{"text_format":"1","workbook":"xlsx","n_sheets":22,"sheets":["MENÚ","DATOS GENERALES","AREA DE ESTUDIO","UNIDAD PRODUCTORA","INVOLUCRADOS","PROBLEMA-OBJETIVO","HORIZONTE DE EVALUACIÓN","BRECHA DE SERVICIO","ANALISIS TÉCNICO","COSTO TOTAL","EVALUACION SOCIAL","SOSTENIBILIDAD","GESTIÓN","IMPACTO AMBIENTAL","MARCO LOGICO","CONCLUSIONES","FIRMAS","ANEXOS","Protocolo final","DETALLE DEL COSTO TOTAL","Hoja1","Hoja2"],"not_rendered":{"charts":0,"images":4,"macros":1,"external_links":2,"defined_names":19,"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":"MENÚ","index":0,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"DATOS GENERALES","index":1,"n_rows":59,"n_cols":25,"rows_kept":59,"cut":false,"hidden":false,"merged":[[52,12,52,14],[52,16,52,18],[52,20,52,22],[52,24,52,26],[28,1,28,4],[28,6,28,20],[30,1,30,4],[30,6,30,20],[32,1,32,4],[32,6,32,20],[41,1,41,7],[41,9,41,14],[41,16,41,20],[43,1,43,7],[43,9,43,14],[43,16,43,20],[16,1,16,15],[16,17,16,26],[36,1,36,4],[36,6,36,20],[57,1,57,10],[57,12,57,26],[54,1,54,10],[54,12,54,14],[54,16,54,18],[54,20,54,22],[54,24,54,26],[34,1,34,4],[34,6,34,20],[50,1,50,10],[50,12,50,26],[52,1,52,10],[18,1,18,15],[18,17,18,26],[20,1,20,15],[20,17,20,26],[22,1,22,15],[22,17,22,26]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"SECCIÓN N°01: DATOS GENERALES DEL PROYECTO"]
[]
[]
[]
[]
[null,"UNIDAD FORMULADORA  (UF)"]
[]
[null,"Nivel de gobierno :"]
[]
[null,"Entidad :"]
[]
[null,"Nombre de la UF:  (Nombre de la Unidad Orgánica a la que pertenece la UF)"]
[]
[null,"Responsable de la UF"]
[]
[null,null,"a"]
[]
[]
[]
[null,"Función"]
[]
[null,"División funcional"]
[]
[null,"Grupo funcional"]
[]
[null,"Sector responsable"]
[]
[null,"Tipología de proyecto"]
[]
[]
[]
[]
[null,"Naturaleza de intervención",null,null,null,null,null,null,null,"Objeto de intervención",null,null,null,null,null,null,"Localización"]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Servicios públicos con brecha identificada y priorizada"]
[]
[null,"Nombre del Indicador de brecha de acceso a servicios",null,null,null,null,null,null,null,null,null,null,"Unidad de medida",null,null,null,"Espacio geográfico",null,null,null,"Año",null,null,null,"Valor"]
[]
[]
[]
[null,"Nota: Se puede incluir más de un servicio público con brecha y más de un indicador"]
[null,"Contribución del Cierre de Brecha (Valor)",null,null,null,"Valor:"]
[null,"Nota: Se refiere a la capacidad de producción que aporta el proyecto (incremental). Su estimación proviene de la diferencia entre la oferta con proyecto (tamaño) respecto a la oferta optimizada sin proyecto (cuando corresponda)."]

{"sheet":"AREA DE ESTUDIO","index":2,"n_rows":82,"n_cols":26,"rows_kept":82,"cut":false,"hidden":false,"merged":[[81,1,81,5],[81,6,81,7],[81,8,81,15],[81,16,81,17],[81,18,81,25],[28,2,28,5],[28,10,28,13],[28,14,28,17],[28,18,28,21],[47,1,47,3],[47,4,47,7],[47,8,47,10],[47,11,47,14],[45,1,45,3],[45,7,45,9],[45,10,45,14],[44,1,44,3],[44,7,44,9],[44,10,44,14],[48,1,48,3],[48,4,48,7],[48,8,48,10],[48,11,48,14],[53,15,55,27],[13,1,13,27],[11,1,11,27],[17,2,17,5],[17,6,17,9],[17,10,17,13],[17,14,17,17],[17,18,17,21],[18,2,18,5],[19,2,19,5],[15,1,15,14],[18,6,18,9],[18,10,18,13],[18,14,18,17],[18,18,18,21],[19,6,19,9],[19,10,19,13],[19,14,19,17],[19,18,19,21],[51,1,51,27],[50,1,50,27],[26,6,26,9],[28,6,28,9],[40,1,40,27],[42,1,42,14],[43,1,43,3],[43,4,43,6],[43,7,43,9],[43,10,43,14],[31,1,32,27],[34,1,35,18],[34,19,34,23],[35,19,36,23],[36,1,36,5],[38,1,38,27],[25,18,25,21],[20,2,20,5],[26,2,26,5],[26,10,26,13],[26,14,26,17],[26,18,26,21],[27,2,27,5],[27,6,27,9],[27,10,27,13],[27,14,27,17],[27,18,27,21],[20,10,20,13],[20,14,20,17],[20,18,20,21],[25,2,25,5],[20,6,20,9],[25,6,25,9],[25,10,25,13],[25,14,25,17],[53,1,55,13],[56,1,56,6],[56,7,56,13],[56,15,56,20],[56,21,56,27],[57,1,57,6],[58,1,58,6],[57,7,57,13],[58,7,58,13],[57,15,57,20],[57,21,57,27],[58,15,58,20],[58,21,58,27],[63,1,64,5],[63,6,63,15],[63,16,63,25],[64,6,64,7],[64,8,64,15],[64,16,64,17],[64,18,64,25],[66,1,66,5],[66,6,66,7],[66,8,66,15],[66,16,66,17],[66,18,66,25],[67,1,67,5],[67,6,67,7],[67,8,67,15],[67,16,67,17],[67,18,67,25],[68,1,68,5],[68,6,68,7],[68,8,68,15],[68,16,68,17],[68,18,68,25],[69,1,69,5],[69,6,69,7],[69,8,69,15],[69,16,69,17],[69,18,69,25],[70,1,70,5],[70,6,70,7],[70,8,70,15],[70,16,70,17],[70,18,70,25],[71,1,71,5],[71,6,71,7],[71,8,71,15],[71,16,71,17],[71,18,71,25],[72,1,72,5],[72,6,72,7],[72,8,72,15],[72,16,72,17],[72,18,72,25],[73,1,73,5],[73,6,73,7],[73,8,73,15],[73,16,73,17],[73,18,73,25],[74,1,74,5],[74,6,74,7],[74,8,74,15],[74,16,74,17],[74,18,74,25],[75,1,75,5],[75,6,75,7],[75,8,75,15],[75,16,75,17],[75,18,75,25],[76,1,76,5],[76,6,76,7],[76,8,76,15],[76,16,76,17],[76,18,76,25],[77,1,77,5],[77,6,77,7],[77,8,77,15],[77,16,77,17],[77,18,77,25],[80,1,80,5],[80,6,80,7],[80,8,80,15],[80,16,80,17],[80,18,80,25],[78,1,78,5],[78,6,78,7],[78,8,78,15],[78,16,78,17],[78,18,78,25],[79,1,79,5],[79,6,79,7],[79,8,79,15],[79,16,79,17],[79,18,79,25]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"SECCIÓN N°02: DIAGNÓSTICO DEL ÁREA DE ESTUDIO"]
[]
[null,"DIAGNÓSTICO"]
[]
[null,"ÁREA DE ESTUDIO"]
[]
[null,"2.01 Localización del área de estudio del proyecto"]
[]
[null,"N° ","Departamento",null,null,null,"Provincia","Provincia",null,null,"Distrito",null,null,null,"Localidad/Centro poblado",null,null,null,"Ubigeo"]
[null,1]
[null,2]
[null,3]
[null,"Nota: Si el área de estudio del proyecto abarca más de una localización, se podrán añadir más localizaciones."]
[]
[null,"2.02 Localización del área de influencia del proyecto"]
[]
[null,"N° ","Departamento",null,null,null,"Provincia","Provincia",null,null,"Distrito",null,null,null,"Localidad/Centro poblado",null,null,null,"Ubigeo"]
[null,1]
[null,2]
[null,3]
[null,"Nota: Si el área de influencia del proyecto abarca más de una localización, se podrán añadir más localizaciones."]
[]
[null,"2.03 Croquis con la ubicación de los beneficiarios o los demandantes actuales y futuros y la localización de los elementos de la UP (en caso exista) o la UP que se conformará producto de las alternativas de solución."]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Leyenda del croquis:"]
[]
[null,"Fuente de información:"]
[]
[null,"2.04 Análisis de las características (físicas, accesibilidad, disponibilidad de servicios, insumos, etc.) que influirán en el diseño del proyecto, en la demanda, en los costos, etc.)"]
[]
[null,"Físicas"]
[]
[null,"Principales características del uso del suelo de la zona de interés (localización potencial de la UP)"]
[null,"Tipo de suelo",null,null,"Área",null,null,"Descripción",null,null,"Fuente de información"]
[]
[]
[]
[null,"Altitud",null,null,"Temperatura",null,null,null,"Humedad",null,null,"Precipitación"]
[]
[]
[null,"Describir características de accesibilidad y dinámica económica"]
[]
[]
[null,"Acceso a servicios públicos",null,null,null,null,null,null,null,null,null,null,null,null,null,"Disponibilidad de recursos e insumos para el proyecto"]
[]
[]
[null,"Servicio público",null,null,null,null,null,"Descripción",null,null,null,null,null,null,null,"Recursos",null,null,null,null,null,"Descripción",null,null,null,"Descripción"]
[]
[]
[]
[]
[null,"2.05 Identificar los peligros que pueden ocurrir en el área de estudio"]
[]
[null,"Peligros",null,null,null,null,"¿Existen antecedentes de ocurrencia en el área de estudio?",null,null,null,null,null,null,null,null,null,"¿Existe información que indique futuros cambios en las características del peligro o los nuevos peligros?"]
[null,null,null,null,null,null,"Sí / No",null,"Características (Intensidad, frecuencia, área de impacto, otros)",null,null,null,null,null,null,null,"Sí/No",null,"Características de los cambios o los nuevos peligros"]
[]
[null,"Inundaciones"]
[null,"Movimientos en masa"]
[null,"Lluvias intensas"]
[null,"Helada"]
[null,"Nevadas"]
[null,"Friaje"]
[null,"Sismos"]
[null,"Sequías"]
[null,"Vulcanismo"]
[null,"Tsunamis"]
[null,"Incendios forestales"]
[null,"Erosión"]
[null,"Vientos fuertes"]
[null,"Incendios urbanos"]
[null,"Radiación solar"]
[null,"Otros"]

{"sheet":"UNIDAD PRODUCTORA","index":3,"n_rows":135,"n_cols":20,"rows_kept":135,"cut":false,"hidden":false,"merged":[[87,1,87,2],[87,3,87,4],[89,1,89,2],[89,3,89,4],[75,1,75,2],[76,1,76,2],[77,1,77,2],[78,1,78,2],[79,1,79,2],[80,1,80,2],[81,1,81,2],[82,1,82,2],[23,11,23,13],[24,5,24,7],[24,8,24,10],[24,11,24,13],[32,2,32,5],[33,2,33,5],[34,2,34,5],[30,6,30,9],[32,6,32,9],[33,6,33,9],[34,6,34,9],[30,10,30,19],[32,10,32,19],[33,10,33,19],[34,10,34,19],[23,8,23,10],[48,14,48,15],[48,9,48,13],[38,14,39,15],[39,6,39,7],[44,14,44,15],[46,14,46,15],[45,6,45,7],[45,14,45,15],[46,6,46,7],[43,14,43,15],[41,14,41,15],[42,14,42,15],[47,14,47,15],[38,6,38,8],[42,6,42,7],[49,14,49,15],[52,1,61,1],[52,2,54,3],[52,4,52,5],[52,6,52,7],[52,14,52,15],[53,4,53,5],[51,2,51,3],[51,4,51,5],[50,4,50,5],[50,6,50,7],[47,2,49,3],[48,4,48,5],[50,14,50,15],[49,4,49,5],[48,6,48,7],[49,6,49,7],[41,1,50,1],[41,2,43,3],[41,4,41,5],[41,6,41,7],[43,4,43,5],[43,6,43,7],[46,4,46,5],[13,1,13,4],[13,5,13,15],[15,1,15,8],[15,9,15,15],[21,14,21,17],[24,14,24,17],[11,1,11,20],[27,1,27,13],[29,1,30,1],[30,2,30,5],[29,2,29,19],[22,14,22,17],[23,14,23,17],[21,2,21,4],[21,5,21,7],[21,8,21,10],[21,11,21,13],[22,2,22,4],[23,2,23,4],[24,2,24,4],[22,5,22,7],[22,8,22,10],[22,11,22,13],[23,5,23,7],[70,1,70,9],[58,9,58,13],[59,9,59,13],[60,9,60,13],[61,9,61,13],[50,2,50,3],[51,6,51,7],[51,14,51,15],[53,6,53,7],[53,14,53,15],[54,4,54,5],[54,6,54,7],[54,14,54,15],[55,2,57,3],[55,4,55,5],[55,6,55,7],[55,14,55,15],[56,4,56,5],[56,6,56,7],[56,14,56,15],[57,4,57,5],[57,6,57,7],[57,14,57,15],[57,9,57,13],[59,14,59,15],[58,2,60,3],[58,4,58,5],[58,6,58,7],[58,14,58,15],[60,4,60,5],[60,6,60,7],[60,14,60,15],[61,2,61,3],[61,4,61,5],[61,6,61,7],[61,14,61,15],[72,14,73,15],[75,10,75,11],[75,12,75,13],[75,14,75,15],[75,16,75,18],[75,19,75,20],[76,6,76,7],[76,8,76,9],[76,10,76,11],[76,12,76,13],[75,6,75,7],[75,8,75,9],[76,14,76,15],[76,16,76,18],[76,19,76,20],[72,19,73,20],[72,6,73,7],[72,16,73,18],[72,8,73,9],[79,19,79,20],[80,16,80,18],[80,19,80,20],[80,6,80,7],[80,8,80,9],[77,6,77,7],[77,8,77,9],[77,10,77,11],[77,12,77,13],[77,14,77,15],[77,16,77,18],[77,19,77,20],[78,6,78,7],[78,8,78,9],[78,10,78,11],[78,12,78,13],[78,14,78,15],[78,16,78,18],[78,19,78,20],[80,10,80,11],[80,12,80,13],[80,14,80,15],[83,14,83,15],[83,16,83,18],[83,19,83,20],[83,1,83,2],[81,14,81,15],[79,6,79,7],[79,8,79,9],[79,10,79,11],[79,12,79,13],[79,14,79,15],[81,16,81,18],[81,19,81,20],[82,6,82,7],[82,8,82,9],[82,10,82,11],[82,12,82,13],[82,14,82,15],[82,16,82,18],[82,19,82,20],[81,6,81,7],[81,8,81,9],[81,10,81,11],[81,12,81,13],[79,16,79,18],[92,1,92,2],[92,3,92,4],[118,9,118,12],[134,1,134,3],[134,13,134,15],[134,16,134,18],[118,1,119,2],[118,3,119,8],[129,1,133,12],[129,13,129,18],[131,13,131,15],[131,16,131,18],[132,13,132,15],[132,16,132,18],[127,1,127,11],[123,1,126,2],[123,3,123,8],[124,3,124,8],[125,3,125,8],[126,3,126,8],[106,1,106,5],[107,1,107,5],[108,1,108,5],[96,1,97,5],[122,3,122,8],[133,13,133,15],[133,16,133,18],[96,6,96,8],[99,1,99,5],[100,1,100,5],[101,1,101,5],[102,1,102,5],[103,1,103,5],[104,1,104,5],[105,1,105,5],[109,1,109,5],[110,1,110,5],[111,1,111,5],[112,1,112,5],[113,1,113,5],[121,1,122,2],[121,3,121,8],[36,1,36,13],[38,9,39,13],[41,9,41,13],[42,9,42,13],[43,9,43,13],[44,9,44,13],[45,9,45,13],[46,9,46,13],[47,9,47,13],[47,6,47,7],[44,2,46,3],[38,1,39,1],[38,2,39,3],[38,4,39,5],[42,4,42,5],[44,4,44,5],[44,6,44,7],[45,4,45,5],[47,4,47,5],[49,9,49,13],[50,9,50,13],[51,9,51,13],[52,9,52,13],[53,9,53,13],[54,9,54,13],[55,9,55,13],[56,9,56,13],[91,1,91,2],[91,3,91,4],[90,1,90,2],[90,3,90,4],[83,6,83,7],[83,8,83,9],[83,10,83,11],[83,12,83,13],[72,10,73,11],[72,12,73,13],[59,4,59,5],[59,6,59,7],[72,3,72,5],[72,1,73,2],[68,1,68,7],[69,1,69,7]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"SECCIÓN N°03: DIAGNÓSTICO DE LA UNIDAD PRODUCTORA"]
[]
[null,"LA UNIDAD PRODUCTORA DE BIENES Y SERVICIOS (En caso exista)"]
[]
[null,"3.01 Nombre de la Unidad Productora:"]
[]
[null,"3.02 Código de la unidad productora (en caso el sector lo haya definido)*"]
[null,"*Son obligatorios en caso de: colegios (código modular), instituciones prestadores de servicios de salud (código de establecimiento)"]
[null,"Nota: Se puede agregar más de un código de identificación cuando el proyecto comprenda más de una Unidad Productora"]
[]
[null,"3.03 Localización geográfica de la Unidad Productora"]
[]
[null,"N° ","Departamento",null,null,"Provincia",null,null,"Distrito",null,null,"Localidad/Centro poblado",null,null,"Coordenadas geográficas"]
[null,1]
[null,2]
[null,3]
[null,"Nota: Si la Unidad Productora del proyecto abarca más de una localización o si el proyecto presenta más de una Unidad Productora, se podrán añadir más localizaciones"]
[]
[null,"3.04 Diagnóstico de procesos de la Unidad Productora"]
[]
[null,"N°","Caracterización de los procesos de producción de la UP"]
[null,null,"Nombre del proceso de producción",null,null,null,"Descripción ¿En qué consiste el proceso?",null,null,null,"Situación actual"]
[]
[null,1]
[null,2]
[null,"n"]
[]
[null,"3.05 Diagnóstico de los activos de la UP"]
[]
[null,"Procesos","Tipo de Factor productivo",null,"Activos estratégicos esenciales*",null,"Cumple con los estándares de calidad del Sector",null,null,"Estado Situacional",null,null,null,null,"Acciones correctivas"]
[null,null,null,null,null,null,"Norma técnica**",null,"Sí "]
[]
[null,"Proceso 1","Infraestructura",null,"Activo 1"]
[null,null,null,null,"…"]
[null,null,null,null,"Activo n"]
[null,null,"Equipamiento",null,"Activo 1"]
[null,null,null,null,"…"]
[null,null,null,null,"Activo n"]
[null,null,"Vehículos",null,"Activo 1"]
[null,null,null,null,"…"]
[null,null,null,null,"Activo n"]
[null,null,"…"]
[null,"Proceso …","…"]
[null,"Proceso n","Infraestructura",null,"Activo 1"]
[null,null,null,null,"…"]
[null,null,null,null,"Activo n"]
[null,null,"Equipamiento",null,"Activo 1"]
[null,null,null,null,"…"]
[null,null,null,null,"Activo n"]
[null,null,"Vehículos",null,"Activo 1"]
[null,null,null,null,"…"]
[null,null,null,null,"Activo n"]
[null,null,"…"]
[null,"* Activos que modifican la capacidad de producción del servicio. P.ej: aulas, laboratorios de investigación, camas, consultorios, PTAP, etc."]
[null,"** De no existir norma técnica, precisar el documento o informe técnico equivalente."]
[]
[]
[null,"3.06 Detallar las prácticas de mantenimiento de la UP "]
[]
[null,"¿Se dispone de un plan operativo aprobado?",null,null,null,null,null,null,"Sí","No"]
[null,"Precisar documento (en caso la anterior pregunta sea afirmativa)"]
[]
[]
[null,"Precisar los activos esenciales que reciben mantenimiento",null,"Tipo de mantenimiento",null,null,"Fecha de último mantenimiento realizado",null,"Acciones de mantenimiento realizadas",null,"Costo de último mantenimiento realizado",null,"¿En el año actual dispone de fondos para su ejecución?",null,"¿La entidad dispone de los materiales, recursos humanos y gestión para el mantenimiento?",null,"Precisar restricciones",null,null,"Órgano o área técnica responsable"]
[null,null,null,"Rutinario","Periódico","Correctivo"]
[]
[null,"Activo 1"]
[null,"Activo 2"]
[null,"…"]
[null,"…"]
[null,"…"]
[null,"…"]
[null,"…"]
[null,"…"]
[null,"Activo \"n\""]
[]
[null,"3.07 Evolución de la producción de servicio provisto a los usuarios"]
[]
[null,"Servicios",null,"Unidad de Medida",null,"Año -5","Año -4","Año -3","Año -2","Año -1"]
[]
[null,"Servicio 1"]
[null,"Servicio 2"]
[null,"…"]
[null,"Servicio \"n\""]
[]
[null,"3.08 Estimar la exposición de la UP frente a los peligros identificados en el diagnóstico del área de estudio"]
[]
[null,"Peligros",null,null,null,null,"Grado de exposición"]
[null,null,null,null,null,null,"Bajo","Medio","Alto"]
[]
[null,"Inundaciones"]
[null,"Movimientos en masa"]
[null,"Lluvias intensas"]
[null,"Helada"]
[null,"Nevadas"]
[null,"Friaje"]
[null,"Sismos"]
[null,"Sequías"]
[null,"Vulcanismo"]
[null,"Tsunamis"]
[null,"Incendios forestales"]
[null,"Erosión"]
[null,"Vientos fuertes"]
[null,"Incendios urbanos"]
[null,"…"]
[]
[]
[null,"3.09 Describir la vulnerabilidad por factores de fragilidad y resiliencia"]
[]
[null,"Factor de Vulnerabilidad*",null,"Variable",null,null,null,null,null,"Grado de vulnerabilidad"]
[null,null,null,null,null,null,null,null,null,"Bajo","Medio","Alto","Muy alto"]
[]
[null,"Fragilidad",null,"Tipo de construcción"]
[null,null,null,"Aplicación de normas de construcción"]
[null,"Resiliencia",null,"Capacidades de los operadores para responder ante un evento natural "]
[null,null,null,"Capacidades de respuesta de la organización (entidad) ante una contingencia."]
[null,null,null,"Capacidades financieras de la entidad para la respuesta"]
[null,null,null,"Existencia de recursos financieros para respuesta"]
[null,"*El llenado del cuadro es para cada UP o para cada uno de sus activos (en caso presenten distinta localización) \n"]
[null,"3.10 Mapa de peligros de la UP y su área de influencia"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Leyenda del croquis:"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"UP o activos de la UP* expuestos",null,null,"Coordenadas de ubicación"]
[]
[]
[null,"Fuente de información:"]

{"sheet":"INVOLUCRADOS","index":4,"n_rows":46,"n_cols":14,"rows_kept":46,"cut":false,"hidden":false,"merged":[[48,7,48,9],[15,7,15,9],[13,4,13,6],[15,4,15,6],[11,1,11,12],[48,1,48,3],[48,4,48,6],[48,10,48,12],[37,8,37,10],[38,8,38,10],[29,4,38,5],[35,6,35,7],[36,6,36,7],[37,6,37,7],[38,6,38,7],[30,8,30,10],[31,8,31,10],[43,1,43,3],[43,4,43,6],[43,10,43,12],[43,13,43,15],[32,8,32,10],[33,8,33,10],[34,6,34,7],[38,1,38,3],[31,1,31,3],[32,1,32,3],[33,1,33,3],[35,1,35,3],[41,1,41,15],[45,1,45,3],[45,4,45,6],[45,10,45,12],[45,13,45,15],[43,7,43,9],[45,7,45,9],[49,1,49,3],[49,4,49,6],[49,10,49,12],[49,13,49,15],[46,1,46,3],[46,4,46,6],[46,10,46,12],[46,13,46,15],[47,1,47,3],[47,4,47,6],[47,10,47,12],[47,13,47,15],[49,7,49,9],[48,13,48,15],[46,7,46,9],[47,7,47,9],[29,8,29,10],[29,6,29,7],[23,8,23,10],[24,8,24,10],[25,8,25,10],[26,8,26,10],[13,10,13,12],[15,1,15,3],[15,10,15,12],[23,4,23,5],[21,6,21,7],[20,1,20,10],[21,8,21,10],[26,4,26,5],[21,4,21,5],[23,1,26,3],[13,7,13,9],[27,1,28,3],[21,1,21,3],[23,6,23,7],[24,6,24,7],[25,6,25,7],[26,6,26,7],[27,6,27,7],[28,6,28,7],[24,4,24,5],[25,4,25,5],[13,1,13,3],[18,1,18,12],[29,1,29,3],[30,1,30,3],[36,1,36,3],[37,1,37,3],[27,8,27,10],[28,8,28,10],[30,6,30,7],[31,6,31,7],[27,4,27,5],[28,4,28,5],[34,8,34,10],[34,1,34,3],[32,6,32,7],[33,6,33,7],[35,8,35,10],[36,8,36,10]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"SECCIÓN N°04: DIAGNÓSTICO DE LOS INVOLUCRADOS"]
[]
[null,"4.01 Descripción de la población afectada"]
[]
[null,"Total de la población afectada",null,null,"Tipo de población*",null,null,"Unidad de medida",null,null,"Fuente de información"]
[]
[]
[null,"*Define en función a la tipología del proyecto"]
[]
[null,"4.02 Caracterización de la población afectada"]
[]
[null,"Estructura de la población"]
[null,"Variables /indicadores",null,null,"Categorías",null,"Valor",null,"Fuente de información"]
[]
[null,"Edad",null,null,"0-14 años"]
[null,null,null,null,"15-19 años"]
[null,null,null,null,"20-59 años"]
[null,null,null,null,"Mayor a 60 años"]
[null,"Género",null,null,"Hombre"]
[null,null,null,null,"Mujer"]
[null,"Personas con discapacidad"]
[null,"Población infantil"]
[null,"Población por niveles de ingresos"]
[null,"Número de hogares"]
[null,"% de la población con acceso a salud"]
[null,"% de la población con acceso a saneamiento"]
[null,"% de la población con acceso a electrificación"]
[null,"% de la población con acceso a educación básica regular"]
[null,"% de la PEA"]
[null,"Otros"]
[null,"*Esta matriz es referencial, dependerá de la tipología del proyecto"]
[]
[null,"4.03 Matriz de involucrados"]
[]
[null,"Agente involucrado",null,null,"Posición (Cooperante, Beneficiario, Oponente, Perjudicado)",null,null,"Problemas percibidos",null,null,"Intereses o expectativas",null,null,"Contribución"]
[]
[null,"Población afectada"]

{"sheet":"PROBLEMA-OBJETIVO","index":5,"n_rows":90,"n_cols":14,"rows_kept":90,"cut":false,"hidden":false,"merged":[[80,5,80,8],[80,9,80,12],[80,13,80,16],[81,1,83,4],[84,1,86,4],[87,1,89,4],[81,5,81,8],[82,5,82,8],[83,5,83,8],[84,5,84,8],[85,5,85,8],[86,5,86,8],[87,5,87,8],[88,5,88,8],[89,5,89,8],[81,9,81,12],[82,9,82,12],[83,9,83,12],[84,9,84,12],[85,9,85,12],[86,9,86,12],[87,9,87,12],[88,9,88,12],[89,9,89,12],[73,1,75,4],[73,5,73,8],[74,5,74,8],[75,5,75,8],[45,1,45,4],[45,5,45,8],[47,1,47,4],[47,5,47,8],[52,2,52,5],[52,6,52,9],[54,6,54,9],[59,6,59,9],[62,6,62,9],[65,5,65,8],[69,5,69,8],[70,1,72,4],[70,5,70,8],[71,5,71,8],[45,9,45,11],[47,9,47,11],[54,1,56,1],[54,2,56,5],[60,1,62,1],[60,2,62,5],[72,5,72,8],[43,1,43,9],[25,5,27,8],[20,9,20,12],[23,9,23,12],[25,9,25,12],[26,9,26,12],[24,9,24,12],[27,9,27,12],[29,1,29,4],[29,5,29,8],[31,1,33,4],[31,5,33,8],[57,1,59,1],[57,2,59,5],[37,1,39,4],[37,5,39,8],[37,9,37,12],[83,13,83,16],[86,13,86,16],[29,9,29,12],[36,9,36,12],[36,13,36,16],[29,13,29,16],[31,9,31,12],[31,13,31,16],[32,9,32,12],[32,13,32,16],[33,9,33,12],[33,13,33,16],[37,13,37,16],[38,9,38,12],[38,13,38,16],[39,9,39,12],[39,13,39,16],[11,1,11,13],[21,9,21,12],[13,1,13,4],[15,1,15,4],[13,5,13,8],[15,5,15,8],[22,1,24,4],[22,9,22,12],[25,1,27,4],[19,5,21,8],[22,5,24,8],[13,9,13,11],[15,9,15,11],[87,13,87,16],[88,13,88,16],[89,13,89,16],[17,9,17,12],[19,9,19,12],[17,1,17,4],[17,5,17,8],[19,1,21,4],[80,1,80,4],[78,1,78,13],[65,1,65,4],[67,1,69,4],[67,5,67,8],[68,5,68,8],[34,1,36,4],[34,5,36,8],[34,9,34,12],[34,13,34,16],[35,9,35,12],[35,13,35,16],[84,13,84,16],[85,13,85,16],[81,13,81,16],[82,13,82,16]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"SECCIÓN N° 05: PROBLEMA/OBJETIVO"]
[]
[null,"5.01 DEFINICIÓN DEL PROBLEMA, SUS CAUSAS Y EFECTOS"]
[]
[null,"Descripción del problema central",null,null,null,"Indicador ",null,null,null,"Descripción del indicador",null,null,"UM","Valor"]
[]
[]
[]
[null,"Causas Directas (CD)",null,null,null,"Sustento (evidencias)",null,null,null,"Causas indirectas (CI)"]
[]
[null,"C.D 1:",null,null,null,null,null,null,null,"C.I. 1.1"]
[null,null,null,null,null,null,null,null,null,"…"]
[null,null,null,null,null,null,null,null,null,"C.I. 1.n"]
[null,"…",null,null,null,null,null,null,null,"…"]
[null,null,null,null,null,null,null,null,null,"…"]
[null,null,null,null,null,null,null,null,null,"…"]
[null,"C.D \"n\":",null,null,null,null,null,null,null,"C.I. n.1"]
[null,null,null,null,null,null,null,null,null,"…"]
[null,null,null,null,null,null,null,null,null,"C.I. n.n"]
[]
[null,"Efectos Directos (ED)",null,null,null,"Sustento (evidencias)",null,null,null,"Efectos Indirectos (EI)",null,null,null,"Sustento (evidencias)"]
[]
[null,"E.D 1:",null,null,null,null,null,null,null,"E.I. 1.1"]
[null,null,null,null,null,null,null,null,null,"…"]
[null,null,null,null,null,null,null,null,null,"E.I. 1.n"]
[null,"…",null,null,null,null,null,null,null,"…"]
[null,null,null,null,null,null,null,null,null,"…"]
[null,null,null,null,null,null,null,null,null,"…"]
[null,"E.D \"n\":",null,null,null,null,null,null,null,"E.I. n.1"]
[null,null,null,null,null,null,null,null,null,"…"]
[null,null,null,null,null,null,null,null,null,"E.I. n.n"]
[]
[]
[]
[null,"5.02 DEFINICIÓN DE LOS OBJETIVOS DEL PROYECTO"]
[]
[null,"Descripción del objetivo central",null,null,null,"Indicador* ",null,null,null,"Descripción del indicador*",null,null,"UM*","Valor*"]
[]
[]
[null,"* Esta información proviene de la información registrada en la tabla 1.04"]
[]
[null,"Medios fundamentales"]
[]
[null,"N°","Medios fundamentales (componentes)",null,null,null,"Acciones"]
[]
[null,1]
[]
[]
[null,"…"]
[]
[]
[null,"n"]
[]
[null,"n"]
[]
[]
[null,"Fines directos (FD)",null,null,null,"Fines Indirectos (FI)"]
[]
[null,"F.D 1:",null,null,null,"F.I. 1.1"]
[null,null,null,null,null,"…"]
[null,null,null,null,null,"F.I. 1.n"]
[null,"…",null,null,null,"…"]
[null,null,null,null,null,"…"]
[null,null,null,null,null,"…"]
[null,"F.D \"n\":",null,null,null,"F.I. n.1"]
[null,null,null,null,null,"…"]
[null,null,null,null,null,"F.I. n.n"]
[]
[]
[null,"5.03 DESCRIPCIÓN DE LAS ALTERNATIVAS DE SOLUCIÓN AL PROBLEMA"]
[]
[null,"Alternativas",null,null,null,"Acciones excluyentes (Ae)",null,null,null,"Acciones independientes (Ai)",null,null,null,"Acciones complementarias (Ac)"]
[null,"Alternativa 1",null,null,null,"Ae 1",null,null,null,"Ai 1",null,null,null,"Ac 1"]
[null,null,null,null,null,"…",null,null,null,"…",null,null,null,"…"]
[null,null,null,null,null,"Ae \"n\"",null,null,null,"Ai \"n\"",null,null,null,"Ac \"n\""]
[null,"…",null,null,null,"…",null,null,null,"…",null,null,null,"…"]
[null,null,null,null,null,"…",null,null,null,"…",null,null,null,"…"]
[null,null,null,null,null,"…",null,null,null,"…",null,null,null,"…"]
[null,"Alternativa \"n\"",null,null,null,"Ae 1",null,null,null,"Ai 1",null,null,null,"Ac 1"]
[null,null,null,null,null,"…",null,null,null,"…",null,null,null,"…"]
[null,null,null,null,null,"Ae \"n\"",null,null,null,"Ai \"n\"",null,null,null,"Ac \"n\""]

{"sheet":"HORIZONTE DE EVALUACIÓN","index":6,"n_rows":31,"n_cols":10,"rows_kept":31,"cut":false,"hidden":false,"merged":[[14,1,14,12],[17,1,18,12],[27,1,28,5],[27,7,28,7],[27,9,28,9]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"SECCIÓN N°06: HORIZONTE DE EVALUACIÓN"]
[]
[null,"FORMULACIÓN"]
[]
[null,"6.01 HORIZONTE DE EVALUACIÓN"]
[null,null,null,null,null,null,null,"Alternativa 1",null,"Alternativa n"]
[null,"Periodo en años de la ejecución del proyecto"]
[null,"Nota: Debe considerar los plazos del Estudios Definitivos (incluyendo los plazos de contratación) y la Ejecución Física (Incluye los plazos de contratación y liquidación)"]
[]
[null,"Periodo en años del funcionamiento del proyecto",null,null,null,null,null,{"$f":"+MIN(H22,H28)","v":0},null,{"$f":"+MIN(J22,J28)","v":0}]
[]
[null,"a) La vida útil de los activos principales: ",null,null,null,null,null,{"$f":"+MAX(H24:H26)","v":0},null,{"$f":"+MAX(J24:J26)","v":0}]
[]
[null,"     Infraestructura: Vida útil de diseño"]
[null,"     Tecnología: Por obsolescencia tecnológica"]
[null,"     Otros"]
[]
[null,"b) Tiempo esperado que durará la demanda por \n    el bien o el servicio a proveer."]
[]
[]
[null,"Número de años del horizonte de evaluación",null,null,null,null,null,{"$f":"+H17+H20","v":0},null,{"$f":"+J17+J20","v":0}]

{"sheet":"BRECHA DE SERVICIO","index":7,"n_rows":82,"n_cols":13,"rows_kept":82,"cut":false,"hidden":false,"merged":[[50,11,50,12],[52,11,53,12],[54,11,55,12],[57,11,57,12],[34,7,34,9],[32,7,32,9],[50,6,50,7],[52,6,53,7],[54,6,55,7],[50,8,50,10],[52,8,52,10],[53,8,53,10],[54,8,54,10],[55,8,55,10],[37,1,37,12],[41,2,41,3],[43,2,43,3],[44,2,44,3],[46,2,46,3],[50,4,50,5],[52,3,53,3],[68,2,68,3],[79,2,79,3],[69,2,69,3],[80,2,80,3],[70,2,70,3],[71,2,71,3],[74,3,74,8],[75,2,75,3],[77,2,77,3],[78,2,78,3],[57,3,57,5],[54,4,55,5],[54,3,55,3],[62,1,62,12],[66,2,66,3],[57,6,57,7],[57,8,57,10],[34,4,34,6],[45,2,45,3],[24,1,24,2],[25,1,25,2],[26,1,26,2],[27,1,27,2],[52,4,53,5],[50,1,50,2],[52,1,55,2],[14,1,14,12],[17,1,17,12],[30,1,30,3],[30,4,30,6],[30,7,30,9],[21,1,21,2],[23,1,23,2],[32,1,32,3],[33,1,33,3],[34,1,34,3],[32,4,32,6],[33,4,33,6],[33,7,33,9]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"SECCIÓN N°07: BRECHA DE SERVICIO"]
[]
[null,"FORMULACIÓN"]
[]
[]
[null,"ESTUDIO DE MERCADO DEL SERVICIO PÚBLICO"]
[]
[null,"7.01 Definición y caracterización del servicio o de la cartera de servicios"]
[]
[]
[null,"7.02 Análisis de la demanda del servicio "]
[]
[null,"Tipo de población",null,"Año 1","Año 2","Año 3","…","…","…","…","…","…","Año n"]
[]
[null,"Población total"]
[null,"Población de referencia"]
[null,"Población demandante potencial"]
[null,"Población demandante efectiva"]
[null,"Población demandante objetivo"]
[null,"* Nota: Replicar el llenado cuando existen diferentes grupos de población."]
[]
[null,"Variables para la estimación de la demanda",null,null,"Tasa de crecimiento anual",null,null,"Consumo per cápita"]
[]
[null,"Servicio 1"]
[null,"Servicio 2"]
[null,"Servicio \"n\""]
[]
[null,"Parámetros, supuestos considerados y fuentes de información"]
[]
[]
[null,"7.03 Proyección de la demanda del servicio"]
[]
[null,"Servicio","Descripción",null,"Unidad de Medida","Año 1","Año 2","Año 3","….","….","….","….","Año n"]
[]
[null,"Servicio 1"]
[null,"Servicio 2"]
[null,"Servicio 3"]
[null,"Servicio \"n\""]
[]
[null,"7.04 Estimación de la oferta optimizada (sin proyecto)"]
[]
[null,"Servicio*",null,"UM","Activos estratégicos esenciales ",null,"Capacidad actual**",null,"Acciones de optimización",null,null,"Capacidad optimizada**"]
[]
[]
[]
[]
[]
[]
[null,null,null,"Total capacidad actual",null,null,null,null,"Total capacidad optimizada"]
[null,"* Nota: Replicar el llenado del cuadro cuando existe más de un servicio intervenido con el proyecto."]
[null,"**Nota: La unidad de medida de la capacidad de producción es la misma que la del balance oferta demanda"]
[]
[null,"Parámetros, supuestos considerados y fuentes de información"]
[]
[]
[null,"7.05 Proyección de la oferta del servicio"]
[]
[null,"Servicio","Descripción",null,"Unidad de Medida","Año 1","Año 2","Año 3","….","….","….","….","Año n"]
[]
[null,"Servicio 1"]
[null,"Servicio 2"]
[null,"Servicio 3"]
[null,"Servicio \"n\""]
[]
[null,"7.06 Brecha del servicio (balance oferta optimizada sin proyecto-demanda con proyecto)"]
[]
[null,"Servicios con brecha","Descripción",null,"Unidad de Medida","Año 1","Año 2","Año 3","….","….","….","….","Año 10"]
[]
[null,"Servicio 1"]
[null,"Servicio 2"]
[null,"Servicio 3"]
[null,"Servicio \"n\""]
[null,"*Nota: Los servicios con brecha corresponden a los servicios públicos con indicadores de cobertura"]

{"sheet":"ANALISIS TÉCNICO","index":8,"n_rows":135,"n_cols":14,"rows_kept":135,"cut":false,"hidden":false,"merged":[[98,1,98,13],[110,11,110,12],[111,11,111,12],[110,13,110,14],[111,13,111,14],[21,2,21,4],[112,11,112,12],[112,13,112,14],[107,11,108,12],[107,13,108,14],[107,1,108,2],[110,1,111,2],[112,1,112,2],[108,5,108,6],[110,5,110,6],[111,5,111,6],[107,9,108,10],[112,9,112,10],[110,9,110,10],[111,9,111,10],[41,2,41,4],[41,5,41,6],[27,1,28,11],[37,2,37,4],[37,5,37,6],[39,2,39,4],[39,5,39,6],[40,2,40,4],[40,5,40,6],[111,7,111,8],[105,1,105,13],[112,5,112,6],[108,3,108,4],[110,3,110,4],[111,3,111,4],[112,3,112,4],[112,7,112,8],[92,11,92,13],[93,11,93,13],[94,11,94,13],[83,11,83,13],[84,11,84,13],[85,11,85,13],[107,3,107,8],[108,7,108,8],[110,7,110,8],[81,6,81,7],[87,6,87,7],[92,6,92,7],[93,6,93,7],[94,6,94,7],[51,8,51,10],[54,6,54,7],[55,6,55,7],[56,6,56,7],[57,6,57,7],[58,6,58,7],[59,6,59,7],[60,6,60,7],[61,6,61,7],[62,6,62,7],[63,6,63,7],[64,6,64,7],[65,6,65,7],[66,6,66,7],[73,6,73,7],[67,6,67,7],[68,6,68,7],[69,6,69,7],[70,6,70,7],[84,4,85,5],[86,4,86,5],[75,4,75,5],[76,4,76,5],[77,4,77,5],[78,4,78,5],[79,4,80,5],[81,4,81,5],[82,4,83,5],[84,2,88,3],[89,2,93,3],[94,2,94,3],[54,4,56,5],[57,4,57,5],[58,4,60,5],[61,4,62,5],[63,4,63,5],[64,4,66,5],[67,4,69,5],[71,4,73,5],[70,4,70,5],[74,4,74,5],[87,4,88,5],[89,4,90,5],[91,4,91,5],[92,4,93,5],[94,4,94,5],[54,2,60,3],[61,2,66,3],[67,2,73,3],[74,2,74,3],[75,2,75,3],[76,2,76,3],[130,5,130,6],[131,5,131,6],[132,5,132,6],[120,3,121,4],[123,3,123,4],[124,3,124,4],[125,3,125,4],[126,3,126,4],[127,3,127,4],[128,3,128,4],[129,3,129,4],[130,3,130,4],[131,1,131,2],[132,1,132,2],[123,5,123,6],[124,5,124,6],[119,1,119,4],[119,5,121,6],[119,7,120,8],[119,9,120,10],[120,1,121,2],[123,1,123,2],[124,1,124,2],[125,1,125,2],[126,1,126,2],[127,1,127,2],[128,1,128,2],[129,1,129,2],[130,1,130,2],[131,3,131,4],[132,3,132,4],[125,5,125,6],[126,5,126,6],[127,5,127,6],[128,5,128,6],[129,5,129,6],[86,11,86,13],[87,11,87,13],[88,11,88,13],[89,11,89,13],[90,11,90,13],[91,11,91,13],[74,11,74,13],[82,6,82,7],[83,6,83,7],[84,6,84,7],[85,6,85,7],[86,6,86,7],[82,11,82,13],[88,6,88,7],[89,6,89,7],[90,6,90,7],[91,6,91,7],[81,11,81,13],[78,11,78,13],[79,11,79,13],[80,11,80,13],[54,11,54,13],[55,11,55,13],[56,11,56,13],[57,11,57,13],[58,11,58,13],[59,11,59,13],[60,11,60,13],[61,11,61,13],[62,11,62,13],[64,11,64,13],[65,11,65,13],[66,11,66,13],[67,11,67,13],[68,11,68,13],[69,11,69,13],[70,11,70,13],[71,11,71,13],[77,11,77,13],[75,11,75,13],[76,11,76,13],[30,1,30,13],[31,1,31,13],[23,2,23,4],[24,2,24,4],[25,2,25,4],[51,11,52,13],[12,1,13,12],[80,6,80,7],[63,11,63,13],[71,6,71,7],[72,6,72,7],[74,6,74,7],[75,6,75,7],[76,6,76,7],[77,6,77,7],[78,6,78,7],[79,6,79,7],[51,1,52,1],[51,2,52,3],[51,4,52,5],[77,2,77,3],[78,2,78,3],[79,2,83,3],[51,6,52,7],[113,1,113,14],[100,1,103,12],[41,7,41,8],[44,1,45,11],[26,1,26,10],[16,1,17,12],[19,1,20,12],[18,1,18,12],[32,1,33,12],[34,1,34,12],[35,1,36,12],[21,7,21,8],[23,7,23,8],[24,7,24,8],[25,7,25,8],[37,7,37,8],[39,7,39,8],[40,7,40,8],[79,1,94,1],[75,1,78,1],[47,1,47,13],[54,1,74,1],[72,11,72,13],[73,11,73,13]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"SECCIÓN N°08: ANÁLISIS TÉCNICO"]
[]
[null,"ANÁLISIS TÉCNICO"]
[null,"Este análisis sustenta la elección de una alternativa técnica de tamaño, localización y tecnología, en mérito a las características particulares de cada tipología de proyecto de inversión. "]
[]
[null,"8.01 ANÁLISIS DE TAMAÑO (¿Cuánto producir?)"]
[]
[null,"Indicar el criterio o factor condicionante del tamaño del proyecto. "]
[]
[]
[null,"Solo en los casos que sea posible analizar más de una alternativa de tamaño, se debe describir tales alternativas de tamaño en la siguiente tabla:"]
[]
[null,"N° ","Alternativa de tamaño",null,null,"Unidad de Medida","Valor*","Criterio o factor condicionante empleado**"]
[]
[null,1]
[null,2]
[null,"…"]
[null,"*El tamaño se define como la capacidad de producción (oferta del servicio con proyecto)  en un periodo de referencia. "]
[null,"** Los criterios o factores condicionantes del tamaño del proyecto pueden ser: Brecha de servicio - último año del horizonte de evaluación, posibilidades de implementación modular o escalonado, estacionalidad, economías de escala, periodo óptimo de diseño, tecnología, disposición de insumos, etc.."]
[]
[]
[null,"8.02 ANÁLISIS DE LOCALIZACIÓN (¿Dónde producir?)"]
[]
[null,"Indicar el criterio o factor condicionante de la localización del proyecto. "]
[]
[]
[null,"Solo en los casos que sea posible analizar más de una alternativa de localización, se debe describir tales alternativas de localización en la siguiente tabla:"]
[]
[null,"N°","Descripción de las alternativas de localización",null,null,"Coordenadas*",null,"Criterio o factor condicionante empleado**"]
[]
[null,1]
[null,2]
[null,"…"]
[]
[null,"*Adjuntar el documento sobre el saneamiento físico legal o los arreglos institucionales, en caso corresponda"]
[null,"**Nota: Precisar el criterio con el cual se define la localización del proyecto (p.ej. ubicación de la población objetivo, condiciones climáticas y ambientales, condiciones topográficas, disponibilidad de infraestructura y servicios públicos domiciliarios, existencia de vías de comunicación y medios de transporte, planes reguladores municipales y de ordenamiento urbano, etc.)."]
[]
[]
[null,"8.03 ANÁLISIS DE TECNOLOGÍA (¿Cómo producir?)"]
[]
[null,"Descripción del proceso de producción del servicio (con proyecto)"]
[]
[null,"Procesos","Tipo de Factor productivo",null,"Activo estratégicos esenciales",null,"Tipo de tecnología",null,"Factores relevantes que condicionan la tecnología",null,null,"Sustento"]
[null,null,null,null,null,null,null,null,"Factor 1","Factor 2","Factor 3"]
[]
[null,"Proceso 1","Infraestructura",null,"Activo 1",null,"1)"]
[null,null,null,null,null,null,"2)"]
[null,null,null,null,null,null,"…"]
[null,null,null,null,"…",null,"…"]
[null,null,null,null,"Activo \"n\"",null,"1)"]
[null,null,null,null,null,null,"2)"]
[null,null,null,null,null,null,"…"]
[null,null,"Equipo",null,"Activo 1",null,"1)"]
[null,null,null,null,null,null,"2)"]
[null,null,null,null,"…",null,"…"]
[null,null,null,null,"Activo \"n\"",null,"1)"]
[null,null,null,null,null,null,"2)"]
[null,null,null,null,null,null,"…"]
[null,null,"Intangibles",null,"Activo 1",null,"1)"]
[null,null,null,null,null,null,"2)"]
[null,null,null,null,null,null,"…"]
[null,null,null,null,"…",null,"…"]
[null,null,null,null,"Activo \"n\"",null,"1)"]
[null,null,null,null,null,null,"2)"]
[null,null,null,null,null,null,"…"]
[null,null,"Otros",null,"…",null,"…"]
[null,"…","…",null,"…",null,"…"]
[null,null,"…",null,"…",null,"…"]
[null,null,"…",null,"…",null,"…"]
[null,null,"…",null,"…",null,"…"]
[null,"Proceso \"n\"","Infraestructura",null,"Activo 1",null,"…"]
[null,null,null,null,null,null,"…"]
[null,null,null,null,"…",null,"…"]
[null,null,null,null,"Activo \"n\"",null,"…"]
[null,null,null,null,null,null,"…"]
[null,null,"Equipo",null,"Activo 1"]
[null,null,null,null,null,null,"…"]
[null,null,null,null,"…",null,"…"]
[null,null,null,null,"Activo \"n\""]
[null,null,null,null,null,null,"…"]
[null,null,"Intangibles",null,"Activo 1"]
[null,null,null,null,null,null,"…"]
[null,null,null,null,"…"]
[null,null,null,null,"Activo \"n\""]
[null,null,null,null,null,null,"…"]
[null,null,"Otros",null,"…",null,"…"]
[]
[null,"8.04 IDENTIFICACIÓN DE MEDIDAS DE REDUCCIÓN DEL RIESGO DE DESASTRES"]
[]
[null,"Descripción de las medidas de reducción del riesgo de desastres (asociadas al análisis de la exposición y fragilidad de la UP sujeta de intervención y de la resiliencia de la población afectada)."]
[]
[]
[]
[]
[]
[]
[null,"8.05 RESUMEN DE LAS ALTERNATIVAS TÉCNICAS"]
[]
[null,"Descripción de alternativas de solución",null,"Alternativas técnicas",null,null,null,null,null,"Resultado final*\n",null,"Resumen de las características relevantes del diseño técnico preliminar",null,"Documentos que respaldan el planteamiento del diseño técnico preliminar"]
[null,null,null,"Tamaño ",null,"Localización ",null,"Tecnología "]
[]
[null,"Nombre de la alternativa de solución 1",null,"Tamaño 1",null,"Localización 1",null,"Tecnología 1"]
[null,null,null,"…",null,"…",null,"…",null,"…",null,"…",null,"…"]
[null,"…",null,"…",null,"…",null,"…",null,"…",null,"…",null,"…"]
[null,"* Descripción de la alternativa de solución al que se le agrega cada uno de los aspectos técnicos analizados (tamaño, localización y tecnología, -incluye medidas de reducción de riesgo- de corresponder) y que será evaluada en la Sección 10 \"Evaluación Social\"."]
[]
[]
[]
[null,"8.06 METAS FISICAS DE LOS ACTIVOS QUE SE BUSCAN CREAR O INTERVENIR CON EL PROYECTO*"]
[]
[null,"Acción sobre el activo",null,null,null,"Tipo de factor productivo",null,"Unidad Física",null,"Dimensión física"]
[null,"Acción",null,"Activos estratégicos esenciales"]
[null,null,null,null,null,null,null,"Unidad de \nmedida","Cantidad","Unidad de \nmedida","Cantidad"]
[]
[null,"Construcción",null,"Aulas",null,"Infraestructura",null,"Nro estructuras físicas",20,"m2",650]
[null,"Adquisición",null,"Mobiliario",null,"Mobiliario",null,"Nro mobiliario",100]
[null,"Acción3"]
[null,"Acción4"]
[null,"Acción5"]
[null,"Acción6"]
[null,"Acción7"]
[null,"…"]
[null,"…"]
[null,"Acción n"]
[null,"Nota: este cuadro se repite por cada unidad productora intervenida por el proyecto de inversión"]
[null,"La estimación de los costos deberá ser sustentada a nivel de ingeniería conceptual"]

{"sheet":"COSTO TOTAL","index":9,"n_rows":142,"n_cols":17,"rows_kept":142,"cut":false,"hidden":false,"merged":[[113,11,113,12],[114,1,114,10],[114,11,114,12],[116,1,116,10],[116,11,116,12],[72,3,72,4],[73,3,73,4],[64,3,64,4],[65,3,65,4],[69,3,69,4],[70,3,70,4],[71,3,71,4],[74,3,74,4],[75,3,75,4],[78,1,79,2],[78,3,78,4],[79,3,79,4],[68,3,68,4],[71,1,77,2],[98,6,98,7],[83,1,83,7],[112,11,112,12],[110,11,110,12],[49,3,50,3],[49,4,50,4],[58,1,58,5],[66,3,66,4],[67,3,67,4],[61,5,61,13],[61,3,62,4],[58,6,58,7],[57,6,57,7],[61,1,62,2],[64,1,70,2],[49,5,49,13],[57,1,57,5],[76,3,76,4],[77,3,77,4],[40,1,40,3],[14,10,14,11],[15,10,16,10],[15,11,16,11],[45,4,45,5],[43,4,43,5],[35,4,35,5],[37,4,37,5],[38,4,38,5],[14,1,14,5],[15,4,16,5],[19,4,19,5],[20,4,20,5],[22,4,22,5],[23,4,23,5],[43,1,43,3],[45,1,45,3],[41,1,41,3],[49,1,50,2],[52,1,52,2],[53,1,53,2],[54,1,54,2],[28,12,28,13],[26,1,26,3],[26,4,26,5],[25,6,25,7],[14,13,16,13],[14,6,16,7],[18,6,18,7],[19,6,19,7],[20,6,20,7],[14,8,14,9],[22,6,22,7],[23,6,23,7],[14,12,16,12],[15,1,16,3],[19,1,19,3],[20,1,20,3],[22,1,22,3],[23,1,23,3],[25,1,25,3],[89,16,91,17],[101,1,101,3],[101,4,101,5],[101,6,101,7],[99,1,99,3],[99,4,99,5],[99,6,99,7],[100,1,100,3],[13,1,13,5],[18,1,18,5],[21,1,21,5],[28,1,28,11],[48,1,48,5],[56,1,56,7],[35,1,35,3],[37,1,37,3],[38,1,38,3],[39,1,39,3],[39,4,39,5],[41,4,41,5],[25,4,25,5],[15,8,16,8],[15,9,16,9],[21,6,21,7],[85,5,85,6],[86,5,86,6],[87,5,87,6],[103,1,103,3],[103,4,103,5],[103,6,103,7],[90,12,91,12],[96,1,96,3],[90,11,91,11],[93,1,93,3],[93,4,93,5],[93,6,93,7],[94,1,94,3],[94,4,94,5],[94,6,94,7],[134,5,134,6],[135,5,135,6],[134,3,134,4],[135,3,135,4],[134,1,134,2],[135,1,135,2],[97,1,97,3],[97,4,97,5],[97,6,97,7],[100,6,100,7],[98,1,98,3],[98,4,98,5],[112,1,112,2],[113,1,113,10],[117,1,117,13],[141,1,142,16],[136,7,136,8],[137,7,137,8],[138,7,138,8],[139,7,139,8],[140,7,140,8],[138,1,138,2],[139,1,139,2],[140,1,140,2],[138,3,138,4],[139,3,139,4],[140,3,140,4],[136,5,136,6],[137,5,137,6],[136,3,136,4],[137,3,137,4],[138,5,138,6],[136,1,136,2],[139,5,139,6],[140,5,140,6],[137,1,137,2],[129,5,132,6],[129,7,132,8],[129,9,130,15],[129,16,132,16],[108,1,108,2],[108,11,108,12],[98,16,98,17],[99,16,99,17],[127,1,127,7],[130,3,132,4],[130,1,132,2],[100,16,100,17],[101,16,101,17],[104,16,104,17],[111,11,111,12],[100,4,100,5],[134,7,134,8],[135,7,135,8],[109,1,109,2],[125,4,125,6],[123,4,123,6],[129,1,129,4],[110,1,110,2],[106,1,106,2],[106,11,106,12],[111,1,111,2],[104,1,104,15],[96,4,96,5],[96,6,96,7],[93,16,93,17],[94,16,94,17],[95,16,95,17],[96,16,96,17],[97,16,97,17],[95,1,95,3],[95,4,95,5],[103,16,103,17],[89,8,89,15],[90,9,91,9],[90,10,91,10],[95,6,95,7],[90,13,91,13],[90,14,91,14],[90,15,91,15],[89,1,89,5],[109,11,109,12],[90,8,91,8],[89,6,91,7],[90,1,91,3],[90,4,91,5]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"SECCIÓN N°09: COSTOS DEL PROYECTO"]
[]
[null,"Estructura de costos de inversión"]
[]
[null,"9.01 Costo de ejecución física de las acciones"]
[null,"Acción sobre los activos",null,null,null,null,"Tipo de factor productivo",null,"Unidad Física",null,"Dimensión Física",null,"Costo unitario","Costo total*"]
[null,"Acción",null,null,"Activos ",null,null,null,"Unidad de \nmedida","Cantidad","Unidad de \nmedida","Cantidad"]
[]
[]
[null,"Componente 1:"]
[null,"Nombre de la acción \"x\"",null,null,"Nombre del activo \"y\" creado o intervenido"]
[null,"…",null,null,"…"]
[null,"Componente 2"]
[null,"Nombre de la acción \"x\"",null,null,"Nombre del activo \"y\" creado o intervenido"]
[null,"…",null,null,"…"]
[null,"Medidas de reducción del riesgo de desastre y mitigación ambiental"]
[null,"Nombre de la acción \"x\"",null,null,"Nombre del activo \"y\" creado o intervenido"]
[null,"…",null,null,"…"]
[]
[null,"Sub Total de costos de inversión"]
[null,"*Según corresponda "]
[null,"Nota: este cuadro se repite por cada unidad productora intervenida por el proyecto de inversión"]
[null,"La estimación de los costos deberá ser sustentada a nivel de ingeniería conceptual"]
[]
[null,"Otros costos de inversión"]
[]
[null,"Otros costos",null,null,"Costos a precios de mercado"]
[]
[null,"Gestión del proyecto"]
[null,"Expediente técnico o documento equivalente"]
[null,"Supervisión"]
[null,"Liquidación"]
[null,"Otros (línea de base, etc.)"]
[]
[null,"Subtotal de otros costos de inversión",null,null,{"$f":"+SUM(E38:E42)","v":0}]
[]
[null,"Costo Total de inversión",null,null,{"$f":"+E44+M29","v":0},null,"Anexar los costos detallados"]
[]
[]
[null,"9.02 Costos de reinversión"]
[null,"Activos",null,"UM","Cantidad","AÑOS (Soles)"]
[null,null,null,null,null,1,2,3,4,5,"…","…","…","n"]
[]
[null,"a1"]
[null,"a2","a2"]
[null,"…","…"]
[]
[null,"9.03 Costos de operación y mantenimiento con y sin proyecto"]
[null,"Fecha prevista de inicio de operaciones:  (mes / año): "]
[null,"Horizonte de funcionamiento (años)"]
[]
[]
[null,"COSTOS*",null,"ÍTEM",null,"AÑOS (Soles)"]
[null,null,null,null,null,1,2,3,4,5,"…","…","…","n"]
[]
[null,"SIN PROYECTO",null,"OPERACIÓN"]
[null,null,null,"Personal"]
[null,null,null,"Bienes"]
[null,null,null,"Servicios"]
[null,null,null,"Otros"]
[null,null,null,"MANTENIMIENTO"]
[null,null,null,"Actividades"]
[null,"CON PROYECTO",null,"OPERACIÓN"]
[null,null,null,"Personal"]
[null,null,null,"Bienes"]
[null,null,null,"Servicios"]
[null,null,null,"Otros"]
[null,null,null,"MANTENIMIENTO"]
[null,null,null,"Actividades"]
[null,"INCREMENTAL",null,"OPERACIÓN"]
[null,null,null,"MANTENIMIENTO"]
[]
[null,"* Agregar anexo de costos"]
[]
[null,"9.04 Cronograma de inversión de metas financieras"]
[]
[null,"Fecha prevista de inicio de ejecución:",null,null,null,null,null,"(mes y año)"]
[null,"Tipo de periodo"]
[null,"Número de periodos",null,null,null,null,null,"(valor)"]
[]
[null,"Acción sobre los activos",null,null,null,null,"Tipo de factor productivo",null,"Cronograma de inversión",null,null,null,null,null,null,null,"Costo estimado de inversión a precios de mercado (Soles)"]
[null,"Componente /acción",null,null,"Activos ",null,null,null,1,2,3,"……….","……….","……….","……….","n"]
[]
[]
[null,"Componente 1:"]
[null,"Nombre de la acción \"x\"",null,null,"Nombre del activo \"y\" creado o intervenido"]
[null,"…"]
[null,"Componente 2"]
[null,"Nombre de la acción \"x\"",null,null,"Nombre del activo \"y\" creado o intervenido"]
[null,"…"]
[null,"Componente \"n\""]
[null,"Nombre de la acción \"x\"",null,null,"Nombre del activo \"y\" creado o intervenido"]
[null,"…"]
[null,"Medidas de reducción del riesgo de desastre y mitigación ambiental"]
[null,"Nombre de la acción \"x\"",null,null,"Nombre del activo \"y\" creado o intervenido"]
[null,"Sub total :",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"A"]
[]
[null,"Otros costos",null,1,2,3,"……….","……….","……….","……….","n","Costos a precio de mercado"]
[]
[null,"Gestión del proyecto"]
[null,"Expediente técnico"]
[null,"Supervisión"]
[null,"Liquidación"]
[null,"Estudio de Línea Base"]
[null,"Sub total :",null,null,null,null,null,null,null,null,null,"B"]
[null,"Costo total de inversión:",null,null,null,null,null,null,null,null,null,"A+B"]
[]
[null,"Control concurrente*",null,null,null,null,null,null,null,null,null,"Hasta el 2%*(A+B) =C"]
[null,"Nota: La gestión del proyecto, el expediente técnico o documento equivalente, la supervisión y la liquidación no son ítems. \nLos gastos generales, la utilidad y el IGV forman parte de los ítem."]
[null,"*Máximo hasta el 2% del costo total de inversión cuando supere los 10 MM"]
[]
[null,"Monto de inversión financiados con fondos públicos"]
[null,"¿El proyecto tiene aporte de los beneficiarios?"]
[]
[null,"SI",null,null,"Aporte de los beneficiarios (S/):"]
[]
[null,"NO",null,null,"Financiado con fondos públicos (S/):"]
[]
[null,"9.05 Cronograma de metas físicas"]
[]
[null,"Acción sobre los activos",null,null,null,"Tipo de factor productivo",null,"Unidad de medida representativa",null,"Periodo",null,null,null,null,null,null,"Total Meta Física"]
[null,"Acción",null,"Activos "]
[null,null,null,null,null,null,null,null,null,"Periodo 1","Periodo 2","…","…","…","…","Periodo n"]
[null,null,null,null,null,null,null,null,null,"Meta física","Meta física","Meta física","Meta física","Meta física","Meta física","Meta física"]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Nota: La unidad de medida representativa proviene de las unidades físicas, a excepción del ítem de Infraestructura que proviene de las dimensiones físicas."]

{"sheet":"EVALUACION SOCIAL","index":10,"n_rows":148,"n_cols":13,"rows_kept":148,"cut":false,"hidden":false,"merged":[[23,7,23,9],[23,10,23,12],[20,7,20,9],[20,10,20,12],[21,7,21,9],[21,10,21,12],[22,7,22,9],[22,10,22,12],[20,2,20,3],[21,2,21,3],[22,2,22,3],[23,2,23,3],[17,4,17,6],[18,4,18,6],[19,4,19,6],[20,4,20,6],[21,4,21,6],[22,4,22,6],[23,4,23,6],[17,2,17,3],[18,2,18,3],[19,2,19,3],[17,7,17,9],[17,10,17,12],[18,7,18,9],[18,10,18,12],[19,7,19,9],[19,10,19,12],[130,1,130,7],[141,1,147,1],[132,1,132,12],[133,1,133,12],[134,1,136,12],[138,1,138,9],[139,1,140,2],[139,3,139,9],[125,1,128,1],[125,2,125,4],[126,2,126,4],[127,2,127,4],[128,2,128,4],[107,1,107,12],[108,1,108,12],[116,1,116,12],[120,2,120,4],[122,1,124,1],[122,2,122,4],[123,2,123,4],[124,2,124,4],[118,1,118,12],[33,1,33,12],[102,1,102,12],[42,3,47,3],[49,2,52,2],[65,3,67,3],[69,3,74,3],[76,3,81,3],[83,3,88,3],[91,3,96,3],[99,1,99,12],[11,1,11,12],[13,1,13,12],[15,2,15,3],[15,4,15,6],[15,7,15,9],[15,10,15,12]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"SECCIÓN N°10: EVALUACIÓN SOCIAL"]
[]
[null,"EVALUACIÓN"]
[]
[null,"10.01 BENEFICIOS SOCIALES"]
[]
[null,"Procedencia de los beneficios","Tipo de beneficio",null,"Descripción",null,null,"Procedimiento de cálculo",null,null,"Fuentes de información"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Años",1,2,3,null,null,null,"…","…","…","n"]
[null,"Beneficios directos"]
[null,"Beneficios indirectos"]
[null,"Externalidades positivas"]
[null,"Intangibles"]
[null,"* Sólo si corresponde a la tipología del proyecto se cuantifican los beneficios sociales, caso contrario solo se describen cualitativamente en la columna \"Descripción\" y se pasa directamente a la tabla 10.02 ."]
[]
[null,"10.02 COSTOS SOCIALES"]
[]
[null,"Transformación de precios de mercado a precios sociales"]
[]
[null,"Costos de inversión a precios sociales"]
[]
[null,"Acciones","Composición porcentual","Costo total a precios de mercado","Factor de corrección* ","Costo a precios sociales "]
[]
[null,"Acción 1"]
[null,"Insumo no transable",null,null,{"$f":"1/1.18","v":0.84745762711864414}]
[null,"Insumo transable**"]
[null,"Mano de obra calificada",null,null,1]
[null,"Mano de obra semicalificada"]
[null,"Mano de obra no calificada***"]
[null,"Combustibles",null,null,{"$f":"'[1]Parámetros de evaluación social'!E6","v":0.66}]
[null,"…"]
[null,"Gestión del proyecto",null,null,{"$f":"1/1.18","v":0.84745762711864414}]
[null,"Expediente técnico",null,null,{"$f":"1/1.18","v":0.84745762711864414}]
[null,"Supervisión",null,null,{"$f":"1/1.18","v":0.84745762711864414}]
[null,"Liquidación",null,null,{"$f":"1/1.18","v":0.84745762711864414}]
[null,"Total"]
[]
[null,"* Según corresponda "]
[null,"** El valor asignado dependerá si el bien es exportado o importado."]
[null,"*** Este valor dependerá de la región geográfica y la zona que corresponda (urbano/rural)"]
[]
[null,"Costos de operación y mantenimiento a precios sociales"]
[]
[null,null,"Composición","Costo total a precios de mercado","Factor de corrección ","Costo a precios sociales "]
[]
[null,"Costos de operación incremental"]
[null,"Personal"]
[null,"Mano de obra calificada",null,null,1]
[null,"Mano de obra semicalificada"]
[null,"Mano de obra no calificada"]
[null,"Bienes"]
[null,"Insumo no transable",null,null,{"$f":"1/1.18","v":0.84745762711864414}]
[null,"Insumo transable "]
[null,"Mano de obra calificada",null,null,1]
[null,"Mano de obra semicalificada"]
[null,"Mano de obra no calificada"]
[null,"Combustibles",null,null,{"$f":"'[1]Parámetros de evaluación social'!E6","v":0.66}]
[null,"Servicios"]
[null,"Insumo no transable",null,null,{"$f":"1/1.18","v":0.84745762711864414}]
[null,"Insumo transable "]
[null,"Mano de obra calificada",null,null,1]
[null,"Mano de obra semicalificada"]
[null,"Mano de obra no calificada"]
[null,"Combustibles",null,null,{"$f":"'[1]Parámetros de evaluación social'!E6","v":0.66}]
[null,"Otros"]
[null,"Insumo no transable",null,null,{"$f":"1/1.18","v":0.84745762711864414}]
[null,"Insumo transable "]
[null,"Mano de obra calificada",null,null,1]
[null,"Mano de obra semicalificada"]
[null,"Mano de obra no calificada"]
[null,"Combustibles",null,null,{"$f":"'[1]Parámetros de evaluación social'!E6","v":0.66}]
[null,"Costos de mantenimiento incremental"]
[null,"Actividades de mantenimiento en general"]
[null,"Insumo no transable",null,null,{"$f":"1/1.18","v":0.84745762711864414}]
[null,"Insumo transable "]
[null,"Mano de obra calificada",null,null,1]
[null,"Mano de obra semicalificada"]
[null,"Mano de obra no calificada"]
[null,"Combustibles",null,null,{"$f":"'[1]Parámetros de evaluación social'!E6","v":0.66}]
[]
[]
[null,"10.03 FLUJO DE BENEFICIOS Y COSTOS A PRECIOS SOCIALES (EVALUACIÓN SOCIAL) ALTERNATIVA DE SOLUCIÓN N°__"]
[]
[null,"Años",0,1,2,3,null,null,null,"…","…","…","n"]
[null,"I. Beneficios  (+)"]
[null,"Beneficios directos"]
[null,"Beneficios indirectos"]
[null,"Externalidades positivas"]
[null,"Total beneficios*"]
[null,"* Sólo si corresponde a la tipología del proyecto"]
[null,"II. Costos de inversión, operación y mantenimiento (-) a precios sociales"]
[null,"1. Costos de inversión"]
[null,"2. Costos de reinversión"]
[null,"3. Costos de operación incremental"]
[null,"4. Costos de mantenimiento incremental"]
[null,"5. Externalidades negativas"]
[null,"Total Costos"]
[null,"Flujo de beneficios netos a precios sociales"]
[null,"Nota: se realiza por cada alternativa considerada en el proyecto"]
[]
[null,"10.04 INDICADORES DE RENTABILIDAD SOCIAL"]
[]
[null,"Tipo","Criterio de elección**",null,null,"Alternativa 1","Alternativa 2","Alternativa n"]
[]
[null,"Costo / Beneficio*","Valor Actual Neto (VAN)"]
[null,null,"Tasa Interna de Retorno (TIR)"]
[null,null,"Valor Anual Equivalente (VAE)"]
[null,"Costo / Eficiencia*","Valor Actual de los Costos (VAC)"]
[null,null,"Costo Anual Equivalente (CAE)"]
[null,null,"Costo por capacidad de producción"]
[null,null,"Costo por beneficiario directo"]
[null,"* A precios sociales"]
[null,"** En función a la tipología del proyecto se definirá cual es el criterio de elección más conveniente"]
[]
[null,"10.05 ANÁLISIS DE SENSIBILIDAD"]
[]
[null,"i) Determinar las variables (demanda, costos de los principales insumos, tarifas o precios cobrados a los usuarios, periodo de ejecución, entre otros) , cuyas variaciones pueden afectar la condición de rentabilidad social del proyecto, su sostenibilidad financiera (cuando corresponda) o la selección de alternativas.\nii) Definir y sustentar los rangos de variación de dichas variables que afectarían la condición de rentabilidad social o la selección de alternativas."]
[]
[]
[]
[null,"ANALISIS DE SENSIBILIDAD BIDIMENSIONAL"]
[null,"ICE / VAN",null,"Variación % de los Costos / periodo de ejecución/ otros"]
[null,null,null,75,50,20,0,-20,-50,-75]
[null,"Variación % del total de beneficiarios",75]
[null,null,50]
[null,null,20]
[null,null,0]
[null,null,-20]
[null,null,-50]
[null,null,-75]

{"sheet":"SOSTENIBILIDAD","index":11,"n_rows":91,"n_cols":15,"rows_kept":91,"cut":false,"hidden":false,"merged":[[78,10,78,13],[86,11,86,13],[87,11,87,13],[88,11,88,13],[73,6,73,9],[73,10,73,13],[75,10,75,13],[76,10,76,13],[77,10,77,13],[76,6,76,9],[77,6,77,9],[89,11,89,13],[86,7,86,8],[87,7,87,8],[88,7,88,8],[89,7,89,8],[86,9,86,10],[87,9,87,10],[88,9,88,10],[89,9,89,10],[86,1,86,3],[87,1,87,3],[88,1,88,3],[89,1,89,3],[86,4,86,6],[87,4,87,6],[88,4,88,6],[89,4,89,6],[84,1,84,3],[84,4,84,6],[84,7,84,8],[84,9,84,10],[84,11,84,13],[76,1,76,5],[77,1,77,5],[78,1,78,5],[73,1,73,5],[75,6,75,9],[75,1,75,5],[78,6,78,9],[50,1,50,3],[57,1,57,2],[63,1,63,3],[69,1,69,2],[57,3,57,12],[61,1,61,3],[64,1,64,3],[65,1,65,3],[66,1,66,3],[68,1,68,2],[44,1,44,3],[45,1,45,3],[41,1,41,3],[48,1,48,3],[49,1,49,3],[90,1,90,13],[86,14,89,14],[13,1,13,12],[39,1,39,12],[19,1,19,3],[20,1,20,3],[21,1,21,3],[22,1,22,3],[17,1,17,3],[28,1,28,3],[29,1,29,3],[30,1,30,3],[31,1,31,3],[26,1,26,3],[46,1,46,3],[43,1,43,3]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"SECCIÓN N°11: SOSTENIBILIDAD"]
[]
[null,"11.01 Sostenibilidad financiera: cuando la tarifa/tasa está predeterminada",null,null,null,null,null,null,null,"Sí","No"]
[]
[null,"Deberá efectuarse para aquellos proyectos de inversión que tienen generación de ingresos monetarios (por ejemplo, a través del cobro de peajes, tarifas, tasas,  cuotas, entre otros) por la prestación del servicio público sujeto de intervención."]
[]
[null,"Tarifa por servicios (cuando corresponda)"]
[]
[null,"Servicios",null,null,"Tarifa que se cobra a los usuarios"]
[]
[null,"Servicio 1"]
[null,"Servicio 2"]
[null,"…"]
[null,"Servicio n"]
[]
[null,"Índice de cobertura de los ingresos"]
[]
[null,"Ítems",null,null,0,1,2,3,4,5,"…","…","…","…","n"]
[]
[null,"Ingresos (a) tarifa x cantidad"]
[null,"Costos de operación y mantenimiento con proyecto (b)"]
[null,"Saldo a cubrir por otras fuentes (a)-(b). P.ej. Transferencias."]
[null,"Índice de cobertura de los ingresos (a)/(b)"]
[]
[null,"Análisis del flujo de caja para determinar el grado de autosostenibilidad",null,null,null,null,null,"Incluir flujo de caja de la unidad operativa que gestionará el proyecto."]
[]
[]
[]
[null,"11.02 Sostenibilidad financiera: cuando la tasa/tarifa no está predeterminada",null,null,null,null,null,null,null,"Sí","No"]
[]
[null,"Deberá efectuarse para aquellos proyectos de inversión que tienen potencial de generación de ingresos monetarios (por ejemplo, a través del cobro de peajes, tarifas, tasas,  cuotas, entre otros) por la prestación del servicio público sujeto de intervención."]
[]
[null,"Flujo de costos y servicios",null,null,0,1,2,3,4,5,"…","…","…","…","n"]
[]
[null,"Costos de O&M con proyecto"]
[null,"Demanda por servicio 1"]
[null,"Demanda por servicio 2"]
[null,"Demanda por servicio n"]
[]
[null,"Sumatoria de costos de O&M con proyecto (a)"]
[null,"Sumatoria de demanda de servicios con proyecto (b)"]
[null,"Tarifa (a) / (b)"]
[null,"Nota: cuando sea posible se debe calcular una tarifa por cada servicio"]
[]
[null,"Análisis de la disposición a pagar del usuario en caso de requerir tarifas o tasas"]
[]
[]
[]
[null,"Fuente de Información"]
[]
[null,"11.03 Evaluación privada (a precios de mercado)"]
[]
[null,"Ítems",null,null,0,1,2,3,4,5,"…","…","…","…","n"]
[]
[null,"Ingresos (con tarifa)"]
[null,"Inversión"]
[null,"Costos de O&M con proyecto"]
[null,"Flujos netos"]
[]
[null,"Tasa de descuento"]
[null,"VAN"]
[]
[null,"11.04 Descripción de la capacidad institucional en la sostenibilidad del proyecto"]
[]
[null,"Ítem",null,null,null,null,"Descripción",null,null,null,"Fuente de información"]
[]
[null,"Órgano técnico responsable de la operación y mantenimiento del proyecto"]
[null,"Análisis de la disponibilidad oportuna de recursos para la operación y mantenimiento"]
[null,"Descripción de los arreglos institucionales para la fase de Funcionamiento"]
[null,"Descripción de la capacidad de gestión del operador"]
[]
[]
[]
[null,"11.05 Gestión integral de los riesgos"]
[]
[null,"Tipo de riesgo (operacional, contexto de cambio climático, mercado, financiero, legal, …)",null,null,"Descripción del riesgo",null,null,"Probabilidad de ocurrencia* (baja, media, alta)",null,"Impacto (bajo, moderado, mayor)",null,"Medidas de mitigación"]
[]
[]
[]
[]
[]
[null,"* Dicha probabilidad resultará de un juicio técnico sobre que tan posible es la ocurrencia del riesgo afecte el desempeño del proyecto."]

{"sheet":"GESTIÓN","index":12,"n_rows":88,"n_cols":14,"rows_kept":88,"cut":false,"hidden":false,"merged":[[85,1,85,5],[87,1,87,8],[79,1,79,5],[81,1,81,5],[82,1,82,5],[83,1,83,5],[84,1,84,5],[49,1,49,5],[50,1,50,5],[51,1,51,5],[52,1,52,5],[65,1,65,5],[61,1,61,5],[62,1,62,5],[63,1,63,5],[64,1,64,5],[53,1,53,5],[56,1,56,10],[58,1,58,9],[42,1,42,4],[42,7,42,8],[43,1,43,4],[43,7,43,8],[47,1,47,5],[36,1,36,4],[36,7,36,8],[37,1,37,4],[37,7,37,8],[38,1,38,4],[38,7,38,8],[39,1,39,4],[39,7,39,8],[40,1,40,4],[40,7,40,8],[41,1,41,4],[41,7,41,8],[34,1,34,4],[34,7,34,8],[35,1,35,4],[35,7,35,8],[30,1,30,4],[30,7,30,8],[31,1,31,4],[31,7,31,8],[32,1,32,4],[32,7,32,8],[25,7,25,8],[26,1,26,4],[26,7,26,8],[33,1,33,4],[33,7,33,8],[27,1,27,4],[27,7,27,8],[28,1,28,4],[28,7,28,8],[29,1,29,4],[29,7,29,8],[23,7,23,8],[18,1,18,4],[18,7,18,8],[19,1,19,4],[19,7,19,8],[20,1,20,4],[20,7,20,8],[14,9,14,13],[17,1,17,4],[17,7,17,8],[68,1,68,5],[69,1,69,5],[24,1,24,4],[24,7,24,8],[25,1,25,4],[14,1,15,4],[14,5,14,6],[14,7,15,8],[21,1,21,4],[21,7,21,8],[22,1,22,4],[22,7,22,8],[23,1,23,4],[70,1,70,5],[71,1,71,5],[60,7,60,9],[61,7,61,9],[62,7,62,9],[63,7,63,9],[64,7,64,9],[65,7,65,9],[67,7,67,9],[68,7,68,9],[69,7,69,9],[70,7,70,9],[71,7,71,9],[67,1,67,5]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"SECCIÓN N°12: GESTIÓN DEL PROYECTO"]
[]
[null,null,null,null,null,"Años","Meses"]
[null,"12.01 Plan de implementación"]
[]
[null,"Actividades del Plan de Implementación",null,null,null,"Fecha ",null,"Órgano\nResponsable",null,"Periodo"]
[null,null,null,null,null,"Inicio","Fin",null,null,1,2,3,"…","n"]
[]
[null,"Expediente Técnico (ET) o Estudio Definitivo (ED)"]
[null,"Proceso de selección"]
[null,"Convocatoria"]
[null,"Integración de Bases"]
[null,"Buena Pro"]
[null,"Suscripción del Contrato"]
[null,"Elaboración del ET o ED"]
[null,"Supervisión"]
[null,"Proceso de selección"]
[null,"Convocatoria"]
[null,"Integración de Bases"]
[null,"Buena Pro"]
[null,"Suscripción del Contrato"]
[null,"Supervisión del PI"]
[null,"Ejecución "]
[null,"Proceso de selección "]
[null,"Convocatoria"]
[null,"Integración de Bases"]
[null,"Buena Pro"]
[null,"Suscripción del Contrato"]
[null,"Ejecución Contractual"]
[null,"Acción 1"]
[null,"…"]
[null,"Acción \"n\""]
[null,"Recepción"]
[null,"Liquidación física y financiera"]
[null,"Transferencia"]
[]
[null,"12.02 Modalidad de ejecución de proyecto"]
[]
[null,"Tipo de ejecución",null,null,null,null,"Marcar"]
[]
[null,"Administración directa"]
[null,"Administración indirecta – por contrata"]
[null,"Administración indirecta – Asociación Público Privado (APP)"]
[null,"Administración indirecta – Núcleo Ejecutor"]
[null,"Administración indirecta – Ley 29230 (Obras por Impuestos)"]
[]
[null,"12.03 Requerimientos institucionales y normativos en la fase de Ejecución y fase de Funcionamiento"]
[null,"(Referido a los aspectos técnicos y regulatorios que el proyecto deberá cumplir durante la fase de Ejecución)."]
[]
[null,"Condiciones previas relevantes"]
[]
[null,"Ejecución",null,null,null,null,"Marcar","Estado situacional"]
[null,"Saneamiento técnico legal"]
[null,"Factibilidad de servicios de agua, desagüe y electricidad"]
[null,"Certificado de parámetros urbanísticos"]
[null,"Cumplimiento de permisos y autorizaciones"]
[null,"Otros"]
[null,"Ejecución"]
[null,"Saneamiento técnico legal"]
[null,"Factibilidad de servicios de agua, desagüe y electricidad"]
[null,"Certificado de parámetros urbanísticos"]
[null,"Cumplimiento de permisos y autorizaciones"]
[null,"Otros"]
[]
[null,"12.04 Entidad u órgano que estará a cargo de la operación y mantenimiento"]
[]
[]
[]
[null,"12.05 Fuente de financiamiento"]
[]
[null,"Fuente de Financiamiento","Marcar",null,null,null,"Marcar"]
[]
[null,"Recursos ordinarios"]
[null,"Recursos directamente recaudados"]
[null,"Recursos por operaciones oficiales de crédito"]
[null,"Donaciones y transferencias"]
[null,"Recursos determinados"]
[]
[null,"En caso se seleccione como fuente de financiamiento ROOC, se deberá sustentar la estructuración financiera del monto de inversión del Proyecto."]

{"sheet":"IMPACTO AMBIENTAL","index":13,"n_rows":23,"n_cols":9,"rows_kept":23,"cut":false,"hidden":false,"merged":[[22,1,22,4],[22,5,22,7],[13,1,13,4],[13,5,13,7],[15,1,15,4],[16,1,16,4],[17,1,17,4],[19,1,19,4],[20,1,20,4],[21,1,21,4],[21,5,21,7],[15,5,15,7],[20,5,20,7],[17,5,17,7],[16,5,16,7],[19,5,19,7]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"SECCIÓN N°13: IMPACTO AMBIENTAL"]
[]
[null,"13.01 Impacto ambiental"]
[]
[null,"IMPACTOS NEGATIVOS",null,null,null,"MEDIDAS DE MITIGACIÓN",null,null,"COSTO (S/)"]
[]
[null,"Durante la Ejecución"]
[null,"Impacto 1:"]
[null,"Impacto 2:"]
[null,"…"]
[null,"Durante el Funcionamiento"]
[null,"Impacto 1:"]
[null,"Impacto 2:"]
[null,"…"]

{"sheet":"MARCO LOGICO","index":14,"n_rows":23,"n_cols":11,"rows_kept":23,"cut":false,"hidden":false,"merged":[[11,1,11,12],[13,10,13,12],[15,10,15,12],[16,10,16,12],[17,10,17,12],[13,7,13,9],[15,7,15,9],[16,7,16,9],[17,7,17,9],[13,1,13,3],[15,1,15,3],[16,1,16,3],[17,1,19,3],[19,4,19,6],[18,10,18,12],[19,10,19,12],[20,10,20,12],[21,10,21,12],[22,10,22,12],[18,7,18,9],[13,4,13,6],[15,4,15,6],[16,4,16,6],[17,4,17,6],[18,4,18,6],[20,4,20,6],[19,7,19,9],[20,7,20,9],[20,1,22,3],[21,4,21,6],[22,4,22,6],[21,7,21,9],[22,7,22,9]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"SECCIÓN N°14: MARCO LÓGICO"]
[]
[null,"14.01 RESUMEN DEL PROYECTO: MATRIZ DEL MARCO LÓGICO"]
[]
[null,"Nivel de objetivo",null,null,"Indicadores",null,null,"Medios de verificación",null,null,"Supuestos"]
[]
[null,"Fin"]
[null,"Propósito"]
[null,"Componentes",null,null,"Indicador 1"]
[null,null,null,null,"…"]
[null,null,null,null,"Indicador \"n\""]
[null,"Acciones",null,null,"Indicador 1"]
[null,null,null,null,"…"]
[null,null,null,null,"Indicador \"n\""]

{"sheet":"CONCLUSIONES","index":15,"n_rows":6,"n_cols":2,"rows_kept":6,"cut":false,"hidden":false,"merged":[[3,1,3,12],[5,1,8,12]]}
[]
[null,"SECCIÓN N°15: CONCLUSIONES Y RECOMENDACIONES"]
[]
[null,"15.01 CONCLUSIONES Y RECOMENDACIONES"]
[]
[null,"Se debe indicar el resultado del proceso de formulación y evaluación del proyecto (viable o no viable) y detallar los principales argumentos que sustentan dicho resultado, en términos de lo siguiente:\n\na. Cumplimiento de los tres atributos que definen la condición de viabilidad de un proyecto, en caso el proyecto resulte viable. Si el resultado es no viable, indicar qué atributo o atributos no se logró cumplir. \nb. Emitir un juicio técnico sobre la calidad y la pertinencia del grado de profundización de la información empleada para la elaboración de la ficha técnica, así como la consistencia y coherencia de los supuestos establecidos, las fuentes de información, las normas técnicas, los parámetros y metodologías empleadas, entre otros elementos claves relacionados con el fundamento técnico y económico de la decisión de inversión."]

{"sheet":"FIRMAS","index":16,"n_rows":18,"n_cols":10,"rows_kept":18,"cut":false,"hidden":false,"merged":[[17,4,17,7],[3,1,3,12],[9,1,9,3],[16,1,16,3],[9,4,9,7],[10,4,10,7],[9,9,9,10],[16,4,16,7],[16,9,16,10]]}
[]
[null,"SECCIÓN N°16: FIRMAS"]
[]
[null,"16.01 FIRMAS"]
[]
[]
[]
[]
[]
[null,"Preparado o supervisado por:",null,null,"…………………………………………………………………………….",null,null,null,"Fecha:","……………………………………………………………………………."]
[null,null,null,null,"Especialista de la UF o Responsable de la UF"]
[]
[]
[]
[]
[]
[null,"Declarado viable por:",null,null,"…………………………………………………………………………….",null,null,null,"Fecha:","……………………………………………………………………………."]
[null,null,null,null,"Responsable de la UF"]

{"sheet":"ANEXOS","index":17,"n_rows":16,"n_cols":3,"rows_kept":16,"cut":false,"hidden":false,"merged":[[14,2,14,14],[13,2,13,14],[15,2,15,14],[12,2,12,14],[2,1,2,14],[10,2,10,14],[11,2,11,14],[6,2,6,14],[9,2,9,14],[8,2,8,14]]}
[null,"SECCIÓN N°17: ANEXOS"]
[]
[null,"17.01 ANEXOS"]
[]
[null,"Considerar los siguientes anexos (según corresponda):"]
[]
[null,"Nro. ","Descripción del anexo"]
[]
[null,1,"Análisis que determina la baja o mediana complejidad de la tipología del proyecto (en consistencia al Anexo N°11 del capítulo III de la Directiva General)."]
[null,2,"Información asociada a diagnóstico de la unidad productora y de la población afectada"]
[null,3,"Estudios preliminares del análisis técnico (topografía, estudio de suelos, etc.) que sustentan la elección del Tamaño, Tecnología y Localización y los planos de la propuesta técnica."]
[null,4,"Análisis de la brecha de servicios"]
[null,5,"Análisis de costos"]
[null,6,"Documentos de saneamiento físico legal"]
[null,7,"Documentos institucionales de acuerdo al Sector (Acuerdos Institucionales, Convenios, Actas de Compromiso, permisos sectoriales etc.) "]
[null,8,"Análisis de los resultados de la evaluación social "]

{"sheet":"Protocolo final","index":18,"n_rows":43,"n_cols":11,"rows_kept":43,"cut":false,"hidden":false,"merged":[[41,2,41,8],[42,2,42,8],[4,2,4,8],[7,2,7,8],[9,2,9,8],[10,2,10,8],[11,2,11,8],[12,2,12,8],[13,2,13,8],[14,2,14,8],[15,2,15,8],[16,2,16,8],[17,2,17,8],[36,2,36,8],[37,2,37,8],[38,2,38,8],[39,2,39,8],[40,2,40,8],[30,2,30,8],[31,2,31,8],[32,2,32,8],[34,2,34,8],[35,2,35,8],[25,2,25,8],[26,2,26,8],[27,2,27,8],[28,2,28,8],[29,2,29,8],[20,2,20,8],[21,2,21,8],[22,2,22,8],[23,2,23,8],[24,2,24,8],[19,10,19,12],[7,10,7,12],[9,10,9,12],[10,10,10,12],[11,10,11,12],[12,10,12,12],[13,10,13,12],[36,10,36,12],[37,10,37,12],[26,10,26,12],[27,10,27,12],[28,10,28,12],[29,10,29,12],[30,10,30,12],[31,10,31,12],[2,1,2,6],[32,10,32,12],[34,10,34,12],[35,10,35,12],[20,10,20,12],[21,10,21,12],[22,10,22,12],[23,10,23,12],[24,10,24,12],[25,10,25,12],[14,10,14,12],[15,10,15,12],[16,10,16,12],[17,10,17,12],[4,10,4,12],[19,2,19,8],[38,10,38,12],[39,10,39,12],[40,10,40,12],[41,10,41,12],[42,10,42,12]]}
[null,"SECCIÓN N°18: PROTOCOLO DE EVALUACIÓN"]
[]
[null,"18.01 PROTOCOLO DE EVALUACIÓN"]
[]
[null,"Número","Criterios de cumplimiento",null,null,null,null,null,null,"Sí","Comentarios"]
[]
[null,null,"Alineamiento al cierre de una brecha prioritaria:"]
[null,1,"¿El proyecto de inversión contribuye a la meta de cierre de una brecha prioritaria?"]
[null,null,"Identificación:"]
[null,2,"¿Se ha delimitado el área de influencia/área de estudio y definido sus características?"]
[null,3,"¿Han sido identificados los peligros naturales, socionaturales y antrópicos que podrían impactar sobre la infraestructura existente o sobre el proyecto durante su vida útil?"]
[null,4,"¿Se ha examinado el desempeño de la oferta actual del servicio?"]
[null,5,"¿Se ha examinado la exposición y vulnerabilidad de la UP frente a peligros identificados en el área de estudio?"]
[null,7,"¿Se han identificado y caracterizado a los agentes afectados y/o beneficiados con el proyecto de inversión?"]
[null,8,"¿El problema central ha sido definido como una situación negativa ó hecho real que afecta a un sector de la población? Las causas explican el problema central? ¿Los efectos son consecuencia del problema identificado?"]
[null,9,"¿El objetivo central o propósito del proyecto expresa la solución del problema central y los medios definidos para el proyecto son suficientes para alcanzar el objetivo central?"]
[null,10,"¿Las acciones que contemplan las alternativas de solución se derivan del análisis de los medios fundamentales?"]
[null,11,"¿Las alternativas planteadas se basan en evidencia técnica, científica o experiencia de otros proyectos?"]
[null,null,"Formulación:"]
[null,12,"¿El Horizonte de Evaluación del Proyecto ha sido adecuadamente determinado?"]
[null,13,"¿La demanda efectiva (o demanda objetivo) y su proyección han sido estimadas en base a parámetros, supuestos y metodologías adecuadas? ¿Se presenta evidencia técnica que respalda los supuestos utilizados?"]
[null,14,"¿Han sido identificados los factores de producción que determinan la oferta actual?"]
[null,15,"¿La oferta actual optimizada ha sido cuantificada considerando los principales factores de producción?"]
[null,16,"¿Ha sido calculada la brecha existente entre la demanda efectiva (o demanda objetivo) con proyecto y la oferta optimizada sin proyecto?"]
[null,17,"¿El tamaño del proyecto (capacidad de producción) guarda correspondencia con la brecha de servicio existente?"]
[null,18,"¿La localización propuesta para el proyecto se encuentra adecuadamente justificada?"]
[null,19,"¿La opción tecnológica propuesta para el proyecto se encuentra adecuadamente justificada?"]
[null,20,"¿Las alternativas de solución están conforme guardan correspondencia con los niveles de servicio y estándares de calidad establecidos por el Sector competente? "]
[null,21,"¿Las soluciones técnicas están respaldadas por estudios de base o campo que el sector establece?"]
[null,22,"¿Las alternativas consideran acciones para reducir probables daños o pérdidas que podrían generar en caso de la ocurrencia de desastres?"]
[null,23,"¿Las alternativas consideran acciones para reducir el impacto ambiental que podría generar el proyecto?"]
[null,24,"¿El presupuesto de inversión de cada alternativa de solución está desagregado a nivel de acciones, actividades y tareas? ¿El presupuesto de inversión del proyecto ha incluido los costos de mitigación ambiental y riesgos?"]
[null,25,"¿Los costos de operación y mantenimiento tienen un razonable nivel de desagregación y se encuentran justificados en relación a la demanda por atender con el proyecto?"]
[null,null,"Evaluación:"]
[null,26,"¿La metodología de evaluación social seleccionada (costo beneficio o costo efectividad) guarda correspondencia con la tipología de proyecto de inversión?"]
[null,27,"¿Existe evidencia que respalda la atribución de los beneficios a los resultados del proyecto, y estos han sido estimados en base a parámetros y procedimientos de cálculo razonables?"]
[null,28,"¿Han sido calculados los indicadores de evaluación social para cada alternativa de solución?"]
[null,29,"¿Se ha analizado el comportamiento de la rentabilidad de las alternativas ante posibles cambios en las principales variables como demanda y costos?"]
[null,30,"¿Se presenta el plan de implementación con las actividades necesarias (ruta crítica) para la ejecución del proyecto?"]
[null,31,"¿Se han definido los requerimientos institucionales y normativos que se deben cumplir durante la fase de ejecución y fase de funcionamiento?"]
[null,32,"¿Se han identificado los probables impactos positivos y/o negativos del proyecto en el medioambiente?"]
[null,33,"¿Se ha definido quién financiará la operación y mantenimiento del proyecto?"]
[null,34,"¿Se ha realizado un análisis tarifario, tasas o contribuciones para la sostenibilidad financiera del proyecto?"]

{"sheet":"DETALLE DEL COSTO TOTAL","index":19,"n_rows":91,"n_cols":49,"rows_kept":91,"cut":false,"hidden":true,"merged":[[4,28,4,29],[4,20,4,21],[1,20,1,29],[1,31,1,38],[1,40,1,47],[2,20,2,21],[2,28,2,29],[1,11,1,18],[1,1,2,3],[1,4,2,4],[1,5,2,5],[1,6,2,6],[1,8,2,8]]}
[]
[null,"Descripción",null,null,"Unidad de Medida","Meta","Costo Unitario","Costo Total S/","Factor Corrección","Costo Total S/",null,"Cronograma de Ejecución (Trimestral)",null,null,null,null,null,null,null,null,"Cronograma de Ejecución Gantt (Trimestral)",null,null,null,null,null,null,null,null,null,null,"Ejecución Financiera a precios privados en Soles (Trimestral)",null,null,null,null,null,null,null,null,"Ejecución Financiera a precios sociales en Soles (Trimestral)"]
[null,null,null,null,null,null,null,"P. Privados",null,"P. Sociales",null,1,2,3,4,5,6,7,8,null,1,null,2,3,4,5,6,7,8,null,null,1,2,3,4,5,6,7,8,null,1,2,3,4,5,6,7,8]
[]
[null,"COMPONENTE 1.Fortalecimiento de capacidades para la planificación y generación de información temática para …",null,null,null,null,null,{"$f":"+H6+H28","v":665410.96},null,{"$f":"+J6+J28","v":591763.86440677964},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+AF6+AF28","v":133090.96},135136,88944,88944,75296,48000,48000,48000,{"$f":"+H5-SUM(AF5:AM5)","v":0},{"$f":"+AO6+AO28","v":116270.98305084747},118004.06779661018,78858.305084745763,78858.305084745763,67292.203389830509,44160,44160,44160,{"$f":"+J5-SUM(AO5:AV5)","v":0}]
[null,"Acción  1.1","…",null,null,null,null,{"$f":"+SUM(H7:H27)","v":528930.96},null,{"$f":"+SUM(J7:J27)","v":476102.84745762707},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+SUM(AF7:AF27)","v":133090.96},{"$f":"+SUM(AG7:AG27)","v":107840},48000,48000,48000,48000,48000,48000,{"$f":"+H6-SUM(AF6:AM6)","v":0},{"$f":"+SUM(AO7:AO27)","v":116270.98305084747},{"$f":"+SUM(AP7:AP27)","v":94871.86440677967},44160,44160,44160,44160,44160,44160,{"$f":"+J6-SUM(AO6:AV6)","v":0}]
[null,"Act. 1.1.1"," YYYYY",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,0]
[null,null,"Tarea 1.1.1.1","ZZZZ","Taller",5,4000,{"$f":"+G8*F8","v":20000},{"$f":"1/(1.18)","v":0.84745762711864414},{"$f":"+I8*H8","v":16949.152542372882},null,1,0,0,0,0,0,0,0,null,null,{"$f":"+L8","v":1},0,0,0,0,0,0,0,null,null,{"$f":"+L8*$H8","v":20000},0,0,0,0,0,0,0,0,{"$f":"+L8*$J8","v":16949.152542372882},{"$f":"+M8*$J8","v":0},0,0,0,0,0,0,0]
[null,null,"Tarea 1.1.1.2","KKKK","Publicación",1,{"$f":"(1136*1.18)*2","v":2680.96},{"$f":"+G9*F9","v":2680.96},{"$f":"1/(1.18)","v":0.84745762711864414},{"$f":"+I9*H9","v":2272.0000000000005},null,1,0,0,0,0,0,0,0,null,null,1,0,0,0,0,0,0,0,null,null,2680.96,0,0,0,0,0,0,0,0,{"$f":"+L9*$J9","v":2272.0000000000005},0,0,0,0,0,0,0,0]
[null,"Act. 1.1.2","Acompañamiento Técnico",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,0]
[null,null,"Tarea 1.1.2.1","Especialista SIG","mes",{"$f":"12*2","v":24},6000,{"$f":"+G11*F11","v":144000},0.92,{"$f":"+I11*H11","v":132480},null,0.125,0.125,0.125,0.125,0.125,0.125,0.125,0.125,null,null,{"$f":"+L11","v":0.125},0.125,0.125,0.125,0.125,0.125,0.125,0.125,null,null,{"$f":"+L11*$H11","v":18000},18000,18000,18000,18000,18000,18000,18000,0,{"$f":"+L11*$J11","v":16560},16560,16560,16560,16560,16560,16560,16560,0]
[null,null,"Tarea 1.1.2.2","Especialista Forestal","mes",{"$f":"12*2","v":24},6000,144000,0.92,132480,null,0.125,0.125,0.125,0.125,0.125,0.125,0.125,0.125,null,null,0.125,0.125,0.125,0.125,0.125,0.125,0.125,0.125,null,null,18000,18000,18000,18000,18000,18000,18000,18000,0,16560,16560,16560,16560,16560,16560,16560,16560,0]
[null,null,"Tarea 1.1.2.3","Sociologo ","mes",{"$f":"12*2","v":24},4000,96000,0.92,88320,null,0.125,0.125,0.125,0.125,0.125,0.125,0.125,0.125,null,null,0.125,0.125,0.125,0.125,0.125,0.125,0.125,0.125,null,null,12000,12000,12000,12000,12000,12000,12000,12000,0,11040,11040,11040,11040,11040,11040,11040,11040,0]
[null,"Act. 1.1.3","…",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,0]
[null,null,"Tarea 1.1.3.1","…",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,0]
[null,null,null,"…","Mes",1,2000,{"$f":"+G16*F16","v":2000},{"$f":"1/(1.18)","v":0.84745762711864414},{"$f":"+I16*H16","v":1694.9152542372883},null,1,0,0,0,0,0,0,0,null,null,{"$f":"+L16","v":1},0,0,0,0,0,0,0,null,null,{"$f":"+L16*$H16","v":2000},0,0,0,0,0,0,0,0,{"$f":"+L16*$J16","v":1694.9152542372883},0,0,0,0,0,0,0,0]
[null,null,null,"…","Mes",1,2250,{"$f":"+G17*F17","v":2250},0.84745762711864414,1906.7796610169494,null,1,0,0,0,0,0,0,0,null,null,1,0,0,0,0,0,0,0,null,null,2250,0,0,0,0,0,0,0,0,1906.7796610169494,0,0,0,0,0,0,0,0]
[null,null,null,"…","Global",1,1000,1000,0.84745762711864414,847.45762711864415,null,1,0,0,0,0,0,0,0,null,null,1,0,0,0,0,0,0,0,null,null,1000,0,0,0,0,0,0,0,0,847.45762711864415,0,0,0,0,0,0,0,0]
[null,null,null,"…","Global",1,1000,1000,0.84745762711864414,847.45762711864415,null,1,0,0,0,0,0,0,0,null,null,1,0,0,0,0,0,0,0,null,null,1000,0,0,0,0,0,0,0,0,847.45762711864415,0,0,0,0,0,0,0,0]
[null,null,null,"…","Millar",10,600,6000,0.84745762711864414,5084.7457627118647,null,1,0,0,0,0,0,0,0,null,null,1,0,0,0,0,0,0,0,null,null,6000,0,0,0,0,0,0,0,0,5084.7457627118647,0,0,0,0,0,0,0,0]
[null,null,null,"…","Millar",10,600,6000,0.84745762711864414,5084.7457627118647,null,1,0,0,0,0,0,0,0,null,null,1,0,0,0,0,0,0,0,null,null,6000,0,0,0,0,0,0,0,0,5084.7457627118647,0,0,0,0,0,0,0,0]
[null,null,"Tarea 1.1.3.2","…","Taller",3,{"$f":"+G8","v":4000},12000,0.84745762711864414,10169.491525423729,null,1,0,0,0,0,0,0,0,null,null,1,0,0,0,0,0,0,0,null,null,12000,0,0,0,0,0,0,0,0,10169.491525423729,0,0,0,0,0,0,0,0]
[null,null,"Tarea 1.1.3.3","…","día/persona",{"$f":"20*F22","v":60},320,19200,0.84745762711864414,16271.186440677968,null,1,0,0,0,0,0,0,0,null,null,1,0,0,0,0,0,0,0,null,null,19200,0,0,0,0,0,0,0,0,16271.186440677968,0,0,0,0,0,0,0,0]
[null,"Act. 1.1.4","Elaboración del Plan de Implementación …",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,0]
[null,null,"Tarea 1.1.4.1","Talleres de formulación …","Taller",5,{"$f":"+G22","v":4000},20000,{"$f":"1/(1.18)","v":0.84745762711864414},16949.152542372882,null,0.2,0.8,0,0,0,0,0,0,null,null,{"$f":"+L25","v":0.2},0.8,0,0,0,0,0,0,null,null,{"$f":"+L25*$H25","v":4000},16000,0,0,0,0,0,0,0,{"$f":"+L25*$J25","v":3389.8305084745766},13559.322033898306,0,0,0,0,0,0,0]
[null,null,"Tarea 1.1.4.2","Taller de presentación y validación …","Taller",2,{"$f":"+G25","v":4000},8000,0.84745762711864414,6779.6610169491532,null,0,1,0,0,0,0,0,0,null,null,0,1,0,0,0,0,0,0,null,null,0,8000,0,0,0,0,0,0,0,0,6779.6610169491532,0,0,0,0,0,0,0]
[null,null,"Tarea 1.1.4.3","…","día/persona",{"$f":"20*(F26+F25)","v":140},320,44800,0.84745762711864414,37966.101694915254,null,0.2,0.8,0,0,0,0,0,0,null,null,0.2,0.8,0,0,0,0,0,0,null,null,8960,35840,0,0,0,0,0,0,{"$f":"+H27-SUM(AF27:AM27)","v":0},7593.2203389830511,30372.881355932204,0,0,0,0,0,0,0]
[null,"Acción 1.2","…",null,null,null,null,{"$f":"+SUM(H29:H34)","v":136480},null,{"$f":"+SUM(J29:J34)","v":115661.01694915254},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+SUM(AF29:AF34)","v":0},27296,40944,40944,27296,0,0,0,0,{"$f":"+SUM(AO29:AO34)","v":0},23132.203389830513,34698.305084745763,34698.305084745763,23132.203389830513,0,0,0,0]
[null,"Act. 1.2.1","Materiales de fortalecimiento de capacidades",null,"Mapa",12,2000,{"$f":"+G29*F29","v":24000},{"$f":"1/(1.18)","v":0.84745762711864414},20338.983050847459,null,0,0.2,0.3,0.3,0.2,0,0,0,null,null,{"$f":"+L29","v":0},0.2,0.3,0.3,0.2,0,0,0,null,null,{"$f":"+L29*$H29","v":0},4800,7200,7200,4800,0,0,0,0,{"$f":"+L29*$J29","v":0},4067.7966101694919,6101.6949152542375,6101.6949152542375,4067.7966101694919,0,0,0,0]
[null,"Act. 1.2.2","Herramientas participativas",null,"Global",1,10000,10000,0.84745762711864414,8474.5762711864409,null,0,0.2,0.3,0.3,0.2,0,0,0,null,null,0,0.2,0.3,0.3,0.2,0,0,0,null,null,0,2000,3000,3000,2000,0,0,0,0,0,1694.9152542372883,2542.3728813559323,2542.3728813559323,1694.9152542372883,0,0,0,0]
[null,"Act. 1.2.3","Cursos especializados para …",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,0]
[null,null,"Tarea 1.2.1.1","Talleres de capacitación","Taller",12,{"$f":"+G8","v":4000},{"$f":"+G32*F32","v":48000},{"$f":"1/(1.18)","v":0.84745762711864414},40677.966101694918,null,0,0.2,0.3,0.3,0.2,0,0,0,null,null,{"$f":"+L32","v":0},0.2,0.3,0.3,0.2,0,0,0,null,null,{"$f":"+L32*$H32","v":0},9600,14400,14400,9600,0,0,0,0,{"$f":"+L32*$J32","v":0},8135.5932203389839,12203.389830508475,12203.389830508475,8135.5932203389839,0,0,0,0]
[null,null,"Tarea 1.2.1.2","Pasajes aéreos  (I/V)","Pasaje",{"$f":"4*F32","v":48},{"$f":"+G87","v":495},23760,0.84745762711864414,20135.593220338986,null,0,0.2,0.3,0.3,0.2,0,0,0,null,null,0,0.2,0.3,0.3,0.2,0,0,0,null,null,0,4752,7128,7128,4752,0,0,0,0,0,4027.1186440677975,6040.6779661016953,6040.6779661016953,4027.1186440677975,0,0,0,0]
[null,null,"Tarea 1.2.1.3","Viáticos","día/persona",{"$f":"4*2*12","v":96},320,30720,0.84745762711864414,26033.898305084749,null,0,0.2,0.3,0.3,0.2,0,0,0,null,null,0,0.2,0.3,0.3,0.2,0,0,0,null,null,0,6144,9216,9216,6144,0,0,0,0,0,5206.7796610169498,7810.1694915254247,7810.1694915254247,5206.7796610169498,0,0,0,0]
[null,"COMPONENTE 2.Suficiente y adecuado equipamiento para la generación, procesamiento, almacenamiento y distribución de información temática",null,null,null,null,null,{"$f":"+H36+H40","v":452462},null,{"$f":"+J36+J40","v":383442.37288135593},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+AF36+AF40","v":0},278308,0,0,0,0,0,174154,0,{"$f":"+AO36+AO40","v":0},235854.2372881356,0,0,0,0,0,147588.13559322036,0]
[null,"Acción 2.1","…",null,null,null,null,{"$f":"+SUM(H37:H39)","v":278308},null,{"$f":"+SUM(J37:J39)","v":235854.2372881356},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+SUM(AF37:AF39)","v":0},278308,0,0,0,0,0,0,0,{"$f":"+SUM(AO37:AO39)","v":0},235854.2372881356,0,0,0,0,0,0,0]
[null,"Act. 2.1.1","Hardware",null,"Global",1,100000,{"$f":"+G37*F37","v":100000},{"$f":"1/(1.18)","v":0.84745762711864414},{"$f":"+I37*H37","v":84745.762711864416},null,0,1,0,0,0,0,0,0,null,null,{"$f":"+L37","v":0},1,0,0,0,0,0,0,null,null,{"$f":"+L37*$H37","v":0},100000,0,0,0,0,0,0,0,{"$f":"+L37*$J37","v":0},84745.762711864416,0,0,0,0,0,0,0]
[null,"Act. 2.1.2","Software: ESRI-ArcGIS Avanzado (Uso individual) v.10.5",null,"Licencia",2,{"$f":"74154","v":74154},148308,0.84745762711864414,125684.74576271187,null,0,1,0,0,0,0,0,0,null,null,0,1,0,0,0,0,0,0,null,null,0,148308,0,0,0,0,0,0,0,0,125684.74576271187,0,0,0,0,0,0,0]
[null,"Act. 2.1.3","Equipamiento menor (gps, drones,etc.)",null,"Global",1,30000,30000,0.84745762711864414,25423.728813559323,null,0,1,0,0,0,0,0,0,null,null,0,1,0,0,0,0,0,0,null,null,0,30000,0,0,0,0,0,0,0,0,25423.728813559323,0,0,0,0,0,0,0]
[null,"Acción 2.2","…",null,null,null,null,{"$f":"+H41+H42","v":174154},null,{"$f":"+J41+J42","v":147588.13559322036},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+AF41+AF42","v":0},0,0,0,0,0,0,174154,0,{"$f":"+AO41+AO42","v":0},0,0,0,0,0,0,147588.13559322036,0]
[null,"Act. 2.1.1","Hardware",null,"Global",1,100000,100000,{"$f":"1/(1.18)","v":0.84745762711864414},{"$f":"+I41*H41","v":84745.762711864416},null,0,0,0,0,0,0,0,1,null,null,{"$f":"+L41","v":0},0,0,0,0,0,0,1,null,null,{"$f":"+L41*$H41","v":0},0,0,0,0,0,0,100000,0,{"$f":"+L41*$J41","v":0},0,0,0,0,0,0,84745.762711864416,0]
[null,"Act. 2.1.2","Software: ESRI-ArcGIS Avanzado (Uso individual) v.10.5",null,"Licencia",1,{"$f":"+G38","v":74154},74154,0.84745762711864414,62842.372881355936,null,0,0,0,0,0,0,0,1,null,null,0,0,0,0,0,0,0,1,null,null,0,0,0,0,0,0,0,74154,0,0,0,0,0,0,0,0,62842.372881355936,0]
[null,"COMPONENTE 3 .Bases de datos y mapas temáticos actualizados, integrados, compatibles y disponibles",null,null,null,null,null,{"$f":"+H44","v":1898751},null,{"$f":"+J44","v":1609111.0169491526},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+AF44","v":148511},364450,341666.66666666669,447061.66666666669,522061.66666666669,75000,0,0,0,{"$f":"+AO44","v":125856.77966101696},308855.93220338988,289548.0225988701,378865.81920903962,442425.14124293794,63559.322033898308,0,0,0]
[null,"Acción 3.1","…",null,null,null,null,{"$f":"+SUM(H45:H52)","v":1898751},null,{"$f":"+SUM(J45:J52)","v":1609111.0169491526},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+SUM(AF45:AF52)","v":148511},364450,341666.66666666669,447061.66666666669,522061.66666666669,75000,0,0,0,{"$f":"+SUM(AO45:AO52)","v":125856.77966101696},308855.93220338988,289548.0225988701,378865.81920903962,442425.14124293794,63559.322033898308,0,0,0]
[null,"Act. 3.1.1","Elaboración del Mapa Base",null,"Mapa",1,{"$f":"+'[2]M1. Mapa Base'!H34","v":148511},{"$f":"+G45*F45","v":148511},{"$f":"1/(1.18)","v":0.84745762711864414},{"$f":"+I45*H45","v":125856.77966101696},null,1,0,0,0,0,0,0,0,null,null,{"$f":"+L45","v":1},0,0,0,0,0,0,0,null,null,{"$f":"+L45*$H45","v":148511},0,0,0,0,0,0,0,0,{"$f":"+L45*$J45","v":125856.77966101696},0,0,0,0,0,0,0,0]
[null,"Act. 3.1.2","Elaboración del Mapa de Dinámica Poblacionales",null,"Mapa",1,{"$f":"+'[2]M2. Centros Poblados'!H39","v":128660},{"$f":"+G46*F46","v":128660},0.84745762711864414,{"$f":"+I46*H46","v":109033.89830508476},null,0,1,0,0,0,0,0,0,null,null,0,1,0,0,0,0,0,0,null,null,0,128660,0,0,0,0,0,0,0,0,109033.89830508476,0,0,0,0,0,0,0]
[null,"Act. 3.1.3","Elaboración del Mapa Forestal",null,"Mapa",1,200000,{"$f":"+G47*F47","v":200000},0.84745762711864414,169491.52542372883,null,0,0,0,0.5,0.5,0,0,0,null,null,0,0,0,0.5,0.5,0,0,0,null,null,0,0,0,100000,100000,0,0,0,0,0,0,0,84745.762711864416,84745.762711864416,0,0,0,0]
[null,"Act. 3.1.4","Elaboración del Mapa de Capacidad de Uso Mayor de las Tierras",null,"Mapa",1,800000,{"$f":"+G48*F48","v":800000},0.84745762711864414,677966.10169491533,null,0,0,0.33333333333333337,0.33333333333333337,0.33333333333333337,0,0,0,null,null,0,0,0.33333333333333337,0.33333333333333337,0.33333333333333337,0,0,0,null,null,0,0,266666.66666666669,266666.66666666669,266666.66666666669,0,0,0,0,0,0,225988.7005649718,225988.7005649718,225988.7005649718,0,0,0,0]
[null,"Act. 3.1.5","Elaboración del Mapa de Ecosistemas priorizados para la conservación de la biodiversidad",null,"Mapa",1,{"$f":"+'[2]M5. EPC'!H109","v":160790},160790,0.84745762711864414,136262.7118644068,null,null,1,0,0,0,0,0,0,null,null,0,1,0,0,0,0,0,0,null,null,0,160790,0,0,0,0,0,0,0,0,136262.7118644068,0,0,0,0,0,0,0]
[null,"Act. 3.1.6","Elaboración del Mapa de Hábitats Críticos",null,"Mapa",1,{"$f":"+'[2]M5. EPC'!H109","v":160790},160790,0.84745762711864414,136262.7118644068,null,0,0,0,0.5,0.5,0,0,0,null,null,0,0,0,0.5,0.5,0,0,0,null,null,0,0,0,80395,80395,0,0,0,0,0,0,0,68131.355932203398,68131.355932203398,0,0,0,0]
[null,"Act. 3.1.7","Elaboración del Mapa de Fisiografía",null,"Mapa",1,150000,150000,0.84745762711864414,127118.64406779662,null,null,0.5,0.5,0,0,0,0,0,null,null,0,0.5,0.5,0,0,0,0,0,null,null,0,75000,75000,0,0,0,0,0,0,0,63559.322033898308,63559.322033898308,0,0,0,0,0,0]
[null,"Act. 3.1.8","Elaboración del Mapa de Uso Actual de la Tierra con enfásis en sistemas agroforestales",null,"Mapa",1,150000,150000,0.84745762711864414,127118.64406779662,null,0,0,0,null,0.5,0.5,0,0,null,null,0,0,0,0,0.5,0.5,0,0,null,null,0,0,0,0,75000,75000,0,0,0,0,0,0,0,63559.322033898308,63559.322033898308,0,0,0]
[null,"COMPONENTE 4.Difusión y sensibilización sobre el proceso de zonificación forestal",null,null,null,null,null,{"$f":"+H54+H63","v":179500},null,{"$f":"+J54+J63","v":154446.25},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+AF54+AF63","v":0},0,0,45500,33500,50250,50250,0,0,{"$f":"+AO54+AO63","v":0},0,0,39025.25,28855.25,43282.875,43282.875,0,0]
[null,"Acción 4.1","…",null,null,null,null,{"$f":"+SUM(H55:H62)","v":51500},null,{"$f":"+SUM(J55:J62)","v":43646.25},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+SUM(AF55:AF62)","v":0},0,0,19900,7900,11850,11850,0,0,{"$f":"+SUM(AO55:AO62)","v":0},0,0,16865.25,6695.25,10042.875,10042.875,0,0]
[null,"Act. 4.1.1","Elaboración de cartillas informativas, afiches, difusión en radio, televisión y prensa, Portal web",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,0]
[null,null,"Tarea 4.1.1.1","Spot Radial","Mes",6,2000,{"$f":"+G56*F56","v":12000},0.84750000000000003,10170,null,0,0,0,0.2,0.2,0.3,0.3,0,null,null,{"$f":"+L56","v":0},0,0,0.2,0.2,0.3,0.3,0,null,null,{"$f":"+L56*$H56","v":0},0,0,2400,2400,3600,3600,0,0,{"$f":"+L56*$J56","v":0},0,0,2034,2034,3051,3051,0,0]
[null,null,"Tarea 4.1.1.2","Spot Televisivo","Mes",6,2250,13500,0.84750000000000003,11441.25,null,0,0,0,0.2,0.2,0.3,0.3,0,null,null,0,0,0,0.2,0.2,0.3,0.3,0,null,null,0,0,0,2700,2700,4050,4050,0,0,0,0,0,2288.25,2288.25,3432.375,3432.375,0,0]
[null,null,"Tarea 4.1.1.3","Redes Sociales","Mes",1,2000,2000,0.84750000000000003,1695,null,0,0,0,0.2,0.2,0.3,0.3,0,null,null,0,0,0,0.2,0.2,0.3,0.3,0,null,null,0,0,0,400,400,600,600,0,0,0,0,0,339,339,508.5,508.5,0,0]
[null,null,"Tarea 4.1.1.4","Portal Web GORE","Mes",1,2000,2000,0.84750000000000003,1695,null,0,0,0,0.2,0.2,0.3,0.3,0,null,null,0,0,0,0.2,0.2,0.3,0.3,0,null,null,0,0,0,400,400,600,600,0,0,0,0,0,339,339,508.5,508.5,0,0]
[null,null,"Tarea 4.1.1.5","Tripticos","Millar",10,600,6000,0.84750000000000003,5085,null,0,0,0,1,0,0,0,0,null,null,0,0,0,1,0,0,0,0,null,null,0,0,0,6000,0,0,0,0,0,0,0,0,5085,0,0,0,0,0]
[null,null,"Tarea 4.1.1.6","Afiches","Millar",10,600,6000,0.84750000000000003,5085,null,0,0,0,1,0,0,0,0,null,null,0,0,0,1,0,0,0,0,null,null,0,0,0,6000,0,0,0,0,0,0,0,0,5085,0,0,0,0,0]
[null,"Act. 4.1.2","Elaboración de materiales varios",null,"Global",1,10000,{"$f":"+G62*F62","v":10000},0.84750000000000003,{"$f":"+I62*H62","v":8475},null,0,0,0,0.2,0.2,0.3,0.3,0,null,null,0,0,0,0.2,0.2,0.3,0.3,0,null,null,0,0,0,2000,2000,3000,3000,0,0,0,0,0,1695,1695,2542.5,2542.5,0,0]
[null,"Acción 4.2","…",null,null,null,null,{"$f":"+SUM(H64:H66)","v":128000},null,{"$f":"+SUM(J64:J66)","v":110800},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+SUM(AF64:AF66)","v":0},0,0,25600,25600,38400,38400,0,0,{"$f":"+SUM(AO64:AO66)","v":0},0,0,22160,22160,33240,33240,0,0]
[null,"Act. 4.2.1","Facilitador Intercultural (comunicador)",null,"Mes",8,4000,{"$f":"+G64*F64","v":32000},0.92,{"$f":"+I64*H64","v":29440},null,0,0,0,0.2,0.2,0.3,0.3,0,null,null,{"$f":"+L64","v":0},0,0,0.2,0.2,0.3,0.3,0,null,null,{"$f":"+L64*$H64","v":0},0,0,6400,6400,9600,9600,0,0,{"$f":"+L64*$J64","v":0},0,0,5888,5888,8832,8832,0,0]
[null,"Act. 4.2.2","Presentación pública del Proceso de ZF",null,"Taller",12,{"$f":"+G8","v":4000},{"$f":"+G65*F65","v":48000},0.84750000000000003,{"$f":"+I65*H65","v":40680},null,0,0,0,0.2,0.2,0.3,0.3,0,null,null,0,0,0,0.2,0.2,0.3,0.3,0,null,null,0,0,0,9600,9600,14400,14400,0,0,0,0,0,8136,8136,12204,12204,0,0]
[null,"Act. 4.2.3","Talleres de difusión y sensibilización en cada provincia",null,"Taller",12,{"$f":"+G65","v":4000},{"$f":"+G66*F66","v":48000},0.84750000000000003,{"$f":"+I66*H66","v":40680},null,0,0,0,0.2,0.2,0.3,0.3,0,null,null,0,0,0,0.2,0.2,0.3,0.3,0,null,null,0,0,0,9600,9600,14400,14400,0,0,0,0,0,8136,8136,12204,12204,0,0]
[null,"COMPONENTE 5.Adecuados mecanismos y espacios de participación  en el proceso de ZF",null,null,null,null,null,{"$f":"+H68+H72","v":259600},null,{"$f":"+J68+J72","v":220011},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+AF68+AF72","v":0},0,129800,0,0,51920,51920,25960,0,{"$f":"+AO68+AO72","v":0},0,110005.5,0,0,44002.2,44002.2,22001.1,0]
[null,"Acción 5.1","…",null,null,null,null,{"$f":"+SUM(H69:H71)","v":129800},null,{"$f":"+SUM(J69:J71)","v":110005.5},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+SUM(AF69:AF71)","v":0},0,0,0,0,51920,51920,25960,0,{"$f":"+SUM(AO69:AO71)","v":0},0,0,0,0,44002.2,44002.2,22001.1,0]
[null,"Act. 5.1.1","Materiales",null,"Global",1,5000,{"$f":"+G69*F69","v":5000},0.84750000000000003,{"$f":"+I69*H69","v":4237.5},null,0,0,0,0,0,0.4,0.4,0.2,null,null,{"$f":"+L69","v":0},0,0,0,0,0.4,0.4,0.2,null,null,{"$f":"+L69*$H69","v":0},0,0,0,0,2000,2000,1000,0,{"$f":"+L69*$J69","v":0},0,0,0,0,1695,1695,847.5,0]
[null,"Act. 5.1.2","Talleres",null,"Taller",12,{"$f":"+G8","v":4000},{"$f":"+G70*F70","v":48000},0.84750000000000003,40680,null,0,0,0,0,0,0.4,0.4,0.2,null,null,0,0,0,0,0,0.4,0.4,0.2,null,null,0,0,0,0,0,19200,19200,9600,{"$f":"+H70-SUM(AF70:AM70)","v":0},0,0,0,0,0,16272,16272,8136,{"$f":"+J70-SUM(AO70:AV70)","v":0}]
[null,"Act. 5.1.3","Viáticos",null,"día/persona",{"$f":"20*F70","v":240},{"$f":"+G23","v":320},76800,0.84750000000000003,65088,null,0,0,0,0,0,0.4,0.4,0.2,null,null,0,0,0,0,0,0.4,0.4,0.2,null,null,0,0,0,0,0,30720,30720,15360,0,0,0,0,0,0,26035.200000000001,26035.200000000001,13017.6,0]
[null,"Acción 5.2","…",null,null,null,null,{"$f":"+SUM(H73:H75)","v":129800},null,{"$f":"+SUM(J73:J75)","v":110005.5},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+SUM(AF73:AF75)","v":0},0,129800,0,0,0,0,0,0,{"$f":"+SUM(AO73:AO75)","v":0},0,110005.5,0,0,0,0,0,0]
[null,"Act. 5.1.1","Materiales",null,"Global",1,5000,{"$f":"+G73*F73","v":5000},0.84750000000000003,{"$f":"+I73*H73","v":4237.5},null,0,0,1,0,0,0,0,0,null,null,{"$f":"+L73","v":0},0,1,0,0,0,0,0,null,null,{"$f":"+L73*$H73","v":0},0,5000,0,0,0,0,0,0,{"$f":"+L73*$J73","v":0},0,4237.5,0,0,0,0,0,0]
[null,"Act. 5.1.2","Talleres",null,"Taller",12,{"$f":"+G70","v":4000},{"$f":"+G74*F74","v":48000},0.84750000000000003,40680,null,0,0,1,0,0,0,0,0,null,null,0,0,1,0,0,0,0,0,null,null,0,0,48000,0,0,0,0,0,0,0,0,40680,0,0,0,0,0,0]
[null,"Act. 5.1.3","Viáticos",null,"día/persona",{"$f":"20*F74","v":240},{"$f":"+G71","v":320},76800,0.84750000000000003,65088,null,0,0,1,0,0,0,0,0,null,null,0,0,1,0,0,0,0,0,null,null,0,0,76800,0,0,0,0,0,0,0,0,65088,0,0,0,0,0,0]
[]
[null,"GESTIÓN DEL PROYECTO",null,null,null,null,null,{"$f":"+SUM(H78:H90)","v":297900},null,{"$f":"+SUM(J78:J90)","v":270738.30508474575},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+SUM(AF78:AF90)","v":31500},{"$f":"+SUM(AG78:AG90)","v":37985.714285714283},37985.714285714283,37985.714285714283,37985.714285714283,37985.714285714283,37985.714285714283,38485.714285714283,0,{"$f":"+SUM(AO78:AO90)","v":28980},34476.368038740919,34476.368038740919,34476.368038740919,34476.368038740919,34476.368038740919,34476.368038740919,34900.096852300245,0]
[null,"Act.1","Expediente Técnico",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,0]
[null,"Act.2","Supervisión",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,0]
[null,"Act.3","Liquidación del Proyecto",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,0]
[null,"Act.4","Personal",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,0]
[null,null,"Act. 4.1","Jefe de Proyecto","mes",{"$f":"12*2","v":24},7000,{"$f":"+G82*F82","v":168000},0.92,{"$f":"+I82*H82","v":154560},null,0.125,0.125,0.125,0.125,0.125,0.125,0.125,0.125,null,null,{"$f":"+L82","v":0.125},0.125,0.125,0.125,0.125,0.125,0.125,0.125,null,null,{"$f":"+L82*$H82","v":21000},21000,21000,21000,21000,21000,21000,21000,0,{"$f":"+L82*$J82","v":19320},19320,19320,19320,19320,19320,19320,19320,0]
[null,null,"Act. 4.2","Administrador","mes",{"$f":"12*2","v":24},3500,{"$f":"+G83*F83","v":84000},0.92,{"$f":"+I83*H83","v":77280},null,0.125,0.125,0.125,0.125,0.125,0.125,0.125,0.125,null,null,0.125,0.125,0.125,0.125,0.125,0.125,0.125,0.125,null,null,10500,10500,10500,10500,10500,10500,10500,10500,0,9660,9660,9660,9660,9660,9660,9660,9660,0]
[null,null,"Act. 4.3","Asistente",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,0]
[null,"Act.5","Gastos Administrativos",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,0]
[null,null,"Act. 5.1","Courier (Remisión de expediente a SERFOR/MINAM)","Global",1,500,{"$f":"+G86*F86","v":500},{"$f":"1/(1.18)","v":0.84745762711864414},{"$f":"+I86*H86","v":423.72881355932208},null,0,0,0,0,0,0,0,1,null,null,{"$f":"+L86","v":0},0,0,0,0,0,0,1,null,null,{"$f":"+L86*$H86","v":0},0,0,0,0,0,0,500,0,{"$f":"+L86*$J86","v":0},0,0,0,0,0,0,423.72881355932208,0]
[null,null,"Act. 5.2","Pasajes aéreos  (I/V) / Asistencia Técnica Serfor","Pasaje",40,{"$f":"150*3.3","v":495},{"$f":"+G87*F87","v":19800},0.84745762711864414,{"$f":"+I87*H87","v":16779.661016949154},null,0,0.14285714285714288,{"$f":"+M87","v":0.14285714285714288},0.14285714285714288,0.14285714285714288,0.14285714285714288,0.14285714285714288,0.14285714285714288,null,null,0,0.14285714285714288,0.14285714285714288,0.14285714285714288,0.14285714285714288,0.14285714285714288,0.14285714285714288,0.14285714285714288,null,null,0,2828.5714285714289,2828.5714285714289,2828.5714285714289,2828.5714285714289,2828.5714285714289,2828.5714285714289,2828.5714285714289,0,0,2397.0944309927368,2397.0944309927368,2397.0944309927368,2397.0944309927368,2397.0944309927368,2397.0944309927368,2397.0944309927368,0]
[null,null,"Act. 5.3","Viáticos / Asistencia Técnica Serfor","día/persona",80,320,{"$f":"+G88*F88","v":25600},0.84745762711864414,{"$f":"+I88*H88","v":21694.91525423729},null,0,0.14285714285714288,0.14285714285714288,0.14285714285714288,0.14285714285714288,0.14285714285714288,0.14285714285714288,0.14285714285714288,null,null,0,0.14285714285714288,0.14285714285714288,0.14285714285714288,0.14285714285714288,0.14285714285714288,0.14285714285714288,0.14285714285714288,null,null,0,3657.1428571428578,3657.1428571428578,3657.1428571428578,3657.1428571428578,3657.1428571428578,3657.1428571428578,3657.1428571428578,0,0,3099.273607748185,3099.273607748185,3099.273607748185,3099.273607748185,3099.273607748185,3099.273607748185,3099.273607748185,0]
[null,null,"Act. 5.4","Otros gastos",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,0]
[null,"Costo Total de Inversión",null,null,null,null,null,{"$f":"+H67+H53+H43+H35+H5+H77","v":3753623.96},null,{"$f":"+J67+J53+J43+J35+J5+J77","v":3229512.8093220335},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+AF67+AF53+AF43+AF35+AF5+AF77","v":313101.95999999996},815879.71428571432,598396.38095238106,619491.38095238106,668843.38095238106,263155.71428571426,188155.71428571429,286599.71428571426,{"$f":"+H91-SUM(AF91:AM91)","v":0},{"$f":"+AO67+AO53+AO43+AO35+AO5+AO77","v":271107.76271186443},697190.60532687663,512888.19572235679,531225.74233252625,573048.96267150936,229480.76507263922,165921.44303874092,248649.33244552062,0]

{"sheet":"Hoja1","index":20,"n_rows":30,"n_cols":7,"rows_kept":30,"cut":false,"hidden":true,"merged":[]}
[]
[null,null,"Sí",1,"Celda vinculada"]
[null,null,"No",0]
[]
[null,null,"Sí",1,"Celda vinculada"]
[null,null,"No",0]
[]
[null,null,"Sí",1,"Celda vinculada"]
[null,null,"No",0]
[null,null,null,null,null,null,0]
[null,null,"Sí",1,"Celda vinculada",null,1]
[null,null,"No",0,3,null,2]
[null,null,null,null,null,null,3]
[null,null,"Sí",1,"Celda vinculada",null,4]
[null,null,"No",0,3,null,5]
[null,null,null,null,null,null,6]
[null,null,"Sí",1,"Celda vinculada",null,7]
[null,null,"No",0,null,null,8]
[null,null,null,null,null,null,9]
[null,null,"Sí",1,"Celda vinculada",null,10]
[null,null,"No",0]
[]
[null,null,"Sí",1,"Celda vinculada"]
[null,null,"No",0]
[]
[null,null,"Sí",1,"Celda vinculada"]
[null,null,"No",0]
[]
[null,null,"Sí",1,"Celda vinculada"]
[null,null,"No",0]

{"sheet":"Hoja2","index":21,"n_rows":38,"n_cols":19,"rows_kept":38,"cut":false,"hidden":true,"merged":[[11,5,11,6],[11,7,11,8],[11,9,11,10]]}
[]
[]
[null,"Cooperante"]
[null,"Beneficiario"]
[null,"Oponente"]
[null,"Perjudicado"]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,8,null,1,null,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,null,1,null,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,null,1,null,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,null,1,null,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,null,1,null,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,null,1,null,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,null,1,null,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,null,1,null,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,null,1,null,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,null,1,null,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,null,1,null,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,null,1,null,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,null,1,null,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,null,1,null,1]
[]
[]
[]
[]
[]
[]
[null,"Especificaciones técnicas"]
[null,"Garantía del servicio de mantenimiento a los equipos",null,null,null,null,null,null,null,"Sí"]
[null,"Grado de dependencia del proveedor",null,null,null,null,null,null,null,"No"]
[null,"Entrenamiento que brindará el proveedor"]
[null,"Obsolescencia tecnológica"]
[null,"Seguridad industrial y riesgos ambientales asociados"]
[null,"Condiciones climáticas y físicas"]
[null,"Disponibilidad de recursos"]