{"text_format":"1","workbook":"xlsx","n_sheets":20,"sheets":["Menu","M1","Food","Ass","CSS","Budget1","Services","Out of hrs","Prop","EHM","Salaries","Rents","EHMplus","CT","CSSplus","Budget2","F1","F2","F3","Spare with auto-condense"],"not_rendered":{"charts":0,"images":14,"macros":1,"external_links":0,"defined_names":13,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Menu","index":0,"n_rows":55,"n_cols":4,"rows_kept":55,"cut":false,"hidden":false,"merged":[[2,1,2,3],[14,3,14,4],[20,3,20,4],[7,3,7,4],[8,3,8,4],[9,3,9,4],[10,3,10,4],[11,3,11,4],[13,3,13,4],[15,3,15,4],[12,3,12,4],[16,3,16,4],[19,3,19,4]]}
[null,"Budgeting model - September 2024"]
[null,{"$f":"IF(B3=\"\",\"Enter project name &/or address ↓\",\"\")","v":"Enter project name &/or address ↓"}]
[]
[null,"General settings"]
[null,"Budget year","2025/26"]
[]
[null,"Budget inputs"]
[null,"Units and core rents",null,"Includes occupancy & bad debt assumptions for HB-eligible rents & charges "]
[null,"Property costs",null,"Entries required to calculate the \"cost rent\""]
[null,"Staff team",null,"Includes analysis of salary costs"]
[null,"Out-of-hours",null,"Costs not included on the salaries page.  Charged either to care & support or enhanced mngmnt"]
[null,"Enhanced management",null,"Non-staff costs can be added after salaries have been allocated to this heading."]
[null,"Care support & supervision",null,"Non-staff costs & funding sources to be added (this is the default salary allocation)"]
[null,"Services",null,"Includes occupancy & bad debt assumptions for HB-ineligible charges"]
[null,"Council tax",null,"Details of council tax, where included in rents and charges"]
[null,"Food/ catering",null,"Entries required if food is provided. "]
[null,"CPI assumptions",null,"Used to calculate standard deductions for meals from 2025 & formula rents"]
[]
[null,"Outputs"]
[null,"Budget summary",null,"Overall budget based on the budget input entries"]
[null,"Rents and charges",null,"Schedule aof rents and charges based on the budget inputs"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,{"$f":"'F1'!N35","v":"2024/25"}]
[null,null,{"$f":"'F1'!N36","v":"2025/26"}]
[null,null,{"$f":"'F1'!N37","v":"2026/27"}]
[null,null,{"$f":"'F1'!N38","v":"2027/28"}]

{"sheet":"M1","index":1,"n_rows":499,"n_cols":21,"rows_kept":499,"cut":false,"hidden":true,"merged":[[23,2,23,6],[33,2,33,6],[20,2,20,3],[18,2,18,3],[18,5,18,6],[18,8,18,9],[20,5,20,6],[20,8,20,9],[5,8,5,9],[11,8,11,9],[12,8,12,9],[13,8,13,9],[11,2,11,3],[12,2,12,3],[13,2,13,3],[5,2,5,3],[5,5,5,6],[11,5,11,6],[12,5,12,6],[13,5,13,6]]}
[]
[]
[]
[null,{"$f":"IF(Menu!B3<>\"\",Menu!B3,\"\")","v":""}]
[]
[null,"Unit details","FIRST UNIT TYPE",null,null,"SECOND UNIT TYPE",null,null,"THIRD UNIT TYPE"]
[]
[null,"Number of units"]
[]
[null,"Budget occupancy level",96,"%",null,96,"%",null,96,"%"]
[]
[null,"Unit size","Bedsit/room",null,null,"1-bed",null,null,"1-bed"]
[null,"Unit type","Supported",null,null,"Supported",null,null,"Supported"]
[null,"Core rent setting method","Cost rent*",null,null,"Cost rent*",null,null,"Cost rent*",null,null,null,null,null,{"$f":"IF(OR(C14=$E$128,C14=\"\"),\"C\",IF(C14=$E$130,\"S\",IF(C14=$E$129,IF(C19=\"DRC*\",\"D\",\"M\"))))","v":"C"},null,null,{"$f":"IF(OR(F14=$E$128,F14=\"\"),\"C\",IF(F14=$E$130,\"S\",IF(F14=$E$129,IF(F19=\"DRC*\",\"D\",\"M\"))))","v":"C"},null,null,{"$f":"IF(OR(I14=$E$128,I14=\"\"),\"C\",IF(I14=$E$130,\"S\",IF(I14=$E$129,IF(I19=\"DRC*\",\"D\",\"M\"))))","v":"C"}]
[null,null,{"$f":"IF(C14=$E$128,\"* The core rent covers costs\",IF(C14=\"\",\"Cost rent by default\",\"\"))","v":"* The core rent covers costs"},null,null,{"$f":"IF(F14=$E$128,\"* The core rent covers costs\",IF(F14=\"\",\"Cost rent by default\",\"\"))","v":"* The core rent covers costs"},null,null,{"$f":"IF(I14=$E$128,\"* The core rent covers costs\",IF(I14=\"\",\"Cost rent by default\",\"\"))","v":"* The core rent covers costs"}]
[null,"Cost rent (from property page)",{"$f":"Prop!M43","v":0},null,null,{"$f":"Prop!O43","v":0},null,null,{"$f":"Prop!Q43","v":0}]
[null,{"$f":"IF(OR(C14=$E$130,F14=$E$130,I14=$E$130),\"Specify the core rent for this unit type\",\"\")","v":""}]
[null,{"$f":"IF(OR(C$14=$E$129,F$14=$E$129,I$14=$E$129),\"Formula rent\",\"\")","v":""},null,{"$f":"IF(C14=$E129,'F1'!$K14,0)","v":0},null,null,{"$f":"IF(F14=$E129,'F2'!$K14,0)","v":0},null,null,{"$f":"IF(I14=$E129,'F3'!$K14,0)","v":0}]
[null,{"$f":"IF(OR(C$14=$E$129,F$14=$E$129,I$14=$E$129),\"Formula rent method (manual or DRC)\",\"\")","v":""},"Manual entry",null,null,"Manual entry",null,null,"Manual entry"]
[null,null,{"$f":"IF(AND(C14=$E$129,C19=\"DRC*\"),\"* Depreciated replacement cost\",IF(AND(C14=$E$129,C19=\"\"),\"Manual (by default)\",\"\"))","v":""},null,null,{"$f":"IF(AND(F14=$E$129,F19=\"DRC*\"),\"* Depreciated replacement cost\",IF(AND(F14=$E$129,F19=\"\"),\"Manual (by default)\",\"\"))","v":""},null,null,{"$f":"IF(AND(I14=$E$129,I19=\"DRC*\"),\"* Depreciated replacement cost\",IF(AND(I14=$E$129,I19=\"\"),\"Manual (by default)\",\"\"))","v":""}]
[null,{"$f":"IF(OR(AND(C14=$E$129,OR(C19=\"Manual entry\",C19=\"\")),AND(F14=$E$129,OR(F19=\"Manual entry\",F19=\"\")),AND(I14=$E$129,OR(I19=\"Manual entry\",I19=\"\"))),\"Enter the 1999 unit valuation (EUV)\",\"\")","v":""}]
[null,{"$f":"IF(OR(C$14=$E$129,F$14=$E$129,I$14=$E$129),\"Apply flexibility to formula rent ?\",\"\")","v":""},"Yes",null,null,"Yes",null,null,"Yes"]
[]
[null,{"$f":"IF(OR(C$14=$E$129,F$14=$E$129,I$14=$E$129),\"Select the area (for 1999 manual earnings data)\",\"\")","v":""},"Greater London",null,null,null,null,{"$f":"IF(R24=1,\"This applies to all formula rent calculations\",\"\")","v":""},null,null,null,null,null,null,{"$f":"IF(C14=$E$129,1,0)","v":0},{"$f":"IF(F14=$E$129,1,0)","v":0},{"$f":"IF(I14=$E$129,1,0)","v":0},{"$f":"IF(SUM(O24:Q24)>0,1,0)","v":0}]
[]
[null,{"$f":"IF(OR(AND(C$19=\"DRC*\",C$14=$E$129),AND(F$19=\"DRC*\",F$14=$E$129),AND(I$19=\"DRC*\",I$14=$E$129)),\"Floor area of the unit (m²) **\",\"\")","v":""}]
[null,{"$f":"IF(OR(AND(C$19=\"DRC*\",C$14=$E$129),AND(F$19=\"DRC*\",F$14=$E$129),AND(I$19=\"DRC*\",I$14=$E$129)),\"Plot area including curtilage (m²)\",\"\")","v":""}]
[null,{"$f":"IF(OR(AND(C$19=\"DRC*\",C$14=$E$129),AND(F$19=\"DRC*\",F$14=$E$129),AND(I$19=\"DRC*\",I$14=$E$129)),\"Total number of units on the site\",\"\")","v":""},{"$f":"SUM(C8,F8,I8)","v":0},null,null,{"$f":"SUM(C8,F8,I8)","v":0},null,null,{"$f":"SUM(C8,F8,I8)","v":0}]
[null,{"$f":"IF(OR(AND(C$19=\"DRC*\",C$14=$E$129),AND(F$19=\"DRC*\",F$14=$E$129),AND(I$19=\"DRC*\",I$14=$E$129)),\"Was a new lift installed ?\",\"\")","v":""},"No",null,null,"No",null,null,"No"]
[null,{"$f":"IF(OR(AND(C$19=\"DRC*\",C$14=$E$129),AND(F$19=\"DRC*\",F$14=$E$129),AND(I$19=\"DRC*\",I$14=$E$129)),\"Were adaptations made for wheelchair access ?\",\"\")","v":""},"No",null,null,"No",null,null,"No"]
[null,{"$f":"IF(OR(AND(C$19=\"DRC*\",C$14=$E$129),AND(F$19=\"DRC*\",F$14=$E$129),AND(I$19=\"DRC*\",I$14=$E$129)),\"Are kitchens more than 10 years old ?\",\"\")","v":""},"No",null,null,"Yes",null,null,"No"]
[null,{"$f":"IF(OR(AND(C$19=\"DRC*\",C$14=$E$129),AND(F$19=\"DRC*\",F$14=$E$129),AND(I$19=\"DRC*\",I$14=$E$129)),\"Are bathrooms more than 15 years old ?\",\"\")","v":""},"No",null,null,"Yes",null,null,"No"]
[]
[null,{"$f":"IF(OR(AND(C$19=\"DRC*\",C$14=$E$129),AND(F$19=\"DRC*\",F$14=$E$129),AND(I$19=\"DRC*\",I$14=$E$129)),\"Select the area (for DRC land values)\",\"\")","v":""},"Lambeth ",null,null,null,null,{"$f":"IF(R34=1,\"This applies to all DRC valuations\",\"\")","v":""},null,null,null,null,null,null,{"$f":"IF(AND(C14=$E$129,C19=\"DRC*\"),1,0)","v":0},{"$f":"IF(AND(F14=$E$129,F19=\"DRC*\"),1,0)","v":0},{"$f":"IF(AND(I14=$E$129,I19=\"DRC*\"),1,0)","v":0},{"$f":"IF(SUM(O34:Q34)>0,1,0)","v":0}]
[]
[]
[]
[null,"Effective rent",{"$f":"IF(C14=$E$128,C16,IF(C14=$E$129,D18,IF(C14=$E$130,C17,0)))","v":0},null,null,{"$f":"IF(F14=$E$128,F16,IF(F14=$E$129,G18,IF(F14=$E$130,F17,0)))","v":0},null,null,{"$f":"IF(I14=$E$128,I16,IF(I14=$E$129,J18,IF(I14=$E$130,I17,0)))","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Manual earnings"]
[null,"Avon",321.2]
[null,"Bedfordshire",343.7]
[null,"Berkshire",345.4]
[null,"Buckinghamshire",328.3]
[null,"Cambridgeshire",330.1]
[null,"Cheshire",322]
[null,"Cleveland",338.4]
[null,"Cornwall",255.5]
[null,"Cumbria",323.7]
[null,"Derbyshire",321.10000000000002]
[null,"Devon",278]
[null,"Dorset",293.89999999999998]
[null,"Durham",289.7]
[null,"East Sussex",281.5]
[null,"Essex",325.89999999999998]
[null,"Gloucestershire",308]
[null,"Greater London",354.1]
[null,"Greater Manchester",307.3]
[null,"Hampshire",328.7]
[null,"Hereford & Worcs",289.60000000000002]
[null,"Hertfordshire",343.7]
[null,"Humberside",318.39999999999998]
[null,"Isle of Wight",288.5]
[null,"Kent",316.39999999999998]
[null,"Lancashire",302.7]
[null,"Leicestershire",303.10000000000002]
[null,"Lincolnshire",286.7]
[null,"Merseyside",324.89999999999998]
[null,"Norfolk",302.5]
[null,"North Yorkshire",299.60000000000002]
[null,"Northamptonshire",328.5]
[null,"Northumberland",276.10000000000002]
[null,"Nottinghamshire",298]
[null,"Oxfordshire",323.8]
[null,"Shropshire",295.39999999999998]
[null,"Somerset",299.7]
[null,"South Yorkshire",299.10000000000002]
[null,"Staffordshire",296.2]
[null,"Suffolk",304.3]
[null,"Surrey",333.2]
[null,"Tyne & Wear",307.89999999999998]
[null,"Warwickshire",326.10000000000002]
[null,"West Midlands",320.60000000000002]
[null,"West Sussex",332.5]
[null,"West Yorkshire",302.7]
[null,"Wiltshire",313.89999999999998]
[]
[null,"Bedsit/room",0.8,null,"Cost rent*"]
[null,"1-bed",0.9,null,"Formula rent"]
[null,"2-bed",1,null,"Specific core rent"]
[null,"3-bed",1.1000000000000001]
[null,"4-bed",1.2]
[null,"5-bed",1.3]
[null,"6-bed",1.4]
[]
[null,"General needs",5]
[null,"Supported",10]
[null,"Refuge or almshouse",10]
[]
[null,"Adur ","C",800,750]
[null,"Allerdale ","D",250,197]
[null,"Alnwick ","D",430,310]
[null,"Amber Valley  ","E",520,450]
[null,"Arun ","C",1125,1110]
[null,"Ashfield ","E",350,300]
[null,"Ashford ","C",1020,925]
[null,"Aylesbury Vale ","C",1600,1600]
[null,"Babergh ","D",350,335]
[null,"Barking and Dagenham ","B",1385,1600]
[null,"Barnet ","A",3800,3500]
[null,"Barnsley  ","D",550,375]
[null,"Barrow-in-Furness  ","C",425,375]
[null,"Basildon  ","C",1025,988]
[null,"Basingstoke and Deane ","B",1720,1720]
[null,"Bassetlaw ","D",400,300]
[null,"Bath and North East Somerset ","C",1500,1400]
[null,"Berwick-upon-Tweed ","D",370,245]
[null,"Bexley ","B",2000,1600]
[null,"Birmingham  ","C",890,890]
[null,"Blaby ","D",750,700]
[null,"Blackburn  ","D",470,325]
[null,"Blackpool  ","D",750,675]
[null,"Blyth Valley  ","D",245,200]
[null,"Bolsover ","E",325,250]
[null,"Bolton  ","D",550,500]
[null,"Boston  ","E",270,185]
[null,"Bournemouth  ","C",1600,1500]
[null,"Bracknell Forest  ","B",2000,2000]
[null,"Bradford  ","D",600,525]
[null,"Braintree  ","D",800,750]
[null,"Breckland ","E",325,275]
[null,"Brent ","A",2300,3000]
[null,"Brentwood  ","B",1555,1400]
[null,"Bridgnorth ","D",750,715]
[null,"Brighton and Hove ","C",1200,1000]
[null,"Bristol  ","C",1350,1350]
[null,"Broadland ","D",325,275]
[null,"Bromley ","B",2000,2470]
[null,"Bromsgrove ","C",1235,1350]
[null,"Broxbourne ","B",2200,2000]
[null,"Broxtowe ","D",680,625]
[null,"Burnley  ","D",470,310]
[null,"Bury ","D",550,500]
[null,"Calderdale ","D",550,450]
[null,"Cambridge  ","B",1480,2200]
[null,"Camden  ","A",9000,5500]
[null,"Cannock Chase ","D",900,950]
[null,"Canterbury  ","C",1850,1350]
[null,"Caradon ","D",200,220]
[null,"Carlisle  ","D",360,270]
[null,"Carrick ","D",400,350]
[null,"Castle Morpeth ","D",450,370]
[null,"Castle Point ","C",1200,1300]
[null,"Charnwood ","D",800,800]
[null,"Chelmsford  ","C",1280,1225]
[null,"Cheltenham  ","C",1500,1500]
[null,"Cherwell ","C",1000,900]
[null,"Chester  ","C",645,825]
[null,"Chesterfield  ","D",495,325]
[null,"Chester-le-Street  ","D",494,494]
[null,"Chichester  ","C",1850,1750]
[null,"Chiltern ","B",2500,2500]
[null,"Chorley  ","D",775,625]
[null,"Christchurch  ","C",1600,1500]
[null,"City of London ","A",20500,20500]
[null,"City of Westminster ","A",20500,20500]
[null,"Colchester  ","C",900,900]
[null,"Congleton ","D",540,500]
[null,"Copeland ","D",200,150]
[null,"Corby  ","D",350,350]
[null,"Cotswold ","C",1350,1350]
[null,"Coventry  ","D",950,850]
[null,"Craven ","D",525,500]
[null,"Crawley  ","B",1200,1200]
[null,"Crewe and Nantwich ","D",350,300]
[null,"Croydon ","B",2000,2000]
[null,"Dacorum ","B",1900,2250]
[null,"Darlington  ","D",500,500]
[null,"Dartford  ","C",1100,1100]
[null,"Daventry ","D",740,740]
[null,"Derby  ","E",600,550]
[null,"Derbyshire Dales ","D",550,490]
[null,"Derwentside ","D",315,275]
[null,"Doncaster  ","D",625,425]
[null,"Dover  ","C",700,450]
[null,"Dudley  ","D",950,1000]
[null,"Durham  ","C",650,600]
[null,"Ealing ","A",3100,3200]
[null,"Easington ","D",350,215]
[null,"East Cambridgeshire  ","D",615,565]
[null,"East Devon  ","C",893,819]
[null,"East Dorset  ","C",1400,1300]
[null,"East Hampshire ","B",1500,1500]
[null,"East Hertfordshire  ","B",1400,1350]
[null,"East Lindsey ","E",410,250]
[null,"East Northamptonshire  ","D",570,570]
[null,"East Riding ","D",610,550]
[null,"East Staffordshire  ","D",700,475]
[null,"Eastbourne  ","C",875,750]
[null,"Eastleigh  ","C",1440,1250]
[null,"Eden  ","D",320,270]
[null,"Ellesmere Port and Neston ","D",360,350]
[null,"Elmbridge ","B",1800,1500]
[null,"Enfield  ","B",3000,2800]
[null,"Epping Forest  ","B",1600,1480]
[null,"Epsom and Ewell  ","B",1450,1400]
[null,"Erewash ","D",540,460]
[null,"Exeter  ","D",1103,987]
[null,"Fareham  ","C",1400,1200]
[null,"Fenland ","E",225,210]
[null,"Forest Heath ","D",320,300]
[null,"Forest of Dean  ","D",740,740]
[null,"Fylde ","C",800,750]
[null,"Gateshead  ","D",500,450]
[null,"Gedling ","D",675,600]
[null,"Gloucester  ","D",1100,1100]
[null,"Gosport  ","C",1025,1000]
[null,"Gravesham ","C",825,825]
[null,"Great Yarmouth ","E",325,275]
[null,"Greenwich  ","B",2000,1700]
[null,"Guildford  ","B",2250,2250]
[null,"Hackney ","A",2500,2500]
[null,"Halton ","D",500,450]
[null,"Hambleton ","D",800,800]
[null,"Hammersmith and Fulham ","A",5000,2550]
[null,"Harborough ","D",750,800]
[null,"Haringey ","A",2500,2500]
[null,"Harlow  ","B",1025,988]
[null,"Harrogate  ","C",850,1000]
[null,"Harrow  ","A",2500,3400]
[null,"Hart ","B",1720,1720]
[null,"Hartlepool  ","D",500,475]
[null,"Hastings  ","D",375,275]
[null,"Havant ","C",1200,1100]
[null,"Havering ","B",1736,2000]
[null,"Herefordshire ","D",600,570]
[null,"Hertsmere ","B",1900,2250]
[null,"High Peak  ","D",440,440]
[null,"Hillingdon ","A",2300,3000]
[null,"Hinckley and Bosworth ","E",850,750]
[null,"Horsham ","C",1450,1425]
[null,"Hounslow ","A",3100,3200]
[null,"Huntingdonshire ","D",890,890]
[null,"Hyndburn ","D",470,235]
[null,"Ipswich  ","D",650,630]
[null,"Isle Of Wight  ","D",475,360]
[null,"Isles of Scilly ","A",1480,2200]
[null,"Islington ","A",5250,5250]
[null,"Kennet ","C",700,700]
[null,"Kensington and Chelsea ","A",27000,17500]
[null,"Kerrier ","D",300,265]
[null,"Kettering  ","D",618,618]
[null,"King's Lynn and West Norfolk ","D",325,275]
[null,"Kingston upon Hull ","D",475,375]
[null,"Kingston upon Thames ","A",2350,2350]
[null,"Kirklees ","D",615,475]
[null,"Knowsley ","D",400,350]
[null,"Lambeth ","A",2100,2100]
[null,"Lancaster  ","D",800,750]
[null,"Leeds  ","C",1000,975]
[null,"Leicester  ","D",750,700]
[null,"Lewes ","C",900,900]
[null,"Lewisham ","B",1600,1600]
[null,"Lichfield  ","D",1100,900]
[null,"Lincoln  ","D",500,375]
[null,"Liverpool  ","C",700,650]
[null,"Luton  ","C",1000,"  "]
[null,"Macclesfield ","C",700,550]
[null,"Maidstone  ","C",1250,1250]
[null,"Maldon ","C",700,900]
[null,"Malvern Hills District ","D",820,795]
[null,"Manchester  ","C",1000,800]
[null,"Mansfield  ","E",320,300]
[null,"Melton ","D",775,725]
[null,"Mendip ","D",600,550]
[null,"Merton ","A",2500,2500]
[null,"Mid Bedfordshire ","C",1050,1050]
[null,"Mid Devon ","D",683,612]
[null,"Mid Suffolk ","E",308,300]
[null,"Mid Sussex ","B",1000,1050]
[null,"Middlesbrough  ","D",425,450]
[null,"Milton Keynes  ","C",1500,1500]
[null,"Mole Valley  ","B",975,1425]
[null,"New Forest  ","C",1280,1400]
[null,"Newark and Sherwood ","E",425,340]
[null,"Newbury ","C",1600,1600]
[null,"Newcastle upon Tyne  ","D",800,800]
[null,"Newcastle-under-Lyme  ","D",450,325]
[null,"Newham ","B",1545,1425]
[null,"North Bedfordshire  ","C",1000,1000]
[null,"North Cornwall  ","D",320,290]
[null,"North Devon  ","C",683,612]
[null,"North Dorset  ","C",950,915]
[null,"North East Derbyshire ","D",450,270]
[null,"North East Lincolnshire ","D",410,350]
[null,"North Hertfordshire  ","B",1200,1100]
[null,"North Kesteven  ","D",340,250]
[null,"North Lincolnshire  ","E",410,350]
[null,"North Norfolk  ","E",350,300]
[null,"North Shropshire  ","D",495,495]
[null,"North Tyneside  ","C",600,800]
[null,"North Warwickshire  ","D",725,600]
[null,"North West Leicestershire ","D",750,750]
[null,"North West Somerset ","C",1100,950]
[null,"North Wiltshire ","C",950,950]
[null,"Northampton  ","D",800,800]
[null,"Norwich  ","D",600,550]
[null,"Nottingham City  ","D",700,620]
[null,"Nuneaton and Bedworth ","E",700,600]
[null,"Oadby and Wigston ","D",750,700]
[null,"Oldham  ","D",675,625]
[null,"Oswestry ","D",490,445]
[null,"Oxford  ","B",3500,3350]
[null,"Pendle ","D",470,270]
[null,"Penwith ","D",330,300]
[null,"Peterborough  ","D",590,565]
[null,"Plymouth  ","D",683,525]
[null,"Poole  ","C",1600,1500]
[null,"Portsmouth  ","C",1000,900]
[null,"Preston  ","D",775,625]
[null,"Purbeck ","C",1000,950]
[null,"Reading  ","C",1950,1950]
[null,"Redbridge ","B",1650,1650]
[null,"Redcar and Cleveland ","D",375,400]
[null,"Redditch  ","D",810,775]
[null,"Reigate and Banstead ","B",1780,1750]
[null,"Restormel ","D",330,300]
[null,"Ribble Valley  ","C",675,625]
[null,"Richmond upon Thames ","A",2600,2600]
[null,"Richmondshire ","D",600,540]
[null,"Rochdale  ","D",650,650]
[null,"Rochford ","C",900,1100]
[null,"Rossendale ","D",475,265]
[null,"Rother ","D",740,700]
[null,"Rotherham  ","D",460,440]
[null,"Rugby  ","D",800,700]
[null,"Runnymede  ","B",2300,2300]
[null,"Rushcliffe ","D",800,745]
[null,"Rushmoor ","B",1720,1720]
[null,"Rutland  ","D",800,675]
[null,"Ryedale ","D",500,400]
[null,"Salford  ","D",500,450]
[null,"Salisbury  ","C",1050,1050]
[null,"Sandwell ","D",570,480]
[null,"Scarborough  ","D",400,350]
[null,"Sedgefield ","D",350,300]
[null,"Sedgemoor  ","D",450,440]
[null,"Sefton ","D",500,425]
[null,"Selby ","D",450,350]
[null,"Sevenoaks ","B",1600,1600]
[null,"Sheffield  ","C",630,540]
[null,"Shepway ","D",865,650]
[null,"Shrewsbury and Atcham ","D",650,765]
[null,"Slough  ","B",1950,1950]
[null,"Solihull  ","C",1800,1650]
[null,"South Bedfordshire  ","C",1100,1100]
[null,"South Bucks ","A",2750,2750]
[null,"South Cambridgeshire  ","C",1130,1025]
[null,"South Derbyshire  ","D",460,375]
[null,"South Gloucestershire  ","D",1300,1200]
[null,"South Hams ","C",716,625]
[null,"South Holland  ","E",325,300]
[null,"South Kesteven  ","E",375,250]
[null,"South Lakeland  ","C",675,575]
[null,"South Norfolk  ","E",350,300]
[null,"South Northamptonshire  ","D",865,865]
[null,"South Oxfordshire  ","C",1250,1200]
[null,"South Ribble  ","D",775,625]
[null,"South Shropshire  ","D",495,445]
[null,"South Somerset  ","D",1000,900]
[null,"South Staffordshire  ","D",950,1000]
[null,"South Tyneside  ","D",500,450]
[null,"Southampton  ","C",1400,1020]
[null,"Southend-on-Sea  ","C",990,920]
[null,"Southwark ","A",2300,2300]
[null,"Spelthorne ","B",1780,1750]
[null,"St. Albans  ","B",1900,2250]
[null,"St. Edmundsbury ","D",650,650]
[null,"St. Helens  ","D",500,410]
[null,"Stafford  ","D",600,425]
[null,"Staffordshire Moorlands ","D",450,325]
[null,"Stevenage  ","B",1400,1250]
[null,"Stockport  ","C",1350,1350]
[null,"Stockton-on-Tees  ","D",500,500]
[null,"Stoke-on-Trent  ","D",450,325]
[null,"Stratford-on-Avon ","C",1450,1400]
[null,"Stroud ","D",850,850]
[null,"Suffolk Coastal ","D",410,400]
[null,"Sunderland  ","D",475,425]
[null,"Surrey Heath ","B",2200,2200]
[null,"Sutton ","B",1900,2470]
[null,"Swale ","C",890,710]
[null,"Tameside ","C",600,490]
[null,"Tamworth  ","D",750,575]
[null,"Tandridge ","B",1780,1750]
[null,"Taunton Deane ","D",925,875]
[null,"Teesdale ","D",325,300]
[null,"Teignbridge ","D",893,819]
[null,"Tendring ","D",600,400]
[null,"Test Valley  ","C",1250,1100]
[null,"Tewkesbury  ","D",1100,1100]
[null,"Thamesdown ","C",850,1050]
[null,"Thanet ","C",700,450]
[null,"The Medway Towns ","C",750,730]
[null,"The Wrekin ","D",500,550]
[null,"Three Rivers ","A",1900,2250]
[null,"Thurrock  ","C",640,555]
[null,"Tonbridge and Malling ","B",1500,1500]
[null,"Torbay  ","D",914,840]
[null,"Torridge ","D",525,478]
[null,"Tower Hamlets ","A",2475,2225]
[null,"Trafford ","C",925,855]
[null,"Tunbridge Wells ","C",1600,1600]
[null,"Tynedale ","D",495,400]
[null,"Uttlesford ","C",1200,1100]
[null,"Vale of White Horse ","C",1200,1150]
[null,"Vale Royal ","D",575,500]
[null,"Wakefield  ","D",700,500]
[null,"Walsall  ","D",975,1025]
[null,"Waltham Forest  ","B",1650,1650]
[null,"Wandsworth ","A",2900,2900]
[null,"Wansbeck ","D",245,200]
[null,"Warrington  ","D",940,700]
[null,"Warwick  ","C",1900,1800]
[null,"Watford  ","B",1900,2250]
[null,"Waveney ","E",320,320]
[null,"Waverley  ","B",2000,2000]
[null,"Wealden ","C",1040,875]
[null,"Wear Valley  ","D",400,300]
[null,"Wellingborough ","D",679,679]
[null,"Welwyn Hatfield ","B",1400,1200]
[null,"West Devon  ","D",680,650]
[null,"West Dorset  ","C",925,875]
[null,"West Lancashire  ","C",775,625]
[null,"West Lindsey ","E",210,135]
[null,"West Oxfordshire  ","C",1200,1100]
[null,"West Somerset  ","D",620,580]
[null,"West Wiltshire ","C",800,950]
[null,"Weymouth and Portland ","C",850,800]
[null,"Wigan  ","D",550,450]
[null,"Winchester  ","B",1720,1720]
[null,"Windsor and Maidenhead ","B",2100,2100]
[null,"Wirral ","D",360,360]
[null,"Woking  ","B",2150,2150]
[null,"Wokingham ","B",2000,2000]
[null,"Wolverhampton  ","D",900,950]
[null,"Worcester City  ","D",820,775]
[null,"Worthing  ","C",950,900]
[null,"Wychavon ","D",830,765]
[null,"Wycombe ","B",2100,2100]
[null,"Wyre ","D",800,750]
[null,"Wyre Forest  ","D",1050,1175]
[null,"York  ","C",800,750]
[]
[null,"A",871]
[null,"B",799]
[null,"C",761]
[null,"D",737]
[null,"E",707]

{"sheet":"Food","index":2,"n_rows":158,"n_cols":14,"rows_kept":158,"cut":false,"hidden":true,"merged":[]}
[]
[null,{"$f":"IF(Menu!B3<>\"\",Menu!B3,\"\")","v":""}]
[null,null,null,null,null,"Unit",null,"Unit",null,"Unit"]
[null,"FOOD / CATERING",null,null,null,"type 1",null,"type 2",null,"type 3"]
[null,null,null,"Total",null,{"$f":"'M1'!C12","v":"Bedsit/room"},null,{"$f":"'M1'!F12","v":"1-bed"},null,{"$f":"'M1'!I12","v":"1-bed"}]
[null,"Number of units",null,{"$f":"SUM(F6:J6)","v":0},null,{"$f":"'M1'!C8","v":0},null,{"$f":"'M1'!F8","v":0},null,{"$f":"'M1'!I8","v":0}]
[null,"Budgeted occupancy (see units page)",null,null,null,{"$f":"IF(F6>0,'M1'!C10,0)","v":0},"%",{"$f":"IF(H6>0,'M1'!F10,0)","v":0},"%",{"$f":"IF(J6>0,'M1'!I10,0)","v":0},"%"]
[null,"Budgeted bad debts (HB-ineligible) - see services page",null,null,null,{"$f":"Services!F10","v":5},"%",{"$f":"Services!H10","v":5},"%",{"$f":"Services!J10","v":5},"%"]
[null,"Budgeted bad debts (HB-eligible) - see services page",null,null,null,{"$f":"Services!F9","v":2},"%",{"$f":"Services!H9","v":2},"%",{"$f":"Services!J9","v":2},"%"]
[null,null,null,{"$f":"IF(D11=\"\",\"Drop-down selection ↓\",\"\")","v":""}]
[null,"Charging method (applies to all types)",null,"Standard deductions"]
[null,"Meals provided (for each unit type)",null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(OR(F12=\"\",F12=\"None\"),OR(H12=\"\",H12=\"None\"),OR(J12=\"\",J12=\"None\")),\"B\",\"\")","v":"B"}]
[null,"Standard HB deductions (HB ineligible food charges)",null,{"$f":"Menu!C5","v":"2025/26"},null,{"$f":"IF(F6=0,0,IF(F12=$F$151,0,IF(AND($D11=$F$156,F12<>\"\",Menu!$C$5<>\"\"),VLOOKUP($D13,Ass!$B$22:$F$25,HLOOKUP(F12,Ass!$D$19:$F$21,ROWS(Ass!$D$19:$D$21),FALSE),FALSE),0)))","v":0},null,{"$f":"IF(H6=0,0,IF(H12=$F$151,0,IF(AND($D11=$F$156,H12<>\"\",Menu!$C$5<>\"\"),VLOOKUP($D13,Ass!$B$22:$F$25,HLOOKUP(H12,Ass!$D$19:$F$21,ROWS(Ass!$D$19:$D$21),FALSE),FALSE),0)))","v":0},null,{"$f":"IF(J6=0,0,IF(J12=$F$151,0,IF(AND($D11=$F$156,J12<>\"\",Menu!$C$5<>\"\"),VLOOKUP($D13,Ass!$B$22:$F$25,HLOOKUP(J12,Ass!$D$19:$F$21,ROWS(Ass!$D$19:$D$21),FALSE),FALSE),0)))","v":0}]
[]
[]
[null,"Food expenditure budget"]
[null,"Salaries - catering staff",null,{"$f":"Salaries!H31","v":0},null,{"$f":"IF($D$11=$F$158,0,IF(AND($D$11=$F$156,$D$114<>0),$D17*F$114/$D$114,IF(AND($D$11=$F$157,$D$93<>0),$D17*F$93/$D$93,0)))","v":0},null,{"$f":"IF($D$11=$F$158,0,IF(AND($D$11=$F$156,$D$114<>0),$D17*H$114/$D$114,IF(AND($D$11=$F$157,$D$93<>0),$D17*H$93/$D$93,0)))","v":0},null,{"$f":"IF($D$11=$F$158,0,IF(AND($D$11=$F$156,$D$114<>0),$D17*J$114/$D$114,IF(AND($D$11=$F$157,$D$93<>0),$D17*J$93/$D$93,0)))","v":0}]
[null,"Provisions / food supplies / other costs",null,null,null,{"$f":"IF(AND($D11=$F157,OR(F12=\"\",F12=\"None\")),0,IF($D$11=$F$158,0,IF(AND($D$11=$F$156,$D$114<>0),$D18*F$114/$D$114,IF(AND($D$11=$F$157,$D$93<>0),$D18*F$93/$D$93,0))))","v":0},null,{"$f":"IF(AND($D11=$F157,OR(H12=\"\",H12=\"None\")),0,IF($D$11=$F$158,0,IF(AND($D$11=$F$156,$D$114<>0),$D18*H$114/$D$114,IF(AND($D$11=$F$157,$D$93<>0),$D18*H$93/$D$93,0))))","v":0},null,{"$f":"IF(AND($D11=$F157,OR(J12=\"\",J12=\"None\")),0,IF($D$11=$F$158,0,IF(AND($D$11=$F$156,$D$114<>0),$D18*J$114/$D$114,IF(AND($D$11=$F$157,$D$93<>0),$D18*J$93/$D$93,0))))","v":0},null,null,null,{"$f":"F156","v":"Standard deductions"}]
[null,{"$f":"IF(D19>0,\"Other costs (balance of ineligible charge income)\",\"\")","v":""},null,{"$f":"SUM(F19:J19)","v":0},null,{"$f":"IF(F63>SUM(F17:F18),F63-SUM(F17:F18),0)","v":0},null,{"$f":"IF(H63>SUM(H17:H18),H63-SUM(H17:H18),0)","v":0},null,{"$f":"IF(J63>SUM(J17:J18),J63-SUM(J17:J18),0)","v":0},null,null,null,{"$f":"F157","v":"All ineligibe"}]
[null,"Total food & catering costs",null,{"$f":"SUM(D17:D19)","v":0},null,{"$f":"SUM(F17:F19)","v":0},null,{"$f":"SUM(H17:H19)","v":0},null,{"$f":"SUM(J17:J19)","v":0},null,null,null,"Separate funding"]
[]
[null,"Income for food / catering"]
[null,"Separate funding / invoicing for food",null,{"$f":"IF(OR($D$11=$F$158,AND($F$12=\"\",$H$12=\"\",$J$12=\"\")),D20,0)","v":0}]
[null,"Ineligible charges (net of voids & bad debts)",null,{"$f":"SUM(F24:J24)","v":0},null,{"$f":"IF($D$11=$F$157,F20,IF($D$11=$F$156,F63,0))","v":0},null,{"$f":"IF($D$11=$F$157,H20,IF($D$11=$F$156,H63,0))","v":0},null,{"$f":"IF($D$11=$F$157,J20,IF($D$11=$F$156,J63,0))","v":0}]
[null,"HB eligible charges (net of voids and bad debts)",null,{"$f":"SUM(F25:J25)","v":0},null,{"$f":"IF(AND($D$11=$F$156,F24<SUM(F17:F18)),SUM(F17:F18)-F24,0)","v":0},null,{"$f":"IF(AND($D$11=$F$156,H24<SUM(H17:H18)),SUM(H17:H18)-H24,0)","v":0},null,{"$f":"IF(AND($D$11=$F$156,J24<SUM(J17:J18)),SUM(J17:J18)-J24,0)","v":0}]
[null,null,null,{"$f":"SUM(D23:D25)","v":0},null,{"$f":"SUM(F23:F25)","v":0},null,{"$f":"SUM(H23:H25)","v":0},null,{"$f":"SUM(J23:J25)","v":0}]
[]
[null,"HB ineligible charges"]
[null,"Units",null,null,null,{"$f":"F6","v":0},null,{"$f":"H6","v":0},null,{"$f":"J6","v":0}]
[null,"Standard ineligible charges",null,null,null,{"$f":"IF($D$11=$F$156,F13,0)","v":0},null,{"$f":"IF($D$11=$F$156,H13,0)","v":0},null,{"$f":"IF($D$11=$F$156,J13,0)","v":0}]
[null,"Ineligible  charges (non-standard)",null,null,null,{"$f":"IF(AND(F$6<>0,F$7-F$8<>0,$D$11=$F$157),F$24/F$6/52*100/(F$7-F$8),0)","v":0},null,{"$f":"IF(AND(H6<>0,H7-H8<>0,$D$11=$F$157),H24/H6/52*100/(H7-H8),0)","v":0},null,{"$f":"IF(AND(J6<>0,J7-J8<>0,$D$11=$F$157),J24/J6/52*100/(J7-J8),0)","v":0}]
[null,"Gross ineligible charges",null,null,null,{"$f":"F29*SUM(F30:F31)*52","v":0},null,{"$f":"H29*SUM(H30:H31)*52","v":0},null,{"$f":"J29*SUM(J30:J31)*52","v":0}]
[null,"Less voids",null,null,null,{"$f":"-F32*(100-F$7)/100","v":0},null,{"$f":"-H32*(100-H7)/100","v":0},null,{"$f":"-J32*(100-J7)/100","v":0}]
[null,"   bad debts",null,null,null,{"$f":"-F32*F$8/100","v":0},null,{"$f":"-H32*H8/100","v":0},null,{"$f":"-J32*J8/100","v":0}]
[null,null,null,null,null,{"$f":"SUM(F32:F34)","v":0},null,{"$f":"SUM(H32:H34)","v":0},null,{"$f":"SUM(J32:J34)","v":0}]
[]
[null,"HB eligible charges",null,null,null,{"$f":"IF(AND(F$6<>0,F$7-F$8<>0),F25/F$6/52*100/(F$7-F$9),0)","v":0},null,{"$f":"IF(AND(H$6<>0,H$7-H$8<>0),H25/H$6/52*100/(H$7-H$9),0)","v":0},null,{"$f":"IF(AND(J$6<>0,J$7-J$8<>0),J25/J$6/52*100/(J$7-J$9),0)","v":0}]
[null,"Gross ineligible charges",null,null,null,{"$f":"F37*F29*52","v":0},null,{"$f":"H37*H29*52","v":0},null,{"$f":"J37*J29*52","v":0}]
[null,"Less voids",null,null,null,{"$f":"-F38*(100-F$7)/100","v":0},null,{"$f":"-H38*(100-H$7)/100","v":0},null,{"$f":"-J38*(100-J$7)/100","v":0}]
[null,"   bad debts",null,null,null,{"$f":"-F38*F$9/100","v":0},null,{"$f":"-H38*H$9/100","v":0},null,{"$f":"-J38*J$9/100","v":0}]
[null,null,null,null,null,{"$f":"SUM(F38:F40)","v":0},null,{"$f":"SUM(H38:H40)","v":0},null,{"$f":"SUM(J38:J40)","v":0}]
[]
[]
[null,"Separate funding",null,{"$f":"D23","v":0}]
[null,"Ineligible",null,{"$f":"D24","v":0}]
[null,"Eligible",null,0]
[]
[null,"Salaries"]
[null,"Separate funding",null,{"$f":"IF(SUM($D$44:$D$46)<>0,$D$17*D44/SUM($D$44:$D$46),0)","v":0}]
[null,"Ineligible",null,{"$f":"IF(SUM($D$44:$D$46)<>0,$D$17*D45/SUM($D$44:$D$46),0)","v":0}]
[null,"Eligible",null,0]
[]
[null,"Other"]
[null,"Separate funding",null,{"$f":"IF(SUM($D$44:$D$46)<>0,SUM($D$18:$D$19)*D44/SUM($D$44:$D$46),0)","v":0}]
[null,"Ineligible",null,{"$f":"IF(SUM($D$44:$D$46)<>0,SUM($D$18:$D$19)*D45/SUM($D$44:$D$46),0)","v":0}]
[null,"Eligible",null,0]
[]
[]
[]
[]
[]
[]
[null,"Standard deductions",null,null,null,{"$f":"IF($D$11=$F$156,F$13*F$6*52*(F$7-F$8)/100,0)","v":0},null,{"$f":"IF($D$11=$F$156,H$13*H$6*52*(H$7-H$8)/100,0)","v":0},null,{"$f":"IF($D$11=$F$156,J$13*J$6*52*(J$7-J$8)/100,0)","v":0}]
[]
[]
[null,"All ineligible / no meals"]
[{"$f":"IF(AND(D$11=$F$157,OR(F$12=\"\",F$12=$F$151),OR(H$12=\"\",H$12=$F$151),OR(J$12=\"\",J$12=$F$151)),1,0)","v":0},"No meals",null,{"$f":"SUM(F67:J67)","v":0},null,{"$f":"F$6","v":0},null,{"$f":"H$6","v":0},null,{"$f":"J$6","v":0}]
[{"$f":"IF(AND(COUNTIF($F$152:$F$154,F$12)=1,COUNTIF($F$152:$F$154,H$12)=0,COUNTIF($F$152:$F$154,J$12)=0),1,0)","v":0},"Meals 1 only",null,{"$f":"SUM(F68:J68)","v":0},null,{"$f":"F$6","v":0}]
[{"$f":"IF(AND(COUNTIF($F$152:$F$154,F$12)=0,COUNTIF($F$152:$F$154,H$12)=1,COUNTIF($F$152:$F$154,J$12)=0),1,0)","v":0},"Meals 2 only",null,{"$f":"SUM(F69:J69)","v":0},null,null,null,{"$f":"H$6","v":0}]
[{"$f":"IF(AND(COUNTIF($F$152:$F$154,F$12)=0,COUNTIF($F$152:$F$154,H$12)=0,COUNTIF($F$152:$F$154,J$12)=1),1,0)","v":0},"Meals 3 only",null,0,null,null,null,null,null,{"$f":"J6","v":0}]
[{"$f":"IF(AND(COUNTIF($F$152:$F$154,F$12)=1,COUNTIF($F$152:$F$154,H$12)=1,COUNTIF($F$152:$F$154,J$12)=0),1,0)","v":0},"Meals 1 & 2",null,0,null,{"$f":"F6","v":0},null,{"$f":"H6","v":0}]
[{"$f":"IF(AND(COUNTIF($F$152:$F$154,F$12)=1,COUNTIF($F$152:$F$154,H$12)=0,COUNTIF($F$152:$F$154,J$12)=1),1,0)","v":0},"Meals 1 & 3",null,0,null,{"$f":"F6","v":0},null,null,null,{"$f":"J6","v":0}]
[{"$f":"IF(AND(COUNTIF($F$152:$F$154,F$12)=0,COUNTIF($F$152:$F$154,H$12)=1,COUNTIF($F$152:$F$154,J$12)=1),1,0)","v":0},"Meals 2 & 3",null,0,null,null,null,{"$f":"H6","v":0},null,{"$f":"J6","v":0}]
[{"$f":"IF(AND(COUNTIF($F$152:$F$154,F$12)=1,COUNTIF($F$152:$F$154,H$12)=1,COUNTIF($F$152:$F$154,J$12)=1),1,0)","v":0},"All meals",null,0,null,{"$f":"F6","v":0},null,{"$f":"H6","v":0},null,{"$f":"J6","v":0}]
[null,"Weighting"]
[{"$f":"IF(AND(D$11=$F$157,OR(F$12=\"\",F$12=$F$151),OR(H$12=\"\",H$12=$F$151),OR(J$12=\"\",J$12=$F$151)),1,0)","v":0},"No meals",null,{"$f":"SUM(F76:J76)","v":3},null,1,null,1,null,1]
[{"$f":"IF(AND(COUNTIF($F$152:$F$154,F$12)=1,COUNTIF($F$152:$F$154,H$12)=0,COUNTIF($F$152:$F$154,J$12)=0),1,0)","v":0},"Meals 1 only",null,{"$f":"SUM(F77:J77)","v":1},null,1]
[{"$f":"IF(AND(COUNTIF($F$152:$F$154,F$12)=0,COUNTIF($F$152:$F$154,H$12)=1,COUNTIF($F$152:$F$154,J$12)=0),1,0)","v":0},"Meals 2 only",null,{"$f":"SUM(F78:J78)","v":1},null,null,null,1]
[{"$f":"IF(AND(COUNTIF($F$152:$F$154,F$12)=0,COUNTIF($F$152:$F$154,H$12)=0,COUNTIF($F$152:$F$154,J$12)=1),1,0)","v":0},"Meals 3 only",null,1,null,null,null,null,null,1]
[{"$f":"IF(AND(COUNTIF($F$152:$F$154,F$12)=1,COUNTIF($F$152:$F$154,H$12)=1,COUNTIF($F$152:$F$154,J$12)=0),1,0)","v":0},"Meals 1 & 2",null,0,null,{"$f":"IF($A71>0,HLOOKUP(F$12,Ass!$D$19:$F$27,ROWS(Ass!$D$19:$D$27),FALSE),0)","v":0},null,{"$f":"IF($A71>0,HLOOKUP(H$12,Ass!$D$19:$F$27,ROWS(Ass!$D$19:$D$27),FALSE),0)","v":0}]
[{"$f":"IF(AND(COUNTIF($F$152:$F$154,F$12)=1,COUNTIF($F$152:$F$154,H$12)=0,COUNTIF($F$152:$F$154,J$12)=1),1,0)","v":0},"Meals 1 & 3",null,0,null,{"$f":"IF($A72>0,HLOOKUP(F$12,Ass!$D$19:$F$27,ROWS(Ass!$D$19:$D$27),FALSE),0)","v":0},null,null,null,{"$f":"IF($A72>0,HLOOKUP(J$12,Ass!$D$19:$F$27,ROWS(Ass!$D$19:$D$27),FALSE),0)","v":0}]
[{"$f":"IF(AND(COUNTIF($F$152:$F$154,F$12)=0,COUNTIF($F$152:$F$154,H$12)=1,COUNTIF($F$152:$F$154,J$12)=1),1,0)","v":0},"Meals 2 & 3",null,0,null,null,null,{"$f":"IF($A73>0,HLOOKUP(H$12,Ass!$D$19:$F$27,ROWS(Ass!$D$19:$D$27),FALSE),0)","v":0},null,{"$f":"IF($A73>0,HLOOKUP(J$12,Ass!$D$19:$F$27,ROWS(Ass!$D$19:$D$27),FALSE),0)","v":0}]
[{"$f":"IF(AND(COUNTIF($F$152:$F$154,F$12)=1,COUNTIF($F$152:$F$154,H$12)=1,COUNTIF($F$152:$F$154,J$12)=1),1,0)","v":0},"All meals",null,0,null,{"$f":"IF($A74>0,HLOOKUP(F$12,Ass!$D$19:$F$27,ROWS(Ass!$D$19:$D$27),FALSE),0)","v":0},null,{"$f":"IF($A74>0,HLOOKUP(H$12,Ass!$D$19:$F$27,ROWS(Ass!$D$19:$D$27),FALSE),0)","v":0},null,{"$f":"IF($A74>0,HLOOKUP(J$12,Ass!$D$19:$F$27,ROWS(Ass!$D$19:$D$27),FALSE),0)","v":0}]
[null,"Weighting x units"]
[{"$f":"IF(AND(D$11=$F$157,OR(F$12=\"\",F$12=$F$151),OR(H$12=\"\",H$12=$F$151),OR(J$12=\"\",J$12=$F$151)),1,0)","v":0},"No meals",null,{"$f":"SUM(F85:J85)","v":0},null,{"$f":"IF($A85=1,F67*F76,0)","v":0},null,{"$f":"IF($A85=1,H67*H76,0)","v":0},null,{"$f":"IF($A85=1,J67*J76,0)","v":0}]
[{"$f":"IF(AND(COUNTIF($F$152:$F$154,F$12)=1,COUNTIF($F$152:$F$154,H$12)=0,COUNTIF($F$152:$F$154,J$12)=0),1,0)","v":0},"Meals 1 only",null,0,null,{"$f":"IF($A86=1,F68*F77,0)","v":0},null,{"$f":"IF($A86=1,H68*H77,0)","v":0},null,{"$f":"IF($A86=1,J68*J77,0)","v":0}]
[{"$f":"IF(AND(COUNTIF($F$152:$F$154,F$12)=0,COUNTIF($F$152:$F$154,H$12)=1,COUNTIF($F$152:$F$154,J$12)=0),1,0)","v":0},"Meals 2 only",null,0,null,0,null,0,null,0]
[{"$f":"IF(AND(COUNTIF($F$152:$F$154,F$12)=0,COUNTIF($F$152:$F$154,H$12)=0,COUNTIF($F$152:$F$154,J$12)=1),1,0)","v":0},"Meals 3 only",null,0,null,0,null,0,null,0]
[{"$f":"IF(AND(COUNTIF($F$152:$F$154,F$12)=1,COUNTIF($F$152:$F$154,H$12)=1,COUNTIF($F$152:$F$154,J$12)=0),1,0)","v":0},"Meals 1 & 2",null,0,null,0,null,0,null,0]
[{"$f":"IF(AND(COUNTIF($F$152:$F$154,F$12)=1,COUNTIF($F$152:$F$154,H$12)=0,COUNTIF($F$152:$F$154,J$12)=1),1,0)","v":0},"Meals 1 & 3",null,0,null,0,null,0,null,0]
[{"$f":"IF(AND(COUNTIF($F$152:$F$154,F$12)=0,COUNTIF($F$152:$F$154,H$12)=1,COUNTIF($F$152:$F$154,J$12)=1),1,0)","v":0},"Meals 2 & 3",null,0,null,0,null,0,null,0]
[{"$f":"IF(AND(COUNTIF($F$152:$F$154,F$12)=1,COUNTIF($F$152:$F$154,H$12)=1,COUNTIF($F$152:$F$154,J$12)=1),1,0)","v":0},"All meals",null,0,null,0,null,0,null,0]
[null,null,null,{"$f":"SUM(D85:D92)","v":0},null,{"$f":"SUM(F85:F92)","v":0},null,{"$f":"SUM(H85:H92)","v":0},null,{"$f":"SUM(J85:J92)","v":0}]
[]
[null,"Standard deductions"]
[{"$f":"IF(AND(D$11=$F$157,OR(F$12=\"\",F$12=$F$151),OR(H$12=\"\",H$12=$F$151),OR(J$12=\"\",J$12=$F$151)),1,0)","v":0},"No meals",null,{"$f":"SUM(F96:J96)","v":0},null,0,null,0,null,0]
[{"$f":"IF(AND(COUNTIF($F$152:$F$154,F$12)=1,COUNTIF($F$152:$F$154,H$12)=0,COUNTIF($F$152:$F$154,J$12)=0),1,0)","v":0},"Meals 1 only",null,{"$f":"SUM(F97:J97)","v":0},null,{"$f":"F$13","v":0}]
[{"$f":"IF(AND(COUNTIF($F$152:$F$154,F$12)=0,COUNTIF($F$152:$F$154,H$12)=1,COUNTIF($F$152:$F$154,J$12)=0),1,0)","v":0},"Meals 2 only",null,{"$f":"SUM(F98:J98)","v":0},null,null,null,{"$f":"H$13","v":0}]
[{"$f":"IF(AND(COUNTIF($F$152:$F$154,F$12)=0,COUNTIF($F$152:$F$154,H$12)=0,COUNTIF($F$152:$F$154,J$12)=1),1,0)","v":0},"Meals 3 only",null,0,null,null,null,null,null,{"$f":"J$13","v":0}]
[{"$f":"IF(AND(COUNTIF($F$152:$F$154,F$12)=1,COUNTIF($F$152:$F$154,H$12)=1,COUNTIF($F$152:$F$154,J$12)=0),1,0)","v":0},"Meals 1 & 2",null,0,null,{"$f":"F$13","v":0},null,{"$f":"H$13","v":0}]
[{"$f":"IF(AND(COUNTIF($F$152:$F$154,F$12)=1,COUNTIF($F$152:$F$154,H$12)=0,COUNTIF($F$152:$F$154,J$12)=1),1,0)","v":0},"Meals 1 & 3",null,0,null,{"$f":"F$13","v":0},null,null,null,{"$f":"J$13","v":0}]
[{"$f":"IF(AND(COUNTIF($F$152:$F$154,F$12)=0,COUNTIF($F$152:$F$154,H$12)=1,COUNTIF($F$152:$F$154,J$12)=1),1,0)","v":0},"Meals 2 & 3",null,0,null,null,null,{"$f":"H$13","v":0},null,{"$f":"J$13","v":0}]
[{"$f":"IF(AND(COUNTIF($F$152:$F$154,F$12)=1,COUNTIF($F$152:$F$154,H$12)=1,COUNTIF($F$152:$F$154,J$12)=1),1,0)","v":0},"All meals",null,0,null,{"$f":"F$13","v":0},null,{"$f":"H$13","v":0},null,{"$f":"J$13","v":0}]
[]
[]
[{"$f":"IF(AND(D$11=$F$157,OR(F$12=\"\",F$12=$F$151),OR(H$12=\"\",H$12=$F$151),OR(J$12=\"\",J$12=$F$151)),1,0)","v":0},"No meals",null,{"$f":"SUM(F106:J106)","v":0},null,{"$f":"IF($A106=1,F$6*F96,0)","v":0},null,{"$f":"IF($A106=1,H$6*H96,0)","v":0},null,{"$f":"IF($A106=1,J$6*J96,0)","v":0}]
[{"$f":"IF(AND(COUNTIF($F$152:$F$154,F$12)=1,COUNTIF($F$152:$F$154,H$12)=0,COUNTIF($F$152:$F$154,J$12)=0),1,0)","v":0},"Meals 1 only",null,{"$f":"SUM(F107:J107)","v":0},null,{"$f":"IF($A107=1,F$6*F97,0)","v":0},null,{"$f":"IF($A107=1,H$6*H97,0)","v":0},null,{"$f":"IF($A107=1,J$6*J97,0)","v":0}]
[{"$f":"IF(AND(COUNTIF($F$152:$F$154,F$12)=0,COUNTIF($F$152:$F$154,H$12)=1,COUNTIF($F$152:$F$154,J$12)=0),1,0)","v":0},"Meals 2 only",null,0,null,0,null,0,null,0]
[{"$f":"IF(AND(COUNTIF($F$152:$F$154,F$12)=0,COUNTIF($F$152:$F$154,H$12)=0,COUNTIF($F$152:$F$154,J$12)=1),1,0)","v":0},"Meals 3 only",null,0,null,0,null,0,null,0]
[{"$f":"IF(AND(COUNTIF($F$152:$F$154,F$12)=1,COUNTIF($F$152:$F$154,H$12)=1,COUNTIF($F$152:$F$154,J$12)=0),1,0)","v":0},"Meals 1 & 2",null,0,null,0,null,0,null,0]
[{"$f":"IF(AND(COUNTIF($F$152:$F$154,F$12)=1,COUNTIF($F$152:$F$154,H$12)=0,COUNTIF($F$152:$F$154,J$12)=1),1,0)","v":0},"Meals 1 & 3",null,0,null,0,null,0,null,0]
[{"$f":"IF(AND(COUNTIF($F$152:$F$154,F$12)=0,COUNTIF($F$152:$F$154,H$12)=1,COUNTIF($F$152:$F$154,J$12)=1),1,0)","v":0},"Meals 2 & 3",null,0,null,0,null,0,null,0]
[{"$f":"IF(AND(COUNTIF($F$152:$F$154,F$12)=1,COUNTIF($F$152:$F$154,H$12)=1,COUNTIF($F$152:$F$154,J$12)=1),1,0)","v":0},"All meals",null,0,null,0,null,0,null,0]
[null,null,null,{"$f":"SUM(D106:D113)","v":0},null,{"$f":"SUM(F106:F113)","v":0},null,{"$f":"SUM(H106:H113)","v":0},null,{"$f":"SUM(J106:J113)","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,{"$f":"F152","v":"Breakfast"},null,{"$f":"Ass!D27","v":1}]
[null,{"$f":"F153","v":"2 meals"},null,{"$f":"Ass!E27","v":5.4883720930232567}]
[null,"3 meals",null,{"$f":"Ass!F27","v":8.2209302325581408}]
[]
[]
[]
[]
[null,null,null,null,null,"None"]
[null,null,null,null,null,{"$f":"Ass!D19","v":"Breakfast"}]
[null,null,null,null,null,{"$f":"Ass!E19","v":"2 meals"}]
[null,null,null,null,null,{"$f":"Ass!F19","v":"3 meals"}]
[]
[null,null,null,null,null,"Standard deductions"]
[null,null,null,null,null,"All ineligibe"]
[null,null,null,null,null,"Separate funding"]

{"sheet":"Ass","index":3,"n_rows":27,"n_cols":7,"rows_kept":27,"cut":false,"hidden":true,"merged":[]}
[]
[]
[null,{"$f":"IF(Menu!B3<>\"\",Menu!B3,\"\")","v":""}]
[]
[null,"WORKING ASSUMPTIONS"]
[]
[null,"Inflation"]
[null,"CPI September 2023",null,{"$f":"'F1'!O35","v":6.7},"%"]
[null,"CPI September 2024",null,2.2000000000000002,"%"]
[null,"CPI September 2025",null,2,"%"]
[null,"CPI September 2026",null,2,"%"]
[]
[null,"Formula rent (CPI additions)",null,null,null,"Formula rent increases"]
[null,"2024/25","From April 2024",{"$f":"'F1'!P35","v":1},"%",{"$f":"SUM(D14,D8)","v":7.7},"%"]
[null,"2025/26","From April 2025",1,"%",{"$f":"SUM(D15,D9)","v":3.2},"%"]
[null,"2026/27","From April 2026",1,"%",3,"%"]
[null,"2027/28","From April 2027",1,"%",3,"%"]
[]
[null,"HB deductions for meals",null,"Breakfast","2 meals","3 meals"]
[null,null,null,1,2,3]
[null,null,null,{"$f":"COLUMNS($B21:D21)","v":3},{"$f":"COLUMNS($B21:E21)","v":4},{"$f":"COLUMNS($B21:F21)","v":5}]
[null,"2024/25",null,4.3,23.6,35.35]
[null,"2025/26",null,{"$f":"ROUND(D22*(100+$D9)/100,2)","v":4.3899999999999997},{"$f":"ROUND(E22*(100+$D9)/100,2)","v":24.12},36.130000000000003]
[null,"2026/27",null,{"$f":"ROUND(D23*(100+$D10)/100,2)","v":4.4800000000000004},{"$f":"ROUND(E23*(100+$D10)/100,2)","v":24.6},{"$f":"ROUND(F23*(100+$D10)/100,2)","v":36.85}]
[null,"2027/28",null,{"$f":"ROUND(D24*(100+$D11)/100,2)","v":4.57},{"$f":"ROUND(E24*(100+$D11)/100,2)","v":25.09},{"$f":"ROUND(F24*(100+$D11)/100,2)","v":37.590000000000003}]
[]
[null,"Relaitive to breakfast only",null,1,{"$f":"E22/D22","v":5.4883720930232567},{"$f":"F22/D22","v":8.2209302325581408}]

{"sheet":"CSS","index":4,"n_rows":66,"n_cols":11,"rows_kept":66,"cut":false,"hidden":true,"merged":[]}
[]
[null,{"$f":"IF(Menu!B3<>\"\",Menu!B3,\"\")","v":""}]
[null,null,null,null,null,"Unit",null,"Unit",null,"Unit"]
[null,"Care / support & supervision",null,null,null,"type 1",null,"type 2",null,"type 3"]
[null,null,null,"Total",null,{"$f":"'M1'!C12","v":"Bedsit/room"},null,{"$f":"'M1'!F12","v":"1-bed"},null,{"$f":"'M1'!I12","v":"1-bed"}]
[null,"Number of units",null,{"$f":"SUM(F6:J6)","v":0},null,{"$f":"'M1'!C8","v":0},null,{"$f":"'M1'!F8","v":0},null,{"$f":"'M1'!I8","v":0}]
[null,"Budgeted occupancy (see units page)",null,null,null,{"$f":"IF(F6>0,'M1'!C10,0)","v":0},"%",{"$f":"IF(H6>0,'M1'!F10,0)","v":0},"%",{"$f":"IF(J6>0,'M1'!I10,0)","v":0},"%"]
[null,"Budgeted bad debts (HB-ineligible) - see services page",null,null,null,{"$f":"Services!F10","v":5},"%",{"$f":"Services!H10","v":5},"%",{"$f":"Services!J10","v":5},"%"]
[]
[null,"Weekly hours per resident"]
[null,"Adjust weekly hours between units  +/-  ( %)",null,null,null,null,{"$f":"IF(F11<>0,\"%\",\"\")","v":""},null,{"$f":"IF(H11<>0,\"%\",\"\")","v":""},null,{"$f":"IF(J11<>0,\"%\",\"\")","v":""}]
[null,"Staff-time - weekly hours",null,{"$f":"Salaries!I33","v":0},null,{"$f":"IF($D$66<>0,$D12*F66/$D$66,0)","v":0},null,{"$f":"IF($D$66<>0,$D12*H66/$D$66,0)","v":0},null,{"$f":"IF($D$66<>0,$D12*J66/$D$66,0)","v":0}]
[null,"Weekly hours per resident",null,{"$f":"IF(D6<>0,D12/D6,0)","v":0},null,{"$f":"IF(F6<>0,F12/F6,0)","v":0},null,{"$f":"IF(H6<>0,H12/H6,0)","v":0},null,{"$f":"IF(J6<>0,J12/J6,0)","v":0}]
[]
[null,"Care support and supervision budget"]
[null,"Salaries - from salaries page",null,{"$f":"Salaries!H33","v":0},null,{"$f":"IF($D$12<>0,$D16*F$12/$D$12,0)","v":0},null,{"$f":"IF($D$12<>0,$D16*H$12/$D$12,0)","v":0},null,{"$f":"IF($D$12<>0,$D16*J$12/$D$12,0)","v":0}]
[null,"On-call / sleep in - from out of hours cover page",null,{"$f":"SUM('Out of hrs'!D8,'Out of hrs'!D13)","v":0},null,{"$f":"IF($D$12<>0,$D17*F$12/$D$12,0)","v":0},null,{"$f":"IF($D$12<>0,$D17*H$12/$D$12,0)","v":0},null,{"$f":"IF($D$12<>0,$D17*J$12/$D$12,0)","v":0}]
[null,"Other care support & supervision expenditure",null,0,null,{"$f":"IF($D$12<>0,$D18*F$12/$D$12,0)","v":0},null,{"$f":"IF($D$12<>0,$D18*H$12/$D$12,0)","v":0},null,{"$f":"IF($D$12<>0,$D18*J$12/$D$12,0)","v":0}]
[null,"Other care support & supervision",null,0,null,0,null,0,null,0]
[null,"Central / area team costs",null,0,null,0,null,0,null,0]
[null,"Central overhead charge",null,0,null,0,null,0,null,0]
[null,"Total expenditure",null,{"$f":"SUM(D16:D21)","v":0},null,{"$f":"SUM(F16:F21)","v":0},null,{"$f":"SUM(H16:H21)","v":0},null,{"$f":"SUM(J16:J21)","v":0}]
[]
[]
[null,"CARE / SUPPORT & SUPERVISION FUNDING"]
[]
[null,"Contracts for care, support & supervision"]
[]
[]
[null,null,null,{"$f":"SUM(D28:D29)","v":0}]
[null,"Charitable funding"]
[]
[]
[]
[null,null,null,{"$f":"SUM(D32:D34)","v":0}]
[null,"Charges to residents (ineligible for HB) - if any",null,null,null,{"$f":"F4","v":"type 1"},null,{"$f":"H4","v":"type 2"},null,{"$f":"J4","v":"type 3"}]
[null,"Weekly charge",null,null,{"$f":"IF(AND(F37>0,F12=0),\"?\",IF(F37>0,\"£\",\"\"))","v":""},0,{"$f":"IF(AND(H37>0,H12=0),\"?\",IF(H37>0,\"£\",\"\"))","v":""},0,{"$f":"IF(AND(J37>0,J12=0),\"?\",IF(J37>0,\"£\",\"\"))","v":""},0]
[null,"Care / support and supervision charges receivable",null,{"$f":"SUM(F38,H38,J38)","v":0},null,{"$f":"F37*F6*52","v":0},null,{"$f":"H37*H6*52","v":0},null,{"$f":"J37*J6*52","v":0}]
[null,"Less:"]
[null,"Voids",null,{"$f":"SUM(F40,H40,J40)","v":0},null,{"$f":"-F38*(100-F7)/100","v":0},null,{"$f":"-H38*(100-H7)/100","v":0},null,{"$f":"-J38*(100-J7)/100","v":0}]
[null,"Bad debts",null,0,null,{"$f":"-F38*F8/100","v":0},null,{"$f":"-H38*H8/100","v":0},null,{"$f":"-J38*J8/100","v":0}]
[null,"Net income from charges",null,{"$f":"SUM(D38,D40:D41)","v":0},null,{"$f":"SUM(F38,F40:F41)","v":0},null,{"$f":"SUM(H38,H40:H41)","v":0},null,{"$f":"SUM(J38,J40:J41)","v":0}]
[]
[null,"Cross-subsidy from other activities"]
[]
[null,null,null,0]
[null,null,null,{"$f":"SUM(D45:D46)","v":0}]
[]
[null,"Total income",null,{"$f":"SUM(D47,D42,D35,D30)","v":0}]
[]
[null,{"$f":"IF(D51>=0,\"Surplus\",IF(D51<0,\"Deficit\",\"\"))","v":"Surplus"},null,{"$f":"ROUND(D49-D22,0)","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,{"$f":"SUM(F66:J66)","v":0},null,{"$f":"F6*(100+F11)/100","v":0},null,{"$f":"H6*(100+H11)/100","v":0},null,{"$f":"J6*(100+J11)/100","v":0}]

{"sheet":"Budget1","index":5,"n_rows":56,"n_cols":10,"rows_kept":56,"cut":false,"hidden":true,"merged":[]}
[]
[]
[null,"SUMMARY BUDGET",null,null,null,null,null,null,null,"Care"]
[null,{"$f":"IF(Menu!B3<>\"\",Menu!B3,\"\")","v":""},null,null,null,null,null,null,null,"support &"]
[null,null,null,null,"Core","Council ","Enhanced","Communal","HB","Super-"]
[null,null,null,"TOTAL","Property","tax","mngmnt","services","ineligible","vision *"]
[null,"INCOME"]
[null,"Core rents receivable",null,{"$f":"SUM(E8:J8)","v":0},{"$f":"('M1'!C38*'M1'!C8+'M1'!F38*'M1'!F8+'M1'!I38*'M1'!I8)*52","v":0},{"$f":"CT!D14","v":0}]
[null,"less voids",null,{"$f":"SUM(E9:J9)","v":0},{"$f":"-'M1'!C8*'M1'!C38*52*(100-'M1'!C10)/100-'M1'!F8*'M1'!F38*52*(100-'M1'!F10)/100-'M1'!I8*'M1'!I38*52*(100-'M1'!I10)/100","v":0},{"$f":"CT!D15","v":0}]
[null,null,null,{"$f":"SUM(D8:D9)","v":0},{"$f":"SUM(E8:E9)","v":0},{"$f":"SUM(F8:F9)","v":0}]
[]
[null,"Service charges receivable",null,{"$f":"SUM(E12:J12)","v":0},null,null,{"$f":"EHM!D30","v":0},{"$f":"Services!D87","v":0},{"$f":"Services!D93","v":0},{"$f":"CSS!D38","v":0}]
[null,"less voids",null,{"$f":"SUM(E13:J13)","v":0},null,null,{"$f":"EHM!D32","v":0},{"$f":"Services!D89","v":0},{"$f":"Services!D95","v":0},{"$f":"CSS!D40","v":0}]
[null,null,null,{"$f":"SUM(D12:D13)","v":0},null,null,{"$f":"SUM(G12:G13)","v":0},{"$f":"SUM(H12:H13)","v":0},0,{"$f":"SUM(J12:J13)","v":0}]
[]
[null,"Food / catering: excluding service charge income",null,{"$f":"SUM(E16:J16)","v":0},null,null,null,null,null,{"$f":"Food!D23","v":0}]
[null,"Contract income",null,0,null,null,null,null,null,{"$f":"CSS!D30","v":0}]
[null,"Charitable income",null,0,null,null,null,null,null,{"$f":"CSS!D35","v":0}]
[null,"Cross-subsidy",null,0,null,null,null,null,null,{"$f":"CSS!D47","v":0}]
[null,"Total income",null,{"$f":"SUM(D14:D19,D10)","v":0},{"$f":"SUM(E14:E19,E10)","v":0},0,0,0,0,0]
[]
[null,"EXPENDITURE"]
[]
[null,"Bad debts",null,{"$f":"SUM(E24:J24)","v":0},{"$f":"'M1'!C8*'M1'!C38*52*(Prop!F8)/100+'M1'!F8*'M1'!F38*52*(Prop!H8)/100+'M1'!I8*'M1'!I38*52*(Prop!J8)/100","v":0},{"$f":"-CT!D16","v":0},{"$f":"-EHM!D33","v":0},{"$f":"-Services!D90","v":0},{"$f":"-Services!D96","v":0},{"$f":"-CSS!D41","v":0}]
[]
[null,"Services (excluding salaries)"]
[null,{"$f":"PROPER(Services!B13)","v":"Utilities"},null,0,null,null,null,{"$f":"SUM(Services!D14,Services!D16,Services!D18)","v":0},{"$f":"SUM(Services!D15,Services!D17,Services!D19)","v":0}]
[null,{"$f":"PROPER(Services!B20)","v":"Cleaning / Grounds Maintenance / Pest Control"},null,0,null,null,null,{"$f":"SUM(Services!D21:D22,Services!D26:D34)","v":0}]
[null,{"$f":"PROPER(Services!B35)","v":"Fire / Health & Safety"},null,0,null,null,null,{"$f":"SUM(Services!D36:D46)","v":0}]
[null,{"$f":"PROPER(Services!B47)","v":"Furniture & Equipment"},null,0,null,null,null,{"$f":"SUM(Services!D48:D57)","v":0}]
[null,{"$f":"PROPER(Services!B58)","v":"Security"},null,0,null,null,null,{"$f":"SUM(Services!D59,Services!D61:D63)","v":0}]
[null,{"$f":"PROPER(Services!B64)","v":"Communal Facilities"},null,0,null,null,null,{"$f":"SUM(Services!D65:D67)","v":0}]
[null,{"$f":"PROPER(Services!B68)","v":"Food / Catering"},null,0,null,null,null,{"$f":"Food!D56","v":0},{"$f":"Food!D55","v":0},{"$f":"Food!D54","v":0}]
[]
[null,"Property costs"]
[null,"Lease",null,0,{"$f":"SUM(Prop!D12:D13)","v":0}]
[null,"Loan charges",null,0,{"$f":"Prop!D16","v":0}]
[null,"Property insurance",null,0,{"$f":"Prop!D14","v":0}]
[null,"Other",null,0,{"$f":"Prop!D15","v":0}]
[null,"Repairs and maintenance",null,0,{"$f":"SUM(Prop!D19:D21,Prop!D24:D28)","v":0}]
[null,"Cyclical maintenance",null,0,{"$f":"Prop!D22","v":0}]
[null,"Major repairs",null,0,{"$f":"Prop!D23","v":0}]
[]
[null,"Salaries",null,{"$f":"SUM(E44:J44)","v":0},{"$f":"SUM(Salaries!H26:H27)","v":0},null,{"$f":"SUM(EHM!D16:D17)","v":0},{"$f":"SUM(Services!D23:D24,Services!D60)+Food!D51","v":0},{"$f":"Food!D50+Services!D25","v":0},{"$f":"CSS!D16+IF(J16>0,Food!D17,0)","v":0}]
[null,"Administrative expenses",null,0,{"$f":"SUM(Prop!D38:D42,Prop!D33:D34)","v":0},null,{"$f":"SUM(EHM!D21:D22)","v":0},{"$f":"Services!F78+Services!H78+Services!J78","v":0},{"$f":"Services!F79+Services!H79+Services!J79","v":0},{"$f":"SUM(CSS!D20:D21)","v":0}]
[]
[null,"Non-staff costs"]
[null,"Enhanced management",null,{"$f":"SUM(E48:J48)","v":0},null,null,{"$f":"SUM(EHM!D18:D20)","v":0}]
[null,"Care and support",null,{"$f":"SUM(E49:J49)","v":0},null,null,null,null,null,{"$f":"SUM(CSS!D17:D19)","v":0}]
[null,"Council tax",null,{"$f":"SUM(E50:J50)","v":0},{"$f":"CT!D18","v":0},{"$f":"CT!D17","v":0}]
[]
[null,"Total expenditure",null,{"$f":"SUM(D24:D51)","v":0},0,0,0,0,0,0]
[]
[null,"Total expenditure",null,{"$f":"ROUND(D20-D52,0)","v":0},0,0,0,0,0,0]
[]
[null,{"$f":"IF(SUM('M1'!C8,'M1'!F8,'M1'!I8)=0,\"NB non units have been entered, therefore the salaries of staff that would be charged\",\"\")","v":"NB non units have been entered, therefore the salaries of staff that would be charged"}]

{"sheet":"Services","index":6,"n_rows":154,"n_cols":17,"rows_kept":154,"cut":false,"hidden":true,"merged":[[68,7,69,7],[68,9,69,9],[2,5,2,9],[2,12,2,16],[67,2,67,4],[68,5,69,5],[3,1,3,4],[68,3,69,3]]}
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"D151","v":5},null,{"$f":"M1","v":5},null,{"$f":"M1","v":5}]
[null,{"$f":"IF(Menu!B3<>\"\",Menu!B3,\"\")","v":""}]
[null,null,null,null,null,"ANNUAL BUDGET",null,null,null,null,null,null,"WEEKLY CHARGES"]
[null,"SERVICES",null,null,null,"Unit",null,"Unit",null,"Unit",null,null,"Unit",null,"Unit",null,"Unit"]
[null,"HB eligible services",null,null,null,"type 1",null,"type 2",null,"type 3",null,null,"type 1",null,"type 2",null,"type 3"]
[null,"HB ineligible services",null,"Total",null,{"$f":"'M1'!C12","v":"Bedsit/room"},null,{"$f":"'M1'!F12","v":"1-bed"},null,{"$f":"'M1'!I12","v":"1-bed"},null,null,{"$f":"F6","v":"Bedsit/room"},null,{"$f":"H6","v":"1-bed"},null,{"$f":"J6","v":"1-bed"}]
[null,"Number of units",null,{"$f":"SUM(F7:J7)","v":0},null,{"$f":"'M1'!C8","v":0},null,{"$f":"'M1'!F8","v":0},null,{"$f":"'M1'!I8","v":0}]
[null,"Budgeted occupancy (see units page)",null,null,null,{"$f":"IF(F7>0,'M1'!C10,0)","v":0},"%",{"$f":"IF(H7>0,'M1'!F10,0)","v":0},"%",{"$f":"IF(J7>0,'M1'!I10,0)","v":0},"%"]
[null,"Budgeted bad debts (HB eligible charges)",null,null,null,2,"%",2,"%",2,"%"]
[null,"Budgeted bad debts (HB ineligible charges)",null,null,null,5,"%",5,"%",5,"%"]
[]
[null,"Annual budget"]
[null,"UTILITIES"]
[null,"Heat and light (common parts only)",{"$f":"IF(D14>0,\"£\",\"\")","v":""},{"$f":"IF(F$7>0,F14,0)+IF(H$7>0,H14,0)+IF(J$7>0,J14,0)","v":0},{"$f":"IF(F14>0,\"£\",\"\")","v":""},0,{"$f":"IF(H14>0,\"£\",\"\")","v":""},null,{"$f":"IF(J14>0,\"£\",\"\")","v":""},null,null,null,{"$f":"IF(F$7>0,ROUND(F14/F$7/52*IF(F$8-F$9=0,1,100/(F$8-F$9)),M$1),0)","v":0},null,{"$f":"IF(H$7>0,ROUND(H14/H$7/52*IF(H$8-H$9=0,1,100/(H$8-H$9)),O$1),0)","v":0},null,{"$f":"IF(J$7>0,ROUND(J14/J$7/52*IF(J$8-J$9=0,1,100/(J$8-J$9)),Q$1),0)","v":0}]
[null,"Heat and light (rooms / flats)",{"$f":"IF(D15>0,\"£\",\"\")","v":""},{"$f":"IF(F$7>0,F15,0)+IF(H$7>0,H15,0)+IF(J$7>0,J15,0)","v":0},{"$f":"IF(F15>0,\"£\",\"\")","v":""},null,{"$f":"IF(H15>0,\"£\",\"\")","v":""},null,"",null,null,null,{"$f":"IF(F$7>0,ROUND(F15/F$7/52*IF(F$8-F$10=0,1,100/(F$8-F$10)),M$1),0)","v":0},null,{"$f":"IF(H$7>0,ROUND(H15/H$7/52*IF(H$8-H$10=0,1,100/(H$8-H$10)),O$1),0)","v":0},null,{"$f":"IF(J$7>0,ROUND(J15/J$7/52*IF(J$8-J$10=0,1,100/(J$8-J$10)),Q$1),0)","v":0}]
[null,"Water charges (common parts only)","",0,"",null,{"$f":"IF(H16>0,\"£\",\"\")","v":""},null,"",null,null,null,{"$f":"IF(F$7>0,ROUND(F16/F$7/52*IF(F$8-F$9=0,1,100/(F$8-F$9)),M$1),0)","v":0},null,{"$f":"IF(H$7>0,ROUND(H16/H$7/52*IF(H$8-H$9=0,1,100/(H$8-H$9)),O$1),0)","v":0},null,{"$f":"IF(J$7>0,ROUND(J16/J$7/52*IF(J$8-J$9=0,1,100/(J$8-J$9)),Q$1),0)","v":0}]
[null,"Water charges (rooms/flats)","",0,"",null,{"$f":"IF(H17>0,\"£\",\"\")","v":""},null,"",null,null,null,{"$f":"IF(F$7>0,ROUND(F17/F$7/52*IF(F$8-F$10=0,1,100/(F$8-F$10)),M$1),0)","v":0},null,{"$f":"IF(H$7>0,ROUND(H17/H$7/52*IF(H$8-H$10=0,1,100/(H$8-H$10)),O$1),0)","v":0},null,{"$f":"IF(J$7>0,ROUND(J17/J$7/52*IF(J$8-J$10=0,1,100/(J$8-J$10)),Q$1),0)","v":0}]
[null,"Phone line rental (for use by residents)","",0,"",null,{"$f":"IF(H18>0,\"£\",\"\")","v":""},null,"",null,null,null,0,null,0,null,0]
[null,"Broadband charges","",0,"",null,{"$f":"IF(H19>0,\"£\",\"\")","v":""},null,"",null,null,null,{"$f":"IF(F$7>0,ROUND(F19/F$7/52*IF(F$8-F$10=0,1,100/(F$8-F$10)),M$1),0)","v":0},null,{"$f":"IF(H$7>0,ROUND(H19/H$7/52*IF(H$8-H$10=0,1,100/(H$8-H$10)),O$1),0)","v":0},null,{"$f":"IF(J$7>0,ROUND(J19/J$7/52*IF(J$8-J$10=0,1,100/(J$8-J$10)),Q$1),0)","v":0}]
[null,"CLEANING / GROUNDS MAINTENANCE / PEST CONTROL"]
[null,"Cleaning materials","",{"$f":"IF(F$7>0,F21,0)+IF(H$7>0,H21,0)+IF(J$7>0,J21,0)","v":0},{"$f":"IF(F21>0,\"£\",\"\")","v":""},null,null,null,null,null,null,null,0,null,0,null,0]
[null,"Cleaning contracts (common parts)","",0,"",null,null,null,null,null,null,null,0,null,0,null,0]
[null,"Cleaning staff (from salaries schedule)","",{"$f":"IF(F$7>0,F23,0)+IF(H$7>0,H23,0)+IF(J$7>0,J23,0)","v":0},{"$f":"IF(F23>0,\"£\",\"\")","v":""},{"$f":"IF($D$7<>0,Salaries!$AD24*F7/$D$7,0)","v":0},null,{"$f":"IF($D$7<>0,Salaries!$AD24*H7/$D$7,0)","v":0},null,{"$f":"IF($D$7<>0,Salaries!$AD24*J7/$D$7,0)","v":0},null,null,0,null,0,null,0]
[null,"Caretaking (from salaries schedule)","",0,"",{"$f":"IF($D$7<>0,Salaries!$AE24*F7/$D$7,0)","v":0},null,{"$f":"IF($D$7<>0,Salaries!$AE24*H7/$D$7,0)","v":0},null,{"$f":"IF($D$7<>0,Salaries!$AE24*J7/$D$7,0)","v":0},null,null,0,null,0,null,0]
[null,"Salaries - inelig services (exc catering)",{"$f":"IF(D25>0,\"£\",\"\")","v":""},{"$f":"IF(F$7>0,F25,0)+IF(H$7>0,H25,0)+IF(J$7>0,J25,0)","v":0},{"$f":"IF(F25>0,\"£\",\"\")","v":""},{"$f":"IF($D$7<>0,Salaries!$AH24*F7/$D$7,0)","v":0},null,{"$f":"IF($D$7<>0,Salaries!$AH24*H7/$D$7,0)","v":0},null,{"$f":"IF($D$7<>0,Salaries!$AH24*J7/$D$7,0)","v":0},null,null,{"$f":"IF(F$7>0,ROUND(F25/F$7/52*IF(F$8-F$10=0,1,100/(F$8-F$10)),M$1),0)","v":0},null,{"$f":"IF(H$7>0,ROUND(H25/H$7/52*IF(H$8-H$10=0,1,100/(H$8-H$10)),O$1),0)","v":0},null,{"$f":"IF(J$7>0,ROUND(J25/J$7/52*IF(J$8-J$10=0,1,100/(J$8-J$10)),Q$1),0)","v":0}]
[null,"Window cleaning","",{"$f":"IF(F$7>0,F26,0)+IF(H$7>0,H26,0)+IF(J$7>0,J26,0)","v":0},{"$f":"IF(F26>0,\"£\",\"\")","v":""},null,null,null,null,null,null,null,0,null,0,null,0]
[null,"Deep cleaning","",0,"",null,null,null,null,null,null,null,0,null,0,null,0]
[null,"Gardening (communal)","",0,"",null,null,null,null,null,null,null,0,null,0,null,0]
[null,"Grounds maintenance","",0,"",null,null,null,null,null,null,null,0,null,0,null,0]
[null,"Caretaking","",0,"",null,null,null,null,null,null,null,0,null,0,null,0]
[null,"Rubbish clearance / removal","",0,"",null,null,null,null,null,null,null,0,null,0,null,0]
[null,"Bulk waste disposal","",0,"",null,null,null,null,null,null,null,0,null,0,null,0]
[null,"Sanitary waste removal","",0,"",null,null,null,null,null,null,null,0,null,0,null,0]
[null,"Pest control","",0,"",null,null,null,null,null,null,null,0,null,0,null,0]
[null,"FIRE / HEALTH & SAFETY"]
[null,"Legionella testing & treatment","",{"$f":"IF(F$7>0,F36,0)+IF(H$7>0,H36,0)+IF(J$7>0,J36,0)","v":0},{"$f":"IF(F36>0,\"£\",\"\")","v":""},null,null,null,null,null,null,null,{"$f":"IF(F$7>0,ROUND(F36/F$7/52*IF(F$8-F$9=0,1,100/(F$8-F$9)),M$1),0)","v":0},null,{"$f":"IF(H$7>0,ROUND(H36/H$7/52*IF(H$8-H$9=0,1,100/(H$8-H$9)),O$1),0)","v":0},null,{"$f":"IF(J$7>0,ROUND(J36/J$7/52*IF(J$8-J$9=0,1,100/(J$8-J$9)),Q$1),0)","v":0}]
[null,"Portable appliance testing","",0,"",null,null,null,null,null,null,null,0,null,0,null,0]
[null,"Fixed appliance testing","",0,"",null,null,null,null,null,null,null,0,null,0,null,0]
[null,"Smoke alarms","",0,"",null,null,null,null,null,null,null,0,null,0,null,0]
[null,"Fire detection equipment","",0,""]
[null,"Provision / replacement / depreciaton","",0,"",null,null,null,null,null,null,null,{"$f":"IF(F$7>0,ROUND(F41/F$7/52*IF(F$8-F$9=0,1,100/(F$8-F$9)),M$1),0)","v":0},null,{"$f":"IF(H$7>0,ROUND(H41/H$7/52*IF(H$8-H$9=0,1,100/(H$8-H$9)),O$1),0)","v":0},null,{"$f":"IF(J$7>0,ROUND(J41/J$7/52*IF(J$8-J$9=0,1,100/(J$8-J$9)),Q$1),0)","v":0}]
[null,"Maintenance & servicing","",0,"",null,null,null,null,null,null,null,{"$f":"IF(F$7>0,ROUND(F42/F$7/52*IF(F$8-F$9=0,1,100/(F$8-F$9)),M$1),0)","v":0},null,{"$f":"IF(H$7>0,ROUND(H42/H$7/52*IF(H$8-H$9=0,1,100/(H$8-H$9)),O$1),0)","v":0},null,{"$f":"IF(J$7>0,ROUND(J42/J$7/52*IF(J$8-J$9=0,1,100/(J$8-J$9)),Q$1),0)","v":0}]
[null,"Fire fighting equipment","",0,""]
[null,"Provision / replacement / depreciaton","",0,"",null,null,null,null,null,null,null,{"$f":"IF(F$7>0,ROUND(F44/F$7/52*IF(F$8-F$9=0,1,100/(F$8-F$9)),M$1),0)","v":0},null,{"$f":"IF(H$7>0,ROUND(H44/H$7/52*IF(H$8-H$9=0,1,100/(H$8-H$9)),O$1),0)","v":0},null,{"$f":"IF(J$7>0,ROUND(J44/J$7/52*IF(J$8-J$9=0,1,100/(J$8-J$9)),Q$1),0)","v":0}]
[null,"Maintenance & servicing","",0,"",null,null,null,null,null,null,null,0,null,0,null,0]
[null,"Other health & safety","",0,"",null,null,null,null,null,null,null,0,null,0,null,0]
[null,"FURNITURE & EQUIPMENT"]
[null,"Furniture & equipment (common parts)","",{"$f":"IF(F$7>0,F48,0)+IF(H$7>0,H48,0)+IF(J$7>0,J48,0)","v":0},{"$f":"IF(F48>0,\"£\",\"\")","v":""},null,null,null,null,null,null,null,{"$f":"IF(F$7>0,ROUND(F48/F$7/52*IF(F$8-F$9=0,1,100/(F$8-F$9)),M$1),0)","v":0},null,{"$f":"IF(H$7>0,ROUND(H48/H$7/52*IF(H$8-H$9=0,1,100/(H$8-H$9)),O$1),0)","v":0},null,{"$f":"IF(J$7>0,ROUND(J48/J$7/52*IF(J$8-J$9=0,1,100/(J$8-J$9)),Q$1),0)","v":0}]
[null,"Furniture & equipment (residents)","",0,"",null,null,null,null,null,null,null,0,null,0,null,0]
[null,"Kitchen equipment / white goods","",0,"",null,null,null,null,null,null,null,0,null,0,null,0]
[null,"Laundry equipment","",0,"",null,null,null,null,null,null,null,0,null,0,null,0]
[null,"Lift replacement","",0,"",null,null,null,null,null,null,null,0,null,0,null,0]
[null,"Lift servicing / maintenance","",0,"",null,null,null,null,null,null,null,0,null,0,null,0]
[null,"Aerials","",0,"",null,null,null,null,null,null,null,0,null,0,null,0]
[null,"Carpets and curtains","",0,"",null,null,null,null,null,null,null,0,null,0,null,0]
[null,"Renewals and replacements","",0,"",null,null,null,null,null,null,null,0,null,0,null,0]
[null,"Contents insurance","",0,"",null,null,null,null,null,null,null,0,null,0,null,0]
[null,"SECURITY"]
[null,"Security contracts","",{"$f":"IF(F$7>0,F59,0)+IF(H$7>0,H59,0)+IF(J$7>0,J59,0)","v":0},{"$f":"IF(F59>0,\"£\",\"\")","v":""},null,null,null,null,null,null,null,{"$f":"IF(F$7>0,ROUND(F59/F$7/52*IF(F$8-F$9=0,1,100/(F$8-F$9)),M$1),0)","v":0},null,{"$f":"IF(H$7>0,ROUND(H59/H$7/52*IF(H$8-H$9=0,1,100/(H$8-H$9)),O$1),0)","v":0},null,{"$f":"IF(J$7>0,ROUND(J59/J$7/52*IF(J$8-J$9=0,1,100/(J$8-J$9)),Q$1),0)","v":0}]
[null,"Security staff (from salaries schedule)","",0,"",{"$f":"IF($D$7<>0,Salaries!$AF24*F7/$D$7,0)","v":0},null,{"$f":"IF($D$7<>0,Salaries!$AF24*H7/$D$7,0)","v":0},null,{"$f":"IF($D$7<>0,Salaries!$AF24*J7/$D$7,0)","v":0},null,null,{"$f":"IF(F$7>0,ROUND(F60/F$7/52*IF(F$8-F$9=0,1,100/(F$8-F$9)),M$1),0)","v":0},null,0,null,0]
[null,"Door entry system","",0,"",null,null,null,null,null,null,null,0,null,0,null,0]
[null,"CCTV","",0,"",null,null,null,null,null,null,null,0,null,0,null,0]
[null,"Other security","",0,"",null,null,null,null,null,null,null,0,null,0,null,0]
[null,"COMMUNAL FACILITIES"]
[null,"Redecoration of communal facilities","",{"$f":"IF(F$7>0,F65,0)+IF(H$7>0,H65,0)+IF(J$7>0,J65,0)","v":0},{"$f":"IF(F65>0,\"£\",\"\")","v":""},null,null,null,null,null,null,null,{"$f":"IF(F$7>0,ROUND(F65/F$7/52*IF(F$8-F$9=0,1,100/(F$8-F$9)),M$1),0)","v":0},null,{"$f":"IF(H$7>0,ROUND(H65/H$7/52*IF(H$8-H$9=0,1,100/(H$8-H$9)),O$1),0)","v":0},null,{"$f":"IF(J$7>0,ROUND(J65/J$7/52*IF(J$8-J$9=0,1,100/(J$8-J$9)),Q$1),0)","v":0}]
[null,"Repairs & maint (communal facilities)","",0,"",null,null,null,null,null,null,null,0,null,0,null,0]
[null,"Other","",0,"",null,null,null,null,null,null,null,0,null,0,null,0]
[null,"FOOD / CATERING","Food/ catering page"]
[null,"HB-eligible element",null,{"$f":"SUM(F69,H69,J69)","v":0},null,{"$f":"Food!F20","v":0},null,{"$f":"Food!H20","v":0},null,{"$f":"Food!J20","v":0},null,null,{"$f":"Food!F37","v":0},null,{"$f":"Food!H37","v":0},null,{"$f":"Food!J37","v":0}]
[null,"HB-ineligible element",null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Food!F30:F31)","v":0},null,{"$f":"SUM(Food!H30:H31)","v":0},null,{"$f":"SUM(Food!J30:J31)","v":0}]
[]
[null,"SUB-TOTAL DIRECT COSTS",null,{"$f":"IF(D7>0,SUM(D69,D65:D67,D59:D63,D48:D57,D44:D46,D41:D42,D36:D39,D21:D34,D14:D19),0)","v":0},null,{"$f":"IF(F7>0,SUM(F69,F65:F67,F59:F63,F48:F57,F44:F46,F41:F42,F36:F39,F21:F34,F14:F19),0)","v":0},null,{"$f":"IF(H7>0,SUM(H69,H65:H67,H59:H63,H48:H57,H44:H46,H41:H42,H36:H39,H21:H34,H14:H19),0)","v":0},null,{"$f":"IF(J7>0,SUM(J69,J65:J67,J59:J63,J48:J57,J44:J46,J41:J42,J36:J39,J21:J34,J14:J19),0)","v":0},null,null,{"$f":"SUM(M69:M70,M65:M67,M59:M63,M48:M57,M44:M46,M41:M42,M36:M39,M21:M34,M14:M19)","v":0},null,{"$f":"SUM(O69:O70,O65:O67,O59:O63,O48:O57,O44:O46,O41:O42,O36:O39,O21:O34,O14:O19)","v":0},null,{"$f":"SUM(Q69:Q70,Q65:Q67,Q59:Q63,Q48:Q57,Q44:Q46,Q41:Q42,Q36:Q39,Q21:Q34,Q14:Q19)","v":0}]
[]
[null,"SUB-TOTAL DIRECT COSTS: HB-ELIGIBLE",null,{"$f":"SUM(F74,H74,J74)","v":0},null,{"$f":"F69-IF(SUM(Food!F35,Food!F41)<>0,ROUND(Food!F20*Food!F35/SUM(Food!F35,Food!F41),2),0)+SUM(F65:F67,F59:F63,F48:F57,F44:F46,F41:F42,F36:F39,F21:F24,F26:F34,F18,F16,F14)","v":0},null,{"$f":"H69-IF(SUM(Food!H35,Food!H41)<>0,ROUND(Food!H20*Food!H35/SUM(Food!H35,Food!H41),2),0)+SUM(H65:H67,H59:H63,H48:H57,H44:H46,H41:H42,H36:H39,H21:H24,H26:H34,H18,H16,H14)","v":0},null,{"$f":"J69-IF(SUM(Food!J35,Food!J41)<>0,ROUND(Food!J20*Food!J35/SUM(Food!J35,Food!J41),2),0)+SUM(J65:J67,J59:J63,J48:J57,J44:J46,J41:J42,J36:J39,J21:J24,J26:J34,J18,J16,J14)","v":0},null,null,{"$f":"SUM(M69,M65:M67,M59:M63,M48:M57,M44:M46,M41:M42,M36:M39,M21:M24,M26:M34,M18,M16,M14)","v":0},null,{"$f":"SUM(O69,O65:O67,O59:O63,O48:O57,O44:O46,O41:O42,O36:O39,O21:O24,O26:O34,O18,O16,O14)","v":0},null,{"$f":"SUM(Q69,Q65:Q67,Q59:Q63,Q48:Q57,Q44:Q46,Q41:Q42,Q36:Q39,Q21:Q24,Q26:Q34,Q18,Q16,Q14)","v":0}]
[null,"SUB-TOTAL DIRECT COSTS: HB INELIGIBLE",null,0,null,{"$f":"IF(SUM(Food!F35,Food!F41)<>0,ROUND(Food!F20*Food!F35/SUM(Food!F35,Food!F41),2),0)+SUM(F25,F19,F17,F15)","v":0},null,{"$f":"IF(SUM(Food!H35,Food!H41)<>0,ROUND(Food!H20*Food!H35/SUM(Food!H35,Food!H41),2),0)+SUM(H25,H19,H17,H15)","v":0},null,{"$f":"IF(SUM(Food!J35,Food!J41)<>0,ROUND(Food!J20*Food!J35/SUM(Food!J35,Food!J41),2),0)+SUM(J25,J19,J17,J15)","v":0},null,null,{"$f":"SUM(M70,M19,M17,M15,M25)","v":0},null,{"$f":"SUM(O70,O19,O17,O15,O25)","v":0},null,{"$f":"SUM(Q70,Q19,Q17,Q15,Q25)","v":0}]
[null,null,null,{"$f":"SUM(D74:D75)","v":0},null,{"$f":"SUM(F74:F75)","v":0},null,{"$f":"SUM(H74:H75)","v":0},null,{"$f":"SUM(J74:J75)","v":0},null,null,{"$f":"SUM(M74:M75)","v":0},null,{"$f":"SUM(O74:O75)","v":0},null,{"$f":"SUM(Q74:Q75)","v":0}]
[null,"Services admin"]
[null,"HB-eligible",null,15,"%",{"$f":"IF(F7>0,F74*$D78/100,0)","v":0},null,{"$f":"IF(H7>0,H74*$D78/100,0)","v":0},null,{"$f":"IF(J7>0,J74*$D78/100,0)","v":0},null,null,{"$f":"IF(F$7>0,ROUND(F78/F$7/52*IF(F$8-F$9=0,1,100/(F$8-F$9)),M$1),0)","v":0},null,{"$f":"IF(H$7>0,ROUND(H78/H$7/52*IF(H$8-H$9=0,1,100/(H$8-H$9)),O$1),0)","v":0},null,{"$f":"IF(J$7>0,ROUND(J78/J$7/52*IF(J$8-J$9=0,1,100/(J$8-J$9)),Q$1),0)","v":0}]
[null,"HB-ineligible (excl food)",null,5,"%",{"$f":"IF(F7>0,SUM(F15,F17,F19,F25)*$D79/100,0)","v":0},null,{"$f":"IF(H7>0,SUM(H15,H17,H19,H25)*$D79/100,0)","v":0},null,{"$f":"IF(J7>0,SUM(J15,J17,J19,J25)*$D79/100,0)","v":0},null,null,{"$f":"IF(F$7>0,ROUND(F79/F$7/52*IF(F$8-F$10=0,1,100/(F$8-F$10)),M$1),0)","v":0},null,{"$f":"IF(H$7>0,ROUND(H79/H$7/52*IF(H$8-H$10=0,1,100/(H$8-H$10)),O$1),0)","v":0},null,{"$f":"IF(J$7>0,ROUND(J79/J$7/52*IF(J$8-J$10=0,1,100/(J$8-J$10)),Q$1),0)","v":0}]
[null,null,null,{"$f":"SUM(F80,H80,J80)","v":0},null,{"$f":"SUM(F78:F79)","v":0},null,{"$f":"SUM(H78:H79)","v":0},null,{"$f":"SUM(J78:J79)","v":0},null,null,{"$f":"SUM(M78:M79)","v":0},null,{"$f":"SUM(O78:O79)","v":0},null,{"$f":"SUM(Q78:Q79)","v":0}]
[null,"TOTAL"]
[null,"HB-eligible",null,{"$f":"IF(F$7>0,F82,0)+IF(H$7>0,H82,0)+IF(J$7>0,J82,0)","v":0},null,{"$f":"SUM(F78,F74)","v":0},null,{"$f":"SUM(H78,H74)","v":0},null,{"$f":"SUM(J78,J74)","v":0},null,null,{"$f":"SUM(M74,M78)","v":0},null,{"$f":"SUM(O74,O78)","v":0},null,{"$f":"SUM(Q74,Q78)","v":0}]
[null,"HB-ineligible (excl food)",null,0,null,{"$f":"SUM(F75,F79)","v":0},null,{"$f":"SUM(H75,H79)","v":0},null,{"$f":"SUM(J75,J79)","v":0},null,null,{"$f":"SUM(M75,M79)","v":0},null,{"$f":"SUM(O75,O79)","v":0},null,{"$f":"SUM(Q75,Q79)","v":0}]
[null,null,null,{"$f":"SUM(D82:D83)","v":0},null,{"$f":"SUM(F82:F83)","v":0},null,{"$f":"SUM(H82:H83)","v":0},null,{"$f":"SUM(J82:J83)","v":0},null,null,{"$f":"SUM(M82:M83)","v":0},null,{"$f":"SUM(O82:O83)","v":0},null,{"$f":"SUM(Q82:Q83)","v":0}]
[]
[null,"Income reconciliation"]
[null,"HB-eligible charges receivable",null,{"$f":"SUM(F87,H87,J87)","v":0},null,{"$f":"F7*M82*52","v":0},null,{"$f":"H7*O82*52","v":0},null,{"$f":"J7*Q82*52","v":0}]
[null,"Less"]
[null,"Voids",null,{"$f":"SUM(F89,H89,J89)","v":0},null,{"$f":"-F87*(100-F8)/100","v":0},null,{"$f":"-H87*(100-H8)/100","v":0},null,{"$f":"-J87*(100-J8)/100","v":0}]
[null,"Bad debts",null,0,null,{"$f":"-F87*F9/100","v":0},null,{"$f":"-H87*H9/100","v":0},null,{"$f":"-J87*J9/100","v":0}]
[null,null,null,{"$f":"SUM(D87:D90)","v":0},null,{"$f":"SUM(F87:F90)","v":0},null,{"$f":"SUM(H87:H90)","v":0},null,{"$f":"SUM(J87:J90)","v":0}]
[]
[null,"HB-ineligible charges receivable",null,{"$f":"SUM(F93,H93,J93)","v":0},null,{"$f":"F7*M83*52","v":0},null,{"$f":"H7*O83*52","v":0},null,{"$f":"J7*Q83*52","v":0}]
[null,"Less"]
[null,"Voids",null,{"$f":"SUM(F95,H95,J95)","v":0},null,{"$f":"-F93*(100-F8)/100","v":0},null,{"$f":"-H93*(100-H8)/100","v":0},null,{"$f":"-J93*(100-J8)/100","v":0}]
[null,"Bad debts",null,0,null,{"$f":"-F93*F10/100","v":0},null,{"$f":"-H93*H10/100","v":0},null,{"$f":"-J93*J10/100","v":0}]
[null,null,null,{"$f":"SUM(D93:D96)","v":0},null,{"$f":"SUM(F93:F96)","v":0},null,{"$f":"SUM(H93:H96)","v":0},null,{"$f":"SUM(J93:J96)","v":0}]
[]
[]
[null,null,null,null,null,{"$f":"ROUND(F91-F82,2)","v":0},null,{"$f":"ROUND(H91-H82,2)","v":0},null,{"$f":"ROUND(J91-J82,2)","v":0}]
[null,null,null,null,null,{"$f":"ROUND(F97-F83,2)","v":0},null,{"$f":"ROUND(H97-H83,2)","v":0},null,{"$f":"ROUND(J97-J83,2)","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Other payment to property owner","£",{"$f":"IF(F$7>0,F112,0)+IF(H$7>0,H112,0)+IF(J$7>0,J112,0)","v":0},"£",{"$f":"2*5*52","v":520},"£",null,"£",234,null,null,{"$f":"IF(F$7>0,ROUND(F112/F$7/52*IF(F$8-F$9=0,1,100/(F$8-F$9)),M$1),0)","v":0},null,{"$f":"IF(H$7>0,ROUND(H112/H$7/52*IF(H$8-H$9=0,1,100/(H$8-H$9)),O$1),0)","v":0},null,{"$f":"IF(J$7>0,ROUND(J112/J$7/52*IF(J$8-J$9=0,1,100/(J$8-J$9)),Q$1),0)","v":0}]
[null,"Property insurance","£",0,"£",null,"£",null,"£",null,null,null,0,null,0,null,0]
[null,"Other estate costs","£",0,"£",null,"£",null,"£",null,null,null,0,null,0,null,0]
[null,"Loan charges","£",0,"£",null,"£",null,"£",null,null,null,0,null,0,null,0]
[null,"Repairs and maintenance"]
[null,"Routine / response maintenance","£",{"$f":"IF(F$7>0,F117,0)+IF(H$7>0,H117,0)+IF(J$7>0,J117,0)","v":0},"£",10000,"£",null,"£",null,null,null,{"$f":"IF(F$7>0,ROUND(F117/F$7/52*IF(F$8-F$9=0,1,100/(F$8-F$9)),M$1),0)","v":0},null,{"$f":"IF(H$7>0,ROUND(H117/H$7/52*IF(H$8-H$9=0,1,100/(H$8-H$9)),O$1),0)","v":0},null,{"$f":"IF(J$7>0,ROUND(J117/J$7/52*IF(J$8-J$9=0,1,100/(J$8-J$9)),Q$1),0)","v":0}]
[null,"Boiler / heating system maintenance","£",0,"£",1000,"£",null,"£",null,null,null,0,null,0,null,0]
[null,"Void maintenance","£",0,"£",4000,"£",null,"£",null,null,null,0,null,0,null,0]
[null,"Cyclical maintenance provision","£",0,"£",0,"£",null,"£",4567,null,null,0,null,0,null,0]
[null,"Major repairs / dilapidations provision","£",0,"£",0,"£",null,"£",null,null,null,0,null,0,null,0]
[null,"Electrical safety certification","£",0,"£",0,"£",null,"£",null,null,null,0,null,0,null,0]
[null,"Gas safety certification","£",0,"£",0,"£",null,"£",null,null,null,0,null,0,null,0]
[null,"Electrical safety certification","£",0,"£",0,"£",null,"£",null,null,null,0,null,0,null,0]
[null,"Other certifications","£",0,"£",0,"£",null,"£",null,null,null,0,null,0,null,0]
[null,"Other certifications","£",0,"£",0,"£",null,"£",null,null,null,0,null,0,null,0]
[]
[null,"Basic property management"]
[null,"Central / area teams"]
[null,"Rent accounting / arrears  control","£",{"$f":"IF(F$7>0,F130,0)+IF(H$7>0,H130,0)+IF(J$7>0,J130,0)","v":0},"£",2500,"£",1234,"£",null,null,null,{"$f":"IF(F$7>0,ROUND(F130/F$7/52*IF(F$8-F$9=0,1,100/(F$8-F$9)),M$1),0)","v":0},null,{"$f":"IF(H$7>0,ROUND(H130/H$7/52*IF(H$8-H$9=0,1,100/(H$8-H$9)),O$1),0)","v":0},null,{"$f":"IF(J$7>0,ROUND(J130/J$7/52*IF(J$8-J$9=0,1,100/(J$8-J$9)),Q$1),0)","v":0}]
[null,"Other core management functions","£",0,"£",3000,"£",3456,"£",null,null,null,0,null,0,null,0]
[null,"Project team (from staff team page)","£",{"$f":"Salaries!H26","v":0},"£",{"$f":"IF($D$7<>0,$D132*F7/$D$7,0)","v":0},"£",{"$f":"IF($D$7<>0,$D132*H7/$D$7,0)","v":0},"£",{"$f":"IF($D$7<>0,$D132*J7/$D$7,0)","v":0},null,null,0,null,0,null,0]
[]
[null,"Overheads charged to core rent"]
[null,"HR","£",500,"£",{"$f":"IF($D$7<>0,$D135*F$7/$D$7,0)","v":0},"£",{"$f":"IF($D$7<>0,$D135*H$7/$D$7,0)","v":0},"£",{"$f":"IF($D$7<>0,$D135*J$7/$D$7,0)","v":0},null,null,{"$f":"IF(F$7>0,ROUND(F135/F$7/52*IF(F$8-F$9=0,1,100/(F$8-F$9)),M$1),0)","v":0},null,{"$f":"IF(H$7>0,ROUND(H135/H$7/52*IF(H$8-H$9=0,1,100/(H$8-H$9)),O$1),0)","v":0},null,{"$f":"IF(J$7>0,ROUND(J135/J$7/52*IF(J$8-J$9=0,1,100/(J$8-J$9)),Q$1),0)","v":0}]
[null,"Finance","£",1500,"£",{"$f":"IF($D$7<>0,$D136*F$7/$D$7,0)","v":0},"£",0,"£",0,null,null,0,null,0,null,0]
[null,"Directorate","£",350,"£",0,"£",0,"£",0,null,null,0,null,0,null,0]
[null,"IT","£",1500,"£",0,"£",0,"£",0,null,null,0,null,0,null,0]
[null,"Central office admin","£",1500,"£",0,"£",0,"£",0,null,null,0,null,0,null,0]
[null,"Total / cost rent",null,null,"£",{"$f":"IF(F7>0,SUM(F14:F115,F117:F126,F130:F132,F135:F139),0)","v":0},"£",{"$f":"IF(H7>0,SUM(H14:H115,H117:H126,H130:H132,H135:H139),0)","v":0},"£",{"$f":"IF(J7>0,SUM(J14:J115,J117:J126,J130:J132,J135:J139),0)","v":0},null,null,{"$f":"SUM(M14:M115,M117:M126,M130:M132,M135:M139)","v":0},null,{"$f":"SUM(O14:O115,O117:O126,O130:O132,O135:O139)","v":0},null,{"$f":"SUM(Q14:Q115,Q117:Q126,Q130:Q132,Q135:Q139)","v":0}]
[]
[]
[]
[null,"Income"]
[null,"Cost rent receivable",null,null,null,{"$f":"F7*M140*52","v":0},null,{"$f":"H7*O140*52","v":0},null,{"$f":"J7*Q140*52","v":0}]
[null,"Less voids",null,null,null,{"$f":"-F145*(100-F8)/100","v":0},null,{"$f":"-H145*(100-H8)/100","v":0},null,{"$f":"-J145*(100-J8)/100","v":0}]
[null,null,null,null,null,{"$f":"SUM(F145:F146)","v":0},null,{"$f":"SUM(H145:H146)","v":0},null,{"$f":"SUM(J145:J146)","v":0}]
[null,"Expenditure"]
[null,"Bad debts",null,null,null,{"$f":"F145*F9/100","v":0},null,{"$f":"H145*H9/100","v":0},null,{"$f":"J145*J9/100","v":0}]
[null,"Property costs",null,"Charge rounding",null,{"$f":"F140","v":0},null,{"$f":"H140","v":0},null,{"$f":"J140","v":0}]
[null,"Rounding (dec points)",null,5,null,{"$f":"ROUND(F147-SUM(F149:F150),2)","v":0},null,{"$f":"ROUND(H147-SUM(H149:H150),2)","v":0},null,{"$f":"ROUND(J147-SUM(J149:J150),2)","v":0}]
[null,null,null,null,null,{"$f":"SUM(F149:F151)","v":0},null,{"$f":"SUM(H149:H151)","v":0},null,{"$f":"SUM(J149:J151)","v":0}]
[]
[null,null,null,null,null,{"$f":"ROUND(F147-F152,2)","v":0},null,{"$f":"ROUND(H147-H152,2)","v":0},null,{"$f":"ROUND(J147-J152,2)","v":0}]

{"sheet":"Out of hrs","index":7,"n_rows":23,"n_cols":4,"rows_kept":23,"cut":false,"hidden":true,"merged":[[20,1,20,3],[22,1,22,3]]}
[]
[null,{"$f":"IF(Menu!B3<>\"\",Menu!B3,\"\")","v":""}]
[]
[null,"Out-of-hours cover"]
[]
[null,"On-call"]
[null,"(Not included in salaries)"]
[null,"Charge to care support & supervision"]
[null,"Charge to enhanced management (HB-eligible)"]
[null,null,null,{"$f":"SUM(D8:D9)","v":0}]
[null,"Sleep-in"]
[null,"(Not included in salaries)"]
[null,"Charge to care support & supervision"]
[null,"Charge to enhanced management (HB-eligible)"]
[null,null,null,{"$f":"SUM(D13:D14)","v":0}]
[null,"Costs, in addition to  items below "]
[null,"Charge to care support & supervision",null,{"$f":"SUM(D13,D8)","v":0}]
[null,"Charge to enhanced management (HB-eligible)",null,{"$f":"SUM(D9,D14)","v":0}]
[null,null,null,{"$f":"SUM(D17:D18)","v":0}]
[]
[null,"Security contracts / staff are included in HB-eligible services"]
[null,"Out of hours salaries may also be included as \"enhanced management\""]
[null,"Out of hours salaries may also be included in care support & supervision"]

{"sheet":"Prop","index":8,"n_rows":57,"n_cols":17,"rows_kept":57,"cut":false,"hidden":true,"merged":[]}
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"D54","v":6},null,{"$f":"M1","v":6},null,{"$f":"M1","v":6}]
[]
[null,{"$f":"IF(Menu!$B$3<>\"\",Menu!$B$3,\"\")","v":""},null,null,null,"Unit",null,"Unit",null,"Unit",null,null,"Unit",null,"Unit",null,"Unit"]
[null,"PROPERTY COST",null,null,null,"type 1",null,"type 2",null,"type 3",null,null,"type 1",null,"type 2",null,"type 3"]
[null,null,null,"Total",null,{"$f":"'M1'!C12","v":"Bedsit/room"},null,{"$f":"'M1'!F12","v":"1-bed"},null,{"$f":"'M1'!I12","v":"1-bed"}]
[null,"Number of units",null,{"$f":"SUM(F6:J6)","v":0},null,{"$f":"'M1'!C8","v":0},null,{"$f":"'M1'!F8","v":0},null,{"$f":"'M1'!I8","v":0}]
[null,"Budgeted occupancy (see units page)",null,null,null,{"$f":"IF(F6>0,'M1'!C10,0)","v":0},"%",{"$f":"IF(H6>0,'M1'!F10,0)","v":0},"%",{"$f":"IF(J6>0,'M1'!I10,0)","v":0},"%"]
[null,"Budgeted bad debts (core rent)",null,null,null,2,"%",2,"%",2,"%"]
[]
[null,"Annual budget"]
[null,"Property costs"]
[null,"Lease charges","£",{"$f":"IF(F$6>0,F12,0)+IF(H$6>0,H12,0)+IF(J$6>0,J12,0)","v":0},"£",null,"£",null,"£",null,null,null,{"$f":"IF(F$6>0,ROUND(F12/F$6/52*IF(F$7-F$8=0,1,100/(F$7-F$8)),M$1),0)","v":0},null,{"$f":"IF(H$6>0,ROUND(H12/H$6/52*IF(H$7-H$8=0,1,100/(H$7-H$8)),O$1),0)","v":0},null,{"$f":"IF(J$6>0,ROUND(J12/J$6/52*IF(J$7-J$8=0,1,100/(J$7-J$8)),Q$1),0)","v":0}]
[null,"Other payment to property owner","£",{"$f":"IF(F$6>0,F13,0)+IF(H$6>0,H13,0)+IF(J$6>0,J13,0)","v":0},"£",null,"£",null,"£",null,null,null,{"$f":"IF(F$6>0,ROUND(F13/F$6/52*IF(F$7-F$8=0,1,100/(F$7-F$8)),M$1),0)","v":0},null,{"$f":"IF(H$6>0,ROUND(H13/H$6/52*IF(H$7-H$8=0,1,100/(H$7-H$8)),O$1),0)","v":0},null,{"$f":"IF(J$6>0,ROUND(J13/J$6/52*IF(J$7-J$8=0,1,100/(J$7-J$8)),Q$1),0)","v":0}]
[null,"Property insurance","£",0,"£",null,"£",null,"£",null,null,null,0,null,0,null,0]
[null,"Other estate costs","£",{"$f":"IF(F$6>0,F15,0)+IF(H$6>0,H15,0)+IF(J$6>0,J15,0)","v":0},"£",null,"£",null,"£",null,null,null,0,null,0,null,0]
[null,"Loan charges","£",{"$f":"IF(F$6>0,F16,0)+IF(H$6>0,H16,0)+IF(J$6>0,J16,0)","v":0},"£",null,"£",null,"£",null,null,null,0,null,0,null,0]
[null,"Council tax on void units","£",0,"£",{"$f":"CT!F18","v":0},null,{"$f":"CT!H18","v":0},null,{"$f":"CT!J18","v":0},null,null,{"$f":"IF(F$6>0,ROUND(F17/F$6/52*IF(F$7-F$8=0,1,100/(F$7-F$8)),M$1),0)","v":0},null,{"$f":"IF(H$6>0,ROUND(H17/H$6/52*IF(H$7-H$8=0,1,100/(H$7-H$8)),O$1),0)","v":0},null,{"$f":"IF(J$6>0,ROUND(J17/J$6/52*IF(J$7-J$8=0,1,100/(J$7-J$8)),Q$1),0)","v":0}]
[null,"Repairs and maintenance"]
[null,"Routine / response maintenance","£",{"$f":"IF(F$6>0,F19,0)+IF(H$6>0,H19,0)+IF(J$6>0,J19,0)","v":0},"£",null,"£",null,"£",null,null,null,{"$f":"IF(F$6>0,ROUND(F19/F$6/52*IF(F$7-F$8=0,1,100/(F$7-F$8)),M$1),0)","v":0},null,{"$f":"IF(H$6>0,ROUND(H19/H$6/52*IF(H$7-H$8=0,1,100/(H$7-H$8)),O$1),0)","v":0},null,{"$f":"IF(J$6>0,ROUND(J19/J$6/52*IF(J$7-J$8=0,1,100/(J$7-J$8)),Q$1),0)","v":0}]
[null,"Boiler / heating system maintenance","£",{"$f":"IF(F$6>0,F20,0)+IF(H$6>0,H20,0)+IF(J$6>0,J20,0)","v":0},"£",null,"£",null,"£",null,null,null,0,null,0,null,0]
[null,"Void maintenance","£",{"$f":"IF(F$6>0,F21,0)+IF(H$6>0,H21,0)+IF(J$6>0,J21,0)","v":0},"£",null,"£",null,"£",null,null,null,0,null,0,null,0]
[null,"Cyclical maintenance provision","£",{"$f":"IF(F$6>0,F22,0)+IF(H$6>0,H22,0)+IF(J$6>0,J22,0)","v":0},"£",null,"£",null,"£",null,null,null,0,null,0,null,0]
[null,"Major repairs / dilapidations provision","£",0,"£",null,"£",null,"£",null,null,null,0,null,0,null,0]
[null,"Electrical safety certification","£",{"$f":"IF(F$6>0,F24,0)+IF(H$6>0,H24,0)+IF(J$6>0,J24,0)","v":0},"£",null,"£",null,"£",null,null,null,0,null,0,null,0]
[null,"Gas safety certification","£",0,"£",null,"£",null,"£",null,null,null,0,null,0,null,0]
[null,"Electrical safety certification","£",{"$f":"IF(F$6>0,F26,0)+IF(H$6>0,H26,0)+IF(J$6>0,J26,0)","v":0},"£",null,"£",null,"£",null,null,null,0,null,0,null,0]
[null,"Other certifications","£",{"$f":"IF(F$6>0,F27,0)+IF(H$6>0,H27,0)+IF(J$6>0,J27,0)","v":0},"£",null,"£",null,"£",null,null,null,0,null,0,null,0]
[null,"Other certifications","£",0,"£",null,"£",null,"£",null,null,null,0,null,0,null,0]
[null,"Project team (from staff team page)","£",{"$f":"Salaries!H27","v":0},"£",{"$f":"IF($D$6<>0,$D29*F$6/$D$6,0)","v":0},"£",{"$f":"IF($D$6<>0,$D29*H$6/$D$6,0)","v":0},"£",{"$f":"IF($D$6<>0,$D29*J$6/$D$6,0)","v":0},null,null,0,null,0,null,0]
[]
[null,"Basic property management"]
[null,"Central / area teams"]
[null,"Rent accounting / arrears  control","£",{"$f":"IF(F$6>0,F33,0)+IF(H$6>0,H33,0)+IF(J$6>0,J33,0)","v":0},"£",null,"£",null,"£",null,null,null,{"$f":"IF(F$6>0,ROUND(F33/F$6/52*IF(F$7-F$8=0,1,100/(F$7-F$8)),M$1),0)","v":0},null,{"$f":"IF(H$6>0,ROUND(H33/H$6/52*IF(H$7-H$8=0,1,100/(H$7-H$8)),O$1),0)","v":0},null,{"$f":"IF(J$6>0,ROUND(J33/J$6/52*IF(J$7-J$8=0,1,100/(J$7-J$8)),Q$1),0)","v":0}]
[null,"Other core management functions","£",{"$f":"IF(F$6>0,F34,0)+IF(H$6>0,H34,0)+IF(J$6>0,J34,0)","v":0},"£",null,"£",null,"£",null,null,null,0,null,0,null,0]
[null,"Project team (from staff team page)","£",{"$f":"Salaries!H26","v":0},"£",{"$f":"IF($D$6<>0,$D35*F$6/$D$6,0)","v":0},"£",{"$f":"IF($D$6<>0,$D35*H$6/$D$6,0)","v":0},"£",{"$f":"IF($D$6<>0,$D35*J$6/$D$6,0)","v":0},null,null,0,null,0,null,0]
[]
[null,"Overheads charged to core rent"]
[null,"HR","£",null,"£",{"$f":"IF($D$6<>0,$D38*F$6/$D$6,0)","v":0},"£",{"$f":"IF($D$6<>0,$D38*H$6/$D$6,0)","v":0},"£",{"$f":"IF($D$6<>0,$D38*J$6/$D$6,0)","v":0},null,null,{"$f":"IF(F$6>0,ROUND(F38/F$6/52*IF(F$7-F$8=0,1,100/(F$7-F$8)),M$1),0)","v":0},null,{"$f":"IF(H$6>0,ROUND(H38/H$6/52*IF(H$7-H$8=0,1,100/(H$7-H$8)),O$1),0)","v":0},null,{"$f":"IF(J$6>0,ROUND(J38/J$6/52*IF(J$7-J$8=0,1,100/(J$7-J$8)),Q$1),0)","v":0}]
[null,"Finance","£",null,"£",{"$f":"IF($D$6<>0,$D39*F$6/$D$6,0)","v":0},"£",0,"£",0,null,null,0,null,0,null,0]
[null,"Directorate","£",null,"£",0,"£",0,"£",0,null,null,0,null,0,null,0]
[null,"IT","£",null,"£",0,"£",0,"£",0,null,null,0,null,0,null,0]
[null,"Central office admin","£",null,"£",0,"£",0,"£",0,null,null,0,null,0,null,0]
[null,"Total / cost rent",null,null,"£",{"$f":"IF(F6>0,SUM(F12:F17,F19:F29,F33:F35,F38:F42),0)","v":0},"£",{"$f":"IF(H6>0,SUM(H12:H17,H19:H29,H33:H35,H38:H42),0)","v":0},"£",{"$f":"IF(J6>0,SUM(J12:J17,J19:J29,J33:J35,J38:J42),0)","v":0},null,null,{"$f":"SUM(M12:M17,M19:M29,M33:M35,M38:M42)","v":0},null,{"$f":"SUM(O12:O17,O19:O29,O33:O35,O38:O42)","v":0},null,{"$f":"SUM(Q12:Q17,Q19:Q29,Q33:Q35,Q38:Q42)","v":0}]
[]
[]
[]
[null,"Income"]
[null,"Cost rent receivable",null,null,null,{"$f":"F6*M43*52","v":0},null,{"$f":"H6*O43*52","v":0},null,{"$f":"J6*Q43*52","v":0}]
[null,"Less voids",null,null,null,{"$f":"-F48*(100-F7)/100","v":0},null,{"$f":"-H48*(100-H7)/100","v":0},null,{"$f":"-J48*(100-J7)/100","v":0}]
[null,null,null,null,null,{"$f":"SUM(F48:F49)","v":0},null,{"$f":"SUM(H48:H49)","v":0},null,{"$f":"SUM(J48:J49)","v":0}]
[null,"Expenditure"]
[null,"Bad debts",null,null,null,{"$f":"F48*F8/100","v":0},null,{"$f":"H48*H8/100","v":0},null,{"$f":"J48*J8/100","v":0}]
[null,"Property costs",null,"Charge rounding",null,{"$f":"F43","v":0},null,{"$f":"H43","v":0},null,{"$f":"J43","v":0}]
[null,"Rounding (dec points)",null,6,null,{"$f":"ROUND(F50-SUM(F52:F53),2)","v":0},null,{"$f":"ROUND(H50-SUM(H52:H53),2)","v":0},null,{"$f":"ROUND(J50-SUM(J52:J53),2)","v":0}]
[null,null,null,null,null,{"$f":"SUM(F52:F54)","v":0},null,{"$f":"SUM(H52:H54)","v":0},null,{"$f":"SUM(J52:J54)","v":0}]
[]
[null,null,null,null,null,{"$f":"ROUND(F50-F55,2)","v":0},null,{"$f":"ROUND(H50-H55,2)","v":0},null,{"$f":"ROUND(J50-J55,2)","v":0}]

{"sheet":"EHM","index":9,"n_rows":51,"n_cols":11,"rows_kept":51,"cut":false,"hidden":true,"merged":[[3,1,3,2],[37,1,37,3]]}
[]
[null,{"$f":"IF(Menu!B3<>\"\",Menu!B3,\"\")","v":""}]
[null,null,null,null,null,"Unit",null,"Unit",null,"Unit"]
[null,"ENHANCED HOUSING MANAGEMENT",null,null,null,"type 1",null,"type 2",null,"type 3"]
[null,null,null,"Total",null,{"$f":"'M1'!C12","v":"Bedsit/room"},null,{"$f":"'M1'!F12","v":"1-bed"},null,{"$f":"'M1'!I12","v":"1-bed"}]
[null,"Number of units",null,{"$f":"SUM(F6:J6)","v":0},null,{"$f":"'M1'!C8","v":0},null,{"$f":"'M1'!F8","v":0},null,{"$f":"'M1'!I8","v":0}]
[null,"Budgeted occupancy (see units page)",null,null,null,{"$f":"IF(F6>0,'M1'!C10,0)","v":0},"%",{"$f":"IF(H6>0,'M1'!F10,0)","v":0},"%",{"$f":"IF(J6>0,'M1'!I10,0)","v":0},"%"]
[null,"Budgeted bad debts (HB-eligible) - see services page",null,null,null,{"$f":"Services!F9","v":2},"%",{"$f":"Services!H9","v":2},"%",{"$f":"Services!J9","v":2},"%"]
[]
[null,"Weekly hours per resident"]
[null,"Adjust weekly hours between units  +/-  ( %)",null,null,null,null,{"$f":"IF(F11<>0,\"%\",\"\")","v":""},null,{"$f":"IF(H11<>0,\"%\",\"\")","v":""},null,{"$f":"IF(J11<>0,\"%\",\"\")","v":""}]
[null,"Staff-time - weekly hours",null,{"$f":"Salaries!I28","v":0},null,{"$f":"IF($D$51<>0,$D12*F51/$D$51,0)","v":0},null,{"$f":"IF($D$51<>0,$D12*H51/$D$51,0)","v":0},null,{"$f":"IF($D$51<>0,$D12*J51/$D$51,0)","v":0}]
[null,"Weekly hours per resident",null,{"$f":"IF(D6<>0,D12/D6,0)","v":0},null,{"$f":"IF(F6<>0,F12/F6,0)","v":0},null,{"$f":"IF(H6<>0,H12/H6,0)","v":0},null,{"$f":"IF(J6<>0,J12/J6,0)","v":0}]
[]
[null,"Care support and supervision budget"]
[null,"Salaries - enhanced management",null,{"$f":"Salaries!H28","v":0},null,{"$f":"IF($D$12<>0,$D16*F$12/$D$12,0)","v":0},null,{"$f":"IF($D$12<>0,$D16*H$12/$D$12,0)","v":0},null,{"$f":"IF($D$12<>0,$D16*J$12/$D$12,0)","v":0}]
[null,"Salaries - out of hours cover",null,{"$f":"Salaries!H29","v":0},null,{"$f":"IF($D$12<>0,$D17*F$12/$D$12,0)","v":0},null,{"$f":"IF($D$12<>0,$D17*H$12/$D$12,0)","v":0},null,{"$f":"IF($D$12<>0,$D17*J$12/$D$12,0)","v":0}]
[null,"On-call / sleep in - from out of hours cover page",null,{"$f":"'Out of hrs'!D9+'Out of hrs'!D14","v":0},null,{"$f":"IF($D$12<>0,$D18*F$12/$D$12,0)","v":0},null,{"$f":"IF($D$12<>0,$D18*H$12/$D$12,0)","v":0},null,{"$f":"IF($D$12<>0,$D18*J$12/$D$12,0)","v":0}]
[null,"Other enhanced management",null,0,null,{"$f":"IF($D$12<>0,$D19*F$12/$D$12,0)","v":0},null,{"$f":"IF($D$12<>0,$D19*H$12/$D$12,0)","v":0},null,{"$f":"IF($D$12<>0,$D19*J$12/$D$12,0)","v":0}]
[null,"Other enhanced management",null,0,null,0,null,0,null,0]
[null,"Central / area team costs",null,0,null,0,null,0,null,0]
[null,"Central overhead charge",null,0,null,0,null,0,null,0]
[null,"Total expenditure",null,{"$f":"SUM(D16:D22)","v":0},null,{"$f":"SUM(F16:F22)","v":0},null,{"$f":"SUM(H16:H22)","v":0},null,{"$f":"SUM(J16:J22)","v":0}]
[]
[]
[null,"ENHANCED MANAGEMENT CHARGES"]
[]
[null,"Charges to residents (ineligible for HB) - if any",null,null,null,{"$f":"F4","v":"type 1"},null,{"$f":"H4","v":"type 2"},null,{"$f":"J4","v":"type 3"}]
[null,"Weekly charge",null,null,{"$f":"IF(F29>0,\"£\",\"\")","v":""},{"$f":"IF(AND(F6<>0,F23<>0),F23/F6/52*100/(F7-F8),0)","v":0},{"$f":"IF(H29>0,\"£\",\"\")","v":""},{"$f":"IF(AND(H6<>0,H23<>0),H23/H6/52*100/(H7-H8),0)","v":0},{"$f":"IF(J29>0,\"£\",\"\")","v":""},{"$f":"IF(AND(J6<>0,J23<>0),J23/J6/52*100/(J7-J8),0)","v":0}]
[null,"Enhanced management charges receivable",null,{"$f":"SUM(F30,H30,J30)","v":0},null,{"$f":"F29*F6*52","v":0},null,{"$f":"H29*H6*52","v":0},null,{"$f":"J29*J6*52","v":0}]
[null,"Less:"]
[null,"Voids",null,{"$f":"SUM(F32,H32,J32)","v":0},null,{"$f":"-F30*(100-F7)/100","v":0},null,{"$f":"-H30*(100-H7)/100","v":0},null,{"$f":"-J30*(100-J7)/100","v":0}]
[null,"Bad debts",null,0,null,{"$f":"-F30*F8/100","v":0},null,{"$f":"-H30*H8/100","v":0},null,{"$f":"-J30*J8/100","v":0}]
[null,"Net income from charges",null,{"$f":"SUM(D30,D32:D33)","v":0},null,{"$f":"SUM(F30,F32:F33)","v":0},null,{"$f":"SUM(H30,H32:H33)","v":0},null,{"$f":"SUM(J30,J32:J33)","v":0}]
[]
[null,{"$f":"IF(D36>=0,\"Surplus\",IF(D36<0,\"Deficit\",\"\"))","v":"Surplus"},null,{"$f":"ROUND(D34-D23,2)","v":0}]
[]
[null,"Security contracts / staff are included in HB-eligible services"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,{"$f":"SUM(F51:J51)","v":0},null,{"$f":"F6*(100+F11)/100","v":0},null,{"$f":"H6*(100+H11)/100","v":0},null,{"$f":"J6*(100+J11)/100","v":0}]

{"sheet":"Salaries","index":10,"n_rows":35,"n_cols":50,"rows_kept":35,"cut":false,"hidden":true,"merged":[[3,3,3,5],[3,15,3,19],[2,10,2,21],[3,29,3,33],[3,43,3,47],[3,7,3,8],[3,10,3,13],[3,24,3,27],[3,38,3,41]]}
[]
[null,{"$f":"IF(Menu!B3<>\"\",Menu!B3,\"\")","v":""}]
[null,"Project Team",null,null,null,null,null,null,null,null,"Percentage allocation of hours and costs (enter as number without % sign)"]
[null,null,null,"Details for EACH post",null,null,null,"Project team cost & hours",null,null,"Housing management",null,null,null,null,"Services",null,null,null,null,null,"Care,",null,null,"Housing management",null,null,null,null,"Services",null,null,null,null,null,"Care,",null,null,"Housing management",null,null,null,null,"Services",null,null,null,null,null,"Care,"]
[null,null,"Number","Salary","Total","Percentage",null,"Salaries,","Total",null,null,"Property",null,"Out",null,null,null,null,null,null,null,"support &",null,null,null,"Property",null,"Out",null,null,null,null,null,null,null,"support &",null,null,null,"Property",null,"Out",null,null,null,null,null,null,null,"support &"]
[null,null,"of","employer NI","Weekly","allocated to",null,"NI &","Weekly",null,"Core","maint-",null,"of hours",null,"Communal","Care-","Security","Catering","HB",null,"Super-",null,null,"Core","maint-",null,"of hours",null,"Communal","Care-","Security","Catering","HB",null,"Super-",null,null,"Core","maint-",null,"of hours",null,"Communal","Care-","Security","Catering","HB",null,"Super-"]
[null,"Post","posts","& pension","hours","this project",null,"pensions","hours",null,"(basic)","enance","Enhanced","cover *",null,"cleaning","taking",null,null,"ineligible",null,"vision *",null,null,"(basic*)","enance","Enhanced","cover *",null,"cleaning","taking",null,null,"ineligible",null,"vision",null,null,"(basic*)","enance","Enhanced","cover *",null,"cleaning","taking",null,null,"ineligible",null,"vision"]
[null,null,"No.","£","Hrs","%",null,"£","Hrs",null,"%","%","%","%",null,"%","%","%","%","%",null,"%"]
[null,"Service Manager",null,null,0,100,{"$f":"IF(AND(C9>0,D9>0,E9>0),\"%\",\"\")","v":""},{"$f":"D9*C9*F9/100","v":0},{"$f":"C9*E9*F9/100","v":0},{"$f":"IF(AND(OR(H9>0,I9>0),V9<0),\"Check →\",\"\")","v":""},0,0,0,0,null,0,0,0,0,0,null,{"$f":"100-SUM(K9:N9,P9:T9)","v":100},null,null,{"$f":"IF($G9=\"%\",$H9*K9/100,0)","v":0},{"$f":"IF($G9=\"%\",$H9*L9/100,0)","v":0},{"$f":"IF($G9=\"%\",$H9*M9/100,0)","v":0},{"$f":"IF($G9=\"%\",$H9*N9/100,0)","v":0},null,{"$f":"IF($G9=\"%\",$H9*P9/100,0)","v":0},{"$f":"IF($G9=\"%\",$H9*Q9/100,0)","v":0},{"$f":"IF($G9=\"%\",$H9*R9/100,0)","v":0},{"$f":"IF($G9=\"%\",$H9*S9/100,0)","v":0},{"$f":"IF($G9=\"%\",$H9*T9/100,0)","v":0},null,{"$f":"IF(G9=\"%\",H9-SUM(Y9:AB9,AD9:AH9),0)","v":0},null,null,{"$f":"IF($G9=\"%\",$I9*K9/100,0)","v":0},{"$f":"IF($G9=\"%\",$I9*L9/100,0)","v":0},{"$f":"IF($G9=\"%\",$I9*M9/100,0)","v":0},{"$f":"IF($G9=\"%\",$I9*N9/100,0)","v":0},null,{"$f":"IF($G9=\"%\",$I9*P9/100,0)","v":0},{"$f":"IF($G9=\"%\",$I9*Q9/100,0)","v":0},{"$f":"IF($G9=\"%\",$I9*R9/100,0)","v":0},{"$f":"IF($G9=\"%\",$I9*S9/100,0)","v":0},{"$f":"IF($G9=\"%\",$I9*T9/100,0)","v":0},null,{"$f":"IF(G9=\"%\",I9-SUM(AM9:AP9,AR9:AV9),0)","v":0}]
[null,"Team leader",null,null,0,100,{"$f":"IF(AND(C10>0,D10>0,E10>0),\"%\",\"\")","v":""},{"$f":"D10*C10*F10/100","v":0},{"$f":"C10*E10*F10/100","v":0},{"$f":"IF(AND(OR(H10>0,I10>0),V10<0),\"Check →\",\"\")","v":""},0,0,0,null,null,0,0,0,0,0,null,{"$f":"100-SUM(K10:N10,P10:T10)","v":100},null,null,{"$f":"IF($G10=\"%\",$H10*K10/100,0)","v":0},{"$f":"IF($G10=\"%\",$H10*L10/100,0)","v":0},{"$f":"IF($G10=\"%\",$H10*M10/100,0)","v":0},0,null,{"$f":"IF($G10=\"%\",$H10*P10/100,0)","v":0},0,0,{"$f":"IF($G10=\"%\",$H10*S10/100,0)","v":0},{"$f":"IF($G10=\"%\",$H10*T10/100,0)","v":0},null,{"$f":"IF(G10=\"%\",H10-SUM(Y10:AB10,AD10:AH10),0)","v":0},null,null,{"$f":"IF($G10=\"%\",$I10*K10/100,0)","v":0},{"$f":"IF($G10=\"%\",$I10*L10/100,0)","v":0},{"$f":"IF($G10=\"%\",$I10*M10/100,0)","v":0},0,null,{"$f":"IF($G10=\"%\",$I10*P10/100,0)","v":0},0,0,{"$f":"IF($G10=\"%\",$I10*S10/100,0)","v":0},{"$f":"IF($G10=\"%\",$I10*T10/100,0)","v":0},null,{"$f":"IF(G10=\"%\",I10-SUM(AM10:AP10,AR10:AV10),0)","v":0}]
[null,"Project Worker",null,null,0,100,"",0,0,"",0,0,0,null,null,0,0,0,0,0,null,100,null,null,0,0,0,0,null,0,0,0,0,0,null,0,null,null,0,0,0,0,null,0,0,0,0,0,null,0]
[null,"Cleaner",null,null,0,100,"",0,0,"",0,0,0,null,null,0,0,0,0,0,null,100,null,null,0,0,0,0,null,0,0,0,0,0,null,0,null,null,0,0,0,0,null,0,0,0,0,0,null,0]
[null,"Cook",null,null,0,100,"",0,0,"",0,0,0,null,null,0,0,0,0,0,null,100,null,null,0,0,0,0,null,0,0,0,0,0,null,0,null,null,0,0,0,0,null,0,0,0,0,0,null,0]
[null,null,null,null,null,100,"",0,0,"",0,100,0,null,null,0,0,null,0,0,null,0,null,null,0,0,0,0,null,0,0,0,0,0,null,0,null,null,0,0,0,0,null,0,0,0,0,0,null,0]
[null,null,null,null,null,100,"",0,0,"",0,0,0,null,null,0,0,null,0,0,null,100,null,null,0,0,0,0,null,0,0,0,0,0,null,0,null,null,0,0,0,0,null,0,0,0,0,0,null,0]
[null,null,null,null,null,100,"",0,0,"",0,0,0,null,null,0,0,null,0,0,null,100,null,null,0,0,0,0,null,0,0,0,0,0,null,0,null,null,0,0,0,0,null,0,0,0,0,0,null,0]
[null,null,null,null,null,100,"",0,0,"",0,0,0,null,null,0,0,null,0,0,null,100,null,null,0,0,0,0,null,0,0,0,0,0,null,0,null,null,0,0,0,0,null,0,0,0,0,0,null,0]
[null,null,null,null,null,100,"",0,0,"",0,0,0,null,null,0,0,null,0,0,null,100,null,null,0,0,0,0,null,0,0,0,0,0,null,0,null,null,0,0,0,0,null,0,0,0,0,0,null,0]
[null,null,null,null,null,100,"",0,0,"",0,0,0,null,null,0,0,null,0,0,null,100,null,null,0,0,0,0,null,0,0,0,0,0,null,0,null,null,0,0,0,0,null,0,0,0,0,0,null,0]
[null,null,null,null,null,100,"",0,0,"",0,0,0,null,null,0,0,null,0,0,null,100,null,null,0,0,0,0,null,0,0,0,0,0,null,0,null,null,0,0,0,0,null,0,0,0,0,0,null,0]
[null,null,null,null,null,100,"",0,0,"",0,0,0,null,null,0,0,null,0,0,null,100,null,null,0,0,0,0,null,0,0,0,0,0,null,0,null,null,0,0,0,0,null,0,0,0,0,0,null,0]
[null,null,null,null,null,100,"",0,0,"",0,0,0,null,null,0,0,null,0,0,null,100,null,null,0,0,0,0,null,0,0,0,0,0,null,0,null,null,0,0,0,0,null,0,0,0,0,0,null,0]
[null,null,null,null,null,100,"",0,0,"",0,0,0,null,null,0,0,null,0,0,null,100,null,null,0,0,0,0,null,0,0,0,0,0,null,0,null,null,0,0,0,0,null,0,0,0,0,0,null,0]
[null,null,null,null,null,null,null,{"$f":"SUM(H9:H23)","v":0},{"$f":"SUM(I9:I23)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Y9:Y23)","v":0},{"$f":"SUM(Z9:Z23)","v":0},{"$f":"SUM(AA9:AA23)","v":0},0,null,{"$f":"SUM(AD9:AD23)","v":0},0,{"$f":"SUM(AF9:AF23)","v":0},0,0,null,{"$f":"SUM(AJ9:AJ23)","v":0},null,null,{"$f":"SUM(AM9:AM23)","v":0},{"$f":"SUM(AN9:AN23)","v":0},{"$f":"SUM(AO9:AO23)","v":0},0,null,{"$f":"SUM(AR9:AR23)","v":0},{"$f":"SUM(AS9:AS23)","v":0},0,{"$f":"SUM(AU9:AU23)","v":0},{"$f":"SUM(AV9:AV23)","v":0},null,{"$f":"SUM(AX9:AX23)","v":0}]
[null,"Allocated hours and costs"]
[null,"Core housing management",null,null,null,null,null,{"$f":"Y24","v":0},{"$f":"AM24","v":0},null,null,null,null,"* staff time charged to out of",null,null,null,null,null,"* Can include out-of-hours"]
[null,"Property maintenance",null,null,null,null,null,{"$f":"Z24","v":0},{"$f":"AN24","v":0},null,null,null,null,"hours cover.",null,null,null,null,null,"cover if paid for from care,"]
[null,"Enhanced management",null,null,null,null,null,{"$f":"AA24","v":0},{"$f":"AO24","v":0},null,null,null,null,"Assumed to be HB-eligible",null,null,null,null,null,"support & supervision funding"]
[null,"Out of hours cover",null,null,null,null,null,{"$f":"AB24","v":0},{"$f":"AP24","v":0},null,null,null,null,"Sleep-in / on call can be added ",null,null,null,null,null,"Sleep-in / on call can be added "]
[null,"Communal service",null,null,null,null,null,{"$f":"AD24+AE24+AF24","v":0},{"$f":"AR24+AS24+AT24","v":0},null,null,null,null,"on the out of hours page",null,null,null,null,null,"on the out-of hours page"]
[null,"Catering",null,null,null,null,null,{"$f":"AG24","v":0},{"$f":"AU24","v":0}]
[null,"HB-ineligible services",null,null,null,null,null,{"$f":"AH24","v":0},{"$f":"AV24","v":0}]
[null,"Care support and supervision",null,null,null,null,null,{"$f":"AJ24","v":0},{"$f":"AX24","v":0}]
[null,null,null,null,null,null,null,{"$f":"SUM(H26:H33)","v":0},{"$f":"SUM(I26:I33)","v":0}]
[null,null,null,null,null,null,null,{"$f":"Budget1!D44","v":0}]

{"sheet":"Rents","index":11,"n_rows":117,"n_cols":11,"rows_kept":117,"cut":false,"hidden":true,"merged":[[4,1,4,2]]}
[]
[]
[]
[]
[null,"SHEDULE OF RENTS AND CHARGES"]
[null,null,null,{"$f":"'M1'!C12","v":"Bedsit/room"},null,{"$f":"'M1'!F12","v":"1-bed"},null,{"$f":"'M1'!I12","v":"1-bed"}]
[null,null,null,{"$f":"'M1'!C13","v":"Supported"},null,{"$f":"'M1'!F13","v":"Supported"},null,{"$f":"'M1'!I13","v":"Supported"}]
[null,null,null,{"$f":"'M1'!C14","v":"Cost rent*"},null,{"$f":"'M1'!F14","v":"Cost rent*"},null,{"$f":"'M1'!I14","v":"Cost rent*"}]
[null,{"$f":"IF(Menu!B3<>\"\",Menu!B3,\"\")","v":""},null,"£",null,"£",null,"£",null,null,1]
[null,"Core rent",null,{"$f":"'M1'!C38","v":0},null,{"$f":"'M1'!F38","v":0},null,{"$f":"'M1'!I38","v":0},null,null,1]
[null,"Council tax charge",null,{"$f":"IF(CT!F6>0,CT!F12,0)","v":0},null,{"$f":"IF(CT!H6>0,CT!H12,0)","v":0},null,{"$f":"IF(CT!J6>0,CT!J12,0)","v":0},null,null,{"$f":"IF(OR(D11<>0,F11<>0,H11<>0),1,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,1]
[null,"Enhanced management charge",null,{"$f":"EHM!F29","v":0},null,{"$f":"EHM!H29","v":0},null,{"$f":"EHM!J29","v":0},null,null,{"$f":"IF(OR(D13<>0,F13<>0,H13<>0),1,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(D13<>0,F13<>0,H13<>0),1,0)","v":0}]
[null,"Service charges (HB eligible)",null,null,null,null,null,null,null,null,1]
[null,{"$f":"Services!B14","v":"Heat and light (common parts only)"},null,{"$f":"Services!M14","v":0},null,{"$f":"Services!O14","v":0},null,{"$f":"Services!Q14","v":0},null,null,{"$f":"IF(OR(D16<>0,F16<>0,H16<>0),1,0)","v":0}]
[null,{"$f":"Services!B16","v":"Water charges (common parts only)"},null,{"$f":"Services!M16","v":0},null,{"$f":"Services!O16","v":0},null,{"$f":"Services!Q16","v":0},null,null,0]
[null,{"$f":"Services!B18","v":"Phone line rental (for use by residents)"},null,{"$f":"Services!M18","v":0},null,{"$f":"Services!O18","v":0},null,{"$f":"Services!Q18","v":0},null,null,0]
[null,{"$f":"Services!B21","v":"Cleaning materials"},null,{"$f":"Services!M21","v":0},null,{"$f":"Services!O21","v":0},null,{"$f":"Services!Q21","v":0},null,null,0]
[null,"Cleaning contracts",null,{"$f":"Services!M22","v":0},null,{"$f":"Services!O22","v":0},null,{"$f":"Services!Q22","v":0},null,null,0]
[null,"Cleaning staff",null,{"$f":"Services!M23","v":0},null,{"$f":"Services!O23","v":0},null,{"$f":"Services!Q23","v":0},null,null,0]
[null,"Caretaking",null,{"$f":"Services!M24","v":0},null,{"$f":"Services!O24","v":0},null,{"$f":"Services!Q24","v":0},null,null,0]
[null,{"$f":"Services!B26","v":"Window cleaning"},null,{"$f":"Services!M26","v":0},null,{"$f":"Services!O26","v":0},null,{"$f":"Services!Q26","v":0},null,null,0]
[null,{"$f":"Services!B27","v":"Deep cleaning"},null,{"$f":"Services!M27","v":0},null,{"$f":"Services!O27","v":0},null,{"$f":"Services!Q27","v":0},null,null,0]
[null,{"$f":"Services!B28","v":"Gardening (communal)"},null,{"$f":"Services!M28","v":0},null,{"$f":"Services!O28","v":0},null,{"$f":"Services!Q28","v":0},null,null,0]
[null,{"$f":"Services!B29","v":"Grounds maintenance"},null,{"$f":"Services!M29","v":0},null,{"$f":"Services!O29","v":0},null,{"$f":"Services!Q29","v":0},null,null,0]
[null,{"$f":"Services!B30","v":"Caretaking"},null,{"$f":"Services!M30","v":0},null,{"$f":"Services!O30","v":0},null,{"$f":"Services!Q30","v":0},null,null,0]
[null,{"$f":"Services!B31","v":"Rubbish clearance / removal"},null,{"$f":"Services!M31","v":0},null,{"$f":"Services!O31","v":0},null,{"$f":"Services!Q31","v":0},null,null,0]
[null,{"$f":"Services!B32","v":"Bulk waste disposal"},null,{"$f":"Services!M32","v":0},null,{"$f":"Services!O32","v":0},null,{"$f":"Services!Q32","v":0},null,null,0]
[null,{"$f":"Services!B33","v":"Sanitary waste removal"},null,{"$f":"Services!M33","v":0},null,{"$f":"Services!O33","v":0},null,{"$f":"Services!Q33","v":0},null,null,0]
[null,{"$f":"Services!B34","v":"Pest control"},null,{"$f":"Services!M34","v":0},null,{"$f":"Services!O34","v":0},null,{"$f":"Services!Q34","v":0},null,null,0]
[null,{"$f":"Services!B36","v":"Legionella testing & treatment"},null,{"$f":"Services!M36","v":0},null,{"$f":"Services!O36","v":0},null,{"$f":"Services!Q36","v":0},null,null,0]
[null,{"$f":"Services!B37","v":"Portable appliance testing"},null,{"$f":"Services!M37","v":0},null,{"$f":"Services!O37","v":0},null,{"$f":"Services!Q37","v":0},null,null,0]
[null,{"$f":"Services!B38","v":"Fixed appliance testing"},null,{"$f":"Services!M38","v":0},null,{"$f":"Services!O38","v":0},null,{"$f":"Services!Q38","v":0},null,null,0]
[null,{"$f":"Services!B39","v":"Smoke alarms"},null,{"$f":"Services!M39","v":0},null,{"$f":"Services!O39","v":0},null,{"$f":"Services!Q39","v":0},null,null,0]
[null,{"$f":"Services!B40","v":"Fire detection equipment"},null,{"$f":"Services!M41+Services!M42","v":0},null,{"$f":"Services!O41+Services!O42","v":0},null,{"$f":"Services!Q41+Services!Q42","v":0},null,null,0]
[null,{"$f":"Services!B43","v":"Fire fighting equipment"},null,{"$f":"Services!M44+Services!M45","v":0},null,{"$f":"Services!O44+Services!O45","v":0},null,{"$f":"Services!Q44+Services!Q45","v":0},null,null,0]
[null,{"$f":"Services!B46","v":"Other health & safety"},null,{"$f":"Services!M46","v":0},null,{"$f":"Services!O46","v":0},null,{"$f":"Services!Q46","v":0},null,null,0]
[null,{"$f":"Services!B48","v":"Furniture & equipment (common parts)"},null,{"$f":"Services!M48","v":0},null,{"$f":"Services!O48","v":0},null,{"$f":"Services!Q48","v":0},null,null,0]
[null,"Furn & equipmt (landlord owned for use in residents' accomm)",null,{"$f":"Services!M49","v":0},null,{"$f":"Services!O49","v":0},null,{"$f":"Services!Q49","v":0},null,null,0]
[null,{"$f":"Services!B50","v":"Kitchen equipment / white goods"},null,{"$f":"Services!M50","v":0},null,{"$f":"Services!O50","v":0},null,{"$f":"Services!Q50","v":0},null,null,0]
[null,{"$f":"Services!B51","v":"Laundry equipment"},null,{"$f":"Services!M51","v":0},null,{"$f":"Services!O51","v":0},null,{"$f":"Services!Q51","v":0},null,null,0]
[null,{"$f":"Services!B52","v":"Lift replacement"},null,{"$f":"Services!M52","v":0},null,{"$f":"Services!O52","v":0},null,{"$f":"Services!Q52","v":0},null,null,0]
[null,{"$f":"Services!B53","v":"Lift servicing / maintenance"},null,{"$f":"Services!M53","v":0},null,{"$f":"Services!O53","v":0},null,{"$f":"Services!Q53","v":0},null,null,0]
[null,{"$f":"Services!B54","v":"Aerials"},null,{"$f":"Services!M54","v":0},null,{"$f":"Services!O54","v":0},null,{"$f":"Services!Q54","v":0},null,null,0]
[null,{"$f":"Services!B55","v":"Carpets and curtains"},null,{"$f":"Services!M55","v":0},null,{"$f":"Services!O55","v":0},null,{"$f":"Services!Q55","v":0},null,null,0]
[null,{"$f":"Services!B56","v":"Renewals and replacements"},null,{"$f":"Services!M56","v":0},null,{"$f":"Services!O56","v":0},null,{"$f":"Services!Q56","v":0},null,null,0]
[null,{"$f":"Services!B57","v":"Contents insurance"},null,{"$f":"Services!M57","v":0},null,{"$f":"Services!O57","v":0},null,{"$f":"Services!Q57","v":0},null,null,0]
[null,{"$f":"Services!B59","v":"Security contracts"},null,{"$f":"Services!M59","v":0},null,{"$f":"Services!O59","v":0},null,{"$f":"Services!Q59","v":0},null,null,0]
[null,"Security staff",null,{"$f":"Services!M60","v":0},null,{"$f":"Services!O60","v":0},null,{"$f":"Services!Q60","v":0},null,null,0]
[null,{"$f":"Services!B61","v":"Door entry system"},null,{"$f":"Services!M61","v":0},null,{"$f":"Services!O61","v":0},null,{"$f":"Services!Q61","v":0},null,null,0]
[null,{"$f":"Services!B62","v":"CCTV"},null,{"$f":"Services!M62","v":0},null,{"$f":"Services!O62","v":0},null,{"$f":"Services!Q62","v":0},null,null,0]
[null,{"$f":"Services!B63","v":"Other security"},null,{"$f":"Services!M63","v":0},null,{"$f":"Services!O63","v":0},null,{"$f":"Services!Q63","v":0},null,null,0]
[null,{"$f":"Services!B65","v":"Redecoration of communal facilities"},null,{"$f":"Services!M65","v":0},null,{"$f":"Services!O65","v":0},null,{"$f":"Services!Q65","v":0},null,null,0]
[null,{"$f":"Services!B66","v":"Repairs & maint (communal facilities)"},null,{"$f":"Services!M66","v":0},null,{"$f":"Services!O66","v":0},null,{"$f":"Services!Q66","v":0},null,null,0]
[null,"Oher repais & maintenance expenses",null,{"$f":"Services!M67","v":0},null,{"$f":"Services!O67","v":0},null,{"$f":"Services!Q67","v":0},null,null,0]
[null,"Food / catering - excludes HB-ineligible charegs",null,{"$f":"Services!M69","v":0},null,{"$f":"Services!O69","v":0},null,{"$f":"Services!Q69","v":0},null,null,0]
[null,"Sub-total -direct costs of  HB-eligible servces",null,{"$f":"SUM(D16:D57)","v":0},null,{"$f":"SUM(F16:F57)","v":0},null,{"$f":"SUM(H16:H57)","v":0},null,null,1]
[null,"Admin charge (HB-eligible services)",null,{"$f":"Services!M78","v":0},null,{"$f":"Services!O78","v":0},null,{"$f":"Services!Q78","v":0},null,null,1]
[null,"Total: HB eligible services",null,{"$f":"SUM(D58:D59)","v":0},null,{"$f":"SUM(F58:F59)","v":0},null,{"$f":"SUM(H58:H59)","v":0},null,null,1]
[null,null,null,null,null,null,null,null,null,null,1]
[null,"Service charges (HB INeligible)",null,null,null,null,null,null,null,null,1]
[null,{"$f":"Services!B15","v":"Heat and light (rooms / flats)"},null,{"$f":"Services!M15","v":0},null,{"$f":"Services!O15","v":0},null,{"$f":"Services!Q15","v":0},null,null,{"$f":"IF(OR(D63<>0,F63<>0,H63<>0),1,0)","v":0}]
[null,{"$f":"Services!B17","v":"Water charges (rooms/flats)"},null,{"$f":"Services!M17","v":0},null,{"$f":"Services!O17","v":0},null,{"$f":"Services!Q17","v":0},null,null,0]
[null,{"$f":"Services!B18","v":"Phone line rental (for use by residents)"},null,{"$f":"Services!M18","v":0},null,{"$f":"Services!O18","v":0},null,{"$f":"Services!Q18","v":0},null,null,0]
[null,{"$f":"Services!B19","v":"Broadband charges"},null,{"$f":"Services!M19","v":0},null,{"$f":"Services!O19","v":0},null,{"$f":"Services!Q19","v":0},null,null,0]
[null,{"$f":"Services!B25","v":"Salaries - inelig services (exc catering)"},null,{"$f":"Services!M25","v":0},null,{"$f":"Services!O25","v":0},null,{"$f":"Services!Q25","v":0},null,null,0]
[null,"Meals",null,{"$f":"Services!M70","v":0},null,{"$f":"Services!O70","v":0},null,{"$f":"Services!Q70","v":0},null,null,0]
[null,"Sub-total -direct costs of  HB-ineligible servces",null,{"$f":"SUM(D63:D68)","v":0},null,{"$f":"SUM(F63:F68)","v":0},null,{"$f":"SUM(H63:H68)","v":0},null,null,1]
[null,"Admin charge (HB-ineligible services)",null,{"$f":"Services!M79","v":0},null,{"$f":"Services!O79","v":0},null,{"$f":"Services!Q79","v":0},null,null,0]
[null,"Total: HB ineligible services",null,{"$f":"SUM(D69:D70)","v":0},null,{"$f":"SUM(F69:F70)","v":0},null,{"$f":"SUM(H69:H70)","v":0},null,null,1]
[null,null,null,null,null,null,null,null,null,null,1]
[null,"Charge for care, support & supervision (HB-ineligible)",null,{"$f":"IF(CSS!F6<>0,CSS!F37,0)","v":0},null,{"$f":"IF(CSS!H6<>0,CSS!H37,0)","v":0},null,{"$f":"IF(CSS!J6<>0,CSS!J37,0)","v":0},null,null,{"$f":"IF(OR(D73<>0,F73<>0,H73<>0),1,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(D73<>0,F73<>0,H73<>0),1,0)","v":0}]
[null,"TOTAL PAYABLE",null,{"$f":"SUM(D73,D71,D60,D13,D11,D10)","v":0},null,{"$f":"SUM(F73,F71,F60,F13,F11,F10)","v":0},null,{"$f":"SUM(H73,H71,H60,H13,H11,H10)","v":0},null,null,1]
[null,{"$f":"IF(OR(D8=\"Cost rent*\",F8=\"Cost rent*\",H8=\"Cost rent*\"),\"* cost rents are set to match core property costs\",\"\")","v":"* cost rents are set to match core property costs"},null,null,null,null,null,null,null,null,1]
[null,null,null,{"$f":"ROUND(D60-D79,2)","v":0},null,{"$f":"ROUND(F60-F79,2)","v":0},null,{"$f":"ROUND(H60-H79,2)","v":0},null,null,{"$f":"IF(OR(D77<>0,F77<>0,H77<>0),1,0)","v":0}]
[null,null,null,{"$f":"ROUND(D71-D80,2)","v":0},null,{"$f":"ROUND(F71-F80,2)","v":0},null,{"$f":"ROUND(H71-H80,2)","v":0},null,null,0]
[null,null,null,{"$f":"Services!M82","v":0},null,{"$f":"Services!O82","v":0},null,{"$f":"Services!Q82","v":0}]
[null,null,null,{"$f":"Services!M83","v":0},null,{"$f":"Services!O83","v":0},null,{"$f":"Services!Q83","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,{"$f":"Services!B75","v":"SUB-TOTAL DIRECT COSTS: HB INELIGIBLE"},null,{"$f":"Services!M75","v":0},null,{"$f":"Services!O75","v":0},null,{"$f":"Services!Q75","v":0},null,null,1]

{"sheet":"EHMplus","index":12,"n_rows":31,"n_cols":9,"rows_kept":31,"cut":false,"hidden":true,"merged":[[3,2,3,3],[5,2,5,4],[18,2,18,4],[13,2,13,4],[14,2,14,4],[15,2,15,4],[16,2,16,4],[17,2,17,4],[21,2,21,4],[22,2,22,4],[23,2,23,4],[10,7,10,8],[19,2,19,4],[20,2,20,4]]}
[]
[]
[]
[null,null,"ENHANCED HOUSING MANAGEMENT"]
[]
[null,null,{"$f":"IF(Menu!B3<>\"\",Menu!B3,\"\")","v":""}]
[]
[null,null,"Total number of hours charged to enhanced management",null,null,null,{"$f":"EHM!D12","v":0},"hrs"]
[null,null,"Total annual cost",null,null,"£",{"$f":"EHM!D23","v":0}]
[]
[null,null,null,null,null,"Weekly","Annual","Balance of duties"]
[null,null,null,null,null,"hours","cost £","Actual","Suggested"]
[null,null,null,null,null,null,null,"%","%"]
[null,null,"Managing anti-social behaviour *",null,null,{"$f":"IF(SUM($H$15:$H$24)=0,$G$8*$I14/100,$G$8*$H14/100)","v":0},{"$f":"IF(SUM($H$15:$H$24)=0,$G$9*$I14/100,$G$9*$H14/100)","v":0},{"$f":"IF(SUM(H15:H24)>0,100-SUM(H15:H24),0)","v":0},{"$f":"100-SUM(I15:I24)","v":10}]
[null,null,"Responding to complaints *",null,null,{"$f":"IF(SUM($H$15:$H$24)=0,$G$8*$I15/100,$G$8*$H15/100)","v":0},{"$f":"IF(SUM($H$15:$H$24)=0,$G$9*I15/100,$G$9*H15/100)","v":0},null,10]
[null,null,"Managing access to shared facilities **",null,null,0,0,null,15]
[null,null,"Concierge / managing access to the building, dealing with disruptive visitors *",null,null,0,0,null,25]
[null,null,"Monitoring CCTV",null,null,0,0,null,15]
[null,null,"Additional input re lettings, enforcing tenancy conditions, rent collection and arrears control *",null,null,0,0,null,10]
[null,null,"Managing extensive / exceptional property maintenance **",null,null,0,0,null,10]
[null,null,"Report writing, handover session, breaks, staff meetings, training, etc.",null,null,0,0,null,5]
[null,null,"Other ",null,null,0,0,null,0]
[null,null,"Other ",null,null,0,0,null,0]
[null,null,"Other ",null,null,0,0,null,0]
[null,null,null,null,null,{"$f":"SUM(F14:F24)","v":0},{"$f":"SUM(G14:G24)","v":0}]
[]
[null,null,"*  Additional input required by the staff team, over and above that normally needed for general needs or low"]
[null,null,"support services."]
[]
[null,null,"**   Enhanced management does not constitute the provision of a support service.  It arises out of the needs of"]
[null,null,"supported housing residents but does not address those support needs."]

{"sheet":"CT","index":13,"n_rows":84,"n_cols":11,"rows_kept":84,"cut":false,"hidden":true,"merged":[[3,1,3,2],[70,1,70,3]]}
[]
[null,{"$f":"IF(Menu!B3<>\"\",Menu!B3,\"\")","v":""}]
[null,null,null,null,null,"Unit",null,"Unit",null,"Unit"]
[null,"COUNCIL TAX",null,null,null,"type 1",null,"type 2",null,"type 3"]
[null,null,null,"Total",null,{"$f":"'M1'!C12","v":"Bedsit/room"},null,{"$f":"'M1'!F12","v":"1-bed"},null,{"$f":"'M1'!I12","v":"1-bed"}]
[null,"Number of units",null,{"$f":"SUM(F6:J6)","v":0},null,{"$f":"'M1'!C8","v":0},null,{"$f":"'M1'!F8","v":0},null,{"$f":"'M1'!I8","v":0}]
[null,"Budgeted occupancy (see units page)",null,null,null,{"$f":"IF(F6>0,'M1'!C10,0)","v":0},"%",{"$f":"IF(H6>0,'M1'!F10,0)","v":0},"%",{"$f":"IF(J6>0,'M1'!I10,0)","v":0},"%"]
[null,"Budgeted bad debts (core rents) - see the property page",null,null,null,{"$f":"Prop!F8","v":2},"%",{"$f":"Prop!H8","v":2},"%",{"$f":"Prop!J8","v":2},"%"]
[]
[null,"Council tax per unit per annum","£",{"$f":"SUM(F10,H10,J10)","v":0},"£",0,"£",0,"£",0]
[null,"Annual council tax","£",{"$f":"SUM(F11,H11,J11)","v":0},"£",{"$f":"F10*F6","v":0},"£",{"$f":"H10*H6","v":0},"£",{"$f":"J10*J6","v":0}]
[null,"Weekly council tax per unit",null,null,"£",{"$f":"F10/52","v":0},"£",{"$f":"H10/52","v":0},"£",{"$f":"J10/52","v":0}]
[]
[null,"Gross CT charges receivable","£",{"$f":"SUM(F14,H14,J14)","v":0},"£",{"$f":"F12*F6*52","v":0},"£",{"$f":"H12*H6*52","v":0},"£",{"$f":"J12*J6*52","v":0}]
[null,"Less voids","£",{"$f":"SUM(F15,H15,J15)","v":0},"£",{"$f":"-F14*(100-F7)/100","v":0},"£",{"$f":"-H14*(100-H7)/100","v":0},"£",{"$f":"-J14*(100-J7)/100","v":0}]
[null,"Less bad debts","£",0,"£",{"$f":"-F14*F8/100","v":0},"£",{"$f":"-H14*H8/100","v":0},"£",{"$f":"-J14*J8/100","v":0}]
[null,"Net CT charges receivable","£",{"$f":"SUM(D14:D16)","v":0},"£",{"$f":"SUM(F14:F16)","v":0},"£",{"$f":"SUM(H14:H16)","v":0},"£",{"$f":"SUM(J14:J16)","v":0}]
[null,"Council tax voids","£",0,"£",{"$f":"F11-F17","v":0},"£",{"$f":"H11-H17","v":0},"£",{"$f":"J11-J17","v":0}]
[null,null,"£",{"$f":"SUM(D17:D18)","v":0},"£",{"$f":"SUM(F17:F18)","v":0},"£",{"$f":"SUM(H17:H18)","v":0},"£",{"$f":"SUM(J17:J18)","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Weekl hours per resident"]
[null,"Adjust weekly hours between units  +/-  ( %)",null,null,null,null,{"$f":"IF(F44<>0,\"%\",\"\")","v":""},null,{"$f":"IF(H44<>0,\"%\",\"\")","v":""},null,{"$f":"IF(J44<>0,\"%\",\"\")","v":""}]
[null,"Staff-time - weekly hours",null,{"$f":"Salaries!I28","v":0},null,{"$f":"IF($D$84<>0,$D45*F84/$D$84,0)","v":0},null,{"$f":"IF($D$84<>0,$D45*H84/$D$84,0)","v":0},null,{"$f":"IF($D$84<>0,$D45*J84/$D$84,0)","v":0}]
[null,"Weekly hours per resident",null,{"$f":"IF(D6<>0,D45/D6,0)","v":0},null,{"$f":"IF(F6<>0,F45/F6,0)","v":0},null,{"$f":"IF(H6<>0,H45/H6,0)","v":0},null,{"$f":"IF(J6<>0,J45/J6,0)","v":0}]
[]
[null,"Care support and supervision budget"]
[null,"Salaries - enhanced management",null,{"$f":"Salaries!H28","v":0},null,{"$f":"IF($D$45<>0,$D49*F$45/$D$45,0)","v":0},null,{"$f":"IF($D$45<>0,$D49*H$45/$D$45,0)","v":0},null,{"$f":"IF($D$45<>0,$D49*J$45/$D$45,0)","v":0}]
[null,"Salaries - out of hours cover",null,{"$f":"Salaries!H29","v":0},null,{"$f":"IF($D$45<>0,$D50*F$45/$D$45,0)","v":0},null,{"$f":"IF($D$45<>0,$D50*H$45/$D$45,0)","v":0},null,{"$f":"IF($D$45<>0,$D50*J$45/$D$45,0)","v":0}]
[null,"On-call / sleep in - from out of hours cover page",null,{"$f":"'Out of hrs'!D9+'Out of hrs'!D14","v":0},null,{"$f":"IF($D$45<>0,$D51*F$45/$D$45,0)","v":0},null,{"$f":"IF($D$45<>0,$D51*H$45/$D$45,0)","v":0},null,{"$f":"IF($D$45<>0,$D51*J$45/$D$45,0)","v":0}]
[null,"Other enhanced management",null,0,null,{"$f":"IF($D$45<>0,$D52*F$45/$D$45,0)","v":0},null,{"$f":"IF($D$45<>0,$D52*H$45/$D$45,0)","v":0},null,{"$f":"IF($D$45<>0,$D52*J$45/$D$45,0)","v":0}]
[null,"Other enhanced management",null,0,null,0,null,0,null,0]
[null,"Central / area team costs",null,0,null,0,null,0,null,0]
[null,"Central overhead charge",null,0,null,0,null,0,null,0]
[null,"Total expenditure",null,{"$f":"SUM(D49:D55)","v":0},null,{"$f":"SUM(F49:F55)","v":0},null,{"$f":"SUM(H49:H55)","v":0},null,{"$f":"SUM(J49:J55)","v":0}]
[]
[]
[null,"ENHANCED MANAGEMENT CHARGES"]
[]
[null,"Charges to residents (ineligible for HB) - if any",null,null,null,{"$f":"F4","v":"type 1"},null,{"$f":"H4","v":"type 2"},null,{"$f":"J4","v":"type 3"}]
[null,"Weekly charge",null,null,{"$f":"IF(F62>0,\"£\",\"\")","v":""},{"$f":"IF(AND(F6<>0,F56<>0),F56/F6/52*100/(F7-#REF!),0)","v":0},{"$f":"IF(H62>0,\"£\",\"\")","v":""},{"$f":"IF(AND(H6<>0,H56<>0),H56/H6/52*100/(H7-#REF!),0)","v":0},{"$f":"IF(J62>0,\"£\",\"\")","v":""},{"$f":"IF(AND(J6<>0,J56<>0),J56/J6/52*100/(J7-#REF!),0)","v":0}]
[null,"Enhanced manageemnt charges receivable",null,{"$f":"SUM(F63,H63,J63)","v":0},null,{"$f":"F62*F6*52","v":0},null,{"$f":"H62*H6*52","v":0},null,{"$f":"J62*J6*52","v":0}]
[null,"Less:"]
[null,"Voids",null,{"$f":"SUM(F65,H65,J65)","v":0},null,{"$f":"-F63*(100-F7)/100","v":0},null,{"$f":"-H63*(100-H7)/100","v":0},null,{"$f":"-J63*(100-J7)/100","v":0}]
[null,"Bad debts",null,{"$error":"#REF!"},null,{"$f":"-F63*#REF!/100","v":{"$error":"#REF!"}},null,{"$f":"-H63*#REF!/100","v":{"$error":"#REF!"}},null,{"$f":"-J63*#REF!/100","v":{"$error":"#REF!"}}]
[null,"Net income from charges",null,{"$f":"SUM(D63,D65:D66)","v":{"$error":"#REF!"}},null,{"$f":"SUM(F63,F65:F66)","v":{"$error":"#REF!"}},null,{"$f":"SUM(H63,H65:H66)","v":{"$error":"#REF!"}},null,{"$f":"SUM(J63,J65:J66)","v":{"$error":"#REF!"}}]
[]
[null,{"$f":"IF(D69>=0,\"Surplus\",IF(D69<0,\"Deficit\",\"\"))","v":{"$error":"#REF!"}},null,{"$f":"ROUND(D67-D56,2)","v":{"$error":"#REF!"}}]
[]
[null,"Securuty contracts / staff are included in HB-eligible services"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,{"$f":"SUM(F84:J84)","v":0},null,{"$f":"F6*(100+F44)/100","v":0},null,{"$f":"H6*(100+H44)/100","v":0},null,{"$f":"J6*(100+J44)/100","v":0}]

{"sheet":"CSSplus","index":14,"n_rows":31,"n_cols":8,"rows_kept":31,"cut":false,"hidden":true,"merged":[[5,1,5,3],[19,6,19,7],[22,1,22,3],[23,1,23,3],[24,1,24,3],[8,1,8,7],[10,4,11,7],[13,2,14,7],[10,3,11,3],[27,1,27,3],[28,1,28,3],[29,1,29,3],[26,1,26,3],[25,1,25,3]]}
[]
[]
[]
[null,"Care / support & supervision"]
[]
[null,{"$f":"IF(Menu!B3<>\"\",Menu!B3,\"\")","v":""}]
[]
[null,"Description of client group"]
[]
[]
[null,"All residents have support plans?","Yes","Notes"]
[null,"Daily log maintained for all residents?","Yes"]
[]
[null,"Software used to record support activity (if any)"]
[]
[]
[null,"Total number of hours charged to care support and supervision",null,null,null,{"$f":"CSS!D12","v":0},"hrs"]
[null,"Total annual cost",null,null,"£",{"$f":"CSS!D22","v":0}]
[]
[null,null,null,null,"Weekly","Annual","Balance of duties"]
[null,null,null,null,"hours","cost £","Actual","Suggested"]
[null,null,null,null,null,null,"%","%"]
[null,"One-to-one sessions",null,null,{"$f":"IF(SUM($G$24:$G$30)=0,$F$17*$H23/100,$F$17*$G23/100)","v":0},{"$f":"IF(SUM($G$24:$G$30)=0,$F$18*$H23/100,$F$18*$G23/100)","v":0},{"$f":"IF(SUM(G24:G30)>0,100-SUM(G24:G30),0)","v":0},{"$f":"100-SUM(H24:H30)","v":50}]
[null,"Group sessions",null,null,{"$f":"IF(SUM($G$24:$G$30)=0,$F$17*$H24/100,$F$17*$G24/100)","v":0},{"$f":"IF(SUM($G$24:$G$30)=0,$F$18*$H24/100,$F$18*$G24/100)","v":0},null,20]
[null,"Liaison with other agencies",null,null,0,0,null,10]
[null,"Off-site support for visits/ appointments, etc.",null,null,0,0,null,5]
[null,"Report writing, handover session, breaks, staff meetings, training, etc.",null,null,0,0,null,15]
[null,"Other ",null,null,0,0,null,0]
[null,"Other ",null,null,0,0,null,0]
[null,"Other ",null,null,0,0,null,0]
[null,null,null,null,{"$f":"SUM(E23:E30)","v":0},{"$f":"SUM(F23:F30)","v":0}]

{"sheet":"Budget2","index":15,"n_rows":33,"n_cols":10,"rows_kept":33,"cut":false,"hidden":true,"merged":[]}
[]
[]
[null,null,null,null,null,null,null,null,null,"Care"]
[null,null,null,null,null,null,null,null,null,"support &"]
[null,null,null,null,"Core","Council ","Enhanced","Communal","HB","Super-"]
[null,null,null,"TOTAL","Property","tax","mngmnt","services","ineligible","vision *"]
[]
[null,"INCOME"]
[null,"Core rents receivable",null,{"$f":"SUM(E9:J9)","v":0},{"$f":"('M1'!C38*'M1'!C8+'M1'!F38*'M1'!F8+'M1'!I38*'M1'!I8)*52","v":0},{"$f":"CT!D14","v":0}]
[null,"less voids",null,{"$f":"SUM(E10:J10)","v":0},{"$f":"-'M1'!C8*'M1'!C38*52*(100-'M1'!C10)/100-'M1'!F8*'M1'!F38*52*(100-'M1'!F10)/100-'M1'!I8*'M1'!I38*52*(100-'M1'!I10)/100","v":0},{"$f":"CT!D15","v":0}]
[null,null,null,{"$f":"SUM(D9:D10)","v":0},{"$f":"SUM(E9:E10)","v":0},{"$f":"SUM(F9:F10)","v":0}]
[]
[null,"Service charges receivable",null,{"$f":"SUM(E13:J13)","v":0},null,null,{"$f":"EHM!D30","v":0},{"$f":"Services!D87","v":0},{"$f":"Services!D93","v":0},{"$f":"CSS!D38","v":0}]
[null,"less voids",null,{"$f":"SUM(E14:J14)","v":0},null,null,{"$f":"EHM!D32","v":0},{"$f":"Services!D89","v":0},{"$f":"Services!D95","v":0},{"$f":"CSS!D40","v":0}]
[null,null,null,{"$f":"SUM(D13:D14)","v":0},null,null,{"$f":"SUM(G13:G14)","v":0},{"$f":"SUM(H13:H14)","v":0},0,{"$f":"SUM(J13:J14)","v":0}]
[]
[null,"Contract income",null,{"$f":"SUM(E17:J17)","v":0},null,null,null,null,null,{"$f":"CSS!D30","v":0}]
[null,"Charitable income",null,0,null,null,null,null,null,{"$f":"CSS!D35","v":0}]
[null,"Cross-subsidy",null,0,null,null,null,null,null,{"$f":"CSS!D47","v":0}]
[null,"Total income",null,{"$f":"SUM(D15:D19,D11)","v":0},{"$f":"SUM(E15:E19,E11)","v":0},0,0,0,0,0]
[]
[null,"EXPENDITURE"]
[]
[null,"Bad debts",null,{"$f":"SUM(E24:J24)","v":0},{"$f":"'M1'!C8*'M1'!C38*52*(Prop!F8)/100+'M1'!F8*'M1'!F38*52*(Prop!H8)/100+'M1'!I8*'M1'!I38*52*(Prop!J8)/100","v":0},{"$f":"-CT!D16","v":0},{"$f":"-EHM!D33","v":0},{"$f":"-Services!D90","v":0},{"$f":"-Services!D96","v":0},{"$f":"-CSS!D41","v":0}]
[null,"Services",null,0,null,null,null,{"$f":"Services!D82","v":0},{"$f":"Services!D83","v":0}]
[null,"Enhanced management",null,0,null,null,{"$f":"EHM!D23","v":0}]
[null,"Care and support",null,0,null,null,null,null,null,{"$f":"CSS!D22","v":0}]
[null,"Council tax",null,0,{"$f":"CT!D18","v":0},{"$f":"CT!D17","v":0}]
[null,"Property costs",null,0,{"$f":"Prop!F43+Prop!H43+Prop!J43-E28","v":0}]
[]
[null,"Total expenditure",null,{"$f":"SUM(D24:D30)","v":0},{"$f":"SUM(E24:E30)","v":0},{"$f":"SUM(F24:F30)","v":0},{"$f":"SUM(G24:G30)","v":0},{"$f":"SUM(H24:H30)","v":0},0,0]
[]
[null,"Total expenditure",null,{"$f":"ROUND(D20-D31,0)","v":0},{"$f":"ROUND(E20-E31,0)","v":0},0,0,0,0,0]

{"sheet":"F1","index":16,"n_rows":491,"n_cols":17,"rows_kept":491,"cut":false,"hidden":true,"merged":[[51,8,51,9],[52,8,52,9],[3,3,3,4],[4,3,4,4],[6,3,6,4],[9,5,9,6],[13,1,13,4],[17,1,17,4]]}
[1,"FORMULA RENT CALCULATOR"]
[{"$f":"IF('M1'!C14='M1'!E129,\"F\",\"\")","v":""},"x"]
[null,"INPUTS FOR FORMULA RENT CALCULATION"]
[null,"Unit size",null,{"$f":"IF(A$2=\"F\",'M1'!C12,\"\")","v":""},null,"x"]
[null,"Unit type",null,{"$f":"IF(A$2=\"F\",'M1'!C13,\"\")","v":""},null,"x"]
[]
[null,"1999 valuation method",null,{"$f":"IF(A$2=\"F\",IF('M1'!C19=\"DRC*\",\"DRC\",'M1'!C19),\"\")","v":""},null,{"$f":"IF(D7=\"Manual entry\",\"Enter the 1990 valuation for each unit in the cell below\",IF(D7=\"DRC\",\"The 1999 valuation will be calculated from details entered below\",\"\"))","v":""}]
[null,"1999 valuation             £",null,{"$f":"IF(A$2=\"F\",'M1'!C21,\"\")","v":""},"x",{"$f":"IF(AND(D7=\"DRC\",D8=0),\"DRC method selected - no valuation entry needed\",IF(AND(D7=\"DRC\",D8<>0),\"DRC method has been selected, so the valuation entered will not be used\",IF(AND(D7=\"Manual entry\",D8=0),\"Enter the 1999 valuation\",\"\")))","v":""}]
[]
[null,"Apply \"flexibility\"",null,{"$f":"IF(A$2=\"F\",'M1'!C22,\"\")","v":""},"x",{"$f":"IF(AND($D10=\"Yes\",$D5<>\"\"),VLOOKUP(D5,$B$128:$C$130,COLUMNS($B$128:$C$128),FALSE),\"\")","v":""}]
[null,{"$f":"IF(D10=\"Yes\",\"Optional flexibility\",\"\")","v":""},null,null,{"$f":"IF(AND(D10=\"Yes\",OR(D11=0,D11=F10)),\"Maximum flexibility will be applied\",IF(AND(D10=\"Yes\",D11<F10),\"The lower flexibility entered will be applied\",IF(AND(D10=\"Yes\",D11>F10),\"Flexiility will be limited to the maximum\",\"\")))","v":""}]
[null,null,null,null,null,null,null,null,"Select"]
[null,"Local area for formula rent calculation",null,null,null,null,null,null,"date"]
[null,{"$f":"IF(A2=\"F\",'M1'!C24,\"\")","v":""},null,null,null,null,"FORMULA RENT",null,{"$f":"IF(A2=\"F\",Menu!C5,\"\")","v":""},"£",{"$f":"IF(I14<>\"\",VLOOKUP(I14,N35:Q38,COLUMNS(N35:Q35),FALSE),\"\")","v":""}]
[]
[null,"INPUTS FOR DEPRECIATED REPLACEMENT COST (DRC) VALUATION (optional)"]
[null,"Local area for DRC calculation"]
[null,{"$f":"IF(AND(A2=\"F\",D7=\"DRC\"),'M1'!C34,\"\")","v":""}]
[]
[null,"Floor area of unit",null,{"$f":"IF(D$7=\"DRC\",'M1'!C26,0)","v":0},"x"]
[null,"Plot area",null,{"$f":"IF(D$7=\"DRC\",'M1'!C27,0)","v":0},"x"]
[null,"No. of units on the plot",null,{"$f":"IF(D$7=\"DRC\",'M1'!C28,0)","v":0},"x",{"$f":"IF(AND($D21>0,$D22>=0),\"The 'land area' for this unit is:\",\"\")","v":""},null,null,{"$f":"IF(AND(D21>0,D22=0),D21,IF(AND($D21>0,$D22>0),D21/D22,0))","v":0},{"$f":"IF(AND($D21>0,$D22>=0),\"m²\",\"\")","v":""}]
[null,"New lift?",null,{"$f":"IF(D$7=\"DRC\",'M1'!C29,0)","v":0},"x"]
[null,"Wheelchair access?",null,{"$f":"IF(D$7=\"DRC\",'M1'!C30,0)","v":0},"x","Requiring specialised equipment"]
[null,"Kitchen >10 yrs old?",null,{"$f":"IF(D$7=\"DRC\",'M1'!C31,0)","v":0},"x"]
[null,"Bathroom >15 yrs old?",null,{"$f":"IF(D$7=\"DRC\",'M1'!C32,0)","v":0},"x"]
[]
[null,"FORMULA RENT CALCULATIONS",null,null,null,null,null,null,null,"Infl-","Addition","Formula",null,null,"Infl-","Addition","Formula"]
[null,null,null,null,null,null,null,null,null,"ation",null,"rent £",null,null,"ation",null,"rent £"]
[null,"Average social rent  2000/01",null,null,null,"£",54.62,null,"2000/01",null,null,{"$f":"G48","v":0},null,"2019/20",{"$f":"IF(D$5=B$128,0,IF(D$5=B$129,0,IF(D$5=B$130,2.4,0)))","v":0},{"$f":"IF(D$5=B$130,1,-1)","v":-1},{"$f":"ROUND(L48*SUM(100,O30,P30)/100,2)","v":0}]
[null,"Average valuation  2000/01",null,null,null,"£",49750,null,"2001/02",3.3,1,{"$f":"ROUND(L30*SUM(100,J31,K31)/100,2)","v":0},null,"2020/21",1.7,1,{"$f":"ROUND(Q30*SUM(O31,P31,100)/100,2)","v":0}]
[null,"Average manual earnings 2000/01",null,null,null,"£",316.39999999999998,null,"2002/03",1.7,0.5,{"$f":"ROUND(L31*SUM(100,J32,K32)/100,2)","v":0},null,"2021/22",0.5,1,{"$f":"ROUND(Q31*SUM(O32,P32,100)/100,2)","v":0}]
[null,"Manual earnings for selected area 2000/01",null,null,null,"£",{"$f":"IF(B14=0,0,IF(B14<>\"\",VLOOKUP(B14,$B$73:$C$118,COLUMNS($B$73:$C$73),FALSE),0))","v":0},null,"2003/04",1.7,0.5,0,null,"2022/23",3.1,1,{"$f":"ROUND(Q32*SUM(O33,P33,100)/100,2)","v":0}]
[null,"Unit size multiplier",null,null,null,null,{"$f":"IF(D4=0,0,IF(D4<>\"\",VLOOKUP(D4,$B$120:$C$126,COLUMNS(B120:C120),FALSE),0))","v":0},null,"2004/05",2.8,0.5,0,null,"2023/24",{"$f":"IF(D5=B128,0,10.1)","v":10.1},{"$f":"IF(D5=B128,7,1)","v":1},0]
[null,null,null,null,null,null,null,null,"2005/06",3.1,0.5,0,null,"2024/25",6.7,1,0]
[null,"Adjusted for local earnings and unit size",null,null,null,null,null,null,"2006/07",2.7,0.5,0,null,"2025/26",{"$f":"Ass!D9","v":2.2000000000000002},{"$f":"Ass!D15","v":1},0]
[null,"70% of social rent 2000/01",null,null,null,"£",{"$f":"ROUND(G30*0.7,2)","v":38.229999999999997},null,"2007/08",3.6,0.5,0,null,"2026/27",{"$f":"Ass!D10","v":2},{"$f":"Ass!D16","v":1},0]
[null,"Adjusted for local earnings & unit size",null,null,null,"£",{"$f":"IF(B14=0,0,ROUND(G37*G33/G32*G34,2))","v":0},null,"2008/09",3.9,0.5,0,null,"2027/28",{"$f":"Ass!D11","v":2},{"$f":"Ass!D17","v":1},0]
[null,null,null,null,null,null,null,null,"2009/10",5,0.5,0]
[null,"Adjusted for 2000/01 valuation",null,null,null,null,null,null,"2010/11",-1.4,0.5,0]
[null,"30% of social rent 2000/01",null,null,null,"£",{"$f":"G30-G37","v":16.39},null,"2011/12",4.5999999999999996,0.5,0]
[null,"Valuation",null,null,null,"£",{"$f":"IF(D7=\"DRC\",J57,D8)","v":""},null,"2012/13",5.6,0.5,0]
[null,"Adjusted for valuation",null,null,null,"£",{"$f":"IF(A2=\"F\",ROUND(G41*G42/G31,2),0)","v":0},null,"2013/14",2.6,0.5,0]
[null,null,null,null,null,null,null,null,"2014/15",3.2,0.5,0]
[null,"Total formula rent 2000/02",null,null,null,null,null,null,"2015/16",1.2,1,0]
[null,"Before flexibility",null,null,null,"£",{"$f":"SUM(G43,G38)","v":0},null,"2016/17",{"$f":"IF(D$5=B$128,0,IF(OR(D$5=B$129,$D5=B$130),-0.1,0))","v":0},{"$f":"IF(D$5=B$128,-1,IF(OR(D$5=B$129,$D5=B$130),1,0))","v":0},0]
[null,"Flexibility",null,null,null,null,{"$f":"IF(D5=0,0,IF(D10=\"No\",0,MIN(F10,D11)))","v":0},null,"2017/18",{"$f":"IF(D$5=B$128,0,IF(D$5=B$129,0,IF(D$5=B$130,1,0)))","v":0},{"$f":"IF(D$5=B$130,1,-1)","v":-1},0]
[null,"Including flexibility",null,null,null,"£",{"$f":"ROUND(G46*(100+G47)/100,2)","v":0},null,"2018/19",{"$f":"IF(D$5=B$128,0,IF(D$5=B$129,0,IF(D$5=B$130,3,0)))","v":0},{"$f":"IF(D$5=B$130,1,-1)","v":-1},0]
[]
[null,"DRC CALCULATION"]
[null,"TCI region",null,{"$f":"IF(B18=0,\"\",IF(B18<>\"\",VLOOKUP(B18,$B$132:$C$485,COLUMNS(B132:C132),FALSE),\"\"))","v":""},null,null,"Plot",null,null,{"$f":"IF(I52<2,\"small\",\"large\")","v":"small"},{"$f":"IF(J51=\"small\",\"< 2 hectares\",\">2 haecares\")","v":"< 2 hectares"}]
[null,"Build cost ",null,{"$f":"IF(D51<>\"\",VLOOKUP(D51,$B$487:$C$491,COLUMNS($B$487:$C$487),FALSE),0)","v":0},"per m²",null,"Plot size",null,{"$f":"D21/10000","v":0},null,"hectares"]
[null,"Adjustment for lift",null,{"$f":"IF(D23=\"Yes\",D$52*0.12,0)","v":0},"per m²",null,"Plot area per unit",null,{"$f":"I22/10000","v":0},null,"hectares per unit"]
[null,"Adjust  for wheelchair",null,{"$f":"IF(D24=\"Yes\",D$52*0.12,0)","v":0},"per m²",null,"Land cost",null,"£k",{"$f":"IF(B18=0,\"\",IF(B18=\"\",0,IF(J51=\"small\",VLOOKUP(B18,$B$132:$E$485,COLUMNS($B$132:$D$132),FALSE),VLOOKUP(B18,$B$132:$E$485,COLUMNS($B$132:$E$132),FALSE))))","v":0},"per hectare"]
[null,"Adjust  for kitch/bthrm",null,{"$f":"IF(OR(D25=\"Yes\",D26=\"Yes\"),-D$52*0.1,0)","v":0},"per m²",null,"Land value per unit",null,"£",{"$f":"ROUND(SUM(J54)*I53*1000,0)","v":0}]
[null,"Adjusted build cost",null,{"$f":"ROUND(SUM(D52:D55),0)","v":0},"per m²",null,"Build cost",null,"£",{"$f":"D57","v":0}]
[null,"Build cost ",null,{"$f":"ROUND(D56*D20,0)","v":0},null,null,"Valuation",null,"£",{"$f":"SUM(J55:J56)","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Manual earnings"]
[null,"Avon",321.2,null,null,null,null,null,{"$f":"I30","v":"2000/01"},{"$f":"L30","v":0}]
[null,"Bedfordshire",343.7,null,null,null,null,null,"2001/02",{"$f":"L31","v":0}]
[null,"Berkshire",345.4,null,null,null,null,null,"2002/03",0]
[null,"Buckinghamshire",328.3,null,null,null,null,null,"2003/04",0]
[null,"Cambridgeshire",330.1,null,null,null,null,null,"2004/05",0]
[null,"Cheshire",322,null,null,null,null,null,"2005/06",0]
[null,"Cleveland",338.4,null,null,null,null,null,"2006/07",0]
[null,"Cornwall",255.5,null,null,null,null,null,"2007/08",0]
[null,"Cumbria",323.7,null,null,null,null,null,"2008/09",0]
[null,"Derbyshire",321.10000000000002,null,null,null,null,null,"2009/10",0]
[null,"Devon",278,null,null,null,null,null,"2010/11",0]
[null,"Dorset",293.89999999999998,null,null,null,null,null,"2011/12",0]
[null,"Durham",289.7,null,null,null,null,null,"2012/13",0]
[null,"East Sussex",281.5,null,null,null,null,null,"2013/14",0]
[null,"Essex",325.89999999999998,null,null,null,null,null,"2014/15",0]
[null,"Gloucestershire",308,null,null,null,null,null,"2015/16",0]
[null,"Greater London",354.1,null,null,null,null,null,"2016/17",0]
[null,"Greater Manchester",307.3,null,null,null,null,null,"2017/18",0]
[null,"Hampshire",328.7,null,null,null,null,null,"2018/19",0]
[null,"Hereford & Worcs",289.60000000000002,null,null,null,null,null,{"$f":"N30","v":"2019/20"},{"$f":"Q30","v":0}]
[null,"Hertfordshire",343.7,null,null,null,null,null,{"$f":"N31","v":"2020/21"},{"$f":"Q31","v":0}]
[null,"Humberside",318.39999999999998,null,null,null,null,null,"2021/22",0]
[null,"Isle of Wight",288.5,null,null,null,null,null,"2022/23",0]
[null,"Kent",316.39999999999998,null,null,null,null,null,"2023/24",0]
[null,"Lancashire",302.7,null,null,null,null,null,"2024/25",0]
[null,"Leicestershire",303.10000000000002,null,null,null,null,null,"2025/26",0]
[null,"Lincolnshire",286.7,null,null,null,null,null,"2026/27",0]
[null,"Merseyside",324.89999999999998]
[null,"Norfolk",302.5]
[null,"North Yorkshire",299.60000000000002]
[null,"Northamptonshire",328.5]
[null,"Northumberland",276.10000000000002]
[null,"Nottinghamshire",298]
[null,"Oxfordshire",323.8]
[null,"Shropshire",295.39999999999998]
[null,"Somerset",299.7]
[null,"South Yorkshire",299.10000000000002]
[null,"Staffordshire",296.2]
[null,"Suffolk",304.3]
[null,"Surrey",333.2]
[null,"Tyne & Wear",307.89999999999998]
[null,"Warwickshire",326.10000000000002]
[null,"West Midlands",320.60000000000002]
[null,"West Sussex",332.5]
[null,"West Yorkshire",302.7]
[null,"Wiltshire",313.89999999999998]
[]
[null,"Bedsit/room",0.8]
[null,"1-bed",0.9]
[null,"2-bed",1]
[null,"3-bed",1.1000000000000001]
[null,"4-bed",1.2]
[null,"5-bed",1.3]
[null,"6-bed",1.4]
[]
[null,"General needs",5]
[null,"Supported",10]
[null,"Refuge or almshouse",10]
[]
[null,"Adur ","C",800,750]
[null,"Allerdale ","D",250,197]
[null,"Alnwick ","D",430,310]
[null,"Amber Valley  ","E",520,450]
[null,"Arun ","C",1125,1110]
[null,"Ashfield ","E",350,300]
[null,"Ashford ","C",1020,925]
[null,"Aylesbury Vale ","C",1600,1600]
[null,"Babergh ","D",350,335]
[null,"Barking and Dagenham ","B",1385,1600]
[null,"Barnet ","A",3800,3500]
[null,"Barnsley  ","D",550,375]
[null,"Barrow-in-Furness  ","C",425,375]
[null,"Basildon  ","C",1025,988]
[null,"Basingstoke and Deane ","B",1720,1720]
[null,"Bassetlaw ","D",400,300]
[null,"Bath and North East Somerset ","C",1500,1400]
[null,"Berwick-upon-Tweed ","D",370,245]
[null,"Bexley ","B",2000,1600]
[null,"Birmingham  ","C",890,890]
[null,"Blaby ","D",750,700]
[null,"Blackburn  ","D",470,325]
[null,"Blackpool  ","D",750,675]
[null,"Blyth Valley  ","D",245,200]
[null,"Bolsover ","E",325,250]
[null,"Bolton  ","D",550,500]
[null,"Boston  ","E",270,185]
[null,"Bournemouth  ","C",1600,1500]
[null,"Bracknell Forest  ","B",2000,2000]
[null,"Bradford  ","D",600,525]
[null,"Braintree  ","D",800,750]
[null,"Breckland ","E",325,275]
[null,"Brent ","A",2300,3000]
[null,"Brentwood  ","B",1555,1400]
[null,"Bridgnorth ","D",750,715]
[null,"Brighton and Hove ","C",1200,1000]
[null,"Bristol  ","C",1350,1350]
[null,"Broadland ","D",325,275]
[null,"Bromley ","B",2000,2470]
[null,"Bromsgrove ","C",1235,1350]
[null,"Broxbourne ","B",2200,2000]
[null,"Broxtowe ","D",680,625]
[null,"Burnley  ","D",470,310]
[null,"Bury ","D",550,500]
[null,"Calderdale ","D",550,450]
[null,"Cambridge  ","B",1480,2200]
[null,"Camden  ","A",9000,5500]
[null,"Cannock Chase ","D",900,950]
[null,"Canterbury  ","C",1850,1350]
[null,"Caradon ","D",200,220]
[null,"Carlisle  ","D",360,270]
[null,"Carrick ","D",400,350]
[null,"Castle Morpeth ","D",450,370]
[null,"Castle Point ","C",1200,1300]
[null,"Charnwood ","D",800,800]
[null,"Chelmsford  ","C",1280,1225]
[null,"Cheltenham  ","C",1500,1500]
[null,"Cherwell ","C",1000,900]
[null,"Chester  ","C",645,825]
[null,"Chesterfield  ","D",495,325]
[null,"Chester-le-Street  ","D",494,494]
[null,"Chichester  ","C",1850,1750]
[null,"Chiltern ","B",2500,2500]
[null,"Chorley  ","D",775,625]
[null,"Christchurch  ","C",1600,1500]
[null,"City of London ","A",20500,20500]
[null,"City of Westminster ","A",20500,20500]
[null,"Colchester  ","C",900,900]
[null,"Congleton ","D",540,500]
[null,"Copeland ","D",200,150]
[null,"Corby  ","D",350,350]
[null,"Cotswold ","C",1350,1350]
[null,"Coventry  ","D",950,850]
[null,"Craven ","D",525,500]
[null,"Crawley  ","B",1200,1200]
[null,"Crewe and Nantwich ","D",350,300]
[null,"Croydon ","B",2000,2000]
[null,"Dacorum ","B",1900,2250]
[null,"Darlington  ","D",500,500]
[null,"Dartford  ","C",1100,1100]
[null,"Daventry ","D",740,740]
[null,"Derby  ","E",600,550]
[null,"Derbyshire Dales ","D",550,490]
[null,"Derwentside ","D",315,275]
[null,"Doncaster  ","D",625,425]
[null,"Dover  ","C",700,450]
[null,"Dudley  ","D",950,1000]
[null,"Durham  ","C",650,600]
[null,"Ealing ","A",3100,3200]
[null,"Easington ","D",350,215]
[null,"East Cambridgeshire  ","D",615,565]
[null,"East Devon  ","C",893,819]
[null,"East Dorset  ","C",1400,1300]
[null,"East Hampshire ","B",1500,1500]
[null,"East Hertfordshire  ","B",1400,1350]
[null,"East Lindsey ","E",410,250]
[null,"East Northamptonshire  ","D",570,570]
[null,"East Riding ","D",610,550]
[null,"East Staffordshire  ","D",700,475]
[null,"Eastbourne  ","C",875,750]
[null,"Eastleigh  ","C",1440,1250]
[null,"Eden  ","D",320,270]
[null,"Ellesmere Port and Neston ","D",360,350]
[null,"Elmbridge ","B",1800,1500]
[null,"Enfield  ","B",3000,2800]
[null,"Epping Forest  ","B",1600,1480]
[null,"Epsom and Ewell  ","B",1450,1400]
[null,"Erewash ","D",540,460]
[null,"Exeter  ","D",1103,987]
[null,"Fareham  ","C",1400,1200]
[null,"Fenland ","E",225,210]
[null,"Forest Heath ","D",320,300]
[null,"Forest of Dean  ","D",740,740]
[null,"Fylde ","C",800,750]
[null,"Gateshead  ","D",500,450]
[null,"Gedling ","D",675,600]
[null,"Gloucester  ","D",1100,1100]
[null,"Gosport  ","C",1025,1000]
[null,"Gravesham ","C",825,825]
[null,"Great Yarmouth ","E",325,275]
[null,"Greenwich  ","B",2000,1700]
[null,"Guildford  ","B",2250,2250]
[null,"Hackney ","A",2500,2500]
[null,"Halton ","D",500,450]
[null,"Hambleton ","D",800,800]
[null,"Hammersmith and Fulham ","A",5000,2550]
[null,"Harborough ","D",750,800]
[null,"Haringey ","A",2500,2500]
[null,"Harlow  ","B",1025,988]
[null,"Harrogate  ","C",850,1000]
[null,"Harrow  ","A",2500,3400]
[null,"Hart ","B",1720,1720]
[null,"Hartlepool  ","D",500,475]
[null,"Hastings  ","D",375,275]
[null,"Havant ","C",1200,1100]
[null,"Havering ","B",1736,2000]
[null,"Herefordshire ","D",600,570]
[null,"Hertsmere ","B",1900,2250]
[null,"High Peak  ","D",440,440]
[null,"Hillingdon ","A",2300,3000]
[null,"Hinckley and Bosworth ","E",850,750]
[null,"Horsham ","C",1450,1425]
[null,"Hounslow ","A",3100,3200]
[null,"Huntingdonshire ","D",890,890]
[null,"Hyndburn ","D",470,235]
[null,"Ipswich  ","D",650,630]
[null,"Isle Of Wight  ","D",475,360]
[null,"Isles of Scilly ","A",1480,2200]
[null,"Islington ","A",5250,5250]
[null,"Kennet ","C",700,700]
[null,"Kensington and Chelsea ","A",27000,17500]
[null,"Kerrier ","D",300,265]
[null,"Kettering  ","D",618,618]
[null,"King's Lynn and West Norfolk ","D",325,275]
[null,"Kingston upon Hull ","D",475,375]
[null,"Kingston upon Thames ","A",2350,2350]
[null,"Kirklees ","D",615,475]
[null,"Knowsley ","D",400,350]
[null,"Lambeth ","A",2100,2100]
[null,"Lancaster  ","D",800,750]
[null,"Leeds  ","C",1000,975]
[null,"Leicester  ","D",750,700]
[null,"Lewes ","C",900,900]
[null,"Lewisham ","B",1600,1600]
[null,"Lichfield  ","D",1100,900]
[null,"Lincoln  ","D",500,375]
[null,"Liverpool  ","C",700,650]
[null,"Luton  ","C",1000,"  "]
[null,"Macclesfield ","C",700,550]
[null,"Maidstone  ","C",1250,1250]
[null,"Maldon ","C",700,900]
[null,"Malvern Hills District ","D",820,795]
[null,"Manchester  ","C",1000,800]
[null,"Mansfield  ","E",320,300]
[null,"Melton ","D",775,725]
[null,"Mendip ","D",600,550]
[null,"Merton ","A",2500,2500]
[null,"Mid Bedfordshire ","C",1050,1050]
[null,"Mid Devon ","D",683,612]
[null,"Mid Suffolk ","E",308,300]
[null,"Mid Sussex ","B",1000,1050]
[null,"Middlesbrough  ","D",425,450]
[null,"Milton Keynes  ","C",1500,1500]
[null,"Mole Valley  ","B",975,1425]
[null,"New Forest  ","C",1280,1400]
[null,"Newark and Sherwood ","E",425,340]
[null,"Newbury ","C",1600,1600]
[null,"Newcastle upon Tyne  ","D",800,800]
[null,"Newcastle-under-Lyme  ","D",450,325]
[null,"Newham ","B",1545,1425]
[null,"North Bedfordshire  ","C",1000,1000]
[null,"North Cornwall  ","D",320,290]
[null,"North Devon  ","C",683,612]
[null,"North Dorset  ","C",950,915]
[null,"North East Derbyshire ","D",450,270]
[null,"North East Lincolnshire ","D",410,350]
[null,"North Hertfordshire  ","B",1200,1100]
[null,"North Kesteven  ","D",340,250]
[null,"North Lincolnshire  ","E",410,350]
[null,"North Norfolk  ","E",350,300]
[null,"North Shropshire  ","D",495,495]
[null,"North Tyneside  ","C",600,800]
[null,"North Warwickshire  ","D",725,600]
[null,"North West Leicestershire ","D",750,750]
[null,"North West Somerset ","C",1100,950]
[null,"North Wiltshire ","C",950,950]
[null,"Northampton  ","D",800,800]
[null,"Norwich  ","D",600,550]
[null,"Nottingham City  ","D",700,620]
[null,"Nuneaton and Bedworth ","E",700,600]
[null,"Oadby and Wigston ","D",750,700]
[null,"Oldham  ","D",675,625]
[null,"Oswestry ","D",490,445]
[null,"Oxford  ","B",3500,3350]
[null,"Pendle ","D",470,270]
[null,"Penwith ","D",330,300]
[null,"Peterborough  ","D",590,565]
[null,"Plymouth  ","D",683,525]
[null,"Poole  ","C",1600,1500]
[null,"Portsmouth  ","C",1000,900]
[null,"Preston  ","D",775,625]
[null,"Purbeck ","C",1000,950]
[null,"Reading  ","C",1950,1950]
[null,"Redbridge ","B",1650,1650]
[null,"Redcar and Cleveland ","D",375,400]
[null,"Redditch  ","D",810,775]
[null,"Reigate and Banstead ","B",1780,1750]
[null,"Restormel ","D",330,300]
[null,"Ribble Valley  ","C",675,625]
[null,"Richmond upon Thames ","A",2600,2600]
[null,"Richmondshire ","D",600,540]
[null,"Rochdale  ","D",650,650]
[null,"Rochford ","C",900,1100]
[null,"Rossendale ","D",475,265]
[null,"Rother ","D",740,700]
[null,"Rotherham  ","D",460,440]
[null,"Rugby  ","D",800,700]
[null,"Runnymede  ","B",2300,2300]
[null,"Rushcliffe ","D",800,745]
[null,"Rushmoor ","B",1720,1720]
[null,"Rutland  ","D",800,675]
[null,"Ryedale ","D",500,400]
[null,"Salford  ","D",500,450]
[null,"Salisbury  ","C",1050,1050]
[null,"Sandwell ","D",570,480]
[null,"Scarborough  ","D",400,350]
[null,"Sedgefield ","D",350,300]
[null,"Sedgemoor  ","D",450,440]
[null,"Sefton ","D",500,425]
[null,"Selby ","D",450,350]
[null,"Sevenoaks ","B",1600,1600]
[null,"Sheffield  ","C",630,540]
[null,"Shepway ","D",865,650]
[null,"Shrewsbury and Atcham ","D",650,765]
[null,"Slough  ","B",1950,1950]
[null,"Solihull  ","C",1800,1650]
[null,"South Bedfordshire  ","C",1100,1100]
[null,"South Bucks ","A",2750,2750]
[null,"South Cambridgeshire  ","C",1130,1025]
[null,"South Derbyshire  ","D",460,375]
[null,"South Gloucestershire  ","D",1300,1200]
[null,"South Hams ","C",716,625]
[null,"South Holland  ","E",325,300]
[null,"South Kesteven  ","E",375,250]
[null,"South Lakeland  ","C",675,575]
[null,"South Norfolk  ","E",350,300]
[null,"South Northamptonshire  ","D",865,865]
[null,"South Oxfordshire  ","C",1250,1200]
[null,"South Ribble  ","D",775,625]
[null,"South Shropshire  ","D",495,445]
[null,"South Somerset  ","D",1000,900]
[null,"South Staffordshire  ","D",950,1000]
[null,"South Tyneside  ","D",500,450]
[null,"Southampton  ","C",1400,1020]
[null,"Southend-on-Sea  ","C",990,920]
[null,"Southwark ","A",2300,2300]
[null,"Spelthorne ","B",1780,1750]
[null,"St. Albans  ","B",1900,2250]
[null,"St. Edmundsbury ","D",650,650]
[null,"St. Helens  ","D",500,410]
[null,"Stafford  ","D",600,425]
[null,"Staffordshire Moorlands ","D",450,325]
[null,"Stevenage  ","B",1400,1250]
[null,"Stockport  ","C",1350,1350]
[null,"Stockton-on-Tees  ","D",500,500]
[null,"Stoke-on-Trent  ","D",450,325]
[null,"Stratford-on-Avon ","C",1450,1400]
[null,"Stroud ","D",850,850]
[null,"Suffolk Coastal ","D",410,400]
[null,"Sunderland  ","D",475,425]
[null,"Surrey Heath ","B",2200,2200]
[null,"Sutton ","B",1900,2470]
[null,"Swale ","C",890,710]
[null,"Tameside ","C",600,490]
[null,"Tamworth  ","D",750,575]
[null,"Tandridge ","B",1780,1750]
[null,"Taunton Deane ","D",925,875]
[null,"Teesdale ","D",325,300]
[null,"Teignbridge ","D",893,819]
[null,"Tendring ","D",600,400]
[null,"Test Valley  ","C",1250,1100]
[null,"Tewkesbury  ","D",1100,1100]
[null,"Thamesdown ","C",850,1050]
[null,"Thanet ","C",700,450]
[null,"The Medway Towns ","C",750,730]
[null,"The Wrekin ","D",500,550]
[null,"Three Rivers ","A",1900,2250]
[null,"Thurrock  ","C",640,555]
[null,"Tonbridge and Malling ","B",1500,1500]
[null,"Torbay  ","D",914,840]
[null,"Torridge ","D",525,478]
[null,"Tower Hamlets ","A",2475,2225]
[null,"Trafford ","C",925,855]
[null,"Tunbridge Wells ","C",1600,1600]
[null,"Tynedale ","D",495,400]
[null,"Uttlesford ","C",1200,1100]
[null,"Vale of White Horse ","C",1200,1150]
[null,"Vale Royal ","D",575,500]
[null,"Wakefield  ","D",700,500]
[null,"Walsall  ","D",975,1025]
[null,"Waltham Forest  ","B",1650,1650]
[null,"Wandsworth ","A",2900,2900]
[null,"Wansbeck ","D",245,200]
[null,"Warrington  ","D",940,700]
[null,"Warwick  ","C",1900,1800]
[null,"Watford  ","B",1900,2250]
[null,"Waveney ","E",320,320]
[null,"Waverley  ","B",2000,2000]
[null,"Wealden ","C",1040,875]
[null,"Wear Valley  ","D",400,300]
[null,"Wellingborough ","D",679,679]
[null,"Welwyn Hatfield ","B",1400,1200]
[null,"West Devon  ","D",680,650]
[null,"West Dorset  ","C",925,875]
[null,"West Lancashire  ","C",775,625]
[null,"West Lindsey ","E",210,135]
[null,"West Oxfordshire  ","C",1200,1100]
[null,"West Somerset  ","D",620,580]
[null,"West Wiltshire ","C",800,950]
[null,"Weymouth and Portland ","C",850,800]
[null,"Wigan  ","D",550,450]
[null,"Winchester  ","B",1720,1720]
[null,"Windsor and Maidenhead ","B",2100,2100]
[null,"Wirral ","D",360,360]
[null,"Woking  ","B",2150,2150]
[null,"Wokingham ","B",2000,2000]
[null,"Wolverhampton  ","D",900,950]
[null,"Worcester City  ","D",820,775]
[null,"Worthing  ","C",950,900]
[null,"Wychavon ","D",830,765]
[null,"Wycombe ","B",2100,2100]
[null,"Wyre ","D",800,750]
[null,"Wyre Forest  ","D",1050,1175]
[null,"York  ","C",800,750]
[]
[null,"A",871]
[null,"B",799]
[null,"C",761]
[null,"D",737]
[null,"E",707]

{"sheet":"F2","index":17,"n_rows":491,"n_cols":17,"rows_kept":491,"cut":false,"hidden":true,"merged":[[51,8,51,9],[52,8,52,9],[3,3,3,4],[4,3,4,4],[6,3,6,4],[9,5,9,6],[13,1,13,4],[17,1,17,4]]}
[1,"FORMULA RENT CALCULATOR"]
[{"$f":"IF('M1'!F14='M1'!E129,\"F\",\"\")","v":""},"x"]
[null,"INPUTS FOR FORMULA RENT CALCULATION"]
[null,"Unit size",null,{"$f":"IF(A$2=\"F\",'M1'!F12,\"\")","v":""},null,"x"]
[null,"Unit type",null,{"$f":"IF(A$2=\"F\",'M1'!F13,\"\")","v":""},null,"x"]
[]
[null,"1999 valuation method",null,{"$f":"IF(A$2=\"F\",IF('M1'!F19=\"DRC*\",\"DRC\",'M1'!F19),\"\")","v":""},null,"x"]
[null,"1999 valuation             £",null,{"$f":"IF(A$2=\"F\",'M1'!F21,\"\")","v":""},"x",{"$f":"IF(AND(D7=\"DRC\",D8=0),\"DRC method selected - no valuation entry needed\",IF(AND(D7=\"DRC\",D8<>0),\"DRC method has been selected, so the valuation entered will not be used\",IF(AND(D7=\"Manual entry\",D8=0),\"Enter the 1999 valuation\",\"\")))","v":""}]
[]
[null,"Apply \"flexibility\"",null,{"$f":"IF(A$2=\"F\",'M1'!F22,\"\")","v":""},"x",{"$f":"IF(AND($D10=\"Yes\",$D5<>\"\"),VLOOKUP(D5,$B$128:$C$130,COLUMNS($B$128:$C$128),FALSE),\"\")","v":""}]
[null,{"$f":"IF(D10=\"Yes\",\"Optional flexibility\",\"\")","v":""},null,null,{"$f":"IF(AND(D10=\"Yes\",OR(D11=0,D11=F10)),\"Maximum flexibility will be applied\",IF(AND(D10=\"Yes\",D11<F10),\"The lower flexibility entered will be applied\",IF(AND(D10=\"Yes\",D11>F10),\"Flexiility will be limited to the maximum\",\"\")))","v":""}]
[null,null,null,null,null,null,null,null,"Select"]
[null,"Local area for formula rent calculation",null,null,null,null,null,null,"date"]
[null,{"$f":"IF(A2=\"F\",'M1'!C24,\"\")","v":""},null,null,null,null,"FORMULA RENT",null,{"$f":"IF(A2=\"F\",Menu!C5,\"\")","v":""},"£",{"$f":"IF(I14<>\"\",VLOOKUP(I14,N35:Q38,COLUMNS(N35:Q35),FALSE),\"\")","v":""}]
[]
[null,"INPUTS FOR DEPRECIATED REPLACEMENT COST (DRC) VALUATION (optional)"]
[null,"Local area for DRC calculation"]
[null,{"$f":"IF(AND(A2=\"F\",D7=\"DRC\"),'M1'!C34,\"\")","v":""}]
[]
[null,"Floor area of unit",null,{"$f":"IF(D$7=\"DRC\",'M1'!F26,0)","v":0},"x"]
[null,"Plot area",null,{"$f":"IF(D$7=\"DRC\",'M1'!F27,0)","v":0},"x"]
[null,"No. of units on the plot",null,{"$f":"IF(D$7=\"DRC\",'M1'!F28,0)","v":0},"x",{"$f":"IF(AND($D21>0,$D22>=0),\"The 'land area' for this unit is:\",\"\")","v":""},null,null,{"$f":"IF(AND(D21>0,D22=0),D21,IF(AND($D21>0,$D22>0),D21/D22,0))","v":0},{"$f":"IF(AND($D21>0,$D22>=0),\"m²\",\"\")","v":""}]
[null,"New lift?",null,{"$f":"IF(D$7=\"DRC\",'M1'!F29,0)","v":0},"x"]
[null,"Wheelchair access?",null,{"$f":"IF(D$7=\"DRC\",'M1'!F30,0)","v":0},"x","Requiring specialised equipment"]
[null,"Kitchen >10 yrs old?",null,{"$f":"IF(D$7=\"DRC\",'M1'!F31,0)","v":0},"x"]
[null,"Bathroom >15 yrs old?",null,{"$f":"IF(D$7=\"DRC\",'M1'!F32,0)","v":0},"x"]
[]
[null,"FORMULA RENT CALCULATIONS",null,null,null,null,null,null,null,"Infl-","Addition","Formula",null,null,"Infl-","Addition","Formula"]
[null,null,null,null,null,null,null,null,null,"ation",null,"rent £",null,null,"ation",null,"rent £"]
[null,"Average social rent  2000/01",null,null,null,"£",54.62,null,"2000/01",null,null,{"$f":"G48","v":0},null,"2019/20",{"$f":"IF(D$5=B$128,0,IF(D$5=B$129,0,IF(D$5=B$130,2.4,0)))","v":0},{"$f":"IF(D$5=B$130,1,-1)","v":-1},{"$f":"ROUND(L48*SUM(100,O30,P30)/100,2)","v":0}]
[null,"Average valuation  2000/01",null,null,null,"£",49750,null,"2001/02",3.3,1,{"$f":"ROUND(L30*SUM(100,J31,K31)/100,2)","v":0},null,"2020/21",1.7,1,{"$f":"ROUND(Q30*SUM(O31,P31,100)/100,2)","v":0}]
[null,"Average manual earnings 2000/01",null,null,null,"£",316.39999999999998,null,"2002/03",1.7,0.5,{"$f":"ROUND(L31*SUM(100,J32,K32)/100,2)","v":0},null,"2021/22",0.5,1,{"$f":"ROUND(Q31*SUM(O32,P32,100)/100,2)","v":0}]
[null,"Manual earnings for selected area 2000/01",null,null,null,"£",{"$f":"IF(B14=0,0,IF(B14<>\"\",VLOOKUP(B14,$B$73:$C$118,COLUMNS($B$73:$C$73),FALSE),0))","v":0},null,"2003/04",1.7,0.5,0,null,"2022/23",3.1,1,{"$f":"ROUND(Q32*SUM(O33,P33,100)/100,2)","v":0}]
[null,"Unit size multiplier",null,null,null,null,{"$f":"IF(D4=0,0,IF(D4<>\"\",VLOOKUP(D4,$B$120:$C$126,COLUMNS(B120:C120),FALSE),0))","v":0},null,"2004/05",2.8,0.5,0,null,"2023/24",{"$f":"IF(D5=B128,0,10.1)","v":10.1},{"$f":"IF(D5=B128,7,1)","v":1},0]
[null,null,null,null,null,null,null,null,"2005/06",3.1,0.5,0,null,"2024/25",6.7,1,0]
[null,"Adjusted for local earnings and unit size",null,null,null,null,null,null,"2006/07",2.7,0.5,0,null,"2025/26",{"$f":"Ass!D9","v":2.2000000000000002},{"$f":"Ass!D15","v":1},0]
[null,"70% of social rent 2000/01",null,null,null,"£",{"$f":"ROUND(G30*0.7,2)","v":38.229999999999997},null,"2007/08",3.6,0.5,0,null,"2026/27",{"$f":"Ass!D10","v":2},{"$f":"Ass!D16","v":1},0]
[null,"Adjusted for local earnings & unit size",null,null,null,"£",{"$f":"IF(B14=0,0,ROUND(G37*G33/G32*G34,2))","v":0},null,"2008/09",3.9,0.5,0,null,"2027/28",{"$f":"Ass!D11","v":2},{"$f":"Ass!D17","v":1},0]
[null,null,null,null,null,null,null,null,"2009/10",5,0.5,0]
[null,"Adjusted for 2000/01 valuation",null,null,null,null,null,null,"2010/11",-1.4,0.5,0]
[null,"30% of social rent 2000/01",null,null,null,"£",{"$f":"G30-G37","v":16.39},null,"2011/12",4.5999999999999996,0.5,0]
[null,"Valuation",null,null,null,"£",{"$f":"IF(D7=\"DRC\",J57,D8)","v":""},null,"2012/13",5.6,0.5,0]
[null,"Adjusted for valuation",null,null,null,"£",{"$f":"IF(A2=\"F\",ROUND(G41*G42/G31,2),0)","v":0},null,"2013/14",2.6,0.5,0]
[null,null,null,null,null,null,null,null,"2014/15",3.2,0.5,0]
[null,"Total formula rent 2000/02",null,null,null,null,null,null,"2015/16",1.2,1,0]
[null,"Before flexibility",null,null,null,"£",{"$f":"SUM(G43,G38)","v":0},null,"2016/17",{"$f":"IF(D$5=B$128,0,IF(OR(D$5=B$129,$D5=B$130),-0.1,0))","v":0},{"$f":"IF(D$5=B$128,-1,IF(OR(D$5=B$129,$D5=B$130),1,0))","v":0},0]
[null,"Flexibility",null,null,null,null,{"$f":"IF(D5=0,0,IF(D10=\"No\",0,MIN(F10,D11)))","v":0},null,"2017/18",{"$f":"IF(D$5=B$128,0,IF(D$5=B$129,0,IF(D$5=B$130,1,0)))","v":0},{"$f":"IF(D$5=B$130,1,-1)","v":-1},0]
[null,"Including flexibility",null,null,null,"£",{"$f":"ROUND(G46*(100+G47)/100,2)","v":0},null,"2018/19",{"$f":"IF(D$5=B$128,0,IF(D$5=B$129,0,IF(D$5=B$130,3,0)))","v":0},{"$f":"IF(D$5=B$130,1,-1)","v":-1},0]
[]
[null,"DRC CALCULATION"]
[null,"TCI region",null,{"$f":"IF(B18=0,\"\",IF(B18<>\"\",VLOOKUP(B18,$B$132:$C$485,COLUMNS(B132:C132),FALSE),\"\"))","v":""},null,null,"Plot",null,null,{"$f":"IF(I52<2,\"small\",\"large\")","v":"small"},{"$f":"IF(J51=\"small\",\"< 2 hectares\",\">2 haecares\")","v":"< 2 hectares"}]
[null,"Build cost ",null,{"$f":"IF(D51<>\"\",VLOOKUP(D51,$B$487:$C$491,COLUMNS($B$487:$C$487),FALSE),0)","v":0},"per m²",null,"Plot size",null,{"$f":"D21/10000","v":0},null,"hectares"]
[null,"Adjustment for lift",null,{"$f":"IF(D23=\"Yes\",D$52*0.12,0)","v":0},"per m²",null,"Plot area per unit",null,{"$f":"I22/10000","v":0},null,"hectares per unit"]
[null,"Adjust  for wheelchair",null,{"$f":"IF(D24=\"Yes\",D$52*0.12,0)","v":0},"per m²",null,"Land cost",null,"£k",{"$f":"IF(B18=0,\"\",IF(B18=\"\",0,IF(J51=\"small\",VLOOKUP(B18,$B$132:$E$485,COLUMNS($B$132:$D$132),FALSE),VLOOKUP(B18,$B$132:$E$485,COLUMNS($B$132:$E$132),FALSE))))","v":0},"per hectare"]
[null,"Adjust  for kitch/bthrm",null,{"$f":"IF(OR(D25=\"Yes\",D26=\"Yes\"),-D$52*0.1,0)","v":0},"per m²",null,"Land value per unit",null,"£",{"$f":"ROUND(SUM(J54)*I53*1000,0)","v":0}]
[null,"Adjusted build cost",null,{"$f":"ROUND(SUM(D52:D55),0)","v":0},"per m²",null,"Build cost",null,"£",{"$f":"D57","v":0}]
[null,"Build cost ",null,{"$f":"ROUND(D56*D20,0)","v":0},null,null,"Valuation",null,"£",{"$f":"SUM(J55:J56)","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Manual earnings"]
[null,"Avon",321.2,null,null,null,null,null,{"$f":"I30","v":"2000/01"},{"$f":"L30","v":0}]
[null,"Bedfordshire",343.7,null,null,null,null,null,"2001/02",{"$f":"L31","v":0}]
[null,"Berkshire",345.4,null,null,null,null,null,"2002/03",0]
[null,"Buckinghamshire",328.3,null,null,null,null,null,"2003/04",0]
[null,"Cambridgeshire",330.1,null,null,null,null,null,"2004/05",0]
[null,"Cheshire",322,null,null,null,null,null,"2005/06",0]
[null,"Cleveland",338.4,null,null,null,null,null,"2006/07",0]
[null,"Cornwall",255.5,null,null,null,null,null,"2007/08",0]
[null,"Cumbria",323.7,null,null,null,null,null,"2008/09",0]
[null,"Derbyshire",321.10000000000002,null,null,null,null,null,"2009/10",0]
[null,"Devon",278,null,null,null,null,null,"2010/11",0]
[null,"Dorset",293.89999999999998,null,null,null,null,null,"2011/12",0]
[null,"Durham",289.7,null,null,null,null,null,"2012/13",0]
[null,"East Sussex",281.5,null,null,null,null,null,"2013/14",0]
[null,"Essex",325.89999999999998,null,null,null,null,null,"2014/15",0]
[null,"Gloucestershire",308,null,null,null,null,null,"2015/16",0]
[null,"Greater London",354.1,null,null,null,null,null,"2016/17",0]
[null,"Greater Manchester",307.3,null,null,null,null,null,"2017/18",0]
[null,"Hampshire",328.7,null,null,null,null,null,"2018/19",0]
[null,"Hereford & Worcs",289.60000000000002,null,null,null,null,null,{"$f":"N30","v":"2019/20"},{"$f":"Q30","v":0}]
[null,"Hertfordshire",343.7,null,null,null,null,null,{"$f":"N31","v":"2020/21"},{"$f":"Q31","v":0}]
[null,"Humberside",318.39999999999998,null,null,null,null,null,"2021/22",0]
[null,"Isle of Wight",288.5,null,null,null,null,null,"2022/23",0]
[null,"Kent",316.39999999999998,null,null,null,null,null,"2023/24",0]
[null,"Lancashire",302.7,null,null,null,null,null,"2024/25",0]
[null,"Leicestershire",303.10000000000002,null,null,null,null,null,"2025/26",0]
[null,"Lincolnshire",286.7,null,null,null,null,null,"2026/27",0]
[null,"Merseyside",324.89999999999998]
[null,"Norfolk",302.5]
[null,"North Yorkshire",299.60000000000002]
[null,"Northamptonshire",328.5]
[null,"Northumberland",276.10000000000002]
[null,"Nottinghamshire",298]
[null,"Oxfordshire",323.8]
[null,"Shropshire",295.39999999999998]
[null,"Somerset",299.7]
[null,"South Yorkshire",299.10000000000002]
[null,"Staffordshire",296.2]
[null,"Suffolk",304.3]
[null,"Surrey",333.2]
[null,"Tyne & Wear",307.89999999999998]
[null,"Warwickshire",326.10000000000002]
[null,"West Midlands",320.60000000000002]
[null,"West Sussex",332.5]
[null,"West Yorkshire",302.7]
[null,"Wiltshire",313.89999999999998]
[]
[null,"Bedsit/room",0.8]
[null,"1-bed",0.9]
[null,"2-bed",1]
[null,"3-bed",1.1000000000000001]
[null,"4-bed",1.2]
[null,"5-bed",1.3]
[null,"6-bed",1.4]
[]
[null,"General needs",5]
[null,"Supported",10]
[null,"Refuge or almshouse",10]
[]
[null,"Adur ","C",800,750]
[null,"Allerdale ","D",250,197]
[null,"Alnwick ","D",430,310]
[null,"Amber Valley  ","E",520,450]
[null,"Arun ","C",1125,1110]
[null,"Ashfield ","E",350,300]
[null,"Ashford ","C",1020,925]
[null,"Aylesbury Vale ","C",1600,1600]
[null,"Babergh ","D",350,335]
[null,"Barking and Dagenham ","B",1385,1600]
[null,"Barnet ","A",3800,3500]
[null,"Barnsley  ","D",550,375]
[null,"Barrow-in-Furness  ","C",425,375]
[null,"Basildon  ","C",1025,988]
[null,"Basingstoke and Deane ","B",1720,1720]
[null,"Bassetlaw ","D",400,300]
[null,"Bath and North East Somerset ","C",1500,1400]
[null,"Berwick-upon-Tweed ","D",370,245]
[null,"Bexley ","B",2000,1600]
[null,"Birmingham  ","C",890,890]
[null,"Blaby ","D",750,700]
[null,"Blackburn  ","D",470,325]
[null,"Blackpool  ","D",750,675]
[null,"Blyth Valley  ","D",245,200]
[null,"Bolsover ","E",325,250]
[null,"Bolton  ","D",550,500]
[null,"Boston  ","E",270,185]
[null,"Bournemouth  ","C",1600,1500]
[null,"Bracknell Forest  ","B",2000,2000]
[null,"Bradford  ","D",600,525]
[null,"Braintree  ","D",800,750]
[null,"Breckland ","E",325,275]
[null,"Brent ","A",2300,3000]
[null,"Brentwood  ","B",1555,1400]
[null,"Bridgnorth ","D",750,715]
[null,"Brighton and Hove ","C",1200,1000]
[null,"Bristol  ","C",1350,1350]
[null,"Broadland ","D",325,275]
[null,"Bromley ","B",2000,2470]
[null,"Bromsgrove ","C",1235,1350]
[null,"Broxbourne ","B",2200,2000]
[null,"Broxtowe ","D",680,625]
[null,"Burnley  ","D",470,310]
[null,"Bury ","D",550,500]
[null,"Calderdale ","D",550,450]
[null,"Cambridge  ","B",1480,2200]
[null,"Camden  ","A",9000,5500]
[null,"Cannock Chase ","D",900,950]
[null,"Canterbury  ","C",1850,1350]
[null,"Caradon ","D",200,220]
[null,"Carlisle  ","D",360,270]
[null,"Carrick ","D",400,350]
[null,"Castle Morpeth ","D",450,370]
[null,"Castle Point ","C",1200,1300]
[null,"Charnwood ","D",800,800]
[null,"Chelmsford  ","C",1280,1225]
[null,"Cheltenham  ","C",1500,1500]
[null,"Cherwell ","C",1000,900]
[null,"Chester  ","C",645,825]
[null,"Chesterfield  ","D",495,325]
[null,"Chester-le-Street  ","D",494,494]
[null,"Chichester  ","C",1850,1750]
[null,"Chiltern ","B",2500,2500]
[null,"Chorley  ","D",775,625]
[null,"Christchurch  ","C",1600,1500]
[null,"City of London ","A",20500,20500]
[null,"City of Westminster ","A",20500,20500]
[null,"Colchester  ","C",900,900]
[null,"Congleton ","D",540,500]
[null,"Copeland ","D",200,150]
[null,"Corby  ","D",350,350]
[null,"Cotswold ","C",1350,1350]
[null,"Coventry  ","D",950,850]
[null,"Craven ","D",525,500]
[null,"Crawley  ","B",1200,1200]
[null,"Crewe and Nantwich ","D",350,300]
[null,"Croydon ","B",2000,2000]
[null,"Dacorum ","B",1900,2250]
[null,"Darlington  ","D",500,500]
[null,"Dartford  ","C",1100,1100]
[null,"Daventry ","D",740,740]
[null,"Derby  ","E",600,550]
[null,"Derbyshire Dales ","D",550,490]
[null,"Derwentside ","D",315,275]
[null,"Doncaster  ","D",625,425]
[null,"Dover  ","C",700,450]
[null,"Dudley  ","D",950,1000]
[null,"Durham  ","C",650,600]
[null,"Ealing ","A",3100,3200]
[null,"Easington ","D",350,215]
[null,"East Cambridgeshire  ","D",615,565]
[null,"East Devon  ","C",893,819]
[null,"East Dorset  ","C",1400,1300]
[null,"East Hampshire ","B",1500,1500]
[null,"East Hertfordshire  ","B",1400,1350]
[null,"East Lindsey ","E",410,250]
[null,"East Northamptonshire  ","D",570,570]
[null,"East Riding ","D",610,550]
[null,"East Staffordshire  ","D",700,475]
[null,"Eastbourne  ","C",875,750]
[null,"Eastleigh  ","C",1440,1250]
[null,"Eden  ","D",320,270]
[null,"Ellesmere Port and Neston ","D",360,350]
[null,"Elmbridge ","B",1800,1500]
[null,"Enfield  ","B",3000,2800]
[null,"Epping Forest  ","B",1600,1480]
[null,"Epsom and Ewell  ","B",1450,1400]
[null,"Erewash ","D",540,460]
[null,"Exeter  ","D",1103,987]
[null,"Fareham  ","C",1400,1200]
[null,"Fenland ","E",225,210]
[null,"Forest Heath ","D",320,300]
[null,"Forest of Dean  ","D",740,740]
[null,"Fylde ","C",800,750]
[null,"Gateshead  ","D",500,450]
[null,"Gedling ","D",675,600]
[null,"Gloucester  ","D",1100,1100]
[null,"Gosport  ","C",1025,1000]
[null,"Gravesham ","C",825,825]
[null,"Great Yarmouth ","E",325,275]
[null,"Greenwich  ","B",2000,1700]
[null,"Guildford  ","B",2250,2250]
[null,"Hackney ","A",2500,2500]
[null,"Halton ","D",500,450]
[null,"Hambleton ","D",800,800]
[null,"Hammersmith and Fulham ","A",5000,2550]
[null,"Harborough ","D",750,800]
[null,"Haringey ","A",2500,2500]
[null,"Harlow  ","B",1025,988]
[null,"Harrogate  ","C",850,1000]
[null,"Harrow  ","A",2500,3400]
[null,"Hart ","B",1720,1720]
[null,"Hartlepool  ","D",500,475]
[null,"Hastings  ","D",375,275]
[null,"Havant ","C",1200,1100]
[null,"Havering ","B",1736,2000]
[null,"Herefordshire ","D",600,570]
[null,"Hertsmere ","B",1900,2250]
[null,"High Peak  ","D",440,440]
[null,"Hillingdon ","A",2300,3000]
[null,"Hinckley and Bosworth ","E",850,750]
[null,"Horsham ","C",1450,1425]
[null,"Hounslow ","A",3100,3200]
[null,"Huntingdonshire ","D",890,890]
[null,"Hyndburn ","D",470,235]
[null,"Ipswich  ","D",650,630]
[null,"Isle Of Wight  ","D",475,360]
[null,"Isles of Scilly ","A",1480,2200]
[null,"Islington ","A",5250,5250]
[null,"Kennet ","C",700,700]
[null,"Kensington and Chelsea ","A",27000,17500]
[null,"Kerrier ","D",300,265]
[null,"Kettering  ","D",618,618]
[null,"King's Lynn and West Norfolk ","D",325,275]
[null,"Kingston upon Hull ","D",475,375]
[null,"Kingston upon Thames ","A",2350,2350]
[null,"Kirklees ","D",615,475]
[null,"Knowsley ","D",400,350]
[null,"Lambeth ","A",2100,2100]
[null,"Lancaster  ","D",800,750]
[null,"Leeds  ","C",1000,975]
[null,"Leicester  ","D",750,700]
[null,"Lewes ","C",900,900]
[null,"Lewisham ","B",1600,1600]
[null,"Lichfield  ","D",1100,900]
[null,"Lincoln  ","D",500,375]
[null,"Liverpool  ","C",700,650]
[null,"Luton  ","C",1000,"  "]
[null,"Macclesfield ","C",700,550]
[null,"Maidstone  ","C",1250,1250]
[null,"Maldon ","C",700,900]
[null,"Malvern Hills District ","D",820,795]
[null,"Manchester  ","C",1000,800]
[null,"Mansfield  ","E",320,300]
[null,"Melton ","D",775,725]
[null,"Mendip ","D",600,550]
[null,"Merton ","A",2500,2500]
[null,"Mid Bedfordshire ","C",1050,1050]
[null,"Mid Devon ","D",683,612]
[null,"Mid Suffolk ","E",308,300]
[null,"Mid Sussex ","B",1000,1050]
[null,"Middlesbrough  ","D",425,450]
[null,"Milton Keynes  ","C",1500,1500]
[null,"Mole Valley  ","B",975,1425]
[null,"New Forest  ","C",1280,1400]
[null,"Newark and Sherwood ","E",425,340]
[null,"Newbury ","C",1600,1600]
[null,"Newcastle upon Tyne  ","D",800,800]
[null,"Newcastle-under-Lyme  ","D",450,325]
[null,"Newham ","B",1545,1425]
[null,"North Bedfordshire  ","C",1000,1000]
[null,"North Cornwall  ","D",320,290]
[null,"North Devon  ","C",683,612]
[null,"North Dorset  ","C",950,915]
[null,"North East Derbyshire ","D",450,270]
[null,"North East Lincolnshire ","D",410,350]
[null,"North Hertfordshire  ","B",1200,1100]
[null,"North Kesteven  ","D",340,250]
[null,"North Lincolnshire  ","E",410,350]
[null,"North Norfolk  ","E",350,300]
[null,"North Shropshire  ","D",495,495]
[null,"North Tyneside  ","C",600,800]
[null,"North Warwickshire  ","D",725,600]
[null,"North West Leicestershire ","D",750,750]
[null,"North West Somerset ","C",1100,950]
[null,"North Wiltshire ","C",950,950]
[null,"Northampton  ","D",800,800]
[null,"Norwich  ","D",600,550]
[null,"Nottingham City  ","D",700,620]
[null,"Nuneaton and Bedworth ","E",700,600]
[null,"Oadby and Wigston ","D",750,700]
[null,"Oldham  ","D",675,625]
[null,"Oswestry ","D",490,445]
[null,"Oxford  ","B",3500,3350]
[null,"Pendle ","D",470,270]
[null,"Penwith ","D",330,300]
[null,"Peterborough  ","D",590,565]
[null,"Plymouth  ","D",683,525]
[null,"Poole  ","C",1600,1500]
[null,"Portsmouth  ","C",1000,900]
[null,"Preston  ","D",775,625]
[null,"Purbeck ","C",1000,950]
[null,"Reading  ","C",1950,1950]
[null,"Redbridge ","B",1650,1650]
[null,"Redcar and Cleveland ","D",375,400]
[null,"Redditch  ","D",810,775]
[null,"Reigate and Banstead ","B",1780,1750]
[null,"Restormel ","D",330,300]
[null,"Ribble Valley  ","C",675,625]
[null,"Richmond upon Thames ","A",2600,2600]
[null,"Richmondshire ","D",600,540]
[null,"Rochdale  ","D",650,650]
[null,"Rochford ","C",900,1100]
[null,"Rossendale ","D",475,265]
[null,"Rother ","D",740,700]
[null,"Rotherham  ","D",460,440]
[null,"Rugby  ","D",800,700]
[null,"Runnymede  ","B",2300,2300]
[null,"Rushcliffe ","D",800,745]
[null,"Rushmoor ","B",1720,1720]
[null,"Rutland  ","D",800,675]
[null,"Ryedale ","D",500,400]
[null,"Salford  ","D",500,450]
[null,"Salisbury  ","C",1050,1050]
[null,"Sandwell ","D",570,480]
[null,"Scarborough  ","D",400,350]
[null,"Sedgefield ","D",350,300]
[null,"Sedgemoor  ","D",450,440]
[null,"Sefton ","D",500,425]
[null,"Selby ","D",450,350]
[null,"Sevenoaks ","B",1600,1600]
[null,"Sheffield  ","C",630,540]
[null,"Shepway ","D",865,650]
[null,"Shrewsbury and Atcham ","D",650,765]
[null,"Slough  ","B",1950,1950]
[null,"Solihull  ","C",1800,1650]
[null,"South Bedfordshire  ","C",1100,1100]
[null,"South Bucks ","A",2750,2750]
[null,"South Cambridgeshire  ","C",1130,1025]
[null,"South Derbyshire  ","D",460,375]
[null,"South Gloucestershire  ","D",1300,1200]
[null,"South Hams ","C",716,625]
[null,"South Holland  ","E",325,300]
[null,"South Kesteven  ","E",375,250]
[null,"South Lakeland  ","C",675,575]
[null,"South Norfolk  ","E",350,300]
[null,"South Northamptonshire  ","D",865,865]
[null,"South Oxfordshire  ","C",1250,1200]
[null,"South Ribble  ","D",775,625]
[null,"South Shropshire  ","D",495,445]
[null,"South Somerset  ","D",1000,900]
[null,"South Staffordshire  ","D",950,1000]
[null,"South Tyneside  ","D",500,450]
[null,"Southampton  ","C",1400,1020]
[null,"Southend-on-Sea  ","C",990,920]
[null,"Southwark ","A",2300,2300]
[null,"Spelthorne ","B",1780,1750]
[null,"St. Albans  ","B",1900,2250]
[null,"St. Edmundsbury ","D",650,650]
[null,"St. Helens  ","D",500,410]
[null,"Stafford  ","D",600,425]
[null,"Staffordshire Moorlands ","D",450,325]
[null,"Stevenage  ","B",1400,1250]
[null,"Stockport  ","C",1350,1350]
[null,"Stockton-on-Tees  ","D",500,500]
[null,"Stoke-on-Trent  ","D",450,325]
[null,"Stratford-on-Avon ","C",1450,1400]
[null,"Stroud ","D",850,850]
[null,"Suffolk Coastal ","D",410,400]
[null,"Sunderland  ","D",475,425]
[null,"Surrey Heath ","B",2200,2200]
[null,"Sutton ","B",1900,2470]
[null,"Swale ","C",890,710]
[null,"Tameside ","C",600,490]
[null,"Tamworth  ","D",750,575]
[null,"Tandridge ","B",1780,1750]
[null,"Taunton Deane ","D",925,875]
[null,"Teesdale ","D",325,300]
[null,"Teignbridge ","D",893,819]
[null,"Tendring ","D",600,400]
[null,"Test Valley  ","C",1250,1100]
[null,"Tewkesbury  ","D",1100,1100]
[null,"Thamesdown ","C",850,1050]
[null,"Thanet ","C",700,450]
[null,"The Medway Towns ","C",750,730]
[null,"The Wrekin ","D",500,550]
[null,"Three Rivers ","A",1900,2250]
[null,"Thurrock  ","C",640,555]
[null,"Tonbridge and Malling ","B",1500,1500]
[null,"Torbay  ","D",914,840]
[null,"Torridge ","D",525,478]
[null,"Tower Hamlets ","A",2475,2225]
[null,"Trafford ","C",925,855]
[null,"Tunbridge Wells ","C",1600,1600]
[null,"Tynedale ","D",495,400]
[null,"Uttlesford ","C",1200,1100]
[null,"Vale of White Horse ","C",1200,1150]
[null,"Vale Royal ","D",575,500]
[null,"Wakefield  ","D",700,500]
[null,"Walsall  ","D",975,1025]
[null,"Waltham Forest  ","B",1650,1650]
[null,"Wandsworth ","A",2900,2900]
[null,"Wansbeck ","D",245,200]
[null,"Warrington  ","D",940,700]
[null,"Warwick  ","C",1900,1800]
[null,"Watford  ","B",1900,2250]
[null,"Waveney ","E",320,320]
[null,"Waverley  ","B",2000,2000]
[null,"Wealden ","C",1040,875]
[null,"Wear Valley  ","D",400,300]
[null,"Wellingborough ","D",679,679]
[null,"Welwyn Hatfield ","B",1400,1200]
[null,"West Devon  ","D",680,650]
[null,"West Dorset  ","C",925,875]
[null,"West Lancashire  ","C",775,625]
[null,"West Lindsey ","E",210,135]
[null,"West Oxfordshire  ","C",1200,1100]
[null,"West Somerset  ","D",620,580]
[null,"West Wiltshire ","C",800,950]
[null,"Weymouth and Portland ","C",850,800]
[null,"Wigan  ","D",550,450]
[null,"Winchester  ","B",1720,1720]
[null,"Windsor and Maidenhead ","B",2100,2100]
[null,"Wirral ","D",360,360]
[null,"Woking  ","B",2150,2150]
[null,"Wokingham ","B",2000,2000]
[null,"Wolverhampton  ","D",900,950]
[null,"Worcester City  ","D",820,775]
[null,"Worthing  ","C",950,900]
[null,"Wychavon ","D",830,765]
[null,"Wycombe ","B",2100,2100]
[null,"Wyre ","D",800,750]
[null,"Wyre Forest  ","D",1050,1175]
[null,"York  ","C",800,750]
[]
[null,"A",871]
[null,"B",799]
[null,"C",761]
[null,"D",737]
[null,"E",707]

{"sheet":"F3","index":18,"n_rows":491,"n_cols":17,"rows_kept":491,"cut":false,"hidden":true,"merged":[[51,8,51,9],[52,8,52,9],[3,3,3,4],[4,3,4,4],[6,3,6,4],[9,5,9,6],[13,1,13,4],[17,1,17,4]]}
[1,"FORMULA RENT CALCULATOR"]
[{"$f":"IF('M1'!I14='M1'!E129,\"F\",\"\")","v":""},"x"]
[null,"INPUTS FOR FORMULA RENT CALCULATION"]
[null,"Unit size",null,{"$f":"IF(A$2=\"F\",'M1'!I12,\"\")","v":""},null,"x"]
[null,"Unit type",null,{"$f":"IF(A$2=\"F\",'M1'!I13,\"\")","v":""},null,"x"]
[]
[null,"1999 valuation method",null,{"$f":"IF(A$2=\"F\",IF('M1'!I19=\"DRC*\",\"DRC\",'M1'!I19),\"\")","v":""},null,{"$f":"IF(D7=\"Manual entry\",\"Enter the 1990 valuation for each unit in the cell below\",IF(D7=\"DRC\",\"The 1999 valuation will be calculated from details entered below\",\"\"))","v":""}]
[null,"1999 valuation             £",null,{"$f":"IF(A$2=\"F\",'M1'!I21,\"\")","v":""},"x",{"$f":"IF(AND(D7=\"DRC\",D8=0),\"DRC method selected - no valuation entry needed\",IF(AND(D7=\"DRC\",D8<>0),\"DRC method has been selected, so the valuation entered will not be used\",IF(AND(D7=\"Manual entry\",D8=0),\"Enter the 1999 valuation\",\"\")))","v":""}]
[]
[null,"Apply \"flexibility\"",null,{"$f":"IF(A$2=\"F\",'M1'!I22,\"\")","v":""},"x",{"$f":"IF(AND($D10=\"Yes\",$D5<>\"\"),VLOOKUP(D5,$B$128:$C$130,COLUMNS($B$128:$C$128),FALSE),\"\")","v":""}]
[null,{"$f":"IF(D10=\"Yes\",\"Optional flexibility\",\"\")","v":""},null,null,{"$f":"IF(AND(D10=\"Yes\",OR(D11=0,D11=F10)),\"Maximum flexibility will be applied\",IF(AND(D10=\"Yes\",D11<F10),\"The lower flexibility entered will be applied\",IF(AND(D10=\"Yes\",D11>F10),\"Flexiility will be limited to the maximum\",\"\")))","v":""}]
[null,null,null,null,null,null,null,null,"Select"]
[null,"Local area for formula rent calculation",null,null,null,null,null,null,"date"]
[null,{"$f":"IF(A2=\"F\",'M1'!C24,\"\")","v":""},null,null,null,null,"FORMULA RENT",null,{"$f":"IF(A2=\"F\",Menu!C5,\"\")","v":""},"£",{"$f":"IF(I14<>\"\",VLOOKUP(I14,N35:Q38,COLUMNS(N35:Q35),FALSE),\"\")","v":""}]
[]
[null,"INPUTS FOR DEPRECIATED REPLACEMENT COST (DRC) VALUATION (optional)"]
[null,"Local area for DRC calculation"]
[null,{"$f":"IF(AND(A2=\"F\",D7=\"DRC\"),'M1'!C34,\"\")","v":""}]
[]
[null,"Floor area of unit",null,{"$f":"IF(D$7=\"DRC\",'M1'!I26,0)","v":0},"x"]
[null,"Plot area",null,{"$f":"IF(D$7=\"DRC\",'M1'!I27,0)","v":0},"x"]
[null,"No. of units on the plot",null,{"$f":"IF(D$7=\"DRC\",'M1'!I28,0)","v":0},"x",{"$f":"IF(AND($D21>0,$D22>=0),\"The 'land area' for this unit is:\",\"\")","v":""},null,null,{"$f":"IF(AND(D21>0,D22=0),D21,IF(AND($D21>0,$D22>0),D21/D22,0))","v":0},{"$f":"IF(AND($D21>0,$D22>=0),\"m²\",\"\")","v":""}]
[null,"New lift?",null,{"$f":"IF(D$7=\"DRC\",'M1'!I29,0)","v":0},"x"]
[null,"Wheelchair access?",null,{"$f":"IF(D$7=\"DRC\",'M1'!I30,0)","v":0},"x","Requiring specialised equipment"]
[null,"Kitchen >10 yrs old?",null,{"$f":"IF(D$7=\"DRC\",'M1'!I31,0)","v":0},"x"]
[null,"Bathroom >15 yrs old?",null,{"$f":"IF(D$7=\"DRC\",'M1'!I32,0)","v":0},"x"]
[]
[null,"FORMULA RENT CALCULATIONS",null,null,null,null,null,null,null,"Infl-","Addition","Formula",null,null,"Infl-","Addition","Formula"]
[null,null,null,null,null,null,null,null,null,"ation",null,"rent £",null,null,"ation",null,"rent £"]
[null,"Average social rent  2000/01",null,null,null,"£",54.62,null,"2000/01",null,null,{"$f":"G48","v":0},null,"2019/20",{"$f":"IF(D$5=B$128,0,IF(D$5=B$129,0,IF(D$5=B$130,2.4,0)))","v":0},{"$f":"IF(D$5=B$130,1,-1)","v":-1},{"$f":"ROUND(L48*SUM(100,O30,P30)/100,2)","v":0}]
[null,"Average valuation  2000/01",null,null,null,"£",49750,null,"2001/02",3.3,1,{"$f":"ROUND(L30*SUM(100,J31,K31)/100,2)","v":0},null,"2020/21",1.7,1,{"$f":"ROUND(Q30*SUM(O31,P31,100)/100,2)","v":0}]
[null,"Average manual earnings 2000/01",null,null,null,"£",316.39999999999998,null,"2002/03",1.7,0.5,{"$f":"ROUND(L31*SUM(100,J32,K32)/100,2)","v":0},null,"2021/22",0.5,1,{"$f":"ROUND(Q31*SUM(O32,P32,100)/100,2)","v":0}]
[null,"Manual earnings for selected area 2000/01",null,null,null,"£",{"$f":"IF(B14=0,0,IF(B14<>\"\",VLOOKUP(B14,$B$73:$C$118,COLUMNS($B$73:$C$73),FALSE),0))","v":0},null,"2003/04",1.7,0.5,0,null,"2022/23",3.1,1,{"$f":"ROUND(Q32*SUM(O33,P33,100)/100,2)","v":0}]
[null,"Unit size multiplier",null,null,null,null,{"$f":"IF(D4=0,0,IF(D4<>\"\",VLOOKUP(D4,$B$120:$C$126,COLUMNS(B120:C120),FALSE),0))","v":0},null,"2004/05",2.8,0.5,0,null,"2023/24",{"$f":"IF(D5=B128,0,10.1)","v":10.1},{"$f":"IF(D5=B128,7,1)","v":1},0]
[null,null,null,null,null,null,null,null,"2005/06",3.1,0.5,0,null,"2024/25",6.7,1,0]
[null,"Adjusted for local earnings and unit size",null,null,null,null,null,null,"2006/07",2.7,0.5,0,null,"2025/26",{"$f":"Ass!D9","v":2.2000000000000002},{"$f":"Ass!D15","v":1},0]
[null,"70% of social rent 2000/01",null,null,null,"£",{"$f":"ROUND(G30*0.7,2)","v":38.229999999999997},null,"2007/08",3.6,0.5,0,null,"2026/27",{"$f":"Ass!D10","v":2},{"$f":"Ass!D16","v":1},0]
[null,"Adjusted for local earnings & unit size",null,null,null,"£",{"$f":"IF(B14=0,0,ROUND(G37*G33/G32*G34,2))","v":0},null,"2008/09",3.9,0.5,0,null,"2027/28",{"$f":"Ass!D11","v":2},{"$f":"Ass!D17","v":1},0]
[null,null,null,null,null,null,null,null,"2009/10",5,0.5,0]
[null,"Adjusted for 2000/01 valuation",null,null,null,null,null,null,"2010/11",-1.4,0.5,0]
[null,"30% of social rent 2000/01",null,null,null,"£",{"$f":"G30-G37","v":16.39},null,"2011/12",4.5999999999999996,0.5,0]
[null,"Valuation",null,null,null,"£",{"$f":"IF(D7=\"DRC\",J57,D8)","v":""},null,"2012/13",5.6,0.5,0]
[null,"Adjusted for valuation",null,null,null,"£",{"$f":"IF(A2=\"F\",ROUND(G41*G42/G31,2),0)","v":0},null,"2013/14",2.6,0.5,0]
[null,null,null,null,null,null,null,null,"2014/15",3.2,0.5,0]
[null,"Total formula rent 2000/02",null,null,null,null,null,null,"2015/16",1.2,1,0]
[null,"Before flexibility",null,null,null,"£",{"$f":"SUM(G43,G38)","v":0},null,"2016/17",{"$f":"IF(D$5=B$128,0,IF(OR(D$5=B$129,$D5=B$130),-0.1,0))","v":0},{"$f":"IF(D$5=B$128,-1,IF(OR(D$5=B$129,$D5=B$130),1,0))","v":0},0]
[null,"Flexibility",null,null,null,null,{"$f":"IF(D5=0,0,IF(D10=\"No\",0,MIN(F10,D11)))","v":0},null,"2017/18",{"$f":"IF(D$5=B$128,0,IF(D$5=B$129,0,IF(D$5=B$130,1,0)))","v":0},{"$f":"IF(D$5=B$130,1,-1)","v":-1},0]
[null,"Including flexibility",null,null,null,"£",{"$f":"ROUND(G46*(100+G47)/100,2)","v":0},null,"2018/19",{"$f":"IF(D$5=B$128,0,IF(D$5=B$129,0,IF(D$5=B$130,3,0)))","v":0},{"$f":"IF(D$5=B$130,1,-1)","v":-1},0]
[]
[null,"DRC CALCULATION"]
[null,"TCI region",null,{"$f":"IF(B18=0,\"\",IF(B18<>\"\",VLOOKUP(B18,$B$132:$C$485,COLUMNS(B132:C132),FALSE),\"\"))","v":""},null,null,"Plot",null,null,{"$f":"IF(I52<2,\"small\",\"large\")","v":"small"},{"$f":"IF(J51=\"small\",\"< 2 hectares\",\">2 haecares\")","v":"< 2 hectares"}]
[null,"Build cost ",null,{"$f":"IF(D51<>\"\",VLOOKUP(D51,$B$487:$C$491,COLUMNS($B$487:$C$487),FALSE),0)","v":0},"per m²",null,"Plot size",null,{"$f":"D21/10000","v":0},null,"hectares"]
[null,"Adjustment for lift",null,{"$f":"IF(D23=\"Yes\",D$52*0.12,0)","v":0},"per m²",null,"Plot area per unit",null,{"$f":"I22/10000","v":0},null,"hectares per unit"]
[null,"Adjust  for wheelchair",null,{"$f":"IF(D24=\"Yes\",D$52*0.12,0)","v":0},"per m²",null,"Land cost",null,"£k",{"$f":"IF(B18=0,\"\",IF(B18=\"\",0,IF(J51=\"small\",VLOOKUP(B18,$B$132:$E$485,COLUMNS($B$132:$D$132),FALSE),VLOOKUP(B18,$B$132:$E$485,COLUMNS($B$132:$E$132),FALSE))))","v":0},"per hectare"]
[null,"Adjust  for kitch/bthrm",null,{"$f":"IF(OR(D25=\"Yes\",D26=\"Yes\"),-D$52*0.1,0)","v":0},"per m²",null,"Land value per unit",null,"£",{"$f":"ROUND(SUM(J54)*I53*1000,0)","v":0}]
[null,"Adjusted build cost",null,{"$f":"ROUND(SUM(D52:D55),0)","v":0},"per m²",null,"Build cost",null,"£",{"$f":"D57","v":0}]
[null,"Build cost ",null,{"$f":"ROUND(D56*D20,0)","v":0},null,null,"Valuation",null,"£",{"$f":"SUM(J55:J56)","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Manual earnings"]
[null,"Avon",321.2,null,null,null,null,null,{"$f":"I30","v":"2000/01"},{"$f":"L30","v":0}]
[null,"Bedfordshire",343.7,null,null,null,null,null,"2001/02",{"$f":"L31","v":0}]
[null,"Berkshire",345.4,null,null,null,null,null,"2002/03",0]
[null,"Buckinghamshire",328.3,null,null,null,null,null,"2003/04",0]
[null,"Cambridgeshire",330.1,null,null,null,null,null,"2004/05",0]
[null,"Cheshire",322,null,null,null,null,null,"2005/06",0]
[null,"Cleveland",338.4,null,null,null,null,null,"2006/07",0]
[null,"Cornwall",255.5,null,null,null,null,null,"2007/08",0]
[null,"Cumbria",323.7,null,null,null,null,null,"2008/09",0]
[null,"Derbyshire",321.10000000000002,null,null,null,null,null,"2009/10",0]
[null,"Devon",278,null,null,null,null,null,"2010/11",0]
[null,"Dorset",293.89999999999998,null,null,null,null,null,"2011/12",0]
[null,"Durham",289.7,null,null,null,null,null,"2012/13",0]
[null,"East Sussex",281.5,null,null,null,null,null,"2013/14",0]
[null,"Essex",325.89999999999998,null,null,null,null,null,"2014/15",0]
[null,"Gloucestershire",308,null,null,null,null,null,"2015/16",0]
[null,"Greater London",354.1,null,null,null,null,null,"2016/17",0]
[null,"Greater Manchester",307.3,null,null,null,null,null,"2017/18",0]
[null,"Hampshire",328.7,null,null,null,null,null,"2018/19",0]
[null,"Hereford & Worcs",289.60000000000002,null,null,null,null,null,{"$f":"N30","v":"2019/20"},{"$f":"Q30","v":0}]
[null,"Hertfordshire",343.7,null,null,null,null,null,{"$f":"N31","v":"2020/21"},{"$f":"Q31","v":0}]
[null,"Humberside",318.39999999999998,null,null,null,null,null,"2021/22",0]
[null,"Isle of Wight",288.5,null,null,null,null,null,"2022/23",0]
[null,"Kent",316.39999999999998,null,null,null,null,null,"2023/24",0]
[null,"Lancashire",302.7,null,null,null,null,null,"2024/25",0]
[null,"Leicestershire",303.10000000000002,null,null,null,null,null,"2025/26",0]
[null,"Lincolnshire",286.7,null,null,null,null,null,"2026/27",0]
[null,"Merseyside",324.89999999999998]
[null,"Norfolk",302.5]
[null,"North Yorkshire",299.60000000000002]
[null,"Northamptonshire",328.5]
[null,"Northumberland",276.10000000000002]
[null,"Nottinghamshire",298]
[null,"Oxfordshire",323.8]
[null,"Shropshire",295.39999999999998]
[null,"Somerset",299.7]
[null,"South Yorkshire",299.10000000000002]
[null,"Staffordshire",296.2]
[null,"Suffolk",304.3]
[null,"Surrey",333.2]
[null,"Tyne & Wear",307.89999999999998]
[null,"Warwickshire",326.10000000000002]
[null,"West Midlands",320.60000000000002]
[null,"West Sussex",332.5]
[null,"West Yorkshire",302.7]
[null,"Wiltshire",313.89999999999998]
[]
[null,"Bedsit/room",0.8]
[null,"1-bed",0.9]
[null,"2-bed",1]
[null,"3-bed",1.1000000000000001]
[null,"4-bed",1.2]
[null,"5-bed",1.3]
[null,"6-bed",1.4]
[]
[null,"General needs",5]
[null,"Supported",10]
[null,"Refuge or almshouse",10]
[]
[null,"Adur ","C",800,750]
[null,"Allerdale ","D",250,197]
[null,"Alnwick ","D",430,310]
[null,"Amber Valley  ","E",520,450]
[null,"Arun ","C",1125,1110]
[null,"Ashfield ","E",350,300]
[null,"Ashford ","C",1020,925]
[null,"Aylesbury Vale ","C",1600,1600]
[null,"Babergh ","D",350,335]
[null,"Barking and Dagenham ","B",1385,1600]
[null,"Barnet ","A",3800,3500]
[null,"Barnsley  ","D",550,375]
[null,"Barrow-in-Furness  ","C",425,375]
[null,"Basildon  ","C",1025,988]
[null,"Basingstoke and Deane ","B",1720,1720]
[null,"Bassetlaw ","D",400,300]
[null,"Bath and North East Somerset ","C",1500,1400]
[null,"Berwick-upon-Tweed ","D",370,245]
[null,"Bexley ","B",2000,1600]
[null,"Birmingham  ","C",890,890]
[null,"Blaby ","D",750,700]
[null,"Blackburn  ","D",470,325]
[null,"Blackpool  ","D",750,675]
[null,"Blyth Valley  ","D",245,200]
[null,"Bolsover ","E",325,250]
[null,"Bolton  ","D",550,500]
[null,"Boston  ","E",270,185]
[null,"Bournemouth  ","C",1600,1500]
[null,"Bracknell Forest  ","B",2000,2000]
[null,"Bradford  ","D",600,525]
[null,"Braintree  ","D",800,750]
[null,"Breckland ","E",325,275]
[null,"Brent ","A",2300,3000]
[null,"Brentwood  ","B",1555,1400]
[null,"Bridgnorth ","D",750,715]
[null,"Brighton and Hove ","C",1200,1000]
[null,"Bristol  ","C",1350,1350]
[null,"Broadland ","D",325,275]
[null,"Bromley ","B",2000,2470]
[null,"Bromsgrove ","C",1235,1350]
[null,"Broxbourne ","B",2200,2000]
[null,"Broxtowe ","D",680,625]
[null,"Burnley  ","D",470,310]
[null,"Bury ","D",550,500]
[null,"Calderdale ","D",550,450]
[null,"Cambridge  ","B",1480,2200]
[null,"Camden  ","A",9000,5500]
[null,"Cannock Chase ","D",900,950]
[null,"Canterbury  ","C",1850,1350]
[null,"Caradon ","D",200,220]
[null,"Carlisle  ","D",360,270]
[null,"Carrick ","D",400,350]
[null,"Castle Morpeth ","D",450,370]
[null,"Castle Point ","C",1200,1300]
[null,"Charnwood ","D",800,800]
[null,"Chelmsford  ","C",1280,1225]
[null,"Cheltenham  ","C",1500,1500]
[null,"Cherwell ","C",1000,900]
[null,"Chester  ","C",645,825]
[null,"Chesterfield  ","D",495,325]
[null,"Chester-le-Street  ","D",494,494]
[null,"Chichester  ","C",1850,1750]
[null,"Chiltern ","B",2500,2500]
[null,"Chorley  ","D",775,625]
[null,"Christchurch  ","C",1600,1500]
[null,"City of London ","A",20500,20500]
[null,"City of Westminster ","A",20500,20500]
[null,"Colchester  ","C",900,900]
[null,"Congleton ","D",540,500]
[null,"Copeland ","D",200,150]
[null,"Corby  ","D",350,350]
[null,"Cotswold ","C",1350,1350]
[null,"Coventry  ","D",950,850]
[null,"Craven ","D",525,500]
[null,"Crawley  ","B",1200,1200]
[null,"Crewe and Nantwich ","D",350,300]
[null,"Croydon ","B",2000,2000]
[null,"Dacorum ","B",1900,2250]
[null,"Darlington  ","D",500,500]
[null,"Dartford  ","C",1100,1100]
[null,"Daventry ","D",740,740]
[null,"Derby  ","E",600,550]
[null,"Derbyshire Dales ","D",550,490]
[null,"Derwentside ","D",315,275]
[null,"Doncaster  ","D",625,425]
[null,"Dover  ","C",700,450]
[null,"Dudley  ","D",950,1000]
[null,"Durham  ","C",650,600]
[null,"Ealing ","A",3100,3200]
[null,"Easington ","D",350,215]
[null,"East Cambridgeshire  ","D",615,565]
[null,"East Devon  ","C",893,819]
[null,"East Dorset  ","C",1400,1300]
[null,"East Hampshire ","B",1500,1500]
[null,"East Hertfordshire  ","B",1400,1350]
[null,"East Lindsey ","E",410,250]
[null,"East Northamptonshire  ","D",570,570]
[null,"East Riding ","D",610,550]
[null,"East Staffordshire  ","D",700,475]
[null,"Eastbourne  ","C",875,750]
[null,"Eastleigh  ","C",1440,1250]
[null,"Eden  ","D",320,270]
[null,"Ellesmere Port and Neston ","D",360,350]
[null,"Elmbridge ","B",1800,1500]
[null,"Enfield  ","B",3000,2800]
[null,"Epping Forest  ","B",1600,1480]
[null,"Epsom and Ewell  ","B",1450,1400]
[null,"Erewash ","D",540,460]
[null,"Exeter  ","D",1103,987]
[null,"Fareham  ","C",1400,1200]
[null,"Fenland ","E",225,210]
[null,"Forest Heath ","D",320,300]
[null,"Forest of Dean  ","D",740,740]
[null,"Fylde ","C",800,750]
[null,"Gateshead  ","D",500,450]
[null,"Gedling ","D",675,600]
[null,"Gloucester  ","D",1100,1100]
[null,"Gosport  ","C",1025,1000]
[null,"Gravesham ","C",825,825]
[null,"Great Yarmouth ","E",325,275]
[null,"Greenwich  ","B",2000,1700]
[null,"Guildford  ","B",2250,2250]
[null,"Hackney ","A",2500,2500]
[null,"Halton ","D",500,450]
[null,"Hambleton ","D",800,800]
[null,"Hammersmith and Fulham ","A",5000,2550]
[null,"Harborough ","D",750,800]
[null,"Haringey ","A",2500,2500]
[null,"Harlow  ","B",1025,988]
[null,"Harrogate  ","C",850,1000]
[null,"Harrow  ","A",2500,3400]
[null,"Hart ","B",1720,1720]
[null,"Hartlepool  ","D",500,475]
[null,"Hastings  ","D",375,275]
[null,"Havant ","C",1200,1100]
[null,"Havering ","B",1736,2000]
[null,"Herefordshire ","D",600,570]
[null,"Hertsmere ","B",1900,2250]
[null,"High Peak  ","D",440,440]
[null,"Hillingdon ","A",2300,3000]
[null,"Hinckley and Bosworth ","E",850,750]
[null,"Horsham ","C",1450,1425]
[null,"Hounslow ","A",3100,3200]
[null,"Huntingdonshire ","D",890,890]
[null,"Hyndburn ","D",470,235]
[null,"Ipswich  ","D",650,630]
[null,"Isle Of Wight  ","D",475,360]
[null,"Isles of Scilly ","A",1480,2200]
[null,"Islington ","A",5250,5250]
[null,"Kennet ","C",700,700]
[null,"Kensington and Chelsea ","A",27000,17500]
[null,"Kerrier ","D",300,265]
[null,"Kettering  ","D",618,618]
[null,"King's Lynn and West Norfolk ","D",325,275]
[null,"Kingston upon Hull ","D",475,375]
[null,"Kingston upon Thames ","A",2350,2350]
[null,"Kirklees ","D",615,475]
[null,"Knowsley ","D",400,350]
[null,"Lambeth ","A",2100,2100]
[null,"Lancaster  ","D",800,750]
[null,"Leeds  ","C",1000,975]
[null,"Leicester  ","D",750,700]
[null,"Lewes ","C",900,900]
[null,"Lewisham ","B",1600,1600]
[null,"Lichfield  ","D",1100,900]
[null,"Lincoln  ","D",500,375]
[null,"Liverpool  ","C",700,650]
[null,"Luton  ","C",1000,"  "]
[null,"Macclesfield ","C",700,550]
[null,"Maidstone  ","C",1250,1250]
[null,"Maldon ","C",700,900]
[null,"Malvern Hills District ","D",820,795]
[null,"Manchester  ","C",1000,800]
[null,"Mansfield  ","E",320,300]
[null,"Melton ","D",775,725]
[null,"Mendip ","D",600,550]
[null,"Merton ","A",2500,2500]
[null,"Mid Bedfordshire ","C",1050,1050]
[null,"Mid Devon ","D",683,612]
[null,"Mid Suffolk ","E",308,300]
[null,"Mid Sussex ","B",1000,1050]
[null,"Middlesbrough  ","D",425,450]
[null,"Milton Keynes  ","C",1500,1500]
[null,"Mole Valley  ","B",975,1425]
[null,"New Forest  ","C",1280,1400]
[null,"Newark and Sherwood ","E",425,340]
[null,"Newbury ","C",1600,1600]
[null,"Newcastle upon Tyne  ","D",800,800]
[null,"Newcastle-under-Lyme  ","D",450,325]
[null,"Newham ","B",1545,1425]
[null,"North Bedfordshire  ","C",1000,1000]
[null,"North Cornwall  ","D",320,290]
[null,"North Devon  ","C",683,612]
[null,"North Dorset  ","C",950,915]
[null,"North East Derbyshire ","D",450,270]
[null,"North East Lincolnshire ","D",410,350]
[null,"North Hertfordshire  ","B",1200,1100]
[null,"North Kesteven  ","D",340,250]
[null,"North Lincolnshire  ","E",410,350]
[null,"North Norfolk  ","E",350,300]
[null,"North Shropshire  ","D",495,495]
[null,"North Tyneside  ","C",600,800]
[null,"North Warwickshire  ","D",725,600]
[null,"North West Leicestershire ","D",750,750]
[null,"North West Somerset ","C",1100,950]
[null,"North Wiltshire ","C",950,950]
[null,"Northampton  ","D",800,800]
[null,"Norwich  ","D",600,550]
[null,"Nottingham City  ","D",700,620]
[null,"Nuneaton and Bedworth ","E",700,600]
[null,"Oadby and Wigston ","D",750,700]
[null,"Oldham  ","D",675,625]
[null,"Oswestry ","D",490,445]
[null,"Oxford  ","B",3500,3350]
[null,"Pendle ","D",470,270]
[null,"Penwith ","D",330,300]
[null,"Peterborough  ","D",590,565]
[null,"Plymouth  ","D",683,525]
[null,"Poole  ","C",1600,1500]
[null,"Portsmouth  ","C",1000,900]
[null,"Preston  ","D",775,625]
[null,"Purbeck ","C",1000,950]
[null,"Reading  ","C",1950,1950]
[null,"Redbridge ","B",1650,1650]
[null,"Redcar and Cleveland ","D",375,400]
[null,"Redditch  ","D",810,775]
[null,"Reigate and Banstead ","B",1780,1750]
[null,"Restormel ","D",330,300]
[null,"Ribble Valley  ","C",675,625]
[null,"Richmond upon Thames ","A",2600,2600]
[null,"Richmondshire ","D",600,540]
[null,"Rochdale  ","D",650,650]
[null,"Rochford ","C",900,1100]
[null,"Rossendale ","D",475,265]
[null,"Rother ","D",740,700]
[null,"Rotherham  ","D",460,440]
[null,"Rugby  ","D",800,700]
[null,"Runnymede  ","B",2300,2300]
[null,"Rushcliffe ","D",800,745]
[null,"Rushmoor ","B",1720,1720]
[null,"Rutland  ","D",800,675]
[null,"Ryedale ","D",500,400]
[null,"Salford  ","D",500,450]
[null,"Salisbury  ","C",1050,1050]
[null,"Sandwell ","D",570,480]
[null,"Scarborough  ","D",400,350]
[null,"Sedgefield ","D",350,300]
[null,"Sedgemoor  ","D",450,440]
[null,"Sefton ","D",500,425]
[null,"Selby ","D",450,350]
[null,"Sevenoaks ","B",1600,1600]
[null,"Sheffield  ","C",630,540]
[null,"Shepway ","D",865,650]
[null,"Shrewsbury and Atcham ","D",650,765]
[null,"Slough  ","B",1950,1950]
[null,"Solihull  ","C",1800,1650]
[null,"South Bedfordshire  ","C",1100,1100]
[null,"South Bucks ","A",2750,2750]
[null,"South Cambridgeshire  ","C",1130,1025]
[null,"South Derbyshire  ","D",460,375]
[null,"South Gloucestershire  ","D",1300,1200]
[null,"South Hams ","C",716,625]
[null,"South Holland  ","E",325,300]
[null,"South Kesteven  ","E",375,250]
[null,"South Lakeland  ","C",675,575]
[null,"South Norfolk  ","E",350,300]
[null,"South Northamptonshire  ","D",865,865]
[null,"South Oxfordshire  ","C",1250,1200]
[null,"South Ribble  ","D",775,625]
[null,"South Shropshire  ","D",495,445]
[null,"South Somerset  ","D",1000,900]
[null,"South Staffordshire  ","D",950,1000]
[null,"South Tyneside  ","D",500,450]
[null,"Southampton  ","C",1400,1020]
[null,"Southend-on-Sea  ","C",990,920]
[null,"Southwark ","A",2300,2300]
[null,"Spelthorne ","B",1780,1750]
[null,"St. Albans  ","B",1900,2250]
[null,"St. Edmundsbury ","D",650,650]
[null,"St. Helens  ","D",500,410]
[null,"Stafford  ","D",600,425]
[null,"Staffordshire Moorlands ","D",450,325]
[null,"Stevenage  ","B",1400,1250]
[null,"Stockport  ","C",1350,1350]
[null,"Stockton-on-Tees  ","D",500,500]
[null,"Stoke-on-Trent  ","D",450,325]
[null,"Stratford-on-Avon ","C",1450,1400]
[null,"Stroud ","D",850,850]
[null,"Suffolk Coastal ","D",410,400]
[null,"Sunderland  ","D",475,425]
[null,"Surrey Heath ","B",2200,2200]
[null,"Sutton ","B",1900,2470]
[null,"Swale ","C",890,710]
[null,"Tameside ","C",600,490]
[null,"Tamworth  ","D",750,575]
[null,"Tandridge ","B",1780,1750]
[null,"Taunton Deane ","D",925,875]
[null,"Teesdale ","D",325,300]
[null,"Teignbridge ","D",893,819]
[null,"Tendring ","D",600,400]
[null,"Test Valley  ","C",1250,1100]
[null,"Tewkesbury  ","D",1100,1100]
[null,"Thamesdown ","C",850,1050]
[null,"Thanet ","C",700,450]
[null,"The Medway Towns ","C",750,730]
[null,"The Wrekin ","D",500,550]
[null,"Three Rivers ","A",1900,2250]
[null,"Thurrock  ","C",640,555]
[null,"Tonbridge and Malling ","B",1500,1500]
[null,"Torbay  ","D",914,840]
[null,"Torridge ","D",525,478]
[null,"Tower Hamlets ","A",2475,2225]
[null,"Trafford ","C",925,855]
[null,"Tunbridge Wells ","C",1600,1600]
[null,"Tynedale ","D",495,400]
[null,"Uttlesford ","C",1200,1100]
[null,"Vale of White Horse ","C",1200,1150]
[null,"Vale Royal ","D",575,500]
[null,"Wakefield  ","D",700,500]
[null,"Walsall  ","D",975,1025]
[null,"Waltham Forest  ","B",1650,1650]
[null,"Wandsworth ","A",2900,2900]
[null,"Wansbeck ","D",245,200]
[null,"Warrington  ","D",940,700]
[null,"Warwick  ","C",1900,1800]
[null,"Watford  ","B",1900,2250]
[null,"Waveney ","E",320,320]
[null,"Waverley  ","B",2000,2000]
[null,"Wealden ","C",1040,875]
[null,"Wear Valley  ","D",400,300]
[null,"Wellingborough ","D",679,679]
[null,"Welwyn Hatfield ","B",1400,1200]
[null,"West Devon  ","D",680,650]
[null,"West Dorset  ","C",925,875]
[null,"West Lancashire  ","C",775,625]
[null,"West Lindsey ","E",210,135]
[null,"West Oxfordshire  ","C",1200,1100]
[null,"West Somerset  ","D",620,580]
[null,"West Wiltshire ","C",800,950]
[null,"Weymouth and Portland ","C",850,800]
[null,"Wigan  ","D",550,450]
[null,"Winchester  ","B",1720,1720]
[null,"Windsor and Maidenhead ","B",2100,2100]
[null,"Wirral ","D",360,360]
[null,"Woking  ","B",2150,2150]
[null,"Wokingham ","B",2000,2000]
[null,"Wolverhampton  ","D",900,950]
[null,"Worcester City  ","D",820,775]
[null,"Worthing  ","C",950,900]
[null,"Wychavon ","D",830,765]
[null,"Wycombe ","B",2100,2100]
[null,"Wyre ","D",800,750]
[null,"Wyre Forest  ","D",1050,1175]
[null,"York  ","C",800,750]
[]
[null,"A",871]
[null,"B",799]
[null,"C",761]
[null,"D",737]
[null,"E",707]

{"sheet":"Spare with auto-condense","index":19,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}