{"text_format":"3","workbook":"xlsx","n_sheets":18,"sheets":["Home","Strategy","BEI","MEI1","MEI2","Mitigation Actions","BoE","Mitigation Report","Monitoring Report","Adaptation Scoreboard","Risks & Vulnerabilities","Adaptation Actions","Adaptation Report","Adaptation Indicators","EFs","Categories","Drop-down Menus","extra"],"not_rendered":{"charts":24,"images":7,"macros":1,"external_links":16,"defined_names":518,"comments":2},"read":"whole","date_system":"1900"}

{"sheet":"Home","index":0,"n_rows":42,"n_cols":18,"rows_kept":42,"merged":[[0,4,1,17],[8,2,16,6],[28,2,29,3],[28,4,28,6],[28,7,29,7],[28,11,31,19],[31,2,34,2],[34,11,35,17],[35,2,39,2],[38,11,40,19]]}
[{"$nulls":4},"Sustainable Energy and Climate Action Plan Template"]
{"$rows_empty":7}
[null,null,"The Sustainable Energy and Climate Action Plan (SECAP) template and its monitoring fields constitute the reporting framework of the Covenant of Mayors initiative. It has been developed by the Covenant of Mayors and Mayors Adapt Offices - together with the Joint Research Centre of the European Commission - and in collaboration with a group of practitioners from local and regional authorities. This Excel-based template is an offline working version of the official online template which has to be completed in English and submitted online via \"My Covenant\": http://www.eumayors.eu/sign-in_en.html. The online vesion of this template should be available as of 2017. Please note that it is not possible to import the data entered in this Excel into the online platform. ",{"$nulls":8},"Commitments:",{"$nulls":4},"Colour codes:"]
[]
[{"$nulls":12},"2020 CO2 reduction",{"$nulls":4},"   Mandatory input cells"]
[]
[{"$nulls":12},"2030 CO2 reduction",{"$nulls":4},"   Optional input cells"]
[]
[{"$nulls":12},"Long-term CO2 reduction",{"$nulls":4},"   Output cells"]
[]
[{"$nulls":12},"Climate Adaptation",{"$nulls":4},"   Pre-filled cells (for the online version)"]
[]
[{"$nulls":6},"Reporting Guidelines",{"$nulls":9},"Definition","   Definitions (visible when clicking)"]
[]
[{"$nulls":6},"SEAP guidebook",{"$nulls":10},"   Monitoring fields"]
[]
[{"$nulls":6},"Urban Adaptation Support Tool"]
[]
[]
[]
[null,null,"Template Structure & Minimum Reporting Requirements:",{"$nulls":8},"Objectives"]
[]
[null,null,"Template Structure",null,"Minimum Reporting Requirements",null,null,"Link to Tab",{"$nulls":3},"→ IDENTIFY & ASSESS local climate and energy challenges and priorities\n→ MONITOR & REPORT progress towards commitments\n→ INFORM & SUPPORT decision-makers \n→ COMMUNICATE results to general public\n→ ENABLE self-assessment & FACILITATE experience-sharing with peers\n→ DEMONSTRATE local achievements to policy-makers"]
[{"$nulls":4},"At the registration stage","Within 2 years","Within 4 years\n(and then every 2 years)"]
[{"$nulls":3},"Strategy","optional","*","*","Ü"]
[null,null,"Mitigation","Emission Inventories","optional","*\n(BEI)","*\n(MEI every 4 years)","Ü"]
[{"$nulls":3},"Mitigation Actions","optional","*","*","Ü"]
[{"$nulls":3},"Mitigation Report",{"$nulls":3},"Ü"]
[{"$nulls":3},"Monitoring Report",{"$nulls":3},"Ü",{"$nulls":3},"Developed by:  Covenant of Mayors & Mayors Adapt Offices, Joint Research Centre of the European Commission   "]
[null,null,"Adaptation","Adaptation Scoreboard","*","*","*","Ü"]
[{"$nulls":3},"Risks and Vulnerabilities","optional","*","*","Ü",{"$nulls":3},"Last update: July 2016"]
[{"$nulls":3},"Adaptation Actions","optional","optional","*\n(min. 3 Benchmarks)","Ü"]
[{"$nulls":3},"Adaptation Report",{"$nulls":3},"Ü",{"$nulls":3},"The sole responsibility for the content of this publication lies with the authors. It does not necessarily reflect the opinion of the European Communities. The European Commission is not responsible for any use that may be made of the information contained therein."]
[{"$nulls":3},"Adaptation Indicators",{"$nulls":3},"Ü"]
[{"$nulls":3},"* mandatory"]
[null,null,"                "]

{"sheet":"Strategy","index":1,"n_rows":98,"n_cols":30,"rows_kept":98,"merged":[[0,0,0,16],[7,1,9,2],[7,4,9,20],[12,4,12,10],[13,9,13,10],[14,9,14,10],[15,9,15,10],[16,9,16,10],[18,4,18,14],[19,4,19,11],[20,4,20,11],[21,4,21,11],[25,1,28,2],[25,4,27,20],[30,1,30,2],[30,10,30,11],[31,4,32,6],[31,7,31,9],[31,10,32,10],[32,8,32,9],[33,4,33,6],[33,8,33,9],[34,4,34,6],[34,8,34,9],[35,4,35,6],[35,8,35,9],[36,4,36,6],[36,8,36,9],[37,4,37,6],[37,8,37,9],[38,4,38,6],[38,8,38,9],[41,4,42,20],[45,1,51,2],[45,4,45,6],[45,8,45,12],[45,13,45,14],[46,4,46,6],[46,8,46,12],[46,13,46,14],[47,4,47,6],[47,8,47,12],[47,13,47,14],[48,4,48,6],[48,8,48,12],[48,13,48,14],[50,4,51,20],[54,29,54,30],[55,1,57,2],[55,4,57,6],[55,7,55,15],[55,18,57,20],[55,21,55,29],[56,7,56,10],[56,11,56,15],[56,21,56,24],[56,25,56,29],[57,8,57,9],[57,11,57,12],[57,13,57,14],[57,22,57,23],[57,25,57,26],[57,27,57,28],[58,4,58,6],[58,8,58,9],[58,11,58,12],[58,13,58,14],[58,18,58,20],[58,22,58,23],[58,25,58,26],[58,27,58,28],[59,4,59,6],[59,8,59,9],[59,11,59,12],[59,13,59,14],[59,18,59,20],[59,22,59,23],[59,25,59,26],[59,27,59,28],[60,4,60,6],[60,8,60,9],[60,11,60,12],[60,13,60,14],[60,18,60,20],[60,22,60,23],[60,25,60,26],[60,27,60,28],[61,4,61,6],[61,8,61,9],[61,11,61,12],[61,13,61,14],[61,18,61,20],[61,22,61,23],[61,25,61,26],[61,27,61,28],[62,4,62,6],[62,8,62,9],[62,11,62,12],[62,13,62,14],[62,18,62,20],[62,22,62,23],[62,25,62,26],[62,27,62,28],[63,4,63,6],[63,8,63,9],[63,11,63,12],[63,13,63,14],[63,18,63,20],[63,22,63,23],[63,25,63,26],[63,27,63,28],[65,4,65,5],[65,18,65,19],[68,4,69,20],[72,1,73,2],[72,4,73,20],[75,20,75,21],[75,22,75,23],[77,5,77,9],[77,10,77,11],[77,13,77,14],[77,15,77,16],[77,17,77,18],[77,19,77,20],[77,21,77,22],[78,5,78,9],[78,10,78,11],[78,13,78,14],[78,15,78,16],[78,17,78,18],[78,19,78,20],[78,21,78,22],[79,5,79,9],[79,10,79,11],[79,13,79,14],[79,15,79,16],[79,17,79,18],[79,19,79,20],[79,21,79,22],[80,5,80,9],[80,10,80,11],[80,13,80,14],[80,15,80,16],[80,17,80,18],[80,19,80,20],[80,21,80,22],[81,4,81,9],[81,10,81,11],[81,13,81,14],[81,15,81,16],[81,17,81,18],[81,19,81,20],[81,21,81,22],[82,5,82,9],[82,10,82,11],[82,13,82,14],[82,15,82,16],[82,17,82,18],[82,19,82,20],[82,21,82,22],[83,5,83,9],[83,10,83,11],[83,13,83,14],[83,15,83,16],[83,17,83,18],[83,19,83,20],[83,21,83,22],[84,5,84,9],[84,10,84,11],[84,13,84,14],[84,15,84,16],[84,17,84,18],[84,19,84,20],[84,21,84,22],[85,4,85,9],[85,10,85,11],[85,13,85,14],[85,15,85,16],[85,17,85,18],[85,19,85,20],[85,21,85,22],[90,1,91,2],[90,4,91,20],[93,1,94,2],[94,4,95,20],[97,0,97,16]]}
["Strategy",{"$nulls":22},"y HOME"]
[]
[]
[]
[]
["Strategy"]
[]
["1)","Vision"]
[]
[{"$nulls":21},{"$f":"CONCATENATE(TEXT(700-LEN(E8),\"#\"),\" chars left\")","v":"700 chars left"}]
[]
[]
["2) ","Commitments",null,null,"Mitigation"]
[{"$nulls":4},"CO2 Target","Unit","Target Year","Base Year","Reduction Type","Population estimates in target year"]
[{"$nulls":5},"%",2020,"[drop -down]","[drop -down]"]
[{"$nulls":5},"%",2030,"[drop -down]","[drop -down]"]
[{"$nulls":6},"[drop -down]","[drop -down]","[drop -down]"]
[]
[{"$nulls":4},"Adaptation"]
[{"$nulls":4},"Goal",{"$nulls":7},"Unit \n(% or other)","Target year","Base Year"]
[{"$nulls":13},"[drop -down]","[drop -down]"]
[{"$nulls":13},"[drop -down]","[drop -down]"]
[{"$nulls":4},"i Add as many rows as necessary."]
[]
[]
["3)","Coordination and organisational structures created/assigned"]
[]
[{"$nulls":21},{"$f":"CONCATENATE(TEXT(700-LEN(E26),\"#\"),\" chars left\")","v":"700 chars left"}]
[]
[]
["4)","Staff capacity allocated ",{"$nulls":8},"MONITORING  "]
[{"$nulls":4},"Type",null,null,"Plan Preparation",null,null,"Plan Implementation"]
[{"$nulls":8},"Full-time equivalent job(s)"]
[{"$nulls":4},"Local authority",null,null,"[Select x]",null,null,"[Select x]"]
[{"$nulls":4},"Covenant Coordinator",null,null,"[Select x]",null,null,"[Select x]"]
[{"$nulls":4},"Covenant Supporter",null,null,"[Select x]",null,null,"[Select x]"]
[{"$nulls":4},"External consultant",null,null,"[Select x]",null,null,"[Select x]"]
[{"$nulls":4},"Other",null,null,"[Select x]",null,null,"[Select x]"]
[{"$nulls":4},"Total",{"$nulls":3},{"$f":"SUM(I34:J38)","v":0}]
[{"$nulls":7},"i Select x for the ones that are applicable."]
[]
[]
[{"$nulls":21},{"$f":"CONCATENATE(TEXT(700-LEN(E42),\"#\"),\" chars left\")","v":"700 chars left"}]
[]
[]
["5)","Involvement of stakeholders and citizens",null,null,"Type",{"$nulls":3},"Stakeholders involved",{"$nulls":4},"Level of involvement"]
[{"$nulls":4},"Local athority's staff",null,null,"[Select x]",{"$nulls":5},"[drop-down]"]
[{"$nulls":4},"External stakeholders\nat local level",null,null,"[Select x]",{"$nulls":5},"[drop-down]"]
[{"$nulls":4},"Stakeholders\nat other levels of governance",null,null,"[Select x]",{"$nulls":5},"[drop-down]"]
[{"$nulls":7},"i Select x for the ones that are applicable."]
[]
[{"$nulls":21},{"$f":"CONCATENATE(TEXT(700-LEN(E51),\"#\"),\" chars left\")","v":"700 chars left"}]
[]
[]
[{"$nulls":29},"MONITORING  "]
["6) ","Overall  budget for implementation and financing sources",null,null,"Source",null,null,"Budget foreseen for plan implementation (€)",{"$nulls":10},"Source",null,null,"Budget spent so far for plan implementation (€)"]
[{"$nulls":7},"Mitigation",{"$nulls":3},"Adaptation",{"$nulls":9},"Mitigation",{"$nulls":3},"Adaptation"]
[{"$nulls":8},"  Investment (€)",null,"  Non-investment  (€)",null,null,"  Investment  (€)",null,"  Non-investment  (€)",null,{"$f":"IF(SUM(R59:R61)=0,\"\",SUM(R59:R61))","v":""},{"$nulls":4},"  Investment (€)",null,"  Non-investment  (€)",null,null,"  Investment  (€)",null,"  Non-investment  (€)"]
[{"$nulls":4},"Local Authority's own resources",null,null,"[Select x]",{"$nulls":3},"[Select x]",{"$nulls":6},"Local Authority's own resources",null,null,"[Select x]",{"$nulls":3},"[Select x]"]
[{"$nulls":4},"Other actors:",null,null,"[Select x]",{"$f":"SUM(I61:J63)","v":0},null,{"$f":"SUM(K61:K63)","v":0},"[Select x]",null,{"$f":"SUM(N61:O63)","v":0},null,{"$f":"SUM(P61:P63)","v":0},null,null,"Other actors:",null,null,"[Select x]",{"$f":"SUM(W61:X63)","v":0},null,{"$f":"SUM(Y61:Y63)","v":0},"[Select x]",null,{"$f":"SUM(AB61:AC63)","v":0},null,{"$f":"SUM(AD61:AD63)","v":0}]
[{"$nulls":4},"  - National Funds & Programmes",null,null,"[Select x]",{"$nulls":3},"[Select x]",{"$nulls":6},"  - National Funds & Programmes",null,null,"[Select x]",{"$nulls":3},"[Select x]"]
[{"$nulls":4},"  - EU Funds & Programmes",null,null,"[Select x]",{"$nulls":3},"[Select x]",{"$nulls":6},"  - EU Funds & Programmes",null,null,"[Select x]",{"$nulls":3},"[Select x]"]
[{"$nulls":4},"  - Private",null,null,"[Select x]",{"$nulls":3},"[Select x]",{"$nulls":5},{"$f":"IF(SUM(R59:R62)=0,\"\",SUM(R59:R62))","v":""},"  - Private",null,null,"[Select x]",{"$nulls":3},"[Select x]"]
[{"$nulls":4},"Total",{"$nulls":3},{"$f":"SUM(I59,I60)","v":0},null,{"$f":"SUM(K59,K60)","v":0},null,null,{"$f":"SUM(N59:O60)","v":0},null,{"$f":"SUM(P59:P60)","v":0},null,null,"Total",{"$nulls":3},{"$f":"SUM(W59,W60)","v":0},null,{"$f":"SUM(Y59,Y60)","v":0},null,null,{"$f":"SUM(AB59:AC60)","v":0},null,{"$f":"SUM(AD59:AD60)","v":0}]
[{"$nulls":7},"i Select x for the ones that are applicable.",{"$nulls":13},"i Select x for the ones that are applicable."]
[{"$nulls":4},"Time period",null,null,1990,null,2030,null,{"$f":"J66-H66+1","v":41}," years",{"$nulls":5},"Time period",null,null,1990,null,2016,null,{"$f":"X66-V66+1","v":27}," years"]
[]
[]
[]
[{"$nulls":21},{"$f":"CONCATENATE(TEXT(700-LEN(E69),\"#\"),\" chars left\")","v":"700 chars left"}]
[]
[]
["7) ","Monitoring process"]
[{"$nulls":21},{"$f":"CONCATENATE(TEXT(700-LEN(E73),\"#\"),\" chars left\")","v":"700 chars left"}]
[]
[{"$nulls":4},"Please rate (little/fair/strong/not applicable) the main problems encountered during your action plan implementation, either overall or by sector:",{"$nulls":17},"MONITORING  "]
[]
[{"$nulls":10},"All sectors",null,null,"Municipal ",null,"Tertiary",null,"Residential",null,"Transport",null,"Adaptation"]
[{"$nulls":5},"Limited financial sources"]
[{"$nulls":5},"Absence of / weak regulatory framework"]
[{"$nulls":5},"Lack of technical expertise"]
[{"$nulls":4},"Lack of support from stakeholders"]
[{"$nulls":5},"Lack of political support at other administrative levels"]
[{"$nulls":5},"Changes in the local political priorities"]
[{"$nulls":5},"Incompability with national policy orientations"]
[{"$nulls":4},"Immature or high cost technologies"]
[]
[]
[]
[]
["8)","Assessment of the Adaptation Options"]
[{"$nulls":21},{"$f":"CONCATENATE(TEXT(700-LEN(E91),\"#\"),\" chars left\")","v":"700 chars left"}]
[]
["9)","Strategy in case of extreme climate events"]
[]
[{"$nulls":21},{"$f":"CONCATENATE(TEXT(700-LEN(E95),\"#\"),\" chars left\")","v":"700 chars left"}]
[]
[{"$nulls":23},"Ü NEXT"]

