{"text_format":"1","workbook":"xlsx","n_sheets":11,"sheets":["Contents","Table 1","Table 2","Table 3","Table 4","Chart 1","Chart 2","Table 5","Chart 3","Chart 4","Chart 5"],"not_rendered":{"charts":5,"images":0,"macros":1,"external_links":0,"defined_names":2,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Contents","index":0,"n_rows":15,"n_cols":2,"rows_kept":15,"cut":false,"hidden":false,"merged":[]}
["Discretionary Housing Payments in Scotland: As at 30 September 2020"]
[]
["Tables"]
["Table 1","Funding Allocation, 2020/21"]
["Table 2","Applications, Determinations, Awards and Total Award Value as at 30 September 2020"]
["Table 3","Actual or committed expenditure profile, 2020/21"]
["Table 4","Actual or committed expenditure compared to funding for 2020/21, as at 30 September 2020"]
["Table 5","Management Information - Funding and actual expenditure for 2020/21, as at 30 September 2020"]
[]
["Charts"]
["Chart 1","Actual or committed expenditure profile  - 2019/20 and 2020/21"]
["Chart 2","Proportion of estimated 2020/21 DHP funding spent as at 30 September 2020"]
["Chart 3","Management Information - Proportion of DHP actual spend by funding stream"]
["Chart 4","Management Information - Proportion of estimated 2020/21 DHP funding spent (actual) by funding stream"]
["Chart 5","Management Information - DHP actual funding spent by each Local Authority broken down by funding stream"]

{"sheet":"Table 1","index":1,"n_rows":43,"n_cols":8,"rows_kept":43,"cut":false,"hidden":false,"merged":[[42,0,42,7],[40,0,40,7],[2,1,2,4],[2,7,3,7],[2,6,3,6],[2,5,3,5],[38,0,38,7]]}
["Table 1: Funding Allocation for 2020-21 "]
[]
[null,"Funding announced to date",null,null,null,"Tranche 2 Bedroom Tax mitigation3","Total estimated funding to fully mitigate RSRS (Tranche 1 and 2 bedroom tax mitigation)4","Total estimated DHP funding5"]
["Local Authority","Tranche 1 Bedroom Tax mitigation1","Other DHPs2","£5 million allocation to Other DHPs2","Total"]
["Aberdeen City",1422035,429164,189754,2040953,355509,1777544,2396462]
["Aberdeenshire",814741,285746,139981,1240468,203685,1018426,1444153]
["Angus",494076,154992,81009,730077,123519,617595,853596]
["Argyll and Bute",563750,79431,40694,683875,140938,704688,824813]
["Clackmannanshire",737972,155381,66593,959946,184493,922465,1144439]
["Dumfries and Galloway",1093606,225232,111722,1430560,273401,1367007,1703961]
["Dundee City",1776121,454354,212585,2443060,444030,2220151,2887090]
["East Ayrshire",1611593,215895,105438,1932926,402898,2014491,2335824]
["East Dunbartonshire",408611,118328,54080,581019,102153,510764,683172]
["East Lothian",532993,167833,87484,788310,133248,666241,921558]
["East Renfrewshire",288693,87519,40698,416910,72173,360866,489083]
["Edinburgh, City of",3661437,2275685,959805,6896927,915359,4576796,7812286]
["Eilean Siar",144283,9634,8140,162057,36071,180354,198128]
["Falkirk",1514737,182151,84015,1780903,378684,1893421,2159587]
["Fife",3742907,672421,310592,4725920,935727,4678634,5661647]
["Glasgow City",8717499,1840286,855042,11412827,2179375,10896874,13592202]
["Highland",1570617,285278,135488,1991383,392654,1963271,2384037]
["Inverclyde",934533,155777,71918,1162228,233633,1168166,1395861]
["Midlothian",801571,190360,94461,1086392,200393,1001964,1286785]
["Moray",385154,64410,34876,484440,96288,481442,580728]
["North Ayrshire",1961221,378512,179675,2519408,490305,2451526,3009713]
["North Lanarkshire",3470244,619807,278570,4368621,867561,4337805,5236182]
["Orkney Islands",93068,13361,8152,114581,23267,116335,137848]
["Perth and Kinross",504075,139462,65780,709317,126019,630094,835336]
["Renfrewshire",1762348,236243,115418,2114009,440587,2202935,2554596]
["Scottish Borders",702254,180177,73546,955977,175564,877818,1131541]
["Shetland Islands",134367,20299,9693,164359,33592,167959,197951]
["South Ayrshire",1068466,196508,95543,1360517,267117,1335583,1627634]
["South Lanarkshire",2602154,410145,188761,3201060,650538,3252692,3851598]
["Stirling",554348,63736,28854,646938,138587,692935,785525]
["West Dunbartonshire",1849232,275427,125228,2249887,462308,2311540,2712195]
["West Lothian",1876682,316445,146405,2339532,469170,2345852,2808702]
["Scotland",47795390,10900000,5000000,63695390,11948847,59744237,75644237]
[]
["1. This represents 80% of the estimated spend on the bedroom tax. A second tranche of funding will follow and reimburse local authorities for their spending over and above tranche 1 funding in mitigating the bedroom tax"]
["2. This includes Core funding, Local Housing Allowance and Benefit Cap funding"]
["3. Estimated additional funding to fully mitigate the bedroom tax. "]
["4. RSRS = Removal of the spare room subsidy"]
["5. Estimated total funding is based on the estimate to fully mitigate the bedroom tax and a further estimate for other DHPs.  The final allocation from the SG will be known following the publication of DHP statistics in May 2021 to reimburse local authorities against actual DHP expenditure to mitigate against RSRS losses."]

{"sheet":"Table 2","index":2,"n_rows":41,"n_cols":7,"rows_kept":41,"cut":false,"hidden":false,"merged":[[40,0,40,7],[38,0,38,6],[39,0,39,6]]}
["Table 2:  Applications, Determinations, Awards and Total Award Value from 1 April 2020 to 30 September 2020"]
[]
["Local Authority","Applications","Determinations","Awards","Award Rate3","Total award value spent/committed","Average award value"]
["Aberdeen City",2750,2575,2425,0.88,1866267,769]
["Aberdeenshire",2160,1935,1680,0.78,1114865,664]
["Angus",1255,1235,985,0.78,661297,673]
["Argyll and Bute",960,905,800,0.83000000000000007,794741,993]
["Clackmannanshire",1300,1300,1280,0.99,933026,729]
["Dumfries and Galloway",2835,2685,2655,0.94000000000000006,1556709,587]
["Dundee City",1065,4235,4130,3.89,2657420,643]
["East Ayrshire",3605,3585,3585,0.99,2236816,624]
["East Dunbartonshire",240,270,745,3.13,561813,752]
["East Lothian",1335,1330,1280,0.96,848198,662]
["East Renfrewshire1",85,85,500,5.7700000000000005,182486,364]
["Edinburgh, City of",6625,6125,5695,0.86,5040151,885]
["Eilean Siar",370,370,370,1,191710,518]
["Falkirk",3960,3825,3765,0.95000000000000007,2254307,599]
["Fife",12260,12260,12075,0.99,5499017,455]
["Glasgow City",2375,19370,19070,8.0299999999999994,12508237,656]
["Highland",7640,7525,7485,0.98,2270689,303]
["Inverclyde",1910,1865,1700,0.89,1299376,764]
["Midlothian",1415,1475,1420,1,1000239,705]
["Moray2",430,495,410,0.96,489020,0]
["North Ayrshire",3925,3925,3925,1,2415142,615]
["North Lanarkshire",8865,8405,8315,0.94000000000000006,4966316,597]
["Orkney Islands",135,135,135,0.99,95520,702]
["Perth and Kinross",1565,1550,1465,0.94000000000000006,610205,416]
["Renfrewshire",4165,3920,3885,0.93,2233368,575]
["Scottish Borders",1480,1395,1250,0.84,811297,650]
["Shetland Islands",270,270,270,1,177713,656]
["South Ayrshire",3010,2915,2650,0.88,1397983,528]
["South Lanarkshire",6380,6275,6180,0.97,3662584,593]
["Stirling",1125,1125,1100,0.98,541047,491]
["West Dunbartonshire",2895,2895,2890,1,2148413,743]
["West Lothian",4850,4815,4790,0.99,2961825,618]
["Scotland",93250,110995,108915,1.17,65987796,606]
[]
["Figures rounded to the nearest five applications/decisions/awards and the nearest pound of expenditure."]
["1. East Renfrewshire cannot provide data on number of decisions. This is because their system does not record determinations which are ‘unsuccessful’. The number of determinations has been assumed to be the same as the number of applications."]
["2. Applications, determination and awards for Moray are lower than previous years, which may be due to a change in their reporting system. These values may not include applications extended from previous years or determinations where an award has not been made. Expenditure figures have been unaffected, but average award value may not be accurate."]
["3. A number of local authorities have fewer applications than decisions and awards because they have systems and processes set up so that a single application can have multiple decisions and awards made. This typically reflects RSRS cases where awards have been extended from the previous year, but for which no new applications have been required by the Local Authority. These figures have not been amended (as done in previous publications) to show a higher application than decision and award rate. Additionally, some decisions may have been taken on applications received prior to 1 April 2020."]

{"sheet":"Table 3","index":3,"n_rows":41,"n_cols":7,"rows_kept":41,"cut":false,"hidden":false,"merged":[[2,1,2,6],[2,10,2,12],[2,0,3,0],[40,0,40,6],[39,0,39,6]]}
["Table 3: Actual or committed expenditure profile 1 April 2020 to 30 September 2020"]
[]
["Local Authority",2020]
[null,"April","May ","June","July","August","September"]
["Aberdeen City",1050811,1396384,1624085,1747807,1818940,1866267]
["Aberdeenshire",666744,963257,1024719,1065162,1099198,1114865]
["Angus",547114,598794,620243,638713,650297,661297]
["Argyll and Bute",662166,689858,729565,759706,801363,794741]
["Clackmannanshire",851910,864913,879600,878688,912720,933026]
["Dumfries and Galloway",1003925,1357670,1455526,1488628,1525886,1556709]
["Dundee City",2110965,2275546,2421841,2505864,2574466,2657420]
["East Ayrshire",1993819,2085768,2171921,2239589,2285643,2236816]
["East Dunbartonshire",414879,476217,497063,534212,550394,561813]
["East Lothian",723092,769493,796961,819264,840181,848198]
["East Renfrewshire",27051,58358,88866,117896,150479,182486]
["Edinburgh, City of",3136048,3442564,3711557,4075312,4377577,5040151]
["Eilean Siar",175818,187407,187895,190720,190959,191710]
["Falkirk",58285,279453,1371286,2058119,2240605,2254307]
["Fife",4338678,4477333,4814423,5078677,5333330,5499017]
["Glasgow City",10449370,10863228,11497360,11920932,12402893,12508237]
["Highland",1970381,2132147,2175028,2215299,2263515,2270689]
["Inverclyde",424516,744304,1075778,1271118,1284887,1299376]
["Midlothian",901896,964608,977247,988614,988910,1000239]
["Moray",435681,416477,478056,499235,513962,489020]
["North Ayrshire",285718,1636893,2161005,2261083,2341925,2415142]
["North Lanarkshire",4090228,4418137,4540852,4739299,4844391,4966316]
["Orkney Islands",75693,85876,84980,91545,93701,95520]
["Perth and Kinross",489991,526176,546195,561831,574514,610205]
["Renfrewshire",1388418,1596131,1990139,2099141,2130863,2233368]
["Scottish Borders",454343,563868,665684,720024,776849,811297]
["Shetland Islands",140233,152990,167060,165078,169939,177713]
["South Ayrshire",1155814,1223663,1336637,1376826,1385269,1397983]
["South Lanarkshire",3234509,3307996,3450507,3553885,3593577,3662584]
["Stirling",242351,329305,403907,441629,511904,541047]
["West Dunbartonshire",1369594,1735863,2079748,2113715,2116751,2148413]
["West Lothian",2227487,2607627,2740952,2822713,2899989,2961825]
["Scotland",47097529,53228303,58766687,62040320,64245877,65987796]
[]
["Figures rounded to the nearest pound."]
["Actual or committed expenditure' is the amount that has either been spent on awards, or committed to be spent on awards by the end of the financial year, as at the end of each month. "]
["Whilst figures generally increase month on month in each LA area, some awards committed through to the end of 2020/21 may be cancelled, for example if a person moves house and no longer requires DHP assistance.  As a result, this can lead to small monthly reductions in the amount of DHP awards spent or committed in some LAs."]

{"sheet":"Table 4","index":4,"n_rows":41,"n_cols":10,"rows_kept":41,"cut":false,"hidden":false,"merged":[[0,0,0,9],[41,0,41,9],[40,0,40,7],[38,0,38,7]]}
["Table 4: Actual or committed expenditure compared to funding for 2020/21, as at 30 September 2020"]
[]
["Local authority","Funding announced to date1","Total estimated funding2","Total award value spent/committed (formal returns)","Expenditure above funding announced to date1","Expenditure below funding announced to date1","Expenditure above total estimated funding2","Total estimated funding remaining2",null,"% of total estimated funding spent/committed (formal returns)"]
["Aberdeen City",2040953,2396462,1866267,"",174686,"",530195,null,0.78]
["Aberdeenshire",1240468,1444153,1114865,"",125603,"",329288,null,0.77]
["Angus",730077,853596,661297,"",68780,"",192299,null,0.77]
["Argyll and Bute",683875,824813,794741,110866,"","",30072,null,0.96]
["Clackmannanshire",959946,1144439,933026,"",26920,"",211413,null,0.82000000000000006]
["Dumfries and Galloway",1430560,1703961,1556709,126149,"","",147252,null,0.91]
["Dundee City",2443060,2887090,2657420,214360,"","",229670,null,0.92]
["East Ayrshire",1932926,2335824,2236816,303890,"","",99008,null,0.96]
["East Dunbartonshire",581019,683172,561813,"",19206,"",121359,null,0.82000000000000006]
["East Lothian",788310,921558,848198,59888,"","",73360,null,0.92]
["East Renfrewshire",416910,489083,182486,"",234424,"",306597,null,0.37]
["Edinburgh, City of",6896927,7812286,5040151,"",1856776,"",2772135,null,0.65]
["Eilean Siar",162057,198128,191710,29653,"","",6418,null,0.97]
["Falkirk",1780903,2159587,2254307,473404,"",94720,"",null,1.04]
["Fife",4725920,5661647,5499017,773097,"","",162630,null,0.97]
["Glasgow City",11412827,13592202,12508237,1095410,"","",1083965,null,0.92]
["Highland",1991383,2384037,2270689,279306,"","",113348,null,0.95000000000000007]
["Inverclyde",1162228,1395861,1299376,137148,"","",96485,null,0.93]
["Midlothian",1086392,1286785,1000239,"",86153,"",286546,null,0.78]
["Moray",484440,580728,489020,4580,"","",91708,null,0.84]
["North Ayrshire",2519408,3009713,2415142,"",104266,"",594571,null,0.8]
["North Lanarkshire",4368621,5236182,4966316,597695,"","",269866,null,0.95000000000000007]
["Orkney Islands",114581,137848,95520,"",19061,"",42328,null,0.69000000000000006]
["Perth and Kinross",709317,835336,610205,"",99112,"",225131,null,0.73]
["Renfrewshire",2114009,2554596,2233368,119359,"","",321228,null,0.87]
["Scottish Borders",955977,1131541,811297,"",144680,"",320244,null,0.72]
["Shetland Islands",164359,197951,177713,13354,"","",20238,null,0.9]
["South Ayrshire",1360517,1627634,1397983,37466,"","",229651,null,0.86]
["South Lanarkshire",3201060,3851598,3662584,461524,"","",189014,null,0.95000000000000007]
["Stirling",646938,785525,541047,"",105891,"",244478,null,0.69000000000000006]
["West Dunbartonshire",2249887,2712195,2148413,"",101474,"",563782,null,0.79]
["West Lothian",2339532,2808702,2961825,622293,"",153123,"",null,1.05]
["Scotland",63695390,75644237,65987796,5459442,3167033,247842,9904279,null,0.87]
[]
["Figures rounded to the nearest pound."]
["Actual or committed expenditure' is the amount that has either been spent on awards, or committed to be spent on awards by the end of the financial year, as at the end of each month. "]
["1. Tranche 1 Bedroom Tax Mitigation plus 'Other DHPs' funding streams."]
["2. Estimated total funding is based on the estimate to fully mitigate the bedroom tax and a further estimate for other DHPs.  The final allocation from the SG will be known following the publication of DHP statistics in May 2019 to reimburse local authorities against actual DHP expenditure to mitigate against RSRS losses."]

{"sheet":"Chart 1","index":5,"n_rows":44,"n_cols":13,"rows_kept":44,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"April","May","June","July","August","September","October","November","December","January","February","March"]
["Actual Spent or Committed 2020/21",47.097528559999986,53.228303029999992,58.766686520000036,62.04032024,64.24587652999999,65.977896070000014]
["Actual Spent or Committed 2019/20",44.956295480000001,51.951601879999998,54.824110830000002,56.938732969999997,58.644848209999999,59.14533204,60.590643629999995,61.649328530000005,62.530142510000005,63.818050163333332,65.048769366666676,66.000611329999998]
["Estimated total for 2019/20",null,null,null,null,null,null,null,null,null,null,null,75.599999999999994]

{"sheet":"Chart 2","index":6,"n_rows":74,"n_cols":3,"rows_kept":74,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Local authority","% of Estimated Funding Spent or Committed","100% line"]
["East Renfrewshire",0.35000000000000003,1]
["Edinburgh, City of",0.65,1]
["Stirling",0.69000000000000006,1]
["Orkney Islands",0.69000000000000006,1]
["Scottish Borders",0.72,1]
["Perth and Kinross",0.73,1]
["Aberdeenshire",0.77,1]
["Angus",0.77,1]
["Midlothian",0.78,1]
["Aberdeen City",0.78,1]
["West Dunbartonshire",0.79,1]
["North Ayrshire",0.8,1]
["Clackmannanshire",0.82000000000000006,1]
["East Dunbartonshire",0.82000000000000006,1]
["Moray",0.84,1]
["South Ayrshire",0.86,1]
["Scotland",0.87,1]
["Renfrewshire",0.87,1]
["Shetland Islands",0.9,1]
["Dumfries and Galloway",0.91,1]
["Glasgow City",0.92,1]
["East Lothian",0.92,1]
["Dundee City",0.92,1]
["Inverclyde",0.93,1]
["North Lanarkshire",0.95000000000000007,1]
["South Lanarkshire",0.95000000000000007,1]
["Highland",0.95000000000000007,1]
["East Ayrshire",0.96,1]
["Argyll and Bute",0.96,1]
["Eilean Siar",0.97,1]
["Fife",0.97,1]
["Falkirk",1.04,1]
["West Lothian",1.05,1]

{"sheet":"Table 5","index":7,"n_rows":43,"n_cols":17,"rows_kept":43,"cut":false,"hidden":false,"merged":[[42,0,43,5],[0,0,0,15],[2,0,3,0],[2,1,2,3],[2,4,2,6],[2,7,2,9],[2,10,2,12],[2,14,2,16],[41,0,41,6]]}
["Table 5: Management Information - Funding and actual expenditure for 2020/21, as at 30 September 2020"]
[]
["Local authority","Mitigation of RSRS (Tranche 1 and 2 bedroom tax mitigation)1",null,null,"Benefit Cap",null,null,"Local Housing Allowance (LHA)",null,null,"Core (non welfare reform)",null,null,"Combination of all funding streams2","Total"]
[null,"Estimated funding","Award value spent","% of funding to fully mitigate RSRS spent","Estimated Funding","Award value spent","% of Benefit Cap funding spent","Estimated Funding","Award value spent","% of LHA funding spent","Estimated Funding","Award value spent","% of Core funding spent","Award value spent","Total estimated funding3","Total award value spent (management information)4","% of total estimated funding spent "]
["Aberdeen City",1777544,962862,0.54,346127,61151,0.18,31774,140408,4.42,51263,19427,0.38,22747,2396462,1206596,0.5]
["Aberdeenshire",1018426,501828,0.49,206614,19358,0.09,41299,68132,1.6500000000000001,37834,3854,0.1,0,1444153,593172,0.41000000000000003]
["Angus",617595,319371,0.52,100108,4979,0.05,29222,36790,1.26,25662,5416,0.21,388,853596,366944,0.43]
["Argyll and Bute",704688,374440,0.53,39471,211,0.01,19635,1365,7.0000000000000007E-2,20325,2048,0.1,156,824813,378220,0.46]
["Clackmannanshire",922465,426608,0.46,128349,24756,0.19,10705,11423,1.07,16327,10576,0.65,68,1144439,473431,0.41000000000000003]
["Dumfries and Galloway",1367007,778603,0.57000000000000006,144045,12604,0.09,41670,65722,1.58,39517,42183,1.07,0,1703961,899111,0.53]
["Dundee City",2220152,1136214,0.51,326093,95639,0.28999999999999998,68015,72747,1.07,60246,82495,1.37,0,2887090,1387096,0.48]
["East Ayrshire",2014492,1167556,0.57999999999999996,139192,0,0,38473,3428,0.09,38230,0,0,0,2335824,1170984,0.5]
["East Dunbartonshire",510764,269948,0.53,83375,13687,0.16,18887,519,0.03,16066,46632,2.9,0,683172,330787,0.48]
["East Lothian",666241,330309,0.5,120776,49693,0.41000000000000003,25003,24385,0.98,22054,2710,0.12,25096,921558,432193,0.47000000000000003]
["East Renfrewshire",360866,171243,0.47000000000000003,62384,5044,0.08,11951,1278,0.11,13184,4921,0.37,0,489083,182486,0.37]
["Edinburgh, City of",4576797,2007904,0.44,1973791,167770,0.08,150030,82054,0.55000000000000004,151864,411907,2.71,0,7812286,2669636,0.34]
["Eilean Siar",180354,99700,0.55000000000000004,3235,129,0.04,2045,0,0,4354,625,0.14000000000000001,0,198128,100455,0.51]
["Falkirk",1893421,975848,0.52,120891,13411,0.11,25129,65757,2.62,36130,22447,0.62,0,2159587,1077464,0.5]
["Fife",4678634,2282417,0.49,475767,34768,7.0000000000000007E-2,91189,24373,0.27,105465,177,0,857669,5661647,3199403,0.57000000000000006]
["Glasgow City",10896874,5531617,0.51,1387914,376248,0.27,172719,133145,0.77,279654,234953,0.84,2160,13592202,6278123,0.46]
["Highland",1963272,1003881,0.51,203949,57747,0.28000000000000003,36934,73571,1.99,44395,20580,0.46,0,2384037,1155779,0.48]
["Inverclyde",1168167,618091,0.53,89698,18143,0.2,35447,40890,1.1500000000000001,30632,20373,0.67,1612,1395861,699109,0.5]
["Midlothian",1001964,476341,0.48,143588,28099,0.2,23272,6305,0.27,23499,4841,0.21,0,1286785,515586,0.4]
["Moray",481442,257448,0.53,32666,0,0,14947,10732,0.72,16797,6343,0.38,2507,580728,277030,0.48]
["North Ayrshire",2451526,1289931,0.53,269845,19853,7.0000000000000007E-2,59447,4089,7.0000000000000007E-2,49220,48652,0.99,2871,3009713,1365396,0.45]
["North Lanarkshire",4337805,2435139,0.56000000000000005,444104,83969,0.19,79452,77769,0.98,96252,45162,0.47000000000000003,0,5236182,2642038,0.5]
["Orkney Islands",116335,44521,0.38,7617,4382,0.57999999999999996,2476,0,0,3269,488,0.15,617,137848,50008,0.36]
["Perth and Kinross",630094,297122,0.47000000000000003,86154,3478,0.04,27933,32494,1.1599999999999999,25375,12770,0.5,675,835336,346538,0.41000000000000003]
["Renfrewshire",2202935,1021827,0.46,138666,31789,0.23,44056,11692,0.27,53522,71852,1.34,0,2554596,1137159,0.45]
["Scottish Borders",877818,342354,0.39,130766,4275,0.03,22969,37067,1.61,26442,28157,1.06,0,1131541,411852,0.36]
["Shetland Islands",167959,83876,0.5,16682,0,0,680,0,0,2937,1217,0.41000000000000003,0,197951,85093,0.43]
["South Ayrshire",1335583,420527,0.31,131181,19551,0.15,33871,5675,0.17,31456,5506,0.18,68,1627634,451326,0.28000000000000003]
["South Lanarkshire",3252692,1745469,0.54,254363,83701,0.33,78453,79121,1.01,77329,72586,0.94000000000000006,932,3851598,1981810,0.51]
["Stirling",692935,236290,0.34,37200,0,0,10886,2193,0.2,15650,2370,0.15,16142,785525,256995,0.33]
["West Dunbartonshire",2311540,1043281,0.45,217823,50285,0.23,19780,203,0.01,37824,5100,0.13,0,2712195,1098869,0.41000000000000003]
["West Lothian",2345852,1403708,0.6,228082,96743,0.42,41138,126,0,47226,132014,2.8000000000000003,0,2808702,1632591,0.57999999999999996]
["Scotland",59744237,30056274,0.5,8090516,1381464,0.17,1309484,1113454,0.85,1500000,1368382,0.91,933707,75644237,34853280,0.46]
[]
["Figures may not sum due to rounding. Total expenditure by local authority may differ from total expenditure in Table 2 by up to £1."]
["1. RSRS = Removal of the spare room subsidy"]
["2. Combination figure is where funding could not be categorise into a single funding stream"]
["3. Estimated total funding is based on the estimate to fully mitigate the bedroom tax and a further estimate for other DHPs (Benefit Cap, Local Housing Allowance and Core). "]
["4. Total award value spent is the sum of the five funding streams- Benefit Cap, RSRS/Bedroom Tax, Local Housing Allowance, Other/Core (non welfare reform) and a combination figure (could not be allocated to a single funding stream) "]

{"sheet":"Chart 3","index":8,"n_rows":47,"n_cols":3,"rows_kept":47,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Award Value Spent","Percentage of award value spent  "]
["Removal of Spare Room Subsidy",30056274,0.86199999999999999]
["Benefit Cap",1381464,0.04]
["Local Housing Allowance",1113454,3.2000000000000001E-2]
["Core",1368382,3.9E-2]
["Combination",933707,2.7E-2]
["Total",34853280,1]

{"sheet":"Chart 4","index":9,"n_rows":43,"n_cols":5,"rows_kept":43,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Estimated Funding","Award Value Spent","Award value remaining","Percentage of estimated funding spent"]
["Removal of Spare Room Subsidy",59744237,30056274,29687963,0.5]
["Benefit Cap",8090516,1381464,6709052,0.17]
["Local Housing Allowance",1309484,1113454,196030,0.85]
["Core",1500000,1368382,131618,0.91]
["Total",75644237,34853280,40790957,0.46]

{"sheet":"Chart 5","index":10,"n_rows":78,"n_cols":7,"rows_kept":78,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Local Authority","Removal of Spare Room Subsidy","Benefit Cap","Local Housing Allowance","Core","Combination","Total"]
["Orkney Islands",44521,4382,0,488,617,50008]
["Shetland Islands",83876,0,0,1217,0,85093]
["Eilean Siar",99700,129,0,625,0,100455]
["East Renfrewshire",171243,5044,1278,4921,0,182486]
["Stirling",236290,0,2193,2370,16142,256995]
["Moray",257448,0,10732,6343,2507,277030]
["East Dunbartonshire",269948,13687,519,46632,0,330787]
["Perth and Kinross",297122,3478,32494,12770,675,346538]
["Angus",319371,4979,36790,5416,388,366944]
["Argyll and Bute",374440,211,1365,2048,156,378220]
["Scottish Borders",342354,4275,37067,28157,0,411852]
["East Lothian",330309,49693,24385,2710,25096,432193]
["South Ayrshire",420527,19551,5675,5506,68,451326]
["Clackmannanshire",426608,24756,11423,10576,68,473431]
["Midlothian",476341,28099,6305,4841,0,515586]
["Aberdeenshire",501828,19358,68132,3854,0,593172]
["Inverclyde",618091,18143,40890,20373,1612,699109]
["Dumfries and Galloway",778603,12604,65722,42183,0,899111]
["Falkirk",975848,13411,65757,22447,0,1077464]
["West Dunbartonshire",1043281,50285,203,5100,0,1098869]
["Renfrewshire",1021827,31789,11692,71852,0,1137159]
["Highland",1003881,57747,73571,20580,0,1155779]
["East Ayrshire",1167556,0,3428,0,0,1170984]
["Aberdeen City",962862,61151,140408,19427,22747,1206596]
["North Ayrshire",1289931,19853,4089,48652,2871,1365396]
["Dundee City",1136214,95639,72747,82495,0,1387096]
["West Lothian",1403708,96743,126,132014,0,1632591]
["South Lanarkshire",1745469,83701,79121,72586,932,1981810]
["North Lanarkshire",2435139,83969,77769,45162,0,2642038]
["Edinburgh, City of",2007904,167770,82054,411907,0,2669636]
["Fife",2282417,34768,24373,177,857669,3199403]
["Glasgow City",5531617,376248,133145,234953,2160,6278123]