{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Introduction","Input","Guidance","Working","Text","Output"],"not_rendered":{"charts":1,"images":4,"macros":1,"external_links":0,"defined_names":3,"comments":1,"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":"Introduction","index":0,"n_rows":12,"n_cols":2,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,{"$f":"\"Climate Change Impact Assessment Tool (v\"&Text!C8&\")\"","v":"Climate Change Impact Assessment Tool (v1.36)"}]
[null,"Developed by Chesterfield Borough Council 2021 "]
[null,"Chesterfield Borough Council (CBC) is taking the problem of climate change very seriously, and declared a climate emergency in July 2019, with the stated goal of becoming a carbon neutral organisation by 2030. As part of our response to climate change, the council committed to introduce climate change impact assessments for all reports where decisions are made. (Climate Change Action Plan item 34). This means that if you develop or change a policy, project, service, function, or strategy, you need to identify the impact of the activity regarding the climate. Our preferred method for doing this is by conducting a Climate Change Impact Assessment (CCIA). This is similar to a risk assessment, or an equalities impact assessment: it is a structured report showing:\n\n•\tWhat effects our activities have on the climate (mainly through our emissions of greenhouse gasses) and what we are doing to reduce these effects \n•\tWhat impacts a changing climate may have on our services and functions and what actions we will take to become more resilient and less vulnerable.\n\nFor further information on how to use this tool, see the guidance notes and video tutorials."]
[null,"Guidance notes and video tutorials for Climate Change Impact Assessment tool"]
[]
[null,"This climate change impact assessment tool has been developed by Chesterfield Borough Council (CBC) for internal use. While CBC are happy to share this tool free of charge, we make no assertions about its usefulness, reliability, or fitness for purpose. This tool is supplied \"as is\" with no warranty of any kind under a Creative Commons attributional, \nnon-commercial licence."]
[null,"Attribution-NonCommercial 4.0 International"]
[]
[null,"It would be helpful to us if you could send us a copy of any revised or altered version you create and let us know how you are planning to use it. This helps us to gauge the impact of our work and justify similar projects. Please send information via email to:"]
[null,"climate@chesterfield.gov.uk"]

{"sheet":"Input","index":1,"n_rows":57,"n_cols":5,"rows_kept":57,"cut":false,"hidden":false,"merged":[]}
[]
[null,{"$f":"\"Climate Change Impact Assessment Tool (v\"&Text!C8&\")\"","v":"Climate Change Impact Assessment Tool (v1.36)"}]
[null,"Developed by Chesterfield Borough Council 2021 "]
[]
[null,"Report Name","Report Name"]
[null,"Report date","Report Date"]
[null,"Report author","Your name"]
[null,"Project Notes","Use this space for a brief overview of the project and any extra notes on things that aren't covered below. "]
[null,"Export filename",{"$f":"Text!C12","v":"Report Name CCIA Report Date"},".png"]
[]
[null,"Category","Impact","Notes / justification for score / existing work\n(see guidance sheet or attached notes for more information)","Score\n(-5 to +5)"]
[null,"Buildings","Building construction"]
[null,"Buildings","Building use"]
[null,"Buildings","Green / blue infrastructure"]
[null,"Buildings"]
[null,"Business","Developing green businesses"]
[null,"Business","Marketable skills & training"]
[null,"Business","Sustainability in business"]
[null,"Business"]
[null,"Energy","Local renewable generation capacity"]
[null,"Energy","Reducing energy demand"]
[null,"Energy","Switching away from fossil fuels"]
[null,"Energy"]
[null,"Influence","Communication & engagement"]
[null,"Influence","Wider influence"]
[null,"Influence","Working with communities"]
[null,"Influence","Working with partners"]
[null,"Influence"]
[null,"Internal Resources","Material / infrastructure requirement"]
[null,"Internal Resources","Staff time requirement"]
[null,"Internal Resources","Staff travel requirement"]
[null,"Internal Resources","External funding"]
[null,"Internal Resources"]
[null,"Land use","Carbon storage"]
[null,"Land use","Improving biodiversity adaptation"]
[null,"Land use","Natural flood management"]
[null,"Land use"]
[null,"Goods & Services","Food & Drink"]
[null,"Goods & Services","Products"]
[null,"Goods & Services","Single-use plastic"]
[null,"Goods & Services","Services"]
[null,"Goods & Services"]
[null,"Transport","Decarbonising vehicles"]
[null,"Transport","Improving infrastructure"]
[null,"Transport","Supporting people to use active travel"]
[null,"Transport"]
[null,"Waste","End of life disposal / recycling"]
[null,"Waste","Waste volume"]
[null,"Waste"]
[null,"Adaptation","Drought vulnerability"]
[null,"Adaptation","Flooding vulnerability"]
[null,"Adaptation","Heatwave vulnerability"]
[null,"Adaptation"]
[null,"Other","Other 1"]
[null,"Other","Other 2"]
[null,"Other","Other 3"]
[null,"Other","Other 4"]