{"sheet":"BEI","index":2,"n_rows":143,"n_cols":20,"rows_kept":143,"merged":[[0,0,0,13],[21,1,23,2],[21,3,23,18],[26,1,26,2],[29,1,31,2],[29,3,29,18],[30,3,31,3],[30,4,31,4],[30,5,30,12],[30,13,30,17],[30,18,31,18],[32,1,32,2],[32,3,32,18],[33,1,33,2],[34,1,34,2],[35,1,35,2],[36,1,36,2],[37,1,38,1],[39,1,39,2],[40,1,40,2],[40,3,40,18],[41,1,41,2],[42,1,42,2],[43,1,43,2],[44,1,44,2],[45,1,45,2],[45,3,45,18],[46,1,46,2],[47,1,47,2],[57,1,57,2],[58,1,58,2],[62,1,62,2],[63,1,63,2],[64,1,64,2],[65,1,65,2],[66,1,66,2],[67,1,67,2],[71,1,73,2],[71,3,72,4],[71,5,71,14],[71,15,72,16],[72,5,72,9],[72,10,73,10],[72,11,73,11],[72,12,73,12],[72,13,73,13],[72,14,73,14],[74,1,74,2],[75,1,75,2],[76,1,76,2],[80,1,82,2],[80,3,81,4],[80,5,80,14],[80,15,81,16],[81,5,81,9],[81,10,82,10],[81,11,82,11],[81,12,82,12],[81,13,82,13],[81,14,82,14],[83,1,83,2],[84,1,84,2],[85,1,85,2],[86,1,86,2],[95,2,95,3],[95,4,96,4],[95,5,95,12],[95,13,95,17],[102,1,102,2],[103,1,103,2],[104,1,104,2],[105,1,105,2],[111,1,113,2],[111,3,111,18],[112,3,113,3],[112,4,113,4],[112,5,112,12],[112,13,112,17],[112,18,113,18],[114,1,114,2],[114,3,114,18],[115,1,115,2],[116,1,116,2],[117,1,117,2],[118,1,118,2],[119,1,120,1],[121,1,121,2],[122,1,122,2],[122,3,122,18],[123,1,123,2],[124,1,124,2],[125,1,125,2],[126,1,126,2],[127,1,127,2],[127,3,127,18],[128,1,128,2],[129,1,129,2],[129,3,129,18],[130,1,130,2],[130,3,132,17],[131,1,131,2],[132,1,132,2],[133,1,133,2],[139,1,140,17]]}
["Emission Inventory",{"$nulls":17},"y HOME"]
[]
[]
[]
[]
["Baseline Emission Inventory"]
[]
["1)","Inventory year",null,"[drop-down]"]
[]
[]
["2)","Number of inhabitants in the inventory year"]
[]
[]
["3)","Emission factors ",null,null,"  IPCC"]
[{"$nulls":4},"  LCA (Life Cycle Assessment)"]
[]
[]
["4)","Emission reporting unit",null,null,"  tonnes CO2 "]
[{"$nulls":4},"  tonnes CO2 equivalent"]
[]
[]
["5) ","Methodological notes"]
[]
[{"$nulls":19},{"$f":"CONCATENATE(TEXT(1000-LEN(D22),\"#\"),\" chars left\")","v":"1000 chars left"}]
[]
[]
[null,"A. Final energy consumption"]
[]
[null,"i Please note that for separating decimals dot [.] is used. No thousand separators are allowed."]
[null,"Sector",null,"FINAL ENERGY CONSUMPTION [MWh]"]
[{"$nulls":3},"Electricity","Heat/cold","Fossil fuels",{"$nulls":7},"Renewable energies",{"$nulls":4},"Total"]
[{"$nulls":5},"Natural gas","Liquid gas","Heating oil","Diesel","Gasoline","Lignite","Coal","Other fossil fuels","Plant oil","Biofuel ","Other biomass","Solar thermal","Geothermal"]
[null,"BUILDINGS, EQUIPMENT/FACILITIES AND INDUSTRIES",null," "]
[null,"Municipal buildings, equipment/facilities",{"$nulls":16},{"$f":"SUM(D34:R34)","v":0}]
[null,"Tertiary (non municipal) buildings, equipment/facilities",{"$nulls":16},0]
[null,"Residential buildings",{"$nulls":16},0]
[null,"Public lighting",{"$nulls":16},0]
[null,"Industry","Non-ETS",{"$nulls":15},0]
[null,null,"ETS (not recommended)",{"$nulls":15},0]
[null,"Subtotal ",null,{"$f":"SUM(D34:D39)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"TRANSPORT"]
[null,"Municipal fleet",{"$nulls":16},{"$f":"SUM(D42:R42)","v":0}]
[null,"Public transport ",{"$nulls":16},0]
[null,"Private and commercial transport  ",{"$nulls":16},0]
[null,"Subtotal ",null,{"$f":"SUM(D42:D44)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"OTHER  "]
[null,"Agriculture, Forestry, Fisheries",{"$nulls":16},{"$f":"SUM(D47:R47)","v":0}]
[null,"TOTAL",null,{"$f":"SUM(D40,D45,D47)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,"Covenant Key Sectors"]
[]
[]
[null,"B. Energy supply"]
[null,"i Hide sections or rows as appropriate to your emission inventory."]
[]
[null,"B1. Municipal purchases of certified green electricity"]
[]
[null,"Municipal purchases of certified green electricity",null,"Renewable electricity purchased [MWh]","CO2 / CO2 eq. Emission factor [t/MWh]"]
[null,"Certified green electricity purchased"]
[]
[null,"B2. Local/distributed electricity production (Renewable energy only)"]
[]
[null,"Local renewable electricity plants                                            (ETS and large-scale plants > 20 MWe not recommended)",null,"Renewable electricity produced [MWh]","Emission factor [t/MWh produced]","CO2 / CO2 eq. emissions [t]"]
[null,"Wind ",{"$nulls":3},{"$f":"D64*E64","v":0}]
[null,"Hydroelectric",{"$nulls":3},0]
[null,"Photovoltaics",{"$nulls":3},0]
[null,"Geothermal",{"$nulls":3},0]
[null,"TOTAL",null,{"$f":"SUM(D64:D67)","v":0},null,{"$f":"SUM(F64:F67)","v":0}]
[]
[null,"B3. Local/distributed electricity production"]
[]
[null,"Local electricity production plants                                         (ETS and large-scale plants > 20 MW not recommended)",null,"Electricity produced [MWh]",null,"  Energy carrier input [MWh]",{"$nulls":9},"CO2 / CO2 eq. emissions [t]"]
[{"$nulls":5},"Fossil fuels",{"$nulls":4},"Waste","Plant oil","Other biomass","Other renewable","Other"]
[{"$nulls":3},"from renewable sources","from non-renewable sources","Natural gas","Liquid gas","Heating oil","Lignite","Coal",{"$nulls":5},"Fossil sources","Renewable sources"]
[null,"Combined Heat and Power "]
[null,"Other"]
[null,"TOTAL",null,{"$f":"SUM(D75:D76)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,"B4. Local heat/cold production"]
[]
[null,"Local heat/cold production plants",null,"Heat/cold produced [MWh]",null,"  Energy carrier input [MWh]",{"$nulls":9},"CO2 / CO2 eq. emissions [t]"]
[{"$nulls":5},"Fossil fuels",{"$nulls":4},"Waste","Plant oil","Other biomass","Other renewable","Other"]
[{"$nulls":3},"from renewable sources","from non-renewable sources","Natural gas","Liquid gas","Heating oil","Lignite","Coal",{"$nulls":5},"Fossil sources","Renewable sources"]
[null,"Combined Heat and Power "]
[null,"District heating (heat-only) "]
[null,"Other"]
[null,"TOTAL",null,{"$f":"SUM(D84:D86)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[]
[]
[null,"C. CO2 emissions"]
[]
[null,"C1. Please insert the CO2 emission factors adopted [t/MWh]:"]
[]
[{"$nulls":5},"Click here to visualise fuel emission factors"]
[null,null,"Electricity",null,"Heat/cold","Fossil fuels",{"$nulls":7},"Renewable energies"]
[null,null,"National","Local",null,"Natural gas","Liquid gas","Heating oil","Diesel","Gasoline","Lignite","Coal","Other fossil fuels","Plant oil","Biofuel ","Other biomass","Solar thermal","Geothermal"]
[]
[]
[]
[null,"C2. Please complete in case non-energy related sectors are included:"]
[]
[null,"Non-energy related sectors",null,"CO2 eq. emissions [t]"]
[null,"Waste management"]
[null,"Waste water management"]
[null,"Other non-energy related"]
[]
[]
[]
[null,"Emission Inventory"]
[]
[null,"Sector",null,"CO2 emissions [t] / CO2 eq. emissions [t]"]
[{"$nulls":3},"Electricity","Heat/cold","Fossil fuels",{"$nulls":7},"Renewable energies",{"$nulls":4},"Total"]
[{"$nulls":5},"Natural gas","Liquid gas","Heating Oil","Diesel","Gasoline","Lignite","Coal","Other fossil fuels","Plant oil","Biofuel ","Other biomass","Solar thermal","Geothermal"]
[null,"BUILDINGS, EQUIPMENT/FACILITIES AND INDUSTRIES",null," "]
[null,"Municipal buildings, equipment/facilities",null,{"$f":"D34*D$98","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(D116:R116)","v":0}]
[null,"Tertiary (non municipal) buildings, equipment/facilities",null,{"$f":"D35*D$98","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Residential buildings",null,{"$f":"D36*D$98","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Public lighting",null,{"$f":"D37*D$98","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Industry","Non-ETS",{"$f":"D38*D$98","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"ETS (not recommended)",{"$f":"D39*D$98","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Subtotal",null,{"$f":"D40*D$98","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"TRANSPORT"]
[null,"Municipal fleet",null,{"$f":"D42*D$98","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(D124:R124)","v":0}]
[null,"Public transport ",null,{"$f":"D43*D$98","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Private and commercial transport  ",null,{"$f":"D44*D$98","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Subtotal",null,{"$f":"D45*D98","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"OTHER "]
[null,"Agriculture, Forestry, Fisheries",null,{"$f":"D47*D$98","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(D129:R129)","v":0}]
[null,"OTHER NON-ENERGY RELATED"]
[null,"Waste management",{"$nulls":16},{"$f":"D104","v":""}]
[null,"Waste water management",{"$nulls":16},""]
[null,"Other non-energy related",{"$nulls":16},""]
[null,"TOTAL",null,{"$f":"SUM(D122,D127,D129)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(S122,S127,S129,S131,S132,S133)","v":0}]
[]
[null,"Covenant Key Sectors"]
[]
[]
[null,"Additional comments"]
[]
[{"$nulls":18},{"$f":"CONCATENATE(TEXT(500-LEN(B140),\"#\"),\" chars left\")","v":"500 chars left"}]
[]
[{"$nulls":16},"BACK Û","Ü MEI1","Ü ACTIONS"]

{"sheet":"MEI1","index":3,"n_rows":145,"n_cols":20,"rows_kept":145,"merged":[[0,0,0,13],[22,1,24,2],[22,3,24,18],[27,1,27,2],[30,1,32,2],[30,3,30,18],[31,3,32,3],[31,4,32,4],[31,5,31,12],[31,13,31,17],[31,18,32,18],[33,1,33,2],[33,3,33,18],[34,1,34,2],[35,1,35,2],[36,1,36,2],[37,1,37,2],[38,1,39,1],[40,1,40,2],[41,1,41,2],[41,3,41,18],[42,1,42,2],[43,1,43,2],[44,1,44,2],[45,1,45,2],[46,1,46,2],[46,3,46,18],[47,1,47,2],[48,1,48,2],[58,1,58,2],[59,1,59,2],[63,1,63,2],[64,1,64,2],[65,1,65,2],[66,1,66,2],[67,1,67,2],[68,1,68,2],[72,1,74,2],[72,3,73,4],[72,5,72,14],[72,15,73,16],[73,5,73,9],[73,10,74,10],[73,11,74,11],[73,12,74,12],[73,13,74,13],[73,14,74,14],[75,1,75,2],[76,1,76,2],[77,1,77,2],[81,1,83,2],[81,3,82,4],[81,5,81,14],[81,15,82,16],[82,5,82,9],[82,10,83,10],[82,11,83,11],[82,12,83,12],[82,13,83,13],[82,14,83,14],[84,1,84,2],[85,1,85,2],[86,1,86,2],[87,1,87,2],[96,2,96,3],[96,4,97,4],[96,5,96,12],[96,13,96,17],[104,1,104,2],[105,1,105,2],[106,1,106,2],[107,1,107,2],[113,1,115,2],[113,3,113,18],[114,3,115,3],[114,4,115,4],[114,5,114,12],[114,13,114,17],[114,18,115,18],[116,1,116,2],[116,3,116,18],[117,1,117,2],[118,1,118,2],[119,1,119,2],[120,1,120,2],[121,1,122,1],[123,1,123,2],[124,1,124,2],[124,3,124,18],[125,1,125,2],[126,1,126,2],[127,1,127,2],[128,1,128,2],[129,1,129,2],[129,3,129,18],[130,1,130,2],[131,1,131,2],[131,3,131,18],[132,1,132,2],[132,3,134,17],[133,1,133,2],[134,1,134,2],[135,1,135,2],[141,1,142,17]]}
["Emission Inventory",{"$nulls":17},"y HOME"]
[]
[]
[]
[]
["Monitoring Emission Inventory"]
["i Copy as many \"MEI\" tabs for Monitoring Emission Inventories as necessary."]
[]
["1)","Inventory year",null,"[drop-down]"]
[]
[]
["2)","Number of inhabitants in the inventory year"]
[]
[]
["3)","Emission factors ",null,null,"  IPCC"]
[{"$nulls":4},"  LCA (Life Cycle Assessment)"]
[]
[]
["4)","Emission reporting unit",null,null,"  tonnes CO2 "]
[{"$nulls":4},"  tonnes CO2 equivalent"]
[]
[]
["5) ","Methodological notes",null,{"$f":"BEI!D22","v":""}]
[]
[{"$nulls":19},{"$f":"CONCATENATE(TEXT(1000-LEN(D23),\"#\"),\" chars left\")","v":"1000 chars left"}]
[]
[]
[null,"A. Final energy consumption"]
[]
[null,"i Please note that for separating decimals dot [.] is used. No thousand separators are allowed."]
[null,"Sector",null,"FINAL ENERGY CONSUMPTION [MWh]"]
[{"$nulls":3},"Electricity","Heat/cold","Fossil fuels",{"$nulls":7},"Renewable energies",{"$nulls":4},"Total"]
[{"$nulls":5},"Natural gas","Liquid gas","Heating oil","Diesel","Gasoline","Lignite","Coal","Other fossil fuels","Plant oil","Biofuel ","Other biomass","Solar thermal","Geothermal"]
[null,"BUILDINGS, EQUIPMENT/FACILITIES AND INDUSTRIES",null," "]
[null,"Municipal buildings, equipment/facilities",{"$nulls":16},{"$f":"SUM(D35:R35)","v":0}]
[null,"Tertiary (non municipal) buildings, equipment/facilities",{"$nulls":16},0]
[null,"Residential buildings",{"$nulls":16},0]
[null,"Public lighting",{"$nulls":16},0]
[null,"Industry","Non-ETS",{"$nulls":15},0]
[null,null,"ETS (not recommended)",{"$nulls":15},0]
[null,"Subtotal ",null,{"$f":"SUM(D35:D40)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"TRANSPORT"]
[null,"Municipal fleet",{"$nulls":16},{"$f":"SUM(D43:R43)","v":0}]
[null,"Public transport ",{"$nulls":16},0]
[null,"Private and commercial transport  ",{"$nulls":16},0]
[null,"Subtotal ",null,{"$f":"SUM(D43:D45)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"OTHER  "]
[null,"Agriculture, Forestry, Fisheries",{"$nulls":16},{"$f":"SUM(D48:R48)","v":0}]
[null,"TOTAL",null,{"$f":"SUM(D41,D46,D48)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,"Covenant Key Sectors"]
[]
[]
[null,"B. Energy supply"]
[null,"i Hide sections or rows as appropriate to your emission inventory."]
[]
[null,"B1. Municipal purchases of certified green electricity"]
[]
[null,"Municipal purchases of certified green electricity",null,"Renewable electricity purchased [MWh]","CO2 / CO2 eq. Emission factor [t/MWh]"]
[null,"Certified green electricity purchased"]
[]
[null,"B2. Local/distributed electricity production (Renewable energy only)"]
[]
[null,"Local renewable electricity plants                                            (ETS and large-scale plants > 20 MWe not recommended)",null,"Renewable electricity produced [MWh]","Emission factor [t/MWh produced]","CO2 / CO2 eq. emissions [t]"]
[null,"Wind ",{"$nulls":3},{"$f":"D65*E65","v":0}]
[null,"Hydroelectric",{"$nulls":3},0]
[null,"Photovoltaics",{"$nulls":3},0]
[null,"Geothermal",{"$nulls":3},0]
[null,"TOTAL",null,{"$f":"SUM(D65:D68)","v":0},null,{"$f":"SUM(F65:F68)","v":0}]
[]
[null,"B3. Local/distributed electricity production"]
[]
[null,"Local electricity production plants                                         (ETS and large-scale plants > 20 MW not recommended)",null,"Electricity produced [MWh]",null,"  Energy carrier input [MWh]",{"$nulls":9},"CO2 / CO2 eq. emissions [t]"]
[{"$nulls":5},"Fossil fuels",{"$nulls":4},"Waste","Plant oil","Other biomass","Other renewable","Other"]
[{"$nulls":3},"from renewable sources","from non-renewable sources","Natural gas","Liquid gas","Heating oil","Lignite","Coal",{"$nulls":5},"Fossil sources","Renewable sources"]
[null,"Combined Heat and Power "]
[null,"Other"]
[null,"TOTAL",null,{"$f":"SUM(D76:D77)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,"B4. Local heat/cold production"]
[]
[null,"Local heat/cold production plants",null,"Heat/cold produced [MWh]",null,"  Energy carrier input [MWh]",{"$nulls":9},"CO2 / CO2 eq. emissions [t]"]
[{"$nulls":5},"Fossil fuels",{"$nulls":4},"Waste","Plant oil","Other biomass","Other renewable","Other"]
[{"$nulls":3},"from renewable sources","from non-renewable sources","Natural gas","Liquid gas","Heating oil","Lignite","Coal",{"$nulls":5},"Fossil sources","Renewable sources"]
[null,"Combined Heat and Power "]
[null,"District heating (heat-only) "]
[null,"Other"]
[null,"TOTAL",null,{"$f":"SUM(D85:D87)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[]
[]
[null,"C. CO2 emissions"]
[]
[null,"C1. Please insert the CO2 emission factors adopted [t/MWh]:"]
[]
[{"$nulls":5},"Click here to visualise fuel emission factors"]
[null,null,"Electricity",null,"Heat/cold","Fossil fuels",{"$nulls":7},"Renewable energies"]
[null,null,"National","Local",null,"Natural gas","Liquid gas","Heating oil","Diesel","Gasoline","Lignite","Coal","Other fossil fuels","Plant oil","Biofuel ","Other biomass","Solar thermal","Geothermal"]
[null,"BEI",{"$f":"BEI!C98","v":""},{"$f":"BEI!D98","v":""},{"$f":"BEI!E98","v":""},{"$f":"BEI!F98","v":""},{"$f":"BEI!G98","v":""},{"$f":"BEI!H98","v":""},{"$f":"BEI!I98","v":""},{"$f":"BEI!J98","v":""},{"$f":"BEI!K98","v":""},{"$f":"BEI!L98","v":""},{"$f":"BEI!M98","v":""},{"$f":"BEI!N98","v":""},{"$f":"BEI!O98","v":""},{"$f":"BEI!P98","v":""},{"$f":"BEI!Q98","v":""},{"$f":"BEI!R98","v":""}]
[null,"MEI"]
[]
[]
[null,"C2. Please complete in case non-energy related sectors are included:"]
[]
[null,"Non-energy related sectors",null,"CO2 eq. emissions [t]"]
[null,"Waste management"]
[null,"Waste water management"]
[null,"Other non-energy related"]
[]
[]
[]
[null,"Emission Inventory"]
[]
[null,"Sector",null,"CO2 emissions [t] / CO2 eq. emissions [t]"]
[{"$nulls":3},"Electricity","Heat/cold","Fossil fuels",{"$nulls":7},"Renewable energies",{"$nulls":4},"Total"]
[{"$nulls":5},"Natural gas","Liquid gas","Heating Oil","Diesel","Gasoline","Lignite","Coal","Other fossil fuels","Plant oil","Biofuel ","Other biomass","Solar thermal","Geothermal"]
[null,"BUILDINGS, EQUIPMENT/FACILITIES AND INDUSTRIES",null," "]
[null,"Municipal buildings, equipment/facilities",null,{"$f":"D35*D$100","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(D118:R118)","v":0}]
[null,"Tertiary (non municipal) buildings, equipment/facilities",null,{"$f":"D36*D$100","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Residential buildings",null,{"$f":"D37*D$100","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Public lighting",null,{"$f":"D38*D$100","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Industry","Non-ETS",{"$f":"D39*D$100","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"ETS (not recommended)",{"$f":"D40*D$100","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Subtotal",null,{"$f":"D41*D$100","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"TRANSPORT"]
[null,"Municipal fleet",null,{"$f":"D43*D$100","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(D126:R126)","v":0}]
[null,"Public transport ",null,{"$f":"D44*D$100","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Private and commercial transport  ",null,{"$f":"D45*D$100","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Subtotal",null,{"$f":"D46*D$100","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"OTHER "]
[null,"Agriculture, Forestry, Fisheries",null,{"$f":"D48*D$100","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(D131:R131)","v":0}]
[null,"OTHER NON-ENERGY RELATED"]
[null,"Waste management",{"$nulls":16},{"$f":"D106","v":""}]
[null,"Waste water management",{"$nulls":16},""]
[null,"Other non-energy related",{"$nulls":16},""]
[null,"TOTAL",null,{"$f":"SUM(D124,D129,D131)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(S124,S129,S131,S133,S134,S135)","v":0}]
[]
[null,"Covenant Key Sectors"]
[]
[]
[null,"Additional comments"]
[null,{"$f":"BEI!B140","v":""}]
[{"$nulls":18},{"$f":"CONCATENATE(TEXT(500-LEN(B142),\"#\"),\" chars left\")","v":"500 chars left"}]
[]
[{"$nulls":16},"BACK Û","Ü MEI2","Ü ACTIONS"]

{"sheet":"MEI2","index":4,"n_rows":145,"n_cols":20,"rows_kept":145,"merged":[[0,0,0,13],[22,1,24,2],[22,3,24,18],[27,1,27,2],[30,1,32,2],[30,3,30,18],[31,3,32,3],[31,4,32,4],[31,5,31,12],[31,13,31,17],[31,18,32,18],[33,1,33,2],[33,3,33,18],[34,1,34,2],[35,1,35,2],[36,1,36,2],[37,1,37,2],[38,1,39,1],[40,1,40,2],[41,1,41,2],[41,3,41,18],[42,1,42,2],[43,1,43,2],[44,1,44,2],[45,1,45,2],[46,1,46,2],[46,3,46,18],[47,1,47,2],[48,1,48,2],[58,1,58,2],[59,1,59,2],[63,1,63,2],[64,1,64,2],[65,1,65,2],[66,1,66,2],[67,1,67,2],[68,1,68,2],[72,1,74,2],[72,3,73,4],[72,5,72,14],[72,15,73,16],[73,5,73,9],[73,10,74,10],[73,11,74,11],[73,12,74,12],[73,13,74,13],[73,14,74,14],[75,1,75,2],[76,1,76,2],[77,1,77,2],[81,1,83,2],[81,3,82,4],[81,5,81,14],[81,15,82,16],[82,5,82,9],[82,10,83,10],[82,11,83,11],[82,12,83,12],[82,13,83,13],[82,14,83,14],[84,1,84,2],[85,1,85,2],[86,1,86,2],[87,1,87,2],[96,2,96,3],[96,4,97,4],[96,5,96,12],[96,13,96,17],[104,1,104,2],[105,1,105,2],[106,1,106,2],[107,1,107,2],[113,1,115,2],[113,3,113,18],[114,3,115,3],[114,4,115,4],[114,5,114,12],[114,13,114,17],[114,18,115,18],[116,1,116,2],[116,3,116,18],[117,1,117,2],[118,1,118,2],[119,1,119,2],[120,1,120,2],[121,1,122,1],[123,1,123,2],[124,1,124,2],[124,3,124,18],[125,1,125,2],[126,1,126,2],[127,1,127,2],[128,1,128,2],[129,1,129,2],[129,3,129,18],[130,1,130,2],[131,1,131,2],[131,3,131,18],[132,1,132,2],[132,3,134,17],[133,1,133,2],[134,1,134,2],[135,1,135,2],[141,1,142,17]]}
["Emission Inventory",{"$nulls":17},"y HOME"]
[]
[]
[]
[]
["Monitoring Emission Inventory"]
["i Copy as many \"MEI\" tabs for Monitoring Emission Inventories as necessary."]
[]
["1)","Inventory year",null,"[drop-down]"]
[]
[]
["2)","Number of inhabitants in the inventory year"]
[]
[]
["3)","Emission factors ",null,null,"  IPCC"]
[{"$nulls":4},"  LCA (Life Cycle Assessment)"]
[]
[]
["4)","Emission reporting unit",null,null,"  tonnes CO2 "]
[{"$nulls":4},"  tonnes CO2 equivalent"]
[]
[]
["5) ","Methodological notes",null,{"$f":"'MEI1'!D23:S25","v":"#VALUE!"}]
[]
[{"$nulls":19},{"$f":"CONCATENATE(TEXT(1000-LEN(D23),\"#\"),\" chars left\")","v":"#VALUE!"}]
[]
[]
[null,"A. Final energy consumption"]
[]
[null,"i Please note that for separating decimals dot [.] is used. No thousand separators are allowed."]
[null,"Sector",null,"FINAL ENERGY CONSUMPTION [MWh]"]
[{"$nulls":3},"Electricity","Heat/cold","Fossil fuels",{"$nulls":7},"Renewable energies",{"$nulls":4},"Total"]
[{"$nulls":5},"Natural gas","Liquid gas","Heating oil","Diesel","Gasoline","Lignite","Coal","Other fossil fuels","Plant oil","Biofuel ","Other biomass","Solar thermal","Geothermal"]
[null,"BUILDINGS, EQUIPMENT/FACILITIES AND INDUSTRIES",null," "]
[null,"Municipal buildings, equipment/facilities",{"$nulls":16},{"$f":"SUM(D35:R35)","v":0}]
[null,"Tertiary (non municipal) buildings, equipment/facilities",{"$nulls":16},0]
[null,"Residential buildings",{"$nulls":16},0]
[null,"Public lighting",{"$nulls":16},0]
[null,"Industry","Non-ETS",{"$nulls":15},0]
[null,null,"ETS (not recommended)",{"$nulls":15},0]
[null,"Subtotal ",null,{"$f":"SUM(D35:D40)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"TRANSPORT"]
[null,"Municipal fleet",{"$nulls":16},{"$f":"SUM(D43:R43)","v":0}]
[null,"Public transport ",{"$nulls":16},0]
[null,"Private and commercial transport  ",{"$nulls":16},0]
[null,"Subtotal ",null,{"$f":"SUM(D43:D45)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"OTHER  "]
[null,"Agriculture, Forestry, Fisheries",{"$nulls":16},{"$f":"SUM(D48:R48)","v":0}]
[null,"TOTAL",null,{"$f":"SUM(D41,D46,D48)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,"Covenant Key Sectors"]
[]
[]
[null,"B. Energy supply"]
[null,"i Hide sections or rows as appropriate to your emission inventory."]
[]
[null,"B1. Municipal purchases of certified green electricity"]
[]
[null,"Municipal purchases of certified green electricity",null,"Renewable electricity purchased [MWh]","CO2 / CO2 eq. Emission factor [t/MWh]"]
[null,"Certified green electricity purchased"]
[]
[null,"B2. Local/distributed electricity production (Renewable energy only)"]
[]
[null,"Local renewable electricity plants                                            (ETS and large-scale plants > 20 MWe not recommended)",null,"Renewable electricity produced [MWh]","Emission factor [t/MWh produced]","CO2 / CO2 eq. emissions [t]"]
[null,"Wind ",{"$nulls":3},{"$f":"D65*E65","v":0}]
[null,"Hydroelectric",{"$nulls":3},0]
[null,"Photovoltaics",{"$nulls":3},0]
[null,"Geothermal",{"$nulls":3},0]
[null,"TOTAL",null,{"$f":"SUM(D65:D68)","v":0},null,{"$f":"SUM(F65:F68)","v":0}]
[]
[null,"B3. Local/distributed electricity production"]
[]
[null,"Local electricity production plants                                         (ETS and large-scale plants > 20 MW not recommended)",null,"Electricity produced [MWh]",null,"  Energy carrier input [MWh]",{"$nulls":9},"CO2 / CO2 eq. emissions [t]"]
[{"$nulls":5},"Fossil fuels",{"$nulls":4},"Waste","Plant oil","Other biomass","Other renewable","Other"]
[{"$nulls":3},"from renewable sources","from non-renewable sources","Natural gas","Liquid gas","Heating oil","Lignite","Coal",{"$nulls":5},"Fossil sources","Renewable sources"]
[null,"Combined Heat and Power "]
[null,"Other"]
[null,"TOTAL",null,{"$f":"SUM(D76:D77)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,"B4. Local heat/cold production"]
[]
[null,"Local heat/cold production plants",null,"Heat/cold produced [MWh]",null,"  Energy carrier input [MWh]",{"$nulls":9},"CO2 / CO2 eq. emissions [t]"]
[{"$nulls":5},"Fossil fuels",{"$nulls":4},"Waste","Plant oil","Other biomass","Other renewable","Other"]
[{"$nulls":3},"from renewable sources","from non-renewable sources","Natural gas","Liquid gas","Heating oil","Lignite","Coal",{"$nulls":5},"Fossil sources","Renewable sources"]
[null,"Combined Heat and Power "]
[null,"District heating (heat-only) "]
[null,"Other"]
[null,"TOTAL",null,{"$f":"SUM(D85:D87)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[]
[]
[null,"C. CO2 emissions"]
[]
[null,"C1. Please insert the CO2 emission factors adopted [t/MWh]:"]
[]
[{"$nulls":5},"Click here to visualise fuel emission factors"]
[null,null,"Electricity",null,"Heat/cold","Fossil fuels",{"$nulls":7},"Renewable energies"]
[null,null,"National","Local",null,"Natural gas","Liquid gas","Heating oil","Diesel","Gasoline","Lignite","Coal","Other fossil fuels","Plant oil","Biofuel ","Other biomass","Solar thermal","Geothermal"]
[null,"BEI",{"$f":"BEI!C98","v":""},{"$f":"BEI!D98","v":""},{"$f":"BEI!E98","v":""},{"$f":"BEI!F98","v":""},{"$f":"BEI!G98","v":""},{"$f":"BEI!H98","v":""},{"$f":"BEI!I98","v":""},{"$f":"BEI!J98","v":""},{"$f":"BEI!K98","v":""},{"$f":"BEI!L98","v":""},{"$f":"BEI!M98","v":""},{"$f":"BEI!N98","v":""},{"$f":"BEI!O98","v":""},{"$f":"BEI!P98","v":""},{"$f":"BEI!Q98","v":""},{"$f":"BEI!R98","v":""}]
[null,"MEI"]
[]
[]
[null,"C2. Please complete in case non-energy related sectors are included:"]
[]
[null,"Non-energy related sectors",null,"CO2 eq. emissions [t]"]
[null,"Waste management"]
[null,"Waste water management"]
[null,"Other non-energy related"]
[]
[]
[]
[null,"Emission Inventory"]
[]
[null,"Sector",null,"CO2 emissions [t] / CO2 eq. emissions [t]"]
[{"$nulls":3},"Electricity","Heat/cold","Fossil fuels",{"$nulls":7},"Renewable energies",{"$nulls":4},"Total"]
[{"$nulls":5},"Natural gas","Liquid gas","Heating Oil","Diesel","Gasoline","Lignite","Coal","Other fossil fuels","Plant oil","Biofuel ","Other biomass","Solar thermal","Geothermal"]
[null,"BUILDINGS, EQUIPMENT/FACILITIES AND INDUSTRIES",null," "]
[null,"Municipal buildings, equipment/facilities",null,{"$f":"D35*D$100","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(D118:R118)","v":0}]
[null,"Tertiary (non municipal) buildings, equipment/facilities",null,{"$f":"D36*D$100","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Residential buildings",null,{"$f":"D37*D$100","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Public lighting",null,{"$f":"D38*D$100","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Industry","Non-ETS",{"$f":"D39*D$100","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"ETS (not recommended)",{"$f":"D40*D$100","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Subtotal",null,{"$f":"D41*D$100","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"TRANSPORT"]
[null,"Municipal fleet",null,{"$f":"D43*D$100","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(D126:R126)","v":0}]
[null,"Public transport ",null,{"$f":"D44*D$100","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Private and commercial transport  ",null,{"$f":"D45*D$100","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Subtotal",null,{"$f":"D46*D$100","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"OTHER "]
[null,"Agriculture, Forestry, Fisheries",null,{"$f":"D48*D$100","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(D131:R131)","v":0}]
[null,"OTHER NON-ENERGY RELATED"]
[null,"Waste management",{"$nulls":16},{"$f":"D106","v":""}]
[null,"Waste water management",{"$nulls":16},""]
[null,"Other non-energy related",{"$nulls":16},""]
[null,"TOTAL",null,{"$f":"SUM(D124,D129,D131)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(S124,S129,S131,S133,S134,S135)","v":0}]
[]
[null,"Covenant Key Sectors"]
[]
[]
[null,"Additional comments"]
[null,{"$f":"'MEI1'!B142","v":""}]
[{"$nulls":18},{"$f":"CONCATENATE(TEXT(500-LEN(B142),\"#\"),\" chars left\")","v":"500 chars left"}]
[]
[{"$nulls":17},"BACK Û","Ü NEXT"]

{"sheet":"Mitigation Actions","index":5,"n_rows":121,"n_cols":39,"rows_kept":121,"merged":[[0,0,0,23],[7,2,7,7],[13,2,13,7],[16,2,16,7],[19,9,19,11],[19,12,19,13],[19,14,19,16],[19,17,19,19],[19,20,19,21],[20,9,20,11],[20,12,20,13],[20,14,20,16],[20,17,20,19],[20,20,20,21],[21,9,21,11],[21,12,21,13],[21,14,21,16],[21,17,21,19],[21,20,21,21],[23,9,23,11],[23,12,23,13],[23,14,23,16],[23,17,23,19],[23,20,23,21],[24,9,24,11],[24,12,24,13],[24,14,24,16],[24,17,24,19],[24,20,24,21],[25,9,25,11],[25,12,25,13],[25,14,25,16],[25,17,25,19],[25,20,25,21],[27,9,27,11],[27,12,27,13],[27,14,27,16],[27,17,27,19],[27,20,27,21],[28,9,28,11],[28,12,28,13],[28,14,28,16],[28,17,28,19],[28,20,28,21],[29,9,29,11],[29,12,29,13],[29,14,29,16],[29,17,29,19],[29,20,29,21],[33,2,35,21],[38,2,38,4],[40,2,40,4],[42,2,42,4],[45,2,45,5],[48,21,48,23],[48,25,48,27],[48,29,48,31],[49,1,51,1],[49,2,51,4],[49,5,51,6],[49,7,51,7],[49,8,51,8],[49,9,50,10],[49,13,51,13],[49,16,50,16],[49,19,50,19],[49,21,49,23],[49,25,49,27],[49,29,49,31],[49,33,50,33],[49,35,51,35],[52,1,52,10],[53,2,53,4],[53,5,53,6],[54,2,54,4],[54,5,54,6],[55,2,55,4],[55,5,55,6],[56,2,56,4],[56,5,56,6],[57,2,57,4],[57,5,57,6],[58,1,58,10],[59,1,59,10],[60,2,60,4],[60,5,60,6],[61,2,61,4],[61,5,61,6],[62,2,62,4],[62,5,62,6],[63,2,63,4],[63,5,63,6],[64,2,64,4],[64,5,64,6],[65,1,65,10],[66,1,66,10],[67,2,67,4],[67,5,67,6],[68,2,68,4],[68,5,68,6],[69,2,69,4],[69,5,69,6],[70,2,70,4],[70,5,70,6],[71,2,71,4],[71,5,71,6],[72,1,72,10],[73,1,73,10],[74,2,74,4],[74,5,74,6],[75,2,75,4],[75,5,75,6],[76,2,76,4],[76,5,76,6],[77,2,77,4],[77,5,77,6],[78,2,78,4],[78,5,78,6],[79,1,79,10],[80,1,80,10],[81,2,81,4],[81,5,81,6],[82,2,82,4],[82,5,82,6],[83,2,83,4],[83,5,83,6],[84,2,84,4],[84,5,84,6],[85,2,85,4],[85,5,85,6],[86,1,86,10],[87,1,87,10],[88,2,88,4],[88,5,88,6],[89,2,89,4],[89,5,89,6],[90,2,90,4],[90,5,90,6],[91,2,91,4],[91,5,91,6],[92,2,92,4],[92,5,92,6],[93,1,93,10],[94,1,94,10],[95,2,95,4],[95,5,95,6],[96,2,96,4],[96,5,96,6],[97,2,97,4],[97,5,97,6],[98,2,98,4],[98,5,98,6],[99,2,99,4],[99,5,99,6],[100,1,100,10],[101,1,101,10],[102,2,102,4],[102,5,102,6],[103,2,103,4],[103,5,103,6],[104,2,104,4],[104,5,104,6],[105,2,105,4],[105,5,105,6],[106,2,106,4],[106,5,106,6],[107,1,107,10],[108,1,108,10],[109,2,109,4],[109,5,109,6],[110,2,110,4],[110,5,110,6],[111,2,111,4],[111,5,111,6],[112,2,112,4],[112,5,112,6],[113,2,113,4],[113,5,113,6],[114,1,114,10],[115,1,115,10]]}
["Mitigation Actions",{"$nulls":34},"y HOME"]
[]
[]
[]
[]
["Action Plan"]
[]
["1)","Title"]
[]
[]
["2)","Date of formal approval"]
[]
[]
["3) ","Decision body approving the plan "]
[]
[]
["4) ","SECAP webpage"]
[]
[]
[{"$nulls":6},"Overall",null,"Municipal","Residential",null,null,"Tertiary",null,"Industry",null,null,"Transport",null,null,"Others"]
["5) ","Business-as-Usual projections by 2020 (if applicable)","CO2 emissions ( t CO2 (eq.)/a )",{"$nulls":3},{"$f":"SUM(I21:V21)","v":0}]
[null,null,"Final energy consumption (MWh/a)",{"$nulls":3},0]
[]
[{"$nulls":8},"Municipal","Residential",null,null,"Tertiary",null,"Industry",null,null,"Transport",null,null,"Others"]
[null,"Business-as-Usual projections by 2030 (if applicable)","CO2 emissions ( t CO2 (eq.)/a )",{"$nulls":3},{"$f":"SUM(I25:V25)","v":0}]
[null,null,"Final energy consumption (MWh/a)",{"$nulls":3},0]
[]
[{"$nulls":8},"Municipal","Residential",null,null,"Tertiary",null,"Industry",null,null,"Transport",null,null,"Others"]
[null,"Business-as-Usual projections by long-term target year (if applicable)","CO2 emissions ( t CO2 (eq.)/a )",{"$nulls":3},{"$f":"SUM(I29:V29)","v":0}]
[null,null,"Final energy consumption (MWh/a)",{"$nulls":3},0]
[]
[null,"i Hide rows as appropriate to the time horizon(s) of your action plan."]
[]
["6)","Methodological notes"]
[]
[{"$nulls":22},{"$f":"CONCATENATE(TEXT(500-LEN(C34),\"#\"),\" chars left\")","v":"500 chars left"}]
[]
[]
["7) ","Estimates of the impacts of actions in 2020 in relation to:","BEI (option 1)"]
[]
[null,"Estimates of the impacts of actions in 2030 in relation to:","BEI (option 1)"]
[]
[null,"Estimates of the impacts of actions in long-term target year in relation to:","BEI (option 1)"]
[]
[null,"i Hide rows as appropriate to the time horizon(s) of your action plan."]
[]
["Key Actions"]
[null,"i Please start by providing your totals by sector and add your key actions afterwards."]
[null,"i Add as many rows for your key actions as necessary.",{"$nulls":14},"MONITORING",{"$nulls":4},"i Hide as appropriate to the time horizon(s) of your action plan",{"$nulls":3},"i Hide as appropriate to the time horizon(s) of your action plan",{"$nulls":3},"i Hide as appropriate to the time horizon(s) of your action plan"]
[null,"Key Actions","Area of intervention",null,null,"Policy instrument",null,"Origin of the action","Responsible body","Implementation timeframe",{"$nulls":3},"Status of implementation",null,null,"Implementation cost spent so far",null,null,"Implementation cost",null,"Estimates in 2020",{"$nulls":3},"Estimates in 2030",{"$nulls":3},"Estimates in long-term target year",{"$nulls":3},"Benchmark of Excellence",null,"Action also affecting adaptation"]
[{"$nulls":21},"Energy savings","Renewable energy production","CO2 reduction",null,"Energy savings","Renewable energy production","CO2 reduction",null,"Energy savings","Renewable energy production","CO2 reduction"]
[{"$nulls":9},"Start","End",{"$nulls":5},"€",null,null,"€",null,"MWh/a","MWh/a","t CO2/a",null,"MWh/a","MWh/a","t CO2/a",null,"MWh/a","MWh/a","t CO2/a",null,"ê"]
[null,"MUNICIPAL BUILDINGS, EQUIPMENT/FACILITIES"]
[{"$nulls":33},"ê",null,"[Select x]"]
[{"$nulls":35},"[Select x]"]
[{"$nulls":35},"[Select x]"]
[{"$nulls":35},"[Select x]"]
[{"$nulls":35},"[Select x]"]
[null,"Estimated reduction not associated with any reported actions",{"$nulls":14},{"$f":"Q53-SUM(Q54:Q58)","v":0},null,null,{"$f":"T53-SUM(T54:T58)","v":0},null,{"$f":"V53-SUM(V54:V58)","v":0},0,0,null,{"$f":"Z53-SUM(Z54:Z58)","v":0},0,0,null,{"$f":"AD53-SUM(AD54:AD58)","v":0},0,0]
[null,"TERTIARY BUILDINGS, EQUIPMENT/FACILITIES"]
[{"$nulls":35},"[Select x]"]
[{"$nulls":35},"[Select x]"]
[{"$nulls":35},"[Select x]"]
[{"$nulls":35},"[Select x]"]
[{"$nulls":35},"[Select x]"]
[null,"Estimated reduction not associated with any reported actions",{"$nulls":14},{"$f":"Q60-SUM(Q61:Q65)","v":0},null,null,{"$f":"T60-SUM(T61:T65)","v":0},null,{"$f":"V60-SUM(V61:V65)","v":0},0,0,null,{"$f":"Z60-SUM(Z61:Z65)","v":0},0,0,null,{"$f":"AD60-SUM(AD61:AD65)","v":0},0,0]
[null,"RESIDENTIAL BUILDINGS"]
[{"$nulls":35},"[Select x]"]
[{"$nulls":35},"[Select x]"]
[{"$nulls":35},"[Select x]"]
[{"$nulls":35},"[Select x]"]
[{"$nulls":35},"[Select x]"]
[null,"Estimated reduction not associated with any reported actions",{"$nulls":14},{"$f":"Q67-SUM(Q68:Q72)","v":0},null,null,{"$f":"T67-SUM(T68:T72)","v":0},null,{"$f":"V67-SUM(V68:V72)","v":0},0,0,null,{"$f":"Z67-SUM(Z68:Z72)","v":0},0,0,null,{"$f":"AD67-SUM(AD68:AD72)","v":0},0,0]
[null,"PUBLIC LIGHTING"]
[{"$nulls":35},"[Select x]"]
[{"$nulls":35},"[Select x]"]
[{"$nulls":35},"[Select x]"]
[{"$nulls":35},"[Select x]"]
[{"$nulls":35},"[Select x]"]
[null,"Estimated reduction not associated with any reported actions",{"$nulls":14},{"$f":"Q74-SUM(Q75:Q79)","v":0},null,null,{"$f":"T74-SUM(T75:T79)","v":0},null,{"$f":"V74-SUM(V75:V79)","v":0},0,0,null,{"$f":"Z74-SUM(Z75:Z79)","v":0},0,0,null,{"$f":"AD74-SUM(AD75:AD79)","v":0},0,0]
[null,"INDUSTRY"]
[{"$nulls":35},"[Select x]"]
[{"$nulls":35},"[Select x]"]
[{"$nulls":35},"[Select x]"]
[{"$nulls":35},"[Select x]"]
[{"$nulls":35},"[Select x]"]
[null,"Estimated reduction not associated with any reported actions",{"$nulls":14},{"$f":"Q81-SUM(Q82:Q86)","v":0},null,null,{"$f":"T81-SUM(T82:T86)","v":0},null,{"$f":"V81-SUM(V82:V86)","v":0},0,0,null,{"$f":"Z81-SUM(Z82:Z86)","v":0},0,0,null,{"$f":"AD81-SUM(AD82:AD86)","v":0},0,0]
[null,"TRANSPORT"]
[{"$nulls":35},"[Select x]"]
[{"$nulls":35},"[Select x]"]
[{"$nulls":35},"[Select x]"]
[{"$nulls":35},"[Select x]"]
[{"$nulls":35},"[Select x]"]
[null,"Estimated reduction not associated with any reported actions",{"$nulls":14},{"$f":"Q88-SUM(Q89:Q93)","v":0},null,null,{"$f":"T88-SUM(T89:T93)","v":0},null,{"$f":"V88-SUM(V89:V93)","v":0},0,0,null,{"$f":"Z88-SUM(Z89:Z93)","v":0},0,0,null,{"$f":"AD88-SUM(AD89:AD93)","v":0},0,0]
[null,"LOCAL ELECTRICITY PRODUCTION"]
[{"$nulls":35},"[Select x]"]
[{"$nulls":35},"[Select x]"]
[{"$nulls":35},"[Select x]"]
[{"$nulls":35},"[Select x]"]
[{"$nulls":35},"[Select x]"]
[null,"Estimated reduction not associated with any reported actions",{"$nulls":14},{"$f":"Q95-SUM(Q96:Q100)","v":0},null,null,{"$f":"T95-SUM(T96:T100)","v":0},null,{"$f":"V95-SUM(V96:V100)","v":0},0,0,null,{"$f":"Z95-SUM(Z96:Z100)","v":0},0,0,null,{"$f":"AD95-SUM(AD96:AD100)","v":0},0,0]
[null,"LOCAL HEAT/COLD PRODUCTION"]
[{"$nulls":35},"[Select x]"]
[{"$nulls":35},"[Select x]"]
[{"$nulls":35},"[Select x]"]
[{"$nulls":35},"[Select x]"]
[{"$nulls":35},"[Select x]"]
[null,"Estimated reduction not associated with any reported actions",{"$nulls":14},{"$f":"Q102-SUM(Q103:Q107)","v":0},null,null,{"$f":"T102-SUM(T103:T107)","v":0},null,{"$f":"V102-SUM(V103:V107)","v":0},0,0,null,{"$f":"Z102-SUM(Z103:Z107)","v":0},0,0,null,{"$f":"AD102-SUM(AD103:AD107)","v":0},0,0]
[null,"OTHERS"]
[{"$nulls":35},"[Select x]"]
[{"$nulls":35},"[Select x]"]
[{"$nulls":35},"[Select x]"]
[{"$nulls":35},"[Select x]"]
[{"$nulls":35},"[Select x]"]
[null,"Estimated reduction not associated with any reported actions",{"$nulls":14},{"$f":"Q109-SUM(Q110:Q114)","v":0},null,null,{"$f":"T109-SUM(T110:T114)","v":0},null,{"$f":"V109-SUM(V110:V114)","v":0},0,0,null,{"$f":"Z109-SUM(Z110:Z114)","v":0},0,0,null,{"$f":"AD109-SUM(AD110:AD114)","v":0},0,0]
[null,"TOTAL",{"$nulls":14},{"$f":"SUM(Q53,Q60,Q67,Q74,Q81,Q88,Q95,Q102,Q109)","v":0},null,null,{"$f":"SUM(T53,T60,T67,T74,T81,T88,T95,T102,T109)","v":0},null,{"$f":"SUM(V53,V60,V67,V74,V81,V88,V95,V102,V109)","v":0},0,0,null,{"$f":"SUM(Z53,Z60,Z67,Z74,Z81,Z88,Z95,Z102,Z109)","v":0},0,0,null,{"$f":"SUM(AD53,AD60,AD67,AD74,AD81,AD88,AD95,AD102,AD109)","v":0},0,0]
[]
[]
[]
[]
[{"$nulls":37},"BACK Û","Ü NEXT"]

{"sheet":"BoE","index":6,"n_rows":93,"n_cols":39,"rows_kept":93,"merged":[[0,0,0,3],[8,1,8,6],[11,1,11,6],[14,1,14,2],[17,1,17,6],[20,1,20,6],[23,1,23,6],[26,1,26,6],[29,1,29,14],[44,1,44,6],[47,1,47,6],[61,1,61,2]]}
["Benchmarks of Excellence",{"$nulls":17},"y HOME"]
[]
[]
[]
[]
["Benchmark of Excellence form"]
["i Copy as many \"BoE\" tabs for Key Actions as necessary."]
[]
["Key action"]
[]
[]
["Title of the Benchmark of Excellence"]
[]
[]
["Language"]
[]
[]
["Sector"]
[]
[]
["Area of intervention"]
[]
[]
["Policy instrument"]
[]
[]
["Responsible body"]
[]
[]
["Description",{"$nulls":14},{"$f":"CONCATENATE(TEXT(900-LEN(B30),\"#\"),\" chars left\")","v":"900 chars left"}]
[]
[]
["Implementation timeframe"]
[]
[]
["Financing sources","Local authority's own resources",null,null,"[select x]"]
[null,"National Funds & Programmes",null,null,"[select x]"]
[null,"EU Funds & Programmes",null,null,"[select x]"]
[null,"Private Partnerships",null,null,"[select x]"]
[null,"Other",null,null,"[select x]"]
[null,"Public-Private Partnerships",null,null,"[select x]"]
[{"$nulls":4},"i Select x for the ones that are applicable."]
[]
[]
["Website"]
[]
[]
["Video link"]
[]
["Key energy and financial figures"]
[]
["CO2 reduction [t/a]"]
[]
["Energy savings [MWh/a]"]
[]
["Renewable energy produced [MWh/a]"]
[]
["Implementation cost [€]"]
[]
["Jobs created [number]"]
[]
["Other figures","Please specify",null,null,"Unit"]
[]
["i In order to visualise the outcome of the table below and to make a financial assessment of the results achieved/forecasted by measure you will need to fill in all the relevant white cells related to the year of investment."]
["Life expectancy of the action [years]"]
["Discount rate applied [%]"]
["First year of investment",null,null,{"$f":"C67","v":""},{"$f":"IF(D67=\"-\",\"-\",IF(D67-$C$67<$C$65,D67+1,\"-\"))","v":"-"},"-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-"]
["                 ",null,null,0,{"$f":"IF(E67=\"-\",\"-\",E67-$C$67)","v":"-"},"-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-"]
["Financial savings (F)",null,{"$f":"SUM(D69:I69)","v":0}]
["Investment costs",null,{"$f":"SUM(D70:AI70)","v":0}]
["Additional costs",null,{"$f":"SUM(D71:AM71)","v":0}]
["Net cash flow  ",null,{"$f":"SUM(D72:AH72)","v":0},{"$f":"IF(D68>$C$65,0,SUM(D69:D71))","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Cumulative cash flow",null,null,{"$f":"IF(D68>$C$65,0,C73+D72)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Discounted cash flow",null,null,{"$f":"IF(D68>$C$65,0,PV($C$66,D68, ,-D72))","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Cumulative discounted cash flow",null,null,{"$f":"IF(D68>$C$65,0,C75+D74)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":3},{"$f":"IF(SUM(D70:D71)<>\"-\",-SUM(D70:D71),\"\")","v":0},{"$f":"-SUM(E70:E71)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[]
[]
[{"$nulls":4},"Year",null,"(Months)"]
[null,null,"Payback period",null,{"$f":"IF(C72<0,\"-\",IF(C72=0,COUNTIF(D73:AM73,\"<\"&0),COUNTIF(D73:AM73,\"<\"&0)-1))","v":0},{"$f":"IF(C72<0,\"-\",IF(C72=0,0,IF(E81<=16,CONCATENATE(IF(E81=0,-D73/E72,\"\"),IF(E81=1,-E73/F72,\"\"),IF(E81=2,-F73/G72,\"\"),IF(E81=3,-G73/H72,\"\"),IF(E81=4,-H73/I72,\"\"),IF(E81=5,-I73/J72,\"\"),IF(E81=6,-J73/K72,\"\"),IF(E81=7,-K73/L72,\"\"),IF(E81=8,-L73/M72,\"\"),IF(E81=9,-M73/N72,\"\"),IF(E81=10,-N73/O72,\"\"),IF(E81=11,-O73/P72,\"\"),IF(E81=12,-P73/Q72,\"\"),IF(E81=13,-Q73/R72,\"\"),IF(E81=14,-R73/S72,\"\"),IF(E81=15,-S73/T72,\"\"),IF(E81=16,-T73/U72,\"\")),IF(E81<=32,CONCATENATE(IF(E81=17,-U73/V72,\"\"),IF(E81=18,-V73/W72,\"\"),IF(E81=19,-W73/X72,\"\"),IF(E81=20,-X73/Y72,\"\"),IF(E81=21,-Y73/Z72,\"\"),IF(E81=22,-Z73/AA72,\"\"),IF(E81=23,-AA73/AB72,\"\"),IF(E81=24,-AB73/AC72,\"\"),IF(E81=25,-AC73/AD72,\"\"),IF(E81=26,-AD73/AE72,\"\"),IF(E81=27,-AE73/AF72,\"\"),IF(E81=28,-AF73/AG72,\"\"),IF(E81=29,-AG73/AH72,\"\"),IF(E81=30,-AH73/AI72,\"\"),IF(E81=31,-AI73/AJ72,\"\"),IF(E81=32,-AJ73/AK72,\"\")),CONCATENATE(IF(E81=33,-AK73/AL72,\"\"),IF(E81=34,-AL73/AM72,\"\"))))))","v":{"v":0,"d":"0.00"}},{"$f":"IF(F81<>\"-\",F81*12,\"-\")","v":0},{"$f":"IF(E81<>\"-\",E81+F81,\"-\")","v":{"v":0,"d":"0.00"}}]
[]
[null,null,"Discounted payback period",null,{"$f":"IF(F72<0,\"-\",IF(F72=0,COUNTIF(D75:AM75,\"<\"&0),COUNTIF(D75:AM75,\"<\"&0)-1))","v":0},{"$f":"IF(F72<0,\"-\",IF(F72=0,0,IF(E83<=16,CONCATENATE(IF(E83=0,-D75/E74,\"\"),IF(E83=1,-E75/F74,\"\"),IF(E83=2,-F75/G74,\"\"),IF(E83=3,-G75/H74,\"\"),IF(E83=4,-H75/I74,\"\"),IF(E83=5,-I75/J74,\"\"),IF(E83=6,-J75/K74,\"\"),IF(E83=7,-K75/L74,\"\"),IF(E83=8,-L75/M74,\"\"),IF(E83=9,-M75/N74,\"\"),IF(E83=10,-N75/O74,\"\"),IF(E83=11,-O75/P74,\"\"),IF(E83=12,-P75/Q74,\"\"),IF(E83=13,-Q75/R74,\"\"),IF(E83=14,-R75/S74,\"\"),IF(E83=15,-S75/T74,\"\"),IF(E83=16,-T75/U74,\"\")),IF(E83<=32,CONCATENATE(IF(E83=17,-U75/V74,\"\"),IF(E83=18,-V75/W74,\"\"),IF(E83=19,-W75/X74,\"\"),IF(E83=20,-X75/Y74,\"\"),IF(E83=21,-Y75/Z74,\"\"),IF(E83=22,-Z75/AA74,\"\"),IF(E83=23,-AA75/AB74,\"\"),IF(E83=24,-AB75/AC74,\"\"),IF(E83=25,-AC75/AD74,\"\"),IF(E83=26,-AD75/AE74,\"\"),IF(E83=27,-AE75/AF74,\"\"),IF(E83=28,-AF75/AG74,\"\"),IF(E83=29,-AG75/AH74,\"\"),IF(E83=30,-AH75/AI74,\"\"),IF(E83=31,-AI75/AJ74,\"\"),IF(E83=32,-AJ75/AK74,\"\")),CONCATENATE(IF(E83=33,-AK75/AL74,\"\"),IF(E83=34,-AL75/AM74,\"\"))))))","v":{"v":0,"d":"0.00"}},{"$f":"IF(F83<>\"-\",F83*12,\"-\")","v":0},{"$f":"IF(E83<>\"-\",E83+F83,\"-\")","v":{"v":0,"d":"0.00"}}]
[]
["PV of Financial savings",null,{"$f":"NPV($C$66,D69:AM69)","v":{"v":0,"d":"€ 0"}}]
["NPV of investment",null,{"$f":"NPV($C$66,D72:AM72)","v":{"v":0,"d":"€ 0"}}]
["Discounted Payback period",null,{"$f":"IF($C$65=E83,\"not reached\",E83)","v":"not reached"},"years",{"$f":"IF($C$65=E83,0,G83)","v":0},"months"]
["Return on Investment (ROI)",null,{"$f":"C86/NPV($C$66,D76:I76)","v":"#DIV/0!"}]
[]
["ESCO involved?","[select x]"]
[]
[]
[{"$nulls":17},"BACK Û","Ü NEXT"]

{"sheet":"Mitigation Report","index":7,"n_rows":158,"n_cols":43,"rows_kept":158,"merged":[[0,0,0,17],[7,0,7,1],[78,1,78,2],[79,1,79,2],[131,24,131,25],[149,1,157,15]]}
["Mitigation Report",{"$nulls":18},"y HOME"]
[]
[]
[]
[]
["Key Results of the Baseline Emission Inventory"]
[]
["Baseline year: ",null,{"$f":"BEI!D8","v":"[drop-down]"}]
[]
["1) Greenhouse gas emissions and final energy consumption per capita "]
[]
[null,"Emission factor","t CO2 (eq.) /capita","MWh/capita"]
[null,null,{"$f":"BEI!S134/BEI!D11","v":"#DIV/0!"},{"$f":"BEI!S48/BEI!D11","v":"#DIV/0!"}]
[]
[]
[]
["2) Greenhouse gas emissions per sector"]
[]
[]
[{"$nulls":24},"Municipal",{"$f":"BEI!S116","v":0}]
[{"$nulls":24},"Tertiary",{"$f":"BEI!S117","v":0}]
[{"$nulls":24},"Residential",{"$f":"BEI!S118","v":0}]
[{"$nulls":24},"Public lighting",{"$f":"BEI!S120","v":0}]
[{"$nulls":24},"Industry",{"$f":"SUM(BEI!S121:S122)","v":0}]
[{"$nulls":24},"Transport",{"$f":"BEI!S127","v":0}]
[{"$nulls":24},"Other",{"$f":"BEI!S129","v":0}]
[{"$nulls":24},"Non-energy related",{"$f":"SUM(BEI!S131:S133)","v":0}]
[]
[{"$nulls":24},"Buildings, equipment/facilities and Industry",{"$f":"BEI!S122","v":0}]
[{"$nulls":24},"Transport ",{"$f":"BEI!S127","v":0}]
[{"$nulls":24},"Other",{"$f":"BEI!S129","v":0}]
[{"$nulls":24},"Non-energy related",{"$f":"SUM(BEI!S131:S133)","v":0}]
[]
[]
[]
[]
["3) Final energy consumption per sector"]
[]
[]
[{"$nulls":24},"Municipal",{"$f":"BEI!S34","v":0}]
[{"$nulls":24},"Tertiary",{"$f":"BEI!S35","v":0}]
[{"$nulls":24},"Residential",{"$f":"BEI!S36","v":0}]
[{"$nulls":24},"Public lighting",{"$f":"BEI!S37","v":0}]
[{"$nulls":24},"Industry",{"$f":"SUM(BEI!S38:S39)","v":0}]
[{"$nulls":24},"Transport",{"$f":"BEI!S45","v":0}]
[{"$nulls":24},"Other",{"$f":"BEI!S47","v":0}]
[]
[]
[{"$nulls":24},"Buildings, equipment/facilities and Industry",{"$f":"BEI!S40","v":0}]
[{"$nulls":24},"Transport ",{"$f":"BEI!S45","v":0}]
[{"$nulls":24},"Other",{"$f":"BEI!S48","v":0}]
[]
[]
[]
[]
["4) Final energy consumption per energy carrier"]
[]
[]
[{"$nulls":24},"Electricity",{"$f":"BEI!D48","v":0}]
[{"$nulls":24},"Heat/cold",{"$f":"BEI!E48","v":0}]
[{"$nulls":24},"Fossil fuels",{"$f":"SUM(BEI!F48:M48)","v":0}]
[{"$nulls":24},"Renewables",{"$f":"SUM(BEI!N48:R48)","v":0}]
{"$rows_empty":9}
["     * Renewables - for non-electricity uses."]
["     ** The energy mix of heat/cold and electricity is not identified."]
[]
[]
[]
["5) Local energy production"]
[]
[null,"Share of local energy production to overall final energy consumption"]
[null,{"$f":"SUM(Z81:Z82,Z85:Z86,Z89)/Z92","v":"#DIV/0!"},{"$nulls":22},"Electricity consumption",{"$f":"Z59","v":0}]
[{"$nulls":24},"Non-RES electricity production",{"$f":"BEI!E77","v":0}]
[{"$nulls":24},"RES electricity production",{"$f":"SUM(BEI!D68,BEI!D77)","v":0}]
[]
[{"$nulls":24},"Heat/cold consumption",{"$f":"Z60","v":0}]
[{"$nulls":24},"RES heat/cold production",{"$f":"BEI!D87","v":0}]
[{"$nulls":24},"Non-RES heat/cold production",{"$f":"BEI!E87","v":0}]
[]
[]
[{"$nulls":24},"Other renewables",{"$f":"SUM(BEI!N48:R48)","v":0}]
[]
[]
[{"$nulls":24},"Final energy consumption",{"$f":"BEI!S48","v":0}]
[]
[]
[]
[]
[]
[]
["Key elements of the SECAP on climate mitigation"]
[]
["6) Greenhouse gas emissions reduction target"]
[]
[null,"Time horizon","Reduction Target","tonnes CO2 (eq.) to be reduced"]
[null,2020,{"$f":"Strategy!E15","v":""},{"$f":"IF(Strategy!H15=\"BAU 2020\",'Mitigation Actions'!G21*C104,IF(Strategy!I15=\"per capita\",(BEI!S134)*(1-((1-C104)*Strategy!J15)/BEI!D11),BEI!S134*C104))","v":0}]
[null,2030,{"$f":"Strategy!E16","v":""},{"$f":"IF(Strategy!H16=\"BAU 2030\",'Mitigation Actions'!G25*C105,IF(Strategy!I16=\"per capita\",(BEI!S134)*(1-((1-C105)*Strategy!J16)/BEI!D11),BEI!S134*C105))","v":0}]
[null,{"$f":"Strategy!G17","v":"[drop -down]"},{"$f":"Strategy!E17","v":""},{"$f":"IF(Strategy!H17=\"BAU\",'Mitigation Actions'!G29*C106,IF(Strategy!I17=\"per capita\",(BEI!S134)*(1-((1-C106)*Strategy!J17)/BEI!D11),BEI!S134*C106))","v":0}]
[]
[]
["7) Estimated greenhouse gas emissions reduction per sector in 2020",{"$nulls":9},"Estimated greenhouse gas emissions reduction per sector in 2030",{"$nulls":13},"Estimated greenhouse gas emissions reduction per sector in long-term target year"]
[]
[{"$nulls":40},2020,2030,{"$f":"Strategy!G17","v":"[drop -down]"}]
[{"$nulls":39},"Municipal",{"$f":"'Mitigation Actions'!X$53","v":""},{"$f":"'Mitigation Actions'!AB53","v":""},{"$f":"'Mitigation Actions'!AF53","v":""}]
[{"$nulls":39},"Tertiary",{"$f":"'Mitigation Actions'!X60","v":""},{"$f":"'Mitigation Actions'!AB60","v":""},{"$f":"'Mitigation Actions'!AF60","v":""}]
[{"$nulls":39},"Residential",{"$f":"'Mitigation Actions'!X67","v":""},{"$f":"'Mitigation Actions'!AB67","v":""},{"$f":"'Mitigation Actions'!AF67","v":""}]
[{"$nulls":39},"Public lighting",{"$f":"'Mitigation Actions'!X74","v":""},{"$f":"'Mitigation Actions'!AB74","v":""},{"$f":"'Mitigation Actions'!AF74","v":""}]
[{"$nulls":39},"Transport",{"$f":"'Mitigation Actions'!X88","v":""},{"$f":"'Mitigation Actions'!AB88","v":""},{"$f":"'Mitigation Actions'!AF88","v":""}]
[{"$nulls":39},"Industry",{"$f":"'Mitigation Actions'!X81","v":""},{"$f":"'Mitigation Actions'!AB81","v":""},{"$f":"'Mitigation Actions'!AF81","v":""}]
[{"$nulls":39},"Local electricity production",{"$f":"'Mitigation Actions'!X95","v":""},{"$f":"'Mitigation Actions'!AB95","v":""},{"$f":"'Mitigation Actions'!AF95","v":""}]
[{"$nulls":39},"Local heat/cold production",{"$f":"'Mitigation Actions'!X95","v":""},{"$f":"'Mitigation Actions'!AB102","v":""},{"$f":"'Mitigation Actions'!AF102","v":""}]
[{"$nulls":39},"Others",{"$f":"'Mitigation Actions'!X109","v":""},{"$f":"'Mitigation Actions'!AB109","v":""},{"$f":"'Mitigation Actions'!AF109","v":""}]
{"$rows_empty":8}
["8) Expected evolution in terms of greenhouse gas emissions"]
[]
[]
[{"$nulls":24},{"$f":"Strategy!H15","v":"[drop -down]"},null,{"$f":"BEI!S134","v":0}]
[{"$nulls":24},"BAU Scenario 2020",null,{"$f":"'Mitigation Actions'!G21","v":0}]
[{"$nulls":24},"SECAP Scenario 2020",null,{"$f":"BEI!S134-BEI!S134*Strategy!E15","v":0}]
[]
[{"$nulls":24},{"$f":"Y132","v":"[drop -down]"},null,{"$f":"AA132","v":0}]
[{"$nulls":24},"BAU Scenario 2030",null,{"$f":"'Mitigation Actions'!G25","v":0}]
[{"$nulls":24},"SECAP Scenario 2030",null,{"$f":"BEI!S134-BEI!S134*Strategy!E16","v":0}]
[]
[{"$nulls":24},{"$f":"Y132","v":"[drop -down]"},null,{"$f":"AA132","v":0}]
[{"$nulls":24},"BAU Scenario long-term year",null,{"$f":"'Mitigation Actions'!G29","v":0}]
[{"$nulls":24},"SECAP Scenario long-term year",null,{"$f":"BEI!S134-BEI!S134*Strategy!E17","v":0}]
[{"$nulls":24},2020]
[{"$nulls":24},2030]
[{"$nulls":24},"Long-term"]
[]
[]
["Comments:"]
{"$rows_empty":9}
[{"$nulls":16},{"$f":"CONCATENATE(TEXT(2000-LEN(B150),\"#\"),\" chars left\")","v":"2000 chars left"}]

{"sheet":"Monitoring Report","index":8,"n_rows":216,"n_cols":21,"rows_kept":216,"merged":[[0,0,0,17],[41,11,41,12],[42,11,42,12],[43,11,43,12],[44,11,44,12],[45,11,45,12],[46,11,46,12],[47,11,47,12],[48,11,48,12],[49,11,49,12],[50,11,50,12],[59,11,59,14],[60,11,60,14],[61,11,61,14],[62,11,62,14],[63,11,63,14],[68,0,68,2],[72,0,72,2],[112,0,112,7],[179,16,179,17],[197,1,205,15]]}
["Monitoring Report for Mitigation",{"$nulls":17},"y HOME"]
[]
[]
[]
[]
["Your implementation progress"]
["i This report refers to the monitoring of the mitigation part of the SECAP."]
[]
["1) Status of implementation of actions"]
[]
[]
[]
[]
[]
[{"$nulls":12},"Municipal","Tertiary","Residential","Public lighting","Industry","Transport","Local electricity ","Local heat/hold","Others"]
[{"$nulls":11},"Completed",{"$f":"SUMIF('Mitigation Actions'!$N$54:$N$58,\"completed\")","v":0},{"$f":"COUNTIF('Mitigation Actions'!N$61:N$65,\"completed\")","v":0},{"$f":"COUNTIF('Mitigation Actions'!N$68:N$72,\"completed\")","v":0},{"$f":"COUNTIF('Mitigation Actions'!N$75:N$79,\"completed\")","v":0},{"$f":"COUNTIF('Mitigation Actions'!N$82:N$86,\"completed\")","v":0},{"$f":"COUNTIF('Mitigation Actions'!N$89:N$93,\"completed\")","v":0},{"$f":"COUNTIF('Mitigation Actions'!N$96:N$100,\"completed\")","v":0},{"$f":"COUNTIF('Mitigation Actions'!N$103:N$107,\"completed\")","v":0},{"$f":"COUNTIF('Mitigation Actions'!N$110:N$114,\"completed\")","v":0}]
[{"$nulls":11},"Ongoing",{"$f":"COUNTIF('Mitigation Actions'!$N$54:$N$58,\"completed\")","v":0},{"$f":"COUNTIF('Mitigation Actions'!N$61:N$65,\"completed\")","v":0},{"$f":"COUNTIF('Mitigation Actions'!N$68:N$72,\"completed\")","v":0},{"$f":"COUNTIF('Mitigation Actions'!N$75:N$79,\"completed\")","v":0},{"$f":"COUNTIF('Mitigation Actions'!N$82:N$86,\"completed\")","v":0},{"$f":"COUNTIF('Mitigation Actions'!N$89:N$93,\"completed\")","v":0},{"$f":"COUNTIF('Mitigation Actions'!N$96:N$100,\"completed\")","v":0},{"$f":"COUNTIF('Mitigation Actions'!N$103:N$107,\"completed\")","v":0},{"$f":"COUNTIF('Mitigation Actions'!N$110:N$114,\"completed\")","v":0}]
[{"$nulls":11},"Not started",{"$f":"COUNTIF('Mitigation Actions'!$N$54:$N$58,\"completed\")+M19","v":0},{"$f":"COUNTIF('Mitigation Actions'!N$61:N$65,\"completed\")+N19","v":0},{"$f":"COUNTIF('Mitigation Actions'!N$68:N$72,\"completed\")+O19","v":0},{"$f":"COUNTIF('Mitigation Actions'!N$75:N$79,\"completed\")+P19","v":0},{"$f":"COUNTIF('Mitigation Actions'!N$82:N$86,\"completed\")+Q19","v":0},{"$f":"COUNTIF('Mitigation Actions'!N$89:N$93,\"completed\")+R19","v":0},{"$f":"COUNTIF('Mitigation Actions'!N$96:N$100,\"completed\")+S19","v":0},{"$f":"COUNTIF('Mitigation Actions'!N$103:N$107,\"completed\")+T19","v":0},{"$f":"COUNTIF('Mitigation Actions'!N$110:N$114,\"completed\")+U19","v":0}]
[{"$nulls":11},"Postponed",{"$f":"COUNTIF('Mitigation Actions'!$N$54:$N$58,\"completed\")","v":0},{"$f":"COUNTIF('Mitigation Actions'!N$61:N$65,\"completed\")","v":0},{"$f":"COUNTIF('Mitigation Actions'!N$68:N$72,\"completed\")","v":0},{"$f":"COUNTIF('Mitigation Actions'!N$75:N$79,\"completed\")","v":0},{"$f":"COUNTIF('Mitigation Actions'!N$82:N$86,\"completed\")","v":0},{"$f":"COUNTIF('Mitigation Actions'!N$89:N$93,\"completed\")","v":0},{"$f":"COUNTIF('Mitigation Actions'!N$96:N$100,\"completed\")","v":0},{"$f":"COUNTIF('Mitigation Actions'!N$103:N$107,\"completed\")","v":0},{"$f":"COUNTIF('Mitigation Actions'!N$110:N$114,\"completed\")","v":0}]
{"$rows_empty":9}
["2) Overall budget spent"]
[]
[{"$nulls":11},"Budget","€"]
[{"$nulls":11},"Spent",{"$f":"SUM(Strategy!W59:Y60,Strategy!AB59:AD60)","v":0}]
[{"$nulls":11},"Remaining",{"$f":"SUM(Strategy!I59:K60,Strategy!N59:P60)-'Monitoring Report'!M32","v":0}]
[]
[]
[]
[]
[]
[]
["3) Money spent per sector "]
[]
[{"$nulls":13},"€"]
[{"$nulls":11},"Municipal",null,{"$f":"'Mitigation Actions'!Q53","v":""}]
[{"$nulls":11},"Tertiary",null,{"$f":"'Mitigation Actions'!Q60","v":""}]
[{"$nulls":11},"Residential",null,{"$f":"'Mitigation Actions'!Q67","v":""}]
[{"$nulls":11},"Public lighting",null,{"$f":"'Mitigation Actions'!Q74","v":""}]
[{"$nulls":11},"Industry",null,{"$f":"'Mitigation Actions'!Q81","v":""}]
[{"$nulls":11},"Transport",null,{"$f":"'Mitigation Actions'!Q88","v":""}]
[{"$nulls":11},"Local electricity production",null,{"$f":"'Mitigation Actions'!Q95","v":""}]
[{"$nulls":11},"Local heat/cold production",null,{"$f":"'Mitigation Actions'!Q102","v":""}]
[{"$nulls":11},"Others",null,{"$f":"'Mitigation Actions'!Q109","v":""}]
[]
[]
[]
[]
[]
[]
["4) Estimated greenhouse gas emissions reduction according to the implementation status of the actions"]
[{"$nulls":3},"Tonnes CO2 eq. /year"]
[{"$nulls":15},2020,2030,{"$f":"Strategy!G17","v":"[drop -down]"}]
[{"$nulls":11},"Estimated GHG reduction associated with completed actions"]
[{"$nulls":11},"Estimated GHG reduction associated with ongoing actions"]
[{"$nulls":11},"Estimated GHG reduction associated with not started actions"]
[{"$nulls":11},"Overall estimated GHG reduction associated with all actions",{"$nulls":3},{"$f":"'Mitigation Actions'!$X$116","v":0},{"$f":"'Mitigation Actions'!$AB$116","v":0},{"$f":"'Mitigation Actions'!$AF$116","v":0}]
[{"$nulls":11},"i Insert the values according to the status of implementation of your actions. "]
{"$rows_empty":11}
["Your performance towards energy sustainability and climate mitigation"]
[]
["5) Greenhouse gas emissions and final energy consumption per capita",{"$nulls":10},"i Insert the values according to the number of MEIs included."]
[{"$nulls":11},"year","tonnes/capita"]
[{"$nulls":11},{"$f":"BEI!D8","v":"[drop-down]"},{"$f":"BEI!S134/BEI!D11","v":"#DIV/0!"}]
[{"$nulls":11},{"$f":"'MEI1'!D9","v":"[drop-down]"},{"$f":"'MEI1'!S136/'MEI1'!D12","v":"#DIV/0!"}]
[{"$nulls":11},{"$f":"'MEI2'!D9","v":"[drop-down]"},{"$f":"'MEI2'!S136/'MEI2'!D12","v":"#DIV/0!"}]
[]
[]
[]
[{"$nulls":11},"year","MWh/capita"]
[{"$nulls":11},{"$f":"BEI!D8","v":"[drop-down]"},{"$f":"BEI!S48/BEI!D11","v":"#DIV/0!"}]
[{"$nulls":11},{"$f":"'MEI1'!D9","v":"[drop-down]"},{"$f":"'MEI1'!S49/'MEI1'!D12","v":"#DIV/0!"}]
[{"$nulls":11},{"$f":"'MEI2'!D9","v":"[drop-down]"},{"$f":"'MEI2'!S49/'MEI2'!D12","v":"#DIV/0!"}]
{"$rows_empty":7}
["6) Greenhouse gas emissions (influence of the National Electricity Emission Factor)"]
[]
[{"$nulls":11},"year","Input National Electricity Emission Factor","Constant emission factor","Yearly updated emission factor","GHG emissions with constant national emission factor","GHG emissions with updated national emission factor"]
[{"$nulls":11},{"$f":"BEI!D8","v":"[drop-down]"},{"$f":"BEI!C98","v":""},{"$f":"((BEI!D48-BEI!D59-BEI!D68-BEI!D77-BEI!E77)*$M101+(BEI!D59*BEI!E59)+(BEI!F68+BEI!P77+BEI!Q77))/BEI!D48","v":"#DIV/0!"},"-",{"$f":"($N101*BEI!$D$48)+SUM(BEI!$E$134:$R$134)","v":"#DIV/0!"},{"$f":"($N101*BEI!$D$48)+SUM(BEI!$E$134:$R$134)","v":"#DIV/0!"}]
[{"$nulls":11},{"$f":"'MEI1'!D9","v":"[drop-down]"},{"$f":"'MEI1'!C100","v":""},{"$f":"(('MEI1'!$D$49-'MEI1'!$D$60-'MEI1'!$D$69-'MEI1'!$D$78-'MEI1'!$E$78)*$M101+('MEI1'!$D$60*'MEI1'!$E$60)+('MEI1'!$F$69+'MEI1'!$P$78+'MEI1'!$Q$78))/'MEI1'!$D$49","v":"#DIV/0!"},{"$f":"(('MEI1'!$D$49-'MEI1'!$D$60-'MEI1'!$D$69-'MEI1'!$D$78-'MEI1'!$E$78)*M102+('MEI1'!$D$60*'MEI1'!$E$60)+('MEI1'!$F$69+'MEI1'!$P$78+'MEI1'!$Q$78))/'MEI1'!$D$49","v":"#DIV/0!"},{"$f":"($N102*'MEI1'!$D$49)+SUM('MEI1'!$E$136:$R$136)","v":"#DIV/0!"},{"$f":"(O102*'MEI1'!$D$49)+SUM('MEI1'!$E$136:$R$136)","v":"#DIV/0!"}]
[{"$nulls":11},{"$f":"'MEI2'!D9","v":"[drop-down]"},{"$f":"'MEI2'!C100","v":""},{"$f":"(('MEI2'!$D$49-'MEI2'!$D$60-'MEI2'!$D$69-'MEI2'!$D$78-'MEI2'!$E$78)*M101+('MEI2'!$D$60*'MEI2'!$E$60)+('MEI2'!$F$69+'MEI2'!$P$78+'MEI2'!$Q$78))/'MEI2'!$D$49","v":"#DIV/0!"},{"$f":"(('MEI2'!$D$49-'MEI2'!$D$60-'MEI2'!$D$69-'MEI2'!$D$78-'MEI2'!$E$78)*M103+('MEI2'!$D$60*'MEI2'!$E$60)+('MEI2'!$F$69+'MEI2'!$P$78+'MEI2'!$Q$78))/'MEI2'!$D$49","v":"#DIV/0!"},{"$f":"($N103*'MEI2'!$D$49)+SUM('MEI2'!$E$136:$R$136)","v":"#DIV/0!"},{"$f":"(O103*'MEI2'!$D$49)+SUM('MEI2'!$E$136:$R$136)","v":"#DIV/0!"}]
{"$rows_empty":9}
["           * Total GHG emission according to constant National Electricity Emission Factor has been calculated in order to show the effect on emission reduction expressed by the changing of National Power grid mix and not directly related to actions within the action plan."]
[]
[]
["7) Greenhouse gas emissions per sector"]
[]
[{"$nulls":12},{"$f":"BEI!D8","v":"[drop-down]"},{"$f":"'MEI1'!D9","v":"[drop-down]"},{"$f":"'MEI2'!D9","v":"[drop-down]"}]
[{"$nulls":11},"Municipal",{"$f":"BEI!S116","v":0},{"$f":"'MEI1'!S118","v":0},{"$f":"'MEI2'!S118","v":0}]
[{"$nulls":11},"Tertiary",{"$f":"BEI!S117","v":0},{"$f":"'MEI1'!S119","v":0},{"$f":"'MEI2'!S119","v":0}]
[{"$nulls":11},"Residential",{"$f":"BEI!S118","v":0},{"$f":"'MEI1'!S120","v":0},{"$f":"'MEI2'!S120","v":0}]
[{"$nulls":11},"Public lighting",{"$f":"BEI!S119","v":0},{"$f":"'MEI1'!S121","v":0},{"$f":"'MEI2'!S121","v":0}]
[{"$nulls":11},"Industry",{"$f":"SUM(BEI!S120:S121)","v":0},{"$f":"SUM('MEI1'!S122:S123)","v":0},{"$f":"SUM('MEI2'!S122:S123)","v":0}]
[{"$nulls":11},"Transport",{"$f":"BEI!S127","v":0},{"$f":"'MEI1'!S129","v":0},{"$f":"'MEI2'!S129","v":0}]
[{"$nulls":11},"Other",{"$f":"BEI!S129","v":0},{"$f":"'MEI1'!S131","v":0},{"$f":"'MEI2'!S131","v":0}]
[{"$nulls":11},"Non-energy related",{"$f":"SUM(BEI!S131:S133)","v":0},{"$f":"SUM('MEI1'!S133:S135)","v":0},{"$f":"SUM('MEI2'!S133:S135)","v":0}]
[{"$nulls":10},"Buildings, equipment/facilities and Industries"]
[{"$nulls":10},"Transport "]
[{"$nulls":10},"Other"]
[]
[]
[{"$nulls":10},"Non-energy related"]
[]
[]
[]
["8) Final energy consumption per sector "]
[]
[]
[{"$nulls":12},{"$f":"BEI!$D$8","v":"[drop-down]"},{"$f":"'MEI1'!$D$9","v":"[drop-down]"},{"$f":"'MEI2'!$D$9","v":"[drop-down]"}]
[{"$nulls":11},"Municipal",{"$f":"BEI!S34","v":0},{"$f":"'MEI1'!S35","v":0},{"$f":"'MEI2'!S35","v":0}]
[{"$nulls":11},"Tertiary",{"$f":"BEI!S35","v":0},{"$f":"'MEI1'!S36","v":0},{"$f":"'MEI2'!S36","v":0}]
[{"$nulls":11},"Residential",{"$f":"BEI!S36","v":0},{"$f":"'MEI1'!S37","v":0},{"$f":"'MEI2'!S37","v":0}]
[{"$nulls":11},"Public lighting",{"$f":"BEI!S37","v":0},{"$f":"'MEI1'!S38","v":0},{"$f":"'MEI2'!S38","v":0}]
[{"$nulls":11},"Industry",{"$f":"SUM(BEI!S38:S39)","v":0},{"$f":"SUM('MEI1'!S39:S40)","v":0},{"$f":"SUM('MEI2'!S39:S40)","v":0}]
[{"$nulls":11},"Transport",{"$f":"BEI!S45","v":0},{"$f":"'MEI1'!S46","v":0},{"$f":"'MEI2'!S46","v":0}]
[{"$nulls":11},"Other",{"$f":"BEI!S47","v":0},{"$f":"'MEI1'!S48","v":0},{"$f":"'MEI2'!S48","v":0}]
{"$rows_empty":8}
["9) Final energy consumption per energy carrier"]
[]
[]
[{"$nulls":12},{"$f":"BEI!$D$8","v":"[drop-down]"},{"$f":"'MEI1'!$D$9","v":"[drop-down]"},{"$f":"'MEI2'!$D$9","v":"[drop-down]"}]
[{"$nulls":11},"Renewables",{"$f":"SUM(BEI!N48:R48)","v":0},{"$f":"SUM('MEI1'!N49:R49)","v":0},{"$f":"SUM('MEI2'!N49:R49)","v":0}]
[{"$nulls":11},"Fossil fuels",{"$f":"SUM(BEI!F48:M48)","v":0},{"$f":"SUM('MEI1'!F49:M49)","v":0},{"$f":"SUM('MEI2'!F49:M50)","v":0}]
[{"$nulls":11},"Heat/cold",{"$f":"BEI!E48","v":0},{"$f":"'MEI1'!E49","v":0},{"$f":"'MEI2'!E49","v":0}]
[{"$nulls":11},"Electricity",{"$f":"BEI!D48","v":0},{"$f":"'MEI1'!D49","v":0},{"$f":"'MEI2'!D49","v":0}]
{"$rows_empty":8}
["   * Renewables for non-electricity uses."]
["   ** The energy mix of heat/cold and electricity is not identified."]
[]
[]
["10) Local energy production",null,true]
[]
[]
[]
[]
[{"$nulls":18},{"$f":"BEI!$D$8","v":"[drop-down]"},{"$f":"'MEI1'!$D$9","v":"[drop-down]"},{"$f":"'MEI2'!$D$9","v":"[drop-down]"}]
[{"$nulls":17},"RES electricity production",{"$f":"SUM(BEI!D68,BEI!D77)","v":0},{"$f":"SUM('MEI1'!D69,'MEI1'!D78)","v":0},{"$f":"SUM('MEI2'!D69,'MEI2'!D78)","v":0}]
[{"$nulls":17},"Non-RES electricity production",{"$f":"BEI!E77","v":0},{"$f":"'MEI1'!E78","v":0},{"$f":"'MEI2'!E78","v":0}]
[{"$nulls":17},"RES heat/cold production",{"$f":"BEI!D87","v":0},{"$f":"'MEI1'!D88","v":0},{"$f":"'MEI2'!D88","v":0}]
[{"$nulls":17},"Non-RES heat/cold production",{"$f":"BEI!E87","v":0},{"$f":"'MEI1'!E88","v":0},{"$f":"'MEI2'!E88","v":0}]
[{"$nulls":17},"Electricity consumption",{"$f":"BEI!D48","v":0},{"$f":"'MEI1'!D49","v":0},{"$f":"'MEI2'!D49","v":0}]
[{"$nulls":17},"Heat/cold consumption",{"$f":"BEI!E48","v":0},{"$f":"'MEI1'!E49","v":0},{"$f":"'MEI2'!E49","v":0}]
{"$rows_empty":9}
["Comments:"]
{"$rows_empty":9}
[{"$nulls":16},{"$f":"CONCATENATE(TEXT(2000-LEN(B198),\"#\"),\" chars left\")","v":"2000 chars left"}]
[]
[]
["NO DECISION WAS YET TAKEN REGARDING THE INTEGRATION OF A SECTION DEDICATED TO THESE OPTIONAL INDICATORS"]
["Examples of indicators that would require extra data from signatories' side",{"$nulls":7},"Parameters required"]
["GHG emissions per unit of Gross Domestic Product (GDP) [t CO2 or t CO2 eq./ million €]",{"$nulls":7},"Municipal GDP"]
["Public transport ridership [pkm/capita]",{"$nulls":7},"Passenger-km in public transport"]
["Energy expenditure in the residential sector [€/year]",{"$nulls":7},"Residential end-use energy price per energy carrier "]
["Energy expenditure in the municipal sector [€/year]",{"$nulls":7},"Municipal energy expenditure"]
["Energy intensity of buildings [kWh/m2]",{"$nulls":7},"Square meters of building floor area "]
["Carbon intensity of transport [CO2/km]",{"$nulls":7},"km driven by transport category"]

{"sheet":"Adaptation Scoreboard","index":9,"n_rows":46,"n_cols":10,"rows_kept":46,"merged":[[0,1,0,8],[6,1,6,8],[7,1,7,3],[7,4,13,8],[13,1,13,3],[14,2,14,4],[15,1,21,1],[15,2,15,4],[15,7,21,7],[15,8,21,8],[16,2,16,4],[17,2,17,4],[18,2,18,4],[19,2,19,4],[20,2,20,4],[21,2,21,4],[22,1,25,1],[22,2,22,4],[22,7,25,7],[22,8,25,8],[23,2,23,4],[24,2,24,4],[25,2,25,4],[26,1,28,1],[26,2,26,4],[26,7,28,7],[26,8,28,8],[27,2,27,4],[28,2,28,4],[29,1,31,1],[29,2,29,4],[29,7,31,7],[29,8,31,8],[30,2,30,4],[31,2,31,4],[32,1,35,1],[32,2,32,4],[32,7,35,7],[32,8,35,8],[33,2,33,4],[34,2,34,4],[35,2,35,4],[39,1,39,8]]}
[null,"Adaptation Scoreboard",{"$nulls":7},"y HOME"]
[]
[]
[]
[]
[]
[null,"i Please complete the following self-assessment checklist, using the A-B-C-D scaling system (presented below) in column F (compulsory). Identify your next steps/areas of possible improvements through comments entered in column I (optional). The average status for every step is then visualised through the (automatically computed) spider graph below a well as in the \"Synthesis Report\" tab."]
[]
[null,"Status Scale","Status","Indicative Completion Level"]
[null,"D","Not started or getting started","0-25 %"]
[null,"C","Moving forward","25-50 %"]
[null,"B","Forging ahead","50-75 %"]
[null,"A","Taking the lead","75-100 %"]
[]
[null,"Adaptation cycle steps","Actions",null,null,"Self check\nof the Status",null,"Your Average Score","Comments"]
[null,"\n\nSTEP 1 - Preparing the ground for adaptation","Adaptation commitments defined/integrated into the local climate policy",{"$nulls":3},{"$f":"IF(F16=\"A\",\"4\",\"0\")+IF(F16=\"B\",\"3\",\"0\")+IF(F16=\"C\",\"2\",\"0\")+IF(F16=\"D\",\"1\",\"0\")","v":0},{"$f":"AVERAGE(G16:G22)","v":0}]
[null,null,"Human, technical and financial resources identified",{"$nulls":3},0]
[null,null,"Adaptation team (officer) appointed within the municipal administration\nand clear responsibilities assigned",{"$nulls":3},0]
[null,null,"Horizontal (i.e. across sectoral departments) coordination mechanisms in place",{"$nulls":3},0]
[null,null,"Vertical (i.e. across governance levels) coordination mechanisms in place",{"$nulls":3},0]
[null,null,"Consultative and participatory mechanisms set up,\nfostering the multi-stakeholder engagement in the adaptation process",{"$nulls":3},0]
[null,null,"Continuous communication process in place\n(for the engagement of the different target audiences)",{"$nulls":3},0,null,null,{"$f":"CONCATENATE(TEXT(500-LEN(I16),\"#\"),\" chars left\")","v":"500 chars left"}]
[null,"\nSTEP 2 - Assessing risks &\nvulnerabilities to climate change","Mapping of the possible methods & data sources\nfor carrying out a Risk & Vulnerability Assessment conducted",{"$nulls":3},0,{"$f":"AVERAGE(G23:G26)","v":0}]
[null,null,"Assessment(s) of climate risks & vulnerabilities undertaken",{"$nulls":3},0]
[null,null,"Possible sectors of action identified and prioritised",{"$nulls":3},0]
[null,null,"Available knowledge periodically reviewed and new findings integrated",{"$nulls":3},0,null,null,{"$f":"CONCATENATE(TEXT(500-LEN(I23),\"#\"),\" chars left\")","v":"500 chars left"}]
[null,"\nSTEPS 3 & 4 - Identifying, assessing and selecting adaptation options ","Full portfolio of adaptation options compiled, documented and assessed",{"$nulls":3},0,{"$f":"AVERAGE(G27:G29)","v":0}]
[null,null,"Possibilities of mainstreaming adaptation in existing policies and plans assessed,\npossible synergies and conflicts (e.g. with mitigation actions) identified",{"$nulls":3},0]
[null,null,"Adaptation Actions developed and adopted\n(as part of the SECAP and/or other planning documents)",{"$nulls":3},0,null,null,{"$f":"CONCATENATE(TEXT(500-LEN(I27),\"#\"),\" chars left\")","v":"500 chars left"}]
[null,"\nSTEP 5 - Implementing","Implementation framework set, with clear milestones",{"$nulls":3},0,{"$f":"AVERAGE(G30:G32)","v":0}]
[null,null,"Adaptation actions implemented and mainstreamed (where relevant)\nas defined in the adopted SECAP and/or other planning documents",{"$nulls":3},0]
[null,null,"Coordinated action between mitigation and adaptation set",{"$nulls":3},0,null,null,{"$f":"CONCATENATE(TEXT(500-LEN(I30),\"#\"),\" chars left\")","v":"500 chars left"}]
[null,"\n\nSTEP 6 - Monitoring and evaluating","Monitoring framework in place for adaptation actions",{"$nulls":3},0,{"$f":"AVERAGE(G33:G36)","v":0}]
[null,null,"Appropriate M&E indicators identified",{"$nulls":3},0]
[null,null,"Progress regularly monitored and reported to the relevant decision-makers",{"$nulls":3},0]
[null,null,"Adaptation strategy and/or Action Plan updated, revised and readjusted\naccording to the findings of the M&E procedure",{"$nulls":3},0,null,null,{"$f":"CONCATENATE(TEXT(500-LEN(I33),\"#\"),\" chars left\")","v":"500 chars left"}]
[]
[{"$nulls":8},"BACK Û","Ü NEXT"]
[null,"Summary table:"]
[null,"The score obtained for each step is summarised in the table below (based on the information entered by the user in the above table > A: 4 points, B: 3 points, C: 2 points, D: 1 point). The spider graph at the top is automatically generated, making the results more visual. "]
[null,"Adaptation Steps","Your Average Score"]
[null,"STEP 1 - Preparing the ground",{"$f":"ROUND(H16,0)","v":0}]
[null,"STEP 2 - Assessing risks & vulnerabilities",{"$f":"ROUND(H23,0)","v":0}]
[null,"STEPS 3 & 4 - Identifying adaptation options ",{"$f":"ROUND(H27,0)","v":0}]
[null,"STEP 5 - Implementing",{"$f":"ROUND(H30,0)","v":0}]
[null,"STEP 6 - Monitoring & evaluating",{"$f":"ROUND(H33,0)","v":0}]

{"sheet":"Risks & Vulnerabilities","index":10,"n_rows":55,"n_cols":10,"rows_kept":55,"merged":[[5,1,5,8],[6,1,6,5],[8,2,8,3],[8,5,8,6],[9,2,9,3],[9,5,9,6],[10,2,10,3],[10,5,10,6],[11,2,11,3],[11,5,11,6],[13,1,13,8],[15,1,15,8],[16,1,16,9],[17,5,17,7],[18,2,18,3],[19,2,19,3],[19,9,28,9],[20,2,20,3],[21,2,21,3],[22,2,22,3],[23,2,23,3],[24,2,24,3],[25,2,25,3],[26,2,26,3],[27,2,27,3],[29,2,29,3],[29,4,29,7],[30,1,30,2],[32,2,32,3],[32,4,32,7],[33,2,33,3],[33,4,33,7],[34,2,34,3],[34,4,34,7],[36,1,36,8],[37,1,37,2],[38,1,38,9],[39,2,39,3],[40,2,40,3],[40,9,51,9],[41,2,41,3],[42,2,42,3],[43,2,43,3],[44,2,44,3],[45,2,45,3],[46,2,46,3],[47,2,47,3],[48,2,48,3],[49,2,49,3],[50,2,50,3],[52,2,52,3],[52,4,52,7]]}
[null,"Climate Change Risks and Vulnerabilities",{"$nulls":7},"y HOME"]
[]
[]
[]
[]
[]
["1)","Climate Change Risk and Vulnerability Assessment(s)"]
[]
[null,"Title","Author(s)",null,"Year","Description",null,"Boundary","Method & Source(s)","Published?"]
[{"$nulls":4},"[Drop-Down]",{"$nulls":4},"[√/×]"]
[{"$nulls":4},"[Drop-Down]",{"$nulls":4},"[√/×]"]
[{"$nulls":4},"[Drop-Down]",{"$nulls":4},"[√/×]"]
[null,"i Add as many rows as necessary"]
[null," Click here to send your Risk & Vulnerability Assessment(s) to helpdesk@mayors-adapt.eu - it(they) will be made available under your signatory profile on the Covenant of Mayors website."]
[]
["2)","Climate hazard risks particularly relevant for your local authority or region"]
[]
[{"$nulls":4},"<< Current Risks >>","<<   Anticipated Risks   >>"]
[null,null,"Climate Hazard Type",null,"Current hazard risk level","Expected change\nin intensity","Expected change\nin frequency","Timeframe","Risk-related indicators"]
[null,null,"Extreme Heat",null,"[Drop-Down]","[Drop-Down]","[Drop-Down]","[Drop-Down]"]
[null,null,"Extreme Cold",null,"[Drop-Down]","[Drop-Down]","[Drop-Down]","[Drop-Down]"]
[null,null,"Extreme Precipitation",null,"[Drop-Down]","[Drop-Down]","[Drop-Down]","[Drop-Down]"]
[null,null,"Floods",null,"[Drop-Down]","[Drop-Down]","[Drop-Down]","[Drop-Down]"]
[null,null,"Sea Level Rise",null,"[Drop-Down]","[Drop-Down]","[Drop-Down]","[Drop-Down]"]
[null,null,"Droughts",null,"[Drop-Down]","[Drop-Down]","[Drop-Down]","[Drop-Down]"]
[null,null,"Storms ",null,"[Drop-Down]","[Drop-Down]","[Drop-Down]","[Drop-Down]"," "]
[null,null,"Landslides",null,"[Drop-Down]","[Drop-Down]","[Drop-Down]","[Drop-Down]"]
[null,null,"Forest Fires",null,"[Drop-Down]","[Drop-Down]","[Drop-Down]","[Drop-Down]"]
[null,null,"Other","[please specify]","[Drop-Down]","[Drop-Down]","[Drop-Down]","[Drop-Down]"]
[null,null,"i Hide the rows that do not concern your local authority",null,"i To be completed for the climate hazards that concern your local authority only.",{"$nulls":3},"i Click here to see examples of risk-related indicators"]
["3)","Vulnerabilities of your local authority or region"]
[]
[null,null,"Vulnerability Type",null,"Vulnerability Description",{"$nulls":3},"Vulnerability-related indicators"]
[null,null,"Socio-Economic:"]
[null,null,"Physical and Environmental:"]
[{"$nulls":8},"i Click here to see examples of vulnerability-related indicators"]
[]
["4)","Expected impacts in your local authority or region"]
[]
[null,null,"Impacted Policy Sector",null,"Expected Impact(s)","Likelihood of Occurrence","Expected\nImpact Level","Timeframe","Impact-related indicators"]
[null,null,"Buildings",null,null,"[Drop-Down]","[Drop-Down]","[Drop-Down]"]
[null,null,"Transport",null,null,"[Drop-Down]","[Drop-Down]","[Drop-Down]"]
[null,null,"Energy",null,null,"[Drop-Down]","[Drop-Down]","[Drop-Down]"]
[null,null,"Water",null,null,"[Drop-Down]","[Drop-Down]","[Drop-Down]"]
[null,null,"Waste",null,null,"[Drop-Down]","[Drop-Down]","[Drop-Down]"]
[null,null,"Land Use Planning",null,null,"[Drop-Down]","[Drop-Down]","[Drop-Down]"]
[null,null,"Agriculture & Forestry",null,null,"[Drop-Down]","[Drop-Down]","[Drop-Down]"]
[null,null,"Environment & Biodiversity",null,null,"[Drop-Down]","[Drop-Down]","[Drop-Down]"]
[null,null,"Health",null,null,"[Drop-Down]","[Drop-Down]","[Drop-Down]"]
[null,null,"Civil Protection & Emergency",null,null,"[Drop-Down]","[Drop-Down]","[Drop-Down]"]
[null,null,"Tourism",null,null,"[Drop-Down]","[Drop-Down]","[Drop-Down]"]
[null,null,"Other","[please specify]",null,"[Drop-Down]","[Drop-Down]","[Drop-Down]"]
[null,null,"i Hide the rows that do not concern your local authority",null,"i To be completed for the sectors that are impacted in your local authority only.",{"$nulls":3},"i Click here to see examples of impact- & sector-related indicators"]
[]
[{"$nulls":8},"BACK Û","Ü NEXT"]

{"sheet":"Adaptation Actions","index":11,"n_rows":41,"n_cols":15,"rows_kept":41,"merged":[[6,1,6,9],[7,1,7,9],[8,2,8,3],[8,5,8,6],[8,8,8,12],[9,2,9,3],[9,5,9,6],[10,2,10,3],[10,5,10,6],[11,2,11,3],[11,5,11,6],[13,1,13,9],[16,1,16,7],[19,1,19,7],[20,10,20,14],[21,1,22,1],[21,2,22,2],[21,3,22,3],[21,4,22,4],[21,5,21,6],[21,7,22,7],[21,8,22,8],[21,9,22,9],[21,10,22,10],[21,11,22,11],[21,12,22,12],[21,13,21,14],[38,10,39,11]]}
[null,"Adaptation Actions",{"$nulls":12},"y HOME"]
[]
[]
[]
[]
[]
["1)","Adaptation Action Plan(s)"]
[]
[null,"Title","Short Description",null,"Date of Adoption (if any)","Language",null,"Published?"]
[{"$nulls":4},"[dd/mm/yy]","[Drop-Down]",null,"[√/×]"]
[{"$nulls":4},"[dd/mm/yy]","[Drop-Down]",null,"[√/×]"]
[{"$nulls":4},"[dd/mm/yy]","[Drop-Down]",null,"[√/×]"]
[null,"i Add as many rows as necessary"]
[null," Send your Local Adaptation Action Plan and other planning documents (if any) to helpdesk@mayors-adapt.eu."]
[]
[null,"Adaptation mainstreaming into other policy fields:"]
[]
[{"$nulls":7},{"$f":"CONCATENATE(TEXT(500-LEN(B17),\"#\"),\" characters left\")","v":"500 characters left"}]
["2)","Adaptation Actions"]
[null,"i List your adaptation actions in the table below. Actions can be comprehensive or representative, taken from one or more of the documents cited by the local authority in the section above."]
[{"$nulls":10},"<< Extra mandatory fields for \"Key Actions\" only >>"]
[null,"Sector","Title\n(max. 120 chars)","Short description\n(max. 300 chars)","Responsible body/department","Implementation timeframe",null,"Implementation status","Action also affecting mitigation?","Select as Key Action (☼)","Stakeholders involved","Risk and/or vulne-\nrability tackled","Outcome(s) reached (min. 1)","Costs (€)"]
[{"$nulls":5},"Start","End",{"$nulls":6},"Investment","Non-investment"]
[null,"[Drop-Down]",{"$nulls":3},"[Drop-Down]","[Drop-Down]","[Drop-Down]","[Select x]","[Please select]"]
[null,"[Drop-Down]",{"$nulls":3},"[Drop-Down]","[Drop-Down]","[Drop-Down]","[Select x]","[Please select]"]
[null,"[Drop-Down]",{"$nulls":3},"[Drop-Down]","[Drop-Down]","[Drop-Down]","[Select x]","[Please select]"]
[null,"[Drop-Down]",{"$nulls":3},"[Drop-Down]","[Drop-Down]","[Drop-Down]","[Select x]","[Please select]"]
[null,"[Drop-Down]",{"$nulls":3},"[Drop-Down]","[Drop-Down]","[Drop-Down]","[Select x]","[Please select]"]
[null,"[Drop-Down]",{"$nulls":3},"[Drop-Down]","[Drop-Down]","[Drop-Down]","[Select x]","[Please select]"]
[null,"[Drop-Down]",{"$nulls":3},"[Drop-Down]","[Drop-Down]","[Drop-Down]","[Select x]","[Please select]"]
[null,"[Drop-Down]",{"$nulls":3},"[Drop-Down]","[Drop-Down]","[Drop-Down]","[Select x]","[Please select]"]
[null,"[Drop-Down]",{"$nulls":3},"[Drop-Down]","[Drop-Down]","[Drop-Down]","[Select x]","[Please select]"]
[null,"[Drop-Down]",{"$nulls":3},"[Drop-Down]","[Drop-Down]","[Drop-Down]","[Select x]","[Please select]"]
[null,"[Drop-Down]",{"$nulls":3},"[Drop-Down]","[Drop-Down]","[Drop-Down]","[Select x]","[Please select]"]
[null,"[Drop-Down]",{"$nulls":3},"[Drop-Down]","[Drop-Down]","[Drop-Down]","[Select x]","[Please select]"]
[null,"[Drop-Down]",{"$nulls":3},"[Drop-Down]","[Drop-Down]","[Drop-Down]","[Select x]","[Please select]"]
[null,"[Drop-Down]",{"$nulls":3},"[Drop-Down]","[Drop-Down]","[Drop-Down]","[Select x]","[Please select]"]
[null,"[Drop-Down]",{"$nulls":3},"[Drop-Down]","[Drop-Down]","[Drop-Down]","[Select x]","[Please select]"]
[null,"i Add/hide as many rows as necessary.",{"$nulls":8},"i For quantifying the risk/vulnerability tackled and/or the outcome reached, click to see examples of indicators."]
[]
[{"$nulls":13},"BACK Û","Ü NEXT"]

{"sheet":"Adaptation Report","index":12,"n_rows":95,"n_cols":18,"rows_kept":95,"merged":[[14,8,14,9],[30,1,30,2],[30,12,30,13],[31,1,31,2],[31,12,31,13],[32,1,32,2],[32,12,32,13],[33,1,33,2],[33,12,33,13],[34,1,34,2],[34,12,34,13],[35,1,35,2],[36,1,36,2],[36,12,36,13],[37,1,37,2],[37,12,37,13],[38,1,38,2],[38,12,38,13],[39,1,39,2],[39,12,39,13],[40,12,40,13],[46,1,46,2],[46,12,46,13],[47,1,47,2],[47,12,47,13],[48,1,48,2],[48,12,48,13],[49,1,49,2],[49,12,49,13],[50,1,50,2],[50,12,50,13],[51,1,51,2],[51,12,51,13],[52,1,52,2],[52,12,52,13],[53,1,53,2],[53,12,53,13],[54,1,54,2],[54,12,54,13],[55,1,55,2],[55,12,55,13],[56,1,56,2],[56,12,56,13],[57,1,57,2],[57,12,57,13],[58,12,58,13],[64,7,64,8],[65,7,65,8],[66,7,66,8],[67,7,67,8],[68,7,68,8],[69,7,69,8],[70,7,70,8],[71,7,71,8],[72,7,72,8],[73,7,73,8],[74,7,74,8],[75,7,75,8],[76,7,76,8],[85,9,85,10],[96,1,100,10]]}
[null,"Adaptation Report",{"$nulls":9},"y HOME"]
[]
[]
[]
[]
[]
[null,"i The following tables and graphs are automatically generated according to the data you reported in the previous tabs."]
[]
["1)","Signatory Status in the Adaptation Cycle"]
[null,"[Source: \"Adaptation Scoreboard\" tab]"]
[]
[{"$nulls":8},"D: Not started or getting started"]
[{"$nulls":8},"C: Moving forward"]
[{"$nulls":8},"B: Forging ahead"]
[{"$nulls":8},"A: Taking the lead"]
{"$rows_empty":12}
["2)","Risk Rating Matrix"]
[null,"[Source: \"Risks & Vulnerabilities\" tab]"]
[]
[null,"Climate Hazard Type",null,"Risk Level","Expected change\nin intensity","Expected change\nin frequency","Timeframe",{"$nulls":5},"Climate Hazard Type",null,"Current hazard risk level","Expected change\nin intensity","Expected change\nin frequency","Timeframe"]
[null,"Extreme Heat",null,{"$f":"IF(O32=\"Low\",\"!\",IF(O32=\"Moderate\",\"!!\",IF(O32=\"High\",\"!!!\",IF(O32=\"Not Known\",\"[?]\",\"\"))))","v":""},{"$f":"IF(P32=\"No change\",\"↔\",IF(P32=\"Decrease\",\"↓\",IF(P32=\"Increase\",\"↑\",IF(P32=\"Not Known\",\"[?]\",\"\"))))","v":""},"",{"$f":"IF(R32=\"Current\",\"|\",IF(R32=\"Short-term\",\"►\",IF(R32=\"Medium-term\",\"►►\",IF(R32=\"Long-term\",\"►►►\",IF(R32=\"Not Known\",\"[?]\",\"\")))))","v":""},null,"!: Low","↑: Increase","|: Current",null,"High Temperatures",null,{"$f":"'Risks & Vulnerabilities'!E20","v":"[Drop-Down]"},{"$f":"'Risks & Vulnerabilities'!F20","v":"[Drop-Down]"},{"$f":"'Risks & Vulnerabilities'!G20","v":"[Drop-Down]"},{"$f":"'Risks & Vulnerabilities'!H20","v":"[Drop-Down]"}]
[null,"Extreme Cold",null,"",{"$f":"IF(P33=\"No change\",\"↔\",IF(P33=\"Decrease\",\"↓\",IF(P33=\"Increase\",\"↑\",IF(P33=\"Not Known\",\"[?]\",\"\"))))","v":""},"","",null,"!!: Moderate","↓: Decrease","►: Short-term",null,"Low Temperatures",null,{"$f":"'Risks & Vulnerabilities'!E21","v":"[Drop-Down]"},{"$f":"'Risks & Vulnerabilities'!F21","v":"[Drop-Down]"},{"$f":"'Risks & Vulnerabilities'!G21","v":"[Drop-Down]"},{"$f":"'Risks & Vulnerabilities'!H21","v":"[Drop-Down]"}]
[null,"Extreme Precipitation",null,"",{"$f":"IF(P34=\"No change\",\"↔\",IF(P34=\"Decrease\",\"↓\",IF(P34=\"Increase\",\"↑\",IF(P34=\"Not Known\",\"[?]\",\"\"))))","v":""},"","",null,"!!!: High","↔: No change","►►: Medium-term",null,"Extreme Precipitation",null,{"$f":"'Risks & Vulnerabilities'!E22","v":"[Drop-Down]"},{"$f":"'Risks & Vulnerabilities'!F22","v":"[Drop-Down]"},{"$f":"'Risks & Vulnerabilities'!G22","v":"[Drop-Down]"},{"$f":"'Risks & Vulnerabilities'!H22","v":"[Drop-Down]"}]
[null,"Floods",null,"",{"$f":"IF(P35=\"No change\",\"↔\",IF(P35=\"Decrease\",\"↓\",IF(P35=\"Increase\",\"↑\",IF(P35=\"Not Known\",\"[?]\",\"\"))))","v":""},"","",null,"[?]: Not Known","[?]: Not known","|►►►: Long-term",null,"Floods",null,{"$f":"'Risks & Vulnerabilities'!E23","v":"[Drop-Down]"},{"$f":"'Risks & Vulnerabilities'!F23","v":"[Drop-Down]"},{"$f":"'Risks & Vulnerabilities'!G23","v":"[Drop-Down]"},{"$f":"'Risks & Vulnerabilities'!H23","v":"[Drop-Down]"}]
[null,"Sea Level Rise",{"$nulls":8},"[?]: Not known",null,null,"Sea Level Rise",{"$f":"'Risks & Vulnerabilities'!E24","v":"[Drop-Down]"},{"$f":"'Risks & Vulnerabilities'!F24","v":"[Drop-Down]"},{"$f":"'Risks & Vulnerabilities'!G24","v":"[Drop-Down]"},{"$f":"'Risks & Vulnerabilities'!H24","v":"[Drop-Down]"}]
[null,"Droughts",null,{"$f":"IF(O37=\"Low\",\"!\",IF(O37=\"Moderate\",\"!!\",IF(O37=\"High\",\"!!!\",IF(O37=\"Not Known\",\"[?]\",\"\"))))","v":""},{"$f":"IF(P37=\"No change\",\"↔\",IF(P37=\"Decrease\",\"↓\",IF(P37=\"Increase\",\"↑\",IF(P37=\"Not Known\",\"[?]\",\"\"))))","v":""},"",{"$f":"IF(R37=\"Current\",\"|\",IF(R37=\"Short-term\",\"►\",IF(R37=\"Medium-term\",\"►►\",IF(R37=\"Long-term\",\"►►►\",IF(R37=\"Not Known\",\"[?]\",\"\")))))","v":""},{"$nulls":5},"Droughts",null,{"$f":"'Risks & Vulnerabilities'!E25","v":"[Drop-Down]"},{"$f":"'Risks & Vulnerabilities'!F25","v":"[Drop-Down]"},{"$f":"'Risks & Vulnerabilities'!G25","v":"[Drop-Down]"},{"$f":"'Risks & Vulnerabilities'!H25","v":"[Drop-Down]"}]
[null,"Storms ",null,"",{"$f":"IF(P38=\"No change\",\"↔\",IF(P38=\"Decrease\",\"↓\",IF(P38=\"Increase\",\"↑\",IF(P38=\"Not Known\",\"[?]\",\"\"))))","v":""},"","",{"$nulls":5},"Storms ",null,{"$f":"'Risks & Vulnerabilities'!E26","v":"[Drop-Down]"},{"$f":"'Risks & Vulnerabilities'!F26","v":"[Drop-Down]"},{"$f":"'Risks & Vulnerabilities'!G26","v":"[Drop-Down]"},{"$f":"'Risks & Vulnerabilities'!H26","v":"[Drop-Down]"}]
[null,"Landslides",null,"",{"$f":"IF(P39=\"No change\",\"↔\",IF(P39=\"Decrease\",\"↓\",IF(P39=\"Increase\",\"↑\",IF(P39=\"Not Known\",\"[?]\",\"\"))))","v":""},"","",{"$nulls":5},"Landslides",null,{"$f":"'Risks & Vulnerabilities'!E27","v":"[Drop-Down]"},{"$f":"'Risks & Vulnerabilities'!F27","v":"[Drop-Down]"},{"$f":"'Risks & Vulnerabilities'!G27","v":"[Drop-Down]"},{"$f":"'Risks & Vulnerabilities'!H27","v":"[Drop-Down]"}]
[null,"Forest Fires",null,"",{"$f":"IF(P40=\"No change\",\"↔\",IF(P40=\"Decrease\",\"↓\",IF(P40=\"Increase\",\"↑\",IF(P40=\"Not Known\",\"[?]\",\"\"))))","v":""},"","",{"$nulls":5},"Forest Fires",null,{"$f":"'Risks & Vulnerabilities'!E28","v":"[Drop-Down]"},{"$f":"'Risks & Vulnerabilities'!F28","v":"[Drop-Down]"},{"$f":"'Risks & Vulnerabilities'!G28","v":"[Drop-Down]"},{"$f":"'Risks & Vulnerabilities'!H28","v":"[Drop-Down]"}]
[null,"Other",{"$f":"'Risks & Vulnerabilities'!D29","v":"[please specify]"},"",{"$f":"IF(P41=\"No change\",\"↔\",IF(P41=\"Decrease\",\"↓\",IF(P41=\"Increase\",\"↑\",IF(P41=\"Not Known\",\"[?]\",\"\"))))","v":""},"","",{"$nulls":5},"Other [please specify]",null,{"$f":"'Risks & Vulnerabilities'!E29","v":"[Drop-Down]"},{"$f":"'Risks & Vulnerabilities'!F29","v":"[Drop-Down]"},{"$f":"'Risks & Vulnerabilities'!G29","v":"[Drop-Down]"},{"$f":"'Risks & Vulnerabilities'!H29","v":"[Drop-Down]"}]
[]
[]
["3)","Impact Rating Matrix"]
[null,"[Source: \"Risks & Vulnerabilities\" tab]"]
[]
[null,"Impacted Policy Sector",null,"Likelihood of Occurrence","Expected\nImpact Level","Timeframe",{"$nulls":6},"Impacted Policy Sector",null,"Likelihood of Occurrence","Expected\nImpact Level","Timeframe"]
[null,"Buildings",null,{"$f":"IF(O48=\"[Drop-Down]\",\"\",O48)","v":""},{"$f":"IF(P48=\"Low\",\"!\",IF(P48=\"Moderate\",\"!!\",IF(P48=\"High\",\"!!!\",IF(P48=\"Not Known\",\"[?]\",\"\"))))","v":""},{"$f":"IF(Q48=\"Current\",\"|\",IF(Q48=\"Short-term\",\"►\",IF(Q48=\"Medium-term\",\"►►\",IF(Q48=\"Long-term\",\"►►►\",IF(Q48=\"Not Known\",\"[?]\",\"\")))))","v":""},null,null,"!: Low","|: Current",null,null,"Buildings",null,{"$f":"'Risks & Vulnerabilities'!F41","v":"[Drop-Down]"},{"$f":"'Risks & Vulnerabilities'!G41","v":"[Drop-Down]"},{"$f":"'Risks & Vulnerabilities'!H41","v":"[Drop-Down]"}]
[null,"Transport",null,"","","",null,null,"!!: Moderate","►: Short-term",null,null,"Transport",null,{"$f":"'Risks & Vulnerabilities'!F42","v":"[Drop-Down]"},{"$f":"'Risks & Vulnerabilities'!G42","v":"[Drop-Down]"},{"$f":"'Risks & Vulnerabilities'!H42","v":"[Drop-Down]"}]
[null,"Energy",null,"","","",null,null,"!!!: High","►►: Medium-term",null,null,"Energy",null,{"$f":"'Risks & Vulnerabilities'!F43","v":"[Drop-Down]"},{"$f":"'Risks & Vulnerabilities'!G43","v":"[Drop-Down]"},{"$f":"'Risks & Vulnerabilities'!H43","v":"[Drop-Down]"}]
[null,"Water",null,"","","",null,null,"[?]: Not Known","|►►►: Long-term",null,null,"Water",null,{"$f":"'Risks & Vulnerabilities'!F44","v":"[Drop-Down]"},{"$f":"'Risks & Vulnerabilities'!G44","v":"[Drop-Down]"},{"$f":"'Risks & Vulnerabilities'!H44","v":"[Drop-Down]"}]
[null,"Waste",null,"","","",{"$nulls":3},"[?]: Not known",null,null,"Waste",null,{"$f":"'Risks & Vulnerabilities'!F45","v":"[Drop-Down]"},{"$f":"'Risks & Vulnerabilities'!G45","v":"[Drop-Down]"},{"$f":"'Risks & Vulnerabilities'!H45","v":"[Drop-Down]"}]
[null,"Land Use Planning",null,"","","",{"$nulls":6},"Land Use Planning",null,{"$f":"'Risks & Vulnerabilities'!F46","v":"[Drop-Down]"},{"$f":"'Risks & Vulnerabilities'!G46","v":"[Drop-Down]"},{"$f":"'Risks & Vulnerabilities'!H46","v":"[Drop-Down]"}]
[null,"Agriculture & Forestry",null,"","","",{"$nulls":6},"Agriculture & Forestry",null,{"$f":"'Risks & Vulnerabilities'!F47","v":"[Drop-Down]"},{"$f":"'Risks & Vulnerabilities'!G47","v":"[Drop-Down]"},{"$f":"'Risks & Vulnerabilities'!H47","v":"[Drop-Down]"}]
[null,"Environment & Biodiversity",null,"","","",{"$nulls":6},"Environment & Biodiversity",null,{"$f":"'Risks & Vulnerabilities'!F48","v":"[Drop-Down]"},{"$f":"'Risks & Vulnerabilities'!G48","v":"[Drop-Down]"},{"$f":"'Risks & Vulnerabilities'!H48","v":"[Drop-Down]"}]
[null,"Health",null,"","","",{"$nulls":6},"Health",null,{"$f":"'Risks & Vulnerabilities'!F49","v":"[Drop-Down]"},{"$f":"'Risks & Vulnerabilities'!G49","v":"[Drop-Down]"},{"$f":"'Risks & Vulnerabilities'!H49","v":"[Drop-Down]"}]
[null,"Civil Protection & Emergency",null,"","","",{"$nulls":6},"Civil Protection & Emergency",null,{"$f":"'Risks & Vulnerabilities'!F50","v":"[Drop-Down]"},{"$f":"'Risks & Vulnerabilities'!G50","v":"[Drop-Down]"},{"$f":"'Risks & Vulnerabilities'!H50","v":"[Drop-Down]"}]
[null,"Tourism",null,"","","",{"$nulls":6},"Tourism",null,{"$f":"'Risks & Vulnerabilities'!F51","v":"[Drop-Down]"},{"$f":"'Risks & Vulnerabilities'!G51","v":"[Drop-Down]"},{"$f":"'Risks & Vulnerabilities'!H51","v":"[Drop-Down]"}]
[null,"Other",{"$f":"'Risks & Vulnerabilities'!D52","v":"[please specify]"},"","","",{"$nulls":6},"Other",null,{"$f":"'Risks & Vulnerabilities'!F52","v":"[Drop-Down]"},{"$f":"'Risks & Vulnerabilities'!G52","v":"[Drop-Down]"},{"$f":"'Risks & Vulnerabilities'!H52","v":"[Drop-Down]"}]
[]
[]
["4)","(Reported) Adaptation Actions by Sector"]
[null,"[Source: \"Adaptation actions\" tab]"]
[]
[{"$nulls":7},"Sector",null,"Number of reported actions",null,null,"Sector","Nber of actions"]
[{"$nulls":7},"Buildings",null,{"$f":"COUNTIF('Adaptation Actions'!B24:B38,\"Buildings\")","v":0},null,null,"Buildings",{"$f":"J66","v":0}]
[{"$nulls":7},"Transport",null,{"$f":"COUNTIF('Adaptation Actions'!B24:B38,\"Transport\")","v":0},null,null,"Transport",0]
[{"$nulls":7},"Energy",null,{"$f":"COUNTIF('Adaptation Actions'!B24:B38,\"Energy\")","v":0},null,null,"Energy",0]
[{"$nulls":7},"Water",null,{"$f":"COUNTIF('Adaptation Actions'!B24:B38,\"Water\")","v":0},null,null,"Water",0]
[{"$nulls":7},"Waste",null,{"$f":"COUNTIF('Adaptation Actions'!B24:B38,\"Waste\")","v":0},null,null,"Waste",0]
[{"$nulls":7},"Land Use Planning",null,{"$f":"COUNTIF('Adaptation Actions'!B24:B38,\"Land Use Planning\")","v":0},null,null,"Land Use Planning",0]
[{"$nulls":7},"Agriculture & Forestry",null,{"$f":"COUNTIF('Adaptation Actions'!B24:B38,\"Agriculture & Forestry\")","v":0},null,null,"Agriculture & Forestry",0]
[{"$nulls":7},"Environment & Biodiversity",null,{"$f":"COUNTIF('Adaptation Actions'!B24:B38,\"Environment & Biodiversity\")","v":0},null,null,"Environment & Biodiversity",0]
[{"$nulls":7},"Health",null,{"$f":"COUNTIF('Adaptation Actions'!B24:B38,\"Health\")","v":0},null,null,"Health",0]
[{"$nulls":7},"Civil Protection & Emergency",null,{"$f":"COUNTIF('Adaptation Actions'!B24:B38,\"Civil Protection & Emergency\")","v":0},null,null,"Civil Protection & Emergency",0]
[{"$nulls":7},"Tourism",null,{"$f":"COUNTIF('Adaptation Actions'!B24:B38,\"Tourism\")","v":0},null,null,"Tourism",0]
[{"$nulls":7},"Other",null,{"$f":"COUNTIF('Adaptation Actions'!B24:B38,\"Other\")","v":0},null,null,"Other",0]
[]
[]
[]
[]
[]
["4)","Status of the (Reported) Adaptation Actions"]
[null,"[Source: \"Adaptation Actions\" tab]"]
[]
[{"$nulls":8},"Action Status","Number of reported actions"]
[{"$nulls":8},"Not started",{"$f":"COUNTIF('Adaptation Actions'!H24:H38,\"Not started\")","v":0},{"$f":"J87/J92","v":{"v":0,"d":"0%"}}]
[{"$nulls":8},"Ongoing",{"$f":"COUNTIF('Adaptation Actions'!H24:H38,\"Ongoing\")","v":0},{"$f":"J88/J92","v":{"v":0,"d":"0%"}}]
[{"$nulls":8},"Completed",{"$f":"COUNTIF('Adaptation Actions'!H24:H38,\"Completed\")","v":0},{"$f":"J89/J92","v":{"v":0,"d":"0%"}}]
[{"$nulls":8},"Cancelled",{"$f":"COUNTIF('Adaptation Actions'!H24:H38,\"Cancelled\")","v":0},{"$f":"J90/J92","v":{"v":0,"d":"0%"}}]
[{"$nulls":8},"Not specified",{"$f":"COUNTIF('Adaptation Actions'!H24:H38,\"[Drop-Down]\")","v":15},{"$f":"J91/J92","v":{"v":1,"d":"100%"}}]
[{"$nulls":8},"Total:",{"$f":"SUM(J87:J91)","v":15}]
[]
[]
["5)","Comments"]

{"sheet":"Adaptation Indicators","index":13,"n_rows":97,"n_cols":6,"rows_kept":97,"merged":[[0,0,0,4],[1,0,1,5],[3,2,3,3],[4,2,4,3],[5,2,5,3],[6,2,6,3],[7,2,7,3],[8,0,8,5],[9,0,9,5],[10,0,10,5],[32,4,32,5],[33,0,33,5],[60,4,60,5],[61,0,61,5],[87,4,87,5],[88,0,88,5],[89,0,89,5],[90,0,90,1],[91,0,91,1],[92,0,92,1],[93,0,93,1],[94,0,94,1],[95,0,95,5],[96,0,96,1],[97,0,97,1]]}
["ANNEX - Indicators for Adaptation",{"$nulls":4},"y HOME"]
["i This annex serves as a source of inspiration only. None of these indicators are compulsory, but rather illustrative examples. Only process-based indicators (A-B-C-D  scaling system proposed in the \"Adaptation Scoreboard\") are compulsory."]
["→ Table of Contents"]
["Type of indicators","Definition","Min. Reporting Requirements",null,"Output","Link"]
["Process-based indicators","track where the local authority is in the adaptation process (through self-assessment questions & an A-B-C-D scaling system).","Compulsory (in the \"Adaptation Scoreboard\")",null,"Spider Graph\n(generated by Excel)","Ü\n(Adaptation Scoreboard)"]
["Vulnerability indicators","provide information about the level of local authority's vulnerability to climate impacts (incl. exposure and sensitivity to risk).","Optional (but highly recommended for the main vunerabilities reported in the \"Risks & Vulnerabilities\" tab)",null,"**","Ü"]
["Impact indicators","give an indication of the impacts (e.g. affecting the environment, society and the economy) measured by the local authority in its terrtory.","Optional (but highly recommended for the main impacts reported in the \"Risks & Vulnerabilities\" tab)",null,"Risk & Impact Rating Matrix (generated by Excel)","Ü"]
["Outcome indicators","quantify progress in delivering adaptation actions and outcomes (e.g. vulnerabilities reduced / resilience strenghtened) in the different sectors.","Optional (but at least 1 highly recommended per \"Key Action\" reported in the \"Actions\" tab)",null,"Key facts & figures on the Covenant (to come on the Covenant website)","Ü"]
[]
["→ Indicators"]
["i Below is a list of indicator examples (non-exhaustive) ; please select any indicators that your local authority is using to measure progress and complete the list with your own indicators - simply add/hide the rows according to your needs. Note that the indicators are classified according to the different sectors and categories you can found in the previous tabs of this present template."]
["Vulnerability Type","Vulnerability-related indicators","Unit","Base year","Expected Change","Timeframe"]
["Climatic","Number of days/nights with extreme temperature (compared to ref. annual/seasonal temperatures at day/night times)","Number of days/nights",null,"[Drop-Down]","[Drop-Down]"]
["Climatic","Frequency of heat/cold waves","Average per monthly/year",null,"[Drop-Down]","[Drop-Down]"]
["Climatic","Number of days/nights with extreme precipitation (compared to ref. annual/seasonal precipitation at day/night times for each season)","Number of days/nights",null,"[Drop-Down]","[Drop-Down]"]
["Climatic","Number of consecutive days/nights without rainfall","Number of days/nights",null,"[Drop-Down]","[Drop-Down]"]
["Socio-economic","Current population vs. projections 2020/2030/2050","Number of inhab.",null,"[Drop-Down]","[Drop-Down]"]
["Socio-economic","Population density (compared to national/regional average in year X in country/region X)","People per km2",null,"[Drop-Down]","[Drop-Down]"]
["Socio-economic","% share of sensitive population groups (e.g. elderly (65+)/young (25-) people, lonely pensioner households, low-income/unemployed households) - compared to national average in year X in country X","%",null,"[Drop-Down]","[Drop-Down]"]
["Socio-economic","% of population living in areas at risk (e.g. flood/drought/heat wave/ forest or land fire)","%",null,"[Drop-Down]","[Drop-Down]"]
["Socio-economic","% of areas non-accessible for emergency / firefighting services","%",null,"[Drop-Down]","[Drop-Down]"]
["Physical & environmental","% change in average annual/monthly temperature","%",null,"[Drop-Down]","[Drop-Down]"]
["Physical & environmental","% change in average annual/monthly precipitation","%",null,"[Drop-Down]","[Drop-Down]"]
["Physical & environmental","Length of transport network (e.g. road/rail) located in areas at risk (e.g. flood/drought/heat wave/ forest or land fire)","Km",null,"[Drop-Down]","[Drop-Down]"]
["Physical & environmental","Length of coastline / river(s) affected by extreme weather conditions / soil erosion (without adaptation)","Km",null,"[Drop-Down]","[Drop-Down]"]
["Physical & environmental","% of low-lying or at altitude areas","%",null,"[Drop-Down]","[Drop-Down]"]
["Physical & environmental","% of areas at coasts or rivers","%",null,"[Drop-Down]","[Drop-Down]"]
["Physical & environmental","% of protected (ecologically and/or culturally sensitive) areas / % of forest cover","%",null,"[Drop-Down]","[Drop-Down]"]
["Physical & environmental","% of (e.g. residential/commercial/agricultural/industrial/touristic) areas at risk (e.g. flood/drought/heat wave/ forest or land fire)","%",null,"[Drop-Down]","[Drop-Down]"]
["Physical & environmental","Current energy consumption per capita vs. projections 2020/2030/2050","MWh",null,"[Drop-Down]","[Drop-Down]"]
["Physical & environmental","Current water comsumption per capita vs. projections 2020/2030/2050","m3",null,"[Drop-Down]","[Drop-Down]"]
["Other [please specify]","Other [please specify]","[please specify]",null,"[Drop-Down]","[Drop-Down]"]
[{"$nulls":4},"Ü RISKS & VULNERABILITIES"]
[]
["Impacted Sector(s)","Impact-related indicators","Unit","Base year","Expected Change","Timeframe"]
["Buildings","Number or % of (public/residential/tertiary) buildings damaged by extreme weather conditions/events","(per year / over a certain period)",null,"[Drop-Down]","[Drop-Down]"]
["Transport, Energy, Water, Waste, ICT","Number or % of transport/energy/water/waste/ICT infrastructure damaged by extreme weather conditions/events","(per year / over a certain period)",null,"[Drop-Down]","[Drop-Down]"]
["Land Use Planning","% of grey/blue/green areas affected by extreme weather conditions/events (e.g. Heat Island Effect, Flood, Rockfalls and/or Landslides, Forest/Land Fire)","%",null,"[Drop-Down]","[Drop-Down]"]
["Transport, Energy, Water, Waste, Civil Protection & Emergency","Number of days with public service interruptions (e.g. energy/water supply, health/civil protection/emergency services, waste) ",null,null,"[Drop-Down]","[Drop-Down]"]
["Transport, Energy, Water, Waste, Civil Protection & Emergency","Average length (in hours) of the public service interruptions (e.g. energy/water supply, public transport traffic, health/civil protection/emergency services) ","hours",null,"[Drop-Down]","[Drop-Down]"]
["Health","Number of people injured/evacuated/relocated due to extreme weather event(s) (e.g. heat or cold waves)","(per year / over a certain period)",null,"[Drop-Down]","[Drop-Down]"]
["Health","Number of deaths related to extreme weather event(s) (e.g. heat or cold waves)","(per year / over a certain period)",null,"[Drop-Down]","[Drop-Down]"]
["Civil Protection & Emergency","Average response time (in min.) for police/fire-fighters/emergency services in case of extreme weather events","min.",null,"[Drop-Down]","[Drop-Down]"]
["Health","Number of water quality warnings issued","%",null,"[Drop-Down]","[Drop-Down]"]
["Health","Number of air quality warnings issued",null,null,"[Drop-Down]","[Drop-Down]"]
["Environment & Biodiversity","% of areas affected by soil erosion / soil quality degradation","%",null,"[Drop-Down]","[Drop-Down]"]
["Environment & Biodiversity","% of habitat losses from extreme weather event(s)","%",null,"[Drop-Down]","[Drop-Down]"]
["Environment & Biodiversity","% change in number of native species","%",null,"[Drop-Down]","[Drop-Down]"]
["Environment & Biodiversity","% of native (animal/plant) species affected by diseases related to extreme weather conditions/events","%",null,"[Drop-Down]","[Drop-Down]"]
["Agriculture & Forestry","% of agriculture losses from extreme weather conditions/events (e.g. drought/water scarcity, soil erosion)","%",null,"[Drop-Down]","[Drop-Down]"]
["Agriculture & Forestry","% of livestock losses from extreme weather conditions","%",null,"[Drop-Down]","[Drop-Down]"]
["Agriculture & Forestry","% change in crop yield / evolution of the annual grassland productivity","%",null,"[Drop-Down]","[Drop-Down]"]
["Agriculture & Forestry","% of livestock losses from pests/pathogens","%",null,"[Drop-Down]","[Drop-Down]"]
["Agriculture & Forestry","% of timber losses from pests/pathogens","%",null,"[Drop-Down]","[Drop-Down]"]
["Agriculture & Forestry","% change in Forest composition","%",null,"[Drop-Down]","[Drop-Down]"]
["Agriculture & Forestry","% change in water abstraction","%",null,"[Drop-Down]","[Drop-Down]"]
["Tourism","% change in tourist flows / tourism activities","%",null,"[Drop-Down]","[Drop-Down]"]
["Other","€ annual direct economic losses (e.g. in commercial/agricultural/industrial/touristic sectors) due to extreme weather event(s)","€/year",null,"[Drop-Down]","[Drop-Down]"]
["Other","€ annual amount of compensation received (e.g. insurance)","€/year",null,"[Drop-Down]","[Drop-Down]"]
["Other","Other [please specify]",null,null,"[Drop-Down]","[Drop-Down]"]
[{"$nulls":4},"Ü RISKS & VULNERABILITIES"]
[]
["Concerned Sector(s)","Outcome-related indicators","Unit","Base year","Expected Change","Timeframe"]
["Buildings","% of (public/residential/tertiary) buildings retrofitted for adaptive resilience","%",null,"[Drop-Down]","[Drop-Down]"]
["Transport, Energy, Water, Waste, ICT","% of transport/energy/water/waste/ICT infrastructure retrofitted for adaptive resilience","%",null,"[Drop-Down]","[Drop-Down]"]
["Land Use Planning","% change in green & blue infrastructure/areas (surface)","%",null,"[Drop-Down]","[Drop-Down]"]
["Land Use Planning","% change in connected green and blue areas","%",null,"[Drop-Down]","[Drop-Down]"]
["Land Use Planning","% change in sealed surfaces / soil moisture level","%",null,"[Drop-Down]","[Drop-Down]"]
["Land Use Planning","% change in runoff of rainwater overflows (due to change in soil infiltration)",null,null,"[Drop-Down]","[Drop-Down]"]
["Land Use Planning","% change in shading (& related change in the Urban Heat Island effect)","%",null,"[Drop-Down]","[Drop-Down]"]
["Land Use Planning","% of coastline designated for managed realignment","%",null,"[Drop-Down]","[Drop-Down]"]
["Water","% change in water loss (e.g. due to leakage in the water distribution system)",null,null,"[Drop-Down]","[Drop-Down]"]
["Water","% change in storage of rain water (for reuse)","%",null,"[Drop-Down]","[Drop-Down]"]
["Waste","% change in solid waste collected / recycled / disposed of / burned",null,null,"[Drop-Down]","[Drop-Down]"]
["Environment & Diversity","% of habitats restored / % of species protected ","%",null,"[Drop-Down]","[Drop-Down]"]
["Agriculture & Forestry","% change in crop yield due to adaptation measures","%",null,"[Drop-Down]","[Drop-Down]"]
["Agriculture & Forestry","% change in water consumption for agriculture/irrigation","%",null,"[Drop-Down]","[Drop-Down]"]
["Agriculture & Forestry","% of forest restored","%",null,"[Drop-Down]","[Drop-Down]"]
["Tourism","% change in tourist flows","%",null,"[Drop-Down]","[Drop-Down]"]
["Tourism","% change in tourism activities","%",null,"[Drop-Down]","[Drop-Down]"]
["Other","% change in costs for recovery and reconstruction associated with extreme climate events","%",null,"[Drop-Down]","[Drop-Down]"]
["Other","€ investment in adaptation research (e.g. soil conservation, water/energy efficiency…) by the city / by other stakeholders","€",null,"[Drop-Down]","[Drop-Down]"]
["Other","€ investment in education / in health & emergency systems by the city","€",null,"[Drop-Down]","[Drop-Down]"]
["Other","Number of awareness-raising events targeting citizens and local stakeholders",null,null,"[Drop-Down]","[Drop-Down]"]
["Other","Number of training sessions targeting staff",null,null,"[Drop-Down]","[Drop-Down]"]
["Other","Number of direct beneficiaries involved in adaptation process milestone decision making through community participatory activities",null,null,"[Drop-Down]","[Drop-Down]"]
["Other","Other [please specify]",null,null,"[Drop-Down]","[Drop-Down]"]
[{"$nulls":4},"Ü ADAPTATION ACTIONS"]
[]
["→ Relevant Resources"]
["EUROSTAT Urban Audit – Database"]
["EEA Urban Vulnerability Map book – Tool"]
["EEA Urban Vulnerability Map book – Factsheets"]
["Urban Vulnerability Indicators – Technical Report (ETC-CCA & ETC-SIA, 2012)"]
["\"World Council on City Data\" – Open Data Portal"]
["ISO 37120 Sustainable Development of Communities: Indicators for City Services and Quality of Life (ISO May 2014) - Note: only informative sessions of standards are publicly available."]
["Planning for Adaptation to Climate Change  –  Guidance Document (ACT Life project, 2013)"]

{"sheet":"EFs","index":14,"n_rows":28,"n_cols":28,"rows_kept":28,"merged":[[0,0,0,13],[6,0,6,1],[6,2,6,13],[6,14,6,27],[7,0,7,1],[7,3,7,4],[7,9,7,11],[7,12,7,13],[7,14,7,15],[7,16,7,17],[7,18,7,19],[7,22,7,23],[7,26,8,26],[7,27,8,27],[8,0,8,1],[8,2,9,2],[8,3,9,3],[8,4,9,4],[8,5,9,5],[8,6,9,6],[8,7,9,7],[8,8,9,8],[8,9,9,9],[8,10,9,10],[8,11,9,11],[8,12,9,12],[8,13,9,13],[8,14,8,15],[8,16,8,17],[8,18,8,19],[8,22,8,23],[9,0,9,1],[10,0,11,0],[12,0,13,0],[12,14,12,15],[12,16,12,17],[12,18,12,19],[13,14,13,15],[13,16,13,17],[13,18,13,19],[20,2,20,27],[21,2,21,27]]}
["Fuel Emission Factors Database",{"$nulls":17},"y HOME"]
[]
[]
[]
[]
[]
[null,null,"Fossil fuels",{"$nulls":11},"Renewable energies"]
["CoM Template Energy carriers",null,"Natural gas","Liquid gas",null,"Heating Oil","Diesel","Gasoline","Lignite","Coal",null,null,"Other fossil fuels",null,"Plant oil",null,"Biofuel \n(1)",null,"Biofuel\n(2)",null,"Other biomass\n(1)","Other biomass\n(2)","Other biomass\n(3)",null,"Other biomass\n(4)","Other biomass\n(5)","Solar thermal","Geothermal"]
["IPCC Energy carriers",null,"Natural gas","Liquified Petroleum Gases ","Natural Gas Liquids","Gas/Diesel oil","Gas/Diesel oil","Motor gasoline","Lignite","Anthracite","Other Bituminous Coal","Sub-Bitominous Coal","Municipal Wastes (non-biomass fraction)","Peat","Other Liquid Biofuels",null,"Biogasoline",null,"Biodiesels",null,"Biogas","Municipal Wastes (biomass fraction)","Wood ",null,"Wood Waste","Other Primary solid biomass"]
["Sustainability criteria (a)",{"$nulls":13},"(s)","(ns)","(s)","(ns)","(s)","(ns)","-","-","(s)","(ns)","-","-","-","-"]
["IPCC","t CO2/MWh ",0.202,0.227,0.231,0.267,0.267,0.249,0.364,0.354,0.341,0.346,{"v":0.33,"d":"0.330"},0.382,{"v":0,"d":"0.000"},0.287,{"v":0,"d":"0.000"},0.255,{"v":0,"d":"0.000"},0.255,0.197,{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},0.403,0.403,{"v":0.36,"d":"0.360"},"-","-"]
[null,"t CO2 eq./MWh (b)",0.202,0.227,0.232,0.268,"0,268 (c)","0,250 (c)",0.365,0.356,0.342,0.348,0.337,0.383,0.001,0.302,0.001,0.256,0.001,0.256,0.197,0.007,0.007,{"v":0.41,"d":"0.410"},{"v":0.41,"d":"0.410"},0.367,"-","-"]
["LCA","t CO2/MWh",0.221,"n.a.","n.a.",0.292,0.292,0.299,0.368,0.379,0.366,0.371,0.181,0.386,0.171,null,0.194,null,0.147,null,"n.a.",0.107,0.006,0.409,0.193,"n.a","n.a.","n.a. (h)"]
[null,"t CO2 eq./MWh",0.237,"n.a.","n.a.",0.305,0.305,0.307,0.375,0.393,{"v":0.38,"d":"0.380"},0.385,0.174,0.392,"0,182 (d)",null,"0,206 (e)",null,"0,156 (f) ",null,"n.a.",0.106,0.013,"0,416 (g)",0.184,"n.a","n.a.","n.a. (h)"]
[]
[]
[{"$nulls":15},"s) if sustainability criteria during production are fulfilled"]
[{"$nulls":15},"ns) if sustainability criteria during production are not fulfilled"]
[]
[]
[null,null,"         a.            IPCC emission factor should be reported zero if the biofuels/biomass meet sustainability criteria; fossil fuel emission factors to be used if biofuels are unsustainable.(s) sustainable, (ns) not sustainable "]
[null,null,"         b.            Taking into consideration also the CH4 and the N2O emissions from combustion in stationary sources"]
[null,null,"         c.            If choosing to report in CO2eq, please consider that the emission factors for the transport sector are with up to 3% higher than the values provided here, which are characteristic for stationary sources"]
[null,null,"         d.            Conservative figure regarding pure plant oil from palm oil. Note that this figure represents the worst ethanol plant oil pathway and does not necessarily represent a typical pathway. This figure does not include the impacts of direct and indirect land use change. Had these been considered, the default value could be as high as 9 t CO2-eq/MWh, in the case of conversion of forest land in the tropics. "]
[null,null,"         e.            Conservative figure regarding ethanol from wheat. Note that this figure represents the worst ethanol pathway and does not necessarily represent a typical pathway. This figure does not include the impacts of direct and indirect land use change. Had these been considered, the default value could be as high as 9 t CO2-eq/MWh, in the case of conversion of forest land in the tropics"]
[null,null,"         f.             Conservative figure regarding biodiesel from palm oil. Note that this figure represents the worst biodiesel pathway and does not necessarily represent a typical pathway. This figure does not include the impacts of direct and indirect land use change. Had these been considered, the default value could be as high as 9 t CO2-eq/MWh, in the case of conversion of forest land in the tropics."]
[null,null,"         g.            The figure reflects the production and local/regional transport of wood, representative for Germany, assuming: spruce log with bark; reforested managed forest; production mix entry to saw mill, at plant; and 44% water content. Carbon dioxide incorporation is considered. The local authority using this emission factor is recommended to check that it is representative for the local circumstances and to develop an own emission factor if the circumstances are different. These are only one set of reference values and another LCA case study could be performed to define a fork spanning the range of variation. This will be done for the next update of this guidebook.. "]
[null,null,"         h.            Data not available, but emissions are assumed to be low (however the emissions from electricity consumption of heat pumps is to be estimated using the emission factors for electricity). Local authorities using these technologies are encouraged to try to obtain such data."]

{"sheet":"Categories","index":15,"n_rows":79,"n_cols":18,"rows_kept":79,"hidden":true,"merged":[[0,0,0,15],[39,6,40,6],[41,6,42,6],[43,6,44,6]]}
["Categories"]
[]
[]
["A","AREA OF INTERVENTION",{"$nulls":5},"B","POLICY INSTRUMENT",{"$nulls":6},"C","Origin of the action","BoE"]
[{"$nulls":17},"ê"]
["A1","Municipal - Residential - Tertiary Buildings",{"$nulls":5},"B1","Buildings",{"$nulls":6},"C1","Local authority"]
["A11","Building envelope",{"$nulls":5},"B11","Awareness raising / training",{"$nulls":6},"C2","Covenant Territorial Coordiantor"]
["A12","Renewable energy for space heating and hot water",{"$nulls":5},"B12","Energy management",{"$nulls":6},"C3","Other (national, regional,…)"]
["A13","Energy efficiency in space heating and hot water",{"$nulls":5},"B13","Energy certification / labelling ",{"$nulls":6},"C4","Not possible to say"]
["A14","Energy efficient lighting systems",{"$nulls":5},"B14","Energy suppliers obligations"]
["A15","Energy efficient electrical appliances",{"$nulls":5},"B15","Energy / carbon taxes"]
["A16","Integrated action (all above)",{"$nulls":5},"B16","Grants and subsidies"]
["A17","Information and Communication Technologies",{"$nulls":5},"B17","Third party financing. PPP"]
["A18","Behavioural changes",{"$nulls":5},"B18","Public procurement"]
["A19","Other",{"$nulls":5},"B19","Building standards"]
[{"$nulls":7},"B110","Land use planning regulation"]
[{"$nulls":7},"B111","Not applicable"]
[{"$nulls":7},"B112","Other"]
[]
["A2","Public Lighting",{"$nulls":5},"B2","Public Lighting"]
["A21","Energy efficiency ",{"$nulls":5},"B21","Energy management"]
["A23","Integrated renewable power",{"$nulls":5},"B22","Energy suppliers obligations"]
["A24","Information and Communication Technologies",{"$nulls":5},"B23","Third party financing. PPP"]
["A25","Other",{"$nulls":5},"B24","Public procurement"]
[{"$nulls":7},"B25","Not applicable"]
[{"$nulls":7},"B26","Other"]
[]
["A3","Industry ",{"$nulls":5},"B3","Industry"]
["A31","     Energy efficiency in industrial processes",{"$nulls":5},"B31","Awareness raising / training"]
["A32","     Energy efficiency in buildings",{"$nulls":5},"B32","Energy management"]
["A33","     Renewable energy ",{"$nulls":5},"B33","Energy certification / labelling "]
["A34","     Information and Communication Technologies",{"$nulls":5},"B34","Energy performance standards"]
["A35","     Other",{"$nulls":5},"B35","Energy / carbon taxes"]
[{"$nulls":7},"B36","Grants and subsidies"]
[{"$nulls":7},"B37","Third party financing. PPP"]
[{"$nulls":7},"B38","Not applicable"]
[{"$nulls":7},"B39","Other"]
[]
["A4","Municipal - Public - Private Transport",{"$nulls":5},"B4","Transport"]
["A41","Cleaner/efficient vehicles",{"$nulls":5},"B41","Awareness raising/training"]
["A42","Electric vehicles (incl. infrastructure)",{"$nulls":5},"B42","Integrated ticketing and charging"]
["A43","Modal shift to public transport",{"$nulls":5},"B43","Grants and subsidies"]
["A44","Modal shift to walking & cycling ",{"$nulls":5},"B44","Road pricing"]
["A45","Car sharing/pooling",{"$nulls":5},"B45","Land use planning regulation"]
["A46","Improvement of logistics and urban freight transport",{"$nulls":5},"B46","Transport / mobility planning regulation"]
["A47","Road network optimisation",{"$nulls":5},"B47","Public procurement"]
["A48","Mixed use development and sprawl containment",{"$nulls":5},"B48","Voluntary agreements with stakeholders"]
["A49","Information and Communication Technologies",{"$nulls":5},"B49","Not applicable"]
["A410","Eco-driving",{"$nulls":5},"B410","Other"]
["A411","Other"]
[]
["A5","Local Electricity Production",{"$nulls":5},"B5","Local Electricity Production"]
["A51","Hydroelectric power",{"$nulls":5},"B51","Awareness raising / training"]
["A52","Wind power",{"$nulls":5},"B52","Energy suppliers obligations "]
["A53","Photovoltaics",{"$nulls":5},"B53","Grants and subsidies"]
["A54","Biomass power plant",{"$nulls":5},"B54","Third party financing. PPP"]
["A55","Combined Heat and Power",{"$nulls":5},"B55","Public procurement"]
["A56","Smart grids",{"$nulls":5},"B56","Building standards"]
["A57","Other",{"$nulls":5},"B57","Land use planning"]
[{"$nulls":7},"B58","Not applicable"]
[{"$nulls":7},"B59","Other"]
[]
[]
["A6","Local heat/cold Production",{"$nulls":5},"B6","Local heat/cold Production"]
["A61","Combined Heat and Power",{"$nulls":5},"B61","Awareness raising / training"]
["A62","District heating/cooling plant",{"$nulls":5},"B62","Energy suppliers obligations "]
["A63","District heating/cooling network (new, expansion, refurbishment)",{"$nulls":5},"B63","Grants and subsidies"]
["A64","Other",{"$nulls":5},"B64","Third party financing. PPP"]
[{"$nulls":7},"B65","Building standards"]
[{"$nulls":7},"B66","Land use planning regulation"]
[{"$nulls":7},"B67","Not applicable"]
[{"$nulls":7},"B68","Other"]
[]
["A7","Other",{"$nulls":5},"B7","Other"]
["A71","Urban regeneration",{"$nulls":5},"B71","Awareness raising / training"]
["A72","Waste & wastewater management",{"$nulls":5},"B72","Land use planning"]
["A73","Tree planting in urban areas",{"$nulls":5},"B73","Not applicable"]
["A74","Agriculture and forestry related",{"$nulls":5},"B74","Other"]
["A75","Other"]

{"sheet":"Drop-down Menus","index":16,"n_rows":151,"n_cols":10,"rows_kept":151,"hidden":true,"merged":[[0,0,0,4]]}
["Drop-down menus",{"$nulls":8},"y HOME"]
["Strategy",null,"Risks & Vulnerabilities",{"$nulls":5},"Actions"]
["Level of involvement",null,"Hazard risk level","Expected change","Impact level","Occurrence likelihood","Timeframe",null,"Sectors","Implementation Status"]
["[Drop-Down]",null,"[Drop-Down]","[Drop-Down]","[Drop-Down]","[Drop-Down]","[Drop-Down]",null,"[Drop-Down]","[Drop-Down]"]
["Low",null,"Low","Increase","Low","Unlikely","Current",null,"Buildings","Not started"]
["Medium",null,"Moderate","Decrease","Moderate","Possible","Short-term",null,"Transport","Ongoing"]
["High",null,"High","No change","High","Likely","Medium-term",null,"Energy","Completed"]
[null,null,"Not Known","Not known","Not Known","Not known","Long-term",null,"Water","Cancelled"]
["Intensity",{"$nulls":5},"Not known",null,"Waste"]
["[Drop-Down]",{"$nulls":7},"Land Use Planning"]
["Little",null,"Yes/No Questions","Key Action",{"$nulls":4},"Agriculture & Forestry"]
["Fair",null,"[√/×]","[Please select]",{"$nulls":4},"Environment & Biodiversity"]
["Strong",null,"√","☼",{"$nulls":4},"Health"]
["Not applicable",null,"×",{"$nulls":5},"Civil Protection & Emergency"]
[{"$nulls":8},"Tourism"]
[{"$nulls":8},"Other"]
[]
[{"$nulls":8},"Language"]
[{"$nulls":8},"[Drop-Down]"]
[{"$nulls":8},"English"]
[{"$nulls":8},"National Language"]
[]
[{"$nulls":8},"Timeframe"]
[{"$nulls":8},"[Drop-Down]"]
[{"$nulls":8},"Not known"]
[{"$nulls":8},1990]
[{"$nulls":8},1991]
[{"$nulls":8},1992]
[{"$nulls":8},1993]
[{"$nulls":8},1994]
[{"$nulls":8},1995]
[{"$nulls":8},1996]
[{"$nulls":8},1997]
[{"$nulls":8},1998]
[{"$nulls":8},1999]
[{"$nulls":8},2000]
[{"$nulls":8},2001]
[{"$nulls":8},2002]
[{"$nulls":8},2003]
[{"$nulls":8},2004]
[{"$nulls":8},2005]
[{"$nulls":8},2006]
[{"$nulls":8},2007]
[{"$nulls":8},2008]
[{"$nulls":8},2009]
[{"$nulls":8},2010]
[{"$nulls":8},2011]
[{"$nulls":8},2012]
[{"$nulls":8},2013]
[{"$nulls":8},2014]
[{"$nulls":8},2015]
[{"$nulls":8},2016]
[{"$nulls":8},2017]
[{"$nulls":8},2018]
[{"$nulls":8},2019]
[{"$nulls":8},2020]
[{"$nulls":8},2021]
[{"$nulls":8},2022]
[{"$nulls":8},2023]
[{"$nulls":8},2024]
[{"$nulls":8},2025]
[{"$nulls":8},2026]
[{"$nulls":8},2027]
[{"$nulls":8},2028]
[{"$nulls":8},2029]
[{"$nulls":8},2030]
[{"$nulls":8},2031]
[{"$nulls":8},2032]
[{"$nulls":8},2033]
[{"$nulls":8},2034]
[{"$nulls":8},2035]
[{"$nulls":8},2036]
[{"$nulls":8},2037]
[{"$nulls":8},2038]
[{"$nulls":8},2039]
[{"$nulls":8},2040]
[{"$nulls":8},2041]
[{"$nulls":8},2042]
[{"$nulls":8},2043]
[{"$nulls":8},2044]
[{"$nulls":8},2045]
[{"$nulls":8},2046]
[{"$nulls":8},2047]
[{"$nulls":8},2048]
[{"$nulls":8},2049]
[{"$nulls":8},2050]
[]
[{"$nulls":8},"Timeframe (without \"not known\")"]
[{"$nulls":8},"[Drop-Down]"]
[{"$nulls":8},"Not known"]
[{"$nulls":8},1990]
[{"$nulls":8},1991]
[{"$nulls":8},1992]
[{"$nulls":8},1993]
[{"$nulls":8},1994]
[{"$nulls":8},1995]
[{"$nulls":8},1996]
[{"$nulls":8},1997]
[{"$nulls":8},1998]
[{"$nulls":8},1999]
[{"$nulls":8},2000]
[{"$nulls":8},2001]
[{"$nulls":8},2002]
[{"$nulls":8},2003]
[{"$nulls":8},2004]
[{"$nulls":8},2005]
[{"$nulls":8},2006]
[{"$nulls":8},2007]
[{"$nulls":8},2008]
[{"$nulls":8},2009]
[{"$nulls":8},2010]
[{"$nulls":8},2011]
[{"$nulls":8},2012]
[{"$nulls":8},2013]
[{"$nulls":8},2014]
[{"$nulls":8},2015]
[{"$nulls":8},2016]
[{"$nulls":8},2017]
[{"$nulls":8},2018]
[{"$nulls":8},2019]
[{"$nulls":8},2020]
[{"$nulls":8},2021]
[{"$nulls":8},2022]
[{"$nulls":8},2023]
[{"$nulls":8},2024]
[{"$nulls":8},2025]
[{"$nulls":8},2026]
[{"$nulls":8},2027]
[{"$nulls":8},2028]
[{"$nulls":8},2029]
[{"$nulls":8},2030]
[{"$nulls":8},2031]
[{"$nulls":8},2032]
[{"$nulls":8},2033]
[{"$nulls":8},2034]
[{"$nulls":8},2035]
[{"$nulls":8},2036]
[{"$nulls":8},2037]
[{"$nulls":8},2038]
[{"$nulls":8},2039]
[{"$nulls":8},2040]
[{"$nulls":8},2041]
[{"$nulls":8},2042]
[{"$nulls":8},2043]
[{"$nulls":8},2044]
[{"$nulls":8},2045]
[{"$nulls":8},2046]
[{"$nulls":8},2047]
[{"$nulls":8},2048]
[{"$nulls":8},2049]
[{"$nulls":8},2050]

{"sheet":"extra","index":17,"n_rows":218,"n_cols":8,"rows_kept":218,"hidden":true,"merged":[[1,4,1,5]]}
["Drop-down menus"]
[{"$nulls":4},"Strategy"]
["Reduction type",null,"x","Level of involvement","Time period - Start","Time period - Final","Long term target year"]
["absolute",null,null,"High",1990,1990,2031]
["per capita",null,"x","Medium",1991,1991,2032]
[{"$nulls":3},"Low",1992,1992,2033]
["Status of implementation",{"$nulls":3},1993,1993,2034]
["Ongoing",{"$nulls":3},1994,1994,2035]
["Completed",{"$nulls":3},1995,1995,2036]
["Postponed",{"$nulls":3},1996,1996,2037]
["Not started",{"$nulls":3},1997,1997,2038]
["New",{"$nulls":3},1998,1998,2039]
[{"$nulls":4},1999,1999,2040]
["Option",{"$nulls":3},2000,2000,2041]
["BEI (option 1)",{"$nulls":3},2001,2001,2042]
["MEI 1 (option 2)",{"$nulls":3},2002,2002,2043]
["MEI 2 (option 2)",{"$nulls":3},2003,2003,2044]
["MEI 3 (option 2)",{"$nulls":3},2004,2004,2045]
["BAU (option 3)",{"$nulls":3},2005,2005,2046]
[{"$nulls":4},2006,2006,2047]
[{"$nulls":4},2007,2007,2048]
["Timeframe",{"$nulls":3},2008,2008,2049]
[1999,{"$nulls":3},2009,2009,2050]
[2000,{"$nulls":3},2010,2010,2051]
[2001,{"$nulls":3},2011,2011,2052]
[2002,{"$nulls":3},2012,2012,2053]
[2003,{"$nulls":3},2013,2013,2054]
[2004,{"$nulls":3},2014,2014,2055]
[2005,{"$nulls":3},2015,2015,2056]
[2006,{"$nulls":3},2016,2016,2057]
[2007,{"$nulls":3},2017,2017,2058]
[2008,{"$nulls":3},2018,2018,2059]
[2009,{"$nulls":3},2019,2019,2060]
[2010,{"$nulls":3},2020,2020]
[2011,{"$nulls":3},2021,2021]
[2012,{"$nulls":3},2022,2022]
[2013,{"$nulls":3},2023,2023]
[2014,{"$nulls":3},2024,2024]
[2015,{"$nulls":3},2025,2025]
[2016,{"$nulls":3},2026,2026]
[2017,{"$nulls":3},2027,2027]
[2018,{"$nulls":3},2028,2028]
[2019,{"$nulls":3},2029,2029]
[2020,{"$nulls":3},2030,2030]
[2021,{"$nulls":4},2031]
[2022,{"$nulls":4},2032]
[2023,{"$nulls":4},2033]
[2024,{"$nulls":4},2034]
[2025,{"$nulls":4},2035]
[2026,{"$nulls":4},2036]
[2027,{"$nulls":4},2037]
[2028,{"$nulls":4},2038]
[2029,{"$nulls":4},2039]
[2030,{"$nulls":4},2040]
[2031,{"$nulls":4},2041]
[2032,{"$nulls":4},2042]
[2033,{"$nulls":4},2043]
[2034,{"$nulls":4},2044]
[2035,{"$nulls":4},2045]
[2036,{"$nulls":4},2046]
[2037,{"$nulls":4},2047]
[2038,{"$nulls":4},2048]
[2039,{"$nulls":4},2049]
[2040,{"$nulls":4},2050]
[2041]
[2042]
[2043]
[2044]
[2045]
[2046]
[2047]
[2048]
[2049]
[2050]
[]
[]
["Base year 2020","Base year 2030","Base year other","Time period","Time period","Day","Month","Year"]
[1990,1990,1990,2000,2000,1,"January",1990]
[1991,1991,1991,2001,2001,2,"February",1991]
[1992,1992,1992,2002,2002,3,"March",1992]
[1993,1993,1993,2003,2003,4,"April",1993]
[1994,1994,1994,2004,2004,5,"May",1994]
[1995,1995,1995,2005,2005,6,"June",1995]
[1996,1996,1996,2006,2006,7,"July",1996]
[1997,1997,1997,2007,2007,8,"August",1997]
[1998,1998,1998,2008,2008,9,"September",1998]
[1999,1999,1999,2009,2009,10,"October",1999]
[2000,2000,2000,2010,2010,11,"November",2000]
[2001,2001,2001,2011,2011,12,"December",2001]
[2002,2002,2002,2012,2012,13,null,2002]
[2003,2003,2003,2013,2013,14,null,2003]
[2004,2004,2004,2014,2014,15,null,2004]
[2005,2005,2005,2015,2015,16,null,2005]
[2006,2006,2006,2016,2016,17,null,2006]
[2007,2007,2007,2017,2017,18,null,2007]
[2008,2008,2008,2018,2018,19,null,2008]
[2009,2009,2009,2019,2019,20,null,2009]
[2010,2010,2010,2020,2020,21,null,2010]
[2011,2011,2011,2021,2021,22,null,2011]
[2012,2012,2012,2022,2022,23,null,2012]
[2013,2013,2013,2023,2023,24,null,2013]
[2014,2014,2014,2024,2024,25,null,2014]
[2015,2015,2015,2025,2025,26,null,2015]
[2016,2016,2016,2026,2026,27,null,2016]
[2017,2017,2017,2027,2027,28,null,2017]
["BAU 2020",2018,2018,2028,2028,29,null,2018]
[null,2019,2019,2029,2029,30,null,2019]
[null,2020,2020,2030,2030,31,null,2020]
[null,2021,2021,2031,2031,null,null,2021]
[null,2022,2022,2032,2032,null,null,2022]
[null,2023,2023,2033,2033,null,null,2023]
[null,2024,2024,2034,2034,null,null,2024]
[null,2025,2025,2035,2035,null,null,2025]
[null,"BAU 2030",2026,2036,2036,null,null,2026]
[null,null,2027,2037,2037,null,null,2027]
[null,null,2028,2038,2038,null,null,2028]
[null,null,2029,2039,2039,null,null,2029]
[null,null,2030,2040,2040,null,null,2030]
[null,null,"BAU",2041,2041]
[{"$nulls":3},2042,2042]
[{"$nulls":3},2043,2043]
[{"$nulls":3},2044,2044]
[{"$nulls":3},2045,2045]
[{"$nulls":3},2046,2046]
[{"$nulls":3},2047,2047]
["Monitoring emission year","Baseline emission year",null,2048,2048]
[1991,1990,null,2049,2049]
[1992,1991,null,2050,2050]
[1993,1992]
[1994,1993]
[1995,1994,null,null,"Time period - Start"]
[1996,1995,null,null,1990]
[1997,1996,null,null,1991]
[1998,1997,null,null,1992]
[1999,1998,null,null,1993]
[2000,1999,null,null,1994]
[2001,2000,null,null,1995]
[2002,2001,null,null,1996]
[2003,2002,null,null,1997]
[2004,2003,null,null,1998]
[2005,2004,null,null,1999]
[2006,2005,null,null,2000]
[2007,2006,null,null,2001]
[2008,2007,null,null,2002]
[2009,2008,null,null,2003]
[2010,2009,null,null,2004]
[2011,2010,null,null,2005]
[2012,2011,null,null,2006]
[2013,2012,null,null,2007]
[2014,2013,null,null,2008]
[2015,2014,null,null,2009]
[2016,2015,null,null,2010]
[2017,2016,null,null,2011]
[2018,2017,null,null,2012]
[2019,2018,null,null,2013]
[2020,2019,null,null,2014]
[2021,2020,null,null,2015]
[2022,{"$nulls":3},2016]
[2023,{"$nulls":3},2017]
[2024,{"$nulls":3},2018]
[2025,{"$nulls":3},2019]
[2026,{"$nulls":3},2020]
[2027,{"$nulls":3},2021]
[2028,{"$nulls":3},2022]
[2029,{"$nulls":3},2023]
[2030,{"$nulls":3},2024]
[{"$nulls":4},2025]
[{"$nulls":4},2026]
["Target year",{"$nulls":3},2027]
[2021,{"$nulls":3},2028]
[2022,{"$nulls":3},2029]
[2023,{"$nulls":3},2030]
[2024]
[2025]
[2026]
[2027]
[2028]
[2029]
[2030]
[2031]
[2032]
[2033]
[2034]
[2035]
[2036]
[2037]
[2038]
[2039]
[2040]
[2041]
[2042]
[2043]
[2044]
[2045]
[2046]
[2047]
[2048]
[2049]
[2050]
[2051]
[2052]
[2053]
[2054]
[2055]
[2056]
[2057]
[2058]
[2059]
[2060]
[]
[]
[]
[]
["Barriers Implementation"]
["Little"]
["Fair"]
["Strong"]
["Not applicable"]