{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Instructivo","Información General","Anexo 1","Resumen","2.1. Personal O&M","2.2. Personal Inversión"],"not_rendered":{"charts":5,"images":4,"macros":1,"external_links":2,"defined_names":7,"comments":2,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Instructivo","index":0,"n_rows":30,"n_cols":24,"rows_kept":30,"cut":false,"hidden":false,"merged":[[0,0,0,7],[0,8,0,15],[0,16,0,23],[1,0,1,7],[7,0,7,7],[1,16,4,23],[1,8,3,15],[27,0,28,7],[19,8,28,15],[2,0,6,7],[8,0,10,7],[18,16,18,23]]}
["INSTRUCTIVO PARA LA UTILIZACIÓN DEL ANEXO 1",null,null,null,null,null,null,null,"ANEXO 1",null,null,null,null,null,null,null,"RESUMEN"]
["GENERALIDADES",null,null,null,null,null,null,null,"En la segunda hoja correspondiente al \"Anexo 1” el prestador observará una matriz en la que se deberá ingresar la información correspondiente a los costos por la prestación de los servicios públicos de agua potable y saneamiento ambiental",null,null,null,null,null,null,null,"La hoja de resumen contempla las gráficas de los costos reportados en el Anexo 1, con el fin de visualizar las relaciones de los montos planificados y ejecutados por cada componente; así como, la representación porcentual de los costos directos, indirectos y de inversión de la prestación de los servicios públicos de agua potable y saneamiento ambiental."]
["La herramienta está compuesta de 3 pestañas, que son las siguientes:\na. Información general\nb. Anexo 1\nc. Resumen"]
[]
[]
[]
[]
["INFORMACIÓN GENERAL"]
["En la primera hoja de “Información general” el prestador observará una matriz en la que se deberá ingresar la información correspondiente a la prestación de el o los servicios e información de la dependencia/unidad administrativa. "]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,"El anexo 1 se divide en dos tipos de costos: los costos directos y costos indirectos."]
[null,null,null,null,null,null,null,null,"Los datos solicitados deberán ser ingresados en las celdas que se encuentran de: color celeste - para el servicio de agua potable, anaranjado - para el servicio de saneamiento ambiental y de color verde - para el componente de alianzas público-comunitarias. \nExisten celdas que contienen un comentario, a partir de éstas se deberá realizar el incremento de más celdas, si fuera el caso.\nLas celdas que se encuentran de color gris corresponden a la sumatoria de los costos ingresados, en los casos que corresponda. Estas celdas no son editables.\nSe podrá realizar comentarios a las cuentas de los costos en la columna Q, de ser necesario."]
[]
[]
[]
[]
[]
[]
[]
["Toda la información solicitada debe ingresarse en las celdas de color azul. Si el prestador público de servicios no cuenta con un software contable deberá dejar el espacio en blanco."]
[]
[null,null,null,null,null,null,null,"Pág.. 1/3",null,null,null,null,null,null,null," Pág.. 2/3",null,null,null,null,null,null,null,"Pág.. 3/3"]

{"sheet":"Información General","index":1,"n_rows":15,"n_cols":24,"rows_kept":15,"cut":false,"hidden":false,"merged":[[11,7,11,9],[8,11,8,14],[9,0,11,2],[9,3,11,6],[9,7,9,9],[8,3,8,6],[8,7,8,9],[8,0,8,2],[11,10,11,14],[5,3,5,14],[6,0,6,14],[5,0,5,2],[9,10,9,14],[10,7,10,9],[10,10,10,14],[7,4,7,14],[7,0,7,3],[12,0,14,2],[12,3,14,6],[14,10,14,14],[13,10,13,14],[12,10,12,14],[12,7,12,9],[13,7,13,9],[14,7,14,9],[0,0,0,14],[1,13,4,14],[3,9,3,10],[3,3,3,5],[4,3,4,5],[1,11,4,12],[3,0,3,2],[4,0,4,2],[3,6,3,8],[1,0,2,2],[4,9,4,10],[4,6,4,8],[1,3,2,10]]}
["I. INFORMACIÓN DEL PRESTADOR",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"DH MANABÍ"]
["Prestador del servicio:",null,null,null,null,null,null,null,null,null,null,"Cantón o cantones servidos: ",null,null,null,null,"DH GUAYAS",null,null,"Agua Potable"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"DH ESMERALDAS",null,null,"Saneamiento ambiental"]
["Cantón:",null,null,null,null,null,"Demarcación:",null,null,null,null,null,null,null,null,null,"DH SANTIAGO",null,null,"Alcantarillado combinado"]
["Servicios prestados ",null,null,null,null,null,"Documento legal de creación:",null,null,null,null,null,null,null,null,null,"DH MIRA",null,null,"Alcantarillado sanitario ",null,"Si",null,"Si"]
["Proceso de control:",null,null,"AUTOEVALUACIÓN DE COSTOS DE LA PRESTACIÓN DE LOS SERVICIOS PÚBLICOS BÁSICOS DE AGUA POTABLE Y SANEAMIENTO AMBIENTAL",null,null,null,null,null,null,null,null,null,null,null,null,"DH PUYANGO - CATAMAYO",null,null,"Agua Potable y Saneamiento Ambiental",null,"No",null,"No"]
["II. INFORMACIÓN DE LA DEPENDENCIA/UNIDAD FINANCIERA",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"DH JUBONES",null,null,"Agua Potable y Alcantarillado Combinado"]
["Nombre del Software Contable:",null,null,null," ",null,null,null,null,null,null,null,null,null,null,null,"DH NAPO",null,null,"Agua Potable y Alcantarillado Sanitario"]
["Nombre de la Dependencia/unidad financiera:",null,null,null,null,null,null,"Se acoge al Código de Planificación y Finanzas Pública:",null,null,null,"Si la respuesta es NO especifique el porqué:",null,null,null,null,"DH PASTAZA"]
["Responsable del reporte:",null,null,null,null,null,null,"Teléfono:"]
[null,null,null,null,null,null,null,"Celular:"]
[null,null,null,null,null,null,null,"Correo Electrónico:"]
["Responsable del departamento/unidad financiera:",null,null,null,null,null,null,"Teléfono:"]
[null,null,null,null,null,null,null,"Celular:"]
[null,null,null,null,null,null,null,"Correo Electrónico:"]

