{"text_format":"2","workbook":"xlsx","n_sheets":4,"sheets":["REPORTE CALLAO AL 26 07 18","REPORTE VENTANILLA AL 26 07 18","CONSOLIDADO REGIONAL AL 260718","Gráfico1"],"not_rendered":{"charts":2,"images":4,"macros":0,"external_links":2,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[{"sheet":"Gráfico1","index":3,"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":"REPORTE CALLAO AL 26 07 18","index":0,"n_rows":54,"n_cols":29,"rows_kept":54,"cut":false,"hidden":false,"merged":[[55,0,55,17],[57,0,57,5],[50,0,51,26],[49,0,49,26],[53,0,53,26],[7,9,8,9],[7,10,8,10],[7,8,8,8],[7,23,7,28],[48,0,48,26],[7,1,8,2],[7,3,8,4],[7,5,8,6],[7,0,8,0],[7,7,8,7],[15,0,15,7],[24,0,24,7],[41,0,41,7],[42,0,42,8]]}
[]
[]
[]
[]
["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 26 /07/18"]
[]
["UNIDAD EJECUTORA","ACTIVIDAD",null,"FUENTE DE FINANCIAMIENTO",null,"GENÉRICA DE GASTO",null,"ESPECÍFICA DE GASTO","NOMBRE DE LA ESPECIFICA","PIA","PIM                  ","m01","m02","m03","m04","m05","m06","m07","m08","m09","m10","m11","m12","SIAF"]
[{"$nulls":23},"CERTIFICACIÓN ","COMPROMISO ANUAL ","EJECUCIÓN","% CERTIFICACIÓN SIAF/PIM","% COMPROMISO ANUAL SIAF/PIM","% EJECUCIÓN"]
["300","5005229","AMB FAMILIAR","RO","1",23,"BIENES Y SERVICIOS","23 2 71199","SERVICIOS DIVERSOS",200000,102655,30000,0,0,0,39284,17308.400000000001,5750,0,0,0,0,0,{"$f":"+SUM(L10:W10)","v":92342.399999999994},92342.399999999994,56592.4,{"$f":"+X10/K10","v":0.89954118162778229},{"$f":"+Y10/K10","v":0.89954118162778229},{"$f":"+Z10/K10","v":0.55128732161122207}]
["300","5005229","AMB FAMILIAR","RO","1",23,"BIENES Y SERVICIOS","23 1 5 1 2","PAPELERIA EN GRAL UTILES Y MATERIALES DE OFICNA",0,6500,0,0,0,0,3046,0,0,0,0,0,0,0,{"$f":"+SUM(L11:W11)","v":3046},3046,3046,{"$f":"+X11/K11","v":0.4686153846153846},{"$f":"+Y11/K11","v":0.4686153846153846},{"$f":"+Z11/K11","v":0.4686153846153846}]
["300","5005229","AMB FAMILIAR","RO","1",23,"BIENES Y SERVICIOS","23 2 1 299","OTROS GASTOS",0,60345,0,0,0,0,0,0,60345,0,0,0,0,0,{"$f":"+SUM(L12:W12)","v":60345},0,0,1,0,0]
["300","5005229","AMB FAMILIAR","RO","1",23,"BIENES Y SERVICIOS","23 2 2 4 4","SERVICO DE IMPRESIÓN ENCUADERNACION Y EMPASTADO ",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","AMB FAMILIAR","RO","1",23,"BIENES Y SERVICIOS","23 2 7 3 2","REALIZADO POR PERSONAS NATURALES",0,3000,0,0,0,0,3000,0,0,0,0,0,0,0,3000,3000,0,1,1,0]
["300","5005229","AMB FAMILIAR","RO","1",23,"BIENES Y SERVICIOS","23 1 9 1 2","MATERIAL DIDACTICO ACCSESORIOS Y UTILES DE ENSEÑANZA",0,13000,0,0,0,0,11214.21,0,0,0,0,0,0,0,11214.21,11214.21,11214.21,0.86263153846153839,0.86263153846153839,0.86263153846153839]
["TOTAL 23  AMBITO FAM RO ",{"$nulls":8},{"$f":"SUM(J10:J15)","v":200000},198500,30000,0,0,12950,56544.21,17308.400000000001,66095,0,0,0,0,0,182897.61,122552.60999999999,83802.609999999986,0.9213985390428211,0.61739350125944581,0.42217939546599487]
["300","5005230","AMBITO EDUCATIVO","RO","1",23,"BIENES Y SERVICIOS","23 2 71199","SERVICIOS DIVERSOS",571349,161209,59000,7900,17760,31862.28,4046,8738,29999,0,0,0,0,0,159305.28,159305.28,89665.279999999999,0.98819098189307053,0.98819098189307053,0.55620517464905805]
["300","5005230","AMBITO EDUCATIVO","RO","1",23,"BIENES Y SERVICIOS","23 1 5 1 2","PAPELERIA EN GRAL UTILES Y MATERIALES DE OFICNA",0,13000,0,0,0,8027.92,0,0,4965.74,0,0,0,0,0,12993.66,12993.66,8027.92,0.9995123076923077,0.9995123076923077,0.61753230769230771]
["300","5005230","AMBITO EDUCATIVO","RO","1",23,"BIENES Y SERVICIOS","23 2 1 299","OTROS GASTOS",0,15100,0,0,0,0,0,0,15100,0,0,0,0,0,15100,0,0,1,0,0]
["300","5005230","AMBITO EDUCATIVO","RO","1",23,"BIENES Y SERVICIOS","23 2 2 4 4","SERVICO DE IMPRESIÓN ENCUADERNACION Y EMPASTADO ",0,3200,0,0,0,0,0,0,1575,0,0,0,0,0,1575,1575,1575,0.4921875,0.4921875,0.4921875]
["300","5005230","AMBITO EDUCATIVO","RO","1",23,"BIENES Y SERVICIOS","23 2 4 1 5","DE MAQUINAS Y EQUIPO EN GRAL",0,16000,0,0,0,9500,0,2800,2700,0,0,0,0,0,15000,15000,15000,0.9375,0.9375,0.9375]
["300","5005230","AMBITO EDUCATIVO","RO","1",23,"BIENES Y SERVICIOS","23 2 7 299","OTROS SERVICIOS SIMILARES",0,13840,0,0,0,3460,6920,3460,0,0,0,0,0,0,13840,13840,13840,1,1,1]
["300","5005230","AMBITO EDUCATIVO","RO",1,23,"BIENES Y SERVICIOS","23 2 8 1 1","CONTRATO ADMINISTRATIVO DE SERVICIOS",307496,645438,413536,413536,262930.24,{"$nulls":9},413536,413536,318672,0.640706001196087,0.640706001196087,0.49372983927193625]
["300","5005230","AMBITO EDUCATIVO","RO",1,23,"BIENES Y SERVICIOS","23 2 8 1 2","CONTRIBUCION A ESSALUD DE LOS CAS",11898,20956,16218,16218,9603,{"$nulls":9},16218,16218,11284,0.77390723420500096,0.77390723420500096,0.53846153846153844]
["TOTAL 23 AMBITO ERDUCATIVO RO",{"$nulls":8},{"$f":"SUM(J17:J24)","v":890743},{"$f":"SUM(K17:K24)","v":888743},488754,437654,290293.24,52850.2,10966,14998,54339.74,0,0,0,0,0,647567.93999999994,632467.93999999994,458064.2,0.728633519476384,0.71164323094527882,0.51540681614369965]
["300","5005230","AMBITO EDUCATIVO","D Y T","4",23,"BIENES Y SERVICIOS","23 1 1 1 1","ALIMENTOS Y BEBIDAS PARA CONSUMO HUMANO",0,32000,0,0,0,0,0,0,30000,0,0,0,0,0,{"$f":"+SUM(L26:W26)","v":30000},30000,0,{"$f":"+X26/K26","v":0.9375},{"$f":"+Y26/K26","v":0.9375},{"$f":"+Z26/K26","v":0}]
["300","5005230","AMBITO EDUCATIVO","D Y T","4",23,"BIENES Y SERVICIOS","23 1 5 1 1","REPUESTOS Y ACSESORIOS",0,15000,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["300","5005230","AMBITO EDUCATIVO","D Y T","4",23,"BIENES Y SERVICIOS","23 1 5 1 2","PAPELERIA EN GENERAL UTILES Y MATERIALES DE OFICINA ",0,65000,0,0,0,0,0,0,53633.41,0,0,0,0,0,53633.41,53633.41,0,0.82512938461538465,0.82512938461538465,0]
["300","5005230","AMBITO EDUCATIVO","D Y T","4",23,"BIENES Y SERVICIOS","23 1 5 3 1","ASEO LIMPIEZA Y TOCADOR",0,3800,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["300","5005230","AMBITO EDUCATIVO","D Y T","4",23,"BIENES Y SERVICIOS","23 1 6 199","OTROS GASTOS Y REPUESTOS",0,4000,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["300","5005230","AMBITO EDUCATIVO","D Y T","4",23,"BIENES Y SERVICIOS","23 1 9 1 2","MATERIAL DIDACTICO ACCSESORIOS Y UTILES DE ENSEÑANZA",0,53316,0,0,5708.71,29291.82,225.43,0,0,0,0,0,0,0,35225.96,35225.96,35225.96,0.66070147798034362,0.66070147798034362,0.66070147798034362]
["300","5005230","AMBITO EDUCATIVO","D Y T","4",23,"BIENES Y SERVICIOS","23 111 1 1","PARA EDIFICIOS Y ESTRUCTURAS",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","AMBITO EDUCATIVO","D Y T","4",23,"BIENES Y SERVICIOS","23 2 2 4 4","SERVICO DE IMPRESIÓN ENCUADERNACION Y EMPASTADO ",0,201369,0,0,26550,3611,1200,43050,124466,0,0,0,0,0,198877,198877,84597,0.98762470886779996,0.98762470886779996,0.42010935148905743]
["300","5005230","AMBITO EDUCATIVO","D Y T","4",23,"BIENES Y SERVICIOS","23 2 4 1 5","DE MAQUINAS Y EQUIPO EN GRAL",0,6000,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["300","5005230","AMBITO EDUCATIVO","D Y T","4",23,"BIENES Y SERVICIOS","23 2 7 299","OTROS SERVICIOS SIMILARES",0,72660,0,0,0,0,0,6920,62280,0,0,0,0,0,69200,69200,10380,0.95238095238095233,0.95238095238095233,0.14285714285714285]
["300","5005230","AMBITO EDUCATIVO","D Y T","4",23,"BIENES Y SERVICIOS","23 2 71199","SERVICIOS DIVERSOS",0,453433,0,0,17662.599999999999,73970.399999999994,10950,49576,296600,0,0,0,0,0,448759,448759,169269,0.9896919721325973,0.9896919721325973,0.37330542770376218]
["300","5005230","AMBITO EDUCATIVO","D Y T","4",26,"ACTIVOS NO FINANCIEROS","26 3 2 1 1","MAQUINAS Y EQUIPO",0,22000,0,0,0,4515.33,0,0,6750,0,0,0,0,0,11265.33,11265.33,4515.33,0.51206045454545457,0.51206045454545457,0.20524227272727272]
["300","5005230","AMBITO EDUCATIVO","D Y T","4",26,"ACTIVOS NO FINANCIEROS","26 3 2 1 2","MOBILIARIO",0,12000,0,0,0,0,0,2940,480,0,0,0,0,0,3420,2940,2940,0.28499999999999998,0.245,0.245]
["300","5005230","AMBITO EDUCATIVO","D Y T","4",26,"ACTIVOS NO FINANCIEROS","26 3 2 2 1","MAQUINA PARA IIEE",0,49720,0,0,0,0,0,0,28934,0,0,0,0,0,28934,28934,0,0.58193885760257447,0.58193885760257447,0]
["300","5005230","AMBITO EDUCATIVO","D Y T","4",26,"ACTIVOS NO FINANCIEROS","26 3 2 2 2","MOBILIARIO PARA IIEE",0,3000,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["300","5005230","AMBITO EDUCATIVO","D Y T","4",26,"ACTIVOS NO FINANCIEROS","26 3 2 3 1","EQUIPOS COMPUTACIONALES Y PERIFERICOS",0,102060,0,0,0,6900,12741.17,0,77550,0,0,0,0,0,97191.17,97191.17,19641.169999999998,0.95229443464628649,0.95229443464628649,0.19244728591024884]
["TOTAL 23 Y 26 AMBITO EDUCATIVO DY T ",{"$nulls":8},{"$f":"SUM(J26:J41)","v":0},{"$f":"SUM(K26:K41)","v":1098892},0,0,49921.31,120988.55,25116.6,102486,680693.41,0,0,0,0,0,979205.87,978725.87,329268.45999999996,0.89108471988148064,0.89064791626474671,0.29963677959253499]
["TOTAL",{"$nulls":8},{"$f":"SUM(J42,J25,J16)","v":1090743},{"$f":"SUM(K42,K25,K16)","v":2186135},518754,437654,340214.55,186788.75,92626.81,134792.4,801128.15,0,0,0,0,0,1809671.42,1733746.42,871135.2699999999,0.82779490745082074,0.79306466435055467,0.3984819190031722]
[]
[]
["Fuente: REPORTE SIAF 2018 AL 26 07 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/83,802.61 que representa una ejecucion del  42.22%  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/458,064.20 que representa una ejecucion del  51.54% 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/329,268.46 que representa una ejecucion del  29.96 % 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."]
[]
[]
["A la fecha Callao tiene un avance de ejecucion  a toda meta y fuente de fianciamiento de S/871,135.27 que representa un 39.25%"]

{"sheet":"REPORTE VENTANILLA AL 26 07 18","index":1,"n_rows":85,"n_cols":19,"rows_kept":85,"cut":false,"hidden":false,"merged":[[62,2,62,6],[84,2,84,14],[29,2,29,14],[1,2,1,13],[4,2,5,2],[4,3,5,3],[4,4,5,4],[4,5,5,5],[4,6,5,6],[4,7,5,7],[4,8,5,8],[4,9,4,14],[31,2,31,28],[26,2,27,14],[28,2,28,14],[44,2,44,6],[53,2,53,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 (Julio-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":"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,49196,49196,49196,49196,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,33000,25000,25000,25000,0.75757575757575757,0.75757575757575757,0.75757575757575757]
[{"$nulls":6},"23.27.11.99 Servicios Diversos",0,293804,269042.58,269042.58,185274.58,0.91572129719132489,0.91572129719132489,0.63060605029203143]
[null,null,null,"SUB TOTAL FUENTE 4",null,null,null,{"$f":"+H10+H11+H12+H13","v":0},{"$f":"+I10+I11+I12+I13","v":378000},345238.58,345238.58,261470.58,0.91332957671957671,0.91332957671957671,0.69172111111111112,null,{"$f":"SUM(L10:L14)","v":522941.16},"2.3 ROAMB FAM",{"$f":"SUM(Q14)","v":522941.16}]
[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,81100,73684.639999999999,73684.639999999999,37700.04,0.9085652281134402,0.9085652281134402,0.46485869297163995,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.33 Equipos de telecomunicaciones",0,14000,14000,14000,14000,1,1,1]
[null,null,null,"SUB TOTAL FUENTE 4",null,null,null,{"$f":"+H15+H16+H17","v":0},{"$f":"+I15+I16+I17","v":103600},96184.639999999999,96184.639999999999,60200.04,0.92842316602316599,0.92842316602316599,0.58108146718146714]
[null,null,null,"TOTAL FUENTE 4",null,null,null,{"$f":"+H14+H18","v":0},{"$f":"+I14+I18","v":481600},441423.22000000003,441423.22000000003,321670.62,0.91657645348837213,0.91657645348837213,0.66792072259136215]
[]
[null,null,null,"TOTAL POR TODA FUENTE FINANCIAMIENTO",null,null,null,{"$f":"+H9+H19","v":0},{"$f":"+I9+I19","v":485100},444923.00000000006,444923.00000000006,325170.40000000002,0.91717790146361589,0.91717790146361589,0.6703162234590806]
[]
[null,null,"Fuente: REPORTE SIAF 2018 AL 26 07 18"]
[null,null,"Análisis:"]
[null,null,"Callao - VENTANILLA"]
[]
[null,null,"En las especificas de gasto 2.3  por la fuente de financiamiento de recursos ordinarios  presenta una ejecucion  de S/ 3,499.78 que representa una ejecucion del  99.99%  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 . "]
[]
[null,null,"En las especificas de gasto 2.3  por la fuente de financiamiento de recursos ordinarios  presenta una ejecucion  de S/ 261,470.58 que representa una ejecucion del  69.17% 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 ."]
[null,null,"En las especificas de gasto 2.3 Y  2.6  por la fuente de financiamiento de Donaciones y transferencias presenta una ejecucion  de S/ 321,670.62 que representa una ejecucion del  66.79 % 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."]
[]
[null,null,"A la fecha Ventanilla tiene un avance de ejecucion  a toda meta y fuente de fianciamiento de S/ 325,170.40 que representa un 67.03%"]
[{"$nulls":16},"AMBITO EDUCATIVO DYT"]
[]
[]
[]
[{"$nulls":16},{"$f":"SUM(L33:L37)","v":0},"2.3 AMB EDUC DYT CAP"]
[]
[]
[]
[]
[]
[]
[{"$nulls":16},{"$f":"SUM(L38:L44)","v":0},"2.6 AMB EDU DYT CAP",{"$f":"SUM(Q37:Q44)","v":0}]
{"$rows_empty":16}
[{"$nulls":16},"CALLAO",0.87639999999999996]
[{"$nulls":16},"VENTANILLA",0.71860000000000002]
[]
[null,null,"Fuente: REPORTE SIAF 2018"]
[null,null,"Análisis:"]
{"$rows_empty":19}
[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."]

{"sheet":"CONSOLIDADO REGIONAL AL 260718","index":2,"n_rows":63,"n_cols":30,"rows_kept":63,"cut":false,"hidden":false,"merged":[[50,1,50,8],[7,2,8,3],[7,4,8,5],[7,6,8,7],[7,8,8,8],[7,9,8,9],[62,1,62,27],[66,1,66,6],[7,0,8,1],[51,1,51,9],[57,1,57,27],[58,1,58,27],[59,1,60,27],[64,1,64,18],[7,10,8,10],[7,11,8,11],[7,24,7,29],[16,1,16,8],[26,1,26,8]]}
[]
[]
[{"$nulls":9},"CONSOLIDADO REGIONAL"]
[]
[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,"AL 26 /07/18"]
[]
["UNIDAD EJECUTORA",null,"ACTIVIDAD",null,"FUENTE DE FINANCIAMIENTO",null,"GENÉRICA DE GASTO",null,"ESPECÍFICA DE GASTO","NOMBRE DE LA ESPECIFICA","PIA","PIM                  ","m01","m02","m03","m04","m05","m06","m07","m08","m09","m10","m11","m12","SIAF"]
[{"$nulls":24},"CERTIFICACIÓN ","COMPROMISO ANUAL ","EJECUCIÓN","% CERTIFICACIÓN SIAF/PIM","% COMPROMISO ANUAL SIAF/PIM","% EJECUCIÓN"]
["300","CALLAO","5005229","AMB FAMILIAR","RO","1",23,"BIENES Y SERVICIOS","23 2 71199","SERVICIOS DIVERSOS",200000,102655,30000,0,0,0,39284,17308.400000000001,5750,0,0,0,0,0,{"$f":"+SUM(M10:X10)","v":92342.399999999994},92342.399999999994,56592.4,{"$f":"+Y10/L10","v":0.89954118162778229},{"$f":"+Z10/L10","v":0.89954118162778229},{"$f":"+AA10/L10","v":0.55128732161122207}]
["300","CALLAO","5005229","AMB FAMILIAR","RO","1",23,"BIENES Y SERVICIOS","23 1 5 1 2","PAPELERIA EN GRAL UTILES Y MATERIALES DE OFICNA",0,6500,0,0,0,0,3046,0,0,0,0,0,0,0,3046,3046,3046,0.4686153846153846,0.4686153846153846,0.4686153846153846]
["300","CALLAO","5005229","AMB FAMILIAR","RO","1",23,"BIENES Y SERVICIOS","23 2 1 299","OTROS GASTOS",0,60345,0,0,0,0,0,0,60345,0,0,0,0,0,60345,0,0,1,0,0]
["300","CALLAO","5005229","AMB FAMILIAR","RO","1",23,"BIENES Y SERVICIOS","23 2 2 4 4","SERVICO DE IMPRESIÓN ENCUADERNACION Y EMPASTADO ",0,13000,0,0,0,12950,0,0,0,0,0,0,0,0,12950,12950,12950,0.99615384615384617,0.99615384615384617,0.99615384615384617]
["300","CALLAO","5005229","AMB FAMILIAR","RO","1",23,"BIENES Y SERVICIOS","23 2 7 3 2","REALIZADO POR PERSONAS NATURALES",0,3000,0,0,0,0,3000,0,0,0,0,0,0,0,3000,3000,0,1,1,0]
["300","CALLAO","5005229","AMB FAMILIAR","RO","1",23,"BIENES Y SERVICIOS","23 1 9 1 2","MATERIAL DIDACTICO ACCSESORIOS Y UTILES DE ENSEÑANZA",0,13000,0,0,0,0,11214.21,0,0,0,0,0,0,0,11214.21,11214.21,11214.21,0.86263153846153839,0.86263153846153839,0.86263153846153839]
[302,"VENTANILLA","5005229","AMB FAMILIAR","RO","1",23,"BIENES Y SERVICIOS","23 1 5 1 2","PAPELERIA EN GRAL UTILES Y MATERIALES DE OFICINA",0,1500,1500,1500,1500,{"$nulls":9},1500,1500,1500,1,1,1]
[null,"TOTAL 23  AMBITO FAM RO ",{"$nulls":8},{"$f":"SUM(K10:K16)","v":200000},{"$f":"SUM(L10:L16)","v":200000},31500,1500,1500,12950,56544.21,17308.400000000001,66095,0,0,0,0,0,184397.61,124052.60999999999,85302.609999999986,0.92198804999999995,0.62026304999999993,0.42651304999999995]
["300","CALLAO","5005230","AMBITO EDUCATIVO","RO","1",23,"BIENES Y SERVICIOS","23 2 71199","SERVICIOS DIVERSOS",571349,161209,59000,7900,17760,31862.28,4046,8738,29999,0,0,0,0,0,{"$f":"+SUM(M18:X18)","v":159305.28},159305.28,89665.279999999999,0.98819098189307053,0.98819098189307053,0.55620517464905805]
["300","CALLAO","5005230","AMBITO EDUCATIVO","RO","1",23,"BIENES Y SERVICIOS","23 1 5 1 2","PAPELERIA EN GRAL UTILES Y MATERIALES DE OFICNA",0,13000,0,0,0,8027.92,0,0,4965.74,0,0,0,0,0,12993.66,12993.66,8027.92,0.9995123076923077,0.9995123076923077,0.61753230769230771]
["300","CALLAO","5005230","AMBITO EDUCATIVO","RO","1",23,"BIENES Y SERVICIOS","23 2 1 299","OTROS GASTOS",0,15100,0,0,0,0,0,0,15100,0,0,0,0,0,15100,0,0,1,0,0]
["300","CALLAO","5005230","AMBITO EDUCATIVO","RO","1",23,"BIENES Y SERVICIOS","23 2 2 4 4","SERVICO DE IMPRESIÓN ENCUADERNACION Y EMPASTADO ",0,3200,0,0,0,0,0,0,1575,0,0,0,0,0,1575,1575,1575,0.4921875,0.4921875,0.4921875]
["300","CALLAO","5005230","AMBITO EDUCATIVO","RO","1",23,"BIENES Y SERVICIOS","23 2 4 1 5","DE MAQUINAS Y EQUIPO EN GRAL",0,16000,0,0,0,9500,0,2800,2700,0,0,0,0,0,15000,15000,15000,0.9375,0.9375,0.9375]
["300","CALLAO","5005230","AMBITO EDUCATIVO","RO","1",23,"BIENES Y SERVICIOS","23 2 7 299","OTROS SERVICIOS SIMILARES",0,13840,0,0,0,3460,6920,3460,0,0,0,0,0,0,13840,13840,13840,1,1,1]
["300","CALLAO","5005230","AMBITO EDUCATIVO","RO",1,23,"BIENES Y SERVICIOS","23 2 8 1 1","CONTRATO ADMINISTRATIVO DE SERVICIOS",307496,645438,413536,413536,262930.24,{"$nulls":9},413536,413536,318672,0.640706001196087,0.640706001196087,0.49372983927193625]
[300,"CALLAO","5005230","AMBITO EDUCATIVO","RO",1,23,"BIENES Y SERVICIOS","23 2 8 1 2","CONTRIBUCION A ESSALUD DE LOS CAS",11898,20956,16218,16218,9603,{"$nulls":9},16218,16218,11284,0.77390723420500096,0.77390723420500096,0.53846153846153844]
[302,"VENTANILLA","5005230","AMBITO EDUCATIVO","RO",1,23,"BIENES Y SERVICIOS","23 1 5 1 2","PAPELERIA EN GRAL UTILES Y MATERIALES DE OFICNA",0,2000,{"$nulls":12},1999.78,1999.78,1999.78,0.99988999999999995,0.99988999999999995,0.99988999999999995]
[null,"TOTAL 23 AMBITO ERDUCATIVO RO",{"$nulls":8},{"$f":"SUM(K18:K26)","v":890743},{"$f":"SUM(L18:L26)","v":890743},488754,437654,290293.24,52850.2,10966,14998,54339.74,0,0,0,0,0,649567.72,634467.72,460063.98000000004,0.72924257614149079,0.71229043618641963,0.51649463425477382]
["300","CALLAO","5005230","AMBITO EDUCATIVO","D Y T","4",23,"BIENES Y SERVICIOS","23 1 1 1 1","ALIMENTOS Y BEBIDAS PARA CONSUMO HUMANO",0,32000,0,0,0,0,0,0,30000,0,0,0,0,0,{"$f":"+SUM(M28:X28)","v":30000},30000,0,0.9375,0.9375,0]
["300","CALLAO","5005230","AMBITO EDUCATIVO","D Y T","4",23,"BIENES Y SERVICIOS","23 1 5 1 1","REPUESTOS Y ACSESORIOS",0,15000,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["300","CALLAO","5005230","AMBITO EDUCATIVO","D Y T","4",23,"BIENES Y SERVICIOS","23 1 5 1 2","PAPELERIA EN GENERAL UTILES Y MATERIALES DE OFICINA ",0,65000,0,0,0,0,0,0,53633.41,0,0,0,0,0,53633.41,53633.41,0,0.82512938461538465,0.82512938461538465,0]
["300","CALLAO","5005230","AMBITO EDUCATIVO","D Y T","4",23,"BIENES Y SERVICIOS","23 1 5 3 1","ASEO LIMPIEZA Y TOCADOR",0,3800,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["300","CALLAO","5005230","AMBITO EDUCATIVO","D Y T","4",23,"BIENES Y SERVICIOS","23 1 6 199","OTROS GASTOS Y REPUESTOS",0,4000,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["300","CALLAO","5005230","AMBITO EDUCATIVO","D Y T","4",23,"BIENES Y SERVICIOS","23 1 9 1 2","MATERIAL DIDACTICO ACCSESORIOS Y UTILES DE ENSEÑANZA",0,53316,0,0,5708.71,29291.82,225.43,0,0,0,0,0,0,0,35225.96,35225.96,35225.96,0.66070147798034362,0.66070147798034362,0.66070147798034362]
["300","CALLAO","5005230","AMBITO EDUCATIVO","D Y T","4",23,"BIENES Y SERVICIOS","23 111 1 1","PARA EDIFICIOS Y ESTRUCTURAS",0,3534,0,0,0,2700,0,0,0,0,0,0,0,0,2700,2700,2700,0.76400679117147707,0.76400679117147707,0.76400679117147707]
["300","CALLAO","5005230","AMBITO EDUCATIVO","D Y T","4",23,"BIENES Y SERVICIOS","23 2 2 4 4","SERVICO DE IMPRESIÓN ENCUADERNACION Y EMPASTADO ",0,201369,0,0,26550,3611,1200,43050,124466,0,0,0,0,0,198877,198877,84597,0.98762470886779996,0.98762470886779996,0.42010935148905743]
["300","CALLAO","5005230","AMBITO EDUCATIVO","D Y T","4",23,"BIENES Y SERVICIOS","23 2 4 1 5","DE MAQUINAS Y EQUIPO EN GRAL",0,6000,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["300","CALLAO","5005230","AMBITO EDUCATIVO","D Y T","4",23,"BIENES Y SERVICIOS","23 2 7 299","OTROS SERVICIOS SIMILARES",0,72660,0,0,0,0,0,6920,62280,0,0,0,0,0,69200,69200,10380,0.95238095238095233,0.95238095238095233,0.14285714285714285]
["300","CALLAO","5005230","AMBITO EDUCATIVO","D Y T","4",23,"BIENES Y SERVICIOS","23 2 71199","SERVICIOS DIVERSOS",0,453433,0,0,17662.599999999999,73970.399999999994,10950,49576,296600,0,0,0,0,0,448759,448759,169269,0.9896919721325973,0.9896919721325973,0.37330542770376218]
["300","CALLAO","5005230","AMBITO EDUCATIVO","D Y T","4",26,"ACTIVOS NO FINANCIEROS","26 3 2 1 1","MAQUINAS Y EQUIPO",0,22000,0,0,0,4515.33,0,0,6750,0,0,0,0,0,11265.33,11265.33,4515.33,0.51206045454545457,0.51206045454545457,0.20524227272727272]
["300","CALLAO","5005230","AMBITO EDUCATIVO","D Y T","4",26,"ACTIVOS NO FINANCIEROS","26 3 2 1 2","MOBILIARIO",0,12000,0,0,0,0,0,2940,480,0,0,0,0,0,3420,2940,2940,0.28499999999999998,0.245,0.245]
["300","CALLAO","5005230","AMBITO EDUCATIVO","D Y T","4",26,"ACTIVOS NO FINANCIEROS","26 3 2 2 1","MAQUINA PARA IIEE",0,49720,0,0,0,0,0,0,28934,0,0,0,0,0,28934,28934,0,0.58193885760257447,0.58193885760257447,0]
["300","CALLAO","5005230","AMBITO EDUCATIVO","D Y T","4",26,"ACTIVOS NO FINANCIEROS","26 3 2 2 2","MOBILIARIO PARA IIEE",0,3000,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["300","CALLAO","5005230","AMBITO EDUCATIVO","D Y T","4",26,"ACTIVOS NO FINANCIEROS","26 3 2 3 1","EQUIPOS COMPUTACIONALES Y PERIFERICOS",0,102060,0,0,0,6900,12741.17,0,77550,0,0,0,0,0,97191.17,97191.17,19641.169999999998,0.95229443464628649,0.95229443464628649,0.19244728591024884]
[302,"VENTANILLA","5005230","AMBITO EDUCATIVO","D Y T","4",23,"BIENES Y SERVICIOS","23 1 9 1 2","MATERIAL DIDACTICO,ACCSESORIOS Y UTILES DE ENSEÑANZA",0,49196,0,0,26550,3611,1200,43050,124466,0,0,0,0,0,49196,49196,49196,1,1,1]
[302,"VENTANILLA","5005230","AMBITO EDUCATIVO","D Y T","4",23,"BIENES Y SERVICIOS","23 111 1 1","PARA EDIFICIOS Y ESTRUCTURAS",0,2000,0,0,0,0,0,0,0,0,0,0,0,0,2000,2000,2000,1,1,1]
[302,"VENTANILLA","5005230","AMBITO EDUCATIVO","D Y T","4",23,"BIENES Y SERVICIOS","23 2 2 4 4","SERVICIO DE IMPRESIONES ENCUADERNACION Y EMPASTADO",0,33000,0,0,0,0,0,6920,62280,0,0,0,0,0,25000,25000,25000,0.75757575757575757,0.75757575757575757,0.75757575757575757]
[302,"VENTANILLA","5005230","AMBITO EDUCATIVO","D Y T","4",23,"BIENES Y SERVICIOS","23 2 71199","SERVICIOS DIVERSOS",0,293804,0,0,17662.599999999999,73970.399999999994,10950,49576,296600,0,0,0,0,0,269042.58,269042.58,185274.58,0.91572129719132489,0.91572129719132489,0.63060605029203143]
[302,"VENTANILLA","5005230","AMBITO EDUCATIVO","D Y T","4",26,"ACTIVOS NO FINANCIEROS","26 3 2 2 1","MAQUINAS Y EQUIPO PARA IIEE",0,81100,{"$nulls":12},73684.639999999999,73684.639999999999,37700.04,{"$f":"+Y48/L48","v":0.9085652281134402},{"$f":"+Z48/L48","v":0.9085652281134402},{"$f":"+AA48/L48","v":0.46485869297163995}]
[302,"VENTANILLA","5005230","AMBITO EDUCATIVO","D Y T","4",26,"ACTIVOS NO FINANCIEROS","26 3 2 3 1","EQUIPOS COMPUTACIONALES Y PERIFERICOS",0,8500,{"$nulls":12},8500,8500,8500,1,1,1]
[302,"VENTANILLA","5005230","AMBITO EDUCATIVO","D Y T","4",26,"ACTIVOS NO FINANCIEROS","26 3 2 3 3","EQUIPOS DE TELECOMUNICACIONES",0,14000,{"$nulls":12},14000,14000,14000,1,1,1]
[null,"TOTAL 23 Y 26 AMBITO EDUCATIVO DY T ",{"$nulls":8},{"$f":"SUM(K28:K50)","v":0},{"$f":"SUM(L28:L50)","v":1580492},0,0,94133.91,198569.95,37266.6,202032,1164039.4100000001,0,0,0,0,0,1420629.09,1420149.09,650939.07999999996,{"$f":"+Y51/L51","v":0.89885243962006778},{"$f":"+Z51/L51","v":0.89854873672248903},{"$f":"+AA51/L51","v":0.411858509881733}]
[null,"TOTAL",{"$nulls":8},{"$f":"SUM(K51,K27,K17)","v":1090743},2671235,520254,439154,385927.15,264370.15000000002,104776.81,234338.4,1284474.1500000001,0,0,0,0,0,2254594.42,2178669.42,1196305.67,{"$f":"+Y52/L52","v":0.84402698377342311},{"$f":"+Z52/L52","v":0.81560380123800413},{"$f":"+AA52/L52","v":0.44784740765975284}]
[]
[]
[null,"Fuente: REPORTE SIAF 2018 AL 26 07 18"]
[null,"Análisis:"]
[null,"Callao - Ventanilla - Consolidado"]
[null,"En las especificas de gasto 2.3  por la fuente de financiamiento de recursos ordinarios  presenta una ejecucion  de S/85,302.61 que representa una ejecucion del  42.65%  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 . "]
[null,"En las especificas de gasto 2.3  por la fuente de financiamiento de recursos ordinarios  presenta una ejecucion  de S/460,063.98 que representa una ejecucion del  51.65% 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 ."]
[null,"En las especificas de gasto 2.3 Y  2.6  por la fuente de financiamiento de Donaciones y transferencias presenta una ejecucion  de S/650,939.08 que representa una ejecucion del  41.19 % 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."]
[]
[]
[null,"A la fecha Callao y Ventanilla  tiene un avance de ejecucion  a toda meta y fuente de fianciamiento de S/1,196,305.67 que representa un 44.78%"]