{"text_format":"1","workbook":"xlsx","n_sheets":11,"sheets":["Explanation","Glossary","Overview","Energy","Waste","Water","Transport","Buildings","ICT","Results_collate","Lists"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":0,"comments":2,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Explanation","index":0,"n_rows":1,"n_cols":17,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"v0.1"]

{"sheet":"Glossary","index":1,"n_rows":17,"n_cols":17,"rows_kept":17,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"v0.1"]
[]
[null,"Glossary"]
[]
[null,"Consolidation centres","A physical node within a freight supply chain which allows the grouping of smaller consignments, minimising the number of deliveries to the end customer."]
[null,"Cooling Degree Day","See CIBSE definition","https://www.cibseknowledgeportal.co.uk/component/dynamicdatabase/?layout=publication&revision_id=76 "]
[null,"Fibre optic connection ","Those buildings with fibre-optic data connection all the way to the building (fibre-to-home)"]
[null,"Fuel poverty-","Those customers spending over 10% of household income on energy bills"]
[null,"Gini coefficient","See World Bank definition","http://web.worldbank.org/WBSITE/EXTERNAL/TOPICS/EXTPOVERTY/EXTPA/0,,contentMDK:20238991~menuPK:492138~pagePK:148956~piPK:216618~theSitePK:430367,00.html  "]
[null,"Heating Degree Days","See CIBSE definition","https://www.cibseknowledgeportal.co.uk/component/dynamicdatabase/?layout=publication&revision_id=76 "]
[null,"Low-emission buses","Those buses hybrid drivetrains, fully electric drivetrains, or fuel-cell technology."]
[null,"Plug loads","Electrical loads served through electrical sockets (i.e. receptacles)"]
[null,"Primary energy consumption","direct use at the source, or supply to users without transformation, of energy that has not been subjected to any conversion or transformation process."]
[null,"Public services"," Municipal buildings, libraries, hospitals, schools, prisons, etc."]
[null,"Rail","Transport mode which utilises fixed rail tracks for wheeled vehicles"]
[null,"Segregated cycle lanes","Cycle lanes which are intended only for cyclists"]
[null,"Space conditioning","Space cooling"]

{"sheet":"Overview","index":2,"n_rows":118,"n_cols":22,"rows_kept":118,"cut":false,"hidden":false,"merged":[[116,7,116,13],[89,5,90,11],[92,9,92,13],[4,8,4,13],[6,8,6,13],[8,8,8,13],[10,8,10,13],[87,5,88,11],[16,13,16,16],[14,13,14,16],[21,13,21,16],[26,13,26,16],[46,13,46,16]]}
[]
[null,"1. Overview"]
[null,null,"1.1 City details"]
[null,null,null,"1.1.1 Contact details"]
[null,null,null,null,"a.","Name of  responding city"]
[]
[null,null,null,null,"b.","Name of main contact"]
[]
[null,null,null,null,"c.","Email address"]
[]
[null,null,null,null,"d.","Contact telephone number"]
[]
[]
[null,null,null,"1.1.2 Form of city entity"]
[null,null,null,null,"a.","Name of the  city authority"]
[]
[null,null,null,null,"b.","Describe the governing structure of your city authority"]
[]
[null,null,null,null,"c.","What is the budget of the city authority?",null,null,null,null,null,null,null,null,"€/yr"]
[]
[null,null,null,null,"d.","Is there another entity that affects the decisions of the governing body? (Please select)",null,null,null,null,null,null,null,null,"Y/N"]
[null,null,null,null,null,null,null,null,null,"If 'Yes', please specify the name and role"]
[]
[null,null,null,"1.1.3 Geographical area"]
[null,null,null,null,"a.","Provide the total area of your city",null,null,null,null,null,null,null,null,"km2"]
[null,null,null,null,null,null,null,null,null,null,null,null,"year:"]
[null,null,null,null,"b.","What area does this figure cover (please select)?"]
[]
[]
[null,null,null,null,"c.","Provide the area used by the following land use types in your city"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Residential",null,"km2"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Private business",null,"km2"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Public services",null,"km2"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Green areas",null,"km2"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Transport infrastructure and logistics",null,"km2"]
[]
[null,null,"1.2 Population"]
[null,null,null,"1.2.1 Current data"]
[null,null,null,null,"a.","Provide the population of your city in the following years"]
[null,null,null,null,null,null,null,null,null,null,null,null,"year:","1970-01-01","year:","1990-01-01","year:","2013-01-01","year:","2030-01-01","year:","2050-01-01"]
[]
[null,null,null,null,"b.","What area does this figure cover (please select)?"]
[]
[]
[]
[null,null,"1.3 Economy"]
[null,null,null,null,"a.","What is the annual GDP of your city in euros?",null,null,null,null,null,null,null,null,"€"]
[null,null,null,null,null,null,null,null,null,null,null,null,"year:"]
[]
[null,null,null,null,"b.","What is the per capita GDP of your city in euros?",null,null,null,null,null,null,null,null,"€"]
[null,null,null,null,null,null,null,null,null,null,null,null,"year:"]
[]
[null,null,null,null,"c.","What is the median disposable income per capita?",null,null,null,null,null,null,null,null,"€"]
[null,null,null,null,null,null,null,null,null,null,null,null,"year:"]
[]
[null,null,null,null,"d.","What is the Gini coefficient of personal income in your city?"]
[null,null,null,null,null,null,null,null,null,null,null,null,"year:"]
[]
[null,null,null,null,"e.","What proportion of the city's GDP is accounted for by the following sectors?"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Service - Finance",null,"%"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Service - Business",null,"%"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Service - Creative industries and film",null,"%"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Light Industry / Manufacturing",null,"%"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Heavy Industry",null,"%"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Tourism",null,"%"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Education",null,"%"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Health",null,"%"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Agriculture",null,"%"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Public Sector",null,"%"]
[]
[null,null,null,null,"f.","Number of jobs in sustainability or green energy"]
[]
[null,null,"1.4. GHG emissions and energy"]
[null,null,null,null,"a.","Does the city authority have a statutory duty (legal ability) in relation to the reduction of greenhouse gases?",null,null,null,null,null,null,null,null,"Y/N"]
[]
[null,null,null,null,"b.","Has a Carbon Reduction or Climate Change Strategy (or similar document) been published by the Mayor?",null,null,null,null,null,null,null,null,"Y/N"]
[null,null,null,null,null,null,null,null,null,null,null,null,"year:"]
[]
[null,null,null,null,null,"If yes, please provide a link to this document :"]
[]
[null,null,null,null,"c.","Provide the total GHG emissions of your city",null,null,null,null,null,null,null,null,"metric tonnes of CO2 equivalent (CO2e) per year"]
[null,null,null,null,null,null,null,null,null,null,null,null,"year:"]
[]
[null,null,null,null,"d.","Provide the total primary energy consumption of your city",null,null,null,null,null,null,null,null,"GWh per year"]
[null,null,null,null,null,null,null,null,null,null,null,null,"year:"]
[]
[null,null,"1.5 Climate"]
[null,null,null,"1.5.1 Climate records"]
[null,null,null,null,"a.","What is the average temperature in your City?",null,null,null,null,null,null,null,null,"°C"]
[]
[null,null,null,null,"b.","What is the lowest temperature recorded in your city?",null,null,null,null,null,null,null,null,"°C"]
[]
[null,null,null,null,"c.","What is the highest temperature recorded in your city?",null,null,null,null,null,null,null,null,"°C"]
[]
[null,null,null,null,"d.","What is the average rainfall in your city?",null,null,null,null,null,null,null,null,"mm/year"]
[]
[null,null,null,null,"e.","What is the Heating Degree Days measure for the city?",null,null,null,null,null,null,null,null,"°C day","Baseline temperature used for this calculation",null,null,null,null,null,"°C"]
[]
[null,null,null,null,"f.","What is the Cooling Degree Days measure for the city?",null,null,null,null,null,null,null,null,"°C day","Baseline temperature used for this calculation",null,null,null,null,null,"°C"]
[]
[null,null,null,"1.5.2 Extreme weather events"]
[null,null,null,null,"a.","Has your city been affected by an extreme weather events in the past [5 years]? "]
[null,null,null,null,null,"Please describe the event"]
[null,null,null,null,null,"Please estimate the value of damages caused by the event",null,null,null,null,null,null,null,null,"€"]

{"sheet":"Energy","index":3,"n_rows":230,"n_cols":17,"rows_kept":230,"cut":false,"hidden":false,"merged":[[6,5,7,11],[229,3,229,5],[228,3,228,5],[24,5,24,8],[47,5,47,8],[47,10,47,13],[18,5,19,8],[49,5,50,8],[83,5,84,8],[24,10,24,14],[20,5,21,8],[170,5,170,9],[172,5,172,9],[160,13,160,15],[175,11,175,12],[194,11,194,12],[194,5,194,9],[136,5,137,10],[134,5,135,10],[139,5,140,10]]}
[]
[]
[null,"2. Energy"]
[null,null,"2.1 Energy development and targets"]
[null,null,null,"2.1.1 Energy strategy"]
[null,null,null,null,"a.","Please provide a description of the existing strategies your city has for energy"]
[]
[]
[]
[null,null,null,"2.1.2 Energy targets/goals"]
[null,null,null,null,"a.","Does your city have a target in place for reducing overall GHG emissions?",null,null,null,null,null,null,"Y/N"]
[]
[null,null,null,null,"b.","If yes, what is this target?",null,null,null,null,null,null,"%"]
[null,null,null,null,null,null,null,null,null,null,"Baseline year:"]
[null,null,null,null,null,null,null,null,null,null,"Target year:"]
[]
[null,null,"2.2 Electricity"]
[null,null,null,"2.2.1 Emissions (electricity)"]
[null,null,null,null,"a.","What is the total electricity consumed within your city?",null,null,null,null,null,null,"MWh / yr"]
[]
[null,null,null,null,"b.","What is the carbon intensity of your cities grid electricity  supply?",null,null,null,null,null,null,"g CO2e/kWh"]
[null,null,null,null,null,null,null,null,null,null,"year:"]
[]
[null,null,null,"2.2.2 Energy mix (electricity)"]
[null,null,null,null,"a.","Please provide the current split of your city's electricity supply by source (share of energy supplied)",null,null,null,null,"Please also provide the generation capacity of each type of asset, owned and/or controlled by the city. These assets may not be within the city boundary, but must be owned and/or controlled by the city authority."]
[]
[null,null,null,null,null,null,"Natural gas",null,"% of energy supply",null,null,null,"MW"]
[]
[null,null,null,null,null,null,"Oil",null,"% of energy supply",null,null,null,"MW"]
[]
[null,null,null,null,null,null,"Coal",null,"% of energy supply",null,null,null,"MW"]
[]
[null,null,null,null,null,null,"Nuclear",null,"% of energy supply",null,null,null,"MW"]
[]
[null,null,null,null,null,null,"Biomass",null,"% of energy supply",null,null,null,"MW"]
[]
[null,null,null,null,null,null,"Wind",null,"% of energy supply",null,null,null,"MW"]
[]
[null,null,null,null,null,null,"Hydro",null,"% of energy supply",null,null,null,"MW"]
[]
[null,null,null,null,null,null,"Solar",null,"% of energy supply",null,null,null,"MW"]
[]
[null,null,null,null,null,null,"Energy from Waste",null,"% of energy supply",null,null,null,"MW"]
[]
[null,null,null,null,null,null,"Other",null,"% of energy supply",null,null,null,"MW"]
[]
[null,null,null,null,"b.","Please describe the generation types within the 'other' category",null,null,null,null,"Please describe the generation types within the 'other' category"]
[]
[]
[null,null,null,null,"c.","Please provide the percentage of your households connected to an electrical grid",null,null,null,null,null,null,"%"]
[]
[null,null,null,null,"d.","What percentage of the population has access to electricity?",null,null,null,null,null,null,"%"]
[]
[null,null,null,"2.2.3 Renewable generation"]
[null,null,null,null,"a.","Please provide the capacity of the electricity generated by renewables within your city"]
[null,null,null,null,null,null,null,null,null,null,"Biomass",null,"MWh/yr"]
[]
[null,null,null,null,null,null,null,null,null,null,"Wind",null,"MWh/yr"]
[]
[null,null,null,null,null,null,null,null,null,null,"Hydro",null,"MWh/yr"]
[]
[null,null,null,null,null,null,null,null,null,null,"Solar",null,"MWh/yr"]
[]
[null,null,null,null,null,null,null,null,null,null,"Other",null,"MWh/yr"]
[]
[null,null,null,null,"b.","Percentage of total energy demand covered by renewable energy production in the city",null,null,null,null,null,null,"%"]
[]
[null,null,null,null,"c.","State how much renewable energy is used for: ",null,null,null,null,"Electricity production",null,"MWh/yr"]
[null,null,null,null,null,null,null,null,null,null,"Heat production",null,"MWh/yr"]
[null,null,null,null,null,null,null,null,null,null," Fuel production",null,"MWh/yr"]
[]
[null,null,null,null,"d.","How much renewable energy is produced within the city boundaries?",null,null,null,null,null,null,"MWh/yr"]
[]
[null,null,null,null,"d.","How much renewable energy is imported into city?",null,null,null,null,null,null,"MWh/yr"]
[]
[]
[]
[null,null,"2.3 Local energy resources"]
[null,null,null,"2.3.1","a.","Has a study been completed to identify the available resources of renewable energy in your city?",null,null,null,null,null,null,"Y/N"]
[null,null,null,null,null,null,null,null,null,null,"year:"]
[null,null,null,null,null,"If yes, please provide a web-link to this study"]
[]
[null,null,"2.4 Heating"]
[null,null,null,null,"a.","Provide the annual CO2 emissions associated with the heating of buildings in your city",null,null,null,null,null,null,"tonnes"]
[]
[]
[null,null,null,null,"b.","Provide the current breakdown of fuels used for building heating (share of energy supplied)"]
[]
[null,null,null,null,null,null,null,null,null,null,"Natural gas (district heating)",null,"%"]
[]
[null,null,null,null,null,null,null,null,null,null,"Natural gas (individual boilers)",null,"%"]
[]
[null,null,null,null,null,null,null,null,null,null,"Energy from Waste (district heating)",null,"%"]
[]
[null,null,null,null,null,null,null,null,null,null,"Oil",null,"%"]
[]
[null,null,null,null,null,null,null,null,null,null,"Coal",null,"%"]
[]
[null,null,null,null,null,null,null,null,null,null,"Fuel oil",null,"%"]
[]
[null,null,null,null,null,null,null,null,null,null,"Electrical heating",null,"%"]
[]
[null,null,null,null,null,null,null,null,null,null,"Solar thermal",null,"%"]
[]
[null,null,null,null,null,null,null,null,null,null,"Biomass",null,"%"]
[]
[null,null,null,null,null,null,null,null,null,null,"Other",null,"%"]
[]
[null,null,null,null,"c.","Does the city have a district heating system? ",null,null,null,null,null,null,"Y/N"]
[]
[null,null,null,null,"d.","Provide the percentage of your households connected to district heating",null,null,null,null,null,null,"%"]
[]
[null,null,null,null,"e.","Percentage of households connected to a gas network",null,null,null,null,null,null,"%"]
[]
[null,null,"2.5 Energy demand"]
[null,null,null,"2.5.1 Energy demand and emissions"]
[null,null,null,null,"a.","Provide the proportion of your city's energy demand and carbon emissions associated with each of the following sectors."]
[null,null,null,null,null,null,null,"Electricity ",null,null,"Heating",null,null,"Transport fuel"]
[null,null,null,null,null,null,null,"Energy","Carbon emissions",null,"Energy","Carbon emissions",null,"Energy","Carbon emissions"]
[null,null,null,null,null,null,"Residential",null,null,"%",null,null,"%",null,null,"%"]
[]
[null,null,null,null,null,null,"Commercial",null,null,"%",null,null,"%",null,null,"%"]
[]
[null,null,null,null,null,null,"Retail",null,null,"%",null,null,"%",null,null,"%"]
[]
[null,null,null,null,null,null,"Industrial",null,null,"%",null,null,"%",null,null,"%"]
[]
[null,null,null,null,null,null,"Public",null,null,"%",null,null,"%",null,null,"%"]
[]
[null,null,null,"2.5.2 Energy efficiency"]
[null,null,null,null,"a.","What is the change in primary energy demand?",null,null,null,null,null,null,"kWh/yr"]
[null,null,null,null,null,null,null,null,null,null," reference year:"]
[null,null,null,null,null,null,null,null,null,null,"current year:"]
[null,null,null,null,"If possible please sub-divide into:"]
[null,null,null,null,"i","Primary energy saved in energy production by using renewable energy sources ",null,null,null,null,null,null,"kWh/yr"]
[]
[null,null,null,null,"ii","Primary energy saved in energy production by using energy efficient production technologies such CHP, heat pumps, use of waste heat",null,null,null,null,null,null,"kWh/yr"]
[]
[]
[null,null,null,null,"iii","Primary energy saved by energy demand reduction in operational buildings’ energy demand (heat, cold, ventilation) ",null,null,null,null,null,null,"kWh/yr"]
[]
[]
[null,null,null,null,"iv","Primary energy saved by energy demand reduction in lighting (in buildings, public lighting)",null,null,null,null,null,null,"kWh/yr"]
[]
[null,null,null,null,"v","Primary energy saved by energy demand reduction in appliance use",null,null,null,null,null,null,"kWh/yr"]
[]
[null,null,null,null,"vi","Primary energy saved by energy demand reduction in industrial processes",null,null,null,null,null,null,"kWh/yr"]
[]
[null,null,null,"2.5.3 Municipal energy consumption"]
[null,null,null,null,"a.","Does the city authority purchase energy (electricity/gas/heat/oil products etc.) for use in public buildings? ",null,null,null,null,null,null,"Y/N"]
[]
[null,null,null,null,null,"If yes please state the percentage of total cost of energy (electricity/gas/heat/oil products) for:"]
[null,null,null,null,null,null,null,null,null,null,"Educational",null,"%"]
[]
[null,null,null,null,null,null,null,null,null,null,"Hospital",null,"%"]
[]
[null,null,null,null,null,null,null,null,null,null,"Government",null,"%"]
[]
[null,null,null,null,null,null,null,null,null,null,"Leisure",null,"%"]
[]
[null,null,null,null,null,null,null,null,null,null,"Other",null,"%",null,null,null,"Description of 'other'"]
[]
[null,null,null,null,"c.","What is the annual energy bill for the city's buildings?",null,null,null,null,null,null,"€/yr"]
[]
[null,null,null,null,"d.","Does the city have a long term energy procurement contract for municipal energy usage?",null,null,null,null,null,null,"Y/N"]
[]
[null,null,null,null,"e.","If yes, what is the duration of the contract?",null,null,null,null,null,null,"years"]
[]
[null,null,null,null,"f.","When is the contract next due for renewal?",null,null,null,null,"year:"]
[]
[null,null,null,null,"g.","Can the city authority specify the carbon intensity or level of renewable generation associated with this energy supply?",null,null,null,null,null,null,"Y/N"]
[]
[null,null,null,null,"h.","If yes, please provide details"]
[]
[null,null,"2.6 Prices"]
[null,null,null,null,"a.","Provide the average prices to residential customers for energy in the following forms.",null,null,null,null,null,"Other associated charges (standing charges, etc.)",null,null,"Are prices regulated?"]
[null,null,null,null,null,null,"Natural gas",null,"€/kWh","(select unit)",null,null,null,null,null,"Y/N"]
[]
[null,null,null,null,null,null,"Oil",null,"€/kWh","(select unit)",null,null,null,null,null,"Y/N"]
[]
[null,null,null,null,null,null,"Coal",null,"€/kWh","(select unit)",null,null,null,null,null,"Y/N"]
[]
[null,null,null,null,null,null,"Electricity",null,"€/kWh","(select unit)",null,null,null,null,null,"Y/N"]
[]
[null,null,null,null,null,null,"Heat from district heating",null,"€/kWh","(select unit)",null,null,null,null,null,"Y/N"]
[]
[null,null,null,null,null,null,"Biomass pellets",null,"€/kWh","(select unit)",null,null,null,null,null,"Y/N"]
[]
[null,null,null,null,null,null,"Heating oil",null,"€/kWh","(select unit)",null,null,null,null,null,"Y/N"]
[]
[null,null,null,null,null,null,"Petrol",null,"€/kWh","(select unit)",null,null,null,null,null,"Y/N"]
[]
[null,null,null,null,null,null,"Diesel",null,"€/kWh","(select unit)",null,null,null,null,null,"Y/N"]
[]
[null,null,null,null,"b.","Provide the average prices to commercial (all non-residential) customers for energy in the following forms.",null,null,null,null,null,"Other associated charges (standing charges, etc.)",null,null,"Are prices regulated?"]
[null,null,null,null,null,null,"Natural gas",null,"€/kWh","(select unit)",null,null,null,null,null,"Y/N"]
[]
[null,null,null,null,null,null,"Oil",null,"€/kWh","(select unit)",null,null,null,null,null,"Y/N"]
[]
[null,null,null,null,null,null,"Coal",null,"€/kWh","(select unit)",null,null,null,null,null,"Y/N"]
[]
[null,null,null,null,null,null,"Electricity",null,"€/kWh","(select unit)",null,null,null,null,null,"Y/N"]
[]
[null,null,null,null,null,null,"Heat from district heating",null,"€/kWh","(select unit)",null,null,null,null,null,"Y/N"]
[]
[null,null,null,null,null,null,"Biomass pellets",null,"€/kWh","(select unit)",null,null,null,null,null,"Y/N"]
[]
[null,null,null,null,null,null,"Heating oil",null,"€/kWh","(select unit)",null,null,null,null,null,"Y/N"]
[]
[null,null,null,null,null,null,"Petrol",null,"€/kWh","(select unit)",null,null,null,null,null,"Y/N"]
[]
[null,null,null,null,null,null,"Diesel",null,"€/kWh","(select unit)",null,null,null,null,null,"Y/N"]
[]
[]
[null,null,"2.7 Fuel poverty"]
[null,null,null,null,"a.","What percentage of city inhabitants are in fuel poverty",null,null,null,null,null,null,"%"]
[]
[null,null,null,null,"b.","Does your city have a target for reducing the level of fuel poverty?",null,null,null,null,null,null,"Y/N"]
[]
[null,null,null,null,"c.","If yes, what is this target",null,null,null,null,null,null,"%"]
[null,null,null,null,null,null,null,null,null,null,"Baseline year:"]
[null,null,null,null,null,null,null,null,null,null,"Target year:"]
[]
[]
[null,null,"2.8 Influence over energy assets"]
[null,null,null,null,"a.","Please select how your city authority has influence over the following energy supply assets."]
[]
[null,null,null,null,null,null,"Own/Operate Asset or Function","Set/enforce policies and regulation","Budgetary control","Set vision"]
[null,null,null,"District heating",null,null,"Select from drop down list","Select from drop down list","Select from drop down list","Select from drop down list"]
[null,null,null,"Distributed power generation within city",null,null,"Select from drop down list","Select from drop down list","Select from drop down list","Select from drop down list"]

{"sheet":"Waste","index":4,"n_rows":77,"n_cols":18,"rows_kept":77,"cut":false,"hidden":false,"merged":[[76,3,76,5],[74,3,74,5],[75,3,75,5],[7,5,8,11],[45,13,45,16]]}
[]
[]
[]
[null,"3. Waste"]
[null,null,"3.1 Waste metrics and strategy"]
[null,null,null,"3.1.1 Waste strategy"]
[null,null,null,null,null,"Please provide a description of the existing strategies your city has for waste"]
[]
[]
[]
[null,null,null,"3.1.2 Waste metrics"]
[null,null,null,null,"a.","How much waste does the city generate (kg/person/day)?",null,null,null,null,null,null,"kg/person/day"]
[]
[null,null,null,null,"b.","What is your municipal waste breakdown (%)?",null,null,null,null,"Organics",null,"%"]
[]
[null,null,null,null,null,null,null,null,null,null,"Metals",null,"%"]
[]
[null,null,null,null,null,null,null,null,null,null,"Wood",null,"%"]
[]
[null,null,null,null,null,null,null,null,null,null,"Glass",null,"%"]
[]
[null,null,null,null,null,null,null,null,null,null,"Textiles",null,"%"]
[]
[null,null,null,null,null,null,null,null,null,null,"Plastics",null,"%"]
[]
[null,null,null,null,null,null,null,null,null,null,"Paper and cardboard",null,"%"]
[]
[null,null,null,null,null,null,null,null,null,null,"Fines (soil, dust etc)",null,"%"]
[]
[null,null,null,null,null,null,null,null,null,null,"Other",null,"%"]
[]
[null,null,null,null,"c.","Provide a percentage split of current municipal waste treatment by method:"]
[null,null,null,null,null,null,null,null,null,null,"Re-use",null,"%"]
[]
[null,null,null,null,null,null,null,null,null,null,"Recycling / composting",null,"%"]
[]
[null,null,null,null,null,null,null,null,null,null,"Waste to energy",null,"%"]
[]
[null,null,null,null,null,null,null,null,null,null,"Landfill",null,"%"]
[]
[null,null,null,null,null,null,null,null,null,null,"Other",null,"%"]
[]
[null,null,"3.2 Waste management"]
[null,null,null,null,"a.","What percentage of the city is served by a formal waste collection?",null,null,null,null,null,null,"%"]
[]
[null,null,null,null,"b.","Does the city have any informal sector waste collection?",null,null,null,null,null,null,"Y/N",null,null,null,null,"Please describe"]
[]
[null,null,null,null,"c.","Does the city have recyclables collection for single-family households?",null,null,null,null,null,null,"Y/N"]
[]
[null,null,null,null,"d.","Does the city have recyclables collection for multi-family buildings?",null,null,null,null,null,null,"Y/N"]
[]
[null,null,null,null,"e.","Does the city have recyclables collection for commercial establishments?",null,null,null,null,null,null,"Y/N"]
[]
[null,null,null,null,"f.","Does the city have organics collection for single-family households?",null,null,null,null,null,null,"Y/N"]
[]
[null,null,null,null,"g.","Does the city have organics collection for multi-family buildings?",null,null,null,null,null,null,"Y/N"]
[]
[null,null,null,null,"h.","Does the city have organics collection for commercial establishments?",null,null,null,null,null,null,"Y/N"]
[]
[null,null,null,null,"i.","Does the city have collection fees for single-family households?",null,null,null,null,null,null,"Y/N"]
[]
[null,null,null,null,"j.","Does the city have collection fees for multi-family buildings?",null,null,null,null,null,null,"Y/N"]
[]
[null,null,null,null,"k.","Does the City have collection fees for commercial establishments?",null,null,null,null,null,null,"Y/N"]
[]
[null,null,null,null,"l.","Is landfill gas management in place for landfills in the city?",null,null,null,null,null,null,"Y/N"]
[]
[null,null,null,null,"m.","Is landfill gas used to generate energy in your city?",null,null,null,null,null,null,"Y/N"]
[]
[]
[null,null,"3.3 Influence over waste assets"]
[null,null,null,null,null,"Please select how your city authority has influence over the following waste management functions"]
[]
[null,null,null,null,null,null,"Own/Operate Asset or Function","Set/enforce policies and regulation","Budgetary control","Set vision"]
[null,null,null,"Residential waste collection",null,null,"Select from drop down list","Select from drop down list","Select from drop down list","Select from drop down list"]
[null,null,null,"Commercial collection",null,null,"Select from drop down list","Select from drop down list","Select from drop down list","Select from drop down list"]
[null,null,null,"Construction collection",null,null,"Select from drop down list","Select from drop down list","Select from drop down list","Select from drop down list"]

{"sheet":"Water","index":5,"n_rows":66,"n_cols":11,"rows_kept":66,"cut":false,"hidden":false,"merged":[[63,3,63,5],[64,3,64,5],[65,3,65,5],[7,5,8,9],[52,5,52,9]]}
[]
[]
[]
[null,"4. Water"]
[null,null,"4.1 Water metrics and strategy"]
[null,null,null,"4.1.1 Water strategy"]
[null,null,null,null,null,"Please provide a description of the existing strategies your city has for water"]
[]
[]
[]
[null,null,null,"4.1.2 Water Metrics"]
[null,null,null,null,"a.","How many tones of CO2 are generated annually from supplying water?"]
[]
[null,null,null,null,null,null,null,null,null,null,"tonnes"]
[]
[null,null,null,null,"b.","What is the percentage split of the city’s water supply? (Please select)"]
[]
[null,null,null,null,null,null,null,null,"Surface water",null,"%"]
[]
[null,null,null,null,null,null,null,null,"Ground water",null,"%"]
[]
[null,null,null,null,null,null,null,null,"Desalinated seawater",null,"%"]
[]
[null,null,null,null,null,null,null,null,"Recycled water",null,"%"]
[]
[null,null,null,null,null,null,null,null,"Other",null,"%"]
[]
[null,null,null,null,"c.","What is the percentage split of water consumption in the city? "]
[]
[null,null,null,null,null,null,null,null,"Residential",null,"%"]
[]
[null,null,null,null,null,null,null,null,"Commercial",null,"%"]
[]
[null,null,null,null,null,null,null,null,"Municipal",null,"%"]
[]
[null,null,null,null,null,null,null,null,"Industrial",null,"%"]
[]
[null,null,null,null,null,null,null,null,"Agriculture",null,"%"]
[]
[null,null,null,null,null,null,null,null,"Other",null,"%"]
[]
[null,null,null,null,"d.","What percentage of domestic users have a metered supply?",null,null,null,null,"%"]
[]
[null,null,null,null,"e.","Is metering mandatory for domestic users?",null,null,null,null,"Y/N"]
[]
[null,null,null,null,"f.","What percentage of industrial and commercial users have a metered supply?",null,null,null,null,"%"]
[]
[null,null,null,null,"g.","Is metering mandatory for industrial and commercial users?",null,null,null,null,"Y/N"]
[]
[null,null,null,null,"h.","What volume of wastewater is treated per day (on average)?",null,null,null,null,"ML"]
[]
[null,null,null,null,"i.","How is storm and waste water collected and treated? "]
[]
[]
[null,null,null,null,"k.","Does your city harness energy from its wastewater treatment processes?",null,null,null,null,"Y/N"]
[]
[]
[]
[]
[null,null,"4.2 Influence over water assets"]
[null,null,null,null,"a.","Please select how your city authority has influence over the following water management functions and assets."]
[]
[null,null,null,null,null,null,"Own/Operate Asset or Function","Set/enforce policies and regulation","Budgetary control","Set vision"]
[null,null,null,"Water supply operation",null,null,"Select from drop down list","Select from drop down list","Select from drop down list","Select from drop down list"]
[null,null,null,"Storm water management",null,null,"Select from drop down list","Select from drop down list","Select from drop down list","Select from drop down list"]
[null,null,null,"Wastewater Treatment",null,null,"Select from drop down list","Select from drop down list","Select from drop down list","Select from drop down list"]

{"sheet":"Transport","index":6,"n_rows":67,"n_cols":13,"rows_kept":67,"cut":false,"hidden":false,"merged":[[7,5,8,10]]}
[]
[]
[]
[null,"5. Transport"]
[null,null,"5.1 Transport metrics and strategy"]
[null,null,null,"5.1.1 Transport strategy"]
[null,null,null,null,"a.","Please provide a description of the existing strategies your city has for transport"]
[]
[]
[]
[null,null,null,null,"b.","What is the modal split for transport, i.e. the proportion of trips made (%), passenger km travelled per year and CO2 emissions per passenger km by each mode "]
[null,null,null,null,null,null,"Proportion of trips",null,"Passenger km travelled per year",null,"CO2 emissions per passenger km"]
[null,null,null,null,null,"Private motorized transport",null,"%",null,"Passenger km/yr",null,"kg/km"]
[]
[null,null,null,null,null,"Rail/Metro/Tram",null,"%",null,"Passenger km/yr",null,"kg/km"]
[]
[null,null,null,null,null,"Buses",null,"%",null,"Passenger km/yr",null,"kg/km"]
[]
[null,null,null,null,null,"Ferries/ River boats",null,"%",null,"Passenger km/yr",null,"kg/km"]
[]
[null,null,null,null,null,"Walking",null,"%",null,"Passenger km/yr",null,"kg/km"]
[]
[null,null,null,null,null,"Taxi",null,"%",null,"Passenger km/yr",null,"kg/km"]
[]
[null,null,null,null,null,"Cycling",null,"%",null,"Passenger km/yr",null,"kg/km"]
[]
[null,null,null,null,null,"Other",null,"%",null,"Passenger km/yr",null,"kg/km"]
[]
[null,null,"5.2 Transport initiatives"]
[null,null,null,"5.2.1 Public transport"]
[null,null,null,null,"a.","Does your city have an inter-modal electronic ticketing system?",null,null,null,null,null,"Y/N"]
[]
[null,null,null,null,"b.","If yes, what percentage of the city population are members of the scheme?",null,null,null,null,null,"%"]
[]
[null,null,null,null,"c.","Are low-emission buses in use in your city?",null,null,null,null,null,"Y/N"]
[]
[null,null,null,null,"d.","If yes, what percentage of the total bus fleet is low-emission?",null,null,null,null,null,"Y/N"]
[]
[null,null,null,"5.2.2 Private transport"]
[null,null,null,null,"a.","Does your city impose a charge on the use of private or commercial vehicles to reduce congestion or emissions?",null,null,null,null,null,null,"Y/N"]
[]
[null,null,null,null,"b.","Does your city provide incentives to low-emission vehicles? (e.g. reduced parking or congestion charges)",null,null,null,null,null,null,"Y/N"]
[]
[null,null,null,null,"c.","If yes, please provide a description of the incentives provided"]
[]
[null,null,null,null,"d.","How many publically accessible, on-street electric vehicle charging points are installed?"]
[]
[null,null,null,null,"e.","Does your city have a city-wide cycle-hire scheme?",null,null,null,null,null,"Y/N"]
[]
[null,null,null,null,"f.","Length of cycle lanes",null,null,null,null,null,"km"]
[]
[null,null,null,null,"g.","What proportion of cycle lanes in the city are segregated?",null,null,null,null,null,"%"]
[]
[null,null,null,"5.2.2 Commercial transport"]
[null,null,null,null,"a.","Does your city impose emission related restrictions on the operations of ships or shipping ports?",null,null,null,null,null,"Y/N"]
[]
[null,null,null,null,"b.","Does your city have an airport?",null,null,null,null,null,"Y/N"]
[]
[null,null,null,null,"c.","Are there any consolidation centres to minimise freight movement within your city?",null,null,null,null,null,"Y/N"]
[]
[null,null,"5.3 Influence over water assets"]
[null,null,null,null,"a.","Please select how your city authority has influence over the following transport functions and assets."]
[]
[null,null,null,null,null,null,"Own/Operate Asset or Function","Set/enforce policies and regulation","Budgetary control","Set vision"]
[null,null,null,null,null,"City roads","Select from drop down list","Select from drop down list","Select from drop down list","Select from drop down list"]
[null,null,null,null,null,"Buses","Select from drop down list","Select from drop down list","Select from drop down list","Select from drop down list"]
[null,null,null,null,null,"Rail","Select from drop down list","Select from drop down list","Select from drop down list","Select from drop down list"]

{"sheet":"Buildings","index":7,"n_rows":90,"n_cols":15,"rows_kept":90,"cut":false,"hidden":false,"merged":[[87,3,87,5],[88,3,88,5],[89,3,89,5],[7,5,8,11],[77,11,77,14],[79,11,79,14],[81,11,81,14],[62,14,62,17],[64,14,64,17],[66,14,66,17],[68,14,68,17],[70,14,70,17],[72,14,72,17],[74,14,74,17]]}
[]
[]
[]
[null,"6. Buildings"]
[null,null,"6.1 Buildings metrics and strategy"]
[null,null,null,"6.1.1 Building stock"]
[null,null,null,null,"a.","Please provide a description of the existing strategies your city has for buildings"]
[]
[]
[]
[null,null,null,null,"b.","Please provide the percentage split of building types in your city?"]
[]
[null,null,null,null,null,null,null,null,"Residential"]
[]
[null,null,null,null,null,null,null,null,"Commercial"]
[]
[null,null,null,null,null,null,null,null,"Industrial"]
[]
[null,null,null,null,null,null,null,null,"Public"]
[]
[null,null,null,null,null,null,null,null,"Other"]
[]
[null,null,null,null,"c.","Please provide the number of buildings built prior to the following years?"]
[]
[null,null,null,null,null,null,null,null,1918]
[]
[null,null,null,null,null,null,null,null,1945]
[]
[null,null,null,null,null,null,null,null,1970]
[]
[null,null,null,null,null,null,null,null,1990]
[]
[null,null,null,null,"d.","How many new residences will be built:",null,null,"In the next year:",null,null,"In the next ten years:"]
[]
[null,null,null,"6.1.2 Building Energy consumption"]
[null,null,null,null,"a.","What is the percentage split of energy use in buildings across the city? Please indicate the percentage by end use."]
[]
[null,null,null,null,null,null,null,null,"Space conditioning",null,"%"]
[]
[null,null,null,null,null,null,null,null,"Refrigeration",null,"%"]
[]
[null,null,null,null,null,null,null,null,"Lighting",null,"%"]
[]
[null,null,null,null,null,null,null,null,"Hot water",null,"%"]
[]
[null,null,null,null,null,null,null,null,"Plug loads",null,"%"]
[]
[null,null,null,null,null,null,null,null,"Others",null,"%"]
[]
[null,null,null,null,"b.","Is industry in your city switching to any of the following lower-carbon fuels? (please select)"]
[]
[null,null,null,null,null,null,null,null,"Switching from coal/wood fire to electricity",null,"Y/N"]
[]
[null,null,null,null,null,null,null,null,"Switching from heating oil to natural gas",null,"Y/N"]
[]
[null,null,null,null,null,null,null,null,"Switching from residual fuel oil to distillate fuel oil",null,"Y/N"]
[]
[null,null,null,null,null,null,null,null,"Switching to biogenic heating fuels",null,"Y/N"]
[]
[null,null,null,null,null,null,null,null,"Purchase of ‘green’ electricity from the grid",null,"Y/N"]
[]
[null,null,"6.2 Planning",null,null,null,null,null,null,null,null,null,null,null,"Additional Comments"]
[null,null,null,null,"a.","Does your city have a 'compact city' strategy?",null,null,null,null,null,null,null,"Y/N"]
[]
[null,null,null,null,"b.","Does your city apply building codes and/or standards for new residential developments?",null,null,null,null,null,null,null,"Y/N"]
[]
[null,null,null,null,"c.","Does your city apply building codes and/or standards for new commercial and industrial buildings?",null,null,null,null,null,null,null,"Y/N"]
[]
[null,null,null,null,"d.","Do your city's planning policies encourage brownfield redevelopment?",null,null,null,null,null,null,null,"Y/N"]
[]
[null,null,null,null,"e.","Do your city's planning policies protect green and open spaces from development?",null,null,null,null,null,null,null,"Y/N"]
[]
[null,null,null,null,"f.","Does your city have an Eco district development strategy?",null,null,null,null,null,null,null,"Y/N"]
[]
[null,null,null,null,"g.","Are there examples of urban agriculture in your city?",null,null,null,null,null,null,null,"Y/N"]
[]
[null,null,null,null,"h.","Do the planning requirements for new buildings in your city address the following?",null,null,null,null,null,"If yes, please provide details of these requirements"]
[null,null,null,null,null,null,null,null,"Energy and/or carbon reduction"]
[]
[null,null,null,null,null,null,null,null,"Installation of onsite renewables"]
[]
[null,null,null,null,null,null,null,null,"Water conservation"]
[]
[null,null,"6.3 Influence over building assets"]
[null,null,null,null,"a.","Please select how your city authority has influence over the following buildings assets."]
[]
[null,null,null,null,null,null,"Own/Operate Asset or Function","Set/enforce policies and regulation","Budgetary control","Set vision"]
[null,null,null,"Municipal offices / buildings",null,null,"Select from drop down list","Select from drop down list","Select from drop down list","Select from drop down list"]
[null,null,null,"Commercial buildings",null,null,"Select from drop down list","Select from drop down list","Select from drop down list","Select from drop down list"]
[null,null,null,"Educational facilities",null,null,"Select from drop down list","Select from drop down list","Select from drop down list","Select from drop down list"]

{"sheet":"ICT","index":8,"n_rows":61,"n_cols":13,"rows_kept":61,"cut":false,"hidden":false,"merged":[[7,5,8,11],[58,3,58,5],[59,3,59,5],[60,3,60,5]]}
[]
[]
[]
[null,"7. Information and Communication Technologies"]
[null,null,"7.1 ICT metrics and strategy"]
[null,null,null,"3.1.1 ICT strategy"]
[null,null,null,null,null,"Please provide a description of the existing strategies your city has for ICT"]
[]
[]
[]
[null,null,null,"3.1.2 ICT metrics"]
[null,null,null,null,"a.","What proportion of people has access to the internet at home or at work?",null,null,null,null,null,null,"%"]
[]
[null,null,null,null,"b.","What proportion of buildings in your city:"]
[null,null,null,null,null,null,null,null,null,null,"Have an internet connection?",null,"%"]
[]
[null,null,null,null,null,null,null,null,null,null,"Have a broadband connection?",null,"%"]
[]
[null,null,null,null,null,null,null,null,null,null,"Have a fibre optic connection?",null,"%"]
[]
[null,null,null,null,"c.","How many wireless hotspots are there in your City? "]
[]
[null,null,null,null,"d.","How many registered wireless hotspot users do you have?"]
[]
[null,null,null,null,"e.","Does your City authority have a website? ",null,null,null,null,null,null,"Y/N"]
[]
[null,null,null,null,null,"If yes, provide the web address."]
[]
[null,null,null,null,"f.","Does the city authority have a Twitter account, Facebook page, or some online communications forum to the public?",null,null,null,null,null,null,"Y/N"]
[]
[null,null,null,null,"g.","Is there someone who is responsible for information communication technology strategy across the whole city?",null,null,null,null,null,null,"Y/N"]
[]
[null,null,null,null,"h.","Does the city have an overview of total spend on ICT across the city?",null,null,null,null,null,null,"Y/N"]
[]
[null,null,null,null,"i.","Does the city have a technical architecture which includes all ICT in use across the city?",null,null,null,null,null,null,"Y/N"]
[]
[null,null,null,null,"j.","Has the city authority assessed the economic case for the strategic use of ICT in the city?",null,null,null,null,null,null,"Y/N"]
[]
[null,null,null,null,"k.","Are there staff members within the city with a role specifically responsible for ICT?",null,null,null,null,null,null,"Y/N"]
[]
[null,null,null,null,"l.","Does the city have an ICT carbon reduction target?",null,null,null,null,null,null,"Y/N"]
[null,null,null,null,"m.","If yes, provide the details of this target."]
[null,null,null,null,null,null,null,null,null,null,"Year:"]
[]
[null,null,null,null,"n.","Does your City have an internet connectivity target?",null,null,null,null,null,null,"Y/N"]
[null,null,null,null,"o.","If yes, provide the details of this target."]
[null,null,null,null,null,null,null,null,null,null,"Year:"]
[]
[null,null,null,null,"p.","Does your City have a wireless hotspot target?",null,null,null,null,null,null,"Y/N"]
[null,null,null,null,"q.","If yes, provide the details of this target."]
[null,null,null,null,null,null,null,null,null,null,"Year:"]
[]
[null,null,null,null,"r.","How many open data projects exist within your city?"]
[]
[null,null,"7.3 Influence over ICT assets"]
[null,null,null,null,"a.","Please select how your city authority has influence over the following ICT  functions and assets"]
[]
[null,null,null,null,null,null,"Own/Operate Asset or Function","Set/enforce policies and regulation","Budgetary control","Set vision"]
[null,null,null,"Public Wifi",null,null,"Select from drop down list","Select from drop down list","Select from drop down list","Select from drop down list"]
[null,null,null,"Broadband",null,null,"Select from drop down list","Select from drop down list","Select from drop down list","Select from drop down list"]
[null,null,null,"Mobile Telecommunications",null,null,"Select from drop down list","Select from drop down list","Select from drop down list","Select from drop down list"]

{"sheet":"Results_collate","index":9,"n_rows":707,"n_cols":22,"rows_kept":707,"cut":false,"hidden":true,"merged":[[92,9,92,13],[3,8,3,13],[5,8,5,13],[7,8,7,13],[9,8,9,13],[13,13,13,16],[15,13,15,16],[20,13,20,16],[25,13,25,16],[45,13,45,16],[87,5,88,11],[89,5,90,11],[116,7,116,13],[137,5,138,11],[149,5,150,8],[151,5,152,8],[155,5,155,8],[155,10,155,14],[325,5,325,9],[325,11,325,12],[178,5,178,8],[178,10,178,13],[180,5,181,8],[214,5,215,8],[265,5,266,10],[267,5,268,10],[270,5,271,10],[291,13,291,15],[301,5,301,9],[303,5,303,9],[306,11,306,12],[497,3,497,5],[359,3,359,5],[360,3,360,5],[365,5,366,11],[403,13,403,16],[432,3,432,5],[433,3,433,5],[434,3,434,5],[439,5,440,9],[484,5,484,9],[495,3,495,5],[496,3,496,5],[640,11,640,14],[502,5,503,10],[566,5,567,11],[621,14,621,17],[623,14,623,17],[625,14,625,17],[627,14,627,17],[629,14,629,17],[631,14,631,17],[633,14,633,17],[636,11,636,14],[638,11,638,14],[706,3,706,5],[646,3,646,5],[647,3,647,5],[648,3,648,5],[653,5,654,11],[704,3,704,5],[705,3,705,5]]}
[null,"1. Overview"]
[null,null,"1.1 City details"]
[null,null,null,"1.1.1 Contact details"]
[null,null,null,null,"a.","Name of  responding city",null,null,{"$f":"Overview!I5","v":0}]
[]
[null,null,null,null,"b.","Name of main contact",null,null,{"$f":"Overview!I7","v":0}]
[]
[null,null,null,null,"c.","Email address",null,null,{"$f":"Overview!I9","v":0}]
[]
[null,null,null,null,"d.","Contact telephone number",null,null,{"$f":"Overview!I11","v":0}]
[]
[]
[null,null,null,"1.1.2 Form of city entity"]
[null,null,null,null,"a.","Name of the  city authority",null,null,null,null,null,null,null,{"$f":"Overview!N15","v":"00:00:00"}]
[]
[null,null,null,null,"b.","Describe the governing structure of your city authority",null,null,null,null,null,null,null,{"$f":"Overview!N17","v":"00:00:00"}]
[]
[null,null,null,null,"c.","What is the budget of the city authority?",null,null,null,null,null,null,null,{"$f":"Overview!N19","v":0}]
[]
[null,null,null,null,"d.","Is there another entity that affects the decisions of the governing body? (Please select)",null,null,null,null,null,null,null,{"$f":"Overview!N21","v":0}]
[null,null,null,null,null,null,null,null,null,"If 'Yes', please specify the name and role",null,null,null,{"$f":"Overview!N22","v":"00:00:00"}]
[]
[null,null,null,"1.1.3 Geographical area"]
[null,null,null,null,"a.","Provide the total area of your city",null,null,null,null,null,null,null,{"$f":"Overview!N25","v":0},{"$f":"Overview!O25","v":"km2"}]
[null,null,null,null,null,null,null,null,null,null,null,null,"year:",{"$f":"Overview!N26","v":"00:00:00"}]
[null,null,null,null,"b.","What area does this figure cover (please select)?",null,null,null,null,null,null,null,{"$f":"Overview!N27","v":"00:00:00"}]
[]
[]
[null,null,null,null,"c.","Provide the area used by the following land use types in your city"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Residential",{"$f":"Overview!N32","v":0},{"$f":"Overview!O32","v":"km2"}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Private business",{"$f":"Overview!N34","v":0},{"$f":"Overview!O34","v":"km2"}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Public services",{"$f":"Overview!N36","v":0},{"$f":"Overview!O36","v":"km2"}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Green areas",{"$f":"Overview!N38","v":0},{"$f":"Overview!O38","v":"km2"}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Transport infrastructure and logistics",{"$f":"Overview!N40","v":0},{"$f":"Overview!O40","v":"km2"}]
[]
[null,null,"1.2 Population"]
[null,null,null,"1.2.1 Current data"]
[null,null,null,null,"a.","Provide the population of your city in the following years",null,null,null,null,null,null,null,{"$f":"Overview!N44","v":0},null,{"$f":"Overview!P44","v":0},null,{"$f":"Overview!R44","v":0},null,{"$f":"Overview!T44","v":0},null,{"$f":"Overview!V44","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,"year:",{"$f":"Overview!N45","v":"1970-01-01"},{"$f":"Overview!O45","v":"year:"},{"$f":"Overview!P45","v":"1990-01-01"},{"$f":"Overview!Q45","v":"year:"},{"$f":"Overview!R45","v":"2013-01-01"},{"$f":"Overview!S45","v":"year:"},{"$f":"Overview!T45","v":"2030-01-01"},{"$f":"Overview!U45","v":"year:"},{"$f":"Overview!V45","v":"2050-01-01"}]
[]
[null,null,null,null,"b.","What area does this figure cover (please select)?",null,null,null,null,null,null,null,{"$f":"Overview!$N$47","v":"00:00:00"}]
[]
[]
[]
[null,null,"1.3 Economy"]
[null,null,null,null,"a.","What is the annual GDP of your city in euros?",null,null,null,null,null,null,null,{"$f":"Overview!N52","v":0},"€"]
[null,null,null,null,null,null,null,null,null,null,null,null,"year:",{"$f":"Overview!N53","v":"00:00:00"}]
[]
[null,null,null,null,"b.","What is the per capita GDP of your city in euros?",null,null,null,null,null,null,null,{"$f":"Overview!N55","v":0},"€"]
[null,null,null,null,null,null,null,null,null,null,null,null,"year:",{"$f":"Overview!N56","v":"00:00:00"}]
[]
[null,null,null,null,"c.","What is the median disposable income per capita?",null,null,null,null,null,null,null,{"$f":"Overview!N58","v":0},"€"]
[null,null,null,null,null,null,null,null,null,null,null,null,"year:",{"$f":"Overview!N59","v":"00:00:00"}]
[]
[null,null,null,null,"d.","What is the Gini coefficient of personal income in your city?",null,null,null,null,null,null,null,{"$f":"Overview!N61","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,"year:",{"$f":"Overview!N62","v":"00:00:00"}]
[]
[null,null,null,null,"e.","What proportion of the city's GDP is accounted for by the following sectors?"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Service - Finance",{"$f":"Overview!N65","v":0},"%"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Service - Business",{"$f":"Overview!N67","v":0},"%"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Service - Creative industries and film",{"$f":"Overview!N69","v":0},"%"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Light Industry / Manufacturing",{"$f":"Overview!N71","v":0},"%"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Heavy Industry",{"$f":"Overview!N73","v":0},"%"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Tourism",{"$f":"Overview!N75","v":0},"%"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Education",{"$f":"Overview!N77","v":0},"%"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Health",{"$f":"Overview!N79","v":0},"%"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Agriculture",{"$f":"Overview!N81","v":0},"%"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Public Sector",{"$f":"Overview!N83","v":0},"%"]
[]
[null,null,null,null,"f.","Number of jobs in sustainability or green energy",null,null,null,null,null,null,null,{"$f":"Overview!N85","v":0}]
[]
[]
[null,null,"1.4. GHG emissions and energy"]
[null,null,null,null,"a.","Does the city authority have a statutory duty (legal ability) in relation to the reduction of greenhouse gases?",null,null,null,null,null,null,null,{"$f":"Overview!N88","v":0},"Y/N"]
[]
[null,null,null,null,"b.","Has a Carbon Reduction or Climate Change Strategy (or similar document) been published by the Mayor?",null,null,null,null,null,null,null,{"$f":"Overview!N90","v":0},"Y/N"]
[null,null,null,null,null,null,null,null,null,null,null,null,"year:",{"$f":"Overview!N91","v":"00:00:00"}]
[]
[null,null,null,null,null,"If yes, please provide a link to this document :",null,null,null,{"$f":"Overview!$J$93","v":0}]
[]
[null,null,null,null,"c.","Provide the total GHG emissions of your city",null,null,null,null,null,null,null,{"$f":"Overview!N95","v":0},"metric tonnes of CO2 equivalent (CO2e) per year"]
[null,null,null,null,null,null,null,null,null,null,null,null,"year:",{"$f":"Overview!N96","v":"00:00:00"}]
[]
[null,null,null,null,"d.","Provide the total primary energy consumption of your city",null,null,null,null,null,null,null,{"$f":"Overview!N98","v":0},"GWh per year"]
[null,null,null,null,null,null,null,null,null,null,null,null,"year:",{"$f":"Overview!N99","v":"00:00:00"}]
[]
[null,null,"1.5 Climate"]
[null,null,null,"1.5.1 Climate records"]
[null,null,null,null,"a.","What is the average temperature in your City?",null,null,null,null,null,null,null,{"$f":"Overview!N103","v":0},"°C"]
[]
[null,null,null,null,"b.","What is the lowest temperature recorded in your city?",null,null,null,null,null,null,null,{"$f":"Overview!N105","v":0},"°C"]
[]
[null,null,null,null,"c.","What is the highest temperature recorded in your city?",null,null,null,null,null,null,null,{"$f":"Overview!N107","v":0},"°C"]
[]
[null,null,null,null,"d.","What is the average rainfall in your city?",null,null,null,null,null,null,null,{"$f":"Overview!N109","v":0},"mm/year"]
[]
[null,null,null,null,"e.","What is the Heating Degree Days measure for the city?",null,null,null,null,null,null,null,{"$f":"Overview!N111","v":0},"°C day","Baseline temperature used for this calculation",null,null,null,null,null,"°C"]
[]
[null,null,null,null,"f.","What is the Cooling Degree Days measure for the city?",null,null,null,null,null,null,null,{"$f":"Overview!N113","v":0},"°C day","Baseline temperature used for this calculation",null,null,null,null,null,"°C"]
[]
[null,null,null,"1.5.2 Extreme weather events"]
[null,null,null,null,"a.","Has your city been affected by an extreme weather events in the past [5 years]? ",null,null,null,null,null,null,null,{"$f":"Overview!$N$116","v":0}]
[null,null,null,null,null,"Please describe the event",null,{"$f":"Overview!$H$117","v":0}]
[null,null,null,null,null,"Please estimate the value of damages caused by the event",null,null,null,null,null,null,null,{"$f":"Overview!$N$118","v":0}]
[null,null,null,{"$f":"Overview!D119","v":0},{"$f":"Overview!E119","v":0},{"$f":"Overview!F119","v":0},{"$f":"Overview!G119","v":0},{"$f":"Overview!H119","v":0},{"$f":"Overview!I119","v":0},{"$f":"Overview!J119","v":0},{"$f":"Overview!K119","v":0},{"$f":"Overview!L119","v":0},{"$f":"Overview!M119","v":0},{"$f":"Overview!N119","v":0}]
[null,null,null,{"$f":"Overview!D120","v":0},{"$f":"Overview!E120","v":0},{"$f":"Overview!F120","v":0},{"$f":"Overview!G120","v":0},{"$f":"Overview!H120","v":0},{"$f":"Overview!I120","v":0},{"$f":"Overview!J120","v":0},{"$f":"Overview!K120","v":0},{"$f":"Overview!L120","v":0},{"$f":"Overview!M120","v":0},{"$f":"Overview!N120","v":0}]
[null,null,null,{"$f":"Overview!D121","v":0},{"$f":"Overview!E121","v":0},{"$f":"Overview!F121","v":0},{"$f":"Overview!G121","v":0},{"$f":"Overview!H121","v":0},{"$f":"Overview!I121","v":0},{"$f":"Overview!J121","v":0},{"$f":"Overview!K121","v":0},{"$f":"Overview!L121","v":0},{"$f":"Overview!M121","v":0},{"$f":"Overview!N121","v":0}]
[null,null,null,{"$f":"Overview!D122","v":0},{"$f":"Overview!E122","v":0},{"$f":"Overview!F122","v":0},{"$f":"Overview!G122","v":0},{"$f":"Overview!H122","v":0},{"$f":"Overview!I122","v":0},{"$f":"Overview!J122","v":0},{"$f":"Overview!K122","v":0},{"$f":"Overview!L122","v":0},{"$f":"Overview!M122","v":0},{"$f":"Overview!N122","v":0}]
[null,null,null,{"$f":"Overview!D123","v":0},{"$f":"Overview!E123","v":0},{"$f":"Overview!F123","v":0},{"$f":"Overview!G123","v":0},{"$f":"Overview!H123","v":0},{"$f":"Overview!I123","v":0},{"$f":"Overview!J123","v":0},{"$f":"Overview!K123","v":0},{"$f":"Overview!L123","v":0},{"$f":"Overview!M123","v":0},{"$f":"Overview!N123","v":0}]
[null,null,null,{"$f":"Overview!D124","v":0},{"$f":"Overview!E124","v":0},{"$f":"Overview!F124","v":0},{"$f":"Overview!G124","v":0},{"$f":"Overview!H124","v":0},{"$f":"Overview!I124","v":0},{"$f":"Overview!J124","v":0},{"$f":"Overview!K124","v":0},{"$f":"Overview!L124","v":0},{"$f":"Overview!M124","v":0},{"$f":"Overview!N124","v":0}]
[null,null,null,{"$f":"Overview!D125","v":0},{"$f":"Overview!E125","v":0},{"$f":"Overview!F125","v":0},{"$f":"Overview!G125","v":0},{"$f":"Overview!H125","v":0},{"$f":"Overview!I125","v":0},{"$f":"Overview!J125","v":0},{"$f":"Overview!K125","v":0},{"$f":"Overview!L125","v":0},{"$f":"Overview!M125","v":0},{"$f":"Overview!N125","v":0}]
[null,null,null,{"$f":"Overview!D126","v":0},{"$f":"Overview!E126","v":0},{"$f":"Overview!F126","v":0},{"$f":"Overview!G126","v":0},{"$f":"Overview!H126","v":0},{"$f":"Overview!I126","v":0},{"$f":"Overview!J126","v":0},{"$f":"Overview!K126","v":0},{"$f":"Overview!L126","v":0},{"$f":"Overview!M126","v":0},{"$f":"Overview!N126","v":0}]
[null,null,null,{"$f":"Overview!D127","v":0},{"$f":"Overview!E127","v":0},{"$f":"Overview!F127","v":0},{"$f":"Overview!G127","v":0},{"$f":"Overview!H127","v":0},{"$f":"Overview!I127","v":0},{"$f":"Overview!J127","v":0},{"$f":"Overview!K127","v":0},{"$f":"Overview!L127","v":0},{"$f":"Overview!M127","v":0},{"$f":"Overview!N127","v":0}]
[null,null,null,{"$f":"Overview!D128","v":0},{"$f":"Overview!E128","v":0},{"$f":"Overview!F128","v":0},{"$f":"Overview!G128","v":0},{"$f":"Overview!H128","v":0},{"$f":"Overview!I128","v":0},{"$f":"Overview!J128","v":0},{"$f":"Overview!K128","v":0},{"$f":"Overview!L128","v":0},{"$f":"Overview!M128","v":0},{"$f":"Overview!N128","v":0}]
[null,null,null,{"$f":"Overview!D129","v":0},{"$f":"Overview!E129","v":0},{"$f":"Overview!F129","v":0},{"$f":"Overview!G129","v":0},{"$f":"Overview!H129","v":0},{"$f":"Overview!I129","v":0},{"$f":"Overview!J129","v":0},{"$f":"Overview!K129","v":0},{"$f":"Overview!L129","v":0},{"$f":"Overview!M129","v":0},{"$f":"Overview!N129","v":0}]
[null,null,null,{"$f":"Overview!D130","v":0},{"$f":"Overview!E130","v":0},{"$f":"Overview!F130","v":0},{"$f":"Overview!G130","v":0},{"$f":"Overview!H130","v":0},{"$f":"Overview!I130","v":0},{"$f":"Overview!J130","v":0},{"$f":"Overview!K130","v":0},{"$f":"Overview!L130","v":0},{"$f":"Overview!M130","v":0},{"$f":"Overview!N130","v":0}]
[null,null,null,{"$f":"Overview!D131","v":0},{"$f":"Overview!E131","v":0},{"$f":"Overview!F131","v":0},{"$f":"Overview!G131","v":0},{"$f":"Overview!H131","v":0},{"$f":"Overview!I131","v":0},{"$f":"Overview!J131","v":0},{"$f":"Overview!K131","v":0},{"$f":"Overview!L131","v":0},{"$f":"Overview!M131","v":0},{"$f":"Overview!N131","v":0}]
[null,null,null,{"$f":"Overview!D132","v":0},{"$f":"Overview!E132","v":0},{"$f":"Overview!F132","v":0},{"$f":"Overview!G132","v":0},{"$f":"Overview!H132","v":0},{"$f":"Overview!I132","v":0},{"$f":"Overview!J132","v":0},{"$f":"Overview!K132","v":0},{"$f":"Overview!L132","v":0},{"$f":"Overview!M132","v":0},{"$f":"Overview!N132","v":0}]
[]
[null,"2. Energy"]
[null,null,"2.1 Energy development and targets"]
[null,null,null,"2.1.1 Energy strategy"]
[null,null,null,null,"a.","Please provide a description of the existing strategies your city has for energy"]
[null,null,null,null,null,{"$f":"Energy!$F$7","v":0}]
[]
[]
[null,null,null,"2.1.2 Energy targets/goals"]
[null,null,null,null,"a.","Does your city have a target in place for reducing overall GHG emissions?",null,null,null,null,null,{"$f":"Energy!L11","v":0},"Y/N"]
[]
[null,null,null,null,"b.","If yes, what is this target?",null,null,null,null,null,{"$f":"Energy!L13","v":0},"%"]
[null,null,null,null,null,null,null,null,null,null,"Baseline year:",{"$f":"Energy!L14","v":0}]
[null,null,null,null,null,null,null,null,null,null,"Target year:",{"$f":"Energy!L15","v":0}]
[]
[null,null,"2.2 Electricity"]
[null,null,null,"2.2.1 Emissions (electricity)"]
[null,null,null,null,"a.","What is the total electricity consumed within your city?",null,null,null,null,null,{"$f":"Energy!L19","v":0},"MWh / yr"]
[]
[null,null,null,null,"b.","What is the carbon intensity of your cities grid electricity  supply?",null,null,null,null,null,{"$f":"Energy!L21","v":0},"g CO2e/kWh"]
[null,null,null,null,null,null,null,null,null,null,"year:",{"$f":"Energy!L22","v":"00:00:00"}]
[]
[null,null,null,"2.2.2 Energy mix (electricity)"]
[null,null,null,null,"a.","Please provide the current split of your city's electricity supply by source (share of energy supplied)",null,null,null,null,"Please also provide the generation capacity of each type of asset, owned and/or controlled by the city. These assets may not be within the city boundary, but must be owned and/or controlled by the city authority."]
[]
[null,null,null,null,null,null,"Natural gas",{"$f":"Energy!H27","v":0},"% of energy supply",null,null,{"$f":"Energy!L27","v":0},"MW"]
[]
[null,null,null,null,null,null,"Oil",{"$f":"Energy!H29","v":0},"% of energy supply",null,null,{"$f":"Energy!L29","v":0},"MW"]
[]
[null,null,null,null,null,null,"Coal",{"$f":"Energy!H31","v":0},"% of energy supply",null,null,{"$f":"Energy!L31","v":0},"MW"]
[]
[null,null,null,null,null,null,"Nuclear",{"$f":"Energy!H33","v":0},"% of energy supply",null,null,{"$f":"Energy!L33","v":0},"MW"]
[]
[null,null,null,null,null,null,"Biomass",{"$f":"Energy!H35","v":0},"% of energy supply",null,null,{"$f":"Energy!L35","v":0},"MW"]
[]
[null,null,null,null,null,null,"Wind",{"$f":"Energy!H37","v":0},"% of energy supply",null,null,{"$f":"Energy!L37","v":0},"MW"]
[]
[null,null,null,null,null,null,"Hydro",{"$f":"Energy!H39","v":0},"% of energy supply",null,null,{"$f":"Energy!L39","v":0},"MW"]
[]
[null,null,null,null,null,null,"Solar",{"$f":"Energy!H41","v":0},"% of energy supply",null,null,{"$f":"Energy!L41","v":0},"MW"]
[]
[null,null,null,null,null,null,"Energy from Waste",{"$f":"Energy!H43","v":0},"% of energy supply",null,null,{"$f":"Energy!L43","v":0},"MW"]
[]
[null,null,null,null,null,null,"Other",{"$f":"Energy!H45","v":0},"% of energy supply",null,null,{"$f":"Energy!L45","v":0},"MW"]
[]
[null,null,null,null,"b.","Please describe the generation types within the 'other' category",null,null,null,null,"Please describe the generation types within the 'other' category"]
[null,null,null,null,null,{"$f":"Energy!F48","v":0},null,null,null,null,{"$f":"Energy!K48","v":0}]
[]
[null,null,null,null,"c.","Please provide the percentage of your households connected to an electrical grid",null,null,null,null,null,{"$f":"Energy!L50","v":0},"%"]
[]
[null,null,null,null,"d.","What percentage of the population has access to electricity?",null,null,null,null,null,{"$f":"Energy!L52","v":0},"%"]
[]
[null,null,null,"2.2.3 Renewable generation"]
[null,null,null,null,"a.","Please provide the capacity of the electricity generated by renewables within your city"]
[null,null,null,null,null,null,null,null,null,null,"Biomass",{"$f":"Energy!L56","v":0},"MWh/yr"]
[]
[null,null,null,null,null,null,null,null,null,null,"Wind",{"$f":"Energy!L58","v":0},"MWh/yr"]
[]
[null,null,null,null,null,null,null,null,null,null,"Hydro",{"$f":"Energy!L60","v":0},"MWh/yr"]
[]
[null,null,null,null,null,null,null,null,null,null,"Solar",{"$f":"Energy!L62","v":0},"MWh/yr"]
[]
[null,null,null,null,null,null,null,null,null,null,"Other",{"$f":"Energy!L64","v":0},"MWh/yr"]
[]
[null,null,null,null,"b.","Percentage of total energy demand covered by renewable energy production in the city",null,null,null,null,null,{"$f":"Energy!L66","v":0},"%"]
[]
[null,null,null,null,"c.","State how much renewable energy is used for: ",null,null,null,null,"Electricity production",{"$f":"Energy!L68","v":0},"MWh/yr"]
[null,null,null,null,null,null,null,null,null,null,"Heat production",{"$f":"Energy!L69","v":0},"MWh/yr"]
[null,null,null,null,null,null,null,null,null,null," Fuel production",{"$f":"Energy!L70","v":0},"MWh/yr"]
[]
[null,null,null,null,"d.","How much renewable energy is produced within the city boundaries?",null,null,null,null,null,{"$f":"Energy!L72","v":0},"MWh/yr"]
[]
[null,null,null,null,"d.","How much renewable energy is imported into city?",null,null,null,null,null,{"$f":"Energy!L74","v":0},"MWh/yr"]
[]
[]
[]
[null,null,"2.3 Local energy resources"]
[null,null,null,"2.3.1","a.","Has a study been completed to identify the available resources of renewable energy in your city?",null,null,null,null,null,{"$f":"Energy!L79","v":0},"Y/N"]
[null,null,null,null,null,null,null,null,null,null,"year:",{"$f":"Energy!L80","v":0}]
[null,null,null,null,null,"If yes, please provide a web-link to this study",null,null,null,null,null,{"$f":"Energy!L81","v":0}]
[]
[null,null,"2.4 Heating"]
[null,null,null,null,"a.","Provide the annual CO2 emissions associated with the heating of buildings in your city",null,null,null,null,null,{"$f":"Energy!$L$84","v":0},"tonnes"]
[]
[]
[null,null,null,null,"b.","Provide the current breakdown of fuels used for building heating (share of energy supplied)"]
[]
[null,null,null,null,null,null,null,null,null,null,"Natural gas (district heating)",{"$f":"Energy!L89","v":0},"%"]
[]
[null,null,null,null,null,null,null,null,null,null,"Natural gas (individual boilers)",{"$f":"Energy!L91","v":0},"%"]
[]
[null,null,null,null,null,null,null,null,null,null,"Energy from Waste (district heating)",{"$f":"Energy!L93","v":0},"%"]
[]
[null,null,null,null,null,null,null,null,null,null,"Oil",{"$f":"Energy!L95","v":0},"%"]
[]
[null,null,null,null,null,null,null,null,null,null,"Coal",{"$f":"Energy!L97","v":0},"%"]
[]
[null,null,null,null,null,null,null,null,null,null,"Fuel oil",{"$f":"Energy!L99","v":0},"%"]
[]
[null,null,null,null,null,null,null,null,null,null,"Electrical heating",{"$f":"Energy!L101","v":0},"%"]
[]
[null,null,null,null,null,null,null,null,null,null,"Solar thermal",{"$f":"Energy!L103","v":0},"%"]
[]
[null,null,null,null,null,null,null,null,null,null,"Biomass",{"$f":"Energy!L105","v":0},"%"]
[]
[null,null,null,null,null,null,null,null,null,null,"Other",{"$f":"Energy!L107","v":0},"%"]
[]
[null,null,null,null,"c.","Does the city have a district heating system? ",null,null,null,null,null,{"$f":"Energy!L109","v":0},"Y/N"]
[]
[null,null,null,null,"d.","Provide the percentage of your households connected to district heating",null,null,null,null,null,{"$f":"Energy!L111","v":0},"%"]
[]
[null,null,null,null,"e.","Percentage of households connected to a gas network",null,null,null,null,null,{"$f":"Energy!L113","v":0},"%"]
[]
[null,null,"2.5 Energy demand"]
[null,null,null,"2.5.1 Energy demand and emissions"]
[null,null,null,null,"a.","Provide the proportion of your city's energy demand and carbon emissions associated with each of the following sectors."]
[null,null,null,null,null,null,null,"Electricity ",null,null,"Heating",null,null,"Transport fuel"]
[null,null,null,null,null,null,null,"Energy","Carbon emissions",null,"Energy","Carbon emissions",null,"Energy","Carbon emissions"]
[null,null,null,null,null,null,"Residential",{"$f":"Energy!H120","v":0},{"$f":"Energy!I120","v":0},{"$f":"Energy!J120","v":"%"},{"$f":"Energy!K120","v":0},{"$f":"Energy!L120","v":0},{"$f":"Energy!M120","v":"%"},{"$f":"Energy!N120","v":0},{"$f":"Energy!O120","v":0},"%"]
[]
[null,null,null,null,null,null,"Commercial",{"$f":"Energy!H122","v":0},{"$f":"Energy!I122","v":0},{"$f":"Energy!J122","v":"%"},{"$f":"Energy!K122","v":0},{"$f":"Energy!L122","v":0},{"$f":"Energy!M122","v":"%"},{"$f":"Energy!N122","v":0},{"$f":"Energy!O122","v":0},"%"]
[]
[null,null,null,null,null,null,"Retail",{"$f":"Energy!H124","v":0},{"$f":"Energy!I124","v":0},{"$f":"Energy!J124","v":"%"},{"$f":"Energy!K124","v":0},{"$f":"Energy!L124","v":0},{"$f":"Energy!M124","v":"%"},{"$f":"Energy!N124","v":0},{"$f":"Energy!O124","v":0},"%"]
[]
[null,null,null,null,null,null,"Industrial",{"$f":"Energy!H126","v":0},{"$f":"Energy!I126","v":0},{"$f":"Energy!J126","v":"%"},{"$f":"Energy!K126","v":0},{"$f":"Energy!L126","v":0},{"$f":"Energy!M126","v":"%"},{"$f":"Energy!N126","v":0},{"$f":"Energy!O126","v":0},"%"]
[]
[null,null,null,null,null,null,"Public",{"$f":"Energy!H128","v":0},{"$f":"Energy!I128","v":0},{"$f":"Energy!J128","v":"%"},{"$f":"Energy!K128","v":0},{"$f":"Energy!L128","v":0},{"$f":"Energy!M128","v":"%"},{"$f":"Energy!N128","v":0},{"$f":"Energy!O128","v":0},"%"]
[]
[null,null,null,"2.5.2 Energy efficiency"]
[null,null,null,null,"a.","What is the change in primary energy demand?",null,null,null,null,null,{"$f":"Energy!L131","v":0},"kWh/yr"]
[null,null,null,null,null,null,null,null,null,null," reference year:",{"$f":"Energy!L132","v":"00:00:00"}]
[null,null,null,null,null,null,null,null,null,null,"current year:",{"$f":"Energy!L133","v":"00:00:00"}]
[null,null,null,null,"If possible please sub-divide into:"]
[null,null,null,null,"i","Primary energy saved in energy production by using renewable energy sources ",null,null,null,null,null,{"$f":"Energy!L135","v":0},"kWh/yr"]
[]
[null,null,null,null,"ii","Primary energy saved in energy production by using energy efficient production technologies such CHP, heat pumps, use of waste heat",null,null,null,null,null,{"$f":"Energy!L137","v":0},"kWh/yr"]
[]
[]
[null,null,null,null,"iii","Primary energy saved by energy demand reduction in operational buildings’ energy demand (heat, cold, ventilation) ",null,null,null,null,null,{"$f":"Energy!L140","v":0},"kWh/yr"]
[]
[]
[null,null,null,null,"iv","Primary energy saved by energy demand reduction in lighting (in buildings, public lighting)",null,null,null,null,null,{"$f":"Energy!L143","v":0},"kWh/yr"]
[]
[null,null,null,null,"v","Primary energy saved by energy demand reduction in appliance use",null,null,null,null,null,{"$f":"Energy!L145","v":0},"kWh/yr"]
[]
[null,null,null,null,"vi","Primary energy saved by energy demand reduction in industrial processes",null,null,null,null,null,{"$f":"Energy!L147","v":0},"kWh/yr"]
[]
[null,null,null,"2.5.3 Municipal energy consumption"]
[null,null,null,null,"a.","Does the city authority purchase energy (electricity/gas/heat/oil products etc.) for use in public buildings? ",null,null,null,null,null,{"$f":"Energy!L150","v":0},"Y/N"]
[]
[null,null,null,null,null,"If yes please state the percentage of total cost of energy (electricity/gas/heat/oil products) for:"]
[null,null,null,null,null,null,null,null,null,null,"Educational",{"$f":"Energy!L153","v":0},"%"]
[]
[null,null,null,null,null,null,null,null,null,null,"Hospital",{"$f":"Energy!L155","v":0},"%"]
[]
[null,null,null,null,null,null,null,null,null,null,"Government",{"$f":"Energy!L157","v":0},"%"]
[]
[null,null,null,null,null,null,null,null,null,null,"Leisure",{"$f":"Energy!L159","v":0},"%"]
[]
[null,null,null,null,null,null,null,null,null,null,"Other",{"$f":"Energy!L161","v":0},"%"]
[]
[null,null,null,null,"c.","What is the annual energy bill for the city's buildings?",null,null,null,null,null,{"$f":"Energy!L163","v":0},"€/yr"]
[]
[null,null,null,null,"d.","Does the city have a long term energy procurement contract for municipal energy usage?",null,null,null,null,null,{"$f":"Energy!L165","v":0},"Y/N"]
[]
[null,null,null,null,"e.","If yes, what is the duration of the contract?",null,null,null,null,null,{"$f":"Energy!L167","v":0},"years"]
[]
[null,null,null,null,"f.","When is the contract next due for renewal?",null,null,null,null,"year:",{"$f":"Energy!L169","v":0}]
[]
[null,null,null,null,"g.","Can the city authority specify the carbon intensity or level of renewable generation associated with this energy supply?",null,null,null,null,null,{"$f":"Energy!L171","v":0},"Y/N"]
[]
[null,null,null,null,"h.","If yes, please provide details",null,null,null,null,null,{"$f":"Energy!L173","v":0}]
[]
[null,null,"2.6 Prices"]
[null,null,null,null,"a.","Provide the average prices to residential customers for energy in the following forms.",null,null,null,null,null,"Other associated charges (standing charges, etc.)",null,null,"Are prices regulated?"]
[null,null,null,null,null,null,"Natural gas",{"$f":"Energy!H177","v":0},"€/kWh","(select unit)",null,{"$f":"Energy!L177","v":0},null,null,{"$f":"Energy!O177","v":0},"Y/N"]
[]
[null,null,null,null,null,null,"Oil",{"$f":"Energy!H179","v":0},"€/kWh","(select unit)",null,{"$f":"Energy!L179","v":0},null,null,{"$f":"Energy!O179","v":0},"Y/N"]
[]
[null,null,null,null,null,null,"Coal",{"$f":"Energy!H181","v":0},"€/kWh","(select unit)",null,{"$f":"Energy!L181","v":0},null,null,{"$f":"Energy!O181","v":0},"Y/N"]
[]
[null,null,null,null,null,null,"Electricity",{"$f":"Energy!H183","v":0},"€/kWh","(select unit)",null,{"$f":"Energy!L183","v":0},null,null,{"$f":"Energy!O183","v":0},"Y/N"]
[]
[null,null,null,null,null,null,"Heat from district heating",{"$f":"Energy!H185","v":0},"€/kWh","(select unit)",null,{"$f":"Energy!L185","v":0},null,null,{"$f":"Energy!O185","v":0},"Y/N"]
[]
[null,null,null,null,null,null,"Biomass pellets",{"$f":"Energy!H187","v":0},"€/kWh","(select unit)",null,{"$f":"Energy!L187","v":0},null,null,{"$f":"Energy!O187","v":0},"Y/N"]
[]
[null,null,null,null,null,null,"Heating oil",{"$f":"Energy!H189","v":0},"€/kWh","(select unit)",null,{"$f":"Energy!L189","v":0},null,null,{"$f":"Energy!O189","v":0},"Y/N"]
[]
[null,null,null,null,null,null,"Petrol",{"$f":"Energy!H191","v":0},"€/kWh","(select unit)",null,{"$f":"Energy!L191","v":0},null,null,{"$f":"Energy!O191","v":0},"Y/N"]
[]
[null,null,null,null,null,null,"Diesel",{"$f":"Energy!H193","v":0},"€/kWh","(select unit)",null,{"$f":"Energy!L193","v":0},null,null,{"$f":"Energy!O193","v":0},"Y/N"]
[]
[null,null,null,null,"b.","Provide the average prices to commercial (all non-residential) customers for energy in the following forms.",null,null,null,null,null,"Other associated charges (standing charges, etc.)",null,null,"Are prices regulated?"]
[null,null,null,null,null,null,"Natural gas",{"$f":"Energy!H196","v":0},"€/kWh","(select unit)",null,{"$f":"Energy!L196","v":0},null,null,{"$f":"Energy!O196","v":0},"Y/N"]
[]
[null,null,null,null,null,null,"Oil",{"$f":"Energy!H198","v":0},"€/kWh","(select unit)",null,{"$f":"Energy!L198","v":0},null,null,{"$f":"Energy!O198","v":0},"Y/N"]
[]
[null,null,null,null,null,null,"Coal",{"$f":"Energy!H200","v":0},"€/kWh","(select unit)",null,{"$f":"Energy!L200","v":0},null,null,{"$f":"Energy!O200","v":0},"Y/N"]
[]
[null,null,null,null,null,null,"Electricity",{"$f":"Energy!H202","v":0},"€/kWh","(select unit)",null,{"$f":"Energy!L202","v":0},null,null,{"$f":"Energy!O202","v":0},"Y/N"]
[]
[null,null,null,null,null,null,"Heat from district heating",{"$f":"Energy!H204","v":0},"€/kWh","(select unit)",null,{"$f":"Energy!L204","v":0},null,null,{"$f":"Energy!O204","v":0},"Y/N"]
[]
[null,null,null,null,null,null,"Biomass pellets",{"$f":"Energy!H206","v":0},"€/kWh","(select unit)",null,{"$f":"Energy!L206","v":0},null,null,{"$f":"Energy!O206","v":0},"Y/N"]
[]
[null,null,null,null,null,null,"Heating oil",{"$f":"Energy!H208","v":0},"€/kWh","(select unit)",null,{"$f":"Energy!L208","v":0},null,null,{"$f":"Energy!O208","v":0},"Y/N"]
[]
[null,null,null,null,null,null,"Petrol",{"$f":"Energy!H210","v":0},"€/kWh","(select unit)",null,{"$f":"Energy!L210","v":0},null,null,{"$f":"Energy!O210","v":0},"Y/N"]
[]
[null,null,null,null,null,null,"Diesel",{"$f":"Energy!H212","v":0},"€/kWh","(select unit)",null,{"$f":"Energy!L212","v":0},null,null,{"$f":"Energy!O212","v":0},"Y/N"]
[]
[]
[null,null,"2.7 Fuel poverty"]
[null,null,null,null,"a.","What percentage of city inhabitants are in fuel poverty",null,null,null,null,null,{"$f":"Energy!L216","v":0},"%"]
[]
[null,null,null,null,"b.","Does your city have a target for reducing the level of fuel poverty?",null,null,null,null,null,{"$f":"Energy!L218","v":0},"Y/N"]
[]
[null,null,null,null,"c.","If yes, what is this target",null,null,null,null,null,{"$f":"Energy!L220","v":0},"%"]
[null,null,null,null,null,null,null,null,null,null,"Baseline year:",{"$f":"Energy!L221","v":0}]
[null,null,null,null,null,null,null,null,null,null,"Target year:",{"$f":"Energy!L222","v":0}]
[]
[]
[null,null,"2.8 Influence over energy assets"]
[null,null,null,null,"a.","Please select how your city authority has influence over the following energy supply assets."]
[]
[null,null,null,null,null,null,"Own/Operate Asset or Function","Set/enforce policies and regulation","Budgetary control","Set vision"]
[null,null,null,"District heating",null,null,{"$f":"Energy!G229","v":"Select from drop down list"},{"$f":"Energy!H229","v":"Select from drop down list"},{"$f":"Energy!I229","v":"Select from drop down list"},{"$f":"Energy!J229","v":"Select from drop down list"}]
[null,null,null,"Distributed power generation within city",null,null,{"$f":"Energy!G230","v":"Select from drop down list"},{"$f":"Energy!H230","v":"Select from drop down list"},{"$f":"Energy!I230","v":"Select from drop down list"},{"$f":"Energy!J230","v":"Select from drop down list"}]
[null,"3. Waste"]
[null,null,"3.1 Waste metrics and strategy"]
[null,null,null,"3.1.1 Waste strategy"]
[null,null,null,null,null,"Please provide a description of the existing strategies your city has for waste"]
[null,null,null,null,null,{"$f":"Waste!$F$8","v":0}]
[]
[]
[null,null,null,"3.1.2 Waste metrics"]
[null,null,null,null,"a.","How much waste does the city generate (kg/person/day)?",null,null,null,null,null,{"$f":"Waste!L12","v":0},"kg/person/day"]
[]
[null,null,null,null,"b.","What is your municipal waste breakdown (%)?",null,null,null,null,"Organics",{"$f":"Waste!L14","v":0},"%"]
[]
[null,null,null,null,null,null,null,null,null,null,"Metals",{"$f":"Waste!L16","v":0},"%"]
[]
[null,null,null,null,null,null,null,null,null,null,"Wood",{"$f":"Waste!L18","v":0},"%"]
[]
[null,null,null,null,null,null,null,null,null,null,"Glass",{"$f":"Waste!L20","v":0},"%"]
[]
[null,null,null,null,null,null,null,null,null,null,"Textiles",{"$f":"Waste!L22","v":0},"%"]
[]
[null,null,null,null,null,null,null,null,null,null,"Plastics",{"$f":"Waste!L24","v":0},"%"]
[]
[null,null,null,null,null,null,null,null,null,null,"Paper and cardboard",{"$f":"Waste!L26","v":0},"%"]
[]
[null,null,null,null,null,null,null,null,null,null,"Fines (soil, dust etc)",{"$f":"Waste!L28","v":0},"%"]
[]
[null,null,null,null,null,null,null,null,null,null,"Other",{"$f":"Waste!L30","v":0},"%"]
[]
[null,null,null,null,"c.","Provide a percentage split of current municipal waste treatment by method:"]
[null,null,null,null,null,null,null,null,null,null,"Re-use",{"$f":"Waste!L33","v":0},"%"]
[]
[null,null,null,null,null,null,null,null,null,null,"Recycling / composting",{"$f":"Waste!L35","v":0},"%"]
[]
[null,null,null,null,null,null,null,null,null,null,"Waste to energy",{"$f":"Waste!L37","v":0},"%"]
[]
[null,null,null,null,null,null,null,null,null,null,"Landfill",{"$f":"Waste!L39","v":0},"%"]
[]
[null,null,null,null,null,null,null,null,null,null,"Other",{"$f":"Waste!L41","v":0},"%"]
[]
[null,null,"3.2 Waste management"]
[null,null,null,null,"a.","What percentage of the city is served by a formal waste collection?",null,null,null,null,null,{"$f":"Waste!L44","v":0},"%"]
[]
[null,null,null,null,"b.","Does the city have any informal sector waste collection?",null,null,null,null,null,{"$f":"Waste!L46","v":0},"Y/N",{"$f":"Waste!$N$46","v":0}]
[]
[null,null,null,null,"c.","Does the city have recyclables collection for single-family households?",null,null,null,null,null,{"$f":"Waste!L48","v":0},"Y/N"]
[]
[null,null,null,null,"d.","Does the city have recyclables collection for multi-family buildings?",null,null,null,null,null,{"$f":"Waste!L50","v":0},"Y/N"]
[]
[null,null,null,null,"e.","Does the city have recyclables collection for commercial establishments?",null,null,null,null,null,{"$f":"Waste!L52","v":0},"Y/N"]
[]
[null,null,null,null,"f.","Does the city have organics collection for single-family households?",null,null,null,null,null,{"$f":"Waste!L54","v":0},"Y/N"]
[]
[null,null,null,null,"g.","Does the city have organics collection for multi-family buildings?",null,null,null,null,null,{"$f":"Waste!L56","v":0},"Y/N"]
[]
[null,null,null,null,"h.","Does the city have organics collection for commercial establishments?",null,null,null,null,null,{"$f":"Waste!L58","v":0},"Y/N"]
[]
[null,null,null,null,"i.","Does the city have collection fees for single-family households?",null,null,null,null,null,{"$f":"Waste!L60","v":0},"Y/N"]
[]
[null,null,null,null,"j.","Does the city have collection fees for multi-family buildings?",null,null,null,null,null,{"$f":"Waste!L62","v":0},"Y/N"]
[]
[null,null,null,null,"k.","Does the City have collection fees for commercial establishments?",null,null,null,null,null,{"$f":"Waste!L64","v":0},"Y/N"]
[]
[null,null,null,null,"l.","Is landfill gas management in place for landfills in the city?",null,null,null,null,null,{"$f":"Waste!L66","v":0},"Y/N"]
[]
[null,null,null,null,"m.","Is landfill gas used to generate energy in your city?",null,null,null,null,null,{"$f":"Waste!L68","v":0},"Y/N"]
[]
[]
[null,null,"3.3 Influence over waste assets"]
[null,null,null,null,null,"Please select how your city authority has influence over the following waste management functions"]
[]
[null,null,null,null,null,null,"Own/Operate Asset or Function","Set/enforce policies and regulation","Budgetary control","Set vision"]
[null,null,null,"Residential waste collection",null,null,{"$f":"Waste!G75","v":"Select from drop down list"},{"$f":"Waste!H75","v":"Select from drop down list"},{"$f":"Waste!I75","v":"Select from drop down list"},{"$f":"Waste!J75","v":"Select from drop down list"}]
[null,null,null,"Commercial collection",null,null,{"$f":"Waste!G76","v":"Select from drop down list"},{"$f":"Waste!H76","v":"Select from drop down list"},{"$f":"Waste!I76","v":"Select from drop down list"},{"$f":"Waste!J76","v":"Select from drop down list"}]
[null,null,null,"Construction collection",null,null,{"$f":"Waste!G77","v":"Select from drop down list"},{"$f":"Waste!H77","v":"Select from drop down list"},{"$f":"Waste!I77","v":"Select from drop down list"},{"$f":"Waste!J77","v":"Select from drop down list"}]
[null,"4. Water"]
[null,null,"4.1 Water metrics and strategy"]
[null,null,null,"4.1.1 Water strategy"]
[null,null,null,null,null,"Please provide a description of the existing strategies your city has for water"]
[null,null,null,null,null,{"$f":"Water!$F$8","v":0}]
[]
[]
[null,null,null,"4.1.2 Water Metrics"]
[null,null,null,null,"a.","How many tones of CO2 are generated annually from supplying water?"]
[]
[null,null,null,null,null,null,null,null,null,{"$f":"Water!J14","v":0},"tonnes"]
[]
[null,null,null,null,"b.","What is the percentage split of the city’s water supply? (Please select)"]
[]
[null,null,null,null,null,null,null,null,"Surface water",{"$f":"Water!J18","v":0},"%"]
[]
[null,null,null,null,null,null,null,null,"Ground water",{"$f":"Water!J20","v":0},"%"]
[]
[null,null,null,null,null,null,null,null,"Desalinated seawater",{"$f":"Water!J22","v":0},"%"]
[]
[null,null,null,null,null,null,null,null,"Recycled water",{"$f":"Water!J24","v":0},"%"]
[]
[null,null,null,null,null,null,null,null,"Other",{"$f":"Water!J26","v":0},"%"]
[]
[null,null,null,null,"c.","What is the percentage split of water consumption in the city? "]
[]
[null,null,null,null,null,null,null,null,"Residential",{"$f":"Water!J30","v":0},"%"]
[]
[null,null,null,null,null,null,null,null,"Commercial",{"$f":"Water!J32","v":0},"%"]
[]
[null,null,null,null,null,null,null,null,"Municipal",{"$f":"Water!J34","v":0},"%"]
[]
[null,null,null,null,null,null,null,null,"Industrial",{"$f":"Water!J36","v":0},"%"]
[]
[null,null,null,null,null,null,null,null,"Agriculture",{"$f":"Water!J38","v":0},"%"]
[]
[null,null,null,null,null,null,null,null,"Other",{"$f":"Water!J40","v":0},"%"]
[]
[null,null,null,null,"d.","What percentage of domestic users have a metered supply?",null,null,null,{"$f":"Water!J42","v":0},"%"]
[]
[null,null,null,null,"e.","Is metering mandatory for domestic users?",null,null,null,{"$f":"Water!J44","v":0},"Y/N"]
[]
[null,null,null,null,"f.","What percentage of industrial and commercial users have a metered supply?",null,null,null,{"$f":"Water!J46","v":0},"%"]
[]
[null,null,null,null,"g.","Is metering mandatory for industrial and commercial users?",null,null,null,{"$f":"Water!J48","v":0},"Y/N"]
[]
[null,null,null,null,"h.","What volume of wastewater is treated per day (on average)?",null,null,null,{"$f":"Water!J50","v":0},"ML"]
[]
[null,null,null,null,"i.","How is storm and waste water collected and treated? "]
[null,null,null,null,null,{"$f":"Water!$F$53","v":0}]
[]
[null,null,null,null,"k.","Does your city harness energy from its wastewater treatment processes?",null,null,null,{"$f":"Water!$J$55","v":0},"Y/N"]
[]
[]
[]
[]
[null,null,"4.2 Influence over water assets"]
[null,null,null,null,"a.","Please select how your city authority has influence over the following water management functions and assets."]
[]
[null,null,null,null,null,null,"Own/Operate Asset or Function","Set/enforce policies and regulation","Budgetary control","Set vision"]
[null,null,null,"Water supply operation",null,null,{"$f":"Water!G64","v":"Select from drop down list"},{"$f":"Water!H64","v":"Select from drop down list"},{"$f":"Water!I64","v":"Select from drop down list"},{"$f":"Water!J64","v":"Select from drop down list"}]
[null,null,null,"Storm water management",null,null,{"$f":"Water!G65","v":"Select from drop down list"},{"$f":"Water!H65","v":"Select from drop down list"},{"$f":"Water!I65","v":"Select from drop down list"},{"$f":"Water!J65","v":"Select from drop down list"}]
[null,null,null,"Wastewater Treatment",null,null,{"$f":"Water!G66","v":"Select from drop down list"},{"$f":"Water!H66","v":"Select from drop down list"},{"$f":"Water!I66","v":"Select from drop down list"},{"$f":"Water!J66","v":"Select from drop down list"}]
[null,"5. Transport"]
[null,null,"5.1 Transport metrics and strategy"]
[null,null,null,"5.1.1 Transport strategy"]
[null,null,null,null,"a.","Please provide a description of the existing strategies your city has for transport"]
[]
[]
[]
[null,null,null,null,"b.","What is the modal split for transport, i.e. the proportion of trips made (%), passenger km travelled per year and CO2 emissions per passenger km by each mode "]
[null,null,null,null,null,null,"Proportion of trips",null,"Passenger km travelled per year",null,"CO2 emissions per passenger km"]
[null,null,null,null,null,"Private motorized transport",{"$f":"Transport!G13","v":0},{"$f":"Transport!H13","v":"%"},{"$f":"Transport!I13","v":0},{"$f":"Transport!J13","v":"Passenger km/yr"},{"$f":"Transport!K13","v":0},"kg/km"]
[]
[null,null,null,null,null,"Rail/Metro/Tram",{"$f":"Transport!G15","v":0},{"$f":"Transport!H15","v":"%"},{"$f":"Transport!I15","v":0},{"$f":"Transport!J15","v":"Passenger km/yr"},{"$f":"Transport!K15","v":0},"kg/km"]
[]
[null,null,null,null,null,"Buses",{"$f":"Transport!G17","v":0},{"$f":"Transport!H17","v":"%"},{"$f":"Transport!I17","v":0},{"$f":"Transport!J17","v":"Passenger km/yr"},{"$f":"Transport!K17","v":0},"kg/km"]
[]
[null,null,null,null,null,"Ferries/ River boats",{"$f":"Transport!G19","v":0},{"$f":"Transport!H19","v":"%"},{"$f":"Transport!I19","v":0},{"$f":"Transport!J19","v":"Passenger km/yr"},{"$f":"Transport!K19","v":0},"kg/km"]
[]
[null,null,null,null,null,"Walking",{"$f":"Transport!G21","v":0},{"$f":"Transport!H21","v":"%"},{"$f":"Transport!I21","v":0},{"$f":"Transport!J21","v":"Passenger km/yr"},{"$f":"Transport!K21","v":0},"kg/km"]
[]
[null,null,null,null,null,"Taxi",{"$f":"Transport!G23","v":0},{"$f":"Transport!H23","v":"%"},{"$f":"Transport!I23","v":0},{"$f":"Transport!J23","v":"Passenger km/yr"},{"$f":"Transport!K23","v":0},"kg/km"]
[]
[null,null,null,null,null,"Cycling",{"$f":"Transport!G25","v":0},{"$f":"Transport!H25","v":"%"},{"$f":"Transport!I25","v":0},{"$f":"Transport!J25","v":"Passenger km/yr"},{"$f":"Transport!K25","v":0},"kg/km"]
[]
[null,null,null,null,null,"Other",{"$f":"Transport!G27","v":0},{"$f":"Transport!H27","v":"%"},{"$f":"Transport!I27","v":0},{"$f":"Transport!J27","v":"Passenger km/yr"},{"$f":"Transport!K27","v":0},"kg/km"]
[]
[null,null,"5.2 Transport initiatives"]
[null,null,null,"5.2.1 Public transport"]
[null,null,null,null,"a.","Does your city have an inter-modal electronic ticketing system?",null,null,null,null,{"$f":"Transport!K31","v":0},"Y/N"]
[]
[null,null,null,null,"b.","If yes, what percentage of the city population are members of the scheme?",null,null,null,null,{"$f":"Transport!K33","v":0},"%"]
[]
[null,null,null,null,"c.","Are low-emission buses in use in your city?",null,null,null,null,{"$f":"Transport!K35","v":0},"Y/N"]
[]
[null,null,null,null,"d.","If yes, what percentage of the total bus fleet is low-emission?",null,null,null,null,{"$f":"Transport!K37","v":0},"Y/N"]
[]
[null,null,null,"5.2.2 Private transport"]
[null,null,null,null,"a.","Does your city impose a charge on the use of private or commercial vehicles to reduce congestion or emissions?",null,null,null,null,null,{"$f":"Transport!L40","v":0},"Y/N"]
[]
[null,null,null,null,"b.","Does your city provide incentives to low-emission vehicles? (e.g. reduced parking or congestion charges)",null,null,null,null,null,{"$f":"Transport!L42","v":0},"Y/N"]
[]
[null,null,null,null,"c.","If yes, please provide a description of the incentives provided",null,null,null,null,{"$f":"Transport!K44","v":0}]
[]
[null,null,null,null,"d.","How many publically accessible, on-street electric vehicle charging points are installed?",null,null,null,null,{"$f":"Transport!K46","v":0}]
[]
[null,null,null,null,"e.","Does your city have a city-wide cycle-hire scheme?",null,null,null,null,{"$f":"Transport!K48","v":0},"Y/N"]
[]
[null,null,null,null,"f.","Length of cycle lanes",null,null,null,null,{"$f":"Transport!K50","v":0},"km"]
[]
[null,null,null,null,"g.","What proportion of cycle lanes in the city are segregated?",null,null,null,null,{"$f":"Transport!K52","v":0},"%"]
[]
[null,null,null,"5.2.2 Commercial transport"]
[null,null,null,null,"a.","Does your city impose emission related restrictions on the operations of ships or shipping ports?",null,null,null,null,{"$f":"Transport!K55","v":0},"Y/N"]
[]
[null,null,null,null,"b.","Does your city have an airport?",null,null,null,null,{"$f":"Transport!K57","v":0},"Y/N"]
[]
[null,null,null,null,"c.","Are there any consolidation centres to minimise freight movement within your city?",null,null,null,null,{"$f":"Transport!K59","v":0},"Y/N"]
[]
[null,null,"5.3 Influence over water assets"]
[null,null,null,null,"a.","Please select how your city authority has influence over the following transport functions and assets."]
[]
[null,null,null,null,null,null,"Own/Operate Asset or Function","Set/enforce policies and regulation","Budgetary control","Set vision"]
[null,null,null,null,null,"City roads",{"$f":"Transport!G65","v":"Select from drop down list"},{"$f":"Transport!H65","v":"Select from drop down list"},{"$f":"Transport!I65","v":"Select from drop down list"},{"$f":"Transport!J65","v":"Select from drop down list"}]
[null,null,null,null,null,"Buses",{"$f":"Transport!G66","v":"Select from drop down list"},{"$f":"Transport!H66","v":"Select from drop down list"},{"$f":"Transport!I66","v":"Select from drop down list"},{"$f":"Transport!J66","v":"Select from drop down list"}]
[null,null,null,null,null,"Rail",{"$f":"Transport!G67","v":"Select from drop down list"},{"$f":"Transport!H67","v":"Select from drop down list"},{"$f":"Transport!I67","v":"Select from drop down list"},{"$f":"Transport!J67","v":"Select from drop down list"}]
[null,"6. Buildings"]
[null,null,"6.1 Buildings metrics and strategy"]
[null,null,null,"6.1.1 Building stock"]
[null,null,null,null,"a.","Please provide a description of the existing strategies your city has for buildings"]
[null,null,null,null,null,{"$f":"Buildings!$F$8","v":0}]
[]
[]
[null,null,null,null,"b.","Please provide the percentage split of building types in your city?"]
[]
[null,null,null,null,null,null,null,null,"Residential",{"$f":"Buildings!J13","v":0}]
[]
[null,null,null,null,null,null,null,null,"Commercial",{"$f":"Buildings!J15","v":0}]
[]
[null,null,null,null,null,null,null,null,"Industrial",{"$f":"Buildings!J17","v":0}]
[]
[null,null,null,null,null,null,null,null,"Public",{"$f":"Buildings!J19","v":0}]
[]
[null,null,null,null,null,null,null,null,"Other",{"$f":"Buildings!J21","v":0}]
[]
[null,null,null,null,"c.","Please provide the number of buildings built prior to the following years?"]
[]
[null,null,null,null,null,null,null,null,1918,{"$f":"Buildings!J25","v":0}]
[]
[null,null,null,null,null,null,null,null,1945,{"$f":"Buildings!J27","v":0}]
[]
[null,null,null,null,null,null,null,null,1970,{"$f":"Buildings!J29","v":0}]
[]
[null,null,null,null,null,null,null,null,1990,{"$f":"Buildings!J31","v":0}]
[]
[null,null,null,null,"d.","How many new residences will be built:",null,null,"In the next year:",{"$f":"Buildings!J33","v":0},null,"In the next ten years:",{"$f":"Buildings!$M$33","v":0}]
[]
[null,null,null,"6.1.2 Building Energy consumption"]
[null,null,null,null,"a.","What is the percentage split of energy use in buildings across the city? Please indicate the percentage by end use."]
[]
[null,null,null,null,null,null,null,null,"Space conditioning",{"$f":"Buildings!J38","v":0},"%"]
[]
[null,null,null,null,null,null,null,null,"Refrigeration",{"$f":"Buildings!J40","v":0},"%"]
[]
[null,null,null,null,null,null,null,null,"Lighting",{"$f":"Buildings!J42","v":0},"%"]
[]
[null,null,null,null,null,null,null,null,"Hot water",{"$f":"Buildings!J44","v":0},"%"]
[]
[null,null,null,null,null,null,null,null,"Plug loads",{"$f":"Buildings!J46","v":0},"%"]
[]
[null,null,null,null,null,null,null,null,"Others",{"$f":"Buildings!J48","v":0},"%"]
[]
[null,null,null,null,"b.","Is industry in your city switching to any of the following lower-carbon fuels? (please select)"]
[]
[null,null,null,null,null,null,null,null,"Switching from coal/wood fire to electricity",{"$f":"Buildings!J52","v":0},"Y/N"]
[]
[null,null,null,null,null,null,null,null,"Switching from heating oil to natural gas",{"$f":"Buildings!J54","v":0},"Y/N"]
[]
[null,null,null,null,null,null,null,null,"Switching from residual fuel oil to distillate fuel oil",{"$f":"Buildings!J56","v":0},"Y/N"]
[]
[null,null,null,null,null,null,null,null,"Switching to biogenic heating fuels",{"$f":"Buildings!J58","v":0},"Y/N"]
[]
[null,null,null,null,null,null,null,null,"Purchase of ‘green’ electricity from the grid",{"$f":"Buildings!J60","v":0},"Y/N"]
[]
[null,null,"6.2 Planning",null,null,null,null,null,null,null,null,null,null,null,"Additional Comments"]
[null,null,null,null,"a.","Does your city have a 'compact city' strategy?",null,null,null,null,null,null,{"$f":"Buildings!M63","v":0},"Y/N",{"$f":"Buildings!O63","v":0}]
[]
[null,null,null,null,"b.","Does your city apply building codes and/or standards for new residential developments?",null,null,null,null,null,null,{"$f":"Buildings!M65","v":0},"Y/N",{"$f":"Buildings!O65","v":0}]
[]
[null,null,null,null,"c.","Does your city apply building codes and/or standards for new commercial and industrial buildings?",null,null,null,null,null,null,{"$f":"Buildings!M67","v":0},"Y/N",{"$f":"Buildings!O67","v":0}]
[]
[null,null,null,null,"d.","Do your city's planning policies encourage brownfield redevelopment?",null,null,null,null,null,null,{"$f":"Buildings!M69","v":0},"Y/N",{"$f":"Buildings!O69","v":0}]
[]
[null,null,null,null,"e.","Do your city's planning policies protect green and open spaces from development?",null,null,null,null,null,null,{"$f":"Buildings!M71","v":0},"Y/N",{"$f":"Buildings!O71","v":0}]
[]
[null,null,null,null,"f.","Does your city have an Eco district development strategy?",null,null,null,null,null,null,{"$f":"Buildings!M73","v":0},"Y/N",{"$f":"Buildings!O73","v":0}]
[]
[null,null,null,null,"g.","Are there examples of urban agriculture in your city?",null,null,null,null,null,null,{"$f":"Buildings!M75","v":0},"Y/N",{"$f":"Buildings!O75","v":0}]
[]
[null,null,null,null,"h.","Do the planning requirements for new buildings in your city address the following?",null,null,null,null,null,"If yes, please provide details of these requirements"]
[null,null,null,null,null,null,null,null,"Energy and/or carbon reduction",{"$f":"Buildings!J78","v":0},null,{"$f":"Buildings!L78","v":0}]
[]
[null,null,null,null,null,null,null,null,"Installation of onsite renewables",{"$f":"Buildings!J80","v":0},null,{"$f":"Buildings!L80","v":0}]
[]
[null,null,null,null,null,null,null,null,"Water conservation",{"$f":"Buildings!J82","v":0},null,{"$f":"Buildings!L82","v":0}]
[]
[null,null,"6.3 Influence over building assets"]
[null,null,null,null,"a.","Please select how your city authority has influence over the following buildings assets."]
[]
[null,null,null,null,null,null,"Own/Operate Asset or Function","Set/enforce policies and regulation","Budgetary control","Set vision"]
[null,null,null,"Municipal offices / buildings",null,null,{"$f":"Buildings!G88","v":"Select from drop down list"},{"$f":"Buildings!H88","v":"Select from drop down list"},{"$f":"Buildings!I88","v":"Select from drop down list"},{"$f":"Buildings!J88","v":"Select from drop down list"}]
[null,null,null,"Commercial buildings",null,null,{"$f":"Buildings!G89","v":"Select from drop down list"},{"$f":"Buildings!H89","v":"Select from drop down list"},{"$f":"Buildings!I89","v":"Select from drop down list"},{"$f":"Buildings!J89","v":"Select from drop down list"}]
[null,null,null,"Educational facilities",null,null,{"$f":"Buildings!G90","v":"Select from drop down list"},{"$f":"Buildings!H90","v":"Select from drop down list"},{"$f":"Buildings!I90","v":"Select from drop down list"},{"$f":"Buildings!J90","v":"Select from drop down list"}]
[null,"7. Information and Communication Technologies"]
[null,null,"7.1 ICT metrics and strategy"]
[null,null,null,"3.1.1 ICT strategy"]
[null,null,null,null,null,"Please provide a description of the existing strategies your city has for ICT"]
[null,null,null,null,null,{"$f":"ICT!$F$8","v":0}]
[]
[]
[null,null,null,"3.1.2 ICT metrics"]
[null,null,null,null,"a.","What proportion of people has access to the internet at home or at work?",null,null,null,null,null,{"$f":"ICT!L12","v":0},"%"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"Have an internet connection?",{"$f":"ICT!L15","v":0},"%"]
[]
[null,null,null,null,null,null,null,null,null,null,"Have a broadband connection?",{"$f":"ICT!L17","v":0},"%"]
[]
[null,null,null,null,null,null,null,null,null,null,"Have a fibre optic connection?",{"$f":"ICT!L19","v":0},"%"]
[]
[null,null,null,null,"c.","How many wireless hotspots are there in your City? ",null,null,null,null,null,{"$f":"ICT!L21","v":0}]
[]
[null,null,null,null,"d.","How many registered wireless hotspot users do you have?",null,null,null,null,null,{"$f":"ICT!L23","v":0}]
[]
[null,null,null,null,"e.","Does your City authority have a website? ",null,null,null,null,null,{"$f":"ICT!L25","v":0},"Y/N"]
[]
[null,null,null,null,null,"If yes, provide the web address.",null,null,null,null,null,{"$f":"ICT!L27","v":0}]
[]
[null,null,null,null,"f.","Does the city authority have a Twitter account, Facebook page, or some online communications forum to the public?",null,null,null,null,null,{"$f":"ICT!L29","v":0},"Y/N"]
[]
[null,null,null,null,"g.","Is there someone who is responsible for information communication technology strategy across the whole city?",null,null,null,null,null,{"$f":"ICT!L31","v":0},"Y/N"]
[]
[null,null,null,null,"h.","Does the city have an overview of total spend on ICT across the city?",null,null,null,null,null,{"$f":"ICT!L33","v":0},"Y/N"]
[]
[null,null,null,null,"i.","Does the city have a technical architecture which includes all ICT in use across the city?",null,null,null,null,null,{"$f":"ICT!L35","v":0},"Y/N"]
[]
[null,null,null,null,"j.","Has the city authority assessed the economic case for the strategic use of ICT in the city?",null,null,null,null,null,{"$f":"ICT!L37","v":0},"Y/N"]
[]
[null,null,null,null,"k.","Are there staff members within the city with a role specifically responsible for ICT?",null,null,null,null,null,{"$f":"ICT!L39","v":0},"Y/N"]
[]
[null,null,null,null,"l.","Does the city have an ICT carbon reduction target?",null,null,null,null,null,{"$f":"ICT!L41","v":0},"Y/N"]
[null,null,null,null,"m.","If yes, provide the details of this target.",null,null,null,null,null,{"$f":"ICT!L42","v":0}]
[null,null,null,null,null,null,null,null,null,null,"Year:",{"$f":"ICT!L43","v":0}]
[]
[null,null,null,null,"n.","Does your City have an internet connectivity target?",null,null,null,null,null,{"$f":"ICT!L45","v":0},"Y/N"]
[null,null,null,null,"o.","If yes, provide the details of this target.",null,null,null,null,null,{"$f":"ICT!L46","v":0}]
[null,null,null,null,null,null,null,null,null,null,"Year:",{"$f":"ICT!L47","v":0}]
[]
[null,null,null,null,"p.","Does your City have a wireless hotspot target?",null,null,null,null,null,{"$f":"ICT!L49","v":0},"Y/N"]
[null,null,null,null,"q.","If yes, provide the details of this target.",null,null,null,null,null,{"$f":"ICT!L50","v":0}]
[null,null,null,null,null,null,null,null,null,null,"Year:",{"$f":"ICT!L51","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"ICT!L52","v":0}]
[null,null,null,null,"r.","How many open data projects exist within your city?",null,null,null,null,null,{"$f":"ICT!L53","v":0}]
[]
[null,null,"7.3 Influence over ICT assets"]
[null,null,null,null,"a.","Please select how your city authority has influence over the following ICT  functions and assets"]
[]
[null,null,null,null,null,null,"Own/Operate Asset or Function","Set/enforce policies and regulation","Budgetary control","Set vision"]
[null,null,null,"Public Wifi",null,null,{"$f":"ICT!G59","v":"Select from drop down list"},{"$f":"ICT!H59","v":"Select from drop down list"},{"$f":"ICT!I59","v":"Select from drop down list"},{"$f":"ICT!J59","v":"Select from drop down list"}]
[null,null,null,"Broadband",null,null,{"$f":"ICT!G60","v":"Select from drop down list"},{"$f":"ICT!H60","v":"Select from drop down list"},{"$f":"ICT!I60","v":"Select from drop down list"},{"$f":"ICT!J60","v":"Select from drop down list"}]
[null,null,null,"Mobile Telecommunications",null,null,{"$f":"ICT!G61","v":"Select from drop down list"},{"$f":"ICT!H61","v":"Select from drop down list"},{"$f":"ICT!I61","v":"Select from drop down list"},{"$f":"ICT!J61","v":"Select from drop down list"}]

{"sheet":"Lists","index":10,"n_rows":9,"n_cols":7,"rows_kept":9,"cut":false,"hidden":true,"merged":[]}
["Assets",null,null,null,null,null,"Operations"]
["Own/Operate","Set Policies/ Regulation","Control Budget","Set Vision",null,null,"Own/Operate"]
["Select from drop down list","Select from drop down list","Select from drop down list","Select from drop down list",null,null,"Select from drop down list"]
["Owns or operates asset/service","Sets AND enforces policies/ regulations","Controls budget for asset/function","Sets the vision",null,null,"Responsible for carrying out this function"]
["Partially owns or operates assets/service ","Sets policies/ regulations, but does not enforce","Has influence over budget for asset/function","can influence the vision",null,null,"Can influence this function"]
["Does not own or operate asset/service","Enforces, but can't set policies/regulation","Has no influence over budget for asset/function","Has no influence over the vision",null,null,"Does not carry out this function"]
["N/A","Can influence policies/ regulation or enforcement","N/A","N/A",null,null,"N/A"]
[null,"Has no influence over policies/ regulation and enforcement"]
[null,"N/A"]