{"text_format":"1","workbook":"xlsx","n_sheets":14,"sheets":["Ficha Mejoramiento Sist Riego","Kc","Ficha Automática","Balance","Demanda","Oferta","1. Identificación","2. Balance Hídrico","3. Costos","4. Beneficios","5. Sostenibilidad","Selección de Datos","Datos","Ppto Ref"],"not_rendered":{"charts":2,"images":3,"macros":1,"external_links":2,"defined_names":6,"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":"Ficha Mejoramiento Sist Riego","index":0,"n_rows":436,"n_cols":16,"rows_kept":436,"cut":false,"hidden":true,"merged":[[367,1,367,2],[173,3,175,5],[173,6,175,9],[166,3,169,5],[403,4,403,6],[376,1,376,4],[190,4,190,5],[255,1,255,3],[351,4,351,9],[352,4,352,9],[245,2,245,6],[189,6,189,7],[189,8,189,9],[190,6,190,7],[190,8,190,9],[170,6,172,9],[167,6,167,9],[168,6,168,9],[169,6,169,9],[275,1,275,2],[298,1,298,2],[219,1,222,2],[166,6,166,9],[224,1,224,9],[1,1,1,9],[2,1,2,9],[10,1,10,9],[14,1,14,3],[14,4,14,9],[114,1,114,3],[119,1,119,3],[39,4,39,6],[39,8,39,9],[88,4,88,9],[110,8,110,9],[89,4,89,9],[92,4,92,9],[85,4,85,9],[94,1,95,1],[94,2,95,2],[112,7,112,9],[110,1,110,3],[106,4,106,9],[112,1,112,3],[113,1,113,3],[113,7,113,9],[111,1,111,3],[115,1,115,3],[21,4,21,9],[23,4,23,9],[25,4,25,9],[36,4,36,6],[36,8,36,9],[37,4,37,6],[37,8,37,9],[15,1,15,3],[15,4,15,9],[16,1,16,3],[16,4,16,9],[17,1,17,3],[17,4,17,9],[40,4,40,6],[40,8,40,9],[42,4,42,6],[43,4,43,6],[256,1,256,3],[257,1,257,3],[45,4,45,9],[47,4,47,9],[54,4,54,9],[63,4,63,9],[246,2,246,6],[148,1,148,9],[147,1,147,9],[121,1,121,3],[122,1,122,3],[160,1,160,3],[136,1,136,9],[137,1,137,9],[152,2,152,9],[153,2,153,9],[154,2,154,9],[123,1,123,3],[242,2,242,6],[218,1,218,2],[55,4,55,9],[56,4,56,9],[57,4,57,9],[62,4,62,9],[141,2,141,4],[140,2,140,4],[94,3,94,6],[86,4,86,9],[87,4,87,9],[90,4,90,9],[67,2,67,3],[67,5,67,6],[139,2,139,4],[139,5,139,8],[192,15,192,17],[193,15,193,17],[189,4,189,5],[189,1,189,3],[408,2,408,3],[408,4,408,6],[270,4,270,9],[271,4,271,9],[379,1,379,7],[405,2,405,3],[404,2,404,3],[406,2,406,3],[406,4,406,6],[407,2,407,3],[407,4,407,6],[381,2,381,4],[334,4,334,9],[358,1,358,2],[247,2,247,6],[333,4,333,9],[212,1,214,9],[226,1,228,9],[231,3,231,8],[269,4,269,9],[165,1,165,2],[67,8,67,9],[120,1,120,3],[105,5,105,6],[105,8,105,9],[165,3,165,5],[165,6,165,9],[166,1,175,2],[141,5,141,9],[140,5,140,9],[170,3,172,5],[161,1,161,3],[330,1,330,2],[331,1,331,2],[282,1,282,2],[293,1,293,2],[305,1,305,2],[316,1,316,2],[179,1,179,3],[180,1,180,3],[181,1,181,3],[182,1,182,3],[183,1,183,3],[286,1,286,2],[309,1,309,2],[248,2,248,6],[232,1,232,2],[233,1,236,2],[243,2,243,6],[244,2,244,6],[205,1,205,2],[206,1,209,2],[268,4,268,9],[199,1,201,9],[321,1,321,3],[432,6,434,8],[435,6,435,8],[411,1,411,8],[412,1,412,8],[413,1,413,8],[414,1,414,8],[402,2,402,3],[402,4,402,6],[380,2,380,4],[338,1,340,9],[343,1,345,9],[435,2,435,4],[366,1,366,2],[404,4,404,6],[422,1,422,8],[423,1,423,8],[424,1,424,8],[416,1,416,8],[372,1,372,9],[377,1,377,9],[380,5,380,9],[381,5,381,9],[391,2,391,6],[405,4,405,6],[359,1,359,2],[403,2,403,3],[401,2,401,3],[401,4,401,6],[432,2,434,4],[419,3,419,8],[415,1,415,8],[420,1,420,8],[421,1,421,8]]}
[]
[null,"FICHA TÉCNICA - MEJORAMIENTO DE SISTEMA DE RIEGO SIMPLIFICADO - RIEGO TECNIFICADO"]
[null,"(La información registrada en esta ficha tiene carácter de Declaración Jurada)  "]
[]
[]
[null,"I.  ASPECTOS GENERALES"]
[]
[null,"1. CÓDIGO DEL PROYECTO",null,null,null,null,245545]
[]
[null,"2. NOMBRE DEL PROYECTO DE INVERSIÓN"]
[null,"MEJORAMIENTO DEL SERVICIO DE AGUA A NIVEL PARCELARIO CON UN SISTEMA DE RIEGO TECNIFICADO EN EL SECTOR “SAN LUIS” – DISTRITO DE LOCROJA – CHURCAMPA – HUANCAVELICA"]
[]
[null,"3. RESPONSABILIDAD FUNCIONAL "]
[]
[null,"FUNCIÓN",null,null,"AGROPECUARIA "]
[null,"DIVISIÓN FUNCIONAL",null,null,"RIEGO "]
[null,"GRUPO FUNCIONAL",null,null,"RIEGO TECNIFICADO"]
[null,"RESPONSABLE FUNCIONAL",null,null,"AGRICULTURA  Y RIEGO"]
[]
[null,"4. UNIDAD FORMULADORA "]
[]
[null,"SECTOR",null,null,"GOBIERNOS LOCALES "]
[]
[null,"PLIEGO",null,null,"MUNICIPALIDAD DISTRITAL DE LOCROJA"]
[]
[null,"NOMBRE",null,null,"UNIDAD FORMULADORA DE DESARROLLO SOCIAL Y ECONÓMICO"]
[]
[null,"Persona Responsable de Formular la Ficha Técnica",null,null,"CARLOS NATIVIDAD TORERO",null,null,"PROFESION:","ING. AGRICOLA "]
[]
[null,"Persona Responsable de la Unidad Formuladora ",null,null,"LUIS LIVORA CANTELLA",null,null,"PROFESION:","ING. AGRÍCOLA"]
[]
[]
[null,"5. UNIDAD EJECUTORA DE INVERSIÓN RECOMENDADA "]
[]
[null,"Pertenece a: (Elegir la Unidad Ejecutora y llenar solo el punto que corresponda)"]
[]
[null,"Gobierno Nacional/Regional",null,null,"Sector",null,null,null,"Unidad Ejecutora"]
[]
[]
[null,"Gobierno Provincial",null,null,"Departamento",null,null,null,"Unidad Ejecutora"]
[]
[]
[null,"Gobierno Distrital",null,null,"Departamento",null,null,null,"Distrito","Unidad Ejecutora"]
[null,null,null,null,"HUANCAVELICA ",null,null,null,"LOCROJA","MUNICIPALIDAD DISTRITAL DE LOCROJA"]
[]
[null,"Persona Responsable de la Unidad Ejecutora",null,null,"ING. JUAN PORTILLA CUETO"]
[]
[null,"Organo Técnico Responsable",null,null,"GERENCIA DE INFRAESTRUCTURA Y OBRAS PÚBLICAS "]
[]
[]
[null,"6. UBICACIÓN  Y ACCESOS"]
[]
[null,"6.1. Ubicación Política"]
[]
[null,"REGIÓN",null,null,"HUANCAVELICA "]
[null,"PROVINCIA",null,null,"CHURCAMPA"]
[null,"DISTRITO",null,null,"LOCROJA"]
[null,"LOCALIDAD ",null,null,"CENTRO POBLADO SAN LUIS"]
[]
[null,"6.2. Ubicación Geográfica"]
[]
[null,"COORDENADAS UTM (m)","(WGS84)",null,"ESTE ",657259,"NORTE ",9406136,"ZONA","18 - M"]
[null,"ALTURA (msnm)",null,null,2542]
[null,"REGIÓN NATURAL",null,null,"Sierra"]
[]
[null,"6.3. Ubicación Hidrografica "]
[]
[null,"Vertiente","Pacifico",null,"Cuenca","Mantaro",null,"Microcuenca","Churcampa"]
[]
[null,"6.4. Vias de acceso al proyecto"]
[]
[null,"Tramo\n(DE) ","Tramo \n(HASTA)","Distancia (km)","Tiempo (Horas)","Tipo de vía","Estado"]
[null,"Lima ","Huancayo",300,7,"Asfaltado","B"]
[null,"Huancayo ","Churcampa",120,5,"Asfaltado - Afirmado","R"]
[null,"Churcampa ","San Luis ",50,1,"Afirmado ","R"]
[null,"San Luis ","Proyecto ",15,0.5,"Trocha carrozable","M"]
[null,"Valores posibles para el Estado: (B) bueno, (R) regular, (M) malo"]
[]
[null,"II.  DEFINICIÓN DEL PROBLEMA Y OBJETIVOS "]
[]
[null,"7. DESCRIPCIÓN DE LA SITUACIÓN ACTUAL"]
[]
[null,"7.1. Administración del Agua con Fines Agrícolas "]
[]
[null,"ORGANIZACIÓN FORMALIZADA POR LA ANA",null,null,"Si (   )  No (   )",null,null,null,null,null,null,null,null,null,null,"EXPLICAR / PROFUNDIZAR - DGIAR"]
[null,"AUTORIDAD ADMINISTRATIVA DEL AGUA (AAA)",null,null,"HUANCAVELICA "]
[null,"AUTORIDAD LOCAL DEL AGUA (ALA)",null,null,"HUANCAVELICA "]
[null,"JUNTA DE USUARIOS ",null,null,"HUANCAVELICA "]
[null,"COMISIÓN DE USUARIOS",null,null,"7 PAGOS"]
[null,"COMITÉ DE USUARIOS ",null,null,"SAN LUIS"]
[null,"OTROS",null,null,null,null,null,null,null,null,null,null,null,null,null,"EXPLICAR / PROFUNDIZAR - DGIAR"]
[]
[null,"7.2 Fuente Hídrica"]
[]
[null,"Fuente","Nombre","Ubicación geográfica UTM WGS84 "]
[null,null,null,"Este","Norte","Zona","Altitud (m.s.n.m)"]
[null,"Rio"]
[null,"Canal ","San Luis ",657278,9406140,"18 - M",2595]
[null,"Manantial (Puquial)"]
[null,"Quebrada"]
[null,"Pozo"]
[null,"Otros: "]
[]
[null,"7.3. Acreditación Hídrica"]
[]
[null,"DOCUMENTO DE ACREDITACIÓN HÍDRICA ",null,null,"LICENCIA ","X",null,"ACREDITACIÓN"]
[null,"DOCUMENTO DE LA ANA QUE SUSTENTA LA ACREDITACIÓN",null,null,"Resolución Administrativa N° 007-2015-ALA-HUANCAVELICA"]
[]
[null,"7.3. Descripción de la Situación Actual"]
[]
[null,"CAUDAL DE LA FUENTE AUTORIZADO",null,null,15,"l/s"]
[null,"VOLUMEN DE LA FUENTE AUTORIZADO",null,null,150000,"m3/año"]
[null,"ÁREA DE RIEGO A BENEFICIAR ",null,null,20,"ha"]
[null,"NÚMERO DE USUARIOS  BENEFICIADOS",null,null,12,"agricultores"]
[null,"MÉTODO DE RIEGO A NIVEL PARCELARIO",null,null,"GRAVEDAD","X","PRESURIZADO",null,"TIPO","SURCO"]
[null,"EFICIENCIA DE APLICACIÓN SIN PROYECTO (%)",null,null,0.3,null,"EXPLICAR / PROFUNDIZAR - DGIAR"]
[]
[null,"7.3. Características de la Producción Agrícola - Situación Actual"]
[]
[null,"CÉDULA DE CULTIVO ACTUAL ",null,null,"PASTOS","ALFALFA"]
[null,"RENDIMIENTO DEL CULTIVO Kg/ha  ",null,null,15000,15000]
[null,"PRECIO EN CHACRA (Soles/Kg)",null,null,0.2,0.2]
[null,"COSTO DE PRODUCCION (Soles/ha)",null,null,1800,2000]
[null,"DESTINO DE LA PRODUCCIÓN",null,null,"AUTOCONSUMO",0.3,"MDO. LOCAL / REGIONAL",0.7,"MDO. EXPORTACION"]
[]
[null,"7.5 Aspectos Sociales*"]
[]
[null,"¿Existen conflictos por la distribución del agua?",null,null,null,"SI (    )                       NO (    )"]
[null,"¿Pertenece a una zona de mesa de dialogo?",null,null,null,"SI (    )                       NO (    )",null,"EXPLICAR / PROFUNDIZAR - DGIAR"]
[null,"¿Existen conflictos por los accesos?",null,null,null,"SI (    )                       NO (    )"]
[null,"¿Existen personas que estan en desacuerdo con el proyecto?",null,null,null,"SI (    )                       NO (    )"]
[]
[null,"* Fuente: Talleres, asambleas participativos desarrollados en el ambito del Proyecto"]
[]
[null,"8. PROBLEMA CENTRAL Y SUS CAUSAS"]
[]
[null,"Descripción del Problema Central"]
[null,"Baja productividad agrícola en el ámbito de la JU Huancavelica – Sector San Luis – Distrito de Locroja – Churcampa – Huancavelica "]
[]
[null,"Nº","Descripción de las Principales Causas",null,null,"Causas Indirectas"]
[null,"Causa 1","Ineficiencias en el uso del recurso hídrico ",null,null,"   i. Uso deficiente de técnicas de riego por gravedad (inundación, surco, etc.)\n   ii. Poco conocimiento de técnicas de riego  de mayor eficiencia"]
[null,"Causa 2","Inadecuada disponibilidad del recurso hídrico ",null,null,"   i. Insuficiente infraestructura hidráulica\n   ii. Inadecuada conservación de la infraestructura hidráulica\n   iii. Poca capacidad de gestión del recurso hídrico entre usuarios "]
[]
[null,"9. OBJETIVO Y MEDIOS FUNDAMENTALES"]
[]
[null,"9.1. Objetivo"]
[]
[null,"Descripción del Objetivo Central"]
[null,"Incremento de la productividad agrícola en el ámbito de la JU Huancavelica – Sector San Luis – Distrito de Locroja – Churcampa – Huancavelica "]
[]
[null,"9.2. Medios Fundamentales"]
[]
[null,"N°","Descripción Medios Fundamentales"]
[null,1,"Utilización de técnicas de riego presurizado"]
[null,2,"Mayor conocimiento de técnicas de riego más eficientes"]
[]
[null,"10. DESCRIPCIÓN DE LA ALTERNATIVA DE SOLUCIÓN AL PROBLEMA"]
[]
[null,"10.1. Alternativa de Solución Propuesta"]
[]
[null,"MÉTODO DE RIEGO A NIVEL PARCELARIO",null,null,"TECNIFICADO A GRAVEDAD",null,"PRESURIZADO","X","TIPO","ASPERSIÓN - FIJO"]
[null,"EFICIENCIA DE APLICACIÓN SIN PROYECTO (%)",null,null,0.75]
[]
[null,"10.2. Descripción de la Alternativa de Solución Propuesta"]
[]
[null,"Descripción  de la Propuesta",null,"Componentes (Resultados necesarios para lograr el Objetivo)",null,null,"Acciones Necesarias para lograr cada Resultado"]
[null,"PLANTEAMIENTO\nSe captará el agua del canal Rumichaca (progresiva 0+390), con un caudal de 15 l/s. A partir de este punto se conducirá el agua mediante una tubería de PVC hasta un desarenador. De la estructura de sedimentación se almacenará el agua en un reservorio revestido de geomembrana PVC 1.0 mm. Desde este punto se irrigarán un total de 20 ha mediante el sistema de riego por aspersión.",null,"COMPONENTE 01:\nInstalación de un sistema de riego por aspersión utilizando agua superficial.",null,null,"Mejoramiento de la toma lateral en el canal y desarenador en concreto armado"]
[null,null,null,null,null,null,"Construcción de un reservorio revestido de geomembrana de PVC de 1.0 mm, de 1,500 m3 de capacidad neta, más obras complementarias"]
[null,null,null,null,null,null,"Construcción del sistema entubado de conducción y distribución de PVC"]
[null,null,null,null,null,null,"Instalación de un sistema de riego parcelario por aspersión fijo para 20 ha"]
[null,null,null,"COMPONENTE 02:\nCapacitación en operación y mantenimiento de sistemas de riego tecnificado.",null,null,"Módulos de capacitación en operación y mantenimiento de sistemas de riego tecnificado "]
[]
[]
[null,null,null,"COMPONENTE 03:\nAsistencia tecnica en prácticas agrícolas en parcelas con sistemas de riego tecnificado.",null,null,"Módulos de capacitación en prácticas agrícolas en parcelas con sistemas de riego tecnificado"]
[]
[]
[]
[null,"10.3. Características de la Producción Agrícola - Situación Con Proyecto"]
[]
[null,"CÉDULA DE CULTIVO ACTUAL ",null,null,"PASTOS","ALFALFA"]
[null,"RENDIMIENTO DEL CULTIVO Kg/ha  ",null,null,20000,25000]
[null,"PRECIO EN CHACRA (Soles/Kg)",null,null,0.2,0.2]
[null,"COSTO DE PRODUCCION (Soles/ha)",null,null,2000,2200]
[null,"DESTINO DE LA PRODUCCIÓN",null,null,"AUTOCONSUMO",0.2,"MDO. LOCAL / REGIONAL",0.8,"MDO. EXPORTACION"]
[]
[null,"III.  CUANTIFICACIÓN DE SU CONTRIBUCIÓN AL CIERRE DE BRECHAS"]
[]
[null,"11. CONTRIBUCIÓN AL CIERRE DE BRECHAS"]
[]
[null,"Brecha",null,null,"Unida de Medida",null,"Brecha Nacional",null,"Contribución al Cierre de Brecha "]
[null,"Área Bajo Riego Sin Riego Tecnificado",null,null,"ha",null,1590546,null,20]
[]
[]
[null,"IV.  FORMULACION Y EVALUACION"]
[]
[null,"12. HORIZONTE DE EVALUACIÓN (*)"]
[null,"Número de Años del Horizonte de Evaluación",null,null,"10 AÑOS"]
[]
[null,"Sustento Técnico del Horizonte de Evaluación Elegido"]
[null,"El horizonte de evaluación del proyecto está asociado al tiempo de vida útil de los materiales e insumos que se utilizarán en la infraestructura."]
[]
[]
[]
[null,"13. ANÁLISIS DE LA DEMANDA (*)"]
[]
[null,"Nivel de Servicio",null,"Unidad de Medida","ENE","FEB","MAR","ABR","MAY","JUN"]
[null,"Demanda Hídrica Con Proyecto",null,"m3",{"$f":"+Demanda!F56","v":9510.7999999999993},{"$f":"+Demanda!G56","v":860.80000000000109},{"$f":"+Demanda!H56","v":3037.3333333333335},{"$f":"+Demanda!I56","v":10636.999999999998},{"$f":"+Demanda!J56","v":16354.8},{"$f":"+Demanda!K56","v":15784.999999999998},{"$f":"+[1]Hoja1!L150","v":{"$error":"#REF!"}},{"$f":"+[1]Hoja1!M150","v":{"$error":"#REF!"}},{"$f":"+[1]Hoja1!N150","v":{"$error":"#REF!"}},{"$f":"+[1]Hoja1!O150","v":{"$error":"#REF!"}},{"$f":"+[1]Hoja1!P150","v":{"$error":"#REF!"}}]
[]
[null,null,null,"Unidad de Medida","JUL","AGO","SEP","OCT","NOV","DIC"]
[null,null,null,"m3",{"$f":"+Demanda!L56","v":17718.666666666668},{"$f":"+Demanda!M56","v":20378.226666666666},{"$f":"+Demanda!N56","v":15615},{"$f":"+Demanda!O56","v":6621.333333333333},{"$f":"+Demanda!P56","v":14442},{"$f":"+Demanda!Q56","v":5785.9999999999991}]
[]
[null,"Enunciar los principales parámetros y supuestos considerados para la proyección de la demanda"]
[null,"Para el cálculo de la demanda hídrica se han considerado los datos de: evapotranspiración potencial, el Kc de los cultivos propuestos, la precipitación efectiva, la eficiencia de aplicación, el área del proyecto.\nComo supuesto se asume que la cédula de cultivo y el área bajo riego es constante en el tiempo, y se mantienen las condiciones meteorológicas de la zona de estudio."]
[]
[]
[]
[null,"14. ANÁLISIS DE LA OFERTA (*)"]
[]
[null,"Nivel de Servicio",null,"Unidad de Medida","ENE","FEB","MAR","ABR","MAY","JUN",null,"Año 8","Año 9","Año 10","mensual "]
[null,"Oferta Hídrica Con Proyecto",null,"m3",{"$f":"+Oferta!G15","v":38880},{"$f":"+Oferta!H15","v":38880},{"$f":"+Oferta!I15","v":38880},{"$f":"+Oferta!J15","v":25920},{"$f":"+Oferta!K15","v":25920},{"$f":"+Oferta!L15","v":25920},{"$f":"+[1]Hoja2!M116","v":{"$error":"#REF!"}},{"$f":"+[1]Hoja2!N116","v":{"$error":"#REF!"}},{"$f":"+[1]Hoja2!O116","v":{"$error":"#REF!"}},{"$f":"+[1]Hoja2!P116","v":{"$error":"#REF!"}},{"$f":"+[1]Hoja2!Q116","v":{"$error":"#REF!"}}]
[]
[null,null,null,"Unidad de Medida","JUL","AGO","SEP","OCT","NOV","DIC"]
[null,null,null,"m3",{"$f":"+Oferta!M15","v":25920},{"$f":"+Oferta!N15","v":25920},{"$f":"+Oferta!O15","v":25920},{"$f":"+Oferta!P15","v":25920},{"$f":"+Oferta!Q15","v":38880},{"$f":"+Oferta!R15","v":38880}]
[]
[null,"Describir los factores de producción que determinan la oferta actual del servicio. Enunciar los principales parámetros y supuestos considerados para la proyección de la oferta."]
[]
[null,"Para el cálculo de la oferta hídrica se han considerado los datos de: caudal ofertado por la fuente hídrica (autorizada por la ANA - acreditacion o licencia), el tiempo de riego, la frecuencia de riego, el área del proyecto.\nComo supuesto se asume que el área bajo riego es constante en el tiempo, y se mantienen los regímenes de oferta hídrica por parte de la organización de usuarios de agua."]
[]
[]
[]
[null,"15. BALANCE OFERTA - DEMANDA "]
[]
[null,"Nivel de Servicio",null,"Unidad de Medida","ENE","FEB","MAR","ABR","MAY","JUN",null,"Año 8","Año 9","Año 10","mensual"]
[null,"Balance Hídrico Con Proyecto",null,"m3",{"$f":"+E220-E207","v":29369.200000000001},38019.199999999997,35842.666666666664,15283.000000000002,9565.2000000000007,10135.000000000002,null,{"$f":"+L220-L207","v":{"$error":"#REF!"}},{"$f":"+M220-M207","v":{"$error":"#REF!"}},{"$f":"+N220-N207","v":{"$error":"#REF!"}}]
[]
[null,null,null,"Unidad de Medida","JUL","AGO","SEP","OCT","NOV","DIC"]
[null,null,null,"m3",{"$f":"+E223-E210","v":8201.3333333333321},5541.7733333333344,10305,19298.666666666668,24438,33094]
[]
[null,"16. COSTOS DEL PROYECTO"]
[]
[null,"16.1 Modalidad de Ejecución"]
[]
[null,"Nº","TIPO DE EJECUCIÓN",null,null,null,null,"SELECCIONADO"]
[null,1,"ADMINISTRACIÓN DIRECTA"]
[null,2,"ADMINISTRACIÓN INDIRECTA – POR CONTRATA"]
[null,3,"ADMINISTRACIÓN INDIRECTA – ASOCIACIÓN PÚBLICA PRIVADO (APP)"]
[null,4,"ADMINISTRACIÓN INDIRECTA - LEY N° 28585 PRT",null,null,null,null,"X"]
[null,5,"ADMINISTRACIÓN INDIRECTA – NÚCLEO EJECUTOR "]
[null,6,"ADMINISTRACIÓN INDIRECTA – ley 29230 (OBRAS POR IMPUESTOS)"]
[]
[null,"16.2 Costos de Inversión de la Alternativa Seleccionada (a precios de mercado en Soles)"]
[]
[null,"Principales Rubros",null,null,"Unidad de Medida","Cantidad","Costo Unitario","Costo Parcial","Obras Comunes ","Obras Parcelarias"]
[null,"Expediente Técnico",null,null,"Estudio",1,{"$f":"+E113*1000","v":20000},{"$f":"+G254*F254","v":20000},{"$f":"+H254","v":20000}]
[null,"Costo Directo",null,null,null,null,null,{"$f":"+H256+H257+H258","v":444000}]
[null,"Componente 01 RIEGO TECNIFICADO",null,null,"Obra",1,{"$f":"+E113*20000","v":400000},{"$f":"+G256*F256","v":400000},{"$f":"+H256*0.7","v":280000},{"$f":"+H256*0.3","v":120000}]
[null,"Componente 02 CAPACITACION",null,null,"Global",1,{"$f":"+E113*1000","v":20000},{"$f":"+G257*F257","v":20000},{"$f":"+H257","v":20000}]
[null,"Componente 03 ASISTENCIA TECNICA",null,null,"Global",1,{"$f":"+E114*2000","v":24000},{"$f":"+G258*F258","v":24000},{"$f":"+H258","v":24000}]
[null,"Costo Indirecto",null,null,null,null,null,{"$f":"+H260+H261+H262+H263","v":117000}]
[null,"Gastos Generales",null,null,"Global",1,{"$f":"+G256*0.08","v":32000},{"$f":"+G260","v":32000},{"$f":"+H260","v":32000}]
[null,"Gatos de Gestión (IGA - CIRA - PMA - Otros)",null,null,"Global",1,20000,{"$f":"+G261","v":20000},20000]
[null,"Utilidad",null,null,"Global",1,{"$f":"+G256*0.12","v":48000},48000,48000]
[null,"Supervisión",null,null,"Global",1,{"$f":"+E113*850","v":17000},17000,{"$f":"+H263*0.7","v":11900},{"$f":"+H263*0.3","v":5100}]
[null,"Sub Total (ET + CD + CI)",null,null,null,null,null,{"$f":"+H254+H255+H259","v":581000}]
[null,"IGV",null,null,"Global",null,null,{"$f":"0.18*H264","v":104580},{"$f":"+H265","v":104580}]
[null,"Costo Total del Proyecto",null,null,null,null,null,{"$f":"+H264+H265","v":685580},{"$f":"SUM(I254:I265)","v":560480},{"$f":"SUM(J254:J265)","v":125100},0,0,0,0,0]
[]
[]
[null,"COSTO DE INVERSION POR HECTÁREA BENEFICIADA (Soles/ha)",null,null,{"$f":"+H266/E113","v":34279}]
[null,"APORTE REFERENCIAL DE LOS BENEFICIARIOS (S/.)",null,null,{"$f":"+J266*0.2","v":25020}]
[null,"COSTOS DE REPOSICIÓN (Soles)",null,null,{"$f":"+H256*0.05","v":20000}]
[null,"AÑO DE APLIACIÓN DEL COSTO DE REPOSICIÓN",null,null,5]
[]
[null,"16.3 Costos de Operación y Mantenimiento Sin Proyecto"]
[null,"16.3.1  COSTOS DE OPERACIÓN"]
[null,"Items de gasto",null,"Año 1","Año 2","Año 3","Año (…)","Año 8","Año 9","Año 10",null,"Año 8","Año 9","Año 10"]
[null,"Personal (*)",null,10830,{"$f":"+D277","v":10830},10830,10830,10830,10830,10830,null,{"$f":"+J277","v":10830},{"$f":"+L277","v":10830},{"$f":"+M277","v":10830}]
[null,"Equipos (*)"]
[null,"Insumos (*)"]
[null,"Servicios (*)"]
[null,"Combustibles (*)"]
[null,"Otros(*)",null,570,{"$f":"+D282","v":570},570,570,570,570,570,null,{"$f":"+J282","v":570},{"$f":"+L282","v":570},{"$f":"+M282","v":570}]
[null,"Total a precios de mercado",null,11400,{"$f":"+E277+E282","v":11400},11400,11400,11400,11400,11400,null,{"$f":"+L277+L282","v":11400},{"$f":"+M277+M282","v":11400},{"$f":"+N277+N282","v":11400}]
[null,"Total a precios sociales (*)",null,{"$f":"+D277*#REF!+D282*#REF!","v":{"$error":"#REF!"}},{"$f":"+D284","v":{"$error":"#REF!"}},null,null,{"$f":"+E284","v":{"$error":"#REF!"}},{"$f":"+#REF!","v":{"$error":"#REF!"}},{"$f":"+I284","v":{"$error":"#REF!"}},{"$f":"+#REF!","v":{"$error":"#REF!"}},{"$f":"+K284","v":{"$error":"#REF!"}},{"$f":"+L284","v":{"$error":"#REF!"}}]
[]
[null,"16.3.2  COSTOS DE MANTENIMIENTO"]
[null,"Items de gasto",null,"Año 1","Año 2","Año 3","Año (…)","Año 8","Año 9","Año 10"]
[null,"Personal (*)",null,10830,{"$f":"+D288","v":10830},10830,10830,10830,10830,10830]
[null,"Equipos (*)"]
[null,"Insumos (*)"]
[null,"Servicios (*)"]
[null,"Combustibles (*)"]
[null,"Otros(*)",null,570,{"$f":"+D293","v":570},570,570,570,570,570]
[null,"Total a precios de mercado",null,11400,{"$f":"+E288+E293","v":11400},11400,11400,11400,11400,11400]
[]
[]
[null,"16.4 Costos de Operación y Mantenimiento Con Proyecto"]
[null,"16.4.1  COSTOS DE OPERACIÓN"]
[null,"Items de gasto",null,"Año 1","Año 2","Año 3","Año (…)","Año 8","Año 9","Año 10",null,"Año 8","Año 9","Año 10"]
[null,"Personal (*)",null,30260,{"$f":"+D300","v":30260},30260,30260,30260,30260,30260,null,{"$f":"+J300","v":30260},{"$f":"+L300","v":30260},{"$f":"+M300","v":30260}]
[null,"Equipos (*)"]
[null,"Insumos (*)",null,3560,{"$f":"+D302","v":3560},3560,3560,3560,3560,3560,null,{"$f":"+J302","v":3560},{"$f":"+L302","v":3560},{"$f":"+M302","v":3560}]
[null,"Servicios (*)"]
[null,"Combustibles (*)"]
[null,"Otros(*)",null,1780,{"$f":"+D305","v":1780},1780,1780,1780,1780,1780,null,{"$f":"+J305","v":1780},{"$f":"+L305","v":1780},{"$f":"+M305","v":1780}]
[null,"Total a precios de mercado",null,35600,35600,35600,35600,35600,35600,35600,null,{"$f":"+J306","v":35600},{"$f":"+L306","v":35600},{"$f":"+M306","v":35600}]
[null,"Total a precios sociales (*)",null,{"$f":"+D300*#REF!+D302*#REF!+D305*#REF!","v":{"$error":"#REF!"}},{"$f":"+D307","v":{"$error":"#REF!"}},null,null,{"$f":"+E307","v":{"$error":"#REF!"}},{"$f":"+#REF!","v":{"$error":"#REF!"}},{"$f":"+I307","v":{"$error":"#REF!"}},{"$f":"+#REF!","v":{"$error":"#REF!"}},{"$f":"+K307","v":{"$error":"#REF!"}},{"$f":"+L307","v":{"$error":"#REF!"}}]
[]
[null,"16.4.2  COSTOS DE MANTENIMIENTO"]
[null,"Items de gasto",null,"Año 1","Año 2","Año 3","Año (…)","Año 8","Año 9","Año 10"]
[null,"Personal (*)",null,10830,{"$f":"+D311","v":10830},10830,10830,10830,10830,10830]
[null,"Equipos (*)"]
[null,"Insumos (*)"]
[null,"Servicios (*)"]
[null,"Combustibles (*)"]
[null,"Otros(*)",null,570,{"$f":"+D316","v":570},570,570,570,570,570]
[null,"Total a precios de mercado",null,11400,{"$f":"+E311+E316","v":11400},11400,11400,11400,11400,11400]
[]
[]
[null,"16.5 Comparación de Costos entre la Situación Sin y Con Proyecto (en Soles)"]
[]
[null,"Descripción",null,null,"Costo de Inversión","VP. Costo O&M","VP. Costo Total"]
[null,"Situación sin Proyecto",null,null,0,66284.812176285195,{"$f":"+F323+E323","v":66284.812176285195}]
[null,"Alternativa de Solución",null,null,{"$f":"+H266","v":685580},205586.54956883853,{"$f":"+F324+E324","v":891166.54956883856}]
[null,"Costos Incrementales",null,null,{"$f":"+E324-E323","v":685580},{"$f":"+F324-F323","v":139301.73739255333},{"$f":"G324-G323","v":824881.73739255336}]
[]
[null,"17. BENEFICIOS"]
[]
[null,"17.1 Beneficios (Cuantitativo) - En Soles"]
[]
[null,"Beneficios",null,"Año 1","Año 2","Año 3","Año (…)","Año 8","Año 9","Año 10",null,"Año 9","Año 10"]
[null,"Incremento en el Valor Neto de la Producción",null,166050,{"$f":"+D332","v":166050},166050,166050,166050,166050,166050,null,{"$f":"+I332","v":166050},{"$f":"+L332","v":166050}]
[]
[null,"TASA DE DESCUESTO (%)",null,null,0.09]
[null,"VALOR PRESENTE DE LOS BENEFICIOS (Soles)",null,null,{"$f":"NPV(0.09,D332:M332)","v":995510.746792424}]
[]
[]
[null,"Enunciar los principales parámetros y supuestos para la estimación de los beneficios "]
[null,"Para el cálculo de los beneficios se ha estimado el Valor Neto de la Producción, que resulta de la diferencia entre el Valor Bruto de la Producción y los Costos Totales de la Producción.  El Valor Bruto de la Producción se calcula en base al área del proyecto, el precio y el rendimiento de los cultivos. El supuesto principal es que la totalidad de la producción es comercializada."]
[]
[]
[]
[null,"17.2 Beneficios (Cualitativo)"]
[null,"Gracias al incremento de la productividad de los cultivos los usuarios de agua beneficiados elevan sus ingresos económicos, con lo que pueden mejorar sus condiciones de vida, y por ende el bienestar familiar."]
[]
[]
[]
[null,"18.EVALUACIÓN "]
[]
[null,"18.1 Costo-Beneficio"]
[]
[null,"VAN (Soles)",null,null,{"$f":"+E335-G325","v":170629.00939987064}]
[null,"TIR",null,null,0.123]
[]
[null,"19. CRONOGRAMA DE EJECUCIÓN"]
[]
[null,"19.1 Cronograma de Ejecución Física  (% de avance)"]
[]
[null,"Principales Rubros",null,"mes 1-2","mes 3-4","mes 5-6","mes 7-8","mes 9-10","mes 11-12","TOTAL"]
[null,"Expediente Técnico",null,1,null,null,null,null,null,{"$f":"SUM(D360:I360)","v":1}]
[null,"Componente 1 RIEGO TECNIFICADO",null,null,0.1,0.5,0.4,null,null,{"$f":"SUM(D361:I361)","v":1}]
[null,"Componente 2 CAPACITACION",null,null,null,null,1,null,null,{"$f":"SUM(D362:I362)","v":1}]
[null,"Componente 3 ASISTENCIA TECNICA",null,null,null,null,0.3,0.3,0.4,{"$f":"SUM(D363:I363)","v":1}]
[]
[null,"19.2 Cronograma de Ejecución Financiera (% de avance)"]
[]
[null,"Principales Rubros",null,"mes 1-2","mes 3-4","mes 5-6","mes 7-8","mes 9-10","mes 11-12","TOTAL"]
[null,"Expediente Técnico",null,1,null,null,null,null,null,{"$f":"SUM(D368:I368)","v":1}]
[null,"Componente 1 RIEGO TECNIFICADO",null,null,0.6,0.3,0.1,null,null,{"$f":"SUM(D369:I369)","v":0.99999999999999989}]
[null,"Componente 2 CAPACITACION",null,null,null,null,1,null,null,{"$f":"SUM(D370:I370)","v":1}]
[null,"Componente 3 ASISTENCIA TECNICA",null,null,null,null,0.2,0.4,0.4,{"$f":"SUM(D371:I371)","v":1}]
[]
[null,"V.  REQUISITOS INSTITUCIONALES Y/O NORMATIVOS"]
[]
[null,"20. SOSTENIBILIDAD"]
[]
[null,"20.1  Responsable de la Operación y Mantenimiento del PIP"]
[null,"El responsable de la operación y mantenimiento del sistema de riego estará a cargo de la organización de usuarios beneficiarios del sector San Luis, velando por el adecuado funcionamiento de los equipos de riego"]
[]
[null,"Documentos que sustentan los acuerdos institucionales u otros que garantizan el financiamiento de los gastos de operación y mantenimiento"]
[null,"Documento","Entidad / Organización",null,null,"Compromiso"]
[null,"Acta de Compromisos","Grupo beneficiario",null,null,"Operar y mantener de forma adecuada el sistema de riego tecnificado, acorde con las recomendaciones impartidas durante el proceso de capacitación."]
[]
[null,"21. RIESGOS"]
[null,"21.1  ¿El área donde se ubica el proyecto ha sido afectada por algún desastre natural?"]
[]
[]
[null,null,"No","X"]
[]
[null,null,"Si"]
[]
[null,null,"Medidas consideradas en el proyecto para mitigar el desastre"]
[null,null,"Acción 1"]
[]
[null,null,"Acción 2"]
[]
[null,null,"Acción \"n\""]
[]
[]
[null,"22. IMPACTO AMBIENTAL"]
[]
[null,null,"IMPACTOS NEGATIVOS",null,"MEDIDAS DE MITIGACIÓN",null,null,"COSTO (S/.)"]
[null,null,"Durante la Ejecución"]
[null,null,"Impacto 1:\nAcumulación de residuos sólidos de construcción y otros ",null,"Eliminación en depósitos de materiales excedentes",null,null,5250]
[null,null,"Impacto 2:"]
[null,null,"Impacto n:"]
[null,null,"Durante la Operación"]
[null,null,"Impacto 1:"]
[null,null,"Impacto n:"]
[]
[null,"23. Documentos para la viabilidad"]
[null,"Adjunta la constancia de disponibilidad hídrica emitida por la ANA."]
[null,"Adjuntan documentos de acreditación de propiedad del terreno de los beneficiarios."]
[null,"Adjunta la acreditración como usuario de agua emitida por la Organización de Usuarios de Agua."]
[null,"Adjunta acta de compromiso de aporte de contrapartida económica de los beneficiarios."]
[null,"Adjunta acta de libre disponibilidad de terreno."]
[null,"Adjunta constancia de rol de distribución de agua emitido por la OUA."]
[]
[null,"24. ANEXOS"]
[]
[null,"Croquis de Ubicación"]
[null,"Balance Hídrico"]
[null,"Flujo de Caja"]
[null,"Presupuesto"]
[null,"Panel Fotográfico"]
[]
[null,"25.  FECHA DE  FORMULACIÓN"]
[null,null,null,null,"2017-03-23"]
[]
[null,"26. FIRMAS"]
[]
[]
[]
[]
[]
[null,null,"Responsable de la Formulación del Perfil",null,null,null,"Responsable de la Unidad Formuladora"]

{"sheet":"Kc","index":1,"n_rows":79,"n_cols":15,"rows_kept":79,"cut":false,"hidden":true,"merged":[[5,2,6,2],[5,3,5,14],[16,2,17,2],[16,3,16,14],[71,2,72,2],[71,3,71,14],[33,2,34,2],[33,3,33,14],[45,2,46,2],[45,3,45,14],[59,2,60,2],[59,3,59,14]]}
[]
[null,null,"DETERMINACIÓN DEL Kc PONDERADO - SIN PROYECTO"]
[]
[null,null,"CÉDULA DE CULTIVO "]
[]
[null,null,"CULTIVOS ","ÁREA  (ha)"]
[null,null,null,"ENE","FEB","MAR","ABR","MAY","JUN","JUL","AGO","SEP","OCT","NOV","DIC"]
[null,null,"Maiz Amarillo Duro",null,null,null,5,5,5,5,5]
[null,null,"Papa",5,5,null,null,null,null,null,null,null,5,5,5]
[null,null,"Alfalfa",15,15,15,15,15,15,15,15,15,15,15,15]
[]
[null,null,"SUBTOTAL",{"$f":"SUM(D8:D11)","v":20},{"$f":"SUM(E8:E11)","v":20},15,20,20,20,20,20,15,20,20,20]
[]
[]
[null,null,"DETERMINACIÓN DEL Kc PONDERADO "]
[]
[null,null,"CULTIVOS ","Kc"]
[null,null,null,"ENE","FEB","MAR","ABR","MAY","JUN","JUL","AGO","SEP","OCT","NOV","DIC"]
[null,null,{"$f":"+C8","v":"Maiz Amarillo Duro"},null,null,null,0.5,0.5,1.1499999999999999,1.1499999999999999,0.75]
[null,null,{"$f":"+C9","v":"Papa"},1.1000000000000001,0.8,null,null,null,null,null,null,null,0.4,0.75,1.1499999999999999]
[null,null,{"$f":"+C10","v":"Alfalfa"},1,1,1,1,1,1,1,1,1,1,1,1]
[]
[null,null,"Kc PONDERADO",{"$f":"+(D8*D19+D9*D20+D10*D21+D11*D22)/D12","v":1.0249999999999999},{"$f":"+(E8*E19+E9*E20+E10*E21+E11*E22)/E12","v":0.95},{"$f":"+(F8*F19+F9*F20+F10*F21+F11*F22)/F12","v":1},0.875,0.875,1.0375000000000001,1.0375000000000001,0.9375,1,0.85,0.9375,1.0375000000000001]
[]
[]
[]
[]
[null,null,"DETERMINACIÓN DEL Kc PONDERADO - CON PROYECTO"]
[]
[null,null,"ASPERSIÓN"]
[]
[null,null,"CÉDULA DE CULTIVO "]
[]
[null,null,"CULTIVOS ","ÁREA  (ha)"]
[null,null,null,"ENE","FEB","MAR","ABR","MAY","JUN","JUL","AGO","SEP","OCT","NOV","DIC"]
[null,null,"Quinua",null,null,null,5,5,5,5,5,5]
[null,null,"Arverja",5,5,null,null,null,null,null,null,null,null,5,5]
[null,null,"Alfalfa",10,10,10,10,10,10,10,10,10,10,10,10]
[]
[]
[null,null,"SUBTOTAL",{"$f":"SUM(D36:D40)","v":15},{"$f":"SUM(E36:E40)","v":15},10,15,15,15,15,15,15,10,15,15]
[]
[]
[null,null,"DETERMINACIÓN DEL Kc PONDERADO "]
[]
[null,null,"CULTIVOS ","Kc"]
[null,null,null,"ENE","FEB","MAR","ABR","MAY","JUN","JUL","AGO","SEP","OCT","NOV","DIC"]
[null,null,{"$f":"+C36","v":"Quinua"},null,null,null,0.65,0.7,0.75,0.8,0.83,0.75]
[null,null,{"$f":"+C37","v":"Arverja"},1.05,0.7,null,null,null,null,null,null,null,null,0.7,1]
[null,null,{"$f":"+C38","v":"Alfalfa"},1,1,1,1,1,1,1,1,1,1,1,1]
[]
[]
[null,null,"Kc PONDERADO",{"$f":"+(D36*D48+D37*D49+D38*D50+D39*D51+D40*D52)/D41","v":1.0166666666666666},{"$f":"+(E36*E48+E37*E49+E38*E50+E39*E51+E40*E52)/E41","v":0.9},{"$f":"+(F36*F48+F37*F49+F38*F50+F39*F51+F40*F52)/F41","v":1},0.8833333333333333,0.9,0.91666666666666663,0.93333333333333335,0.94333333333333325,0.91666666666666663,1,0.9,1]
[]
[]
[null,null,"GOTEO"]
[]
[null,null,"CÉDULA DE CULTIVO "]
[]
[null,null,"CULTIVOS ","ÁREA  (ha)"]
[null,null,null,"ENE","FEB","MAR","ABR","MAY","JUN","JUL","AGO","SEP","OCT","NOV","DIC"]
[null,null,"Palto",5,5,5,5,5,5,5,5,5,5,5,5]
[]
[]
[]
[]
[null,null,"SUBTOTAL",{"$f":"SUM(D62:D66)","v":5},{"$f":"SUM(E62:E66)","v":5},5,5,5,5,5,5,5,5,5,5]
[]
[]
[null,null,"DETERMINACIÓN DEL Kc PONDERADO "]
[]
[null,null,"CULTIVOS ","Kc"]
[null,null,null,"ENE","FEB","MAR","ABR","MAY","JUN","JUL","AGO","SEP","OCT","NOV","DIC"]
[null,null,{"$f":"+C62","v":"Palto"},0.65,0.6,0.6,0.65,0.65,0.7,0.75,0.75,0.83,0.8,0.75,0.7]
[]
[]
[]
[]
[null,null,"Kc PONDERADO",{"$f":"+(D62*D74+D63*D75+D64*D76+D65*D77+D66*D78)/D67","v":0.65},{"$f":"+(E62*E74+E63*E75+E64*E76+E65*E77+E66*E78)/E67","v":0.6},{"$f":"+(F62*F74+F63*F75+F64*F76+F65*F77+F66*F78)/F67","v":0.6},0.65,0.65,0.7,0.75,0.75,0.82999999999999985,0.8,0.75,0.7]

{"sheet":"Ficha Automática","index":2,"n_rows":449,"n_cols":16,"rows_kept":449,"cut":false,"hidden":true,"merged":[[1,1,1,9],[2,1,2,9],[109,2,109,4],[109,5,109,9],[115,1,115,9],[96,1,96,3],[96,7,96,9],[102,1,102,9],[103,1,103,9],[107,2,107,4],[47,4,47,9],[52,4,52,9],[53,4,53,9],[57,2,57,3],[57,5,57,6],[57,8,57,9],[75,4,75,9],[18,4,18,9],[20,4,20,9],[29,4,29,9],[31,4,31,9],[33,4,33,9],[44,4,44,9],[37,4,37,9],[445,2,447,4],[445,6,447,8],[420,2,420,4],[420,5,420,9],[424,1,424,8],[448,2,448,4],[448,6,448,8],[428,1,428,8],[429,1,429,8],[432,3,432,8],[436,1,436,8],[437,1,437,8],[433,1,433,8],[434,1,434,8],[435,1,435,8],[425,1,425,8],[426,1,426,8],[427,1,427,8],[415,1,415,4],[416,1,416,9],[418,1,418,7],[419,2,419,4],[419,5,419,9],[133,15,133,17],[413,1,413,9],[283,2,283,6],[293,2,293,3],[293,4,293,6],[294,2,294,3],[294,4,294,6],[295,2,295,3],[295,4,295,6],[296,2,296,3],[296,4,296,6],[297,2,297,3],[297,4,297,6],[298,2,298,3],[298,4,298,6],[299,2,299,3],[299,4,299,6],[409,1,409,3],[405,1,405,3],[406,1,406,3],[407,1,407,3],[408,1,408,3],[201,1,201,3],[198,1,198,3],[198,8,198,9],[203,1,203,3],[203,4,203,5],[204,1,204,3],[202,1,202,3],[399,1,399,3],[400,1,400,3],[401,1,401,3],[300,2,300,3],[300,4,300,6],[170,1,170,4],[176,1,176,3],[178,1,178,3],[199,1,199,3],[199,4,199,5],[221,1,221,6],[177,1,177,3],[176,4,176,5],[193,1,193,6],[154,1,154,3],[154,8,154,9],[155,1,155,3],[175,1,175,3],[200,1,200,3],[85,1,86,1],[85,2,86,2],[85,3,85,6],[149,5,149,6],[149,8,149,9],[156,1,156,3],[175,8,175,9],[107,5,107,9],[130,4,130,5],[130,6,130,7],[130,8,130,9],[129,1,129,3],[129,4,129,5],[129,6,129,7],[129,8,129,9],[122,2,122,9],[116,1,116,9],[120,2,120,9],[121,2,121,9],[150,4,150,9],[76,4,76,9],[77,4,77,9],[78,4,78,9],[79,4,79,9],[80,4,80,9],[83,4,83,9],[108,2,108,4],[108,5,108,9],[45,4,45,9],[46,4,46,9],[11,1,11,3],[11,4,11,9],[16,4,16,9],[8,1,8,3],[8,4,8,9],[9,1,9,3],[9,4,9,9],[10,1,10,3],[10,4,10,9]]}
[]
[null,"FICHA TÉCNICA - MEJORAMIENTO DE SISTEMA DE RIEGO SIMPLIFICADO - RIEGO TECNIFICADO"]
[null,"(La información registrada en esta ficha tiene carácter de Declaración Jurada)  "]
[]
[null,"I.  ASPECTOS GENERALES"]
[]
[null,"1. RESPONSABILIDAD FUNCIONAL "]
[]
[null,"FUNCIÓN",null,null,"AGROPECUARIA "]
[null,"DIVISIÓN FUNCIONAL",null,null,"RIEGO "]
[null,"GRUPO FUNCIONAL",null,null,"RIEGO TECNIFICADO"]
[null,"RESPONSABLE FUNCIONAL",null,null,"AGRICULTURA  Y RIEGO"]
[]
[]
[null,"2. UNIDAD FORMULADORA "]
[]
[null,"SECTOR",null,null,"GOBIERNOS LOCALES "]
[]
[null,"PLIEGO",null,null,"MUNICIPALIDAD DISTRITAL DE LOCROJA"]
[]
[null,"NOMBRE",null,null,"UNIDAD FORMULADORA DE DESARROLLO SOCIAL Y ECONÓMICO"]
[]
[null,"Persona Responsable de Formular la Ficha Técnica",null,null,"CARLOS NATIVIDAD TORERO",null,null,"PROFESION:","ING. AGRICOLA "]
[]
[null,"Persona Responsable de la Unidad Formuladora ",null,null,"LUIS LIVORA CANTELLA",null,null,"PROFESION:","ING. AGRÍCOLA"]
[]
[]
[null,"3. UNIDAD EJECUTORA DE INVERSIONES"]
[]
[null,"SECTOR",null,null,"GOBIERNOS LOCALES "]
[]
[null,"PLIEGO",null,null,"MUNICIPALIDAD DISTRITAL DE LOCROJA"]
[]
[null,"NOMBRE",null,null,"UNIDAD FORMULADORA DE DESARROLLO SOCIAL Y ECONÓMICO"]
[]
[null,"Persona Responsable de la Unidad Ejecutora",null,null,"JUAN PORTILLA CUETO",null,null,"PROFESION:","ING. AGRICOLA "]
[]
[null,"Organo Técnico Responsable",null,null,"GERENCIA DE INFRAESTRUCTURA Y OBRAS PÚBLICAS "]
[]
[]
[null,"4. UBICACIÓN  Y ACCESOS"]
[]
[null,"4.1. Ubicación Política"]
[]
[null,"REGIÓN",null,null,"HUANCAVELICA "]
[null,"PROVINCIA",null,null,"CHURCAMPA"]
[null,"DISTRITO",null,null,"LOCROJA"]
[null,"LOCALIDAD ",null,null,"CENTRO POBLADO SAN LUIS"]
[]
[null,"4.2. Ubicación Geográfica"]
[]
[null,"COORDENADAS UTM (m)","(WGS84)",null,"ESTE ",657259,"NORTE ",9406136,"ZONA","18 - M"]
[null,"ALTURA (msnm)",null,null,2542]
[null,"REGIÓN NATURAL",null,null,"Sierra"]
[]
[null,"4.3. Ubicación Hidrografica "]
[]
[null,"Vertiente","Atlántico",null,"Cuenca","Mantaro",null,"Microcuenca","Churcampa"]
[]
[null,"4.4. Vias de acceso al proyecto"]
[]
[null,"Tramo\n(DE) ","Tramo \n(HASTA)","Distancia (km)","Tiempo (Horas)","Tipo de vía","Estado"]
[null,"Lima ","Huancayo",300,7,"Asfaltado","B"]
[null,"Huancayo ","Churcampa",120,5,"Asfaltado - Afirmado","R"]
[null,"Churcampa ","San Luis ",50,1,"Afirmado ","R"]
[null,"San Luis ","Proyecto ",15,0.5,"Trocha carrozable","M"]
[null,"Valores posibles para el Estado: (B) bueno, (R) regular, (M) malo"]
[]
[]
[null,"II.  DEFINICIÓN DEL PROBLEMA Y OBJETIVOS "]
[]
[null,"5. DESCRIPCIÓN DE LA SITUACIÓN ACTUAL"]
[]
[null,"5.1. Administración del Agua con Fines Agrícolas "]
[]
[null,"AUTORIDAD ADMINISTRATIVA DEL AGUA (AAA)",null,null,"HUANCAVELICA "]
[null,"AUTORIDAD LOCAL DEL AGUA (ALA)",null,null,"HUANCAVELICA "]
[null,"JUNTA DE USUARIOS ",null,null,"HUANCAVELICA "]
[null,"COMISIÓN DE USUARIOS",null,null,"7 PAGOS"]
[null,"COMITÉ DE USUARIOS ",null,null,"SAN LUIS"]
[null,"OTROS",null,null,null,null,null,null,null,null,null,null,null,null,null,"EXPLICAR / PROFUNDIZAR - DGIAR"]
[null,"ORGANIZACIÓN FORMALIZADA POR LA ANA",null,null,"SI","X","NO",null,null,null,null,null,null,null,null,"EXPLICAR / PROFUNDIZAR - DGIAR"]
[]
[null,"5.2 Fuente Hídrica"]
[]
[null,"Fuente","Nombre","Ubicación geográfica UTM WGS84 "]
[null,null,null,"Este","Norte","Zona","Altitud \n(m.s.n.m)"]
[null,"Rio"]
[null,"Canal ","San Luis ",657278,9406140,"18 - M",2595]
[null,"Manantial (Puquial)"]
[null,"Quebrada"]
[null,"Pozo"]
[null,"Otros: "]
[]
[null,"5.3 Beneficiarios Directos"]
[]
[null,"NÚMERO DE USUARIOS  BENEFICIADOS",null,null,12,"agricultores"]
[]
[null,"6. PROBLEMA CENTRAL Y SUS CAUSAS"]
[]
[null,"6.1. Problema Central"]
[]
[null,"Descripción del Problema Central"]
[null,"Baja productividad agrícola en el ámbito del Centro Poblado San Luis – Distrito de Locroja – Provincia de Churcampa – Huancavelica "]
[]
[null,"6.2. Causas que Generan el Problema"]
[]
[null,"Nº","Descripción de las Principales Causas",null,null,"Causas Indirectas"]
[null,"Causa 1","Ineficiencias en el uso del recurso hídrico ",null,null,"   i. Uso deficiente de técnicas de riego por gravedad (inundación, surco, etc.)\n   ii. Poco conocimiento de técnicas de riego  de mayor eficiencia"]
[null,"Causa 2","Inadecuada disponibilidad del recurso hídrico ",null,null,"   i. Insuficiente infraestructura hidráulica\n   ii. Inadecuada conservación de la infraestructura hidráulica\n   iii. Poca capacidad de gestión del recurso hídrico entre usuarios "]
[]
[null,"7. OBJETIVO Y MEDIOS FUNDAMENTALES"]
[]
[null,"7.1. Objetivo"]
[]
[null,"Descripción del Objetivo Central"]
[null,"Incremento de la productividad agrícola en el ámbito del Centro Poblado San Luis – Distrito de Locroja – Provincia Churcampa – Huancavelica "]
[]
[null,"7.2. Medios Fundamentales"]
[]
[null,"N°","Descripción Medios Fundamentales"]
[null,1,"Utilización de técnicas de riego presurizado"]
[null,2,"Mayor conocimiento de técnicas de riego más eficientes"]
[]
[]
[null,"III.  CUANTIFICACIÓN DE SU CONTRIBUCIÓN AL CIERRE DE BRECHAS"]
[]
[null,"11. CONTRIBUCIÓN AL CIERRE DE BRECHAS"]
[]
[null,"Brecha",null,null,"Unida de Medida",null,"Brecha Nacional",null,"Contribución al Cierre de Brecha "]
[null,"Área Bajo Riego Sin Riego Tecnificado",null,null,"ha",null,2362143,null,20]
[]
[]
[null,"IV.  FORMULACION Y EVALUACION"]
[]
[null,"12. HORIZONTE DE EVALUACIÓN (*)"]
[]
[null,"Número de Años del Horizonte de Evaluación",null,null,10,"AÑOS "]
[]
[null,"Sustento Técnico del Horizonte de Evaluación Elegido"]
[]
[null,"Tiempo de vida útil de los materiales y equipos que se utilizarán en el proyecto",null,null,null,null,"X"]
[null,"Periodo de productividad del cultivo (proyectos agroforestales)"]
[]
[]
[null,"6. BALANCE HÍDRICO"]
[]
[null,"7.3. Acreditación Hídrica"]
[]
[null,"DOCUMENTO DE ACREDITACIÓN HÍDRICA ",null,null,"LICENCIA ","X",null,"ACREDITACIÓN"]
[null,"DOCUMENTO DE LA ANA QUE SUSTENTA LA ACREDITACIÓN",null,null,"Resolución Administrativa N° 007-2015-ALA-HUANCAVELICA"]
[]
[null,"7.3. Cálculo de la Oferta Hídrica "]
[]
[null,"CAUDAL DE LA FUENTE AUTORIZADO",null,null,15,"l/s"]
[null,"VOLUMEN AUTORIZADO",null,null,null,"m3"]
[]
[null,"MES PROMEDIO","CAUDAL \n(l/s)","FRECUENCIA DE DOTACIÓN\n(cada x días)","TIEMPO DE RIEGO\n(horas por bloque)","VOLUMEN DISPONIBLE \n(m3)"]
[null,"ENERO "]
[null,"FEBRERO"]
[null,"MARZO"]
[null,"ABRIL"]
[null,"MAYO"]
[null,"JUNIO"]
[null,"JULIO"]
[null,"AGOSTO"]
[null,"SEPTIEMBRE"]
[null,"OCTUBRE"]
[null,"NOVIEMBRE"]
[null,"DICIEMBRE"]
[null,"VOLUMEN TOTAL "]
[]
[]
[null,"7.3. Cálculo de la Demanda Hídrica - Sin Proyecto "]
[]
[null,"ÁREA A BENEFICIAR ",null,null,20,"ha"]
[null,"MÉTODO DE RIEGO A NIVEL PARCELARIO",null,null,"GRAVEDAD"]
[null,"EFICIENCIA DE APLICACIÓN",null,null,30,"%"]
[]
[null,"MÉTODO DE RIEGO","GRAVEDAD","GRAVEDAD","GRAVEDAD",null,"ÁREA A IRRIGAR ","VOLUMEN DEMANDADO"]
[null,"CEDULA ","ALFALFA","MAIZ","PAPA",null,"ha","M3"]
[null,"ENERO ",15,null,5,null,{"$f":"+C182+D182+E182+F182","v":20}]
[null,"FEBRERO",15,null,5,null,{"$f":"+C183+D183+E183+F183","v":20}]
[null,"MARZO",15,null,null,null,15]
[null,"ABRIL",15,5,null,null,20]
[null,"MAYO",15,5,null,null,20]
[null,"JUNIO",15,5,null,null,20]
[null,"JULIO",15,5,null,null,20]
[null,"AGOSTO",15,5,null,null,20]
[null,"SEPTIEMBRE",15,null,null,null,15]
[null,"OCTUBRE",15,null,5,null,20]
[null,"NOVIEMBRE",15,null,5,null,20]
[null,"DICIEMBRE",15,null,5,null,20]
[null,"VOLUMEN TOTAL "]
[]
[]
[null,"7.3. Cálculo de la Demanda Hídrica - Con Proyecto "]
[]
[null,"ÁREA A BENEFICIAR ",null,null,15,"ha"]
[null,"MÉTODO DE RIEGO A NIVEL PARCELARIO",null,null,"ASPERSIÓN"]
[null,"EFICIENCIA DE APLICACIÓN",null,null,75,"%"]
[]
[null,"ÁREA A BENEFICIAR ",null,null,5,"ha"]
[null,"MÉTODO DE RIEGO A NIVEL PARCELARIO",null,null,"GOTEO"]
[null,"EFICIENCIA DE APLICACIÓN",null,null,90,"%"]
[]
[]
[null,"MÉTODO DE RIEGO","ASPERSIÓN","ASPERSIÓN","ASPERSIÓN","GOTEO","ÁREA A IRRIGAR ","VOLUMEN DEMANDADO"]
[null,"CEDULA ","ALFALFA","HABA","QUINUA","PALTO","ha","M3"]
[null,"ENERO ",10,null,5,5,{"$f":"+C210+D210+E210+F210","v":20}]
[null,"FEBRERO",10,null,5,5,{"$f":"+C211+D211+E211+F211","v":20}]
[null,"MARZO",10,null,null,5,15]
[null,"ABRIL",10,5,null,5,20]
[null,"MAYO",10,5,null,5,20]
[null,"JUNIO",10,5,null,5,20]
[null,"JULIO",10,5,null,5,20]
[null,"AGOSTO",10,5,null,5,20]
[null,"SEPTIEMBRE",10,null,null,5,15]
[null,"OCTUBRE",10,null,5,5,20]
[null,"NOVIEMBRE",10,null,5,5,20]
[null,"DICIEMBRE",10,null,5,5,20]
[null,"VOLUMEN TOTAL "]
[]
[]
[null,"7.3. Cálculo del Balance Hídrico - Sin Proyecto "]
[]
[null,null,"Oferta Hídrica \n(m3)","Demanda Hídrica Sin Proyecto\n(m3)","Balance Hídrico Sin Proyecto \n(m3)"]
[null,"ENERO "]
[null,"FEBRERO"]
[null,"MARZO",null,null,null,null,"INSERTAR GRÁFICO"]
[null,"ABRIL"]
[null,"MAYO"]
[null,"JUNIO"]
[null,"JULIO"]
[null,"AGOSTO"]
[null,"SEPTIEMBRE"]
[null,"OCTUBRE"]
[null,"NOVIEMBRE"]
[null,"DICIEMBRE"]
[null,"VOLUMEN TOTAL "]
[]
[]
[null,"7.3. Cálculo del Balance Hídrico - Con Proyecto "]
[]
[null,null,"Oferta Hídrica \n(m3)","Demanda Hídrica Con Proyecto\n(m3)","Balance Hídrico Con Proyecto \n(m3)"]
[null,"ENERO "]
[null,"FEBRERO"]
[null,"MARZO",null,null,null,null,"INSERTAR GRÁFICO"]
[null,"ABRIL"]
[null,"MAYO"]
[null,"JUNIO"]
[null,"JULIO"]
[null,"AGOSTO"]
[null,"SEPTIEMBRE"]
[null,"OCTUBRE"]
[null,"NOVIEMBRE"]
[null,"DICIEMBRE"]
[null,"VOLUMEN TOTAL "]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"6. ESTIMACIÓN DE LOS COSTOS DEL PROYECTO"]
[]
[null,"OJO COORDINAR CON EQUIPO OTR"]
[]
[null,"21. RIESGOS"]
[null,"21.1  ¿El área donde se ubica el proyecto ha sido afectada por algún desastre natural?"]
[]
[]
[null,null,"No","X"]
[]
[null,null,"Si"]
[]
[null,null,"Medidas consideradas en el proyecto para mitigar el desastre"]
[null,null,"Acción 1"]
[]
[null,null,"Acción 2"]
[]
[null,null,"Acción \"n\""]
[]
[]
[null,"22. IMPACTO AMBIENTAL"]
[]
[null,null,"IMPACTOS NEGATIVOS",null,"MEDIDAS DE MITIGACIÓN",null,null,"COSTO (S/.)"]
[null,null,"Durante la Ejecución"]
[null,null,"Impacto 1:\nAcumulación de residuos sólidos de construcción y otros ",null,"Eliminación en depósitos de materiales excedentes",null,null,5250]
[null,null,"Impacto 2:"]
[null,null,"Impacto n:"]
[null,null,"Durante la Operación"]
[null,null,"Impacto 1:"]
[null,null,"Impacto n:"]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"COSTOS DE OPERACIÓN Y MANTENIMIENTO"]
[]
[]
[]
[null,"COSTOS DE REPOSICIÓN "]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"6. ESTIMACIÓN DE LOS BENEFICIOS DEL PROYECTO"]
[]
[null,"7.3. Cálculo del Valor Neto de la Producción - Sin Proyecto "]
[]
[null,"CULTIVOS ESTACIONALES "]
[]
[null,null,{"$f":"+D181","v":"MAIZ"},{"$f":"+E181","v":"PAPA"}]
[null,"Área de Cédula ",{"$f":"+D217","v":5},{"$f":"+E193","v":5}]
[null,"Rendimiento "]
[null,"Precio en Chacra "]
[null,"VBP"]
[]
[null,"Costo de Producción"]
[null,"VNP"]
[]
[null,"CULTIVOS PERMANENTES"]
[]
[null,null,{"$f":"+C181","v":"ALFALFA"},"AÑO 1","AÑO 2","AÑO 3","AÑO 4","AÑO 5","AÑO 6","AÑO 7","AÑO 8","AÑO 9","AÑO 10"]
[null,"Área de Cédula ",{"$f":"+C193","v":15}]
[null,"Rendimiento "]
[null,"Precio en Chacra "]
[null,"VBP"]
[]
[null,"Costo de Producción"]
[null,"VNP"]
[]
[null,"7.3. Cálculo del Valor Neto de la Producción - Con Proyecto "]
[]
[null,"CULTIVOS ESTACIONALES "]
[]
[null,null,{"$f":"+D209","v":"HABA"},{"$f":"+E209","v":"QUINUA"}]
[null,"Área de Cédula ",{"$f":"+D217","v":5},{"$f":"+E211","v":5}]
[null,"Rendimiento "]
[null,"Precio en Chacra "]
[null,"VBP"]
[]
[null,"Costo de Producción"]
[null,"VNP"]
[]
[]
[null,"CULTIVOS PERMANENTES"]
[]
[null,null,{"$f":"+C209","v":"ALFALFA"},"AÑO 1","AÑO 2","AÑO 3","AÑO 4","AÑO 5","AÑO 6","AÑO 7","AÑO 8","AÑO 9","AÑO 10"]
[null,"Área de Cédula ",{"$f":"+C221","v":10}]
[null,"Rendimiento "]
[null,"Precio en Chacra "]
[null,"VBP"]
[]
[null,"Costo de Producción"]
[null,"VNP"]
[]
[null,"CULTIVOS PERMANENTES"]
[]
[null,null,{"$f":"+F209","v":"PALTO"},"AÑO 1","AÑO 2","AÑO 3","AÑO 4","AÑO 5","AÑO 6","AÑO 7","AÑO 8","AÑO 9","AÑO 10"]
[null,"Área de Cédula ",{"$f":"+F211","v":5}]
[null,"Rendimiento "]
[null,"Precio en Chacra "]
[null,"VBP"]
[]
[null,"Costo de Producción"]
[null,"VNP"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"7.3. Características de la Producción Agrícola - Situación Actual"]
[]
[null,"CÉDULA DE CULTIVO ACTUAL ",null,null,"PASTOS","ALFALFA"]
[null,"RENDIMIENTO DEL CULTIVO Kg/ha  ",null,null,15000,15000]
[null,"PRECIO EN CHACRA (Soles/Kg)",null,null,0.2,0.2]
[null,"COSTO DE PRODUCCION (Soles/ha)",null,null,1800,2000]
[null,"DESTINO DE LA PRODUCCIÓN",null,null,"AUTOCONSUMO",0.3,"MDO. LOCAL / REGIONAL",0.7,"MDO. EXPORTACION"]
[]
[]
[]
[null,"V.  REQUISITOS INSTITUCIONALES Y/O NORMATIVOS"]
[]
[null,"20.1  Responsable de la Operación y Mantenimiento del PIP"]
[null,"El responsable de la operación y mantenimiento del sistema de riego estará a cargo de la organización de usuarios beneficiarios del sector San Luis, velando por el adecuado funcionamiento de los equipos de riego"]
[]
[null,"Documentos que sustentan los acuerdos institucionales u otros que garantizan el financiamiento de los gastos de operación y mantenimiento"]
[null,"Documento","Entidad / Organización",null,null,"Compromiso"]
[null,"Acta de Compromisos","Grupo beneficiario",null,null,"Operar y mantener de forma adecuada el sistema de riego tecnificado, acorde con las recomendaciones impartidas durante el proceso de capacitación."]
[]
[]
[null,"23. Documentos para la viabilidad"]
[null,"Adjunta la constancia de disponibilidad hídrica emitida por la ANA."]
[null,"Adjuntan documentos de acreditación de propiedad del terreno de los beneficiarios."]
[null,"Adjunta la acreditración como usuario de agua emitida por la Organización de Usuarios de Agua."]
[null,"Adjunta acta de compromiso de aporte de contrapartida económica de los beneficiarios."]
[null,"Adjunta acta de libre disponibilidad de terreno."]
[null,"Adjunta constancia de rol de distribución de agua emitido por la OUA."]
[]
[null,"24. ANEXOS"]
[]
[null,"Croquis de Ubicación"]
[null,"Balance Hídrico"]
[null,"Flujo de Caja"]
[null,"Presupuesto"]
[null,"Panel Fotográfico"]
[]
[null,"25.  FECHA DE  FORMULACIÓN"]
[null,null,null,null,"2017-03-23"]
[]
[null,"26. FIRMAS"]
[]
[]
[]
[]
[]
[null,null,"Responsable de la Formulación del Perfil",null,null,null,"Responsable de la Unidad Formuladora"]

