{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Special Rates 2021-22","DATA","Firing Range"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":57,"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":"Special Rates 2021-22","index":0,"n_rows":142,"n_cols":19,"rows_kept":142,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[null,null,null,null,"2021/22 Calculation of Special School Funding Rates"]
[]
[]
[]
[null,"DfE",null,null,{"$f":"IFERROR(VLOOKUP(DFENUM,DATA!B5:C28,2,0),\"\")","v":""}]
[]
[]
[null,"Section 1 - Commissioned Place numbers"]
[]
[null,"Academic Year","Pre-16","Post-16","Weekday Residential","Weekend Residential",null,"High Needs Place numbers as agreed annually with the Local Authority's SEN team\n\n"]
[]
[null,"2020/21",{"$f":"IFERROR(VLOOKUP(DFENUM,DATA!B5:K28,3,0),0)","v":0},{"$f":"IFERROR(VLOOKUP(DFENUM,DATA!B5:K28,5,0),0)","v":0},{"$f":"IFERROR(VLOOKUP(DFENUM,DATA!B5:K28,7,0),0)","v":0},{"$f":"IFERROR(VLOOKUP(DFENUM,DATA!B5:K28,9,0),0)","v":0},null,"Place numbers 2020-21 agreed November 2019"]
[]
[null,"2021/22",{"$f":"IFERROR(VLOOKUP(DFENUM,DATA!B5:K28,4,0),0)","v":0},{"$f":"IFERROR(VLOOKUP(DFENUM,DATA!B5:K28,6,0),0)","v":0},{"$f":"IFERROR(VLOOKUP(DFENUM,DATA!B5:K28,8,0),0)","v":0},{"$f":"IFERROR(VLOOKUP(DFENUM,DATA!B5:K28,10,0),0)","v":0},null,"Place numbers 2021-22 agreed November 2020"]
[]
[null,"Movement",{"$f":"C17-C15","v":0},{"$f":"D17-D15","v":0},{"$f":"E17-E15","v":0},{"$f":"F17-F15","v":0}]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Day Pupil",null,null,null,"Weekday",null,null,"Weekend"]
[null,"Section 2 - Calculation of funding rate for April 2021 to March 2022"]
[null,null,null,null,null,null,null,null,null,"MLD & SLCN","SEMH","SLD","PD & PMLD","ASD",null,"PD & PMLD","ASD",null,"PD & PMLD"]
[]
["(A)","April 2021 to August 2021 (Formula only excluding MFG)-",null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(DFENUM,DATA!B5:AA28,11,0),0)","v":0},{"$f":"IFERROR(VLOOKUP(DFENUM,DATA!B5:AA28,17,0),0)","v":0},{"$f":"IFERROR(VLOOKUP(DFENUM,DATA!B5:AA28,20,0),0)","v":0},{"$f":"IFERROR(VLOOKUP(DFENUM,DATA!B5:AA28,23,0),0)","v":0},{"$f":"IFERROR(VLOOKUP(DFENUM,DATA!B5:AA28,14,0),0)","v":0},null,{"$f":"IFERROR(VLOOKUP(DFENUM,DATA!B5:BX28,50,0),0)","v":0},{"$f":"IFERROR(VLOOKUP(DFENUM,DATA!B5:BX28,47,0),0)","v":0},null,{"$f":"IFERROR(VLOOKUP(DFENUM,DATA!B5:BX28,53,0),0)","v":0}]
[null,"Based on  Academic Year 2020 to 2021. Data taken from 2020-21 Funding Rates Calculation."]
[]
["(B)","September 2021 to March 2022 (Formula only excluding MFG)",null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(DFENUM,DATA!B5:AA28,12,0),0)","v":0},{"$f":"IFERROR(VLOOKUP(DFENUM,DATA!B5:AA28,18,0),0)","v":0},{"$f":"IFERROR(VLOOKUP(DFENUM,DATA!B5:AA28,21,0),0)","v":0},{"$f":"IFERROR(VLOOKUP(DFENUM,DATA!B5:AA28,24,0),0)","v":0},{"$f":"IFERROR(VLOOKUP(DFENUM,DATA!B5:AA28,15,0),0)","v":0},null,{"$f":"IFERROR(VLOOKUP(DFENUM,DATA!B5:BX28,52,0),0)","v":0},{"$f":"IFERROR(VLOOKUP(DFENUM,DATA!B5:BX28,49,0),0)","v":0},null,{"$f":"IFERROR(VLOOKUP(DFENUM,DATA!B5:BX28,55,0),0)","v":0}]
[null,"Based on  Academic Year 2021 to 2022. See section 3 for calculation."]
[]
["(C)","April 2021 to March 2022",null,null,null,null,null,null,"= (A) X 5/12",{"$f":"(J27*5/12)+(J30*7/12)","v":0},{"$f":"(K27*5/12)+(K30*7/12)","v":0},{"$f":"(L27*5/12)+(L30*7/12)","v":0},{"$f":"(M27*5/12)+(M30*7/12)","v":0},{"$f":"(N27*5/12)+(N30*7/12)","v":0},null,{"$f":"IF(DFENUM=7073,P27,(P27*5/12)+(P30*7/12))","v":0},{"$f":"IF(DFENUM=7073,Q27,(Q27*5/12)+(Q30*7/12))","v":0},null,{"$f":"IF(DFENUM=7073,S27,(S27*5/12)+(S30*7/12))","v":0}]
[null,"Based on Academic Year 2020 to 2021 (April 2021 to August 2021) 5/12's + ",null,null,null,null,null,null,"+"]
[null,"Academic Year 2021 to 2022 (September 2021 to March 2022) 7/12's",null,null,null,null,null,null,"(B) X 7/12"]
[]
["(D)","Final funding rate for financial Year 2020 to 2021",null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(DFENUM,DATA!B5:AA28,13,0),0)","v":0},{"$f":"IFERROR(VLOOKUP(DFENUM,DATA!B5:AA28,19,0),0)","v":0},{"$f":"IFERROR(VLOOKUP(DFENUM,DATA!B5:AA28,22,0),0)","v":0},{"$f":"IFERROR(VLOOKUP(DFENUM,DATA!B5:AA28,25,0),0)","v":0},{"$f":"IFERROR(VLOOKUP(DFENUM,DATA!B5:AA28,16,0),0)","v":0},null,{"$f":"IFERROR(VLOOKUP(DFENUM,DATA!B5:BX28,51,0),0)","v":0},{"$f":"IFERROR(VLOOKUP(DFENUM,DATA!B5:BX28,48,0),0)","v":0},null,{"$f":"IFERROR(VLOOKUP(DFENUM,DATA!B5:BX28,54,0),0)","v":0}]
["(E)","MFG rate (D) X 100%",null,null,null,null,null,null,null,{"$f":"J37","v":0},{"$f":"K37","v":0},{"$f":"L37","v":0},0,0,null,{"$f":"P37","v":0},{"$f":"Q37","v":0},null,{"$f":"S37","v":0}]
[]
[]
[null,null,null,null,null,null,null,null,null,"MLD & SLCN","SEMH","SLD","PD & PMLD","ASD",null,"PD & PMLD","ASD",null,"PD & PMLD"]
["(F)","Final Rate (Greater of Formula (C) or MFG (E))",null,null,null,null,"Formula (C)",null,null,{"$f":"J33","v":0},{"$f":"K33","v":0},{"$f":"L33","v":0},{"$f":"M33","v":0},{"$f":"N33","v":0},null,{"$f":"P33","v":0},{"$f":"Q33","v":0},null,{"$f":"S33","v":0}]
[null,null,null,null,null,null,"MFG funding rate (E)",null,null,{"$f":"J38","v":0},{"$f":"K38","v":0},{"$f":"L38","v":0},{"$f":"M38","v":0},{"$f":"N38","v":0},null,{"$f":"P38","v":0},{"$f":"Q38","v":0},null,{"$f":"S38","v":0}]
[null,null,null,null,null,null,"Amount of MFG if (E) is greater than ( C)",null,null,{"$f":"IF(J42>J43,0,J43-J42)","v":0},{"$f":"IF(K42>K43,0,K43-K42)","v":0},0,0,0,null,{"$f":"IF(P42>P43,0,P43-P42)","v":0},0,null,{"$f":"IF(S42>S43,0,S43-S42)","v":0}]
[null,null,null,null,null,null,"Final Rate formula plus MFG",null,null,{"$f":"SUM(J42,J44)","v":0},{"$f":"SUM(K42,K44)","v":0},{"$f":"SUM(L42,L44)","v":0},{"$f":"SUM(M42,M44)","v":0},{"$f":"SUM(N42,N44)","v":0},null,{"$f":"SUM(P42,P44)","v":0},{"$f":"SUM(Q42,Q44)","v":0},null,{"$f":"SUM(S42,S44)","v":0}]
["(F)","Place Plus Breakdown"]
[null,null,null,null,null,null,"Element 1 & 2",null,null,10000,10000,10000,10000,10000,null,{"$f":"IF($P$45=0,0,10000)","v":0},{"$f":"IF($Q$45=0,0,10000)","v":0},null,{"$f":"IF($S$45=0,0,10000)","v":0}]
[null,null,null,null,null,null,"Element 3",null,null,{"$f":"J45-J47","v":-10000},{"$f":"K45-K47","v":-10000},-10000,-10000,-10000,null,{"$f":"P45-P47","v":0},0,null,{"$f":"S45-S47","v":0}]
[null,null,null,null,null,null,"Total rate",null,null,{"$f":"SUM(J47:J48)","v":0},{"$f":"SUM(K47:K48)","v":0},{"$f":"SUM(L47:L48)","v":0},{"$f":"SUM(M47:M48)","v":0},{"$f":"SUM(N47:N48)","v":0},null,{"$f":"SUM(P47:P48)","v":0},{"$f":"SUM(Q47:Q48)","v":0},null,{"$f":"SUM(S47:S48)","v":0}]
[null,"Section 3 - Pupil Led Elements"]
[null,null,null,null,null,null,null,null,null,"MLD & SLCN","SEMH","SLD","PD & PMLD","ASD",null,"PD & PMLD","ASD",null,"PD & PMLD"]
[null,"Day Rate",null,null,null,null,null,null,null,9508.1552216756936,15744.490719770669,13651.3856982532,20556.053500131722,15744.490719770669,null,{"$f":"IF($P$30=0,0,M52)","v":0},{"$f":"IF($Q$30=0,0,N52)","v":0},null,{"$f":"IF($S$33=0,0,M52)","v":0}]
[null,"Adjusted Rate due to School type (see note)",null,null,null,null,null,null,null,0,0,0,0,{"$f":"IFERROR(VLOOKUP(DFENUM,DATA!B5:BE28,27,0),0)-N52","v":-15744.490719770669},null,0,{"$f":"IF($Q$30=0,0,N53)","v":0},null,0]
[null,"Residential Weekday rate",null,null,null,null,null,null,null,0,0,0,0,0,null,{"$f":"IF($P$30=0,0,IFERROR(VLOOKUP(DFENUM,DATA!B5:BX26,56,0),0))","v":0},{"$f":"IF($Q$30=0,0,IFERROR(VLOOKUP(DFENUM,DATA!B5:BX26,56,0),0))","v":0},null,{"$f":"IF($S$33=0,0,IFERROR(VLOOKUP(DFENUM,DATA!B5:BX26,56,0),0))","v":0}]
[null,"Residential Weekend rate",null,null,null,null,null,null,null,0,0,0,0,0,null,0,0,null,{"$f":"IF($S$33=0,0,IFERROR(VLOOKUP(DFENUM,DATA!B5:BX26,57,0),0))","v":0}]
[null,"Subsidy on day places (catering)",null,null,null,null,null,null,null,113.5472,{"$f":"$J56","v":113.5472},{"$f":"$J56","v":113.5472},113.5472,113.5472,null,{"$f":"IF($P$30=0,0,M56)","v":0},{"$f":"IF($Q$30=0,0,N56)","v":0},null,{"$f":"IF($S$33=0,0,P56)","v":0}]
[null,"Lunch Grant",null,null,null,null,null,null,null,11.783200000000004,{"$f":"$J57","v":11.783200000000004},11.783200000000004,11.783200000000004,11.783200000000004,null,{"$f":"IF($P$30=0,0,M57)","v":0},{"$f":"IF($Q$30=0,0,N57)","v":0},null,{"$f":"IF($S$33=0,0,P57)","v":0}]
[null,"Specialist Schools Funding",null,null,null,null,null,null,null,97.780110497237587,97.780110497237587,97.780110497237587,97.780110497237587,97.780110497237587,null,{"$f":"IF($P$30=0,0,M58)","v":0},{"$f":"IF($Q$30=0,0,N58)","v":0},null,0]
[null,"Further Delegation",null,null,null,null,null,null,null,46.656237388361738,46.656237388361738,46.656237388361738,46.656237388361738,46.656237388361738,null,{"$f":"IF($P$30=0,0,M59)","v":0},{"$f":"IF($Q$30=0,0,N59)","v":0},null,0]
[null,"Residential Weekday Places Catering",null,null,null,null,null,null,null,0,0,0,0,0,null,{"$f":"IF($P$30=0,0,1456.83)","v":0},{"$f":"IF($Q$30=0,0,1456.83)","v":0},null,0]
[null,"Residential Weekend Places Catering",null,null,null,null,null,null,null,0,0,0,0,0,null,0,0,null,{"$f":"IF($S$33=0,0,2195.96)","v":0}]
[null,"London Fringe Day Pupil",null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(DFENUM,DATA!B5:BE28,29,0),0)","v":0},{"$f":"IFERROR(VLOOKUP(DFENUM,DATA!B5:BE28,30,0),0)","v":0},{"$f":"IFERROR(VLOOKUP(DFENUM,DATA!B5:BE28,31,0),0)","v":0},{"$f":"IFERROR(VLOOKUP(DFENUM,DATA!B5:BE28,32,0),0)","v":0},{"$f":"IFERROR(VLOOKUP(DFENUM,DATA!B5:BE28,33,0),0)","v":0},null,0,0,null,0]
[null,"London Fringe Weekday Residential Pupil",null,null,null,null,null,null,null,0,0,0,0,0,null,{"$f":"IF($P$30=0,0,IFERROR(VLOOKUP(DFENUM,DATA!B5:BX28,58,0),0))","v":0},{"$f":"IF($Q$30=0,0,IFERROR(VLOOKUP(DFENUM,DATA!B5:BX28,58,0),0))","v":0},null,0]
[null,"London Fringe Weekend Residential Pupil",null,null,null,null,null,null,null,0,0,0,0,0,null,0,0,null,{"$f":"IF($S$33=0,0,IFERROR(VLOOKUP(DFENUM,DATA!B5:BX28,59,0),0))","v":0}]
[]
[null,"Rate for Pupil Led Elements",null,null,null,null,null,null,null,{"$f":"SUM(J52:J65)","v":9777.9219695612937},{"$f":"SUM(K52:K65)","v":16014.257467656269},{"$f":"SUM(L52:L65)","v":13921.1524461388},{"$f":"SUM(M52:M65)","v":20825.820248017324},{"$f":"SUM(N52:N65)","v":269.76674788559933},null,{"$f":"SUM(P52:P65)","v":0},{"$f":"SUM(Q52:Q65)","v":0},null,{"$f":"SUM(S52:S65)","v":0}]
[]
[null,"Section 4 - School Led Elements"]
[null,null,null,null,null,null,null,null,null,null,null,"Need Type"]
[null,null,null,null,null,"Units","Rate","Total","Places","MLD & SLCN","SEMH","SLD","PD & PMLD","ASD",null,"PD & PMLD","ASD",null,"PD & PMLD"]
[null,"Lump Sum Day",null,null,null,{"$f":"IF(DFENUM>0,1,0)","v":0},370989.7672,{"$f":"F71*G71","v":0},{"$f":"IF(DFENUM=7005,168,\nIF(DFENUM=7006,168,\n$C$17+$D$17))","v":0},{"$f":"IF(I71=0,0,H71/I71)","v":0},{"$f":"$J71","v":0},{"$f":"$J71","v":0},0,0,null,{"$f":"IF($P$30=0,0,M71)","v":0},{"$f":"IF($Q$30=0,0,N71)","v":0},null,{"$f":"IF($S$33=0,0,M71)","v":0}]
[null,"Lump Sum Catering Day",null,null,null,{"$f":"IF(DFENUM>0,1,0)","v":0},2142.4,{"$f":"F72*G72","v":0},0,{"$f":"IF(I72=0,0,H72/I72)","v":0},{"$f":"$J72","v":0},0,0,0,null,0,0,null,{"$f":"IF($S$33=0,0,M72)","v":0}]
[null,"Specialist Schools Funding- Lump Sum",null,null,null,{"$f":"IF(DFENUM>0,1,0)","v":0},12659.129166666668,0,0,0,0,0,0,0,null,0,0,null,0]
[null,"Free Mid-day Meals",null,null,null,{"$f":"IFERROR(VLOOKUP(DFENUM,DATA!$B$5:$BE$28,43,0),0)*I74","v":0},444.54800000000006,0,0,0,0,0,0,0,null,0,0,null,0]
[null,"Gross Day Floor Area (m2)",null,null,null,{"$f":"IFERROR(VLOOKUP(DFENUM,DATA!$B$5:$BE$28,37,0),0)","v":0},32.135997620573193,{"$f":"F75*G75","v":0},0,0,0,0,0,0,null,0,0,null,0]
[null,"Grounds Site Area (hectares)",null,null,null,{"$f":"IFERROR(VLOOKUP(DFENUM,DATA!$B$5:$BE$28,40,0),0)","v":0},1126.9023999999997,0,0,0,0,0,0,0,null,0,0,null,0]
[null,"Rentals",null,null,null,{"$f":"IF(IFERROR(VLOOKUP(DFENUM,DATA!$B$5:$BE$28,41,0),0)>0,1,0)","v":0},{"$f":"IFERROR(VLOOKUP(DFENUM,DATA!$B$5:$BE$26,41,0),0)","v":0},0,0,0,0,0,0,0,null,0,0,null,0]
[null,"Hydrotherapy Pool",null,null,null,{"$f":"IFERROR(VLOOKUP(DFENUM,DATA!$B$5:$BE$28,42,0),0)","v":0},5355.9999999999991,0,0,0,0,0,0,0,null,0,0,null,0]
[null,"Split site- Band  1",null,null,null,{"$f":"IFERROR(VLOOKUP(DFENUM,DATA!$B$5:$BE$28,45,0),0)","v":0},4689.7136,0,0,0,0,0,0,0,null,0,0,null,0]
[null,"Split site - Band 2",null,null,null,{"$f":"IFERROR(VLOOKUP(DFENUM,DATA!$B$5:$BE$28,46,0),0)","v":0},41163.002400000005,0,0,0,0,0,0,0,null,0,0,null,0]
[null,"Residential Floor Area Weekday (m2)",null,null,null,{"$f":"IFERROR(VLOOKUP(DFENUM,DATA!$B$5:$BE$28,38,0),0)","v":0},53.559509914258861,0,{"$f":"E17","v":0},0,0,0,0,0,null,{"$f":"IF($P$30=0,0,((F81*G81)/I81))","v":0},{"$f":"IF($Q$30=0,0,((F81*G81)/I81))","v":0},null,{"$f":"IF($S$33=0,0,((F81*G81)/I81))","v":0}]
[null,"Residential Floor Area Weekend (m2)",null,null,null,{"$f":"IFERROR(VLOOKUP(DFENUM,DATA!$B$5:$BE$28,39,0),0)","v":0},69.627901625493365,0,{"$f":"E17","v":0},0,0,0,0,0,null,{"$f":"IF($P$30=0,0,((F82*G82)/I82))","v":0},{"$f":"IF($Q$30=0,0,((F82*G82)/I82))","v":0},null,{"$f":"IF($S$33=0,0,((F82*G82)/I82))","v":0}]
[null,"Lump Sum Residential",null,null,null,{"$f":"IF(SUM(P33:S33)>0,1,0)","v":0},175060.86000000002,0,{"$f":"E17","v":0},0,0,0,0,0,null,{"$f":"IF($P$30=0,0,((F83*G83)/I83))","v":0},{"$f":"IF($Q$30=0,0,((F83*G83)/I83))","v":0},null,{"$f":"IF($S$33=0,0,((F83*G83)/I83))","v":0}]
[null,"London Fringe Day Pupils",null,null,null,{"$f":"IFERROR(VLOOKUP(DFENUM,DATA!$B$5:$BE$28,44,0),0)","v":0},4128.6725999999999,0,{"$f":"IF(DFENUM=7005,168,\nIF(DFENUM=7006,168,\n$C$17+$D$17))","v":0},0,0,0,0,0,null,0,0,null,0]
[null,"London Fringe Residential Pupils",null,null,null,0,0,0,{"$f":"E17","v":0},0,0,0,0,0,null,{"$f":"IF($P$30=0,0,IFERROR(VLOOKUP(DFENUM,DATA!B5:BX28,60,0),0))","v":0},{"$f":"IF($Q$30=0,0,IFERROR(VLOOKUP(DFENUM,DATA!B5:BX28,60,0),0))","v":0},null,{"$f":"IF($S$33=0,0,IFERROR(VLOOKUP(DFENUM,DATA!B5:BX28,61,0),0))","v":0}]
[]
[null,"Rate for School Led Elements",null,null,null,null,null,null,null,{"$f":"SUM(J71:J86)","v":0},{"$f":"SUM(K71:K86)","v":0},{"$f":"SUM(L71:L86)","v":0},{"$f":"SUM(M71:M86)","v":0},{"$f":"SUM(N71:N86)","v":0},null,{"$f":"SUM(P71:P86)","v":0},{"$f":"SUM(Q71:Q86)","v":0},null,{"$f":"SUM(S71:S86)","v":0}]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Need Type"]
[null,"Total Formula Rate",null,null,null,null,null,null,null,"MLD & SLCN","SEMH","SLD","PD & PMLD","ASD",null,"PD & PMLD","ASD",null,"PD & PMLD"]
[null,null,null,null,null,null,null,null,null,{"$f":"J66+J87","v":9777.9219695612937},{"$f":"K66+K87","v":16014.257467656269},{"$f":"L66+L87","v":13921.1524461388},{"$f":"M66+M87","v":20825.820248017324},{"$f":"N66+N87","v":269.76674788559933},null,{"$f":"P66+P87","v":0},{"$f":"Q66+Q87","v":0},null,{"$f":"S66+S87","v":0}]
[null,null,null,null,null,null,null,null,null,{"$f":"ROUND(J93-mldnew,1)","v":9777.9},{"$f":"ROUND(K93-besdnew,1)","v":16014.3},{"$f":"ROUND(L93-sldnew,1)","v":13921.2},{"$f":"ROUND(M93-pdnew,1)","v":20825.8},{"$f":"ROUND(N93-asdnew,1)","v":269.8},null,{"$f":"ROUND(P93-pdweekdaynew,1)","v":0},{"$f":"ROUND(Q93-asdweekdaynew,1)","v":0},null,{"$f":"ROUND(S93-pdweekendnew,1)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(J94=0,K94=0,L94=0,M94=0,N94=0),\"OK\",\"ERROR\")","v":"ERROR"},null,null,null,null,{"$f":"IF(AND(P94=0,Q94=0,S94=0),\"OK\",\"ERROR\")","v":"OK"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(N95=\"OK\",S95=\"OK\"),\"OK\",\"ERROR\")","v":"ERROR"}]
[]
[null,"Note"]
[null,"ASD"]
[null," - All ASD pupils in Stone Bay are funded at ASD2"]
[null," - 10% of all ASD places in C & I and PSCN Special Schools are funded at ASD2\n"]
[]
[]
[]
[]
[]
[]
[]
[null,"Section 5 - Analysis of Rate Changes"]
[]
[]
[null,null,null,"2020/21 Financial Year",null,"2021/22 Financial Year",null,"Movement £","Movement %"]
[null,"Pupil Led Elements"]
[null,null,"MLD & SLCN",null,{"$f":"IFERROR(VLOOKUP(DFENUM,DATA!$B:$CG,63,0),\"\")","v":""},null,{"$f":"IFERROR(VLOOKUP(DFENUM,DATA!$B:$CG,74,0),\"\")","v":""},{"$f":"IFERROR(G114-E114,\"\")","v":""},{"$f":"IFERROR(H114/E114,\"\")","v":""}]
[null,null,"SEMH",null,{"$f":"IFERROR(VLOOKUP(DFENUM,DATA!B:CG,64,0),\"\")","v":""},null,{"$f":"IFERROR(VLOOKUP(DFENUM,DATA!$B:$CG,75,0),\"\")","v":""},{"$f":"IFERROR(G115-E115,\"\")","v":""},{"$f":"IFERROR(H115/E115,\"\")","v":""}]
[null,null,"SLD",null,{"$f":"IFERROR(VLOOKUP(DFENUM,DATA!B:CG,65,0),\"\")","v":""},null,{"$f":"IFERROR(VLOOKUP(DFENUM,DATA!$B:$CG,76,0),\"\")","v":""},{"$f":"IFERROR(G116-E116,\"\")","v":""},{"$f":"IFERROR(H116/E116,\"\")","v":""},null,"This will always be 3% apart from for the SEMH rate which will be substantially more due to the removal of the SEMH 1 rate"]
[null,null,"PD & PMLD",null,{"$f":"IFERROR(VLOOKUP(DFENUM,DATA!B:CG,66,0),\"\")","v":""},null,{"$f":"IFERROR(VLOOKUP(DFENUM,DATA!$B:$CG,77,0),\"\")","v":""},{"$f":"IFERROR(G117-E117,\"\")","v":""},{"$f":"IFERROR(H117/E117,\"\")","v":""}]
[null,null,"ASD",null,{"$f":"IFERROR(VLOOKUP(DFENUM,DATA!B:CG,67,0),\"\")","v":""},null,{"$f":"IFERROR(VLOOKUP(DFENUM,DATA!$B:$CG,78,0),\"\")","v":""},{"$f":"IFERROR(G118-E118,\"\")","v":""},{"$f":"IFERROR(H118/E118,\"\")","v":""}]
[null,"School Led Elements"]
[null,null,"All",null,{"$f":"IFERROR(VLOOKUP(DFENUM,DATA!B:CG,68,0),\"\")","v":""},null,{"$f":"IFERROR(VLOOKUP(DFENUM,DATA!$B:$CG,79,0),\"\")","v":""},{"$f":"IFERROR(G120-E120,\"\")","v":""},{"$f":"IFERROR(H120/E120,\"\")","v":""}]
[null,"Minimum Funding Guarantee"]
[null,null,"MLD & SLCN",null,{"$f":"IFERROR(VLOOKUP(DFENUM,DATA!B:CG,69,0),\"\")","v":""},null,{"$f":"IFERROR(VLOOKUP(DFENUM,DATA!$B:$CG,80,0),\"\")","v":""},{"$f":"IFERROR(G122-E122,\"\")","v":""},{"$f":"IFERROR(H122/E122,\"\")","v":""}]
[null,null,"SEMH",null,{"$f":"IFERROR(VLOOKUP(DFENUM,DATA!B:CG,70,0),\"\")","v":""},null,{"$f":"IFERROR(VLOOKUP(DFENUM,DATA!$B:$CG,81,0),\"\")","v":""},{"$f":"IFERROR(G123-E123,\"\")","v":""},{"$f":"IFERROR(H123/E123,\"\")","v":""}]
[null,null,"SLD",null,{"$f":"IFERROR(VLOOKUP(DFENUM,DATA!B:CG,71,0),\"\")","v":""},null,{"$f":"IFERROR(VLOOKUP(DFENUM,DATA!$B:$CG,82,0),\"\")","v":""},{"$f":"IFERROR(G124-E124,\"\")","v":""},{"$f":"IFERROR(H124/E124,\"\")","v":""},null,"This can vary but will be reduced on account of increases in the above two elements"]
[null,null,"PD & PMLD",null,{"$f":"IFERROR(VLOOKUP(DFENUM,DATA!B:CG,72,0),\"\")","v":""},null,{"$f":"IFERROR(VLOOKUP(DFENUM,DATA!$B:$CG,83,0),\"\")","v":""},{"$f":"IFERROR(G125-E125,\"\")","v":""},{"$f":"IFERROR(H125/E125,\"\")","v":""}]
[null,null,"ASD",null,{"$f":"IFERROR(VLOOKUP(DFENUM,DATA!B:CG,73,0),\"\")","v":""},null,{"$f":"IFERROR(VLOOKUP(DFENUM,DATA!$B:$CG,84,0),\"\")","v":""},{"$f":"IFERROR(G126-E126,\"\")","v":""},{"$f":"IFERROR(H126/E126,\"\")","v":""}]
[]
[]
[null,"Section 6 - 2021/22 Nursery Provision Lump Sum Calculation"]
[]
[null,"Rates"]
[]
[null,"Leadership Lump Sum per provision",null,null,53560]
[null,"Day Rate per FTE (see breakdown)",null,null,9299.8700000000008]
[]
[null,"Calculation"]
[]
[null,null,null,"Units","Rate","Total"]
[null,"Leadership Lump Sum",null,{"$f":"IF(D140>9,2,IF(D140>0,1,0))","v":0},{"$f":"E133","v":53560},{"$f":"D139*E139","v":0}]
[null,"Day Rate",null,{"$f":"IFERROR(VLOOKUP('Special Rates 2021-22'!DFENUM,DATA!B:BK,62,0),0)","v":0},{"$f":"E134","v":9299.8700000000008},{"$f":"D140*E140","v":0}]
[]
[null,null,null,null,"Total Funding at this provision:",{"$f":"IFERROR(ROUND(F140+F139,0),\"TBC\")","v":0}]

{"sheet":"DATA","index":1,"n_rows":28,"n_cols":85,"rows_kept":28,"cut":false,"hidden":true,"merged":[[2,29,2,36],[2,14,2,16],[2,17,2,19],[2,20,2,22],[1,11,1,25],[2,23,2,25],[2,11,2,13],[1,3,1,10],[2,3,2,4],[2,5,2,6],[2,7,2,8],[2,9,2,10],[2,58,2,59],[2,60,2,61],[1,47,1,55],[2,47,2,49],[2,50,2,52],[2,53,2,55],[2,56,2,57],[1,63,1,73],[2,63,2,67],[2,69,2,73],[1,74,1,84],[2,74,2,78],[2,80,2,84]]}
[null,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,56,57,58,59,60,61,62,63,64,65,66,67,68,69,70,71,72,73,74,75,76,77,78,79,80,81,82,83,84]
[null,null,null,"Places",null,null,null,null,null,null,null,"Rates",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Residential Rates",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2020/21 Financial Year",null,null,null,null,null,null,null,null,null,null,"2021/22 Financial Year"]
[null,null,null,"Pre-16",null,"Post-16",null,"Weekday",null,"Weekend",null,"MLD & SLCN",null,null,"ASD",null,null,"SEMH",null,null,"SLD",null,null,"PD & PMLD",null,null,null,null,null,"London Fringe",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ASD Weekday",null,null,"PD Weekday",null,null,"PD Weekend",null,null,"Residential Winter Rates",null,"Residential Pupil Fringe",null,"Residential School Fringe",null,null,"Pupil Led",null,null,null,null,"School","MFG",null,null,null,null,"Pupil Led",null,null,null,null,"School","MFG"]
[null,"DFE","School","20/21","21/22","20/21","21/22","20/21","21/22","20/21","21/22","Summer","Winter","Old Financial Year","Summer","Winter","Old Financial Year","Summer","Winter","Old Financial Year","Summer","Winter","Old Financial Year","Summer","Winter","Old Financial Year",null,"ASD Rate","SEMH Rate","MLD & SLCN","SEMH","SLD","PD & PMLD","ASD","Residential weekdayASD","Residential weekdayPD & PMLD","Residential WeekendPD & PMLD","Gross Day Floor Area","Residential floor area weekday","Residential floor area weekend","Grounds site area","Rentals","Hydrotherapy Pool","No of FSM","London Fringe","Split  site- Band  1","Split site - Band 2","Summer","Last Financial Year","Winter","Summer","Last Financial Year","Winter","Summer","Last Financial Year","Winter","Weekday","Weekend","Weekday","Weekend","Weekday","Weekend","Nursery FTE","MLD&SLCN","SEMH","SLD","PD&PMLD","ASD","All","MLD&SLCN","SEMH","SLD","PD&PMLD","ASD","MLD&SLCN","SEMH","SLD","PD&PMLD","ASD","All","MLD&SLCN","SEMH","SLD","PD&PMLD","ASD"]
[null,7002,"Broomhill Bank School",218,218,100,100,23,23,0,0,12407.498397077656,12451.117273294147,14529.83,19447.384874437168,19491.003750653661,20545.71,18658.901795131274,18702.520671347767,15687.060000000001,16575.274657335955,16618.893533552447,18083.41,23520.822160430831,23564.441036647324,24009.61,null,16504.906752666462,15744.490719770669,43.290266986246721,58.358166944889987,67.836050667038776,108.71575188339635,86.425213354992252,942.1406202545985,0,0,11140.8930014898,632.10699851023674,0,10.685,0,0,0.24873096446700502,1,0,1,57307.841383929161,59779.4,57351.46026014565,0,0,0,0,0,0,26464.596013306229,0,942.1406202545985,0,12.983247169811321,0,{"$error":"#VALUE!"},9530.7054991678488,11533.661206638648,13577.090217865225,20320.340220869966,16365.546739322719,2859.3070092525231,2139.818686766479,1294.0896899526197,1647.0159532279358,829.96121929953733,1320.8519657689576,9821.2122365475407,16072.615634601159,13988.98849680584,20934.53599990072,16861.098713907057,2611.730504989735,2096.8872584627225,0,1482.6909982044235,463.3434951095478,1072.8807811032093]
[null,7005,"Aspire School",32,88,0,0,0,0,0,0,12851.453308560915,12851.453308560915,12406.19,19848.204839551687,19848.204839551687,19199.190000000002,19087.788806655888,19087.788806655888,14395.189999999999,16994.683785138419,16994.683785138419,16429.189999999999,23899.351587016947,23899.351587016947,23132.190000000002,null,16504.906752666462,15744.490719770669,0,0,0,0,0,0,0,0,3227,0,0,1.7432000000000001,0,0,0.33333333333333298,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$error":"#VALUE!"},0,0,0,0,0,0,0,0,0,0,0,9777.9219695612937,16014.257467656269,13921.1524461388,20825.820248017328,16774.673500552064,3073.5313389996213,0,0,0,0,0]
[null,7006,"Snowfields Academy",60,96,0,0,0,0,0,0,12890.696882526703,12890.696882526703,12450.83,19887.448413517475,19887.448413517475,19243.830000000002,19127.032380621677,19127.032380621677,14439.83,17033.927359104207,17033.927359104207,16473.830000000002,23938.595160982735,23938.595160982735,23176.83,null,16504.906752666462,15744.490719770669,0,0,0,0,0,0,0,0,3480,0,0,1.383,0,0,0.31818181818181801,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$error":"#VALUE!"},0,0,0,0,0,0,0,0,0,0,0,9777.9219695612937,16014.257467656269,13921.1524461388,20825.820248017328,16774.673500552064,3112.7749129654094,0,0,0,0,0]
[null,7021,"Valence School",72,80,33,31,46,46,18,18,16737.704764452399,16329.008899149521,16230.93,23101.377197551417,22692.68133224854,22409.25,23023.462974411723,22614.767109108849,18267.239999999998,20961.4454115029,20552.749546200026,20331.650000000001,28000.198633371074,27591.502768068203,27165.39,null,15744.490719770669,15744.490719770669,165.5509854180452,214.97369728239582,246.06115589104323,380.14657588069474,292.88792042209087,0,1218.4285723174685,1725.6130497931049,8799,0,1924,18.321999999999999,0,1,0.20481927710843401,1,0,0,0,0,0,77658.059505344791,75376.91,77249.36364004192,104490.68033580808,101427.99,104081.98447050519,40644.813337983695,25586.308352987642,1218.4285723174685,1725.6130497931049,37.195248648648651,37.195248648648651,{"$error":"#VALUE!"},9653.8572378440185,11690.167131631039,13754.576312650333,20588.317304755357,15832.179988425592,6577.0728343525152,0,0,0,0,0,9943.4729549793392,16229.231164938665,14167.213602029846,21205.966823898019,16307.145388078361,6555.8258880463809,0,0,0,0,0]
[null,7032,"Bower Grove School",214,225,0,0,0,0,0,0,12419.078230834317,12336.923883103813,12050.22,18655.413728929292,18573.25938119879,18104.919999999998,18655.413728929292,18573.25938119879,14446.49,16562.308707411823,16480.154359681321,16072.779999999999,23466.976509290347,23384.822161559845,22776.34,null,15744.490719770669,15744.490719770669,0,0,0,0,0,0,0,0,4093,0,0,2.1496,0,0,0.51327433628318597,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$error":"#VALUE!"},9493.1281257876635,11889.394549857825,13515.681986542524,20219.24295924012,15547.822784132299,2557.0931364904786,0,0,0,0,0,9777.9219695612937,16014.257467656269,13921.1524461388,20825.820248017328,16014.257467656269,2593.2328917635623,0,0,0,0,0]
[null,7033,"St Anthony's School",98,98,0,0,0,0,0,0,15151.345840562875,15195.73504075963,14706.98,21387.681338657851,21432.070538854605,20761.669999999998,21387.681338657851,21432.070538854605,17037.88,19294.576317140381,19338.965517337136,18729.53,26199.244119018906,26243.63331921566,25433.09,null,15744.490719770669,15744.490719770669,0,0,0,0,0,0,0,0,3614,0,0,1.54,0,0,0.62616822429906493,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$error":"#VALUE!"},9493.1281257876635,11824.034416519175,13515.681986542524,20219.24295924012,15547.822784132299,5213.8490469296257,0,0,0,0,0,9777.9219695612937,16014.257467656269,13921.1524461388,20825.820248017328,16014.257467656269,5399.3175711163549,0,0,0,0,0]
[null,7039,"The Ifield School",210,212,40,37,0,0,0,0,12216.329440395928,12416.444635586198,11853.76,19213.080971386698,19413.196166576967,18646.72,18452.664938490903,18652.780133681172,13842.09,16359.559916973434,16559.675112163703,15876.310000000001,23264.227718851958,23464.342914042227,22579.879999999997,null,16504.906752666462,15744.490719770669,0,0,0,0,0,0,0,0,4274.1399960000008,0,0,6.22,75000,1,0.37755102040816296,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$error":"#VALUE!"},9493.1281257876635,11481.454804172401,13515.681986542524,20219.24295924012,16286.090777235015,2360.6329471214094,0,0,0,0,0,9777.9219695612937,16014.257467656269,13921.1524461388,20825.820248017328,16774.673500552064,2555.1413346956242,0,0,0,0,0]
[null,7040,"Foreland Fields School",188,191,32,33,0,0,0,0,12377.453881422296,12366.862997208646,12016.33,19374.205412413066,19363.614528199418,18809.29,18613.789379517271,18603.198495303623,14004.66,16520.684357999802,16510.093473786153,16038.89,23425.352159878326,23414.761275664678,22742.45,null,16504.906752666462,15744.490719770669,0,0,0,0,0,0,0,0,4331,0,0,4.3045,0,1,0.40223463687150796,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$error":"#VALUE!"},9493.1281257876635,11481.454804172401,13515.681986542524,20219.24295924012,16286.090777235015,2523.203923619601,0,0,0,0,0,9777.9219695612937,16014.257467656269,13921.1524461388,20825.820248017328,16774.673500552064,2593.3538960697074,0,0,0,0,0]
[null,7041,"Goldwyn School",150,156,0,33,0,0,0,0,14045.826719112833,13564.823179731447,14106.03,20282.162217207806,19801.158677826421,19682.07,20282.162217207806,19801.158677826421,18665.47,18189.057195690337,17708.053656308952,17649.93,25093.724997568861,24612.721458187476,24353.49,null,15744.490719770669,15744.490719770669,0,0,0,0,0,0,0,0,5856.3800899999997,0,0,7.3492000000000006,47900,0,0.41666666666666702,0,2,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$error":"#VALUE!"},9493.1281257876635,14531.230789142326,13515.681986542524,20219.24295924012,15547.822784132299,4134.2432730276996,478.66186751871101,0,0,0,0,9777.9219695612937,16014.257467656269,13921.1524461388,20825.820248017328,16014.257467656269,3987.3193515790636,340.78867885964246,0,0,0,0]
[null,7043,"The Beacon Folkestone",348,329,64,73,0,0,0,0,11612.130365690771,11684.064947701736,11771.35,18608.881896681545,18680.816478692508,18016.080000000002,17848.465863785746,17920.400445796713,13531.6,15755.360842268277,15827.295424279244,15381.77,22660.028644146805,22731.963226157768,21949.23,null,16504.906752666462,15744.490719770669,0,0,0,0,0,0,0,0,7676,0,0,2.4561000000000002,0,1,0.47292418772563205,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$error":"#VALUE!"},9493.1281257876635,11481.454804172401,13515.681986542524,20219.24295924012,16286.090777235015,1729.987309816119,548.23936220883661,320.1551582524462,136.09636737367873,0,0,9777.9219695612937,16014.257467656269,13921.1524461388,20825.820248017328,16774.673500552064,1876.1702356358746,117.257794802832,0,0,0,0]
[null,7044,"Rowhill School",110,132,0,0,0,0,0,0,14966.877807014556,14165.957203875618,14536.1,21330.550240113575,20529.629636974641,20714.419999999998,21260.681507406785,20459.760904267845,16972.64,19190.618454065061,18389.697850926124,18636.82,26229.371675933238,25428.451072794298,25470.559999999998,null,15744.490719770669,15744.490719770669,165.55098541804574,223.01918771529844,246.06115589104374,380.1465758806952,292.8879204220915,0,0,0,4165,0,0,1.8948,0,0,0.53623188405797106,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$error":"#VALUE!"},9653.8572378440185,12090.405184031722,13754.576312650333,20588.317304755357,15832.179988425592,4882.2388345846584,0,0,0,0,0,9943.4729549793392,16237.276655371568,14167.213602029846,21205.966823898019,16307.145388078361,4556.2011668708365,36.425878149824712,0,0,0,0]
[null,7045,"Elms School",158,158,0,0,0,0,0,0,13105.960914214065,13126.47689890939,13048.92,19342.296412309042,19362.812397004363,18783.41,19342.296412309042,19362.812397004363,15260.26,17249.191390791573,17269.707375486894,16858.739999999998,24153.859192670097,24174.375177365422,23440.760000000002,null,15744.490719770669,15744.490719770669,0,0,0,0,0,0,0,0,2771,0,0,2.13,0,0,0.73793103448275899,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$error":"#VALUE!"},9493.1281257876635,11892.531692866904,13515.681986542524,20219.24295924012,15547.822784132299,3221.5171870326603,334.27197051802432,146.21494912913113,121.54075672810359,0,14.071772240218706,9777.9219695612937,16014.257467656269,13921.1524461388,20825.820248017328,16014.257467656269,3340.0066023917107,0,0,0,0,0]
[null,7051,"Nexus School",200,200,28,28,0,0,0,0,12781.181213437128,12794.938176727126,12773.08,19777.932744427897,19791.689707717898,19358.809999999998,19017.516711532102,19031.273674822103,14600.18,16924.411690014633,16938.168653304634,16588.400000000001,23829.079491893157,23842.836455183158,23291.96,null,16504.906752666462,15744.490719770669,0,0,0,0,0,0,0,0,6916,0,0,2.36,0,1,0.30246913580246898,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$error":"#VALUE!"},9493.1281257876635,11481.454804172401,13515.681986542524,20219.24295924012,16286.090777235015,3072.714265015009,207.23455720164384,46.011136281140352,0,0,0,9777.9219695612937,16014.257467656269,13921.1524461388,20825.820248017328,16774.673500552064,3011.2841391283337,0,0,0,0,0]
[null,7052,"Grange Park School",100,91,50,53,0,0,0,0,12895.431577037925,13025.035357207142,12861.07,19892.183108028694,20021.786888197916,19294.78,19131.767075132902,19261.370855302117,14744.24,17038.662053615433,17168.265833784648,16670.89,23943.329855493954,24072.933635663176,23196.620000000003,null,16504.906752666462,15744.490719770669,0,0,0,0,0,0,0,0,1958.53,0,0,1.1245000000000001,0,0,0.27472527472527497,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$error":"#VALUE!"},9493.1281257876635,11481.454804172401,13515.681986542524,20219.24295924012,16286.090777235015,2977.3724177598997,390.56454904473503,285.41265739939263,177.8333352548143,0,31.321331900915538,9777.9219695612937,16014.257467656269,13921.1524461388,20825.820248017328,16774.673500552064,3193.1118125753414,0,0,0,0,0]
[null,7056,"Five Acre Wood School",420,542,50,59,0,0,0,0,11389.534553589108,11089.552393427863,11254.39,18386.286084579879,18086.303924418637,17846.72,17625.870051684084,17325.887891522838,13042.08,15532.765030166614,15232.782870005369,15076.310000000001,22437.432832045139,22137.450671883897,21779.870000000003,null,16504.906752666462,15744.490719770669,0,0,0,0,0,0,0,0,7768.4,0,0,2.6381999999999999,9259,1,0.33466135458167301,0,1,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$error":"#VALUE!"},9493.1281257876635,11481.454804172401,13515.681986542524,20219.24295924012,16286.090777235015,1560.6243133500543,200.63756086228022,0,0,0,0,9777.9219695612937,16014.257467656269,13921.1524461388,20825.820248017328,16774.673500552064,1436.6229906004219,39.84503983828472,0,0,0,0]
[null,7058,"Stone Bay School",65,69,15,21,18,18,0,0,15814.326036452789,15191.678851242625,16536.41,29654.821863505709,29032.174678295545,29561.88,22050.661534547766,21428.014349337598,18448.260000000002,19957.556513030297,19334.909327820129,20404.25,26862.224314908821,26239.577129698657,26850.62,null,23348.65104872861,15744.490719770669,0,0,0,0,0,0,0,0,2396.216342490492,1481.783657509508,0,0.96,0,1,0.45,0,0,0,77583.763841683729,76094.84,76961.116656473561,74791.166293086848,73383.58,74168.51910787668,0,0,0,32337.417395113174,0,0,0,0,0,{"$error":"#VALUE!"},9493.1281257876635,11481.454804172401,13515.681986542524,20219.24295924012,22930.502715159429,6631.3800484653948,411.90234078677349,335.42823777198282,257.18873075774172,0,0,9777.9219695612937,16014.257467656269,13921.1524461388,20825.820248017328,23618.417796614216,5673.1932088522335,1085.2948215864744,0,809.90434500896663,351.60654313044142,270.26899453355509]
[null,7062,"The Orchard School",83,85,0,0,0,0,0,0,15629.409695226384,15539.769547944512,15171.59,21865.74519332136,21776.105046039487,21226.28,21865.74519332136,21776.105046039487,17461.689999999999,19772.640171803891,19683.000024522018,19194.14,26677.307973682415,26587.667826400542,25897.7,null,15744.490719770669,15744.490719770669,0,0,0,0,0,0,0,0,2505,0,0,1.81,0,0,0.56701030927834994,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$error":"#VALUE!"},9493.1281257876635,11783.235056878704,13515.681986542524,20219.24295924012,15547.822784132299,5678.4584517424464,0,0,0,0,0,9777.9219695612937,16014.257467656269,13921.1524461388,20825.820248017328,16014.257467656269,5799.197639750666,0,0,0,0,0]
[null,7063,"St Nicholas' School",249,273,43,39,0,0,0,0,12649.782364494578,12487.165587942236,12370.3,19646.533895485347,19483.917118933005,19163.259999999998,18886.117862589552,18723.501086037213,14358.63,16793.012841072083,16630.396064519744,16392.849999999999,23697.680642950607,23535.063866398265,23096.41,null,16504.906752666462,15744.490719770669,0,0,0,0,0,0,0,0,3971.7700100000002,0,0,0.93049999999999999,122554,1,0.369649805447471,0,6,3,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$error":"#VALUE!"},9493.1281257876635,11481.454804172401,13515.681986542524,20219.24295924012,16286.090777235015,2877.1703995868706,0,0,0,0,0,9777.9219695612937,16014.257467656269,13921.1524461388,20825.820248017328,16774.673500552064,2777.0006086110852,0,0,0,0,0]
[null,7066,"Milestone Academy",285,285,55,55,0,0,0,0,12292.942657044421,12289.579782520404,11954.58,19431.176812124679,19427.813937600666,18884.91,18578.700867003747,18575.33799247973,13990.89,16516.683304094928,16513.320429570911,16055.3,23555.436525963101,23552.073651439088,22889.040000000001,null,16504.906752666462,15744.490719770669,165.91895980307237,215.34167166742193,246.4291302760704,380.51455026572194,307.40158389255805,0,0,0,7151,0,0,4.6768999999999998,0,1,0.28919860627177701,1,0,3,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$error":"#VALUE!"},9653.8572378440185,11690.167131631037,13754.576312650333,20588.317304755357,16584.181660252034,2300.7243315297274,0,0,0,0,0,9943.8409293643672,16229.599139323693,14167.581576414872,21206.334798283046,17082.075084444623,2347.14005087438,0,0,0,0,0]
[null,7067,"Portal House School",80,80,0,0,0,0,0,0,16269.834936178362,16277.311042968357,16589.669999999998,22506.170434273336,22513.646541063332,22324.16,22506.170434273336,22513.646541063332,21361.33,20413.065412755866,20420.541519545863,20399.489999999998,27317.733214634391,27325.209321424387,26748.54,null,15744.490719770669,15744.490719770669,0,0,0,0,0,0,0,0,3816,0,0,0.81,0,0,0.29850746268656697,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$error":"#VALUE!"},9493.1281257876635,14531.230789142326,13515.681986542524,20219.24295924012,15547.822784132299,6174.6658259213764,921.8761944776179,655.43807285792718,709.14498068769535,354.62973693926324,601.67599619980683,9777.9219695612937,16014.257467656269,13921.1524461388,20825.820248017328,16014.257467656269,6496.2740289112326,315.47400152747286,0,0,0,0]
[null,7069,"The Wyvern School",255,240,35,45,0,0,0,0,11991.363450798932,12040.424436529316,11692.78,18988.114981789702,19037.175967520088,18485.739999999998,18227.698948893907,18276.759934624293,13681.11,16134.593927376438,16183.654913106822,15715.33,23039.261729254962,23088.322714985348,22418.89,null,16504.906752666462,15744.490719770669,0,0,0,0,0,0,0,0,6156,0,0,7.6,0,1,0.33609958506224102,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$error":"#VALUE!"},9493.1281257876635,11481.454804172401,13515.681986542524,20219.24295924012,16286.090777235015,2199.6519306174946,0,0,0,0,0,9777.9219695612937,16014.257467656269,13921.1524461388,20825.820248017328,16774.673500552064,2242.0603895803624,0,0,0,0,0]
[null,7070,"Oakley School",200,170,52,42,0,0,0,0,12206.714505492659,12652.419896234425,12081.42,19203.466036483427,19649.171427225196,18874.379999999997,18443.050003587632,18888.755394329401,14069.75,16349.944982070165,16795.650372811931,16103.970000000001,23254.612783948687,23700.318174690456,22807.53,null,16504.906752666462,15744.490719770669,0,0,0,0,0,0,0,0,4287,0,0,11.4161,0,0,0.33750000000000002,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$error":"#VALUE!"},9493.1281257876635,11481.454804172401,13515.681986542524,20219.24295924012,16286.090777235015,2588.2907401366647,0,0,0,0,0,9777.9219695612937,16014.257467656269,13921.1524461388,20825.820248017328,16774.673500552064,2688.7873471973958,0,0,0,0,0]
[null,7072,"Meadowfield School",298,310,50,41,0,0,0,0,11700.163832152439,11777.396305647842,11420.64,18696.915363143209,18774.147836638615,18213.599999999999,17936.499330247414,18013.731803742819,13408.97,15843.394308729945,15920.626782225349,15443.189999999999,22748.062110608469,22825.294584103875,22146.75,null,16504.906752666462,15744.490719770669,0,0,0,0,0,0,0,0,7513,0,0,2.3725999999999998,0,1,0.39649122807017501,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$error":"#VALUE!"},9493.1281257876635,11481.454804172401,13515.681986542524,20219.24295924012,16286.090777235015,1927.5105528160357,0,0,0,0,0,9777.9219695612937,16014.257467656269,13921.1524461388,20825.820248017328,16774.673500552064,1967.2941387967965,0,0,0,0,0]
[null,7073,"Laleham Gap School",196,187,0,9,0,0,0,0,12744.004437721687,12703.303425209831,12312.93,19740.755968712459,19700.054956200602,19105.89,18980.339935816661,18939.638923304807,14301.25,16887.234914299192,16846.533901787338,16335.48,23791.902716177719,23751.201703665862,23039.040000000001,null,16504.906752666462,15744.490719770669,0,0,0,0,0,0,0,0,4885,0,0,2.5697000000000001,0,0,0.31794871794871798,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$error":"#VALUE!"},9493.1281257876635,11481.454804172401,13515.681986542524,20219.24295924012,16286.090777235015,2819.7989621059173,0,0,0,0,0,9777.9219695612937,16014.257467656269,13921.1524461388,20825.820248017328,16774.673500552064,2942.3402108618111,0,0,0,0,0]

{"sheet":"Firing Range","index":2,"n_rows":54,"n_cols":50,"rows_kept":54,"cut":false,"hidden":true,"merged":[]}
[{"$f":"COUNTIF(B1:AT1,\">0\")-22","v":3},null,7032,{"$f":"COUNTIF(D2:D108,\">0\")","v":0},7033,{"$f":"COUNTIF(F2:F108,\">0\")","v":0},7044,{"$f":"COUNTIF(H2:H108,\">0\")","v":0},7045,{"$f":"COUNTIF(J2:J108,\">0\")","v":0},7062,{"$f":"COUNTIF(L2:L108,\">0\")","v":16},7041,{"$f":"COUNTIF(N2:N108,\">0\")","v":0},7067,{"$f":"COUNTIF(P2:P108,\">0\")","v":0},7021,{"$f":"COUNTIF(R2:R108,\">0\")","v":0},7002,{"$f":"COUNTIF(T2:T108,\">0\")","v":15},7052,{"$f":"COUNTIF(V2:V108,\">0\")","v":0},7058,{"$f":"COUNTIF(X2:X108,\">0\")","v":0},7073,{"$f":"COUNTIF(Z2:Z108,\">0\")","v":0},7039,{"$f":"COUNTIF(AB2:AB108,\">0\")","v":0},7040,{"$f":"COUNTIF(AD2:AD108,\">0\")","v":0},7043,{"$f":"COUNTIF(AF2:AF108,\">0\")","v":0},7051,{"$f":"COUNTIF(AH2:AH108,\">0\")","v":17},7056,{"$f":"COUNTIF(AJ2:AJ108,\">0\")","v":0},7063,{"$f":"COUNTIF(AL2:AL108,\">0\")","v":0},7066,{"$f":"COUNTIF(AN2:AN108,\">0\")","v":0},7069,{"$f":"COUNTIF(AP2:AP108,\">0\")","v":0},7070,{"$f":"COUNTIF(AR2:AR108,\">0\")","v":0},7072,{"$f":"COUNTIF(AT2:AT108,\">0\")","v":0},7005,{"$f":"COUNTIF(AV2:AV108,\">0\")","v":0},7006,{"$f":"COUNTIF(AX2:AX108,\">0\")","v":0}]
["DFENUM",{"$f":"'Special Rates 2021-22'!DFENUM","v":0},7032,{"$f":"IF(C2=C1,0,1)","v":0},7033,{"$f":"IF(E2=E1,0,1)","v":0},7044,{"$f":"IF(G2=G1,0,1)","v":0},7045,{"$f":"IF(I2=I1,0,1)","v":0},7062,{"$f":"IF(K2=K1,0,1)","v":0},7041,{"$f":"IF(M2=M1,0,1)","v":0},7067,{"$f":"IF(O2=O1,0,1)","v":0},7021,{"$f":"IF(Q2=Q1,0,1)","v":0},7002,{"$f":"IF(S2=S1,0,1)","v":0},7052,{"$f":"IF(U2=U1,0,1)","v":0},7058,{"$f":"IF(W2=W1,0,1)","v":0},7073,{"$f":"IF(Y2=Y1,0,1)","v":0},7039,{"$f":"IF(AA2=AA1,0,1)","v":0},7040,{"$f":"IF(AC2=AC1,0,1)","v":0},7043,{"$f":"IF(AE2=AE1,0,1)","v":0},7051,{"$f":"IF(AG2=AG1,0,1)","v":0},7056,{"$f":"IF(AI2=AI1,0,1)","v":0},7063,{"$f":"IF(AK2=AK1,0,1)","v":0},7066,{"$f":"IF(AM2=AM1,0,1)","v":0},7069,{"$f":"IF(AO2=AO1,0,1)","v":0},7070,{"$f":"IF(AQ2=AQ1,0,1)","v":0},7072,{"$f":"IF(AS2=AS1,0,1)","v":0},7005,{"$f":"IF(AU2=AU1,0,1)","v":0},7006,{"$f":"IF(AW2=AW1,0,1)","v":0}]
["NAME",{"$f":"[0]!NAME","v":""},"Bower Grove School",0,"St Anthony's School",0,"Rowhill School",0,"Elms School",0,"The Orchard School",0,"Goldwyn School",0,"Portal House School",0,"Valence School",0,"Broomhill Bank School",0,"Grange Park School",0,"Stone Bay School",0,"Laleham Gap School",0,"The Ifield School",0,"Foreland Fields School",0,"The Beacon Folkestone",0,"Nexus School",0,"Five Acre Wood School",0,"St Nicholas' School",0,"Milestone Academy",0,"The Wyvern School",0,"Oakley School",0,"Meadowfield School",0,"Aspire School",0,"Snowfields Academy",0]
["preold",{"$f":"[0]!preold","v":0},214,0,98,0,110,0,158,0,83,0,150,0,80,0,72,0,218,0,100,0,65,0,196,0,210,0,188,0,348,0,200,0,420,0,249,0,285,0,255,0,200,0,298,0,32,0,60,0]
["postold",{"$f":"[0]!postold","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,33,0,100,0,50,0,15,0,0,0,40,0,32,0,64,0,28,0,50,0,43,0,55,0,35,0,52,0,50,0,0,0,0,0]
["weekdayold",{"$f":"[0]!weekdayold","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,46,0,23,0,0,0,18,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]
["weekendold",{"$f":"[0]!weekendold","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,18,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]
["prenew",{"$f":"[0]!prenew","v":0},225,0,98,0,132,0,158,0,98,1,156,0,80,0,80,0,197,1,91,0,69,0,187,0,212,0,191,0,329,0,185,1,542,0,273,0,285,0,240,0,170,0,310,0,88,0,96,0]
["postnew",{"$f":"[0]!postnew","v":0},0,0,0,0,0,0,0,0,0,0,33,0,0,0,31,0,81,1,53,0,21,0,9,0,37,0,33,0,73,0,22,1,59,0,39,0,55,0,45,0,42,0,41,0,0,0,0,0]
["weekdaynew",{"$f":"[0]!weekdaynew","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,46,0,23,0,0,0,18,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]
["weekendnew",{"$f":"[0]!weekendnew","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,18,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]
["mldold",{"$f":"[0]!mldold","v":0},12419.078230834317,0,15151.345840562875,0,14966.877807014556,0,13105.960914214065,0,15629.409695226384,0,14045.826719112833,0,16269.834936178362,0,16737.704764452399,0,12407.498397077656,0,12895.431577037925,0,15814.326036452789,0,12744.004437721687,0,12216.329440395928,0,12377.453881422296,0,11612.130365690771,0,12781.181213437128,0,11389.534553589108,0,12649.782364494578,0,12292.942657044421,0,11991.363450798932,0,12206.714505492659,0,11700.163832152439,0,12851.453308560915,0,12890.696882526703,0]
["besdold",{"$f":"[0]!besdold","v":0},18655.413728929292,0,21387.681338657851,0,21260.681507406785,0,19342.296412309042,0,21865.74519332136,0,20282.162217207806,0,22506.170434273336,0,23023.462974411723,0,18658.901795131274,0,19131.767075132902,0,22050.661534547766,0,18980.339935816661,0,18452.664938490903,0,18613.789379517271,0,17848.465863785746,0,19017.516711532102,0,17625.870051684084,0,18886.117862589552,0,18578.700867003747,0,18227.698948893907,0,18443.050003587632,0,17936.499330247414,0,19087.788806655888,0,19127.032380621677,0]
["sldold",{"$f":"[0]!sldold","v":0},16562.308707411823,0,19294.576317140381,0,19190.618454065061,0,17249.191390791573,0,19772.640171803891,0,18189.057195690337,0,20413.065412755866,0,20961.4454115029,0,16575.274657335955,0,17038.662053615433,0,19957.556513030297,0,16887.234914299192,0,16359.559916973434,0,16520.684357999802,0,15755.360842268277,0,16924.411690014633,0,15532.765030166614,0,16793.012841072083,0,16516.683304094928,0,16134.593927376438,0,16349.944982070165,0,15843.394308729945,0,16994.683785138419,0,17033.927359104207,0]
["pdold",{"$f":"[0]!pdold","v":0},23466.976509290347,0,26199.244119018906,0,26229.371675933238,0,24153.859192670097,0,26677.307973682415,0,25093.724997568861,0,27317.733214634391,0,28000.198633371074,0,23520.822160430831,0,23943.329855493954,0,26862.224314908821,0,23791.902716177719,0,23264.227718851958,0,23425.352159878326,0,22660.028644146805,0,23829.079491893157,0,22437.432832045139,0,23697.680642950607,0,23555.436525963101,0,23039.261729254962,0,23254.612783948687,0,22748.062110608469,0,23899.351587016947,0,23938.595160982735,0]
["asdold",{"$f":"[0]!asdold","v":0},18655.413728929292,0,21387.681338657851,0,21330.550240113575,0,19342.296412309042,0,21865.74519332136,0,20282.162217207806,0,22506.170434273336,0,23101.377197551417,0,19447.384874437168,0,19892.183108028694,0,29654.821863505709,0,19740.755968712459,0,19213.080971386698,0,19374.205412413066,0,18608.881896681545,0,19777.932744427897,0,18386.286084579879,0,19646.533895485347,0,19431.176812124679,0,18988.114981789702,0,19203.466036483427,0,18696.915363143209,0,19848.204839551687,0,19887.448413517475,0]
["pdweekdayold",{"$f":"[0]!pdweekdayold","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,77658.059505344791,0,0,0,0,0,74791.166293086848,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]
["asdweekdayold",{"$f":"[0]!asdweekdayold","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,57307.841383929161,0,0,0,77583.763841683729,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]
["pdweekendold",{"$f":"[0]!pdweekendold","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,104490.68033580808,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]
["mldnew",{"$f":"[0]!mldnew","v":0},12336.923883103813,0,15195.73504075963,0,14165.957203875618,0,13126.47689890939,0,14808.879796593657,1,13564.823179731447,0,16277.311042968357,0,16329.008899149521,0,12813.611112712093,1,13025.035357207142,0,15191.678851242625,0,12703.303425209831,0,12416.444635586198,0,12366.862997208646,0,11684.064947701736,0,13087.371207226863,1,11089.552393427863,0,12487.165587942236,0,12289.579782520404,0,12040.424436529316,0,12652.419896234425,0,11777.396305647842,0,12851.453308560915,0,12890.696882526703,0]
["besdnew",{"$f":"[0]!besdnew","v":0},18573.25938119879,0,21432.070538854605,0,20459.760904267845,0,19362.812397004363,0,21045.215294688631,1,19801.158677826421,0,22513.646541063332,0,22614.767109108849,0,19065.014510765712,1,19261.370855302117,0,21428.014349337598,0,18939.638923304807,0,18652.780133681172,0,18603.198495303623,0,17920.400445796713,0,19323.706705321838,1,17325.887891522838,0,18723.501086037213,0,18575.33799247973,0,18276.759934624293,0,18888.755394329401,0,18013.731803742819,0,19087.788806655888,0,19127.032380621677,0]
["sldnew",{"$f":"[0]!sldnew","v":0},16480.154359681321,0,19338.965517337136,0,18389.697850926124,0,17269.707375486894,0,18952.110273171162,1,17708.053656308952,0,20420.541519545863,0,20552.749546200026,0,16981.387372970392,1,17168.265833784648,0,19334.909327820129,0,16846.533901787338,0,16559.675112163703,0,16510.093473786153,0,15827.295424279244,0,17230.601683804369,1,15232.782870005369,0,16630.396064519744,0,16513.320429570911,0,16183.654913106822,0,16795.650372811931,0,15920.626782225349,0,16994.683785138419,0,17033.927359104207,0]
["pdnew",{"$f":"[0]!pdnew","v":0},23384.822161559845,0,26243.63331921566,0,25428.451072794298,0,24174.375177365422,0,25856.778075049686,1,24612.721458187476,0,27325.209321424387,0,27591.502768068203,0,23926.934876065268,1,24072.933635663176,0,26239.577129698657,0,23751.201703665862,0,23464.342914042227,0,23414.761275664678,0,22731.963226157768,0,24135.269485682897,1,22137.450671883897,0,23535.063866398265,0,23552.073651439088,0,23088.322714985348,0,23700.318174690456,0,22825.294584103875,0,23899.351587016947,0,23938.595160982735,0]
["asdnew",{"$f":"[0]!asdnew","v":0},18573.25938119879,0,21432.070538854605,0,20529.629636974641,0,19362.812397004363,0,21045.215294688631,1,19801.158677826421,0,22513.646541063332,0,22692.68133224854,0,19853.497590071605,1,20021.786888197916,0,29032.174678295545,0,19700.054956200602,0,19413.196166576967,0,19363.614528199418,0,18680.816478692508,0,20084.122738217637,1,18086.303924418637,0,19483.917118933005,0,19427.813937600666,0,19037.175967520088,0,19649.171427225196,0,18774.147836638615,0,19848.204839551687,0,19887.448413517475,0]
["pdweekdaynew",{"$f":"[0]!pdweekdaynew","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,77249.36364004192,0,0,0,0,0,74168.51910787668,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]
["asdweekdaynew",{"$f":"[0]!asdweekdaynew","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,57713.954099563591,1,0,0,76961.116656473561,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]
["pdweekendnew",{"$f":"[0]!pdweekendnew","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,104081.98447050519,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]
["mldyear",{"$f":"[0]!mldyear","v":0},12371.154861324856,0,15177.239540677649,0,14499.674121850177,0,13117.928571953005,0,15150.767254357293,1,13765.241321140358,0,16274.195998472525,0,16499.298843025721,0,12644.397481197742,1,12971.033782136634,0,15451.115178413525,0,12720.262180423106,0,12333.063304256919,0,12371.275865631,0,11654.092205197168,0,12959.792043147805,1,11214.544960161715,0,12554.92257817238,0,12290.980980238744,0,12019.982359141657,0,12466.70931675869,0,11745.21610835809,0,12851.453308560915,0,12890.696882526703,0]
["besdyear",{"$f":"[0]!besdyear","v":0},18607.490359419833,0,21413.575038772622,0,20793.477822242403,0,19354.264070047979,0,21387.102752452269,1,20001.576819235328,0,22510.531496567499,0,22785.057052985045,0,18895.800879251365,1,19207.369280231611,0,21687.450676508503,0,18956.597678518079,0,18569.398802351894,0,18607.611363725977,0,17890.427703292145,0,19196.127541242779,1,17450.880458256692,0,18791.258076267353,0,18576.73919019807,0,18256.317857236631,0,18703.044814853663,0,17981.551606453068,0,19087.788806655888,0,19127.032380621677,0]
["sldyear",{"$f":"[0]!sldyear","v":0},16514.385337902364,0,19320.470017255153,0,18723.414768900682,0,17261.15904853051,0,19293.997730934796,1,17908.471797717863,0,20417.42647505003,0,20723.039490076226,0,16812.173741456041,1,17114.264258714142,0,19594.345654991033,0,16863.49265700061,0,16476.293780834421,0,16514.506342208508,0,15797.322681774673,0,17103.022519725309,1,15357.775436739223,0,16698.153054749884,0,16514.721627289251,0,16163.212835719161,0,16609.939793336194,0,15888.446584935598,0,16994.683785138419,0,17033.927359104207,0]
["pdyear",{"$f":"[0]!pdyear","v":0},23419.053139780888,0,26225.137819133677,0,25762.167990768856,0,24165.826850409037,0,26198.66553281332,1,24813.139599596387,0,27322.094276928554,0,27761.792711944399,0,23757.721244550921,1,24018.932060592666,0,26499.013456869561,0,23768.160458879138,0,23380.961582712946,0,23419.174144087032,0,22701.9904836532,0,24007.690321603837,1,22262.44323861775,0,23602.820856628408,0,23553.474849157425,0,23067.880637597689,0,23514.607595214722,0,22793.114386814123,0,23899.351587016947,0,23938.595160982735,0]
["asdyear",{"$f":"[0]!asdyear","v":0},18607.490359419833,0,21413.575038772622,0,20863.346554949196,0,19354.264070047979,0,21387.102752452269,1,20001.576819235328,0,22510.531496567499,0,22862.971276124739,0,19684.283958557255,1,19967.78531312741,0,29291.611005466446,0,19717.013711413878,0,19329.814835247686,0,19368.027396621772,0,18650.843736187941,0,19956.543574138581,1,18211.29649115249,0,19551.674109163148,0,19429.215135319006,0,19016.733890132426,0,19463.460847749458,0,18741.967639348863,0,19848.20483955169,0,19887.448413517475,0]
["pdweekdayyear",{"$f":"[0]!pdweekdayyear","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,77419.653583918116,0,0,0,0,0,74427.955435047581,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]
["asdweekdayyear",{"$f":"[0]!asdweekdayyear","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,57544.740468049247,1,0,0,77220.552983644462,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]
["pdweekendyear",{"$f":"[0]!pdweekendyear","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,104252.27441438139,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]
["mldlastyear",{"$f":"[0]!mldlastyear","v":0},12050.22,0,14706.98,0,14536.1,0,13048.92,0,15171.59,0,14106.03,0,16589.669999999998,0,16230.93,0,14529.83,0,12861.07,0,16536.41,0,12312.93,0,11853.76,0,12016.33,0,11771.35,0,12773.08,0,11254.39,0,12370.3,0,11954.58,0,11692.78,0,12081.42,0,11420.64,0,12406.19,0,12450.83,0]
["besdlastyear",{"$f":"[0]!besdlastyear","v":0},14446.49,0,17037.88,0,16972.64,0,15260.26,0,17461.689999999999,0,18665.47,0,21361.33,0,18267.239999999998,0,15687.060000000001,0,14744.24,0,18448.260000000002,0,14301.25,0,13842.09,0,14004.66,0,13531.6,0,14600.18,0,13042.08,0,14358.63,0,13990.89,0,13681.11,0,14069.75,0,13408.97,0,14395.189999999999,0,14439.83,0]
["sldlastyear",{"$f":"[0]!sldlastyear","v":0},16072.779999999999,0,18729.53,0,18636.82,0,16858.739999999998,0,19194.14,0,17649.93,0,20399.489999999998,0,20331.650000000001,0,18083.41,0,16670.89,0,20404.25,0,16335.48,0,15876.310000000001,0,16038.89,0,15381.77,0,16588.400000000001,0,15076.310000000001,0,16392.849999999999,0,16055.3,0,15715.33,0,16103.970000000001,0,15443.189999999999,0,16429.189999999999,0,16473.830000000002,0]
["pdlastyear",{"$f":"[0]!pdlastyear","v":0},22776.34,0,25433.09,0,25470.559999999998,0,23440.760000000002,0,25897.7,0,24353.49,0,26748.54,0,27165.39,0,24009.61,0,23196.620000000003,0,26850.62,0,23039.040000000001,0,22579.879999999997,0,22742.45,0,21949.23,0,23291.96,0,21779.870000000003,0,23096.41,0,22889.040000000001,0,22418.89,0,22807.53,0,22146.75,0,23132.190000000002,0,23176.83,0]
["asdlastyear",{"$f":"[0]!asdlastyear","v":0},18104.919999999998,0,20761.669999999998,0,20714.419999999998,0,18783.41,0,21226.28,0,19682.07,0,22324.16,0,22409.25,0,20545.71,0,19294.78,0,29561.88,0,19105.89,0,18646.72,0,18809.29,0,18016.080000000002,0,19358.809999999998,0,17846.72,0,19163.259999999998,0,18884.91,0,18485.739999999998,0,18874.379999999997,0,18213.599999999999,0,19199.190000000002,0,19243.830000000002,0]
["pdweekdaylastyear",{"$f":"[0]!pdweekdaylastyear","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,75376.91,0,0,0,0,0,73383.58,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]
["asdweekdaylastyear",{"$f":"[0]!asdweekdaylastyear","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,59779.4,0,0,0,76094.84,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]
["pdweekendlastyear",{"$f":"[0]!pdweekendlastyear","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,101427.99,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]
["MLD&SLCN",{"$f":"mldfinal","v":0},12371.154861324856,0,15177.239540677649,0,14536.1,0,13117.928571953005,0,15171.59,1,14106.03,0,16589.669999999998,0,16499.298843025721,0,14529.83,0,12971.033782136634,0,16536.41,0,12720.262180423106,0,12333.063304256919,0,12371.275865631,0,11771.35,0,12959.792043147805,1,11254.39,0,12554.92257817238,0,12290.980980238744,0,12019.982359141657,0,12466.70931675869,0,11745.21610835809,0,12851.453308560915,0,12890.696882526703,0]
["BESD",{"$f":"besdfinal","v":0},18607.490359419833,0,21413.575038772622,0,20793.477822242403,0,19354.264070047979,0,21387.102752452269,1,20001.576819235328,0,22510.531496567499,0,22785.057052985045,0,18895.800879251365,1,19207.369280231611,0,21687.450676508503,0,18956.597678518079,0,18569.398802351894,0,18607.611363725977,0,17890.427703292145,0,19196.127541242779,1,17450.880458256692,0,18791.258076267353,0,18576.73919019807,0,18256.317857236631,0,18703.044814853663,0,17981.551606453068,0,19087.788806655888,0,19127.032380621677,0]
["SLD",{"$f":"sldfinal","v":0},16514.385337902364,0,19320.470017255153,0,18723.414768900682,0,17261.15904853051,0,19293.997730934796,1,17908.471797717863,0,20417.42647505003,0,20723.039490076226,0,18083.41,0,17114.264258714142,0,20404.25,0,16863.49265700061,0,16476.293780834421,0,16514.506342208508,0,15797.322681774673,0,17103.022519725309,1,15357.775436739223,0,16698.153054749884,0,16514.721627289251,0,16163.212835719161,0,16609.939793336194,0,15888.446584935598,0,16994.683785138419,0,17033.927359104207,0]
["PD&PMLD",{"$f":"pdfinal","v":0},23419.053139780888,0,26225.137819133677,0,25762.167990768856,0,24165.826850409037,0,26198.66553281332,1,24813.139599596387,0,27322.094276928554,0,27761.792711944399,0,24009.61,0,24018.932060592666,0,26850.62,0,23768.160458879138,0,23380.961582712946,0,23419.174144087032,0,22701.9904836532,0,24007.690321603837,1,22262.44323861775,0,23602.820856628408,0,23553.474849157425,0,23067.880637597689,0,23514.607595214722,0,22793.114386814123,0,23899.351587016947,0,23938.595160982735,0]
["ASD",{"$f":"asdfinal","v":0},18607.490359419833,0,21413.575038772622,0,20863.346554949196,0,19354.264070047979,0,21387.102752452269,1,20001.576819235328,0,22510.531496567499,0,22862.971276124739,0,20545.71,0,19967.78531312741,0,29561.88,0,19717.013711413878,0,19329.814835247686,0,19368.027396621772,0,18650.843736187941,0,19956.543574138581,1,18211.29649115249,0,19551.674109163148,0,19429.215135319006,0,19016.733890132426,0,19463.460847749458,0,18741.967639348863,0,19848.20483955169,0,19887.448413517475,0]
["WeekdayPD&PMLD",{"$f":"pd5final","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,77419.653583918116,0,0,0,0,0,74427.955435047581,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]
["WeekdayASD",{"$f":"asd5final","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,59779.4,0,0,0,77220.552983644462,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]
["WeekendPD&PMLD",{"$f":"pd7final","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,104252.27441438139,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]
["integrity",{"$f":"[0]!integrity","v":"ERROR"},"OK",{"$f":"IF(C52=\"OK\",0,1)","v":0},"OK",{"$f":"IF(E52=\"OK\",0,1)","v":0},"OK",{"$f":"IF(G52=\"OK\",0,1)","v":0},"OK",{"$f":"IF(I52=\"OK\",0,1)","v":0},"OK",{"$f":"IF(K52=\"OK\",0,1)","v":0},"OK",{"$f":"IF(M52=\"OK\",0,1)","v":0},"OK",{"$f":"IF(O52=\"OK\",0,1)","v":0},"OK",{"$f":"IF(Q52=\"OK\",0,1)","v":0},"OK",{"$f":"IF(S52=\"OK\",0,1)","v":0},"OK",{"$f":"IF(U52=\"OK\",0,1)","v":0},"OK",{"$f":"IF(W52=\"OK\",0,1)","v":0},"OK",{"$f":"IF(Y52=\"OK\",0,1)","v":0},"OK",{"$f":"IF(AA52=\"OK\",0,1)","v":0},"OK",{"$f":"IF(AC52=\"OK\",0,1)","v":0},"OK",{"$f":"IF(AE52=\"OK\",0,1)","v":0},"OK",{"$f":"IF(AG52=\"OK\",0,1)","v":0},"OK",{"$f":"IF(AI52=\"OK\",0,1)","v":0},"OK",{"$f":"IF(AK52=\"OK\",0,1)","v":0},"OK",{"$f":"IF(AM52=\"OK\",0,1)","v":0},"OK",{"$f":"IF(AO52=\"OK\",0,1)","v":0},"OK",{"$f":"IF(AQ52=\"OK\",0,1)","v":0},"OK",{"$f":"IF(AS52=\"OK\",0,1)","v":0},"OK",{"$f":"IF(AU52=\"OK\",0,1)","v":0},"OK",{"$f":"IF(AW52=\"OK\",0,1)","v":0}]
["nurseryfte",{"$f":"nurseryfte","v":0},0,{"$error":"#VALUE!"},0,{"$error":"#VALUE!"},0,{"$error":"#VALUE!"},0,{"$error":"#VALUE!"},0,{"$error":"#VALUE!"},0,{"$error":"#VALUE!"},0,{"$error":"#VALUE!"},0,{"$error":"#VALUE!"},0,{"$error":"#VALUE!"},0,{"$error":"#VALUE!"},0,{"$error":"#VALUE!"},0,{"$error":"#VALUE!"},6,{"$error":"#VALUE!"},10,{"$error":"#VALUE!"},10,{"$error":"#VALUE!"},8,{"$error":"#VALUE!"},15,{"$error":"#VALUE!"},6,{"$error":"#VALUE!"},12,{"$error":"#VALUE!"},5,{"$error":"#VALUE!"},12,{"$error":"#VALUE!"},6,{"$error":"#VALUE!"},0,{"$error":"#VALUE!"},0,{"$error":"#VALUE!"}]
["nurserycash",{"$f":"nurserycash","v":0},0,{"$error":"#VALUE!"},0,{"$error":"#VALUE!"},0,{"$error":"#VALUE!"},0,{"$error":"#VALUE!"},0,{"$error":"#VALUE!"},0,{"$error":"#VALUE!"},0,{"$error":"#VALUE!"},0,{"$error":"#VALUE!"},0,{"$error":"#VALUE!"},0,{"$error":"#VALUE!"},0,{"$error":"#VALUE!"},0,{"$error":"#VALUE!"},109359,{"$error":"#VALUE!"},200119,{"$error":"#VALUE!"},200119,{"$error":"#VALUE!"},127959,{"$error":"#VALUE!"},246618,{"$error":"#VALUE!"},109359,{"$error":"#VALUE!"},218718,{"$error":"#VALUE!"},100059,{"$error":"#VALUE!"},218718,{"$error":"#VALUE!"},109359,{"$error":"#VALUE!"},0,{"$error":"#VALUE!"},0,{"$error":"#VALUE!"}]