{"text_format":"3","workbook":"xls","n_sheets":9,"sheets":["INDICE","PREPARACION","ALTERNATIVAS","EVALUACIÓN PRIVADA","EVALUACIÓN SOCIOECONÓMICA","INDICADORES","FINANCIACIÓN","ANÁLISIS DE SENSIBILIDAD","CONCLUSIONES"],"not_rendered":{"images":24,"macros":1,"external_links":3,"defined_names":558,"comments":24},"read":"whole","date_system":"1900","formulas":"cached_only"}

{"sheet":"INDICE","index":0,"n_rows":0,"n_cols":0,"rows_kept":0,"flags":["formulas_cached_only"]}

{"sheet":"PREPARACION","index":1,"n_rows":192,"n_cols":12,"rows_kept":192,"merged":[[5,1,5,3],[9,1,9,4],[10,1,10,4],[11,1,11,10],[21,1,21,2],[21,6,21,8],[35,1,35,4],[36,1,36,3],[36,4,36,6],[38,1,39,2],[38,3,39,4],[38,5,39,6],[40,1,40,2],[40,3,40,4],[40,5,40,6],[42,1,42,3],[43,1,43,3],[45,1,45,3],[46,1,48,2],[46,3,48,3],[49,1,49,2],[50,1,50,2],[51,1,51,2],[52,1,52,2],[53,1,53,2],[54,1,54,2],[57,1,59,3],[60,1,60,3],[61,1,61,3],[62,1,62,3],[63,1,63,3],[66,1,68,3],[69,1,69,3],[70,1,70,3],[71,1,71,3],[72,1,72,3],[74,6,74,9],[75,1,75,3],[75,6,75,8],[76,1,76,3],[76,6,76,8],[77,1,77,3],[77,6,77,8],[79,6,79,9],[80,1,80,3],[80,6,80,8],[81,1,81,3],[81,6,81,8],[82,1,82,3],[82,6,82,8],[83,6,83,8],[84,6,84,8],[86,1,86,5],[86,6,86,10],[87,1,87,3],[87,6,87,8],[88,1,88,3],[88,6,88,8],[89,1,89,3],[89,6,89,8],[90,1,90,3],[90,6,90,8],[92,1,92,4],[93,1,93,4],[94,1,94,4],[95,1,95,4],[97,1,100,2],[97,3,97,5],[98,3,98,5],[99,3,99,5],[100,3,100,5],[102,1,103,3],[105,1,105,3],[107,1,107,3],[107,4,107,9],[108,1,108,3],[108,4,108,9],[109,1,109,3],[109,4,109,9],[111,1,112,3],[111,6,111,10],[112,6,112,10],[114,1,114,5],[115,1,116,3],[118,1,119,3],[121,1,121,3],[123,1,124,3],[123,4,123,5],[123,6,123,7],[124,4,124,5],[124,6,124,7],[126,1,126,3],[127,1,128,2],[127,4,128,4],[127,5,128,5],[127,6,128,6],[130,1,131,3],[130,4,130,6],[130,7,130,8],[131,4,131,6],[131,7,131,8],[133,1,133,3],[133,4,133,9],[135,1,136,2],[138,1,138,4],[140,1,141,2],[140,5,140,6],[141,5,141,6],[143,1,145,2],[144,3,145,3],[147,1,148,2],[150,1,150,5],[157,1,157,5],[175,1,176,2],[175,3,176,3],[175,4,176,4],[175,5,176,5],[175,6,176,6],[175,7,175,8],[175,10,176,10],[177,1,177,2],[177,10,178,10],[178,1,178,2],[179,1,179,2],[180,1,180,2],[181,1,181,2],[186,2,186,5],[186,8,186,11]],"flags":["formulas_cached_only"]}
[null,202,75,{"$error":"#REF!"},{"$error":"#REF!"}]
[null,1151,460]
[null,{"$error":"#REF!"},{"$error":"#REF!"}]
[null,"PREPARACIÓN DEL PROYECTO",{"$nulls":4},2]
[]
[null," NOMBRE DEL PROYECTO"]
[]
[]
[]
[null,"NUMERO DE AÑOS QUE DURA EL PROYECTO",{"$nulls":3},1,null,null,"AÑO BASE",2008]
[null,"NUMERO DE AÑOS QUE DURA LA INVERSIÓN",{"$nulls":3},1]
[null,"LLENE ESTA SECCIÖN ANTES DE COMENZAR A INTRODUCIR INFORMACIÓN EN LA HOJA Y PULSE EL BOTÓN"]
[]
[]
[null,"TIPO DE PROYECTO",{"$nulls":5},"REGIÓN",null,"AREA"]
[{"$nulls":7},0,null,1]
[null,null,"Red de Alcantarillado"]
[null,null,"Planta de Tratamiento de Aguas Residuales",{"$nulls":4},"TIPO DE INVERSION"]
[null,null,"Obra de Canalización o Drenaje Pluvial",{"$nulls":4},3]
[]
[]
[null,"ANTECEDENTES",{"$nulls":4},"PROBLEMA O NECESIDAD"]
{"$rows_empty":8}
[null,"OBJETIVOS DEL PROYECTO"]
[]
[]
[]
[]
[null,"LOCALIZACIÓN"]
[null,"Municipio"]
[]
[null,"Población Total",null,"% Cubierto por el Proyecto",null,"Total Población Beneficiada"]
[]
[{"$nulls":5},0]
[]
[null,"Tasa de Crecimiento Intercensal"]
[null,"Promedio de Personas por Vivienda",null,null,{"v":1,"d":"1.0"}]
[]
[null,"POBLACIÓN OBJETIVO"]
[null,"ESTRATO O CATEGORÍA",null,"% de la Población Total","Años"]
[{"$nulls":4},0]
[{"$nulls":4},2008]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[null,"TOTAL",null,{"v":0,"d":"0%"},0]
[]
[null,"UNIDADES BENEFICIADAS"]
[{"$nulls":4},"Años"]
[{"$nulls":4},0]
[{"$nulls":4},2008]
[null,"Viviendas",null,null,0]
[null,"Industrias"]
[null,"Comercios"]
[null,"TOTAL",null,null,0]
[]
[null,"AREA BENEFICIADA",null,null,"Unidad Física"]
[null,"AREA BENEFICIADA",null,null,"Años"]
[{"$nulls":4},0]
[{"$nulls":4},2008]
[]
[]
[{"$nulls":4}," "]
[null,"TOTAL",null,null,0]
[]
[null,"CLIMATOLOGÍA",{"$nulls":4},"DIAGNÓSTICO DE LA SITUACIÓN ACTUAL"]
[null,"Temperatura Promedio",{"$nulls":3},"º","Longitud de la Red de Alcantarillado Actual",{"$nulls":3},"Kms."]
[null,"Altura sobre el Nivel del Mar",{"$nulls":3},"m.s.n.m","Existe Planta de Tratamiento?"]
[null,"Volúmen de Lluvia Anual",{"$nulls":3},"mm."]
[]
[null,"INDICADORES DE SALUD",{"$nulls":4},"SERVICIOS PÚBLICOS EN EL MUNICIPIO"]
[null,"Tasa de Mortalidad",{"$nulls":3},"%","Cobertura Agua Potable",{"$nulls":3},"%"]
[null,"Enfermos Gastrointestinales por Año",{"$nulls":4},"Cobertura Alcantarillado",{"$nulls":3},"%"]
[null,"Casos de Enfermos de la Piel por Año",{"$nulls":4},"Cobertura Recolección Basuras",{"$nulls":3},"%"]
[{"$nulls":6},"Cobertura Energía Eléctrica",{"$nulls":3},"%"]
[{"$nulls":6},"Cobertura Teléfono",{"$nulls":3},"%"]
[]
[null,"SERVICIO DE ALCANTARILLADO (SIN PROYECTO)",{"$nulls":4},"SERVICIO DE ALCANTARILLADO (CON PROYECTO)"]
[null,"Tipo de Alcantarillado",{"$nulls":4},"Tipo de Alcantarillado"]
[null,"No. de Conexiones Intradomiciliarias",{"$nulls":4},"No. de Nuevas Conexiones Intradomiciliarias"]
[null,"No. de Conexiones Domiciliarias",{"$nulls":4},"No. de Nuevas Conexiones Domiciliarias"]
[null,"No. de Emisarios",{"$nulls":4},"No. de Nuevos Emisarios"]
[]
[{"$nulls":5},"Diámetro","Longitud"]
[null,"Red de Alcantarillado"]
[null,"Colectores"]
[null,"Interceptores"]
[]
[null,"Obras auxiliares",null,"Tipo",null,null,"Número"]
[]
[]
[]
[]
[null,"Porcentaje de Conexiones Erradas",null,null,"Pluvial a Sanitario","Sanitario a Pluvial"]
[]
[]
[null,"Porcentaje de Agua Residual Recogida"]
[]
[null,"Uso del Agua del Cuerpo Receptor"]
[null,"Estado del Cuerpo de Agua Receptor"]
[null,"Tipo de Tratamiento"]
[]
[null,"Descarga Final",null,null,"Tipo","Lugar","Características de las Aguas Servidas Descargadas."]
[]
[]
[null,"ESTADO ACTUAL DEL SERVICIO DE AGUA POTABLE"]
[null,"Captación",null,null,"Fuente","Caudal      (litros / seg)"]
[]
[]
[null,"Comportamiento de la Fuente"]
[]
[]
[null,"Dotación per Cápita (m3/hab/mes)"]
[]
[null,"Obra de Toma",null,null,"Tipo",null,"Estado Actual"]
[]
[]
[{"$nulls":4},"Longitud de la Tubería (Km)","Estado de la Tubería","Estado de la Estación de Bombeo"]
[null,"Aducción"]
[]
[]
[null,"Tratamiento",null,null,"Tipo",null,null,"Calidad del Agua"]
[]
[]
[null,"Tipo de Almacenamiento"]
[]
[null,"Red de Distribución",null,"Diámetro","Longitud","Estado","Area Cubierta","Personas","Familias","Viviendas"]
[]
[]
[null,"Regularidad del Servicio (Porcentaje de Tiempo)"]
[]
[null,"Macromedición",null,"Tipo","Estado","Forma de Operación"]
[]
[]
[null,"Micromedición",null,"No. de Medidores"]
[]
[]
[]
[null,"Cálculo de Pérdidas",null,"Fugas (m3/mes)","Conexiones Ilegales","Agua no Contabiliz."]
[]
[]
[null,"DIAGNOSTICO INSTITUCIONAL"]
[]
[]
[]
[]
[]
[]
[null,"DIAGNOSTICO LEGAL"]
[]
[]
[]
[]
[]
[null,"RELACIÓN DEL PROYECTO CON PLANES Y PROGRAMAS"]
{"$rows_empty":10}
[null,"IMPACTO AMBIENTAL"]
[null,"IMPACTO AMBIENTAL",null,"Ninguno","Bajo","Medio","Alto","Tipo de Impacto",null,null,"Categoría del Impacto"]
[{"$nulls":7},"Transitorio","Permanente"]
[null,"Bosque",null,false,false,false,false,false,false,null,4]
[null,"Suelo",null,false,false,false,false,false,false]
[null,"Agua",null,false,false,false,false,false,false]
[null,"Aire",null,false,false,false,false,false,false]
[null,"Biodiversidad",null,false,false,false,false,false,false]
[]
[]
[null,"Participación de los COSTOS de EEIA según Categoría y Monto del",{"$nulls":5},"Participación de los Costos Ambientales por Categoría y Monto en "]
[null,"Proyecto dentro de los Costos del Proyecto",{"$nulls":5},"el Costo Total del Proyecto"]
[null,"Costo del Proyecto","Categoría del Proyecto",{"$nulls":4},"Costo del Proyecto","Categoría del Proyecto"]
[null,"millones de $ Bol.",1,2,3,4,null,"millones de $ Bol.",1,2,3,4]
[null,"< 30",0.01,0.007,0.005,0,null,"< 30",0.025,0.0175,0.0125,0]
[null,"30-60",0.009,0.006,0.004,0,null,"30-60",0.0225,0.015,0.01,0]
[null,"60-120",0.008,0.005,0,0,null,"60-120",0.02,0.0125,0,0]
[null,">120",0.007,0,0,0,null,">120",0.0175,0,0,0]

