{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["Guide","Questions","PEA notes","Results Dashboard","Detailed Results","Spider Diagram","SUMS","Fill"],"not_rendered":{"charts":1,"images":14,"macros":1,"external_links":0,"defined_names":1,"comments":3,"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":"Guide","index":0,"n_rows":46,"n_cols":15,"rows_kept":46,"cut":false,"hidden":false,"merged":[[4,4,4,16],[6,5,6,15],[8,5,8,15],[35,6,35,14],[37,6,37,14],[39,6,39,14],[11,6,11,14],[23,6,23,14],[25,6,25,14],[31,6,31,14],[33,6,33,14],[13,6,13,14],[15,6,15,14],[17,6,17,14],[19,6,19,14],[27,6,27,14],[29,6,29,14]]}
[]
[]
[]
[]
[null,null,null,null,"GUIDE "]
[]
[null,null,null,null,null,"This tool is designed for all energy networks in the UK. It is used to assess the potential impact of innovation projects on customers in situations of vulnerability."]
[]
[null,null,null,null," ","As a result of answering a set of questions, users will automatically generate a score for the project they are assessing. The tool also allows users to dive deeper into the results by examining the full 'impact matrix,' which gives a granular breakdown of the impacts on customers across all scenarios considered by the tool."]
[]
["For"]
[null,null,null,null,null,null,"First-Time Setup Instructions"]
[]
[null,null,null,null,null,null,"Please save the file after following the instructions below to embed changes for future use. "]
[]
[null,null,null,null,null,null,"1) First, enable macros by selecting the yellow notification(s) above. "]
[]
[null,null,null,null,null,null,"2) Select 'Fit Screen' below to adjust the layout of the tool to the resolution of your computer screen."]
[]
[null,null,null,null,null,null,"Finally, select 'Full Screen Mode' from the dropdown arrow in the top right corner. (Optional)"]
[]
[]
[]
[null,null,null,null,null,null,"General Use Intructions"]
[]
[null,null,null,null,null,null,"   After general use, do not save the file. Instead, save your results to PDF by following the instructions below. "]
[]
[null,null,null,null,null,null,"   To navigate between sheets, do not use the tabs below. Only use the buttons provided on sheets."]
[]
[null,null,null,null,null,null,"   For best results, only use the tool on your primary display screen.  "]
[]
[null,null,null,null,null,null,"1) Select 'Begin' to navigate to the questions sheet. For each question, select the checkbox that corresponds to the innovation project you are testing. You must answer every question.     \n"]
[]
[null,null,null,null,null,null,"2) Once completed, select 'See Results' to view the results dashboard. Select 'See More Details' to view the Impact Matrix, High-Level Mitigations, Questions and Answers, and overall project impact scores sections.     "]
[]
[null,null,null,null,null,null,"Save 'Results Dashboard' and 'Detailed Results' by selecting the relevant buttons on the questions sheet. "]
[]
[null,null,null,null,null,null,"To restart, select 'Clear Answers' on the questions sheet. Only return to answers by selecting 'See Results'."]
[]
[null,null,null,null,null,null,"To contact support via Outlook, select 'Contact' below on this sheet.  "]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Alternatively, contact daniel@sirio-strategies.com"]

{"sheet":"Questions","index":1,"n_rows":41,"n_cols":18,"rows_kept":41,"cut":false,"hidden":false,"merged":[[21,3,21,14],[23,3,23,14],[25,3,25,14],[13,3,13,14],[15,3,15,14],[17,3,17,14],[19,3,19,14],[12,3,12,7],[24,15,24,16],[22,15,22,16],[10,15,10,16],[12,15,12,16],[14,15,14,16],[16,15,16,16],[18,15,18,16],[20,15,20,16],[14,3,14,7],[16,3,16,7],[18,3,18,7],[20,3,20,7],[22,3,22,7],[24,3,24,7],[11,3,11,14],[8,15,9,16],[8,3,8,7],[9,3,9,7],[10,3,10,7],[4,3,4,17],[8,17,9,17]]}
[]
[]
[]
[]
[null,null,null,"QUESTIONS"]
[]
[null,null,null,"Is the project expected to:"]
[]
[null,null,null,"1) focus on reserch only, and not deliver any immediate impacts on customers or the network?",null,null,null,null,"i","Yes:",null,"No:",null,"Unsure:",null,"Over what timeframe will the impact be felt by customers?\nOptional",null,"Additional Comments\nOptional"]
[null,null,null,"2) impact customers directly or indirectly?",null,null,null,null,"i","Yes:",null,"No:",null,"Unsure:"]
[null,null,null,"3) reduce or increase costs (such as bills, appliance maintenance, etc.) for households?",null,null,null,null,"i","Reduce:",null,"Increase:",null,"No Change/ Unrelated:"]
[null,null,null,"Reasoning:"]
[null,null,null,"4) improve or hinder the exchange of information between networks and customers?",null,null,null,null,"i","Improve:",null,"Hinder:",null,"No Change/ Unrelated:"]
[null,null,null,"Reasoning:"]
[null,null,null,"5) improve or hinder the network's understanding of customers' needs and the ability to address these?",null,null,null,null,"i","Improve:",null,"Hinder:",null,"No Change/ Unrelated:"]
[null,null,null,"Reasoning:"]
[null,null,null,"6) reduce or increase the need, time taken, and disruptions caused by staff visits to customers' homes?",null,null,null,null,"i","Reduce:",null,"Increase:",null,"No Change/ Unrelated:"]
[null,null,null,"Reasoning:"]
[null,null,null,"7) improve or hinder customers' health, safety, and accessibility within or immediately around the home?",null,null,null,null,"i","Improve:",null,"Hinder:",null,"No Change/ Unrelated:"]
[null,null,null,"Reasoning:"]
[null,null,null,"8) improve or hinder customers' ability to heat, cook, wash and use medical equipment during supply interruptions?",null,null,null,null,"i","Improve:",null,"Hinder:",null,"No Change/ Unrelated:"]
[null,null,null,"Reasoning:"]
[null,null,null,"9) reduce or increase the occurrence and duration of supply interruptions?",null,null,null,null,"i","Reduce:",null,"Increase:",null,"No Change/ Unrelated:"]
[null,null,null,"Reasoning:"]
[null,null,null,"10) reduce or increase the need for, time taken, and space required to work on trees and public and private roads in residential areas?",null,null,null,null,"i","Reduce:",null,"Increase:",null,"No Change/ Unrelated:"]
[null,null,null,"Reasoning:"]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,"K11",false,"O11",false,{"$f":"J34*70","v":0},{"$f":"(H34+J34)*145","v":0}]
[null,null,null,null,null,null,"K13",false,"O13",false,{"$f":"J35*70","v":0},{"$f":"(H35+J35)*145","v":0}]
[null,null,null,null,null,null,"K15",false,"O15",false,0,0]
[null,null,null,null,null,null,"K17",false,"O17",false,0,0]
[null,null,null,null,null,null,"K19",false,"O19",false,0,0]
[null,null,null,null,null,null,"K21",false,"O21",false,0,0]
[null,null,null,null,null,null,"K23",false,"O23",false,0,0]
[null,null,null,null,null,null,"K25",false,"O25",false,0,0]

{"sheet":"PEA notes","index":2,"n_rows":1,"n_cols":1,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
["DRAFT PEA SECTION GUIDANCE"]

{"sheet":"Results Dashboard","index":3,"n_rows":32,"n_cols":17,"rows_kept":32,"cut":false,"hidden":true,"merged":[[18,16,19,16],[11,4,11,5],[12,4,12,5],[4,3,4,17],[7,11,9,15],[10,11,10,13],[7,4,9,5],[10,4,10,5],[6,4,6,7],[6,11,6,15],[12,12,12,14],[10,14,10,15],[7,6,9,6],[7,7,9,7],[7,8,9,8],[26,7,26,16],[27,7,27,16],[21,5,21,14],[22,4,22,6],[22,7,22,16],[31,4,31,6],[31,7,31,16],[23,4,23,6],[24,4,24,6],[25,4,25,6],[26,4,26,6],[27,4,27,6],[28,7,28,16],[29,7,29,16],[30,7,30,16],[30,4,30,6],[29,4,29,6],[28,4,28,6],[23,7,23,16],[24,7,24,16],[25,7,25,16]]}
[]
[]
[]
[]
[null,null,null,"RESULTS DASHBOARD"]
[]
[null,null,null,null,"Project Impact Score",null,null,null,null,null,null,"Customer Impact Calculator"]
[null,null,null,null,"Overall Project Score:",null,{"$f":"IFERROR(10*(G12/(G12+G13)),0)","v":5},"/10","i"]
[]
[]
[null,null,null,null,"Relative Impact Score:",null,{"$f":"(SUMS!C35-SUMS!C37)/(SUMS!C36-SUMS!C37)*10","v":5},"/10","i",null,null,"Overall Impact Score:",null,null,{"$f":"IF(SUMS!$K$44=1,SUMS!K34,IF(SUMS!$K$44=2,SUMS!L34,IF(SUMS!$K$44=3,SUMS!M34,IF(SUMS!$K$44=4,SUMS!N34,IF(SUMS!$K$44=5,SUMS!O34,IF(SUMS!$K$44=6,SUMS!P34,IF(SUMS!$K$44=7,SUMS!Q34,IF(SUMS!$K$44=8,SUMS!R34,IF(SUMS!$K$44=9,SUMS!S34,IF(SUMS!$K$44=10,SUMS!T34,IF(SUMS!$K$44=11,SUMS!U34,IF(SUMS!$K$44=12,SUMS!V34,IF(SUMS!$K$44=13,SUMS!W34,IF(SUMS!$K$44=14,SUMS!X34,IF(SUMS!$K$44=15,SUMS!Y34,IF(SUMS!$K$44=16,SUMS!Z34,IF(SUMS!$K$44=17,SUMS!AA34,IF(SUMS!$K$44=18,SUMS!AB34,IF(SUMS!$K$44=19,SUMS!AC34,IF(SUMS!$K$44=20,SUMS!AD34,IF(SUMS!$K$44=21,SUMS!AE34,IF(SUMS!$K$44=22,SUMS!AF34,IF(SUMS!$K$44=23,SUMS!AG34,IF(SUMS!$K$44=24,SUMS!AH34, IF(SUMS!$K$44=25,SUMS!AI34,IF(SUMS!$K$44=26,SUMS!AJ34,IF(SUMS!$K$44=27,SUMS!AK34,IF(SUMS!$K$44=28,SUMS!AL34,IF(SUMS!$K$44=29,\"\",0)))))))))))))))))))))))))))))","v":""},null,"i"]
[null,null,null,null,"Positive Impact Score:",null,{"$f":"(SUMS!C38-SUMS!C40)/(SUMS!C36-SUMS!C40)*10","v":10.073886261969722},"/10","i"]
[null,null,null,null,"Negative Impact Score:",null,{"$f":"((SUMS!C39*-1)-SUMS!C40)/(SUMS!C36-SUMS!C40)*10","v":10.073886261969722},"/10","i"]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"i"]
[]
[]
[null,null,null,null,null,"Negative Impacts and Mitigations"]
[null,null,null,null,"Driver of Negative Impact",null,null,"High-Level Mitigation"]
[null,null,null,null,"Project increases costs for households:",null,null,"Where costs are expected to increase as a result of new ‘systems’ installed in the customer’s premises, stakeholders believe it is essential to ensure that customers in vulnerable situations can use these properly to avoid further bill impacts. "]
[null,null,null,null,"Project hinders the exchange of information between networks and customers:",null,null,"Engage different groups of vulnerable customers and their representatives to understand preferred channels, identify the optimal format and type of content. Gathering and communicating tailored information effectively is critical."]
[null,null,null,null,"Project hinders the network's understanding of customers' needs and the ability to address these:",null,null,"Customers with communication disabilities are often underrepresented in data collected. Networks should ensure that provisions are made to engage these customers through their preferred method of communication."]
[null,null,null,null,"Project increases the need for, time taken and disruption cased by staff vists to customers' homes:",null,null,"To date, stakeholders have not shared recommendations on how to mitigate this type of impact on customers in vulnerable situations. "]
[null,null,null,null,"Project hinders health, safety and accessibility within or immediately  around customers' homes:",null,null,"To date, stakeholders have not shared recommendations on how to mitigate this type of impact on customers in vulnerable situations. "]
[null,null,null,null,"Project hinders customers' ability to heat, cook, wash and use medical equipment during supply interruptions:",null,null,"To date, stakeholders have not shared recommendations on how to mitigate this type of impact on customers in vulnerable situations. "]
[null,null,null,null,"Project increases the occurrence and duration of supply interruptions:",null,null,"To date, stakeholders have not shared recommendations on how to mitigate this type of impact on customers in vulnerable situations. "]
[null,null,null,null,"Project increases the need for, time taken, and space required to work on trees and public and private roads in residential areas:",null,null,"To date, stakeholders have not shared recommendations on how to mitigate this type of impact on customers in vulnerable situations. "]
[null,null,null,null,"Unavailable",null,null,"There is no need to take mitigation measures."]

