{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Calculation"],"not_rendered":{"charts":0,"images":1,"macros":0,"external_links":0,"defined_names":1,"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":"Calculation","index":0,"n_rows":44,"n_cols":11,"rows_kept":44,"cut":false,"hidden":false,"merged":[[3,1,3,3],[4,6,12,10],[13,6,14,10],[15,6,16,10],[3,6,3,10]]}
["LONDON BOROUGH OF RICHMOND UPON THAMES"]
[null,null,null,null,null,null,null,null,null,"2026-02-01"]
["AFFORDABLE HOUSING SPD - ANNEXE A - COMMUTED SUM CALCULATION",null,null,null,null,null,null,null,null,"REV D"]
["Site Name:","xxxx",null,null,"Date",null,"Notes"]
["Number of Units on proposed development",null,null,null,1,"No."]
["Level of Affordable Housing required",null,null,null,0.05]
["Number of Affordable Units required",null,null,null,{"$f":"E5*E6","v":0.05},"No."]
["Percentage Affordable Rented required",null,null,null,0.7]
["Number of Affordable Rented Units required",null,null,null,{"$f":"E7*E8","v":3.4999999999999996E-2},"No."]
["Percentage Intermediate required",null,null,null,{"$f":"1-E8","v":0.30000000000000004}]
["Number of Intermediate units required",null,null,null,{"$f":"E10*E7","v":1.5000000000000003E-2},"No."]
[]
["Less on Site provision"]
["Affordable Rented Units provided on site",null,null,null,0,"No."]
["Net number of units of Affordable Rented off-site",null,null,null,{"$f":"E9-E14","v":3.4999999999999996E-2},"No."]
["Intermediate Units provided on site",null,null,null,0,"No."]
["Net number of Intermediate units off-site",null,null,null,{"$f":"E11-E16","v":1.5000000000000003E-2},"No."]
[]
["Off-Site Commuted Sum calculation"]
["Affordable Rented"]
["Unit type","Off Site","OMV","Profit","Net Total Cost","Policy Rent","Mgt Charge","Yield","Capitalised","Commuted"]
[null,"Provision","£",0.17499999999999999,null,"per week",0.25,0.06,"Rent","Sum"]
["1 Bed Flat",null,null,{"$f":"C23*$D$22","v":0},{"$f":"C23-D23","v":0},null,{"$f":"(F23*52)*$G$22","v":0},{"$f":"$H$22","v":0.06},{"$f":"((F23*52)-G23)/H23","v":0},{"$f":"(E23-I23)*B23","v":0}]
["2 Bed Flat",null,null,{"$f":"C24*$D$22","v":0},{"$f":"C24-D24","v":0},null,{"$f":"(F24*52)*$G$22","v":0},{"$f":"$H$22","v":0.06},{"$f":"((F24*52)-G24)/H24","v":0},{"$f":"(E24-I24)*B24","v":0}]
["3 Bed Flat",null,null,0,0,null,0,0.06,0,0]
["2 Bed Hse",null,null,0,0,null,0,0.06,0,0]
["3 Bed Hse",null,null,0,0,null,0,0.06,0,0]
["4 Bed Hse",null,null,0,0,null,0,0.06,0,0]
["5 Bed Hse",null,null,0,0,null,0,0.06,0,0]
["Total",{"$f":"SUM(B23:B29)","v":0},null,null,null,null,null,null,"Total",{"$f":"SUM(J23:J29)","v":0}]
[]
["Intermediate - Shared Ownership"]
["Unit type","Off Site","OMV","Profit","Net Total Cost","Equity Rent","Mgt Charge","Yield","Capitalised","1st Tranche","Commuted"]
[null,"Provision","£",{"$f":"D22","v":0.17499999999999999},null,2.75E-2,6.5000000000000002E-2,5.5E-2,"Rent",0.35,"Sum"]
["1 Bed Flat",null,null,{"$f":"C35*$D$34","v":0},{"$f":"C35-D35","v":0},{"$f":"(C35-J35)*$F$34","v":0},{"$f":"F35*$G$34","v":0},{"$f":"$H$34","v":5.5E-2},{"$f":"(F35-G35)/H35","v":0},{"$f":"C35*$J$34","v":0},{"$f":"(E35-I35-J35)*B35","v":0}]
["2 Bed Flat",null,null,{"$f":"C36*$D$34","v":0},0,0,{"$f":"F36*$G$34","v":0},{"$f":"$H$34","v":5.5E-2},{"$f":"(F36-G36)/H36","v":0},0,{"$f":"(E36-I36-J36)*B36","v":0}]
["3 Bed Flat",null,null,0,0,0,0,5.5E-2,0,0,0]
["2 Bed Hse",null,null,0,0,0,0,5.5E-2,0,0,0]
["3 Bed Hse",null,null,0,0,0,0,5.5E-2,0,0,0]
["4 Bed Hse",null,null,0,0,0,0,5.5E-2,0,0,0]
["5 Bed Hse",null,null,0,0,0,0,5.5E-2,0,0,0]
["Total",{"$f":"SUM(B35:B41)","v":0},null,null,null,null,null,null,null,null,{"$f":"SUM(K35:K41)","v":0}]
[]
["Total Units",{"$f":"B42+B30","v":0},null,null,null,null,null,null,"Total Commuted  Sum",null,{"$f":"K42+J30","v":0}]