{"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":19,"macros":1,"external_links":2,"defined_names":525,"comments":34},"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":117,"n_cols":12,"rows_kept":117,"merged":[[5,1,5,3],[9,1,9,4],[10,1,10,4],[11,1,11,10],[15,6,16,7],[18,6,18,7],[18,8,18,9],[21,1,21,2],[27,1,27,2],[27,3,27,10],[28,1,28,2],[28,3,28,10],[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],[65,1,65,4],[66,1,66,3],[66,6,66,8],[67,1,67,3],[67,6,67,8],[68,1,68,3],[68,6,68,8],[69,1,69,3],[72,1,72,3],[72,6,72,8],[73,1,73,3],[73,6,73,8],[74,1,74,3],[74,6,74,8],[75,1,75,3],[75,6,75,8],[76,1,76,3],[76,6,76,8],[77,1,77,3],[78,6,79,8],[78,9,79,9],[78,10,79,10],[82,1,82,6],[82,7,82,10],[83,1,85,3],[83,4,83,6],[83,7,83,10],[84,4,84,6],[84,7,84,10],[85,4,85,6],[85,7,85,10],[86,1,88,3],[86,4,86,6],[86,7,86,10],[87,4,87,6],[87,7,87,10],[88,4,88,6],[88,7,88,10],[89,1,91,3],[89,4,89,6],[89,7,89,10],[90,4,90,6],[90,7,90,10],[91,4,91,6],[91,7,91,10],[100,1,101,2],[100,3,101,3],[100,4,101,4],[100,5,101,5],[100,6,101,6],[100,7,100,8],[100,10,101,10],[102,1,102,2],[102,10,103,10],[103,1,103,2],[104,1,104,2],[105,1,105,2],[106,1,106,2],[111,2,111,5],[111,8,111,11]],"flags":["formulas_cached_only"]}
[null,0,0,{"$error":"#REF!"},{"$error":"#REF!"}]
[null,0,0]
[null,0,0]
[null,"PREPARACIÓN DEL PROYECTO",{"$nulls":4},2]
[]
[null," NOMBRE DEL PROYECTO"]
[]
[]
[]
[null,"NÚMERO DE AÑOS QUE DURA EL PROYECTO",{"$nulls":3},1,null,null,"AÑO BASE",2008]
[null,"NÚMERO 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"]
[{"$nulls":6},"REGIÓN"]
[null,null,"Recolección"]
[null,null,"Barrido",{"$nulls":3},0]
[null,null,"Disposición Final",{"$nulls":3},"AREA",null,"TIPO DE INVERSION"]
[{"$nulls":6},1,null,3]
[]
[null,"ANTECEDENTES"]
[]
[]
[]
[]
[]
[null,"Entidad Ejecutora"]
[null,"Entidad Operadora"]
[]
[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,"SERVICIOS PÚBLICOS EN EL MUNICIPIO",{"$nulls":4},"CLIMATOLOGÍA"]
[null,"Cobertura Agua Potable",{"$nulls":4},"Temperatura Promedio",{"$nulls":3},"º C"]
[null,"Cobertura Alcantarillado",{"$nulls":4},"Altura sobre el Nivel del Mar",{"$nulls":3},"m.s.n.m"]
[null,"Cobertura Energía Eléctrica",{"$nulls":4},"Volúmen de Lluvia Anual",{"$nulls":3},"mm."]
[null,"Cobertura Teléfono"]
[]
[null,"COMPOSICIÓN DE LOS RESIDUOS SÓLIDOS",{"$nulls":4},"DESCRIPCIÓN DE LA RED VIAL",null,null,"km","%"]
[null,"Residenciales",{"$nulls":4},"Longitud de la Red Vial Urbana",{"$nulls":3},{"v":1,"d":"100.00%"}]
[null,"Comerciales",{"$nulls":4},"Con Pavimento",{"$nulls":3},{"v":0,"d":"0.00%"}]
[null,"Industriales",{"$nulls":4},"Empedrados",{"$nulls":3},{"v":0,"d":"0.00%"}]
[null,"Residuos Peligrosos",{"$nulls":4},"Adoquinados",{"$nulls":3},{"v":0,"d":"0.00%"}]
[null,"Otros",{"$nulls":4},"kms de Pavimento que se barren Actualmente",{"$nulls":3},{"v":0,"d":"0.00%"}]
[null,"TOTAL",null,null,{"v":0,"d":"0%"},{"v":1,"d":"100%"}]
[{"$nulls":6},"Barrido Adicional con Proyecto en Kilómetros",{"$nulls":3},{"v":0,"d":"0.00%"}]
[]
[]
[null,"RELACIÓN DEL OBJETIVO DEL PROYECTO Y PLANES DE SANEAMIENTO BÁSICO"]
[null,"COMPONENTES DEL PLAN",{"$nulls":5},"RELACION DEL PROYECTO"]
[null,"Plan Local"]
[]
[]
[null,"Planes o Programas Departamentales"]
[]
[]
[null,"Plan Sectorial (Nacional)"]
[]
[]
[]
[null,"COINCIDENCIA DE LOS OBJETIVOS DEL PROYECTO CON LA POLITICA DEL PLAN"]
[]
[]
[]
[]
[]
[null,"ESTIMACIÓN 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,"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":121,"n_cols":7,"rows_kept":121,"merged":[[5,1,5,4],[8,2,8,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],[32,1,32,2],[33,1,33,2],[34,1,34,2],[35,1,35,2],[36,1,36,2],[37,1,37,2],[38,1,38,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],[48,1,48,2],[49,1,49,2],[50,1,50,2],[51,1,51,2],[52,1,52,2],[53,1,53,2],[54,1,54,2],[55,1,55,2],[57,1,57,2],[59,1,59,2],[60,1,60,2],[61,1,61,2],[62,1,62,2],[63,1,63,2],[64,1,64,2],[65,1,65,2],[67,1,67,2],[68,1,68,2],[69,1,69,2],[70,1,70,2],[71,1,71,2],[72,1,72,2],[73,1,73,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],[81,1,81,2],[82,1,82,2],[85,1,85,2],[86,1,86,2],[87,1,87,2],[89,1,89,2],[91,1,91,2],[92,1,92,2],[93,1,93,2],[94,1,94,2],[95,1,95,2],[98,1,100,2],[98,3,98,4],[99,4,100,4],[101,1,101,2],[103,1,103,2],[104,1,104,2],[105,1,105,2],[106,1,106,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],[118,1,118,2],[119,1,119,2],[120,1,120,2]],"flags":["formulas_cached_only"]}
[null,false]
[]
[]
[null,"EVALUACIÓN PRIVADA"]
[null,"PARÁMETROS PARA LA EVALUACIÓN"]
[null,"TASA DE DESCUENTO PRIVADA",{"$nulls":3},{"v":0.1281,"d":"12.81%"}]
[]
[null,"INGRESOS DEL PROYECTO",null,0.1281]
[null,"Unidad Monetaria",null,null,"Tipo de Cambio (Bs. por Dólar)"]
[{"$nulls":4},{"v":1,"d":"1.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,"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},2000]
[null,"COSTOS DE OPERACIÓN"]
[null,"BARRIDO"]
[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,"Subtotal",null,0,0]
[null,"RECOLECCIÓN Y TRANSPORTE"]
[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,"Subtotal",null,0,0]
[null,"DISPOSICIÓN FINAL"]
[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,"Subtotal",null,0,0]
[null,"TOTAL COSTOS DE OPERACIÓN",null,0,0]
[]
[null,"COSTOS DE INVERSIÓN"]
[null,"BARRIDO"]
[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,"Subtotal",null,0,0]
[null,"RECOLECCIÓN Y TRANSPORTE"]
[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,"Subtotal",null,0,0]
[null,"DISPOSICIÓN FINAL"]
[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,"Subtotal",null,0,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 el Valor 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":86,"n_cols":7,"rows_kept":86,"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],[17,1,19,2],[17,3,17,4],[18,4,19,4],[22,1,22,2],[23,1,23,2],[24,1,24,2],[25,1,25,2],[26,1,26,2],[27,1,27,2],[28,1,28,2],[30,1,30,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],[38,1,38,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],[49,1,49,2],[50,1,50,2],[51,1,51,2],[52,1,52,2],[53,1,53,2],[54,1,54,2],[55,1,55,2],[57,1,57,2],[58,1,58,2],[59,1,59,2],[60,1,60,2],[61,1,61,2],[62,1,62,2],[63,1,63,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],[71,1,71,2],[72,1,72,2],[75,1,75,2],[76,1,76,2],[77,1,77,2],[79,1,79,2],[81,1,81,2],[82,1,82,2],[83,1,83,2],[84,1,84,2],[85,1,85,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"]
[]
[null,"Componentes",null,"Años"]
[{"$nulls":3},0,"Total"]
[{"$nulls":3},2000]
[null,"COSTOS DE OPERACIÓN"]
[null,"BARRIDO"]
[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,"RECOLECCIÓN Y TRANSPORTE"]
[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,"DISPOSICIÓN FINAL"]
[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 INVERSIÓN"]
[null,"BARRIDO"]
[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,"RECOLECCIÓN Y TRANSPORTE"]
[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,"DISPOSICIÓN FINAL"]
[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,"VACS",null,{"v":0,"d":"0.00"}]
[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":45,"n_cols":14,"rows_kept":45,"merged":[[4,1,5,2],[4,3,5,3],[4,5,5,6],[4,7,5,7],[6,5,6,6],[7,5,7,6],[8,1,8,2],[8,5,8,6],[9,1,9,2],[9,5,9,6],[10,1,10,2],[10,5,10,6],[12,1,12,2],[12,5,12,6],[15,1,17,2],[15,3,17,3],[15,4,16,5],[18,1,18,2],[19,1,19,2],[20,1,20,2],[23,1,23,2],[25,1,26,1],[25,2,25,5],[25,6,25,9],[25,10,25,13],[26,2,26,3],[26,4,26,5],[26,6,26,7],[26,8,26,9],[26,10,26,11],[26,12,26,13],[32,1,33,1],[32,2,32,5],[32,6,32,9],[32,10,32,13],[33,2,33,3],[33,4,33,5],[33,6,33,7],[33,8,33,9],[33,10,33,11],[33,12,33,13],[39,1,40,1],[39,2,39,5],[39,6,39,9],[39,10,39,13],[40,2,40,3],[40,4,40,5],[40,6,40,7],[40,8,40,9],[40,10,40,11],[40,12,40,13]],"flags":["formulas_cached_only"]}
[]
[]
[]
[null,"INDICADORES FINANCIEROS",{"$nulls":3},"INDICADORES SOCIOECONOMICOS"]
[null,"Indicador",null,"Valor",null,"Indicador",null,"Valor"]
[]
[{"$nulls":5},"VACS",null,0]
[{"$nulls":5},"VANS",null,0]
[null,"VACP",null,{"v":0,"d":"0.00"},null,"VACS",null,{"v":0,"d":"0.00"}]
[null,"VANP",null,{"v":0,"d":"0.00"},null,"VANS",null,{"v":0,"d":"0.00"}]
[null,"CAEP",null,{"v":0,"d":"0.00"},null,"CAES",null,{"v":0,"d":"0.00"}]
[null,"TIRP",{"v":0.1,"d":"10%"},{"v":0,"d":"0.00%"},null,"TIRS",{"v":0.1,"d":"10%"},{"v":0,"d":"0.00%"}]
[null,"RBC Privado",null,{"v":0,"d":"0.00"},null,"RBC Social",null,{"v":0,"d":"0.00"}]
[]
[null,"INDICADORES DE COSTO - EFICIENCIA"]
[null,"Indicador",null,"Valor","Indicadores Estándar           U.S.$"]
[]
[{"$nulls":4},"Max","Min"]
[null,"CAES / Unidades Beneficiadas",null,0,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[null,"CAES / Km Barrido",null,0,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[null,"VACP / Unidades Beneficiadas",null,0,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[]
[]
[null,"CAEP",null,0,{"$error":"#REF!"},{"$error":"#REF!"}]
[null,"OTROS INDICADORES ESTANDAR PARA PROYECTOS SIMILARES"]
[null,"CAES / Beneficiarios","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"]
[null,"Ampliación"]
[null,"Mejoramiento"]
[]
[null,"CAES / Barrido","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"]
[null,"Ampliación"]
[null,"Mejoramiento"]
[]
[null,"VACP / Beneficiarios","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"]
[null,"Ampliación"]
[null,"Mejoramiento"]

{"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":19,"n_cols":10,"rows_kept":19,"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],[16,6,16,7],[17,6,17,7],[18,6,18,7]],"flags":["formulas_cached_only"]}
[null,0]
[]
[]
[null,"ANALISIS DE SENSIBILIDAD"]
[]
[null,"ESCENARIO 1"]
[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,"Unidades Beneficiadas",null,0,{"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 Operación",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},"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},"CAES / Unidades Beneficiadas",null,{"v":0,"d":"0.00"},{"v":0,"d":"0.00%"}]
[{"$nulls":6},"CAES / Barrido",null,{"v":0,"d":"0.00"},{"v":0,"d":"0.00%"}]
[{"$nulls":6},"VACP / Unidades Beneficiadas",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"]