{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Cover Sheet","0. Worked example","Sheet1","1. Budget Calculator","2. Modelling data inputs","3. Current budget data","Sensitivity data"],"not_rendered":{"charts":0,"images":9,"macros":1,"external_links":0,"defined_names":6,"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":"Cover Sheet","index":0,"n_rows":35,"n_cols":19,"rows_kept":35,"cut":false,"hidden":false,"merged":[[1,2,2,16],[27,3,27,18],[29,3,29,18],[31,3,31,18],[4,1,23,18],[25,3,25,18]]}
[]
[null,null,"Indicative Scottish Homelessness Budget Calculator "]
[]
[]
[null,"This Scottish homelessness budget tool provides a high-level estimation of the required budget at a local authority level to tackle homelessness across Scotland. The model developed allows the user to explore the current costs of homelessness services based on the latest available Green Book data (POBE) and make adjustments based on the number of HL1 homeless assessments and the types of services used as well as any other sensitivities. This model provides a comparison of the current level of funding provided to local authorities from the Scottish Government. Guidance and information is provided for each stage of the budget calculation process. There are 5 steps to using this calculator:\n\nStep 1: Choose the breakdown for the budget calculation\nStart by choosing the breakdown for the data (ie an individual local authority, rural/urban local authorities, housing option hubs, or for the whole of Scotland). \n\nStep 2: Select or input the unit costs for type of services provided\nThis step determines the service type and the annual unit costs through pre-loaded drop-down options. The user also has the option of manually adding in costs. \n\nStep 3: Determine the number of people in each service\nThe number of people in a selection of service types can be added in here using current avaiable data, or through using estimates of the percentage of people who might be in each service. This can also be used to model what the service could like in the furture. This requires a manual input of percentages which then calculates the total number of people in each service based on homelessness assessment from 2018/19 - 2020/21. \n\nStep 4: Add in any sensitivities\nThe final step is to add any sensitivities that you feel are relevant to the budget estimation which in effects produces a margin of error for the model. \n\nStep 5: Estimated change in demand\nThis steps allows the user to produce budget projections for the next 2 years, using inflation and adjusting for any changes in demand. "]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"About each tab"]
[null,"Worked example",null,"The \"Worked example\" tab provides an example of how this tool can be used. Inputs are taken from publically aviable data and includes a 5% increase in demand for services currently as a result of Covid-19. For the projections, it includes an increase in demand for the next two years). "]
[]
[null,"Budget Calculator ",null,"The \"Budget Calculator\" tab allows you to develop an indicative budget for homelessness in Scotland across a range of levels: i) Local authority level, ii) Across Scotland, iii) Across all rural and all urban local authorities, and iv) Across Housing Options Hubs "]
[]
[null,"Modelling data inputs",null,"The \"Modelling data inputs\" tab sets out the main data sources, caveats and assumptions, as well as the unit costs for different homelessness support services which are incorporated into this budget estimation tool. "]
[]
[null,"Current budget data",null,"The \"Current budget data\" tab sets out the underlying data that this tool is built on. This tool uses information from the Scottish Government's Local Government Provisional Outturn and Budget Estimates (POBE) across the last three years (2018, 2019 and 2020),  with estimates of the total number of homeless acceptances (HL1 returns) taken from the Scottish Government's green book on Grant Aided expenditure."]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Version",3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"QA","2021-01-29"]