{"sheet":"Detailed Results","index":4,"n_rows":123,"n_cols":24,"rows_kept":123,"cut":false,"hidden":true,"merged":[[104,2,104,23],[107,2,107,23],[54,2,54,23],[121,2,121,3],[81,2,81,23],[113,2,113,23],[83,2,83,23],[84,2,84,23],[86,2,86,23],[87,2,87,23],[105,2,105,23],[108,2,108,23],[109,2,109,23],[69,2,69,23],[70,2,70,23],[90,2,90,23],[122,2,122,3],[121,4,121,23],[114,2,114,23],[116,2,116,3],[117,2,117,3],[118,2,118,3],[120,2,120,23],[66,2,66,23],[93,2,93,23],[96,2,96,23],[99,2,99,23],[102,2,102,23],[101,2,101,23],[61,2,61,23],[62,2,62,23],[63,2,63,23],[64,2,64,23],[65,2,65,23],[56,2,56,23],[57,2,57,23],[58,2,58,23],[59,2,59,23],[60,2,60,23],[42,3,42,4],[5,2,13,2],[5,3,6,3],[7,3,9,3],[10,3,12,3],[14,2,41,2],[38,3,38,4],[29,3,29,4],[30,3,30,4],[16,3,16,4],[17,3,17,4],[18,3,18,4],[14,3,14,4],[2,2,2,23],[41,3,41,4],[34,3,34,4],[25,3,25,4],[31,3,31,4],[32,3,32,4],[27,3,27,4],[28,3,28,4],[39,3,39,4],[40,3,40,4],[33,3,33,4],[35,3,35,4],[36,3,36,4],[37,3,37,4],[4,3,4,4],[15,3,15,4],[110,2,110,23],[19,3,19,4],[20,3,20,4],[21,3,21,4],[22,3,22,4],[26,3,26,4],[23,3,23,4],[24,3,24,4],[67,2,67,23],[68,2,68,23],[52,2,52,23],[89,2,89,23],[92,2,92,23],[95,2,95,23],[98,2,98,23],[55,2,55,23]]}
[]
[]
[null,null,"IMPACT MATRIX RESULTS"]
[]
[null,null,null,"Types of Impact",null,"Project reduces costs for households","Project increases costs for households","Project improves the exchange of information between networks and customers","Project hinders the exchange of information between networks and customers","Project improves the network's understanding of customers' needs and the ability to address these","Project hinders the network's understanding of customers' needs and the ability to address these","Project reduces the need for, time taken and disruption cased by staff vists to customers' homes","Project increases the need for, time taken and disruption cased by staff vists to customers' homes","Project improves health, safety and accessibility within or immediately around customers' homes","Project hinders health,   safety and accessibility   within or immediately  around customers' homes","Project improves customers' ability to heat, cook, wash and use medical equipment during supply interruptions","Project hinders customers' ability to heat, cook, wash and use medical equipment during supply interruptions","Project reduces the occurrence and duration    of supply interruptions","Project increases the occurrence and duration     of supply interruptions","Project reduces the need for, time taken, and space required to work on trees and public and private roads in residential areas","Project increases the need for, time taken, and space required to work on trees and public and private roads in residential areas","Overall impact","Overall positive impact","Overall negative impact"]
[null,null,"Situational Circumstances","Dwelling","Flats",{"$f":"SUM(Fill!F5)","v":0.99},{"$f":"SUM(Fill!G5)","v":-0.99},{"$f":"SUM(Fill!H5)","v":0.63},{"$f":"SUM(Fill!I5)","v":-0.63},{"$f":"SUM(Fill!J5)","v":0.76},{"$f":"SUM(Fill!K5)","v":-0.76},{"$f":"SUM(Fill!L5)","v":0.61},{"$f":"SUM(Fill!M5)","v":-0.61},{"$f":"SUM(Fill!N5)","v":0.88},{"$f":"SUM(Fill!O5)","v":-0.88},{"$f":"SUM(Fill!P5)","v":1},{"$f":"SUM(Fill!Q5)","v":-1},{"$f":"SUM(Fill!R5)","v":1},{"$f":"SUM(Fill!S5)","v":-1},"N/A","N/A",{"$f":"SUM(SUMS!B18)","v":0},{"$f":"SUM(SUMS!B19)","v":5.8699999999999992},{"$f":"SUM(SUMS!B20)","v":-5.8699999999999992}]
[null,null,null,null,"Houses",{"$f":"SUM(Fill!F6)","v":0.96},{"$f":"SUM(Fill!G6)","v":-0.96},{"$f":"SUM(Fill!H6)","v":0.63},{"$f":"SUM(Fill!I6)","v":-0.63},{"$f":"SUM(Fill!J6)","v":0.76},{"$f":"SUM(Fill!K6)","v":-0.76},{"$f":"SUM(Fill!L6)","v":0.87},{"$f":"SUM(Fill!M6)","v":-0.87},{"$f":"SUM(Fill!N6)","v":0.88},{"$f":"SUM(Fill!O6)","v":-0.88},{"$f":"SUM(Fill!P6)","v":1},{"$f":"SUM(Fill!Q6)","v":-1},{"$f":"SUM(Fill!R6)","v":0.92},{"$f":"SUM(Fill!S6)","v":-0.92},"N/A","N/A",{"$f":"SUM(SUMS!C18)","v":0},{"$f":"SUM(SUMS!C19)","v":6.02},{"$f":"SUM(SUMS!C20)","v":-6.02}]
[null,null,null,"Tenure","Owner occupier",{"$f":"SUM(Fill!F7)","v":0.96},{"$f":"SUM(Fill!G7)","v":-0.96},{"$f":"SUM(Fill!H7)","v":0.75},{"$f":"SUM(Fill!I7)","v":-0.75},{"$f":"SUM(Fill!J7)","v":0.8},{"$f":"SUM(Fill!K7)","v":-0.8},{"$f":"SUM(Fill!L7)","v":0.91},{"$f":"SUM(Fill!M7)","v":-0.91},"N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A",{"$f":"SUM(SUMS!D18)","v":0},{"$f":"SUM(SUMS!D19)","v":3.42},{"$f":"SUM(SUMS!D20)","v":-3.42}]
[null,null,null,null,"Private renter",{"$f":"SUM(Fill!F8)","v":0.96},{"$f":"SUM(Fill!G8)","v":-0.96},{"$f":"SUM(Fill!H8)","v":0.67},{"$f":"SUM(Fill!I8)","v":-0.67},{"$f":"SUM(Fill!J8)","v":0.72},{"$f":"SUM(Fill!K8)","v":-0.72},{"$f":"SUM(Fill!L8)","v":0.65},{"$f":"SUM(Fill!M8)","v":-0.65},"N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A",{"$f":"SUM(SUMS!E18)","v":0},{"$f":"SUM(SUMS!E19)","v":2.9999999999999996},{"$f":"SUM(SUMS!E20)","v":-2.9999999999999996}]
[null,null,null,null,"Social renter",{"$f":"SUM(Fill!F9)","v":1.21},{"$f":"SUM(Fill!G9)","v":-1.21},{"$f":"SUM(Fill!H9)","v":0.75},{"$f":"SUM(Fill!I9)","v":-0.75},{"$f":"SUM(Fill!J9)","v":0.88},{"$f":"SUM(Fill!K9)","v":-0.88},{"$f":"SUM(Fill!L9)","v":0.7},{"$f":"SUM(Fill!M9)","v":-0.7},"N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A",{"$f":"SUM(SUMS!F18)","v":0},{"$f":"SUM(SUMS!F19)","v":3.54},{"$f":"SUM(SUMS!F20)","v":-3.54}]
[null,null,null,"Heating system","Central heating system",{"$f":"SUM(Fill!F10)","v":1.04},{"$f":"SUM(Fill!G10)","v":-1.04},{"$f":"SUM(Fill!H10)","v":0.67},{"$f":"SUM(Fill!I10)","v":-0.67},{"$f":"SUM(Fill!J10)","v":0.76},{"$f":"SUM(Fill!K10)","v":-0.76},{"$f":"SUM(Fill!L10)","v":0.74},{"$f":"SUM(Fill!M10)","v":-0.74},"N/A","N/A",{"$f":"SUM(Fill!P10)","v":1.0900000000000001},{"$f":"SUM(Fill!Q10)","v":-1.0900000000000001},{"$f":"SUM(Fill!R10)","v":1.17},{"$f":"SUM(Fill!S10)","v":-1.17},"N/A","N/A",{"$f":"SUM(SUMS!G18)","v":0},{"$f":"SUM(SUMS!G19)","v":5.47},{"$f":"SUM(SUMS!G20)","v":-5.47}]
[null,null,null,null,"Storage heaters",{"$f":"SUM(Fill!F11)","v":1.1299999999999999},{"$f":"SUM(Fill!G11)","v":-1.1299999999999999},{"$f":"SUM(Fill!H11)","v":0.75},{"$f":"SUM(Fill!I11)","v":-0.75},{"$f":"SUM(Fill!J11)","v":0.72},{"$f":"SUM(Fill!K11)","v":-0.72},{"$f":"SUM(Fill!L11)","v":0.65},{"$f":"SUM(Fill!M11)","v":-0.65},"N/A","N/A",{"$f":"SUM(Fill!P11)","v":1.08},{"$f":"SUM(Fill!Q11)","v":-1.08},{"$f":"SUM(Fill!R11)","v":1.04},{"$f":"SUM(Fill!S11)","v":-1.04},"N/A","N/A",{"$f":"SUM(SUMS!H18)","v":0},{"$f":"SUM(SUMS!H19)","v":5.37},{"$f":"SUM(SUMS!H20)","v":-5.37}]
[null,null,null,null,"Room heaters",{"$f":"SUM(Fill!F12)","v":1.04},{"$f":"SUM(Fill!G12)","v":-1.04},{"$f":"SUM(Fill!H12)","v":0.67},{"$f":"SUM(Fill!I12)","v":-0.67},{"$f":"SUM(Fill!J12)","v":0.76},{"$f":"SUM(Fill!K12)","v":-0.76},{"$f":"SUM(Fill!L12)","v":0.65},{"$f":"SUM(Fill!M12)","v":-0.65},"N/A","N/A",{"$f":"SUM(Fill!P12)","v":1.17},{"$f":"SUM(Fill!Q12)","v":-1.17},{"$f":"SUM(Fill!R12)","v":1.08},{"$f":"SUM(Fill!S12)","v":-1.08},"N/A","N/A",{"$f":"SUM(SUMS!I18)","v":0},{"$f":"SUM(SUMS!I19)","v":5.3699999999999992},{"$f":"SUM(SUMS!I20)","v":-5.3699999999999992}]
[null,null,null,"Readiness for digital technology","Limited digital literacy",{"$f":"SUM(Fill!F13)","v":0.96},{"$f":"SUM(Fill!G13)","v":-0.96},{"$f":"SUM(Fill!H13)","v":0.71},{"$f":"SUM(Fill!I13)","v":-0.71},{"$f":"SUM(Fill!J13)","v":0.76},{"$f":"SUM(Fill!K13)","v":-0.76},"N/A","N/A",{"$f":"SUM(Fill!N13)","v":1.1200000000000001},{"$f":"SUM(Fill!O13)","v":-1.1200000000000001},{"$f":"SUM(Fill!P13)","v":1.04},{"$f":"SUM(Fill!Q13)","v":-1.04},{"$f":"SUM(Fill!R13)","v":1.04},{"$f":"SUM(Fill!S13)","v":-1.04},"N/A","N/A",{"$f":"SUM(SUMS!J18)","v":0},{"$f":"SUM(SUMS!J19)","v":5.63},{"$f":"SUM(SUMS!J20)","v":-5.63}]
[null,null,"Needs Codes Circumstances","Blind",null,{"$f":"AVERAGE(Fill!F15:F16,Fill!F18:F19)","v":1.3149999999999999},{"$f":"AVERAGE(Fill!G15:G16,Fill!G18:G19)","v":-1.3149999999999999},{"$f":"AVERAGE(Fill!H15:H16,Fill!H18:H19)","v":0.92500000000000004},{"$f":"AVERAGE(Fill!I15:I16,Fill!I18:I19)","v":-0.92500000000000004},{"$f":"AVERAGE(Fill!J15:J16,Fill!J18:J19)","v":1.085},{"$f":"AVERAGE(Fill!K15:K16,Fill!K18:K19)","v":-1.085},{"$f":"AVERAGE(Fill!L15:L16,Fill!L18:L19)","v":1.325},{"$f":"AVERAGE(Fill!M15:M16,Fill!M18:M19)","v":-1.325},{"$f":"AVERAGE(Fill!N15:N16,Fill!N18:N19)","v":1.7250000000000001},{"$f":"AVERAGE(Fill!O15:O16,Fill!O18:O19)","v":-1.7250000000000001},{"$f":"AVERAGE(Fill!P15:P16,Fill!P18:P19)","v":1.74},{"$f":"AVERAGE(Fill!Q15:Q16,Fill!Q18:Q19)","v":-1.74},{"$f":"AVERAGE(Fill!R15:R16,Fill!R18:R19)","v":1.7350000000000001},{"$f":"AVERAGE(Fill!S15:S16,Fill!S18:S19)","v":-1.7350000000000001},{"$f":"AVERAGE(Fill!T15:T16,Fill!T18:T19)","v":1.2825},{"$f":"AVERAGE(Fill!U15:U16,Fill!U18:U19)","v":-1.2825},{"$f":"SUM(SUMS!K18)","v":0},{"$f":"SUM(SUMS!K19)","v":11.1325},{"$f":"SUM(SUMS!K20)","v":-11.1325}]
[null,null,null,"Partially sighted",null,{"$f":"AVERAGE(Fill!F15:F16,Fill!F18:F19)","v":1.3149999999999999},{"$f":"AVERAGE(Fill!G15:G16,Fill!G18:G19)","v":-1.3149999999999999},{"$f":"AVERAGE(Fill!H15:H16,Fill!H18:H19)","v":0.92500000000000004},{"$f":"AVERAGE(Fill!I15:I16,Fill!I18:I19)","v":-0.92500000000000004},{"$f":"AVERAGE(Fill!J15:J16,Fill!J18:J19)","v":1.085},{"$f":"AVERAGE(Fill!K15:K16,Fill!K18:K19)","v":-1.085},{"$f":"AVERAGE(Fill!L15:L16,Fill!L18:L19)","v":1.325},{"$f":"AVERAGE(Fill!M15:M16,Fill!M18:M19)","v":-1.325},{"$f":"AVERAGE(Fill!N15:N16,Fill!N18:N19)","v":1.7250000000000001},{"$f":"AVERAGE(Fill!O15:O16,Fill!O18:O19)","v":-1.7250000000000001},{"$f":"AVERAGE(Fill!P15:P16,Fill!P18:P19)","v":1.74},{"$f":"AVERAGE(Fill!Q15:Q16,Fill!Q18:Q19)","v":-1.74},{"$f":"AVERAGE(Fill!R15:R16,Fill!R18:R19)","v":1.7350000000000001},{"$f":"AVERAGE(Fill!S15:S16,Fill!S18:S19)","v":-1.7350000000000001},{"$f":"AVERAGE(Fill!T15:T16,Fill!T18:T19)","v":1.2825},{"$f":"AVERAGE(Fill!U15:U16,Fill!U18:U19)","v":-1.2825},{"$f":"SUM(SUMS!L18)","v":0},{"$f":"SUM(SUMS!L19)","v":11.1325},{"$f":"SUM(SUMS!L20)","v":-11.1325}]
[null,null,null,"Hearing impairment (inc. deaf)",null,{"$f":"AVERAGE(Fill!F15:F16,Fill!F19)","v":1.1966666666666665},{"$f":"AVERAGE(Fill!G15:G16,Fill!G19)","v":-1.1966666666666665},{"$f":"AVERAGE(Fill!H15:H16,Fill!H19)","v":0.95666666666666667},{"$f":"AVERAGE(Fill!I15:I16,Fill!I19)","v":-0.95666666666666667},{"$f":"AVERAGE(Fill!J15:J16,Fill!J19)","v":1.1133333333333333},{"$f":"AVERAGE(Fill!K15:K16,Fill!K19)","v":-1.1133333333333333},{"$f":"AVERAGE(Fill!L15:L16,Fill!L19)","v":1.21},{"$f":"AVERAGE(Fill!M15:M16,Fill!M19)","v":-1.21},{"$f":"AVERAGE(Fill!N15:N16,Fill!N19)","v":1.6333333333333335},{"$f":"AVERAGE(Fill!O15:O16,Fill!O19)","v":-1.6333333333333335},{"$f":"AVERAGE(Fill!P15:P16,Fill!P19)","v":1.6533333333333333},{"$f":"AVERAGE(Fill!Q15:Q16,Fill!Q19)","v":-1.6533333333333333},{"$f":"AVERAGE(Fill!R15:R16,Fill!R19)","v":1.7033333333333334},{"$f":"AVERAGE(Fill!S15:S16,Fill!S19)","v":-1.7033333333333334},{"$f":"AVERAGE(Fill!T15:T16,Fill!T19)","v":1.21},{"$f":"AVERAGE(Fill!U15:U16,Fill!U19)","v":-1.21},{"$f":"SUM(SUMS!M18)","v":0},{"$f":"SUM(SUMS!M19)","v":10.676666666666666},{"$f":"SUM(SUMS!M20)","v":-10.676666666666666}]
[null,null,null,"Speech impairment",null,{"$f":"AVERAGE(Fill!F15)","v":1.03},{"$f":"AVERAGE(Fill!G15)","v":-1.03},{"$f":"AVERAGE(Fill!H15)","v":0.63},{"$f":"AVERAGE(Fill!I15)","v":-0.63},{"$f":"AVERAGE(Fill!J15)","v":0.95},{"$f":"AVERAGE(Fill!K15)","v":-0.95},{"$f":"AVERAGE(Fill!L15)","v":1.1599999999999999},{"$f":"AVERAGE(Fill!M15)","v":-1.1599999999999999},{"$f":"AVERAGE(Fill!N15)","v":1.34},{"$f":"AVERAGE(Fill!O15)","v":-1.34},{"$f":"AVERAGE(Fill!P15)","v":1.44},{"$f":"AVERAGE(Fill!Q15)","v":-1.44},{"$f":"AVERAGE(Fill!R15)","v":1.51},{"$f":"AVERAGE(Fill!S15)","v":-1.51},{"$f":"AVERAGE(Fill!T15)","v":0.89},{"$f":"AVERAGE(Fill!U15)","v":-0.89},{"$f":"SUM(SUMS!N18)","v":0},{"$f":"SUM(SUMS!N19)","v":8.9500000000000011},{"$f":"SUM(SUMS!N20)","v":-8.9500000000000011}]
[null,null,null,"Physical impairment",null,{"$f":"AVERAGE(Fill!F18:F19)","v":1.3599999999999999},{"$f":"AVERAGE(Fill!G18:G19)","v":-1.3599999999999999},{"$f":"AVERAGE(Fill!H18:H19)","v":0.72499999999999998},{"$f":"AVERAGE(Fill!I18:I19)","v":-0.72499999999999998},{"$f":"AVERAGE(Fill!J18:J19)","v":0.99},{"$f":"AVERAGE(Fill!K18:K19)","v":-0.99},{"$f":"AVERAGE(Fill!L18:L19)","v":1.5150000000000001},{"$f":"AVERAGE(Fill!M18:M19)","v":-1.5150000000000001},{"$f":"AVERAGE(Fill!N18:N19)","v":2},{"$f":"AVERAGE(Fill!O18:O19)","v":-2},{"$f":"AVERAGE(Fill!P18:P19)","v":1.875},{"$f":"AVERAGE(Fill!Q18:Q19)","v":-1.875},{"$f":"AVERAGE(Fill!R18:R19)","v":1.7450000000000001},{"$f":"AVERAGE(Fill!S18:S19)","v":-1.7450000000000001},{"$f":"AVERAGE(Fill!T18:T19)","v":1.5699999999999998},{"$f":"AVERAGE(Fill!U18:U19)","v":-1.5699999999999998},{"$f":"SUM(SUMS!O18)","v":0},{"$f":"SUM(SUMS!O19)","v":11.780000000000001},{"$f":"SUM(SUMS!O20)","v":-11.780000000000001}]
[null,null,null,"Developmental condition",null,{"$f":"AVERAGE(Fill!F15:F19)","v":1.2979999999999998},{"$f":"AVERAGE(Fill!G15:G19)","v":-1.2979999999999998},{"$f":"AVERAGE(Fill!H15:H19)","v":0.94199999999999995},{"$f":"AVERAGE(Fill!I15:I19)","v":-0.94199999999999995},{"$f":"AVERAGE(Fill!J15:J19)","v":1.1379999999999999},{"$f":"AVERAGE(Fill!K15:K19)","v":-1.1379999999999999},{"$f":"AVERAGE(Fill!L15:L19)","v":1.272},{"$f":"AVERAGE(Fill!M15:M19)","v":-1.272},{"$f":"AVERAGE(Fill!N15:N19)","v":1.64},{"$f":"AVERAGE(Fill!O15:O19)","v":-1.64},{"$f":"AVERAGE(Fill!P15:P19)","v":1.7759999999999998},{"$f":"AVERAGE(Fill!Q15:Q19)","v":-1.7759999999999998},{"$f":"AVERAGE(Fill!R15:R19)","v":1.752},{"$f":"AVERAGE(Fill!S15:S19)","v":-1.752},{"$f":"AVERAGE(Fill!T15:T19)","v":1.222},{"$f":"AVERAGE(Fill!U15:U19)","v":-1.222},{"$f":"SUM(SUMS!P18)","v":0},{"$f":"SUM(SUMS!P19)","v":11.04},{"$f":"SUM(SUMS!P20)","v":-11.04}]
[null,null,null,"Mental health ",null,{"$f":"AVERAGE(Fill!F15:F19)","v":1.2979999999999998},{"$f":"AVERAGE(Fill!G15:G19)","v":-1.2979999999999998},{"$f":"AVERAGE(Fill!H15:H19)","v":0.94199999999999995},{"$f":"AVERAGE(Fill!I15:I19)","v":-0.94199999999999995},{"$f":"AVERAGE(Fill!J15:J19)","v":1.1379999999999999},{"$f":"AVERAGE(Fill!K15:K19)","v":-1.1379999999999999},{"$f":"AVERAGE(Fill!L15:L19)","v":1.272},{"$f":"AVERAGE(Fill!M15:M19)","v":-1.272},{"$f":"AVERAGE(Fill!N15:N19)","v":1.64},{"$f":"AVERAGE(Fill!O15:O19)","v":-1.64},{"$f":"AVERAGE(Fill!P15:P19)","v":1.7759999999999998},{"$f":"AVERAGE(Fill!Q15:Q19)","v":-1.7759999999999998},{"$f":"AVERAGE(Fill!R15:R19)","v":1.752},{"$f":"AVERAGE(Fill!S15:S19)","v":-1.752},{"$f":"AVERAGE(Fill!T15:T19)","v":1.222},{"$f":"AVERAGE(Fill!U15:U19)","v":-1.222},{"$f":"SUM(SUMS!Q18)","v":0},{"$f":"SUM(SUMS!Q19)","v":11.04},{"$f":"SUM(SUMS!Q20)","v":-11.04}]
[null,null,null,"Chronic/serious illness ",null,{"$f":"AVERAGE(Fill!F17)","v":1.23},{"$f":"AVERAGE(Fill!G17)","v":-1.23},{"$f":"AVERAGE(Fill!H17)","v":1.01},{"$f":"AVERAGE(Fill!I17)","v":-1.01},{"$f":"AVERAGE(Fill!J17)","v":1.35},{"$f":"AVERAGE(Fill!K17)","v":-1.35},{"$f":"AVERAGE(Fill!L17)","v":1.06},{"$f":"AVERAGE(Fill!M17)","v":-1.06},{"$f":"AVERAGE(Fill!N17)","v":1.3},{"$f":"AVERAGE(Fill!O17)","v":-1.3},{"$f":"AVERAGE(Fill!P17)","v":1.92},{"$f":"AVERAGE(Fill!Q17)","v":-1.92},{"$f":"AVERAGE(Fill!R17)","v":1.82},{"$f":"AVERAGE(Fill!S17)","v":-1.82},{"$f":"AVERAGE(Fill!T17)","v":0.98},{"$f":"AVERAGE(Fill!U17)","v":-0.98},{"$f":"SUM(SUMS!R18)","v":0},{"$f":"SUM(SUMS!R19)","v":10.67},{"$f":"SUM(SUMS!R20)","v":-10.67}]
[null,null,null,"Dementia(s)/ cognitive impairment",null,{"$f":"AVERAGE(Fill!F15:F17,Fill!F19)","v":1.2050000000000001},{"$f":"AVERAGE(Fill!G15:G17,Fill!G19)","v":-1.2050000000000001},{"$f":"AVERAGE(Fill!H15:H17,Fill!H19)","v":0.97},{"$f":"AVERAGE(Fill!I15:I17,Fill!I19)","v":-0.97},{"$f":"AVERAGE(Fill!J15:J17,Fill!J19)","v":1.1724999999999999},{"$f":"AVERAGE(Fill!K15:K17,Fill!K19)","v":-1.1724999999999999},{"$f":"AVERAGE(Fill!L15:L17,Fill!L19)","v":1.1725000000000001},{"$f":"AVERAGE(Fill!M15:M17,Fill!M19)","v":-1.1725000000000001},{"$f":"AVERAGE(Fill!N15:N17,Fill!N19)","v":1.55},{"$f":"AVERAGE(Fill!O15:O17,Fill!O19)","v":-1.55},{"$f":"AVERAGE(Fill!P15:P17,Fill!P19)","v":1.72},{"$f":"AVERAGE(Fill!Q15:Q17,Fill!Q19)","v":-1.72},{"$f":"AVERAGE(Fill!R15:R17,Fill!R19)","v":1.7325000000000002},{"$f":"AVERAGE(Fill!S15:S17,Fill!S19)","v":-1.7325000000000002},{"$f":"AVERAGE(Fill!T15:T17,Fill!T19)","v":1.1525000000000001},{"$f":"AVERAGE(Fill!U15:U17,Fill!U19)","v":-1.1525000000000001},{"$f":"SUM(SUMS!S18)","v":0},{"$f":"SUM(SUMS!S19)","v":10.674999999999999},{"$f":"SUM(SUMS!S20)","v":-10.674999999999999}]
[null,null,null,"Nebuliser, and apnoea monitor ",null,{"$f":"AVERAGE(Fill!F17)","v":1.23},{"$f":"AVERAGE(Fill!G17)","v":-1.23},{"$f":"AVERAGE(Fill!H17)","v":1.01},{"$f":"AVERAGE(Fill!I17)","v":-1.01},{"$f":"AVERAGE(Fill!J17)","v":1.35},{"$f":"AVERAGE(Fill!K17)","v":-1.35},{"$f":"AVERAGE(Fill!L17)","v":1.06},{"$f":"AVERAGE(Fill!M17)","v":-1.06},{"$f":"AVERAGE(Fill!N17)","v":1.3},{"$f":"AVERAGE(Fill!O17)","v":-1.3},{"$f":"AVERAGE(Fill!P17)","v":1.92},{"$f":"AVERAGE(Fill!Q17)","v":-1.92},{"$f":"AVERAGE(Fill!R17)","v":1.82},{"$f":"AVERAGE(Fill!S17)","v":-1.82},{"$f":"AVERAGE(Fill!T17)","v":0.98},{"$f":"AVERAGE(Fill!U17)","v":-0.98},{"$f":"SUM(SUMS!T18)","v":0},{"$f":"SUM(SUMS!T19)","v":10.67},{"$f":"SUM(SUMS!T20)","v":-10.67}]
[null,null,null,"Heart, lung and ventilator ",null,{"$f":"AVERAGE(Fill!F17)","v":1.23},{"$f":"AVERAGE(Fill!G17)","v":-1.23},{"$f":"AVERAGE(Fill!H17)","v":1.01},{"$f":"AVERAGE(Fill!I17)","v":-1.01},{"$f":"AVERAGE(Fill!J17)","v":1.35},{"$f":"AVERAGE(Fill!K17)","v":-1.35},{"$f":"AVERAGE(Fill!L17)","v":1.06},{"$f":"AVERAGE(Fill!M17)","v":-1.06},{"$f":"AVERAGE(Fill!N17)","v":1.3},{"$f":"AVERAGE(Fill!O17)","v":-1.3},{"$f":"AVERAGE(Fill!P17)","v":1.92},{"$f":"AVERAGE(Fill!Q17)","v":-1.92},{"$f":"AVERAGE(Fill!R17)","v":1.82},{"$f":"AVERAGE(Fill!S17)","v":-1.82},{"$f":"AVERAGE(Fill!T17)","v":0.98},{"$f":"AVERAGE(Fill!U17)","v":-0.98},{"$f":"SUM(SUMS!U18)","v":0},{"$f":"SUM(SUMS!U19)","v":10.67},{"$f":"SUM(SUMS!U20)","v":-10.67}]
[null,null,null,"Dialysis, feeding pump and automated medicaiton",null,{"$f":"AVERAGE(Fill!F17)","v":1.23},{"$f":"AVERAGE(Fill!G17)","v":-1.23},{"$f":"AVERAGE(Fill!H17)","v":1.01},{"$f":"AVERAGE(Fill!I17)","v":-1.01},{"$f":"AVERAGE(Fill!J17)","v":1.35},{"$f":"AVERAGE(Fill!K17)","v":-1.35},{"$f":"AVERAGE(Fill!L17)","v":1.06},{"$f":"AVERAGE(Fill!M17)","v":-1.06},{"$f":"AVERAGE(Fill!N17)","v":1.3},{"$f":"AVERAGE(Fill!O17)","v":-1.3},{"$f":"AVERAGE(Fill!P17)","v":1.92},{"$f":"AVERAGE(Fill!Q17)","v":-1.92},{"$f":"AVERAGE(Fill!R17)","v":1.82},{"$f":"AVERAGE(Fill!S17)","v":-1.82},{"$f":"AVERAGE(Fill!T17)","v":0.98},{"$f":"AVERAGE(Fill!U17)","v":-0.98},{"$f":"SUM(SUMS!V18)","v":0},{"$f":"SUM(SUMS!V19)","v":10.67},{"$f":"SUM(SUMS!V20)","v":-10.67}]
[null,null,null,"Oxygen concentrator / use",null,{"$f":"AVERAGE(Fill!F17)","v":1.23},{"$f":"AVERAGE(Fill!G17)","v":-1.23},{"$f":"AVERAGE(Fill!H17)","v":1.01},{"$f":"AVERAGE(Fill!I17)","v":-1.01},{"$f":"AVERAGE(Fill!J17)","v":1.35},{"$f":"AVERAGE(Fill!K17)","v":-1.35},{"$f":"AVERAGE(Fill!L17)","v":1.06},{"$f":"AVERAGE(Fill!M17)","v":-1.06},{"$f":"AVERAGE(Fill!N17)","v":1.3},{"$f":"AVERAGE(Fill!O17)","v":-1.3},{"$f":"AVERAGE(Fill!P17)","v":1.92},{"$f":"AVERAGE(Fill!Q17)","v":-1.92},{"$f":"AVERAGE(Fill!R17)","v":1.82},{"$f":"AVERAGE(Fill!S17)","v":-1.82},{"$f":"AVERAGE(Fill!T17)","v":0.98},{"$f":"AVERAGE(Fill!U17)","v":-0.98},{"$f":"SUM(SUMS!W18)","v":0},{"$f":"SUM(SUMS!W19)","v":10.67},{"$f":"SUM(SUMS!W20)","v":-10.67}]
[null,null,null,"Medicine refrigeration",null,{"$f":"AVERAGE(Fill!F17)","v":1.23},{"$f":"AVERAGE(Fill!G17)","v":-1.23},{"$f":"AVERAGE(Fill!H17)","v":1.01},{"$f":"AVERAGE(Fill!I17)","v":-1.01},{"$f":"AVERAGE(Fill!J17)","v":1.35},{"$f":"AVERAGE(Fill!K17)","v":-1.35},{"$f":"AVERAGE(Fill!L17)","v":1.06},{"$f":"AVERAGE(Fill!M17)","v":-1.06},{"$f":"AVERAGE(Fill!N17)","v":1.3},{"$f":"AVERAGE(Fill!O17)","v":-1.3},{"$f":"AVERAGE(Fill!P17)","v":1.92},{"$f":"AVERAGE(Fill!Q17)","v":-1.92},{"$f":"AVERAGE(Fill!R17)","v":1.82},{"$f":"AVERAGE(Fill!S17)","v":-1.82},{"$f":"AVERAGE(Fill!T17)","v":0.98},{"$f":"AVERAGE(Fill!U17)","v":-0.98},{"$f":"SUM(SUMS!X18)","v":0},{"$f":"SUM(SUMS!X19)","v":10.67},{"$f":"SUM(SUMS!X20)","v":-10.67}]
[null,null,null,"Unable to communicate in English",null,{"$f":"AVERAGE(Fill!F15:F16)","v":1.27},{"$f":"AVERAGE(Fill!G15:G16)","v":-1.27},{"$f":"AVERAGE(Fill!H15:H16)","v":1.125},{"$f":"AVERAGE(Fill!I15:I16)","v":-1.125},{"$f":"AVERAGE(Fill!J15:J16)","v":1.18},{"$f":"AVERAGE(Fill!K15:K16)","v":-1.18},{"$f":"AVERAGE(Fill!L15:L16)","v":1.135},{"$f":"AVERAGE(Fill!M15:M16)","v":-1.135},{"$f":"AVERAGE(Fill!N15:N16)","v":1.4500000000000002},{"$f":"AVERAGE(Fill!O15:O16)","v":-1.4500000000000002},{"$f":"AVERAGE(Fill!P15:P16)","v":1.605},{"$f":"AVERAGE(Fill!Q15:Q16)","v":-1.605},{"$f":"AVERAGE(Fill!R15:R16)","v":1.7250000000000001},{"$f":"AVERAGE(Fill!S15:S16)","v":-1.7250000000000001},{"$f":"AVERAGE(Fill!T15:T16)","v":0.99500000000000011},{"$f":"AVERAGE(Fill!U15:U16)","v":-0.99500000000000011},{"$f":"SUM(SUMS!Y18)","v":0},{"$f":"SUM(SUMS!Y19)","v":10.484999999999999},{"$f":"SUM(SUMS!Y20)","v":-10.484999999999999}]
[null,null,null,"Stair lift, hoist, electric bed",null,{"$f":"AVERAGE(Fill!F17:F19)","v":1.3166666666666667},{"$f":"AVERAGE(Fill!G17:G19)","v":-1.3166666666666667},{"$f":"AVERAGE(Fill!H17:H19)","v":0.82},{"$f":"AVERAGE(Fill!I17:I19)","v":-0.82},{"$f":"AVERAGE(Fill!J17:J19)","v":1.1100000000000001},{"$f":"AVERAGE(Fill!K17:K19)","v":-1.1100000000000001},{"$f":"AVERAGE(Fill!L17:L19)","v":1.3633333333333333},{"$f":"AVERAGE(Fill!M17:M19)","v":-1.3633333333333333},{"$f":"AVERAGE(Fill!N17:N19)","v":1.7666666666666666},{"$f":"AVERAGE(Fill!O17:O19)","v":-1.7666666666666666},{"$f":"AVERAGE(Fill!P17:P19)","v":1.89},{"$f":"AVERAGE(Fill!Q17:Q19)","v":-1.89},{"$f":"AVERAGE(Fill!R17:R19)","v":1.7700000000000002},{"$f":"AVERAGE(Fill!S17:S19)","v":-1.7700000000000002},{"$f":"AVERAGE(Fill!T17:T19)","v":1.3733333333333333},{"$f":"AVERAGE(Fill!U17:U19)","v":-1.3733333333333333},{"$f":"SUM(SUMS!Z18)","v":0},{"$f":"SUM(SUMS!Z19)","v":11.41},{"$f":"SUM(SUMS!Z20)","v":-11.41}]
[null,null,null,"Unable to answer door",null,{"$f":"AVERAGE(Fill!F18:F19)","v":1.3599999999999999},{"$f":"AVERAGE(Fill!G18:G19)","v":-1.3599999999999999},{"$f":"AVERAGE(Fill!H18:H19)","v":0.72499999999999998},{"$f":"AVERAGE(Fill!I18:I19)","v":-0.72499999999999998},{"$f":"AVERAGE(Fill!J18:J19)","v":0.99},{"$f":"AVERAGE(Fill!K18:K19)","v":-0.99},{"$f":"AVERAGE(Fill!L18:L19)","v":1.5150000000000001},{"$f":"AVERAGE(Fill!M18:M19)","v":-1.5150000000000001},{"$f":"AVERAGE(Fill!N18:N19)","v":2},{"$f":"AVERAGE(Fill!O18:O19)","v":-2},{"$f":"AVERAGE(Fill!P18:P19)","v":1.875},{"$f":"AVERAGE(Fill!Q18:Q19)","v":-1.875},{"$f":"AVERAGE(Fill!R18:R19)","v":1.7450000000000001},{"$f":"AVERAGE(Fill!S18:S19)","v":-1.7450000000000001},{"$f":"AVERAGE(Fill!T18:T19)","v":1.5699999999999998},{"$f":"AVERAGE(Fill!U18:U19)","v":-1.5699999999999998},{"$f":"SUM(SUMS!AA18)","v":0},{"$f":"SUM(SUMS!AA19)","v":11.780000000000001},{"$f":"SUM(SUMS!AA20)","v":-11.780000000000001}]
[null,null,null,"MDE electric showering/ bathing",null,{"$f":"AVERAGE(Fill!F17)","v":1.23},{"$f":"AVERAGE(Fill!G17)","v":-1.23},{"$f":"AVERAGE(Fill!H17)","v":1.01},{"$f":"AVERAGE(Fill!I17)","v":-1.01},{"$f":"AVERAGE(Fill!J17)","v":1.35},{"$f":"AVERAGE(Fill!K17)","v":-1.35},{"$f":"AVERAGE(Fill!L17)","v":1.06},{"$f":"AVERAGE(Fill!M17)","v":-1.06},{"$f":"AVERAGE(Fill!N17)","v":1.3},{"$f":"AVERAGE(Fill!O17)","v":-1.3},{"$f":"AVERAGE(Fill!P17)","v":1.92},{"$f":"AVERAGE(Fill!Q17)","v":-1.92},{"$f":"AVERAGE(Fill!R17)","v":1.82},{"$f":"AVERAGE(Fill!S17)","v":-1.82},{"$f":"AVERAGE(Fill!T17)","v":0.98},{"$f":"AVERAGE(Fill!U17)","v":-0.98},{"$f":"SUM(SUMS!AB18)","v":0},{"$f":"SUM(SUMS!AB19)","v":10.67},{"$f":"SUM(SUMS!AB20)","v":-10.67}]
[null,null,null,"Pensionable age",null,{"$f":"AVERAGE(Fill!F17,Fill!F19)","v":1.1400000000000001},{"$f":"AVERAGE(Fill!G17,Fill!G19)","v":-1.1400000000000001},{"$f":"AVERAGE(Fill!H17,Fill!H19)","v":0.81499999999999995},{"$f":"AVERAGE(Fill!I17,Fill!I19)","v":-0.81499999999999995},{"$f":"AVERAGE(Fill!J17,Fill!J19)","v":1.165},{"$f":"AVERAGE(Fill!K17,Fill!K19)","v":-1.165},{"$f":"AVERAGE(Fill!L17,Fill!L19)","v":1.21},{"$f":"AVERAGE(Fill!M17,Fill!M19)","v":-1.21},{"$f":"AVERAGE(Fill!N17,Fill!N19)","v":1.65},{"$f":"AVERAGE(Fill!O17,Fill!O19)","v":-1.65},{"$f":"AVERAGE(Fill!P17,Fill!P19)","v":1.835},{"$f":"AVERAGE(Fill!Q17,Fill!Q19)","v":-1.835},{"$f":"AVERAGE(Fill!R17,Fill!R19)","v":1.74},{"$f":"AVERAGE(Fill!S17,Fill!S19)","v":-1.74},{"$f":"AVERAGE(Fill!T17,Fill!T19)","v":1.31},{"$f":"AVERAGE(Fill!U17,Fill!U19)","v":-1.31},{"$f":"SUM(SUMS!AC18)","v":0},{"$f":"SUM(SUMS!AC19)","v":10.865},{"$f":"SUM(SUMS!AC20)","v":-10.865}]
[null,null,null,"Careline/telecare system",null,{"$f":"AVERAGE(Fill!F15,Fill!F17,Fill!F19)","v":1.1033333333333333},{"$f":"AVERAGE(Fill!G15,Fill!G17,Fill!G19)","v":-1.1033333333333333},{"$f":"AVERAGE(Fill!H15,Fill!H17,Fill!H19)","v":0.75333333333333341},{"$f":"AVERAGE(Fill!I15,Fill!I17,Fill!I19)","v":-0.75333333333333341},{"$f":"AVERAGE(Fill!J15,Fill!J17,Fill!J19)","v":1.0933333333333333},{"$f":"AVERAGE(Fill!K15,Fill!K17,Fill!K19)","v":-1.0933333333333333},{"$f":"AVERAGE(Fill!L15,Fill!L17,Fill!L19)","v":1.1933333333333334},{"$f":"AVERAGE(Fill!M15,Fill!M17,Fill!M19)","v":-1.1933333333333334},{"$f":"AVERAGE(Fill!N15,Fill!N17,Fill!N19)","v":1.5466666666666669},{"$f":"AVERAGE(Fill!O15,Fill!O17,Fill!O19)","v":-1.5466666666666669},{"$f":"AVERAGE(Fill!P15,Fill!P17,Fill!P19)","v":1.7033333333333331},{"$f":"AVERAGE(Fill!Q15,Fill!Q17,Fill!Q19)","v":-1.7033333333333331},{"$f":"AVERAGE(Fill!R15,Fill!R17,Fill!R19)","v":1.6633333333333333},{"$f":"AVERAGE(Fill!S15,Fill!S17,Fill!S19)","v":-1.6633333333333333},{"$f":"AVERAGE(Fill!T15,Fill!T17,Fill!T19)","v":1.17},{"$f":"AVERAGE(Fill!U15,Fill!U17,Fill!U19)","v":-1.17},{"$f":"SUM(SUMS!AD18)","v":0},{"$f":"SUM(SUMS!AD19)","v":10.226666666666667},{"$f":"SUM(SUMS!AD20)","v":-10.226666666666667}]
[null,null,null,"Families with children 5 or under",null,{"$f":"AVERAGE(Fill!F17)","v":1.23},{"$f":"AVERAGE(Fill!G17)","v":-1.23},{"$f":"AVERAGE(Fill!H17)","v":1.01},{"$f":"AVERAGE(Fill!I17)","v":-1.01},{"$f":"AVERAGE(Fill!J17)","v":1.35},{"$f":"AVERAGE(Fill!K17)","v":-1.35},{"$f":"AVERAGE(Fill!L17)","v":1.06},{"$f":"AVERAGE(Fill!M17)","v":-1.06},{"$f":"AVERAGE(Fill!N17)","v":1.3},{"$f":"AVERAGE(Fill!O17)","v":-1.3},{"$f":"AVERAGE(Fill!P17)","v":1.92},{"$f":"AVERAGE(Fill!Q17)","v":-1.92},{"$f":"AVERAGE(Fill!R17)","v":1.82},{"$f":"AVERAGE(Fill!S17)","v":-1.82},{"$f":"AVERAGE(Fill!T17)","v":0.98},{"$f":"AVERAGE(Fill!U17)","v":-0.98},{"$f":"SUM(SUMS!AE18)","v":0},{"$f":"SUM(SUMS!AE19)","v":10.67},{"$f":"SUM(SUMS!AE20)","v":-10.67}]
[null,null,null,"Poor sense of smell/ taste",null,{"$f":"AVERAGE(Fill!F19)","v":1.05},{"$f":"AVERAGE(Fill!G19)","v":-1.05},{"$f":"AVERAGE(Fill!H19)","v":0.62},{"$f":"AVERAGE(Fill!I19)","v":-0.62},{"$f":"AVERAGE(Fill!J19)","v":0.98},{"$f":"AVERAGE(Fill!K19)","v":-0.98},{"$f":"AVERAGE(Fill!L19)","v":1.36},{"$f":"AVERAGE(Fill!M19)","v":-1.36},{"$f":"AVERAGE(Fill!N19)","v":2},{"$f":"AVERAGE(Fill!O19)","v":-2},{"$f":"AVERAGE(Fill!P19)","v":1.75},{"$f":"AVERAGE(Fill!Q19)","v":-1.75},{"$f":"AVERAGE(Fill!R19)","v":1.66},{"$f":"AVERAGE(Fill!S19)","v":-1.66},{"$f":"AVERAGE(Fill!T19)","v":1.64},{"$f":"AVERAGE(Fill!U19)","v":-1.64},{"$f":"SUM(SUMS!AF18)","v":0},{"$f":"SUM(SUMS!AF19)","v":11.06},{"$f":"SUM(SUMS!AF20)","v":-11.06}]
[null,null,null,"Water dependent",null,{"$f":"AVERAGE(Fill!F17)","v":1.23},{"$f":"AVERAGE(Fill!G17)","v":-1.23},{"$f":"AVERAGE(Fill!H17)","v":1.01},{"$f":"AVERAGE(Fill!I17)","v":-1.01},{"$f":"AVERAGE(Fill!J17)","v":1.35},{"$f":"AVERAGE(Fill!K17)","v":-1.35},{"$f":"AVERAGE(Fill!L17)","v":1.06},{"$f":"AVERAGE(Fill!M17)","v":-1.06},{"$f":"AVERAGE(Fill!N17)","v":1.3},{"$f":"AVERAGE(Fill!O17)","v":-1.3},{"$f":"AVERAGE(Fill!P17)","v":1.92},{"$f":"AVERAGE(Fill!Q17)","v":-1.92},{"$f":"AVERAGE(Fill!R17)","v":1.82},{"$f":"AVERAGE(Fill!S17)","v":-1.82},{"$f":"AVERAGE(Fill!T17)","v":0.98},{"$f":"AVERAGE(Fill!U17)","v":-0.98},{"$f":"SUM(SUMS!AG18)","v":0},{"$f":"SUM(SUMS!AG19)","v":10.67},{"$f":"SUM(SUMS!AG20)","v":-10.67}]
[null,null,null,"Temporary - post hospital recovery",null,{"$f":"AVERAGE(Fill!F17)","v":1.23},{"$f":"AVERAGE(Fill!G17)","v":-1.23},{"$f":"AVERAGE(Fill!H17)","v":1.01},{"$f":"AVERAGE(Fill!I17)","v":-1.01},{"$f":"AVERAGE(Fill!J17)","v":1.35},{"$f":"AVERAGE(Fill!K17)","v":-1.35},{"$f":"AVERAGE(Fill!L17)","v":1.06},{"$f":"AVERAGE(Fill!M17)","v":-1.06},{"$f":"AVERAGE(Fill!N17)","v":1.3},{"$f":"AVERAGE(Fill!O17)","v":-1.3},{"$f":"AVERAGE(Fill!P17)","v":1.92},{"$f":"AVERAGE(Fill!Q17)","v":-1.92},{"$f":"AVERAGE(Fill!R17)","v":1.82},{"$f":"AVERAGE(Fill!S17)","v":-1.82},{"$f":"AVERAGE(Fill!T17)","v":0.98},{"$f":"AVERAGE(Fill!U17)","v":-0.98},{"$f":"SUM(SUMS!AH18)","v":0},{"$f":"SUM(SUMS!AH19)","v":10.67},{"$f":"SUM(SUMS!AH20)","v":-10.67}]
[null,null,null,"Temporary - young adult householder (<18)",null,{"$f":"AVERAGE(Fill!F19)","v":1.05},{"$f":"AVERAGE(Fill!G19)","v":-1.05},{"$f":"AVERAGE(Fill!H19)","v":0.62},{"$f":"AVERAGE(Fill!I19)","v":-0.62},{"$f":"AVERAGE(Fill!J19)","v":0.98},{"$f":"AVERAGE(Fill!K19)","v":-0.98},{"$f":"AVERAGE(Fill!L19)","v":1.36},{"$f":"AVERAGE(Fill!M19)","v":-1.36},{"$f":"AVERAGE(Fill!N19)","v":2},{"$f":"AVERAGE(Fill!O19)","v":-2},{"$f":"AVERAGE(Fill!P19)","v":1.75},{"$f":"AVERAGE(Fill!Q19)","v":-1.75},{"$f":"AVERAGE(Fill!R19)","v":1.66},{"$f":"AVERAGE(Fill!S19)","v":-1.66},{"$f":"AVERAGE(Fill!T19)","v":1.64},{"$f":"AVERAGE(Fill!U19)","v":-1.64},{"$f":"SUM(SUMS!AI18)","v":0},{"$f":"SUM(SUMS!AI19)","v":11.06},{"$f":"SUM(SUMS!AI20)","v":-11.06}]
[null,null,null,"Additional presence preferred",null,{"$f":"AVERAGE(Fill!F15)","v":1.03},{"$f":"AVERAGE(Fill!G15)","v":-1.03},{"$f":"AVERAGE(Fill!H15)","v":0.63},{"$f":"AVERAGE(Fill!I15)","v":-0.63},{"$f":"AVERAGE(Fill!J15)","v":0.95},{"$f":"AVERAGE(Fill!K15)","v":-0.95},{"$f":"AVERAGE(Fill!L15)","v":1.1599999999999999},{"$f":"AVERAGE(Fill!M15)","v":-1.1599999999999999},{"$f":"AVERAGE(Fill!N15)","v":1.34},{"$f":"AVERAGE(Fill!O15)","v":-1.34},{"$f":"AVERAGE(Fill!P15)","v":1.44},{"$f":"AVERAGE(Fill!Q15)","v":-1.44},{"$f":"AVERAGE(Fill!R15)","v":1.51},{"$f":"AVERAGE(Fill!S15)","v":-1.51},{"$f":"AVERAGE(Fill!T15)","v":0.89},{"$f":"AVERAGE(Fill!U15)","v":-0.89},{"$f":"SUM(SUMS!AJ18)","v":0},{"$f":"SUM(SUMS!AJ19)","v":8.9500000000000011},{"$f":"SUM(SUMS!AJ20)","v":-8.9500000000000011}]
[null,null,null,"Resricted hand movement",null,{"$f":"AVERAGE(Fill!F17:F19)","v":1.3166666666666667},{"$f":"AVERAGE(Fill!G17:G19)","v":-1.3166666666666667},{"$f":"AVERAGE(Fill!H17:H19)","v":0.82},{"$f":"AVERAGE(Fill!I17:I19)","v":-0.82},{"$f":"AVERAGE(Fill!J17:J19)","v":1.1100000000000001},{"$f":"AVERAGE(Fill!K17:K19)","v":-1.1100000000000001},{"$f":"AVERAGE(Fill!L17:L19)","v":1.3633333333333333},{"$f":"AVERAGE(Fill!M17:M19)","v":-1.3633333333333333},{"$f":"AVERAGE(Fill!N17:N19)","v":1.7666666666666666},{"$f":"AVERAGE(Fill!O17:O19)","v":-1.7666666666666666},{"$f":"AVERAGE(Fill!P17:P19)","v":1.89},{"$f":"AVERAGE(Fill!Q17:Q19)","v":-1.89},{"$f":"AVERAGE(Fill!R17:R19)","v":1.7700000000000002},{"$f":"AVERAGE(Fill!S17:S19)","v":-1.7700000000000002},{"$f":"AVERAGE(Fill!T17:T19)","v":1.3733333333333333},{"$f":"AVERAGE(Fill!U17:U19)","v":-1.3733333333333333},{"$f":"SUM(SUMS!AK18)","v":0},{"$f":"SUM(SUMS!AK19)","v":11.41},{"$f":"SUM(SUMS!AK20)","v":-11.41}]
[null,null,null,"Financial vulnerability",null,{"$f":"AVERAGE(Fill!F14)","v":1.49},{"$f":"AVERAGE(Fill!G14)","v":-1.49},{"$f":"AVERAGE(Fill!H14)","v":0.77},{"$f":"AVERAGE(Fill!I14)","v":-0.77},{"$f":"AVERAGE(Fill!J14)","v":1.3},{"$f":"AVERAGE(Fill!K14)","v":-1.3},{"$f":"AVERAGE(Fill!L14)","v":0.95},{"$f":"AVERAGE(Fill!M14)","v":-0.95},{"$f":"AVERAGE(Fill!N14)","v":1.17},{"$f":"AVERAGE(Fill!O14)","v":-1.17},{"$f":"AVERAGE(Fill!P14)","v":1.41},{"$f":"AVERAGE(Fill!Q14)","v":-1.41},{"$f":"AVERAGE(Fill!R14)","v":1.24},{"$f":"AVERAGE(Fill!S14)","v":-1.24},{"$f":"AVERAGE(Fill!T14)","v":0.92},{"$f":"AVERAGE(Fill!U14)","v":-0.92},{"$f":"SUM(SUMS!AL18)","v":0},{"$f":"SUM(SUMS!AL19)","v":9.25},{"$f":"SUM(SUMS!AL20)","v":-9.25}]
[null,null,null,"When will the impact occur?",null,{"$f":"IF(SUMS!K38=1,SUMS!K39,IF(SUMS!K38=2,SUMS!K40,IF(SUMS!K38=3,\"Not specified\",0)))","v":"Not specified"},{"$f":"IF(SUMS!K38=1,SUMS!K39,IF(SUMS!K38=2,SUMS!K40,IF(SUMS!K38=3,\"Not specified\",0)))","v":"Not specified"},{"$f":"IF(SUMS!L38=1,SUMS!L39,IF(SUMS!L38=2,SUMS!L40,IF(SUMS!L38=3,\"Not specified\",0)))","v":"Not specified"},{"$f":"IF(SUMS!L38=1,SUMS!L39,IF(SUMS!L38=2,SUMS!L40,IF(SUMS!L38=3,\"Not specified\",0)))","v":"Not specified"},{"$f":"IF(SUMS!M38=1,SUMS!M39,IF(SUMS!M38=2,SUMS!M40,IF(SUMS!M38=3,\"Not specified\",0)))","v":"Not specified"},{"$f":"IF(SUMS!M38=1,SUMS!M39,IF(SUMS!M38=2,SUMS!M40,IF(SUMS!M38=3,\"Not specified\",0)))","v":"Not specified"},{"$f":"IF(SUMS!N38=1,SUMS!N39,IF(SUMS!N38=2,SUMS!N40,IF(SUMS!N38=3,\"Not specified\",0)))","v":"Not specified"},{"$f":"IF(SUMS!N38=1,SUMS!N39,IF(SUMS!N38=2,SUMS!N40,IF(SUMS!N38=3,\"Not specified\",0)))","v":"Not specified"},{"$f":"IF(SUMS!O38=1,SUMS!O39,IF(SUMS!O38=2,SUMS!O40,IF(SUMS!O38=3,\"Not specified\",0)))","v":"Not specified"},{"$f":"IF(SUMS!O38=1,SUMS!O39,IF(SUMS!O38=2,SUMS!O40,IF(SUMS!O38=3,\"Not specified\",0)))","v":"Not specified"},{"$f":"IF(SUMS!P38=1,SUMS!P39,IF(SUMS!P38=2,SUMS!P40,IF(SUMS!P38=3,\"Not specified\",0)))","v":"Not specified"},{"$f":"IF(SUMS!P38=1,SUMS!P39,IF(SUMS!P38=2,SUMS!P40,IF(SUMS!P38=3,\"Not specified\",0)))","v":"Not specified"},{"$f":"IF(SUMS!Q38=1,SUMS!Q39,IF(SUMS!Q38=2,SUMS!Q40,IF(SUMS!Q38=3,\"Not specified\",0)))","v":"Not specified"},{"$f":"IF(SUMS!Q38=1,SUMS!Q39,IF(SUMS!Q38=2,SUMS!Q40,IF(SUMS!Q38=3,\"Not specified\",0)))","v":"Not specified"},{"$f":"IF(SUMS!R38=1,SUMS!R39,IF(SUMS!R38=2,SUMS!R40,IF(SUMS!R38=3,\"Not specified\",0)))","v":"Not specified"},{"$f":"IF(SUMS!R38=1,SUMS!R39,IF(SUMS!R38=2,SUMS!R40,IF(SUMS!R38=3,\"Not specified\",0)))","v":"Not specified"}]
[]
[null,null,null,"High positive:","1.5 < x"]
[null,null,null,"Low positive:","0.5 < x < 1.5"]
[null,null,null,"Neutral impact:"," -0.5 < x < 0.5"]
[null,null,null,"Low negative:"," -1.5 < x < -0.5"]
[null,null,null,"High negative:"," -x < -1.5"]
[null,null,null,"Not relevant:","N/A"]
[]
[]
[null,null,"HIGH-LEVEL MITIGATIONS"]
[]
[null,null,"There is no need to take mitigation measures. Below are your answers to the questions and project impact scores."]
[null,null,"Project increases costs for households"]
[null,null,"Where costs are expected to increase as a result of new ‘systems’ installed in the customer’s premises, stakeholders believe it is essential to ensure that customers in vulnerable situations can use these properly to avoid further bill impacts. "]
[null,null,"Project hinders the exchange of information between networks and customers"]
[null,null,"Engage different groups of vulnerable customers and their representatives to understand preferred channels, identify the optimal format and type of content. Gathering and communicating tailored information effectively is critical."]
[null,null,"Project hinders the network's understanding of customers' needs and the ability to address these"]
[null,null,"Customers with communication disabilities are often underrepresented in data collected. Networks should ensure that provisions are made to engage these customers through their preferred method of communication."]
[null,null,"Project increases the need for, time taken and disruption cased by staff vists to customers' homes"]
[null,null,"To date, stakeholders have not shared recommendations on how to mitigate this type of impact on customers in vulnerable situations. "]
[null,null,"Project hinders health, safety and accessibility within or immediately  around customers' homes"]
[null,null,"To date, stakeholders have not shared recommendations on how to mitigate this type of impact on customers in vulnerable situations. "]
[null,null,"Project hinders customers' ability to heat, cook, wash and use medical equipment during supply interruptions"]
[null,null,"To date, stakeholders have not shared recommendations on how to mitigate this type of impact on customers in vulnerable situations. "]
[null,null,"Project increases the occurrence and duration of supply interruptions"]
[null,null,"To date, stakeholders have not shared recommendations on how to mitigate this type of impact on customers in vulnerable situations. "]
[null,null,"Project increases the need for, time taken, and space required to work on trees and public and private roads in residential areas"]
[null,null,"To date, stakeholders have not shared recommendations on how to mitigate this type of impact on customers in vulnerable situations. "]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"QUESTIONS AND ANSWERS"]
[null,null,"Is the Project expected to:"]
[null,null,"1) focus on reserch only, and not deliver any immediate impacts on customers or the network?"]
[]
[null,null,"2) impact customers directly or indirectly?"]
[]
[null,null,"3) reduce or increase costs (such as bills, appliance maintenance, etc.) for households?"]
[]
[null,null,{"$f":"Questions!D12","v":"Reasoning:"}]
[null,null,"4) improve or hinder the exchange of information between networks and customers?"]
[]
[null,null,{"$f":"Questions!D14","v":"Reasoning:"}]
[null,null,"5) improve or hinder the network’s ability to cater to customer needs?"]
[]
[null,null,{"$f":"Questions!D16","v":"Reasoning:"}]
[null,null,"6) reduce or increase the need, time taken, and disruptions caused by staff visits to customers' homes?"]
[]
[null,null,{"$f":"Questions!D18","v":"Reasoning:"}]
[null,null,"7) improve or hinder customers' health, safety, and accessibility within or immediately around the home?"]
[]
[null,null,{"$f":"Questions!D20","v":"Reasoning:"}]
[null,null,"8) improve or hinder customers' ability to heat, cook, wash and use medical equipment during supply interruptions?"]
[]
[null,null,{"$f":"Questions!D22","v":"Reasoning:"}]
[null,null,"9) reduce or increase the occurrence and duration of supply interruptions?"]
[]
[null,null,{"$f":"Questions!D24","v":"Reasoning:"}]
[null,null,"10) reduce or increase the need for, time taken, and space required to work on trees and public and private roads in residential areas?"]
[]
[null,null,{"$f":"Questions!D26","v":"Reasoning:"}]
[]
[]
[null,null,"OVERALL PROJECT SCORE"]
[null,null,"Project Impact score"]
[null,null,null,"Overall Project Score:",{"$f":"IFERROR(10*('Results Dashboard'!G12/('Results Dashboard'!G12+'Results Dashboard'!G13)),0)","v":5}]
[null,null,"Relative Impact Score:",null,{"$f":"(SUMS!C35-SUMS!C37)/(SUMS!C36-SUMS!C37)*10","v":5}]
[null,null,"Positive Impact Score:",null,{"$f":"(SUMS!C38-SUMS!C40)/(SUMS!C36-SUMS!C40)*10","v":10.073886261969722}]
[null,null,"Negative Impact Score:",null,{"$f":"((SUMS!C39*-1)-SUMS!C40)/(SUMS!C36-SUMS!C40)*10","v":10.073886261969722}]
[]
[null,null,"Customer Impact Calculator"]
[null,null,"Situation of Vulnerability:",null,{"$f":"IF(SUMS!$K$44=1,SUMS!K45,IF(SUMS!$K$44=2,SUMS!K46,IF(SUMS!$K$44=3,SUMS!K47,IF(SUMS!$K$44=4,SUMS!K48,IF(SUMS!$K$44=5,SUMS!K49,IF(SUMS!$K$44=6,SUMS!K50,IF(SUMS!$K$44=7,SUMS!K51,IF(SUMS!$K$44=8,SUMS!K52,IF(SUMS!$K$44=9,SUMS!K53,IF(SUMS!$K$44=10,SUMS!K54,IF(SUMS!$K$44=11,SUMS!K55,IF(SUMS!$K$44=12,SUMS!K56,IF(SUMS!$K$44=13,SUMS!K57,IF(SUMS!$K$44=14,SUMS!K58,IF(SUMS!$K$44=15,SUMS!K59,IF(SUMS!$K$44=16,SUMS!K60,IF(SUMS!$K$44=17,SUMS!K61,IF(SUMS!$K$44=18,SUMS!K62,IF(SUMS!$K$44=19,SUMS!K63,IF(SUMS!$K$44=20,SUMS!K64,IF(SUMS!$K$44=21,SUMS!K65,IF(SUMS!$K$44=22,SUMS!K66,IF(SUMS!$K$44=23,SUMS!K67,IF(SUMS!$K$44=24,SUMS!K68, IF(SUMS!$K$44=25,SUMS!K69,IF(SUMS!$K$44=26,SUMS!K70,IF(SUMS!$K$44=27,SUMS!K71,IF(SUMS!$K$44=28,SUMS!K72,IF(SUMS!$K$44=29,\"NOT SELECTED\",0)))))))))))))))))))))))))))))","v":"NOT SELECTED"}]
[null,null,"Overall Impact Score:",null,{"$f":"IF(SUMS!$K$44=1,SUMS!K34,IF(SUMS!$K$44=2,SUMS!L34,IF(SUMS!$K$44=3,SUMS!M34,IF(SUMS!$K$44=4,SUMS!N34,IF(SUMS!$K$44=5,SUMS!O34,IF(SUMS!$K$44=6,SUMS!P34,IF(SUMS!$K$44=7,SUMS!Q34,IF(SUMS!$K$44=8,SUMS!R34,IF(SUMS!$K$44=9,SUMS!S34,IF(SUMS!$K$44=10,SUMS!T34,IF(SUMS!$K$44=11,SUMS!U34,IF(SUMS!$K$44=12,SUMS!V34,IF(SUMS!$K$44=13,SUMS!W34,IF(SUMS!$K$44=14,SUMS!X34,IF(SUMS!$K$44=15,SUMS!Y34,IF(SUMS!$K$44=16,SUMS!Z34,IF(SUMS!$K$44=17,SUMS!AA34,IF(SUMS!$K$44=18,SUMS!AB34,IF(SUMS!$K$44=19,SUMS!AC34,IF(SUMS!$K$44=20,SUMS!AD34,IF(SUMS!$K$44=21,SUMS!AE34,IF(SUMS!$K$44=22,SUMS!AF34,IF(SUMS!$K$44=23,SUMS!AG34,IF(SUMS!$K$44=24,SUMS!AH34, IF(SUMS!$K$44=25,SUMS!AI34,IF(SUMS!$K$44=26,SUMS!AJ34,IF(SUMS!$K$44=27,SUMS!AK34,IF(SUMS!$K$44=28,SUMS!AL34,IF(SUMS!$K$44=29,\"\",0)))))))))))))))))))))))))))))","v":""}]