{"sheet":"Guidance","index":2,"n_rows":34,"n_cols":4,"rows_kept":34,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Category","Impact","Notes & examples"]
[null,"Buildings","Building construction","How is the building constructed? Positive impacts would include retrofitting existing buildings rather than demolition and replacement, construction using low carbon materials (e.g. low concrete, additional timber) to high standard (BREEAM [Building Research Establishment Environmental Assessment Method], Passivhaus etc.) the inclusion of high grade insulation, low carbon heating, and microgeneration technologies. Negative impacts would generally be business as usual construction techniques. This is distinct from the building use impact in that it is about the fabric of the building rather than how the building is used. If it is not clear whether an impact should be in this category or the building use category below, simply choose one, and make sure you don’t report an item in both categories."]
[null,"Buildings","Building use","How is the building used? Positive impacts would include encouragement of low-carbon living and travel. This could be provision of bicycle storage, water fountains, recycling bins, automatic lighting, or passive cooling etc. Negative impacts would include removal or omission of one or more of these modifications, or alterations that discourage low carbon use (removal of cycle storage for example). If it is not clear whether an impact should be in this category or the construction category above, simply choose one, and make sure you don’t report an item in both categories."]
[null,"Buildings","Green / blue infrastructure","This includes changes to the value of green / blue infrastructure in the built environment (excluding wider land use which is included below) . Impacts may include habitat creation within a building (nesting boxes or a green roof for example) the introduction of street trees or sustainable drainage from a development. These are measures which are implemented with good building design but are not necessarily part of the building itself. Negative impacts would include habitat loss, impermeable drainage surfaces etc."]
[null,"Business","Developing green businesses","Does the activity explicitly support the development of green businesses? This impact covers businesses which are focussed on delivering green technologies, research, services etc. NOT simply an existing business implementing incremental changes to established processes and supply chains (which would be counted under sustainability in business below). Examples might be development of a new business installing solar panels, providing energy audits, or manufacturing EV charging points. Negative scores would reflect adverse effects on these businesses"]
[null,"Business","Marketable skills & training","Does this activity provide training to individuals and businesses in improving their climate change performance, or in developing marketable green skills? For example, this might include land management, waste reduction, low carbon construction, microgeneration technologies etc. Negative effects are unlikely in this category, but could include closure of a local training provider"]
[null,"Business","Sustainability in business","Does this activity support businesses in applying best practice and sustainable solutions in their existing business model and supply chains? This must be a quantifiable shift in business practice to reduce climate impact (rather than a high score simply because the business is involved in some form of low carbon technology – this would be included under the developing green businesses heading) . Examples of this might be successful application to a new certification scheme (FSC, PEFC, ISO 14001 etc.) a switch to a less carbon intensive manufacturing process, successful applications to government decarbonisation schemes etc."]
[null,"Energy","Local renewable generation capacity","Does the activity include changes to local capacity for renewable electricity heat generation? This might include solar PV panels, heat pumps, biomass boilers, wind turbines, micro-hydro etc. Negative effects would include decommissioning of local capacity, e.g. building on an existing solar farm."]
[null,"Energy","Reducing energy demand","Does the activity change overall energy demand? This might include installation of more efficient systems, or management to allow reduced heating or lighting energy demand. A negative score would represent a net increase in heating or lighting energy demand."]
[null,"Energy","Switching away from fossil fuels","Does this activity involve an increase or decrease in static fossil fuel technologies (transport is covered later). For example, replacement of an existing gas boiler with a heat pump of an equivalent rating would be a positive score. Installation of new fossil fuel systems represents a negative score in this category (even if they are more efficient than existing systems)"]
[null,"Influence","Communication & engagement","Does this activity increase awareness of climate change, and our actions to address climate change issues? Does it challenge climate change disinformation, and can we back up what we say with good quality published science? Conversely, is this activity embarrassing from a climate point of view? Is there a climate cost to a positive action that we are delivering for other reasons? Is this reasonable and justifiable?"]
[null,"Influence","Wider influence","Does this activity result in us gaining authority on a climate change issue, could we be a clear example to other local authorities, are we leading on this? A negative outcome would be us missing opportunities, failing to engage with the wider conversation, or re-inventing existing work.  "]
[null,"Influence","Working with communities","Does this activity help build awareness, willingness, and skills in our communities to address climate change? Does it have a cost or benefit in terms of our relationships with community groups?"]
[null,"Influence","Working with partners","Are we taking steps in this activity to ensure that we are working with partners with similar values to ours in relation to climate change? Is this activity expanding or limiting our work with partners more generally?"]
[null,"Internal resources","Material / infrastructure requirement","Does this activity result in us using more or less of our existing infrastructure, supplies and council resources? Will this have an indirect impact on the climate change impact of other services? Are we taking the appropriate steps to ensure that we are using the minimum necessary resource, and that it is at the highest possible environmental standard? Is there a clear constraint stopping us from doing more?"]
[null,"Internal resources","Staff time requirement","Council emissions are directly influenced by the amount of time members of staff have to work on an activity - does this activity require more staff time or less? What are the indirect effects? Does this mean that another project will have more or less resources?"]
[null,"Internal resources","Staff travel requirement","Does this activity mean that staff will need to travel more or less? Can this be reduced? Can we modify the project to change the mode of transport (public transport, cycling, walking, remote working etc.) If not, why not?"]
[null,"Internal resources","External funding","Are we able to leverage additional support for the activity from external funders? Does this mean we can achieve more than we could originally? Would support for this project preclude support for something else? How can we use external funding to help us reach our climate goals?"]
[null,"Land use","Carbon storage","Does this project result in a net increase or decrease in land carbon storage? This is likely to be directly correlated with the amount of timber (or mature trees) on the site, but may also be affected by peat formation, wetlands, or peat use as a horticultural medium. Remember that trees take a long time to grow (!) so simply replacing a mature tree with a newly planted one would still result in a loss of carbon."]
[null,"Land use","Improving biodiversity adaptation","Does this activity help or hinder the natural world's ability to cope with climate change? Are we creating, destroying, or modifying habitats? Are we joining up species rich areas or cutting that connectivity? Are there measures we could be taking to minimise the damage of our activities?"]
[null,"Land use","Natural flood management","Is this activity reducing or increasing the risk of flooding due to changes in land use? Rough vegetation, woodland, and artificial flood storage areas will decrease the risk, impermeable surfaces, open ground, and drainage directly into watercourses will increase it. Are there modifications we could make to the activity to improve its performance?"]
[null,"Goods & services","Food & Drink","Are we working to ensure that we specify lower carbon options when we buy in food and drink? Typically, we want to use food that is less land and carbon intensive to produce, process, and transport. This means we should ideally be reducing red meat and dairy consumption, and keeping supply chains as short as possible (i.e. buying locally produced food where possible). How is the food packaged? Is it wrapped in foil or plastic? Are we increasing the quantities we buy, or decreasing?"]
[null,"Goods & services","Products","Are we increasing overall consumption of products or decreasing them? External businesses providing products have their own carbon emissions. Is the product absolutely necessary? Does the supplier have an environmental policy? Is it better than their competitors?"]
[null,"Goods & services","Single-use plastic","We are committed to phasing out single use plastic where possible. Does purchase of this product increase or decrease our reliance on single use plastic? Is there an effective alternative? What does the supplier pack the product in?"]
[null,"Goods & services","Services","Are we increasing overall consumption of services or decreasing them? External businesses providing services have their own carbon emissions. Does this activity increase or decrease our indirect emissions created by relying on these services? Is the service absolutely necessary? Does the supplier have an environmental policy? Is it better than their competitors?"]
[null,"Transport","Decarbonising vehicles","Does this activity increase or decrease the use of fossil-fuelled vehicles?"]
[null,"Transport","Improving infrastructure","Does this activity increase or decrease the opportunities within the borough for low carbon forms of travel? This may include increased provision of paths, cycle storage and repair facilities, lighting on public rights of way etc. Conversely, does this activity make active forms of travel more difficult? Does it divert traffic, or block access, does it result in a net loss of training and facilities."]
[null,"Transport","Supporting people to use active travel","Does the activity provide support for people to use active forms of travel (mainly cycling and walking). This may include training and improvements to general health and fitness. Removal of any of these services would result in a negative score."]
[null,"Waste","End of life disposal / recycling","Do you expect this activity to increase or decrease the proportion of waste which is recycled? Does it increase the amount of mixing of otherwise recyclable material? Does it make recycling easier and more efficient?"]
[null,"Waste","Waste volume","Will this activity increase or decrease the total volume of waste?"]
[null,"Adaptation","Drought vulnerability","By 2050 we expect drier summers. This could mean 34% less rain, with watercourses 65% lower than the current average. How vulnerable is the activity to drought?"]
[null,"Adaptation","Flooding vulnerability","By 2050 we expect the biggest rainfall events to be up to 20% more intense than current extremes (peak rainfall intensity). Average winter rainfall may increase by 29% on today’s averages. This means that at their highest, the flow in watercourses could be 30% greater than current extremes. How vulnerable is the activity to flooding both from rivers and surface water?"]
[null,"Adaptation","Heatwave vulnerability","By 2050 we expect summer daily maximum temperature may be around 6°C higher compared to average summer temperatures now. Winter daily maximum temperature could be 4°C more than the current average, with the potential for more extreme temperatures, both warmer and colder than present. How vulnerable is the activity to heatwaves?"]

{"sheet":"Working","index":3,"n_rows":53,"n_cols":8,"rows_kept":53,"cut":false,"hidden":true,"merged":[]}
[]
[null,"Category","Sum","n impacts","n blanks","Value","Formatted Value","Formatted Label"]
[null,{"$f":"_xlfn.UNIQUE(Input!$B$12:$B$978,FALSE,FALSE)","v":"Buildings"},{"$f":"IF(ISBLANK(B3)=TRUE,\"\",SUMIFS(Input!E:E,Input!B:B,\"=\"&B3,Input!E:E,\"<>#N/A\"))","v":0},{"$f":"IF(ISBLANK(B3)=TRUE,\"\",COUNTIFS(Input!B:B,\"=\"&B3))","v":4},{"$f":"IF(ISBLANK(B3)=TRUE,\"\",COUNTIFS(Input!B:B,\"=\"&B3,Input!E:E,\"=\"&\"\"))","v":4},{"$f":"IF(OR(AND(D3=E3,B3=\"Other\"),B3=0,B3=\"\"),NA(),C3)","v":0},{"$f":"IF(AND(D3=E3,F3=0),\"\",\"(\"&TEXT(F3,\"+##,##0;-##,##0;↓↑ ##,##0\")&\")\")","v":""},{"$f":"B3&CHAR(10)&G3","v":"Buildings\n"}]
[null,"Business",{"$f":"IF(ISBLANK(B4)=TRUE,\"\",SUMIFS(Input!E:E,Input!B:B,\"=\"&B4,Input!E:E,\"<>#N/A\"))","v":0},{"$f":"IF(ISBLANK(B4)=TRUE,\"\",COUNTIFS(Input!B:B,\"=\"&B4))","v":4},{"$f":"IF(ISBLANK(B4)=TRUE,\"\",COUNTIFS(Input!B:B,\"=\"&B4,Input!E:E,\"=\"&\"\"))","v":4},0,{"$f":"IF(AND(D4=E4,F4=0),\"\",\"(\"&TEXT(F4,\"+##,##0;-##,##0;↓↑ ##,##0\")&\")\")","v":""},"Business\n"]
[null,"Energy",{"$f":"IF(ISBLANK(B5)=TRUE,\"\",SUMIFS(Input!E:E,Input!B:B,\"=\"&B5,Input!E:E,\"<>#N/A\"))","v":0},{"$f":"IF(ISBLANK(B5)=TRUE,\"\",COUNTIFS(Input!B:B,\"=\"&B5))","v":4},{"$f":"IF(ISBLANK(B5)=TRUE,\"\",COUNTIFS(Input!B:B,\"=\"&B5,Input!E:E,\"=\"&\"\"))","v":4},0,"","Energy\n"]
[null,"Influence",{"$f":"IF(ISBLANK(B6)=TRUE,\"\",SUMIFS(Input!E:E,Input!B:B,\"=\"&B6,Input!E:E,\"<>#N/A\"))","v":0},{"$f":"IF(ISBLANK(B6)=TRUE,\"\",COUNTIFS(Input!B:B,\"=\"&B6))","v":5},{"$f":"IF(ISBLANK(B6)=TRUE,\"\",COUNTIFS(Input!B:B,\"=\"&B6,Input!E:E,\"=\"&\"\"))","v":5},0,"","Influence\n"]
[null,"Internal Resources",{"$f":"IF(ISBLANK(B7)=TRUE,\"\",SUMIFS(Input!E:E,Input!B:B,\"=\"&B7,Input!E:E,\"<>#N/A\"))","v":0},{"$f":"IF(ISBLANK(B7)=TRUE,\"\",COUNTIFS(Input!B:B,\"=\"&B7))","v":5},{"$f":"IF(ISBLANK(B7)=TRUE,\"\",COUNTIFS(Input!B:B,\"=\"&B7,Input!E:E,\"=\"&\"\"))","v":5},0,"","Internal Resources\n"]
[null,"Land use",{"$f":"IF(ISBLANK(B8)=TRUE,\"\",SUMIFS(Input!E:E,Input!B:B,\"=\"&B8,Input!E:E,\"<>#N/A\"))","v":0},{"$f":"IF(ISBLANK(B8)=TRUE,\"\",COUNTIFS(Input!B:B,\"=\"&B8))","v":4},{"$f":"IF(ISBLANK(B8)=TRUE,\"\",COUNTIFS(Input!B:B,\"=\"&B8,Input!E:E,\"=\"&\"\"))","v":4},0,"","Land use\n"]
[null,"Goods & Services",{"$f":"IF(ISBLANK(B9)=TRUE,\"\",SUMIFS(Input!E:E,Input!B:B,\"=\"&B9,Input!E:E,\"<>#N/A\"))","v":0},{"$f":"IF(ISBLANK(B9)=TRUE,\"\",COUNTIFS(Input!B:B,\"=\"&B9))","v":5},{"$f":"IF(ISBLANK(B9)=TRUE,\"\",COUNTIFS(Input!B:B,\"=\"&B9,Input!E:E,\"=\"&\"\"))","v":5},0,"","Goods & Services\n"]
[null,"Transport",{"$f":"IF(ISBLANK(B10)=TRUE,\"\",SUMIFS(Input!E:E,Input!B:B,\"=\"&B10,Input!E:E,\"<>#N/A\"))","v":0},{"$f":"IF(ISBLANK(B10)=TRUE,\"\",COUNTIFS(Input!B:B,\"=\"&B10))","v":4},{"$f":"IF(ISBLANK(B10)=TRUE,\"\",COUNTIFS(Input!B:B,\"=\"&B10,Input!E:E,\"=\"&\"\"))","v":4},0,"","Transport\n"]
[null,"Waste",{"$f":"IF(ISBLANK(B11)=TRUE,\"\",SUMIFS(Input!E:E,Input!B:B,\"=\"&B11,Input!E:E,\"<>#N/A\"))","v":0},{"$f":"IF(ISBLANK(B11)=TRUE,\"\",COUNTIFS(Input!B:B,\"=\"&B11))","v":3},{"$f":"IF(ISBLANK(B11)=TRUE,\"\",COUNTIFS(Input!B:B,\"=\"&B11,Input!E:E,\"=\"&\"\"))","v":3},0,"","Waste\n"]
[null,"Adaptation",{"$f":"IF(ISBLANK(B12)=TRUE,\"\",SUMIFS(Input!E:E,Input!B:B,\"=\"&B12,Input!E:E,\"<>#N/A\"))","v":0},{"$f":"IF(ISBLANK(B12)=TRUE,\"\",COUNTIFS(Input!B:B,\"=\"&B12))","v":4},{"$f":"IF(ISBLANK(B12)=TRUE,\"\",COUNTIFS(Input!B:B,\"=\"&B12,Input!E:E,\"=\"&\"\"))","v":4},0,"","Adaptation\n"]
[null,"Other",{"$f":"IF(ISBLANK(B13)=TRUE,\"\",SUMIFS(Input!E:E,Input!B:B,\"=\"&B13,Input!E:E,\"<>#N/A\"))","v":0},{"$f":"IF(ISBLANK(B13)=TRUE,\"\",COUNTIFS(Input!B:B,\"=\"&B13))","v":4},{"$f":"IF(ISBLANK(B13)=TRUE,\"\",COUNTIFS(Input!B:B,\"=\"&B13,Input!E:E,\"=\"&\"\"))","v":4},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,0,{"$f":"IF(ISBLANK(B14)=TRUE,\"\",SUMIFS(Input!E:E,Input!B:B,\"=\"&B14,Input!E:E,\"<>#N/A\"))","v":0},{"$f":"IF(ISBLANK(B14)=TRUE,\"\",COUNTIFS(Input!B:B,\"=\"&B14))","v":0},{"$f":"IF(ISBLANK(B14)=TRUE,\"\",COUNTIFS(Input!B:B,\"=\"&B14,Input!E:E,\"=\"&\"\"))","v":0},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,{"$f":"IF(ISBLANK(B15)=TRUE,\"\",SUMIFS(Input!E:E,Input!B:B,\"=\"&B15,Input!E:E,\"<>#N/A\"))","v":""},{"$f":"IF(ISBLANK(B15)=TRUE,\"\",COUNTIFS(Input!B:B,\"=\"&B15))","v":""},{"$f":"IF(ISBLANK(B15)=TRUE,\"\",COUNTIFS(Input!B:B,\"=\"&B15,Input!E:E,\"=\"&\"\"))","v":""},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,{"$f":"IF(ISBLANK(B16)=TRUE,\"\",SUMIFS(Input!E:E,Input!B:B,\"=\"&B16,Input!E:E,\"<>#N/A\"))","v":""},{"$f":"IF(ISBLANK(B16)=TRUE,\"\",COUNTIFS(Input!B:B,\"=\"&B16))","v":""},{"$f":"IF(ISBLANK(B16)=TRUE,\"\",COUNTIFS(Input!B:B,\"=\"&B16,Input!E:E,\"=\"&\"\"))","v":""},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,{"$f":"IF(ISBLANK(B17)=TRUE,\"\",SUMIFS(Input!E:E,Input!B:B,\"=\"&B17,Input!E:E,\"<>#N/A\"))","v":""},{"$f":"IF(ISBLANK(B17)=TRUE,\"\",COUNTIFS(Input!B:B,\"=\"&B17))","v":""},{"$f":"IF(ISBLANK(B17)=TRUE,\"\",COUNTIFS(Input!B:B,\"=\"&B17,Input!E:E,\"=\"&\"\"))","v":""},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,{"$f":"IF(ISBLANK(B18)=TRUE,\"\",SUMIFS(Input!E:E,Input!B:B,\"=\"&B18,Input!E:E,\"<>#N/A\"))","v":""},{"$f":"IF(ISBLANK(B18)=TRUE,\"\",COUNTIFS(Input!B:B,\"=\"&B18))","v":""},{"$f":"IF(ISBLANK(B18)=TRUE,\"\",COUNTIFS(Input!B:B,\"=\"&B18,Input!E:E,\"=\"&\"\"))","v":""},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,{"$f":"IF(ISBLANK(B19)=TRUE,\"\",SUMIFS(Input!E:E,Input!B:B,\"=\"&B19,Input!E:E,\"<>#N/A\"))","v":""},{"$f":"IF(ISBLANK(B19)=TRUE,\"\",COUNTIFS(Input!B:B,\"=\"&B19))","v":""},{"$f":"IF(ISBLANK(B19)=TRUE,\"\",COUNTIFS(Input!B:B,\"=\"&B19,Input!E:E,\"=\"&\"\"))","v":""},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,{"$f":"IF(ISBLANK(B20)=TRUE,\"\",SUMIFS(Input!E:E,Input!B:B,\"=\"&B20,Input!E:E,\"<>#N/A\"))","v":""},{"$f":"IF(ISBLANK(B20)=TRUE,\"\",COUNTIFS(Input!B:B,\"=\"&B20))","v":""},{"$f":"IF(ISBLANK(B20)=TRUE,\"\",COUNTIFS(Input!B:B,\"=\"&B20,Input!E:E,\"=\"&\"\"))","v":""},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,{"$f":"IF(ISBLANK(B21)=TRUE,\"\",SUMIFS(Input!E:E,Input!B:B,\"=\"&B21,Input!E:E,\"<>#N/A\"))","v":""},{"$f":"IF(ISBLANK(B21)=TRUE,\"\",COUNTIFS(Input!B:B,\"=\"&B21))","v":""},{"$f":"IF(ISBLANK(B21)=TRUE,\"\",COUNTIFS(Input!B:B,\"=\"&B21,Input!E:E,\"=\"&\"\"))","v":""},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,{"$f":"IF(ISBLANK(B22)=TRUE,\"\",SUMIFS(Input!E:E,Input!B:B,\"=\"&B22,Input!E:E,\"<>#N/A\"))","v":""},{"$f":"IF(ISBLANK(B22)=TRUE,\"\",COUNTIFS(Input!B:B,\"=\"&B22))","v":""},{"$f":"IF(ISBLANK(B22)=TRUE,\"\",COUNTIFS(Input!B:B,\"=\"&B22,Input!E:E,\"=\"&\"\"))","v":""},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,{"$f":"IF(ISBLANK(B23)=TRUE,\"\",SUMIFS(Input!E:E,Input!B:B,\"=\"&B23,Input!E:E,\"<>#N/A\"))","v":""},{"$f":"IF(ISBLANK(B23)=TRUE,\"\",COUNTIFS(Input!B:B,\"=\"&B23))","v":""},{"$f":"IF(ISBLANK(B23)=TRUE,\"\",COUNTIFS(Input!B:B,\"=\"&B23,Input!E:E,\"=\"&\"\"))","v":""},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,{"$f":"IF(ISBLANK(B24)=TRUE,\"\",SUMIFS(Input!E:E,Input!B:B,\"=\"&B24,Input!E:E,\"<>#N/A\"))","v":""},{"$f":"IF(ISBLANK(B24)=TRUE,\"\",COUNTIFS(Input!B:B,\"=\"&B24))","v":""},{"$f":"IF(ISBLANK(B24)=TRUE,\"\",COUNTIFS(Input!B:B,\"=\"&B24,Input!E:E,\"=\"&\"\"))","v":""},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,{"$f":"IF(ISBLANK(B25)=TRUE,\"\",SUMIFS(Input!E:E,Input!B:B,\"=\"&B25,Input!E:E,\"<>#N/A\"))","v":""},{"$f":"IF(ISBLANK(B25)=TRUE,\"\",COUNTIFS(Input!B:B,\"=\"&B25))","v":""},{"$f":"IF(ISBLANK(B25)=TRUE,\"\",COUNTIFS(Input!B:B,\"=\"&B25,Input!E:E,\"=\"&\"\"))","v":""},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,{"$f":"IF(ISBLANK(B26)=TRUE,\"\",SUMIFS(Input!E:E,Input!B:B,\"=\"&B26,Input!E:E,\"<>#N/A\"))","v":""},{"$f":"IF(ISBLANK(B26)=TRUE,\"\",COUNTIFS(Input!B:B,\"=\"&B26))","v":""},{"$f":"IF(ISBLANK(B26)=TRUE,\"\",COUNTIFS(Input!B:B,\"=\"&B26,Input!E:E,\"=\"&\"\"))","v":""},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,{"$f":"IF(ISBLANK(B27)=TRUE,\"\",SUMIFS(Input!E:E,Input!B:B,\"=\"&B27,Input!E:E,\"<>#N/A\"))","v":""},{"$f":"IF(ISBLANK(B27)=TRUE,\"\",COUNTIFS(Input!B:B,\"=\"&B27))","v":""},{"$f":"IF(ISBLANK(B27)=TRUE,\"\",COUNTIFS(Input!B:B,\"=\"&B27,Input!E:E,\"=\"&\"\"))","v":""},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,{"$f":"IF(ISBLANK(B28)=TRUE,\"\",SUMIFS(Input!E:E,Input!B:B,\"=\"&B28,Input!E:E,\"<>#N/A\"))","v":""},{"$f":"IF(ISBLANK(B28)=TRUE,\"\",COUNTIFS(Input!B:B,\"=\"&B28))","v":""},{"$f":"IF(ISBLANK(B28)=TRUE,\"\",COUNTIFS(Input!B:B,\"=\"&B28,Input!E:E,\"=\"&\"\"))","v":""},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,{"$f":"IF(ISBLANK(B29)=TRUE,\"\",SUMIFS(Input!E:E,Input!B:B,\"=\"&B29,Input!E:E,\"<>#N/A\"))","v":""},{"$f":"IF(ISBLANK(B29)=TRUE,\"\",COUNTIFS(Input!B:B,\"=\"&B29))","v":""},{"$f":"IF(ISBLANK(B29)=TRUE,\"\",COUNTIFS(Input!B:B,\"=\"&B29,Input!E:E,\"=\"&\"\"))","v":""},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,{"$f":"IF(ISBLANK(B30)=TRUE,\"\",SUMIFS(Input!E:E,Input!B:B,\"=\"&B30,Input!E:E,\"<>#N/A\"))","v":""},{"$f":"IF(ISBLANK(B30)=TRUE,\"\",COUNTIFS(Input!B:B,\"=\"&B30))","v":""},{"$f":"IF(ISBLANK(B30)=TRUE,\"\",COUNTIFS(Input!B:B,\"=\"&B30,Input!E:E,\"=\"&\"\"))","v":""},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,{"$f":"IF(ISBLANK(B31)=TRUE,\"\",SUMIFS(Input!E:E,Input!B:B,\"=\"&B31,Input!E:E,\"<>#N/A\"))","v":""},{"$f":"IF(ISBLANK(B31)=TRUE,\"\",COUNTIFS(Input!B:B,\"=\"&B31))","v":""},{"$f":"IF(ISBLANK(B31)=TRUE,\"\",COUNTIFS(Input!B:B,\"=\"&B31,Input!E:E,\"=\"&\"\"))","v":""},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,{"$f":"IF(ISBLANK(B32)=TRUE,\"\",SUMIFS(Input!E:E,Input!B:B,\"=\"&B32,Input!E:E,\"<>#N/A\"))","v":""},{"$f":"IF(ISBLANK(B32)=TRUE,\"\",COUNTIFS(Input!B:B,\"=\"&B32))","v":""},{"$f":"IF(ISBLANK(B32)=TRUE,\"\",COUNTIFS(Input!B:B,\"=\"&B32,Input!E:E,\"=\"&\"\"))","v":""},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,{"$f":"IF(ISBLANK(B33)=TRUE,\"\",SUMIFS(Input!E:E,Input!B:B,\"=\"&B33,Input!E:E,\"<>#N/A\"))","v":""},{"$f":"IF(ISBLANK(B33)=TRUE,\"\",COUNTIFS(Input!B:B,\"=\"&B33))","v":""},{"$f":"IF(ISBLANK(B33)=TRUE,\"\",COUNTIFS(Input!B:B,\"=\"&B33,Input!E:E,\"=\"&\"\"))","v":""},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,{"$f":"IF(ISBLANK(B34)=TRUE,\"\",SUMIFS(Input!E:E,Input!B:B,\"=\"&B34,Input!E:E,\"<>#N/A\"))","v":""},{"$f":"IF(ISBLANK(B34)=TRUE,\"\",COUNTIFS(Input!B:B,\"=\"&B34))","v":""},{"$f":"IF(ISBLANK(B34)=TRUE,\"\",COUNTIFS(Input!B:B,\"=\"&B34,Input!E:E,\"=\"&\"\"))","v":""},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,{"$f":"IF(ISBLANK(B35)=TRUE,\"\",SUMIFS(Input!E:E,Input!B:B,\"=\"&B35,Input!E:E,\"<>#N/A\"))","v":""},{"$f":"IF(ISBLANK(B35)=TRUE,\"\",COUNTIFS(Input!B:B,\"=\"&B35))","v":""},{"$f":"IF(ISBLANK(B35)=TRUE,\"\",COUNTIFS(Input!B:B,\"=\"&B35,Input!E:E,\"=\"&\"\"))","v":""},{"$f":"IF(OR(AND(D35=E35,B35=\"Other\"),B35=0,B35=\"\"),NA(),C35)","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$f":"B35&CHAR(10)&G35","v":{"$error":"#N/A"}}]
[null,null,{"$f":"IF(ISBLANK(B36)=TRUE,\"\",SUMIFS(Input!E:E,Input!B:B,\"=\"&B36,Input!E:E,\"<>#N/A\"))","v":""},{"$f":"IF(ISBLANK(B36)=TRUE,\"\",COUNTIFS(Input!B:B,\"=\"&B36))","v":""},{"$f":"IF(ISBLANK(B36)=TRUE,\"\",COUNTIFS(Input!B:B,\"=\"&B36,Input!E:E,\"=\"&\"\"))","v":""},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,{"$f":"IF(ISBLANK(B37)=TRUE,\"\",SUMIFS(Input!E:E,Input!B:B,\"=\"&B37,Input!E:E,\"<>#N/A\"))","v":""},{"$f":"IF(ISBLANK(B37)=TRUE,\"\",COUNTIFS(Input!B:B,\"=\"&B37))","v":""},{"$f":"IF(ISBLANK(B37)=TRUE,\"\",COUNTIFS(Input!B:B,\"=\"&B37,Input!E:E,\"=\"&\"\"))","v":""},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,{"$f":"IF(ISBLANK(B38)=TRUE,\"\",SUMIFS(Input!E:E,Input!B:B,\"=\"&B38,Input!E:E,\"<>#N/A\"))","v":""},{"$f":"IF(ISBLANK(B38)=TRUE,\"\",COUNTIFS(Input!B:B,\"=\"&B38))","v":""},{"$f":"IF(ISBLANK(B38)=TRUE,\"\",COUNTIFS(Input!B:B,\"=\"&B38,Input!E:E,\"=\"&\"\"))","v":""},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,{"$f":"IF(ISBLANK(B39)=TRUE,\"\",SUMIFS(Input!E:E,Input!B:B,\"=\"&B39,Input!E:E,\"<>#N/A\"))","v":""},{"$f":"IF(ISBLANK(B39)=TRUE,\"\",COUNTIFS(Input!B:B,\"=\"&B39))","v":""},{"$f":"IF(ISBLANK(B39)=TRUE,\"\",COUNTIFS(Input!B:B,\"=\"&B39,Input!E:E,\"=\"&\"\"))","v":""},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,{"$f":"IF(ISBLANK(B40)=TRUE,\"\",SUMIFS(Input!E:E,Input!B:B,\"=\"&B40,Input!E:E,\"<>#N/A\"))","v":""},{"$f":"IF(ISBLANK(B40)=TRUE,\"\",COUNTIFS(Input!B:B,\"=\"&B40))","v":""},{"$f":"IF(ISBLANK(B40)=TRUE,\"\",COUNTIFS(Input!B:B,\"=\"&B40,Input!E:E,\"=\"&\"\"))","v":""},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,{"$f":"IF(ISBLANK(B41)=TRUE,\"\",SUMIFS(Input!E:E,Input!B:B,\"=\"&B41,Input!E:E,\"<>#N/A\"))","v":""},{"$f":"IF(ISBLANK(B41)=TRUE,\"\",COUNTIFS(Input!B:B,\"=\"&B41))","v":""},{"$f":"IF(ISBLANK(B41)=TRUE,\"\",COUNTIFS(Input!B:B,\"=\"&B41,Input!E:E,\"=\"&\"\"))","v":""},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,{"$f":"IF(ISBLANK(B42)=TRUE,\"\",SUMIFS(Input!E:E,Input!B:B,\"=\"&B42,Input!E:E,\"<>#N/A\"))","v":""},{"$f":"IF(ISBLANK(B42)=TRUE,\"\",COUNTIFS(Input!B:B,\"=\"&B42))","v":""},{"$f":"IF(ISBLANK(B42)=TRUE,\"\",COUNTIFS(Input!B:B,\"=\"&B42,Input!E:E,\"=\"&\"\"))","v":""},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,{"$f":"IF(ISBLANK(B43)=TRUE,\"\",SUMIFS(Input!E:E,Input!B:B,\"=\"&B43,Input!E:E,\"<>#N/A\"))","v":""},{"$f":"IF(ISBLANK(B43)=TRUE,\"\",COUNTIFS(Input!B:B,\"=\"&B43))","v":""},{"$f":"IF(ISBLANK(B43)=TRUE,\"\",COUNTIFS(Input!B:B,\"=\"&B43,Input!E:E,\"=\"&\"\"))","v":""},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,{"$f":"IF(ISBLANK(B44)=TRUE,\"\",SUMIFS(Input!E:E,Input!B:B,\"=\"&B44,Input!E:E,\"<>#N/A\"))","v":""},{"$f":"IF(ISBLANK(B44)=TRUE,\"\",COUNTIFS(Input!B:B,\"=\"&B44))","v":""},{"$f":"IF(ISBLANK(B44)=TRUE,\"\",COUNTIFS(Input!B:B,\"=\"&B44,Input!E:E,\"=\"&\"\"))","v":""},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,{"$f":"IF(ISBLANK(B45)=TRUE,\"\",SUMIFS(Input!E:E,Input!B:B,\"=\"&B45,Input!E:E,\"<>#N/A\"))","v":""},{"$f":"IF(ISBLANK(B45)=TRUE,\"\",COUNTIFS(Input!B:B,\"=\"&B45))","v":""},{"$f":"IF(ISBLANK(B45)=TRUE,\"\",COUNTIFS(Input!B:B,\"=\"&B45,Input!E:E,\"=\"&\"\"))","v":""},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,{"$f":"IF(ISBLANK(B46)=TRUE,\"\",SUMIFS(Input!E:E,Input!B:B,\"=\"&B46,Input!E:E,\"<>#N/A\"))","v":""},{"$f":"IF(ISBLANK(B46)=TRUE,\"\",COUNTIFS(Input!B:B,\"=\"&B46))","v":""},{"$f":"IF(ISBLANK(B46)=TRUE,\"\",COUNTIFS(Input!B:B,\"=\"&B46,Input!E:E,\"=\"&\"\"))","v":""},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,{"$f":"IF(ISBLANK(B47)=TRUE,\"\",SUMIFS(Input!E:E,Input!B:B,\"=\"&B47,Input!E:E,\"<>#N/A\"))","v":""},{"$f":"IF(ISBLANK(B47)=TRUE,\"\",COUNTIFS(Input!B:B,\"=\"&B47))","v":""},{"$f":"IF(ISBLANK(B47)=TRUE,\"\",COUNTIFS(Input!B:B,\"=\"&B47,Input!E:E,\"=\"&\"\"))","v":""},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,{"$f":"IF(ISBLANK(B48)=TRUE,\"\",SUMIFS(Input!E:E,Input!B:B,\"=\"&B48,Input!E:E,\"<>#N/A\"))","v":""},{"$f":"IF(ISBLANK(B48)=TRUE,\"\",COUNTIFS(Input!B:B,\"=\"&B48))","v":""},{"$f":"IF(ISBLANK(B48)=TRUE,\"\",COUNTIFS(Input!B:B,\"=\"&B48,Input!E:E,\"=\"&\"\"))","v":""},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,{"$f":"IF(ISBLANK(B49)=TRUE,\"\",SUMIFS(Input!E:E,Input!B:B,\"=\"&B49,Input!E:E,\"<>#N/A\"))","v":""},{"$f":"IF(ISBLANK(B49)=TRUE,\"\",COUNTIFS(Input!B:B,\"=\"&B49))","v":""},{"$f":"IF(ISBLANK(B49)=TRUE,\"\",COUNTIFS(Input!B:B,\"=\"&B49,Input!E:E,\"=\"&\"\"))","v":""},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,{"$f":"IF(ISBLANK(B50)=TRUE,\"\",SUMIFS(Input!E:E,Input!B:B,\"=\"&B50,Input!E:E,\"<>#N/A\"))","v":""},{"$f":"IF(ISBLANK(B50)=TRUE,\"\",COUNTIFS(Input!B:B,\"=\"&B50))","v":""},{"$f":"IF(ISBLANK(B50)=TRUE,\"\",COUNTIFS(Input!B:B,\"=\"&B50,Input!E:E,\"=\"&\"\"))","v":""},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,{"$f":"IF(ISBLANK(B51)=TRUE,\"\",SUMIFS(Input!E:E,Input!B:B,\"=\"&B51,Input!E:E,\"<>#N/A\"))","v":""},{"$f":"IF(ISBLANK(B51)=TRUE,\"\",COUNTIFS(Input!B:B,\"=\"&B51))","v":""},{"$f":"IF(ISBLANK(B51)=TRUE,\"\",COUNTIFS(Input!B:B,\"=\"&B51,Input!E:E,\"=\"&\"\"))","v":""},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,{"$f":"IF(ISBLANK(B52)=TRUE,\"\",SUMIFS(Input!E:E,Input!B:B,\"=\"&B52,Input!E:E,\"<>#N/A\"))","v":""},{"$f":"IF(ISBLANK(B52)=TRUE,\"\",COUNTIFS(Input!B:B,\"=\"&B52))","v":""},{"$f":"IF(ISBLANK(B52)=TRUE,\"\",COUNTIFS(Input!B:B,\"=\"&B52,Input!E:E,\"=\"&\"\"))","v":""},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,{"$f":"IF(ISBLANK(B53)=TRUE,\"\",SUMIFS(Input!E:E,Input!B:B,\"=\"&B53,Input!E:E,\"<>#N/A\"))","v":""},{"$f":"IF(ISBLANK(B53)=TRUE,\"\",COUNTIFS(Input!B:B,\"=\"&B53))","v":""},{"$f":"IF(ISBLANK(B53)=TRUE,\"\",COUNTIFS(Input!B:B,\"=\"&B53,Input!E:E,\"=\"&\"\"))","v":""},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]

{"sheet":"Text","index":4,"n_rows":67,"n_cols":7,"rows_kept":67,"cut":false,"hidden":true,"merged":[[15,1,66,1],[3,4,3,5]]}
[]
[null,"Target 1",{"$f":"DATE(2030,1,1)","v":"2030-01-01"},null,"Only edit the light blue boxes by hand (everything else is calculated)"]
[null,"Target 2","2050-01-01"]
[null,"Today (code)",{"$f":"TODAY()","v":"2021-12-23"},null,"Rag rating hex colours",null,"< for guidance only, all colour fomatting on the chart is carried out using conditional formatting and VBA"]
[null,"Today (text)",{"$f":"CONCATENATE(TEXT(TODAY(), \"dd/mm/yy\"))","v":"23/12/21"},null,"Red","E03A3E"]
[null,"Time to target 1",{"$f":"DATEDIF($C$4,C2,\"y\") &\" years and \"&DATEDIF($C$4,C2,\"ym\") &\" months\"","v":"8 years and 0 months"},null,"Amber","FDB827"]
[null,"Time to target 2",{"$f":"DATEDIF($C$4,C3,\"y\") &\" years, \"&DATEDIF($C$4,C3,\"ym\") &\" months, and \" &DATEDIF($C$4,C3,\"md\") &\" days\"","v":"28 years, 0 months, and 9 days"},null,"Neutral","b8b8b8"]
[null,"Version",1.36,null,"Green","61BB46"]
[null,"Text label",{"$f":"\"Chesterfield Borough Council has committed to being a carbon neutral organisation by 2030 (\"&Text!C6&\" away).\"","v":"Chesterfield Borough Council has committed to being a carbon neutral organisation by 2030 (8 years and 0 months away)."},null,"Really_Green","406F31"]
[null,"Text label 2",{"$f":"\"Generated \"&C5&\" v\"&Text!C8","v":"Generated 23/12/21 v1.36"}]
[null,"Centre index",{"$f":"SUMIF(Working!C:C,\"<>#N/A\")","v":0}]
[null,"default filename",{"$f":"IF(Input!C6=\"\",Input!C5&\" CCIA \"&TEXT(C4,\"dd.mm.yy\"),Input!C5&\" CCIA \"&TEXT(Input!C6,\"dd.mm.yyyy\"))","v":"Report Name CCIA Report Date"}]
[null,"output filename",{"$f":"IF(Input!C9 = C12, Text!C12,Input!C9)","v":"Report Name CCIA Report Date"}]
[null,"alt text",{"$f":"_xlfn.CONCAT(C16:C67)","v":"The infographic shows the relative costs and benefits of the decision on 10 different categories with respect to the climate: Buildings, no effect. Business, no effect. Energy, no effect. Influence, no effect. Internal Resources, no effect. Land use, no effect. Goods & Services, no effect. Transport, no effect. Waste, no effect. Adaptation, no effect. "}]
[null,"Number of categories",{"$f":"SUMIF(Output!D:D,\"<>#N/A\")","v":10}]
[null,"Alt text content",{"$f":"\"The infographic shows the relative costs and benefits of the decision on \"&C15&\" different categories with respect to the climate: \"","v":"The infographic shows the relative costs and benefits of the decision on 10 different categories with respect to the climate: "},"Alt text working"]
[null,null,{"$f":"IFERROR(IF(F17<>\"#N/A\",D17&E17&\". \",\"\"),\"\")","v":"Buildings, no effect. "},{"$f":"Working!B3&\",\"","v":"Buildings,"},{"$f":"IFERROR(IF(AND(Working!D3=Working!E3,Working!F3=0),\" no effect\",F17),\"\")","v":" no effect"},{"$f":"IF(Working!F3=0,\" no net effect\",IF(Working!F3<0,\" minus \"&ABS(Working!F3),\" plus \"&ABS(Working!F3)))","v":" no net effect"}]
[null,null,{"$f":"IFERROR(IF(F18<>\"#N/A\",D18&E18&\". \",\"\"),\"\")","v":"Business, no effect. "},{"$f":"Working!B4&\",\"","v":"Business,"},{"$f":"IFERROR(IF(AND(Working!D4=Working!E4,Working!F4=0),\" no effect\",F18),\"\")","v":" no effect"},{"$f":"IF(Working!F4=0,\" no net effect\",IF(Working!F4<0,\" minus \"&ABS(Working!F4),\" plus \"&ABS(Working!F4)))","v":" no net effect"}]
[null,null,"Energy, no effect. ",{"$f":"Working!B5&\",\"","v":"Energy,"},{"$f":"IFERROR(IF(AND(Working!D5=Working!E5,Working!F5=0),\" no effect\",F19),\"\")","v":" no effect"},{"$f":"IF(Working!F5=0,\" no net effect\",IF(Working!F5<0,\" minus \"&ABS(Working!F5),\" plus \"&ABS(Working!F5)))","v":" no net effect"}]
[null,null,{"$f":"IFERROR(IF(F20<>\"#N/A\",D20&E20&\". \",\"\"),\"\")","v":"Influence, no effect. "},{"$f":"Working!B6&\",\"","v":"Influence,"},{"$f":"IFERROR(IF(AND(Working!D6=Working!E6,Working!F6=0),\" no effect\",F20),\"\")","v":" no effect"},{"$f":"IF(Working!F6=0,\" no net effect\",IF(Working!F6<0,\" minus \"&ABS(Working!F6),\" plus \"&ABS(Working!F6)))","v":" no net effect"}]
[null,null,"Internal Resources, no effect. ",{"$f":"Working!B7&\",\"","v":"Internal Resources,"},{"$f":"IFERROR(IF(AND(Working!D7=Working!E7,Working!F7=0),\" no effect\",F21),\"\")","v":" no effect"},{"$f":"IF(Working!F7=0,\" no net effect\",IF(Working!F7<0,\" minus \"&ABS(Working!F7),\" plus \"&ABS(Working!F7)))","v":" no net effect"}]
[null,null,"Land use, no effect. ",{"$f":"Working!B8&\",\"","v":"Land use,"},{"$f":"IFERROR(IF(AND(Working!D8=Working!E8,Working!F8=0),\" no effect\",F22),\"\")","v":" no effect"},{"$f":"IF(Working!F8=0,\" no net effect\",IF(Working!F8<0,\" minus \"&ABS(Working!F8),\" plus \"&ABS(Working!F8)))","v":" no net effect"}]
[null,null,"Goods & Services, no effect. ",{"$f":"Working!B9&\",\"","v":"Goods & Services,"},{"$f":"IFERROR(IF(AND(Working!D9=Working!E9,Working!F9=0),\" no effect\",F23),\"\")","v":" no effect"},{"$f":"IF(Working!F9=0,\" no net effect\",IF(Working!F9<0,\" minus \"&ABS(Working!F9),\" plus \"&ABS(Working!F9)))","v":" no net effect"}]
[null,null,"Transport, no effect. ",{"$f":"Working!B10&\",\"","v":"Transport,"},{"$f":"IFERROR(IF(AND(Working!D10=Working!E10,Working!F10=0),\" no effect\",F24),\"\")","v":" no effect"},{"$f":"IF(Working!F10=0,\" no net effect\",IF(Working!F10<0,\" minus \"&ABS(Working!F10),\" plus \"&ABS(Working!F10)))","v":" no net effect"}]
[null,null,"Waste, no effect. ",{"$f":"Working!B11&\",\"","v":"Waste,"},{"$f":"IFERROR(IF(AND(Working!D11=Working!E11,Working!F11=0),\" no effect\",F25),\"\")","v":" no effect"},{"$f":"IF(Working!F11=0,\" no net effect\",IF(Working!F11<0,\" minus \"&ABS(Working!F11),\" plus \"&ABS(Working!F11)))","v":" no net effect"}]
[null,null,"Adaptation, no effect. ",{"$f":"Working!B12&\",\"","v":"Adaptation,"},{"$f":"IFERROR(IF(AND(Working!D12=Working!E12,Working!F12=0),\" no effect\",F26),\"\")","v":" no effect"},{"$f":"IF(Working!F12=0,\" no net effect\",IF(Working!F12<0,\" minus \"&ABS(Working!F12),\" plus \"&ABS(Working!F12)))","v":" no net effect"}]
[null,null,"",{"$f":"Working!B13&\",\"","v":"Other,"},{"$f":"IFERROR(IF(AND(Working!D13=Working!E13,Working!F13=0),\" no effect\",F27),\"\")","v":""},{"$f":"IF(Working!F13=0,\" no net effect\",IF(Working!F13<0,\" minus \"&ABS(Working!F13),\" plus \"&ABS(Working!F13)))","v":{"$error":"#N/A"}}]
[null,null,"",{"$f":"Working!B14&\",\"","v":"0,"},{"$f":"IFERROR(IF(AND(Working!D14=Working!E14,Working!F14=0),\" no effect\",F28),\"\")","v":""},{"$f":"IF(Working!F14=0,\" no net effect\",IF(Working!F14<0,\" minus \"&ABS(Working!F14),\" plus \"&ABS(Working!F14)))","v":{"$error":"#N/A"}}]
[null,null,"",{"$f":"Working!B15&\",\"","v":","},{"$f":"IFERROR(IF(AND(Working!D15=Working!E15,Working!F15=0),\" no effect\",F29),\"\")","v":""},{"$f":"IF(Working!F15=0,\" no net effect\",IF(Working!F15<0,\" minus \"&ABS(Working!F15),\" plus \"&ABS(Working!F15)))","v":{"$error":"#N/A"}}]
[null,null,"",{"$f":"Working!B16&\",\"","v":","},{"$f":"IFERROR(IF(AND(Working!D16=Working!E16,Working!F16=0),\" no effect\",F30),\"\")","v":""},{"$f":"IF(Working!F16=0,\" no net effect\",IF(Working!F16<0,\" minus \"&ABS(Working!F16),\" plus \"&ABS(Working!F16)))","v":{"$error":"#N/A"}}]
[null,null,"",{"$f":"Working!B17&\",\"","v":","},{"$f":"IFERROR(IF(AND(Working!D17=Working!E17,Working!F17=0),\" no effect\",F31),\"\")","v":""},{"$f":"IF(Working!F17=0,\" no net effect\",IF(Working!F17<0,\" minus \"&ABS(Working!F17),\" plus \"&ABS(Working!F17)))","v":{"$error":"#N/A"}}]
[null,null,"",{"$f":"Working!B18&\",\"","v":","},{"$f":"IFERROR(IF(AND(Working!D18=Working!E18,Working!F18=0),\" no effect\",F32),\"\")","v":""},{"$f":"IF(Working!F18=0,\" no net effect\",IF(Working!F18<0,\" minus \"&ABS(Working!F18),\" plus \"&ABS(Working!F18)))","v":{"$error":"#N/A"}}]
[null,null,"",{"$f":"Working!B19&\",\"","v":","},{"$f":"IFERROR(IF(AND(Working!D19=Working!E19,Working!F19=0),\" no effect\",F33),\"\")","v":""},{"$f":"IF(Working!F19=0,\" no net effect\",IF(Working!F19<0,\" minus \"&ABS(Working!F19),\" plus \"&ABS(Working!F19)))","v":{"$error":"#N/A"}}]
[null,null,"",{"$f":"Working!B20&\",\"","v":","},{"$f":"IFERROR(IF(AND(Working!D20=Working!E20,Working!F20=0),\" no effect\",F34),\"\")","v":""},{"$f":"IF(Working!F20=0,\" no net effect\",IF(Working!F20<0,\" minus \"&ABS(Working!F20),\" plus \"&ABS(Working!F20)))","v":{"$error":"#N/A"}}]
[null,null,"",{"$f":"Working!B21&\",\"","v":","},{"$f":"IFERROR(IF(AND(Working!D21=Working!E21,Working!F21=0),\" no effect\",F35),\"\")","v":""},{"$f":"IF(Working!F21=0,\" no net effect\",IF(Working!F21<0,\" minus \"&ABS(Working!F21),\" plus \"&ABS(Working!F21)))","v":{"$error":"#N/A"}}]
[null,null,"",{"$f":"Working!B22&\",\"","v":","},{"$f":"IFERROR(IF(AND(Working!D22=Working!E22,Working!F22=0),\" no effect\",F36),\"\")","v":""},{"$f":"IF(Working!F22=0,\" no net effect\",IF(Working!F22<0,\" minus \"&ABS(Working!F22),\" plus \"&ABS(Working!F22)))","v":{"$error":"#N/A"}}]
[null,null,"",{"$f":"Working!B23&\",\"","v":","},{"$f":"IFERROR(IF(AND(Working!D23=Working!E23,Working!F23=0),\" no effect\",F37),\"\")","v":""},{"$f":"IF(Working!F23=0,\" no net effect\",IF(Working!F23<0,\" minus \"&ABS(Working!F23),\" plus \"&ABS(Working!F23)))","v":{"$error":"#N/A"}}]
[null,null,"",{"$f":"Working!B24&\",\"","v":","},{"$f":"IFERROR(IF(AND(Working!D24=Working!E24,Working!F24=0),\" no effect\",F38),\"\")","v":""},{"$f":"IF(Working!F24=0,\" no net effect\",IF(Working!F24<0,\" minus \"&ABS(Working!F24),\" plus \"&ABS(Working!F24)))","v":{"$error":"#N/A"}}]
[null,null,"",{"$f":"Working!B25&\",\"","v":","},{"$f":"IFERROR(IF(AND(Working!D25=Working!E25,Working!F25=0),\" no effect\",F39),\"\")","v":""},{"$f":"IF(Working!F25=0,\" no net effect\",IF(Working!F25<0,\" minus \"&ABS(Working!F25),\" plus \"&ABS(Working!F25)))","v":{"$error":"#N/A"}}]
[null,null,"",{"$f":"Working!B26&\",\"","v":","},{"$f":"IFERROR(IF(AND(Working!D26=Working!E26,Working!F26=0),\" no effect\",F40),\"\")","v":""},{"$f":"IF(Working!F26=0,\" no net effect\",IF(Working!F26<0,\" minus \"&ABS(Working!F26),\" plus \"&ABS(Working!F26)))","v":{"$error":"#N/A"}}]
[null,null,"",{"$f":"Working!B27&\",\"","v":","},{"$f":"IFERROR(IF(AND(Working!D27=Working!E27,Working!F27=0),\" no effect\",F41),\"\")","v":""},{"$f":"IF(Working!F27=0,\" no net effect\",IF(Working!F27<0,\" minus \"&ABS(Working!F27),\" plus \"&ABS(Working!F27)))","v":{"$error":"#N/A"}}]
[null,null,"",{"$f":"Working!B28&\",\"","v":","},{"$f":"IFERROR(IF(AND(Working!D28=Working!E28,Working!F28=0),\" no effect\",F42),\"\")","v":""},{"$f":"IF(Working!F28=0,\" no net effect\",IF(Working!F28<0,\" minus \"&ABS(Working!F28),\" plus \"&ABS(Working!F28)))","v":{"$error":"#N/A"}}]
[null,null,"",{"$f":"Working!B29&\",\"","v":","},{"$f":"IFERROR(IF(AND(Working!D29=Working!E29,Working!F29=0),\" no effect\",F43),\"\")","v":""},{"$f":"IF(Working!F29=0,\" no net effect\",IF(Working!F29<0,\" minus \"&ABS(Working!F29),\" plus \"&ABS(Working!F29)))","v":{"$error":"#N/A"}}]
[null,null,"",{"$f":"Working!B30&\",\"","v":","},{"$f":"IFERROR(IF(AND(Working!D30=Working!E30,Working!F30=0),\" no effect\",F44),\"\")","v":""},{"$f":"IF(Working!F30=0,\" no net effect\",IF(Working!F30<0,\" minus \"&ABS(Working!F30),\" plus \"&ABS(Working!F30)))","v":{"$error":"#N/A"}}]
[null,null,"",{"$f":"Working!B31&\",\"","v":","},{"$f":"IFERROR(IF(AND(Working!D31=Working!E31,Working!F31=0),\" no effect\",F45),\"\")","v":""},{"$f":"IF(Working!F31=0,\" no net effect\",IF(Working!F31<0,\" minus \"&ABS(Working!F31),\" plus \"&ABS(Working!F31)))","v":{"$error":"#N/A"}}]
[null,null,"",{"$f":"Working!B32&\",\"","v":","},{"$f":"IFERROR(IF(AND(Working!D32=Working!E32,Working!F32=0),\" no effect\",F46),\"\")","v":""},{"$f":"IF(Working!F32=0,\" no net effect\",IF(Working!F32<0,\" minus \"&ABS(Working!F32),\" plus \"&ABS(Working!F32)))","v":{"$error":"#N/A"}}]
[null,null,"",{"$f":"Working!B33&\",\"","v":","},{"$f":"IFERROR(IF(AND(Working!D33=Working!E33,Working!F33=0),\" no effect\",F47),\"\")","v":""},{"$f":"IF(Working!F33=0,\" no net effect\",IF(Working!F33<0,\" minus \"&ABS(Working!F33),\" plus \"&ABS(Working!F33)))","v":{"$error":"#N/A"}}]
[null,null,"",{"$f":"Working!B34&\",\"","v":","},{"$f":"IFERROR(IF(AND(Working!D34=Working!E34,Working!F34=0),\" no effect\",F48),\"\")","v":""},{"$f":"IF(Working!F34=0,\" no net effect\",IF(Working!F34<0,\" minus \"&ABS(Working!F34),\" plus \"&ABS(Working!F34)))","v":{"$error":"#N/A"}}]
[null,null,"",{"$f":"Working!B35&\",\"","v":","},{"$f":"IFERROR(IF(AND(Working!D35=Working!E35,Working!F35=0),\" no effect\",F49),\"\")","v":""},{"$f":"IF(Working!F35=0,\" no net effect\",IF(Working!F35<0,\" minus \"&ABS(Working!F35),\" plus \"&ABS(Working!F35)))","v":{"$error":"#N/A"}}]
[null,null,"",{"$f":"Working!B36&\",\"","v":","},{"$f":"IFERROR(IF(AND(Working!D36=Working!E36,Working!F36=0),\" no effect\",F50),\"\")","v":""},{"$f":"IF(Working!F36=0,\" no net effect\",IF(Working!F36<0,\" minus \"&ABS(Working!F36),\" plus \"&ABS(Working!F36)))","v":{"$error":"#N/A"}}]
[null,null,"",{"$f":"Working!B37&\",\"","v":","},{"$f":"IFERROR(IF(AND(Working!D37=Working!E37,Working!F37=0),\" no effect\",F51),\"\")","v":""},{"$f":"IF(Working!F37=0,\" no net effect\",IF(Working!F37<0,\" minus \"&ABS(Working!F37),\" plus \"&ABS(Working!F37)))","v":{"$error":"#N/A"}}]
[null,null,"",{"$f":"Working!B38&\",\"","v":","},{"$f":"IFERROR(IF(AND(Working!D38=Working!E38,Working!F38=0),\" no effect\",F52),\"\")","v":""},{"$f":"IF(Working!F38=0,\" no net effect\",IF(Working!F38<0,\" minus \"&ABS(Working!F38),\" plus \"&ABS(Working!F38)))","v":{"$error":"#N/A"}}]
[null,null,"",{"$f":"Working!B39&\",\"","v":","},{"$f":"IFERROR(IF(AND(Working!D39=Working!E39,Working!F39=0),\" no effect\",F53),\"\")","v":""},{"$f":"IF(Working!F39=0,\" no net effect\",IF(Working!F39<0,\" minus \"&ABS(Working!F39),\" plus \"&ABS(Working!F39)))","v":{"$error":"#N/A"}}]
[null,null,"",{"$f":"Working!B40&\",\"","v":","},{"$f":"IFERROR(IF(AND(Working!D40=Working!E40,Working!F40=0),\" no effect\",F54),\"\")","v":""},{"$f":"IF(Working!F40=0,\" no net effect\",IF(Working!F40<0,\" minus \"&ABS(Working!F40),\" plus \"&ABS(Working!F40)))","v":{"$error":"#N/A"}}]
[null,null,"",{"$f":"Working!B41&\",\"","v":","},{"$f":"IFERROR(IF(AND(Working!D41=Working!E41,Working!F41=0),\" no effect\",F55),\"\")","v":""},{"$f":"IF(Working!F41=0,\" no net effect\",IF(Working!F41<0,\" minus \"&ABS(Working!F41),\" plus \"&ABS(Working!F41)))","v":{"$error":"#N/A"}}]
[null,null,"",{"$f":"Working!B42&\",\"","v":","},{"$f":"IFERROR(IF(AND(Working!D42=Working!E42,Working!F42=0),\" no effect\",F56),\"\")","v":""},{"$f":"IF(Working!F42=0,\" no net effect\",IF(Working!F42<0,\" minus \"&ABS(Working!F42),\" plus \"&ABS(Working!F42)))","v":{"$error":"#N/A"}}]
[null,null,"",{"$f":"Working!B43&\",\"","v":","},{"$f":"IFERROR(IF(AND(Working!D43=Working!E43,Working!F43=0),\" no effect\",F57),\"\")","v":""},{"$f":"IF(Working!F43=0,\" no net effect\",IF(Working!F43<0,\" minus \"&ABS(Working!F43),\" plus \"&ABS(Working!F43)))","v":{"$error":"#N/A"}}]
[null,null,"",{"$f":"Working!B44&\",\"","v":","},{"$f":"IFERROR(IF(AND(Working!D44=Working!E44,Working!F44=0),\" no effect\",F58),\"\")","v":""},{"$f":"IF(Working!F44=0,\" no net effect\",IF(Working!F44<0,\" minus \"&ABS(Working!F44),\" plus \"&ABS(Working!F44)))","v":{"$error":"#N/A"}}]
[null,null,"",{"$f":"Working!B45&\",\"","v":","},{"$f":"IFERROR(IF(AND(Working!D45=Working!E45,Working!F45=0),\" no effect\",F59),\"\")","v":""},{"$f":"IF(Working!F45=0,\" no net effect\",IF(Working!F45<0,\" minus \"&ABS(Working!F45),\" plus \"&ABS(Working!F45)))","v":{"$error":"#N/A"}}]
[null,null,"",{"$f":"Working!B46&\",\"","v":","},{"$f":"IFERROR(IF(AND(Working!D46=Working!E46,Working!F46=0),\" no effect\",F60),\"\")","v":""},{"$f":"IF(Working!F46=0,\" no net effect\",IF(Working!F46<0,\" minus \"&ABS(Working!F46),\" plus \"&ABS(Working!F46)))","v":{"$error":"#N/A"}}]
[null,null,"",{"$f":"Working!B47&\",\"","v":","},{"$f":"IFERROR(IF(AND(Working!D47=Working!E47,Working!F47=0),\" no effect\",F61),\"\")","v":""},{"$f":"IF(Working!F47=0,\" no net effect\",IF(Working!F47<0,\" minus \"&ABS(Working!F47),\" plus \"&ABS(Working!F47)))","v":{"$error":"#N/A"}}]
[null,null,"",{"$f":"Working!B48&\",\"","v":","},{"$f":"IFERROR(IF(AND(Working!D48=Working!E48,Working!F48=0),\" no effect\",F62),\"\")","v":""},{"$f":"IF(Working!F48=0,\" no net effect\",IF(Working!F48<0,\" minus \"&ABS(Working!F48),\" plus \"&ABS(Working!F48)))","v":{"$error":"#N/A"}}]
[null,null,"",{"$f":"Working!B49&\",\"","v":","},{"$f":"IFERROR(IF(AND(Working!D49=Working!E49,Working!F49=0),\" no effect\",F63),\"\")","v":""},{"$f":"IF(Working!F49=0,\" no net effect\",IF(Working!F49<0,\" minus \"&ABS(Working!F49),\" plus \"&ABS(Working!F49)))","v":{"$error":"#N/A"}}]
[null,null,"",{"$f":"Working!B50&\",\"","v":","},{"$f":"IFERROR(IF(AND(Working!D50=Working!E50,Working!F50=0),\" no effect\",F64),\"\")","v":""},{"$f":"IF(Working!F50=0,\" no net effect\",IF(Working!F50<0,\" minus \"&ABS(Working!F50),\" plus \"&ABS(Working!F50)))","v":{"$error":"#N/A"}}]
[null,null,"",{"$f":"Working!B51&\",\"","v":","},{"$f":"IFERROR(IF(AND(Working!D51=Working!E51,Working!F51=0),\" no effect\",F65),\"\")","v":""},{"$f":"IF(Working!F51=0,\" no net effect\",IF(Working!F51<0,\" minus \"&ABS(Working!F51),\" plus \"&ABS(Working!F51)))","v":{"$error":"#N/A"}}]
[null,null,"",{"$f":"Working!B52&\",\"","v":","},{"$f":"IFERROR(IF(AND(Working!D52=Working!E52,Working!F52=0),\" no effect\",F66),\"\")","v":""},{"$f":"IF(Working!F52=0,\" no net effect\",IF(Working!F52<0,\" minus \"&ABS(Working!F52),\" plus \"&ABS(Working!F52)))","v":{"$error":"#N/A"}}]
[null,null,"",{"$f":"Working!B53&\",\"","v":","},{"$f":"IFERROR(IF(AND(Working!D53=Working!E53,Working!F53=0),\" no effect\",F67),\"\")","v":""},{"$f":"IF(Working!F53=0,\" no net effect\",IF(Working!F53<0,\" minus \"&ABS(Working!F53),\" plus \"&ABS(Working!F53)))","v":{"$error":"#N/A"}}]

{"sheet":"Output","index":5,"n_rows":54,"n_cols":10,"rows_kept":54,"cut":false,"hidden":true,"merged":[]}
[]
[]
[null,null,"Label","Used","Value & colour"]
[null,null,{"$f":"Working!H3","v":"Buildings\n"},{"$f":"IF(C4<>\"\",1,NA())","v":1},{"$f":"Working!F3","v":0},"< conditional formatting is transferred to chart"]
[null,null,{"$f":"Working!H4","v":"Business\n"},{"$f":"IF(C5<>\"\",1,NA())","v":1},{"$f":"Working!F4","v":0}]
[null,null,{"$f":"Working!H5","v":"Energy\n"},1,{"$f":"Working!F5","v":0}]
[null,null,{"$f":"Working!H6","v":"Influence\n"},1,{"$f":"Working!F6","v":0}]
[null,null,{"$f":"Working!H7","v":"Internal Resources\n"},1,{"$f":"Working!F7","v":0}]
[null,null,{"$f":"Working!H8","v":"Land use\n"},1,{"$f":"Working!F8","v":0}]
[null,null,{"$f":"Working!H9","v":"Goods & Services\n"},1,{"$f":"Working!F9","v":0}]
[null,null,{"$f":"Working!H10","v":"Transport\n"},1,{"$f":"Working!F10","v":0}]
[null,null,{"$f":"Working!H11","v":"Waste\n"},1,{"$f":"Working!F11","v":0}]
[null,null,{"$f":"Working!H12","v":"Adaptation\n"},1,{"$f":"Working!F12","v":0}]
[null,null,{"$f":"Working!H13","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$f":"Working!F13","v":{"$error":"#N/A"}}]
[null,null,{"$f":"Working!H14","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$f":"Working!F14","v":{"$error":"#N/A"}}]
[null,null,{"$f":"Working!H15","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$f":"Working!F15","v":{"$error":"#N/A"}}]
[null,null,{"$f":"Working!H16","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$f":"Working!F16","v":{"$error":"#N/A"}}]
[null,null,{"$f":"Working!H17","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$f":"Working!F17","v":{"$error":"#N/A"}}]
[null,null,{"$f":"Working!H18","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$f":"Working!F18","v":{"$error":"#N/A"}}]
[null,null,{"$f":"Working!H19","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$f":"Working!F19","v":{"$error":"#N/A"}}]
[null,null,{"$f":"Working!H20","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$f":"Working!F20","v":{"$error":"#N/A"}}]
[null,null,{"$f":"Working!H21","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$f":"Working!F21","v":{"$error":"#N/A"}}]
[null,null,{"$f":"Working!H22","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$f":"Working!F22","v":{"$error":"#N/A"}},null,null,null,null,"Don't edit anything within the green lines - it will show up on the infographic (and in the preview)"]
[null,null,{"$f":"Working!H23","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$f":"Working!F23","v":{"$error":"#N/A"}}]
[null,null,{"$f":"Working!H24","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$f":"Working!F24","v":{"$error":"#N/A"}}]
[null,null,{"$f":"Working!H25","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$f":"Working!F25","v":{"$error":"#N/A"}}]
[null,null,{"$f":"Working!H26","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$f":"Working!F26","v":{"$error":"#N/A"}}]
[null,null,{"$f":"Working!H27","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$f":"Working!F27","v":{"$error":"#N/A"}}]
[null,null,{"$f":"Working!H28","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$f":"Working!F28","v":{"$error":"#N/A"}}]
[null,null,{"$f":"Working!H29","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$f":"Working!F29","v":{"$error":"#N/A"}}]
[null,null,{"$f":"Working!H30","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$f":"Working!F30","v":{"$error":"#N/A"}}]
[null,null,{"$f":"Working!H31","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$f":"Working!F31","v":{"$error":"#N/A"}}]
[null,null,{"$f":"Working!H32","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$f":"Working!F32","v":{"$error":"#N/A"}}]
[null,null,{"$f":"Working!H33","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$f":"Working!F33","v":{"$error":"#N/A"}}]
[null,null,{"$f":"Working!H34","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$f":"Working!F34","v":{"$error":"#N/A"}}]
[null,null,{"$f":"Working!H35","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$f":"Working!F35","v":{"$error":"#N/A"}}]
[null,null,{"$f":"Working!H36","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$f":"Working!F36","v":{"$error":"#N/A"}}]
[null,null,{"$f":"Working!H37","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$f":"Working!F37","v":{"$error":"#N/A"}}]
[null,null,{"$f":"Working!H38","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$f":"Working!F38","v":{"$error":"#N/A"}}]
[null,null,{"$f":"Working!H39","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$f":"Working!F39","v":{"$error":"#N/A"}}]
[null,null,{"$f":"Working!H40","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$f":"Working!F40","v":{"$error":"#N/A"}}]
[null,null,{"$f":"Working!H41","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$f":"Working!F41","v":{"$error":"#N/A"}}]
[null,null,{"$f":"Working!H42","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$f":"Working!F42","v":{"$error":"#N/A"}}]
[null,null,{"$f":"Working!H43","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$f":"Working!F43","v":{"$error":"#N/A"}}]
[null,null,{"$f":"Working!H44","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$f":"Working!F44","v":{"$error":"#N/A"}}]
[null,null,{"$f":"Working!H45","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$f":"Working!F45","v":{"$error":"#N/A"}}]
[null,null,{"$f":"Working!H46","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$f":"Working!F46","v":{"$error":"#N/A"}}]
[null,null,{"$f":"Working!H47","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$f":"Working!F47","v":{"$error":"#N/A"}}]
[null,null,{"$f":"Working!H48","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$f":"Working!F48","v":{"$error":"#N/A"}}]
[null,null,{"$f":"Working!H49","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$f":"Working!F49","v":{"$error":"#N/A"}}]
[null,null,{"$f":"Working!H50","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$f":"Working!F50","v":{"$error":"#N/A"}}]
[null,null,{"$f":"Working!H51","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$f":"Working!F51","v":{"$error":"#N/A"}}]
[null,null,{"$f":"Working!H52","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$f":"Working!F52","v":{"$error":"#N/A"}}]
[null,null,{"$f":"Working!H53","v":{"$error":"#N/A"}},{"$f":"IF(C54<>\"\",1,NA())","v":{"$error":"#N/A"}},{"$f":"Working!F53","v":{"$error":"#N/A"}}]