{"text_format":"2","workbook":"xlsx","n_sheets":5,"sheets":["HOJ","CALLAO AL 28-06","VENTANILLAal 28-06","CONSOLIDADO REGIONALal 28 06","Gráfico1"],"not_rendered":{"charts":2,"images":2,"macros":0,"external_links":1,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[{"sheet":"Gráfico1","index":4,"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":"HOJ","index":0,"n_rows":35,"n_cols":17,"rows_kept":35,"cut":false,"hidden":true,"merged":[[1,7,2,7],[1,8,1,13],[33,1,33,5],[1,1,2,1],[1,2,2,2],[1,3,2,3],[1,4,2,4],[1,5,2,5],[1,6,2,6]]}
[]
[null,"UNIDAD EJECUTORA","ACTIVIDAD","FUENTE DE FINANCIAMIENTO","GENÉRICA DE GASTO","ESPECÍFICA DE GASTO","PIA","PIM                  ","SIAF"]
[{"$nulls":8},"CERTIFICACIÓN ","COMPROMISO ANUAL ","EJECUCIÓN","% CERTIFICACIÓN SIAF/PIM","% COMPROMISO ANUAL SIAF/PIM","% EJECUCIÓN"]
[null,"300","5005229","1",23,"23 1 5 1 2",0,6500,3046,3046,3046,{"$f":"+I4/H4","v":0.4686153846153846},{"$f":"+J4/H4","v":0.4686153846153846},{"$f":"+K4/H4","v":0.4686153846153846}]
[null,"300","5005229","1",23,"23 1 9 1 2",0,13000,11214.21,11214.21,10891.57,{"$f":"+I5/H5","v":0.86263153846153839},{"$f":"+J5/H5","v":0.86263153846153839},{"$f":"+K5/H5","v":0.83781307692307694}]
[null,"300","5005229","1",23,"23 2 1 299",0,60345,0,0,0,0,0,0]
[null,"300","5005229","1",23,"23 2 2 4 4",0,13000,12950,12950,12950,0.99615384615384617,0.99615384615384617,0.99615384615384617]
[null,"300","5005229","1",23,"23 2 7 3 2",0,3000,3000,3000,0,1,1,0]
[null,"300","5005229","1",23,"23 2 71199",200000,102655,86592.4,86592.4,49002.400000000001,0.84352832302372016,0.84352832302372016,0.47735034825386002]
[null,"300","5005230","1",23,"23 1 5 1 2",0,13000,8027.92,8027.92,8027.92,0.61753230769230771,0.61753230769230771,0.61753230769230771]
[null,"300","5005230","1",23,"23 2 1 299",0,15100,0,0,0,0,0,0]
[null,"300","5005230","1",23,"23 2 2 4 4",0,3200,0,0,0,0,0,0]
[null,"300","5005230","1",23,"23 2 4 1 5",0,16000,12300,12300,12300,0.76875000000000004,0.76875000000000004,0.76875000000000004]
[null,"300","5005230","1",23,"23 2 7 299",0,13840,13840,13840,13840,1,1,1]
[null,"300","5005230","1",23,"23 2 71199",571349,161209,129306.28,129306.28,78556.28,0.80210335651235354,0.80210335651235354,0.48729462995242201]
[null,"300","5005230","1",23,"23 2 8 1 1",307496,645438,413536,413536,262930.24,0.640706001196087,0.640706001196087,0.40736715222840925]
[null,"300","5005230","1",23,"23 2 8 1 2",11898,20956,16218,16218,9603,0.77390723420500096,0.77390723420500096,0.45824584844435962]
[null,"300","5005230","4",23,"23 1 1 1 1",0,32000,0,0,0,0,0,0]
[null,"300","5005230","4",23,"23 1 5 1 1",0,15000,0,0,0,0,0,0]
[null,"300","5005230","4",23,"23 1 5 1 2",0,65000,0,0,0,0,0,0]
[null,"300","5005230","4",23,"23 1 5 3 1",0,3800,0,0,0,0,0,0]
[null,"300","5005230","4",23,"23 1 9 1 2",0,53316,35225.96,35225.96,35225.96,0.66070147798034362,0.66070147798034362,0.66070147798034362]
[null,"300","5005230","4",23,"23 111 1 1",0,3534,2700,2700,2700,0.76400679117147707,0.76400679117147707,0.76400679117147707]
[null,"300","5005230","4",23,"23 2 2 4 4",0,201369,74411,74411,37661,0.36952559728657342,0.36952559728657342,0.1870248151403642]
[null,"300","5005230","4",23,"23 2 4 1 5",0,6000,0,0,0,0,0,0]
[null,"300","5005230","4",23,"23 2 7 299",0,72660,6920,6920,6920,9.5238095238095233E-2,9.5238095238095233E-2,9.5238095238095233E-2]
[null,"300","5005230","4",23,"23 2 71199",0,457433,152159,152159,129533,0.33263669214945141,0.33263669214945141,0.28317371068549929]
[null,"300","5005230","4",26,"26 3 2 1 1",0,18000,4515.33,4515.33,4515.33,0.25085166666666664,0.25085166666666664,0.25085166666666664]
[null,"300","5005230","4",26,"26 3 2 1 2",0,12000,0,0,0,0,0,0]
[null,"300","5005230","4",26,"26 3 2 2 1",0,9000,0,0,0,0,0,0]
[null,"300","5005230","4",26,"26 3 2 2 2",0,3000,0,0,0,0,0,0,null,"CALLAO",31.9]
[null,"300","5005230","4",26,"26 3 2 3 1",0,102060,19641.169999999998,19641.169999999998,19641.169999999998,0.19244728591024884,0.19244728591024884,0.19244728591024884,null,"VENTANILLA",54.2]
[null,"300","5005230","4",26,"26 3 2 3 3",0,44720,0,0,0,0,0,0]
[null,"TOTAL",{"$nulls":4},{"$f":"+SUM(G4:G33)","v":1090743},{"$f":"+SUM(H4:H33)","v":2186135},1005603.2699999999,1005603.2699999999,697343.87,{"$f":"+I34/H34","v":0.45999138662525413},{"$f":"+J34/H34","v":0.45999138662525413},{"$f":"+K34/H34","v":0.31898481566783388}]
[null,"Fuente: REPORTE SIAF 2018"]

{"sheet":"CALLAO AL 28-06","index":1,"n_rows":51,"n_cols":14,"rows_kept":51,"cut":false,"hidden":false,"merged":[[42,0,42,4],[8,6,9,6],[8,5,9,5],[57,0,57,3],[43,0,43,4],[8,0,9,0],[8,1,9,1],[8,2,9,2],[8,3,9,3],[8,4,9,4],[48,0,48,14],[49,0,49,13],[50,0,51,13],[53,0,53,14],[55,0,55,14],[8,7,9,7],[8,8,8,13],[16,0,16,4],[25,0,25,4]]}
[]
[]
[]
[]
[]
["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 28 /06/18"]
[]
["UNIDAD EJECUTORA","ACTIVIDAD","FUENTE DE FINANCIAMIENTO","GENÉRICA DE GASTO","ESPECÍFICA DE GASTO","NOMBRE DE LA ESPECIFICA","PIA","PIM                  ","SIAF"]
[{"$nulls":8},"CERTIFICACIÓN ","COMPROMISO ANUAL ","EJECUCIÓN","% CERTIFICACIÓN SIAF/PIM","% COMPROMISO ANUAL SIAF/PIM","% EJECUCIÓN"]
["300","5005229","1",23,"23 1 5 1 2","PAPELERIA EN GRAL UTILES Y MATERIALES DE OFICINA",0,6500,3046,3046,3046,{"$f":"+I11/H11","v":0.4686153846153846},{"$f":"+J11/H11","v":0.4686153846153846},{"$f":"+K11/H11","v":0.4686153846153846}]
["300","5005229","1",23,"23 1 9 1 2","MATERIAL DIDACTICO,ACCSESORIOS Y UTILES DE ENSEÑANZA",0,13000,11214.21,11214.21,10891.57,{"$f":"+I12/H12","v":0.86263153846153839},{"$f":"+J12/H12","v":0.86263153846153839},{"$f":"+K12/H12","v":0.83781307692307694}]
["300","5005229","1",23,"23 2 1 299","OTROS GASTOS",0,60345,0,0,0,0,0,0]
["300","5005229","1",23,"23 2 2 4 4","SERVICIO DE IMPRESIONES ENCUADERNACION Y EMPASTADO",0,13000,12950,12950,12950,0.99615384615384617,0.99615384615384617,0.99615384615384617]
["300","5005229","1",23,"23 2 7 3 2","RELAIZADO POR PERSONAS NATURALES",0,3000,3000,3000,0,1,1,0]
["300","5005229","1",23,"23 2 71199","SERVICIOS DIVERSOS",200000,102655,86592.4,86592.4,49002.400000000001,0.84352832302372016,0.84352832302372016,0.47735034825386002]
["TOTAL 23  AMBITO FAM RO ",{"$nulls":5},{"$f":"SUM(G11:G16)","v":200000},{"$f":"SUM(H11:H16)","v":198500},116802.60999999999,116802.60999999999,75889.97,0.58842624685138534,0.58842624685138534,0.38231722921914357]
["300","5005230","1",23,"23 1 5 1 2","PAPELERIA EN GRAL UTILES Y MATERIALES DE OFICINA",0,13000,8027.92,8027.92,8027.92,0.61753230769230771,0.61753230769230771,0.61753230769230771]
["300","5005230","1",23,"23 2 1 299","OTROS GASTOS",0,15100,0,0,0,0,0,0]
["300","5005230","1",23,"23 2 2 4 4","SERVICIO DE IMPRESIONES ENCUADERNACION Y EMPASTADO",0,3200,0,0,0,0,0,0]
["300","5005230","1",23,"23 2 4 1 5","DE MAQUINAS Y EQUIPO",0,16000,12300,12300,12300,0.76875000000000004,0.76875000000000004,0.76875000000000004]
["300","5005230","1",23,"23 2 7 299","OTROS SERVICIOS SIMILARES",0,13840,13840,13840,13840,1,1,1]
["300","5005230","1",23,"23 2 71199","SERVICIOS DIVERSOS",571349,161209,129306.28,129306.28,78556.28,0.80210335651235354,0.80210335651235354,0.48729462995242201]
["300","5005230","1",23,"23 2 8 1 1","CONTRATO ADMINISTRATIVO DE SERVICIOS",307496,645438,413536,413536,262930.24,0.640706001196087,0.640706001196087,0.40736715222840925]
["300","5005230","1",23,"23 2 8 1 2","CONTRIBUCIONES A ESSALUD DE LOS CAS",11898,20956,16218,16218,9603,0.77390723420500096,0.77390723420500096,0.45824584844435962]
["TOTAL 23 AMBITO ERDUCATIVO RO",{"$nulls":5},{"$f":"SUM(G18:G25)","v":890743},{"$f":"SUM(H18:H25)","v":888743},593228.19999999995,593228.19999999995,385257.44,0.66749127700583855,0.66749127700583855,0.43348576585132037]
["300","5005230","4",23,"23 1 1 1 1","ALIMENTOS Y BEBIDAS PARA CONSUMO HUMANO",0,32000,0,0,0,0,0,0]
["300","5005230","4",23,"23 1 5 1 1","REPUESTOS Y ACCSESORIOS",0,15000,0,0,0,0,0,0]
["300","5005230","4",23,"23 1 5 1 2","PAPELERIA EN GRAL UTILES Y MATERIALES DE OFICINA",0,65000,0,0,0,0,0,0]
["300","5005230","4",23,"23 1 5 3 1","ASEO LIMPIEZA Y TOCADOR ",0,3800,0,0,0,0,0,0]
["300","5005230","4",23,"23 1 9 1 2","MATERIAL DIDACTICO,ACCSESORIOS Y UTILES DE ENSEÑANZA",0,53316,35225.96,35225.96,35225.96,0.66070147798034362,0.66070147798034362,0.66070147798034362]
["300","5005230","4",23,"23 111 1 1","PARA EDIFICIOS Y ESTRUCTURAS",0,3534,2700,2700,2700,0.76400679117147707,0.76400679117147707,0.76400679117147707]
["300","5005230","4",23,"23 2 2 4 4","SERVICIO DE IMPRESIONES ENCUADERNACION Y EMPASTADO",0,201369,74411,74411,37661,0.36952559728657342,0.36952559728657342,0.1870248151403642]
["300","5005230","4",23,"23 2 4 1 5","DE MAQUINARIAS Y EQUIPO",0,6000,0,0,0,0,0,0]
["300","5005230","4",23,"23 2 7 299","OTROS SERVICIOS SIMILARES",0,72660,6920,6920,6920,9.5238095238095233E-2,9.5238095238095233E-2,9.5238095238095233E-2]
["300","5005230","4",23,"23 2 71199","SERVICIOS DIVERSOS",0,457433,152159,152159,129533,0.33263669214945141,0.33263669214945141,0.28317371068549929]
["300","5005230","4",26,"26 3 2 1 1","MAQUINAS Y EQUIPO",0,18000,4515.33,4515.33,4515.33,0.25085166666666664,0.25085166666666664,0.25085166666666664]
["300","5005230","4",26,"26 3 2 1 2","MOBILIARIO",0,12000,0,0,0,0,0,0]
["300","5005230","4",26,"26 3 2 2 1","MAQUINAS Y EQUIPO PARA IIEE",0,9000,0,0,0,0,0,0]
["300","5005230","4",26,"26 3 2 2 2","MOBILIARIO PARA IIEE",0,3000,0,0,0,0,0,0]
["300","5005230","4",26,"26 3 2 3 1","EQUIPOS COMPUTACIONALES Y PERIFERICOS",0,102060,19641.169999999998,19641.169999999998,19641.169999999998,0.19244728591024884,0.19244728591024884,0.19244728591024884]
["300","5005230","4",26,"26 3 2 3 3","EQUIPOS DE TELECOMUNICACIONES",0,44720,0,0,0,0,0,0]
["TOTAL 23 Y 26 AMBITO EDUCATIVO DY T ",{"$nulls":5},{"$f":"SUM(G27:G42)","v":0},{"$f":"SUM(H27:H42)","v":1098892},295572.45999999996,295572.45999999996,236196.45999999996,0.26897316569781193,0.26897316569781193,0.21494055830782274]
["TOTAL",{"$nulls":5},{"$f":"SUM(G11:G16,G18:G25,G27:G42)","v":1090743},{"$f":"SUM(H11:H16,H18:H25,H27:H42)","v":2186135},1005603.2699999999,1005603.2699999999,697343.87,{"$f":"+I44/H44","v":0.45999138662525413},{"$f":"+J44/H44","v":0.45999138662525413},{"$f":"+K44/H44","v":0.31898481566783388}]
[]
["Fuente: REPORTE SIAF 2018 AL 28 06 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/75,889.97 que representa una ejecucion del  38.23%  en el ambito familiar  por concepto de adquisicion de utiles y materiales de oficina,material didactico,servicio de impresiones de material de difusion ,servicio de atrencion de break para las aplicaciones de familias fuertes y servicios de fotocopiado y grabacion de estuches con dvds para los docentes facilitadores . "]
["En las especificas de gasto 2.3  por la fuente de financiamiento de recursos ordinarios  presenta una ejecucion  de S/385,257.44 que representa una ejecucion del  43.35% de ejecucion en el ambito educativo  por concepto de adquisicion de utiles y materiales de oficina , servicio de impresion de materiales  de difusion lbretas afiches entre otros , servicio de reparacion y mantenimiento de impresoras y fotocopiadoras ,servicios de grabacion de material de difusion ,servicios de refrigerios y break ,pago de etr por la modalidad de cas y contribuciones a essalud de cas y pago de un facilitador por la modalidad de terceros ."]
["En las especificas de gasto 2.3 Y  2.6  por la fuente de financiamiento de Donaciones y transferencias presenta una ejecucion  de S/236,196.46 que representa una ejecucion del  21.49 % de ejecucion en el ambito educativo  por concepto de adquisicion de utiles y materiales de oficina  servicio de impresion de material de difusion, ,servicios de grabacion y confeccion  de materiales de difusion ,servicios de refrigerios y break ,asi mismo como la adquisicion de equuipos computacxionales y  maquina y equipo."]

{"sheet":"VENTANILLAal 28-06","index":2,"n_rows":32,"n_cols":19,"rows_kept":32,"cut":false,"hidden":false,"merged":[[23,2,23,6],[4,3,5,3],[4,4,5,4],[1,2,1,13],[4,5,5,5],[4,9,4,14],[4,2,5,2],[4,8,5,8],[4,7,5,7],[4,6,5,6]]}
[]
[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)"]
[{"$nulls":4},"AL 28 /06/18"]
[]
[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":"J7/I7","v":1},{"$f":"K7/I7","v":1},{"$f":"L7/I7","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":"+H7+H8","v":0},{"$f":"+I7+I8","v":3500},{"$f":"+J7+J8","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,30000,29091.62,29091.62,29091.62,{"$f":"J10/I10","v":0.96972066666666668},{"$f":"K10/I10","v":0.96972066666666668},{"$f":"L10/I10","v":0.96972066666666668},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,105000,25000,25000,25000,0.23809523809523808,0.23809523809523808,0.23809523809523808]
[{"$nulls":6},"23.27.11.99 Servicios Diversos",0,241000,169354.98,169354.98,169354.98,0.70271775933609959,0.70271775933609959,0.70271775933609959]
[null,null,null,"SUB TOTAL FUENTE 4",null,null,null,{"$f":"+H10+H11+H12+H13","v":0},{"$f":"+I10+I11+I12+I13","v":378000},225446.6,225446.6,225446.6,0.59641957671957668,0.59641957671957668,0.59641957671957668,null,{"$f":"SUM(L10:L14)","v":450893.2},"2.3 ROAMB FAM",{"$f":"SUM(Q14)","v":450893.2}]
[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,41500,11500,11500,11500,0.27710843373493976,0.27710843373493976,0.27710843373493976,null,"AMBITO EDUCATIVO RO"]
[{"$nulls":6},"26.32.31 Equipos computacionales y perifericos",0,38500,8500,8500,8500,0.22077922077922077,0.22077922077922077,0.22077922077922077]
[{"$nulls":6},"26.32.33 Equipos de telecomunicaciones",0,23600,14000,14000,14000,0.59322033898305082,0.59322033898305082,0.59322033898305082]
[null,null,null,"SUB TOTAL FUENTE 4",null,null,null,{"$f":"+H15+H16+H17","v":0},{"$f":"+I15+I16+I17","v":103600},34000,34000,34000,0.3281853281853282,0.3281853281853282,0.3281853281853282]
[null,null,null,"TOTAL FUENTE 4",null,null,null,{"$f":"+H14+H18","v":0},{"$f":"+I14+I18","v":481600},259446.6,259446.6,259446.6,0.53871802325581397,0.53871802325581397,0.53871802325581397]
[]
[null,null,null,"TOTAL POR TODA FUENTE FINANCIAMIENTO",null,null,null,{"$f":"+H9+H19","v":0},{"$f":"+I9+I19","v":485100},262946.38,262946.38,262946.38,0.54204572253143679,0.54204572253143679,0.54204572253143679]
[]
[]
[]
[null,null,"Fuente: REPORTE SIAF 2018 - al 28-06-18"]
[null,null,"Análisis:"]
[null,null,"UGEL - VENTANILLA"]
[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/262,946.38 que representa una ejecucion del  54.20 % de ejecucion en el ambito educativo  por concepto de adquisicion de utiles y materiales de oficina  "]

{"sheet":"CONSOLIDADO REGIONALal 28 06","index":3,"n_rows":60,"n_cols":17,"rows_kept":60,"cut":false,"hidden":false,"merged":[[8,0,9,1],[8,2,9,3],[8,4,9,5],[57,0,57,14],[58,0,58,13],[8,9,9,9],[8,10,9,10],[8,11,8,16],[17,0,17,7],[27,0,27,7],[51,0,51,7],[8,6,9,6],[8,7,9,7],[8,8,9,8],[59,0,60,13],[52,0,52,7],[65,0,65,17],[67,0,67,17],[69,0,69,6]]}
[]
[]
[{"$nulls":8},"CONSOLIDADO REGIONAL"]
[]
[]
["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 28 /06/18"]
[]
["UNIDAD EJECUTORA",null,"ACTIVIDAD",null,"FUENTE DE FINANCIAMIENTO",null,"GENÉRICA DE GASTO","ESPECÍFICA DE GASTO","NOMBRE DE LA ESPECIFICA","PIA","PIM                  ","SIAF"]
[{"$nulls":11},"CERTIFICACIÓN ","COMPROMISO ANUAL ","EJECUCIÓN","% CERTIFICACIÓN SIAF/PIM","% COMPROMISO ANUAL SIAF/PIM","% EJECUCIÓN"]
["300","CALLAO","5005229","AMB FAMILIAR","1","RO",23,"23 1 5 1 2","PAPELERIA EN GRAL UTILES Y MATERIALES DE OFICINA",0,6500,3046,3046,3046,{"$f":"+L11/K11","v":0.4686153846153846},{"$f":"+M11/K11","v":0.4686153846153846},{"$f":"+N11/K11","v":0.4686153846153846}]
["300","CALLAO","5005229","AMB FAMILIAR","1","RO",23,"23 1 9 1 2","MATERIAL DIDACTICO,ACCSESORIOS Y UTILES DE ENSEÑANZA",0,13000,11214.21,11214.21,10891.57,{"$f":"+L12/K12","v":0.86263153846153839},{"$f":"+M12/K12","v":0.86263153846153839},{"$f":"+N12/K12","v":0.83781307692307694}]
["300","CALLAO","5005229","AMB FAMILIAR","1","RO",23,"23 2 1 299","OTROS GASTOS",0,60345,0,0,0,0,0,0]
["300","CALLAO","5005229","AMB FAMILIAR","1","RO",23,"23 2 2 4 4","SERVICIO DE IMPRESIONES ENCUADERNACION Y EMPASTADO",0,13000,12950,12950,12950,0.99615384615384617,0.99615384615384617,0.99615384615384617]
["300","CALLAO","5005229","AMB FAMILIAR","1","RO",23,"23 2 7 3 2","RELAIZADO POR PERSONAS NATURALES",0,3000,3000,3000,0,1,1,0]
["300","CALLAO","5005229","AMB FAMILIAR","1","RO",23,"23 2 71199","SERVICIOS DIVERSOS",200000,102655,86592.4,86592.4,49002.400000000001,0.84352832302372016,0.84352832302372016,0.47735034825386002]
[302,"VENTAN","5005229","AMB FAMILIAR","1","RO",23,"23 1 5 1 2","PAPELERIA EN GRAL UTILES Y MATERIALES DE OFICINA",0,1500,1500,1500,1500,{"$f":"L17/K17","v":1},{"$f":"M17/K17","v":1},{"$f":"N17/K17","v":1}]
["TOTAL 23  AMBITO FAM RO  CALLAO Y VENTANILLA",{"$nulls":8},{"$f":"SUM(J11:J17)","v":200000},{"$f":"SUM(K11:K17)","v":200000},118302.60999999999,118302.60999999999,77389.97,0.59151304999999998,0.59151304999999998,0.38694984999999998]
["300","CALLAO","5005230","AMBITO EDUC","1","RO",23,"23 1 5 1 2","PAPELERIA EN GRAL UTILES Y MATERIALES DE OFICINA",0,13000,8027.92,8027.92,8027.92,0.61753230769230771,0.61753230769230771,0.61753230769230771]
["300","CALLAO","5005230","AMBITO EDUC","1","RO",23,"23 2 1 299","OTROS GASTOS",0,15100,0,0,0,0,0,0]
["300","CALLAO","5005230","AMBITO EDUC","1","RO",23,"23 2 2 4 4","SERVICIO DE IMPRESIONES ENCUADERNACION Y EMPASTADO",0,3200,0,0,0,0,0,0]
["300","CALLAO","5005230","AMBITO EDUC","1","RO",23,"23 2 4 1 5","DE MAQUINAS Y EQUIPO",0,16000,12300,12300,12300,0.76875000000000004,0.76875000000000004,0.76875000000000004]
["300","CALLAO","5005230","AMBITO EDUC","1","RO",23,"23 2 7 299","OTROS SERVICIOS SIMILARES",0,13840,13840,13840,13840,1,1,1]
["300","CALLAO","5005230","AMBITO EDUC","1","RO",23,"23 2 71199","SERVICIOS DIVERSOS",571349,161209,129306.28,129306.28,78556.28,0.80210335651235354,0.80210335651235354,0.48729462995242201]
["300","CALLAO","5005230","AMBITO EDUC","1","RO",23,"23 2 8 1 1","CONTRATO ADMINISTRATIVO DE SERVICIOS",307496,645438,413536,413536,262930.24,0.640706001196087,0.640706001196087,0.40736715222840925]
["300","CALLAO","5005230","AMBITO EDUC","1","RO",23,"23 2 8 1 2","CONTRIBUCIONES A ESSALUD DE LOS CAS",11898,20956,16218,16218,9603,0.77390723420500096,0.77390723420500096,0.45824584844435962]
[302,"VENTAN","5005230","AMBITO EDUC",1,"RO",23,"23 1 5 1 2","PAPELERIA EN GRAL UTILES Y MATERIALES DE OFICINA",0,2000,1999.78,1999.78,1999.78,{"$f":"L27/K27","v":0.99988999999999995},{"$f":"M27/K27","v":0.99988999999999995},{"$f":"N27/K27","v":0.99988999999999995}]
["TOTAL 23 AMBITO ERDUCATIVO RO CALLAO Y VENTANILLA",{"$nulls":8},{"$f":"SUM(J19:J27)","v":890743},{"$f":"SUM(K19:K27)","v":890743},595227.98,595227.98,387257.22000000003,0.6682376173598894,0.6682376173598894,0.43475752265243739]
["300","CALLAO","5005230","AMBITO EDUC","4","DYT",23,"23 1 1 1 1","ALIMENTOS Y BEBIDAS PARA CONSUMO HUMANO",0,32000,0,0,0,0,0,0]
["300","CALLAO","5005230","AMBITO EDUC","4","DYT",23,"23 1 5 1 1","REPUESTOS Y ACCSESORIOS",0,15000,0,0,0,0,0,0]
["300","CALLAO","5005230","AMBITO EDUC","4","DYT",23,"23 1 5 1 2","PAPELERIA EN GRAL UTILES Y MATERIALES DE OFICINA",0,65000,0,0,0,0,0,0]
["300","CALLAO","5005230","AMBITO EDUC","4","DYT",23,"23 1 5 3 1","ASEO LIMPIEZA Y TOCADOR ",0,3800,0,0,0,0,0,0]
["300","CALLAO","5005230","AMBITO EDUC","4","DYT",23,"23 1 9 1 2","MATERIAL DIDACTICO,ACCSESORIOS Y UTILES DE ENSEÑANZA",0,53316,35225.96,35225.96,35225.96,0.66070147798034362,0.66070147798034362,0.66070147798034362]
["300","CALLAO","5005230","AMBITO EDUC","4","DYT",23,"23 111 1 1","PARA EDIFICIOS Y ESTRUCTURAS",0,3534,2700,2700,2700,0.76400679117147707,0.76400679117147707,0.76400679117147707]
["300","CALLAO","5005230","AMBITO EDUC","4","DYT",23,"23 2 2 4 4","SERVICIO DE IMPRESIONES ENCUADERNACION Y EMPASTADO",0,201369,74411,74411,37661,0.36952559728657342,0.36952559728657342,0.1870248151403642]
["300","CALLAO","5005230","AMBITO EDUC","4","DYT",23,"23 2 4 1 5","DE MAQUINARIAS Y EQUIPO",0,6000,0,0,0,0,0,0]
["300","CALLAO","5005230","AMBITO EDUC","4","DYT",23,"23 2 7 299","OTROS SERVICIOS SIMILARES",0,72660,6920,6920,6920,9.5238095238095233E-2,9.5238095238095233E-2,9.5238095238095233E-2]
["300","CALLAO","5005230","AMBITO EDUC","4","DYT",23,"23 2 71199","SERVICIOS DIVERSOS",0,457433,152159,152159,129533,0.33263669214945141,0.33263669214945141,0.28317371068549929]
["300","CALLAO","5005230","AMBITO EDUC","4","DYT",26,"26 3 2 1 1","MAQUINAS Y EQUIPO",0,18000,4515.33,4515.33,4515.33,0.25085166666666664,0.25085166666666664,0.25085166666666664]
["300","CALLAO","5005230","AMBITO EDUC","4","DYT",26,"26 3 2 1 2","MOBILIARIO",0,12000,0,0,0,0,0,0]
["300","CALLAO","5005230","AMBITO EDUC","4","DYT",26,"26 3 2 2 1","MAQUINAS Y EQUIPO PARA IIEE",0,9000,0,0,0,0,0,0]
["300","CALLAO","5005230","AMBITO EDUC","4","DYT",26,"26 3 2 2 2","MOBILIARIO PARA IIEE",0,3000,0,0,0,0,0,0]
["300","CALLAO","5005230","AMBITO EDUC","4","DYT",26,"26 3 2 3 1","EQUIPOS COMPUTACIONALES Y PERIFERICOS",0,102060,19641.169999999998,19641.169999999998,19641.169999999998,0.19244728591024884,0.19244728591024884,0.19244728591024884]
["300","CALLAO","5005230","AMBITO EDUC","4","DYT",26,"26 3 2 3 3","EQUIPOS DE TELECOMUNICACIONES",0,44720,0,0,0,0,0,0]
[302,"VENTAN","5005230","AMBITO EDUC","4","DYT",23,"23 1 9 1 2","MATERIAL DIDACTICO,ACCSESORIOS Y UTILES DE ENSEÑANZA",0,30000,29091.62,29091.62,29091.62,{"$f":"L45/K45","v":0.96972066666666668},{"$f":"M45/K45","v":0.96972066666666668},{"$f":"N45/K45","v":0.96972066666666668}]
[302,"VENTAN","5005230","AMBITO EDUC","4","DYT",23,"23 111 1 1","PARA EDIFICIOS Y ESTRUCTURAS",0,2000,2000,2000,2000,1,1,1]
[302,"VENTAN","5005230","AMBITO EDUC","4","DYT",23,"23 2 2 4 4","SERVICIO DE IMPRESIONES ENCUADERNACION Y EMPASTADO",0,105000,25000,25000,25000,0.23809523809523808,0.23809523809523808,0.23809523809523808]
[302,"VENTAN","5005230","AMBITO EDUC","4","DYT",23,"23 2 71199","SERVICIOS DIVERSOS",0,241000,169354.98,169354.98,169354.98,0.70271775933609959,0.70271775933609959,0.70271775933609959]
[302,"VENTAN","5005230","AMBITO EDUC","4","DYT",26,"26 3 2 2 1","MAQUINAS Y EQUIPO PARA IIEE",0,41500,11500,11500,11500,0.27710843373493976,0.27710843373493976,0.27710843373493976]
[302,"VENTAN","5005230","AMBITO EDUC","4","DYT",26,"26 3 2 3 1","EQUIPOS COMPUTACIONALES Y PERIFERICOS",0,38500,8500,8500,8500,0.22077922077922077,0.22077922077922077,0.22077922077922077]
[302,"VENTAN","5005230","AMBITO EDUC","4","DYT",26,"26 3 2 3 3","EQUIPOS DE TELECOMUNICACIONES",0,23600,14000,14000,14000,0.59322033898305082,0.59322033898305082,0.59322033898305082]
["TOTAL 23 Y 26 AMBITO EDUCATIVO DY T  CALLAO Y VENTANILLA",{"$nulls":8},{"$f":"SUM(J29:J51)","v":0},{"$f":"SUM(K29:K51)","v":1580492},555019.05999999994,555019.05999999994,495643.05999999994,0.35116853486129634,0.35116853486129634,0.31360048643080757]
["TOTAL",{"$nulls":8},{"$f":"SUM(J18,J28,J52)","v":1090743},{"$f":"SUM(K18,K28,K52)","v":2671235},1268549.6499999999,1268549.6499999999,960290.25,{"$f":"+L53/K53","v":0.47489256841872762},{"$f":"+M53/K53","v":0.47489256841872762},{"$f":"+N53/K53","v":0.35949298732608698}]
[]
["Fuente: REPORTE SIAF 2018 AL 28 06 18"]
["Análisis:"]
["Consolidadado  CALLAO -  VENTANILLA"]
["En las especificas de gasto 2.3  por la fuente de financiamiento de recursos ordinarios  presenta una ejecucion  de S/77,389.97 que representa una ejecucion del  38.69%  en el ambito familiar  por concepto de adquisicion de utiles y materiales de oficina,material didactico,servicio de impresiones de material de difusion ,servicio de atrencion de break para las aplicaciones de familias fuertes y servicios de fotocopiado y grabacion de estuches con dvds para los docentes facilitadores . "]
["En las especificas de gasto 2.3  por la fuente de financiamiento de recursos ordinarios  presenta una ejecucion  de S/387,257.22 que representa una ejecucion del  43.48% de ejecucion en el ambito educativo  por concepto de adquisicion de utiles y materiales de oficina , servicio de impresion de materiales  de difusion lbretas afiches entre otros , servicio de reparacion y mantenimiento de impresoras y fotocopiadoras ,servicios de grabacion de material de difusion ,servicios de refrigerios y break ,pago de etr por la modalidad de cas y contribuciones a essalud de cas y pago de un facilitador por la modalidad de terceros ."]
["En las especificas de gasto 2.3 Y  2.6  por la fuente de financiamiento de Donaciones y transferencias presenta una ejecucion  de S/495,643.06 que representa una ejecucion del  31.36 % de ejecucion en el ambito educativo  por concepto de adquisicion de utiles y materiales de oficina  servicio de impresion de material de difusion, ,servicios de grabacion y confeccion  de materiales de difusion ,servicios de refrigerios y break ,asi mismo como la adquisicion de equuipos computacxionales y  maquina y equipo."]