{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Introduction","Calculator","2023 Charge Rates","2022 Charge rates","Historic Charge rates","Definitions"],"not_rendered":{"charts":0,"images":9,"macros":1,"external_links":0,"defined_names":13,"comments":1,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Introduction","index":0,"n_rows":3,"n_cols":3,"rows_kept":3,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,null,"Winchester City Council Community Infrastructure Levy (CIL) Calculator"]

{"sheet":"Calculator","index":1,"n_rows":30,"n_cols":10,"rows_kept":30,"cut":false,"hidden":false,"merged":[[12,2,12,9],[6,1,6,2],[8,1,8,4],[10,1,10,9],[29,2,29,5],[22,9,26,9]]}
[null,null,null,null,null,null,"hidden","hidden","hidden"]
[]
[null,null,"Winchester City Council Community Infrastructure Levy (CIL) Calculator"]
[]
[]
[]
[null," 1. In which CIL Charging Zone is the development located?",null,null,null,null,null,null,null,"(link to map)"]
[]
[null," 2. What is the total GIA* (sq m) of existing floorspace (of any use) to be demolished?"]
[]
[null," 3. Use the table below to set out the GIA that is: a) proposed and b) to be retained and will form part of the completed development."]
[]
[null,null,"Charge rates have been uprated in accordance with the BICS All-in Tender Price Index (2015 to 2019) or\n RICS CIL Index (2020 onwards) and apply where permission is granted after 1 January 2022."]
[null,null,"Use°",null,"Total GIA* proposed for this use (sq m)","Total GIA to be retained for this use (sq m)","R","Ar",null,"Charge for this use (£)"]
[null,null,"  Residentialˆ ","(i)",null,null,{"$f":"IF(F7=1,0,(IF(F7=2,120,(IF(F7=3,80)))))","v":false},{"$f":"(E15-F15)-((E15*$F$9)/$E$21)","v":{"$error":"#DIV/0!"}},null,{"$f":"IF(E15<0,0,(H15*G15*$I$23)/$H$23)","v":{"$error":"#DIV/0!"}}]
[null,null,"  Hotel","(i)",null,0,{"$f":"IF(F7=1,0,(IF(F7=2,70,(IF(F7=3,70)))))","v":false},{"$error":"#DIV/0!"},null,{"$f":"IF(E16<0,0,(H16*G16*$I$23)/$H$23)","v":{"$error":"#DIV/0!"}}]
[null,null,"  Retail - all categories within the town centre - part of Zone 2","(i)",null,0,{"$f":"IF(F7=1,0,(IF(F7=2,120,(IF(F7=3,0)))))","v":false},{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"}]
[null,null,"  Retail - convenience stores, supermarkets and retail warehouses","(i)",null,0,{"$f":"IF(F7=1,0,(IF(F7=2,120,(IF(F7=3,120)))))","v":false},{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"}]
[null,null,"  Retail all other retail development","(i)",null,0,{"$f":"IF(F7=1,0,(IF(F7=2,0,(IF(F7=3,0)))))","v":false},{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"}]
[null,null,"  All Other Uses ","(i)",null,0,{"$f":"IF(F7=1,0,(IF(F7=2,0,(IF(F7=3,0)))))","v":false},{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"}]
[null,null,"Total GIA proposed",null,{"$f":"SUM(E15:E20)","v":0},null,"Sum of Kr",{"$f":"SUM(F15:F20)","v":0}]
[null,"H",null,null,null,null,"Yr","Ic","Ip"]
[null,"H",null,null,null,null,2024,237,381]
[null,"H"]
[null,null,"Total CIL payable"]
[null,"H"]
[null,null,"Notes:",null,null,null,"Zone"]
[null,null,"* GIA = Gross Internal Floor Area.  The GIA calculations should include all ancillary areas such as stairwells.",null,null,null,1]
[null,null,"° Definitions of use classes:- follow (i) link",null,null,null,2]
[null,null,"ˆSocial Housing Relief: You should exclude the area for social housing from the residential calculation.",null,null,null,3]

{"sheet":"2023 Charge Rates","index":2,"n_rows":12,"n_cols":6,"rows_kept":12,"cut":false,"hidden":false,"merged":[[2,3,2,5],[3,3,3,5]]}
[]
[]
[null,null,null,"Indexed rate from \n1 January 2023"]
[null,null,"Charging Rates","Charge per square metre"]
[null,null,"Type of Development ","Zone 1","Zone 2","Zone 3"]
[]
[null,null,"Residential",0,179.74,119.82]
[null,null,"Hotel",0,104.85,104.85]
[null,null,"Retail - all categories within the town centre","n/a",179.74,"n/a"]
[null,null,"Retail - convenience stores, supermarkets \n              and retail warehouses",0,179.74,179.74]
[null,null,"Retail - all other retail development",0,0,0]
[null,null,"All Other Uses",0,0,0]

{"sheet":"2022 Charge rates","index":3,"n_rows":12,"n_cols":6,"rows_kept":12,"cut":false,"hidden":false,"merged":[[2,3,2,5],[3,3,3,5]]}
[]
[]
[null,null,null,"Indexed rate from \n1 January 2022"]
[null,null,"Charging Rates","Charge per square metre"]
[null,null,"Type of Development ","Zone 1","Zone 2","Zone 3"]
[]
[null,null,"Residential",0,{"$f":"'Historic Charge rates'!AC7","v":168.10019169329072},{"$f":"'Historic Charge rates'!AD7","v":112.06325878594249}]
[null,null,"Hotel",0,{"$f":"'Historic Charge rates'!AC8","v":98.058445154419587},{"$f":"'Historic Charge rates'!AD8","v":98.055351437699684}]
[null,null,"Retail - all categories within the town centre","n/a",{"$f":"'Historic Charge rates'!AC9","v":168.10019169329072},"n/a"]
[null,null,"Retail - convenience stores, supermarkets \n              and retail warehouses",0,{"$f":"'Historic Charge rates'!AC10","v":168.10019169329072},{"$f":"'Historic Charge rates'!AD10","v":168.09488817891375}]
[null,null,"Retail - all other retail development",0,0,0]
[null,null,"All Other Uses",0,0,0]

{"sheet":"Historic Charge rates","index":4,"n_rows":26,"n_cols":36,"rows_kept":26,"cut":false,"hidden":false,"merged":[[2,30,2,32],[3,30,3,32],[2,27,2,29],[3,27,3,29],[2,24,2,26],[3,24,3,26],[2,33,2,35],[3,33,3,35],[2,3,2,5],[2,6,2,8],[2,9,2,11],[2,12,2,14],[3,3,3,5],[3,6,3,8],[3,9,3,11],[3,12,3,14],[2,21,2,23],[3,21,3,23],[2,18,2,20],[3,18,3,20],[2,15,2,17],[3,15,3,17]]}
[]
[]
[null,null,null,"as at 7 April 2014",null,null,"After indexation.\nApplied when \nPermission granted\non or after 1 January 2015",null,null,"After indexation. \nApplied when \nPermission granted\non or after 1 January 2016",null,null,"After indexation. \nApplied when \nPermission granted\non or after 1 January 2017",null,null,"After indexation. \nApplied when \nPermission granted on or after\n1 January 2018",null,null,"After indexation. \nApplied when \nPermission granted between \n1 January and 31 December 2019",null,null,"After indexation. \nApplied when \nPermission granted between\n1 January and 31 December 2020",null,null,"After indexation. \nApplied when \nPermission granted between\n1 January and 31 December 2021",null,null,"After indexation. \nApplied when \nPermission granted between\n1 January and 31 December 2022",null,null,"After Indexation\nApplied when\nPermission granted between\n1 January  and 31 December 2023",null,null,"After Indexation\nApplied when\nPermission granted between\n1 January  and 31 December 2024"]
[null,null,"Charging Rates","Charge per square metre",null,null,"Charge per square metre",null,null,"Charge per square metre",null,null,"Charge per square metre",null,null,"Charge per square metre",null,null,"Charge per square metre",null,null,"Charge per square metre",null,null,"Charge per square metre",null,null,"Charge per square metre",null,null,"Charge per square metre",null,null,"Charge per square metre"]
[null,null,"Type of Development ","Zone 1","Zone 2","Zone 3","Zone 1","Zone 2","Zone 3","Zone 1","Zone 2","Zone 3","Zone 1","Zone 2","Zone 3","Zone 1","Zone 2","Zone 3","Zone 1","Zone 2","Zone 3","Zone 1","Zone 2","Zone 3","Zone 1","Zone 2","Zone 3","Zone 1","Zone 2","Zone 3","Zone 1","Zone 2","Zone 3","Zone 1","Zone 2","Zone 3"]
[]
[null,null,"Residential",0,120,80,0,129.11000000000001,86.08,0,139.24,92.83,0,144.81,96.54,0,158.47999999999999,105.65,0,161.01,107.34,0,{"$f":"E7+(E7*$W$21)","v":169.1133090909091},{"$f":"F7+(F7*$W$21)","v":112.74220606060607},0,{"$f":"$E7+($E7*Z$21)","v":168.60744755244755},{"$f":"$F7+($F7*AA$21)","v":112.40496503496504},0,{"$f":"$E7+($E7*AC$21)","v":168.10019169329072},{"$f":"$F7+($F7*AD$21)","v":112.06325878594249},0,179.74,119.82,0,192.91,128.61000000000001]
[null,null,"Hotel",0,70,70,0,75.319999999999993,75.319999999999993,0,81.22,81.22,0,84.47,84.47,0,92.45,92.45,0,93.92,93.92,0,{"$f":"E8+(E8*$W$21)","v":98.6494303030303},{"$f":"F8+(F8*$W$21)","v":98.6494303030303},0,{"$f":"$E8+($E8*Z$21)","v":98.354344405594404},{"$f":"$F8+($F8*AA$21)","v":98.354344405594418},0,{"$f":"$E8+($E8*AC$21)","v":98.058445154419587},{"$f":"$F8+($F8*AD$21)","v":98.055351437699684},0,104.05,104.05,0,112.53,112.53]
[null,null,"Retail - all categories within the town centre","n/a",120,"n/a","n/a",129.11000000000001,"n/a","n/a",139.24,"n/a","n/a",144.81,"n/a","n/a",158.47999999999999,"n/a","n/a",161.01,"n/a","n/a",{"$f":"E9+(E9*$W$21)","v":169.1133090909091},"n/a","n/a",{"$f":"$E9+($E9*Z$21)","v":168.60744755244755},"n/a","n/a",{"$f":"$E9+($E9*AC$21)","v":168.10019169329072},"n/a","n/a",179.74,"n/a","n/a",192.91,"n/a"]
[null,null,"Retail - convenience stores, supermarkets \n              and retail warehouses",0,120,120,0,129.11000000000001,129.11000000000001,0,139.24,139.24,0,144.81,144.81,0,158.47999999999999,158.47999999999999,0,161.01,161.01,0,{"$f":"E10+(E10*$W$21)","v":169.1133090909091},{"$f":"F10+(F10*$W$21)","v":169.1133090909091},0,{"$f":"$E10+($E10*Z$21)","v":168.60744755244755},{"$f":"$F10+($F10*AA$21)","v":168.60744755244758},0,{"$f":"$E10+($E10*AC$21)","v":168.10019169329072},{"$f":"$F10+($F10*AD$21)","v":168.09488817891375},0,179.74,179.74,0,192.91,192.91]
[null,null,"Retail - all other retail development",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"All Other Uses",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[]
[]
[null,null,"2015 to 2019 - RICS all-in tender price index as at November of preceding year\n2020 onwards - RICS CIL Index",null,237,null,null,255,null,null,275,null,null,286,null,null,313,null,null,318,null,null,334,null,null,333,null,null,332]
[]
[null,null,"Indexed rate/sqm",null,{"$f":"E7/E16*E16","v":120.00000000000001},{"$f":"F7/E16*E16","v":80},null,{"$f":"E7/E16*H16","v":129.11392405063293},{"$f":"F7/E16*H16","v":86.075949367088597},null,{"$f":"E7/E16*K16","v":139.24050632911394},{"$f":"F7/E16*K16","v":92.827004219409275},null,{"$f":"E7/E16*N16","v":144.81012658227849},{"$f":"F7/E16*N16","v":96.540084388185647},null,{"$f":"E7/E16*Q16","v":158.48101265822785},{"$f":"F7/E16*Q16","v":105.65400843881856},null,{"$f":"H7/H16*T16","v":161.00776470588238},{"$f":"I7/H16*T16","v":107.34682352941176},null,{"$f":"K7/K16*W16","v":169.1133090909091},{"$f":"L7/K16*W16","v":112.74625454545453},null,{"$f":"N7/N16*Z16","v":168.60744755244755},{"$f":"O7/N16*Z16","v":112.40496503496504},null,{"$f":"Q7/Q16*AC16","v":168.10019169329072},{"$f":"R7/Q16*AC16","v":112.06325878594249}]
[]
[]
[null,null,"%age increase from 2014 base",null,{"$f":"(E18-E7)/E7","v":1.1842378929335003E-16},{"$f":"(F18-F7)/F7","v":0},null,{"$f":"(H18-$E$7)/$E$7","v":7.5949367088607764E-2},{"$f":"(I18-$F$7)/$F$7","v":7.5949367088607472E-2},null,{"$f":"(K18-$E$7)/$E$7","v":0.16033755274261619},{"$f":"(L18-$F$7)/$F$7","v":0.16033755274261594},null,{"$f":"(N18-$E$7)/$E$7","v":0.2067510548523207},{"$f":"(O18-$F$7)/$F$7","v":0.20675105485232059},null,{"$f":"(Q18-$E$7)/$E$7","v":0.32067510548523209},{"$f":"(R18-$F$7)/$F$7","v":0.32067510548523204},null,{"$f":"(T18-$E$7)/$E$7","v":0.34173137254901981},{"$f":"(U18-$F$7)/$F$7","v":0.34183529411764707},null,{"$f":"(W18-$E$7)/$E$7","v":0.40927757575757584},{"$f":"(X18-$F$7)/$F$7","v":0.40932818181818165},null,{"$f":"(Z18-$E$7)/$E$7","v":0.40506206293706293},{"$f":"(AA18-$F$7)/$F$7","v":0.40506206293706304},null,{"$f":"(AC18-$E$7)/$E$7","v":0.40083493077742272},{"$f":"(AD18-$F$7)/$F$7","v":0.40079073482428118}]
[]
[]
[]
[]
[null,null,"Parish limit/residential property",null,null,100,null,{"$f":"$F$26/$E$16*H16","v":107.59493670886076},null,null,{"$f":"$F$26/$E$16*K16","v":116.03375527426161},null,null,{"$f":"$F$26/$E$16*N16","v":120.67510548523207},null,null,{"$f":"$F$26/$E$16*Q16","v":132.06751054852322},null,null,{"$f":"$F$26/$E$16*T16","v":134.17721518987341},null,null,{"$f":"$F$26/$E$16*W16","v":140.9282700421941},null,null,{"$f":"$F$26/$E$16*Z16","v":140.50632911392407},null,null,{"$f":"$F$26/$E$16*AC16","v":140.08438818565401}]

{"sheet":"Definitions","index":5,"n_rows":3,"n_cols":3,"rows_kept":3,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,null,"Winchester City Council Community Infrastructure Levy (CIL) Calculator"]