{"text_format":"1","workbook":"xlsx","n_sheets":13,"sheets":["Datos del hotel","Información","Plan","Energía","Agua","Residuos","Deperdicio alimentario","Evaluación","HUELLA","DATOS","Datos y cálculos","Scale","Hoja1"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":1,"defined_names":18,"comments":5,"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 hotel","index":0,"n_rows":11,"n_cols":12,"rows_kept":11,"cut":false,"hidden":false,"merged":[[0,1,0,2],[1,1,1,2]]}
[null,"DATOS DEL HOTEL"]
[null,"DATOS"]
[null,"NOMBRE DEL HOTEL"]
["YEAR","NOMBRE DE LA EMPRESA"]
["SEM","CIF"]
["ID","DIRECCIÓN DEL HOTEL"]
[null,"CÓDIGO POSTAL"]
["D1","PROVINCIA"]
["D2","NÚMERO DE TELÉFONO",null,null,"*","**","***","****","*****"]
["D3","FAX",null,null,"Complejo turístico/ resort – Nivel superior","Complejo turístico/ resort – Nivel medio/bajo","Hotel","Hotel de congresos o negocios","Apartamento turístico","Bed & Breakfast (B&B)","Camping","De estancia prolongada"]
["D4","E-MAIL",null,null,"Urbano – en el centro de la ciudad","Urbano – a las afueras de la ciudad","Rural/de interior/pueblo","De costa","Interestatal (motel, hotel de carretera, o cercano a ella, aeropuerto, etc.)","Pequeña ciudad metropolitana"]

{"sheet":"Información","index":1,"n_rows":19,"n_cols":12,"rows_kept":19,"cut":false,"hidden":false,"merged":[[0,1,0,2],[1,1,1,2]]}
[null,"ALOJAMIENTO – INFORMACIÓN GENÉRICA"]
[null,"DATOS"]
[null,"IDENTIFICACIÓN DEL ALOJAMIENTO",{"$f":"'Datos del hotel'!C3","v":0}]
["YEAR","AÑO (YEAR)"]
["SEM","SEMANAS APERTURA DEL HOTEL POR AÑO (SEM)"]
["ID","(CÓDIGO O NOMBRE) (ID)"]
["D1","PROVINCIA (D1)",{"$f":"'Datos del hotel'!C8","v":0}]
["D2","NÚMERO DE ESTRELLAS (D2)",null,null,"*","**","***","****","*****"]
["D3","TIPOLOGÍA DE ALOJAMIENTO (por categoría)(D3)",null,null,"Complejo turístico/ resort – Nivel superior","Complejo turístico/ resort – Nivel medio/bajo","Hotel","Hotel de congresos o negocios","Apartamento turístico","Bed & Breakfast (B&B)","Camping","De estancia prolongada"]
["D4","TIPOLOGÍA DE ALOJAMIENTO (por ubicación) (D4)",null,null,"Urbano – en el centro de la ciudad","Urbano – a las afueras de la ciudad","Rural/de interior/pueblo","De costa","Interestatal (motel, hotel de carretera, o cercano a ella, aeropuerto, etc.)","Pequeña ciudad metropolitana"]
["D5","FUNCIONAMIENTO (D5)",null,null,"Pertenece a una cadena hotelera","Franquicia","Independiente"]
["D6","ESCALA (D6)",null,null,"Cadenas de lujo","Cadenas de alta gama nivel superior","Cadenas de alta gama nivel medio","Cadenas de media escala con comida y bebida","Cadenas de media escala Sin comida y bebida","Cadenas Económicas"]
["D7","ESTACIÓN DEL AÑO EN FUNCIONAMIENTO (D7)",null,null,"Verano","Invierno","Todo el año"]
["D8","PROPIEDAD (D8)",null,null,"Alquilado","Propio"]
["D9","SUPERFICIE DEL ALOJAMIENTO (m2) (D9)"]
["D10","Nº DE HABITACIONES (Uds.) (D10)"]
["D11","Nº PERNOCTACIONES POR AÑO (huésped-noche/año) (D11)"]
["D12","Nº HABITACIONES OCUPADAS POR AÑO (habitaciones ocupadas/año) (D12)"]
["D13","SUPERFICIE DE HABITACIÓN ESTÁNDAR (M2) (D13)"]

{"sheet":"Plan","index":2,"n_rows":56,"n_cols":6,"rows_kept":56,"cut":false,"hidden":false,"merged":[[0,1,0,2],[50,1,50,2],[44,1,44,2],[1,1,1,2],[8,1,8,2],[12,1,12,2],[26,1,26,2],[32,1,32,2],[36,1,36,2],[40,1,40,2],[45,1,45,2],[51,1,51,2],[35,1,35,2],[31,1,31,2],[11,1,11,2],[25,1,25,2]]}
[null,"PLANIFICACIÓN Y EVALUACIÓN CIRCULAR"]
[null,"DATOS"]
[null,"INVERSIÓN","VALORES"]
["P1B","Fracción de la inversión vinculada a buenas prácticas circulares[1] hecha por el establecimiento (% sobre la inversión total de los últimos 3 ejercicios) (P1B) "]
[null,"FORMACIÓN DE LA PLANTILLA","VALORES"]
["P2B","Plantilla que ha recibido formación relacionada con la circularidad (P2B) (% trabajadores que han recibido algún tipo de formación en circularidad en el último ejercicio)"]
[null,"COMPROMISO CIRCULAR DE PROVEEDORES","VALORES"]
["P3B","Proveedores que operan con un código de conducta circular (P3B) (% del total de proveedores que operan bajo prácticas circulares)"]
[null,"ACTUACIONES"]
[null,"COMUNICACIÓN Y TRANSPARENCIA","Sí/No"]
["PBP1","1.     Comunicaciones hechas a los clientes con recomendaciones o guías en materia de ahorro de energía, iluminación, climatización, ahorro de agua, servicio de bufés, separación de residuos en las habitaciones y recambio de toallas o sábanas, entre otras pautas. (PBP1)",null,null,"Sí","No"]
[null,"POLÍTICAS TRANSVERSALES – GOBERNANZA "]
[null,"ACTUACIONES"]
[null,"ESTRATEGÍA Y PLANIFICACIÓN DE LA ECONOMÍA CIRCULAR","Sí/No"]
["PBP2","2.     El alojamiento trabaja en alguno de los principios básicos de la Economía Circular. (Ej. Reducción de residuos; Ahorro de energía y agua; Empleo de materias primas, materiales, productos o instalaciones sostenibles; Desarrollo de la economía local; Preservación de ecosistemas, etc.) (PBP2) "]
["PBP3","3.     El alojamiento ha desarrollado una Estrategia o Plan de circularidad, desarrollando los principios, objetivos, acciones y medidas, calendario de implantación, responsables y roles, indicadores, etc. (PBP3)"]
[null,"MONITORIZACIÓN Y SEGUIMIENTO DE LA ECONOMÍA CIRCULAR","Sí/No"]
["PBP4","4.     Se han establecido indicadores que permiten medir aspectos relacionados con la EC-(Ej. consumo y ahorro de agua y de energía, la cantidad de materiales sostenibles empleados, la cantidad de alimentos sostenibles, el desperdicio alimentario, la cantidad de residuos generados, entre otros (PBP4)"]
[null,"OTROS DOCUMENTOS DE GOBERNANZA","Sí/No"]
["PBP5","5.     Se redactan informes de sostenibilidad[1] (PBP5)"]
[null,"POLÍTICA DE CONTRATACIÓN Y COMPRA SOSTENIBLE","Sí/No"]
["PBP6","6.     El alojamiento selecciona a proveedores de proximidad o que cuentan con certificaciones de sostenibilidad (PBP6)"]
["PBP7","7.     El alojamiento compra productos (textiles, de limpieza y amenities, entre otros) que sean reacondicionables, reciclables, reparables, reutilizables, compostables, etc. y/o que vayan acompañados de información sobre el ciclo de vida del producto (PBP7)"]
[null,"CERTIFICADOS, SELLOS Y ETIQUETAS MEDIOAMBIENTALES","Sí/No"]
["PBP8","8.     El alojamiento dispone de algún certificado de sostenibilidad  (PBP8) (Ej. Certificación Residuo Cero; Sistemas de Gestión Ambiental (ISO 140001); Sistema de Gestión de la Eficiencia Energética (ISO 50001); Verificación de la Huella Hídrica; Etiqueta ecológica tipo I – Ecolabel (ISO 14024); Etiqueta ecológica tipo II – Autodeclaración ambiental (ISO 14021); Etiqueta ecológica tipo III –Declaración ambiental o Global EDP (ISO 14025); Bioscore); Certificado de turismo sostenible; Certificado de agro alimentos; European Ecotourism Labelling Standard; Certificado PassivHaus; etc.)"]
[null,"POLÍTICAS TRANSVERSALES – COLABORACIÓN Y ALIANZAS; PARTICIPACIÓN; COMUNICACIÓN, DIFUSIÓN Y TRANSPARENCIA"]
[null,"ACTUACIONES"]
[null,"RECONOCIMIENTOS","Sí/No"]
["PBP9","9.     Se le ha otorgado al alojamiento algún premio por haber adoptado buenas prácticas de sostenibilidad y/o de economía circular (PBP9)"]
[null,"COLABORACIÓN Y ALIANZAS","Sí/No"]
["PBP10","10.     El alojamiento colabora y coopera con clientes, competidores, proveedores u otras organizaciones (ONGs, ayuntamientos, asociaciones, empresas de base tecnológica, hubs de innovación, entidades y asociaciones de investigación, organismos públicos de innovación, universidades, etc.) sobre sostenibilidad y/o circularidad. (PBP10)"]
[null,"POLÍTICAS TRANSVERSALES – INNOVACIÓN Y DIGITALIZACIÓN"]
[null,"ACTUACIONES"]
[null,"DIGITALIZACIÓN","Sí/No"]
["PBP11","11.     El alojamiento ha implantado herramientas y tecnologías digitales que contribuyen a la sostenibilidad y/o circularidad (PBP11) (Ej. Reservas a través de aplicaciones; Uso de código QR; carta o menú digital; etc.)"]
[null,"POLÍTICAS TRANSVERSALES – EMPLEO Y FORMACIÓN"]
[null,"ACTUACIONES"]
[null,"EMPLEO","Sí/No"]
["PBP12","12.     El alojamiento dispone de personal encargado de las tareas relacionadas con la EC "]
[null,"FORMACIÓN","Sí/No"]
[null,"FORMACIÓN DE LA PLANTILLA"]
["PBP13","13.     Las personas que dirigen el establecimiento (gerencia y mandos intermedios) conocen qué es la economía circular y sus principios (PBP13)"]
["PBP14","14.     Desde la dirección del alojamiento se llevan a cabo tareas de concienciación para la plantilla en materia de sostenibilidad y/o economía circular (PBP14)"]
["PBP15","15.     El alojamiento ha realizado planes de formación para sus trabajadores en materias de EC.(Ej. ahorro de energía, ahorro de agua, gestión de residuos (reciclaje, reutilización, tratamiento de sustancias peligrosas, …), gestión de desperdicio alimentario, etc.) (PBP15)"]
[null,"POLÍTICAS TRANSVERSALES – SERVICIOS SOSTENIBLES"]
[null,"ACTUACIONES"]
[null,"MOVILIDAD SOSTENIBLE","Sí/No"]
["PBP16","16.     El alojamiento dispone de algún servicio asociado a la movilidad sostenible (PBP16) (Ej. Cargadores eléctricos en sus instalaciones para la recarga de vehículos, motocicletas, patinetes y bicicletas eléctricos; Aparca bicicletas; Ofrece el servicio de alquiler de vehículos, motocicletas, patinetes y bicicletas eléctricas o de bajas emisiones para los clientes y/o colabora con empresas del sector dedicadas a ello; Car-sharing/ coche compartido; Compartir taxi; Traslado al aeropuerto en grupos; Convenio con el transporte local; Alquiler de vehículos compartidos; Fomenta el uso de servicios de movilidad de clientes a través de soluciones sostenibles, etc.)"]
[null,"OTROS SERVICIOS TURÍSTICOS SOSTENIBLES","Sí/No"]
["PBP17","17.     El alojamiento ofrece algún producto y/o servicio turístico con menor huella de carbono(Ej. Gastroturismo ecológico; Ecoturismo; Actividades turísticas en el entorno local para dinamizar la economía rural; etc.) (PBP17)"]
[null,"POLÍTICAS TRANSVERSALES – FINANCIACIÓN, INVERSIÓN Y ASPECTOS ECONÓMICOS, POLÍTICOS Y LEGALES"]
[null,"ACTUACIONES"]
[null,"ASPECTOS ECONÓMICOS, POLÍTICOS Y LEGALES","Sí/No"]
["PBP18","18.     La dirección del alojamiento conoce la legislación sobre sostenibilidad y economía circular que le es de aplicación (PBP18) (Ej. Ley 15/2018, de 7 de junio, de turismo, ocio y hospitalidad de la Comunitat Valenciana; Ley 7/2022, de 8 de abril, de residuos y suelos contaminados para una economía circular; Ley 7/2022, de 16 de diciembre, de la Generalitat, de medidas fiscales para impulsar el turismo sostenible; Ley 3/2022, de 15 de junio, de medidas urgentes para la sostenibilidad y la circularidad del turismo de las Illes Balears; enlace al Código de Turismo del BOE; enlace a normativa de la Comunitat Valenciana; UNE 178501; UNE-ISO 21401; etc.)"]
[null,"FINANCIACIÓN E INVERSIÓN","Sí/No"]
["PBP19","19.     Se conocen los programas de financiación pública disponibles para implantar soluciones sostenibles y de economía circular, a nivel europeo, estatal o regional (PBP19) (Ej. Fondos de la Política de Cohesión; Fondo Social Europeo (FSE); Mecanismo para la Transición Justa; Fondo Europeo de Inversiones Estratégicas —ESFI—; Banco Europeo de Inversiones; Fondo para la Competitividad de las Empresas Turísticas —FOCIT— del Ministerio de Industria, Comercio y Turismo; PYME Circular del Ministerio para la Transición Ecológica y el Reto Demográfico; financiación de AXIS, ENISA, CDTI; etc.)"]

{"sheet":"Energía","index":3,"n_rows":37,"n_cols":11,"rows_kept":37,"cut":false,"hidden":false,"merged":[[32,1,32,2],[0,1,0,2],[1,1,1,2],[11,1,11,2],[21,1,21,2]]}
[null,"ÁREA PRIORITARIA DE ENERGÍA"]
[null,"DATOS"]
[null,"HUELLA DE CARBONO","VALORES"]
["E1B","Huella de carbono anual (t CO2 eq. / año) (E1B)"]
[null,"CERTIFICACIONES ENERGÉTICAS","VALORES"]
["E2B","Certificación energética del edificio (E2B)",null,null,"A","B","C","D","E","F","G"]
[null,"PARÁMETROS ENERGÉTICOS","VALORES",null,1,0.83333333333333337,{"$f":"4/6","v":0.66666666666666663},{"$f":"3/6","v":0.5},{"$f":"2/6","v":0.33333333333333331},{"$f":"1/6","v":0.16666666666666666},0]
["E3B","Capacidad de autoabastecimiento de energía (E3B) (% energía autogenerada/ autoconsumida de fuentes renovables respecto al total de energía consumida al año en el establecimiento)"]
["E4B","Potencia renovable instalada (kWh) (E4B)"]
["E5B","Capacidad de almacenamiento (kWh) (E5B)"]
[null,"GESTIÓN Y CONSUMO RESPONSABLE DE ENERGÍA; EFICIENCIA ENERGÉTICA",null,null,"Sí","No"]
[null,"DATOS"]
[null,"PARÁMETROS ENERGÉTICOS","VALORES"]
["E6","Consumo anual total de energía del alojamiento (MWh/año) (E6)"]
["E7","Consumo anual de energía térmica del alojamiento (MWh/año) (E7)"]
["E8","Consumo anual de energía eléctrica del alojamiento (MWh/año) (E8)"]
[null,"INSTALACIONES ELÉCTRICAS Y DE ILUMINACIÓN","VALORES"]
["E9","Sistemas de iluminación (E9)"]
["E10","Electrodomésticos e instalaciones de cocina (E10)"]
["E11","Electrodomésticos e instalaciones de habitaciones (E11)"]
["E12","Ascensores (E12)"]
[null,"ACTUACIONES"]
[null,"ESTRATEGÍA DE COMPENSACIÓN DE HUELLA DE CARBONO","Sí/No y VALOR"]
["EBP1","1.     Se llevan a cabo programas o iniciativas para compensar la huella de carbono de los procesos o servicios del alojamiento (EBP1)",null,null,"Sí","No"]
["E13","Huella de carbono compensada (E13) (KWh/año)"]
[null,"ESTRATEGÍA DE COMPENSACIÓN DE LA GESTIÓN DE ENERGÍA","Sí/No"]
["EBP21","2.1.     El alojamiento sensibiliza y fomenta a los clientes que reduzcan el consumo de energía en el alojamiento (Ej. El alojamiento informa de la política medioambiental a los clientes al realizar el check-in; Proporciona información sobre ahorro de energía en sistemas de iluminación, así como en sistemas de climatización; etc.) (EBP2.1)"]
["EBP22","2.2     El alojamiento sensibiliza y fomenta a los empleados que reduzcan el consumo de energía en el alojamiento (Ej. El alojamiento informa de la política medioambiental a los clientes al realizar el check-in; Proporciona información sobre ahorro de energía en sistemas de iluminación, así como en sistemas de climatización; etc.) (EBP2.2)"]
["EBP3","3.     El alojamiento dispone de planes de mantenimiento preventivo y predictivo de las instalaciones de gestión de energía (EBP3)"]
[null,"MONITORIZACIÓN Y SEGUIMIENTO DE LA GESTIÓN DE ENERGÍA","Sí/No"]
["EBP4","4. El alojamiento dispone de algún sistema de gestión energética de habitaciones (Ej. Interruptor de tarjetas, Guest Room Management System  GRMS)[1](EBP4)"]
[null,"BUENAS PRÁCTICAS DE EFICIENCIA ENERGÉTICA","Sí/No"]
[null,"BUENAS PRÁCTICAS DE EFICIENCIA ENERGÉTICA EN LA INFRAESTRUCTURA DEL EDIFICIO"]
["EBP5","5. El alojamiento ha llevado a cabo alguna actuación para la rehabilitación energética de los edificios (EBP5) (Ej. La envolvente térmica, las instalaciones térmicas, así como las instalaciones de iluminación son las adecuadas en términos de eficiencia energética, conforme a los últimos requerimientos técnicos de la normativa vigente)"]
["EBP61","6.1 Aislantes en muros y paredes, en los últimos 2-3 años (EBP61) (Ej. En la construcción, reforma y/ o rehabilitación del alojamiento se ha empleado materiales aislantes en muros y paredes, conforme a los últimos requerimientos técnicos de la normativa vigente (Código Técnico de la Edificación (CTE); Reglamento de instalaciones térmicas de los edificios —RITE—; etc.)"]
["EBP62","6.2. De aislamiento térmico de las instalaciones y equipamiento (EBP62) (Ej. En instalaciones de calderas, tuberías de distribución, acumuladores de ACS; en ventanas y puertas exteriores, cristaleras y otro tipo de carpintería; en la envolvente/ fachada exterior del alojamiento; en la cubierta; ..., conforme a los últimos requerimientos técnicos de la normativa vigente —CTE—; etc.)"]
["EBP7","7. El alojamiento dispone de protecciones solares exteriores en las habitaciones, así como en otras zonas comunes, para mejorar la eficiencia energética. (EBP7) (Ej. Protecciones solares fijas o móviles; de distintos colores; Persianas, celosías, vidrio oscuro, cortinas, etc.)"]

{"sheet":"Agua","index":4,"n_rows":15,"n_cols":6,"rows_kept":15,"cut":false,"hidden":false,"merged":[[0,1,0,2],[6,1,6,2],[1,1,1,2]]}
[null,"ÁREA PRIORITARIA DE AGUA"]
[null,"DATOS"]
[null,"CONSUMO Y CAPACIDAD","VALORES"]
["A1B","Capacidad de autoabastecimiento de agua (A1B). (% volumen de agua autocaptada y/o depurada respecto al total de agua en el establecimiento y en las instalaciones del mismo)"]
["A2B","Consumo anual de agua (proveniente de la red pública) (A2B) (L/año)"]
[null,"GESTIÓN Y CONSUMO RESPONSABLE DE AGUA"]
[null,"ACTUACIONES"]
[null,"ESTRATEGÍA Y PLANIFICACIÓN DE LA GESTIÓN DE AGUA","Sí/No"]
["ABP1","1.     El alojamiento fomenta a los clientes que reduzcan el consumo de agua durante su estancia (ABP1) (Ej. El alojamiento proporciona información a los clientes sobre el ahorro de agua en aseos y baños, y sobre el consumo asociado al recambio de toallas y ropa de cama; En el alojamiento se cambia la ropa de cama y las toallas bajo pedido (en lugar de cambiarlas todos los días) para reducir el consumo de agua; Se colocan carteles en las habitaciones y aseos que informan sobre el coste real del servicio de gestión del agua; Se difunde la problemática que genera el desecho de elementos impropios al sistema de saneamiento (aceites, toallitas, productos de higiene femenina —compresas y tampones), bastoncillos de los oídos, …—; etc.)",null,null,"Sí","No"]
["ABP2","2.     El alojamiento dispone de planes de mantenimiento preventivo y predictivo de las instalaciones de gestión del agua (ABP2)"]
[null,"INSTALACIONES Y EQUIPAMIENTO ASOCIADOS A LA GESTIÓN DE AGUA","Sí/No"]
["ABP3","3.     El alojamiento dispone de instalaciones de tratamiento, filtrado y reaprovechamiento de aguas (ABP3).(Ej. Construcción de aljibes para ahorrar agua de riego; Recogida y aprovechamiento de agua de lluvia; Reutilización del agua sobrante de piscinas; Utilizar agua regenerada para riego de jardines, huerto urbano, zonas verdes o sistemas de protección contra incendios; etc.)"]
["ABP41","4.1.     El alojamiento ha realizado alguna de estas prácticas circulares en materia de gestión y consumo responsable de agua en las instalaciones de las habitaciones (ABP41) (Ej. En los grifos de lavabos, bañeras y duchas se dispone de aireadores, difusores, grifos monomando, grifos temporizados, grifos de cierre automático, limitadores de caudal, entre otros; Los inodoros cuentan con doble pulsador, pulsador con interrupción de descarga en las cisternas y/ o con sensores; El alojamiento dispone de duchas en las habitaciones; etc.)"]
["ABP42","4.2,    El alojamiento ha realizado alguna de estas prácticas circulares en materia de gestión y consumo responsable de agua en otras instalaciones del alojamiento (AB42) (Ej. En los grifos de lavabos, bañeras y duchas se dispone de aireadores, difusores, grifos monomando, grifos temporizados, grifos de cierre automático, limitadores de caudal, entre otros; Los inodoros cuentan con doble pulsador, pulsador con interrupción de descarga en las cisternas y/ o con sensores; El alojamiento dispone de duchas en las habitaciones; etc.)"]
["ABP5","5.     El alojamiento dispone de especies vegetales autóctonas que requieren menor consumo de agua (ABP5)"]

{"sheet":"Residuos","index":5,"n_rows":49,"n_cols":10,"rows_kept":49,"cut":false,"hidden":false,"merged":[[31,1,31,2],[0,1,0,2],[1,1,1,2],[6,1,6,2],[15,1,15,2],[27,1,27,2]]}
[null,"ÁREA PRIORITARIA DE MATERIALES Y RESIDUOS"]
[null,"DATOS"]
[null,"JERARQUÍA DE RESIDUOS","CÁLCULOS "]
["R1B","Recogida selectiva de residuos (R1B) (m3/noche) (Volumen estimado, por pernoctación, de residuos recogidos selectivamente —suma de las fracciones de papel y cartón, vidrio, envases, entre otros—)",{"$f":"SUM(C10:C14/365)","v":0}]
["R2B","Reciclaje de residuos de obras, reformas y demoliciones (R2B) (% de residuos reciclados de obras, reformas y demoliciones respecto al total de residuos de construcciones y demoliciones generados durante el último ejercicio, o, en su defecto, durante el último proyecto de obra)"]
[null,"SOSTENIBILIDAD Y GESTIÓN DE RESIDUOS"]
[null,"DATOS",null,null,"Sí","No"]
[null,"RESIDUOS GENERADOS EN EL ALOJAMIENTO","CÁLCULOS "]
[null,"Tipo de residuos","Volumen (m3/año)"]
["R1","Residuos orgánicos  (R1)",{"$f":"J43","v":0}]
["R2","Residuos de plástico (R2)",{"$f":"J44","v":0}]
["R3","Residuos de papel y cartón  (R3)",0]
["R4","Residuos de vidrio (R4)",0]
["R5","Otros residuos recogidos selectivamente (R5)",0]
["R6","Residuos no depositados selectivamente (R6)",0]
[null,"ACTUACIONES"]
[null,"ESTRATEGÍA Y PLANIFICACIÓN DE LA GESTIÓN DE RESIDUOS","Sí/No"]
["RBP1","1.     Se ha elaborado un plan de prevención y gestión de residuos generados en el alojamiento (RBP1)"]
["RBP2","2.     El alojamiento ha realizado alguna de estas prácticas circulares en materia de gestión de residuos, que no sean residuos orgánicos o de alimentación (RBP2) (Ej. Extender la vida del mobiliario, equipos, accesorios; Externalizar el servicio de lavandería, o fomentar el uso del car-sharing o compartir vehículo, etc.; Dar un nuevo uso a productos como las sábanas, toallas, manteles, etc.; Reparar los productos y las infraestructuras en mal estado; Donar mobiliario y equipamiento a otras organizaciones; Implantar sistemas de clasificación, separación y almacenamiento para la recogida selectiva de residuos en el establecimiento por los empleados; Reciclar las sábanas en mal estado para crear alfombras, trapos o aislamiento en materiales de construcción; etc.)"]
["RBP3","3.     El alojamiento fomenta que los clientes que separen los residuos generados durante su estancia (RBP3) (Ej. Colocación de recipientes diferenciados para cada tipo de residuo en las habitaciones y zonas comunes)"]
[null,"SOSTENIBILIDAD DE PRODUCTOS, MATERIALES, ETC.","Sí/No"]
["RBP41","4.1. En el alojamiento se emplean productos químicos sostenibles (RBP41) (Ej. Productos de limpieza —desinfectantes y biocidas, productos de limpieza de instalaciones, productos de limpieza de productos textiles, entre otros—, así como productos de jardinería —fertilizantes, etc.—, o pinturas, que sean sostenibles o tengan etiquetado led ISO Type-1) "]
["RBP42","4.2. En el alojamiento se emplean productos textiles sostenibles (RBP42). (Ej. Productos con etiqueta led ISO Type-1, o uniformes del personal del alojamiento que hayan sido elaborados con materiales sostenibles, entre otros)"]
["RBP43","4.3. En el alojamiento se emplean productos de aseo y cosmética sostenibles (RBP43). (Ej. Geles, jabones, cepillos de dientes, cepillos de pelo, seda dental, esponjas, gorros de ducha, etc., que sean biodegradables o que tengan etiqueta led ISO Type-1; etc.)"]
["RBP44","4.4. En el alojamiento se emplean equipamiento y mobiliario sostenible (RBP44) (Ej. Eco-mobiliario exterior e interior que tenga etiqueta led ISO Type-1; etc.)"]
["RBP45","4.5. En el alojamiento se emplean otros productos sostenibles (RBP45). (Ej. Amenities[1] del alojamiento sostenibles; Impresoras con tintas no contaminantes que tengan etiqueta led ISO Type-1, etc.)"]
[null,"GESTIÓN DE RESIDUOS","Sí/No"]
[null,"GESTIÓN DE RESIDUOS DE PRODUCTOS, ENVASES Y EMBALAJES (PACKAGING)"]
["RBP5","5. Se ha realizado alguna actuación en el alojamiento para eliminar y minimizar los envases y embalajes, así como para sustituir los materiales de estos por otros más sostenibles (RBP5) (Ej. El alojamiento ha eliminado los plásticos de un solo uso como pajitas, bastoncillos, cubiertos, platos, etc.; Compra productos con el mínimo embalaje posible —Ej. Usa las mismas cajas para transvasar productos de los proveedores, entre otros—; Usa la modalidad de graneles frente a la opción de monodosis en productos de alimentación, etc.; Compra geles y jabones en dispensadores rellenables; El alojamiento cuenta con fuentes o dispensadores de agua rellenables —Ej. Aquaservice—.)"]
["RBP6","6. Se ha realizado alguna actuación en el alojamiento para que ciertos envases y embalajes de plástico, papel y cartón y vidrio, sean reutilizables, reciclables o compostables (RBP6) (Ej. Envases de los amenities que sean compostables, biodegradables  o de materiales a base de vegetales renovables, entre otros, o que cuenten con etiqueta led ISO Type-1, etc.)"]
["RBP7","7. Se ha implantado en el alojamiento un sistema de depósito, devolución y retorno de los envases generados por la actividad (de vidrio, de plástico, de papel y cartón, etc.) (RBP7)"]
[null,"GESTIÓN DE RESIDUOS DE MATERIALES DE INSTALACIONES, EQUIPOS E INFRAESTRUCTURA"]
["RBP8","8. En las intervenciones del alojamiento (nueva construcción, reformas y rehabilitaciones) se ha utilizado materiales de construcción revalorizados o estos son sostenibles o cuentan con ecoetiqueta-led ISO Type-1 (RBP8)"]
["RBP9","9. Se realiza un tratamiento adecuado posterior de los residuos de las intervenciones del alojamiento: Separar los residuos; Depositarlos en los contenedores correspondientes; Reutilizar; Reciclar y Revalorizar; etc. (RBP9). (Ej. Los residuos de hormigón, ladrillos, tejas y materiales cerámicos, madera, vidrio, plásticos, mezclas bituminosas, alquitrán de hulla y otros productos alquitranados, metales, tierra, piedras y lodos de drenaje, materiales de aislamiento y materiales de construcción que contengan amianto y los materiales de construcción a base de yeso, deben separarse en bandejas acondicionadas o en sacos de almacenamiento para su posterior gestión)"]
[]
[]
[]
[]
[]
[]
[]
[null,"Tipo de residuos","Contenedor 1100L","Contenedor 3200L","Otro contenedor (L)","Nº contenedores/semana","% Llenado contenedores (promedio)","Volumen (m3/semana)","semanas","Volumen (m3/año)"]
["R1","Residuos orgánicos  (R1)",null,null,null,null,null,null,{"$f":"Información!C5","v":0},{"$f":"H43*I43","v":0}]
["R2","Residuos de plástico (R2) LER 15 01 02 / 20 01 39 / ",null,null,null,null,null,null,{"$f":"Información!C5","v":0},{"$f":"H44*I44","v":0}]
["R3","Residuos de papel y cartón  (R3) LER 15 01 01 / 20 01 01",null,null,null,null,null,null,{"$f":"Información!C5","v":0},0]
["R4","Residuos de vidrio (R4) LER 15 01 07 / 20 01 02",null,null,null,null,null,null,{"$f":"Información!C5","v":0},0]
["R5","Otros residuos recogidos selectivamente (R5) LER 15 01 03 / 15 01 04 / 20 01 08 / 20 01 10 /20 01 11 / 20 01 25 / 20 01 40 / 20 02 ",null,null,null,null,null,null,{"$f":"Información!C5","v":0},0]
["R6","Residuos no depositados selectivamente (R6)",null,null,null,null,null,null,{"$f":"Información!C5","v":0},0]
[null,"TOTAL",null,null,"-","-","-",{"$f":"SUM(H43:H48)","v":0},{"$f":"Información!C5","v":0},0]

{"sheet":"Deperdicio alimentario","index":6,"n_rows":20,"n_cols":6,"rows_kept":20,"cut":false,"hidden":false,"merged":[[0,1,0,2],[1,1,1,2],[5,1,5,2],[6,1,6,2],[10,1,10,2]]}
[null,"ÁREA PRIORITARIA DE ALIMENTOS"]
[null,"DATOS"]
[null,"GASTO EN COMPRA SOSTENIBLE","VALORES"]
["RA1B","Consumo de productos de kilómetro cero[1](RA1B) (% sobre el total de gasto en alimentos y bebidas del establecimiento)"]
["RA2B","Cesta de la compra que minimiza el uso de envases (RA2B)  (% que representan los productos a granel y/o con envases reutilizables/ biodegradables sobre el total de partidas de gasto de aprovisionamientos del establecimiento)"]
[null,"ORIGEN DE LOS PRODUCTOS ALIMENTARIOS Y REDUCCIÓN DEL DESPERDICIO DE ALIMENTOS"]
[null,"DATOS",null,null,"Sí","No"]
[null,"ALIMENTOS NOS CONSUMIDOS","Sí/No y VALOR"]
["RABP1","1.     Se lleva a cabo algún tipo de seguimiento para conocer la cantidad de alimentos no consumidos en el alojamiento (RABP1)"]
["RABP11","Fracción de alimentos no consumidos por diversas causas (RABP11) (Ej. Por estar deteriorados; Por estar caducados; Alimentos desechados por excedentes derivados de la preparación de comidas; Alimentos desechados por excedentes no consumidos por los clientes; etc.) (% de alimentos desechados respecto al total de alimentos disponibles en el alojamiento)"]
[null,"ACTUACIONES"]
[null,"ESTRATEGIA Y PLANIFICACIÓN DEL DESPERDICIO ALIMENTARIO","Sí/No"]
["RABP2","2.     El alojamiento fomenta entre clientes la reducción del desperdicio alimentario durante su estancia (RABP2) (Ej. Formar, sensibilizar e informar a los clientes sobre la prevención y reducción del desperdicio de alimentos y el consumo responsable de alimentos, así como la problemática que genera el desecho de alimentos, etc)"]
[null,"OPTIMIZACIÓN DEL CONSUMO DE ALIMENTOS","Sí/No"]
["RABP3","3.     El alojamiento ha realizado alguna de estas prácticas circulares en materia de optimización del consumo de alimentos y reducción del desperdicio de alimentos (RABP3) (Ej. Realizar una gestión más eficiente de los alimentos; Flexibilizar los menús y adaptarlos a productos de temporada; Elaborar distintos tamaños de platos de comida; Disponer de equipos e infraestructura adecuada para garantizar la cadena de frío de los alimentos; Formar, sensibilizar e informar a los empleados y a los clientes sobre la prevención y reducción del desperdicio de alimentos; Medir en el alojamiento el desperdicio alimentario; etc.)"]
[null,"ORIGEN DE LOS ALIMENTOS","Sí/No"]
["RABP4","4.El alojamiento proporciona en sus servicios de restauración bioalimentos, alimentos de origen orgánico y alimentos ecológicos y sostenibles[1] (RABP4)"]
[null,"GESTIÓN DE RESIDUOS DE ALIMENTOS","Sí/No"]
["RABP5","1.     El alojamiento ha realizado alguna de estas prácticas circulares en materia de gestión de residuos de alimentación y otros residuos orgánicos (RABP5) (Ej. Obtener compost para su uso en agricultura a partir de alimentos desechados; Destinar alimentos orgánicos desechados para fabricar piensos y alimentación animal; Obtener biogás u otros combustibles a partir de alimentos desechados y otros residuos orgánicos; Implantar sistemas de clasificación, separación y almacenamiento para la recogida selectiva de residuos alimentarios en el establecimiento; etc.)"]
["RABP6","2.     El alojamiento ofrece sus excedentes de alimentos a otros usuarios (RABP6) (Ej. Donación de alimentos a comedores sociales, ONGs, etc.; Usar aplicaciones digitales como Too Good To Go; etc.)"]

{"sheet":"Evaluación","index":7,"n_rows":44,"n_cols":17,"rows_kept":44,"cut":false,"hidden":false,"merged":[[0,0,0,4]]}
["EVALUACIÓN ECONOMÍQA CIRCULAR"]
[null,null,null,null,null,null,null,null,null,null,null,2,3,4,5,6,12]
["PLANIFICACIÓN Y EVALUACIÓN CIRCULAR","INDICADOR","VALOR INDICADOR","PUNTUACIÓN ASIGNADA","EVALUACIÓN",null,null,null,null,null,null,"Min","Bajo","Medio","Alto","Max","Puntuación max"]
["INVERSIÓN","P1B",{"$f":"HLOOKUP(B4,'Datos y cálculos'!$A$1:$FI$2,2,FALSE)","v":0},{"$f":"IF(C4<L4,0,IF(C4<P4,ABS((C4-L4)*Q4/(P4-L4)),Q4))","v":0},{"$f":"IF(C4<M4,\"Bajo\",IF(C4<N4,\"Medio\",IF(C4<O4,\"Alto\",\"Muy Alto\")))","v":"Bajo"},null,null,null,null,null,null,{"$f":"VLOOKUP($B4,Scale!$A$2:$L$32,L$2,FALSE)","v":0},{"$f":"VLOOKUP($B4,Scale!$A$2:$L$32,M$2,FALSE)","v":10},{"$f":"VLOOKUP($B4,Scale!$A$2:$L$32,N$2,FALSE)","v":20},{"$f":"VLOOKUP($B4,Scale!$A$2:$L$32,O$2,FALSE)","v":30},{"$f":"VLOOKUP($B4,Scale!$A$2:$L$32,P$2,FALSE)","v":40},{"$f":"VLOOKUP($B4,Scale!$A$2:$L$32,Q$2,FALSE)","v":4}]
["FORMACIÓN DE LA PLANTILLA","P2B",{"$f":"HLOOKUP(B5,'Datos y cálculos'!$A$1:$FI$2,2,FALSE)","v":0},{"$f":"IF(C5<L5,0,IF(C5<P5,ABS((C5-L5)*Q5/(P5-L5)),Q5))","v":0},"Bajo",null,null,null,null,null,null,{"$f":"VLOOKUP($B5,Scale!$A$2:$L$32,L$2,FALSE)","v":0},{"$f":"VLOOKUP($B5,Scale!$A$2:$L$32,M$2,FALSE)","v":25},{"$f":"VLOOKUP($B5,Scale!$A$2:$L$32,N$2,FALSE)","v":50},{"$f":"VLOOKUP($B5,Scale!$A$2:$L$32,O$2,FALSE)","v":75},{"$f":"VLOOKUP($B5,Scale!$A$2:$L$32,P$2,FALSE)","v":100},{"$f":"VLOOKUP($B5,Scale!$A$2:$L$32,Q$2,FALSE)","v":1}]
["COMPROMISO CIRCULAR DE PROVEEDORES","P3B",{"$f":"HLOOKUP(B6,'Datos y cálculos'!$A$1:$FI$2,2,FALSE)","v":0},{"$f":"IF(C6<L6,0,IF(C6<P6,ABS((C6-L6)*Q6/(P6-L6)),Q6))","v":0},"Bajo",null,null,null,null,null,null,{"$f":"VLOOKUP($B6,Scale!$A$2:$L$32,L$2,FALSE)","v":0},{"$f":"VLOOKUP($B6,Scale!$A$2:$L$32,M$2,FALSE)","v":25},{"$f":"VLOOKUP($B6,Scale!$A$2:$L$32,N$2,FALSE)","v":50},{"$f":"VLOOKUP($B6,Scale!$A$2:$L$32,O$2,FALSE)","v":75},{"$f":"VLOOKUP($B6,Scale!$A$2:$L$32,P$2,FALSE)","v":100},{"$f":"VLOOKUP($B6,Scale!$A$2:$L$32,Q$2,FALSE)","v":1}]
["ACTUACIONES","PBP",{"$f":"HLOOKUP(B7,'Datos y cálculos'!$A$1:$FI$2,2,FALSE)","v":0},{"$f":"IF(C7<L7,0,IF(C7<P7,ABS((C7-L7)*Q7/(P7-L7)),Q7))","v":0},{"$f":"IF(C7<M7,\"Bajo\",IF(C7<N7,\"Medio\",IF(C7<O7,\"Alto\",\"Muy Alto\")))","v":"Bajo"},null,null,null,null,null,null,{"$f":"VLOOKUP($B7,Scale!$A$2:$L$32,L$2,FALSE)","v":0},{"$f":"VLOOKUP($B7,Scale!$A$2:$L$32,M$2,FALSE)","v":4.75},{"$f":"VLOOKUP($B7,Scale!$A$2:$L$32,N$2,FALSE)","v":9.5},{"$f":"VLOOKUP($B7,Scale!$A$2:$L$32,O$2,FALSE)","v":14.25},{"$f":"VLOOKUP($B7,Scale!$A$2:$L$32,P$2,FALSE)","v":19},{"$f":"VLOOKUP($B7,Scale!$A$2:$L$32,Q$2,FALSE)","v":14}]
[]
["ÁREA PRIORITARIA DE ENERGÍA","INDICADOR","VALOR INDICADOR","PUNTUACIÓN ASIGNADA","EVALUACIÓN"]
["CONSUMO ENERGÉTICO HUELLA DE CARBONO HAB OCUPADA","E1B2",{"$f":"HLOOKUP(B10,'Datos y cálculos'!$A$1:$FI$2,2,FALSE)","v":{"$error":"#DIV/0!"}},{"$f":"IF(C10<P10,Q10,IF(C10<L10,ABS((C10-L10)*Q10/(P10-L10)),0))","v":{"$error":"#DIV/0!"}},{"$f":"IF(C10>M10,\"Bajo\",IF(C10>N10,\"Medio\",IF(C10>O10,\"Alto\",\"Muy Alto\")))","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,{"$f":"VLOOKUP($B10,Scale!$A$2:$L$32,L$2,FALSE)","v":24.5},{"$f":"VLOOKUP($B10,Scale!$A$2:$L$32,M$2,FALSE)","v":19},{"$f":"VLOOKUP($B10,Scale!$A$2:$L$32,N$2,FALSE)","v":13.5},{"$f":"VLOOKUP($B10,Scale!$A$2:$L$32,O$2,FALSE)","v":8},{"$f":"VLOOKUP($B10,Scale!$A$2:$L$32,P$2,FALSE)","v":2.5},{"$f":"VLOOKUP($B10,Scale!$A$2:$L$32,Q$2,FALSE)","v":2}]
["CONSUMO ENERGÉTICO HUELLA DE CARBONO SUPERFICIE","E1B3",{"$f":"HLOOKUP(B11,'Datos y cálculos'!$A$1:$FI$2,2,FALSE)","v":{"$error":"#DIV/0!"}},{"$f":"IF(C11<P11,Q11,IF(C11<L11,ABS((C11-L11)*Q11/(P11-L11)),0))","v":{"$error":"#DIV/0!"}},{"$f":"IF(C11>M11,\"Bajo\",IF(C11>N11,\"Medio\",IF(C11>O11,\"Alto\",\"Muy Alto\")))","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,{"$f":"VLOOKUP($B11,Scale!$A$2:$L$32,L$2,FALSE)","v":85},{"$f":"VLOOKUP($B11,Scale!$A$2:$L$32,M$2,FALSE)","v":70},{"$f":"VLOOKUP($B11,Scale!$A$2:$L$32,N$2,FALSE)","v":55},{"$f":"VLOOKUP($B11,Scale!$A$2:$L$32,O$2,FALSE)","v":40},{"$f":"VLOOKUP($B11,Scale!$A$2:$L$32,P$2,FALSE)","v":25},{"$f":"VLOOKUP($B11,Scale!$A$2:$L$32,Q$2,FALSE)","v":2}]
["CERTIFICACIÓN ENERGÉTICA EDIFICIO","E2B_val",{"$f":"HLOOKUP(B12,'Datos y cálculos'!$A$1:$FI$2,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"IF(C12<L12,0,IF(C12<P12,ABS((C12-L12)*Q12/(P12-L12)),Q12))","v":{"$error":"#N/A"}},{"$f":"IF(C12<M12,\"Bajo\",IF(C12<N12,\"Medio\",IF(C12<O12,\"Alto\",\"Muy Alto\")))","v":{"$error":"#N/A"}},null,null,null,null,null,null,{"$f":"VLOOKUP($B12,Scale!$A$2:$L$32,L$2,FALSE)","v":0},{"$f":"VLOOKUP($B12,Scale!$A$2:$L$32,M$2,FALSE)","v":0.25},{"$f":"VLOOKUP($B12,Scale!$A$2:$L$32,N$2,FALSE)","v":0.5},{"$f":"VLOOKUP($B12,Scale!$A$2:$L$32,O$2,FALSE)","v":0.75},{"$f":"VLOOKUP($B12,Scale!$A$2:$L$32,P$2,FALSE)","v":1},{"$f":"VLOOKUP($B12,Scale!$A$2:$L$32,Q$2,FALSE)","v":2}]
["CERTIFICACIÓN ENERGÉTICA INSTALACIONES","EI",{"$f":"HLOOKUP(B13,'Datos y cálculos'!$A$1:$FI$2,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"IF(C13<L13,0,IF(C13<P13,ABS((C13-L13)*Q13/(P13-L13)),Q13))","v":{"$error":"#N/A"}},{"$error":"#N/A"},null,null,null,null,null,null,{"$f":"VLOOKUP($B13,Scale!$A$2:$L$32,L$2,FALSE)","v":0},{"$f":"VLOOKUP($B13,Scale!$A$2:$L$32,M$2,FALSE)","v":0.25},{"$f":"VLOOKUP($B13,Scale!$A$2:$L$32,N$2,FALSE)","v":0.5},{"$f":"VLOOKUP($B13,Scale!$A$2:$L$32,O$2,FALSE)","v":0.75},{"$f":"VLOOKUP($B13,Scale!$A$2:$L$32,P$2,FALSE)","v":1},{"$f":"VLOOKUP($B13,Scale!$A$2:$L$32,Q$2,FALSE)","v":2}]
["AUTOABASTECIMIENTO DE ENERGÍA","E3B",{"$f":"HLOOKUP(B14,'Datos y cálculos'!$A$1:$FI$2,2,FALSE)","v":0},{"$f":"IF(C14<L14,0,IF(C14<P14,ABS((C14-L14)*Q14/(P14-L14)),Q14))","v":0},"Bajo",null,null,null,null,null,null,{"$f":"VLOOKUP($B14,Scale!$A$2:$L$32,L$2,FALSE)","v":0},{"$f":"VLOOKUP($B14,Scale!$A$2:$L$32,M$2,FALSE)","v":7.5},{"$f":"VLOOKUP($B14,Scale!$A$2:$L$32,N$2,FALSE)","v":15},{"$f":"VLOOKUP($B14,Scale!$A$2:$L$32,O$2,FALSE)","v":22.5},{"$f":"VLOOKUP($B14,Scale!$A$2:$L$32,P$2,FALSE)","v":30},{"$f":"VLOOKUP($B14,Scale!$A$2:$L$32,Q$2,FALSE)","v":2}]
["CONSUMO ENERGÉTICO POR HUESPED","E62",{"$f":"HLOOKUP(B15,'Datos y cálculos'!$A$1:$FI$2,2,FALSE)","v":{"$error":"#DIV/0!"}},{"$f":"IF(C15<P15,Q15,IF(C15<L15,ABS((C15-L15)*Q15/(P15-L15)),0))","v":{"$error":"#DIV/0!"}},{"$f":"IF(C15>M15,\"Bajo\",IF(C15>N15,\"Medio\",IF(C15>O15,\"Alto\",\"Muy Alto\")))","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,{"$f":"VLOOKUP($B15,Scale!$A$2:$L$32,L$2,FALSE)","v":87.5},{"$f":"VLOOKUP($B15,Scale!$A$2:$L$32,M$2,FALSE)","v":70},{"$f":"VLOOKUP($B15,Scale!$A$2:$L$32,N$2,FALSE)","v":52.5},{"$f":"VLOOKUP($B15,Scale!$A$2:$L$32,O$2,FALSE)","v":35},{"$f":"VLOOKUP($B15,Scale!$A$2:$L$32,P$2,FALSE)","v":17.5},{"$f":"VLOOKUP($B15,Scale!$A$2:$L$32,Q$2,FALSE)","v":2}]
["CONSUMO ENERGÉTICO POR M2","E63",{"$f":"HLOOKUP(B16,'Datos y cálculos'!$A$1:$FI$2,2,FALSE)","v":{"$error":"#DIV/0!"}},{"$f":"IF(C16<P16,Q16,IF(C16<L16,ABS((C16-L16)*Q16/(P16-L16)),0))","v":{"$error":"#DIV/0!"}},{"$f":"IF(C16>M16,\"Bajo\",IF(C16>N16,\"Medio\",IF(C16>O16,\"Alto\",\"Muy Alto\")))","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,{"$f":"VLOOKUP($B16,Scale!$A$2:$L$32,L$2,FALSE)","v":330},{"$f":"VLOOKUP($B16,Scale!$A$2:$L$32,M$2,FALSE)","v":280},{"$f":"VLOOKUP($B16,Scale!$A$2:$L$32,N$2,FALSE)","v":230},{"$f":"VLOOKUP($B16,Scale!$A$2:$L$32,O$2,FALSE)","v":180},{"$f":"VLOOKUP($B16,Scale!$A$2:$L$32,P$2,FALSE)","v":130},{"$f":"VLOOKUP($B16,Scale!$A$2:$L$32,Q$2,FALSE)","v":1}]
["ACTUACIONES","EBP",{"$f":"HLOOKUP(B17,'Datos y cálculos'!$A$1:$FI$2,2,FALSE)","v":0},{"$f":"IF(C17<L17,0,IF(C17<P17,ABS((C17-L17)*Q17/(P17-L17)),Q17))","v":0},"Bajo",null,null,null,null,null,null,{"$f":"VLOOKUP($B17,Scale!$A$2:$L$32,L$2,FALSE)","v":0},{"$f":"VLOOKUP($B17,Scale!$A$2:$L$32,M$2,FALSE)","v":2},{"$f":"VLOOKUP($B17,Scale!$A$2:$L$32,N$2,FALSE)","v":4},{"$f":"VLOOKUP($B17,Scale!$A$2:$L$32,O$2,FALSE)","v":6},{"$f":"VLOOKUP($B17,Scale!$A$2:$L$32,P$2,FALSE)","v":8},{"$f":"VLOOKUP($B17,Scale!$A$2:$L$32,Q$2,FALSE)","v":8}]
[]
["ÁREA PRIORITARIA DE AGUA","INDICADOR","VALOR INDICADOR","PUNTUACIÓN ASIGNADA","EVALUACIÓN"]
["DATOS"]
["AUTOABASTECIMIENTO DE AGUA","A1B",{"$f":"HLOOKUP(B21,'Datos y cálculos'!$A$1:$FI$2,2,FALSE)","v":0},{"$f":"IF(C21<L21,0,IF(C21<P21,ABS((C21-L21)*Q21/(P21-L21)),Q21))","v":0},{"$f":"IF(C21<M21,\"Bajo\",IF(C21<N21,\"Medio\",IF(C21<O21,\"Alto\",\"Muy Alto\")))","v":"Bajo"},null,null,null,null,null,null,{"$f":"VLOOKUP($B21,Scale!$A$2:$L$32,L$2,FALSE)","v":0},{"$f":"VLOOKUP($B21,Scale!$A$2:$L$32,M$2,FALSE)","v":25},{"$f":"VLOOKUP($B21,Scale!$A$2:$L$32,N$2,FALSE)","v":50},{"$f":"VLOOKUP($B21,Scale!$A$2:$L$32,O$2,FALSE)","v":75},{"$f":"VLOOKUP($B21,Scale!$A$2:$L$32,P$2,FALSE)","v":100},{"$f":"VLOOKUP($B21,Scale!$A$2:$L$32,Q$2,FALSE)","v":4}]
["CONSUMO DE AGUA POR HABITACIÓN","A2B2",{"$f":"HLOOKUP(B22,'Datos y cálculos'!$A$1:$FI$2,2,FALSE)","v":{"$error":"#DIV/0!"}},{"$f":"IF(C22<P22,Q22,IF(C22<L22,ABS((C22-L22)*Q22/(P22-L22)),0))","v":{"$error":"#DIV/0!"}},{"$f":"IF(C22>M22,\"Bajo\",IF(C22>N22,\"Medio\",IF(C22>O22,\"Alto\",\"Muy Alto\")))","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,{"$f":"VLOOKUP($B22,Scale!$A$2:$L$32,L$2,FALSE)","v":685},{"$f":"VLOOKUP($B22,Scale!$A$2:$L$32,M$2,FALSE)","v":570},{"$f":"VLOOKUP($B22,Scale!$A$2:$L$32,N$2,FALSE)","v":455},{"$f":"VLOOKUP($B22,Scale!$A$2:$L$32,O$2,FALSE)","v":340},{"$f":"VLOOKUP($B22,Scale!$A$2:$L$32,P$2,FALSE)","v":225},{"$f":"VLOOKUP($B22,Scale!$A$2:$L$32,Q$2,FALSE)","v":6}]
["CONSUMO DE AGUA POR M2","A2B3",{"$f":"HLOOKUP(B23,'Datos y cálculos'!$A$1:$FI$2,2,FALSE)","v":{"$error":"#DIV/0!"}},{"$f":"IF(C23<P23,Q23,IF(C23<L23,ABS((C23-L23)*Q23/(P23-L23)),0))","v":{"$error":"#DIV/0!"}},{"$f":"IF(C23>M23,\"Bajo\",IF(C23>N23,\"Medio\",IF(C23>O23,\"Alto\",\"Muy Alto\")))","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,{"$f":"VLOOKUP($B23,Scale!$A$2:$L$32,L$2,FALSE)","v":3000},{"$f":"VLOOKUP($B23,Scale!$A$2:$L$32,M$2,FALSE)","v":2650},{"$f":"VLOOKUP($B23,Scale!$A$2:$L$32,N$2,FALSE)","v":2000},{"$f":"VLOOKUP($B23,Scale!$A$2:$L$32,O$2,FALSE)","v":1400},{"$f":"VLOOKUP($B23,Scale!$A$2:$L$32,P$2,FALSE)","v":800},{"$f":"VLOOKUP($B23,Scale!$A$2:$L$32,Q$2,FALSE)","v":2}]
["ACTUACIONES","ABP",{"$f":"HLOOKUP(B24,'Datos y cálculos'!$A$1:$FI$2,2,FALSE)","v":0},{"$f":"IF(C24<L24,0,IF(C24<P24,ABS((C24-L24)*Q24/(P24-L24)),Q24))","v":0},{"$f":"IF(C24<M24,\"Bajo\",IF(C24<N24,\"Medio\",IF(C24<O24,\"Alto\",\"Muy Alto\")))","v":"Bajo"},null,null,null,null,null,null,{"$f":"VLOOKUP($B24,Scale!$A$2:$L$32,L$2,FALSE)","v":0},{"$f":"VLOOKUP($B24,Scale!$A$2:$L$32,M$2,FALSE)","v":1.5},{"$f":"VLOOKUP($B24,Scale!$A$2:$L$32,N$2,FALSE)","v":3},{"$f":"VLOOKUP($B24,Scale!$A$2:$L$32,O$2,FALSE)","v":4.5},{"$f":"VLOOKUP($B24,Scale!$A$2:$L$32,P$2,FALSE)","v":6},{"$f":"VLOOKUP($B24,Scale!$A$2:$L$32,Q$2,FALSE)","v":8}]
[]
["ÁREA PRIORITARIA DE MATERIALES Y RESIDUOS","INDICADOR","VALOR INDICADOR","PUNTUACIÓN ASIGNADA","EVALUACIÓN"]
["RESIDUOS VALORIZADOS","Rval",{"$f":"HLOOKUP(B27,'Datos y cálculos'!$A$1:$FI$2,2,FALSE)","v":{"$error":"#DIV/0!"}},{"$f":"IF(C27<L27,0,IF(C27<P27,ABS((C27-L27)*Q27/(P27-L27)),Q27))","v":{"$error":"#DIV/0!"}},{"$f":"IF(C27<M27,\"Bajo\",IF(C27<N27,\"Medio\",IF(C27<O27,\"Alto\",\"Muy Alto\")))","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,{"$f":"VLOOKUP($B27,Scale!$A$2:$L$32,L$2,FALSE)","v":0},{"$f":"VLOOKUP($B27,Scale!$A$2:$L$32,M$2,FALSE)","v":25},{"$f":"VLOOKUP($B27,Scale!$A$2:$L$32,N$2,FALSE)","v":50},{"$f":"VLOOKUP($B27,Scale!$A$2:$L$32,O$2,FALSE)","v":75},{"$f":"VLOOKUP($B27,Scale!$A$2:$L$32,P$2,FALSE)","v":100},{"$f":"VLOOKUP($B27,Scale!$A$2:$L$32,Q$2,FALSE)","v":10}]
["RESIDUOS CONSTRUCCIÓN","R2B",{"$f":"HLOOKUP(B28,'Datos y cálculos'!$A$1:$FI$2,2,FALSE)","v":0},{"$f":"IF(C28<L28,0,IF(C28<P28,ABS((C28-L28)*Q28/(P28-L28)),Q28))","v":0},"Bajo",null,null,null,null,null,null,{"$f":"VLOOKUP($B28,Scale!$A$2:$L$32,L$2,FALSE)","v":0},{"$f":"VLOOKUP($B28,Scale!$A$2:$L$32,M$2,FALSE)","v":25},{"$f":"VLOOKUP($B28,Scale!$A$2:$L$32,N$2,FALSE)","v":50},{"$f":"VLOOKUP($B28,Scale!$A$2:$L$32,O$2,FALSE)","v":75},{"$f":"VLOOKUP($B28,Scale!$A$2:$L$32,P$2,FALSE)","v":100},{"$f":"VLOOKUP($B28,Scale!$A$2:$L$32,Q$2,FALSE)","v":2}]
["ACTUACIONES","RBP",{"$f":"HLOOKUP(B29,'Datos y cálculos'!$A$1:$FI$2,2,FALSE)","v":0},{"$f":"IF(C29<L29,0,IF(C29<P29,ABS((C29-L29)*Q29/(P29-L29)),Q29))","v":0},"Bajo",null,null,null,null,null,null,{"$f":"VLOOKUP($B29,Scale!$A$2:$L$32,L$2,FALSE)","v":0},{"$f":"VLOOKUP($B29,Scale!$A$2:$L$32,M$2,FALSE)","v":3},{"$f":"VLOOKUP($B29,Scale!$A$2:$L$32,N$2,FALSE)","v":6},{"$f":"VLOOKUP($B29,Scale!$A$2:$L$32,O$2,FALSE)","v":9},{"$f":"VLOOKUP($B29,Scale!$A$2:$L$32,P$2,FALSE)","v":12},{"$f":"VLOOKUP($B29,Scale!$A$2:$L$32,Q$2,FALSE)","v":8}]
[]
["ÁREA PRIORITARIA DE ALIMENTOS","INDICADOR","VALOR INDICADOR","PUNTUACIÓN ASIGNADA","EVALUACIÓN"]
["ALIMENTOS KM0","RA1B",{"$f":"HLOOKUP(B32,'Datos y cálculos'!$A$1:$FI$2,2,FALSE)","v":0},{"$f":"IF(C32<L32,0,IF(C32<P32,ABS((C32-L32)*Q32/(P32-L32)),Q32))","v":0},{"$f":"IF(C32<M32,\"Bajo\",IF(C32<N32,\"Medio\",IF(C32<O32,\"Alto\",\"Muy Alto\")))","v":"Bajo"},null,null,null,null,null,null,{"$f":"VLOOKUP($B32,Scale!$A$2:$L$32,L$2,FALSE)","v":0},{"$f":"VLOOKUP($B32,Scale!$A$2:$L$32,M$2,FALSE)","v":12.5},{"$f":"VLOOKUP($B32,Scale!$A$2:$L$32,N$2,FALSE)","v":25},{"$f":"VLOOKUP($B32,Scale!$A$2:$L$32,O$2,FALSE)","v":37.5},{"$f":"VLOOKUP($B32,Scale!$A$2:$L$32,P$2,FALSE)","v":50},{"$f":"VLOOKUP($B32,Scale!$A$2:$L$32,Q$2,FALSE)","v":4}]
["ALIMENTOS REDUCCIÓN DE ENVASES","RA2B",{"$f":"HLOOKUP(B33,'Datos y cálculos'!$A$1:$FI$2,2,FALSE)","v":0},{"$f":"IF(C33<L33,0,IF(C33<P33,ABS((C33-L33)*Q33/(P33-L33)),Q33))","v":0},"Bajo",null,null,null,null,null,null,{"$f":"VLOOKUP($B33,Scale!$A$2:$L$32,L$2,FALSE)","v":0},{"$f":"VLOOKUP($B33,Scale!$A$2:$L$32,M$2,FALSE)","v":12.5},{"$f":"VLOOKUP($B33,Scale!$A$2:$L$32,N$2,FALSE)","v":25},{"$f":"VLOOKUP($B33,Scale!$A$2:$L$32,O$2,FALSE)","v":37.5},{"$f":"VLOOKUP($B33,Scale!$A$2:$L$32,P$2,FALSE)","v":50},{"$f":"VLOOKUP($B33,Scale!$A$2:$L$32,Q$2,FALSE)","v":4}]
["ACTUACIONES","RABP",{"$f":"HLOOKUP(B34,'Datos y cálculos'!$A$1:$FI$2,2,FALSE)","v":0},{"$f":"IF(C34<L34,0,IF(C34<P34,ABS((C34-L34)*Q34/(P34-L34)),Q34))","v":0},"Bajo",null,null,null,null,null,null,{"$f":"VLOOKUP($B34,Scale!$A$2:$L$32,L$2,FALSE)","v":0},{"$f":"VLOOKUP($B34,Scale!$A$2:$L$32,M$2,FALSE)","v":1.25},{"$f":"VLOOKUP($B34,Scale!$A$2:$L$32,N$2,FALSE)","v":2.5},{"$f":"VLOOKUP($B34,Scale!$A$2:$L$32,O$2,FALSE)","v":3.75},{"$f":"VLOOKUP($B34,Scale!$A$2:$L$32,P$2,FALSE)","v":5},{"$f":"VLOOKUP($B34,Scale!$A$2:$L$32,Q$2,FALSE)","v":12}]
[]
["TOTALES",null,"VALOR INDICADOR","PUNTUACIÓN ASIGNADA","EVALUACIÓN"]
["PLANIFICACIÓN Y EVALUACIÓN CIRCULAR","Planificación y Gestión Circular",{"$f":"SUM(D4:D7)","v":0},{"$f":"IF(C37<L37,0,IF(C37<P37,ABS((C37-L37)*Q37/(P37-L37)),Q37))","v":0},{"$f":"IF(C37<M37,\"Bajo\",IF(C37<N37,\"Medio\",IF(C37<O37,\"Alto\",\"Muy Alto\")))","v":"Bajo"},null,null,null,null,null,null,{"$f":"VLOOKUP($B37,Scale!$A$2:$L$32,L$2,FALSE)","v":0},{"$f":"VLOOKUP($B37,Scale!$A$2:$L$32,M$2,FALSE)","v":5},{"$f":"VLOOKUP($B37,Scale!$A$2:$L$32,N$2,FALSE)","v":10},{"$f":"VLOOKUP($B37,Scale!$A$2:$L$32,O$2,FALSE)","v":15},{"$f":"VLOOKUP($B37,Scale!$A$2:$L$32,P$2,FALSE)","v":20},{"$f":"VLOOKUP($B37,Scale!$A$2:$L$32,Q$2,FALSE)","v":20}]
["ÁREA PRIORITARIA DE ENERGÍA","Energía",{"$f":"SUM(D10:D17)","v":{"$error":"#DIV/0!"}},{"$f":"IF(C38<L38,0,IF(C38<P38,ABS((C38-L38)*Q38/(P38-L38)),Q38))","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},null,null,null,null,null,null,{"$f":"VLOOKUP($B38,Scale!$A$2:$L$32,L$2,FALSE)","v":0},{"$f":"VLOOKUP($B38,Scale!$A$2:$L$32,M$2,FALSE)","v":5},{"$f":"VLOOKUP($B38,Scale!$A$2:$L$32,N$2,FALSE)","v":10},{"$f":"VLOOKUP($B38,Scale!$A$2:$L$32,O$2,FALSE)","v":15},{"$f":"VLOOKUP($B38,Scale!$A$2:$L$32,P$2,FALSE)","v":20},{"$f":"VLOOKUP($B38,Scale!$A$2:$L$32,Q$2,FALSE)","v":20}]
["ÁREA PRIORITARIA DE AGUA","Agua",{"$f":"SUM(D21:D24)","v":{"$error":"#DIV/0!"}},{"$f":"IF(C39<L39,0,IF(C39<P39,ABS((C39-L39)*Q39/(P39-L39)),Q39))","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},null,null,null,null,null,null,{"$f":"VLOOKUP($B39,Scale!$A$2:$L$32,L$2,FALSE)","v":0},{"$f":"VLOOKUP($B39,Scale!$A$2:$L$32,M$2,FALSE)","v":5},{"$f":"VLOOKUP($B39,Scale!$A$2:$L$32,N$2,FALSE)","v":10},{"$f":"VLOOKUP($B39,Scale!$A$2:$L$32,O$2,FALSE)","v":15},{"$f":"VLOOKUP($B39,Scale!$A$2:$L$32,P$2,FALSE)","v":20},{"$f":"VLOOKUP($B39,Scale!$A$2:$L$32,Q$2,FALSE)","v":20}]
["ÁREA PRIORITARIA DE MATERIALES Y RESIDUOS","Residuos",{"$f":"SUM(D27:D29)","v":{"$error":"#DIV/0!"}},{"$f":"IF(C40<L40,0,IF(C40<P40,ABS((C40-L40)*Q40/(P40-L40)),Q40))","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},null,null,null,null,null,null,{"$f":"VLOOKUP($B40,Scale!$A$2:$L$32,L$2,FALSE)","v":0},{"$f":"VLOOKUP($B40,Scale!$A$2:$L$32,M$2,FALSE)","v":5},{"$f":"VLOOKUP($B40,Scale!$A$2:$L$32,N$2,FALSE)","v":10},{"$f":"VLOOKUP($B40,Scale!$A$2:$L$32,O$2,FALSE)","v":15},{"$f":"VLOOKUP($B40,Scale!$A$2:$L$32,P$2,FALSE)","v":20},{"$f":"VLOOKUP($B40,Scale!$A$2:$L$32,Q$2,FALSE)","v":20}]
["ÁREA PRIORITARIA DE ALIMENTOS","Desperdicio Alimentario",{"$f":"SUM(D32:D34)","v":0},{"$f":"IF(C41<L41,0,IF(C41<P41,ABS((C41-L41)*Q41/(P41-L41)),Q41))","v":0},"Bajo",null,null,null,null,null,null,{"$f":"VLOOKUP($B41,Scale!$A$2:$L$32,L$2,FALSE)","v":0},{"$f":"VLOOKUP($B41,Scale!$A$2:$L$32,M$2,FALSE)","v":5},{"$f":"VLOOKUP($B41,Scale!$A$2:$L$32,N$2,FALSE)","v":10},{"$f":"VLOOKUP($B41,Scale!$A$2:$L$32,O$2,FALSE)","v":15},{"$f":"VLOOKUP($B41,Scale!$A$2:$L$32,P$2,FALSE)","v":20},{"$f":"VLOOKUP($B41,Scale!$A$2:$L$32,Q$2,FALSE)","v":20}]
[]
[null,null,"VALOR INDICADOR","PUNTUACIÓN ASIGNADA","EVALUACIÓN"]
["NIVEL DE CIRCULARIDAD","Nivel de Circularidad",{"$f":"SUM(C37:C41)","v":{"$error":"#DIV/0!"}},{"$f":"IF(C44<L44,0,IF(C44<P44,ABS((C44-L44)*Q44/(P44-L44)),1))","v":{"$error":"#DIV/0!"}},{"$f":"IF(C44<M44,\"Bajo\",IF(C44<N44,\"Medio\",IF(C44<O44,\"Alto\",\"Muy Alto\")))","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,{"$f":"VLOOKUP($B44,Scale!$A$2:$L$32,L$2,FALSE)","v":0},{"$f":"VLOOKUP($B44,Scale!$A$2:$L$32,M$2,FALSE)","v":25},{"$f":"VLOOKUP($B44,Scale!$A$2:$L$32,N$2,FALSE)","v":50},{"$f":"VLOOKUP($B44,Scale!$A$2:$L$32,O$2,FALSE)","v":75},{"$f":"VLOOKUP($B44,Scale!$A$2:$L$32,P$2,FALSE)","v":100},{"$f":"VLOOKUP($B44,Scale!$A$2:$L$32,Q$2,FALSE)","v":100}]

{"sheet":"HUELLA","index":8,"n_rows":99,"n_cols":11,"rows_kept":99,"cut":false,"hidden":false,"merged":[[80,1,80,5],[1,2,1,10],[67,2,67,10],[18,1,18,10],[32,1,32,10],[51,1,51,9],[70,1,70,5],[4,1,4,10],[52,8,53,8],[52,9,53,9],[71,1,72,1],[71,2,72,2],[71,3,72,3],[71,4,72,4],[71,5,72,5],[52,1,53,1],[81,1,82,1],[81,2,82,2],[81,3,82,3],[81,4,82,4],[81,5,82,5],[52,2,53,2],[52,3,53,3],[52,4,52,5],[52,6,53,6],[52,7,53,7],[33,2,35,2],[33,3,35,3],[33,4,33,6],[33,7,34,9],[33,10,35,10],[34,4,34,6],[19,10,21,10],[20,4,20,6],[5,1,7,1],[5,2,7,2],[5,3,7,3],[5,4,5,6],[5,7,6,9],[5,10,7,10],[6,4,6,6],[19,1,21,1],[19,2,21,2],[19,3,21,3],[19,4,19,6],[19,7,20,9]]}
[]
[null,"ALCANCE 1: EMISIONES DIRECTAS","CONSUMOS DE FLOTA DE VEHICULOS DE COMBUSTIÓN, INSTALACIONES FIJAS Y FUGITIVAS"]
[]
[]
[null,"EMISIONES DE LA FLOTA DE VEHÍCULOS DE COMBUSTIÓN POR CANTIDAD DE COMBUSTIBLE CONSUMIDA AL AÑO"]
[null,"Categoría de vehículo","Tipo de Combustible","Cantidad comb. (ud)","Factor emisión",null,null,"Emisiones parciales",null,null,"Emisiones \ntotales\nkg CO2e"]
[null,null,null,null,"Por defecto"]
[null,null,null,null,"CO2 (kg/ud)","CH4 (g/ud)","N2O (g/ud)","kg CO2","g CH4","g N2O"]
[null,null,null,null,{"$f":"IFERROR(INDEX(DATOS!$E$4:$G$37,MATCH($C9&$B9,DATOS!$D$4:$D$37,0),MATCH(E$8,DATOS!$E$3:$G$3,0)),\"-\")","v":"-"},{"$f":"IFERROR(INDEX(DATOS!$E$4:$G$37,MATCH($C9&$B9,DATOS!$D$4:$D$37,0),MATCH(F$8,DATOS!$E$3:$G$3,0)),\"-\")","v":"-"},{"$f":"IFERROR(INDEX(DATOS!$E$4:$G$37,MATCH($C9&$B9,DATOS!$D$4:$D$37,0),MATCH(G$8,DATOS!$E$3:$G$3,0)),\"-\")","v":"-"},{"$f":"IFERROR($D9*E9,\"-\")","v":"-"},{"$f":"IFERROR($D9*F9,\"-\")","v":"-"},{"$f":"IFERROR($D9*G9,\"-\")","v":"-"},{"$f":"IFERROR(H9+I9*(DATOS!$J$2/1000)+J9*(DATOS!$J$3/1000),\"-\")","v":"-"}]
[null,null,null,null,{"$f":"IFERROR(INDEX(DATOS!$E$4:$G$37,MATCH($C10&$B10,DATOS!$D$4:$D$37,0),MATCH(E$8,DATOS!$E$3:$G$3,0)),\"-\")","v":"-"},{"$f":"IFERROR(INDEX(DATOS!$E$4:$G$37,MATCH($C10&$B10,DATOS!$D$4:$D$37,0),MATCH(F$8,DATOS!$E$3:$G$3,0)),\"-\")","v":"-"},{"$f":"IFERROR(INDEX(DATOS!$E$4:$G$37,MATCH($C10&$B10,DATOS!$D$4:$D$37,0),MATCH(G$8,DATOS!$E$3:$G$3,0)),\"-\")","v":"-"},{"$f":"IFERROR($D10*E10,\"-\")","v":"-"},{"$f":"IFERROR($D10*F10,\"-\")","v":"-"},{"$f":"IFERROR($D10*G10,\"-\")","v":"-"},{"$f":"IFERROR(H10+I10*(DATOS!$J$2/1000)+J10*(DATOS!$J$3/1000),\"-\")","v":"-"}]
[null,null,null,null,{"$f":"IFERROR(INDEX(DATOS!$E$4:$G$37,MATCH($C11&$B11,DATOS!$D$4:$D$37,0),MATCH(E$8,DATOS!$E$3:$G$3,0)),\"-\")","v":"-"},{"$f":"IFERROR(INDEX(DATOS!$E$4:$G$37,MATCH($C11&$B11,DATOS!$D$4:$D$37,0),MATCH(F$8,DATOS!$E$3:$G$3,0)),\"-\")","v":"-"},{"$f":"IFERROR(INDEX(DATOS!$E$4:$G$37,MATCH($C11&$B11,DATOS!$D$4:$D$37,0),MATCH(G$8,DATOS!$E$3:$G$3,0)),\"-\")","v":"-"},"-","-","-",{"$f":"IFERROR(H11+I11*(DATOS!$J$2/1000)+J11*(DATOS!$J$3/1000),\"-\")","v":"-"}]
[null,null,null,null,{"$f":"IFERROR(INDEX(DATOS!$E$4:$G$37,MATCH($C12&$B12,DATOS!$D$4:$D$37,0),MATCH(E$8,DATOS!$E$3:$G$3,0)),\"-\")","v":"-"},{"$f":"IFERROR(INDEX(DATOS!$E$4:$G$37,MATCH($C12&$B12,DATOS!$D$4:$D$37,0),MATCH(F$8,DATOS!$E$3:$G$3,0)),\"-\")","v":"-"},{"$f":"IFERROR(INDEX(DATOS!$E$4:$G$37,MATCH($C12&$B12,DATOS!$D$4:$D$37,0),MATCH(G$8,DATOS!$E$3:$G$3,0)),\"-\")","v":"-"},"-","-","-",{"$f":"IFERROR(H12+I12*(DATOS!$J$2/1000)+J12*(DATOS!$J$3/1000),\"-\")","v":"-"}]
[null,null,null,null,{"$f":"IFERROR(INDEX(DATOS!$E$4:$G$37,MATCH($C13&$B13,DATOS!$D$4:$D$37,0),MATCH(E$8,DATOS!$E$3:$G$3,0)),\"-\")","v":"-"},{"$f":"IFERROR(INDEX(DATOS!$E$4:$G$37,MATCH($C13&$B13,DATOS!$D$4:$D$37,0),MATCH(F$8,DATOS!$E$3:$G$3,0)),\"-\")","v":"-"},{"$f":"IFERROR(INDEX(DATOS!$E$4:$G$37,MATCH($C13&$B13,DATOS!$D$4:$D$37,0),MATCH(G$8,DATOS!$E$3:$G$3,0)),\"-\")","v":"-"},"-","-","-",{"$f":"IFERROR(H13+I13*(DATOS!$J$2/1000)+J13*(DATOS!$J$3/1000),\"-\")","v":"-"}]
[null,null,null,null,{"$f":"IFERROR(INDEX(DATOS!$E$4:$G$37,MATCH($C14&$B14,DATOS!$D$4:$D$37,0),MATCH(E$8,DATOS!$E$3:$G$3,0)),\"-\")","v":"-"},{"$f":"IFERROR(INDEX(DATOS!$E$4:$G$37,MATCH($C14&$B14,DATOS!$D$4:$D$37,0),MATCH(F$8,DATOS!$E$3:$G$3,0)),\"-\")","v":"-"},{"$f":"IFERROR(INDEX(DATOS!$E$4:$G$37,MATCH($C14&$B14,DATOS!$D$4:$D$37,0),MATCH(G$8,DATOS!$E$3:$G$3,0)),\"-\")","v":"-"},"-","-","-",{"$f":"IFERROR(H14+I14*(DATOS!$J$2/1000)+J14*(DATOS!$J$3/1000),\"-\")","v":"-"}]
[null,null,null,null,{"$f":"IFERROR(INDEX(DATOS!$E$4:$G$37,MATCH($C15&$B15,DATOS!$D$4:$D$37,0),MATCH(E$8,DATOS!$E$3:$G$3,0)),\"-\")","v":"-"},{"$f":"IFERROR(INDEX(DATOS!$E$4:$G$37,MATCH($C15&$B15,DATOS!$D$4:$D$37,0),MATCH(F$8,DATOS!$E$3:$G$3,0)),\"-\")","v":"-"},{"$f":"IFERROR(INDEX(DATOS!$E$4:$G$37,MATCH($C15&$B15,DATOS!$D$4:$D$37,0),MATCH(G$8,DATOS!$E$3:$G$3,0)),\"-\")","v":"-"},"-","-","-",{"$f":"IFERROR(H15+I15*(DATOS!$J$2/1000)+J15*(DATOS!$J$3/1000),\"-\")","v":"-"}]
[null,null,null,null,null,null,"SUMA EMISIONES",{"$f":"SUM(H9:H15)","v":0},{"$f":"SUM(I9:I15)","v":0},0,0]
[]
[]
[null,"EMISIONES DE LA FLOTA DE VEHÍCULOS DE COMBUSTIÓN POR KILOMETROS RECORRIDOS AL AÑO"]
[null,"Categoría de vehículo","Tipo de Combustible","KM Recorridos","Factor emisión",null,null,"Emisiones parciales",null,null,"Emisiones \ntotales\nkg CO2e"]
[null,null,null,null,"Por defecto"]
[null,null,null,null,"CO2 (kg/ud)","CH4 (g/ud)","N2O (g/ud)","kg CO2","g CH4","g N2O"]
[null,null,null,null,{"$f":"IFERROR(INDEX(DATOS!$E$41:$G$50,MATCH(HUELLA!$C23&HUELLA!$B23,DATOS!$D$41:$D$50,0),MATCH(HUELLA!E$22,DATOS!$E$40:$G$40,0)),\"-\")","v":"-"},{"$f":"IFERROR(INDEX(DATOS!$E$41:$G$50,MATCH(HUELLA!$C23&HUELLA!$B23,DATOS!$D$41:$D$50,0),MATCH(HUELLA!F$22,DATOS!$E$40:$G$40,0)),\"-\")","v":"-"},{"$f":"IFERROR(INDEX(DATOS!$E$41:$G$50,MATCH(HUELLA!$C23&HUELLA!$B23,DATOS!$D$41:$D$50,0),MATCH(HUELLA!G$22,DATOS!$E$40:$G$40,0)),\"-\")","v":"-"},{"$f":"IFERROR($D23*E23,\"-\")","v":"-"},{"$f":"IFERROR($D23*F23,\"-\")","v":"-"},{"$f":"IFERROR($D23*G23,\"-\")","v":"-"},{"$f":"IFERROR(H23+I23*(DATOS!$J$2/1000)+J23*(DATOS!$J$3/1000),\"-\")","v":"-"}]
[null,null,null,null,{"$f":"IFERROR(INDEX(DATOS!$E$41:$G$50,MATCH(HUELLA!$C24&HUELLA!$B24,DATOS!$D$41:$D$50,0),MATCH(HUELLA!E$22,DATOS!$E$40:$G$40,0)),\"-\")","v":"-"},{"$f":"IFERROR(INDEX(DATOS!$E$41:$G$50,MATCH(HUELLA!$C24&HUELLA!$B24,DATOS!$D$41:$D$50,0),MATCH(HUELLA!F$22,DATOS!$E$40:$G$40,0)),\"-\")","v":"-"},{"$f":"IFERROR(INDEX(DATOS!$E$41:$G$50,MATCH(HUELLA!$C24&HUELLA!$B24,DATOS!$D$41:$D$50,0),MATCH(HUELLA!G$22,DATOS!$E$40:$G$40,0)),\"-\")","v":"-"},{"$f":"IFERROR($D24*E24,\"-\")","v":"-"},{"$f":"IFERROR($D24*F24,\"-\")","v":"-"},{"$f":"IFERROR($D24*G24,\"-\")","v":"-"},{"$f":"IFERROR(H24+I24*(DATOS!$J$2/1000)+J24*(DATOS!$J$3/1000),\"-\")","v":"-"}]
[null,null,null,null,{"$f":"IFERROR(INDEX(DATOS!$E$41:$G$50,MATCH(HUELLA!$C25&HUELLA!$B25,DATOS!$D$41:$D$50,0),MATCH(HUELLA!E$22,DATOS!$E$40:$G$40,0)),\"-\")","v":"-"},{"$f":"IFERROR(INDEX(DATOS!$E$41:$G$50,MATCH(HUELLA!$C25&HUELLA!$B25,DATOS!$D$41:$D$50,0),MATCH(HUELLA!F$22,DATOS!$E$40:$G$40,0)),\"-\")","v":"-"},{"$f":"IFERROR(INDEX(DATOS!$E$41:$G$50,MATCH(HUELLA!$C25&HUELLA!$B25,DATOS!$D$41:$D$50,0),MATCH(HUELLA!G$22,DATOS!$E$40:$G$40,0)),\"-\")","v":"-"},{"$f":"IFERROR($D25*E25,\"-\")","v":"-"},"-","-",{"$f":"IFERROR(H25+I25*(DATOS!$J$2/1000)+J25*(DATOS!$J$3/1000),\"-\")","v":"-"}]
[null,null,null,null,{"$f":"IFERROR(INDEX(DATOS!$E$41:$G$50,MATCH(HUELLA!$C26&HUELLA!$B26,DATOS!$D$41:$D$50,0),MATCH(HUELLA!E$22,DATOS!$E$40:$G$40,0)),\"-\")","v":"-"},{"$f":"IFERROR(INDEX(DATOS!$E$41:$G$50,MATCH(HUELLA!$C26&HUELLA!$B26,DATOS!$D$41:$D$50,0),MATCH(HUELLA!F$22,DATOS!$E$40:$G$40,0)),\"-\")","v":"-"},{"$f":"IFERROR(INDEX(DATOS!$E$41:$G$50,MATCH(HUELLA!$C26&HUELLA!$B26,DATOS!$D$41:$D$50,0),MATCH(HUELLA!G$22,DATOS!$E$40:$G$40,0)),\"-\")","v":"-"},"-","-","-",{"$f":"IFERROR(H26+I26*(DATOS!$J$2/1000)+J26*(DATOS!$J$3/1000),\"-\")","v":"-"}]
[null,null,null,null,{"$f":"IFERROR(INDEX(DATOS!$E$41:$G$50,MATCH(HUELLA!$C27&HUELLA!$B27,DATOS!$D$41:$D$50,0),MATCH(HUELLA!E$22,DATOS!$E$40:$G$40,0)),\"-\")","v":"-"},{"$f":"IFERROR(INDEX(DATOS!$E$41:$G$50,MATCH(HUELLA!$C27&HUELLA!$B27,DATOS!$D$41:$D$50,0),MATCH(HUELLA!F$22,DATOS!$E$40:$G$40,0)),\"-\")","v":"-"},{"$f":"IFERROR(INDEX(DATOS!$E$41:$G$50,MATCH(HUELLA!$C27&HUELLA!$B27,DATOS!$D$41:$D$50,0),MATCH(HUELLA!G$22,DATOS!$E$40:$G$40,0)),\"-\")","v":"-"},"-","-","-",{"$f":"IFERROR(H27+I27*(DATOS!$J$2/1000)+J27*(DATOS!$J$3/1000),\"-\")","v":"-"}]
[null,null,null,null,{"$f":"IFERROR(INDEX(DATOS!$E$41:$G$50,MATCH(HUELLA!$C28&HUELLA!$B28,DATOS!$D$41:$D$50,0),MATCH(HUELLA!E$22,DATOS!$E$40:$G$40,0)),\"-\")","v":"-"},{"$f":"IFERROR(INDEX(DATOS!$E$41:$G$50,MATCH(HUELLA!$C28&HUELLA!$B28,DATOS!$D$41:$D$50,0),MATCH(HUELLA!F$22,DATOS!$E$40:$G$40,0)),\"-\")","v":"-"},{"$f":"IFERROR(INDEX(DATOS!$E$41:$G$50,MATCH(HUELLA!$C28&HUELLA!$B28,DATOS!$D$41:$D$50,0),MATCH(HUELLA!G$22,DATOS!$E$40:$G$40,0)),\"-\")","v":"-"},"-","-","-",{"$f":"IFERROR(H28+I28*(DATOS!$J$2/1000)+J28*(DATOS!$J$3/1000),\"-\")","v":"-"}]
[null,null,null,null,{"$f":"IFERROR(INDEX(DATOS!$E$41:$G$50,MATCH(HUELLA!$C29&HUELLA!$B29,DATOS!$D$41:$D$50,0),MATCH(HUELLA!E$22,DATOS!$E$40:$G$40,0)),\"-\")","v":"-"},{"$f":"IFERROR(INDEX(DATOS!$E$41:$G$50,MATCH(HUELLA!$C29&HUELLA!$B29,DATOS!$D$41:$D$50,0),MATCH(HUELLA!F$22,DATOS!$E$40:$G$40,0)),\"-\")","v":"-"},{"$f":"IFERROR(INDEX(DATOS!$E$41:$G$50,MATCH(HUELLA!$C29&HUELLA!$B29,DATOS!$D$41:$D$50,0),MATCH(HUELLA!G$22,DATOS!$E$40:$G$40,0)),\"-\")","v":"-"},"-","-","-",{"$f":"IFERROR(H29+I29*(DATOS!$J$2/1000)+J29*(DATOS!$J$3/1000),\"-\")","v":"-"}]
[null,null,null,null,null,null,"SUMA EMISIONES",{"$f":"SUM(H23:H29)","v":0},{"$f":"SUM(I23:I29)","v":0},0,0]
[]
[]
[null,"EMISIONES DE INSTALACIONES FIJAS (CALDERAS, MOTORES ESTACIONARIOS, ETC.)* POR CANTIDAD DE COMBUSTIBLE CONSUMIDA AL AÑO"]
[null,null,"Tipo de Combustible","Cantidad comb. (ud)","Factor emisión",null,null,"Emisiones parciales A.1",null,null,"Emisiones \ntotales A1\nkg CO2e"]
[null,null,null,null,"Por defecto"]
[null,null,null,null,"CO2 (kg/ud)","CH4 (g/ud)","N2O (g/ud)","kg CO2","g CH4","g N2O"]
[null,"*NO SUJETAS A LAS OBLIGACIONES ESTABLECIDAS EN LA LEY 1/2005, DE 9 DE MARZO",null,null,{"$f":"IFERROR(INDEX(DATOS!$E$57:$G$77,MATCH($C37,DATOS!$D$57:$D$77,0),MATCH(E$36,DATOS!$E$56:$G$56,0)),\"-\")","v":"-"},{"$f":"IFERROR(INDEX(DATOS!$E$57:$G$77,MATCH($C37,DATOS!$D$57:$D$77,0),MATCH(F$36,DATOS!$E$56:$G$56,0)),\"-\")","v":"-"},{"$f":"IFERROR(INDEX(DATOS!$E$57:$G$77,MATCH($C37,DATOS!$D$57:$D$77,0),MATCH(G$36,DATOS!$E$56:$G$56,0)),\"-\")","v":"-"},{"$f":"IFERROR($D37*E37,\"-\")","v":"-"},{"$f":"IFERROR($D37*F37,\"-\")","v":"-"},{"$f":"IFERROR($D37*G37,\"-\")","v":"-"},{"$f":"IFERROR(H37+I37*(DATOS!$J$2/1000)+J37*(DATOS!$J$3/1000),\"-\")","v":"-"}]
[null,"** Indique la cantidad de gas natural consumida en kWhPCS (Poder Calorífico Superior)",null,null,{"$f":"IFERROR(INDEX(DATOS!$E$57:$G$77,MATCH($C38,DATOS!$D$57:$D$77,0),MATCH(E$36,DATOS!$E$56:$G$56,0)),\"-\")","v":"-"},{"$f":"IFERROR(INDEX(DATOS!$E$57:$G$77,MATCH($C38,DATOS!$D$57:$D$77,0),MATCH(F$36,DATOS!$E$56:$G$56,0)),\"-\")","v":"-"},{"$f":"IFERROR(INDEX(DATOS!$E$57:$G$77,MATCH($C38,DATOS!$D$57:$D$77,0),MATCH(G$36,DATOS!$E$56:$G$56,0)),\"-\")","v":"-"},{"$f":"IFERROR($D38*E38,\"-\")","v":"-"},"-","-",{"$f":"IFERROR(H38+I38*(DATOS!$J$2/1000)+J38*(DATOS!$J$3/1000),\"-\")","v":"-"}]
[null,"       ya que el factor de emisión del gas natural está expresado en kgCO2/kWhPCS.",null,null,{"$f":"IFERROR(INDEX(DATOS!$E$57:$G$77,MATCH($C39,DATOS!$D$57:$D$77,0),MATCH(E$36,DATOS!$E$56:$G$56,0)),\"-\")","v":"-"},{"$f":"IFERROR(INDEX(DATOS!$E$57:$G$77,MATCH($C39,DATOS!$D$57:$D$77,0),MATCH(F$36,DATOS!$E$56:$G$56,0)),\"-\")","v":"-"},{"$f":"IFERROR(INDEX(DATOS!$E$57:$G$77,MATCH($C39,DATOS!$D$57:$D$77,0),MATCH(G$36,DATOS!$E$56:$G$56,0)),\"-\")","v":"-"},"-","-","-",{"$f":"IFERROR(H39+I39*(DATOS!$J$2/1000)+J39*(DATOS!$J$3/1000),\"-\")","v":"-"}]
[null,"*** La utilización de la biomasa (madera, pellets, biogás, etc.) como combustible se considera",null,null,{"$f":"IFERROR(INDEX(DATOS!$E$57:$G$77,MATCH($C40,DATOS!$D$57:$D$77,0),MATCH(E$36,DATOS!$E$56:$G$56,0)),\"-\")","v":"-"},{"$f":"IFERROR(INDEX(DATOS!$E$57:$G$77,MATCH($C40,DATOS!$D$57:$D$77,0),MATCH(F$36,DATOS!$E$56:$G$56,0)),\"-\")","v":"-"},{"$f":"IFERROR(INDEX(DATOS!$E$57:$G$77,MATCH($C40,DATOS!$D$57:$D$77,0),MATCH(G$36,DATOS!$E$56:$G$56,0)),\"-\")","v":"-"},"-","-","-",{"$f":"IFERROR(H40+I40*(DATOS!$J$2/1000)+J40*(DATOS!$J$3/1000),\"-\")","v":"-"}]
[null,"       neutra en emisiones de CO2 al ser de origen biogénico, pero sí producirá emisiones de CH4 y N2O.",null,null,{"$f":"IFERROR(INDEX(DATOS!$E$57:$G$77,MATCH($C41,DATOS!$D$57:$D$77,0),MATCH(E$36,DATOS!$E$56:$G$56,0)),\"-\")","v":"-"},{"$f":"IFERROR(INDEX(DATOS!$E$57:$G$77,MATCH($C41,DATOS!$D$57:$D$77,0),MATCH(F$36,DATOS!$E$56:$G$56,0)),\"-\")","v":"-"},{"$f":"IFERROR(INDEX(DATOS!$E$57:$G$77,MATCH($C41,DATOS!$D$57:$D$77,0),MATCH(G$36,DATOS!$E$56:$G$56,0)),\"-\")","v":"-"},"-","-","-",{"$f":"IFERROR(H41+I41*(DATOS!$J$2/1000)+J41*(DATOS!$J$3/1000),\"-\")","v":"-"}]
[null,null,null,null,{"$f":"IFERROR(INDEX(DATOS!$E$57:$G$77,MATCH($C42,DATOS!$D$57:$D$77,0),MATCH(E$36,DATOS!$E$56:$G$56,0)),\"-\")","v":"-"},{"$f":"IFERROR(INDEX(DATOS!$E$57:$G$77,MATCH($C42,DATOS!$D$57:$D$77,0),MATCH(F$36,DATOS!$E$56:$G$56,0)),\"-\")","v":"-"},{"$f":"IFERROR(INDEX(DATOS!$E$57:$G$77,MATCH($C42,DATOS!$D$57:$D$77,0),MATCH(G$36,DATOS!$E$56:$G$56,0)),\"-\")","v":"-"},"-","-","-",{"$f":"IFERROR(H42+I42*(DATOS!$J$2/1000)+J42*(DATOS!$J$3/1000),\"-\")","v":"-"}]
[null,null,null,null,{"$f":"IFERROR(INDEX(DATOS!$E$57:$G$77,MATCH($C43,DATOS!$D$57:$D$77,0),MATCH(E$36,DATOS!$E$56:$G$56,0)),\"-\")","v":"-"},{"$f":"IFERROR(INDEX(DATOS!$E$57:$G$77,MATCH($C43,DATOS!$D$57:$D$77,0),MATCH(F$36,DATOS!$E$56:$G$56,0)),\"-\")","v":"-"},{"$f":"IFERROR(INDEX(DATOS!$E$57:$G$77,MATCH($C43,DATOS!$D$57:$D$77,0),MATCH(G$36,DATOS!$E$56:$G$56,0)),\"-\")","v":"-"},"-","-","-",{"$f":"IFERROR(H43+I43*(DATOS!$J$2/1000)+J43*(DATOS!$J$3/1000),\"-\")","v":"-"}]
[null,null,null,null,null,null,"SUMA EMISIONES",{"$f":"SUM(H37:H43)","v":0},{"$f":"SUM(I37:I43)","v":0},0,0]
[]
[]
[]
[]
[]
[]
[]
[null,"EMISIONES FUGITIVAS DE EQUIPOS DE CLIMATIZACIÓN/REFRIGERACIÓN* POR KG AL AÑO"]
[null,"Nombre del gas o de la mezcla","Fórmula  química","PCA","    Otras mezclas",null," Tipo de equipo","Capacidad equipo (kg)","Recarga equipo (kg)","Emisiones\nkg CO2e"]
[null,null,null,null,"Nombre","PCA"]
[null,null,{"$f":"IFERROR(VLOOKUP(B55,DATOS!$C$84:$E$127,2,0),\"-\")","v":"-"},{"$f":"IFERROR(VLOOKUP(B55,DATOS!$C$84:$E$127,3,0),\"-\")","v":"-"},null,null,null,null,null,{"$f":"IFERROR(IF(B55=DATOS!$C$127,HUELLA!F55*HUELLA!I55,HUELLA!D55*HUELLA!I55),\"-\")","v":"-"}]
[null,null,{"$f":"IFERROR(VLOOKUP(B56,DATOS!$C$84:$E$127,2,0),\"-\")","v":"-"},{"$f":"IFERROR(VLOOKUP(B56,DATOS!$C$84:$E$127,3,0),\"-\")","v":"-"},null,null,null,null,null,{"$f":"IFERROR(IF(B56=DATOS!$C$127,HUELLA!F56*HUELLA!I56,HUELLA!D56*HUELLA!I56),\"-\")","v":"-"}]
[null,null,{"$f":"IFERROR(VLOOKUP(B57,DATOS!$C$84:$E$127,2,0),\"-\")","v":"-"},{"$f":"IFERROR(VLOOKUP(B57,DATOS!$C$84:$E$127,3,0),\"-\")","v":"-"},null,null,null,null,null,{"$f":"IFERROR(IF(B57=DATOS!$C$127,HUELLA!F57*HUELLA!I57,HUELLA!D57*HUELLA!I57),\"-\")","v":"-"}]
[null,null,{"$f":"IFERROR(VLOOKUP(B58,DATOS!$C$84:$E$127,2,0),\"-\")","v":"-"},{"$f":"IFERROR(VLOOKUP(B58,DATOS!$C$84:$E$127,3,0),\"-\")","v":"-"},null,null,null,null,null,{"$f":"IFERROR(IF(B58=DATOS!$C$127,HUELLA!F58*HUELLA!I58,HUELLA!D58*HUELLA!I58),\"-\")","v":"-"}]
[null,null,{"$f":"IFERROR(VLOOKUP(B59,DATOS!$C$84:$E$127,2,0),\"-\")","v":"-"},{"$f":"IFERROR(VLOOKUP(B59,DATOS!$C$84:$E$127,3,0),\"-\")","v":"-"},null,null,null,null,null,{"$f":"IFERROR(IF(B59=DATOS!$C$127,HUELLA!F59*HUELLA!I59,HUELLA!D59*HUELLA!I59),\"-\")","v":"-"}]
[null,null,{"$f":"IFERROR(VLOOKUP(B60,DATOS!$C$84:$E$127,2,0),\"-\")","v":"-"},{"$f":"IFERROR(VLOOKUP(B60,DATOS!$C$84:$E$127,3,0),\"-\")","v":"-"},null,null,null,null,null,{"$f":"IFERROR(IF(B60=DATOS!$C$127,HUELLA!F60*HUELLA!I60,HUELLA!D60*HUELLA!I60),\"-\")","v":"-"}]
[null,null,{"$f":"IFERROR(VLOOKUP(B61,DATOS!$C$84:$E$127,2,0),\"-\")","v":"-"},{"$f":"IFERROR(VLOOKUP(B61,DATOS!$C$84:$E$127,3,0),\"-\")","v":"-"},null,null,null,null,null,{"$f":"IFERROR(IF(B61=DATOS!$C$127,HUELLA!F61*HUELLA!I61,HUELLA!D61*HUELLA!I61),\"-\")","v":"-"}]
[null,null,{"$f":"IFERROR(VLOOKUP(B62,DATOS!$C$84:$E$127,2,0),\"-\")","v":"-"},{"$f":"IFERROR(VLOOKUP(B62,DATOS!$C$84:$E$127,3,0),\"-\")","v":"-"},null,null,null,null,null,{"$f":"IFERROR(IF(B62=DATOS!$C$127,HUELLA!F62*HUELLA!I62,HUELLA!D62*HUELLA!I62),\"-\")","v":"-"}]
[null,null,{"$f":"IFERROR(VLOOKUP(B63,DATOS!$C$84:$E$127,2,0),\"-\")","v":"-"},{"$f":"IFERROR(VLOOKUP(B63,DATOS!$C$84:$E$127,3,0),\"-\")","v":"-"},null,null,null,null,null,{"$f":"IFERROR(IF(B63=DATOS!$C$127,HUELLA!F63*HUELLA!I63,HUELLA!D63*HUELLA!I63),\"-\")","v":"-"}]
[null,null,null,null,null,null,null,null,"SUMA EMISIONES",{"$f":"SUM(J55:J63)","v":0}]
[null,"*No se tienen en cuenta otras emisiones fugitivas menores procedentes de equipos eléctricos, extintores, equipos de anestesia, etc., por la poca significatividad para la herramienta."]
[]
[]
[null,"ALCANCE 2: EMISIONES INDIRECTAS","CONSUMO DE ELECTRICIDAD EN EDIFICIOS Y VEHÍCULOS ELÉCTRICOS"]
[]
[]
[null,"EMISIONES DEL CONSUMO DE ELECTRICIDAD EN EDIFICIOS POR kWh CONSUMIDO AL AÑO"]
[null,"    Nombre de la comercializadora suministradora de energía","¿Dispone GdO*?"," Dato de consumo kWh","Factor Mix eléc.(3) kg CO2/kWh","Emisiones kg CO2e"]
[]
[null,null,null,null,{"$f":"IFERROR(_xlfn.IFS(C74=DATOS!$J$141,VLOOKUP(HUELLA!B74,DATOS!$D$139:'DATOS'!$E$328,2,0),C74=DATOS!$J$140,DATOS!$K$140,C74=DATOS!$J$139,DATOS!$K$139),\"-\")","v":"-"},{"$f":"IFERROR(+D74*E74,\"-\")","v":"-"}]
[null,null,null,null,{"$f":"IFERROR(_xlfn.IFS(C75=DATOS!$J$141,VLOOKUP(HUELLA!B75,DATOS!$D$139:'DATOS'!$E$328,2,0),C75=DATOS!$J$140,DATOS!$K$140,C75=DATOS!$J$139,DATOS!$K$139),\"-\")","v":"-"},{"$f":"IFERROR(+D75*E75,\"-\")","v":"-"}]
[null,null,null,null,{"$f":"IFERROR(_xlfn.IFS(C76=DATOS!$J$141,VLOOKUP(HUELLA!B76,DATOS!$D$139:'DATOS'!$E$328,2,0),C76=DATOS!$J$140,DATOS!$K$140,C76=DATOS!$J$139,DATOS!$K$139),\"-\")","v":"-"},"-"]
[null,null,null,null,{"$f":"IFERROR(_xlfn.IFS(C77=DATOS!$J$141,VLOOKUP(HUELLA!B77,DATOS!$D$139:'DATOS'!$E$328,2,0),C77=DATOS!$J$140,DATOS!$K$140,C77=DATOS!$J$139,DATOS!$K$139),\"-\")","v":"-"},"-"]
[null,null,null,null,"SUMA EMISIONES",{"$f":"+SUM(F74:F77)","v":0}]
[null,"*Garantía de Origen"]
[]
[null,"EMISIONES DEL CONSUMO DE ELECTRICIDAD DE FLOTA DE VEHÍCULOS ELÉCTRICOS POR kWh CONSUMIDO AL AÑO"]
[null,"    Nombre de la comercializadora suministradora de energía","¿Dispone GdO*?"," Dato de consumo kWh","Factor Mix eléc. kg CO2/kWh","Emisiones kg CO2e"]
[]
[null,null,null,null,{"$f":"IFERROR(_xlfn.IFS(C84=DATOS!$J$141,VLOOKUP(HUELLA!B84,DATOS!$D$139:'DATOS'!$E$328,2,0),C84=DATOS!$J$140,DATOS!$K$140,C84=DATOS!$J$139,DATOS!$K$139),\"-\")","v":"-"},{"$f":"IFERROR(+D84*E84,\"-\")","v":"-"}]
[null,null,null,null,{"$f":"IFERROR(_xlfn.IFS(C85=DATOS!$J$141,VLOOKUP(HUELLA!B85,DATOS!$D$139:'DATOS'!$E$328,2,0),C85=DATOS!$J$140,DATOS!$K$140,C85=DATOS!$J$139,DATOS!$K$139),\"-\")","v":"-"},{"$f":"IFERROR(+D85*E85,\"-\")","v":"-"}]
[null,null,null,null,{"$f":"IFERROR(_xlfn.IFS(C86=DATOS!$J$141,VLOOKUP(HUELLA!B86,DATOS!$D$139:'DATOS'!$E$328,2,0),C86=DATOS!$J$140,DATOS!$K$140,C86=DATOS!$J$139,DATOS!$K$139),\"-\")","v":"-"},"-"]
[null,null,null,null,{"$f":"IFERROR(_xlfn.IFS(C87=DATOS!$J$141,VLOOKUP(HUELLA!B87,DATOS!$D$139:'DATOS'!$E$328,2,0),C87=DATOS!$J$140,DATOS!$K$140,C87=DATOS!$J$139,DATOS!$K$139),\"-\")","v":"-"},"-"]
[null,null,null,null,{"$f":"IFERROR(_xlfn.IFS(C88=DATOS!$J$141,VLOOKUP(HUELLA!B88,DATOS!$D$139:'DATOS'!$E$328,2,0),C88=DATOS!$J$140,DATOS!$K$140,C88=DATOS!$J$139,DATOS!$K$139),\"-\")","v":"-"},"-"]
[null,null,null,null,{"$f":"IFERROR(_xlfn.IFS(C89=DATOS!$J$141,VLOOKUP(HUELLA!B89,DATOS!$D$139:'DATOS'!$E$328,2,0),C89=DATOS!$J$140,DATOS!$K$140,C89=DATOS!$J$139,DATOS!$K$139),\"-\")","v":"-"},"-"]
[null,null,null,null,{"$f":"IFERROR(_xlfn.IFS(C90=DATOS!$J$141,VLOOKUP(HUELLA!B90,DATOS!$D$139:'DATOS'!$E$328,2,0),C90=DATOS!$J$140,DATOS!$K$140,C90=DATOS!$J$139,DATOS!$K$139),\"-\")","v":"-"},"-"]
[null,null,null,null,"SUMA EMISIONES",{"$f":"+SUM(F84:F90)","v":0}]
[null,"*Garantía de Origen"]
[]
[]
[]
[null,"RESULTADO","t CO2e"]
[null,"EMISIONES DIRECTAS",{"$f":"+(SUM(K16,K30,K44,J64)/1000)","v":0}]
[null,"EMISIONES INDIRECTAS",{"$f":"+SUM(F78,F91)/1000","v":0}]
[null,"TOTAL HUELLA DE CARBONO",{"$f":"SUM(C97:C98)","v":0}]

{"sheet":"DATOS","index":9,"n_rows":328,"n_cols":12,"rows_kept":328,"cut":false,"hidden":true,"merged":[[0,2,0,6],[1,1,1,3],[38,1,38,3],[134,2,134,7]]}
[null,"ALCANCE 1","CONSUMOS DE FLOTA DE VEHICULOS DE COMBUSTIÓN E INSTALACIONES FIJAS",null,null,null,null,null,"GWP 5th AR"]
[null,"FACTORES DE EMISIÓN VEHICULOS FLOTA (POR ud)",null,null,2022,2022,2022,null,"CH4",28]
[null,"TIPO CONBUSTIBLE","TIPO DE VEHÍCULO","CONCAT","CO2 (kg/ud)","CH4 (g/ud)","N2O (g/ud)",null,"N2O",265]
["GASOLINA","E5 (l)","Turismos (M1)",{"$f":"B4&C4","v":"E5 (l)Turismos (M1)"},2.2360000000000002,0.245,2.5999999999999999E-2]
[null,"E5 (l)","Furgonetas y furgones (N1)","E5 (l)Furgonetas y furgones (N1)",2.234,0.59799999999999998,5.5E-2,null,"LISTA TIPO COMBUSTIBLE",{"$f":"10732.8+(1176*(J2/1000))+(124.8*(J3/1000))","v":10798.8}]
[null,"E5 (l)","Camiones y autobuses (N2, N3, M2, M3)","E5 (l)Camiones y autobuses (N2, N3, M2, M3)",2.234,0.48799999999999999,2.1000000000000001E-2,null,"B10 (l)"]
[null,"E5 (l)","Ciclomotores y motocicletas (L)","E5 (l)Ciclomotores y motocicletas (L)",2.27,2.1629999999999998,4.4999999999999998E-2,null,"B100 (l)"]
[null,"E10 (l)","Turismos (M1)","E10 (l)Turismos (M1)",2.1190000000000002,0.245,2.5999999999999999E-2,null,"B20 (l)"]
[null,"E10 (l)","Furgonetas y furgones (N1)","E10 (l)Furgonetas y furgones (N1)",2.117,0.59799999999999998,5.5E-2,null,"B7 (l)"]
[null,"E10 (l)","Camiones y autobuses (N2, N3, M2, M3)","E10 (l)Camiones y autobuses (N2, N3, M2, M3)",2.117,0.48799999999999999,2.1000000000000001E-2,null,"CNG (kg)"]
[null,"E10 (l)","Ciclomotores y motocicletas (L)","E10 (l)Ciclomotores y motocicletas (L)",2.1520000000000001,2.1629999999999998,4.4999999999999998E-2,null,"E10 (l)"]
[null,"E85 (l)","Turismos (M1)","E85 (l)Turismos (M1)",0.35899999999999999,0.245,2.5999999999999999E-2,null,"E100 (l)"]
[null,"E85 (l)","Furgonetas y furgones (N1)","E85 (l)Furgonetas y furgones (N1)",0.35699999999999998,0.59799999999999998,5.5E-2,null,"E5 (l)"]
[null,"E85 (l)","Camiones y autobuses (N2, N3, M2, M3)","E85 (l)Camiones y autobuses (N2, N3, M2, M3)",0.35699999999999998,0.48799999999999999,2.1000000000000001E-2,null,"E85 (l)"]
[null,"E85 (l)","Ciclomotores y motocicletas (L)","E85 (l)Ciclomotores y motocicletas (L)",0.39200000000000002,2.1629999999999998,4.4999999999999998E-2,null,"LPG (l)"]
[null,"E100 (l)","Turismos (M1)","E100 (l)Turismos (M1)",7.0000000000000001E-3,0.245,2.5999999999999999E-2,null,"B30 (l)"]
[null,"E100 (l)","Furgonetas y furgones (N1)","E100 (l)Furgonetas y furgones (N1)",5.0000000000000001E-3,0.59799999999999998,5.5E-2]
[null,"E100 (l)","Camiones y autobuses (N2, N3, M2, M3)","E100 (l)Camiones y autobuses (N2, N3, M2, M3)",5.0000000000000001E-3,0.48799999999999999,2.1000000000000001E-2]
[null,"E100 (l)","Ciclomotores y motocicletas (L)","E100 (l)Ciclomotores y motocicletas (L)",0.04,2.1629999999999998,4.4999999999999998E-2]
["DIESEL","B7 (l)","Turismos (M1)","B7 (l)Turismos (M1)",2.488,6.0000000000000001E-3,0.11799999999999999]
[null,"B7 (l)","Furgonetas y furgones (N1)","B7 (l)Furgonetas y furgones (N1)",2.4860000000000002,8.0000000000000002E-3,7.1999999999999995E-2]
[null,"B7 (l)","Camiones y autobuses (N2, N3, M2, M3)","B7 (l)Camiones y autobuses (N2, N3, M2, M3)",2.4830000000000001,5.2999999999999999E-2,0.13]
[null,"B10 (l)","Turismos (M1)","B10 (l)Turismos (M1)",2.4119999999999999,6.0000000000000001E-3,0.11799999999999999]
[null,"B10 (l)","Furgonetas y furgones (N1)","B10 (l)Furgonetas y furgones (N1)",2.41,8.0000000000000002E-3,7.1999999999999995E-2]
[null,"B10 (l)","Camiones y autobuses (N2, N3, M2, M3)","B10 (l)Camiones y autobuses (N2, N3, M2, M3)",2.407,5.2999999999999999E-2,0.13]
[null,"B20 (l)","Turismos (M1)","B20 (l)Turismos (M1)",2.16,6.0000000000000001E-3,0.11799999999999999]
[null,"B20 (l)","Furgonetas y furgones (N1)","B20 (l)Furgonetas y furgones (N1)",2.1579999999999999,8.0000000000000002E-3,7.1999999999999995E-2]
[null,"B20 (l)","Camiones y autobuses (N2, N3, M2, M3)","B20 (l)Camiones y autobuses (N2, N3, M2, M3)",2.1549999999999998,5.2999999999999999E-2,0.13]
[null,"B30 (l)","Turismos (M1)","B30 (l)Turismos (M1)",1.9079999999999999,6.0000000000000001E-3,0.11799999999999999]
[null,"B30 (l)","Furgonetas y furgones (N1)","B30 (l)Furgonetas y furgones (N1)",1.9059999999999999,8.0000000000000002E-3,7.1999999999999995E-2]
[null,"B30 (l)","Camiones y autobuses (N2, N3, M2, M3)","B30 (l)Camiones y autobuses (N2, N3, M2, M3)",1.903,5.2999999999999999E-2,0.13]
[null,"B100 (l)","Turismos (M1)","B100 (l)Turismos (M1)",0.14399999999999999,6.0000000000000001E-3,0.11799999999999999]
[null,"B100 (l)","Furgonetas y furgones (N1)","B100 (l)Furgonetas y furgones (N1)",0.14199999999999999,8.0000000000000002E-3,7.1999999999999995E-2]
[null,"B100 (l)","Camiones y autobuses (N2, N3, M2, M3)","B100 (l)Camiones y autobuses (N2, N3, M2, M3)",0.13900000000000001,5.2999999999999999E-2,0.13]
[null,"LPG (l)","Turismos (M1)","LPG (l)Turismos (M1)",1.6519999999999999,0.20499999999999999,1.6E-2]
[null,"CNG (kg)","Turismos (M1)","CNG (kg)Turismos (M1)",2.7160000000000002,1.079,3.3000000000000002E-2]
[null,"CNG (kg)","Camiones y autobuses (N2, N3, M2, M3)","CNG (kg)Camiones y autobuses (N2, N3, M2, M3)",2.7160000000000002,2.395,0]
[]
[null,"FACTORES DE EMISIÓN VEHICULOS FLOTA (POR KM)",null,null,2022,2022,2022]
[null,"TIPO CONBUSTIBLE","TIPO DE VEHÍCULO","CONCAT","CO2 (kg/ud)","CH4 (g/ud)","N2O (g/ud)",null,"LISTA TIPO COMBUSTIBLE","LISTA TIPO DE VEHÍCULO"]
[null,"Gasóleo (km)","Turismos (M1)","Gasóleo (km)Turismos (M1)",0.16300000000000001,0,7.0000000000000001E-3,null,"Gasóleo (km)","Turismos (M1)"]
[null,"Gasolina (km)","Turismos (M1)","Gasolina (km)Turismos (M1)",0.19500000000000001,0.02,2E-3,null,"Gasolina (km)","Furgonetas y furgones (N1)"]
[null,"LPG (km)","Turismos (M1)","LPG (km)Turismos (M1)",0.185,2.3E-2,2E-3,null,"LPG (km)","Camiones y autobuses (N2, N3, M2, M3)"]
[null,"CNG (km)","Turismos (M1)","CNG (km)Turismos (M1)",0.19600000000000001,7.8E-2,2E-3,null,"CNG (km)","Ciclomotores y motocicletas (L)"]
[null,"Gasóleo (km)","Furgonetas y furgones (N1)","Gasóleo (km)Furgonetas y furgones (N1)",0.25600000000000001,1E-3,7.0000000000000001E-3]
[null,"Gasolina (km)","Furgonetas y furgones (N1)","Gasolina (km)Furgonetas y furgones (N1)",0.25900000000000001,6.6000000000000003E-2,6.0000000000000001E-3]
[null,"Gasóleo (km)","Camiones y autobuses (N2, N3, M2, M3)","Gasóleo (km)Camiones y autobuses (N2, N3, M2, M3)",0.58599999999999997,1.2E-2,2.9000000000000001E-2]
[null,"Gasolina (km)","Camiones y autobuses (N2, N3, M2, M3)","Gasolina (km)Camiones y autobuses (N2, N3, M2, M3)",0.67300000000000004,0.14000000000000001,6.0000000000000001E-3]
[null,"CNG (km)","Camiones y autobuses (N2, N3, M2, M3)","CNG (km)Camiones y autobuses (N2, N3, M2, M3)",1.117,0.98699999999999999,0]
[null,"Gasolina (km)","Ciclomotores y motocicletas (L)","Gasolina (km)Ciclomotores y motocicletas (L)",0.1,9.1999999999999998E-2,2E-3]
[]
[]
[]
[null,null,"FACTORES DE EMISIÓN INSTALACIONES FIJAS (CALDERAS, MOTORES ESTACIONARIOS, ETC.) NO SUJETAS A LAS OBLIGACIONES ESTABLECIDAS EN LA LEY 1/2005, DE 9 DE MARZO (POR ud)"]
[null,null,null,null,2022,2022,2022,null,null,61640,4880,80]
[null,null,null,"TIPO CONBUSTIBLE","CO2 (kg/ud)","CH4 (g/ud)","N2O (g/ud)",null,null,{"$f":"J55+(K55*(J2/1000))+L55*(J3/1000)","v":61797.84}]
[null,null,null,"Gasóleo C (l)",2.7050000000000001,0.36499999999999999,2.1999999999999999E-2]
[null,null,null,"Gasóleo B (l)",2.7050000000000001,0.36499999999999999,2.1999999999999999E-2]
[null,null,null,"Gas natural (kWhPCS)**",0.182,1.6E-2,0]
[null,null,null,"Fuelóleo (l)",3.11,0.40200000000000002,1.2E-2]
[null,null,null,"LPG (l)",1.5409999999999999,0.122,2E-3]
[null,null,null,"Queroseno (l)",2.4849999999999999,0.34599999999999997,2.1000000000000001E-2]
[null,null,null,"Gas propano (kg)",2.9660000000000002,0,0]
[null,null,null,"Gas butano (kg)",2.996,0,0]
[null,null,null,"Gas manufacturado (kg)",0.878,9.9000000000000005E-2,2E-3]
[null,null,null,"Biogás (kg)***",0,2.5000000000000001E-2,3.0000000000000001E-3]
[null,null,null,"Biomasa madera (kg)***",0,4.3319999999999999,5.8000000000000003E-2]
[null,null,null,"Biomasa pellets (kg)***",0,5.4240000000000004,7.1999999999999995E-2]
[null,null,null,"Biomasa astillas (kg)***",0,4.5330000000000004,0.06]
[null,null,null,"Biomasa serrines virutas (kg)***",0,4.7489999999999997,6.3E-2]
[null,null,null,"Biomasa cáscara f. secos (kg)***",0,4.665,6.2E-2]
[null,null,null,"Biomasa hueso aceituna (kg)***",0,4.8479999999999999,6.5000000000000002E-2]
[null,null,null,"Carbón vegetal (kg)***",0,6.2779999999999996,3.1E-2]
[null,null,null,"Coque de petróleo (kg)",3.169,0.32500000000000001,0.02]
[null,null,null,"Coque de carbón (kg)",3.0169999999999999,0.28199999999999997,4.2000000000000003E-2]
[null,null,null,"Hulla y antracita (kg)",3.117,0.30299999999999999,4.5999999999999999E-2]
[null,null,null,"Hullas subituminosas (kg)",1.331,0.13400000000000001,0.02]
[null,"** Indique la cantidad de gas natural consumida en kWhPCS (Poder Calorífico Superior) ya que el factor de emisión del gas natural está expresado en kgCO2/kWhPCS."]
[null,"*** La utilización de la biomasa (madera, pellets, biogás, etc.) como combustible se considera neutra en emisiones de CO2 al ser de origen biogénico, pero sí producirá emisiones de CH4 y N2O."]
[]
[]
[null,null,"FACTORES DE EMISIONES FUGITIVAS EN EQUIPOS DE CLIMATIZACIÓN/REFRIGERACIÓN (POR KG)"]
[null,null,"Nombre","Fórmula química","PCA 5th",null,"GWP 5th AR"]
[null,null,"HFC-23","CH2F3",12400,null,"CH4",28]
[null,null,"HFC-32","CH2F2",677,null,"N2O",265]
[null,null,"HFC-41","CH3F",116]
[null,null,"HFC-125","C2HF5",3170,null,"Gas","PCA AR4","PCAs AR5","PCAs AR5"]
[null,null,"HFC-134","C2H2F4",1120,null,"R-600 (butano)",4]
[null,null,"HFC-134a","CH2FCF3",1300]
[null,null,"HFC-143","C2H3F3.",328,null,"Tipo de equipo"]
[null,null,"HFC-143a","C2H3F3",4800,null,"Equipo autónomo de refrigeración"]
[null,null,"HFC-152","CH2FCH2F",16,null,"Aire acondicionado"]
[null,null,"HFC-152a","C2H4F2",138,null,"Congelador"]
[null,null,"HFC-161","C2H2F",4,null,"Nevera"]
[null,null,"HFC-227ea","C3HF7",3350,null,"Otro"]
[null,null,"HFC-236cb","CH2FCF2CF3",1210]
[null,null,"HFC-236ea","CHF2CHFCF3",1330]
[null,null,"HFC-236fa","C3H2F6",8060]
[null,null,"HFC-245ca","C3H3F5",716]
[null,null,"HFC-245fa","C3H3F5",858]
[null,null,"HFC-365mfc","C4H5F5",804]
[null,null,"HFC-43-10mee","C5H2F10",1650]
[null,null,"R-404A","R-125/143a/134a (44/52/4)",3942.8]
[null,null,"R-407A","R-32/125/134a (20/40/40)",1923.4]
[null,null,"R-407B","R-32/125/134a (10/70/20)  ",2546.6999999999998]
[null,null,"R-407C","R-32/125/134a (23/25/52)",1624.21]
[null,null,"R-407F","R-32/125/134a (30/30/40)",1674.1]
[null,null,"R-410A","R-32/125 (50/50) ",1923.5]
[null,null,"R-410B","R-32/125 (45/55) ",2048.15]
[null,null,"R-413A","R-218/134a/600a (9/88/3)",1945]
[null,null,"R-417A","R-125/134a/600 (46,6/50/3,4)",2127.2200000000003]
[null,null,"R-417B","R-125/134a/600 (79/18,25/2,75)",2741.55]
[null,null,"R-422A","R-125/134a/600a (85,1/11,5/3,4)",2847.17]
[null,null,"R-422D","R-125/134a/600a (65,1/31,5/3,4)",2473.1699999999996]
[null,null,"R-424A","R-125/134a/600a/600/601a (50,5/47/0,9/1/0)",2211.85]
[null,null,"R-426A","R-134a/125/600/601a (93/5,1/1,3/0,6)",1370.67]
[null,null,"R-427A","R-32/125/143a/134a (15/25/10/50)",2024.05]
[null,null,"R-428A","R-125/143a/600a/290 (77,5/20/1,9/06)              ",3416.75]
[null,null,"R-434A","R-125/143a/134a/600a (63,2/18/16/2,8)",3075.44]
[null,null,"R-437A","R-125/134a/600/601 (19,5/78,5/1,4/06)",1638.65]
[null,null,"R-438A","R-32/125/134a/600/601a (8,5/45/44,2/1,7/0,6)",2058.645]
[null,null,"R-442A","R-32/125/134a/152a/227ea (31/31/30/3/5)",1754.2100000000003]
[null,null,"R-449A","R-32/R-125/HFO-1234yf/R-134a (24,3/24,7/25,3/25,7)",1281.6010000000001]
[null,null,"R-452A","R-125/R-32/HFO-1234yf (59/11/30)",1945]
[null,null,"R-453A","R-134a/125/32/227ea/600/601a (53,8/20/20/5/0,6/0,6)",1636]
[null,null,"R-507A","R-125/143a (50/50)",3985]
[null,null,"Otro","-","-"]
[]
[]
[]
[]
[]
[]
[]
[null,"ALCANCE 2","ELECTRICIDAD Y OTRAS ENERGÍAS"]
[null,null,null,"PARA EDIFICIOS Y VEHÍCULOS ELECTRICOS",null,null,null,null,null,"FE Mix GdO para todos los años","*GDO: GARANTÍA DE ORÍGEN"]
[]
[null,null,null,"Comercializadoras2022","FACTOR EMISION 2022",null,null,null,null,null,"FACTOR EMISION 2022"]
[null,null,null,"AB ENERGÍA 1903, S.L.",0.27300000000000002,null,null,null,null,"GdO energía renovable",0]
[null,null,null,"ACCIONA GREEN ENERGY DEVELOPMENTS SL",0,null,null,null,null,"GdO cogeneración de alta eficiencia",0.30199999999999999,"SE APLICA ESTE DIRECTAMENTE INDEPENDIENTEMENTE DE LA COMERCIALIZADORA"]
[null,null,null,"ACSOL ENERGÍA GLOBAL, S.A.",0.27200000000000002,null,null,null,null,"No","-","DEPENDE DE LA COMERCIALIZADORA"]
[null,null,null,"ADEINNOVA ENERGIA S.L",0.27300000000000002]
[null,null,null,"ADELFAS ENERGIA SL",0]
[null,null,null,"ADS ENERGY 8.0 SL",1E-3]
[null,null,null,"AED ENERGIA ELECTRICA, S.L.",0]
[null,null,null,"AGRI-ENERGIA, S.A.",0.215]
[null,null,null,"AHORRELUZ SERVICIOS ONLINE S.L",0.252]
[null,null,null,"ALCANZIA ENERGIA, S.L.",0.27200000000000002]
[null,null,null,"ALPIQ ENERGIA ESPAÑA SAU",0.27200000000000002]
[null,null,null,"ALUMBRA CORPORACIÓN, S.L.",0]
[null,null,null,"AMPERIOS ENERGY TRADE, S.L.",0]
[null,null,null,"ARACAN ENERGIA S.L.",0.26900000000000002]
[null,null,null,"ARSUS ENERGIA, S.L",0.27300000000000002]
[null,null,null,"ASTRALCAD ENERGIA, S.L.",0]
[null,null,null,"ATLAS ENERGIA COMERCIAL, S.L.",0.27200000000000002]
[null,null,null,"AUDAX RENOVABLES, S.A",0]
[null,null,null,"AVANZALIA ENERGIA COMERCIALIZADORA SA",0.20399999999999999]
[null,null,null,"AXPO IBERIA S.L.",0.26400000000000001]
[null,null,null,"BARTER SHARING, S.L.",3.5999999999999997E-2]
[null,null,null,"BASSOLS ENERGIA COMERCIAL, S.L",0]
[null,null,null,"BIROU GAS S.L.",0.27]
[null,null,null,"BLUBAT PULSAR, S.L.",0.193]
[null,null,null,"BON PREU, SAU",0]
[null,null,null,"BP GAS & POWER IBERIA, S.A.U.",0]
[null,null,null,"CAPITAL ENERGY COMERCIALIZADORA, S.L.U",0]
[null,null,null,"CEPSA GAS Y ELECTRICIDAD, S.A.U.",0.19500000000000001]
[null,null,null,"CIDE HCENERGÍA S.A.U",0.26500000000000001]
[null,null,null,"CIMA ENERGIA COMERCIALIZADORA SL",0.27200000000000002]
[null,null,null,"CLEARVIEW ENERGY S.L.",0]
[null,null,null,"COMERCIALIZADORA ADI ESPAÑA, S.L.",0.26800000000000002]
[null,null,null,"COMERCIALIZADORA DE ELECTRICIDAD Y GAS DEL MEDITERRÁNEO S.L",0]
[null,null,null,"COMERCIALIZADORA ELECTRICA DE CADIZ, S.A.U",0]
[null,null,null,"COMERCIALIZADORA ELECTRICA PENINSULAR S.L.",0.27300000000000002]
[null,null,null,"COMERCIALIZADORA ENERGÉTICA SOSTENIBLE, S.A.U.",0]
[null,null,null,"CONECTA2 ENERGIA, S.L.",0.215]
[null,null,null,"COOPERATIVA ELECTRICA DE CASTELLAR, S.C.V (COMERC)",0]
[null,null,null,"COOPERATIVA ELÉCTRICA BENÉFICA SAN FRANCISCO DE ASÍS, COOP. V.",0.23799999999999999]
[null,null,null,"COX ENERGÍA COMERCIALIZADORA ESPAÑA S.L.U.",0]
[null,null,null,"CYE ENERGIA SL",0.27200000000000002]
[null,null,null,"DAIMUZ ENERGÍA S.L.",0.214]
[null,null,null,"DISA ENERGIA ELECTRICA S.L.",0]
[null,null,null,"DOMESTICA GAS Y ELECTRICIDAD SLU",0]
[null,null,null,"E-LUZ ENERGY SOLUTIONS, S.L.",0.128]
[null,null,null,"ECOFUTURA LUZ ENERGÍA, S.L.",0.254]
[null,null,null,"EDP CLIENTES SAU",0.27200000000000002]
[null,null,null,"EDP ESPAÑA, S.A",0.27300000000000002]
[null,null,null,"EKILUZ ENERGÍA COMERCIALIZADORA, S.L.",0]
[null,null,null,"ELECNOVA SIGLO XXI SL",0.26900000000000002]
[null,null,null,"ELECTRA AVELLANA COMERCIAL, S.L",0]
[null,null,null,"ELECTRA CALDENSE ENERGIA, S.A.",0]
[null,null,null,"ELECTRA DEL CARDENER ENERGIA, S.A.",0.249]
[null,null,null,"ELECTRA ENERGIA, S.A.",0.27]
[null,null,null,"ELECTRA NORTE ENERGÍA, S.A.",0.25600000000000001]
[null,null,null,"ELECTRACOMERCIAL CENTELLES, S.L.UNIPERSONAL",0]
[null,null,null,"ELECTRICA DE GUIXES ENERGIA, SL",0.27300000000000002]
[null,null,null,"ELECTRICA DE VINALESA SOCIEDAD COOPERATIVA VALENCIANA",0]
[null,null,null,"ELECTRICA SEROSENSE, S.L.",0.27200000000000002]
[null,null,null,"ELECTRICA SOLLERENSE, S.A.",0]
[null,null,null,"ELECTRICIDAD ELEIA S.L.",0.27300000000000002]
[null,null,null,"ELEVA 2 COMERCIALIZADORA, S.L",0]
[null,null,null,"ELÉCTRICA VAQUER ENERGIA, S.A",0.25]
[null,null,null,"EMPRESA DE ALUMBRADO ELECTRICO DE CEUTA, S.A.",0.27300000000000002]
[null,null,null,"ENARA GESTIÓN Y MEDIACIÓN, S.L.",0]
[null,null,null,"ENDESA ENERGÍA RENOVABLE, S.L.",0]
[null,null,null,"ENDESA ENERGÍA S.A.U.",0.27200000000000002]
[null,null,null,"ENDI ENERGY TRADING SL",0.26700000000000002]
[null,null,null,"ENERCOLUZ ENERGIA SL",0.27300000000000002]
[null,null,null,"ENERGIA DLR COMERCIALIZADORA, SL",0.27300000000000002]
[null,null,null,"ENERGIA NUFRI SL",0.27100000000000002]
[null,null,null,"ENERGIA VIVA SPAIN, S.L.",0.27200000000000002]
[null,null,null,"ENERGY BY COGEN S.L.U.",0.27300000000000002]
[null,null,null,"ENERGY STROM XXI SL",0.24]
[null,null,null,"ENERGY TRADER SOLUTIONS, S.L.",0.27100000000000002]
[null,null,null,"ENERGYA VM GESTION DE ENERGÍA, S.L",0.27300000000000002]
[null,null,null,"ENERGÉTICA DEL ESTE SL",0.27300000000000002]
[null,null,null,"ENERGÍA COLECTIVA, S.L.",0]
[null,null,null,"ENERGÍA ECOLÓGICA ECONÓMICA, S.L.",0.27]
[null,null,null,"ENERPLUS ENERGIA, S.A.",0.27300000000000002]
[null,null,null,"ENERXIA GALEGA MAIS SLU",0.27300000000000002]
[null,null,null,"ENGIE ESPAÑA, S.L",0.27200000000000002]
[null,null,null,"ENI PLENITUDE IBERIA, S.L.",0]
[null,null,null,"ENSTROGA, S.L.",0.22800000000000001]
[null,null,null,"EPRESA ENERGÍA S.A.",0]
[null,null,null,"ESCANDINAVA DE ELECTRICIDAD, S.L.U",0.27100000000000002]
[null,null,null,"ESTABANELL IMPULSA, S.A.U.",0]
[null,null,null,"ESTRATEGIAS ELÉCTRICAS INTEGRALES, S.A.",0.27200000000000002]
[null,null,null,"FACTOR ENERGÍA ESPAÑA, S.A.",0.27200000000000002]
[null,null,null,"FACTOR ENERGÍA, S.A.",0.255]
[null,null,null,"FENIE ENERGIA SA",0.26700000000000002]
[null,null,null,"FOENER ENERGÍA, S.L",0.27200000000000002]
[null,null,null,"FORTIA ENERGIA S.L.",0.27200000000000002]
[null,null,null,"FORZA  VILALTA GREEN ENERGY, S.L.",0]
[null,null,null,"FOX ENERGÍA S.A",0.27]
[null,null,null,"GABA COMERCIALIZADORA DE ELECTRICIDAD, S.L.U.",0]
[null,null,null,"GALP ENERGÍA ESPAÑA, S.A.U.",0.27300000000000002]
[null,null,null,"GAS NATURAL COMERCIALIZADORA SA",0.26200000000000001]
[null,null,null,"GASELEC DIVERSIFICACIÓN S.L.",0.27300000000000002]
[null,null,null,"GASILUZ ECO ENERCIA S.L.",0]
[null,null,null,"GEO ALTERNATIVA S.L.",0.27300000000000002]
[null,null,null,"GEOATLANTER SA",0]
[null,null,null,"GERENTA ENERGÍA, S.L.U.",0.191]
[null,null,null,"GESTERNOVA, S.A",0]
[null,null,null,"GLOBAL BIOSFERA PROTEC S.L",2.3E-2]
[null,null,null,"GLOBELIGHT ENERGY S.L",0.24099999999999999]
[null,null,null,"GNERA ENERGIA Y TECNOLOGIA, S.L.",0.05]
[null,null,null,"GOIENER S.COOP",0]
[null,null,null,"GREEN POWER SUPPLY, S.L.U.",0]
[null,null,null,"GURBTEC ENERGIA, S.L.",0]
[null,null,null,"HANWHA ENERGY RETAIL SPAIN SL",0]
[null,null,null,"HELIOELEC ENERGIA ELECTRICA, S.L.",0.27300000000000002]
[null,null,null,"HIDROELÉCTRICA DEL VALIRA, S.L.",0.27300000000000002]
[null,null,null,"HIDROELÉCTRICA EL CARMEN ENERGÍA, S.L",0]
[null,null,null,"HOLALUZ-CLIDOM, S.A",0]
[null,null,null,"IBERDROLA CLIENTES, S.A.U.",0.27]
[null,null,null,"IBERDROLA ENERGÍA ESPAÑA, S.A.U",0.27300000000000002]
[null,null,null,"IBERDROLA SERVICIOS ENERGETICOS, S.A.U.",0]
[null,null,null,"INDEXO ENERGIA SL",0.246]
[null,null,null,"INER ENERGIA CASTILLA LA MANCHA SL",0.27]
[null,null,null,"INER EUSKADI, S.L.",0.26600000000000001]
[null,null,null,"INTEGRACIÓN EUROPEA DE ENERGIA, S.A.U.",0.27300000000000002]
[null,null,null,"INTELIGENCIA PARA EL AHORRO ENERGÉTICO, S.L.",0.251]
[null,null,null,"IRIS ENERGÍA EFICIENTE S.A.",0.26900000000000002]
[null,null,null,"JUAN ENERGY, S.L.",0.26700000000000002]
[null,null,null,"KISHOA, S.L.",0]
[null,null,null,"LA CORRIENTE SOCIEDAD COOPERATIVA",0]
[null,null,null,"LA UNIÓN ELECTRO INDUSTRIAL, S.L.U",0]
[null,null,null,"LONJAS TECNOLOGÍA, S.A.",0.223]
[null,null,null,"LOVE ENERGY, S.L.",0]
[null,null,null,"LUZ SOLIDARIA S.L.",0]
[null,null,null,"MASQLUZ 2020, S.L.",0]
[null,null,null,"MEGARA ENERGIA SOC. COOP",0]
[null,null,null,"MET ENERGIA ESPAÑA, S.A",0.27300000000000002]
[null,null,null,"MY ENERGIA ONER S.L",0.26]
[null,null,null,"NABALIA ENERGIA 2000 S.A",0.26600000000000001]
[null,null,null,"NATURGY CLIENTES, S.A.U.",0]
[null,null,null,"NATURGY IBERIA, S.A.",0.27100000000000002]
[null,null,null,"NATURGY RENOVABLES, S.LU.",0]
[null,null,null,"NEOELECTRA  ENERGIA",0.27300000000000002]
[null,null,null,"NEXUS ENERGIA SA",0]
[null,null,null,"NINOBE SERVICIOS ENERGÉTICOS, SL",0.27100000000000002]
[null,null,null,"NOSA ENERXIA SCG",0]
[null,null,null,"NUEVA COMERCIALIZADORA ESPAÑOLA SL",0]
[null,null,null,"OCTOPUS ENERGY ESPAÑA, S.L.U.",0.26800000000000002]
[null,null,null,"ON DEMAND FACILITIES, SLU",0.27200000000000002]
[null,null,null,"PASIÓN ENERGÍA, S.L.",0]
[null,null,null,"PEPEENERGY, S.L.",0]
[null,null,null,"PETRONIEVES ENERGIA 1, S.L.",0.25]
[null,null,null,"PLANETGY SL",0]
[null,null,null,"PLENA ENERGIA RENOVABLE, S.L.",0.26900000000000002]
[null,null,null,"POTENZIA COMERCIALIZADORA SL",0.27300000000000002]
[null,null,null,"PROT ENERGIA COMERCIALIZACION, S.L",0]
[null,null,null,"RECICLAJES ECOLOGICOS NAGINI, S.L.",0.27300000000000002]
[null,null,null,"RENEWABLE VENTURES SLU",0.26900000000000002]
[null,null,null,"REPSOL COMERCIALIZADORA DE ELECTRICIDAD Y GAS, S.L.U",0]
[null,null,null,"RESPIRA ENERGÍA ESPAÑA, S.L.",0.27200000000000002]
[null,null,null,"RESPIRA ENERGÍA S.A",0.112]
[null,null,null,"ROFEICA ENERGIA, S.A",0.27300000000000002]
[null,null,null,"RONDA OESTE ENERGÍA, S.L",0.27100000000000002]
[null,null,null,"SAMPOL INGENIERIA Y OBRAS SA",0.26900000000000002]
[null,null,null,"SERVIGAS S XXI SA",0.26700000000000002]
[null,null,null,"SHELL ESPAÑA, S.A",0.27300000000000002]
[null,null,null,"SISTEMAS URBANOS DE ENERGÍAS RENOVABLES S.L.",0.27300000000000002]
[null,null,null,"SMART ELECTRIC ENGINEERING P2P SL",0]
[null,null,null,"SOCIEDAD ARAGONESA DE COMERCIALIZACION DE ENERGIA S.L.",0.25]
[null,null,null,"SOLABRIA S.COOP. - ENERPLUS S.C.",4.0000000000000001E-3]
[null,null,null,"SOLAR EAAS, S.L.",0]
[null,null,null,"SOLARPACK ENERGY, S.L.",0]
[null,null,null,"SOM ENERGIA SCCL",0]
[null,null,null,"STIN S.A",0.27300000000000002]
[null,null,null,"SUNAIR ONE ENERGY S.L",0.27300000000000002]
[null,null,null,"SYDER COMERCIALIZADORA VERDE SL",0.25800000000000001]
[null,null,null,"TELECOR S.A. UNIPERSONAL",0]
[null,null,null,"THE YELLOW ENERGY, S.L",0.27300000000000002]
[null,null,null,"TOTALENERGIES CLIENTES S.A.U.",5.0999999999999997E-2]
[null,null,null,"TOTALENERGIES ELECTRICIDAD Y GAS ESPAÑA, S.A.U.",0.27]
[null,null,null,"TOTALENERGIES MERCADO ESPAÑA, S.A.U",0.23]
[null,null,null,"TRACTAMENT I SELECCIÓ DE RESIDUS, S.A.",0]
[null,null,null,"TU COMERCIALIZADORA DE ENERGÍA LUZ, DOS, TRES, S.L.",0]
[null,null,null,"UNIELECTRICA ENERGIA, S.A",0]
[null,null,null,"V3J INGENIERIA Y SERVICIOS, S.L",0]
[null,null,null,"VISALIA ENERGIA S.L.",0.27300000000000002]
[null,null,null,"VIVO ENERGIA FUTURA S.A",0.27200000000000002]
[null,null,null,"VODAFONE ENERGÍA, S.L.",0]
[null,null,null,"WATIO WHOLESALE, S.L",0.27300000000000002]
[null,null,null,"WATIUM, S.L.",0.27300000000000002]
[null,null,null,"WIND TO MARKET S.A",0.26100000000000001]
[null,null,null,"Varias comercializadoras",0.27300000000000002]
[null,null,null,"Otras",0.27300000000000002]

{"sheet":"Datos y cálculos","index":10,"n_rows":4,"n_cols":165,"rows_kept":4,"cut":false,"hidden":true,"merged":[]}
["ID","YEAR","SEM","D1","D2","D3","D4","D5","D6","D7","D8","D9","D10","D11","D12","D13","P1B","P2B","P3B","PBP1","PBP2","PBP3","PBP4","PBP5","PBP6","PBP7","PBP8","PBP9","PBP10","PBP11","PBP12","PBP13","PBP14","PBP15","PBP16","PBP17","PBP18","PBP19","E1B","E2B","E3B","E4B","E5B","E6","E7","E8","E9","E10","E11","E12","EBP1","E13","EBP21","EBP22","EBP3","EBP4","EBP5","EBP61","EBP62","EBP7","A1B","A2B","ABP1","ABP2","ABP3","ABP41","ABP42","ABP5","R1B","R2B","R1","R2","R3","R4","R5","R6","RBP1","RBP2","RBP3","RBP41","RBP42","RBP43","RBP44","RBP45","RBP5","RBP6","RBP7","RBP8","RBP9","RA1B","RA2B","RABP1","RABP11","RABP2","RABP3","RABP4","RABP5","RABP6","PBP","E2B_val","EI","EBP","E1B1","E1B2","E1B3","E3B1","E3B2","E3B3","E61","E71","E81","E62","E72","E82","E63","E73","E83","A1B1","A1B2","A1B3","A2B1","A2B2","A2B3","ABP","R1P","R2P","R3P","R4P","R5P","R6P","R1F","R2F","R3F","R4F","R5F","R6F","R1FP","R2FP","R3FP","R4FP","R5FP","R6FP","RVal","R11","R21","R31","R41","R51","R61","R12","R22","R32","R42","R52","R62","R13","R23","R33","R43","R53","R63","RTot","RTotP","RBP","RABP"]
[{"$f":"VLOOKUP(A1,Información!$A$3:$C$19,3,FALSE)","v":0},{"$f":"VLOOKUP(B1,Información!$A$3:$C$19,3,FALSE)","v":0},{"$f":"VLOOKUP(C1,Información!$A$3:$C$19,3,FALSE)","v":0},{"$f":"VLOOKUP(D1,Información!$A$3:$C$19,3,FALSE)","v":0},{"$f":"VLOOKUP(E1,Información!$A$3:$C$19,3,FALSE)","v":0},{"$f":"VLOOKUP(F1,Información!$A$3:$C$19,3,FALSE)","v":0},{"$f":"VLOOKUP(G1,Información!$A$3:$C$19,3,FALSE)","v":0},{"$f":"VLOOKUP(H1,Información!$A$3:$C$19,3,FALSE)","v":0},{"$f":"VLOOKUP(I1,Información!$A$3:$C$19,3,FALSE)","v":0},{"$f":"VLOOKUP(J1,Información!$A$3:$C$19,3,FALSE)","v":0},{"$f":"VLOOKUP(K1,Información!$A$3:$C$19,3,FALSE)","v":0},{"$f":"VLOOKUP(L1,Información!$A$3:$C$19,3,FALSE)","v":0},{"$f":"VLOOKUP(M1,Información!$A$3:$C$19,3,FALSE)","v":0},{"$f":"VLOOKUP(N1,Información!$A$3:$C$19,3,FALSE)","v":0},{"$f":"VLOOKUP(O1,Información!$A$3:$C$19,3,FALSE)","v":0},{"$f":"VLOOKUP(P1,Información!$A$3:$C$19,3,FALSE)","v":0},{"$f":"VLOOKUP(Q1,Plan!$A$4:$C$56,3,FALSE)","v":0},{"$f":"VLOOKUP(R1,Plan!$A$4:$C$56,3,FALSE)","v":0},{"$f":"VLOOKUP(S1,Plan!$A$4:$C$56,3,FALSE)","v":0},{"$f":"IF(VLOOKUP(T1,Plan!$A$4:$C$56,3,FALSE)=\"Sí\",1,0)","v":0},{"$f":"IF(VLOOKUP(U1,Plan!$A$4:$C$56,3,FALSE)=\"Sí\",1,0)","v":0},{"$f":"IF(VLOOKUP(V1,Plan!$A$4:$C$56,3,FALSE)=\"Sí\",1,0)","v":0},{"$f":"IF(VLOOKUP(W1,Plan!$A$4:$C$56,3,FALSE)=\"Sí\",1,0)","v":0},{"$f":"IF(VLOOKUP(X1,Plan!$A$4:$C$56,3,FALSE)=\"Sí\",1,0)","v":0},{"$f":"IF(VLOOKUP(Y1,Plan!$A$4:$C$56,3,FALSE)=\"Sí\",1,0)","v":0},{"$f":"IF(VLOOKUP(Z1,Plan!$A$4:$C$56,3,FALSE)=\"Sí\",1,0)","v":0},{"$f":"IF(VLOOKUP(AA1,Plan!$A$4:$C$56,3,FALSE)=\"Sí\",1,0)","v":0},{"$f":"IF(VLOOKUP(AB1,Plan!$A$4:$C$56,3,FALSE)=\"Sí\",1,0)","v":0},{"$f":"IF(VLOOKUP(AC1,Plan!$A$4:$C$56,3,FALSE)=\"Sí\",1,0)","v":0},{"$f":"IF(VLOOKUP(AD1,Plan!$A$4:$C$56,3,FALSE)=\"Sí\",1,0)","v":0},{"$f":"IF(VLOOKUP(AE1,Plan!$A$4:$C$56,3,FALSE)=\"Sí\",1,0)","v":0},{"$f":"IF(VLOOKUP(AF1,Plan!$A$4:$C$56,3,FALSE)=\"Sí\",1,0)","v":0},{"$f":"IF(VLOOKUP(AG1,Plan!$A$4:$C$56,3,FALSE)=\"Sí\",1,0)","v":0},{"$f":"IF(VLOOKUP(AH1,Plan!$A$4:$C$56,3,FALSE)=\"Sí\",1,0)","v":0},{"$f":"IF(VLOOKUP(AI1,Plan!$A$4:$C$56,3,FALSE)=\"Sí\",1,0)","v":0},{"$f":"IF(VLOOKUP(AJ1,Plan!$A$4:$C$56,3,FALSE)=\"Sí\",1,0)","v":0},{"$f":"IF(VLOOKUP(AK1,Plan!$A$4:$C$56,3,FALSE)=\"Sí\",1,0)","v":0},{"$f":"IF(VLOOKUP(AL1,Plan!$A$4:$C$56,3,FALSE)=\"Sí\",1,0)","v":0},{"$f":"VLOOKUP(AM1,Energía!$A$4:$C$37,3,FALSE)","v":0},{"$f":"VLOOKUP(AN1,Energía!$A$4:$C$37,3,FALSE)","v":0},{"$f":"VLOOKUP(AO1,Energía!$A$4:$C$37,3,FALSE)","v":0},{"$f":"VLOOKUP(AP1,Energía!$A$4:$C$37,3,FALSE)","v":0},{"$f":"VLOOKUP(AQ1,Energía!$A$4:$C$37,3,FALSE)","v":0},{"$f":"VLOOKUP(AR1,Energía!$A$4:$C$37,3,FALSE)","v":0},{"$f":"VLOOKUP(AS1,Energía!$A$4:$C$37,3,FALSE)","v":0},{"$f":"VLOOKUP(AT1,Energía!$A$4:$C$37,3,FALSE)","v":0},{"$f":"VLOOKUP(AU1,Energía!$A$4:$C$37,3,FALSE)","v":0},{"$f":"VLOOKUP(AV1,Energía!$A$4:$C$37,3,FALSE)","v":0},{"$f":"VLOOKUP(AW1,Energía!$A$4:$C$37,3,FALSE)","v":0},{"$f":"VLOOKUP(AX1,Energía!$A$4:$C$37,3,FALSE)","v":0},{"$f":"IF(VLOOKUP(AY1,Energía!$A$4:$C$37,3,FALSE)=\"Si\",1,0)","v":0},{"$f":"VLOOKUP(AZ1,Energía!$A$4:$C$37,3,FALSE)","v":0},{"$f":"IF(VLOOKUP(BA1,Energía!$A$4:$C$37,3,FALSE)=\"Sí\",1,0)","v":0},{"$f":"IF(VLOOKUP(BB1,Energía!$A$4:$C$37,3,FALSE)=\"Sí\",1,0)","v":0},{"$f":"IF(VLOOKUP(BC1,Energía!$A$4:$C$37,3,FALSE)=\"Sí\",1,0)","v":0},{"$f":"IF(VLOOKUP(BD1,Energía!$A$4:$C$37,3,FALSE)=\"Sí\",1,0)","v":0},{"$f":"IF(VLOOKUP(BE1,Energía!$A$4:$C$37,3,FALSE)=\"Sí\",1,0)","v":0},{"$f":"IF(VLOOKUP(BF1,Energía!$A$4:$C$37,3,FALSE)=\"Sí\",1,0)","v":0},{"$f":"IF(VLOOKUP(BG1,Energía!$A$4:$C$37,3,FALSE)=\"Sí\",1,0)","v":0},{"$f":"IF(VLOOKUP(BH1,Energía!$A$4:$C$37,3,FALSE)=\"Sí\",1,0)","v":0},{"$f":"VLOOKUP(BI1,Agua!$A$4:$C$15,3,FALSE)","v":0},{"$f":"VLOOKUP(BJ1,Agua!$A$4:$C$15,3,FALSE)","v":0},{"$f":"IF(VLOOKUP(BK1,Agua!$A$4:$C$15,3,FALSE)=\"Sí\",1,0)","v":0},{"$f":"IF(VLOOKUP(BL1,Agua!$A$4:$C$15,3,FALSE)=\"Sí\",1,0)","v":0},{"$f":"IF(VLOOKUP(BM1,Agua!$A$4:$C$15,3,FALSE)=\"Sí\",1,0)","v":0},{"$f":"IF(VLOOKUP(BN1,Agua!$A$4:$C$15,3,FALSE)=\"Sí\",1,0)","v":0},{"$f":"IF(VLOOKUP(BO1,Agua!$A$4:$C$15,3,FALSE)=\"Sí\",1,0)","v":0},{"$f":"IF(VLOOKUP(BP1,Agua!$A$4:$C$15,3,FALSE)=\"Sí\",1,0)","v":0},{"$f":"VLOOKUP(BQ1,Residuos!$A$4:$C$34,3,FALSE)","v":0},{"$f":"Residuos!C5","v":0},{"$f":"VLOOKUP(BS1,Residuos!$A$4:$C$34,3,FALSE)","v":0},{"$f":"VLOOKUP(BT1,Residuos!$A$4:$C$34,3,FALSE)","v":0},{"$f":"VLOOKUP(BU1,Residuos!$A$4:$C$34,3,FALSE)","v":0},{"$f":"VLOOKUP(BV1,Residuos!$A$4:$C$34,3,FALSE)","v":0},{"$f":"VLOOKUP(BW1,Residuos!$A$4:$C$34,3,FALSE)","v":0},{"$f":"VLOOKUP(BX1,Residuos!$A$4:$C$34,3,FALSE)","v":0},{"$f":"IF(VLOOKUP(BY1,Residuos!$A$4:$C$34,3,FALSE)=\"Sí\",1,0)","v":0},{"$f":"IF(VLOOKUP(BZ1,Residuos!$A$4:$C$34,3,FALSE)=\"Sí\",1,0)","v":0},{"$f":"IF(VLOOKUP(CA1,Residuos!$A$4:$C$34,3,FALSE)=\"Sí\",1,0)","v":0},{"$f":"IF(VLOOKUP(CB1,Residuos!$A$4:$C$34,3,FALSE)=\"Sí\",1,0)","v":0},{"$f":"IF(VLOOKUP(CC1,Residuos!$A$4:$C$34,3,FALSE)=\"Sí\",1,0)","v":0},{"$f":"IF(VLOOKUP(CD1,Residuos!$A$4:$C$34,3,FALSE)=\"Sí\",1,0)","v":0},{"$f":"IF(VLOOKUP(CE1,Residuos!$A$4:$C$34,3,FALSE)=\"Sí\",1,0)","v":0},{"$f":"IF(VLOOKUP(CF1,Residuos!$A$4:$C$34,3,FALSE)=\"Sí\",1,0)","v":0},{"$f":"IF(VLOOKUP(CG1,Residuos!$A$4:$C$34,3,FALSE)=\"Sí\",1,0)","v":0},{"$f":"IF(VLOOKUP(CH1,Residuos!$A$4:$C$34,3,FALSE)=\"Sí\",1,0)","v":0},{"$f":"IF(VLOOKUP(CI1,Residuos!$A$4:$C$34,3,FALSE)=\"Sí\",1,0)","v":0},{"$f":"IF(VLOOKUP(CJ1,Residuos!$A$4:$C$34,3,FALSE)=\"Sí\",1,0)","v":0},{"$f":"IF(VLOOKUP(CK1,Residuos!$A$4:$C$34,3,FALSE)=\"Sí\",1,0)","v":0},{"$f":"VLOOKUP(CL1,'Deperdicio alimentario'!$A$4:$C$20,3,FALSE)","v":0},{"$f":"VLOOKUP(CM1,'Deperdicio alimentario'!$A$4:$C$20,3,FALSE)","v":0},{"$f":"IF(VLOOKUP(CN1,'Deperdicio alimentario'!$A$4:$C$20,3,FALSE)=\"Sí\",1,0)","v":0},{"$f":"IF(VLOOKUP(CO1,'Deperdicio alimentario'!$A$4:$C$20,3,FALSE)=\"Sí\",1,0)","v":0},{"$f":"IF(VLOOKUP(CP1,'Deperdicio alimentario'!$A$4:$C$20,3,FALSE)=\"Sí\",1,0)","v":0},{"$f":"IF(VLOOKUP(CQ1,'Deperdicio alimentario'!$A$4:$C$20,3,FALSE)=\"Sí\",1,0)","v":0},{"$f":"IF(VLOOKUP(CR1,'Deperdicio alimentario'!$A$4:$C$20,3,FALSE)=\"Sí\",1,0)","v":0},{"$f":"IF(VLOOKUP(CS1,'Deperdicio alimentario'!$A$4:$C$20,3,FALSE)=\"Sí\",1,0)","v":0},{"$f":"IF(VLOOKUP(CT1,'Deperdicio alimentario'!$A$4:$C$20,3,FALSE)=\"Sí\",1,0)","v":0},{"$f":"SUM(T2:AL2)","v":0},{"$f":"HLOOKUP('Datos y cálculos'!AN2,Energía!$E$6:$K$7,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"(HLOOKUP(AU2,Energía!$E$6:$K$7,2,FALSE)+HLOOKUP(AV2,Energía!$E$6:$K$7,2,FALSE)+HLOOKUP(AW2,Energía!$E$6:$K$7,2,FALSE)+HLOOKUP(AX2,Energía!$E$6:$K$7,2,FALSE))/4","v":{"$error":"#N/A"}},{"$f":"SUM(BA2:BH2)+AY2","v":0},{"$f":"AM2*1000/N2","v":{"$error":"#DIV/0!"}},{"$f":"AM2*1000/O2","v":{"$error":"#DIV/0!"}},{"$f":"AM2*1000/L2","v":{"$error":"#DIV/0!"}},{"$f":"(AO2*AR2/100)*1000/N2","v":{"$error":"#DIV/0!"}},{"$f":"(AO2*AR2/100)*1000/O2","v":{"$error":"#DIV/0!"}},{"$f":"(AO2*AR2/100)*1000/L2","v":{"$error":"#DIV/0!"}},{"$f":"AR2*1000/N2","v":{"$error":"#DIV/0!"}},{"$f":"AS2*1000/N2","v":{"$error":"#DIV/0!"}},{"$f":"AT2*1000/N2","v":{"$error":"#DIV/0!"}},{"$f":"AR2*1000/O2","v":{"$error":"#DIV/0!"}},{"$f":"AS2*1000/O2","v":{"$error":"#DIV/0!"}},{"$f":"AT2*1000/O2","v":{"$error":"#DIV/0!"}},{"$f":"AR2*1000/L2","v":{"$error":"#DIV/0!"}},{"$f":"AS2*1000/L2","v":{"$error":"#DIV/0!"}},{"$f":"AT2*1000/L2","v":{"$error":"#DIV/0!"}},{"$f":"(BI2*BJ2/100)/N2","v":{"$error":"#DIV/0!"}},{"$f":"(BI2*BJ2/100)/O2","v":{"$error":"#DIV/0!"}},{"$f":"(BI2*BJ2/100)/L2","v":{"$error":"#DIV/0!"}},{"$f":"BJ2/N2","v":{"$error":"#DIV/0!"}},{"$f":"BJ2/O2","v":{"$error":"#DIV/0!"}},{"$f":"BJ2/L2","v":{"$error":"#DIV/0!"}},{"$f":"SUM(BK2:BP2)","v":0},{"$f":"BS2","v":0},0,0,0,0,0,{"$f":"BS2*100/SUM($BS$2:$BX$2)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"DU2*100/SUM($DU$2:$DZ$2)","v":{"$error":"#DIV/0!"}},{"$f":"DV2*100/SUM($DU$2:$DZ$2)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"100-EF2","v":{"$error":"#DIV/0!"}},{"$f":"BS2*1000/$N$2","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"BS2*1000/$O$2","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"BS2*1000/$L$2","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"SUM(BS2:BX2)","v":0},{"$f":"SUM(DU2:DZ2)","v":0},{"$f":"SUM(BY2:CK2)","v":0},{"$f":"SUM(CN2:CT2)","v":0}]
["Hotel Pepe",2023,52,"Valencia","*","Complejo turístico/ resort – Nivel superior","Urbano – en el centro de la ciudad","Gestión de la cadena","Cadenas de lujo","Todo el año","Propio",2000,90,19000,17000,20,5,35,10,1,0,1,1,1,1,1,1,1,1,1,1,1,1,1,1,0,1,1,27.03,"A",100,100,0,320000,0,200000,"C","F","A","C",1,1000000,1,1,1,1,1,0,0,0,33,8480000,0,1,1,0,1,1,2.137,0,52,156,260,104,208,936,1,1,0,0,0,1,0,0,0,0,0,0,0,20,10,0,0,0,1,0,0,0,17,1,0.625,6,1.422631578947368,1.59,13.515000000000001,16842.10526315789,18823.52941176471,160000,16842.10526315789,0,10526.315789473691,18823.52941176471,0,11764.705882352941,160000,0,100000,147.2842105263158,164.61176470588239,1399.2,446.31578947368422,498.8235294117647,4240,4,null,null,null,null,null,null,3.0303030303030298,9.0909090909090917,15.15151515151515,6.0606060606060614,12.121212121212119,54.545454545454547,null,null,null,null,null,null,45.454545454545453,2.736842105263158,8.2105263157894743,13.684210526315789,5.4736842105263159,10.94736842105263,49.263157894736842,3.0588235294117641,9.1764705882352935,15.294117647058821,6.117647058823529,12.23529411764706,55.058823529411768,26,78,130,52,104,468,1716,null,3,1]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"L2-L3","v":-2000},{"$f":"M2-M3","v":-90},-19000,-17000,-20,-5,-35,-10,-1,0,-1,-1,-1,-1,-1,-1,-1,-1,-1,-1,-1,-1,-1,-1,0,-1,-1,-27.03,{"$error":"#VALUE!"},-100,-100,0,-320000,0,-200000,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},-1,-1000000,-1,-1,-1,-1,-1,0,0,0,-33,-8480000,0,-1,-1,0,-1,-1,-2.137,{"$f":"BR2-BR3","v":0},{"$f":"BS2-BS3","v":-52},{"$f":"BT2-BT3","v":-156},{"$f":"BU2-BU3","v":-260},{"$f":"BV2-BV3","v":-104},{"$f":"BW2-BW3","v":-208},{"$f":"BX2-BX3","v":-936},{"$f":"BY2-BY3","v":-1},{"$f":"BZ2-BZ3","v":-1},{"$f":"CA2-CA3","v":0},{"$f":"CB2-CB3","v":0},{"$f":"CC2-CC3","v":0},-1,0,0,0,0,0,0,0,-20,-10,0,0,0,-1,0,0,0,-17,{"$error":"#N/A"},{"$error":"#N/A"},-6,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"DN2-DN3","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},-4,0,0,0,0,0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"EP2-EP3","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},-1716,0,-3,-1]

{"sheet":"Scale","index":11,"n_rows":32,"n_cols":25,"rows_kept":32,"cut":false,"hidden":true,"merged":[]}
["Indicador","Min","Bajo","Medio","Alto","Max","Dir","Dim","Sdim","Pdim","Psdim","Puntos","referencia",null,null,null,null,null,null,"Dimension","Puntos",null,"Subdimension"]
["P1B",0,10,20,30,40,0,"Planificación y Gestión Circular","Inversión",{"$f":"IF(H2=\"\",0,VLOOKUP(H2,$T$2:$U$8,2,FALSE))","v":20},{"$f":"IF(I2=\"\",0,VLOOKUP(I2,$W$2:$X$28,2,FALSE))","v":0.2},{"$f":"J2*K2","v":4},null,null,null,null,null,null,null,"Planificación y Gestión Circular",20,null,"Inversión",0.2,"Planificación y Gestión Circular"]
["P2B",0,25,50,75,100,0,"Planificación y Gestión Circular","Formación",20,0.05,{"$f":"J3*K3","v":1},null,null,null,null,null,null,null,"Energía",20,null,"Formación",0.05,"Planificación y Gestión Circular"]
["P3B",0,25,50,75,100,0,"Planificación y Gestión Circular","Compromiso circular de proveedores",20,0.05,1,null,null,null,null,null,null,null,"Agua",20,null,"Compromiso circular de proveedores",0.05,"Planificación y Gestión Circular"]
["P2_3B",0,25,50,75,100,0,"Planificación y Gestión Circular","Formación",20,0.05,1,null,null,null,null,null,null,null,"Residuos",20,null,"Buenas Prácticas Planifircación y Gestión Circular",0.7,"Planificación y Gestión Circular"]
["PBP",0,{"$f":"F6*0.25","v":4.75},{"$f":"F6*0.5","v":9.5},{"$f":"F6*0.75","v":14.25},19,0,"Planificación y Gestión Circular","Buenas Prácticas Planifircación y Gestión Circular",20,0.7,14,null,null,null,null,null,null,null,"Desperdicio Alimentario",20,null,"Consumo energético huella de carbono hab",0.1,"Energía"]
["E1B2",24.5,19,13.5,8,2.5,1,"Energía","Consumo energético huella de carbono hab",20,0.1,2,"Greenview","hab ocu",null,null,null,null,null,null,0,null,"Consumo energético huella de carbono m2",0.05,"Energía"]
["E1B3",85,70,55,40,25,1,"Energía","Certificación Energética Edificio",20,0.1,2,"Greenview","m2",null,null,null,null,null,"Nivel de Circularidad",{"$f":"SUM(U2:U6)","v":100},null,"Certificación Energética Edificio",0.1,"Energía"]
["E2B_val",0,0.25,0.5,0.75,1,0,"Energía","Certificación Energética Edificio",20,0.1,2,null,null,null,null,null,null,null,null,null,null,"Certificación Energética Instalaciones",0.1,"Energía"]
["EI",0,0.25,0.5,0.75,1,0,"Energía","Certificación Energética Instalaciones",20,0.1,2,null,null,null,null,null,null,null,null,null,null,"Autoabastecimiento Energía",0.1,"Energía"]
["E3B",0,7.5,15,22.5,30,0,"Energía","Autoabastecimiento Energía",20,0.1,2,"Greenview",null,null,null,null,null,null,null,null,null,"Consumo energético por hab",0.1,"Energía"]
["E62",87.5,70,52.5,35,17.5,1,"Energía","Consumo energético por hab",20,0.1,2,"Greenview","hab ocu",null,null,null,null,null,null,null,null,"Consumo energético por m2",0.05,"Energía"]
["E63",330,280,230,180,130,1,"Energía","Consumo energético por m2",20,0.05,1,"Greenview yconsumo energético de hoteles de la Comunidad Valenciana",null,null,null,null,null,null,null,null,null,"Buenas Prácticas Energia",0.4,"Energía"]
["EBP",0,{"$f":"F14*0.25","v":2},{"$f":"F14*0.5","v":4},{"$f":"F14*0.75","v":6},8,0,"Energía","Buenas Prácticas Energia",20,0.4,8,null,null,null,null,null,null,null,null,null,null,"Autoabastecimiento Agua",0.2,"Agua"]
["A1B",0,25,50,75,100,0,"Agua","Autoabastecimiento Agua",20,0.2,4,null,null,null,null,null,null,null,null,null,null,"Consumo Agua por habitación",0.3,"Agua"]
["A2B1",{"$f":"(C16-D16)+C16","v":490},440,390,340,{"$f":"E16-(D16-E16)","v":290},1,"Agua","Consumo Agua por huesped",20,{"$error":"#N/A"},{"$error":"#N/A"},"revisar",null,null,null,null,null,null,null,null,null,"Consumo Agua por m2",0.1,"Agua"]
["A2B2",685,570,455,340,{"$f":"E17-(D17-E17)","v":225},1,"Agua","Consumo Agua por habitación",20,0.3,6,"Greenview","hab ocu",null,null,null,null,null,null,null,null,"Buenas Prácticas Agua",0.4,"Agua"]
["A2B3",3000,2650,2000,1400,800,1,"Agua","Consumo Agua por m2",20,0.1,2,"Greenview","m2",null,null,null,null,null,null,null,null,"Residuos valorizados",0.5,"Residuos"]
["A1_2B",0,0.25,0.5,0.75,1,0,"Agua","Consumo Agua por habitación",20,0.3,6,null,null,null,null,null,null,null,null,null,null,"Residuos construcción",0.1,"Residuos"]
["ABP",0,{"$f":"F20*0.25","v":1.5},{"$f":"F20*0.5","v":3},{"$f":"F20*0.75","v":4.5},6,0,"Agua","Buenas Prácticas Agua",20,0.4,8,null,null,null,null,null,null,null,null,null,null,"Buenas Prácticas Residuos",0.4,"Residuos"]
["RVal",0,25,50,75,100,0,"Residuos","Residuos valorizados",20,0.5,10,null,null,null,null,null,null,null,null,null,null,"Alimentos km0",0.2,"Desperdicio Alimentario"]
["R2B",0,25,50,75,100,0,"Residuos","Residuos construcción",20,0.1,2,null,null,null,null,null,null,null,null,null,null,"Alimentos reducción envases",0.2,"Desperdicio Alimentario"]
["RBP",0,{"$f":"F23*0.25","v":3},{"$f":"F23*0.5","v":6},{"$f":"F23*0.75","v":9},12,0,"Residuos","Buenas Prácticas Residuos",20,0.4,{"$f":"J23*K23","v":8},null,null,null,null,null,null,null,null,null,null,"Buenas Prácticas Desperdicio Alimentario",0.6,"Desperdicio Alimentario"]
["RA1B",0,12.5,25,37.5,50,0,"Desperdicio Alimentario","Alimentos km0",20,0.2,4,null,null,null,null,null,null,null,null,null,null,"Planificación y Gestión Circular",{"$f":"X2+X3+X4+X5","v":1}]
["RA2B",0,12.5,25,37.5,50,0,"Desperdicio Alimentario","Alimentos reducción envases",20,0.2,4,null,null,null,null,null,null,null,null,null,null,"Energía",{"$f":"SUM(X6:X13)","v":1}]
["RABP",0,{"$f":"F26*0.25","v":1.25},{"$f":"F26*0.5","v":2.5},{"$f":"F26*0.75","v":3.75},5,0,"Desperdicio Alimentario","Buenas Prácticas Desperdicio Alimentario",20,0.6,12,null,null,null,null,null,null,null,null,null,null,"Agua",{"$f":"X14+X15+X16+X17","v":1}]
["Planificación y Gestión Circular",0,{"$f":"(F27-B27)*0.25","v":5},{"$f":"(F27-B27)*0.5","v":10},{"$f":"(F27-B27)*0.75","v":15},{"$f":"U2","v":20},0,"Planificación y Gestión Circular",null,20,{"$f":"IF(H27=\"\",0,VLOOKUP(H27,$W$2:$X$29,2,FALSE))","v":1},20,null,null,null,null,null,null,null,null,null,null,"Residuos",{"$f":"X18+X19+X20","v":1}]
["Energía",0,{"$f":"(F28-B28)*0.25","v":5},{"$f":"(F28-B28)*0.5","v":10},{"$f":"(F28-B28)*0.75","v":15},{"$f":"U3","v":20},0,"Energía",null,20,1,20,null,null,null,null,null,null,null,null,null,null,"Desperdicio Alimentario",{"$f":"X21+X22+X23","v":1}]
["Agua",0,{"$f":"(F29-B29)*0.25","v":5},{"$f":"(F29-B29)*0.5","v":10},{"$f":"(F29-B29)*0.75","v":15},{"$f":"U4","v":20},0,"Agua",null,20,1,20,null,null,null,null,null,null,null,null,null,null,"Nivel de Circularidad",1]
["Residuos",0,{"$f":"(F30-B30)*0.25","v":5},{"$f":"(F30-B30)*0.5","v":10},{"$f":"(F30-B30)*0.75","v":15},{"$f":"U5","v":20},0,"Residuos",null,20,1,20]
["Desperdicio Alimentario",0,{"$f":"(F31-B31)*0.25","v":5},{"$f":"(F31-B31)*0.5","v":10},{"$f":"(F31-B31)*0.75","v":15},{"$f":"U6","v":20},0,"Desperdicio Alimentario",null,20,1,20]
["Nivel de Circularidad",{"$f":"B27+B28+B29+B30+B31","v":0},25,50,75,{"$f":"F27+F28+F29+F30+F31","v":100},0,"Nivel de Circularidad",null,100,1,100]

{"sheet":"Hoja1","index":12,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}