{"text_format":"1","workbook":"xlsx","n_sheets":11,"sheets":["Summary of Funding","Budget Share Statement","Minimum Funding Level","MFG Calculation","De-delegation","EYSFF statement","Further Delegation Info","ISB","LogIn","LoginPage","Funding Floor"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":19,"defined_names":22,"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":"Summary of Funding","index":0,"n_rows":46,"n_cols":14,"rows_kept":46,"cut":false,"hidden":true,"merged":[[17,0,17,3],[2,0,2,7],[3,0,3,7],[5,0,5,7],[1,0,1,7],[9,0,9,2]]}
["Date Issued: ",null,null,null,null,null,null,"Last amended: 21st December 2023"]
["COVENTRY CITY COUNCIL"]
["2023/24 Funding Allocations for Schools",null,null,null,null,null,null,null,null,null,null,null,null,16]
["INDICATIVE Summary of Funding"]
[]
[{"$f":"_xlfn.XLOOKUP(\"P\"&$N$3,'[5]Minimum Funding Guarantee'!$A:$A,'[5]Minimum Funding Guarantee'!$C:$C)","v":"Frederick Bird Primary School"},null,null,null,null,null,null,null,null,null,null,null,null,"Checks"]
[]
[]
[{"$f":"IF((N36+N37)=0,\"\",\"***ERROR - CALCULATED ADJUSTMENT DOES NOT EQUAL ACTUAL ***\")","v":""}]
["Main Funding Elements"]
[]
["School Budget Share 2023/24",null,null,null,null,{"$f":"'Budget Share Statement'!K58","v":3848313.167525012},null,null,null,null,null,null,null,{"$f":"F12-'Budget Share Statement'!K58","v":0}]
[]
["Indicative Early Years Funding 2023/24* (to be updated)",null,null,null,null,{"$f":"'EYSFF statement'!K30","v":215478.72407142859},null,null,null,null,null,null,null,{"$f":"F14-'EYSFF statement'!K30","v":0}]
[]
[null,null,null,null,null,null,null,{"$f":"SUM(F12,F14)","v":4063791.8915964407},null,null,null,null,null,{"$f":"N12+N14","v":0}]
[]
["Other 2023/24 Funding Elements "]
[]
["Indicative Pupil Premium Grant † (excludes LAC & EYPP elements)",null,null,null,null,{"$f":"_xlfn.XLOOKUP(\"P\"&$N$3,[6]Allocations!$A$1:$A$65536,[6]Allocations!$V$1:$V$65536)","v":531410}]
[]
["Indicative High Needs Top-up Funding §",null,null,null,null,{"$f":"_xlfn.XLOOKUP(\"P\"&$N$3,'[7]HN Top-up Calculation'!$A:$A,'[7]HN Top-up Calculation'!$R:$R)","v":40808.19}]
[]
["Class Size Funding ",null,null,null,null,{"$f":"_xlfn.XLOOKUP(N3,'[8]Class size'!$A:$A,'[8]Class size'!$N:$N)","v":0}]
[]
["In-year Admissions Funding ",null,null,null,null,{"$f":"_xlfn.XLOOKUP(\"P\"&$N$3,'[8]In-year admissions'!$A:$A,'[8]In-year admissions'!$M:$M)","v":40039.79}]
[]
["Disproportionate SEN",null,null,null,null,{"$f":"-_xlfn.XLOOKUP(\"P\"&$N$3,[9]Sheet1!$C:$C,[9]Sheet1!$T:$T)","v":0}]
[]
["Mainstream schools additional grant",null,null,null,null,{"$f":"_xlfn.XLOOKUP(\"P\"&$N$3,[10]Sheet1!$Z:$Z,[10]Sheet1!$X:$X)","v":129417}]
[]
["Teachers pay additional grant 7/12ths",null,null,null,null,{"$f":"_xlfn.XLOOKUP(\"P\"&N3,[11]Sheet1!$Y:$Y,[11]Sheet1!$X:$X)","v":38960}]
[]
[null,null,null,null,null,null,null,{"$f":"F20+F22+F24+F26+F28+F30+F32","v":780634.98}]
[]
["Total Revenue Resources",null,null,null,null,null,null,{"$f":"H16+H34","v":4844426.8715964407},null,null,null,null,null,{"$f":"N12+N14+N20+N22+N24+N16","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(('Budget Share Statement'!O58+'EYSFF statement'!N30+'De-delegation'!O25+'Minimum Funding Level'!O28+'Funding Floor'!N42+'MFG Calculation'!N57),0)","v":0}]
[]
["Notes "]
["This funding summary is intended to give you an overview of the resources allocated to the school for the financial year 2023/24."]
["Please ensure that you read this budget share pack in conjunction with the explanatory notes which are available to download online."]
[]
["* Early Years funding has been updated to reflect the Summer and Autumn term census data - please see the EYSFF statement for further detail."]
["† Pupil Premium Funding has been updated to reflect 23/24 eligibility data from DfE. This may still be subject to slight change."]
["§ Indicative High Needs Top-up Funding has been calculated based on your number of pupils on high needs bandings as at 15/08/23. This"]
["figure will change based on the real time movement of pupils during the 2023/24 financial year and so will not be final until March 2024."]

{"sheet":"Budget Share Statement","index":1,"n_rows":61,"n_cols":15,"rows_kept":61,"cut":false,"hidden":true,"merged":[[55,7,55,8],[20,2,20,4],[21,2,21,4],[22,2,22,4],[23,2,23,4],[53,7,53,8],[39,2,39,4],[39,7,39,8],[51,2,51,4],[24,2,24,4],[47,7,47,8],[37,2,37,4],[31,2,31,4],[35,2,35,4],[51,7,51,8],[43,7,43,8],[1,0,1,10],[18,2,18,4],[19,2,19,4],[3,0,3,10],[17,2,17,4],[16,2,16,4],[2,0,2,10],[5,0,5,10],[9,2,9,4]]}
[{"$f":"'Summary of Funding'!A1","v":"Date Issued: "},null,null,null,null,null,null,null,null,null,{"$f":"'Summary of Funding'!H1","v":"Last amended: 21st December 2023"}]
["COVENTRY CITY COUNCIL"]
[{"$f":"'Summary of Funding'!A3:H3","v":"2023/24 Funding Allocations for Schools"},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Summary of Funding'!N3","v":16}]
["INDICATIVE School Budget Share Statement"]
[]
[{"$f":"_xlfn.XLOOKUP(\"P\"&$N$3,'[5]Minimum Funding Guarantee'!$A:$A,'[5]Minimum Funding Guarantee'!$C:$C)","v":"Frederick Bird Primary School"},null,null,null,null,null,null,null,null,null,null," ",null,null,"Checks"]
[null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null," "]
[]
["Factors",null,"Factor Measurement",null,null,null,"Number\nof Units",null,"Funding\nPer Unit",null,"Funding \nAllocated"]
[null,null,null,null,null,null,null,null,"£",null,"£"," "]
["Basic Entitlement"]
["Funding",null,"Pupil Number: (Oct-22 Census)",null,null,null,{"$f":"_xlfn.XLOOKUP(\"P\"&$N$3,[12]Data!$A:$A,[12]Data!$G:$G)","v":727},null,{"$f":"[12]Formula!$D$2","v":3405.47172},null,{"$f":"G13*I13","v":2475777.94044},null,null,null,{"$f":"_xlfn.XLOOKUP(\"P\"&$N$3,[12]Formula!$A:$A,[12]Formula!$D:$D)-K13","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,{"$f":"K13","v":2475777.94044}]
[]
["Deprivation Funding",null,"IDACI Band G:  Pupil's IDACI < 0.20",null,null,null,{"$f":"_xlfn.XLOOKUP(\"P\"&$N$3,[12]Data!$A:$A,[12]Data!$V:$V)","v":52.999999999999979},null,0,null,{"$f":"G17*I17","v":0}]
[null,null,"IDACI Band F:  0.20 ≤ Pupil's IDACI < 0.25",null,null,null,{"$f":"_xlfn.XLOOKUP(\"P\"&$N$3,[12]Data!$A:$A,[12]Data!$W:$W)","v":21.000000000000036},null,{"$f":"[12]Formula!$N$2","v":230.7774},null,{"$f":"G18*I18","v":4846.3254000000079}," ",null,null,{"$f":"_xlfn.XLOOKUP(\"P\"&$N$3,[12]Formula!$A:$A,[12]Formula!$N:$N)-K18","v":0}]
[null,null,"IDACI Band E:  0.25 ≤ Pupil's IDACI < 0.30",null,null,null,{"$f":"_xlfn.XLOOKUP(\"P\"&$N$3,[12]Data!$A:$A,[12]Data!$X:$X)","v":24.000000000000007},null,{"$f":"[12]Formula!$O$2","v":280.94639999999998},null,6742.7136000000019," ",null,null,{"$f":"_xlfn.XLOOKUP(\"P\"&$N$3,[12]Formula!$A:$A,[12]Formula!$O:$O)-K19","v":0}]
[null,null,"IDACI Band D:  0.30 ≤ Pupil's IDACI < 0.35",null,null,null,{"$f":"_xlfn.XLOOKUP(\"P\"&$N$3,[12]Data!$A:$A,[12]Data!$Y:$Y)","v":200.99999999999977},null,{"$f":"[12]Formula!$P$2","v":441.48719999999997},null,88738.927199999889," ",null,null,{"$f":"_xlfn.XLOOKUP(\"P\"&$N$3,[12]Formula!$A:$A,[12]Formula!$P:$P)-K20","v":0}]
[null,null,"IDACI Band C:  0.35 ≤ Pupil's IDACI < 0.40",null,null,null,{"$f":"_xlfn.XLOOKUP(\"P\"&$N$3,[12]Data!$A:$A,[12]Data!$Z:$Z)","v":110.99999999999983},null,{"$f":"[12]Formula!$Q$2","v":481.62239999999997},null,53460.086399999913,null,null,null,{"$f":"_xlfn.XLOOKUP(\"P\"&$N$3,[12]Formula!$A:$A,[12]Formula!$Q:$Q)-K21","v":0}]
[null,null,"IDACI Band B:  0.40 ≤ Pupil's IDACI < 0.50",null,null,null,{"$f":"_xlfn.XLOOKUP(\"P\"&$N$3,[12]Data!$A:$A,[12]Data!$AA:$AA)","v":303.99999999999983},null,{"$f":"[12]Formula!$R$2","v":511.72379999999998},null,155564.0351999999,null,null,null,{"$f":"_xlfn.XLOOKUP(\"P\"&$N$3,[12]Formula!$A:$A,[12]Formula!$R:$R)-K22","v":0}]
[null,null,"IDACI Band A:  0.50 ≤ Pupil's IDACI ≤ 1.00",null,null,null,{"$f":"_xlfn.XLOOKUP(\"P\"&$N$3,[12]Data!$A:$A,[12]Data!$AB:$AB)","v":13.000000000000032},null,{"$f":"[12]Formula!$S$2","v":672.26459999999997},null,8739.4398000000219,null,null,null,{"$f":"_xlfn.XLOOKUP(\"P\"&$N$3,[12]Formula!$A:$A,[12]Formula!$S:$S)-K23","v":0}]
[null,null,"Free School Meals: (Oct-22 FSM Eligibility)",null,null,null,{"$f":"_xlfn.XLOOKUP(\"P\"&$N$3,[12]Data!$A:$A,[12]Data!$T:$T)","v":356.00000000000028},null,{"$f":"[12]Formula!$E$2","v":481.62239999999997},null,171457.57440000013,null,null,null,{"$f":"_xlfn.XLOOKUP(\"P\"&$N$3,[12]Formula!$A:$A,[12]Formula!$E:$E)-K24","v":0}]
[null,null,"Free School Meals Ever 6: (Oct-22 FSM Eligibility)",null,null,null,{"$f":"_xlfn.XLOOKUP(\"P\"&$N$3,[12]Data!$A:$A,[12]Data!$U:$U)","v":366.00000000000017},null,{"$f":"[12]Formula!$F$2","v":707.38289999999995},null,258902.14140000011,null,null,null,{"$f":"_xlfn.XLOOKUP(\"P\"&$N$3,[12]Formula!$A:$A,[12]Formula!$F:$F)-K25","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(K17:K25)","v":748451.24340000004}]
[]
["Prior Attainment Funding",null,"No.pupils not reaching expected level of development",null,null,null,{"$f":"_xlfn.XLOOKUP(\"P\"&$N$3,[12]Data!$A:$A,[12]Data!$AC:$AC)","v":295.11645071346584},null,{"$f":"[12]Formula!$G$2","v":1158.9039},null,{"$f":"G29*I29","v":342011.60568599333},null,null,null,{"$f":"_xlfn.XLOOKUP(\"P\"&$N$3,[12]Formula!$A:$A,[12]Formula!$G:$G)-K29","v":0}]
[]
["English as an Additional"]
["Language Funding",null,"No. EAL in compulsory education for 3 years or less",null,null,null,{"$f":"_xlfn.XLOOKUP(\"P\"&$N$3,[12]Data!$A:$A,[12]Data!$AD:$AD)","v":277.33281004709585},null,{"$f":"[12]Formula!$H$2","v":581.96039999999994},null,{"$f":"G32*I32","v":161396.71306813191},null,null,null,{"$f":"_xlfn.XLOOKUP(\"P\"&$N$3,[12]Formula!$A:$A,[12]Formula!$H:$H)-K32","v":0}]
[]
["Pupil Mobility Funding",null,"No.pupils in last 3 years who didn’t start school in Sept",null,null,null,{"$f":"_xlfn.XLOOKUP(\"P\"&$N$3,[12]Data!$A:$A,[12]Data!$AE:$AE)","v":59.380000000000052},null,{"$f":"[12]Formula!$I$2","v":948.19409999999993},null,{"$f":"G34*I34","v":56303.765658000048},null,null,null,{"$f":"_xlfn.XLOOKUP(\"P\"&$N$3,[12]Formula!$A:$A,[12]Formula!$I:$I)-K34","v":0}]
[]
["Lump Sum",null,"One set amount for all schools",null,null,null,null,null,null,null,{"$f":"_xlfn.XLOOKUP(\"P\"&$N$3,[12]Formula!$A:$A,[12]Formula!$J:$J)","v":128432.63999999998},null,null,null,{"$f":"_xlfn.XLOOKUP(\"P\"&$N$3,[12]Formula!$A:$A,[12]Formula!$J:$J)-K36","v":0}]
[]
["Split Sites Funding",null,"Lump Sum",null,null,null,null,null,null,null,{"$f":"_xlfn.XLOOKUP(\"P\"&$N$3,[12]Formula!$A:$A,[12]Formula!$L:$L)","v":0},null,null,null,{"$f":"_xlfn.XLOOKUP(\"P\"&$N$3,[12]Formula!$A:$A,[12]Formula!$L:$L)-K38","v":0}]
[]
["Rates Funding",null,"Estimated 2023/24 rates bill",null,null,null,null,{"$f":"_xlfn.XLOOKUP(\"P\"&$N$3,[12]Formula!$A:$A,[12]Formula!$K:$K)","v":87552},{"$f":"INDEX([13]Formula!$J:$J,MATCH(\"P\"&$N$3,[13]Formula!$A:$A,0))-E40","v":128432.63999999998},null,{"$f":"H40","v":87552},null,null,null,{"$f":"_xlfn.XLOOKUP(\"P\"&$N$3,[12]Formula!$A:$A,[12]Formula!$K:$K)-K40","v":0}]
[]
["Total Formula Factor Funding",null,null,null,null,null,null,null,null,null,{"$f":"K15+K27+K32+K34+K36+K38+K40+K29","v":3999925.9082521256},null,null,null,{"$f":"_xlfn.XLOOKUP(\"P\"&$N$3,[12]Formula!$A:$A,[12]Formula!$U:$U)-K42","v":0}]
[]
["Minimum Per Pupil (MPP) Funding Level Allocation",null,null,null,null,null,null,{"$f":"'Minimum Funding Level'!J28","v":0},null,null,null,null,null,null,{"$f":"ROUND(_xlfn.XLOOKUP(\"P\"&$N$3,[12]Formula!$A:$A,[12]Formula!$V:$V),2)-H44","v":0}]
[]
["Total Funding Allocated before Minimum Funding Guarantee (MFG)",null,null,null,null,null,null,null,null,null,{"$f":"K42+H44","v":3999925.9082521256},null,null,null,{"$f":"ROUND(_xlfn.XLOOKUP(\"P\"&$N$3,[12]Formula!$A:$A,[12]Formula!$W:$W),2)-K46","v":1.7478745430707932E-3}]
[]
["MFG Protection (additional funding/top-slice)",null,null,null,null,null,null,{"$f":"'MFG Calculation'!J64","v":0},null,null,null,null,null,null,{"$f":"ROUND(_xlfn.XLOOKUP(\"P\"&$N$3,[12]Formula!$A:$A,[12]Formula!$Z:$Z),2)-H48","v":0}]
[]
["Total Funding Allocated after protection Arrangements",null,null,null,null,null,null,null,null,null,{"$f":"K46+H48","v":3999925.9082521256},null,null,null,{"$f":"ROUND(_xlfn.XLOOKUP(\"P\"&$N$3,[12]Formula!$A:$A,[12]Formula!$AA:$AA),2)-K50","v":1.7478745430707932E-3}]
[]
["23/24 De-delegation",null,"See separate 'De-delegation' sheet",null,null,null,null,{"$f":"'De-delegation'!K25","v":-46580.740727113385},null,null,null,null,null,null,{"$f":"ROUND(_xlfn.XLOOKUP(\"P\"&$N$3,[12]Formula!$A:$A,[12]Formula!$AB:$AB),2)-H52","v":7.2711338725639507E-4}]
[]
["23/24 Risk Protection Arrangement Deduction",null,null,null,null,null,null,{"$f":"-IFERROR(_xlfn.XLOOKUP(\"P\"&$N$3,'[14]LAMS Data'!$AH:$AH,'[14]LAMS Data'!$AE:$AE),0)","v":-17480}]
[]
["23/24 Business Rates Deduction",null,null,null,null,null,null,{"$f":"-H40","v":-87552}]
[]
["Total Funding Allocated after MFG, De-delegation and RPA & NNDR Adjustments",null,null,null,null,null,null,null,null,null,{"$f":"K50+H52+H54+H56","v":3848313.167525012},null,null,null,{"$f":"ROUND(_xlfn.XLOOKUP(\"P\"&$N$3,[12]Formula!$A:$A,[12]Formula!$AC:$AC),2)-K58+H56+H54","v":2.4749878793954849E-3}]
[]
["Notes"]
["If you have chosen to join the DfE Risk Protection Arrangement, the value of your charge has been deducted from your budget share. "]

{"sheet":"Minimum Funding Level","index":2,"n_rows":28,"n_cols":14,"rows_kept":28,"cut":false,"hidden":true,"merged":[[11,6,11,7],[19,6,19,7],[21,6,21,7],[16,6,16,7],[1,0,1,10],[2,0,2,10],[3,0,3,10],[5,0,5,10],[8,6,8,7],[9,6,9,7]]}
[{"$f":"'Summary of Funding'!A1","v":"Date Issued: "},null,null,null,null,null,null,null,null,null,{"$f":"'Summary of Funding'!H1","v":"Last amended: 21st December 2023"}]
["COVENTRY CITY COUNCIL"]
[{"$f":"'Summary of Funding'!A3:H3","v":"2023/24 Funding Allocations for Schools"},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Summary of Funding'!N3","v":16}]
["Calculation of Minimum Per Pupil (MPP) Funding Level"]
[]
[{"$f":"_xlfn.XLOOKUP(\"P\"&$N$3,'[5]Minimum Funding Guarantee'!$A:$A,'[5]Minimum Funding Guarantee'!$C:$C)","v":"Frederick Bird Primary School"},null,null,null,null,null,null,null,null,null,null,null,null,"Checks"]
[]
[]
[null,null,null,null,null,null,"£",null,null,"£"]
["NFF Minimum per pupil funding rate",null,null,null,null,null,{"$f":"'[12]Minimum Per Pupil'!$D$3","v":4405},null,null,null,null,null,null,{"$f":"'[12]Minimum Per Pupil'!$D$3-G10","v":0}]
[]
["October 2022 Pupil Numbers",null,null,null,null,null,{"$f":"_xlfn.XLOOKUP(\"P\"&$N$3,'[12]Minimum Per Pupil'!$A:$A,'[12]Minimum Per Pupil'!$D:$D)","v":727},null,null,null,null,null,null,{"$f":"_xlfn.XLOOKUP(\"P\"&$N$3,'[12]Minimum Per Pupil'!$A:$A,'[12]Minimum Per Pupil'!$D:$D)-G12","v":0}]
[]
["Minimum Funding Level (MFL)",null,null,null,null,"[A]",null,null,null,{"$f":"G10*G12","v":3202435},null,null,null,{"$f":"_xlfn.XLOOKUP(\"P\"&$N$3,'[12]Minimum Per Pupil'!$A:$A,'[12]Minimum Per Pupil'!$E:$E)-J14","v":0}]
[]
[]
["Total Formula Factor Funding",null,null,null,null,null,{"$f":"'Budget Share Statement'!K42","v":3999925.9082521256},null,null,null,null,null,null,{"$f":"_xlfn.XLOOKUP(\"P\"&$N$3,'[12]Minimum Per Pupil'!$A:$A,'[12]Minimum Per Pupil'!$G:$G)-G17","v":0}]
[]
["Less: exempt premises factors"]
["2023/24 NNDR",null,null,null,null,null,{"$f":"_xlfn.XLOOKUP(\"P\"&$N$3,[12]Formula!$A:$A,[12]Formula!$K:$K)","v":87552},{"$f":"INDEX([13]Formula!$K:$K,MATCH(\"P\"&$N$3,[13]Formula!$A:$A,0))-A20","v":{"$error":"#VALUE!"}},null,null,null,null,null,{"$f":"_xlfn.XLOOKUP(\"P\"&$N$3,[12]Formula!$A:$A,[12]Formula!$K:$K)-G20","v":0}]
[]
["2023/24 Split Site",null,null,null,null,null,{"$f":"_xlfn.XLOOKUP(\"P\"&$N$3,[12]Formula!$A:$A,[12]Formula!$L:$L)","v":0},{"$f":"INDEX([13]Formula!$K:$K,MATCH(\"P\"&$N$3,[13]Formula!$A:$A,0))-A22","v":{"$error":"#VALUE!"}},null,null,null,null,null,{"$f":"_xlfn.XLOOKUP(\"P\"&$N$3,[12]Formula!$A:$A,[12]Formula!$L:$L)-G22","v":0}]
[]
[]
["2023/24 Funding for MFL comparison",null,null,null,null,"[B]",null,null,null,{"$f":"G17-SUM(G20:G22)","v":3912373.9082521256},null,null,null,{"$f":"_xlfn.XLOOKUP(\"P\"&$N$3,'[12]Minimum Per Pupil'!$A:$A,'[12]Minimum Per Pupil'!$K:$K)-J25","v":0}]
[]
[]
["MFL shortfall to be funded  [B] - [A]",null,null,null,null,"= [B] - [A]  ",null,null,null,{"$f":"IF(J25<J14,J14-J25,0)","v":0},null,null,null,{"$f":"_xlfn.XLOOKUP(\"P\"&$N$3,'[12]Minimum Per Pupil'!$A:$A,'[12]Minimum Per Pupil'!$M:$M)-J28","v":0}]

{"sheet":"MFG Calculation","index":3,"n_rows":67,"n_cols":14,"rows_kept":67,"cut":false,"hidden":true,"merged":[[59,6,59,7],[61,6,61,7],[10,6,10,7],[51,6,51,7],[17,6,17,7],[15,6,15,7],[31,6,31,7],[13,6,13,7],[29,6,29,7],[53,6,53,7],[44,6,44,7],[49,6,49,7],[35,6,35,7],[42,6,42,7],[22,6,22,7],[1,0,1,10],[2,0,2,10],[3,0,3,10],[5,0,5,10],[19,6,19,7],[8,6,8,7]]}
[{"$f":"'Summary of Funding'!A1","v":"Date Issued: "},null,null,null,null,null,null,null,null,null,{"$f":"'Summary of Funding'!H1","v":"Last amended: 21st December 2023"}]
["COVENTRY CITY COUNCIL"]
[{"$f":"'Summary of Funding'!A3:H3","v":"2023/24 Funding Allocations for Schools"},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Summary of Funding'!N3","v":16}]
["Calculation of Minimum Funding Guarantee"]
[]
[{"$f":"_xlfn.XLOOKUP(\"P\"&$N$3,[5]Formula!$A:$A,[5]Formula!$C:$C)","v":"Frederick Bird Primary School"},null,null,null,null,null,null,null,null,null,null,null,null,"Checks"]
[]
[]
["Baseline",null,{"$f":"IF(N57>=0,\" \",\"DOES NOT BALANCE\")","v":" "},null,null,null,"£",null,null,"£"]
[]
["Final Budget Share 2022/23 (Excluding Early Years)",null,null,null,null,null,null,null,null,{"$f":"_xlfn.XLOOKUP(\"P\"&$N$3,'[12]Minimum Funding Guarantee'!$A:$A,'[12]Minimum Funding Guarantee'!$H:$H)","v":3618765.8539006351}]
[]
["Less:"]
["2022/23 Rates Funding",null,null,null,null,null,{"$f":"_xlfn.XLOOKUP(\"P\"&$N$3,'[12]Minimum Funding Guarantee'!$A:$A,'[12]Minimum Funding Guarantee'!$J:$J)","v":75264},{"$f":"INDEX('[13]Minimum Funding Guarantee'!$H:$H,MATCH(\"P\"&$N$3,'[13]Minimum Funding Guarantee'!$A:$A,0))","v":3618765.8539006351}]
[]
["2023/24 Lump Sum",null,null,null,null,null,{"$f":"_xlfn.XLOOKUP(\"P\"&$N$3,'[12]Minimum Funding Guarantee'!$A:$A,'[12]Minimum Funding Guarantee'!$I:$I)","v":128432.63999999998},{"$f":"INDEX('[13]Minimum Funding Guarantee'!$H:$H,MATCH(\"P\"&$N$3,'[13]Minimum Funding Guarantee'!$A:$A,0))","v":3618765.8539006351}]
[]
["2022/23 Education Improvement Commissioning Pot",null,null,null,null,null,{"$f":"_xlfn.XLOOKUP(\"P\"&$N$3,'[12]Minimum Funding Guarantee'!$A:$A,'[12]Minimum Funding Guarantee'!$K:$K)","v":7317.319286104861},{"$f":"INDEX('[13]Minimum Funding Guarantee'!$H:$H,MATCH(\"P\"&$N$3,'[13]Minimum Funding Guarantee'!$A:$A,0))","v":3618765.8539006351}]
[]
["2022/23 Split Site",null,null,null,null,null,{"$f":"_xlfn.XLOOKUP(\"P\"&$N$3,'[12]Minimum Funding Guarantee'!$A:$A,'[12]Minimum Funding Guarantee'!$L:$L)","v":0},{"$f":"INDEX('[13]Minimum Funding Guarantee'!$H:$H,MATCH(\"P\"&$N$3,'[13]Minimum Funding Guarantee'!$A:$A,0))","v":3618765.8539006351},null,{"$f":"-SUM(G14,G16,G18,G20)","v":-211013.95928610486}]
[]
["Add:"]
["2022/23 Supplementary Grant",null,null,null,null,null,{"$f":"_xlfn.XLOOKUP(\"P\"&$N$3,'[12]Minimum Funding Guarantee'!$A:$A,'[12]Minimum Funding Guarantee'!$M:$M)","v":102633.7334},{"$f":"INDEX('[13]Minimum Funding Guarantee'!$H:$H,MATCH(\"P\"&$N$3,'[13]Minimum Funding Guarantee'!$A:$A,0))","v":3618765.8539006351},null,{"$f":"G23","v":102633.7334}]
[]
["Adjusted Budget Share 2022/23",null,null,null,null,null,null,null,null,{"$f":"J11+J20+J23","v":3510385.6280145301},null,null,null,{"$f":"_xlfn.XLOOKUP(\"P\"&$N$3,'[12]Minimum Funding Guarantee'!$A:$A,'[12]Minimum Funding Guarantee'!$N:$N)-J25","v":0}]
[]
[]
["Guaranteed Unit Funding Calculation",null,null,null,null,null,null,null,null,"£"]
[]
["Adjusted Budget Share 2022/23",null,null,null,null,null,{"$f":"J25","v":3510385.6280145301}]
[]
["October 2021 Pupil Number",null,null,null,null,null,{"$f":"_xlfn.XLOOKUP(\"P\"&$N$3,'[12]Minimum Funding Guarantee'!$A:$A,'[12]Minimum Funding Guarantee'!$D:$D)","v":709},{"$f":"INDEX('[13]Minimum Funding Guarantee'!$H:$H,MATCH(\"P\"&$N$3,'[13]Minimum Funding Guarantee'!$A:$A,0))","v":3618765.8539006351}]
[]
["Adjusted Budget Share 2022/23 Per Pupil",null,null,null,null,null,null,null,null,{"$f":"G30/G32","v":4951.1786008667559},null,null,null,{"$f":"_xlfn.XLOOKUP(\"P\"&$N$3,'[12]Minimum Funding Guarantee'!$A:$A,'[12]Minimum Funding Guarantee'!$O:$O)-J34","v":0}]
[]
["Minimum Funding Guarantee Protection Level",null,null,null,null,null,{"$f":"'[12]Minimum Funding Guarantee'!$R$3-1","v":4.9999999999998934E-3}]
[]
["2023/24 Guaranteed Unit Funding",null,null,null,null,null,null,null,null,{"$f":"J34*(1+G36)","v":4975.9344938710892}]
[]
[]
["Guaranteed Funding Level Calculation"]
[]
["2023/24 Guaranteed Unit Funding",null,null,null,null,null,{"$f":"J38","v":4975.9344938710892}]
[]
["October 2022 Pupil Number",null,null,null,null,null,{"$f":"_xlfn.XLOOKUP(\"P\"&$N$3,'[12]Minimum Funding Guarantee'!$A:$A,'[12]Minimum Funding Guarantee'!$E:$E)","v":727},{"$f":"INDEX('[13]Minimum Funding Guarantee'!$H:$H,MATCH(\"P\"&$N$3,'[13]Minimum Funding Guarantee'!$A:$A,0))","v":3618765.8539006351}]
[]
["2023/24 Guaranteed Funding Level",null,null,null,null,null,null,null,null,{"$f":"G43*G45","v":3617504.3770442819}]
[]
["Add:"]
["2023/24 Rates",null,null,null,null,null,{"$f":"_xlfn.XLOOKUP(\"P\"&$N$3,'[12]Minimum Funding Guarantee'!$A:$A,'[12]Minimum Funding Guarantee'!$Z:$Z)","v":87552},{"$f":"INDEX('[13]Minimum Funding Guarantee'!$H:$H,MATCH(\"P\"&$N$3,'[13]Minimum Funding Guarantee'!$A:$A,0))","v":3618765.8539006351}]
[]
["2023/24 Lump Sum",null,null,null,null,null,{"$f":"_xlfn.XLOOKUP(\"P\"&$N$3,'[12]Minimum Funding Guarantee'!$A:$A,'[12]Minimum Funding Guarantee'!$Y:$Y)","v":128432.63999999998},{"$f":"INDEX('[13]Minimum Funding Guarantee'!$H:$H,MATCH(\"P\"&$N$3,'[13]Minimum Funding Guarantee'!$A:$A,0))","v":3618765.8539006351}]
[]
["2023/24 Split Site",null,null,null,null,null,{"$f":"_xlfn.XLOOKUP(\"P\"&$N$3,'[12]Minimum Funding Guarantee'!$A:$A,'[12]Minimum Funding Guarantee'!$AA:$AA)","v":0},{"$f":"INDEX('[13]Minimum Funding Guarantee'!$H:$H,MATCH(\"P\"&$N$3,'[13]Minimum Funding Guarantee'!$A:$A,0))","v":3618765.8539006351},null,{"$f":"SUM(G50,G52)","v":215984.63999999998}]
[]
[]
["2023/24 Minimum Funding Guarantee",null,null,null,null,null,null,null,null,{"$f":"J47+J54","v":3833489.0170442821},null,null,null,{"$f":"_xlfn.XLOOKUP(\"P\"&$N$3,'[12]Minimum Funding Guarantee'!$A:$A,'[12]Minimum Funding Guarantee'!$Q:$Q)-J57","v":0}]
[]
[]
["2023/24 Minimum Funding Guarantee",null,null,null,null,null,{"$f":"J47+J54","v":3833489.0170442821}]
[]
["2023/24 Total Formula Funding allocated pre-MFG",null,null,null,null,null,{"$f":"'Budget Share Statement'!K46","v":3999925.9082521256}]
[]
["2023/24 MFG Protection (additional funding/top-slice)",null,null,null,null,null,null,null,null,{"$f":"IF(G60>G62,G60-G62,0)","v":0},null,null,null,{"$f":"_xlfn.XLOOKUP(\"P\"&$N$3,'[12]Minimum Funding Guarantee'!$A:$A,'[12]Minimum Funding Guarantee'!$V:$V)-J64","v":-3.5478157203068098E-9}]
[]
["Note:"]
["The Minimum Funding Guarantee is compared with your Budget Share before 2023/24 de-delegated budgets are removed."]

{"sheet":"De-delegation","index":4,"n_rows":25,"n_cols":15,"rows_kept":25,"cut":false,"hidden":true,"merged":[[22,2,22,4],[9,2,9,4],[18,2,18,4],[1,0,1,10],[2,0,2,10],[3,0,3,10],[5,0,5,10]]}
[{"$f":"'Summary of Funding'!A1","v":"Date Issued: "},null,null,null,null,null,null,null,null,null,{"$f":"'Summary of Funding'!H1","v":"Last amended: 21st December 2023"}]
["COVENTRY CITY COUNCIL"]
[{"$f":"'Summary of Funding'!A3:H3","v":"2023/24 Funding Allocations for Schools"},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Summary of Funding'!N3","v":16}]
[{"$f":"\"De-Delegation Detail\"","v":"De-Delegation Detail"}]
[]
[{"$f":"_xlfn.XLOOKUP(\"P\"&$N$3,[5]Formula!$A:$A,[5]Formula!$C:$C)","v":"Frederick Bird Primary School"},null,null,null,null,null,null,null,null,null,null," ",null,null,"Checks"]
[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," "]
["Factors",null,"Factor Measurement",null,null,null,"Number\nof Units",null,"Funding\nPer Unit",null,"Funding \nAllocated"]
[null,null,null,null,null,null,null,null,"£",null,"£"]
["Basic Entitlement"]
["Funding"]
["Maternity Cover",null,"Pupil Number: (Oct-22 Census)",null,null,null,{"$f":"INDEX([13]Data!$D:$D,MATCH(\"P\"&$N$3,[13]Data!$A:$A,0))","v":727},null,{"$f":"-'[13]New Del & De-Del'!$G$9","v":-34.130000000000003},null,{"$f":"G14*I14","v":-24812.510000000002},null,null,null,{"$f":"INDEX('[13]New Del & De-Del'!$K:$K,MATCH(\"P\"&$N$3,'[13]New Del & De-Del'!$A:$A,0))+K14","v":0}]
["Trade Union Facility",null,"Pupil Number: (Oct-22 Census)",null,null,null,{"$f":"INDEX([13]Data!$D:$D,MATCH(\"P\"&$N$3,[13]Data!$A:$A,0))","v":727},null,{"$f":"-'[13]New Del & De-Del'!$G$10","v":-4},null,{"$f":"G15*I15","v":-2908},null,null,null,{"$f":"INDEX('[13]New Del & De-Del'!$K:$K,MATCH(\"P\"&$N$3,'[13]New Del & De-Del'!$A:$A,0))+K14","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(K14:K15)","v":-27720.510000000002},null,null,null,{"$f":"INDEX('[13]New Del & De-Del'!$D:$D,MATCH(\"P\"&$N$3,'[13]New Del & De-Del'!$A:$A,0))+K17","v":0}]
["Deprivation Funding"]
["Free School Meal Eligibility",null,"Free School Meals: (Oct-22 FSM Eligibility)",null,null,null,{"$f":"INDEX([13]Data!$T:$T,MATCH(\"P\"&$N$3,[13]Data!$A:$A,0))","v":356.00000000000028},null,{"$f":"-'[13]New Del & De-Del'!$G$7","v":-2.6670904955226922},null,{"$f":"G19*I19","v":-949.48421640607921},null,null,null,{"$f":"INDEX('[13]New Del & De-Del'!$E:$E,MATCH(\"P\"&$N$3,'[13]New Del & De-Del'!$A:$A,0))+K19","v":0}]
[]
["English as an Additional"]
["Language Funding"]
["EMAS: New Arrivals Grant",null,"EAL3:  EAL in child's 1st 3 years of compulsory education",null,null,null,{"$f":"INDEX([13]Data!$AD:$AD,MATCH(\"P\"&$N$3,[13]Data!$A:$A,0))","v":277.33281004709585},null,{"$f":"-'[13]New Del & De-Del'!$G$12","v":-64.582140525189772},null,{"$f":"G23*I23","v":-17910.746510707304},null,null,null,{"$f":"INDEX('[13]New Del & De-Del'!$F:$F,MATCH(\"P\"&$N$3,'[13]New Del & De-Del'!$A:$A,0))+K23","v":0}]
[]
["Total De-Delegation",null,null,null,null,null,null,null,null,null,{"$f":"K17+K19+K23","v":-46580.740727113385},null,null,null,{"$f":"INDEX('[13]New Del & De-Del'!$H:$H,MATCH(\"P\"&$N$3,'[13]New Del & De-Del'!$A:$A,0))+K25","v":0}]

{"sheet":"EYSFF statement","index":5,"n_rows":41,"n_cols":14,"rows_kept":41,"cut":false,"hidden":true,"merged":[[1,0,1,10],[2,0,2,10],[3,0,3,10],[5,0,5,10],[8,4,8,6],[8,8,8,10]]}
[{"$f":"'Summary of Funding'!A1","v":"Date Issued: "},null,null,null,null,null,null,null,null,null,{"$f":"'Summary of Funding'!H1","v":"Last amended: 21st December 2023"}]
["COVENTRY CITY COUNCIL"]
[{"$f":"'Summary of Funding'!A3:H3","v":"2023/24 Funding Allocations for Schools"},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Summary of Funding'!N3","v":16}]
["INDICATIVE Early Years Funding Statement"]
[]
[{"$f":"_xlfn.XLOOKUP(\"P\"&$N$3,[5]Formula!$A:$A,[5]Formula!$C:$C)","v":"Frederick Bird Primary School"},null,null,null,null,null,null,null,null,null,null,null,null,"Checks"]
[]
[]
["School Data",null,null,null,"Summer Term Rates",null,null,null,"Autumn & Spring Rates"]
[null,null,null,null,"Free Entitlement",null,"Extended Entitlement",null,"Free Entitlement",null,"Extended Entitlement"]
["January 2023 Headcount ",null,null,null,{"$f":"_xlfn.IFNA(_xlfn.XLOOKUP(\"P\"&$N$3,'[5]Early Years Formula'!$A:$A,'[5]Early Years Formula'!$D:$D),0)","v":70},null,{"$f":"_xlfn.IFNA(_xlfn.XLOOKUP(\"P\"&$N$3,'[5]Early Years Formula'!$A:$A,'[5]Early Years Formula'!$D:$D),0)","v":70},null,{"$f":"_xlfn.IFNA(_xlfn.XLOOKUP(\"P\"&$N$3,'[5]Early Years Formula'!$A:$A,'[5]Early Years Formula'!$D:$D),0)","v":70},null,{"$f":"_xlfn.IFNA(_xlfn.XLOOKUP(\"P\"&$N$3,'[5]Early Years Formula'!$A:$A,'[5]Early Years Formula'!$D:$D),0)","v":70}]
["IDACI based on January 2023 census",null,null,null,{"$f":"_xlfn.IFNA(_xlfn.XLOOKUP(\"P\"&$N$3,'[5]Early Years Formula'!$A:$A,'[5]Early Years Formula'!$E:$E),0)","v":0.35007142857142876},null,{"$f":"_xlfn.IFNA(_xlfn.XLOOKUP(\"P\"&$N$3,'[5]Early Years Formula'!$A:$A,'[5]Early Years Formula'!$E:$E),0)","v":0.35007142857142876},null,{"$f":"_xlfn.IFNA(_xlfn.XLOOKUP(\"P\"&$N$3,'[5]Early Years Formula'!$A:$A,'[5]Early Years Formula'!$E:$E),0)","v":0.35007142857142876},null,{"$f":"_xlfn.IFNA(_xlfn.XLOOKUP(\"P\"&$N$3,'[5]Early Years Formula'!$A:$A,'[5]Early Years Formula'!$E:$E),0)","v":0.35007142857142876}]
["Universal Base Rate",null,null,null,{"$f":"'[5]Early Years Formula'!$D$2","v":4.43},null,{"$f":"'[5]Early Years Formula'!$D$2","v":4.43},null,{"$f":"'[5]Early Years Formula'!$D$3","v":4.8099999999999996},null,{"$f":"'[5]Early Years Formula'!$D$3","v":4.8099999999999996}]
["Universal Deprivation Rate",null,null,null,{"$f":"'[5]Early Years Formula'!$E$2","v":1.33},null,{"$f":"'[5]Early Years Formula'!$E$2","v":1.33},null,{"$f":"'[5]Early Years Formula'!$E$3","v":1.44},null,{"$f":"'[5]Early Years Formula'!$E$3","v":1.44}]
[]
[]
[null,null,null,null,"Summer \nTerm 2023",null,"Autumn\nTerm 2023",null,"Spring\nTerm 2024",null,"Whole\nFinancial Year"]
[null,null,null,null,"(12 Weeks)",null,"(15 Weeks)",null,"(11 Weeks)",null,"(38 Weeks)"]
[null,null,null,null,"(Per May 23 census)",null,"(Per Oct 23 census)",null,"(Per Jan 22 census)"]
["Formula Factors",null,null,null,"Updated",null,"Updated",null,"To be updated"]
["Free Entitlement Headcount",null,null,null,{"$f":"_xlfn.IFNA(_xlfn.XLOOKUP(\"P\"&$N$3,'[5]Early Years Formula'!$A:$A,'[5]Early Years Formula'!$I:$I),0)","v":77},null,{"$f":"_xlfn.IFNA(_xlfn.XLOOKUP(\"P\"&$N$3,'[12]Early Years Formula'!$A:$A,'[12]Early Years Formula'!$P:$P),0)","v":67},null,{"$f":"_xlfn.IFNA(_xlfn.XLOOKUP(\"P\"&$N$3,'[5]Early Years Formula'!$A:$A,'[5]Early Years Formula'!$W:$W),0)","v":77}]
["Free Entitlement Hours Provided",null,null,null,{"$f":"_xlfn.IFNA(_xlfn.XLOOKUP(\"P\"&$N$3,'[5]Early Years Formula'!$A:$A,'[5]Early Years Formula'!$H:$H),0)","v":13860},null,{"$f":"_xlfn.IFNA(_xlfn.XLOOKUP(\"P\"&$N$3,'[12]Early Years Formula'!$A:$A,'[12]Early Years Formula'!$O:$O),0)","v":15075},null,{"$f":"_xlfn.IFNA(_xlfn.XLOOKUP(\"P\"&$N$3,'[5]Early Years Formula'!$A:$A,'[5]Early Years Formula'!$V:$V),0)","v":12705}]
["Extended Entitlement Headcount",null,null,null,{"$f":"_xlfn.IFNA(_xlfn.XLOOKUP(\"P\"&$N$3,'[5]Early Years Formula'!$A:$A,'[5]Early Years Formula'!$K:$K),0)","v":0},null,{"$f":"_xlfn.IFNA(_xlfn.XLOOKUP(\"P\"&$N$3,'[12]Early Years Formula'!$A:$A,'[12]Early Years Formula'!$R:$R),0)","v":0},null,{"$f":"_xlfn.IFNA(_xlfn.XLOOKUP(\"P\"&$N$3,'[5]Early Years Formula'!$A:$A,'[5]Early Years Formula'!$Y:$Y),0)","v":0}]
["Extended Entitlement Hours Provided",null,null,null,{"$f":"_xlfn.IFNA(_xlfn.XLOOKUP(\"P\"&$N$3,'[5]Early Years Formula'!$A:$A,'[5]Early Years Formula'!$J:$J),0)","v":0},null,{"$f":"_xlfn.IFNA(_xlfn.XLOOKUP(\"P\"&$N$3,'[12]Early Years Formula'!$A:$A,'[12]Early Years Formula'!$Q:$Q),0)","v":0},null,{"$f":"_xlfn.IFNA(_xlfn.XLOOKUP(\"P\"&$N$3,'[5]Early Years Formula'!$A:$A,'[5]Early Years Formula'!$X:$X),0)","v":0}]
[]
["Base Rate Funding",null,null,null,{"$f":"IFERROR((E22+E24)*$E13,0)","v":61399.799999999996},null,{"$f":"IFERROR((G22+G24)*$I13,0)","v":72510.75},null,{"$f":"IFERROR((I22+I24)*$I13,0)","v":61111.049999999996}]
[]
["Deprivation Funding",null,null,null,{"$f":"IFERROR((E21+E23)*$E$14*15*12*$E$12,0)","v":6453.1467000000048},null,{"$f":"IFERROR((G21+G23)*$I$14*15*15*$I$12,0)","v":7599.3505714285739},null,{"$f":"IFERROR((I21+I23)*$I$14*15*11*$I$12,0)","v":6404.6268000000027}]
[]
["Total 2023/24 Funding Under EYSFF (£)",null,null,null,{"$f":"E28+E26","v":67852.9467},null,{"$f":"G28+G26","v":80110.100571428571},null,{"$f":"I28+I26","v":67515.676800000001},null,{"$f":"E30+G30+I30","v":215478.72407142859},null,null,{"$f":"_xlfn.IFNA(_xlfn.XLOOKUP(\"P\"&$N$3,'[5]Early Years Formula'!$A:$A,'[12]Early Years Formula'!$AC:$AC),0)-K30","v":0}]
[]
[]
["Note:"]
["This Early Years budget has been estimated based on full participation at the 22/23 census levels and 23/24 hourly rates"]
[]
["At this point in time, you will have the best knowledge of relevant pupil numbers and as such are in the best position to estimate "]
["what the EYSFF funding position will be. Work with your SFO's to make an estimate and work through the financial implications."]
[]
["Your actual Early Years funding will be updated through the year to reflect the actual provision delivered as recorded on the"]
["Summer-23, Autumn-23 and Spring-24 school census information. As in previous years, this means that your Early Years"]
["funding will not be finalised until after the Spring 2024 census has been finalised."]

{"sheet":"Further Delegation Info","index":6,"n_rows":26,"n_cols":14,"rows_kept":26,"cut":false,"hidden":true,"merged":[[8,0,9,7],[1,0,1,7],[2,0,2,7],[3,0,3,7],[4,0,4,7],[5,0,5,7],[6,0,6,7],[10,0,13,7],[16,0,17,0],[16,1,17,1],[16,2,16,4],[16,5,16,7]]}
[{"$f":"'Summary of Funding'!A1","v":"Date Issued: "},null,null,null,null,null,null,{"$f":"'Summary of Funding'!H1","v":"Last amended: 21st December 2023"},null,null,null,null,null,"ID"]
["COVENTRY CITY COUNCIL"]
[{"$f":"'Summary of Funding'!A3:H3","v":"2023/24 Funding Allocations for Schools"}]
["Further Delegation Information"]
[]
["All Schools"]
[]
[]
["The 2013/14 School Funding Reform required local authorities to delegate some centrally retained DSG budgets to schools; those budgets are listed below in the columns headed \"Delegated in 2013/14\" for your information.\n"]
[]
["For 2023/24 maintained schools have opted to return some of this funding to the Local Authority to continue central provision of the relevant services. The delegated budget available to each maintained school therefore excludes these returned budgets. The relevant amounts are listed below in the columns headed \"De-delegation in 2023/24\" for your reference."]
[]
[]
[]
[]
[]
["S251 line","Further Delegation Areas","Delegated in 2013/14",null,null,"De-delegation in 2023/24"]
[null,null,"Primary\n(all)\n£","Secondary\n(all)\n£","Total\n(all)\n£","Primary\nMaintained\n£","Secondary\nMaintained\n£","Total\nMaintained\n£"]
["1.1.4","Free school meal eligibility",20899.321122915815,11151.538623932094,32050.859746847909,{"$f":"'[13]New Del & De-Del'!$I$7","v":13807.527495320977},0,{"$f":"SUM(F19:G19)","v":13807.527495320977}]
["1.1.7","Licences/subscriptions",56639.723182411013,35735.642889017559,92375.36607142858,{"$f":"'[15]New Del & De-Del'!$I$8","v":0},0,{"$f":"SUM(F20:G20)","v":0}]
["1.1.8","Maternity/special staffing suspension",356766.17682212021,225094.12075930767,581860.29758142785,{"$f":"'[13]New Del & De-Del'!$I$9","v":667616.93000000005},0,667616.93000000005]
["1.1.9","Trade Union facility",195944.4399044039,123627.02600013438,319571.46590453829,{"$f":"'[13]New Del & De-Del'!$I$10","v":78244},0,78244]
["1.1.10","School Improvement",0,0,0,{"$f":"'[15]New Del & De-Del'!$I$11","v":0},0,0]
["1.1.3","Ethnic Minority Acheivement Service (EMAS)",991053,284303,1275356,{"$f":"'[13]New Del & De-Del'!$I$12","v":269792.01321676781},0,269792.01321676781]
["1.1.2","Behaviour support services",310504,256781,567285,{"$f":"-'[15]New Del & De-Del'!$I$13","v":0},{"$f":"-'[16]New Del & De-Del'!$J13","v":0},0]
[null,"Totals",{"$f":"SUM(C19:C25)","v":1931806.6610318511},936692.32827239169,2868498.9893042427,1029460.4707120889,0,1029460.4707120889,null,{"$f":"H26-'[13]New Del & De-Del'!$K$14","v":0}]

{"sheet":"ISB","index":7,"n_rows":40,"n_cols":10,"rows_kept":40,"cut":false,"hidden":true,"merged":[[1,0,1,5],[2,0,2,5],[4,0,4,5],[7,0,11,5]]}
[{"$f":"'Summary of Funding'!A1","v":"Date Issued: "},null,null,null,null,{"$f":"'Summary of Funding'!H1","v":"Last amended: 21st December 2023"},null,null,null,"ID"]
["COVENTRY CITY COUNCIL"]
["2023/24 Funding Allocations for Schools"]
[]
["Individual Schools Budget (ISB) 2023/24"]
[]
[]
["This page shows how the Individual Schools Budget (ISB), which is the total of all schools block delegated budget shares, has changed from the previous year. It shows the financial effect, in overall budget terms, of policy and funding decisions in terms of the increased or decreased level of resources for schools. The final ISB figure represents the total level of resources which go into the Fair Funding Formula to produce schools budget shares."]
[]
[]
[]
[]
[]
[null,null,"Schools ","Schools"]
[null,null,"Block","Block"]
[null,null,"(Primary)","(Secondary)"]
[null,null,"£","£"]
[]
[null,"FINAL ISB 2022/23",{"$f":"'[17]PPR (New Blocks)'!$E$9","v":144279729.32221356},{"$f":"'[17]PPR (New Blocks)'!$F$9","v":127380350.92539436}]
[]
[null,"Removal of 2022/23 expenditure funded by reserves",{"$f":"'[17]PPR (New Blocks)'!$E$11","v":-240718.13121172786},{"$f":"'[17]PPR (New Blocks)'!$F$11","v":-209281.86878824234}]
[]
[]
[null,"Revised Base for 2022/23",{"$f":"SUM(C19:C23)","v":144039011.19100183},{"$f":"SUM(D19:D23)","v":127171069.05660611}]
[]
[null,"Resource Adjustments"]
[null,"De-delegation adjustments",{"$f":"'[17]PPR (New Blocks)'!$E$22+'[17]PPR (New Blocks)'!$E$23","v":-169962.18489664851}]
[null,"NFF - Additional resource",{"$f":"'[17]PPR (New Blocks)'!$E$35","v":1969057.2063330924},{"$f":"'[17]PPR (New Blocks)'!$F$35","v":2556152.7553559002}]
[null,"NFF - supplementary funding rolled into DSG",{"$f":"'[17]PPR (New Blocks)'!$E$40","v":4010343.2988999998},{"$f":"'[17]PPR (New Blocks)'!$F$40","v":3770414.0700000003}]
[]
[null,"Education Service PPR"]
[null,"Pupil number changes",{"$f":"'[17]PPR (New Blocks)'!$E$57+'[17]PPR (New Blocks)'!$E$58","v":2965093.4902130626},{"$f":"'[17]PPR (New Blocks)'!$F$57+'[17]PPR (New Blocks)'!$F$58","v":5722866.6865245048}]
[null,"PFI Factor Change",null,{"$f":"'[17]PPR (New Blocks)'!$F$36","v":77159.812160000089}]
[]
[]
[null,"FINAL ISB 2023/24",{"$f":"SUM(C24:C35)","v":152813543.00155136},{"$f":"SUM(D24:D35)","v":139297662.3806465}]
[]
[]
[]
["If you have any queries about any of this information, please contact Paul Hammond 7697 2635"]

{"sheet":"LogIn","index":8,"n_rows":85,"n_cols":3,"rows_kept":85,"cut":false,"hidden":true,"merged":[]}
["User Name","Password","ID"]
["Alderman's Green ","NcR96Na",1]
["Aldermoor Farm","8UBcN4",2]
["Allesley","uE98HX",3]
["Allesley Hall","c2r66H",4]
["Broad Heath","94ctnJ",5]
["Cannon Park","4V8gK4",6]
["Charter","bHkpG8a",7]
["Clifford Bridge ","VksmRa1a",8]
["Coundon Primary","4Y428c",9]
["Courthouse Green","BE75nX1a",10]
["Earlsdon","ZkcST6",11]
["Eastern Green Junior","24x4Xc",12]
["Edgewick","R3kRR4",13]
["Ernesford Grange","GKD5A2",14]
["Finham","9TWJzm1a",15]
["Frederick Bird","agw9kd",16]
["Gosford Park ","cuxXcd",17]
["Grange Farm","V2DGxe",18]
["Grangehurst","aFbkW3",19]
["Hearsall ","3JcVC31a",20]
["Henley Green","J5cwAZ",21]
["Hill Farm Academy","8S7cc81a",22]
["Holbrook ","GkEHwt",23]
["Hollyfast","D4N45K",24]
["Howes","ccAeb5",25]
["John Gulson","26cA4V",26]
["John Shelton","B8cds4",27]
["Joseph Cash ","33GsH6",28]
["Keresley Grange","RPPyVD1a",29]
["Limbrick Wood ","uk7NEQ",30]
["Little Heath","Av3kpb",31]
["Longford Park ","79byb7",32]
["Manor Park","MkRSqT",33]
["Moathouse","7URcPj",34]
["Moseley","FHQ99Q",35]
["Mount Nod","t9C84k",36]
["Parkgate","vk7KgW1a",37]
["Parkhill","CDXegf",38]
["Pearl Hyde","j3MNSS1a",39]
["Potters Green","YEy8sy",40]
["Radford Academy","p43M6w1a",41]
["Ravensdale","APVTV2",42]
["Richard Lee","hAt28j1a",43]
["Sir Frank Whittle","GX72Yc1a",44]
["St. Christopher","47967b",45]
["Southfields ","5Wbz28",46]
["Sowe Valley","CmbnbG",47]
["Spon Gate ","kyX882",48]
["Stanton Bridge ","334HJR1a",49]
["Stivichall","7Qc6H3",50]
["Stoke","6R28Wf",51]
["Stoke Heath","abbM4V",52]
["Templars","X23zbq",53]
["Whitley Abbey","64t3u4",54]
["Whitmore Park","bY76ab",55]
["Whoberley Hall","Q6kTTB",56]
["Willenhall Community","rHAW8H",57]
["Wyken Croft","U4pEJ3",58]
["All Saints' CE","BgJH5H",59]
["All Souls' RC","5dQG7T",60]
["Christ the King RC Primary","AbcSYP1a",61]
["Corpus Christi RC","E446Hn1a",62]
["St Laurance's CE Academy","j877qE1a",63]
["Good Shepherd RC","ZX6bRM1a",64]
["Holy Family RC","y8FdX4",65]
["Leigh CE","y5ZNQz1a",66]
["Our Lady of the Assumption RC","6f89MQ",67]
["Sacred Heart RC","4n6E5w1a",68]
["St. Andrew's CE Infant","zS5569",69]
["St. Anne's RC","H2YK64",70]
["St. Augustine's RC","cAb7FY1a",71]
["St. Bartholomew's Academy","CPKbKb1a",72]
["St. Elizabeth's RC","2s47541a",73]
["St. Gregory's RC","YHzVS61a",74]
["St. John Fisher RC","G97Ncj1a",75]
["St. John Vianney RC","RkP3wb1a",76]
["St. John's CE","WV25551a",77]
["St. Mary's & St. Benedict's RC","hNW6cM",78]
["St. Osburg's RC","D7UP4r",79]
["St. Patrick's RC","6bP7aV1a",80]
["Sts. Peter & Paul RC","K43Jb31a",81]
["St. Thomas More RC","Kc3rR81a",82]
["Stretton CE Academy","BMJT831a",83]
["Walsgrave CE","DM93SH1a",84]

{"sheet":"LoginPage","index":9,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Funding Floor","index":10,"n_rows":42,"n_cols":14,"rows_kept":42,"cut":false,"hidden":true,"merged":[[1,0,1,11],[2,0,2,11],[3,0,3,11],[5,0,5,11],[15,8,15,9],[19,8,19,9],[33,8,33,9],[8,8,8,9],[31,8,31,9],[21,8,21,9],[26,8,26,9],[13,8,13,9],[17,8,17,9]]}
[{"$f":"'Summary of Funding'!A1","v":"Date Issued: "},null,null,null,null,null,null,null,null,null,null,{"$f":"'Summary of Funding'!H1","v":"Last amended: 21st December 2023"}]
["COVENTRY CITY COUNCIL - PEOPLE'S DIRECTORATE"]
[{"$f":"'Summary of Funding'!A3:H3","v":"2023/24 Funding Allocations for Schools"},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Summary of Funding'!N3","v":16}]
["Calculation of Funding Floor"]
[]
[{"$f":"VLOOKUP((\"P\"&N3),[18]Formula!$A$10:$X$96,3,FALSE)","v":"Frederick Bird"},null,null,null,null,null,null,null,null,null,null,null,null,"Checks"]
[]
[]
[null,null,null,null,null,null,null,null,"£",null,null,"£"]
[]
["2020/21 Total funding allocated after MFL",null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP((\"P\"&$N$3),'[19]Funding Floor'!$A$3:$U$90,6,FALSE)","v":3499492.7230638112},null,{"$f":"VLOOKUP((\"P\"&$N$3),'[19]Funding Floor'!$A$3:$U$90,6,FALSE)-L11","v":0}]
[]
["Less: "]
["2020/21 Mobility",null,null,null,null,null,null,null,{"$f":"VLOOKUP((\"P\"&$N$3),'[19]Funding Floor'!$A$3:$U$90,7,FALSE)","v":10715.274028038593},{"$f":"VLOOKUP((\"P\"&$N$3),'[19]Funding Floor'!$A$3:$U$90,6,FALSE)","v":3499492.7230638112},null,null,null,{"$f":"VLOOKUP((\"P\"&$N$3),'[19]Funding Floor'!$A$3:$U$90,7,FALSE)-I14","v":0}]
[]
["2020/21 Lump Sum",null,null,null,null,null,null,null,{"$f":"VLOOKUP((\"P\"&$N$3),'[19]Funding Floor'!$A$3:$U$90,8,FALSE)","v":110364.09999999999},{"$f":"VLOOKUP((\"P\"&$N$3),'[19]Funding Floor'!$A$3:$U$90,6,FALSE)","v":3499492.7230638112},null,null,null,{"$f":"VLOOKUP((\"P\"&$N$3),'[19]Funding Floor'!$A$3:$U$90,8,FALSE)-I16","v":0}]
[]
["2020/21 Split Site",null,null,null,null,null,null,null,{"$f":"VLOOKUP((\"P\"&$N$3),'[19]Funding Floor'!$A$3:$U$90,9,FALSE)","v":0},{"$f":"VLOOKUP((\"P\"&$N$3),'[19]Funding Floor'!$A$3:$U$90,6,FALSE)","v":3499492.7230638112},null,null,null,{"$f":"VLOOKUP((\"P\"&$N$3),'[19]Funding Floor'!$A$3:$U$90,9,FALSE)-I18","v":0}]
[]
["2020/21 Rates Funding",null,null,null,null,null,null,null,{"$f":"VLOOKUP((\"P\"&$N$3),'[19]Funding Floor'!$A$3:$U$90,11,FALSE)","v":77146.75},{"$f":"VLOOKUP((\"P\"&$N$3),'[19]Funding Floor'!$A$3:$U$90,6,FALSE)","v":3499492.7230638112},null,null,null,{"$f":"VLOOKUP((\"P\"&$N$3),'[19]Funding Floor'!$A$3:$U$90,11,FALSE)-I20","v":0}]
[]
["2020/21 Education Improvement Commissioning Pot",null,null,null,null,null,null,null,{"$f":"VLOOKUP((\"P\"&$N$3),'[19]Funding Floor'!$A$3:$U$90,12,FALSE)","v":7103.4081138533966},{"$f":"VLOOKUP((\"P\"&$N$3),'[19]Funding Floor'!$A$3:$U$90,6,FALSE)","v":3499492.7230638112},null,{"$f":"-SUM(I14:I22)","v":-205329.53214189198},null,{"$f":"VLOOKUP((\"P\"&$N$3),'[19]Funding Floor'!$A$3:$U$90,12,FALSE)-I22","v":0}]
[]
[]
["2020/21 Pupil Led Funding",null,null,null,null,null,null,null,null,null,null,{"$f":"L11+L22","v":3294163.1909219194},null,{"$f":"VLOOKUP((\"P\"&$N$3),'[19]Funding Floor'!$A$3:$U$90,15,FALSE)-L25","v":0}]
[]
["October 2019 Pupil Number",null,null,null,null,null,null,"[A]",{"$f":"VLOOKUP((\"P\"&$N$3),'[19]Funding Floor'!$A$3:$U$90,17,FALSE)","v":786},{"$f":"VLOOKUP((\"P\"&$N$3),'[19]Funding Floor'!$A$3:$U$90,6,FALSE)","v":3499492.7230638112},null,null,null,{"$f":"VLOOKUP((\"P\"&$N$3),'[19]Funding Floor'!$A$3:$U$90,17,FALSE)-I27","v":0}]
[]
["2020/21 Pupil Led Funding (per pupil)",null,null,null,null,null,null,"[B]",null,null,null,{"$f":"L25/I27","v":4191.047316694554},null,{"$f":"VLOOKUP((\"P\"&$N$3),'[19]Funding Floor'!$A$3:$U$90,18,FALSE)-L29","v":0}]
[]
[]
["2017/18 calculated Funding Floor (FF) per Pupil ",null,null,null,null,null,null,null,{"$f":"VLOOKUP((\"P\"&$N$3),'[19]Funding Floor'!$A$3:$U$90,4,FALSE)","v":4181.5766000000003},{"$f":"VLOOKUP((\"P\"&$N$3),'[19]Funding Floor'!$A$3:$U$90,6,FALSE)","v":3499492.7230638112},null,null,null,{"$f":"VLOOKUP((\"P\"&$N$3),'[19]Funding Floor'!$A$3:$U$90,4,FALSE)-I32","v":0}]
[]
["2020/21 Funding Floor protection level",null,null,null,null,null,null,null,0.01]
[]
["Funding Floor per pupil",null,null,null,null,null,null,"[C]",null,null,null,{"$f":"I32*(1+I34)","v":4223.392366}]
[]
["Shortfall to Funding Floor per pupil",null,null,null,null,null,null,"[D] = [C] - [B]",null,null,null,{"$f":"IF(L29<L36,L36-L29,0)","v":32.345049305446082}]
[]
[]
[]
["2020/21 Funding Floor Adjustment",null,null,null,null,null,null,"= [A] x [D]",null,null,null,{"$f":"L38*I27","v":25423.208754080621},null,{"$f":"VLOOKUP((\"P\"&$N$3),'[19]Funding Floor'!$A$3:$U$90,21,FALSE)-L42","v":3.2014213502407074E-10}]