{"text_format":"3","workbook":"xlsx","n_sheets":8,"sheets":["Q1","Q2","Q3","Q4","Q5","Q6","Q7","Q8"],"read":"whole","date_system":"1900"}

{"sheet":"Q1","index":0,"n_rows":29,"n_cols":10,"rows_kept":29}
[]
["Q1.  Presented themselves as homeless, or at risk of homelessness"]
[]
["• Presented before 56 days of becoming as homeless, or at risk of homelessness "]
[null,"16/17 year olds",{"$nulls":3},"18-24 year olds"]
["Gender","Q1","Q2","Q3","Q4","Q1","Q2","Q3","Q4","Total"]
["Female",0,1,0,1,0,0,0,0,{"$f":"SUM(B7:I7)","v":2}]
["Male",0,2,0,0,0,0,0,0,{"$f":"SUM(B8:I8)","v":2}]
["Not Know / Other",0,0,0,0,0,0,0,0,0]
["Prefer not to say",0,0,0,0,0,0,0,0,0]
[null,{"$f":"SUM(B7:B10)","v":0},{"$f":"SUM(C7:C10)","v":3},0,1,0,0,0,0,4]
[]
["• Believed they were homeless but did not meet requirements (Advice only cases)"]
[null,"16/17 year olds",{"$nulls":3},"18-24 year olds"]
["Gender","Q1","Q2","Q3","Q4","Q1","Q2","Q3","Q4","Total"]
["Female",1,3,4,3,16,22,20,14,{"$f":"SUM(B16:I16)","v":83}]
["Male",3,3,5,5,13,10,12,11,{"$f":"SUM(B17:I17)","v":62}]
["Not Know / Other",0,0,0,1,0,0,0,0,1]
["Prefer not to say",0,1,0,0,0,0,0,0,1]
[null,{"$f":"SUM(B16:B19)","v":4},{"$f":"SUM(C16:C19)","v":7},9,9,{"$f":"SUM(F16:F19)","v":29},{"$f":"SUM(G16:G19)","v":32},{"$f":"SUM(H16:H19)","v":32},{"$f":"SUM(I16:I19)","v":25},147]
[]
["• Presented but had no recourse to public funds"]
[null,"16/17 year olds",{"$nulls":3},"18-24 year olds"]
["Gender","Q1","Q2","Q3","Q4","Q1","Q2","Q3","Q4","Total"]
["Female",0,0,0,0,0,0,0,0,{"$f":"SUM(B25:I25)","v":0}]
["Male",0,0,0,0,1,0,0,0,{"$f":"SUM(B26:I26)","v":1}]
["Not Know / Other",0,0,0,0,0,0,0,0,0]
["Prefer not to say",0,0,0,0,0,0,0,0,0]
["Grand Total",0,0,0,0,1,0,0,0,1]

{"sheet":"Q2","index":1,"n_rows":11,"n_cols":10,"rows_kept":11}
["Q2. Were assessed for a Prevention and/or Relief duty under part 7 of the Housing Act "]
["While this assessment is a new duty brought in by the HRA, it is a duty under part 7 of the Housing Act as amended by the HRA."]
[]
[]
[null,"16/17 year olds",{"$nulls":3},"18-24 year olds"]
["Gender","Q1","Q2","Q3","Q4","Q1","Q2","Q3","Q4","Total"]
["Female",6,4,7,5,39,48,39,40,{"$f":"SUM(B7:I7)","v":188}]
["Male",2,8,8,3,34,25,28,26,{"$f":"SUM(B8:I8)","v":134}]
["Not Know / Other",0,0,0,0,0,0,1,0,{"$f":"SUM(B9:I9)","v":1}]
["Prefer not to say",0,0,0,0,0,0,0,0,{"$f":"SUM(B10:I10)","v":0}]
["Grand Total",{"$f":"SUM(B7:B10)","v":8},{"$f":"SUM(C7:C10)","v":12},15,8,73,73,68,66,323]