{"sheet":"Balance","index":3,"n_rows":30,"n_cols":17,"rows_kept":30,"cut":false,"hidden":true,"merged":[[13,2,13,16],[2,2,2,16],[4,1,5,1],[4,2,5,2],[4,3,5,3],[4,4,5,4],[4,5,4,16],[6,2,7,2],[6,3,7,3],[8,2,9,2],[8,3,9,3],[11,2,12,2],[30,2,30,16],[19,2,19,16],[21,1,22,1],[21,2,22,2],[21,3,22,3],[21,4,22,4],[21,5,21,16],[23,2,24,2],[23,3,24,3],[25,2,26,2],[25,3,26,3],[28,2,29,2]]}
[]
[]
[null,null,"BALANCE HÍDRICO  - SIN PROYECTO"]
[]
[null,"N°","Descripción","Cálculo","Unidad","Meses"]
[null,null,null,null,null,"Ene","Feb","Mar","Abr","May","Jun","Jul","Ago","Sep","Oct","Nov","Dic"]
[null,"a","Oferta ","Dato de Oferta","(m3/mes)",{"$f":"+Oferta!G15","v":38880},{"$f":"+Oferta!H15","v":38880},{"$f":"+Oferta!I15","v":38880},{"$f":"+Oferta!J15","v":25920},{"$f":"+Oferta!K15","v":25920},{"$f":"+Oferta!L15","v":25920},{"$f":"+Oferta!M15","v":25920},{"$f":"+Oferta!N15","v":25920},{"$f":"+Oferta!O15","v":25920},{"$f":"+Oferta!P15","v":25920},{"$f":"+Oferta!Q15","v":38880},{"$f":"+Oferta!R15","v":38880}]
[null,"b",null,null,"(m3/dia)",{"$f":"+Oferta!G15/Oferta!G12","v":1254.1935483870968},{"$f":"+Oferta!H15/Oferta!H12","v":1388.5714285714287},{"$f":"+Oferta!I15/Oferta!I12","v":1254.1935483870968},{"$f":"+Oferta!J15/Oferta!J12","v":864},{"$f":"+Oferta!K15/Oferta!K12","v":836.12903225806451},{"$f":"+Oferta!L15/Oferta!L12","v":864},{"$f":"+Oferta!M15/Oferta!M12","v":836.12903225806451},{"$f":"+Oferta!N15/Oferta!N12","v":836.12903225806451},{"$f":"+Oferta!O15/Oferta!O12","v":864},{"$f":"+Oferta!P15/Oferta!P12","v":836.12903225806451},{"$f":"+Oferta!Q15/Oferta!Q12","v":1296},{"$f":"+Oferta!R15/Oferta!R12","v":1254.1935483870968}]
[null,"c","Demanda","Dato de Demanda","(m3/mes)",{"$f":"+Demanda!F37","v":32260.666666666661},{"$f":"+Demanda!G37","v":5688.0000000000009},{"$f":"+Demanda!H37","v":11390},{"$f":"+Demanda!I37","v":34941.666666666664},{"$f":"+Demanda!J37","v":52935.000000000007},{"$f":"+Demanda!K37","v":59842.500000000015},{"$f":"+Demanda!L37","v":65735.833333333343},{"$f":"+Demanda!M37","v":67495.833333333343},{"$f":"+Demanda!N37","v":43600},{"$f":"+Demanda!O37","v":22380.666666666661},{"$f":"+Demanda!P37","v":50862.5},{"$f":"+Demanda!Q37","v":21634.916666666668}]
[null,"d",null,null,"(m3/dia)",{"$f":"+Demanda!F36","v":1040.6666666666665},{"$f":"+Demanda!G36","v":203.14285714285717},{"$f":"+Demanda!H36","v":367.41935483870969},{"$f":"+Demanda!I36","v":1164.7222222222222},{"$f":"+Demanda!J36","v":1707.5806451612905},{"$f":"+Demanda!K36","v":1994.7500000000005},{"$f":"+Demanda!L36","v":2120.5107526881725},{"$f":"+Demanda!M36","v":2177.2849462365593},{"$f":"+Demanda!N36","v":1453.3333333333333},{"$f":"+Demanda!O36","v":721.95698924731164},{"$f":"+Demanda!P36","v":1695.4166666666667},{"$f":"+Demanda!Q36","v":697.90053763440869}]
[]
[null,"e","Balance Hídrico","(a - c)","(m3/mes)",{"$f":"+F7-F9","v":6619.3333333333394},33192,27490,-9021.6666666666642,-27015.000000000007,-33922.500000000015,-39815.833333333343,-41575.833333333343,-17680,3539.3333333333394,-11982.5,17245.083333333332]
[null,"f",null,"(b - d)","(m3/dia)",213.52688172043031,1185.4285714285716,886.77419354838707,-300.72222222222217,-871.45161290322596,-1130.7500000000005,-1284.3817204301081,-1341.1559139784949,-589.33333333333326,114.17204301075287,-399.41666666666674,556.29301075268813]
[]
[]
[]
[]
[]
[]
[null,null,"BALANCE HÍDRICO  - CON PROYECTO"]
[]
[null,"N°","Descripción","Cálculo","Unidad","Meses"]
[null,null,null,null,null,"Ene","Feb","Mar","Abr","May","Jun","Jul","Ago","Sep","Oct","Nov","Dic"]
[null,"a","Oferta ","Dato de Oferta","(m3/ha/mes)",{"$f":"+F7","v":38880},{"$f":"+G7","v":38880},38880,25920,25920,25920,25920,25920,25920,25920,38880,38880]
[null,"b",null,null,"(m3/ha/dia)",{"$f":"+F8","v":1254.1935483870968},{"$f":"+G8","v":1388.5714285714287},1254.1935483870968,864,836.12903225806451,864,836.12903225806451,836.12903225806451,864,836.12903225806451,1296,1254.1935483870968]
[null,"c","Demanda","Dato de Demanda","(m3/ha/mes)",{"$f":"+Demanda!F56+Demanda!F87","v":10106.688888888888},{"$f":"+Demanda!G56+Demanda!G87","v":860.80000000000109},{"$f":"+Demanda!H56+Demanda!H87","v":3037.3333333333335},{"$f":"+Demanda!I56+Demanda!I87","v":12390.055555555555},{"$f":"+Demanda!J56+Demanda!J87","v":19580.3},{"$f":"+Demanda!K56+Demanda!K87","v":19090},{"$f":"+Demanda!L56+Demanda!L87","v":21661.722222222223},{"$f":"+Demanda!M56+Demanda!M87","v":24846.837777777779},{"$f":"+Demanda!N56+Demanda!N87","v":19425.277777777774},{"$f":"+Demanda!O56+Demanda!O87","v":8188.4444444444443},{"$f":"+Demanda!P56+Demanda!P87","v":17546.166666666668},{"$f":"+Demanda!Q56+Demanda!Q87","v":5827.7222222222208}]
[null,"d",null,null,"(m3/ha/dia)",{"$f":"+Demanda!F57+Demanda!F88","v":326.02222222222218},{"$f":"+Demanda!G57+Demanda!G88","v":30.742857142857183},{"$f":"+Demanda!H57+Demanda!H88","v":97.978494623655919},{"$f":"+Demanda!I57+Demanda!I88","v":413.00185185185182},{"$f":"+Demanda!J57+Demanda!J88","v":631.62258064516129},{"$f":"+Demanda!K57+Demanda!K88","v":636.33333333333326},{"$f":"+Demanda!L57+Demanda!L88","v":698.76523297491042},{"$f":"+Demanda!M57+Demanda!M88","v":801.51089605734774},{"$f":"+Demanda!N57+Demanda!N88","v":647.50925925925912},{"$f":"+Demanda!O57+Demanda!O88","v":264.14336917562724},{"$f":"+Demanda!P57+Demanda!P88","v":584.87222222222226},{"$f":"+Demanda!Q57+Demanda!Q88","v":187.99103942652326}]
[]
[null,"e","Balance Hídrico","(a - c)","(m3/ha/mes)",{"$f":"+F24-F26","v":28773.311111111114},38019.199999999997,35842.666666666664,13529.944444444445,6339.7000000000007,6830,4258.2777777777774,1073.1622222222213,6494.7222222222263,17731.555555555555,21333.833333333332,33052.277777777781]
[null,"f",null,"(b - d)","(m3/ha/dia)",928.1713261648747,1357.8285714285714,1156.2150537634409,450.99814814814818,204.50645161290322,227.66666666666674,137.36379928315409,34.618136200716776,216.49074074074088,571.98566308243721,711.12777777777774,1066.2025089605736]

