{"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":23,"macros":1,"external_links":2,"defined_names":574,"comments":46},"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":120,"n_cols":12,"rows_kept":120,"merged":[[5,1,5,3],[9,1,9,4],[10,1,10,4],[11,1,11,10],[16,6,16,7],[16,8,16,9],[20,6,20,7],[20,8,20,9],[24,1,24,2],[24,6,24,8],[37,1,37,4],[38,1,38,3],[38,4,38,6],[40,1,41,2],[40,3,41,4],[40,5,41,6],[42,1,42,2],[42,3,42,4],[42,5,42,6],[44,1,44,3],[45,1,45,3],[47,1,47,3],[48,1,50,2],[48,3,50,3],[51,1,51,2],[52,1,52,2],[53,1,53,2],[54,1,54,2],[55,1,55,2],[56,1,56,2],[59,1,61,3],[62,1,62,3],[63,1,63,3],[64,1,64,3],[65,1,65,3],[68,1,70,3],[71,1,71,3],[72,1,72,3],[73,1,73,3],[74,1,74,3],[75,6,75,9],[77,1,77,3],[78,1,78,3],[79,1,79,3],[81,1,81,4],[82,1,82,6],[83,1,83,6],[84,1,84,6],[85,1,85,6],[86,1,86,6],[87,1,87,6],[88,1,88,6],[89,1,89,4],[90,1,92,4],[90,5,90,6],[91,5,91,6],[92,5,92,6],[103,1,104,2],[103,3,104,3],[103,4,104,4],[103,5,104,5],[103,6,104,6],[103,7,103,8],[103,10,104,10],[105,1,105,2],[105,10,106,10],[106,1,106,2],[107,1,107,2],[108,1,108,2],[109,1,109,2],[114,2,114,5],[114,8,114,11]],"flags":["formulas_cached_only"]}
[null,281,64,773,133]
[null,655,113]
[null,312,95]
[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":4},"CARACTERÍSTICAS"]
[]
[null,null,"Captación",{"$nulls":3},"REGIÓN",null,"AREA"]
[null,null,"Aducción",{"$nulls":3},0]
[null,null,"Tratamiento"]
[null,null,"Almacenamiento"]
[null,null,"Distribución",{"$nulls":3},"     TECNOLOGÍA",null,"TIPO DE INVERSION"]
[null,null,"Conexiones Domiciliarias",{"$nulls":3},1,null,3]
[]
[]
[null,"ANTECEDENTES",{"$nulls":4},"PROBLEMA O NECESIDAD"]
{"$rows_empty":7}
[null,"OBJETIVOS DEL PROYECTO"]
[]
[]
[]
[]
[null,"LOCALIZACIÓN"]
[null,"Municipio"]
[]
[null,"Población Total           (No. de Habitantes)",null,"% Cubierto por el Proyecto",null,"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 Benefic.","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]
[{"$nulls":6},"SERVICIOS PÚBLICOS EN EL MUNICIPIO"]
[null,"CLIMATOLOGÍA",{"$nulls":4},"Cobertura Agua Potable",{"$nulls":3},"%"]
[null,"Temperatura Promedio",{"$nulls":3},"º","Cobertura Alcantarillado",{"$nulls":3},"%"]
[null,"Altura sobre el Nivel del Mar",{"$nulls":3},"m.s.n.m","Cobertura Recolección Basuras",{"$nulls":3},"%"]
[null,"Volúmen de Lluvia Anual",{"$nulls":3},"mm.","Cobertura Energía Eléctrica",{"$nulls":3},"%"]
[{"$nulls":6},"Cobertura Teléfono",{"$nulls":3},"%"]
[null,"DIAGNÓSTICO DE LA SITUACIÓN ACTUAL"]
[null,"Población con Servicio de Acueducto"]
[null,"No.de Conexiones Domiciliarias"]
[null,"Medidores Instalados"]
[null,"Continuidad (Horas diarias de servicio/24 horas)"]
[null,"% de Pérdidas (Volumen de agua facturada/volumen de agua producida)"]
[null,"Cobertura del Servicio (conexiones/viviendas)",{"$nulls":5},0]
[null,"Cobertura de Micromedición (Medidores/suscriptores)",{"$nulls":5},0]
[null,"DEMANDA POTENCIAL"]
[null,"Consumo Promedio Mensual de Agua (Mt3)",{"$nulls":3},"por Vivienda"]
[{"$nulls":5},"por Industria"]
[{"$nulls":5},"por Comercio"]
[null,"RELACIÓN DEL PROYECTO CON PLANES Y PROGRAMAS"]
{"$rows_empty":8}
[null,"ESTIMACION PRELIMINAR DEL IMPACTO AMBIENTAL"]
[null,"IMPACTO AMBIENTAL",null,"Ninguno","Bajo","Medio","Alto","Tipo de Impacto",null,null,"Categoría del Impacto"]
[{"$nulls":7},"Transitorio","Permanent"]
[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,"DESCRIPCIÓN"]
{"$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":181,"n_cols":8,"rows_kept":181,"merged":[[5,1,5,4],[7,2,7,4],[10,1,12,1],[10,2,10,3],[10,4,10,5],[11,2,12,2],[11,3,12,3],[11,5,12,5],[22,1,22,3],[25,2,25,3],[27,1,29,3],[27,4,27,5],[28,5,29,5],[32,1,32,3],[33,1,33,3],[34,1,34,3],[35,1,35,3],[36,1,36,3],[37,1,37,3],[38,1,38,3],[40,1,40,3],[41,1,41,3],[42,1,42,3],[43,1,43,3],[44,1,44,3],[45,1,45,3],[46,1,46,3],[48,1,48,3],[49,1,49,3],[50,1,50,3],[51,1,51,3],[52,1,52,3],[53,1,53,3],[54,1,54,3],[56,1,56,3],[57,1,57,3],[58,1,58,3],[59,1,59,3],[60,1,60,3],[61,1,61,3],[62,1,62,3],[64,1,64,3],[65,1,65,3],[66,1,66,3],[67,1,67,3],[68,1,68,3],[69,1,69,3],[70,1,70,3],[72,1,72,3],[73,1,73,3],[74,1,74,3],[75,1,75,3],[76,1,76,3],[77,1,77,3],[78,1,78,3],[79,1,79,3],[82,1,82,3],[83,1,83,3],[84,1,84,3],[85,1,85,3],[86,1,86,3],[87,1,87,3],[88,1,88,3],[89,1,89,3],[91,1,91,2],[93,1,93,3],[94,1,94,3],[95,1,95,3],[96,1,96,3],[97,1,97,3],[98,1,98,3],[99,1,99,3],[101,1,101,3],[102,1,102,3],[103,1,103,3],[104,1,104,3],[105,1,105,3],[106,1,106,3],[107,1,107,3],[109,1,109,3],[110,1,110,3],[111,1,111,3],[112,1,112,3],[113,1,113,3],[114,1,114,3],[115,1,115,3],[117,1,117,3],[118,1,118,3],[119,1,119,3],[120,1,120,3],[121,1,121,3],[122,1,122,3],[123,1,123,3],[125,1,125,3],[126,1,126,3],[127,1,127,3],[128,1,128,3],[129,1,129,3],[130,1,130,3],[131,1,131,3],[133,1,133,3],[134,1,134,3],[135,1,135,3],[136,1,136,3],[137,1,137,3],[138,1,138,3],[139,1,139,3],[140,1,140,3],[143,1,143,3],[144,1,144,3],[145,1,145,3],[147,1,147,3],[149,1,149,3],[150,1,150,3],[151,1,151,3],[152,1,152,3],[153,1,153,3],[156,1,158,3],[156,4,156,5],[157,5,158,5],[159,1,159,3],[161,1,161,3],[162,1,162,3],[163,1,163,3],[164,1,164,3],[166,1,166,3],[168,2,168,3],[170,1,170,3],[171,1,171,3],[172,1,172,3],[173,1,173,3],[174,1,174,3],[176,1,176,3],[178,1,178,3],[179,1,179,3],[180,1,180,3]],"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",{"$nulls":3},"Tipo de Cambio (Bs. Por Dólar)"]
[]
[null,"INGRESOS DEL PROYECTO",null,null,0.1281]
[null,"Componentes","Tarifa",null,"Años"]
[null,null,"Fija por mes","Varble. por m3",0,"Total"]
[{"$nulls":4},2008]
[null,"Ingresos Viviendas"]
[null,"",null,null,0,0]
[null,"",null,null,0,0]
[null,"",null,null,0,0]
[null,"",null,null,0,0]
[null,"",null,null,0,0]
[null,"Ingresos Industrias",null,null,0,0]
[null,"Ingresos Comercios",null,null,0,0]
[]
[null,"TOTAL INGRESOS",null,null,0,0]
[]
[null,"COSTOS DEL PROYECTO"]
[null,"Unidad Monetaria","Dólares"]
[null,null,{"v":1,"d":"100%"},{"v":1,"d":"100%"},6]
[null,"Componentes",null,null,"Años"]
[{"$nulls":4},0,"Total"]
[{"$nulls":4},2008]
[null,"COSTOS DE OPERACIÓN"]
[null,"CAPTACIÓN"]
[null,"   Bienes Transables",{"$nulls":3},0]
[null,"   Materiales Locales",{"$nulls":3},0]
[null,"   Mano de Obra Calificada",{"$nulls":3},0]
[null,"   Mano de Obra Semicalificada",{"$nulls":3},0]
[null,"   Mano de Obra No Calificada Urbana",{"$nulls":3},0]
[null,"   Mano de Obra No calificada Rural",{"$nulls":3},0]
[null,"Subtotal",null,null,0,0]
[null,"ADUCCIÓN"]
[null,"   Bienes Transables",{"$nulls":3},0]
[null,"   Materiales Locales",{"$nulls":3},0]
[null,"   Mano de Obra Calificada",{"$nulls":3},0]
[null,"   Mano de Obra Semicalificada",{"$nulls":3},0]
[null,"   Mano de Obra No Calificada Urbana",{"$nulls":3},0]
[null,"   Mano de Obra No calificada Rural",{"$nulls":3},0]
[null,"Subtotal",null,null,0,0]
[null,"TRATAMIENTO"]
[null,"   Bienes Transables",{"$nulls":3},0]
[null,"   Materiales Locales",{"$nulls":3},0]
[null,"   Mano de Obra Calificada",{"$nulls":3},0]
[null,"   Mano de Obra Semicalificada",{"$nulls":3},0]
[null,"   Mano de Obra No Calificada Urbana",{"$nulls":3},0]
[null,"   Mano de Obra No calificada Rural",{"$nulls":3},0]
[null,"Subtotal",null,null,0,0]
[null,"ALMACENAMIENTO"]
[null,"   Bienes Transables",{"$nulls":3},0]
[null,"   Materiales Locales",{"$nulls":3},0]
[null,"   Mano de Obra Calificada",{"$nulls":3},0]
[null,"   Mano de Obra Semicalificada",{"$nulls":3},0]
[null,"   Mano de Obra No Calificada Urbana",{"$nulls":3},0]
[null,"   Mano de Obra No calificada Rural",{"$nulls":3},0]
[null,"Subtotal",null,null,0,0]
[null,"DISTRIBUCIÓN"]
[null,"   Bienes Transables",{"$nulls":3},0]
[null,"   Materiales Locales",{"$nulls":3},0]
[null,"   Mano de Obra Calificada",{"$nulls":3},0]
[null,"   Mano de Obra Semicalificada",{"$nulls":3},0]
[null,"   Mano de Obra No Calificada Urbana",{"$nulls":3},0]
[null,"   Mano de Obra No calificada Rural",{"$nulls":3},0]
[null,"Subtotal",null,null,0,0]
[null,"CONEXIONES DOMICILIARIAS"]
[null,"   Bienes Transables",{"$nulls":3},0]
[null,"   Materiales Locales",{"$nulls":3},0]
[null,"   Mano de Obra Calificada",{"$nulls":3},0]
[null,"   Mano de Obra Semicalificada",{"$nulls":3},0]
[null,"   Mano de Obra No Calificada Urbana",{"$nulls":3},0]
[null,"   Mano de Obra No calificada Rural",{"$nulls":3},0]
[null,"Subtotal",null,null,0,0]
[null,"TOTAL COSTOS DE OPERACIÓN",null,null,0,0]
[]
[null,"COSTOS DE ADMINISTRACIÓN"]
[null,"   Bienes Transables",{"$nulls":3},0]
[null,"   Materiales Locales",{"$nulls":3},0]
[null,"   Mano de Obra Calificada",{"$nulls":3},0]
[null,"   Mano de Obra Semicalificada",{"$nulls":3},0]
[null,"   Mano de Obra No Calificada Urbana",{"$nulls":3},0]
[null,"   Mano de Obra No calificada Rural",{"$nulls":3},0]
[null,"Subtotal",null,null,0,0]
[null,"TOTAL COSTOS DE ADMINIST.",null,null,0,0]
[]
[null,"COSTOS DE INVERSIÓN"]
[null,"CAPTACIÓN"]
[null,"   Bienes Transables",{"$nulls":3},0]
[null,"   Materiales Locales",{"$nulls":3},0]
[null,"   Mano de Obra Calificada",{"$nulls":3},0]
[null,"   Mano de Obra Semicalificada",{"$nulls":3},0]
[null,"   Mano de Obra No Calificada Urbana",{"$nulls":3},0]
[null,"   Mano de Obra No calificada Rural",{"$nulls":3},0]
[null,"Subtotal",null,null,0,0]
[null,"ADUCCIÓN"]
[null,"   Bienes Transables",{"$nulls":3},0]
[null,"   Materiales Locales",{"$nulls":3},0]
[null,"   Mano de Obra Calificada",{"$nulls":3},0]
[null,"   Mano de Obra Semicalificada",{"$nulls":3},0]
[null,"   Mano de Obra No Calificada Urbana",{"$nulls":3},0]
[null,"   Mano de Obra No calificada Rural",{"$nulls":3},0]
[null,"Subtotal",null,null,0,0]
[null,"TRATAMIENTO"]
[null,"   Bienes Transables",{"$nulls":3},0]
[null,"   Materiales Locales",{"$nulls":3},0]
[null,"   Mano de Obra Calificada",{"$nulls":3},0]
[null,"   Mano de Obra Semicalificada",{"$nulls":3},0]
[null,"   Mano de Obra No Calificada Urbana",{"$nulls":3},0]
[null,"   Mano de Obra No calificada Rural",{"$nulls":3},0]
[null,"Subtotal",null,null,0,0]
[null,"ALMACENAMIENTO"]
[null,"   Bienes Transables",{"$nulls":3},0]
[null,"   Materiales Locales",{"$nulls":3},0]
[null,"   Mano de Obra Calificada",{"$nulls":3},0]
[null,"   Mano de Obra Semicalificada",{"$nulls":3},0]
[null,"   Mano de Obra No Calificada Urbana",{"$nulls":3},0]
[null,"   Mano de Obra No calificada Rural",{"$nulls":3},0]
[null,"Subtotal",null,null,0,0]
[null,"DISTRIBUCIÓN"]
[null,"   Bienes Transables",{"$nulls":3},0]
[null,"   Materiales Locales",{"$nulls":3},0]
[null,"   Mano de Obra Calificada",{"$nulls":3},0]
[null,"   Mano de Obra Semicalificada",{"$nulls":3},0]
[null,"   Mano de Obra No Calificada Urbana",{"$nulls":3},0]
[null,"   Mano de Obra No calificada Rural",{"$nulls":3},0]
[null,"Subtotal",null,null,0,0]
[null,"CONEXIONES DOMICILIARIAS"]
[null,"   Bienes Transables",{"$nulls":3},0]
[null,"   Materiales Locales",{"$nulls":3},0]
[null,"   Mano de Obra Calificada",{"$nulls":3},0]
[null,"   Mano de Obra Semicalificada",{"$nulls":3},0]
[null,"   Mano de Obra No Calificada Urbana",{"$nulls":3},0]
[null,"   Mano de Obra No calificada Rural",{"$nulls":3},0]
[null,"Subtotal",null,null,0,0]
[null,"TOTAL COSTOS DE INVERSIÓN",null,null,0,0]
[]
[null,"IMPACTO AMBIENTAL",5000000,10000000,20000000,0]
[null,"   Costo de los Estudios de Impacto",null,null,0,0]
[null,"   Costo del Manejo del Impacto",null,null,0,0]
[null,"Subtotal",null,null,0,0]
[]
[null,"TOTAL COSTOS",null,null,0,0]
[]
[null,"VACP"]
[null,"VANP"]
[null,"CAEP",null,null,0]
[null,"TIRP"]
[null,"VAIP",{"$nulls":4},"B / C",0]
[]
[null,"FLUJO DE FONDOS"]
[{"$nulls":4},"Años"]
[{"$nulls":4},0,"Total"]
[{"$nulls":4},2008]
[null,"Total Ingresos",null,null,0,0]
[]
[null,"Total Costos de Operación",null,null,0,0]
[null,"Depreciación (+)",{"$nulls":3},0]
[null,"Costos Financieros (Intereses)",{"$nulls":3},0]
[null,"Subtotal",null,null,0,0]
[]
[null,"Costos de Administración",null,null,0,0]
[]
[null,"Impuestos",null,null,0,0]
[]
[null,"Total Costos de Inversión",null,null,0,0]
[null,"Depreciación (-)",null,null,0,0]
[null,"Amortización (+)",{"$nulls":3},0]
[null,"Préstamo(-) Escribir valores con signo Negativo",{"$nulls":3},0]
[null,"Subtotal",null,null,0,0]
[]
[null,"Costos de Impacto Ambiental",null,null,0,0]
[]
[null,"Total Costos ",null,null,0,0]
[null,"Valor de Salvamento",{"$nulls":3},0]
[null,"Flujo de Fondos Neto",null,null,0,0]

{"sheet":"EVALUACIÓN SOCIOECONÓMICA","index":4,"n_rows":147,"n_cols":7,"rows_kept":147,"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],[18,1,20,2],[18,3,18,4],[19,4,20,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],[29,1,29,2],[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],[47,1,47,2],[48,1,48,2],[49,1,49,2],[50,1,50,2],[51,1,51,2],[52,1,52,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],[60,1,60,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],[68,1,68,2],[69,1,69,2],[70,1,70,2],[73,1,73,2],[74,1,74,2],[75,1,75,2],[76,1,76,2],[77,1,77,2],[78,1,78,2],[79,1,79,2],[80,1,80,2],[82,1,82,2],[84,1,84,2],[85,1,85,2],[86,1,86,2],[87,1,87,2],[88,1,88,2],[89,1,89,2],[90,1,90,2],[92,1,92,2],[93,1,93,2],[94,1,94,2],[95,1,95,2],[96,1,96,2],[97,1,97,2],[98,1,98,2],[100,1,100,2],[101,1,101,2],[102,1,102,2],[103,1,103,2],[104,1,104,2],[105,1,105,2],[106,1,106,2],[108,1,108,2],[109,1,109,2],[110,1,110,2],[111,1,111,2],[112,1,112,2],[113,1,113,2],[114,1,114,2],[116,1,116,2],[117,1,117,2],[118,1,118,2],[119,1,119,2],[120,1,120,2],[121,1,121,2],[122,1,122,2],[124,1,124,2],[125,1,125,2],[126,1,126,2],[127,1,127,2],[128,1,128,2],[129,1,129,2],[130,1,130,2],[131,1,131,2],[134,1,134,2],[135,1,135,2],[136,1,136,2],[138,1,138,2],[140,1,140,2],[142,1,142,2],[143,1,143,2],[144,1,144,2],[145,1,145,2],[146,1,146,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,"COSTOS DEL PROYECTO"]
[null,"Unidad Monetaria","Dólares"]
[{"$nulls":3},{"v":1,"d":"100.00%"},{"v":1,"d":"100.00%"}]
[null,"Componentes",null,"Años"]
[{"$nulls":3},0,"Total"]
[{"$nulls":3},2008]
[null,"COSTOS DE OPERACIÓN"]
[null,"CAPTACIÓ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,"Subtotal",null,0,0]
[null,"ADUCCIÓ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,"Subtotal",null,0,0]
[null,"TRATAMIENTO"]
[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,"Subtotal",null,0,0]
[null,"ALMACENAMIENTO"]
[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,"Subtotal",null,0,0]
[null,"DISTRIBUCIÓ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,"Subtotal",null,0,0]
[null,"CONEXIONES DOMICILIARIAS"]
[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,"Subtotal",null,0,0]
[null,"TOTAL COSTOS DE OPERACIÓN",null,0,0]
[]
[null,"COSTOS DE ADMINISTRACIÓ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,"Subtotal",null,0,0]
[null,"TOTAL COSTOS DE ADMINIST.",null,0,0]
[]
[null,"COSTOS DE INVERSIÓN"]
[null,"CAPTACIÓ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,"Subtotal",null,0,0]
[null,"ADUCCIÓ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,"Subtotal",null,0,0]
[null,"TRATAMIENTO"]
[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,"Subtotal",null,0,0]
[null,"ALMACENAMIENTO"]
[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,"Subtotal",null,0,0]
[null,"DISTRIBUCIÓ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,"Subtotal",null,0,0]
[null,"CONEXIONES DOMICILIARIAS"]
[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,"Subtotal",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 NETO DE FONDOS",null,0,0]
[]
[null,"VACS"]
[null,"VANS"]
[null,"CAES",null,0]
[null,"TIRS"]
[null,"VAIS",{"$nulls":3},"B / C",{"v":0,"d":"0.00"}]

{"sheet":"INDICADORES","index":5,"n_rows":51,"n_cols":26,"rows_kept":51,"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,15,2],[13,3,15,3],[13,4,14,5],[13,7,15,8],[13,9,15,9],[16,1,16,2],[16,7,16,8],[17,1,17,2],[17,7,17,8],[18,1,18,2],[18,7,18,8],[19,1,19,2],[19,7,19,8],[20,1,20,2],[21,1,21,2],[24,1,26,1],[24,2,24,9],[24,10,24,17],[24,18,24,25],[25,2,25,5],[25,6,25,9],[25,10,25,13],[25,14,25,17],[25,18,25,21],[25,22,25,25],[26,2,26,3],[26,4,26,5],[26,6,26,7],[26,8,26,9],[26,10,26,11],[26,12,26,13],[26,14,26,15],[26,16,26,17],[26,18,26,19],[26,20,26,21],[26,22,26,23],[26,24,26,25],[31,1,33,1],[31,2,31,9],[31,10,31,17],[31,18,31,25],[32,2,32,5],[32,6,32,9],[32,10,32,13],[32,14,32,17],[32,18,32,21],[32,22,32,25],[33,2,33,3],[33,4,33,5],[33,6,33,7],[33,8,33,9],[33,10,33,11],[33,12,33,13],[33,14,33,15],[33,16,33,17],[33,18,33,19],[33,20,33,21],[33,22,33,23],[33,24,33,25],[38,1,40,1],[38,2,38,9],[38,10,38,17],[38,18,38,25],[39,2,39,5],[39,6,39,9],[39,10,39,13],[39,14,39,17],[39,18,39,21],[39,22,39,25],[40,2,40,3],[40,4,40,5],[40,6,40,7],[40,8,40,9],[40,10,40,11],[40,12,40,13],[40,14,40,15],[40,16,40,17],[40,18,40,19],[40,20,40,21],[40,22,40,23],[40,24,40,25],[45,1,47,1],[45,2,45,9],[45,10,45,17],[45,18,45,25],[46,2,46,5],[46,6,46,9],[46,10,46,13],[46,14,46,17],[46,18,46,21],[46,22,46,25],[47,2,47,3],[47,4,47,5],[47,6,47,7],[47,8,47,9],[47,10,47,11],[47,12,47,13],[47,14,47,15],[47,16,47,17],[47,18,47,19],[47,20,47,21],[47,22,47,23],[47,24,47,25]],"flags":["formulas_cached_only"]}
[]
[]
[]
[null,"INDICADORES FINANCIEROS",{"$nulls":5},"INDICADORES SOCIOECONÓMICOS"]
[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 DE COSTO EFICIENCIA"]
[null,"Indicador",null,"Valor","Indicadores Estándar U.S.$",null,null,"Indicador",null,"Valor"]
[]
[{"$nulls":4},"Max","Min"]
[null,"CAEP / Beneficiario",null,{"v":0,"d":"0.00"},{"$nulls":3},"CAES / Beneficiarios",null,{"v":0,"d":"0.00"}]
[null,"CAEP / Area Beneficiada",null,{"v":0,"d":"0.00"},{"$nulls":3},"CAES / Area Beneficiada",null,{"v":0,"d":"0.00"}]
[null,"VACP / Beneficiarios",null,{"v":0,"d":"0.00"},312,95,null,"VACS / Conexiones",null,{"v":0,"d":"0.00"}]
[null,"VACP / Conexiones",null,{"v":0,"d":"0.00"},773,133,null,"VACS / Beneficiarios",null,{"v":0,"d":"0.00"}]
[null,"Costo Inversión/ Beneficiario",null,{"v":0,"d":"0.00"},281,64]
[null,"Costo Inversión/ Conexiónes",null,{"v":0,"d":"0.00"},655,113]
[]
[null,"OTROS INDICADORES ESTANDAR PARA PROYECTOS SIMILARES"]
[null,"Costo de Inversión / Beneficiarios","ALTIPLANO",{"$nulls":7},"VALLES",{"$nulls":7},"LLANOS"]
[null,null,"Urbano",{"$nulls":3},"Rural",{"$nulls":3},"Urbano",{"$nulls":3},"Rural",{"$nulls":3},"Urbano",{"$nulls":3},"Rural"]
[null,null,"Bombeo",null,"Gravedad",null,"Bombeo",null,"Gravedad",null,"Bombeo",null,"Gravedad",null,"Bombeo",null,"Gravedad",null,"Bombeo",null,"Gravedad",null,"Bombeo",null,"Gravedad"]
[null,"TIPO","Max","Min","Max","Min","Max","Min","Max","Min","Max","Min","Max","Min","Max","Min","Max","Min","Max","Min","Max","Min","Max","Min","Max","Min"]
[null,"Construcción",281,64,281,64,131,120,131,120,166,27,166,27,132,121,132,121,{"$nulls":4},138,119,138,119]
[null,"Mejoramiento",121,55,121,55,121,82,121,82,101,65,101,65,107,84,107,84,{"$nulls":4},214,83,214,83]
[]
[null,"Costo de Inversión / Conecciones","ALTIPLANO",{"$nulls":7},"VALLES",{"$nulls":7},"LLANOS"]
[null,null,"Urbano",{"$nulls":3},"Rural",{"$nulls":3},"Urbano",{"$nulls":3},"Rural",{"$nulls":3},"Urbano",{"$nulls":3},"Rural"]
[null,null,"Bombeo",null,"Gravedad",null,"Bombeo",null,"Gravedad",null,"Bombeo",null,"Gravedad",null,"Bombeo",null,"Gravedad",null,"Bombeo",null,"Gravedad",null,"Bombeo",null,"Gravedad"]
[null,"TIPO","Max","Min","Max","Min","Max","Min","Max","Min","Max","Min","Max","Min","Max","Min","Max","Min","Max","Min","Max","Min","Max","Min","Max","Min"]
[null,"Construcción",655,113,655,113,404,364,404,364,422,114,422,114,465,421,465,421,{"$nulls":4},585,494,585,494]
[null,"Mejoramiento",279,167,279,167,420,188,420,188,367,225,367,225,368,264,368,264,{"$nulls":4},804,453,804,453]
[]
[null,"VACP / Beneficiarios","ALTIPLANO",{"$nulls":7},"VALLES",{"$nulls":7},"LLANOS"]
[null,null,"Urbano",{"$nulls":3},"Rural",{"$nulls":3},"Urbano",{"$nulls":3},"Rural",{"$nulls":3},"Urbano",{"$nulls":3},"Rural"]
[null,null,"Bombeo",null,"Gravedad",null,"Bombeo",null,"Gravedad",null,"Bombeo",null,"Gravedad",null,"Bombeo",null,"Gravedad",null,"Bombeo",null,"Gravedad",null,"Bombeo",null,"Gravedad"]
[null,"TIPO","Max","Min","Max","Min","Max","Min","Max","Min","Max","Min","Max","Min","Max","Min","Max","Min","Max","Min","Max","Min","Max","Min","Max","Min"]
[null,"Construcción",312,95,312,95,153,143,153,143,183,45,183,45,155,144,155,144,{"$nulls":4},161,143,161,143]
[null,"Mejoramiento",137,70,137,70,139,101,139,101,116,79,116,79,124,101,124,101,{"$nulls":4},241,109,241,109]
[]
[null,"VACP / Conecciones","ALTIPLANO",{"$nulls":7},"VALLES",{"$nulls":7},"LLANOS"]
[null,null,"Urbano",{"$nulls":3},"Rural",{"$nulls":3},"Urbano",{"$nulls":3},"Rural",{"$nulls":3},"Urbano",{"$nulls":3},"Rural"]
[null,null,"Bombeo",null,"Gravedad",null,"Bombeo",null,"Gravedad",null,"Bombeo",null,"Gravedad",null,"Bombeo",null,"Gravedad",null,"Bombeo",null,"Gravedad",null,"Bombeo",null,"Gravedad"]
[null,"TIPO","Max","Min","Max","Min","Max","Min","Max","Min","Max","Min","Max","Min","Max","Min","Max","Min","Max","Min","Max","Min","Max","Min","Max","Min"]
[null,"Construcción",773,133,773,133,477,430,477,430,498,134,498,134,549,497,549,497,{"$nulls":4},690,583,690,583]
[null,"Mejoramiento",330,197,330,197,496,221,496,221,469,301,469,301,435,311,435,311,{"$nulls":4},949,535,949,535]

{"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":30,"n_cols":10,"rows_kept":30,"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,6,11,7],[13,6,13,7],[14,6,14,7],[15,6,15,7],[16,6,16,7],[18,6,18,7],[19,6,19,7],[20,6,20,7],[21,6,21,7],[22,6,22,7],[23,6,23,7],[25,6,25,7],[26,6,26,7],[27,6,27,7],[28,6,28,7],[29,6,29,7]],"flags":["formulas_cached_only"]}
[0]
[0]
[]
[null,"ANÁLISIS 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,"Beneficiarios",null,{"v":0,"d":"0.00"},{"v":1,"d":"100%"},null,"VANP",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,"CAEP",null,{"v":0,"d":"0.00"},{"v":0,"d":"0.00%"}]
[null,"Costos de Operacion",null,{"v":0,"d":"0.00"},{"v":1,"d":"100%"},null,"TIRP",null,{"v":0,"d":"0.00%"},{"v":0,"d":"0.00%"}]
[{"$nulls":6},"RBC Privado",null,{"v":0,"d":"0.00"},{"v":0,"d":"0.00%"}]
[]
[{"$nulls":6},"CAEP / Beneficiarios",null,{"v":0,"d":"0.00"},{"v":0,"d":"0.00%"}]
[{"$nulls":6},"CAEP / Area Beneficiada",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},"Indicador",null,"Valor","% de Cambio"]
[{"$nulls":6},"VACS",null,{"v":0,"d":"0.00"},{"v":0,"d":"0.00%"}]
[{"$nulls":6},"VANS",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},"TIRS",null,{"v":0,"d":"0.00%"},{"v":0,"d":"0.00%"}]
[{"$nulls":6},"RBC Social",null,{"v":0,"d":"0.00"},{"v":0,"d":"0.00%"}]
[]
[{"$nulls":6},"CAES / Beneficiarios",null,{"v":0,"d":"0.00"},{"v":0,"d":"0.00%"}]
[{"$nulls":6},"CAES / Area Beneficiada",null,{"v":0,"d":"0.00"},{"v":0,"d":"0.00%"}]
[{"$nulls":6},"VACS / Conexiones",null,{"v":0,"d":"0.00"},{"v":0,"d":"0.00%"}]
[{"$nulls":6},"VACS / 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%"}]

{"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"]