{"sheet":"ALTERNATIVAS","index":2,"n_rows":29,"n_cols":2,"rows_kept":29,"flags":["formulas_cached_only"]}
[]
[]
[]
[null,"ALTERNATIVA DE SOLUCIÓN - INGENIERÍA DEL PROYECTO"]
[null,"DESCRIPCION"]
{"$rows_empty":7}
[null,"ASPECTOS TÉCNICOS"]
{"$rows_empty":7}
[null,"ASPECTOS OPERATIVOS"]
{"$rows_empty":7}
[null,"ASPECTOS AMBIENTALES"]

{"sheet":"EVALUACIÓN PRIVADA","index":3,"n_rows":85,"n_cols":7,"rows_kept":85,"merged":[[5,1,5,4],[7,2,7,3],[10,1,12,1],[10,2,12,2],[10,3,10,4],[11,4,12,4],[22,1,22,2],[27,1,29,2],[27,3,27,4],[28,4,29,4],[31,1,31,2],[32,1,32,2],[33,1,33,2],[34,1,34,2],[35,1,35,2],[36,1,36,2],[37,1,37,2],[39,1,39,2],[40,1,40,2],[41,1,41,2],[42,1,42,2],[43,1,43,2],[44,1,44,2],[45,1,45,2],[46,1,46,2],[49,1,49,2],[50,1,50,2],[51,1,51,2],[53,1,53,2],[55,1,55,2],[56,1,56,2],[57,1,57,2],[58,1,58,2],[59,1,59,2],[62,1,64,2],[62,3,62,4],[63,4,64,4],[65,1,65,2],[67,1,67,2],[68,1,68,2],[69,1,69,2],[70,1,70,2],[74,1,74,2],[75,1,75,2],[76,1,76,2],[77,1,77,2],[78,1,78,2],[80,1,80,2],[82,1,82,2],[83,1,83,2],[84,1,84,2]],"flags":["formulas_cached_only"]}
[null,false]
[]
[]
[null,"EVALUACIÓN PRIVADA"]
[null,"PARAMETROS PARA LA EVALUACIÓN"]
[null,"TASA DE DESCUENTO PRIVADA",{"$nulls":3},{"v":0.1281,"d":"12.81%"}]
[]
[null,"Unidad Monetaria",null,null,"Tipo de Cambio (Bs. por Dólar)"]
[]
[null,"INGRESOS DEL PROYECTO",null,0.1281,{"v":1,"d":"100.00%"}]
[null,"Componentes","Tarifa Mensual","Años"]
[{"$nulls":3},0,"Total"]
[{"$nulls":3},2000]
[null,"Ingresos Viviendas"]
[null,"",null,0,0]
[null,"",null,0,0]
[null,"",null,0,0]
[null,"",null,0,0]
[null,"",null,0,0]
[null,"Ingresos Industrias",null,0,0]
[null,"Ingresos Comercios",null,0,0]
[]
[null,"TOTAL INGRESOS",null,0,0]
[]
[null,"COSTOS DEL PROYECTO",null,{"v":1,"d":"100%"},{"v":1,"d":"100%"}]
[null,"Unidad Monetaria","Dólares"]
[{"$nulls":3},6]
[null,"Componentes",null,"Años"]
[{"$nulls":3},0,"Total"]
[{"$nulls":3},2000]
[null,"OPERACIÓN"]
[null,"Bienes Transables",null,null,0]
[null,"Materiales Locales",null,null,0]
[null,"Mano de Obra Calificada",null,null,0]
[null,"Mano de Obra Semicalificada",null,null,0]
[null,"Mano de Obra No Calificada Urbana",null,null,0]
[null,"Mano de Obra No calificada Rural",null,null,0]
[null,"TOTAL COSTOS DE OPERACIÓN",null,0,0]
[]
[null,"INVERSIÓN"]
[null,"Bienes Transables",null,null,0]
[null,"Materiales Locales",null,null,0]
[null,"Mano de Obra Calificada",null,null,0]
[null,"Mano de Obra Semicalificada",null,null,0]
[null,"Mano de Obra No Calificada Urbana",null,null,0]
[null,"Mano de Obra No calificada Rural",null,null,0]
[null,"TOTAL COSTOS DE INVERSIÓN",null,0,0]
[null,null,20000000]
[null,"IMPACTO AMBIENTAL",5000000,10000000,0]
[null,"Costo de los Estudios de Impacto",null,0,0]
[null,"Costo del Manejo del Impacto",null,0,0]
[null,"Subtotal",null,0,0]
[]
[null,"TOTAL COSTOS",null,0,0]
[]
[null,"VACP",null,{"v":0,"d":"0.00"}]
[null,"VANP",null,{"v":0,"d":"0.00"}]
[null,"CAEP",null,{"v":0,"d":"0.00"}]
[null,"TIRP"]
[null,"VAIP",{"$nulls":3},"B / C",{"v":0,"d":"0.00"}]
[]
[null,"FLUJO DE FONDOS"]
[{"$nulls":3},"Años"]
[{"$nulls":3},0,"Total"]
[{"$nulls":3},2000]
[null,"Total Ingresos",null,0,0]
[]
[null,"Total Costos de Operación",null,0,0]
[null,"Depreciación (+)",null,null,0]
[null,"Costos Financieros (Intereses)",null,null,0]
[null,"Subtotal",null,0,0]
[]
[null,"Impuestos",null,0,0]
[]
[null,"Total Costos de Inversión",null,0,0]
[null,"Depreciación (-)",null,0,0]
[null,"Amortización (+)",null,null,0]
[null,"Préstamo(-)Escribir valores con signo Negativo",null,null,0]
[null,"Subtotal",null,0,0]
[]
[null,"Costos de Impacto Ambiental",null,0,0]
[]
[null,"Total Costos ",null,0,0]
[null,"Valor de Salvamento",null,null,0]
[null,"Flujo de Fondos Neto",null,0,0]

