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

{"sheet":"INICIO","index":0,"n_rows":15,"n_cols":1,"rows_kept":15,"flags":["formulas_cached_only"]}
[]
[]
[]
[]
["REPUBLICA DE BOLIVIA"]
["VICEMINISTERIO DE INVERSIONES PUBLICAS Y FINANCIAMIENTO"]
["EXTERNO DEL MINISTERIO DE HACIENDA DE BOLIVIA"]
[]
[]
["UNIVERSIDAD DE LOS ANDES"]
["FACULTAD DE ECONOMIA"]
["CENTRO DE ESTUDIOS SOBRE DESARROLLO ECONOMICO (CEDE)"]
[]
["METODOLOGIA DE PREPARACION Y EVALUACION DE PROYECTOS DE "]
["CONSTRUCCION DE CARRETERAS PAVIMENTADAS"]

{"sheet":"PREPARACION","index":1,"n_rows":347,"n_cols":15,"rows_kept":347,"merged":[[6,4,6,5],[7,1,7,5],[15,1,16,8],[22,1,22,3],[22,5,22,7],[28,1,28,6],[30,4,30,5],[31,4,31,5],[33,4,33,5],[34,1,34,6],[42,5,43,6],[42,7,43,7],[44,5,45,6],[44,7,45,7],[46,5,47,6],[46,7,47,7],[59,1,59,4],[59,5,59,10],[60,1,60,4],[60,5,60,10],[61,1,61,4],[61,5,61,10],[62,1,62,4],[62,5,62,10],[63,1,63,4],[63,5,63,10],[64,1,64,4],[64,5,64,10],[65,1,65,4],[65,5,65,10],[66,1,66,4],[66,5,66,10],[67,1,67,4],[67,5,67,10],[70,1,70,4],[70,5,70,10],[71,1,71,4],[71,5,71,10],[74,4,74,5],[74,8,74,9],[75,4,75,5],[75,8,75,9],[76,4,76,5],[76,8,76,9],[77,4,77,5],[77,8,77,9],[78,4,78,5],[78,8,78,9],[79,4,79,5],[79,8,79,9],[80,4,80,5],[80,8,80,9],[83,4,83,6],[84,4,84,6],[85,4,85,6],[89,1,89,3],[89,4,89,6],[89,7,89,8],[89,9,89,10],[90,1,90,3],[90,4,90,6],[90,7,90,8],[90,9,90,10],[91,1,91,3],[91,4,91,6],[91,7,91,8],[91,9,91,10],[92,1,92,3],[92,4,92,6],[92,7,92,8],[92,9,92,10],[93,1,93,3],[93,4,93,6],[93,7,93,8],[93,9,93,10],[94,1,94,3],[94,4,94,6],[94,7,94,8],[94,9,94,10],[95,1,95,3],[95,4,95,6],[95,7,95,8],[95,9,95,10],[96,1,96,3],[96,4,96,6],[96,7,96,8],[96,9,96,10],[106,1,106,12],[107,1,107,12],[108,1,108,12],[109,1,109,12],[110,1,110,12],[114,1,114,12],[115,1,115,12],[116,1,116,12],[117,1,117,12],[118,1,118,12],[121,1,121,12],[122,1,122,12],[123,1,123,12],[124,1,124,12],[125,1,125,12],[127,5,127,6],[129,5,129,6],[129,7,129,9],[131,5,131,6],[133,1,133,5],[134,1,134,2],[134,3,134,11],[135,1,135,2],[135,10,137,10],[135,11,137,11],[136,1,136,2],[137,1,137,2],[138,1,138,2],[142,1,142,3],[142,4,142,8],[142,9,142,10],[142,11,142,12],[143,1,143,3],[143,4,143,8],[143,9,143,10],[143,11,143,12],[144,1,144,3],[144,4,144,8],[144,9,144,10],[144,11,144,12],[145,1,145,3],[145,4,145,8],[145,9,145,10],[145,11,145,12],[146,1,146,3],[146,4,146,13],[148,4,148,5],[149,1,149,5],[150,1,150,4],[150,5,150,7],[150,8,150,10],[150,11,150,13],[151,1,151,4],[151,5,151,7],[151,8,151,10],[151,11,151,13],[152,1,152,4],[152,5,152,7],[152,8,152,10],[152,11,152,13],[153,1,153,4],[153,5,153,7],[153,8,153,10],[153,11,153,13],[154,1,154,4],[154,5,154,7],[154,8,154,10],[154,11,154,13],[155,1,155,4],[155,5,155,7],[155,8,155,10],[155,11,155,13],[156,1,156,4],[156,5,156,7],[156,8,156,10],[156,11,156,13],[157,1,157,4],[157,5,157,7],[157,8,157,10],[157,11,157,13],[158,1,158,4],[158,5,158,7],[158,8,158,10],[158,11,158,13],[159,1,159,4],[159,5,159,7],[159,8,159,10],[159,11,159,13],[160,1,160,4],[160,5,160,7],[160,8,160,10],[160,11,160,13],[161,1,161,4],[161,5,161,7],[161,8,161,10],[161,11,161,13],[162,1,162,4],[162,5,162,7],[162,8,162,10],[162,11,162,13],[163,1,163,4],[163,5,163,7],[163,8,163,10],[163,11,163,13],[164,1,164,4],[164,5,164,7],[164,8,164,10],[164,11,164,13],[165,1,165,4],[165,5,165,7],[165,8,165,10],[165,11,165,13],[166,1,166,4],[166,5,166,7],[166,8,166,10],[166,11,166,13],[167,4,167,5],[168,1,168,5],[169,1,169,2],[169,3,169,4],[169,5,169,6],[169,8,169,10],[169,11,169,12],[170,1,170,2],[170,3,170,4],[170,5,170,6],[170,8,170,10],[170,11,170,12],[171,1,171,2],[171,3,171,4],[171,5,171,6],[171,8,171,10],[171,11,171,12],[172,1,172,2],[172,3,172,4],[172,5,172,6],[172,8,172,10],[172,11,172,12],[173,1,173,2],[173,3,173,4],[173,5,173,6],[173,8,173,10],[173,11,173,12],[174,1,174,2],[174,3,174,4],[174,5,174,6],[174,8,174,10],[174,11,174,12],[175,1,175,2],[175,3,175,4],[175,5,175,6],[175,8,175,10],[175,11,175,12],[176,1,176,2],[176,3,176,4],[176,5,176,6],[176,8,176,10],[176,11,176,12],[177,1,177,2],[177,3,177,4],[177,5,177,6],[177,8,177,10],[177,11,177,12],[178,1,178,2],[178,3,178,4],[178,5,178,6],[178,8,178,10],[178,11,178,12],[179,1,179,2],[179,3,179,4],[179,5,179,6],[179,8,179,10],[179,11,179,12],[180,1,180,2],[180,3,180,4],[180,5,180,6],[180,8,180,10],[180,11,180,12],[181,1,181,2],[181,3,181,4],[181,5,181,6],[181,8,181,10],[181,11,181,12],[182,4,182,5],[183,1,183,5],[184,1,184,2],[184,3,184,5],[184,6,184,7],[184,8,184,9],[184,10,184,11],[184,12,184,13],[185,1,185,2],[185,3,185,5],[185,6,185,7],[185,8,185,9],[185,10,185,11],[185,12,185,13],[186,1,186,2],[186,3,186,5],[186,6,186,7],[186,8,186,9],[186,10,186,11],[186,12,186,13],[187,1,187,2],[187,3,187,5],[187,6,187,7],[187,8,187,9],[187,10,187,11],[187,12,187,13],[188,1,188,2],[188,3,188,5],[188,6,188,7],[188,8,188,9],[188,10,188,11],[188,12,188,13],[189,1,189,2],[189,3,189,5],[189,6,189,7],[189,8,189,9],[189,10,189,11],[189,12,189,13],[190,1,190,2],[190,3,190,5],[190,6,190,7],[190,8,190,9],[190,10,190,11],[190,12,190,13],[191,1,191,2],[191,3,191,5],[191,6,191,7],[191,8,191,9],[191,10,191,11],[191,12,191,13],[192,1,192,2],[192,3,192,5],[192,6,192,7],[192,8,192,9],[192,10,192,11],[192,12,192,13],[193,1,193,2],[193,3,193,5],[193,6,193,7],[193,8,193,9],[193,10,193,11],[193,12,193,13],[194,1,194,2],[194,3,194,5],[194,6,194,7],[194,8,194,9],[194,10,194,11],[194,12,194,13],[195,1,195,2],[195,3,195,5],[195,6,195,7],[195,8,195,9],[195,10,195,11],[195,12,195,13],[196,1,196,2],[196,3,196,5],[196,6,196,7],[196,8,196,9],[196,10,196,11],[196,12,196,13],[202,1,204,2],[202,3,204,5],[202,6,203,6],[202,7,203,7],[205,1,206,2],[205,3,206,5],[207,1,208,2],[207,3,208,5],[209,1,210,2],[209,3,210,5],[211,1,212,2],[211,3,212,5],[213,1,214,2],[213,3,214,5],[215,1,216,2],[215,3,216,5],[217,1,218,2],[217,3,218,5],[219,1,220,2],[219,3,220,5],[221,1,222,2],[221,3,222,5],[223,1,224,2],[223,3,224,5],[225,1,226,2],[225,3,226,5],[227,1,228,2],[227,3,228,5],[229,3,229,5],[231,1,233,2],[231,3,233,3],[231,4,233,5],[231,6,233,6],[231,7,233,7],[231,8,233,8],[231,9,233,9],[234,1,234,2],[234,4,234,5],[235,1,235,2],[235,4,235,5],[236,1,236,2],[236,4,236,5],[237,1,237,2],[237,4,237,5],[238,1,238,2],[238,4,238,5],[239,1,239,2],[239,4,239,5],[240,1,240,2],[240,4,240,5],[241,1,241,2],[241,4,241,5],[242,1,242,2],[242,4,242,5],[243,1,243,2],[243,4,243,5],[244,1,244,2],[244,4,244,5],[245,1,245,2],[245,4,245,5],[246,5,246,7],[248,1,250,2],[251,1,251,2],[252,1,252,2],[253,1,253,2],[254,1,254,2],[255,1,255,2],[256,1,256,2],[257,1,257,2],[258,1,258,2],[259,1,259,2],[260,1,260,2],[261,1,261,2],[262,1,262,2],[264,1,264,3],[288,1,288,3],[288,4,288,6],[288,7,288,8],[288,9,288,10],[288,11,288,12],[289,1,289,3],[289,4,289,6],[289,7,289,8],[289,9,289,10],[289,11,289,12],[290,1,290,3],[290,4,290,6],[290,7,290,8],[290,9,290,10],[290,11,290,12],[291,1,291,3],[291,4,291,6],[291,7,291,8],[291,9,291,10],[291,11,291,12],[292,1,292,3],[292,4,292,6],[292,7,292,8],[292,9,292,10],[292,11,292,12],[293,1,293,3],[293,4,293,6],[293,7,293,8],[293,9,293,10],[293,11,293,12],[294,1,294,3],[294,4,294,6],[294,7,294,8],[294,9,294,10],[294,11,294,12],[295,1,295,3],[295,4,295,6],[295,7,295,8],[295,9,295,10],[295,11,295,12],[296,1,296,3],[296,4,296,6],[296,7,296,8],[296,9,296,10],[296,11,296,12],[297,1,297,3],[297,4,297,6],[297,7,297,8],[297,9,297,10],[297,11,297,12],[298,1,298,3],[298,4,298,6],[298,7,298,8],[298,9,298,10],[298,11,298,12],[299,1,299,3],[299,4,299,6],[299,7,299,8],[299,9,299,10],[299,11,299,12],[300,1,300,3],[300,4,300,6],[300,7,300,8],[300,9,300,10],[300,11,300,12],[301,5,301,6],[301,7,301,8],[301,9,301,10],[301,11,301,12],[304,1,304,6],[304,7,304,12],[305,1,307,3],[305,4,305,6],[305,7,307,12],[306,4,306,6],[307,4,307,6],[308,1,310,3],[308,4,308,6],[308,7,310,12],[309,4,309,6],[310,4,310,6],[311,1,313,3],[311,4,311,6],[311,7,313,12],[312,4,312,6],[313,4,313,6],[320,1,321,2],[320,3,321,3],[320,4,321,4],[320,5,321,5],[320,6,321,6],[320,7,320,8],[320,10,321,11],[322,1,322,2],[322,10,323,11],[323,1,323,2],[324,1,324,2],[325,1,325,2],[326,1,326,2],[341,2,341,5],[341,8,341,11]],"flags":["formulas_cached_only"]}
[null,44.09,29.85,{"$error":"#REF!"},{"$error":"#REF!"}]
[null,171.92,143.53,{"$error":"#REF!"},{"$error":"#REF!"}]
[null,17.28,11.19,{"$error":"#REF!"},{"$error":"#REF!"}]
[null,3.18,1.88,{"$error":"#REF!"},{"$error":"#REF!"}]
[]
[{"$nulls":8}," "]
[{"$nulls":7},"Aspectos Generales del Proyecto"," "]
[null,"NOMBRE DEL PROYECTO",{"$nulls":5},"Diagnostico de la sitación actual","  "]
[]
[]
[{"$nulls":7},1]
[null,"AÑOS QUE DURA LA OPERACIÓN DEL PROYECTO",{"$nulls":5},1]
[null,"AÑOS QUE DURA LA INVERSIÓN",{"$nulls":5},1]
[null,"AÑO DE INICIO DEL PROYECTO",{"$nulls":5},2008]
[]
[null,"LLENE LA SECCION ANTERIOR Y OPRIMA EL BOTÓN ANTES DE CONTINUAR EL REGISTRO DE INFORMACIÓN"]
[]
[]
[null,"UBICACIÓN"]
[]
[]
[]
[null,"REGIÓN",{"$nulls":3},"AREA DE INFLUENCIA"]
[]
[]
[]
[]
[]
[null,"ENTIDAD EJECUTORA DEL PROYECTO"]
[null,"NOMBRE DE LA INSTITUCIÓN",{"$nulls":3},"DIRECCIÓN"]
[]
[]
[]
[]
[null,"ENTIDAD OPERADORA DEL SERVICIO"]
[null,"NOMBRE DE LA INSTITUCIÓN",{"$nulls":3},"DIRECCIÓN"]
[]
[]
[]
[]
[null,"TIPO DE PROYECTO"]
[]
[{"$nulls":5},"m2 de Construcción"]
[]
[{"$nulls":5},"m2 de Refacción"]
[]
[{"$nulls":5},"m2 Totales",null,0]
[]
[]
[]
[]
[]
[]
[null,"ORGANIZACIÓN COMUNITARIA Y TERRITORIAL"]
[]
[]
[]
[]
[null,"ASPECTOS DEMOGRÁFICOS Y SOCIALES"]
[null,"Población Actual:"]
[null,"Densidad:"]
[null,"Tasa de Crecimiento (últimos 3 años):"]
[null,"Grupos Étnicos:"]
[null,"Idioma:"]
[null,"No. Aproximado de Familias:"]
[null,"Tamaño Promedio de las Familias:"]
[null,"Nivel Promedio Educativo de la Madre:"]
[null,"No. Promedio de Hijos en Escuela:"]
[]
[null,"ASPECTOS ECONÓMICOS"]
[null,"Principal Actividad Económica:"]
[null,"Ingreso Familiar Promedio Mensual:"]
[]
[null,"SERVICIOS BÁSICOS DEL AREA DE INFLUENCIA DEL PROYECTO"]
[{"$nulls":4},"SERVICIO",null,"Nivel","Cobertura (%)","Estado"]
[{"$nulls":4},"Agua Potable "]
[{"$nulls":4},"Alcantarillado"]
[{"$nulls":4},"Energía Eléctrica"]
[{"$nulls":4},"Teléfono         "]
[{"$nulls":4},"Educación"]
[{"$nulls":4},"Salud"]
[]
[null,"CLIMATOLOGÍA"]
[{"$nulls":4},"Temperatura Promedio",{"$nulls":3},"º C"]
[{"$nulls":4},"Altura sobre el Nivel del Mar",{"$nulls":3},"m.s.n.m"]
[{"$nulls":4},"Volúmen de Lluvia Anual",{"$nulls":3},"mm."]
[]
[]
[null,"ACCESO AL CENTRO DE SALUD MÁS CERCANO"]
[null,"TIPO",null,null,"Estado",null,null,"Distancia (km)",null,"Tiempo de Viaje (Horas)"]
[null,"Carretera"]
[null,"Camino Vecinal"]
[null,"Camino de Herradura"]
[null,"Senda"]
[null,"Tren"]
[null,"Fluvial y Lacustre"]
[null,"Aéreo"]
[]
[]
[]
[null,"INDICADORES DE SALUD  (referidos al área de influencia del proyecto)"]
[]
[null,"Cobertura de Servicios:",{"$nulls":3},"%","  Porcentaje de la Población que tiene acceso al servicio"]
[]
[]
[null,"Causas más frecuentes de Enfermedad (Estructura de la Morbilidad)"]
{"$rows_empty":7}
[null,"Principales Causas de Muerte"]
[]
[]
[]
[]
[]
[]
[null,"Principales Causas de Insatisfacción de los Usuarios"]
[]
[]
[]
[]
[]
[]
[null,"Tasa de Mortalidad General:",{"$nulls":5},"por 1000"]
[]
[null,"Tasa de Mortalidad Infantil:",{"$nulls":5},"por 1000 nacidos vivos"]
[]
[null,"Tasa de Mortalidad Materna:",{"$nulls":5},"por 100.000"]
[]
[null,"POBLACIÓN AFECTADA"]
[null,"Tipo",null,"DISTRIBUCION POR EDAD Y GENERO (Habitantes)"]
[{"$nulls":3},"Menor de 1 año","1 a 4 años","5 a 14 años","15 a 49 años","50 a 59 años","60 y más","TOTAL","Mujeres Embara- zadas","Tasa de Crecim. de Poblac."]
[null,"Hombres",{"$nulls":7},0]
[null,"Mujeres",{"$nulls":7},0]
[null,"Población Total",null,0,0,0,0,0,0,0]
[]
[]
[null,"INSTITUCIONES DE SALUD EN EL ÁREA DE INFLUENCIA DEL PROYECTO"]
[null,"NOMBRE",null,null,"Servicios",{"$nulls":4},"Tipo",null,"Nivel de Complejidad",null,"Atiende Poblac. de Otra Zona"]
[]
[]
[]
[null,"OBSERVACIONES"]
[]
[]
[null,"DEMANDA POTENCIAL"]
[null,"Servicio",{"$nulls":3},"Indicador de Frecuencia Anual",null,null,"Población",null,null,"Atenciones Esperadas"]
[null,"SBS - Prestaciones a la Madre"]
[null,"   Atención Prenatal",{"$nulls":9},0]
[null,"   Atención de Parto",{"$nulls":9},0]
[null,"   Atención Post-Parto",{"$nulls":9},0]
[null,"SBS - Prestaciones al Niño"]
[null,"  Enfermedades Digestivas Agudas (EDA)",{"$nulls":9},0]
[null,"  Infecciones Respiratorias Agudas (IRA)",{"$nulls":9},0]
[null,"   Crecimiento y Desarrollo",{"$nulls":9},0]
[null,"SBS - Prestaciones Generales"]
[null,"   Salud Sexual y Reproductiva",{"$nulls":9},0]
[null,"   Tuberculosis",{"$nulls":9},0]
[null,"Escudo Epidemiológico"]
[null,"  Programa Ampliado de Inmunización (PAI)",{"$nulls":9},0]
[null,"Otros Ingresos Seguro Básico de Salud",{"$nulls":9},0]
[null,"Ingresos Propios",{"$nulls":9},0]
[null,"Otro",{"$nulls":9},0]
[]
[null,"OFERTA ACTUAL DE SERVICIOS"]
[null,"Servicio",null,"Indicador de Rendimiento",null,"Unidad de Medida",null,"Cantidad de Recurso","Estado del Recurso",null,null,"Capacidad (Teórica)",null,"Capacidad (Real)"]
[null,"   Atención Prenatal",{"$nulls":9},0]
[null,"   Atención de Parto",{"$nulls":9},0]
[null,"   Atención Post-Parto",{"$nulls":9},0]
[null,"  Enfermedades Digestivas Agudas (EDA)",{"$nulls":9},0]
[null,"  Infecciones Respiratorias Agudas (IRA)",{"$nulls":9},0]
[null,"   Crecimiento y Desarrollo",{"$nulls":9},0]
[null,"   Salud Sexual y Reproductiva",{"$nulls":9},0]
[null,"   Tuberculosis",{"$nulls":9},0]
[null,"  Programa Ampliado de Inmunización (PAI)",{"$nulls":9},0]
[null,"Otros Ingresos Seguro Básico de Salud",{"$nulls":9},0]
[null,"Ingresos Propios",{"$nulls":9},0]
[null,"Otro",{"$nulls":9},0]
[]
[null,"DÉFICIT ACTUAL DE SERVICIOS"]
[null,"Servicio",null,"Demanda",null,null,"Capacidad",null,"Oferta",null,"Deficit de Capacidad",null,"Deficit de Oferta"]
[null,"   Atención Prenatal",null,0,null,null,0,null,0,null,0,null,0]
[null,"   Atención de Parto",null,0,null,null,0,null,0,null,0,null,0]
[null,"   Atención Post-Parto",null,0,null,null,0,null,0,null,0,null,0]
[null,"  Enfermedades Digestivas Agudas (EDA)",null,0,null,null,0,null,0,null,0,null,0]
[null,"  Infecciones Respiratorias Agudas (IRA)",null,0,null,null,0,null,0,null,0,null,0]
[null,"   Crecimiento y Desarrollo",null,0,null,null,0,null,0,null,0,null,0]
[null,"   Salud Sexual y Reproductiva",null,0,null,null,0,null,0,null,0,null,0]
[null,"   Tuberculosis",null,0,null,null,0,null,0,null,0,null,0]
[null,"  Programa Ampliado de Inmunización (PAI)",null,0,null,null,0,null,0,null,0,null,0]
[null,"Otros Ingresos Seguro Básico de Salud",null,0,null,null,0,null,0,null,0,null,0]
[null,"Ingresos Propios",null,0,null,null,0,null,0,null,0,null,0]
[null,"Otro",null,0,null,null,0,null,0,null,0,null,0]
[]
[]
[]
[null,"SITUACION SIN PROYECTO (BASE OPTIMIZADA)"]
[null,"PROYECCIÓN DE LA DEMANDA"]
[null,"Servicio",null,"Indicador de Frecuencia Anual",null,null,"Demanda Actual","Total al Final del Proyecto",1,2,3,4,5]
[{"$nulls":8},"POBLACION Y DEMANDA PROYECTADA"]
[{"$nulls":6},0,0,0,0,0,0,0]
[null,"   Atención Prenatal",null,0,null,null,0,0,0,0,0,0,0]
[{"$nulls":6},0,0,0,0,0,0,0]
[null,"   Atención de Parto",null,0,null,null,0,0,0,0,0,0,0]
[{"$nulls":6},0,0,0,0,0,0,0]
[null,"   Atención Post-Parto",null,0,null,null,0,0,0,0,0,0,0]
[{"$nulls":6},0,0,0,0,0,0,0]
[null,"  Enfermedades Digestivas Agudas (EDA)",null,0,null,null,0,0,0,0,0,0,0]
[{"$nulls":6},0,0,0,0,0,0,0]
[null,"  Infecciones Respiratorias Agudas (IRA)",null,0,null,null,0,0,0,0,0,0,0]
[{"$nulls":6},0,0,0,0,0,0,0]
[null,"   Crecimiento y Desarrollo",null,0,null,null,0,0,0,0,0,0,0]
[{"$nulls":6},0,0,0,0,0,0,0]
[null,"   Salud Sexual y Reproductiva",null,0,null,null,0,0,0,0,0,0,0]
[{"$nulls":6},0,0,0,0,0,0,0]
[null,"   Tuberculosis",null,0,null,null,0,0,0,0,0,0,0]
[{"$nulls":6},0,0,0,0,0,0,0]
[null,"  Programa Ampliado de Inmunización (PAI)",null,0,null,null,0,0,0,0,0,0,0]
[{"$nulls":6},0,0,0,0,0,0,0]
[null,"Otros Ingresos Seguro Básico de Salud",null,0,null,null,0,0,0,0,0,0,0]
[{"$nulls":6},0,0,0,0,0,0,0]
[null,"Ingresos Propios",null,0,null,null,0,0,0,0,0,0,0]
[{"$nulls":6},0,0,0,0,0,0,0]
[null,"Otro",null,0,null,null,0,0,0,0,0,0,0]
[{"$nulls":6},0,0,0,0,0,0,0]
[{"$nulls":3},"TOTAL DEMANDA",null,null,0,0,0,0,0,0,0]
[null,"OFERTA REAL DE SERVICIOS PROYECTADA"]
[null,"Servicio",null,"Indicad. de Rendim.","Unidad de Medida",null,"Cantidad de Recurso","Estado del Recurso","Oferta Actual","Total al Final del Proyecto","OFERTA PROYECTADA"]
[{"$nulls":10},"AÑOS"]
[{"$nulls":10},1,2,3,4,5]
[null,"   Atención Prenatal",null,0,0,null,0,0,0,0,0,0,0,0,0]
[null,"   Atención de Parto",null,0,0,null,0,0,0,0,0,0,0,0,0]
[null,"   Atención Post-Parto",null,0,0,null,0,0,0,0,0,0,0,0,0]
[null,"  Enfermedades Digestivas Agudas (EDA)",null,0,0,null,0,0,0,0,0,0,0,0,0]
[null,"  Infecciones Respiratorias Agudas (IRA)",null,0,0,null,0,0,0,0,0,0,0,0,0]
[null,"   Crecimiento y Desarrollo",null,0,0,null,0,0,0,0,0,0,0,0,0]
[null,"   Salud Sexual y Reproductiva",null,0,0,null,0,0,0,0,0,0,0,0,0]
[null,"   Tuberculosis",null,0,0,null,0,0,0,0,0,0,0,0,0]
[null,"  Programa Ampliado de Inmunización (PAI)",null,0,0,null,0,0,0,0,0,0,0,0,0]
[null,"Otros Ingresos Seguro Básico de Salud",null,0,0,null,0,0,0,0,0,0,0,0,0]
[null,"Ingresos Propios",null,0,0,null,0,0,0,0,0,0,0,0,0]
[null,"Otro",null,0,0,null,0,0,0,0,0,0,0,0,0]
[{"$nulls":5},"TOTAL OFERTA",null,null,0,0,0,0,0,0,0]
[null,"DEFICIT REAL DE SERVICIOS PROYECTADO"]
[null,"Servicio",null,"Proyección","DEFICIT PROYECTADO"]
[{"$nulls":3},"5 años","AÑOS"]
[{"$nulls":3},"DEFICIT ACTUAL",1,2,3,4,5]
[null,"   Atención Prenatal",null,0,0,0,0,0,0]
[null,"   Atención de Parto",null,0,0,0,0,0,0]
[null,"   Atención Post-Parto",null,0,0,0,0,0,0]
[null,"  Enfermedades Digestivas Agudas (EDA)",null,0,0,0,0,0,0]
[null,"  Infecciones Respiratorias Agudas (IRA)",null,0,0,0,0,0,0]
[null,"   Crecimiento y Desarrollo",null,0,0,0,0,0,0]
[null,"   Salud Sexual y Reproductiva",null,0,0,0,0,0,0]
[null,"   Tuberculosis",null,0,0,0,0,0,0]
[null,"  Programa Ampliado de Inmunización (PAI)",null,0,0,0,0,0,0]
[null,"Otros Ingresos Seguro Básico de Salud",null,0,0,0,0,0,0]
[null,"Ingresos Propios",null,0,0,0,0,0,0]
[null,"Otro",null,0,0,0,0,0,0]
[]
[null,"% del Déficit cubierto por el Proyecto"]
[]
[]
[]
[null,"PROBLEMA"]
[]
[]
[]
[]
[]
[null,"CAUSAS DEL PROBLEMA"]
[]
[]
[]
[]
[]
[null,"OBJETIVO DEL PROYECTO"]
[]
[]
[]
[]
[]
[]
[null,"METAS ANUALES DE COBERTURA DEL PROYECTO"]
[null,"Indicadores por Servicio",null,null,"Unidad de Medida",null,null,"Valor Actual de la Oferta",null,"Meta           (Promedio anual con Proyecto)",null,"Incremental"]
[null,"   Atención Prenatal",null,null,"Atenciones",null,null,0,null,0,null,0]
[null,"   Atención de Parto",null,null,"Atenciones",null,null,0,null,0,null,0]
[null,"   Atención Post-Parto",null,null,"Atenciones",null,null,0,null,0,null,0]
[null,"  Enfermedades Digestivas Agudas (EDA)",null,null,"Atenciones",null,null,0,null,0,null,0]
[null,"  Infecciones Respiratorias Agudas (IRA)",null,null,"Atenciones",null,null,0,null,0,null,0]
[null,"   Crecimiento y Desarrollo",null,null,"Atenciones",null,null,0,null,0,null,0]
[null,"   Salud Sexual y Reproductiva",null,null,"Atenciones",null,null,0,null,0,null,0]
[null,"   Tuberculosis",null,null,"Atenciones",null,null,0,null,0,null,0]
[null,"  Programa Ampliado de Inmunización (PAI)",null,null,"Atenciones",null,null,0,null,0,null,0]
[null,"Otros Ingresos Seguro Básico de Salud",null,null,"Atenciones",null,null,0,null,0,null,0]
[null,"Ingresos Propios",null,null,"Atenciones",null,null,0,null,0,null,0]
[null,"Otro",null,null,"Atenciones",null,null,0,null,0,null,0]
[{"$nulls":5},"TOTAL",null,0,null,0,0,0]
[]
[null,"RELACIÓN DEL OBJETIVO DEL PROYECTO Y PLANES DE SALUD"]
[null,"COMPONENTES DEL PLAN DE SALUD",{"$nulls":5},"COINCIDENCIA DEL PROYECTO CON LA POLITICA DEL PLAN"]
[null,"Plan de Salud Local"]
[]
[]
[null,"Planes o Programas Departamentales"]
[]
[]
[null,"Plan Sectorial (Nacional)"]
{"$rows_empty":7}
[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":10}
[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":22,"n_cols":2,"rows_kept":22,"flags":["formulas_cached_only"]}
{"$rows_empty":7}
[null,"ALTERNATIVA DE SOLUCIÓN - INGENIERÍA DEL PROYECTO"]
[]
[]
[null,"DESCRIPCIÓN"]
[]
[]
[]
[]
[]
[null,"ASPECTOS TÉCNICOS"]
[]
[]
[]
[]
[null,"ASPECTOS OPERATIVOS"]

{"sheet":"EVALUACION PRIVADA","index":3,"n_rows":118,"n_cols":8,"rows_kept":118,"merged":[[8,1,8,3],[17,1,19,2],[17,3,19,3],[17,4,17,5],[18,5,19,5],[20,1,20,2],[21,1,21,2],[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],[29,1,29,2],[30,1,30,2],[31,1,31,2],[32,1,32,2],[33,1,33,3],[37,1,39,2],[37,3,37,4],[38,4,39,4],[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],[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],[64,1,64,2],[65,1,65,2],[66,1,66,2],[67,1,67,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],[77,1,77,2],[78,1,78,2],[79,1,79,2],[80,1,80,2],[81,1,81,2],[83,1,83,2],[83,5,83,6],[84,1,84,2],[84,5,84,6],[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],[95,1,97,2],[95,3,95,4],[96,4,97,4],[98,1,98,2],[100,1,100,2],[101,1,101,2],[102,1,102,2],[103,1,103,2],[107,1,107,2],[108,1,108,2],[109,1,109,2],[110,1,110,2],[111,1,111,2],[113,1,113,2],[115,1,115,2],[116,1,116,2],[117,1,117,2]],"flags":["formulas_cached_only"]}
[null,false]
[]
[]
[]
[]
[]
[]
[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,"INGRESOS DEL PROYECTO"]
[null,"SERVICIOS",null,"Tarifa","Años"]
[{"$nulls":4},0,"Total"]
[{"$nulls":4},2008]
[null,"   Atención Prenatal",null,null,0,0]
[null,"   Atención de Parto",null,null,0,0]
[null,"   Atención Post-Parto",null,null,0,0]
[null,"  Enfermedades Digestivas Agudas (EDA)",null,null,0,0]
[null,"  Infecciones Respiratorias Agudas (IRA)",null,null,0,0]
[null,"   Crecimiento y Desarrollo",null,null,0,0]
[null,"   Salud Sexual y Reproductiva",null,null,0,0]
[null,"   Tuberculosis",null,null,0,0]
[null,"  Programa Ampliado de Inmunización (PAI)",null,null,0,0]
[null,"Otros Ingresos Seguro Básico de Salud",null,null,0,0]
[null,"Ingresos Propios",null,null,0,0]
[null,"Otro",null,null,0,0]
[null,"Otros Ingresos",{"$nulls":3},0]
[null,"      Total ",null,null,0,0]
[]
[]
[null,"COSTOS DEL PROYECTO"]
[null,"Componentes",null,"Años"]
[{"$nulls":3},0,"Total"]
[{"$nulls":3},2008]
[null,"INVERSION"]
[null,"Terrenos",null,null,0]
[null,"Gastos de Supervisión",null,0,0]
[null,"   Mano de Obra Calificada"]
[null,"   Mano de Obra Semicalificada"]
[null,"Infraestructura",null,0,0]
[null,"  Construcción Nueva",null,0,0]
[null,"   Mano de Obra Calificada"]
[null,"   Mano de Obra Semicalificada"]
[null,"   Mano de Obra No Cal. Urbana"]
[null,"   Mano de Obra No Cal. Rural"]
[null,"   Bienes Transables"]
[null,"   Materiales Locales"]
[null,"  Refacción o Ampliación",null,0,0]
[null,"   Mano de Obra Calificada"]
[null,"   Mano de Obra Semicalificada"]
[null,"   Mano de Obra No Cal. Urbana"]
[null,"   Mano de Obra No Cal. Rural"]
[null,"   Bienes Transables"]
[null,"   Materiales Locales"]
[null,"Equipamiento",null,0,0]
[null,"   Bienes Transables"]
[null,"   Materiales Locales"]
[null,"Suministros",null,0,0]
[null,"   Bienes Transables"]
[null,"   Materiales Locales"]
[null,"Gastos Generales",null,null,0]
[null,"Subtotal",null,0,0]
[null,"OPERACIÓN Y MANTENIMIENTO"]
[null,"Mano de Obra Calificada",null,null,0]
[null,"Mano de Obra Semicalificada",null,null,0]
[null,"Mano de Obra No Cal. Urbana",null,null,0]
[null,"Mano de Obra No Cal. Rural",null,null,0]
[null,"Bienes Transables",null,null,0]
[null,"Materiales Locales",null,null,0]
[null,"Subtotal",null,0,0]
[5000000,"Impacto Ambiental",null,null,0,null,0]
[10000000,"Costo de los Estudios de Impacto",null,0,0]
[20000000,"Costo del Manejo del Impacto",null,0,0]
[null,"Subtotal",null,0,0]
[]
[null,"TOTAL",null,0,0]
[]
[null,"VACP",null,{"v":0,"d":"0.00"},null,"Cambio Inversión",null,{"v":1,"d":"100.00%"}]
[null,"VANP",null,{"v":0,"d":"0.00"},null,"Cambio Operación",null,{"v":1,"d":"100.00%"}]
[null,"CAEP",null,{"v":0,"d":"0.00"}]
[null,"TIRP"]
[null,"VAIP",{"$nulls":3},"B / C",0]
[null,"VACP (Construcción)"]
[null,"VACP (Ampliación)"]
[null,"VACP (Equipamiento)"]
[null,"VACP (Operación y Mantenimiento)"]
[null,"CAEP (Operación y Mantenimiento)",null,{"v":0,"d":"0.00"}]
[]
[null,"FLUJO DE FONDOS"]
[{"$nulls":3},"Años"]
[{"$nulls":3},0,"Total"]
[{"$nulls":3},2008]
[null,"Total Ingresos",null,0,0]
[]
[null,"Total Costos de Operación",null,0,0]
[null,"Depreciación (+)",null,null,0]
[null,"Costos Financieros (Intereses)",null,null,0]
[null,"Subtotal",null,0,0]
[]
[null,"Impuestos",null,0,0]
[]
[null,"Total Costos de Inversión",null,0,0]
[null,"Depreciación (-)",null,0,0]
[null,"Amortización (+)",null,null,0]
[null,"Préstamo - Escribir valores con signo (-)",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":84,"n_cols":6,"rows_kept":84,"merged":[[7,1,7,2],[8,1,8,2],[9,1,9,2],[10,1,10,2],[11,1,11,2],[12,1,12,2],[28,1,30,2],[28,3,28,4],[29,4,30,4],[31,1,31,2],[32,1,32,2],[33,1,33,2],[34,1,34,2],[35,1,35,2],[36,1,36,2],[37,1,37,2],[38,1,38,2],[39,1,39,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],[56,1,56,2],[57,1,57,2],[58,1,58,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],[68,1,68,2],[69,1,69,2],[70,1,70,2],[71,1,71,2],[72,1,72,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]],"flags":["formulas_cached_only"]}
[]
[]
[]
[]
[]
[]
[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,"BENEFICIOS ECONÓMICOS DEL PROYECTO"]
{"$rows_empty":8}
[null,"Unidad Monetaria","Dólares"]
[]
[null,"COSTOS DEL PROYECTO"]
[null,"Componentes",null,"Años"]
[{"$nulls":3},0,"Total"]
[{"$nulls":3},2008]
[null,"INVERSION"]
[null,"Terrenos",null,0,0]
[null,"Gastos de Supervisión",null,0,0]
[null,"   Mano de Obra Calificada",null,0]
[null,"   Mano de Obra Semicalificada",null,0]
[null,"Infraestructura",null,0,0]
[null,"  Construcción Nueva",null,0,0]
[null,"   Mano de Obra Calificada",null,0]
[null,"   Mano de Obra Semicalificada",null,0]
[null,"   Mano de Obra No Cal. Urbana",null,0]
[null,"   Mano de Obra No Cal. Rural",null,0]
[null,"   Bienes Transables",null,0]
[null,"   Materiales Locales",null,0]
[null,"  Refacción o Ampliación",null,0,0]
[null,"   Mano de Obra Calificada",null,0]
[null,"   Mano de Obra Semicalificada",null,0]
[null,"   Mano de Obra No Cal. Urbana",null,0]
[null,"   Mano de Obra No Cal. Rural",null,0]
[null,"   Bienes Transables",null,0]
[null,"   Materiales Locales",null,0]
[null,"Equipamiento",null,0,0]
[null,"   Bienes Transables",null,0]
[null,"   Materiales Locales",null,0]
[null,"Suministros",null,0,0]
[null,"   Bienes Transables",null,0]
[null,"   Materiales Locales",null,0]
[null,"Gastos Generales",null,0,0]
[null,"Subtotal",null,0,0]
[null,"OPERACIÓN Y MANTENIMIENTO"]
[null,"Mano de Obra Calificada",null,0,0]
[null,"Mano de Obra Semicalificada",null,0,0]
[null,"Mano de Obra No Cal. Urbana",null,0,0]
[null,"Mano de Obra No Cal. Rural",null,0,0]
[null,"Bienes Transables",null,0,0]
[null,"Materiales Locales",null,0,0]
[null,"Subtotal",null,0,0]
[null,"Impacto Ambiental"]
[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",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"]
[null,"VACS (Construcción)"]
[null,"VACS (Ampliación)"]
[null,"VACS (Equipamiento)"]
[null,"VACS (Operación y Mantenimiento)"]
[null,"CAES (Operación y Mantenimiento)",null,{"v":0,"d":"0.00"}]

{"sheet":"INDICADORES","index":5,"n_rows":53,"n_cols":14,"rows_kept":53,"merged":[[6,1,7,2],[6,3,7,3],[6,7,7,8],[6,9,7,9],[8,1,8,2],[8,7,8,8],[9,1,9,2],[9,7,9,8],[10,1,10,2],[10,7,10,8],[11,1,11,2],[11,7,11,8],[12,1,12,2],[12,7,12,8],[13,1,13,2],[13,7,13,8],[14,1,14,2],[14,7,14,8],[15,1,15,2],[15,7,15,8],[17,1,17,2],[17,7,17,8],[20,1,22,2],[20,3,22,3],[20,4,21,5],[20,7,22,8],[20,9,22,9],[23,1,23,2],[23,7,23,8],[24,1,24,2],[24,7,24,8],[25,1,25,2],[25,7,25,8],[26,1,26,2],[26,7,26,8],[27,1,27,2],[27,7,27,8],[30,1,31,1],[30,2,30,5],[30,6,30,9],[30,10,30,13],[31,2,31,3],[31,4,31,5],[31,6,31,7],[31,8,31,9],[31,10,31,11],[31,12,31,13],[36,1,37,1],[36,2,36,5],[36,6,36,9],[36,10,36,13],[37,2,37,3],[37,4,37,5],[37,6,37,7],[37,8,37,9],[37,10,37,11],[37,12,37,13],[42,1,43,1],[42,2,42,5],[42,6,42,9],[42,10,42,13],[43,2,43,3],[43,4,43,5],[43,6,43,7],[43,8,43,9],[43,10,43,11],[43,12,43,13],[48,1,49,1],[48,2,48,5],[48,6,48,9],[48,10,48,13],[49,2,49,3],[49,4,49,5],[49,6,49,7],[49,8,49,9],[49,10,49,11],[49,12,49,13]],"flags":["formulas_cached_only"]}
[]
[]
[]
[]
[]
[null,"INDICADORES FINANCIEROS",{"$nulls":5},"INDICADORES ECONÓ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,"VACP (Construcción)",null,{"v":0,"d":"0.00"},{"$nulls":3},"VACS (Construcción)",null,{"v":0,"d":"0.00"}]
[null,"VACP (Refacción o Ampliación)",null,{"v":0,"d":"0.00"},{"$nulls":3},"VACS (Refacción o Ampliación)",null,{"v":0,"d":"0.00"}]
[null,"VACP (Equipamiento)",null,{"v":0,"d":"0.00"},{"$nulls":3},"VACS (Equipamiento)",null,{"v":0,"d":"0.00"}]
[null,"VACP (Operación y Mantenimiento)",null,{"v":0,"d":"0.00"},{"$nulls":3},"VACS (Operación y Mantenimiento)",null,{"v":0,"d":"0.00"}]
[null,"VANP",null,{"v":0,"d":"0.00"},{"$nulls":3},"VANS",null,"No se calcula"]
[null,"CAEP",null,{"v":0,"d":"0.00"},{"$nulls":3},"CAES",null,{"v":0,"d":"0.00"}]
[null,"CAEP (Operación y Mantenimiento)",null,{"v":0,"d":"0.00"},{"$nulls":3},"CAES (Operación y Mantenimiento)",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%"},"No se calcula"]
[null,"RBC Privado",null,{"v":0,"d":"0.00"},{"$nulls":3},"RBC Social",null,"No se calcula"]
[]
[null,"INDICADORES DE COSTO - EFICIENCIA"]
[null,"Indicador",null,"Valor","Indicadores Estándar            U.S.$",null,null,"Indicador",null,"Valor"]
[]
[{"$nulls":4},"Max","Min"]
[null,"VACP / Beneficiario",null,{"v":0,"d":"0.00"},{"v":44.09,"d":"44"},{"v":29.85,"d":"30"},null,"VACS / Beneficiario",null,{"v":0,"d":"0.00"}]
[null,"VACP (Infraestructura)/m2 totales",null,{"v":0,"d":"0.00"},{"v":171.92,"d":"172"},{"v":143.53,"d":"144"},null,"VACS (Infraestructura) / m2 totales",null,{"v":0,"d":"0.00"}]
[null,"CAEP / Beneficiario",null,{"v":0,"d":"0.00"},{"v":17.28,"d":"17"},{"v":11.19,"d":"11"},null,"CAES / Beneficiario",null,{"v":0,"d":"0.00"}]
[null,"CAEP (Oper y Mant) / Beneficiario",null,{"v":0,"d":"0.00"},{"v":3.18,"d":"3.2"},{"v":1.88,"d":"1.9"},null,"CAES (Oper y Mant) / Beneficiario",null,{"v":0,"d":"0.00"}]
[null,"CAEP (O y M) / Atenciones Esperadas",null,{"v":0,"d":"0.00"},{"$nulls":3},"CAES (O y M) / Atenciones Esperadas",null,{"v":0,"d":"0.00"}]
[]
[null,"OTROS INDICADORES ESTANDAR PARA PROYECTOS SIMILARES"]
[null,"VACP / Beneficiario","ALTIPLANO",{"$nulls":3},"VALLES",{"$nulls":3},"LLANOS"]
[null,null,"Urbano",null,"Rural",null,"Urbano",null,"Rural",null,"Urbano",null,"Rural"]
[null,"TIPO","Max","Min","Max","Min","Max","Min","Max","Min","Max","Min","Max","Min"]
[null,"Construcción",4.53,3.99,44.09,29.85,22.8,11.77,49.13,31.52,29.51,15.97,44.22,29.39]
[null,"Ampliación",8.65,2.58,15.88,8.36,11.27,4.74,20.01,12.45,17.21,4.97,21.16,5.96]
[]
[null,"VACP(Infraest.) / m2 totales","AREA",{"$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",159.26,148.38,171.92,143.53,159.2,148.85,168.93,144.99,185.53,164.17,191.93,166.56]
[null,"Ampliación",160.87,79.47,135.12,85.03,117.38,62.98,122.4,97.2,117.38,62.98,132.78,110.11]
[]
[null,"CAEP / Beneficiario","AREA",{"$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",12.51,5.53,17.28,11.19,12.51,5.53,21.72,11.27,12.51,5.53,14.01,9.77]
[null,"Ampliación",2.64,2.31,11.94,1.31,2.64,2.31,17.904,11.936,2.64,2.31,17.9,11.94]
[]
[null,"CAEP(Op y Mant) / Beneficiario","AREA",{"$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",0.95,0.82,3.18,1.88,1.66,0.66,2.92,1.69,2.65,1.18,2.64,1.76]
[null,"Ampliación",0.82,0.67,1.66,0.78,1.99,0.61,2.08,1.35,0.82,0.67,2.59,1.66]

{"sheet":"FUENTES DE FINANCIACION","index":6,"n_rows":15,"n_cols":12,"rows_kept":15,"merged":[[6,1,7,1],[6,2,6,5],[6,6,6,7],[6,8,6,10],[6,11,7,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":"ANALISIS DE SENSIBILIDAD","index":7,"n_rows":35,"n_cols":10,"rows_kept":35,"merged":[[7,1,8,2],[7,3,8,3],[7,4,8,4],[9,1,9,2],[10,1,10,2],[11,1,11,2],[12,1,12,2],[13,1,13,2],[15,1,16,2],[15,3,16,3],[15,4,16,4],[15,6,16,7],[15,8,16,8],[15,9,16,9],[17,1,17,2],[17,6,17,7],[18,1,18,2],[18,6,18,7],[19,1,19,2],[19,6,19,7],[20,1,20,2],[20,6,20,7],[21,1,21,2],[21,6,21,7],[22,1,22,2],[22,6,22,7],[23,1,23,2],[23,6,23,7],[24,1,24,2],[24,6,24,7],[26,1,26,2],[26,6,26,7],[28,1,29,2],[28,3,29,3],[28,4,29,4],[28,6,29,7],[28,8,29,8],[28,9,29,9],[30,1,30,2],[30,6,30,7],[31,1,31,2],[31,6,31,7],[32,1,32,2],[32,6,32,7],[33,1,33,2],[33,6,33,7],[34,1,34,2],[34,6,34,7]],"flags":["formulas_cached_only"]}
[null,0]
[]
[]
[]
[]
[null,"ANÁLISIS DE SENSIBILIDAD"]
[]
[null,"Variables",null,"Valor Actual","Nuevo Valor (%)"]
[]
[null,"Monto de la Inversión",null,{"v":0,"d":"0.00"},{"v":1,"d":"100%"}]
[null,"Costos de Operación",null,{"v":0,"d":"0.00"},{"v":1,"d":"100%"}]
[null,"Población Objetivo",null,{"v":0,"d":"0.00"},{"v":1,"d":"100%"}]
[null,"Total Atenciones",null,{"v":0,"d":"0.00"},{"v":1,"d":"100%"}]
[null,"Total m2",null,{"v":0,"d":"0.00"},{"v":1,"d":"100%"}]
[]
[null,"Indicador",null,"Valor","% de Cambio",null,"Indicador",null,"Valor","% de Cambio"]
[]
[null,"VACP",null,{"v":0,"d":"0.00"},{"v":0,"d":"0.00%"},null,"VACS",null,{"v":0,"d":"0.00"},{"v":0,"d":"0.00%"}]
[null,"VACP (Construcción)",null,{"v":0,"d":"0.00"},{"v":0,"d":"0.00%"},null,"VACS (Construcción)",null,{"v":0,"d":"0.00"},{"v":0,"d":"0.00%"}]
[null,"VACP (Refacción o Ampliación)",null,{"v":0,"d":"0.00"},{"v":0,"d":"0.00%"},null,"VACS (Refacción o Ampliación)",null,{"v":0,"d":"0.00"},{"v":0,"d":"0.00%"}]
[null,"VACP (Equipamiento)",null,{"v":0,"d":"0.00"},{"v":0,"d":"0.00%"},null,"VACS (Equipamiento)",null,{"v":0,"d":"0.00"},{"v":0,"d":"0.00%"}]
[null,"VACP (Operación y Mantenimiento)",null,{"v":0,"d":"0.00"},{"v":0,"d":"0.00%"},null,"VACS (Operación y Mantenimiento)",null,{"v":0,"d":"0.00"},{"v":0,"d":"0.00%"}]
[null,"VANP",null,{"v":0,"d":"0.00"},{"v":0,"d":"0.00%"},null,"VANS"]
[null,"CAEP",null,{"v":0,"d":"0.00"},{"v":0,"d":"0.00%"},null,"CAES",null,{"v":0,"d":"0.00"},{"v":0,"d":"0.00%"}]
[null,"CAEP (Operación y Mantenimiento)",null,{"v":0,"d":"0.00"},{"v":0,"d":"0.00%"},null,"CAES (Operación y Mantenimiento)",null,{"v":0,"d":"0.00"},{"v":0,"d":"0.00%"}]
[null,"TIRP",{"v":0.1,"d":"10%"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00%"},null,"TIRS",{"v":0.1,"d":"10%"}]
[null,"RBC Privado",null,{"v":0,"d":"0.00"},{"v":0,"d":"0.00%"},null,"RBC Social"]
[]
[null,"Indicador",null,"Valor","% de Cambio",null,"Indicador",null,"Valor","% de Cambio"]
[]
[null,"VACP / Beneficiario",null,{"v":0,"d":"0.00"},{"v":0,"d":"0.00%"},null,"VACS / Beneficiario",null,{"v":0,"d":"0.00"},{"v":0,"d":"0.00%"}]
[null,"VACP (Infraest.) / m2 totales",null,{"v":0,"d":"0.00"},{"v":0,"d":"0.00%"},null,"VACS (Infraest.) / m2 totales",null,{"v":0,"d":"0.00"},{"v":0,"d":"0.00%"}]
[null,"CAEP / Beneficiario",null,{"v":0,"d":"0.00"},{"v":0,"d":"0.00%"},null,"CAES / Beneficiario",null,{"v":0,"d":"0.00"},{"v":0,"d":"0.00%"}]
[null,"CAEP (Oper y Mant) / Beneficiario",null,{"v":0,"d":"0.00"},{"v":0,"d":"0.00%"},null,"CAES (Oper y Mant) / Beneficiario",null,{"v":0,"d":"0.00"},{"v":0,"d":"0.00%"}]
[null,"CAEP (O y M) / Atenciones Esperadas",null,{"v":0,"d":"0.00"},{"v":0,"d":"0.00%"},null,"CAES (O y M) / Atenciones Esperadas",null,{"v":0,"d":"0.00"},{"v":0,"d":"0.00%"}]

{"sheet":"CONCLUSIONES Y RECOMENDACIONES","index":8,"n_rows":42,"n_cols":2,"rows_kept":42,"merged":[[25,3,25,4],[27,3,27,4]],"flags":["formulas_cached_only"]}
[]
[]
[]
[]
[]
[null,"CONCLUSIONES Y RECOMENDACIONES"]
[]
[]
[]
[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"]