{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Special Rates 2018-19","Nursery Lump Sums","newdatacalc"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":24,"comments":1,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Special Rates 2018-19","index":0,"n_rows":96,"n_cols":28,"rows_kept":96,"cut":false,"hidden":false,"merged":[[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],[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],[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],[75,1,75,4],[76,1,76,4],[77,1,77,4],[78,1,78,4],[79,1,79,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],[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]]}
[]
[]
[]
[null,null,null,null,"2018/19 Calculation of Special School Funding Rates"]
[]
[]
[]
[null,"DfE",null,null,{"$f":"IFERROR(VLOOKUP(DFENUM,newdatacalc!$A$33:$CB$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 2017-18 agreed November 2016\n\n\nPlace numbers 2018-19 agreed November 2017"]
[]
[null,"2017/18",{"$f":"IFERROR(VLOOKUP(DFENUM,newdatacalc!$A$33:$CL$55,81,0),0)","v":0},{"$f":"IFERROR(VLOOKUP(DFENUM,newdatacalc!$A$33:$CL$55,82,0),0)","v":0},{"$f":"IFERROR(VLOOKUP(DFENUM,newdatacalc!$A$33:$CL$55,83,0),0)","v":0},{"$f":"IFERROR(VLOOKUP(DFENUM,newdatacalc!$A$33:$CL$55,84,0),0)","v":0}]
[]
[null,"2018/19",{"$f":"IFERROR(VLOOKUP(DFENUM,newdatacalc!$A$33:$CL$55,79,0),0)","v":0},{"$f":"IFERROR(VLOOKUP(DFENUM,newdatacalc!$A$33:$CL$55,80,0),0)","v":0},{"$f":"IFERROR(VLOOKUP(DFENUM,newdatacalc!$A$33:$CL$55,77,0),0)","v":0},{"$f":"IFERROR(VLOOKUP(DFENUM,newdatacalc!$A$33:$CL$55,78,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 2018 to March 2019"]
[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 2018 to August 2018 (Formula only excluding MFG)- based on  Academic Year 2017 to 2018. Data taken from 2017-18 Funding Rates Calculation.",null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP('Special Rates 2018-19'!DFENUM,newdatacalc!$A$33:$BC$55,41,0),0)","v":0},{"$f":"IFERROR(VLOOKUP('Special Rates 2018-19'!DFENUM,newdatacalc!$A$33:$BC$55,42,0),0)","v":0},{"$f":"IFERROR(VLOOKUP('Special Rates 2018-19'!DFENUM,newdatacalc!$A$33:$BC$55,43,0),0)","v":0},{"$f":"IFERROR(VLOOKUP('Special Rates 2018-19'!DFENUM,newdatacalc!$A$33:$BC$55,44,0),0)","v":0},{"$f":"IFERROR(VLOOKUP('Special Rates 2018-19'!DFENUM,newdatacalc!$A$33:$BC$55,45,0),0)","v":0},null,null,{"$f":"VLOOKUP('Special Rates 2018-19'!DFENUM,newdatacalc!$A$33:$BC$55,46,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP('Special Rates 2018-19'!DFENUM,newdatacalc!$A$33:$BC$55,47,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP('Special Rates 2018-19'!DFENUM,newdatacalc!$A$33:$BC$55,48,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP('Special Rates 2018-19'!DFENUM,newdatacalc!$A$33:$BC$55,49,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP('Special Rates 2018-19'!DFENUM,newdatacalc!$A$33:$BC$55,50,0)","v":{"$error":"#N/A"}},null,null,{"$f":"VLOOKUP('Special Rates 2018-19'!DFENUM,newdatacalc!$A$33:$BC$55,51,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP('Special Rates 2018-19'!DFENUM,newdatacalc!$A$33:$BC$55,52,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP('Special Rates 2018-19'!DFENUM,newdatacalc!$A$33:$BC$55,53,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP('Special Rates 2018-19'!DFENUM,newdatacalc!$A$33:$BC$55,54,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP('Special Rates 2018-19'!DFENUM,newdatacalc!$A$33:$BC$55,55,0)","v":{"$error":"#N/A"}}]
[]
["(B)","September 2018 to March 2019 (Formula only excluding MFG)- based on  Academic Year 2018 to 2019. 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 2018 to March 2019 - based on Academic Year 2017 to 2018 (April 2018 to August 2018) 5/12's + Academic Year 2018 to 2019 (September 2018 to March 2019) 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 2017 to 2018",null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP('Special Rates 2018-19'!DFENUM,newdatacalc!$A$33:$BV$55,58,0),0)","v":0},{"$f":"IFERROR(VLOOKUP('Special Rates 2018-19'!DFENUM,newdatacalc!$A$33:$BV$55,59,0),0)","v":0},{"$f":"IFERROR(VLOOKUP('Special Rates 2018-19'!DFENUM,newdatacalc!$A$33:$BV$55,60,0),0)","v":0},{"$f":"IFERROR(VLOOKUP('Special Rates 2018-19'!DFENUM,newdatacalc!$A$33:$BV$55,61,0),0)","v":0},{"$f":"IFERROR(VLOOKUP('Special Rates 2018-19'!DFENUM,newdatacalc!$A$33:$BV$55,62,0),0)","v":0},null,null,{"$f":"VLOOKUP('Special Rates 2018-19'!DFENUM,newdatacalc!$A$33:$BV$55,63,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP('Special Rates 2018-19'!DFENUM,newdatacalc!$A$33:$BV$55,64,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP('Special Rates 2018-19'!DFENUM,newdatacalc!$A$33:$BV$55,65,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP('Special Rates 2018-19'!DFENUM,newdatacalc!$A$33:$BV$55,66,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP('Special Rates 2018-19'!DFENUM,newdatacalc!$A$33:$BV$55,67,0)","v":{"$error":"#N/A"}},null,null,{"$f":"VLOOKUP('Special Rates 2018-19'!DFENUM,newdatacalc!$A$33:$BV$55,68,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP('Special Rates 2018-19'!DFENUM,newdatacalc!$A$33:$BV$55,69,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP('Special Rates 2018-19'!DFENUM,newdatacalc!$A$33:$BV$55,70,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP('Special Rates 2018-19'!DFENUM,newdatacalc!$A$33:$BV$55,71,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP('Special Rates 2018-19'!DFENUM,newdatacalc!$A$33:$BV$55,72,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)*10788.0243655825)+(VLOOKUP(DFENUM,newdatacalc!A5:G27,6,0)*14697.9935770824))-K49,0)","v":0},0,0,{"$f":"IFERROR(((VLOOKUP(DFENUM,newdatacalc!A5:E27,5,0)*14697.9935770824)+(VLOOKUP(DFENUM,newdatacalc!A5:E27,4,0)*21796.7242799931))-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:$CL$55,86,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(DFENUM,newdatacalc!$A$33:$CL$55,86,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(DFENUM,newdatacalc!$A$33:$CL$55,86,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(DFENUM,newdatacalc!$A$33:$CL$55,86,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(DFENUM,newdatacalc!$A$33:$CL$55,86,0)","v":{"$error":"#N/A"}},null,null,{"$f":"IF($F$17=0,0,VLOOKUP(DFENUM,newdatacalc!$A$33:$CL$55,86,0))","v":0},{"$f":"IF($F$17=0,0,VLOOKUP(DFENUM,newdatacalc!$A$33:$CL$55,86,0))","v":0},{"$f":"IF($F$17=0,0,VLOOKUP(DFENUM,newdatacalc!$A$33:$CL$55,86,0))","v":0},{"$f":"IF($F$17=0,0,VLOOKUP(DFENUM,newdatacalc!$A$33:$CL$55,86,0))","v":0},{"$f":"IF($F$17=0,0,VLOOKUP(DFENUM,newdatacalc!$A$33:$CL$55,86,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:$CL$55,87,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(DFENUM,newdatacalc!$A$33:$CL$55,87,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(DFENUM,newdatacalc!$A$33:$CL$55,87,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(DFENUM,newdatacalc!$A$33:$CL$55,87,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(DFENUM,newdatacalc!$A$33:$CL$55,87,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:$CL$55,88,0)","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$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:$CL$55,89,0)","v":{"$error":"#N/A"}},{"$f":"X59","v":{"$error":"#N/A"}},{"$f":"Y59","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$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 2018-19'!DFENUM,newdatacalc!$A$33:$BC$55,21,0)>0,0.0174114727366503*Q49*(IF(DFENUM=7002,(164/164),1)),0)","v":{"$error":"#N/A"}},{"$f":"IF(VLOOKUP('Special Rates 2018-19'!DFENUM,newdatacalc!$A$33:$BC$55,21,0)>0,0.0186025655345146*R49*(IF(DFENUM=7002,(164/164),1)),0)","v":{"$error":"#N/A"}},{"$f":"IF(VLOOKUP('Special Rates 2018-19'!DFENUM,newdatacalc!$A$33:$BC$55,21,0)>0,0.0180246285124395*S49*(IF(DFENUM=7002,(164/164),1)),0)","v":{"$error":"#N/A"}},{"$f":"IF(VLOOKUP('Special Rates 2018-19'!DFENUM,newdatacalc!$A$33:$BC$55,21,0)>0,0.0184931692203593*T49*(IF(DFENUM=7002,(164/164),1)),0)","v":{"$error":"#N/A"}},{"$f":"IF(VLOOKUP('Special Rates 2018-19'!DFENUM,newdatacalc!$A$33:$BC$55,21,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 2018-19'!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 2018-19'!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 2018-19'!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 2018-19'!DFENUM,newdatacalc!A$33:AM$55,34,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 2018-19'!DFENUM,newdatacalc!A$33:BX$55,23,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 2018-19'!DFENUM,newdatacalc!A$33:BV$55,26,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 2018-19'!DFENUM,newdatacalc!A$33:AM$55,28,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP('Special Rates 2018-19'!DFENUM,newdatacalc!$A$33:$AM$55,27,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 2018-19'!DFENUM,newdatacalc!A$33:AM$55,33,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 2018-19'!DFENUM,newdatacalc!A$33:AM$55,38,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 2018-19'!DFENUM,newdatacalc!A$33:AM$55,39,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP('Special Rates 2018-19'!DFENUM,newdatacalc!A$33:BB$55,40,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 2018-19'!DFENUM,newdatacalc!A$33:AM$55,24,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 2018-19'!DFENUM,newdatacalc!A$33:AM$55,25,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 2018-19'!DFENUM,newdatacalc!A$33:CP$55,31,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP('Special Rates 2018-19'!DFENUM,newdatacalc!$A$33:$AM$55,32,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 2018-19'!DFENUM,newdatacalc!A$33:BX$55,36,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP('Special Rates 2018-19'!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 2018-19'!DFENUM,newdatacalc!A$33:BX$55,37,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,"2018/19 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:$CL$55,9,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:$CL$55,10,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":[]}
[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]
["Dfe","School","Type","ASD High rate","ASD Low Rate","BESD High rate","BESD Low Rate",null,"Dfe","Primary Pupils","Secondary Pupils","Total Pupils","% secondary","25% BESD2","Specialist School","Lump sum day","Lump sum day catering","London Fridge Dat rate"]
[7032,"Bower Grove School","B&L",0,1,{"$f":"VLOOKUP(A6,$I$6:$N$10,6,0)","v":0.10377358490566038},{"$f":"1-F6","v":0.89622641509433965},null,7032,44,62,106,{"$f":"J6/L6","v":0.41509433962264153},{"$f":"M6*0.25","v":0.10377358490566038},1,1,1,3854.25]
[7033,"St Anthony's School","B&L",0,1,{"$f":"VLOOKUP(A7,$I$6:$N$10,6,0)","v":8.6206896551724144E-2},{"$f":"1-F7","v":0.9137931034482758},null,7033,20,38,58,{"$f":"J7/L7","v":0.34482758620689657},{"$f":"M7*0.25","v":8.6206896551724144E-2},1,1,1,3854.25]
[7044,"Rowhill School","B&L",0,1,{"$f":"VLOOKUP(A8,$I$6:$N$10,6,0)","v":0.10326086956521739},0.89673913043478259,null,7044,19,27,46,0.41304347826086957,{"$f":"M8*0.25","v":0.10326086956521739},1,1,1,3854.25]
[7045,"Elms School","B&L",0,1,{"$f":"VLOOKUP(A9,$I$6:$N$10,6,0)","v":8.3333333333333329E-2},0.91666666666666663,null,7045,23,46,69,0.33333333333333331,8.3333333333333329E-2,1,1,1,3854.25]
[7062,"The Orchard School","B&L",0,1,{"$f":"VLOOKUP(A10,$I$6:$N$10,6,0)","v":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,21796.724279993101,10788.024365582505,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,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(BX34:BX55)","v":0},100,16,3552,578,3327,549,92,16]
["Data",null,null,14697.993577082399,14697.993577082434,null,null,null,null,null,null,null,null,{"$f":"SUM(N34:N55)","v":0},{"$f":"SUM(O34:O55)","v":0},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,"DAY April to August 2018 (A) ","DAY April to August 2018 (A) ","DAY April to August 2018 (A) ","DAY April to August 2018 (A) ","DAY April to August 2018 (A) ","WeekD April to August 2018 (A) ","WeekD April to August 2018 (A) ","WeekD April to August 2018 (A) ","WeekD April to August 2018 (A) ","WeekD April to August 2018 (A) ","WeekEnd April to August 2018 (A) ","WeekEnd April to August 2018 (A) ","WeekEnd April to August 2018 (A) ","WeekEnd April to August 2018 (A) ","WeekEnd April to August 2018 (A) ",null,null,"DAY September to March 2018 (D input) ","DAY September to March 2018 (D input) ","DAY September to March 2018 (D input) ","DAY September to March 2018 (D input) ","DAY September to March 2018 (D input) ","WeekD September to March 2018 (D input) ","WeekD September to March 2018 (D input) ","WeekD September to March 2018 (D input) ","WeekD September to March 2018 (D input) ","WeekD September to March 2018 (D input) ","WeekEnd September to March 2018 (D input) ","WeekEnd September to March 2018 (D input) ","WeekEnd September to March 2018 (D input) ","WeekEnd September to March 2018 (D input) ","WeekEnd September to March 2018 (D input) ",null,null,"Place data (18/19)",null,null,null,null,null,"Place data (17/18)"]
["Dfe","School","Type","ASDAdjusted Rate due to School type (see note 1)","BESDAdjusted Rate due to School type (see note 1)","Day provision","Resi -Weekday","Resi -Weekend","Nursery","Nursery FTE",null,null,null,null,null,null,null,null,null,null,"London Fringe Residential Pupils (DAY adjustment for Broomhill)","Lunch Grant","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",null,"London Fringe Day Pupils","London Fringe Residential Pupils","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","Pre-16","Post-16","Weekday Residential","Weekend Residential",null,"Residential weekday","Residential Weekend","Residential Weekday Places- Catering","Residential Weekend Places Catering"]
[7032,"Bower Grove School","B&L",709.87307029106341,405.75152194810653,1,null,null,0,0,null,null,null,null,null,null,null,null,null,null,{"$f":"AK34","v":0},0,4093,0,0,2.1496,0,0,1,1,0,null,0,0.38725490196078433,null,0,0,1,0,null,11643.598574996147,13974.376423026801,15511.438825721976,21957.170530238884,17465.420361866018,null,null,null,null,null,null,null,null,null,null,null,null,11647.101245936319,13958.684350660638,15514.941496662146,21960.673201179055,17468.923032806189,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,212,0,208,0,0,0]
[7033,"St Anthony's School","B&L",709.87307029106341,337.06631133620067,1,null,null,0,0,null,null,null,null,null,null,null,null,null,null,{"$f":"AK35","v":0},0,3614,0,0,1.54,0,0,1,1,0,null,0,0.50505050505050508,null,0,0,0,0,null,14260.372825499251,16515.205156263928,18128.213076225078,24573.944780741989,20082.194612369123,null,null,null,null,null,null,null,null,null,null,null,null,14267.384914406721,16520.974564898228,18135.22516513255,24580.956869649461,20089.206701276591,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,98,0,96,0,0,0]
[7044,"Rowhill School","B&L",709.87307029106341,403.74682075271085,1,null,null,0,0,null,null,null,null,null,null,null,null,null,null,1,0,4165,0,0,1.8948,0,0,1,1,0,null,0,0.53271028037383172,null,1,1,0,0,null,13949.212639788862,16327.599526331393,17892.211750179547,24463.116550280531,19889.907592271175,null,null,null,null,null,null,null,null,null,null,null,null,14013.845721764599,16365.233452971517,17956.844832155282,24527.749632256266,19954.540674246913,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,110,0,110,0,0,0]
[7045,"Elms School","B&L",709.87307029106341,325.83076762499513,1,null,null,0,0,null,null,null,null,null,null,null,null,null,null,0,0,2771,0,0,2.13,0,0,1,1,0,null,0,0.6,null,0,0,0,0,null,13242.790093067699,15498.085909988315,17110.630343793528,23556.362048310442,19064.611879937576,null,null,null,null,null,null,null,null,null,null,null,null,13446.056710501362,15666.466457334041,17297.21044752912,23742.942152046031,19251.191983673165,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,115,0,115,0,0,0]
[7062,"The Orchard School","B&L",709.87307029106341,299.55409281652646,1,null,null,0,0,null,null,null,null,null,null,null,null,null,null,0,0,2505,0,0,1.81,0,0,1,1,0,null,0,0.44303797468354428,null,0,0,0,0,null,14797.620562659176,16953.846213747875,18665.460813385012,25111.192517901927,20619.442349529061,null,null,null,null,null,null,null,null,null,null,null,null,14813.934185134771,16995.615364944169,18681.774435860607,25127.506140377518,20635.755972004656,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,83,0,80,0,0,0]
[7041,"Goldwyn Community Special School","BESD",null,2932.4769086249453,1,null,null,0,0,null,null,null,null,null,null,null,null,null,null,0,0,5362.3800899999997,0,0,7.3492000000000006,0,0,1,1,0,null,0,0.34108527131782945,null,0,0,1,1,38427,13656.808337422724,18501.137821417615,17524.648588148553,23970.380292665464,19478.630124292598,null,null,null,null,null,null,null,null,null,null,null,null,14538.9299042326,19046.068674084479,18114.268135730024,24072.567930553592,19920.493985427627,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,150,0,130,0,0,0]
[7067,"Portal House School","BESD",null,2932.4769086249453,1,null,null,0,0,null,null,null,null,null,null,null,null,null,null,0,0,3091,0,0,0.81,0,0,1,1,0,null,0,0.33333333333333331,null,0,0,0,0,null,16861.601214525308,21705.930698520202,20729.441465251137,27175.173169768052,22683.423001395186,null,null,null,null,null,null,null,null,null,null,null,null,16843.193973422338,21685.118353168487,20708.629119899422,27154.360824416341,22662.610656043471,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,60,0,60,0,0,0]
[7002,"Broomhill Bank School","C&I",null,null,1,1,null,0,0,null,null,null,null,null,null,null,null,null,null,1,0,10814.893001489763,632.10699851023674,0,10.685,0,0,1,1,1,163425,0,0.19696969696969696,null,1,1,0,1,38427,12763.13545716682,14689.054406657979,16653.889994375837,23137.784228034234,19335.09818808499,54950.177512783339,56908.167795270871,58893.176623174033,65464.081423275013,61613.950995867999,null,null,null,null,null,null,null,14975.733665064135,16168.474225920576,18638.370666954248,24746.433507095811,21176.227900068749,54950.177512783339,56908.167795270871,58893.176623174033,65464.081423275013,61613.950995867999,null,null,null,null,null,null,null,null,null,24,0,155,62,172,37,12,0,null,24705.560131913953,0,1360,0]
[7052,"Grange Park School","C&I",null,null,1,null,null,0,0,null,null,null,null,null,null,null,null,null,null,0,0,1958.53,0,0,1.1245000000000001,0,0,1,1,0,null,0,0.26363636363636361,null,0,0,0,0,null,13057.652461586806,14969.505036956753,16925.492712312636,23371.224416829555,19589.34731874775,null,null,null,null,null,null,null,null,null,null,null,null,13222.137060281253,15122.203800764652,17078.191476120533,23523.923180637452,19742.046082555647,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,64,46,62,48,0,0]
[7058,"Stone Bay School","C&I",7098.7307029106378,null,1,1,null,0,0,null,null,null,null,null,null,null,null,null,null,0,0,2396.216342490492,1481.783657509508,0,0.96,0,0,1,1,1,163425,1,0.24074074074074073,null,0,0,0,0,null,16524.528932116584,18436.381507486527,20392.369182842409,26838.100887359324,29445.081421897092,60441.168216617836,62353.020791987787,64309.008467343665,70754.740171860583,73361.720706398351,null,null,null,null,null,null,null,16749.610406536147,18632.785193275537,20576.612754637259,27022.34445915417,29629.324993691938,59800.837814897335,61712.690390267278,63668.678065623157,70114.409770140075,72721.390304677858,null,null,null,null,null,null,null,null,null,22,0,45,15,34,26,21,0,null,30188.029681771073,null,1360]
[7073,"Laleham Gap School","C&I",null,null,1,1,null,0,0,null,null,null,null,null,null,null,null,null,null,0,0,{"$f":"3477+669.34","v":4146.34},{"$f":"1004-571","v":433},0,2.5697000000000001,0,0,1,1,1,163425,0,0.24083769633507854,null,0,0,0,0,null,11683.214772769299,13595.067348139246,15551.055023495128,21996.786728012044,18214.909629930244,75360.407213197672,77272.259788567608,79228.247463923486,85673.979168440419,81892.102070358611,null,null,null,null,null,null,null,12100.575669998525,13983.75045673792,15910.398316963465,22259.444045912627,18534.295104302051,64315.552918419999,66227.405493789935,68183.393169145813,74629.124873662746,70847.247775580923,null,null,null,null,null,null,null,null,null,5,0,196,0,190,0,5,0,null,19592.284308629278,0,1360,0]
[7021,"Valence School","PD",null,null,1,1,1,0,0,null,null,null,null,null,null,null,null,null,null,1,0,8799,0,1924,18.321999999999999,0,0,1,1,1,163425,1,0.20202020202020202,null,1,1,0,0,null,15687.046606951108,17645.03688943863,19630.045717341796,26200.950517442776,21627.74155943342,61131.770727978961,63089.761010466471,65074.769838369648,71645.674638470635,67072.465680461275,86180.893982705689,88138.884265193206,90123.893093096369,96694.797893197363,92121.588935188003,null,null,16568.971416160075,17637.718736767725,20198.755026618852,26247.791754595062,21620.423406762515,61124.452575308052,63082.442857795562,65067.451685698739,71638.356485799741,67065.147527790366,86173.575830034795,88131.566112522298,90116.57494042546,96687.479740526454,92114.270782517095,null,null,null,null,49,16,70,30,79,24,54,16,null,37943.253676235712,23885.650068136336,1360,2050]
[7039,"The Ifield School","PSCN",null,null,1,null,null,1,6,null,null,null,null,null,null,null,null,null,null,0,0,4274.1399960000008,0,0,6.22,31367,1,1,1,0,null,1,0.2982456140350877,null,0,0,1,0,null,11647.846867022281,13559.699442392228,15515.68711774811,21961.418822265015,18179.541724183215,null,null,null,null,null,null,null,null,null,null,null,null,11643.068519813125,13554.921095183074,15510.908770538954,21956.640475055858,18174.763376974061,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,187,43,181,42,0,0]
[7040,"Foreland Fields School","PSCN",null,null,1,null,null,{"$f":"(1*(5/12))+((2*(7/12)))","v":1.5833333333333335},{"$f":"(6*(5/12))+((10*(7/12)))","v":8.3333333333333339},"Checked to Letter",null,null,null,null,null,null,null,null,null,0,0,4331,0,0,4.3045,0,0,1,1,0,null,1,0.330188679245283,null,0,0,1,0,null,11892.028022479399,13803.880597849346,15759.868273205228,22205.599977722144,18423.72287964034,null,null,null,null,null,null,null,null,null,null,null,null,12017.40036670024,13929.252942070187,15885.240617426069,22330.972321942983,18549.095223861179,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,167,33,168,24,0,0]
[7043,"The Beacon School","PSCN",null,null,1,null,null,2,10,"Checked to Letter",null,null,null,null,null,null,null,null,null,0,0,6634,0,0,0.92510000000000003,0,0,1,1,0,null,1,0.31623931623931623,null,0,0,0,0,null,10854.376142317973,12766.22871768792,14722.216393043802,21167.948097560715,17386.07099947891,null,null,null,null,null,null,null,null,null,null,null,null,12132.603053737661,13946.86518306678,15853.812944144218,22202.858673093378,18477.709731482806,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,291,63,282,65,0,0]
[7051,"Nexus School","PSCN",null,null,1,null,null,1,8,"Not listed on letter",null,null,null,null,null,null,null,null,null,0,0,{"$f":"5690+130","v":5820},0,0,2.36,0,0,1,1,0,null,1,0.20353982300884957,null,0,0,0,0,null,12705.421336853124,14617.273912223071,16573.261587578952,23018.993292095864,19237.116194014063,null,null,null,null,null,null,null,null,null,null,null,null,13165.066812341796,15048.241599081193,16974.889459306734,23323.935188255895,19598.786246645323,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,158,14,117,13,0,0]
[7056,"Five Acre Wood School","PSCN",null,null,1,null,null,{"$f":"(1*(5/12))+((2*(7/12)))","v":1.5833333333333335},{"$f":"(8*(5/12))+((10*(7/12)))","v":9.1666666666666679},"Checked to Letter",null,null,null,null,null,null,null,null,null,0,0,7768.4,0,0,2.6381999999999999,9259,1,1,1,0,null,1,0.24324324324324326,null,0,0,1,1,38427,11242.477029382782,13154.329604752729,15110.317280108611,21556.048984625526,17774.171886543721,null,null,null,null,null,null,null,null,null,null,null,null,11599.777239538271,13244.659684089818,15175.115471035697,21575.514772031875,17793.637673950074,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,324,51,277,48,0,0]
[7063,"St Nicholas' School","PSCN",null,null,1,null,null,1,6,"Not listed on letter",null,null,null,null,null,null,null,null,null,0,0,3971.7700100000002,0,0,0.93049999999999999,{"$f":"21000+32747+24000","v":77747},1,1,1,0,null,1,0.30120481927710846,null,0,0,1,1,38427,11845.57676436403,13757.429339733977,15713.417015089859,22159.148719606772,18377.271621524967,null,null,null,null,null,null,null,null,null,null,null,null,11634.268103486822,13546.120678856771,15502.108354212653,21947.840058729565,18165.962960647761,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,205,45,190,45,0,0]
[7066,"Milestone School","PSCN",null,null,1,null,null,2,12,"Not listed on letter",null,null,null,null,null,null,null,null,null,1,0,{"$f":"6993+261","v":7254},0,0,4.6955,0,0,1,1,0,null,1,0.2,null,1,1,{"$f":"1-1","v":0},3,38427,11558.162276188172,13516.152558675698,15501.16138657886,22072.066186679844,18221.93575927283,null,null,null,null,null,null,null,null,null,null,null,null,11615.963274850485,13573.953557338011,15558.962385241175,22129.867185342155,18279.736757935141,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,{"$f":"275","v":275},55,254,46,0,0]
[7069,"The Wyvern School","PSCN",null,null,1,null,null,1,5,"Not listed on letter",null,null,null,null,null,null,null,null,null,0,0,6096,0,0,7.6,0,0,1,1,0,null,1,0.22466960352422907,null,0,0,1,0,null,11783.619603992978,13695.472179362925,15651.459854718807,22097.191559235718,18315.314461153914,null,null,null,null,null,null,null,null,null,null,null,null,11761.88236347531,13673.734938845257,15629.722614201139,22075.454318718053,18293.577220636249,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,215,35,184,35,0,0]
[7070,"Oakley School","PSCN",null,null,1,null,null,2,{"$f":"(12/12)*12","v":12},"Checked to Letter",null,null,null,null,null,null,null,null,null,0,0,4287,0,0,11.4161,0,0,1,1,0,null,0,0.22613065326633167,null,0,0,0,1,38427,12032.987352460119,13944.839927830066,15900.827603185948,22346.559307702857,18564.682209621056,null,null,null,null,null,null,null,null,null,null,null,null,12109.278128647456,14021.130704017405,15977.118379373287,22422.850083890196,18640.972985808396,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,158,36,158,36,0,0]
[7072,"Meadowfield School","PSCN",null,null,1,null,null,1,4,"Checked to Letter",null,null,null,null,null,null,null,null,null,0,0,6963,0,0,2.3725999999999998,0,0,1,1,0,null,1,0.27240143369175629,null,0,0,0,0,null,11643.282407164006,13555.134982533953,15511.122657889835,21956.854362406746,18174.977264324942,null,null,null,null,null,null,null,null,null,null,null,null,11602.313621902558,13514.166197272503,15470.153872628387,21915.885577145295,18134.008479063494,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,214,50,180,60,0,0]
[null,"Total",null,null,null,{"$f":"SUM(F34:F55)","v":22},{"$f":"SUM(G34:G55)","v":4},{"$f":"SUM(H34:H55)","v":1},null,{"$f":"SUM(J34:J55)","v":80.5}]