{"sheet":"0. Worked example","index":1,"n_rows":28,"n_cols":11,"rows_kept":28,"cut":false,"hidden":false,"merged":[[23,7,28,11],[19,1,20,1],[19,2,20,2],[19,3,20,3],[19,8,20,8],[9,5,10,5],[10,2,10,3],[4,1,4,2],[5,1,5,2],[6,1,6,2],[9,1,10,1],[9,2,9,4]]}
[]
[null,"INPUTS for Budget adjustments",null,null,null,null,null,null,"Budget estimation"]
[null,null,null,null,null,null,null,null,null,"Step 4: Sensitivity"]
[null,"Step 1: Select location",null,null,null,null,null,null,{"$f":"IF(ISBLANK($D$5), \"\", $D$5)","v":"TOTAL Scotland"},0.05]
[null,"Local authority",null,"TOTAL Scotland"]
[null,"Average annual cost per homeless assessments (2018/19-2020/21)",null,{"$f":"IF(ISBLANK($D$5), \"\",VLOOKUP($D$5,'3. Current budget data'!$B$10:$S$51,17, FALSE))","v":7613.4088480171022},null,null,null,null,"Estimated new budget by model (£) \n2018/19-2020/21","Sensitivity range"]
[null,"Total annual homeless assessments (numbers) (2018/19-2020/21)",null,{"$f":"IF(ISBLANK($D$5),\"\", VLOOKUP($D$5,'3. Current budget data'!$B$10:$T$51,18, FALSE))","v":30193.666666666672},null,null,null,null,{"$f":"IF(ISBLANK($D$5),\"\",SUM(($F$12*$D$22)+($F$13*$D$23)+($F$14*$D$24)+($F$15*$D$25)+($F$16*$D$26)+($F$17*$D$27)))","v":247573051.59299308},{"$f":"IF(SUM($I$7)=0,$I$7,_xlfn.CONCAT(TEXT(((-$J$4)+1)*$I$7,\"£#,###\"),\" - \",TEXT(($J$4+1)*$I$7,\"£#,###\")))","v":"£235,194,399 - £259,951,704"}]
[]
[null,"Step 2: Select or input unit costs",null,null,null,null,null,null,"Unit cost comparison"]
[null,"Service type","Annual Unit Costs (£)\n(see 2. Modelling data inputs for details)",null,null,"Annual Unit Costs used in model (£)",null,null,"Average POBE costs (£)\n2018/19 - 2020/21","*Estimated* unit cost by model (£)\n2018/19 - 2020/21","Difference (£)"]
[null,null,"Drop down options",null,"Manual input",null,null,null,{"$f":"IF(ISBLANK($D$5),\"\", $D$6)","v":7613.4088480171022},{"$f":"IF(SUM($D$7)=0,\"\",$I$7/$D$7)","v":8199.5027078413696},{"$f":"SUM($I$11)-SUM($J$11)","v":-586.09385982426738}]
[null,"Housing First","Support cost plus SRS rent ",{"$f":"IF(ISBLANK($C$12),0, VLOOKUP($B$12,'2. Modelling data inputs'!$B$13:$E$18,IF($C$12=\"Support cost\", \"2\", IF($C$12=\"Support cost plus SRS rent \",\"3\", IF($C$12=\"Support cost plus PRS rent \",\"4\", \"\"))),FALSE))","v":9878},null,{"$f":"IF($E$12>0,$E$12,IF($D$12>0,$D$12,$D$6))","v":9878}]
[null,"Hostel","Support cost",{"$f":"IF(ISBLANK($C$13),0, VLOOKUP($B$13,'2. Modelling data inputs'!$B$13:$E$18,IF($C$13=\"Support cost\", \"2\", IF($C$13=\"Support cost plus SRS rent \",\"3\", IF($C$13=\"Support cost plus PRS rent \",\"4\", \"\"))),FALSE))","v":12878},null,{"$f":"IF($E$13>0,$E$13,IF($D$13>0,$D$13,$D$6))","v":12878},null,null,"Budget comparison"]
[null,"High Intensity Supported Accommodation ","Support cost",{"$f":"IF(ISBLANK($C$14),0, VLOOKUP($B$14,'2. Modelling data inputs'!$B$13:$E$18,IF($C$14=\"Support cost\", \"2\", IF($C$14=\"Support cost plus SRS rent \",\"3\", IF($C$14=\"Support cost plus PRS rent \",\"4\", \"\"))),FALSE))","v":18885},null,{"$f":"IF($E$14>0,$E$14,IF($D$14>0,$D$14,$D$6))","v":18885},null,null,"Average POBE expenditure (£)\n2018/19-2020/21","Estimated new budget range by model (£)  2018/19-2020/21","Difference (£)"]
[null,"Low Intensity Accommodation Based Support","Support cost plus SRS rent ",{"$f":"IF(ISBLANK($C$15),0, VLOOKUP($B$15,'2. Modelling data inputs'!$B$13:$E$18,IF($C$15=\"Support cost\", \"2\", IF($C$15=\"Support cost plus SRS rent \",\"3\", IF($C$15=\"Support cost plus PRS rent \",\"4\", \"\"))),FALSE))","v":12160},null,{"$f":"IF($E$15>0,$E$15,IF($D$15>0,$D$15,$D$6))","v":12160},null,null,{"$f":"IF(ISBLANK($D$5),\"\",SUM($D$6*$D$7))","v":229876728.95407909},{"$f":"$J$7","v":"£235,194,399 - £259,951,704"},{"$f":"SUM($I$15)-SUM($I$7)","v":-17696322.638913989}]
[null,"Floating Support","Support cost",{"$f":"IF(ISBLANK($C$16),0, VLOOKUP($B$16,'2. Modelling data inputs'!$B$13:$E$18,IF($C$16=\"Support cost\", \"2\", IF($C$16=\"Support cost plus SRS rent \",\"3\", IF($C$16=\"Support cost plus PRS rent \",\"4\", \"\"))),FALSE))","v":3046},null,{"$f":"IF($E$16>0,$E$16,IF($D$16>0,$D$16,$D$6))","v":3046}]
[null,"Other or unspecified",null,{"$f":"$D$6","v":7613.4088480171022},null,{"$f":"IF($E$17=0,$D$17,$E$17)","v":7613.4088480171022},null,null,"Budget forecast","Estimated budget (2021/22) (£)","Estimated budget (2022/23) (£)"]
[null,null,null,null,null,null,null,null,"Adjusted for annual inflation of 2%",{"$f":"IF(SUM($I$7)=0,$J$7,_xlfn.CONCAT(TEXT(((-$J$4)+1)*$I$7*(0.02+1)*(IF(ISNUMBER($J$20),$J$20,0)+1),\"£#,###\"),\" - \",TEXT(($J$4+1)*$I$7*(0.02+1)*(IF(ISNUMBER($J$20),$J$20,0)+1),\"£#,###\")))","v":"£275,883,030 - £304,923,349"},{"$f":"IF(SUM($I$7)=0,$I$7,_xlfn.CONCAT(TEXT(((-$J$4)+1)*$I$7*(0.02+1)*(0.02+1)*(IF(ISNUMBER($J$20),$J$20,0)+1)*(IF(ISNUMBER($K$20),$K$20,0)+1),\"£#,###\"),\" - \",TEXT(($J$4+1)*$I$7*(0.02+1)*(0.02+1)*(IF(ISNUMBER($J$20),$J$20,0)+1)*(IF(ISNUMBER($K$20),$K$20,0)+1),\"£#,###\")))","v":"£295,470,725 - £326,572,907"}]
[null,"Step 3: Input users by service type"]
[null,"Service type","Estimated % of \npeople in each service","Estimated number of people annually in each service",null,null,null,null,"Step 5: Expected annual change in demand",0.15,0.05]
[]
[null,"Housing First",0.01,{"$f":"IF(ISBLANK($D$5), \"\", $D$7*$C$22)","v":301.93666666666672}]
[null,"Hostel",0.26,{"$f":"IF(ISBLANK($D$5), \"\", $D$7*$C$23)","v":7850.3533333333353}]
[null,"High Intensity Supported Accommodation ",0.01,{"$f":"IF(ISBLANK($D$5), \"\", $D$7*$C$24)","v":301.93666666666672},null,null,null,"Caveats for budget estimation: \n\n1. Based on ringfencing of POBE budget which is not the case. New budget estimates, and therefore the difference in budgets is likely to be an underestimate.\n2. Service costs are based on the best available data for service types based on data from and English study. The use of these figures seeks to demonstrates the differences in the cost of support services and the impact this will have on the budget\n3. Inflation is adjusted for in the annual service unit costs and for the budget projections\n4. The sensitivity analysis can be used to allow for any margins of error and is recommended for use in developing a new budget estimate"]
[null,"Low Intensity Accommodation Based Support",0.22,{"$f":"IF(ISBLANK($D$5), \"\", $D$7*$C$25)","v":6642.6066666666675}]
[null,"Floating Support",0.42,{"$f":"IF(ISBLANK($D$5), \"\", $D$7*$C$26)","v":12681.340000000002}]
[null,"Other or unspecified",{"$f":"100%-SUM($C$22:$C$26)","v":8.0000000000000071E-2},{"$f":"IF(ISBLANK($D$5), \"\", $D$7*$C$27)","v":2415.4933333333361}]
[null,null,{"$f":"SUM($C$22:$C$27)","v":1},{"$f":"SUM($D$22:$D$27)","v":30193.666666666675}]

{"sheet":"Sheet1","index":2,"n_rows":16,"n_cols":4,"rows_kept":16,"cut":false,"hidden":true,"merged":[[0,1,2,4]]}
[null,"Costing Tool 2"]
[]
[]
[null,null,"Projected cost:",{"$f":"SUM(D13*(1+D15))","v":{"$error":"#REF!"}}]
[]
[]
[]
[]
[null,null,"Local Authority:","Shetland Islands"]
[]
[null,null,"2020 homeless applications (HL1 returns):",{"$f":"VLOOKUP(D9,#REF!, 2, FALSE)","v":{"$error":"#REF!"}}]
[null,null,"Average cost per homeless application (2018 to 2020):",{"$f":"VLOOKUP(D9,#REF!, 3, FALSE)","v":{"$error":"#REF!"}}]
[null,null,"Housing and homelessness outturn expenditure 2020/21",{"$f":"VLOOKUP(D9,#REF!, 4, FALSE)","v":{"$error":"#REF!"}}]
[]
[null,null,"Please choose budget adjustment:",0]
[null,null,"based on incresea or decrease in demand"]

