{"text_format":"1","workbook":"xlsx","n_sheets":10,"sheets":["Introduction","Instructions","1 - Cost Estimations","2 - Flood Scenario","3 - People per Household","4 - Inputs","5 - Outputs","6 - Summary","7 - Calculations","8 - Sources"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"comments":2,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Introduction","index":0,"n_rows":34,"n_cols":3,"rows_kept":34,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Modelling the Direct Impacts of Flooding in London"]
[]
[null,"Overview"]
[]
[null,"- The purpose of this spreadsheet is to estimate the direct impacts of flooding in a hypothetical flood scenario in London."]
[]
[null,null,"- It is designed to be easy to use, with inputs obtained from readily available sources."]
[]
[null,"- This spreadsheet is designed to give a rough estimate of direct impacts of flooding."]
[]
[null,null,"- The number of affected people and properties can be obtained by a simple data extraction through any GIS software."]
[]
[null,null,"- Cost estimates are largely based on data from the 2007 UK Flood."]
[]
[null,null,"- Since the cost estimates are based on aggregate data an exact estimate is impossible and the estimate will be rough but simple to obtain."]
[]
[null,"- In order to use this spreadsheet you will need the following information:"]
[]
[null,null,"- The names of the different regions being analyzed (either wards or boroughs)."]
[]
[null,null,"- A screenshot of the GIS map of the flood scenario for visual reference (if desired)."]
[]
[null,null,"- The number of households in the flood zone."]
[]
[null,null,"- The number of businesses in the flood zone."]
[]
[null,null,"- The number of schools in the flood zone."]
[]
[null,null,"- The total number of students in all schools in the flood zone."]
[]
[null,null,"- The number of GPs in the flood zone."]
[]
[null,"- Read the instructions tab thoroughly before proceeding and use it a reference as to how to properly use this spreadsheet"]

{"sheet":"Instructions","index":1,"n_rows":30,"n_cols":4,"rows_kept":30,"cut":false,"hidden":false,"merged":[[1,1,1,3],[2,1,2,3],[3,1,3,3],[4,1,4,3],[7,1,7,3],[8,1,8,3],[9,1,9,3],[14,1,14,2],[12,1,12,3],[5,1,5,3],[6,1,6,3]]}
[]
[null,"General Notes"]
[]
[null,"- Yellow cells are input cells.  Other cells contain formulas and references and cannot be edited."]
[]
[null,"- Green cells indicate a value used in calculations that is specific to the borough being analyzed."]
[]
[null,"- Inputs that are not taken from GIS maps (used to calculate values in green cells) are taken from the source referenced below them.  The links to these sources can be found in the Sources tab."]
[]
[null,"- The table below describes the steps necessary to complete the spreadsheet.  Follow the steps in order to obtain all of the input variables."]
[]
[]
[null,"How To Complete This Spreadsheet"]
[]
[null,"Steps",null,"Instructions/Explanations"]
[null,1,"Write the name of each area being analyzed into the yellow cells in the section titled \"List of Affected Areas\"","Sheet 1 - List of Affected Areas: If the analysis is being done on the entire borough, enter the name of the borough in the first cell in the column.  If the analysis is being broken down to the ward level, enter the name of each ward in seperate cells in alphabetical order.  This list will carry on to the other sheets to show which areas are being analyzed."]
[null,2,"Fill in the yellow input cells in the section titled \"Cost of a School Day.\"  This data is specific to the borough containing the areas being analyzed","Sheet 1 - Cost of a School Day: Click the link for the source labelled Department for Education.  Find the borough being analyzed. Choose results for the entire borough by clicking the word \"district.\"  Click \"School Funding and Resources.\"  Locate the value \"Funding per Pupil Age 3-19\" for the current year and enter it into the yellow cell.  This value will be used to estimate the cost of school closings in the affected area."]
[null,3,"Fill in the yelow input cells in the section titled \"People Requiring Evacuation Assistance.\"  This data is specific to the borough containing the areas being analyzed","Sheet 1 - People Requiring Evacuation Assistance: Click the link for the source labelled Office For National Statistics.  Enter the name of the borough being analyzed.  Select \"Health and Care.\"  Select \"Disability Living Allowance Claimants.\"  Enter the number of people in each age group below the age of 70 into the corresponding yellow boxes in this section.  Close the link, and reopen it from the Sources tab.  Enter the name of the borough being analyzed.  Select \"Census Area Statistics.\"  Select \"Age.\"  Enter the number of people in each indicated age group into the corresponding yellow cells.  Find the number listed for \"All People\" and enter it in the yellow cell labelled \"Total Population\" in this section.  This will calculate the total number of people requiring evacuation assistance, and represent it as a precentage of the total population."]
[null,4,"Fill in the yellow input cells in the section titled \"20 Year Projections.\"  This data is specific to each indivual area being analyzed.","Sheet 1 - Future Projections: This part of the sheet can be for any year in the future up to 20 years.  Decide what year the projection will be done for.  Click the source labelled Greater London Authority.  Open the Excel File.  Select the tab that corresponds to the borough being analyzed.  First find the population for the current year.  If the analysis is being done per ward, enter these values as the current population of each ward.  If the analysis is being done per borough, add all the values and enter the sum as the value for the borough.  Scroll down scroll down the sheet until you find the year to calculate costs for and repeat this same process. This will calculate the percent increase in population for each area being analyzed.  This percent is assumed to be the same as the percent change in households and will be used as such.  "]
[null,5,"Insert a screenshot of the GIS map","Sheet 2 - Paste a screenshot of the GIS map for reference, if desired.  This can be used as a visual reference but is not required to complete the spreadsheet."]
[null,6,"Fill in the yellow cells in the section titled \"Average Number of People Living in Households\"","Sheet 3 - Average Number of People Living in Households: Click the source labelled Office for National Statistics.  Enter the name of the first area being analyzed, whether it is the entire borough or the first ward in the list.  Select \"Census Area Statistics\" then select \"Number of People in Households.\"  Enter the values shown into the corresponding yellow cells for that area.  Repeat this process for each area in the list.  These values will be used to estimate the number of people affected by the flood."]
[null,7,"Fill in the cell under \"Number of Households Affected\" corresponding to each affected area","Sheet 4 - Number of Households Affected: This number is calculated by using GIS software.  Load an Ordinance Survey Address Point layer and a flood map layer into GIS and run a query for the intersection of the two layers.  Export the data as an excel file and open the file.  If the analysis is being broken down to the ward level, sort the data by the column titled \"Ward\"  and repeat the following steps for each ward.  If not, do the following steps for the entire set of data.  Sort this data by the column titled \"Organization Name.\"  Count the number of properties without an organization name.  This is the number of households in the affected area.  Enter this number in the corresponding yellow cell in the spreadsheet."]
[null,8,"Fill in the cell under \"Number of Businesses Affected\" corresponding to each affected area","Sheet 4 - Number of Businesses Affected: This number is calculated by using GIS software.  Load an Ordinance Survey Address Point layer and a flood map layer into GIS and run a query for the intersection of the two layers.  Export the data as an excel file and open the file.  If the analysis is being broken down to the ward level, sort the data by the column titled \"Ward\"  and repeat the following steps for each ward.  If not, do the following steps for the entire set of data.  Sort this data by the column titled \"Organization Name.\"  Count the number of properties with an organization name.  This is the number of businesses in the affected area.  Enter this number in the corresponding yellow cell in the spreadsheet."]
[null,9,"Fill in the cell under \"Number of Schools Affected\" corresponding to each affected area","Sheet 4 - Number of Schools Affected: This number is calculated by using GIS software.  Load a layer with the location of the schools within the borough and a flood map layer into GIS and run a query for the intersection of the two layers.  Export the data as an excel file and open the file.  Determine the number of schools in the flood zone.  Enter this number in the corresponding yellow cell in the spreadsheet."]
[null,10,"Fill in the cell under \"Number of Pupils in Affected Schools\" corresponding to each affected area","Sheet 4 - Number of Pupils in Affected Schools: Once the affected schools have been extracted from GIS, open the excel file to obtain the name of each school affected.  If the analysis is being broken down to the ward level, repeat the following steps for each ward.  If not, do the following steps for the entire borough.  Using information provided by the education department of the borough being analyzed, determine the number of pupils in each school that is affected.  Sum each of these numbers to determine the total number of pupils in affected schools."]
[null,11,"Fill in the cell under \"Number of GPs Affected\" corresponding to each affected area","Sheet 4 - Number of GPs Affected: This number is calculated by using GIS software.  Load a layer with the location of the GPs within the borough and a flood map layer into GIS and run a query for the intersection of the two layers.  Export the data as an excel file and open the file.  Determine the number of GPs that are in the flood zone.  Enter this number in the corresponding yellow cell in the spreadsheet."]
[null,12,"Go to the Outputs sheet to view all of the values calculated","Sheet 5 - This sheet contains all of the values that are calculated by the spreadsheet.  These values are used to calculate the key statistics in the summary sheet"]
[null,13,"Go to the Summary sheet to view a compilation of all of the key variables, a total monetary cost, and a projected 20 year cost.","Sheet 6 - This sheet contains a compilation of all of the key statistics that the spreadsheet calculates, and a total value for each one."]
[null,14,"View the Calculations sheet for an explanation of all of the calculations done by the spreadsheet.","Sheet 7 - This sheet is only necessary to read if clarification is desired"]
[null,15,"View the Sources sheet for a full list of the sources used to obtain data.","Sheet 8 - This sheet provides all of the sources that were used to obtain all of the estimation factors."]

{"sheet":"1 - Cost Estimations","index":2,"n_rows":36,"n_cols":19,"rows_kept":36,"cut":false,"hidden":false,"merged":[[32,2,36,2],[29,1,31,1],[32,1,36,1],[25,1,28,1],[31,9,31,13],[3,2,11,2],[3,1,11,1],[12,1,15,1],[29,2,31,2],[20,2,24,2],[25,2,28,2],[12,2,19,2],[1,15,1,18],[29,15,29,18],[1,9,1,13],[9,9,9,13],[6,9,6,13],[11,9,11,10],[11,12,11,13],[16,1,19,1]]}
[]
[null,"Source","Category","Cost Estimation Factors","Value","Unit",null,"List of Affected Areas",null,"Cost of School Day",null,null,null,null,null,"Future Projections"]
[]
[null,"EA 2007 Flood Report","Utility",null,null,null,null,null,null,"Input Funding per Pupil (age 3-19) for the affected area:",null,null,null,null,null,"Affected Areas","Current Total Population","Projected Future Total Population","Percent Change in Population"]
[null,null,null,"Electricity deprivation cost",10,"£/household/kWh"]
[null,null,null,"Average Household Electricity Consumption",0.37669999999999998,"kWh/hour",null,null,null,"Cost of School Day ",null,null,null,{"$f":"N4/190","v":0},null,{"$f":"H4","v":0},0,0,{"$f":"IF(OR(P6=0,Q6=0,R6=0),0,((R6-Q6)/Q6))","v":0}]
[null,null,null,"Average electricity deprivation time",14.6,"hours",null,null,null,"Department for Education",null,null,null,null,null,0,0,0,{"$f":"IF(OR(P7=0,Q7=0,R7=0),0,((R7-Q7)/Q7))","v":0}]
[null,null,null,"Water failure cost",10,"£/household/day",null,null,null,null,null,null,null,null,null,0,0,0,0]
[null,null,null,"Average water failure time",2,"days",null,null,null,null,null,null,null,null,null,0,0,0,0]
[null,null,null,"Sewage failure cost",5,"£/Household/day",null,null,null,"People Requiring Evacuation Assistance",null,null,null,null,null,0,0,0,0]
[null,null,null,"Average sewage failure time",2,"days",null,null,null,null,null,null,null,null,null,0,0,0,0]
[null,null,null,null,null,null,null,null,null,"Disabled Population Under 70",null,null,"Population 70 and above",null,null,0,0,0,0]
[null,"EA 2007 Flood Report","Property Damage",null,null,null,null,null,null,-16,0,null,"Aged 70 years",0,null,0,0,0,0]
[null,null,null,"Average Household Insurance Claim",27150,"£/Household",null,null,null,"16-24",0,null,"Aged 71 years",0,null,0,0,0,0]
[null,null,null,"Number of Uninsured Houses",0.24,"percentage",null,null,null,"35-49",0,null,"Aged 72 years",0,null,0,0,0,0]
[null,null,null,null,null,null,null,null,null,"50-59",0,null,"Aged 73 years",0,null,0,0,0,0]
[null,"EA 2007 Flood Report",null,null,null,null,null,null,null,"60-69",0,null,"Aged 74 years",0,null,0,0,0,0]
[null,null,null,"Average Business Insurance Claim",72826,"£/Business",null,null,null,null,null,null,"Aged 75 to 79 years",0,null,0,0,0,0]
[null,null,null,"Number of Uninsured Businesses",0.05,"percentage",null,null,null,"Total",{"$f":"SUM(K13:K17)","v":0},null,"Aged 80 to 84 years",0,null,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,"Aged 85 to 89 years",0,null,0,0,0,0]
[null,null,"Health/People",null,null,null,null,null,null,null,null,null,"Aged 90 to 94 years",0,null,0,0,0,0]
[null,"Pitt Review",null,"People Reporting Health Concerns",0.41499999999999998,"percentage",null,null,null,null,null,null,"Aged 95 to 99 years",0,null,0,0,0,0]
[null,"Pitt Review",null,"People Requiring GP Visit",0.39,"percentage of above value",null,null,null,null,null,null,"Aged 100 years and over",0,null,0,0,0,0]
[null,"Office for National Statistics",null,"People Requiring Evacuation Assistance",{"$f":"N31","v":{"$error":"#DIV/0!"}},"percentage",null,null,null,null,null,null,null,null,null,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,"Total",{"$f":"SUM(N13:N23)","v":0},null,0,0,0,0]
[null,"Department for Education","Schools ",null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0]
[null,null,null,"Cost of school day",{"$f":"N6","v":0},"£/pupil day",null,null,null,null,null,null,"Total Disabled and/or Elderly",{"$f":"K19+N25","v":0},null,0,0,0,0]
[null,null,null,"Average days out of school",2.35,"days",null,null,null,null,null,null,null,null,null,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,"Total Population (2001)",0,null,0,0,0,0]
[null,"Disaster Reduction and Human Renovation Institution","Waste",null,null,null,null,null,null,null,null,null,null,null,null,"Greater London Authority"]
[null,null,null,"Total Waste Produced",4.17,"Tonnes/Building",null,null,null,null,null,null,"People Requiring Evacuation Assistance",{"$f":"N27/N29","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,null,null,null,"Office for National Statistics"]
[null,"EA 2007 Flood Report","Temporary Accomodations"]
[null,null,null,"Buildings needing temporary accomodations",0.3,"percentage"]
[null,null,null,"Ave cost of temp accom (domestic)",6695,"£/Household"]
[null,null,null,"Ave cost of temp accom (business)",5461,"£/Business"]

{"sheet":"2 - Flood Scenario","index":3,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"3 - People per Household","index":4,"n_rows":30,"n_cols":13,"rows_kept":30,"cut":false,"hidden":false,"merged":[[2,2,2,12],[29,2,29,12]]}
[]
[]
[null,null,"Average Number of People Living in Households"]
[]
[null,null,null,"Total",1,2,3,4,5,6,7,8,"Average"]
[null,null,{"$f":"'1 - Cost Estimations'!H4","v":0},{"$f":"IF(C6=0,0,SUM(E6:L6))","v":0},0,0,0,0,0,0,0,0,{"$f":"IF(D6=0,0,((F6*$F$5)+(G6*$G$5)+(H6*$H$5)+(I6*$I$5)+(J6*$J$5)+(K6*$K$5)+(L6*$L$5)+(E6*$E$5))/D6)","v":0}]
[null,null,{"$f":"'1 - Cost Estimations'!H5","v":0},{"$f":"IF(C7=0,0,SUM(E7:L7))","v":0},0,0,0,0,0,0,0,0,{"$f":"IF(D7=0,0,((F7*$F$5)+(G7*$G$5)+(H7*$H$5)+(I7*$I$5)+(J7*$J$5)+(K7*$K$5)+(L7*$L$5)+(E7*$E$5))/D7)","v":0}]
[null,null,{"$f":"'1 - Cost Estimations'!H6","v":0},0,0,0,0,0,0,0,0,0,0]
[null,null,{"$f":"'1 - Cost Estimations'!H7","v":0},0,0,0,0,0,0,0,0,0,0]
[null,null,{"$f":"'1 - Cost Estimations'!H8","v":0},0,0,0,0,0,0,0,0,0,0]
[null,null,{"$f":"'1 - Cost Estimations'!H9","v":0},0,0,0,0,0,0,0,0,0,0]
[null,null,{"$f":"'1 - Cost Estimations'!H10","v":0},0,0,0,0,0,0,0,0,0,0]
[null,null,{"$f":"'1 - Cost Estimations'!H11","v":0},0,0,0,0,0,0,0,0,0,0]
[null,null,{"$f":"'1 - Cost Estimations'!H12","v":0},0,0,0,0,0,0,0,0,0,0]
[null,null,{"$f":"'1 - Cost Estimations'!H13","v":0},0,0,0,0,0,0,0,0,0,0]
[null,null,{"$f":"'1 - Cost Estimations'!H14","v":0},0,0,0,0,0,0,0,0,0,0]
[null,null,{"$f":"'1 - Cost Estimations'!H15","v":0},0,0,0,0,0,0,0,0,0,0]
[null,null,{"$f":"'1 - Cost Estimations'!H16","v":0},0,0,0,0,0,0,0,0,0,0]
[null,null,{"$f":"'1 - Cost Estimations'!H17","v":0},0,0,0,0,0,0,0,0,0,0]
[null,null,{"$f":"'1 - Cost Estimations'!H18","v":0},0,0,0,0,0,0,0,0,0,0]
[null,null,{"$f":"'1 - Cost Estimations'!H19","v":0},0,0,0,0,0,0,0,0,0,0]
[null,null,{"$f":"'1 - Cost Estimations'!H20","v":0},0,0,0,0,0,0,0,0,0,0]
[null,null,{"$f":"'1 - Cost Estimations'!H21","v":0},0,0,0,0,0,0,0,0,0,0]
[null,null,{"$f":"'1 - Cost Estimations'!H22","v":0},0,0,0,0,0,0,0,0,0,0]
[null,null,{"$f":"'1 - Cost Estimations'!H23","v":0},0,0,0,0,0,0,0,0,0,0]
[null,null,{"$f":"'1 - Cost Estimations'!H24","v":0},0,0,0,0,0,0,0,0,0,0]
[null,null,{"$f":"'1 - Cost Estimations'!H25","v":0},0,0,0,0,0,0,0,0,0,0]
[null,null,{"$f":"'1 - Cost Estimations'!H26","v":0},0,0,0,0,0,0,0,0,0,0]
[null,null,{"$f":"'1 - Cost Estimations'!H27","v":0},0,0,0,0,0,0,0,0,0,0]
[null,null,"Office for National Statistics"]

{"sheet":"4 - Inputs","index":5,"n_rows":28,"n_cols":7,"rows_kept":28,"cut":false,"hidden":false,"merged":[[1,2,1,6]]}
[]
[null,null,"Inputs Taken from GIS Maps"]
[]
[null,null,"Number of Households in Flood Zone","Number of Businesses in Flood Zone","Number of Schools in Flood Zone","Number of School Pupils in Schools in Flood Zone","Number of GPs in Flood Zone"]
[null,{"$f":"'3 - People per Household'!C6","v":0},0,0,0,0,0]
[null,{"$f":"'3 - People per Household'!C7","v":0},0,0,0,0,0]
[null,{"$f":"'3 - People per Household'!C8","v":0},0,0,0,0,0]
[null,{"$f":"'3 - People per Household'!C9","v":0},0,0,0,0,0]
[null,{"$f":"'3 - People per Household'!C10","v":0},0,0,0,0,0]
[null,{"$f":"'3 - People per Household'!C11","v":0},0,0,0,0,0]
[null,{"$f":"'3 - People per Household'!C12","v":0},0,0,0,0,0]
[null,{"$f":"'3 - People per Household'!C13","v":0},0,0,0,0,0]
[null,{"$f":"'3 - People per Household'!C14","v":0},0,0,0,0,0]
[null,{"$f":"'3 - People per Household'!C15","v":0},0,0,0,0,0]
[null,{"$f":"'3 - People per Household'!C16","v":0},0,0,0,0,0]
[null,{"$f":"'3 - People per Household'!C17","v":0},0,0,0,0,0]
[null,{"$f":"'3 - People per Household'!C18","v":0},0,0,0,0,0]
[null,{"$f":"'3 - People per Household'!C19","v":0},0,0,0,0,0]
[null,{"$f":"'3 - People per Household'!C20","v":0},0,0,0,0,0]
[null,{"$f":"'3 - People per Household'!C21","v":0},0,0,0,0,0]
[null,{"$f":"'3 - People per Household'!C22","v":0},0,0,0,0,0]
[null,{"$f":"'3 - People per Household'!C23","v":0},0,0,0,0,0]
[null,{"$f":"'3 - People per Household'!C24","v":0},0,0,0,0,0]
[null,{"$f":"'3 - People per Household'!C25","v":0},0,0,0,0,0]
[null,{"$f":"'3 - People per Household'!C26","v":0},0,0,0,0,0]
[null,{"$f":"'3 - People per Household'!C27","v":0},0,0,0,0,0]
[null,{"$f":"'3 - People per Household'!C28","v":0},0,0,0,0,0]
[null,{"$f":"'3 - People per Household'!C29","v":0},0,0,0,0,0]

{"sheet":"5 - Outputs","index":6,"n_rows":29,"n_cols":30,"rows_kept":29,"cut":false,"hidden":false,"merged":[[0,5,0,7],[0,1,0,3],[0,25,0,27],[0,21,0,23],[0,9,0,13],[0,15,0,19]]}
[null,"People",null,null,null,"Health",null,null,null,"Domestic",null,null,null,null,null,"Businesses",null,null,null,null,null,"Schools",null,null,null,"Utilities",null,null,null,"Waste"]
[]
["Affected Areas","Number of People Affected","Number of People Temporarily Relocated","Number of People Requiring Evacuation Assistance",null,"Number of People Reporting Health Concerns","Number of People Requiring a GP Visit","Number of GPs Affected",null,"Number of Households Affected","Total Cost of Damages to Households","Total Uninsured Damage","Number of Households Requiring Temporary Accomodation","Total Cost of Temporary Accomodation for Households",null,"Number of Businesses Affected","Total Cost of Damages to Businesses","Total Uninsured Damage","Number of Businesses Requiring Temporary Accomodation","Total Cost of Temporary Accomodation for Businesses",null,"Number of Schools Affected","Total Number of Pupil Days Lost","Total \"Cost of School Day\" Impacts",null,"Total Cost of Electricity Deprivation","Total Cost of Water Failure","Total Cost of Sewage Failure",null,"Tonnes of Waste Produced"]
[{"$f":"'4 - Inputs'!B5","v":0},{"$f":"IF(A4=0,0,'3 - People per Household'!M6*J4)","v":0},{"$f":"IF(A4=0,0,'5 - Outputs'!M4*'3 - People per Household'!M6)","v":0},{"$f":"IF(A4=0,0,B4*'1 - Cost Estimations'!$E$24)","v":0},null,{"$f":"IF(A4=0,0,B4*0.415)","v":0},{"$f":"IF(A4=0,0,F4*0.39)","v":0},{"$f":"IF(A4=0,0,'4 - Inputs'!G5)","v":0},null,{"$f":"IF(A4=0,0,'4 - Inputs'!C5)","v":0},{"$f":"IF(A4=0,0,J4*'1 - Cost Estimations'!$E$14)","v":0},{"$f":"IF(A4=0,0,0.24*K4)","v":0},{"$f":"IF(A4=0,0,0.3*J4)","v":0},{"$f":"IF(A4=0,0,M4*'1 - Cost Estimations'!$E$35)","v":0},null,{"$f":"IF(A4=0,0,'4 - Inputs'!D5)","v":0},{"$f":"IF(A4=0,0,P4*'1 - Cost Estimations'!$E$18)","v":0},{"$f":"IF(A4=0,0,0.05*Q4)","v":0},{"$f":"IF(A4=0,0,0.3*P4)","v":0},{"$f":"IF(A4=0,0,S4*'1 - Cost Estimations'!$E$36)","v":0},null,{"$f":"IF(A4=0,0,'4 - Inputs'!E5)","v":0},{"$f":"IF(A4=0,0,'4 - Inputs'!F5*'1 - Cost Estimations'!$E$28)","v":0},{"$f":"IF(A4=0,0,W4*'1 - Cost Estimations'!$E$27)","v":0},null,{"$f":"IF(A4=0,0,'1 - Cost Estimations'!$E$7*('4 - Inputs'!C5+'4 - Inputs'!D5)*'1 - Cost Estimations'!$E$5*'1 - Cost Estimations'!$E$6)","v":0},{"$f":"IF(A4=0,0,('4 - Inputs'!C5+'4 - Inputs'!D5)*'1 - Cost Estimations'!$E$9*'1 - Cost Estimations'!$E$8)","v":0},{"$f":"IF(A4=0,0,('4 - Inputs'!C5+'4 - Inputs'!D5)*'1 - Cost Estimations'!$E$11*'1 - Cost Estimations'!$E$10)","v":0},null,{"$f":"IF(A4=0,0,'1 - Cost Estimations'!$E$31*('5 - Outputs'!J4+'5 - Outputs'!P4))","v":0}]
[{"$f":"'4 - Inputs'!B6","v":0},{"$f":"IF(A5=0,0,'3 - People per Household'!M7*J5)","v":0},{"$f":"IF(A5=0,0,'5 - Outputs'!M5*'3 - People per Household'!M7)","v":0},{"$f":"IF(A5=0,0,B5*'1 - Cost Estimations'!$E$24)","v":0},null,{"$f":"IF(A5=0,0,B5*0.415)","v":0},{"$f":"IF(A5=0,0,F5*0.39)","v":0},{"$f":"IF(A5=0,0,'4 - Inputs'!G6)","v":0},null,{"$f":"IF(A5=0,0,'4 - Inputs'!C6)","v":0},{"$f":"IF(A5=0,0,J5*'1 - Cost Estimations'!$E$14)","v":0},{"$f":"IF(A5=0,0,0.24*K5)","v":0},{"$f":"IF(A5=0,0,0.3*J5)","v":0},{"$f":"IF(A5=0,0,M5*'1 - Cost Estimations'!$E$35)","v":0},null,{"$f":"IF(A5=0,0,'4 - Inputs'!D6)","v":0},{"$f":"IF(A5=0,0,P5*'1 - Cost Estimations'!$E$18)","v":0},{"$f":"IF(A5=0,0,0.05*Q5)","v":0},{"$f":"IF(A5=0,0,0.3*P5)","v":0},{"$f":"IF(A5=0,0,S5*'1 - Cost Estimations'!$E$36)","v":0},null,{"$f":"IF(A5=0,0,'4 - Inputs'!E6)","v":0},{"$f":"IF(A5=0,0,'4 - Inputs'!F6*'1 - Cost Estimations'!$E$28)","v":0},{"$f":"IF(A5=0,0,W5*'1 - Cost Estimations'!$E$27)","v":0},null,{"$f":"IF(A5=0,0,'1 - Cost Estimations'!$E$7*('4 - Inputs'!C6+'4 - Inputs'!D6)*'1 - Cost Estimations'!$E$5*'1 - Cost Estimations'!$E$6)","v":0},{"$f":"IF(A5=0,0,('4 - Inputs'!C6+'4 - Inputs'!D6)*'1 - Cost Estimations'!$E$9*'1 - Cost Estimations'!$E$8)","v":0},{"$f":"IF(A5=0,0,('4 - Inputs'!C6+'4 - Inputs'!D6)*'1 - Cost Estimations'!$E$11*'1 - Cost Estimations'!$E$10)","v":0},null,{"$f":"IF(A5=0,0,'1 - Cost Estimations'!$E$31*('5 - Outputs'!J5+'5 - Outputs'!P5))","v":0}]
[{"$f":"'4 - Inputs'!B7","v":0},{"$f":"IF(A6=0,0,'3 - People per Household'!M8*J6)","v":0},{"$f":"IF(A6=0,0,'5 - Outputs'!M6*'3 - People per Household'!M8)","v":0},{"$f":"IF(A6=0,0,B6*'1 - Cost Estimations'!$E$24)","v":0},null,0,0,{"$f":"IF(A6=0,0,'4 - Inputs'!G7)","v":0},null,{"$f":"IF(A6=0,0,'4 - Inputs'!C7)","v":0},{"$f":"IF(A6=0,0,J6*'1 - Cost Estimations'!$E$14)","v":0},0,0,{"$f":"IF(A6=0,0,M6*'1 - Cost Estimations'!$E$35)","v":0},null,{"$f":"IF(A6=0,0,'4 - Inputs'!D7)","v":0},{"$f":"IF(A6=0,0,P6*'1 - Cost Estimations'!$E$18)","v":0},0,0,{"$f":"IF(A6=0,0,S6*'1 - Cost Estimations'!$E$36)","v":0},null,{"$f":"IF(A6=0,0,'4 - Inputs'!E7)","v":0},{"$f":"IF(A6=0,0,'4 - Inputs'!F7*'1 - Cost Estimations'!$E$28)","v":0},{"$f":"IF(A6=0,0,W6*'1 - Cost Estimations'!$E$27)","v":0},null,{"$f":"IF(A6=0,0,'1 - Cost Estimations'!$E$7*('4 - Inputs'!C7+'4 - Inputs'!D7)*'1 - Cost Estimations'!$E$5*'1 - Cost Estimations'!$E$6)","v":0},{"$f":"IF(A6=0,0,('4 - Inputs'!C7+'4 - Inputs'!D7)*'1 - Cost Estimations'!$E$9*'1 - Cost Estimations'!$E$8)","v":0},{"$f":"IF(A6=0,0,('4 - Inputs'!C7+'4 - Inputs'!D7)*'1 - Cost Estimations'!$E$11*'1 - Cost Estimations'!$E$10)","v":0},null,{"$f":"IF(A6=0,0,'1 - Cost Estimations'!$E$31*('5 - Outputs'!J6+'5 - Outputs'!P6))","v":0}]
[{"$f":"'4 - Inputs'!B8","v":0},{"$f":"IF(A7=0,0,'3 - People per Household'!M9*J7)","v":0},{"$f":"IF(A7=0,0,'5 - Outputs'!M7*'3 - People per Household'!M9)","v":0},{"$f":"IF(A7=0,0,B7*'1 - Cost Estimations'!$E$24)","v":0},null,0,0,{"$f":"IF(A7=0,0,'4 - Inputs'!G8)","v":0},null,{"$f":"IF(A7=0,0,'4 - Inputs'!C8)","v":0},{"$f":"IF(A7=0,0,J7*'1 - Cost Estimations'!$E$14)","v":0},0,0,{"$f":"IF(A7=0,0,M7*'1 - Cost Estimations'!$E$35)","v":0},null,{"$f":"IF(A7=0,0,'4 - Inputs'!D8)","v":0},{"$f":"IF(A7=0,0,P7*'1 - Cost Estimations'!$E$18)","v":0},0,0,{"$f":"IF(A7=0,0,S7*'1 - Cost Estimations'!$E$36)","v":0},null,{"$f":"IF(A7=0,0,'4 - Inputs'!E8)","v":0},{"$f":"IF(A7=0,0,'4 - Inputs'!F8*'1 - Cost Estimations'!$E$28)","v":0},{"$f":"IF(A7=0,0,W7*'1 - Cost Estimations'!$E$27)","v":0},null,{"$f":"IF(A7=0,0,'1 - Cost Estimations'!$E$7*('4 - Inputs'!C8+'4 - Inputs'!D8)*'1 - Cost Estimations'!$E$5*'1 - Cost Estimations'!$E$6)","v":0},{"$f":"IF(A7=0,0,('4 - Inputs'!C8+'4 - Inputs'!D8)*'1 - Cost Estimations'!$E$9*'1 - Cost Estimations'!$E$8)","v":0},{"$f":"IF(A7=0,0,('4 - Inputs'!C8+'4 - Inputs'!D8)*'1 - Cost Estimations'!$E$11*'1 - Cost Estimations'!$E$10)","v":0},null,{"$f":"IF(A7=0,0,'1 - Cost Estimations'!$E$31*('5 - Outputs'!J7+'5 - Outputs'!P7))","v":0}]
[{"$f":"'4 - Inputs'!B9","v":0},{"$f":"IF(A8=0,0,'3 - People per Household'!M10*J8)","v":0},{"$f":"IF(A8=0,0,'5 - Outputs'!M8*'3 - People per Household'!M10)","v":0},{"$f":"IF(A8=0,0,B8*'1 - Cost Estimations'!$E$24)","v":0},null,0,0,{"$f":"IF(A8=0,0,'4 - Inputs'!G9)","v":0},null,{"$f":"IF(A8=0,0,'4 - Inputs'!C9)","v":0},{"$f":"IF(A8=0,0,J8*'1 - Cost Estimations'!$E$14)","v":0},0,0,{"$f":"IF(A8=0,0,M8*'1 - Cost Estimations'!$E$35)","v":0},null,{"$f":"IF(A8=0,0,'4 - Inputs'!D9)","v":0},{"$f":"IF(A8=0,0,P8*'1 - Cost Estimations'!$E$18)","v":0},0,0,{"$f":"IF(A8=0,0,S8*'1 - Cost Estimations'!$E$36)","v":0},null,{"$f":"IF(A8=0,0,'4 - Inputs'!E9)","v":0},{"$f":"IF(A8=0,0,'4 - Inputs'!F9*'1 - Cost Estimations'!$E$28)","v":0},{"$f":"IF(A8=0,0,W8*'1 - Cost Estimations'!$E$27)","v":0},null,{"$f":"IF(A8=0,0,'1 - Cost Estimations'!$E$7*('4 - Inputs'!C9+'4 - Inputs'!D9)*'1 - Cost Estimations'!$E$5*'1 - Cost Estimations'!$E$6)","v":0},{"$f":"IF(A8=0,0,('4 - Inputs'!C9+'4 - Inputs'!D9)*'1 - Cost Estimations'!$E$9*'1 - Cost Estimations'!$E$8)","v":0},{"$f":"IF(A8=0,0,('4 - Inputs'!C9+'4 - Inputs'!D9)*'1 - Cost Estimations'!$E$11*'1 - Cost Estimations'!$E$10)","v":0},null,{"$f":"IF(A8=0,0,'1 - Cost Estimations'!$E$31*('5 - Outputs'!J8+'5 - Outputs'!P8))","v":0}]
[{"$f":"'4 - Inputs'!B10","v":0},{"$f":"IF(A9=0,0,'3 - People per Household'!M11*J9)","v":0},{"$f":"IF(A9=0,0,'5 - Outputs'!M9*'3 - People per Household'!M11)","v":0},{"$f":"IF(A9=0,0,B9*'1 - Cost Estimations'!$E$24)","v":0},null,0,0,{"$f":"IF(A9=0,0,'4 - Inputs'!G10)","v":0},null,{"$f":"IF(A9=0,0,'4 - Inputs'!C10)","v":0},{"$f":"IF(A9=0,0,J9*'1 - Cost Estimations'!$E$14)","v":0},0,0,{"$f":"IF(A9=0,0,M9*'1 - Cost Estimations'!$E$35)","v":0},null,{"$f":"IF(A9=0,0,'4 - Inputs'!D10)","v":0},{"$f":"IF(A9=0,0,P9*'1 - Cost Estimations'!$E$18)","v":0},0,0,{"$f":"IF(A9=0,0,S9*'1 - Cost Estimations'!$E$36)","v":0},null,{"$f":"IF(A9=0,0,'4 - Inputs'!E10)","v":0},{"$f":"IF(A9=0,0,'4 - Inputs'!F10*'1 - Cost Estimations'!$E$28)","v":0},{"$f":"IF(A9=0,0,W9*'1 - Cost Estimations'!$E$27)","v":0},null,{"$f":"IF(A9=0,0,'1 - Cost Estimations'!$E$7*('4 - Inputs'!C10+'4 - Inputs'!D10)*'1 - Cost Estimations'!$E$5*'1 - Cost Estimations'!$E$6)","v":0},{"$f":"IF(A9=0,0,('4 - Inputs'!C10+'4 - Inputs'!D10)*'1 - Cost Estimations'!$E$9*'1 - Cost Estimations'!$E$8)","v":0},{"$f":"IF(A9=0,0,('4 - Inputs'!C10+'4 - Inputs'!D10)*'1 - Cost Estimations'!$E$11*'1 - Cost Estimations'!$E$10)","v":0},null,{"$f":"IF(A9=0,0,'1 - Cost Estimations'!$E$31*('5 - Outputs'!J9+'5 - Outputs'!P9))","v":0}]
[{"$f":"'4 - Inputs'!B11","v":0},{"$f":"IF(A10=0,0,'3 - People per Household'!M12*J10)","v":0},{"$f":"IF(A10=0,0,'5 - Outputs'!M10*'3 - People per Household'!M12)","v":0},{"$f":"IF(A10=0,0,B10*'1 - Cost Estimations'!$E$24)","v":0},null,0,0,{"$f":"IF(A10=0,0,'4 - Inputs'!G11)","v":0},null,{"$f":"IF(A10=0,0,'4 - Inputs'!C11)","v":0},{"$f":"IF(A10=0,0,J10*'1 - Cost Estimations'!$E$14)","v":0},0,0,{"$f":"IF(A10=0,0,M10*'1 - Cost Estimations'!$E$35)","v":0},null,{"$f":"IF(A10=0,0,'4 - Inputs'!D11)","v":0},{"$f":"IF(A10=0,0,P10*'1 - Cost Estimations'!$E$18)","v":0},0,0,{"$f":"IF(A10=0,0,S10*'1 - Cost Estimations'!$E$36)","v":0},null,{"$f":"IF(A10=0,0,'4 - Inputs'!E11)","v":0},{"$f":"IF(A10=0,0,'4 - Inputs'!F11*'1 - Cost Estimations'!$E$28)","v":0},{"$f":"IF(A10=0,0,W10*'1 - Cost Estimations'!$E$27)","v":0},null,{"$f":"IF(A10=0,0,'1 - Cost Estimations'!$E$7*('4 - Inputs'!C11+'4 - Inputs'!D11)*'1 - Cost Estimations'!$E$5*'1 - Cost Estimations'!$E$6)","v":0},{"$f":"IF(A10=0,0,('4 - Inputs'!C11+'4 - Inputs'!D11)*'1 - Cost Estimations'!$E$9*'1 - Cost Estimations'!$E$8)","v":0},{"$f":"IF(A10=0,0,('4 - Inputs'!C11+'4 - Inputs'!D11)*'1 - Cost Estimations'!$E$11*'1 - Cost Estimations'!$E$10)","v":0},null,{"$f":"IF(A10=0,0,'1 - Cost Estimations'!$E$31*('5 - Outputs'!J10+'5 - Outputs'!P10))","v":0}]
[{"$f":"'4 - Inputs'!B12","v":0},{"$f":"IF(A11=0,0,'3 - People per Household'!M13*J11)","v":0},{"$f":"IF(A11=0,0,'5 - Outputs'!M11*'3 - People per Household'!M13)","v":0},{"$f":"IF(A11=0,0,B11*'1 - Cost Estimations'!$E$24)","v":0},null,0,0,{"$f":"IF(A11=0,0,'4 - Inputs'!G12)","v":0},null,{"$f":"IF(A11=0,0,'4 - Inputs'!C12)","v":0},{"$f":"IF(A11=0,0,J11*'1 - Cost Estimations'!$E$14)","v":0},0,0,{"$f":"IF(A11=0,0,M11*'1 - Cost Estimations'!$E$35)","v":0},null,{"$f":"IF(A11=0,0,'4 - Inputs'!D12)","v":0},{"$f":"IF(A11=0,0,P11*'1 - Cost Estimations'!$E$18)","v":0},0,0,{"$f":"IF(A11=0,0,S11*'1 - Cost Estimations'!$E$36)","v":0},null,{"$f":"IF(A11=0,0,'4 - Inputs'!E12)","v":0},{"$f":"IF(A11=0,0,'4 - Inputs'!F12*'1 - Cost Estimations'!$E$28)","v":0},{"$f":"IF(A11=0,0,W11*'1 - Cost Estimations'!$E$27)","v":0},null,{"$f":"IF(A11=0,0,'1 - Cost Estimations'!$E$7*('4 - Inputs'!C12+'4 - Inputs'!D12)*'1 - Cost Estimations'!$E$5*'1 - Cost Estimations'!$E$6)","v":0},{"$f":"IF(A11=0,0,('4 - Inputs'!C12+'4 - Inputs'!D12)*'1 - Cost Estimations'!$E$9*'1 - Cost Estimations'!$E$8)","v":0},{"$f":"IF(A11=0,0,('4 - Inputs'!C12+'4 - Inputs'!D12)*'1 - Cost Estimations'!$E$11*'1 - Cost Estimations'!$E$10)","v":0},null,{"$f":"IF(A11=0,0,'1 - Cost Estimations'!$E$31*('5 - Outputs'!J11+'5 - Outputs'!P11))","v":0}]
[{"$f":"'4 - Inputs'!B13","v":0},{"$f":"IF(A12=0,0,'3 - People per Household'!M14*J12)","v":0},{"$f":"IF(A12=0,0,'5 - Outputs'!M12*'3 - People per Household'!M14)","v":0},{"$f":"IF(A12=0,0,B12*'1 - Cost Estimations'!$E$24)","v":0},null,0,0,{"$f":"IF(A12=0,0,'4 - Inputs'!G13)","v":0},null,{"$f":"IF(A12=0,0,'4 - Inputs'!C13)","v":0},{"$f":"IF(A12=0,0,J12*'1 - Cost Estimations'!$E$14)","v":0},0,0,{"$f":"IF(A12=0,0,M12*'1 - Cost Estimations'!$E$35)","v":0},null,{"$f":"IF(A12=0,0,'4 - Inputs'!D13)","v":0},{"$f":"IF(A12=0,0,P12*'1 - Cost Estimations'!$E$18)","v":0},0,0,{"$f":"IF(A12=0,0,S12*'1 - Cost Estimations'!$E$36)","v":0},null,{"$f":"IF(A12=0,0,'4 - Inputs'!E13)","v":0},{"$f":"IF(A12=0,0,'4 - Inputs'!F13*'1 - Cost Estimations'!$E$28)","v":0},{"$f":"IF(A12=0,0,W12*'1 - Cost Estimations'!$E$27)","v":0},null,{"$f":"IF(A12=0,0,'1 - Cost Estimations'!$E$7*('4 - Inputs'!C13+'4 - Inputs'!D13)*'1 - Cost Estimations'!$E$5*'1 - Cost Estimations'!$E$6)","v":0},{"$f":"IF(A12=0,0,('4 - Inputs'!C13+'4 - Inputs'!D13)*'1 - Cost Estimations'!$E$9*'1 - Cost Estimations'!$E$8)","v":0},{"$f":"IF(A12=0,0,('4 - Inputs'!C13+'4 - Inputs'!D13)*'1 - Cost Estimations'!$E$11*'1 - Cost Estimations'!$E$10)","v":0},null,{"$f":"IF(A12=0,0,'1 - Cost Estimations'!$E$31*('5 - Outputs'!J12+'5 - Outputs'!P12))","v":0}]
[{"$f":"'4 - Inputs'!B14","v":0},{"$f":"IF(A13=0,0,'3 - People per Household'!M15*J13)","v":0},{"$f":"IF(A13=0,0,'5 - Outputs'!M13*'3 - People per Household'!M15)","v":0},{"$f":"IF(A13=0,0,B13*'1 - Cost Estimations'!$E$24)","v":0},null,0,0,{"$f":"IF(A13=0,0,'4 - Inputs'!G14)","v":0},null,{"$f":"IF(A13=0,0,'4 - Inputs'!C14)","v":0},{"$f":"IF(A13=0,0,J13*'1 - Cost Estimations'!$E$14)","v":0},0,0,{"$f":"IF(A13=0,0,M13*'1 - Cost Estimations'!$E$35)","v":0},null,{"$f":"IF(A13=0,0,'4 - Inputs'!D14)","v":0},{"$f":"IF(A13=0,0,P13*'1 - Cost Estimations'!$E$18)","v":0},0,0,{"$f":"IF(A13=0,0,S13*'1 - Cost Estimations'!$E$36)","v":0},null,{"$f":"IF(A13=0,0,'4 - Inputs'!E14)","v":0},{"$f":"IF(A13=0,0,'4 - Inputs'!F14*'1 - Cost Estimations'!$E$28)","v":0},{"$f":"IF(A13=0,0,W13*'1 - Cost Estimations'!$E$27)","v":0},null,{"$f":"IF(A13=0,0,'1 - Cost Estimations'!$E$7*('4 - Inputs'!C14+'4 - Inputs'!D14)*'1 - Cost Estimations'!$E$5*'1 - Cost Estimations'!$E$6)","v":0},{"$f":"IF(A13=0,0,('4 - Inputs'!C14+'4 - Inputs'!D14)*'1 - Cost Estimations'!$E$9*'1 - Cost Estimations'!$E$8)","v":0},{"$f":"IF(A13=0,0,('4 - Inputs'!C14+'4 - Inputs'!D14)*'1 - Cost Estimations'!$E$11*'1 - Cost Estimations'!$E$10)","v":0},null,{"$f":"IF(A13=0,0,'1 - Cost Estimations'!$E$31*('5 - Outputs'!J13+'5 - Outputs'!P13))","v":0}]
[{"$f":"'4 - Inputs'!B15","v":0},{"$f":"IF(A14=0,0,'3 - People per Household'!M16*J14)","v":0},{"$f":"IF(A14=0,0,'5 - Outputs'!M14*'3 - People per Household'!M16)","v":0},{"$f":"IF(A14=0,0,B14*'1 - Cost Estimations'!$E$24)","v":0},null,0,0,{"$f":"IF(A14=0,0,'4 - Inputs'!G15)","v":0},null,{"$f":"IF(A14=0,0,'4 - Inputs'!C15)","v":0},{"$f":"IF(A14=0,0,J14*'1 - Cost Estimations'!$E$14)","v":0},0,0,{"$f":"IF(A14=0,0,M14*'1 - Cost Estimations'!$E$35)","v":0},null,{"$f":"IF(A14=0,0,'4 - Inputs'!D15)","v":0},{"$f":"IF(A14=0,0,P14*'1 - Cost Estimations'!$E$18)","v":0},0,0,{"$f":"IF(A14=0,0,S14*'1 - Cost Estimations'!$E$36)","v":0},null,{"$f":"IF(A14=0,0,'4 - Inputs'!E15)","v":0},{"$f":"IF(A14=0,0,'4 - Inputs'!F15*'1 - Cost Estimations'!$E$28)","v":0},{"$f":"IF(A14=0,0,W14*'1 - Cost Estimations'!$E$27)","v":0},null,{"$f":"IF(A14=0,0,'1 - Cost Estimations'!$E$7*('4 - Inputs'!C15+'4 - Inputs'!D15)*'1 - Cost Estimations'!$E$5*'1 - Cost Estimations'!$E$6)","v":0},{"$f":"IF(A14=0,0,('4 - Inputs'!C15+'4 - Inputs'!D15)*'1 - Cost Estimations'!$E$9*'1 - Cost Estimations'!$E$8)","v":0},{"$f":"IF(A14=0,0,('4 - Inputs'!C15+'4 - Inputs'!D15)*'1 - Cost Estimations'!$E$11*'1 - Cost Estimations'!$E$10)","v":0},null,{"$f":"IF(A14=0,0,'1 - Cost Estimations'!$E$31*('5 - Outputs'!J14+'5 - Outputs'!P14))","v":0}]
[{"$f":"'4 - Inputs'!B16","v":0},{"$f":"IF(A15=0,0,'3 - People per Household'!M17*J15)","v":0},{"$f":"IF(A15=0,0,'5 - Outputs'!M15*'3 - People per Household'!M17)","v":0},{"$f":"IF(A15=0,0,B15*'1 - Cost Estimations'!$E$24)","v":0},null,0,0,{"$f":"IF(A15=0,0,'4 - Inputs'!G16)","v":0},null,{"$f":"IF(A15=0,0,'4 - Inputs'!C16)","v":0},{"$f":"IF(A15=0,0,J15*'1 - Cost Estimations'!$E$14)","v":0},0,0,{"$f":"IF(A15=0,0,M15*'1 - Cost Estimations'!$E$35)","v":0},null,{"$f":"IF(A15=0,0,'4 - Inputs'!D16)","v":0},{"$f":"IF(A15=0,0,P15*'1 - Cost Estimations'!$E$18)","v":0},0,0,{"$f":"IF(A15=0,0,S15*'1 - Cost Estimations'!$E$36)","v":0},null,{"$f":"IF(A15=0,0,'4 - Inputs'!E16)","v":0},{"$f":"IF(A15=0,0,'4 - Inputs'!F16*'1 - Cost Estimations'!$E$28)","v":0},{"$f":"IF(A15=0,0,W15*'1 - Cost Estimations'!$E$27)","v":0},null,{"$f":"IF(A15=0,0,'1 - Cost Estimations'!$E$7*('4 - Inputs'!C16+'4 - Inputs'!D16)*'1 - Cost Estimations'!$E$5*'1 - Cost Estimations'!$E$6)","v":0},{"$f":"IF(A15=0,0,('4 - Inputs'!C16+'4 - Inputs'!D16)*'1 - Cost Estimations'!$E$9*'1 - Cost Estimations'!$E$8)","v":0},{"$f":"IF(A15=0,0,('4 - Inputs'!C16+'4 - Inputs'!D16)*'1 - Cost Estimations'!$E$11*'1 - Cost Estimations'!$E$10)","v":0},null,{"$f":"IF(A15=0,0,'1 - Cost Estimations'!$E$31*('5 - Outputs'!J15+'5 - Outputs'!P15))","v":0}]
[{"$f":"'4 - Inputs'!B17","v":0},{"$f":"IF(A16=0,0,'3 - People per Household'!M18*J16)","v":0},{"$f":"IF(A16=0,0,'5 - Outputs'!M16*'3 - People per Household'!M18)","v":0},{"$f":"IF(A16=0,0,B16*'1 - Cost Estimations'!$E$24)","v":0},null,0,0,{"$f":"IF(A16=0,0,'4 - Inputs'!G17)","v":0},null,{"$f":"IF(A16=0,0,'4 - Inputs'!C17)","v":0},{"$f":"IF(A16=0,0,J16*'1 - Cost Estimations'!$E$14)","v":0},0,0,{"$f":"IF(A16=0,0,M16*'1 - Cost Estimations'!$E$35)","v":0},null,{"$f":"IF(A16=0,0,'4 - Inputs'!D17)","v":0},{"$f":"IF(A16=0,0,P16*'1 - Cost Estimations'!$E$18)","v":0},0,0,{"$f":"IF(A16=0,0,S16*'1 - Cost Estimations'!$E$36)","v":0},null,{"$f":"IF(A16=0,0,'4 - Inputs'!E17)","v":0},{"$f":"IF(A16=0,0,'4 - Inputs'!F17*'1 - Cost Estimations'!$E$28)","v":0},{"$f":"IF(A16=0,0,W16*'1 - Cost Estimations'!$E$27)","v":0},null,{"$f":"IF(A16=0,0,'1 - Cost Estimations'!$E$7*('4 - Inputs'!C17+'4 - Inputs'!D17)*'1 - Cost Estimations'!$E$5*'1 - Cost Estimations'!$E$6)","v":0},{"$f":"IF(A16=0,0,('4 - Inputs'!C17+'4 - Inputs'!D17)*'1 - Cost Estimations'!$E$9*'1 - Cost Estimations'!$E$8)","v":0},{"$f":"IF(A16=0,0,('4 - Inputs'!C17+'4 - Inputs'!D17)*'1 - Cost Estimations'!$E$11*'1 - Cost Estimations'!$E$10)","v":0},null,{"$f":"IF(A16=0,0,'1 - Cost Estimations'!$E$31*('5 - Outputs'!J16+'5 - Outputs'!P16))","v":0}]
[{"$f":"'4 - Inputs'!B18","v":0},{"$f":"IF(A17=0,0,'3 - People per Household'!M19*J17)","v":0},{"$f":"IF(A17=0,0,'5 - Outputs'!M17*'3 - People per Household'!M19)","v":0},{"$f":"IF(A17=0,0,B17*'1 - Cost Estimations'!$E$24)","v":0},null,0,0,{"$f":"IF(A17=0,0,'4 - Inputs'!G18)","v":0},null,{"$f":"IF(A17=0,0,'4 - Inputs'!C18)","v":0},{"$f":"IF(A17=0,0,J17*'1 - Cost Estimations'!$E$14)","v":0},0,0,{"$f":"IF(A17=0,0,M17*'1 - Cost Estimations'!$E$35)","v":0},null,{"$f":"IF(A17=0,0,'4 - Inputs'!D18)","v":0},{"$f":"IF(A17=0,0,P17*'1 - Cost Estimations'!$E$18)","v":0},0,0,{"$f":"IF(A17=0,0,S17*'1 - Cost Estimations'!$E$36)","v":0},null,{"$f":"IF(A17=0,0,'4 - Inputs'!E18)","v":0},{"$f":"IF(A17=0,0,'4 - Inputs'!F18*'1 - Cost Estimations'!$E$28)","v":0},{"$f":"IF(A17=0,0,W17*'1 - Cost Estimations'!$E$27)","v":0},null,{"$f":"IF(A17=0,0,'1 - Cost Estimations'!$E$7*('4 - Inputs'!C18+'4 - Inputs'!D18)*'1 - Cost Estimations'!$E$5*'1 - Cost Estimations'!$E$6)","v":0},{"$f":"IF(A17=0,0,('4 - Inputs'!C18+'4 - Inputs'!D18)*'1 - Cost Estimations'!$E$9*'1 - Cost Estimations'!$E$8)","v":0},{"$f":"IF(A17=0,0,('4 - Inputs'!C18+'4 - Inputs'!D18)*'1 - Cost Estimations'!$E$11*'1 - Cost Estimations'!$E$10)","v":0},null,{"$f":"IF(A17=0,0,'1 - Cost Estimations'!$E$31*('5 - Outputs'!J17+'5 - Outputs'!P17))","v":0}]
[{"$f":"'4 - Inputs'!B19","v":0},{"$f":"IF(A18=0,0,'3 - People per Household'!M20*J18)","v":0},{"$f":"IF(A18=0,0,'5 - Outputs'!M18*'3 - People per Household'!M20)","v":0},{"$f":"IF(A18=0,0,B18*'1 - Cost Estimations'!$E$24)","v":0},null,0,0,{"$f":"IF(A18=0,0,'4 - Inputs'!G19)","v":0},null,{"$f":"IF(A18=0,0,'4 - Inputs'!C19)","v":0},{"$f":"IF(A18=0,0,J18*'1 - Cost Estimations'!$E$14)","v":0},0,0,{"$f":"IF(A18=0,0,M18*'1 - Cost Estimations'!$E$35)","v":0},null,{"$f":"IF(A18=0,0,'4 - Inputs'!D19)","v":0},{"$f":"IF(A18=0,0,P18*'1 - Cost Estimations'!$E$18)","v":0},0,0,{"$f":"IF(A18=0,0,S18*'1 - Cost Estimations'!$E$36)","v":0},null,{"$f":"IF(A18=0,0,'4 - Inputs'!E19)","v":0},{"$f":"IF(A18=0,0,'4 - Inputs'!F19*'1 - Cost Estimations'!$E$28)","v":0},{"$f":"IF(A18=0,0,W18*'1 - Cost Estimations'!$E$27)","v":0},null,{"$f":"IF(A18=0,0,'1 - Cost Estimations'!$E$7*('4 - Inputs'!C19+'4 - Inputs'!D19)*'1 - Cost Estimations'!$E$5*'1 - Cost Estimations'!$E$6)","v":0},{"$f":"IF(A18=0,0,('4 - Inputs'!C19+'4 - Inputs'!D19)*'1 - Cost Estimations'!$E$9*'1 - Cost Estimations'!$E$8)","v":0},{"$f":"IF(A18=0,0,('4 - Inputs'!C19+'4 - Inputs'!D19)*'1 - Cost Estimations'!$E$11*'1 - Cost Estimations'!$E$10)","v":0},null,{"$f":"IF(A18=0,0,'1 - Cost Estimations'!$E$31*('5 - Outputs'!J18+'5 - Outputs'!P18))","v":0}]
[{"$f":"'4 - Inputs'!B20","v":0},{"$f":"IF(A19=0,0,'3 - People per Household'!M21*J19)","v":0},{"$f":"IF(A19=0,0,'5 - Outputs'!M19*'3 - People per Household'!M21)","v":0},{"$f":"IF(A19=0,0,B19*'1 - Cost Estimations'!$E$24)","v":0},null,0,0,{"$f":"IF(A19=0,0,'4 - Inputs'!G20)","v":0},null,{"$f":"IF(A19=0,0,'4 - Inputs'!C20)","v":0},{"$f":"IF(A19=0,0,J19*'1 - Cost Estimations'!$E$14)","v":0},0,0,{"$f":"IF(A19=0,0,M19*'1 - Cost Estimations'!$E$35)","v":0},null,{"$f":"IF(A19=0,0,'4 - Inputs'!D20)","v":0},{"$f":"IF(A19=0,0,P19*'1 - Cost Estimations'!$E$18)","v":0},0,0,{"$f":"IF(A19=0,0,S19*'1 - Cost Estimations'!$E$36)","v":0},null,{"$f":"IF(A19=0,0,'4 - Inputs'!E20)","v":0},{"$f":"IF(A19=0,0,'4 - Inputs'!F20*'1 - Cost Estimations'!$E$28)","v":0},{"$f":"IF(A19=0,0,W19*'1 - Cost Estimations'!$E$27)","v":0},null,{"$f":"IF(A19=0,0,'1 - Cost Estimations'!$E$7*('4 - Inputs'!C20+'4 - Inputs'!D20)*'1 - Cost Estimations'!$E$5*'1 - Cost Estimations'!$E$6)","v":0},{"$f":"IF(A19=0,0,('4 - Inputs'!C20+'4 - Inputs'!D20)*'1 - Cost Estimations'!$E$9*'1 - Cost Estimations'!$E$8)","v":0},{"$f":"IF(A19=0,0,('4 - Inputs'!C20+'4 - Inputs'!D20)*'1 - Cost Estimations'!$E$11*'1 - Cost Estimations'!$E$10)","v":0},null,{"$f":"IF(A19=0,0,'1 - Cost Estimations'!$E$31*('5 - Outputs'!J19+'5 - Outputs'!P19))","v":0}]
[{"$f":"'4 - Inputs'!B21","v":0},{"$f":"IF(A20=0,0,'3 - People per Household'!M22*J20)","v":0},{"$f":"IF(A20=0,0,'5 - Outputs'!M20*'3 - People per Household'!M22)","v":0},{"$f":"IF(A20=0,0,B20*'1 - Cost Estimations'!$E$24)","v":0},null,0,0,{"$f":"IF(A20=0,0,'4 - Inputs'!G21)","v":0},null,{"$f":"IF(A20=0,0,'4 - Inputs'!C21)","v":0},{"$f":"IF(A20=0,0,J20*'1 - Cost Estimations'!$E$14)","v":0},0,0,{"$f":"IF(A20=0,0,M20*'1 - Cost Estimations'!$E$35)","v":0},null,{"$f":"IF(A20=0,0,'4 - Inputs'!D21)","v":0},{"$f":"IF(A20=0,0,P20*'1 - Cost Estimations'!$E$18)","v":0},0,0,{"$f":"IF(A20=0,0,S20*'1 - Cost Estimations'!$E$36)","v":0},null,{"$f":"IF(A20=0,0,'4 - Inputs'!E21)","v":0},{"$f":"IF(A20=0,0,'4 - Inputs'!F21*'1 - Cost Estimations'!$E$28)","v":0},{"$f":"IF(A20=0,0,W20*'1 - Cost Estimations'!$E$27)","v":0},null,{"$f":"IF(A20=0,0,'1 - Cost Estimations'!$E$7*('4 - Inputs'!C21+'4 - Inputs'!D21)*'1 - Cost Estimations'!$E$5*'1 - Cost Estimations'!$E$6)","v":0},{"$f":"IF(A20=0,0,('4 - Inputs'!C21+'4 - Inputs'!D21)*'1 - Cost Estimations'!$E$9*'1 - Cost Estimations'!$E$8)","v":0},{"$f":"IF(A20=0,0,('4 - Inputs'!C21+'4 - Inputs'!D21)*'1 - Cost Estimations'!$E$11*'1 - Cost Estimations'!$E$10)","v":0},null,{"$f":"IF(A20=0,0,'1 - Cost Estimations'!$E$31*('5 - Outputs'!J20+'5 - Outputs'!P20))","v":0}]
[{"$f":"'4 - Inputs'!B22","v":0},{"$f":"IF(A21=0,0,'3 - People per Household'!M23*J21)","v":0},{"$f":"IF(A21=0,0,'5 - Outputs'!M21*'3 - People per Household'!M23)","v":0},{"$f":"IF(A21=0,0,B21*'1 - Cost Estimations'!$E$24)","v":0},null,0,0,{"$f":"IF(A21=0,0,'4 - Inputs'!G22)","v":0},null,{"$f":"IF(A21=0,0,'4 - Inputs'!C22)","v":0},{"$f":"IF(A21=0,0,J21*'1 - Cost Estimations'!$E$14)","v":0},0,0,{"$f":"IF(A21=0,0,M21*'1 - Cost Estimations'!$E$35)","v":0},null,{"$f":"IF(A21=0,0,'4 - Inputs'!D22)","v":0},{"$f":"IF(A21=0,0,P21*'1 - Cost Estimations'!$E$18)","v":0},0,0,{"$f":"IF(A21=0,0,S21*'1 - Cost Estimations'!$E$36)","v":0},null,{"$f":"IF(A21=0,0,'4 - Inputs'!E22)","v":0},{"$f":"IF(A21=0,0,'4 - Inputs'!F22*'1 - Cost Estimations'!$E$28)","v":0},{"$f":"IF(A21=0,0,W21*'1 - Cost Estimations'!$E$27)","v":0},null,{"$f":"IF(A21=0,0,'1 - Cost Estimations'!$E$7*('4 - Inputs'!C22+'4 - Inputs'!D22)*'1 - Cost Estimations'!$E$5*'1 - Cost Estimations'!$E$6)","v":0},{"$f":"IF(A21=0,0,('4 - Inputs'!C22+'4 - Inputs'!D22)*'1 - Cost Estimations'!$E$9*'1 - Cost Estimations'!$E$8)","v":0},{"$f":"IF(A21=0,0,('4 - Inputs'!C22+'4 - Inputs'!D22)*'1 - Cost Estimations'!$E$11*'1 - Cost Estimations'!$E$10)","v":0},null,{"$f":"IF(A21=0,0,'1 - Cost Estimations'!$E$31*('5 - Outputs'!J21+'5 - Outputs'!P21))","v":0}]
[{"$f":"'4 - Inputs'!B23","v":0},{"$f":"IF(A22=0,0,'3 - People per Household'!M24*J22)","v":0},{"$f":"IF(A22=0,0,'5 - Outputs'!M22*'3 - People per Household'!M24)","v":0},{"$f":"IF(A22=0,0,B22*'1 - Cost Estimations'!$E$24)","v":0},null,0,0,{"$f":"IF(A22=0,0,'4 - Inputs'!G23)","v":0},null,{"$f":"IF(A22=0,0,'4 - Inputs'!C23)","v":0},{"$f":"IF(A22=0,0,J22*'1 - Cost Estimations'!$E$14)","v":0},0,0,{"$f":"IF(A22=0,0,M22*'1 - Cost Estimations'!$E$35)","v":0},null,{"$f":"IF(A22=0,0,'4 - Inputs'!D23)","v":0},{"$f":"IF(A22=0,0,P22*'1 - Cost Estimations'!$E$18)","v":0},0,0,{"$f":"IF(A22=0,0,S22*'1 - Cost Estimations'!$E$36)","v":0},null,{"$f":"IF(A22=0,0,'4 - Inputs'!E23)","v":0},{"$f":"IF(A22=0,0,'4 - Inputs'!F23*'1 - Cost Estimations'!$E$28)","v":0},{"$f":"IF(A22=0,0,W22*'1 - Cost Estimations'!$E$27)","v":0},null,{"$f":"IF(A22=0,0,'1 - Cost Estimations'!$E$7*('4 - Inputs'!C23+'4 - Inputs'!D23)*'1 - Cost Estimations'!$E$5*'1 - Cost Estimations'!$E$6)","v":0},{"$f":"IF(A22=0,0,('4 - Inputs'!C23+'4 - Inputs'!D23)*'1 - Cost Estimations'!$E$9*'1 - Cost Estimations'!$E$8)","v":0},{"$f":"IF(A22=0,0,('4 - Inputs'!C23+'4 - Inputs'!D23)*'1 - Cost Estimations'!$E$11*'1 - Cost Estimations'!$E$10)","v":0},null,{"$f":"IF(A22=0,0,'1 - Cost Estimations'!$E$31*('5 - Outputs'!J22+'5 - Outputs'!P22))","v":0}]
[{"$f":"'4 - Inputs'!B24","v":0},{"$f":"IF(A23=0,0,'3 - People per Household'!M25*J23)","v":0},{"$f":"IF(A23=0,0,'5 - Outputs'!M23*'3 - People per Household'!M25)","v":0},{"$f":"IF(A23=0,0,B23*'1 - Cost Estimations'!$E$24)","v":0},null,0,0,{"$f":"IF(A23=0,0,'4 - Inputs'!G24)","v":0},null,{"$f":"IF(A23=0,0,'4 - Inputs'!C24)","v":0},{"$f":"IF(A23=0,0,J23*'1 - Cost Estimations'!$E$14)","v":0},0,0,{"$f":"IF(A23=0,0,M23*'1 - Cost Estimations'!$E$35)","v":0},null,{"$f":"IF(A23=0,0,'4 - Inputs'!D24)","v":0},{"$f":"IF(A23=0,0,P23*'1 - Cost Estimations'!$E$18)","v":0},0,0,{"$f":"IF(A23=0,0,S23*'1 - Cost Estimations'!$E$36)","v":0},null,{"$f":"IF(A23=0,0,'4 - Inputs'!E24)","v":0},{"$f":"IF(A23=0,0,'4 - Inputs'!F24*'1 - Cost Estimations'!$E$28)","v":0},{"$f":"IF(A23=0,0,W23*'1 - Cost Estimations'!$E$27)","v":0},null,{"$f":"IF(A23=0,0,'1 - Cost Estimations'!$E$7*('4 - Inputs'!C24+'4 - Inputs'!D24)*'1 - Cost Estimations'!$E$5*'1 - Cost Estimations'!$E$6)","v":0},{"$f":"IF(A23=0,0,('4 - Inputs'!C24+'4 - Inputs'!D24)*'1 - Cost Estimations'!$E$9*'1 - Cost Estimations'!$E$8)","v":0},{"$f":"IF(A23=0,0,('4 - Inputs'!C24+'4 - Inputs'!D24)*'1 - Cost Estimations'!$E$11*'1 - Cost Estimations'!$E$10)","v":0},null,{"$f":"IF(A23=0,0,'1 - Cost Estimations'!$E$31*('5 - Outputs'!J23+'5 - Outputs'!P23))","v":0}]
[{"$f":"'4 - Inputs'!B25","v":0},{"$f":"IF(A24=0,0,'3 - People per Household'!M26*J24)","v":0},{"$f":"IF(A24=0,0,'5 - Outputs'!M24*'3 - People per Household'!M26)","v":0},{"$f":"IF(A24=0,0,B24*'1 - Cost Estimations'!$E$24)","v":0},null,0,0,{"$f":"IF(A24=0,0,'4 - Inputs'!G25)","v":0},null,{"$f":"IF(A24=0,0,'4 - Inputs'!C25)","v":0},{"$f":"IF(A24=0,0,J24*'1 - Cost Estimations'!$E$14)","v":0},0,0,{"$f":"IF(A24=0,0,M24*'1 - Cost Estimations'!$E$35)","v":0},null,{"$f":"IF(A24=0,0,'4 - Inputs'!D25)","v":0},{"$f":"IF(A24=0,0,P24*'1 - Cost Estimations'!$E$18)","v":0},0,0,{"$f":"IF(A24=0,0,S24*'1 - Cost Estimations'!$E$36)","v":0},null,{"$f":"IF(A24=0,0,'4 - Inputs'!E25)","v":0},{"$f":"IF(A24=0,0,'4 - Inputs'!F25*'1 - Cost Estimations'!$E$28)","v":0},{"$f":"IF(A24=0,0,W24*'1 - Cost Estimations'!$E$27)","v":0},null,{"$f":"IF(A24=0,0,'1 - Cost Estimations'!$E$7*('4 - Inputs'!C25+'4 - Inputs'!D25)*'1 - Cost Estimations'!$E$5*'1 - Cost Estimations'!$E$6)","v":0},{"$f":"IF(A24=0,0,('4 - Inputs'!C25+'4 - Inputs'!D25)*'1 - Cost Estimations'!$E$9*'1 - Cost Estimations'!$E$8)","v":0},{"$f":"IF(A24=0,0,('4 - Inputs'!C25+'4 - Inputs'!D25)*'1 - Cost Estimations'!$E$11*'1 - Cost Estimations'!$E$10)","v":0},null,{"$f":"IF(A24=0,0,'1 - Cost Estimations'!$E$31*('5 - Outputs'!J24+'5 - Outputs'!P24))","v":0}]
[{"$f":"'4 - Inputs'!B26","v":0},{"$f":"IF(A25=0,0,'3 - People per Household'!M27*J25)","v":0},{"$f":"IF(A25=0,0,'5 - Outputs'!M25*'3 - People per Household'!M27)","v":0},{"$f":"IF(A25=0,0,B25*'1 - Cost Estimations'!$E$24)","v":0},null,0,0,{"$f":"IF(A25=0,0,'4 - Inputs'!G26)","v":0},null,{"$f":"IF(A25=0,0,'4 - Inputs'!C26)","v":0},{"$f":"IF(A25=0,0,J25*'1 - Cost Estimations'!$E$14)","v":0},0,0,{"$f":"IF(A25=0,0,M25*'1 - Cost Estimations'!$E$35)","v":0},null,{"$f":"IF(A25=0,0,'4 - Inputs'!D26)","v":0},{"$f":"IF(A25=0,0,P25*'1 - Cost Estimations'!$E$18)","v":0},0,0,{"$f":"IF(A25=0,0,S25*'1 - Cost Estimations'!$E$36)","v":0},null,{"$f":"IF(A25=0,0,'4 - Inputs'!E26)","v":0},{"$f":"IF(A25=0,0,'4 - Inputs'!F26*'1 - Cost Estimations'!$E$28)","v":0},{"$f":"IF(A25=0,0,W25*'1 - Cost Estimations'!$E$27)","v":0},null,{"$f":"IF(A25=0,0,'1 - Cost Estimations'!$E$7*('4 - Inputs'!C26+'4 - Inputs'!D26)*'1 - Cost Estimations'!$E$5*'1 - Cost Estimations'!$E$6)","v":0},{"$f":"IF(A25=0,0,('4 - Inputs'!C26+'4 - Inputs'!D26)*'1 - Cost Estimations'!$E$9*'1 - Cost Estimations'!$E$8)","v":0},{"$f":"IF(A25=0,0,('4 - Inputs'!C26+'4 - Inputs'!D26)*'1 - Cost Estimations'!$E$11*'1 - Cost Estimations'!$E$10)","v":0},null,{"$f":"IF(A25=0,0,'1 - Cost Estimations'!$E$31*('5 - Outputs'!J25+'5 - Outputs'!P25))","v":0}]
[{"$f":"'4 - Inputs'!B27","v":0},{"$f":"IF(A26=0,0,'3 - People per Household'!M28*J26)","v":0},{"$f":"IF(A26=0,0,'5 - Outputs'!M26*'3 - People per Household'!M28)","v":0},{"$f":"IF(A26=0,0,B26*'1 - Cost Estimations'!$E$24)","v":0},null,0,0,{"$f":"IF(A26=0,0,'4 - Inputs'!G27)","v":0},null,{"$f":"IF(A26=0,0,'4 - Inputs'!C27)","v":0},{"$f":"IF(A26=0,0,J26*'1 - Cost Estimations'!$E$14)","v":0},0,0,{"$f":"IF(A26=0,0,M26*'1 - Cost Estimations'!$E$35)","v":0},null,{"$f":"IF(A26=0,0,'4 - Inputs'!D27)","v":0},{"$f":"IF(A26=0,0,P26*'1 - Cost Estimations'!$E$18)","v":0},0,0,{"$f":"IF(A26=0,0,S26*'1 - Cost Estimations'!$E$36)","v":0},null,{"$f":"IF(A26=0,0,'4 - Inputs'!E27)","v":0},{"$f":"IF(A26=0,0,'4 - Inputs'!F27*'1 - Cost Estimations'!$E$28)","v":0},{"$f":"IF(A26=0,0,W26*'1 - Cost Estimations'!$E$27)","v":0},null,{"$f":"IF(A26=0,0,'1 - Cost Estimations'!$E$7*('4 - Inputs'!C27+'4 - Inputs'!D27)*'1 - Cost Estimations'!$E$5*'1 - Cost Estimations'!$E$6)","v":0},{"$f":"IF(A26=0,0,('4 - Inputs'!C27+'4 - Inputs'!D27)*'1 - Cost Estimations'!$E$9*'1 - Cost Estimations'!$E$8)","v":0},{"$f":"IF(A26=0,0,('4 - Inputs'!C27+'4 - Inputs'!D27)*'1 - Cost Estimations'!$E$11*'1 - Cost Estimations'!$E$10)","v":0},null,{"$f":"IF(A26=0,0,'1 - Cost Estimations'!$E$31*('5 - Outputs'!J26+'5 - Outputs'!P26))","v":0}]
[{"$f":"'4 - Inputs'!B28","v":0},{"$f":"IF(A27=0,0,'3 - People per Household'!M29*J27)","v":0},{"$f":"IF(A27=0,0,'5 - Outputs'!M27*'3 - People per Household'!M29)","v":0},{"$f":"IF(A27=0,0,B27*'1 - Cost Estimations'!$E$24)","v":0},null,0,0,{"$f":"IF(A27=0,0,'4 - Inputs'!G28)","v":0},null,{"$f":"IF(A27=0,0,'4 - Inputs'!C28)","v":0},{"$f":"IF(A27=0,0,J27*'1 - Cost Estimations'!$E$14)","v":0},0,0,{"$f":"IF(A27=0,0,M27*'1 - Cost Estimations'!$E$35)","v":0},null,{"$f":"IF(A27=0,0,'4 - Inputs'!D28)","v":0},{"$f":"IF(A27=0,0,P27*'1 - Cost Estimations'!$E$18)","v":0},0,0,{"$f":"IF(A27=0,0,S27*'1 - Cost Estimations'!$E$36)","v":0},null,{"$f":"IF(A27=0,0,'4 - Inputs'!E28)","v":0},{"$f":"IF(A27=0,0,'4 - Inputs'!F28*'1 - Cost Estimations'!$E$28)","v":0},{"$f":"IF(A27=0,0,W27*'1 - Cost Estimations'!$E$27)","v":0},null,{"$f":"IF(A27=0,0,'1 - Cost Estimations'!$E$7*('4 - Inputs'!C28+'4 - Inputs'!D28)*'1 - Cost Estimations'!$E$5*'1 - Cost Estimations'!$E$6)","v":0},{"$f":"IF(A27=0,0,('4 - Inputs'!C28+'4 - Inputs'!D28)*'1 - Cost Estimations'!$E$9*'1 - Cost Estimations'!$E$8)","v":0},{"$f":"IF(A27=0,0,('4 - Inputs'!C28+'4 - Inputs'!D28)*'1 - Cost Estimations'!$E$11*'1 - Cost Estimations'!$E$10)","v":0},null,{"$f":"IF(A27=0,0,'1 - Cost Estimations'!$E$31*('5 - Outputs'!J27+'5 - Outputs'!P27))","v":0}]
[]
["Total",{"$f":"SUM(B4:B27)","v":0},{"$f":"SUM(C4:C27)","v":0},{"$f":"SUM(D4:D27)","v":0},null,{"$f":"SUM(F4:F27)","v":0},{"$f":"SUM(G4:G27)","v":0},{"$f":"SUM(H4:H27)","v":0},null,{"$f":"SUM(J4:J27)","v":0},{"$f":"SUM(K4:K27)","v":0},0,0,0,null,0,0,{"$f":"SUM(R4:R27)","v":0},0,0,null,0,0,0,null,0,0,0,null,0]

{"sheet":"6 - Summary","index":7,"n_rows":27,"n_cols":16,"rows_kept":27,"cut":false,"hidden":false,"merged":[]}
[null,"Number of Households Affected","Number of Businesses Affected","Number of Schools Affected","Number of People Affected","Number of GPs Affected","Number of People with Health Concerns","Number of People Requiring GP Visit","Number of People Temporarily Relocated","Number of People Requiring Evacuation Assistance","Tonnes of Waste Produced","Total Uninsured Cost ",null,"Total Cost ",null,"Total Cost       (20 Year Projection)"]
[{"$f":"'5 - Outputs'!A4","v":0},{"$f":"IF(A2=0,0,'5 - Outputs'!J4)","v":0},{"$f":"IF(A2=0,0,'5 - Outputs'!P4)","v":0},{"$f":"IF(A2=0,0,'5 - Outputs'!V4)","v":0},{"$f":"IF(A2=0,0,'5 - Outputs'!B4)","v":0},{"$f":"IF(A2=0,0,'5 - Outputs'!H4)","v":0},{"$f":"IF(A2=0,0,'5 - Outputs'!F4)","v":0},{"$f":"IF(A2=0,0,'5 - Outputs'!G4)","v":0},{"$f":"IF(A2=0,0,'5 - Outputs'!C4)","v":0},{"$f":"IF(A2=0,0,'5 - Outputs'!D4)","v":0},{"$f":"IF(A2=0,0,'5 - Outputs'!AD4)","v":0},{"$f":"IF(A2=0,0,'5 - Outputs'!L4+'5 - Outputs'!R4)","v":0},null,{"$f":"IF(A2=0,0,'5 - Outputs'!K4+'5 - Outputs'!N4+'5 - Outputs'!Q4+'5 - Outputs'!T4+'5 - Outputs'!X4+'5 - Outputs'!Z4+'5 - Outputs'!AA4+'5 - Outputs'!AB4)","v":0},null,{"$f":"IF(A2=0,0,(('5 - Outputs'!K4+('5 - Outputs'!K4*'1 - Cost Estimations'!S6))+'5 - Outputs'!N4+'5 - Outputs'!Q4+'5 - Outputs'!T4+'5 - Outputs'!X4+'5 - Outputs'!Z4+'5 - Outputs'!AA4+'5 - Outputs'!AB4))","v":0}]
[{"$f":"'5 - Outputs'!A5","v":0},{"$f":"IF(A3=0,0,'5 - Outputs'!J5)","v":0},{"$f":"IF(A3=0,0,'5 - Outputs'!P5)","v":0},{"$f":"IF(A3=0,0,'5 - Outputs'!V5)","v":0},{"$f":"IF(A3=0,0,'5 - Outputs'!B5)","v":0},{"$f":"IF(A3=0,0,'5 - Outputs'!H5)","v":0},{"$f":"IF(A3=0,0,'5 - Outputs'!F5)","v":0},{"$f":"IF(A3=0,0,'5 - Outputs'!G5)","v":0},{"$f":"IF(A3=0,0,'5 - Outputs'!C5)","v":0},{"$f":"IF(A3=0,0,'5 - Outputs'!D5)","v":0},{"$f":"IF(A3=0,0,'5 - Outputs'!AD5)","v":0},{"$f":"IF(A3=0,0,'5 - Outputs'!L5+'5 - Outputs'!R5)","v":0},null,{"$f":"IF(A3=0,0,'5 - Outputs'!K5+'5 - Outputs'!N5+'5 - Outputs'!Q5+'5 - Outputs'!T5+'5 - Outputs'!X5+'5 - Outputs'!Z5+'5 - Outputs'!AA5+'5 - Outputs'!AB5)","v":0},null,{"$f":"IF(A3=0,0,(('5 - Outputs'!K5+('5 - Outputs'!K5*'1 - Cost Estimations'!S7))+'5 - Outputs'!N5+'5 - Outputs'!Q5+'5 - Outputs'!T5+'5 - Outputs'!X5+'5 - Outputs'!Z5+'5 - Outputs'!AA5+'5 - Outputs'!AB5))","v":0}]
[{"$f":"'5 - Outputs'!A6","v":0},{"$f":"IF(A4=0,0,'5 - Outputs'!J6)","v":0},{"$f":"IF(A4=0,0,'5 - Outputs'!P6)","v":0},{"$f":"IF(A4=0,0,'5 - Outputs'!V6)","v":0},{"$f":"IF(A4=0,0,'5 - Outputs'!B6)","v":0},{"$f":"IF(A4=0,0,'5 - Outputs'!H6)","v":0},{"$f":"IF(A4=0,0,'5 - Outputs'!F6)","v":0},{"$f":"IF(A4=0,0,'5 - Outputs'!G6)","v":0},{"$f":"IF(A4=0,0,'5 - Outputs'!C6)","v":0},{"$f":"IF(A4=0,0,'5 - Outputs'!D6)","v":0},{"$f":"IF(A4=0,0,'5 - Outputs'!AD6)","v":0},{"$f":"IF(A4=0,0,'5 - Outputs'!L6+'5 - Outputs'!R6)","v":0},null,{"$f":"IF(A4=0,0,'5 - Outputs'!K6+'5 - Outputs'!N6+'5 - Outputs'!Q6+'5 - Outputs'!T6+'5 - Outputs'!X6+'5 - Outputs'!Z6+'5 - Outputs'!AA6+'5 - Outputs'!AB6)","v":0},null,{"$f":"IF(A4=0,0,(('5 - Outputs'!K6+('5 - Outputs'!K6*'1 - Cost Estimations'!S8))+'5 - Outputs'!N6+'5 - Outputs'!Q6+'5 - Outputs'!T6+'5 - Outputs'!X6+'5 - Outputs'!Z6+'5 - Outputs'!AA6+'5 - Outputs'!AB6))","v":0}]
[{"$f":"'5 - Outputs'!A7","v":0},{"$f":"IF(A5=0,0,'5 - Outputs'!J7)","v":0},{"$f":"IF(A5=0,0,'5 - Outputs'!P7)","v":0},{"$f":"IF(A5=0,0,'5 - Outputs'!V7)","v":0},{"$f":"IF(A5=0,0,'5 - Outputs'!B7)","v":0},{"$f":"IF(A5=0,0,'5 - Outputs'!H7)","v":0},{"$f":"IF(A5=0,0,'5 - Outputs'!F7)","v":0},{"$f":"IF(A5=0,0,'5 - Outputs'!G7)","v":0},{"$f":"IF(A5=0,0,'5 - Outputs'!C7)","v":0},{"$f":"IF(A5=0,0,'5 - Outputs'!D7)","v":0},{"$f":"IF(A5=0,0,'5 - Outputs'!AD7)","v":0},{"$f":"IF(A5=0,0,'5 - Outputs'!L7+'5 - Outputs'!R7)","v":0},null,{"$f":"IF(A5=0,0,'5 - Outputs'!K7+'5 - Outputs'!N7+'5 - Outputs'!Q7+'5 - Outputs'!T7+'5 - Outputs'!X7+'5 - Outputs'!Z7+'5 - Outputs'!AA7+'5 - Outputs'!AB7)","v":0},null,{"$f":"IF(A5=0,0,(('5 - Outputs'!K7+('5 - Outputs'!K7*'1 - Cost Estimations'!S9))+'5 - Outputs'!N7+'5 - Outputs'!Q7+'5 - Outputs'!T7+'5 - Outputs'!X7+'5 - Outputs'!Z7+'5 - Outputs'!AA7+'5 - Outputs'!AB7))","v":0}]
[{"$f":"'5 - Outputs'!A8","v":0},{"$f":"IF(A6=0,0,'5 - Outputs'!J8)","v":0},{"$f":"IF(A6=0,0,'5 - Outputs'!P8)","v":0},{"$f":"IF(A6=0,0,'5 - Outputs'!V8)","v":0},{"$f":"IF(A6=0,0,'5 - Outputs'!B8)","v":0},{"$f":"IF(A6=0,0,'5 - Outputs'!H8)","v":0},{"$f":"IF(A6=0,0,'5 - Outputs'!F8)","v":0},{"$f":"IF(A6=0,0,'5 - Outputs'!G8)","v":0},{"$f":"IF(A6=0,0,'5 - Outputs'!C8)","v":0},{"$f":"IF(A6=0,0,'5 - Outputs'!D8)","v":0},{"$f":"IF(A6=0,0,'5 - Outputs'!AD8)","v":0},{"$f":"IF(A6=0,0,'5 - Outputs'!L8+'5 - Outputs'!R8)","v":0},null,{"$f":"IF(A6=0,0,'5 - Outputs'!K8+'5 - Outputs'!N8+'5 - Outputs'!Q8+'5 - Outputs'!T8+'5 - Outputs'!X8+'5 - Outputs'!Z8+'5 - Outputs'!AA8+'5 - Outputs'!AB8)","v":0},null,{"$f":"IF(A6=0,0,(('5 - Outputs'!K8+('5 - Outputs'!K8*'1 - Cost Estimations'!S10))+'5 - Outputs'!N8+'5 - Outputs'!Q8+'5 - Outputs'!T8+'5 - Outputs'!X8+'5 - Outputs'!Z8+'5 - Outputs'!AA8+'5 - Outputs'!AB8))","v":0}]
[{"$f":"'5 - Outputs'!A9","v":0},{"$f":"IF(A7=0,0,'5 - Outputs'!J9)","v":0},{"$f":"IF(A7=0,0,'5 - Outputs'!P9)","v":0},{"$f":"IF(A7=0,0,'5 - Outputs'!V9)","v":0},{"$f":"IF(A7=0,0,'5 - Outputs'!B9)","v":0},{"$f":"IF(A7=0,0,'5 - Outputs'!H9)","v":0},{"$f":"IF(A7=0,0,'5 - Outputs'!F9)","v":0},{"$f":"IF(A7=0,0,'5 - Outputs'!G9)","v":0},{"$f":"IF(A7=0,0,'5 - Outputs'!C9)","v":0},{"$f":"IF(A7=0,0,'5 - Outputs'!D9)","v":0},{"$f":"IF(A7=0,0,'5 - Outputs'!AD9)","v":0},{"$f":"IF(A7=0,0,'5 - Outputs'!L9+'5 - Outputs'!R9)","v":0},null,{"$f":"IF(A7=0,0,'5 - Outputs'!K9+'5 - Outputs'!N9+'5 - Outputs'!Q9+'5 - Outputs'!T9+'5 - Outputs'!X9+'5 - Outputs'!Z9+'5 - Outputs'!AA9+'5 - Outputs'!AB9)","v":0},null,{"$f":"IF(A7=0,0,(('5 - Outputs'!K9+('5 - Outputs'!K9*'1 - Cost Estimations'!S11))+'5 - Outputs'!N9+'5 - Outputs'!Q9+'5 - Outputs'!T9+'5 - Outputs'!X9+'5 - Outputs'!Z9+'5 - Outputs'!AA9+'5 - Outputs'!AB9))","v":0}]
[{"$f":"'5 - Outputs'!A10","v":0},{"$f":"IF(A8=0,0,'5 - Outputs'!J10)","v":0},{"$f":"IF(A8=0,0,'5 - Outputs'!P10)","v":0},{"$f":"IF(A8=0,0,'5 - Outputs'!V10)","v":0},{"$f":"IF(A8=0,0,'5 - Outputs'!B10)","v":0},{"$f":"IF(A8=0,0,'5 - Outputs'!H10)","v":0},{"$f":"IF(A8=0,0,'5 - Outputs'!F10)","v":0},{"$f":"IF(A8=0,0,'5 - Outputs'!G10)","v":0},{"$f":"IF(A8=0,0,'5 - Outputs'!C10)","v":0},{"$f":"IF(A8=0,0,'5 - Outputs'!D10)","v":0},{"$f":"IF(A8=0,0,'5 - Outputs'!AD10)","v":0},{"$f":"IF(A8=0,0,'5 - Outputs'!L10+'5 - Outputs'!R10)","v":0},null,{"$f":"IF(A8=0,0,'5 - Outputs'!K10+'5 - Outputs'!N10+'5 - Outputs'!Q10+'5 - Outputs'!T10+'5 - Outputs'!X10+'5 - Outputs'!Z10+'5 - Outputs'!AA10+'5 - Outputs'!AB10)","v":0},null,{"$f":"IF(A8=0,0,(('5 - Outputs'!K10+('5 - Outputs'!K10*'1 - Cost Estimations'!S12))+'5 - Outputs'!N10+'5 - Outputs'!Q10+'5 - Outputs'!T10+'5 - Outputs'!X10+'5 - Outputs'!Z10+'5 - Outputs'!AA10+'5 - Outputs'!AB10))","v":0}]
[{"$f":"'5 - Outputs'!A11","v":0},{"$f":"IF(A9=0,0,'5 - Outputs'!J11)","v":0},{"$f":"IF(A9=0,0,'5 - Outputs'!P11)","v":0},{"$f":"IF(A9=0,0,'5 - Outputs'!V11)","v":0},{"$f":"IF(A9=0,0,'5 - Outputs'!B11)","v":0},{"$f":"IF(A9=0,0,'5 - Outputs'!H11)","v":0},{"$f":"IF(A9=0,0,'5 - Outputs'!F11)","v":0},{"$f":"IF(A9=0,0,'5 - Outputs'!G11)","v":0},{"$f":"IF(A9=0,0,'5 - Outputs'!C11)","v":0},{"$f":"IF(A9=0,0,'5 - Outputs'!D11)","v":0},{"$f":"IF(A9=0,0,'5 - Outputs'!AD11)","v":0},{"$f":"IF(A9=0,0,'5 - Outputs'!L11+'5 - Outputs'!R11)","v":0},null,{"$f":"IF(A9=0,0,'5 - Outputs'!K11+'5 - Outputs'!N11+'5 - Outputs'!Q11+'5 - Outputs'!T11+'5 - Outputs'!X11+'5 - Outputs'!Z11+'5 - Outputs'!AA11+'5 - Outputs'!AB11)","v":0},null,{"$f":"IF(A9=0,0,(('5 - Outputs'!K11+('5 - Outputs'!K11*'1 - Cost Estimations'!S13))+'5 - Outputs'!N11+'5 - Outputs'!Q11+'5 - Outputs'!T11+'5 - Outputs'!X11+'5 - Outputs'!Z11+'5 - Outputs'!AA11+'5 - Outputs'!AB11))","v":0}]
[{"$f":"'5 - Outputs'!A12","v":0},{"$f":"IF(A10=0,0,'5 - Outputs'!J12)","v":0},{"$f":"IF(A10=0,0,'5 - Outputs'!P12)","v":0},{"$f":"IF(A10=0,0,'5 - Outputs'!V12)","v":0},{"$f":"IF(A10=0,0,'5 - Outputs'!B12)","v":0},{"$f":"IF(A10=0,0,'5 - Outputs'!H12)","v":0},{"$f":"IF(A10=0,0,'5 - Outputs'!F12)","v":0},{"$f":"IF(A10=0,0,'5 - Outputs'!G12)","v":0},{"$f":"IF(A10=0,0,'5 - Outputs'!C12)","v":0},{"$f":"IF(A10=0,0,'5 - Outputs'!D12)","v":0},{"$f":"IF(A10=0,0,'5 - Outputs'!AD12)","v":0},{"$f":"IF(A10=0,0,'5 - Outputs'!L12+'5 - Outputs'!R12)","v":0},null,{"$f":"IF(A10=0,0,'5 - Outputs'!K12+'5 - Outputs'!N12+'5 - Outputs'!Q12+'5 - Outputs'!T12+'5 - Outputs'!X12+'5 - Outputs'!Z12+'5 - Outputs'!AA12+'5 - Outputs'!AB12)","v":0},null,{"$f":"IF(A10=0,0,(('5 - Outputs'!K12+('5 - Outputs'!K12*'1 - Cost Estimations'!S14))+'5 - Outputs'!N12+'5 - Outputs'!Q12+'5 - Outputs'!T12+'5 - Outputs'!X12+'5 - Outputs'!Z12+'5 - Outputs'!AA12+'5 - Outputs'!AB12))","v":0}]
[{"$f":"'5 - Outputs'!A13","v":0},{"$f":"IF(A11=0,0,'5 - Outputs'!J13)","v":0},{"$f":"IF(A11=0,0,'5 - Outputs'!P13)","v":0},{"$f":"IF(A11=0,0,'5 - Outputs'!V13)","v":0},{"$f":"IF(A11=0,0,'5 - Outputs'!B13)","v":0},{"$f":"IF(A11=0,0,'5 - Outputs'!H13)","v":0},{"$f":"IF(A11=0,0,'5 - Outputs'!F13)","v":0},{"$f":"IF(A11=0,0,'5 - Outputs'!G13)","v":0},{"$f":"IF(A11=0,0,'5 - Outputs'!C13)","v":0},{"$f":"IF(A11=0,0,'5 - Outputs'!D13)","v":0},{"$f":"IF(A11=0,0,'5 - Outputs'!AD13)","v":0},{"$f":"IF(A11=0,0,'5 - Outputs'!L13+'5 - Outputs'!R13)","v":0},null,{"$f":"IF(A11=0,0,'5 - Outputs'!K13+'5 - Outputs'!N13+'5 - Outputs'!Q13+'5 - Outputs'!T13+'5 - Outputs'!X13+'5 - Outputs'!Z13+'5 - Outputs'!AA13+'5 - Outputs'!AB13)","v":0},null,{"$f":"IF(A11=0,0,(('5 - Outputs'!K13+('5 - Outputs'!K13*'1 - Cost Estimations'!S15))+'5 - Outputs'!N13+'5 - Outputs'!Q13+'5 - Outputs'!T13+'5 - Outputs'!X13+'5 - Outputs'!Z13+'5 - Outputs'!AA13+'5 - Outputs'!AB13))","v":0}]
[{"$f":"'5 - Outputs'!A14","v":0},{"$f":"IF(A12=0,0,'5 - Outputs'!J14)","v":0},{"$f":"IF(A12=0,0,'5 - Outputs'!P14)","v":0},{"$f":"IF(A12=0,0,'5 - Outputs'!V14)","v":0},{"$f":"IF(A12=0,0,'5 - Outputs'!B14)","v":0},{"$f":"IF(A12=0,0,'5 - Outputs'!H14)","v":0},{"$f":"IF(A12=0,0,'5 - Outputs'!F14)","v":0},{"$f":"IF(A12=0,0,'5 - Outputs'!G14)","v":0},{"$f":"IF(A12=0,0,'5 - Outputs'!C14)","v":0},{"$f":"IF(A12=0,0,'5 - Outputs'!D14)","v":0},{"$f":"IF(A12=0,0,'5 - Outputs'!AD14)","v":0},{"$f":"IF(A12=0,0,'5 - Outputs'!L14+'5 - Outputs'!R14)","v":0},null,{"$f":"IF(A12=0,0,'5 - Outputs'!K14+'5 - Outputs'!N14+'5 - Outputs'!Q14+'5 - Outputs'!T14+'5 - Outputs'!X14+'5 - Outputs'!Z14+'5 - Outputs'!AA14+'5 - Outputs'!AB14)","v":0},null,{"$f":"IF(A12=0,0,(('5 - Outputs'!K14+('5 - Outputs'!K14*'1 - Cost Estimations'!S16))+'5 - Outputs'!N14+'5 - Outputs'!Q14+'5 - Outputs'!T14+'5 - Outputs'!X14+'5 - Outputs'!Z14+'5 - Outputs'!AA14+'5 - Outputs'!AB14))","v":0}]
[{"$f":"'5 - Outputs'!A15","v":0},{"$f":"IF(A13=0,0,'5 - Outputs'!J15)","v":0},{"$f":"IF(A13=0,0,'5 - Outputs'!P15)","v":0},{"$f":"IF(A13=0,0,'5 - Outputs'!V15)","v":0},{"$f":"IF(A13=0,0,'5 - Outputs'!B15)","v":0},{"$f":"IF(A13=0,0,'5 - Outputs'!H15)","v":0},{"$f":"IF(A13=0,0,'5 - Outputs'!F15)","v":0},{"$f":"IF(A13=0,0,'5 - Outputs'!G15)","v":0},{"$f":"IF(A13=0,0,'5 - Outputs'!C15)","v":0},{"$f":"IF(A13=0,0,'5 - Outputs'!D15)","v":0},{"$f":"IF(A13=0,0,'5 - Outputs'!AD15)","v":0},{"$f":"IF(A13=0,0,'5 - Outputs'!L15+'5 - Outputs'!R15)","v":0},null,{"$f":"IF(A13=0,0,'5 - Outputs'!K15+'5 - Outputs'!N15+'5 - Outputs'!Q15+'5 - Outputs'!T15+'5 - Outputs'!X15+'5 - Outputs'!Z15+'5 - Outputs'!AA15+'5 - Outputs'!AB15)","v":0},null,{"$f":"IF(A13=0,0,(('5 - Outputs'!K15+('5 - Outputs'!K15*'1 - Cost Estimations'!S17))+'5 - Outputs'!N15+'5 - Outputs'!Q15+'5 - Outputs'!T15+'5 - Outputs'!X15+'5 - Outputs'!Z15+'5 - Outputs'!AA15+'5 - Outputs'!AB15))","v":0}]
[{"$f":"'5 - Outputs'!A16","v":0},{"$f":"IF(A14=0,0,'5 - Outputs'!J16)","v":0},{"$f":"IF(A14=0,0,'5 - Outputs'!P16)","v":0},{"$f":"IF(A14=0,0,'5 - Outputs'!V16)","v":0},{"$f":"IF(A14=0,0,'5 - Outputs'!B16)","v":0},{"$f":"IF(A14=0,0,'5 - Outputs'!H16)","v":0},{"$f":"IF(A14=0,0,'5 - Outputs'!F16)","v":0},{"$f":"IF(A14=0,0,'5 - Outputs'!G16)","v":0},{"$f":"IF(A14=0,0,'5 - Outputs'!C16)","v":0},{"$f":"IF(A14=0,0,'5 - Outputs'!D16)","v":0},{"$f":"IF(A14=0,0,'5 - Outputs'!AD16)","v":0},{"$f":"IF(A14=0,0,'5 - Outputs'!L16+'5 - Outputs'!R16)","v":0},null,{"$f":"IF(A14=0,0,'5 - Outputs'!K16+'5 - Outputs'!N16+'5 - Outputs'!Q16+'5 - Outputs'!T16+'5 - Outputs'!X16+'5 - Outputs'!Z16+'5 - Outputs'!AA16+'5 - Outputs'!AB16)","v":0},null,{"$f":"IF(A14=0,0,(('5 - Outputs'!K16+('5 - Outputs'!K16*'1 - Cost Estimations'!S18))+'5 - Outputs'!N16+'5 - Outputs'!Q16+'5 - Outputs'!T16+'5 - Outputs'!X16+'5 - Outputs'!Z16+'5 - Outputs'!AA16+'5 - Outputs'!AB16))","v":0}]
[{"$f":"'5 - Outputs'!A17","v":0},{"$f":"IF(A15=0,0,'5 - Outputs'!J17)","v":0},{"$f":"IF(A15=0,0,'5 - Outputs'!P17)","v":0},{"$f":"IF(A15=0,0,'5 - Outputs'!V17)","v":0},{"$f":"IF(A15=0,0,'5 - Outputs'!B17)","v":0},{"$f":"IF(A15=0,0,'5 - Outputs'!H17)","v":0},{"$f":"IF(A15=0,0,'5 - Outputs'!F17)","v":0},{"$f":"IF(A15=0,0,'5 - Outputs'!G17)","v":0},{"$f":"IF(A15=0,0,'5 - Outputs'!C17)","v":0},{"$f":"IF(A15=0,0,'5 - Outputs'!D17)","v":0},{"$f":"IF(A15=0,0,'5 - Outputs'!AD17)","v":0},{"$f":"IF(A15=0,0,'5 - Outputs'!L17+'5 - Outputs'!R17)","v":0},null,{"$f":"IF(A15=0,0,'5 - Outputs'!K17+'5 - Outputs'!N17+'5 - Outputs'!Q17+'5 - Outputs'!T17+'5 - Outputs'!X17+'5 - Outputs'!Z17+'5 - Outputs'!AA17+'5 - Outputs'!AB17)","v":0},null,{"$f":"IF(A15=0,0,(('5 - Outputs'!K17+('5 - Outputs'!K17*'1 - Cost Estimations'!S19))+'5 - Outputs'!N17+'5 - Outputs'!Q17+'5 - Outputs'!T17+'5 - Outputs'!X17+'5 - Outputs'!Z17+'5 - Outputs'!AA17+'5 - Outputs'!AB17))","v":0}]
[{"$f":"'5 - Outputs'!A18","v":0},{"$f":"IF(A16=0,0,'5 - Outputs'!J18)","v":0},{"$f":"IF(A16=0,0,'5 - Outputs'!P18)","v":0},{"$f":"IF(A16=0,0,'5 - Outputs'!V18)","v":0},{"$f":"IF(A16=0,0,'5 - Outputs'!B18)","v":0},{"$f":"IF(A16=0,0,'5 - Outputs'!H18)","v":0},{"$f":"IF(A16=0,0,'5 - Outputs'!F18)","v":0},{"$f":"IF(A16=0,0,'5 - Outputs'!G18)","v":0},{"$f":"IF(A16=0,0,'5 - Outputs'!C18)","v":0},{"$f":"IF(A16=0,0,'5 - Outputs'!D18)","v":0},{"$f":"IF(A16=0,0,'5 - Outputs'!AD18)","v":0},{"$f":"IF(A16=0,0,'5 - Outputs'!L18+'5 - Outputs'!R18)","v":0},null,{"$f":"IF(A16=0,0,'5 - Outputs'!K18+'5 - Outputs'!N18+'5 - Outputs'!Q18+'5 - Outputs'!T18+'5 - Outputs'!X18+'5 - Outputs'!Z18+'5 - Outputs'!AA18+'5 - Outputs'!AB18)","v":0},null,{"$f":"IF(A16=0,0,(('5 - Outputs'!K18+('5 - Outputs'!K18*'1 - Cost Estimations'!S20))+'5 - Outputs'!N18+'5 - Outputs'!Q18+'5 - Outputs'!T18+'5 - Outputs'!X18+'5 - Outputs'!Z18+'5 - Outputs'!AA18+'5 - Outputs'!AB18))","v":0}]
[{"$f":"'5 - Outputs'!A19","v":0},{"$f":"IF(A17=0,0,'5 - Outputs'!J19)","v":0},{"$f":"IF(A17=0,0,'5 - Outputs'!P19)","v":0},{"$f":"IF(A17=0,0,'5 - Outputs'!V19)","v":0},{"$f":"IF(A17=0,0,'5 - Outputs'!B19)","v":0},{"$f":"IF(A17=0,0,'5 - Outputs'!H19)","v":0},{"$f":"IF(A17=0,0,'5 - Outputs'!F19)","v":0},{"$f":"IF(A17=0,0,'5 - Outputs'!G19)","v":0},{"$f":"IF(A17=0,0,'5 - Outputs'!C19)","v":0},{"$f":"IF(A17=0,0,'5 - Outputs'!D19)","v":0},{"$f":"IF(A17=0,0,'5 - Outputs'!AD19)","v":0},{"$f":"IF(A17=0,0,'5 - Outputs'!L19+'5 - Outputs'!R19)","v":0},null,{"$f":"IF(A17=0,0,'5 - Outputs'!K19+'5 - Outputs'!N19+'5 - Outputs'!Q19+'5 - Outputs'!T19+'5 - Outputs'!X19+'5 - Outputs'!Z19+'5 - Outputs'!AA19+'5 - Outputs'!AB19)","v":0},null,{"$f":"IF(A17=0,0,(('5 - Outputs'!K19+('5 - Outputs'!K19*'1 - Cost Estimations'!S21))+'5 - Outputs'!N19+'5 - Outputs'!Q19+'5 - Outputs'!T19+'5 - Outputs'!X19+'5 - Outputs'!Z19+'5 - Outputs'!AA19+'5 - Outputs'!AB19))","v":0}]
[{"$f":"'5 - Outputs'!A20","v":0},{"$f":"IF(A18=0,0,'5 - Outputs'!J20)","v":0},{"$f":"IF(A18=0,0,'5 - Outputs'!P20)","v":0},{"$f":"IF(A18=0,0,'5 - Outputs'!V20)","v":0},{"$f":"IF(A18=0,0,'5 - Outputs'!B20)","v":0},{"$f":"IF(A18=0,0,'5 - Outputs'!H20)","v":0},{"$f":"IF(A18=0,0,'5 - Outputs'!F20)","v":0},{"$f":"IF(A18=0,0,'5 - Outputs'!G20)","v":0},{"$f":"IF(A18=0,0,'5 - Outputs'!C20)","v":0},{"$f":"IF(A18=0,0,'5 - Outputs'!D20)","v":0},{"$f":"IF(A18=0,0,'5 - Outputs'!AD20)","v":0},{"$f":"IF(A18=0,0,'5 - Outputs'!L20+'5 - Outputs'!R20)","v":0},null,{"$f":"IF(A18=0,0,'5 - Outputs'!K20+'5 - Outputs'!N20+'5 - Outputs'!Q20+'5 - Outputs'!T20+'5 - Outputs'!X20+'5 - Outputs'!Z20+'5 - Outputs'!AA20+'5 - Outputs'!AB20)","v":0},null,{"$f":"IF(A18=0,0,(('5 - Outputs'!K20+('5 - Outputs'!K20*'1 - Cost Estimations'!S22))+'5 - Outputs'!N20+'5 - Outputs'!Q20+'5 - Outputs'!T20+'5 - Outputs'!X20+'5 - Outputs'!Z20+'5 - Outputs'!AA20+'5 - Outputs'!AB20))","v":0}]
[{"$f":"'5 - Outputs'!A21","v":0},{"$f":"IF(A19=0,0,'5 - Outputs'!J21)","v":0},{"$f":"IF(A19=0,0,'5 - Outputs'!P21)","v":0},{"$f":"IF(A19=0,0,'5 - Outputs'!V21)","v":0},{"$f":"IF(A19=0,0,'5 - Outputs'!B21)","v":0},{"$f":"IF(A19=0,0,'5 - Outputs'!H21)","v":0},{"$f":"IF(A19=0,0,'5 - Outputs'!F21)","v":0},{"$f":"IF(A19=0,0,'5 - Outputs'!G21)","v":0},{"$f":"IF(A19=0,0,'5 - Outputs'!C21)","v":0},{"$f":"IF(A19=0,0,'5 - Outputs'!D21)","v":0},{"$f":"IF(A19=0,0,'5 - Outputs'!AD21)","v":0},{"$f":"IF(A19=0,0,'5 - Outputs'!L21+'5 - Outputs'!R21)","v":0},null,{"$f":"IF(A19=0,0,'5 - Outputs'!K21+'5 - Outputs'!N21+'5 - Outputs'!Q21+'5 - Outputs'!T21+'5 - Outputs'!X21+'5 - Outputs'!Z21+'5 - Outputs'!AA21+'5 - Outputs'!AB21)","v":0},null,{"$f":"IF(A19=0,0,(('5 - Outputs'!K21+('5 - Outputs'!K21*'1 - Cost Estimations'!S23))+'5 - Outputs'!N21+'5 - Outputs'!Q21+'5 - Outputs'!T21+'5 - Outputs'!X21+'5 - Outputs'!Z21+'5 - Outputs'!AA21+'5 - Outputs'!AB21))","v":0}]
[{"$f":"'5 - Outputs'!A22","v":0},{"$f":"IF(A20=0,0,'5 - Outputs'!J22)","v":0},{"$f":"IF(A20=0,0,'5 - Outputs'!P22)","v":0},{"$f":"IF(A20=0,0,'5 - Outputs'!V22)","v":0},{"$f":"IF(A20=0,0,'5 - Outputs'!B22)","v":0},{"$f":"IF(A20=0,0,'5 - Outputs'!H22)","v":0},{"$f":"IF(A20=0,0,'5 - Outputs'!F22)","v":0},{"$f":"IF(A20=0,0,'5 - Outputs'!G22)","v":0},{"$f":"IF(A20=0,0,'5 - Outputs'!C22)","v":0},{"$f":"IF(A20=0,0,'5 - Outputs'!D22)","v":0},{"$f":"IF(A20=0,0,'5 - Outputs'!AD22)","v":0},{"$f":"IF(A20=0,0,'5 - Outputs'!L22+'5 - Outputs'!R22)","v":0},null,{"$f":"IF(A20=0,0,'5 - Outputs'!K22+'5 - Outputs'!N22+'5 - Outputs'!Q22+'5 - Outputs'!T22+'5 - Outputs'!X22+'5 - Outputs'!Z22+'5 - Outputs'!AA22+'5 - Outputs'!AB22)","v":0},null,{"$f":"IF(A20=0,0,(('5 - Outputs'!K22+('5 - Outputs'!K22*'1 - Cost Estimations'!S24))+'5 - Outputs'!N22+'5 - Outputs'!Q22+'5 - Outputs'!T22+'5 - Outputs'!X22+'5 - Outputs'!Z22+'5 - Outputs'!AA22+'5 - Outputs'!AB22))","v":0}]
[{"$f":"'5 - Outputs'!A23","v":0},{"$f":"IF(A21=0,0,'5 - Outputs'!J23)","v":0},{"$f":"IF(A21=0,0,'5 - Outputs'!P23)","v":0},{"$f":"IF(A21=0,0,'5 - Outputs'!V23)","v":0},{"$f":"IF(A21=0,0,'5 - Outputs'!B23)","v":0},{"$f":"IF(A21=0,0,'5 - Outputs'!H23)","v":0},{"$f":"IF(A21=0,0,'5 - Outputs'!F23)","v":0},{"$f":"IF(A21=0,0,'5 - Outputs'!G23)","v":0},{"$f":"IF(A21=0,0,'5 - Outputs'!C23)","v":0},{"$f":"IF(A21=0,0,'5 - Outputs'!D23)","v":0},{"$f":"IF(A21=0,0,'5 - Outputs'!AD23)","v":0},{"$f":"IF(A21=0,0,'5 - Outputs'!L23+'5 - Outputs'!R23)","v":0},null,{"$f":"IF(A21=0,0,'5 - Outputs'!K23+'5 - Outputs'!N23+'5 - Outputs'!Q23+'5 - Outputs'!T23+'5 - Outputs'!X23+'5 - Outputs'!Z23+'5 - Outputs'!AA23+'5 - Outputs'!AB23)","v":0},null,{"$f":"IF(A21=0,0,(('5 - Outputs'!K23+('5 - Outputs'!K23*'1 - Cost Estimations'!S25))+'5 - Outputs'!N23+'5 - Outputs'!Q23+'5 - Outputs'!T23+'5 - Outputs'!X23+'5 - Outputs'!Z23+'5 - Outputs'!AA23+'5 - Outputs'!AB23))","v":0}]
[{"$f":"'5 - Outputs'!A24","v":0},{"$f":"IF(A22=0,0,'5 - Outputs'!J24)","v":0},{"$f":"IF(A22=0,0,'5 - Outputs'!P24)","v":0},{"$f":"IF(A22=0,0,'5 - Outputs'!V24)","v":0},{"$f":"IF(A22=0,0,'5 - Outputs'!B24)","v":0},{"$f":"IF(A22=0,0,'5 - Outputs'!H24)","v":0},{"$f":"IF(A22=0,0,'5 - Outputs'!F24)","v":0},{"$f":"IF(A22=0,0,'5 - Outputs'!G24)","v":0},{"$f":"IF(A22=0,0,'5 - Outputs'!C24)","v":0},{"$f":"IF(A22=0,0,'5 - Outputs'!D24)","v":0},{"$f":"IF(A22=0,0,'5 - Outputs'!AD24)","v":0},{"$f":"IF(A22=0,0,'5 - Outputs'!L24+'5 - Outputs'!R24)","v":0},null,{"$f":"IF(A22=0,0,'5 - Outputs'!K24+'5 - Outputs'!N24+'5 - Outputs'!Q24+'5 - Outputs'!T24+'5 - Outputs'!X24+'5 - Outputs'!Z24+'5 - Outputs'!AA24+'5 - Outputs'!AB24)","v":0},null,{"$f":"IF(A22=0,0,(('5 - Outputs'!K24+('5 - Outputs'!K24*'1 - Cost Estimations'!S26))+'5 - Outputs'!N24+'5 - Outputs'!Q24+'5 - Outputs'!T24+'5 - Outputs'!X24+'5 - Outputs'!Z24+'5 - Outputs'!AA24+'5 - Outputs'!AB24))","v":0}]
[{"$f":"'5 - Outputs'!A25","v":0},{"$f":"IF(A23=0,0,'5 - Outputs'!J25)","v":0},{"$f":"IF(A23=0,0,'5 - Outputs'!P25)","v":0},{"$f":"IF(A23=0,0,'5 - Outputs'!V25)","v":0},{"$f":"IF(A23=0,0,'5 - Outputs'!B25)","v":0},{"$f":"IF(A23=0,0,'5 - Outputs'!H25)","v":0},{"$f":"IF(A23=0,0,'5 - Outputs'!F25)","v":0},{"$f":"IF(A23=0,0,'5 - Outputs'!G25)","v":0},{"$f":"IF(A23=0,0,'5 - Outputs'!C25)","v":0},{"$f":"IF(A23=0,0,'5 - Outputs'!D25)","v":0},{"$f":"IF(A23=0,0,'5 - Outputs'!AD25)","v":0},{"$f":"IF(A23=0,0,'5 - Outputs'!L25+'5 - Outputs'!R25)","v":0},null,{"$f":"IF(A23=0,0,'5 - Outputs'!K25+'5 - Outputs'!N25+'5 - Outputs'!Q25+'5 - Outputs'!T25+'5 - Outputs'!X25+'5 - Outputs'!Z25+'5 - Outputs'!AA25+'5 - Outputs'!AB25)","v":0},null,{"$f":"IF(A23=0,0,(('5 - Outputs'!K25+('5 - Outputs'!K25*'1 - Cost Estimations'!S27))+'5 - Outputs'!N25+'5 - Outputs'!Q25+'5 - Outputs'!T25+'5 - Outputs'!X25+'5 - Outputs'!Z25+'5 - Outputs'!AA25+'5 - Outputs'!AB25))","v":0}]
[{"$f":"'5 - Outputs'!A26","v":0},{"$f":"IF(A24=0,0,'5 - Outputs'!J26)","v":0},{"$f":"IF(A24=0,0,'5 - Outputs'!P26)","v":0},{"$f":"IF(A24=0,0,'5 - Outputs'!V26)","v":0},{"$f":"IF(A24=0,0,'5 - Outputs'!B26)","v":0},{"$f":"IF(A24=0,0,'5 - Outputs'!H26)","v":0},{"$f":"IF(A24=0,0,'5 - Outputs'!F26)","v":0},{"$f":"IF(A24=0,0,'5 - Outputs'!G26)","v":0},{"$f":"IF(A24=0,0,'5 - Outputs'!C26)","v":0},{"$f":"IF(A24=0,0,'5 - Outputs'!D26)","v":0},{"$f":"IF(A24=0,0,'5 - Outputs'!AD26)","v":0},{"$f":"IF(A24=0,0,'5 - Outputs'!L26+'5 - Outputs'!R26)","v":0},null,{"$f":"IF(A24=0,0,'5 - Outputs'!K26+'5 - Outputs'!N26+'5 - Outputs'!Q26+'5 - Outputs'!T26+'5 - Outputs'!X26+'5 - Outputs'!Z26+'5 - Outputs'!AA26+'5 - Outputs'!AB26)","v":0},null,{"$f":"IF(A24=0,0,(('5 - Outputs'!K26+('5 - Outputs'!K26*'1 - Cost Estimations'!S28))+'5 - Outputs'!N26+'5 - Outputs'!Q26+'5 - Outputs'!T26+'5 - Outputs'!X26+'5 - Outputs'!Z26+'5 - Outputs'!AA26+'5 - Outputs'!AB26))","v":0}]
[{"$f":"'5 - Outputs'!A27","v":0},{"$f":"IF(A25=0,0,'5 - Outputs'!J27)","v":0},{"$f":"IF(A25=0,0,'5 - Outputs'!P27)","v":0},{"$f":"IF(A25=0,0,'5 - Outputs'!V27)","v":0},{"$f":"IF(A25=0,0,'5 - Outputs'!B27)","v":0},{"$f":"IF(A25=0,0,'5 - Outputs'!H27)","v":0},{"$f":"IF(A25=0,0,'5 - Outputs'!F27)","v":0},{"$f":"IF(A25=0,0,'5 - Outputs'!G27)","v":0},{"$f":"IF(A25=0,0,'5 - Outputs'!C27)","v":0},{"$f":"IF(A25=0,0,'5 - Outputs'!D27)","v":0},{"$f":"IF(A25=0,0,'5 - Outputs'!AD27)","v":0},{"$f":"IF(A25=0,0,'5 - Outputs'!L27+'5 - Outputs'!R27)","v":0},null,{"$f":"IF(A25=0,0,'5 - Outputs'!K27+'5 - Outputs'!N27+'5 - Outputs'!Q27+'5 - Outputs'!T27+'5 - Outputs'!X27+'5 - Outputs'!Z27+'5 - Outputs'!AA27+'5 - Outputs'!AB27)","v":0},null,{"$f":"IF(A25=0,0,(('5 - Outputs'!K27+('5 - Outputs'!K27*'1 - Cost Estimations'!S29))+'5 - Outputs'!N27+'5 - Outputs'!Q27+'5 - Outputs'!T27+'5 - Outputs'!X27+'5 - Outputs'!Z27+'5 - Outputs'!AA27+'5 - Outputs'!AB27))","v":0}]
[]
["Total",{"$f":"SUM(B2:B25)","v":0},{"$f":"SUM(C2:C25)","v":0},0,0,0,0,0,0,0,0,{"$f":"SUM(L2:L25)","v":0},null,{"$f":"SUM(N2:N25)","v":0},null,{"$f":"SUM(P2:P25)","v":0}]

{"sheet":"7 - Calculations","index":8,"n_rows":32,"n_cols":3,"rows_kept":32,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,"Output","Explanation of Calculations"]
[]
[null,"Cost of a School Day","Funding per pupil provided by the borough divided by the number of school days in one school year"]
[null,"Percent Vulnerable","Total number of people in the affected area over 70 plus the number of disabled people under 70, divided by the total population of the affected area"]
[null,"Number of People Affected","Number of households affected multiplied by the average number of people per household in the affected area"]
[null,"Number of People Temporarily Relocated","Percentage of households requiring temporary accomodations (30%) during the 2007 floods multiplied by the number of people per household"]
[null,"Number of People Requiring Evacuation Assistance","Percent Vulnerable multiplied by the number of people affected"]
[null,"Number of People Reporting Health Concerns","Percentage of people reporting health concerns from the 2007 flood multiplied by number of people affected"]
[null,"Number of People Requiring a GP Visit","Percentage of people who reported health concerns that visited a GP from the 2007 flood multiplied by the number of people reporting health concerns"]
[null,"Number of GPs Affected","Extracted from GIS Map"]
[null,"Number of Households Affected","Extracted from GIS Map"]
[null,"Total Cost of Damages to Households","Average household insurance claim from the 2007 flood multiplied by the number of houses affected"]
[null,"Total Uninsured Damage","Total cost of damages to households multiplied by the percentage of houses that are uninsured"]
[null,"Number of Households Requiring Temporary Accomodation","Percentage of households requiring temporary accomodations during the 2007 floods multiplied by the number of households affected"]
[null,"Total Cost of Temporary Accomodation for Households","Average cost of temporary accomodations for a household from the 2007 flood multiplied by the number of households requiring temporary accomodations"]
[null,"Number of Businesses Affected","Extracted from GIS Map"]
[null,"Total Cost of Damages to Businesses","Average business insurance claim from the 2007 flood multiplied by the number of businesses affected"]
[null,"Total Uninsured Damage","Total cost of damages to businesses multiplied by the percentage of businesses that are uninsured"]
[null,"Number of Businesses Requiring Temporary Accomodation","Percentage of businesses requiring temporary accomodations during the 2007 floods multiplied by the number of businesses affected"]
[null,"Total Cost of Temporary Accomodation for Businesses","Average cost of temporary accomodations for a business from the 2007 flood multiplied by the number of businesses requiring temporary accomodations"]
[null,"Number of Schools Affected","Extracted from GIS Map"]
[null,"Total Number of Pupil Days Lost","Average school closure duration from the 2007 flood multiplied by the number of pupils in affected schools"]
[null,"Total \"Cost of School Day\" Impacts","Total number of pupil days lost multiplied by the cost of a school day"]
[null,"Total Cost of Electricity Deprivation","Average electricity deprivation duration from the 2007 flood multiplied by average hourly household electricity consumption multiplied by a \"willingness to pay\" estimate for the cost of one kWh multiplied by the number of affected buildings (households and businesses)"]
[null,"Total Cost of Water Failure","Average water failure duration from the 2007 flood multiplied by a \"willingness to pay\" estimate for the cost of water services"]
[null,"Total Cost of Sewage Failure","Average sewage failure duration from the 2007 flood multiplied by a \"willingness to pay\" estimate for the cost of sewage"]
[null,"Tonnes of Waste Produced","Average amount of waste generated per building in a flood multiplied by the number of buildings"]
[]
[null,"Total Cost","All previous monetary costs combined"]
[null,"Total Cost (20 Year Projection)","Same formula as Total Cost with household damages multiplied by the percent change in population."]

{"sheet":"8 - Sources","index":9,"n_rows":14,"n_cols":4,"rows_kept":14,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Sources as Referenced",null,"Location"]
[]
[null,"EA 2007 Flood Report",null,"http://publications.environment-agency.gov.uk/pdf/SCHO1109BRJA-e-e.pdf "]
[]
[null,"Office for National Statistics",null,"http://www.neighbourhood.statistics.gov.uk/dissemination/"]
[]
[null,"Department for Education",null,"http://www.education.gov.uk/inyourarea/gors/gor_H.shtml "]
[]
[null,"Disaster Reduction and Human Renovation Institution",null,"http://www.dri.ne.jp/english/research/koremadeno.html"]
[]
[null,"Pitt Review",null,"http://webarchive.nationalarchives.gov.uk/20100807034701/http://archive.cabinetoffice.gov.uk/pittreview/thepittreview/final_report.html"]
[]
[null,"Greater London Authority",null,"http://data.london.gov.uk/datafiles/demographics/popproj_ward_2010rnd_ward_shlaa.xls"]