{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Inicio","Carga ingresos","Carga gastos","Carga Presupuesto aprobado"],"not_rendered":{"charts":0,"images":4,"macros":1,"external_links":0,"defined_names":0,"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":"Inicio","index":0,"n_rows":6,"n_cols":5,"rows_kept":6,"cut":false,"hidden":false,"merged":[[5,4,5,14]]}
[]
[]
[]
[]
[]
[null,null,null,null,"Plantillas para el cargue de la programación presupuestal de las Empresas Industriales y Comerciales del Estado"]

{"sheet":"Carga ingresos","index":1,"n_rows":18,"n_cols":11,"rows_kept":18,"cut":false,"hidden":true,"merged":[]}
[]
[]
[null,null,null,null,null,null,null,null,null,null,"|"]
[]
["Código del rubro","Recaudo V.A","Aforo V.C","Recaudo V.C","Ingreso Base cero P.V","Cuentas por cobrar V.C","Ingresos P.V","Presupuesto Ingresos próxima vigencia + 1","Presupuesto Ingresos próxima vigencia + 2","Presupuesto Ingresos próxima vigencia + 3"]
[0,0,0,26605000000,0,6895932920,27583731681,0,0,0]
["1-02-5-01-07",26605000000,0,10700000,0,11134014,44536058,0,0,0]
["1-02-5-01-08",0,0,56836139800,0,2103974165,8415896662,0,8415896662,8415896662]
["1-02-5-01-09",26605000000,0,105930160200,0,27375343321,109501373285,27375343321,0,0]
["2-05-01",0,0,14799000000,0,3478939600,13915758400,0,0,0]
[]
[]
["Estructura para plano"]
[{"$f":"A6&$K$3&B6&$K$3&C6&$K$3&D6&$K$3&E6&$K$3&F6&$K$3&G6&$K$3&H6&$K$3&I6&$K$3&J6","v":"0|0|0|26605000000|0|6895932920|27583731681|0|0|0"}]
[{"$f":"A7&$K$3&B7&$K$3&C7&$K$3&D7&$K$3&E7&$K$3&F7&$K$3&G7&$K$3&H7&$K$3&I7&$K$3&J7","v":"1-02-5-01-07|26605000000|0|10700000|0|11134014|44536058|0|0|0"}]
[{"$f":"A8&$K$3&B8&$K$3&C8&$K$3&D8&$K$3&E8&$K$3&F8&$K$3&G8&$K$3&H8&$K$3&I8&$K$3&J8","v":"1-02-5-01-08|0|0|56836139800|0|2103974165|8415896662|0|8415896662|8415896662"}]
[{"$f":"A9&$K$3&B9&$K$3&C9&$K$3&D9&$K$3&E9&$K$3&F9&$K$3&G9&$K$3&H9&$K$3&I9&$K$3&J9","v":"1-02-5-01-09|26605000000|0|105930160200|0|27375343321|109501373285|27375343321|0|0"}]
[{"$f":"A10&$K$3&B10&$K$3&C10&$K$3&D10&$K$3&E10&$K$3&F10&$K$3&G10&$K$3&H10&$K$3&I10&$K$3&J10","v":"2-05-01|0|0|14799000000|0|3478939600|13915758400|0|0|0"}]

{"sheet":"Carga gastos","index":2,"n_rows":51,"n_cols":12,"rows_kept":51,"cut":false,"hidden":true,"merged":[]}
[]
[]
[null,null,null,null,null,null,null,null,null,null,"|"]
[]
[]
[]
[]
["Código del rubro","Ejecución V.A","Apropiación V.C","Compromisos V.C","Pagos V.C","Gastos Causados P.V Base cero","Gastos Causados P.V","Pagos Estimados P.V","Vigencias Futuras P.V","Presupuesto de Gasto PV+1","Presupuesto de Gasto PV+2","Presupuesto de Gasto PV+3"]
["A-01-01-01",2674006480,2842891101,2814743664,2772522509,9746183323,6567735215,2841835572,10000000,2855698184,2883423409,2897286022]
["A-01-01-02",826395897,878589322,869890418,856842062,3410904236,2029744310,878263113,0,882547324,891115744,895399955]
["A-01-01-03",223232686,237331593,234981775,231457048,1826589393,548290808,237243475,0,238400760,240715330,241872616]
["A-02-01-01",51505200,54758160,54216000,53402760,180720000,126504000,54737829,0,55004843,55538870,55805884]
["A-02-02-02-010",71535000,76053000,75300000,74170500,251000000,175700000,76024763,0,76395615,77137320,77508173]
["A-02-02-01-003",20404071,21692750,21477970,21155800,71593232,50115262,21684695,0,21790474,22002032,22107811]
["A-02-02-01-004",811779180,863049444,854504400,841686834,2848348000,1993843600,862729005,0,866937439,875354307,879562742]
["A-02-02-02-006",21145078,22480557,22257977,21924107,74193258,51935281,22472210,0,22581831,22801072,22910692]
["A-02-02-02-007",2799606166,2976423398,2946953859,2902749551,7904888769,6876225672,2975318290,0,2989832038,3018859533,3033373281]
["A-02-02-02-008",0,3177257291,3145799298,3098612309,10485997661,7340198363,3176077616,0,3191570678,3222556801,3238049862]
["A-02-02-02-009",310522682,330134642,326865982,321962992,1089553272,762687290,330012067,0,331621882,334841512,336451327]
["A-03-04-02",26967720,28670945,28387074,27961268,94623580,66236506,28660300,0,28800106,29079719,29219525]
["A-03-10",600894000,638845200,632520000,623032200,2108400000,1475880000,0,0,0,0,0]
["B-05-01-01-003",2251349,2393540,2369842,2334294,7899472,5529630,2392652,0,2404323,2427666,2439338]
["B-05-01-02-006",21074139,22405138,22183305,21850555,73944351,51761046,22396819,0,22506072,22724578,22833830]
["B-05-01-02-007",35010572472,37221766523,36853234181,36300435668,9036000,85990879755,37207946560,0,37389448738,37752453095,37933955273]
["B-05-01-02-008",0,37191492028,36823259434,36270910542,122744198113,85920938679,0,0,0,0,0]
["A-08-01",32542702,34598031,34255476,33741644,114184920,79929444,34585185,0,34753893,35091310,35260018]
["A-08-04",88703400,94305720,93372000,91971420,311240000,217868000,94270706,0,94730563,95650277,96110134]
["D",7322514471,7784989069,7707909969,7592291319,25693033229,17985123260,7782098602,0,7820060059,7895982972,7933944429]
[]
[]
["Estructura para plano"]
[{"$f":"A9&$K$3&B9&$K$3&C9&$K$3&D9&$K$3&E9&$K$3&F9&$K$3&G9&$K$3&H9&$K$3&I9&$K$3&J9&$K$3&K9&$K$3&L9","v":"A-01-01-01|2674006480|2842891101|2814743664|2772522509|9746183323|6567735215|2841835572|10000000|2855698184|2883423409|2897286022"}]
[{"$f":"A10&$K$3&B10&$K$3&C10&$K$3&D10&$K$3&E10&$K$3&F10&$K$3&G10&$K$3&H10&$K$3&I10&$K$3&J10&$K$3&K10&$K$3&L10","v":"A-01-01-02|826395897|878589322|869890418|856842062|3410904236|2029744310|878263113|0|882547324|891115744|895399955"}]
["A-01-01-03|223232686|237331593|234981775|231457048|1826589393|548290808|237243475|0|238400760|240715330|241872616"]
["A-02-01-01|51505200|54758160|54216000|53402760|180720000|126504000|54737829|0|55004843|55538870|55805884"]
["A-02-02-02-010|71535000|76053000|75300000|74170500|251000000|175700000|76024763|0|76395615|77137320|77508173"]
["A-02-02-01-003|20404071|21692750|21477970|21155800|71593232|50115262|21684695|0|21790474|22002032|22107811"]
["A-02-02-01-004|811779180|863049444|854504400|841686834|2848348000|1993843600|862729005|0|866937439|875354307|879562742"]
["A-02-02-02-006|21145078|22480557|22257977|21924107|74193258|51935281|22472210|0|22581831|22801072|22910692"]
["A-02-02-02-007|2799606166|2976423398|2946953859|2902749551|7904888769|6876225672|2975318290|0|2989832038|3018859533|3033373281"]
["A-02-02-02-008|0|3177257291|3145799298|3098612309|10485997661|7340198363|3176077616|0|3191570678|3222556801|3238049862"]
["A-02-02-02-009|310522682|330134642|326865982|321962992|1089553272|762687290|330012067|0|331621882|334841512|336451327"]
["A-03-04-02|26967720|28670945|28387074|27961268|94623580|66236506|28660300|0|28800106|29079719|29219525"]
["A-03-10|600894000|638845200|632520000|623032200|2108400000|1475880000|0|0|0|0|0"]
["B-05-01-01-003|2251349|2393540|2369842|2334294|7899472|5529630|2392652|0|2404323|2427666|2439338"]
["B-05-01-02-006|21074139|22405138|22183305|21850555|73944351|51761046|22396819|0|22506072|22724578|22833830"]
["B-05-01-02-007|35010572472|37221766523|36853234181|36300435668|9036000|85990879755|37207946560|0|37389448738|37752453095|37933955273"]
[{"$f":"A25&$K$3&B25&$K$3&C25&$K$3&D25&$K$3&E25&$K$3&F25&$K$3&G25&$K$3&H25&$K$3&I25&$K$3&J25&$K$3&K25&$K$3&L25","v":"B-05-01-02-008|0|37191492028|36823259434|36270910542|122744198113|85920938679|0|0|0|0|0"}]
["A-08-01|32542702|34598031|34255476|33741644|114184920|79929444|34585185|0|34753893|35091310|35260018"]
["A-08-04|88703400|94305720|93372000|91971420|311240000|217868000|94270706|0|94730563|95650277|96110134"]
["D|7322514471|7784989069|7707909969|7592291319|25693033229|17985123260|7782098602|0|7820060059|7895982972|7933944429"]

{"sheet":"Carga Presupuesto aprobado","index":3,"n_rows":12,"n_cols":4,"rows_kept":12,"cut":false,"hidden":true,"merged":[[4,0,4,4]]}
[]
[]
[]
[]
["CARGA PRESUPUESTO APROBADO"]
["Tipo de ingreso/gasto","Valores aprobados","Fórmula plano","Ejemplo plano"]
[0,50410003800,{"$f":"CONCATENATE(A7,\"|\",B7)","v":"0|50410003800"}]
[1,488624284631,{"$f":"CONCATENATE(A8,\"|\",B8)","v":"1|488624284631"}]
[2,346477273884,"2|346477273884"]
["A",193539468737,"A|193539468737"]
["C",200557395445,"C|200557395445"]
["D",490939943832,"D|490939943832"]