{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Special Rates 2020-21","DATA"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":56,"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 2020-21","index":0,"n_rows":135,"n_cols":19,"rows_kept":135,"cut":false,"hidden":false,"merged":[[50,1,50,8],[43,6,43,8],[44,6,44,8],[47,1,47,8],[49,1,49,8],[48,1,48,8],[37,6,37,8],[38,6,38,8],[39,6,39,8],[40,6,40,8],[42,6,42,8],[105,9,110,9],[113,9,118,9],[111,10,113,16],[93,6,93,12],[93,1,93,4],[105,5,105,6],[111,5,111,6],[113,5,113,6],[117,3,117,4],[113,3,113,4],[106,3,106,4],[107,3,107,4],[108,3,108,4],[109,3,109,4],[51,1,51,8],[52,1,52,8],[53,1,53,8],[54,1,54,8],[55,1,55,8],[30,1,30,6],[4,15,12,16],[33,1,33,6],[22,9,22,13],[12,7,19,10],[26,1,26,7],[28,1,28,7],[64,9,64,13],[92,6,92,9],[104,3,104,4],[104,5,104,6],[105,3,105,4],[73,1,73,4],[74,1,74,4],[75,1,75,4],[76,1,76,4],[77,1,77,4],[88,1,88,8],[92,1,92,4],[66,1,66,4],[69,1,69,4],[70,1,70,4],[71,1,71,4],[1,15,2,15],[78,1,78,4],[79,1,79,4],[80,1,80,4],[86,9,86,13],[72,1,72,4],[56,1,56,8],[57,1,57,8],[58,1,58,8],[59,1,59,8],[67,1,67,4],[68,1,68,4],[86,15,86,16],[64,15,64,16],[22,15,22,16],[7,4,7,10],[112,5,112,6],[114,5,114,6],[115,5,115,6],[116,5,116,6],[117,5,117,6],[106,5,106,6],[107,5,107,6],[108,5,108,6],[109,5,109,6],[110,5,110,6],[118,5,118,6],[125,1,125,3],[126,1,126,3],[119,3,119,4],[119,5,119,6],[131,1,131,2],[132,1,132,2],[118,3,118,4],[110,3,110,4],[111,3,111,4],[112,3,112,4],[114,3,114,4],[115,3,115,4],[116,3,116,4]]}
[]
[]
[]
[null,null,null,null,"2020/21 Calculation of Special School Funding Rates"]
[]
[]
[]
[null,"DfE",null,null,{"$f":"IFERROR(VLOOKUP(DFENUM,DATA!B5:C26,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\nPlace numbers 2019-20 agreed November 2018\n\n\nPlace numbers 2020-21 agreed November 2019"]
[]
[null,"2019/20",{"$f":"IFERROR(VLOOKUP(DFENUM,DATA!B5:K26,3,0),0)","v":0},{"$f":"IFERROR(VLOOKUP(DFENUM,DATA!B5:K26,5,0),0)","v":0},{"$f":"IFERROR(VLOOKUP(DFENUM,DATA!B5:K26,7,0),0)","v":0},{"$f":"IFERROR(VLOOKUP(DFENUM,DATA!B5:K26,9,0),0)","v":0}]
[]
[null,"2020/21",{"$f":"IFERROR(VLOOKUP(DFENUM,DATA!B5:K26,4,0),0)","v":0},{"$f":"IFERROR(VLOOKUP(DFENUM,DATA!B5:K26,6,0),0)","v":0},{"$f":"IFERROR(VLOOKUP(DFENUM,DATA!B5:K26,8,0),0)","v":0},{"$f":"IFERROR(VLOOKUP(DFENUM,DATA!B5:K26,10,0),0)","v":0}]
[]
[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,"Day Pupil",null,null,null,null,null,"Weekday",null,null,"Weekend"]
[null,"Section 2 - Calculation of funding rate for April 2020 to March 2021"]
[null,null,null,null,null,null,null,null,null,"MLD & SLCN","BESD","SLD","PD & PMLD","ASD",null,"PD & PMLD","ASD",null,"PD & PMLD"]
[]
["(A)","April 2020 to August 2020 (Formula only excluding MFG)- based on  Academic Year 2019 to 2020. Data taken from 2019-20 Funding Rates Calculation.",null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(DFENUM,DATA!B5:AA26,11,0),0)","v":0},{"$f":"IFERROR(VLOOKUP(DFENUM,DATA!B5:AA26,17,0),0)","v":0},{"$f":"IFERROR(VLOOKUP(DFENUM,DATA!B5:AA26,20,0),0)","v":0},{"$f":"IFERROR(VLOOKUP(DFENUM,DATA!B5:AA26,23,0),0)","v":0},{"$f":"IFERROR(VLOOKUP(DFENUM,DATA!B5:AA26,14,0),0)","v":0},null,{"$f":"IFERROR(VLOOKUP(DFENUM,DATA!B5:BX26,50,0),0)","v":0},{"$f":"IFERROR(VLOOKUP(DFENUM,DATA!B5:BX26,47,0),0)","v":0},null,{"$f":"IFERROR(VLOOKUP(DFENUM,DATA!B5:BX26,53,0),0)","v":0}]
[]
["(B)","September 2020 to March 2021 (Formula only excluding MFG)- based on  Academic Year 2020 to 2021. See section 3 for calculation.",null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(DFENUM,DATA!B5:AA26,12,0),0)","v":0},{"$f":"IFERROR(VLOOKUP(DFENUM,DATA!B5:AA26,18,0),0)","v":0},{"$f":"IFERROR(VLOOKUP(DFENUM,DATA!B5:AA26,21,0),0)","v":0},{"$f":"IFERROR(VLOOKUP(DFENUM,DATA!B5:AA26,24,0),0)","v":0},{"$f":"IFERROR(VLOOKUP(DFENUM,DATA!B5:AA26,15,0),0)","v":0},null,{"$f":"IFERROR(VLOOKUP(DFENUM,DATA!B5:BX26,52,0),0)","v":0},{"$f":"IFERROR(VLOOKUP(DFENUM,DATA!B5:BX26,49,0),0)","v":0},null,{"$f":"IFERROR(VLOOKUP(DFENUM,DATA!B5:BX26,55,0),0)","v":0}]
[]
["(C)","April 2020 to March 2021 - based on Academic Year 2019 to 2020 (April 2020 to August 2020) 5/12's + Academic Year 2020 to 2021 (September 2020 to March 2021) 7/12's",null,null,null,null,null,null,"=  (A) X 5/12 \n           + \n    (B) X 7/12",{"$f":"(J27*5/12)+(J29*7/12)","v":0},{"$f":"(K27*5/12)+(K29*7/12)","v":0},{"$f":"(L27*5/12)+(L29*7/12)","v":0},{"$f":"(M27*5/12)+(M29*7/12)","v":0},{"$f":"(N27*5/12)+(N29*7/12)","v":0},null,{"$f":"IF(DFENUM=7073,P27,(P27*5/12)+(P29*7/12))","v":0},{"$f":"IF(DFENUM=7073,Q27,(Q27*5/12)+(Q29*7/12))","v":0},null,{"$f":"IF(DFENUM=7073,S27,(S27*5/12)+(S29*7/12))","v":0}]
[]
["(D)","Final funding rate for financial Year 2019 to 2020",null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(DFENUM,DATA!B5:AA26,13,0),0)","v":0},{"$f":"IFERROR(VLOOKUP(DFENUM,DATA!B5:AA26,19,0),0)","v":0},{"$f":"IFERROR(VLOOKUP(DFENUM,DATA!B5:AA26,22,0),0)","v":0},{"$f":"IFERROR(VLOOKUP(DFENUM,DATA!B5:AA26,25,0),0)","v":0},{"$f":"IFERROR(VLOOKUP(DFENUM,DATA!B5:AA26,16,0),0)","v":0},null,{"$f":"IFERROR(VLOOKUP(DFENUM,DATA!B5:BX26,51,0),0)","v":0},{"$f":"IFERROR(VLOOKUP(DFENUM,DATA!B5:BX26,48,0),0)","v":0},null,{"$f":"IFERROR(VLOOKUP(DFENUM,DATA!B5:BX26,54,0),0)","v":0}]
["(E)","MFG rate (D) X 100%",null,null,null,null,null,null,null,{"$f":"J33","v":0},{"$f":"K33","v":0},0,0,0,null,{"$f":"P33","v":0},{"$f":"Q33","v":0},null,{"$f":"S33","v":0}]
[]
[]
[null,null,null,null,null,null,null,null,null,"MLD & SLCN","BESD","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":"J31","v":0},{"$f":"K31","v":0},{"$f":"L31","v":0},{"$f":"M31","v":0},{"$f":"N31","v":0},null,{"$f":"P31","v":0},{"$f":"Q31","v":0},null,{"$f":"S31","v":0}]
[null,null,null,null,null,null,"MFG funding rate (E)",null,null,{"$f":"J34","v":0},{"$f":"K34","v":0},{"$f":"L34","v":0},{"$f":"M34","v":0},{"$f":"N34","v":0},null,{"$f":"P34","v":0},{"$f":"Q34","v":0},null,{"$f":"S34","v":0}]
[null,null,null,null,null,null,"Amount of MFG if (E) is greater than ( C)",null,null,{"$f":"IF(J38>J39,0,J39-J38)","v":0},{"$f":"IF(K38>K39,0,K39-K38)","v":0},0,0,0,null,{"$f":"IF(P38>P39,0,P39-P38)","v":0},0,null,{"$f":"IF(S38>S39,0,S39-S38)","v":0}]
[null,null,null,null,null,null,"Final Rate formula plus MFG",null,null,{"$f":"SUM(J38,J40)","v":0},{"$f":"SUM(K38,K40)","v":0},0,0,0,null,{"$f":"SUM(P38,P40)","v":0},0,null,{"$f":"SUM(S38,S40)","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($Q$41=0,0,10000)","v":0},{"$f":"IF($Q$41=0,0,10000)","v":0},null,{"$f":"IF($F$17=0,0,10000)","v":0}]
[null,null,null,null,null,null,"Element 3",null,null,{"$f":"J41-J43","v":-10000},{"$f":"K41-K43","v":-10000},-10000,-10000,-10000,null,{"$f":"P41-P43","v":0},0,null,{"$f":"S41-S43","v":0}]
[null,null,null,null,null,null,"Total rate",null,null,{"$f":"SUM(J43:J44)","v":0},{"$f":"SUM(K43:K44)","v":0},0,0,0,null,{"$f":"SUM(P43:P44)","v":0},0,null,{"$f":"SUM(S43:S44)","v":0}]
[null,"Section 3 - Pupil Led Elements"]
[null,null,null,null,null,null,null,null,null,"MLD & SLCN","BESD","SLD","PD & PMLD","ASD",null,"PD & PMLD","ASD",null,"PD & PMLD"]
[null,"Day Rate",null,null,null,null,null,null,null,9231.2186618210617,11219.545340205799,13253.772522575922,19957.333495273517,15285.913320165697,null,{"$f":"IF($P$29=0,0,M48)","v":0},{"$f":"IF($Q$29=0,0,N48)","v":0},null,{"$f":"IF($S$31=0,0,M48)","v":0}]
[null,"Adjusted Rate due to School type (see note)",null,null,null,null,null,null,null,0,{"$f":"IFERROR(VLOOKUP(DFENUM,DATA!B5:BE26,28,0),0)-K48","v":-11219.545340205799},0,0,{"$f":"IFERROR(VLOOKUP(DFENUM,DATA!B5:BE26,27,0),0)-N48","v":-15285.913320165697},null,0,{"$f":"IF($Q$29=0,0,N49)","v":0},null,0]
[null,"Residential Weekday rate",null,null,null,null,null,null,null,0,0,0,0,0,null,{"$f":"IF($P$29=0,0,IFERROR(VLOOKUP(DFENUM,DATA!B5:BX26,56,0),0))","v":0},{"$f":"IF($Q$29=0,0,IFERROR(VLOOKUP(DFENUM,DATA!B5:BX26,56,0),0))","v":0},null,{"$f":"IF($S$31=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$31=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,110.24,{"$f":"$J52","v":110.24},{"$f":"$J52","v":110.24},110.24,110.24,null,{"$f":"IF($P$29=0,0,M52)","v":0},{"$f":"IF($Q$29=0,0,N52)","v":0},null,{"$f":"IF($S$31=0,0,P52)","v":0}]
[null,"Lunch Grant",null,null,null,null,null,null,null,11.440000000000003,{"$f":"$J53","v":11.440000000000003},11.440000000000003,11.440000000000003,11.440000000000003,null,{"$f":"IF($P$29=0,0,M53)","v":0},{"$f":"IF($Q$29=0,0,N53)","v":0},null,{"$f":"IF($S$31=0,0,P53)","v":0}]
[null,"Specialist Schools Funding",null,null,null,null,null,null,null,94.932146113822895,94.932146113822895,94.932146113822895,94.932146113822895,94.932146113822895,null,{"$f":"IF($P$29=0,0,M54)","v":0},{"$f":"IF($Q$29=0,0,N54)","v":0},null,0]
[null,"Further Delegation",null,null,null,null,null,null,null,45.297317852778384,45.297317852778384,45.297317852778384,45.297317852778384,45.297317852778384,null,{"$f":"IF($P$29=0,0,M55)","v":0},{"$f":"IF($Q$29=0,0,N55)","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$29=0,0,1414)","v":0},{"$f":"IF($Q$29=0,0,1414)","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$31=0,0,2132)","v":0}]
[null,"London Fringe Day Pupil",null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(DFENUM,DATA!B5:BE26,29,0),0)","v":0},{"$f":"IFERROR(VLOOKUP(DFENUM,DATA!B5:BE26,30,0),0)","v":0},{"$f":"IFERROR(VLOOKUP(DFENUM,DATA!B5:BE26,31,0),0)","v":0},{"$f":"IFERROR(VLOOKUP(DFENUM,DATA!B5:BE26,32,0),0)","v":0},{"$f":"IFERROR(VLOOKUP(DFENUM,DATA!B5:BE26,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$29=0,0,IFERROR(VLOOKUP(DFENUM,DATA!B5:BX26,58,0),0))","v":0},{"$f":"IF($Q$29=0,0,IFERROR(VLOOKUP(DFENUM,DATA!B5:BX26,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$31=0,0,IFERROR(VLOOKUP(DFENUM,DATA!B5:BX26,59,0),0))","v":0}]
[]
[null,"Rate for Pupil Led Elements",null,null,null,null,null,null,null,{"$f":"SUM(J48:J61)","v":9493.1281257876635},{"$f":"SUM(K48:K61)","v":261.90946396660127},{"$f":"SUM(L48:L61)","v":13515.681986542524},{"$f":"SUM(M48:M61)","v":20219.24295924012},{"$f":"SUM(N48:N61)","v":261.90946396660127},null,{"$f":"SUM(P48:P61)","v":0},{"$f":"SUM(Q48:Q61)","v":0},null,{"$f":"SUM(S48:S61)","v":0}]
[]
[null,"Section 4 - School Led Elements"]
[null,null,null,null,null,null,null,null,null,"Need Type"]
[null,null,null,null,null,"Units","Rate","Total","Places","MLD & SLCN","BESD","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},360184.24,{"$f":"F67*G67","v":0},{"$f":"$C$17+$D$17","v":0},{"$f":"IF(I67=0,0,H67/I67)","v":0},{"$f":"$J67","v":0},{"$f":"$J67","v":0},0,0,null,{"$f":"IF($P$29=0,0,M67)","v":0},{"$f":"IF($Q$29=0,0,N67)","v":0},null,{"$f":"IF($S$31=0,0,M67)","v":0}]
[null,"Lump Sum Catering Day",null,null,null,{"$f":"IF(DFENUM>0,1,0)","v":0},2080,{"$f":"F68*G68","v":0},{"$f":"$C$17+$D$17","v":0},{"$f":"IF(I68=0,0,H68/I68)","v":0},{"$f":"$J68","v":0},0,0,0,null,0,0,null,{"$f":"IF($S$31=0,0,M68)","v":0}]
[null,"Specialist Schools Funding- Lump Sum",null,null,null,{"$f":"IF(DFENUM>0,1,0)","v":0},12290.416666666668,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$26,43,0),0)*(prenew+postnew)","v":0},431.6,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$26,37,0),0)","v":0},31.199997689876888,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$26,40,0),0)","v":0},1094.0799999999997,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$26,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$26,42,0),0)","v":0},5199.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$26,45,0),0)","v":0},4553.12,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$26,46,0),0)","v":0},39964.080000000002,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$26,38,0),0)","v":0},51.999524188600837,0,{"$f":"E17","v":0},0,0,0,0,0,null,{"$f":"IF($P$29=0,0,((F77*G77)/I77))","v":0},{"$f":"IF($Q$29=0,0,((F77*G77)/I77))","v":0},null,{"$f":"IF($S$31=0,0,((F77*G77)/I77))","v":0}]
[null,"Residential Floor Area Weekend (m2)",null,null,null,{"$f":"IFERROR(VLOOKUP(DFENUM,DATA!$B$5:$BE$26,39,0),0)","v":0},67.599904490770257,0,{"$f":"E17","v":0},0,0,0,0,0,null,{"$f":"IF($P$29=0,0,((F78*G78)/I78))","v":0},{"$f":"IF($Q$29=0,0,((F78*G78)/I78))","v":0},null,{"$f":"IF($S$31=0,0,((F78*G78)/I78))","v":0}]
[null,"Lump Sum Residential",null,null,null,{"$f":"IF(SUM(P31:S31)>0,1,0)","v":0},169962,0,{"$f":"E17","v":0},0,0,0,0,0,null,{"$f":"IF($P$29=0,0,((F79*G79)/I79))","v":0},{"$f":"IF($Q$29=0,0,((F79*G79)/I79))","v":0},null,{"$f":"IF($S$31=0,0,((F79*G79)/I79))","v":0}]
[null,"London Fringe Day Pupils",null,null,null,{"$f":"IFERROR(VLOOKUP(DFENUM,DATA!$B$5:$BE$26,44,0),0)","v":0},4008.42,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,0,0,{"$f":"E17","v":0},0,0,0,0,0,null,{"$f":"IF($P$29=0,0,IFERROR(VLOOKUP(DFENUM,DATA!B5:BX26,60,0),0))","v":0},{"$f":"IF($Q$29=0,0,IFERROR(VLOOKUP(DFENUM,DATA!B5:BX26,60,0),0))","v":0},null,{"$f":"IF($S$31=0,0,IFERROR(VLOOKUP(DFENUM,DATA!B5:BX26,61,0),0))","v":0}]
[]
[null,"Rate for School Led Elements",null,null,null,null,null,null,null,{"$f":"SUM(J67:J82)","v":0},0,0,0,0,null,{"$f":"SUM(P67:P82)","v":0},{"$f":"SUM(Q67:Q82)","v":0},null,{"$f":"SUM(S67:S82)","v":0}]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,"Need Type"]
[null,"Total Formula Rate",null,null,null,null,null,null,null,"MLD & SLCN","BESD","SLD","PD & PMLD","ASD",null,"PD & PMLD","ASD",null,"PD & PMLD"]
[null,null,null,null,null,null,null,null,null,{"$f":"J62+J83","v":9493.1281257876635},{"$f":"K62+K83","v":261.90946396660127},{"$f":"L62+L83","v":13515.681986542524},{"$f":"M62+M83","v":20219.24295924012},{"$f":"N62+N83","v":261.90946396660127},null,{"$f":"P62+P83","v":0},{"$f":"Q62+Q83","v":0},null,{"$f":"S62+S83","v":0}]
[null,null,null,null,null,null,null,null,null,{"$f":"ROUND(J89-mldnew,1)","v":9493.1},{"$f":"ROUND(K89-besdnew,1)","v":261.89999999999998},{"$f":"ROUND(L89-sldnew,1)","v":13515.7},{"$f":"ROUND(M89-pdnew,1)","v":20219.2},{"$f":"ROUND(N89-asdnew,1)","v":261.89999999999998},null,{"$f":"ROUND(P89-pdweekdaynew,1)","v":0},{"$f":"ROUND(Q89-asdweekdaynew,1)","v":0},null,{"$f":"ROUND(S89-pdweekendnew,1)","v":0}]
[null,"Note",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(J90=0,K90=0,L90=0,M90=0,N90=0),\"OK\",\"ERROR\")","v":"ERROR"},null,null,null,null,{"$f":"IF(AND(P90=0,Q90=0,S90=0),\"OK\",\"ERROR\")","v":"OK"}]
[null,"ASD",null,null,null,null,"BESD",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(N91=\"OK\",S91=\"OK\"),\"OK\",\"ERROR\")","v":"ERROR"}]
[null," - All ASD pupils in Stone Bay are funded at ASD2",null,null,null,null," - 75% of Pupils at BESD Schools funded at BESD2"]
[null," - 10% of all ASD places in C & I and PSCN Special Schools are funded at ASD2\n",null,null,null,null," - 25% of all Primary aged Pupils at B&L Schools funded at at BESD2"]
[]
[]
[]
[]
[]
[]
[]
[null,"Section 5 - Analysis of Rate Changes"]
[]
[]
[null,null,null,"2019/20 Financial Year",null,"2020/21 Financial Year",null,"Movement £","Movement %"]
[null,"Pupil Led Elements",null,null,null,null,null,null,null,"}"]
[null,null,"MLD & SLCN",{"$f":"VLOOKUP(DFENUM,DATA!B:CG,63,0)","v":{"$error":"#N/A"}},null,{"$f":"VLOOKUP(DFENUM,DATA!B:CG,74,0)","v":{"$error":"#N/A"}},null,{"$f":"F107-D107","v":{"$error":"#N/A"}},{"$f":"H107/D107","v":{"$error":"#N/A"}}]
[null,null,"BESD",{"$f":"VLOOKUP(DFENUM,DATA!B:CG,64,0)","v":{"$error":"#N/A"}},null,{"$f":"VLOOKUP(DFENUM,DATA!B:CG,75,0)","v":{"$error":"#N/A"}},null,{"$f":"F108-D108","v":{"$error":"#N/A"}},{"$f":"H108/D108","v":{"$error":"#N/A"}}]
[null,null,"SLD",{"$f":"VLOOKUP(DFENUM,DATA!B:CG,65,0)","v":{"$error":"#N/A"}},null,{"$f":"VLOOKUP(DFENUM,DATA!B:CG,76,0)","v":{"$error":"#N/A"}},null,{"$error":"#N/A"},{"$error":"#N/A"},null,"This will always be 3% apart from for the BESD rate at certain schools which will differ slightly"]
[null,null,"PD & PMLD",{"$f":"VLOOKUP(DFENUM,DATA!B:CG,66,0)","v":{"$error":"#N/A"}},null,{"$f":"VLOOKUP(DFENUM,DATA!B:CG,77,0)","v":{"$error":"#N/A"}},null,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,"ASD",{"$f":"VLOOKUP(DFENUM,DATA!B:CG,67,0)","v":{"$error":"#N/A"}},null,{"$f":"VLOOKUP(DFENUM,DATA!B:CG,78,0)","v":{"$error":"#N/A"}},null,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,"School Led Elements",null,null,null,null,null,null,null,null,"The component school led rates have all increased by 3%. The overall rate change will differ because the aim is to deliver 3% more funding in total to the school but this total may be spread across a different number of pupils to last year. Other changes such as floor area can make a further difference."]
[null,null,"All",{"$f":"VLOOKUP(DFENUM,DATA!B:CG,68,0)","v":{"$error":"#N/A"}},null,{"$f":"VLOOKUP(DFENUM,DATA!B:CG,79,0)","v":{"$error":"#N/A"}},null,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,"Minimum Funding Guarantee",null,null,null,null,null,null,null,"}"]
[null,null,"MLD & SLCN",{"$f":"VLOOKUP(DFENUM,DATA!B:CG,69,0)","v":{"$error":"#N/A"}},null,{"$f":"VLOOKUP(DFENUM,DATA!B:CG,80,0)","v":{"$error":"#N/A"}},null,{"$error":"#N/A"},{"$f":"IFERROR(H115/D115,0)","v":0}]
[null,null,"BESD",{"$f":"VLOOKUP(DFENUM,DATA!B:CG,70,0)","v":{"$error":"#N/A"}},null,{"$f":"VLOOKUP(DFENUM,DATA!B:CG,81,0)","v":{"$error":"#N/A"}},null,{"$error":"#N/A"},{"$f":"IFERROR(H116/D116,0)","v":0}]
[null,null,"SLD",{"$f":"VLOOKUP(DFENUM,DATA!B:CG,71,0)","v":{"$error":"#N/A"}},null,{"$f":"VLOOKUP(DFENUM,DATA!B:CG,82,0)","v":{"$error":"#N/A"}},null,{"$error":"#N/A"},0,null,"This can vary but will be reduced on account of increases in the above two elements"]
[null,null,"PD & PMLD",{"$f":"VLOOKUP(DFENUM,DATA!B:CG,72,0)","v":{"$error":"#N/A"}},null,{"$f":"VLOOKUP(DFENUM,DATA!B:CG,83,0)","v":{"$error":"#N/A"}},null,{"$error":"#N/A"},0]
[null,null,"ASD",{"$f":"VLOOKUP(DFENUM,DATA!B:CG,73,0)","v":{"$error":"#N/A"}},null,{"$f":"VLOOKUP(DFENUM,DATA!B:CG,84,0)","v":{"$error":"#N/A"}},null,{"$error":"#N/A"},0]
[]
[]
[null,"Section 6 - 2020/21 Nursery Provision Lump Sum Calculation"]
[]
[null,"Rates"]
[]
[null,"Leadership Lump Sum per provision",null,null,52000]
[null,"Day Rate per FTE (see breakdown)",null,null,9029]
[]
[null,"Calculation"]
[]
[null,null,null,"Units","Rate","Total"]
[null,"Leadership Lump Sum",null,{"$f":"IF(D133>9,2,IF(D133>0,1,0))","v":0},{"$f":"E126","v":52000},{"$f":"D132*E132","v":0}]
[null,"Day Rate",null,{"$f":"IFERROR(VLOOKUP('Special Rates 2020-21'!DFENUM,DATA!B:BK,62,0),0)","v":0},{"$f":"E127","v":9029},{"$f":"D133*E133","v":0}]
[]
[null,null,null,null,"Total Funding at this provision:",{"$f":"IFERROR(F133+F132,\"TBC\")","v":0}]

