{"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":27,"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":51,"n_cols":14,"rows_kept":51,"cut":false,"hidden":true,"merged":[[19,0,19,3],[2,0,2,7],[3,0,3,7],[5,0,5,7],[1,0,1,7],[9,0,9,2]]}
["Date Issued: 13th October 2025",null,null,null,null,null,null,"Last amended:10th October 2025"]
["COVENTRY CITY COUNCIL"]
["2025/26 Funding Allocations for Schools",null,null,null,null,null,null,null,null,null,null,null,null,50]
["INDICATIVE Summary of Funding"]
[]
[{"$f":"_xlfn.XLOOKUP(\"P\"&$N$3,'[5]Minimum Funding Guarantee'!$A:$A,'[5]Minimum Funding Guarantee'!$C:$C)","v":"Stivichall 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 2025/26",null,null,null,null,{"$f":"'Budget Share Statement'!K58","v":2619475.91314812},null,null,null,null,null,null,null,{"$f":"F12-'Budget Share Statement'!K58","v":0}]
[]
["Indicative Early Years Funding 2025/26* (to be updated)",null,null,null,null,{"$f":"'EYSFF statement'!K30","v":0},null,null,null,null,null,null,null,{"$f":"F14-'EYSFF statement'!K30","v":0}]
[]
["Early Years Funding Adjustment 2024/25#",null,null,null,null,{"$f":"_xlfn.IFNA(_xlfn.XLOOKUP(\"P\"&$N$3,'[6]25-26 adj'!$A:$A,'[6]25-26 adj'!$F:$F),0)","v":0}]
[]
[null,null,null,null,null,null,null,{"$f":"SUM(F12,F14,F16)","v":2619475.91314812},null,null,null,null,null,{"$f":"N12+N14","v":0}]
[]
["Other 2025/26 Funding Elements "]
[]
["National Insurance Contribution Grant",null,null,null,null,{"$f":"_xlfn.XLOOKUP(\"P\"&$N$3,[7]School_Level!$AC:$AC,[7]School_Level!$AB:$AB)+_xlfn.IFNA(_xlfn.XLOOKUP(\"P\"&$N$3,[8]Sheet1!$A:$A,[8]Sheet1!$M:$M),0)","v":46083}]
[]
["Indicative Pupil Premium Grant † (excludes LAC & EYPP elements)",null,null,null,null,{"$f":"_xlfn.XLOOKUP(\"P\"&$N$3,[9]Allocations!$A$1:$A$65536,[9]Allocations!$V$1:$V$65536)","v":53655}]
[]
["Indicative High Needs Top-up Funding §",null,null,null,null,{"$f":"_xlfn.XLOOKUP(\"P\"&$N$3,'[10]Band 5-6 Delegation Summer Info'!$A:$A,'[10]Band 5-6 Delegation Summer Info'!$M:$M)+_xlfn.XLOOKUP(\"P\"&$N$3,'[10]Band 5-6 Delegation Autumn Info'!$A:$A,'[10]Band 5-6 Delegation Autumn Info'!$P:$P)+_xlfn.XLOOKUP(\"P\"&$N$3,'[10]Band 5-6 Delegation Spring Info'!$A:$A,'[10]Band 5-6 Delegation Spring Info'!$P:$P)","v":142760.32000000001}]
[]
["Class Size Funding ",null,null,null,null,{"$f":"_xlfn.XLOOKUP(N3,'[11]Class size'!$A:$A,'[11]Class size'!$N:$N)","v":0}]
[]
["Bulge Class Second Year Funding",null,null,null,null,{"$f":"_xlfn.IFNA(_xlfn.XLOOKUP(\"P\"&$N$3,'[11]Bulge Class 2nd Year'!$R:$R,'[11]Bulge Class 2nd Year'!$T:$T),0)","v":0}]
[]
["Disproportionate SEN",null,null,null,null,{"$f":"-_xlfn.XLOOKUP(\"P\"&$N$3,[12]Sheet1!$C:$C,[12]Sheet1!$T:$T)","v":85057.503811626913}]
[]
[null,null,null,null,null,null,null,{"$f":"F24+F26+F28+F32+F22+F30","v":327555.82381162693}]
[]
["Total Revenue Resources",null,null,null,null,null,null,{"$f":"H18+H34","v":2947031.736959747},null,null,null,null,null,{"$f":"N12+N14+N24+N26+N28+N18","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'!N55),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 2025/26."]
["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 estimated based on participation at the 24/25 census levels for Aut-25 and  Spr-26 and"]
[" actual participation level for Sum-25- please see the EYSFF statement for further detail."]
["# Due to a pupil number error relating to Summer 24 that was not corrected until after the end of financial year 2024/25,"]
[" we have had to include an additional line adjusting Early Years funding. This adjustment is a reduction in funding for a small"]
["number of schools. Your SFO’s have been made aware of this & the adjustment should already be built into your 2025/26 budget plans."]
["† Pupil Premium Funding has been updated to reflect 25/26 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 in 2024/25"]
["using 2025/26 funding rates for Aut-25 and Spr-26. Sum-25 is based on actual pupils on high needs bandings. This figure "]
["will change based on the real time movement of pupils during the 2025/26 financial year and so will not be final until March 2026."]

{"sheet":"Budget Share Statement","index":1,"n_rows":61,"n_cols":15,"rows_kept":61,"cut":false,"hidden":true,"merged":[[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],[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]]}
[{"$f":"'Summary of Funding'!A1","v":"Date Issued: 13th October 2025"},null,null,null,null,null,null,null,null,null,{"$f":"'Summary of Funding'!H1","v":"Last amended:10th October 2025"}]
["COVENTRY CITY COUNCIL"]
[{"$f":"'Summary of Funding'!A3:H3","v":"2025/26 Funding Allocations for Schools"},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Summary of Funding'!N3","v":50}]
["INDICATIVE School Budget Share Statement"]
[]
[{"$f":"_xlfn.XLOOKUP(\"P\"&$N$3,'[5]Minimum Funding Guarantee'!$A:$A,'[5]Minimum Funding Guarantee'!$C:$C)","v":"Stivichall 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-24 Census)",null,null,null,{"$f":"_xlfn.XLOOKUP(\"P\"&$N$3,[13]Data!$A:$A,[13]Data!$G:$G)","v":533},null,{"$f":"[13]Formula!$D$2","v":3860.54144},null,{"$f":"G13*I13","v":2057668.5875200001},null,null,null,{"$f":"_xlfn.XLOOKUP(\"P\"&$N$3,[13]Formula!$A:$A,[13]Formula!$D:$D)-K13","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,{"$f":"K13","v":2057668.5875200001}]
[]
["Deprivation Funding",null,"IDACI Band G:  Pupil's IDACI < 0.20",null,null,null,{"$f":"_xlfn.XLOOKUP(\"P\"&$N$3,[13]Data!$A:$A,[13]Data!$V:$V)","v":489.99999999999983},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,[13]Data!$A:$A,[13]Data!$W:$W)","v":24.999999999999986},null,{"$f":"[13]Formula!$N$2","v":235.8272},null,{"$f":"G18*I18","v":5895.6799999999967}," ",null,null,{"$f":"_xlfn.XLOOKUP(\"P\"&$N$3,[13]Formula!$A:$A,[13]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,[13]Data!$A:$A,[13]Data!$X:$X)","v":8},null,{"$f":"[13]Formula!$O$2","v":286.00319999999999},null,2288.0255999999999," ",null,null,{"$f":"_xlfn.XLOOKUP(\"P\"&$N$3,[13]Formula!$A:$A,[13]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,[13]Data!$A:$A,+[13]Data!$Y:$Y)","v":8},null,{"$f":"[13]Formula!$P$2","v":446.56639999999999},null,3572.5311999999999," ",null,null,{"$f":"_xlfn.XLOOKUP(\"P\"&$N$3,[13]Formula!$A:$A,[13]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,[13]Data!$A:$A,[13]Data!$Z:Z)","v":0},null,{"$f":"[13]Formula!$Q$2","v":491.72479999999996},null,0,null,null,null,{"$f":"_xlfn.XLOOKUP(\"P\"&$N$3,[13]Formula!$A:$A,[13]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,[13]Data!$A:$A,[13]Data!$AA:$AA)","v":2},null,{"$f":"[13]Formula!$R$2","v":521.83039999999994},null,1043.6607999999999,null,null,null,{"$f":"_xlfn.XLOOKUP(\"P\"&$N$3,[13]Formula!$A:$A,[13]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,[13]Data!$A:$A,[13]Data!$AB:$AB)","v":0},null,{"$f":"[13]Formula!$S$2","v":687.41120000000001},null,0,null,null,null,{"$f":"_xlfn.XLOOKUP(\"P\"&$N$3,[13]Formula!$A:$A,[13]Formula!$S:$S)-K23","v":0}]
[null,null,"Free School Meals: (Oct-24 FSM Eligibility)",null,null,null,{"$f":"_xlfn.XLOOKUP(\"P\"&$N$3,[13]Data!$A:$A,[13]Data!$T:$T)","v":26.000000000000028},null,{"$f":"[13]Formula!$E$2","v":496.74239999999998},null,12915.302400000013,null,null,null,{"$f":"_xlfn.XLOOKUP(\"P\"&$N$3,[13]Formula!$A:$A,[13]Formula!$E:$E)-K24","v":0}]
[null,null,"Free School Meals Ever 6: (Oct-24 FSM Eligibility)",null,null,null,{"$f":"_xlfn.XLOOKUP(\"P\"&$N$3,[13]Data!$A:$A,[13]Data!$U:$U)","v":26.000000000000028},null,{"$f":"[13]Formula!$F$2","v":1063.7311999999999},null,27657.01120000003,null,null,null,{"$f":"_xlfn.XLOOKUP(\"P\"&$N$3,[13]Formula!$A:$A,[13]Formula!$F:$F)-K25","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(K17:K25)","v":53372.211200000042}]
[]
["Prior Attainment Funding",null,"No.pupils not reaching expected level of development",null,null,null,{"$f":"_xlfn.XLOOKUP(\"P\"&$N$3,[13]Data!$A:$A,[13]Data!$AC:$AC)","v":88.334628880549857},null,{"$f":"[13]Formula!$G$2","v":1179.136},null,{"$f":"G29*I29","v":104158.54095969604},null,null,null,{"$f":"_xlfn.XLOOKUP(\"P\"&$N$3,[13]Formula!$A:$A,[13]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,[13]Data!$A:$A,[13]Data!$AD:$AD)","v":45.58552631578948},null,{"$f":"[13]Formula!$H$2","v":597.09439999999995},null,{"$f":"G32*I32","v":27218.862484210527},null,null,null,{"$f":"_xlfn.XLOOKUP(\"P\"&$N$3,[13]Formula!$A:$A,[13]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,[13]Data!$A:$A,[13]Data!$AE:$AE)","v":0},null,{"$f":"[13]Formula!$I$2","v":968.39679999999998},null,{"$f":"G34*I34","v":0},null,null,null,{"$f":"_xlfn.XLOOKUP(\"P\"&$N$3,[13]Formula!$A:$A,[13]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,[13]Formula!$A:$A,[13]Formula!$J:$J)","v":145610.75200000001},null,null,null,{"$f":"_xlfn.XLOOKUP(\"P\"&$N$3,[13]Formula!$A:$A,[13]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,[13]Formula!$A:$A,[13]Formula!$L:$L)","v":0},null,null,null,{"$f":"_xlfn.XLOOKUP(\"P\"&$N$3,[13]Formula!$A:$A,[13]Formula!$L:$L)-K38","v":0}]
[]
["Rates Funding",null,"Estimated 2025/26 rates bill",null,null,null,null,{"$f":"_xlfn.XLOOKUP(\"P\"&$N$3,[13]Formula!$A:$A,[13]Formula!$K:$K)","v":84630},{"$f":"INDEX([14]Formula!$J:$J,MATCH(\"P\"&$N$3,[14]Formula!$A:$A,0))-E40","v":128432.63999999998},null,{"$f":"H40","v":84630},null,null,null,{"$f":"_xlfn.XLOOKUP(\"P\"&$N$3,[13]Formula!$A:$A,[13]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":2472658.9541639066},null,null,null,{"$f":"_xlfn.XLOOKUP(\"P\"&$N$3,[13]Formula!$A:$A,[13]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":252986.04583609337},null,null,null,null,null,null,{"$f":"ROUND(_xlfn.XLOOKUP(\"P\"&$N$3,[13]Formula!$A:$A,[13]Formula!$V:$V),2)-H44","v":4.1639066184870899E-3}]
[]
["Total Funding Allocated before Minimum Funding Guarantee (MFG)",null,null,null,null,null,null,null,null,null,{"$f":"K42+H44","v":2725645},null,null,null,{"$f":"_xlfn.XLOOKUP(\"P\"&$N$3,[13]Formula!$A:$A,[13]Formula!$W:$W)-K46","v":0}]
[]
["MFG Protection (additional funding/top-slice)",null,null,null,null,null,null,{"$f":"'MFG Calculation'!J62","v":0},null,null,null,null,null,null,{"$f":"ROUND(_xlfn.XLOOKUP(\"P\"&$N$3,[13]Formula!$A:$A,[13]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":2725645},null,null,null,{"$f":"_xlfn.XLOOKUP(\"P\"&$N$3,[13]Formula!$A:$A,[13]Formula!$AA:$AA)-K50","v":0}]
[]
["25/26 De-delegation",null,"See separate 'De-delegation' sheet",null,null,null,null,{"$f":"'De-delegation'!K25","v":-21539.086851879998},null,null,null,null,null,null,{"$f":"ROUND(_xlfn.XLOOKUP(\"P\"&$N$3,[13]Formula!$A:$A,[13]Formula!$AB:$AB),2)-H52","v":-3.1481200021516997E-3}]
[]
["25/26 Risk Protection Arrangement Deduction",null,null,null,null,null,null,{"$f":"-IFERROR(_xlfn.XLOOKUP(\"P\"&$N$3,'[15]LAMS Data'!$AH:$AH,'[15]LAMS Data'!$AE:$AE),0)","v":0}]
[]
["25/26 Business Rates Deduction",null,null,null,null,null,null,{"$f":"-H40","v":-84630}]
[]
["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":2619475.91314812},null,null,null,{"$f":"ROUND(_xlfn.XLOOKUP(\"P\"&$N$3,[13]Formula!$A:$A,[13]Formula!$AC:$AC),2)-K58+H56+H54","v":-3.1481198966503143E-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: 13th October 2025"},null,null,null,null,null,null,null,null,null,{"$f":"'Summary of Funding'!H1","v":"Last amended:10th October 2025"}]
["COVENTRY CITY COUNCIL"]
[{"$f":"'Summary of Funding'!A3:H3","v":"2025/26 Funding Allocations for Schools"},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Summary of Funding'!N3","v":50}]
["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":"Stivichall 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":"'[13]Minimum Per Pupil'!$D$3","v":4955},null,null,null,null,null,null,{"$f":"'[13]Minimum Per Pupil'!$D$3-G10","v":0}]
[]
["October 2024 Pupil Numbers",null,null,null,null,null,{"$f":"_xlfn.XLOOKUP(\"P\"&$N$3,'[13]Minimum Per Pupil'!$A:$A,'[13]Minimum Per Pupil'!$D:$D)","v":533},null,null,null,null,null,null,{"$f":"_xlfn.XLOOKUP(\"P\"&$N$3,'[13]Minimum Per Pupil'!$A:$A,'[13]Minimum Per Pupil'!$D:$D)-G12","v":0}]
[]
["Minimum Funding Level (MFL)",null,null,null,null,"[A]",null,null,null,{"$f":"G10*G12","v":2641015},null,null,null,{"$f":"_xlfn.XLOOKUP(\"P\"&$N$3,'[13]Minimum Per Pupil'!$A:$A,'[13]Minimum Per Pupil'!$E:$E)-J14","v":0}]
[]
[]
["Total Formula Factor Funding",null,null,null,null,null,{"$f":"'Budget Share Statement'!K42","v":2472658.9541639066},null,null,null,null,null,null,{"$f":"_xlfn.XLOOKUP(\"P\"&$N$3,'[13]Minimum Per Pupil'!$A:$A,'[13]Minimum Per Pupil'!$G:$G)-G17","v":0}]
[]
["Less: exempt premises factors"]
["2025/26 NNDR",null,null,null,null,null,{"$f":"_xlfn.XLOOKUP(\"P\"&$N$3,[13]Formula!$A:$A,[13]Formula!$K:$K)","v":84630},{"$f":"INDEX([14]Formula!$K:$K,MATCH(\"P\"&$N$3,[14]Formula!$A:$A,0))-A20","v":{"$error":"#VALUE!"}},null,null,null,null,null,{"$f":"_xlfn.XLOOKUP(\"P\"&$N$3,[13]Formula!$A:$A,[13]Formula!$K:$K)-G20","v":0}]
[]
["2025/26 Split Site",null,null,null,null,null,{"$f":"_xlfn.XLOOKUP(\"P\"&$N$3,[13]Formula!$A:$A,[13]Formula!$L:$L)","v":0},{"$f":"INDEX([14]Formula!$K:$K,MATCH(\"P\"&$N$3,[14]Formula!$A:$A,0))-A22","v":{"$error":"#VALUE!"}},null,null,null,null,null,{"$f":"_xlfn.XLOOKUP(\"P\"&$N$3,[13]Formula!$A:$A,[13]Formula!$L:$L)-G22","v":0}]
[]
[]
["2025/26 Funding for MFL comparison",null,null,null,null,"[B]",null,null,null,{"$f":"G17-SUM(G20:G22)","v":2388028.9541639066},null,null,null,{"$f":"_xlfn.XLOOKUP(\"P\"&$N$3,'[13]Minimum Per Pupil'!$A:$A,'[13]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":252986.04583609337},null,null,null,{"$f":"_xlfn.XLOOKUP(\"P\"&$N$3,'[13]Minimum Per Pupil'!$A:$A,'[13]Minimum Per Pupil'!$M:$M)-J28","v":4.6566128730773926E-10}]

{"sheet":"MFG Calculation","index":3,"n_rows":65,"n_cols":14,"rows_kept":65,"cut":false,"hidden":true,"merged":[[1,0,1,10],[2,0,2,10],[3,0,3,10],[5,0,5,10],[17,6,17,7],[8,6,8,7],[57,6,57,7],[59,6,59,7],[10,6,10,7],[49,6,49,7],[15,6,15,7],[29,6,29,7],[13,6,13,7],[27,6,27,7],[51,6,51,7],[42,6,42,7],[47,6,47,7],[33,6,33,7],[40,6,40,7],[20,6,20,7]]}
[{"$f":"'Summary of Funding'!A1","v":"Date Issued: 13th October 2025"},null,null,null,null,null,null,null,null,null,{"$f":"'Summary of Funding'!H1","v":"Last amended:10th October 2025"}]
["COVENTRY CITY COUNCIL"]
[{"$f":"'Summary of Funding'!A3:H3","v":"2025/26 Funding Allocations for Schools"},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Summary of Funding'!N3","v":50}]
["Calculation of Minimum Funding Guarantee"]
[]
[{"$f":"_xlfn.XLOOKUP(\"P\"&$N$3,[5]Formula!$A:$A,[5]Formula!$C:$C)","v":"Stivichall Primary School"},null,null,null,null,null,null,null,null,null,null,null,null,"Checks"]
[]
[]
["Baseline",null,{"$f":"IF(N55>=0,\" \",\"DOES NOT BALANCE\")","v":" "},null,null,null,"£",null,null,"£"]
[]
["Final Budget Share 2024/25(Excluding Early Years)",null,null,null,null,null,null,null,null,{"$f":"_xlfn.XLOOKUP(\"P\"&$N$3,'[13]Minimum Funding Guarantee'!$A:$A,'[13]Minimum Funding Guarantee'!$H:$H)","v":2532540}]
[]
["Less:"]
["2024/25 Rates Funding",null,null,null,null,null,{"$f":"_xlfn.XLOOKUP(\"P\"&$N$3,'[13]Minimum Funding Guarantee'!$A:$A,'[13]Minimum Funding Guarantee'!$J:$J)","v":84630},{"$f":"_xlfn.XLOOKUP(\"P\"&$N$3,'[16]Minimum Funding Guarantee'!$A:$A,'[16]Minimum Funding Guarantee'!$H:$H)","v":2385744}]
[]
["2025/26 Lump Sum",null,null,null,null,null,{"$f":"_xlfn.XLOOKUP(\"P\"&$N$3,'[13]Minimum Funding Guarantee'!$A:$A,'[13]Minimum Funding Guarantee'!$I:$I)","v":145610.75200000001},{"$f":"INDEX('[14]Minimum Funding Guarantee'!$H:$H,MATCH(\"P\"&$N$3,'[14]Minimum Funding Guarantee'!$A:$A,0))","v":2299029}]
[]
["2024/25 Split Site",null,null,null,null,null,{"$f":"_xlfn.XLOOKUP(\"P\"&$N$3,'[13]Minimum Funding Guarantee'!$A:$A,'[13]Minimum Funding Guarantee'!$L:$L)","v":0},{"$f":"INDEX('[14]Minimum Funding Guarantee'!$H:$H,MATCH(\"P\"&$N$3,'[14]Minimum Funding Guarantee'!$A:$A,0))","v":2299029},null,{"$f":"-SUM(G14,G16,G18)","v":-230240.75200000001}]
[]
["Add:"]
["2024/25 Supplementary Grant",null,null,null,null,null,{"$f":"_xlfn.XLOOKUP(\"P\"&$N$3,'[13]Minimum Funding Guarantee'!$A:$A,'[13]Minimum Funding Guarantee'!$M:$M)","v":158347.3854},{"$f":"INDEX('[14]Minimum Funding Guarantee'!$H:$H,MATCH(\"P\"&$N$3,'[14]Minimum Funding Guarantee'!$A:$A,0))","v":2299029},null,{"$f":"G21","v":158347.3854}]
[]
["Adjusted Budget Share 2024/25",null,null,null,null,null,null,null,null,{"$f":"J11+J18+J21","v":2460646.6334000002},null,null,null,{"$f":"_xlfn.XLOOKUP(\"P\"&$N$3,'[13]Minimum Funding Guarantee'!$A:$A,'[13]Minimum Funding Guarantee'!$N:$N)-J23","v":0}]
[]
[]
["Guaranteed Unit Funding Calculation",null,null,null,null,null,null,null,null,"£"]
[]
["Adjusted Budget Share 2024/25",null,null,null,null,null,{"$f":"J23","v":2460646.6334000002}]
[]
["October 2023 Pupil Number",null,null,null,null,null,{"$f":"_xlfn.XLOOKUP(\"P\"&$N$3,'[13]Minimum Funding Guarantee'!$A:$A,'[13]Minimum Funding Guarantee'!$D:$D)","v":531},{"$f":"INDEX('[14]Minimum Funding Guarantee'!$H:$H,MATCH(\"P\"&$N$3,'[14]Minimum Funding Guarantee'!$A:$A,0))","v":2299029}]
[]
["Adjusted Budget Share 2024/25 Per Pupil",null,null,null,null,null,null,null,null,{"$f":"G28/G30","v":4633.9861269303201},null,null,null,{"$f":"_xlfn.XLOOKUP(\"P\"&$N$3,'[13]Minimum Funding Guarantee'!$A:$A,'[13]Minimum Funding Guarantee'!$O:$O)-J32","v":0}]
[]
["Minimum Funding Guarantee Protection Level",null,null,null,null,null,{"$f":"'[13]Minimum Funding Guarantee'!$R$3-1","v":0}]
[]
["2025/26 Guaranteed Unit Funding",null,null,null,null,null,null,null,null,{"$f":"J32*(1+G34)","v":4633.9861269303201}]
[]
[]
["Guaranteed Funding Level Calculation"]
[]
["2025/26 Guaranteed Unit Funding",null,null,null,null,null,{"$f":"J36","v":4633.9861269303201}]
[]
["October 2024 Pupil Number",null,null,null,null,null,{"$f":"_xlfn.XLOOKUP(\"P\"&$N$3,'[13]Minimum Funding Guarantee'!$A:$A,'[13]Minimum Funding Guarantee'!$E:$E)","v":533},{"$f":"INDEX('[14]Minimum Funding Guarantee'!$H:$H,MATCH(\"P\"&$N$3,'[14]Minimum Funding Guarantee'!$A:$A,0))","v":2299029}]
[]
["2025/26 Guaranteed Funding Level",null,null,null,null,null,null,null,null,{"$f":"G41*G43","v":2469914.6056538606}]
[]
["Add:"]
["2025/26 Rates",null,null,null,null,null,{"$f":"_xlfn.XLOOKUP(\"P\"&$N$3,'[13]Minimum Funding Guarantee'!$A:$A,'[13]Minimum Funding Guarantee'!$Z:$Z)","v":84630},{"$f":"INDEX('[14]Minimum Funding Guarantee'!$H:$H,MATCH(\"P\"&$N$3,'[14]Minimum Funding Guarantee'!$A:$A,0))","v":2299029}]
[]
["2025/26 Lump Sum",null,null,null,null,null,{"$f":"_xlfn.XLOOKUP(\"P\"&$N$3,'[13]Minimum Funding Guarantee'!$A:$A,'[13]Minimum Funding Guarantee'!$Y:$Y)","v":145610.75200000001},{"$f":"INDEX('[14]Minimum Funding Guarantee'!$H:$H,MATCH(\"P\"&$N$3,'[14]Minimum Funding Guarantee'!$A:$A,0))","v":2299029}]
[]
["2025/26 Split Site",null,null,null,null,null,{"$f":"_xlfn.XLOOKUP(\"P\"&$N$3,'[13]Minimum Funding Guarantee'!$A:$A,'[13]Minimum Funding Guarantee'!$AA:$AA)","v":0},{"$f":"INDEX('[14]Minimum Funding Guarantee'!$H:$H,MATCH(\"P\"&$N$3,'[14]Minimum Funding Guarantee'!$A:$A,0))","v":2299029},null,{"$f":"SUM(G48,G50)","v":230240.75200000001}]
[]
[]
["2025/26 Minimum Funding Guarantee",null,null,null,null,null,null,null,null,{"$f":"J45+J52","v":2700155.3576538605},null,null,null,{"$f":"_xlfn.XLOOKUP(\"P\"&$N$3,'[13]Minimum Funding Guarantee'!$A:$A,'[13]Minimum Funding Guarantee'!$Q:$Q)-J55","v":0}]
[]
[]
["2025/26 Minimum Funding Guarantee",null,null,null,null,null,{"$f":"J45+J52","v":2700155.3576538605}]
[]
["2025/26 Total Formula Funding allocated pre-MFG",null,null,null,null,null,{"$f":"'Budget Share Statement'!K46","v":2725645}]
[]
["2025/26 MFG Protection (additional funding/top-slice)",null,null,null,null,null,null,null,null,{"$f":"_xlfn.XLOOKUP(\"P\"&$N$3,'[13]Minimum Funding Guarantee'!$A:$A,'[13]Minimum Funding Guarantee'!$V:$V)","v":0},null,null,null,{"$f":"_xlfn.XLOOKUP(\"P\"&$N$3,'[13]Minimum Funding Guarantee'!$A:$A,'[13]Minimum Funding Guarantee'!$V:$V)-J62","v":0}]
[]
["Note:"]
["The Minimum Funding Guarantee is compared with your Budget Share before 2024/25 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: 13th October 2025"},null,null,null,null,null,null,null,null,null,{"$f":"'Summary of Funding'!H1","v":"Last amended:10th October 2025"}]
["COVENTRY CITY COUNCIL"]
[{"$f":"'Summary of Funding'!A3:H3","v":"2025/26 Funding Allocations for Schools"},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Summary of Funding'!N3","v":50}]
[{"$f":"\"De-Delegation Detail\"","v":"De-Delegation Detail"}]
[]
[{"$f":"_xlfn.XLOOKUP(\"P\"&$N$3,[5]Formula!$A:$A,[5]Formula!$C:$C)","v":"Stivichall 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-24 Census)",null,null,null,{"$f":"_xlfn.XLOOKUP(\"P\"&$N$3,[13]Data!$A:$A,[13]Data!$D:$D)","v":533},null,{"$f":"-'[13]New Del & De-Del'!$G$9","v":-33.02218303254952},null,{"$f":"G14*I14","v":-17600.823556348896},null,null,null,{"$f":"ROUND(_xlfn.XLOOKUP(\"P\"&$N$3,'[13]New Del & De-Del'!$A:$A,'[13]New Del & De-Del'!$K:$K)+K14,0)","v":0}]
["Trade Union Facility",null,"Pupil Number: (Oct-24 Census)",null,null,null,{"$f":"_xlfn.XLOOKUP(\"P\"&$N$3,[13]Data!$A:$A,[13]Data!$D:$D)","v":533},null,{"$f":"-'[13]New Del & De-Del'!$G$10","v":-4},null,{"$f":"G15*I15","v":-2132},null,null,null,{"$f":"ROUND(_xlfn.XLOOKUP(\"P\"&$N$3,'[13]New Del & De-Del'!$A:$A,'[13]New Del & De-Del'!$L:$L)+K15,0)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(K14:K15)","v":-19732.823556348896},null,null,null,{"$f":"ROUND(_xlfn.XLOOKUP(\"P\"&$N$3,'[13]New Del & De-Del'!$A:$A,'[13]New Del & De-Del'!$D:$D)+K17,0)","v":0}]
["Deprivation Funding"]
["Free School Meal Eligibility",null,"Free School Meals: (Oct-24 FSM Eligibility)",null,null,null,{"$f":"_xlfn.XLOOKUP(\"P\"&$N$3,[13]Data!$A:$A,[13]Data!$T:$T)","v":26.000000000000028},null,{"$f":"-'[13]New Del & De-Del'!$G$7","v":-2.5836717916820144},null,{"$f":"G19*I19","v":-67.175466583732444},null,null,null,{"$f":"ROUND(_xlfn.XLOOKUP(\"P\"&$N$3,'[13]New Del & De-Del'!$A:$A,'[13]New Del & De-Del'!$E:$E)+K19,0)","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":"_xlfn.XLOOKUP(\"P\"&$N$3,[13]Data!$A:$A,[13]Data!$AD:$AD)","v":45.58552631578948},null,{"$f":"-'[13]New Del & De-Del'!$G$12","v":-38.15},null,{"$f":"G23*I23","v":-1739.0878289473685},null,null,null,{"$f":"ROUND(_xlfn.XLOOKUP(\"P\"&$N$3,'[13]New Del & De-Del'!$A:$A,'[13]New Del & De-Del'!$F:$F)+K23,0)","v":0}]
[]
["Total De-Delegation",null,null,null,null,null,null,null,null,null,{"$f":"K17+K19+K23","v":-21539.086851879998},null,null,null,{"$f":"ROUND(_xlfn.XLOOKUP(\"P\"&$N$3,'[13]New Del & De-Del'!$A:$A,'[13]New Del & De-Del'!$H:$H)+K25,0)","v":0}]

{"sheet":"EYSFF statement","index":5,"n_rows":42,"n_cols":14,"rows_kept":42,"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: 13th October 2025"},null,null,null,null,null,null,null,null,null,{"$f":"'Summary of Funding'!H1","v":"Last amended:10th October 2025"}]
["COVENTRY CITY COUNCIL"]
[{"$f":"'Summary of Funding'!A3:H3","v":"2025/26 Funding Allocations for Schools"},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Summary of Funding'!N3","v":50}]
["INDICATIVE Early Years Funding Statement"]
[]
[{"$f":"_xlfn.XLOOKUP(\"P\"&$N$3,[5]Formula!$A:$A,[5]Formula!$C:$C)","v":"Stivichall Primary School"},null,null,null,null,null,null,null,null,null,null,null,null,"Checks"]
[]
[]
["School Data",null,null,null,"Early Years Rates"]
[null,null,null,null,"Free Entitlement",null,"Extended Entitlement"]
["January 2024 Headcount "]
["IDACI based on January 2025 census",null,null,null,{"$f":"_xlfn.IFNA(_xlfn.XLOOKUP(\"P\"&$N$3,[17]Sheet1!$A:$A,[17]Sheet1!$D:$D),0)","v":0},null,{"$f":"_xlfn.IFNA(_xlfn.XLOOKUP(\"P\"&$N$3,[17]Sheet1!$A:$A,[17]Sheet1!$D:$D),0)","v":0}]
["Universal Base Rate",null,null,null,5.21,null,5.21]
["Universal Deprivation Rate",null,null,null,1.56,null,1.56]
[]
[]
[null,null,null,null,"Summer \nTerm 2025",null,"Autumn\nTerm 2025",null,"Spring\nTerm 2026",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 25 census)",null,"(Per Oct 24 census)",null,"(Per Jan 25 census)"]
["Formula Factors",null,null,null,"Updated",null,"To be updated",null,"To be updated"]
["Free Entitlement Headcount",null,null,null,{"$f":"_xlfn.IFNA(_xlfn.XLOOKUP(\"P\"&$N$3,[17]Sheet1!$A:$A,[17]Sheet1!$H:$H),0)","v":0},null,{"$f":"_xlfn.IFNA(_xlfn.XLOOKUP(\"P\"&$N$3,[18]Sheet1!$A:$A,[18]Sheet1!$P:$P),0)","v":0},null,{"$f":"_xlfn.IFNA(_xlfn.XLOOKUP(\"P\"&$N$3,[6]Sheet1!$A:$A,[6]Sheet1!$W:$W),0)","v":0}]
["Free Entitlement Hours Provided",null,null,null,{"$f":"_xlfn.IFNA(_xlfn.XLOOKUP(\"P\"&$N$3,[17]Sheet1!$A:$A,[17]Sheet1!$G:$G),0)","v":0},null,{"$f":"_xlfn.IFNA(_xlfn.XLOOKUP(\"P\"&$N$3,[18]Sheet1!$A:$A,[18]Sheet1!$O:$O),0)/14*15","v":0},null,{"$f":"_xlfn.IFNA(_xlfn.XLOOKUP(\"P\"&$N$3,[6]Sheet1!$A:$A,[6]Sheet1!$V:$V),0)/12*11","v":0}]
["Extended Entitlement Headcount",null,null,null,{"$f":"_xlfn.IFNA(_xlfn.XLOOKUP(\"P\"&$N$3,[17]Sheet1!$A:$A,[17]Sheet1!$J:$J),0)","v":0},null,{"$f":"_xlfn.IFNA(_xlfn.XLOOKUP(\"P\"&$N$3,[18]Sheet1!$A:$A,[18]Sheet1!$R:$R),0)","v":0},null,{"$f":"_xlfn.IFNA(_xlfn.XLOOKUP(\"P\"&$N$3,[6]Sheet1!$A:$A,[6]Sheet1!$Y:$Y),0)","v":0}]
["Extended Entitlement Hours Provided",null,null,null,{"$f":"_xlfn.IFNA(_xlfn.XLOOKUP(\"P\"&$N$3,[17]Sheet1!$A:$A,[17]Sheet1!$I:$I),0)","v":0},null,{"$f":"_xlfn.IFNA(_xlfn.XLOOKUP(\"P\"&$N$3,[18]Sheet1!$A:$A,[18]Sheet1!$Q:$Q),0)/14*15","v":0},null,{"$f":"_xlfn.IFNA(_xlfn.XLOOKUP(\"P\"&$N$3,[6]Sheet1!$A:$A,[6]Sheet1!$X:$X),0)/12*11","v":0}]
[]
["Base Rate Funding",null,null,null,{"$f":"IFERROR((E22+E24)*$E13,0)","v":0},null,{"$f":"IFERROR((G22+G24)*$E13,0)","v":0},null,{"$f":"IFERROR((I22+I24)*$E13,0)","v":0}]
[]
["Deprivation Funding",null,null,null,{"$f":"IFERROR((E21+E23)*$E$14*15*12*$E$12,0)","v":0},null,{"$f":"IFERROR((G21+G23)*$E$14*15*15*$E$12,0)","v":0},null,{"$f":"IFERROR((I21+I23)*$E$14*15*11*$E$12,0)","v":0}]
[]
["Total 2025/26 Funding Under EYSFF (£)",null,null,null,{"$f":"E28+E26","v":0},null,{"$f":"G28+G26","v":0},null,{"$f":"I28+I26","v":0},null,{"$f":"E30+G30+I30","v":0}]
[]
[]
["Note:"]
["This Early Years budget has been estimated based on full participation at the 24/25 census levels for  Autumn-25 and"]
["Spring-26 using the 25/26 hourly rates. Summer-25 is calculated using Summer-25 census."]
[]
["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"]
["Autumn-25 and Spring-26 school census information. As in previous years, this means that your Early Years"]
["funding will not be finalised until after the Spring 2026 census has been finalised."]

{"sheet":"Further Delegation Info","index":6,"n_rows":26,"n_cols":14,"rows_kept":26,"cut":false,"hidden":true,"merged":[[10,0,13,7],[16,0,17,0],[16,1,17,1],[16,2,16,4],[16,5,16,7],[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]]}
[{"$f":"'Summary of Funding'!A1","v":"Date Issued: 13th October 2025"},null,null,null,null,null,null,{"$f":"'Summary of Funding'!H1","v":"Last amended:10th October 2025"},null,null,null,null,null,"ID"]
["COVENTRY CITY COUNCIL"]
[{"$f":"'Summary of Funding'!A3:H3","v":"2025/26 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 2025/26 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 2025/26\" for your reference."]
[]
[]
[]
[]
[]
["S251 line","Further Delegation Areas","Delegated in 2013/14",null,null,"De-delegation in 2025/26"]
[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":12618.653030574955},0,{"$f":"SUM(F19:G19)","v":12618.653030574955}]
["1.1.7","Licences/subscriptions",56639.723182411013,35735.642889017559,92375.36607142858,{"$f":"'[13]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":634124.98077404848},0,634124.98077404848]
["1.1.9","Trade Union facility",195944.4399044039,123627.02600013438,319571.46590453829,{"$f":"'[13]New Del & De-Del'!$I$10","v":76812},0,76812]
["1.1.10","School Improvement",0,0,0,{"$f":"'[13]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":170150.26113277586},0,170150.26113277586]
["1.1.2","Behaviour support services",310504,256781,567285,{"$f":"'[13]New Del & De-Del'!$I$13","v":0},{"$f":"-'[19]New Del & De-Del'!$J13","v":0},0]
[null,"Totals",{"$f":"SUM(C19:C25)","v":1931806.6610318511},936692.32827239169,2868498.9893042427,893705.89493739931,0,893705.89493739931,null,{"$f":"H26-'[13]New Del & De-Del'!$K$14","v":0}]

{"sheet":"ISB","index":7,"n_rows":36,"n_cols":12,"rows_kept":36,"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: 13th October 2025"},null,null,null,null,{"$f":"'Summary of Funding'!H1","v":"Last amended:10th October 2025"},null,null,null,"ID"]
["COVENTRY CITY COUNCIL"]
["2025/26 Funding Allocations for Schools"]
[]
["Individual Schools Budget (ISB) 2025/26"]
[]
[]
["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 2024/25",163158443.90403911,152121843.09596092,null,null,null,null,null,null,null,{"$f":"[20]Schools_block_and_CSSB!$J$5-[20]Schools_block_and_CSSB!$I$5","v":315280287}]
[]
[null,"Resource Adjustments"]
[null,"De-delegation adjustments",{"$f":"[21]Formula!$AB$93-[22]Formula!$AB$93","v":-6404.092868394102},null,null,null,null,null,null,null,null,{"$f":"C22","v":-6404.092868394102}]
[null,"NFF - Additional resource",{"$f":"(L23*(C19/(C19+D19)))-147938","v":833811.581221845},{"$f":"(L23*(D19/(C19+D19)))+147938","v":1063278.6479041425},null,null,null,null,null,null,null,{"$f":"[23]Schools_block_and_CSSB!$J$7-[20]Schools_block_and_CSSB!$J$8-L24+[24]Formula!$AB$93","v":1897090.2291259873}]
[null,"NFF - TPAG, TPECG and CSBG funding rolled into DSG",{"$f":"'[21]Minimum Funding Guarantee'!$M$93-'[21]Minimum Funding Guarantee'!$M$90+'[21]Minimum Funding Guarantee'!$M$129","v":11100186.915671073},{"$f":"'[21]Minimum Funding Guarantee'!$M$122+'[21]Minimum Funding Guarantee'!$M$130","v":11124288.186028928},null,null,null,null,null,null,null,{"$f":"'[24]Minimum Funding Guarantee'!$M$125","v":22224475.1017}]
[null,"Pupil number changes funding",{"$f":"[23]Schools_block_and_CSSB!$C$19","v":1640141.9200000002},{"$f":"[23]Schools_block_and_CSSB!$D$19-204","v":1734147.605},null,null,null,null,null,null,null,{"$f":"C25+D25-204","v":3374085.5250000004}]
[]
[null,"Education Service PPR"]
[]
[null,"Pupil data changes",{"$f":"[25]Summary!$B$10","v":497807.0399999998},{"$f":"SUM([25]Summary!$C$3:$C$9)+[25]Summary!$D$2","v":777600.41865401505},null,null,null,null,null,null,null,{"$f":"C29+D29","v":1275407.4586540149}]
[null,"Capping and Scaling",{"$f":"SUM([21]Formula!$Z$7,[21]Formula!$Z$9:$Z$17,[21]Formula!$Z$19:$Z$32,[21]Formula!$Z$34:$Z$36,[21]Formula!$Z$38:$Z$51,[21]Formula!$Z$53:$Z$54,[21]Formula!$Z$56,[21]Formula!$Z$58:$Z$64,[21]Formula!$Z$67:$Z$73,[21]Formula!$Z$76:$Z$81,[21]Formula!$Z$84:$Z$86,[21]Formula!$Z$88:$Z$92)","v":-558007.87877906021},{"$f":"SUM([21]Formula!$Z$104:$Z$105,[21]Formula!$Z$107:$Z$108,[21]Formula!$Z$110:$Z$121,[21]Formula!$Z$124)+204","v":-717399.2178581811},null,null,null,null,null,null,null,{"$f":"C30+D30","v":-1275407.0966372413}]
[]
[null,"FINAL ISB 2025/26",{"$f":"SUM(C19:C31)","v":176665979.38928458},{"$f":"SUM(D19:D31)","v":166103758.73568979},null,null,null,null,null,null,null,{"$f":"SUM(L19:L30)","v":342769534.12497431}]
[]
[]
[]
["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","agw9kda",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 ","uk7NEQa",30]
["Little Heath","Av3kpba",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","YEy8sya",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":[[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],[1,0,1,11],[2,0,2,11],[3,0,3,11],[5,0,5,11],[15,8,15,9]]}
[{"$f":"'Summary of Funding'!A1","v":"Date Issued: 13th October 2025"},null,null,null,null,null,null,null,null,null,null,{"$f":"'Summary of Funding'!H1","v":"Last amended:10th October 2025"}]
["COVENTRY CITY COUNCIL - PEOPLE'S DIRECTORATE"]
[{"$f":"'Summary of Funding'!A3:H3","v":"2025/26 Funding Allocations for Schools"},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Summary of Funding'!N3","v":50}]
["Calculation of Funding Floor"]
[]
[{"$f":"VLOOKUP((\"P\"&N3),[26]Formula!$A$10:$X$96,3,FALSE)","v":"Stivichall"},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),'[27]Funding Floor'!$A$3:$U$90,6,FALSE)","v":1871968},null,{"$f":"VLOOKUP((\"P\"&$N$3),'[27]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),'[27]Funding Floor'!$A$3:$U$90,7,FALSE)","v":0},{"$f":"VLOOKUP((\"P\"&$N$3),'[27]Funding Floor'!$A$3:$U$90,6,FALSE)","v":1871968},null,null,null,{"$f":"VLOOKUP((\"P\"&$N$3),'[27]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),'[27]Funding Floor'!$A$3:$U$90,8,FALSE)","v":110364.09999999999},{"$f":"VLOOKUP((\"P\"&$N$3),'[27]Funding Floor'!$A$3:$U$90,6,FALSE)","v":1871968},null,null,null,{"$f":"VLOOKUP((\"P\"&$N$3),'[27]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),'[27]Funding Floor'!$A$3:$U$90,9,FALSE)","v":0},{"$f":"VLOOKUP((\"P\"&$N$3),'[27]Funding Floor'!$A$3:$U$90,6,FALSE)","v":1871968},null,null,null,{"$f":"VLOOKUP((\"P\"&$N$3),'[27]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),'[27]Funding Floor'!$A$3:$U$90,11,FALSE)","v":58968},{"$f":"VLOOKUP((\"P\"&$N$3),'[27]Funding Floor'!$A$3:$U$90,6,FALSE)","v":1871968},null,null,null,{"$f":"VLOOKUP((\"P\"&$N$3),'[27]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),'[27]Funding Floor'!$A$3:$U$90,12,FALSE)","v":4681.3809198168692},{"$f":"VLOOKUP((\"P\"&$N$3),'[27]Funding Floor'!$A$3:$U$90,6,FALSE)","v":1871968},null,{"$f":"-SUM(I14:I22)","v":-174013.48091981685},null,{"$f":"VLOOKUP((\"P\"&$N$3),'[27]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":1697954.5190801832},null,{"$f":"VLOOKUP((\"P\"&$N$3),'[27]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),'[27]Funding Floor'!$A$3:$U$90,17,FALSE)","v":518},{"$f":"VLOOKUP((\"P\"&$N$3),'[27]Funding Floor'!$A$3:$U$90,6,FALSE)","v":1871968},null,null,null,{"$f":"VLOOKUP((\"P\"&$N$3),'[27]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":3277.9044769887705},null,{"$f":"VLOOKUP((\"P\"&$N$3),'[27]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),'[27]Funding Floor'!$A$3:$U$90,4,FALSE)","v":3369.9630000000002},{"$f":"VLOOKUP((\"P\"&$N$3),'[27]Funding Floor'!$A$3:$U$90,6,FALSE)","v":1871968},null,null,null,{"$f":"VLOOKUP((\"P\"&$N$3),'[27]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":3403.6626300000003}]
[]
["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":125.75815301122975}]
[]
[]
[]
["2020/21 Funding Floor Adjustment",null,null,null,null,null,null,"= [A] x [D]",null,null,null,{"$f":"L38*I27","v":65142.723259817009},null,{"$f":"VLOOKUP((\"P\"&$N$3),'[27]Funding Floor'!$A$3:$U$90,21,FALSE)-L42","v":0}]