{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Special Rates 2023-24","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 2023-24","index":0,"n_rows":146,"n_cols":19,"rows_kept":146,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[null,null,null,null,"2023/24 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,"2022/23",{"$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 2022-23 agreed November 2021"]
[]
[null,"2023/24",{"$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 2023-24 agreed November 2022"]
[]
[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 2023 to March 2024"]
[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 2023 to August 2023 (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 2022 to 2023. Data taken from 2022-23 Funding Rates Calculation."]
[]
["(B)","September 2023 to March 2024 (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 2023 to 2024. See section 3 for calculation."]
[]
["(C)","April 2023 to March 2024",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 2022 to 2023 (April 2023 to August 2023) 5/12's + ",null,null,null,null,null,null,"+"]
[null,"Academic Year 2023 to 2024 (September 2023 to March 2024) 7/12's",null,null,null,null,null,null,"(B) X 7/12"]
[]
["(D)","Final funding rate for financial Year 2021 to 2022",null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(DFENUM,DATA!$B:$CL,85,0),0)","v":0},{"$f":"IFERROR(VLOOKUP(DFENUM,DATA!$B:$CL,87,0),0)","v":0},{"$f":"IFERROR(VLOOKUP(DFENUM,DATA!$B:$CL,88,0),0)","v":0},{"$f":"IFERROR(VLOOKUP(DFENUM,DATA!$B:$CL,89,0),0)","v":0},{"$f":"IFERROR(VLOOKUP(DFENUM,DATA!$B:$CL,86,0),0)","v":0},null,{"$f":"IFERROR(VLOOKUP(DFENUM,DATA!$B:$CO,91,0),0)","v":0},{"$f":"IFERROR(VLOOKUP(DFENUM,DATA!$B:$CO,90,0),0)","v":0},null,{"$f":"IFERROR(VLOOKUP(DFENUM,DATA!$B:$CO,92,0),0)","v":0}]
["(E)","MFG rate (D) X 103%",null,null,null,null,null,null,null,{"$f":"mldlastyear*1.03","v":0},{"$f":"besdlastyear*1.03","v":0},{"$f":"sldlastyear*1.03","v":0},{"$f":"pdlastyear*1.03","v":0},{"$f":"asdlastyear*1.03","v":0},null,{"$f":"pdweekdaylastyear*1.03","v":0},{"$f":"asdweekdaylastyear*1.03","v":0},null,{"$f":"pdweekendlastyear*1.03","v":0}]
["(F)","Final funding rate for financial Year 2022 to 2023",null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(DFENUM,DATA!$B:$BD,13,0),0)","v":0},{"$f":"IFERROR(VLOOKUP(DFENUM,DATA!$B:$BD,19,0),0)","v":0},{"$f":"IFERROR(VLOOKUP(DFENUM,DATA!$B:$BD,22,0),0)","v":0},{"$f":"IFERROR(VLOOKUP(DFENUM,DATA!$B:$BD,25,0),0)","v":0},{"$f":"IFERROR(VLOOKUP(DFENUM,DATA!$B:$BD,16,0),0)","v":0},null,{"$f":"IFERROR(VLOOKUP(DFENUM,DATA!$B:$BD,51,0),0)","v":0},{"$f":"IFERROR(VLOOKUP(DFENUM,DATA!$B:$BD,48,0),0)","v":0},null,{"$f":"IFERROR(VLOOKUP(DFENUM,DATA!$B:$BD,54,0),0)","v":0}]
["(G)","MFG rate (F) X 100%",null,null,null,null,null,null,null,{"$f":"J39","v":0},{"$f":"K39","v":0},0,0,0,null,{"$f":"P39","v":0},{"$f":"Q39","v":0},null,{"$f":"S39","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"]
["(H)","Final Rate (Greater of Formula (C) , MFG (E) or MFG (G))",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,"MFG funding rate (G)",null,null,{"$f":"J40","v":0},{"$f":"K40","v":0},0,0,0,null,{"$f":"P40","v":0},{"$f":"Q40","v":0},null,{"$f":"S40","v":0}]
[null,null,null,null,null,null,"Amount of MFG if (E) or (G) is greater than (C)",null,null,{"$f":"IF(AND(J47>J46,J47>J45),J47-J45,IF(AND(J46>J47,J46>J45),J46-J45,0))","v":0},{"$f":"IF(AND(K47>K46,K47>K45),K47-K45,IF(AND(K46>K47,K46>K45),K46-K45,0))","v":0},0,0,0,null,0,0,null,0]
[null,null,null,null,null,null,"Final Rate formula plus MFG",null,null,{"$f":"SUM(J45,J48)","v":0},{"$f":"SUM(K45,K48)","v":0},{"$f":"SUM(L45,L48)","v":0},{"$f":"SUM(M45,M48)","v":0},{"$f":"SUM(N45,N48)","v":0},null,{"$f":"SUM(P45,P48)","v":0},{"$f":"SUM(Q45,Q48)","v":0},null,{"$f":"SUM(S45,S48)","v":0}]
["(I)","Place Plus Breakdown"]
[null,null,null,null,null,null,"Element 1 & 2",null,null,10000,10000,10000,10000,10000,null,{"$f":"IF($P$49=0,0,10000)","v":0},{"$f":"IF($Q$49=0,0,10000)","v":0},null,{"$f":"IF($S$49=0,0,10000)","v":0}]
[null,null,null,null,null,null,"Element 3",null,null,{"$f":"J49-J51","v":-10000},{"$f":"K49-K51","v":-10000},-10000,-10000,-10000,null,{"$f":"P49-P51","v":0},0,null,{"$f":"S49-S51","v":0}]
[null,null,null,null,null,null,"Total rate",null,null,{"$f":"SUM(J51:J52)","v":0},{"$f":"SUM(K51:K52)","v":0},{"$f":"SUM(L51:L52)","v":0},{"$f":"SUM(M51:M52)","v":0},{"$f":"SUM(N51:N52)","v":0},null,{"$f":"SUM(P51:P52)","v":0},{"$f":"SUM(Q51:Q52)","v":0},null,{"$f":"SUM(S51:S52)","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,9977.4777634176062,16521.638781698548,14325.218096318977,21570.700300898221,16521.638781698548,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,M56)","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)-N56","v":-16521.638781698548},null,0,{"$f":"IF($Q$30=0,0,N57)","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,119.15188979199999,{"$f":"$J60","v":119.15188979199999},{"$f":"$J60","v":119.15188979199999},119.15188979199999,119.15188979199999,null,{"$f":"IF($P$30=0,0,M60)","v":0},{"$f":"IF($Q$30=0,0,N60)","v":0},null,{"$f":"IF($S$33=0,0,P60)","v":0}]
[null,"Lunch Grant",null,null,null,null,null,null,null,12.364818752000003,{"$f":"$J61","v":12.364818752000003},12.364818752000003,12.364818752000003,12.364818752000003,null,{"$f":"IF($P$30=0,0,M61)","v":0},{"$f":"IF($Q$30=0,0,N61)","v":0},null,{"$f":"IF($S$33=0,0,P61)","v":0}]
[null,"Specialist Schools Funding",null,null,null,null,null,null,null,102.60653675138123,102.60653675138123,102.60653675138123,102.60653675138123,102.60653675138123,null,{"$f":"IF($P$30=0,0,M62)","v":0},{"$f":"IF($Q$30=0,0,N62)","v":0},null,0]
[null,"Further Delegation",null,null,null,null,null,null,null,48.959189265851265,48.959189265851265,48.959189265851265,48.959189265851265,48.959189265851265,null,{"$f":"IF($P$30=0,0,M63)","v":0},{"$f":"IF($Q$30=0,0,N63)","v":0},null,0]
[null,"Residential Weekday Places Catering",null,null,null,null,null,null,null,0,0,0,0,0,null,0,0,null,0]
[null,"Residential Weekend Places Catering",null,null,null,null,null,null,null,0,0,0,0,0,null,0,0,null,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(J56:J69)","v":10260.560197978839},{"$f":"SUM(K56:K69)","v":16804.721216259779},{"$f":"SUM(L56:L69)","v":14608.300530880209},{"$f":"SUM(M56:M69)","v":21853.782735459452},{"$f":"SUM(N56:N69)","v":283.08243456123245},null,{"$f":"SUM(P56:P69)","v":0},{"$f":"SUM(Q56:Q69)","v":0},null,{"$f":"SUM(S56:S69)","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},389301.82210899197,{"$f":"F75*G75","v":0},{"$f":"$C$17+$D$17","v":0},{"$f":"IF(I75=0,0,H75/I75)","v":0},{"$f":"$J75","v":0},{"$f":"$J75","v":0},0,0,null,{"$f":"IF($P$30=0,0,M75)","v":0},{"$f":"IF($Q$30=0,0,N75)","v":0},null,{"$f":"IF($S$33=0,0,M75)","v":0}]
[null,"Lump Sum Catering Day",null,null,null,{"$f":"IF(DFENUM>0,1,0)","v":0},2248.1488639999998,{"$f":"F76*G76","v":0},{"$f":"$C$17+$D$17","v":0},{"$f":"IF(I76=0,0,H76/I76)","v":0},{"$f":"$J76","v":0},0,0,0,null,0,0,null,{"$f":"IF($S$33=0,0,M76)","v":0}]
[null,"Specialist Schools Funding- Lump Sum",null,null,null,{"$f":"IF(DFENUM>0,1,0)","v":0},13283.983782333333,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)*I78","v":0},466.49088928000003,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},33.722230463124681,{"$f":"F79*G79","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},1182.5263024639996,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$28,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},5620.3721599999981,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},4921.1978632959999,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},43194.808198464001,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},56.203207323626678,0,{"$f":"E17","v":0},0,0,0,0,0,null,{"$f":"IF($P$30=0,0,((F85*G85)/I85))","v":0},{"$f":"IF($Q$30=0,0,((F85*G85)/I85))","v":0},null,{"$f":"IF($S$33=0,0,((F85*G85)/I85))","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},73.064734849727714,0,{"$f":"E17","v":0},0,0,0,0,0,null,{"$f":"IF($P$30=0,0,((F86*G86)/I86))","v":0},{"$f":"IF($Q$30=0,0,((F86*G86)/I86))","v":0},null,{"$f":"IF($S$33=0,0,((F86*G86)/I86))","v":0}]
[null,"Lump Sum Residential",null,null,null,{"$f":"IF(SUM(P33:S33)>0,1,0)","v":0},183701.8640496,0,{"$f":"E17","v":0},0,0,0,0,0,null,{"$f":"IF($P$30=0,0,((F87*G87)/I87))","v":0},{"$f":"IF($Q$30=0,0,((F87*G87)/I87))","v":0},null,{"$f":"IF($S$33=0,0,((F87*G87)/I87))","v":0}]
[null,"London Fringe Day Pupils",null,null,null,{"$f":"IFERROR(VLOOKUP(DFENUM,DATA!$B$5:$BE$28,44,0),0)","v":0},4332.4638795359997,0,{"$f":"$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,2713.7966974559999,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(J75:J90)","v":0},{"$f":"SUM(K75:K90)","v":0},{"$f":"SUM(L75:L90)","v":0},{"$f":"SUM(M75:M90)","v":0},{"$f":"SUM(N75:N90)","v":0},null,{"$f":"SUM(P75:P90)","v":0},{"$f":"SUM(Q75:Q90)","v":0},null,{"$f":"SUM(S75:S90)","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":"J70+J91","v":10260.560197978839},{"$f":"K70+K91","v":16804.721216259779},{"$f":"L70+L91","v":14608.300530880209},{"$f":"M70+M91","v":21853.782735459452},{"$f":"N70+N91","v":283.08243456123245},null,{"$f":"P70+P91","v":0},{"$f":"Q70+Q91","v":0},null,{"$f":"S70+S91","v":0}]
[null,null,null,null,null,null,null,null,null,{"$f":"ROUND(J97-mldnew,1)","v":10260.6},{"$f":"ROUND(K97-besdnew,1)","v":16804.7},{"$f":"ROUND(L97-sldnew,1)","v":14608.3},{"$f":"ROUND(M97-pdnew,1)","v":21853.8},{"$f":"ROUND(N97-asdnew,1)","v":283.10000000000002},null,{"$f":"ROUND(P97-pdweekdaynew,1)","v":0},{"$f":"ROUND(Q97-asdweekdaynew,1)","v":0},null,{"$f":"ROUND(S97-pdweekendnew,1)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(J98=0,K98=0,L98=0,M98=0,N98=0),\"OK\",\"ERROR\")","v":"ERROR"},null,null,null,null,{"$f":"IF(AND(P98=0,Q98=0,S98=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(N99=\"OK\",S99=\"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,"2022/23 Financial Year",null,"2023/24 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(G118-E118,\"\")","v":""},{"$f":"IFERROR(H118/E118,\"\")","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(G119-E119,\"\")","v":""},{"$f":"IFERROR(H119/E119,\"\")","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(G120-E120,\"\")","v":""},{"$f":"IFERROR(H120/E120,\"\")","v":""}]
[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(G121-E121,\"\")","v":""},{"$f":"IFERROR(H121/E121,\"\")","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(G122-E122,\"\")","v":""},{"$f":"IFERROR(H122/E122,\"\")","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(G124-E124,\"\")","v":""},{"$f":"IFERROR(H124/E124,\"\")","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(G126-E126,\"\")","v":""},{"$f":"IFERROR(H126/E126,\"\")","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(G127-E127,\"\")","v":""},{"$f":"IFERROR(H127/E127,\"\")","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(G128-E128,\"\")","v":""},{"$f":"IFERROR(H128/E128,\"\")","v":""}]
[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(G129-E129,\"\")","v":""},{"$f":"IFERROR(H129/E129,\"\")","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(G130-E130,\"\")","v":""},{"$f":"IFERROR(H130/E130,\"\")","v":""}]
[]
[]
[null,"Section 6 - 2023/24 Nursery Provision Lump Sum Calculation"]
[]
[null,"Rates"]
[]
[null,"Leadership Lump Sum per provision",null,null,58097.603199999998]
[null,"Day Rate per FTE (see breakdown)",null,null,10087.754986400001]
[]
[null,"Calculation"]
[]
[null,null,null,"Units","Rate","Total"]
[null,"Leadership Lump Sum",null,{"$f":"IF(D144>9,2,IF(D144>0,1,0))","v":0},{"$f":"E137","v":58097.603199999998},{"$f":"D143*E143","v":0}]
[null,"Day Rate",null,{"$f":"IFERROR(VLOOKUP('Special Rates 2023-24'!DFENUM,DATA!B:BK,62,0),0)","v":0},{"$f":"E138","v":10087.754986400001},{"$f":"D144*E144","v":0}]
[]
[null,null,null,null,"Total Funding at this provision:",{"$f":"IFERROR(ROUND(F144+F143,0),\"TBC\")","v":0}]

{"sheet":"DATA","index":1,"n_rows":28,"n_cols":93,"rows_kept":28,"cut":false,"hidden":true,"merged":[[1,85,1,92],[2,85,2,92],[1,63,1,73],[2,63,2,67],[2,69,2,73],[1,74,1,84],[2,74,2,78],[2,80,2,84],[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,3,1,10],[2,3,2,4],[2,5,2,6],[2,7,2,8],[2,9,2,10],[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]]}
[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,85,86,87,88,89,90,91,92]
[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,"2022/23 Financial Year",null,null,null,null,null,null,null,null,null,null,"2023/24 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,null,null,null,"Total rate"]
[null,"DFE","School","22/23","23/24","22/23","23/24","22/23","23/24","22/23","23/24","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","MLD & SLCN","ASD","SEMH","SLD","PD & PMLD","ASD Weekday","PD Weekday","PD Weekend"]
[null,7002,"Broomhill Bank School",218,269,100,107,23,23,0,0,13082.956804321117,12678.086340235641,14529.83,20470.332078203093,20065.461614117619,20545.71,19642.929474102657,19238.059010017183,19460.599999999999,17456.454500785763,17051.584036700286,18083.41,24744.834228633401,24339.963764547927,24516.989999999998,null,17319.588949978079,16521.638781698548,45.427074564687857,61.238726065289754,71.184438127963801,114.0819613963608,90.691161886194664,0,0,0,11140.8930014898,632.10699851023674,0,10.685,0,0,0.29199999999999998,1,0,1,60199.580721003607,59779.4,59794.71025691813,0,0,0,0,0,0,27770.888472523024,0,988.64468127036548,0,11.522510317914893,0,{"$error":"#VALUE!"},10214.060726009444,16715.520259985205,14548.548036678072,21771.917439896748,17535.54266246334,2745.0753608560649,1570.6939131344916,0,789.78660246586151,0,265.09197668059642,10305.987272543527,16865.959942325069,14679.484969008176,21967.864696855817,17693.362546425509,2540.7950943943956,2118.9425330620779,53.844963280535012,1405.6322365974302,221.23850874978962,927.92365918009455,14529.83,20545.71,18684.346139590896,18083.41,24009.61,59779.4]
[null,7005,"Aspire School",136,172,0,0,0,0,0,0,13518.112101137627,13425.013716913696,13384.19,20860.2232876981,20767.124903474167,20660.809999999998,20062.273119418569,19969.174735194636,19869.98,17865.852434038999,17772.754049815067,17693.150000000001,25111.334638618242,25018.236254394309,24874.010000000002,null,17319.588949978079,16521.638781698548,0,0,0,0,0,0,0,0,3227,0,0,1.7432000000000001,0,0,0.35606060606060608,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$error":"#VALUE!"},10169.038848343745,16654.827766362519,14477.998543984351,21658.853057938017,17445.660440574149,3215.1525893272828,0,0,0,0,0,10260.560197978841,16804.721216259779,14608.300530880209,21853.782735459452,17602.67138453931,3203.2445123614962,0,0,0,0,0,12851.453308560915,19848.20483955169,19087.788806655888,16994.683785138419,23899.35158701695]
[null,7006,"Snowfields Academy",120,226,0,12,0,0,0,0,14649.275605845922,13412.141001905371,13399.45,21991.386792406389,20754.252188465838,20676.07,21193.436624126858,19956.302020186307,19885.239999999998,18997.015938747292,17759.881334806742,17708.41,26242.498143326535,25005.36353938598,24889.260000000002,null,17319.588949978079,16521.638781698548,0,0,0,0,0,0,0,0,7642,0,0,7.3,0,0,0.32163742690058478,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$error":"#VALUE!"},10169.038848343745,16654.827766362519,14477.998543984351,21658.853057938017,17445.660440574149,3230.4090509178759,0,0,0,0,0,10260.560197978841,16804.721216259779,14608.300530880209,21853.782735459452,17602.67138453931,3667.0535555684278,0,0,0,0,0,12890.696882526703,19887.448413517479,19127.032380621677,17033.927359104207,23938.595160982739]
[null,7021,"Valence School",80,80,30,30,46,46,18,18,17255.006502709006,17222.270299952514,17051.54,23932.78980710579,23900.053604349298,23669.760000000002,23851.029737911918,23818.293535155426,23588.73,21687.230988097923,21654.494785341427,21444.23,29073.417068997504,29040.680866241011,28764.54,null,16521.638781698548,16521.638781698548,173.7225820582799,225.58479898025485,258.2067345458251,398.91061086616583,307.34486817412522,0,0,0,8799,0,1924,18.321999999999999,0,1,0.26315789473684209,1,0,0,0,0,0,81182.389953611841,80408.710000000006,81149.653750855345,109339.46894826677,108314.64,109306.73274551028,42651.041324346566,26849.248533291109,1278.5702066470587,1810.7893099308924,39.38603526850909,39.38603526850909,{"$error":"#VALUE!"},10341.211873178512,16878.400411536211,14733.902146111039,22054.205496853938,16959.431203601493,6710.3316857098871,0,0,0,0,0,10434.28278003712,17030.306015240032,14866.507265426037,22252.693346325617,17112.066084433904,6801.6276043972666,0,0,0,0,0,16499.298843025721,22862.971276124743,22785.057052985048,20723.039490076226,27761.792711944399,null,77419.653583918116,104252.27441438139]
[null,7032,"Bower Grove School",225,225,0,0,0,0,0,0,12976.221006125608,12997.373815150899,12847.95,19520.38202440655,19541.534833431841,19333.73,19520.38202440655,19541.534833431841,19333.73,17323.961339026981,17345.114148052271,17156.900000000001,24569.443543606223,24590.596352631514,24337.760000000002,null,16521.638781698548,16521.638781698548,0,0,0,0,0,0,0,0,4185.3,0,0,2.1496,0,0,0.59401709401709402,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$error":"#VALUE!"},10169.038848343745,16654.827766362519,14477.998543984351,21658.853057938017,16654.827766362519,2678.9062518171695,0,0,0,0,0,10260.560197978841,16804.721216259779,14608.300530880209,21853.782735459452,16804.721216259779,2727.9999467448561,0,0,0,0,0,12371.154861324856,18607.490359419833,18607.490359419833,16514.385337902364,23419.053139780888]
[null,7033,"St Anthony's School",110,106,0,0,0,0,0,0,15391.896421882589,15586.724506842907,15483.34,21936.057440163528,22130.885525123849,21969.129999999997,21936.057440163528,22130.885525123849,21969.129999999997,19739.636754783958,19934.464839744276,19792.3,26985.118959363201,27179.947044323522,26973.15,null,16521.638781698548,16521.638781698548,0,0,0,0,0,0,0,0,3614,0,0,1.54,0,0,0.7289719626168224,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$error":"#VALUE!"},10169.038848343745,16654.827766362519,14477.998543984351,21658.853057938017,16654.827766362519,5314.299239287222,0,0,0,0,0,10260.560197978841,16804.721216259779,14608.300530880209,21853.782735459452,16804.721216259779,5244.985940130603,127.01058878853655,6.2751335454195214,46.797646761999204,0,6.2751335454195214,15177.239540677649,21413.575038772622,21413.575038772622,19320.470017255157,26225.137819133681]
[null,7039,"The Ifield School",220,227,41,39,0,0,0,0,12904.604159150313,12857.552392233018,12837.48,20246.715345710785,20199.663578793487,20114.099999999999,19448.765177431254,19401.713410513956,19323.260000000002,17252.344492051685,17205.292725134386,17146.439999999999,24497.826696630924,24450.774929713629,24327.29,null,17319.588949978079,16521.638781698548,0,0,0,0,0,0,0,0,4274.1399960000008,0,0,6.22,75000,1,0.39436619718309857,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$error":"#VALUE!"},10169.038848343745,16654.827766362519,14477.998543984351,21658.853057938017,17445.660440574149,2668.4364691150918,0,0,0,0,0,10260.560197978841,16804.721216259779,14608.300530880209,21853.782735459452,17602.67138453931,2616.5970971363854,0,0,0,0,0,12333.063304256921,19329.814835247689,18569.398802351894,16476.293780834425,23380.961582712949]
[null,7040,"Foreland Fields School",209,213,33,30,0,0,0,0,13124.539076540057,13111.348353514699,12900.34,20466.650263100528,20453.459540075168,20176.97,19668.700094820997,19655.509371795637,19386.129999999997,17472.279409441428,17459.088686416068,17209.3,24717.761614020666,24704.57089099531,24390.16,null,17319.588949978079,16521.638781698548,0,0,0,0,0,0,0,0,4490.5,0,0,4.4852999999999996,63000,1,0.46500000000000002,0,2,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$error":"#VALUE!"},10169.038848343745,16654.827766362519,14477.998543984351,21658.853057938017,17445.660440574149,2731.3052024518674,0,0,0,0,0,10260.560197978841,16804.721216259779,14608.300530880209,21853.782735459452,17602.67138453931,2856.284290129759,0,0,0,0,0,12371.275865631,19368.027396621772,18607.611363725977,16514.506342208508,23419.174144087032]
[null,7041,"Goldwyn School",150,160,45,35,0,0,0,0,14116.969340625137,14133.600693463375,14106.029999999999,20661.130358906077,20677.761711744315,20522.379999999997,20661.130358906077,20677.761711744315,20522.379999999997,18464.709673526508,18481.341026364746,18345.55,25710.191878105747,25726.823230943992,25526.400000000001,null,16521.638781698548,16521.638781698548,0,0,0,0,0,0,0,0,5856.3800899999997,0,0,7.3492000000000006,47900,0,0.4759036144578313,0,2,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$error":"#VALUE!"},10169.038848343745,16654.827766362519,14477.998543984351,21658.853057938017,16654.827766362519,3867.5510927895775,69.440058866677646,0,0,0,0,10260.560197978841,16804.721216259779,14608.300530880209,21853.782735459452,16804.721216259779,3866.1107651352704,402.53993688589253,0,0,0,0,14106.03,20001.576819235335,20001.576819235335,17908.471797717866,24813.13959959639]
[null,7043,"The Beacon Folkestone",329,278,73,130,0,0,0,0,12371.704289803118,12345.359006735052,12252.69,19713.81547636359,19687.470193295521,19529.309999999998,18915.86530808406,18889.520025015991,18738.47,16719.44462270449,16693.099339636421,16561.64,23964.926827283733,23938.581544215664,23742.5,null,17319.588949978079,16521.638781698548,0,0,0,0,0,0,0,0,8748,0,0,2.4561000000000002,0,1,0.52037617554858939,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$error":"#VALUE!"},10169.038848343745,16654.827766362519,14477.998543984351,21658.853057938017,17445.660440574149,2083.6462966621712,0,0,0,0,0,10260.560197978841,16804.721216259779,14608.300530880209,21853.782735459452,17602.67138453931,2095.7760100345736,0,0,0,0,0,11771.35,18650.843736187941,17890.427703292145,15797.322681774676,22701.9904836532]
[null,7044,"Rowhill School",132,132,0,0,0,0,0,0,14884.939863230713,14888.716218048692,14744.01,21562.723167627497,21566.499522445476,21362.23,21489.405714274297,21493.182069092276,21289.57,19317.164348619626,19320.940703437605,19136.7,26703.350429519211,26707.12678433719,26457.01,null,16521.638781698548,16521.638781698548,173.72258205828047,234.02741482092557,258.20673454582561,398.91061086616628,307.34486817412591,0,0,0,4165,0,0,1.8948,0,0,0.58666666666666667,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$error":"#VALUE!"},10341.211873178512,16886.767721586431,14733.902146111039,22054.205496853945,16959.431203601496,4402.8022744849804,0,0,0,0,0,10434.28278003712,17038.748631080707,14866.507265426037,22252.693346325617,17112.066084433904,4452.8599568374148,85.040263125465572,0,0,0,0,14536.1,20863.346554949196,20793.477822242407,18723.414768900682,25762.167990768859]
[null,7045,"Elms School",158,152,0,0,0,0,0,0,13800.962144589717,13931.580193354785,13666.89,20345.123162870659,20475.741211635723,20152.68,20345.123162870659,20475.741211635723,20152.68,18148.702477491086,18279.320526256153,17975.849999999999,25394.184682070332,25524.802730835399,25156.71,null,16521.638781698548,16521.638781698548,0,0,0,0,0,0,0,0,2771,0,0,2.13,0,0,0.80666666666666653,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$error":"#VALUE!"},10169.038848343745,16654.827766362519,14477.998543984351,21658.853057938017,16654.827766362519,3497.8536198860047,0,0,0,0,0,10260.560197978841,16804.721216259779,14608.300530880209,21853.782735459452,16804.721216259779,3616.5958083905016,0,0,0,0,0,13117.928571953005,19354.264070047982,19354.264070047982,17261.159048530513,24165.826850409037]
[null,7051,"Nexus School",246,256,30,39,0,0,0,0,12952.89098687646,12797.829015153693,12911.72,20295.002173436929,20139.940201714166,20188.34,19497.052005157399,19341.990033434635,19397.510000000002,17300.631319777829,17145.569348055062,17220.68,24546.113524357072,24391.051552634308,24401.54,null,17319.588949978079,16521.638781698548,0,0,0,0,0,0,0,0,7075.8,0,0,2.36,0,1,0.38834951456310679,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$error":"#VALUE!"},10169.038848343745,16654.827766362519,14477.998543984351,21658.853057938017,17445.660440574149,2742.6821180562338,0,0,0,0,0,10260.560197978841,16804.721216259779,14608.300530880209,21853.782735459452,17602.67138453931,2601.8779720593402,293.83422996181798,37.298419833165099,77.820933049744781,0,22.576765436304413,12773.08,19637.986526247532,18877.570493351737,16784.465471834268,23689.133273712792]
[null,7052,"Grange Park School",91,95,53,60,0,0,0,0,13693.736258187,13491.823294771324,13560.94,21035.847444747469,20833.934481331795,20837.57,20237.897276467938,20035.984313052264,20046.73,18041.476591088373,17839.563627672695,17869.900000000001,25286.958795667611,25085.045832251937,25050.760000000002,null,17319.588949978079,16521.638781698548,0,0,0,0,0,0,0,0,1958.53,0,0,1.1245000000000001,0,0,0.39603960396039606,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$error":"#VALUE!"},10169.038848343745,16654.827766362519,14477.998543984351,21658.853057938017,17445.660440574149,3391.905099418349,0,0,0,0,0,10260.560197978841,16804.721216259779,14608.300530880209,21853.782735459452,17602.67138453931,3315.3934982156838,0,0,0,0,0,12971.033782136636,19967.78531312741,19207.369280231611,17114.264258714142,24018.93206059267]
[null,7056,"Five Acre Wood School",542,648,59,77,0,0,0,0,11758.119018481306,11564.605428794841,11603.02,19100.230205041778,18906.716615355308,18879.64,18302.280036762248,18108.766447075777,18088.810000000001,16105.859351382676,15912.345761696211,15911.98,23351.341555961921,23157.82796627545,23092.83,null,17319.588949978079,16521.638781698548,0,0,0,0,0,0,0,0,10386.17,0,0,2.6381999999999999,9259,1,0.36734693877551022,0,1,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$error":"#VALUE!"},10169.038848343745,16654.827766362519,14477.998543984351,21658.853057938017,17445.660440574149,1433.9805004993459,0,0,0,0,0,10260.560197978841,16804.721216259779,14608.300530880209,21853.782735459452,17602.67138453931,1384.6758931853617,0,0,0,0,0,11254.39,18211.29649115249,17450.880458256692,15357.775436739223,22262.44323861775]
[null,7058,"Stone Bay School",90,92,10,11,10,10,0,0,15436.172875735972,15301.464214751606,16536.41,29959.83557681222,29825.126915827848,29901.29,21980.333894016912,21845.625233032544,21992.97,19783.913208637343,19649.204547652975,20404.25,27029.395413216589,26894.686752232217,26996.99,null,24501.140464493852,16521.638781698548,0,0,0,0,0,0,0,0,2396.216342490492,1481.783657509508,0,0.96,0,1,0.55813953488372092,0,0,0,92120.454938205046,86607.43,91985.746277220678,89190.014774609415,83703.13,89055.306113625047,0,0,0,33933.592317735958,0,0,0,0,0,{"$error":"#VALUE!"},10169.038848343745,16654.827766362519,14477.998543984351,21658.853057938017,24563.154508478779,5338.1391105967596,1029.2320410594948,0,588.11234541888552,0,0,10260.560197978841,16804.721216259779,14608.300530880209,21853.782735459452,24784.222899055087,5097.0326255162527,1674.9094765049067,436.32035502772487,1311.0443436035421,705.32323902429198,567.48087542866415,16536.41,29561.88,21687.450676508503,20404.25,26850.62,77220.552983644462,74427.955435047596]
[null,7062,"The Orchard School",93,100,0,0,0,0,0,0,15845.774056536913,15496.607025667963,15894.82,22389.935074817855,22040.768043948905,22380.61,22389.935074817855,22040.768043948905,22380.61,20193.514389438285,19844.347358569335,20203.78,27438.996594017528,27089.829563148574,27384.63,null,16521.638781698548,16521.638781698548,0,0,0,0,0,0,0,0,2505,0,0,1.81,0,0,0.68932038834951459,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$error":"#VALUE!"},10169.038848343745,16654.827766362519,14477.998543984351,21658.853057938017,16654.827766362519,5725.7812094621404,0,0,0,0,0,10260.560197978841,16804.721216259779,14608.300530880209,21853.782735459452,16804.721216259779,5381.5330905511873,402.33990906129111,281.60445381818136,322.12696703475376,188.45259839039136,281.60445381818136,15577.11960931196,21813.455107406939,21813.455107406939,19720.350085889466,26625.017887767994]
[null,7063,"St Nicholas' School",296,311,44,44,0,0,0,0,12872.140316698195,12784.819071843676,12848.21,20214.251503258663,20126.930258404147,20124.830000000002,19416.301334979133,19328.980090124616,19334,17219.880649599563,17132.559404745047,17157.169999999998,24465.362854178806,24378.041609324289,24338.02,null,17319.588949978079,16521.638781698548,0,0,0,0,0,0,0,0,3971.7700100000002,0,0,0.93049999999999999,122554,1,0.41638225255972694,0,6,3,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$error":"#VALUE!"},10169.038848343745,16654.827766362519,14477.998543984351,21658.853057938017,17445.660440574149,2679.1676151744959,0,0,0,0,0,10260.560197978841,16804.721216259779,14608.300530880209,21853.782735459452,17602.67138453931,2560.6427258875528,110.36733165115947,0,30.154389624614851,0,0,12554.92257817238,19551.674109163148,18791.258076267357,16698.153054749884,23602.820856628408]
[null,7066,"Milestone Academy",326,326,37,37,0,0,0,0,12756.187738650193,12760.128004034836,12700.22,20246.765131625205,20250.70539700985,20123.98,19352.210973853103,19356.151239237748,19237.41,17188.412224039108,17192.352489423749,17092.91,24574.598304938689,24578.538570323333,24413.22,null,17319.588949978079,16521.638781698548,174.10871965895203,225.97093658092587,258.5928721464972,399.29674846683798,322.57492607349474,0,0,0,7151,0,0,4.6768999999999998,0,1,0.31353135313531355,1,0,3,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$error":"#VALUE!"},10341.594566538941,16878.78310489664,14734.284839471464,22054.588190214366,17765.358087822409,2358.6268881587312,0,0,0,0,0,10434.668917637791,17030.692152840704,14866.893403026708,22253.079483926289,17925.246310612805,2323.8173091534427,0,0,0,0,0,12290.980980238746,19429.215135319006,18576.739190198074,16514.721627289255,23553.474849157428]
[null,7067,"Portal House School",80,80,0,0,0,0,0,0,17142.27633515327,17193.66534177255,16963.97,23686.437353434208,23737.826360053492,23449.760000000002,23686.437353434208,23737.826360053492,23449.760000000002,21490.016668054639,21541.405674673922,21272.93,28735.498872633878,28786.887879253161,28453.78,null,16521.638781698548,16521.638781698548,0,0,0,0,0,0,0,0,3816,0,0,0.81,0,0,0.54054054054054057,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$error":"#VALUE!"},10169.038848343745,16654.827766362519,14477.998543984351,21658.853057938017,16654.827766362519,6794.9295961821263,0,0,0,0,0,10260.560197978841,16804.721216259779,14608.300530880209,21853.782735459452,16804.721216259779,6911.6930577023431,0,0,0,0,0,16589.669999999998,22510.531496567499,22510.531496567499,20417.426475050033,27322.094276928554]
[null,7069,"The Wyvern School",297,303,33,47,0,0,0,0,12380.570734283385,12257.119844128607,12375.1,19722.681920843857,19599.231030689079,19651.72,18924.731752564327,18801.280862409549,18860.89,16728.311067184757,16604.860177029979,16684.060000000001,23973.793271764,23850.342381609222,23864.91,null,17319.588949978079,16521.638781698548,0,0,0,0,0,0,0,0,6156,0,0,7.6,0,1,0.34909090909090912,0,3,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$error":"#VALUE!"},10169.038848343745,16654.827766362519,14477.998543984351,21658.853057938017,17445.660440574149,2206.059770219661,0,0,0,0,0,10260.560197978841,16804.721216259779,14608.300530880209,21853.782735459452,17602.67138453931,2047.997517047593,72.024114889474731,8.1712666926250677,27.761952072196436,0,1.0510984130960423,12019.982359141657,19016.733890132426,18256.317857236634,16163.212835719163,23067.880637597689]
[null,7070,"Oakley School",170,152,42,60,0,0,0,0,13279.769475767549,13294.436750660556,13160.15,20621.880662328022,20636.547937221025,20436.77,19823.930494048491,19838.597768941494,19645.940000000002,17627.509808668921,17642.177083561928,17469.11,24872.992013248164,24887.659288141167,24649.96,null,17319.588949978079,16521.638781698548,0,0,0,0,0,0,0,0,4287,0,0,11.4161,0,0,0.375,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$error":"#VALUE!"},10169.038848343745,16654.827766362519,14477.998543984351,21658.853057938017,17445.660440574149,2991.1117167318776,0,0,0,0,0,10260.560197978841,16804.721216259779,14608.300530880209,21853.782735459452,17602.67138453931,3027.7651881429651,0,0,0,0,0,12466.70931675869,19463.460847749462,18703.044814853667,16609.939793336198,23514.607595214722]
[null,7072,"Meadowfield School",310,346,41,45,0,0,0,0,12563.066707720895,12342.033178990439,12303.93,19905.177894281362,19684.14436555091,19580.55,19107.227726001831,18886.194197271379,18789.72,16910.807040622265,16689.77351189181,16612.89,24156.289245201504,23935.255716471052,23793.739999999998,null,17319.588949978079,16521.638781698548,0,0,0,0,0,0,0,0,8934.58,0,0,2.5630000000000002,13000,1,0.41795665634674928,0,2,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$error":"#VALUE!"},10169.038848343745,16654.827766362519,14477.998543984351,21658.853057938017,17445.660440574149,2134.8903245615461,0,0,0,0,0,10260.560197978841,16804.721216259779,14608.300530880209,21853.782735459452,17602.67138453931,2173.5702846492904,0,0,0,0,0,11745.21610835809,18741.967639348863,17981.551606453068,15888.446584935598,22793.114386814123]
[null,7073,"Laleham Gap School",187,192,9,15,0,0,0,0,13347.473198787298,13169.766430881458,13221.34,20689.584385347771,20511.877617441933,20497.96,19891.63421706824,19713.927449162402,19707.129999999997,17695.213531688671,17517.506763782829,17530.3,24940.695736267913,24762.988968362075,24711.16,null,17319.588949978079,16521.638781698548,0,0,0,0,0,0,0,0,4885,0,0,2.5697000000000001,0,0,0.30653266331658291,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$error":"#VALUE!"},10169.038848343745,16654.827766362519,14477.998543984351,21658.853057938017,17445.660440574149,3052.3028103035981,0,0,0,0,0,10260.560197978841,16804.721216259779,14608.300530880209,21853.782735459452,17602.67138453931,2983.2507195300536,0,0,0,0,0,12720.262180423106,19717.013711413878,18956.597678518079,16863.49265700061,23768.160458879138]

{"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":4},null,7032,{"$f":"COUNTIF(D2:D108,\">0\")","v":16},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":0},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":1},7052,{"$f":"COUNTIF(V2:V108,\">0\")","v":0},7058,{"$f":"COUNTIF(X2:X108,\">0\")","v":0},7073,{"$f":"COUNTIF(Z2:Z108,\">0\")","v":16},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":0},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":3},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":17}]
["DFENUM",{"$f":"'Special Rates 2023-24'!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},225,0,110,0,132,0,158,0,93,0,150,0,80,0,80,0,218,0,91,0,90,0,187,0,220,0,209,0,329,0,246,0,542,0,296,0,326,0,297,0,170,0,310,0,136,0,120,0]
["postold",{"$f":"[0]!postold","v":0},0,0,0,0,0,0,0,0,0,0,45,0,0,0,30,0,100,0,53,0,10,0,9,0,41,0,33,0,73,0,30,0,59,0,44,0,37,0,33,0,42,0,41,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,10,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},236,1,106,0,132,0,152,0,100,0,160,0,80,0,80,0,269,0,95,0,92,0,205,1,227,0,213,0,278,0,256,0,648,0,311,0,326,0,303,0,152,0,346,0,172,0,236,1]
["postnew",{"$f":"[0]!postnew","v":0},0,0,0,0,0,0,0,0,0,0,35,0,0,0,30,0,107,0,60,0,11,0,15,0,39,0,30,0,130,0,39,0,77,0,44,0,37,0,47,0,60,0,45,0,0,0,0,1]
["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,10,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},12976.221006125608,0,15391.896421882589,0,14884.939863230713,0,13800.962144589717,0,15845.774056536913,0,14116.969340625137,0,17142.27633515327,0,17255.006502709006,0,13082.956804321117,0,13693.736258187,0,15436.172875735972,0,13347.473198787298,0,12904.604159150313,0,13124.539076540057,0,12371.704289803118,0,12952.89098687646,0,11758.119018481306,0,12872.140316698195,0,12756.187738650193,0,12380.570734283385,0,13279.769475767549,0,12563.066707720895,0,13518.112101137627,0,14649.275605845922,0]
["besdold",{"$f":"[0]!besdold","v":0},19520.38202440655,0,21936.057440163528,0,21489.405714274297,0,20345.123162870659,0,22389.935074817855,0,20661.130358906077,0,23686.437353434208,0,23851.029737911918,0,19642.929474102657,0,20237.897276467938,0,21980.333894016912,0,19891.63421706824,0,19448.765177431254,0,19668.700094820997,0,18915.86530808406,0,19497.052005157399,0,18302.280036762248,0,19416.301334979133,0,19352.210973853103,0,18924.731752564327,0,19823.930494048491,0,19107.227726001831,0,20062.273119418569,0,21193.436624126858,0]
["sldold",{"$f":"[0]!sldold","v":0},17323.961339026981,0,19739.636754783958,0,19317.164348619626,0,18148.702477491086,0,20193.514389438285,0,18464.709673526508,0,21490.016668054639,0,21687.230988097923,0,17456.454500785763,0,18041.476591088373,0,19783.913208637343,0,17695.213531688671,0,17252.344492051685,0,17472.279409441428,0,16719.44462270449,0,17300.631319777829,0,16105.859351382676,0,17219.880649599563,0,17188.412224039108,0,16728.311067184757,0,17627.509808668921,0,16910.807040622265,0,17865.852434038999,0,18997.015938747292,0]
["pdold",{"$f":"[0]!pdold","v":0},24569.443543606223,0,26985.118959363201,0,26703.350429519211,0,25394.184682070332,0,27438.996594017528,0,25710.191878105747,0,28735.498872633878,0,29073.417068997504,0,24744.834228633401,0,25286.958795667611,0,27029.395413216589,0,24940.695736267913,0,24497.826696630924,0,24717.761614020666,0,23964.926827283733,0,24546.113524357072,0,23351.341555961921,0,24465.362854178806,0,24574.598304938689,0,23973.793271764,0,24872.992013248164,0,24156.289245201504,0,25111.334638618242,0,26242.498143326535,0]
["asdold",{"$f":"[0]!asdold","v":0},19520.38202440655,0,21936.057440163528,0,21562.723167627497,0,20345.123162870659,0,22389.935074817855,0,20661.130358906077,0,23686.437353434208,0,23932.78980710579,0,20470.332078203093,0,21035.847444747469,0,29959.83557681222,0,20689.584385347771,0,20246.715345710785,0,20466.650263100528,0,19713.81547636359,0,20295.002173436929,0,19100.230205041778,0,20214.251503258663,0,20246.765131625205,0,19722.681920843857,0,20621.880662328022,0,19905.177894281362,0,20860.2232876981,0,21991.386792406389,0]
["pdweekdayold",{"$f":"[0]!pdweekdayold","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,81182.389953611841,0,0,0,0,0,89190.014774609415,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,60199.580721003607,0,0,0,92120.454938205046,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,109339.46894826677,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},12882.726312599621,1,15586.724506842907,0,14888.716218048692,0,13931.580193354785,0,15496.607025667963,0,14133.600693463375,0,17193.66534177255,0,17222.270299952514,0,12678.086340235641,0,13491.823294771324,0,15301.464214751606,0,13006.308476351536,1,12857.552392233018,0,13111.348353514699,0,12345.359006735052,0,12797.829015153693,0,11564.605428794841,0,12784.819071843676,0,12760.128004034836,0,12257.119844128607,0,13294.436750660556,0,12342.033178990439,0,13425.013716913696,0,13437.577780503896,1]
["besdnew",{"$f":"[0]!besdnew","v":0},19426.887330880563,1,22130.885525123849,0,21493.182069092276,0,20475.741211635723,0,22040.768043948905,0,20677.761711744315,0,23737.826360053492,0,23818.293535155426,0,19238.059010017183,0,20035.984313052264,0,21845.625233032544,0,19550.469494632478,1,19401.713410513956,0,19655.509371795637,0,18889.520025015991,0,19341.990033434635,0,18108.766447075777,0,19328.980090124616,0,19356.151239237748,0,18801.280862409549,0,19838.597768941494,0,18886.194197271379,0,19969.174735194636,0,19981.738798784834,1]
["sldnew",{"$f":"[0]!sldnew","v":0},17230.466645500994,1,19934.464839744276,0,19320.940703437605,0,18279.320526256153,0,19844.347358569335,0,18481.341026364746,0,21541.405674673922,0,21654.494785341427,0,17051.584036700286,0,17839.563627672695,0,19649.204547652975,0,17354.048809252905,1,17205.292725134386,0,17459.088686416068,0,16693.099339636421,0,17145.569348055062,0,15912.345761696211,0,17132.559404745047,0,17192.352489423749,0,16604.860177029979,0,17642.177083561928,0,16689.77351189181,0,17772.754049815067,0,17785.318113405265,1]
["pdnew",{"$f":"[0]!pdnew","v":0},24475.948850080236,1,27179.947044323522,0,26707.12678433719,0,25524.802730835399,0,27089.829563148574,0,25726.823230943992,0,28786.887879253161,0,29040.680866241011,0,24339.963764547927,0,25085.045832251937,0,26894.686752232217,0,24599.531013832151,1,24450.774929713629,0,24704.57089099531,0,23938.581544215664,0,24391.051552634308,0,23157.82796627545,0,24378.041609324289,0,24578.538570323333,0,23850.342381609222,0,24887.659288141167,0,23935.255716471052,0,25018.236254394309,0,25030.800317984507,1]
["asdnew",{"$f":"[0]!asdnew","v":0},19426.887330880563,1,22130.885525123849,0,21566.499522445476,0,20475.741211635723,0,22040.768043948905,0,20677.761711744315,0,23737.826360053492,0,23900.053604349298,0,20065.461614117619,0,20833.934481331795,0,29825.126915827848,0,20348.419662912009,1,20199.663578793487,0,20453.459540075168,0,19687.470193295521,0,20139.940201714166,0,18906.716615355308,0,20126.930258404147,0,20250.70539700985,0,19599.231030689079,0,20636.547937221025,0,19684.14436555091,0,20767.124903474167,0,20779.688967064365,1]
["pdweekdaynew",{"$f":"[0]!pdweekdaynew","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,81149.653750855345,0,0,0,0,0,89055.306113625047,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,59794.71025691813,0,0,0,91985.746277220678,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,109306.73274551028,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},12921.682434902115,1,15505.546138109441,0,14887.142736874535,0,13877.15600636934,0,15642.093288530024,0,14126.670963114109,0,17172.253255681182,0,17235.910384434384,0,12846.782366937923,0,13575.953696194523,0,15357.592823495092,0,13148.460444033104,1,12877.157295115225,0,13116.8444881086,0,12356.336208013412,0,12862.438170038178,0,11645.236091164203,0,12821.202923866393,0,12758.486226791236,0,12308.557715026431,0,13288.325386121802,0,12434.130482628128,0,13463.804710340333,0,13942.451874396407,1]
["besdyear",{"$f":"[0]!besdyear","v":0},19465.843453183057,1,22049.707156390381,0,21491.608587918119,0,20421.317024650278,0,22186.254306810966,0,20670.831981395051,0,23716.414273962124,0,23831.933619637297,0,19406.755036719464,0,20120.114714475461,0,21901.753841776033,0,19692.621462314048,1,19421.318313396165,0,19661.005506389534,0,18900.497226294352,0,19406.59918831912,0,18189.397109445141,0,19365.363942147331,0,19354.509461994145,0,18852.718733307371,0,19832.486404402742,0,18978.291500909068,0,20007.965728621275,0,20486.612892677342,1]
["sldyear",{"$f":"[0]!sldyear","v":0},17269.422767803488,1,19853.286471010812,0,19319.367222263449,0,18224.896339270708,0,19989.833621431397,0,18474.411296015482,0,21519.993588582554,0,21668.134869823301,0,17220.28006340257,0,17923.694029095892,0,19705.33315639646,0,17496.200776934471,1,17224.897628016595,0,17464.584821009968,0,16704.076540914783,0,17210.178502939551,0,15992.976424065571,0,17168.943256767761,0,17190.710712180149,0,16656.298047927805,0,17636.065719023176,0,16781.870815529499,0,17811.545043241706,0,18290.192207297776,1]
["pdyear",{"$f":"[0]!pdyear","v":0},24514.904972382734,1,27098.768675590058,0,26705.553303163033,0,25470.378543849954,0,27235.315826010639,0,25719.893500594721,0,28765.475793161793,0,29054.320950722882,0,24508.659791250211,0,25169.176233675134,0,26950.815360975703,0,24741.682981513721,1,24470.379832595834,0,24710.067025589207,0,23949.558745494025,0,24455.660707518793,0,23238.45862864481,0,24414.425461347004,0,24576.89679307973,0,23901.780252507044,0,24881.547923602415,0,24027.353020108741,0,25057.027247820948,0,25535.674411877018,1]
["asdyear",{"$f":"[0]!asdyear","v":0},19465.843453183057,1,22049.707156390381,0,21564.926041271319,0,20421.317024650278,0,22186.254306810966,0,20670.831981395051,0,23716.414273962124,0,23913.693688831168,0,20234.1576408199,0,20918.064882754992,0,29881.255524571334,0,20490.571630593578,1,20219.268481675696,0,20458.955674669069,0,19698.447394573886,0,20204.549356598647,0,18987.347277724672,0,20163.314110426865,0,20249.063619766246,0,19650.668901586901,0,20630.436572682276,0,19776.241669188596,0,20805.915896900806,0,21284.563060956876,1]
["pdweekdayyear",{"$f":"[0]!pdweekdayyear","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,81163.293835337216,0,0,0,0,0,89111.434722368533,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,59963.406283620418,0,0,0,92041.874885964178,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,109320.37282999215,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},12847.95,0,15483.34,0,14744.01,0,13666.89,0,15894.82,0,14106.029999999999,0,16963.97,0,17051.54,0,14529.83,0,13560.94,0,16536.41,0,13221.34,0,12837.48,0,12900.34,0,12252.69,0,12911.72,0,11603.02,0,12848.21,0,12700.22,0,12375.1,0,13160.15,0,12303.93,0,13384.19,0,13399.45,0]
["besdlastyear",{"$f":"[0]!besdlastyear","v":0},19333.73,0,21969.129999999997,0,21289.57,0,20152.68,0,22380.61,0,20522.379999999997,0,23449.760000000002,0,23588.73,0,19460.599999999999,0,20046.73,0,21992.97,0,19707.129999999997,0,19323.260000000002,0,19386.129999999997,0,18738.47,0,19397.510000000002,0,18088.810000000001,0,19334,0,19237.41,0,18860.89,0,19645.940000000002,0,18789.72,0,19869.98,0,19885.239999999998,0]
["sldlastyear",{"$f":"[0]!sldlastyear","v":0},17156.900000000001,0,19792.3,0,19136.7,0,17975.849999999999,0,20203.78,0,18345.55,0,21272.93,0,21444.23,0,18083.41,0,17869.900000000001,0,20404.25,0,17530.3,0,17146.439999999999,0,17209.3,0,16561.64,0,17220.68,0,15911.98,0,17157.169999999998,0,17092.91,0,16684.060000000001,0,17469.11,0,16612.89,0,17693.150000000001,0,17708.41,0]
["pdlastyear",{"$f":"[0]!pdlastyear","v":0},24337.760000000002,0,26973.15,0,26457.01,0,25156.71,0,27384.63,0,25526.400000000001,0,28453.78,0,28764.54,0,24516.989999999998,0,25050.760000000002,0,26996.99,0,24711.16,0,24327.29,0,24390.16,0,23742.5,0,24401.54,0,23092.83,0,24338.02,0,24413.22,0,23864.91,0,24649.96,0,23793.739999999998,0,24874.010000000002,0,24889.260000000002,0]
["asdlastyear",{"$f":"[0]!asdlastyear","v":0},19333.73,0,21969.129999999997,0,21362.23,0,20152.68,0,22380.61,0,20522.379999999997,0,23449.760000000002,0,23669.760000000002,0,20545.71,0,20837.57,0,29901.29,0,20497.96,0,20114.099999999999,0,20176.97,0,19529.309999999998,0,20188.34,0,18879.64,0,20124.830000000002,0,20123.98,0,19651.72,0,20436.77,0,19580.55,0,20660.809999999998,0,20676.07,0]
["pdweekdaylastyear",{"$f":"[0]!pdweekdaylastyear","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,80408.710000000006,0,0,0,0,0,83703.13,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,86607.43,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,108314.64,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},12921.682434902115,1,15632.556726897979,0,14972.183000000001,0,13877.15600636934,0,16044.433197591319,0,14529.210900000002,0,17172.253255681182,0,17235.910384434384,0,14965.724900000001,0,13575.953696194523,0,17032.5023,0,13148.460444033104,1,12877.157295115225,0,13116.8444881086,0,12356.336208013412,0,13156.2724,0,11645.236091164203,0,12931.570255517552,0,12758.486226791236,0,12380.581829915907,0,13288.325386121802,0,12434.130482628128,0,13463.804710340333,0,13942.451874396407,1]
["BESD",{"$f":"besdfinal","v":0},19465.843453183057,1,22055.982289935801,0,21491.608587918119,0,20421.317024650278,0,22467.858760629148,0,20670.831981395051,0,23716.414273962124,0,23831.933619637297,0,19406.755036719464,1,20120.114714475461,0,22338.074196803758,0,19692.621462314048,1,19421.318313396165,0,19661.005506389534,0,18900.497226294352,0,19443.897608152289,0,18189.397109445141,0,19365.363942147331,0,19354.509461994145,0,18852.718733307371,1,19832.486404402742,0,18978.291500909068,0,20007.965728621275,0,20486.612892677342,1]
["SLD",{"$f":"sldfinal","v":0},17269.422767803488,1,19900.084117772811,0,19319.367222263449,0,18224.896339270708,0,20311.960588466151,0,18474.411296015482,0,21519.993588582554,0,21668.134869823301,0,18625.9123,0,17923.694029095892,0,21016.377500000002,0,17496.200776934471,1,17224.897628016595,0,17464.584821009968,0,16704.076540914783,0,17287.999435989295,0,15992.976424065571,0,17199.09764639238,0,17190.710712180149,0,16656.298047927805,1,17636.065719023176,0,16781.870815529499,0,17811.545043241706,0,18290.192207297776,1]
["PD&PMLD",{"$f":"pdfinal","v":0},24514.904972382734,1,27098.768675590058,0,26705.553303163033,0,25470.378543849954,0,27423.768424401034,0,25719.893500594721,0,28765.475793161793,0,29054.320950722882,0,24729.898300000001,0,25169.176233675134,0,27656.138599999998,0,24741.682981513721,1,24470.379832595834,0,24710.067025589207,0,23949.558745494025,0,24455.660707518793,0,23238.45862864481,0,24414.425461347004,0,24576.89679307973,0,23901.780252507044,0,24881.547923602415,0,24027.353020108741,0,25057.027247820948,0,25535.674411877018,1]
["ASD",{"$f":"asdfinal","v":0},19465.843453183057,1,22055.982289935801,0,21564.926041271319,0,20421.317024650278,0,22467.858760629148,0,20670.831981395051,0,23716.414273962124,0,23913.693688831168,0,21162.081299999998,0,20918.064882754992,0,30448.736400000002,0,20490.571630593578,1,20219.268481675696,0,20458.955674669069,0,19698.447394573886,0,20227.126122034959,0,18987.347277724672,0,20163.314110426865,0,20249.063619766246,0,19650.668901586901,1,20630.436572682276,0,19776.241669188596,0,20805.915896900806,0,21284.563060956876,1]
["WeekdayPD&PMLD",{"$f":"pd5final","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,81163.293835337216,0,0,0,0,0,89111.434722368533,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,61572.782000000007,0,0,0,92041.874885964178,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,109320.37282999215,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!"},118624,{"$error":"#VALUE!"},217073,{"$error":"#VALUE!"},217073,{"$error":"#VALUE!"},138800,{"$error":"#VALUE!"},267512,{"$error":"#VALUE!"},118624,{"$error":"#VALUE!"},237248,{"$error":"#VALUE!"},108536,{"$error":"#VALUE!"},237248,{"$error":"#VALUE!"},118624,{"$error":"#VALUE!"},0,{"$error":"#VALUE!"},0,{"$error":"#VALUE!"}]