{"sheet":"Demanda","index":4,"n_rows":99,"n_cols":24,"rows_kept":99,"cut":false,"hidden":true,"merged":[[5,23,5,34],[81,2,82,2],[93,1,93,17],[94,1,95,1],[94,2,95,2],[94,3,95,3],[94,4,95,4],[94,5,94,16],[94,17,95,17],[50,2,51,2],[71,1,71,17],[73,1,74,1],[73,2,74,2],[73,3,74,3],[73,4,74,4],[73,5,73,16],[73,17,74,17],[62,1,62,17],[63,1,64,1],[63,2,64,2],[63,3,64,3],[63,4,64,4],[63,5,63,16],[63,17,64,17],[40,1,40,17],[42,1,43,1],[42,2,43,2],[42,3,43,3],[42,4,43,4],[42,5,42,16],[42,17,43,17],[15,2,16,2],[31,1,31,17],[32,1,33,1],[32,2,33,2],[32,3,33,3],[32,4,33,4],[32,5,32,16],[32,17,33,17],[5,1,5,17],[7,1,8,1],[7,2,8,2],[7,3,8,3],[7,4,8,4],[7,5,7,16],[7,17,8,17]]}
[]
[]
[]
[]
[]
[null,"CÁLCULO DE LA DEMANDA HÍDRICA \"SIN PROYECTO\" ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"EJEMPLOS DE FUENTE DE INFORMACIÓN ETO y PRECIPITACIÓN EFECTIVA"]
[]
[null,"N°","Descripción","Cálculo","Unidad","Meses",null,null,null,null,null,null,null,null,null,null,null,"Total"]
[null,null,null,null,null,"Ene","Feb","Mar","Abr","May","Jun","Jul","Ago","Sep","Oct","Nov","Dic"]
[null,"a","Eto","Dato","mm/día",3.24,3.02,2.88,3.09,3.06,2.99,3.1,3.58,3.65,3.46,3.63,3.03]
[null,"b","Kc Ponderado","Dato",null,{"$f":"+Kc!D23","v":1.0249999999999999},{"$f":"+Kc!E23","v":0.95},{"$f":"+Kc!F23","v":1},{"$f":"+Kc!G23","v":0.875},{"$f":"+Kc!H23","v":0.875},{"$f":"+Kc!I23","v":1.0375000000000001},{"$f":"+Kc!J23","v":1.0375000000000001},{"$f":"+Kc!K23","v":0.9375},{"$f":"+Kc!L23","v":1},{"$f":"+Kc!M23","v":0.85},{"$f":"+Kc!N23","v":0.9375},{"$f":"+Kc!O23","v":1.0375000000000001}]
[null,"c","Uso Consultivo o Evaporación Real  ","(a x b)","mm/día",{"$f":"+F10*F11","v":3.3209999999999997},2.8689999999999998,2.88,2.7037499999999999,2.6775000000000002,3.1021250000000005,3.2162500000000005,3.3562500000000002,3.65,2.9409999999999998,3.4031249999999997,3.1436250000000001]
[null,"d","Precipitación Efectiva","Dato","mm/día",1.76,2.5642857142857141,2.1451612903225805,0.95666666666666667,0.11612903225806452,0.11,3.5483870967741936E-2,9.0322580645161285E-2,0.7433333333333334,1.8580645161290323,0.86,2.096774193548387]
[null,"e","Necesidades Netas del Cultivo  ","(c - d)","mm/día",{"$f":"+IF((F12-F13)<0,0,(F12-F13))","v":1.5609999999999997},{"$f":"+IF((G12-G13)<0,0,(G12-G13))","v":0.30471428571428572},0.73483870967741938,1.7470833333333333,2.5613709677419356,2.9921250000000006,3.1807661290322584,3.2659274193548389,2.9066666666666663,1.0829354838709675,2.5431249999999999,1.0468508064516131]
[null,"f","Eficiencia de Riego","Dato","%",{"$f":"'2. Balance Hídrico'!E59","v":0.3},{"$f":"+F15","v":0.3},{"$f":"+G15","v":0.3},0.3,0.3,0.3,0.3,0.3,0.3,0.3,0.3,0.3]
[null,"g","Necesidades Totales del Cultivo  ","(e / f)","mm/día",{"$f":"+F14/F15","v":5.2033333333333323},{"$f":"+G14/G15","v":1.0157142857142858},2.4494623655913981,5.8236111111111111,8.5379032258064527,9.9737500000000026,{"$f":"+L14/L15","v":10.602553763440861},10.886424731182796,9.6888888888888882,3.6097849462365583,8.4770833333333329,3.4895026881720437]
[null,"h",null,"(e / f) x 10","m3-ha/día",{"$f":"+F16*10","v":52.033333333333324},10.157142857142858,24.49462365591398,58.236111111111114,85.379032258064527,99.737500000000026,106.02553763440861,108.86424731182797,96.888888888888886,36.097849462365581,84.770833333333329,34.89502688172044]
[null,"i","N° de Días del Mes","Dato",null,31,28,31,30,31,30,31,31,30,31,30,31]
[null,"j","Demanda Total Unitaria - Mensual","(h x i)","m3/ha/mes",{"$f":"+F17*F18","v":1613.0333333333331},284.40000000000003,759.33333333333337,1747.0833333333335,2646.7500000000005,2992.1250000000009,3286.791666666667,3374.791666666667,2906.6666666666665,1119.0333333333331,2543.125,1081.7458333333336]
[null,"k","Área de Riego","Dato","ha",{"$f":"+Kc!D12","v":20},{"$f":"+Kc!E12","v":20},{"$f":"+Kc!F12","v":15},{"$f":"+Kc!G12","v":20},{"$f":"+Kc!H12","v":20},{"$f":"+Kc!I12","v":20},{"$f":"+Kc!J12","v":20},{"$f":"+Kc!K12","v":20},{"$f":"+Kc!L12","v":15},{"$f":"+Kc!M12","v":20},{"$f":"+Kc!N12","v":20},{"$f":"+Kc!O12","v":20}]
[null,"l","Demanda Total - Mensual","(j x k)","m3/mes",{"$f":"+F19*F20","v":32260.666666666661},{"$f":"+G19*G20","v":5688.0000000000009},11390,34941.666666666672,52935.000000000007,59842.500000000015,65735.833333333343,67495.833333333343,43600,22380.666666666661,50862.5,21634.916666666672,{"$f":"SUM(F21:Q21)","v":468767.58333333349}]
[null,"m","Demanda Total - Diaria","(l / i)","m3/día",{"$f":"+F21/F18","v":1040.6666666666665},{"$f":"+G21/G18","v":203.14285714285717},367.41935483870969,1164.7222222222224,1707.5806451612905,1994.7500000000005,2120.5107526881725,2177.2849462365593,1453.3333333333333,721.95698924731164,1695.4166666666667,697.90053763440881,{"$f":"SUM(F22:Q22)","v":15344.6849718382}]
[]
[]
[]
[]
[]
[]
[null,"CÁLCULO DEL VOLUMEN DEMANDADO"]
[]
[null,"TIEMPO DE OPERACIÓN DIARIO",null,24,"HORAS"]
[]
[null,"N°","Descripción","Cálculo","Unidad","Meses",null,null,null,null,null,null,null,null,null,null,null,"Total"]
[null,null,null,null,null,"Ene","Feb","Mar","Abr","May","Jun","Jul","Ago","Sep","Oct","Nov","Dic"]
[null,"m","Módulo de Riego ",null,"l/s / ha ",{"$f":"+F16*(10000/($D$31*60*60))","v":0.60223765432098753},{"$f":"+G16*(10000/($D$31*60*60))","v":0.11755952380952382},0.28350258861011551,0.67402906378600824,0.98818324372759869,1.1543692129629632,1.2271474263241737,1.2600028624054163,1.1213991769547325,0.41779918359219426,0.98114390432098764,0.40387762594583837]
[null,"n","Demanda Total Diaria",null,"m3/día",{"$f":"+F35*F20*24*60*60/1000","v":1040.6666666666665},{"$f":"+G35*G20*24*60*60/1000","v":203.14285714285717},367.41935483870969,1164.7222222222222,1707.5806451612905,1994.7500000000005,2120.5107526881725,2177.2849462365593,1453.3333333333333,721.95698924731164,1695.4166666666667,697.90053763440869,{"$f":"SUM(F36:Q36)","v":15344.6849718382}]
[null,"o","Demanda Total Mensual",null,"m3/mes",{"$f":"+F36*F18","v":32260.666666666661},{"$f":"+G36*G18","v":5688.0000000000009},11390,34941.666666666664,52935.000000000007,59842.500000000015,65735.833333333343,67495.833333333343,43600,22380.666666666661,50862.5,21634.916666666668,{"$f":"SUM(F37:Q37)","v":468767.58333333349}]
[]
[]
[]
[null,"CÁLCULO DE LA DEMANDA HÍDRICA \"CON PROYECTO\" - ASPERSIÓN"]
[]
[null,"N°","Descripción","Cálculo","Unidad","Meses",null,null,null,null,null,null,null,null,null,null,null,"Total"]
[null,null,null,null,null,"Ene","Feb","Mar","Abr","May","Jun","Jul","Ago","Sep","Oct","Nov","Dic"]
[null,"a","Eto","Dato","mm/dia",{"$f":"+F10","v":3.24},{"$f":"+G10","v":3.02},2.88,3.09,3.06,2.99,3.1,3.58,3.65,3.46,3.63,3.03]
[null,"b","Kc Ponderado","Dato",null,{"$f":"+Kc!D53","v":1.0166666666666666},{"$f":"+Kc!E53","v":0.9},{"$f":"+Kc!F53","v":1},{"$f":"+Kc!G53","v":0.8833333333333333},{"$f":"+Kc!H53","v":0.9},{"$f":"+Kc!I53","v":0.91666666666666663},{"$f":"+Kc!J53","v":0.93333333333333335},{"$f":"+Kc!K53","v":0.94333333333333325},{"$f":"+Kc!L53","v":0.91666666666666663},{"$f":"+Kc!M53","v":1},{"$f":"+Kc!N53","v":0.9},{"$f":"+Kc!O53","v":1}]
[null,"c","Uso Consultivo o Evaporación Real  ","(a x b)","mm/dia",{"$f":"+F45*F46","v":3.294},2.718,2.88,2.7294999999999998,2.754,2.7408333333333332,2.8933333333333335,3.3771333333333331,3.3458333333333332,3.46,3.2669999999999999,3.03]
[null,"d","Precipitación Efectiva","Dato","mm/dia",{"$f":"+F13","v":1.76},{"$f":"+G13","v":2.5642857142857141},2.1451612903225805,0.95666666666666667,0.11612903225806452,0.11,3.5483870967741936E-2,9.0322580645161285E-2,0.7433333333333334,1.8580645161290323,0.86,2.096774193548387]
[null,"e","Necesidades Netas del Cultivo  ","(c - d)","mm/dia",{"$f":"+IF((F47-F48)<0,0,(F47-F48))","v":1.534},{"$f":"+IF((G47-G48)<0,0,(G47-G48))","v":0.15371428571428591},{"$f":"+IF((H47-H48)<0,0,(H47-H48))","v":0.73483870967741938},1.7728333333333333,2.6378709677419354,2.6308333333333334,2.8578494623655915,3.2868107526881718,2.6025,1.6019354838709676,2.407,0.93322580645161279,{"$f":"SUM(F49:Q49)","v":23.153412135176652}]
[null,"f","Eficiencia de Riego","Dato","%",0.75,{"$f":"+F50","v":0.75},{"$f":"+G50","v":0.75},0.75,0.75,0.75,0.75,0.75,0.75,0.75,0.75,0.75]
[null,"g","Necesidades Totales del Cultivo  ","(e / f)","mm/dia",{"$f":"+F49/F50","v":2.0453333333333332},{"$f":"+G49/G50","v":0.20495238095238122},{"$f":"+H49/H50","v":0.97978494623655921},2.3637777777777775,3.5171612903225804,3.5077777777777777,3.8104659498207885,4.3824143369175621,3.47,2.1359139784946235,3.2093333333333334,1.2443010752688171,{"$f":"SUM(F51:Q51)","v":30.871216180235535}]
[null,"h",null,"(e / f) x 10","m3-ha/dia",{"$f":"+F51*10","v":20.453333333333333},2.0495238095238122,9.7978494623655923,23.637777777777774,35.171612903225807,35.077777777777776,38.104659498207887,43.824143369175623,34.700000000000003,21.359139784946237,32.093333333333334,12.443010752688171,{"$f":"SUM(F52:Q52)","v":308.71216180235541}]
[null,"i","N° de Días del Mes","Dato",null,{"$f":"+F18","v":31},28,31,30,31,30,31,31,30,31,30,31]
[null,"j","Demanda Total Unitaria - Mensual","(h x i)","m3/ha/mes",{"$f":"+F52*F53","v":634.05333333333328},57.386666666666741,303.73333333333335,709.13333333333321,1090.32,{"$f":"+K52*K53","v":1052.3333333333333},1181.2444444444445,1358.5484444444444,1041,662.13333333333333,962.8,385.73333333333329,{"$f":"SUM(F54:Q54)","v":9438.4195555555561}]
[null,"k","Área de Riego","Dato","ha",{"$f":"+Kc!D41","v":15},{"$f":"+Kc!E41","v":15},{"$f":"+Kc!F41","v":10},{"$f":"+Kc!G41","v":15},{"$f":"+Kc!H41","v":15},{"$f":"+Kc!I41","v":15},{"$f":"+Kc!J41","v":15},{"$f":"+Kc!K41","v":15},{"$f":"+Kc!L41","v":15},{"$f":"+Kc!M41","v":10},{"$f":"+Kc!N41","v":15},{"$f":"+Kc!O41","v":15}]
[null,"l","Demanda Total - Mensual","(j x k)","m3/mes",{"$f":"+F54*F55","v":9510.7999999999993},860.80000000000109,3037.3333333333335,10636.999999999998,16354.8,15784.999999999998,17718.666666666668,20378.226666666666,15615,6621.333333333333,14442,5785.9999999999991,{"$f":"SUM(F56:Q56)","v":136746.96}]
[null,"m","Demanda Total - Diaria","(l / i)","m3/día",{"$f":"+F56/F53","v":306.79999999999995},30.742857142857183,97.978494623655919,354.56666666666661,527.57419354838703,526.16666666666663,571.56989247311833,657.36215053763442,520.5,213.59139784946237,481.4,186.64516129032256,{"$f":"SUM(F57:Q57)","v":4474.8974807987715}]
[]
[]
[null,"CÁLCULO DEL VOLUMEN DEMANDADO"]
[]
[null,"TIEMPO DE OPERACIÓN DIARIO",null,{"$f":"+D31","v":24},"HORAS"]
[]
[null,"N°","Descripción","Cálculo","Unidad","Meses",null,null,null,null,null,null,null,null,null,null,null,"Total"]
[null,null,null,null,null,"Ene","Feb","Mar","Abr","May","Jun","Jul","Ago","Sep","Oct","Nov","Dic"]
[null,"m","Módulo de Riego ",null,"l/s / ha ",{"$f":"+F51*(10000/($D$62*60*60))","v":0.23672839506172838},{"$f":"+G51*(10000/($D$62*60*60))","v":2.3721340388007085E-2},0.1134010354440462,0.27358539094650203,0.40707885304659497,0.40599279835390945,0.44102615159962827,0.50722388158768084,0.40162037037037041,0.2472122660294703,0.37145061728395062,0.14401632815611309]
[null,"n","Demanda Total Diaria",null,"m3/día",{"$f":"+F66*F55*24*60*60/1000","v":306.8},{"$f":"+G66*G55*24*60*60/1000","v":30.742857142857179},97.978494623655919,354.56666666666661,527.57419354838703,526.16666666666663,571.56989247311833,657.36215053763442,520.5,213.59139784946234,481.40000000000003,186.64516129032256,{"$f":"SUM(F67:Q67)","v":4474.8974807987715}]
[null,"o","Demanda Total Mensual",null,"m3/mes",{"$f":"+F67*F53","v":9510.8000000000011},{"$f":"+G67*G53","v":860.80000000000098},3037.3333333333335,10636.999999999998,16354.799999999997,15784.999999999998,17718.666666666668,20378.226666666666,15615,6621.3333333333321,14442.000000000002,5785.9999999999991,{"$f":"SUM(F68:Q68)","v":136746.96}]
[]
[]
[]
[null,"CÁLCULO DE LA DEMANDA HÍDRICA \"CON PROYECTO\" - GOTEO"]
[]
[null,"N°","Descripción","Cálculo","Unidad","Meses",null,null,null,null,null,null,null,null,null,null,null,"Total"]
[null,null,null,null,null,"Ene","Feb","Mar","Abr","May","Jun","Jul","Ago","Sep","Oct","Nov","Dic"]
[null,"a","Eto","Dato","mm/dia",{"$f":"+F45","v":3.24},{"$f":"+G45","v":3.02},2.88,3.09,3.06,2.99,3.1,3.58,3.65,3.46,3.63,3.03]
[null,"b","Kc Ponderado","Dato",null,{"$f":"+Kc!D79","v":0.65},{"$f":"+Kc!E79","v":0.6},{"$f":"+Kc!F79","v":0.6},{"$f":"+Kc!G79","v":0.65},{"$f":"+Kc!H79","v":0.65},{"$f":"+Kc!I79","v":0.7},{"$f":"+Kc!J79","v":0.75},{"$f":"+Kc!K79","v":0.75},{"$f":"+Kc!L79","v":0.82999999999999985},{"$f":"+Kc!M79","v":0.8},{"$f":"+Kc!N79","v":0.75},{"$f":"+Kc!O79","v":0.7}]
[null,"c","Uso Consultivo o Evaporación Real  ","(a x b)","mm/dia",{"$f":"+F76*F77","v":2.1060000000000003},1.8119999999999998,1.728,2.0085000000000002,1.9890000000000001,2.093,2.3250000000000002,2.6850000000000001,3.0294999999999992,2.7680000000000002,2.7225000000000001,2.1209999999999996]
[null,"d","Precipitación Efectiva","Dato","mm/dia",{"$f":"+F13","v":1.76},{"$f":"+G13","v":2.5642857142857141},2.1451612903225805,0.95666666666666667,0.11612903225806452,0.11,3.5483870967741936E-2,9.0322580645161285E-2,0.7433333333333334,1.8580645161290323,0.86,2.096774193548387]
[null,"e","Necesidades Netas del Cultivo  ","(c - d)","mm/dia",{"$f":"+IF((F78-F79)<0,0,(F78-F79))","v":0.34600000000000031},{"$f":"+IF((G78-G79)<0,0,(G78-G79))","v":0},{"$f":"+IF((H78-H79)<0,0,(H78-H79))","v":0},1.0518333333333336,1.8728709677419355,1.9829999999999999,2.2895161290322581,2.5946774193548388,2.2861666666666656,0.9099354838709679,1.8625000000000003,2.4225806451612542E-2,{"$f":"SUM(F80:Q80)","v":15.220725806451613}]
[null,"f","Eficiencia de Riego","Dato","%",0.9,{"$f":"+F81","v":0.9},0.9,0.9,0.9,0.9,0.9,0.9,0.9,0.9,0.9,0.9]
[null,"g","Necesidades Totales del Cultivo  ","(e / f)","mm/dia",{"$f":"+F80/F81","v":0.38444444444444476},{"$f":"+G80/G81","v":0},{"$f":"+H80/H81","v":0},1.168703703703704,2.080967741935484,2.2033333333333331,2.5439068100358422,2.8829749103942652,2.5401851851851838,1.0110394265232976,2.0694444444444446,2.6917562724013935E-2,{"$f":"SUM(F82:Q82)","v":16.91191756272401}]
[null,"h",null,"(e / f) x 10","m3-ha/dia",{"$f":"+F82*10","v":3.8444444444444477},0,0,11.68703703703704,20.809677419354841,22.033333333333331,25.439068100358423,28.829749103942653,25.401851851851838,10.110394265232976,20.694444444444446,0.26917562724013933,{"$f":"SUM(F83:Q83)","v":169.11917562724014}]
[null,"i","N° de Días del Mes","Dato",null,{"$f":"+F53","v":31},{"$f":"+G53","v":28},31,30,31,30,31,31,30,31,30,31]
[null,"j","Demanda Total Unitaria - Mensual","(h x i)","m3/ha/mes",{"$f":"+F83*F84","v":119.17777777777788},0,0,350.6111111111112,645.10000000000014,661,{"$f":"+L83*L84","v":788.61111111111109},893.72222222222229,762.05555555555509,313.42222222222227,620.83333333333337,8.3444444444443189,{"$f":"SUM(F85:Q85)","v":5162.8777777777768}]
[null,"k","Área de Riego","Dato","ha",{"$f":"+Kc!D67","v":5},{"$f":"+Kc!E67","v":5},{"$f":"+Kc!F67","v":5},{"$f":"+Kc!G67","v":5},{"$f":"+Kc!H67","v":5},{"$f":"+Kc!I67","v":5},{"$f":"+Kc!J67","v":5},{"$f":"+Kc!K67","v":5},{"$f":"+Kc!L67","v":5},{"$f":"+Kc!M67","v":5},{"$f":"+Kc!N67","v":5},{"$f":"+Kc!O67","v":5}]
[null,"l","Demanda Total - Mensual","(j x k)","m3/mes",{"$f":"+F85*F86","v":595.88888888888937},0,0,1753.0555555555561,3225.5000000000009,3305,3943.0555555555557,4468.6111111111113,3810.2777777777756,1567.1111111111113,3104.166666666667,41.722222222221596,{"$f":"SUM(F87:Q87)","v":25814.388888888883}]
[null,"m","Demanda Total - Diaria","(l / i)","m3/día",{"$f":"+F87/F84","v":19.222222222222239},0,0,58.435185185185205,104.04838709677422,110.16666666666667,127.19534050179212,144.14874551971326,127.00925925925918,50.551971326164882,103.47222222222223,1.3458781362006966,{"$f":"SUM(F88:Q88)","v":845.59587813620067}]
[]
[]
[null,"CÁLCULO DEL VOLUMEN DEMANDADO"]
[]
[null,"TIEMPO DE OPERACIÓN DIARIO",null,{"$f":"+D62","v":24},"HORAS"]
[]
[null,"N°","Descripción","Cálculo","Unidad","Meses",null,null,null,null,null,null,null,null,null,null,null,"Total"]
[null,null,null,null,null,"Ene","Feb","Mar","Abr","May","Jun","Jul","Ago","Sep","Oct","Nov","Dic"]
[null,"m","Módulo de Riego ",null,"l/s / ha ",{"$f":"+F82*(10000/($D$62*60*60))","v":4.4495884773662585E-2},{"$f":"+G82*(10000/($D$62*60*60))","v":0},0,0.1352666323731139,0.24085274790919953,0.25501543209876543,0.2944336585689632,0.33367765166600294,0.29400291495198888,0.11701845214390018,0.23951903292181073,3.1154586486127241E-3]
[null,"n","Demanda Total Diaria",null,"m3/día",{"$f":"+F97*F86*24*60*60/1000","v":19.222222222222236},0,0,58.435185185185205,104.04838709677418,110.16666666666667,127.19534050179207,144.14874551971326,127.00925925925921,50.551971326164875,103.47222222222224,1.3458781362006969,{"$f":"SUM(F98:Q98)","v":845.59587813620067}]
[null,"o","Demanda Total Mensual",null,"m3/mes",{"$f":"+F98*F84","v":595.88888888888926},0,0,1753.0555555555561,3225.4999999999995,3305,3943.0555555555543,4468.6111111111113,3810.2777777777765,1567.1111111111111,3104.1666666666674,41.722222222221603,{"$f":"SUM(F99:Q99)","v":25814.388888888887}]

{"sheet":"Oferta","index":5,"n_rows":17,"n_cols":19,"rows_kept":17,"cut":false,"hidden":true,"merged":[[6,3,7,3],[14,3,16,3],[2,3,2,18],[4,2,5,2],[4,3,5,3],[4,4,5,4],[4,5,5,5],[4,6,4,17],[4,18,5,18]]}
[]
[]
[null,null,null,"OFERTA HÍDRICA"]
[]
[null,null,"N°","Descripción","Cálculo","Unidad","Meses",null,null,null,null,null,null,null,null,null,null,null,"Total"]
[null,null,null,null,null,null,"Ene","Feb","Mar","Abr","May","Jun","Jul","Ago","Sep","Oct","Nov","Dic"]
[null,null,"a","Caudal Asignado por la OUA","Dato","l/s",15,15,15,15,15,15,15,15,15,15,15,15]
[null,null,"b",null,"Dato","m3/hr",{"$f":"+G7*3.6","v":54},{"$f":"+H7*3.6","v":54},54,54,54,54,54,54,54,54,54,54]
[null,null,"c","Tiempo de Riego por Dotación","Dato","hr/ha",6,6,6,4,4,4,4,4,4,4,6,6]
[null,null,"d","Área de Riego","Dato","ha",20,20,20,20,20,20,20,20,20,20,20,20]
[null,null,"e","Tiempo de Riego Total por Dotación ","(c x d)","hr",{"$f":"+G9*G10","v":120},{"$f":"+H9*H10","v":120},120,80,80,80,80,80,80,80,120,120]
[null,null,"f","N° de Días del Mes","Dato","días",31,28,31,30,31,30,31,31,30,31,30,31]
[null,null,"g","Frecuencia de cada Dotacion de Riego Parcelario","Dato","días",5,5,5,5,5,5,5,5,5,5,5,5]
[null,null,"h","Número de Riegos al Mes","(f / g)","N°",6,6,6,6,6,6,6,6,6,6,6,6,{"$f":"SUM(G14:R14)","v":72}]
[null,null,"i","Volumen Ofertado para el Proyecto","(b x e x h)","m3",{"$f":"+G8*G11*G14","v":38880},{"$f":"+H8*H11*H14","v":38880},38880,25920,25920,25920,25920,25920,25920,25920,38880,38880,{"$f":"SUM(G15:R15)","v":375840}]
[null,null,"j",null,"(i / d)","m3/ha/mes",{"$f":"+G15/G10","v":1944},{"$f":"+H15/H10","v":1944},1944,1296,1296,1296,1296,1296,1296,1296,1944,1944,{"$f":"SUM(G16:R16)","v":18792}]
[null,null,"k",null,"(j / f)","m3/ha/dia",{"$f":"+G16/G12","v":62.70967741935484},69.428571428571431,62.70967741935484,43.2,41.806451612903224,43.2,41.806451612903224,41.806451612903224,43.2,41.806451612903224,64.8,62.70967741935484,{"$f":"SUM(G17:R17)","v":619.18341013824886}]

{"sheet":"1. Identificación","index":6,"n_rows":183,"n_cols":10,"rows_kept":183,"cut":false,"hidden":false,"merged":[[2,1,2,9],[94,4,94,9],[116,1,116,9],[132,2,132,4],[132,5,132,9],[115,1,115,9],[126,5,126,9],[127,5,127,9],[120,1,120,9],[121,1,121,9],[125,2,125,4],[125,5,125,9],[99,2,100,2],[99,3,99,6],[97,4,97,9],[99,1,100,1],[131,2,131,4],[131,5,131,9],[162,8,162,9],[156,1,156,9],[166,2,166,9],[173,1,173,2],[161,8,161,9],[174,1,174,2],[173,8,173,9],[174,6,174,7],[174,8,174,9],[168,2,168,9],[172,1,172,2],[175,1,175,2],[176,1,176,2],[126,2,126,4],[127,2,127,4],[155,1,155,9],[133,2,133,4],[133,5,133,9],[175,6,175,7],[175,8,175,9],[176,6,176,7],[176,8,176,9],[172,6,172,7],[160,8,160,9],[167,2,167,9],[172,8,172,9],[173,6,173,7],[89,4,89,9],[90,4,90,9],[91,4,91,9],[92,4,92,9],[93,4,93,9],[76,8,76,9],[55,4,55,9],[62,4,62,9],[63,4,63,9],[64,4,64,9],[65,4,65,9],[36,4,36,9],[38,4,38,9],[47,4,47,9],[49,4,49,9],[51,4,51,9],[28,1,28,3],[28,4,28,9],[29,1,29,3],[29,4,29,9],[34,4,34,9],[1,1,1,9],[5,1,5,9],[26,1,26,3],[26,4,26,9],[27,1,27,3],[27,4,27,9],[3,1,3,9],[22,1,22,3],[21,1,21,3],[21,4,21,5],[22,4,22,5],[13,6,13,9],[15,6,15,9],[21,6,21,9],[22,6,22,9],[4,1,4,9],[182,1,182,2],[182,3,182,9],[180,1,180,2],[181,1,181,2],[181,3,181,9],[180,3,180,9]]}
[]
[null,"FICHA TÉCNICA ESPECÍFICA SIMPLIFICADA - MEJORAMIENTO DEL SISTEMA DE RIEGO PARCELARIO"]
[null,"(RIEGO TECNIFICADO)"]
[null,"Basado en la Directiva N° 002-2017-EF/63.01, aprobada por Resolución Directoral N° 002-2017-EF/63.01"]
[null,"Monto de Inversión a Precios de Mercado hasta 750 UIT"]
[null,"(La información registrada en esta ficha tiene carácter de Declaración Jurada)  "]
[]
[null,"I.  DATOS GENERALES "]
[]
[null,"CÓDIGO DEL PROYECTO",null,null,null,null,28021979]
[]
[null,"1. ARTICULACIÓN CON EL PROGRAMA MULTIANUAL DE INVERSIONES (PMI)"]
[]
[null,"1.1. Servicios Públicos con Brecha Identificada y Priorizada:   ",null,null,null,null,"Servicio de Riego Tecnificado"]
[]
[null,"1.2.  Indicador de Producto Asociado a la Brecha de Servicios:",null,null,null,null,"Porcentaje de Superficie Sin Tecnificación"]
[]
[null,"1.3. Contribución al Cierre de Brechas",null,null,null,null,20,"Hectáreas"]
[]
[null,"2. NOMBRE DEL PROYECTO DE INVERSIÓN"]
[]
[null,"NATURALEZA DE INTERVENCIÓN",null,null,"OBJETO",null,"LOCALIZACIÓN"]
[null,"MEJORAMIENTO DEL SERVICIO DE AGUA A NIVEL PARCELARIO",null,null," CON UN SISTEMA DE RIEGO TECNIFICADO ",null,"EN EL CENTRO POBLADO SAN LUIS – DISTRITO DE LOCROJA – PROVINCIA DE CHURCAMPA – REGIÓN HUANCAVELICA"]
[]
[null,"3. RESPONSABILIDAD FUNCIONAL "]
[]
[null,"FUNCIÓN",null,null,"AGROPECUARIA "]
[null,"DIVISIÓN FUNCIONAL",null,null,"RIEGO "]
[null,"GRUPO FUNCIONAL",null,null,"RIEGO TECNIFICADO"]
[null,"RESPONSABLE FUNCIONAL",null,null,"AGRICULTURA "]
[]
[]
[null,"4. UNIDAD FORMULADORA "]
[]
[null,"SECTOR",null,null,"GOBIERNOS LOCALES "]
[]
[null,"PLIEGO",null,null,"MUNICIPALIDAD DISTRITAL DE LOCROJA"]
[]
[null,"NOMBRE",null,null,"UNIDAD FORMULADORA DE DESARROLLO SOCIAL Y ECONÓMICO"]
[]
[null,"Persona Responsable de Formular la Ficha Técnica",null,null,"CARLOS NATIVIDAD TORERO",null,null,"PROFESION:","ING. AGRICOLA "]
[]
[null,"Persona Responsable de la Unidad Formuladora ",null,null,"LUIS LIVORA CANTELLA",null,null,"PROFESION:","ING. AGRÍCOLA"]
[]
[]
[null,"5. UNIDAD EJECUTORA DE INVERSIONES"]
[]
[null,"SECTOR",null,null,"GOBIERNOS LOCALES "]
[]
[null,"PLIEGO",null,null,"MUNICIPALIDAD DISTRITAL DE LOCROJA"]
[]
[null,"NOMBRE",null,null,"OFICINA DE ESTUDIOS Y PROYECTOS"]
[]
[null,"Persona Responsable de la Unidad Ejecutora de Inversiones",null,null,"JUAN PORTILLA CUETO",null,null,"PROFESION:","ING. AGRICOLA "]
[]
[null,"Organo Técnico Responsable",null,null,"GERENCIA DE INFRAESTRUCTURA Y OBRAS PÚBLICAS "]
[]
[]
[null,"6. UBICACIÓN, ACCESOS Y ADMINISTRACIÓN DEL AGUA"]
[]
[null,"6.1. Ubicación Política"]
[]
[null,"REGIÓN",null,null,"HUANCAVELICA "]
[null,"PROVINCIA",null,null,"CHURCAMPA"]
[null,"DISTRITO",null,null,"LOCROJA"]
[null,"LOCALIDAD ",null,null,"CENTRO POBLADO SAN LUIS"]
[]
[null,"6.2. Ubicación Geográfica"]
[]
[null,"COORDENADAS UTM (m) - WGS84",null,null,"ESTE ",657259,"NORTE ",9406136,"ZONA","18 - M"]
[null,"ALTURA (msnm)",null,null,2542]
[null,"REGIÓN NATURAL",null,null,"Sierra"]
[null,"UBIGEO",null,null,"090506"]
[]
[null,"6.3. Ubicación Hidrografica "]
[]
[null,"Vertiente","Atlántico","Cuenca","Mantaro","Subcuenca","Churcampa","Microcuenca","Churcampa"]
[]
[null,"6.4. Vias de Acceso al Proyecto"]
[]
[null,"Tramo\n(DE) ","Tramo \n(HASTA)","Distancia (km)","Tiempo (Horas)","Tipo de vía","Estado (*)"]
[null,"Lima ","Huancayo",300,7,"Asfaltado","B"]
[null,"Huancayo ","Churcampa",120,5,"Asfaltado - Afirmado","R"]
[null,"Churcampa ","San Luis ",50,1,"Afirmado ","R"]
[null,"San Luis ","Proyecto ",15,0.5,"Trocha carrozable","M"]
[null,"(*) Valores posibles para el Estado: (B) bueno, (R) regular, (M) malo"]
[]
[null,"6.5. Administración del Agua con Fines Agrícolas "]
[]
[null,"AUTORIDAD ADMINISTRATIVA DEL AGUA (AAA)",null,null,"HUANCAVELICA "]
[null,"ADMINISTRACIÓN LOCAL DEL AGUA (ALA)",null,null,"HUANCAVELICA "]
[null,"JUNTA DE USUARIOS ",null,null,"HUANCAVELICA "]
[null,"COMISIÓN DE USUARIOS",null,null,"7 PAGOS"]
[null,"COMITÉ DE USUARIOS ",null,null,"SAN LUIS"]
[null,"OTROS"]
[null,"ORGANIZACIÓN FORMALIZADA POR LA ANA",null,null,"SI","X","NO",{"$f":"IF(F96=\"X\", \"\", \"X\")","v":""}]
[]
[null,"6.6. Fuente Hídrica"]
[]
[null,"Fuente","Nombre","Ubicación geográfica UTM WGS84 "]
[null,null,null,"Este","Norte","Zona","Altitud \n(m.s.n.m)"]
[null,"Rio"]
[null,"Canal "]
[null,"Manantial (Puquial)"]
[null,"Quebrada","San Luis ",657278,9406140,"18 - M",2595]
[null,"Pozo"]
[null,"Otros: "]
[]
[]
[null,"II.  IDENTIFICACIÓN"]
[]
[null,"7. PROBLEMA CENTRAL, CAUSAS Y EFECTOS"]
[]
[null,"7.1. Descripción de la Situación Actual "]
[]
[null,"Descipción de la situación actual"]
[null,"Los beneficiarios del proyecto pertenecen al sector San Luis y al Comité de Riego del mismo nombre, que corresponde a la Comisión de Usuarios 7 Pagos, de la Junta de Usuarios Huancavelica. La fuente hídrica del sector es la quebrada San Luis, cuyo caudal en época de estiaje es de 15 l/s. \nEn la actualidad el riego parcelario es por surcos (gravedad), con una baja eficiencia de aplicación de agua de riego a nivel parcelario, lo que no ha posibilitado incrementar un desarrollo tecnológico que permita innovar nuevos cultivos con tendencia a la agro-exportación y de mayor rentabilidad. Actualmente los rendimientos de sus principales cultivos (pastos y alfalfa), inducen a los agricultores a dirigir una agricultura de subsistencia regida en una informalidad de mercado destino, comprador y precio refugio. \nEl proyecto contempla beneficiar a un total de 20 ha bajo riego, que vienen siendo conducidas por 12 familias dedicadas a la agricultura.    "]
[]
[null,"7.2. Problema Central"]
[]
[null,"Descripción del Problema Central"]
[null,"Baja productividad agrícola en el ámbito del Centro Poblado San Luis – Distrito de Locroja – Provincia de Churcampa – Huancavelica "]
[]
[null,"7.3. Causas que Generan el Problema"]
[]
[null,"Nº","Descripción de las Principales Causas",null,null,"Causas Indirectas"]
[null,"Causa 1","Ineficiencias en el uso del recurso hídrico ",null,null,"   i. Uso deficiente de técnicas de riego por gravedad (inundación, surco, etc.)\n   ii. Poco conocimiento de técnicas de riego  de mayor eficiencia"]
[null,"Causa 2","Inadecuada disponibilidad del recurso hídrico ",null,null,"   i. Insuficiente infraestructura hidráulica\n   ii. Inadecuada conservación de la infraestructura hidráulica\n   iii. Poca capacidad de gestión del recurso hídrico entre usuarios "]
[]
[null,"7.4. Efectos Generados por el Problema"]
[]
[null,"Nº","Efectos Directos ",null,null,"Efectos Indirectas"]
[null,"Efecto 1","Bajos ingresos de los productores agrarios",null,null,"   i. Pérdida de capital de trabajo\n   ii. Abandono de la actividad agrícola\n   iii. Migración"]
[null,"Efecto 2","Disminución del grado de integración al mercado"]
[]
[null,"8. POBLACIÓN AFECTADA Y POBLACIÓN OBJETIVO"]
[]
[null,"8.1. Población Afectada"]
[]
[null,"Tipo de Población",null,"Rural","Junta ",null,"Comisión ","7 PAGOS","Nivel mayor de la OUA"]
[null,"Número de Usuarios (Familias)",null,3560]
[null,"Número de Personas",null,{"$f":"+D141*5","v":17800}]
[null,"Fuente de Información",null,"Padrón de Usuarios"]
[]
[null,"8.2. Población Objetivo / Beneficiarios Directos"]
[]
[null,"Tipo de Población",null,"Rural","Comité ",null,"Bloque",null,"GGE (*)","SAN LUIS"]
[null,"Número de Usuarios (Familias)",null,12]
[null,"Número de Personas",null,{"$f":"+D148*5","v":60}]
[null,"Fuente de Información",null,"Padrón de Usuarios",null,null,null,null,null,"GRUPO DE GESTIÓN EMPRESARIAL (*)"]
[]
[null,"9. DEFINICIÓN DE LOS OBJETIVOS DEL PROYECTO"]
[]
[null,"9.1. Objetivo"]
[]
[null,"Descripción del Objetivo Central"]
[null,"Incremento de la productividad agrícola en el ámbito del Centro Poblado San Luis – Distrito de Locroja – Provincia Churcampa – Huancavelica "]
[]
[null,"9.2. Indicadores del Objetivo"]
[]
[null,"Principales indicadores de la situación actual",null,null,null,"Unidad de Medida","Valor Actual","Meta ","Fuente de Verificación"]
[null,"1.- Bajo rendimiento agrícola del cultivo de alfalfa ",null,null,null,"Kg/ha",10000,12500,"Información propia"]
[null,"2.- Baja eficiencia de aplicación de agua de riego a nivel parcelario",null,null,null,"%",30,75,"Información propia"]
[]
[null,"9.3. Medios Fundamentales"]
[]
[null,"N°","Descripción Medios Fundamentales"]
[null,1,"Utilización de técnicas de riego tecnificado"]
[null,2,"Mayor conocimiento de técnicas de riego más eficientes"]
[]
[null,"10. ANÁLISIS DE INVOLUCRADOS"]
[]
[null,"Involucrado",null,"Ámbito del participante (Nacional, Regional, Local, Otros)","Entidad a la que pertenece","Posición (Cooperante, Beneficiario, Oponente, Perjudicado)","Intereses",null,"Contribución"]
[null,"UF Municipalidad Distrital de Locroja",null,"Local ","MDL","Cooperante ","Mejorar los niveles de producción agropecuaria, propiciando su desarrollo competitivo y sostenible",null,"Financiamiento de las obras comunes y parte de las obras parcelarias"]
[null,"Grupo de Gestión Empresarial San Luis ",null,"Local ","JU Huancavelica","Beneficiario","Mejorar los niveles de productividad agropecuaria",null,"Financiamiento de parte de las obras parcelarias"]
[null,"Autoridad Local de Agua (ALA) HUANCAVELICA",null,"Local ","ANA","Cooperante ","Formalización del uso de los recursos hídricos ",null,"Brindar facilidades para la obtención de la licencia de uso de agua"]
[null,"Programa Subsectorial de Irrigaciones (PSI)",null,"Nacional","MINAGRI","Cooperante ","Fomentar el uso eficiente del recurso hídrico",null,"Asistencia técnica "]
[]
[null,"11. PLANTEAMIENTO DE LAS ALTERNATIVAS DE SOLUCIÓN AL PROBLEMA"]
[]
[null,"Alternativas más Frecuentes",null,"Descripción"]
[null,"Alternativa 1",null,"Presurizado: Aspersión Semifijo y Goteo"]
[null,"Alternativa 2",null,"No hay Alternativa 2"]

{"sheet":"2. Balance Hídrico","index":7,"n_rows":155,"n_cols":9,"rows_kept":155,"cut":false,"hidden":false,"merged":[[1,1,1,9],[2,1,2,9],[5,15,5,17],[28,5,28,6],[28,8,28,9],[3,1,3,9],[17,6,17,9],[12,1,12,9],[154,1,154,9],[50,3,50,5],[76,3,76,5],[105,3,105,5],[58,1,58,3],[59,1,59,3],[74,1,74,6],[80,1,80,3],[80,8,80,9],[81,1,81,3],[81,4,81,5],[103,1,103,6],[82,1,82,3],[150,1,150,2],[56,1,56,3],[56,8,56,9],[153,1,153,2],[148,1,148,9],[151,1,151,9],[22,1,22,9],[29,4,29,9],[33,1,33,3],[33,8,33,9],[34,1,34,3],[48,1,48,4],[57,1,57,3],[57,4,57,5],[83,1,83,3],[84,1,84,3],[85,1,85,3],[85,4,85,5],[86,1,86,3]]}
[]
[null,"FICHA TÉCNICA ESPECÍFICA SIMPLIFICADA - MEJORAMIENTO DEL SISTEMA DE RIEGO PARCELARIO"]
[null,"Basado en la Directiva N° 002-2017-EF/63.01, aprobada por Resolución Directoral N° 002-2017-EF/63.01"]
[null,"(La información registrada en esta ficha tiene carácter de Declaración Jurada)  "]
[]
[null,"III.  FORMULACION Y EVALUACIÓN"]
[]
[null,"12. HORIZONTE DE EVALUACIÓN"]
[]
[null,"Número de Años del Horizonte de Evaluación (AÑOS)",null,null,null,null,10]
[]
[null,"Sustento técnico del horizonte de evaluación elegido"]
[null,"El horizonte de evaluación del proyecto de riego tecnificado se ha determinado en base a los siguientes criterios: a) La obsolescencia tecnológica esperada en el sector que se va a intervenir, y b) El periodo de vida útil de los activos principales."]
[]
[null,"Si el horizonte de evaluación del proyecto es mayor a 10 años, deberá sustentar el tiempo adicional:"]
[]
[null,"Periodo de productividad del cultivo (frutales de rendimiento tardío)"]
[null,"Otros. Especificar "]
[]
[null,"13. ESTUDIO DE MERCADO DEL SERVICIO PÚBLICO"]
[]
[null,"Definición del servicio público o de la cartera de servicios"]
[null,"El servicio es la Tecnificación del Riego, que es el conjunto de componentes y tecnologías aplicadas para el riego de cultivos que permiten optimizar la eficiencia en el uso de los recursos hídricos, y lograr el incremento de la productividad agrícola (Ley N° 28585 y su Reglamento)."]
[]
[null,"14. ESTIMACIÓN DE LA OFERTA HÍDRICA "]
[]
[null,"14.1. Acreditación Hídrica"]
[]
[null,"DOCUMENTO DE ACREDITACIÓN HÍDRICA ",null,null,"LICENCIA ","NO",null,"ACREDITACIÓN"]
[null,"DOCUMENTO DE LA ANA QUE SUSTENTA LA ACREDITACIÓN",null,null,"Resolución Administrativa N° 007-2015-ALA-HUANCAVELICA"]
[]
[null,"14.2. Cálculo de la Oferta Hídrica "]
[]
[null,"CAUDAL AUTORIZADO DE LA FUENTE ",null,null,15,"l/s"]
[]
[null,"MES PROMEDIO","CAUDAL \n(l/s)","FRECUENCIA DE DOTACIÓN\n(cada cuántos días)","TIEMPO DE RIEGO\n(horas según área del PIP) (*)","VOLUMEN DISPONIBLE \n(m3)"]
[null,{"$f":"+B63","v":"ENE"},{"$f":"+Oferta!G7","v":15},{"$f":"+Oferta!G13","v":5},{"$f":"+Oferta!G11","v":120},{"$f":"+C37*3.6*ROUND(I37/D37,0)*E37","v":38880},null,null,31]
[null,{"$f":"+B64","v":"FEB"},{"$f":"+Oferta!H7","v":15},{"$f":"+Oferta!H13","v":5},{"$f":"+Oferta!H11","v":120},{"$f":"+C38*3.6*ROUND(I38/D38,0)*E38","v":38880},null,null,28]
[null,"MAR",{"$f":"+Oferta!I7","v":15},{"$f":"+Oferta!I13","v":5},{"$f":"+Oferta!I11","v":120},38880,null,null,31]
[null,"ABR",{"$f":"+Oferta!J7","v":15},{"$f":"+Oferta!J13","v":5},{"$f":"+Oferta!J11","v":80},25920,null,null,30]
[null,"MAY",{"$f":"+Oferta!K7","v":15},{"$f":"+Oferta!K13","v":5},{"$f":"+Oferta!K11","v":80},25920,null,null,31]
[null,"JUN",{"$f":"+Oferta!L7","v":15},{"$f":"+Oferta!L13","v":5},{"$f":"+Oferta!L11","v":80},25920,null,null,30]
[null,"JUL",{"$f":"+Oferta!M7","v":15},{"$f":"+Oferta!M13","v":5},{"$f":"+Oferta!M11","v":80},25920,null,null,31]
[null,"AGO",{"$f":"+Oferta!N7","v":15},{"$f":"+Oferta!N13","v":5},{"$f":"+Oferta!N11","v":80},25920,null,null,31]
[null,"SEP",{"$f":"+Oferta!O7","v":15},{"$f":"+Oferta!O13","v":5},{"$f":"+Oferta!O11","v":80},25920,null,null,30]
[null,"OCT",{"$f":"+Oferta!P7","v":15},{"$f":"+Oferta!P13","v":5},{"$f":"+Oferta!P11","v":80},25920,null,null,31]
[null,"NOV",{"$f":"+Oferta!Q7","v":15},{"$f":"+Oferta!Q13","v":5},{"$f":"+Oferta!Q11","v":120},38880,null,null,30]
[null,"DIC",{"$f":"+Oferta!R7","v":15},{"$f":"+Oferta!R13","v":5},{"$f":"+Oferta!R11","v":120},38880,null,null,31]
[null,"VOLUMEN TOTAL ",null,null,null,{"$f":"SUM(F37:F48)","v":375840}]
[null,"(*) Medida en la punto de toma del PIP"]
[null,"FUENTE DE INFORMACIÓN:",null,"ALA Huancavelica - JU Huancavelica "]
[]
[null,"15. ESTIMACIÓN DE LA DEMANDA HÍDRICA "]
[]
[null,"15.1. Cálculo de la Demanda Hídrica - Sin Proyecto "]
[]
[null,"ÁREA A BENEFICIAR ",null,null,{"$f":"+'1. Identificación'!G18","v":20},"ha"]
[null,"MÉTODO DE RIEGO A NIVEL PARCELARIO",null,null,"GRAVEDAD"]
[null,"EFICIENCIA DE APLICACIÓN",null,null,0.3]
[]
[null,"MÉTODO DE RIEGO","GRAVEDAD","GRAVEDAD","GRAVEDAD",null,"ÁREA A IRRIGAR ","VOLUMEN DEMANDADO"]
[null,"CEDULA ","ALFALFA","MAIZ","PAPA",null,"ha","m3"]
[null,"ENE",15,null,5,null,{"$f":"+C63+D63+E63+F63","v":20},{"$f":"+Demanda!F21","v":32260.666666666661}]
[null,"FEB",15,null,5,null,{"$f":"+C64+D64+E64+F64","v":20},{"$f":"+Demanda!G21","v":5688.0000000000009}]
[null,"MAR",15,null,null,null,15,{"$f":"+Demanda!H21","v":11390}]
[null,"ABR",15,5,null,null,20,{"$f":"+Demanda!I21","v":34941.666666666672}]
[null,"MAY",15,5,null,null,20,{"$f":"+Demanda!J21","v":52935.000000000007}]
[null,"JUN",15,5,null,null,{"$f":"+C68+D68+E68+F68","v":20},{"$f":"+Demanda!K21","v":59842.500000000015}]
[null,"JUL",15,5,null,null,20,{"$f":"+Demanda!L21","v":65735.833333333343}]
[null,"AGO",15,5,null,null,20,{"$f":"+Demanda!M21","v":67495.833333333343}]
[null,"SEP",15,null,null,null,15,{"$f":"+Demanda!N21","v":43600}]
[null,"OCT",15,null,5,null,20,{"$f":"+Demanda!O21","v":22380.666666666661}]
[null,"NOV",15,null,5,null,20,{"$f":"+Demanda!P21","v":50862.5}]
[null,"DIC",15,null,5,null,20,{"$f":"+Demanda!Q21","v":21634.916666666672}]
[null,"VOLUMEN TOTAL ",null,null,null,null,null,{"$f":"SUM(H63:H74)","v":468767.58333333349}]
[]
[null,"FUENTE DE INFORMACIÓN:",null,"FAO (Eto, Kc, Precipitación)"]
[]
[null,"15.2. Cálculo de la Demanda Hídrica - Con Proyecto "]
[]
[null,"ÁREA A BENEFICIAR ",null,null,15,"ha"]
[null,"MÉTODO DE RIEGO A NIVEL PARCELARIO",null,null,"ASPERSIÓN"]
[null,"EFICIENCIA DE APLICACIÓN",null,null,75,"%"]
[]
[null,"ÁREA A BENEFICIAR ",null,null,5,"ha"]
[null,"MÉTODO DE RIEGO A NIVEL PARCELARIO",null,null,"GOTEO"]
[null,"EFICIENCIA DE APLICACIÓN",null,null,90,"%"]
[]
[]
[null,"MÉTODO DE RIEGO","ASPERSIÓN","ASPERSIÓN","ASPERSIÓN","GOTEO","ÁREA A IRRIGAR ","VOLUMEN DEMANDADO"]
[null,"CEDULA ","ALFALFA","HABA","QUINUA","PALTO","ha","m3"]
[null,{"$f":"+B63","v":"ENE"},10,null,5,5,{"$f":"+C92+D92+E92+F92","v":20},{"$f":"+Balance!F26","v":10106.688888888888}]
[null,"FEB",10,null,5,5,{"$f":"+C93+D93+E93+F93","v":20},{"$f":"+Balance!G26","v":860.80000000000109}]
[null,"MAR",10,null,null,5,15,{"$f":"+Balance!H26","v":3037.3333333333335}]
[null,"ABR",10,5,null,5,20,{"$f":"+Balance!I26","v":12390.055555555555}]
[null,"MAY",10,5,null,5,20,{"$f":"+Balance!J26","v":19580.3}]
[null,"JUN",10,5,null,5,20,{"$f":"+Balance!K26","v":19090}]
[null,"JUL",10,5,null,5,20,{"$f":"+Balance!L26","v":21661.722222222223}]
[null,"AGO",10,5,null,5,20,{"$f":"+Balance!M26","v":24846.837777777779}]
[null,"SEP",10,null,null,5,15,{"$f":"+Balance!N26","v":19425.277777777774}]
[null,"OCT",10,null,5,5,20,{"$f":"+Balance!O26","v":8188.4444444444443}]
[null,"NOV",10,null,5,5,20,{"$f":"+Balance!P26","v":17546.166666666668}]
[null,"DIC",10,null,5,5,20,{"$f":"+Balance!Q26","v":5827.7222222222208}]
[null,"VOLUMEN TOTAL ",null,null,null,null,null,{"$f":"SUM(H92:H103)","v":162561.34888888887}]
[]
[null,"FUENTE DE INFORMACIÓN:",null,"FAO (Eto, Kc, Precipitación)"]
[]
[null,"16. ESTIMACIÓN DEL BALANCE HÍDRICO "]
[]
[null,"16.1. Cálculo del Balance Hídrico - Sin Proyecto "]
[]
[null,"MES ","Balance Hídrico Sin Proyecto \n(m3)"]
[null,{"$f":"+B92","v":"ENE"},{"$f":"+F37-H63","v":6619.3333333333394}]
[null,"FEB",33192]
[null,"MAR",27490]
[null,"ABR",-9021.6666666666715]
[null,"MAY",-27015.000000000007]
[null,"JUN",-33922.500000000015]
[null,"JUL",-39815.833333333343]
[null,"AGO",-41575.833333333343]
[null,"SEP",-17680]
[null,"OCT",3539.3333333333394]
[null,"NOV",-11982.5]
[null,"DIC",17245.083333333328]
[null,"VOLUMEN TOTAL ",{"$f":"SUM(C113:C124)","v":-92927.583333333358}]
[]
[]
[null,"16.2. Cálculo del Balance Hídrico - Con Proyecto "]
[]
[null,"MES ","Balance Hídrico Con Proyecto \n(m3)"]
[null,{"$f":"+B113","v":"ENE"},{"$f":"+F37-H92","v":28773.311111111114}]
[null,{"$f":"+B114","v":"FEB"},38019.199999999997]
[null,"MAR",35842.666666666664]
[null,"ABR",13529.944444444445]
[null,"MAY",6339.7000000000007]
[null,"JUN",6830]
[null,"JUL",4258.2777777777774]
[null,"AGO",1073.1622222222213]
[null,"SEP",6494.7222222222263]
[null,"OCT",17731.555555555555]
[null,"NOV",21333.833333333332]
[null,"DIC",33052.277777777781]
[null,"VOLUMEN TOTAL ",{"$f":"SUM(C131:C142)","v":213278.6511111111}]
[]
[]
[null,"17. ANALISIS TECNICO"]
[]
[null,"17.1 Análisis de tamaño"]
[null,"El proyecto abarca un área de 20.0 ha, de acuerdo con la disponibilidad de área bajo riego de los beneficiarios directos del proyecto, y considerando la acreditación hídrica emitida por la ALA Huancavelica."]
[]
[null,"17.2 Análisis de localización"]
[null,"Los beneficiarios forman parte de la JU Huancavelica, que conforma la CU 7 Pagos, y el Comité de Ususarios San Luis, los mismos que cumplen con los requisitos establecidos en la Ley N° 28585 y su Reglamento, para acceder a los incentivos de riego tecnificado promovidos por el Estado."]
[]
[null,"17.3 Análisis de tecnología"]
[null,"Se ha optado por los sistemas de riego tecnificado por aspersión y goteo, de acuerdo con la cédula de cultivo propuesta, y las condiciones topográficas "]

{"sheet":"3. Costos","index":8,"n_rows":135,"n_cols":10,"rows_kept":135,"cut":false,"hidden":false,"merged":[[53,1,53,4],[54,1,54,4],[55,1,55,9],[17,4,17,6],[17,7,18,7],[17,8,17,9],[20,1,37,1],[38,1,39,1],[42,2,42,7],[50,1,50,9],[49,1,49,4],[51,1,51,4],[52,1,52,4],[19,4,19,6],[19,8,19,9],[56,1,56,4],[78,3,78,7],[66,1,66,5],[67,1,67,5],[64,1,64,5],[61,1,61,5],[72,1,72,5],[73,1,73,5],[95,7,96,7],[95,8,96,8],[95,9,96,9],[85,9,86,9],[85,8,86,8],[85,7,86,7],[97,1,97,2],[85,3,85,6],[101,1,101,2],[99,1,99,2],[98,1,98,2],[95,1,96,2],[95,3,95,6],[120,5,120,6],[115,5,115,6],[116,5,116,6],[62,1,62,5],[63,1,63,5],[88,1,88,2],[89,1,89,2],[90,1,90,2],[65,1,65,5],[87,1,87,2],[85,1,86,2],[119,5,119,6],[117,5,117,6],[118,5,118,6],[68,1,68,5],[100,1,100,2],[1,1,1,9],[2,1,2,9],[9,2,9,9],[10,2,10,9],[3,1,3,9]]}
[]
[null,"FICHA TÉCNICA ESPECÍFICA SIMPLIFICADA - MEJORAMIENTO DEL SISTEMA DE RIEGO PARCELARIO"]
[null,"Basado en la Directiva N° 002-2017-EF/63.01, aprobada por Resolución Directoral N° 002-2017-EF/63.01"]
[null,"(La información registrada en esta ficha tiene carácter de Declaración Jurada)  "]
[]
[null,"III.  FORMULACION Y EVALUACIÓN"]
[]
[null,"18. DESCRIPCION DE LA ALTERNATIVA DE SOLUCIÓN AL PROBLEMA"]
[]
[null,"Tipo de Sistema de Riego ","Descripción"]
[null,{"$f":"+'1. Identificación'!D182","v":"Presurizado: Aspersión Semifijo y Goteo"},"El recurso hídrico se captará en la Quebrada San Luis (Toma Huambasi), con un caudal de 15 l/s, para lo cual se mejorará la estructura existente con concreto. A partir de este punto se construirá un canal de aducción de concreto hasta un desarenador, antes de ingresar a un reservorio revestido de geomembrana de HDPE (e=1.0 mm). Desde este punto se instalará un sistema de conducción con tubería de HDPE, y para la distribución se utilizará tubería de PVC. Se irrigarán un total de 20 ha mediante el sistema de riego por aspersión semifijo (15 ha) y goteo (5 ha). El proyecto contempla la capacitación en operación y mantenimiento del sistema de riego instalado, y la asistencia técnica para el manejo del cultivo con un sistema de riego tecnificado."]
[]
[]
[null,"19. ESTIMACIÓN DE LOS COSTOS DE INVERSIÓN, METAS FÍSICAS Y PLAZOS DEL PROYECTO"]
[]
[null,"19.1. Estimación del Costo de Inversión del Proyecto"]
[]
[null,null,null,null,"UNIDAD DE PRODUCCIÓN",null,null,"COSTO A PRECIOS DE MERCADO\n(S/)","CAPACIDAD DE PRODUCCIÓN"]
[null,"DESCRIPCIÓN DEL PRODUCTO","DESCRIPCIÓN DE LAS ACCIONES","TIPO DE ÍTEM","UNIDAD DE MEDIDA","META","COSTO UNITARIO\n(S/)",null,"UNIDAD DE MEDIDA","META"]
[null,"Estudios Definitivos","Expediente Técnico","Estudios ",null,null,null,25000]
[null,"Instalación de Equipos de Riego","Obras Comunes"]
[null,null,"Componentes de Captación","Toma en quebrada o río","und",1,3250,{"$f":"+F22*G22","v":3250},"l/s",15]
[null,null,"Componentes de Aducción ","Canal de concreto","m",50,65,3250,"l/s",15]
[null,null,"Obras de Sedimentación","Concreto","und",1,11000,11000,"l/s",15]
[null,null,"Componentes de Almacenamiento o Cámara de Carga","Revestimiento con geomenbrana","und",1,65000,65000,"m3 ",850]
[null,null,"Componentes de Impulsión \n(unidad de bombeo) (*)","No comtempla","und",null,null,0,"l/s"]
[null,null,"Componente de Fertirrigación","No comtempla","und",null,null,0,"l/hr"]
[null,null,"Componentes de Filtrado \n(indicar capacidad de filtrado en m3/hr)","No comtempla","und",null,null,0,"m3/hr"]
[null,null,"Componentes de Conducción ","Tuberia de HDPE","m",580,100,58000,"l/s",8]
[null,null,"Componentes de Distribución ","Tuberia de PVC","m",670,50,33500,"l/s",8]
[null,null,"Caseta de Control","No comtempla","und",null,null,0]
[null,null,"Componentes de Automatización","No comtempla","und",null,null,0]
[null,null,"Equipos de Control y Protección","Varios","gbl",1,21500,21500]
[null,null,"Obras de Arte ","Varios","gbl",1,20000,20000]
[null,null,"Arcos de Riego ","Válvulas hidráulicas ","gbl",1,17500,17500]
[null,null,"Otros","Otros equipos","gbl",null,null,0]
[null,null,"Obras Parcelarias"]
[null,null,"Obras a Nivel Parcelario","Riego por goteo","ha",{"$f":"+'2. Balance Hídrico'!E57","v":20},7500,{"$f":"+F38*G38","v":150000}]
[null,"Capacitación y Asistencia Técnica ","Capacitación en Operación y Mantenimiento del Sistema de Riego","Módulo de capacitación","gbl",1,{"$f":"+'Selección de Datos'!C2*'2. Balance Hídrico'!E57","v":4000},{"$f":"+F39*G39","v":4000}]
[null,null,"Asistencia Técnica en el Manejo de Cultivos con Riego Tecnificado","Módulo de capacitación","gbl",1,15000,{"$f":"+F40*G40","v":15000}]
[null,null,null,null,null,null,"SUBTOTAL",{"$f":"SUM(H20:H40)","v":427000}]
[]
[null,"FUENTE DE INFORMACIÓN:","Cotizaciones de proveedores de equipos de riego y de servicios"]
[]
[null,"(*) Potencia acumulada (Hp)"]
[]
[]
[null,"19.2. Resumen del Costo de Inversión del Proyecto y Plazos Referenciales de Ejecución"]
[]
[null,"DESCRIPCIÓN ",null,null,null,"PARCIAL\n(S/)","OBRAS COMUNES \n(S/)","OBRAS PARCELARIAS\n(S/)","FECHA DE INICIO","FECHA DE TÉRMINO"]
[]
[null,"Componente 1: Costos del Estudio Definitivo (Expediente Técnico, CIRA, Certificación Ambiental, otros)",null,null,null,{"$f":"+H20","v":25000},{"$f":"+F52","v":25000},null,"2017-07-01",{"$f":"+I52+60","v":"2017-08-30"}]
[null,"Componente 2: Estimación de los Costos de Instalación de Equipos de Riego",null,null,null,{"$f":"+G53+H53","v":383000},{"$f":"+SUM(H22:H36)","v":233000},{"$f":"+H38","v":150000},{"$f":"+J52+45","v":"2017-10-14"},{"$f":"+I53+90","v":"2018-01-12"}]
[null,"Componente 3: Costos de Capacitación en Operación y Mantenimiento del Sistema de Riego",null,null,null,{"$f":"+G39","v":4000},{"$f":"+F54","v":4000},null,{"$f":"+I53","v":"2017-10-14"},{"$f":"+J53","v":"2018-01-12"}]
[null,"Componente 4: Costos de Asistencia Técnica en el Manejo de Cultivos con Riego Tecnificado",null,null,null,{"$f":"+G40","v":15000},{"$f":"+F55","v":15000},null,{"$f":"+J54","v":"2018-01-12"},{"$f":"+I55+180","v":"2018-07-11"}]
[]
[null,"COSTO TOTAL DE INVERSIÓN DEL PROYECTO ",null,null,null,{"$f":"+F52+F53+F54+F55","v":427000},{"$f":"+G52+G53+G54+G55","v":277000},150000]
[]
[]
[null,"19.3. Estimación de Indicadores de los Costos de Inversión del Proyecto"]
[]
[null,"DESCRIPCIÓN",null,null,null,null,"COSTO\n(S/)","PORCENTAJE\n(%)"]
[null,"COSTO DE INVERSION TOTAL (S/ )",null,null,null,null,{"$f":"+F57","v":427000},{"$f":"+G63/G63","v":1}]
[null,"APORTE REFERENCIAL DEL ESTADO (S/ )",null,null,null,null,{"$f":"+G57+(0.8*H57)","v":397000},{"$f":"+G64/G63","v":0.92974238875878223}]
[null,"APORTE REFERENCIAL DE LOS BENEFICIARIOS (S/ )",null,null,null,null,{"$f":"+H57*0.2","v":30000},{"$f":"+G65/G63","v":7.0257611241217793E-2}]
[]
[null,"COSTO DE INVERSION POR HECTÁREA BENEFICIADA (Soles/ha)",null,null,null,null,{"$f":"+G63/'2. Balance Hídrico'!E57","v":21350},{"$f":"+G67/G67","v":1}]
[null,"APORTE REFERENCIAL DEL ESTADO (Soles/ha)",null,null,null,null,{"$f":"+G67*H64","v":19850},{"$f":"+G68/G67","v":0.92974238875878223}]
[null,"APORTE REFERENCIAL DE LOS BENEFICIARIOS (Soles/ha)",null,null,null,null,{"$f":"+H65*G67","v":1500},{"$f":"+G69/G67","v":7.0257611241217793E-2}]
[]
[null,"19.4. Costo de Inversión por Beneficiario Directo"]
[]
[null,"DESCRIPCIÓN",null,null,null,null,"COSTO\n(S/)"]
[null,"COSTO DE INVERSIÓN POR BENEFICIARIO DIRECTO  (S/ )  (*)",null,null,null,null,{"$f":"+G63/'1. Identificación'!D148","v":35583.333333333336}]
[null,"(*) Este valor se puede considerar como el ratio Costo / Eficiencia, debido a que, por lo general, el 100% de la inversión se realiza en el Año 0 (cero)."]
[]
[null,"19.5. Modalidad de Ejecución"]
[]
[null,"MODALIDAD DE EJECUCIÓN ",null,"ADMINISTRACIÓN INDIRECTA - LEY N° 28585 PRT"]
[]
[]
[null,"20. CRONOGRAMA DE EJECUCIÓN"]
[]
[null,"20.1 Cronograma de Ejecución Física  (% de avance)"]
[]
[null,"Principales Rubros",null,"AÑO 1",null,null,null,"AÑO 2","AÑO 3","TOTAL"]
[null,null,null,"mes 1-3","mes 4-6","mes 7-9","mes 10-12"]
[null,"Componente 1: Estudio Definitivo",null,1,null,null,null,null,null,{"$f":"SUM(D88:I88)","v":1}]
[null,"Componente 2: Riego Tecnificado",null,null,0.9,0.1,null,null,null,{"$f":"SUM(D89:I89)","v":1}]
[null,"Componente 3: Capacitación en O&M",null,null,0.9,0.1,null,null,null,{"$f":"SUM(D90:I90)","v":1}]
[null,"Componente 4: Asistencia Técnica ",null,null,null,0.25,0.25,0.5,null,{"$f":"SUM(D91:I91)","v":1}]
[]
[]
[null,"20.2 Cronograma de Inversión según Componentes  (Soles)"]
[]
[null,"Principales Rubros",null,"AÑO 1",null,null,null,"AÑO 2","AÑO 3","TOTAL"]
[null,null,null,"mes 1-3","mes 4-6","mes 7-9","mes 10-12"]
[null,{"$f":"+B88","v":"Componente 1: Estudio Definitivo"},null,{"$f":"+D88*$F$52","v":25000},0,0,0,0,0,{"$f":"SUM(D98:I98)","v":25000}]
[null,{"$f":"+B89","v":"Componente 2: Riego Tecnificado"},null,{"$f":"+$F$53*D89","v":0},344700,38300,0,0,0,{"$f":"SUM(D99:I99)","v":383000}]
[null,"Componente 3: Capacitación en O&M",null,{"$f":"+$F$54*D90","v":0},3600,400,0,0,0,{"$f":"SUM(D100:I100)","v":4000}]
[null,"Componente 4: Asistencia Técnica ",null,{"$f":"+$F$55*D91","v":0},0,3750,3750,7500,0,{"$f":"SUM(D101:I101)","v":15000}]
[null,"SUBTOTAL",null,{"$f":"+SUM(D98:D101)","v":25000},{"$f":"+SUM(E98:E101)","v":348300},42450,3750,7500,0,427000]
[]
[]
[null,"21. ESTIMACIÓN DE LOS COSTOS DE REPOSICIÓN"]
[]
[null,"COSTO REFERENCIAL ANUAL (S/)",null,null,null,null,{"$f":"+H38*0.3","v":45000}]
[]
[null,"AÑO DE APLICACIÓN DEL COSTO DE REPOSICIÓN",null,null,null,null,5]
[]
[]
[null,"22. ESTIMACIÓN DE LOS COSTOS DE OPERACIÓN Y MANTENIMIENTO DEL SISTEMA DE RIEGO"]
[]
[null,"COSTO REFERENCIAL SIN PROYECTO (ANUAL)",null,null,null,"COSTO REFERENCIAL CON PROYECTO (ANUAL)"]
[]
[null,"INSUMO ","COSTO (S/)",null,null,"INSUMO ",null,"COSTO (S/)"]
[null,"Mano de Obra ",8500,null,null,"Mano de Obra ",null,15500]
[null,"Materiales ",2500,null,null,"Materiales ",null,3600]
[null,"Herramientas ",1800,null,null,"Herramientas ",null,1200]
[null,"Gastos para Impulsión (*)",null,null,null,"Gastos para Impulsión (*)"]
[null,"SUBTOTAL (S/)",{"$f":"+SUM(C117:C120)","v":12800},null,null,"SUBTOTAL (S/)",null,{"$f":"+SUM(H117:H120)","v":20300}]
[]
[null,"(*) DATOS PARA GASTOS DE IMPULSIÓN (SIN PROYECTO)",null,null,null,"(*) DATOS PARA GASTOS DE IMPULSIÓN (CON PROYECTO)"]
[]
[null,"Potencia en Hp",null,null,null,"Potencia en Hp",null,null,{"$f":"+C45","v":0}]
[null,"Potencia en Kw",null,null,null,"Potencia en Kw",null,null,{"$f":"+C45*'Selección de Datos'!C103","v":0}]
[null,"Tiempo de operación diario promerio (hr)",null,null,null,"Tiempo de operación diario promerio (hr)"]
[null,"Número de días de operación promerio (días)",null,null,null,"Número de días de operación promerio (días)"]
[]
[null,"Motor eléctrico:",null,null,null,"Motor eléctrico:"]
[null,"Tarfia de consumo eléctrico (Soles/Kw x hr)",null,null,null,"Tarfia de consumo eléctrico (Soles/Kw x hr)"]
[]
[null,"Motor a combustión:",null,null,null,"Motor a combustión:"]
[null,"Consumo promedio de combustible (gal/Hp x hr)",null,null,null,"Consumo promedio de combustible (gal/Hp x hr)"]
[null,"Costo del combustible (Soles/gal)",null,null,null,"Costo del combustible (Soles/gal)"]

{"sheet":"4. Beneficios","index":9,"n_rows":105,"n_cols":22,"rows_kept":105,"cut":false,"hidden":false,"merged":[[1,1,1,9],[3,1,3,9],[5,14,5,16],[2,1,2,9]]}
[]
[null,"FICHA TÉCNICA ESPECÍFICA SIMPLIFICADA - MEJORAMIENTO DEL SISTEMA DE RIEGO PARCELARIO"]
[null,"Basado en la Directiva N° 002-2017-EF/63.01, aprobada por Resolución Directoral N° 002-2017-EF/63.01"]
[null,"(La información registrada en esta ficha tiene carácter de Declaración Jurada)  "]
[]
[null,"III.  FORMULACION Y EVALUACION"]
[]
[null,"23. ESTIMACIÓN DE LOS BENEFICIOS DEL PROYECTO"]
[]
[null,"23.1. Cálculo del Valor Neto de la Producción - Sin Proyecto "]
[]
[null,"CULTIVOS ESTACIONALES "]
[]
[null,"Cultivo",{"$f":"+'2. Balance Hídrico'!D62","v":"MAIZ"},{"$f":"+'2. Balance Hídrico'!E62","v":"PAPA"}]
[null,"Área de Cédula (ha)",{"$f":"+'2. Balance Hídrico'!D66","v":5},{"$f":"+'2. Balance Hídrico'!E64","v":5}]
[null,"Rendimiento (Kg/ha)",5000,10000]
[null,"Precio en Chacra (Soles/Kg)",0.8,0.6]
[null,"VBP (S/ )",{"$f":"+C16*C15*C17","v":20000},{"$f":"+D16*D15*D17","v":30000},{"$f":"+E16*E15*E17","v":0},{"$f":"+F16*F15*F17","v":0},{"$f":"+G16*G15*G17","v":0}]
[]
[null,"Costo de Producción Unitario (Soles/ha)",3000,5000]
[null,"VNP (S/ )",{"$f":"+C18-(C15*C20)","v":5000},{"$f":"+D18-(D15*D20)","v":5000},{"$f":"+E18-(E15*E20)","v":0},{"$f":"+F18-(F15*F20)","v":0},{"$f":"+G18-(G15*G20)","v":0}]
[]
[null,"CULTIVOS PERMANENTES"]
[]
[null,{"$f":"+'2. Balance Hídrico'!C62","v":"ALFALFA"},"AÑO 1","AÑO 2","AÑO 3","AÑO 4","AÑO 5","AÑO 6","AÑO 7","AÑO 8","AÑO 9","AÑO 10"]
[null,"Área de Cédula (ha)",{"$f":"+'2. Balance Hídrico'!C63","v":15},{"$f":"+C26","v":15},{"$f":"+D26","v":15},15,15,15,15,15,15,15]
[null,"Rendimiento (Kg/ha)",10000,{"$f":"+C27","v":10000},{"$f":"+D27","v":10000},10000,10000,10000,10000,10000,10000,10000]
[null,"Precio en Chacra (Soles/Kg)",0.15,{"$f":"+C28","v":0.15},{"$f":"+D28","v":0.15},0.15,0.15,0.15,0.15,0.15,0.15,0.15]
[null,"VBP (S/ )",{"$f":"+C26*C27*C28","v":22500},{"$f":"+D26*D27*D28","v":22500},22500,22500,22500,22500,22500,22500,22500,22500]
[]
[null,"Costo de Producción Unitario (Soles/ha)",1300,{"$f":"+C31","v":1300},{"$f":"+D31","v":1300},{"$f":"+E31","v":1300},1300,1300,1300,1300,1300,1300]
[null,"VNP (S/ )",{"$f":"+C29-(C26*C31)","v":3000},{"$f":"+D29-(D26*D31)","v":3000},3000,3000,3000,3000,3000,3000,3000,3000]
[]
[]
[null,null,"AÑO 1","AÑO 2","AÑO 3","AÑO 4","AÑO 5","AÑO 6","AÑO 7","AÑO 8","AÑO 9","AÑO 10"]
[null,"Área de Cédula (ha)",{"$f":"+'[2]Balance Hídrico'!C73","v":0},{"$f":"+C36","v":0},0,0,0,0,0,0,0,0]
[null,"Rendimiento (Kg/ha)",0,0,0,0,0,0,0,0,0,0]
[null,"Precio en Chacra (Soles/Kg)",0,{"$f":"+C38","v":0},0,0,0,0,0,0,0,0]
[null,"VBP (S/ )",{"$f":"+C36*C37*C38","v":0},{"$f":"+D36*D37*D38","v":0},0,0,0,0,0,0,0,0]
[]
[null,"Costo de Producción Unitario (Soles/ha)",0,0,0,0,0,0,0,0,0,0]
[null,"VNP (S/ )",{"$f":"+C39-(C36*C41)","v":0},{"$f":"+D39-(D36*D41)","v":0},0,0,0,0,0,0,0,0]
[]
[]
[null,"23.2. Cálculo del Valor Neto de la Producción - Con Proyecto "]
[]
[null,"CULTIVOS ESTACIONALES "]
[]
[null,"Cultivo",{"$f":"+'2. Balance Hídrico'!D91","v":"HABA"},{"$f":"+'2. Balance Hídrico'!E91","v":"QUINUA"}]
[null,"Área de Cédula (ha)",{"$f":"+'2. Balance Hídrico'!D95","v":5},{"$f":"+'2. Balance Hídrico'!E92","v":5}]
[null,"Rendimiento (Kg/ha)",6000,4500]
[null,"Precio en Chacra (Soles/Kg)",1.5,3.5]
[null,"VBP (S/ )",{"$f":"+C51*C50*C52","v":45000},{"$f":"+D51*D50*D52","v":78750},{"$f":"+E51*E50*E52","v":0},{"$f":"+F51*F50*F52","v":0},{"$f":"+G51*G50*G52","v":0}]
[]
[null,"Costo de Producción Unitario (Soles/ha)",4500,5000,9000]
[null,"VNP (S/ )",{"$f":"+C53-(C50*C55)","v":22500},{"$f":"+D53-(D50*D55)","v":53750},{"$f":"+E53-(E50*E55)","v":0},{"$f":"+F53-(F50*F55)","v":0},{"$f":"+G53-(G50*G55)","v":0}]
[]
[]
[null,"CULTIVOS PERMANENTES"]
[]
[null,{"$f":"+'2. Balance Hídrico'!C91","v":"ALFALFA"},"AÑO 1","AÑO 2","AÑO 3","AÑO 4","AÑO 5","AÑO 6","AÑO 7","AÑO 8","AÑO 9","AÑO 10"]
[null,"Área de Cédula (ha)",{"$f":"+'2. Balance Hídrico'!C92","v":10},{"$f":"+C62","v":10},{"$f":"+D62","v":10},10,10,10,10,10,10,10]
[null,"Rendimiento (Kg/ha)",12500,{"$f":"+C63","v":12500},{"$f":"+D63","v":12500},12500,12500,12500,12500,12500,12500,12500]
[null,"Precio en Chacra (Soles/Kg)",0.15,{"$f":"+C64","v":0.15},{"$f":"+D64","v":0.15},0.15,0.15,0.15,0.15,0.15,0.15,0.15]
[null,"VBP (S/ )",{"$f":"+C62*C63*C64","v":18750},18750,18750,18750,18750,18750,18750,18750,18750,18750]
[]
[null,"Costo de Producción Unitario (Soles/ha)",1400,{"$f":"+C67","v":1400},{"$f":"+D67","v":1400},{"$f":"+E67","v":1400},1400,1400,1400,1400,1400,1400]
[null,"VNP (S/ )",{"$f":"+C65-(C62*C67)","v":4750},4750,4750,4750,4750,4750,4750,4750,4750,4750]
[]
[]
[null,{"$f":"+'2. Balance Hídrico'!F91","v":"PALTO"},"AÑO 1","AÑO 2","AÑO 3","AÑO 4","AÑO 5","AÑO 6","AÑO 7","AÑO 8","AÑO 9","AÑO 10"]
[null,"Área de Cédula (ha)",{"$f":"+'2. Balance Hídrico'!F92","v":5},{"$f":"+C72","v":5},{"$f":"+D72","v":5},5,5,5,5,5,5,5]
[null,"Rendimiento (Kg/ha)",0,0,0,3500,7500,10000,14000,14000,14000,14000]
[null,"Precio en Chacra (Soles/Kg)",3.5,{"$f":"+C74","v":3.5},{"$f":"+D74","v":3.5},{"$f":"+E74","v":3.5},3.5,3.5,3.5,3.5,3.5,3.5]
[null,"VBP (S/ )",{"$f":"+C72*C73*C74","v":0},0,0,61250,131250,175000,245000,245000,245000,245000]
[]
[null,"Costo de Producción Unitario (Soles/ha)",15000,7500,{"$f":"+D77","v":7500},{"$f":"+E77","v":7500},7500,7500,7500,7500,7500,7500]
[null,"VNP (S/ )",{"$f":"+C75-(C72*C77)","v":-75000},-37500,-37500,23750,93750,137500,207500,207500,207500,207500]
[]
[]
[null,"24. EVALUACIÓN COSTO - BENEFICIO"]
[]
[null,"24.1. Estimación del Flujo de Caja Privado"]
[]
[null,"TASA DE DESCUENTO",0.08]
[]
[null,"AÑO DE EVALUACIÓN","BENEFICIOS INCREMENTALES (S/ )","COSTOS INCREMENTALES (S/ )","FLUJO DE CAJA (S/ )",null,null,null,null,null,null,null,null,null,null,null,"VBP\nSIN PROY","VBP\nCON PROY",null,null,"BENEFICIOS SIN PROYECTO","BENEFICIOS CON PROYECTO"]
[null,"AÑO 0",null,{"$f":"+'[2]FyE Costos'!G71","v":427000},{"$f":"+C88-D88","v":-427000}]
[null,"AÑO 1",{"$f":"+V89-U89","v":-7000},{"$f":"+'[2]FyE Costos'!H124-'[2]FyE Costos'!C124","v":7500},{"$f":"+C89-D89","v":-14500},null,null,null,null,null,null,null,null,null,null,"AÑO 1",{"$f":"+C18+D18+C29","v":72500},{"$f":"+C53+D53+C65+C75","v":142500},null,null,{"$f":"+C32+C21+D21","v":13000},{"$f":"+C56+D56+C68+C78","v":6000}]
[null,"AÑO 2",30500,{"$f":"+D89","v":7500},23000,null,null,null,null,null,null,null,null,null,null,"AÑO 2",{"$f":"+Q89","v":72500},{"$f":"+C53+D53+D65+D75","v":142500},null,null,{"$f":"+C21+D21+D32","v":13000},{"$f":"+C56+D56+D68+D78","v":43500}]
[null,"AÑO 3",30500,{"$f":"+D90","v":7500},23000,null,null,null,null,null,null,null,null,null,null,"AÑO 3",{"$f":"+Q90","v":72500},{"$f":"+C53+D53+E65+E75","v":142500},null,null,{"$f":"+E32+C21+D21","v":13000},{"$f":"+C56+D56+E68+E78","v":43500}]
[null,"AÑO 4",91750,7500,84250,null,null,null,null,null,null,null,null,null,null,"AÑO 4",{"$f":"+Q91","v":72500},{"$f":"+C53+D53+F65+F75","v":203750},null,null,{"$f":"+C21+D21+F32","v":13000},{"$f":"+C56+D56+F68+F78","v":104750}]
[null,"AÑO 5",161750,{"$f":"+D92+'[2]FyE Costos'!G110","v":52500},109250,null,null,null,null,null,null,null,null,null,null,"AÑO 5",72500,{"$f":"+C53+D53+G65+G75","v":273750},null,null,{"$f":"+C21+D21+G32","v":13000},{"$f":"+C56+D56+G68+G78","v":174750}]
[null,"AÑO 6",205500,{"$f":"+D92","v":7500},198000,null,null,null,null,null,null,null,null,null,null,"AÑO 6",72500,{"$f":"+C53+D53+H65+H75","v":317500},null,null,{"$f":"+C21+D21+H32","v":13000},{"$f":"+C56+D56+H68+H78","v":218500}]
[null,"AÑO 7",275500,7500,268000,null,null,null,null,null,null,null,null,null,null,"AÑO 7",72500,{"$f":"+C53+D53+I65+I75","v":387500},null,null,{"$f":"+C21+D21+I32","v":13000},{"$f":"+C56+D56+I68+I78","v":288500}]
[null,"AÑO 8",275500,7500,268000,null,null,null,null,null,null,null,null,null,null,"AÑO 8",72500,{"$f":"+C53+D53+J65+J75","v":387500},null,null,{"$f":"+C21+D21+J32","v":13000},{"$f":"+C56+D56+J68+J78","v":288500}]
[null,"AÑO 9",275500,7500,268000,null,null,null,null,null,null,null,null,null,null,"AÑO 9",72500,{"$f":"+C53+D53+K65+K75","v":387500},null,null,{"$f":"+C21+D21+K32","v":13000},{"$f":"+C56+D56+K68+K78","v":288500}]
[null,"AÑO 10",275500,7500,268000,null,null,null,null,null,null,null,null,null,null,"AÑO 10",72500,{"$f":"+C53+D53+L65+L75","v":387500},null,null,{"$f":"+C21+D21+L32","v":13000},{"$f":"+C56+D56+L68+L78","v":288500}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Q89:Q98)","v":725000},{"$f":"SUM(R89:R98)","v":2772500}]
[]
[null,"24.2. Estimación de los Indicadores de Rentabilidad "]
[]
[null,"VAN (S/ )",{"$f":"NPV(C85,E89:E98)+E88","v":417974.63895608019}]
[null,"TIR (%)",{"$f":"IRR(E88:E98)","v":0.1888862258824715}]
[null,"B/C",{"$f":"NPV(C85,E89:E98)/(-E88)","v":1.9788633230821551}]

{"sheet":"5. Sostenibilidad","index":10,"n_rows":94,"n_cols":10,"rows_kept":94,"cut":false,"hidden":false,"merged":[[42,4,42,8],[43,1,43,8],[63,1,63,8],[67,1,67,8],[68,1,68,8],[54,1,54,4],[54,5,54,8],[55,1,55,8],[56,5,56,8],[57,5,57,8],[58,5,58,8],[59,1,59,8],[56,2,56,4],[57,2,57,4],[58,2,58,4],[62,2,62,4],[40,1,40,2],[41,1,41,2],[42,1,42,2],[29,4,29,8],[30,4,30,8],[31,4,31,8],[32,4,32,8],[33,4,33,8],[34,4,34,8],[35,4,35,8],[36,4,36,8],[37,4,37,8],[38,4,38,8],[39,4,39,8],[40,4,40,8],[41,4,41,8],[35,1,35,2],[36,1,36,2],[37,1,37,2],[38,1,38,2],[39,1,39,2],[30,1,30,2],[31,1,31,2],[32,1,32,2],[33,1,33,2],[34,1,34,2],[27,1,27,2],[27,4,27,8],[28,1,28,2],[28,4,28,8],[29,1,29,2],[1,1,1,9],[2,1,2,9],[16,1,16,3],[16,5,16,9],[5,1,5,9],[9,1,9,4],[10,1,10,9],[14,1,14,3],[14,5,14,9],[15,1,15,3],[15,5,15,9],[3,1,3,9],[70,1,70,8],[66,1,66,8],[69,1,69,8],[93,2,93,4],[93,6,93,8],[81,1,81,8],[78,1,78,8],[71,1,71,8],[80,1,80,8],[90,2,92,4],[90,6,92,8],[76,3,76,8],[77,1,77,8],[73,1,73,8],[62,5,62,8],[60,2,60,4],[60,5,60,8],[61,5,61,8],[61,2,61,4]]}
[]
[null,"FICHA TÉCNICA ESPECÍFICA SIMPLIFICADA - MEJORAMIENTO DEL SISTEMA DE RIEGO PARCELARIO"]
[null,"Basado en la Directiva N° 002-2017-EF/63.01, aprobada por Resolución Directoral N° 002-2017-EF/63.01"]
[null,"(La información registrada en esta ficha tiene carácter de Declaración Jurada)  "]
[]
[null,"IV.  REQUISITOS INSTITUCIONALES Y/O NORMATIVOS"]
[]
[null,"25. SOSTENIBILIDAD"]
[]
[null,"25.1.  Responsable de la Operación y Mantenimiento del PIP"]
[null,"GRUPO DE GESTIÓN EMPRESARIAL SAN LUIS"]
[]
[null,"25.2. Documentos que sustentan los acuerdos institucionales u otros que garantizan el financiamiento de los gastos de operación y mantenimiento"]
[]
[null,"Entidad / Organización",null,null,"Documento","Compromiso"]
[null,{"$f":"+B11","v":"GRUPO DE GESTIÓN EMPRESARIAL SAN LUIS"},null,null,"Acta de Compromisos","Operar y mantener de forma adecuada el sistema de riego tecnificado, acorde con las recomendaciones impartidas durante el proceso de capacitación."]
[null,{"$f":"+B16","v":"GRUPO DE GESTIÓN EMPRESARIAL SAN LUIS"},null,null,"Acta de Compromisos","Cumplir con implementar la cédula de cultivo propuesta."]
[]
[null,"26. GESTIÓN DEL RIESGO EN CONTEXTO DE CAMBIO CLIMÁTICO "]
[]
[null,"26.1.  ¿El área donde se ubica el proyecto ha sido afectada por algún desastre natural?"]
[]
[null,"NO","X"]
[null,"SI",{"$f":"IF(C23=\"X\", \"\", \"X\")","v":""}]
[]
[null,"26.2.  ¿Qué medidas de reducción de riesgos se están incluyendo en el proyecto de inversión?"]
[]
[null,"Peligros",null,"Nivel (BAJO, MEDIO, ALTO)","Medidas de Reducción de Riesgo en Contexto de Cambio Climático",null,null,null,null,"Costo (S/)"]
[null,"Sismos"]
[null,"Tsunamis"]
[null,"Heladas"]
[null,"Friajes"]
[null,"Erupciones Volcánicas"]
[null,"Sequías"]
[null,"Granizadas"]
[null,"Lluvias intensas."]
[null,"Avalanchas"]
[null,"Flujos de lodo (Huaicos)"]
[null,"Deslizamientos"]
[null,"Inundaciones"]
[null,"Vientos fuertes"]
[null,"Otros (Especificar):"]
[]
[null,"TOTAL",null,null,null,null,null,null,null,{"$f":"SUM(J29:J43)","v":0}]
[]
[null,"27. CERTIFICACIÓN AMBIENTAL"]
[]
[null,"27.1.  ¿El PIP cuenta con la certificación ambiental emitida por la DGAAA - MINAGRI?"]
[]
[null,"NO"]
[null,"SI",{"$f":"IF(C50=\"X\", \"\", \"X\")","v":"X"}]
[]
[null,"27.2.  Impactos Ambientales Negativos y Medidas de Mitigación"]
[]
[null,"Impactos Negativos ",null,null,null,"Medidas de Mitigación",null,null,null,"Costo (S/)"]
[null,"Durante la Ejecución",null,null,null,null,null,null,null,{"$f":"+J57+J58+J59","v":0}]
[null,"Acción 1:"]
[null,"Acción 2:"]
[null,"Acción 3:"]
[null,"Durante la Operación",null,null,null,null,null,null,null,{"$f":"+J61+J62+J63","v":0}]
[null,"Acción 1:"]
[null,"Acción 2:"]
[null,"Acción 3:"]
[null,"TOTAL",null,null,null,null,null,null,null,{"$f":"+J60+J56","v":0}]
[]
[null,"28. DOCUMENTOS PARA VIABILIDAD"]
[null,"Constancia de disponibilidad hídrica o licencia para uso de agua de riego, otorgada por la Autoridad Nacional del Agua - ANA."]
[null,"Acta de constitución del Grupo de Gestión Empresarial (Grupo de Beneficiarios)."]
[null,"Copia de DNI de los beneficiarios directos del proyecto."]
[null,"Documentos de acreditación de propiedad o posesión del terreno de los beneficiarios."]
[null,"Acreditaciones como usuarios de agua emitida por la Organización de Usuarios de Agua."]
[null,"Acta de compromiso de aporte de contrapartida económica de los beneficiarios."]
[null,"Acta de compromiso de operación y mantenimiento del sistema de riego instalado."]
[null,"Constancia de rol de distribución de agua emitido por la OUA."]
[]
[null,"29. ANEXOS"]
[]
[null,"Croquis de Ubicación"]
[null,"Plano de Planteamiento Hidráulico"]
[null,"Acta de compromiso de implementación de cédula de cultivo."]
[null,"Acta de libre disponibilidad de terreno."]
[null,"Panel Fotográfico"]
[]
[]
[null,"30.  FECHA DE  FORMULACIÓN"]
[null,null,null,null,"2017-08-30"]
[]
[null,"31. FIRMAS"]
[]
[]
[]
[]
[]
[null,null,"Responsable de la Formulación del Perfil",null,null,null,"Responsable de la Unidad Formuladora"]

{"sheet":"Selección de Datos","index":11,"n_rows":114,"n_cols":4,"rows_kept":114,"cut":false,"hidden":true,"merged":[]}
[]
[null,"COSTO DE CAPACITACIÓN EN O&M",200,"Costo unitario por ha"]
[null,"COSTO DE ASISTENCIA TÉCNICA ",500,"Costo unitario por ha"]
[]
[null,"COSTO EXPEDIENTE TÉCNICO",1200,"Costo unitario por ha"]
[]
[]
[]
[null,null,null,"Caracteristicas (*)"]
[null,null,"PRESUPUESTO "]
[null,null,"Componentes de Captación","Toma en quebrada o río"]
[null,null,null,"Toma en manantial"]
[null,null,null,"Toma en canal"]
[null,null,null,"Pozo"]
[null,null,null,"Otros"]
[null,null,null,"No comtempla"]
[]
[null,null,"Componentes de Aducción ","Canal de concreto"]
[null,null,null,"Canal de mamposteria "]
[null,null,null,"Tuberia de PVC"]
[null,null,null,"Tuberia de HDPE"]
[null,null,null,"Otros"]
[null,null,null,"No comtempla"]
[]
[null,null,"Componentes de Conducción ","Tuberia de PVC"]
[null,null,null,"Tuberia de HDPE"]
[null,null,null,"Otros"]
[null,null,null,"No comtempla"]
[]
[null,null,"Componentes de Distribución ","Tuberia de PVC"]
[null,null,null,"Tuberia de HDPE"]
[null,null,null,"Otros"]
[null,null,null,"No comtempla"]
[]
[null,null,"Componentes de Almacenamiento ","Revestimiento con geomenbrana"]
[null,null,null,"Revestimiento con concreto "]
[null,null,null,"Revestimiento con mampostería"]
[null,null,null,"Revestimiento con arcilla"]
[null,null,null,"Otros"]
[null,null,null,"No comtempla"]
[]
[null,null,"Componentes de Filtrado ","Cabezal de filtrado"]
[null,null,null,"No comtempla"]
[]
[null,null,"Componente de Fertirrigación","Inyector tipo venturi"]
[null,null,null,"Tanque fertilizante"]
[null,null,null,"Inyector hidráulico"]
[null,null,null,"Otros"]
[null,null,null,"No comtempla"]
[]
[null,null,"Componentes de Impulsión (Unidad de Bombeo)","Bomba accionada con motor petrolero "]
[null,null,null,"Bomba accionada con motor gasolinero"]
[null,null,null,"Bomba accionada con motor eléctrico"]
[null,null,null,"No comtempla"]
[]
[null,null,"Componentes de Automatización","Semiautomático"]
[null,null,null,"Automático"]
[null,null,null,"No comtempla"]
[]
[null,null,"Obras de sedimentación","Concreto"]
[null,null,null,"Otros"]
[null,null,null,"No comtempla"]
[]
[null,null,"Caseta de Control","Material noble"]
[null,null,null,"Material noble con techo de calamina"]
[null,null,null,"Otros"]
[null,null,null,"No comtempla"]
[]
[null,null,"Arcos de Riego ","Válvulas hidráulicas "]
[null,null,null,"Válvulas esféricas "]
[null,null,null,"Válvulas tipo angular"]
[null,null,null,"Válvulas tipo compuerta"]
[null,null,null,"Otros"]
[null,null,null,"No comtempla"]
[]
[null,null,"Equipos de Control y Protección","Varios"]
[null,null,null,"No comtempla"]
[]
[null,null,"Obras de Arte ","Varios"]
[null,null,null,"No comtempla"]
[]
[null,null,"Obras a Nivel Parcelario","Riego por multicompuertas "]
[null,null,null,"Riego por mangas "]
[null,null,null,"Riego por goteo"]
[null,null,null,"Riego por microaspersión"]
[null,null,null,"Riego por aspersión fijo"]
[null,null,null,"Riego por asperión semifijo"]
[null,null,null,"Riego por aspersión móvil"]
[]
[null,null,"Tipo de Motor ","Eléctrico "]
[null,null,null,"Combustión "]
[]
[]
[]
[null,"TIPO DE EJECUCIÓN"]
[null,"ADMINISTRACIÓN DIRECTA"]
[null,"ADMINISTRACIÓN INDIRECTA – POR CONTRATA"]
[null,"ADMINISTRACIÓN INDIRECTA – ASOCIACIÓN PÚBLICA PRIVADO (APP)"]
[null,"ADMINISTRACIÓN INDIRECTA - LEY N° 28585 PRT"]
[null,"ADMINISTRACIÓN INDIRECTA – NÚCLEO EJECUTOR "]
[null,"ADMINISTRACIÓN INDIRECTA – ley 29230 (OBRAS POR IMPUESTOS)"]
[]
[null,"CONVERSIÓN HP - Kw",0.74570000000000003]
[null,"DIAS DEL AÑO ",365]
[]
[]
[]
[]
[null,"Motor eléctrico:"]
[null,"Tarfia de consumo eléctrico (Soles/Kw x hr)",null,0.4]
[]
[null,"Motor a combustión:"]
[null,"Consumo promedio de combustible (gal/Hp x hr)",null,0.05]
[null,"Costo del combustible (Soles/gal)",null,12]

{"sheet":"Datos","index":12,"n_rows":93,"n_cols":8,"rows_kept":93,"cut":false,"hidden":true,"merged":[]}
[]
[null,null,"DATOS A INGRESAR "]
[]
[null,null,null,null,"NOMBRE DEL PIP","BALANCE HÍDRICO","PRESUPUESTO ","FLUJO DE CAJA "]
[null,null,"Ubicación Geográfica ",null,"X"]
[null,null,"Cédula de Cultivo",null,null,"X","X","X"]
[null,null,"Periodo de Siembra y Cosecha",null,null,"X"]
[null,null,"Área de Cultivo",null,null,"X","X","X"]
[null,null,"Caudal Autorizado",null,null,"X"]
[null,null,"Tiempo de Riego por ha ",null,null,"X"]
[null,null,"Frecuencia de Dotación",null,null,"X"]
[null,null,"Tipo de Riego Tecnificado",null,"X","X","X","X"]
[null,null,"Uso de Energía a Utilizar",null,null,null,"X","X"]
[]
[null,null,"BASE DE DATOS BALANCE HÍDRICO"]
[]
[null,null,null,null,"UNIDAD DE MEDIDA ","TIEMPO"]
[null,null,"ETO",null,"mm/mes","Mensual","CROPWAT"]
[null,null,"Precipitación Efectiva ",null,"mm/mes","Mensual","CROPWAT"]
[null,null,"Kc",null,null,"Mensual","MANUAL N° 56 DE LA FAO - CROPWAT"]
[null,null,"Eficiencia de Riego ",null,"%","Mensual"]
[]
[]
[null,null,"BASE DE DATOS FLUJO DE CAJA "]
[]
[null,null,"Costos de Producción",null,"Soles/ha","Campaña o Anual"]
[null,null,"Estimación del Incremento del Costo de Producción",null,"Soles/ha","Campaña o Anual"]
[null,null,"Rendimiento Agrícola ",null,"Kg/ha","Campaña o Anual"]
[null,null,"Estimación de Incremento del Rendimiento ",null,"Kg/ha","Campaña o Anual"]
[null,null,"Precio de Venta en Chacra",null,"Soles/Kg","Anual"]
[]
[null,null,null,null,null,"Caracteristicas (*)"]
[null,null,"PRESUPUESTO ","Unidad","metrado",null,"Costo"]
[null,null,"Componentes de Captación","und",1,"Toma en quebrada o rio",5500]
[null,null,null,null,null,"Toma en manantial"]
[null,null,null,null,null,"Toma en canal"]
[null,null,null,null,null,"Otros"]
[]
[null,null,"Componentes de Aducción ","m",20,"Canal de concreto"]
[null,null,null,null,null,"Canal mamposteria "]
[null,null,null,null,null,"Tuberia de pvc"]
[null,null,null,null,null,"Tuberia de hdpe"]
[null,null,null,null,null,"Otros"]
[]
[]
[null,null,"Componentes de Conducción ","m",800,"Tuberia de pvc"]
[null,null,null,null,null,"Tuberia de hdpe"]
[null,null,null,null,null,"Otros"]
[]
[null,null,"Componentes de Distribución ",null,null,"Tuberia de pvc"]
[null,null,null,null,null,"Tuberia de hdpe"]
[null,null,null,null,null,"Otros"]
[]
[null,null,"Componentes de Almacenamiento ","m3",1500,"Revestimiento con geoemenbrana",54000]
[null,null,null,null,null,"Revestimiento con concreto "]
[null,null,null,null,null,"Revestimiento con mampostería"]
[null,null,null,null,null,"Revestimiento con arcilla"]
[null,null,null,null,null,"Otros"]
[]
[null,null,"Componentes de Filtrado ",1,"und","Capacidad de filtrado"]
[]
[null,null,"Componente de Fertirrigación",1,"und","Inyector tipo venturi"]
[null,null,null,null,null,"Tanque fertilizante"]
[null,null,null,null,null,"Inyector hidráulico"]
[null,null,null,null,null,"Otros"]
[]
[null,null,"Componentes de Impulsión (Unidad de Bombeo)",1,"und","Bomba accionada con motor petrolero "]
[null,null,null,null,null,"Bomba accionada con motor gasolinero"]
[null,null,null,null,null,"Bomba accionada con motor eléctrico"]
[]
[null,null,"Componentes de Automatización",1,"und","Semiautomático"]
[null,null,null,null,null,"Automático"]
[]
[null,null,"Equipos de Control y Protección",1,"gbl","Global"]
[]
[null,null,"Obras de sedimentación",1,"und","Concreto"]
[null,null,null,null,null,"Otros"]
[]
[null,null,"Caseta de Control","und",1,"Material noble"]
[null,null,null,null,null,"Material noble con techo de calamina"]
[null,null,null,null,null,"Otros"]
[]
[null,null,"Obras de Arte ",1,"gbl","Global"]
[]
[null,null,"Arcos de Riego ",1,"gbl","Válvulas Hidráulicas "]
[null,null,null,null,null,"Válvulas Esféricas "]
[null,null,null,null,null,"Válvulas Tipo Angular"]
[null,null,"Equipos Especiales ",null,null,"Válvulas Tipo Compuerta"]
[null,null,"Obras a Nivel Parcelario",null,null,"Otros"]
[]
[]
[]
[null,null,"(*) Descripción en forma breve y concisa"]

{"sheet":"Ppto Ref","index":13,"n_rows":313,"n_cols":11,"rows_kept":313,"cut":false,"hidden":true,"merged":[[308,1,308,4],[311,1,311,5],[0,0,0,5],[1,1,1,5],[3,1,3,5],[305,1,305,4],[306,1,306,4],[307,1,307,4]]}
["Presupuesto Desagregado"]
["Obra"]
["Cliente",null,"AREA (HA)",15]
["Lugar","HUANCAVELICA - CHURCAMPA - CHURCAMPA"]
["Item","Descripción","Und.","Metrado","Precio S/.","Parcial S/."]
["01.00","OBRAS PROVISIONALES",null,null,null,1800,null,null,null,null,{"$f":"+F6/F311","v":7.1928485822256088E-3}]
["01.01","CARTEL DE OBRA","UND",1,700,700]
["01.02","CAMPAMENTO PROVISIONAL DE LA OBRA (1)","GLB",1,1100,1100]
["02.00","TOMA CAPTACION",null,null,null,1115.22]
["02.01","TRABAJOS PRELIMINARES",null,null,null,11.27]
["02.01.01","LIMPIEZA DE TERRENO MANUAL","M²",4,0.95,3.8]
["02.01.02","TRAZO Y REPLANTEO","M²",3,2.4900000000000002,7.47]
["02.02","MOVIMIENTO DE TIERRAS",null,null,null,30.74]
["02.02.01","EXCAVACION DE ESTRUCTURAS","M3",1.34,18.899999999999999,25.33]
["02.02.02","REFINE DE CARAS LATERALES","M²",4.29,1.26,5.41]
["02.03","OBRAS DE CONCRETO ARMADO",null,null,null,634.58000000000004]
["02.03.01","CONCRETO F'C=175 KG/CM2  SIN MEZCLADORA (HORMIGON)","M3",0.53,426.39,225.99]
["02.03.02","ENCOFRADO Y DESENCOFRADO MANUAL","M²",7.71,24.62,189.82]
["02.03.03","ACERO  ESTRUCTURAL  Fy = 4200 kg/ cm2","KG",30.64,7.14,218.77]
["02.04","REVOQUES ENLUCIDOS Y MOLDURAS",null,null,null,139.47999999999999]
["02.04.01","TARRAJEO CON IMPERMEABILIZANTE 1.3. e=1.5cm","M²",3.22,15.93,51.29]
["02.04.02","TARRAJEO CON MORTERO 1:3  e= 1.5cm","M²",3.49,25.27,88.19]
["02.05","ACCESORIOS PARA LA CAPTACIÓN",null,null,null,299.14999999999998]
["02.05.01","INSTALACION DE COMPUERTA METALICA  0.30 x 1.10 M","UND",1,210.9,210.9]
["02.05.02","ACCESORIOS DE CAPTACION","GLB",1,88.25,88.25]
["03.00","LINEA DE CONDUCCION (10 M)",null,null,null,351.02]
["03.01","TRABAJOS PRELIMINARES",null,null,null,12.4]
["03.01.01","LIMPIEZA DE TERRENO MANUAL LINEAL","ML",10,0.32,3.2]
["03.01.02","TRAZO Y REPLANTEO LONGITUDINAL","ML",10,0.92,9.1999999999999993]
["03.02","MOVIMIENTO DE TIERRAS",null,null,null,70.7]
["03.02.01","EXCAVACION DE ZANJA EN MATERIAL  SUELTO, PARA  TUB","M3",3.5,12.6,44.1]
["03.02.02","REFINE Y NIVELACION DE ZANJA EN TERRENO NORMAL PARA TUB. =< 200 mm.","ML",10,0.95,9.5]
["03.02.03","RELLENO CON MATERIAL ZARANDEADO","M3",1.5,3.84,5.76]
["03.02.04","RELLENO CON MATERIAL PROPIO","M3",1.5,7.56,11.34]
["03.03","TUBERIAS PVC-U UF",null,null,null,187.92]
["03.03.01","INSTALACION DE TUBERIA PVC-U DN: 110 mm PN-5","ML",12,15.66,187.92]
["03.04","ACCESORIOS EN LINEA DE CONDUCCIÓN",null,null,null,80]
["03.04.01","ACCESORIOS PVC UF-U 110mm","GLB",1,80,80]
["04.00","RESERVORIO DE GEOMEMBRANA (240 M3)",null,null,null,29054.76]
["04.01","TRABAJOS PRELIMINARES",null,null,null,770.55]
["04.01.01","LIMPIEZA DE TERRENO MANUAL","M²",300,0.95,285]
["04.01.02","TRAZO Y REPLANTEO","M²",195,2.4900000000000002,485.55]
["04.02","MOVIMIENTO DE TIERRAS",null,null,null,15167.76]
["04.02.01","EXCAVACION MANUAL PARA RESERVORIO","M3",396,20,7920]
["04.02.02","SERVICIO DE VOLADURA EN ROCAS MEDIANAS","PTO",80,2.99,239.2]
["04.02.03","ELIMINACION MANUAL DEL MATERIAL  EXCAVADO MAX. 30 M.","M3",200,9.16,1832]
["04.02.04","EXCAVACION DE ZANJA EN MATERIAL  SUELTO, PARA  TUB","M3",14,12.6,176.4]
["04.02.05","RELLENO CON MATERIAL PROPIO","M3",38,7.56,287.27999999999997]
["04.02.06","PERFILADO Y COMPACTADO CON EQUIPO Y RELLENO CON MATERIAL PROPIO","M²",269,17.52,4712.88]
["04.03","IMPERMEABILIZACIÓN DE RESERVORIO CON GEOMEMBRANA PVC",null,null,null,11604.62]
["04.03.01","TARRAJEO CON ARCILLA MAS ICHU  E=5.0 CM TALUD, 10 CM BASE, DEL RESERVORIO","M²",211,11.88,2506.6799999999998]
["04.03.02","SUMINISTRO E INSTALACION DE GEOMEMBRANA PVC DE 1.0 mm DE ESPESOR.","M²",298,30.53,9097.94]
["04.04","ACCESORIOS  EN RESERVORIO",null,null,null,526.48]
["04.04.01","ACCESORIOS EN EL RESERVORIO","GLB",1,526.48,526.48]
["04.05","CERCO PERIMÉTRICO",null,null,null,985.35]
["04.05.01","EXCAVACION DE ESTRUCTURAS","M3",1.17,18.899999999999999,22.11]
["04.05.02","CERCO PERIMETRICO CON ALAMBRE DE PUAS","ML",64,14.41,922.24]
["04.05.03","PUERTA DE MADERA RÚSTICA","UND",1,41,41]
["05.00","CAJA DE VALVULA  RESERVORIO (02 UND)",null,null,null,1306.8900000000001]
["05.01","TRABAJOS PRELIMINARES",null,null,null,5.09]
["05.01.01","TRAZO Y REPLANTEO","M²",1.28,2.4900000000000002,3.19]
["05.01.02","LIMPIEZA DE TERRENO MANUAL","M²",2,0.95,1.9]
["05.02","MOVIMIENTO DE TIERRAS",null,null,null,38.78]
["05.02.01","EXCAVACION DE ESTRUCTURAS","M3",1.62,18.899999999999999,30.62]
["05.02.02","REFINE DE CARAS LATERALES","M²",6.48,1.26,8.16]
["05.03","OBRAS DE CONCRETO ARMADO",null,null,null,218.39]
["05.03.01","CONCRETO F'C=175 KG/CM2  SIN MEZCLADORA (HORMIGON)","M3",0.22,426.39,93.81]
["05.03.02","ENCOFRADO Y DESENCOFRADO MANUAL","M²",5.0599999999999996,24.62,124.58]
["05.04","REVOQUES ENLUCIDOS Y MOLDURAS",null,null,null,111.19]
["05.04.01","TARRAJEO CON MORTERO 1:3  e= 1.5cm","M²",4.4000000000000004,25.27,111.19]
["05.05","ACCESORIOS",null,null,null,933.44]
["05.05.01","INSTALACION DE VALVULA COMPUERTA FO. FDO. LUFLEX  110 mm.","UND",1,367.32,367.32]
["05.05.02","INSTALACION DE VALVULA COMPUERTA FO. FDO. LUFLEX  90 mm.","UND",1,347.32,347.32]
["05.05.03","INSTALACION DE TAPA METÁLICA DE 0.50x0.50 m.","UND",2,109.4,218.8]
["06.00","CABEZAL DE FILTRADO",null,null,null,4333.29]
["06.01","TRABAJOS PRELIMINARES",null,null,null,22.16]
["06.01.01","LIMPIEZA DE TERRENO MANUAL","M²",12,0.95,11.4]
["06.01.02","TRAZO Y REPLANTEO","M²",4.32,2.4900000000000002,10.76]
["06.02","MOVIMIENTO DE TIERRAS",null,null,null,65.39]
["06.02.01","EXCAVACION DE ESTRUCTURAS","M3",3.46,18.899999999999999,65.39]
["06.03","OBRAS DE CONCRETO ARMADO",null,null,null,256.85000000000002]
["06.03.01","CONCRETO F'C=175 KG/CM2  SIN MEZCLADORA (HORMIGON)","M3",0.51,426.39,217.46]
["06.03.02","ENCOFRADO Y DESENCOFRADO MANUAL","M²",1.6,24.62,39.39]
["06.04","ACCESORIOS DE CABEZAL DE FILTRADO",null,null,null,3988.89]
["06.04.01","SUMINISTRO DE FILTRO DE ANILLOS DE 3\"","UND",2,720,1440]
["06.04.02","SUMINISTRO E INSTALACION DE VALVULA PVC TIPO MARIPOSA DE 90 MM","UND",4,317.36,1269.44]
["06.04.03","INSTALACION DE COLLARIN DE 90 mm. x 1\"","UND",1,21.9,21.9]
["06.04.04","INSTALACION DE VAL. DE AIRE 2\" (DOBLE EFECTO)","UND",1,254.75,254.75]
["06.04.05","ACCESORIOS DE CABEZAL DE RIEGO","UND",1,1002.8,1002.8]
["07.00","LINEA DE TUBERIA PRINCIPAL (1098 m)",null,null,null,27836.83]
["07.01","TRABAJOS PRELIMINARES",null,null,null,1460.34]
["07.01.01","LIMPIEZA DE TERRENO MANUAL LINEAL","ML",1098,0.32,351.36]
["07.01.02","TRAZO Y REPLANTEO LONGITUDINAL (M)","ML",1098,1.01,1108.98]
["07.02","MOVIMIENTO DE TIERRAS",null,null,null,8348.02]
["07.02.01","EXCAVACION DE ZANJA EN MATERIAL  SUELTO, PARA  TUB","M3",179.4,12.6,2260.44]
["07.02.02","EXCAVACION EN ROCA SUELTA","M3",150,20,3000]
["07.02.03","REFINE Y NIVELACION DE ZANJA EN TERRENO NORMAL PARA TUB. <= 110 mm.","ML",1098,0.76,834.48]
["07.02.04","RELLENO CON MATERIAL ZARANDEADO","M3",197.64,3.84,758.94]
["07.02.05","RELLENO CON MATERIAL PROPIO","M3",197.64,7.56,1494.16]
["07.03","TUBERIAS PVC-U UF",null,null,null,13733.77]
["07.03.01","INSTALACION DE TUBERIA PVC-U DN: 90 mm PN-5","ML",761,11.4,8675.4]
["07.03.02","INSTALACION DE TUBERIA PVC-U DN: 90 mm PN-7.5","ML",337,15.01,5058.37]
["07.04","ACCESORIOS",null,null,null,2120]
["07.04.01","ACCESORIOS PVC UF-U 90mm","GLB",1,2120,2120]
["07.05","PRUEBA HIDRAULICA",null,null,null,669.78]
["07.05.01","PRUEBA HIDRAULICA  A PRESION  EN TUBERIAS <= 110 mm","ML",1098,0.61,669.78]
["07.06","DADOS DE ANCLAJE",null,null,null,1504.92]
["07.06.01","CONCRETO F'C=140 KG/CM2  PARA DADO DE ANCLAJE","M3",2.4,338.3,811.92]
["07.06.02","COLOCACION DE DADOS DE ANCLAJE","UND",50,13.86,693]
["08.00","VALVULA  DE  CONTROL PRINCIPAL (10 UND)",null,null,null,5913.46]
["08.01","TRABAJOS PRELIMINARES",null,null,null,78]
["08.01.01","LIMPIEZA DE TERRENO MANUAL","M²",10,0.95,9.5]
["08.01.02","TRAZO Y REPLANTEO PARA UBICACION DE  ESTRUCTURAS","UND",10,6.85,68.5]
["08.02","MOVIMIENTO DE TIERRAS",null,null,null,115.92]
["08.02.01","EXCAVACION DE ESTRUCTURAS","M3",5.6,18.899999999999999,105.84]
["08.02.02","REFINE DE CARAS LATERALES","M²",8,1.26,10.08]
["08.03","OBRAS DE CONCRETO",null,null,null,493.94]
["08.03.01","ENCOFRADO Y DESENCOFRADO MANUAL","M²",6.9,24.62,169.88]
["08.03.02","CONCRETO F'C=175 KG/CM2  SIN MEZCLADORA (HORMIGON)","M3",0.76,426.39,324.06]
["08.04","VALVULA  DE  CONTROL",null,null,null,3173.6]
["08.04.01","SUMINISTRO E INSTALACION DE VALVULA PVC TIPO MARIPOSA DE 90 MM","UND",10,317.36,3173.6]
["08.05","ACCESORIOS",null,null,null,2052]
["08.05.01","INSTALACION DE COLLARIN DE 90 mm. x 1\"","UND",10,21.9,219]
["08.05.02","INSTALACION DE VAL. DE AIRE 1\" (SIMPLE EFECTO)","UND",10,48.22,482.2]
["08.05.03","CAJA PE DE PROTECCION JUMBO PARA VALVULAS DE CONTROL","UND",10,135.08000000000001,1350.8]
["09.00","CAMARA ROMPE PRESION CON CONTROL DE NIVEL (4 UND)",null,null,null,9514.9599999999991]
["09.01","TRABAJOS PRELIMINARES",null,null,null,49.81]
["09.01.01","TRAZO Y REPLANTEO PARA UBICACION DE  ESTRUCTURAS","UND",4,6.85,27.4]
["09.01.02","TRAZO Y REPLANTEO","M²",9,2.4900000000000002,22.41]
["09.02","MOVIMIENTO DE TIERRAS",null,null,null,217.67]
["09.02.01","EXCAVACION DE ESTRUCTURAS","M3",10.130000000000001,18.899999999999999,191.46]
["09.02.02","REFINE DE CARAS LATERALES","M²",20.8,1.26,26.21]
["09.03","OBRAS DE CONCRETO ARMADO",null,null,null,3412.5]
["09.03.01","SOLADO DE CONCRETO FC=100 KG/CM2 SIN MEZCLADORA (HORMIGON)","M3",0.34,300.14999999999998,102.05]
["09.03.02","ENCOFRADO Y DESENCOFRADO MANUAL","M²",40.200000000000003,24.62,989.72]
["09.03.03","CONCRETO F'C=175 KG/CM2  SIN MEZCLADORA (HORMIGON)","M3",0.56999999999999995,426.39,243.04]
["09.03.04","CONCRETO F'C=210 KG/CM2  SIN MEZCLADORA (HORMIGON)","M3",2.4300000000000002,465.93,1132.21]
["09.03.05","ACERO  ESTRUCTURAL  Fy = 4200 kg/ cm2","KG",132.41999999999999,7.14,945.48]
["09.04","REVOQUES ENLUCIDOS Y MOLDURAS",null,null,null,1214.22]
["09.04.01","TARRAJEO CON IMPERMEABILIZANTE 1.3. e=1.5cm","M²",17.600000000000001,15.93,280.37]
["09.04.02","TARRAJEO CON MORTERO 1:3  e= 1.5cm","M²",24.64,25.27,622.65]
["09.04.03","PINTURA ESMALTE EXTERIOR","M²",24.64,12.63,311.2]
["09.05","ACCESORIOS DE CRP",null,null,null,4620.76]
["09.05.01","SUMINISTRO E INSTALACION DE VALV. HIDRAULICA DE 3\"","UND",4,616.36,2465.44]
["09.05.02","INSTALACION DE TAPA METÁLICA DE 0.90x1.10 m.","UND",4,180.91,723.64]
["09.05.03","ACCESORIOS DE CRP 3\"/90mm","UND",4,357.92,1431.68]
["10.00","REGULADORAS DE PRESION PRV T-I -3\" (7 UND)",null,null,null,5731.8]
["10.01","TRABAJOS PRELIMINARES",null,null,null,47.95]
["10.01.01","TRAZO Y REPLANTEO PARA UBICACION DE  ESTRUCTURAS","UND",7,6.85,47.95]
["10.02","MOVIMIENTO DE TIERRAS",null,null,null,72.2]
["10.02.01","EXCAVACION DE ESTRUCTURAS","M3",3.82,18.899999999999999,72.2]
["10.03","DADOS DE ANCLAJE",null,null,null,363.19]
["10.03.01","CONCRETO F'C=140 KG/CM2  PARA DADO DE ANCLAJE","M3",0.5,338.3,169.15]
["10.03.02","COLOCACION DE DADOS DE ANCLAJE","UND",14,13.86,194.04]
["10.04","ACCESORIOS  PRV",null,null,null,5248.46]
["10.04.01","SUMINISTRO DE REGULADORA PRV  PRXF-LV 30 PSI 3\"","UND",7,640,4480]
["10.04.02","ACCESORIOS PRV 3\" B/1 EN TUB. 63 MM","UND",7,109.78,768.46]
["11.00","REGULADORAS DE PRESION PRV T-II - 3\"(6 UND)",null,null,null,10585.66]
["11.01","TRABAJOS PRELIMINARES",null,null,null,41.1]
["11.01.01","TRAZO Y REPLANTEO PARA UBICACION DE  ESTRUCTURAS","UND",6,6.85,41.1]
["11.02","MOVIMIENTO DE TIERRAS",null,null,null,79.569999999999993]
["11.02.01","EXCAVACION DE ESTRUCTURAS","M3",4.21,18.899999999999999,79.569999999999993]
["11.03","OBRAS DE CONCRETO ARMADO",null,null,null,311.79000000000002]
["11.03.01","CONCRETO F'C=140 KG/CM2  PARA DADO DE ANCLAJE","M3",0.43,338.3,145.47]
["11.03.02","COLOCACION DE DADOS DE ANCLAJE","UND",12,13.86,166.32]
["11.04","ACCESORIOS  PRV",null,null,null,10153.200000000001]
["11.04.01","ACCESORIOS PRV 3\" B/2 EN TUB. 90 MM","UND",6,412.2,2473.1999999999998]
["11.04.02","SUMINISTRO DE REGULADORA PRV  PRXF-LV 30 PSI 3\"","UND",2,1280,2560]
["11.04.03","SUMINISTRO DE REGULADORA PRV  PRXF-LV 40 PSI 3\"","UND",4,1280,5120]
["12.00","REGULADORAS DE PRESION PRV T-II  1 1/2 (5 UND)",null,null,null,1721.38]
["12.01","TRABAJOS PRELIMINARES",null,null,null,34.25]
["12.01.01","TRAZO Y REPLANTEO PARA UBICACION DE  ESTRUCTURAS","UND",5,6.85,34.25]
["12.02","MOVIMIENTO DE TIERRAS",null,null,null,66.34]
["12.02.01","EXCAVACION DE ESTRUCTURAS","M3",3.51,18.899999999999999,66.34]
["12.03","OBRAS DE CONCRETO ARMADO",null,null,null,260.39]
["12.03.01","CONCRETO F'C=140 KG/CM2  PARA DADO DE ANCLAJE","M3",0.36,338.3,121.79]
["12.03.02","COLOCACION DE DADOS DE ANCLAJE","UND",10,13.86,138.6]
["12.04","ACCESORIOS  PRV",null,null,null,1360.4]
["12.04.01","SUMINISTRO DE REGULADORA PRV  PRXF-LV 30 PSI 1\"","UND",5,120,600]
["12.04.02","ACCESORIOS PRV 1\" B/2 EN TUB. 1 1/2\"","UND",5,152.08000000000001,760.4]
["13.00","VALVULA  DE  AIRE DE 1\" (5 UND)",null,null,null,978.49]
["13.01","TRABAJOS PRELIMINARES",null,null,null,34.25]
["13.01.01","TRAZO Y REPLANTEO PARA UBICACION DE  ESTRUCTURAS","UND",5,6.85,34.25]
["13.02","MOVIMIENTO DE TIERRAS",null,null,null,7.94]
["13.02.01","EXCAVACION DE ESTRUCTURAS","M3",0.42,18.899999999999999,7.94]
["13.03","OBRAS DE CONCRETO ARMADO",null,null,null,69.45]
["13.03.01","ENCOFRADO Y DESENCOFRADO MANUAL","M²",0.36,24.62,8.86]
["13.03.02","CONCRETO F'C=140 KG/CM2  SIN MEZCLADORA (HORMIGON)","M3",0.15,403.93,60.59]
["13.04","ACCESORIOS VAL. AIRE",null,null,null,866.85]
["13.04.01","INSTALACION DE COLLARIN DE 90 mm. x 1\"","UND",5,21.9,109.5]
["13.04.02","INSTALACION DE VAL. DE AIRE 1\" (DOBLE EFECTO)","UND",5,114.75,573.75]
["13.04.03","CONO PE DE PROTECCION DE PARA  VALVULAS DE AIRE 1","UND",5,36.72,183.6]
["14.00","LINEA DE TUBERIA DISTRIBUIDORA (2857 m)",null,null,null,56148.63]
["14.01","TRABAJOS PRELIMINARES",null,null,null,3799.81]
["14.01.01","LIMPIEZA DE TERRENO MANUAL LINEAL","ML",2857,0.32,914.24]
["14.01.02","TRAZO Y REPLANTEO LONGITUDINAL (M)","ML",2857,1.01,2885.57]
["14.02","MOVIMIENTO DE TIERRAS",null,null,null,20076.25]
["14.02.01","EXCAVACION DE ZANJA EN MATERIAL  SUELTO, PARA  TUB","M3",557.1,12.6,7019.46]
["14.02.02","EXCAVACION EN ROCA SUELTA","M3",300,20,6000]
["14.02.03","REFINE Y NIVELACION DE ZANJA EN TERRENO NORMAL PARA TUB. <= 110 mm.","ML",2857,0.76,2171.3200000000002]
["14.02.04","RELLENO CON MATERIAL ZARANDEADO","M3",428.55,3.84,1645.63]
["14.02.05","RELLENO CON MATERIAL PROPIO","M3",428.55,7.56,3239.84]
["14.03","TUBERIAS PVC-U UF",null,null,null,27486.09]
["14.03.01","INSTALACION DE TUBERIA PVC-U DN: 90 mm PN-5","ML",345,11.4,3933]
["14.03.02","INSTALACION DE TUBERIA PVC-U DN: 90 mm PN-7.5","ML",460,15.01,6904.6]
["14.03.03","INSTALACION DE TUBERIA PVC-U DN: 63 mm PN-5","ML",599,7.8,4672.2]
["14.03.04","INSTALACION DE TUBERIA PVC-U DN: 63 mm PN-7.5","ML",413,9.1300000000000008,3770.69]
["14.03.05","INSTALACION DE TUBERIA PVC SP 1 1/2\" C-7.5","ML",1040,7.89,8205.6]
["14.04","ACCESORIOS",null,null,null,1894]
["14.04.01","ACCESORIOS PVC UF-U 90mm","GLB",1,1310,1310]
["14.04.02","ACCESORIOS PVC UF-U 63mm","GLB",1,488,488]
["14.04.03","ACCESORIOS PVC SP 1 1/2\"","GLB",1,96,96]
["14.05","PRUEBA HIDRAULICA",null,null,null,1742.77]
["14.05.01","PRUEBA HIDRAULICA  A PRESION  EN TUBERIAS <= 110 mm","ML",2857,0.61,1742.77]
["14.06","DADOS DE ANCLAJE",null,null,null,1149.71]
["14.06.01","CONCRETO F'C=140 KG/CM2  PARA DADO DE ANCLAJE","M3",1.35,338.3,456.71]
["14.06.02","COLOCACION DE DADOS DE ANCLAJE","UND",50,13.86,693]
["15.00","VALVULA  DE  CONTROL DISTRIBUIDORA (10 UND)",null,null,null,5492.29]
["15.01","TRABAJOS PRELIMINARES",null,null,null,78]
["15.01.01","LIMPIEZA DE TERRENO MANUAL","M²",10,0.95,9.5]
["15.01.02","TRAZO Y REPLANTEO PARA UBICACION DE  ESTRUCTURAS","UND",10,6.85,68.5]
["15.02","MOVIMIENTO DE TIERRAS",null,null,null,92.73]
["15.02.01","EXCAVACION DE ESTRUCTURAS","M3",4.4800000000000004,18.899999999999999,84.67]
["15.02.02","REFINE DE CARAS LATERALES","M²",6.4,1.26,8.06]
["15.03","OBRAS DE CONCRETO",null,null,null,464.09]
["15.03.01","ENCOFRADO Y DESENCOFRADO MANUAL","M²",6.9,24.62,169.88]
["15.03.02","CONCRETO F'C=175 KG/CM2  SIN MEZCLADORA (HORMIGON)","M3",0.69,426.39,294.20999999999998]
["15.04","VALVULA  DE  CONTROL",null,null,null,2813.6]
["15.04.01","SUMINISTRO E INSTALACION DE VALVULA PVC TIPO MARIPOSA DE 90 MM","UND",7,317.36,2221.52]
["15.04.02","SUMINISTRO E INSTALACION DE VALVULA PVC TIPO MARIPOSA DE 63 MM","UND",3,197.36,592.08000000000004]
["15.05","ACCESORIOS",null,null,null,2043.87]
["15.05.01","INSTALACION DE COLLARIN DE 90 mm. x 1\"","UND",7,21.9,153.30000000000001]
["15.05.02","INSTALACION DE COLLARIN DE 63 mm. x 1\"","UND",3,19.190000000000001,57.57]
["15.05.03","INSTALACION DE VAL. DE AIRE 1\" (SIMPLE EFECTO)","UND",10,48.22,482.2]
["15.05.04","CAJA PE DE PROTECCION JUMBO PARA VALVULAS DE CONTROL","UND",10,135.08000000000001,1350.8]
["16.00","VALVULA  DE  PURGA (22 UND)",null,null,null,1408.68]
["16.01","TRABAJOS PRELIMINARES",null,null,null,150.69999999999999]
["16.01.01","TRAZO Y REPLANTEO PARA UBICACION DE  ESTRUCTURAS","UND",22,6.85,150.69999999999999]
["16.02","MOVIMIENTO DE TIERRAS",null,null,null,41.58]
["16.02.01","EXCAVACION DE ESTRUCTURAS","M3",2.2000000000000002,18.899999999999999,41.58]
["16.03","OBRAS DE CONCRETO ARMADO",null,null,null,642.41999999999996]
["16.03.01","ENCOFRADO Y DESENCOFRADO MANUAL","M²",10.16,24.62,250.14]
["16.03.02","CONCRETO F'C=175 KG/CM2  SIN MEZCLADORA (HORMIGON)","M3",0.92,426.39,392.28]
["16.04","ACCESORIOS DE VAL. PURGA",null,null,null,573.98]
["16.04.01","INSTALACION DE PURGA DE 1 1/2\", TAPON CON ROSCA","UND",22,26.09,573.98]
["17.00","TOMA  HIDRANTE DE 1\" (27 UND)",null,null,null,2996.1]
["17.01","TRABAJOS PRELIMINARES",null,null,null,184.95]
["17.01.01","TRAZO Y REPLANTEO PARA UBICACION DE  ESTRUCTURAS","UND",27,6.85,184.95]
["17.02","OBRAS DE CONCRETO ARMADO",null,null,null,1106.8499999999999]
["17.02.01","ENCOFRADO Y DESENCOFRADO MANUAL","M²",22.68,24.62,558.38]
["17.02.02","CONCRETO F'C=175 KG/CM2  PARA PROTECCION DE HIDRANTES","M3",1.1299999999999999,362.8,409.96]
["17.02.03","ELAB. TRASL Y COLOCACION DADO DE PROTECCION DEL HIDRANTE","UND",27,5.13,138.51]
["17.03","ACCESORIOS DE TOMAS HIDRANTES",null,null,null,1704.3]
["17.03.01","INSTALACION DE COLLARIN DE 90 mm. x 1\"","UND",6,21.9,131.4]
["17.03.02","INSTALACION DE COLLARIN DE 63 mm. x 1\"","UND",12,19.190000000000001,230.28]
["17.03.03","INSTALACION DE TEE 1 1/2\" x 1\"","UND",9,18.2,163.80000000000001]
["17.03.04","INSTALACION DE TOMAS HIDRANTES DE 1\" (2A)","UND",27,43.66,1178.82]
["18.00","TOMA  HIDRANTE DE 1 1/2\" (24 UND)",null,null,null,3531.16]
["18.01","TRABAJOS PRELIMINARES",null,null,null,164.4]
["18.01.01","TRAZO Y REPLANTEO PARA UBICACION DE  ESTRUCTURAS","UND",24,6.85,164.4]
["18.02","OBRAS DE CONCRETO ARMADO",null,null,null,998.27]
["18.02.01","ENCOFRADO Y DESENCOFRADO MANUAL","M²",20.16,24.62,496.34]
["18.02.02","CONCRETO F'C=175 KG/CM2  PARA PROTECCION DE HIDRANTES","M3",1.03,362.8,373.68]
["18.02.03","ELAB. TRASL Y COLOCACION DADO DE PROTECCION DEL HIDRANTE","UND",25,5.13,128.25]
["18.03","ACCESORIOS DE TOMAS HIDRANTES",null,null,null,2368.4899999999998]
["18.03.01","INSTALACION DE COLLARIN DE 90 mm. 1 1/2\"","UND",19,15,285]
["18.03.02","INSTALACION DE COLLARIN DE 63 mm. 1 1/2\"","UND",4,15,60]
["18.03.03","INSTALACION DE TEE 1 1/2\" x 1 1/2\"","UND",1,13.49,13.49]
["18.03.04","INSTALACION DE TOMAS HIDRANTES DE 1 1/2\" (2B)","UND",24,83.75,2010]
["19.00","LATERAL MÓVIL DE 1\" PARA RIEGO POR  ASPERSION",null,null,null,{"$f":"+F271","v":4865}]
["19.01","INSTALACION DE MANGUERA PE DE 32 mm.",null,null,null,{"$f":"SUM(F272:F274)","v":4865}]
["19.01.01","Instalacion de Manguera PE de 32 mm. PN 6","ML",500,1.73,{"$f":"+D272*E272","v":865}]
["19.01.02","INSTALACION DE ELEVADORES Y SOPORTES EN CAMPO","UND",40,50,{"$f":"+D273*E273","v":2000}]
["19.01.03","SUMINISTRO E INSTALACION DE ASPERSORES 3/4 VYR 66","UND",40,50,{"$f":"+D274*E274","v":2000}]
["20.00","RIEGO POR MICROASPERSION",null,null,null,{"$f":"+F276","v":34821.399999999994}]
["20.01","INSTALACION DE  LATERALES DE RIEGO POR MICROASPERSIÓN",null,null,null,{"$f":"SUM(F277:F279)","v":34821.399999999994}]
["20.01.01","Instalacion de Manguera PE de 16 mm. PN 4","ML",18000,0.73,{"$f":"+E277*D277","v":13140}]
["20.01.02","INSTALACION DE CONECTORES TIPO BIGOTE DE 16 mm","UND",496,6,{"$f":"+E278*D278","v":2976}]
["20.01.03","INSTALACION DE KID DE MICROASPERSORES","UND",4310,4.34,{"$f":"+E279*D279","v":18705.399999999998}]
["21.00","ARCO DE RIEGO (16 UND)",null,null,null,{"$f":"+F281+F284+F286+F289","v":6734.48}]
["21.01","TRABAJOS PRELIMINARES",null,null,null,{"$f":"+F282+F283","v":123.36}]
["21.01.01","LIMPIEZA DE TERRENO MANUAL","M²",16,0.86,{"$f":"+E282*D282","v":13.76}]
["21.01.02","TRAZO Y REPLANTEO PARA UBICACION DE  ESTRUCTURAS","UND",16,6.85,{"$f":"+E283*D283","v":109.6}]
["21.02","MOVIMIENTO DE TIERRAS",null,null,null,72.58]
["21.02.01","EXCAVACION DE ESTRUCTURAS","M3",3.84,18.899999999999999,72.58]
["21.03","OBRAS DE CONCRETO",null,null,null,832.56]
["21.03.01","CONCRETO F'C=140 KG/CM2  PARA DADO DE ANCLAJE","M3",1.1499999999999999,338.3,389.04]
["21.03.02","COLOCACION DE DADOS DE ANCLAJE","UND",32,13.86,443.52]
["21.04","ACCESORIOS EN ARCO DE RIEGO",null,null,null,5705.98]
["21.04.01","ACCESORIOS ARCO DE RIEGO DE 3\"","UND",3,550.41999999999996,1651.26]
["21.04.02","ACCESORIOS ARCO DE RIEGO DE 2\"","UND",9,213.6,1922.4]
["21.04.03","ACCESORIOS ARCO DE RIEGO DE 1 1/2\"","UND",4,186.11,744.44]
["21.04.04","INSTALACION DE FILTRO DE ANILLOS DE 2\"","UND",1,302.35000000000002,302.35000000000002]
["21.04.05","INSTALACION DE COLLARIN DE 90 mm. x 1\"","UND",3,21.9,65.7]
["21.04.06","INSTALACION DE COLLARIN DE 63 mm. x 1\"","UND",9,19.190000000000001,172.71]
["21.04.07","INSTALACION DE COLLARIN DE 50 mm. x 1\"","UND",4,18.899999999999999,75.599999999999994]
["21.04.08","INSTALACION DE VAL. DE AIRE 1\" (SIMPLE EFECTO)","UND",16,48.22,771.52]
["22.00","FLETE",null,null,null,{"$f":"SUM(F299:F300)","v":5840.86}]
["22.01","FLETE TERRESTRE","GLB",1,4000,{"$f":"+E299*D299","v":4000}]
["22.02","FLETE RURAL","GLB",1,1840.86,{"$f":"+E300*D300","v":1840.86}]
["23.00","MITIGACION AMBIENTAL",null,null,null,{"$f":"+F302","v":2478}]
["23.01","MITIGACION AMBIENTAL","GLB",1,2478,{"$f":"+E302*D302","v":2478}]
["24.00","CAPAPACITACION Y ASISTENCIA TÉCNICA",null,null,null,{"$f":"+F304","v":1180}]
["24.01","CAPACITACION Y ASTENCIA TECNICA","GLB",1,1180,{"$f":"+E304*D304","v":1180}]
[null,"Costo Directo",null,null,null,{"$f":"+F303+F301+F298+F280+F275+F270+F258+F246+F236+F218+F193+F181+F170+F158+F147+F126+F110+F90+F75+F59+F39+F26+F9+F6","v":225740.35999999996}]
[null,"IGV (18% ST)  YA ESTAN INCLUIDOS EN EL COSTO DIRECTO DEL PROYECTO",null,null,null,{"$f":"+F305*0","v":0}]
[null,"ELABORACION DE ESTUDIOS (EXPEDIENTE TECNICO)",null,null,null,8850]
[null,"SUPERVISIÓN DEL PROYECTO",null,null,null,7658.2]
[null,"TRÁMITE PARA PMA",null,null,null,{"$f":"+E310","v":8000}]
[null,"PMA - Plan de Monitoreo Arqueológico","GLB",1,8000]
[null,"TOTAL PRESUPUESTO",null,null,null,{"$f":"SUM(F305:F309)","v":250248.55999999997}]
[null,"SON :      "]
[null,"COSTO UNITARIO","S/. - Ha",null,null,{"$f":"F311/14.75","v":16966.004067796606}]