{"sheet":"Anexo 1","index":2,"n_rows":356,"n_cols":17,"rows_kept":356,"cut":false,"hidden":false,"merged":[[347,1,347,2],[350,1,350,2],[351,1,351,2],[240,0,240,16],[1,0,1,16],[2,2,5,2],[2,0,5,1],[2,16,5,16],[219,1,219,2],[220,1,220,2],[241,3,241,12],[340,1,340,2],[343,1,343,2],[241,16,244,16],[242,3,243,4],[242,5,242,10],[0,0,0,16],[4,5,4,6],[4,7,4,8],[3,5,3,10],[3,3,4,4],[3,11,4,12],[2,3,2,12],[4,9,4,10],[242,11,243,12],[243,5,243,6],[243,7,243,8],[243,9,243,10],[245,1,245,2],[246,1,246,2],[288,1,288,2],[337,1,337,2],[6,1,6,2],[7,1,7,2],[34,1,34,2],[241,0,244,1],[241,2,244,2],[106,1,106,2],[114,1,114,2],[115,1,115,2],[137,1,137,2],[199,1,199,2],[234,1,234,2],[213,1,213,2]]}
["ANEXO 1"]
["COSTOS DIRECTOS"]
["                                                                 GRUPO DE GASTO",null,"COSTO ASOCIADO A LA ACTIVIDAD/PARÁMETRO","COMPONENTE",null,null,null,null,null,null,null,null,null,null,null,null,"OBSERVACIONES / COMENTARIOS"]
[null,null,null,"AGUA POTABLE",null,"SANEAMIENTO AMBIENTAL",null,null,null,null,null,"PRESTACIÓN COMUNITARIA"]
[null,null,null,null,null,"ALCANTARILLADO SANITARIO",null,"ALCANTARILLADO PLUVIAL",null,"ALCANTARILLADO COMBINADO",null,null,null,"AÑO 1","AÑO 2","AÑO 3"]
[null,null,null,"MONTO PLANIFICADO                                                    (USD)","MONTO EJECUTADO                                                    (USD)","MONTO PLANIFICADO                                                    (USD)","MONTO EJECUTADO                                                    (USD)","MONTO PLANIFICADO                                                    (USD)","MONTO EJECUTADO                                                    (USD)","MONTO PLANIFICADO                                                   (USD)","MONTO EJECUTADO                                                  (USD)","MONTO PLANIFICADO                                                    (USD)","MONTO EJECUTADO                                                  (USD)","PROYECCIÓN [USD]","PROYECCIÓN [USD]","PROYECCIÓN [USD]"]
[6,"GASTOS DE PRODUCCIÓN",null,{"$f":"+D8+D35+D107","v":0},0,0,0,0,0,0,0,0,0]
[61,"GASTOS EN PERSONAL PARA LA PRODUCCIÓN",null,{"$f":"+D9+D12+D15+D25+D28","v":0},0,0,0,0,0,0,0,0,0]
[6101,"Remuneraciones Básicas",null,{"$f":"SUM(D10:D11)","v":0},{"$f":"SUM(E10:E11)","v":0},0,0,0,0,0,0,0,0,0,0,0]
[null,null,"Remuneraciones Unificadas"]
[null,null,"Salarios Unificados"]
[6102,"Remuneraciones Complementarias",null,{"$f":"SUM(D13:D14)","v":0},{"$f":"SUM(E13:E14)","v":0},0,0,0,0,0,0,0,0]
[null,null,"Decimotercer Sueldo"]
[null,null,"Decimocuarto Sueldo"]
[6105,"Remuneraciones Temporales",null,{"$f":"SUM(D16:D24)","v":0},{"$f":"SUM(E16:E24)","v":0},0,0,0,0,0,0,0,0,0,0,0]
[null,null,"Remuneración Unificada para Pasantes"]
[null,null,"Licencia Remunerada"]
[null,null,"Honorarios "]
[null,null,"Horas Extraordinarias y Suplementarias"]
[null,null,"Servicios Personales por Contrato"]
[null,null,"Subrogación"]
[null,null,"Encargos"]
[]
[]
[6106,"Aportes Patronales a la Seguridad Social",null,{"$f":"SUM(D26:D27)","v":0},{"$f":"SUM(E26:E27)","v":0},0,0,0,0,0,0,0,0]
[null,null,"Aporte Patronal"]
[null,null,"Fondo de Reserva"]
[6107,"Indemnizaciones",null,{"$f":"SUM(D29:D34)","v":0},{"$f":"SUM(E29:E34)","v":0},0,0,0,0,0,0,0,0]
[null,null,"Supresión de Puesto"]
[null,null,"Compensación por Desahucio"]
[null,null,"Compensación por Vacaciones no Gozadas por Cesación de Funciones"]
[null,null,"Por Accidente de Trabajo o Enfermedad"]
[]
[]
[63,"BIENES Y SERVICIOS PARA LA PRODUCCIÓN",null,{"$f":"+D36+D41+D51+D58+D66+D71+D78+D84+D99","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
[6301,"Servicios Básicos",null,{"$f":"SUM(D37:D40)","v":0},{"$f":"SUM(E37:E40)","v":0},0,0,0,0,0,0,0,0]
[null,null,"Energía Eléctrica"]
[null,null,"Telecomunicaciones"]
[]
[]
[6302,"Servicios Generales",null,{"$f":"SUM(D42:D50)","v":0},0,0,0,0,0,0,0,0,0]
[null,null,"Transporte de personal"]
[null,null,"Difusión e Información"]
[null,null,"Servicio de Vigilancia"]
[null,null,"Servicios de Aseo; Lavado de Vestimenta de Trabajo; Fumigación, Desinfección y Limpieza de Instalaciones"]
[null,null,"Remediación, Restauración y Descontaminación de Cuerpos de Agua"]
[null,null,"Fletes y maniobras"]
[null,null,"Otros servicios"]
[]
[]
[6303,"Traslados, Instalaciones, Viáticos y Subsistencias",null,{"$f":"SUM(D52:D57)","v":0},{"$f":"SUM(E52:E57)","v":0},0,0,0,0,0,0,0,0]
[null,null,"Pasajes al Interior"]
[null,null,"Pasajes al Exterior"]
[null,null,"Viáticos y Subsistencias en el Interior"]
[null,null,"Viáticos y Subsistencias en el Exterior"]
[]
[]
[6304,"Instalación, Mantenimiento y Reparaciones Menores",null,{"$f":"SUM(D59:D65)","v":0},{"$f":"SUM(E59:E65)","v":0},0,0,0,0,0,0,0,0]
[null,null,"Maquinarias y Equipos (Instalación, Mantenimiento y Reparación)"]
[null,null,"Vehículos (Mantenimiento y Reparación)"]
[null,null,"Herramientas (Mantenimiento y Reparación)"]
[null,null,"Infraestructura"]
[null,null,"Mantenimiento de Áreas Verdes y Arreglo de Vías Internas"]
[]
[]
[6305,"Arrendamiento de Bienes",null,{"$f":"SUM(D67:D70)","v":0},{"$f":"SUM(E67:E70)","v":0},0,0,0,0,0,0,0,0]
[null,null,"Maquinarias y Equipos (Arrendamiento)"]
[null,null,"Vehículos (Arrendamiento)"]
[]
[]
[6306,"Contratación de Estudios, Investigaciones y Servicios Técnicos Especializados.",null,{"$f":"SUM(D72:D77)","v":0},{"$f":"SUM(E72:E77)","v":0},0,0,0,0,0,0,0,0]
[null,null,"Consultoría, Asesoría e Investigación Especializada\n"]
[null,null,"Honorarios por Contratos Civiles de Servicios"]
[null,null,"Servicios Técnicos Especializados"]
[null,null,"Investigaciones Profesionales y Análisis de Laboratorio"]
[]
[]
[6307,"Gastos en Informática",null,{"$f":"SUM(D79:D83)","v":0},0,0,0,{"$f":"SUM(H79:H83)","v":0},{"$f":"SUM(I79:I83)","v":0},0,0,0,0]
[null,null,"Desarrollo, Actualización, Asistencia Técnica y Soporte de Sistemas Informáticos"]
[null,null,"Arrendamiento de Equipos Informáticos"]
[null,null,"Mantenimiento y Reparación de Equipos y Sistemas Informáticos"]
[]
[]
[6308,"Bienes de Uso y Consumo de Producción",null,{"$f":"SUM(D85:D98)","v":0},{"$f":"SUM(E85:E98)","v":0},0,0,0,0,0,0,0,0,0,0,0]
[null,null,"Alimentos y Bebidas"]
[null,null,"Vestuario, Lencería y Prendas de Protección"]
[null,null,"Combustibles, Lubricantes y Aditivos"]
[null,null,"Materiales de Oficina"]
[null,null,"Materiales de Aseo"]
[null,null,"Herramientas "]
[null,null,"Repuestos y Accesorios"]
[null,null,"Adquisición de Accesorios y Productos Químicos"]
[null,null,"Insumos, Materiales, Suministros y Bienes para Investigación"]
[null,null,"Material de impresión"]
[null,null,"Material de construcción"]
[null,null,"Otros usos "]
[]
[]
[6314,"Bienes Muebles no Depreciables",null,{"$f":"SUM(D100:D106)","v":0},{"$f":"SUM(E100:E106)","v":0},0,0,0,0,0,0,0,0]
[null,null,"Mobiliario (No Depreciables)"]
[null,null,"Maquinarias y Equipos (No Depreciables)"]
[null,null,"Herramientas (No Depreciables)"]
[null,null,"Equipos, Sistemas y Paquetes Informáticos"]
[null,null,"Partes y Repuestos"]
[]
[]
[67,"OTROS GASTOS DE PRODUCCIÓN",null,{"$f":"+D108+D112","v":0},{"$f":"+E108+E112","v":0},{"$f":"+F108+F112","v":0},0,0,0,0,0,0,0]
[6701,"Impuestos, Tasas y Contribuciones",null,{"$f":"SUM(D109:D111)","v":0},{"$f":"SUM(E109:E111)","v":0},0,0,0,0,0,0,0,0]
[null,null,"Contribuciones Especiales y de Mejora"]
[]
[]
[6702,"Seguros, Costos Financieros y Otros Gastos",null,{"$f":"SUM(D113:D114)","v":0},{"$f":"SUM(E113:E114)","v":0},0,0,0,0,0,0,{"$f":"SUM(L113:L114)","v":0},0]
[]
[]
[7,"GASTOS DE INVERSIÓN",null,{"$f":"+D116+D138+D200+D208+D214","v":0},{"$f":"+E116+E138+E200+E208+E214","v":0},{"$f":"+F116+F138+F200+F208+F214","v":0},0,0,0,0,0,0,0]
[71,"GASTOS EN PERSONAL PARA INVERSIÓN",null,{"$f":"+D117+D120+D123+D129+D132","v":0},{"$f":"+E117+E120+E123+E129+E132","v":0},0,0,0,0,0,0,0,0]
[7101,"Remuneraciones Básicas",null,{"$f":"SUM(D118:D119)","v":0},{"$f":"SUM(E118:E119)","v":0},0,0,0,0,0,0,0,0]
[null,null,"Remuneraciones Unificadas"]
[null,null,"Salarios Unificados"]
[7102,"Remuneraciones Complementarias",null,{"$f":"SUM(D121:D122)","v":0},{"$f":"SUM(E121:E122)","v":0},0,0,0,0,0,0,0,0]
[null,null,"Decimotercer Sueldo"]
[null,null,"Decimocuarto Sueldo"]
[7105,"Remuneraciones Temporales",null,{"$f":"SUM(D124:D128)","v":0},{"$f":"SUM(E124:E128)","v":0},0,0,0,0,0,0,0,0,0,0,0]
[null,null,"Jornales"]
[null,null,"Horas Extraordinarias y Suplementarias"]
[null,null,"Servicios Personales por Contrato"]
[]
[]
[7106,"Aportes Patronales a la Seguridad Social",null,{"$f":"SUM(D130:D131)","v":0},{"$f":"SUM(E130:E131)","v":0},0,0,0,0,0,0,0,0]
[null,null,"Aporte Patronal"]
[null,null,"Fondo de Reserva"]
[7107,"Indemnizaciones",null,{"$f":"SUM(D133:D137)","v":0},{"$f":"SUM(E133:E137)","v":0},0,0,0,0,0,0,0,0,0,0,0]
[null,null,"Compensación por Desahucio"]
[null,null,"Compensación por Vacaciones no Gozadas por Cesación de Funciones"]
[null,null,"Por Accidente de Trabajo o Enfermedad"]
[]
[]
[73,"BIENES Y SERVICIOS PARA INVERSIÓN",null,{"$f":"+D139+D144+D153+D160+D168+D179+D192","v":0},{"$f":"+E139+E144+E153+E160+E168+E179+E192","v":0},0,0,0,0,0,0,0,0]
[7301,"Servicios Básicos",null,{"$f":"SUM(D140:D143)","v":0},{"$f":"SUM(E140:E143)","v":0},0,0,0,0,0,0,0,0,0,0,0]
[null,null,"Energía Eléctrica"]
[null,null,"Telecomunicaciones"]
[]
[]
[7302,"Servicios Generales",null,{"$f":"SUM(D145:D152)","v":0},{"$f":"SUM(E145:E152)","v":0},0,0,0,0,0,0,0,0]
[null,null,"Transporte de personal"]
[null,null,"Eventos Públicos y Oficiales"]
[null,null,"Servicio de Seguridad y Vigilancia"]
[null,null,"Servicios de Aseo; Lavado de Vestimenta de Trabajo; Fumigación, Desinfección y Limpieza de Instalaciones"]
[null,null,"Servicios de Difusión e Información"]
[null,null,"Servicios de Publicidad y Propaganda en Medios de Comunicación Masiva"]
[]
[]
[7303,"Traslados, Instalaciones, Viáticos y Subsistencias",null,{"$f":"SUM(D154:D159)","v":0},{"$f":"SUM(E154:E159)","v":0},0,0,0,0,0,0,0,0]
[null,null,"Pasajes al Interior"]
[null,null,"Pasajes al Exterior"]
[null,null,"Viáticos y Subsistencias en el Interior"]
[null,null,"Viáticos y Subsistencias en el Exterior"]
[]
[]
[7304,"Instalación, Mantenimiento y Reparaciones Menores",null,{"$f":"SUM(D161:D167)","v":0},{"$f":"SUM(E161:E167)","v":0},0,0,0,0,0,0,0,0]
[null,null,"Maquinarias y Equipos (Instalación, Mantenimiento y Reparación)"]
[null,null,"Vehículos (Mantenimiento y Reparación)"]
[null,null,"Herramientas (Mantenimiento y Reparación)"]
[null,null,"Infraestructura"]
[null,null,"Mantenimiento de Áreas Verdes y Arreglo de Vías Internas"]
[]
[]
[7306,"Contratación de Estudios, Investigaciones y Servicios Técnicos Especializados.",null,{"$f":"SUM(D169:D178)","v":0},{"$f":"SUM(E169:E178)","v":0},0,0,0,0,0,0,0,0]
[null,null,"Consultoría, Asesoría e Investigación Especializada\n"]
[null,null,"Servicio de Auditoría"]
[null,null,"Servicio de Capacitación"]
[null,null,"Fiscalización e Inspecciones Técnicas"]
[null,null,"Estudio y Diseño de Proyectos"]
[null,null,"Honorarios por Contratos Civiles de Servicios"]
[null,null,"Servicios Técnicos Especializados"]
[null,null,"Investigaciones Profesionales y Análisis de Laboratorio"]
[]
[]
[7308,"Bienes de Uso y Consumo de Inversión",null,{"$f":"SUM(D180:D191)","v":0},{"$f":"SUM(E180:E191)","v":0},0,0,0,0,0,0,0,0,0,0,0]
[null,null,"Alimentos y Bebidas"]
[null,null,"Combustibles y Lubricantes"]
[null,null,"Materiales de Oficina"]
[null,null,"Materiales de Aseo"]
[null,null,"Herramientas y Equipos Menores"]
[null,null,"Repuestos y Accesorios"]
[null,null,"Adquisición de Accesorios e Insumos Químicos y Orgánicos"]
[null,null,"Insumos, Materiales, Suministros y Bienes para Investigación"]
[null,null,"Materiales de construcción"]
[null,null,"Otros "]
[]
[]
[7314,"Bienes Muebles no Depreciables",null,{"$f":"SUM(D193:D199)","v":0},{"$f":"SUM(E193:E199)","v":0},0,0,0,0,0,0,0,0,0,0,0]
[null,null,"Mobiliario (No Depreciables)"]
[null,null,"Maquinarias y Equipos (No Depreciables)"]
[null,null,"Herramientas (No Depreciables)"]
[null,null,"Equipos, Sistemas y Paquetes Informáticos"]
[null,null,"Partes y Repuestos"]
[]
[]
[75,"OBRAS PÚBLICAS",null,{"$f":"+D201+D204","v":0},{"$f":"+E201+E204","v":0},0,0,0,0,0,0,0,0]
[7501,"Obras de Infraestructura",null,{"$f":"SUM(D202:D203)","v":0},{"$f":"SUM(E202:E203)","v":0},0,0,0,0,0,0,0,0]
[null,null,"De Agua Potable"]
[null,null,"De Alcantarillado"]
[7505,"Mantenimiento y Reparaciones",null,{"$f":"SUM(D205:D207)","v":0},{"$f":"SUM(E205:E207)","v":0},0,0,0,0,0,0,0,0,0,0,0]
[null,null,"En Obras de Infraestructura"]
[]
[]
[77,"OTROS GASTOS DE INVERSIÓN",null,{"$f":"+D209","v":0},{"$f":"+E209","v":0},0,0,0,0,0,0,0,0]
[7701,"Impuestos, Tasas y Contribuciones",null,{"$f":"SUM(D210:D213)","v":0},{"$f":"SUM(E210:E213)","v":0},0,0,0,0,0,0,0,0]
[null,null,"Tasas Generales, Impuestos, Contribuciones, Permisos, Licencias y Patentes"]
[null,null,"Seguros"]
[]
[]
[78,"TRANSFERENCIAS Y DONACIONES PARA INVERSIÓN",null,{"$f":"+D215","v":0},{"$f":"+E215","v":0},0,0,0,0,0,0,0,0]
[7801,"Transferencias para Inversión al Sector Público",null,{"$f":"SUM(D216:D219)","v":0},{"$f":"SUM(E216:E219)","v":0},0,0,0,0,0,0,0,0]
[null,null,"A Empresas Públicas"]
[null,null,"Ministerio de Economía y Finanzas"]
[]
[]
[9,"APLICACIÓN DE FINANCIAMIENTO",null,{"$f":"+D221+D235","v":0},{"$f":"+E221+E235","v":0},0,0,0,0,0,0,0,0]
[96,"AMORTIZACIÓN DE LA DEUDA PÚBLICA",null,{"$f":"+D222+D229","v":0},{"$f":"+E222+E229","v":0},0,0,0,0,0,0,0,0]
[9602,"Amortización Deuda Interna",null,{"$f":"SUM(D223:D228)","v":0},{"$f":"SUM(E223:E228)","v":0},0,0,0,0,0,0,0,0]
[null,null,"Al Sector Público Financiero"]
[null,null,"Al Sector Público no Financiero"]
[null,null,"Al Sector Privado Financiero"]
[null,null,"Al Sector Privado no Financiero"]
[]
[]
[9603,"Amortización Deuda Externa",null,{"$f":"SUM(D230:D234)","v":0},{"$f":"SUM(E230:E234)","v":0},0,0,0,0,0,0,0,0,0,0,0]
[null,null,"A Organismos Multilaterales"]
[null,null,"Al Sector Privado Financiero"]
[null,null,"Al Sector Privado no Financiero"]
[]
[]
[97,"PASIVO CIRCULANTE",null,{"$f":"+D236","v":0},{"$f":"+E236","v":0},0,0,0,0,0,0,0,0,0,0,0]
[9701,"Deuda Flotante",null,{"$f":"SUM(D237:D240)","v":0},{"$f":"SUM(E237:E240)","v":0},0,0,0,0,0,0,0,0]
[null,null,"De Cuentas por Pagar"]
[null,null,"Depósito de Terceros"]
[]
[]
["COSTOS INDIRECTOS"]
["                                                                 GRUPO DE GASTO",null,"COSTO ASOCIADO A LA ACTIVIDAD/PARÁMETRO","COMPONENTE",null,null,null,null,null,null,null,null,null,null,null,null,"OBSERVACIONES / COMENTARIOS"]
[null,null,null,"AGUA POTABLE",null,"SANEAMIENTO AMBIENTAL",null,null,null,null,null,"ALIANZAS PÚBLICO-COMUNITARIAS"]
[null,null,null,null,null,"ALCANTARILLADO SANITARIO",null,"ALCANTARILLADO PLUVIAL",null,"ALCANTARILLADO COMBINADO",null,null,null,"AÑO 1","AÑO 2","AÑO 3"]
[null,null,null,"MONTO PLANIFICADO                                                    (USD)","MONTO EJECUTADO                                                    (USD)","MONTO PLANIFICADO                                                    (USD)","MONTO EJECUTADO                                                    (USD)","MONTO PLANIFICADO                                                    (USD)","MONTO EJECUTADO                                                    (USD)","MONTO PLANIFICADO                                                   (USD)","MONTO EJECUTADO                                                  (USD)","MONTO PLANIFICADO                                                    (USD)","MONTO EJECUTADO                                                  (USD)","PROYECCIÓN [USD]","PROYECCIÓN [USD]","PROYECCIÓN [USD]"]
[5,"GASTOS CORRIENTES",null,{"$f":"+D247+D289+D338+D341+D344+D348","v":0},{"$f":"+E247+E289+E338+E341+E344+E348","v":0},0,0,0,0,0,0,0,0]
[51,"GASTOS EN PERSONAL",null,{"$f":"+D248+D251+D257+D262+D267+D277+D282","v":0},{"$f":"+E248+E251+E257+E262+E267+E277+E282","v":0},0,0,0,0,0,0,0,0]
[5101,"Remuneraciones Básicas",null,{"$f":"SUM(D249:D250)","v":0},{"$f":"SUM(E249:E250)","v":0},0,0,0,0,0,0,0,0]
[null,null,"Remuneraciones Unificadas"]
[null,null,"Salarios Unificados"]
[5102,"Remuneraciones Complementarias",null,{"$f":"SUM(D252:D256)","v":0},{"$f":"SUM(E252:E256)","v":0},0,0,0,0,0,0,0,0]
[null,null,"Decimotercer Sueldo"]
[null,null,"Decimocuarto Sueldo"]
[null,null,"Remuneración Variable por Eficiencia\n"]
[]
[]
[5103,"Remuneraciones Compensatorias",null,{"$f":"SUM(D258:D261)","v":0},{"$f":"SUM(E258:E261)","v":0},0,0,0,0,0,0,0,0]
[null,null,"Compensación por Transporte"]
[null,null,"Alimentación\n"]
[]
[]
[5104,"Subsidios",null,{"$f":"SUM(D263:D266)","v":0},{"$f":"SUM(E263:E266)","v":0},0,0,0,0,0,0,0,0]
[null,null,"Por Cargas Familiares"]
[null,null,"Subsidio de Antigüedad"]
[]
[]
[5105,"Remuneraciones Temporales",null,{"$f":"SUM(D268:D276)","v":0},{"$f":"SUM(E268:E276)","v":0},0,0,0,0,0,0,0,0]
[null,null,"Remuneración Unificada para Pasantes"]
[null,null,"Licencia Remunerada"]
[null,null,"Honorarios\n"]
[null,null,"Horas Extraordinarias y Suplementarias"]
[null,null,"Servicios Personales por Contrato"]
[null,null,"Subrogación"]
[null,null,"Encargos"]
[]
[]
[5106,"Aportes Patronales a la Seguridad Social",null,{"$f":"SUM(D278:D281)","v":0},{"$f":"SUM(E278:E281)","v":0},{"$f":"SUM(F278:F281)","v":0},0,0,0,0,0,0,0,0,0,0]
[null,null,"Aporte Patronal"]
[null,null,"Fondo de Reserva"]
[]
[]
[5107,"Indemnizaciones",null,{"$f":"SUM(D283:D288)","v":0},{"$f":"SUM(E283:E288)","v":0},0,0,0,0,0,0,0,0]
[null,null,"Supresión de Puesto"]
[null,null,"Compensación por Desahucio"]
[null,null,"Compensación por Vacaciones no Gozadas por Cesación de Funciones"]
[null,null,"Por Accidente de Trabajo o Enfermedad"]
[]
[]
[53,"BIENES Y SERVICIOS DE CONSUMO",null,{"$f":"+D290+D297+D306+D314+D321+D326+D329+D332+D335","v":0},{"$f":"+E290+E297+E306+E314+E321+E326+E329+E332+E335","v":0},0,0,0,0,0,0,0,0]
[5301,"Servicios Básicos",null,{"$f":"SUM(D291:D296)","v":0},{"$f":"SUM(E291:E296)","v":0},0,0,0,0,0,0,0,0]
[null,null,"Agua Potable"]
[null,null,"Energía Eléctrica"]
[null,null,"Telecomunicaciones"]
[null,null,"Servicio de correo"]
[]
[]
[5302,"Servicios Generales",null,{"$f":"SUM(D298:D305)","v":0},{"$f":"SUM(E298:E305)","v":0},0,0,0,0,0,0,0,0]
[null,null,"Servicio de Seguridad y Vigilancia"]
[null,null,"Servicios de Aseo; Lavado de Vestimenta de Trabajo; Fumigación, Desinfección y Limpieza de Instalaciones"]
[null,null,"Investigaciones Profesionales y Análisis de Laboratorio"]
[null,null,"Fletes y maniobras"]
[null,null,"Edición, impresión, reproducción y publicaciones"]
[null,null,"Otros servicios generales"]
[]
[]
[5303,"Traslados, instalaciones, viáticos y subsistencias",null,{"$f":"SUM(D307:D313)","v":0},{"$f":"SUM(E307:E313)","v":0},0,0,0,0,0,0,0,0]
[null,null,"Pasajes al interior"]
[null,null,"Pasajes al exterior"]
[null,null,"Viáticos y subsistencias al interior"]
[null,null,"Viáticos y subsistencias al exterior"]
[null,null,"Viáticos por gastos de residencia"]
[]
[]
[5304,"Instalación, Mantenimiento y Reparaciones Menores",null,{"$f":"SUM(D315:D320)","v":0},{"$f":"SUM(E315:E320)","v":0},0,0,0,0,0,0,0,0]
[null,null,"Maquinarias y Equipos (Instalación, Mantenimiento y Reparación)"]
[null,null,"Vehículos (Mantenimiento y Reparación)"]
[null,null,"Herramientas (Mantenimiento y Reparación)"]
[null,null,"Mantenimiento de Áreas Verdes y Arreglo de Vías Internas"]
[]
[]
[5305,"Arrendamiento de Bienes",null,{"$f":"SUM(D322:D325)","v":0},{"$f":"SUM(E322:E325)","v":0},0,0,0,0,0,0,0,0]
[null,null,"Maquinarias y Equipos (Arrendamiento)"]
[null,null,"Vehículos (Arrendamiento)"]
[]
[]
[5306,"Contratación de Estudios, Investigaciones y Servicios Técnicos Especializados.",null,{"$f":"SUM(D327:D328)","v":0},{"$f":"SUM(E327:E328)","v":0},0,0,0,0,0,0,0,0]
[]
[]
[5307,"Gastos en Informática",null,{"$f":"SUM(D330:D331)","v":0},{"$f":"SUM(E330:E331)","v":0},0,0,0,0,0,0,0,0]
[]
[]
[5308,"Bienes de Uso y Consumo Corriente",null,{"$f":"SUM(D333:D334)","v":0},{"$f":"SUM(E333:E334)","v":0},0,0,0,0,0,0,0,0]
[]
[]
[5314,"Bienes Muebles no Depreciables",null,{"$f":"SUM(D336:D337)","v":0},{"$f":"SUM(E336:E337)","v":0},0,0,0,0,0,0,0,0,0,0,0]
[]
[]
[56,"GASTOS FINANCIEROS",null,{"$f":"SUM(D339:D340)","v":0},{"$f":"SUM(E339:E340)","v":0},0,0,0,0,0,0,0,0]
[]
[]
[57,"OTROS GASTOS CORRIENTES",null,{"$f":"SUM(D342:D343)","v":0},{"$f":"SUM(E342:E343)","v":0},0,0,0,0,0,0,0,0]
[]
[]
[58,"TRANSFERENCIAS Y DONACIONES CORRIENTES",null,{"$f":"+D345","v":0},{"$f":"+E345","v":0},0,0,0,0,0,0,0,0]
[5801,"Transferencias Corrientes al Sector Público",null,{"$f":"SUM(D346:D347)","v":0},{"$f":"SUM(E346:E347)","v":0},0,0,0,0,0,0,0,0]
[]
[]
[59,"PREVISIONES PARA REASIGNACION",null,{"$f":"SUM(D349:D350)","v":0},{"$f":"SUM(E349:E350)","v":0},0,0,0,0,0,0,0,0]
[]
[]
[8,"GASTOS DE CAPITAL",null,{"$f":"+D352","v":0},{"$f":"+E352","v":0},0,0,0,0,0,0,0,0]
[84,"BIENES DE LARGA DURACIÓN",null,{"$f":"+D353+D356","v":0},{"$f":"+E353+E356","v":0},0,0,0,0,0,0,0,0]
[8401,"Bienes Muebles",null,{"$f":"SUM(D354:D355)","v":0},{"$f":"SUM(E354:E355)","v":0},0,0,0,0,0,0,0,0]
[]
[]
[8402,"Bienes Inmuebles",null,{"$f":"SUM(D357:D358)","v":0},{"$f":"SUM(E357:E358)","v":0},0,0,0,0,0,0,0,0]

{"sheet":"Resumen","index":3,"n_rows":92,"n_cols":15,"rows_kept":92,"cut":false,"hidden":false,"merged":[[30,6,32,6],[0,0,0,6],[3,3,3,6],[7,3,7,6],[30,0,30,5],[4,1,4,2],[6,0,6,2],[10,0,10,2],[31,3,31,5],[0,7,3,7],[8,1,8,2],[9,1,9,2],[1,1,3,2],[1,0,3,0],[1,4,1,6],[1,3,2,3],[5,1,5,2],[7,1,7,2],[55,7,58,7],[56,0,58,0],[56,1,58,2],[56,3,57,3],[56,4,56,6],[55,0,55,6],[58,3,58,6],[85,6,87,6],[59,1,59,2],[61,0,61,2],[62,1,62,2],[63,1,63,2],[60,1,60,2],[64,1,64,2],[65,0,65,2],[62,3,62,6],[85,0,85,5],[86,3,86,5],[89,0,89,1],[34,0,34,1],[91,0,91,1],[31,0,32,1],[31,2,32,2],[86,2,87,2],[88,0,88,1],[33,0,33,1],[90,0,90,1]]}
["COSTOS DIRECTOS ",null,null,null,null,null,null,"SUBTOTAL"]
["CUENTAS","COSTOS DIRECTOS TOTALES",null,"AGUA POTABLE","SANEAMIENTO AMBIENTAL"]
[null,null,null,null,"ALCANTARILLADO SANITARIO","ALCANTARILLADO PLUVIAL","ALCANTARILLADO COMBINADO"]
[null,null,null,"MONTO PLANIFICADO (USD)"]
[6,"DE PRODUCCIÓN (61+63+67)",null,{"$f":"+'Anexo 1'!D7+'Anexo 1'!L7","v":0},{"$f":"+'Anexo 1'!F7","v":0},{"$f":"+'Anexo 1'!H7","v":0},{"$f":"+'Anexo 1'!J7","v":0},{"$f":"SUM(D5:G5)","v":0}]
[9,"APLICACIÓN DEL FINANCIAMIENTO (96+97)",null,{"$f":"+'Anexo 1'!D220+'Anexo 1'!L220","v":0},{"$f":"+'Anexo 1'!F220","v":0},{"$f":"+'Anexo 1'!H220","v":0},{"$f":"+'Anexo 1'!J220","v":0},{"$f":"SUM(D6:G6)","v":0}]
["COSTO TOTAL (6+7+9)",null,null,{"$f":"SUM(D5:D6)","v":0},{"$f":"SUM(E5:E6)","v":0},{"$f":"SUM(F5:F6)","v":0},{"$f":"SUM(G5:G6)","v":0},{"$f":"SUM(D7:G7)","v":0}]
["CUENTAS","COSTOS DIRECTOS TOTALES",null,"MONTO EJECUTADO (USD)",null,null,null,"SUBTOTAL",null,null,"AGUA POTABLE","ALCANTARILLADO SANITARIO","ALCANTARILLADO PLUVIAL","ALCANTARILLADO COMBINADO","ALIANZAS PÚBLICO-COMUNITARIAS"]
[6,"DE PRODUCCIÓN (61+63+67)",null,{"$f":"+'Anexo 1'!E7+'Anexo 1'!M7","v":0},{"$f":"+'Anexo 1'!G7","v":0},{"$f":"+'Anexo 1'!I7","v":0},{"$f":"+'Anexo 1'!K7","v":0},{"$f":"SUM(D9:G9)","v":0}]
[9,"APLICACIÓN DEL FINANCIAMIENTO (96+97)",null,{"$f":"+'Anexo 1'!E220+'Anexo 1'!M220","v":0},{"$f":"+'Anexo 1'!G220","v":0},{"$f":"+'Anexo 1'!I220","v":0},{"$f":"+'Anexo 1'!K220","v":0},{"$f":"SUM(D10:G10)","v":0}]
["COSTO TOTAL (6+7+9)",null,null,{"$f":"SUM(D9:D10)","v":0},{"$f":"SUM(E9:E10)","v":0},{"$f":"SUM(F9:F10)","v":0},{"$f":"SUM(G9:G10)","v":0},{"$f":"SUM(D11:G11)","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["COSTOS DE INVERSIÓN ",null,null,null,null,null,"SUBTOTAL"]
[null,null,"AGUA POTABLE","SANEAMIENTO AMBIENTAL"]
[null,null,null,"ALCANTARILLADO SANITARIO","ALCANTARILLADO PLUVIAL","ALCANTARILLADO COMBINADO"]
["MONTO PLANIFICADO",null,{"$f":"+'Anexo 1'!D115+'Anexo 1'!L115","v":0},{"$f":"+'Anexo 1'!F115","v":0},{"$f":"+'Anexo 1'!H115","v":0},{"$f":"+'Anexo 1'!J115","v":0},{"$f":"SUM(C34:F34)","v":0}]
["MONTO EJECUTADO",null,{"$f":"+'Anexo 1'!E115+'Anexo 1'!M115","v":0},{"$f":"+'Anexo 1'!G115","v":0},{"$f":"+'Anexo 1'!I115","v":0},{"$f":"+'Anexo 1'!K115","v":0},{"$f":"SUM(C35:F35)","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["COSTOS INDIRECTOS ",null,null,null,null,null,null,"SUBTOTAL"]
["CUENTAS","COSTOS INDIRECTOS TOTALES",null,"AGUA POTABLE","SANEAMIENTO AMBIENTAL"]
[null,null,null,null,"ALCANTARILLADO SANITARIO","ALCANTARILLADO PLUVIAL","ALCANTARILLADO COMBINADO"]
[null,null,null,"MONTO PLANIFICADO (USD)"]
[5,"CORRIENTES (51+53+56+57+58+59)",null,{"$f":"+'Anexo 1'!D246+'Anexo 1'!L246","v":0},{"$f":"+'Anexo 1'!F246","v":0},{"$f":"+'Anexo 1'!H246","v":0},{"$f":"+'Anexo 1'!J246","v":0},{"$f":"SUM(D60:G60)","v":0}]
[8,"DE CAPITAL (84)",null,{"$f":"+'Anexo 1'!D351+'Anexo 1'!L351","v":0},{"$f":"+'Anexo 1'!F351","v":0},{"$f":"+'Anexo 1'!H351","v":0},{"$f":"+'Anexo 1'!J351","v":0},{"$f":"SUM(D61:G61)","v":0}]
["COSTO TOTAL (6+7+9)",null,null,{"$f":"SUM(D60:D61)","v":0},{"$f":"SUM(E60:E61)","v":0},{"$f":"SUM(F60:F61)","v":0},{"$f":"SUM(G60:G61)","v":0},{"$f":"SUM(D62:G62)","v":0}]
["CUENTAS","COSTOS INDIRECTOS TOTALES",null,"MONTO EJECUTADO (USD)",null,null,null,"SUBTOTAL"]
[5,"CORRIENTES (51+53+56+57+58+59)",null,{"$f":"+'Anexo 1'!E246+'Anexo 1'!M246","v":0},{"$f":"+'Anexo 1'!G246","v":0},{"$f":"+'Anexo 1'!I246","v":0},{"$f":"+'Anexo 1'!K246","v":0},{"$f":"SUM(D64:G64)","v":0}]
[8,"DE CAPITAL (84)",null,{"$f":"+'Anexo 1'!E351+'Anexo 1'!M351","v":0},{"$f":"+'Anexo 1'!G351","v":0},{"$f":"+'Anexo 1'!I351","v":0},{"$f":"+'Anexo 1'!K351","v":0},{"$f":"SUM(D65:G65)","v":0}]
["COSTO TOTAL (6+7+9)",null,null,{"$f":"SUM(D64:D65)","v":0},{"$f":"SUM(E64:E65)","v":0},{"$f":"SUM(F64:F65)","v":0},{"$f":"SUM(G64:G65)","v":0},{"$f":"SUM(D66:G66)","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["COSTOS TOTALES DE LA PRESTACIÓN DE LOS SERVICIOS",null,null,null,null,null,"SUBTOTAL"]
[null,null,"AGUA POTABLE","SANEAMIENTO AMBIENTAL"]
[null,null,null,"ALCANTARILLADO SANITARIO","ALCANTARILLADO PLUVIAL","ALCANTARILLADO COMBINADO"]
["COSTOS DIRECTOS",null,{"$f":"+D11","v":0},{"$f":"+E11","v":0},{"$f":"+F11","v":0},0,{"$f":"SUM(C89:F89)","v":0}]
["COSTOS DE INVERSIÓN",null,{"$f":"+C35","v":0},{"$f":"+D35","v":0},0,0,{"$f":"SUM(C90:F90)","v":0}]
["COSTOS INDIRECTO ",null,{"$f":"+D66","v":0},{"$f":"+E66","v":0},{"$f":"+F66","v":0},0,{"$f":"SUM(C91:F91)","v":0}]
["TOTAL",null,{"$f":"SUM(C89:C91)","v":0},{"$f":"SUM(D89:D91)","v":0},0,0,{"$f":"SUM(G89:G91)","v":0}]

{"sheet":"2.1. Personal O&M","index":4,"n_rows":61,"n_cols":16,"rows_kept":61,"cut":false,"hidden":true,"merged":[[41,5,42,5],[40,2,40,4],[41,0,42,0],[41,1,42,1],[40,0,40,1],[22,0,23,0],[22,1,23,1],[3,0,4,0],[2,0,2,1],[2,2,2,3],[3,2,4,2],[57,8,57,9],[59,8,60,9],[58,0,58,4],[59,0,60,1],[57,0,57,1],[1,0,1,15],[0,0,0,1],[41,13,42,13],[58,8,58,12],[40,8,40,9],[40,10,40,12],[41,8,42,8],[41,9,42,9],[3,15,4,15],[3,3,3,14],[3,1,4,1],[22,15,23,15],[21,2,21,4],[22,2,23,2],[22,3,22,14],[21,0,21,1]]}
["PRESS MENU"]
["PERSONAL OPERACIÓN Y MANTENIMIENTO"]
["MODALIDAD DE CONTRATO",null,"LOSEP - OTRO TIPO DE MODALIDAD"]
["No.","CARGO O DEPENDENCIA","Nº DE PERSONAL ","REMUNERACIÓN MENSUAL",null,null,null,null,null,null,null,null,null,null,null,"TOTAL         AÑO - 2016"]
[null,null,null,"2016-01-01","2016-02-01","2016-03-01","2016-04-01","2016-05-01","2016-06-01","2016-07-01","2016-08-01","2016-09-01","2016-10-01","2016-11-01","2016-12-01"]
[1,"Zona de desglose",null,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(D6:O6)","v":0}]
[2,null,null,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(D7:O7)","v":0}]
[3,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0]
[4,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0]
[5,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0]
[6,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0]
[7,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0]
[8,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0]
[9,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0]
[10,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0]
[11,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0]
[12,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0]
[13,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0]
[14,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,{"$f":"SUM(C6:C19)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(P6:P19)","v":0}]
["MODALIDAD DE CONTRATO",null,"CÓDIGO DE TRABAJO  - OTRO TIPO DE MODALIDAD"]
["No.","CARGO O DEPENDENCIA","Nº DE PERSONAL ","SALARIOS UNIFICADOS",null,null,null,null,null,null,null,null,null,null,null,"TOTAL         AÑO - 2016"]
[null,null,null,"2016-01-01","2016-02-01","2016-03-01","2016-04-01","2016-05-01","2016-06-01","2016-07-01","2016-08-01","2016-09-01","2016-10-01","2016-11-01","2016-12-01"]
[1,"Zona de desglose",null,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(D25:O25)","v":0}]
[2,null,null,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(D26:O26)","v":0}]
[3,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0]
[4,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0]
[5,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0]
[6,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0]
[7,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0]
[8,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0]
[9,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0]
[10,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0]
[11,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0]
[12,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0]
[13,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0]
[14,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,{"$f":"SUM(C25:C38)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(P25:P38)","v":0}]
[]
["MODALIDAD DE CONTRATO",null,"LOSEP - OTRO TIPO DE MODALIDAD",null,null,null,null,null,"MODALIDAD DE CONTRATO",null,"LOSEP - OTRO TIPO DE MODALIDAD"]
["No.","CARGO O DEPENDENCIA","AGUA POTABLE","SANEAMIENTO AMBIENTAL","ALIANZAS PÚBLICO-COMUNITARIAS","SUBTOTAL",null,null,"No.","CARGO O DEPENDENCIA","AGUA POTABLE","SANEAMIENTO AMBIENTAL","ALIANZAS PÚBLICO-COMUNITARIAS","SUBTOTAL"]
[null,null,"TIEMPO TRABAJADO (HORAS/MES)","TIEMPO TRABAJADO (HORAS/MES)","TIEMPO TRABAJADO (HORAS/MES)",null,null,null,null,null,"TIEMPO TRABAJADO (HORAS/MES)","TIEMPO TRABAJADO (HORAS/MES)","TIEMPO TRABAJADO (HORAS/MES)"]
[1,"Zona de desglose",1,1,0,{"$f":"SUM(C44:E44)","v":2},null,null,1,"Zona de desglose",1,1,0,{"$f":"SUM(K44:M44)","v":2}]
[2,null,1,1,0,{"$f":"SUM(C45:E45)","v":2},null,null,2,null,1,1,0,{"$f":"SUM(K45:M45)","v":2}]
[3,null,1,1,0,2,null,null,3,null,1,1,0,2]
[4,null,1,1,0,2,null,null,4,null,1,1,0,2]
[5,null,1,1,0,2,null,null,5,null,1,1,0,2]
[6,null,1,1,0,2,null,null,6,null,1,1,0,2]
[7,null,1,1,0,2,null,null,7,null,1,1,0,2]
[8,null,1,1,0,2,null,null,8,null,1,1,0,2]
[9,null,1,1,0,2,null,null,9,null,1,1,0,2]
[10,null,1,1,0,2,null,null,10,null,1,1,0,2]
[11,null,1,1,0,2,null,null,11,null,1,1,0,2]
[12,null,1,1,0,2,null,null,12,null,1,1,0,2]
[13,null,1,1,0,2,null,null,13,null,1,1,0,2]
[14,null,1,1,0,2,null,null,14,null,1,1,0,2]
["SUBTOTAL",null,{"$f":"SUM(C44:C57)","v":14},{"$f":"SUM(D44:D57)","v":14},{"$f":"SUM(E44:E57)","v":0},{"$f":"SUM(F44:F57)","v":28},null,null,"SUBTOTAL",null,{"$f":"SUM(K44:K57)","v":14},{"$f":"SUM(L44:L57)","v":14},{"$f":"SUM(M44:M57)","v":0},{"$f":"SUM(N44:N57)","v":28}]
["TOTAL",null,null,null,null,{"$f":"IF(C58+D58+E58=F58,F58,\"Error_Ajustar\")","v":28},null,null,"TOTAL",null,null,null,null,{"$f":"IF(K58+L58+M58=N58,N58,\"Error_Ajustar\")","v":28}]
[null,null,"% DE ASIGNACIÓN TOTAL ","% DE ASIGNACIÓN TOTAL ","% DE ASIGNACIÓN TOTAL ","TOTAL",null,null,null,null,"% DE ASIGNACIÓN TOTAL ","% DE ASIGNACIÓN TOTAL ","% DE ASIGNACIÓN TOTAL ","TOTAL"]
[null,null,{"$f":"+C58/$F$59","v":0.5},{"$f":"+D58/$F$59","v":0.5},{"$f":"+E58/F59","v":0},{"$f":"SUM(C61:E61)","v":1},null,null,null,null,{"$f":"+K58/$N$59","v":0.5},{"$f":"+L58/$N$59","v":0.5},0,{"$f":"SUM(K61:M61)","v":1}]

{"sheet":"2.2. Personal Inversión","index":5,"n_rows":61,"n_cols":16,"rows_kept":61,"cut":false,"hidden":true,"merged":[[3,1,4,1],[3,2,4,2],[3,3,3,14],[58,0,58,4],[58,8,58,12],[40,10,40,12],[59,0,60,1],[59,8,60,9],[40,0,40,1],[40,2,40,4],[40,8,40,9],[41,0,42,0],[41,1,42,1],[41,5,42,5],[41,8,42,8],[41,9,42,9],[1,0,1,15],[0,0,0,1],[41,13,42,13],[57,0,57,1],[57,8,57,9],[3,15,4,15],[21,0,21,1],[21,2,21,4],[22,0,23,0],[22,1,23,1],[22,2,23,2],[22,3,22,14],[22,15,23,15],[2,0,2,1],[2,2,2,3],[3,0,4,0]]}
["PRESS MENU"]
["PERSONAL INVERSIÓN"]
["MODALIDAD DE CONTRATO",null,"LOSEP - OTRO TIPO DE MODALIDAD"]
["No.","CARGO O DEPENDENCIA","Nº DE PERSONAL ","REMUNERACIÓN MENSUAL",null,null,null,null,null,null,null,null,null,null,null,"TOTAL         AÑO - 2016"]
[null,null,null,"2016-01-01","2016-02-01","2016-03-01","2016-04-01","2016-05-01","2016-06-01","2016-07-01","2016-08-01","2016-09-01","2016-10-01","2016-11-01","2016-12-01"]
[1,"Zona de desglose",null,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(D6:O6)","v":0}]
[2,null,null,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(D7:O7)","v":0}]
[3,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0]
[4,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0]
[5,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0]
[6,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0]
[7,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0]
[8,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0]
[9,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0]
[10,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0]
[11,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0]
[12,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0]
[13,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0]
[14,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,{"$f":"SUM(C6:C19)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(P6:P19)","v":0}]
["MODALIDAD DE CONTRATO",null,"CÓDIGO DE TRABAJO  - OTRO TIPO DE MODALIDAD"]
["No.","CARGO O DEPENDENCIA","Nº DE PERSONAL ","SALARIOS UNIFICADOS",null,null,null,null,null,null,null,null,null,null,null,"TOTAL         AÑO - 2016"]
[null,null,null,"2016-01-01","2016-02-01","2016-03-01","2016-04-01","2016-05-01","2016-06-01","2016-07-01","2016-08-01","2016-09-01","2016-10-01","2016-11-01","2016-12-01"]
[1,"Zona de desglose",null,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(D25:O25)","v":0}]
[2,null,null,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(D26:O26)","v":0}]
[3,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0]
[4,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0]
[5,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0]
[6,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0]
[7,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0]
[8,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0]
[9,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0]
[10,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0]
[11,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0]
[12,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0]
[13,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0]
[14,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,{"$f":"SUM(C25:C38)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(P25:P38)","v":0}]
[]
["MODALIDAD DE CONTRATO",null,"LOSEP - OTRO TIPO DE MODALIDAD",null,null,null,null,null,"MODALIDAD DE CONTRATO",null,"LOSEP - OTRO TIPO DE MODALIDAD"]
["No.","CARGO O DEPENDENCIA","AGUA POTABLE","SANEAMIENTO AMBIENTAL","ALIANZAS PÚBLICO-COMUNITARIAS","SUBTOTAL",null,null,"No.","CARGO O DEPENDENCIA","AGUA POTABLE","SANEAMIENTO AMBIENTAL","ALIANZAS PÚBLICO-COMUNITARIAS","SUBTOTAL"]
[null,null,"TIEMPO TRABAJADO (HORAS/MES)","TIEMPO TRABAJADO (HORAS/MES)","TIEMPO TRABAJADO (HORAS/MES)",null,null,null,null,null,"TIEMPO TRABAJADO (HORAS/MES)","TIEMPO TRABAJADO (HORAS/MES)","TIEMPO TRABAJADO (HORAS/MES)"]
[1,"Zona de desglose",1,1,0,{"$f":"SUM(C44:E44)","v":2},null,null,1,"Zona de desglose",1,1,0,{"$f":"SUM(K44:M44)","v":2}]
[2,null,1,1,0,{"$f":"SUM(C45:E45)","v":2},null,null,2,null,1,1,0,{"$f":"SUM(K45:M45)","v":2}]
[3,null,1,1,0,2,null,null,3,null,1,1,0,2]
[4,null,1,1,0,2,null,null,4,null,1,1,0,2]
[5,null,1,1,0,2,null,null,5,null,1,1,0,2]
[6,null,1,1,0,2,null,null,6,null,1,1,0,2]
[7,null,1,1,0,2,null,null,7,null,1,1,0,2]
[8,null,1,1,0,2,null,null,8,null,1,1,0,2]
[9,null,1,1,0,2,null,null,9,null,1,1,0,2]
[10,null,1,1,0,2,null,null,10,null,1,1,0,2]
[11,null,1,1,0,2,null,null,11,null,1,1,0,2]
[12,null,1,1,0,2,null,null,12,null,1,1,0,2]
[13,null,1,1,0,2,null,null,13,null,1,1,0,2]
[14,null,1,1,0,2,null,null,14,null,1,1,0,2]
["SUBTOTAL",null,{"$f":"SUM(C44:C57)","v":14},{"$f":"SUM(D44:D57)","v":14},{"$f":"SUM(E44:E57)","v":0},{"$f":"SUM(F44:F57)","v":28},null,null,"SUBTOTAL",null,{"$f":"SUM(K44:K57)","v":14},{"$f":"SUM(L44:L57)","v":14},{"$f":"SUM(M44:M57)","v":0},{"$f":"SUM(N44:N57)","v":28}]
["TOTAL",null,null,null,null,{"$f":"IF(C58+D58+E58=F58,F58,\"Error_Ajustar\")","v":28},null,null,"TOTAL",null,null,null,null,{"$f":"IF(K58+L58+M58=N58,N58,\"Error_Ajustar\")","v":28}]
[null,null,"% DE ASIGNACIÓN TOTAL ","% DE ASIGNACIÓN TOTAL ","% DE ASIGNACIÓN TOTAL ","TOTAL",null,null,null,null,"% DE ASIGNACIÓN TOTAL ","% DE ASIGNACIÓN TOTAL ","% DE ASIGNACIÓN TOTAL ","TOTAL"]
[null,null,{"$f":"+C58/$F$59","v":0.5},{"$f":"+D58/$F$59","v":0.5},{"$f":"+E58/F59","v":0},{"$f":"SUM(C61:E61)","v":1},null,null,null,null,{"$f":"+K58/N59","v":0.5},{"$f":"+L58/N59","v":0.5},{"$f":"+M58/N59","v":0},{"$f":"SUM(K61:M61)","v":1}]