{"text_format":"3","workbook":"xls","n_sheets":10,"sheets":["INICIO","PREPARACION","ALTERNATIVAS","EVALUACION PRIVADA","EVALUACION SOCIOECONOMICA","INDICADORES","FUENTES DE FINANCIACION","ANALISIS DE SENSIBILIDAD","CONCLUSIONES Y RECOMENDACIONES","Module1"],"not_rendered":{"images":22,"macros":1,"external_links":2,"defined_names":359,"comments":73},"unopened":[{"sheet":"Module1","index":9,"reason":"not_a_worksheet"}],"read":"whole","date_system":"1900","formulas":"cached_only"}

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

{"sheet":"PREPARACION","index":1,"n_rows":274,"n_cols":23,"rows_kept":274,"merged":[[8,1,8,5],[17,2,17,3],[17,4,17,6],[19,5,19,6],[32,1,32,6],[34,4,34,5],[35,4,35,5],[37,4,37,5],[38,1,38,7],[49,4,49,5],[50,4,50,5],[57,4,57,5],[63,1,63,2],[63,3,63,4],[63,6,63,7],[64,1,64,2],[64,3,64,4],[64,6,64,7],[65,1,65,2],[65,3,65,4],[65,6,65,7],[66,1,66,2],[66,3,66,4],[66,6,66,7],[67,1,67,2],[67,3,67,4],[67,6,67,7],[68,1,68,2],[68,3,68,4],[68,6,68,7],[69,1,69,2],[69,3,69,4],[69,6,69,7],[70,1,70,2],[70,3,70,4],[70,6,70,7],[80,7,81,7],[80,9,81,9],[82,7,83,7],[82,9,83,9],[93,1,96,3],[93,4,93,5],[93,7,96,7],[94,4,96,4],[94,5,96,5],[97,1,97,3],[98,1,98,3],[99,1,99,3],[100,1,100,3],[101,1,101,3],[106,1,106,2],[106,7,106,8],[107,1,107,2],[107,7,107,8],[108,1,108,2],[108,7,108,8],[109,1,109,2],[109,7,109,8],[110,1,110,2],[110,7,110,8],[111,1,111,2],[111,7,111,8],[112,1,112,2],[112,7,112,8],[113,1,113,2],[113,7,113,8],[114,1,114,2],[114,7,114,8],[115,1,115,2],[115,7,115,8],[116,1,116,2],[119,1,119,3],[119,4,119,9],[120,1,120,3],[120,4,120,9],[121,1,121,3],[121,4,121,9],[122,1,122,3],[122,4,122,9],[123,1,123,3],[123,4,123,9],[124,1,124,3],[124,4,124,9],[125,1,125,3],[125,4,125,9],[126,1,126,3],[126,4,126,9],[127,1,127,3],[127,4,127,9],[128,1,128,3],[128,4,128,9],[131,1,131,3],[131,4,131,9],[132,1,132,3],[132,4,132,9],[133,1,133,3],[133,4,133,9],[134,1,134,3],[134,4,134,9],[135,1,135,3],[135,4,135,9],[136,1,136,3],[136,4,136,9],[137,1,137,3],[137,4,137,9],[138,1,138,3],[138,4,138,9],[139,1,139,3],[139,4,139,9],[140,1,140,3],[140,4,140,9],[142,7,143,9],[144,1,146,2],[144,3,144,7],[144,8,144,14],[145,3,146,3],[145,4,146,4],[145,5,146,5],[145,6,146,6],[145,7,146,7],[145,8,146,8],[145,9,146,9],[145,10,146,10],[145,11,146,11],[145,12,146,12],[145,13,146,13],[145,14,146,14],[147,1,147,2],[148,1,148,6],[149,8,150,9],[151,1,153,2],[151,3,151,7],[151,8,151,14],[152,3,153,3],[152,4,153,4],[152,5,153,5],[152,6,153,6],[152,7,153,7],[152,8,153,8],[152,9,153,9],[152,10,153,10],[152,11,153,11],[152,12,153,12],[152,13,153,13],[152,14,153,14],[154,1,154,2],[155,1,155,6],[156,7,157,9],[158,1,160,2],[158,3,158,7],[158,8,158,14],[159,3,160,3],[159,4,160,4],[159,5,160,5],[159,6,160,6],[159,7,160,7],[159,8,160,8],[159,9,160,9],[159,10,160,10],[159,11,160,11],[159,12,160,12],[159,13,160,13],[159,14,160,14],[161,1,161,2],[162,1,162,6],[165,1,167,2],[165,3,165,7],[165,8,165,14],[166,3,167,3],[166,4,167,4],[166,5,167,5],[166,6,167,6],[166,7,167,7],[166,8,167,8],[166,9,167,9],[166,10,167,10],[166,11,167,11],[166,12,167,12],[166,13,167,13],[166,14,167,14],[168,1,168,2],[169,1,169,6],[172,1,174,2],[172,3,172,7],[172,8,172,14],[173,3,174,3],[173,4,174,4],[173,5,174,5],[173,6,174,6],[173,7,174,7],[173,8,174,8],[173,9,174,9],[173,10,174,10],[173,11,174,11],[173,12,174,12],[173,13,174,13],[173,14,174,14],[175,1,175,2],[176,1,176,6],[179,1,181,2],[179,3,179,7],[179,8,179,14],[180,3,181,3],[180,4,181,4],[180,5,181,5],[180,6,181,6],[180,7,181,7],[180,8,181,8],[180,9,181,9],[180,10,181,10],[180,11,181,11],[180,12,181,12],[180,13,181,13],[180,14,181,14],[182,1,182,2],[183,1,183,6],[186,1,188,2],[186,3,186,7],[186,8,186,14],[187,3,188,3],[187,4,188,4],[187,5,188,5],[187,6,188,6],[187,7,188,7],[187,8,188,8],[187,9,188,9],[187,10,188,10],[187,11,188,11],[187,12,188,12],[187,13,188,13],[187,14,188,14],[189,1,189,2],[190,1,190,6],[193,1,195,2],[193,3,193,7],[193,8,193,14],[193,16,194,16],[193,17,194,17],[193,18,194,18],[193,19,194,19],[193,20,194,20],[193,21,194,21],[193,22,194,22],[194,3,195,3],[194,4,195,4],[194,5,195,5],[194,6,195,6],[194,7,195,7],[194,8,195,8],[194,9,195,9],[194,10,195,10],[194,11,195,11],[194,12,195,12],[194,13,195,13],[194,14,195,14],[196,1,196,2],[197,1,197,6],[199,1,199,6],[200,1,200,3],[200,4,200,6],[200,7,200,10],[201,1,203,3],[201,4,201,6],[202,4,202,6],[203,4,203,6],[204,1,206,3],[204,4,204,6],[205,4,205,6],[206,4,206,6],[247,1,248,2],[247,3,248,3],[247,4,248,4],[247,5,248,5],[247,6,248,6],[247,7,247,8],[247,10,248,10],[249,1,249,2],[249,10,250,10],[250,1,250,2],[251,1,251,2],[252,1,252,2],[253,1,253,2],[268,2,268,5],[268,8,268,11]],"flags":["formulas_cached_only"]}
[1,{"v":10990.72,"d":"10,990.72"},{"v":8864.37,"d":"8,864.37"}]
[null,497.15,327.85]
[]
[]
[]
[null,"PREPARACIÓN DEL PROYECTO"]
[]
[]
[null,"NOMBRE DEL PROYECTO"]
[]
[]
[]
[{"$nulls":6},1]
[null,"VIDA ÚTIL DEL PROYECTO",{"$nulls":3},1]
[null,"AÑOS QUE DURA LA INVERSIÓN",{"$nulls":3},1]
[null,"AÑO BASE (INICIO DEL PROYECTO)",{"$nulls":3},2008]
[]
[null,"REGIÓN","TOPOGRAFÍA",null,"TIPO DE INVERSIÓN"]
[]
[]
[null,"OBJETIVO"]
[]
[]
[]
[null,"UBICACIÓN"]
[]
[]
[]
[null,"POBLACIÓN Y/O ZONA AFECTADA"]
[]
[]
[]
[null,"ENTIDAD EJECUTORA DEL PROYECTO"]
[null,"NOMBRE DE LA INSTITUCIÓN"]
[]
[]
[]
[]
[null,"ENTIDAD RESPONSABLE DEL MANTENIMIENTO DE LA VIA"]
[null,"NOMBRE DE LA INSTITUCIÓN"]
{"$rows_empty":8}
[null,"LOCALIZACIÓN"]
[null,"MUNICIPIOS",null,null,"   DEPARTAMENTO"]
[]
[]
[]
[null,"COMUNIDAD(ES) Y/O ZONA(S)"]
[]
[]
[]
[]
[]
[]
[null,"CARACTERIZACIÓN"]
[]
[null,"OFERTA ACTUAL DE INFRAESTRUCTURA DE TRANSPORTE"]
[null,"Desde",null,"Hasta",null,"Distancia (km)","Tipo ",null,"Estado"]
{"$rows_empty":9}
[null,"DESCRIPCIÓN DE LA SITUACIÓN ACTUAL (SIN PROYECTO)"]
[]
[]
[]
[]
[]
[null,"SOLUCIÓN PROPUESTA (CON PROYECTO)"]
[{"$nulls":7},"Longitud del Camino (Km)",null,"Luz del Puente (mts)"]
[]
[]
[]
[]
[]
[null,"DESCRIPCIÓN DEL ÁREA DE INFLUENCIA"]
[]
[]
[]
[]
[]
[null,"PROYECCIONES DE DEMANDA VEHICULAR"]
[null,"Tipo de Vehículo",null,null,"Frecuencia Semanal",null,null,"Demanda Vehicular Incremental Semanal"]
[{"$nulls":4},"Sin Proyecto","Con Proyecto"]
[]
[]
[null,"Automóviles",{"$nulls":5},{"v":0,"d":"0.00"}]
[null,"Camionetas",{"$nulls":5},{"v":0,"d":"0.00"}]
[null,"Camión de dos Ejes",{"$nulls":5},{"v":0,"d":"0.00"}]
[null,"Minibus",{"$nulls":5},{"v":0,"d":"0.00"}]
[null,"Bus",{"$nulls":5},{"v":0,"d":"0.00"}]
[{"$nulls":7},{"v":0,"d":"0.00"}]
[null,"DIAGNÓSTICO SOCIOECONÓMICO"]
[]
[null,"POBLACIÓN AFECTADA"]
[null,"Nombre de la Localidad o Comunidad",null,"Número de Habitantes","Promedio Personas por Familia","Número de Familias","Tasa de Crecimiento Poblacional","Actividad Económica Principal"]
[{"$nulls":5},""]
[{"$nulls":5},""]
[{"$nulls":5},""]
[{"$nulls":5},""]
[{"$nulls":5},""]
[{"$nulls":5},""]
[{"$nulls":5},""]
[{"$nulls":5},""]
[{"$nulls":5},""]
[null,"Total Población",null,0,"Familias",0]
[]
[null,"ACCESO"]
[null,"Nombre Población",null,null,"Tipo de Acceso"]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[]
[null,"USO DEL SUELO"]
[null,"Nombre Población",null,null,"Uso Principal del Suelo"]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[]
[null,"PRODUCCION AGROPECUARIA  (Valores Anuales)",{"$nulls":5},"Para añadir productos al cuadro presione este botón"]
[null,"SITUACIÓN SIN PROYECTO - PRODUCCION AGRÍCOLA",{"$nulls":9},0]
[null,"Cultivos",null,"Ingresos",{"$nulls":4},"Costos de Producción"]
[{"$nulls":3},"Superficie Cultivada en Ha. ","Rendimiento Tm/Ha ","% Pérdidas Post Cosecha","Precio por Tonelada","Valor del Producto Marginal","Bienes Transables","Insumos Locales","Mano de Obra Calificada","Mano de Obra Semi Calificada","Mano de Obra No Calif. Urbana","Mano de Obra No Calif. Rural","Total Costos Producción"]
[]
[{"$nulls":7},{"v":0,"d":"0.00"},{"$nulls":6},{"v":0,"d":"0.00"}]
[null,"TOTAL",{"$nulls":5},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[{"$nulls":8},"Para añadir especies presione este botón"]
[null,"SITUACIÓN SIN PROYECTO - PRODUCCION PECUARIA Y PISCICOLA"]
[null,"Especies en Producción",null,"Ingresos",{"$nulls":4},"Costos de Producción"]
[{"$nulls":3},"Número de Cabezas o ejemplares","Porcentaje de Muertes","Precio por Cabeza o ejemplar","Período de Crianza o Engorde (Años)","Valor del Producto Marginal","Bienes Transables","Insumos Locales","Mano de Obra Calificada","Mano de Obra Semi Calificada","Mano de Obra No Calif. Urbana","Mano de Obra No Calif. Rural","Total Costos Producción"]
[]
[{"$nulls":7},{"v":0,"d":"0.00"},{"$nulls":6},{"v":0,"d":"0.00"}]
[null,"TOTAL",{"$nulls":5},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[{"$nulls":7},"Para añadir especies al cuadro presione este botón"]
[null,"SITUACIÓN SIN PROYECTO - PRODUCCIÓN AGROFORESTAL"]
[null,"Especies Maderables",null,"Ingresos",{"$nulls":4},"Costos de Producción"]
[{"$nulls":3},"Unidad     (Mt3, Pié/Tabla...)","Cantidad","Porcentaje de Pérdidas","Precio Unitario","Valor del Producto Marginal","Bienes Transables","Insumos Locales","Mano de Obra Calificada","Mano de Obra Semi Calificada","Mano de Obra No Calif. Urbana","Mano de Obra No Calif. Rural","Total Costos Producción"]
[]
[{"$nulls":7},{"v":0,"d":"0.00"},{"$nulls":6},{"v":0,"d":"0.00"}]
[null,"TOTAL",{"$nulls":5},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[]
[null,"SITUACIÓN SIN PROYECTO - SUBPRODUCTOS AGRICOLAS Y PRODUCTOS ARTESANALES"]
[null,"Subproductos Agrícolas o Productos Artesanales",null,"Ingresos",{"$nulls":4},"Costos de Producción"]
[{"$nulls":3},"Unidad","Cantidad","Porcentaje de Pérdidas o Autoconsumo","Precio Unitario","Valor del Producto Marginal","Bienes Transables","Insumos Locales","Mano de Obra Calificada","Mano de Obra Semi Calificada","Mano de Obra No Calif. Urbana","Mano de Obra No Calif. Rural","Total Costos Producción"]
[]
[{"$nulls":7},{"v":0,"d":"0.00"},{"$nulls":6},{"v":0,"d":"0.00"}]
[null,"TOTAL",{"$nulls":5},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[]
[null,"SITUACION CON PROYECTO - PRODUCCIÓN AGRICOLA"]
[null,"Cultivos",null,"Ingresos",{"$nulls":4},"Costos de Producción"]
[{"$nulls":3},"Superficie Cultivada en Ha. ","Rendimiento Tm/Ha ","% Pérdidas Post Cosecha","Precio por Tonelada","Valor del Producto Marginal","Bienes Transables","Insumos Locales","Mano de Obra Calificada","Mano de Obra Semi Calificada","Mano de Obra No Calif. Urbana","Mano de Obra No Calif. Rural","Total Costos Producción"]
[]
[null,"",{"$nulls":5},{"v":0,"d":"0.00"},{"$nulls":6},{"v":0,"d":"0.00"}]
[null,"TOTAL",{"$nulls":5},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[]
[null,"SITUACIÓN CON PROYECTO - PRODUCCION PECUARIA Y PISCICOLA"]
[null,"Especies en Producción",null,"Ingresos",{"$nulls":4},"Costos de Producción"]
[{"$nulls":3},"Número de Cabezas o ejemplares","Porcentaje de Muertes","Precio por Cabeza o ejemplar","Período de Crianza o Engorde (Años)","Valor del Producto Marginal","Bienes Transables","Insumos Locales","Mano de Obra Calificada","Mano de Obra Semi Calificada","Mano de Obra No Calif. Urbana","Mano de Obra No Calif. Rural","Total Costos Producción"]
[]
[null,"",{"$nulls":5},{"v":0,"d":"0.00"},{"$nulls":6},{"v":0,"d":"0.00"}]
[null,"TOTAL",{"$nulls":5},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[]
[null,"SITUACIÓN CON PROYECTO - PRODUCCIÓN AGROFORESTAL"]
[null,"Especies Maderables",null,"Ingresos",{"$nulls":4},"Costos de Producción"]
[{"$nulls":3},"Unidad     (Mt3, Pié/Tabla...)","Cantidad","Porcentaje de Pérdidas","Precio Unitario","Valor del Producto Marginal","Bienes Transables","Insumos Locales","Mano de Obra Calificada","Mano de Obra Semi Calificada","Mano de Obra No Calif. Urbana","Mano de Obra No Calif. Rural","Total Costos Producción"]
[]
[null,"",null,"",{"$nulls":3},{"v":0,"d":"0.00"},{"$nulls":6},{"v":0,"d":"0.00"}]
[null,"TOTAL",{"$nulls":5},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[]
[null,"SITUACIÓN CON PROYECTO - SUBPRODUCTOS AGRICOLAS Y PRODUCTOS ARTESANALES"]
[null,"Subproductos Agrícolas o Productos Artesanales",null,"Ingresos",{"$nulls":4},"Costos de Producción",{"$nulls":7},"Total Prod. Incremental","Bienes Transables","Materiales Locales","Mano de Obra Calif.","M. de Obra Semicalif.","M de Obra No Cal. Urb.","M de Obra No Cal. Rural"]
[{"$nulls":3},"Unidad","Cantidad","Porcentaje de Pérdidas o Autoconsumo","Precio Unitario","Valor del Producto Marginal","Bienes Transables","Insumos Locales","Mano de Obra Calificada","Mano de Obra Semi Calificada","Mano de Obra No Calif. Urbana","Mano de Obra No Calif. Rural","Total Costos Producción"]
[{"$nulls":16},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[null,"",null,"",{"$nulls":3},{"v":0,"d":"0.00"},{"$nulls":6},{"v":0,"d":"0.00"}]
[null,"TOTAL",{"$nulls":5},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[]
[null,"RELACIÓN ENTRE OBJETIVOS DEL PROYECTO Y OBJETIVOS DE PLANES DE DESARROLLO"]
[{"$nulls":4},"COMPONENTES DEL PLAN ",null,null,"COINCIDENCIA DEL PROYECTO CON LA POLITICA DEL PLAN"]
[null,"Plan de Desarrollo Municipal"]
[]
[]
[null,"Plan de Desarrollo Departamental"]
[]
[]
[]
[]
[null,"JUSTIFICACIÓN"]
{"$rows_empty":10}
[null,"ENTIDAD EJECUTORA"]
[]
[]
[]
[null,"DESCRIPCIÓN DE ORGANIZACIÓN PREVISTA PARA EJECUTAR EL PROYECTO"]
[]
[]
[]
[]
[]
[null,"FORTALEZAS INSTITUCIONALES"]
[]
[]
[]
[]
[]
[null,"DESCRIPCIÓN DE EXPERIENCIAS ANTERIORES"]
[]
[]
[]
[{"$nulls":3},false]
[]
[]
[]
[]
[]
[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},"Trans.","Perm."]
[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,"INFORMACIÓN ADICIONAL"]
{"$rows_empty":11}
[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":20,"n_cols":2,"rows_kept":20,"flags":["formulas_cached_only"]}
[]
[]
[]
[]
[]
[]
[null,"ALTERNATIVA DE SOLUCIÓN - INGENIERÍA DEL PROYECTO"]
[]
[]
[null,"DESCRIPCIÓN GENERAL"]
[]
[]
[]
[]
[null,"ASPECTOS TÉCNICOS"]
[]
[]
[]
[]
[null,"ASPECTOS OPERATIVOS"]

{"sheet":"EVALUACION PRIVADA","index":3,"n_rows":204,"n_cols":7,"rows_kept":204,"merged":[[9,1,9,3],[12,5,12,6],[16,1,18,2],[16,3,16,4],[17,4,18,4],[20,1,20,2],[21,1,21,2],[22,1,22,2],[23,1,23,2],[29,1,31,2],[29,3,29,4],[30,4,31,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],[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],[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],[54,1,54,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],[62,1,62,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],[71,1,71,2],[72,1,72,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],[81,1,81,2],[82,1,82,2],[83,1,83,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],[91,1,91,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],[99,1,99,2],[100,1,100,2],[101,1,101,2],[102,1,102,2],[105,1,105,2],[106,1,106,2],[107,1,107,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],[115,1,115,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],[123,1,123,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],[132,1,132,2],[133,1,133,2],[134,1,134,2],[135,1,135,2],[136,1,136,2],[137,1,137,2],[138,1,138,2],[139,1,139,2],[140,1,140,2],[141,1,141,2],[142,1,142,2],[143,1,143,2],[144,1,144,2],[145,1,145,2],[146,1,146,2],[147,1,147,2],[148,1,148,2],[149,1,149,2],[150,1,150,2],[151,1,151,2],[152,1,152,2],[153,1,153,2],[154,1,154,2],[155,1,155,2],[157,1,157,2],[158,1,158,2],[159,1,159,2],[160,1,160,2],[161,1,161,2],[162,1,162,2],[163,1,163,2],[164,1,164,2],[166,1,166,2],[167,1,167,2],[168,1,168,2],[170,1,170,2],[171,1,171,2],[173,1,173,2],[174,1,174,2],[175,1,175,2],[176,1,176,2],[177,1,177,2],[180,1,182,2],[180,3,180,4],[181,4,182,4],[183,1,183,2],[185,1,185,2],[187,1,187,2],[188,1,188,2],[189,1,189,2],[193,1,193,2],[194,1,194,2],[195,1,195,2],[196,1,196,2],[197,1,197,2],[199,1,199,2],[201,1,201,2],[202,1,202,2],[203,1,203,2]],"flags":["formulas_cached_only"]}
[null,false]
[]
[]
[]
[]
[null,"EVALUACIÓN PRIVADA"]
[]
[null,"INFORMACIÓN  GENERAL"]
[]
[null,"Tasa Privada de Descuento",null,null,{"v":0.1281,"d":"12.81%"}]
[]
[]
[null,"Unidad Monetaria","Dólares","Tipo de Cambio (Bs. por Dólar)",null,"Si escoge Bolivianos deberá proporcionar una Tasa de Cambio y modificar la Tasa Privada de Descuento"]
[]
[]
[null,"INGRESOS INCREMENTALES DEL PROYECTO"]
[null,"INGRESO POR VENTAS DE PRODUCTOS",null,"Años"]
[{"$nulls":3},0,"Total"]
[{"$nulls":3},2008]
[]
[null,"",null,0,0]
[null,"",null,0,0]
[null,"",null,0,0]
[null,"",null,0,0]
[null,"Otros Ingresos",null,0,0]
[null,"      Total ",null,0,0]
[]
[]
[null,"COSTOS INCREMENTALES DEL PROYECTO",null,null,{"v":1,"d":"100.00%"},{"v":1,"d":"100.00%"}]
[null,"Componentes de Inversión",null,"Años"]
[{"$nulls":3},0,"Total"]
[{"$nulls":3},2008]
[null,"INVERSION"]
[null,"COMPONENTE 1",null,0,0]
[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,"COMPONENTE 2",null,0,0]
[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,"COMPONENTE 3",null,0,0]
[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,"COMPONENTE 4",null,0,0]
[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,"COMPONENTE 5",null,0,0]
[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,"COMPONENTE 6",null,0,0]
[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,"COMPONENTE 7",null,0,0]
[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,"COMPONENTE 8",null,0,0]
[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,"COMPONENTE 9",null,0,0]
[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,"COMPONENTE 10",null,0,0]
[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,"OPERACION Y MANTENIMIENTO"]
[null,"COMPONENTE 1",null,0,0]
[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,"COMPONENTE 2",null,0,0]
[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,"COMPONENTE 3",null,0,0]
[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,"COMPONENTE 4",null,0,0]
[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,"COMPONENTE 5",null,0,0]
[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,"COMPONENTE 6",null,0,0]
[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,"COMPONENTE 7",null,0,0]
[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,"COSTOS DE PRODUCCIÓ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 PRODUCCIÓN",null,0,0]
[null,5000000,10000000]
[null,"IMPACTO AMBIENTAL",null,20000000,0]
[null,"   Costo de estudios del Impacto",null,0,0]
[null,"   Costo de mitigación del Impacto",null,0,0]
[null,null,"Subtotal",0,0]
[]
[null,"TOTAL",null,0,0]
[]
[null,"VACP",null,0]
[null,"VANP",null,0]
[null,"CAEP",null,0]
[null,"TIRP"]
[null,"VAIP",{"$nulls":3},"B / C",0]
[]
[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,"Total Costos de Producción",null,0,0]
[null,"Depreciación (+)",null,null,0]
[null,"Costos Financieros (Intereses)",null,null,0]
[null,"Subtotal",null,0,0]
[]
[null,"Impuesto a la Utilidad",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":"EVALUACION SOCIOECONOMICA","index":4,"n_rows":195,"n_cols":7,"rows_kept":195,"merged":[[8,1,8,2],[9,1,9,2],[10,1,10,2],[11,1,11,2],[12,1,12,2],[13,1,13,2],[19,1,21,2],[19,3,19,4],[20,4,21,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],[44,1,46,2],[44,3,44,4],[45,4,46,4],[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],[54,1,54,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],[62,1,62,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],[71,1,71,2],[72,1,72,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],[81,1,81,2],[82,1,82,2],[83,1,83,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],[91,1,91,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],[99,1,99,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],[107,1,107,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],[115,1,115,2],[116,1,116,2],[117,1,117,2],[120,1,120,2],[121,1,121,2],[122,1,122,2],[123,1,123,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],[132,1,132,2],[133,1,133,2],[134,1,134,2],[135,1,135,2],[136,1,136,2],[137,1,137,2],[138,1,138,2],[139,1,139,2],[140,1,140,2],[141,1,141,2],[142,1,142,2],[143,1,143,2],[144,1,144,2],[145,1,145,2],[146,1,146,2],[147,1,147,2],[148,1,148,2],[149,1,149,2],[150,1,150,2],[151,1,151,2],[152,1,152,2],[153,1,153,2],[154,1,154,2],[155,1,155,2],[156,1,156,2],[157,1,157,2],[158,1,158,2],[159,1,159,2],[160,1,160,2],[161,1,161,2],[162,1,162,2],[163,1,163,2],[164,1,164,2],[165,1,165,2],[166,1,166,2],[167,1,167,2],[168,1,168,2],[169,1,169,2],[170,1,170,2],[172,1,172,2],[173,1,173,2],[174,1,174,2],[175,1,175,2],[176,1,176,2],[177,1,177,2],[178,1,178,2],[179,1,179,2],[181,1,181,2],[182,1,182,2],[183,1,183,2],[185,1,185,2],[186,1,186,2],[188,1,188,2],[190,1,190,2],[191,1,191,2],[192,1,192,2],[193,1,193,2],[194,1,194,2]],"flags":["formulas_cached_only"]}
[]
[]
[]
[]
[]
[null,"EVALUACIÓN SOCIOECONÓMICA"]
[]
[null,"INFORMACIÓN  GENERAL"]
[null,"RPC Divisa",null,1.24]
[null,"RPC Mano de Obra no Calificada Urbana",null,0.23]
[null,"RPC Mano de Obra no Calificada Rural",null,0.47]
[null,"RPC Mano de Obra Semicalificada",null,0.43]
[null,"RPC Mano de Obra Calificada",null,{"v":1,"d":"1.00"}]
[null,"Tasa Social de Descuento",null,{"v":0.1267,"d":"12.67%"}]
[]
[null,"Unidad Monetaria","Dólares"]
[]
[]
[null,"IDENTIFICACIÓN DE BENEFICIOS DEL PROYECTO"]
[null,"BENEFICIOS POR PRODUCCIÓN",null,"Años"]
[{"$nulls":3},0,"Total"]
[{"$nulls":3},2008]
[]
[null,"",null,0,0]
[null,"",null,0,0]
[null,"",null,0,0]
[null,"",null,0,0]
[null,"Otros Beneficios",null,0,0]
[null,"      Total ",null,0,0]
[]
[]
[null,"IDENTIFICACIÓN DE EXTERNALIDADES POSITIVAS"]
{"$rows_empty":11}
[null,"COSTOS DEL PROYECTO"]
[null,"Componentes de Inversión",null,"Años"]
[{"$nulls":3},0,"Total"]
[{"$nulls":3},2008]
[null,"INVERSION"]
[null,"COMPONENTE 1",null,0,0]
[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,"COMPONENTE 2",null,0,0]
[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,"COMPONENTE 3",null,0,0]
[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,"COMPONENTE 4",null,0,0]
[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,"COMPONENTE 5",null,0,0]
[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,"COMPONENTE 6",null,0,0]
[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,"COMPONENTE 7",null,0,0]
[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,"COMPONENTE 8",null,0,0]
[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,"COMPONENTE 9",null,0,0]
[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,"COMPONENTE 10",null,0,0]
[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,"OPERACION Y MANTENIMIENTO"]
[null,"COMPONENTE 1",null,0,0]
[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,"COMPONENTE 2",null,0,0]
[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,"COMPONENTE 3",null,0,0]
[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,"COMPONENTE 4",null,0,0]
[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,"COMPONENTE 5",null,0,0]
[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,"COMPONENTE 6",null,0,0]
[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,"COMPONENTE 7",null,0,0]
[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,"COSTOS DE PRODUCCIÓ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 PRODUCCIÓN",null,0,0]
[]
[null,"IMPACTO AMBIENTAL"]
[null,"   Costo de estudios del Impacto",null,0,0]
[null,"   Costo de mitigación del Impacto",null,0,0]
[null,null,"Subtotal",0,0]
[]
[null,"TOTAL",null,0,0]
[]
[null,"FLUJO DE FONDOS NETO",null,0,0]
[]
[null,"VACS",null,0]
[null,"VANS",null,0]
[null,"CAES",null,0]
[null,"TIRS"]
[null,"VAIS",{"$nulls":3},"B / C",0]

{"sheet":"INDICADORES","index":5,"n_rows":41,"n_cols":20,"rows_kept":41,"merged":[[7,1,8,2],[7,3,8,3],[7,7,8,8],[7,9,8,9],[9,1,9,2],[9,7,9,8],[10,1,10,2],[10,7,10,8],[11,1,11,2],[11,7,11,8],[13,1,13,2],[13,7,13,8],[16,1,18,2],[16,3,18,3],[16,4,17,5],[16,7,18,8],[16,9,18,9],[19,1,19,2],[19,7,19,8],[20,1,20,2],[20,7,20,8],[21,1,21,2],[21,7,21,8],[24,1,25,1],[24,2,24,7],[24,8,24,13],[24,14,24,19],[25,2,25,3],[25,4,25,5],[25,6,25,7],[25,8,25,9],[25,10,25,11],[25,12,25,13],[25,14,25,15],[25,16,25,17],[25,18,25,19],[33,1,34,1],[33,2,33,7],[33,8,33,13],[33,14,33,19],[34,2,34,3],[34,4,34,5],[34,6,34,7],[34,8,34,9],[34,14,34,15]],"flags":["formulas_cached_only"]}
[]
[]
[]
[]
[null,"RESUMEN INDICADORES"]
[]
[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,"CAEP / Población",null,{"v":0,"d":"0.00"},"…","…",null,"CAES / Población",null,{"v":0,"d":"0.00"}]
[null,"Costo de Inversión / Kilómetro",null,{"v":0,"d":"0.00"},{"v":10990.72,"d":"10,991"},{"v":8864.37,"d":"8,864"},null,"Inversión Social por Kilómetro",null,{"v":0,"d":"0.00"}]
[null,"Costo de Inversión / Familia",null,{"v":0,"d":"0.00"},{"v":497.15,"d":"497"},{"v":327.85,"d":"328"},null,"Inversión Social por Familia",null,{"v":0,"d":"0.00"}]
[]
[null,"OTROS INDICADORES ESTANDAR PARA PROYECTOS SIMILARES"]
[null,"Costo de Inv / Km o Metro","ALTIPLANO",{"$nulls":5},"VALLES",{"$nulls":5},"LLANOS"]
[null,null,"Planicies",null,"Serranías",null,"Llanuras",null,"Planicies",null,"Serranías",null,"Llanuras",null,"Planicies",null,"Serranías",null,"Llanuras"]
[null,"TIPO","Max","Min","Max","Min","Max","Min","Max","Min","Max","Min","Max","Min","Max","Min","Max","Min","Max","Min"]
[null,"Construcción",{"v":21252.08,"d":"21,252.08"},{"v":16741.95,"d":"16,741.95"},{"v":21252.08,"d":"21,252.08"},{"v":16741.95,"d":"16,741.95"},{"v":21252.08,"d":"21,252.08"},{"v":16741.95,"d":"16,741.95"},{"v":25263.35,"d":"25,263.35"},{"v":19994.45,"d":"19,994.45"},{"v":25263.35,"d":"25,263.35"},{"v":19994.45,"d":"19,994.45"},{"v":25263.35,"d":"25,263.35"},{"v":19994.45,"d":"19,994.45"},{"v":21947.68,"d":"21,947.68"},{"v":16955.82,"d":"16,955.82"},{"v":21947.68,"d":"21,947.68"},{"v":16955.82,"d":"16,955.82"},{"v":21947.68,"d":"21,947.68"},{"v":16955.82,"d":"16,955.82"}]
[null,"Mejoramiento",{"v":10990.72,"d":"10,990.72"},{"v":8864.37,"d":"8,864.37"},{"v":10990.72,"d":"10,990.72"},{"v":8864.37,"d":"8,864.37"},{"v":10990.72,"d":"10,990.72"},{"v":8864.37,"d":"8,864.37"},{"v":11537.47,"d":"11,537.47"},{"v":9553.19,"d":"9,553.19"},{"v":11537.47,"d":"11,537.47"},{"v":9553.19,"d":"9,553.19"},{"v":11537.47,"d":"11,537.47"},{"v":9553.19,"d":"9,553.19"},{"v":9994.11,"d":"9,994.11"},{"v":7735.77,"d":"7,735.77"},{"v":9994.11,"d":"9,994.11"},{"v":7735.77,"d":"7,735.77"},{"v":9994.11,"d":"9,994.11"},{"v":7735.77,"d":"7,735.77"}]
[null,"Puntos y Tramos","…","…","…","…","…","…","…","…","…","…","…","…","…","…","…","…","…","…"]
[null,"Puentes Vehiculares","2,606.85","2,331.67","2,606.85","2,331.67","2,606.85","2,331.67","2,606.85","2,331.67","2,606.85","2,331.67","2,606.85","2,331.67","2,606.85","2,331.67","2,606.85","2,331.67","2,606.85","2,331.67"]
[null,"Puentes Peatonales","1,023.93","800.47","1,023.93","800.47","1,023.93","800.47","1,023.93","800.47","1,023.93","800.47","1,023.93","800.47","1,023.93","800.47","1,023.93","800.47","1,023.93","800.47"]
[]
[null,"Costo de Inv / Familia","ALTIPLANO",{"$nulls":5},"VALLES",{"$nulls":5},"LLANOS"]
[null,null,"Planicies",null,"Serranías",null,"Llanuras",null,"Planicies",null,"Serranías",null,"Llanuras",null,"Planicies",null,"Serranías",null,"Llanuras"]
[null,"TIPO","Max","Min","Max","Min","Max","Min","Max","Min","Max","Min","Max","Min","Max","Min","Max","Min","Max","Min"]
[null,"Construcción",{"v":1011.95,"d":"1,011.95"},421.47,{"v":1011.95,"d":"1,011.95"},421.47,{"v":1011.95,"d":"1,011.95"},421.47,{"v":1608.9,"d":"1,608.90"},457.86,{"v":1608.9,"d":"1,608.90"},457.86,{"v":1608.9,"d":"1,608.90"},457.86,{"v":2004.08,"d":"2,004.08"},592.56,{"v":2004.08,"d":"2,004.08"},592.56,{"v":2004.08,"d":"2,004.08"},592.56]
[null,"Mejoramiento",497.15,327.85,497.15,327.85,497.15,327.85,719.25,485.39,719.25,485.39,719.25,485.39,{"v":1215.27,"d":"1,215.27"},803.01,{"v":1215.27,"d":"1,215.27"},803.01,{"v":1215.27,"d":"1,215.27"},803.01]
[null,"Puntos y Tramos","…","…","…","…","…","…","…","…","…","…","…","…","…","…","…","…","…","…"]
[null,"Puentes Vehiculares","257.55","175.59","257.55","175.59","257.55","175.59","257.55","175.59","257.55","175.59","257.55","175.59","257.55","175.59","257.55","175.59","257.55","175.59"]
[null,"Puentes Peatonales","435.13","424.99","435.13","424.99","435.13","424.99","435.13","424.99","435.13","424.99","435.13","424.99","435.13","424.99","435.13","424.99","435.13","424.99"]

{"sheet":"FUENTES DE FINANCIACION","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",{"$nulls":7},"Deuda Consesional"]
[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":"ANALISIS DE SENSIBILIDAD","index":7,"n_rows":22,"n_cols":13,"rows_kept":22,"merged":[[5,7,6,10],[5,11,6,11],[5,12,6,12],[7,7,7,10],[8,1,9,2],[8,3,9,3],[8,4,9,4],[8,5,9,5],[8,7,8,10],[9,7,9,10],[10,1,10,2],[10,7,10,10],[11,1,11,2],[11,7,11,10],[12,1,12,2],[12,7,12,10],[13,1,13,2],[13,7,13,10],[15,7,15,10],[16,1,17,2],[16,3,17,3],[16,4,17,4],[16,7,16,10],[17,7,17,10],[18,1,18,2],[18,7,18,10],[19,1,19,2],[19,7,19,10],[20,1,20,2],[20,7,20,10],[21,1,21,2],[21,7,21,10]],"flags":["formulas_cached_only"]}
[null,{"v":0,"d":"0.00%"}]
[null,{"v":0,"d":"0.00%"}]
[]
[]
[]
[null,"ANÁLISIS DE SENSIBILIDAD",{"$nulls":5},"Indicador",{"$nulls":3},"Valor","% de Cambio"]
[]
[{"$nulls":7},"VACP",{"$nulls":3},{"v":0,"d":"0.00"},{"v":0,"d":"0.00%"}]
[null,"Variables",null,"Valor Actual","Nuevo Valor ($)","Nuevo Valor %",null,"VANP",{"$nulls":3},{"v":0,"d":"0.00"},{"v":0,"d":"0.00%"}]
[{"$nulls":7},"CAEP",{"$nulls":3},{"v":0,"d":"0.00"},{"v":0,"d":"0.00%"}]
[null,"Costos de Inversión",null,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":1,"d":"100%"},null,"TIRP",{"$nulls":3},{"v":0,"d":"0.00%"},{"v":0,"d":"0.00%"}]
[null,"Costos de Operac. y Mant.",null,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":1,"d":"100%"},null,"CAEP / Población",{"$nulls":3},{"v":0,"d":"0.00"},{"v":0,"d":"0.00%"}]
[null,"Longitud del Camino",null,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":1,"d":"100%"},null,"Costo de Inversión / Kilómetro",{"$nulls":3},{"v":0,"d":"0.00"},{"v":0,"d":"0.00%"}]
[null,"Familias Beneficiadas",null,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":1,"d":"100%"},null,"Costo de Inversión por Familia",{"$nulls":3},{"v":0,"d":"0.00"},{"v":0,"d":"0.00%"}]
[]
[null,null,6,{"$nulls":4},"VACS",{"$nulls":3},{"v":0,"d":"0.00"},{"v":0,"d":"0.00%"}]
[null,"Precios de Productos",null,"Valor Actual","Nuevo Valor %",null,null,"VANS",{"$nulls":3},{"v":0,"d":"0.00"},{"v":0,"d":"0.00%"}]
[{"$nulls":7},"CAES",{"$nulls":3},{"v":0,"d":"0.00"},{"v":0,"d":"0.00%"}]
[1,"",null,{"v":0,"d":"0.00"},{"v":1,"d":"100%"},null,null,"TIRS",{"$nulls":3},{"v":0,"d":"0.00%"},{"v":0,"d":"0.00%"}]
[1,"",null,{"v":0,"d":"0.00"},{"v":1,"d":"100%"},null,null,"CAES / Población",{"$nulls":3},{"v":0,"d":"0.00"},{"v":0,"d":"0.00%"}]
[1,"",null,{"v":0,"d":"0.00"},{"v":1,"d":"100%"},null,null,"Inversión Social por Kilómetro",{"$nulls":3},{"v":0,"d":"0.00"},{"v":0,"d":"0.00%"}]
[1,"",null,{"v":0,"d":"0.00"},{"v":1,"d":"100%"},null,null,"Inversión Social por Familia",{"$nulls":3},{"v":0,"d":"0.00"},{"v":0,"d":"0.00%"}]

{"sheet":"CONCLUSIONES Y RECOMENDACIONES","index":8,"n_rows":45,"n_cols":2,"rows_kept":45,"merged":[[30,3,30,4]],"flags":["formulas_cached_only"]}
[]
[]
[]
[]
[null,"CONCLUSIONES Y RECOMENDACIONES"]
[]
[]
[null,"NOMBRE DEL PROYECTO"]
[]
[]
[]
[]
[null,"RECOMENDACIÓN"]
{"$rows_empty":7}
[null,"JUSTIFICACIÓN"]
{"$rows_empty":9}
[null,"FECHA DE ELABORACIÓN"]
[]
[]
[null,"RESPONSABLE"]
[null,"NOMBRE"]
[]
[]
[null,"CARGO"]
[]
[]
[]
[]
[]
[]
[null,"Firma"]