{"text_format":"1","workbook":"xlsx","n_sheets":31,"sheets":["Notes","Contents","Fig 1 - Infographic","Fig 1 - Infographic (2)","Table 1 - Approaches","Chart 1 - Apps v open apps","Table 2 - Unique Hhs - 6 months","Chart 2 - Rates of Approaches","Table 2B - Unique Hhs - all","Table 3 - Open Approaches","Chart 3.1 - Open Approaches","Chart 3.2 Open Approach Durtio","Table 4 - Reasons","Chart 4 - Approach Reasons","Table 5 - Maximum Activty Type","Chart 5 - Activities Type by Q","Table 6 - Activities","Chart 6 - Activities","Table 7 - Activities by LA","Chart 7 - Activities by LA","Table 8 - Outcomes by Quarter","Chart 8.1 - Outcomes by quarter","Chart 8.2 - Outcome Durations","Table 9 - Outcomes by LA","Chart 9 - Outcomes by LA","Chart 10 - Homelessness Boxplot","Chart 11- Lost Contact NK Boxpl","Table 10 - Repeat Approaches","Chart 12- Repeat Approaches","SAS code - last 6 months","all data - from 04-14"],"not_rendered":{"charts":20,"images":5,"macros":1,"external_links":0,"defined_names":2,"comments":1,"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":"Notes","index":0,"n_rows":5,"n_cols":2,"rows_kept":5,"cut":false,"hidden":false,"merged":[]}
["date:","2017-11-20"]
["author:","Homelessness Statistics, CAD"]
["data source:","PREVENT1 data for 1 April 2014 to 30 Sept 2017"]
["SAS code at:","\\\\s0429a\\datashare\\dd\\EAS7\\Homelessness\\Dissemination\\Prevent1 Publications\\PREVNT1 to 30 Sept 2017\\SAS code"]
["notes:","Where potentially disclosive, figures to be rounded to the nearest five."]

{"sheet":"Contents","index":1,"n_rows":71,"n_cols":2,"rows_kept":71,"cut":false,"hidden":false,"merged":[]}
["Housing Options (PREVENT1) Statistics in Scotland: 1 April 2015 to 30 September 2017"]
["Published on 23 January 2018"]
[]
["Note: Where potentially disclosive, figures are rounded to the nearest five. "]
[null,"Contents of Tables"]
["Click here"]
["►",{"$f":"'Table 1 - Approaches'!A1","v":"Table 1: Total Housing Options approaches by LA and quarter"}]
[]
["►",{"$f":"'Table 2 - Unique Hhs - 6 months'!A1","v":"Table 2: Unique household approaches as a percentage of households in each Local Authority for period 1 April to 30 Sept 2017"}]
[]
["►",{"$f":"'Table 3 - Open Approaches'!A1","v":"Table 3: Open Approaches at the end of each quarter by LA"}]
[]
["►",{"$f":"'Table 4 - Reasons'!A1","v":"Table 4a: Reasons for Approach (Number)"}]
[]
["►",{"$f":"'Table 4 - Reasons'!A33","v":"Table 4b: Reasons for Approach (Percent)"}]
[]
["►",{"$f":"'Table 4 - Reasons'!A65","v":"Table 4c: Reasons for Approach - abbreviated (Number)"}]
[]
["►",{"$f":"'Table 4 - Reasons'!A73","v":"Table 4d: Reasons for Approach - abbreviated (Percent)"}]
[]
["►",{"$f":"'Table 5 - Maximum Activty Type'!A1","v":"Table 5a: Maximum Activity Type (Number)"}]
[]
["►",{"$f":"'Table 5 - Maximum Activty Type'!A10","v":"Table 5b: Maximum Activity Type (Percent)"}]
[]
["►",{"$f":"'Table 6 - Activities'!A1","v":"Table 6a: Housing Options activities by quarter (number)"}]
[]
["►",{"$f":"'Table 6 - Activities'!A18","v":"Table 6b: Housing Options activities by quarter (percent)"}]
[]
["►",{"$f":"'Table 7 - Activities by LA'!A1","v":"Table 7a: Housing Options activities by Local Authority, during the last 6 months, 1 April to 30 September 2017 (number)"}]
[]
["►",{"$f":"'Table 7 - Activities by LA'!A42","v":"Table 7b: Housing Options activities by Local Authority, during the last 6 months, 1 April 2016 to 30 September 2016 (percent)"}]
[]
["►",{"$f":"'Table 8 - Outcomes by Quarter'!A1","v":"Table 8a: Outcomes by Quarter (number)"}]
[]
["►",{"$f":"'Table 8 - Outcomes by Quarter'!A14","v":"Table 8b: Outcomes by Quarter (percent)"}]
[]
["►",{"$f":"'Table 9 - Outcomes by LA'!A1","v":"Table 9a: Outcomes by LA during the last 6 months: 1 April to 30 September 2017"}]
[]
["►",{"$f":"'Table 9 - Outcomes by LA'!A41","v":"Table 9b: Outcomes by LA: 1 April to 30 September 2017"}]
[]
["►",{"$f":"'Table 10 - Repeat Approaches'!A1","v":"Table 10: Households making Repeat Approaches"}]
[]
[null,"Contents of Charts"]
[]
["►",{"$f":"'Fig 1 - Infographic'!A1","v":"Figure 1: Flow diagram of all approaches to Housing Options services in Scotland during April to September 2017"}]
[]
["►",{"$f":"'Chart 2 - Rates of Approaches'!A1","v":"Chart 2: Rates of Approaches per 10,000 households"}]
[]
["►",{"$f":"'Chart 3.1 - Open Approaches'!A25","v":"Chart 3.1: Open approaches as a proportion of all approaches received between 1 April 2014 and 30 September 2017"}]
[]
["►",{"$f":"'Chart 3.2 Open Approach Durtio'!A1","v":"Chart 3.2: Distribution of the number of days approaches have been open"}]
[]
["►",{"$f":"'Chart 4 - Approach Reasons'!A1","v":"Chart 4: Percentage of Approaches by Reason for Approach"}]
[]
["►",{"$f":"'Chart 5 - Activities Type by Q'!A1","v":"Chart 5: Percentage of Approaches with each level of activity type by quarter"}]
[]
["►",{"$f":"'Chart 6 - Activities'!A1","v":"Chart 6: Housing Options Actvities by quarter"}]
[]
["►",{"$f":"'Chart 7 - Activities by LA'!A1","v":"Chart 7: Activities by Local Authority"}]
[]
["►",{"$f":"'Chart 8.1 - Outcomes by quarter'!A1","v":"Chart 8.1: Outcome of Housing Options Approaches by quarter\n"}]
[]
["►",{"$f":"'Chart 8.2 - Outcome Durations'!A1","v":"Chart 8.2: Distribution of Housing Options approach case durations by outcome, cases closed between 1 April and 30 September 2017"}]
[]
["►",{"$f":"'Chart 9 - Outcomes by LA'!A1","v":"Chart 9: Variation in outcomes for each Local Authority"}]
[]
["►",{"$f":"'Chart 10 - Homelessness Boxplot'!A1","v":"Chart 10: Distribution of the number of days to outcome an approach as a homelessness application"}]
[]
["►",{"$f":"'Chart 11- Lost Contact NK Boxpl'!A1","v":"Chart 11: Distribution of the number of days to outcome approach as Lost Contact or Not Known by LA"}]
[]
["►",{"$f":"'Chart 12- Repeat Approaches'!A1","v":"Chart 12: Proportion of Unique Households in each LA area making Repeat Approaches"}]

{"sheet":"Fig 1 - Infographic","index":2,"n_rows":13,"n_cols":27,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
["Figure 1: Flow diagram of all approaches to Housing Options services in Scotland during April to September 2017",null,null,null,null,null,null,null,null,null,null,null,null,"Back to Contents"]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Outcomes"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Table 8 - Outcomes by Quarter'!A39","v":"Made homelessness application to local authority"},10165,{"$f":"Z9/$Z$13","v":0.41032575788156461}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Table 8 - Outcomes by Quarter'!A40","v":"Remained in current accommodation"},5456,{"$f":"Z10/$Z$13","v":0.22023977717676502}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Table 8 - Outcomes by Quarter'!A41","v":"Lost Contact/ Not known"},5704,0.23025067613934525]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Table 8 - Outcomes by Quarter'!A42","v":"Moved into Alternative Accommodation"},3448,0.13918378880232513]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Z9:Z12)","v":24773}]

{"sheet":"Fig 1 - Infographic (2)","index":3,"n_rows":13,"n_cols":9,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
[null,null,"Figure 1: Flow diagram of all approaches to Housing Options services in Scotland during April to September 2017"]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,"Outcomes"]
[null,null,null,null,null,null,{"$f":"'Table 8 - Outcomes by Quarter'!A39","v":"Made homelessness application to local authority"},10165,{"$f":"H9/$H$13","v":0.41032575788156461}]
[null,null,null,null,null,null,{"$f":"'Table 8 - Outcomes by Quarter'!A40","v":"Remained in current accommodation"},5456,{"$f":"H10/$H$13","v":0.22023977717676502}]
[null,null,null,null,null,null,{"$f":"'Table 8 - Outcomes by Quarter'!A41","v":"Lost Contact/ Not known"},5704,0.23025067613934525]
[null,null,null,null,null,null,{"$f":"'Table 8 - Outcomes by Quarter'!A42","v":"Moved into Alternative Accommodation"},3448,0.13918378880232513]
[null,null,null,null,null,null,null,{"$f":"SUM(H9:H12)","v":24773}]

{"sheet":"Table 1 - Approaches","index":4,"n_rows":40,"n_cols":26,"rows_kept":40,"cut":false,"hidden":false,"merged":[[2,0,3,0],[2,17,2,20],[2,1,2,14],[2,22,2,25]]}
["Table 1: Total Housing Options approaches by LA and quarter",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Back to Contents"]
[]
["Local Authority",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Bi-annual change",null,null,null,null,"Annual change"]
[null,"2014 Q2","2014 Q3","2014 Q4","2015 Q1","2015 Q2","2015 Q3","2015 Q4","2016 Q1","2016 Q2","2016 Q3","2016 Q4","2017 Q1","2017 Q2","2017 Q3","Total",null,"April to Sept 2016","April to Sept 2017","Change","% ",null,"Year to end Sept 2016","Year to end Sept 2017","change","%"]
["Scotland",16025,16200,13920,16945,14670,14595,12375,14840,13570,13320,11355,13615,12210,11125,194770,null,{"$f":"SUM(J5:K5)","v":26890},{"$f":"SUM(N5:O5)","v":23335},{"$f":"S5-R5","v":-3555},{"$f":"T5/R5","v":-0.13220528077352176},null,{"$f":"SUM(H5:K5)","v":54105},{"$f":"SUM(L5:O5)","v":48305},{"$f":"X5-W5","v":-5800},{"$f":"Y5/W5","v":-0.10719896497551058}]
["Aberdeen City",1165,1595,1615,1910,1710,1580,1330,1515,1415,1400,1025,1345,1220,1005,19830,null,{"$f":"SUM(J6:K6)","v":2815},{"$f":"SUM(N6:O6)","v":2225},{"$f":"S6-R6","v":-590},{"$f":"T6/R6","v":-0.20959147424511546},null,{"$f":"SUM(H6:K6)","v":5660},{"$f":"SUM(L6:O6)","v":4595},{"$f":"X6-W6","v":-1065},{"$f":"Y6/W6","v":-0.18816254416961131}]
["Aberdeenshire",575,480,420,615,560,530,435,575,480,460,390,460,405,420,6805,null,940,825,-115,-0.12234042553191489,null,1950,1675,-275,-0.14102564102564102]
["Angus",275,275,240,295,260,250,180,215,290,305,190,270,180,200,3425,null,595,380,-215,-0.36134453781512604,null,990,840,-150,-0.15151515151515152]
["Argyll & Bute",130,100,260,640,580,455,400,465,435,490,375,480,520,465,5795,null,925,985,60,6.4864864864864868E-2,null,1790,1840,50,2.7932960893854747E-2]
["Clackmannanshire",30,45,30,25,15,50,30,25,125,100,90,180,150,120,1010,null,225,270,45,0.2,null,280,540,260,0.9285714285714286]
["Dumfries & Galloway",235,250,195,210,230,200,190,235,220,255,205,300,235,255,3220,null,475,490,15,3.1578947368421054E-2,null,900,995,95,0.10555555555555556]
["Dundee City",765,785,440,480,545,550,490,615,530,500,465,655,350,240,7420,null,1030,590,-440,-0.42718446601941745,null,2135,1710,-425,-0.19906323185011709]
["East Ayrshire",65,45,20,25,5,5,0,30,15,30,25,30,20,10,330,null,45,30,-15,-0.33333333333333331,null,75,85,10,0.13333333333333333]
["East Dunbartonshire",35,30,35,35,35,40,25,70,60,125,90,150,105,60,885,null,185,165,-20,-0.10810810810810811,null,280,405,125,0.44642857142857145]
["East Lothian",125,110,65,135,90,110,90,70,55,40,50,55,25,25,1040,null,95,50,-45,-0.47368421052631576,null,255,155,-100,-0.39215686274509803]
["East Renfrewshire",40,50,45,25,45,50,45,50,55,45,40,45,35,30,595,null,100,65,-35,-0.35,null,195,150,-45,-0.23076923076923078]
["Edinburgh",1940,2105,1960,2170,2045,1930,1785,1845,1760,1600,1470,1595,1465,1275,24940,null,3360,2740,-620,-0.18452380952380953,null,6990,5805,-1185,-0.16952789699570817]
["Eilean Siar",5,5,0,5,0,0,5,5,0,0,0,10,0,0,45,null,0,0,"-","-",null,10,10,0,0]
["Falkirk",565,580,435,475,440,470,395,520,485,515,450,540,505,460,6840,null,1000,965,-35,-3.5000000000000003E-2,null,1915,1955,40,2.0887728459530026E-2]
["Fife",805,830,650,905,845,715,560,695,700,690,570,735,715,590,10005,null,1390,1305,-85,-6.1151079136690649E-2,null,2645,2610,-35,-1.3232514177693762E-2]
["Glasgow City",3685,3210,2845,3325,2115,2720,2385,2890,2525,2520,2085,2590,2485,2365,37750,null,5045,4850,-195,-3.865213082259663E-2,null,10320,9525,-795,-7.7034883720930231E-2]
["Highland",490,490,345,400,465,430,330,325,160,130,75,110,80,30,3855,null,290,110,-180,-0.62068965517241381,null,945,295,-650,-0.68783068783068779]
["Inverclyde",225,305,215,250,240,215,205,265,235,210,225,275,220,240,3330,null,445,460,15,3.3707865168539325E-2,null,915,960,45,4.9180327868852458E-2]
["Midlothian",160,130,90,125,125,90,85,115,100,110,90,90,65,75,1450,null,210,140,-70,-0.33333333333333331,null,410,320,-90,-0.21951219512195122]
["Moray",325,305,270,340,315,230,225,325,255,265,240,320,280,280,3975,null,520,560,40,7.6923076923076927E-2,null,1070,1120,50,4.6728971962616821E-2]
["North Ayrshire",470,480,410,565,470,480,380,470,435,380,320,435,425,435,6150,null,815,860,45,5.5214723926380369E-2,null,1665,1615,-50,-3.003003003003003E-2]
["North Lanarkshire",920,875,740,995,900,925,725,875,835,830,910,630,470,445,11065,null,1665,915,-750,-0.45045045045045046,null,3265,2455,-810,-0.24808575803981622]
["Orkney",10,15,15,15,10,20,10,20,10,10,5,5,5,5,155,null,20,10,-10,-0.5,null,50,20,-30,-0.6]
["Perth & Kinross",565,535,485,550,460,545,435,550,575,590,525,670,635,620,7740,null,1165,1255,90,7.7253218884120178E-2,null,2150,2450,300,0.13953488372093023]
["Renfrewshire",460,520,460,550,535,520,470,585,530,540,485,560,525,490,7225,null,1070,1015,-55,-5.1401869158878503E-2,null,2125,2060,-65,-3.0588235294117649E-2]
["Scottish Borders",275,255,200,270,260,240,160,205,210,220,165,255,190,185,3095,null,430,375,-55,-0.12790697674418605,null,795,795,0,0]
["Shetland",100,65,75,65,40,40,45,40,50,45,55,50,45,65,780,null,95,110,15,0.15789473684210525,null,180,215,35,0.19444444444444445]
["South Ayrshire",240,230,245,350,365,395,355,450,310,260,225,215,255,265,4170,null,570,520,-50,-8.771929824561403E-2,null,1375,960,-415,-0.30181818181818182]
["South Lanarkshire",345,365,255,335,260,315,235,265,225,195,175,260,225,190,3640,null,420,415,-5,-1.1904761904761904E-2,null,920,850,-70,-7.6086956521739135E-2]
["Stirling",200,235,155,55,100,105,80,130,105,90,50,70,90,85,1550,null,195,175,-20,-0.10256410256410256,null,405,295,-110,-0.27160493827160492]
["West Dunbartonshire",420,465,385,385,285,45,20,35,40,60,40,55,60,55,2355,null,100,115,15,0.15,null,155,210,55,0.35483870967741937]
["West Lothian",370,430,315,430,330,340,275,370,335,300,255,180,225,150,4305,null,635,375,-260,-0.40944881889763779,null,1280,810,-470,-0.3671875]
[]
["NB: Disclosure Control has been applied to this table.  All cells have been rounded to the nearest five."]
["Column totals may not sum to total of individual cells due to rounding."]

{"sheet":"Chart 1 - Apps v open apps","index":5,"n_rows":59,"n_cols":42,"rows_kept":59,"cut":false,"hidden":false,"merged":[]}
["Chart 1: Number of Housing Options Approaches by Month",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Back to Contents"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AVERAGE(Y50:AD50)","v":4481.166666666667}]
[]
[]
[2014,null,null,null,null,null,null,null,null,2015,null,null,null,null,null,null,null,null,null,null,null,2016,null,null,null,null,null,null,null,null,null,null,null,2017]
[null,null,"Jun",null,null,"Sep",null,null,"Dec",null,null,"Mar",null,null,"Jun",null,null,"Sep",null,null,"Dec",null,null,"Mar",null,null,"Jun",null,null,"Sep",null,null,"Dec",null,null,"Mar",null,null,"Jun",null,null,"Sep"]
[5418,5127,5480,5473,5286,5441,5556,4696,3668,5589,5513,5845,4900,4798,4974,4734,4994,4867,4715,4438,3222,4774,4988,5079,4555,4408,4605,4054,4712,4553,4293,4155,2909,4482,4303,4830,3768,4337,4105,3771,4085,3271]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"R50-L50","v":-978},{"$f":"S50-M50","v":-185},-360,-1752,40,-6,212,-160,-30,1383,-720,-276,-526,{"$f":"AE50-Y50","v":-262},{"$f":"AF50-Z50","v":-253},-1696,428,-409,277,-525,182,1196,-711,-218,-1559]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"R53/L50","v":-0.16732249786142001},{"$f":"S53/M50","v":-3.7755102040816328E-2},-7.5031263026260939E-2,-0.35223160434258144,8.4495141529362053E-3,-1.2014417300760913E-3,4.3558660365728377E-2,-3.3934252386002124E-2,-6.7598017124831005E-3,0.42923649906890132,-0.15081692501047339,-5.5332798716920609E-2,-0.1035636936404804,{"$f":"AE53/Y50","v":-5.7519209659714597E-2},{"$f":"AF53/Z50","v":-5.7395644283121598E-2},-0.36829533116178065,0.10557474099654662,-8.6799660441426146E-2,6.0839007247968376E-2,-0.1222921034241789,4.3802647412755719E-2,0.41113784805775183,-0.15863453815261044,-5.0662328607947942E-2,-0.3227743271221532]
[]
[]
[null,"2014-06-30","2014-09-30","2014-12-31","2015-03-31","2015-06-30","2015-09-30","2015-12-31","2016-03-31","2016-06-30","2016-09-30","2016-12-31","2017-03-31","2017-06-30","2017-09-30"]
["Open approaches",7440,9630,10215,13765,15690,17060,16550,18270,18875,19815,19580,18495,16715,17060]
["New approaches",16025,16200,13920,16945,14670,14595,12375,14840,13570,13320,11355,13615,12210,11125]

{"sheet":"Table 2 - Unique Hhs - 6 months","index":6,"n_rows":81,"n_cols":7,"rows_kept":81,"cut":false,"hidden":false,"merged":[[2,2,3,2],[2,3,3,3],[2,0,3,0],[2,1,3,1],[2,6,3,6]]}
["Table 2: Unique household approaches as a percentage of households in each Local Authority for period 1 April to 30 Sept 2017"]
[null,null,null,null,"Back to Contents"]
["Local Authority","Number of households1","Unique household approaches","Unique household approaches as % of households within LA",null,null,"Number of approaches per 10,000 households"]
[null,null,"1 April 2014 to 31 March 2015"]
["Scotland",2451869,21875,{"$f":"C5/B5","v":8.9217653961121083E-3},null,null,{"$f":"C5/B5*10000","v":89.217653961121087}]
["Aberdeen City",106749,2130,1.9953348509119524E-2,null,null,199.53348509119525]
["Aberdeenshire",110296,785,7.1172118662508159E-3,null,null,71.172118662508154]
["Angus",53333,370,6.9375433596459979E-3,null,null,69.375433596459985]
["Argyll & Bute",41040,840,2.046783625730994E-2,null,null,204.67836257309941]
["Clackmannanshire",23401,260,1.111063629759412E-2,null,null,111.1063629759412]
["Dumfries & Galloway",69202,470,6.7917112222190112E-3,null,null,67.917112222190113]
["Dundee City",69635,570,8.1855388813096858E-3,null,null,81.855388813096852]
["East Ayrshire",54748,30,5.4796522247388033E-4,null,null,5.4796522247388033]
["East Dunbartonshire",45350,150,3.3076074972436605E-3,null,null,33.076074972436608]
["East Lothian",44749,50,1.1173434043218844E-3,null,null,11.173434043218844]
["East Renfrewshire",38581,65,1.6847671133459474E-3,null,null,16.847671133459475]
["Edinburgh, City of",232885,2640,1.1336067157609979E-2,null,null,113.36067157609979]
["Eilean Siar",12951,0,0,null,null,0]
["Falkirk",71072,870,1.2241107609185052E-2,null,null,122.41107609185052]
["Fife",165833,1235,7.4472511502535685E-3,null,null,74.472511502535681]
["Glasgow City",293595,4400,1.4986631243720091E-2,null,null,149.86631243720092]
["Highland",107573,110,1.0225614234055014E-3,null,null,10.225614234055014]
["Inverclyde",37586,390,1.0376203905709572E-2,null,null,103.76203905709572]
["Midlothian",37766,135,3.5746438595562146E-3,null,null,35.746438595562147]
["Moray",41961,540,1.2869092728962608E-2,null,null,128.69092728962607]
["North Ayrshire",63440,835,1.3162042875157629E-2,null,null,131.6204287515763]
["North Lanarkshire",150364,900,5.9854752467345907E-3,null,null,59.854752467345911]
["Orkney Islands",10256,15,1.4625585023400937E-3,null,null,14.625585023400937]
["Perth & Kinross",67101,1110,1.6542227388563507E-2,null,null,165.42227388563506]
["Renfrewshire",84025,945,1.1246652781910145E-2,null,null,112.46652781910146]
["Scottish Borders",53787,365,6.7860263632476252E-3,null,null,67.860263632476247]
["Shetland Islands",10283,105,1.0211027910142955E-2,null,null,102.11027910142955]
["South Ayrshire",51923,505,9.7259403347264226E-3,null,null,97.259403347264225]
["South Lanarkshire",144148,405,2.8096123428698284E-3,null,null,28.096123428698284]
["Stirling",38951,170,4.3644579086544637E-3,null,null,43.644579086544638]
["West Dunbartonshire",42657,115,2.6959232951215511E-3,null,null,26.959232951215512]
["West Lothian",76630,365,4.7631475923267646E-3,null,null,47.631475923267644]
[]
["1) Source: National Records of Scotland: Estimates of Households and Dwellings in Scotland, 2016"]
["http://www.gro-scotland.gov.uk/statistics-and-data/statistics/statistics-by-theme/housholds/household-estimates"]
["NB Unique household approaches are rounded to 5 for disclosure purposes."]
[]
[]
[]
[]
[]
["Data for chart"]
[]
["Eilean Siar",1.54428229480349E-4,null,"Eilean Siar",0]
["East Ayrshire",5.6623072988967629E-4,null,"East Ayrshire",5.4796522247388033]
["Highland",1.0039693975254014E-3,null,"Highland",10.225614234055014]
["East Lothian",1.0726496681490089E-3,null,"East Lothian",11.173434043218844]
["Orkney Islands",1.2675507020280812E-3,null,"Orkney Islands",14.625585023400937]
["East Renfrewshire",1.6588476192944714E-3,null,"East Renfrewshire",16.847671133459475]
["West Dunbartonshire",2.6490376725976979E-3,null,"West Dunbartonshire",26.959232951215512]
["South Lanarkshire",2.8234869717235064E-3,null,"South Lanarkshire",28.096123428698284]
["East Dunbartonshire",3.2855567805953694E-3,null,"East Dunbartonshire",33.076074972436608]
["Midlothian",3.6276015463644548E-3,null,"Midlothian",35.746438595562147]
["Stirling",4.4158044722856921E-3,null,"Stirling",43.644579086544638]
["West Lothian",4.7631475923267646E-3,null,"West Lothian",47.631475923267644]
["North Lanarkshire",5.992125774786518E-3,null,"North Lanarkshire",59.854752467345911]
["Scottish Borders",6.804618216297618E-3,null,"Scottish Borders",67.860263632476247]
["Dumfries & Galloway",6.8061616716279874E-3,null,"Dumfries & Galloway",67.917112222190113]
["Angus",6.9187932424577651E-3,null,"Angus",69.375433596459985]
["Aberdeenshire",7.1081453543192863E-3,null,"Aberdeenshire",71.172118662508154]
["Fife",7.4532813131282672E-3,null,"Fife",74.472511502535681]
["Dundee City",8.1568176922524587E-3,null,"Dundee City",81.855388813096852]
["Scotland",8.9221732482445016E-3,null,"Scotland",89.217653961121087]
["South Ayrshire",9.7066810469348848E-3,null,"South Ayrshire",97.259403347264225]
["Shetland Islands",1.0308275795001459E-2,null,"Shetland Islands",102.11027910142955]
["Inverclyde",1.0376203905709572E-2,null,"Inverclyde",103.76203905709572]
["Clackmannanshire",1.1196102730652536E-2,null,"Clackmannanshire",111.1063629759412]
["Renfrewshire",1.1222850342160071E-2,null,"Renfrewshire",112.46652781910146]
["Edinburgh, City of",1.1331773192777551E-2,null,"Edinburgh, City of",113.36067157609979]
["Falkirk",1.2255177847816299E-2,null,"Falkirk",122.41107609185052]
["Moray",1.289292438216439E-2,null,"Moray",128.69092728962607]
["North Ayrshire",1.317780580075662E-2,null,"North Ayrshire",131.6204287515763]
["Glasgow City",1.4986631243720091E-2,null,"Glasgow City",149.86631243720092]
["Perth & Kinross",1.6512421573448979E-2,null,"Perth & Kinross",165.42227388563506]
["Aberdeen City",1.9953348509119524E-2,null,"Aberdeen City",199.53348509119525]
["Argyll & Bute",2.0516569200779728E-2,null,"Argyll & Bute",204.67836257309941]

{"sheet":"Chart 2 - Rates of Approaches","index":7,"n_rows":2,"n_cols":14,"rows_kept":2,"cut":false,"hidden":false,"merged":[]}
["Chart 2: Rates of Approaches per 10,000 households",null,null,null,null,null,null,null,null,null,null,null,null,"Back to Contents"]
["Households making approaches between 1 April and 30 Sept 2017"]

{"sheet":"Table 2B - Unique Hhs - all","index":8,"n_rows":81,"n_cols":7,"rows_kept":81,"cut":false,"hidden":false,"merged":[[2,0,3,0],[2,1,3,1],[2,2,3,2],[2,3,3,3],[2,6,3,6]]}
["Table 2: Unique household approaches as a percentage of households in each Local Authority for period 1 April 2014 to 30 Sept 2017"]
[null,null,null,null,"Back to Contents"]
["Local Authority","Number of households1","Unique household approaches","Unique household approaches as % of households within LA",null,null,"Number of approaches per 10,000 households"]
[null,null,"1 April 2014 to 31 March 2015"]
["Scotland",2451869,150661,{"$f":"C5/B5","v":6.1447410118566692E-2},null,null,{"$f":"C5/B5*10000","v":614.47410118566688}]
["Aberdeen City",106749,16549,{"$f":"C6/B6","v":0.15502721336968028},null,null,{"$f":"C6/B6*10000","v":1550.2721336968029}]
["Aberdeenshire",110296,5116,4.6384275041705954E-2,null,null,463.84275041705956]
["Angus",53333,2984,5.5950349689685562E-2,null,null,559.50349689685561]
["Argyll & Bute",41040,3580,8.7231968810916174E-2,null,null,872.31968810916169]
["Clackmannanshire",23401,855,3.6536900132472974E-2,null,null,365.36900132472977]
["Dumfries & Galloway",69202,2535,3.6631889251755728E-2,null,null,366.31889251755729]
["Dundee City",69635,5880,8.4440295828247289E-2,null,null,844.40295828247292]
["East Ayrshire",54748,320,5.8449623730547238E-3,null,null,58.449623730547238]
["East Dunbartonshire",45350,746,1.6449834619625139E-2,null,null,164.49834619625139]
["East Lothian",44749,942,2.1050749737424299E-2,null,null,210.507497374243]
["East Renfrewshire",38581,533,1.381509032943677E-2,null,null,138.15090329436771]
["Edinburgh, City of",232885,19315,8.2937930738347251E-2,null,null,829.37930738347256]
["Eilean Siar",12951,38,2.9341363601266312E-3,null,null,29.341363601266313]
["Falkirk",71072,5089,7.1603444394416932E-2,null,null,716.03444394416931]
["Fife",165833,7922,4.7770950293367427E-2,null,null,477.70950293367429]
["Glasgow City",293595,25662,8.7406120676442031E-2,null,null,874.06120676442026]
["Highland",107573,3534,3.2852109730136747E-2,null,null,328.52109730136749]
["Inverclyde",37586,2049,5.4514978981535678E-2,null,null,545.14978981535683]
["Midlothian",37766,1180,3.1245035216861727E-2,null,null,312.45035216861726]
["Moray",41961,3306,7.8787445485093296E-2,null,null,787.87445485093292]
["North Ayrshire",63440,4973,7.8389029003783098E-2,null,null,783.89029003783094]
["North Lanarkshire",150364,9339,6.2109281476949267E-2,null,null,621.09281476949263]
["Orkney Islands",10256,130,1.2675507020280811E-2,null,null,126.75507020280811]
["Perth & Kinross",67101,5795,8.6362349294347329E-2,null,null,863.62349294347325]
["Renfrewshire",84025,5289,6.294555191907171E-2,null,null,629.45551919071715]
["Scottish Borders",53787,2528,4.7000204510383552E-2,null,null,470.00204510383554]
["Shetland Islands",10283,660,6.4183604006612854E-2,null,null,641.83604006612859]
["South Ayrshire",51923,3258,6.2746759624829077E-2,null,null,627.46759624829076]
["South Lanarkshire",144148,3225,2.2372839026556041E-2,null,null,223.72839026556039]
["Stirling",38951,1334,3.4248157942029726E-2,null,null,342.48157942029724]
["West Dunbartonshire",42657,2093,4.9065803971212227E-2,null,null,490.65803971212227]
["West Lothian",76630,3902,5.0920005219887772E-2,null,null,509.2000521988777]
[]
["1) Source: National Records of Scotland: Estimates of Households and Dwellings in Scotland, 2016"]
["http://www.gro-scotland.gov.uk/statistics-and-data/statistics/statistics-by-theme/housholds/household-estimates"]
[]
[]
[]
[]
[]
[]
["Data for chart"]
[]
["Eilean Siar",2.9341363601266312E-3]
["East Ayrshire",5.8449623730547238E-3]
["Orkney Islands",1.2675507020280811E-2]
["East Renfrewshire",1.381509032943677E-2]
["East Dunbartonshire",1.6449834619625139E-2]
["East Lothian",2.1050749737424299E-2]
["South Lanarkshire",2.2372839026556041E-2]
["Midlothian",3.1245035216861727E-2]
["Highland",3.2852109730136747E-2]
["Stirling",3.4248157942029726E-2]
["Clackmannanshire",3.6536900132472974E-2]
["Dumfries & Galloway",3.6631889251755728E-2]
["Aberdeenshire",4.6384275041705954E-2]
["Scottish Borders",4.7000204510383552E-2]
["Fife",4.7770950293367427E-2]
["West Dunbartonshire",4.9065803971212227E-2]
["West Lothian",5.0920005219887772E-2]
["Inverclyde",5.4514978981535678E-2]
["Angus",5.5950349689685562E-2]
["Scotland",6.1447410118566692E-2]
["North Lanarkshire",6.2109281476949267E-2]
["South Ayrshire",6.2746759624829077E-2]
["Renfrewshire",6.294555191907171E-2]
["Shetland Islands",6.4183604006612854E-2]
["Falkirk",7.1603444394416932E-2]
["North Ayrshire",7.8389029003783098E-2]
["Moray",7.8787445485093296E-2]
["Edinburgh, City of",8.2937930738347251E-2]
["Dundee City",8.4440295828247289E-2]
["Perth & Kinross",8.6362349294347329E-2]
["Argyll & Bute",8.7231968810916174E-2]
["Glasgow City",8.7406120676442031E-2]
["Aberdeen City",0.15502721336968028]

