{"text_format":"2","workbook":"xlsx","n_sheets":5,"sheets":["FICHA","Formato 01","Formato 02","Formato 03","Hoja1"],"not_rendered":{"charts":0,"images":2,"macros":0,"external_links":0,"defined_names":3,"comments":0,"pivot_tables":0},"unopened":[],"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":"FICHA","index":0,"n_rows":32,"n_cols":11,"rows_kept":32,"cut":false,"hidden":false,"merged":[[31,0,31,3],[31,4,31,7],[31,8,31,11],[6,7,6,8],[7,7,7,8],[6,2,6,6],[7,2,7,6],[11,10,11,11],[15,8,15,9],[22,4,22,7],[22,8,22,11],[22,0,22,3],[15,6,15,7],[6,0,6,1],[7,0,7,1],[10,2,10,3],[18,1,18,2],[17,3,17,4],[18,3,18,4],[4,7,4,8],[12,8,12,9],[10,0,10,1],[11,6,12,6],[11,8,11,9],[10,8,10,11],[4,9,4,11],[4,0,4,1],[18,6,18,7],[16,8,16,9],[17,8,17,9],[18,8,18,9],[17,6,17,7],[1,2,1,11],[16,1,16,2],[16,3,16,4],[15,1,15,4],[17,1,17,2],[12,10,12,11],[16,6,16,7],[10,4,10,5],[11,0,12,1],[11,2,12,3],[11,4,12,5],[4,4,4,5],[4,2,4,3]]}
[]
[null,null,"INFORMACIÓN GENERAL DEL PLAN OPERATIVO ANUAL - PROYECTO DE RECONVERSION PRODUCTIVA"]
[]
["INFORMACIÓN GENERAL DEL PROYECTO PRPA"]
["N° de Resolucion Ministerial:",null,null,null,"N° de Convenio:",null,null,"Periodo de Trabajo:",null,"12 meses"]
[]
["Nombre de la Organización:",{"$nulls":6},"RUC: ",null,null,"N° de Socios:"]
["Nombre del Proyecto PRPA:",{"$nulls":6},"Producto o Actividad:",null,null,"Has según PRP:"]
[]
["GEOREFERENCIACIÓN DEL PROYECTO PRPA"]
["Departamento",null,"Provincia",null,"Distrito",null,"Localidad",null,"Coordenadas Geográficas"]
[{"$nulls":8},"Este",null,"Norte"]
[]
[]
["CRONOGRAMA DE EJECUCIÓN ",{"$nulls":5},"PLAN DE COFINANCIAMIENTO "]
[null,"POA 1",{"$nulls":4},"Cofinanciamiento ",null,"POA 1: Presupuesto S/ ",null,"%"]
[null,"Fecha de Inicio",null,"Fecha de Fin",null,null,"AGROIDEAS (S/ )",null,null,null,{"$f":"+I17/I19","v":{"$error":"#DIV/0!"}}]
["PC1",{"$nulls":5},"OA (S/ )",null,null,null,{"$f":"+I18/I19","v":{"$error":"#DIV/0!"}}]
["PC2",{"$nulls":5},"Total (S/ )",null,{"$f":"I17+I18","v":0},null,{"$f":"SUM(K17:K18)","v":{"$error":"#DIV/0!"}}]
[]
[]
[]
["Representante Legal de la OA",null,null,null,"Coordinador de la UR",null,null,null,"Jefatura de la UM"]
{"$rows_empty":8}
["Firma",null,null,null,"Firma",null,null,null,"Firma"]

{"sheet":"Formato 01","index":1,"n_rows":29,"n_cols":13,"rows_kept":29,"cut":false,"hidden":false,"merged":[[33,1,33,5],[30,1,30,5],[31,1,31,5],[32,1,32,5],[21,1,21,5],[29,1,29,5],[5,2,5,3],[5,4,5,6],[6,2,6,3],[6,4,6,12],[8,1,9,5],[8,6,9,6],[8,7,8,10],[8,11,8,12],[0,2,0,6],[2,2,2,12],[3,2,3,3],[3,4,3,6],[4,2,4,3],[4,4,4,12],[18,7,18,9],[11,2,11,6],[11,7,11,9],[18,2,18,6],[12,1,17,5],[19,1,19,5],[20,1,20,5],[28,7,28,9],[22,7,22,9],[24,1,24,5],[25,1,25,5],[26,1,26,5],[27,1,27,5],[22,2,22,6],[28,2,28,6],[23,1,23,5]]}
[]
[]
[null,null,"FORMATO 01 - PLAN DE ADQUISICIONES DE EQUIPOS, INSUMOS Y SERVICIOS"]
[null,null,"POA:"]
[null,null,"Nombre OA:"]
[null,null,"RUC:"]
[null,null,"Proyecto PRPA:"]
[]
[null,"Componente/Actividad/Producto",{"$nulls":4},"Especificación del Bien / Servicio","PRESUPUESTO APROBADO EN EL PROYECTO PRPA",null,null,null,"PARTICIPACIÓN PRESUPUESTAL"]
[{"$nulls":7},"Unidad de Medida","Cantidad","Costo Unitario S/.","Costo Total Aprobado S/.","AGROIDEAS S/.","OPA S/."]
[{"$nulls":10},{"$f":"K12+K19+K23+K29","v":0},{"$f":"L12+L19+L23+L29","v":0},{"$f":"M12+M19+M23+M29","v":0}]
[{"$nulls":10},{"$f":"SUM(K13:K18)","v":0},{"$f":"SUM(L13:L18)","v":0},{"$f":"SUM(M13:M18)","v":0}]
[{"$nulls":12},0]
[{"$nulls":12},0]
[{"$nulls":12},0]
[{"$nulls":12},0]
[{"$nulls":12},0]
[{"$nulls":12},0]
[{"$nulls":12},{"$f":"SUM(M20:M22)","v":0}]
[{"$nulls":12},0]
[{"$nulls":12},0]
[{"$nulls":12},0]
[{"$nulls":10},{"$f":"SUM(K24:K28)","v":0},{"$f":"SUM(L24:L28)","v":0},{"$f":"SUM(M24:M28)","v":0}]
[{"$nulls":12},{"$f":"K24-L24","v":0}]
[{"$nulls":12},{"$f":"K25-L25","v":0}]
[{"$nulls":12},0]
[{"$nulls":12},{"$f":"K27-L27","v":0}]
[{"$nulls":12},0]
[{"$nulls":10},{"$f":"+SUM(K30:K34)","v":0},{"$f":"+SUM(L30:L34)","v":0},{"$f":"+SUM(M30:M34)","v":0}]