{"sheet":"DATA","index":1,"n_rows":26,"n_cols":85,"rows_kept":26,"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,"2019/20 Financial Year",null,null,null,null,null,null,null,null,null,null,"2020/21 Financial Year"]
[null,null,null,"Pre-16",null,"Post-16",null,"Weekday",null,"Weekend",null,"MLD & SLCN",null,null,"ASD",null,null,"BESD",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","19/20","20/21","19/20","20/21","19/20","20/21","19/20","20/21","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","New MFG","ASD Rate","BESD Rate","MLD & SLCN","BESD","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","BESD","SLD","PD&PMLD","ASD","All","MLD&SLCN","BESD","SLD","PD&PMLD","ASD","MLD&SLCN","BESD","SLD","PD&PMLD","ASD","All","MLD&SLCN","BESD","SLD","PD&PMLD","ASD"]
[null,7002,"Broomhill Bank School",173,218,62,100,23,23,0,0,12877.701909002875,12041.662936575725,14529.831195186851,19712.543149157744,18876.504176730596,20545.7057143442,14880.657616473673,14044.618644046524,15687.057905843791,16924.086627700253,16088.047655273102,18083.413180345684,23667.336630704991,22831.297658277846,24009.60844942203,14529.831195186851,16024.181313268411,11219.545340205799,37.577373380184419,52.206402466245841,61.408231322700985,101.09726162984424,79.45596208770435,907.45893922361461,0,0,10814.893001489763,632.10699851023674,0,10.685,0,0,0.2247191011235955,1,0,1,56467.479235606646,59779.395604965997,55631.440263179495,0,0,0,0,0,0,25693.782537190513,0,907.45893922361461,0,12.605094339622642,0,0,9175.1258690900231,11101.044818581184,13065.88040629904,19549.774639957435,15747.088600008192,3316.8622802286764,2037.8430458681505,1269.1508070339332,1700.6704938179664,1142.9715292359142,1481.7548341073489,9530.7054991678488,11533.661206638648,13577.090217865225,20320.340220869966,16365.546739322719,2859.3070092525231,2139.818686766479,1294.0896899526197,1647.0159532279358,829.96121929953733,1320.8519657689576]
[null,7021,"Valence School",72,72,33,33,46,46,16,18,16203.95385265677,16250.198800439221,16075.63029224391,22382.276603238344,22428.521551020793,21649.813723217227,18240.26374644379,18286.508694226242,17667.109053222437,20304.672927463085,20350.917875245534,19652.117881125603,27138.413919568113,27184.658867350561,26223.022681226583,16075.63029224391,15285.913320165697,11219.545340205799,160.72911205635455,208.71232745863671,238.89432610780895,369.07434551523761,284.35720429329211,0,1182.9403614732703,1675.3524755272863,8799,0,1924,18.321999999999999,0,1,0.31506849315068491,1,0,0,0,0,0,75349.929329251332,72443.296025761796,75396.174277033773,101401.01751416711,97492.419280488495,101447.26246194956,39460.98382328514,24841.076070861789,1182.9403614732703,1675.3524755272863,38.175428571428569,38.175428571428569,0,9282.5550363884795,11240.545318876004,13225.554146779166,19796.45894688015,15223.249988870793,6426.5637343464368,366.51152150899361,0,0,0,0,9653.8572378440185,11690.167131631039,13754.576312650333,20588.317304755357,15832.179988425592,6577.0728343525152,0,0,0,0,0]
[null,7032,"Bower Grove School",214,214,0,0,0,0,0,0,12040.230521537402,12057.357505664386,11585.854908918624,18094.925179882037,18112.052164009023,17407.676695788497,14437.009340766335,14453.257933192568,13895.870376919938,16062.784382292262,16079.911366419246,15453.695159644452,22766.345354989855,22783.472339116845,21899.426864161367,11585.854908918624,15285.913320165697,11627.119089349244,0,0,0,0,0,0,0,0,4093,0,0,2.1496,0,0,0.42857142857142855,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,9128.0078132573672,11438.023281258684,12995.848063983198,19441.579768500109,14949.829600127243,2457.8470956612564,0,0,0,0,0,9493.1281257876635,11889.394549857825,13515.681986542524,20219.24295924012,15547.822784132299,2557.0931364904786,0,0,0,0,0]
[null,7033,"St Anthony's School",98,98,0,0,0,0,0,0,14702.682906960303,14710.044505400849,14136.46733909785,20757.377565304938,20764.739163745486,19958.289125967727,17063.75998350804,17019.400234835051,16397.838953417253,18725.236767715163,18732.598366155711,18004.307589823675,25428.79774041276,25436.159338853307,24450.039294340586,14136.46733909785,15285.913320165697,11540.574391255264,0,0,0,0,0,0,0,0,3614,0,0,1.54,0,0,0.52631578947368418,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,9128.0078132573672,11389.379427576769,12995.848063983198,19441.579768500109,14949.829600127243,5008.4595258404806,0,0,0,0,0,9493.1281257876635,11824.034416519175,13515.681986542524,20219.24295924012,15547.822784132299,5213.8490469296257,0,0,0,0,0]
[null,7039,"The Ifield School",210,210,40,40,0,0,0,0,11838.716368851388,11864.507290093132,11468.429845010141,18631.679020298739,18657.469941540483,18000.124702171081,13827.043047236126,13852.833968477869,13380.282420380088,15861.270229606249,15887.061150847992,15336.27009573597,22564.831202303845,22590.622123545589,21782.001800252881,11468.429845010141,16024.181313268411,11219.545340205799,0,0,0,0,0,0,0,0,4274.1399960000008,0,0,6.22,34275.57,1,0.31606217616580312,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,6,9128.0078132573672,11039.860388627314,12995.848063983198,19441.579768500109,15659.702670418308,2340.4220317527725,0,0,0,0,0,9493.1281257876635,11481.454804172401,13515.681986542524,20219.24295924012,16286.090777235015,2360.6329471214094,0,0,0,0,0]
[null,7040,"Foreland Fields School",188,188,32,32,0,0,0,0,12015.473196255867,12016.945515943977,11659.582270781739,18808.435847703218,18809.908167391328,18181.543496830716,14003.799874640605,14005.272194328714,13561.70121503972,16038.027057010728,16039.499376698837,15517.688890395602,22741.588029708324,22743.060349396434,21963.420594912517,11659.582270781739,16024.181313268411,11219.545340205799,0,0,0,0,0,0,0,0,4331,0,0,4.3045,0,1,0.32748538011695905,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,10,9128.0078132573672,11039.860388627314,12995.848063983198,19441.579768500109,15659.702670418308,2521.8408264124064,9.7336311119652237,0,0,0,0,9493.1281257876635,11481.454804172401,13515.681986542524,20219.24295924012,16286.090777235015,2523.203923619601,0,0,0,0,0]
[null,7041,"Goldwyn Community Special School",150,150,0,0,0,0,0,0,13614.276399139428,13636.724970012458,14106.033266334074,19668.971057484065,19691.419628357093,19327.361277011521,18652.379062494088,18674.82763336712,18478.971979313614,17636.83025989429,17659.278830767318,17574.915801988664,24340.391232591883,24362.839803464914,23399.757422591709,14106.033266334074,15285.913320165697,14269.321325175722,0,0,0,0,0,0,0,0,5362.3800899999997,0,0,7.3492000000000006,0,0,0.41891891891891897,0,1,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,9128.0078132573672,13972.337297252259,12995.848063983198,19441.579768500109,14949.829600127243,3958.1776540915998,1019.8477989851053,548.45702796976911,620.89008391386596,0,419.35402279269692,9493.1281257876635,14531.230789142326,13515.681986542524,20219.24295924012,15547.822784132299,4134.2432730276996,478.66186751871101,0,0,0,0]
[null,7043,"The Beacon Folkestone",306,316,64,64,0,0,0,0,11235.777941712438,11214.070788383315,11771.354797812621,18028.74059315979,18007.033439830662,17927.535924227905,13224.104620097176,13202.397466768052,13531.597272240968,15258.331802467299,15236.624649138175,15381.765663732323,21961.892775164899,21940.185621835772,21541.768556102023,11771.354797812621,16024.181313268411,11219.545340205799,0,0,0,0,0,0,0,0,6634,0,0,0.92510000000000003,0,1,0.40370370370370373,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,10,9128.0078132573672,11039.860388627314,12995.848063983198,19441.579768500109,15659.702670418308,1697.3167126026451,946.0302719526062,794.4201710110101,688.60088714648009,402.87207499926808,570.51654120696912,9493.1281257876635,11481.454804172401,13515.681986542524,20219.24295924012,16286.090777235015,1729.987309816119,548.23936220883661,320.1551582524462,136.09636737367873,0,0]
[null,7044,"Rowhill School",110,110,0,0,0,0,0,0,14543.301515750787,14530.949327198599,13976.791275817654,20721.624266332357,20709.272077780173,19917.486228299967,17051.131194591588,16916.581750062662,16371.070247642343,18644.020590557102,18631.668402004914,17919.79038620834,25477.761582662126,25465.409394109938,24490.69518630932,13976.791275817654,15285.913320165697,11561.056713522743,160.72911205635509,216.52348321873635,238.89432610780946,369.07434551523806,284.35720429329268,0,0,0,4165,0,0,1.8948,0,0,0.54545454545454541,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,9282.5550363884795,11676.834008213169,13225.554146779166,19796.45894688015,15223.249988870793,4694.2362394291758,0,0,0,0,0,9653.8572378440185,12090.405184031722,13754.576312650333,20588.317304755357,15832.179988425592,4882.2388345846584,0,0,0,0,0]
[null,7045,"Elms School",158,158,0,0,0,0,0,0,12701.221294555482,12724.233897295209,13048.917283338349,18755.915952900119,18778.928555639846,18783.41174340518,15102.887575298791,15122.021240328686,15260.263829028696,16723.775155310344,16746.787758050072,16858.739930303291,23427.336128007941,23450.348730747664,23207.785659252448,13048.917283338349,15285.913320165697,11629.006004854538,0,0,0,0,0,0,0,0,2771,0,0,2.13,0,0,0.69178082191780821,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,9128.0078132573672,11407.464331588846,12995.848063983198,19441.579768500109,14949.829600127243,3517.3621824029215,403.54728767805864,335.4373150369338,345.5296839171715,248.84370834941365,316.2199608750343,9493.1281257876635,11892.531692866904,13515.681986542524,20219.24295924012,15547.822784132299,3221.5171870326603,334.27197051802432,146.21494912913113,121.54075672810359,0,14.071772240218706]
[null,7051,"Nexus School",186,200,14,28,0,0,0,0,12785.542418691486,12408.913799453521,12773.076948004318,19578.505070138835,19201.876450900872,19015.232386151456,14773.869097076222,14397.240477838259,14600.18020546855,16808.096279446345,16431.467660208382,16469.462125655875,23511.657252143941,23135.028632905978,22629.465018025578,12773.076948004318,16024.181313268411,11219.545340205799,0,0,0,0,0,0,0,0,6916,0,0,2.36,0,1,0.27152317880794702,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,8,9128.0078132573672,11039.860388627314,12995.848063983198,19441.579768500109,15659.702670418308,3099.5472650902339,545.52186965671717,460.77255175100436,374.06679658244502,88.33798443523483,255.98245064293224,9493.1281257876635,11481.454804172401,13515.681986542524,20219.24295924012,16286.090777235015,3072.714265015009,207.23455720164384,46.011136281140352,0,0,0]
[null,7052,"Grange Park School",107,100,50,50,0,0,0,0,12401.430228928621,12519.836482561092,12861.065092592298,19194.39288037597,19312.799134008441,19294.784526895826,14389.756907313358,14508.163160945831,14744.239879331693,16423.984089683483,16542.390343315954,16670.887739557238,23127.545062381076,23245.95131601355,23019.933468506402,12861.065092592298,16024.181313268411,11219.545340205799,0,0,0,0,0,0,0,0,1958.53,0,0,1.1245000000000001,0,0,0.26436781609195403,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,9128.0078132573672,11039.860388627314,12995.848063983198,19441.579768500109,15659.702670418308,3268.0871393718267,464.97013996310488,436.29235133255861,406.95253620221592,310.26656063446717,366.99471710570651,9493.1281257876635,11481.454804172401,13515.681986542524,20219.24295924012,16286.090777235015,2977.3724177598997,390.56454904473503,285.41265739939263,177.8333352548143,0,31.321331900915538]
[null,7056,"Five Acre Wood School",412,420,58,50,0,0,0,0,11047.281800508434,11058.37432387292,11254.39,17840.244451955787,17851.336975320271,17351.224914634517,13035.608478893171,13046.701002257658,12850.299941996043,15069.835661263294,15080.928184627781,14727.328127295936,21773.396633960892,21784.489157325377,21081.403463718088,11254.39,16024.181313268411,11219.545340205799,0,0,0,0,0,0,0,0,7768.4,0,0,2.6381999999999999,9259,1,0.28037383177570091,0,1,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,15,9128.0078132573672,11039.860388627314,12995.848063983198,19441.579768500109,15659.702670418308,1639.8236952179807,486.56236375566914,170.61585815075159,91.656368094758363,0,51.698548998243496,9493.1281257876635,11481.454804172401,13515.681986542524,20219.24295924012,16286.090777235015,1560.6243133500543,200.63756086228022,0,0,0,0]
[null,7058,"Stone Bay School",45,65,15,15,18,18,0,0,17203.619180310343,15353.714598497854,16536.410515039832,30640.993769682107,28791.08918786962,29456.963004820343,19191.945858695079,17342.041276882592,18448.263090409779,21226.173041065202,19376.268459252715,20404.250765765661,27929.734013762798,26079.829431950311,26849.982470282572,16536.410515039832,22668.593251192826,11219.545340205799,0,0,0,0,0,0,0,0,2396.216342490492,1481.783657509508,0,0.96,0,1,0.38461538461538469,0,0,0,77173.947146553968,73200.551442092998,75324.042564741481,74462.687390634659,70593.570907555215,72612.782808822172,0,0,0,31395.550869041916,0,0,0,0,0,0,9128.0078132573672,11039.860388627314,12995.848063983198,19441.579768500109,22048.560303037877,7408.4027017824683,0,0,0,0,0,9493.1281257876635,11481.454804172401,13515.681986542524,20219.24295924012,22930.502715159429,6631.3800484653948,411.90234078677349,335.42823777198282,257.18873075774172,0,0]
[null,7062,"The Orchard School",83,83,0,0,0,0,0,0,15167.949947900481,15174.184170122702,14582.402759237495,21222.644606245114,21228.878828467339,20404.224546107369,17467.812882814411,17457.322527054534,16793.809427423967,19190.50380865534,19196.738030877565,18450.243009963324,25894.064781352936,25900.299003575157,24895.974714480239,14582.402759237495,15285.913320165697,11514.357018752893,0,0,0,0,0,0,0,0,2505,0,0,1.81,0,0,0.47,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,9128.0078132573672,11339.41448144384,12995.848063983198,19441.579768500109,14949.829600127243,5454.3949459801297,0,0,0,0,0,9493.1281257876635,11783.235056878704,13515.681986542524,20219.24295924012,15547.822784132299,5678.4584517424464,0,0,0,0,0]
[null,7063,"St Nicholas' School",229,249,43,43,0,0,0,0,11935.441108968571,11788.4269438503,11570.651659297369,18728.40376041592,18581.389595297649,18097.807191540476,13923.76778735331,13776.753622235039,13477.964909749488,15957.994969723433,15810.980804605162,15433.95258510537,22661.55594242103,22514.541777302758,21879.684289622281,11570.651659297369,16024.181313268411,11219.545340205799,0,0,0,0,0,0,0,0,3971.7700100000002,0,0,0.93049999999999999,77747,1,0.34334763948497854,0,1,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,6,9128.0078132573672,11039.860388627314,12995.848063983198,19441.579768500109,15659.702670418308,2438.1045211221735,4.5393249178287078,0,0,0,0,9493.1281257876635,11481.454804172401,13515.681986542524,20219.24295924012,16286.090777235015,2356.5547201952509,0,0,0,0,0]
[null,7066,"Milestone School",275,285,55,55,0,0,0,0,11982.641828901696,11934.538526853783,11515.826978911888,18912.966251309706,18864.862949261795,18179.600461996546,14018.951722688715,13970.848420640799,13473.81726139941,16083.360903708011,16035.257601660098,15458.826089302576,22917.101895813033,22868.998593765118,22029.730889403556,11515.826978911888,16024.181313268411,11219.545340205799,160.72911205635498,208.71232745863608,238.89432610780935,369.07434551523801,298.09088301702064,0,0,0,7254,0,0,4.6955,0,1,0.27472527472527475,1,0,3,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,12,9282.5550363884795,11240.545318876004,13225.554146779166,19796.45894688015,15946.328519473136,2233.2719425234081,0,0,0,0,0,9653.8572378440185,11690.167131631037,13754.576312650333,20588.317304755357,16584.181660252034,2300.7243315297274,0,0,0,0,0]
[null,7067,"Portal House School",80,80,0,0,0,0,0,0,15488.366735898097,15795.956248716855,16589.670146186658,21543.06139424273,21850.650907061492,22324.164606253482,20526.469399252757,20834.058912071516,21361.334687921626,19510.920596652955,19818.510109471717,20399.492793151596,26214.481569350555,26522.071082169314,26748.53852210076,16589.670146186658,15285.913320165697,14269.321325175722,0,0,0,0,0,0,0,0,3816,0,0,0.81,0,0,0.28169014084507044,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,9128.0078132573672,13972.337297252259,12995.848063983198,19441.579768500109,14949.829600127243,6571.2613353055067,890.40099762378304,817.73605536387549,832.3833938628959,735.69741829514533,803.07367082075143,9493.1281257876635,14531.230789142326,13515.681986542524,20219.24295924012,15547.822784132299,6174.6658259213764,921.8761944776179,655.43807285792718,709.14498068769535,354.62973693926324,601.67599619980683]
[null,7069,"The Wyvern School",235,255,35,35,0,0,0,0,11763.731522635966,11642.100437668865,11422.558325059606,18556.694174083314,18435.063089116218,17906.130570580688,13752.058201020704,13630.427116053603,13305.733111799003,15786.285383390827,15664.654298423726,15242.27596414558,22489.846356088423,22368.215271121324,21688.007668662493,11422.558325059606,16024.181313268411,11219.545340205799,0,0,0,0,0,0,0,0,6156,0,0,7.6,0,1,0.30769230769230771,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,5,9128.0078132573672,11039.860388627314,12995.848063983198,19441.579768500109,15659.702670418308,2246.4279001623822,48.122611639857496,19.444823009307584,0,0,0,9493.1281257876635,11481.454804172401,13515.681986542524,20219.24295924012,16286.090777235015,2199.6519306174946,0,0,0,0,0]
[null,7070,"Oakley School",158,200,42,52,0,0,0,0,12403.75449405361,11851.179131546269,11957.73823785931,19196.717145500956,18644.141782993622,18489.433095020249,14392.081172438347,13839.505809931006,13869.590813229255,16426.308354808469,15873.732992301129,15825.578488585139,23129.869327506065,22577.293964998727,22271.31019310205,11957.73823785931,16024.181313268411,11219.545340205799,0,0,0,0,0,0,0,0,4287,0,0,11.4161,0,0,0.30769230769230771,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,12,9128.0078132573672,11039.860388627314,12995.848063983198,19441.579768500109,15659.702670418308,2829.7304246019426,0,0,0,0,0,9493.1281257876635,11481.454804172401,13515.681986542524,20219.24295924012,16286.090777235015,2588.2907401366647,0,0,0,0,0]
[null,7072,"Meadowfield School",270,298,50,50,0,0,0,0,11506.397522810614,11359.382361313046,11343.153043037895,18299.360174257963,18152.345012760397,17776.872477341418,13494.724201195351,13347.709039697784,13226.327829777292,15528.951383565474,15381.936222067907,15152.975690002835,22232.512356263069,22085.497194765503,21519.874196322868,11343.153043037895,16024.181313268411,11219.545340205799,0,0,0,0,0,0,0,0,6963,0,0,2.3725999999999998,0,1,0.30165289256198347,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,6,9128.0078132573672,11039.860388627314,12995.848063983198,19441.579768500109,15659.702670418308,2078.294427822761,136.85080195776573,108.17301332722127,78.833198196878584,0,38.875379100365535,9493.1281257876635,11481.454804172401,13515.681986542524,20219.24295924012,16286.090777235015,1927.5105528160357,0,0,0,0,0]
[null,7073,"Laleham Gap School",196,196,0,0,4,0,0,0,12229.077231517058,12372.81984244824,11749.794503290355,19022.039882964407,19165.782493895589,18271.738406831137,14217.403909901795,14361.146520832977,13651.896125040159,16251.631092271919,16395.373703203099,15607.883800396045,22955.192064969517,23098.934675900698,22053.615504912956,11749.794503290355,16024.181313268411,11219.545340205799,0,0,0,0,0,0,0,0,5300.09,433,0,2.5697000000000001,0,0,0.25641025641025639,0,0,0,88931.864057354891,81636.998150362386,0,92865.016239360004,85418.875248444208,0,0,0,0,0,0,0,0,0,0,0,9128.0078132573672,11039.860388627314,12995.848063983198,19441.579768500109,15659.702670418308,2612.0357364128477,9.7509536201396259,0,0,0,0,9493.1281257876635,11481.454804172401,13515.681986542524,20219.24295924012,16286.090777235015,2819.7989621059173,0,0,0,0,0]