{"text_format":"3","workbook":"xlsx","n_sheets":3,"sheets":["Accessible properties","Band & Band Reason by bed need","wait times"],"read":"whole","date_system":"1900"}

{"sheet":"Accessible properties","index":0,"n_rows":50,"n_cols":8,"rows_kept":50,"merged":[[2,1,2,6],[9,0,9,7],[11,0,12,0],[11,1,11,6]]}
["Accessible property"]
[]
[null,"Bed need"]
["Mobility Level",1,2,3,4,5,6,"Grand Total"]
[1,8,13,5,1,null,null,27]
[2,13,10,10,2,null,null,35]
[3,149,75,40,15,1,1,281]
["Total",{"$f":"SUM(B5:B7)","v":170},{"$f":"SUM(C5:C7)","v":98},55,18,1,1,343]
[]
["Mobility Level \nWhere a property is advertised for applicants with restricted mobility i.e. Mobility Level 1, 2 or 3, priority will be given to applicants who require this type of property. \n• Mobility Level 1 – Typically suitable for a person who uses a wheelchair full time, indoors and outdoors. The property will provide full wheelchair access throughout. \n• Mobility Level 2 – Typically suitable to a person with restricted walking ability and for those that may need to use a wheelchair for some of the time. The property will have internal and external level or ramped access, but some parts of the property may not be fully wheelchair accessible. \n• Mobility Level 3 – Typically suitable for a person able to manage two or three steps, but unable to manage steep gradients. The property may have adaptations to assist people with limited mobility."]
[]
["Band/Band reason and Mobility level","Bed need"]
[null,1,2,3,4,5,6,"Grand Total"]
["Band A"]
["Mobility 1"]
["(HBC) Applicant in Severe Housing Need as a result of cumulative circumstances",null,null,1,{"$nulls":3},1]
["(HBC) Applicants at serious imminent personal risk (agreed by Council's Housing Options Team Leader)",1,{"$nulls":5},1]
["(HBC) Band A Medical",6,8,4,1,null,null,19]
["(HBC) Statutory Homeless Cases ? Applicants with particular difficulties in accessing or retaining PRS",1,2,{"$nulls":4},3]
["Mobility 2"]
["(HBC) Applicants with high on-going support needs ? Applicants with particular difficulties in accessing or retaining PRS",{"$nulls":3},1,null,null,1]
["(HBC) Band A Medical",5,7,5,1,null,null,18]
["(HBC) Statutory Homeless Cases ? Applicants with particular difficulties in accessing or retaining PRS",4,1,4,{"$nulls":3},9]
["Mobility 3"]
["(HBC) Applicant in Severe Housing Need as a result of cumulative circumstances",1,1,5,2,1,null,10]
["(HBC) Applicant In Severe Housing Need as a result of housing conditions (immediate threat of serious injury or if life threatening)",null,1,{"$nulls":4},1]
["(HBC) Applicants with high on-going support needs ? Applicants with particular difficulties in accessing or retaining PRS",3,{"$nulls":5},3]
["(HBC) Band A Medical",25,15,8,5,null,1,54]
["(HBC) Statutory Homeless Cases ? Applicants with particular difficulties in accessing or retaining PRS",15,9,3,3,null,null,30]
["(HBC) Transfer applicant with statutory succession who would or is currently under-occupying by two bedrooms or more",4,{"$nulls":5},4]
["Band B"]
["Mobility 1"]
["(HBC) Band B Medical",null,1,{"$nulls":4},1]
["Mobility 2"]
["(HBC) Band B Medical",4,1,1,{"$nulls":3},6]
["(HBC) Management Transfer Agreed By Housing Management",null,1,{"$nulls":4},1]
["Mobility 3"]
["(HBC) Band B Medical",80,41,20,4,null,null,145]
["(HBC) Transfer applicant under-occupying by one bedroom",3,1,1,{"$nulls":3},5]
["Band C"]
["Mobility 3"]
["(HBC) Accepted Homeless in TA other than B&B",1,{"$nulls":5},1]
["(HBC) Applicant owed a prevention (s195(2)) or relief duty (s189B)",3,3,1,{"$nulls":3},7]
["(HBC) Household Lacking One Separate Bedroom",2,2,2,1,null,null,7]
["Band D"]
["Mobility 1"]
["(HBC) Applicant for Sheltered Housing or HOPs where no other housing need",null,2,{"$nulls":4},2]
["Mobility 3"]
["(HBC) Applicant for Sheltered Housing or HOPs where no other housing need",12,2,{"$nulls":4},14]
["Grand Total",{"$f":"SUM(B16:J27B49)","v":{"$error":"#NAME?"}},{"$f":"SUM(C16:C49)","v":98},55,18,1,1,343]

