{"text_format":"1","workbook":"xlsx","n_sheets":10,"sheets":["Datos del del proyecto","LISTA DESPLEGABLE","Línea Base y beneficios proy","Resultados del proyecto","Costos del proyecto","Resultados del proyecto ","Línea Base y beneficios pro (2)","Resultados del proyecto  (2)","Línea Base y beneficios pro (3)","Resultados del proyecto  (3)"],"not_rendered":{"charts":5,"images":38,"macros":1,"external_links":1,"defined_names":213,"comments":0,"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":"Datos del del proyecto","index":0,"n_rows":33,"n_cols":18,"rows_kept":33,"cut":false,"hidden":false,"merged":[[17,3,17,5],[18,3,20,5],[26,10,26,11],[27,10,27,11],[18,7,18,17],[17,7,17,17],[28,10,28,11],[20,7,20,17],[25,7,25,9],[19,7,19,17],[21,7,21,17],[22,7,22,17],[23,7,23,17],[26,7,26,9],[27,7,27,9],[28,7,28,9],[24,2,24,17],[1,5,1,14],[2,2,2,17],[3,2,3,17],[16,3,16,5],[1,2,1,4],[1,15,1,17],[14,10,14,13],[7,7,7,17],[6,7,6,17],[13,7,13,17],[14,3,14,5],[14,7,14,8],[15,3,15,5],[16,7,16,17],[6,3,6,5],[7,3,7,5],[34,7,34,9],[26,12,26,13],[39,15,39,16],[25,3,25,6],[25,10,25,11],[29,10,29,11],[30,10,30,11],[31,10,31,11],[29,7,29,9],[30,7,30,9],[25,14,25,17],[26,14,26,17],[27,14,27,17],[28,14,28,17],[27,12,27,13],[28,12,28,13],[9,2,9,17],[13,3,13,5],[22,20,22,21],[32,3,34,6],[29,3,31,6],[25,12,25,13],[26,3,28,6],[21,3,23,5],[32,7,32,9],[33,7,33,9],[31,7,31,9],[14,15,14,16],[31,14,31,17],[32,14,32,17],[33,14,33,17],[34,14,34,17],[29,14,29,17],[30,14,30,17],[34,12,34,13],[32,10,32,11],[33,10,33,11],[34,10,34,11],[29,12,29,13],[30,12,30,13],[31,12,31,13],[32,12,32,13],[33,12,33,13]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"VERSIÓN 2.0"]
["MENÚ",null,null,null,null,"FORMATO PARA LA PRESENTACIÓN DE PROYECTOS AMBIENTALES AÑO 2025"]
[]
[null,null,"1. DATOS GENERALES DEL PROYECTO"]
[]
[]
[null,null,null,"Nombre de la empresa"]
[null,null,null,"Dirección de la sede "]
[]
[]
[]
[]
[]
[null,null,null,"Nombre del proyecto"]
[null,null,null,"Fecha de inicio",null,null,null,"DD/MM/AAAA",null,null,"Fecha de terminación",null,null,null,null,"DD/MM/AAAA",null,{"$f":"DATEDIF(H15,P15,\"M\")","v":{"$error":"#VALUE!"}}]
[null,null,null,"Seleccione el componente ambiental "]
[null,null,null,"Descripción del proyecto:"]
[null,null,null,"Objetivo general"]
[null,null,null,"Objetivos específicos",null,null,null,"1."]
[null,null,null,null,null,null,null,"2."]
[null,null,null,null,null,null,null,"3."]
[null,null,null,"Metas",null,null,null,"1."]
[null,null,null,null,null,null,null,"2."]
[null,null,null,null,null,null,null,"3."]
[null,null,"CRONOGRAMA"]
[null,null,null,"Objetivo especifico",null,null,null,"Actividades",null,null,"Fecha inicio DD/MM/AAAA",null,"Fecha final\nDD/MM/AAAA",null,"Nombre de la evidencia que soportará la actividad"]
[null,null,null,{"$f":"+H19","v":"1."}]
[]
[]
[null,null,null,{"$f":"+H20","v":"2."}]
[]
[]
[null,null,null,{"$f":"+H21","v":"3."}]

{"sheet":"LISTA DESPLEGABLE","index":1,"n_rows":21,"n_cols":1,"rows_kept":21,"cut":false,"hidden":true,"merged":[[24,1,24,2]]}
["COMPONENTE"]
["Uso eficiente de agua"]
["Uso eficiente de energía"]
["Disminución de residuos peligrosos"]
["Uso eficiente de materiales "]
["Reducción de emisiones "]
["Uso eficiente de residuos orgánicos"]
["Uso eficiente de residuos aprovechables"]
["Uso eficiente de residuos de construcción y demolición"]
[]
[]
["UND DE MEDIDA"]
[]
["m³"]
["kWh"]
["kg"]
["Ton"]
["Ton CO₂eq/año"]
["Unidades"]
["L"]
["Galones"]

{"sheet":"Línea Base y beneficios proy","index":2,"n_rows":24,"n_cols":20,"rows_kept":24,"cut":false,"hidden":false,"merged":[[1,2,1,4],[1,5,1,14],[10,3,10,7],[8,2,8,19],[10,8,10,9],[10,11,10,14],[1,15,1,19],[7,3,7,19],[23,2,23,18],[2,2,2,18],[11,3,11,7],[11,8,11,9],[12,21,12,22],[11,11,11,13]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"VERSIÓN 2.0"]
["MENÚ",null,null,null,null,"FORMATO PARA LA PRESENTACIÓN DE \nPROYECTOS AMBIENTALES AÑO 2025"]
[]
[]
[]
[]
[]
[null,null,null,"Nota: La hoja se encuentra protegida en algunas celdas. Por favor, registre manulamente los datos de su organización en los campos de color verde claro."]
[null,null,"2. LINEA BASE Y BENEFICIOS DEL PROYECTO PRINCIPAL"]
[]
[null,null,null,"Componente ambiental",null,null,null,null,"Unidad",null,null,"Mes de inicio de la línea base"]
[null,null,null,null,null,null,null,null,"m3",null,null,"MM/AAAA"]
[]
[null,null,null,"Línea Base","Mes 1","Mes 2","Mes 3","Mes 4","Mes 5","Mes 6","Mes 7","Mes 8","Mes 9","Mes 10","Mes 11","Mes 12","Total","Promedio mes","Mín.","Máx."]
[null,null,null,"Consumo o generación",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(TablaLineaBase[[#This Row],[Mes 1]:[Mes 12]])","v":0},{"$f":"AVERAGE(TablaLineaBase[[#This Row],[Mes 1]:[Mes 12]])","v":{"$error":"#DIV/0!"}},{"$f":"MIN(TablaLineaBase[[#This Row],[Mes 1]:[Mes 12]])","v":0},{"$f":"MAX(TablaLineaBase[[#This Row],[Mes 1]:[Mes 12]])","v":0}]
[null,null,null,"Costo ",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(TablaLineaBase[[#This Row],[Mes 1]:[Mes 12]])","v":0},{"$f":"AVERAGE(TablaLineaBase[[#This Row],[Mes 1]:[Mes 12]])","v":{"$error":"#DIV/0!"}},{"$f":"MIN(TablaLineaBase[[#This Row],[Mes 1]:[Mes 12]])","v":0},{"$f":"MAX(TablaLineaBase[[#This Row],[Mes 1]:[Mes 12]])","v":0}]
[]
[]
[null,null,null,"Beneficio proyectado","Mensual proyectado","No de meses proyectados","Beneficio total"]
[null,null,null,"Ambiental (Consumo o generación)",null,null,{"$f":"+TablaBeneProyectado[[#This Row],[Mensual proyectado]]*TablaBeneProyectado[[#This Row],[No de meses proyectados]]","v":0}]
[null,null,null,"Economico",null,null,{"$f":"+TablaBeneProyectado[[#This Row],[Mensual proyectado]]*TablaBeneProyectado[[#This Row],[No de meses proyectados]]","v":0}]
[]
[]
[null,null,"CÁLCULOS COMPLEMENTARIOS PARA ESTIMAR LA LÍNEA BASE Y LOS BENEFICIOS PROYECTADOS"]

{"sheet":"Resultados del proyecto","index":3,"n_rows":72,"n_cols":16,"rows_kept":72,"cut":false,"hidden":true,"merged":[[26,11,26,12],[26,13,26,14],[27,11,27,12],[27,13,27,14],[71,1,71,18],[47,2,47,6],[47,7,47,8],[53,11,53,12],[53,13,53,14],[54,11,54,12],[54,13,54,14],[12,2,12,6],[12,7,12,8],[14,21,14,22],[1,1,1,3],[1,4,1,13],[1,14,1,18],[2,1,2,17],[3,1,3,18],[6,21,6,23]]}
[]
[null,null,null,null,"FORMATO PARA LA PRESENTACIÓN DE \nPROYECTOS AMBIENTALES AÑO 2025"]
[]
[null,"9. RESULTADOS  DEL PROYECTO"]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,{"$f":"+#REF!","v":{"$error":"#REF!"}},null,null,null,null,{"$f":"+#REF!","v":{"$error":"#REF!"}}]
[]
[null,null,"Columna1","Mes 1","Mes 2","Mes 3","Mes 4","Mes 5","Mes 6","PROMEDIO"]
[null,null,"Línea base",{"$f":"+#REF!","v":{"$error":"#REF!"}},{"$f":"+#REF!","v":{"$error":"#REF!"}},{"$f":"+#REF!","v":{"$error":"#REF!"}},{"$f":"+#REF!","v":{"$error":"#REF!"}},{"$f":"+#REF!","v":{"$error":"#REF!"}},{"$f":"+#REF!","v":{"$error":"#REF!"}},{"$f":"AVERAGE(Tabla4[[#This Row],[Mes 1]:[Mes 6]])","v":{"$error":"#REF!"}}]
[null,null,"Meta",259.60000000000002,259.60000000000002,259.60000000000002,259.60000000000002,259.60000000000002,259.60000000000002,{"$f":"AVERAGE(Tabla4[[#This Row],[Mes 1]:[Mes 6]])","v":259.59999999999997}]
[null,null,"Resultado consumo o generación actual",1100,1000,1110,1215,1423,1400,{"$f":"AVERAGE(Tabla4[[#This Row],[Mes 1]:[Mes 6]])","v":1208}]
[null,null,"Reducción real",{"$f":"+D16-D18","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"AVERAGE(Tabla4[[#This Row],[Mes 1]:[Mes 6]])","v":{"$error":"#REF!"}}]
[null,null,"% de cumplimiento de la meta",{"$f":"(D19/D17)","v":{"$error":"#REF!"}},{"$f":"(E19/E17)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"AVERAGE(Tabla4[[#This Row],[Mes 1]:[Mes 6]])","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,{"$f":"AVERAGE(J16:J20)","v":{"$error":"#REF!"}}]
[null,null,"Columna1","Mes 1","Mes 2","Mes 3","Mes 4","Mes 5","Mes 6","TOTAL"]
[null,null,"Resultado consumo o generación actual",1100,1000,1110,1215,1423,1400]
[null,null,"Unidad de producción",50,50,50,50,50,50]
[null,null,"Costo ",{"$f":"500000/$D$23","v":454.54545454545456},{"$f":"500000/$E$23","v":500},{"$f":"500000/$F$23","v":450.45045045045043},{"$f":"500000/$G$23","v":411.52263374485597},{"$f":"500000/$H$23","v":351.37034434293747},{"$f":"500000/$I$23","v":357.14285714285717}]
[null,null,"Relación índice de consumo después del proyecto ICDP",{"$f":"D24/D23","v":4.5454545454545456E-2},0.05,4.5045045045045043E-2,4.1152263374485597E-2,3.5137034434293744E-2,3.5714285714285712E-2]
[null,null,"%cumplimiento de mejora",{"$f":"(#REF!-D26)/#REF!","v":{"$error":"#REF!"}},{"$f":"(#REF!-E26)/#REF!","v":{"$error":"#REF!"}},{"$f":"(#REF!-F26)/#REF!","v":{"$error":"#REF!"}},{"$f":"(#REF!-G26)/#REF!","v":{"$error":"#REF!"}},{"$f":"(#REF!-H26)/#REF!","v":{"$error":"#REF!"}},{"$f":"(#REF!-I26)/#REF!","v":{"$error":"#REF!"}},null,null,"Componente beneficio principal",null,"Resultado Ambiental  (mes)",null,"Resultado económico  (mes/$)"]
[null,null,"Ahorro total",{"$f":"+D23*D25","v":500000},{"$f":"E25*E23","v":500000},{"$f":"F25*F23","v":500000},500000,500000,500000.00000000006,null,null,{"$f":"+C13","v":{"$error":"#REF!"}},null,null,null,{"$f":"+N28*$K$21","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Columna1","Mes 1","Mes 2","Mes 3","Mes 4","Mes 5","Mes 6","TOTAL"]
[null,null,"Línea base",{"$f":"+#REF!","v":{"$error":"#REF!"}},{"$f":"+#REF!","v":{"$error":"#REF!"}},{"$f":"+#REF!","v":{"$error":"#REF!"}},{"$f":"+#REF!","v":{"$error":"#REF!"}},{"$f":"+#REF!","v":{"$error":"#REF!"}},{"$f":"+#REF!","v":{"$error":"#REF!"}}]
[null,null,"Meta"]
[null,null,"Resultado consumo o generación actual"]
[null,null,"Reducción real"]
[null,null,"% de cumplimiento de la meta"]
[]
[null,null,{"$f":"+#REF!","v":{"$error":"#REF!"}},null,null,null,null,{"$f":"+#REF!","v":{"$error":"#REF!"}}]
[]
[null,null,"Columna1","Mes 1","Mes 2","Mes 3","Mes 4","Mes 5","Mes 6","TOTAL"]
[null,null,"Resultado consumo o generación actual"]
[null,null,"Unidad de producción"]
[null,null,"Costo "]
[null,null,"Relación índice de consumo después del proyecto",null,null,null,null,null,null,null,null,"Componente beneficio principal",null,"Resultado Ambiental  (mes)",null,"Resultado económico  (mes/$)"]
[null,null,"%cumplimiento de mejora",null,null,null,null,null,null,null,null,{"$f":"+C48","v":{"$error":"#REF!"}},null,null,null,{"$f":"+N55*$K$21","v":0}]
[null,null,"Ahorro total"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"10. REGISTRO FOTOGRÁFICO"]

{"sheet":"Costos del proyecto","index":4,"n_rows":32,"n_cols":18,"rows_kept":32,"cut":false,"hidden":false,"merged":[[10,3,10,15],[11,3,11,6],[11,7,11,8],[11,9,11,10],[17,9,17,11],[12,3,12,6],[13,3,13,6],[14,3,14,6],[15,3,15,6],[16,3,16,6],[13,7,13,8],[14,7,14,8],[15,7,15,8],[16,7,16,8],[13,9,13,10],[14,9,14,10],[1,5,1,12],[2,2,2,17],[3,2,3,17],[1,2,1,4],[1,13,1,17],[26,3,26,6],[26,9,26,10],[32,8,32,12],[29,8,29,11],[30,9,30,11],[31,7,31,11],[26,7,26,8],[27,9,27,11],[28,8,28,11],[24,9,24,10],[25,9,25,10],[23,3,23,6],[24,3,24,6],[25,3,25,6],[23,7,23,8],[24,7,24,8],[25,7,25,8],[22,7,22,8],[21,9,21,10],[22,3,22,6],[22,9,22,10],[23,9,23,10],[20,3,20,6],[21,3,21,6],[19,9,19,10],[20,7,20,8],[20,9,20,10],[21,7,21,8],[15,9,15,10],[12,7,12,8],[12,9,12,10],[19,3,19,6],[19,7,19,8],[16,9,16,10]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"VERSIÓN 2.0"]
["MENÚ",null,null,null,null,"FORMATO PARA LA PRESENTACIÓN DE\nPROYECTOS AMBIENTALES AÑO 2025"]
[]
[null,null,"3. COSTOS DEL PROYECTO"]
[]
[]
[]
[]
[]
[]
[null,null,null,"Nota: La hoja se encuentra protegida en algunas celdas. Por favor, registre manulamente los datos de su organización en los campos de color verde claro."]
[null,null,null,"Detalle de inversión",null,null,null,"Unidad de medida",null,"Valor de la unidad de medida",null,"Cantidad","Total"]
[null,null,null,"Equipos y herramientas. Ejemplo: sensores, medidores",null,null,null,"Unidad",null,null,null,null,{"$f":"J13*L13","v":0}]
[null,null,null,"Instalaciones iniciales. Ejemplo: instalación de tuberías",null,null,null,"Unidad",null,null,null,null,{"$f":"J14*L14","v":0}]
[null,null,null,"Software y licencias. Ejemplo: licencias de análisis",null,null,null,"Unidad",null,null,null,null,0]
[null,null,null,"Consultoría técnica. Ejemplo: Estudios de viabilidad",null,null,null,"Unidad",null,null,null,null,0]
[null,null,null,"Otros",null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,"Sub total Inversión",null,null,{"$f":"SUM(M13:M17)","v":0}]
[]
[null,null,null,"Costos operativos del mes",null,null,null,"Unidad de medida",null,"Valor de la unidad de medida",null,"Cantidad"]
[null,null,null,"Mano de obra. Ejemplo: técnicos, supervisores",null,null,null,"Horas hombre",null,null,null,null,{"$f":"J21*L21","v":0}]
[null,null,null,"Mantenimiento. Ejemplo: calibración de sensores o equipos",null,null,null,"Servicio",null,null,null,null,{"$f":"J22*L22","v":0}]
[null,null,null,"Suministros y consumibles. Ejemplo: filtros, herramientas",null,null,null,"Unidad",null,null,null,null,0]
[null,null,null,"Energía eléctrica. Ejemplo: operación de bombas",null,null,null,"kwh",null,null,null,null,0]
[null,null,null,"Transporte. Ejemplo: logistica para el traslado de personal o materiales",null,null,null,"Viaje",null,null,null,null,0]
[null,null,null,"Monitoreo y reportes. Ejemplo: Supervisiòn y generaciòn de informes",null,null,null,"Informes",null,null,null,null,0]
[null,null,null,"Otros",null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,"Costo operativo mensual",null,null,{"$f":"SUM(M21:M27)","v":0}]
[null,null,null,null,null,null,null,null,"Tiempo duración del proyecto en meses",null,null,null,{"$f":"'Datos del del proyecto'!R15","v":{"$error":"#VALUE!"}}]
[null,null,null,null,null,null,null,null,"Costo operativo total",null,null,null,{"$f":"+M28*$M$29","v":{"$error":"#VALUE!"}}]
[null,null,null,null,null,null,null,null,null,"Total inversión",null,null,{"$f":"+M30+$M$18","v":{"$error":"#VALUE!"}}]
[null,null,null,null,null,null,null,"Tiempo estimado para el retorno \nde la inversión en meses",null,null,null,null,{"$f":"M31/('Línea Base y beneficios proy'!E21+'Línea Base y beneficios pro (2)'!E22+'Línea Base y beneficios pro (3)'!E22)","v":{"$error":"#VALUE!"}}]

{"sheet":"Resultados del proyecto ","index":5,"n_rows":72,"n_cols":22,"rows_kept":72,"cut":false,"hidden":false,"merged":[[10,3,10,6],[11,7,11,8],[10,7,10,8],[12,10,12,15],[48,5,48,6],[11,3,11,6],[32,3,32,4],[33,3,33,4],[47,5,47,6],[26,3,26,9],[17,3,17,6],[34,3,34,18],[10,10,10,12],[11,10,11,12],[8,3,8,14],[2,2,2,14],[1,6,1,13],[1,2,1,5],[1,14,1,18],[3,2,3,18]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"VERSIÓN 2.0"]
["MENÚ",null,null,null,null,null,"FORMATO PARA LA PRESENTACIÓN DE \nPROYECTOS AMBIENTALES AÑO 2025"]
[]
[null,null,"4. RESULTADOS  DEL PROYECTO PRINCIPAL"]
[]
[]
[]
[]
[null,null,null,"Nota: La hoja se encuentra protegida en algunas celdas. Por favor, registre manulamente los datos de su organización en los campos de color verde claro."]
[]
[null,null,null,"Componente ambiental",null,null,null,"Unidad",null,null,"Mes de inicio de resultados"]
[null,null,null,{"$f":"+'Línea Base y beneficios proy'!D12:$H$12","v":0},null,null,null,{"$f":"+'Línea Base y beneficios proy'!$I$12","v":"m3"},null,null,"2025-08-01"]
[]
[null,null,null,"Ambiental","Mes 1","Mes 2","Mes 3","Mes 4","Mes 5","Mes 6","Mes 7","Mes 8","Mes 9","Mes 10","Mes 11","Mes 12","Total","Promedio"]
[null,null,null,"Meta",{"$f":"+'Línea Base y beneficios proy'!$E$20","v":0},{"$f":"+'Línea Base y beneficios proy'!$E$20","v":0},{"$f":"+'Línea Base y beneficios proy'!$E$20","v":0},{"$f":"+'Línea Base y beneficios proy'!$E$20","v":0},{"$f":"+'Línea Base y beneficios proy'!$E$20","v":0},{"$f":"+'Línea Base y beneficios proy'!$E$20","v":0},{"$f":"+'Línea Base y beneficios proy'!$E$20","v":0},{"$f":"+'Línea Base y beneficios proy'!$E$20","v":0},{"$f":"+'Línea Base y beneficios proy'!$E$20","v":0},{"$f":"+'Línea Base y beneficios proy'!$E$20","v":0},{"$f":"+'Línea Base y beneficios proy'!$E$20","v":0},{"$f":"+'Línea Base y beneficios proy'!$E$20","v":0},{"$f":"SUM(Tabla10[[#This Row],[Mes 1]:[Mes 12]])","v":0},{"$f":"AVERAGE(Tabla10[[#This Row],[Mes 1]:[Mes 12]])","v":0}]
[null,null,null,"Resultado consumo o generación",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AVERAGE(Tabla10[[#This Row],[Mes 1]:[Mes 12]])","v":{"$error":"#DIV/0!"}}]
[]
[null,null,null,"Resultados concluyentes del proyecto"]
[]
[null,null,null,"% de cumplimiento promedio meta","% de mejoramiento promedio "]
[null,null,null,{"$f":"R16*100/R15","v":{"$error":"#DIV/0!"}},{"$f":"R16*100/'Línea Base y beneficios proy'!R15","v":{"$error":"#DIV/0!"}}]
[]
[null,null,null,"Economico","Mes 1","Mes 2","Mes 3","Mes 4","Mes 5","Mes 6","Mes 7","Mes 8","Mes 9","Mes 10","Mes 11","Mes 12","Total","Promedio"]
[null,null,null,"Meta",{"$f":"+'Línea Base y beneficios proy'!$E$21","v":0},{"$f":"+'Línea Base y beneficios proy'!$E$21","v":0},{"$f":"+'Línea Base y beneficios proy'!$E$21","v":0},{"$f":"+'Línea Base y beneficios proy'!$E$21","v":0},{"$f":"+'Línea Base y beneficios proy'!$E$21","v":0},{"$f":"+'Línea Base y beneficios proy'!$E$21","v":0},{"$f":"+'Línea Base y beneficios proy'!$E$21","v":0},{"$f":"+'Línea Base y beneficios proy'!$E$21","v":0},{"$f":"+'Línea Base y beneficios proy'!$E$21","v":0},{"$f":"+'Línea Base y beneficios proy'!$E$21","v":0},{"$f":"+'Línea Base y beneficios proy'!$E$21","v":0},{"$f":"+'Línea Base y beneficios proy'!$E$21","v":0},{"$f":"SUM(Tabla479613[[#This Row],[Mes 1]:[Mes 12]])","v":0},{"$f":"AVERAGE(Tabla479613[[#This Row],[Mes 1]:[Mes 12]])","v":0}]
[null,null,null,"Beneficio obtenido",0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(Tabla479613[[#This Row],[Mes 1]:[Mes 12]])","v":0},{"$f":"AVERAGE(Tabla479613[[#This Row],[Mes 1]:[Mes 12]])","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"EVIDENCIAS DE IMPLEMENTACIÓN"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"OBSERVACIONES TUTOR "]

{"sheet":"Línea Base y beneficios pro (2)","index":6,"n_rows":24,"n_cols":20,"rows_kept":24,"cut":false,"hidden":false,"merged":[[12,21,12,22],[23,2,23,18],[10,3,10,7],[10,8,10,9],[10,11,10,14],[11,3,11,7],[11,8,11,9],[11,11,11,13],[8,2,8,19],[1,2,1,4],[1,5,1,14],[1,15,1,19],[2,2,2,18],[7,3,7,19]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"VERSIÓN 2.0"]
["MENÚ",null,null,null,null,"FORMATO PARA LA PRESENTACIÓN DE \nPROYECTOS AMBIENTALES AÑO 2025"]
[]
[]
[]
[]
[]
[null,null,null,"Nota: La hoja se encuentra protegida en algunas celdas. Por favor, registre manulamente los datos de su organización en los campos de color verde claro."]
[null,null," 5. LINEA BASE Y BENEFICIOS COMPLEMENTARIOS DEL PROYECTO 1"]
[]
[null,null,null,"Componente ambiental",null,null,null,null,"Unidad",null,null,"Mes de inicio de la linea base"]
[]
[]
[null,null,null,"Línea Base","Mes 1","Mes 2","Mes 3","Mes 4","Mes 5","Mes 6","Mes 7","Mes 8","Mes 9","Mes 10","Mes 11","Mes 12","Total","Promedio mes","Mín.","Máx."]
[null,null,null,"Consumo o generación",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(TablaLineaBase6[[#This Row],[Mes 1]:[Mes 12]])","v":0},{"$f":"AVERAGE(TablaLineaBase6[[#This Row],[Mes 1]:[Mes 12]])","v":{"$error":"#DIV/0!"}},{"$f":"MIN(TablaLineaBase6[[#This Row],[Mes 1]:[Mes 12]])","v":0},{"$f":"MAX(TablaLineaBase6[[#This Row],[Mes 1]:[Mes 12]])","v":0}]
[null,null,null,"Costo ",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(TablaLineaBase6[[#This Row],[Mes 1]:[Mes 12]])","v":0},{"$f":"AVERAGE(TablaLineaBase6[[#This Row],[Mes 1]:[Mes 12]])","v":{"$error":"#DIV/0!"}},{"$f":"MIN(TablaLineaBase6[[#This Row],[Mes 1]:[Mes 12]])","v":0},{"$f":"MAX(TablaLineaBase6[[#This Row],[Mes 1]:[Mes 12]])","v":0}]
[]
[]
[]
[null,null,null,"Beneficio proyectado","Mensual proyectado","No de meses proyectados","Beneficio total"]
[null,null,null,"Ambiental (Consumo o generación)",null,null,{"$f":"+TablaBeneProyectado8[[#This Row],[Mensual proyectado]]*TablaBeneProyectado8[[#This Row],[No de meses proyectados]]","v":0}]
[null,null,null,"Economico",null,null,{"$f":"+TablaBeneProyectado8[[#This Row],[Mensual proyectado]]*TablaBeneProyectado8[[#This Row],[No de meses proyectados]]","v":0}]
[]
[null,null,"CÁLCULOS COMPLEMENTARIOS PARA ESTIMAR LA LÍNEA BASE Y LOS BENEFICIOS PROYECTADOS"]

{"sheet":"Resultados del proyecto  (2)","index":7,"n_rows":69,"n_cols":22,"rows_kept":69,"cut":false,"hidden":false,"merged":[[29,3,29,4],[30,3,30,4],[31,3,31,18],[44,5,44,6],[45,5,45,6],[10,3,10,6],[11,3,11,6],[11,7,11,8],[12,10,12,15],[17,3,17,6],[10,10,10,12],[11,10,11,12],[8,3,8,14],[1,2,1,5],[1,6,1,13],[1,14,1,18],[2,2,2,14],[3,2,3,18]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"VERSIÓN 2.0"]
["MENÚ",null,null,null,null,null,"FORMATO PARA LA PRESENTACIÓN DE \nPROYECTOS AMBIENTALES AÑO 2025"]
[]
[null,null,"6. RESULTADOS  COMPLEMENTARIOS DEL PROYECTO 1"]
[]
[]
[]
[]
[null,null,null,"Nota: La hoja se encuentra protegida en algunas celdas. Por favor, registre manulamente los datos de su organización en los campos de color verde claro."]
[]
[null,null,null,"Componente ambiental",null,null,null,"Unidad",null,null,"Mes de inicio de resultados"]
[null,null,null,{"$f":"+'Línea Base y beneficios pro (2)'!D12:H12","v":0},null,null,null,{"$f":"+'Línea Base y beneficios pro (2)'!I12","v":0},null,null,"MM/AAAA"]
[]
[null,null,null,"Ambiental","Mes 1","Mes 2","Mes 3","Mes 4","Mes 5","Mes 6","Mes 7","Mes 8","Mes 9","Mes 10","Mes 11","Mes 12","Total","Promedio"]
[null,null,null,"Meta",{"$f":"+'Línea Base y beneficios pro (2)'!$E$21","v":0},{"$f":"+'Línea Base y beneficios pro (2)'!$E$21","v":0},{"$f":"+'Línea Base y beneficios pro (2)'!$E$21","v":0},{"$f":"+'Línea Base y beneficios pro (2)'!$E$21","v":0},{"$f":"+'Línea Base y beneficios pro (2)'!$E$21","v":0},{"$f":"+'Línea Base y beneficios pro (2)'!$E$21","v":0},{"$f":"+'Línea Base y beneficios pro (2)'!$E$21","v":0},{"$f":"+'Línea Base y beneficios pro (2)'!$E$21","v":0},{"$f":"+'Línea Base y beneficios pro (2)'!$E$21","v":0},{"$f":"+'Línea Base y beneficios pro (2)'!$E$21","v":0},{"$f":"+'Línea Base y beneficios pro (2)'!$E$21","v":0},{"$f":"+'Línea Base y beneficios pro (2)'!$E$21","v":0},{"$f":"SUM(Tabla1015[[#This Row],[Mes 1]:[Mes 12]])","v":0},{"$f":"AVERAGE(Tabla1015[[#This Row],[Mes 1]:[Mes 12]])","v":0}]
[null,null,null,"Resultado consumo o generación",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Tabla1015[[#This Row],[Mes 1]:[Mes 12]])","v":0},{"$f":"AVERAGE(Tabla1015[[#This Row],[Mes 1]:[Mes 12]])","v":{"$error":"#DIV/0!"}}]
[]
[null,null,null,"Resultados concluyentes del proyecto"]
[]
[null,null,null,"% de cumplimiento promedio meta","% de mejoramiento promedio"]
[null,null,null,{"$f":"R16*100/R15","v":{"$error":"#DIV/0!"}},{"$f":"R16*100/'Línea Base y beneficios pro (2)'!R15","v":{"$error":"#DIV/0!"}}]
[]
[null,null,null,"Economico","Mes 1","Mes 2","Mes 3","Mes 4","Mes 5","Mes 6","Mes 7","Mes 8","Mes 9","Mes 10","Mes 11","Mes 12","Total","Promedio"]
[null,null,null,"Meta",{"$f":"+'Línea Base y beneficios pro (2)'!$E$22","v":0},{"$f":"+'Línea Base y beneficios pro (2)'!$E$22","v":0},{"$f":"+'Línea Base y beneficios pro (2)'!$E$22","v":0},{"$f":"+'Línea Base y beneficios pro (2)'!$E$22","v":0},{"$f":"+'Línea Base y beneficios pro (2)'!$E$22","v":0},{"$f":"+'Línea Base y beneficios pro (2)'!$E$22","v":0},{"$f":"+'Línea Base y beneficios pro (2)'!$E$22","v":0},{"$f":"+'Línea Base y beneficios pro (2)'!$E$22","v":0},{"$f":"+'Línea Base y beneficios pro (2)'!$E$22","v":0},{"$f":"+'Línea Base y beneficios pro (2)'!$E$22","v":0},{"$f":"+'Línea Base y beneficios pro (2)'!$E$22","v":0},{"$f":"+'Línea Base y beneficios pro (2)'!$E$22","v":0},{"$f":"SUM(Tabla47961314[[#This Row],[Mes 1]:[Mes 12]])","v":0},{"$f":"AVERAGE(Tabla47961314[[#This Row],[Mes 1]:[Mes 12]])","v":0}]
[null,null,null,"Beneficio obtenido",0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(Tabla47961314[[#This Row],[Mes 1]:[Mes 12]])","v":0},{"$f":"AVERAGE(Tabla47961314[[#This Row],[Mes 1]:[Mes 12]])","v":0}]
[]
[]
[]
[]
[]
[]
[null,null,null,"EVIDENCIAS DE IMPLEMENTACIÓN"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"OBSERVACIONES TUTOR "]

{"sheet":"Línea Base y beneficios pro (3)","index":8,"n_rows":24,"n_cols":20,"rows_kept":24,"cut":false,"hidden":false,"merged":[[12,21,12,22],[23,2,23,18],[10,3,10,7],[10,8,10,9],[10,11,10,14],[11,3,11,7],[11,8,11,9],[11,11,11,13],[8,2,8,19],[1,2,1,4],[1,5,1,14],[1,15,1,19],[2,2,2,18],[7,3,7,19]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"VERSIÓN 2.0"]
["MENÚ",null,null,null,null,"FORMATO PARA LA PRESENTACIÓN DE \nPROYECTOS AMBIENTALES AÑO 2025"]
[]
[]
[]
[]
[]
[null,null,null,"Nota: La hoja se encuentra protegida en algunas celdas. Por favor, registre manulamente los datos de su organización en los campos de color verde claro."]
[null,null,"7. LINEA BASE Y BENEFICIOS COMPLEMENTARIOS DEL PROYECTO 2"]
[]
[null,null,null,"Componente ambiental",null,null,null,null,"Unidad",null,null,"Mes de inicio de la linea base"]
[]
[]
[null,null,null,"Línea Base","Mes 1","Mes 2","Mes 3","Mes 4","Mes 5","Mes 6","Mes 7","Mes 8","Mes 9","Mes 10","Mes 11","Mes 12","Total","Promedio mes","Mín.","Máx."]
[null,null,null,"Consumo o generación",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(TablaLineaBase64[[#This Row],[Mes 1]:[Mes 12]])","v":0},{"$f":"AVERAGE(TablaLineaBase64[[#This Row],[Mes 1]:[Mes 12]])","v":{"$error":"#DIV/0!"}},{"$f":"MIN(TablaLineaBase64[[#This Row],[Mes 1]:[Mes 12]])","v":0},{"$f":"MAX(TablaLineaBase64[[#This Row],[Mes 1]:[Mes 12]])","v":0}]
[null,null,null,"Costo ",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(TablaLineaBase64[[#This Row],[Mes 1]:[Mes 12]])","v":0},{"$f":"AVERAGE(TablaLineaBase64[[#This Row],[Mes 1]:[Mes 12]])","v":{"$error":"#DIV/0!"}},{"$f":"MIN(TablaLineaBase64[[#This Row],[Mes 1]:[Mes 12]])","v":0},{"$f":"MAX(TablaLineaBase64[[#This Row],[Mes 1]:[Mes 12]])","v":0}]
[]
[]
[]
[null,null,null,"Beneficio proyectado","Mensual proyectado","No de meses proyectados","Beneficio total"]
[null,null,null,"Ambiental (Consumo o generación)",null,null,{"$f":"+TablaBeneProyectado817[[#This Row],[Mensual proyectado]]*TablaBeneProyectado817[[#This Row],[No de meses proyectados]]","v":0}]
[null,null,null,"Economico",null,null,{"$f":"+TablaBeneProyectado817[[#This Row],[Mensual proyectado]]*TablaBeneProyectado817[[#This Row],[No de meses proyectados]]","v":0}]
[]
[null,null,"CÁLCULOS COMPLEMENTARIOS PARA ESTIMAR LA LÍNEA BASE Y LOS BENEFICIOS PROYECTADOS"]

{"sheet":"Resultados del proyecto  (3)","index":9,"n_rows":69,"n_cols":22,"rows_kept":69,"cut":false,"hidden":false,"merged":[[30,3,30,4],[31,3,31,18],[44,5,44,6],[45,5,45,6],[10,3,10,6],[11,3,11,6],[11,7,11,8],[12,10,12,15],[17,3,17,6],[29,3,29,4],[10,10,10,12],[11,10,11,12],[8,3,8,14],[1,2,1,5],[1,6,1,13],[1,14,1,18],[2,2,2,14],[3,2,3,18]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"VERSIÓN 2.0"]
["MENÚ",null,null,null,null,null,"FORMATO PARA LA PRESENTACIÓN DE \nPROYECTOS AMBIENTALES AÑO 2025"]
[]
[null,null,"8. RESULTADOS  COMPLEMENTARIOS DEL PROYECTO 2"]
[]
[]
[]
[]
[null,null,null,"Nota: La hoja se encuentra protegida en algunas celdas. Por favor, registre manulamente los datos de su organización en los campos de color verde claro."]
[]
[null,null,null,"Componente ambiental",null,null,null,"Unidad",null,null,"Mes de inicio de resultados"]
[null,null,null,{"$f":"+'Línea Base y beneficios pro (3)'!D12:H12","v":0},null,null,null,{"$f":"+'Línea Base y beneficios pro (3)'!I12","v":0},null,null,"MM/AAAA"]
[]
[null,null,null,"Ambiental","Mes 1","Mes 2","Mes 3","Mes 4","Mes 5","Mes 6","Mes 7","Mes 8","Mes 9","Mes 10","Mes 11","Mes 12","Total","Promedio"]
[null,null,null,"Meta",{"$f":"+'Línea Base y beneficios pro (3)'!$E$21","v":0},{"$f":"+'Línea Base y beneficios pro (3)'!$E$21","v":0},{"$f":"+'Línea Base y beneficios pro (3)'!$E$21","v":0},{"$f":"+'Línea Base y beneficios pro (3)'!$E$21","v":0},{"$f":"+'Línea Base y beneficios pro (3)'!$E$21","v":0},{"$f":"+'Línea Base y beneficios pro (3)'!$E$21","v":0},{"$f":"+'Línea Base y beneficios pro (3)'!$E$21","v":0},{"$f":"+'Línea Base y beneficios pro (3)'!$E$21","v":0},{"$f":"+'Línea Base y beneficios pro (3)'!$E$21","v":0},{"$f":"+'Línea Base y beneficios pro (3)'!$E$21","v":0},{"$f":"+'Línea Base y beneficios pro (3)'!$E$21","v":0},{"$f":"+'Línea Base y beneficios pro (3)'!$E$21","v":0},{"$f":"SUM(Tabla101519[[#This Row],[Mes 1]:[Mes 12]])","v":0},{"$f":"AVERAGE(Tabla101519[[#This Row],[Mes 1]:[Mes 12]])","v":0}]
[null,null,null,"Resultado consumo o generación",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Tabla101519[[#This Row],[Mes 1]:[Mes 12]])","v":0},{"$f":"AVERAGE(Tabla101519[[#This Row],[Mes 1]:[Mes 12]])","v":{"$error":"#DIV/0!"}}]
[]
[null,null,null,"Resultados concluyentes del proyecto"]
[]
[null,null,null,"% de cumplimiento promedio\nmeta","% de mejoramiento promedio "]
[null,null,null,{"$f":"R16*100/R15","v":{"$error":"#DIV/0!"}},{"$f":"R16*100/'Línea Base y beneficios pro (3)'!R15","v":{"$error":"#DIV/0!"}}]
[]
[null,null,null,"Economico","Mes 1","Mes 2","Mes 3","Mes 4","Mes 5","Mes 6","Mes 7","Mes 8","Mes 9","Mes 10","Mes 11","Mes 12","Total","Promedio"]
[null,null,null,"Meta",{"$f":"+'Línea Base y beneficios pro (3)'!$E$22","v":0},{"$f":"+'Línea Base y beneficios pro (3)'!$E$22","v":0},{"$f":"+'Línea Base y beneficios pro (3)'!$E$22","v":0},{"$f":"+'Línea Base y beneficios pro (3)'!$E$22","v":0},{"$f":"+'Línea Base y beneficios pro (3)'!$E$22","v":0},{"$f":"+'Línea Base y beneficios pro (3)'!$E$22","v":0},{"$f":"+'Línea Base y beneficios pro (3)'!$E$22","v":0},{"$f":"+'Línea Base y beneficios pro (3)'!$E$22","v":0},{"$f":"+'Línea Base y beneficios pro (3)'!$E$22","v":0},{"$f":"+'Línea Base y beneficios pro (3)'!$E$22","v":0},{"$f":"+'Línea Base y beneficios pro (3)'!$E$22","v":0},{"$f":"+'Línea Base y beneficios pro (3)'!$E$22","v":0},{"$f":"SUM(Tabla4796131418[[#This Row],[Mes 1]:[Mes 12]])","v":0},{"$f":"AVERAGE(Tabla4796131418[[#This Row],[Mes 1]:[Mes 12]])","v":0}]
[null,null,null,"Beneficio obtenido",0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(Tabla4796131418[[#This Row],[Mes 1]:[Mes 12]])","v":0},{"$f":"AVERAGE(Tabla4796131418[[#This Row],[Mes 1]:[Mes 12]])","v":0}]
[]
[]
[]
[]
[]
[]
[null,null,null,"EVIDENCIAS DE IMPLEMENTACIÓN"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"OBSERVACIONES TUTOR "]