{"sheet":"Q3","index":2,"n_rows":22,"n_cols":10,"rows_kept":22}
[]
[]
["Q3  Received an initial decision of being owed:"]
[]
["• Prevention duty under HRA "]
[null,"16/17 year olds",{"$nulls":3},"18-24 year olds"]
["Gender","Q1","Q2","Q3","Q4","Q1","Q2","Q3","Q4","Total"]
["Female",6,2,7,4,22,25,21,15,{"$f":"SUM(B8:I8)","v":102}]
["Male",2,3,8,3,10,10,15,9,{"$f":"SUM(B9:I9)","v":60}]
["Not Know / Other",0,0,0,0,0,0,0,0,{"$f":"SUM(B10:I10)","v":0}]
["Prefer not to say",0,0,0,0,0,0,0,0,{"$f":"SUM(B11:I11)","v":0}]
["Grand Total",8,5,15,7,{"$f":"SUM(F8:F11)","v":32},{"$f":"SUM(G8:G11)","v":35},{"$f":"SUM(H8:H11)","v":36},{"$f":"SUM(I8:I11)","v":24},{"$f":"SUM(B12:I12)","v":162}]
[]
[]
["• Relief duty under HRA "]
[null,"16/17 year olds",{"$nulls":3},"18-24 year olds"]
["Gender","Q1","Q2","Q3","Q4","Q1","Q2","Q3","Q4","Total"]
["Female",0,1,0,0,17,23,18,25,{"$f":"SUM(B18:I18)","v":84}]
["Male",0,3,0,0,24,15,13,17,{"$f":"SUM(B19:I19)","v":72}]
["Not Know / Other",0,0,0,0,0,0,1,0,{"$f":"SUM(B20:I20)","v":1}]
["Prefer not to say",0,0,0,0,0,0,0,0,{"$f":"SUM(B21:I21)","v":0}]
["Grand Total",{"$f":"SUM(B18:B21)","v":0},{"$f":"SUM(C18:C21)","v":4},{"$f":"SUM(D18:D21)","v":0},{"$f":"SUM(E18:E21)","v":0},{"$f":"SUM(F18:F21)","v":41},{"$f":"SUM(G18:G21)","v":38},{"$f":"SUM(H18:H21)","v":32},{"$f":"SUM(I18:I21)","v":42},{"$f":"SUM(B22:I22)","v":157}]

{"sheet":"Q4","index":3,"n_rows":29,"n_cols":10,"rows_kept":29}
[]
["Q4. Prevention duty ended"]
[]
["• with accommodation secured"]
[null,"16/17 year olds",{"$nulls":3},"18-24 year olds"]
["Gender","Q1","Q2","Q3","Q4","Q1","Q2","Q3","Q4","Total"]
["Female",2,0,2,3,2,5,6,11,{"$f":"SUM(B7:I7)","v":31}]
["Male",1,0,5,4,3,4,4,8,{"$f":"SUM(B8:I8)","v":29}]
["Not Know / Other",0,0,0,0,0,0,0,0,0]
["Prefer not to say",0,0,0,0,0,0,0,0,0]
["Grand Total",{"$f":"SUM(B7:B10)","v":3},{"$f":"SUM(C7:C10)","v":0},7,7,5,9,10,19,60]
[]
["• leading to relief duty"]
[null,"16/17 year olds",{"$nulls":3},"18-24 year olds"]
["Gender","Q1","Q2","Q3","Q4","Q1","Q2","Q3","Q4","Total"]
["Female",0,0,1,1,6,13,7,2,{"$f":"SUM(B16:I16)","v":30}]
["Male",1,0,3,0,2,4,3,4,{"$f":"SUM(B17:I17)","v":17}]
["Not Know / Other",0,0,0,0,0,0,0,0,0]
["Prefer not to say",0,0,0,0,0,0,0,0,0]
["Grand Total",{"$f":"SUM(B16:B19)","v":1},{"$f":"SUM(C16:C19)","v":0},4,1,8,17,10,6,47]
[]
["• any other reason"]
[null,"16/17 year olds",{"$nulls":3},"18-24 year olds"]
["Gender","Q1","Q2","Q3","Q4","Q1","Q2","Q3","Q4","Total"]
["Female",3,2,3,0,4,6,4,13,{"$f":"SUM(B25:I25)","v":35}]
["Male",0,0,0,0,5,4,1,4,{"$f":"SUM(B26:I26)","v":14}]
["Not Know / Other",0,0,0,0,0,0,0,0,0]
["Prefer not to say",0,0,0,0,0,0,0,0,0]
["Grand Total",{"$f":"SUM(B25:B28)","v":3},{"$f":"SUM(C25:C28)","v":2},3,0,9,10,5,17,49]