{"sheet":"Formato 02","index":2,"n_rows":12,"n_cols":20,"rows_kept":12,"cut":false,"hidden":false,"merged":[[20,1,20,4],[7,1,7,2],[8,1,8,2],[10,1,11,1],[10,2,11,3],[18,1,18,14],[15,2,17,3],[15,1,17,1],[7,3,7,19],[8,3,8,19],[10,5,11,5],[10,8,10,13],[10,14,10,19],[12,2,14,3],[2,1,2,3],[5,1,5,2],[6,1,6,2],[4,1,4,19],[5,3,5,4],[6,3,6,19],[10,7,11,7],[10,4,11,4],[10,6,11,6],[12,1,14,1]]}
[]
[]
[]
[]
[null,"FORMATO 02 - PROGRAMACIÓN DE ACTIVIDADES POR PASO CRITICO"]
[null,"POA:"]
[null,"Nombre OA:",null,{"$f":"'Formato 01'!E5","v":0}]
[null,"RUC:",null,{"$f":"'Formato 01'!E6","v":0}]
[null,"Proyecto PRPA:",null,{"$f":"'Formato 01'!E7","v":0}]
[]
[null,"#","COMPONENTE",null,"ACTIVIDAD","MEDIO DE VERIFICACIÓN","UNIDAD DE MEDIDA","META","PC 01",{"$nulls":5},"PC 02"]
[{"$nulls":8},"Mes 1","Mes 2","Mes 3","Mes 4","Mes 5","Mes 6","Mes 1","Mes 2","Mes 3","Mes 4","Mes 5","Mes 6"]

{"sheet":"Formato 03","index":3,"n_rows":24,"n_cols":11,"rows_kept":24,"cut":false,"hidden":false,"merged":[[23,1,25,10],[13,2,13,3],[17,2,17,3],[12,2,12,3],[15,2,15,3],[18,2,18,3],[20,2,20,3],[22,1,22,10],[21,2,21,3],[14,2,14,3],[12,1,15,1],[18,1,19,1],[16,2,16,3],[2,1,2,3],[5,1,5,2],[6,1,6,2],[4,1,4,10],[5,3,5,4],[5,6,5,8],[8,1,8,2],[6,3,6,18],[7,3,7,18],[8,3,9,10],[7,1,7,2],[10,1,11,1],[19,2,19,3],[10,8,10,9],[10,5,11,5],[10,4,11,4],[10,2,11,3]]}
[]
[]
[]
[]
[null,"FORMATO 03 - INDICADORES DE SEGUIMIENTO Y MONITOREO DEL PROYECTO PRPA"]
[null,"POA:"]
[null,"Nombre OA:",null,{"$f":"'Formato 02'!D7","v":0}]
[null,"RUC:",null,{"$f":"'Formato 02'!D8","v":0}]
[null,"Proyecto PRPA:",null,{"$f":"'Formato 02'!D9","v":0}]
[]
[null,"INDICADORES","OBJETIVO ESPECÍFICO",null,"UNIDAD DE MEDIDA","MEDIO DE VERIFICACIÓN","LINEA BASE","META PRP","METAS DEL POA POR \nPASO CRÍTICO",null,"META DEL POA"]
[{"$nulls":6},"AÑO 0","(3 años)","PC 01","PC 02","Acumulado"]
[null,"Producción"]
[]
[]
[]
[]
[null,"Costos "]
[null,"Ingreso por ventas"]
[]
[null,"Mano de Obra"]
[null,"Aspecto medioambiental"]
[]
[null,"NOTA:\nLos indicadores del presente formato, deberán estar expuestos y sustentados dentro de los ICMs, así mismo, deberán estar directamente alineados a la estructura del Proyecto PRPA aprobado."]

{"sheet":"Hoja1","index":4,"n_rows":31,"n_cols":8,"rows_kept":31,"cut":false,"hidden":true,"merged":[]}
{"$rows_empty":30}
[{"$nulls":7},"dj HASTA K GRADO DE CCONSANGUIEDAD"]