{"text_format":"1","workbook":"xlsx","n_sheets":18,"sheets":["MENÚ","DATOS GENERALES","AREA DE ESTUDIO","UNIDAD PRODUCTORA","PROBLEMA-OBJETIVO","HORIZONTE DE EVALUACIÓN","BRECHA DE SERVICIO","ANALISIS TÉCNICO","COSTO TOTAL","EVALUACION SOCIAL","SOSTENIBILIDAD","GESTIÓN","IMPACTO AMBIENTAL","CONCLUSIONES","FIRMAS","DETALLE DEL COSTO TOTAL","Hoja1","Hoja2"],"not_rendered":{"charts":0,"images":4,"macros":1,"external_links":1,"defined_names":14,"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":51,"n_cols":25,"rows_kept":51,"cut":false,"hidden":false,"merged":[[44,12,44,14],[44,16,44,18],[44,20,44,22],[44,24,44,26],[20,1,20,4],[20,6,20,20],[22,1,22,4],[22,6,22,20],[24,1,24,4],[24,6,24,20],[33,1,33,7],[33,9,33,14],[33,16,33,20],[35,1,35,7],[35,9,35,14],[35,16,35,20],[8,1,8,15],[8,17,8,26],[28,1,28,4],[28,6,28,20],[49,1,49,10],[49,12,49,26],[46,1,46,10],[46,12,46,14],[46,16,46,18],[46,20,46,22],[46,24,46,26],[26,1,26,4],[26,6,26,20],[42,1,42,10],[42,12,42,26],[44,1,44,10],[10,1,10,15],[10,17,10,26],[12,1,12,15],[12,17,12,26],[14,1,14,15],[14,17,14,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":28,"n_cols":20,"rows_kept":28,"cut":false,"hidden":false,"merged":[[9,18,9,21],[10,6,10,9],[10,10,10,13],[10,14,10,17],[10,18,10,21],[9,2,9,5],[10,2,10,5],[9,6,9,9],[9,10,9,13],[9,14,9,17],[2,1,2,27],[8,2,8,5],[8,6,8,9],[8,10,8,13],[8,14,8,17],[8,18,8,21],[6,1,6,14],[4,1,4,27],[11,14,11,17],[11,18,11,21],[16,2,16,5],[11,6,11,9],[17,6,17,9],[16,6,16,9],[16,10,16,13],[16,14,16,17],[16,18,16,21],[11,2,11,5],[17,2,17,5],[17,10,17,13],[17,14,17,17],[17,18,17,21],[11,10,11,13],[19,6,19,9],[22,1,23,27],[25,1,26,18],[25,19,25,23],[26,19,27,23],[27,1,27,5],[19,2,19,5],[19,10,19,13],[19,14,19,17],[19,18,19,21],[18,2,18,5],[18,6,18,9],[18,10,18,13],[18,14,18,17],[18,18,18,21]]}
[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:"]

{"sheet":"UNIDAD PRODUCTORA","index":3,"n_rows":19,"n_cols":15,"rows_kept":19,"cut":false,"hidden":false,"merged":[[20,1,21,19],[4,1,4,4],[4,5,4,15],[6,1,6,8],[6,9,6,15],[12,14,12,17],[15,14,15,17],[14,8,14,10],[14,11,14,13],[15,5,15,7],[15,8,15,10],[15,11,15,13],[2,1,2,20],[18,1,18,13],[13,14,13,17],[14,14,14,17],[12,2,12,4],[12,5,12,7],[12,8,12,10],[12,11,12,13],[13,2,13,4],[14,2,14,4],[15,2,15,4],[13,5,13,7],[13,8,13,10],[13,11,13,13],[14,5,14,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 la Unidad Productora"]

{"sheet":"PROBLEMA-OBJETIVO","index":4,"n_rows":80,"n_cols":14,"rows_kept":80,"cut":false,"hidden":false,"merged":[[79,1,81,10],[64,1,66,4],[64,5,64,8],[65,5,65,8],[66,5,66,8],[69,1,69,13],[36,1,36,4],[36,5,36,8],[38,1,38,4],[38,5,38,8],[43,2,43,5],[43,6,43,9],[45,6,45,9],[50,6,50,9],[53,6,53,9],[56,5,56,8],[60,5,60,8],[61,1,63,4],[61,5,61,8],[62,5,62,8],[36,9,36,11],[38,9,38,11],[45,1,47,1],[45,2,47,5],[51,1,53,1],[51,2,53,5],[63,5,63,8],[48,1,50,1],[48,2,50,5],[56,1,56,4],[58,1,60,4],[58,5,58,8],[59,5,59,8],[29,9,29,12],[34,1,34,9],[16,5,18,8],[11,9,11,12],[14,9,14,12],[16,9,16,12],[17,9,17,12],[15,9,15,12],[18,9,18,12],[20,1,20,4],[20,5,20,8],[22,1,24,4],[22,5,24,8],[28,1,30,4],[28,5,30,8],[28,9,28,12],[30,9,30,12],[71,1,71,10],[73,1,75,10],[76,1,78,10],[2,1,2,13],[12,9,12,12],[4,1,4,4],[6,1,6,4],[4,5,4,8],[6,5,6,8],[13,1,15,4],[13,9,13,12],[16,1,18,4],[10,5,12,8],[13,5,15,8],[4,9,4,11],[25,1,27,4],[25,5,27,8],[25,9,25,12],[26,9,26,12],[6,9,6,11],[8,9,8,12],[10,9,10,12],[8,1,8,4],[8,5,8,8],[10,1,12,4],[27,9,27,12],[22,9,22,12],[23,9,23,12],[24,9,24,12],[20,9,20,12]]}
[null,"SECCIÓN N°04: PROBLEMA/OBJETIVO"]
[]
[null,"4.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,"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,"4.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,"4.03 DESCRIPCIÓN DE LAS ALTERNATIVAS DE SOLUCIÓN AL PROBLEMA"]
[]
[null,"Descripción de Alternativas de Solución"]
[]
[null,"Alternativa 1:"]
[]
[]
[null,"…"]
[]
[]
[null,"Alternativa \"n\":"]

{"sheet":"HORIZONTE DE EVALUACIÓN","index":5,"n_rows":12,"n_cols":10,"rows_kept":12,"cut":false,"hidden":false,"merged":[[4,1,4,12],[7,1,8,12]]}
[null,"SECCIÓN N°05: HORIZONTE DE EVALUACIÓN"]
[]
[null,"FORMULACIÓN"]
[]
[null,"5.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,"Número de años del horizonte de evaluación",null,null,null,null,null,{"$f":"+H7+H10","v":0},null,{"$f":"+J7+J10","v":0}]

{"sheet":"BRECHA DE SERVICIO","index":6,"n_rows":42,"n_cols":13,"rows_kept":42,"cut":false,"hidden":false,"merged":[[17,2,17,3],[26,2,26,3],[24,2,24,3],[16,2,16,3],[5,1,5,12],[8,1,8,12],[20,1,20,12],[12,2,12,3],[14,2,14,3],[15,2,15,3],[40,2,40,3],[27,2,27,3],[41,2,41,3],[28,2,28,3],[29,2,29,3],[35,3,35,8],[36,2,36,3],[38,2,38,3],[39,2,39,3],[32,1,32,12]]}
[null,"SECCIÓN N°06: BRECHA DE SERVICIO"]
[]
[null,"FORMULACIÓN"]
[]
[]
[null,"ESTUDIO DE MERCADO DEL SERVICIO PÚBLICO"]
[]
[null,"6.01 Definición y caracterización del servicio o de la cartera de servicios"]
[]
[]
[null,"6.02 Análisis 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,"Parámetros, supuestos considerados y fuentes de información"]
[]
[]
[null,"6.03 Análisis 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,"Parámetros, supuestos considerados y fuentes de información"]
[]
[]
[null,"6.04 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\""]

{"sheet":"ANALISIS TÉCNICO","index":7,"n_rows":20,"n_cols":2,"rows_kept":20,"cut":false,"hidden":false,"merged":[[19,1,20,12],[21,1,21,12],[11,1,11,13],[12,1,12,13],[3,1,4,12],[7,1,8,12],[9,1,9,12],[13,1,14,12],[15,1,15,12],[17,1,17,13]]}
[null,"SECCIÓN N°07: 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,"7.01 ANÁLISIS DE TAMAÑO (¿Cuánto producir?)"]
[]
[null,"Descripción de la alternativa técnica seleccionada"]
[]
[]
[]
[null,"7.02 ANÁLISIS DE LOCALIZACIÓN (¿Dónde producir?)"]
[]
[null,"Descripción de la alternativa técnica seleccionada"]
[]
[]
[]
[null,"7.03 ANÁLISIS DE TECNOLOGÍA (¿Cómo producir?)"]
[]
[null,"Descripción de la alternativa técnica seleccionada"]

{"sheet":"COSTO TOTAL","index":8,"n_rows":133,"n_cols":17,"rows_kept":133,"cut":false,"hidden":false,"merged":[[81,12,82,12],[81,13,82,13],[81,14,82,14],[81,15,82,15],[80,16,82,17],[94,1,94,3],[94,4,94,5],[94,6,94,7],[95,1,95,3],[95,4,95,5],[95,6,95,7],[92,1,92,3],[92,4,92,5],[92,6,92,7],[93,1,93,3],[93,4,93,5],[93,6,93,7],[90,1,90,3],[90,4,90,5],[90,6,90,7],[91,1,91,3],[91,4,91,5],[91,6,91,7],[88,1,88,3],[81,11,82,11],[84,1,84,3],[84,4,84,5],[84,6,84,7],[85,1,85,3],[85,4,85,5],[85,6,85,7],[62,3,63,4],[76,5,76,6],[77,5,77,6],[78,5,78,6],[80,1,80,5],[80,6,82,7],[81,1,82,3],[81,4,82,5],[66,3,66,4],[67,3,67,4],[65,3,65,4],[129,5,129,6],[130,5,130,6],[131,5,131,6],[125,7,125,8],[126,7,126,8],[19,6,19,7],[21,6,21,7],[6,8,7,8],[6,9,7,9],[13,6,13,7],[14,6,14,7],[15,6,15,7],[16,6,16,7],[17,6,17,7],[40,4,40,5],[38,4,38,5],[44,5,45,6],[30,4,30,5],[32,4,32,5],[33,4,33,5],[34,4,34,5],[36,4,36,5],[44,7,44,15],[58,1,58,5],[10,6,10,7],[11,6,11,7],[12,6,12,7],[69,1,70,2],[69,3,69,4],[70,3,70,4],[81,8,82,8],[20,1,20,3],[5,1,5,5],[6,4,7,5],[10,4,10,5],[11,4,11,5],[12,4,12,5],[14,4,14,5],[15,4,15,5],[5,8,5,9],[38,1,38,3],[40,1,40,3],[36,1,36,3],[52,5,52,6],[53,5,53,6],[54,5,54,6],[55,5,55,6],[44,3,45,4],[23,12,23,13],[50,1,52,2],[53,1,55,2],[51,3,51,4],[52,3,52,4],[53,3,53,4],[62,1,63,2],[65,1,66,2],[67,1,68,2],[59,1,59,5],[54,3,54,4],[55,3,55,4],[47,3,47,4],[48,3,48,4],[49,3,49,4],[50,3,50,4],[44,1,45,2],[47,1,49,2],[48,5,48,6],[49,5,49,6],[50,5,50,6],[51,5,51,6],[5,12,7,12],[5,13,7,13],[80,8,80,15],[16,4,16,5],[18,4,18,5],[19,4,19,5],[81,9,82,9],[81,10,82,10],[68,3,68,4],[35,1,35,3],[30,1,30,3],[32,1,32,3],[33,1,33,3],[34,1,34,3],[58,6,58,7],[59,6,59,7],[47,5,47,6],[6,1,7,3],[10,1,10,3],[11,1,11,3],[12,1,12,3],[14,1,14,3],[15,1,15,3],[16,1,16,3],[130,3,130,4],[131,3,131,4],[120,5,123,6],[120,7,123,8],[93,16,93,17],[94,16,94,17],[95,16,95,17],[97,16,97,17],[97,1,97,15],[106,1,106,10],[116,4,116,6],[114,4,114,6],[120,1,120,4],[120,9,121,15],[120,16,123,16],[101,1,101,2],[101,11,101,12],[102,1,102,2],[102,11,102,12],[103,1,103,2],[99,1,99,2],[99,11,99,12],[104,1,104,2],[104,11,104,12],[132,1,133,16],[127,7,127,8],[128,7,128,8],[129,7,129,8],[130,7,130,8],[131,7,131,8],[121,1,123,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,1,131,2],[121,3,123,4],[125,3,125,4],[126,3,126,4],[127,3,127,4],[128,3,128,4],[129,3,129,4],[125,5,125,6],[126,5,126,6],[127,5,127,6],[128,5,128,6],[96,16,96,17],[43,1,43,5],[57,1,57,7],[74,1,74,7],[105,1,105,2],[105,11,105,12],[103,11,103,12],[106,11,106,12],[107,1,107,10],[107,11,107,12],[84,16,84,17],[85,16,85,17],[86,16,86,17],[87,16,87,17],[88,16,88,17],[89,16,89,17],[90,16,90,17],[91,16,91,17],[92,16,92,17],[88,4,88,5],[88,6,88,7],[89,1,89,3],[89,4,89,5],[89,6,89,7],[4,1,4,6],[118,1,118,7],[9,1,9,5],[13,1,13,5],[17,1,17,5],[21,1,21,5],[23,1,23,11],[96,1,96,5],[96,6,96,7],[86,1,86,3],[86,4,86,5],[86,6,86,7],[87,1,87,3],[87,4,87,5],[87,6,87,7],[5,10,5,11],[6,10,7,10],[6,11,7,11],[18,6,18,7],[108,1,108,8],[18,1,18,3],[19,1,19,3],[5,6,7,7],[9,6,9,7]]}
[null,"SECCIÓN N° 08: COSTOS DEL PROYECTO"]
[]
[null,"Estructura de costos"]
[]
[null,"8.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,"Componente /acción",null,null,"Activos ",null,null,null,"Unidad de \nmedida","Cantidad","Unidad de \nmedida","Cantidad"]
[]
[]
[null,"Componente 1:"]
[null,"Acción1"]
[null,"…"]
[null,"Acción \"n\""]
[null,"Componente 2"]
[null,"Acción1"]
[null,"…"]
[null,"Acción \"n\""]
[null,"Componente \"n\""]
[null,"Acción 1"]
[null,"…"]
[null,"Acción \"n\""]
[null,"Medidas de reducción del riesgo y de mitigación ambiental"]
[]
[null,"SubTotal de costos de inversión",null,null,null,null,null,null,null,null,null,null,{"$f":"+SUM(N10:N22)","v":0}]
[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(E33:E37)","v":0}]
[]
[null,"Costo Total de inversión",null,null,{"$f":"+E39+M24","v":0},null,"Anexar los costos detallados"]
[]
[]
[null,"8.02 Costos de reinversiones"]
[null,"Reinversiones",null,"Activos",null,"Tipo de factor productivo",null,"AÑOS (Soles)"]
[null,null,null,null,null,null,null,1,2,3,4,5,"…","…","…","n"]
[]
[null,null,null,"a1"]
[null,null,null,"a2","a2"]
[null,null,null,"…","…"]
[null,null,null,"a1","a1"]
[null,null,null,"a2","a2"]
[null,null,null,"…","…"]
[null,null,null,"a1","a1"]
[null,null,null,"a2","a2"]
[null,null,null,"…","…"]
[]
[null,"8.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,"MANTENIMIENTO"]
[null,"CON PROYECTO",null,"OPERACIÓN"]
[null,null,null,"MANTENIMIENTO"]
[null,"INCREMENTAL",null,"OPERACIÓN"]
[null,null,null,"MANTENIMIENTO"]
[]
[null,"* Agregar anexo de costos"]
[]
[null,"8.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,"Acción1"]
[null,"…"]
[null,"Acción \"n\""]
[null,"Componente 2"]
[null,"Acción1"]
[null,"…"]
[null,"Acción \"n\""]
[null,"Componente \"n\""]
[null,"Acción 1"]
[null,"…"]
[null,"Acción \"n\""]
[null,"Medidas de la gestión del riesgo y de las medidas de mitigación"]
[null,"Sub total :"]
[]
[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,"Costo total de la Inversión :"]
[null,"Nota: La gestión del proyecto, el expediente técnico o documento equivalente, la supervisión y la liquidación no son items. \nLos gastos generales, la utilidad y el IGV forman parte de los ítem."]
[]
[]
[null,"Monto de inversión financiado con fondos públicos"]
[null,"¿El proyecto tiene aporte de los beneficiarios?"]
[]
[null,"SÍ",null,null,"Aporte de los beneficiarios (S/):"]
[]
[null,"NO",null,null,"Financiado con fondos públicos (S/):"]
[]
[null,"8.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":9,"n_rows":17,"n_cols":8,"rows_kept":17,"cut":false,"hidden":false,"merged":[[16,1,16,7],[11,1,14,1],[11,2,11,4],[12,2,12,4],[13,2,13,4],[14,2,14,4],[4,1,4,12],[2,1,2,12],[6,2,6,4],[8,1,10,1],[8,2,8,4],[9,2,9,4],[10,2,10,4]]}
[null,"SECCIÓN N° 09: EVALUACIÓN SOCIAL"]
[]
[null,"EVALUACIÓN"]
[]
[null,"9.01 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"]

{"sheet":"SOSTENIBILIDAD","index":10,"n_rows":22,"n_cols":12,"rows_kept":22,"cut":false,"hidden":false,"merged":[[17,11,17,13],[18,11,18,13],[19,11,19,13],[4,6,4,9],[4,10,4,13],[6,10,6,13],[7,10,7,13],[8,10,8,13],[7,6,7,9],[8,6,8,9],[18,7,18,8],[19,7,19,8],[20,7,20,8],[17,9,17,10],[18,9,18,10],[19,9,19,10],[20,9,20,10],[4,1,4,5],[6,6,6,9],[6,1,6,5],[9,6,9,9],[15,1,15,3],[15,4,15,6],[15,7,15,8],[15,9,15,10],[9,10,9,13],[21,1,21,13],[17,14,20,14],[7,1,7,5],[8,1,8,5],[9,1,9,5],[15,11,15,13],[17,1,17,3],[18,1,18,3],[19,1,19,3],[20,1,20,3],[17,4,17,6],[18,4,18,6],[19,4,19,6],[20,4,20,6],[20,11,20,13],[17,7,17,8]]}
[null,"SECCIÓN N°10: SOSTENIBILIDAD"]
[]
[null,"10.01 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,"10.02 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 qué tan posible es la ocurrencia del riesgo que afecte el desempeño del proyecto."]

{"sheet":"GESTIÓN","index":11,"n_rows":59,"n_cols":14,"rows_kept":59,"cut":false,"hidden":false,"merged":[[58,1,58,11],[60,1,60,11],[54,1,54,5],[56,1,56,8],[48,1,48,5],[50,1,50,5],[51,1,51,5],[52,1,52,5],[53,1,53,5],[33,1,33,4],[33,7,33,8],[34,1,34,4],[34,7,34,8],[38,1,38,5],[40,1,40,5],[41,1,41,5],[42,1,42,5],[43,1,43,5],[44,1,44,5],[30,1,30,4],[30,7,30,8],[31,1,31,4],[31,7,31,8],[32,1,32,4],[32,7,32,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],[24,1,24,4],[24,7,24,8],[25,1,25,4],[25,7,25,8],[26,1,26,4],[26,7,26,8],[21,1,21,4],[21,7,21,8],[22,1,22,4],[22,7,22,8],[23,1,23,4],[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],[15,1,15,4],[15,7,15,8],[16,1,16,4],[16,7,16,8],[17,1,17,4],[17,7,17,8],[12,1,12,4],[12,7,12,8],[13,1,13,4],[13,7,13,8],[14,1,14,4],[14,7,14,8],[9,1,9,4],[9,7,9,8],[10,1,10,4],[10,7,10,8],[11,1,11,4],[11,7,11,8],[5,1,6,4],[5,5,5,6],[5,7,6,8],[5,9,5,13],[8,1,8,4],[8,7,8,8]]}
[null,"SECCIÓN N°11: GESTIÓN DEL PROYECTO"]
[]
[null,null,null,null,null,"Años","Meses"]
[null,"11.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,"11.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,"11.03 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."]
[null,"11.04 Requerimientos institucionales y/o normativos"]
[null,"(Referido a los aspectos técnicos y regulatorios que el proyecto deberá cumplir durante su fase de Ejecución y fase de Funcionamiento (como el saneamiento técnico legal, sustento de factibilidad de servicios de agua, desagüe y electricidad, certificado de parámetros urbanísticos, cumplimiento de permisos y autorizaciones, entre otros)."]

{"sheet":"IMPACTO AMBIENTAL","index":12,"n_rows":13,"n_cols":9,"rows_kept":13,"cut":false,"hidden":false,"merged":[[12,1,12,4],[8,5,8,7],[12,5,12,7],[10,5,10,7],[5,1,5,4],[7,1,7,4],[8,1,8,4],[9,1,9,4],[10,1,10,4],[7,5,7,7],[5,5,5,7],[9,5,9,7],[11,5,11,7],[11,1,11,4]]}
[null,"SECCIÓN N°12: IMPACTO AMBIENTAL"]
[]
[]
[null,"12.01 Matriz de 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 n:"]
[null,"Durante el Funcionamiento"]
[null,"Impacto 1:"]
[null,"Impacto n:"]

{"sheet":"CONCLUSIONES","index":13,"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°13: CONCLUSIONES Y RECOMENDACIONES"]
[]
[null,"13.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":14,"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°14: FIRMAS"]
[]
[null,"14.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":"DETALLE DEL COSTO TOTAL","index":15,"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":"+'[1]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":"+'[1]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":"+'[1]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":"+'[1]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":16,"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":17,"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,"Grado de dependencia del proveedor"]
[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"]