{"text_format":"1","workbook":"xlsx","n_sheets":9,"sheets":["Impact Assessment - START","Control Sheet","Sheet2","Sheet3","Sheet5","Sustainability Assessment","Equality Impact Assessment","Carbon Assessment","Results"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":1,"comments":0,"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":"Impact Assessment - START","index":0,"n_rows":37,"n_cols":11,"rows_kept":37,"cut":false,"hidden":false,"merged":[[4,2,6,15],[24,2,24,15],[25,2,25,15],[29,2,29,15],[26,2,26,15],[27,2,27,15],[28,2,28,15],[13,2,13,15],[17,2,17,15],[18,2,18,15],[21,2,21,15],[9,2,9,15],[8,2,8,15],[19,2,19,15],[10,2,10,15],[12,2,12,15],[34,2,34,15],[35,2,35,15],[33,2,33,15],[30,2,30,15],[31,2,31,15],[16,2,16,15],[15,2,15,15],[11,2,11,15],[14,2,14,15],[32,2,32,15],[20,2,20,15],[22,2,22,15]]}
[]
[]
[]
[]
[null,null,"Local authorities are facing significant challenges around rising costs and increased demand for public services. If we are to continue to meet the needs of residents we must make good decisions, practice effective project management and commit to fair and sustainable ways of working.  This assessment has been developed to ensure that risks and benefits are being considered across all council activity and how this will affect our people, place and the planet."]
[]
[]
[]
[null,null,"Key considerations when completing the impact assessment"]
[null,null,"This assessment must be completed for new or changes to existing proposals (including: policies, projects, initiatives or services)"]
[null,null,"It must be completed when you are first thinking about your proposal to help shape it - not at the end of the process!"]
[null,null,"It is recommended that you discuss and complete the assessment with other colleagues and peers, where possible, to get a broader viewpoint and to draw upon different professional expertise and lived experience."]
[null,null,"It is a live document and should be monitored and updated where new impacts are identified during the scoping of your proposal and throughout its implementation. "]
[null,null,"It is good practice to carry out an assessment for all council activity/projects that will impact our people, places or the planet. It is mandatory to complete the sustainability assessment for proposals that require an Executive Decision (any decisions going to Cabinet, Health and Wellbeing Board, Scrutiny Committees or Township Committees)"]
[null,null,"If it is a Key Decision you will need to complete the relevant paperwork and publish the item 28 days before the Cabinet meeting. "]
[null,null,"It is important that you complete all 3 parts of the assessment - Sustainability, Equality and Carbon. "]
[null,null,"You must highlight your findings in your governance report. Sustainability and Carbon impacts (both risks and benefits) should be included in the 'Sustainability Impact' section and Equality Impacts (both risks and benefits) should be included in the 'Other considerations (corporate priorities, risks)' section of the report template"]
[null,null,"You must upload the results table with  your governance report"]
[null,null,"The Corporate Policy Team will sign off the sustainability assessment as part of the ModGov process. Please send a copy of the full assessment to policy@rochdale.gov.uk"]
[null,null,"When completing the assessment it is NOT acceptable to state there are no impacts at all. "]
[null,null,"It is important that you state what data, intelligence or consultation feedback you have used to shape your proposal and to make your judgement about any possible impacts "]
[null,null,"A glossary of terms has been created to support your understanding of language used. It can found on the Climate Change and Sustainability intranet page (link below):"]
[null,null,"http://council.rochdale.local/neighbourhoods/CorporatePolicy/Pages/Climate-Change-and-Sustainability.aspx"]
[]
[null,null,"Step by step guide"]
[null,null,"Click on the 'CONTROL SHEET TAB' and complete the table"]
[null,null,"Click on the 'SUSTAINABILITY ASSESSMENT TAB' and work your way through each Sustainable Development Goal (SDG)"]
[null,null,"Read the questions within each SDG and decide if any of them are relevant to your proposal. If none of them feel relevant, select no. This will automatically blank out that SDG."]
[null,null,"If any of the SDG questions feel relevant select YES and proceed to give an impact rating for each question. "]
[null,null,"Click on the cell in the 'IMPACT RATING' column and select an answer from the drop down menu.  Impact rating descriptions can be found at the top of the worksheet. A RAG rating will automatically be generated for the impact selected. Do not leave a blank cell or overwrite. An overall RAG rating will be generated for each SDG and will atomically be populated in a table on the results tab."]
[null,null,"The next step is to click on the 'EQUALIT Y IMPACT ASSESSEMENT TAB'"]
[null,null,"You MUST consider the impacts for all of the Protected Characteristics. Click on the cells for each of the 3 questions, and select an answer from the drop down menu.  Impact rating descriptions can be found at the top of the worksheet. A RAG rating will automatically be generated for the impact selected. Do not leave a blank cell or overwrite. An overall RAG rating will be generated for each Protected Characteristic and will automatically be populated in a table on the results tab."]
[null,null,"The next step is to click on the 'CARBON ASSESSMENT TAB' "]
[null,null,"You MUST consider the impact on carbon emissions. Click on the cells for each of the different types of emissions (scope 1,2 and 3)  and select an answer from the drop down menu.  Impact rating descriptions can be found at the top of the worksheet. A RAG rating will automatically be generated for the impact selected. Do not leave a blank cell or overwrite. An overall RAG rating will be generated and will automatically be populated in a table on the results tab."]
[null,null,"When you have completed the SDG assessment, go to the ' RESULTS TAB'. You will notice that the overall RAG ratings have been pulled through into the table of results. In the comments section describe the positive and negative impacts that you have identified. Where you have identified negative impacts you will need to explain how these could be avoided or mitigated. "]
[null,null,"Once you are satisfied that you have a completed assessment with impact ratings and relevant commentary that explains  the rating, click on the 'EXPORT BUTTON' which will export your table of results to a word document. Save that word document to use with your governance report"]
[null,null,"If you require support please contact the Corporate Policy Team at ",null,null,null,null,null,null,null,"policy@rochdale.gov.uk"]

{"sheet":"Control Sheet","index":1,"n_rows":24,"n_cols":11,"rows_kept":24,"cut":false,"hidden":false,"merged":[[19,2,19,9],[20,2,20,9],[21,2,21,9],[22,2,22,9],[23,2,23,9],[18,2,18,9],[11,2,11,9],[12,2,12,9],[13,2,13,9],[14,2,14,9],[16,2,16,9],[15,2,15,9],[5,2,5,9],[6,2,6,9],[7,2,7,9],[10,2,10,9],[17,2,17,9],[8,2,8,9],[9,2,9,9]]}
[]
[]
[]
[]
[]
[null,null,"What is the name of the proposal? ",null,null,null,null,null,null,null,"Susainability impact assessment in relation to the mechanically propelled vehicle prohibition of the proposed Borough-Wide Public Spaces Protection Order"]
[null,null,"Is it new or a change to something existing?",null,null,null,null,null,null,null,"New"]
[null,null,"Which area of the Council does this relate to?",null,null,null,null,null,null,null,"Public Health"]
[null,null,"If the proposal is system wide, which partners and organisations are involved?",null,null,null,null,null,null,null,"Rochdale Borough Council, Greater Manchester Police"]
[null,null,"Which team/service/partnership is completing this assessment?",null,null,null,null,null,null,null,"Community Safety team"]
[null,null,"What date was the assessment first carried out?",null,null,null,null,null,null,null,"8th January 2024"]
[null,null,"What date was the assessment last updated?",null,null,null,null,null,null,null,"13th February 2024"]
[null,null,"What is the name of the person completing the assessment?",null,null,null,null,null,null,null,"Charles Cordingley "]
[null,null,"What is the job title of the person completing the assessment?",null,null,null,null,null,null,null,"Community Safety Officer"]
[null,null,"What is the email address of the person completing the assessment?",null,null,null,null,null,null,null,"charles.cordingley@rochdale.gov.uk"]
[null,null,"What is the contact number for the person completing the assessment?",null,null,null,null,null,null,null,"01706 924984"]
[null,null,"Who else has been involved in completing the assessment?",null,null,null,null,null,null,null,"Helen Walton "]
[null,null,"What are the aims and objectives of the proposal?",null,null,null,null,null,null,null,"To implement a Borough-wide Public Spaces Protection Order in relation to the anti-social usage of Mechanically propelled vehicles and alcohol (sustainability assessment for the alcohol prohibition completed seperately) "]
[null,null,"Who will be affected by the proposal?",null,null,null,null,null,null,null,"Please see assessment "]
[null,null,"Have you or will you inform those affected by your proposal? (reference the methods that were used/will be used)",null,null,null,null,null,null,null,"Thorough public consultation will be undertaken in which a variety different groups will be consulted with"]
[null,null,"What is the cost value of this proposal?",null,null,null,null,null,null,null,"Not yet confirmed, different cost implications can be seen within report to cabinet "]
[null,null,"Is this proposal a key decision? (if yes, reference the process you have followed or will follow to gain approval)",null,null,null,null,null,null,null,"Yes, key decision notice to be submitted prior to informal cabinet meeting"]
[null,null,"What data and intelligence have you used to inform the proposal and this assessment? (reference any data sources or include links to the data)",null,null,null,null,null,null,null,"Police data which will be included in report to cabinet"]
[null,null,"What engagement and consultation have you or will you carry out to inform the proposal and this assessment? (reference the different stakeholders and the methods that were used/will be used)",null,null,null,null,null,null,null,"Public consultation will take place across the borough. Methods of consultation will include an online questionaire, public meetings, social media etc. "]

{"sheet":"Sheet2","index":2,"n_rows":102,"n_cols":19,"rows_kept":102,"cut":false,"hidden":true,"merged":[]}
[]
[]
[]
[null,null,"Long term or significant positive",1,null,null,"Positive",1,null,2,null,null,null,null,null,null,1,0.01,"R"]
[null,null,"Short term positive",2,null,null,"Both positive and negative",2,null,0,null,null,null,null,null,null,2,0.02,"R"]
[null,null,"None",3,null,null,"Neutral",3,null,0,null,null,null,null,null,null,3,0.03,"R"]
[null,null,"Short term negative",4,null,null,"Negative",4,null,1,null,null,null,null,null,null,4,0.04,"R"]
[null,null,"Long term or significant negative",5,null,null,"Unknown",4,null,1,null,null,null,null,null,null,5,0.05,"R"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6,0.06,"R"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,7,7.0000000000000007E-2,"R"]
[null,null,"wind, solar, hydro, geo-thermal, hydrogen, biomass",null,null,null,null,null,null,null,null,null,null,null,null,null,8,0.08,"R"]
[null,null,null,null,null,null,"Positive",1,null,2,null,null,null,null,null,null,9,0.09,"R"]
[null,null,"Wind",null,null,null,"Neutral",3,null,0,null,null,null,null,null,null,10,0.1,"R"]
[null,null,"Solar",null,null,null,"Negative",4,null,1,null,null,null,null,null,null,11,0.11,"R"]
[null,null,"Hydro",null,null,null,"Unknown",4,null,1,null,null,null,null,null,null,12,0.12,"R"]
[null,null,"Geo-thermal",null,null,null,null,null,null,null,null,null,null,null,null,null,13,0.13,"R"]
[null,null,"Hydrogen",null,null,null,null,null,null,null,null,null,null,null,null,null,14,0.14000000000000001,"R"]
[null,null,"Biomass",null,null,null,null,null,null,null,null,null,null,null,null,null,15,0.15,"R"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,16,0.16,"R"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,17,0.17,"R"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,18,0.18,"R"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,19,0.19,"R"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,20,0.2,"R"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,21,0.21,"R"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,22,0.22,"R"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,23,0.23,"R"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,24,0.24,"R"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,25,0.25,"R"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,26,0.26,"R"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,27,0.27,"R"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,28,0.28000000000000003,"R"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,29,0.28999999999999998,"R"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,30,0.3,"R"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,31,0.31,"R"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,32,0.32,"R"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,33,0.33,"R"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,34,0.34,"R"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,35,0.35,"R"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,36,0.36,"R"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,37,0.37,"R"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,38,0.38,"R"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,39,0.39,"R"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,40,0.4,"R"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,41,0.41,"R"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,42,0.42,"R"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,43,0.43,"R"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,44,0.44,"R"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,45,0.45,"R"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,46,0.46,"R"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,47,0.47,"R"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,48,0.48,"R"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,49,0.49,"R"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,50,0.5,"R"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,51,0.51,"R"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,52,0.52,"R"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,53,0.53,"R"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,54,0.54,"R"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,55,0.55000000000000004,"R"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,56,0.56000000000000005,"R"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,57,0.56999999999999995,"R"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,58,0.57999999999999996,"R"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,59,0.59,"R"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,60,0.6,"R"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,61,0.61,"R"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,62,0.62,"R"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,63,0.63,"R"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,64,0.64,"R"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,65,0.65,"R"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,66,0.66,"R"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,67,0.67,"R"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,68,0.68,"R"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,69,0.69,"R"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,70,0.7,"R"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,71,0.71,"R"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,72,0.72,"R"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,73,0.73,"R"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,74,0.74,"R"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.75,"A"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.76,"A"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.77,"A"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.78,"A"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.79,"A"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.8,"A"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.81,"A"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.82,"A"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.83,"A"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.84,"A"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.85,"A"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.86,"A"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.87,"A"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.88,"A"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.89,"A"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.9,"A"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.91,"A"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.92,"A"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.93,"A"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.94,"A"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.95,"A"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.96,"A"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.97,"A"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.98,"A"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.99,"A"]

{"sheet":"Sheet3","index":3,"n_rows":5,"n_cols":4,"rows_kept":5,"cut":false,"hidden":true,"merged":[]}
[]
[]
[]
[null,null,null,"Yes"]
[null,null,null,"No"]

{"sheet":"Sheet5","index":4,"n_rows":23,"n_cols":8,"rows_kept":23,"cut":false,"hidden":true,"merged":[]}
[]
[]
[null,null,"Yes",null,null,"A-B",null,"Energiesprong New Build, Passivhaus Classic/Passivhaus, Low Energy Building/ Passivhaus Plus/Passivhaus Premium"]
[null,null,"No",null,null,"C-D",null,"AECB Standard, London Plan, LETI Net Zero Operational Carbon standard"]
[null,null,"Not applicable",null,null,"E-F",null,"SAP 2012/ Part L - Current English building regulations standard, SAP 10.1 / Part L – proposed improvement in English standards"]
[null,null,null,null,null,"G",null,"None specified"]
[null,null,null,null,null,"Not applicable",null,"Not applicable"]
[]
[null,null,null,null,null,"Reduced vehicles"]
[null,null,null,null,null,"Increased vehicles"]
[null,null,null,null,null,"Not applicable",null,"Passivhaus for non-domestic buildings"]
[null,null,"Adult Care",null,null,null,null,"Publicly Available Specification 2038: 2021"]
[null,null,"Children's Services",null,null,null,null,"Government’s Minimum Energy Efficiency Standard (MEES)"]
[null,null,"Economy",null,null,null,null,"Below Minimum Energy Efficiency Standard (MEES)"]
[null,null,"Neighbourhoods",null,null,null,null,"Not applicable"]
[null,null,"Resources"]
[null,null,"Public Health",null,null,null,null,"Rapid charge (50kW+)"]
[null,null,"Multiple directorates",null,null,null,null,"Fast charge (7-22kW)"]
[null,null,null,null,null,null,null,"Slow charge (3kW – 6kW)"]
[null,null,null,null,null,null,null,"Not applicable"]
[]
[null,null,"New"]
[null,null,"Change to existing"]

{"sheet":"Sustainability Assessment","index":5,"n_rows":376,"n_cols":22,"rows_kept":376,"cut":false,"hidden":false,"merged":[[357,16,358,16],[357,17,358,17],[359,4,360,11],[359,12,360,13],[359,14,360,14],[361,4,362,11],[361,12,362,13],[361,14,362,14],[363,4,364,11],[363,12,364,13],[363,14,364,14],[357,4,358,11],[357,12,358,13],[357,14,358,14],[371,4,372,11],[371,12,372,13],[371,14,372,14],[367,4,368,11],[367,12,368,13],[367,14,368,14],[369,4,370,11],[369,12,370,13],[369,14,370,14],[365,4,366,11],[365,12,366,13],[365,14,366,14],[344,4,345,11],[344,12,345,13],[344,14,345,14],[346,4,347,11],[346,12,347,13],[346,14,347,14],[351,3,353,5],[352,6,353,6],[355,4,356,11],[355,12,356,13],[355,14,356,14],[338,4,339,11],[338,12,339,13],[338,14,339,14],[340,4,341,11],[340,12,341,13],[340,14,341,14],[342,4,343,11],[342,12,343,13],[342,14,343,14],[330,17,331,17],[332,4,333,11],[332,12,333,13],[332,14,333,14],[334,4,335,11],[334,12,335,13],[334,14,335,14],[336,4,337,11],[336,12,337,13],[336,14,337,14],[324,3,326,5],[325,6,326,6],[328,4,329,11],[328,12,329,13],[328,14,329,14],[330,4,331,11],[330,12,331,13],[330,14,331,14],[330,16,331,16],[315,4,316,11],[315,12,316,13],[315,14,316,14],[317,4,318,11],[317,12,318,13],[317,14,318,14],[319,4,320,11],[319,12,320,13],[319,14,320,14],[309,4,310,11],[309,12,310,13],[309,14,310,14],[311,4,312,11],[311,12,312,13],[311,14,312,14],[311,16,312,16],[311,17,312,17],[313,4,314,11],[313,12,314,13],[313,14,314,14],[298,4,299,11],[298,12,299,13],[298,14,299,14],[298,16,299,16],[298,17,299,17],[300,4,301,11],[300,12,301,13],[300,14,301,14],[305,3,307,5],[306,6,307,6],[285,17,286,17],[287,4,288,11],[287,12,288,13],[287,14,288,14],[292,3,294,5],[293,6,294,6],[296,4,297,11],[296,12,297,13],[296,14,297,14],[279,3,281,5],[280,6,281,6],[283,4,284,11],[283,12,284,13],[283,14,284,14],[285,4,286,11],[285,12,286,13],[285,14,286,14],[285,16,286,16],[270,4,271,11],[270,12,271,13],[270,14,271,14],[272,4,273,11],[272,12,273,13],[272,14,273,14],[274,4,275,11],[274,12,275,13],[274,14,275,14],[264,4,265,11],[264,12,265,13],[264,14,265,14],[266,4,267,11],[266,12,267,13],[266,14,267,14],[268,4,269,11],[268,12,269,13],[268,14,269,14],[258,4,259,11],[258,12,259,13],[258,14,259,14],[260,4,261,11],[260,12,261,13],[260,14,261,14],[262,4,263,11],[262,12,263,13],[262,14,263,14],[250,16,251,16],[250,17,251,17],[252,4,253,11],[252,12,253,13],[252,14,253,14],[254,4,255,11],[254,12,255,13],[254,14,255,14],[256,4,257,11],[256,12,257,13],[256,14,257,14],[239,4,240,11],[239,12,240,13],[239,14,240,14],[244,3,246,5],[245,6,246,6],[248,4,249,11],[248,12,249,13],[248,14,249,14],[250,4,251,11],[250,12,251,13],[250,14,251,14],[233,4,234,11],[233,12,234,13],[233,14,234,14],[235,4,236,11],[235,12,236,13],[235,14,236,14],[237,4,238,11],[237,12,238,13],[237,14,238,14],[227,4,228,11],[227,12,228,13],[227,14,228,14],[229,4,230,11],[229,12,230,13],[229,14,230,14],[231,4,232,11],[231,12,232,13],[231,14,232,14],[221,4,222,11],[221,12,222,13],[221,14,222,14],[223,4,224,11],[223,12,224,13],[223,14,224,14],[225,4,226,11],[225,12,226,13],[225,14,226,14],[215,4,216,11],[215,12,216,13],[215,14,216,14],[217,4,218,11],[217,12,218,13],[217,14,218,14],[219,4,220,11],[219,12,220,13],[219,14,220,14],[209,4,210,11],[209,12,210,13],[209,14,210,14],[211,4,212,11],[211,12,212,13],[211,14,212,14],[211,16,212,16],[211,17,212,17],[213,4,214,11],[213,12,214,13],[213,14,214,14],[196,17,197,17],[198,4,199,11],[198,12,199,13],[198,14,199,14],[200,4,201,11],[200,12,201,13],[200,14,201,14],[205,3,207,5],[206,6,207,6],[190,3,192,5],[191,6,192,6],[194,4,195,11],[194,12,195,13],[194,14,195,14],[196,4,197,11],[196,12,197,13],[196,14,197,14],[196,16,197,16],[181,4,182,11],[181,12,182,13],[181,14,182,14],[183,4,184,11],[183,12,184,13],[183,14,184,14],[185,4,186,11],[185,12,186,13],[185,14,186,14],[175,4,176,11],[175,12,176,13],[175,14,176,14],[177,4,178,11],[177,12,178,13],[177,14,178,14],[179,4,180,11],[179,12,180,13],[179,14,180,14],[167,16,168,16],[167,17,168,17],[169,4,170,11],[169,12,170,13],[169,14,170,14],[171,4,172,11],[171,12,172,13],[171,14,172,14],[173,4,174,11],[173,12,174,13],[173,14,174,14],[156,4,157,11],[156,12,157,13],[156,14,157,14],[161,3,163,5],[162,6,163,6],[165,4,166,11],[165,12,166,13],[165,14,166,14],[167,4,168,11],[167,12,168,13],[167,14,168,14],[150,4,151,11],[150,12,151,13],[150,14,151,14],[152,4,153,11],[152,12,153,13],[152,14,153,14],[154,4,155,11],[154,12,155,13],[154,14,155,14],[142,16,143,16],[142,17,143,17],[144,4,145,11],[144,12,145,13],[144,14,145,14],[146,4,147,11],[146,12,147,13],[146,14,147,14],[148,4,149,11],[148,12,149,13],[148,14,149,14],[131,4,132,11],[131,12,132,13],[131,14,132,14],[136,3,138,5],[137,6,138,6],[140,4,141,11],[140,12,141,13],[140,14,141,14],[142,4,143,11],[142,12,143,13],[142,14,143,14],[123,17,124,17],[125,4,126,11],[125,12,126,13],[125,14,126,14],[127,4,128,11],[127,12,128,13],[127,14,128,14],[129,4,130,11],[129,12,130,13],[129,14,130,14],[117,3,119,5],[118,6,119,6],[121,4,122,11],[121,12,122,13],[121,14,122,14],[123,4,124,11],[123,12,124,13],[123,14,124,14],[123,16,124,16],[106,16,107,16],[106,17,107,17],[108,4,109,11],[108,12,109,13],[108,14,109,14],[110,4,111,11],[110,12,111,13],[110,14,111,14],[112,4,113,11],[112,12,113,13],[112,14,113,14],[95,4,96,11],[95,12,96,13],[95,14,96,14],[100,3,102,5],[101,6,102,6],[104,4,105,11],[104,12,105,13],[104,14,105,14],[106,4,107,11],[106,12,107,13],[106,14,107,14],[89,4,90,11],[89,12,90,13],[89,14,90,14],[89,16,90,16],[89,17,90,17],[91,4,92,11],[91,12,92,13],[91,14,92,14],[93,4,94,11],[93,12,94,13],[93,14,94,14],[76,4,77,11],[76,12,77,13],[76,14,77,14],[78,4,79,11],[78,12,79,13],[78,14,79,14],[83,3,85,5],[84,6,85,6],[87,4,88,11],[87,12,88,13],[87,14,88,14],[70,4,71,11],[70,12,71,13],[70,14,71,14],[72,4,73,11],[72,12,73,13],[72,14,73,14],[74,4,75,11],[74,12,75,13],[74,14,75,14],[62,17,63,17],[64,4,65,11],[64,12,65,13],[64,14,65,14],[66,4,67,11],[66,12,67,13],[66,14,67,14],[68,4,69,11],[68,12,69,13],[68,14,69,14],[56,3,58,5],[57,6,58,6],[60,4,61,11],[60,12,61,13],[60,14,61,14],[62,4,63,11],[62,12,63,13],[62,14,63,14],[62,16,63,16],[44,17,45,17],[46,4,47,11],[46,12,47,13],[46,14,47,14],[48,4,49,11],[48,12,49,13],[48,14,49,14],[50,4,51,11],[50,12,51,13],[50,14,51,14],[38,3,40,5],[39,6,40,6],[42,4,43,11],[42,12,43,13],[42,14,43,14],[44,4,45,11],[44,12,45,13],[44,14,45,14],[44,16,45,16],[29,4,30,11],[29,12,30,13],[29,14,30,14],[23,14,24,14],[31,4,32,11],[31,12,32,13],[31,14,32,14],[33,4,34,11],[33,12,34,13],[33,14,34,14],[6,3,6,17],[17,3,19,5],[18,6,19,6],[25,4,26,11],[25,12,26,13],[25,14,26,14],[27,4,28,11],[27,12,28,13],[27,14,28,14],[23,4,24,11],[23,12,24,13],[21,4,22,11],[21,12,22,13],[21,14,22,14],[23,16,24,16],[23,17,24,17],[8,3,8,17],[9,3,9,17],[10,3,10,17],[11,3,11,17],[12,3,12,17],[13,3,13,17]]}
[]
[]
[]
[]
[]
[]
[null,null,null," In 2015 the United Nations General Assembly created the Sustainable Development Goals (SDG’s) to act as a blueprint for achieving a better and more sustainable future for all. They aim to address the global challenges we face, including poverty, inequality, climate change, environmental degradation, peace and justice.  Sustainability is about responding to current needs and demands in ways that will create long term value and will not compromise the capacities of future generations. When assessing the impact of council proposals it is important that you base your judgement on available data or intelligence or via consultation or engagement with those affected. "]
[]
[null,null,null,"Impact Rating Descriptions for SDG's"]
[null,null,null,"Long term or significant positive: The proposal has positive impacts that will be long lasting (3 or more years) and/or are significant for large numbers of Rochdale residents and/or a significant proportion of a particular group or community."]
[null,null,null,"Short term positive: The proposal has positive impacts that will be limited in effects or have a short lifespan (3 years or less)."]
[null,null,null,"None: The proposal has no discernible positive or negative impacts "]
[null,null,null,"Short term negative: The proposal has negative impacts that will to be short term or limited impacts (3 years or less)."]
[null,null,null,"Long term or significant impact: The proposal or decision has negative impacts that will be long lasting (3 or more years) and/or are significant for large numbers of Rochdale residents and/or a significant proportion of a particular group or community."]
[]
[]
[]
[null,null,null,"Does this SDG apply to your project?",null,null,"Select"]
[null,null,null,null,null,null,"No"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(G19=\"Yes\",1,IF(G19=\"No\",0))","v":0}]
[]
[null,null,null,null," No Poverty",null,null,null,null,null,null,null,"Impact Rating",null,"RAG Result"]
[]
[null,null,null,null,"1. What will be the impact of this proposal on residents financially?",null,null,null,null,null,null,null,null,null,null,null,"Overall RAG",{"$f":"IF(U38=0,\"N/A\",IF(AND(U38<=0.74),\"RR\",IF(AND(U38>=0.75,U38<=0.99),\"A\",IF(U38=1,\"G\",IF(U38=\"x\",\"This is calculated when all questions have been answered\",\"\")))))","v":"N/A"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M24=\"Long term or significant positive\",2,IF(M24=\"Short term positive\",2,IF(M24=\"None\",0,IF(M24=\"Short term negative\",1,IF(M24=\"Long term or significant negative\",1)))))","v":false},{"$f":"VLOOKUP('Sustainability Assessment'!M24,Sheet2!$C$4:$D$8,2,0)","v":{"$error":"#N/A"}}]
[null,null,null,null,"2. What will be the impact of this proposal for people living in poverty?",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP('Sustainability Assessment'!M25,Sheet2!$C$4:$D$8,2,0)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M26=\"Long term or significant positive\",2,IF(M26=\"Short term positive\",2,IF(M26=\"None\",0,IF(M26=\"Short term negative\",1,IF(M26=\"Long term or significant negative\",1)))))","v":false},{"$f":"VLOOKUP('Sustainability Assessment'!M26,Sheet2!$C$4:$D$8,2,0)","v":{"$error":"#N/A"}}]
[null,null,null,null,"3. What will be the impact of this proposal for people living in fuel poverty?",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP('Sustainability Assessment'!M27,Sheet2!$C$4:$D$8,2,0)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M28=\"Long term or significant positive\",2,IF(M28=\"Short term positive\",2,IF(M28=\"None\",0,IF(M28=\"Short term negative\",1,IF(M28=\"Long term or significant negative\",1)))))","v":false},{"$f":"VLOOKUP('Sustainability Assessment'!M28,Sheet2!$C$4:$D$8,2,0)","v":{"$error":"#N/A"}}]
[null,null,null,null,"4. What will be the impact of this proposal on the accessibility of financial support for vulnerable and disadvantaged people?",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP('Sustainability Assessment'!M29,Sheet2!$C$4:$D$8,2,0)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M30=\"Long term or significant positive\",2,IF(M30=\"Short term positive\",2,IF(M30=\"None\",0,IF(M30=\"Short term negative\",1,IF(M30=\"Long term or significant negative\",1)))))","v":false},{"$f":"VLOOKUP('Sustainability Assessment'!M30,Sheet2!$C$4:$D$8,2,0)","v":{"$error":"#N/A"}}]
[null,null,null,null,"5. What will be the impact of this proposal on provision of early help and support for vulnerable and disadvantaged people to prevent them falling into crisis?",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP('Sustainability Assessment'!M31,Sheet2!$C$4:$D$8,2,0)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M32=\"Long term or significant positive\",2,IF(M32=\"Short term positive\",2,IF(M32=\"None\",0,IF(M32=\"Short term negative\",1,IF(M32=\"Long term or significant negative\",1)))))","v":false},{"$f":"VLOOKUP('Sustainability Assessment'!M32,Sheet2!$C$4:$D$8,2,0)","v":{"$error":"#N/A"}}]
[null,null,null,null,"6. What will be the impact of this proposal on building the resilience of those most vulnerable and disadvantaged?",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP('Sustainability Assessment'!M33,Sheet2!$C$4:$D$8,2,0)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M34=\"Long term or significant positive\",2,IF(M34=\"Short term positive\",2,IF(M34=\"None\",0,IF(M34=\"Short term negative\",1,IF(M34=\"Long term or significant negative\",1)))))","v":false},{"$f":"VLOOKUP('Sustainability Assessment'!M34,Sheet2!$C$4:$D$8,2,0)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP('Sustainability Assessment'!M35,Sheet2!$C$4:$D$8,2,0)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR((SUM(U25:U35))/((COUNTIF(U25:U35,\">0\")*2)),\"0\")","v":"0"},{"$f":"VLOOKUP('Sustainability Assessment'!M36,Sheet2!$C$4:$D$8,2,0)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(U37,2)","v":0},{"$f":"VLOOKUP('Sustainability Assessment'!M37,Sheet2!$C$4:$D$8,2,0)","v":{"$error":"#N/A"}}]
[null,null,null,"Does this SDG apply to your project?",null,null,"Select",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP('Sustainability Assessment'!M38,Sheet2!$C$4:$D$8,2,0)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,"Yes",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP('Sustainability Assessment'!M39,Sheet2!$C$4:$D$8,2,0)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(G40=\"Yes\",1,IF(G40=\"No\",0))","v":1},{"$f":"VLOOKUP('Sustainability Assessment'!M40,Sheet2!$C$4:$D$8,2,0)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP('Sustainability Assessment'!M41,Sheet2!$C$4:$D$8,2,0)","v":{"$error":"#N/A"}}]
[null,null,null,null,"Zero Hunger",null,null,null,null,null,null,null,"Impact Rating",null,"RAG Result",null,null,null,null,null,null,{"$f":"VLOOKUP('Sustainability Assessment'!M42,Sheet2!$C$4:$D$8,2,0)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP('Sustainability Assessment'!M43,Sheet2!$C$4:$D$8,2,0)","v":{"$error":"#N/A"}}]
[null,null,null,null,"1. What will be the impact of this proposal on availability and accessibility of food within the local area?",null,null,null,null,null,null,null,null,null,null,null,"Overall RAG",{"$f":"IF(U55=0,\"N/A\",IF(AND(U55<=0.74),\"RR\",IF(AND(U55>=0.75,U55<=0.99),\"A\",IF(U55=1,\"G\",IF(U55=\"x\",\"This is calculated when all questions have been answered\",\"\")))))","v":"G"},null,null,null,{"$f":"VLOOKUP('Sustainability Assessment'!M44,Sheet2!$C$4:$D$8,2,0)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M45=\"Long term or significant positive\",2,IF(M45=\"Short term positive\",2,IF(M45=\"None\",0,IF(M45=\"Short term negative\",1,IF(M45=\"Long term or significant negative\",1)))))","v":false},{"$f":"VLOOKUP('Sustainability Assessment'!M45,Sheet2!$C$4:$D$8,2,0)","v":{"$error":"#N/A"}}]
[null,null,null,null,"2. What will be the impact of this proposal on food production within the local area?",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP('Sustainability Assessment'!M46,Sheet2!$C$4:$D$8,2,0)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M47=\"Long term or significant positive\",2,IF(M47=\"Short term positive\",2,IF(M47=\"None\",0,IF(M47=\"Short term negative\",1,IF(M47=\"Long term or significant negative\",1)))))","v":false},{"$f":"VLOOKUP('Sustainability Assessment'!M47,Sheet2!$C$4:$D$8,2,0)","v":{"$error":"#N/A"}}]
[null,null,null,null,"3. What will be the impact of this proposal on agriculture in the local area?",null,null,null,null,null,null,null,"Long term or significant positive",null,null,null,null,null,null,null,null,{"$f":"VLOOKUP('Sustainability Assessment'!M48,Sheet2!$C$4:$D$8,2,0)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M49=\"Long term or significant positive\",2,IF(M49=\"Short term positive\",2,IF(M49=\"None\",0,IF(M49=\"Short term negative\",1,IF(M49=\"Long term or significant negative\",1)))))","v":2},{"$f":"VLOOKUP('Sustainability Assessment'!M49,Sheet2!$C$4:$D$8,2,0)","v":1}]
[null,null,null,null,"4. What will be the impact of this proposal on healthy eating?",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP('Sustainability Assessment'!M50,Sheet2!$C$4:$D$8,2,0)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M51=\"Long term or significant positive\",2,IF(M51=\"Short term positive\",2,IF(M51=\"None\",0,IF(M51=\"Short term negative\",1,IF(M51=\"Long term or significant negative\",1)))))","v":false},{"$f":"VLOOKUP('Sustainability Assessment'!M51,Sheet2!$C$4:$D$8,2,0)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP('Sustainability Assessment'!M52,Sheet2!$C$4:$D$8,2,0)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR((SUM(U46:U52))/((COUNTIF(U46:U52,\">0\")*2)),\"0\")","v":1},{"$f":"VLOOKUP('Sustainability Assessment'!M53,Sheet2!$C$4:$D$8,2,0)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(U54,2)","v":1},{"$f":"VLOOKUP('Sustainability Assessment'!M54,Sheet2!$C$4:$D$8,2,0)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP('Sustainability Assessment'!M55,Sheet2!$C$4:$D$8,2,0)","v":{"$error":"#N/A"}}]
[null,null,null,"Does this SDG apply to your project?",null,null,"Select",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP('Sustainability Assessment'!M56,Sheet2!$C$4:$D$8,2,0)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,"Yes",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP('Sustainability Assessment'!M57,Sheet2!$C$4:$D$8,2,0)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(G58=\"Yes\",1,IF(G58=\"No\",0))","v":1},{"$f":"VLOOKUP('Sustainability Assessment'!M58,Sheet2!$C$4:$D$8,2,0)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP('Sustainability Assessment'!M59,Sheet2!$C$4:$D$8,2,0)","v":{"$error":"#N/A"}}]
[null,null,null,null,"Health & Wellbeing",null,null,null,null,null,null,null,"Impact Rating",null,"RAG Result",null,null,null,null,null,null,{"$f":"VLOOKUP('Sustainability Assessment'!M60,Sheet2!$C$4:$D$8,2,0)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP('Sustainability Assessment'!M61,Sheet2!$C$4:$D$8,2,0)","v":{"$error":"#N/A"}}]
[null,null,null,null,"1. What will be the impact of this proposal on the availability and accessibility of healthcare services in the local area?",null,null,null,null,null,null,null,"None",null,null,null,"Overall RAG",{"$f":"IF(U83=0,\"N/A\",IF(AND(U83<=0.74),\"RR\",IF(AND(U83>=0.75,U83<=0.99),\"A\",IF(U83=1,\"G\",IF(U83=\"x\",\"This is calculated when all questions have been answered\",\"\")))))","v":"G"},null,null,null,{"$f":"VLOOKUP('Sustainability Assessment'!M62,Sheet2!$C$4:$D$8,2,0)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M63=\"Long term or significant positive\",2,IF(M63=\"Short term positive\",2,IF(M63=\"None\",0,IF(M63=\"Short term negative\",1,IF(M63=\"Long term or significant negative\",1)))))","v":0},{"$f":"VLOOKUP('Sustainability Assessment'!M63,Sheet2!$C$4:$D$8,2,0)","v":3}]
[null,null,null,null,"2. What will be the impact of this proposal on the availability and accessibility of social care services in the local area?",null,null,null,null,null,null,null,"None",null,null,null,null,null,null,null,null,{"$f":"VLOOKUP('Sustainability Assessment'!M64,Sheet2!$C$4:$D$8,2,0)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M65=\"Long term or significant positive\",2,IF(M65=\"Short term positive\",2,IF(M65=\"None\",0,IF(M65=\"Short term negative\",1,IF(M65=\"Long term or significant negative\",1)))))","v":0},{"$f":"VLOOKUP('Sustainability Assessment'!M65,Sheet2!$C$4:$D$8,2,0)","v":3}]
[null,null,null,null,"3. What will be the impact of this proposal on the opportunities for children and young people getting a healthy start?",null,null,null,null,null,null,null,"None",null,null,null,null,null,null,null,null,{"$f":"VLOOKUP('Sustainability Assessment'!M66,Sheet2!$C$4:$D$8,2,0)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M67=\"Long term or significant positive\",2,IF(M67=\"Short term positive\",2,IF(M67=\"None\",0,IF(M67=\"Short term negative\",1,IF(M67=\"Long term or significant negative\",1)))))","v":0},{"$f":"VLOOKUP('Sustainability Assessment'!M67,Sheet2!$C$4:$D$8,2,0)","v":3}]
[null,null,null,null,"4. What will be the impact of this proposal on the opportunities for preventing or reducing illness, injury and death?",null,null,null,null,null,null,null,"Long term or significant positive",null,null,null,null,null,null,null,null,{"$f":"VLOOKUP('Sustainability Assessment'!M68,Sheet2!$C$4:$D$8,2,0)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M69=\"Long term or significant positive\",2,IF(M69=\"Short term positive\",2,IF(M69=\"None\",0,IF(M69=\"Short term negative\",1,IF(M69=\"Long term or significant negative\",1)))))","v":2},{"$f":"VLOOKUP('Sustainability Assessment'!M69,Sheet2!$C$4:$D$8,2,0)","v":1}]
[null,null,null,null,"5. What is the impact of this proposal on the opportunities for preventing or reducing communicable or infectious disease?",null,null,null,null,null,null,null,"None",null,null,null,null,null,null,null,null,{"$f":"VLOOKUP('Sustainability Assessment'!M70,Sheet2!$C$4:$D$8,2,0)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M71=\"Long term or significant positive\",2,IF(M71=\"Short term positive\",2,IF(M71=\"None\",0,IF(M71=\"Short term negative\",1,IF(M71=\"Long term or significant negative\",1)))))","v":0},{"$f":"VLOOKUP('Sustainability Assessment'!M71,Sheet2!$C$4:$D$8,2,0)","v":3}]
[null,null,null,null,"6. What will be the impact of this proposal on the opportunities for reducing substance misuse?",null,null,null,null,null,null,null,"None",null,null,null,null,null,null,null,null,{"$f":"VLOOKUP('Sustainability Assessment'!M72,Sheet2!$C$4:$D$8,2,0)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M73=\"Long term or significant positive\",2,IF(M73=\"Short term positive\",2,IF(M73=\"None\",0,IF(M73=\"Short term negative\",1,IF(M73=\"Long term or significant negative\",1)))))","v":0},{"$f":"VLOOKUP('Sustainability Assessment'!M73,Sheet2!$C$4:$D$8,2,0)","v":3}]
[null,null,null,null,"7. What will be the impact of this proposal on the opportunities for physical wellbeing?",null,null,null,null,null,null,null,"Long term or significant positive",null,null,null,null,null,null,null,null,{"$f":"VLOOKUP('Sustainability Assessment'!M74,Sheet2!$C$4:$D$8,2,0)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M75=\"Long term or significant positive\",2,IF(M75=\"Short term positive\",2,IF(M75=\"None\",0,IF(M75=\"Short term negative\",1,IF(M75=\"Long term or significant negative\",1)))))","v":2},{"$f":"VLOOKUP('Sustainability Assessment'!M75,Sheet2!$C$4:$D$8,2,0)","v":1}]
[null,null,null,null,"8. What will be the impact of the proposal on the opportunities for mental wellbeing?",null,null,null,null,null,null,null,"Long term or significant positive",null,null,null,null,null,null,null,null,{"$f":"VLOOKUP('Sustainability Assessment'!M76,Sheet2!$C$4:$D$8,2,0)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M77=\"Long term or significant positive\",2,IF(M77=\"Short term positive\",2,IF(M77=\"None\",0,IF(M77=\"Short term negative\",1,IF(M77=\"Long term or significant negative\",1)))))","v":2},{"$f":"VLOOKUP('Sustainability Assessment'!M77,Sheet2!$C$4:$D$8,2,0)","v":1}]
[null,null,null,null,"9. What will be the impact of this proposal on loneliness and isolation?",null,null,null,null,null,null,null,"None",null,null,null,null,null,null,null,null,{"$f":"VLOOKUP('Sustainability Assessment'!M78,Sheet2!$C$4:$D$8,2,0)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M79=\"Long term or significant positive\",2,IF(M79=\"Short term positive\",2,IF(M79=\"None\",0,IF(M79=\"Short term negative\",1,IF(M79=\"Long term or significant negative\",1)))))","v":0},{"$f":"VLOOKUP('Sustainability Assessment'!M79,Sheet2!$C$4:$D$8,2,0)","v":3}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP('Sustainability Assessment'!M80,Sheet2!$C$4:$D$8,2,0)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR((SUM(U64:U80))/((COUNTIF(U64:U80,\">0\")*2)),\"0\")","v":1},{"$f":"VLOOKUP('Sustainability Assessment'!M81,Sheet2!$C$4:$D$8,2,0)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(U82,2)","v":1},{"$f":"VLOOKUP('Sustainability Assessment'!M82,Sheet2!$C$4:$D$8,2,0)","v":{"$error":"#N/A"}}]
[null,null,null,"Does this SDG apply to your project?",null,null,"Select",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP('Sustainability Assessment'!M83,Sheet2!$C$4:$D$8,2,0)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,"No",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP('Sustainability Assessment'!M84,Sheet2!$C$4:$D$8,2,0)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(G85=\"Yes\",1,IF(G85=\"No\",0))","v":0},{"$f":"VLOOKUP('Sustainability Assessment'!M85,Sheet2!$C$4:$D$8,2,0)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP('Sustainability Assessment'!M86,Sheet2!$C$4:$D$8,2,0)","v":{"$error":"#N/A"}}]
[null,null,null,null,"Quality Education",null,null,null,null,null,null,null,"Impact Rating",null,"RAG Result",null,null,null,null,null,null,{"$f":"VLOOKUP('Sustainability Assessment'!M87,Sheet2!$C$4:$D$8,2,0)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP('Sustainability Assessment'!M88,Sheet2!$C$4:$D$8,2,0)","v":{"$error":"#N/A"}}]
[null,null,null,null,"1. What will be the impact of this proposal on the availability and accessibility of educational services in the local area? E.g. primary, secondary, further education ",null,null,null,null,null,null,null,null,null,null,null,"Overall RAG",{"$f":"IF(U100=0,\"N/A\",IF(AND(U100<=0.74),\"RR\",IF(AND(U100>=0.75,U100<=0.99),\"A\",IF(U100=1,\"G\",IF(U100=\"x\",\"This is calculated when all questions have been answered\",\"\")))))","v":"N/A"},null,null,null,{"$f":"VLOOKUP('Sustainability Assessment'!M89,Sheet2!$C$4:$D$8,2,0)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M90=\"Long term or significant positive\",2,IF(M90=\"Short term positive\",2,IF(M90=\"None\",0,IF(M90=\"Short term negative\",1,IF(M90=\"Long term or significant negative\",1)))))","v":false},{"$f":"VLOOKUP('Sustainability Assessment'!M90,Sheet2!$C$4:$D$8,2,0)","v":{"$error":"#N/A"}}]
[null,null,null,null,"2. What will be the impact of this proposal on the availability and accessibility of informal education and training in the local area?",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP('Sustainability Assessment'!M91,Sheet2!$C$4:$D$8,2,0)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M92=\"Long term or significant positive\",2,IF(M92=\"Short term positive\",2,IF(M92=\"None\",0,IF(M92=\"Short term negative\",1,IF(M92=\"Long term or significant negative\",1)))))","v":false},{"$f":"VLOOKUP('Sustainability Assessment'!M92,Sheet2!$C$4:$D$8,2,0)","v":{"$error":"#N/A"}}]
[null,null,null,null,"3. What will be the impact of this proposal on the ability of local people to use digital technologies?  ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP('Sustainability Assessment'!M93,Sheet2!$C$4:$D$8,2,0)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M94=\"Long term or significant positive\",2,IF(M94=\"Short term positive\",2,IF(M94=\"None\",0,IF(M94=\"Short term negative\",1,IF(M94=\"Long term or significant negative\",1)))))","v":false},{"$f":"VLOOKUP('Sustainability Assessment'!M94,Sheet2!$C$4:$D$8,2,0)","v":{"$error":"#N/A"}}]
[null,null,null,null,"4. What will be the impact of this proposal on the opportunities to educate people on important issues to influence behaviour change and promote sustainable development?",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP('Sustainability Assessment'!M95,Sheet2!$C$4:$D$8,2,0)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M96=\"Long term or significant positive\",2,IF(M96=\"Short term positive\",2,IF(M96=\"None\",0,IF(M96=\"Short term negative\",1,IF(M96=\"Long term or significant negative\",1)))))","v":false},{"$f":"VLOOKUP('Sustainability Assessment'!M96,Sheet2!$C$4:$D$8,2,0)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP('Sustainability Assessment'!M97,Sheet2!$C$4:$D$8,2,0)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR((SUM(U91:U97))/((COUNTIF(U91:U97,\">0\")*2)),\"0\")","v":"0"},{"$f":"VLOOKUP('Sustainability Assessment'!M98,Sheet2!$C$4:$D$8,2,0)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(U99,2)","v":0},{"$f":"VLOOKUP('Sustainability Assessment'!M99,Sheet2!$C$4:$D$8,2,0)","v":{"$error":"#N/A"}}]
[null,null,null,"Does this SDG apply to your project?",null,null,"Select",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP('Sustainability Assessment'!M100,Sheet2!$C$4:$D$8,2,0)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,"No",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP('Sustainability Assessment'!M101,Sheet2!$C$4:$D$8,2,0)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(G102=\"Yes\",1,IF(G102=\"No\",0))","v":0},{"$f":"VLOOKUP('Sustainability Assessment'!M102,Sheet2!$C$4:$D$8,2,0)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP('Sustainability Assessment'!M103,Sheet2!$C$4:$D$8,2,0)","v":{"$error":"#N/A"}}]
[null,null,null,null,"Gender Equality",null,null,null,null,null,null,null,"Impact Rating",null,"RAG Result",null,null,null,null,null,null,{"$f":"VLOOKUP('Sustainability Assessment'!M104,Sheet2!$C$4:$D$8,2,0)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP('Sustainability Assessment'!M105,Sheet2!$C$4:$D$8,2,0)","v":{"$error":"#N/A"}}]
[null,null,null,null,"1. What will be the impact of this proposal in eliminating discrimination against different genders?",null,null,null,null,null,null,null,null,null,null,null,"Overall RAG",{"$f":"IF(U117=0,\"N/A\",IF(AND(U117<=0.74),\"RR\",IF(AND(U117>=0.75,U117<=0.99),\"A\",IF(U117=1,\"G\",IF(U117=\"x\",\"This is calculated when all questions have been answered\",\"\")))))","v":"N/A"},null,null,null,{"$f":"VLOOKUP('Sustainability Assessment'!M106,Sheet2!$C$4:$D$8,2,0)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M107=\"Long term or significant positive\",2,IF(M107=\"Short term positive\",2,IF(M107=\"None\",0,IF(M107=\"Short term negative\",1,IF(M107=\"Long term or significant negative\",1)))))","v":false},{"$f":"VLOOKUP('Sustainability Assessment'!M107,Sheet2!$C$4:$D$8,2,0)","v":{"$error":"#N/A"}}]
[null,null,null,null,"2. What will be the impact of this proposal in eliminating violence and exploitation against different genders?",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP('Sustainability Assessment'!M108,Sheet2!$C$4:$D$8,2,0)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M109=\"Long term or significant positive\",2,IF(M109=\"Short term positive\",2,IF(M109=\"None\",0,IF(M109=\"Short term negative\",1,IF(M109=\"Long term or significant negative\",1)))))","v":false},{"$f":"VLOOKUP('Sustainability Assessment'!M109,Sheet2!$C$4:$D$8,2,0)","v":{"$error":"#N/A"}}]
[null,null,null,null,"3. What will be the impact of this proposal in eliminating harmful practices to different genders? ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP('Sustainability Assessment'!M110,Sheet2!$C$4:$D$8,2,0)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M111=\"Long term or significant positive\",2,IF(M111=\"Short term positive\",2,IF(M111=\"None\",0,IF(M111=\"Short term negative\",1,IF(M111=\"Long term or significant negative\",1)))))","v":false},{"$f":"VLOOKUP('Sustainability Assessment'!M111,Sheet2!$C$4:$D$8,2,0)","v":{"$error":"#N/A"}}]
[null,null,null,null,"4. What will be the impact of this proposal in empowering different genders?",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP('Sustainability Assessment'!M112,Sheet2!$C$4:$D$8,2,0)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M113=\"Long term or significant positive\",2,IF(M113=\"Short term positive\",2,IF(M113=\"None\",0,IF(M113=\"Short term negative\",1,IF(M113=\"Long term or significant negative\",1)))))","v":false},{"$f":"VLOOKUP('Sustainability Assessment'!M113,Sheet2!$C$4:$D$8,2,0)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP('Sustainability Assessment'!M114,Sheet2!$C$4:$D$8,2,0)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR((SUM(U108:U114))/((COUNTIF(U108:U114,\">0\")*2)),\"0\")","v":"0"},{"$f":"VLOOKUP('Sustainability Assessment'!M115,Sheet2!$C$4:$D$8,2,0)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(U116,2)","v":0},{"$f":"VLOOKUP('Sustainability Assessment'!M116,Sheet2!$C$4:$D$8,2,0)","v":{"$error":"#N/A"}}]
[null,null,null,"Does this SDG apply to your project?",null,null,"Select",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP('Sustainability Assessment'!M117,Sheet2!$C$4:$D$8,2,0)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,"Yes",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP('Sustainability Assessment'!M118,Sheet2!$C$4:$D$8,2,0)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(G119=\"Yes\",1,IF(G119=\"No\",0))","v":1},{"$f":"VLOOKUP('Sustainability Assessment'!M119,Sheet2!$C$4:$D$8,2,0)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP('Sustainability Assessment'!M120,Sheet2!$C$4:$D$8,2,0)","v":{"$error":"#N/A"}}]
[null,null,null,null,"Clean Water & Sanitation",null,null,null,null,null,null,null,"Impact Rating",null,"RAG Result",null,null,null,null,null,null,{"$f":"VLOOKUP('Sustainability Assessment'!M121,Sheet2!$C$4:$D$8,2,0)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP('Sustainability Assessment'!M122,Sheet2!$C$4:$D$8,2,0)","v":{"$error":"#N/A"}}]
[null,null,null,null,"1. What will be the impact of this proposal on water use efficiency?",null,null,null,null,null,null,null,"None",null,null,null,"Overall RAG",{"$f":"IF(U136=0,\"N/A\",IF(AND(U136<=0.74),\"RR\",IF(AND(U136>=0.75,U136<=0.99),\"A\",IF(U136=1,\"G\",IF(U136=\"x\",\"This is calculated when all questions have been answered\",\"\")))))","v":"G"},null,null,null,{"$f":"VLOOKUP('Sustainability Assessment'!M123,Sheet2!$C$4:$D$8,2,0)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M124=\"Long term or significant positive\",2,IF(M124=\"Short term positive\",2,IF(M124=\"None\",0,IF(M124=\"Short term negative\",1,IF(M124=\"Long term or significant negative\",1)))))","v":0},{"$f":"VLOOKUP('Sustainability Assessment'!M124,Sheet2!$C$4:$D$8,2,0)","v":3}]
[null,null,null,null,"2. What will be the impact of this proposal on water quality?",null,null,null,null,null,null,null,"Long term or significant positive",null,null,null,null,null,null,null,null,{"$f":"VLOOKUP('Sustainability Assessment'!M125,Sheet2!$C$4:$D$8,2,0)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M126=\"Long term or significant positive\",2,IF(M126=\"Short term positive\",2,IF(M126=\"None\",0,IF(M126=\"Short term negative\",1,IF(M126=\"Long term or significant negative\",1)))))","v":2},{"$f":"VLOOKUP('Sustainability Assessment'!M126,Sheet2!$C$4:$D$8,2,0)","v":1}]
[null,null,null,null,"3. What will be the impact on the supply or availability of water?",null,null,null,null,null,null,null,"None",null,null,null,null,null,null,null,null,{"$f":"VLOOKUP('Sustainability Assessment'!M127,Sheet2!$C$4:$D$8,2,0)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M128=\"Long term or significant positive\",2,IF(M128=\"Short term positive\",2,IF(M128=\"None\",0,IF(M128=\"Short term negative\",1,IF(M128=\"Long term or significant negative\",1)))))","v":0},{"$f":"VLOOKUP('Sustainability Assessment'!M128,Sheet2!$C$4:$D$8,2,0)","v":3}]
[null,null,null,null,"4. What will be the impact of this proposal on protecting and managing natural water resources? E.g. Lakes, rivers etc.",null,null,null,null,null,null,null,"Long term or significant positive",null,null,null,null,null,null,null,null,{"$f":"VLOOKUP('Sustainability Assessment'!M129,Sheet2!$C$4:$D$8,2,0)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M130=\"Long term or significant positive\",2,IF(M130=\"Short term positive\",2,IF(M130=\"None\",0,IF(M130=\"Short term negative\",1,IF(M130=\"Long term or significant negative\",1)))))","v":2},{"$f":"VLOOKUP('Sustainability Assessment'!M130,Sheet2!$C$4:$D$8,2,0)","v":1}]
[null,null,null,null,"5. What will be the impact of this proposal on sustainable urban drainage? ",null,null,null,null,null,null,null,"None",null,null,null,null,null,null,null,null,{"$f":"VLOOKUP('Sustainability Assessment'!M131,Sheet2!$C$4:$D$8,2,0)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M132=\"Long term or significant positive\",2,IF(M132=\"Short term positive\",2,IF(M132=\"None\",0,IF(M132=\"Short term negative\",1,IF(M132=\"Long term or significant negative\",1)))))","v":0},{"$f":"VLOOKUP('Sustainability Assessment'!M132,Sheet2!$C$4:$D$8,2,0)","v":3}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP('Sustainability Assessment'!M133,Sheet2!$C$4:$D$8,2,0)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR((SUM(U125:U133))/((COUNTIF(U125:U133,\">0\")*2)),\"0\")","v":1},{"$f":"VLOOKUP('Sustainability Assessment'!M134,Sheet2!$C$4:$D$8,2,0)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(U135,2)","v":1},{"$f":"VLOOKUP('Sustainability Assessment'!M135,Sheet2!$C$4:$D$8,2,0)","v":{"$error":"#N/A"}}]
[null,null,null,"Does this SDG apply to your project?",null,null,"Select",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP('Sustainability Assessment'!M136,Sheet2!$C$4:$D$8,2,0)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,"No",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP('Sustainability Assessment'!M137,Sheet2!$C$4:$D$8,2,0)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(G138=\"Yes\",1,IF(G138=\"No\",0))","v":0},{"$f":"VLOOKUP('Sustainability Assessment'!M138,Sheet2!$C$4:$D$8,2,0)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP('Sustainability Assessment'!M139,Sheet2!$C$4:$D$8,2,0)","v":{"$error":"#N/A"}}]
[null,null,null,null,"Affordable & Clean Energy",null,null,null,null,null,null,null,"Impact Rating",null,"RAG Result",null,null,null,null,null,null,{"$f":"VLOOKUP('Sustainability Assessment'!M140,Sheet2!$C$4:$D$8,2,0)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP('Sustainability Assessment'!M141,Sheet2!$C$4:$D$8,2,0)","v":{"$error":"#N/A"}}]
[null,null,null,null,"1. What will be the impact of this proposal in reducing the amount of energy consumed?",null,null,null,null,null,null,null,null,null,null,null,"Overall RAG",{"$f":"IF(U161=0,\"N/A\",IF(AND(U161<=0.74),\"RR\",IF(AND(U161>=0.75,U161<=0.99),\"A\",IF(U161=1,\"G\",IF(U161=\"x\",\"This is calculated when all questions have been answered\",\"\")))))","v":"N/A"},null,null,null,{"$f":"VLOOKUP('Sustainability Assessment'!M142,Sheet2!$C$4:$D$8,2,0)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M143=\"Long term or significant positive\",2,IF(M143=\"Short term positive\",2,IF(M143=\"None\",0,IF(M143=\"Short term negative\",1,IF(M143=\"Long term or significant negative\",1)))))","v":false},{"$f":"VLOOKUP('Sustainability Assessment'!M143,Sheet2!$C$4:$D$8,2,0)","v":{"$error":"#N/A"}}]
[null,null,null,null,"2. What will be the impact of this proposal in improving energy efficiency for buildings and infrastructure? E.g. EPC ratings, Energy or Building Management Systems",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP('Sustainability Assessment'!M144,Sheet2!$C$4:$D$8,2,0)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M145=\"Long term or significant positive\",2,IF(M145=\"Short term positive\",2,IF(M145=\"None\",0,IF(M145=\"Short term negative\",1,IF(M145=\"Long term or significant negative\",1)))))","v":false},{"$f":"VLOOKUP('Sustainability Assessment'!M145,Sheet2!$C$4:$D$8,2,0)","v":{"$error":"#N/A"}}]
[null,null,null,null,"3. What will be the impact of this proposal on the cost of energy? (E.g. reducing costs or provision of affordable energy in the borough)?",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP('Sustainability Assessment'!M146,Sheet2!$C$4:$D$8,2,0)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M147=\"Long term or significant positive\",2,IF(M147=\"Short term positive\",2,IF(M147=\"None\",0,IF(M147=\"Short term negative\",1,IF(M147=\"Long term or significant negative\",1)))))","v":false},{"$f":"VLOOKUP('Sustainability Assessment'!M147,Sheet2!$C$4:$D$8,2,0)","v":{"$error":"#N/A"}}]
[null,null,null,null,"4. What will be the impact of this proposal on electricity consumption from the grid? (if grid consumption will be increased this is a negative impact)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP('Sustainability Assessment'!M148,Sheet2!$C$4:$D$8,2,0)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M149=\"Long term or significant positive\",2,IF(M149=\"Short term positive\",2,IF(M149=\"None\",0,IF(M149=\"Short term negative\",1,IF(M149=\"Long term or significant negative\",1)))))","v":false},{"$f":"VLOOKUP('Sustainability Assessment'!M149,Sheet2!$C$4:$D$8,2,0)","v":{"$error":"#N/A"}}]
[null,null,null,null,"5. What will be the impact of this proposal on gas consumption from the grid? (if grid consumption will be increased this is a negative impact)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP('Sustainability Assessment'!M150,Sheet2!$C$4:$D$8,2,0)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M151=\"Long term or significant positive\",2,IF(M151=\"Short term positive\",2,IF(M151=\"None\",0,IF(M151=\"Short term negative\",1,IF(M151=\"Long term or significant negative\",1)))))","v":false},{"$f":"VLOOKUP('Sustainability Assessment'!M151,Sheet2!$C$4:$D$8,2,0)","v":{"$error":"#N/A"}}]
[null,null,null,null,"6. What will be the impact of this proposal on production and utilisation of energy from renewable sources? ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP('Sustainability Assessment'!M152,Sheet2!$C$4:$D$8,2,0)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M153=\"Long term or significant positive\",2,IF(M153=\"Short term positive\",2,IF(M153=\"None\",0,IF(M153=\"Short term negative\",1,IF(M153=\"Long term or significant negative\",1)))))","v":false},{"$f":"VLOOKUP('Sustainability Assessment'!M153,Sheet2!$C$4:$D$8,2,0)","v":{"$error":"#N/A"}}]
[null,null,null,null,"7. What will be the impact of this proposal on the provision of opportunities to utilise waste products to facilitate energy generation? E.g. bio-energy from bio-fuels",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP('Sustainability Assessment'!M154,Sheet2!$C$4:$D$8,2,0)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M155=\"Long term or significant positive\",2,IF(M155=\"Short term positive\",2,IF(M155=\"None\",0,IF(M155=\"Short term negative\",1,IF(M155=\"Long term or significant negative\",1)))))","v":false},{"$f":"VLOOKUP('Sustainability Assessment'!M155,Sheet2!$C$4:$D$8,2,0)","v":{"$error":"#N/A"}}]
[null,null,null,null,"8. What will be the impact of this proposal on the accessibility and security of energy? E.g. Locally sourced, community energy etc. ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP('Sustainability Assessment'!M156,Sheet2!$C$4:$D$8,2,0)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M157=\"Long term or significant positive\",2,IF(M157=\"Short term positive\",2,IF(M157=\"None\",0,IF(M157=\"Short term negative\",1,IF(M157=\"Long term or significant negative\",1)))))","v":false},{"$f":"VLOOKUP('Sustainability Assessment'!M157,Sheet2!$C$4:$D$8,2,0)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP('Sustainability Assessment'!M158,Sheet2!$C$4:$D$8,2,0)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR((SUM(U144:U158))/((COUNTIF(U144:U158,\">0\")*2)),\"0\")","v":"0"},{"$f":"VLOOKUP('Sustainability Assessment'!M159,Sheet2!$C$4:$D$8,2,0)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(U160,2)","v":0},{"$f":"VLOOKUP('Sustainability Assessment'!M160,Sheet2!$C$4:$D$8,2,0)","v":{"$error":"#N/A"}}]
[null,null,null,"Does this SDG apply to your project?",null,null,"Select",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP('Sustainability Assessment'!M161,Sheet2!$C$4:$D$8,2,0)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,"Yes",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP('Sustainability Assessment'!M162,Sheet2!$C$4:$D$8,2,0)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(G163=\"Yes\",1,IF(G163=\"No\",0))","v":1},{"$f":"VLOOKUP('Sustainability Assessment'!M163,Sheet2!$C$4:$D$8,2,0)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP('Sustainability Assessment'!M164,Sheet2!$C$4:$D$8,2,0)","v":{"$error":"#N/A"}}]
[null,null,null,null,"Decent Work & Economic Growth",null,null,null,null,null,null,null,"Impact Rating",null,"RAG Result",null,null,null,null,null,null,{"$f":"VLOOKUP('Sustainability Assessment'!M165,Sheet2!$C$4:$D$8,2,0)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP('Sustainability Assessment'!M166,Sheet2!$C$4:$D$8,2,0)","v":{"$error":"#N/A"}}]
[null,null,null,null,"1. What will be the impact of this proposal on the local authority budget? E.g. revenue, funding, income generation, savings",null,null,null,null,null,null,null,"None",null,null,null,"Overall RAG",{"$f":"IF(U190=0,\"N/A\",IF(AND(U190<=0.74),\"RR\",IF(AND(U190>=0.75,U190<=0.99),\"A\",IF(U190=1,\"G\",IF(U190=\"x\",\"This is calculated when all questions have been answered\",\"\")))))","v":"G"},null,null,null,{"$f":"VLOOKUP('Sustainability Assessment'!M167,Sheet2!$C$4:$D$8,2,0)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M168=\"Long term or significant positive\",2,IF(M168=\"Short term positive\",2,IF(M168=\"None\",0,IF(M168=\"Short term negative\",1,IF(M168=\"Long term or significant negative\",1)))))","v":0},{"$f":"VLOOKUP('Sustainability Assessment'!M168,Sheet2!$C$4:$D$8,2,0)","v":3}]
[null,null,null,null,"2. What will be the impact of this proposal on employment or volunteering opportunities for local people?",null,null,null,null,null,null,null,"None",null,null,null,null,null,null,null,null,{"$f":"VLOOKUP('Sustainability Assessment'!M169,Sheet2!$C$4:$D$8,2,0)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M170=\"Long term or significant positive\",2,IF(M170=\"Short term positive\",2,IF(M170=\"None\",0,IF(M170=\"Short term negative\",1,IF(M170=\"Long term or significant negative\",1)))))","v":0},{"$f":"VLOOKUP('Sustainability Assessment'!M170,Sheet2!$C$4:$D$8,2,0)","v":3}]
[null,null,null,null,"3. What will be the impact of this proposal on working conditions of employees in the local area? ",null,null,null,null,null,null,null,"None",null,null,null,null,null,null,null,null,{"$f":"VLOOKUP('Sustainability Assessment'!M171,Sheet2!$C$4:$D$8,2,0)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M172=\"Long term or significant positive\",2,IF(M172=\"Short term positive\",2,IF(M172=\"None\",0,IF(M172=\"Short term negative\",1,IF(M172=\"Long term or significant negative\",1)))))","v":0},{"$f":"VLOOKUP('Sustainability Assessment'!M172,Sheet2!$C$4:$D$8,2,0)","v":3}]
[null,null,null,null,"4. What will be the impact of this proposal on trade opportunities for local businesses?",null,null,null,null,null,null,null,"None",null,null,null,null,null,null,null,null,{"$f":"VLOOKUP('Sustainability Assessment'!M173,Sheet2!$C$4:$D$8,2,0)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M174=\"Long term or significant positive\",2,IF(M174=\"Short term positive\",2,IF(M174=\"None\",0,IF(M174=\"Short term negative\",1,IF(M174=\"Long term or significant negative\",1)))))","v":0},{"$f":"VLOOKUP('Sustainability Assessment'!M174,Sheet2!$C$4:$D$8,2,0)","v":3}]
[null,null,null,null,"5. What will be the impact of this proposal on revenue of local businesses?",null,null,null,null,null,null,null,"None",null,null,null,null,null,null,null,null,{"$f":"VLOOKUP('Sustainability Assessment'!M175,Sheet2!$C$4:$D$8,2,0)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M176=\"Long term or significant positive\",2,IF(M176=\"Short term positive\",2,IF(M176=\"None\",0,IF(M176=\"Short term negative\",1,IF(M176=\"Long term or significant negative\",1)))))","v":0},{"$f":"VLOOKUP('Sustainability Assessment'!M176,Sheet2!$C$4:$D$8,2,0)","v":3}]
[null,null,null,null,"6. What will be the impact of this proposal on local and community assets?",null,null,null,null,null,null,null,"None",null,null,null,null,null,null,null,null,{"$f":"VLOOKUP('Sustainability Assessment'!M177,Sheet2!$C$4:$D$8,2,0)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M178=\"Long term or significant positive\",2,IF(M178=\"Short term positive\",2,IF(M178=\"None\",0,IF(M178=\"Short term negative\",1,IF(M178=\"Long term or significant negative\",1)))))","v":0},{"$f":"VLOOKUP('Sustainability Assessment'!M178,Sheet2!$C$4:$D$8,2,0)","v":3}]
[null,null,null,null,"7. What will be the impact of this proposal for leisure, tourism and the visitor economy?",null,null,null,null,null,null,null,"Long term or significant positive",null,null,null,null,null,null,null,null,{"$f":"VLOOKUP('Sustainability Assessment'!M179,Sheet2!$C$4:$D$8,2,0)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M180=\"Long term or significant positive\",2,IF(M180=\"Short term positive\",2,IF(M180=\"None\",0,IF(M180=\"Short term negative\",1,IF(M180=\"Long term or significant negative\",1)))))","v":2},{"$f":"VLOOKUP('Sustainability Assessment'!M180,Sheet2!$C$4:$D$8,2,0)","v":1}]
[null,null,null,null,"8. What will be the impact of this proposal in growing the green economy? E.g. green skills, jobs, green industry and supply chains",null,null,null,null,null,null,null,"None",null,null,null,null,null,null,null,null,{"$f":"VLOOKUP('Sustainability Assessment'!M181,Sheet2!$C$4:$D$8,2,0)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M182=\"Long term or significant positive\",2,IF(M182=\"Short term positive\",2,IF(M182=\"None\",0,IF(M182=\"Short term negative\",1,IF(M182=\"Long term or significant negative\",1)))))","v":0},{"$f":"VLOOKUP('Sustainability Assessment'!M182,Sheet2!$C$4:$D$8,2,0)","v":3}]
[null,null,null,null,"9. What will be the impact of this proposal in delivering social value?",null,null,null,null,null,null,null,"None",null,null,null,null,null,null,null,null,{"$f":"VLOOKUP('Sustainability Assessment'!M183,Sheet2!$C$4:$D$8,2,0)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M184=\"Long term or significant positive\",2,IF(M184=\"Short term positive\",2,IF(M184=\"None\",0,IF(M184=\"Short term negative\",1,IF(M184=\"Long term or significant negative\",1)))))","v":0},{"$f":"VLOOKUP('Sustainability Assessment'!M184,Sheet2!$C$4:$D$8,2,0)","v":3}]
[null,null,null,null,"10. What will be the impact of this proposal in increasing local spend?",null,null,null,null,null,null,null,"None",null,null,null,null,null,null,null,null,{"$f":"VLOOKUP('Sustainability Assessment'!M185,Sheet2!$C$4:$D$8,2,0)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M186=\"Long term or significant positive\",2,IF(M186=\"Short term positive\",2,IF(M186=\"None\",0,IF(M186=\"Short term negative\",1,IF(M186=\"Long term or significant negative\",1)))))","v":0},{"$f":"VLOOKUP('Sustainability Assessment'!M186,Sheet2!$C$4:$D$8,2,0)","v":3}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP('Sustainability Assessment'!M187,Sheet2!$C$4:$D$8,2,0)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR((SUM(U169:U187))/((COUNTIF(U169:U187,\">0\")*2)),\"0\")","v":1},{"$f":"VLOOKUP('Sustainability Assessment'!M188,Sheet2!$C$4:$D$8,2,0)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(U189,2)","v":1},{"$f":"VLOOKUP('Sustainability Assessment'!M189,Sheet2!$C$4:$D$8,2,0)","v":{"$error":"#N/A"}}]
[null,null,null,"Does this SDG apply to your project?",null,null,"Select",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP('Sustainability Assessment'!M190,Sheet2!$C$4:$D$8,2,0)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,"Yes",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP('Sustainability Assessment'!M191,Sheet2!$C$4:$D$8,2,0)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(G192=\"Yes\",1,IF(G192=\"No\",0))","v":1},{"$f":"VLOOKUP('Sustainability Assessment'!M192,Sheet2!$C$4:$D$8,2,0)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP('Sustainability Assessment'!M193,Sheet2!$C$4:$D$8,2,0)","v":{"$error":"#N/A"}}]
[null,null,null,null,"Industry, Innovation & Infrastructure",null,null,null,null,null,null,null,"Impact Rating",null,"RAG Result",null,null,null,null,null,null,{"$f":"VLOOKUP('Sustainability Assessment'!M194,Sheet2!$C$4:$D$8,2,0)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP('Sustainability Assessment'!M195,Sheet2!$C$4:$D$8,2,0)","v":{"$error":"#N/A"}}]
[null,null,null,null,"1. What will be the impact of this proposal on creating sustainable and resilient infrastructure and buildings? E.g. retrofitting or upgrading, blue and green infrastructure",null,null,null,null,null,null,null,"Long term or significant positive",null,null,null,"Overall RAG",{"$f":"IF(U205=0,\"N/A\",IF(AND(U205<=0.74),\"RR\",IF(AND(U205>=0.75,U205<=0.99),\"A\",IF(U205=1,\"G\",IF(U205=\"x\",\"This is calculated when all questions have been answered\",\"\")))))","v":"G"},null,null,null,{"$f":"VLOOKUP('Sustainability Assessment'!M196,Sheet2!$C$4:$D$8,2,0)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M197=\"Long term or significant positive\",2,IF(M197=\"Short term positive\",2,IF(M197=\"None\",0,IF(M197=\"Short term negative\",1,IF(M197=\"Long term or significant negative\",1)))))","v":2},{"$f":"VLOOKUP('Sustainability Assessment'!M197,Sheet2!$C$4:$D$8,2,0)","v":1}]
[null,null,null,null,"2. What will be the impact of this proposal on opportunities for greener or more efficient industry? E.g. use of environmentally friendly equipment, technologies, processes, working methods and practices",null,null,null,null,null,null,null,"None",null,null,null,null,null,null,null,null,{"$f":"VLOOKUP('Sustainability Assessment'!M198,Sheet2!$C$4:$D$8,2,0)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M199=\"Long term or significant positive\",2,IF(M199=\"Short term positive\",2,IF(M199=\"None\",0,IF(M199=\"Short term negative\",1,IF(M199=\"Long term or significant negative\",1)))))","v":0},{"$f":"VLOOKUP('Sustainability Assessment'!M199,Sheet2!$C$4:$D$8,2,0)","v":3}]
[null,null,null,null,"3. What will be the impact of this proposal on availability and accessibility of digital and communications technology in the local area?",null,null,null,null,null,null,null,"None",null,null,null,null,null,null,null,null,{"$f":"VLOOKUP('Sustainability Assessment'!M200,Sheet2!$C$4:$D$8,2,0)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M201=\"Long term or significant positive\",2,IF(M201=\"Short term positive\",2,IF(M201=\"None\",0,IF(M201=\"Short term negative\",1,IF(M201=\"Long term or significant negative\",1)))))","v":0},{"$f":"VLOOKUP('Sustainability Assessment'!M201,Sheet2!$C$4:$D$8,2,0)","v":3}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP('Sustainability Assessment'!M202,Sheet2!$C$4:$D$8,2,0)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR((SUM(U198:U202))/((COUNTIF(U198:U202,\">0\")*2)),\"0\")","v":1},{"$f":"VLOOKUP('Sustainability Assessment'!M203,Sheet2!$C$4:$D$8,2,0)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(U204,2)","v":1},{"$f":"VLOOKUP('Sustainability Assessment'!M204,Sheet2!$C$4:$D$8,2,0)","v":{"$error":"#N/A"}}]
[null,null,null,"Does this SDG apply to your project?",null,null,"Select",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP('Sustainability Assessment'!M205,Sheet2!$C$4:$D$8,2,0)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,"No",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP('Sustainability Assessment'!M206,Sheet2!$C$4:$D$8,2,0)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(G207=\"Yes\",1,IF(G207=\"No\",0))","v":0},{"$f":"VLOOKUP('Sustainability Assessment'!M207,Sheet2!$C$4:$D$8,2,0)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP('Sustainability Assessment'!M208,Sheet2!$C$4:$D$8,2,0)","v":{"$error":"#N/A"}}]
[null,null,null,null,"Sustainable Cities & Communities",null,null,null,null,null,null,null,"Impact Rating",null,"RAG Result",null,null,null,null,null,null,{"$f":"VLOOKUP('Sustainability Assessment'!M209,Sheet2!$C$4:$D$8,2,0)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP('Sustainability Assessment'!M210,Sheet2!$C$4:$D$8,2,0)","v":{"$error":"#N/A"}}]
[null,null,null,null,"1. What will be the impact of this proposal on the availability and accessibility of housing in the local area? ",null,null,null,null,null,null,null,null,null,null,null,"Overall RAG",{"$f":"IF(U244=0,\"N/A\",IF(AND(U244<=0.74),\"RR\",IF(AND(U244>=0.75,U244<=0.99),\"A\",IF(U244=1,\"G\",IF(U244=\"x\",\"This is calculated when all questions have been answered\",\"\")))))","v":"N/A"},null,null,null,{"$f":"VLOOKUP('Sustainability Assessment'!M211,Sheet2!$C$4:$D$8,2,0)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M212=\"Long term or significant positive\",2,IF(M212=\"Short term positive\",2,IF(M212=\"None\",0,IF(M212=\"Short term negative\",1,IF(M212=\"Long term or significant negative\",1)))))","v":false},{"$f":"VLOOKUP('Sustainability Assessment'!M212,Sheet2!$C$4:$D$8,2,0)","v":{"$error":"#N/A"}}]
[null,null,null,null,"2. What will be the impact of this proposal on meeting specialist housing needs?",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP('Sustainability Assessment'!M213,Sheet2!$C$4:$D$8,2,0)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M214=\"Long term or significant positive\",2,IF(M214=\"Short term positive\",2,IF(M214=\"None\",0,IF(M214=\"Short term negative\",1,IF(M214=\"Long term or significant negative\",1)))))","v":false},{"$f":"VLOOKUP('Sustainability Assessment'!M214,Sheet2!$C$4:$D$8,2,0)","v":{"$error":"#N/A"}}]
[null,null,null,null,"3. What will be the impact of this proposal on the living conditions of local residents?",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP('Sustainability Assessment'!M215,Sheet2!$C$4:$D$8,2,0)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M216=\"Long term or significant positive\",2,IF(M216=\"Short term positive\",2,IF(M216=\"None\",0,IF(M216=\"Short term negative\",1,IF(M216=\"Long term or significant negative\",1)))))","v":false},{"$f":"VLOOKUP('Sustainability Assessment'!M216,Sheet2!$C$4:$D$8,2,0)","v":{"$error":"#N/A"}}]
[null,null,null,null,"4. What will be the impact of this proposal on those that are or at risk of homelessness?",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP('Sustainability Assessment'!M217,Sheet2!$C$4:$D$8,2,0)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M218=\"Long term or significant positive\",2,IF(M218=\"Short term positive\",2,IF(M218=\"None\",0,IF(M218=\"Short term negative\",1,IF(M218=\"Long term or significant negative\",1)))))","v":false},{"$f":"VLOOKUP('Sustainability Assessment'!M218,Sheet2!$C$4:$D$8,2,0)","v":{"$error":"#N/A"}}]
[null,null,null,null,"5. What will be the impact of this proposal on availability and accessibility of public transport?",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP('Sustainability Assessment'!M219,Sheet2!$C$4:$D$8,2,0)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M220=\"Long term or significant positive\",2,IF(M220=\"Short term positive\",2,IF(M220=\"None\",0,IF(M220=\"Short term negative\",1,IF(M220=\"Long term or significant negative\",1)))))","v":false},{"$f":"VLOOKUP('Sustainability Assessment'!M220,Sheet2!$C$4:$D$8,2,0)","v":{"$error":"#N/A"}}]
[null,null,null,null,"6. What will be the impact of this proposal on availability and accessibility of active travel? E.g. cycle lanes, cycle storage, walking routes",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP('Sustainability Assessment'!M221,Sheet2!$C$4:$D$8,2,0)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M222=\"Long term or significant positive\",2,IF(M222=\"Short term positive\",2,IF(M222=\"None\",0,IF(M222=\"Short term negative\",1,IF(M222=\"Long term or significant negative\",1)))))","v":false},{"$f":"VLOOKUP('Sustainability Assessment'!M222,Sheet2!$C$4:$D$8,2,0)","v":{"$error":"#N/A"}}]
[null,null,null,null,"7. What would be the impact of this proposal on other forms of transport? E.g. planes, scooters, boats ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP('Sustainability Assessment'!M223,Sheet2!$C$4:$D$8,2,0)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M224=\"Long term or significant positive\",2,IF(M224=\"Short term positive\",2,IF(M224=\"None\",0,IF(M224=\"Short term negative\",1,IF(M224=\"Long term or significant negative\",1)))))","v":false},{"$f":"VLOOKUP('Sustainability Assessment'!M224,Sheet2!$C$4:$D$8,2,0)","v":{"$error":"#N/A"}}]
[null,null,null,null,"8. What will be the impact of this proposal for the highway network?",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP('Sustainability Assessment'!M225,Sheet2!$C$4:$D$8,2,0)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M226=\"Long term or significant positive\",2,IF(M226=\"Short term positive\",2,IF(M226=\"None\",0,IF(M226=\"Short term negative\",1,IF(M226=\"Long term or significant negative\",1)))))","v":false},{"$f":"VLOOKUP('Sustainability Assessment'!M226,Sheet2!$C$4:$D$8,2,0)","v":{"$error":"#N/A"}}]
[null,null,null,null,"9. What will be the impact of this proposal for connecting areas across the borough and across the region? ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP('Sustainability Assessment'!M227,Sheet2!$C$4:$D$8,2,0)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M228=\"Long term or significant positive\",2,IF(M228=\"Short term positive\",2,IF(M228=\"None\",0,IF(M228=\"Short term negative\",1,IF(M228=\"Long term or significant negative\",1)))))","v":false},{"$f":"VLOOKUP('Sustainability Assessment'!M228,Sheet2!$C$4:$D$8,2,0)","v":{"$error":"#N/A"}}]
[null,null,null,null," 10. What will be the impact of this proposal on personal vehicle use, traffic volumes and car parking? ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP('Sustainability Assessment'!M229,Sheet2!$C$4:$D$8,2,0)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M230=\"Long term or significant positive\",2,IF(M230=\"Short term positive\",2,IF(M230=\"None\",0,IF(M230=\"Short term negative\",1,IF(M230=\"Long term or significant negative\",1)))))","v":false},{"$f":"VLOOKUP('Sustainability Assessment'!M230,Sheet2!$C$4:$D$8,2,0)","v":{"$error":"#N/A"}}]
[null,null,null,null,"11. What will be the impact of this proposal on low carbon transport and travel?  (e.g. green power for vehicles - electric, hydrogen, bio-fuels, car free commuting, car sharing etc.)?",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP('Sustainability Assessment'!M231,Sheet2!$C$4:$D$8,2,0)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M232=\"Long term or significant positive\",2,IF(M232=\"Short term positive\",2,IF(M232=\"None\",0,IF(M232=\"Short term negative\",1,IF(M232=\"Long term or significant negative\",1)))))","v":false},{"$f":"VLOOKUP('Sustainability Assessment'!M232,Sheet2!$C$4:$D$8,2,0)","v":{"$error":"#N/A"}}]
[null,null,null,null,"12.  What will be the impact of this proposal for  electric vehicle charging?",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP('Sustainability Assessment'!M233,Sheet2!$C$4:$D$8,2,0)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M234=\"Long term or significant positive\",2,IF(M234=\"Short term positive\",2,IF(M234=\"None\",0,IF(M234=\"Short term negative\",1,IF(M234=\"Long term or significant negative\",1)))))","v":false},{"$f":"VLOOKUP('Sustainability Assessment'!M234,Sheet2!$C$4:$D$8,2,0)","v":{"$error":"#N/A"}}]
[null,null,null,null,"13. What will be the impact of this proposal on air quality? E.g. carbon emissions from transport, business, homes, energy, agriculture, waste, industry, land use",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP('Sustainability Assessment'!M235,Sheet2!$C$4:$D$8,2,0)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M236=\"Long term or significant positive\",2,IF(M236=\"Short term positive\",2,IF(M236=\"None\",0,IF(M236=\"Short term negative\",1,IF(M236=\"Long term or significant negative\",1)))))","v":false},{"$f":"VLOOKUP('Sustainability Assessment'!M236,Sheet2!$C$4:$D$8,2,0)","v":{"$error":"#N/A"}}]
[null,null,null,null,"14. What will be the impact of this proposal on loss of habitats from development and biodiversity net gain?",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP('Sustainability Assessment'!M237,Sheet2!$C$4:$D$8,2,0)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M238=\"Long term or significant positive\",2,IF(M238=\"Short term positive\",2,IF(M238=\"None\",0,IF(M238=\"Short term negative\",1,IF(M238=\"Long term or significant negative\",1)))))","v":false},{"$f":"VLOOKUP('Sustainability Assessment'!M238,Sheet2!$C$4:$D$8,2,0)","v":{"$error":"#N/A"}}]
[null,null,null,null,"15. What will be the impact of this proposal in protecting and promoting culture and heritage in the local area?",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP('Sustainability Assessment'!M239,Sheet2!$C$4:$D$8,2,0)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M240=\"Long term or significant positive\",2,IF(M240=\"Short term positive\",2,IF(M240=\"None\",0,IF(M240=\"Short term negative\",1,IF(M240=\"Long term or significant negative\",1)))))","v":false},{"$f":"VLOOKUP('Sustainability Assessment'!M240,Sheet2!$C$4:$D$8,2,0)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP('Sustainability Assessment'!M241,Sheet2!$C$4:$D$8,2,0)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR((SUM(U213:U241))/((COUNTIF(U213:U241,\">0\")*2)),\"0\")","v":"0"},{"$f":"VLOOKUP('Sustainability Assessment'!M242,Sheet2!$C$4:$D$8,2,0)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(U243,2)","v":0},{"$f":"VLOOKUP('Sustainability Assessment'!M243,Sheet2!$C$4:$D$8,2,0)","v":{"$error":"#N/A"}}]
[null,null,null,"Does this SDG apply to your project?",null,null,"Select",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP('Sustainability Assessment'!M244,Sheet2!$C$4:$D$8,2,0)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,"Yes",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP('Sustainability Assessment'!M245,Sheet2!$C$4:$D$8,2,0)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(G246=\"Yes\",1,IF(G246=\"No\",0))","v":1},{"$f":"VLOOKUP('Sustainability Assessment'!M246,Sheet2!$C$4:$D$8,2,0)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP('Sustainability Assessment'!M247,Sheet2!$C$4:$D$8,2,0)","v":{"$error":"#N/A"}}]
[null,null,null,null,"Responsible Consumption & Production",null,null,null,null,null,null,null,"Impact Rating",null,"RAG Result",null,null,null,null,null,null,{"$f":"VLOOKUP('Sustainability Assessment'!M248,Sheet2!$C$4:$D$8,2,0)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP('Sustainability Assessment'!M249,Sheet2!$C$4:$D$8,2,0)","v":{"$error":"#N/A"}}]
[null,null,null,null,"1. What will be the impact of this proposal on use of fossil fuels?",null,null,null,null,null,null,null,"Long term or significant positive",null,null,null,"Overall RAG",{"$f":"IF(U279=0,\"N/A\",IF(AND(U279<=0.74),\"RR\",IF(AND(U279>=0.75,U279<=0.99),\"A\",IF(U279=1,\"G\",IF(U279=\"x\",\"This is calculated when all questions have been answered\",\"\")))))","v":"G"},null,null,null,{"$f":"VLOOKUP('Sustainability Assessment'!M250,Sheet2!$C$4:$D$8,2,0)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M251=\"Long term or significant positive\",2,IF(M251=\"Short term positive\",2,IF(M251=\"None\",0,IF(M251=\"Short term negative\",1,IF(M251=\"Long term or significant negative\",1)))))","v":2},{"$f":"VLOOKUP('Sustainability Assessment'!M251,Sheet2!$C$4:$D$8,2,0)","v":1}]
[null,null,null,null,"2. What will be then impact of this proposal on carbon capture, storage and offsetting? ",null,null,null,null,null,null,null,"Long term or significant positive",null,null,null,null,null,null,null,null,{"$f":"VLOOKUP('Sustainability Assessment'!M252,Sheet2!$C$4:$D$8,2,0)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M253=\"Long term or significant positive\",2,IF(M253=\"Short term positive\",2,IF(M253=\"None\",0,IF(M253=\"Short term negative\",1,IF(M253=\"Long term or significant negative\",1)))))","v":2},{"$f":"VLOOKUP('Sustainability Assessment'!M253,Sheet2!$C$4:$D$8,2,0)","v":1}]
[null,null,null,null,"3. What will be the impact of this proposal on importing and exporting goods?",null,null,null,null,null,null,null,"None",null,null,null,null,null,null,null,null,{"$f":"VLOOKUP('Sustainability Assessment'!M254,Sheet2!$C$4:$D$8,2,0)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M255=\"Long term or significant positive\",2,IF(M255=\"Short term positive\",2,IF(M255=\"None\",0,IF(M255=\"Short term negative\",1,IF(M255=\"Long term or significant negative\",1)))))","v":0},{"$f":"VLOOKUP('Sustainability Assessment'!M255,Sheet2!$C$4:$D$8,2,0)","v":3}]
[null,null,null,null,"4. What will be the impact of this proposal on the production and use of building and construction materials that are harmful to the environment? E.g. concrete, aluminium, steel etc. ",null,null,null,null,null,null,null,"None",null,null,null,null,null,null,null,null,{"$f":"VLOOKUP('Sustainability Assessment'!M256,Sheet2!$C$4:$D$8,2,0)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M257=\"Long term or significant positive\",2,IF(M257=\"Short term positive\",2,IF(M257=\"None\",0,IF(M257=\"Short term negative\",1,IF(M257=\"Long term or significant negative\",1)))))","v":0},{"$f":"VLOOKUP('Sustainability Assessment'!M257,Sheet2!$C$4:$D$8,2,0)","v":3}]
[null,null,null,null,"5. What will be the impact of this proposal on the production and use of refrigerants, propellants or blowing agents (chlorofluorocarbons)?",null,null,null,null,null,null,null,"None",null,null,null,null,null,null,null,null,{"$f":"VLOOKUP('Sustainability Assessment'!M258,Sheet2!$C$4:$D$8,2,0)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M259=\"Long term or significant positive\",2,IF(M259=\"Short term positive\",2,IF(M259=\"None\",0,IF(M259=\"Short term negative\",1,IF(M259=\"Long term or significant negative\",1)))))","v":0},{"$f":"VLOOKUP('Sustainability Assessment'!M259,Sheet2!$C$4:$D$8,2,0)","v":3}]
[null,null,null,null,"6. What will be the impact of this proposal on the release of substantial dust? E.g. from quarrying, excavation",null,null,null,null,null,null,null,"None",null,null,null,null,null,null,null,null,{"$f":"VLOOKUP('Sustainability Assessment'!M260,Sheet2!$C$4:$D$8,2,0)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M261=\"Long term or significant positive\",2,IF(M261=\"Short term positive\",2,IF(M261=\"None\",0,IF(M261=\"Short term negative\",1,IF(M261=\"Long term or significant negative\",1)))))","v":0},{"$f":"VLOOKUP('Sustainability Assessment'!M261,Sheet2!$C$4:$D$8,2,0)","v":3}]
[null,null,null,null,"7. What will be the impact of this proposal on the use of fertiliser /pesticides?",null,null,null,null,null,null,null,"None",null,null,null,null,null,null,null,null,{"$f":"VLOOKUP('Sustainability Assessment'!M262,Sheet2!$C$4:$D$8,2,0)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M263=\"Long term or significant positive\",2,IF(M263=\"Short term positive\",2,IF(M263=\"None\",0,IF(M263=\"Short term negative\",1,IF(M263=\"Long term or significant negative\",1)))))","v":0},{"$f":"VLOOKUP('Sustainability Assessment'!M263,Sheet2!$C$4:$D$8,2,0)","v":3}]
[null,null,null,null,"8. What will be the impact of this proposal on the use of plastic?",null,null,null,null,null,null,null,"None",null,null,null,null,null,null,null,null,{"$f":"VLOOKUP('Sustainability Assessment'!M264,Sheet2!$C$4:$D$8,2,0)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M265=\"Long term or significant positive\",2,IF(M265=\"Short term positive\",2,IF(M265=\"None\",0,IF(M265=\"Short term negative\",1,IF(M265=\"Long term or significant negative\",1)))))","v":0},{"$f":"VLOOKUP('Sustainability Assessment'!M265,Sheet2!$C$4:$D$8,2,0)","v":3}]
[null,null,null,null,"9. What will be the impact of this proposal on sustainable consumption and production of carbon intensive foods such as meat and dairy ?",null,null,null,null,null,null,null,"None",null,null,null,null,null,null,null,null,{"$f":"VLOOKUP('Sustainability Assessment'!M266,Sheet2!$C$4:$D$8,2,0)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M267=\"Long term or significant positive\",2,IF(M267=\"Short term positive\",2,IF(M267=\"None\",0,IF(M267=\"Short term negative\",1,IF(M267=\"Long term or significant negative\",1)))))","v":0},{"$f":"VLOOKUP('Sustainability Assessment'!M267,Sheet2!$C$4:$D$8,2,0)","v":3}]
[null,null,null,null,"10. What will be the impact of this proposal on the production of waste, including food waste? ",null,null,null,null,null,null,null,"None",null,null,null,null,null,null,null,null,{"$f":"VLOOKUP('Sustainability Assessment'!M268,Sheet2!$C$4:$D$8,2,0)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M269=\"Long term or significant positive\",2,IF(M269=\"Short term positive\",2,IF(M269=\"None\",0,IF(M269=\"Short term negative\",1,IF(M269=\"Long term or significant negative\",1)))))","v":0},{"$f":"VLOOKUP('Sustainability Assessment'!M269,Sheet2!$C$4:$D$8,2,0)","v":3}]
[null,null,null,null,"11. What will be the impact of this proposal on the production of toxic waste?",null,null,null,null,null,null,null,"None",null,null,null,null,null,null,null,null,{"$f":"VLOOKUP('Sustainability Assessment'!M270,Sheet2!$C$4:$D$8,2,0)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M271=\"Long term or significant positive\",2,IF(M271=\"Short term positive\",2,IF(M271=\"None\",0,IF(M271=\"Short term negative\",1,IF(M271=\"Long term or significant negative\",1)))))","v":0},{"$f":"VLOOKUP('Sustainability Assessment'!M271,Sheet2!$C$4:$D$8,2,0)","v":3}]
[null,null,null,null,"12. What will be the impact of this proposal on the circular economy? E.g. reducing, recycling and reusing",null,null,null,null,null,null,null,"None",null,null,null,null,null,null,null,null,{"$f":"VLOOKUP('Sustainability Assessment'!M272,Sheet2!$C$4:$D$8,2,0)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M273=\"Long term or significant positive\",2,IF(M273=\"Short term positive\",2,IF(M273=\"None\",0,IF(M273=\"Short term negative\",1,IF(M273=\"Long term or significant negative\",1)))))","v":0},{"$f":"VLOOKUP('Sustainability Assessment'!M273,Sheet2!$C$4:$D$8,2,0)","v":3}]
[null,null,null,null,"13. What will be the impact of this proposal on the incineration of waste?",null,null,null,null,null,null,null,"None",null,null,null,null,null,null,null,null,{"$f":"VLOOKUP('Sustainability Assessment'!M274,Sheet2!$C$4:$D$8,2,0)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M275=\"Long term or significant positive\",2,IF(M275=\"Short term positive\",2,IF(M275=\"None\",0,IF(M275=\"Short term negative\",1,IF(M275=\"Long term or significant negative\",1)))))","v":0},{"$f":"VLOOKUP('Sustainability Assessment'!M275,Sheet2!$C$4:$D$8,2,0)","v":3}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP('Sustainability Assessment'!M276,Sheet2!$C$4:$D$8,2,0)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR((SUM(U252:U276))/((COUNTIF(U252:U276,\">0\")*2)),\"0\")","v":1},{"$f":"VLOOKUP('Sustainability Assessment'!M277,Sheet2!$C$4:$D$8,2,0)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(U278,2)","v":1},{"$f":"VLOOKUP('Sustainability Assessment'!M278,Sheet2!$C$4:$D$8,2,0)","v":{"$error":"#N/A"}}]
[null,null,null,"Does this SDG apply to your project?",null,null,"Select",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP('Sustainability Assessment'!M279,Sheet2!$C$4:$D$8,2,0)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,"Yes",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP('Sustainability Assessment'!M280,Sheet2!$C$4:$D$8,2,0)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(G281=\"Yes\",1,IF(G281=\"No\",0))","v":1},{"$f":"VLOOKUP('Sustainability Assessment'!M281,Sheet2!$C$4:$D$8,2,0)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP('Sustainability Assessment'!M282,Sheet2!$C$4:$D$8,2,0)","v":{"$error":"#N/A"}}]
[null,null,null,null,"Climate Action",null,null,null,null,null,null,null,"Impact Rating",null,"RAG Result",null,null,null,null,null,null,{"$f":"VLOOKUP('Sustainability Assessment'!M283,Sheet2!$C$4:$D$8,2,0)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP('Sustainability Assessment'!M284,Sheet2!$C$4:$D$8,2,0)","v":{"$error":"#N/A"}}]
[null,null,null,null,"1. What will be the impact of this proposal on building resilience or adapting to climate related hazards and extreme events, shocks and disasters? E.g. flooding, drought, wildfires, slope failure, storm damage, soil heave",null,null,null,null,null,null,null,"Long term or significant positive",null,null,null,"Overall RAG",{"$f":"IF(U292=0,\"N/A\",IF(AND(U292<=0.74),\"RR\",IF(AND(U292>=0.75,U292<=0.99),\"A\",IF(U292=1,\"G\",IF(U292=\"x\",\"This is calculated when all questions have been answered\",\"\")))))","v":"G"},null,null,null,{"$f":"VLOOKUP('Sustainability Assessment'!M285,Sheet2!$C$4:$D$8,2,0)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M286=\"Long term or significant positive\",2,IF(M286=\"Short term positive\",2,IF(M286=\"None\",0,IF(M286=\"Short term negative\",1,IF(M286=\"Long term or significant negative\",1)))))","v":2},{"$f":"VLOOKUP('Sustainability Assessment'!M286,Sheet2!$C$4:$D$8,2,0)","v":1}]
[null,null,null,null,"2. What will be the impact of this proposal in raising awareness and building human capacity on climate change mitigation and adaptation? E.g. carbon literacy, green skills, green proposals",null,null,null,null,null,null,null,"None",null,null,null,null,null,null,null,null,{"$f":"VLOOKUP('Sustainability Assessment'!M287,Sheet2!$C$4:$D$8,2,0)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M288=\"Long term or significant positive\",2,IF(M288=\"Short term positive\",2,IF(M288=\"None\",0,IF(M288=\"Short term negative\",1,IF(M288=\"Long term or significant negative\",1)))))","v":0},{"$f":"VLOOKUP('Sustainability Assessment'!M288,Sheet2!$C$4:$D$8,2,0)","v":3}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP('Sustainability Assessment'!M289,Sheet2!$C$4:$D$8,2,0)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR((SUM(U287:U289))/((COUNTIF(U287:U289,\">0\")*2)),\"0\")","v":1},{"$f":"VLOOKUP('Sustainability Assessment'!M290,Sheet2!$C$4:$D$8,2,0)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(U291,2)","v":1},{"$f":"VLOOKUP('Sustainability Assessment'!M291,Sheet2!$C$4:$D$8,2,0)","v":{"$error":"#N/A"}}]
[null,null,null,"Does this SDG apply to your project?",null,null,"Select",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP('Sustainability Assessment'!M292,Sheet2!$C$4:$D$8,2,0)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,"Yes",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP('Sustainability Assessment'!M293,Sheet2!$C$4:$D$8,2,0)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(G294=\"Yes\",1,IF(G294=\"No\",0))","v":1},{"$f":"VLOOKUP('Sustainability Assessment'!M294,Sheet2!$C$4:$D$8,2,0)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP('Sustainability Assessment'!M295,Sheet2!$C$4:$D$8,2,0)","v":{"$error":"#N/A"}}]
[null,null,null,null,"Life Below Water",null,null,null,null,null,null,null,"Impact Rating",null,"RAG Result",null,null,null,null,null,null,{"$f":"VLOOKUP('Sustainability Assessment'!M296,Sheet2!$C$4:$D$8,2,0)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP('Sustainability Assessment'!M297,Sheet2!$C$4:$D$8,2,0)","v":{"$error":"#N/A"}}]
[null,null,null,null,"1. What will be the impact of this proposal on creating, enhancing or protecting aquatic and marine habitats?",null,null,null,null,null,null,null,"Long term or significant positive",null,null,null,"Overall RAG",{"$f":"IF(U305=0,\"N/A\",IF(AND(U305<=0.74),\"RR\",IF(AND(U305>=0.75,U305<=0.99),\"A\",IF(U305=1,\"G\",IF(U305=\"x\",\"This is calculated when all questions have been answered\",\"\")))))","v":"G"},null,null,null,{"$f":"VLOOKUP('Sustainability Assessment'!M298,Sheet2!$C$4:$D$8,2,0)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M299=\"Long term or significant positive\",2,IF(M299=\"Short term positive\",2,IF(M299=\"None\",0,IF(M299=\"Short term negative\",1,IF(M299=\"Long term or significant negative\",1)))))","v":2},{"$f":"VLOOKUP('Sustainability Assessment'!M299,Sheet2!$C$4:$D$8,2,0)","v":1}]
[null,null,null,null,"2. What will be the impact of this proposal on fishing or other activities that might affect aquatic and marine wildlife?",null,null,null,null,null,null,null,"None",null,null,null,null,null,null,null,null,{"$f":"VLOOKUP('Sustainability Assessment'!M300,Sheet2!$C$4:$D$8,2,0)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M301=\"Long term or significant positive\",2,IF(M301=\"Short term positive\",2,IF(M301=\"None\",0,IF(M301=\"Short term negative\",1,IF(M301=\"Long term or significant negative\",1)))))","v":0},{"$f":"VLOOKUP('Sustainability Assessment'!M301,Sheet2!$C$4:$D$8,2,0)","v":3}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP('Sustainability Assessment'!M302,Sheet2!$C$4:$D$8,2,0)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR((SUM(U299:U302))/((COUNTIF(U299:U302,\">0\")*2)),\"0\")","v":1},{"$f":"VLOOKUP('Sustainability Assessment'!M303,Sheet2!$C$4:$D$8,2,0)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(U304,2)","v":1},{"$f":"VLOOKUP('Sustainability Assessment'!M304,Sheet2!$C$4:$D$8,2,0)","v":{"$error":"#N/A"}}]
[null,null,null,"Does this SDG apply to your project?",null,null,"Select",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP('Sustainability Assessment'!M305,Sheet2!$C$4:$D$8,2,0)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,"Yes",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP('Sustainability Assessment'!M306,Sheet2!$C$4:$D$8,2,0)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(G307=\"Yes\",1,IF(G307=\"No\",0))","v":1},{"$f":"VLOOKUP('Sustainability Assessment'!M307,Sheet2!$C$4:$D$8,2,0)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP('Sustainability Assessment'!M308,Sheet2!$C$4:$D$8,2,0)","v":{"$error":"#N/A"}}]
[null,null,null,null,"Life On Land",null,null,null,null,null,null,null,"Impact Rating",null,"RAG Result",null,null,null,null,null,null,{"$f":"VLOOKUP('Sustainability Assessment'!M309,Sheet2!$C$4:$D$8,2,0)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP('Sustainability Assessment'!M310,Sheet2!$C$4:$D$8,2,0)","v":{"$error":"#N/A"}}]
[null,null,null,null,"1. What will be the impact of this proposal on forestry, green spaces, peatland etc. in terms of degradation or improvement?",null,null,null,null,null,null,null,"Long term or significant positive",null,null,null,"Overall RAG",{"$f":"IF(U324=0,\"N/A\",IF(AND(U324<=0.74),\"RR\",IF(AND(U324>=0.75,U324<=0.99),\"A\",IF(U324=1,\"G\",IF(U324=\"x\",\"This is calculated when all questions have been answered\",\"\")))))","v":"G"},null,null,null,{"$f":"VLOOKUP('Sustainability Assessment'!M311,Sheet2!$C$4:$D$8,2,0)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M312=\"Long term or significant positive\",2,IF(M312=\"Short term positive\",2,IF(M312=\"None\",0,IF(M312=\"Short term negative\",1,IF(M312=\"Long term or significant negative\",1)))))","v":2},{"$f":"VLOOKUP('Sustainability Assessment'!M312,Sheet2!$C$4:$D$8,2,0)","v":1}]
[null,null,null,null,"2. What will be the impact of this proposal on the management and use of land? E.g. erosion, agriculture, construction, waste etc. ",null,null,null,null,null,null,null,"Long term or significant positive",null,null,null,null,null,null,null,null,{"$f":"VLOOKUP('Sustainability Assessment'!M313,Sheet2!$C$4:$D$8,2,0)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M314=\"Long term or significant positive\",2,IF(M314=\"Short term positive\",2,IF(M314=\"None\",0,IF(M314=\"Short term negative\",1,IF(M314=\"Long term or significant negative\",1)))))","v":2},{"$f":"VLOOKUP('Sustainability Assessment'!M314,Sheet2!$C$4:$D$8,2,0)","v":1}]
[null,null,null,null,"3. What will be the impact of this proposal on creating, enhancing or protecting wildlife habitats? ",null,null,null,null,null,null,null,"Long term or significant positive",null,null,null,null,null,null,null,null,{"$f":"VLOOKUP('Sustainability Assessment'!M315,Sheet2!$C$4:$D$8,2,0)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M316=\"Long term or significant positive\",2,IF(M316=\"Short term positive\",2,IF(M316=\"None\",0,IF(M316=\"Short term negative\",1,IF(M316=\"Long term or significant negative\",1)))))","v":2},{"$f":"VLOOKUP('Sustainability Assessment'!M316,Sheet2!$C$4:$D$8,2,0)","v":1}]
[null,null,null,null,"4. What will be the impact of this proposal on hunting or other activities that might affect wildlife?",null,null,null,null,null,null,null,"None",null,null,null,null,null,null,null,null,{"$f":"VLOOKUP('Sustainability Assessment'!M317,Sheet2!$C$4:$D$8,2,0)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M318=\"Long term or significant positive\",2,IF(M318=\"Short term positive\",2,IF(M318=\"None\",0,IF(M318=\"Short term negative\",1,IF(M318=\"Long term or significant negative\",1)))))","v":0},{"$f":"VLOOKUP('Sustainability Assessment'!M318,Sheet2!$C$4:$D$8,2,0)","v":3}]
[null,null,null,null,"5. What will be the impact of this proposal on the emergence of invasive species and pathogens being introduced?",null,null,null,null,null,null,null,"None",null,null,null,null,null,null,null,null,{"$f":"VLOOKUP('Sustainability Assessment'!M319,Sheet2!$C$4:$D$8,2,0)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M320=\"Long term or significant positive\",2,IF(M320=\"Short term positive\",2,IF(M320=\"None\",0,IF(M320=\"Short term negative\",1,IF(M320=\"Long term or significant negative\",1)))))","v":0},{"$f":"VLOOKUP('Sustainability Assessment'!M320,Sheet2!$C$4:$D$8,2,0)","v":3}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP('Sustainability Assessment'!M321,Sheet2!$C$4:$D$8,2,0)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR((SUM(U313:U321))/((COUNTIF(U313:U321,\">0\")*2)),\"0\")","v":1},{"$f":"VLOOKUP('Sustainability Assessment'!M322,Sheet2!$C$4:$D$8,2,0)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(U323,2)","v":1},{"$f":"VLOOKUP('Sustainability Assessment'!M323,Sheet2!$C$4:$D$8,2,0)","v":{"$error":"#N/A"}}]
[null,null,null,"Does this SDG apply to your project?",null,null,"Select",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP('Sustainability Assessment'!M324,Sheet2!$C$4:$D$8,2,0)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,"Yes",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP('Sustainability Assessment'!M325,Sheet2!$C$4:$D$8,2,0)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(G326=\"Yes\",1,IF(G326=\"No\",0))","v":1},{"$f":"VLOOKUP('Sustainability Assessment'!M326,Sheet2!$C$4:$D$8,2,0)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP('Sustainability Assessment'!M327,Sheet2!$C$4:$D$8,2,0)","v":{"$error":"#N/A"}}]
[null,null,null,null,"Peace, Justice & Strong Institutions",null,null,null,null,null,null,null,"Impact Rating",null,"RAG Result",null,null,null,null,null,null,{"$f":"VLOOKUP('Sustainability Assessment'!M328,Sheet2!$C$4:$D$8,2,0)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP('Sustainability Assessment'!M329,Sheet2!$C$4:$D$8,2,0)","v":{"$error":"#N/A"}}]
[null,null,null,null,"1. What will be the impact of this proposal on crime in the local area?",null,null,null,null,null,null,null,"Long term or significant positive",null,null,null,"Overall RAG",{"$f":"IF(U351=0,\"N/A\",IF(AND(U351<=0.74),\"RR\",IF(AND(U351>=0.75,U351<=0.99),\"A\",IF(U351=1,\"G\",IF(U351=\"x\",\"This is calculated when all questions have been answered\",\"\")))))","v":"A"},null,null,null,{"$f":"VLOOKUP('Sustainability Assessment'!M330,Sheet2!$C$4:$D$8,2,0)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M331=\"Long term or significant positive\",2,IF(M331=\"Short term positive\",2,IF(M331=\"None\",0,IF(M331=\"Short term negative\",1,IF(M331=\"Long term or significant negative\",1)))))","v":2},{"$f":"VLOOKUP('Sustainability Assessment'!M331,Sheet2!$C$4:$D$8,2,0)","v":1}]
[null,null,null,null,"2. What will be the impact of this proposal on anti-social behaviour in the local area?",null,null,null,null,null,null,null,"Long term or significant positive",null,null,null,null,null,null,null,null,{"$f":"VLOOKUP('Sustainability Assessment'!M332,Sheet2!$C$4:$D$8,2,0)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M333=\"Long term or significant positive\",2,IF(M333=\"Short term positive\",2,IF(M333=\"None\",0,IF(M333=\"Short term negative\",1,IF(M333=\"Long term or significant negative\",1)))))","v":2},{"$f":"VLOOKUP('Sustainability Assessment'!M333,Sheet2!$C$4:$D$8,2,0)","v":1}]
[null,null,null,null,"3. What will be the impact of this proposal for victims?",null,null,null,null,null,null,null,"Long term or significant positive",null,null,null,null,null,null,null,null,{"$f":"VLOOKUP('Sustainability Assessment'!M334,Sheet2!$C$4:$D$8,2,0)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M335=\"Long term or significant positive\",2,IF(M335=\"Short term positive\",2,IF(M335=\"None\",0,IF(M335=\"Short term negative\",1,IF(M335=\"Long term or significant negative\",1)))))","v":2},{"$f":"VLOOKUP('Sustainability Assessment'!M335,Sheet2!$C$4:$D$8,2,0)","v":1}]
[null,null,null,null,"4. What will be the impact of this proposal for perpetrators?",null,null,null,null,null,null,null,"Short term negative",null,null,null,null,null,null,null,null,{"$f":"VLOOKUP('Sustainability Assessment'!M336,Sheet2!$C$4:$D$8,2,0)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M337=\"Long term or significant positive\",2,IF(M337=\"Short term positive\",2,IF(M337=\"None\",0,IF(M337=\"Short term negative\",1,IF(M337=\"Long term or significant negative\",1)))))","v":1},{"$f":"VLOOKUP('Sustainability Assessment'!M337,Sheet2!$C$4:$D$8,2,0)","v":4}]
[null,null,null,null,"5. What will be the impact of this proposal on making public places, spaces and buildings safe and secure?",null,null,null,null,null,null,null,"Long term or significant positive",null,null,null,null,null,null,null,null,{"$f":"VLOOKUP('Sustainability Assessment'!M338,Sheet2!$C$4:$D$8,2,0)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M339=\"Long term or significant positive\",2,IF(M339=\"Short term positive\",2,IF(M339=\"None\",0,IF(M339=\"Short term negative\",1,IF(M339=\"Long term or significant negative\",1)))))","v":2},{"$f":"VLOOKUP('Sustainability Assessment'!M339,Sheet2!$C$4:$D$8,2,0)","v":1}]
[null,null,null,null,"6. What will be the impact of this proposal on safeguarding local people?",null,null,null,null,null,null,null,"Long term or significant positive",null,null,null,null,null,null,null,null,{"$f":"VLOOKUP('Sustainability Assessment'!M340,Sheet2!$C$4:$D$8,2,0)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M341=\"Long term or significant positive\",2,IF(M341=\"Short term positive\",2,IF(M341=\"None\",0,IF(M341=\"Short term negative\",1,IF(M341=\"Long term or significant negative\",1)))))","v":2},{"$f":"VLOOKUP('Sustainability Assessment'!M341,Sheet2!$C$4:$D$8,2,0)","v":1}]
[null,null,null,null,"7. What will be the impact of this proposal on bringing communities together and supporting cohesion?",null,null,null,null,null,null,null,"None",null,null,null,null,null,null,null,null,{"$f":"VLOOKUP('Sustainability Assessment'!M342,Sheet2!$C$4:$D$8,2,0)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M343=\"Long term or significant positive\",2,IF(M343=\"Short term positive\",2,IF(M343=\"None\",0,IF(M343=\"Short term negative\",1,IF(M343=\"Long term or significant negative\",1)))))","v":0},{"$f":"VLOOKUP('Sustainability Assessment'!M343,Sheet2!$C$4:$D$8,2,0)","v":3}]
[null,null,null,null,"8. What will be the impact of this proposal on opportunities for local people to celebrate their culture, heritage and identity?",null,null,null,null,null,null,null,"None",null,null,null,null,null,null,null,null,{"$f":"VLOOKUP('Sustainability Assessment'!M344,Sheet2!$C$4:$D$8,2,0)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M345=\"Long term or significant positive\",2,IF(M345=\"Short term positive\",2,IF(M345=\"None\",0,IF(M345=\"Short term negative\",1,IF(M345=\"Long term or significant negative\",1)))))","v":0},{"$f":"VLOOKUP('Sustainability Assessment'!M345,Sheet2!$C$4:$D$8,2,0)","v":3}]
[null,null,null,null,"9. What will be the impact of this proposal on opportunities for local people to contribute in their local community?",null,null,null,null,null,null,null,"None",null,null,null,null,null,null,null,null,{"$f":"VLOOKUP('Sustainability Assessment'!M346,Sheet2!$C$4:$D$8,2,0)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M347=\"Long term or significant positive\",2,IF(M347=\"Short term positive\",2,IF(M347=\"None\",0,IF(M347=\"Short term negative\",1,IF(M347=\"Long term or significant negative\",1)))))","v":0},{"$f":"VLOOKUP('Sustainability Assessment'!M347,Sheet2!$C$4:$D$8,2,0)","v":3}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP('Sustainability Assessment'!M348,Sheet2!$C$4:$D$8,2,0)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR((SUM(U332:U348))/((COUNTIF(U332:U348,\">0\")*2)),\"0\")","v":0.91666666666666663},{"$f":"VLOOKUP('Sustainability Assessment'!M349,Sheet2!$C$4:$D$8,2,0)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(U350,2)","v":0.92},{"$f":"VLOOKUP('Sustainability Assessment'!M350,Sheet2!$C$4:$D$8,2,0)","v":{"$error":"#N/A"}}]
[null,null,null,"Does this SDG apply to your project?",null,null,"Select",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP('Sustainability Assessment'!M351,Sheet2!$C$4:$D$8,2,0)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,"Yes",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP('Sustainability Assessment'!M352,Sheet2!$C$4:$D$8,2,0)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(G353=\"Yes\",1,IF(G353=\"No\",0))","v":1},{"$f":"VLOOKUP('Sustainability Assessment'!M353,Sheet2!$C$4:$D$8,2,0)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP('Sustainability Assessment'!M354,Sheet2!$C$4:$D$8,2,0)","v":{"$error":"#N/A"}}]
[null,null,null,null,"Partnerships For The Goals",null,null,null,null,null,null,null,"Impact Rating",null,"RAG Result",null,null,null,null,null,null,{"$f":"VLOOKUP('Sustainability Assessment'!M355,Sheet2!$C$4:$D$8,2,0)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP('Sustainability Assessment'!M356,Sheet2!$C$4:$D$8,2,0)","v":{"$error":"#N/A"}}]
[null,null,null,null,"1. What will be the impact of this proposal on the participation of local people in decision making?",null,null,null,null,null,null,null,"None",null,null,null,"Overall RAG",{"$f":"IF(U376=0,\"N/A\",IF(AND(U376<=0.74),\"RR\",IF(AND(U376>=0.75,U376<=0.99),\"A\",IF(U376=1,\"G\",IF(U376=\"x\",\"This is calculated when all questions have been answered\",\"\")))))","v":"G"},null,null,null,{"$f":"VLOOKUP('Sustainability Assessment'!M357,Sheet2!$C$4:$D$8,2,0)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M358=\"Long term or significant positive\",2,IF(M358=\"Short term positive\",2,IF(M358=\"None\",0,IF(M358=\"Short term negative\",1,IF(M358=\"Long term or significant negative\",1)))))","v":0},{"$f":"VLOOKUP('Sustainability Assessment'!M358,Sheet2!$C$4:$D$8,2,0)","v":3}]
[null,null,null,null,"2. What will be the impact of this proposal on local people in co-designing services? (involving them in developing initiatives, and strategies that affect them)",null,null,null,null,null,null,null,"None",null,null,null,null,null,null,null,null,{"$f":"VLOOKUP('Sustainability Assessment'!M359,Sheet2!$C$4:$D$8,2,0)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M360=\"Long term or significant positive\",2,IF(M360=\"Short term positive\",2,IF(M360=\"None\",0,IF(M360=\"Short term negative\",1,IF(M360=\"Long term or significant negative\",1)))))","v":0},{"$f":"VLOOKUP('Sustainability Assessment'!M360,Sheet2!$C$4:$D$8,2,0)","v":3}]
[null,null,null,null,"3. What will be the impact of this proposal on local people in co-producing services?\n(involving them in planning and delivering services that they need and want)",null,null,null,null,null,null,null,"None",null,null,null,null,null,null,null,null,{"$f":"VLOOKUP('Sustainability Assessment'!M361,Sheet2!$C$4:$D$8,2,0)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M362=\"Long term or significant positive\",2,IF(M362=\"Short term positive\",2,IF(M362=\"None\",0,IF(M362=\"Short term negative\",1,IF(M362=\"Long term or significant negative\",1)))))","v":0},{"$f":"VLOOKUP('Sustainability Assessment'!M362,Sheet2!$C$4:$D$8,2,0)","v":3}]
[null,null,null,null,"4. What will be the impact of this proposal on local political participation?",null,null,null,null,null,null,null,"None",null,null,null,null,null,null,null,null,{"$f":"VLOOKUP('Sustainability Assessment'!M363,Sheet2!$C$4:$D$8,2,0)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M364=\"Long term or significant positive\",2,IF(M364=\"Short term positive\",2,IF(M364=\"None\",0,IF(M364=\"Short term negative\",1,IF(M364=\"Long term or significant negative\",1)))))","v":0},{"$f":"VLOOKUP('Sustainability Assessment'!M364,Sheet2!$C$4:$D$8,2,0)","v":3}]
[null,null,null,null,"5. What will be the impact of this proposal on how local people are engaged, consulted and communicated with?  ",null,null,null,null,null,null,null,"Long term or significant positive",null,null,null,null,null,null,null,null,{"$f":"VLOOKUP('Sustainability Assessment'!M365,Sheet2!$C$4:$D$8,2,0)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M366=\"Long term or significant positive\",2,IF(M366=\"Short term positive\",2,IF(M366=\"None\",0,IF(M366=\"Short term negative\",1,IF(M366=\"Long term or significant negative\",1)))))","v":2},{"$f":"VLOOKUP('Sustainability Assessment'!M366,Sheet2!$C$4:$D$8,2,0)","v":1}]
[null,null,null,null,"6. What will be the impact of this proposal on the opportunities for partnership working?",null,null,null,null,null,null,null,"Long term or significant positive",null,null,null,null,null,null,null,null,{"$f":"VLOOKUP('Sustainability Assessment'!M367,Sheet2!$C$4:$D$8,2,0)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M368=\"Long term or significant positive\",2,IF(M368=\"Short term positive\",2,IF(M368=\"None\",0,IF(M368=\"Short term negative\",1,IF(M368=\"Long term or significant negative\",1)))))","v":2},{"$f":"VLOOKUP('Sustainability Assessment'!M368,Sheet2!$C$4:$D$8,2,0)","v":1}]
[null,null,null,null,"7. What will be the impact of this proposal on access to information and data?",null,null,null,null,null,null,null,"Long term or significant positive",null,null,null,null,null,null,null,null,{"$f":"VLOOKUP('Sustainability Assessment'!M369,Sheet2!$C$4:$D$8,2,0)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M370=\"Long term or significant positive\",2,IF(M370=\"Short term positive\",2,IF(M370=\"None\",0,IF(M370=\"Short term negative\",1,IF(M370=\"Long term or significant negative\",1)))))","v":2},{"$f":"VLOOKUP('Sustainability Assessment'!M370,Sheet2!$C$4:$D$8,2,0)","v":1}]
[null,null,null,null,"8.  What will be the impact of this proposal on the practice of 'Good Help' in service delivery?",null,null,null,null,null,null,null,"None",null,null,null,null,null,null,null,null,{"$f":"VLOOKUP('Sustainability Assessment'!M371,Sheet2!$C$4:$D$8,2,0)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M372=\"Long term or significant positive\",2,IF(M372=\"Short term positive\",2,IF(M372=\"None\",0,IF(M372=\"Short term negative\",1,IF(M372=\"Long term or significant negative\",1)))))","v":0},{"$f":"VLOOKUP('Sustainability Assessment'!M372,Sheet2!$C$4:$D$8,2,0)","v":3}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR((SUM(U361:U373))/((COUNTIF(U361:U373,\">0\")*2)),\"0\")","v":1}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(U375,2)","v":1}]

{"sheet":"Equality Impact Assessment","index":6,"n_rows":29,"n_cols":17,"rows_kept":29,"cut":false,"hidden":false,"merged":[[27,5,27,6],[11,2,11,6],[4,2,4,5],[5,2,5,6],[7,2,7,6],[8,2,8,6],[9,2,9,6],[10,2,10,6],[26,2,26,6]]}
[]
[]
[]
[]
[]
[null,null,"The Public Sector Equality Duty is a duty imposed on all UK public bodies by The Equality Act 2010.  It requires them to take equalities considerations into account when exercising any of their functions and taking decisions. An Equality Impact Assessment (EqIA) is an evidence-based approach designed to understand the impact of policies, practices, events and decision-making on different groups to ensure they are fair and will not disadvantage or present barriers for people from the different protected groups. When assessing the impact of council proposals it is important that you base your judgement on available data or intelligence or via consultation or engagement with those affected. "]
[]
[null,null,"Impact Rating Descriptions"]
[null,null,"Positive: The proposal has positive impacts"]
[null,null,"Both positive and negative: The proposal has both positive and negative impacts "]
[null,null,"Neutral: The proposal has no discernible positive or negative impacts "]
[null,null,"Negative or Unknown: The proposal has negative impacts or the impacts are unknown, making it difficult to carry out a robust equality impact assessment."]
[]
[]
[null,null,"Protected Characteristics","What will be the impact of this proposal on protecting against discrimination and disadvantage?","What will be the impact of this proposal on meeting different or specific needs?","What will be the impact of this proposal in tackling prejudice and promoting understanding between different groups?","RAG result"]
[null,null,"Age","Both positive and negative","Neutral","Neutral",null,null,{"$f":"IF(D16=\"positive\",2,IF(D16=\"both positive and negative\",1.5,IF(D16=\"Neutral\",0,IF(D16=\"negative\",1,IF(D16=\"unknown\",1)))))","v":1.5},0,0,{"$f":"VLOOKUP(D16,Sheet2!$G$4:$H$8,2,0)","v":2},{"$f":"VLOOKUP(E16,Sheet2!$G$4:$H$8,2,0)","v":3},{"$f":"VLOOKUP(F16,Sheet2!$G$4:$H$8,2,0)","v":3},{"$f":"IFERROR((SUM(I16:K16))/((COUNTIF(I16:K16,\">0\")*2)),\"0\")","v":0.75},{"$f":"ROUND(O16,2)","v":0.75},{"$f":"VLOOKUP(P16,Sheet2!$R$4:$S$102,2,0)","v":"A"}]
[null,null,"Disability","Neutral","Neutral","Neutral",null,null,0,0,0,{"$f":"VLOOKUP(D17,Sheet2!$G$4:$H$8,2,0)","v":3},{"$f":"VLOOKUP(E17,Sheet2!$G$4:$H$8,2,0)","v":3},{"$f":"VLOOKUP(F17,Sheet2!$G$4:$H$8,2,0)","v":3},{"$f":"IFERROR((SUM(I17:K17))/((COUNTIF(I17:K17,\">0\")*2)),\"0\")","v":"0"},{"$f":"ROUND(O17,2)","v":0},{"$f":"VLOOKUP(P17,Sheet2!$R$4:$S$102,2,0)","v":{"$error":"#N/A"}}]
[null,null,"Gender reassignment or transgender people","Neutral","Neutral","Neutral",null,null,0,0,0,{"$f":"VLOOKUP(D18,Sheet2!$G$4:$H$8,2,0)","v":3},{"$f":"VLOOKUP(E18,Sheet2!$G$4:$H$8,2,0)","v":3},{"$f":"VLOOKUP(F18,Sheet2!$G$4:$H$8,2,0)","v":3},"0",0,{"$f":"VLOOKUP(P18,Sheet2!$R$4:$S$102,2,0)","v":{"$error":"#N/A"}}]
[null,null,"Marriage & civil partnership","Neutral","Neutral","Neutral",null,null,0,0,0,{"$f":"VLOOKUP(D19,Sheet2!$G$4:$H$8,2,0)","v":3},{"$f":"VLOOKUP(E19,Sheet2!$G$4:$H$8,2,0)","v":3},{"$f":"VLOOKUP(F19,Sheet2!$G$4:$H$8,2,0)","v":3},"0",0,{"$f":"VLOOKUP(P19,Sheet2!$R$4:$S$102,2,0)","v":{"$error":"#N/A"}}]
[null,null,"Pregnancy & maternity","Neutral","Neutral","Neutral",null,null,0,0,0,{"$f":"VLOOKUP(D20,Sheet2!$G$4:$H$8,2,0)","v":3},{"$f":"VLOOKUP(E20,Sheet2!$G$4:$H$8,2,0)","v":3},{"$f":"VLOOKUP(F20,Sheet2!$G$4:$H$8,2,0)","v":3},"0",0,{"$f":"VLOOKUP(P20,Sheet2!$R$4:$S$102,2,0)","v":{"$error":"#N/A"}}]
[null,null,"Race","Neutral","Neutral","Neutral",null,null,0,0,0,{"$f":"VLOOKUP(D21,Sheet2!$G$4:$H$8,2,0)","v":3},{"$f":"VLOOKUP(E21,Sheet2!$G$4:$H$8,2,0)","v":3},{"$f":"VLOOKUP(F21,Sheet2!$G$4:$H$8,2,0)","v":3},"0",0,{"$f":"VLOOKUP(P21,Sheet2!$R$4:$S$102,2,0)","v":{"$error":"#N/A"}}]
[null,null,"Religion or belief","Neutral","Neutral","Neutral",null,null,0,0,0,{"$f":"VLOOKUP(D22,Sheet2!$G$4:$H$8,2,0)","v":3},{"$f":"VLOOKUP(E22,Sheet2!$G$4:$H$8,2,0)","v":3},{"$f":"VLOOKUP(F22,Sheet2!$G$4:$H$8,2,0)","v":3},"0",0,{"$f":"VLOOKUP(P22,Sheet2!$R$4:$S$102,2,0)","v":{"$error":"#N/A"}}]
[null,null,"Sexual orientation","Neutral","Neutral","Neutral",null,null,0,0,0,{"$f":"VLOOKUP(D23,Sheet2!$G$4:$H$8,2,0)","v":3},{"$f":"VLOOKUP(E23,Sheet2!$G$4:$H$8,2,0)","v":3},{"$f":"VLOOKUP(F23,Sheet2!$G$4:$H$8,2,0)","v":3},"0",0,{"$f":"VLOOKUP(P23,Sheet2!$R$4:$S$102,2,0)","v":{"$error":"#N/A"}}]
[null,null,"Sex","Neutral","Neutral","Neutral",null,null,0,0,0,{"$f":"VLOOKUP(D24,Sheet2!$G$4:$H$8,2,0)","v":3},{"$f":"VLOOKUP(E24,Sheet2!$G$4:$H$8,2,0)","v":3},{"$f":"VLOOKUP(F24,Sheet2!$G$4:$H$8,2,0)","v":3},"0",0,{"$f":"VLOOKUP(P24,Sheet2!$R$4:$S$102,2,0)","v":{"$error":"#N/A"}}]
[null,null,"Carers","Neutral","Neutral","Neutral",null,null,0,0,0,{"$f":"VLOOKUP(D25,Sheet2!$G$4:$H$8,2,0)","v":3},{"$f":"VLOOKUP(E25,Sheet2!$G$4:$H$8,2,0)","v":3},{"$f":"VLOOKUP(F25,Sheet2!$G$4:$H$8,2,0)","v":3},"0",0,{"$f":"VLOOKUP(P25,Sheet2!$R$4:$S$102,2,0)","v":{"$error":"#N/A"}}]
[null,null,"Care experience","Neutral","Neutral","Neutral",null,null,{"$f":"IF(D26=\"positive\",2,IF(D26=\"both positive and negative\",1.5,IF(D26=\"Neutral\",0,IF(D26=\"negative\",1,IF(D26=\"unknown\",1)))))","v":0},{"$f":"IF(E26=\"positive\",2,IF(E26=\"both positive and negative\",1.5,IF(E26=\"Neutral\",0,IF(E26=\"negative\",1,IF(E26=\"unknown\",1)))))","v":0},{"$f":"IF(F26=\"positive\",2,IF(F26=\"both positive and negative\",1.5,IF(F26=\"Neutral\",0,IF(F26=\"negative\",1,IF(F26=\"unknown\",1)))))","v":0},{"$f":"VLOOKUP(D26,Sheet2!$G$4:$H$8,2,0)","v":3},{"$f":"VLOOKUP(E26,Sheet2!$G$4:$H$8,2,0)","v":3},{"$f":"VLOOKUP(F26,Sheet2!$G$4:$H$8,2,0)","v":3},{"$f":"IFERROR((SUM(I26:K26))/((COUNTIF(I26:K26,\">0\")*2)),\"0\")","v":"0"},{"$f":"ROUND(O26,2)","v":0},{"$f":"VLOOKUP(P26,Sheet2!$R$4:$S$102,2,0)","v":{"$error":"#N/A"}}]
[]
[]
[null,null,null,null,null,"Overall RAG",{"$f":"IF(P29=0,\"N/A\",IF(AND(P29<=0.74),\"RR\",IF(AND(P29>=0.75,P29<=0.99),\"A\",IF(P29=1,\"G\",IF(P29=\"x\",\"This is calculated when all questions have been answered\",\"\")))))","v":"A"},null,null,null,null,null,null,null,{"$f":"IFERROR((SUM(O16:O26))/((COUNTIF(O16:O26,\">0\"))),\"0\")","v":0.75},0.75]

{"sheet":"Carbon Assessment","index":7,"n_rows":26,"n_cols":23,"rows_kept":26,"cut":false,"hidden":false,"merged":[[15,2,15,15],[15,16,15,17],[5,2,5,18],[6,2,6,18],[7,2,7,18],[8,2,8,18],[9,2,9,18],[10,2,10,18],[12,2,13,15],[12,16,13,17],[12,18,13,18],[14,2,14,15],[14,16,14,17],[16,2,16,15],[16,16,16,17],[18,2,18,18],[20,16,21,17],[20,18,21,18]]}
[]
[]
[]
[]
[]
[null,null,"In July 2019 the Council declared a climate emergency and resolved to work towards ensuring the Council and Borough of Rochdale is carbon neutral by 2038. Carbon neutrality means any CO2 being released into the atmosphere is balanced by an equivalent amount being removed. To achieve carbon neutrality the council will need to ensure that all decisions taken do not add to our carbon footprint. If a proposal will have a carbon impact the council must look to identify ways to cut, capture or offset those carbon emissions. "]
[]
[null,null,"Impact Rating Descriptions"]
[null,null,"Positive: The proposal has positive impacts"]
[null,null,"Neutral: The proposal has no discernible positive or negative impacts "]
[null,null,"Negative or Unknown: The proposal has negative impacts or the impacts are unknown, making it difficult to carry out a robust equality impact assessment."]
[]
[null,null,"Carbon Assessment\n\nWhat is the impact of this proposal on carbon emissions?",null,null,null,null,null,null,null,null,null,null,null,null,null,"Impact Rating",null,"RAG Result"]
[]
[null,null,"What will be the impact of this proposal on Scope 1 emissions?\nScope 1 (Direct) -  Activities owned or controlled by Rochdale Council that release emissions straight into the atmosphere E.g. burning fossil fuels for heating, transport or generator use.",null,null,null,null,null,null,null,null,null,null,null,null,null,"Neutral",null,null,null,null,{"$f":"IF(Q15=\"positive\",2,IF(Q15=\"both positive and negative\",1.5,IF(Q15=\"Neutral\",0,IF(Q15=\"negative\",1,IF(Q15=\"unknown\",1)))))","v":0},{"$f":"VLOOKUP(Q15,Sheet2!$G$4:$H$8,2,0)","v":3}]
[null,null,"What will be the impact of this proposal on Scope 2 emissions?\nScope 2 (Indirect) - Emissions released into the atmosphere occurring at sources not owned or controlled by Rochdale Council E.g. electricity purchased from the grid to power street lighting, electric vehicles, building lights or heat pumps. ",null,null,null,null,null,null,null,null,null,null,null,null,null,"Neutral",null,null,null,null,{"$f":"IF(Q16=\"positive\",2,IF(Q16=\"both positive and negative\",1.5,IF(Q16=\"Neutral\",0,IF(Q16=\"negative\",1,IF(Q16=\"unknown\",1)))))","v":0},{"$f":"VLOOKUP(Q16,Sheet2!$G$4:$H$8,2,0)","v":3}]
[null,null,"What will be the impact of this proposal on Scope 3 emissions?\nScope 3 (Consumption based) Indirect emissions that are not classed as scope 2 emissions are sometimes referred to as consumption based emissions. These are the result of activities from assets not owned or controlled by the Council, but that indirectly impacts in its value chain. E.g. business travel, employee commuting, waste disposal, goods and services procured, distribution of goods etc. \n",null,null,null,null,null,null,null,null,null,null,null,null,null,"Positive",null,null,null,null,{"$f":"IF(Q17=\"positive\",2,IF(Q17=\"both positive and negative\",1.5,IF(Q17=\"Neutral\",0,IF(Q17=\"negative\",1,IF(Q17=\"unknown\",1)))))","v":2},{"$f":"VLOOKUP(Q17,Sheet2!$G$4:$H$8,2,0)","v":1}]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Overall RAG",null,{"$f":"IF(V26=0,\"N/A\",IF(AND(V26<=0.74),\"RR\",IF(AND(V26>=0.75,V26<=0.99),\"A\",IF(V26=1,\"G\",IF(V26=\"x\",\"This is calculated when all questions have been answered\",\"\")))))","v":"G"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR((SUM(V15:V17))/((COUNTIF(V15:V17,\">0\")*2)),\"0\")","v":1}]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(V22,2)","v":1}]

{"sheet":"Results","index":8,"n_rows":34,"n_cols":7,"rows_kept":34,"cut":false,"hidden":false,"merged":[[5,3,6,6],[14,3,14,4],[15,2,15,6],[16,3,16,4],[20,3,20,4],[21,3,21,4],[22,3,22,4],[17,3,17,4],[18,3,18,4],[19,3,19,4],[26,3,26,4],[27,3,27,4],[28,3,28,4],[23,3,23,4],[24,3,24,4],[25,3,25,4],[32,3,32,4],[33,3,33,4],[35,3,35,6],[29,3,29,4],[30,3,30,4],[31,3,31,4]]}
[]
[]
[]
[]
[]
[null,null,null,"This is the impact assessment results page. If you have completed the assessment correctly there should be an impact rating for sustainability, equality and carbon. In the comments section you must describe both the positive and negative impacts that you have identified when carrying out the assessment. Where you have identified negative impacts you will need to explain how these could be avoided or mitigated. Click on the export button to copy your table of results to a word document. You must upload this word document to ModGov as a background to your report. You must highlight any significant positive and negative impacts within your governance report."]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Impact Assessment Results","Impact Assessment ",null,"Impact Rating","Comments, Actions and Mitigations"]
[null,null,"Sustainability Assessment "]
[null,null,"SDG 1","No Poverty",null,{"$f":"'Sustainability Assessment'!R24","v":"N/A"}]
[null,null,"SDG 2","Zero Hunger",null,{"$f":"'Sustainability Assessment'!R45","v":"G"}]
[null,null,"SDG 3","Health & Wellbeing",null,{"$f":"'Sustainability Assessment'!R63","v":"G"}]
[null,null,"SDG 4","Quality Education",null,{"$f":"'Sustainability Assessment'!R90","v":"N/A"}]
[null,null,"SDG 5","Gender Equality",null,{"$f":"'Sustainability Assessment'!R107","v":"N/A"}]
[null,null,"SDG 6","Clean Water & Sanitation",null,{"$f":"'Sustainability Assessment'!R124","v":"G"}]
[null,null,"SDG 7","Affordable & Clean Energy",null,{"$f":"'Sustainability Assessment'!R143","v":"N/A"}]
[null,null,"SDG 8","Decent Work & Economic Growth",null,{"$f":"'Sustainability Assessment'!R168","v":"G"}]
[null,null,"SDG 9","Industry, Innovation and Infrastructure",null,{"$f":"'Sustainability Assessment'!R197","v":"G"}]
[null,null,"SDG 11","Sustainable Cities & Communities",null,{"$f":"'Sustainability Assessment'!R212","v":"N/A"}]
[null,null,"SDG 12","Responsible Consumption & Production",null,{"$f":"'Sustainability Assessment'!R251","v":"G"}]
[null,null,"SDG 13","Climate Action",null,{"$f":"'Sustainability Assessment'!R286","v":"G"}]
[null,null,"SDG 14","Life Below Water",null,{"$f":"'Sustainability Assessment'!R299","v":"G"}]
[null,null,"SDG 15","Life On Land",null,{"$f":"'Sustainability Assessment'!R312","v":"G"}]
[null,null,"SDG 16","Peace, Justice & Strong Institutions",null,{"$f":"'Sustainability Assessment'!R331","v":"A"},"Negative imapct on perpetrators breaching the order, overall positive impact for community"]
[null,null,"SDG 17","Partnerships For The Goals",null,{"$f":"'Sustainability Assessment'!R358","v":"G"}]
[null,null,null,"Equality Assessment",null,{"$f":"'Equality Impact Assessment'!G29","v":"A"},"Could negatively impact young  people due to the majorty of perpetrators falling to this category however this could also benefit older people who suffer the consequences of the usage of off road vehicle "]
[null,null,null,"Carbon Assessment",null,{"$f":"'Carbon Assessment'!S21","v":"G"}]