{"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":16,"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":42,"n_cols":14,"rows_kept":42,"cut":false,"hidden":true,"merged":[[2,0,2,7],[3,0,3,7],[5,0,5,7],[1,0,1,7],[9,0,9,2],[17,0,17,3]]}
["Date Issued: 4th July 2022",null,null,null,null,null,null,"Last amended: 1st July 2022"]
["COVENTRY CITY COUNCIL"]
["2022/23 Funding Allocations for Schools",null,null,null,null,null,null,null,null,null,null,null,null,25]
["INDICATIVE Summary of Funding"]
[]
[{"$f":"VLOOKUP((\"P\"&N3),[5]Formula!$A$10:$X$96,3,FALSE)","v":"Howes"},null,null,null,null,null,null,null,null,null,null,null,null,"Checks"]
[]
[]
[{"$f":"IF((N32+N33)=0,\"\",\"***ERROR - CALCULATED ADJUSTMENT DOES NOT EQUAL ACTUAL ***\")","v":""}]
["Main Funding Elements"]
[]
["School Budget Share 2022/23",null,null,null,null,{"$f":"'Budget Share Statement'!K62","v":740023.54899769346},null,null,null,null,null,null,null,{"$f":"F12-'Budget Share Statement'!K62","v":0}]
[]
["Indicative Early Years Funding 2022/23* (to be updated)",null,null,null,null,{"$f":"'EYSFF statement'!K29","v":30641.864760000004},null,null,null,null,null,null,null,{"$f":"F14-'EYSFF statement'!K29","v":0}]
[]
[null,null,null,null,null,null,null,{"$f":"SUM(F12,F14)","v":770665.41375769349},null,null,null,null,null,{"$f":"N12+N14","v":0}]
[]
["Other 2022/23 Funding Elements "]
[]
["Indicative Pupil Premium Grant † (excludes LAC & EYPP elements)",null,null,null,null,{"$f":"VLOOKUP((\"P\"&$N$3),[13]Allocations!$A$6:$W$123,22,FALSE)","v":64735}]
[]
["Indicative High Needs Top-up Funding §",null,null,null,null,{"$f":"VLOOKUP((\"P\"&$N$3),[14]PupilNosAutTerm!$A$2:$E$108,5,FALSE)","v":52500}]
[]
["Class Size Funding ",null,null,null,null,{"$f":"VLOOKUP($N$3,'[15]Class size'!$A$10:$N$95,14,FALSE)","v":13255.229436145833}]
[]
["In-year Admissions Funding ",null,null,null,null,{"$f":"VLOOKUP(\"P\"&$N$3,'[15]In-year admissions'!$A$6:$M$116,13,FALSE)","v":4675.1099999999997}]
[]
["Disproportionate SEN",null,null,null,null,{"$f":"-VLOOKUP((\"P\"&$N$3),[16]Sheet1!$C$2:$AC$110,24,FALSE)","v":20144.120670553042}]
[]
[null,null,null,null,null,null,null,{"$f":"F20+F22+F24+F26+F28","v":155309.46010669885}]
[]
["Total Revenue Resources",null,null,null,null,null,null,{"$f":"H16+H30","v":925974.87386439228},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'!O62+'De-delegation'!O25+'Minimum Funding Level'!O28+'Funding Floor'!N42+'MFG Calculation'!N56),5)","v":0}]
[]
["Notes "]
["This funding summary is intended to give you an overview of the resources allocated to the school for the financial year 2022/23."]
["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 term census data - please see the EYSFF statement for further detail."]
["† Pupil Premium Funding is indicative based on the Qtr 1 22-23 allocations as per the Oct-21 census."]
["§ Indicative High Needs Top-up Funding has been calculated based on your number of Band 5 & Band 6 pupils as at 17/12/21. This"]
["  figure will change based on the real time movement of pupils during the 2022/23 financial year and so will not be final until March 2023."]

{"sheet":"Budget Share Statement","index":1,"n_rows":66,"n_cols":15,"rows_kept":66,"cut":false,"hidden":true,"merged":[[58,7,58,8],[21,2,21,4],[22,2,22,4],[23,2,23,4],[41,7,41,8],[40,2,40,4],[40,7,40,8],[56,2,56,4],[24,2,24,4],[38,2,38,4],[1,0,1,10],[19,2,19,4],[20,2,20,4],[3,0,3,10],[18,2,18,4],[17,2,17,4],[2,0,2,10],[5,0,5,10],[9,2,9,4],[41,2,41,4],[36,2,36,4],[56,7,56,8],[46,7,46,8],[32,2,32,4],[25,2,25,4],[50,7,50,8]]}
[{"$f":"'Summary of Funding'!A1","v":"Date Issued: 4th July 2022"},null,null,null,null,null,null,null,null,null,{"$f":"'Summary of Funding'!H1","v":"Last amended: 1st July 2022"}]
["COVENTRY CITY COUNCIL"]
[{"$f":"'Summary of Funding'!A3:H3","v":"2022/23 Funding Allocations for Schools"},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Summary of Funding'!N3","v":25}]
["INDICATIVE School Budget Share Statement"]
[]
[{"$f":"VLOOKUP((\"P\"&N3),[5]Formula!$A$10:$X$96,3,FALSE)","v":"Howes"},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-21 Census)",null,null,null,{"$f":"VLOOKUP((\"P\"&$N$3),[10]Data!$A$8:$AH$94,4,FALSE)","v":136},null,{"$f":"[10]Formula!$D$5","v":3238.1940795854794},null,{"$f":"G13*I13","v":440394.39482362522},null,null,null,{"$f":"VLOOKUP((\"P\"&$N$3),[10]Formula!$A$9:$AC$95,4,FALSE)-K13","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,{"$f":"K13","v":440394.39482362522}]
[]
[]
["Deprivation Funding",null,"IDACI Band G:  Pupil's IDACI < 0.20",null,null,null,{"$f":"VLOOKUP((\"P\"&$N$3),[10]Data!$A$8:$AH$94,22,FALSE)","v":96.999999999999986},null,0,null,{"$f":"G18*I18","v":0}]
[null,null,"IDACI Band F:  0.20 ≤ Pupil's IDACI < 0.25",null,null,null,{"$f":"VLOOKUP((\"P\"&$N$3),[10]Data!$A$8:$AH$94,23,FALSE)","v":25.000000000000039},null,{"$f":"[10]Formula!$N$5","v":220.74359999999999},null,{"$f":"G19*I19","v":5518.5900000000083}," ",null,null,{"$f":"VLOOKUP((\"P\"&$N$3),[10]Formula!$A$9:$AC$95,14,FALSE)-K19","v":0}]
[null,null,"IDACI Band E:  0.25 ≤ Pupil's IDACI < 0.30",null,null,null,{"$f":"VLOOKUP((\"P\"&$N$3),[10]Data!$A$8:$AH$94,24,FALSE)","v":4.9999999999999947},null,{"$f":"[10]Formula!$O$5","v":270.9126},null,1354.5629999999985," ",null,null,{"$f":"VLOOKUP((\"P\"&$N$3),[10]Formula!$A$9:$AC$95,15,FALSE)-K20","v":0}]
[null,null,"IDACI Band D:  0.30 ≤ Pupil's IDACI < 0.35",null,null,null,{"$f":"VLOOKUP((\"P\"&$N$3),[10]Data!$A$8:$AH$94,25,FALSE)","v":1.0000000000000002},null,{"$f":"[10]Formula!$P$5","v":421.41959999999995},null,421.41960000000006," ",null,null,{"$f":"VLOOKUP((\"P\"&$N$3),[10]Formula!$A$9:$AC$95,16,FALSE)-K21","v":0}]
[null,null,"IDACI Band C:  0.35 ≤ Pupil's IDACI < 0.40",null,null,null,{"$f":"VLOOKUP((\"P\"&$N$3),[10]Data!$A$8:$AH$94,26,FALSE)","v":0},null,{"$f":"[10]Formula!$Q$5","v":461.5548},null,0,null,null,null,{"$f":"VLOOKUP((\"P\"&$N$3),[10]Formula!$A$9:$AC$95,17,FALSE)-K22","v":0}]
[null,null,"IDACI Band B:  0.40 ≤ Pupil's IDACI < 0.50",null,null,null,{"$f":"VLOOKUP((\"P\"&$N$3),[10]Data!$A$8:$AH$94,27,FALSE)","v":5.9999999999999956},null,{"$f":"[10]Formula!$R$5","v":491.65619999999996},null,2949.9371999999976,null,null,null,{"$f":"VLOOKUP((\"P\"&$N$3),[10]Formula!$A$9:$AC$95,18,FALSE)-K23","v":0}]
[null,null,"IDACI Band A:  0.50 ≤ Pupil's IDACI ≤ 1.00",null,null,null,{"$f":"VLOOKUP((\"P\"&$N$3),[10]Data!$A$8:$AH$94,28,FALSE)","v":2.0000000000000031},null,{"$f":"[10]Formula!$S$5","v":642.16319999999996},null,1284.326400000002,null,null,null,{"$f":"VLOOKUP((\"P\"&$N$3),[10]Formula!$A$9:$AC$95,19,FALSE)-K24","v":0}]
[null,null,"Free School Meals: (Oct-19 FSM Eligibility)",null,null,null,{"$f":"VLOOKUP((\"P\"&$N$3),[10]Data!$A$8:$AH$94,20,FALSE)","v":44.000000000000014},null,{"$f":"[10]Formula!$E$5","v":471.58859999999999},null,20749.898400000005,null,null,null,{"$f":"VLOOKUP((\"P\"&$N$3),[10]Formula!$A$9:$AC$95,5,FALSE)-K25","v":0}]
[null,null,"Free School Meals Ever 6: (Oct-19 FSM Eligibility)",null,null,null,{"$f":"VLOOKUP((\"P\"&$N$3),[10]Data!$A$8:$AH$94,21,FALSE)","v":47.000000000000043},null,{"$f":"[10]Formula!$F$5","v":591.99419999999998},null,27823.727400000025,null,null,null,{"$f":"VLOOKUP((\"P\"&$N$3),[10]Formula!$A$9:$AC$95,6,FALSE)-K26","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(K18:K26)","v":60102.462000000036}]
[]
["Prior Attainment Funding",null,"No.pupils not reaching expected level of development",null,null,null,{"$f":"VLOOKUP((\"P\"&$N$3),[10]Data!$A$8:$AH$94,29,FALSE)","v":51.927272727272729},null,{"$f":"[10]Formula!$G$5","v":1133.8193999999999},null,{"$f":"G30*I30","v":58876.14920727272},null,null,null,{"$f":"VLOOKUP((\"P\"&$N$3),[10]Formula!$A$9:$AC$95,7,FALSE)-K30","v":0}]
[]
["English as an Additional"]
["Language Funding",null,"No. EAL in compulsory education for 3 years or less",null,null,null,{"$f":"VLOOKUP((\"P\"&$N$3),[10]Data!$A$8:$AH$94,30,FALSE)","v":18.598290598290632},null,{"$f":"[10]Formula!$H$5","v":566.90969999999993},null,{"$f":"G33*I33","v":10543.551343589761},null,null,null,{"$f":"VLOOKUP((\"P\"&$N$3),[10]Formula!$A$9:$AC$95,8,FALSE)-K33","v":0}]
[]
["Pupil Mobility Funding",null,"No.pupils in last 3 years who didn’t start school in Sept",null,null,null,{"$f":"VLOOKUP((\"P\"&$N$3),[10]Data!$A$8:$AH$94,31,FALSE)","v":2.8400000000000047},null,{"$f":"[10]Formula!$I$5","v":928.12649999999996},null,{"$f":"G35*I35","v":2635.8792600000043},null,null,null,{"$f":"VLOOKUP((\"P\"&$N$3),[10]Formula!$A$9:$AC$95,9,FALSE)-K35","v":0}]
[]
["Lump Sum",null,"One set amount for all schools",null,null,null,null,null,null,null,{"$f":"VLOOKUP((\"P\"&$N$3),[10]Formula!$A$9:$AC$95,10,FALSE)","v":121709.99399999999},null,null,null,{"$f":"VLOOKUP((\"P\"&$N$3),[10]Formula!$A$9:$AC$95,10,FALSE)-K37","v":0}]
[]
["Split Sites Funding",null,"Lump Sum",null,null,null,null,null,null,null,{"$f":"VLOOKUP((\"P\"&$N$3),[10]Formula!$A$9:$AC$95,12,FALSE)","v":0},null,null,null,{"$f":"VLOOKUP((\"P\"&$N$3),[10]Formula!$A$9:$AC$95,12,FALSE)-K39","v":0}]
[]
["Rates Funding",null,"Estimated 2022/23 rates bill",null,null,null,null,{"$f":"VLOOKUP((\"P\"&$N$3),[10]Formula!$A$10:$AC$95,11,FALSE)","v":34048}]
[null,null,"Adjustment for previous years charges",null,null,null,null,0,null,null,{"$f":"H41+H42","v":34048},null,null,null,{"$f":"VLOOKUP((\"P\"&$N$3),[10]Formula!$A$9:$AC$95,11,FALSE)-K42","v":0}]
[]
[]
["Total Formula Factor Funding",null,null,null,null,null,null,null,null,null,{"$f":"K15+K28+K33+K35+K37+K39+K42+K30","v":728310.43063448777},null,null,null,{"$f":"VLOOKUP((\"P\"&$N$3),[10]Formula!$A$9:$AC$95,21,FALSE)-K45","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":"VLOOKUP((\"P\"&$N$3),[10]Formula!$A$9:$AC$95,22,FALSE)-H47","v":0}]
[]
["Total Funding Allocated before Minimum Funding Guarantee (MFG)",null,null,null,null,null,null,null,null,null,{"$f":"K45+H47","v":728310.43063448777},null,null,null,{"$f":"VLOOKUP((\"P\"&$N$3),[10]Formula!$A$9:$AC$95,23,FALSE)-K49","v":0}]
[]
["MFG Protection (additional funding/top-slice)",null,null,null,null,null,null,{"$f":"'MFG Calculation'!J63","v":20070.980164227774},null,null,null,null,null,null,{"$f":"VLOOKUP((\"P\"&$N$3),[10]Formula!$A$9:$AC$95,26,FALSE)-H51","v":1.1641532182693481E-10}]
[]
["Total Funding Allocated after protection Arrangements",null,null,null,null,null,null,null,null,null,{"$f":"K49+H51","v":748381.41079871554},null,null,null,{"$f":"VLOOKUP((\"P\"&$N$3),[10]Formula!$A$9:$AC$95,27,FALSE)-K53","v":0}]
[]
[]
[]
["22/23 De-delegation",null,"See separate 'De-delegation' sheet",null,null,null,null,{"$f":"'De-delegation'!K25","v":-5545.8618010221044},null,null,null,null,null,null,{"$f":"VLOOKUP((\"P\"&$N$3),[10]Formula!$A$9:$AC$95,28,FALSE)-H57","v":0}]
[]
["22/23 Risk Protection Arrangement Deduction",null,null,null,null,null,null,{"$f":"-IFERROR(INDEX('[9]LAMS Data'!$AG$9:$AG$34,MATCH($N$3,'[9]LAMS Data'!$A$9:$A$34,0)),0)","v":-2812}]
[]
[]
["Total Funding Allocated after MFG, De-delegation and RPA Adjustment",null,null,null,null,null,null,null,null,null,{"$f":"K53+H57+H59","v":740023.54899769346},null,null,null,{"$f":"VLOOKUP((\"P\"&$N$3),[10]Formula!$A$9:$AC$95,29,FALSE)-K62-IFERROR(INDEX('[9]LAMS Data'!$AG$9:$AG$34,MATCH($N$3,'[9]LAMS Data'!$A$9:$A$34,0)),0)","v":0}]
[]
["Notes"]
["If you have chosen to join the DfE Risk Protection Arrangement, the value of your charge is deducted from your budget share when the "]
["charge is known."]

{"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: 4th July 2022"},null,null,null,null,null,null,null,null,null,{"$f":"'Summary of Funding'!H1","v":"Last amended: 1st July 2022"}]
["COVENTRY CITY COUNCIL"]
[{"$f":"'Summary of Funding'!A3:H3","v":"2022/23 Funding Allocations for Schools"},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Summary of Funding'!N3","v":25}]
["Calculation of Minimum Per Pupil (MPP) Funding Level"]
[]
[{"$f":"VLOOKUP((\"P\"&N3),[5]Formula!$A$10:$X$96,3,FALSE)","v":"Howes"},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":"'[10]Minimum Per Pupil'!$D$3","v":4265},null,null,null,null,null,null,{"$f":"'[10]Minimum Per Pupil'!$D$3-G10","v":0}]
[]
["October 2021 Pupil Numbers",null,null,null,null,null,{"$f":"VLOOKUP((\"P\"&$N$3),'[10]Minimum Per Pupil'!$A$4:$N$91,4,FALSE)","v":136},null,null,null,null,null,null,{"$f":"VLOOKUP((\"P\"&$N$3),'[10]Minimum Per Pupil'!$A$4:$N$91,4,FALSE)-G12","v":0}]
[]
["Minimum Funding Level (MFL)",null,null,null,null,"[A]",null,null,null,{"$f":"G10*G12","v":580040},null,null,null,{"$f":"VLOOKUP((\"P\"&$N$3),'[10]Minimum Per Pupil'!$A$4:$N$91,5,FALSE)-J14","v":0}]
[]
[]
["Total Formula Factor Funding",null,null,null,null,null,{"$f":"'Budget Share Statement'!K45","v":728310.43063448777},null,null,null,null,null,null,{"$f":"VLOOKUP((\"P\"&$N$3),'[10]Minimum Per Pupil'!$A$4:$N$91,7,FALSE)-G17","v":0}]
[]
["Less: exempt premises factors"]
["2022/23 NNDR",null,null,null,null,null,{"$f":"VLOOKUP((\"P\"&$N$3),[10]Formula!$A$10:$AC$95,11,FALSE)","v":34048},null,null,null,null,null,null,{"$f":"VLOOKUP((\"P\"&$N$3),'[10]Minimum Per Pupil'!$A$4:$N$91,8,FALSE)-G20","v":0}]
[]
["2022/23 Split Site",null,null,null,null,null,{"$f":"VLOOKUP((\"P\"&$N$3),[10]Formula!$A$10:$AC$95,12,FALSE)","v":0},null,null,null,null,null,null,{"$f":"VLOOKUP((\"P\"&$N$3),'[10]Minimum Per Pupil'!$A$4:$N$91,9,FALSE)-G22","v":0}]
[]
[]
["2022/23 Funding for MFL comparison",null,null,null,null,"[B]",null,null,null,{"$f":"G17-SUM(G20:H23)","v":694262.43063448777},null,null,null,{"$f":"VLOOKUP((\"P\"&$N$3),'[10]Minimum Per Pupil'!$A$4:$N$91,11,FALSE)-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":"VLOOKUP((\"P\"&$N$3),'[10]Minimum Per Pupil'!$A$4:$N$91,13,FALSE)-J28","v":0}]

{"sheet":"MFG Calculation","index":3,"n_rows":66,"n_cols":14,"rows_kept":66,"cut":false,"hidden":true,"merged":[[29,6,29,7],[15,6,15,7],[58,6,58,7],[60,6,60,7],[10,6,10,7],[49,6,49,7],[17,6,17,7],[53,6,53,7],[33,6,33,7],[51,6,51,7],[47,6,47,7],[42,6,42,7],[1,0,1,10],[2,0,2,10],[3,0,3,10],[5,0,5,10],[19,6,19,7],[40,6,40,7],[8,6,8,7],[13,6,13,7],[27,6,27,7]]}
[{"$f":"'Summary of Funding'!A1","v":"Date Issued: 4th July 2022"},null,null,null,null,null,null,null,null,null,{"$f":"'Summary of Funding'!H1","v":"Last amended: 1st July 2022"}]
["COVENTRY CITY COUNCIL"]
[{"$f":"'Summary of Funding'!A3:H3","v":"2022/23 Funding Allocations for Schools"},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Summary of Funding'!N3","v":25}]
["Calculation of Minimum Funding Guarantee"]
[]
[{"$f":"VLOOKUP((\"P\"&N3),[5]Formula!$A$10:$X$96,3,FALSE)","v":"Howes"},null,null,null,null,null,null,null,null,null,null,null,null,"Checks"]
[]
[]
["Baseline",null,{"$f":"IF(N56>=0,\" \",\"DOES NOT BALANCE\")","v":" "},null,null,null,"£",null,null,"£"]
[]
["Final Budget Share 2021/22 (Excluding Early Years)",null,null,null,null,null,null,null,null,{"$f":"VLOOKUP((\"P\"&$N$3),'[10]Minimum Funding Guarantee'!$A$4:$AK$91,9,FALSE)","v":766710.67266731081}]
[]
["Less:"]
["2021/22 Rates Funding",null,null,null,null,null,{"$f":"VLOOKUP((\"P\"&$N$3),'[10]Minimum Funding Guarantee'!$A$4:$AK$91,11,FALSE)","v":34048},{"$f":"VLOOKUP((\"P\"&$N$3),'[8]Minimum Funding Guarantee'!$A$4:$AK$91,9,FALSE)","v":809720.27666721749}]
[]
["2021/22 Lump Sum",null,null,null,null,null,{"$f":"VLOOKUP((\"P\"&$N$3),'[10]Minimum Funding Guarantee'!$A$4:$AK$91,10,FALSE)","v":121709.99399999999},{"$f":"VLOOKUP((\"P\"&$N$3),'[8]Minimum Funding Guarantee'!$A$4:$AK$91,9,FALSE)","v":809720.27666721749}]
[]
["2021/22 Education Improvement Commissioning Pot",null,null,null,null,null,{"$f":"VLOOKUP((\"P\"&$N$3),'[10]Minimum Funding Guarantee'!$A$4:$AK$91,12,FALSE)","v":1491.6550764953101},{"$f":"VLOOKUP((\"P\"&$N$3),'[8]Minimum Funding Guarantee'!$A$4:$AK$91,9,FALSE)","v":809720.27666721749}]
[]
["2021/22 Split Site",null,null,null,null,null,{"$f":"VLOOKUP((\"P\"&$N$3),'[10]Minimum Funding Guarantee'!$A$4:$AK$91,13,FALSE)","v":0},{"$f":"VLOOKUP((\"P\"&$N$3),'[8]Minimum Funding Guarantee'!$A$4:$AK$91,9,FALSE)","v":809720.27666721749},null,{"$f":"-SUM(G14,G16,G18,G20)","v":-157249.64907649532}]
[]
["Adjusted Budget Share 2021/22",null,null,null,null,null,null,null,null,{"$f":"J11+J20","v":609461.02359081549},null,null,null,{"$f":"VLOOKUP((\"P\"&$N$3),'[10]Minimum Funding Guarantee'!$A$4:$AK$91,15,FALSE)-J22","v":0}]
[]
[]
[]
["Guaranteed Unit Funding Calculation",null,null,null,null,null,null,null,null,"£"]
[]
["Adjusted Budget Share 2021/22",null,null,null,null,null,{"$f":"J22","v":609461.02359081549}]
[]
["October 2020 Pupil Number",null,null,null,null,null,{"$f":"VLOOKUP((\"P\"&$N$3),'[10]Minimum Funding Guarantee'!$A$4:$AK$91,5,FALSE)","v":143},{"$f":"VLOOKUP((\"P\"&$N$3),'[8]Minimum Funding Guarantee'!$A$4:$AK$91,9,FALSE)","v":809720.27666721749}]
[]
["Adjusted Budget Share 2021/22 Per Pupil",null,null,null,null,null,null,null,null,{"$f":"G28/G30","v":4261.9651999357729},null,null,null,{"$f":"VLOOKUP((\"P\"&$N$3),'[10]Minimum Funding Guarantee'!$A$4:$AK$91,16,FALSE)-J32","v":0}]
[]
["Minimum Funding Guarantee Protection Level",null,null,null,null,null,{"$f":"'[10]Minimum Funding Guarantee'!$R$3-1","v":2.0000000000000018E-2}]
[]
["2022/23 Guaranteed Unit Funding",null,null,null,null,null,null,null,null,{"$f":"J32*(1+G34)","v":4347.2045039344885}]
[]
[]
["Guaranteed Funding Level Calculation"]
[]
["2022/23 Guaranteed Unit Funding",null,null,null,null,null,{"$f":"J36","v":4347.2045039344885}]
[]
["October 2021 Pupil Number",null,null,null,null,null,{"$f":"VLOOKUP((\"P\"&$N$3),'[10]Minimum Funding Guarantee'!$A$4:$AK$91,6,FALSE)","v":136},{"$f":"VLOOKUP((\"P\"&$N$3),'[8]Minimum Funding Guarantee'!$A$4:$AK$91,9,FALSE)","v":809720.27666721749}]
[]
["2022/23 Guaranteed Funding Level",null,null,null,null,null,null,null,null,{"$f":"G41*G43","v":591219.81253509037}]
[]
["Add:"]
["2022/23 Rates",null,null,null,null,null,{"$f":"VLOOKUP((\"P\"&$N$3),'[10]Minimum Funding Guarantee'!$A$4:$AK$91,27,FALSE)","v":34048},{"$f":"VLOOKUP((\"P\"&$N$3),'[8]Minimum Funding Guarantee'!$A$4:$AK$91,9,FALSE)","v":809720.27666721749}]
[]
["2022/23 Lump Sum",null,null,null,null,null,{"$f":"VLOOKUP((\"P\"&$N$3),'[10]Minimum Funding Guarantee'!$A$4:$AK$91,26,FALSE)","v":121709.99399999999},{"$f":"VLOOKUP((\"P\"&$N$3),'[8]Minimum Funding Guarantee'!$A$4:$AK$91,9,FALSE)","v":809720.27666721749}]
[]
["2022/23 Split Site",null,null,null,null,null,{"$f":"VLOOKUP((\"P\"&$N$3),'[10]Minimum Funding Guarantee'!$A$4:$AK$91,29,FALSE)","v":0},{"$f":"VLOOKUP((\"P\"&$N$3),'[8]Minimum Funding Guarantee'!$A$4:$AK$91,9,FALSE)","v":809720.27666721749}]
[]
["2022/23 Education Improvement Commissioning Pot",null,null,null,null,null,{"$f":"VLOOKUP((\"P\"&$N$3),'[10]Minimum Funding Guarantee'!$A$4:$AK$91,28,FALSE)","v":1403.6042636251921},{"$f":"VLOOKUP((\"P\"&$N$3),'[8]Minimum Funding Guarantee'!$A$4:$AK$91,9,FALSE)","v":809720.27666721749},null,{"$f":"SUM(G48,G50,G52,G54)","v":157161.5982636252}]
[]
["2022/23 Minimum Funding Guarantee",null,null,null,null,null,null,null,null,{"$f":"J45+J54","v":748381.41079871554},null,null,null,{"$f":"VLOOKUP((\"P\"&$N$3),'[10]Minimum Funding Guarantee'!$A$4:$AK$91,19,FALSE)-J56","v":0}]
[]
[]
["2022/23 Minimum Funding Guarantee",null,null,null,null,null,{"$f":"J45+J54","v":748381.41079871554}]
[]
["2022/23 Total Formula Funding allocated pre-MFG",null,null,null,null,null,{"$f":"'Budget Share Statement'!K49","v":728310.43063448777}]
[]
["2022/23 MFG Protection (additional funding/top-slice)",null,null,null,null,null,null,null,null,{"$f":"IF(G59>G61,G59-G61,0)","v":20070.980164227774},null,null,null,{"$f":"VLOOKUP((\"P\"&$N$3),'[10]Minimum Funding Guarantee'!$A$4:$AK$91,23,FALSE)-J63","v":1.1641532182693481E-10}]
[]
["Note:"]
["The Minimum Funding Guarantee is compared with your Budget Share before 2022/23 de-delegated budgets are removed."]

{"sheet":"De-delegation","index":4,"n_rows":30,"n_cols":15,"rows_kept":30,"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: 4th July 2022"},null,null,null,null,null,null,null,null,null,{"$f":"'Summary of Funding'!H1","v":"Last amended: 1st July 2022"}]
["COVENTRY CITY COUNCIL"]
[{"$f":"'Summary of Funding'!A3:H3","v":"2022/23 Funding Allocations for Schools"},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Summary of Funding'!N3","v":25}]
[{"$f":"\"De-Delegation Detail\"","v":"De-Delegation Detail"}]
[]
[{"$f":"VLOOKUP((\"P\"&N3),[5]Formula!$A$10:$X$96,3,FALSE)","v":"Howes"},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-21 Census)",null,null,null,{"$f":"VLOOKUP((\"P\"&$N$3),[10]Data!$A$8:$AH$94,7,FALSE)","v":136},null,{"$f":"-'[10]New Del & De-Del'!$G$9","v":-26.16},null,{"$f":"G14*I14","v":-3557.76},null,null,null,{"$f":"VLOOKUP((\"P\"&N3),'[10]New Del & De-Del'!$A$20:$N$106,11,FALSE)+K14","v":0}]
["Trade Union Facility",null,"Pupil Number: (Oct-21 Census)",null,null,null,{"$f":"VLOOKUP((\"P\"&$N$3),[10]Data!$A$8:$AH$94,7,FALSE)","v":136},null,{"$f":"-'[10]New Del & De-Del'!$G$10","v":-4},null,{"$f":"G15*I15","v":-544},null,null,null,{"$f":"VLOOKUP((\"P\"&N3),'[10]New Del & De-Del'!$A$20:$N$106,12,FALSE)+K15","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(K14:K15)","v":-4101.76},null,null,null,{"$f":"VLOOKUP((\"P\"&N3),'[10]New Del & De-Del'!$A$20:$N$106,4,FALSE)+K17","v":0}]
["Deprivation Funding"]
["Free School Meal Eligibility",null,"Free School Meals: (Oct-21 FSM Eligibility)",null,null,null,{"$f":"VLOOKUP((\"P\"&$N$3),[10]Data!$A$8:$AH$94,20,FALSE)","v":44.000000000000014},null,{"$f":"-'[10]New Del & De-Del'!$G$7","v":-2.8446061144570325},null,{"$f":"G19*I19","v":-125.16266903610946},null,null,null,{"$f":"VLOOKUP((\"P\"&N3),'[10]New Del & De-Del'!$A$20:$N$106,5,FALSE)+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":"VLOOKUP((\"P\"&$N$3),[10]Data!$A$8:$AH$94,30,FALSE)","v":18.598290598290632},null,{"$f":"-'[10]New Del & De-Del'!$G$12","v":-70.917223548879193},null,{"$f":"G23*I23","v":-1318.9391319859949},null,null,null,{"$f":"VLOOKUP((\"P\"&N3),'[10]New Del & De-Del'!$A$20:$N$106,6,FALSE)+K23","v":0}]
[]
["Total De-Delegation",null,null,null,null,null,null,null,null,null,{"$f":"K17+K19+K23","v":-5545.8618010221044},null,null,null,{"$f":"VLOOKUP((\"P\"&N3),'[10]New Del & De-Del'!$A$20:$N$106,8,FALSE)+K25","v":0}]
[]
[]
["Notes"]
["Coventry Education Improvement Strategy funding is no longer part of the De-Delegation process. Instead schools will be invoiced for the "]
["amount of funding that they receive for this service. Full details can be found on the January Schools Forum report."]

{"sheet":"EYSFF statement","index":5,"n_rows":40,"n_cols":14,"rows_kept":40,"cut":false,"hidden":true,"merged":[[1,0,1,10],[2,0,2,10],[3,0,3,10],[5,0,5,10]]}
[{"$f":"'Summary of Funding'!A1","v":"Date Issued: 4th July 2022"},null,null,null,null,null,null,null,null,null,{"$f":"'Summary of Funding'!H1","v":"Last amended: 1st July 2022"}]
["COVENTRY CITY COUNCIL"]
[{"$f":"'Summary of Funding'!A3:H3","v":"2022/23 Funding Allocations for Schools"},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Summary of Funding'!N3","v":25}]
["INDICATIVE Early Years Funding Statement"]
[]
[{"$f":"VLOOKUP((\"P\"&N3),[5]Formula!$A$10:$X$96,3,FALSE)","v":"Howes"},null,null,null,null,null,null,null,null,null,null,null,null,"Checks"]
[]
[]
["School Data"]
[]
["IDACI based on January 2022 census",null,null,null,null,null,{"$f":"VLOOKUP((\"P\"&$N$3),'[10]Early Years Formula'!$A$10:$H$93,5,FALSE)","v":0.12090000000000001}]
["2022-23 Base Rate",null,null,null,null,null,{"$f":"VLOOKUP((\"P\"&$N$3),'[10]Early Years Formula'!$A$10:$H$93,6,FALSE)","v":4.21}]
["2022-23 Deprivation Rate",null,null,null,null,null,{"$f":"VLOOKUP((\"P\"&$N$3),'[10]Early Years Formula'!$A$10:$H$93,7,FALSE)","v":1.26}]
[]
[]
[null,null,null,null,"Summer \nTerm 2022",null,"Autumn\nTerm 2022",null,"Spring\nTerm 2023",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 22 census)",null,"(Per Oct 21 census)",null,"(Per Jan 22 census)"]
["Formula Factors",null,null,null,"Updated",null,"To be updated",null,"To be updated"]
["Free Entitlement Headcount",null,null,null,{"$f":"VLOOKUP((\"P\"&$N$3),'[10]Early Years Formula'!$A$10:$O$93,9,FALSE)","v":12},null,{"$f":"VLOOKUP((\"P\"&$N$3),'[10]Early Years Formula'!$A$10:$AD$93,16,FALSE)","v":8},null,{"$f":"VLOOKUP((\"P\"&$N$3),'[10]Early Years Formula'!$A$10:$AD$93,23,FALSE)","v":12}]
["Free Entitlement Hours Provided",null,null,null,{"$f":"VLOOKUP((\"P\"&$N$3),'[10]Early Years Formula'!$A$10:$O$93,8,FALSE)","v":2160},null,{"$f":"VLOOKUP((\"P\"&$N$3),'[10]Early Years Formula'!$A$10:$AD$93,15,FALSE)","v":1680},null,{"$f":"VLOOKUP((\"P\"&$N$3),'[10]Early Years Formula'!$A$10:$AD$93,22,FALSE)","v":2040}]
["Extended Entitlement Headcount",null,null,null,{"$f":"VLOOKUP((\"P\"&$N$3),'[10]Early Years Formula'!$A$10:$O$93,11,FALSE)","v":2},null,{"$f":"VLOOKUP((\"P\"&$N$3),'[10]Early Years Formula'!$A$10:$AD$93,18,FALSE)","v":2},null,{"$f":"VLOOKUP((\"P\"&$N$3),'[10]Early Years Formula'!$A$10:$AD$93,25,FALSE)","v":2}]
["Extended Entitlement Hours Provided",null,null,null,{"$f":"VLOOKUP((\"P\"&$N$3),'[10]Early Years Formula'!$A$10:$O$93,10,FALSE)","v":360},null,{"$f":"VLOOKUP((\"P\"&$N$3),'[10]Early Years Formula'!$A$10:$AD$93,17,FALSE)","v":420},null,{"$f":"VLOOKUP((\"P\"&$N$3),'[10]Early Years Formula'!$A$10:$AD$93,24,FALSE)","v":360}]
[]
["Base Rate Funding",null,null,null,{"$f":"(E21+E23)*$G12","v":10609.2},null,{"$f":"(G21+G23)*$G12","v":8841},null,{"$f":"(I21+I23)*$G12","v":10104}]
[]
["Deprivation Funding",null,null,null,{"$f":"IFERROR((E20+E22)*$G$13*15*12*$G$11,0)","v":383.88168000000007},null,{"$f":"IFERROR((G20+G22)*$G$13*15*14*$G$11,0)","v":319.90140000000002},null,{"$f":"IFERROR((I20+I22)*$G$13*15*12*$G$11,0)","v":383.88168000000007}]
[]
["Total 2022/23 Funding Under EYSFF (£)",null,null,null,{"$f":"E27+E25","v":10993.081680000001},null,{"$f":"G27+G25","v":9160.9014000000006},null,{"$f":"I27+I25","v":10487.88168},null,{"$f":"E29+G29+I29","v":30641.864760000004},null,null,{"$f":"VLOOKUP((\"P\"&$N$3),'[10]Early Years Formula'!$A$10:$AD$93,29,FALSE)-K29","v":0}]
[]
[]
["Note:"]
["This Early Years budget has been estimated based on full participation at the 21/22 census levels and 22/23 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-22, Autumn-22 and Spring-23 school census information. As in previous years, this means that your Early Years"]
["funding will not be finalised until after the Spring 2023 census has been finalised."]

{"sheet":"Further Delegation Info","index":6,"n_rows":26,"n_cols":14,"rows_kept":26,"cut":false,"hidden":true,"merged":[[3,0,3,7],[4,0,4,7],[5,0,5,7],[6,0,6,7],[8,0,9,7],[1,0,1,7],[10,0,13,7],[16,0,17,0],[16,1,17,1],[16,2,16,4],[16,5,16,7],[2,0,2,7]]}
[{"$f":"'Summary of Funding'!A1","v":"Date Issued: 4th July 2022"},null,null,null,null,null,null,{"$f":"'Summary of Funding'!H1","v":"Last amended: 1st July 2022"},null,null,null,null,null,"ID"]
["COVENTRY CITY COUNCIL"]
[{"$f":"'Summary of Funding'!A3:H3","v":"2022/23 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 2022/23 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 2021/22\" for your reference."]
[]
[]
[]
[]
[]
["S251 line","Further Delegation Areas","Delegated in 2013/14",null,null,"De-delegation in 2022/23"]
[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'!$I$7","v":13750.825957285297},0,{"$f":"SUM(F19:G19)","v":13750.825957285297}]
["1.1.7","Licences/subscriptions",56639.723182411013,35735.642889017559,92375.36607142858,{"$f":"'[11]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":"'[11]New Del & De-Del'!$I$9","v":501591.84},0,501591.84]
["1.1.9","Trade Union facility",195944.4399044039,123627.02600013438,319571.46590453829,{"$f":"'[11]New Del & De-Del'!$I$10","v":76696},0,76696]
["1.1.10","School Improvement",0,0,0,{"$f":"'[11]New Del & De-Del'!$I$11","v":0},0,0]
["1.1.3","Ethnic Minority Acheivement Service (EMAS)",991053,284303,1275356,{"$f":"'[11]New Del & De-Del'!$I$12","v":267459.6198581552},0,267459.6198581552]
["1.1.2","Behaviour support services",310504,256781,567285,{"$f":"-'[11]New Del & De-Del'!$I$13","v":0},{"$f":"-'[6]New Del & De-Del'!$J13","v":0},0]
[null,"Totals",{"$f":"SUM(C19:C25)","v":1931806.6610318511},936692.32827239169,2868498.9893042427,859498.28581544058,0,859498.28581544058,null,{"$f":"H26-'[10]New Del & De-Del'!$I$14","v":0}]

{"sheet":"ISB","index":7,"n_rows":45,"n_cols":10,"rows_kept":45,"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: 4th July 2022"},null,null,null,null,{"$f":"'Summary of Funding'!H1","v":"Last amended: 1st July 2022"},null,null,null,"ID"]
["COVENTRY CITY COUNCIL"]
["2022/23 Funding Allocations for Schools"]
[]
["Individual Schools Budget (ISB) 2022/23"]
[]
[]
["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 2021/22",{"$f":"'[12]PPR (New Blocks)'!$E$9","v":142688600.80349195},{"$f":"'[12]PPR (New Blocks)'!$F$9","v":119603664.55763626}]
[]
[null,"Removal of 2021/22 expenditure funded by reserves",{"$f":"'[12]PPR (New Blocks)'!$E$11","v":-246164.81223919988},{"$f":"'[12]PPR (New Blocks)'!$F$11","v":-203835.18776074052}]
[null,"Removal of Implicit Growth",{"$f":"'[12]PPR (New Blocks)'!$E$14","v":-175223.36087551713}]
[]
[null,"Revised Base for 2021/22",{"$f":"SUM(C19:C23)","v":142267212.63037723},{"$f":"SUM(D19:D23)","v":119399829.36987552}]
[]
[null,"Resource Adjustments"]
[null,"De-delegation adjustments",{"$f":"'[12]PPR (New Blocks)'!$E$22+'[12]PPR (New Blocks)'!$E$23","v":-10816.833365423721}]
[null,"NFF - protection resource",{"$f":"'[12]PPR (New Blocks)'!$E$35","v":2933825.4957099557},{"$f":"'[12]PPR (New Blocks)'!$F$35","v":2788768.4359978028}]
[]
[null,"Education Service PPR"]
[null,"Pupil number changes",{"$f":"'[12]PPR (New Blocks)'!$E$56+'[12]PPR (New Blocks)'!$E$57+'[12]PPR (New Blocks)'!$E$58","v":-1151210.1017199156},{"$f":"'[12]PPR (New Blocks)'!$F$57+'[12]PPR (New Blocks)'!$F$58","v":4961291.0189227965}]
[null,"PFI Factor Change",null,{"$f":"'[12]PPR (New Blocks)'!$F$36","v":21180.23180999991}]
[null,"National Non-Domestic Rates",{"$f":"'[12]PPR (New Blocks)'!$E$60","v":-92728.044036649168},{"$f":"'[12]PPR (New Blocks)'!$F$60","v":1760.859036650043}]
[null,"Coventry School Improvement Strategy commisioning pot",{"$f":"'[12]PPR (New Blocks)'!$E$45","v":240718.13121172786},{"$f":"'[12]PPR (New Blocks)'!$F$45","v":209281.86878824234}]
[]
[null,"FINAL ISB 2022/23",{"$f":"SUM(C24:C35)","v":144187001.27817693},{"$f":"SUM(D24:D35)","v":127382111.78443101}]
[]
[null,"Headroom/Efficiency Savings",0,0]
[]
[null,"FINAL ISB 2022/23",{"$f":"SUM(C36:C39)","v":144187001.27817693},{"$f":"SUM(D36:D39)","v":127382111.78443101}]
[]
[]
[]
[]
["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 ","NcR96N",1]
["Aldermoor Farm","8UBcN4",2]
["Allesley","uE98HX",3]
["Allesley Hall","c2r66H",4]
["Broad Heath","94ctnJ",5]
["Cannon Park","4V8gK4",6]
["Charter","bHkpG8",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],[17,8,17,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]]}
[{"$f":"'Summary of Funding'!A1","v":"Date Issued: 4th July 2022"},null,null,null,null,null,null,null,null,null,null,{"$f":"'Summary of Funding'!H1","v":"Last amended: 1st July 2022"}]
["COVENTRY CITY COUNCIL - PEOPLE'S DIRECTORATE"]
[{"$f":"'Summary of Funding'!A3:H3","v":"2022/23 Funding Allocations for Schools"},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Summary of Funding'!N3","v":25}]
["Calculation of Funding Floor"]
[]
[{"$f":"VLOOKUP((\"P\"&N3),[5]Formula!$A$10:$X$96,3,FALSE)","v":"Howes"},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),'[7]Funding Floor'!$A$3:$U$90,6,FALSE)","v":775536.03023775283},null,{"$f":"VLOOKUP((\"P\"&$N$3),'[7]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),'[7]Funding Floor'!$A$3:$U$90,7,FALSE)","v":750.75168349314936},{"$f":"VLOOKUP((\"P\"&$N$3),'[7]Funding Floor'!$A$3:$U$90,6,FALSE)","v":775536.03023775283},null,null,null,{"$f":"VLOOKUP((\"P\"&$N$3),'[7]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),'[7]Funding Floor'!$A$3:$U$90,8,FALSE)","v":110364.09999999999},{"$f":"VLOOKUP((\"P\"&$N$3),'[7]Funding Floor'!$A$3:$U$90,6,FALSE)","v":775536.03023775283},null,null,null,{"$f":"VLOOKUP((\"P\"&$N$3),'[7]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),'[7]Funding Floor'!$A$3:$U$90,9,FALSE)","v":0},{"$f":"VLOOKUP((\"P\"&$N$3),'[7]Funding Floor'!$A$3:$U$90,6,FALSE)","v":775536.03023775283},null,null,null,{"$f":"VLOOKUP((\"P\"&$N$3),'[7]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),'[7]Funding Floor'!$A$3:$U$90,11,FALSE)","v":33516},{"$f":"VLOOKUP((\"P\"&$N$3),'[7]Funding Floor'!$A$3:$U$90,6,FALSE)","v":775536.03023775283},null,null,null,{"$f":"VLOOKUP((\"P\"&$N$3),'[7]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),'[7]Funding Floor'!$A$3:$U$90,12,FALSE)","v":1518.28570372439},{"$f":"VLOOKUP((\"P\"&$N$3),'[7]Funding Floor'!$A$3:$U$90,6,FALSE)","v":775536.03023775283},null,{"$f":"-SUM(I14:I22)","v":-146149.13738721752},null,{"$f":"VLOOKUP((\"P\"&$N$3),'[7]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":629386.89285053534},null,{"$f":"VLOOKUP((\"P\"&$N$3),'[7]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),'[7]Funding Floor'!$A$3:$U$90,17,FALSE)","v":168},{"$f":"VLOOKUP((\"P\"&$N$3),'[7]Funding Floor'!$A$3:$U$90,6,FALSE)","v":775536.03023775283},null,null,null,{"$f":"VLOOKUP((\"P\"&$N$3),'[7]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":3746.350552681758},null,{"$f":"VLOOKUP((\"P\"&$N$3),'[7]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),'[7]Funding Floor'!$A$3:$U$90,4,FALSE)","v":3910.721},{"$f":"VLOOKUP((\"P\"&$N$3),'[7]Funding Floor'!$A$3:$U$90,6,FALSE)","v":775536.03023775283},null,null,null,{"$f":"VLOOKUP((\"P\"&$N$3),'[7]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":3949.8282100000001}]
[]
["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":203.47765731824211}]
[]
[]
[]
["2020/21 Funding Floor Adjustment",null,null,null,null,null,null,"= [A] x [D]",null,null,null,{"$f":"L38*I27","v":34184.246429464678},null,{"$f":"VLOOKUP((\"P\"&$N$3),'[7]Funding Floor'!$A$3:$U$90,21,FALSE)-L42","v":0}]