{"sheet":"Spider Diagram","index":5,"n_rows":2,"n_cols":21,"rows_kept":2,"cut":false,"hidden":true,"merged":[]}
[null,null,null,null,null," Impact on Household Costs"," Impact on Household Costs","Understanding of information exchanged","Understanding of information exchanged","Understanding of individual needs","Understanding of individual needs","Disruption caused by staff visits to homes","Disruption caused by staff visits to homes","Health, Safety and Accessibility in/near homes","Health, Safety and Accessibility in/near homes","Satisfy essential needs during interruptions","Satisfy essential needs during interruptions","Impact of supply interruptions","Impact of supply interruptions","Distruption on Public Roads","Distruption on Public Roads"]
[null,null,null,null,null,{"$f":"IF(AND(SUMS!$K$44=1,Questions!H34=TRUE),'Detailed Results'!$F$15,IF(AND(SUMS!$K$44=1,Questions!H34=FALSE),'Detailed Results'!$G$15,IF(AND(SUMS!$K$44=2,Questions!H34=TRUE),'Detailed Results'!$F$16,IF(AND(SUMS!$K$44=2,Questions!H34=FALSE),'Detailed Results'!$G$16,IF(AND(SUMS!$K$44=3,Questions!H34=TRUE),'Detailed Results'!$F$17,IF(AND(SUMS!$K$44=3,Questions!H34=FALSE),'Detailed Results'!$G$17,IF(AND(SUMS!$K$44=4,Questions!H34=TRUE),'Detailed Results'!$F$18,IF(AND(SUMS!$K$44=4,Questions!H34=FALSE),'Detailed Results'!$G$18,IF(AND(SUMS!$K$44=5,Questions!H34=TRUE),'Detailed Results'!$F$19,IF(AND(SUMS!$K$44=5,Questions!H34=FALSE),'Detailed Results'!$G$19,IF(AND(SUMS!$K$44=6,Questions!H34=TRUE),'Detailed Results'!$F$20,IF(AND(SUMS!$K$44=6,Questions!H34=FALSE),'Detailed Results'!$G$20,IF(AND(SUMS!$K$44=7,Questions!H34=TRUE),'Detailed Results'!$F$21,IF(AND(SUMS!$K$44=7,Questions!H34=FALSE),'Detailed Results'!$G$21,IF(AND(SUMS!$K$44=8,Questions!H34=TRUE),'Detailed Results'!$F$22,IF(AND(SUMS!$K$44=8,Questions!H34=FALSE),'Detailed Results'!$G$22,IF(AND(SUMS!$K$44=9,Questions!H34=TRUE),'Detailed Results'!$F$23,IF(AND(SUMS!$K$44=9,Questions!H34=FALSE),'Detailed Results'!$G$23,IF(AND(SUMS!$K$44=10,Questions!H34=TRUE),'Detailed Results'!$F$24,IF(AND(SUMS!$K$44=10,Questions!H34=FALSE),'Detailed Results'!$G$24,IF(AND(SUMS!$K$44=11,Questions!H34=TRUE),'Detailed Results'!$F$25,IF(AND(SUMS!$K$44=11,Questions!H34=FALSE),'Detailed Results'!$G$25,IF(AND(SUMS!$K$44=12,Questions!H34=TRUE),'Detailed Results'!$F$26,IF(AND(SUMS!$K$44=12,Questions!H34=FALSE),'Detailed Results'!$G$26,IF(AND(SUMS!$K$44=13,Questions!H34=TRUE),'Detailed Results'!$F$27,IF(AND(SUMS!$K$44=13,Questions!H34=FALSE),'Detailed Results'!$G$27,IF(AND(SUMS!$K$44=14,Questions!H34=TRUE),'Detailed Results'!$F$28,IF(AND(SUMS!$K$44=14,Questions!H34=FALSE),'Detailed Results'!$G$28,IF(AND(SUMS!$K$44=15,Questions!H34=TRUE),'Detailed Results'!$F$29,IF(AND(SUMS!$K$44=15,Questions!H34=FALSE),'Detailed Results'!$G$29,IF(AND(SUMS!$K$44=16,Questions!H34=TRUE),'Detailed Results'!$F$30,IF(AND(SUMS!$K$44=16,Questions!H34=FALSE),'Detailed Results'!$G$30,IF(AND(SUMS!$K$44=17,Questions!H34=TRUE),'Detailed Results'!$F$31,IF(AND(SUMS!$K$44=17,Questions!H34=FALSE),'Detailed Results'!$G$31,IF(AND(SUMS!$K$44=18,Questions!H34=TRUE),'Detailed Results'!$F$32,IF(AND(SUMS!$K$44=18,Questions!H34=FALSE),'Detailed Results'!$G$32,IF(AND(SUMS!$K$44=19,Questions!H34=TRUE),'Detailed Results'!$F$33,IF(AND(SUMS!$K$44=19,Questions!H34=FALSE),'Detailed Results'!$G$33,IF(AND(SUMS!$K$44=20,Questions!H34=TRUE),'Detailed Results'!$F$34,IF(AND(SUMS!$K$44=20,Questions!H34=FALSE),'Detailed Results'!$G$34,IF(AND(SUMS!$K$44=21,Questions!H34=TRUE),'Detailed Results'!$F$35,IF(AND(SUMS!$K$44=21,Questions!H34=FALSE),'Detailed Results'!$G$35,IF(AND(SUMS!$K$44=22,Questions!H34=TRUE),'Detailed Results'!$F$36,IF(AND(SUMS!$K$44=22,Questions!H34=FALSE),'Detailed Results'!$G$36,IF(AND(SUMS!$K$44=23,Questions!H34=TRUE),'Detailed Results'!$F$37,IF(AND(SUMS!$K$44=23,Questions!H34=FALSE),'Detailed Results'!$G$37,IF(AND(SUMS!$K$44=24,Questions!H34=TRUE),'Detailed Results'!$F$38,IF(AND(SUMS!$K$44=24,Questions!H34=FALSE),'Detailed Results'!$G$38,IF(AND(SUMS!$K$44=25,Questions!H34=TRUE),'Detailed Results'!$F$39,IF(AND(SUMS!$K$44=25,Questions!H34=FALSE),'Detailed Results'!$G$39,IF(AND(SUMS!$K$44=26,Questions!H34=TRUE),'Detailed Results'!$F$40,IF(AND(SUMS!$K$44=26,Questions!H34=FALSE),'Detailed Results'!$G$40,IF(AND(SUMS!$K$44=27,Questions!H34=TRUE),'Detailed Results'!$F$41,IF(AND(SUMS!$K$44=27,Questions!H34=FALSE),'Detailed Results'!$G$41,IF(AND(SUMS!$K$44=28,Questions!H34=TRUE),'Detailed Results'!$F$42,IF(AND(SUMS!$K$44=28,Questions!H34=FALSE),'Detailed Results'!$G$42,\"\"))))))))))))))))))))))))))))))))))))))))))))))))))))))))","v":""},-3,{"$f":"IF(AND(SUMS!$K$44=1,Questions!H35=TRUE),'Detailed Results'!$H$15,IF(AND(SUMS!$K$44=1,Questions!H35=FALSE),'Detailed Results'!$I$15,IF(AND(SUMS!$K$44=2,Questions!H35=TRUE),'Detailed Results'!$H$16,IF(AND(SUMS!$K$44=2,Questions!H35=FALSE),'Detailed Results'!$I$16,IF(AND(SUMS!$K$44=3,Questions!H35=TRUE),'Detailed Results'!$H$17,IF(AND(SUMS!$K$44=3,Questions!H35=FALSE),'Detailed Results'!$I$17,IF(AND(SUMS!$K$44=4,Questions!H35=TRUE),'Detailed Results'!$H$18,IF(AND(SUMS!$K$44=4,Questions!H35=FALSE),'Detailed Results'!$I$18,IF(AND(SUMS!$K$44=5,Questions!H35=TRUE),'Detailed Results'!$H$19,IF(AND(SUMS!$K$44=5,Questions!H35=FALSE),'Detailed Results'!$I$19,IF(AND(SUMS!$K$44=6,Questions!H35=TRUE),'Detailed Results'!$H$20,IF(AND(SUMS!$K$44=6,Questions!H35=FALSE),'Detailed Results'!$I$20,IF(AND(SUMS!$K$44=7,Questions!H35=TRUE),'Detailed Results'!$H$21,IF(AND(SUMS!$K$44=7,Questions!H35=FALSE),'Detailed Results'!$I$21,IF(AND(SUMS!$K$44=8,Questions!H35=TRUE),'Detailed Results'!$H$22,IF(AND(SUMS!$K$44=8,Questions!H35=FALSE),'Detailed Results'!$I$22,IF(AND(SUMS!$K$44=9,Questions!H35=TRUE),'Detailed Results'!$H$23,IF(AND(SUMS!$K$44=9,Questions!H35=FALSE),'Detailed Results'!$I$23,IF(AND(SUMS!$K$44=10,Questions!H35=TRUE),'Detailed Results'!$H$24,IF(AND(SUMS!$K$44=10,Questions!H35=FALSE),'Detailed Results'!$I$24,IF(AND(SUMS!$K$44=11,Questions!H35=TRUE),'Detailed Results'!$H$25,IF(AND(SUMS!$K$44=11,Questions!H35=FALSE),'Detailed Results'!$I$25,IF(AND(SUMS!$K$44=12,Questions!H35=TRUE),'Detailed Results'!$H$26,IF(AND(SUMS!$K$44=12,Questions!H35=FALSE),'Detailed Results'!$I$26,IF(AND(SUMS!$K$44=13,Questions!H35=TRUE),'Detailed Results'!$H$27,IF(AND(SUMS!$K$44=13,Questions!H35=FALSE),'Detailed Results'!$I$27,IF(AND(SUMS!$K$44=14,Questions!H35=TRUE),'Detailed Results'!$H$28,IF(AND(SUMS!$K$44=14,Questions!H35=FALSE),'Detailed Results'!$I$28,IF(AND(SUMS!$K$44=15,Questions!H35=TRUE),'Detailed Results'!$H$29,IF(AND(SUMS!$K$44=15,Questions!H35=FALSE),'Detailed Results'!$I$29,IF(AND(SUMS!$K$44=16,Questions!H35=TRUE),'Detailed Results'!$H$30,IF(AND(SUMS!$K$44=16,Questions!H35=FALSE),'Detailed Results'!$I$30,IF(AND(SUMS!$K$44=17,Questions!H35=TRUE),'Detailed Results'!$H$31,IF(AND(SUMS!$K$44=17,Questions!H35=FALSE),'Detailed Results'!$I$31,IF(AND(SUMS!$K$44=18,Questions!H35=TRUE),'Detailed Results'!$H$32,IF(AND(SUMS!$K$44=18,Questions!H35=FALSE),'Detailed Results'!$I$32,IF(AND(SUMS!$K$44=19,Questions!H35=TRUE),'Detailed Results'!$H$33,IF(AND(SUMS!$K$44=19,Questions!H35=FALSE),'Detailed Results'!$I$33,IF(AND(SUMS!$K$44=20,Questions!H35=TRUE),'Detailed Results'!$H$34,IF(AND(SUMS!$K$44=20,Questions!H35=FALSE),'Detailed Results'!$I$34,IF(AND(SUMS!$K$44=21,Questions!H35=TRUE),'Detailed Results'!$H$35,IF(AND(SUMS!$K$44=21,Questions!H35=FALSE),'Detailed Results'!$I$35,IF(AND(SUMS!$K$44=22,Questions!H35=TRUE),'Detailed Results'!$H$36,IF(AND(SUMS!$K$44=22,Questions!H35=FALSE),'Detailed Results'!$I$36,IF(AND(SUMS!$K$44=23,Questions!H35=TRUE),'Detailed Results'!$H$37,IF(AND(SUMS!$K$44=23,Questions!H35=FALSE),'Detailed Results'!$I$37,IF(AND(SUMS!$K$44=24,Questions!H35=TRUE),'Detailed Results'!$H$38,IF(AND(SUMS!$K$44=24,Questions!H35=FALSE),'Detailed Results'!$I$38,IF(AND(SUMS!$K$44=25,Questions!H35=TRUE),'Detailed Results'!$H$39,IF(AND(SUMS!$K$44=25,Questions!H35=FALSE),'Detailed Results'!$I$39,IF(AND(SUMS!$K$44=26,Questions!H35=TRUE),'Detailed Results'!$H$40,IF(AND(SUMS!$K$44=26,Questions!H35=FALSE),'Detailed Results'!$I$40,IF(AND(SUMS!$K$44=27,Questions!H35=TRUE),'Detailed Results'!$H$41,IF(AND(SUMS!$K$44=27,Questions!H35=FALSE),'Detailed Results'!$I$41,IF(AND(SUMS!$K$44=28,Questions!H35=TRUE),'Detailed Results'!$H$42,IF(AND(SUMS!$K$44=28,Questions!H35=FALSE),'Detailed Results'!$I$42,\"\"))))))))))))))))))))))))))))))))))))))))))))))))))))))))","v":""},-3,{"$f":"IF(AND(SUMS!$K$44=1,Questions!H36=TRUE),'Detailed Results'!$J$15,IF(AND(SUMS!$K$44=1,Questions!H36=FALSE),'Detailed Results'!$K$15,IF(AND(SUMS!$K$44=2,Questions!H36=TRUE),'Detailed Results'!$J$16,IF(AND(SUMS!$K$44=2,Questions!H36=FALSE),'Detailed Results'!$K$16,IF(AND(SUMS!$K$44=3,Questions!H36=TRUE),'Detailed Results'!$J$17,IF(AND(SUMS!$K$44=3,Questions!H36=FALSE),'Detailed Results'!$K$17,IF(AND(SUMS!$K$44=4,Questions!H36=TRUE),'Detailed Results'!$J$18,IF(AND(SUMS!$K$44=4,Questions!H36=FALSE),'Detailed Results'!$K$18,IF(AND(SUMS!$K$44=5,Questions!H36=TRUE),'Detailed Results'!$J$19,IF(AND(SUMS!$K$44=5,Questions!H36=FALSE),'Detailed Results'!$K$19,IF(AND(SUMS!$K$44=6,Questions!H36=TRUE),'Detailed Results'!$J$20,IF(AND(SUMS!$K$44=6,Questions!H36=FALSE),'Detailed Results'!$K$20,IF(AND(SUMS!$K$44=7,Questions!H36=TRUE),'Detailed Results'!$J$21,IF(AND(SUMS!$K$44=7,Questions!H36=FALSE),'Detailed Results'!$K$21,IF(AND(SUMS!$K$44=8,Questions!H36=TRUE),'Detailed Results'!$J$22,IF(AND(SUMS!$K$44=8,Questions!H36=FALSE),'Detailed Results'!$K$22,IF(AND(SUMS!$K$44=9,Questions!H36=TRUE),'Detailed Results'!$J$23,IF(AND(SUMS!$K$44=9,Questions!H36=FALSE),'Detailed Results'!$K$23,IF(AND(SUMS!$K$44=10,Questions!H36=TRUE),'Detailed Results'!$J$24,IF(AND(SUMS!$K$44=10,Questions!H36=FALSE),'Detailed Results'!$K$24,IF(AND(SUMS!$K$44=11,Questions!H36=TRUE),'Detailed Results'!$J$25,IF(AND(SUMS!$K$44=11,Questions!H36=FALSE),'Detailed Results'!$K$25,IF(AND(SUMS!$K$44=12,Questions!H36=TRUE),'Detailed Results'!$J$26,IF(AND(SUMS!$K$44=12,Questions!H36=FALSE),'Detailed Results'!$K$26,IF(AND(SUMS!$K$44=13,Questions!H36=TRUE),'Detailed Results'!$J$27,IF(AND(SUMS!$K$44=13,Questions!H36=FALSE),'Detailed Results'!$K$27,IF(AND(SUMS!$K$44=14,Questions!H36=TRUE),'Detailed Results'!$J$28,IF(AND(SUMS!$K$44=14,Questions!H36=FALSE),'Detailed Results'!$K$28,IF(AND(SUMS!$K$44=15,Questions!H36=TRUE),'Detailed Results'!$J$29,IF(AND(SUMS!$K$44=15,Questions!H36=FALSE),'Detailed Results'!$K$29,IF(AND(SUMS!$K$44=16,Questions!H36=TRUE),'Detailed Results'!$J$30,IF(AND(SUMS!$K$44=16,Questions!H36=FALSE),'Detailed Results'!$K$30,IF(AND(SUMS!$K$44=17,Questions!H36=TRUE),'Detailed Results'!$J$31,IF(AND(SUMS!$K$44=17,Questions!H36=FALSE),'Detailed Results'!$K$31,IF(AND(SUMS!$K$44=18,Questions!H36=TRUE),'Detailed Results'!$J$32,IF(AND(SUMS!$K$44=18,Questions!H36=FALSE),'Detailed Results'!$K$32,IF(AND(SUMS!$K$44=19,Questions!H36=TRUE),'Detailed Results'!$J$33,IF(AND(SUMS!$K$44=19,Questions!H36=FALSE),'Detailed Results'!$K$33,IF(AND(SUMS!$K$44=20,Questions!H36=TRUE),'Detailed Results'!$J$34,IF(AND(SUMS!$K$44=20,Questions!H36=FALSE),'Detailed Results'!$K$34,IF(AND(SUMS!$K$44=21,Questions!H36=TRUE),'Detailed Results'!$J$35,IF(AND(SUMS!$K$44=21,Questions!H36=FALSE),'Detailed Results'!$K$35,IF(AND(SUMS!$K$44=22,Questions!H36=TRUE),'Detailed Results'!$J$36,IF(AND(SUMS!$K$44=22,Questions!H36=FALSE),'Detailed Results'!$K$36,IF(AND(SUMS!$K$44=23,Questions!H36=TRUE),'Detailed Results'!$J$37,IF(AND(SUMS!$K$44=23,Questions!H36=FALSE),'Detailed Results'!$K$37,IF(AND(SUMS!$K$44=24,Questions!H36=TRUE),'Detailed Results'!$J$38,IF(AND(SUMS!$K$44=24,Questions!H36=FALSE),'Detailed Results'!$K$38,IF(AND(SUMS!$K$44=25,Questions!H36=TRUE),'Detailed Results'!$J$39,IF(AND(SUMS!$K$44=25,Questions!H36=FALSE),'Detailed Results'!$K$39,IF(AND(SUMS!$K$44=26,Questions!H36=TRUE),'Detailed Results'!$J$40,IF(AND(SUMS!$K$44=26,Questions!H36=FALSE),'Detailed Results'!$K$40,IF(AND(SUMS!$K$44=27,Questions!H36=TRUE),'Detailed Results'!$J$41,IF(AND(SUMS!$K$44=27,Questions!H36=FALSE),'Detailed Results'!$K$41,IF(AND(SUMS!$K$44=28,Questions!H36=TRUE),'Detailed Results'!$J$42,IF(AND(SUMS!$K$44=28,Questions!H36=FALSE),'Detailed Results'!$K$42,\"\"))))))))))))))))))))))))))))))))))))))))))))))))))))))))","v":""},-3,{"$f":"IF(AND(SUMS!$K$44=1,Questions!H37=TRUE),'Detailed Results'!$L$15,IF(AND(SUMS!$K$44=1,Questions!H37=FALSE),'Detailed Results'!$M$15,IF(AND(SUMS!$K$44=2,Questions!H37=TRUE),'Detailed Results'!$L$16,IF(AND(SUMS!$K$44=2,Questions!H37=FALSE),'Detailed Results'!$M$16,IF(AND(SUMS!$K$44=3,Questions!H37=TRUE),'Detailed Results'!$L$17,IF(AND(SUMS!$K$44=3,Questions!H37=FALSE),'Detailed Results'!$M$17,IF(AND(SUMS!$K$44=4,Questions!H37=TRUE),'Detailed Results'!$L$18,IF(AND(SUMS!$K$44=4,Questions!H37=FALSE),'Detailed Results'!$M$18,IF(AND(SUMS!$K$44=5,Questions!H37=TRUE),'Detailed Results'!$L$19,IF(AND(SUMS!$K$44=5,Questions!H37=FALSE),'Detailed Results'!$M$19,IF(AND(SUMS!$K$44=6,Questions!H37=TRUE),'Detailed Results'!$L$20,IF(AND(SUMS!$K$44=6,Questions!H37=FALSE),'Detailed Results'!$M$20,IF(AND(SUMS!$K$44=7,Questions!H37=TRUE),'Detailed Results'!$L$21,IF(AND(SUMS!$K$44=7,Questions!H37=FALSE),'Detailed Results'!$M$21,IF(AND(SUMS!$K$44=8,Questions!H37=TRUE),'Detailed Results'!$L$22,IF(AND(SUMS!$K$44=8,Questions!H37=FALSE),'Detailed Results'!$M$22,IF(AND(SUMS!$K$44=9,Questions!H37=TRUE),'Detailed Results'!$L$23,IF(AND(SUMS!$K$44=9,Questions!H37=FALSE),'Detailed Results'!$M$23,IF(AND(SUMS!$K$44=10,Questions!H37=TRUE),'Detailed Results'!$L$24,IF(AND(SUMS!$K$44=10,Questions!H37=FALSE),'Detailed Results'!$M$24,IF(AND(SUMS!$K$44=11,Questions!H37=TRUE),'Detailed Results'!$L$25,IF(AND(SUMS!$K$44=11,Questions!H37=FALSE),'Detailed Results'!$M$25,IF(AND(SUMS!$K$44=12,Questions!H37=TRUE),'Detailed Results'!$L$26,IF(AND(SUMS!$K$44=12,Questions!H37=FALSE),'Detailed Results'!$M$26,IF(AND(SUMS!$K$44=13,Questions!H37=TRUE),'Detailed Results'!$L$27,IF(AND(SUMS!$K$44=13,Questions!H37=FALSE),'Detailed Results'!$M$27,IF(AND(SUMS!$K$44=14,Questions!H37=TRUE),'Detailed Results'!$L$28,IF(AND(SUMS!$K$44=14,Questions!H37=FALSE),'Detailed Results'!$M$28,IF(AND(SUMS!$K$44=15,Questions!H37=TRUE),'Detailed Results'!$L$29,IF(AND(SUMS!$K$44=15,Questions!H37=FALSE),'Detailed Results'!$M$29,IF(AND(SUMS!$K$44=16,Questions!H37=TRUE),'Detailed Results'!$L$30,IF(AND(SUMS!$K$44=16,Questions!H37=FALSE),'Detailed Results'!$M$30,IF(AND(SUMS!$K$44=17,Questions!H37=TRUE),'Detailed Results'!$L$31,IF(AND(SUMS!$K$44=17,Questions!H37=FALSE),'Detailed Results'!$M$31,IF(AND(SUMS!$K$44=18,Questions!H37=TRUE),'Detailed Results'!$L$32,IF(AND(SUMS!$K$44=18,Questions!H37=FALSE),'Detailed Results'!$M$32,IF(AND(SUMS!$K$44=19,Questions!H37=TRUE),'Detailed Results'!$L$33,IF(AND(SUMS!$K$44=19,Questions!H37=FALSE),'Detailed Results'!$M$33,IF(AND(SUMS!$K$44=20,Questions!H37=TRUE),'Detailed Results'!$L$34,IF(AND(SUMS!$K$44=20,Questions!H37=FALSE),'Detailed Results'!$M$34,IF(AND(SUMS!$K$44=21,Questions!H37=TRUE),'Detailed Results'!$L$35,IF(AND(SUMS!$K$44=21,Questions!H37=FALSE),'Detailed Results'!$M$35,IF(AND(SUMS!$K$44=22,Questions!H37=TRUE),'Detailed Results'!$L$36,IF(AND(SUMS!$K$44=22,Questions!H37=FALSE),'Detailed Results'!$M$36,IF(AND(SUMS!$K$44=23,Questions!H37=TRUE),'Detailed Results'!$L$37,IF(AND(SUMS!$K$44=23,Questions!H37=FALSE),'Detailed Results'!$M$37,IF(AND(SUMS!$K$44=24,Questions!H37=TRUE),'Detailed Results'!$L$38,IF(AND(SUMS!$K$44=24,Questions!H37=FALSE),'Detailed Results'!$M$38,IF(AND(SUMS!$K$44=25,Questions!H37=TRUE),'Detailed Results'!$L$39,IF(AND(SUMS!$K$44=25,Questions!H37=FALSE),'Detailed Results'!$M$39,IF(AND(SUMS!$K$44=26,Questions!H37=TRUE),'Detailed Results'!$L$40,IF(AND(SUMS!$K$44=26,Questions!H37=FALSE),'Detailed Results'!$M$40,IF(AND(SUMS!$K$44=27,Questions!H37=TRUE),'Detailed Results'!$L$41,IF(AND(SUMS!$K$44=27,Questions!H37=FALSE),'Detailed Results'!$M$41,IF(AND(SUMS!$K$44=28,Questions!H37=TRUE),'Detailed Results'!$L$42,IF(AND(SUMS!$K$44=28,Questions!H37=FALSE),'Detailed Results'!$M$42,\"\"))))))))))))))))))))))))))))))))))))))))))))))))))))))))","v":""},-3,{"$f":"IF(AND(SUMS!$K$44=1,Questions!H38=TRUE),'Detailed Results'!$N$15,IF(AND(SUMS!$K$44=1,Questions!H38=FALSE),'Detailed Results'!$O$15,IF(AND(SUMS!$K$44=2,Questions!H38=TRUE),'Detailed Results'!$N$16,IF(AND(SUMS!$K$44=2,Questions!H38=FALSE),'Detailed Results'!$O$16,IF(AND(SUMS!$K$44=3,Questions!H38=TRUE),'Detailed Results'!$N$17,IF(AND(SUMS!$K$44=3,Questions!H38=FALSE),'Detailed Results'!$O$17,IF(AND(SUMS!$K$44=4,Questions!H38=TRUE),'Detailed Results'!$N$18,IF(AND(SUMS!$K$44=4,Questions!H38=FALSE),'Detailed Results'!$O$18,IF(AND(SUMS!$K$44=5,Questions!H38=TRUE),'Detailed Results'!$N$19,IF(AND(SUMS!$K$44=5,Questions!H38=FALSE),'Detailed Results'!$O$19,IF(AND(SUMS!$K$44=6,Questions!H38=TRUE),'Detailed Results'!$N$20,IF(AND(SUMS!$K$44=6,Questions!H38=FALSE),'Detailed Results'!$O$20,IF(AND(SUMS!$K$44=7,Questions!H38=TRUE),'Detailed Results'!$N$21,IF(AND(SUMS!$K$44=7,Questions!H38=FALSE),'Detailed Results'!$O$21,IF(AND(SUMS!$K$44=8,Questions!H38=TRUE),'Detailed Results'!$N$22,IF(AND(SUMS!$K$44=8,Questions!H38=FALSE),'Detailed Results'!$O$22,IF(AND(SUMS!$K$44=9,Questions!H38=TRUE),'Detailed Results'!$N$23,IF(AND(SUMS!$K$44=9,Questions!H38=FALSE),'Detailed Results'!$O$23,IF(AND(SUMS!$K$44=10,Questions!H38=TRUE),'Detailed Results'!$N$24,IF(AND(SUMS!$K$44=10,Questions!H38=FALSE),'Detailed Results'!$O$24,IF(AND(SUMS!$K$44=11,Questions!H38=TRUE),'Detailed Results'!$N$25,IF(AND(SUMS!$K$44=11,Questions!H38=FALSE),'Detailed Results'!$O$25,IF(AND(SUMS!$K$44=12,Questions!H38=TRUE),'Detailed Results'!$N$26,IF(AND(SUMS!$K$44=12,Questions!H38=FALSE),'Detailed Results'!$O$26,IF(AND(SUMS!$K$44=13,Questions!H38=TRUE),'Detailed Results'!$N$27,IF(AND(SUMS!$K$44=13,Questions!H38=FALSE),'Detailed Results'!$O$27,IF(AND(SUMS!$K$44=14,Questions!H38=TRUE),'Detailed Results'!$N$28,IF(AND(SUMS!$K$44=14,Questions!H38=FALSE),'Detailed Results'!$O$28,IF(AND(SUMS!$K$44=15,Questions!H38=TRUE),'Detailed Results'!$N$29,IF(AND(SUMS!$K$44=15,Questions!H38=FALSE),'Detailed Results'!$O$29,IF(AND(SUMS!$K$44=16,Questions!H38=TRUE),'Detailed Results'!$N$30,IF(AND(SUMS!$K$44=16,Questions!H38=FALSE),'Detailed Results'!$O$30,IF(AND(SUMS!$K$44=17,Questions!H38=TRUE),'Detailed Results'!$N$31,IF(AND(SUMS!$K$44=17,Questions!H38=FALSE),'Detailed Results'!$O$31,IF(AND(SUMS!$K$44=18,Questions!H38=TRUE),'Detailed Results'!$N$32,IF(AND(SUMS!$K$44=18,Questions!H38=FALSE),'Detailed Results'!$O$32,IF(AND(SUMS!$K$44=19,Questions!H38=TRUE),'Detailed Results'!$N$33,IF(AND(SUMS!$K$44=19,Questions!H38=FALSE),'Detailed Results'!$O$33,IF(AND(SUMS!$K$44=20,Questions!H38=TRUE),'Detailed Results'!$N$34,IF(AND(SUMS!$K$44=20,Questions!H38=FALSE),'Detailed Results'!$O$34,IF(AND(SUMS!$K$44=21,Questions!H38=TRUE),'Detailed Results'!$N$35,IF(AND(SUMS!$K$44=21,Questions!H38=FALSE),'Detailed Results'!$O$35,IF(AND(SUMS!$K$44=22,Questions!H38=TRUE),'Detailed Results'!$N$36,IF(AND(SUMS!$K$44=22,Questions!H38=FALSE),'Detailed Results'!$O$36,IF(AND(SUMS!$K$44=23,Questions!H38=TRUE),'Detailed Results'!$N$37,IF(AND(SUMS!$K$44=23,Questions!H38=FALSE),'Detailed Results'!$O$37,IF(AND(SUMS!$K$44=24,Questions!H38=TRUE),'Detailed Results'!$N$38,IF(AND(SUMS!$K$44=24,Questions!H38=FALSE),'Detailed Results'!$O$38,IF(AND(SUMS!$K$44=25,Questions!H38=TRUE),'Detailed Results'!$N$39,IF(AND(SUMS!$K$44=25,Questions!H38=FALSE),'Detailed Results'!$O$39,IF(AND(SUMS!$K$44=26,Questions!H38=TRUE),'Detailed Results'!$N$40,IF(AND(SUMS!$K$44=26,Questions!H38=FALSE),'Detailed Results'!$O$40,IF(AND(SUMS!$K$44=27,Questions!H38=TRUE),'Detailed Results'!$N$41,IF(AND(SUMS!$K$44=27,Questions!H38=FALSE),'Detailed Results'!$O$41,IF(AND(SUMS!$K$44=28,Questions!H38=TRUE),'Detailed Results'!$N$42,IF(AND(SUMS!$K$44=28,Questions!H38=FALSE),'Detailed Results'!$O$42,\"\"))))))))))))))))))))))))))))))))))))))))))))))))))))))))","v":""},-3,{"$f":"IF(AND(SUMS!$K$44=1,Questions!H39=TRUE),'Detailed Results'!$P$15,IF(AND(SUMS!$K$44=1,Questions!H39=FALSE),'Detailed Results'!$Q$15,IF(AND(SUMS!$K$44=2,Questions!H39=TRUE),'Detailed Results'!$P$16,IF(AND(SUMS!$K$44=2,Questions!H39=FALSE),'Detailed Results'!$Q$16,IF(AND(SUMS!$K$44=3,Questions!H39=TRUE),'Detailed Results'!$P$17,IF(AND(SUMS!$K$44=3,Questions!H39=FALSE),'Detailed Results'!$Q$17,IF(AND(SUMS!$K$44=4,Questions!H39=TRUE),'Detailed Results'!$P$18,IF(AND(SUMS!$K$44=4,Questions!H39=FALSE),'Detailed Results'!$Q$18,IF(AND(SUMS!$K$44=5,Questions!H39=TRUE),'Detailed Results'!$P$19,IF(AND(SUMS!$K$44=5,Questions!H39=FALSE),'Detailed Results'!$Q$19,IF(AND(SUMS!$K$44=6,Questions!H39=TRUE),'Detailed Results'!$P$20,IF(AND(SUMS!$K$44=6,Questions!H39=FALSE),'Detailed Results'!$Q$20,IF(AND(SUMS!$K$44=7,Questions!H39=TRUE),'Detailed Results'!$P$21,IF(AND(SUMS!$K$44=7,Questions!H39=FALSE),'Detailed Results'!$Q$21,IF(AND(SUMS!$K$44=8,Questions!H39=TRUE),'Detailed Results'!$P$22,IF(AND(SUMS!$K$44=8,Questions!H39=FALSE),'Detailed Results'!$Q$22,IF(AND(SUMS!$K$44=9,Questions!H39=TRUE),'Detailed Results'!$P$23,IF(AND(SUMS!$K$44=9,Questions!H39=FALSE),'Detailed Results'!$Q$23,IF(AND(SUMS!$K$44=10,Questions!H39=TRUE),'Detailed Results'!$P$24,IF(AND(SUMS!$K$44=10,Questions!H39=FALSE),'Detailed Results'!$Q$24,IF(AND(SUMS!$K$44=11,Questions!H39=TRUE),'Detailed Results'!$P$25,IF(AND(SUMS!$K$44=11,Questions!H39=FALSE),'Detailed Results'!$Q$25,IF(AND(SUMS!$K$44=12,Questions!H39=TRUE),'Detailed Results'!$P$26,IF(AND(SUMS!$K$44=12,Questions!H39=FALSE),'Detailed Results'!$Q$26,IF(AND(SUMS!$K$44=13,Questions!H39=TRUE),'Detailed Results'!$P$27,IF(AND(SUMS!$K$44=13,Questions!H39=FALSE),'Detailed Results'!$Q$27,IF(AND(SUMS!$K$44=14,Questions!H39=TRUE),'Detailed Results'!$P$28,IF(AND(SUMS!$K$44=14,Questions!H39=FALSE),'Detailed Results'!$Q$28,IF(AND(SUMS!$K$44=15,Questions!H39=TRUE),'Detailed Results'!$P$29,IF(AND(SUMS!$K$44=15,Questions!H39=FALSE),'Detailed Results'!$Q$29,IF(AND(SUMS!$K$44=16,Questions!H39=TRUE),'Detailed Results'!$P$30,IF(AND(SUMS!$K$44=16,Questions!H39=FALSE),'Detailed Results'!$Q$30,IF(AND(SUMS!$K$44=17,Questions!H39=TRUE),'Detailed Results'!$P$31,IF(AND(SUMS!$K$44=17,Questions!H39=FALSE),'Detailed Results'!$Q$31,IF(AND(SUMS!$K$44=18,Questions!H39=TRUE),'Detailed Results'!$P$32,IF(AND(SUMS!$K$44=18,Questions!H39=FALSE),'Detailed Results'!$Q$32,IF(AND(SUMS!$K$44=19,Questions!H39=TRUE),'Detailed Results'!$P$33,IF(AND(SUMS!$K$44=19,Questions!H39=FALSE),'Detailed Results'!$Q$33,IF(AND(SUMS!$K$44=20,Questions!H39=TRUE),'Detailed Results'!$P$34,IF(AND(SUMS!$K$44=20,Questions!H39=FALSE),'Detailed Results'!$Q$34,IF(AND(SUMS!$K$44=21,Questions!H39=TRUE),'Detailed Results'!$P$35,IF(AND(SUMS!$K$44=21,Questions!H39=FALSE),'Detailed Results'!$Q$35,IF(AND(SUMS!$K$44=22,Questions!H39=TRUE),'Detailed Results'!$P$36,IF(AND(SUMS!$K$44=22,Questions!H39=FALSE),'Detailed Results'!$Q$36,IF(AND(SUMS!$K$44=23,Questions!H39=TRUE),'Detailed Results'!$P$37,IF(AND(SUMS!$K$44=23,Questions!H39=FALSE),'Detailed Results'!$Q$37,IF(AND(SUMS!$K$44=24,Questions!H39=TRUE),'Detailed Results'!$P$38,IF(AND(SUMS!$K$44=24,Questions!H39=FALSE),'Detailed Results'!$Q$38,IF(AND(SUMS!$K$44=25,Questions!H39=TRUE),'Detailed Results'!$P$39,IF(AND(SUMS!$K$44=25,Questions!H39=FALSE),'Detailed Results'!$Q$39,IF(AND(SUMS!$K$44=26,Questions!H39=TRUE),'Detailed Results'!$P$40,IF(AND(SUMS!$K$44=26,Questions!H39=FALSE),'Detailed Results'!$Q$40,IF(AND(SUMS!$K$44=27,Questions!H39=TRUE),'Detailed Results'!$P$41,IF(AND(SUMS!$K$44=27,Questions!H39=FALSE),'Detailed Results'!$Q$41,IF(AND(SUMS!$K$44=28,Questions!H39=TRUE),'Detailed Results'!$P$42,IF(AND(SUMS!$K$44=28,Questions!H39=FALSE),'Detailed Results'!$Q$42,\"\"))))))))))))))))))))))))))))))))))))))))))))))))))))))))","v":""},-3,{"$f":"IF(AND(SUMS!$K$44=1,Questions!H40<>TRUE),'Detailed Results'!$R$15,IF(AND(SUMS!$K$44=1,Questions!H40=FALSE),'Detailed Results'!$S$15,IF(AND(SUMS!$K$44=2,Questions!H40=TRUE),'Detailed Results'!$R$16,IF(AND(SUMS!$K$44=2,Questions!H40=FALSE),'Detailed Results'!$S$16,IF(AND(SUMS!$K$44=3,Questions!H40=TRUE),'Detailed Results'!$R$17,IF(AND(SUMS!$K$44=3,Questions!H40=FALSE),'Detailed Results'!$S$17,IF(AND(SUMS!$K$44=4,Questions!H40=TRUE),'Detailed Results'!$R$18,IF(AND(SUMS!$K$44=4,Questions!H40=FALSE),'Detailed Results'!$S$18,IF(AND(SUMS!$K$44=5,Questions!H40=TRUE),'Detailed Results'!$R$19,IF(AND(SUMS!$K$44=5,Questions!H40=FALSE),'Detailed Results'!$S$19,IF(AND(SUMS!$K$44=6,Questions!H40=TRUE),'Detailed Results'!$R$20,IF(AND(SUMS!$K$44=6,Questions!H40=FALSE),'Detailed Results'!$S$20,IF(AND(SUMS!$K$44=7,Questions!H40=TRUE),'Detailed Results'!$R$21,IF(AND(SUMS!$K$44=7,Questions!H40=FALSE),'Detailed Results'!$S$21,IF(AND(SUMS!$K$44=8,Questions!H40=TRUE),'Detailed Results'!$R$22,IF(AND(SUMS!$K$44=8,Questions!H40=FALSE),'Detailed Results'!$S$22,IF(AND(SUMS!$K$44=9,Questions!H40=TRUE),'Detailed Results'!$R$23,IF(AND(SUMS!$K$44=9,Questions!H40=FALSE),'Detailed Results'!$S$23,IF(AND(SUMS!$K$44=10,Questions!H40=TRUE),'Detailed Results'!$R$24,IF(AND(SUMS!$K$44=10,Questions!H40=FALSE),'Detailed Results'!$S$24,IF(AND(SUMS!$K$44=11,Questions!H40=TRUE),'Detailed Results'!$R$25,IF(AND(SUMS!$K$44=11,Questions!H40=FALSE),'Detailed Results'!$S$25,IF(AND(SUMS!$K$44=12,Questions!H40=TRUE),'Detailed Results'!$R$26,IF(AND(SUMS!$K$44=12,Questions!H40=FALSE),'Detailed Results'!$S$26,IF(AND(SUMS!$K$44=13,Questions!H40=TRUE),'Detailed Results'!$R$27,IF(AND(SUMS!$K$44=13,Questions!H40=FALSE),'Detailed Results'!$S$27,IF(AND(SUMS!$K$44=14,Questions!H40=TRUE),'Detailed Results'!$R$28,IF(AND(SUMS!$K$44=14,Questions!H40=FALSE),'Detailed Results'!$S$28,IF(AND(SUMS!$K$44=15,Questions!H40=TRUE),'Detailed Results'!$R$29,IF(AND(SUMS!$K$44=15,Questions!H40=FALSE),'Detailed Results'!$S$29,IF(AND(SUMS!$K$44=16,Questions!H40=TRUE),'Detailed Results'!$R$30,IF(AND(SUMS!$K$44=16,Questions!H40=FALSE),'Detailed Results'!$S$30,IF(AND(SUMS!$K$44=17,Questions!H40=TRUE),'Detailed Results'!$R$31,IF(AND(SUMS!$K$44=17,Questions!H40=FALSE),'Detailed Results'!$S$31,IF(AND(SUMS!$K$44=18,Questions!H40=TRUE),'Detailed Results'!$R$32,IF(AND(SUMS!$K$44=18,Questions!H40=FALSE),'Detailed Results'!$S$32,IF(AND(SUMS!$K$44=19,Questions!H40=TRUE),'Detailed Results'!$R$33,IF(AND(SUMS!$K$44=19,Questions!H40=FALSE),'Detailed Results'!$S$33,IF(AND(SUMS!$K$44=20,Questions!H40=TRUE),'Detailed Results'!$R$34,IF(AND(SUMS!$K$44=20,Questions!H40=FALSE),'Detailed Results'!$S$34,IF(AND(SUMS!$K$44=21,Questions!H40=TRUE),'Detailed Results'!$R$35,IF(AND(SUMS!$K$44=21,Questions!H40=FALSE),'Detailed Results'!$S$35,IF(AND(SUMS!$K$44=22,Questions!H40=TRUE),'Detailed Results'!$R$36,IF(AND(SUMS!$K$44=22,Questions!H40=FALSE),'Detailed Results'!$S$36,IF(AND(SUMS!$K$44=23,Questions!H40=TRUE),'Detailed Results'!$R$37,IF(AND(SUMS!$K$44=23,Questions!H40=FALSE),'Detailed Results'!$S$37,IF(AND(SUMS!$K$44=24,Questions!H40=TRUE),'Detailed Results'!$R$38,IF(AND(SUMS!$K$44=24,Questions!H40=FALSE),'Detailed Results'!$S$38,IF(AND(SUMS!$K$44=25,Questions!H40=TRUE),'Detailed Results'!$R$39,IF(AND(SUMS!$K$44=25,Questions!H40=FALSE),'Detailed Results'!$S$39,IF(AND(SUMS!$K$44=26,Questions!H40=TRUE),'Detailed Results'!$R$40,IF(AND(SUMS!$K$44=26,Questions!H40=FALSE),'Detailed Results'!$S$40,IF(AND(SUMS!$K$44=27,Questions!H40=TRUE),'Detailed Results'!$R$41,IF(AND(SUMS!$K$44=27,Questions!H40=FALSE),'Detailed Results'!$S$41,IF(AND(SUMS!$K$44=28,Questions!H40=TRUE),'Detailed Results'!$R$42,IF(AND(SUMS!$K$44=28,Questions!H40=FALSE),'Detailed Results'!$S$42,\"\"))))))))))))))))))))))))))))))))))))))))))))))))))))))))","v":""},-3,{"$f":"IF(AND(SUMS!$K$44=1,Questions!H41=TRUE),'Detailed Results'!$T$15,IF(AND(SUMS!$K$44=1,Questions!H41=FALSE),'Detailed Results'!$U$15,IF(AND(SUMS!$K$44=2,Questions!H41=TRUE),'Detailed Results'!$T$16,IF(AND(SUMS!$K$44=2,Questions!H41=FALSE),'Detailed Results'!$U$16,IF(AND(SUMS!$K$44=3,Questions!H41=TRUE),'Detailed Results'!$T$17,IF(AND(SUMS!$K$44=3,Questions!H41=FALSE),'Detailed Results'!$U$17,IF(AND(SUMS!$K$44=4,Questions!H41=TRUE),'Detailed Results'!$T$18,IF(AND(SUMS!$K$44=4,Questions!H41=FALSE),'Detailed Results'!$U$18,IF(AND(SUMS!$K$44=5,Questions!H41=TRUE),'Detailed Results'!$T$19,IF(AND(SUMS!$K$44=5,Questions!H41=FALSE),'Detailed Results'!$U$19,IF(AND(SUMS!$K$44=6,Questions!H41=TRUE),'Detailed Results'!$T$20,IF(AND(SUMS!$K$44=6,Questions!H41=FALSE),'Detailed Results'!$U$20,IF(AND(SUMS!$K$44=7,Questions!H41=TRUE),'Detailed Results'!$T$21,IF(AND(SUMS!$K$44=7,Questions!H41=FALSE),'Detailed Results'!$U$21,IF(AND(SUMS!$K$44=8,Questions!H41=TRUE),'Detailed Results'!$T$22,IF(AND(SUMS!$K$44=8,Questions!H41=FALSE),'Detailed Results'!$U$22,IF(AND(SUMS!$K$44=9,Questions!H41=TRUE),'Detailed Results'!$T$23,IF(AND(SUMS!$K$44=9,Questions!H41=FALSE),'Detailed Results'!$U$23,IF(AND(SUMS!$K$44=10,Questions!H41=TRUE),'Detailed Results'!$T$24,IF(AND(SUMS!$K$44=10,Questions!H41=FALSE),'Detailed Results'!$U$24,IF(AND(SUMS!$K$44=11,Questions!H41=TRUE),'Detailed Results'!$T$25,IF(AND(SUMS!$K$44=11,Questions!H41=FALSE),'Detailed Results'!$U$25,IF(AND(SUMS!$K$44=12,Questions!H41=TRUE),'Detailed Results'!$T$26,IF(AND(SUMS!$K$44=12,Questions!H41=FALSE),'Detailed Results'!$U$26,IF(AND(SUMS!$K$44=13,Questions!H41=TRUE),'Detailed Results'!$T$27,IF(AND(SUMS!$K$44=13,Questions!H41=FALSE),'Detailed Results'!$U$27,IF(AND(SUMS!$K$44=14,Questions!H41=TRUE),'Detailed Results'!$T$28,IF(AND(SUMS!$K$44=14,Questions!H41=FALSE),'Detailed Results'!$U$28,IF(AND(SUMS!$K$44=15,Questions!H41=TRUE),'Detailed Results'!$T$29,IF(AND(SUMS!$K$44=15,Questions!H41=FALSE),'Detailed Results'!$U$29,IF(AND(SUMS!$K$44=16,Questions!H41=TRUE),'Detailed Results'!$T$30,IF(AND(SUMS!$K$44=16,Questions!H41=FALSE),'Detailed Results'!$U$30,IF(AND(SUMS!$K$44=17,Questions!H41=TRUE),'Detailed Results'!$T$31,IF(AND(SUMS!$K$44=17,Questions!H41=FALSE),'Detailed Results'!$U$31,IF(AND(SUMS!$K$44=18,Questions!H41=TRUE),'Detailed Results'!$T$32,IF(AND(SUMS!$K$44=18,Questions!H41=FALSE),'Detailed Results'!$U$32,IF(AND(SUMS!$K$44=19,Questions!H41=TRUE),'Detailed Results'!$T$33,IF(AND(SUMS!$K$44=19,Questions!H41=FALSE),'Detailed Results'!$U$33,IF(AND(SUMS!$K$44=20,Questions!H41=TRUE),'Detailed Results'!$T$34,IF(AND(SUMS!$K$44=20,Questions!H41=FALSE),'Detailed Results'!$U$34,IF(AND(SUMS!$K$44=21,Questions!H41=TRUE),'Detailed Results'!$T$35,IF(AND(SUMS!$K$44=21,Questions!H41=FALSE),'Detailed Results'!$U$35,IF(AND(SUMS!$K$44=22,Questions!H41=TRUE),'Detailed Results'!$T$36,IF(AND(SUMS!$K$44=22,Questions!H41=FALSE),'Detailed Results'!$U$36,IF(AND(SUMS!$K$44=23,Questions!H41=TRUE),'Detailed Results'!$T$37,IF(AND(SUMS!$K$44=23,Questions!H41=FALSE),'Detailed Results'!$U$37,IF(AND(SUMS!$K$44=24,Questions!H41=TRUE),'Detailed Results'!$T$38,IF(AND(SUMS!$K$44=24,Questions!H41=FALSE),'Detailed Results'!$U$38,IF(AND(SUMS!$K$44=25,Questions!H41=TRUE),'Detailed Results'!$T$39,IF(AND(SUMS!$K$44=25,Questions!H41=FALSE),'Detailed Results'!$U$39,IF(AND(SUMS!$K$44=26,Questions!H41=TRUE),'Detailed Results'!$T$40,IF(AND(SUMS!$K$44=26,Questions!H41=FALSE),'Detailed Results'!$U$40,IF(AND(SUMS!$K$44=27,Questions!H41=TRUE),'Detailed Results'!$T$41,IF(AND(SUMS!$K$44=27,Questions!H41=FALSE),'Detailed Results'!$U$41,IF(AND(SUMS!$K$44=28,Questions!H41=TRUE),'Detailed Results'!$T$42,IF(AND(SUMS!$K$44=28,Questions!H41=FALSE),'Detailed Results'!$U$42,\"\"))))))))))))))))))))))))))))))))))))))))))))))))))))))))","v":""},-3]