{"sheet":"EVALUACIÓN SOCIOECONÓMICA","index":4,"n_rows":68,"n_cols":7,"rows_kept":68,"merged":[[6,1,6,4],[7,1,7,4],[8,1,8,4],[9,1,9,4],[10,1,10,4],[11,1,11,4],[15,1,15,8],[20,1,22,2],[20,3,20,4],[21,4,22,4],[23,1,23,2],[24,1,24,2],[25,1,25,2],[26,1,26,2],[27,1,27,2],[28,1,28,2],[33,1,35,2],[33,3,33,4],[34,4,35,4],[37,1,37,2],[38,1,38,2],[39,1,39,2],[40,1,40,2],[41,1,41,2],[42,1,42,2],[43,1,43,2],[45,1,45,2],[46,1,46,2],[47,1,47,2],[48,1,48,2],[49,1,49,2],[50,1,50,2],[51,1,51,2],[52,1,52,2],[55,1,55,2],[56,1,56,2],[57,1,57,2],[59,1,59,2],[61,1,61,2],[63,1,63,2],[64,1,64,2],[65,1,65,2],[66,1,66,2],[67,1,67,2]],"flags":["formulas_cached_only"]}
[]
[]
[]
[null,"EVALUACIÓN SOCIOECONÓMICA"]
[]
[null,"PARÁMETROS PARA  LA EVALUACIÓN"]
[null,"RPC DIVISA",{"$nulls":3},1.24]
[null,"RPC MANO DE OBRA CALIFICADA",{"$nulls":3},{"v":1,"d":"1.00"}]
[null,"RPC MANO DE OBRA SEMICALIFICADA",{"$nulls":3},0.43]
[null,"RPC MANO DE OBRA NO CALIFICADA URBANA",{"$nulls":3},0.23]
[null,"RPC MANO DE OBRA NO CALIFICADA RURAL",{"$nulls":3},0.47]
[null,"TASA SOCIAL DE DESCUENTO",{"$nulls":3},{"v":0.1267,"d":"12.67%"}]
[]
[]
[]
[null,"Llene el Cuadro de Beneficios sólo si su proyecto es de Canalización y/o Drenaje Pluvial - Metodología de Ahorro de Costos"]
[]
[null,"BENEFICIOS DEL PROYECTO"]
[null,"Unidad Monetaria","Dólares"]
[]
[null,"BENEFICIOS",null,"Años"]
[{"$nulls":3},0,"Total"]
[{"$nulls":3},2000]
[null,"Ahorro en costos anuales de mantenimiento períodico",null,null,0]
[null,"Ahorro en gastos de emergencia",null,null,0]
[null,"Ahorro en costos por daños físicos evitables",null,null,0]
[null,"Ahorro en costos económicos personales",null,null,0]
[null,"Ahorro en costos por improductividad transitoria de activos",null,null,0]
[null,"TOTAL BENEFICIOS",null,0,0]
[]
[null,"COSTOS DEL PROYECTO"]
[null,"Unidad Monetaria","Dólares"]
[]
[null,"Componentes",null,"Años"]
[{"$nulls":3},0,"Total"]
[{"$nulls":3},2000]
[null,"OPERACIÓN"]
[null,"Bienes Transables",null,0,0]
[null,"Materiales Locales",null,0,0]
[null,"Mano de Obra Calificada",null,0,0]
[null,"Mano de Obra Semicalificada",null,0,0]
[null,"Mano de Obra No Calificada Urbana",null,0,0]
[null,"Mano de Obra No calificada Rural",null,0,0]
[null,"TOTAL COSTOS DE OPERACIÓN",null,0,0]
[]
[null,"INVERSIÓN"]
[null,"Bienes Transables",null,0,0]
[null,"Materiales Locales",null,0,0]
[null,"Mano de Obra Calificada",null,0,0]
[null,"Mano de Obra Semicalificada",null,0,0]
[null,"Mano de Obra No Calificada Urbana",null,0,0]
[null,"Mano de Obra No calificada Rural",null,0,0]
[null,"TOTAL COSTOS DE INVERSIÓN",null,0,0]
[]
[null,"IMPACTO AMBIENTAL",null,null,0]
[null,"Costo de los Estudios de Impacto",null,0,0]
[null,"Costo del Manejo del Impacto",null,0,0]
[null,"Subtotal",null,0,0]
[]
[null,"TOTAL COSTOS",null,0,0]
[]
[null,"FLUJO DE FONDOS NETO",null,0,0]
[]
[null,"VACS"]
[null,"VANS"]
[null,"CAES",null,{"v":0,"d":"0.00"}]
[null,"TIRS"]
[null,"VAIS",{"$nulls":3},"B / C",{"v":0,"d":"0.00"}]

