{"text_format":"2","workbook":"xlsx","n_sheets":3,"sheets":["CALLAO-2018","VENTANILLA-2018","Gráfico1"],"not_rendered":{"charts":2,"images":1,"macros":0,"external_links":1,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[{"sheet":"Gráfico1","index":2,"reason":"not_a_worksheet"}],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","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":"CALLAO-2018","index":0,"n_rows":61,"n_cols":28,"rows_kept":61,"cut":false,"hidden":false,"merged":[[60,0,60,12],[15,0,15,4],[24,0,24,4],[40,0,40,4],[7,6,8,6],[7,19,7,24],[41,0,41,4],[7,0,8,0],[7,1,8,1],[7,2,8,2],[7,3,8,3],[7,4,8,4],[7,5,8,5]]}
[]
[]
[]
[]
[]
["REPORTE DE EJECUCIÓN PRESUPUESTAL DEL PP PTCD 0051 (ámbito educativo y familiar): POR GENÉRICA DE GASTO 2.3 Y 2.6, ESPECÍFICA DE GASTO Y POR TODA FUENTE DE FINACIAMIENTO (año 2018)"]
["AL 31 /05/18"]
["UNIDAD EJECUTORA","ACTIVIDAD","FUENTE DE FINANCIAMIENTO","GENÉRICA DE GASTO","ESPECÍFICA DE GASTO","PIA","PIM",{"$nulls":12},"SIAF"]
[{"$nulls":7},"m01","m02","m03","m04","m05","m06","m07","m08","m09","m10","m11","m12","CERTIFICACIÓN ","COMPROMISO ANUAL","EJECUCION","% CERTIFICACIÓN SIAF/PIM","% COMPROMISO ANUAL SIAF/PIM","% EJECUCIÓN"]
["300","5005229","1",23,"23 1 5 1 2",0,6500,0,0,0,0,3046,0,0,0,0,0,0,0,{"$f":"+SUM(H10:S10)","v":3046},3046,3046,{"$f":"+T10/G10","v":0.4686153846153846},{"$f":"+U10/G10","v":0.4686153846153846},{"$f":"+V10/G10","v":0.4686153846153846}]
["300","5005229","1",23,"23 1 9 1 2",0,13000,0,0,0,0,11214.21,0,0,0,0,0,0,0,11214.21,11214.21,0,{"$f":"+T11/G11","v":0.86263153846153839},{"$f":"+U11/G11","v":0.86263153846153839},{"$f":"+V11/G11","v":0}]
["300","5005229","1",23,"23 2 1 299",0,60345,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["300","5005229","1",23,"23 2 2 4 4",0,13000,0,0,0,12950,0,0,0,0,0,0,0,0,12950,12950,12950,0.99615384615384617,0.99615384615384617,0.99615384615384617]
["300","5005229","1",23,"23 2 7 3 2",0,7000,0,0,0,0,3000,0,0,0,0,0,0,0,3000,3000,0,0.42857142857142855,0.42857142857142855,0]
["300","5005229","1",23,"23 2 71199",200000,98655,30000,0,0,0,39284,0,0,0,0,0,0,0,69284,69284,12000,0.7022857432466677,0.7022857432466677,0.12163600425726015]
["TOTAL 23  AMBITO FAM RO ",{"$nulls":4},{"$f":"SUM(F10:F15)","v":200000},198500,30000,0,0,12950,56544.21,0,0,0,0,0,0,0,99494.209999999992,99494.209999999992,27996,0.50123027707808565,0.50123027707808565,0.14103778337531486]
["300","5005230","1",23,"23 1 5 1 2",0,13000,0,0,0,8027.92,0,0,0,0,0,0,0,0,8027.92,8027.92,8027.92,0.61753230769230771,0.61753230769230771,0.61753230769230771]
["300","5005230","1",23,"23 2 1 299",0,15100,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["300","5005230","1",23,"23 2 2 4 4",0,3200,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["300","5005230","1",23,"23 2 4 1 5",0,16000,0,0,0,9500,0,0,0,0,0,0,0,0,9500,9500,9500,0.59375,0.59375,0.59375]
["300","5005230","1",23,"23 2 7 299",0,13840,0,0,0,3460,6920,0,0,0,0,0,0,0,10380,10380,10380,0.75,0.75,0.75]
["300","5005230","1",23,"23 2 71199",571349,161209,59000,7900,17760,31862.28,4046,0,0,0,0,0,0,0,120568.28,120568.28,68367.28,0.74790042739549278,0.74790042739549278,0.42409096266337487]
["300","5005230","1",23,"23 2 8 1 1",307496,645496,307496,0,0,0,0,0,0,0,0,0,0,0,307496,307496,212245.95,0.47637165838363055,0.47637165838363055,0.32881063554228068]
["300","5005230","1",23,"23 2 8 1 2",11898,20898,11898,0,0,0,0,0,0,0,0,0,0,0,11898,11898,7922,0.56933677863910426,0.56933677863910426,0.37907933773566849]
["TOTAL 23 AMBITO ERDUCATIVO RO",{"$nulls":4},{"$f":"SUM(F17:F24)","v":890743},{"$f":"SUM(G17:G24)","v":888743},378394,7900,17760,52850.2,10966,0,0,0,0,0,0,0,467870.2,467870.2,316443.15000000002,0.52644037702687951,0.52644037702687951,0.35605698160210547]
["300","5005230","4",23,"23 1 5 1 1",0,15000,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["300","5005230","4",23,"23 1 5 1 2",0,55000,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["300","5005230","4",23,"23 1 5 3 1",0,3800,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["300","5005230","4",23,"23 1 9 1 2",0,73316,0,0,5708.71,29291.82,225.43,0,0,0,0,0,0,0,35225.96,35225.96,35000.53,0.48046756506083255,0.48046756506083255,0.47739279284194447]
["300","5005230","4",23,"23 111 1 1",0,3534,0,0,0,2700,0,0,0,0,0,0,0,0,2700,2700,2700,0.76400679117147707,0.76400679117147707,0.76400679117147707]
["300","5005230","4",23,"23 2 2 4 4",0,201369,0,0,26550,3611,1200,0,0,0,0,0,0,0,31361,31361,31361,0.15573896677244262,0.15573896677244262,0.15573896677244262]
["300","5005230","4",23,"23 2 4 1 5",0,6000,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["300","5005230","4",23,"23 2 7 299",0,72660,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["300","5005230","4",23,"23 2 71199",0,479433,0,0,17662.599999999999,73970.399999999994,10950,0,0,0,0,0,0,0,102583,102583,102583,0.2139673322445472,0.2139673322445472,0.2139673322445472]
["300","5005230","4",26,"26 3 2 1 1",0,18000,0,0,0,4515.33,0,0,0,0,0,0,0,0,4515.33,4515.33,4515.33,0.25085166666666664,0.25085166666666664,0.25085166666666664]
["300","5005230","4",26,"26 3 2 1 2",0,12000,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["300","5005230","4",26,"26 3 2 2 1",0,9000,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["300","5005230","4",26,"26 3 2 2 2",0,3000,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["300","5005230","4",26,"26 3 2 3 1",0,102060,0,0,0,6900,12741.17,0,0,0,0,0,0,0,19641.169999999998,19641.169999999998,19641.169999999998,0.19244728591024884,0.19244728591024884,0.19244728591024884,null,"CALLAO",24.71]
["300","5005230","4",26,"26 3 2 3 3",0,44720,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,"VENTANILLA",87.45]
["TOTAL 23 Y 26 AMBITO EDUCATIVO DY T ",{"$nulls":4},{"$f":"SUM(F26:F40)","v":0},{"$f":"SUM(G26:G40)","v":1098892},0,0,49921.31,120988.55,25116.6,0,0,0,0,0,0,0,196026.45999999996,196026.45999999996,195801.02999999997,0.17838555563240061,0.17838555563240061,0.17818041263381659]
["TOTAL",{"$nulls":4},{"$f":"SUM(F10:F15,F17:F24,F26:F40)","v":1090743},{"$f":"SUM(G10:G15,G17:G24,G26:G40)","v":2186135},{"$f":"SUM(H10:H15,H17:H24,H26:H40)","v":408394},7900,67681.31,186788.74999999997,92626.809999999983,0,0,0,0,0,0,0,763390.86999999988,763390.86999999988,540240.18000000005,{"$f":"+T42/G42","v":0.34919658209579918},{"$f":"+U42/G42","v":0.34919658209579918},{"$f":"+V42/G42","v":0.24712114302181706}]
[]
["Fuente: REPORTE SIAF 2018 AL 31 05 18"]
["Análisis:"]
["Callao - DREC"]
["En las especificas de gasto 2.3  por la fuente de financiamiento de recursos ordinarios  presenta una ejecucion  de S/27,996 que representa una ejecucion del  14.10%  en el ambito familiar  por concepto de adquisicion de utiles y materiales de oficina  "]
[]
["En las especificas de gasto 2.3  por la fuente de financiamiento de recursos ordinarios  presenta una ejecucion  de S/316,443.15 que representa una ejecucion del  35.61% de ejecucion en el ambito educativo  por concepto de adquisicion de utiles y materiales de oficina  "]
[]
["En las especificas de gasto 2.3 Y  2.6  por la fuente de financiamiento de Donaciones y transferencias presenta una ejecucion  de S/195,801.03 que representa una ejecucion del  17.82 % de ejecucion en el ambito educativo  por concepto de adquisicion de utiles y materiales de oficina  "]
{"$rows_empty":9}
["Nota: Elaborar un gráfico en el que se visualice el porcentaje de ejecución presupuestal del programa presupuestal: Por toda fuente de financiamiento, genérica de gasto, por UE y total del programa presupuestal."]

{"sheet":"VENTANILLA-2018","index":1,"n_rows":39,"n_cols":19,"rows_kept":39,"cut":false,"hidden":false,"merged":[[38,2,38,14],[1,2,1,13],[3,2,4,2],[3,3,4,3],[3,4,4,4],[3,5,4,5],[3,6,4,6],[3,7,4,7],[3,8,4,8],[3,9,3,14]]}
[]
[null,null,"REPORTE DE EJECUCIÓN PRESUPUESTAL DEL PP PTCD 0051 (ámbito educativo y familiar): POR GENÉRICA DE GASTO 2.3 Y 2.6, ESPECÍFICA DE GASTO Y POR TODA FUENTE DE FINACIAMIENTO (año 2018)"]
[]
[null,null,"UNIDAD EJECUTORA","ACTIVIDAD","FUENTE DE FINANCIAMIENTO","GENÉRICA DE GASTO","ESPECÍFICA DE GASTO","PIA","PIM                  ","SIAF"]
[{"$nulls":9},"CERTIFICACIÓN ","COMPROMISO ANUAL ","EJECUCIÓN","% CERTIFICACIÓN SIAF/PIM","% COMPROMISO ANUAL SIAF/PIM","% EJECUCIÓN"]
[null,null,"302 EDUCACION VENTANILA","5005229 PREVENCION CONSUMO DE DROGAS  EN EL AMBITO FAMILIAR","1 RECURSOS ORDINARIOS","23 BIENES Y SERVICIOS","23.15.12 Papeleria ,utiles",0,1500,1500,1500,1500,{"$f":"J6/I6","v":1},{"$f":"K6/I6","v":1},{"$f":"L6/I6","v":1}]
[null,null,"302 EDUCACION VENTANILA","50052230PREVENCION CONSUMO DE DROGAS  EN EL AMBITO EDUCATIVO","1 RECURSOS ORDINARIOS","23 BIENES Y SERVICIOS","23.15.12 Papeleria ,utiles",0,2000,1999.78,1999.78,1999.78,0.99988999999999995,0.99988999999999995,0.99988999999999995]
[null,null,null,"TOTAL FUENTE 1",null,null,null,{"$f":"+H6+H7","v":0},{"$f":"+I6+I7","v":3500},{"$f":"+J6+J7","v":3499.7799999999997},3499.7799999999997,3499.7799999999997,0.99993714285714275,0.99993714285714275,0.99993714285714275]
[null,null,"302 EDUCACION VENTANILLA","5005230 PREVENCION DEL CONSUMO DE DROGAS EN EL AMBITO EDUCATIVO","4 DONACIONES Y TRANSFERENCIAS","23 BIENES Y SERVICIOS","23.19.12 Material Didactico",0,10000,10000,10000,10000,1,1,1,null,"AMBITO FAMILIAR RO"]
[{"$nulls":6},"23.1.11.11 Para edificios y estructuras",0,2000,2000,2000,2000,1,1,1]
[{"$nulls":6},"23.22.44 Servicio de Impresiones",0,25000,25000,25000,25000,1,1,1]
[{"$nulls":6},"23.27.11.99 Servicios Diversos",0,41000,26500,26500,26500,0.64634146341463417,0.64634146341463417,0.64634146341463417]
[null,null,null,"SUB TOTAL FUENTE 4",null,null,null,{"$f":"+H9+H10+H11+H12","v":0},{"$f":"+I9+I10+I11+I12","v":78000},63500,63500,63500,0.8141025641025641,0.8141025641025641,0.8141025641025641,null,{"$f":"SUM(L9:L13)","v":127000},"2.3 ROAMB FAM",{"$f":"SUM(Q13)","v":127000}]
[null,null,"302 EDUCACION VENTANILLA","5005230 PREVENCION DEL CONSUMO DE DROGAS EN EL AMBITO EDUCATIVO","4 DONACIONES Y TRANSFERENCIAS","26 ADQUISICION DE ACTIVOS NO FINANCIEROS","26.32.21 Maquinas y Equipos",0,11500,11500,11500,11500,1,1,1,null,"AMBITO EDUCATIVO RO"]
[{"$nulls":6},"26.32.31 Equipos computacionales y perifericos",0,8500,8500,8500,8500,1,1,1]
[{"$nulls":6},"26.32.23 Equipos de telecomunicaciones",0,14000,14000,14000,14000,1,1,1]
[null,null,null,"SUB TOTAL FUENTE 4",null,null,null,{"$f":"+H14+H15+H16","v":0},{"$f":"+I14+I15+I16","v":34000},34000,34000,34000,1,1,1]
[null,null,null,"TOTAL FUENTE 4",null,null,null,{"$f":"+H13+H17","v":0},{"$f":"+I13+I17","v":112000},97500,97500,97500,0.8705357142857143,0.8705357142857143,0.8705357142857143]
[]
[null,null,null,"TOTAL POR TODA FUENTE FINANCIAMIENTO",null,null,null,{"$f":"+H8+H18","v":0},{"$f":"+I8+I18","v":115500},100999.78,100999.78,100999.78,0.87445696969696973,0.87445696969696973,0.87445696969696973]
[]
[null,null,"Fuente: REPORTE SIAF 2018"]
[null,null,"Análisis:"]
[null,null,"UGEL - VENTANILLA",{"$nulls":13},{"$f":"SUM(L24:L24)","v":0},"2.3 AMB EDUC DYT CAP"]
[null,null,"En las especificas de gasto 2.3  por la fuente de financiamiento de recursos ordinarios  presenta una ejecucion  de S/1,500 que representa una ejecucion del  100 %  en el ambito familiar  por concepto de adquisicion de utiles y materiales de oficina  "]
[]
[null,null,"En las especificas de gasto 2.3  por la fuente de financiamiento de recursos ordinarios  presenta una ejecucion  de S/1999.78 que representa una ejecucion del  100 % de ejecucion en el ambito educativo  por concepto de adquisicion de utiles y materiales de oficina  "]
[]
[null,null,"En las especificas de gasto 2.6  por la fuente de financiamiento de Donaciones y transferencias presenta una ejecucion  de S/97,500 que representa una ejecucion del  87.45 % de ejecucion en el ambito educativo  por concepto de adquisicion de utiles y materiales de oficina  "]
{"$rows_empty":9}
[null,null,"Nota: Elaborar un gráfico en el que se visualice el porcentaje de ejecución presupuestal del programa presupuestal: Por toda fuente de financiamiento, genérica de gasto, por UE y total del programa presupuestal."]