{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["START","1. Impacts Questionnaire","2. Carbon Assessment","3. Equalities Assessment","4. Results","Refs"],"not_rendered":{"charts":0,"images":6,"macros":1,"external_links":0,"defined_names":8,"comments":4,"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":"START","index":0,"n_rows":27,"n_cols":4,"rows_kept":27,"cut":false,"hidden":false,"merged":[[2,2,3,4],[5,2,5,5],[22,2,22,3]]}
[]
[null,null,"Decision Support Tool"]
[null,null,"Introduction"]
[]
[]
[null,null,"This Decision Support Tool allows users to self-assess the impact of the proposed policies, initiatives, or services against GMCA policy frameworks. It provides decision makers with a high-level assessment of how a Decision meets GMCA policy goals and can facilitate a process of revising Decisions to more fully meet these goals. Where more detailed assessment is needed, users should consult other tools that lead to a full assessment of specific impact areas as indicated (e.g. Environmental Impact Assessment, Cost Benefit Analysis (CBA)). Users self-assess against nine impact areas (Equalities, Health, Resilience & Adaptation, Housing, Economy, Mobility & Connectivity, Carbon, Nature & Environment, Consumption and Production and the 2038 Carbon Neutral target). Depending on your answers, you may then be directed into a self-reported Carbon Assessment tab, where your paper will be compared to relevant best practice. If your paper impacts on people with ‘protected characteristics’, you will be directed to the Equalities Impact Assessment tab. \n\nNote that the Carbon Assessment does not yet assess embodied carbon and the tool does not go into the detail of intersectionality with regard to equality and inclusion impacts. As such, it is important that users take an overview approach when using this tool to inform decision-making at CA level."]
[]
[null,null,"Overview information","Please complete all fields"]
[null,null,"Name of policy / initiative / service to be assessed"]
[null,null,"Author(s)"]
[null,null,"Date of Assessment"]
[null,null,"Document Version"]
[null,null,"Corporate objective being addressed"]
[null,null,"Department / function carrying out the assessment "]
[null,null,"Who is responsible for the implementation of the policy / initiative / service? (function head / department manager)"]
[null,null,"Brief description of the proposal or decision"]
[null,null,"Value (£)"]
[null,null,"Is this a strategy document?"]
[null,null,"If this is a strategy document will this strategy have an impact over multiple years?"]
[null,null,"Where does this policy / initiative / service apply to? (Check all that apply)"]
[]
[null,null,"Contents of this tool"]
[null,null,"This tool comprises the following sections. Instructions for each section are detailed on the relevant pages."]
[null,null,{"$f":"HYPERLINK(\"#'1. Impacts Questionnaire'!A1\",\"Step 1: Impacts Questionnaire\")","v":"Step 1: Impacts Questionnaire"},"← Get started by clicking on this link."]
[null,null,{"$f":"HYPERLINK(\"#'2. Carbon Assessment'!A1\",\"Step 2: Simple Carbon Assessment\")","v":"Step 2: Simple Carbon Assessment"}]
[null,null,{"$f":"HYPERLINK(\"#'3. Equalities Assessment'!A1\",\"Step 3: Equalities Impact Assessment (if applicable)\")","v":"Step 3: Equalities Impact Assessment (if applicable)"}]
[null,null,{"$f":"HYPERLINK(\"#'4. Results'!A1\",\"Step 4: Results\")","v":"Step 4: Results"}]

{"sheet":"1. Impacts Questionnaire","index":1,"n_rows":160,"n_cols":26,"rows_kept":160,"cut":false,"hidden":false,"merged":[[6,2,6,15],[7,2,7,15],[9,2,9,15],[8,2,8,15],[27,21,31,21],[111,13,111,14],[122,13,122,14],[127,9,127,21],[127,7,127,8],[76,13,76,14],[78,13,78,14],[104,13,104,14],[105,13,105,14],[108,13,108,14],[87,5,87,11],[93,5,93,11],[96,5,96,11],[97,5,97,11],[88,5,88,11],[94,5,94,11],[95,5,95,11],[92,5,92,11],[110,13,110,14],[106,5,106,11],[38,21,43,21],[50,21,54,21],[61,21,66,21],[73,21,80,21],[106,13,106,14],[107,5,107,11],[107,13,107,14],[121,13,121,14],[43,13,43,14],[50,13,50,14],[54,13,54,14],[61,13,61,14],[75,13,75,14],[119,15,119,17],[120,15,120,17],[87,21,97,21],[119,21,123,21],[104,21,112,21],[121,15,121,17],[122,15,122,17],[123,15,123,17],[39,13,39,14],[42,13,42,14],[87,13,87,14],[10,4,10,15],[11,4,11,15],[12,4,12,15],[57,2,59,7],[69,2,71,7],[61,2,66,2],[62,5,62,11],[63,5,63,11],[64,5,64,11],[65,5,65,11],[66,5,66,11],[13,4,13,15],[14,4,14,15],[27,13,27,14],[29,13,29,14],[31,13,31,14],[16,4,16,15],[17,4,17,15],[52,5,52,11],[53,5,53,11],[18,4,18,15],[19,4,19,15],[28,5,28,11],[27,5,27,11],[73,2,80,2],[74,5,74,11],[75,5,75,11],[76,5,76,11],[77,5,77,11],[78,5,78,11],[79,5,79,11],[80,5,80,11],[73,5,73,11],[31,5,31,11],[30,5,30,11],[46,2,48,7],[38,2,43,2],[50,2,54,2],[54,5,54,11],[38,5,38,11],[39,5,39,11],[40,5,40,11],[159,4,159,8],[127,2,127,6],[109,5,109,11],[110,5,110,11],[115,2,117,7],[100,2,102,7],[112,5,112,11],[120,5,120,11],[121,5,121,11],[122,5,122,11],[123,5,123,11],[104,5,104,11],[105,5,105,11],[108,5,108,11],[132,2,140,2],[131,2,131,16],[4,2,4,15],[5,2,5,15],[157,4,157,8],[28,3,29,3],[148,4,148,6],[89,5,89,11],[90,5,90,11],[91,5,91,11],[119,2,123,2],[87,2,97,2],[111,5,111,11],[104,2,111,2],[119,5,119,11],[29,5,29,11],[41,5,41,11],[42,5,42,11],[43,5,43,11],[50,5,50,11],[51,5,51,11],[61,5,61,11],[83,2,85,7],[34,2,36,7],[27,2,31,2],[23,2,25,7]]}
[]
[null,null,"1. Impacts Questionnaire"]
[]
[null,null,"Guide"]
[null,null,"This questionnaire will provide high level scoring on key impact areas related to GMCA policy. The results are given a RAG (Red, Amber, Green) result indicating how the proposed Decision fits with GMCA policy related to the impact area."]
[null,null,"Definitions\nSome questions have a 'red corner' in the cell; this indicates that there are guidance notes available to view in relation to that question. To view these, hover the mouse pointer over one of these cells (you can practice by hovering over this cell). In the cells next to the question there are also links to websites with further supporting information."]
[null,null,"Impact areas\nQuestions for each impact area require a yes/no answer to determine if they are relevant. These are set to YES as default – once you have read through the questions in that impact area, you may select NO if this area is not relevant to your paper.  "]
[null,null,"Different types of papers and confidence in your assessment\nIt is understood that various types of Decisions are being assessed through this tool. For some papers, for example new strategies, you may not feel able to answer all of the questions with confidence as this will depend on delivery. You should answer on the basis of what the strategy aims to achieve – however, this is an important opportunity to consider where issues at the delivery stage could undermine your aims. You should note these challenges and specify any mitigation measures needed to ensure delivery is in line with the original aspirations on the results page."]
[null,null,"Some papers may have a number of projects within them and so the answers between projects could be different. Here we ask you to take a high level (‘helicopter’) view, assessing across the content of the paper. However, again, where there are particular areas that will have negative impacts or there are risks that the assessed level of positive impact will not be met – specific mitigation measures should be flagged by users on the results page."]
[null,null,"Impact categories\nThe definitions of the possible impacts are as follows:"]
[null,null,null,null,"Yes, with long lasting and/or significant positive impact.  The proposal or decision has positive impacts that are long lasting (3 or more years) and/or are significant for large numbers of GM residents and/or a significant proportion of a particular group or community."]
[null,null,null,null,"Yes, with short term (3 years or less) or limited positive impact. The proposal or decision has positive impact, but will be limited in its effects or have a short lifespan."]
[null,null,null,null,"No, the decision or proposal has no discernable positive or negative impact. It will not affect any discernible positive or negative change. "]
[null,null,null,null,"Yes, but with short term (3 years or less) or limited negative impact. The proposal or decision has negative short term or limited impacts."]
[null,null,null,null,"Yes, but with long lasting (more than 3 years) or severe negative impact. The proposal or decision has negative impacts that are long lasting (3 or more years) and/or are significant for large numbers of GM residents and/or a significant proportion of a particular group or community."]
[null,null,"All Decisions will then be given a RAG (Red, Amber, Green) rating on applicable Impact areas. The definitions of these are:"]
[null,null,null,null,"All green. The proposal or decision is expected to have positive impacts overall, whether long or short term."]
[null,null,null,null,"Equal number of red and green OR at least one red. The proposal or decision has both positive and negative impacts OR have net neutral impact with equal positive and negative overall outcomes. Careful consideration of trade-offs is recommended."]
[null,null,null,null,"Mostly red, with at least one green. Careful consideration of trade-offs is necessary."]
[null,null,null,null,"All red. The proposal or decision is expected result to negative impacts overall. It should receive most attention for mitigation or be avoided. Clear and evidenced justification to progress this proposal will be required."]
[]
[null,null,"Impacts Questionnaire"]
[null,null,"1. Equality and Inclusion"]
[null,null,"Will this proposal or decision affect individuals or groups in different ways, including for example, social equality and inclusion?"]
[]
[]
[null,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"RAG Result",null,"Comment - please provide succinct statements."]
[null,null,{"$f":"IF(B27=1,\"Please complete next part →\",IF(B27=2,\"Proceed to next question ↓\",\"\"))","v":"Please complete next part →"},null,1,"Will this proposal or decision disproportionately affect people with one or more protected characteristics?",null,null,null,null,null,null,null,"More help (web link)",null,null,null,null,{"$f":"IF(OR(Z28=1,Z28=2),2,IF(OR(Z28=4,Z28=5),1,IF(Z28=3,0,\"\")))","v":""},null,null,{"$f":"IF(V33=0,\"\",IF(V33<0.63,\"RR\",IF(AND(V33>=0.63,V33<=0.74),\"R\",IF(AND(V33>=0.75,V33<=0.99),\"A\",IF(V33=1,\"G\",IF(V33=\"x\",\"This is calculated when all questions have been answered\",\"\"))))))","v":"This is calculated when all questions have been answered"},null,null,null,6]
[null,null,null,null,2,"Will this proposal or decision affect other people or groups, for example, people with caring responsibilities, or those that are socially and economically disadvantaged?",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(Z29=1,Z29=2),2,IF(OR(Z29=4,Z29=5),1,IF(Z29=3,0,\"\")))","v":""},null,null,null,null,null,null,6]
[null,null,null,null,3,"Will this proposal or decision affect local people’s access to public services (e.g., community centres, transport services, health services)?",null,null,null,null,null,null,null,"More help (web link)",null,null,null,null,{"$f":"IF(OR(Z30=1,Z30=2),2,IF(OR(Z30=4,Z30=5),1,IF(Z30=3,0,\"\")))","v":""},null,null,null,null,null,null,6]
[null,null,null,null,4,"Will this proposal support communities in shaping decisions that affect them?",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(Z31=1,Z31=2),2,IF(OR(Z31=4,Z31=5),1,IF(Z31=3,0,\"\")))","v":""},null,null,null,null,null,null,6]
[null,null,null,null,5,"Will this proposal or decision affect community cohesion?",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(Z32=1,Z32=2),2,IF(OR(Z32=4,Z32=5),1,IF(Z32=3,0,\"\")))","v":""},null,null,null,null,null,null,6]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR((SUM(S28:S32))/((COUNTIF(S28:S32,\">0\")*2)),\"0\")","v":"0"},null,null,{"$f":"IF(AND(B27=1,Z33=0),ROUND(S33,2),IF(AND(B27=1,Z33<>0),\"x\",0))","v":"x"},null,null,null,{"$f":"COUNTIF(Z28:Z32,6)","v":5}]
[null,null,"2. Health"]
[null,null,"Will this proposal or decision affect people's physical or mental health?"]
[]
[]
[null,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"RAG Result",null,"Comment - please provide succinct statements."]
[null,null,{"$f":"IF(B38=1,\"Please complete next part →\",IF(B38=2,\"Proceed to next question ↓\",\"\"))","v":"Please complete next part →"},null,1,"Will this proposal or decision affect the physical health of GM residents?",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(Z39=1,Z39=2),2,IF(OR(Z39=4,Z39=5),1,IF(Z39=3,0,\"\")))","v":""},null,null,{"$f":"IF(V45=0,\"\",IF(V45<0.63,\"RR\",IF(AND(V45>=0.63,V45<=0.74),\"R\",IF(AND(V45>=0.75,V45<=0.99),\"A\",IF(V45=1,\"G\",IF(V45=\"x\",\"This is calculated when all questions have been answered\",\"\"))))))","v":"This is calculated when all questions have been answered"},null,null,null,6]
[null,null,null,null,2,"Will this proposal or decision affect the mental health and wellbeing of GM residents?",null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,6]
[null,null,null,null,3,"Will the proposal or decision affect residents’ levels of physical activity?",null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,6]
[null,null,null,null,4,"Will the proposal or decision affect levels of social isolation?",null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,6]
[null,null,null,null,5,"Will this proposal or decision affect resident access to healthcare services (physical and mental) through the provision or removal of infrastructure (transport links, digital infrastructure, hospitals, surgeries etc)?",null,null,null,null,null,null,null,"More help (web link)",null,null,null,null,"",null,null,null,null,null,null,6]
[null,null,null,null,6,"Will this proposal affect the accessibility and provision of healthy food in GM (e.g., delivery of surplus food to food banks/ charities/ communities, the ‘no child hungry provision', or local food production)?",null,null,null,null,null,null,null,"More help (web link)",null,null,null,null,"",null,null,null,null,null,null,6]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR((SUM(S39:S44))/((COUNTIF(S39:S44,\">0\")*2)),\"0\")","v":"0"},null,null,{"$f":"IF(AND(B38=1,Z45=0),ROUND(S45,2),IF(AND(B38=1,Z45<>0),\"x\",0))","v":"x"},null,null,null,{"$f":"COUNTIF(Z39:Z44,6)","v":6}]
[null,null,"3. Resilience and Adaptation"]
[null,null,"Will this proposal or decision affect GM's vulnerability and/or resilience to climate, disaster, public safety, or health risks?"]
[]
[]
[null,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"RAG Result",null,"Comment - please provide succinct statements."]
[null,null,{"$f":"IF(B50=1,\"Please complete next part →\",IF(B50=2,\"Proceed to next question ↓\",\"\"))","v":"Please complete next part →"},null,1,"Will this proposal or decision affect the risks in GM, e.g., climate, disaster, public safety or health risks?",null,null,null,null,null,null,null,"More help (web link)",null,null,null,null,{"$f":"IF(OR(Z51=1,Z51=2),2,IF(OR(Z51=4,Z51=5),1,IF(Z51=3,0,\"\")))","v":""},null,null,{"$f":"IF(V56=0,\"\",IF(V56<0.63,\"RR\",IF(AND(V56>=0.63,V56<=0.74),\"R\",IF(AND(V56>=0.75,V56<=0.99),\"A\",IF(V56=1,\"G\",IF(V56=\"x\",\"This is calculated when all questions have been answered\",\"\"))))))","v":"This is calculated when all questions have been answered"},null,null,null,6]
[null,null,null,null,2,"Will this proposal or decision enable individuals, communities, or businesses to better withstand and recover from disruption more quickly and effectively? ",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(Z52=1,Z52=2),2,IF(OR(Z52=4,Z52=5),1,IF(Z52=3,0,\"\")))","v":""},null,null,null,null,null,null,6]
[null,null,null,null,3,"Will this proposal or decision affect current levels of vulnerability both for people and the environment?",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(Z53=1,Z53=2),2,IF(OR(Z53=4,Z53=5),1,IF(Z53=3,0,\"\")))","v":""},null,null,null,null,null,null,6]
[null,null,null,null,4,"Will this proposal or decision make our communities safer and stronger, for example, by tackling crime or anti-social behaviour?",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(Z54=1,Z54=2),2,IF(OR(Z54=4,Z54=5),1,IF(Z54=3,0,\"\")))","v":""},null,null,null,null,null,null,6]
[null,null,null,null,5,"Does this proposal or decision affect the quality and provision of green and blue infrastructure?",null,null,null,null,null,null,null,"More help (web link)",null,null,null,null,{"$f":"IF(OR(Z55=1,Z55=2),2,IF(OR(Z55=4,Z55=5),1,IF(Z55=3,0,\"\")))","v":""},null,null,null,null,null,null,6]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR((SUM(S51:S55))/((COUNTIF(S51:S55,\">0\")*2)),\"0\")","v":"0"},null,null,{"$f":"IF(AND(B50=1,Z56=0),ROUND(S56,2),IF(AND(B50=1,Z56<>0),\"x\",0))","v":"x"},null,null,null,{"$f":"COUNTIF(Z51:Z55,6)","v":5}]
[null,null,"4. Housing"]
[null,null,"Will this proposal or decision affect housing in GM?"]
[]
[]
[null,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"RAG Result",null,"Comment - please provide succinct statements."]
[null,null,{"$f":"IF(B61=1,\"Please complete next part →\",IF(B61=2,\"Proceed to next question ↓\",\"\"))","v":"Please complete next part →"},null,1,"Will this proposal or decision affect people who are experiencing or at risk of any form of homelessness, including for example, rough sleeping?",null,null,null,null,null,null,null,"More help (web link)",null,null,null,null,{"$f":"IF(OR(Z62=1,Z62=2),2,IF(OR(Z62=4,Z62=5),1,IF(Z62=3,0,\"\")))","v":""},null,null,{"$f":"IF(V68=0,\"\",IF(V68<0.63,\"RR\",IF(AND(V68>=0.63,V68<=0.74),\"R\",IF(AND(V68>=0.75,V68<=0.99),\"A\",IF(V68=1,\"G\",IF(V68=\"x\",\"This is calculated when all questions have been answered\",\"\"))))))","v":"This is calculated when all questions have been answered"},null,null,null,6]
[null,null,null,null,2,"Will this proposal or decision affect the accessibility or affordability of homes for GM residents?",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(Z63=1,Z63=2),2,IF(OR(Z63=4,Z63=5),1,IF(Z63=3,0,\"\")))","v":""},null,null,null,null,null,null,6]
[null,null,null,null,3,"Will this proposal or decision improve derelict urban land or reuse redundant or underused buildings for local housing?",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(Z64=1,Z64=2),2,IF(OR(Z64=4,Z64=5),1,IF(Z64=3,0,\"\")))","v":""},null,null,null,null,null,null,6]
[null,null,null,null,4,"Will this proposal or decision facilitate construction of new-build residential building(s)?",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3]
[null,null,null,null,5,"Will this proposal or decision facilitate maintenance or improvement of existing residential building(s)?",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3]
[null,null,null,null,6,"Will this proposal or decision affect mandates or regulations for landlords on building standards?",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR((SUM(S62:S64))/((COUNTIF(S62:S64,\">0\")*2)),\"0\")","v":"0"},null,null,{"$f":"IF(AND(B61=1,Z68=0),ROUND(S68,2),IF(AND(B61=1,Z68<>0),\"x\",0))","v":"x"},null,null,null,{"$f":"COUNTIF(Z62:Z64,6)+COUNTIF(Z65:Z67,3)","v":6}]
[null,null,"5. Economy"]
[null,null,"Will this proposal or decision affect GM's local economy?"]
[]
[]
[null,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"RAG Result",null,"Comment - please provide succinct statements."]
[null,null,{"$f":"IF(B73=1,\"Please complete next part →\",IF(B73=2,\"Proceed to next question ↓\",\"\"))","v":"Please complete next part →"},null,1,"Will this proposal or decision contribute to improving economic development in Greater Manchester?",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(Z74=1,Z74=2),2,IF(OR(Z74=4,Z74=5),1,IF(Z74=3,0,\"\")))","v":""},null,null,{"$f":"IF(V82=0,\"\",IF(V82<0.63,\"RR\",IF(AND(V82>=0.63,V82<=0.74),\"R\",IF(AND(V82>=0.75,V82<=0.99),\"A\",IF(V82=1,\"G\",IF(V82=\"x\",\"This is calculated when all questions have been answered\",\"\"))))))","v":"This is calculated when all questions have been answered"},null,null,null,6]
[null,null,null,null,2,"Will this proposal or decision increase or decrease employment opportunities for local people?",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(Z75=1,Z75=2),2,IF(OR(Z75=4,Z75=5),1,IF(Z75=3,0,\"\")))","v":""},null,null,null,null,null,null,6]
[null,null,null,null,3,"Will this proposal or decision create, retain or attract ‘good jobs’ with opportunities and support available for people to progress and develop?",null,null,null,null,null,null,null,"More help (web link)",null,null,null,null,"",null,null,null,null,null,null,6]
[null,null,null,null,4,"Will this proposal or decision help local businesses maximise potential economic assets?",null,null,null,null,null,null,null,"More help (web link)",null,null,null,null,"",null,null,null,null,null,null,6]
[null,null,null,null,5,"Will this proposal contribute to innovation, R&D, and knowledge economy in GM?",null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,6]
[null,null,null,null,6,"Will this proposal attract inward investment in our towns and cities?",null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,6]
[null,null,null,null,7,"Will this proposal increase opportunities for formal education, vocational training or skills development (including lifelong and community learning)?",null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,6]
[null,null,null,null,8,"Does this proposal entail the construction or re-purposing of building(s) for non-residential purposes?",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR((SUM(S74:S80))/((COUNTIF(S74:S80,\">0\")*2)),\"0\")","v":"0"},null,null,{"$f":"IF(AND(B73=1,Z82=0),ROUND(S82,2),IF(AND(B73=1,Z82<>0),\"x\",0))","v":"x"},null,null,null,{"$f":"COUNTIF(Z74:Z80,6)+COUNTIF(Z81,3)","v":8}]
[null,null,"6. Mobility and Connectivity"]
[null,null,"Will this proposal or decision affect mobility and connectivity in GM through transport and digital infrastructures?"]
[]
[]
[null,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"RAG Result",null,"Comment - please provide succinct statements."]
[null,null,{"$f":"IF(B87=1,\"Please complete next part →\",IF(B87=2,\"Proceed to next question ↓\",\"\"))","v":"Please complete next part →"},null,1,"Does this proposal or decision affect digital connectivity?",null,null,null,null,null,null,null,"More help (web link)",null,null,null,null,{"$f":"IF(OR(Z88=1,Z88=2),2,IF(OR(Z88=4,Z88=5),1,IF(Z88=3,0,\"\")))","v":""},null,null,{"$f":"IF(V99=0,\"\",IF(V99<0.63,\"RR\",IF(AND(V99>=0.63,V99<=0.74),\"R\",IF(AND(V99>=0.75,V99<=0.99),\"A\",IF(V99=1,\"G\",IF(V99=\"x\",\"This is calculated when all questions have been answered\",\"\"))))))","v":"This is calculated when all questions have been answered"},null,null,null,6]
[null,null,null,null,2,"Does this proposal or decision digitally-enable current or future transport infrastructure via smart systems (e.g., smart ticketing, smart motorways)?",null,null,null,null,null,null,null,"More help (web link 1)","More help (web link 2)",null,null,null,"",null,null,null,null,null,null,6]
[null,null,null,null,3,"Will this proposal or decision affect access to services for users through physical or digital infrastructure, such as provision of new transport links or online services?",null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,6]
[null,null,null,null,4,"Will this proposal or decision affect road congestion?",null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,6]
[null,null,null,null,5,"Does this proposal or decision affect affordability of transport or digital services?",null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,6]
[null,null,null,null,6,"Does this proposal or decision affect local availability of low carbon shared transport schemes?",null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,6]
[null,null,null,null,7,"Does this proposal or decision affect transport connectivity?",null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,6]
[null,null,null,null,8,"Does this proposal or decision affect cycling, walking, bus, tram or train availability and/or access?",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3]
[null,null,null,null,9,"Does the proposal or decision affect roads or parking?",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3]
[null,null,null,null,10,"Will this proposal or decision procure or lease a new vehicle?",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3]
[null,null,null,null,11,"Will this proposal or decision restrict petrol/diesel vehicle use in towns and cities?",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR((SUM(S88:S94))/((COUNTIF(S88:S94,\">0\")*2)),\"0\")","v":"0"},null,null,{"$f":"IF(AND(B87=1,Z99=0),ROUND(S99,2),IF(AND(B87=1,Z99<>0),\"x\",0))","v":"x"},null,null,null,{"$f":"COUNTIF(Z88:Z94,6)+COUNTIF(Z95:Z98,3)","v":11}]
[null,null,"7. Carbon, Nature and Environment"]
[null,null,"Will this proposal or decision affect the natural environment, carbon emissions, air quality and local pollution in GM?"]
[]
[]
[null,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"RAG Result",null,"Comment - please provide succinct statements."]
[null,null,{"$f":"IF(B104=1,\"Please complete next part →\",IF(B104=2,\"Proceed to next question ↓\",\"\"))","v":"Please complete next part →"},null,1,"Will this proposal or decision affect local air quality, for example, by changes in public levels of exposure to oxides of nitrogen (NOx), volatile organic compounds (VOCs) and particulate matter (PM10 & PM2.5)?",null,null,null,null,null,null,null,"More help (web link)",null,null,null,null,{"$f":"IF(OR(Z105=1,Z105=2),2,IF(OR(Z105=4,Z105=5),1,IF(Z105=3,0,\"\")))","v":""},null,null,{"$f":"IF(V114=0,\"\",IF(V114<0.63,\"RR\",IF(AND(V114>=0.63,V114<=0.74),\"R\",IF(AND(V114>=0.75,V114<=0.99),\"A\",IF(V114=1,\"G\",IF(V114=\"x\",\"This is calculated when all questions have been answered\",\"\"))))))","v":"This is calculated when all questions have been answered"},null,null,null,6]
[null,null,null,null,2,"Will this proposal affect the level of water pollutants in the environment?",null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,6]
[null,null,null,null,3,"Will this proposal affect the level of light pollutants in the environment?",null,null,null,null,null,null,null,"More help (web link)",null,null,null,null,"",null,null,null,null,null,null,6]
[null,null,null,null,4,"Will this proposal affect the level of noise pollutants in the environment?",null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,6]
[null,null,null,null,5,"Does this proposal or decision affect natural carbon sinks in GM e.g., through changes to woodland or peatland?",null,null,null,null,null,null,null,"More help (web link)",null,null,null,null,"",null,null,null,null,null,null,6]
[null,null,null,null,6,"Does this proposal or decision affect the visual amenity of the environment?",null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,6]
[null,null,null,null,7,"Will this proposal or decision affect biodiversity?",null,null,null,null,null,null,null,"More help (web link)",null,null,null,null,"",null,null,null,null,null,null,6]
[null,null,null,null,8,"Will this proposal or decision change the local community’s access to greenspace?",null,null,null,null,null,null,null,"More help (web link)",null,null,null,null,null,null,null,null,null,null,null,3]
[null,null,null,null,9,"Will this proposal or decision have a positive or negative effect on efforts to reduce carbon emissions across GM?",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(Z113=1,Z113=2),2,IF(OR(Z113=4,Z113=5),1,IF(Z113=3,0,\"\")))","v":""},null,null,null,null,null,null,6]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR((SUM(S105:S111,S113))/(SUM(COUNTIF(S105:S111,\">0\"),(COUNTIF(S113,\">0\")))*2),\"0\")","v":"0"},null,null,{"$f":"IF(AND(B104=1,Z114=0),ROUND(S114,2),IF(AND(B104=1,Z114<>0),\"x\",0))","v":"x"},null,null,null,{"$f":"COUNTIF(Z105:Z111,6)+COUNTIF(Z112,3)+COUNTIF(Z113,6)","v":9}]
[null,null,"8. Consumption and Production"]
[null,null,"Will this proposal or decision affect waste and recycling within GM?"]
[]
[]
[null,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"RAG Result",null,"Comment - please provide succinct statements."]
[null,null,{"$f":"IF(B119=1,\"Please complete next part →\",IF(B119=2,\"Proceed to next question ↓\",\"\"))","v":"Please complete next part →"},null,1,"Does this project or decision have an impact on the amount of waste produced, considering all waste streams and their life cycle including food waste?",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(Z120=1,Z120=2),2,IF(OR(Z120=4,Z120=5),1,IF(Z120=3,0,\"\")))","v":""},null,null,{"$f":"IF(V125=0,\"\",IF(V125<0.63,\"RR\",IF(AND(V125>=0.63,V125<=0.74),\"R\",IF(AND(V125>=0.75,V125<=0.99),\"A\",IF(V125=1,\"G\",IF(V125=\"x\",\"This is calculated when all questions have been answered\",\"\"))))))","v":"This is calculated when all questions have been answered"},null,null,null,6]
[null,null,null,null,2,"Will this project or decision affect current or future reuse or recycling rates?",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(Z121=1,Z121=2),2,IF(OR(Z121=4,Z121=5),1,IF(Z121=3,0,\"\")))","v":""},null,null,null,null,null,null,6]
[null,null,null,null,3,"Does this proposal or decision consider resource efficiency and take steps to increase circularity?",null,null,null,null,null,null,null,"More help (web link)",null,null,null,null,{"$f":"IF(OR(Z122=1,Z122=3),1,IF(Z122=2,2,IF(Z122=4,0,\"\")))","v":""},null,null,null,null,null,null,5]
[null,null,null,null,4,"Will this proposal or decision affect levels of single-use plastics and packaging in GM?",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(Z123=1,Z123=2),2,IF(OR(Z123=4,Z123=5),1,IF(Z123=3,0,\"\")))","v":""},null,null,null,null,null,null,6]
[null,null,null,null,5,"What impact will this project or decision have on goals to minimise construction waste?",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(Z124=1,Z124=2),2,IF(OR(Z124=4,Z124=5),1,IF(Z124=3,0,\"\")))","v":""},null,null,null,null,null,null,6]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR((SUM(S120:S124))/((COUNTIF(S120:S124,\">0\")*2)),\"0\")","v":"0"},null,null,{"$f":"IF(AND(B119=1,Z125=0),ROUND(S125,2),IF(AND(B119=1,Z125<>0),\"x\",0))","v":"x"},null,null,null,{"$f":"COUNTIF(Z120:Z121,6)+COUNTIF(Z122,5)+COUNTIF(Z123:Z124,6)","v":5}]
[]
[null,null,"9. Climate Change Target",null,null,null,null,null,null,"Enter text answer below (include summary of climate change mitigation measures)"]
[null,null,"How does this proposal or decision contribute to achieving the Greater Manchester Carbon Neutral 2038? What more could be done to improve this contribution futher?",null,null,null,null,"More help (web link)"]
[]
[]
[null,null,"Impacts Questionnaire: Progress Checklist"]
[null,{"$f":"IF(OR(E133=\"❌\",E134=\"❌\",E135=\"❌\",E136=\"❌\",E137=\"❌\",E138=\"❌\",E139=\"❌\",E140=\"❌\",E141=\"❌\"),2,1)","v":2},{"$f":"IF(OR(E133=\"❌\",E134=\"❌\",E135=\"❌\",E136=\"❌\",E137=\"❌\",E138=\"❌\",E139=\"❌\",E140=\"❌\",E141=\"❌\"),\"You have not yet fully completed this Impacts Questionnaire. Please refer to the checklist below to determine which section(s) require completion - these are marked with an ❌ and appear in black.\",\"You have fully completed the Impacts Questionnaire and can now proceed to the Next Steps below.\")","v":"You have not yet fully completed this Impacts Questionnaire. Please refer to the checklist below to determine which section(s) require completion - these are marked with an ❌ and appear in black."}]
[null,null,null,null,{"$f":"IF(OR(B27=2,AND(B27=1,Z33=0)),\"✅\",\"❌\")","v":"❌"},"1. Equality and Inclusion"]
[null,null,null,null,{"$f":"IF(OR(B38=2,AND(B38=1,Z45=0)),\"✅\",\"❌\")","v":"❌"},"2. Health"]
[null,null,null,null,{"$f":"IF(OR(B50=2,AND(B50=1,Z56=0)),\"✅\",\"❌\")","v":"❌"},"3. Resilience and Adaptation"]
[null,null,null,null,{"$f":"IF(OR(B61=2,AND(B61=1,Z68=0)),\"✅\",\"❌\")","v":"❌"},"4. Housing"]
[null,null,null,null,{"$f":"IF(OR(B73=2,AND(B73=1,Z82=0)),\"✅\",\"❌\")","v":"❌"},"5. Economy"]
[null,null,null,null,{"$f":"IF(OR(B87=2,AND(B87=1,Z99=0)),\"✅\",\"❌\")","v":"❌"},"6. Mobility and Connectivity"]
[null,null,null,null,{"$f":"IF(OR(B104=2,AND(B104=1,Z114=0)),\"✅\",\"❌\")","v":"❌"},"7. Carbon, Nature and Environment"]
[null,null,null,null,{"$f":"IF(OR(B119=2,AND(B119=1,Z125=0)),\"✅\",\"❌\")","v":"❌"},"8. Consumption and Production"]
[null,null,null,null,{"$f":"IF(ISBLANK(J128),\"❌\",\"✅\")","v":"❌"},"9. Climate Change Target"]
[]
[]
[null,null,"Next Steps"]
[]
[null,null,"Based on your answers above, the following sections should be completed."]
[null,null,"Click on the relevant link to take you to your next section:"]
[]
[null,null,null,{"$f":"IF(COUNTIF(E153:I156,\"✅\"&\"*\"),\"✅\",\"❌\")","v":"❌"},{"$f":"HYPERLINK(\"#'2. Carbon Assessment'!A1\",\"Step 2: Carbon Assessment\")","v":"Step 2: Carbon Assessment"}]
[null,null,null,null,"Here you will be prompted to answer the following sections:"]
[]
[null,null,null,null,"Buildings",null,"Transport",null,"Land Use"]
[null,null,null,null,{"$f":"IF(AND(B61=1,Z65=1),\"✅ Q.1a\",\"❌ Q.1a\")","v":"❌ Q.1a"},null,{"$f":"IF(AND(B87=1,Z95=1),\"✅ Q.2a\",\"❌ Q.2a\")","v":"❌ Q.2a"},null,{"$f":"IF(AND(B104=1,Z112=1),\"✅ Q.3a\",\"❌ Q.3a\")","v":"❌ Q.3a"}]
[null,null,null,null,{"$f":"IF(AND(B61=1,OR(Z66=1,Z67=1)),\"✅ Q.1b\",\"❌ Q.1b\")","v":"❌ Q.1b"},null,{"$f":"IF(AND(B87=1,Z96=1),\"✅ Q.2b\",\"❌ Q.2b\")","v":"❌ Q.2b"}]
[null,null,null,null,{"$f":"IF(AND(B73=1,Z81=1),\"✅ Q.1c\",\"❌ Q.1c\")","v":"❌ Q.1c"},null,{"$f":"IF(AND(B87=1,OR(Z94=1,Z94=2,Z94=4,Z94=5,Z98=1)),\"✅ Q.2c\",\"❌ Q.2c\")","v":"❌ Q.2c"}]
[null,null,null,null,null,null,{"$f":"IF(AND(B87=1,Z97=1),\"✅ Q.2d\",\"❌ Q.2d\")","v":"❌ Q.2d"}]
[]
[null,null,null,{"$f":"IF(AND(B27=1,OR(Z28=1,Z28=2,Z28=4,Z28=5)),\"✅\",\"❌\")","v":"❌"},{"$f":"HYPERLINK(\"#'3. Equalities Assessment'!A1\",\"Step 3: Equalities Impact Assessment\")","v":"Step 3: Equalities Impact Assessment"}]
[]
[null,null,null,"✅",{"$f":"HYPERLINK(\"#'4. Results'!A1\",\"Step 4: Results\")","v":"Step 4: Results"}]

{"sheet":"2. Carbon Assessment","index":2,"n_rows":130,"n_cols":25,"rows_kept":130,"cut":false,"hidden":false,"merged":[[113,3,117,3],[112,5,112,6],[116,5,116,6],[121,5,121,6],[43,5,43,6],[59,5,59,6],[104,5,104,6],[106,5,106,6],[23,7,23,8],[28,7,28,8],[52,7,52,8],[39,2,39,3],[40,2,40,3],[48,2,48,3],[49,2,49,3],[50,2,50,3],[107,2,107,3],[80,2,80,3],[81,2,81,3],[82,2,82,3],[87,2,87,3],[88,2,88,3],[89,2,89,3],[69,2,69,3],[9,2,9,7],[30,2,30,3],[31,2,31,3],[37,2,37,3],[26,5,26,6],[31,5,31,6],[24,2,24,3],[25,2,25,3],[26,2,26,3],[27,2,27,3],[28,2,28,3],[29,2,29,3],[77,16,82,17],[78,9,78,15],[23,16,31,17],[37,16,43,17],[48,9,48,15],[94,7,94,8],[89,9,89,15],[94,9,94,15],[94,2,94,3],[87,9,87,15],[88,9,88,15],[87,16,89,17],[58,9,58,15],[59,9,59,15],[55,9,55,15],[56,9,56,15],[57,9,57,15],[41,9,41,15],[42,7,42,8],[42,9,42,15],[43,9,43,15],[48,7,48,8],[37,7,37,8],[37,9,37,15],[104,9,104,15],[104,16,107,17],[105,9,105,15],[106,9,106,15],[107,9,107,15],[97,7,97,8],[95,9,95,15],[96,9,96,15],[97,9,97,15],[94,16,97,17],[79,9,79,15],[80,9,80,15],[81,9,81,15],[82,9,82,15],[49,9,49,15],[50,9,50,15],[51,9,51,15],[52,9,52,15],[53,9,53,15],[54,9,54,15],[66,9,66,15],[67,9,67,15],[68,9,68,15],[69,9,69,15],[71,9,71,15],[72,9,72,15],[77,9,77,15],[70,9,70,15],[4,2,4,6],[5,2,5,6],[8,2,8,6],[38,2,38,3],[41,2,41,3],[42,2,42,3],[43,2,43,3],[48,16,59,17],[66,16,72,17],[38,9,38,15],[39,9,39,15],[40,9,40,15],[29,9,29,15],[30,9,30,15],[31,9,31,15],[23,9,23,15],[24,9,24,15],[25,9,25,15],[26,9,26,15],[27,9,27,15],[28,9,28,15],[6,2,6,3],[7,2,7,7],[23,2,23,3],[96,2,96,3],[97,2,97,3],[104,2,104,3],[105,2,105,3],[106,2,106,3],[57,2,57,3],[58,2,58,3],[59,2,59,3],[51,2,51,3],[66,2,66,3],[67,2,67,3],[68,2,68,3],[52,2,52,3],[53,2,53,3],[54,2,54,3],[55,2,55,3],[56,2,56,3],[71,2,71,3],[72,2,72,3],[77,2,77,3],[78,2,78,3],[79,2,79,3],[95,2,95,3],[70,2,70,3]]}
[]
[null,null,"2. Simple Carbon Assessment"]
[]
[null,null,"Guide"]
[null,null,"The Simple Carbon Assessment tool scores the Decision against best practice for reducing carbon emissions that cause climate change in line with GMCA targets. You only need to answer the sections indicated - this is determined by answers given in the Impacts Questionnaire."]
[null,null,"Some questions require a yes/no response that is scored. Others require a comment that will provide additional context for a reviewer of the decision. If 'Non Applicable\" is given as an answer add a brief explanation why this is the case."]
[null,null,"All questions need to be answered to score a section. "]
[null,null,"For any scoring a comment can be added as justification in the 'Comment' column."]
[null,null,"Embodied carbon is not specified in the simple assessment - full life cycle assessment is required and advisable to comment on this."]
[null,null,"The scoring is colour coded as follows:"]
[null,null,null,"Grey: No associated carbon impacts expected for decision."]
[null,null,null,"Green: In the simple assessment the decision meets the highest standard in terms of practice and awareness."]
[null,null,null,"Blue: In the simple assessment the decision meets most of the associated best practice with a good level of awareness."]
[null,null,null,"Brown: In the simple assessment the decision only partially meets associated best practice and/or awareness is lacking, significant room for improvement."]
[null,null,null,"Black: In the simple assessment the decision does not meet best practice and/or there is insufficient awareness of carbon impacts."]
[]
[null,null,"Simple Carbon Assessment"]
[]
[null,null,"Buildings"]
[]
[null,{"$f":"IF(ISNUMBER(SEARCH(\"You do not need\",C21)),1,IF(ISNUMBER(SEARCH(\"to determine if\",C21)),3,IF(ISNUMBER(SEARCH(\"Please answer\",C21)),2,\"\")))","v":3},{"$f":"IF(AND('1. Impacts Questionnaire'!B61=1,'1. Impacts Questionnaire'!Z65=1),\"✅ Please answer section 1a\",IF(OR('1. Impacts Questionnaire'!B61=2,AND('1. Impacts Questionnaire'!B61=1,'1. Impacts Questionnaire'!Z65=2)),\"❌ You do not need to answer section 1a\",\"Please complete the Impacts Questionnaire to determine if you are required to complete this section.\"))","v":"Please complete the Impacts Questionnaire to determine if you are required to complete this section."}]
[]
[null,null,"Q.1a If the Decision will contribute to the construction of a new residential building(s):",null,null,null,null,null,null,"Comment - please provide succinct statements.",null,null,null,null,null,null,"Result"]
[null,null,"State the design energy performance certification (EPC) of the building(s).",null,null,null,null,"Enter text answer in the comment field →",null,null,null,null,null,null,null,null,{"$f":"IF(AND('1. Impacts Questionnaire'!Z65=1,T33=0),Y33,IF(AND('1. Impacts Questionnaire'!Z65=1,T33<>0),\"This is calculated when all questions have been answered\",IF(C21=\"Please complete the Impacts Questionnaire to determine if you are required to complete this section.\",\"Please complete the Impacts Questionnaire to determine if you are required to complete this section.\",\"\")))","v":"Please complete the Impacts Questionnaire to determine if you are required to complete this section."},null,{"$f":"IF(AND('1. Impacts Questionnaire'!Z65=1,T33=0),Y33,IF(AND('1. Impacts Questionnaire'!Z65=1,T33<>0),\"TBC\",\"\"))","v":""}]
[null,null,"Does the proposed building fabric exceed required standards of energy efficiency (part L)?",null,null,null,null,null,{"$f":"IF(U25=\"Add comment >\",\"Add comment >\",\"\")","v":""},null,null,null,null,null,null,null,null,null,null,5,{"$f":"IF(T25=1,-1,IF(T25=2,1,IF(T25=3,-1,IF(T25=4,\"\",\"\"))))","v":""}]
[null,null,"Does the new building(s) include a natural gas or oil based heating system?",null,null,null,null,null,{"$f":"IF(U26=\"Add comment >\",\"Add comment >\",\"\")","v":""},null,null,null,null,null,null,null,null,null,null,5,{"$f":"IF(T26=1,-1,IF(T26=2,-1,IF(T26=3,1,IF(T26=4,\"Add comment >\",\"\"))))","v":""}]
[null,null,"Are proposed buildings to Passivhaus standard?",null,null,"More help (web link)",null,null,{"$f":"IF(U27=\"Add comment >\",\"Add comment >\",\"\")","v":""},null,null,null,null,null,null,null,null,null,null,5,{"$f":"IF(T27=1,0,IF(T27=2,2,IF(T27=3,0,IF(T27=4,\"Add comment >\",\"\"))))","v":""}]
[null,null,"Have life cycle (embodied) carbon emissions of building materials been considered and minimised in building design and are steps taken to procure lowest carbon options?",null,null,null,null,null,{"$f":"IF(U28=\"Add comment >\",\"Add comment >\",\"\")","v":""},null,null,null,null,null,null,null,null,null,null,5,{"$f":"IF(T28=1,0,IF(T28=2,1,IF(T28=3,0,IF(T28=4,\"Add comment >\",\"\"))))","v":""}]
[null,null,"Estimated additional costs to increase building air tightness and/or swap to low carbon heating.",null,null,null,null,"Enter text answer in the comment field →"]
[null,null,"Has a biodiversity impact assessment been completed and is onsite biodiversity net gain over 10%?",null,null,"More help (web link)",null,null,{"$f":"IF(U30=\"Add comment >\",\"Add comment >\",\"\")","v":""},null,null,null,null,null,null,null,null,null,null,5,{"$f":"IF(T30=1,0,IF(T30=2,1,IF(T30=3,0,IF(T30=4,\"Add comment >\",\"N\"))))","v":"N"}]
[null,null,"Is there suitable pedestrian and cycle assess from the new building(s) to all or some of the following amenities - food shopping/other shops/transport hub/health care services?",null,null,null,null,null,{"$f":"IF(U31=\"Add comment >\",\"Add comment >\",\"\")","v":""},null,null,null,null,null,null,null,null,null,null,5,{"$f":"IF(T31=1,0,IF(T31=2,1,IF(T31=3,-1,IF(T31=4,\"Add comment >\",\"N\"))))","v":"N"}]
[null,null,"Building will include onsite renewable energy (Solar Photovoltaics (PV), Solar Thermal, Ground/Air Source Heat Pump)?",null,null,"More help (web link)",null,null,{"$f":"IF(U32=\"Add comment >\",\"Add comment >\",\"\")","v":""},null,null,null,null,null,null,null,null,null,null,5,{"$f":"IF(T32=1,0,IF(T32=2,2,IF(T32=3,0,IF(T32=4,\"Add comment >\",\"\"))))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"COUNTIF(T25:T32,5)","v":7},{"$f":"IF($C$21=\"✅ Please answer section 1a\",(SUM($U$25:$U$32)),\"0\")","v":"0"},{"$f":"U33","v":"0"},{"$f":"COUNT(U25:U32)","v":0},{"$f":"IF(AND(T33=0,C21=\"✅ Please answer section 1a\"),W33,0)","v":0},{"$f":"IF(T33=0,(U33/X33),\"N/A\")","v":"N/A"}]
[]
[null,{"$f":"IF(ISNUMBER(SEARCH(\"You do not need\",C35)),1,IF(ISNUMBER(SEARCH(\"to determine if\",C35)),3,IF(ISNUMBER(SEARCH(\"Please answer\",C35)),2,\"\")))","v":3},{"$f":"IF(AND('1. Impacts Questionnaire'!B61=1,OR('1. Impacts Questionnaire'!Z66=1,'1. Impacts Questionnaire'!Z67=1)),\"✅ Please answer section 1b\",IF(OR('1. Impacts Questionnaire'!B61=2,AND('1. Impacts Questionnaire'!B61=1,'1. Impacts Questionnaire'!Z66=2,'1. Impacts Questionnaire'!Z67=2)),\"❌ You do not need to answer section 1b\",\"Please complete the Impacts Questionnaire to determine if you are required to complete this section.\"))","v":"Please complete the Impacts Questionnaire to determine if you are required to complete this section."}]
[]
[null,null,"Q.1b If the decision will contribute to the renovation or maintenance of a residential building(s):",null,null,null,null,null,null,"Comment - please provide succinct statements.",null,null,null,null,null,null,"Result"]
[null,null,"What is the current EPC standard of the building(s) and what will it be following the intervention(s)?",null,null,null,null,"Enter text answer in the comment field →",null,null,null,null,null,null,null,null,{"$f":"IF(AND(OR('1. Impacts Questionnaire'!Z66=1,'1. Impacts Questionnaire'!Z67=1),T45=0),Y45,IF(AND(OR('1. Impacts Questionnaire'!Z66=1,'1. Impacts Questionnaire'!Z67=1),T45<>0),\"This is calculated when all questions have been answered\",IF(C35=\"Please complete the Impacts Questionnaire to determine if you are required to complete this section.\",\"Please complete the Impacts Questionnaire to determine if you are required to complete this section.\",\"\")))","v":"Please complete the Impacts Questionnaire to determine if you are required to complete this section."},null,{"$f":"IF(AND(OR('1. Impacts Questionnaire'!Z66=1,'1. Impacts Questionnaire'!Z67=1),T45=0),Y45,IF(AND(OR('1. Impacts Questionnaire'!Z66=1,'1. Impacts Questionnaire'!Z67=1),T45<>0),\"TBC\",\"\"))","v":""}]
[null,null,"If natural gas/oil heating systems are present will they be replaced with a low carbon alternative?",null,null,null,null,null,{"$f":"IF(U39=\"Add comment >\",\"Add comment >\",\"\")","v":""},null,null,null,null,null,null,null,null,null,null,5,{"$f":"IF(T39=1,-1,IF(T39=2,2,IF(T39=3,0,IF(T39=4,\"Add comment >\",\"\"))))","v":""}]
[null,null,"Have life cycle (embodied) carbon emissions of building materials being considered and are steps taken to procure lowest carbon options?",null,null,null,null,null,{"$f":"IF(U40=\"Add comment >\",\"Add comment >\",\"\")","v":""},null,null,null,null,null,null,null,null,null,null,5,{"$f":"IF(T40=1,0,IF(T40=2,1,IF(T40=3,0,IF(T40=4,\"Add comment >\",\"\"))))","v":""}]
[null,null,"Will the building fabric be upgraded to improve energy efficiency?",null,null,null,null,null,{"$f":"IF(U41=\"Add comment >\",\"Add comment >\",\"\")","v":""},null,null,null,null,null,null,null,null,null,null,5,{"$f":"IF(T41=1,-1,IF(T41=2,1,IF(T41=3,-1,IF(T41=4,\"Add comment >\",\"\"))))","v":""}]
[null,null,"Will a minimum EPC rating of 'C' be attained?",null,null,null,null,null,{"$f":"IF(U42=\"Add comment >\",\"Add comment >\",\"\")","v":""},null,null,null,null,null,null,null,null,null,null,5,{"$f":"IF(T42=1,-1,IF(T42=2,1,IF(T42=3,0,IF(T42=4,\"Add comment >\",\"\"))))","v":""}]
[null,null,"What additional costs are associated with upgrading building to EnerPhit standard after intervention)?",null,null,"Help (web link)","Help (web link 2)","Enter text answer in the comment field →"]
[null,null,"Will onsite renewable energy generation (Solar Photovoltaics or Solar Thermal) be added as part of the renovation/maintenance?",null,null,"More help (web link)",null,null,{"$f":"IF(U44=\"Add comment >\",\"Add comment >\",\"\")","v":""},null,null,null,null,null,null,null,null,null,null,5,{"$f":"IF(T44=1,-1,IF(T44=2,1,IF(T44=3,0,IF(T44=4,\"Add comment >\",\"\"))))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"COUNTIF(T38:T44,5)","v":5},{"$f":"IF($C$35=\"✅ Please answer section 1b\",(SUM($U$38:$U$44)),0)","v":0},{"$f":"U45","v":0},{"$f":"COUNT(U39:U44)","v":0},{"$f":"IF(AND(T45=0,C35=\"✅ Please answer section 1b\"),W45,0)","v":0},{"$f":"U45/X45","v":{"$error":"#DIV/0!"}}]
[null,{"$f":"IF(ISNUMBER(SEARCH(\"You do not need\",C46)),1,IF(ISNUMBER(SEARCH(\"to determine if\",C46)),3,IF(ISNUMBER(SEARCH(\"Please answer\",C46)),2,\"\")))","v":3},{"$f":"IF(AND('1. Impacts Questionnaire'!B73=1,'1. Impacts Questionnaire'!Z81=1),\"✅ Please answer section 1c\",IF(OR('1. Impacts Questionnaire'!B73=2,AND('1. Impacts Questionnaire'!B73=1,'1. Impacts Questionnaire'!Z81=2)),\"❌ You do not need to answer section 1c\",\"Please complete the Impacts Questionnaire to determine if you are required to complete this section.\"))","v":"Please complete the Impacts Questionnaire to determine if you are required to complete this section."}]
[]
[null,null,"Q.1c If the Decision will contribute to the construction of a new non-residential (including public) building:",null,null,null,null,null,null,"Comment - please provide succinct statements.",null,null,null,null,null,null,"Result"]
[null,null,"State the design Energy Performance Certificate (EPC) or Display Energy Certificate (DEC) of the building.",null,null,null,null,"Enter text answer in the comment field →",null,null,null,null,null,null,null,null,{"$f":"IF(AND('1. Impacts Questionnaire'!Z81=1,T61=0),Y61,IF(AND('1. Impacts Questionnaire'!Z81=1,T61<>0),\"This is calculated when all questions have been answered\",IF(C46=\"Please complete the Impacts Questionnaire to determine if you are required to complete this section.\",\"Please complete the Impacts Questionnaire to determine if you are required to complete this section.\",\"\")))","v":"Please complete the Impacts Questionnaire to determine if you are required to complete this section."},null,{"$f":"IF(AND('1. Impacts Questionnaire'!Z81=1,T61=0),Y61,IF(AND('1. Impacts Questionnaire'!Z81=1,T61<>0),\"TBC\",\"\"))","v":""}]
[null,null,"Does the proposed building exceed required standards of energy efficiency (part L)?",null,null,null,null,null,{"$f":"IF(U50=\"Add comment >\",\"Add comment >\",\"\")","v":""},null,null,null,null,null,null,null,null,null,null,5,{"$f":"IF(T50=1,-1,IF(T50=2,1,IF(T50=3,-1,IF(T50=4,\"Add comment >\",\"\"))))","v":""}]
[null,null,"Does the new building(s) include a natural gas or oil based heating system?",null,null,null,null,null,{"$f":"IF(U51=\"Add comment >\",\"Add comment >\",\"\")","v":""},null,null,null,null,null,null,null,null,null,null,5,{"$f":"IF(T51=1,-1,IF(T51=2,-1,IF(T51=3,1,IF(T51=4,\"Add comment >\",\"\"))))","v":""}]
[null,null,"Does the building design include a Building Energy Management system or Building Management System?",null,null,null,null,null,{"$f":"IF(U52=\"Add comment >\",\"Add comment >\",\"\")","v":""},null,null,null,null,null,null,null,null,null,null,5,{"$f":"IF(T52=1,-1,IF(T52=2,1,IF(T52=3,0,IF(T52=4,\"Add comment >\",\"\"))))","v":""}]
[null,null,"Estimated additional costs to improve to higher fabric efficiency standard.",null,null,null,null,"Enter text answer in the comment field →"]
[null,null,"Have life cycle (embodied) carbon emissions of building materials being considered and are steps taken to procure lowest carbon options?",null,null,null,null,null,{"$f":"IF(U54=\"Add comment >\",\"Add comment >\",\"\")","v":""},null,null,null,null,null,null,null,null,null,null,5,{"$f":"IF(T54=1,0,IF(T54=2,1,IF(T54=3,0,IF(T54=4,\"Add comment >\",\"\"))))","v":""}]
[null,null,"Has a biodiversity impact assessment been completed and is onsite biodiversity net gain over 10%?",null,null,"More help (web link)",null,null,"",null,null,null,null,null,null,null,null,null,null,5,{"$f":"IF(T55=1,0,IF(T55=2,1,IF(T55=3,-1,IF(T55=4,\"Add comment >\",\"\"))))","v":""}]
[null,null,"Is there suitable pedestrian and cycle access to/from the new building(s) for car free commuting?",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,5,{"$f":"IF(T56=1,-1,IF(T56=2,1,IF(T56=3,-1,IF(T56=4,\"Add comment >\",\"\"))))","v":""}]
[null,null,"Is there a bus/tram/train stop near (up to a mile) from the building(s) for car free commuting?",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,5,{"$f":"IF(T57=1,-1,IF(T57=2,1,IF(T57=3,0,IF(T57=4,\"Add comment >\",\"\"))))","v":""}]
[null,null,"Will the development include multiple electric vehicle charging points?",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,5,{"$f":"IF(T58=1,-1,IF(T58=2,1,IF(T58=3,0,IF(T58=4,\"Add comment >\",\"\"))))","v":""}]
[null,null,"Does the development include facilities for cyclists (secure, dry bike storage)?",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,5,{"$f":"IF(T59=1,-1,IF(T59=2,1,IF(T59=3,0,IF(T59=4,\"Add comment >\",\"\"))))","v":""}]
[null,null,"Will the building have onsite renewables energy generation (Solar Photovoltaics (PV), Solar Thermal, wind generator)?",null,null,"More help (web link)",null,null,"",null,null,null,null,null,null,null,null,null,null,5,{"$f":"IF(T60=1,-1,IF(T60=2,1,IF(T60=3,0,IF(T60=4,\"Add comment >\",\"\"))))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"COUNTIF(T49:T60,5)","v":10},{"$f":"IF($C$46=\"✅ Please answer section 1c\",(SUM($U$50:$U$60)),0)","v":0},{"$f":"U61","v":0},{"$f":"COUNT(U50:U60)","v":0},{"$f":"IF(AND(T61=0,C46=\"✅ Please answer section 1c\"),W61,0)","v":0},{"$f":"U61/X61","v":{"$error":"#DIV/0!"}}]
[null,null,"Transport"]
[]
[null,{"$f":"IF(ISNUMBER(SEARCH(\"You do not need\",C64)),1,IF(ISNUMBER(SEARCH(\"to determine if\",C64)),3,IF(ISNUMBER(SEARCH(\"Please answer\",C64)),2,\"\")))","v":3},{"$f":"IF(AND('1. Impacts Questionnaire'!B87=1,'1. Impacts Questionnaire'!Z95=1),\"✅ Please answer section 2a\",IF(OR('1. Impacts Questionnaire'!B87=2,AND('1. Impacts Questionnaire'!B87=1,'1. Impacts Questionnaire'!Z95=2)),\"❌ You do not need to answer section 2a\",\"Please complete the Impacts Questionnaire to determine if you are required to complete this section.\"))","v":"Please complete the Impacts Questionnaire to determine if you are required to complete this section."}]
[]
[null,null,"Q.2a If this Decision affects cycling, walking, bus, tram or train availability and/or access:",null,null,null,null,null,null,"Comment - please provide succinct statements.",null,null,null,null,null,null,"Result"]
[null,null,"Is an existing active travel route being extended/improved?",null,null,null,null,null,{"$f":"IF(U67=\"Add comment >\",\"Add comment >\",\"\")","v":""},null,null,null,null,null,null,null,{"$f":"IF(AND('1. Impacts Questionnaire'!Z95=1,T74=0),Y74,IF(AND('1. Impacts Questionnaire'!Z95=1,T74<>0),\"This is calculated when all questions have been answered\",IF(C64=\"Please complete the Impacts Questionnaire to determine if you are required to complete this section.\",\"Please complete the Impacts Questionnaire to determine if you are required to complete this section.\",\"\")))","v":"Please complete the Impacts Questionnaire to determine if you are required to complete this section."},null,{"$f":"IF(AND('1. Impacts Questionnaire'!Z95=1,T74=0),Y74,IF(AND('1. Impacts Questionnaire'!Z95=1,T74<>0),\"TBC\",\"\"))","v":""},5,{"$f":"IF(T67=1,-1,IF(T67=2,1,IF(T67=3,0,IF(T67=4,\"Add comment >\",\"\"))))","v":""}]
[null,null,"Is an existing active travel route being removed/reduced?",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,5,{"$f":"IF(T68=1,-1,IF(T68=2,-1,IF(T68=3,1,IF(T68=4,\"Add comment >\",\"\"))))","v":""}]
[null,null,"Is an active travel route being created?",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,5,{"$f":"IF(T69=1,0,IF(T69=2,2,IF(T69=3,1,IF(T69=4,\"Add comment >\",\"\"))))","v":""}]
[null,null,"Is access to existing and planned local educational, shopping, leisure and work facilities by public transport being improved?",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,5,{"$f":"IF(T70=1,-1,IF(T70=2,1,IF(T70=3,0,IF(T70=4,\"Add comment >\",\"\"))))","v":""}]
[null,null,"Is resident access to low carbon transport being enhanced through increased shared mobility options?",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5,{"$f":"IF(T71=1,-1,IF(T71=2,1,IF(T71=3,0,IF(T71=4,\"Add comment >\",\"\"))))","v":""}]
[null,null,"Are new public transport facilities being constructed?",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,5,{"$f":"IF(T72=1,0,IF(T72=2,2,IF(T72=3,1,IF(T72=4,\"Add comment >\",\"\"))))","v":""}]
[null,null,"Are existing public transport facilities being removed or disrupted?",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,5,{"$f":"IF(T73=1,0,IF(T73=2,-1,IF(T73=3,1,IF(T73=4,\"Add comment >\",\"\"))))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"COUNTIF(T67:T73,5)","v":7},{"$f":"IF($C$64=\"✅ Please answer section 2a\",(SUM($U$67:$U$73)),0)","v":0},{"$f":"U74","v":0},{"$f":"COUNT(U67:U73)","v":0},{"$f":"IF(AND(T74=0,C64=\"✅ Please answer section 2a\"),W74,0)","v":0},{"$f":"U74/X74","v":{"$error":"#DIV/0!"}}]
[null,{"$f":"IF(ISNUMBER(SEARCH(\"You do not need\",C75)),1,IF(ISNUMBER(SEARCH(\"to determine if\",C75)),3,IF(ISNUMBER(SEARCH(\"Please answer\",C75)),2,\"\")))","v":3},{"$f":"IF(AND('1. Impacts Questionnaire'!B87=1,'1. Impacts Questionnaire'!Z96=1),\"✅ Please answer section 2b\",IF(OR('1. Impacts Questionnaire'!B87=2,AND('1. Impacts Questionnaire'!B87=1,'1. Impacts Questionnaire'!Z96=2)),\"❌ You do not need to answer section 2b\",\"Please complete the Impacts Questionnaire to determine if you are required to complete this section.\"))","v":"Please complete the Impacts Questionnaire to determine if you are required to complete this section."}]
[]
[null,null,"Q.2b If the Decision affect roads, parking or vehicle access:",null,null,null,null,null,null,"Comment - please provide succinct statements.",null,null,null,null,null,null,"Result"]
[null,null,"Will road capacity be increased for vehicles only?",null,null,null,null,null,{"$f":"IF(U78=\"Add comment >\",\"Add comment >\",\"\")","v":""},null,null,null,null,null,null,null,{"$f":"IF(AND('1. Impacts Questionnaire'!Z96=1,T84=0),Y84,IF(AND('1. Impacts Questionnaire'!Z96=1,T84<>0),\"This is calculated when all questions have been answered\",IF(C75=\"Please complete the Impacts Questionnaire to determine if you are required to complete this section.\",\"Please complete the Impacts Questionnaire to determine if you are required to complete this section.\",\"\")))","v":"Please complete the Impacts Questionnaire to determine if you are required to complete this section."},null,{"$f":"IF(AND('1. Impacts Questionnaire'!Z96=1,T84=0),Y84,IF(AND('1. Impacts Questionnaire'!Z96=1,T84<>0),\"TBC\",\"\"))","v":""},5,{"$f":"IF(T78=1,-1,IF(T78=2,-1,IF(T78=3,1,IF(T78=4,\"Add comment >\",\"\"))))","v":""}]
[null,null,"Will access for cyclists or pedestrians be reduced?",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,5,{"$f":"IF(T79=1,-1,IF(T79=2,-1,IF(T79=3,1,IF(T79=4,\"Add comment >\",\"\"))))","v":""}]
[null,null,"Will access for cyclists or pedestrians be improved?",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,5,{"$f":"IF(T80=1,0,IF(T80=2,1,IF(T80=3,-1,IF(T80=4,\"Add comment >\",\"\"))))","v":""}]
[null,null,"Will the Decision incentivise more personal vehicle travel?",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,5,{"$f":"IF(T81=1,0,IF(T81=2,-1,IF(T81=3,1,IF(T81=4,\"Add comment >\",\"\"))))","v":""}]
[null,null,"With the exception of Disabled Parking - will the Decision lead to a net increase in parking spaces in town/city centres?",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,5,{"$f":"IF(T82=1,0,IF(T82=2,-1,IF(T82=3,1,IF(T82=4,\"Add comment >\",\"\"))))","v":""}]
[null,null,"Does the Decision increase access to electric vehicle charging points?",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,5,{"$f":"IF(T83=1,0,IF(T83=2,1,IF(T83=3,0,IF(T83=4,\"Add comment >\",\"\"))))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"COUNTIF(T78:T83,5)","v":6},{"$f":"IF($C$75=\"✅ Please answer section 2b\",(SUM($U$78:$U$83)),0)","v":0},{"$f":"U84","v":0},{"$f":"COUNT(U78:U83)","v":0},{"$f":"IF(AND(T84=0,C75=\"✅ Please answer section 2b\"),W84,0)","v":0},{"$f":"U84/X84","v":{"$error":"#DIV/0!"}}]
[null,{"$f":"IF(ISNUMBER(SEARCH(\"You do not need\",C85)),1,IF(ISNUMBER(SEARCH(\"to determine if\",C85)),3,IF(ISNUMBER(SEARCH(\"Please answer\",C85)),2,\"\")))","v":3},{"$f":"IF(AND('1. Impacts Questionnaire'!B87=1,OR('1. Impacts Questionnaire'!Z94=1,'1. Impacts Questionnaire'!Z94=2,'1. Impacts Questionnaire'!Z94=4,'1. Impacts Questionnaire'!Z94=5,'1. Impacts Questionnaire'!Z98=1)),\"✅ Please answer section 2c\",IF(OR('1. Impacts Questionnaire'!B87=2,AND('1. Impacts Questionnaire'!B87=1,'1. Impacts Questionnaire'!Z94=3,'1. Impacts Questionnaire'!Z98=2)),\"❌ You do not need to answer section 2c\",\"Please complete the Impacts Questionnaire to determine if you are required to complete this section.\"))","v":"Please complete the Impacts Questionnaire to determine if you are required to complete this section."}]
[]
[null,null,"Q.2c If this Decision affect access for residents to amenities:",null,null,null,null,null,null,"Comment - please provide succinct statements.",null,null,null,null,null,null,"Result"]
[null,null,"Does the development improve access to shops and services for residents by walking/cycling?",null,null,null,null,null,{"$f":"IF(U88=\"Add comment >\",\"Add comment >\",\"\")","v":""},null,null,null,null,null,null,null,{"$f":"IF(AND(OR('1. Impacts Questionnaire'!Z94=1,'1. Impacts Questionnaire'!Z94=2,'1. Impacts Questionnaire'!Z94=4,'1. Impacts Questionnaire'!Z94=5,'1. Impacts Questionnaire'!Z98=1),T91=0),Y91,IF(AND(OR('1. Impacts Questionnaire'!Z94=1,'1. Impacts Questionnaire'!Z94=2,'1. Impacts Questionnaire'!Z94=4,'1. Impacts Questionnaire'!Z94=5,'1. Impacts Questionnaire'!Z98=1),T91<>0),\"This is calculated when all questions have been answered\",IF(C85=\"Please complete the Impacts Questionnaire to determine if you are required to complete this section.\",\"Please complete the Impacts Questionnaire to determine if you are required to complete this section.\",\"\")))","v":"Please complete the Impacts Questionnaire to determine if you are required to complete this section."},null,{"$f":"IF(AND(OR('1. Impacts Questionnaire'!Z94=1,'1. Impacts Questionnaire'!Z94=2,'1. Impacts Questionnaire'!Z94=4,'1. Impacts Questionnaire'!Z94=5,'1. Impacts Questionnaire'!Z98=1),T91=0),Y91,IF(AND(OR('1. Impacts Questionnaire'!Z94=1,'1. Impacts Questionnaire'!Z94=2,'1. Impacts Questionnaire'!Z94=4,'1. Impacts Questionnaire'!Z94=5,'1. Impacts Questionnaire'!Z98=1),T91<>0),\"TBC\",\"\"))","v":""},5,{"$f":"IF(T88=1,-1,IF(T88=2,1,IF(T88=3,-1,IF(T88=4,\"Add comment >\",\"\"))))","v":""}]
[null,null,"Does the development improve access to shops and services for residents by bus/tram?",null,null,null,null,null,{"$f":"IF(U89=\"Add comment >\",\"Add comment >\",\"\")","v":""},null,null,null,null,null,null,null,null,null,null,5,{"$f":"IF(T89=1,0,IF(T89=2,1,IF(T89=3,0,IF(T89=4,\"Add comment >\",\"\"))))","v":""}]
[null,null,"Does the development require access to a car to reach?",null,null,null,null,null,{"$f":"IF(U90=\"Add comment >\",\"Add comment >\",\"\")","v":""},null,null,null,null,null,null,null,null,null,null,5,{"$f":"IF(T90=1,-1,IF(T90=2,-2,IF(T90=3,1,IF(T90=4,\"Add comment >\",\"\"))))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"COUNTIF(T88:T90,5)","v":3},{"$f":"IF($C$85=\"✅ Please answer section 2c\",(SUM($U$88:$U$90)),0)","v":0},{"$f":"U91","v":0},{"$f":"COUNT(U88:U90)","v":0},{"$f":"IF(AND(T91=0,C85=\"✅ Please answer section 2c\"),W91,0)","v":0},{"$f":"U91/X91","v":{"$error":"#DIV/0!"}}]
[null,{"$f":"IF(ISNUMBER(SEARCH(\"You do not need\",C92)),1,IF(ISNUMBER(SEARCH(\"to determine if\",C92)),3,IF(ISNUMBER(SEARCH(\"Please answer\",C92)),2,\"\")))","v":3},{"$f":"IF(AND('1. Impacts Questionnaire'!B87=1,'1. Impacts Questionnaire'!Z97=1),\"✅ Please answer section 2d\",IF(OR('1. Impacts Questionnaire'!B87=2,AND('1. Impacts Questionnaire'!B87=1,'1. Impacts Questionnaire'!Z97=2)),\"❌ You do not need to answer section 2d\",\"Please complete the Impacts Questionnaire to determine if you are required to complete this section.\"))","v":"Please complete the Impacts Questionnaire to determine if you are required to complete this section."}]
[]
[null,null,"Q.2d If the Decision requires the procurement of a new vehicle:",null,null,null,null,null,null,"Comment - please provide succinct statements.",null,null,null,null,null,null,"Result"]
[null,null,"What is the vehicle?",null,null,null,null,"Enter text answer in the comment field →",null,null,null,null,null,null,null,null,{"$f":"IF(AND('1. Impacts Questionnaire'!Z97=1,T99=0),Y99,IF(AND('1. Impacts Questionnaire'!Z97=1,T99<>0),\"This is calculated when all questions have been answered\",IF(C92=\"Please complete the Impacts Questionnaire to determine if you are required to complete this section.\",\"Please complete the Impacts Questionnaire to determine if you are required to complete this section.\",\"\")))","v":"Please complete the Impacts Questionnaire to determine if you are required to complete this section."},null,{"$f":"IF(AND('1. Impacts Questionnaire'!Z97=1,T99=0),Y99,IF(AND('1. Impacts Questionnaire'!Z97=1,T99<>0),\"TBC\",\"\"))","v":""}]
[null,null,"Is the vehicle fully electric or hydrogen fuelled? ",null,null,null,null,null,{"$f":"IF(U96=\"Add comment >\",\"Add comment >\",\"\")","v":""},null,null,null,null,null,null,null,null,null,null,5,{"$f":"IF(T96=1,-1,IF(T96=2,2,IF(T96=3,-1,IF(T96=4,\"Add comment >\",\"\"))))","v":""}]
[null,null,"Were whole-life costs for the vehicle (operation as well as initial purchase) considered?",null,null,null,null,null,{"$f":"IF(U97=\"Add comment >\",\"Add comment >\",\"\")","v":""},null,null,null,null,null,null,null,null,null,null,5,{"$f":"IF(T97=1,-1,IF(T97=2,1,IF(T97=3,-1,IF(T97=4,\"Add comment >\",\"\"))))","v":""}]
[null,null,"If a fully electric or hydrogen option is not being selected state why.",null,null,null,null,"Enter text answer in the comment field →"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"COUNTIF(T95:T98,5)","v":2},{"$f":"IF($C$92=\"✅ Please answer section 2d\",(SUM($U$95:$U$98)),0)","v":0},{"$f":"U99","v":0},{"$f":"COUNT(U96:U97)","v":0},{"$f":"IF(AND(T99=0,C92=\"✅ Please answer section 2d\"),W99,0)","v":0},{"$f":"U99/X99","v":{"$error":"#DIV/0!"}}]
[null,null,"Land Use"]
[]
[null,{"$f":"IF(ISNUMBER(SEARCH(\"You do not need\",C102)),1,IF(ISNUMBER(SEARCH(\"to determine if\",C102)),3,IF(ISNUMBER(SEARCH(\"Please answer\",C102)),2,\"\")))","v":3},{"$f":"IF(AND('1. Impacts Questionnaire'!B104=1,'1. Impacts Questionnaire'!Z112=1),\"✅ Please answer section 3a\",IF(OR('1. Impacts Questionnaire'!B104=2,AND('1. Impacts Questionnaire'!B104=1,'1. Impacts Questionnaire'!Z112=2)),\"❌ You do not need to answer section 3a\",\"Please complete the Impacts Questionnaire to determine if you are required to complete this section.\"))","v":"Please complete the Impacts Questionnaire to determine if you are required to complete this section."}]
[]
[null,null,"Q.3a If the Decision changes existing land use:",null,null,null,null,null,null,"Comment - please provide succinct statements.",null,null,null,null,null,null,"Result"]
[null,null,"Will existing green space/ecologically important habitat be preserved? ",null,null,"More help (web link)",null,null,{"$f":"IF(U105=\"Add comment >\",\"Add comment >\",\"\")","v":""},null,null,null,null,null,null,null,{"$f":"IF(AND('1. Impacts Questionnaire'!Z112=1,T109=0),Y109,IF(AND('1. Impacts Questionnaire'!Z112=1,T109<>0),\"This is calculated when all questions have been answered\",IF(C102=\"Please complete the Impacts Questionnaire to determine if you are required to complete this section.\",\"Please complete the Impacts Questionnaire to determine if you are required to complete this section.\",\"\")))","v":"Please complete the Impacts Questionnaire to determine if you are required to complete this section."},null,{"$f":"IF(AND('1. Impacts Questionnaire'!Z112=1,T109=0),Y109,IF(AND('1. Impacts Questionnaire'!Z112=1,T109<>0),\"TBC\",\"\"))","v":""},5,{"$f":"IF(T105=1,-1,IF(T105=2,1,IF(T105=3,-1,IF(T105=4,\"Add comment >\",\"\"))))","v":""}]
[null,null,"Has a biodiversity impact assessment been completed?",null,null,null,null,null,{"$f":"IF(U106=\"Add comment >\",\"Add comment >\",\"\")","v":""},null,null,null,null,null,null,null,null,null,null,5,{"$f":"IF(T106=1,0,IF(T106=2,1,IF(T106=3,0,IF(T106=4,\"Add comment >\",\"\"))))","v":""}]
[null,null,"Will a new natural habitat (above net gain criteria) be created?",null,null,"More help (web link)",null,null,{"$f":"IF(U107=\"Add comment >\",\"Add comment >\",\"\")","v":""},null,null,null,null,null,null,null,null,null,null,5,{"$f":"IF(T107=1,-1,IF(T107=2,1,IF(T107=3,0,IF(T107=4,\"Add comment >\",\"\"))))","v":""}]
[null,null,"Does this proposal or decision impact a protected species? ",null,null,"More help (web link)",null,null,{"$f":"IF(U108=\"Add comment >\",\"Add comment >\",\"\")","v":""},null,null,null,null,null,null,null,null,null,null,5,{"$f":"IF(T108=1,-1,IF(T108=2,-1,IF(T108=3,1,IF(T108=4,\"Add comment >\",\"\"))))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"COUNTIF(T105:T108,5)","v":4},{"$f":"IF($C$102=\"✅ Please answer section 3a\",(SUM($U$105:$U$108)),0)","v":0},{"$f":"U109","v":0},{"$f":"COUNT(U105:U108)","v":0},{"$f":"IF(AND(T109=0,C102=\"✅ Please answer section 3a\"),W109,0)","v":0},{"$f":"U109/X109","v":{"$error":"#DIV/0!"}}]
[null,null,"Overall Rating",null,null,null,null,{"$f":"IF(T110<44,SUM(V33:V109)/SUM(X33:X109),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,{"$f":"T109+T99+T91+T84+T74+T61+T45+T33","v":44}]
[]
[]
[null,null,{"$f":"IF(AND(B21=1,B35=1,B46=1,B64=1,B75=1,B85=1,B92=1,B102=1),1,IF(OR(B21=3,B35=3,B46=3,B64=3,B75=3,B85=3,B92=3,B102=3),3,2))","v":3},"Impact Questionnaire: Progress Checklist",null,"Buildings"]
[null,null,{"$f":"IF(OR(F114=\"❌\",F115=\"❌\",F116=\"❌\",F118=\"❌\",F119=\"❌\",F120=\"❌\",F121=\"❌\",F123=\"❌\"),2,1)","v":2},{"$f":"IF(OR(F114=\"❌\",F115=\"❌\",F116=\"❌\",F118=\"❌\",F119=\"❌\",F120=\"❌\",F121=\"❌\",F123=\"❌\"),\"You have not yet fully completed this Carbon Assessment. Please refer to this checklist to determine which section(s) require completion - these are marked with an ❌ and appear in black.\",\"You have fully completed the Carbon Assessment and can now proceed to the Next Steps below.\")","v":"You have not yet fully completed this Carbon Assessment. Please refer to this checklist to determine which section(s) require completion - these are marked with an ❌ and appear in black."},null,{"$f":"IF(OR(B21=1,AND(B21=2,T33=0)),\"✅\",\"❌\")","v":"❌"},"Q.1a"]
[null,null,null,null,null,{"$f":"IF(OR(B35=1,AND(B35=2,T45=0)),\"✅\",\"❌\")","v":"❌"},"Q.1b"]
[null,null,null,null,null,{"$f":"IF(OR(B46=1,AND(B46=2,T61=0)),\"✅\",\"❌\")","v":"❌"},"Q.1c"]
[null,null,null,null,null,"Transport"]
[null,null,null,null,null,{"$f":"IF(OR(B64=1,AND(B64=2,T74=0)),\"✅\",\"❌\")","v":"❌"},"Q.2a"]
[null,null,null,null,null,{"$f":"IF(OR(B75=1,AND(B75=2,T84=0)),\"✅\",\"❌\")","v":"❌"},"Q.2b"]
[null,null,null,null,null,{"$f":"IF(OR(B85=1,AND(B85=2,T91=0)),\"✅\",\"❌\")","v":"❌"},"Q.2c"]
[null,null,null,null,null,{"$f":"IF(OR(B92=1,AND(B92=2,T99=0)),\"✅\",\"❌\")","v":"❌"},"Q.2d"]
[null,null,null,null,null,"Land Use"]
[null,null,null,null,null,{"$f":"IF(OR(B102=1,AND(B102=2,T109=0)),\"✅\",\"❌\")","v":"❌"},"Q.3a"]
[]
[null,null,"Next Steps"]
[null,null,"Click on the relevant link to take you to your next section:"]
[]
[null,null,{"$f":"IF(AND('1. Impacts Questionnaire'!B27=1,OR('1. Impacts Questionnaire'!Z28=1,'1. Impacts Questionnaire'!Z28=2,'1. Impacts Questionnaire'!Z28=4,'1. Impacts Questionnaire'!Z28=5)),\"✅\",\"❌\")","v":"❌"},{"$f":"HYPERLINK(\"#'3. Equalities Assessment'!A1\",\"Step 3: Equalities Impact Assessment\")","v":"Step 3: Equalities Impact Assessment"}]
[]
[null,null,"✅",{"$f":"HYPERLINK(\"#'4. Results'!A1\",\"Step 4: Results\")","v":"Step 4: Results"}]

{"sheet":"3. Equalities Assessment","index":3,"n_rows":70,"n_cols":4,"rows_kept":70,"cut":false,"hidden":false,"merged":[[7,2,7,3],[16,2,16,3],[12,2,12,3],[14,2,14,3],[13,2,13,3],[15,2,15,3]]}
[null,null,{"$f":"IF(AND(D11<>\"If alternative EIA state here\",D11<>\"\"),1,IF(OR(D24<>\"\",D25<>\"\",D26<>\"\",D27<>\"\",D28<>\"\"),2,3))","v":3}]
[null,null,"3. Equalities Impact Assessment"]
[]
[null,{"$f":"IF(ISNUMBER(SEARCH(\"you are not required\",C4)),1,IF(ISNUMBER(SEARCH(\"you are required to complete this Equalities\",C4)),2,\"\"))","v":""},{"$f":"IF(AND('1. Impacts Questionnaire'!B27=1,OR('1. Impacts Questionnaire'!Z28=1,'1. Impacts Questionnaire'!Z28=2,'1. Impacts Questionnaire'!Z28=4,'1. Impacts Questionnaire'!Z28=5)),\"✅ Based on your Impacts Questionnaire response, you are required to complete this Equalities Impact Assessment.\",IF(OR('1. Impacts Questionnaire'!B27=2,'1. Impacts Questionnaire'!Z28=3),\"❌ Based on your Impacts Questionnaire response, you are not required to complete this Equalities Impact Assessment.\",\"Please complete Q1 of the Impacts Questionnaire to determine whether you are required to complete this section.\"))","v":"Please complete Q1 of the Impacts Questionnaire to determine whether you are required to complete this section."}]
[]
[null,null,"Guide"]
[null,null,"This form based on the GMFRS Equalities Impact Assessment."]
[null,null,"Some fields have already been answered based on the responses you provided on the Introductory sheet (marked here with an asterisk). If any of these are incorrect, please edit them on the Introductory form."]
[null,null,"This section is not scored."]
[null,null,null,"Answer:"]
[null,null,"If you have completed an Equalities Impact Assessment for this proposal in another form there is no need to complete this form, but please give details of the EIA completed that will be attached with the proposal:","If alternative EIA state here"]
[]
[null,null,"In accordance with s149(1) of the Equality Act 2010, Greater Manchester Combined Authority (GMCA) and Transport for Greater Manchester (TfGM) are required in the exercise of their functions to have due regard for the need to: \n"]
[null,null,"•   Eliminate unlawful discrimination, harassment and victimisation. \n•   Advance equality of opportunity between persons who share a relevant protected characteristic, and persons who do not share it. \n•   Foster good relations between those who have a relevant protected characteristic and those who don’t. "]
[null,null,"Having due regard to the need to advance equality of opportunity between persons who share a relevant protected characteristic and persons who do not share it involves having due regard, in particular, to the need to: "]
[null,null,"•   Remove or minimise disadvantages suffered by persons who share a relevant protected characteristic that are connected to that characteristic; \n•   Take steps to meet the needs of persons who share a relevant protected characteristic that are different from the needs of the persons who do not share it; \n•   Encourage persons who share a relevant protected characteristic to participate in public life or in any other activity in which participation by such persons is disproportionately low. "]
[null,null,"Having due regard to the need to foster good relations between persons who share a relevant protected characteristic and persons who do not share it involves having due regard, in particular, to the need to tackle prejudice and promote understanding. \n \n“Relevant protected characteristics” are age; disability; gender reassignment; pregnancy and maternity; race; religion or belief; sex; and sexual orientation. \n\nAs part of its compliance with this ongoing duty, TfGM undertakes an Equality Impact Assessment (EqIA) for any significant strategy, project, policy, process or procedure using a standard screening form designed to identify any adverse impacts on members of the above “protected characteristic groups” and to record actions planned to ameliorate any adverse impacts, should any be identified.   "]
[]
[null,null,"Section 1"]
[null,null,"Name of policy / initiative / Service to be impact assessed*",{"$f":"IF(START!D9<>\"\",START!D9,\"\")","v":""}]
[null,null,"Corporate objective being addressed*",{"$f":"IF(START!D13<>\"\",START!D13,\"\")","v":""}]
[null,null,"Department / function carrying out the assessment*",{"$f":"IF(START!D14<>\"\",START!D14,\"\")","v":""}]
[null,null,"Who is responsible for the implementation of the policy / initiative / service? (function head /department manager)*",{"$f":"IF(START!D15<>\"\",START!D15,\"\")","v":""}]
[null,null,"Who is involved in the impact assessment?"]
[null,null,"What are the aims / objectives of the policy / initiative / service?"]
[null,null,"Who is intended to benefit from the policy?"]
[null,null,"What are the main outcomes of the policy (this is key to being able to identify what monitoring is needed)?"]
[null,null,"Is the policy for external or internal purposes?"]
[null,null,"Are other organisations involved in the delivery? "]
[null,null,"If yes please state who:"]
[null,null,"What information/ past experience do we have i.e. a similar initiative and what did this information tell us? (info can be demographic data i.e. census findings, research findings, comparisons between similar policies in our Service and other Services, survey data, equality monitoring data, ad hoc data gathering exercises) "]
[null,null,"How will information be collected regarding the impact of the policy /initiative /service/ employment policy etc?"]
[null,null,"Has a search of the internet revealed an impact assessment conducted by other Fire and Rescue Services or local authorities of a similar policy/initiative?"]
[null,null,"If yes – is it possible to adapt / incorporate findings"]
[null,null,"Date of Policy Review*",{"$f":"IF(START!D11<>\"\",START!D11,\"\")","v":""}]
[]
[null,null,"Section 2","Impacts Identified"]
[null,null,"Age "]
[null,null,"Disability"]
[null,null,"Gender "]
[null,null,"Race "]
[null,null,"Religion and Belief (including no belief)"]
[null,null,"Sexual Orientation"]
[null,null,"Transgender"]
[null,null,"Pregnancy and Maternity"]
[null,null,"Marriage and Civil Partnership"]
[null,null,"People experiencing or at risk of socio-economic disadvantage (including those with lower income or carers, ex-offenders and armed forces veterans)"]
[]
[null,null,"Section 2: Consultation & Engagement"]
[null,null,"Involved","Consulted"]
[null,null,"Include who was involved","Include who was involved"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"To Export this Form: File>>Export>>Create PDF/XPS"]
[]
[]
[null,null,"Next steps"]
[]
[null,null,{"$f":"HYPERLINK(\"#'4. Results'!A1\",\"Step 4: Results\")","v":"Step 4: Results"}]

{"sheet":"4. Results","index":4,"n_rows":79,"n_cols":16,"rows_kept":79,"cut":false,"hidden":false,"merged":[[71,2,71,4],[77,2,77,4],[4,2,4,4],[5,2,5,4],[6,2,6,4],[7,2,7,4],[8,2,8,4],[53,2,53,4],[68,2,68,4],[69,2,69,4],[33,2,33,3],[70,2,70,4],[61,2,62,4],[64,2,65,4],[57,2,57,4],[20,2,20,4]]}
[]
[null,null,"4. Results"]
[]
[null,null,"Results, interpretation and use"]
[null,null,"This tool allows users to self-assess the impact of decisions against GMCA policy frameworks. Decisions may not always lead to universally positive outcomes. Here, the term ‘impact’ is used to capture both positive and negative outcomes of a decision."]
[null,null,"Impacts Questionnaire Result\nThe results give a RAG (red, amber, green) rating indicating whether expected impacts align with GMCA policy goals. An explanatory note/justification should be added to the overall rating result for each relevant impact area. For ease, the Justification/Mitigation column in the results tables contain all the comments that were provided whilst completing the questionnaires. These comments should be edited to provide useful information for decision-makers. They will be public and should be in plain English with references made to the full Decision Report. Please try to keep each comment box to under 100 words if possible."]
[null,null,"Carbon Assessment Result\nThe Carbon Assessment results indicate the degree to which best practice is being adopted for minimising carbon emissions with an associated colour rating (green, blue, brown and black). Again, comments pulled through from the questionnaire should be edited to ensure the information is useful for decision-makers."]
[null,null,"Recommendation Box\nIn this box, you should enter the recommendation that will be included in the paper. This recommendation should offer a very brief summary of the results of Decision Support Tool and must refer to any important caveats, mitigation measures, and negative impacts that decision-makers should note. For example noting whether postive/negative impacts are conditional on other policies or measures. \n \nThe text you provide in the Recommendation Box should also be copied into the Recommendations section of the paper submitted for decision itself where it says “The GMCA is requested to”. We therefore suggest you start your comments with words that call action such as, e.g., “agree”, “note”, “approve”."]
[null,null,"Exporting the result to your paper\nAn export button is provided below the results tables which will export these to a Word document. In addition, you should include the text you have added to the Recommendation Box in the relevant section within the main body of your paper. "]
[]
[null,null,"Progress checklist"]
[null,null,"Please refer to the following checklist to ensure all sections have been completed before proceeding to the results tables:"]
[]
[null,null,"START",null,{"$f":"IF(AND(START!D9<>\"\",START!D10<>\"\",START!D11<>\"\",START!D16<>\"\"),\"✅ The overview information on the START page has been completed.\",\"❌ The overview information on the START page has not been fully completed.\")","v":"❌ The overview information on the START page has not been fully completed."}]
[null,null,"1. Impacts Questionnaire",null,{"$f":"IF('1. Impacts Questionnaire'!B132=2,\"❌ The Impacts Questionnaire has not been fully completed.\",\"✅ The Impacts Questionnaire has been completed.\")","v":"❌ The Impacts Questionnaire has not been fully completed."}]
[null,null,"2. Carbon Assessment",null,{"$f":"IF('2. Carbon Assessment'!C113=1,\"✅ Based on your responses you are not required to complete the Carbon Assessment.\",IF(AND('2. Carbon Assessment'!C113=2,'2. Carbon Assessment'!C114=2),\"❌ The Carbon Assessment has not been fully completed.\",IF('2. Carbon Assessment'!C113=3,\"❌ Please complete the Impacts Questionnaire to determine which sections of the Carbon Assessment you are required to complete.\",\"✅ The Carbon Assessment has been completed.\")))","v":"❌ Please complete the Impacts Questionnaire to determine which sections of the Carbon Assessment you are required to complete."}]
[null,null,"3. Equalities Assessment",null,{"$f":"IF('3. Equalities Assessment'!B4=1,\"✅ Based on your responses you are not required to complete the Equalities Assessment.\",IF(AND('3. Equalities Assessment'!B4=2,'3. Equalities Assessment'!C1=3),\"❌ Please ensure you have completed the Equalities Assessment form.\",IF(AND('1. Impacts Questionnaire'!B27=1,'1. Impacts Questionnaire'!Z28=6),\"❌ Please complete the Impacts Questionnaire to determine if you are required to fill out the Equalities Assessment.\",\"✅ You have filled in the Equalities Assessment\")))","v":"❌ Please complete the Impacts Questionnaire to determine if you are required to fill out the Equalities Assessment."}]
[]
[]
[null,null,"Recommendation - Key points for decision-makers",null,null,"Word Count"]
[null,null,"Insert text",null,null,{"$f":"IF(LEN(TRIM(C21))=0,0,LEN(TRIM(C21))-LEN(SUBSTITUTE(C21,\" \",\"\"))+1)","v":2}]
[]
[null,null,"Impacts Questionnaire"]
[null,null,"Impact Indicator","Result","Justification/Mitigation","Word Count"]
[null,null,"Equality and Inclusion",{"$f":"IF(OR('1. Impacts Questionnaire'!B27=2,AND('1. Impacts Questionnaire'!B27=1,'1. Impacts Questionnaire'!Z33=0)),'1. Impacts Questionnaire'!V28,\"N/A\")","v":"N/A"},null,{"$f":"IF(LEN(TRIM(E25))=0,0,LEN(TRIM(E25))-LEN(SUBSTITUTE(E25,\" \",\"\"))+1)","v":0},null,null,null,null,null,null,null,null,null,{"$f":"IF(OR('1. Impacts Questionnaire'!Z28=3,'1. Impacts Questionnaire'!Z28=6),0,2)","v":0}]
[null,null,"Health",{"$f":"IF(OR('1. Impacts Questionnaire'!B38=2,AND('1. Impacts Questionnaire'!B38=1,'1. Impacts Questionnaire'!Z45=0)),'1. Impacts Questionnaire'!V39,\"N/A\")","v":"N/A"},null,0]
[null,null,"Resilience and Adaptation",{"$f":"IF(OR('1. Impacts Questionnaire'!B50=2,AND('1. Impacts Questionnaire'!B50=1,'1. Impacts Questionnaire'!Z56=0)),'1. Impacts Questionnaire'!V51,\"N/A\")","v":"N/A"},null,0]
[null,null,"Housing",{"$f":"IF(OR('1. Impacts Questionnaire'!B61=2,AND('1. Impacts Questionnaire'!B61=1,'1. Impacts Questionnaire'!Z68=0)),'1. Impacts Questionnaire'!V62,\"N/A\")","v":"N/A"},null,0]
[null,null,"Economy",{"$f":"IF(OR('1. Impacts Questionnaire'!B73=2,AND('1. Impacts Questionnaire'!B73=1,'1. Impacts Questionnaire'!Z82=0)),'1. Impacts Questionnaire'!V74,\"N/A\")","v":"N/A"},null,0]
[null,null,"Mobility and Connectivity",{"$f":"IF(OR('1. Impacts Questionnaire'!B87=2,AND('1. Impacts Questionnaire'!B87=1,'1. Impacts Questionnaire'!Z99=0)),'1. Impacts Questionnaire'!V88,\"N/A\")","v":"N/A"},null,0]
[null,null,"Carbon, Nature and Environment",{"$f":"IF(OR('1. Impacts Questionnaire'!B104=2,AND('1. Impacts Questionnaire'!B104=1,'1. Impacts Questionnaire'!Z114=0)),'1. Impacts Questionnaire'!V105,\"N/A\")","v":"N/A"},null,0,null,null,null,null,null,null,null,null,null,{"$f":"IF('1. Impacts Questionnaire'!D149=\"✅\",1,0)","v":0}]
[null,null,"Consumption and Production",{"$f":"IF(OR('1. Impacts Questionnaire'!B119=2,AND('1. Impacts Questionnaire'!B119=1,'1. Impacts Questionnaire'!Z125=0)),'1. Impacts Questionnaire'!V120,\"N/A\")","v":"N/A"},null,0,null,null,null,null,null,null,null,null,null,{"$f":"P25+P31","v":0}]
[]
[null,null,"Contribution to achieving the GM Carbon Neutral 2038 target"]
[null,null,"Further Assessment(s):",null,{"$f":"IF(P32=0,\"N/A\",IF(P32=1,\"Carbon Assessment\",IF(P32=2,\"Equalities Impact Assessment\",IF(P32=3,\"Equalities Impact Assessment and Carbon Assessment\"))))","v":"N/A"}]
[]
[]
[]
[null,null,"Carbon Assessment"]
[null,null,"Overall Score",{"$f":"'2. Carbon Assessment'!H110","v":""}]
[]
[null,null,"Buildings","Result","Justification/Mitigation","Word Count"]
[null,null,"New Build residential",{"$f":"IF('2. Carbon Assessment'!B21=1,\"N/A\",IF('2. Carbon Assessment'!B21=3,\"TBC\",'2. Carbon Assessment'!S24))","v":"TBC"},null,{"$f":"IF(LEN(TRIM(E43))=0,0,LEN(TRIM(E43))-LEN(SUBSTITUTE(E43,\" \",\"\"))+1)","v":0}]
[null,null,"Residential building(s) renovation/maintenance",{"$f":"IF('2. Carbon Assessment'!B35=1,\"N/A\",IF('2. Carbon Assessment'!B35=3,\"TBC\",'2. Carbon Assessment'!S38))","v":"TBC"},null,{"$f":"IF(LEN(TRIM(E44))=0,0,LEN(TRIM(E44))-LEN(SUBSTITUTE(E44,\" \",\"\"))+1)","v":0}]
[null,null,"New build non-residential (including public) buildings",{"$f":"IF('2. Carbon Assessment'!B46=1,\"N/A\",IF('2. Carbon Assessment'!B46=3,\"TBC\",'2. Carbon Assessment'!S49))","v":"TBC"},null,{"$f":"IF(LEN(TRIM(E45))=0,0,LEN(TRIM(E45))-LEN(SUBSTITUTE(E45,\" \",\"\"))+1)","v":0}]
[null,null,"Transport"]
[null,null,"Active travel and public transport",{"$f":"IF('2. Carbon Assessment'!B64=1,\"N/A\",IF('2. Carbon Assessment'!B64=3,\"TBC\",'2. Carbon Assessment'!S67))","v":"TBC"},null,{"$f":"IF(LEN(TRIM(E47))=0,0,LEN(TRIM(E47))-LEN(SUBSTITUTE(E47,\" \",\"\"))+1)","v":0}]
[null,null,"Roads, Parking and Vehicle Access",{"$f":"IF('2. Carbon Assessment'!B75=1,\"N/A\",IF('2. Carbon Assessment'!B75=3,\"TBC\",'2. Carbon Assessment'!S78))","v":"TBC"},null,{"$f":"IF(LEN(TRIM(E48))=0,0,LEN(TRIM(E48))-LEN(SUBSTITUTE(E48,\" \",\"\"))+1)","v":0}]
[null,null,"Access to amenities",{"$f":"IF('2. Carbon Assessment'!B85=1,\"N/A\",IF('2. Carbon Assessment'!B85=3,\"TBC\",'2. Carbon Assessment'!S88))","v":"TBC"},null,{"$f":"IF(LEN(TRIM(E49))=0,0,LEN(TRIM(E49))-LEN(SUBSTITUTE(E49,\" \",\"\"))+1)","v":0}]
[null,null,"Vehicle procurement",{"$f":"IF('2. Carbon Assessment'!B92=1,\"N/A\",IF('2. Carbon Assessment'!B92=3,\"TBC\",'2. Carbon Assessment'!S95))","v":"TBC"},null,{"$f":"IF(LEN(TRIM(E50))=0,0,LEN(TRIM(E50))-LEN(SUBSTITUTE(E50,\" \",\"\"))+1)","v":0}]
[null,null,"Land Use"]
[null,null,"Land use",{"$f":"IF('2. Carbon Assessment'!B102=1,\"N/A\",IF('2. Carbon Assessment'!B102=3,\"TBC\",'2. Carbon Assessment'!S105))","v":"TBC"},null,{"$f":"IF(LEN(TRIM(E52))=0,0,LEN(TRIM(E52))-LEN(SUBSTITUTE(E52,\" \",\"\"))+1)","v":0}]
[]
[]
[null,null,"Exporting options"]
[]
[null,null,"Export tables to Word document"]
[null,null,"1. When clicked, the button below will launch a new Word document and paste the above results tables in. You can then save this new document and/or copy and paste the tables elsewhere as required."]
[]
[]
[]
[null,null,"2. Once you have exported the results table to Word, please copy and paste the table into your GMCA meeting paper at the location specified in the paper template  and submit the final paper to the GMCA Secretariat in the usual way."]
[]
[]
[null,null,"3. Please then save the whole Excel spreadsheet using “File….Save As….[Title of Paper]” in an appropriate location for future editing and forward a copy of the whole Excel file to the Secretariat for archiving."]
[]
[]
[null,null,"Manually exporting"]
[null,null,"1. If you would like to export any other parts of this tool, you can do it manually. It is recommended that you copy and paste as images to avoid any problems associated with pasting the form controls (drop downs and tick boxes) into other documents. "]
[null,null,"2. To do this, first highlight the table or area of a table you would like to copy."]
[null,null,"3. Then using options at the top of the screen click on the Home tab. Then in the Clipboard group, click the small down arrow next to Copy, then select Copy as Picture."]
[null,null,"3. A box of options will appear, click OK to select the default options. Then open your Word (or other) document and press CTRL+V to paste. Alternatively right click in the document and select Paste from the menu. It will paste as a picture and you can resize it to suit your document."]
[]
[null,null,"Full PDF output"]
[null,null,"1. The entirety of this workbook can be exported as a PDF file."]
[null,null,"2. Click File > Print."]
[null,null,"3. Under Printers select 'Microsoft Print to PDF'."]
[null,null,"4. Under Settings select 'Print Entire Workbook' (or leave it as Active Sheet if you just want one of the worksheets)."]
[null,null,"5. Select Print and you will be prompted to choose where you would like to save your PDF."]

{"sheet":"Refs","index":5,"n_rows":13,"n_cols":28,"rows_kept":13,"cut":false,"hidden":true,"merged":[]}
[]
["Long term or significant positive",null,"Yes",null,"Don't know",null,"Don't know"]
["Short term or limited positive",null,"No",null,"Yes",null,"Yes"]
["No discernible impact",null,null,null,"No",null,"No"]
["Short term or limited negative",null,null,null,"Not Applicable"]
["Long lasting or significant negative"]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"No associated carbon impacts expected.",null,"High standard in terms of practice and awareness on carbon.",null,"Mostly best practice with a good level of awareness on carbon.",null,"Partially meets best practice/ awareness, significant room to improve.",null,"Does not meet best practice and/ or insufficient awareness of carbon impacts."]
[]
[null,null,null,null,null,null,null,"G","Positive impacts overall, whether long or short term.","A","Mix of positive and negative impacts. Trade-offs to consider.","R","Mostly negative, with at least one positive aspect. Trade-offs to consider.","RR","Negative impacts overall. "]