{"sheet":"SUMS","index":6,"n_rows":72,"n_cols":38,"rows_kept":72,"cut":false,"hidden":true,"merged":[[72,10,72,13],[42,10,42,13],[43,10,43,13],[66,10,66,13],[67,10,67,13],[68,10,68,13],[69,10,69,13],[70,10,70,13],[71,10,71,13],[55,10,55,13],[56,10,56,13],[57,10,57,13],[59,10,59,13],[60,10,60,13],[61,10,61,13],[44,10,44,13],[45,10,45,13],[46,10,46,13],[47,10,47,13],[48,10,48,13],[50,10,50,13],[64,10,64,13],[62,10,62,13],[63,10,63,13],[65,10,65,13],[58,10,58,13],[53,10,53,13],[51,10,51,13],[52,10,52,13],[54,10,54,13],[49,10,49,13]]}
[null,"Flats","Houses","Owner Occupier","Private Renter","Social Renter","Central Heating System","Storage Heaters","Room Heaters","Limited digital literacy","Blind","Partially sighted","Hearing Impairment (inc. Deaf)","Speech impairment","Physical impairment","Developmental condition","Mental health ","Chronic/serious illness ","Dementia(s)/ Cognitive Impairment","Nebuliser, and apnoea monitor ","Heart, lung and ventilator ","Dialysis, feeding pump and automated medicaiton","Oxygen Concentrator / use","Medicine refrigeration","Unable to communicate in English","Stair Lift, hoist, electric bed","Unable to answer door","MDE electric showering/ bathing","Pensionable age","Careline/telecare system","Families with children 5 or under","Poor sense of smell/ taste","Water dependent","Temporary - Post hospital recovery","Temporary - Young adult householder (<18)","Additional presence preferred","Resricted hand movement","Financial Vulnerability"]
["Reduces Costs For Households",{"$f":"SUM(Fill!F5)","v":0.99},{"$f":"SUM(Fill!F6)","v":0.96},{"$f":"SUM(Fill!F7)","v":0.96},{"$f":"SUM(Fill!F8)","v":0.96},{"$f":"SUM(Fill!F9)","v":1.21},{"$f":"SUM(Fill!F10)","v":1.04},{"$f":"SUM(Fill!F11)","v":1.1299999999999999},{"$f":"SUM(Fill!F12)","v":1.04},{"$f":"SUM(Fill!F13)","v":0.96},{"$f":"AVERAGE(Fill!F15:F16,Fill!F18:F19)","v":1.3149999999999999},{"$f":"AVERAGE(Fill!F15:F16,Fill!F18:F19)","v":1.3149999999999999},{"$f":"AVERAGE(Fill!F15:F16,Fill!F19)","v":1.1966666666666665},{"$f":"AVERAGE(Fill!F15)","v":1.03},{"$f":"AVERAGE(Fill!F18:F19)","v":1.3599999999999999},{"$f":"AVERAGE(Fill!F15:F19)","v":1.2979999999999998},{"$f":"AVERAGE(Fill!F15:F19)","v":1.2979999999999998},{"$f":"AVERAGE(Fill!F17)","v":1.23},{"$f":"AVERAGE(Fill!F15:F17,Fill!F19)","v":1.2050000000000001},{"$f":"AVERAGE(Fill!F17)","v":1.23},{"$f":"AVERAGE(Fill!F17)","v":1.23},{"$f":"AVERAGE(Fill!F17)","v":1.23},{"$f":"AVERAGE(Fill!F17)","v":1.23},{"$f":"AVERAGE(Fill!F17)","v":1.23},{"$f":"AVERAGE(Fill!F15:F16)","v":1.27},{"$f":"AVERAGE(Fill!F17:F19)","v":1.3166666666666667},{"$f":"AVERAGE(Fill!F18:F19)","v":1.3599999999999999},{"$f":"AVERAGE(Fill!F17)","v":1.23},{"$f":"AVERAGE(Fill!F17,Fill!F19)","v":1.1400000000000001},{"$f":"AVERAGE(Fill!F15,Fill!F17,Fill!F19)","v":1.1033333333333333},{"$f":"AVERAGE(Fill!F17)","v":1.23},{"$f":"AVERAGE(Fill!F19)","v":1.05},{"$f":"AVERAGE(Fill!F17)","v":1.23},{"$f":"AVERAGE(Fill!F17)","v":1.23},{"$f":"AVERAGE(Fill!F19)","v":1.05},{"$f":"AVERAGE(Fill!F15)","v":1.03},{"$f":"AVERAGE(Fill!F17:F19)","v":1.3166666666666667},{"$f":"AVERAGE(Fill!F14)","v":1.49}]
["Increases Costs For Households",{"$f":"SUM(Fill!G5)","v":-0.99},{"$f":"SUM(Fill!G6)","v":-0.96},{"$f":"SUM(Fill!G7)","v":-0.96},{"$f":"SUM(Fill!G8)","v":-0.96},{"$f":"SUM(Fill!G9)","v":-1.21},{"$f":"SUM(Fill!G10)","v":-1.04},{"$f":"SUM(Fill!G11)","v":-1.1299999999999999},{"$f":"SUM(Fill!G12)","v":-1.04},{"$f":"SUM(Fill!G13)","v":-0.96},{"$f":"AVERAGE(Fill!G15:G16,Fill!G18:G19)","v":-1.3149999999999999},{"$f":"AVERAGE(Fill!G15:G16,Fill!G18:G19)","v":-1.3149999999999999},{"$f":"AVERAGE(Fill!G15:G16,Fill!G19)","v":-1.1966666666666665},{"$f":"AVERAGE(Fill!G15)","v":-1.03},{"$f":"AVERAGE(Fill!G18:G19)","v":-1.3599999999999999},{"$f":"AVERAGE(Fill!G15:G19)","v":-1.2979999999999998},{"$f":"AVERAGE(Fill!G15:G19)","v":-1.2979999999999998},{"$f":"AVERAGE(Fill!G17)","v":-1.23},{"$f":"AVERAGE(Fill!G15:G17,Fill!G19)","v":-1.2050000000000001},{"$f":"AVERAGE(Fill!G17)","v":-1.23},{"$f":"AVERAGE(Fill!G17)","v":-1.23},{"$f":"AVERAGE(Fill!G17)","v":-1.23},{"$f":"AVERAGE(Fill!G17)","v":-1.23},{"$f":"AVERAGE(Fill!G17)","v":-1.23},{"$f":"AVERAGE(Fill!G15:G16)","v":-1.27},{"$f":"AVERAGE(Fill!G17:G19)","v":-1.3166666666666667},{"$f":"AVERAGE(Fill!G18:G19)","v":-1.3599999999999999},{"$f":"AVERAGE(Fill!G17)","v":-1.23},{"$f":"AVERAGE(Fill!G17,Fill!G19)","v":-1.1400000000000001},{"$f":"AVERAGE(Fill!G15,Fill!G17,Fill!G19)","v":-1.1033333333333333},{"$f":"AVERAGE(Fill!G17)","v":-1.23},{"$f":"AVERAGE(Fill!G19)","v":-1.05},{"$f":"AVERAGE(Fill!G17)","v":-1.23},{"$f":"AVERAGE(Fill!G17)","v":-1.23},{"$f":"AVERAGE(Fill!G19)","v":-1.05},{"$f":"AVERAGE(Fill!G15)","v":-1.03},{"$f":"AVERAGE(Fill!G17:G19)","v":-1.3166666666666667},{"$f":"AVERAGE(Fill!G14)","v":-1.49}]
["Improves the Nature, Quality, and Understanding of Information Between Networks and Customers",{"$f":"SUM(Fill!H5)","v":0.63},{"$f":"SUM(Fill!H6)","v":0.63},{"$f":"SUM(Fill!H7)","v":0.75},{"$f":"SUM(Fill!H8)","v":0.67},{"$f":"SUM(Fill!H9)","v":0.75},{"$f":"SUM(Fill!H10)","v":0.67},{"$f":"SUM(Fill!H11)","v":0.75},{"$f":"SUM(Fill!H12)","v":0.67},{"$f":"SUM(Fill!H13)","v":0.71},{"$f":"AVERAGE(Fill!H15:H16,Fill!H18:H19)","v":0.92500000000000004},{"$f":"AVERAGE(Fill!H15:H16,Fill!H18:H19)","v":0.92500000000000004},{"$f":"AVERAGE(Fill!H15:H16,Fill!H19)","v":0.95666666666666667},{"$f":"AVERAGE(Fill!H15)","v":0.63},{"$f":"AVERAGE(Fill!H18:H19)","v":0.72499999999999998},{"$f":"AVERAGE(Fill!H15:H19)","v":0.94199999999999995},{"$f":"AVERAGE(Fill!H15:H19)","v":0.94199999999999995},{"$f":"AVERAGE(Fill!H17)","v":1.01},{"$f":"AVERAGE(Fill!H15:H17,Fill!H19)","v":0.97},{"$f":"AVERAGE(Fill!H17)","v":1.01},{"$f":"AVERAGE(Fill!H17)","v":1.01},{"$f":"AVERAGE(Fill!H17)","v":1.01},{"$f":"AVERAGE(Fill!H17)","v":1.01},{"$f":"AVERAGE(Fill!H17)","v":1.01},{"$f":"AVERAGE(Fill!H15:H16)","v":1.125},{"$f":"AVERAGE(Fill!H17:H19)","v":0.82},{"$f":"AVERAGE(Fill!H18:H19)","v":0.72499999999999998},{"$f":"AVERAGE(Fill!H17)","v":1.01},{"$f":"AVERAGE(Fill!H17,Fill!H19)","v":0.81499999999999995},{"$f":"AVERAGE(Fill!H15,Fill!H17,Fill!H19)","v":0.75333333333333341},{"$f":"AVERAGE(Fill!H17)","v":1.01},{"$f":"AVERAGE(Fill!H19)","v":0.62},{"$f":"AVERAGE(Fill!H17)","v":1.01},{"$f":"AVERAGE(Fill!H17)","v":1.01},{"$f":"AVERAGE(Fill!H19)","v":0.62},{"$f":"AVERAGE(Fill!H15)","v":0.63},{"$f":"AVERAGE(Fill!H17:H19)","v":0.82},{"$f":"AVERAGE(Fill!H14)","v":0.77}]
["Hinders the Nature, Quality, and Understanding of Information Between Networks and Customers",{"$f":"SUM(Fill!I5)","v":-0.63},{"$f":"SUM(Fill!I6)","v":-0.63},{"$f":"SUM(Fill!I7)","v":-0.75},{"$f":"SUM(Fill!I8)","v":-0.67},{"$f":"SUM(Fill!I9)","v":-0.75},{"$f":"SUM(Fill!I10)","v":-0.67},{"$f":"SUM(Fill!I11)","v":-0.75},{"$f":"SUM(Fill!I12)","v":-0.67},{"$f":"SUM(Fill!I13)","v":-0.71},{"$f":"AVERAGE(Fill!I15:I16,Fill!I18:I19)","v":-0.92500000000000004},{"$f":"AVERAGE(Fill!I15:I16,Fill!I18:I19)","v":-0.92500000000000004},{"$f":"AVERAGE(Fill!I15:I16,Fill!I19)","v":-0.95666666666666667},{"$f":"AVERAGE(Fill!I15)","v":-0.63},{"$f":"AVERAGE(Fill!I18:I19)","v":-0.72499999999999998},{"$f":"AVERAGE(Fill!I15:I19)","v":-0.94199999999999995},{"$f":"AVERAGE(Fill!I15:I19)","v":-0.94199999999999995},{"$f":"AVERAGE(Fill!I17)","v":-1.01},{"$f":"AVERAGE(Fill!I15:I17,Fill!I19)","v":-0.97},{"$f":"AVERAGE(Fill!I17)","v":-1.01},{"$f":"AVERAGE(Fill!I17)","v":-1.01},{"$f":"AVERAGE(Fill!I17)","v":-1.01},{"$f":"AVERAGE(Fill!I17)","v":-1.01},{"$f":"AVERAGE(Fill!I17)","v":-1.01},{"$f":"AVERAGE(Fill!I15:I16)","v":-1.125},{"$f":"AVERAGE(Fill!I17:I19)","v":-0.82},{"$f":"AVERAGE(Fill!I18:I19)","v":-0.72499999999999998},{"$f":"AVERAGE(Fill!I17)","v":-1.01},{"$f":"AVERAGE(Fill!I17,Fill!I19)","v":-0.81499999999999995},{"$f":"AVERAGE(Fill!I15,Fill!I17,Fill!I19)","v":-0.75333333333333341},{"$f":"AVERAGE(Fill!I17)","v":-1.01},{"$f":"AVERAGE(Fill!I19)","v":-0.62},{"$f":"AVERAGE(Fill!I17)","v":-1.01},{"$f":"AVERAGE(Fill!I17)","v":-1.01},{"$f":"AVERAGE(Fill!I19)","v":-0.62},{"$f":"AVERAGE(Fill!I15)","v":-0.63},{"$f":"AVERAGE(Fill!I17:I19)","v":-0.82},{"$f":"AVERAGE(Fill!I14)","v":-0.77}]
["Improves the Network’s Ability to Gather Data On, Understand, and Cater To Individual Customer Needs",{"$f":"SUM(Fill!J5)","v":0.76},{"$f":"SUM(Fill!J6)","v":0.76},{"$f":"SUM(Fill!J7)","v":0.8},{"$f":"SUM(Fill!J8)","v":0.72},{"$f":"SUM(Fill!J9)","v":0.88},{"$f":"SUM(Fill!J10)","v":0.76},{"$f":"SUM(Fill!J11)","v":0.72},{"$f":"SUM(Fill!J12)","v":0.76},{"$f":"SUM(Fill!J13)","v":0.76},{"$f":"AVERAGE(Fill!J15:J16,Fill!J18:J19)","v":1.085},{"$f":"AVERAGE(Fill!J15:J16,Fill!J18:J19)","v":1.085},{"$f":"AVERAGE(Fill!J15:J16,Fill!J19)","v":1.1133333333333333},{"$f":"AVERAGE(Fill!J15)","v":0.95},{"$f":"AVERAGE(Fill!J18:J19)","v":0.99},{"$f":"AVERAGE(Fill!J15:J19)","v":1.1379999999999999},{"$f":"AVERAGE(Fill!J15:J19)","v":1.1379999999999999},{"$f":"AVERAGE(Fill!J17)","v":1.35},{"$f":"AVERAGE(Fill!J15:J17,Fill!J19)","v":1.1724999999999999},{"$f":"AVERAGE(Fill!J17)","v":1.35},{"$f":"AVERAGE(Fill!J17)","v":1.35},{"$f":"AVERAGE(Fill!J17)","v":1.35},{"$f":"AVERAGE(Fill!J17)","v":1.35},{"$f":"AVERAGE(Fill!J17)","v":1.35},{"$f":"AVERAGE(Fill!J15:J16)","v":1.18},{"$f":"AVERAGE(Fill!J17:J19)","v":1.1100000000000001},{"$f":"AVERAGE(Fill!J18:J19)","v":0.99},{"$f":"AVERAGE(Fill!J17)","v":1.35},{"$f":"AVERAGE(Fill!J17,Fill!J19)","v":1.165},{"$f":"AVERAGE(Fill!J15,Fill!J17,Fill!J19)","v":1.0933333333333333},{"$f":"AVERAGE(Fill!J17)","v":1.35},{"$f":"AVERAGE(Fill!J19)","v":0.98},{"$f":"AVERAGE(Fill!J17)","v":1.35},{"$f":"AVERAGE(Fill!J17)","v":1.35},{"$f":"AVERAGE(Fill!J19)","v":0.98},{"$f":"AVERAGE(Fill!J15)","v":0.95},{"$f":"AVERAGE(Fill!J17:J19)","v":1.1100000000000001},{"$f":"AVERAGE(Fill!J14)","v":1.3}]
["Hinders the Network’s Ability to Gather Data On, Understand, and Cater To Individual Customer Needs",{"$f":"SUM(Fill!K5)","v":-0.76},{"$f":"SUM(Fill!K6)","v":-0.76},{"$f":"SUM(Fill!K7)","v":-0.8},{"$f":"SUM(Fill!K8)","v":-0.72},{"$f":"SUM(Fill!K9)","v":-0.88},{"$f":"SUM(Fill!K10)","v":-0.76},{"$f":"SUM(Fill!K11)","v":-0.72},{"$f":"SUM(Fill!K12)","v":-0.76},{"$f":"SUM(Fill!K13)","v":-0.76},{"$f":"AVERAGE(Fill!K15:K16,Fill!K18:K19)","v":-1.085},{"$f":"AVERAGE(Fill!K15:K16,Fill!K18:K19)","v":-1.085},{"$f":"AVERAGE(Fill!K15:K16,Fill!K19)","v":-1.1133333333333333},{"$f":"AVERAGE(Fill!K15)","v":-0.95},{"$f":"AVERAGE(Fill!K18:K19)","v":-0.99},{"$f":"AVERAGE(Fill!K15:K19)","v":-1.1379999999999999},{"$f":"AVERAGE(Fill!K15:K19)","v":-1.1379999999999999},{"$f":"AVERAGE(Fill!K17)","v":-1.35},{"$f":"AVERAGE(Fill!K15:K17,Fill!K19)","v":-1.1724999999999999},{"$f":"AVERAGE(Fill!K17)","v":-1.35},{"$f":"AVERAGE(Fill!K17)","v":-1.35},{"$f":"AVERAGE(Fill!K17)","v":-1.35},{"$f":"AVERAGE(Fill!K17)","v":-1.35},{"$f":"AVERAGE(Fill!K17)","v":-1.35},{"$f":"AVERAGE(Fill!K15:K16)","v":-1.18},{"$f":"AVERAGE(Fill!K17:K19)","v":-1.1100000000000001},{"$f":"AVERAGE(Fill!K18:K19)","v":-0.99},{"$f":"AVERAGE(Fill!K17)","v":-1.35},{"$f":"AVERAGE(Fill!K17,Fill!K19)","v":-1.165},{"$f":"AVERAGE(Fill!K15,Fill!K17,Fill!K19)","v":-1.0933333333333333},{"$f":"AVERAGE(Fill!K17)","v":-1.35},{"$f":"AVERAGE(Fill!K19)","v":-0.98},{"$f":"AVERAGE(Fill!K17)","v":-1.35},{"$f":"AVERAGE(Fill!K17)","v":-1.35},{"$f":"AVERAGE(Fill!K19)","v":-0.98},{"$f":"AVERAGE(Fill!K15)","v":-0.95},{"$f":"AVERAGE(Fill!K17:K19)","v":-1.1100000000000001},{"$f":"AVERAGE(Fill!K14)","v":-1.3}]
["Reduces the Need, Time Taken, and Disruptions Caused by Staff Visits to Customer’s Homes",{"$f":"SUM(Fill!L5)","v":0.61},{"$f":"SUM(Fill!L6)","v":0.87},{"$f":"SUM(Fill!L7)","v":0.91},{"$f":"SUM(Fill!L8)","v":0.65},{"$f":"SUM(Fill!L9)","v":0.7},{"$f":"SUM(Fill!L10)","v":0.74},{"$f":"SUM(Fill!L11)","v":0.65},{"$f":"SUM(Fill!L12)","v":0.65},{"$f":"SUM(Fill!L13)","v":0},{"$f":"AVERAGE(Fill!L15:L16,Fill!L18:L19)","v":1.325},{"$f":"AVERAGE(Fill!L15:L16,Fill!L18:L19)","v":1.325},{"$f":"AVERAGE(Fill!L15:L16,Fill!L19)","v":1.21},{"$f":"AVERAGE(Fill!L15)","v":1.1599999999999999},{"$f":"AVERAGE(Fill!L18:L19)","v":1.5150000000000001},{"$f":"AVERAGE(Fill!L15:L19)","v":1.272},{"$f":"AVERAGE(Fill!L15:L19)","v":1.272},{"$f":"AVERAGE(Fill!L17)","v":1.06},{"$f":"AVERAGE(Fill!L15:L17,Fill!L19)","v":1.1725000000000001},{"$f":"AVERAGE(Fill!L17)","v":1.06},{"$f":"AVERAGE(Fill!L17)","v":1.06},{"$f":"AVERAGE(Fill!L17)","v":1.06},{"$f":"AVERAGE(Fill!L17)","v":1.06},{"$f":"AVERAGE(Fill!L17)","v":1.06},{"$f":"AVERAGE(Fill!L15:L16)","v":1.135},{"$f":"AVERAGE(Fill!L17:L19)","v":1.3633333333333333},{"$f":"AVERAGE(Fill!L18:L19)","v":1.5150000000000001},{"$f":"AVERAGE(Fill!L17)","v":1.06},{"$f":"AVERAGE(Fill!L17,Fill!L19)","v":1.21},{"$f":"AVERAGE(Fill!L15,Fill!L17,Fill!L19)","v":1.1933333333333334},{"$f":"AVERAGE(Fill!L17)","v":1.06},{"$f":"AVERAGE(Fill!L19)","v":1.36},{"$f":"AVERAGE(Fill!L17)","v":1.06},{"$f":"AVERAGE(Fill!L17)","v":1.06},{"$f":"AVERAGE(Fill!L19)","v":1.36},{"$f":"AVERAGE(Fill!L15)","v":1.1599999999999999},{"$f":"AVERAGE(Fill!L17:L19)","v":1.3633333333333333},{"$f":"AVERAGE(Fill!L14)","v":0.95}]
["Increases the Need, Time Taken, and Disruptions Caused by Staff Visits to Customer’s Homes",{"$f":"SUM(Fill!M5)","v":-0.61},{"$f":"SUM(Fill!M6)","v":-0.87},{"$f":"SUM(Fill!M7)","v":-0.91},{"$f":"SUM(Fill!M8)","v":-0.65},{"$f":"SUM(Fill!M9)","v":-0.7},{"$f":"SUM(Fill!M10)","v":-0.74},{"$f":"SUM(Fill!M11)","v":-0.65},{"$f":"SUM(Fill!M12)","v":-0.65},{"$f":"SUM(Fill!M13)","v":0},{"$f":"AVERAGE(Fill!M15:M16,Fill!M18:M19)","v":-1.325},{"$f":"AVERAGE(Fill!M15:M16,Fill!M18:M19)","v":-1.325},{"$f":"AVERAGE(Fill!M15:M16,Fill!M19)","v":-1.21},{"$f":"AVERAGE(Fill!M15)","v":-1.1599999999999999},{"$f":"AVERAGE(Fill!M18:M19)","v":-1.5150000000000001},{"$f":"AVERAGE(Fill!M15:M19)","v":-1.272},{"$f":"AVERAGE(Fill!M15:M19)","v":-1.272},{"$f":"AVERAGE(Fill!M17)","v":-1.06},{"$f":"AVERAGE(Fill!M15:M17,Fill!M19)","v":-1.1725000000000001},{"$f":"AVERAGE(Fill!M17)","v":-1.06},{"$f":"AVERAGE(Fill!M17)","v":-1.06},{"$f":"AVERAGE(Fill!M17)","v":-1.06},{"$f":"AVERAGE(Fill!M17)","v":-1.06},{"$f":"AVERAGE(Fill!M17)","v":-1.06},{"$f":"AVERAGE(Fill!M15:M16)","v":-1.135},{"$f":"AVERAGE(Fill!M17:M19)","v":-1.3633333333333333},{"$f":"AVERAGE(Fill!M18:M19)","v":-1.5150000000000001},{"$f":"AVERAGE(Fill!M17)","v":-1.06},{"$f":"AVERAGE(Fill!M17,Fill!M19)","v":-1.21},{"$f":"AVERAGE(Fill!M15,Fill!M17,Fill!M19)","v":-1.1933333333333334},{"$f":"AVERAGE(Fill!M17)","v":-1.06},{"$f":"AVERAGE(Fill!M19)","v":-1.36},{"$f":"AVERAGE(Fill!M17)","v":-1.06},{"$f":"AVERAGE(Fill!M17)","v":-1.06},{"$f":"AVERAGE(Fill!M19)","v":-1.36},{"$f":"AVERAGE(Fill!M15)","v":-1.1599999999999999},{"$f":"AVERAGE(Fill!M17:M19)","v":-1.3633333333333333},{"$f":"AVERAGE(Fill!M14)","v":-0.95}]
["Improves Customer's Health, Safety, and Accessibility Within or Immediately Around the Home",{"$f":"SUM(Fill!N5)","v":0.88},{"$f":"SUM(Fill!N6)","v":0.88},{"$f":"SUM(Fill!N7)","v":0},{"$f":"SUM(Fill!N8)","v":0},{"$f":"SUM(Fill!N9)","v":0},{"$f":"SUM(Fill!N10)","v":0},{"$f":"SUM(Fill!N11)","v":0},{"$f":"SUM(Fill!N12)","v":0},{"$f":"SUM(Fill!N13)","v":1.1200000000000001},{"$f":"AVERAGE(Fill!N15:N16,Fill!N18:N19)","v":1.7250000000000001},{"$f":"AVERAGE(Fill!N15:N16,Fill!N18:N19)","v":1.7250000000000001},{"$f":"AVERAGE(Fill!N15:N16,Fill!N19)","v":1.6333333333333335},{"$f":"AVERAGE(Fill!N15)","v":1.34},{"$f":"AVERAGE(Fill!N18:N19)","v":2},{"$f":"AVERAGE(Fill!N15:N19)","v":1.64},{"$f":"AVERAGE(Fill!N15:N19)","v":1.64},{"$f":"AVERAGE(Fill!N17)","v":1.3},{"$f":"AVERAGE(Fill!N15:N17,Fill!N19)","v":1.55},{"$f":"AVERAGE(Fill!N17)","v":1.3},{"$f":"AVERAGE(Fill!N17)","v":1.3},{"$f":"AVERAGE(Fill!N17)","v":1.3},{"$f":"AVERAGE(Fill!N17)","v":1.3},{"$f":"AVERAGE(Fill!N17)","v":1.3},{"$f":"AVERAGE(Fill!N15:N16)","v":1.4500000000000002},{"$f":"AVERAGE(Fill!N17:N19)","v":1.7666666666666666},{"$f":"AVERAGE(Fill!N18:N19)","v":2},{"$f":"AVERAGE(Fill!N17)","v":1.3},{"$f":"AVERAGE(Fill!N17,Fill!N19)","v":1.65},{"$f":"AVERAGE(Fill!N15,Fill!N17,Fill!N19)","v":1.5466666666666669},{"$f":"AVERAGE(Fill!N17)","v":1.3},{"$f":"AVERAGE(Fill!N19)","v":2},{"$f":"AVERAGE(Fill!N17)","v":1.3},{"$f":"AVERAGE(Fill!N17)","v":1.3},{"$f":"AVERAGE(Fill!N19)","v":2},{"$f":"AVERAGE(Fill!N15)","v":1.34},{"$f":"AVERAGE(Fill!N17:N19)","v":1.7666666666666666},{"$f":"AVERAGE(Fill!N14)","v":1.17}]
["Hinders Customer's Health, Safety, and Accessibility Within or Immediately Around the Home",{"$f":"SUM(Fill!O5)","v":-0.88},{"$f":"SUM(Fill!O6)","v":-0.88},{"$f":"SUM(Fill!O7)","v":0},{"$f":"SUM(Fill!O8)","v":0},{"$f":"SUM(Fill!O9)","v":0},{"$f":"SUM(Fill!O10)","v":0},{"$f":"SUM(Fill!O11)","v":0},{"$f":"SUM(Fill!O12)","v":0},{"$f":"SUM(Fill!O13)","v":-1.1200000000000001},{"$f":"AVERAGE(Fill!O15:O16,Fill!O18:O19)","v":-1.7250000000000001},{"$f":"AVERAGE(Fill!O15:O16,Fill!O18:O19)","v":-1.7250000000000001},{"$f":"AVERAGE(Fill!O15:O16,Fill!O19)","v":-1.6333333333333335},{"$f":"AVERAGE(Fill!O15)","v":-1.34},{"$f":"AVERAGE(Fill!O18:O19)","v":-2},{"$f":"AVERAGE(Fill!O15:O19)","v":-1.64},{"$f":"AVERAGE(Fill!O15:O19)","v":-1.64},{"$f":"AVERAGE(Fill!O17)","v":-1.3},{"$f":"AVERAGE(Fill!O15:O17,Fill!O19)","v":-1.55},{"$f":"AVERAGE(Fill!O17)","v":-1.3},{"$f":"AVERAGE(Fill!O17)","v":-1.3},{"$f":"AVERAGE(Fill!O17)","v":-1.3},{"$f":"AVERAGE(Fill!O17)","v":-1.3},{"$f":"AVERAGE(Fill!O17)","v":-1.3},{"$f":"AVERAGE(Fill!O15:O16)","v":-1.4500000000000002},{"$f":"AVERAGE(Fill!O17:O19)","v":-1.7666666666666666},{"$f":"AVERAGE(Fill!O18:O19)","v":-2},{"$f":"AVERAGE(Fill!O17)","v":-1.3},{"$f":"AVERAGE(Fill!O17,Fill!O19)","v":-1.65},{"$f":"AVERAGE(Fill!O15,Fill!O17,Fill!O19)","v":-1.5466666666666669},{"$f":"AVERAGE(Fill!O17)","v":-1.3},{"$f":"AVERAGE(Fill!O19)","v":-2},{"$f":"AVERAGE(Fill!O17)","v":-1.3},{"$f":"AVERAGE(Fill!O17)","v":-1.3},{"$f":"AVERAGE(Fill!O19)","v":-2},{"$f":"AVERAGE(Fill!O15)","v":-1.34},{"$f":"AVERAGE(Fill!O17:O19)","v":-1.7666666666666666},{"$f":"AVERAGE(Fill!O14)","v":-1.17}]
["Improves Customer’s Ability to Heat, Cook, Wash and Use Medical Equipment During Supply Interruptions",{"$f":"SUM(Fill!P5)","v":1},{"$f":"SUM(Fill!P6)","v":1},{"$f":"SUM(Fill!P7)","v":0},{"$f":"SUM(Fill!P8)","v":0},{"$f":"SUM(Fill!P9)","v":0},{"$f":"SUM(Fill!P10)","v":1.0900000000000001},{"$f":"SUM(Fill!P11)","v":1.08},{"$f":"SUM(Fill!P12)","v":1.17},{"$f":"SUM(Fill!P13)","v":1.04},{"$f":"AVERAGE(Fill!P15:P16,Fill!P18:P19)","v":1.74},{"$f":"AVERAGE(Fill!P15:P16,Fill!P18:P19)","v":1.74},{"$f":"AVERAGE(Fill!P15:P16,Fill!P19)","v":1.6533333333333333},{"$f":"AVERAGE(Fill!P15)","v":1.44},{"$f":"AVERAGE(Fill!P18:P19)","v":1.875},{"$f":"AVERAGE(Fill!P15:P19)","v":1.7759999999999998},{"$f":"AVERAGE(Fill!P15:P19)","v":1.7759999999999998},{"$f":"AVERAGE(Fill!P17)","v":1.92},{"$f":"AVERAGE(Fill!P15:P17,Fill!P19)","v":1.72},{"$f":"AVERAGE(Fill!P17)","v":1.92},{"$f":"AVERAGE(Fill!P17)","v":1.92},{"$f":"AVERAGE(Fill!P17)","v":1.92},{"$f":"AVERAGE(Fill!P17)","v":1.92},{"$f":"AVERAGE(Fill!P17)","v":1.92},{"$f":"AVERAGE(Fill!P15:P16)","v":1.605},{"$f":"AVERAGE(Fill!P17:P19)","v":1.89},{"$f":"AVERAGE(Fill!P18:P19)","v":1.875},{"$f":"AVERAGE(Fill!P17)","v":1.92},{"$f":"AVERAGE(Fill!P17,Fill!P19)","v":1.835},{"$f":"AVERAGE(Fill!P15,Fill!P17,Fill!P19)","v":1.7033333333333331},{"$f":"AVERAGE(Fill!P17)","v":1.92},{"$f":"AVERAGE(Fill!P19)","v":1.75},{"$f":"AVERAGE(Fill!P17)","v":1.92},{"$f":"AVERAGE(Fill!P17)","v":1.92},{"$f":"AVERAGE(Fill!P19)","v":1.75},{"$f":"AVERAGE(Fill!P15)","v":1.44},{"$f":"AVERAGE(Fill!P17:P19)","v":1.89},{"$f":"AVERAGE(Fill!P14)","v":1.41}]
["Hinders Customer’s Ability to Heat, Cook, Wash and Use Medical Equipment During Supply Interruptions",{"$f":"SUM(Fill!Q5)","v":-1},{"$f":"SUM(Fill!Q6)","v":-1},{"$f":"SUM(Fill!Q7)","v":0},{"$f":"SUM(Fill!Q8)","v":0},{"$f":"SUM(Fill!Q9)","v":0},{"$f":"SUM(Fill!Q10)","v":-1.0900000000000001},{"$f":"SUM(Fill!Q11)","v":-1.08},{"$f":"SUM(Fill!Q12)","v":-1.17},{"$f":"SUM(Fill!Q13)","v":-1.04},{"$f":"AVERAGE(Fill!Q15:Q16,Fill!Q18:Q19)","v":-1.74},{"$f":"AVERAGE(Fill!Q15:Q16,Fill!Q18:Q19)","v":-1.74},{"$f":"AVERAGE(Fill!Q15:Q16,Fill!Q19)","v":-1.6533333333333333},{"$f":"AVERAGE(Fill!Q15)","v":-1.44},{"$f":"AVERAGE(Fill!Q18:Q19)","v":-1.875},{"$f":"AVERAGE(Fill!Q15:Q19)","v":-1.7759999999999998},{"$f":"AVERAGE(Fill!Q15:Q19)","v":-1.7759999999999998},{"$f":"AVERAGE(Fill!Q17)","v":-1.92},{"$f":"AVERAGE(Fill!Q15:Q17,Fill!Q19)","v":-1.72},{"$f":"AVERAGE(Fill!Q17)","v":-1.92},{"$f":"AVERAGE(Fill!Q17)","v":-1.92},{"$f":"AVERAGE(Fill!Q17)","v":-1.92},{"$f":"AVERAGE(Fill!Q17)","v":-1.92},{"$f":"AVERAGE(Fill!Q17)","v":-1.92},{"$f":"AVERAGE(Fill!Q15:Q16)","v":-1.605},{"$f":"AVERAGE(Fill!Q17:Q19)","v":-1.89},{"$f":"AVERAGE(Fill!Q18:Q19)","v":-1.875},{"$f":"AVERAGE(Fill!Q17)","v":-1.92},{"$f":"AVERAGE(Fill!Q17,Fill!Q19)","v":-1.835},{"$f":"AVERAGE(Fill!Q15,Fill!Q17,Fill!Q19)","v":-1.7033333333333331},{"$f":"AVERAGE(Fill!Q17)","v":-1.92},{"$f":"AVERAGE(Fill!Q19)","v":-1.75},{"$f":"AVERAGE(Fill!Q17)","v":-1.92},{"$f":"AVERAGE(Fill!Q17)","v":-1.92},{"$f":"AVERAGE(Fill!Q19)","v":-1.75},{"$f":"AVERAGE(Fill!Q15)","v":-1.44},{"$f":"AVERAGE(Fill!Q17:Q19)","v":-1.89},{"$f":"AVERAGE(Fill!Q14)","v":-1.41}]
["Reduces the Occurrence and Duration of Supply Interruptions",{"$f":"SUM(Fill!R5)","v":1},{"$f":"SUM(Fill!R6)","v":0.92},{"$f":"SUM(Fill!R7)","v":0},{"$f":"SUM(Fill!R8)","v":0},{"$f":"SUM(Fill!R9)","v":0},{"$f":"SUM(Fill!R10)","v":1.17},{"$f":"SUM(Fill!R11)","v":1.04},{"$f":"SUM(Fill!R12)","v":1.08},{"$f":"SUM(Fill!R13)","v":1.04},{"$f":"AVERAGE(Fill!R15:R16,Fill!R18:R19)","v":1.7350000000000001},{"$f":"AVERAGE(Fill!R15:R16,Fill!R18:R19)","v":1.7350000000000001},{"$f":"AVERAGE(Fill!R15:R16,Fill!R19)","v":1.7033333333333334},{"$f":"AVERAGE(Fill!R15)","v":1.51},{"$f":"AVERAGE(Fill!R18:R19)","v":1.7450000000000001},{"$f":"AVERAGE(Fill!R15:R19)","v":1.752},{"$f":"AVERAGE(Fill!R15:R19)","v":1.752},{"$f":"AVERAGE(Fill!R17)","v":1.82},{"$f":"AVERAGE(Fill!R15:R17,Fill!R19)","v":1.7325000000000002},{"$f":"AVERAGE(Fill!R17)","v":1.82},{"$f":"AVERAGE(Fill!R17)","v":1.82},{"$f":"AVERAGE(Fill!R17)","v":1.82},{"$f":"AVERAGE(Fill!R17)","v":1.82},{"$f":"AVERAGE(Fill!R17)","v":1.82},{"$f":"AVERAGE(Fill!R15:R16)","v":1.7250000000000001},{"$f":"AVERAGE(Fill!R17:R19)","v":1.7700000000000002},{"$f":"AVERAGE(Fill!R18:R19)","v":1.7450000000000001},{"$f":"AVERAGE(Fill!R17)","v":1.82},{"$f":"AVERAGE(Fill!R17,Fill!R19)","v":1.74},{"$f":"AVERAGE(Fill!R15,Fill!R17,Fill!R19)","v":1.6633333333333333},{"$f":"AVERAGE(Fill!R17)","v":1.82},{"$f":"AVERAGE(Fill!R19)","v":1.66},{"$f":"AVERAGE(Fill!R17)","v":1.82},{"$f":"AVERAGE(Fill!R17)","v":1.82},{"$f":"AVERAGE(Fill!R19)","v":1.66},{"$f":"AVERAGE(Fill!R15)","v":1.51},{"$f":"AVERAGE(Fill!R17:R19)","v":1.7700000000000002},{"$f":"AVERAGE(Fill!R14)","v":1.24}]
["Increases the Occurrence and Duration of Supply Interruptions",{"$f":"SUM(Fill!S5)","v":-1},{"$f":"SUM(Fill!S6)","v":-0.92},{"$f":"SUM(Fill!S7)","v":0},{"$f":"SUM(Fill!S8)","v":0},{"$f":"SUM(Fill!S9)","v":0},{"$f":"SUM(Fill!S10)","v":-1.17},{"$f":"SUM(Fill!S11)","v":-1.04},{"$f":"SUM(Fill!S12)","v":-1.08},{"$f":"SUM(Fill!S13)","v":-1.04},{"$f":"AVERAGE(Fill!S15:S16,Fill!S18:S19)","v":-1.7350000000000001},{"$f":"AVERAGE(Fill!S15:S16,Fill!S18:S19)","v":-1.7350000000000001},{"$f":"AVERAGE(Fill!S15:S16,Fill!S19)","v":-1.7033333333333334},{"$f":"AVERAGE(Fill!S15)","v":-1.51},{"$f":"AVERAGE(Fill!S18:S19)","v":-1.7450000000000001},{"$f":"AVERAGE(Fill!S15:S19)","v":-1.752},{"$f":"AVERAGE(Fill!S15:S19)","v":-1.752},{"$f":"AVERAGE(Fill!S17)","v":-1.82},{"$f":"AVERAGE(Fill!S15:S17,Fill!S19)","v":-1.7325000000000002},{"$f":"AVERAGE(Fill!S17)","v":-1.82},{"$f":"AVERAGE(Fill!S17)","v":-1.82},{"$f":"AVERAGE(Fill!S17)","v":-1.82},{"$f":"AVERAGE(Fill!S17)","v":-1.82},{"$f":"AVERAGE(Fill!S17)","v":-1.82},{"$f":"AVERAGE(Fill!S15:S16)","v":-1.7250000000000001},{"$f":"AVERAGE(Fill!S17:S19)","v":-1.7700000000000002},{"$f":"AVERAGE(Fill!S18:S19)","v":-1.7450000000000001},{"$f":"AVERAGE(Fill!S17)","v":-1.82},{"$f":"AVERAGE(Fill!S17,Fill!S19)","v":-1.74},{"$f":"AVERAGE(Fill!S15,Fill!S17,Fill!S19)","v":-1.6633333333333333},{"$f":"AVERAGE(Fill!S17)","v":-1.82},{"$f":"AVERAGE(Fill!S19)","v":-1.66},{"$f":"AVERAGE(Fill!S17)","v":-1.82},{"$f":"AVERAGE(Fill!S17)","v":-1.82},{"$f":"AVERAGE(Fill!S19)","v":-1.66},{"$f":"AVERAGE(Fill!S15)","v":-1.51},{"$f":"AVERAGE(Fill!S17:S19)","v":-1.7700000000000002},{"$f":"AVERAGE(Fill!S14)","v":-1.24}]
["Reduces the Need For, Time Taken, and Space Required To Excavate on Public and Private Roads in Residential Areas",{"$f":"SUM(Fill!T5)","v":0},{"$f":"SUM(Fill!T6)","v":0},{"$f":"SUM(Fill!T7)","v":0},{"$f":"SUM(Fill!T8)","v":0},{"$f":"SUM(Fill!T9)","v":0},{"$f":"SUM(Fill!T10)","v":0},{"$f":"SUM(Fill!T11)","v":0},{"$f":"SUM(Fill!T12)","v":0},{"$f":"SUM(Fill!T13)","v":0},{"$f":"AVERAGE(Fill!T15:T16,Fill!T18:T19)","v":1.2825},{"$f":"AVERAGE(Fill!T15:T16,Fill!T18:T19)","v":1.2825},{"$f":"AVERAGE(Fill!T15:T16,Fill!T19)","v":1.21},{"$f":"AVERAGE(Fill!T15)","v":0.89},{"$f":"AVERAGE(Fill!T18:T19)","v":1.5699999999999998},{"$f":"AVERAGE(Fill!T15:T19)","v":1.222},{"$f":"AVERAGE(Fill!T15:T19)","v":1.222},{"$f":"AVERAGE(Fill!T17)","v":0.98},{"$f":"AVERAGE(Fill!T15:T17,Fill!T19)","v":1.1525000000000001},{"$f":"AVERAGE(Fill!T17)","v":0.98},{"$f":"AVERAGE(Fill!T17)","v":0.98},{"$f":"AVERAGE(Fill!T17)","v":0.98},{"$f":"AVERAGE(Fill!T17)","v":0.98},{"$f":"AVERAGE(Fill!T17)","v":0.98},{"$f":"AVERAGE(Fill!T15:T16)","v":0.99500000000000011},{"$f":"AVERAGE(Fill!T17:T19)","v":1.3733333333333333},{"$f":"AVERAGE(Fill!T18:T19)","v":1.5699999999999998},{"$f":"AVERAGE(Fill!T17)","v":0.98},{"$f":"AVERAGE(Fill!T17,Fill!T19)","v":1.31},{"$f":"AVERAGE(Fill!T15,Fill!T17,Fill!T19)","v":1.17},{"$f":"AVERAGE(Fill!T17)","v":0.98},{"$f":"AVERAGE(Fill!T19)","v":1.64},{"$f":"AVERAGE(Fill!T17)","v":0.98},{"$f":"AVERAGE(Fill!T17)","v":0.98},{"$f":"AVERAGE(Fill!T19)","v":1.64},{"$f":"AVERAGE(Fill!T15)","v":0.89},{"$f":"AVERAGE(Fill!T17:T19)","v":1.3733333333333333},{"$f":"AVERAGE(Fill!T14)","v":0.92}]
["Increases the Need For, Time Taken, and Space Required To Excavate on Public and Private Roads in Residential Areas",{"$f":"SUM(Fill!U5)","v":0},{"$f":"SUM(Fill!U6)","v":0},{"$f":"SUM(Fill!U7)","v":0},{"$f":"SUM(Fill!U8)","v":0},{"$f":"SUM(Fill!U9)","v":0},{"$f":"SUM(Fill!U10)","v":0},{"$f":"SUM(Fill!U11)","v":0},{"$f":"SUM(Fill!U12)","v":0},{"$f":"SUM(Fill!U13)","v":0},{"$f":"AVERAGE(Fill!U15:U16,Fill!U18:U19)","v":-1.2825},{"$f":"AVERAGE(Fill!U15:U16,Fill!U18:U19)","v":-1.2825},{"$f":"AVERAGE(Fill!U15:U16,Fill!U19)","v":-1.21},{"$f":"AVERAGE(Fill!U15)","v":-0.89},{"$f":"AVERAGE(Fill!U18:U19)","v":-1.5699999999999998},{"$f":"AVERAGE(Fill!U15:U19)","v":-1.222},{"$f":"AVERAGE(Fill!U15:U19)","v":-1.222},{"$f":"AVERAGE(Fill!U17)","v":-0.98},{"$f":"AVERAGE(Fill!U15:U17,Fill!U19)","v":-1.1525000000000001},{"$f":"AVERAGE(Fill!U17)","v":-0.98},{"$f":"AVERAGE(Fill!U17)","v":-0.98},{"$f":"AVERAGE(Fill!U17)","v":-0.98},{"$f":"AVERAGE(Fill!U17)","v":-0.98},{"$f":"AVERAGE(Fill!U17)","v":-0.98},{"$f":"AVERAGE(Fill!U15:U16)","v":-0.99500000000000011},{"$f":"AVERAGE(Fill!U17:U19)","v":-1.3733333333333333},{"$f":"AVERAGE(Fill!U18:U19)","v":-1.5699999999999998},{"$f":"AVERAGE(Fill!U17)","v":-0.98},{"$f":"AVERAGE(Fill!U17,Fill!U19)","v":-1.31},{"$f":"AVERAGE(Fill!U15,Fill!U17,Fill!U19)","v":-1.17},{"$f":"AVERAGE(Fill!U17)","v":-0.98},{"$f":"AVERAGE(Fill!U19)","v":-1.64},{"$f":"AVERAGE(Fill!U17)","v":-0.98},{"$f":"AVERAGE(Fill!U17)","v":-0.98},{"$f":"AVERAGE(Fill!U19)","v":-1.64},{"$f":"AVERAGE(Fill!U15)","v":-0.89},{"$f":"AVERAGE(Fill!U17:U19)","v":-1.3733333333333333},{"$f":"AVERAGE(Fill!U14)","v":-0.92}]
["Overall Impact Score",{"$f":"SUBTOTAL(109, B2:B17)","v":0},{"$f":"SUBTOTAL(109, C2:C17)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Overall Only Positive Score",{"$f":"SUBTOTAL(109, B2, B4, B6, B8, B10, B12, B14, B16)","v":5.8699999999999992},{"$f":"SUBTOTAL(109, C2, C4, C6, C8, C10, C12, C14, C16)","v":6.02},3.42,2.9999999999999996,3.54,5.47,5.37,5.3699999999999992,{"$f":"SUBTOTAL(109, J2, J4, J6, J8, J10, J12, J14, J16)","v":5.63},{"$f":"SUBTOTAL(109, K2, K4, K6, K8, K10, K12, K14, K16)","v":11.1325},{"$f":"SUBTOTAL(109, L2, L4, L6, L8, L10, L12, L14, L16)","v":11.1325},{"$f":"SUBTOTAL(109, M2, M4, M6, M8, M10, M12, M14, M16)","v":10.676666666666666},{"$f":"SUBTOTAL(109, N2, N4, N6, N8, N10,N12, N14, N16)","v":8.9500000000000011},{"$f":"SUBTOTAL(109, O2, O4, O6, O8, O10, O12, O14, O16)","v":11.780000000000001},{"$f":"SUBTOTAL(109, P2, P4, P6, P8, P10, P12, P14, P16)","v":11.04},{"$f":"SUBTOTAL(109, Q2, Q4, Q6, Q8, Q10, Q12, Q14, Q16)","v":11.04},10.67,10.674999999999999,10.67,10.67,10.67,10.67,10.67,10.484999999999999,11.41,{"$f":"SUBTOTAL(109, AA2, AA4, AA6, AA8, AA10, AA12, AA14, AA16)","v":11.780000000000001},10.67,10.865,10.226666666666667,10.67,11.06,10.67,10.67,11.06,8.9500000000000011,11.41,9.25]
["Overall Only Negative Score",{"$f":"SUBTOTAL(109, B3, B5, B7, B9, B11, B13, B15)","v":-5.8699999999999992},{"$f":"SUBTOTAL(109, C3, C5, C7, C9, C11, C13, C15)","v":-6.02},{"$f":"SUBTOTAL(109, D3, D5, D7, D9)","v":-3.42},{"$f":"SUBTOTAL(109, E3, E5,  E7, E9)","v":-2.9999999999999996},{"$f":"SUBTOTAL(109, F3, F5, F7, F9)","v":-3.54},{"$f":"SUBTOTAL(109, G3, G5, G7, G9, G13, G15)","v":-5.47},{"$f":"SUBTOTAL(109, H3, H5, H7, H9, H13, H15)","v":-5.37},{"$f":"SUBTOTAL(109, I3, I5, I7, I9, I13, I15)","v":-5.3699999999999992},{"$f":"SUBTOTAL(109, J3, J5, J7, J11, J13, J15)","v":-5.63},{"$f":"SUBTOTAL(109, K3, K5, K7, K9, K11, K13, K15, K17)","v":-11.1325},{"$f":"SUBTOTAL(109, L3, L5, L7, L9, L11, L13, L15, L17)","v":-11.1325},{"$f":"SUBTOTAL(109, M3, M5, M7, M9, M11, M13, M15, M17)","v":-10.676666666666666},{"$f":"SUBTOTAL(109, N3, N5, N7, N9,N11,N13, N15, N17)","v":-8.9500000000000011},{"$f":"SUBTOTAL(109, O3, O5, O7, O9, O11, O13, O15, O17)","v":-11.780000000000001},{"$f":"SUBTOTAL(109, P3, P5, P7, P9, P11, P13, P15, P17)","v":-11.04},-11.04,-10.67,-10.674999999999999,-10.67,-10.67,-10.67,-10.67,-10.67,-10.484999999999999,-11.41,{"$f":"SUBTOTAL(109, AA3, AA5, AA7, AA9, AA11, AA13, AA15, AA17)","v":-11.780000000000001},-10.67,-10.865,-10.226666666666667,-10.67,-11.06,-10.67,-10.67,-11.06,-8.9500000000000011,-11.41,-9.25]
["Average Impact Score",{"$f":"SUBTOTAL(101, B2:B17)","v":0},{"$f":"SUBTOTAL(101, C2:C17)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Average Only Positive Score",{"$f":"SUBTOTAL(101, B2, B4, B6, B8, B10, B12, B14, B16)","v":0.7337499999999999},{"$f":"SUBTOTAL(101, C2, C4, C6, C8, C10, C12, C14, C16)","v":0.75249999999999995},0.42749999999999999,0.37499999999999994,0.4425,0.68374999999999997,0.67125000000000001,0.6712499999999999,0.70374999999999999,1.3915625,1.3915625,1.3345833333333332,1.1187500000000001,1.4725000000000001,1.38,1.38,1.33375,1.3343749999999999,1.33375,1.33375,1.33375,1.33375,1.33375,1.3106249999999999,1.42625,1.4725000000000001,1.33375,1.358125,1.2783333333333333,1.33375,1.3825000000000001,1.33375,1.33375,1.3825000000000001,1.1187500000000001,1.42625,1.15625]
["Average Only Negative Score ",{"$f":"SUBTOTAL(101, B3, B5, B7, B9, B11, B13, B15)","v":-0.83857142857142841},{"$f":"SUBTOTAL(101, C3, C5, C7, C9, C11, C13, C15)","v":-0.86},-0.48857142857142855,-0.42857142857142849,-0.50571428571428567,-0.78142857142857136,-0.76714285714285713,-0.76714285714285702,-0.80428571428571427,-1.407142857142857,-1.407142857142857,-1.3523809523809525,-1.1514285714285715,-1.4585714285714286,-1.4025714285714286,-1.4025714285714286,-1.3842857142857141,-1.3603571428571428,-1.3842857142857141,-1.3842857142857141,-1.3842857142857141,-1.3842857142857141,-1.3842857142857141,-1.3557142857142856,-1.4338095238095239,-1.4585714285714286,-1.3842857142857141,-1.365,-1.2938095238095237,-1.3842857142857141,-1.3457142857142856,-1.3842857142857141,-1.3842857142857141,-1.3457142857142856,-1.1514285714285715,-1.4338095238095239,-1.19]
[]
[null,null,null,null,null,null,null,null,null,null,"Max","Max","Max","Max","Max","Max","Max","Max","Max","Max","Max","Max","Max","Max","Max","Max","Max","Max","Max","Max","Max","Max","Max","Max","Max","Max","Max","Max"]
[null,null,null,null,null,null,null,null,null,null,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2]
[null,null,null,null,null,null,null,null,null,null,"Min","Min","Min","Min","Min","Min","Min","Min","Min","Min","Min","Min","Min","Min","Min","Min","Min","Min","Min","Min","Min","Min","Min","Min","Min","Min","Min","Min"]
[null,null,null,null,null,null,null,null,null,null,-2,-2,-2,-2,-2,-2,-2,-2,-2,-2,-2,-2,-2,-2,-2,-2,-2,-2,-2,-2,-2,-2,-2,-2,-2,-2,-2,-2]
[null,null,null,null,null,null,null,null,null,null,"Score","Score","Score","Score","Score","Score","Score","Score","Score","Score","Score","Score","Score","Score","Score","Score","Score","Score","Score","Score","Score","Score","Score","Score","Score","Score","Score","Score"]
[null,null,null,null,null,null,null,null,null,null,{"$f":"K21","v":0},{"$f":"L21","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,"Equation","Equation","Equation","Equation","Equation","Equation","Equation","Equation","Equation","Equation","Equation","Equation","Equation","Equation","Equation","Equation","Equation","Equation","Equation","Equation","Equation","Equation","Equation","Equation","Equation","Equation","Equation","Equation"]
[null,null,null,null,null,null,null,null,null,null,{"$f":"(K30-K28)/(K26-K28)*10","v":5},{"$f":"(L30-L28)/(L26-L28)*10","v":5},5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5]
[null,null,null,null,null,null,null,null,null,null,"W Value","W Value","W Value","W Value","W Value","W Value","W Value","W Value","W Value","W Value","W Value","W Value","W Value","W Value","W Value","W Value","W Value","W Value","W Value","W Value","W Value","W Value","W Value","W Value","W Value","W Value","W Value","W Value"]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF(K32>=8.75,\"HIGH POSITIVE\",IF(K32>=6.25,\"LOW POSITIVE\",IF(K32>=3.75,\"NEUTRAL IMPACT\", IF(K32>=1.25,\"LOW NEGATIVE\",IF(K32>=0,\"HIGH NEGATIVE\",\"0\")))))","v":"NEUTRAL IMPACT"},{"$f":"IF(L32>=8.75,\"HIGH POSITIVE\",IF(L32>=6.25,\"LOW POSITIVE\",IF(L32>=3.75,\"NEUTRAL IMPACT\", IF(L32>=1.25,\"LOW NEGATIVE\",IF(L32>=0,\"HIGH NEGATIVE\",\"0\")))))","v":"NEUTRAL IMPACT"},"NEUTRAL IMPACT","NEUTRAL IMPACT","NEUTRAL IMPACT","NEUTRAL IMPACT","NEUTRAL IMPACT","NEUTRAL IMPACT","NEUTRAL IMPACT","NEUTRAL IMPACT","NEUTRAL IMPACT","NEUTRAL IMPACT","NEUTRAL IMPACT","NEUTRAL IMPACT","NEUTRAL IMPACT","NEUTRAL IMPACT","NEUTRAL IMPACT","NEUTRAL IMPACT","NEUTRAL IMPACT","NEUTRAL IMPACT","NEUTRAL IMPACT","NEUTRAL IMPACT","NEUTRAL IMPACT","NEUTRAL IMPACT","NEUTRAL IMPACT","NEUTRAL IMPACT","NEUTRAL IMPACT","NEUTRAL IMPACT"]
[null,"Score",{"$f":"SUM('Detailed Results'!V6:V42)","v":0}]
[null,"Max ",340.79532407407402,null,null,null,null,null,null,null,"SHORT/LONG VALUES DROP DOWN "]
[null,"Min ",-340.79532407407402,null,null,null,null,null,null,null,"Q3","Q4","Q5","Q6","Q7","Q8","Q9","Q10"]
[null,"P Score",{"$f":"SUM('Detailed Results'!W6:W42)","v":343.31333333333333},null,null,null,null,null,null,null,3,3,3,3,3,3,3,3]
[null,"N Score",{"$f":"SUM('Detailed Results'!X6:X42)","v":-343.31333333333333},null,null,null,null,null,null,null,"Short term","Short term","Short term","Short term","Short term","Short term","Short term","Short term"]
[null,"PN min",0,null,null,null,null,null,null,null,"Long term","Long term","Long term","Long term","Long term","Long term","Long term","Long term"]
[]
[null,null,null,null,null,null,null,null,null,null,"VULNERABILITY DROP DOWN"]
[null,null,null,null,null,null,null,null,null,null,"Value "]
[null,null,null,null,null,null,null,null,null,null,29]
[null,null,null,null,null,null,null,null,null,null,"Blind"]
[null,null,null,null,null,null,null,null,null,null,"Partially sighted"]
[null,null,null,null,null,null,null,null,null,null,"Hearing impairment (inc. deaf)"]
[null,null,null,null,null,null,null,null,null,null,"Speech impairment"]
[null,null,null,null,null,null,null,null,null,null,"Physical impairment"]
[null,null,null,null,null,null,null,null,null,null,"Developmental condition"]
[null,null,null,null,null,null,null,null,null,null,"Mental health "]
[null,null,null,null,null,null,null,null,null,null,"Chronic/serious illness "]
[null,null,null,null,null,null,null,null,null,null,"Dementia(s)/ cognitive impairment"]
[null,null,null,null,null,null,null,null,null,null,"Nebuliser, and apnoea monitor "]
[null,null,null,null,null,null,null,null,null,null,"Heart, lung and ventilator "]
[null,null,null,null,null,null,null,null,null,null,"Dialysis, feeding pump and automated medicaiton"]
[null,null,null,null,null,null,null,null,null,null,"Oxygen concentrator / use"]
[null,null,null,null,null,null,null,null,null,null,"Medicine refrigeration"]
[null,null,null,null,null,null,null,null,null,null,"Unable to communicate in English"]
[null,null,null,null,null,null,null,null,null,null,"Stair lift, hoist, electric bed"]
[null,null,null,null,null,null,null,null,null,null,"Unable to answer door"]
[null,null,null,null,null,null,null,null,null,null,"MDE electric showering/ bathing"]
[null,null,null,null,null,null,null,null,null,null,"Pensionable age"]
[null,null,null,null,null,null,null,null,null,null,"Careline/telecare system"]
[null,null,null,null,null,null,null,null,null,null,"Families with children 5 or under"]
[null,null,null,null,null,null,null,null,null,null,"Poor sense of smell/ taste"]
[null,null,null,null,null,null,null,null,null,null,"Water dependent"]
[null,null,null,null,null,null,null,null,null,null,"Temporary - post hospital recovery"]
[null,null,null,null,null,null,null,null,null,null,"Temporary - young adult householder (<18)"]
[null,null,null,null,null,null,null,null,null,null,"Additional presence preferred"]
[null,null,null,null,null,null,null,null,null,null,"Resricted hand movement"]
[null,null,null,null,null,null,null,null,null,null,"Financial vulnerability"]

{"sheet":"Fill","index":7,"n_rows":51,"n_cols":21,"rows_kept":51,"cut":false,"hidden":true,"merged":[[17,3,17,4],[18,3,18,4],[3,3,3,4],[4,2,12,2],[4,3,5,3],[6,3,8,3],[9,3,11,3],[13,2,18,2],[13,3,13,4],[14,3,14,4],[15,3,15,4],[16,3,16,4],[22,3,22,4],[21,3,21,4],[23,3,23,4],[24,3,24,4],[25,3,25,4],[26,3,26,4],[27,3,27,4],[28,3,28,4],[29,3,29,4],[30,3,30,4],[31,3,31,4],[32,3,32,4],[33,3,33,4],[34,3,34,4],[35,3,35,4],[36,3,36,4],[37,3,37,4],[38,3,38,4],[39,3,39,4],[40,3,40,4],[46,3,46,4],[47,3,47,4],[48,3,48,4],[49,3,49,4],[41,3,41,4],[42,3,42,4],[43,3,43,4],[44,3,44,4],[45,3,45,4]]}
[]
[]
[]
[null,null,null,"Types of Impact",null,"Impacts Costs (Any Cost Including Network Costs, Bills, Maintenance of Appliances, Etc..) For Households","Impacts Costs (Any Cost Including Network Costs, Bills, Maintenance of Appliances, Etc..) For Households","Impacts the Nature, Quality, and Understanding of Information Between Networks and Customers","Impacts the Nature, Quality, and Understanding of Information Between Networks and Customers","Impacts the Network’s Ability to Gather Data On, Understand, and Cater To Individual Customer Needs","Impacts the Network’s Ability to Gather Data On, Understand, and Cater To Individual Customer Needs","Impacts the Need, Time Taken, and Disruptions (e.g., Drilling, Scaffolding) Caused by Staff Visits to Customer’s Homes","Impacts the Need, Time Taken, and Disruptions (e.g., Drilling, Scaffolding) Caused by Staff Visits to Customer’s Homes","Impacts Health, Safety, and Accessibility Within or Immediately Around the Home","Impacts Health, Safety, and Accessibility Within or Immediately Around the Home","Impacts Customer’s Ability to Heat, Cook, Wash and Use Medical Equipment During Supply Interruptions","Impacts Customer’s Ability to Heat, Cook, Wash and Use Medical Equipment During Supply Interruptions","Impacts the Occurrence and Duration of Supply Interruptions","Impacts the Occurrence and Duration of Supply Interruptions","Impacts the Need For, Time Taken, and Space Required (e.g., Roadblocks and Obstacles on Public Roads and Walkways) To Excavate on Public and Private Roads in Residential Areas","Impacts the Need For, Time Taken, and Space Required (e.g., Roadblocks and Obstacles on Public Roads and Walkways) To Excavate on Public and Private Roads in Residential Areas"]
[null,null,"Situational Circumstances","Dwelling","Flats",0.99,{"$f":"F5*-1","v":-0.99},0.63,{"$f":"H5*-1","v":-0.63},0.76,{"$f":"J5*-1","v":-0.76},0.61,{"$f":"L5*-1","v":-0.61},0.88,{"$f":"N5*-1","v":-0.88},1,{"$f":"P5*-1","v":-1},1,{"$f":"R5*-1","v":-1},"N/A","N/A"]
[null,null,null,null,"Houses",0.96,{"$f":"F6*-1","v":-0.96},0.63,{"$f":"H6*-1","v":-0.63},0.76,{"$f":"J6*-1","v":-0.76},0.87,{"$f":"L6*-1","v":-0.87},0.88,{"$f":"N6*-1","v":-0.88},1,{"$f":"P6*-1","v":-1},0.92,{"$f":"R6*-1","v":-0.92},"N/A","N/A"]
[null,null,null,"Tenure","Owner Occupier",0.96,-0.96,0.75,-0.75,0.8,-0.8,0.91,-0.91,"N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A"]
[null,null,null,null,"Private Renter",0.96,-0.96,0.67,-0.67,0.72,-0.72,0.65,-0.65,"N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A"]
[null,null,null,null,"Social Renter",1.21,-1.21,0.75,-0.75,0.88,-0.88,0.7,-0.7,"N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A"]
[null,null,null,"Heating System","Central Heating System",1.04,-1.04,0.67,-0.67,0.76,-0.76,0.74,-0.74,"N/A","N/A",1.0900000000000001,{"$f":"P10*-1","v":-1.0900000000000001},1.17,{"$f":"R10*-1","v":-1.17},"N/A","N/A"]
[null,null,null,null,"Storage Heaters",1.1299999999999999,-1.1299999999999999,0.75,-0.75,0.72,-0.72,0.65,-0.65,"N/A","N/A",1.08,{"$f":"P11*-1","v":-1.08},1.04,{"$f":"R11*-1","v":-1.04},"N/A","N/A"]
[null,null,null,null,"Room Heaters",1.04,-1.04,0.67,-0.67,0.76,-0.76,0.65,-0.65,"N/A","N/A",1.17,-1.17,1.08,-1.08,"N/A","N/A"]
[null,null,null,"Readiness for Digital Technology","Limited digital literacy",0.96,-0.96,0.71,-0.71,0.76,-0.76,"N/A","N/A",1.1200000000000001,{"$f":"N13*-1","v":-1.1200000000000001},1.04,-1.04,1.04,-1.04,"N/A","N/A"]
[null,null,"PSR-Related Circumstances","Customers in Need of Financial Support",null,1.49,-1.49,0.77,-0.77,1.3,-1.3,0.95,{"$f":"L14*-1","v":-0.95},1.17,{"$f":"N14*-1","v":-1.17},1.41,-1.41,1.24,-1.24,0.92,{"$f":"T14*-1","v":-0.92}]
[null,null,null,"Customers Who Face Difficulties In Engaging With Staff In-Person or on the Phone",null,1.03,-1.03,0.63,-0.63,0.95,-0.95,1.1599999999999999,-1.1599999999999999,1.34,-1.34,1.44,-1.44,1.51,-1.51,0.89,-0.89]
[null,null,null,"Customers Who Find It Difficult to Access Information in Non-tailored Formats",null,1.51,-1.51,1.62,-1.62,1.41,-1.41,1.1100000000000001,-1.1100000000000001,1.56,-1.56,1.77,-1.77,1.94,-1.94,1.1000000000000001,-1.1000000000000001]
[null,null,null,"Customers Whose Wellbeing Is at Risk When Energy and Water Supply in Interrupted\t",null,1.23,-1.23,1.01,-1.01,1.35,-1.35,1.06,-1.06,1.3,-1.3,1.92,-1.92,1.82,-1.82,0.98,-0.98]
[null,null,null,"Customers Who Face Difficulties in Moving or Interacting With Equipment",null,1.67,-1.67,0.83,{"$f":"H18*-1","v":-0.83},1,-1,1.67,-1.67,2,-2,2,-2,1.83,-1.83,1.5,-1.5]
[null,null,null,"Customers Who Face Obstacles in Noticing Danger and Taking Steps to Avoid It",null,1.05,-1.05,0.62,-0.62,0.98,-0.98,1.36,-1.36,2,-2,1.75,-1.75,1.66,-1.66,1.64,-1.64]
[]
[]
[null,null,null,null,null,"Customers in need of financial support","Customers who face difficulties in engaging with staff in person or on the phone","Customers who find it difficult to access information in non-tailored formats","Customers whose wellbeing is at risk when energy and water supply in interrupted","Customers who face difficulties in moving or interacting with equipment","Customers who face obstacles in noticing danger and taking steps to avoid it"]
[null,null,null,"Blind",null,null,"x","x",null,"x","x"]
[null,null,null,"Partially sighted",null,null,"x","x",null,"x","x"]
[null,null,null,"Hearing Impairment (inc. Deaf)",null,null,"x","x",null,null,"x"]
[null,null,null,"Speech impairment",null,null,"x"]
[null,null,null,"Physical impairment",null,null,null,null,null,"x","x"]
[null,null,null,"Developmental condition",null,null,"x","x","x","x","x"]
[null,null,null,"Mental health ",null,null,"x","x","x","x","x"]
[null,null,null,"Chronic/serious illness ",null,null,null,null,"x"]
[null,null,null,"Dementia(s)/ Cognitive Impairment",null,null,"x","x","x",null,"x"]
[null,null,null,"Nebuliser, and apnoea monitor ",null,null,null,null,"x"]
[null,null,null,"Heart, lung and ventilator ",null,null,null,null,"x"]
[null,null,null,"Dialysis, feeding pump and automated medicaiton",null,null,null,null,"x"]
[null,null,null,"Oxygen Concentrator / use",null,null,null,null,"x"]
[null,null,null,"Medicine refrigeration",null,null,null,null,"x"]
[null,null,null,"Unable to communicate in English",null,null,"x","x"]
[null,null,null,"Stair Lift, hoist, electric bed",null,null,null,null,"x","x","x"]
[null,null,null,"Unable to answer door",null,null,null,null,null,"x","x"]
[null,null,null,"MDE electric showering/ bathing",null,null,null,null,"x"]
[null,null,null,"Pensionable age",null,null,null,null,"x",null,"x"]
[null,null,null,"Careline/telecare system",null,null,"x",null,"x",null,"x"]
[null,null,null,"Families with children 5 or under",null,null,null,null,"x"]
[null,null,null,"Poor sense of smell/ taste",null,null,null,null,null,null,"x"]
[null,null,null,"Water dependent",null,null,null,null,"x"]
[null,null,null,"Temporary - Post hospital recovery",null,null,null,null,"x"]
[null,null,null,"Temporary - Young adult householder (<18)",null,null,null,null,null,null,"x"]
[null,null,null,"Additional presence preferred",null,null,"x"]
[null,null,null,"Resricted hand movement",null,null,null,null,"x","x","x"]
[null,null,null,"Financial Vulnerability",null,"x"]
[null,null,null,null,null,"F14","F15","F16","F17","F18","F19"]