{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["BExRepositorySheet","Balance Presupuestario","Hoja1","Tabla 2","Table","Graph"],"not_rendered":{"charts":1,"images":22,"macros":1,"external_links":1,"defined_names":8,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"BExRepositorySheet","index":0,"n_rows":14,"n_cols":3,"rows_kept":14,"cut":false,"hidden":true,"merged":[]}
[7]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Filter"]

{"sheet":"Balance Presupuestario","index":1,"n_rows":74,"n_cols":30,"rows_kept":74,"cut":false,"hidden":false,"merged":[[45,1,45,2],[46,1,47,1],[71,1,74,1],[61,1,62,1],[63,1,66,1],[48,1,51,1],[56,1,59,1],[60,1,60,2],[43,4,44,4],[43,1,44,1],[43,2,44,2],[2,1,2,5],[3,1,3,5],[4,1,4,5],[6,1,6,5],[7,1,7,2],[43,5,44,5],[22,1,25,1],[29,1,31,1],[37,1,38,1],[40,1,42,1],[43,3,44,3]]}
[null,null,"29/10/2019","","","","Diciembre","Diciembre",{"$error":"#VALUE!"},"Diciembre",{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,null,null,"Diciembre",0,null,0,0,null,null,null,"19",null,"","","Diciembre","Diciembre"]
[]
[null,"GOBIERNO DEL ESTADO DE MICHOACÁN DE OCAMPO"]
[null,"Balance Presupuestario - LDF"]
[null,"Del 1 de Enero al 30 de Septiembre del 2019"]
[]
[null,"(PESOS)"]
[null,"Concepto",null,"Estimado/ Aprobado","Devengado","Recaudado/Pagado "]
[]
[null,null,"A. Ingresos Totales (A = A1+A2+A3)",69556013707,57920979418.739998,57920979418.739998]
[null,null,"A1. Ingresos de Libre Disposición",31347682513,25897745091.220001,25897745091.220001]
[null,null,"A2. Transferencias Federales Etiquetadas",38669858927,32353146890.259998,32353146890.259998]
[null,null,"A3. Financiamiento Neto",-461527733,-329912562.74000001,-329912562.74000001]
[]
[null,null,"B. Egresos Presupuestarios1 (B = B1+B2)",69556013707,51713457285.990005,49983782407.990005]
[null,null,"B1. Gasto No Etiquetado (sin incluir Amortización de la Deuda Pública)",31347682513,21078397491.93,19623989534.380001]
[null,null,"B2. Gasto Etiquetado (sin incluir Amortización de la Deuda Pública) ",38208331194,30635059794.060001,30359792873.610001]
[]
[null,null,"C. Remanentes del Ejercicio Anterior ( C = C1 + C2 )",0,933158358,933158358]
[null,null,"C1. Remanentes de Ingresos de Libre Disposición aplicados en el periodo",0,525467658,525467658]
[null,null,"C2. Remanentes de Transferencias Federales Etiquetadas aplicados en el periodo",0,407690700,407690700]
[]
[null,null,"I. Balance Presupuestario (I = A – B + C)",0,7140680490.7499924,8870355368.7499924]
[]
[null,null,"II. Balance Presupuestario sin Financiamiento Neto (II = I - A3)",461527733,7470593053.4899921,9200267931.4899921]
[]
[null,null,"III. Balance Presupuestario sin Financiamiento Neto y sin Remanentes del Ejercicio Anterior (III= II - C)",461527733,6537434695.4899921,8267109573.4899921]
[]
[]
[null,null,"E. Intereses, Comisiones y Gastos de la Deuda (E = E1+E2)",2373239566,1485459416.8399999,1482868605.0899999]
[null,null,"E1. Intereses, Comisiones y Gastos de la Deuda con Gasto No Etiquetado",982375186,480720124.95999998,478129313.20999998]
[null,null,"E2. Intereses, Comisiones y Gastos de la Deuda con Gasto Etiquetado",1390864380,1004739291.88,1004739291.88]
[]
[null,null,"IV. Balance Primario (IV = III + E)",2834767299,8022894112.3299923,9749978178.5799923]
[]
[]
[null,null,"F. Financiamiento (F = F1 + F2)",0,0,0]
[null,null,"F1. Financiamiento con Fuente de Pago de Ingresos de Libre Disposición",0,0,0]
[null,null,"F2. Financiamiento con Fuente de Pago de Transferencias Federales Etiquetadas",0,0,0]
[]
[null,null,"G. Amortización de la Deuda (G = G1 + G2)",461527733,329912562.74000001,329912562.74000001]
[null,null,"G1. Amortización de la Deuda Pública con Gasto No Etiquetado",0,275423.08,275423.08]
[null,null,"G2. Amortización de la Deuda Pública con Gasto Etiquetado",461527733,329637139.66000003,329637139.66000003]
[null,null,"A3. Financiamiento Neto (A3 = F – G )",-461527733,-329912562.74000001,-329912562.74000001]
[]
[]
[null,null,"A1. Ingresos de Libre Disposición ",31347682513,25897745091.220001,25897745091.220001]
[]
[null,null,"A3.1 Financiamiento Neto con Fuente de Pago de Ingresos de Libre Disposición (A3.1 = F1 – G1)",0,-275423.08,-275423.08]
[null,null,"F1. Financiamiento con Fuente de Pago de Ingresos de Libre Disposición",0,0,0]
[null,null,"G1. Amortización de la Deuda Pública con Gasto No Etiquetado",0,275423.08,275423.08]
[]
[null,null,"B1. Gasto No Etiquetado (sin incluir Amortización de la Deuda Pública)",31347682513,21078397491.93,19623989534.380001]
[]
[null,null,"C1. Remanentes de Ingresos de Libre Disposición aplicados en el periodo",0,525467658,525467658]
[]
[null,null,"V. Balance Presupuestario de Recursos Disponibles (V = A1 + A3.1 – B 1 + C1)",0,5344539834.2099991,6798947791.7599983]
[]
[null,null,"VI. Balance Presupuestario de Recursos Disponibles sin Financiamiento Neto (VI = V – A3.1)",0,5344815257.289999,6799223214.8399982]
[]
[]
[null,null,"A2. Transferencias Federales Etiquetadas",38669858927,32353146890.259998,32353146890.259998]
[]
[null,null,"A3.2 Financiamiento Neto con Fuente de Pago de Transferencias Federales Etiquetadas                        (A3.2 = F2 – G2)",-461527733,-329637139.66000003,-329637139.66000003]
[null,null,"F2. Financiamiento con Fuente de Pago de Transferencias Federales Etiquetadas",0,0,0]
[null,null,"G2. Amortización de la Deuda Pública con Gasto Etiquetado",461527733,329637139.66000003,329637139.66000003]
[]
[null,null,"B2. Gasto Etiquetado (sin incluir Amortización de la Deuda Pública",38208331194,30635059794.060001,30359792873.610001]
[]
[null,null,"C2. Remanentes de Transferencias Federales Etiquetadas aplicados en el periodo",0,407690700,407690700]
[]
[null,null,"VII. Balance Presupuestario de Recursos Etiquetados (VII = A2 + A3.2 – B2 + C2)",0,1796140656.5399971,2071407576.9899979]
[]
[null,null,"VIII. Balance Presupuestario de Recursos Etiquetados sin Financiamiento Neto (VIII = VII – A3.2)",461527733,2125777796.1999972,2401044716.6499977]

{"sheet":"Hoja1","index":2,"n_rows":22,"n_cols":9,"rows_kept":22,"cut":false,"hidden":true,"merged":[]}
[]
[]
[]
[null,"01-ENE..09-SEP",null,"ENE","Enero",1,"Del 1 de Enero al 30 de Junio del 2019"]
[null,null,null,"FEB","Febrero",2]
[null,"2019",null,"MAR","Marzo",3]
[null,null,null,"ABR","Abril",4]
[null,"Mes 1",{"$f":"+VLOOKUP(MID($B$4,4,3),$D$4:$E$19,2,FALSE)","v":"Enero"},"MAY","Mayo",5,null,{"$f":"+LEFT($B$4,1)","v":"0"},{"$f":"+VLOOKUP(H8,$D$4:$E$19,2,FALSE)","v":{"$error":"#N/A"}}]
[null,"Mes 2",{"$f":"+VLOOKUP(MID($B$4,12,3),$D$4:$E$19,2,FALSE)","v":"Septiembre"},"JUN","Junio",6]
[null,null,null,"JUL","Julio",7]
[null,null,{"$f":"+DATE(B6,+VLOOKUP(C9,$E$4:$F$15,2,FALSE)+1,0)","v":"2019-09-30"},"AGO","Agosto",8]
[null,null,null,"SEP","Septiembre",9]
[null,null,null,"OCT","Octubre",10]
[null,"Días",{"$f":"+DAY(C11)","v":30},"NOV","Noviembre",11]
[null,null,null,"DIC","Diciembre",12]
[null,null,null,"DIC","Diciembre",12]
[null,null,null,"DIC","Diciembre",12]
[null,null,null,"DIC","Diciembre",12]
[null,null,null,"DIC","Diciembre",12]
[]
[]
[null,{"$f":"+\"Del 1 de \"&C8&\" al \"&C14&\" de \"&C9&\" del \"&B6","v":"Del 1 de Enero al 30 de Septiembre del 2019"}]

{"sheet":"Tabla 2","index":3,"n_rows":8,"n_cols":6,"rows_kept":8,"cut":false,"hidden":true,"merged":[]}
[]
[]
[]
[]
[]
[null,null,null,"Table"]
[null,null,null,"","RATIO 1","RATIO 2"]
[null,null,null,"    Derechos a Recibir Efectivo o Equivalentes",2890381899.8000002,0]

{"sheet":"Table","index":4,"n_rows":55,"n_cols":13,"rows_kept":55,"cut":false,"hidden":true,"merged":[]}
[null,null,null,null,null,"4.  Balance Presupuestario"]
[null,null,null,null,null,null,null,"Autor","ADVJYNOQUIO",null,"Actualidad de datos","02/05/2019 15:17:23"]
[]
[]
[null,null,null,null,null,null,"Information"]
[null,null,null,null,null,null,"Autor","ADVJYNOQUIO",null,"Últ.actual.pantalla","29/10/2019 16:22:09"]
[null,null,null,null,null,null,"Usuario actual","GRPAARROYO",null,"Fe.clave","29/10/2019"]
[null,null,null,null,null,null,"Modificado por","ADVIVIEYRA",null,"Hora de modificación","28/10/2019 19:05:49"]
[null,null,null,null,null,null,"InfoSitio","ZVRL_MP01",null,"Actualidad de datos","02/05/2019 15:17:23"]
[null,null,null,null,null,null,"Nombre técnico query","ZFM_VRL_MP01_Q040",null,"Actualidad datos (fecha)","02/05/2019"]
[null,null,null,null,null,null,"Descripción query","4.  Balance Presupuestario",null,"Actualidad datos (fecha)","15:17:23"]
[]
[]
[null,null,"Filter",null,null,null,"Table"]
[null,null,"0CMMT_ITEM__ZCAPITUL","",null,null,"","[E] Aprobado","[E] Devengado","[E] Pagado","[I] Estimado","[I] Devengado","[I] Recaudado"]
[null,null,"0CMMT_ITEM__ZCONCEPT","",null,null,"A. Ingresos Totales (A = A1+A2+A3)",null,-57125413692.57,-57125413692.57,70017541440,58250891981.480003,58250891981.480003]
[null,null,"0CMMT_ITEM__ZINGRESO","",null,null,"A1. Ingresos de Libre Disposición",null,-25560790906.209999,-25560790906.209999,31347682513,25897745091.220001,25897745091.220001]
[null,null,"0CMMT_ITEM__ZRUBRO","",null,null,"A2. Transferencias Federales Etiquetadas",null,-31564622786.360001,-31564622786.360001,38669858927,32353146890.259998,32353146890.259998]
[null,null,"0FUND__ZETIQUETA","",null,null,"A3. Financiamiento Neto",-461527733,-329912562.74000001,-329912562.74000001,0,80834800.739999995,329912562.74000001]
[null,null,"Clase de presupuesto","",null,null,"B. Egresos Presupuestarios1 (B = B1+B2).",69556013707,51713457285.989998,49983782407.989998,0,-50556731180.32,-49401916253.209999]
[null,null,"Compr./Real: Detalle","",null,null,"B1. Gasto No Etiquetado (sin incluir Amortización de la Deud",31347682513,21078397491.93,19623989534.380001,0,-20686569628.889999,-19317853753.279999]
[null,null,"Cuenta de mayor","",null,null,"B2. Gasto Etiquetado (sin incluir Amortización de la Deuda P",38208331194,30635059794.060001,30359792873.610001,0,-29870161551.43,-30084062499.93]
[null,null,"Ejercicio/Período","",null,null,"C. Remanentes del Ejercicio Anterior ( C = C1 + C2 ).",0,0,0,0,0,0]
[null,null,"Estruct.",",A. Ingresos Totales (A = A1+A2+A3),A1. Ingresos de Libre Disposición,A2. Transferencias Federales Etiquetadas...",null,null,"C1. Remanentes de Ingresos de Libre Disposición aplicados en",0,0,0,0,0,0]
[null,null,"Fondos","",null,null,"C2. Remanentes de Transferencias Federales Etiquetadas aplic",0,0,0,0,0,0]
[null,null,"ID petición","",null,null,"I. Balance Presupuestario (I = A – B + C).",-69556013707,-108838870978.56,-107109196100.56,70017541440,108807623161.8,107652808234.69]
[null,null,"InfoSitio","",null,null,"II. Balance Presupuestario sin Financ. Neto (II = I - A3).",-69556013707,-108838870978.56,-107109196100.56,70017541440,108807623161.8,107652808234.69]
[null,null,"Pos.presupuestaria","",null,null,"III. Balan. Presup. sin Financ. Neto y sin Reman. (III=II-C)",-69556013707,-108838870978.56,-107109196100.56,70017541440,108807623161.8,107652808234.69]
[null,null,"Ratios","",null,null,"E. Intereses, Comisiones y Gastos de la Deuda (E = E1+E2).",2373239566,1485459416.8399999,1482868605.0899999,0,-390108451.27999997,-1482801528.01]
[null,null,null,null,null,null,"E1. Inte., Com. y Gastos de la Deuda con Gasto No Etiquetado",982375186,480720124.95999998,478129313.20999998,0,-134561763.71000001,-478062236.13]
[null,null,null,null,null,null,"E2. Inte., Com. y Gastos de la Deuda con Gasto Etiquetado",1390864380,1004739291.88,1004739291.88,0,-255546687.56999999,-1004739291.88]
[null,null,null,null,null,null,"IV. Balance Primario (IV = III + E).",-67182774141,-107353411561.72,-105626327495.47,70017541440,108417514710.52,106170006706.67999]
[null,null,null,null,null,null,"F. Financiamiento (F = F1 + F2).",null,0,0,0,0,0]
[null,null,null,null,null,null,"F1. Financ, con Fuente de Pago de Ingresos de Libre Dispos.",null,0,0,0,0,0]
[null,null,null,null,null,null,"F2. Financiamiento con Fuente de Pago de Transf. Feder. Etiq",null,0,0,0,0,0]
[null,null,null,null,null,null,"G. Amortización de la Deuda (G = G1 + G2).",461527733,329912562.74000001,329912562.74000001,0,-80834800.739999995,-329912562.74000001]
[null,null,null,null,null,null,"G1. Amortización de la Deuda Pública con Gasto No Etiquetado",null,275423.08,275423.08,0,-275423.08,-275423.08]
[null,null,null,null,null,null,"G2. Amortización de la Deuda Pública con Gasto Etiquetado",461527733,329637139.66000003,329637139.66000003,0,-80559377.659999996,-329637139.66000003]
[null,null,null,null,null,null,"A3. Financiamiento Neto (A3 = F – G )",-461527733,-329912562.74000001,-329912562.74000001,0,80834800.739999995,329912562.74000001]
[null,null,null,null,null,null,"A1. Ingresos de Libre Disposición.",null,-25560790906.209999,-25560790906.209999,31347682513,25897745091.220001,25897745091.220001]
[null,null,null,null,null,null,"A3.1 Financ. Neto Fuente Pago Ingr. Libre Dispo(A3. =F1-G1).",null,-275423.08,-275423.08,0,275423.08,275423.08]
[null,null,null,null,null,null,"F1. Financ, con Fuente de Pago de Ingresos de Libre Dispos.",null,0,0,0,0,0]
[null,null,null,null,null,null,"G1. Amortización de la Deuda Pública con Gasto No Etiquetado",null,275423.08,275423.08,0,-275423.08,-275423.08]
[null,null,null,null,null,null,"B1. Gasto No Etiquetado (sin incluir Amortización de la Deu.",31347682513,21078397491.93,19623989534.380001,0,-20686569628.889999,-19317853753.279999]
[null,null,null,null,null,null,"C1. Remanentes de Ingresos de Libre Disposición aplicados e.",0,0,0,0,0,0]
[null,null,null,null,null,null,"V. Balance Presup. de Recur. Disp.  (V=A1+ A3.1–B1+C1).",-31347682513,-46639463821.220001,-45185055863.669998,31347682513,46584590143.190002,45215874267.580002]
[null,null,null,null,null,null,"VI. Balance Presup. de Rec. Disp. sin Finan. Neto(VI=V–A3.1-",-31347682513,-46639188398.139999,-45184780440.589996,31347682513,46584314720.110001,45215598844.5]
[null,null,null,null,null,null,"A2. Transferencias Federales Etiquetadas.",null,-31564622786.360001,-31564622786.360001,38669858927,32353146890.259998,32353146890.259998]
[null,null,null,null,null,null,"A3.2 Fin. Neto con Fte. de Pago de Transf. Fed. Etiq. (A3.2.",-461527733,-329637139.66000003,-329637139.66000003,0,80559377.659999996,329637139.66000003]
[null,null,null,null,null,null,"F2. Financiamiento con Fuente de Pago de Transf. Feder. Eti.",null,0,0,0,0,0]
[null,null,null,null,null,null,"G2. Amortización de la Deuda Pública con Gasto Etiquetado.",461527733,329637139.66000003,329637139.66000003,0,-80559377.659999996,-329637139.66000003]
[null,null,null,null,null,null,"B2. Gasto Etiquetado (sin incluir Amortización de la Deuda .",38208331194,30635059794.060001,30359792873.610001,0,-29870161551.43,-30084062499.93]
[null,null,null,null,null,null,"C2. Remanentes de Transferencias Federales Etiqueta.",0,0,0,0,0,0]
[null,null,null,null,null,null,"VII. Bal. Presup. de Rec.Etiq. (VII = A2 + A3.2 – B2 + C2).",-38669858927,-62529319720.080002,-62254052799.629997,38669858927,62303867819.349998,62766846529.849998]
[null,null,null,null,null,null,"VIII. Bal.Pres. de Rec. Etiq. sin Fin. Neto (VIII=VII–A3.2)",-38208331194,-62199682580.419998,-61924415659.970001,38669858927,62223308441.690002,62437209390.190002]

{"sheet":"Graph","index":5,"n_rows":48,"n_cols":12,"rows_kept":48,"cut":false,"hidden":true,"merged":[]}
[null,null,null,null,null,null,null,"FEP8Qry3"]
[null,null,null,null,null,null,null,"Autor","ADVJYNOQUIO",null,"Actualidad datos (fecha)","15:17:23"]
[]
[]
[null,null,null,null,null,null,"Information"]
[null,null,null,null,null,null,"Autor","ADVJYNOQUIO",null,"Últ.actual.pantalla","29/10/2019 16:22:09"]
[null,null,null,null,null,null,"Usuario actual","GRPAARROYO",null,"Fe.clave","29/10/2019"]
[null,null,null,null,null,null,"Modificado por","ADVIVIEYRA",null,"Hora de modificación","28/10/2019 19:05:49"]
[null,null,null,null,null,null,"InfoSitio","ZVRL_MP01",null,"Actualidad de datos","02/05/2019 15:17:23"]
[null,null,null,null,null,null,"Nombre técnico query","ZFM_VRL_MP01_Q040",null,"Actualidad datos (fecha)","02/05/2019"]
[null,null,null,null,null,null,"Descripción query","4.  Balance Presupuestario",null,"Actualidad datos (fecha)","15:17:23"]
[]
[]
[null,null,"Filter",null,null," "]
[null,null,"0CMMT_ITEM__ZCAPITUL","",null," "]
[null,null,"0CMMT_ITEM__ZCONCEPT","",null," "]
[null,null,"0CMMT_ITEM__ZINGRESO","",null," "]
[null,null,"0CMMT_ITEM__ZRUBRO","",null," "]
[null,null,"0FUND__ZETIQUETA","",null," "]
[null,null,"Clase de presupuesto","",null," "]
[null,null,"Compr./Real: Detalle","",null," "]
[null,null,"Cuenta de mayor","",null," "]
[null,null,"Ejercicio/Período","",null," "]
[null,null,"Estruct.",",A. Ingresos Totales (A = A1+A2+A3),A1. Ingresos de Libre Disposición,A2. Transferencias Federales Etiquetadas...",null," "]
[null,null,"Fondos","",null," "]
[null,null,"ID petición","",null," "]
[null,null,"InfoSitio","",null," "]
[null,null,"Pos.presupuestaria","",null," "]
[null,null,"Ratios","",null," "]
[null,null,null,null,null," "]
[null,null,null,null,null," "]
[null,null,null,null,null," "]
[null,null,null,null,null," "]
[null,null,null,null,null," "]
[null,null,null,null,null," "]
[null,null,null,null,null," "]
[null,null,null,null,null," "]
[null,null,null,null,null," "]
[null,null,null,null,null," "]
[null,null,null,null,null," "]
[null,null,null,null,null," "]
[null,null,null,null,null," "]
[null,null,null,null,null," "]
[null,null,null,null,null," "]
[null,null,null,null,null," "]
[null,null,null,null,null," "]
[null,null,null,null,null," "]
[null,null,null,null,null," "]