{"sheet":"1. Budget Calculator","index":3,"n_rows":28,"n_cols":11,"rows_kept":28,"cut":false,"hidden":false,"merged":[[23,7,28,11],[19,8,20,8],[4,1,4,2],[5,1,5,2],[6,1,6,2],[9,1,10,1],[9,2,9,4],[9,5,10,5],[19,3,20,3],[19,1,20,1],[10,2,10,3],[19,2,20,2]]}
[]
[null,"INPUTS for Budget adjustments",null,null,null,null,null,null,"Budget estimation"]
[null,null,null,null,null,null,null,null,null,"Step 4: Sensitivity"]
[null,"Step 1: Select location",null,null,null,null,null,null,{"$f":"IF(ISBLANK($D$5), \"\", $D$5)","v":""}]
[null,"Local authority"]
[null,"Average annual cost per homeless assessments (2018/19-2020/21)",null,{"$f":"IF(ISBLANK($D$5), \"\",VLOOKUP($D$5,'3. Current budget data'!$B$10:$S$51,17, FALSE))","v":""},null,null,null,null,"Estimated new budget by model (£) \n2018/19-2020/21","Sensitivity range"]
[null,"Average annual homeless assessments (numbers) (2018/19-2020/21)",null,{"$f":"IF(ISBLANK($D$5),\"\", VLOOKUP($D$5,'3. Current budget data'!$B$10:$T$51,18, FALSE))","v":""},null,null,null,null,{"$f":"IF(ISBLANK($D$5),\"\",SUM(($F$12*$D$22)+($F$13*$D$23)+($F$14*$D$24)+($F$15*$D$25)+($F$16*$D$26)+($F$17*$D$27)))","v":""},{"$f":"IF(SUM($I$7)=0,$I$7,_xlfn.CONCAT(TEXT(((-$J$4)+1)*$I$7,\"£#,###\"),\" - \",TEXT(($J$4+1)*$I$7,\"£#,###\")))","v":""}]
[]
[null,"Step 2: Select or input unit costs",null,null,null,null,null,null,"Unit cost comparison"]
[null,"Service type","Annual Unit Costs (£)\n(see 2. Modelling data inputs for details)",null,null,"Annual Unit Costs used in model (£)",null,null,"Average POBE costs (£)\n2018/19 - 2020/21","*Estimated* unit cost by model (£)\n2018/19 - 2020/21","Difference (£)"]
[null,null,"Drop down options",null,"Manual input",null,null,null,{"$f":"IF(ISBLANK($D$5),\"\", $D$6)","v":""},{"$f":"IF(SUM($D$7)=0,\"\",$I$7/$D$7)","v":""},{"$f":"SUM($I$11)-SUM($J$11)","v":0}]
[null,"Housing First",null,{"$f":"IF(ISBLANK($C$12),0, VLOOKUP($B$12,'2. Modelling data inputs'!$B$13:$E$18,IF($C$12=\"Support cost\", \"2\", IF($C$12=\"Support cost plus SRS rent \",\"3\", IF($C$12=\"Support cost plus PRS rent \",\"4\", \"\"))),FALSE))","v":0},null,{"$f":"IF($E$12>0,$E$12,IF($D$12>0,$D$12,$D$6))","v":""}]
[null,"Hostel",null,{"$f":"IF(ISBLANK($C$13),0, VLOOKUP($B$13,'2. Modelling data inputs'!$B$13:$E$18,IF($C$13=\"Support cost\", \"2\", IF($C$13=\"Support cost plus SRS rent \",\"3\", IF($C$13=\"Support cost plus PRS rent \",\"4\", \"\"))),FALSE))","v":0},null,{"$f":"IF($E$13>0,$E$13,IF($D$13>0,$D$13,$D$6))","v":""},null,null,"Budget comparison"]
[null,"High Intensity Supported Accommodation ",null,{"$f":"IF(ISBLANK($C$14),0, VLOOKUP($B$14,'2. Modelling data inputs'!$B$13:$E$18,IF($C$14=\"Support cost\", \"2\", IF($C$14=\"Support cost plus SRS rent \",\"3\", IF($C$14=\"Support cost plus PRS rent \",\"4\", \"\"))),FALSE))","v":0},null,{"$f":"IF($E$14>0,$E$14,IF($D$14>0,$D$14,$D$6))","v":""},null,null,"Average POBE expenditure (£)\n2018/19-2020/21","Estimated new budget range by model (£)  2018/19-2020/21","Difference (£)"]
[null,"Low Intensity Accommodation Based Support",null,{"$f":"IF(ISBLANK($C$15),0, VLOOKUP($B$15,'2. Modelling data inputs'!$B$13:$E$18,IF($C$15=\"Support cost\", \"2\", IF($C$15=\"Support cost plus SRS rent \",\"3\", IF($C$15=\"Support cost plus PRS rent \",\"4\", \"\"))),FALSE))","v":0},null,{"$f":"IF($E$15>0,$E$15,IF($D$15>0,$D$15,$D$6))","v":""},null,null,{"$f":"IF(ISBLANK($D$5),\"\",SUM($D$6*$D$7))","v":""},{"$f":"$J$7","v":""},{"$f":"SUM($I$7)-SUM($I$15)","v":0}]
[null,"Floating Support",null,{"$f":"IF(ISBLANK($C$16),0, VLOOKUP($B$16,'2. Modelling data inputs'!$B$13:$E$18,IF($C$16=\"Support cost\", \"2\", IF($C$16=\"Support cost plus SRS rent \",\"3\", IF($C$16=\"Support cost plus PRS rent \",\"4\", \"\"))),FALSE))","v":0},null,{"$f":"IF($E$16>0,$E$16,IF(ISNUMBER($D$16),$D$16,$D$6))","v":0}]
[null,"Other or unspecified",null,{"$f":"$D$6","v":""},null,{"$f":"IF($E$17=0,$D$17,$E$17)","v":""},null,null,"Budget forecast","Estimated budget (2021/22) (£)","Estimated budget (2022/23) (£)"]
[null,null,null,null,null,null,null,null,"Adjusted for annual inflation of 2%",{"$f":"IF(SUM($I$7)=0,$J$7,_xlfn.CONCAT(TEXT(((-$J$4)+1)*$I$7*(0.02+1)*(IF(ISNUMBER($J$20),$J$20,0)+1),\"£#,###\"),\" - \",TEXT(($J$4+1)*$I$7*(0.02+1)*(IF(ISNUMBER($J$20),$J$20,0)+1),\"£#,###\")))","v":""},{"$f":"IF(SUM($I$7)=0,$I$7,_xlfn.CONCAT(TEXT(((-$J$4)+1)*$I$7*(0.02+1)*(0.02+1)*(IF(ISNUMBER($J$20),$J$20,0)+1)*(IF(ISNUMBER($K$20),$K$20,0)+1),\"£#,###\"),\" - \",TEXT(($J$4+1)*$I$7*(0.02+1)*(0.02+1)*(IF(ISNUMBER($J$20),$J$20,0)+1)*(IF(ISNUMBER($K$20),$K$20,0)+1),\"£#,###\")))","v":""}]
[null,"Step 3: Input users by service type"]
[null,"Service type","Estimated % of \npeople in each service","Estimated number of people annually in each service",null,null,null,null,"Step 5: Expected annual change in demand"]
[]
[null,"Housing First",null,{"$f":"IF(ISBLANK($D$5), \"\", $D$7*$C$22)","v":""}]
[null,"Hostel",null,{"$f":"IF(ISBLANK($D$5), \"\", $D$7*$C$23)","v":""}]
[null,"High Intensity Supported Accommodation ",null,{"$f":"IF(ISBLANK($D$5), \"\", $D$7*$C$24)","v":""},null,null,null,"Caveats for budget estimation: \n\n1. Based on ringfencing of POBE budget which is not the case. New budget estimates, and therefore the difference in budgets is likely to be an underestimate.\n2. Service costs are based on the best available data for service types based on data from and English study. The use of these figures seeks to demonstrates the differences in the cost of support services and the impact this will have on the budget\n3. Inflation is adjusted for in the annual service unit costs and for the budget projections\n4. The sensitivity analysis can be used to allow for any margins of error and is recommended for use in developing a new budget estimate"]
[null,"Low Intensity Accommodation Based Support",null,{"$f":"IF(ISBLANK($D$5), \"\", $D$7*$C$25)","v":""}]
[null,"Floating Support",null,{"$f":"IF(ISBLANK($D$5), \"\", $D$7*$C$26)","v":""}]
[null,"Other or unspecified",{"$f":"100%-SUM($C$22:$C$26)","v":1},{"$f":"IF(ISBLANK($D$5), \"\", $D$7*$C$27)","v":""}]
[null,null,{"$f":"SUM($C$22:$C$27)","v":1},{"$f":"SUM($D$22:$D$27)","v":0}]

