{"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":47,"n_cols":14,"rows_kept":47,"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: 28th March 2024",null,null,null,null,null,null,"Last amended: 29th February 2024"]
["COVENTRY CITY COUNCIL"]
["2024/25 Funding Allocations for Schools",null,null,null,null,null,null,null,null,null,null,null,null,3]
["INDICATIVE Summary of Funding"]
[]
[{"$f":"_xlfn.XLOOKUP(\"P\"&$N$3,'[5]Minimum Funding Guarantee'!$A:$A,'[5]Minimum Funding Guarantee'!$C:$C)","v":"Allesley Primary School"},null,null,null,null,null,null,null,null,null,null,null,null,"Checks"]
[]
[]
[{"$f":"IF((N34+N35)=0,\"\",\"***ERROR - CALCULATED ADJUSTMENT DOES NOT EQUAL ACTUAL ***\")","v":""}]
["Main Funding Elements"]
[]
["School Budget Share 2024/25",null,null,null,null,{"$f":"'Budget Share Statement'!K58","v":1746326.8629633444},null,null,null,null,null,null,null,{"$f":"F12-'Budget Share Statement'!K58","v":0}]
[]
["Indicative Early Years Funding 2024/25* (to be updated)",null,null,null,null,{"$f":"'EYSFF statement'!K30","v":153175.92674999998},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":1899502.7897133445},null,null,null,null,null,{"$f":"N12+N14","v":0}]
[]
["Other 2024/25 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!$U$1:$U$65536)","v":58340}]
[]
["Indicative High Needs Top-up Funding §",null,null,null,null,{"$f":"VLOOKUP(\"P\"&$N$3,'[7]HN Top-up Calculation'!$A$2:$R$108,18,FALSE)","v":24771.63}]
[]
["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":0}]
[]
["Disproportionate SEN",null,null,null,null,{"$f":"-_xlfn.XLOOKUP(\"P\"&$N$3,[9]Sheet1!$C:$C,[9]Sheet1!$T:$T)","v":21489.731046602807}]
[]
["Indicative Teachers pay additional grant ^",null,null,null,null,{"$f":"_xlfn.XLOOKUP(\"P\"&N3,[10]Sheet1!$Y:$Y,[10]Sheet1!$X:$X)/7*12","v":25656}]
[]
[null,null,null,null,null,null,null,{"$f":"F20+F22+F24+F26+F28+F30","v":130257.3610466028}]
[]
["Total Revenue Resources",null,null,null,null,null,null,{"$f":"H16+H32","v":2029760.1507599473},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'!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 2024/25."]
["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 23/24 census levels for Sum-24, Aut-24 and Spr-25"]
[" - please see the EYSFF statement for further detail."]
["† Pupil Premium Funding is based on your 2023/24 eligibility position but has been updated to reflect the 2024/25 financial year rates. This"]
["allocation will change once 2024/25 eligibility for Pupil Premium is published by the DFE. We will then update this figure."]
["§ Indicative High Needs Top-up Funding has been calculated based on your number of pupils on high needs bandings in 2023/24."]
["Figures will change based on the real time movement of pupils during the 2024/25 financial year so will not be final until March 2025."]
["^ Teachers pay additional grant allocation is an indicative figure - final allocations are due to be published in April 2024."]

{"sheet":"Budget Share Statement","index":1,"n_rows":62,"n_cols":15,"rows_kept":62,"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: 28th March 2024"},null,null,null,null,null,null,null,null,null,{"$f":"'Summary of Funding'!H1","v":"Last amended: 29th February 2024"}]
["COVENTRY CITY COUNCIL"]
[{"$f":"'Summary of Funding'!A3:H3","v":"2024/25 Funding Allocations for Schools"},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Summary of Funding'!N3","v":3}]
["INDICATIVE School Budget Share Statement"]
[]
[{"$f":"_xlfn.XLOOKUP(\"P\"&$N$3,'[5]Minimum Funding Guarantee'!$A:$A,'[5]Minimum Funding Guarantee'!$C:$C)","v":"Allesley 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-23 Census)",null,null,null,{"$f":"_xlfn.XLOOKUP(\"P\"&$N$3,[11]Data!$A:$A,[11]Data!$G:$G)","v":382},null,{"$f":"[11]Formula!$D$2","v":3574.5026199999998},null,{"$f":"G13*I13","v":1365460.0008399999},null,null,null,{"$f":"_xlfn.XLOOKUP(\"P\"&$N$3,[11]Formula!$A:$A,[11]Formula!$D:$D)-K13","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,{"$f":"K13","v":1365460.0008399999}]
[]
["Deprivation Funding",null,"IDACI Band G:  Pupil's IDACI < 0.20",null,null,null,{"$f":"_xlfn.XLOOKUP(\"P\"&$N$3,[11]Data!$A:$A,[11]Data!$V:$V)","v":351.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,[11]Data!$A:$A,[11]Data!$W:$W)","v":9.0000000000000124},null,{"$f":"[11]Formula!$N$2","v":235.82484999999997},null,{"$f":"G18*I18","v":2122.4236500000025}," ",null,null,{"$f":"_xlfn.XLOOKUP(\"P\"&$N$3,[11]Formula!$A:$A,[11]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,[11]Data!$A:$A,[11]Data!$X:$X)","v":12.999999999999982},null,{"$f":"[11]Formula!$O$2","v":286.00034999999997},null,3718.0045499999947," ",null,null,{"$f":"_xlfn.XLOOKUP(\"P\"&$N$3,[11]Formula!$A:$A,[11]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,[11]Data!$A:$A,[11]Data!$Y:$Y)","v":5.0000000000000018},null,{"$f":"[11]Formula!$P$2","v":446.56194999999997},null,2232.8097500000008," ",null,null,{"$f":"_xlfn.XLOOKUP(\"P\"&$N$3,[11]Formula!$A:$A,[11]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,[11]Data!$A:$A,[11]Data!$Z:$Z)","v":0},null,{"$f":"[11]Formula!$Q$2","v":486.70234999999997},null,0,null,null,null,{"$f":"_xlfn.XLOOKUP(\"P\"&$N$3,[11]Formula!$A:$A,[11]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,[11]Data!$A:$A,[11]Data!$AA:$AA)","v":1.0000000000000004},null,{"$f":"[11]Formula!$R$2","v":516.80764999999997},null,516.80765000000019,null,null,null,{"$f":"_xlfn.XLOOKUP(\"P\"&$N$3,[11]Formula!$A:$A,[11]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,[11]Data!$A:$A,[11]Data!$AB:$AB)","v":2.0000000000000009},null,{"$f":"[11]Formula!$S$2","v":682.38679999999988},null,1364.7736000000004,null,null,null,{"$f":"_xlfn.XLOOKUP(\"P\"&$N$3,[11]Formula!$A:$A,[11]Formula!$S:$S)-K23","v":0}]
[null,null,"Free School Meals: (Oct-23 FSM Eligibility)",null,null,null,{"$f":"_xlfn.XLOOKUP(\"P\"&$N$3,[11]Data!$A:$A,[11]Data!$T:$T)","v":28.999999999999982},null,{"$f":"[11]Formula!$E$2","v":491.71989999999994},null,14259.877099999989,null,null,null,{"$f":"_xlfn.XLOOKUP(\"P\"&$N$3,[11]Formula!$A:$A,[11]Formula!$E:$E)-K24","v":0}]
[null,null,"Free School Meals Ever 6: (Oct-23 FSM Eligibility)",null,null,null,{"$f":"_xlfn.XLOOKUP(\"P\"&$N$3,[11]Data!$A:$A,[11]Data!$U:$U)","v":30.000000000000014},null,{"$f":"[11]Formula!$F$2","v":822.87819999999988},null,24686.346000000009,null,null,null,{"$f":"_xlfn.XLOOKUP(\"P\"&$N$3,[11]Formula!$A:$A,[11]Formula!$F:$F)-K25","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(K17:K25)","v":48901.042300000001}]
[]
["Prior Attainment Funding",null,"No.pupils not reaching expected level of development",null,null,null,{"$f":"_xlfn.XLOOKUP(\"P\"&$N$3,[11]Data!$A:$A,[11]Data!$AC:$AC)","v":95.595094110503808},null,{"$f":"[11]Formula!$G$2","v":1174.1066999999998},null,{"$f":"G29*I29","v":112238.84048227304},null,null,null,{"$f":"_xlfn.XLOOKUP(\"P\"&$N$3,[11]Formula!$A:$A,[11]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,[11]Data!$A:$A,[11]Data!$AD:$AD)","v":34.403726708074522},null,{"$f":"[11]Formula!$H$2","v":592.07089999999994},null,{"$f":"G32*I32","v":20369.445435403719},null,null,null,{"$f":"_xlfn.XLOOKUP(\"P\"&$N$3,[11]Formula!$A:$A,[11]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,[11]Data!$A:$A,[11]Data!$AE:$AE)","v":8.0800000000000072},null,{"$f":"[11]Formula!$I$2","v":963.36959999999988},null,{"$f":"G34*I34","v":7784.0263680000062},null,null,null,{"$f":"_xlfn.XLOOKUP(\"P\"&$N$3,[11]Formula!$A:$A,[11]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,[11]Formula!$A:$A,[11]Formula!$J:$J)","v":134871.74399999998},null,null,null,{"$f":"_xlfn.XLOOKUP(\"P\"&$N$3,[11]Formula!$A:$A,[11]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,[11]Formula!$A:$A,[11]Formula!$L:$L)-K38","v":0}]
[]
["Rates Funding",null,"Estimated 2024/25 rates bill",null,null,null,null,{"$f":"_xlfn.XLOOKUP(\"P\"&$N$3,[11]Formula!$A:$A,[11]Formula!$K:$K)","v":53760},{"$f":"INDEX([13]Formula!$J:$J,MATCH(\"P\"&$N$3,[13]Formula!$A:$A,0))-E40","v":128432.63999999998},null,{"$f":"H40","v":53760},null,null,null,{"$f":"_xlfn.XLOOKUP(\"P\"&$N$3,[11]Formula!$A:$A,[11]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":1743385.0994256767},null,null,null,{"$f":"_xlfn.XLOOKUP(\"P\"&$N$3,[11]Formula!$A:$A,[11]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":71394.900574323256},null,null,null,null,null,null,{"$f":"_xlfn.XLOOKUP(\"P\"&$N$3,[11]Formula!$A:$A,[11]Formula!$V:$V)-H44","v":2.3283064365386963E-10}]
[]
["Total Funding Allocated before Minimum Funding Guarantee (MFG)",null,null,null,null,null,null,null,null,null,{"$f":"K42+H44","v":1814780},null,null,null,{"$f":"_xlfn.XLOOKUP(\"P\"&$N$3,[11]Formula!$A:$A,[11]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,[11]Formula!$A:$A,[11]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":1814780},null,null,null,{"$f":"_xlfn.XLOOKUP(\"P\"&$N$3,[11]Formula!$A:$A,[11]Formula!$AA:$AA)-K50","v":0}]
[]
["24/25 De-delegation",null,"See separate 'De-delegation' sheet",null,null,null,null,{"$f":"'De-delegation'!K25","v":-14693.137036655604},null,null,null,null,null,null,{"$f":"ROUND(_xlfn.XLOOKUP(\"P\"&$N$3,[11]Formula!$A:$A,[11]Formula!$AB:$AB),2)-H52","v":-2.9633443955390248E-3}]
[]
["INDICATIVE 24/25 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":0}]
[]
["24/25 Business Rates Deduction",null,null,null,null,null,null,{"$f":"-H40","v":-53760}]
[]
["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":1746326.8629633444},null,null,null,{"$f":"ROUND(_xlfn.XLOOKUP(\"P\"&$N$3,[11]Formula!$A:$A,[11]Formula!$AC:$AC),2)-K58+H56+H54","v":-2.9633443336933851E-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. "]
["This figure is currently indicative based on the 2023/24 deduction. Once deductions are published, this figure will be updated"]

{"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: 28th March 2024"},null,null,null,null,null,null,null,null,null,{"$f":"'Summary of Funding'!H1","v":"Last amended: 29th February 2024"}]
["COVENTRY CITY COUNCIL"]
[{"$f":"'Summary of Funding'!A3:H3","v":"2024/25 Funding Allocations for Schools"},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Summary of Funding'!N3","v":3}]
["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":"Allesley 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":"'[11]Minimum Per Pupil'!$D$3","v":4610},null,null,null,null,null,null,{"$f":"'[11]Minimum Per Pupil'!$D$3-G10","v":0}]
[]
["October 2023 Pupil Numbers",null,null,null,null,null,{"$f":"_xlfn.XLOOKUP(\"P\"&$N$3,'[11]Minimum Per Pupil'!$A:$A,'[11]Minimum Per Pupil'!$D:$D)","v":382},null,null,null,null,null,null,{"$f":"_xlfn.XLOOKUP(\"P\"&$N$3,'[11]Minimum Per Pupil'!$A:$A,'[11]Minimum Per Pupil'!$D:$D)-G12","v":0}]
[]
["Minimum Funding Level (MFL)",null,null,null,null,"[A]",null,null,null,{"$f":"G10*G12","v":1761020},null,null,null,{"$f":"_xlfn.XLOOKUP(\"P\"&$N$3,'[11]Minimum Per Pupil'!$A:$A,'[11]Minimum Per Pupil'!$E:$E)-J14","v":0}]
[]
[]
["Total Formula Factor Funding",null,null,null,null,null,{"$f":"'Budget Share Statement'!K42","v":1743385.0994256767},null,null,null,null,null,null,{"$f":"_xlfn.XLOOKUP(\"P\"&$N$3,'[11]Minimum Per Pupil'!$A:$A,'[11]Minimum Per Pupil'!$G:$G)-G17","v":0}]
[]
["Less: exempt premises factors"]
["2024/25 NNDR",null,null,null,null,null,{"$f":"_xlfn.XLOOKUP(\"P\"&$N$3,[11]Formula!$A:$A,[11]Formula!$K:$K)","v":53760},{"$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,[11]Formula!$A:$A,[11]Formula!$K:$K)-G20","v":0}]
[]
["2024/25 Split Site",null,null,null,null,null,{"$f":"_xlfn.XLOOKUP(\"P\"&$N$3,[11]Formula!$A:$A,[11]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,[11]Formula!$A:$A,[11]Formula!$L:$L)-G22","v":0}]
[]
[]
["2024/25 Funding for MFL comparison",null,null,null,null,"[B]",null,null,null,{"$f":"G17-SUM(G20:G22)","v":1689625.0994256767},null,null,null,{"$f":"_xlfn.XLOOKUP(\"P\"&$N$3,'[11]Minimum Per Pupil'!$A:$A,'[11]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":71394.900574323256},null,null,null,{"$f":"_xlfn.XLOOKUP(\"P\"&$N$3,'[11]Minimum Per Pupil'!$A:$A,'[11]Minimum Per Pupil'!$M:$M)-J28","v":2.3283064365386963E-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: 28th March 2024"},null,null,null,null,null,null,null,null,null,{"$f":"'Summary of Funding'!H1","v":"Last amended: 29th February 2024"}]
["COVENTRY CITY COUNCIL"]
[{"$f":"'Summary of Funding'!A3:H3","v":"2024/25 Funding Allocations for Schools"},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Summary of Funding'!N3","v":3}]
["Calculation of Minimum Funding Guarantee"]
[]
[{"$f":"_xlfn.XLOOKUP(\"P\"&$N$3,[5]Formula!$A:$A,[5]Formula!$C:$C)","v":"Allesley 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 2023/24 (Excluding Early Years)",null,null,null,null,null,null,null,null,{"$f":"_xlfn.XLOOKUP(\"P\"&$N$3,'[11]Minimum Funding Guarantee'!$A:$A,'[11]Minimum Funding Guarantee'!$H:$H)","v":1600252.5777664001}]
[]
["Less:"]
["2023/24 Rates Funding",null,null,null,null,null,{"$f":"_xlfn.XLOOKUP(\"P\"&$N$3,'[11]Minimum Funding Guarantee'!$A:$A,'[11]Minimum Funding Guarantee'!$J:$J)","v":45824},{"$f":"_xlfn.XLOOKUP(\"P\"&$N$3,'[11]Minimum Funding Guarantee'!$A:$A,'[11]Minimum Funding Guarantee'!$H:$H)","v":1600252.5777664001}]
[]
["2024/25 Lump Sum",null,null,null,null,null,{"$f":"_xlfn.XLOOKUP(\"P\"&$N$3,'[11]Minimum Funding Guarantee'!$A:$A,'[11]Minimum Funding Guarantee'!$I:$I)","v":134871.74399999998},{"$f":"INDEX('[13]Minimum Funding Guarantee'!$H:$H,MATCH(\"P\"&$N$3,'[13]Minimum Funding Guarantee'!$A:$A,0))","v":1596002.9570200001}]
[]
["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'!$L:$L)","v":0},{"$f":"INDEX('[13]Minimum Funding Guarantee'!$H:$H,MATCH(\"P\"&$N$3,'[13]Minimum Funding Guarantee'!$A:$A,0))","v":1596002.9570200001},null,{"$f":"-SUM(G14,G16,G18)","v":-180695.74399999998}]
[]
["Add:"]
["2023/24 Supplementary Grant",null,null,null,null,null,{"$f":"_xlfn.XLOOKUP(\"P\"&$N$3,'[11]Minimum Funding Guarantee'!$A:$A,'[11]Minimum Funding Guarantee'!$M:$M)","v":49581.221899999997},{"$f":"INDEX('[13]Minimum Funding Guarantee'!$H:$H,MATCH(\"P\"&$N$3,'[13]Minimum Funding Guarantee'!$A:$A,0))","v":1596002.9570200001},null,{"$f":"G21","v":49581.221899999997}]
[]
["Adjusted Budget Share 2023/24",null,null,null,null,null,null,null,null,{"$f":"J11+J18+J21","v":1469138.0556664001},null,null,null,{"$f":"_xlfn.XLOOKUP(\"P\"&$N$3,'[11]Minimum Funding Guarantee'!$A:$A,'[11]Minimum Funding Guarantee'!$N:$N)-J23","v":0}]
[]
[]
["Guaranteed Unit Funding Calculation",null,null,null,null,null,null,null,null,"£"]
[]
["Adjusted Budget Share 2023/24",null,null,null,null,null,{"$f":"J23","v":1469138.0556664001}]
[]
["October 2022 Pupil Number",null,null,null,null,null,{"$f":"_xlfn.XLOOKUP(\"P\"&$N$3,'[11]Minimum Funding Guarantee'!$A:$A,'[11]Minimum Funding Guarantee'!$D:$D)","v":352},{"$f":"INDEX('[13]Minimum Funding Guarantee'!$H:$H,MATCH(\"P\"&$N$3,'[13]Minimum Funding Guarantee'!$A:$A,0))","v":1596002.9570200001}]
[]
["Adjusted Budget Share 2023/24 Per Pupil",null,null,null,null,null,null,null,null,{"$f":"G28/G30","v":4173.6876581431825},null,null,null,{"$f":"_xlfn.XLOOKUP(\"P\"&$N$3,'[11]Minimum Funding Guarantee'!$A:$A,'[11]Minimum Funding Guarantee'!$O:$O)-J32","v":0}]
[]
["Minimum Funding Guarantee Protection Level",null,null,null,null,null,{"$f":"'[11]Minimum Funding Guarantee'!$R$3-1","v":4.2024585740008114E-3}]
[]
["2024/25 Guaranteed Unit Funding",null,null,null,null,null,null,null,null,{"$f":"J32*(1+G34)","v":4191.2274076273479}]
[]
[]
["Guaranteed Funding Level Calculation"]
[]
["2024/25 Guaranteed Unit Funding",null,null,null,null,null,{"$f":"J36","v":4191.2274076273479}]
[]
["October 2023 Pupil Number",null,null,null,null,null,{"$f":"_xlfn.XLOOKUP(\"P\"&$N$3,'[11]Minimum Funding Guarantee'!$A:$A,'[11]Minimum Funding Guarantee'!$E:$E)","v":382},{"$f":"INDEX('[13]Minimum Funding Guarantee'!$H:$H,MATCH(\"P\"&$N$3,'[13]Minimum Funding Guarantee'!$A:$A,0))","v":1596002.9570200001}]
[]
["2024/25 Guaranteed Funding Level",null,null,null,null,null,null,null,null,{"$f":"G41*G43","v":1601048.8697136468}]
[]
["Add:"]
["2024/25 Rates",null,null,null,null,null,{"$f":"_xlfn.XLOOKUP(\"P\"&$N$3,'[11]Minimum Funding Guarantee'!$A:$A,'[11]Minimum Funding Guarantee'!$Z:$Z)","v":53760},{"$f":"INDEX('[13]Minimum Funding Guarantee'!$H:$H,MATCH(\"P\"&$N$3,'[13]Minimum Funding Guarantee'!$A:$A,0))","v":1596002.9570200001}]
[]
["2024/25 Lump Sum",null,null,null,null,null,{"$f":"_xlfn.XLOOKUP(\"P\"&$N$3,'[11]Minimum Funding Guarantee'!$A:$A,'[11]Minimum Funding Guarantee'!$Y:$Y)","v":134871.74399999998},{"$f":"INDEX('[13]Minimum Funding Guarantee'!$H:$H,MATCH(\"P\"&$N$3,'[13]Minimum Funding Guarantee'!$A:$A,0))","v":1596002.9570200001}]
[]
["2024/25 Split Site",null,null,null,null,null,{"$f":"_xlfn.XLOOKUP(\"P\"&$N$3,'[11]Minimum Funding Guarantee'!$A:$A,'[11]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":1596002.9570200001},null,{"$f":"SUM(G48,G50)","v":188631.74399999998}]
[]
[]
["2024/25 Minimum Funding Guarantee",null,null,null,null,null,null,null,null,{"$f":"J45+J52","v":1789680.6137136468},null,null,null,{"$f":"_xlfn.XLOOKUP(\"P\"&$N$3,'[11]Minimum Funding Guarantee'!$A:$A,'[11]Minimum Funding Guarantee'!$Q:$Q)-J55","v":0}]
[]
[]
["2024/25 Minimum Funding Guarantee",null,null,null,null,null,{"$f":"J45+J52","v":1789680.6137136468}]
[]
["2024/25 Total Formula Funding allocated pre-MFG",null,null,null,null,null,{"$f":"'Budget Share Statement'!K46","v":1814780}]
[]
["2024/25 MFG Protection (additional funding/top-slice)",null,null,null,null,null,null,null,null,{"$f":"_xlfn.XLOOKUP(\"P\"&$N$3,'[11]Minimum Funding Guarantee'!$A:$A,'[11]Minimum Funding Guarantee'!$V:$V)","v":0},null,null,null,{"$f":"_xlfn.XLOOKUP(\"P\"&$N$3,'[11]Minimum Funding Guarantee'!$A:$A,'[11]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: 28th March 2024"},null,null,null,null,null,null,null,null,null,{"$f":"'Summary of Funding'!H1","v":"Last amended: 29th February 2024"}]
["COVENTRY CITY COUNCIL"]
[{"$f":"'Summary of Funding'!A3:H3","v":"2024/25 Funding Allocations for Schools"},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Summary of Funding'!N3","v":3}]
[{"$f":"\"De-Delegation Detail\"","v":"De-Delegation Detail"}]
[]
[{"$f":"_xlfn.XLOOKUP(\"P\"&$N$3,[5]Formula!$A:$A,[5]Formula!$C:$C)","v":"Allesley 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-23 Census)",null,null,null,{"$f":"_xlfn.XLOOKUP(\"P\"&$N$3,[11]Data!$A:$A,[11]Data!$D:$D)","v":382},null,{"$f":"-'[11]New Del & De-Del'!$G$9","v":-29.010664596926969},null,{"$f":"G14*I14","v":-11082.073876026103},null,null,null,{"$f":"ROUND(_xlfn.XLOOKUP(\"P\"&$N$3,'[11]New Del & De-Del'!$A:$A,'[11]New Del & De-Del'!$K:$K)+K14,0)","v":0}]
["Trade Union Facility",null,"Pupil Number: (Oct-23 Census)",null,null,null,{"$f":"_xlfn.XLOOKUP(\"P\"&$N$3,[11]Data!$A:$A,[11]Data!$D:$D)","v":382},null,{"$f":"-'[11]New Del & De-Del'!$G$10","v":-4},null,{"$f":"G15*I15","v":-1528},null,null,null,{"$f":"ROUND(_xlfn.XLOOKUP(\"P\"&$N$3,'[11]New Del & De-Del'!$A:$A,'[11]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":-12610.073876026103},null,null,null,{"$f":"ROUND(_xlfn.XLOOKUP(\"P\"&$N$3,'[11]New Del & De-Del'!$A:$A,'[11]New Del & De-Del'!$D:$D)+K17,0)","v":0}]
["Deprivation Funding"]
["Free School Meal Eligibility",null,"Free School Meals: (Oct-23 FSM Eligibility)",null,null,null,{"$f":"_xlfn.XLOOKUP(\"P\"&$N$3,[11]Data!$A:$A,[11]Data!$T:$T)","v":28.999999999999982},null,{"$f":"-'[11]New Del & De-Del'!$G$7","v":-2.6331512061126139},null,{"$f":"G19*I19","v":-76.361384977265757},null,null,null,{"$f":"ROUND(_xlfn.XLOOKUP(\"P\"&$N$3,'[11]New Del & De-Del'!$A:$A,'[11]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,[11]Data!$A:$A,[11]Data!$AD:$AD)","v":34.403726708074522},null,{"$f":"-'[11]New Del & De-Del'!$G$12","v":-58.328035002709882},null,{"$f":"G23*I23","v":-2006.7017756522355},null,null,null,{"$f":"ROUND(_xlfn.XLOOKUP(\"P\"&$N$3,'[11]New Del & De-Del'!$A:$A,'[11]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":-14693.137036655604},null,null,null,{"$f":"ROUND(_xlfn.XLOOKUP(\"P\"&$N$3,'[11]New Del & De-Del'!$A:$A,'[11]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: 28th March 2024"},null,null,null,null,null,null,null,null,null,{"$f":"'Summary of Funding'!H1","v":"Last amended: 29th February 2024"}]
["COVENTRY CITY COUNCIL"]
[{"$f":"'Summary of Funding'!A3:H3","v":"2024/25 Funding Allocations for Schools"},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Summary of Funding'!N3","v":3}]
["INDICATIVE Early Years Funding Statement"]
[]
[{"$f":"_xlfn.XLOOKUP(\"P\"&$N$3,[5]Formula!$A:$A,[5]Formula!$C:$C)","v":"Allesley 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 2023 Headcount ",null,null,null,{"$f":"_xlfn.IFNA(_xlfn.XLOOKUP(\"P\"&$N$3,'[15]Early Years Formula'!$A:$A,'[15]Early Years Formula'!$D:$D),0)","v":32},null,{"$f":"_xlfn.IFNA(_xlfn.XLOOKUP(\"P\"&$N$3,'[15]Early Years Formula'!$A:$A,'[15]Early Years Formula'!$D:$D),0)","v":32}]
["IDACI based on January 2023 census",null,null,null,{"$f":"_xlfn.IFNA(_xlfn.XLOOKUP(\"P\"&$N$3,'[15]Early Years Formula'!$A:$A,'[15]Early Years Formula'!$E:$E),0)","v":9.6718750000000034E-2},null,{"$f":"_xlfn.IFNA(_xlfn.XLOOKUP(\"P\"&$N$3,'[15]Early Years Formula'!$A:$A,'[15]Early Years Formula'!$E:$E),0)","v":9.6718750000000034E-2}]
["Universal Base Rate",null,null,null,4.93,null,4.93]
["Universal Deprivation Rate",null,null,null,1.48,null,1.48]
[]
[]
[null,null,null,null,"Summer \nTerm 2024",null,"Autumn\nTerm 2024",null,"Spring\nTerm 2025",null,"Whole\nFinancial Year"]
[null,null,null,null,"(12 Weeks)",null,"(14 Weeks)",null,"(12 Weeks)",null,"(38 Weeks)"]
[null,null,null,null,"(Per May 23 census)",null,"(Per Oct 23 census)",null,"(Per Jan 24 census)"]
["Formula Factors"]
["Free Entitlement Headcount",null,null,null,{"$f":"_xlfn.IFNA(_xlfn.XLOOKUP(\"P\"&$N$3,'[15]Early Years Formula'!$A:$A,'[15]Early Years Formula'!$I:$I),0)","v":33},null,{"$f":"_xlfn.IFNA(_xlfn.XLOOKUP(\"P\"&$N$3,'[15]Early Years Formula'!$A:$A,'[15]Early Years Formula'!$P:$P),0)","v":32},null,{"$f":"_xlfn.IFNA(_xlfn.XLOOKUP(\"P\"&$N$3,'[15]Early Years Formula'!$A:$A,'[15]Early Years Formula'!$W:$W),0)","v":32}]
["Free Entitlement Hours Provided",null,null,null,{"$f":"_xlfn.IFNA(_xlfn.XLOOKUP(\"P\"&$N$3,'[15]Early Years Formula'!$A:$A,'[15]Early Years Formula'!$H:$H),0)","v":5916},null,{"$f":"_xlfn.IFNA(_xlfn.XLOOKUP(\"P\"&$N$3,'[15]Early Years Formula'!$A:$A,'[15]Early Years Formula'!$O:$O),0)/15*14","v":6860},null,{"$f":"_xlfn.IFNA(_xlfn.XLOOKUP(\"P\"&$N$3,'[15]Early Years Formula'!$A:$A,'[15]Early Years Formula'!$V:$V),0)","v":5390}]
["Extended Entitlement Headcount",null,null,null,{"$f":"_xlfn.IFNA(_xlfn.XLOOKUP(\"P\"&$N$3,'[15]Early Years Formula'!$A:$A,'[15]Early Years Formula'!$K:$K),0)","v":23},null,{"$f":"_xlfn.IFNA(_xlfn.XLOOKUP(\"P\"&$N$3,'[15]Early Years Formula'!$A:$A,'[15]Early Years Formula'!$R:$R),0)","v":21},null,{"$f":"_xlfn.IFNA(_xlfn.XLOOKUP(\"P\"&$N$3,'[15]Early Years Formula'!$A:$A,'[15]Early Years Formula'!$Y:$Y),0)","v":21}]
["Extended Entitlement Hours Provided",null,null,null,{"$f":"_xlfn.IFNA(_xlfn.XLOOKUP(\"P\"&$N$3,'[15]Early Years Formula'!$A:$A,'[15]Early Years Formula'!$J:$J),0)","v":4140},null,{"$f":"_xlfn.IFNA(_xlfn.XLOOKUP(\"P\"&$N$3,'[15]Early Years Formula'!$A:$A,'[15]Early Years Formula'!$Q:$Q),0)","v":4590},null,{"$f":"_xlfn.IFNA(_xlfn.XLOOKUP(\"P\"&$N$3,'[15]Early Years Formula'!$A:$A,'[15]Early Years Formula'!$X:$X),0)","v":3327.5}]
[]
["Base Rate Funding",null,null,null,{"$f":"IFERROR((E22+E24)*$E13,0)","v":49576.079999999994},null,{"$f":"IFERROR((G22+G24)*$E13,0)","v":56448.5},null,{"$f":"IFERROR((I22+I24)*$E13,0)","v":42977.274999999994}]
[]
["Deprivation Funding",null,null,null,{"$f":"IFERROR((E21+E23)*$E$14*15*12*$E$12,0)","v":1442.8890000000004},null,{"$f":"IFERROR((G21+G23)*$E$14*15*12*$E$12,0)","v":1365.5913750000004},null,{"$f":"IFERROR((I21+I23)*$E$14*15*12*$E$12,0)","v":1365.5913750000004}]
[]
["Total 2024/25 Funding Under EYSFF (£)",null,null,null,{"$f":"E28+E26","v":51018.968999999997},null,{"$f":"G28+G26","v":57814.091375000004},null,{"$f":"I28+I26","v":44342.866374999998},null,{"$f":"E30+G30+I30","v":153175.92674999998}]
[]
[]
["Note:"]
["This Early Years budget has been estimated based on full participation at the 23/24 census levels for Sum-24, Aut-24"]
["and Spr-25 using the 24/25 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-24, Autumn-24 and Spring-25 school census information. As in previous years, this means that your Early Years"]
["funding will not be finalised until after the Spring 2025 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: 28th March 2024"},null,null,null,null,null,null,{"$f":"'Summary of Funding'!H1","v":"Last amended: 29th February 2024"},null,null,null,null,null,"ID"]
["COVENTRY CITY COUNCIL"]
[{"$f":"'Summary of Funding'!A3:H3","v":"2024/25 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 2024/25 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 2024/25\" for your reference."]
[]
[]
[]
[]
[]
["S251 line","Further Delegation Areas","Delegated in 2013/14",null,null,"De-delegation in 2024/25"]
[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":"'[11]New Del & De-Del'!I7","v":12720.753476730019},0,{"$f":"SUM(F19:G19)","v":12720.753476730019}]
["1.1.7","Licences/subscriptions",56639.723182411013,35735.642889017559,92375.36607142858,{"$f":"'[11]New Del & De-Del'!I8","v":0},0,{"$f":"SUM(F20:G20)","v":0}]
["1.1.8","Maternity/special staffing suspension",356766.17682212021,225094.12075930767,581860.29758142785,{"$f":"'[11]New Del & De-Del'!I9","v":551318.67000000016},0,551318.67000000016]
["1.1.9","Trade Union facility",195944.4399044039,123627.02600013438,319571.46590453829,{"$f":"'[11]New Del & De-Del'!I10","v":76016},0,76016]
["1.1.10","School Improvement",0,0,0,{"$f":"'[11]New Del & De-Del'!I11","v":0},0,0]
["1.1.3","Ethnic Minority Acheivement Service (EMAS)",991053,284303,1275356,{"$f":"'[11]New Del & De-Del'!I12","v":247246.37859227497},0,247246.37859227497]
["1.1.2","Behaviour support services",310504,256781,567285,{"$f":"'[11]New Del & De-Del'!I13","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,887301.80206900509,0,887301.80206900509,null,{"$f":"H26-'[11]New Del & De-Del'!$K$14","v":0}]

{"sheet":"ISB","index":7,"n_rows":35,"n_cols":10,"rows_kept":35,"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: 28th March 2024"},null,null,null,null,{"$f":"'Summary of Funding'!H1","v":"Last amended: 29th February 2024"},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 2023/24",{"$f":"[17]Sheet2!$B$2","v":152715110.58055162},{"$f":"[17]Sheet2!$C$2","v":139305127.96148044}]
[]
[null,"Resource Adjustments"]
[null,"De-delegation adjustments",{"$f":"[17]Sheet2!$B$8","v":67766.565142452717}]
[null,"NFF - Additional resource",{"$f":"[17]Sheet2!$B$4","v":2172678.6423612796},{"$f":"[17]Sheet2!$C$4","v":2047563.0914995065}]
[null,"NFF - mainstream schools additional grant rolled into DSG",{"$f":"[17]Sheet2!$B$3","v":5009787.442499999},{"$f":"[17]Sheet2!$C$3","v":4775317.6496000001}]
[]
[null,"Education Service PPR"]
[null,"Pupil number changes",{"$f":"[17]Sheet2!$B$5","v":2016291.9756320715},{"$f":"[17]Sheet2!$C$5","v":5415017.8456530571}]
[null,"Pupil data changes",{"$f":"[17]Sheet2!$B$6","v":810474.27653935552},{"$f":"[17]Sheet2!$C$6","v":573948.55448064208}]
[null,"Capping & scaling",{"$f":"[17]Sheet2!$B$7","v":-212764.35543820262},{"$f":"[17]Sheet2!$C$7","v":-282065.36521565914}]
[]
[null,"FINAL ISB 2023/24",{"$f":"SUM(C19:C30)","v":162579345.12728858},{"$f":"SUM(D19:D30)","v":151834909.73749799}]
[]
[]
[]
["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","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":[[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: 28th March 2024"},null,null,null,null,null,null,null,null,null,null,{"$f":"'Summary of Funding'!H1","v":"Last amended: 29th February 2024"}]
["COVENTRY CITY COUNCIL - PEOPLE'S DIRECTORATE"]
[{"$f":"'Summary of Funding'!A3:H3","v":"2024/25 Funding Allocations for Schools"},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Summary of Funding'!N3","v":3}]
["Calculation of Funding Floor"]
[]
[{"$f":"VLOOKUP((\"P\"&N3),[18]Formula!$A$10:$X$96,3,FALSE)","v":"Allesley"},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":1438986.0832845215},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":0},{"$f":"VLOOKUP((\"P\"&$N$3),'[19]Funding Floor'!$A$3:$U$90,6,FALSE)","v":1438986.0832845215},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":1438986.0832845215},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":1438986.0832845215},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":45108},{"$f":"VLOOKUP((\"P\"&$N$3),'[19]Funding Floor'!$A$3:$U$90,6,FALSE)","v":1438986.0832845215},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":3578.8163016360622},{"$f":"VLOOKUP((\"P\"&$N$3),'[19]Funding Floor'!$A$3:$U$90,6,FALSE)","v":1438986.0832845215},null,{"$f":"-SUM(I14:I22)","v":-159050.91630163603},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":1279935.1669828855},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":396},{"$f":"VLOOKUP((\"P\"&$N$3),'[19]Funding Floor'!$A$3:$U$90,6,FALSE)","v":1438986.0832845215},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":3232.159512583044},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":3403.2458000000001},{"$f":"VLOOKUP((\"P\"&$N$3),'[19]Funding Floor'!$A$3:$U$90,6,FALSE)","v":1438986.0832845215},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":3437.2782580000003}]
[]
["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":205.11874541695624}]
[]
[]
[]
["2020/21 Funding Floor Adjustment",null,null,null,null,null,null,"= [A] x [D]",null,null,null,{"$f":"L38*I27","v":81227.023185114667},null,{"$f":"VLOOKUP((\"P\"&$N$3),'[19]Funding Floor'!$A$3:$U$90,21,FALSE)-L42","v":0}]