{"sheet":"Band & Band Reason by bed need","index":1,"n_rows":26,"n_cols":9,"rows_kept":26,"merged":[[0,0,1,0],[0,1,0,7],[0,8,1,8]]}
["Band and Band Reason","Bed need",{"$nulls":6},"Grand Total"]
[null,1,2,3,4,5,6,8]
["Band A",258,263,136,64,10,3,1,735]
["(HBC) Applicant in Severe Housing Need as a result of cumulative circumstances",7,22,13,11,2,null,null,55]
["(HBC) Applicant In Severe Housing Need as a result of housing conditions (immediate threat of serious injury or if life threatening)",null,2,{"$nulls":5},2]
["(HBC) Applicants at serious imminent personal risk (agreed by Council's Housing Options Team Leader)",1,null,1,{"$nulls":4},2]
["(HBC) Applicants with high on-going support needs ? Applicants with particular difficulties in accessing or retaining PRS",54,17,3,1,null,1,null,76]
["(HBC) Band A Medical",47,42,41,15,1,1,null,147]
["(HBC) Permanent/Temporary Decant (0-12 months)",2,3,1,{"$nulls":4},6]
["(HBC) Statutory Homeless Cases ? Applicants with particular difficulties in accessing or retaining PRS",138,176,77,37,7,1,1,437]
["(HBC) Transfer applicant with statutory succession who would or is currently under-occupying by two bedrooms or more",9,1,{"$nulls":5},10]
["Band B",180,99,109,42,13,2,null,445]
["(HBC) Applicant Approved for Permanent Accommodation to enable fostering or adoption",null,1,1,1,{"$nulls":3},3]
["(HBC) Armed Forces awaiting discharge",null,1,{"$nulls":5},1]
["(HBC) Band B Medical",157,81,85,19,2,2,null,346]
["(HBC) Family Lacking Two Or More Separate Bedrooms",null,6,20,22,10,null,null,58]
["(HBC) Management Transfer Agreed By Housing Management",null,1,null,null,1,null,null,2]
["(HBC) Transfer applicant under-occupying by one bedroom",23,9,3,{"$nulls":4},35]
["Band C",153,130,140,26,3,null,null,452]
["(HBC) Accepted Homeless in TA other than B&B",14,5,3,2,{"$nulls":3},24]
["(HBC) Applicant owed a prevention (s195(2)) or relief duty (s189B)",53,29,17,8,1,null,null,108]
["(HBC) Household Lacking One Separate Bedroom",83,93,119,15,2,null,null,312]
["(HBC) Unreasonable to remain due to unsatisfactory housing",3,3,1,1,{"$nulls":3},8]
["Band D",99,15,{"$nulls":5},114]
["(HBC) Applicant for Sheltered Housing or HOPs where no other housing need",99,15,{"$nulls":5},114]
["Grand Total",690,507,385,132,26,5,1,1746]

{"sheet":"wait times","index":2,"n_rows":14,"n_cols":19,"rows_kept":14,"merged":[[3,0,3,3],[3,5,3,8],[3,10,3,13],[3,15,3,18]]}
["Waiting times - lettings between 01/11/2023 and 30/10/2024"]
["(Note: accessible properties will be included in the figures below)"]
[]
["Band A",{"$nulls":4},"Band B",{"$nulls":4},"Band C",{"$nulls":4},"Band D"]
["Type / Size","No. of Lets","Longest wait","Average wait",null,"Type / Size","No. of Lets","Longest wait","Average wait",null,"Type / Size","No. of Lets","Longest wait","Average wait",null,"Type / Size","No. of Lets","Longest wait","Average wait"]
["Sheltered accomm.",31,"8 years","19 months",null,"Sheltered accomm.",5,"7 years","33 months",null,"Sheltered accomm.",12,"18 months","7 months",null,"Sheltered accomm.",0]
["Studio general needs",3,"5 years","4 years",null,"Studio general needs",0,{"$nulls":3},"Studio general needs",0,{"$nulls":3},"Studio general needs",0]
["1-bed general needs",69,"8 years","32 months",null,"1-bed general needs",2,"36 months","21 months",null,"1-bed general needs",2,"10 months","5 months",null,"1-bed general needs",0]
["2-bed flat or maisonette",48,"9 years","32 months",null,"2-bed flat or maisonette",2,"21 months","15 months",null,"2-bed flat or maisonette",1,"4 months","4 months",null,"2-bed flat or maisonette",0]
["2-bed house",9,"4 years","34 months",null,"2-bed house",0,{"$nulls":3},"2-bed house",0,{"$nulls":3},"2-bed house",0]
["3-bed flat or maisonette",5,"3 years","28 months",null,"3-bed flat or maisonette",0,{"$nulls":3},"3-bed flat or maisonette",0,{"$nulls":3},"3-bed flat or maisonette",0]
["3-bed house",14,"13 years","3 years",null,"3-bed house",0,{"$nulls":3},"3-bed house",0,{"$nulls":3},"3-bed house",0]
["4-bed",10,"7 years","4 years",null,"4-bed",0,{"$nulls":3},"4-bed",0,{"$nulls":3},"4-bed",0]
["5-bed",0,{"$nulls":3},"5-bed",0,{"$nulls":3},"5-bed",0,{"$nulls":3},"5-bed",0]