{"sheet":"2. Modelling data inputs","index":4,"n_rows":18,"n_cols":8,"rows_kept":18,"cut":false,"hidden":false,"merged":[[1,1,2,7],[5,6,5,7],[6,6,6,7],[7,6,7,7],[11,1,11,7],[4,1,4,7],[5,2,5,4],[6,2,6,4],[7,2,7,4],[8,2,8,4],[9,2,9,4],[8,6,8,7],[9,6,9,7]]}
[]
[null,"The data for modelling and budget estimation"]
[]
[]
[null,"Scottish Local Authority Unit Costs"]
[null,null,"Calculation",null,null,"Data Source","Data Source Link"]
[null,"2018/19","Total number of homeless applications (HL1 returns) across Scotland in 2018/19",null,null,"Scottish Government: Homelessness in Scotland: 2019 to 2020 (Tables (August 2020))","https://www.gov.scot/publications/homelessness-scotland-2019-2020/"]
[null,"2019/20","Total number of homeless applications (HL1 returns) across Scotland in 2019/20",null,null,"Scottish Government: Homelessness in Scotland: 2019 to 2020 (Tables (August 2020))","https://www.gov.scot/publications/homelessness-scotland-2019-2020/"]
[null,"2020/21","Total number of homeless applications (HL1 returns) across Scotland in 2020/21",null,null,"Scottish Government - Grant Aided Expenditure (Green Book 2020-21) ","https://www.gov.scot/binaries/content/documents/govscot/publications/statistics/2019/03/grant-aided-expenditure/documents/2020-21/green-book-2020-21/green-book-2020-21/govscot%3Adocument/Green%2BBook%2B2020-21.pdf"]
[null,"Overall Unit Cost","Average annual unit cost of homelessness support and services per individual. Estimated by taking an average across all 32 Scottish Local Authorities (excluding Inverclyde as an outlier) and averaged across the last three years (2018, 2019, 2020)",null,null,"Scottish Government - Local government 2019-2020 provisional outturn and 2020-2021 budget estimates – revenue (Provisional Outturn and Budget Estimates (POBE) Workbook 2020; Local government revenue expenditure and financing 2018-2019: provisional outturn and budget estimates (POBE 2019: publication workbook)","https://www.gov.scot/publications/local-government-2019-20-provisional-outturn-2020-21-budget-estimates-revenue/; https://www.gov.scot/publications/local-government-revenue-expenditure-financing-2018-19-provisional-outturn-2019-20-budget-estimates/pages/4/"]
[]
[null,"Element approach - unit costs for different services"]
[null,"Service type ","Support cost","Support cost plus SRS rent ","Support cost plus PRS rent ","Data Source","Data Source Link ","Adjustments Made"]
[null,"Housing First",4296,9878,9592,"Homeless Link, March 2019, The cost effectiveness of Housing First in England ","https://hfe.homeless.org.uk/sites/default/files/attachments/The%20cost%20effectiveness%20of%20Housing%20First%20in%20England_March%202019_0.pdf","Support cost adjusted for inflation to October 2020; SRS/PRS rent adjusted for inflation to October 2020"]
[null,"Hostel",12878,18460,18174,"Homeless Link, March 2019, The cost effectiveness of Housing First in England ","https://hfe.homeless.org.uk/sites/default/files/attachments/The%20cost%20effectiveness%20of%20Housing%20First%20in%20England_March%202019_0.pdf","Support cost adjusted for inflation to October 2020; SRS/PRS rent adjusted for inflation to October 2020"]
[null,"High intensity supported accommodation ",18885,24467,24181,"Homeless Link, March 2019, The cost effectiveness of Housing First in England ","https://hfe.homeless.org.uk/sites/default/files/attachments/The%20cost%20effectiveness%20of%20Housing%20First%20in%20England_March%202019_0.pdf","Support cost adjusted for inflation to October 2020; SRS/PRS rent adjusted for inflation to October 2020"]
[null,"Low Intensity Accommodation Based Support",6578,12160,11874,"Crisis, July 2015, At what cost?\nAn estimation of the financial costs of single homelessness in the UK","https://www.crisis.org.uk/media/20677/crisis_at_what_cost_2015.pdf","Weekly support cost adjusted to yearly; cost adjusted for inflation to October 2020; SRS/PRS rent adjusted for inflation to October 2020"]
[null,"Floating support",3046,"N/A","N/A","Crisis, July 2015, At what cost?\nAn estimation of the financial costs of single homelessness in the UK","https://www.crisis.org.uk/media/20677/crisis_at_what_cost_2015.pdf","Weekly support cost adjusted to yearly; cost adjusted for inflation to October 2020; SRS/PRS rent adjusted for inflation to October 2020"]