{"sheet":"Q5","index":4,"n_rows":20,"n_cols":10,"rows_kept":20}
[]
["Q4. Relief ended"]
[]
["• with accommodation secured"]
[null,"16/17 year olds",{"$nulls":3},"18-24 year olds"]
["Gender","Q1","Q2","Q3","Q4","Q1","Q2","Q3","Q4","Total"]
["Female",0,0,0,0,2,3,3,5,{"$f":"SUM(B7:I7)","v":13}]
["Male",0,0,0,0,1,5,6,3,{"$f":"SUM(B8:I8)","v":15}]
["Not Know / Other",0,0,0,0,0,0,0,0,0]
["Prefer not to say",0,0,0,0,0,0,0,0,0]
["Grand Total",{"$f":"SUM(B7:B10)","v":0},{"$f":"SUM(C7:C10)","v":0},0,0,3,8,9,8,28]
[]
["• for any other reason (not including those who progress to an assessment under the Housing Act 1996)"]
[null,"16/17 year olds",{"$nulls":3},"18-24 year olds"]
["Gender","Q1","Q2","Q3","Q4","Q1","Q2","Q3","Q4","Total"]
["Female",0,0,0,1,2,3,5,5,{"$f":"SUM(B16:I16)","v":16}]
["Male",1,0,0,0,1,5,1,2,{"$f":"SUM(B17:I17)","v":10}]
["Not Know / Other",0,0,0,0,0,0,0,0,0]
["Prefer not to say",0,0,0,0,0,0,0,0,0]
["Grand Total",{"$f":"SUM(B16:B19)","v":1},{"$f":"SUM(C16:C19)","v":0},0,1,3,8,6,7,26]

{"sheet":"Q6","index":5,"n_rows":11,"n_cols":10,"rows_kept":11,"merged":[[2,0,2,9]]}
[]
[]
["Q6 .  Were assessed for a statutory main housing duty under part 7 of the Housing Act \nBy this we mean- following unsuccessful prevention and/or relief outcomes, how many young people underwent a final assessment under part 7 of the Housing Act in order to assess their eligibility for a statutory main housing duty "]
[]
[null,"16/17 year olds",{"$nulls":3},"18-24 year olds"]
["Gender","Q1","Q2","Q3","Q4","Q1","Q2","Q3","Q4","Total"]
["Female",3,1,null,2,12,13,11,15,{"$f":"SUM(B7:I7)","v":57}]
["Male",1,1,3,1,7,9,10,9,{"$f":"SUM(B8:I8)","v":41}]
["Not Know / Other",0,0,0,0,0,0,0,0,0]
["Prefer not to say",0,0,0,0,0,0,0,0,0]
["Grand Total",{"$f":"SUM(B7:B10)","v":4},{"$f":"SUM(C7:C10)","v":2},3,3,19,22,21,24,98]

{"sheet":"Q7","index":6,"n_rows":11,"n_cols":10,"rows_kept":11,"merged":[[2,0,2,9]]}
[]
[]
["Q7. \tWere accepted as statutorily homeless and owed a statutory main housing duty under part 6 of the Housing Act 1996\nAfter undergoing a final assessment, how many young people were accepted as statutorily homeless and offered a statutory main housing duty."]
[]
[null,"16/17 year olds",{"$nulls":3},"18-24 year olds"]
["Gender","Q1","Q2","Q3","Q4","Q1","Q2","Q3","Q4","Total"]
["Female",1,null,null,2,8,8,7,9,{"$f":"SUM(B7:I7)","v":35}]
["Male",1,1,2,1,1,4,4,7,{"$f":"SUM(B8:I8)","v":21}]
["Not Know / Other",0,0,0,0,0,0,0,0,0]
["Prefer not to say",0,0,0,0,0,0,0,0,0]
["Grand Total",{"$f":"SUM(B7:B10)","v":2},{"$f":"SUM(C7:C10)","v":1},2,3,9,12,11,16,56]

{"sheet":"Q8","index":7,"n_rows":8,"n_cols":1,"rows_kept":8,"merged":[[2,0,2,7],[6,0,6,9]]}
["8. Everyone In"]
[]
["\na.  Were Housed through Everyone In \nThe total number of young people who were housed through Everyone In by your Local Authority by the relevant age and gender splits for the time periods specified."]
["Answer = 2020/21:  0 (excludes those 'placed' in temporary accommodation)"]
[]
["b. Were housed through everyone In and did not start an HRA journey in FY202021"]
["The number of people who were housed through Everyone In but had not presented to the Local Authority as homeless or at risk of homelessness and therefore were not involved in the HRA process within this given timeframe."]
["Answer = 2020/21:  0 "]