{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Special Rates 2019-20","Nursery Lump Sums","newdatacalc"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":24,"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 2019-20","index":0,"n_rows":96,"n_cols":28,"rows_kept":96,"cut":false,"hidden":false,"merged":[[95,6,95,12],[37,6,37,8],[38,6,38,8],[39,6,39,8],[40,6,40,8],[42,6,42,8],[43,6,43,8],[44,6,44,8],[46,9,46,13],[48,1,48,8],[50,1,50,8],[49,1,49,8],[95,1,95,4],[51,1,51,8],[90,1,90,8],[94,1,94,4],[68,1,68,4],[52,1,52,8],[53,1,53,8],[54,1,54,8],[55,1,55,8],[56,1,56,8],[57,1,57,8],[75,1,75,4],[76,1,76,4],[77,1,77,4],[78,1,78,4],[79,1,79,4],[94,6,94,9],[22,23,22,27],[88,16,88,20],[88,23,88,27],[66,16,66,20],[46,16,46,20],[46,23,46,27],[66,23,66,27],[7,4,7,10],[30,1,30,6],[4,16,12,20],[33,1,33,6],[22,9,22,13],[22,16,22,20],[12,7,19,10],[26,1,26,7],[28,1,28,7],[1,15,2,19],[80,1,80,4],[81,1,81,4],[82,1,82,4],[88,9,88,13],[74,1,74,4],[58,1,58,8],[59,1,59,8],[60,1,60,8],[61,1,61,8],[69,1,69,4],[70,1,70,4],[71,1,71,4],[72,1,72,4],[73,1,73,4],[66,9,66,13]]}
[]
[]
[]
[null,null,null,null,"2019/20 Calculation of Special School Funding Rates"]
[]
[]
[]
[null,"DfE",null,null,{"$f":"IFERROR(VLOOKUP(DFENUM,newdatacalc!$A$33:$BJ$55,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 2018-19 agreed November 2017\n\n\nPlace numbers 2019-20 agreed November 2018"]
[]
[null,"2018/19",{"$f":"IFERROR(VLOOKUP(DFENUM,newdatacalc!$A$33:$BO$55,66,0),0)","v":0},{"$f":"IFERROR(VLOOKUP(DFENUM,newdatacalc!$A$33:$BO$55,67,0),0)","v":0},{"$f":"IFERROR(VLOOKUP(DFENUM,newdatacalc!$A$33:$BO$55,64,0),0)","v":0},{"$f":"IFERROR(VLOOKUP(DFENUM,newdatacalc!$A$33:$BO$55,65,0),0)","v":0}]
[]
[null,"2019/20",{"$f":"IFERROR(VLOOKUP(DFENUM,newdatacalc!$A$33:$BO$55,61,0),0)","v":0},{"$f":"IFERROR(VLOOKUP(DFENUM,newdatacalc!$A$33:$BO$55,62,0),0)","v":0},{"$f":"IFERROR(VLOOKUP(DFENUM,newdatacalc!$A$33:$BO$55,59,0),0)","v":0},{"$f":"IFERROR(VLOOKUP(DFENUM,newdatacalc!$A$33:$BO$55,60,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,null,"Weekday",null,null,null,null,null,null,"Weekend"]
[null,"Section 2 - Calculation of funding rate for April 2019 to March 2020"]
[null,null,null,null,null,null,null,null,null,"MLD & SLCN","BESD","SLD","PD & PMLD","ASD",null,null,"MLD & SLCN","BESD","SLD","PD & PMLD","ASD",null,null,"MLD & SLCN","BESD","SLD","PD & PMLD","ASD"]
[]
["(A)","April 2019 to August 2019 (Formula only excluding MFG)- based on  Academic Year 2018 to 2019. Data taken from 2018-19 Funding Rates Calculation.",null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP('Special Rates 2019-20'!DFENUM,newdatacalc!$A$33:$BT$55,23,0),0)","v":0},{"$f":"IFERROR(VLOOKUP('Special Rates 2019-20'!DFENUM,newdatacalc!$A$33:$BT$55,24,0),0)","v":0},{"$f":"IFERROR(VLOOKUP('Special Rates 2019-20'!DFENUM,newdatacalc!$A$33:$BT$55,25,0),0)","v":0},{"$f":"IFERROR(VLOOKUP('Special Rates 2019-20'!DFENUM,newdatacalc!$A$33:$BT$55,26,0),0)","v":0},{"$f":"IFERROR(VLOOKUP('Special Rates 2019-20'!DFENUM,newdatacalc!$A$33:$BT$55,27,0),0)","v":0},null,null,{"$f":"VLOOKUP('Special Rates 2019-20'!DFENUM,newdatacalc!$A$33:$AK$55,28,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP('Special Rates 2019-20'!DFENUM,newdatacalc!$A$33:$AK$55,29,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP('Special Rates 2019-20'!DFENUM,newdatacalc!$A$33:$AK$55,30,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP('Special Rates 2019-20'!DFENUM,newdatacalc!$A$33:$AK$55,31,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP('Special Rates 2019-20'!DFENUM,newdatacalc!$A$33:$AK$55,32,0)","v":{"$error":"#N/A"}},null,null,{"$f":"VLOOKUP('Special Rates 2019-20'!DFENUM,newdatacalc!$A$33:$AK$55,33,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP('Special Rates 2019-20'!DFENUM,newdatacalc!$A$33:$AK$55,34,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP('Special Rates 2019-20'!DFENUM,newdatacalc!$A$33:$AK$55,35,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP('Special Rates 2019-20'!DFENUM,newdatacalc!$A$33:$AK$55,36,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP('Special Rates 2019-20'!DFENUM,newdatacalc!$A$33:$AK$55,37,0)","v":{"$error":"#N/A"}}]
[]
["(B)","September 2019 to March 2020 (Formula only excluding MFG)- based on  Academic Year 2019 to 2020. See section 3 for calculation.",null,null,null,null,null,null,null,{"$f":"J91","v":9128.0078132573672},{"$f":"K91","v":11039.860388627309},{"$f":"L91","v":12995.848063983196},19441.579768500109,14949.829600127208,null,null,{"$f":"Q91","v":{"$error":"#N/A"}},{"$f":"R91","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,null,{"$f":"X91","v":{"$error":"#N/A"}},{"$f":"Y91","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[]
["(C)","April 2019 to March 2020 - based on Academic Year 2018 to 2019 (April 2019 to August 2019) 5/12's + Academic Year 2019 to 2020 (September 2019 to March 2020) 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":5324.671224400131},{"$f":"(K27*5/12)+(K29*7/12)","v":6439.9185600325973},{"$f":"(L27*5/12)+(L29*7/12)","v":7580.9113706568642},{"$f":"(M27*5/12)+(M29*7/12)","v":11340.921531625063},{"$f":"(N27*5/12)+(N29*7/12)","v":8720.7339334075386},null,null,{"$f":"(Q27*5/12)+(Q29*7/12)","v":{"$error":"#N/A"}},{"$f":"(R27*5/12)+(R29*7/12)","v":{"$error":"#N/A"}},{"$f":"(S27*5/12)+(S29*7/12)","v":{"$error":"#N/A"}},{"$f":"(T27*5/12)+(T29*7/12)","v":{"$error":"#N/A"}},{"$f":"(U27*5/12)+(U29*7/12)","v":{"$error":"#N/A"}},null,null,{"$f":"(X27*5/12)+(X29*7/12)","v":{"$error":"#N/A"}},{"$f":"(Y27*5/12)+(Y29*7/12)","v":{"$error":"#N/A"}},{"$f":"(Z27*5/12)+(Z29*7/12)","v":{"$error":"#N/A"}},{"$f":"(AA27*5/12)+(AA29*7/12)","v":{"$error":"#N/A"}},{"$f":"(AB27*5/12)+(AB29*7/12)","v":{"$error":"#N/A"}}]
[]
["(D-input)","Final funding rate for financial Year 2018 to 2019",null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP('Special Rates 2019-20'!DFENUM,newdatacalc!$A$33:$BT$55,40,0),0)","v":0},{"$f":"IFERROR(VLOOKUP('Special Rates 2019-20'!DFENUM,newdatacalc!$A$33:$BT$55,41,0),0)","v":0},{"$f":"IFERROR(VLOOKUP('Special Rates 2019-20'!DFENUM,newdatacalc!$A$33:$BT$55,42,0),0)","v":0},{"$f":"IFERROR(VLOOKUP('Special Rates 2019-20'!DFENUM,newdatacalc!$A$33:$BT$55,43,0),0)","v":0},{"$f":"IFERROR(VLOOKUP('Special Rates 2019-20'!DFENUM,newdatacalc!$A$33:$BT$55,44,0),0)","v":0},null,null,{"$f":"VLOOKUP('Special Rates 2019-20'!DFENUM,newdatacalc!$A$33:$BT$55,45,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP('Special Rates 2019-20'!DFENUM,newdatacalc!$A$33:$BT$55,46,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP('Special Rates 2019-20'!DFENUM,newdatacalc!$A$33:$BT$55,47,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP('Special Rates 2019-20'!DFENUM,newdatacalc!$A$33:$BT$55,48,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP('Special Rates 2019-20'!DFENUM,newdatacalc!$A$33:$BT$55,49,0)","v":{"$error":"#N/A"}},null,null,{"$f":"VLOOKUP('Special Rates 2019-20'!DFENUM,newdatacalc!$A$33:$BD$55,50,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP('Special Rates 2019-20'!DFENUM,newdatacalc!$A$33:$BD$55,51,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP('Special Rates 2019-20'!DFENUM,newdatacalc!$A$33:$BD$55,52,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP('Special Rates 2019-20'!DFENUM,newdatacalc!$A$33:$BD$55,53,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP('Special Rates 2019-20'!DFENUM,newdatacalc!$A$33:$BD$55,54,0)","v":{"$error":"#N/A"}}]
["(D)","MFG rate (D-input) X 98.5%",null,null,null,null,null,null,null,{"$f":"J33*0.985","v":0},{"$f":"K33*0.985","v":0},0,0,{"$f":"N33*0.985","v":0},null,null,{"$f":"Q33*0.985","v":{"$error":"#N/A"}},{"$f":"R33*0.985","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"U33*0.985","v":{"$error":"#N/A"}},null,null,{"$f":"X33*0.985","v":{"$error":"#N/A"}},{"$f":"Y33*0.985","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[]
[]
[null,null,null,null,null,null,null,null,null,"MLD & SLCN","BESD","SLD","PD & PMLD","ASD",null,null,"MLD & SLCN","BESD","SLD","PD & PMLD","ASD",null,null,"MLD & SLCN","BESD","SLD","PD & PMLD","ASD"]
["(E)","Final Rate (Greater of Formula (C) or MFG (D))",null,null,null,null,"Formula (C)",null,null,{"$f":"J31","v":5324.671224400131},{"$f":"K31","v":6439.9185600325973},{"$f":"L31","v":7580.9113706568642},{"$f":"M31","v":11340.921531625063},{"$f":"N31","v":8720.7339334075386},null,"Formula",{"$f":"Q31","v":{"$error":"#N/A"}},{"$f":"R31","v":{"$error":"#N/A"}},{"$f":"S31","v":{"$error":"#N/A"}},{"$f":"T31","v":{"$error":"#N/A"}},{"$f":"U31","v":{"$error":"#N/A"}},null,"Formula",{"$f":"X31","v":{"$error":"#N/A"}},{"$f":"Y31","v":{"$error":"#N/A"}},{"$f":"Z31","v":{"$error":"#N/A"}},{"$f":"AA31","v":{"$error":"#N/A"}},{"$f":"AB31","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,"MFG funding rate (D)",null,null,{"$f":"J34","v":0},{"$f":"K34","v":0},0,0,0,null,"MFG",{"$f":"Q34","v":{"$error":"#N/A"}},{"$f":"R34","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,"MFG",{"$f":"X34","v":{"$error":"#N/A"}},{"$f":"Y34","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,null,null,"Amount of MFG if (D) 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,"Amount of MFG if (D) is greater than ( C)",{"$f":"IF(Q38>Q39,0,Q39-Q38)","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,"Amount of MFG if (D) is greater than ( C)",{"$f":"IF(X38>X39,0,X39-X38)","v":{"$error":"#N/A"}},{"$f":"IF(Y38>Y39,0,Y39-Y38)","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,null,null,"Final Rate formula plus MFG",null,null,{"$f":"SUM(J38,J40)","v":5324.671224400131},{"$f":"SUM(K38,K40)","v":6439.9185600325973},7580.9113706568642,11340.921531625063,8720.7339334075386,null,"Final Rate",{"$f":"SUM(Q38,Q40)","v":{"$error":"#N/A"}},{"$f":"SUM(R38,R40)","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,"Final Rate",{"$f":"SUM(X38,X40)","v":{"$error":"#N/A"}},{"$f":"SUM(Y38,Y40)","v":{"$error":"#N/A"}},{"$f":"SUM(Z38,Z40)","v":{"$error":"#N/A"}},{"$f":"SUM(AA38,AA40)","v":{"$error":"#N/A"}},{"$f":"SUM(AB38,AB40)","v":{"$error":"#N/A"}}]
["(F)","Place Plus Breakdown"]
[null,null,null,null,null,null,"Element 1 & 2",null,null,10000,10000,10000,10000,10000,null,"Element 1 & 2",{"$f":"IF($F$81=0,0,10000)","v":{"$error":"#N/A"}},{"$f":"IF($F$81=0,0,10000)","v":{"$error":"#N/A"}},{"$f":"IF($F$81=0,0,10000)","v":{"$error":"#N/A"}},{"$f":"IF($F$81=0,0,10000)","v":{"$error":"#N/A"}},{"$f":"IF($F$81=0,0,10000)","v":{"$error":"#N/A"}},null,"Element 1 & 2",{"$f":"IF($F$17=0,0,10000)","v":0},{"$f":"IF($F$17=0,0,10000)","v":0},0,0,0]
[null,null,null,null,null,null,"Element 3",null,null,{"$f":"J41-J43","v":-4675.328775599869},{"$f":"K41-K43","v":-3560.0814399674027},-2419.0886293431358,1340.9215316250629,-1279.2660665924614,null,"Element 3",{"$f":"Q41-Q43","v":{"$error":"#N/A"}},{"$f":"R41-R43","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,"Element 3",{"$f":"X41-X43","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,null,null,"Total rate",null,null,{"$f":"SUM(J43:J44)","v":5324.671224400131},{"$f":"SUM(K43:K44)","v":6439.9185600325973},7580.9113706568642,11340.921531625063,8720.7339334075386,null,"Total rate",{"$f":"SUM(Q43:Q44)","v":{"$error":"#N/A"}},{"$f":"SUM(R43:R44)","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,"Total rate",{"$f":"SUM(X43:X44)","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,"Section 3 - Pupil Led Elements"]
[null,null,null,null,null,null,null,null,null,"Need Type",null,null,null,null,null,null,"Need Type",null,null,null,null,null,null,"Need Type"]
[null,null,null,null,null,null,null,null,null,"MLD & SLCN","BESD","SLD","PD & PMLD","ASD",null,null,"MLD & SLCN","BESD","SLD","PD & PMLD","ASD",null,null,"MLD & SLCN","BESD","SLD","PD & PMLD","ASD"]
[null,"Day Rate",null,null,null,null,null,null,null,8876.1717902125583,10788.0243655825,12744.012040938387,19189.743745455304,14697.993577082399,null,null,{"$f":"IF($F$81=0,0,8876.17179021256)","v":{"$error":"#N/A"}},{"$f":"IF($F$81=0,0,10788.0243655825)","v":{"$error":"#N/A"}},{"$f":"IF($F$81=0,0,12744.0120409384)","v":{"$error":"#N/A"}},{"$f":"IF($F$81=0,0,19189.7437454553)","v":{"$error":"#N/A"}},{"$f":"IF($F$81=0,0,14697.9935770824)","v":{"$error":"#N/A"}},null,null,{"$f":"IF($F$17=0,0,8876.17179021256)","v":0},{"$f":"IF($F$17=0,0,10788.0243655825)","v":0},{"$f":"IF($F$17=0,0,12744.0120409384)","v":0},{"$f":"IF($F$17=0,0,19189.7437454553)","v":0},{"$f":"IF($F$17=0,0,14697.9935770824)","v":0}]
[null,"Adjusted Rate due to School type (see note 1)",null,null,null,null,null,null,null,0,{"$f":"IFERROR(((VLOOKUP(DFENUM,newdatacalc!A5:G27,7,0)*newdatacalc!G4)+(VLOOKUP(DFENUM,newdatacalc!A5:G27,6,0)*newdatacalc!F4))-K49,0)","v":0},0,0,{"$f":"IFERROR(((VLOOKUP(DFENUM,newdatacalc!A5:E27,5,0)*newdatacalc!E4)+(VLOOKUP(DFENUM,newdatacalc!A5:E27,4,0)*newdatacalc!D4))-N49,0)","v":0},null,null,0,{"$f":"IF($F$81=0,0,K50)","v":{"$error":"#N/A"}},0,0,{"$f":"IF($F$81=0,0,N50)","v":{"$error":"#N/A"}},null,null,0,{"$f":"IF($F$17=0,0,K50)","v":0},0,0,{"$f":"IF($F$17=0,0,N50)","v":0}]
[null,"Residential Weekday rate",null,null,null,null,null,null,null,0,0,0,0,0,null,null,{"$f":"VLOOKUP(DFENUM,newdatacalc!$A$33:$BT$55,69,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(DFENUM,newdatacalc!$A$33:$BT$55,69,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(DFENUM,newdatacalc!$A$33:$BT$55,69,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(DFENUM,newdatacalc!$A$33:$BT$55,69,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(DFENUM,newdatacalc!$A$33:$BT$55,69,0)","v":{"$error":"#N/A"}},null,null,{"$f":"IF($F$17=0,0,VLOOKUP(DFENUM,newdatacalc!$A$33:$BT$55,69,0))","v":0},{"$f":"IF($F$17=0,0,VLOOKUP(DFENUM,newdatacalc!$A$33:$BT$55,69,0))","v":0},{"$f":"IF($F$17=0,0,VLOOKUP(DFENUM,newdatacalc!$A$33:$BT$55,69,0))","v":0},{"$f":"IF($F$17=0,0,VLOOKUP(DFENUM,newdatacalc!$A$33:$BT$55,69,0))","v":0},{"$f":"IF($F$17=0,0,VLOOKUP(DFENUM,newdatacalc!$A$33:$BT$55,69,0))","v":0}]
[null,"Residential Weekend rate",null,null,null,null,null,null,null,0,0,0,0,0,null,null,0,0,0,0,0,null,null,{"$f":"VLOOKUP(DFENUM,newdatacalc!$A$33:$BT$55,70,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(DFENUM,newdatacalc!$A$33:$BT$55,70,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(DFENUM,newdatacalc!$A$33:$BT$55,70,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(DFENUM,newdatacalc!$A$33:$BT$55,70,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(DFENUM,newdatacalc!$A$33:$BT$55,70,0)","v":{"$error":"#N/A"}}]
[null,"Subsidy on day places (catering)",null,null,null,null,null,null,null,105.99999999999999,105.99999999999999,105.99999999999999,105.99999999999999,105.99999999999999,null,null,{"$f":"IF($F$81=0,0,106)","v":{"$error":"#N/A"}},{"$f":"Q53","v":{"$error":"#N/A"}},{"$f":"R53","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},null,null,{"$f":"IF(F$17=0,0,106)","v":0},{"$f":"X53","v":0},0,0,0]
[null,"Lunch Grant",null,null,null,null,null,null,null,11.000000000000002,11.000000000000002,11.000000000000002,11.000000000000002,11.000000000000002,null,null,{"$f":"IF($F$81=0,0,11)","v":{"$error":"#N/A"}},{"$f":"Q54","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,null,{"$f":"IF(F$17=0,0,11)","v":0},0,0,0,0]
[null,"Specialist Schools Funding",null,null,null,null,null,null,null,91.280909724829698,91.280909724829698,91.280909724829698,91.280909724829698,91.280909724829698,null,null,{"$f":"IF($F$81=0,0,91.2809097248297)","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,null,{"$f":"IF(F$17=0,0,91.2809097248297)","v":0},0,0,0,0]
[null,"Further Delegation",null,null,null,null,null,null,null,42.062510871868518,42.062510871868518,42.062510871868518,42.062510871868518,42.062510871868518,null,null,{"$f":"IF($F$81=0,0,42.0625108718685)","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,null,{"$f":"IF(F$17=0,0,42.0625108718685)","v":0},0,0,0,0]
[null,"Induction for Newly Qualified Teachers",null,null,null,null,null,null,null,1.4926024481106972,1.4926024481106972,1.4926024481106972,1.4926024481106972,1.4926024481106972,null,null,{"$f":"IF($F$81=0,0,1.4926024481107)","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,null,{"$f":"IF(F$17=0,0,1.4926024481107)","v":0},0,0,0,0]
[null,"Residential Weekday Places Catering",null,null,null,null,null,null,null,0,0,0,0,0,null,null,{"$f":"VLOOKUP(DFENUM,newdatacalc!$A$33:$BT$55,71,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(DFENUM,newdatacalc!$A$33:$BT$55,71,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(DFENUM,newdatacalc!$A$33:$BT$55,71,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(DFENUM,newdatacalc!$A$33:$BT$55,71,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(DFENUM,newdatacalc!$A$33:$BT$55,71,0)","v":{"$error":"#N/A"}},null,null,0,0,0,0,0]
[null,"Residential Weekend Places Catering",null,null,null,null,null,null,null,0,0,0,0,0,null,null,0,0,0,0,0,null,null,{"$f":"VLOOKUP(DFENUM,newdatacalc!$A$33:$BT$55,72,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(DFENUM,newdatacalc!$A$33:$BT$55,72,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(DFENUM,newdatacalc!$A$33:$BT$55,72,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(DFENUM,newdatacalc!$A$33:$BT$55,72,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(DFENUM,newdatacalc!$A$33:$BT$55,72,0)","v":{"$error":"#N/A"}}]
[null,"London Fringe Day Pupil",null,null,null,null,null,null,null,{"$f":"IFERROR(IF(LONDAY>0,0.0174114727366503*J49,0)*(IF(DFENUM=7002,(50/164),1)),0)","v":0},{"$f":"IFERROR(IF(LONDAY>0,0.0186025655345146*(K49+K50),0)*(IF(DFENUM=7002,(50/164),1)),0)","v":0},{"$f":"IFERROR(IF(LONDAY>0,0.0180246285124395*L49,0)*(IF(DFENUM=7002,(50/164),1)),0)","v":0},{"$f":"IFERROR(IF(LONDAY>0,0.0184931692203593*M49,0)*(IF(DFENUM=7002,(50/164),1)),0)","v":0},{"$f":"IFERROR(IF(LONDAY>0,0.0186025655345146*(N49+N50),0)*(IF(DFENUM=7002,(50/164),1)),0)","v":0},null,null,{"$f":"IF(VLOOKUP('Special Rates 2019-20'!DFENUM,newdatacalc!$A$33:$AK$55,19,0)>0,0.0174114727366503*Q49*(IF(DFENUM=7002,(164/164),1)),0)","v":{"$error":"#N/A"}},{"$f":"IF(VLOOKUP('Special Rates 2019-20'!DFENUM,newdatacalc!$A$33:$AK$55,19,0)>0,0.0186025655345146*R49*(IF(DFENUM=7002,(164/164),1)),0)","v":{"$error":"#N/A"}},{"$f":"IF(VLOOKUP('Special Rates 2019-20'!DFENUM,newdatacalc!$A$33:$AK$55,19,0)>0,0.0180246285124395*S49*(IF(DFENUM=7002,(164/164),1)),0)","v":{"$error":"#N/A"}},{"$f":"IF(VLOOKUP('Special Rates 2019-20'!DFENUM,newdatacalc!$A$33:$AK$55,19,0)>0,0.0184931692203593*T49*(IF(DFENUM=7002,(164/164),1)),0)","v":{"$error":"#N/A"}},{"$f":"IF(VLOOKUP('Special Rates 2019-20'!DFENUM,newdatacalc!$A$33:$AK$55,19,0)>0,0.0186025655345146*(U49+U50)*(IF(DFENUM=7002,(164/164),1)),0)","v":{"$error":"#N/A"}},null,null,{"$f":"IF(LONRES>0,0.0174114727366503*X49,0)","v":{"$error":"#N/A"}},{"$f":"IF(LONRES>0,0.0186025655345146*Y49,0)","v":{"$error":"#N/A"}},{"$f":"IF(LONRES>0,0.0180246285124395*Z49,0)","v":{"$error":"#N/A"}},{"$f":"IF(LONRES>0,0.0184931692203593*AA49,0)","v":{"$error":"#N/A"}},{"$f":"IF(LONRES>0,0.0186025655345146*AB49,0)","v":{"$error":"#N/A"}}]
[null,"London Fringe Weekday Residential Pupil",null,null,null,null,null,null,null,{"$f":"IFERROR(IF(LONRES>0,0.0198836550802172*J51,0),0)","v":0},{"$f":"IFERROR(IF(LONRES>0,0.0198836550802172*K51,0),0)","v":0},{"$f":"IFERROR(IF(LONRES>0,0.0198836550802172*L51,0),0)","v":0},{"$f":"IFERROR(IF(LONRES>0,0.0198836550802172*M51,0),0)","v":0},{"$f":"IFERROR(IF(LONRES>0,0.0198836550802172*N51,0),0)","v":0},null,null,{"$f":"IF(LONRES>0,0.0198836550802172*Q51*(IF(DFENUM=7002,(164/164),1)),0)","v":{"$error":"#N/A"}},{"$f":"IF(LONRES>0,0.0198836550802172*R51*(IF(DFENUM=7002,(164/164),1)),0)","v":{"$error":"#N/A"}},{"$f":"IF(LONRES>0,0.0198836550802172*S51*(IF(DFENUM=7002,(164/164),1)),0)","v":{"$error":"#N/A"}},{"$f":"IF(LONRES>0,0.0198836550802172*T51*(IF(DFENUM=7002,(164/164),1)),0)","v":{"$error":"#N/A"}},{"$f":"IF(LONRES>0,0.0198836550802172*U51*(IF(DFENUM=7002,(164/164),1)),0)","v":{"$error":"#N/A"}},null,null,{"$f":"IF(LONRES>0,0.0198836550802172*X51,0)","v":{"$error":"#N/A"}},{"$f":"IF(LONRES>0,0.0198836550802172*Y51,0)","v":{"$error":"#N/A"}},{"$f":"IF(LONRES>0,0.0198836550802172*Z51,0)","v":{"$error":"#N/A"}},{"$f":"IF(LONRES>0,0.0198836550802172*AA51,0)","v":{"$error":"#N/A"}},{"$f":"IF(LONRES>0,0.0198836550802172*AB51,0)","v":{"$error":"#N/A"}}]
[null,"London Fringe Weekend Residential Pupil",null,null,null,null,null,null,null,{"$f":"IFERROR(IF(LONRES>0,0.0198224953157972*J52,0),0)","v":0},{"$f":"IFERROR(IF(LONRES>0,0.0198224953157972*K52,0),0)","v":0},{"$f":"IFERROR(IF(LONRES>0,0.0198224953157972*L52,0),0)","v":0},{"$f":"IFERROR(IF(LONRES>0,0.0198224953157972*M52,0),0)","v":0},{"$f":"IFERROR(IF(LONRES>0,0.0198224953157972*N52,0),0)","v":0},null,null,0,0,0,0,0,null,null,{"$f":"IF(LONRES>0,0.0198224953157972*X52,0)","v":{"$error":"#N/A"}},{"$f":"IF(LONRES>0,0.0198224953157972*Y52,0)","v":{"$error":"#N/A"}},{"$f":"IF(LONRES>0,0.0198224953157972*Z52,0)","v":{"$error":"#N/A"}},{"$f":"IF(LONRES>0,0.0198224953157972*AA52,0)","v":{"$error":"#N/A"}},{"$f":"IF(LONRES>0,0.0198224953157972*AB52,0)","v":{"$error":"#N/A"}}]
[]
[null,"Rate for Pupil Led Elements",null,null,null,null,null,null,null,{"$f":"SUM(J49:J63)","v":9128.0078132573672},{"$f":"SUM(K49:K63)","v":11039.860388627309},{"$f":"SUM(L49:L63)","v":12995.848063983196},19441.579768500109,14949.829600127208,null,null,{"$f":"SUM(Q49:Q63)","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,null,{"$f":"SUM(X49:X63)","v":{"$error":"#N/A"}},{"$f":"SUM(Y49:Y63)","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[]
[null,"Section 4 - School Led Elements"]
[null,null,null,null,null,null,null,null,null,"Need Type",null,null,null,null,null,null,"Need Type",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,null,"MLD & SLCN","BESD","SLD","PD & PMLD","ASD",null,null,"MLD & SLCN","BESD","SLD","PD & PMLD","ASD"]
[null,"Lump Sum Day",null,null,null,{"$f":"VLOOKUP('Special Rates 2019-20'!DFENUM,newdatacalc!$A$6:$AM$27,16,0)","v":{"$error":"#N/A"}},346331,{"$f":"F69*G69","v":{"$error":"#N/A"}},{"$f":"$C$17+$D$17","v":0},{"$f":"IF(I69=0,0,H69/I69)","v":0},{"$f":"$J69","v":0},{"$f":"$J69","v":0},0,0,null,null,{"$f":"IF(SUM($E$17:$F$17)>0,$J69,0)","v":0},{"$f":"IF(SUM($E$17:$F$17)>0,K$69,0)","v":0},{"$f":"IF(SUM($E$17:$F$17)>0,L$69,0)","v":0},{"$f":"IF(SUM($E$17:$F$17)>0,M$69,0)","v":0},{"$f":"IF(SUM($E$17:$F$17)>0,N$69,0)","v":0},null,null,{"$f":"IF(SUM($F$17)>0,$J69,0)","v":0},{"$f":"IF(SUM($F$17)>0,$K69,0)","v":0},{"$f":"IF(SUM($F$17)>0,$L69,0)","v":0},{"$f":"IF(SUM($F$17)>0,$M69,0)","v":0},{"$f":"IF(SUM($F$17)>0,$N69,0)","v":0}]
[null,"Lump Sum Catering Day",null,null,null,{"$f":"VLOOKUP('Special Rates 2019-20'!DFENUM,newdatacalc!$A$6:$AM$27,17,0)","v":{"$error":"#N/A"}},2000,{"$f":"F70*G70","v":{"$error":"#N/A"}},{"$f":"$C$17+$D$17","v":0},{"$f":"IF(I70=0,0,H70/I70)","v":0},{"$f":"$J70","v":0},0,0,0,null,null,{"$f":"IF(SUM($E$17:$F$17)>0,$J70,0)","v":0},{"$f":"IF(SUM($E$17:$F$17)>0,K$70,0)","v":0},{"$f":"IF(SUM($E$17:$F$17)>0,L$70,0)","v":0},{"$f":"IF(SUM($E$17:$F$17)>0,M$70,0)","v":0},{"$f":"IF(SUM($E$17:$F$17)>0,N$70,0)","v":0},null,null,{"$f":"IF(SUM($F$17)>0,$J70,0)","v":0},{"$f":"IF(SUM($F$17)>0,$J70,0)","v":0},0,0,0]
[null,"Specialist Schools Funding- Lump Sum",null,null,null,{"$f":"VLOOKUP('Special Rates 2019-20'!DFENUM,newdatacalc!$A$6:$AM$27,15,0)","v":{"$error":"#N/A"}},11817.708333333334,{"$error":"#N/A"},0,{"$f":"IF(I71=0,0,H71/I71)","v":0},0,0,0,0,null,null,0,{"$f":"IF(SUM($E$17:$F$17)>0,K$71,0)","v":0},{"$f":"IF(SUM($E$17:$F$17)>0,L$71,0)","v":0},{"$f":"IF(SUM($E$17:$F$17)>0,M$71,0)","v":0},{"$f":"IF(SUM($E$17:$F$17)>0,N$71,0)","v":0},null,null,0,0,0,0,0]
[null,"Free Mid-day Meals",null,null,null,{"$f":"VLOOKUP('Special Rates 2019-20'!DFENUM,newdatacalc!A$33:V$55,18,0)*SUM(C17:D17)","v":{"$error":"#N/A"}},415,{"$f":"F72*G72","v":{"$error":"#N/A"}},0,{"$f":"IF(I72=0,0,H72/I72)","v":0},0,0,0,0,null,null,0,{"$f":"IF(SUM($E$17:$F$17)>0,K$72,0)","v":0},{"$f":"IF(SUM($E$17:$F$17)>0,L$72,0)","v":0},{"$f":"IF(SUM($E$17:$F$17)>0,M$72,0)","v":0},{"$f":"IF(SUM($E$17:$F$17)>0,N$72,0)","v":0},null,null,0,0,0,0,0]
[null,"Gross Day Floor Area (m2)",null,null,null,{"$f":"VLOOKUP('Special Rates 2019-20'!DFENUM,newdatacalc!A$33:V$55,7,0)","v":{"$error":"#N/A"}},29.999997778727799,{"$error":"#N/A"},0,0,0,0,0,0,null,null,0,{"$f":"IF(SUM($E$17:$F$17)>0,K$73,0)","v":0},{"$f":"IF(SUM($E$17:$F$17)>0,L$73,0)","v":0},{"$f":"IF(SUM($E$17:$F$17)>0,M$73,0)","v":0},{"$f":"IF(SUM($E$17:$F$17)>0,N$73,0)","v":0},null,null,0,0,0,0,0]
[null,"Grounds Site Area (hectares)",null,null,null,{"$f":"VLOOKUP('Special Rates 2019-20'!DFENUM,newdatacalc!A$33:V$55,10,0)","v":{"$error":"#N/A"}},1051.9999999999998,{"$error":"#N/A"},0,0,0,0,0,0,null,null,0,{"$f":"IF(SUM($E$17:$F$17)>0,K$74,0)","v":0},{"$f":"IF(SUM($E$17:$F$17)>0,L$74,0)","v":0},{"$f":"IF(SUM($E$17:$F$17)>0,M$74,0)","v":0},{"$f":"IF(SUM($E$17:$F$17)>0,N$74,0)","v":0},null,null,0,0,0,0,0]
[null,"Rentals",null,null,null,{"$f":"VLOOKUP('Special Rates 2019-20'!DFENUM,newdatacalc!A$33:V$55,12,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP('Special Rates 2019-20'!DFENUM,newdatacalc!$A$33:$V$55,11,0)","v":{"$error":"#N/A"}},{"$f":"F75*G75","v":{"$error":"#N/A"}},0,{"$f":"IF(I75=0,0,H75/I75)","v":0},0,0,0,0,null,null,0,{"$f":"IF(SUM($E$17:$F$17)>0,K$75,0)","v":0},{"$f":"IF(SUM($E$17:$F$17)>0,L$75,0)","v":0},{"$f":"IF(SUM($E$17:$F$17)>0,M$75,0)","v":0},{"$f":"IF(SUM($E$17:$F$17)>0,N$75,0)","v":0},null,null,0,0,0,0,0]
[null,"Hydrotherapy Pool",null,null,null,{"$f":"VLOOKUP('Special Rates 2019-20'!DFENUM,newdatacalc!A$33:V$55,17,0)","v":{"$error":"#N/A"}},5000,{"$error":"#N/A"},0,0,0,0,0,0,null,null,0,{"$f":"IF(SUM($E$17:$F$17)>0,K$76,0)","v":0},{"$f":"IF(SUM($E$17:$F$17)>0,L$76,0)","v":0},{"$f":"IF(SUM($E$17:$F$17)>0,M$76,0)","v":0},{"$f":"IF(SUM($E$17:$F$17)>0,N$76,0)","v":0},null,null,0,0,0,0,0]
[null,"Split site- Band  1",null,null,null,{"$f":"VLOOKUP('Special Rates 2019-20'!DFENUM,newdatacalc!A$33:V$55,20,0)","v":{"$error":"#N/A"}},4378,{"$error":"#N/A"},0,0,0,0,0,0,null,null,0,{"$f":"IF(SUM($E$17:$F$17)>0,K$77,0)","v":0},{"$f":"IF(SUM($E$17:$F$17)>0,L$77,0)","v":0},0,0,null,null,0,0,0,0,0]
[null,"Split site - Band 2",null,null,null,{"$f":"VLOOKUP('Special Rates 2019-20'!DFENUM,newdatacalc!A$33:V$55,21,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP('Special Rates 2019-20'!DFENUM,newdatacalc!A$33:V$55,22,0)","v":{"$error":"#N/A"}},{"$error":"#N/A"},0,{"$f":"IF(I78=0,0,H78/I78)","v":0},0,0,0,0,null,null,0,{"$f":"IF(SUM($E$17:$F$17)>0,K$78,0)","v":0},{"$f":"IF(SUM($E$17:$F$17)>0,L$78,0)","v":0},0,0,null,null,0,0,0,0,0]
[null,"Residential Floor Area Weekday (m2)",null,null,null,{"$f":"VLOOKUP('Special Rates 2019-20'!DFENUM,newdatacalc!A$33:V$55,8,0)","v":{"$error":"#N/A"}},49.9995424890393,{"$f":"F79*G79","v":{"$error":"#N/A"}},{"$f":"E17","v":0},0,0,0,0,0,null,null,{"$f":"IF(SUM($E$17:$F$17)>0,H79/I79,0)","v":0},{"$f":"Q79","v":0},{"$f":"R79","v":0},0,0,null,null,0,0,0,0,0]
[null,"Residential Floor Area Weekend (m2)",null,null,null,{"$f":"VLOOKUP('Special Rates 2019-20'!DFENUM,newdatacalc!A$33:V$55,9,0)","v":{"$error":"#N/A"}},64.999908164202196,{"$error":"#N/A"},{"$f":"E17","v":0},0,0,0,0,0,null,null,{"$f":"IF(SUM($E$17:$F$17)>0,H80/I80,0)","v":0},{"$f":"Q80","v":0},0,0,0,null,null,{"$f":"IF(SUM($F$17)>0,$Q80,0)","v":0},0,0,0,0]
[null,"Lump Sum Residential",null,null,null,{"$f":"VLOOKUP('Special Rates 2019-20'!DFENUM,newdatacalc!A$33:V$55,15,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP('Special Rates 2019-20'!DFENUM,newdatacalc!$A$33:$V$55,16,0)","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$f":"E17","v":0},0,0,0,0,0,null,null,{"$f":"IF(SUM($E$17:$F$17)>0,H81/I81,0)","v":0},0,0,0,0,null,null,{"$f":"IF(SUM($F$17)>0,$Q81,0)","v":0},0,0,0,0]
[null,"London Fringe Day Pupils",null,null,null,{"$f":"VLOOKUP('Special Rates 2019-20'!DFENUM,newdatacalc!A$33:V$55,19,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP('Special Rates 2019-20'!DFENUM,newdatacalc!A$5:AM$55,18,0)","v":{"$error":"#N/A"}},{"$f":"F82*G82","v":{"$error":"#N/A"}},{"$f":"$C$17+$D$17","v":0},{"$f":"IF(I82=0,0,$H$82/$I$82)*(IF(DFENUM=7002,(50/164),1))","v":0},{"$f":"J82","v":0},0,0,{"$f":"M82","v":0},null,null,{"$f":"IF(SUM($E$17:$F$17)>0,(H82/I82)*(IF(DFENUM=7002,(164/164),1)),0)","v":0},0,0,0,0,null,null,0,0,0,0,0]
[null,"London Fringe Residential Pupils",null,null,null,{"$f":"VLOOKUP('Special Rates 2019-20'!DFENUM,newdatacalc!A$33:V$55,19,0)","v":{"$error":"#N/A"}},{"$f":"IF(DFENUM=7002,2414.25,2414.25)","v":2414.25},{"$f":"F83*G83","v":{"$error":"#N/A"}},{"$f":"E17","v":0},0,0,0,0,0,null,null,{"$f":"IF(SUM($E$17:$F$17)>0,(H83/I83)*(IF(DFENUM=7002,(164/164),1)),0)","v":0},0,0,0,0,null,null,0,0,0,0,0]
[]
[null,"Rate for School Led Elements",null,null,null,null,null,null,null,{"$f":"SUM(J69:J84)","v":0},0,0,0,0,null,null,{"$f":"SUM(Q69:Q84)","v":0},{"$f":"SUM(R69:R84)","v":0},0,0,0,null,null,{"$f":"SUM(X69:X84)","v":0},{"$f":"SUM(Y69:Y84)","v":0},{"$f":"SUM(Z69:Z84)","v":0},{"$f":"SUM(AA69:AA84)","v":0},{"$f":"SUM(AB69:AB84)","v":0}]
[]
[]
[null,"Total Formula Rate"]
[null,null,null,null,null,null,null,null,null,"Need Type",null,null,null,null,null,null,"Need Type",null,null,null,null,null,null,"Need Type"]
[null,null,null,null,null,null,null,null,null,"MLD & SLCN","BESD","SLD","PD & PMLD","ASD",null,null,"MLD & SLCN","BESD","SLD","PD & PMLD","ASD",null,null,"MLD & SLCN","BESD","SLD","PD & PMLD","ASD"]
[null,null,null,null,null,null,null,null,null,{"$f":"J64+J85","v":9128.0078132573672},{"$f":"K64+K85","v":11039.860388627309},{"$f":"L64+L85","v":12995.848063983196},{"$f":"M64+M85","v":19441.579768500109},{"$f":"N64+N85","v":14949.829600127208},null,null,{"$f":"Q64+Q85","v":{"$error":"#N/A"}},{"$f":"R64+R85","v":{"$error":"#N/A"}},{"$f":"S64+S85","v":{"$error":"#N/A"}},{"$f":"T64+T85","v":{"$error":"#N/A"}},{"$f":"U64+U85","v":{"$error":"#N/A"}},null,null,{"$f":"X64+X85","v":{"$error":"#N/A"}},{"$f":"Y64+Y85","v":{"$error":"#N/A"}},{"$f":"Z64+Z85","v":{"$error":"#N/A"}},{"$f":"AA64+AA85","v":{"$error":"#N/A"}},{"$f":"AB64+AB85","v":{"$error":"#N/A"}}]
[]
[null,"Note 1"]
[null,"ASD",null,null,null,null,"BESD"]
[null," - All ASD pupils in Stone Bay are funded at ASD2 (£21,797)",null,null,null,null," - 75% of Pupils at BESD Schools funded at BESD2 (£13,721)"]
[null," - 10% of all ASD places in C & I and PSCN Special Schools are funded at ASD2  (£15,408)\n",null,null,null,null,"- 25% of all Primary aged Pupils at B&L Schools funded at at BESD2 (BESD1 - £10,078 + percentage profile of individual School)"]

{"sheet":"Nursery Lump Sums","index":1,"n_rows":113,"n_cols":10,"rows_kept":113,"cut":false,"hidden":false,"merged":[]}
[]
[null,"2019/20 Nursery Provision Lump Sum Calculation"]
[]
[]
[null,null,"Rates"]
[]
[null,null,"Leadership Lump Sum per provision",50000,null,null,null,null,"Day Rate Breakdown"]
[null,null,"Day Rate per FTE (see breakdown)",8681.57]
[null,null,null,null,null,null,null,null,"Support Staff",7073.65]
[null,null,"Calculation",null,null,null,null,null,"Other Staffing",1003.07]
[null,null,null,null,null,null,null,null,"Resources",354.08]
[null,null,null,"Units","Rate","Total",null,null,"Training/Sundry",250.77]
[null,null,"Leadership Lump Sum",{"$f":"IFERROR(VLOOKUP(DFENUM,newdatacalc!$A$33:$BS$55,4,0),0)","v":0},50000,{"$f":"IFERROR(E13*D13,\"TBC\")","v":0},null,null,"Total FTE Funding",8681.57]
[null,null,"Day Rate",{"$f":"IFERROR(VLOOKUP(DFENUM,newdatacalc!$A$33:$BS$55,5,0),0)","v":0},8681.57,{"$f":"IFERROR(E14*D14,\"TBC\")","v":0}]
[]
[null,null,null,null,"Total Funding at this provision:",{"$f":"IFERROR(F14+F13,\"TBC\")","v":0}]
[]
[]
[null,null,"This funding will be provided in twelve equal instalments (except where a Nursery provision is commissioned to start in-year)"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,{"$f":"J56+J85","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,{"$f":"J97+J105","v":0}]

{"sheet":"newdatacalc","index":2,"n_rows":56,"n_cols":89,"rows_kept":56,"cut":false,"hidden":true,"merged":[[3,14,3,16],[31,57,31,61],[31,62,31,66],[31,22,31,26],[31,27,31,31],[31,32,31,36],[31,39,31,43],[31,44,31,48],[31,49,31,53]]}
[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,40,37,38,39,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,89,90,91,92,93,94,95,96,97,98,99,100,101,102,103]
[]
[]
["Calc",null,null,21796.724279993101,14697.993577082399,14697.993577082399,10788.0243655825,null,null,null,null,null,null,null,"Section 4 - Units"]
["Dfe","School","Type","ASD High rate","ASD Low Rate","BESD High rate","BESD Low Rate",null,"Dfe","Primary Pupils","Secondary Pupils","Total Pupils","% primary","25% BESD2","Specialist School","Lump sum day","Lump sum day catering","London Fridge Dat rate"]
[7032,"Bower Grove School","B&L",0,1,0.10044642857142858,0.8995535714285714,null,7032,45,67,112,0.4017857142857143,0.10044642857142858,1,1,1,3854.25]
[7033,"St Anthony's School","B&L",0,1,9.166666666666666E-2,0.90833333333333333,null,7033,22,38,60,0.36666666666666664,9.166666666666666E-2,1,1,1,3854.25]
[7044,"Rowhill School","B&L",0,1,0.11403508771929824,0.88596491228070173,null,7044,26,31,57,0.45614035087719296,0.11403508771929824,1,1,1,3854.25]
[7045,"Elms School","B&L",0,1,0.10164835164835165,0.89835164835164838,null,7045,37,54,91,0.40659340659340659,0.10164835164835165,1,1,1,3854.25]
[7062,"The Orchard School","B&L",0,1,7.6612903225806453E-2,0.92338709677419351,null,7062,19,43,62,0.30645161290322581,7.6612903225806453E-2,1,1,1,3854.25]
[7041,"Goldwyn Community Special School","BESD",0,1,0.75,0.25,null,null,null,null,null,null,null,1,1,1,3854.25]
[7067,"Portal House School","BESD",0,1,0.75,0.25,null,null,null,null,null,null,null,1,1,1,3854.25]
[7002,"Broomhill Bank School","C&I",0.1,0.9,0,1,null,null,null,null,null,null,null,1,1,1,3854.25]
[7052,"Grange Park School","C&I",0.1,0.9,0,1,null,null,null,null,null,null,null,1,1,1,3854.25]
[7058,"Stone Bay School","C&I",1,0,0,1,null,null,null,null,null,null,null,1,1,1,3854.25]
[7073,"Laleham Gap School","C&I",0.1,0.9,0,1,null,null,null,null,null,null,null,1,1,1,3854.25]
[7021,"Valence School","PD",0,1,0,1,null,null,null,null,null,null,null,1,1,1,3854.25]
[7039,"The Ifield School","PSCN",0.1,0.9,0,1,null,null,null,null,null,null,null,1,1,1,3854.25]
[7040,"Foreland Fields School","PSCN",0.1,0.9,0,1,null,null,null,null,null,null,null,1,1,1,3854.25]
[7043,"The Beacon Folkestone","PSCN",0.1,0.9,0,1,null,null,null,null,null,null,null,1,1,1,3854.25]
[7051,"Nexus School","PSCN",0.1,0.9,0,1,null,null,null,null,null,null,null,1,1,1,3854.25]
[7056,"Five Acre Wood School","PSCN",0.1,0.9,0,1,null,null,null,null,null,null,null,1,1,1,3854.25]
[7063,"St Nicholas' School","PSCN",0.1,0.9,0,1,null,null,null,null,null,null,null,1,1,1,3854.25]
[7066,"Milestone School","PSCN",0.1,0.9,0,1,null,null,null,null,null,null,null,1,1,1,3854.25]
[7069,"The Wyvern School","PSCN",0.1,0.9,0,1,null,null,null,null,null,null,null,1,1,1,3854.25]
[7070,"Oakley School","PSCN",0.1,0.9,0,1,null,null,null,null,null,null,null,1,1,1,3854.25]
[7072,"Meadowfield School","PSCN",0.1,0.9,0,1,null,null,null,null,null,null,null,1,1,1,3854.25]
[]
[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]
[]
[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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4457,91,16,3955,593,4022,92,16,3552,578]
["Data",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,38427,"DAY April to August 2019 (A) ",null,null,null,null,"WeekDay April to August 2019 (A) ",null,null,null,null,"WeekEnd April to August 2019 (A) ",null,null,null,null,null,null,"DAY 2018-19 FY funding rate + MFG (D input) ",null,null,null,null,"WEEKDAY 2018-19 FY funding rate + MFG (D input) ",null,null,null,null,"WEEKEND 2018-19 FY funding rate + MFG (D input) ",null,null,null,null,null,null,null,"Place data (19/20)",null,null,null,null,"Place data (18/19)"]
["Dfe","School","Type","Nursery","Nursery FTE",null,"Gross Day Floor Area (m2)","Residential Floor Area Weekday (m2)","Residential Floor Area Weekend (m2)","Grounds Site Area (hectares)","Rentals","Rentals","Lump sum standard","lump sum catering day","lump sum residential","lump sum residential rate","Hydrotherapy Pool","% FSM","London Fringe ","Split site- Band  1","Split site - Band 2","split site 2 rate","MLD & SLCN","BESD","SLD","PD & PMLD","ASD","MLD & SLCN","BESD","SLD","PD & PMLD","ASD","MLD & SLCN","BESD","SLD","PD & PMLD","ASD",null,null,"MLD & SLCN","BESD","SLD","PD & PMLD","ASD","MLD & SLCN","BESD","SLD","PD & PMLD","ASD","MLD & SLCN","BESD","SLD","PD & PMLD","ASD",null,null,null,"Day","Res Weekday","Res Weekend","Pre-16","Post-16","Day","Res Weekday","Res Weekend","Pre-16","Post-16",null,"Residential weekday","Residential Weekend","Residential Weekday Places- Catering","Residential Weekend Places Catering"]
[7032,"Bower Grove School","B&L",0,0,null,4093,0,0,2.1496,0,0,1,1,0,0,0,0.3888888888888889,0,1,0,0,11598.049156258197,13915.653253576251,15465.889406984026,21911.621111500936,17419.870943128069,null,null,null,null,null,null,null,null,null,null,null,null,11617.028080732343,13940.121240847313,15484.868331458172,21930.60003597508,17438.849867602214,null,null,null,null,null,null,null,null,null,null,null,null,null,214,0,0,214,0,212,0,0,212,0,null,0,0,0,0]
[7033,"St Anthony's School","B&L",0,0,null,3614,0,0,1.54,0,0,1,1,0,0,0,0.5092592592592593,0,0,0,0,14135.448469849813,16384.367356555962,18003.288720575641,24449.020425092553,19957.27025671969,null,null,null,null,null,null,null,null,null,null,null,null,14187.500284703747,16438.883106434281,18055.340535429572,24501.072239946483,20009.322071573624,null,null,null,null,null,null,null,null,null,null,null,null,null,98,0,0,98,0,98,0,0,98,0,null,0,0,0,0]
[7044,"Rowhill School","B&L",0,0,null,4165,0,0,1.8948,0,0,1,1,0,0,0,0.57407407407407407,1,0,0,0,13966.777790759388,16336.025620692028,17909.776901150071,24480.681701251055,19907.472743241698,null,null,null,null,null,null,null,null,null,null,null,null,13959.458977855003,16332.514748041762,17902.458088245687,24473.36288834667,19900.153930337314,null,null,null,null,null,null,null,null,null,null,null,null,null,110,0,0,110,0,110,0,0,110,0,null,0,0,0,0]
[7045,"Elms School","B&L",0,0,null,2771,0,0,2.13,0,0,1,1,0,0,0,0.63846153846153841,0,0,0,0,13251.090093067698,15488.77343606264,17118.930343793527,23564.662048310442,19072.911879937576,null,null,null,null,null,null,null,null,null,null,null,null,13247.631759734364,15492.65363353167,17115.472010460195,23561.203714977106,19069.453546604243,null,null,null,null,null,null,null,null,null,null,null,null,null,158,0,0,158,0,115,0,0,115,0,null,0,0,0,0]
[7062,"The Orchard School","B&L",0,0,null,2505,0,0,1.81,0,0,1,1,0,0,0,0.45555555555555555,0,0,0,0,14579.372461534729,16790.779129721202,18447.212712260556,24892.944416777471,20401.194248404601,null,null,null,null,null,null,null,null,null,null,null,null,14670.309170336583,16858.723748065648,18538.149421062415,24983.881125579326,20492.13095720646,null,null,null,null,null,null,null,null,null,null,null,null,null,83,0,0,83,0,83,0,0,83,0,null,0,0,0,0]
[7041,"Goldwyn Community Special School","BESD",0,0,null,5362.3800899999997,0,0,7.3492000000000006,0,0,1,1,0,0,0,0.36690647482014388,0,1,1,38427,13079.934584334449,17924.264068329343,16947.774835060278,23393.506539577193,18901.756371204327,null,null,null,null,null,null,null,null,null,null,null,null,14320.84595566911,18760.377643973214,17842.554113694074,23711.479411595286,19621.686575646214,null,null,null,null,null,null,null,null,null,null,null,null,null,150,0,0,150,0,150,0,0,150,0,null,0,0,0,0]
[7067,"Portal House School","BESD",0,0,null,3091,0,0,0.81,0,0,1,1,0,0,0,0.22413793103448276,0,0,0,0,16828.521504380384,21672.850988375274,20696.361755106209,27142.093459623124,22650.343291250258,null,null,null,null,null,null,null,null,null,null,null,null,16842.304716940769,21686.634200935659,20710.144967666594,27155.876672183513,22664.126503810643,null,null,null,null,null,null,null,null,null,null,null,null,null,80,0,0,80,0,60,0,0,60,0,null,0,0,0,0]
[7002,"Broomhill Bank School","C&I",0,0,null,10814.893001489763,632.10699851023674,0,10.685,0,0,1,1,1,163425,0,0.18636363636363637,1,0,1,38427,12645.984286764322,14571.903236255483,16536.738823973341,23020.633057631738,19217.947017682491,51662.826265756812,53620.816548244336,55605.825376147506,62176.730176248479,58326.599748841472,null,null,null,null,null,null,null,14751.097660088173,15925.947112531767,18358.795106949932,24375.237004489372,20858.584481567716,54125.924850091586,56054.545278341808,58009.778973826418,64482.120201925885,60689.741730929978,null,null,null,null,null,null,null,null,212,23,0,173,62,201,16,0,155,62,null,24705.560131913953,0,1360,0]
[7052,"Grange Park School","C&I",0,0,null,1958.53,0,0,1.1245000000000001,0,0,1,1,0,0,0,0.29090909090909089,0,0,0,0,13056.39488582923,14968.247461199177,16924.23513655506,23369.966841071979,19588.089742990174,null,null,null,null,null,null,null,null,null,null,null,null,13056.918875728221,14968.771451098166,16924.75912645405,23370.490830970968,19588.613732889164,null,null,null,null,null,null,null,null,null,null,null,null,null,157,0,0,107,50,110,0,0,64,46,null,0,0,0,0]
[7058,"Stone Bay School","C&I",0,0,null,2396.216342490492,1481.783657509508,0,0.96,0,0,1,1,1,163425,1,0.27272727272727271,0,0,0,0,16528.667108754758,18440.519684124705,20396.507359480587,26842.239063997502,29449.21959853527,58872.765197035413,60784.617772405363,62740.605447761242,69186.337152278167,71793.317686815935,null,null,null,null,null,null,null,16526.942868488852,18438.795443858799,20394.783119214677,26840.514823731595,29447.495358269363,59526.266455194753,61438.119030564703,63394.106705920582,69839.8384104375,72446.818944975283,null,null,null,null,null,null,null,null,42,18,0,45,15,38,22,0,45,15,null,30188.029681771073,0,1360,0]
[7073,"Laleham Gap School","C&I",0,0,null,4451.9400000000005,433,0,2.5697000000000001,0,0,1,1,1,163425,0,0.23618090452261306,0,0,0,0,11713.885169089403,13625.737744459349,15581.725419815231,22027.457124332141,18245.58002625034,69681.129857269465,71592.98243263943,73548.970107995308,79994.701812512241,76212.824714430433,null,null,null,null,null,null,null,11928.725384051122,13840.577959421069,15796.565634776949,22242.297339293866,18460.420241212061,72047.495422239561,73959.347997609511,75915.33567296539,82361.067377482308,78579.1902794005,null,null,null,null,null,null,null,null,192,4,0,196,0,191,5,0,196,0,null,19592.284308629278,0,1360,0]
[7021,"Valence School","PD",0,0,null,8799,0,1924,18.321999999999999,0,0,1,1,1,163425,1,0.20792079207920791,1,0,0,0,15888.87024811045,17846.860530597976,19831.869358501139,26402.774158602122,21829.565200592766,61883.29027486001,63841.280557347527,65826.289385250697,72397.194185351662,67823.985227342317,86932.413529586731,88890.403812074248,90875.412639977425,97446.317440078405,92873.108482069045,null,null,16320.436844917675,17762.76734678158,19895.773701219568,26318.68097478573,21745.472016776373,61570.157130326239,63528.147412813756,65513.156240716926,72084.061040817905,67510.852082808546,86619.28038505296,88577.270667540477,90562.279495443654,97133.184295544634,92559.975337535274,null,null,null,59,46,16,72,33,35,49,16,70,30,null,37943.253676235712,23885.650068136336,1360,2050]
[7039,"The Ifield School","PSCN",1,6,null,4274.1399960000008,0,0,6.22,31367,1,1,1,0,0,1,0.2832618025751073,0,1,0,0,11580.742085339776,13492.594660709723,15448.582336065605,21894.314040582522,18112.436942500717,null,null,null,null,null,null,null,null,null,null,null,null,11608.70241104082,13520.554986410767,15476.542661766649,21922.274366283564,18140.397268201759,null,null,null,null,null,null,null,null,null,null,null,null,null,250,0,0,210,40,230,0,0,187,43,null,0,0,0,0]
[7040,"Foreland Fields School","PSCN",2,10,null,4331,0,0,4.3045,0,0,1,1,0,0,1,0.32407407407407407,0,1,0,0,11784.961278709176,13696.813854079122,15652.801529435004,22098.533233951919,18316.656135870118,null,null,null,null,null,null,null,null,null,null,null,null,11837.139361199736,13741.424997316715,15697.412672672599,22143.144377189514,18361.267279107709,null,null,null,null,null,null,null,null,null,null,null,null,null,220,0,0,188,32,200,0,0,167,33,null,0,0,0,0]
[7043,"The Beacon School","PSCN",2,10,null,6634,0,0,0.92510000000000003,0,0,1,1,0,0,1,0.35714285714285715,0,0,0,0,10855.693171297289,12767.545746667236,14723.533422023118,21169.265126540027,17387.388028458223,null,null,null,null,null,null,null,null,null,null,null,null,11950.614007931596,13737.662205320779,15616.005749982054,21869.815792996978,18200.544085510563,null,null,null,null,null,null,null,null,null,null,null,null,null,370,0,0,306,64,354,0,0,291,63,null,0,0,0,0]
[7051,"Nexus School","PSCN",1,8,null,5820,0,0,2.36,0,0,1,1,0,0,1,0.23636363636363636,0,0,1,38427,12364.985068907952,14276.837644277899,16232.825319633781,22678.557024150694,18896.679926068889,null,null,null,null,null,null,null,null,null,null,null,null,12967.590810156669,14822.517975094976,16720.266117417134,22974.076160432058,19304.804452945642,null,null,null,null,null,null,null,null,null,null,null,null,null,200,0,0,186,14,172,0,0,158,14,null,0,0,0,0]
[7056,"Five Acre Wood School","PSCN",2,10,null,7768.4,0,0,2.6381999999999999,9259,1,1,1,0,0,1,0.25467289719626168,0,1,1,38427,10970.393965810255,12882.246541180202,14838.234216536084,21283.965921052994,17502.088822971193,null,null,null,null,null,null,null,null,null,null,null,null,11425.780580945197,13045.98978882847,14951.602159691305,21397.333864208216,17615.456766126412,null,null,null,null,null,null,null,null,null,null,null,null,null,470,0,0,412,58,375,0,0,324,51,null,0,0,0,0]
[7063,"St Nicholas' School","PSCN",1,6,null,3971.7700100000002,0,0,0.93049999999999999,77747,1,1,1,0,0,1,0.31818181818181818,0,1,1,38427,11676.338556501172,13588.191131871119,15544.178807227001,21989.91051174391,18208.033413662106,null,null,null,null,null,null,null,null,null,null,null,null,11746.85447644403,13658.707051813975,15614.694727169859,22060.42643168677,18278.549333604966,null,null,null,null,null,null,null,null,null,null,null,null,null,272,0,0,229,43,250,0,0,205,45,null,0,0,0,0]
[7066,"Milestone School","PSCN",2,12,null,7254,0,0,4.6955,0,0,1,1,0,0,1,0.234375,1,0,3,38427,11507.505364328554,13465.495646816078,15450.504474719242,22021.409274820224,18171.278847413214,null,null,null,null,null,null,null,null,null,null,null,null,11528.612410936727,13486.602693424255,15471.611521327417,22042.516321428397,18192.385894021387,null,null,null,null,null,null,null,null,null,null,null,null,null,330,0,0,275,55,330,0,0,275,55,null,0,0,0,0]
[7069,"The Wyvern School","PSCN",1,5,null,6096,0,0,7.6,0,0,1,1,0,0,1,0.25954198473282442,0,1,0,0,11462.853277889755,13374.705853259702,15330.693528615584,21776.425233132497,17994.548135050693,null,null,null,null,null,null,null,null,null,null,null,null,11596.505913766097,13508.358489136044,15464.346164491926,21910.077869008841,18128.200770927033,null,null,null,null,null,null,null,null,null,null,null,null,null,270,0,0,235,35,250,0,0,215,35,null,0,0,0,0]
[7070,"Oakley School","PSCN",2,12,null,4287,0,0,11.4161,0,0,1,1,0,0,0,0.24747474747474749,0,0,1,38427,12001.209951944025,13913.062527313972,15869.050202669854,22314.781907186763,18532.904809104963,null,null,null,null,null,null,null,null,null,null,null,null,12014.450535492397,13926.303110862345,15882.290786218226,22328.022490735137,18546.145392653336,null,null,null,null,null,null,null,null,null,null,null,null,null,200,0,0,158,42,194,0,0,158,36,null,0,0,0,0]
[7072,"Meadowfield School","PSCN",1,4,null,6963,0,0,2.3725999999999998,0,0,1,1,0,0,1,0.29032258064516131,0,0,0,0,11424.897847885715,13336.750423255662,15292.738098611544,21738.469803128453,17956.592705046653,null,null,null,null,null,null,null,null,null,null,null,null,11515.89141425167,13427.743989621616,15383.731664977498,21829.463369494406,18047.586271412609,null,null,null,null,null,null,null,null,null,null,null,null,null,320,0,0,270,50,264,0,0,214,50,null,0,0,0,0]
[null,"Total",null,null,83]