{"sheet":"INDICADORES","index":5,"n_rows":34,"n_cols":14,"rows_kept":34,"merged":[[4,1,5,2],[4,3,5,3],[4,7,5,8],[4,9,5,9],[6,1,6,2],[6,7,6,8],[7,1,7,2],[7,7,7,8],[8,1,8,2],[8,7,8,8],[10,1,10,2],[10,7,10,8],[13,1,14,2],[13,3,14,3],[13,4,14,5],[13,7,14,8],[13,9,14,9],[16,1,16,2],[16,7,16,8],[17,1,17,2],[17,7,17,8],[18,1,18,2],[19,1,19,2],[21,1,22,1],[21,2,21,5],[21,6,21,9],[21,10,21,13],[22,2,22,3],[22,4,22,5],[22,6,22,7],[22,8,22,9],[22,10,22,11],[22,12,22,13],[28,1,29,1],[28,2,28,5],[28,6,28,9],[28,10,28,13],[29,2,29,3],[29,4,29,5],[29,6,29,7],[29,8,29,9],[29,10,29,11],[29,12,29,13]],"flags":["formulas_cached_only"]}
[]
[]
[]
[null,"INDICADORES FINANCIEROS",{"$nulls":5},"INDICADORES SOCIOECONOMICOS"]
[null,"Indicador",null,"Valor",{"$nulls":3},"Indicador",null,"Valor"]
[]
[null,"VACP",null,{"v":0,"d":"0.00"},{"$nulls":3},"VACS",null,{"v":0,"d":"0.00"}]
[null,"VANP",null,{"v":0,"d":"0.00"},{"$nulls":3},"VANS",null,{"v":0,"d":"0.00"}]
[null,"CAEP",null,{"v":0,"d":"0.00"},{"$nulls":3},"CAES",null,{"v":0,"d":"0.00"}]
[null,"TIRP",{"v":0.1,"d":"10%"},{"v":0,"d":"0.00%"},{"$nulls":3},"TIRS",{"v":0.1,"d":"10%"},{"v":0,"d":"0.00%"}]
[null,"RBC Privado",null,{"v":0,"d":"0.00"},{"$nulls":3},"RBC Social",null,{"v":0,"d":"0.00"}]
[]
[null,"INDICADORES COSTO - EFICIENCIA"]
[null,"Indicador",null,"Valor","Indicadores Estándar   U.S.$",null,null,"Indicador",null,"Valor"]
[]
[{"$nulls":4},"Max","Min"]
[null,"VACP / Conexiones",null,{"v":0,"d":"0.00"},{"$nulls":3},"VACS / Conexiones",null,{"v":0,"d":"0.00"}]
[null,"VACP / Beneficiarios",null,{"v":0,"d":"0.00"},{"$nulls":3},"VACS / Beneficiarios",null,{"v":0,"d":"0.00"}]
[null,"Costo Inv./ Beneficiario",null,{"v":0,"d":"0.00"},202,75]
[null,"Costo Inv./ Conexión",null,{"v":0,"d":"0.00"},{"v":1151,"d":"1,151"},460]
[null,"OTROS INDICADORES ESTANDAR PARA PROYECTOS SIMILARES"]
[null,"Costo de Inv/ Beneficiario","ALTIPLANO",{"$nulls":3},"VALLES",{"$nulls":3},"LLANOS"]
[null,null,"Urbano",null,"Rural",null,"Urbano",null,"Rural",null,"Urbano",null,"Rural"]
[null,"TIPO","Max","Min","Max","Min","Max","Min","Max","Min","Max","Min","Max","Min"]
[null,"Construcción",202,75,152,75,76,50,149,81]
[null,"Mejoramiento",53,33,null,null,82,53]
[null,"Ampliación"]
[]
[null,"Costo de Inv/ Conexión","ALTIPLANO",{"$nulls":3},"VALLES",{"$nulls":3},"LLANOS"]
[null,null,"Urbano",null,"Rural",null,"Urbano",null,"Rural",null,"Urbano",null,"Rural"]
[null,"TIPO","Max","Min","Max","Min","Max","Min","Max","Min","Max","Min","Max","Min"]
[null,"Construcción",1151,460,763,352,383,261,726,356]
[null,"Mejoramiento",1601,375,null,null,482,286]
[null,"Ampliación"]