{"sheet":"Table 3 - Open Approaches","index":9,"n_rows":79,"n_cols":27,"rows_kept":79,"cut":false,"hidden":false,"merged":[[2,25,2,26],[3,25,3,26],[2,0,3,0],[2,22,3,22],[2,23,3,23],[2,1,2,14]]}
["Table 3: Open Approaches at the end of each quarter by LA",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Back to Contents"]
[]
["Local Authority","Number of Approaches Open at the end of each Quarter",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total Approaches received \n1 April 2014 to 30 Sept 2017 \n","Open Approaches as a % of all Approaches ",null,"Annual change"]
[null,"2014-06-30","2014-09-30","2014-12-31","2015-03-31","2015-06-30","2015-09-30","2015-12-31","2016-03-31","2016-06-30","2016-09-30","2016-12-31","2017-03-31","2017-06-30","2017-09-30",null,null,null,null,null,null,null,null,null,null,"Open approaches on 30 Sept 2017 compared to 30 Sept 2016"]
["Scotland",7440,9630,10215,13765,15690,17060,16550,18270,18875,19815,19580,18495,16715,17060,null,null,null,null,null,null,null,194770,{"$f":"O5/W5","v":8.7590491348770338E-2},null,{"$f":"O5-K5","v":-2755},{"$f":"Z5/K5","v":-0.139036083774918}]
["Aberdeen City",710,1155,1390,2445,3480,4165,4675,5340,5630,5675,5530,4200,1780,1725,null,null,null,null,null,null,null,19830,{"$f":"O6/W6","v":8.698940998487141E-2},null,{"$f":"O6-K6","v":-3950},{"$f":"Z6/K6","v":-0.69603524229074887}]
["Aberdeenshire",125,150,190,235,240,275,235,370,365,240,220,220,240,220,null,null,null,null,null,null,null,6805,3.2329169728141073E-2,null,-20,-8.3333333333333329E-2]
["Angus",85,105,105,150,195,200,180,185,245,290,250,255,170,80,null,null,null,null,null,null,null,3425,2.3357664233576641E-2,null,-210,-0.72413793103448276]
["Argyll & Bute",45,15,115,270,315,275,335,340,415,495,430,455,555,595,null,null,null,null,null,null,null,5795,0.10267471958584987,null,100,0.20202020202020202]
["Clackmannanshire",10,25,25,25,15,25,35,15,35,15,20,85,120,120,null,null,null,null,null,null,null,1010,0.11881188118811881,null,105,7]
["Dumfries & Galloway",165,190,180,225,250,240,255,240,180,200,35,30,15,20,null,null,null,null,null,null,null,3220,6.2111801242236021E-3,null,-180,-0.9]
["Dundee City",175,215,60,105,275,255,145,220,170,145,120,180,115,70,null,null,null,null,null,null,null,7420,9.433962264150943E-3,null,-75,-0.51724137931034486]
["East Ayrshire",50,70,55,45,30,20,5,20,25,35,40,30,25,20,null,null,null,null,null,null,null,330,6.0606060606060608E-2,null,-15,-0.42857142857142855]
["East Dunbartonshire",10,20,25,20,30,20,20,30,30,35,35,55,55,65,null,null,null,null,null,null,null,885,7.3446327683615822E-2,null,30,0.8571428571428571]
["East Lothian",80,95,35,80,55,60,40,45,25,25,25,35,40,50,null,null,null,null,null,null,null,1040,4.807692307692308E-2,null,25,1]
["East Renfrewshire",35,85,55,50,55,80,90,105,95,80,100,85,115,105,null,null,null,null,null,null,null,595,0.17647058823529413,null,25,0.3125]
["Edinburgh",1050,1725,2015,2555,2785,2835,2805,2875,2960,3080,3090,3230,3425,3565,null,null,null,null,null,null,null,24940,0.1429430633520449,null,485,0.15746753246753248]
["Eilean Siar",10,10,5,10,10,10,10,10,10,10,5,10,5,5,null,null,null,null,null,null,null,45,0.1111111111111111,null,-5,-0.5]
["Falkirk",430,665,840,290,245,265,190,130,100,90,80,40,230,320,null,null,null,null,null,null,null,6840,4.6783625730994149E-2,null,230,2.5555555555555554]
["Fife",230,335,185,435,400,455,500,835,925,1195,1335,1650,1840,2035,null,null,null,null,null,null,null,10005,0.20339830084957522,null,840,0.70292887029288698]
["Glasgow City",1245,1150,1160,1765,1825,2290,1790,1410,1430,1720,1315,750,730,915,null,null,null,null,null,null,null,37750,2.423841059602649E-2,null,-805,-0.46802325581395349]
["Highland",240,265,205,490,390,280,245,325,190,210,200,165,145,125,null,null,null,null,null,null,null,3855,3.2425421530479899E-2,null,-85,-0.40476190476190477]
["Inverclyde",170,325,335,320,335,340,295,305,325,305,340,390,380,435,null,null,null,null,null,null,null,3330,0.13063063063063063,null,130,0.42622950819672129]
["Midlothian",125,185,155,140,170,190,235,345,405,470,490,540,570,615,null,null,null,null,null,null,null,1450,0.42413793103448277,null,145,0.30851063829787234]
["Moray",170,190,170,220,225,150,110,200,155,165,115,190,190,205,null,null,null,null,null,null,null,3975,5.157232704402516E-2,null,40,0.24242424242424243]
["North Ayrshire",220,500,605,815,880,1045,1090,1030,1030,705,590,565,570,580,null,null,null,null,null,null,null,6150,9.4308943089430899E-2,null,-125,-0.1773049645390071]
["North Lanarkshire",385,445,355,550,760,635,500,685,920,1335,2065,2440,2570,2590,null,null,null,null,null,null,null,11065,0.23407139629462267,null,1255,0.94007490636704116]
["Orkney",10,25,20,20,25,25,20,20,15,25,15,5,15,10,null,null,null,null,null,null,null,155,6.4516129032258063E-2,null,-15,-0.6]
["Perth & Kinross",300,350,400,560,515,650,720,735,770,900,985,710,530,505,null,null,null,null,null,null,null,7740,6.5245478036175711E-2,null,-395,-0.43888888888888888]
["Renfrewshire",270,235,280,300,330,315,290,365,365,425,405,395,375,315,null,null,null,null,null,null,null,7225,4.3598615916955019E-2,null,-110,-0.25882352941176473]
["Scottish Borders",120,135,110,165,175,150,125,150,160,145,120,145,130,80,null,null,null,null,null,null,null,3095,2.5848142164781908E-2,null,-65,-0.44827586206896552]
["Shetland",50,75,110,115,125,135,145,150,150,135,145,150,135,145,null,null,null,null,null,null,null,780,0.1858974358974359,null,10,7.407407407407407E-2]
["South Ayrshire",135,200,220,355,460,535,390,475,465,370,240,235,300,370,null,null,null,null,null,null,null,4170,8.8729016786570747E-2,null,0,0]
["South Lanarkshire",465,300,440,480,490,595,560,680,680,600,575,655,650,545,null,null,null,null,null,null,null,3640,0.14972527472527472,null,-55,-9.166666666666666E-2]
["Stirling",125,135,115,155,215,210,190,210,165,170,140,175,185,215,null,null,null,null,null,null,null,1550,0.13870967741935483,null,45,0.26470588235294118]
["West Dunbartonshire",100,140,135,155,110,45,40,55,60,75,75,75,85,90,null,null,null,null,null,null,null,2355,3.8216560509554139E-2,null,15,0.2]
["West Lothian",90,115,130,220,280,280,290,370,390,440,450,350,420,325,null,null,null,null,null,null,null,4305,7.5493612078977937E-2,null,-115,-0.26136363636363635]
[]
["Disclosure Control has been applied to this table.  All cells have been rounded to the nearest five."]
["Row totals may not sum to total of individual cells due to rounding."]
[]
["Chart Data - Open Cases"]
[null,{"$f":"X3","v":"Open Approaches as a % of all Approaches "}]
["Midlothian",0.42413793103448277]
["North Lanarkshire",0.23407139629462267]
["Fife",0.20339830084957522]
["Shetland",0.1858974358974359]
["East Renfrewshire",0.17647058823529413]
["South Lanarkshire",0.14972527472527472]
["Edinburgh",0.1429430633520449]
["Stirling",0.13870967741935483]
["Inverclyde",0.13063063063063063]
["Clackmannanshire",0.11881188118811881]
["Eilean Siar",0.1111111111111111]
["Argyll & Bute",0.10267471958584987]
["North Ayrshire",9.4308943089430899E-2]
["South Ayrshire",8.8729016786570747E-2]
["Scotland",8.7590491348770338E-2]
["Aberdeen City",8.698940998487141E-2]
["West Lothian",7.5493612078977937E-2]
["East Dunbartonshire",7.3446327683615822E-2]
["Perth & Kinross",6.5245478036175711E-2]
["Orkney",6.4516129032258063E-2]
["East Ayrshire",6.0606060606060608E-2]
["Moray",5.157232704402516E-2]
["East Lothian",4.807692307692308E-2]
["Falkirk",4.6783625730994149E-2]
["Renfrewshire",4.3598615916955019E-2]
["West Dunbartonshire",3.8216560509554139E-2]
["Highland",3.2425421530479899E-2]
["Aberdeenshire",3.2329169728141073E-2]
["Scottish Borders",2.5848142164781908E-2]
["Glasgow City",2.423841059602649E-2]
["Angus",2.3357664233576641E-2]
["Dundee City",9.433962264150943E-3]
["Dumfries & Galloway",6.2111801242236021E-3]
[]
[]
["Note: To calculate these figures, see 'Calculating open approaches.xlsx' in the publication folder"]

{"sheet":"Chart 3.1 - Open Approaches","index":10,"n_rows":25,"n_cols":26,"rows_kept":25,"cut":false,"hidden":false,"merged":[[5,11,6,11],[5,12,5,21]]}
["Chart 3.1: Open Approaches at the end of each quarter - Scotland",null,null,null,null,null,null,null,null,null,"Back to Contents"]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"2014-06-30","2014-09-30","2014-12-31","2015-03-31","2015-06-30","2015-09-30","2015-12-31","2016-03-31","2016-06-30","2016-09-30","2016-12-31","2017-03-31","2017-06-30","2017-09-30"]
[null,null,null,null,null,null,null,null,null,null,null,"Number of approaches per quarter",16025,16200,13920,16947,14672,14595,12375,14841,13568,13319,11357,13615,12210,11127]
[null,null,null,null,null,null,null,null,null,null,null,"Open approaches at the end of each quarter",7440,9630,10215,13765,15690,17060,16550,18270,18875,19815,19580,18495,16715,17060]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Chart 3.1: Open approaches as a proportion of all approaches received between 1 April 2014 and 30 September 2017"]

{"sheet":"Chart 3.2 Open Approach Durtio","index":11,"n_rows":181,"n_cols":7,"rows_kept":181,"cut":false,"hidden":false,"merged":[[64,0,65,0],[64,2,64,6],[64,1,65,1]]}
["Chart 3.2: Distribution of the number of days approaches have been open",null,null,null,null,null,"Back to Contents"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Working for Chart 15: For Approaches open on 30 September 2017, how long have they been open for?"]
[]
["Local Authority","Number of Open Approaches on 30 Sept 2017","Number of days between Approach Date and 30 Sept 2017"]
[null,null,"P5","Q1","Median","Q3","P95"]
["Scotland",17058,10,67,198,404,1018]
["Aberdeen City",1726,10,47,109,340,526]
["Aberdeenshire",219,4,19,40,68,115]
["Angus",82,3,18,42,215,1095]
["Argyll & Bute",595,10,47,122,306,940]
["Clackmannanshire",120,8,53,116,192,405]
["Dumfries & Galloway",18,1,12,39,81,508]
["Dundee City",68,8,36,45,158,939]
["East Ayrshire",22,16,59,100,149,206]
["East Dunbartonshire",67,16,101,248,633,1249]
["East Lothian",49,16,61,172,206,305]
["East Renfrewshire",104,37,108,206,1022,1187]
["Edinburgh",3563,16,92,206,354,572]
["Eilean Siar",6,61,148,204,228,241]
["Falkirk",319,2,22,50,86,144]
["Fife",2034,18,136,340,562,839]
["Glasgow City",913,3,18,47,121,399]
["Highland",127,32,103,158,562,1024]
["Inverclyde",437,8,58,156,394,1223]
["Midlothian",615,46,249,495,719,1170]
["Moray",207,4,18,39,74,145]
["North Ayrshire",581,12,68,171,339,948]
["North Lanarkshire",2592,29,151,316,396,583]
["Orkney",9,8,46,93,227,428]
["Perth & Kinross",503,8,40,116,298,732]
["Renfrewshire",313,3,37,1107,1191,1230]
["Scottish Borders",81,2,17,54,192,467]
["Shetland",143,16,109,787,1053,1221]
["South Ayrshire",368,30,115,208,262,648]
["South Lanarkshire",545,25,93,710,1060,1202]
["Stirling",215,9,74,333,1054,1152]
["West Dunbartonshire",91,8,47,114,1046,1256]
["West Lothian",326,15,122,396,625,971]
[]
["Notes"]
["P5 = 5th Percentile.  5% of approaches have been open for this many days."]
["Q1 = First Quartile.  25% of approaches have been open for this many days."]
["Median.  50% of approaches have been open for this many days."]
["Q3 = First Quartile.  75% of approaches have been open for this many days. Conversely, 25% of cases have been open for more than this number of days."]
["P95 = 95th Percentile.  5% of approaches have been open for more than this number of days."]
[]
[]
["Data for Box Plot"]
[]
[null,"Number of days between Approach Date and 30 September 2016"]
["Local Authority","P5","Q1","Median","Q3","P95"]
["Dumfries & Galloway",1,12,39,81,508]
["Moray",4,18,39,74,145]
["Aberdeenshire",4,19,40,68,115]
["Angus",3,18,42,215,1095]
["Dundee City",8,36,45,158,939]
["Glasgow City",3,18,47,121,399]
["Falkirk",2,22,50,86,144]
["Scottish Borders",2,17,54,192,467]
["Orkney",8,46,93,227,428]
["East Ayrshire",16,59,100,149,206]
["Aberdeen City",10,47,109,340,526]
["West Dunbartonshire",8,47,114,1046,1256]
["Clackmannanshire",8,53,116,192,405]
["Perth & Kinross",8,40,116,298,732]
["Argyll & Bute",10,47,122,306,940]
["Inverclyde",8,58,156,394,1223]
["Highland",32,103,158,562,1024]
["North Ayrshire",12,68,171,339,948]
["East Lothian",16,61,172,206,305]
["Scotland",10,67,198,404,1018]
["Eilean Siar",61,148,204,228,241]
["East Renfrewshire",37,108,206,1022,1187]
["Edinburgh",16,92,206,354,572]
["South Ayrshire",30,115,208,262,648]
["East Dunbartonshire",16,101,248,633,1249]
["North Lanarkshire",29,151,316,396,583]
["Stirling",9,74,333,1054,1152]
["Fife",18,136,340,562,839]
["West Lothian",15,122,396,625,971]
["Midlothian",46,249,495,719,1170]
["South Lanarkshire",25,93,710,1060,1202]
["Shetland",16,109,787,1053,1221]
["Renfrewshire",3,37,1107,1191,1230]
[]
[{"$f":"A112","v":"Local Authority"},"Q1","Median-Q1","Q3-Median","Q1-P5","P95-Q3","Median"]
[]
[{"$f":"A113","v":"Dumfries & Galloway"},{"$f":"C113","v":12},{"$f":"D113-C113","v":27},42,{"$f":"C113-B113","v":11},{"$f":"F113-E113","v":427},{"$f":"D113","v":39}]
["Moray",18,21,35,14,71,39]
["Aberdeenshire",19,21,28,15,47,40]
["Angus",18,24,173,15,880,42]
["Dundee City",36,9,113,28,781,45]
["Glasgow City",18,29,74,15,278,47]
["Falkirk",22,28,36,20,58,50]
["Scottish Borders",17,37,138,15,275,54]
["Orkney",46,47,134,38,201,93]
["East Ayrshire",59,41,49,43,57,100]
["Aberdeen City",47,62,231,37,186,109]
["West Dunbartonshire",47,67,932,39,210,114]
["Clackmannanshire",53,63,76,45,213,116]
["Perth & Kinross",40,76,182,32,434,116]
["Argyll & Bute",47,75,184,37,634,122]
["Inverclyde",58,98,238,50,829,156]
["Highland",103,55,404,71,462,158]
["North Ayrshire",68,103,168,56,609,171]
["East Lothian",61,111,34,45,99,172]
["Scotland",67,131,206,57,614,198]
["Eilean Siar",148,{"$f":"D133-C133","v":56},24,87,13,204]
["East Renfrewshire",108,98,816,71,165,206]
["Edinburgh",92,114,148,76,218,206]
["South Ayrshire",115,93,54,85,386,208]
["East Dunbartonshire",101,147,385,85,616,248]
["North Lanarkshire",151,165,80,122,187,316]
["Stirling",74,259,721,65,98,333]
["Fife",136,204,222,118,277,340]
["West Lothian",122,274,229,107,346,396]
["Midlothian",249,246,224,203,451,495]
["South Lanarkshire",93,617,350,68,142,710]
["Shetland",109,678,266,93,168,787]
["Renfrewshire",37,1070,84,34,39,1107]

{"sheet":"Table 4 - Reasons","index":12,"n_rows":123,"n_cols":21,"rows_kept":123,"cut":false,"hidden":false,"merged":[[2,1,2,10],[74,0,75,0],[34,0,35,0],[66,0,67,0],[34,1,34,10],[66,1,66,10],[74,1,74,10],[2,17,2,20],[34,17,34,19],[66,17,66,20],[74,17,74,19],[2,12,2,15],[66,12,66,15],[74,12,74,14],[34,12,34,14]]}
["Table 4a: Reasons for Approach (Number)","Back to Contents"]
[]
[null,"Quarter of Approach",null,null,null,null,null,null,null,null,null,null,"Bi-annual change",null,null,null,null,"Annual change"]
[null,"2015 Q2","2015 Q3","2015 Q4","2016 Q1","2016 Q2","2016 Q3","2016 Q4","2017 Q1","2017 Q2","2017 Q3",null,"April to Sept 2016","April to Sept 2017","Change","% ",null,"Year to end Sept 2016","Year to end Sept 2017","Change","%"]
["Total",14672,14595,12375,14841,13568,13319,11357,13615,12210,11127,null,{"$f":"SUM(F5:G5)","v":26887},{"$f":"SUM(J5:K5)","v":23337},{"$f":"N5-M5","v":-3550},{"$f":"O5/M5","v":-0.13203406850894484},null,{"$f":"SUM(D5:G5)","v":54103},{"$f":"SUM(H5:K5)","v":48309},{"$f":"S5-R5","v":-5794},{"$f":"T5/R5","v":-0.10709202816849343}]
["General housing options advice",1975,2115,1810,2392,2090,2085,1779,2174,2201,2077,null,{"$f":"SUM(F6:G6)","v":4175},{"$f":"SUM(J6:K6)","v":4278},{"$f":"N6-M6","v":103},{"$f":"O6/M6","v":2.4670658682634732E-2},null,{"$f":"SUM(D6:G6)","v":8377},{"$f":"SUM(H6:K6)","v":8231},{"$f":"S6-R6","v":-146},{"$f":"T6/R6","v":-1.7428673749552346E-2}]
["Asked to leave",2132,2102,1782,2121,1979,1779,1464,1878,1634,1517,null,{"$f":"SUM(F7:G7)","v":3758},{"$f":"SUM(J7:K7)","v":3151},{"$f":"N7-M7","v":-607},{"$f":"O7/M7","v":-0.16152208621607239},null,{"$f":"SUM(D7:G7)","v":7661},{"$f":"SUM(H7:K7)","v":6493},{"$f":"S7-R7","v":-1168},{"$f":"T7/R7","v":-0.15246051429317323}]
["Dispute within household / relationship breakdown: non-violent",1850,1895,1581,1879,1669,1776,1535,1988,1582,1453,null,3445,3035,-410,-0.11901306240928883,null,6905,6558,-347,-5.0253439536567704E-2]
["Risk of losing accommodation",1274,1126,1006,1227,1062,1103,924,1041,949,900,null,2165,1849,-316,-0.14595842956120092,null,4398,3814,-584,-0.13278763074124603]
["Other action by landlord resulting in the termination of the tenancy",1042,1041,819,1122,1127,972,757,1077,951,763,null,2099,1714,-385,-0.18342067651262506,null,4040,3548,-492,-0.12178217821782178]
["Dispute within household: violent or abusive",836,881,780,838,816,789,708,826,785,747,null,1605,1532,-73,-4.5482866043613707E-2,null,3223,3066,-157,-4.8712379770400251E-2]
["Discharge from prison / hospital / care / other institution",674,672,523,586,609,536,546,597,568,470,null,1145,1038,-107,-9.344978165938865E-2,null,2254,2181,-73,-3.2386867790594499E-2]
["Other reason for leaving accommodation / household",473,543,508,505,479,554,411,501,413,434,null,1033,847,-186,-0.18005808325266215,null,2046,1759,-287,-0.14027370478983381]
["Accommodation unsuitable",614,619,433,531,497,639,521,633,582,416,null,1136,998,-138,-0.12147887323943662,null,2100,2152,52,2.4761904761904763E-2]
["Termination of tenancy / mortgage due to rent arrears / default on payments",653,576,561,627,555,458,428,574,464,405,null,1013,869,-144,-0.14215202369200394,null,2201,1871,-330,-0.14993184915947297]
["Other reason for loss of accommodation",314,347,333,408,432,372,369,407,454,373,null,804,827,23,2.8606965174129355E-2,null,1545,1603,58,3.7540453074433655E-2]
["Personal issues – affordability / financial difficulties",388,383,297,368,360,443,479,455,323,304,null,803,627,-176,-0.21917808219178081,null,1468,1561,93,6.3351498637602185E-2]
["Other",735,696,586,666,499,406,243,196,190,198,null,905,388,-517,-0.57127071823204423,null,2157,827,-1330,-0.61659712563745939]
["Harassment",227,208,153,162,180,187,145,182,156,166,null,367,322,-45,-0.1226158038147139,null,682,649,-33,-4.8387096774193547E-2]
["Fleeing non-domestic violence",211,215,175,173,200,131,137,158,161,153,null,331,314,-17,-5.1359516616314202E-2,null,679,609,-70,-0.10309278350515463]
["Overcrowding",254,237,225,256,185,194,155,201,178,146,null,379,324,-55,-0.14511873350923482,null,860,680,-180,-0.20930232558139536]
["Benefit issues & Welfare Reform",248,157,148,183,117,215,188,132,139,127,null,332,266,-66,-0.19879518072289157,null,663,586,-77,-0.11613876319758673]
["Applicant terminated secure accommodation",148,155,131,144,112,149,115,148,135,125,null,261,260,-1,-3.8314176245210726E-3,null,536,523,-13,-2.4253731343283583E-2]
["Household experiencing anti-social behaviour / neighbour problems",104,104,67,94,114,106,92,100,88,93,null,220,181,-39,-0.17727272727272728,null,381,373,-8,-2.0997375328083989E-2]
["Property condition",136,127,139,167,104,98,95,123,74,68,null,202,142,-60,-0.29702970297029702,null,508,360,-148,-0.29133858267716534]
["Loss of service / tied accommodation",61,64,63,59,66,49,34,49,40,57,null,115,97,-18,-0.15652173913043479,null,237,180,-57,-0.24050632911392406]
["Forced division and sale of matrimonial home",69,71,45,63,56,51,37,48,44,49,null,107,93,-14,-0.13084112149532709,null,215,178,-37,-0.17209302325581396]
["Household member needing care",165,182,140,182,176,170,119,62,40,37,null,346,77,-269,-0.7774566473988439,null,668,258,-410,-0.61377245508982037]
["Landlord issue",48,45,34,43,33,30,34,34,25,27,null,63,52,-11,-0.17460317460317459,null,140,120,-20,-0.14285714285714285]
["Emergency (fire, flood, storm, closing order from Environmental Health etc.)",41,34,36,45,51,27,42,31,34,22,null,78,56,-22,-0.28205128205128205,null,159,129,-30,-0.18867924528301888]
[]
[]
["Table 4b: Reasons for Approach (Percent)"]
[]
[null,"Quarter of Approach",null,null,null,null,null,null,null,null,null,null,"Bi-annual change",null,null,null,null,"Annual change"]
[null,"2015 Q2","2015 Q3","2015 Q4","2016 Q1","2016 Q2","2016 Q3","2016 Q4","2017 Q1","2017 Q2","2017 Q3",null,"April to Sept 2016","April to Sept 2017","% change",null,null,"Year to end Sept 2016","Year to end Sept 2017","% change"]
["Total ",{"$f":"B5/B$5","v":1},1,1,1,1,1,1,1,1,1,null,{"$f":"SUM(F37:G37)/2","v":1},{"$f":"SUM(J37:K37)/2","v":1},{"$f":"N37-M37","v":0},null,null,{"$f":"SUM(D37:G37)/4","v":1},{"$f":"SUM(H37:K37)/4","v":1},{"$f":"S37-R37","v":0}]
["General housing options advice",{"$f":"B6/B$5","v":0.1346101417666303},0.14491264131551901,0.14626262626262626,0.16117512297015027,0.15403891509433962,0.1565432840303326,0.15664347979219864,0.15967682702901212,0.18026208026208027,0.18666307180731553,null,{"$f":"SUM(F38:G38)/2","v":0.15529109956233611},{"$f":"SUM(J38:K38)/2","v":0.1834625760346979},{"$f":"N38-M38","v":2.8171476472361789E-2},null,null,{"$f":"SUM(D38:G38)/4","v":0.15450498708936219},{"$f":"SUM(H38:K38)/4","v":0.17081136472265165},{"$f":"S38-R38","v":1.6306377633289459E-2}]
["Dispute within household / relationship breakdown: non-violent",{"$f":"B7/B$5","v":0.14531079607415484},0.14402192531688934,0.14399999999999999,0.14291489791793005,0.14585790094339623,0.13356858623019746,0.12890728185260192,0.13793609988982738,0.13382473382473384,0.13633504089152512,null,{"$f":"SUM(F39:G39)/2","v":0.13971324358679685},{"$f":"SUM(J39:K39)/2","v":0.13507988735812948},{"$f":"N39-M39","v":-4.633356228667368E-3},null,null,0.14158534627288094,0.13425078911467206,-7.334557158208882E-3]
["Asked to leave",{"$f":"B8/B$5","v":0.12609051254089423},0.12983898595409388,0.12775757575757576,0.12660871908901017,0.12301002358490566,0.13334334409490203,0.135158932816765,0.14601542416452443,0.12956592956592958,0.1305832659297205,null,0.12817668383990385,0.13007459774782504,1.8979139079211838E-3,null,null,0.12767991563159839,0.13533088811923488,7.6509724876364926E-3]
["Risk of losing accommodation",{"$f":"B9/B$5","v":8.6832061068702296E-2},7.714970880438507E-2,8.1292929292929292E-2,8.2676369516878914E-2,7.8272405660377353E-2,8.2814025076957731E-2,8.1359513956150389E-2,7.6459786999632753E-2,7.7723177723177717E-2,8.0884335400377455E-2,null,8.0543215368667542E-2,7.9303756561777586E-2,-1.2394588068899565E-3,null,null,8.1263932386785823E-2,7.9106703519834579E-2,-2.1572288669512441E-3]
["Other action by landlord resulting in the termination of the tenancy",{"$f":"B10/B$5","v":7.1019629225736097E-2},7.1325796505652614E-2,6.6181818181818175E-2,7.560137457044673E-2,8.3063089622641514E-2,7.2978451835723407E-2,6.6654926477062601E-2,7.9103929489533598E-2,7.788697788697789E-2,6.8571942122764448E-2,null,7.8020770729182454E-2,7.3229460004871169E-2,-4.7913107243112846E-3,null,null,7.4456183552657457E-2,7.3054443994084645E-2,-1.4017395585728121E-3]
["Dispute within household: violent or abusive",{"$f":"B11/B$5","v":5.6979280261723012E-2},6.0363138060979787E-2,6.3030303030303034E-2,5.6465197762953979E-2,6.0141509433962265E-2,5.9238681582701402E-2,6.2340406797569782E-2,6.0668380462724936E-2,6.4291564291564296E-2,6.7133998382313292E-2,null,5.9690095508331834E-2,6.5712781336938794E-2,6.0226858286069607E-3,null,null,5.9718922952480172E-2,6.3608587483543075E-2,3.889664531062903E-3]
["Accommodation unsuitable",{"$f":"B12/B$5","v":4.5937840785169028E-2},4.60431654676259E-2,4.2262626262626266E-2,3.9485209891516743E-2,4.4885023584905662E-2,4.024326150611908E-2,4.8076076428634325E-2,4.3848696290855672E-2,4.6519246519246521E-2,4.2239597375752676E-2,null,4.2564142545512371E-2,4.4379421947499595E-2,1.8152794019872243E-3,null,null,4.1719030311291941E-2,4.5170904153622293E-2,3.4518738423303524E-3]
["Other reason for leaving accommodation / household",{"$f":"B13/B$5","v":3.2238276990185388E-2},3.7204522096608426E-2,4.1050505050505053E-2,3.4027356647126202E-2,3.530365566037736E-2,4.1594714317891732E-2,3.6189134454521439E-2,3.679764965112009E-2,3.3824733824733826E-2,3.9004223959737579E-2,null,3.8449184989134549E-2,3.6414478892235702E-2,-2.0347060968988473E-3,null,null,3.7994057918975088E-2,3.6453935472528232E-2,-1.5401224464468566E-3]
["Discharge from prison / hospital / care / other institution",{"$f":"B14/B$5","v":4.1848418756815706E-2},4.2411784857828025E-2,3.4989898989898988E-2,3.5779260157671314E-2,3.6630306603773588E-2,4.7976574817929274E-2,4.5874790877872676E-2,4.6492838780756517E-2,4.7665847665847666E-2,3.7386537251730023E-2,null,4.2303440710851431E-2,4.2526192458788845E-2,2.2275174793741359E-4,null,null,3.8844010142318294E-2,4.4355003644051719E-2,5.5109935017334244E-3]
["Other",{"$f":"B15/B$5","v":4.4506543075245368E-2},3.94655704008222E-2,4.5333333333333337E-2,4.2247826965837884E-2,4.0905070754716978E-2,3.4386965988437573E-2,3.7686008629039362E-2,4.2159383033419026E-2,3.8001638001638E-2,3.6397950930169856E-2,null,3.7646018371577272E-2,3.7199794465903928E-2,-4.4622390567334441E-4,null,null,4.0718299260581445E-2,3.8561245148566556E-2,-2.1570541120148889E-3]
["Termination of tenancy / mortgage due to rent arrears / default on payments",{"$f":"B16/B$5","v":2.1401308615049072E-2},2.3775265501884208E-2,2.690909090909091E-2,2.7491408934707903E-2,3.1839622641509434E-2,2.7930024776634883E-2,3.2490974729241874E-2,2.9893499816378993E-2,3.7182637182637181E-2,3.3522063449267545E-2,null,2.988482370907216E-2,3.5352350315952366E-2,5.4675266068802061E-3,null,null,2.854253681548578E-2,3.3272293794381402E-2,4.7297569788956224E-3]
["Personal issues – affordability / financial difficulties",{"$f":"B17/B$5","v":2.6444929116684841E-2},2.6241863651935593E-2,2.4E-2,2.47961727646385E-2,2.6533018867924529E-2,3.3260755311960356E-2,4.2176631152593118E-2,3.3419023136246784E-2,2.6453726453726453E-2,2.7320931068571943E-2,null,2.9896887089942443E-2,2.6887328761149198E-2,-3.0095583287932451E-3,null,null,2.7147486736130849E-2,3.2342577952784578E-2,5.1950912166537286E-3]
["Other reason for loss of accommodation",{"$f":"B18/B$5","v":5.0095419847328244E-2},4.7687564234326824E-2,4.7353535353535356E-2,4.4875682231655549E-2,3.6777712264150941E-2,3.04827689766499E-2,2.1396495553403186E-2,1.4395886889460155E-2,1.5561015561015561E-2,1.7794553788083041E-2,null,3.3630240620400417E-2,1.6677784674549299E-2,-1.6952455945851118E-2,null,null,3.9872424706497933E-2,1.7286987947990488E-2,-2.2585436758507445E-2]
["Benefit issues & Welfare Reform",{"$f":"B19/B$5","v":1.5471646673936751E-2},1.4251455978074683E-2,1.2363636363636363E-2,1.0915706488781079E-2,1.3266509433962265E-2,1.4040093100082588E-2,1.2767456194417539E-2,1.3367609254498715E-2,1.2776412776412777E-2,1.4918666307180731E-2,null,1.3653301267022426E-2,1.3847539541796754E-2,1.9423827477432765E-4,null,null,1.2646486346615575E-2,1.345753613312744E-2,8.110497865118655E-4]
["Overcrowding",{"$f":"B20/B$5","v":1.438113413304253E-2},1.473107228502912E-2,1.4141414141414142E-2,1.1656896435550165E-2,1.4740566037735849E-2,9.8355732412343262E-3,1.2063044818173814E-2,1.1604847594564819E-2,1.3185913185913186E-2,1.3750337018064168E-2,null,1.2288069639485089E-2,1.3468125101988677E-2,1.1800554625035885E-3,null,null,1.2593612463983619E-2,1.2651035654178997E-2,5.7423190195377699E-5]
["Harassment",{"$f":"B21/B$5","v":1.7311886586695746E-2},1.6238437821171636E-2,1.8181818181818181E-2,1.7249511488444176E-2,1.363502358490566E-2,1.4565658082438622E-2,1.3647970414722198E-2,1.4763128901946383E-2,1.4578214578214578E-2,1.3121236631616788E-2,null,1.4100340833672141E-2,1.3849725604915684E-2,-2.5061522875645739E-4,null,null,1.590800283440166E-2,1.4027637631624987E-2,-1.8803652027766724E-3]
["Applicant terminated secure accommodation",{"$f":"B22/B$5","v":1.6902944383860415E-2},1.0757108598835217E-2,1.195959595959596E-2,1.2330705478067515E-2,8.6232311320754724E-3,1.6142353029506718E-2,1.6553667341727567E-2,9.69518912963643E-3,1.1384111384111384E-2,1.1413678439831041E-2,null,1.2382792080791096E-2,1.1398894911971214E-2,-9.8389716881988262E-4,null,null,1.2263971399811415E-2,1.2261661573826606E-2,-2.3098259848090136E-6]
["Household member needing care",{"$f":"B23/B$5","v":1.0087241003271538E-2},1.0620075368276806E-2,1.0585858585858586E-2,9.7028502122498486E-3,8.2547169811320754E-3,1.1187026053006982E-2,1.0125913533503566E-2,1.0870363569592362E-2,1.1056511056511056E-2,1.1233935472274647E-2,null,9.7208715170695285E-3,1.1145223264392851E-2,1.4243517473233221E-3,null,null,9.9326129580618733E-3,1.0821680907970407E-2,8.8906794990853411E-4]
["Fleeing non-domestic violence",{"$f":"B24/B$5","v":7.0883315158124316E-3},7.1257279890373417E-3,5.4141414141414138E-3,6.3338049996630955E-3,8.4021226415094338E-3,7.9585554471056381E-3,8.1007308268028523E-3,7.3448402497245683E-3,7.2072072072072073E-3,8.358047991372337E-3,null,8.1803390443075351E-3,7.7826275992897726E-3,-3.9771144501776247E-4,null,null,7.027156125604896E-3,7.7527065687767408E-3,7.2555044317184486E-4]
["Household experiencing anti-social behaviour / neighbour problems",{"$f":"B25/B$5","v":9.2693565976008727E-3},8.7016101404590613E-3,1.1232323232323232E-2,1.1252611010039755E-2,7.6650943396226415E-3,7.3579097529844579E-3,8.3648850928942503E-3,9.0341535071612189E-3,6.0606060606060606E-3,6.1112608969174078E-3,null,7.5115020463035493E-3,6.0859334787617342E-3,-1.4255685675418151E-3,null,null,9.376984583742521E-3,7.3927263893947348E-3,-1.9842581943477862E-3]
["Property condition",{"$f":"B26/B$5","v":4.1575790621592151E-3},4.3850633778691334E-3,5.0909090909090913E-3,3.9754733508523682E-3,4.86438679245283E-3,3.678954876492229E-3,2.9937483490358368E-3,3.5989717223650387E-3,3.2760032760032762E-3,5.1226745753572391E-3,null,4.2716708344725293E-3,4.1993389256802576E-3,-7.2331908792271603E-5,null,null,4.4024310276766293E-3,3.7478494806903479E-3,-6.5458154698628136E-4]
["Forced division and sale of matrimonial home",{"$f":"B27/B$5","v":4.7028353326063251E-3},4.8646796848235696E-3,3.6363636363636364E-3,4.2449969678593083E-3,4.1273584905660377E-3,3.8291163000225242E-3,3.2579026151272343E-3,3.5255233198677929E-3,3.6036036036036037E-3,4.4037027051316621E-3,null,3.9782373952942807E-3,4.0036531543676326E-3,2.5415759073351904E-5,null,null,3.959458848702877E-3,3.697683060932573E-3,-2.6177578777030397E-4]
["Loss of service / tied accommodation",{"$f":"B28/B$5","v":1.1245910577971646E-2},1.2470023980815348E-2,1.1313131313131313E-2,1.226332457381578E-2,1.2971698113207548E-2,1.2763721000075081E-2,1.0478119221625429E-2,4.5538009548292324E-3,3.2760032760032762E-3,3.3252448997932956E-3,null,1.2867709556641314E-2,3.3006240878982861E-3,-9.5670854687430282E-3,null,null,1.2327968750057431E-2,5.4082920880628082E-3,-6.9196766619946228E-3]
["Landlord issue",{"$f":"B29/B$5","v":3.2715376226826608E-3},3.0832476875642342E-3,2.7474747474747476E-3,2.8973788828246076E-3,2.432193396226415E-3,2.2524213529544262E-3,2.9937483490358368E-3,2.4972456849063534E-3,2.0475020475020475E-3,2.4265300620113237E-3,null,2.3423073745904204E-3,2.2370160547566858E-3,-1.0529131983373456E-4,null,null,2.5823670948700488E-3,2.4912565358638904E-3,-9.1110559006158352E-5]
["Emergency (fire, flood, storm, closing order from Environmental Health etc.)",{"$f":"B30/B$5","v":2.7944383860414395E-3},2.3295649194929771E-3,2.9090909090909089E-3,3.0321406913280777E-3,3.7588443396226415E-3,2.0271792176589833E-3,3.6981597252795633E-3,2.2769004774146162E-3,2.7846027846027844E-3,1.9771726431203379E-3,null,2.8930117786408124E-3,2.3808877138615609E-3,-5.1212406477925149E-4,null,null,2.931813789425153E-3,2.6842089076043255E-3,-2.4760488182082752E-4]
[]
[]
["Table 4c: Reasons for Approach - abbreviated (Number)"]
[]
[null,"Quarter of Approach",null,null,null,null,null,null,null,null,null,null,"Bi-annual change",null,null,null,null,"Annual change"]
[null,"2015 Q2","2015 Q3","2015 Q4","2016 Q1","2016 Q2","2016 Q3","2016 Q4","2017 Q1","2017 Q2","2017 Q3",null,"April - Sept 2016","April - Sept 2017","Change","% ",null,"Year to end Sept 2016","Year to end Sept 2017","Change","%"]
["Homelessness Type",8985,9041,7715,8988,8516,8024,6883,8665,7599,6880,null,{"$f":"SUM(F69:G69)","v":16540},{"$f":"SUM(J69:K69)","v":14479},{"$f":"N69-M69","v":-2061},{"$f":"O69/M69","v":-0.12460701330108827},null,{"$f":"SUM(D69:G69)","v":33243},{"$f":"SUM(H69:K69)","v":30027},{"$f":"S69-R69","v":-3216},{"$f":"T69/R69","v":-9.6742171284180126E-2}]
["Prevention Type",5687,5554,4660,5853,5052,5295,4474,4950,4611,4247,null,{"$f":"SUM(F70:G70)","v":10347},{"$f":"SUM(J70:K70)","v":8858},{"$f":"N70-M70","v":-1489},{"$f":"O70/M70","v":-0.14390644631294094},null,{"$f":"SUM(D70:G70)","v":20860},{"$f":"SUM(H70:K70)","v":18282},{"$f":"S70-R70","v":-2578},{"$f":"T70/R70","v":-0.12358581016299137}]
["Total",14672,14595,12375,14841,13568,13319,11357,13615,12210,11127,null,{"$f":"SUM(F71:G71)","v":26887},{"$f":"SUM(J71:K71)","v":23337},-3550,-0.13203406850894484,null,54103,48309,-5794,-0.10709202816849343]
[]
["Table 4d: Reasons for Approach - abbreviated (Percent)"]
[]
[null,"Quarter of Approach",null,null,null,null,null,null,null,null,null,null,"Bi-annual change",null,null,null,null,"Annual change"]
[null,"2015 Q2","2015 Q3","2015 Q4","2016 Q1","2016 Q2","2016 Q3","2016 Q4","2017 Q1","2017 Q2","2017 Q3",null,"April - Sept 2016","April - Sept 2017","% Change",null,null,"Year to end Sept 2016","Year to end Sept 2017","% Change"]
["Homelessness Type",{"$f":"B69/B$71","v":0.6123909487459106},{"$f":"C69/C$71","v":0.61945871873929426},0.62343434343434345,0.60561956741459466,0.62765330188679247,{"$f":"G69/G$71","v":0.60244763120354383},{"$f":"H69/H$71","v":0.60605793783569606},{"$f":"I69/I$71","v":0.6364304076386339},{"$f":"J69/J$71","v":0.62235872235872236},{"$f":"K69/K$71","v":0.61831580839399658},null,{"$f":"SUM(F77:G77)/2","v":0.61505046654516815},{"$f":"SUM(J77:K77)/2","v":0.62033726537635947},{"$f":"N77-M77","v":5.2867988311913194E-3},null,null,{"$f":"SUM(D77:G77)/4","v":0.61478871098481858},{"$f":"SUM(H77:K77)/4","v":0.6207907190567622},{"$f":"S77-R77","v":6.0020080719436208E-3}]
["Prevention Type",{"$f":"B70/B$71","v":0.3876090512540894},0.38054128126070574,0.37656565656565655,0.39438043258540528,0.37234669811320753,0.39755236879645617,{"$f":"H70/H$71","v":0.39394206216430394},{"$f":"I70/I$71","v":0.36356959236136616},0.37764127764127764,0.38168419160600342,null,{"$f":"SUM(F78:G78)/2","v":0.38494953345483185},{"$f":"SUM(J78:K78)/2","v":0.37966273462364053},{"$f":"N78-M78","v":-5.2867988311913194E-3},null,null,{"$f":"SUM(D78:G78)/4","v":0.38521128901518137},{"$f":"SUM(H78:K78)/4","v":0.3792092809432378},{"$f":"S78-R78","v":-6.0020080719435653E-3}]
["Total",1,1,1,1,1,1,{"$f":"H71/H$71","v":1},{"$f":"I71/I$71","v":1},1,1,null,1,1,{"$f":"N79-M79","v":0},null,null,1,1,0]
[]
["Notes"]
["Homeless Type Reasons as defined as:","Termination of tenancy / mortgage due to rent arrears / default on payments"]
[null,"Other action by landlord resulting in the termination of the tenancy"]
[null,"Applicant terminated secure accommodation"]
[null,"Loss of service / tied accommodation"]
[null,"Discharge from prison / hospital / care / other institution"]
[null,"Emergency (fire, flood, storm, closing order from Environmental Health etc.)"]
[null,"Forced division and sale of matrimonial home"]
[null,"Other reason for loss of accommodation"]
[null,"Reasons for having to leave accommodation / household"]
[null,"Dispute within household: violent or abusive"]
[null,"Dispute within household / relationship breakdown: non-violent"]
[null,"Fleeing non-domestic violence"]
[null,"Harassment"]
[null,"Overcrowding"]
[null,"Asked to leave"]
[null,"Other reason for leaving accommodation / household"]
[]
[]
["Prevention Type Reasons are defined as:","General housing options advice"]
[null,"Benefit issues (excluding Welfare Reform)"]
[null,"Welfare Reform – Benefit Cap"]
[null,"Welfare Reform – Under-occupancy penalty"]
[null,"Welfare Reform - Other"]
[null,"Property condition - disrepair"]
[null,"Property condition – lacking amenities"]
[null,"Property condition – fire/flood"]
[null,"Accommodation unsuitable - Overcrowded"]
[null,"Accommodation unsuitable – Mobility/ Adaptation Issues"]
[null,"Accommodation unsuitable – Location"]
[null,"Household experiencing anti-social behaviour / neighbour problems"]
[null,"Household experiencing hate crime"]
[null,"Household member needing care"]
[null,"Personal issues – affordability / financial difficulties"]
[null,"Risk of losing accommodation  - eviction/ repossession"]
[null,"Risk of losing accommodation  - eviction from UK Borders Agency (or successor organisation) accommodation"]
[null,"Risk of losing accommodation  - tied/ service tenancy"]
[null,"Risk of losing accommodation  - asked to leave - parents"]
[null,"Risk of losing accommodation  - asked to leave – other family"]
[null,"Risk of losing accommodation  - asked to leave – friends"]
[null,"Landlord issue - Harassment from private sector landlord"]
[null,"Landlord issue - Illegal eviction – private sector landlord"]
[null,"Other"]

{"sheet":"Chart 4 - Approach Reasons","index":13,"n_rows":1,"n_cols":12,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
["Chart 4: Percentage of Approaches by Reason for Approach",null,null,null,null,null,null,null,null,null,null,"Back to Contents"]

{"sheet":"Table 5 - Maximum Activty Type","index":14,"n_rows":17,"n_cols":21,"rows_kept":17,"cut":false,"hidden":false,"merged":[[2,1,2,10],[11,1,11,10],[2,12,2,15],[11,12,11,14],[2,17,2,20],[11,17,11,19]]}
["Table 5a: Maximum Activity Type (Number)","Back to Contents"]
[]
[null,"Quarter of Approach",null,null,null,null,null,null,null,null,null,null,"Bi-annual change",null,null,null,null,"Annual change"]
["Activity type","2015 Q2","2015 Q3","2015 Q4","2016 Q1","2016 Q2","2016 Q3","2016 Q4","2017 Q1","2017 Q2","2017 Q3",null,"April to Sept 2016","April to Sept 2017","Change","% ",null,"Year to end Sept 2016","Year to end Sept 2017","Change","%"]
["Type I – Active Information, Sign-posting and Explanation",8291,7935,6665,8133,7428,7072,6127,7466,6965,6355,null,{"$f":"SUM(F5:G5)","v":14500},{"$f":"SUM(J5:K5)","v":13320},{"$f":"N5-M5","v":-1180},{"$f":"O5/M5","v":-8.137931034482758E-2},null,{"$f":"SUM(D5:G5)","v":29298},{"$f":"SUM(H5:K5)","v":26913},{"$f":"S5-R5","v":-2385},{"$f":"T5/R5","v":-8.1404874052836376E-2}]
["Type II – Casework",6349,6620,5683,6666,6073,6177,5152,6070,5169,4707,null,{"$f":"SUM(F6:G6)","v":12250},{"$f":"SUM(J6:K6)","v":9876},{"$f":"N6-M6","v":-2374},{"$f":"O6/M6","v":-0.19379591836734694},null,{"$f":"SUM(D6:G6)","v":24599},{"$f":"SUM(H6:K6)","v":21098},{"$f":"S6-R6","v":-3501},{"$f":"T6/R6","v":-0.14232285865279076}]
["Type III – Advocacy, Representation and Mediation at Tribunal or Court Action Level",32,40,27,42,67,70,78,79,76,65,null,137,141,4,2.9197080291970802E-2,null,206,298,92,0.44660194174757284]
["Total",14672,14595,12375,14841,13568,13319,11357,13615,12210,11127,null,{"$f":"SUM(F8:G8)","v":26887},{"$f":"SUM(J8:K8)","v":23337},{"$f":"N8-M8","v":-3550},{"$f":"O8/M8","v":-0.13203406850894484},null,54103,48309,-5794,-0.10709202816849343]
[]
["Table 5b: Maximum Activity Type (Percent)"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Bi-annual change",null,null,null,null,"Annual change"]
["Activity type (Percentage)","2015 Q2","2015 Q3","2015 Q4","2016 Q1","2016 Q2","2016 Q3","2016 Q4","2017 Q1","2017 Q2","2017 Q3",null,"April to Sept 2016","April to Sept 2017","% change",null,null,"Year to end Sept 2016","Year to end Sept 2017","% change"]
["Type I – Active Information, Sign-posting and Explanation",{"$f":"B5/B$8","v":0.5650899672846238},{"$f":"C5/C$8","v":0.5436793422404933},0.53858585858585861,0.54800889427936128,0.54746462264150941,0.53097079360312338,{"$f":"H5/H$8","v":0.53949106278066394},{"$f":"I5/I$8","v":0.54836577304443623},{"$f":"J5/J$8","v":0.57043407043407046},0.57113327941044312,null,{"$f":"SUM(F14:G14)/2","v":0.5392177081223164},{"$f":"SUM(J14:K14)/2","v":0.57078367492225679},{"$f":"N14-M14","v":3.1565966799940393E-2},null,null,{"$f":"SUM(D14:G14)/4","v":0.54125754227746314},{"$f":"SUM(H14:K14)/4","v":0.55735604641740344},{"$f":"S14-R14","v":1.6098504139940295E-2}]
["Type II – Casework",{"$f":"B6/B$8","v":0.43272900763358779},0.45357999314833847,0.45923232323232321,0.44916110774206591,0.44759728773584906,0.46377355657331631,{"$f":"H6/H$8","v":0.45364092630095976},{"$f":"I6/I$8","v":0.4458318031582813},0.42334152334152336,0.42302507414397411,null,{"$f":"SUM(F15:G15)/2","v":0.45568542215458269},{"$f":"SUM(J15:K15)/2","v":0.42318329874274874},{"$f":"N15-M15","v":-3.250212341183395E-2},null,null,{"$f":"SUM(D15:G15)/4","v":0.45494106882088864},{"$f":"SUM(H15:K15)/4","v":0.43645983173618463},{"$f":"S15-R15","v":-1.8481237084704005E-2}]
["Type III – Advocacy, Representation and Mediation at Tribunal or Court Action Level",{"$f":"B7/B$8","v":2.1810250817884407E-3},2.7406646111682084E-3,2.1818181818181819E-3,2.8299979785728724E-3,4.9380896226415092E-3,5.255649823560327E-3,{"$f":"H7/H$8","v":6.8680109183763315E-3},{"$f":"I7/I$8","v":5.8024237972824095E-3},6.2244062244062245E-3,5.841646445582817E-3,null,5.0968697231009181E-3,6.0330263349945203E-3,9.3615661189360225E-4,null,null,3.8013889016482228E-3,6.1841218464119456E-3,2.3827329447637228E-3]
["Total",{"$f":"B8/B$8","v":1},1,1,1,1,1,{"$f":"H8/H$8","v":1},{"$f":"I8/I$8","v":1},1,1,null,{"$f":"SUM(J17:K17)/2","v":1},{"$f":"SUM(G17:H17)/2","v":1},0,null,null,{"$f":"SUM(D17:G17)/4","v":1},{"$f":"SUM(H17:K17)/4","v":1},0]

{"sheet":"Chart 5 - Activities Type by Q","index":15,"n_rows":1,"n_cols":14,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
["Chart 5: Percentage of Approaches with each level of activity type by quarter",null,null,null,null,null,null,null,null,null,null,null,null,"Back to Contents"]

{"sheet":"Table 6 - Activities","index":16,"n_rows":52,"n_cols":21,"rows_kept":52,"cut":false,"hidden":false,"merged":[[2,17,2,20],[19,17,19,19],[47,1,47,10],[2,12,2,15],[19,12,19,14],[2,1,2,10],[19,1,19,10],[47,12,48,12],[47,13,48,13],[47,14,48,14],[46,12,46,14]]}
["Table 6a: Housing Options activities by quarter (number)",null,null,"Back to Contents"]
[]
[null,"Quarter of Approach",null,null,null,null,null,null,null,null,null,null,"Bi-annual change",null,null,null,null,"Annual change"]
["Activity type","2015 Q2","2015 Q3","2015 Q4","2016 Q1","2016 Q2","2016 Q3","2016 Q4","2017 Q1","2017 Q2","2017 Q3",null,"April to Sept 2016","April to Sept 2017","Change","% ",null,"Year to end Sept 2016","Year to end Sept 2017","Change","%"]
["General Housing advice/Tenancy rights advice",12462,12712,10400,12594,11084,10662,8906,10934,9839,8499,null,{"$f":"SUM(F5:G5)","v":21746},{"$f":"SUM(J5:K5)","v":18338},{"$f":"N5-M5","v":-3408},{"$f":"O5/M5","v":-0.15671847696128025},null,{"$f":"SUM(D5:G5)","v":44740},{"$f":"SUM(H5:K5)","v":38178},{"$f":"S5-R5","v":-6562},{"$f":"T5/R5","v":-0.14666964684845776}]
["Client informed of rights under homelessness legislation",7814,7839,6827,8103,7466,7110,6138,7739,6806,6294,null,14576,13100,{"$f":"N6-M6","v":-1476},{"$f":"O6/M6","v":-0.10126234906695938},null,{"$f":"SUM(D6:G6)","v":29506},{"$f":"SUM(H6:K6)","v":26977},{"$f":"S6-R6","v":-2529},{"$f":"T6/R6","v":-8.5711380736121473E-2}]
["Rent/repairs/referrals/negotiation with landlords",2246,2315,1765,1850,1679,1778,1464,1741,1588,1514,null,3457,3102,-355,-0.10269019380966156,null,7072,6307,-765,-0.10817307692307693]
["Help to move property",1874,2008,1601,2000,2028,2154,1702,2173,1958,1443,null,4182,3401,-781,-0.18675274988043999,null,7783,7276,-507,-6.5141976101760243E-2]
["Other",1611,1642,1393,1696,1546,1686,1437,1455,1113,1414,null,3232,2527,-705,-0.21813118811881188,null,6321,5419,-902,-0.14269894004113273]
["Financial assistance/advice",2439,2474,2059,2147,2007,2193,1822,1814,1593,1357,null,4200,2950,-1250,-0.29761904761904762,null,8406,6586,-1820,-0.21651201522721866]
["Referral to health/Social Work/employment services",795,958,717,836,805,882,734,825,837,760,null,1687,1597,-90,-5.3349140486069944E-2,null,3240,3156,-84,-2.5925925925925925E-2]
["Help to remain in accommodation",693,774,566,732,616,736,560,564,579,417,null,1352,996,-356,-0.26331360946745563,null,2650,2120,-530,-0.2]
["Tenancy/social care support/adaptations to property",372,340,343,419,377,342,251,343,419,382,null,719,801,82,0.11404728789986092,null,1481,1395,-86,-5.8068872383524643E-2]
["Mediation/outreach work",397,393,339,440,414,475,342,416,315,252,null,889,567,-322,-0.36220472440944884,null,1668,1325,-343,-0.20563549160671463]
["Mortgage/home ownership advice",164,154,99,131,97,91,68,103,86,65,null,188,151,-37,-0.19680851063829788,null,418,322,-96,-0.22966507177033493]
["Total (ALL)",30867,31609,26109,30948,28119,28109,23424,28107,25133,22397,null,56228,47530,-8698,-0.15469161271964146,null,113285,99061,-14224,-0.12555942975680806]
[]
["Table 6b: Housing Options activities by quarter (percent)"]
[]
[null,"Quarter of Approach",null,null,null,null,null,null,null,null,null,null,"Bi-annual change",null,null,null,null,"Annual change"]
["Activity Type","2015 Q2","2015 Q3","2015 Q4","2016 Q1","2016 Q2","2016 Q3","2016 Q4","2017 Q1","2017 Q2","2017 Q3",null,"April to Sept 2016","April to Sept 2017","% change",null,null,"Year to end Sept 2016","Year to end Sept 2017","% change"]
["General Housing advice/Tenancy rights advice",{"$f":"B5/B$16","v":0.40373214112158617},{"$f":"C5/C$16","v":0.40216394064981492},0.39833007775096713,0.40694067468010858,0.39418186991002524,0.37930911807606105,{"$f":"H5/H$16","v":0.38020833333333331},{"$f":"I5/I$16","v":0.38901341302878284},0.39147734054828315,0.37947046479439211,null,{"$f":"SUM(F22:G22)/2","v":0.38674549399304314},{"$f":"SUM(J22:K22)/2","v":0.38547390267133763},{"$f":"N22-M22","v":-1.2715913217055119E-3},null,null,{"$f":"SUM(D22:G22)/4","v":0.39469043510429047},{"$f":"SUM(H22:K22)/4","v":0.38504238792619783},{"$f":"S22-R22","v":-9.6480471780926447E-3}]
["Client informed of rights under homelessness legislation",{"$f":"B6/B$16","v":0.2531506139242557},0.24799898763010536,0.26148071546210117,0.26182628925940288,0.26551442085422666,0.25294389697249992,{"$f":"H6/H$16","v":0.2620389344262295},{"$f":"I6/I$16","v":0.27534066246842426},0.2707993474714519,0.28101977943474571,null,0.25922915891336329,0.27590956345309881,{"$f":"N23-M23","v":1.6680404539735516E-2},null,null,{"$f":"SUM(D23:G23)/4","v":0.26044133063705766},{"$f":"SUM(H23:K23)/4","v":0.27229968095021284},{"$f":"S23-R23","v":1.1858350313155186E-2}]
["Financial assistance/advice",{"$f":"B7/B$16","v":7.2763793047591285E-2},7.3238634566104591E-2,6.7601210310620857E-2,5.9777691611735816E-2,5.9710516021195634E-2,6.3253762140239783E-2,{"$f":"H7/H$16","v":6.25E-2},{"$f":"I7/I$16","v":6.1941865015832355E-2},6.3183861854931758E-2,6.7598339063267399E-2,null,6.1482139080717708E-2,6.5391100459099571E-2,3.908961378381863E-3,null,null,6.2585795020948021E-2,6.380601648350788E-2,1.220221462559859E-3]
["Help to move property",{"$f":"B8/B$16","v":6.0712087342469301E-2},6.3526210889303686E-2,6.1319851392240221E-2,6.4624531472146821E-2,7.2122052704576972E-2,7.6630260770571709E-2,{"$f":"H8/H$16","v":7.2660519125683054E-2},{"$f":"I8/I$16","v":7.731170171131746E-2},7.7905542513826448E-2,6.4428271643523688E-2,null,7.4376156737574334E-2,7.1166907078675068E-2,-3.2092496588992658E-3,null,null,6.8674174084883924E-2,7.3076508748587662E-2,4.4023346637037386E-3]
["Rent/repairs/referrals/negotiation with landlords",{"$f":"B9/B$16","v":5.2191660997181456E-2},5.1947230219241358E-2,5.3353249837220881E-2,5.480160268838051E-2,5.4980618087414203E-2,5.9980789071116015E-2,{"$f":"H9/H$16","v":6.1347336065573771E-2},{"$f":"I9/I$16","v":5.1766463870210271E-2},4.4284406954999404E-2,6.3133455373487524E-2,null,5.7480703579265109E-2,5.3708931164243467E-2,-3.7717724150216417E-3,null,null,5.5779064921032899E-2,5.5132915566067746E-2,-6.4614935496515313E-4]
["Other",{"$f":"B10/B$16","v":7.9016425308581981E-2},7.8268847480148063E-2,7.8861695200888579E-2,6.9374434535349624E-2,7.1375226715032547E-2,7.801771674552635E-2,{"$f":"H10/H$16","v":7.7783469945355191E-2},{"$f":"I10/I$16","v":6.4539082790763869E-2},6.338280348545737E-2,6.0588471670312991E-2,null,7.4696471730279448E-2,6.198563757788518E-2,-1.2710834152394268E-2,null,null,7.4407268299199275E-2,6.6573456972972359E-2,-7.8338113262269166E-3]
["Referral to health/Social Work/employment services",{"$f":"B11/B$16","v":2.5755661385946156E-2},3.0307823721092093E-2,2.746179478340802E-2,2.7013054155357374E-2,2.8628329599203386E-2,3.1377850510512645E-2,{"$f":"H11/H$16","v":3.1335382513661199E-2},{"$f":"I11/I$16","v":2.9352118689294483E-2},3.3302828949986076E-2,3.3933116042327099E-2,null,3.0003090054858017E-2,3.3617972496156584E-2,3.614882441298567E-3,null,null,2.8620257262120356E-2,3.1980861548817213E-2,3.3606042866968569E-3]
["Help to remain in accommodation",{"$f":"B12/B$16","v":2.2451161434541744E-2},2.4486696826853113E-2,2.1678348462216095E-2,2.3652578518805738E-2,2.1906895693303459E-2,2.6183784552990145E-2,{"$f":"H12/H$16","v":2.3907103825136611E-2},{"$f":"I12/I$16","v":2.0066175685772229E-2},2.3037440814864918E-2,1.8618564986382105E-2,null,2.4045340123146804E-2,2.0828002900623512E-2,-3.2173372225232921E-3,null,null,2.3355401806828859E-2,2.1407321328038968E-2,-1.948080478789891E-3]
["Mediation/outreach work",{"$f":"B13/B$16","v":1.2051705705121974E-2},1.075643013065899E-2,1.3137232371979011E-2,1.3538839343414761E-2,1.3407304669440592E-2,1.2166921626525311E-2,{"$f":"H13/H$16","v":1.0715505464480874E-2},{"$f":"I13/I$16","v":1.2203365709609705E-2},1.6671308638045598E-2,1.7055855694959147E-2,null,1.2787113147982952E-2,1.6863582166502373E-2,4.0764690185194213E-3,null,null,1.3062574502839919E-2,1.4161508876773832E-2,1.0989343739339127E-3]
["Tenancy/social care support/adaptations to property",{"$f":"B14/B$16","v":1.2861632163799527E-2},1.2433167768673479E-2,1.2984028495920947E-2,1.4217396923872302E-2,1.4723140936733169E-2,1.6898502259062934E-2,{"$f":"H14/H$16","v":1.4600409836065574E-2},{"$f":"I14/I$16","v":1.4800583484541217E-2},1.2533322723113039E-2,1.1251506898245301E-2,null,1.5810821597898053E-2,1.189241481067917E-2,-3.9184067872188831E-3,null,null,1.4705767153897337E-2,1.3296455735491283E-2,-1.4093114184060545E-3]
["Mortgage/home ownership advice",{"$f":"B15/B$16","v":5.3131175689247415E-3},4.8720301180043661E-3,3.7917959324370908E-3,4.2329068114256175E-3,3.4496248088481097E-3,3.2373972748941621E-3,{"$f":"H15/H$16","v":2.9030054644808745E-3},{"$f":"I15/I$16","v":3.6645675454513109E-3},3.421796045040385E-3,2.902174398356923E-3,null,3.3435110418711359E-3,3.1619852216986542E-3,-1.8152582017248167E-4,null,null,3.6779312069012454E-3,3.222885863332373E-3,-4.5504534356887241E-4]
["Total (ALL)",{"$f":"B16/B$16","v":1},1,1,1,1,1,{"$f":"H16/H$16","v":1},{"$f":"I16/I$16","v":1},1,1,null,1,1,0,null,null,1,1,0]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Data for chart"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Bi-annual change"]
[null,"Quarter of Approach",null,null,null,null,null,null,null,null,null,null,"April to Sept 2016","April to Sept 2017","% change"]
[null,"2015 Q2","2015 Q3","2015 Q4","2016 Q1","2016 Q2","2016 Q3","2016 Q4","2017 Q1","2017 Q2","2017 Q3"]
[{"$f":"A22","v":"General Housing advice/Tenancy rights advice"},{"$f":"B22","v":0.40373214112158617},{"$f":"C22","v":0.40216394064981492},0.39833007775096713,0.40694067468010858,0.39418186991002524,0.37930911807606105,0.38020833333333331,0.38901341302878284,0.39147734054828315,0.37947046479439211,null,{"$f":"SUM(F50:G50)/2","v":0.38674549399304314},{"$f":"SUM(J50:K50)/2","v":0.38547390267133763},{"$f":"N50-M50","v":-1.2715913217055119E-3}]
[{"$f":"A23","v":"Client informed of rights under homelessness legislation"},{"$f":"B23","v":0.2531506139242557},{"$f":"C23","v":0.24799898763010536},0.26148071546210117,0.26182628925940288,0.26551442085422666,0.25294389697249992,0.2620389344262295,0.27534066246842426,0.2707993474714519,0.28101977943474571,null,{"$f":"SUM(F51:G51)/2","v":0.25922915891336329},{"$f":"SUM(J51:K51)/2","v":0.27590956345309881},{"$f":"N51-M51","v":1.6680404539735516E-2}]
["Other Activity",{"$f":"SUM(B24:B32)","v":0.34311724495415813},{"$f":"SUM(C24:C32)","v":0.34983707172007972},0.34018920678693176,0.33123303606048859,0.34030370923574793,0.36774698495143898,0.35775273224043713,0.33564592450279296,0.33772331198026506,0.33950975577086212,null,0.35402534709359346,0.33861653387556356,-1.5408813218029893E-2]

{"sheet":"Chart 6 - Activities","index":17,"n_rows":1,"n_cols":14,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
["Chart 6: Housing Options Actvities by quarter",null,null,null,null,null,null,null,null,null,null,null,null,"Back to Contents"]

{"sheet":"Table 7 - Activities by LA","index":18,"n_rows":121,"n_cols":16,"rows_kept":121,"cut":false,"hidden":false,"merged":[[2,1,2,11],[2,12,3,12],[43,1,43,11],[43,12,44,12],[43,0,44,0],[2,0,3,0]]}
["Table 7a: Housing Options activities by Local Authority, during the last 6 months, 1 April to 30 September 2017 (number)",null,null,null,null,null,null,null,null,null,null,"Back to Contents"]
[]
["Local Authority","ACTIVITY",null,null,null,null,null,null,null,null,null,null,"All"]
[null,"Mediation/outreach work","Financial assistance/advice","Rent/repairs/referrals/negotiation with landlords","Help to remain in accommodation","Mortgage/home ownership advice","Tenancy/social care support/adaptations to property","Referral to health/Social Work/employment services","Client informed of rights under homelessness legislation","General Housing advice/Tenancy rights advice","Help to move property","Other",null,null,"All other activities","NB: This includes all categories apart from 'Client informed of rights under homelessness legislation' and 'General Housing Advice'"]
["Scotland",565,2950,3100,995,150,800,1595,13100,18340,3400,2525,47530,null,{"$f":"SUM(B5:H5,K5:L5)","v":16080}]
["Aberdeen City",20,35,20,90,5,5,25,740,1145,190,0,2275,null,390]
["Aberdeenshire",20,210,265,20,10,5,20,630,895,5,20,2095,null,575]
["Angus",5,225,80,35,5,25,10,280,430,280,0,1375,null,665]
["Argyll & Bute",5,25,60,130,0,40,5,435,610,90,5,1405,null,360]
["Clackmannanshire",0,0,10,0,0,0,0,275,245,20,0,550,null,30]
["Dumfries & Galloway",0,15,40,10,0,85,25,455,480,150,10,1275,null,335]
["Dundee City",10,10,30,10,0,5,5,595,680,65,20,1430,null,155]
["East Ayrshire",0,55,40,5,20,20,15,30,35,5,0,230,null,160]
["East Dunbartonshire",0,95,70,10,5,5,5,130,135,150,0,605,null,340]
["East Lothian",0,25,60,15,5,0,0,45,75,55,5,285,null,165]
["East Renfrewshire",0,25,25,5,5,5,10,60,50,5,0,190,null,80]
["Edinburgh",0,95,45,5,5,0,45,825,1685,15,15,2740,null,225]
["Eilean Siar",0,0,0,0,0,0,0,0,0,0,0,5,null,0]
["Falkirk",330,970,75,460,0,50,485,1020,1230,755,1490,6865,null,4615]
["Fife",30,145,430,35,50,30,70,1105,1455,265,55,3675,null,1110]
["Glasgow City",10,70,80,50,0,0,635,1795,2265,25,0,4940,null,870]
["Highland",0,5,5,5,5,0,0,65,95,0,0,190,null,20]
["Inverclyde",0,5,0,5,0,0,5,235,320,20,5,595,null,40]
["Midlothian",15,25,15,0,0,5,0,125,235,30,110,565,null,200]
["Moray",25,65,30,5,0,10,15,430,530,105,125,1335,null,380]
["North Ayrshire",0,75,725,10,5,0,5,790,850,10,5,2470,null,835]
["North Lanarkshire",5,260,140,30,5,110,35,200,980,35,85,1880,null,705]
["Orkney",0,0,0,0,0,0,0,10,20,0,0,30,null,0]
["Perth & Kinross",10,20,235,0,0,0,5,425,725,5,75,1505,null,350]
["Renfrewshire",55,295,175,10,5,75,70,765,945,280,40,2720,null,1005]
["Scottish Borders",0,30,55,0,0,45,5,225,280,115,0,755,null,250]
["Shetland",0,5,0,0,0,0,0,95,110,0,0,225,null,5]
["South Ayrshire",10,45,230,10,5,280,95,405,630,230,445,2385,null,1350]
["South Lanarkshire",5,65,110,10,0,0,0,380,500,420,0,1495,null,610]
["Stirling",0,5,10,0,0,0,0,40,165,5,0,225,null,20]
["West Dunbartonshire",0,30,25,15,5,0,0,105,85,50,0,320,null,125]
["West Lothian",0,15,30,5,5,0,5,380,445,20,0,905,null,80]
[]
["Disclosure Control has been applied to this table.  All cells have been rounded to the nearest five."]
["Column totals may not sum to total of individual cells due to rounding."]
[]
["Table 7b: Housing Options activities by Local Authority, during the last 6 months, 1 April 2016 to 30 September 2016 (percent)"]
[]
["Local Authority","ACTIVITY",null,null,null,null,null,null,null,null,null,null,"All"]
[null,"Mediation/\noutreach work","Financial assistance/\nadvice","Rent/repairs/\nreferrals/\nnegotiation with landlords","Help to\n remain in \naccommodation","Mortgage/\nhome ownership advice","Tenancy/\nsocial care support/\nadaptations to property","Referral to health/Social Work/\nemployment services","Client informed of rights under homelessness legislation","General Housing advice/\nTenancy rights advice","Help to move property","Other",null,null,"All other activities"]
["Scotland",{"$f":"B5/$M5","v":1.1887229118451505E-2},{"$f":"C5/$M5","v":6.2066063538817585E-2},6.5221965074689664E-2,2.0934146854618137E-2,3.1559015358720807E-3,1.6831474857984433E-2,3.3557752998106462E-2,0.27561540079949504,0.38586156111929309,7.1533768146433835E-2,{"$f":"L5/$M5","v":5.312434252051336E-2},{"$f":"SUM(B46,C46,D46,E46,F46,G46,H46,I46,J46,K46,L46)","v":0.99978960656427518},null,{"$f":"O5/$M5","v":0.33831264464548705}]
["Aberdeen City",{"$f":"B6/$M6","v":8.7912087912087912E-3},1.5384615384615385E-2,8.7912087912087912E-3,3.9560439560439559E-2,2.1978021978021978E-3,2.1978021978021978E-3,1.098901098901099E-2,0.32527472527472528,0.50329670329670328,8.3516483516483511E-2,0,{"$f":"SUM(B47,C47,D47,E47,F47,G47,H47,I47,J47,K47,L47)","v":1},null,0.17142857142857143]
["Aberdeenshire",{"$f":"B7/$M7","v":9.5465393794749408E-3},0.10023866348448687,0.12649164677804295,9.5465393794749408E-3,4.7732696897374704E-3,2.3866348448687352E-3,9.5465393794749408E-3,0.30071599045346065,0.42720763723150357,2.3866348448687352E-3,9.5465393794749408E-3,1.0023866348448687,null,0.27446300715990452]
["Angus",{"$f":"B8/$M8","v":3.6363636363636364E-3},0.16363636363636364,5.8181818181818182E-2,2.5454545454545455E-2,3.6363636363636364E-3,1.8181818181818181E-2,7.2727272727272727E-3,0.20363636363636364,0.31272727272727274,0.20363636363636364,0,1,null,0.48363636363636364]
["Argyll & Bute",{"$f":"B9/$M9","v":3.5587188612099642E-3},1.7793594306049824E-2,4.2704626334519574E-2,9.2526690391459068E-2,0,2.8469750889679714E-2,3.5587188612099642E-3,0.30960854092526691,0.43416370106761565,6.4056939501779361E-2,3.5587188612099642E-3,0.99999999999999989,null,0.25622775800711745]
["Clackmannanshire",{"$f":"B10/$M10","v":0},0,1.8181818181818181E-2,0,0,0,0,0.5,0.44545454545454544,3.6363636363636362E-2,0,1,null,5.4545454545454543E-2]
["Dumfries & Galloway",{"$f":"B11/$M11","v":0},1.1764705882352941E-2,3.1372549019607843E-2,7.8431372549019607E-3,0,6.6666666666666666E-2,1.9607843137254902E-2,0.35686274509803922,0.37647058823529411,0.11764705882352941,7.8431372549019607E-3,0.99607843137254903,null,0.2627450980392157]
["Dundee City",{"$f":"B12/$M12","v":6.993006993006993E-3},6.993006993006993E-3,2.097902097902098E-2,6.993006993006993E-3,0,3.4965034965034965E-3,3.4965034965034965E-3,0.41608391608391609,0.47552447552447552,4.5454545454545456E-2,1.3986013986013986E-2,1,null,0.10839160839160839]
["East Ayrshire",{"$f":"B13/$M13","v":0},0.2391304347826087,0.17391304347826086,2.1739130434782608E-2,8.6956521739130432E-2,8.6956521739130432E-2,6.5217391304347824E-2,0.13043478260869565,0.15217391304347827,2.1739130434782608E-2,0,0.97826086956521741,null,0.69565217391304346]
["East Dunbartonshire",{"$f":"B14/$M14","v":0},0.15702479338842976,0.11570247933884298,1.6528925619834711E-2,8.2644628099173556E-3,8.2644628099173556E-3,8.2644628099173556E-3,0.21487603305785125,0.2231404958677686,0.24793388429752067,0,1,null,0.56198347107438018]
["East Lothian",{"$f":"B15/$M15","v":0},8.771929824561403E-2,0.21052631578947367,5.2631578947368418E-2,1.7543859649122806E-2,0,0,0.15789473684210525,0.26315789473684209,0.19298245614035087,1.7543859649122806E-2,1,null,0.57894736842105265]
["East Renfrewshire",{"$f":"B16/$M16","v":0},0.13157894736842105,0.13157894736842105,2.6315789473684209E-2,2.6315789473684209E-2,2.6315789473684209E-2,5.2631578947368418E-2,0.31578947368421051,0.26315789473684209,2.6315789473684209E-2,0,0.99999999999999989,null,0.42105263157894735]
["Edinburgh",{"$f":"B17/$M17","v":0},3.4671532846715328E-2,1.6423357664233577E-2,1.8248175182481751E-3,1.8248175182481751E-3,0,1.6423357664233577E-2,0.3010948905109489,0.61496350364963503,5.4744525547445258E-3,5.4744525547445258E-3,0.99817518248175185,null,8.211678832116788E-2]
["Eilean Siar",{"$f":"B18/$M18","v":0},0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(B59,C59,D59,E59,F59,G59,H59,I59,J59,K59,L59)","v":0},null,0]
["Falkirk",{"$f":"B19/$M19","v":4.8069919883466858E-2},0.1412964311726147,1.0924981791697014E-2,6.7006554989075012E-2,0,7.2833211944646759E-3,7.064821558630735E-2,0.14857975236707938,0.17916970138383104,0.1099781500364166,0.21704297159504735,1,null,0.67225054624908953]
["Fife",{"$f":"B20/$M20","v":8.1632653061224497E-3},3.9455782312925167E-2,0.11700680272108843,9.5238095238095247E-3,1.3605442176870748E-2,8.1632653061224497E-3,1.9047619047619049E-2,0.30068027210884352,0.39591836734693875,7.2108843537414966E-2,1.4965986394557823E-2,0.99863945578231283,null,0.30204081632653063]
["Glasgow City",{"$f":"B21/$M21","v":2.0242914979757085E-3},1.417004048582996E-2,1.6194331983805668E-2,1.0121457489878543E-2,0,0,0.12854251012145748,0.36336032388663969,0.458502024291498,5.0607287449392713E-3,0,0.99797570850202422,null,0.17611336032388664]
["Highland",{"$f":"B22/$M22","v":0},2.6315789473684209E-2,2.6315789473684209E-2,2.6315789473684209E-2,2.6315789473684209E-2,0,0,0.34210526315789475,0.5,0,0,0.94736842105263164,null,0.10526315789473684]
["Inverclyde",{"$f":"B23/$M23","v":0},8.4033613445378148E-3,0,8.4033613445378148E-3,0,0,8.4033613445378148E-3,0.3949579831932773,0.53781512605042014,3.3613445378151259E-2,8.4033613445378148E-3,0.99999999999999989,null,6.7226890756302518E-2]
["Midlothian",{"$f":"B24/$M24","v":2.6548672566371681E-2},4.4247787610619468E-2,2.6548672566371681E-2,0,0,8.8495575221238937E-3,0,0.22123893805309736,0.41592920353982299,5.3097345132743362E-2,0.19469026548672566,0.99115044247787609,null,0.35398230088495575]
["Moray",{"$f":"B25/$M25","v":1.8726591760299626E-2},4.8689138576779027E-2,2.247191011235955E-2,3.7453183520599251E-3,0,7.4906367041198503E-3,1.1235955056179775E-2,0.32209737827715357,0.39700374531835209,7.8651685393258425E-2,9.3632958801498134E-2,1.0037453183520599,null,0.28464419475655428]
["North Ayrshire",{"$f":"B26/$M26","v":0},3.0364372469635626E-2,0.29352226720647773,4.048582995951417E-3,2.0242914979757085E-3,0,2.0242914979757085E-3,0.31983805668016196,0.34412955465587042,4.048582995951417E-3,2.0242914979757085E-3,1.0020242914979758,null,0.33805668016194335]
["North Lanarkshire",{"$f":"B27/$M27","v":2.6595744680851063E-3},0.13829787234042554,7.4468085106382975E-2,1.5957446808510637E-2,2.6595744680851063E-3,5.8510638297872342E-2,1.8617021276595744E-2,0.10638297872340426,0.52127659574468088,1.8617021276595744E-2,4.5212765957446811E-2,1.0026595744680851,null,0.375]
["Orkney",{"$f":"B28/$M28","v":0},0,0,0,0,0,0,0.33333333333333331,0.66666666666666663,0,0,1,null,0]
["Perth & Kinross",{"$f":"B29/$M29","v":6.6445182724252493E-3},1.3289036544850499E-2,0.15614617940199335,0,0,0,3.3222591362126247E-3,0.28239202657807311,0.48172757475083056,3.3222591362126247E-3,4.9833887043189369E-2,0.99667774086378735,null,0.23255813953488372]
["Renfrewshire",{"$f":"B30/$M30","v":2.0220588235294119E-2},0.10845588235294118,6.4338235294117641E-2,3.6764705882352941E-3,1.838235294117647E-3,2.7573529411764705E-2,2.5735294117647058E-2,0.28125,0.34742647058823528,0.10294117647058823,1.4705882352941176E-2,0.99816176470588225,null,0.36948529411764708]
["Scottish Borders",{"$f":"B31/$M31","v":0},3.9735099337748346E-2,7.2847682119205295E-2,0,0,5.9602649006622516E-2,6.6225165562913907E-3,0.29801324503311261,0.37086092715231789,0.15231788079470199,0,1,null,0.33112582781456956]
["Shetland",{"$f":"B32/$M32","v":0},2.2222222222222223E-2,0,0,0,0,0,0.42222222222222222,0.48888888888888887,0,0,0.93333333333333335,null,2.2222222222222223E-2]
["South Ayrshire",{"$f":"B33/$M33","v":4.1928721174004195E-3},1.8867924528301886E-2,9.6436058700209645E-2,4.1928721174004195E-3,2.0964360587002098E-3,0.11740041928721175,3.9832285115303984E-2,0.16981132075471697,0.26415094339622641,9.6436058700209645E-2,0.18658280922431866,1,null,0.56603773584905659]
["South Lanarkshire",{"$f":"B34/$M34","v":3.3444816053511705E-3},4.3478260869565216E-2,7.3578595317725759E-2,6.688963210702341E-3,0,0,0,0.25418060200668896,0.33444816053511706,0.28093645484949831,0,0.99665551839464883,null,0.40802675585284282]
["Stirling",{"$f":"B35/$M35","v":0},2.2222222222222223E-2,4.4444444444444446E-2,0,0,0,0,0.17777777777777778,0.73333333333333328,2.2222222222222223E-2,0,1,null,8.8888888888888892E-2]
["West Dunbartonshire",{"$f":"B36/$M36","v":0},9.375E-2,7.8125E-2,4.6875E-2,1.5625E-2,0,0,0.328125,0.265625,0.15625,0,0.984375,null,0.390625]
["West Lothian",{"$f":"B37/$M37","v":0},1.6574585635359115E-2,3.3149171270718231E-2,5.5248618784530384E-3,5.5248618784530384E-3,0,5.5248618784530384E-3,0.41988950276243092,0.49171270718232046,2.2099447513812154E-2,0,1,null,8.8397790055248615E-2]
[]
["Disclosure Control has been applied to this table.  All cells have been rounded to the nearest five."]
["Column totals may not sum to total of individual cells due to rounding."]
[]
[]
[]
[]
[]
[null,"Chart Data"]
[null,null,"Client informed of rights under homelessness legislation","General Housing advice/\nTenancy rights advice","Other Actitivity"]
[null,"Clackmannanshire",0.5,0.44545454545454544,5.4545454545454543E-2]
[null,"Shetland",0.42222222222222222,0.48888888888888887,2.2222222222222223E-2]
[null,"West Lothian",0.41988950276243092,0.49171270718232046,8.8397790055248615E-2]
[null,"Dundee City",0.41608391608391609,0.47552447552447552,0.10839160839160839]
[null,"Inverclyde",0.3949579831932773,0.53781512605042014,6.7226890756302518E-2]
[null,"Glasgow City",0.36336032388663969,0.458502024291498,0.17611336032388664]
[null,"Dumfries & Galloway",0.35686274509803922,0.37647058823529411,0.2627450980392157]
[null,"Highland",0.34210526315789475,0.5,0.10526315789473684]
[null,"Orkney",0.33333333333333331,0.66666666666666663,0]
[null,"West Dunbartonshire",0.328125,0.265625,0.390625]
[null,"Aberdeen City",0.32527472527472528,0.50329670329670328,0.17142857142857143]
[null,"Moray",0.32209737827715357,0.39700374531835209,0.28464419475655428]
[null,"North Ayrshire",0.31983805668016196,0.34412955465587042,0.33805668016194335]
[null,"East Renfrewshire",0.31578947368421051,0.26315789473684209,0.42105263157894735]
[null,"Argyll & Bute",0.30960854092526691,0.43416370106761565,0.25622775800711745]
[null,"Edinburgh",0.3010948905109489,0.61496350364963503,8.211678832116788E-2]
[null,"Aberdeenshire",0.30071599045346065,0.42720763723150357,0.27446300715990452]
[null,"Fife",0.30068027210884352,0.39591836734693875,0.30204081632653063]
[null,"Scottish Borders",0.29801324503311261,0.37086092715231789,0.33112582781456956]
[null,"Perth & Kinross",0.28239202657807311,0.48172757475083056,0.23255813953488372]
[null,"Renfrewshire",0.28125,0.34742647058823528,0.36948529411764708]
[null,"Scotland",0.27561540079949504,0.38586156111929309,0.33831264464548705]
[null,"South Lanarkshire",0.25418060200668896,0.33444816053511706,0.40802675585284282]
[null,"Midlothian",0.22123893805309736,0.41592920353982299,0.35398230088495575]
[null,"East Dunbartonshire",0.21487603305785125,0.2231404958677686,0.56198347107438018]
[null,"Angus",0.20363636363636364,0.31272727272727274,0.48363636363636364]
[null,"Stirling",0.17777777777777778,0.73333333333333328,8.8888888888888892E-2]
[null,"South Ayrshire",0.16981132075471697,0.26415094339622641,0.56603773584905659]
[null,"East Lothian",0.15789473684210525,0.26315789473684209,0.57894736842105265]
[null,"Falkirk",0.14857975236707938,0.17916970138383104,0.67225054624908953]
[null,"East Ayrshire",0.13043478260869565,0.15217391304347827,0.69565217391304346]
[null,"North Lanarkshire",0.10638297872340426,0.52127659574468088,0.375]
[null,"Eilean Siar",0,0,0]

{"sheet":"Chart 7 - Activities by LA","index":19,"n_rows":2,"n_cols":14,"rows_kept":2,"cut":false,"hidden":false,"merged":[]}
["Chart 7: Activities by Local Authority",null,null,null,null,null,null,null,null,null,null,null,null,"Back to Contents"]
["Data from 1 April to 30 September 2017"]

{"sheet":"Table 8 - Outcomes by Quarter","index":20,"n_rows":51,"n_cols":21,"rows_kept":51,"cut":false,"hidden":false,"merged":[[36,1,36,10],[44,1,44,10],[2,12,2,15],[2,17,2,20],[15,12,15,14],[15,17,15,19],[2,1,2,10],[15,1,15,10]]}
["Table 8a: Outcomes by Quarter (number)",null,null,null,null,"Back to Contents"]
[]
[null,"Quarter of Approach Closure",null,null,null,null,null,null,null,null,null,null,"Bi-annual change",null,null,null,null,"Annual change"]
["Outcomes","2015 Q2","2015 Q3","2015 Q4","2016 Q1","2016 Q2","2016 Q3","2016 Q4","2017 Q1","2017 Q2","2017 Q3",null,"April to Sept 2016","April to Sept 2017","Change","% ",null,"Year to end Sept 2016","Year to end Sept 2017","Change","%"]
["Made homelessness application to local authority",6624,6761,6203,6535,6478,5412,5521,6334,5367,4798,null,{"$f":"SUM(F5:G5)","v":11890},{"$f":"SUM(J5:K5)","v":10165},{"$f":"N5-M5","v":-1725},{"$f":"O5/M5","v":-0.14507989907485283},null,{"$f":"SUM(D5:G5)","v":24628},{"$f":"SUM(H5:K5)","v":22020},{"$f":"S5-R5","v":-2608},{"$f":"T5/R5","v":-0.10589572843917493}]
["Remained in current accommodation",2606,2834,2705,2736,2613,2704,2376,3308,2832,2624,null,5317,5456,{"$f":"N6-M6","v":139},{"$f":"O6/M6","v":2.6142561594884334E-2},null,{"$f":"SUM(D6:G6)","v":10758},{"$f":"SUM(H6:K6)","v":11140},{"$f":"S6-R6","v":382},{"$f":"T6/R6","v":3.5508458821342258E-2}]
["Lost Contact/ Not known",1689,1794,2205,1900,2074,1906,1843,2961,4033,1671,null,3980,5704,1724,0.43316582914572865,null,8085,10508,2423,0.2996907854050711]
["Other (known)",515,576,439,680,545,735,715,892,682,613,null,1280,1295,15,1.171875E-2,null,2399,2902,503,0.20967069612338474]
["LA/RSL Tenancy",578,544,565,586,528,812,509,513,417,424,null,1340,841,-499,-0.37238805970149252,null,2491,1863,-628,-0.25210758731433158]
["PRS Tenancy",489,462,468,408,459,502,395,422,402,401,null,961,803,-158,-0.16441207075962538,null,1837,1620,-217,-0.1181273816004355]
["Moved-in with friends/ relatives",246,251,302,275,267,307,232,268,258,251,null,574,509,-65,-0.1132404181184669,null,1151,1009,-142,-0.12337098175499565]
["Total (ALL)",12747,13222,12887,13120,12964,12378,11591,14698,13991,10782,null,25342,24773,-569,-2.245284507931497E-2,null,51349,51062,-287,-5.5892032950982488E-3]
[]
["Table 8b: Outcomes by Quarter (percent)"]
[]
[null,"Quarter of Approach Closure",null,null,null,null,null,null,null,null,null,null,"Bi-annual change",null,null,null,null,"Annual change"]
["Outcomes","2015 Q2","2015 Q3","2015 Q4","2016 Q1","2016 Q2","2016 Q3","2016 Q4","2017 Q1","2017 Q2","2017 Q3",null,"April to Sept 2016","April to Sept 2017","Change",null,null,"Year to end Sept 2016","Year to end Sept 2017","Change"]
["Made homelessness application to local authority",{"$f":"B5/B$12","v":0.51965168274888207},{"$f":"C5/C$12","v":0.51134472848283163},0.48133778226119345,0.49809451219512196,0.49969145325516817,0.43722733882695103,{"$f":"H5/H$12","v":0.47631783280131135},{"$f":"I5/I$12","v":0.43094298544019594},0.38360374526481311,0.4450009274717121,null,{"$f":"SUM(F18:G18)/2","v":0.46845939604105957},{"$f":"SUM(J18:K18)/2","v":0.41430233636826264},{"$f":"N18-M18","v":-5.4157059672796937E-2},null,null,{"$f":"SUM(D18:G18)/4","v":0.47908777163460864},{"$f":"SUM(H18:K18)/4","v":0.43396637274450811},{"$f":"S18-R18","v":-4.5121398890100528E-2}]
["Remained in current accommodation",{"$f":"B6/B$12","v":0.20444026045344002},0.2143397368022992,0.20990145107472646,0.20853658536585365,0.20155816106140081,0.21845209242203911,{"$f":"H6/H$12","v":0.20498662755586231},{"$f":"I6/I$12","v":0.22506463464416929},0.20241583875348437,0.24336857725839361,null,{"$f":"SUM(F19:G19)/2","v":0.21000512674171995},{"$f":"SUM(J19:K19)/2","v":0.22289220800593901},{"$f":"N19-M19","v":1.2887081264219058E-2},null,null,{"$f":"SUM(D19:G19)/4","v":0.209612072481005},{"$f":"SUM(H19:K19)/4","v":0.21895891955297742},{"$f":"S19-R19","v":9.3468470719724195E-3}]
["Lost Contact/ Not known",{"$f":"B7/B$12","v":0.13250176512120498},0.13568295265466646,0.17110266159695817,0.1448170731707317,0.15998148719531008,0.15398287283890774,{"$f":"H7/H$12","v":0.15900267448882754},{"$f":"I7/I$12","v":0.20145598040549734},0.28825673647344724,0.15498052309404564,null,0.1569821800171089,0.22161862978374644,6.4636449766637544E-2,null,null,0.15747102370047691,0.20092397861545444,4.3452954914977526E-2]
["LA/RSL Tenancy",{"$f":"B8/B$12","v":4.0401663136424258E-2},4.3563757374073517E-2,3.4065337161480559E-2,5.1829268292682924E-2,4.2039493983338477E-2,5.9379544352884152E-2,{"$f":"H8/H$12","v":6.168579069968079E-2},{"$f":"I8/I$12","v":6.0688529051571641E-2},4.8745622185690798E-2,5.6854015952513451E-2,null,5.0709519168111311E-2,5.2799819069102125E-2,2.0902999009908135E-3,null,null,4.6828410947596523E-2,5.699348947236417E-2,1.0165078524767647E-2]
["Other (known)",{"$f":"B9/B$12","v":4.5344002510394603E-2},4.1143548631069428E-2,4.3842632109878169E-2,4.4664634146341461E-2,4.0728170317803146E-2,6.5600258523186294E-2,{"$f":"H9/H$12","v":4.3913381071521006E-2},{"$f":"I9/I$12","v":3.4902707851408352E-2},2.9804874562218569E-2,3.9324800593581899E-2,null,5.3164214420494724E-2,3.4564837577900236E-2,-1.8599376842594488E-2,null,null,4.8708923774302269E-2,3.6986441019682459E-2,-1.172248275461981E-2]
["PRS Tenancy",{"$f":"B10/B$12","v":3.8361967521769826E-2},3.4941763727121461E-2,3.6315666951191122E-2,3.1097560975609756E-2,3.540573896945387E-2,4.0555824850541281E-2,{"$f":"H10/H$12","v":3.4078164092830647E-2},{"$f":"I10/I$12","v":2.8711389304667302E-2},2.8732756772210707E-2,3.7191615655722501E-2,null,3.7980781909997575E-2,3.2962186213966606E-2,-5.0185956960309697E-3,null,null,3.5843697936699004E-2,3.2178481456357794E-2,-3.6652164803412102E-3]
["Moved-in with friends/ relatives",{"$f":"B11/B$12","v":1.9298658507884207E-2},1.8983512327938285E-2,2.3434468844572048E-2,2.0960365853658538E-2,2.0595495217525454E-2,2.4802068185490387E-2,{"$f":"H11/H$12","v":2.0015529289966354E-2},{"$f":"I11/I$12","v":1.8233773302490135E-2},1.844042598813523E-2,2.3279539974030792E-2,null,2.2698781701507922E-2,2.0859982981083013E-2,-1.8387987204249098E-3,null,null,2.2448099525311606E-2,1.9992317138655628E-2,-2.4557823866559782E-3]
["Total (ALL)",{"$f":"B12/B$12","v":1},1,1,1,1,1,{"$f":"H12/H$12","v":1},{"$f":"I12/I$12","v":1},1,1,null,1,1,0,null,null,1,1,0]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(M21:M24)","v":0.16455329720011153},{"$f":"SUM(N21:N24)","v":0.14118682584205197}]
[]
[]
[]
[]
[]
[]
[]
["Data for chart"]
[]
[null,"Quarter of Approach Closure",null,null,null,null,null,null,null,null,null,null,"bi-annual summary"]
[null,"2015 Q2","2015 Q3","2015 Q4","2016 Q1","2016 Q2","2016 Q3","2016 Q4","2017 Q1","2017 Q2","2017 Q3"]
["Made homelessness application to local authority",6624,6761,6203,6535,6478,5412,5521,6334,5367,4798,null,{"$f":"SUM(J39:K39)","v":10165}]
["Remained in current accommodation",2606,2834,2705,2736,2613,2704,2376,3308,2832,2624,null,{"$f":"SUM(J40:K40)","v":5456}]
["Lost Contact/ Not known",1689,1794,2205,1900,2074,1906,1843,2961,4033,1671,null,5704]
["Moved into Alternative Accommodation",{"$f":"SUM(B8:B11)","v":1828},{"$f":"SUM(C8:C11)","v":1833},{"$f":"SUM(D8:D11)","v":1774},1949,1799,2356,1851,2095,1759,1689,null,3448]
["Total (ALL)",{"$f":"SUM(B39:B42)","v":12747},{"$f":"SUM(C39:C42)","v":13222},12887,13120,12964,12378,11591,14698,13991,10782,null,24773]
[]
[null,"Quarter of Approach Closure"]
[null,"2015 Q2","2015 Q3","2015 Q4","2016 Q1","2016 Q2","2016 Q3","2016 Q4","2017 Q1","2017 Q2","2017 Q3"]
["Made homelessness application to local authority",{"$f":"B39/B$43","v":0.51965168274888207},{"$f":"C39/C$43","v":0.51134472848283163},0.48133778226119345,0.49809451219512196,0.49969145325516817,0.43722733882695103,{"$f":"H39/H$43","v":0.47631783280131135},{"$f":"I39/I$43","v":0.43094298544019594},0.38360374526481311,0.4450009274717121,null,{"$f":"M39/$M$43","v":0.41032575788156461}]
["Remained in current accommodation",{"$f":"B40/B$43","v":0.20444026045344002},0.2143397368022992,0.20990145107472646,0.20853658536585365,0.20155816106140081,0.21845209242203911,{"$f":"H40/H$43","v":0.20498662755586231},{"$f":"I40/I$43","v":0.22506463464416929},0.20241583875348437,0.24336857725839361,null,{"$f":"M40/$M$43","v":0.22023977717676502}]
["Lost Contact/ Not known",0.13250176512120498,0.13568295265466646,0.17110266159695817,0.1448170731707317,0.15998148719531008,0.15398287283890774,{"$f":"H41/H$43","v":0.15900267448882754},{"$f":"I41/I$43","v":0.20145598040549734},0.28825673647344724,0.15498052309404564,null,0.23025067613934525]
["Moved into Alternative Accommodation",0.1434062916764729,0.13863258206020268,0.13765810506712189,0.14855182926829269,0.13876889848812096,0.19033769591210212,{"$f":"H42/H$43","v":0.1596928651539988},{"$f":"I42/I$43","v":0.14253639951013744},0.1257236795082553,0.15664997217584864,null,0.13918378880232513]
["Total (ALL)",{"$f":"B43/B$43","v":1},1,1,1,1,1,{"$f":"H43/H$43","v":1},{"$f":"I43/I$43","v":1},1,1,null,1]

{"sheet":"Chart 8.1 - Outcomes by quarter","index":21,"n_rows":2,"n_cols":14,"rows_kept":2,"cut":false,"hidden":false,"merged":[]}
["Chart 8.1: Outcome of Housing Options Approaches by quarter\n",null,null,null,null,null,null,null,null,null,null,null,null,"Back to Contents"]
["Data from 1 April 30 September 2017"]

{"sheet":"Chart 8.2 - Outcome Durations","index":22,"n_rows":76,"n_cols":7,"rows_kept":76,"cut":false,"hidden":false,"merged":[[39,0,40,0],[39,1,40,1],[39,2,39,6]]}
["Chart 8.2: Distribution of Housing Options approach case durations by outcome, cases closed between 1 April and 30 September 2017"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Workings for Chart XX: Distribution of approach duration by outcome"]
["All approaches closed between 1 April 30 September 2017"]
[]
["Outcome","Number","Number of days between Approach Date and Outcome Date"]
[null,null,"P5","Q1","Median","Q3","P95"]
["LA/RSL Tenancy",841,4,40,84,156,381]
["PRS Tenancy",803,6,29,60,129,374]
["Other (known)",1295,0,4,33,103,371]
["Moved-in with friends/ relatives",509,0,20,41,83,302]
["Lost Contact/ Not known",5704,0,31,137,588,846]
["Remained in current accommodation",5456,0,19,48,112,392]
["Made homelessness application\n to local authority",10165,0,0,1,13,109]
["All Outcomes",24773,0,1,26,100,651]
[]
["Notes"]
["P5 = 5th Percentile.  5% of approaches have been open for this many days."]
["Q1 = First Quartile.  25% of approaches have been open for this many days."]
["Median.  50% of approaches have been open for this many days."]
["Q3 = First Quartile.  75% of approaches have been open for this many days. Conversely, 25% of cases have been open for more than this number of days."]
["P95 = 95th Percentile.  5% of approaches have been open for more than this number of days."]
[]
[]
["Data for Box Plot"]
["Outcome","P5","Q1","Median","Q3","P95"]
["Made homelessness application to local authority",0,0,1,13,109]
["Other (known)",0,4,33,103,371]
["Moved-in with friends/ relatives",0,20,41,83,302]
["Remained in current accommodation",0,19,48,112,392]
["PRS Tenancy",6,29,60,129,374]
["LA/RSL Tenancy",4,40,84,156,381]
["Lost Contact/ Not known",0,31,137,588,846]
[]
[{"$f":"A60","v":"Outcome"},"Q1","Median-Q1","Q3-Median","Q1-P5","P95-Q3","Median"]
[{"$f":"A61","v":"Made homelessness application to local authority"},{"$f":"C61","v":0},{"$f":"D61-C61","v":1},12,{"$f":"C61-B61","v":0},{"$f":"F61-E61","v":96},{"$f":"D61","v":1}]
["Other (known)",4,29,70,4,268,33]
["Moved-in with friends/ relatives",20,21,42,20,219,41]
["Remained in current accommodation",19,29,64,19,280,48]
["PRS Tenancy",29,31,69,23,245,60]
["LA/RSL Tenancy",40,44,72,36,225,84]
["Lost Contact/ Not known",31,106,451,31,258,137]

{"sheet":"Table 9 - Outcomes by LA","index":23,"n_rows":116,"n_cols":11,"rows_kept":116,"cut":false,"hidden":false,"merged":[]}
["Table 9a: Outcomes by LA during the last 6 months: 1 April to 30 September 2017",null,null,null,null,null,"Back to Contents"]
[]
["Local Authority","LA/RSL Tenancy","PRS Tenancy","Other (known)","Moved-in with friends/ relatives","Lost Contact/ Not known","Remained in current accommodation","Made homelessness application to local authority","All",null,"Found Alternative Accommodation (sum of LA/RSL/PRS/Other (known)/moved in with friends/relatives)"]
["Scotland",841,803,1295,509,5704,5456,10165,24773,null,{"$f":"SUM(B4:E4)","v":3448}]
["Aberdeen City",182,102,113,35,2666,971,628,4697,null,432]
["Aberdeenshire",20,52,20,26,271,174,264,827,null,118]
["Angus",15,18,17,1,54,179,267,551,null,51]
["Argyll & Bute",38,30,51,9,101,413,203,845,null,128]
["Clackmannanshire",0,0,0,1,5,9,220,235,null,1]
["Dumfries & Galloway",7,6,2,2,99,39,351,506,null,17]
["Dundee City",33,27,33,15,143,186,263,700,null,108]
["East Ayrshire",6,3,0,5,4,16,4,38,null,14]
["East Dunbartonshire",1,1,2,0,26,29,95,154,null,4]
["East Lothian",0,2,0,2,10,7,16,37,null,4]
["East Renfrewshire",1,5,1,1,3,16,18,45,null,8]
["Edinburgh",35,38,52,51,459,447,1327,2409,null,176]
["Eilean Siar",1,0,0,1,0,2,1,5,null,2]
["Falkirk",18,3,27,25,44,124,446,687,null,73]
["Fife",53,93,41,9,191,129,402,918,null,196]
["Glasgow City",32,5,381,121,656,698,2792,4685,null,539]
["Highland",3,10,11,11,21,44,46,146,null,35]
["Inverclyde",18,19,37,27,114,98,101,414,null,101]
["Midlothian",4,4,2,3,5,41,5,64,null,13]
["Moray",22,40,19,46,60,128,222,537,null,127]
["North Ayrshire",75,94,50,30,30,85,480,844,null,249]
["North Lanarkshire",51,9,34,10,48,471,138,761,null,104]
["Orkney",1,0,0,0,3,1,6,11,null,1]
["Perth & Kinross",38,91,258,8,217,410,435,1457,null,395]
["Renfrewshire",42,16,78,36,117,364,442,1095,null,172]
["Scottish Borders",35,32,16,2,112,63,178,438,null,85]
["Shetland",11,0,2,3,22,29,52,119,null,16]
["South Ayrshire",3,0,0,0,10,4,370,387,null,3]
["South Lanarkshire",38,76,18,13,145,84,150,524,null,145]
["Stirling",6,9,5,6,16,77,18,137,null,26]
["West Dunbartonshire",23,4,4,0,19,28,21,99,null,31]
["West Lothian",29,14,21,10,33,90,204,401,null,74]
[]
["Disclosure Control has been applied to this table.  All cells have been rounded to the nearest five."]
["Row totals may not sum to total of individual cells due to rounding."]
[]
["Table 9b: Outcomes by LA: 1 April to 30 September 2017"]
[]
["Local Authority","LA/RSL Tenancy","PRS Tenancy","Other (known)","Moved-in with friends/ relatives","Lost Contact/ Not known","Remained in current accommodation","Made homelessness application to local authority","All",null,"Found Alternative Accommodation (sum of LA/RSL/PRS/Other (known)/moved in with friends/relatives)"]
["Scotland",{"$f":"B4/$I4","v":3.3948250111007952E-2},{"$f":"C4/$I4","v":3.2414322044160983E-2},5.2274653857021756E-2,2.0546562790134421E-2,0.23025067613934525,0.22023977717676502,{"$f":"H4/$I4","v":0.41032575788156461},{"$f":"SUM(B44,C44,D44,E44,F44,G44,H44)","v":1},null,{"$f":"K4/$I4","v":0.13918378880232513}]
["Aberdeen City",{"$f":"B5/$I5","v":3.8748137108792845E-2},2.1715988929103685E-2,2.4057909303810944E-2,7.4515648286140089E-3,0.56759633808814136,0.20672769853097722,0.13370236321055992,1,null,9.1973600170321482E-2]
["Aberdeenshire",{"$f":"B6/$I6","v":2.4183796856106408E-2},6.2877871825876661E-2,2.4183796856106408E-2,3.143893591293833E-2,0.32769044740024184,0.21039903264812576,0.31922611850060462,1,null,0.14268440145102781]
["Angus",{"$f":"B7/$I7","v":2.7223230490018149E-2},3.2667876588021776E-2,3.0852994555353903E-2,1.8148820326678765E-3,9.8003629764065334E-2,0.32486388384754988,0.48457350272232302,1,null,9.2558983666061703E-2]
["Argyll & Bute",{"$f":"B8/$I8","v":4.4970414201183431E-2},3.5502958579881658E-2,6.0355029585798817E-2,1.0650887573964497E-2,0.11952662721893491,0.48875739644970412,0.24023668639053256,1,null,0.1514792899408284]
["Clackmannanshire",{"$f":"B9/$I9","v":0},0,0,4.2553191489361703E-3,2.1276595744680851E-2,3.8297872340425532E-2,0.93617021276595747,1,null,4.2553191489361703E-3]
["Dumfries & Galloway",{"$f":"B10/$I10","v":1.383399209486166E-2},1.1857707509881422E-2,3.952569169960474E-3,3.952569169960474E-3,0.19565217391304349,7.7075098814229248E-2,0.69367588932806323,1,null,3.3596837944664032E-2]
["Dundee City",{"$f":"B11/$I11","v":4.7142857142857146E-2},3.8571428571428569E-2,4.7142857142857146E-2,2.1428571428571429E-2,0.20428571428571429,0.26571428571428574,0.37571428571428572,1,null,0.15428571428571428]
["East Ayrshire",{"$f":"B12/$I12","v":0.15789473684210525},7.8947368421052627E-2,0,0.13157894736842105,0.10526315789473684,0.42105263157894735,0.10526315789473684,1,null,0.36842105263157893]
["East Dunbartonshire",{"$f":"B13/$I13","v":6.4935064935064939E-3},6.4935064935064939E-3,1.2987012987012988E-2,0,0.16883116883116883,0.18831168831168832,0.61688311688311692,1,null,2.5974025974025976E-2]
["East Lothian",{"$f":"B14/$I14","v":0},5.4054054054054057E-2,0,5.4054054054054057E-2,0.27027027027027029,0.1891891891891892,0.43243243243243246,1,null,0.10810810810810811]
["East Renfrewshire",{"$f":"B15/$I15","v":2.2222222222222223E-2},0.1111111111111111,2.2222222222222223E-2,2.2222222222222223E-2,6.6666666666666666E-2,0.35555555555555557,0.4,1,null,0.17777777777777778]
["Edinburgh",{"$f":"B16/$I16","v":1.4528850145288501E-2},1.5774180157741801E-2,2.1585720215857203E-2,2.1170610211706103E-2,0.19053549190535493,0.18555417185554171,0.55085097550850981,1,null,7.3059360730593603E-2]
["Eilean Siar",{"$f":"B17/$I17","v":0.2},0,0,0.2,0,0.4,0.2,1,null,0.4]
["Falkirk",{"$f":"B18/$I18","v":2.6200873362445413E-2},4.3668122270742356E-3,3.9301310043668124E-2,3.6390101892285295E-2,6.4046579330422126E-2,0.18049490538573509,0.64919941775836976,1,null,0.10625909752547306]
["Fife",{"$f":"B19/$I19","v":5.7734204793028321E-2},0.10130718954248366,4.4662309368191724E-2,9.8039215686274508E-3,0.20806100217864923,0.14052287581699346,0.43790849673202614,1,null,0.21350762527233116]
["Glasgow City",{"$f":"B20/$I20","v":6.8303094983991463E-3},1.0672358591248667E-3,8.1323372465314833E-2,2.5827107790821771E-2,0.1400213447171825,0.14898612593383137,0.59594450373532548,1,null,0.11504802561366062]
["Highland",{"$f":"B21/$I21","v":2.0547945205479451E-2},6.8493150684931503E-2,7.5342465753424653E-2,7.5342465753424653E-2,0.14383561643835616,0.30136986301369861,0.31506849315068491,1,null,0.23972602739726026]
["Inverclyde",{"$f":"B22/$I22","v":4.3478260869565216E-2},4.5893719806763288E-2,8.9371980676328497E-2,6.5217391304347824E-2,0.27536231884057971,0.23671497584541062,0.24396135265700483,1,null,0.24396135265700483]
["Midlothian",{"$f":"B23/$I23","v":6.25E-2},6.25E-2,3.125E-2,4.6875E-2,7.8125E-2,0.640625,7.8125E-2,1,null,0.203125]
["Moray",{"$f":"B24/$I24","v":4.0968342644320296E-2},7.4487895716946001E-2,3.5381750465549346E-2,8.5661080074487903E-2,0.11173184357541899,0.23836126629422719,0.41340782122905029,1,null,0.23649906890130354]
["North Ayrshire",{"$f":"B25/$I25","v":8.8862559241706163E-2},0.11137440758293839,5.9241706161137442E-2,3.5545023696682464E-2,3.5545023696682464E-2,0.10071090047393365,0.56872037914691942,1,null,0.29502369668246448]
["North Lanarkshire",{"$f":"B26/$I26","v":6.7017082785808146E-2},1.1826544021024968E-2,4.4678055190538767E-2,1.3140604467805518E-2,6.3074901445466486E-2,0.6189224704336399,0.18134034165571616,1,null,0.13666228646517739]
["Orkney",{"$f":"B27/$I27","v":9.0909090909090912E-2},0,0,0,0.27272727272727271,9.0909090909090912E-2,0.54545454545454541,1,null,9.0909090909090912E-2]
["Perth & Kinross",{"$f":"B28/$I28","v":2.6080988332189432E-2},6.2457103637611533E-2,0.17707618393960192,5.4907343857240904E-3,0.14893617021276595,0.28140013726835966,0.29855868222374743,1,null,0.27110501029512696]
["Renfrewshire",{"$f":"B29/$I29","v":3.8356164383561646E-2},1.4611872146118721E-2,7.1232876712328766E-2,3.287671232876712E-2,0.10684931506849316,0.33242009132420092,0.40365296803652967,1,null,0.15707762557077626]
["Scottish Borders",{"$f":"B30/$I30","v":7.9908675799086754E-2},7.3059360730593603E-2,3.6529680365296802E-2,4.5662100456621002E-3,0.25570776255707761,0.14383561643835616,0.40639269406392692,1,null,0.19406392694063926]
["Shetland",{"$f":"B31/$I31","v":9.2436974789915971E-2},0,1.680672268907563E-2,2.5210084033613446E-2,0.18487394957983194,0.24369747899159663,0.43697478991596639,1,null,0.13445378151260504]
["South Ayrshire",{"$f":"B32/$I32","v":7.7519379844961239E-3},0,0,0,2.5839793281653745E-2,1.0335917312661499E-2,0.95607235142118863,1,null,7.7519379844961239E-3]
["South Lanarkshire",{"$f":"B33/$I33","v":7.2519083969465645E-2},0.14503816793893129,3.4351145038167941E-2,2.4809160305343511E-2,0.27671755725190839,0.16030534351145037,0.2862595419847328,1,null,0.27671755725190839]
["Stirling",{"$f":"B34/$I34","v":4.3795620437956206E-2},6.569343065693431E-2,3.6496350364963501E-2,4.3795620437956206E-2,0.11678832116788321,0.56204379562043794,0.13138686131386862,1,null,0.18978102189781021]
["West Dunbartonshire",{"$f":"B35/$I35","v":0.23232323232323232},4.0404040404040407E-2,4.0404040404040407E-2,0,0.19191919191919191,0.28282828282828282,0.21212121212121213,1,null,0.31313131313131315]
["West Lothian",{"$f":"B36/$I36","v":7.2319201995012475E-2},3.4912718204488775E-2,5.2369077306733167E-2,2.4937655860349128E-2,8.2294264339152115E-2,0.22443890274314215,0.50872817955112215,1,null,0.18453865336658354]
[]
["Disclosure Control has been applied to this table.  All cells have been rounded to the nearest five."]
["Row totals may not sum to total of individual cells due to rounding."]
[]
[]
["Chart Data - Remained in Current Accommodation"]
[null,"Made homelessness application to local authority","Remained in current accommodation","Not Known/Lost Contact","Found Alternative Accommodation"]
["South Ayrshire",0.95607235142118863,1.0335917312661499E-2,2.5839793281653745E-2,7.7519379844961239E-3]
["Clackmannanshire",0.93617021276595747,3.8297872340425532E-2,2.1276595744680851E-2,4.2553191489361703E-3]
["Dumfries & Galloway",0.69367588932806323,7.7075098814229248E-2,0.19565217391304349,3.3596837944664032E-2]
["Falkirk",0.64919941775836976,0.18049490538573509,6.4046579330422126E-2,0.10625909752547306]
["East Dunbartonshire",0.61688311688311692,0.18831168831168832,0.16883116883116883,2.5974025974025976E-2]
["Glasgow City",0.59594450373532548,0.14898612593383137,0.1400213447171825,0.11504802561366062]
["North Ayrshire",0.56872037914691942,0.10071090047393365,3.5545023696682464E-2,0.29502369668246448]
["Edinburgh",0.55085097550850981,0.18555417185554171,0.19053549190535493,7.3059360730593603E-2]
["Orkney",0.54545454545454541,9.0909090909090912E-2,0.27272727272727271,9.0909090909090912E-2]
["West Lothian",0.50872817955112215,0.22443890274314215,8.2294264339152115E-2,0.18453865336658354]
["Angus",0.48457350272232302,0.32486388384754988,9.8003629764065334E-2,9.2558983666061703E-2]
["Fife",0.43790849673202614,0.14052287581699346,0.20806100217864923,0.21350762527233116]
["Shetland",0.43697478991596639,0.24369747899159663,0.18487394957983194,0.13445378151260504]
["East Lothian",0.43243243243243246,0.1891891891891892,0.27027027027027029,0.10810810810810811]
["Moray",0.41340782122905029,0.23836126629422719,0.11173184357541899,0.23649906890130354]
["Scotland",0.41032575788156461,0.22023977717676502,0.23025067613934525,0.13918378880232513]
["Scottish Borders",0.40639269406392692,0.14383561643835616,0.25570776255707761,0.19406392694063926]
["Renfrewshire",0.40365296803652967,0.33242009132420092,0.10684931506849316,0.15707762557077626]
["East Renfrewshire",0.4,0.35555555555555557,6.6666666666666666E-2,0.17777777777777778]
["Dundee City",0.37571428571428572,0.26571428571428574,0.20428571428571429,0.15428571428571428]
["Aberdeenshire",0.31922611850060462,0.21039903264812576,0.32769044740024184,0.14268440145102781]
["Highland",0.31506849315068491,0.30136986301369861,0.14383561643835616,0.23972602739726026]
["Perth & Kinross",0.29855868222374743,0.28140013726835966,0.14893617021276595,0.27110501029512696]
["South Lanarkshire",0.2862595419847328,0.16030534351145037,0.27671755725190839,0.27671755725190839]
["Inverclyde",0.24396135265700483,0.23671497584541062,0.27536231884057971,0.24396135265700483]
["Argyll & Bute",0.24023668639053256,0.48875739644970412,0.11952662721893491,0.1514792899408284]
["West Dunbartonshire",0.21212121212121213,0.28282828282828282,0.19191919191919191,0.31313131313131315]
["Eilean Siar",0.2,0.4,0,0.4]
["North Lanarkshire",0.18134034165571616,0.6189224704336399,6.3074901445466486E-2,0.13666228646517739]
["Aberdeen City",0.13370236321055992,0.20672769853097722,0.56759633808814136,9.1973600170321482E-2]
["Stirling",0.13138686131386862,0.56204379562043794,0.11678832116788321,0.18978102189781021]
["East Ayrshire",0.10526315789473684,0.42105263157894735,0.10526315789473684,0.36842105263157893]
["Midlothian",7.8125E-2,0.640625,7.8125E-2,0.203125]

{"sheet":"Chart 9 - Outcomes by LA","index":24,"n_rows":2,"n_cols":14,"rows_kept":2,"cut":false,"hidden":false,"merged":[]}
["Chart 9: Variation in outcomes for each Local Authority",null,null,null,null,null,null,null,null,null,null,null,null,"Back to Contents"]
["All apporaches closed between 1 April and 30 September 2017"]

{"sheet":"Chart 10 - Homelessness Boxplot","index":25,"n_rows":181,"n_cols":7,"rows_kept":181,"cut":false,"hidden":false,"merged":[[65,0,66,0],[65,1,66,1],[65,2,65,6]]}
["Chart 10: Distribution of the number of days to outcome an approach as a homelessness application"]
["All approaches closed between 1 April and 30 September 2017 where the outcome was a homelessness application."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Working for Chart XX: Distribution of the number of days to make a homelessness application"]
[]
["Local Authority","Number of approaches with an outcomes of making a homelessness application","Number of days between Approach Date and date of Homelessness Application "]
[null,null,"P5","Q1","Median","Q3","P95"]
["Scotland",10165,0,0,1,13,109]
["Aberdeen City",628,0,0,5,80,628]
["Aberdeenshire",264,0,0,1,10,78]
["Angus",267,0,2,7,16,84]
["Argyll & Bute",203,0,1,3,13,73]
["Clackmannanshire",220,0,0,0,0,0]
["Dumfries & Galloway",351,0,0,0,0,0]
["Dundee City",263,1,2,4,15,106]
["East Ayrshire",4,10,10,14,29,40]
["East Dunbartonshire",95,0,0,0,0,71]
["East Lothian",16,1,14,38,59,197]
["East Renfrewshire",18,0,6,45,93,273]
["Edinburgh",1327,0,0,0,9,85]
["Eilean Siar",1,78,78,78,78,78]
["Falkirk",446,0,0,0,0,19]
["Fife",402,0,1,6,15,69]
["Glasgow City",2792,0,0,1,9,51]
["Highland",46,8,26,51,126,287]
["Inverclyde",101,0,1,6,41,108]
["Midlothian",5,48,48,56,59,77]
["Moray",222,0,1,7,38,148]
["North Ayrshire",480,0,0,0,0,127]
["North Lanarkshire",138,2,23,101,266,415]
["Orkney",6,53,71,112,148,157]
["Perth & Kinross",435,0,0,3,13,173]
["Renfrewshire",442,0,0,0,2,47]
["Scottish Borders",178,6,11,18,31,89]
["Shetland",52,0,0,0,0,172]
["South Ayrshire",370,0,0,0,0,0]
["South Lanarkshire",150,7,16,24,40,129]
["Stirling",18,0,4,33,60,169]
["West Dunbartonshire",21,5,20,49,67,143]
["West Lothian",204,0,0,15,47,168]
[]
["Notes"]
["P5 = 5th Percentile.  5% of approaches have been open for this many days."]
["Q1 = First Quartile.  25% of approaches have been open for this many days."]
["Median.  50% of approaches have been open for this many days."]
["Q3 = First Quartile.  75% of approaches have been open for this many days. Conversely, 25% of cases have been open for more than this number of days."]
["P95 = 95th Percentile.  5% of approaches have been open for more than this number of days."]
[]
[]
["Data for Box Plot"]
[]
[null,"Number of days between Approach Date and 30 September 2017"]
["Local Authority","P5","Q1","Median","Q3","P95"]
["Clackmannanshire",0,0,0,0,0]
["Dumfries & Galloway",0,0,0,0,0]
["East Dunbartonshire",0,0,0,0,71]
["Edinburgh",0,0,0,9,85]
["Falkirk",0,0,0,0,19]
["North Ayrshire",0,0,0,0,127]
["Renfrewshire",0,0,0,2,47]
["Shetland",0,0,0,0,172]
["South Ayrshire",0,0,0,0,0]
["Scotland",0,0,1,13,109]
["Aberdeenshire",0,0,1,10,78]
["Glasgow City",0,0,1,9,51]
["Argyll & Bute",0,1,3,13,73]
["Perth & Kinross",0,0,3,13,173]
["Dundee City",1,2,4,15,106]
["Aberdeen City",0,0,5,80,628]
["Fife",0,1,6,15,69]
["Inverclyde",0,1,6,41,108]
["Angus",0,2,7,16,84]
["Moray",0,1,7,38,148]
["East Ayrshire",10,10,14,29,40]
["West Lothian",0,0,15,47,168]
["Scottish Borders",6,11,18,31,89]
["South Lanarkshire",7,16,24,40,129]
["Stirling",0,4,33,60,169]
["East Lothian",1,14,38,59,197]
["East Renfrewshire",0,6,45,93,273]
["West Dunbartonshire",5,20,49,67,143]
["Highland",8,26,51,126,287]
["Midlothian",48,48,56,59,77]
["Eilean Siar",78,78,78,78,78]
["North Lanarkshire",2,23,101,266,415]
["Orkney",53,71,112,148,157]
[]
[{"$f":"A113","v":"Local Authority"},"Q1","Median-Q1","Q3-Median","Q1-P5","P95-Q3","Median"]
["Clackmannanshire",{"$f":"C114","v":0},{"$f":"D114-C114","v":0},{"$f":"E114-D114","v":0},{"$f":"C114-B114","v":0},{"$f":"F114-E114","v":0},{"$f":"D114","v":0}]
["Dumfries & Galloway",{"$f":"C115","v":0},{"$f":"D115-C115","v":0},0,{"$f":"C115-B115","v":0},{"$f":"F115-E115","v":0},{"$f":"D115","v":0}]
["East Dunbartonshire",0,0,0,0,71,0]
["Edinburgh",0,0,9,0,76,0]
["Falkirk",0,0,0,0,19,0]
["North Ayrshire",0,0,0,0,127,0]
["Renfrewshire",0,0,2,0,45,0]
["Shetland",0,0,0,0,172,0]
["South Ayrshire",0,0,0,0,0,0]
["Scotland",0,1,12,0,96,1]
["Aberdeenshire",0,1,9,0,68,1]
["Glasgow City",0,1,8,0,42,1]
["Argyll & Bute",1,2,10,1,60,3]
["Perth & Kinross",0,3,10,0,160,3]
["Dundee City",2,2,11,1,91,4]
["Aberdeen City",0,5,75,0,548,5]
["Fife",1,5,9,1,54,6]
["Inverclyde",1,{"$f":"D131-C131","v":5},35,1,67,6]
["Angus",2,5,9,2,68,7]
["Moray",1,6,31,1,110,7]
["East Ayrshire",10,4,15,0,11,14]
["West Lothian",0,15,32,0,121,15]
["Scottish Borders",11,7,13,5,58,18]
["South Lanarkshire",16,8,16,9,89,24]
["Stirling",4,29,27,4,109,33]
["East Lothian",14,24,21,13,138,38]
["East Renfrewshire",6,39,48,6,180,45]
["West Dunbartonshire",20,29,18,15,76,49]
["Highland",26,25,75,18,161,51]
["Midlothian",48,8,3,0,18,56]
["Eilean Siar",78,0,0,0,0,78]
["North Lanarkshire",23,78,165,21,149,101]
["Orkney",71,41,36,{"$f":"C146-B146","v":18},{"$f":"F146-E146","v":9},{"$f":"D146","v":112}]

{"sheet":"Chart 11- Lost Contact NK Boxpl","index":26,"n_rows":180,"n_cols":9,"rows_kept":180,"cut":false,"hidden":false,"merged":[[65,0,66,0],[65,1,66,1],[65,2,65,6]]}
["Chart 11: Distribution of the number of days to outcome approach as Lost Contact or Not Known by LA",null,null,null,null,null,null,null,"Back to Contents"]
["All approaches closed between 1 April and 30 September 2017 where the outcome was lost contact or not known."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Working for Chart 12:  Distribution of the number of days to outcome approach as Lost Contact or Not Known by LA"]
[]
["Local Authority","Number of approaches with an outcomes of not known/ lost contact","Number of days between Approach Date and Outcome Date "]
[null,null,"P5","Q1","Median","Q3","P95"]
["Scotland",5704,0,31,137,588,846]
["Aberdeen City",2666,93,449,601,735,922]
["Aberdeenshire",271,2,27,50,71,140]
["Angus",54,4,29,41,91,479]
["Argyll & Bute",101,7,28,37,54,222]
["Clackmannanshire",5,0,33,116,127,166]
["Dumfries & Galloway",99,0,0,0,0,119]
["Dundee City",143,0,1,19,42,104]
["East Ayrshire",4,106,107,114,143,167]
["East Dunbartonshire",26,0,0,0,0,35]
["East Lothian",10,26,29,64,67,94]
["East Renfrewshire",3,33,33,270,332,332]
["Edinburgh",459,0,27,31,55,139]
["Eilean Siar",0,".",".",".",".","."]
["Falkirk",44,8,56,75,79,134]
["Fife",191,3,21,38,63,142]
["Glasgow City",656,0,8,15,55,167]
["Highland",21,32,89,174,208,292]
["Inverclyde",114,5,36,74,141,555]
["Midlothian",5,23,31,34,193,348]
["Moray",60,13,35,55,83,142]
["North Ayrshire",30,0,0,1,368,418]
["North Lanarkshire",48,156,256,536,579,928]
["Orkney",3,29,29,67,147,147]
["Perth & Kinross",217,0,6,33,111,801]
["Renfrewshire",117,1,20,23,33,148]
["Scottish Borders",112,9,21,46,83,147]
["Shetland",22,0,63,92,155,214]
["South Ayrshire",10,0,0,16,19,35]
["South Lanarkshire",145,27,57,86,150,365]
["Stirling",16,13,32,52,96,194]
["West Dunbartonshire",19,27,56,78,196,304]
["West Lothian",33,7,43,84,153,337]
[]
["Notes"]
["P5 = 5th Percentile.  5% of approaches have been open for this many days."]
["Q1 = First Quartile.  25% of approaches have been open for this many days."]
["Median.  50% of approaches have been open for this many days."]
["Q3 = First Quartile.  75% of approaches have been open for this many days. Conversely, 25% of cases have been open for more than this number of days."]
["P95 = 95th Percentile. 95% of approaches have been open for more than this number of days. Conversely, 5% of approaches have been open for more than this number of days."]
[]
[]
["Data for Box Plot"]
[]
[null,"Number of days between Approach Date and 30 September 2015"]
["Local Authority","P5","Q1","Median","Q3","P95"]
["Dumfries & Galloway",0,0,0,0,119]
["East Dunbartonshire",0,0,0,0,35]
["Eilean Siar",0,0,0,0,0]
["North Ayrshire",0,0,1,368,418]
["Glasgow City",0,8,15,55,167]
["South Ayrshire",0,0,16,19,35]
["Dundee City",0,1,19,42,104]
["Renfrewshire",1,20,23,33,148]
["Edinburgh",0,27,31,55,139]
["Perth & Kinross",0,6,33,111,801]
["Midlothian",23,31,34,193,348]
["Argyll & Bute",7,28,37,54,222]
["Fife",3,21,38,63,142]
["Angus",4,29,41,91,479]
["Scottish Borders",9,21,46,83,147]
["Aberdeenshire",2,27,50,71,140]
["Stirling",13,32,52,96,194]
["Moray",13,35,55,83,142]
["East Lothian",26,29,64,67,94]
["Orkney",29,29,67,147,147]
["Inverclyde",5,36,74,141,555]
["Falkirk",8,56,75,79,134]
["West Dunbartonshire",27,56,78,196,304]
["West Lothian",7,43,84,153,337]
["South Lanarkshire",27,57,86,150,365]
["Shetland",0,63,92,155,214]
["East Ayrshire",106,107,114,143,167]
["Clackmannanshire",0,33,116,127,166]
["Scotland",0,31,137,588,846]
["Highland",32,89,174,208,292]
["East Renfrewshire",33,33,270,332,332]
["North Lanarkshire",156,256,536,579,928]
["Aberdeen City",93,449,601,735,922]
[]
[{"$f":"A113","v":"Local Authority"},"Q1","Median-Q1","Q3-Median","Q1-P5","P95-Q3","Median"]
[{"$f":"A114","v":"Dumfries & Galloway"},{"$f":"C114","v":0},{"$f":"D114-C114","v":0},{"$f":"E114-D114","v":0},{"$f":"C114-B114","v":0},{"$f":"F114-E114","v":119},{"$f":"D114","v":0}]
[{"$f":"A115","v":"East Dunbartonshire"},{"$f":"C115","v":0},{"$f":"D115-C115","v":0},0,{"$f":"C115-B115","v":0},{"$f":"F115-E115","v":35},{"$f":"D115","v":0}]
[{"$f":"A117","v":"North Ayrshire"},{"$f":"C117","v":0},{"$f":"D117-C117","v":1},367,{"$f":"C117-B117","v":0},{"$f":"F117-E117","v":50},{"$f":"D117","v":1}]
["Glasgow City",8,7,40,8,112,15]
["South Ayrshire",0,16,3,0,16,16]
["Dundee City",1,18,23,1,62,19]
["Renfrewshire",20,3,10,19,115,23]
["Edinburgh",27,4,24,27,84,31]
["Perth & Kinross",6,27,78,6,690,33]
["Midlothian",31,3,159,8,155,34]
["Argyll & Bute",28,9,17,21,168,37]
["Fife",21,17,25,18,79,38]
["Angus",29,12,50,25,388,41]
["Scottish Borders",21,25,37,12,64,46]
["Aberdeenshire",27,23,21,25,69,50]
["Stirling",32,20,44,19,98,52]
["Moray",35,{"$f":"D131-C131","v":20},28,22,59,55]
["East Lothian",29,35,3,3,27,64]
["Orkney",29,38,80,0,0,67]
["Inverclyde",36,38,67,31,414,74]
["Falkirk",56,19,4,48,55,75]
["West Dunbartonshire",56,22,118,29,108,78]
["West Lothian",43,41,69,36,184,84]
["South Lanarkshire",57,29,64,30,215,86]
["Shetland",63,29,63,63,59,92]
["East Ayrshire",107,7,29,1,24,114]
["Clackmannanshire",33,83,11,33,39,116]
["Scotland",31,106,451,31,258,137]
["Highland",89,85,34,57,84,174]
["East Renfrewshire",33,237,62,0,0,270]
["North Lanarkshire",{"$f":"C145","v":256},{"$f":"D145-C145","v":280},{"$f":"E145-D145","v":43},{"$f":"C145-B145","v":100},{"$f":"F145-E145","v":349},{"$f":"D145","v":536}]
["Aberdeen City",449,152,134,356,187,601]

{"sheet":"Table 10 - Repeat Approaches","index":27,"n_rows":83,"n_cols":6,"rows_kept":83,"cut":false,"hidden":false,"merged":[[3,1,3,3],[3,5,4,5],[3,4,4,4],[3,0,4,0]]}
["Table 10: Households making Repeat Approaches",null,null,null,"Back to Contents"]
["All households making approaches during the last 6 months, 1 April 2017 to 30 September 2017"]
[]
["Local Authority","Households Making",null,null,"All Households","Proportion of Households making Repeat Approaches"]
[null,"One approach only","Two approaches","Three or more approaches"]
["Scotland",20665,1110,105,21875,{"$f":"SUM(C6:D6)/E6","v":5.5542857142857144E-2}]
["Aberdeen City",2055,75,0,2130,{"$f":"SUM(C7:D7)/E7","v":3.5211267605633804E-2}]
["Aberdeenshire",755,30,0,785,3.8216560509554139E-2]
["Angus",360,10,0,370,2.7027027027027029E-2]
["Argyll & Bute",785,50,5,840,6.5476190476190479E-2]
["Clackmannanshire",255,5,5,260,3.8461538461538464E-2]
["Dumfries & Galloway",450,20,0,470,4.2553191489361701E-2]
["Dundee City",545,20,0,570,3.5087719298245612E-2]
["East Ayrshire",30,0,0,30,0]
["East Dunbartonshire",135,10,0,150,6.6666666666666666E-2]
["East Lothian",50,0,0,50,0]
["East Renfrewshire",60,5,0,65,7.6923076923076927E-2]
["Edinburgh",2545,90,5,2640,3.5984848484848488E-2]
["Eilean Siar",0,0,0,0]
["Falkirk",790,80,5,870,9.7701149425287362E-2]
["Fife",1170,60,10,1235,5.6680161943319839E-2]
["Glasgow City",4030,330,40,4400,8.4090909090909091E-2]
["Highland",105,0,0,110,0]
["Inverclyde",360,20,10,390,7.6923076923076927E-2]
["Midlothian",130,10,0,135,7.407407407407407E-2]
["Moray",525,15,0,540,2.7777777777777776E-2]
["North Ayrshire",815,20,0,835,2.3952095808383235E-2]
["North Lanarkshire",890,10,0,900,1.1111111111111112E-2]
["Orkney",15,0,0,15,0]
["Perth & Kinross",975,125,5,1110,0.11711711711711711]
["Renfrewshire",870,65,5,945,7.407407407407407E-2]
["Scottish Borders",355,10,0,365,2.7397260273972601E-2]
["Shetland",105,0,0,105,0]
["South Ayrshire",490,15,0,505,2.9702970297029702E-2]
["South Lanarkshire",395,10,0,405,2.4691358024691357E-2]
["Stirling",160,10,0,170,5.8823529411764705E-2]
["West Dunbartonshire",110,0,0,115,0]
["West Lothian",350,15,0,365,4.1095890410958902E-2]
[]
["Disclosure Control has been applied to this table.  All cells have been rounded to the nearest five."]
["Row totals may not sum to total of individual cells due to rounding."]
[]
[]
[]
[]
[]
[]
[]
["Chart Data - Repeat approaches"]
[null,"Proportion of Households making Repeat Approaches"]
["Perth & Kinross",0.11711711711711711]
["Falkirk",9.7701149425287362E-2]
["Glasgow City",8.4090909090909091E-2]
["East Renfrewshire",7.6923076923076927E-2]
["Inverclyde",7.6923076923076927E-2]
["Midlothian",7.407407407407407E-2]
["Renfrewshire",7.407407407407407E-2]
["East Dunbartonshire",6.6666666666666666E-2]
["Argyll & Bute",6.5476190476190479E-2]
["Stirling",5.8823529411764705E-2]
["Fife",5.6680161943319839E-2]
["Scotland",5.5542857142857144E-2]
["Dumfries & Galloway",4.2553191489361701E-2]
["West Lothian",4.1095890410958902E-2]
["Clackmannanshire",3.8461538461538464E-2]
["Aberdeenshire",3.8216560509554139E-2]
["Edinburgh",3.5984848484848488E-2]
["Aberdeen City",3.5211267605633804E-2]
["Dundee City",3.5087719298245612E-2]
["South Ayrshire",2.9702970297029702E-2]
["Moray",2.7777777777777776E-2]
["Scottish Borders",2.7397260273972601E-2]
["Angus",2.7027027027027029E-2]
["South Lanarkshire",2.4691358024691357E-2]
["North Ayrshire",2.3952095808383235E-2]
["North Lanarkshire",1.1111111111111112E-2]
["East Ayrshire",0]
["East Lothian",0]
["Highland",0]
["Orkney",0]
["Shetland",0]
["West Dunbartonshire",0]
["Eilean Siar"]

{"sheet":"Chart 12- Repeat Approaches","index":28,"n_rows":2,"n_cols":13,"rows_kept":2,"cut":false,"hidden":false,"merged":[]}
["Chart 12: Proportion of Unique Households in each LA area making Repeat Approaches",null,null,null,null,null,null,null,null,null,null,null,"Back to Contents"]
["All Households making approaches between 1 April and 30 September 2017"]

{"sheet":"SAS code - last 6 months","index":29,"n_rows":511,"n_cols":49,"rows_kept":511,"cut":false,"hidden":true,"merged":[]}
["Table 1: Total Housing Options approaches by LA and quarter"]
[null,"Quarter of Approach"]
[null,"2014 Q2","2014 Q3","2014 Q4","2015 Q1","2015 Q2","2015 Q3","2015 Q4","2016 Q1","2016 Q2","2016 Q3","2016 Q4","2017 Q1","2017 Q2","2017 Q3"]
[null,"N","N","N","N","N","N","N","N","N","N","N","N","N","N"]
["Aberdeen City",1167,1595,1617,1908,1708,1582,1332,1516,1416,1398,1024,1345,1218,1003]
["Aberdeenshire",573,478,422,614,558,532,437,574,479,461,391,458,406,422]
["Angus",273,274,238,295,261,252,178,215,292,305,191,270,181,199]
["Argyll & Bute",129,99,261,638,579,455,401,465,436,491,374,481,518,466]
["Clackmannanshire",31,44,29,27,13,50,28,25,123,101,88,180,150,121]
["Dumfries & Galloway",237,250,193,212,231,201,192,235,220,254,203,299,237,255]
["Dundee City",767,787,439,478,547,552,490,617,531,501,466,656,352,238]
["East Ayrshire",63,47,21,26,7,5,1,31,15,32,23,28,20,11]
["East Dunbartonshire",33,32,33,36,34,39,25,68,58,126,88,148,107,58]
["East Lothian",124,109,64,134,89,110,91,72,53,42,52,53,23,26]
["East Renfrewshire",38,52,47,23,44,48,44,50,54,47,39,43,35,29]
["Edinburgh",1940,2106,1960,2168,2044,1928,1783,1844,1761,1602,1468,1595,1466,1274]
["Eilean Siar",6,3,2,5,2,1,3,6,2,2,2,8,1,1]
["Falkirk",567,580,433,476,441,471,397,521,485,513,448,541,504,462]
["Fife",804,832,649,904,843,716,558,696,700,691,571,737,716,588]
["Glasgow City",3686,3212,2845,3326,2113,2719,2385,2891,2527,2521,2085,2592,2484,2363]
["Highland",492,490,346,401,464,431,328,323,161,129,75,109,78,30]
["Inverclyde",226,307,216,250,240,215,204,264,234,212,224,276,222,240]
["Midlothian",162,129,90,125,124,89,87,113,101,109,91,88,66,75]
["Moray",323,305,270,340,316,231,227,325,257,267,242,318,278,278]
["North Ayrshire",469,482,409,565,469,480,378,468,435,379,321,434,425,435]
["North Lanarkshire",920,873,742,995,898,923,725,873,835,828,912,631,468,443]
["Orkney",9,17,13,14,11,18,9,22,12,12,3,4,7,6]
["Perth & Kinross",565,535,487,551,458,545,433,551,577,588,526,672,633,619]
["Renfrewshire",461,520,459,550,533,520,469,584,529,542,484,562,523,491]
["Scottish Borders",277,254,202,271,259,241,162,205,209,218,166,255,189,185]
["Shetland",99,67,74,63,42,40,43,40,51,43,56,51,47,64]
["South Ayrshire",242,229,247,352,367,395,357,448,310,261,223,215,256,266]
["South Lanarkshire",346,364,253,333,262,317,236,265,226,194,173,259,225,189]
["Stirling",202,234,157,55,100,103,78,131,103,91,52,70,91,85]
["West Dunbartonshire",422,465,386,384,286,45,20,34,41,58,42,56,60,54]
["West Lothian",372,429,316,428,329,341,274,369,335,301,254,181,224,151]
["Scotland",16025,16200,13920,16947,14672,14595,12375,14841,13568,13319,11357,13615,12210,11127]
["Household is assigned to local authority of most recent approach"]
["Table 1M: Total Housing Options approaches by LA and quarter"]
[null,"approach_year"]
[null,2014,null,null,null,null,null,null,null,null,null,null,null,2015,null,null,null,null,null,null,null,null,null,null,null,2016,null,null,null,null,null,null,null,null,null,null,null,2017]
[null,"approach_month",null,null,null,null,null,null,null,null,null,null,null,"approach_month",null,null,null,null,null,null,null,null,null,null,null,"approach_month",null,null,null,null,null,null,null,null,null,null,null,"approach_month"]
[null,1,2,3,4,5,6,7,8,9,10,11,12,1,2,3,4,5,6,7,8,9,10,11,12,1,2,3,4,5,6,7,8,9,10,11,12,1,2,3,4,5,6,7,8,9,10,11,12]
["Scotland",0,0,0,5418,5127,5480,5473,5286,5441,5556,4696,3668,5589,5513,5845,4900,4798,4974,4734,4994,4867,4715,4438,3222,4774,4988,5079,4555,4408,4605,4054,4712,4553,4293,4155,2909,4482,4303,4830,3768,4337,4105,3771,4085,3271,0,0,0]
["Household is assigned to local authority of most recent approach"]
["Table 3a: Reasons for Housing Options approaches by quarter"]
[null,"Quarter of Approach"]
[null,"2014 Q2","2014 Q3","2014 Q4","2015 Q1","2015 Q2","2015 Q3","2015 Q4","2016 Q1","2016 Q2","2016 Q3","2016 Q4","2017 Q1","2017 Q2","2017 Q3",null,null,"N","N","N","N","N","N","N","N","N","N"]
[null,"N","N","N","N","N","N","N","N","N","N","N","N","N","N",null,null,"2015 Q2","2015 Q3","2015 Q4","2016 Q1","2016 Q2","2016 Q3","2016 Q4","2017 Q1","2017 Q2","2017 Q3"]
["Termination of tenancy / mortgage due to rent arrears / default on payments",893,872,720,905,653,576,561,627,555,458,428,574,464,405,null,"General housing options advice",1975,2115,1810,2392,2090,2085,1779,2174,2201,2077]
["Other action by landlord resulting in the termination of the tenancy",1163,1016,828,1207,1042,1041,819,1122,1127,972,757,1077,951,763,null,"Asked to leave",2132,2102,1782,2121,1979,1779,1464,1878,1634,1517]
["Applicant terminated secure accommodation",168,176,159,177,148,155,131,144,112,149,115,148,135,125,null,"Dispute within household / relationship breakdown: non-violent",1850,1895,1581,1879,1669,1776,1535,1988,1582,1453]
["Loss of service / tied accommodation",82,82,65,71,61,64,63,59,66,49,34,49,40,57,null,"Risk of losing accommodation",1274,1126,1006,1227,1062,1103,924,1041,949,900]
["Discharge from prison / hospital / care / other institution",1150,952,719,887,674,672,523,586,609,536,546,597,568,470,null,"Other action by landlord resulting in the termination of the tenancy",1042,1041,819,1122,1127,972,757,1077,951,763]
["Emergency (fire, flood, storm, closing order from Environmental Health etc.)",28,50,38,46,41,34,36,45,51,27,42,31,34,22,null,"Dispute within household: violent or abusive",836,881,780,838,816,789,708,826,785,747]
["Forced division and sale of matrimonial home",71,81,62,63,69,71,45,63,56,51,37,48,44,49,null,"Discharge from prison / hospital / care / other institution",674,672,523,586,609,536,546,597,568,470]
["Other reason for loss of accommodation",447,395,367,466,314,347,333,408,432,372,369,407,454,373,null,"Other reason for leaving accommodation / household",473,543,508,505,479,554,411,501,413,434]
["Dispute within household: violent or abusive",935,1042,823,943,836,881,780,838,816,789,708,826,785,747,null,"Accommodation unsuitable",614,619,433,531,497,639,521,633,582,416]
["Dispute within household / relationship breakdown: non-violent",2267,2279,1850,2139,1850,1895,1581,1879,1669,1776,1535,1988,1582,1453,null,"Termination of tenancy / mortgage due to rent arrears / default on payments",653,576,561,627,555,458,428,574,464,405]
["Fleeing non-domestic violence",273,260,214,206,211,215,175,173,200,131,137,158,161,153,null,"Other reason for loss of accommodation",314,347,333,408,432,372,369,407,454,373]
["Harassment",256,283,206,215,227,208,153,162,180,187,145,182,156,166,null,"Personal issues – affordability / financial difficulties",388,383,297,368,360,443,479,455,323,304]
["Overcrowding",316,311,270,346,254,237,225,256,185,194,155,201,178,146,null,"Other",735,696,586,666,499,406,243,196,190,198]
["Asked to leave",2363,2472,2062,2474,2132,2102,1782,2121,1979,1779,1464,1878,1634,1517,null,"Harassment",227,208,153,162,180,187,145,182,156,166]
["Other reason for leaving accommodation / household",632,673,511,558,473,543,508,505,479,554,411,501,413,434,null,"Fleeing non-domestic violence",211,215,175,173,200,131,137,158,161,153]
["General housing options advice",1689,1752,1595,2112,1975,2115,1810,2392,2090,2085,1779,2174,2201,2077,null,"Overcrowding",254,237,225,256,185,194,155,201,178,146]
["Benefit issues & Welfare Reform",343,216,279,332,248,157,148,183,117,215,188,132,139,127,null,"Benefit issues & Welfare Reform",248,157,148,183,117,215,188,132,139,127]
["Property condition",140,144,146,219,136,127,139,167,104,98,95,123,74,68,null,"Applicant terminated secure accommodation",148,155,131,144,112,149,115,148,135,125]
["Accommodation unsuitable",412,558,508,587,614,619,433,531,497,639,521,633,582,416,null,"Household experiencing anti-social behaviour / neighbour problems",104,104,67,94,114,106,92,100,88,93]
["Household experiencing anti-social behaviour / neighbour problems",103,108,85,76,104,104,67,94,114,106,92,100,88,93,null,"Property condition",136,127,139,167,104,98,95,123,74,68]
["Other",544,657,659,728,735,696,586,666,499,406,243,196,190,198,null,"Loss of service / tied accommodation",61,64,63,59,66,49,34,49,40,57]
["Household member needing care",71,148,166,209,165,182,140,182,176,170,119,62,40,37,null,"Forced division and sale of matrimonial home",69,71,45,63,56,51,37,48,44,49]
["Personal issues – affordability / financial difficulties",365,376,334,468,388,383,297,368,360,443,479,455,323,304,null,"Household member needing care",165,182,140,182,176,170,119,62,40,37]
["Risk of losing accommodation",1266,1242,1212,1463,1274,1126,1006,1227,1062,1103,924,1041,949,900,null,"Landlord issue",48,45,34,43,33,30,34,34,25,27]
["Landlord issue",48,55,42,50,48,45,34,43,33,30,34,34,25,27,null,"Emergency (fire, flood, storm, closing order from Environmental Health etc.)",41,34,36,45,51,27,42,31,34,22]
["Scotland",16025,16200,13920,16947,14672,14595,12375,14841,13568,13319,11357,13615,12210,11127,null,"Scotland",14672,14595,12375,14841,13568,13319,11357,13615,12210,11127]
["Household is assigned to local authority of most recent approach"]
["Table 3b: Reasons for Housing Options approaches by quarter"]
[null,"Quarter of Approach"]
[null,"2014 Q2","2014 Q3","2014 Q4","2015 Q1","2015 Q2","2015 Q3","2015 Q4","2016 Q1","2016 Q2","2016 Q3","2016 Q4","2017 Q1","2017 Q2","2017 Q3"]
[null,"N","N","N","N","N","N","N","N","N","N","N","N","N","N"]
["Homelessness Type",11044,10944,8894,10703,8985,9041,7715,8988,8516,8024,6883,8665,7599,6880]
["Prevention Type",4981,5256,5026,6244,5687,5554,4660,5853,5052,5295,4474,4950,4611,4247]
["Scotland",16025,16200,13920,16947,14672,14595,12375,14841,13568,13319,11357,13615,12210,11127]
["Household is assigned to local authority of most recent approach"]
["Table 4: Maximum Type of Housing Options activities by quarter"]
[null,null,"Quarter of Approach"]
[null,null,"2014 Q2","2014 Q3","2014 Q4","2015 Q1","2015 Q2","2015 Q3","2015 Q4","2016 Q1","2016 Q2","2016 Q3","2016 Q4","2017 Q1","2017 Q2","2017 Q3"]
[0,"N",".",".",1,".",".",".",".",".",".",".",".",".",".","."]
[1,"N",8108,8850,7882,9471,8291,7935,6665,8133,7428,7072,6127,7466,6965,6355]
[2,"N",7834,7287,5987,7435,6349,6620,5683,6666,6073,6177,5152,6070,5169,4707]
[3,"N",83,63,50,41,32,40,27,42,67,70,78,79,76,65]
["Total","N",16025,16200,13920,16947,14672,14595,12375,14841,13568,13319,11357,13615,12210,11127]
["Household is assigned to local authority of most recent approach"]
["Table 5: Housing Options activities by quarter"]
[null,null,"Quarter of Approach",null,null,null,null,null,null,null,null,null,null,null,null,null,"All"]
[null,null,"2014 Q2","2014 Q3","2014 Q4","2015 Q1","2015 Q2","2015 Q3","2015 Q4","2016 Q1","2016 Q2","2016 Q3","2016 Q4","2017 Q1","2017 Q2","2017 Q3",null,null,null,"2015 Q2","2015 Q3","2015 Q4","2016 Q1","2016 Q2","2016 Q3","2016 Q4","2017 Q1","2017 Q2","2017 Q3"]
["Mediation/outreach work","N",556,667,520,644,397,393,339,440,414,475,342,416,315,252,6170,null,"General Housing advice/Tenancy rights advice",12462,12712,10400,12594,11084,10662,8906,10934,9839,8499]
["Financial assistance/advice","N",2438,2830,2380,2705,2439,2474,2059,2147,2007,2193,1822,1814,1593,1357,30258,null,"Client informed of rights under homelessness legislation",7814,7839,6827,8103,7466,7110,6138,7739,6806,6294]
["Rent/repairs/referrals/negotiation with landlords","N",2313,2259,1969,2626,2246,2315,1765,1850,1679,1778,1464,1741,1588,1514,27107,null,"Rent/repairs/referrals/negotiation with landlords",2246,2315,1765,1850,1679,1778,1464,1741,1588,1514]
["Help to remain in accommodation","N",832,902,709,801,693,774,566,732,616,736,560,564,579,417,9481,null,"Help to move property",1874,2008,1601,2000,2028,2154,1702,2173,1958,1443]
["Mortgage/home ownership advice","N",160,204,115,172,164,154,99,131,97,91,68,103,86,65,1709,null,"Other",1611,1642,1393,1696,1546,1686,1437,1455,1113,1414]
["Tenancy/social care support/adaptations to property","N",322,342,291,410,372,340,343,419,377,342,251,343,419,382,4953,null,"Financial assistance/advice",2439,2474,2059,2147,2007,2193,1822,1814,1593,1357]
["Referral to health/Social Work/employment services","N",960,1026,931,913,795,958,717,836,805,882,734,825,837,760,11979,null,"Referral to health/Social Work/employment services",795,958,717,836,805,882,734,825,837,760]
["Client informed of rights under homelessness legislation","N",9131,8526,6697,8674,7814,7839,6827,8103,7466,7110,6138,7739,6806,6294,105164,null,"Help to remain in accommodation",693,774,566,732,616,736,560,564,579,417]
["General Housing advice/Tenancy rights advice","N",12143,12294,10544,13220,12462,12712,10400,12594,11084,10662,8906,10934,9839,8499,156293,null,"Tenancy/social care support/adaptations to property",372,340,343,419,377,342,251,343,419,382]
["Help to move property","N",1869,2000,1598,1969,1874,2008,1601,2000,2028,2154,1702,2173,1958,1443,26377,null,"Mediation/outreach work",397,393,339,440,414,475,342,416,315,252]
["Other","N",1437,2236,1619,1610,1611,1642,1393,1696,1546,1686,1437,1455,1113,1414,21895,null,"Mortgage/home ownership advice",164,154,99,131,97,91,68,103,86,65]
["Total (ALL)","N",32161,33286,27373,33744,30867,31609,26109,30948,28119,28109,23424,28107,25133,22397,401386,null,"Total (ALL)",30867,31609,26109,30948,28119,28109,23424,28107,25133,22397]
["Household is assigned to local authority of most recent approach"]
["Table 6: Housing Options activities by Local Authority, during the last 6 months, 1 April 2017 to 30 Sept 2017"]
[null,null,"ACTIVITY",null,null,null,null,null,null,null,null,null,null,"All"]
[null,null,"Mediation/outreach work","Financial assistance/advice","Rent/repairs/referrals/negotiation with landlords","Help to remain in accommodation","Mortgage/home ownership advice","Tenancy/social care support/adaptations to property","Referral to health/Social Work/employment services","Client informed of rights under homelessness legislation","General Housing advice/Tenancy rights advice","Help to move property","Other"]
["Aberdeen City","N",21,33,22,88,6,7,23,742,1145,189,0,2276]
["Aberdeenshire","N",21,210,263,19,9,6,18,629,894,5,19,2093]
["Angus","N",6,224,79,36,5,25,10,282,428,281,0,1376]
["Argyll & Bute","N",5,24,62,128,0,41,5,433,612,88,7,1405]
["Clackmannanshire","N",0,1,9,1,0,0,0,276,243,19,2,551]
["Dumfries & Galloway","N",2,15,42,9,0,83,27,457,479,149,11,1274]
["Dundee City","N",10,11,31,12,0,3,5,594,681,65,20,1432]
["East Ayrshire","N",2,55,38,4,19,22,15,31,37,5,1,229]
["East Dunbartonshire","N",0,94,70,10,6,3,4,130,136,152,1,606]
["East Lothian","N",0,25,58,13,4,0,0,47,76,54,7,284]
["East Renfrewshire","N",0,26,24,6,4,4,8,59,52,5,0,188]
["Edinburgh","N",2,94,46,6,3,2,45,824,1687,17,15,2741]
["Eilean Siar","N",0,2,1,0,0,0,1,1,1,1,0,7]
["Falkirk","N",331,969,76,460,0,48,487,1020,1229,753,1492,6865]
["Fife","N",31,147,428,37,52,28,69,1105,1456,265,56,3674]
["Glasgow City","N",11,70,81,52,1,2,636,1795,2265,26,0,4939]
["Highland","N",1,7,5,7,7,0,0,66,96,1,0,190]
["Inverclyde","N",2,4,0,4,0,0,4,233,322,20,5,594]
["Midlothian","N",15,26,13,1,2,5,2,127,236,31,108,566]
["Moray","N",25,66,29,4,0,8,14,430,528,105,124,1333]
["North Ayrshire","N",0,73,724,11,5,0,5,792,850,8,3,2471]
["North Lanarkshire","N",4,262,140,31,4,109,34,198,978,35,87,1882]
["Orkney","N",0,0,2,0,0,0,0,8,19,0,0,29]
["Perth & Kinross","N",8,18,235,0,2,2,5,427,724,7,75,1503]
["Renfrewshire","N",56,296,173,11,7,75,70,766,944,278,42,2718]
["Scottish Borders","N",0,32,53,1,0,46,4,224,279,114,1,754]
["Shetland","N",1,7,0,1,0,0,1,97,112,2,2,223]
["South Ayrshire","N",8,45,229,12,4,282,96,403,630,231,445,2385]
["South Lanarkshire","N",3,67,109,11,2,0,1,382,498,420,0,1493]
["Stirling","N",0,4,9,1,0,0,0,38,167,5,0,224]
["West Dunbartonshire","N",1,30,23,16,3,0,2,106,87,51,2,321]
["West Lothian","N",1,13,28,4,6,0,6,378,447,19,2,904]
["Scotland","N",567,2950,3102,996,151,801,1597,13100,18338,3401,2527,47530]
["Household is assigned to local authority of most recent approach"]
["Table 7: Outcomes by Quarter"]
[null,null,"Quarter of Outcome",null,null,null,null,null,null,null,null,null,null,null,null,null,"All",null,null,"2015 Q2","2015 Q3","2015 Q4","2016 Q1","2016 Q2","2016 Q3","2016 Q4","2017 Q1","2017 Q2","2017 Q3"]
[null,null,"2014 Q2","2014 Q3","2014 Q4","2015 Q1","2015 Q2","2015 Q3","2015 Q4","2016 Q1","2016 Q2","2016 Q3","2016 Q4","2017 Q1","2017 Q2","2017 Q3",null,null,"Made homelessness application to local authority",6624,6761,6203,6535,6478,5412,5521,6334,5367,4798]
["LA/RSL Tenancy","N",223,405,504,482,578,544,565,586,528,812,509,513,417,424,7090,null,"Remained in current accommodation",2606,2834,2705,2736,2613,2704,2376,3308,2832,2624]
["PRS Tenancy","N",267,459,415,458,489,462,468,408,459,502,395,422,402,401,6007,null,"Lost Contact/ Not known",1689,1794,2205,1900,2074,1906,1843,2961,4033,1671]
["Other (known)","N",458,717,656,470,515,576,439,680,545,735,715,892,682,613,8693,null,"Other (known)",515,576,439,680,545,735,715,892,682,613]
["Moved-in with friends/ relatives","N",185,339,292,258,246,251,302,275,267,307,232,268,258,251,3731,null,"LA/RSL Tenancy",578,544,565,586,528,812,509,513,417,424]
["Lost Contact/ Not known","N",1069,2522,2389,1777,1689,1794,2205,1900,2074,1906,1843,2961,4033,1671,29833,null,"PRS Tenancy",489,462,468,408,459,502,395,422,402,401]
["Remained in current accommodation","N",1649,2608,2963,2717,2606,2834,2705,2736,2613,2704,2376,3308,2832,2624,37275,null,"Moved-in with friends/ relatives",246,251,302,275,267,307,232,268,258,251]
["Made homelessness application to local authority","N",4984,6730,6106,7235,6624,6761,6203,6535,6478,5412,5521,6334,5367,4798,85088,null,"Total (ALL)",12747,13222,12887,13120,12964,12378,11591,14698,13991,10782]
["Total (ALL)","N",8835,13780,13325,13397,12747,13222,12887,13120,12964,12378,11591,14698,13991,10782,177717]
["Household is assigned to local authority of most recent approach"]
["Table 8: Outcomes by LA: during the last 6 months, 1 April 2017 to 30 Sept 2017"]
[null,null,"LA/RSL Tenancy","PRS Tenancy","Other (known)","Moved-in with friends/ relatives","Lost Contact/ Not known","Remained in current accommodation","Made homelessness application to local authority","All"]
["Aberdeen City","N",182,102,113,35,2666,971,628,4697]
["Aberdeenshire","N",20,52,20,26,271,174,264,827]
["Angus","N",15,18,17,1,54,179,267,551]
["Argyll & Bute","N",38,30,51,9,101,413,203,845]
["Clackmannanshire","N",0,0,0,1,5,9,220,235]
["Dumfries & Galloway","N",7,6,2,2,99,39,351,506]
["Dundee City","N",33,27,33,15,143,186,263,700]
["East Ayrshire","N",6,3,0,5,4,16,4,38]
["East Dunbartonshire","N",1,1,2,0,26,29,95,154]
["East Lothian","N",0,2,0,2,10,7,16,37]
["East Renfrewshire","N",1,5,1,1,3,16,18,45]
["Edinburgh","N",35,38,52,51,459,447,1327,2409]
["Eilean Siar","N",1,0,0,1,0,2,1,5]
["Falkirk","N",18,3,27,25,44,124,446,687]
["Fife","N",53,93,41,9,191,129,402,918]
["Glasgow City","N",32,5,381,121,656,698,2792,4685]
["Highland","N",3,10,11,11,21,44,46,146]
["Inverclyde","N",18,19,37,27,114,98,101,414]
["Midlothian","N",4,4,2,3,5,41,5,64]
["Moray","N",22,40,19,46,60,128,222,537]
["North Ayrshire","N",75,94,50,30,30,85,480,844]
["North Lanarkshire","N",51,9,34,10,48,471,138,761]
["Orkney","N",1,0,0,0,3,1,6,11]
["Perth & Kinross","N",38,91,258,8,217,410,435,1457]
["Renfrewshire","N",42,16,78,36,117,364,442,1095]
["Scottish Borders","N",35,32,16,2,112,63,178,438]
["Shetland","N",11,0,2,3,22,29,52,119]
["South Ayrshire","N",3,0,0,0,10,4,370,387]
["South Lanarkshire","N",38,76,18,13,145,84,150,524]
["Stirling","N",6,9,5,6,16,77,18,137]
["West Dunbartonshire","N",23,4,4,0,19,28,21,99]
["West Lothian","N",29,14,21,10,33,90,204,401]
["Total (ALL)","N",841,803,1295,509,5704,5456,10165,24773]
["Household is assigned to local authority of most recent approach"]
["Table 9: Outcomes: Number of days from approach to case closure - for the last 6 months - BOXPLOT"]
[null,"outcome_time"]
[null,"P5","Q1","Median","Q3","P95","N"]
["LA/RSL Tenancy",4,40,84,156,381,841]
["PRS Tenancy",6,29,60,129,374,803]
["Other (known)",0,4,33,103,371,1295]
["Moved-in with friends/ relatives",0,20,41,83,302,509]
["Lost Contact/ Not known",0,31,137,588,846,5704]
["Remained in current accommodation",0,19,48,112,392,5456]
["Made homelessness application to local authority",0,0,1,13,109,10165]
["All Outcomes",0,1,26,100,651,24773]
["Household is assigned to local authority of most recent approach"]
["Table 10: Outcomes: Number of days from approach to making a homeless application by LA - for the last 6 months - BOXPLOT"]
[null,"outcome_time"]
[null,"P5","Q1","Median","Q3","P95","N"]
["Aberdeen City",0,0,5,80,628,628]
["Aberdeenshire",0,0,1,10,78,264]
["Angus",0,2,7,16,84,267]
["Argyll & Bute",0,1,3,13,73,203]
["Clackmannanshire",0,0,0,0,0,220]
["Dumfries & Galloway",0,0,0,0,0,351]
["Dundee City",1,2,4,15,106,263]
["East Ayrshire",10,10,14,29,40,4]
["East Dunbartonshire",0,0,0,0,71,95]
["East Lothian",1,14,38,59,197,16]
["East Renfrewshire",0,6,45,93,273,18]
["Edinburgh",0,0,0,9,85,1327]
["Eilean Siar",78,78,78,78,78,1]
["Falkirk",0,0,0,0,19,446]
["Fife",0,1,6,15,69,402]
["Glasgow City",0,0,1,9,51,2792]
["Highland",8,26,51,126,287,46]
["Inverclyde",0,1,6,41,108,101]
["Midlothian",48,48,56,59,77,5]
["Moray",0,1,7,38,148,222]
["North Ayrshire",0,0,0,0,127,480]
["North Lanarkshire",2,23,101,266,415,138]
["Orkney",53,71,112,148,157,6]
["Perth & Kinross",0,0,3,13,173,435]
["Renfrewshire",0,0,0,2,47,442]
["Scottish Borders",6,11,18,31,89,178]
["Shetland",0,0,0,0,172,52]
["South Ayrshire",0,0,0,0,0,370]
["South Lanarkshire",7,16,24,40,129,150]
["Stirling",0,4,33,60,169,18]
["West Dunbartonshire",5,20,49,67,143,21]
["West Lothian",0,0,15,47,168,204]
["Scotland",0,0,1,13,109,10165]
["Household is assigned to local authority of most recent approach"]
["Table 11: Outcomes: Number of days from approach to case closed as type 'Lost Contact' and 'Not Known' by LA, for the last 6 months - BOXPLOT"]
[null,"outcome_time"]
[null,"P5","Q1","Median","Q3","P95","N"]
["Aberdeen City",93,449,601,735,922,2666]
["Aberdeenshire",2,27,50,71,140,271]
["Angus",4,29,41,91,479,54]
["Argyll & Bute",7,28,37,54,222,101]
["Clackmannanshire",0,33,116,127,166,5]
["Dumfries & Galloway",0,0,0,0,119,99]
["Dundee City",0,1,19,42,104,143]
["East Ayrshire",106,107,114,143,167,4]
["East Dunbartonshire",0,0,0,0,35,26]
["East Lothian",26,29,64,67,94,10]
["East Renfrewshire",33,33,270,332,332,3]
["Edinburgh",0,27,31,55,139,459]
["Eilean Siar",".",".",".",".",".",0]
["Falkirk",8,56,75,79,134,44]
["Fife",3,21,38,63,142,191]
["Glasgow City",0,8,15,55,167,656]
["Highland",32,89,174,208,292,21]
["Inverclyde",5,36,74,141,555,114]
["Midlothian",23,31,34,193,348,5]
["Moray",13,35,55,83,142,60]
["North Ayrshire",0,0,1,368,418,30]
["North Lanarkshire",156,256,536,579,928,48]
["Orkney",29,29,67,147,147,3]
["Perth & Kinross",0,6,33,111,801,217]
["Renfrewshire",1,20,23,33,148,117]
["Scottish Borders",9,21,46,83,147,112]
["Shetland",0,63,92,155,214,22]
["South Ayrshire",0,0,16,19,35,10]
["South Lanarkshire",27,57,86,150,365,145]
["Stirling",13,32,52,96,194,16]
["West Dunbartonshire",27,56,78,196,304,19]
["West Lothian",7,43,84,153,337,33]
["Scotland",0,31,137,588,846,5704]
["Household is assigned to local authority of most recent approach"]
["Table 12: Outcomes: Where approach did not result in an application for homelessness, not known or lost contact, in number of days, for the last 6 months - BOXPLOT"]
[null,"outcome_time"]
[null,"P5","Q1","Median","Q3","P95","N"]
["Aberdeen City",8,43,92,162,406,1403]
["Aberdeenshire",0,27,49,77,145,292]
["Angus",6,28,47,80,316,230]
["Argyll & Bute",0,23,45,85,251,541]
["Clackmannanshire",0,0,4,30,171,10]
["Dumfries & Galloway",0,0,1,74,152,56]
["Dundee City",0,8,27,62,146,294]
["East Ayrshire",30,81,103,155,208,30]
["East Dunbartonshire",0,0,0,1,108,33]
["East Lothian",13,28,34,104,157,11]
["East Renfrewshire",38,127,218,250,331,24]
["Edinburgh",0,0,28,31,84,623]
["Eilean Siar",0,31,41,397,764,5]
["Falkirk",0,0,9,39,86,197]
["Fife",1,15,33,62,176,325]
["Glasgow City",0,0,12,48,162,1237]
["Highland",0,38,125,327,574,79]
["Inverclyde",15,42,71,129,343,199]
["Midlothian",0,2,81,138,202,54]
["Moray",20,39,63,90,144,255]
["North Ayrshire",24,83,136,290,404,334]
["North Lanarkshire",14,155,257,470,641,575]
["Orkney",39,39,103,167,167,2]
["Perth & Kinross",0,13,39,126,426,805]
["Renfrewshire",17,22,32,70,187,536]
["Scottish Borders",6,18,49,104,210,148]
["Shetland",12,46,69,164,273,45]
["South Ayrshire",0,0,0,3,24,7]
["South Lanarkshire",33,63,99,163,553,229]
["Stirling",6,25,51,90,164,103]
["West Dunbartonshire",1,21,58,110,219,59]
["West Lothian",0,29,70,188,870,164]
["Scotland",0,19,49,118,381,8905]
["Household is assigned to local authority of most recent approach"]
["Table 13: All open cases on 30 Sept 2017 by LA"]
[null,"open_30092017"]
[null,"N"]
["Scotland",17058]
["LACODE",1726]
["Aberdeen City"]
["Aberdeenshire",219]
["Angus",82]
["Argyll & Bute",595]
["Clackmannanshire",120]
["Dumfries & Galloway",18]
["Dundee City",68]
["East Ayrshire",22]
["East Dunbartonshire",67]
["East Lothian",49]
["East Renfrewshire",104]
["Edinburgh",3563]
["Eilean Siar",6]
["Falkirk",319]
["Fife",2034]
["Glasgow City",913]
["Highland",127]
["Inverclyde",437]
["Midlothian",615]
["Moray",207]
["North Ayrshire",581]
["North Lanarkshire",2592]
["Orkney",9]
["Perth & Kinross",503]
["Renfrewshire",313]
["Scottish Borders",81]
["Shetland",143]
["South Ayrshire",368]
["South Lanarkshire",545]
["Stirling",215]
["West Dunbartonshire",91]
["West Lothian",326]
["Household is assigned to local authority of most recent approach"]
["Table 13a: All closed approaches by LA and quarter"]
[null,"Quarter of Outcome"]
[null,"2017 Q2","2017 Q3"]
[null,"N","N"]
["Aberdeen City",3638,1059]
["Aberdeenshire",385,442]
["Angus",264,287]
["Argyll & Bute",417,428]
["Clackmannanshire",113,122]
["Dumfries & Galloway",252,254]
["Dundee City",417,283]
["East Ayrshire",26,12]
["East Dunbartonshire",108,46]
["East Lothian",19,18]
["East Renfrewshire",6,39]
["Edinburgh",1274,1135]
["Eilean Siar",6,0]
["Falkirk",312,375]
["Fife",523,395]
["Glasgow City",2506,2179]
["Highland",96,50]
["Inverclyde",229,185]
["Midlothian",33,31]
["Moray",276,261]
["North Ayrshire",422,422]
["North Lanarkshire",340,421]
["Orkney",1,10]
["Perth & Kinross",813,644]
["Renfrewshire",544,551]
["Scottish Borders",202,236]
["Shetland",63,56]
["South Ayrshire",191,196]
["South Lanarkshire",229,295]
["Stirling",81,56]
["West Dunbartonshire",52,47]
["West Lothian",154,247]
["Scotland",13992,10782]
["Household is assigned to local authority of most recent approach"]
["Number of Approaches per household"]
["Approaches made the last 6 months 1 April 2017 to 30 Sept 2017"]
[null,"counter",null,null,"Total (ALL)"]
[null,"Households making one approach only","Households making two approaches only","Households making three or more approaches"]
[null,"N","N","N","N"]
["LACODE"]
["Aberdeen City",2054,74,2,2130,null,"Aberdeen City",2130]
["Aberdeenshire",753,31,".",784,null,"Aberdeenshire",784]
["Angus",359,10,".",369,null,"Angus",369]
["Argyll & Bute",787,50,5,842,null,"Argyll & Bute",842]
["Clackmannanshire",253,6,3,262,null,"Clackmannanshire",262]
["Dumfries & Galloway",452,18,1,471,null,"Dumfries & Galloway",471]
["Dundee City",547,20,1,568,null,"Dundee City",568]
["East Ayrshire",31,".",".",31,null,"East Ayrshire",31]
["East Dunbartonshire",137,11,1,149,null,"East Dunbartonshire",149]
["East Lothian",48,".",".",48,null,"East Lothian",48]
["East Renfrewshire",60,3,1,64,null,"East Renfrewshire",64]
["Edinburgh",2545,89,5,2639,null,"Edinburgh",2639]
["Eilean Siar",2,".",".",2,null,"Eilean Siar",2]
["Falkirk",788,78,5,871,null,"Falkirk",871]
["Fife",1169,58,9,1236,null,"Fife",1236]
["Glasgow City",4028,331,41,4400,null,"Glasgow City",4400]
["Highland",107,1,".",108,null,"Highland",108]
["Inverclyde",358,22,10,390,null,"Inverclyde",390]
["Midlothian",128,9,".",137,null,"Midlothian",137]
["Moray",525,16,".",541,null,"Moray",541]
["North Ayrshire",813,22,1,836,null,"North Ayrshire",836]
["North Lanarkshire",892,8,1,901,null,"North Lanarkshire",901]
["Orkney",13,".",".",13,null,"Orkney",13]
["Perth & Kinross",977,124,7,1108,null,"Perth & Kinross",1108]
["Renfrewshire",870,67,6,943,null,"Renfrewshire",943]
["Scottish Borders",354,11,1,366,null,"Scottish Borders",366]
["Shetland",104,1,1,106,null,"Shetland",106]
["South Ayrshire",488,15,1,504,null,"South Ayrshire",504]
["South Lanarkshire",396,10,1,407,null,"South Lanarkshire",407]
["Stirling",162,10,".",172,null,"Stirling",172]
["West Dunbartonshire",112,1,".",113,null,"West Dunbartonshire",113]
["West Lothian",351,14,".",365,null,"West Lothian",365]
["Total (ALL)",20663,1110,103,21876,null,"Total (ALL)",21876]
["Household is assigned to local authority of most recent approach"]
["Number of Approaches per household"]
["Approaches made the last 6 months 1 April 2017 to 30 Sept 2017"]
[null,"counter",null,null,"Total (ALL)"]
[null,"Households making one approach only","Households making two approaches only","Households making three or more approaches"]
[null,"RowPctN","RowPctN","RowPctN","RowPctN"]
["LACODE",96,3,0,100]
["Aberdeen City"]
["Aberdeenshire",96,4,".",100]
["Angus",97,3,".",100]
["Argyll & Bute",93,6,1,100]
["Clackmannanshire",97,2,1,100]
["Dumfries & Galloway",96,4,0,100]
["Dundee City",96,4,0,100]
["East Ayrshire",100,".",".",100]
["East Dunbartonshire",92,7,1,100]
["East Lothian",100,".",".",100]
["East Renfrewshire",94,5,2,100]
["Edinburgh",96,3,0,100]
["Eilean Siar",100,".",".",100]
["Falkirk",90,9,1,100]
["Fife",95,5,1,100]
["Glasgow City",92,8,1,100]
["Highland",99,1,".",100]
["Inverclyde",92,6,3,100]
["Midlothian",93,7,".",100]
["Moray",97,3,".",100]
["North Ayrshire",97,3,0,100]
["North Lanarkshire",99,1,0,100]
["Orkney",100,".",".",100]
["Perth & Kinross",88,11,1,100]
["Renfrewshire",92,7,1,100]
["Scottish Borders",97,3,0,100]
["Shetland",98,1,1,100]
["South Ayrshire",97,3,0,100]
["South Lanarkshire",97,2,0,100]
["Stirling",94,6,".",100]
["West Dunbartonshire",99,1,".",100]
["West Lothian",96,4,".",100]
["Total (ALL)",94,5,0,100]
["Household is assigned to local authority of most recent approach"]
["Table 10: How long have the Open Approaches been open for"]
[null,"days_open"]
[null,"N","P5","Q1","Median","Q3","P95"]
["Scotland",17058,10,67,198,404,1018]
["LACODE",1726,10,47,109,340,526]
["Aberdeen City"]
["Aberdeenshire",219,4,19,40,68,115]
["Angus",82,3,18,42,215,1095]
["Argyll & Bute",595,10,47,122,306,940]
["Clackmannanshire",120,8,53,116,192,405]
["Dumfries & Galloway",18,1,12,39,81,508]
["Dundee City",68,8,36,45,158,939]
["East Ayrshire",22,16,59,100,149,206]
["East Dunbartonshire",67,16,101,248,633,1249]
["East Lothian",49,16,61,172,206,305]
["East Renfrewshire",104,37,108,206,1022,1187]
["Edinburgh",3563,16,92,206,354,572]
["Eilean Siar",6,61,148,204,228,241]
["Falkirk",319,2,22,50,86,144]
["Fife",2034,18,136,340,562,839]
["Glasgow City",913,3,18,47,121,399]
["Highland",127,32,103,158,562,1024]
["Inverclyde",437,8,58,156,394,1223]
["Midlothian",615,46,249,495,719,1170]
["Moray",207,4,18,39,74,145]
["North Ayrshire",581,12,68,171,339,948]
["North Lanarkshire",2592,29,151,316,396,583]
["Orkney",9,8,46,93,227,428]
["Perth & Kinross",503,8,40,116,298,732]
["Renfrewshire",313,3,37,1107,1191,1230]
["Scottish Borders",81,2,17,54,192,467]
["Shetland",143,16,109,787,1053,1221]
["South Ayrshire",368,30,115,208,262,648]
["South Lanarkshire",545,25,93,710,1060,1202]
["Stirling",215,9,74,333,1054,1152]
["West Dunbartonshire",91,8,47,114,1046,1256]
["West Lothian",326,15,122,396,625,971]
["Household is assigned to local authority of most recent approach"]

{"sheet":"all data - from 04-14","index":30,"n_rows":511,"n_cols":49,"rows_kept":511,"cut":false,"hidden":true,"merged":[]}
["Table 1: Total Housing Options approaches by LA and quarter"]
[null,"Quarter of Approach"]
[null,"2014 Q2","2014 Q3","2014 Q4","2015 Q1","2015 Q2","2015 Q3","2015 Q4","2016 Q1","2016 Q2","2016 Q3","2016 Q4","2017 Q1","2017 Q2","2017 Q3"]
[null,"N","N","N","N","N","N","N","N","N","N","N","N","N","N"]
["Aberdeen City",1167,1595,1617,1908,1708,1582,1332,1516,1416,1398,1024,1345,1218,1003,null,{"$f":"SUM(B5:O5)","v":19829}]
["Aberdeenshire",573,478,422,614,558,532,437,574,479,461,391,458,406,422,null,{"$f":"SUM(B6:O6)","v":6805}]
["Angus",273,274,238,295,261,252,178,215,292,305,191,270,181,199,null,3424]
["Argyll & Bute",129,99,261,638,579,455,401,465,436,491,374,481,518,466,null,5793]
["Clackmannanshire",31,44,29,27,13,50,28,25,123,101,88,180,150,121,null,1010]
["Dumfries & Galloway",237,250,193,212,231,201,192,235,220,254,203,299,237,255,null,3219]
["Dundee City",767,787,439,478,547,552,490,617,531,501,466,656,352,238,null,7421]
["East Ayrshire",63,47,21,26,7,5,1,31,15,32,23,28,20,11,null,330]
["East Dunbartonshire",33,32,33,36,34,39,25,68,58,126,88,148,107,58,null,885]
["East Lothian",124,109,64,134,89,110,91,72,53,42,52,53,23,26,null,1042]
["East Renfrewshire",38,52,47,23,44,48,44,50,54,47,39,43,35,29,null,593]
["Edinburgh",1940,2106,1960,2168,2044,1928,1783,1844,1761,1602,1468,1595,1466,1274,null,24939]
["Eilean Siar",6,3,2,5,2,1,3,6,2,2,2,8,1,1,null,44]
["Falkirk",567,580,433,476,441,471,397,521,485,513,448,541,504,462,null,6839]
["Fife",804,832,649,904,843,716,558,696,700,691,571,737,716,588,null,10005]
["Glasgow City",3686,3212,2845,3326,2113,2719,2385,2891,2527,2521,2085,2592,2484,2363,null,37749]
["Highland",492,490,346,401,464,431,328,323,161,129,75,109,78,30,null,3857]
["Inverclyde",226,307,216,250,240,215,204,264,234,212,224,276,222,240,null,3330]
["Midlothian",162,129,90,125,124,89,87,113,101,109,91,88,66,75,null,1449]
["Moray",323,305,270,340,316,231,227,325,257,267,242,318,278,278,null,3977]
["North Ayrshire",469,482,409,565,469,480,378,468,435,379,321,434,425,435,null,6149]
["North Lanarkshire",920,873,742,995,898,923,725,873,835,828,912,631,468,443,null,11066]
["Orkney",9,17,13,14,11,18,9,22,12,12,3,4,7,6,null,157]
["Perth & Kinross",565,535,487,551,458,545,433,551,577,588,526,672,633,619,null,7740]
["Renfrewshire",461,520,459,550,533,520,469,584,529,542,484,562,523,491,null,7227]
["Scottish Borders",277,254,202,271,259,241,162,205,209,218,166,255,189,185,null,3093]
["Shetland",99,67,74,63,42,40,43,40,51,43,56,51,47,64,null,780]
["South Ayrshire",242,229,247,352,367,395,357,448,310,261,223,215,256,266,null,4168]
["South Lanarkshire",346,364,253,333,262,317,236,265,226,194,173,259,225,189,null,3642]
["Stirling",202,234,157,55,100,103,78,131,103,91,52,70,91,85,null,1552]
["West Dunbartonshire",422,465,386,384,286,45,20,34,41,58,42,56,60,54,null,2353]
["West Lothian",372,429,316,428,329,341,274,369,335,301,254,181,224,151,null,4304]
["Scotland",16025,16200,13920,16947,14672,14595,12375,14841,13568,13319,11357,13615,12210,11127,null,194771]
["Household is assigned to local authority of most recent approach"]
["Table 1M: Total Housing Options approaches by LA and quarter"]
[null,"approach_year"]
[null,2014,null,null,null,null,null,null,null,null,null,null,null,2015,null,null,null,null,null,null,null,null,null,null,null,2016,null,null,null,null,null,null,null,null,null,null,null,2017]
[null,"approach_month",null,null,null,null,null,null,null,null,null,null,null,"approach_month",null,null,null,null,null,null,null,null,null,null,null,"approach_month",null,null,null,null,null,null,null,null,null,null,null,"approach_month"]
[null,1,2,3,4,5,6,7,8,9,10,11,12,1,2,3,4,5,6,7,8,9,10,11,12,1,2,3,4,5,6,7,8,9,10,11,12,1,2,3,4,5,6,7,8,9,10,11,12]
["Scotland",0,0,0,5418,5127,5480,5473,5286,5441,5556,4696,3668,5589,5513,5845,4900,4798,4974,4734,4994,4867,4715,4438,3222,4774,4988,5079,4555,4408,4605,4054,4712,4553,4293,4155,2909,4482,4303,4830,3768,4337,4105,3771,4085,3271,0,0,0]
["Household is assigned to local authority of most recent approach"]
["Table 3a: Reasons for Housing Options approaches by quarter"]
[null,"Quarter of Approach"]
[null,"2014 Q2","2014 Q3","2014 Q4","2015 Q1","2015 Q2","2015 Q3","2015 Q4","2016 Q1","2016 Q2","2016 Q3","2016 Q4","2017 Q1","2017 Q2","2017 Q3"]
[null,"N","N","N","N","N","N","N","N","N","N","N","N","N","N"]
["Termination of tenancy / mortgage due to rent arrears / default on payments",893,872,720,905,653,576,561,627,555,458,428,574,464,405]
["Other action by landlord resulting in the termination of the tenancy",1163,1016,828,1207,1042,1041,819,1122,1127,972,757,1077,951,763]
["Applicant terminated secure accommodation",168,176,159,177,148,155,131,144,112,149,115,148,135,125]
["Loss of service / tied accommodation",82,82,65,71,61,64,63,59,66,49,34,49,40,57]
["Discharge from prison / hospital / care / other institution",1150,952,719,887,674,672,523,586,609,536,546,597,568,470]
["Emergency (fire, flood, storm, closing order from Environmental Health etc.)",28,50,38,46,41,34,36,45,51,27,42,31,34,22]
["Forced division and sale of matrimonial home",71,81,62,63,69,71,45,63,56,51,37,48,44,49]
["Other reason for loss of accommodation",447,395,367,466,314,347,333,408,432,372,369,407,454,373]
["Dispute within household: violent or abusive",935,1042,823,943,836,881,780,838,816,789,708,826,785,747]
["Dispute within household / relationship breakdown: non-violent",2267,2279,1850,2139,1850,1895,1581,1879,1669,1776,1535,1988,1582,1453]
["Fleeing non-domestic violence",273,260,214,206,211,215,175,173,200,131,137,158,161,153]
["Harassment",256,283,206,215,227,208,153,162,180,187,145,182,156,166]
["Overcrowding",316,311,270,346,254,237,225,256,185,194,155,201,178,146]
["Asked to leave",2363,2472,2062,2474,2132,2102,1782,2121,1979,1779,1464,1878,1634,1517]
["Other reason for leaving accommodation / household",632,673,511,558,473,543,508,505,479,554,411,501,413,434]
["General housing options advice",1689,1752,1595,2112,1975,2115,1810,2392,2090,2085,1779,2174,2201,2077]
["Benefit issues & Welfare Reform",343,216,279,332,248,157,148,183,117,215,188,132,139,127]
["Property condition",140,144,146,219,136,127,139,167,104,98,95,123,74,68]
["Accommodation unsuitable",412,558,508,587,614,619,433,531,497,639,521,633,582,416]
["Household experiencing anti-social behaviour / neighbour problems",103,108,85,76,104,104,67,94,114,106,92,100,88,93]
["Other",544,657,659,728,735,696,586,666,499,406,243,196,190,198]
["Household member needing care",71,148,166,209,165,182,140,182,176,170,119,62,40,37]
["Personal issues – affordability / financial difficulties",365,376,334,468,388,383,297,368,360,443,479,455,323,304]
["Risk of losing accommodation",1266,1242,1212,1463,1274,1126,1006,1227,1062,1103,924,1041,949,900]
["Landlord issue",48,55,42,50,48,45,34,43,33,30,34,34,25,27]
["Scotland",16025,16200,13920,16947,14672,14595,12375,14841,13568,13319,11357,13615,12210,11127]
["Household is assigned to local authority of most recent approach"]
["Table 3b: Reasons for Housing Options approaches by quarter"]
[null,"Quarter of Approach"]
[null,"2014 Q2","2014 Q3","2014 Q4","2015 Q1","2015 Q2","2015 Q3","2015 Q4","2016 Q1","2016 Q2","2016 Q3","2016 Q4","2017 Q1","2017 Q2","2017 Q3"]
[null,"N","N","N","N","N","N","N","N","N","N","N","N","N","N"]
["Homelessness Type",11044,10944,8894,10703,8985,9041,7715,8988,8516,8024,6883,8665,7599,6880]
["Prevention Type",4981,5256,5026,6244,5687,5554,4660,5853,5052,5295,4474,4950,4611,4247]
["Scotland",16025,16200,13920,16947,14672,14595,12375,14841,13568,13319,11357,13615,12210,11127]
["Household is assigned to local authority of most recent approach"]
["Table 4: Maximum Type of Housing Options activities by quarter"]
[null,null,"Quarter of Approach"]
[null,null,"2014 Q2","2014 Q3","2014 Q4","2015 Q1","2015 Q2","2015 Q3","2015 Q4","2016 Q1","2016 Q2","2016 Q3","2016 Q4","2017 Q1","2017 Q2","2017 Q3"]
[0,"N",".",".",1,".",".",".",".",".",".",".",".",".",".","."]
[1,"N",8108,8850,7882,9471,8291,7935,6665,8133,7428,7072,6127,7466,6965,6355]
[2,"N",7834,7287,5987,7435,6349,6620,5683,6666,6073,6177,5152,6070,5169,4707]
[3,"N",83,63,50,41,32,40,27,42,67,70,78,79,76,65]
["Total","N",16025,16200,13920,16947,14672,14595,12375,14841,13568,13319,11357,13615,12210,11127]
["Household is assigned to local authority of most recent approach"]
["Table 5: Housing Options activities by quarter"]
[null,null,"Quarter of Approach",null,null,null,null,null,null,null,null,null,null,null,null,null,"All"]
[null,null,"2014 Q2","2014 Q3","2014 Q4","2015 Q1","2015 Q2","2015 Q3","2015 Q4","2016 Q1","2016 Q2","2016 Q3","2016 Q4","2017 Q1","2017 Q2","2017 Q3"]
["Mediation/outreach work","N",556,667,520,644,397,393,339,440,414,475,342,416,315,252,6170]
["Financial assistance/advice","N",2438,2830,2380,2705,2439,2474,2059,2147,2007,2193,1822,1814,1593,1357,30258]
["Rent/repairs/referrals/negotiation with landlords","N",2313,2259,1969,2626,2246,2315,1765,1850,1679,1778,1464,1741,1588,1514,27107]
["Help to remain in accommodation","N",832,902,709,801,693,774,566,732,616,736,560,564,579,417,9481]
["Mortgage/home ownership advice","N",160,204,115,172,164,154,99,131,97,91,68,103,86,65,1709]
["Tenancy/social care support/adaptations to property","N",322,342,291,410,372,340,343,419,377,342,251,343,419,382,4953]
["Referral to health/Social Work/employment services","N",960,1026,931,913,795,958,717,836,805,882,734,825,837,760,11979]
["Client informed of rights under homelessness legislation","N",9131,8526,6697,8674,7814,7839,6827,8103,7466,7110,6138,7739,6806,6294,105164]
["General Housing advice/Tenancy rights advice","N",12143,12294,10544,13220,12462,12712,10400,12594,11084,10662,8906,10934,9839,8499,156293]
["Help to move property","N",1869,2000,1598,1969,1874,2008,1601,2000,2028,2154,1702,2173,1958,1443,26377]
["Other","N",1437,2236,1619,1610,1611,1642,1393,1696,1546,1686,1437,1455,1113,1414,21895]
["Total (ALL)","N",32161,33286,27373,33744,30867,31609,26109,30948,28119,28109,23424,28107,25133,22397,401386]
["Household is assigned to local authority of most recent approach"]
["Table 6: Housing Options activities by Local Authority, during 1 April 2014 to 30 Sept 2017"]
[null,null,"ACTIVITY",null,null,null,null,null,null,null,null,null,null,"All"]
[null,null,"Mediation/outreach work","Financial assistance/advice","Rent/repairs/referrals/negotiation with landlords","Help to remain in accommodation","Mortgage/home ownership advice","Tenancy/social care support/adaptations to property","Referral to health/Social Work/employment services","Client informed of rights under homelessness legislation","General Housing advice/Tenancy rights advice","Help to move property","Other"]
["Aberdeen City","N",236,545,244,554,140,43,132,4254,12703,2486,0,21337]
["Aberdeenshire","N",131,1629,1599,165,218,19,150,5213,7013,269,288,16694]
["Angus","N",81,2005,507,554,81,253,93,2433,4054,2419,84,12564]
["Argyll & Bute","N",49,255,534,898,2,281,37,885,3700,346,105,7092]
["Clackmannanshire","N",7,127,234,7,1,2,13,1261,1026,103,8,2789]
["Dumfries & Galloway","N",24,340,665,138,11,396,237,2732,3209,850,180,8782]
["Dundee City","N",732,319,420,262,2,16,61,8011,6323,902,350,17398]
["East Ayrshire","N",18,549,246,47,41,111,54,240,409,55,39,1809]
["East Dunbartonshire","N",1,525,408,47,48,7,40,672,761,649,8,3166]
["East Lothian","N",36,389,1149,247,38,5,7,1060,1602,1507,105,6145]
["East Renfrewshire","N",12,255,293,65,50,40,43,518,424,65,4,1769]
["Edinburgh","N",138,1895,311,93,20,28,297,5775,16008,176,327,25068]
["Eilean Siar","N",2,29,24,3,1,3,5,38,23,11,2,141]
["Falkirk","N",3272,9673,1058,3894,227,665,3596,6952,8934,5293,14540,58104]
["Fife","N",177,956,3296,210,336,148,396,8780,11004,2332,350,27985]
["Glasgow City","N",66,751,1142,947,16,36,5023,14378,16471,487,0,39317]
["Highland","N",66,960,208,122,68,79,67,3197,3612,240,91,8710]
["Inverclyde","N",33,200,695,91,5,10,74,1786,2235,188,523,5840]
["Midlothian","N",275,231,176,44,32,111,94,1288,2391,643,1169,6454]
["Moray","N",166,784,361,69,14,118,133,3248,4038,566,875,10372]
["North Ayrshire","N",3,412,6121,182,81,10,73,7219,7857,593,132,22683]
["North Lanarkshire","N",57,2242,917,318,54,1432,452,3260,14525,585,515,24357]
["Orkney","N",2,24,40,5,6,0,1,109,196,21,5,409]
["Perth & Kinross","N",87,399,1646,43,20,28,109,2742,4054,126,1008,10262]
["Renfrewshire","N",409,2111,1018,135,27,376,437,5350,6279,1634,420,18196]
["Scottish Borders","N",19,431,908,57,35,420,45,2075,2544,1242,113,7889]
["Shetland","N",14,21,4,4,0,0,6,708,761,8,31,1557]
["South Ayrshire","N",13,70,310,27,7,294,117,1818,2713,251,474,6094]
["South Lanarkshire","N",7,647,930,105,55,1,20,2659,4081,1552,80,10137]
["Stirling","N",1,31,111,24,3,0,8,319,1336,65,2,1900]
["West Dunbartonshire","N",14,167,71,34,9,2,14,1931,849,213,25,3329]
["West Lothian","N",22,1286,1461,90,61,19,145,4253,5158,500,42,13037]
["Scotland","N",6170,30258,27107,9481,1709,4953,11979,105164,156293,26377,21895,401386]
["Household is assigned to local authority of most recent approach"]
["Table 7: Outcomes by Quarter"]
[null,null,"Quarter of Outcome",null,null,null,null,null,null,null,null,null,null,null,null,null,"All"]
[null,null,"2014 Q2","2014 Q3","2014 Q4","2015 Q1","2015 Q2","2015 Q3","2015 Q4","2016 Q1","2016 Q2","2016 Q3","2016 Q4","2017 Q1","2017 Q2","2017 Q3"]
["LA/RSL Tenancy","N",223,405,504,482,578,544,565,586,528,812,509,513,417,424,7090]
["PRS Tenancy","N",267,459,415,458,489,462,468,408,459,502,395,422,402,401,6007]
["Other (known)","N",458,717,656,470,515,576,439,680,545,735,715,892,682,613,8693]
["Moved-in with friends/ relatives","N",185,339,292,258,246,251,302,275,267,307,232,268,258,251,3731]
["Lost Contact/ Not known","N",1069,2522,2389,1777,1689,1794,2205,1900,2074,1906,1843,2961,4033,1671,29833]
["Remained in current accommodation","N",1649,2608,2963,2717,2606,2834,2705,2736,2613,2704,2376,3308,2832,2624,37275]
["Made homelessness application to local authority","N",4984,6730,6106,7235,6624,6761,6203,6535,6478,5412,5521,6334,5367,4798,85088]
["Total (ALL)","N",8835,13780,13325,13397,12747,13222,12887,13120,12964,12378,11591,14698,13991,10782,177717]
["Household is assigned to local authority of most recent approach"]
["Table 8: Outcomes by LA: 1 April 2014 to 30 Sept 2017"]
[null,null,"LA/RSL Tenancy","PRS Tenancy","Other (known)","Moved-in with friends/ relatives","Lost Contact/ Not known","Remained in current accommodation","Made homelessness application to local authority","All"]
["Aberdeen City","N",1358,442,1173,187,6424,3624,4895,18103]
["Aberdeenshire","N",126,304,238,224,1649,1540,2505,6586]
["Angus","N",99,90,136,81,267,1060,1609,3342]
["Argyll & Bute","N",312,294,296,143,516,2412,1226,5199]
["Clackmannanshire","N",23,35,6,6,57,75,688,890]
["Dumfries & Galloway","N",102,102,39,40,580,325,2014,3202]
["Dundee City","N",164,191,428,83,1877,1273,3336,7352]
["East Ayrshire","N",91,38,6,23,15,70,65,308]
["East Dunbartonshire","N",12,36,26,6,98,220,420,818]
["East Lothian","N",9,100,21,54,131,279,399,993]
["East Renfrewshire","N",14,20,17,12,63,171,192,489]
["Edinburgh","N",733,291,362,391,3378,5382,10839,21376]
["Eilean Siar","N",6,2,1,1,3,10,15,38]
["Falkirk","N",283,23,279,130,935,630,4240,6520]
["Fife","N",557,649,285,76,1405,1302,3697,7971]
["Glasgow City","N",334,71,2456,750,5617,5599,22009,36836]
["Highland","N",239,287,166,180,428,729,1701,3730]
["Inverclyde","N",152,147,170,139,582,816,887,2893]
["Midlothian","N",18,41,107,52,138,262,216,834]
["Moray","N",160,265,105,302,379,701,1857,3769]
["North Ayrshire","N",644,913,344,132,188,620,2730,5571]
["North Lanarkshire","N",288,30,514,97,232,2487,4826,8474]
["Orkney","N",13,19,6,2,51,14,43,148]
["Perth & Kinross","N",172,375,615,83,1534,1781,2677,7237]
["Renfrewshire","N",247,85,330,204,666,2450,2932,6914]
["Scottish Borders","N",268,268,133,41,680,405,1217,3012]
["Shetland","N",51,10,17,16,111,79,353,637]
["South Ayrshire","N",134,34,32,17,306,783,2493,3799]
["South Lanarkshire","N",202,458,216,83,624,558,958,3099]
["Stirling","N",32,61,40,68,254,440,442,1337]
["West Dunbartonshire","N",126,36,46,11,202,326,1515,2262]
["West Lothian","N",121,290,83,97,443,852,2092,3978]
["Total (ALL)","N",7090,6007,8693,3731,29833,37275,85088,177717]
["Household is assigned to local authority of most recent approach"]
["Table 9: Outcomes: Number of days from approach to case closure - for the most recent quarter - BOXPLOT"]
[null,"outcome_time"]
[null,"P5","Q1","Median","Q3","P95","N"]
["LA/RSL Tenancy",0,26,68,142,390,7090]
["PRS Tenancy",1,23,50,106,329,6007]
["Other (known)",0,3,31,99,368,8693]
["Moved-in with friends/ relatives",0,9,34,77,252,3731]
["Lost Contact/ Not known",0,15,48,130,656,29833]
["Remained in current accommodation",0,6,31,85,314,37275]
["Made homelessness application to local authority",0,0,1,21,378,85088]
["All Outcomes",0,0,16,70,423,177717]
["Household is assigned to local authority of most recent approach"]
["Table 10: Outcomes: Number of days from approach to making a homeless application by LA - for the most recent quarter - BOXPLOT"]
[null,"outcome_time"]
[null,"P5","Q1","Median","Q3","P95","N"]
["Aberdeen City",0,0,10,103,580,4895]
["Aberdeenshire",0,0,3,20,329,2505]
["Angus",0,6,12,34,420,1609]
["Argyll & Bute",0,1,5,47,601,1226]
["Clackmannanshire",0,0,0,0,5,688]
["Dumfries & Galloway",0,0,0,0,47,2014]
["Dundee City",1,3,9,49,514,3336]
["East Ayrshire",8,26,65,351,978,65]
["East Dunbartonshire",0,0,0,13,336,420]
["East Lothian",6,24,50,163,679,399]
["East Renfrewshire",1,12,35,101,528,192]
["Edinburgh",0,0,0,22,425,10839]
["Eilean Siar",0,8,30,99,433,15]
["Falkirk",0,0,0,0,228,4240]
["Fife",0,0,3,16,349,3697]
["Glasgow City",0,0,1,14,195,22009]
["Highland",0,6,20,84,596,1701]
["Inverclyde",0,0,6,42,420,887]
["Midlothian",0,0,11,92,729,216]
["Moray",0,1,10,50,531,1857]
["North Ayrshire",0,0,0,5,406,2730]
["North Lanarkshire",0,0,0,0,312,4826]
["Orkney",1,8,66,157,707,43]
["Perth & Kinross",0,1,6,28,328,2677]
["Renfrewshire",0,0,0,3,214,2932]
["Scottish Borders",3,10,18,41,367,1217]
["Shetland",0,0,0,7,246,353]
["South Ayrshire",0,0,0,0,102,2493]
["South Lanarkshire",5,16,31,125,708,958]
["Stirling",1,11,38,188,865,442]
["West Dunbartonshire",0,0,0,0,91,1515]
["West Lothian",1,9,21,84,509,2092]
["Scotland",0,0,1,21,378,85088]
["Household is assigned to local authority of most recent approach"]
["Table 11: Outcomes: Number of days from approach to case closed as type 'Lost Contact' and 'Not Known' by LA, for the most recent quarter - BOXPLOT"]
[null,"outcome_time"]
[null,"P5","Q1","Median","Q3","P95","N"]
["Aberdeen City",1,68,380,624,849,6424]
["Aberdeenshire",0,18,41,71,175,1649]
["Angus",0,12,36,95,339,267]
["Argyll & Bute",1,21,37,57,186,516]
["Clackmannanshire",0,1,33,87,294,57]
["Dumfries & Galloway",0,0,1,93,275,580]
["Dundee City",0,1,10,26,77,1877]
["East Ayrshire",35,108,168,218,636,15]
["East Dunbartonshire",0,0,0,0,76,98]
["East Lothian",25,37,54,70,126,131]
["East Renfrewshire",33,94,132,212,317,63]
["Edinburgh",0,3,28,41,161,3378]
["Eilean Siar",25,25,96,169,169,3]
["Falkirk",64,74,75,85,167,935]
["Fife",0,17,42,66,134,1405]
["Glasgow City",0,10,30,91,374,5617]
["Highland",0,15,49,97,217,428]
["Inverclyde",24,39,69,128,311,582]
["Midlothian",3,46,93,124,353,138]
["Moray",14,40,64,93,154,379]
["North Ayrshire",0,0,153,406,485,188]
["North Lanarkshire",0,0,89,419,762,232]
["Orkney",29,70,103,147,302,51]
["Perth & Kinross",1,19,50,122,416,1534]
["Renfrewshire",1,20,23,38,116,666]
["Scottish Borders",4,19,42,89,184,680]
["Shetland",0,26,153,335,636,111]
["South Ayrshire",0,5,97,197,377,306]
["South Lanarkshire",27,59,98,152,270,624]
["Stirling",6,25,44,90,379,254]
["West Dunbartonshire",1,1,45,78,173,202]
["West Lothian",0,3,42,93,239,443]
["Scotland",0,15,48,130,656,29833]
["Household is assigned to local authority of most recent approach"]
["Table 12: Outcomes: Where approach did not result in an application for homelessness, not known or lost contact, in number of days, for the most recent quarter - BOXPLOT"]
[null,"outcome_time"]
[null,"P5","Q1","Median","Q3","P95","N"]
["Aberdeen City",1,35,96,217,536,6784]
["Aberdeenshire",0,7,32,61,138,2432]
["Angus",0,8,28,64,232,1466]
["Argyll & Bute",0,6,29,69,199,3457]
["Clackmannanshire",0,1,23,77,206,145]
["Dumfries & Galloway",0,1,35,94,207,608]
["Dundee City",0,9,29,57,146,2139]
["East Ayrshire",22,63,105,173,322,228]
["East Dunbartonshire",0,0,0,15,97,303]
["East Lothian",14,29,45,74,142,463]
["East Renfrewshire",2,72,107,147,246,241]
["Edinburgh",0,0,7,29,84,7159]
["Eilean Siar",0,27,61,191,463,24]
["Falkirk",0,0,12,59,132,1345]
["Fife",0,11,29,57,131,2869]
["Glasgow City",0,0,11,49,239,9210]
["Highland",2,26,61,118,259,1601]
["Inverclyde",0,34,66,133,343,1500]
["Midlothian",0,26,77,103,241,480]
["Moray",14,39,63,97,166,1533]
["North Ayrshire",23,84,185,370,510,2656]
["North Lanarkshire",0,30,83,174,521,3416]
["Orkney",6,55,109,155,308,54]
["Perth & Kinross",0,11,40,116,402,3026]
["Renfrewshire",0,20,26,49,133,3490]
["Scottish Borders",4,16,44,91,203,1115]
["Shetland",0,39,91,158,394,173]
["South Ayrshire",0,28,92,183,249,1000]
["South Lanarkshire",0,46,86,134,296,1634]
["Stirling",2,22,42,87,238,641]
["West Dunbartonshire",3,30,73,133,240,545]
["West Lothian",0,3,31,76,278,1443]
["Scotland",0,8,36,94,333,63180]
["Household is assigned to local authority of most recent approach"]
["Table 13: All open cases on 30 Sept 2017 by LA"]
[null,"open_30092017"]
[null,"N"]
["Scotland"]
["LACODE",17058]
["Aberdeen City",1726]
["Aberdeenshire",219]
["Angus",82]
["Argyll & Bute",595]
["Clackmannanshire",120]
["Dumfries & Galloway",18]
["Dundee City",68]
["East Ayrshire",22]
["East Dunbartonshire",67]
["East Lothian",49]
["East Renfrewshire",104]
["Edinburgh",3563]
["Eilean Siar",6]
["Falkirk",319]
["Fife",2034]
["Glasgow City",913]
["Highland",127]
["Inverclyde",437]
["Midlothian",615]
["Moray",207]
["North Ayrshire",581]
["North Lanarkshire",2592]
["Orkney",9]
["Perth & Kinross",503]
["Renfrewshire",313]
["Scottish Borders",81]
["Shetland",143]
["South Ayrshire",368]
["South Lanarkshire",545]
["Stirling",215]
["West Dunbartonshire",91]
["West Lothian",326]
["Household is assigned to local authority of most recent approach"]
["Table 13a: All closed approaches by LA and quarter"]
[null,"Quarter of Outcome"]
[null,"2014 Q2","2014 Q3","2014 Q4","2015 Q1","2015 Q2","2015 Q3","2015 Q4","2016 Q1","2016 Q2","2016 Q3","2016 Q4","2017 Q1","2017 Q2","2017 Q3"]
[null,"N","N","N","N","N","N","N","N","N","N","N","N","N","N"]
["Aberdeen City",458,1147,1384,855,670,898,824,848,1127,1351,1169,2675,3638,1059]
["Aberdeenshire",447,455,383,569,552,497,475,439,483,590,411,458,385,442]
["Angus",186,258,235,253,214,246,199,209,235,257,230,269,264,287]
["Argyll & Bute",85,131,161,479,536,496,342,459,362,408,438,457,417,428]
["Clackmannanshire",19,29,33,23,24,40,19,47,100,121,85,115,113,122]
["Dumfries & Galloway",74,224,202,167,208,211,174,253,280,233,369,301,252,254]
["Dundee City",592,745,594,434,375,574,598,543,581,526,490,600,417,283]
["East Ayrshire",11,30,37,32,23,18,14,15,13,21,18,38,26,12]
["East Dunbartonshire",25,22,30,38,26,48,27,59,54,124,89,125,108,46]
["East Lothian",42,95,125,91,113,102,111,68,74,40,53,42,19,18]
["East Renfrewshire",9,3,79,25,42,19,38,32,66,59,23,56,6,39]
["Edinburgh",892,1429,1669,1631,1811,1878,1812,1776,1674,1484,1458,1453,1274,1135]
["Eilean Siar",0,3,5,2,4,1,0,7,3,2,5,4,6,0]
["Falkirk",137,343,260,1027,484,452,474,578,517,522,459,580,312,375]
["Fife",572,729,800,654,879,657,517,358,612,419,433,423,523,395]
["Glasgow City",2439,3308,2835,2724,2051,2255,2883,3274,2504,2231,2493,3154,2506,2179]
["Highland",250,469,402,119,563,539,364,242,297,108,87,144,96,50]
["Inverclyde",132,151,208,265,225,210,246,255,217,230,191,225,229,185]
["Midlothian",38,70,120,138,96,65,46,0,43,41,72,41,33,31]
["Moray",152,286,290,289,312,304,268,237,302,254,293,245,276,261]
["North Ayrshire",257,201,304,353,407,311,335,530,435,700,438,459,422,422]
["North Lanarkshire",535,811,835,799,690,1046,862,688,598,412,182,255,340,421]
["Orkney",1,2,18,10,8,16,18,20,15,2,13,14,1,10]
["Perth & Kinross",263,485,437,391,505,408,365,535,542,459,439,951,813,644]
["Renfrewshire",363,555,418,530,499,536,494,509,529,482,503,575,544,551]
["Scottish Borders",158,239,228,212,253,262,190,178,201,232,191,230,202,236]
["Shetland",48,43,39,57,31,34,33,32,53,55,47,46,63,56]
["South Ayrshire",107,161,228,217,262,320,501,364,321,358,350,223,191,196]
["South Lanarkshire",2,528,113,293,249,215,272,144,226,275,198,177,229,295]
["Stirling",76,225,175,17,39,110,97,111,150,86,81,33,81,56]
["West Dunbartonshire",321,428,391,363,329,109,25,21,38,42,43,53,52,47]
["West Lothian",280,405,300,340,267,345,264,289,312,254,240,281,154,247]
["Scotland",8971,14010,13338,13397,12747,13222,12887,13120,12964,12378,11591,14702,13992,10782]
["Household is assigned to local authority of most recent approach"]
["Number of Approaches per household"]
["Approaches made 1 April 2014 to 30 Sept 2017"]
[null,"counter",null,null,"Total (ALL)"]
[null,"Households making one approach only","Households making two approaches only","Households making three or more approaches"]
[null,"N","N","N","N"]
["LACODE"]
["Aberdeen City",13888,2133,528,16549,null,"Aberdeen City",16549]
["Aberdeenshire",4091,737,288,5116,null,"Aberdeenshire",5116]
["Angus",2615,293,76,2984,null,"Angus",2984]
["Argyll & Bute",2625,619,336,3580,null,"Argyll & Bute",3580]
["Clackmannanshire",765,76,14,855,null,"Clackmannanshire",855]
["Dumfries & Galloway",2036,393,106,2535,null,"Dumfries & Galloway",2535]
["Dundee City",4726,841,313,5880,null,"Dundee City",5880]
["East Ayrshire",301,13,6,320,null,"East Ayrshire",320]
["East Dunbartonshire",660,66,20,746,null,"East Dunbartonshire",746]
["East Lothian",863,66,13,942,null,"East Lothian",942]
["East Renfrewshire",484,35,14,533,null,"East Renfrewshire",533]
["Edinburgh",15154,3156,1005,19315,null,"Edinburgh",19315]
["Eilean Siar",36,2,".",38,null,"Eilean Siar",38]
["Falkirk",3906,848,335,5089,null,"Falkirk",5089]
["Fife",6442,1116,364,7922,null,"Fife",7922]
["Glasgow City",18367,4651,2644,25662,null,"Glasgow City",25662]
["Highland",3185,287,62,3534,null,"Highland",3534]
["Inverclyde",1596,291,162,2049,null,"Inverclyde",2049]
["Midlothian",946,163,71,1180,null,"Midlothian",1180]
["Moray",2799,416,91,3306,null,"Moray",3306]
["North Ayrshire",4087,687,199,4973,null,"North Ayrshire",4973]
["North Lanarkshire",7835,1251,253,9339,null,"North Lanarkshire",9339]
["Orkney",116,10,4,130,null,"Orkney",130]
["Perth & Kinross",4488,944,363,5795,null,"Perth & Kinross",5795]
["Renfrewshire",3982,867,440,5289,null,"Renfrewshire",5289]
["Scottish Borders",2148,275,105,2528,null,"Scottish Borders",2528]
["Shetland",566,69,25,660,null,"Shetland",660]
["South Ayrshire",2611,489,158,3258,null,"South Ayrshire",3258]
["South Lanarkshire",2870,273,82,3225,null,"South Lanarkshire",3225]
["Stirling",1137,142,55,1334,null,"Stirling",1334]
["West Dunbartonshire",1837,190,66,2093,null,"West Dunbartonshire",2093]
["West Lothian",3506,344,52,3902,null,"West Lothian",3902]
["Total (ALL)",120668,21743,8250,150661,null,"Total (ALL)",150661]
["Household is assigned to local authority of most recent approach"]
["Number of Approaches per household"]
["Approaches made 1 April 2014 to 30 Sept 2017"]
[null,"counter",null,null,"Total (ALL)"]
[null,"Households making one approach only","Households making two approaches only","Households making three or more approaches"]
[null,"RowPctN","RowPctN","RowPctN","RowPctN"]
["LACODE",84,13,3,100]
["Aberdeen City"]
["Aberdeenshire",80,14,6,100]
["Angus",88,10,3,100]
["Argyll & Bute",73,17,9,100]
["Clackmannanshire",89,9,2,100]
["Dumfries & Galloway",80,16,4,100]
["Dundee City",80,14,5,100]
["East Ayrshire",94,4,2,100]
["East Dunbartonshire",88,9,3,100]
["East Lothian",92,7,1,100]
["East Renfrewshire",91,7,3,100]
["Edinburgh",78,16,5,100]
["Eilean Siar",95,5,".",100]
["Falkirk",77,17,7,100]
["Fife",81,14,5,100]
["Glasgow City",72,18,10,100]
["Highland",90,8,2,100]
["Inverclyde",78,14,8,100]
["Midlothian",80,14,6,100]
["Moray",85,13,3,100]
["North Ayrshire",82,14,4,100]
["North Lanarkshire",84,13,3,100]
["Orkney",89,8,3,100]
["Perth & Kinross",77,16,6,100]
["Renfrewshire",75,16,8,100]
["Scottish Borders",85,11,4,100]
["Shetland",86,10,4,100]
["South Ayrshire",80,15,5,100]
["South Lanarkshire",89,8,3,100]
["Stirling",85,11,4,100]
["West Dunbartonshire",88,9,3,100]
["West Lothian",90,9,1,100]
["Total (ALL)",80,14,5,100]
["Household is assigned to local authority of most recent approach"]
["Table 10: How long have the Open Approaches been open for"]
[null,"days_open"]
[null,"N","P5","Q1","Median","Q3","P95"]
["Scotland",17058,10,67,198,404,1018]
["LACODE",1726,10,47,109,340,526]
["Aberdeen City"]
["Aberdeenshire",219,4,19,40,68,115]
["Angus",82,3,18,42,215,1095]
["Argyll & Bute",595,10,47,122,306,940]
["Clackmannanshire",120,8,53,116,192,405]
["Dumfries & Galloway",18,1,12,39,81,508]
["Dundee City",68,8,36,45,158,939]
["East Ayrshire",22,16,59,100,149,206]
["East Dunbartonshire",67,16,101,248,633,1249]
["East Lothian",49,16,61,172,206,305]
["East Renfrewshire",104,37,108,206,1022,1187]
["Edinburgh",3563,16,92,206,354,572]
["Eilean Siar",6,61,148,204,228,241]
["Falkirk",319,2,22,50,86,144]
["Fife",2034,18,136,340,562,839]
["Glasgow City",913,3,18,47,121,399]
["Highland",127,32,103,158,562,1024]
["Inverclyde",437,8,58,156,394,1223]
["Midlothian",615,46,249,495,719,1170]
["Moray",207,4,18,39,74,145]
["North Ayrshire",581,12,68,171,339,948]
["North Lanarkshire",2592,29,151,316,396,583]
["Orkney",9,8,46,93,227,428]
["Perth & Kinross",503,8,40,116,298,732]
["Renfrewshire",313,3,37,1107,1191,1230]
["Scottish Borders",81,2,17,54,192,467]
["Shetland",143,16,109,787,1053,1221]
["South Ayrshire",368,30,115,208,262,648]
["South Lanarkshire",545,25,93,710,1060,1202]
["Stirling",215,9,74,333,1054,1152]
["West Dunbartonshire",91,8,47,114,1046,1256]
["West Lothian",326,15,122,396,625,971]
["Household is assigned to local authority of most recent approach"]