{"sheet":"3. Current budget data","index":5,"n_rows":51,"n_cols":26,"rows_kept":51,"cut":false,"hidden":false,"merged":[[1,1,2,20],[8,17,8,18],[8,12,8,16],[4,1,5,10],[6,1,6,2],[6,3,6,4],[8,2,8,6],[8,7,8,11]]}
[]
[null,"The data behind current budget estimations"]
[]
[]
[null,"The model uses information from the Scottish Government's Local Government Provisional Outturn and Budget Estimates (POBE) across the last three years (2018, 2019 and 2020), in conjunction with estimates of the total number of homeless applications (HL1 returns) taken from the Scottish Government's green book on Grant Aided expenditure"]
[]
[null,"https://www.gov.scot/publications/homelessness-scotland-2019-2020/",null,"https://www.gov.scot/binaries/content/documents/govscot/publications/statistics/2019/03/grant-aided-expenditure/documents/2020-21/green-book-2020-21/green-book-2020-21/govscot%3Adocument/Green%2BBook%2B2020-21.pdf"]
[]
[null,null,"2018/19",null,null,null,null,"2019/20",null,null,null,null,"2020/21"]
[null,"Local Authority","Housing Support Services (provisional outturn)","Homelessness (provisional outturn)","Total provisional outturn","Homeless/threatened with homelessness acceptances","Unit cost","Housing Support Services (provisional outturn)","Homelessness (provisional outturn)","Total provisional outturn","Homeless/threatened with homelessness acceptances","Unit cost","Housing Support Services (budget estimate)","Homelessness (budget estimate)","Total budget","Homeless acceptances 2016/2017 - 2018/2019","Unit cost","Average unit cost 2018/19-2020/21","Average acceptances 2018/19-2020/21","Regional Hub","Rural/Urban"]
[null,"Aberdeen City",3068000,2755000,{"$f":"SUM(C11:D11)","v":5823000},1305,{"$f":"SUM(E11/F11)","v":4462.0689655172409},2897000,1586000,{"$f":"SUM(H11:I11)","v":4483000},1245,{"$f":"SUM(J11/K11)","v":3600.8032128514055},2629000,2089000,{"$f":"SUM(M11:N11)","v":4718000},1304,{"$f":"SUM(O11/P11)","v":3618.0981595092026},{"$f":"AVERAGE(G11,L11,Q11)","v":3893.6567792926166},{"$f":"AVERAGE(F11,K11,P11)","v":1284.6666666666667},"North and Islands","Urban",null,null,null,"Urban",{"$f":"SUMIF($U$11:$U$42,$Y$11,$F$11:$F$42)","v":24010}]
[null,"Aberdeenshire",668000,3692000,4360000,970,{"$f":"SUM(E12/F12)","v":4494.8453608247419},584000,2612000,{"$f":"SUM(H12:I12)","v":3196000},1060,3015.0943396226417,1060000,3276000,{"$f":"SUM(M12:N12)","v":4336000},933,{"$f":"SUM(O12/P12)","v":4647.3740621650586},{"$f":"AVERAGE(G12,L12,Q12)","v":4052.4379208708137},{"$f":"AVERAGE(F12,K12,P12)","v":987.66666666666663},"North and Islands","Rural",null,null,null,"Rural",{"$f":"SUMIF($U$11:$U$42,$Y$12,$F$11:$F$42)","v":5890}]
[null,"Angus",1196000,1421000,2617000,590,4435.593220338983,1146000,1283000,2429000,500,4858,1253000,1307000,2560000,606,4224.4224422442248,4506.0052208610687,565.33333333333337,"Tayside, Fife and Central","Urban",null,null,null,null,{"$f":"SUM(Z11:Z12)","v":29900}]
[null,"Argyll & Bute",1055000,1583000,2638000,350,7537.1428571428569,1057000,1542000,2599000,340,7644.1176470588234,1058000,1556000,2614000,392,6668.3673469387759,7283.2092837134851,360.66666666666669,"Tayside, Fife and Central","Rural"]
[null,"Clackmannanshire",82000,-321000,-239000,470,-508.51063829787233,166000,-906000,-740000,425,-1741.1764705882354,266000,-393000,-127000,444,-286.03603603603602,-845.24104830738122,446.33333333333331,"Tayside, Fife and Central","Urban"]
[null,"Dumfries & Galloway",3857000,2133000,5990000,715,8377.6223776223778,3285000,2723000,6008000,730,8230.1369863013697,3366000,2644000,6010000,657,9147.6407914764077,8585.1333851333839,700.66666666666663,"Ayrshire and South","Rural"]
[null,"Dundee City",1481000,1882000,3363000,1020,3297.0588235294117,1404000,2965000,4369000,1020,4283.333333333333,1421000,2909000,4330000,995,4351.7587939698496,3977.3836502775316,1011.6666666666666,"Tayside, Fife and Central","Urban"]
[null,"East Ayrshire",6447000,988000,7435000,625,11896,6514000,891000,7405000,720,10284.722222222223,6514000,1181000,7695000,529,14546.313799621928,12242.345340614716,624.66666666666663,"Ayrshire and South","Urban"]
[null,"East Dunbartonshire",75000,976000,1051000,315,3336.5079365079364,71000,1248000,1319000,350,3768.5714285714284,71000,830000,901000,353,2552.4079320113315,3219.1624323635656,339.33333333333331,"West","Urban"]
[null,"East Lothian",865000,1666000,2531000,660,3834.848484848485,870000,1796000,2666000,635,4198.4251968503941,897000,1886000,2783000,657,4235.9208523592088,4089.7315113526961,650.66666666666663,"Edinburgh, Lothians and Borders","Rural"]
[null,"East Renfrewshire",0,1099000,1099000,270,4070.3703703703704,0,1248000,1248000,305,4091.8032786885246,0,1239000,1239000,270,4588.8888888888887,4250.3541793159284,281.66666666666669,"West","Urban"]
[null,"Edinburgh (City of)",13882000,18213000,32095000,3075,10437.39837398374,13196000,18398000,31594000,3355,9416.9895678092398,15330000,20216000,35546000,3182,11170.961659333752,10341.783200375578,3204,"Edinburgh, Lothians and Borders","Urban"]
[null,"Eilean Siar",852000,608000,1460000,115,12695.652173913044,1130000,489000,1619000,120,13491.666666666666,1026000,523000,1549000,108,14342.592592592593,13509.9704777241,114.33333333333333,"North and Islands","Rural"]
[null,"Falkirk",1371000,1221000,2592000,815,3180.3680981595094,1118000,1144000,2262000,970,2331.9587628865979,1133000,1312000,2445000,866,2823.3256351039263,2778.5508320500107,883.66666666666663,"Edinburgh, Lothians and Borders","Urban"]
[null,"Fife",1354000,6462000,7816000,2065,3784.9878934624699,1361000,5345000,6706000,2105,3185.7482185273161,1465000,5565000,7030000,1992,3529.1164658634539,3499.9508592844136,2054,"Tayside, Fife and Central","Urban"]
[null,"Glasgow City",17929000,33888000,51817000,4660,11119.527896995709,1725000,44502000,46227000,5260,8788.403041825095,1462000,44745000,46207000,4415,10465.911664779162,10124.614201199989,4778.333333333333,"West","Urban"]
[null,"Highland",1544000,1974000,3518000,1090,3227.5229357798166,1450000,2180000,3630000,1130,3212.3893805309735,1544000,2171000,3715000,1067,3481.7244611059045,3307.2122591388984,1095.6666666666667,"North and Islands","Rural"]
[null,"Inverclyde",4599000,787000,5386000,140,38471.428571428572,4530000,1001000,5531000,170,32535.294117647059,4540000,986000,5526000,166,33289.156626506025,34765.293105193887,158.66666666666666,"Ayrshire and South","Urban"]
[null,"Midlothian",6109000,1577000,7686000,465,16529.032258064515,5185000,995000,6180000,450,13733.333333333334,5935000,776000,6711000,491,13668.024439918534,14643.463343772128,468.66666666666669,"Edinburgh, Lothians and Borders","Urban"]
[null,"Moray",5633000,1142000,6775000,380,17828.947368421053,5807000,956000,6763000,385,17566.233766233767,6165000,1049000,7214000,371,19444.743935309973,18279.9750233216,378.66666666666669,"North and Islands","Rural"]
[null,"North Ayrshire",6443000,-114000,6329000,785,8062.4203821656047,5875000,297000,6172000,925,6672.4324324324325,5897000,587000,6484000,762,8509.1863517060374,7748.0130554346915,824,"Ayrshire and South","Urban"]
[null,"North Lanarkshire",1995000,1571000,3566000,2010,1774.1293532338309,1552000,2042000,3594000,1775,2024.7887323943662,1801000,1981000,3782000,1774,2131.9052987598648,1976.9411281293542,1853,"West","Urban"]
[null,"Orkney Islands",0,765000,765000,105,7285.7142857142853,0,716000,716000,90,7955.5555555555557,0,826000,826000,100,8260,7833.7566137566137,98.333333333333329,"North and Islands","Rural"]
[null,"Perth & Kinross",2279000,2206000,4485000,800,5606.25,2461000,2399000,4860000,640,7593.75,2368000,1990000,4358000,779,5594.3517329910137,6264.7839109970046,739.66666666666663,"Tayside, Fife and Central","Rural"]
[null,"Renfrewshire",1358000,2171000,3529000,705,5005.6737588652486,1315000,2537000,3852000,730,5276.7123287671229,1312000,2551000,3863000,670,5765.6716417910447,5349.3525764744718,701.66666666666663,"West","Urban"]
[null,"Scottish Borders",2000,1812000,1814000,610,2973.7704918032787,2000,1756000,1758000,640,2746.875,2000,2227000,2229000,593,3758.8532883642497,3159.8329267225095,614.33333333333337,"Edinburgh, Lothians and Borders","Rural"]
[null,"Shetland Islands",512000,378000,890000,95,9368.4210526315783,521000,499000,1020000,90,11333.333333333334,561000,479000,1040000,99,10505.050505050505,10402.268297005139,94.666666666666671,"North and Islands","Rural"]
[null,"South Ayrshire",1903000,1181000,3084000,630,4895.2380952380954,1302000,1817000,3119000,720,4331.9444444444443,1811000,1077000,2888000,628,4598.7261146496812,4608.6362181107406,659.33333333333337,"Ayrshire and South","Urban"]
[null,"South Lanarkshire",1831000,4627000,6458000,1570,4113.375796178344,1841000,6252000,8093000,1750,4624.5714285714284,1850000,6183000,8033000,1615,4973.9938080495358,4570.647010933103,1645,"West","Urban"]
[null,"Stirling",4890000,2328000,7218000,455,15863.736263736264,4637000,2372000,7009000,590,11879.661016949152,4817000,2356000,7173000,434,16527.649769585252,14757.015683423555,493,"Tayside, Fife and Central","Urban"]
[null,"West Dunbartonshire",4607000,524000,5131000,930,5517.2043010752686,4605000,866000,5471000,890,6147.1910112359546,4506000,559000,5065000,940,5388.2978723404258,5684.2310615505494,920,"West","Urban"]
[null,"West Lothian",1325000,4367000,5692000,1110,5127.9279279279281,1326000,4486000,5812000,1225,{"$f":"SUM(J42/K42)","v":4744.4897959183672},1174000,3920000,5094000,1149,4433.4203655352485,4768.6126964605146,1161.3333333333333,"Edinburgh, Lothians and Borders","Urban"]
[null,"TOTAL Scotland",{"$f":"SUM(C11:C42)","v":99212000},{"$f":"SUM(D11:D42)","v":105562000},{"$f":"SUM(E11:E42)","v":204774000},{"$f":"SUM(F11:F42)","v":29900},{"$f":"AVERAGE(G11:G42)","v":7753.1960949119602},{"$f":"SUM(H11:H42)","v":78933000},{"$f":"SUM(I11:I42)","v":118037000},{"$f":"SUM(J11:J42)","v":196970000},{"$f":"SUM(K11:K42)","v":31340},{"$f":"AVERAGE(L11:L42)","v":7244.598534686691},{"$f":"SUM(M11:M42)","v":83234000},{"$f":"SUM(N11:N42)","v":120603000},{"$f":"SUM(O11:O42)","v":203837000},{"$f":"SUM(P11:P42)","v":29341},{"$f":"AVERAGE(Q11:Q42)","v":7842.431914452658},{"$f":"AVERAGE(R11:R42)","v":7613.4088480171022},{"$f":"SUM(S11:S42)","v":30193.666666666672}]
[null,"AVERAGE Urban",{"$f":"SUMIF($U$11:$U$42,\"Urban\",C$11:C$42)","v":81945000},{"$f":"SUMIF($U$11:$U$42,\"Urban\",D$11:D$42)","v":87603000},{"$f":"SUMIF($U$11:$U$42,\"Urban\",E$11:E$42)","v":169548000},{"$f":"SUMIF($U$11:$U$42,\"Urban\",F$11:F$42)","v":24010},{"$f":"AVERAGEIF($U$11:$U$42,\"Urban\",G$11:G$42)","v":7851.0256023086285},{"$f":"SUMIF($U$11:$U$42,\"Urban\",H$11:H$42)","v":61766000},{"$f":"SUMIF($U$11:$U$42,\"Urban\",I$11:I$42)","v":100369000},{"$f":"SUMIF($U$11:$U$42,\"Urban\",J$11:J$42)","v":162135000},{"$f":"SUMIF($U$11:$U$42,\"Urban\",K$11:K$42)","v":25480},{"$f":"AVERAGEIF($U$11:$U$42,\"Urban\",L$11:L$42)","v":6897.1226303724106},{"$f":"SUMIF($U$11:$U$42,\"Urban\",M$11:M$42)","v":65187000},{"$f":"SUMIF($U$11:$U$42,\"Urban\",N$11:N$42)","v":101976000},{"$f":"SUMIF($U$11:$U$42,\"Urban\",O$11:O$42)","v":167163000},{"$f":"SUMIF($U$11:$U$42,\"Urban\",P$11:P$42)","v":23585},{"$f":"AVERAGEIF($U$11:$U$42,\"Urban\",Q$11:Q$42)","v":7660.5334140062541},{"$f":"AVERAGEIF($U$11:$U$42,\"Urban\",R$11:R$42)","v":7469.5605488957635},{"$f":"AVERAGEIF($U$11:$U$42,\"Urban\",S$11:S$42)","v":1159.9206349206349}]
[null,"AVERAGE Rural",{"$f":"SUMIF($U$11:$U$42,\"Rural\",C$11:C$42)","v":17267000},{"$f":"SUMIF($U$11:$U$42,\"Rural\",D$11:D$42)","v":17959000},{"$f":"SUMIF($U$11:$U$42,\"Rural\",E$11:E$42)","v":35226000},{"$f":"SUMIF($U$11:$U$42,\"Rural\",F$11:F$42)","v":5890},{"$f":"AVERAGEIF($U$11:$U$42,\"Rural\",G$11:G$42)","v":7566.4306717001373},{"$f":"SUMIF($U$11:$U$42,\"Rural\",H$11:H$42)","v":17167000},{"$f":"SUMIF($U$11:$U$42,\"Rural\",I$11:I$42)","v":17668000},{"$f":"SUMIF($U$11:$U$42,\"Rural\",J$11:J$42)","v":34835000},{"$f":"SUMIF($U$11:$U$42,\"Rural\",K$11:K$42)","v":5860},{"$f":"AVERAGEIF($U$11:$U$42,\"Rural\",L$11:L$42)","v":7907.9616247412287},{"$f":"SUMIF($U$11:$U$42,\"Rural\",M$11:M$42)","v":18047000},{"$f":"SUMIF($U$11:$U$42,\"Rural\",N$11:N$42)","v":18627000},{"$f":"SUMIF($U$11:$U$42,\"Rural\",O$11:O$42)","v":36674000},{"$f":"SUMIF($U$11:$U$42,\"Rural\",P$11:P$42)","v":5756},{"$f":"AVERAGEIF($U$11:$U$42,\"Rural\",Q$11:Q$42)","v":8189.6926880321525},{"$f":"AVERAGEIF($U$11:$U$42,\"Rural\",R$11:R$42)","v":7888.0283281578413},{"$f":"AVERAGEIF($U$11:$U$42,\"Rural\",S$11:S$42)","v":530.4848484848485}]
[null,"AVERAGE North and Islands",{"$f":"SUMIF($T$11:$T$42,\"North and Islands\",C$11:C$42)","v":12277000},{"$f":"SUMIF($T$11:$T$42,\"North and Islands\",D$11:D$42)","v":11314000},{"$f":"SUMIF($T$11:$T$42,\"North and Islands\",E$11:E$42)","v":23591000},{"$f":"SUMIF($T$11:$T$42,\"North and Islands\",F$11:F$42)","v":4060},{"$f":"AVERAGEIF($T$11:$T$42,\"North and Islands\",G$11:G$42)","v":8480.4531632573944},{"$f":"SUMIF($T$11:$T$42,\"North and Islands\",H$11:H$42)","v":12389000},{"$f":"SUMIF($T$11:$T$42,\"North and Islands\",I$11:I$42)","v":9038000},{"$f":"SUMIF($T$11:$T$42,\"North and Islands\",J$11:J$42)","v":21427000},{"$f":"SUMIF($T$11:$T$42,\"North and Islands\",K$11:K$42)","v":4120},{"$f":"AVERAGEIF($T$11:$T$42,\"North and Islands\",L$11:L$42)","v":8596.439464970621},{"$f":"SUMIF($T$11:$T$42,\"North and Islands\",M$11:M$42)","v":12985000},{"$f":"SUMIF($T$11:$T$42,\"North and Islands\",N$11:N$42)","v":10413000},{"$f":"SUMIF($T$11:$T$42,\"North and Islands\",O$11:O$42)","v":23398000},{"$f":"SUMIF($T$11:$T$42,\"North and Islands\",P$11:P$42)","v":3982},{"$f":"AVERAGEIF($T$11:$T$42,\"North and Islands\",Q$11:Q$42)","v":9185.6548165333188},{"$f":"AVERAGEIF($T$11:$T$42,\"North and Islands\",R$11:R$42)","v":8754.1824815871114},{"$f":"AVERAGEIF($T$11:$T$42,\"North and Islands\",S$11:S$42)","v":579.14285714285722}]
[null,"AVERAGE Tayside, Fife and Central",{"$f":"SUMIF($T$11:$T$42,\"Tayside, Fife and Central\",C$11:C$42)","v":12337000},{"$f":"SUMIF($T$11:$T$42,\"Tayside, Fife and Central\",D$11:D$42)","v":15561000},{"$f":"SUMIF($T$11:$T$42,\"Tayside, Fife and Central\",E$11:E$42)","v":27898000},{"$f":"SUMIF($T$11:$T$42,\"Tayside, Fife and Central\",F$11:F$42)","v":5750},{"$f":"AVERAGEIF($T$11:$T$42,\"Tayside, Fife and Central\",G$11:G$42)","v":5716.6083457017303},{"$f":"SUMIF($T$11:$T$42,\"Tayside, Fife and Central\",H$11:H$42)","v":12232000},{"$f":"SUMIF($T$11:$T$42,\"Tayside, Fife and Central\",I$11:I$42)","v":15000000},{"$f":"SUMIF($T$11:$T$42,\"Tayside, Fife and Central\",J$11:J$42)","v":27232000},{"$f":"SUMIF($T$11:$T$42,\"Tayside, Fife and Central\",K$11:K$42)","v":5620},{"$f":"AVERAGEIF($T$11:$T$42,\"Tayside, Fife and Central\",L$11:L$42)","v":5386.2048207543412},{"$f":"SUMIF($T$11:$T$42,\"Tayside, Fife and Central\",M$11:M$42)","v":12648000},{"$f":"SUMIF($T$11:$T$42,\"Tayside, Fife and Central\",N$11:N$42)","v":15290000},{"$f":"SUMIF($T$11:$T$42,\"Tayside, Fife and Central\",O$11:O$42)","v":27938000},{"$f":"SUMIF($T$11:$T$42,\"Tayside, Fife and Central\",P$11:P$42)","v":5642},{"$f":"AVERAGEIF($T$11:$T$42,\"Tayside, Fife and Central\",Q$11:Q$42)","v":5801.3757879366476},{"$f":"AVERAGEIF($T$11:$T$42,\"Tayside, Fife and Central\",R$11:R$42)","v":5634.7296514642394},{"$f":"AVERAGEIF($T$11:$T$42,\"Tayside, Fife and Central\",S$11:S$42)","v":810.09523809523819}]
[null,"AVERAGE Ayrshire and South",{"$f":"SUMIF($T$11:$T$42,\"Ayrshire and South\",C$11:C$42)","v":23249000},{"$f":"SUMIF($T$11:$T$42,\"Ayrshire and South\",D$11:D$42)","v":4975000},{"$f":"SUMIF($T$11:$T$42,\"Ayrshire and South\",E$11:E$42)","v":28224000},{"$f":"SUMIF($T$11:$T$42,\"Ayrshire and South\",F$11:F$42)","v":2895},{"$f":"AVERAGEIF($T$11:$T$42,\"Ayrshire and South\",G$11:G$42)","v":14340.54188529093},{"$f":"SUMIF($T$11:$T$42,\"Ayrshire and South\",H$11:H$42)","v":21506000},{"$f":"SUMIF($T$11:$T$42,\"Ayrshire and South\",I$11:I$42)","v":6729000},{"$f":"SUMIF($T$11:$T$42,\"Ayrshire and South\",J$11:J$42)","v":28235000},{"$f":"SUMIF($T$11:$T$42,\"Ayrshire and South\",K$11:K$42)","v":3265},{"$f":"AVERAGEIF($T$11:$T$42,\"Ayrshire and South\",L$11:L$42)","v":12410.906040609505},{"$f":"SUMIF($T$11:$T$42,\"Ayrshire and South\",M$11:M$42)","v":22128000},{"$f":"SUMIF($T$11:$T$42,\"Ayrshire and South\",N$11:N$42)","v":6475000},{"$f":"SUMIF($T$11:$T$42,\"Ayrshire and South\",O$11:O$42)","v":28603000},{"$f":"SUMIF($T$11:$T$42,\"Ayrshire and South\",P$11:P$42)","v":2742},{"$f":"AVERAGEIF($T$11:$T$42,\"Ayrshire and South\",Q$11:Q$42)","v":14018.204736792013},{"$f":"AVERAGEIF($T$11:$T$42,\"Ayrshire and South\",R$11:R$42)","v":13589.884220897486},{"$f":"AVERAGEIF($T$11:$T$42,\"Ayrshire and South\",S$11:S$42)","v":593.4666666666667}]
[null,"AVERAGE West",{"$f":"SUMIF($T$11:$T$42,\"West\",C$11:C$42)","v":27795000},{"$f":"SUMIF($T$11:$T$42,\"West\",D$11:D$42)","v":44856000},{"$f":"SUMIF($T$11:$T$42,\"West\",E$11:E$42)","v":72651000},{"$f":"SUMIF($T$11:$T$42,\"West\",F$11:F$42)","v":10460},{"$f":"AVERAGEIF($T$11:$T$42,\"West\",G$11:G$42)","v":4990.9699161752442},{"$f":"SUMIF($T$11:$T$42,\"West\",H$11:H$42)","v":11109000},{"$f":"SUMIF($T$11:$T$42,\"West\",I$11:I$42)","v":58695000},{"$f":"SUMIF($T$11:$T$42,\"West\",J$11:J$42)","v":69804000},{"$f":"SUMIF($T$11:$T$42,\"West\",K$11:K$42)","v":11060},{"$f":"AVERAGEIF($T$11:$T$42,\"West\",L$11:L$42)","v":4960.2916071505606},{"$f":"SUMIF($T$11:$T$42,\"West\",M$11:M$42)","v":11002000},{"$f":"SUMIF($T$11:$T$42,\"West\",N$11:N$42)","v":58088000},{"$f":"SUMIF($T$11:$T$42,\"West\",O$11:O$42)","v":69090000},{"$f":"SUMIF($T$11:$T$42,\"West\",P$11:P$42)","v":10037},{"$f":"AVERAGEIF($T$11:$T$42,\"West\",Q$11:Q$42)","v":5123.8681580886068},{"$f":"AVERAGEIF($T$11:$T$42,\"West\",R$11:R$42)","v":5025.0432271381378},{"$f":"AVERAGEIF($T$11:$T$42,\"West\",S$11:S$42)","v":1502.7142857142858}]
[null,"AVERAGE Edinburgh, Lothians and Borders",{"$f":"SUMIF($T$11:$T$42,\"Edinburgh, Lothians and Borders\",C$11:C$42)","v":23554000},{"$f":"SUMIF($T$11:$T$42,\"Edinburgh, Lothians and Borders\",D$11:D$42)","v":28856000},{"$f":"SUMIF($T$11:$T$42,\"Edinburgh, Lothians and Borders\",E$11:E$42)","v":52410000},{"$f":"SUMIF($T$11:$T$42,\"Edinburgh, Lothians and Borders\",F$11:F$42)","v":6735},{"$f":"AVERAGEIF($T$11:$T$42,\"Edinburgh, Lothians and Borders\",G$11:G$42)","v":7013.8909391312418},{"$f":"SUMIF($T$11:$T$42,\"Edinburgh, Lothians and Borders\",H$11:H$42)","v":21697000},{"$f":"SUMIF($T$11:$T$42,\"Edinburgh, Lothians and Borders\",I$11:I$42)","v":28575000},{"$f":"SUMIF($T$11:$T$42,\"Edinburgh, Lothians and Borders\",J$11:J$42)","v":50272000},{"$f":"SUMIF($T$11:$T$42,\"Edinburgh, Lothians and Borders\",K$11:K$42)","v":7275},{"$f":"AVERAGEIF($T$11:$T$42,\"Edinburgh, Lothians and Borders\",L$11:L$42)","v":6195.3452761329891},{"$f":"SUMIF($T$11:$T$42,\"Edinburgh, Lothians and Borders\",M$11:M$42)","v":24471000},{"$f":"SUMIF($T$11:$T$42,\"Edinburgh, Lothians and Borders\",N$11:N$42)","v":30337000},{"$f":"SUMIF($T$11:$T$42,\"Edinburgh, Lothians and Borders\",O$11:O$42)","v":54808000},{"$f":"SUMIF($T$11:$T$42,\"Edinburgh, Lothians and Borders\",P$11:P$42)","v":6938},{"$f":"AVERAGEIF($T$11:$T$42,\"Edinburgh, Lothians and Borders\",Q$11:Q$42)","v":6681.7510401024856},{"$f":"AVERAGEIF($T$11:$T$42,\"Edinburgh, Lothians and Borders\",R$11:R$42)","v":6630.32908512224},{"$f":"AVERAGEIF($T$11:$T$42,\"Edinburgh, Lothians and Borders\",S$11:S$42)","v":1163.7777777777776}]
[null,"TOTAL AVERAGE",null,null,null,null,{"$f":"SUM(G11:G42)/32","v":7753.1960949119602},null,null,null,null,{"$f":"SUM(L11:L42)/32","v":7244.598534686691},null,null,null,null,{"$f":"SUM(Q11:Q42)/32","v":7842.431914452658},{"$f":"SUM((Q51+L51))/2","v":7543.5152245696745}]

{"sheet":"Sensitivity data","index":6,"n_rows":27,"n_cols":2,"rows_kept":27,"cut":false,"hidden":true,"merged":[]}
[0,-1]
[0.01,-0.75]
[0.05,-0.500000000000001]
[0.1,-0.45000000000000101]
[0.15,-0.40000000000000102]
[0.2,-0.35000000000000098]
[0.25,-0.30000000000000099]
[0.3,-0.250000000000001]
[0.35,-0.20000000000000101]
[0.4,-0.15000000000000099]
[0.45,-0.100000000000001]
[0.5,-5.0000000000000898E-2]
[0.55000000000000004,-0.01]
[0.6,0]
[0.65,0.01]
[0.7,0.05]
[0.75,0.1]
[0.8,0.15]
[0.85,0.2]
[0.9,0.25]
[0.95,0.3]
[1,0.35]
[1.25,0.4]
[1.5,0.45]
[1.75,0.5]
[2,0.75]
[null,1]