{"sheet":"FINANCIACIÓN","index":6,"n_rows":14,"n_cols":12,"rows_kept":14,"merged":[[5,1,6,1],[5,2,5,5],[5,6,5,7],[5,8,5,10],[5,11,6,11]],"flags":["formulas_cached_only"]}
[]
[]
[]
[null,"INVERSIÓN ESTIMADA Y FINANCIAMIENTO"]
[]
[null,"Detalle","Financiamiento Interno -",{"$nulls":3},"Dólares",null,"Financiamiento Externo",null,null,"Total General"]
[null,null,"T.G.N.","Recursos Propios","Impuesto Específico Hidrocarb.","Recursos de Contraval.","Otros","Total Financiam Interno","Crédito Externo","Donación","Total Finaciam. Externo"]
[null,"Terreno",{"$nulls":5},0,null,null,0,0]
[null,"Edificaciones",{"$nulls":5},0,null,null,0,0]
[null,"Equipamiento",{"$nulls":5},0,null,null,0,0]
[null,"Suministros",{"$nulls":5},0,null,null,0,0]
[null,"Supervisión",{"$nulls":5},0,null,null,0,0]
[null,"Gastos Generales e Imprevistos",{"$nulls":5},0,null,null,0,0]
[null,"TOTAL",0,0,0,0,0,0,0,0,0,0]

{"sheet":"ANÁLISIS DE SENSIBILIDAD","index":7,"n_rows":21,"n_cols":10,"rows_kept":21,"merged":[[6,1,7,2],[6,3,7,3],[6,4,7,4],[6,6,6,7],[7,6,7,7],[8,1,8,2],[8,6,8,7],[9,1,9,2],[9,6,9,7],[10,1,10,2],[10,6,10,7],[11,1,11,2],[11,6,11,7],[13,6,13,7],[14,6,14,7],[15,6,15,7],[17,6,17,7],[18,6,18,7],[19,6,19,7],[20,6,20,7]],"flags":["formulas_cached_only"]}
[0]
[]
[]
[null,"ANALISIS DE SENSIBILIDAD"]
[]
[]
[null,"Variables",null,"Valor Actual","Nuevo Valor %",null,"Indicador",null,"Valor","% de Cambio"]
[{"$nulls":6},"VACP",null,{"v":0,"d":"0.00"},{"v":0,"d":"0.00%"}]
[null,"Conexiones",null,0,{"v":1,"d":"100%"},null,"VANP",null,{"v":0,"d":"0.00"},{"v":0,"d":"0.00%"}]
[null,"Unidades Beneficiadas",null,0,{"v":1,"d":"100%"},null,"CAEP",null,{"v":0,"d":"0.00"},{"v":0,"d":"0.00%"}]
[null,"Monto de la Inversión",null,{"v":0,"d":"0.00"},{"v":1,"d":"100%"},null,"TIRP",null,{"v":0,"d":"0.00%"},{"v":0,"d":"0.00%"}]
[null,"Costos de Operación",null,{"v":0,"d":"0.00"},{"v":1,"d":"100%"},null,"RBC Privado",null,{"v":0,"d":"0.00"},{"v":0,"d":"0.00%"}]
[]
[{"$nulls":6},"Indicador",null,"Valor","% de Cambio"]
[{"$nulls":6},"VACS",null,{"v":0,"d":"0.00"},{"v":0,"d":"0.00%"}]
[{"$nulls":6},"CAES",null,{"v":0,"d":"0.00"},{"v":0,"d":"0.00%"}]
[]
[{"$nulls":6},"VACP / Conexiones",null,{"v":0,"d":"0.00"},{"v":0,"d":"0.00%"}]
[{"$nulls":6},"VACP / Beneficiarios",null,{"v":0,"d":"0.00"},{"v":0,"d":"0.00%"}]
[{"$nulls":6},"Costo de Inversión / Beneficiario",null,{"v":0,"d":"0.00"},{"v":0,"d":"0.00%"}]
[{"$nulls":6},"Costo de Inversión / Conexiones",null,{"v":0,"d":"0.00"},{"v":0,"d":"0.00%"}]

{"sheet":"CONCLUSIONES","index":8,"n_rows":23,"n_cols":7,"rows_kept":23,"flags":["formulas_cached_only"]}
[]
[]
[]
[null,"CONCLUSIONES Y RECOMENDACIONES"]
[]
[null,"RECOMENDACIÓN",{"$nulls":3},"OBSERVACIONES"]
{"$rows_empty":10}
[null,"FECHA",{"$nulls":4},"        FIRMA"]
[]
[]
[null,"RESPONSABLE"]
[]
[]
[null,"CARGO"]