{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Introduction","Benchmarking","2022-23 Data","PFI Adjustments"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":4,"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":"Introduction","index":0,"n_rows":18,"n_cols":5,"rows_kept":18,"cut":false,"hidden":false,"merged":[[12,4,13,4]]}
[]
[]
[null,{"$f":"Benchmarking!C1&\" Data\"","v":"2022-23 Data"},null,null,{"$f":"\"Kent LA Schools' Benchmarking Data \"&Benchmarking!C1","v":"Kent LA Schools' Benchmarking Data 2022-23"}]
[]
[null,null,null,null,"THIS BENCHMARKING SHEET IS FOR SECONDARY SCHOOLS ONLY"]
[]
[null,null,null,null,{"$f":"\"The Benchmarking spreadsheet shows the income and expenditure information for the \"&Benchmarking!C1&\" financial year at subjective account level i.e. CFR codes. It shows all revenue income and expenditure including standards funds.\"","v":"The Benchmarking spreadsheet shows the income and expenditure information for the 2022-23 financial year at subjective account level i.e. CFR codes. It shows all revenue income and expenditure including standards funds."}]
[]
[null,null,null,null,"Capital income and expenditure is excluded."]
[]
[null,null,null,null,"Enter your DFE number in the green shaded box, you can enter the last four digits or use the drop down box.  "]
[]
[null,null,null,null,"The green drop down boxes allow you to select up to three Schools to benchmark against, the grey area allows you to benchmark against the average of the Schools you selected"]
[]
[]
[null,null,null,null,"The sheet is formatted to print on one page."]
[]
[null,null,null,null,"CFR = Consistent Financial Reporting"]

{"sheet":"Benchmarking","index":1,"n_rows":72,"n_cols":22,"rows_kept":72,"cut":false,"hidden":false,"merged":[[7,3,7,5],[6,7,6,9],[51,4,52,17],[3,7,3,9],[3,11,3,13],[7,11,7,13],[7,7,7,9],[5,1,6,4],[6,19,7,21],[2,7,2,9],[2,11,2,13],[2,15,2,17],[3,15,3,17],[7,15,7,17],[6,11,6,13],[6,15,6,17]]}
[null,"Subjective Analysis of ","2022-23"," Income and Expenditure Compared to Group and Phase Averages"]
[]
[null,null,null,null,"11-16","Post 16",null,"Select a school to Benchmark against",null,null,null,"Select a school to Benchmark against",null,null,null,"Select a school to Benchmark against"]
[null,"Enter last 4 digits of your DfE No.",null,"Pupil Roll",{"$f":"IF(ISERROR(VLOOKUP(C4,'2022-23 Data'!$A$3:$C$20,3,0)),\"\",VLOOKUP(C4,'2022-23 Data'!$A$3:$C$20,3,0)+VLOOKUP(C4,'2022-23 Data'!$A$3:$E$20,5,0))","v":""},{"$f":"IF(ISERROR(VLOOKUP(C4,'2022-23 Data'!$A$3:$D$20,4,0)),\"\",VLOOKUP(C4,'2022-23 Data'!$A$3:$D$20,4,0))","v":""}]
[null,null,null,null,null,null,null,null,"11-16","Post 16",null,null,"11-16","Post 16",null,null,"11-16","Post 16"]
[null,{"$f":"B1&C1&D1","v":"Subjective Analysis of 2022-23 Income and Expenditure Compared to Group and Phase Averages"},null,null,null,null,null,{"$f":"IF(ISERROR(SUMIF(schools,H4,dfenums)),\"\",SUMIF(schools,H4,dfenums))","v":0},{"$f":"IF(ISERROR(VLOOKUP(H6,'2022-23 Data'!$A$3:$C$20,3,0)),\"\",VLOOKUP(H6,'2022-23 Data'!$A$3:$C$20,3,0))","v":""},{"$f":"IF(ISERROR(VLOOKUP(H6,'2022-23 Data'!$A$3:$D$20,4,0)),\"\",VLOOKUP(H6,'2022-23 Data'!$A$3:$D$20,4,0))","v":""},null,{"$f":"IF(ISERROR(SUMIF(schools,L4,dfenums)),\"\",SUMIF(schools,L4,dfenums))","v":0},{"$f":"IF(ISERROR(VLOOKUP(L6,'2022-23 Data'!$A$3:$C$20,3,0)),\"\",VLOOKUP(L6,'2022-23 Data'!$A$3:$C$20,3,0))","v":""},{"$f":"IF(ISERROR(VLOOKUP(L6,'2022-23 Data'!$A$3:$D$20,4,0)),\"\",VLOOKUP(L6,'2022-23 Data'!$A$3:$D$20,4,0))","v":""},null,{"$f":"IF(ISERROR(SUMIF(schools,P4,dfenums)),\"\",SUMIF(schools,P4,dfenums))","v":0},{"$f":"IF(ISERROR(VLOOKUP(P6,'2022-23 Data'!$A$3:$C$20,3,0)),\"\",VLOOKUP(P6,'2022-23 Data'!$A$3:$C$20,3,0))","v":""},{"$f":"IF(ISERROR(VLOOKUP(P6,'2022-23 Data'!$A$3:$D$20,4,0)),\"\",VLOOKUP(P6,'2022-23 Data'!$A$3:$D$20,4,0))","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(H4=\"\",\"\",IF(C4=H6,\"This is your school\",\"\"))","v":""},null,null,null,{"$f":"IF(L4=\"\",\"\",IF(L6=H6,\"You have already selected this school\",IF(L6=C4,\"This is your school\",\"\")))","v":""},null,null,null,{"$f":"IF(P4=\"\",\"\",IF(OR(P6=L6,P6=H6),\"You have already selected this school\",IF(P6=C4,\"This is your school\",\"\")))","v":""},null,null,null,"All Kent Secondary Schools"]
[]
[null,{"$f":"IF(C4=\"\",\"\",VLOOKUP($C$4,'2022-23 Data'!A3:B280,2,0))","v":""},null,"total\nExp. / Inc.","amount\nper Pupil","% of total \nExp.",null,"total\nExp. / Inc.","amount\nper Pupil","% of total \nExp.",null,"total\nExp. / Inc.","amount\nper Pupil","% of total \nExp.",null,"total\nExp. / Inc.","amount\nper Pupil","% of total \nExp.",null,"amount\nper Pupil","% of total \nExp.","% of Exp / total inc."]
[null,null,null,"£","£","%",null,"£","£","%",null,"£","£","%",null,"£","£","%",null,"£","%","%"]
[]
[null,"EXPENDITURE"]
[null,"Teaching staff","E01",{"$f":"IF(ISERROR(INDEX('2022-23 Data'!$B$3:$BJ$20,MATCH($C$4,dfenums,0),MATCH($C13,'2022-23 Data'!$B$2:$BJ$2,0))),\"\",INDEX('2022-23 Data'!$B$3:$BJ$20,MATCH($C$4,dfenums,0),MATCH($C13,'2022-23 Data'!$B$2:$BJ$2,0)))","v":""},{"$f":"IF($C$4>0,D13/($E$4+$F$4),\"\")","v":""},{"$f":"IF($C$4>0,D13/$D$46,\"\")","v":""},null,{"$f":"IF(ISERROR(INDEX('2022-23 Data'!$B$3:$BJ$20,MATCH($H$6,dfenums,0),MATCH($C13,'2022-23 Data'!$B$2:$BJ$2,0))),\"\",INDEX('2022-23 Data'!$B$3:$BJ$20,MATCH($H$6,dfenums,0),MATCH($C13,'2022-23 Data'!$B$2:$BJ$2,0)))","v":""},{"$f":"IF($H$6>0,H13/($I$6+$J$6),\"\")","v":""},{"$f":"IF($H$6>0,H13/$H$46,\"\")","v":""},null,{"$f":"IF(ISERROR(INDEX('2022-23 Data'!$B$3:$BJ$20,MATCH($L$6,dfenums,0),MATCH($C13,'2022-23 Data'!$B$2:$BJ$2,0))),\"\",INDEX('2022-23 Data'!$B$3:$BJ$20,MATCH($L$6,dfenums,0),MATCH($C13,'2022-23 Data'!$B$2:$BJ$2,0)))","v":""},{"$f":"IF($L$6>0,L13/($M$6+$N$6),\"\")","v":""},{"$f":"IF($L$6>0,L13/$L$46,\"\")","v":""},null,{"$f":"IF(ISERROR(INDEX('2022-23 Data'!$B$3:$BJ$20,MATCH($P$6,dfenums,0),MATCH($C13,'2022-23 Data'!$B$2:$BJ$2,0))),\"\",INDEX('2022-23 Data'!$B$3:$BJ$20,MATCH($P$6,dfenums,0),MATCH($C13,'2022-23 Data'!$B$2:$BJ$2,0)))","v":""},{"$f":"IF($P$6>0,P13/($Q$6+$R$6),\"\")","v":""},{"$f":"IF($P$6>0,P13/$P$46,\"\")","v":""},null,{"$f":"IF(ISERROR(SUM('2022-23 Data'!F$3:F$20)/SUM('2022-23 Data'!$C$3:$D$20)),\"\",SUM('2022-23 Data'!F$3:F$20)/SUM('2022-23 Data'!$C$3:$D$20))","v":3712.3409144899088},{"$f":"IF(ISERROR(T13/$T$46),\"\",T13/$T$46)","v":0.52919713972983318},{"$f":"IF(ISERROR(T13/-$T$72),\"\",T13/-$T$72)","v":0.34893231435047428}]
[null,"Supply teaching staff","E02",{"$f":"IF(ISERROR(INDEX('2022-23 Data'!$B$3:$BJ$20,MATCH($C$4,dfenums,0),MATCH($C14,'2022-23 Data'!$B$2:$BJ$2,0))),\"\",INDEX('2022-23 Data'!$B$3:$BJ$20,MATCH($C$4,dfenums,0),MATCH($C14,'2022-23 Data'!$B$2:$BJ$2,0)))","v":""},"","",null,{"$f":"IF(ISERROR(INDEX('2022-23 Data'!$B$3:$BJ$20,MATCH($H$6,dfenums,0),MATCH($C14,'2022-23 Data'!$B$2:$BJ$2,0))),\"\",INDEX('2022-23 Data'!$B$3:$BJ$20,MATCH($H$6,dfenums,0),MATCH($C14,'2022-23 Data'!$B$2:$BJ$2,0)))","v":""},{"$f":"IF($H$6>0,H14/($I$6+$J$6),\"\")","v":""},{"$f":"IF($H$6>0,H14/$H$46,\"\")","v":""},null,{"$f":"IF(ISERROR(INDEX('2022-23 Data'!$B$3:$BJ$20,MATCH($L$6,dfenums,0),MATCH($C14,'2022-23 Data'!$B$2:$BJ$2,0))),\"\",INDEX('2022-23 Data'!$B$3:$BJ$20,MATCH($L$6,dfenums,0),MATCH($C14,'2022-23 Data'!$B$2:$BJ$2,0)))","v":""},{"$f":"IF($L$6>0,L14/($M$6+$N$6),\"\")","v":""},{"$f":"IF($L$6>0,L14/$L$46,\"\")","v":""},null,{"$f":"IF(ISERROR(INDEX('2022-23 Data'!$B$3:$BJ$20,MATCH($P$6,dfenums,0),MATCH($C14,'2022-23 Data'!$B$2:$BJ$2,0))),\"\",INDEX('2022-23 Data'!$B$3:$BJ$20,MATCH($P$6,dfenums,0),MATCH($C14,'2022-23 Data'!$B$2:$BJ$2,0)))","v":""},{"$f":"IF($P$6>0,P14/($Q$6+$R$6),\"\")","v":""},{"$f":"IF($P$6>0,P14/$P$46,\"\")","v":""},null,{"$f":"IF(ISERROR(SUM('2022-23 Data'!G$3:G$20)/SUM('2022-23 Data'!$C$3:$D$20)),\"\",SUM('2022-23 Data'!G$3:G$20)/SUM('2022-23 Data'!$C$3:$D$20))","v":5.2159343701243142},{"$f":"IF(ISERROR(T14/$T$46),\"\",T14/$T$46)","v":7.4353557856568443E-4},{"$f":"IF(ISERROR(T14/-$T$72),\"\",T14/-$T$72)","v":4.9025886716488084E-4}]
[null,"Education support staff","E03",{"$f":"IF(ISERROR(INDEX('2022-23 Data'!$B$3:$BJ$20,MATCH($C$4,dfenums,0),MATCH($C15,'2022-23 Data'!$B$2:$BJ$2,0))),\"\",INDEX('2022-23 Data'!$B$3:$BJ$20,MATCH($C$4,dfenums,0),MATCH($C15,'2022-23 Data'!$B$2:$BJ$2,0)))","v":""},"","",null,{"$f":"IF(ISERROR(INDEX('2022-23 Data'!$B$3:$BJ$20,MATCH($H$6,dfenums,0),MATCH($C15,'2022-23 Data'!$B$2:$BJ$2,0))),\"\",INDEX('2022-23 Data'!$B$3:$BJ$20,MATCH($H$6,dfenums,0),MATCH($C15,'2022-23 Data'!$B$2:$BJ$2,0)))","v":""},"","",null,{"$f":"IF(ISERROR(INDEX('2022-23 Data'!$B$3:$BJ$20,MATCH($L$6,dfenums,0),MATCH($C15,'2022-23 Data'!$B$2:$BJ$2,0))),\"\",INDEX('2022-23 Data'!$B$3:$BJ$20,MATCH($L$6,dfenums,0),MATCH($C15,'2022-23 Data'!$B$2:$BJ$2,0)))","v":""},"","",null,{"$f":"IF(ISERROR(INDEX('2022-23 Data'!$B$3:$BJ$20,MATCH($P$6,dfenums,0),MATCH($C15,'2022-23 Data'!$B$2:$BJ$2,0))),\"\",INDEX('2022-23 Data'!$B$3:$BJ$20,MATCH($P$6,dfenums,0),MATCH($C15,'2022-23 Data'!$B$2:$BJ$2,0)))","v":""},"","",null,{"$f":"IF(ISERROR(SUM('2022-23 Data'!H$3:H$20)/SUM('2022-23 Data'!$C$3:$D$20)),\"\",SUM('2022-23 Data'!H$3:H$20)/SUM('2022-23 Data'!$C$3:$D$20))","v":700.17159142382593},9.9810015307413194E-2,6.5810899231904155E-2]
[null,"Premises staff","E04",{"$f":"IF(ISERROR(INDEX('2022-23 Data'!$B$3:$BJ$20,MATCH($C$4,dfenums,0),MATCH($C16,'2022-23 Data'!$B$2:$BJ$2,0))),\"\",INDEX('2022-23 Data'!$B$3:$BJ$20,MATCH($C$4,dfenums,0),MATCH($C16,'2022-23 Data'!$B$2:$BJ$2,0)))","v":""},"","",null,{"$f":"IF(ISERROR(INDEX('2022-23 Data'!$B$3:$BJ$20,MATCH($H$6,dfenums,0),MATCH($C16,'2022-23 Data'!$B$2:$BJ$2,0))),\"\",INDEX('2022-23 Data'!$B$3:$BJ$20,MATCH($H$6,dfenums,0),MATCH($C16,'2022-23 Data'!$B$2:$BJ$2,0)))","v":""},"","",null,{"$f":"IF(ISERROR(INDEX('2022-23 Data'!$B$3:$BJ$20,MATCH($L$6,dfenums,0),MATCH($C16,'2022-23 Data'!$B$2:$BJ$2,0))),\"\",INDEX('2022-23 Data'!$B$3:$BJ$20,MATCH($L$6,dfenums,0),MATCH($C16,'2022-23 Data'!$B$2:$BJ$2,0)))","v":""},"","",null,{"$f":"IF(ISERROR(INDEX('2022-23 Data'!$B$3:$BJ$20,MATCH($P$6,dfenums,0),MATCH($C16,'2022-23 Data'!$B$2:$BJ$2,0))),\"\",INDEX('2022-23 Data'!$B$3:$BJ$20,MATCH($P$6,dfenums,0),MATCH($C16,'2022-23 Data'!$B$2:$BJ$2,0)))","v":""},"","",null,{"$f":"IF(ISERROR(SUM('2022-23 Data'!I$3:I$20)/SUM('2022-23 Data'!$C$3:$D$20)),\"\",SUM('2022-23 Data'!I$3:I$20)/SUM('2022-23 Data'!$C$3:$D$20))","v":135.59963762645327},1.9329835818750748E-2,1.2745352992071659E-2]
[null,"Administrative and clerical staff","E05",{"$f":"IF(ISERROR(INDEX('2022-23 Data'!$B$3:$BJ$20,MATCH($C$4,dfenums,0),MATCH($C17,'2022-23 Data'!$B$2:$BJ$2,0))),\"\",INDEX('2022-23 Data'!$B$3:$BJ$20,MATCH($C$4,dfenums,0),MATCH($C17,'2022-23 Data'!$B$2:$BJ$2,0)))","v":""},"","",null,{"$f":"IF(ISERROR(INDEX('2022-23 Data'!$B$3:$BJ$20,MATCH($H$6,dfenums,0),MATCH($C17,'2022-23 Data'!$B$2:$BJ$2,0))),\"\",INDEX('2022-23 Data'!$B$3:$BJ$20,MATCH($H$6,dfenums,0),MATCH($C17,'2022-23 Data'!$B$2:$BJ$2,0)))","v":""},"","",null,{"$f":"IF(ISERROR(INDEX('2022-23 Data'!$B$3:$BJ$20,MATCH($L$6,dfenums,0),MATCH($C17,'2022-23 Data'!$B$2:$BJ$2,0))),\"\",INDEX('2022-23 Data'!$B$3:$BJ$20,MATCH($L$6,dfenums,0),MATCH($C17,'2022-23 Data'!$B$2:$BJ$2,0)))","v":""},"","",null,{"$f":"IF(ISERROR(INDEX('2022-23 Data'!$B$3:$BJ$20,MATCH($P$6,dfenums,0),MATCH($C17,'2022-23 Data'!$B$2:$BJ$2,0))),\"\",INDEX('2022-23 Data'!$B$3:$BJ$20,MATCH($P$6,dfenums,0),MATCH($C17,'2022-23 Data'!$B$2:$BJ$2,0)))","v":""},"","",null,{"$f":"IF(ISERROR(SUM('2022-23 Data'!J$3:J$20)/SUM('2022-23 Data'!$C$3:$D$20)),\"\",SUM('2022-23 Data'!J$3:J$20)/SUM('2022-23 Data'!$C$3:$D$20))","v":346.66898535406921},4.9417938629061638E-2,3.2584294966279251E-2]
[null,"Catering staff","E06",{"$f":"IF(ISERROR(INDEX('2022-23 Data'!$B$3:$BJ$20,MATCH($C$4,dfenums,0),MATCH($C18,'2022-23 Data'!$B$2:$BJ$2,0))),\"\",INDEX('2022-23 Data'!$B$3:$BJ$20,MATCH($C$4,dfenums,0),MATCH($C18,'2022-23 Data'!$B$2:$BJ$2,0)))","v":""},"","",null,{"$f":"IF(ISERROR(INDEX('2022-23 Data'!$B$3:$BJ$20,MATCH($H$6,dfenums,0),MATCH($C18,'2022-23 Data'!$B$2:$BJ$2,0))),\"\",INDEX('2022-23 Data'!$B$3:$BJ$20,MATCH($H$6,dfenums,0),MATCH($C18,'2022-23 Data'!$B$2:$BJ$2,0)))","v":""},"","",null,{"$f":"IF(ISERROR(INDEX('2022-23 Data'!$B$3:$BJ$20,MATCH($L$6,dfenums,0),MATCH($C18,'2022-23 Data'!$B$2:$BJ$2,0))),\"\",INDEX('2022-23 Data'!$B$3:$BJ$20,MATCH($L$6,dfenums,0),MATCH($C18,'2022-23 Data'!$B$2:$BJ$2,0)))","v":""},"","",null,{"$f":"IF(ISERROR(INDEX('2022-23 Data'!$B$3:$BJ$20,MATCH($P$6,dfenums,0),MATCH($C18,'2022-23 Data'!$B$2:$BJ$2,0))),\"\",INDEX('2022-23 Data'!$B$3:$BJ$20,MATCH($P$6,dfenums,0),MATCH($C18,'2022-23 Data'!$B$2:$BJ$2,0)))","v":""},"","",null,{"$f":"IF(ISERROR(SUM('2022-23 Data'!K$3:K$20)/SUM('2022-23 Data'!$C$3:$D$20)),\"\",SUM('2022-23 Data'!K$3:K$20)/SUM('2022-23 Data'!$C$3:$D$20))","v":31.443218078413611},4.4822556587005222E-3,2.9554276149325776E-3]
[null,"Cost of other staff","E07",{"$f":"IF(ISERROR(INDEX('2022-23 Data'!$B$3:$BJ$20,MATCH($C$4,dfenums,0),MATCH($C19,'2022-23 Data'!$B$2:$BJ$2,0))),\"\",INDEX('2022-23 Data'!$B$3:$BJ$20,MATCH($C$4,dfenums,0),MATCH($C19,'2022-23 Data'!$B$2:$BJ$2,0)))","v":""},"","",null,{"$f":"IF(ISERROR(INDEX('2022-23 Data'!$B$3:$BJ$20,MATCH($H$6,dfenums,0),MATCH($C19,'2022-23 Data'!$B$2:$BJ$2,0))),\"\",INDEX('2022-23 Data'!$B$3:$BJ$20,MATCH($H$6,dfenums,0),MATCH($C19,'2022-23 Data'!$B$2:$BJ$2,0)))","v":""},"","",null,{"$f":"IF(ISERROR(INDEX('2022-23 Data'!$B$3:$BJ$20,MATCH($L$6,dfenums,0),MATCH($C19,'2022-23 Data'!$B$2:$BJ$2,0))),\"\",INDEX('2022-23 Data'!$B$3:$BJ$20,MATCH($L$6,dfenums,0),MATCH($C19,'2022-23 Data'!$B$2:$BJ$2,0)))","v":""},"","",null,{"$f":"IF(ISERROR(INDEX('2022-23 Data'!$B$3:$BJ$20,MATCH($P$6,dfenums,0),MATCH($C19,'2022-23 Data'!$B$2:$BJ$2,0))),\"\",INDEX('2022-23 Data'!$B$3:$BJ$20,MATCH($P$6,dfenums,0),MATCH($C19,'2022-23 Data'!$B$2:$BJ$2,0)))","v":""},"","",null,{"$f":"IF(ISERROR(SUM('2022-23 Data'!L$3:L$20)/SUM('2022-23 Data'!$C$3:$D$20)),\"\",SUM('2022-23 Data'!L$3:L$20)/SUM('2022-23 Data'!$C$3:$D$20))","v":22.543472243192912},3.2135898360282464E-3,2.1189179885419611E-3]
[null,"Indirect employee expenses","E08",{"$f":"IF(ISERROR(INDEX('2022-23 Data'!$B$3:$BJ$20,MATCH($C$4,dfenums,0),MATCH($C20,'2022-23 Data'!$B$2:$BJ$2,0))),\"\",INDEX('2022-23 Data'!$B$3:$BJ$20,MATCH($C$4,dfenums,0),MATCH($C20,'2022-23 Data'!$B$2:$BJ$2,0)))","v":""},"","",null,{"$f":"IF(ISERROR(INDEX('2022-23 Data'!$B$3:$BJ$20,MATCH($H$6,dfenums,0),MATCH($C20,'2022-23 Data'!$B$2:$BJ$2,0))),\"\",INDEX('2022-23 Data'!$B$3:$BJ$20,MATCH($H$6,dfenums,0),MATCH($C20,'2022-23 Data'!$B$2:$BJ$2,0)))","v":""},"","",null,{"$f":"IF(ISERROR(INDEX('2022-23 Data'!$B$3:$BJ$20,MATCH($L$6,dfenums,0),MATCH($C20,'2022-23 Data'!$B$2:$BJ$2,0))),\"\",INDEX('2022-23 Data'!$B$3:$BJ$20,MATCH($L$6,dfenums,0),MATCH($C20,'2022-23 Data'!$B$2:$BJ$2,0)))","v":""},"","",null,{"$f":"IF(ISERROR(INDEX('2022-23 Data'!$B$3:$BJ$20,MATCH($P$6,dfenums,0),MATCH($C20,'2022-23 Data'!$B$2:$BJ$2,0))),\"\",INDEX('2022-23 Data'!$B$3:$BJ$20,MATCH($P$6,dfenums,0),MATCH($C20,'2022-23 Data'!$B$2:$BJ$2,0)))","v":""},"","",null,{"$f":"IF(ISERROR(SUM('2022-23 Data'!M$3:M$20)/SUM('2022-23 Data'!$C$3:$D$20)),\"\",SUM('2022-23 Data'!M$3:M$20)/SUM('2022-23 Data'!$C$3:$D$20))","v":33.075869948160452},4.7149914767586837E-3,3.1088846945924262E-3]
[null,"Development and training","E09",{"$f":"IF(ISERROR(INDEX('2022-23 Data'!$B$3:$BJ$20,MATCH($C$4,dfenums,0),MATCH($C21,'2022-23 Data'!$B$2:$BJ$2,0))),\"\",INDEX('2022-23 Data'!$B$3:$BJ$20,MATCH($C$4,dfenums,0),MATCH($C21,'2022-23 Data'!$B$2:$BJ$2,0)))","v":""},"","",null,{"$f":"IF(ISERROR(INDEX('2022-23 Data'!$B$3:$BJ$20,MATCH($H$6,dfenums,0),MATCH($C21,'2022-23 Data'!$B$2:$BJ$2,0))),\"\",INDEX('2022-23 Data'!$B$3:$BJ$20,MATCH($H$6,dfenums,0),MATCH($C21,'2022-23 Data'!$B$2:$BJ$2,0)))","v":""},"","",null,{"$f":"IF(ISERROR(INDEX('2022-23 Data'!$B$3:$BJ$20,MATCH($L$6,dfenums,0),MATCH($C21,'2022-23 Data'!$B$2:$BJ$2,0))),\"\",INDEX('2022-23 Data'!$B$3:$BJ$20,MATCH($L$6,dfenums,0),MATCH($C21,'2022-23 Data'!$B$2:$BJ$2,0)))","v":""},"","",null,{"$f":"IF(ISERROR(INDEX('2022-23 Data'!$B$3:$BJ$20,MATCH($P$6,dfenums,0),MATCH($C21,'2022-23 Data'!$B$2:$BJ$2,0))),\"\",INDEX('2022-23 Data'!$B$3:$BJ$20,MATCH($P$6,dfenums,0),MATCH($C21,'2022-23 Data'!$B$2:$BJ$2,0)))","v":""},"","",null,{"$f":"IF(ISERROR(SUM('2022-23 Data'!N$3:N$20)/SUM('2022-23 Data'!$C$3:$D$20)),\"\",SUM('2022-23 Data'!N$3:N$20)/SUM('2022-23 Data'!$C$3:$D$20))","v":23.496404449141878},3.3494310772720949E-3,2.2084864973885045E-3]
[null,"Supply teacher insurance","E10",{"$f":"IF(ISERROR(INDEX('2022-23 Data'!$B$3:$BJ$20,MATCH($C$4,dfenums,0),MATCH($C22,'2022-23 Data'!$B$2:$BJ$2,0))),\"\",INDEX('2022-23 Data'!$B$3:$BJ$20,MATCH($C$4,dfenums,0),MATCH($C22,'2022-23 Data'!$B$2:$BJ$2,0)))","v":""},"","",null,{"$f":"IF(ISERROR(INDEX('2022-23 Data'!$B$3:$BJ$20,MATCH($H$6,dfenums,0),MATCH($C22,'2022-23 Data'!$B$2:$BJ$2,0))),\"\",INDEX('2022-23 Data'!$B$3:$BJ$20,MATCH($H$6,dfenums,0),MATCH($C22,'2022-23 Data'!$B$2:$BJ$2,0)))","v":""},"","",null,{"$f":"IF(ISERROR(INDEX('2022-23 Data'!$B$3:$BJ$20,MATCH($L$6,dfenums,0),MATCH($C22,'2022-23 Data'!$B$2:$BJ$2,0))),\"\",INDEX('2022-23 Data'!$B$3:$BJ$20,MATCH($L$6,dfenums,0),MATCH($C22,'2022-23 Data'!$B$2:$BJ$2,0)))","v":""},"","",null,{"$f":"IF(ISERROR(INDEX('2022-23 Data'!$B$3:$BJ$20,MATCH($P$6,dfenums,0),MATCH($C22,'2022-23 Data'!$B$2:$BJ$2,0))),\"\",INDEX('2022-23 Data'!$B$3:$BJ$20,MATCH($P$6,dfenums,0),MATCH($C22,'2022-23 Data'!$B$2:$BJ$2,0)))","v":""},"","",null,{"$f":"IF(ISERROR(SUM('2022-23 Data'!O$3:O$20)/SUM('2022-23 Data'!$C$3:$D$20)),\"\",SUM('2022-23 Data'!O$3:O$20)/SUM('2022-23 Data'!$C$3:$D$20))","v":1.5604293119935582},2.2244043520745654E-4,1.4666869874181397E-4]
[null,"Staff related insurance","E11",{"$f":"IF(ISERROR(INDEX('2022-23 Data'!$B$3:$BJ$20,MATCH($C$4,dfenums,0),MATCH($C23,'2022-23 Data'!$B$2:$BJ$2,0))),\"\",INDEX('2022-23 Data'!$B$3:$BJ$20,MATCH($C$4,dfenums,0),MATCH($C23,'2022-23 Data'!$B$2:$BJ$2,0)))","v":""},"","",null,{"$f":"IF(ISERROR(INDEX('2022-23 Data'!$B$3:$BJ$20,MATCH($H$6,dfenums,0),MATCH($C23,'2022-23 Data'!$B$2:$BJ$2,0))),\"\",INDEX('2022-23 Data'!$B$3:$BJ$20,MATCH($H$6,dfenums,0),MATCH($C23,'2022-23 Data'!$B$2:$BJ$2,0)))","v":""},"","",null,{"$f":"IF(ISERROR(INDEX('2022-23 Data'!$B$3:$BJ$20,MATCH($L$6,dfenums,0),MATCH($C23,'2022-23 Data'!$B$2:$BJ$2,0))),\"\",INDEX('2022-23 Data'!$B$3:$BJ$20,MATCH($L$6,dfenums,0),MATCH($C23,'2022-23 Data'!$B$2:$BJ$2,0)))","v":""},"","",null,{"$f":"IF(ISERROR(INDEX('2022-23 Data'!$B$3:$BJ$20,MATCH($P$6,dfenums,0),MATCH($C23,'2022-23 Data'!$B$2:$BJ$2,0))),\"\",INDEX('2022-23 Data'!$B$3:$BJ$20,MATCH($P$6,dfenums,0),MATCH($C23,'2022-23 Data'!$B$2:$BJ$2,0)))","v":""},"","",null,{"$f":"IF(ISERROR(SUM('2022-23 Data'!P$3:P$20)/SUM('2022-23 Data'!$C$3:$D$20)),\"\",SUM('2022-23 Data'!P$3:P$20)/SUM('2022-23 Data'!$C$3:$D$20))","v":18.829392521012632},2.6841448278839869E-3,1.7698222392576843E-3]
[null,"Building maintenance and improvement","E12",{"$f":"IF(ISERROR(INDEX('2022-23 Data'!$B$3:$BJ$20,MATCH($C$4,dfenums,0),MATCH($C24,'2022-23 Data'!$B$2:$BJ$2,0))),\"\",INDEX('2022-23 Data'!$B$3:$BJ$20,MATCH($C$4,dfenums,0),MATCH($C24,'2022-23 Data'!$B$2:$BJ$2,0)))","v":""},"","",null,{"$f":"IF(ISERROR(INDEX('2022-23 Data'!$B$3:$BJ$20,MATCH($H$6,dfenums,0),MATCH($C24,'2022-23 Data'!$B$2:$BJ$2,0))),\"\",INDEX('2022-23 Data'!$B$3:$BJ$20,MATCH($H$6,dfenums,0),MATCH($C24,'2022-23 Data'!$B$2:$BJ$2,0)))","v":""},"","",null,{"$f":"IF(ISERROR(INDEX('2022-23 Data'!$B$3:$BJ$20,MATCH($L$6,dfenums,0),MATCH($C24,'2022-23 Data'!$B$2:$BJ$2,0))),\"\",INDEX('2022-23 Data'!$B$3:$BJ$20,MATCH($L$6,dfenums,0),MATCH($C24,'2022-23 Data'!$B$2:$BJ$2,0)))","v":""},"","",null,{"$f":"IF(ISERROR(INDEX('2022-23 Data'!$B$3:$BJ$20,MATCH($P$6,dfenums,0),MATCH($C24,'2022-23 Data'!$B$2:$BJ$2,0))),\"\",INDEX('2022-23 Data'!$B$3:$BJ$20,MATCH($P$6,dfenums,0),MATCH($C24,'2022-23 Data'!$B$2:$BJ$2,0)))","v":""},"","",null,{"$f":"IF(ISERROR(SUM('2022-23 Data'!Q$3:Q$20)/SUM('2022-23 Data'!$C$3:$D$20)),\"\",SUM('2022-23 Data'!Q$3:Q$20)/SUM('2022-23 Data'!$C$3:$D$20))","v":145.07354739363731},2.0680349165001763E-2,1.3635829738996534E-2]
[null,"Grounds maintenance and improvement","E13",{"$f":"IF(ISERROR(INDEX('2022-23 Data'!$B$3:$BJ$20,MATCH($C$4,dfenums,0),MATCH($C25,'2022-23 Data'!$B$2:$BJ$2,0))),\"\",INDEX('2022-23 Data'!$B$3:$BJ$20,MATCH($C$4,dfenums,0),MATCH($C25,'2022-23 Data'!$B$2:$BJ$2,0)))","v":""},"","",null,{"$f":"IF(ISERROR(INDEX('2022-23 Data'!$B$3:$BJ$20,MATCH($H$6,dfenums,0),MATCH($C25,'2022-23 Data'!$B$2:$BJ$2,0))),\"\",INDEX('2022-23 Data'!$B$3:$BJ$20,MATCH($H$6,dfenums,0),MATCH($C25,'2022-23 Data'!$B$2:$BJ$2,0)))","v":""},"","",null,{"$f":"IF(ISERROR(INDEX('2022-23 Data'!$B$3:$BJ$20,MATCH($L$6,dfenums,0),MATCH($C25,'2022-23 Data'!$B$2:$BJ$2,0))),\"\",INDEX('2022-23 Data'!$B$3:$BJ$20,MATCH($L$6,dfenums,0),MATCH($C25,'2022-23 Data'!$B$2:$BJ$2,0)))","v":""},"","",null,{"$f":"IF(ISERROR(INDEX('2022-23 Data'!$B$3:$BJ$20,MATCH($P$6,dfenums,0),MATCH($C25,'2022-23 Data'!$B$2:$BJ$2,0))),\"\",INDEX('2022-23 Data'!$B$3:$BJ$20,MATCH($P$6,dfenums,0),MATCH($C25,'2022-23 Data'!$B$2:$BJ$2,0)))","v":""},"","",null,{"$f":"IF(ISERROR(SUM('2022-23 Data'!R$3:R$20)/SUM('2022-23 Data'!$C$3:$D$20)),\"\",SUM('2022-23 Data'!R$3:R$20)/SUM('2022-23 Data'!$C$3:$D$20))","v":29.53340790276582},4.2100107044629048E-3,2.7759197249223101E-3]
[null,"Cleaning and caretaking","E14",{"$f":"IF(ISERROR(INDEX('2022-23 Data'!$B$3:$BJ$20,MATCH($C$4,dfenums,0),MATCH($C26,'2022-23 Data'!$B$2:$BJ$2,0))),\"\",INDEX('2022-23 Data'!$B$3:$BJ$20,MATCH($C$4,dfenums,0),MATCH($C26,'2022-23 Data'!$B$2:$BJ$2,0)))","v":""},"","",null,{"$f":"IF(ISERROR(INDEX('2022-23 Data'!$B$3:$BJ$20,MATCH($H$6,dfenums,0),MATCH($C26,'2022-23 Data'!$B$2:$BJ$2,0))),\"\",INDEX('2022-23 Data'!$B$3:$BJ$20,MATCH($H$6,dfenums,0),MATCH($C26,'2022-23 Data'!$B$2:$BJ$2,0)))","v":""},"","",null,{"$f":"IF(ISERROR(INDEX('2022-23 Data'!$B$3:$BJ$20,MATCH($L$6,dfenums,0),MATCH($C26,'2022-23 Data'!$B$2:$BJ$2,0))),\"\",INDEX('2022-23 Data'!$B$3:$BJ$20,MATCH($L$6,dfenums,0),MATCH($C26,'2022-23 Data'!$B$2:$BJ$2,0)))","v":""},"","",null,{"$f":"IF(ISERROR(INDEX('2022-23 Data'!$B$3:$BJ$20,MATCH($P$6,dfenums,0),MATCH($C26,'2022-23 Data'!$B$2:$BJ$2,0))),\"\",INDEX('2022-23 Data'!$B$3:$BJ$20,MATCH($P$6,dfenums,0),MATCH($C26,'2022-23 Data'!$B$2:$BJ$2,0)))","v":""},"","",null,{"$f":"IF(ISERROR(SUM('2022-23 Data'!S$3:S$20)/SUM('2022-23 Data'!$C$3:$D$20)),\"\",SUM('2022-23 Data'!S$3:S$20)/SUM('2022-23 Data'!$C$3:$D$20))","v":95.066269929184543},1.355177212710847E-2,8.9355192174248883E-3]
[null,"Water and sewerage","E15",{"$f":"IF(ISERROR(INDEX('2022-23 Data'!$B$3:$BJ$20,MATCH($C$4,dfenums,0),MATCH($C27,'2022-23 Data'!$B$2:$BJ$2,0))),\"\",INDEX('2022-23 Data'!$B$3:$BJ$20,MATCH($C$4,dfenums,0),MATCH($C27,'2022-23 Data'!$B$2:$BJ$2,0)))","v":""},"","",null,{"$f":"IF(ISERROR(INDEX('2022-23 Data'!$B$3:$BJ$20,MATCH($H$6,dfenums,0),MATCH($C27,'2022-23 Data'!$B$2:$BJ$2,0))),\"\",INDEX('2022-23 Data'!$B$3:$BJ$20,MATCH($H$6,dfenums,0),MATCH($C27,'2022-23 Data'!$B$2:$BJ$2,0)))","v":""},"","",null,{"$f":"IF(ISERROR(INDEX('2022-23 Data'!$B$3:$BJ$20,MATCH($L$6,dfenums,0),MATCH($C27,'2022-23 Data'!$B$2:$BJ$2,0))),\"\",INDEX('2022-23 Data'!$B$3:$BJ$20,MATCH($L$6,dfenums,0),MATCH($C27,'2022-23 Data'!$B$2:$BJ$2,0)))","v":""},"","",null,{"$f":"IF(ISERROR(INDEX('2022-23 Data'!$B$3:$BJ$20,MATCH($P$6,dfenums,0),MATCH($C27,'2022-23 Data'!$B$2:$BJ$2,0))),\"\",INDEX('2022-23 Data'!$B$3:$BJ$20,MATCH($P$6,dfenums,0),MATCH($C27,'2022-23 Data'!$B$2:$BJ$2,0)))","v":""},"","",null,{"$f":"IF(ISERROR(SUM('2022-23 Data'!T$3:T$20)/SUM('2022-23 Data'!$C$3:$D$20)),\"\",SUM('2022-23 Data'!T$3:T$20)/SUM('2022-23 Data'!$C$3:$D$20))","v":17.771783305232443},2.5333817959226051E-3,1.6704148734362511E-3]
[null,"Energy","E16",{"$f":"IF(ISERROR(INDEX('2022-23 Data'!$B$3:$BJ$20,MATCH($C$4,dfenums,0),MATCH($C28,'2022-23 Data'!$B$2:$BJ$2,0))),\"\",INDEX('2022-23 Data'!$B$3:$BJ$20,MATCH($C$4,dfenums,0),MATCH($C28,'2022-23 Data'!$B$2:$BJ$2,0)))","v":""},"","",null,{"$f":"IF(ISERROR(INDEX('2022-23 Data'!$B$3:$BJ$20,MATCH($H$6,dfenums,0),MATCH($C28,'2022-23 Data'!$B$2:$BJ$2,0))),\"\",INDEX('2022-23 Data'!$B$3:$BJ$20,MATCH($H$6,dfenums,0),MATCH($C28,'2022-23 Data'!$B$2:$BJ$2,0)))","v":""},"","",null,{"$f":"IF(ISERROR(INDEX('2022-23 Data'!$B$3:$BJ$20,MATCH($L$6,dfenums,0),MATCH($C28,'2022-23 Data'!$B$2:$BJ$2,0))),\"\",INDEX('2022-23 Data'!$B$3:$BJ$20,MATCH($L$6,dfenums,0),MATCH($C28,'2022-23 Data'!$B$2:$BJ$2,0)))","v":""},"","",null,{"$f":"IF(ISERROR(INDEX('2022-23 Data'!$B$3:$BJ$20,MATCH($P$6,dfenums,0),MATCH($C28,'2022-23 Data'!$B$2:$BJ$2,0))),\"\",INDEX('2022-23 Data'!$B$3:$BJ$20,MATCH($P$6,dfenums,0),MATCH($C28,'2022-23 Data'!$B$2:$BJ$2,0)))","v":""},"","",null,{"$f":"IF(ISERROR(SUM('2022-23 Data'!U$3:U$20)/SUM('2022-23 Data'!$C$3:$D$20)),\"\",SUM('2022-23 Data'!U$3:U$20)/SUM('2022-23 Data'!$C$3:$D$20))","v":143.06095574685779},2.039345263059061E-2,1.3446661158489238E-2]
[null,"Rates","E17",{"$f":"IF(ISERROR(INDEX('2022-23 Data'!$B$3:$BJ$20,MATCH($C$4,dfenums,0),MATCH($C29,'2022-23 Data'!$B$2:$BJ$2,0))),\"\",INDEX('2022-23 Data'!$B$3:$BJ$20,MATCH($C$4,dfenums,0),MATCH($C29,'2022-23 Data'!$B$2:$BJ$2,0)))","v":""},"","",null,{"$f":"IF(ISERROR(INDEX('2022-23 Data'!$B$3:$BJ$20,MATCH($H$6,dfenums,0),MATCH($C29,'2022-23 Data'!$B$2:$BJ$2,0))),\"\",INDEX('2022-23 Data'!$B$3:$BJ$20,MATCH($H$6,dfenums,0),MATCH($C29,'2022-23 Data'!$B$2:$BJ$2,0)))","v":""},"","",null,{"$f":"IF(ISERROR(INDEX('2022-23 Data'!$B$3:$BJ$20,MATCH($L$6,dfenums,0),MATCH($C29,'2022-23 Data'!$B$2:$BJ$2,0))),\"\",INDEX('2022-23 Data'!$B$3:$BJ$20,MATCH($L$6,dfenums,0),MATCH($C29,'2022-23 Data'!$B$2:$BJ$2,0)))","v":""},"","",null,{"$f":"IF(ISERROR(INDEX('2022-23 Data'!$B$3:$BJ$20,MATCH($P$6,dfenums,0),MATCH($C29,'2022-23 Data'!$B$2:$BJ$2,0))),\"\",INDEX('2022-23 Data'!$B$3:$BJ$20,MATCH($P$6,dfenums,0),MATCH($C29,'2022-23 Data'!$B$2:$BJ$2,0)))","v":""},"","",null,{"$f":"IF(ISERROR(SUM('2022-23 Data'!V$3:V$20)/SUM('2022-23 Data'!$C$3:$D$20)),\"\",SUM('2022-23 Data'!V$3:V$20)/SUM('2022-23 Data'!$C$3:$D$20))","v":58.859292364990694},8.3904387779954129E-3,5.5323337966576274E-3]
[null,"Other occupation costs","E18",{"$f":"IF(ISERROR(INDEX('2022-23 Data'!$B$3:$BJ$20,MATCH($C$4,dfenums,0),MATCH($C30,'2022-23 Data'!$B$2:$BJ$2,0))),\"\",INDEX('2022-23 Data'!$B$3:$BJ$20,MATCH($C$4,dfenums,0),MATCH($C30,'2022-23 Data'!$B$2:$BJ$2,0)))","v":""},"","",null,{"$f":"IF(ISERROR(INDEX('2022-23 Data'!$B$3:$BJ$20,MATCH($H$6,dfenums,0),MATCH($C30,'2022-23 Data'!$B$2:$BJ$2,0))),\"\",INDEX('2022-23 Data'!$B$3:$BJ$20,MATCH($H$6,dfenums,0),MATCH($C30,'2022-23 Data'!$B$2:$BJ$2,0)))","v":""},"","",null,{"$f":"IF(ISERROR(INDEX('2022-23 Data'!$B$3:$BJ$20,MATCH($L$6,dfenums,0),MATCH($C30,'2022-23 Data'!$B$2:$BJ$2,0))),\"\",INDEX('2022-23 Data'!$B$3:$BJ$20,MATCH($L$6,dfenums,0),MATCH($C30,'2022-23 Data'!$B$2:$BJ$2,0)))","v":""},"","",null,{"$f":"IF(ISERROR(INDEX('2022-23 Data'!$B$3:$BJ$20,MATCH($P$6,dfenums,0),MATCH($C30,'2022-23 Data'!$B$2:$BJ$2,0))),\"\",INDEX('2022-23 Data'!$B$3:$BJ$20,MATCH($P$6,dfenums,0),MATCH($C30,'2022-23 Data'!$B$2:$BJ$2,0)))","v":""},"","",null,{"$f":"IF(ISERROR(SUM('2022-23 Data'!W$3:W$20)/SUM('2022-23 Data'!$C$3:$D$20)),\"\",SUM('2022-23 Data'!W$3:W$20)/SUM('2022-23 Data'!$C$3:$D$20))","v":26.178689415672658},3.73179292520692E-3,2.4606012472666609E-3]
[null,"Learning resources (not ICT equipment)","E19",{"$f":"IF(ISERROR(INDEX('2022-23 Data'!$B$3:$BJ$20,MATCH($C$4,dfenums,0),MATCH($C31,'2022-23 Data'!$B$2:$BJ$2,0))),\"\",INDEX('2022-23 Data'!$B$3:$BJ$20,MATCH($C$4,dfenums,0),MATCH($C31,'2022-23 Data'!$B$2:$BJ$2,0)))","v":""},"","",null,{"$f":"IF(ISERROR(INDEX('2022-23 Data'!$B$3:$BJ$20,MATCH($H$6,dfenums,0),MATCH($C31,'2022-23 Data'!$B$2:$BJ$2,0))),\"\",INDEX('2022-23 Data'!$B$3:$BJ$20,MATCH($H$6,dfenums,0),MATCH($C31,'2022-23 Data'!$B$2:$BJ$2,0)))","v":""},"","",null,{"$f":"IF(ISERROR(INDEX('2022-23 Data'!$B$3:$BJ$20,MATCH($L$6,dfenums,0),MATCH($C31,'2022-23 Data'!$B$2:$BJ$2,0))),\"\",INDEX('2022-23 Data'!$B$3:$BJ$20,MATCH($L$6,dfenums,0),MATCH($C31,'2022-23 Data'!$B$2:$BJ$2,0)))","v":""},"","",null,{"$f":"IF(ISERROR(INDEX('2022-23 Data'!$B$3:$BJ$20,MATCH($P$6,dfenums,0),MATCH($C31,'2022-23 Data'!$B$2:$BJ$2,0))),\"\",INDEX('2022-23 Data'!$B$3:$BJ$20,MATCH($P$6,dfenums,0),MATCH($C31,'2022-23 Data'!$B$2:$BJ$2,0)))","v":""},"","",null,{"$f":"IF(ISERROR(SUM('2022-23 Data'!X$3:X$20)/SUM('2022-23 Data'!$C$3:$D$20)),\"\",SUM('2022-23 Data'!X$3:X$20)/SUM('2022-23 Data'!$C$3:$D$20))","v":335.38255372691123},4.7809048855082192E-2,3.1523454704262599E-2]
[null,"ICT learning resources","E20",{"$f":"IF(ISERROR(INDEX('2022-23 Data'!$B$3:$BJ$20,MATCH($C$4,dfenums,0),MATCH($C32,'2022-23 Data'!$B$2:$BJ$2,0))),\"\",INDEX('2022-23 Data'!$B$3:$BJ$20,MATCH($C$4,dfenums,0),MATCH($C32,'2022-23 Data'!$B$2:$BJ$2,0)))","v":""},"","",null,{"$f":"IF(ISERROR(INDEX('2022-23 Data'!$B$3:$BJ$20,MATCH($H$6,dfenums,0),MATCH($C32,'2022-23 Data'!$B$2:$BJ$2,0))),\"\",INDEX('2022-23 Data'!$B$3:$BJ$20,MATCH($H$6,dfenums,0),MATCH($C32,'2022-23 Data'!$B$2:$BJ$2,0)))","v":""},"","",null,{"$f":"IF(ISERROR(INDEX('2022-23 Data'!$B$3:$BJ$20,MATCH($L$6,dfenums,0),MATCH($C32,'2022-23 Data'!$B$2:$BJ$2,0))),\"\",INDEX('2022-23 Data'!$B$3:$BJ$20,MATCH($L$6,dfenums,0),MATCH($C32,'2022-23 Data'!$B$2:$BJ$2,0)))","v":""},"","",null,{"$f":"IF(ISERROR(INDEX('2022-23 Data'!$B$3:$BJ$20,MATCH($P$6,dfenums,0),MATCH($C32,'2022-23 Data'!$B$2:$BJ$2,0))),\"\",INDEX('2022-23 Data'!$B$3:$BJ$20,MATCH($P$6,dfenums,0),MATCH($C32,'2022-23 Data'!$B$2:$BJ$2,0)))","v":""},"","",null,{"$f":"IF(ISERROR(SUM('2022-23 Data'!Y$3:Y$20)/SUM('2022-23 Data'!$C$3:$D$20)),\"\",SUM('2022-23 Data'!Y$3:Y$20)/SUM('2022-23 Data'!$C$3:$D$20))","v":113.74729830389045},1.6214767528344293E-2,1.0691396335226895E-2]
[null,"Exam fees","E21",{"$f":"IF(ISERROR(INDEX('2022-23 Data'!$B$3:$BJ$20,MATCH($C$4,dfenums,0),MATCH($C33,'2022-23 Data'!$B$2:$BJ$2,0))),\"\",INDEX('2022-23 Data'!$B$3:$BJ$20,MATCH($C$4,dfenums,0),MATCH($C33,'2022-23 Data'!$B$2:$BJ$2,0)))","v":""},"","",null,{"$f":"IF(ISERROR(INDEX('2022-23 Data'!$B$3:$BJ$20,MATCH($H$6,dfenums,0),MATCH($C33,'2022-23 Data'!$B$2:$BJ$2,0))),\"\",INDEX('2022-23 Data'!$B$3:$BJ$20,MATCH($H$6,dfenums,0),MATCH($C33,'2022-23 Data'!$B$2:$BJ$2,0)))","v":""},"","",null,{"$f":"IF(ISERROR(INDEX('2022-23 Data'!$B$3:$BJ$20,MATCH($L$6,dfenums,0),MATCH($C33,'2022-23 Data'!$B$2:$BJ$2,0))),\"\",INDEX('2022-23 Data'!$B$3:$BJ$20,MATCH($L$6,dfenums,0),MATCH($C33,'2022-23 Data'!$B$2:$BJ$2,0)))","v":""},"","",null,{"$f":"IF(ISERROR(INDEX('2022-23 Data'!$B$3:$BJ$20,MATCH($P$6,dfenums,0),MATCH($C33,'2022-23 Data'!$B$2:$BJ$2,0))),\"\",INDEX('2022-23 Data'!$B$3:$BJ$20,MATCH($P$6,dfenums,0),MATCH($C33,'2022-23 Data'!$B$2:$BJ$2,0)))","v":""},"","",null,{"$f":"IF(ISERROR(SUM('2022-23 Data'!Z$3:Z$20)/SUM('2022-23 Data'!$C$3:$D$20)),\"\",SUM('2022-23 Data'!Z$3:Z$20)/SUM('2022-23 Data'!$C$3:$D$20))","v":123.42849162011174},1.759482930880172E-2,1.1601356187329433E-2]
[null,"Administrative supplies","E22",{"$f":"IF(ISERROR(INDEX('2022-23 Data'!$B$3:$BJ$20,MATCH($C$4,dfenums,0),MATCH($C34,'2022-23 Data'!$B$2:$BJ$2,0))),\"\",INDEX('2022-23 Data'!$B$3:$BJ$20,MATCH($C$4,dfenums,0),MATCH($C34,'2022-23 Data'!$B$2:$BJ$2,0)))","v":""},"","",null,{"$f":"IF(ISERROR(INDEX('2022-23 Data'!$B$3:$BJ$20,MATCH($H$6,dfenums,0),MATCH($C34,'2022-23 Data'!$B$2:$BJ$2,0))),\"\",INDEX('2022-23 Data'!$B$3:$BJ$20,MATCH($H$6,dfenums,0),MATCH($C34,'2022-23 Data'!$B$2:$BJ$2,0)))","v":""},"","",null,{"$f":"IF(ISERROR(INDEX('2022-23 Data'!$B$3:$BJ$20,MATCH($L$6,dfenums,0),MATCH($C34,'2022-23 Data'!$B$2:$BJ$2,0))),\"\",INDEX('2022-23 Data'!$B$3:$BJ$20,MATCH($L$6,dfenums,0),MATCH($C34,'2022-23 Data'!$B$2:$BJ$2,0)))","v":""},"","",null,{"$f":"IF(ISERROR(INDEX('2022-23 Data'!$B$3:$BJ$20,MATCH($P$6,dfenums,0),MATCH($C34,'2022-23 Data'!$B$2:$BJ$2,0))),\"\",INDEX('2022-23 Data'!$B$3:$BJ$20,MATCH($P$6,dfenums,0),MATCH($C34,'2022-23 Data'!$B$2:$BJ$2,0)))","v":""},"","",null,{"$f":"IF(ISERROR(SUM('2022-23 Data'!AA$3:AA$20)/SUM('2022-23 Data'!$C$3:$D$20)),\"\",SUM('2022-23 Data'!AA$3:AA$20)/SUM('2022-23 Data'!$C$3:$D$20))","v":61.103090744375677},8.7102940153919294E-3,5.7432340828890774E-3]
[null,"Other insurance premiums","E23",{"$f":"IF(ISERROR(INDEX('2022-23 Data'!$B$3:$BJ$20,MATCH($C$4,dfenums,0),MATCH($C35,'2022-23 Data'!$B$2:$BJ$2,0))),\"\",INDEX('2022-23 Data'!$B$3:$BJ$20,MATCH($C$4,dfenums,0),MATCH($C35,'2022-23 Data'!$B$2:$BJ$2,0)))","v":""},"","",null,{"$f":"IF(ISERROR(INDEX('2022-23 Data'!$B$3:$BJ$20,MATCH($H$6,dfenums,0),MATCH($C35,'2022-23 Data'!$B$2:$BJ$2,0))),\"\",INDEX('2022-23 Data'!$B$3:$BJ$20,MATCH($H$6,dfenums,0),MATCH($C35,'2022-23 Data'!$B$2:$BJ$2,0)))","v":""},"","",null,{"$f":"IF(ISERROR(INDEX('2022-23 Data'!$B$3:$BJ$20,MATCH($L$6,dfenums,0),MATCH($C35,'2022-23 Data'!$B$2:$BJ$2,0))),\"\",INDEX('2022-23 Data'!$B$3:$BJ$20,MATCH($L$6,dfenums,0),MATCH($C35,'2022-23 Data'!$B$2:$BJ$2,0)))","v":""},"","",null,{"$f":"IF(ISERROR(INDEX('2022-23 Data'!$B$3:$BJ$20,MATCH($P$6,dfenums,0),MATCH($C35,'2022-23 Data'!$B$2:$BJ$2,0))),\"\",INDEX('2022-23 Data'!$B$3:$BJ$20,MATCH($P$6,dfenums,0),MATCH($C35,'2022-23 Data'!$B$2:$BJ$2,0)))","v":""},"","",null,{"$f":"IF(ISERROR(SUM('2022-23 Data'!AB$3:AB$20)/SUM('2022-23 Data'!$C$3:$D$20)),\"\",SUM('2022-23 Data'!AB$3:AB$20)/SUM('2022-23 Data'!$C$3:$D$20))","v":36.698314349244555},5.2313737972513206E-3,3.4493674082200004E-3]
[null,"Special facilities","E24",{"$f":"IF(ISERROR(INDEX('2022-23 Data'!$B$3:$BJ$20,MATCH($C$4,dfenums,0),MATCH($C36,'2022-23 Data'!$B$2:$BJ$2,0))),\"\",INDEX('2022-23 Data'!$B$3:$BJ$20,MATCH($C$4,dfenums,0),MATCH($C36,'2022-23 Data'!$B$2:$BJ$2,0)))","v":""},"","",null,{"$f":"IF(ISERROR(INDEX('2022-23 Data'!$B$3:$BJ$20,MATCH($H$6,dfenums,0),MATCH($C36,'2022-23 Data'!$B$2:$BJ$2,0))),\"\",INDEX('2022-23 Data'!$B$3:$BJ$20,MATCH($H$6,dfenums,0),MATCH($C36,'2022-23 Data'!$B$2:$BJ$2,0)))","v":""},"","",null,{"$f":"IF(ISERROR(INDEX('2022-23 Data'!$B$3:$BJ$20,MATCH($L$6,dfenums,0),MATCH($C36,'2022-23 Data'!$B$2:$BJ$2,0))),\"\",INDEX('2022-23 Data'!$B$3:$BJ$20,MATCH($L$6,dfenums,0),MATCH($C36,'2022-23 Data'!$B$2:$BJ$2,0)))","v":""},"","",null,{"$f":"IF(ISERROR(INDEX('2022-23 Data'!$B$3:$BJ$20,MATCH($P$6,dfenums,0),MATCH($C36,'2022-23 Data'!$B$2:$BJ$2,0))),\"\",INDEX('2022-23 Data'!$B$3:$BJ$20,MATCH($P$6,dfenums,0),MATCH($C36,'2022-23 Data'!$B$2:$BJ$2,0)))","v":""},"","",null,{"$f":"IF(ISERROR(SUM('2022-23 Data'!AC$3:AC$20)/SUM('2022-23 Data'!$C$3:$D$20)),\"\",SUM('2022-23 Data'!AC$3:AC$20)/SUM('2022-23 Data'!$C$3:$D$20))","v":241.34812897283962},3.4404367075517625E-2,2.2684921225296754E-2]
[null,"Catering supplies","E25",{"$f":"IF(ISERROR(INDEX('2022-23 Data'!$B$3:$BJ$20,MATCH($C$4,dfenums,0),MATCH($C37,'2022-23 Data'!$B$2:$BJ$2,0))),\"\",INDEX('2022-23 Data'!$B$3:$BJ$20,MATCH($C$4,dfenums,0),MATCH($C37,'2022-23 Data'!$B$2:$BJ$2,0)))","v":""},"","",null,{"$f":"IF(ISERROR(INDEX('2022-23 Data'!$B$3:$BJ$20,MATCH($H$6,dfenums,0),MATCH($C37,'2022-23 Data'!$B$2:$BJ$2,0))),\"\",INDEX('2022-23 Data'!$B$3:$BJ$20,MATCH($H$6,dfenums,0),MATCH($C37,'2022-23 Data'!$B$2:$BJ$2,0)))","v":""},"","",null,{"$f":"IF(ISERROR(INDEX('2022-23 Data'!$B$3:$BJ$20,MATCH($L$6,dfenums,0),MATCH($C37,'2022-23 Data'!$B$2:$BJ$2,0))),\"\",INDEX('2022-23 Data'!$B$3:$BJ$20,MATCH($L$6,dfenums,0),MATCH($C37,'2022-23 Data'!$B$2:$BJ$2,0)))","v":""},"","",null,{"$f":"IF(ISERROR(INDEX('2022-23 Data'!$B$3:$BJ$20,MATCH($P$6,dfenums,0),MATCH($C37,'2022-23 Data'!$B$2:$BJ$2,0))),\"\",INDEX('2022-23 Data'!$B$3:$BJ$20,MATCH($P$6,dfenums,0),MATCH($C37,'2022-23 Data'!$B$2:$BJ$2,0)))","v":""},"","",null,{"$f":"IF(ISERROR(SUM('2022-23 Data'!AD$3:AD$20)/SUM('2022-23 Data'!$C$3:$D$20)),\"\",SUM('2022-23 Data'!AD$3:AD$20)/SUM('2022-23 Data'!$C$3:$D$20))","v":93.786238621820203},1.3369302649701943E-2,8.8152058365130286E-3]
[null,"Agency supply teaching staff","E26",{"$f":"IF(ISERROR(INDEX('2022-23 Data'!$B$3:$BJ$20,MATCH($C$4,dfenums,0),MATCH($C38,'2022-23 Data'!$B$2:$BJ$2,0))),\"\",INDEX('2022-23 Data'!$B$3:$BJ$20,MATCH($C$4,dfenums,0),MATCH($C38,'2022-23 Data'!$B$2:$BJ$2,0)))","v":""},"","",null,{"$f":"IF(ISERROR(INDEX('2022-23 Data'!$B$3:$BJ$20,MATCH($H$6,dfenums,0),MATCH($C38,'2022-23 Data'!$B$2:$BJ$2,0))),\"\",INDEX('2022-23 Data'!$B$3:$BJ$20,MATCH($H$6,dfenums,0),MATCH($C38,'2022-23 Data'!$B$2:$BJ$2,0)))","v":""},"","",null,{"$f":"IF(ISERROR(INDEX('2022-23 Data'!$B$3:$BJ$20,MATCH($L$6,dfenums,0),MATCH($C38,'2022-23 Data'!$B$2:$BJ$2,0))),\"\",INDEX('2022-23 Data'!$B$3:$BJ$20,MATCH($L$6,dfenums,0),MATCH($C38,'2022-23 Data'!$B$2:$BJ$2,0)))","v":""},"","",null,{"$f":"IF(ISERROR(INDEX('2022-23 Data'!$B$3:$BJ$20,MATCH($P$6,dfenums,0),MATCH($C38,'2022-23 Data'!$B$2:$BJ$2,0))),\"\",INDEX('2022-23 Data'!$B$3:$BJ$20,MATCH($P$6,dfenums,0),MATCH($C38,'2022-23 Data'!$B$2:$BJ$2,0)))","v":""},"","",null,{"$f":"IF(ISERROR(SUM('2022-23 Data'!AE$3:AE$20)/SUM('2022-23 Data'!$C$3:$D$20)),\"\",SUM('2022-23 Data'!AE$3:AE$20)/SUM('2022-23 Data'!$C$3:$D$20))","v":74.991259751371473},1.0690063514981802E-2,7.0486182233344425E-3]
[null,"Bought in professional services - curriculum","E27",{"$f":"IF(ISERROR(INDEX('2022-23 Data'!$B$3:$BJ$20,MATCH($C$4,dfenums,0),MATCH($C39,'2022-23 Data'!$B$2:$BJ$2,0))),\"\",INDEX('2022-23 Data'!$B$3:$BJ$20,MATCH($C$4,dfenums,0),MATCH($C39,'2022-23 Data'!$B$2:$BJ$2,0)))","v":""},"","",null,{"$f":"IF(ISERROR(INDEX('2022-23 Data'!$B$3:$BJ$20,MATCH($H$6,dfenums,0),MATCH($C39,'2022-23 Data'!$B$2:$BJ$2,0))),\"\",INDEX('2022-23 Data'!$B$3:$BJ$20,MATCH($H$6,dfenums,0),MATCH($C39,'2022-23 Data'!$B$2:$BJ$2,0)))","v":""},"","",null,{"$f":"IF(ISERROR(INDEX('2022-23 Data'!$B$3:$BJ$20,MATCH($L$6,dfenums,0),MATCH($C39,'2022-23 Data'!$B$2:$BJ$2,0))),\"\",INDEX('2022-23 Data'!$B$3:$BJ$20,MATCH($L$6,dfenums,0),MATCH($C39,'2022-23 Data'!$B$2:$BJ$2,0)))","v":""},"","",null,{"$f":"IF(ISERROR(INDEX('2022-23 Data'!$B$3:$BJ$20,MATCH($P$6,dfenums,0),MATCH($C39,'2022-23 Data'!$B$2:$BJ$2,0))),\"\",INDEX('2022-23 Data'!$B$3:$BJ$20,MATCH($P$6,dfenums,0),MATCH($C39,'2022-23 Data'!$B$2:$BJ$2,0)))","v":""},"","",null,{"$f":"IF(ISERROR(SUM('2022-23 Data'!AF$3:AF$20)/SUM('2022-23 Data'!$C$3:$D$20)),\"\",SUM('2022-23 Data'!AF$3:AF$20)/SUM('2022-23 Data'!$C$3:$D$20))","v":90.777690371936174},1.2940431712131654E-2,8.5324247752237414E-3]
[null,"Bought in professional services other","E28",{"$f":"IF(ISERROR(INDEX('2022-23 Data'!$B$3:$BJ$20,MATCH($C$4,dfenums,0),MATCH($C40,'2022-23 Data'!$B$2:$BJ$2,0))),\"\",INDEX('2022-23 Data'!$B$3:$BJ$20,MATCH($C$4,dfenums,0),MATCH($C40,'2022-23 Data'!$B$2:$BJ$2,0)))","v":""},{"$f":"IF($C$4>0,D40/($E$4+$F$4),\"\")","v":""},{"$f":"IF($C$4>0,D40/$D$46,\"\")","v":""},null,{"$f":"IF(ISERROR(INDEX('2022-23 Data'!$B$3:$BJ$20,MATCH($H$6,dfenums,0),MATCH($C40,'2022-23 Data'!$B$2:$BJ$2,0))),\"\",INDEX('2022-23 Data'!$B$3:$BJ$20,MATCH($H$6,dfenums,0),MATCH($C40,'2022-23 Data'!$B$2:$BJ$2,0)))","v":""},{"$f":"IF($H$6>0,H40/($I$6+$J$6),\"\")","v":""},{"$f":"IF($H$6>0,H40/$H$46,\"\")","v":""},null,{"$f":"IF(ISERROR(INDEX('2022-23 Data'!$B$3:$BJ$20,MATCH($L$6,dfenums,0),MATCH($C40,'2022-23 Data'!$B$2:$BJ$2,0))),\"\",INDEX('2022-23 Data'!$B$3:$BJ$20,MATCH($L$6,dfenums,0),MATCH($C40,'2022-23 Data'!$B$2:$BJ$2,0)))","v":""},{"$f":"IF($L$6>0,L40/($M$6+$N$6),\"\")","v":""},{"$f":"IF($L$6>0,L40/$L$46,\"\")","v":""},null,{"$f":"IF(ISERROR(INDEX('2022-23 Data'!$B$3:$BJ$20,MATCH($P$6,dfenums,0),MATCH($C40,'2022-23 Data'!$B$2:$BJ$2,0))),\"\",INDEX('2022-23 Data'!$B$3:$BJ$20,MATCH($P$6,dfenums,0),MATCH($C40,'2022-23 Data'!$B$2:$BJ$2,0)))","v":""},{"$f":"IF($P$6>0,P40/($Q$6+$R$6),\"\")","v":""},{"$f":"IF($P$6>0,P40/$P$46,\"\")","v":""},null,{"$f":"IF(ISERROR(SUM('2022-23 Data'!AG$3:AG$20)/SUM('2022-23 Data'!$C$3:$D$20)),\"\",SUM('2022-23 Data'!AG$3:AG$20)/SUM('2022-23 Data'!$C$3:$D$20))","v":114.13788304511458},{"$f":"IF(ISERROR(T40/$T$46),\"\",T40/$T$46)","v":1.627044569277988E-2},{"$f":"IF(ISERROR(T40/-$T$72),\"\",T40/-$T$72)","v":1.0728108383189237E-2}]
[null,"Bought in professional services other","E28b",{"$f":"IF(ISERROR(INDEX('2022-23 Data'!$B$3:$BJ$20,MATCH($C$4,dfenums,0),MATCH($C41,'2022-23 Data'!$B$2:$BJ$2,0))),\"\",INDEX('2022-23 Data'!$B$3:$BJ$20,MATCH($C$4,dfenums,0),MATCH($C41,'2022-23 Data'!$B$2:$BJ$2,0)))","v":""},"","",null,{"$f":"IF(ISERROR(INDEX('2022-23 Data'!$B$3:$BJ$20,MATCH($H$6,dfenums,0),MATCH($C41,'2022-23 Data'!$B$2:$BJ$2,0))),\"\",INDEX('2022-23 Data'!$B$3:$BJ$20,MATCH($H$6,dfenums,0),MATCH($C41,'2022-23 Data'!$B$2:$BJ$2,0)))","v":""},"","",null,{"$f":"IF(ISERROR(INDEX('2022-23 Data'!$B$3:$BJ$20,MATCH($L$6,dfenums,0),MATCH($C41,'2022-23 Data'!$B$2:$BJ$2,0))),\"\",INDEX('2022-23 Data'!$B$3:$BJ$20,MATCH($L$6,dfenums,0),MATCH($C41,'2022-23 Data'!$B$2:$BJ$2,0)))","v":""},"","",null,{"$f":"IF(ISERROR(INDEX('2022-23 Data'!$B$3:$BJ$20,MATCH($P$6,dfenums,0),MATCH($C41,'2022-23 Data'!$B$2:$BJ$2,0))),\"\",INDEX('2022-23 Data'!$B$3:$BJ$20,MATCH($P$6,dfenums,0),MATCH($C41,'2022-23 Data'!$B$2:$BJ$2,0)))","v":""},"","",null,{"$f":"IF(ISERROR(SUM('2022-23 Data'!AH$3:AH$20)/SUM('2022-23 Data'!$C$3:$D$20)),\"\",SUM('2022-23 Data'!AH$3:AH$20)/SUM('2022-23 Data'!$C$3:$D$20))","v":0},0,0]
[null,"Loan interest","E29",{"$f":"IF(ISERROR(INDEX('2022-23 Data'!$B$3:$BJ$20,MATCH($C$4,dfenums,0),MATCH($C42,'2022-23 Data'!$B$2:$BJ$2,0))),\"\",INDEX('2022-23 Data'!$B$3:$BJ$20,MATCH($C$4,dfenums,0),MATCH($C42,'2022-23 Data'!$B$2:$BJ$2,0)))","v":""},"","",null,{"$f":"IF(ISERROR(INDEX('2022-23 Data'!$B$3:$BJ$20,MATCH($H$6,dfenums,0),MATCH($C42,'2022-23 Data'!$B$2:$BJ$2,0))),\"\",INDEX('2022-23 Data'!$B$3:$BJ$20,MATCH($H$6,dfenums,0),MATCH($C42,'2022-23 Data'!$B$2:$BJ$2,0)))","v":""},"","",null,{"$f":"IF(ISERROR(INDEX('2022-23 Data'!$B$3:$BJ$20,MATCH($L$6,dfenums,0),MATCH($C42,'2022-23 Data'!$B$2:$BJ$2,0))),\"\",INDEX('2022-23 Data'!$B$3:$BJ$20,MATCH($L$6,dfenums,0),MATCH($C42,'2022-23 Data'!$B$2:$BJ$2,0)))","v":""},"","",null,{"$f":"IF(ISERROR(INDEX('2022-23 Data'!$B$3:$BJ$20,MATCH($P$6,dfenums,0),MATCH($C42,'2022-23 Data'!$B$2:$BJ$2,0))),\"\",INDEX('2022-23 Data'!$B$3:$BJ$20,MATCH($P$6,dfenums,0),MATCH($C42,'2022-23 Data'!$B$2:$BJ$2,0)))","v":""},"","",null,{"$f":"IF(ISERROR(SUM('2022-23 Data'!AI$3:AI$20)/SUM('2022-23 Data'!$C$3:$D$20)),\"\",SUM('2022-23 Data'!AI$3:AI$20)/SUM('2022-23 Data'!$C$3:$D$20))","v":4.1756963108359759},5.9524881873044416E-4,3.9248426028915434E-4]
[null,"Direct revenue financing (rev contrib. to cap)","E30",{"$f":"IF(ISERROR(INDEX('2022-23 Data'!$B$3:$BJ$20,MATCH($C$4,dfenums,0),MATCH($C43,'2022-23 Data'!$B$2:$BJ$2,0))),\"\",INDEX('2022-23 Data'!$B$3:$BJ$20,MATCH($C$4,dfenums,0),MATCH($C43,'2022-23 Data'!$B$2:$BJ$2,0)))","v":""},"","",null,{"$f":"IF(ISERROR(INDEX('2022-23 Data'!$B$3:$BJ$20,MATCH($H$6,dfenums,0),MATCH($C43,'2022-23 Data'!$B$2:$BJ$2,0))),\"\",INDEX('2022-23 Data'!$B$3:$BJ$20,MATCH($H$6,dfenums,0),MATCH($C43,'2022-23 Data'!$B$2:$BJ$2,0)))","v":""},"","",null,{"$f":"IF(ISERROR(INDEX('2022-23 Data'!$B$3:$BJ$20,MATCH($L$6,dfenums,0),MATCH($C43,'2022-23 Data'!$B$2:$BJ$2,0))),\"\",INDEX('2022-23 Data'!$B$3:$BJ$20,MATCH($L$6,dfenums,0),MATCH($C43,'2022-23 Data'!$B$2:$BJ$2,0)))","v":""},"","",null,{"$f":"IF(ISERROR(INDEX('2022-23 Data'!$B$3:$BJ$20,MATCH($P$6,dfenums,0),MATCH($C43,'2022-23 Data'!$B$2:$BJ$2,0))),\"\",INDEX('2022-23 Data'!$B$3:$BJ$20,MATCH($P$6,dfenums,0),MATCH($C43,'2022-23 Data'!$B$2:$BJ$2,0)))","v":""},"","",null,{"$f":"IF(ISERROR(SUM('2022-23 Data'!AJ$3:AJ$20)/SUM('2022-23 Data'!$C$3:$D$20)),\"\",SUM('2022-23 Data'!AJ$3:AJ$20)/SUM('2022-23 Data'!$C$3:$D$20))","v":178.97698122703707},2.5513310529521289E-2,1.6822499256804502E-2]
[null,"Community focussed extended school staff","E31",{"$f":"IF(ISERROR(INDEX('2022-23 Data'!$B$3:$BJ$20,MATCH($C$4,dfenums,0),MATCH($C44,'2022-23 Data'!$B$2:$BJ$2,0))),\"\",INDEX('2022-23 Data'!$B$3:$BJ$20,MATCH($C$4,dfenums,0),MATCH($C44,'2022-23 Data'!$B$2:$BJ$2,0)))","v":""},"","",null,{"$f":"IF(ISERROR(INDEX('2022-23 Data'!$B$3:$BJ$20,MATCH($H$6,dfenums,0),MATCH($C44,'2022-23 Data'!$B$2:$BJ$2,0))),\"\",INDEX('2022-23 Data'!$B$3:$BJ$20,MATCH($H$6,dfenums,0),MATCH($C44,'2022-23 Data'!$B$2:$BJ$2,0)))","v":""},"","",null,{"$f":"IF(ISERROR(INDEX('2022-23 Data'!$B$3:$BJ$20,MATCH($L$6,dfenums,0),MATCH($C44,'2022-23 Data'!$B$2:$BJ$2,0))),\"\",INDEX('2022-23 Data'!$B$3:$BJ$20,MATCH($L$6,dfenums,0),MATCH($C44,'2022-23 Data'!$B$2:$BJ$2,0)))","v":""},"","",null,{"$f":"IF(ISERROR(INDEX('2022-23 Data'!$B$3:$BJ$20,MATCH($P$6,dfenums,0),MATCH($C44,'2022-23 Data'!$B$2:$BJ$2,0))),\"\",INDEX('2022-23 Data'!$B$3:$BJ$20,MATCH($P$6,dfenums,0),MATCH($C44,'2022-23 Data'!$B$2:$BJ$2,0)))","v":""},"","",null,{"$f":"IF(ISERROR(SUM('2022-23 Data'!AK$3:AK$20)/SUM('2022-23 Data'!$C$3:$D$20)),\"\",SUM('2022-23 Data'!AK$3:AK$20)/SUM('2022-23 Data'!$C$3:$D$20))","v":0},0,0]
[null,"Community focussed extended school costs","E32",{"$f":"IF(ISERROR(INDEX('2022-23 Data'!$B$3:$BJ$20,MATCH($C$4,dfenums,0),MATCH($C45,'2022-23 Data'!$B$2:$BJ$2,0))),\"\",INDEX('2022-23 Data'!$B$3:$BJ$20,MATCH($C$4,dfenums,0),MATCH($C45,'2022-23 Data'!$B$2:$BJ$2,0)))","v":""},"","",null,{"$f":"IF(ISERROR(INDEX('2022-23 Data'!$B$3:$BJ$20,MATCH($H$6,dfenums,0),MATCH($C45,'2022-23 Data'!$B$2:$BJ$2,0))),\"\",INDEX('2022-23 Data'!$B$3:$BJ$20,MATCH($H$6,dfenums,0),MATCH($C45,'2022-23 Data'!$B$2:$BJ$2,0)))","v":""},"","",null,{"$f":"IF(ISERROR(INDEX('2022-23 Data'!$B$3:$BJ$20,MATCH($L$6,dfenums,0),MATCH($C45,'2022-23 Data'!$B$2:$BJ$2,0))),\"\",INDEX('2022-23 Data'!$B$3:$BJ$20,MATCH($L$6,dfenums,0),MATCH($C45,'2022-23 Data'!$B$2:$BJ$2,0)))","v":""},"","",null,{"$f":"IF(ISERROR(INDEX('2022-23 Data'!$B$3:$BJ$20,MATCH($P$6,dfenums,0),MATCH($C45,'2022-23 Data'!$B$2:$BJ$2,0))),\"\",INDEX('2022-23 Data'!$B$3:$BJ$20,MATCH($P$6,dfenums,0),MATCH($C45,'2022-23 Data'!$B$2:$BJ$2,0)))","v":""},"","",null,{"$f":"IF(ISERROR(SUM('2022-23 Data'!AL$3:AL$20)/SUM('2022-23 Data'!$C$3:$D$20)),\"\",SUM('2022-23 Data'!AL$3:AL$20)/SUM('2022-23 Data'!$C$3:$D$20))","v":0},0,0]
[null,"Total Expenditure  ",null,{"$f":"IF($C$4>0,SUM(D13:D45),\"\")","v":""},{"$f":"IF($C$4>0,SUM(E13:E45),\"\")","v":""},{"$f":"IF($C$4>0,SUM(F13:F45),\"\")","v":""},null,{"$f":"IF($C$4>0,SUM(H13:H45),\"\")","v":""},{"$f":"IF($C$4>0,SUM(I13:I45),\"\")","v":""},{"$f":"IF($C$4>0,SUM(J13:J45),\"\")","v":""},null,{"$f":"IF($C$4>0,SUM(L13:L45),\"\")","v":""},{"$f":"IF($C$4>0,SUM(M13:M45),\"\")","v":""},{"$f":"IF($C$4>0,SUM(N13:N45),\"\")","v":""},null,{"$f":"IF($C$4>0,SUM(P13:P45),\"\")","v":""},{"$f":"IF($C$4>0,SUM(Q13:Q45),\"\")","v":""},{"$f":"IF($C$4>0,SUM(R13:R45),\"\")","v":""},null,{"$f":"IF(ISERROR(SUM(T13:T45)),\"\",SUM(T13:T45))","v":7015.0434229201246},{"$f":"IF(ISERROR(SUM(U13:U45)),\"\",SUM(U13:U45))","v":1},{"$f":"IF(ISERROR(SUM(V13:V45)),\"\",SUM(V13:V45))","v":0.65936167857712158}]
[]
[null,"INCOME"]
[null,"Funds delegated by the LEA","I01",{"$f":"IF(ISERROR(INDEX('2022-23 Data'!$B$3:$BJ$20,MATCH($C$4,dfenums,0),MATCH(\"I01 OTHER\",'2022-23 Data'!$B$2:$BJ$2,0))),\"\",INDEX('2022-23 Data'!$B$3:$BJ$20,MATCH($C$4,dfenums,0),MATCH(\"I01 OTHER\",'2022-23 Data'!$B$2:$BJ$2,0)))","v":""},{"$f":"IF(C4>0,D49/(E4-VLOOKUP(C4,'2022-23 Data'!A3:E20,5,0)))","v":false},{"$f":"IF($C$4>0,D49/$D$72)","v":false},null,{"$f":"IF(ISERROR(INDEX('2022-23 Data'!$B$3:$BJ$20,MATCH($H$6,dfenums,0),MATCH(\"I01 OTHER\",'2022-23 Data'!$B$2:$BJ$2,0))),\"\",INDEX('2022-23 Data'!$B$3:$BJ$20,MATCH($H$6,dfenums,0),MATCH(\"I01 OTHER\",'2022-23 Data'!$B$2:$BJ$2,0)))","v":""},{"$f":"IF(H6>0,H49/(I6-VLOOKUP(H6,'2022-23 Data'!A3:E20,5,0)))","v":false},{"$f":"IF($H$6>0,H49/$H$72)","v":false},null,{"$f":"IF(ISERROR(INDEX('2022-23 Data'!$B$3:$BJ$20,MATCH($L$6,dfenums,0),MATCH(\"I01 OTHER\",'2022-23 Data'!$B$2:$BJ$2,0))),\"\",INDEX('2022-23 Data'!$B$3:$BJ$20,MATCH($L$6,dfenums,0),MATCH(\"I01 OTHER\",'2022-23 Data'!$B$2:$BJ$2,0)))","v":""},{"$f":"IF(L6>0,L49/(M6-VLOOKUP(L6,'2022-23 Data'!A3:E20,5,0)))","v":false},{"$f":"IF($L$6>0,L49/$L$72)","v":false},null,{"$f":"IF(ISERROR(INDEX('2022-23 Data'!$B$3:$BJ$20,MATCH($P$6,dfenums,0),MATCH(\"I01 OTHER\",'2022-23 Data'!$B$2:$BJ$2,0))),\"\",INDEX('2022-23 Data'!$B$3:$BJ$20,MATCH($P$6,dfenums,0),MATCH(\"I01 OTHER\",'2022-23 Data'!$B$2:$BJ$2,0)))","v":""},{"$f":"IF(P6>0,P49/(Q6-VLOOKUP(P6,'2022-23 Data'!A3:E20,5,0)))","v":false},{"$f":"IF($P$6>0,P49/$P$72)","v":false},null,{"$f":"IF(ISERROR(SUM('2022-23 Data'!AM$3:AM$20)/SUM('2022-23 Data'!$C$3:$D$20)),\"\",SUM('2022-23 Data'!AM$3:AM$20)/SUM('2022-23 Data'!$C$3:$D$20))","v":-4440.9946715989727},{"$f":"IF(ISERROR(T49/$T$72),\"\",T49/$T$72)","v":0.41742032439175286}]
[null,"Funding for sixth form students","I02",{"$f":"IF(ISERROR(INDEX('2022-23 Data'!$B$3:$BJ$20,MATCH($C$4,dfenums,0),MATCH($C50,'2022-23 Data'!$B$2:$BJ$2,0))),\"\",INDEX('2022-23 Data'!$B$3:$BJ$20,MATCH($C$4,dfenums,0),MATCH($C50,'2022-23 Data'!$B$2:$BJ$2,0)))","v":""},{"$f":"IF(ISERROR(IF($C$4>0,D50/$F$4)),0,IF($C$4>0,D50/$F$4))","v":false},{"$f":"IF($C$4>0,D50/$D$72)","v":false},null,{"$f":"IF(ISERROR(INDEX('2022-23 Data'!$B$3:$BJ$20,MATCH($H$6,dfenums,0),MATCH($C50,'2022-23 Data'!$B$2:$BJ$2,0))),\"\",INDEX('2022-23 Data'!$B$3:$BJ$20,MATCH($H$6,dfenums,0),MATCH($C50,'2022-23 Data'!$B$2:$BJ$2,0)))","v":""},{"$f":"IF($H$6>0,H50/$J$6)","v":false},{"$f":"IF($H$6>0,H50/$H$72)","v":false},null,{"$f":"IF(ISERROR(INDEX('2022-23 Data'!$B$3:$BJ$20,MATCH($L$6,dfenums,0),MATCH($C50,'2022-23 Data'!$B$2:$BJ$2,0))),\"\",INDEX('2022-23 Data'!$B$3:$BJ$20,MATCH($L$6,dfenums,0),MATCH($C50,'2022-23 Data'!$B$2:$BJ$2,0)))","v":""},{"$f":"IF($L$6>0,L50/$N$6)","v":false},{"$f":"IF($L$6>0,L50/$L$72)","v":false},null,{"$f":"IF(ISERROR(INDEX('2022-23 Data'!$B$3:$BJ$20,MATCH($P$6,dfenums,0),MATCH($C50,'2022-23 Data'!$B$2:$BJ$2,0))),\"\",INDEX('2022-23 Data'!$B$3:$BJ$20,MATCH($P$6,dfenums,0),MATCH($C50,'2022-23 Data'!$B$2:$BJ$2,0)))","v":""},{"$f":"IF($P$6>0,P50/$R$6)","v":false},{"$f":"IF($P$6>0,P50/$P$72)","v":false},null,{"$f":"IF(ISERROR(SUM('2022-23 Data'!AQ$3:AQ$20)/SUM('2022-23 Data'!$D$3:$D$20)),\"\",SUM('2022-23 Data'!AQ$3:AQ$20)/SUM('2022-23 Data'!$D$3:$D$20))","v":-4897.0243093798972},{"$f":"IF(ISERROR(T50/$T$72),\"\",T50/$T$72)","v":0.46028370374956451}]
[null,"Notional SEN budget","I01",{"$f":"IF(ISERROR(INDEX('2022-23 Data'!$B$3:$BJ$20,MATCH($C$4,dfenums,0),MATCH($B51,'2022-23 Data'!$B$2:$BJ$2,0))),\"\",INDEX('2022-23 Data'!$B$3:$BJ$20,MATCH($C$4,dfenums,0),MATCH($B51,'2022-23 Data'!$B$2:$BJ$2,0)))","v":""},{"$f":"IF($C$4>0,D51/$E$4)","v":false},{"$f":"IF($C$4>0,D51/$D$72)","v":false},null,{"$f":"IF(ISERROR(INDEX('2022-23 Data'!$B$3:$BJ$20,MATCH($H$6,dfenums,0),MATCH($B51,'2022-23 Data'!$B$2:$BJ$2,0))),\"\",INDEX('2022-23 Data'!$B$3:$BJ$20,MATCH($H$6,dfenums,0),MATCH($B51,'2022-23 Data'!$B$2:$BJ$2,0)))","v":""},{"$f":"IF($P$6>0,H51/$I$6)","v":false},{"$f":"IF($H$6>0,H51/$H$72)","v":false},null,{"$f":"IF(ISERROR(INDEX('2022-23 Data'!$B$3:$BJ$20,MATCH($L$6,dfenums,0),MATCH($B51,'2022-23 Data'!$B$2:$BJ$2,0))),\"\",INDEX('2022-23 Data'!$B$3:$BJ$20,MATCH($L$6,dfenums,0),MATCH($B51,'2022-23 Data'!$B$2:$BJ$2,0)))","v":""},{"$f":"IF($P$6>0,L51/$M$6)","v":false},{"$f":"IF($L$6>0,L51/$L$72)","v":false},null,{"$f":"IF(ISERROR(INDEX('2022-23 Data'!$B$3:$BJ$20,MATCH($P$6,dfenums,0),MATCH($B51,'2022-23 Data'!$B$2:$BJ$2,0))),\"\",INDEX('2022-23 Data'!$B$3:$BJ$20,MATCH($P$6,dfenums,0),MATCH($B51,'2022-23 Data'!$B$2:$BJ$2,0)))","v":""},{"$f":"IF($P$6>0,P51/$Q$6)","v":false},{"$f":"IF($P$6>0,P51/$P$72)","v":false},null,{"$f":"IF(ISERROR(SUM('2022-23 Data'!AN$3:AN$20)/SUM('2022-23 Data'!$C$3:$D$20)),\"\",SUM('2022-23 Data'!AN$3:AN$20)/SUM('2022-23 Data'!$C$3:$D$20))","v":-641.43514268458421},6.0290111818410978E-2]
[null,"SRP Funding","I01 & I03",{"$f":"IF(ISERROR(INDEX('2022-23 Data'!$B$3:$BJ$20,MATCH($C$4,dfenums,0),MATCH(\"Unit Funding\",'2022-23 Data'!$B$2:$BJ$2,0))),\"\",INDEX('2022-23 Data'!$B$3:$BJ$20,MATCH($C$4,dfenums,0),MATCH(\"Unit Funding\",'2022-23 Data'!$B$2:$BJ$2,0)))","v":""},"Meaningful comparison is not possible in this area"]
[null,"High Needs Pupils Funding","I01 & I03",{"$f":"IF(ISERROR(INDEX('2022-23 Data'!$B$3:$BJ$20,MATCH($C$4,dfenums,0),MATCH(\"HNP Funding\",'2022-23 Data'!$B$2:$BJ$2,0))),\"\",INDEX('2022-23 Data'!$B$3:$BJ$20,MATCH($C$4,dfenums,0),MATCH(\"HNP Funding\",'2022-23 Data'!$B$2:$BJ$2,0)))","v":""}]
[null,"Funding for minority ethnic pupils","I04",{"$f":"IF(ISERROR(INDEX('2022-23 Data'!$B$3:$BJ$20,MATCH($C$4,dfenums,0),MATCH($C54,'2022-23 Data'!$B$2:$BJ$2,0))),\"\",INDEX('2022-23 Data'!$B$3:$BJ$20,MATCH($C$4,dfenums,0),MATCH($C54,'2022-23 Data'!$B$2:$BJ$2,0)))","v":""},{"$f":"IF($C$4>0,D54/($E$4+$F$4),\"\")","v":""},{"$f":"IF($C$4>0,D54/$D$72,\"\")","v":""},null,{"$f":"IF(ISERROR(INDEX('2022-23 Data'!$B$3:$BJ$20,MATCH($H$6,dfenums,0),MATCH($C54,'2022-23 Data'!$B$2:$BJ$2,0))),\"\",INDEX('2022-23 Data'!$B$3:$BJ$20,MATCH($H$6,dfenums,0),MATCH($C54,'2022-23 Data'!$B$2:$BJ$2,0)))","v":""},{"$f":"IF($H$6>0,H54/($I$6+$J$6),\"\")","v":""},{"$f":"IF($H$6>0,H54/$H$72,\"\")","v":""},null,{"$f":"IF(ISERROR(INDEX('2022-23 Data'!$B$3:$BJ$20,MATCH($L$6,dfenums,0),MATCH($C54,'2022-23 Data'!$B$2:$BJ$2,0))),\"\",INDEX('2022-23 Data'!$B$3:$BJ$20,MATCH($L$6,dfenums,0),MATCH($C54,'2022-23 Data'!$B$2:$BJ$2,0)))","v":""},{"$f":"IF($L$6>0,L54/($M$6+$N$6),\"\")","v":""},{"$f":"IF($L$6>0,L54/$L$72,\"\")","v":""},null,{"$f":"IF(ISERROR(INDEX('2022-23 Data'!$B$3:$BJ$20,MATCH($P$6,dfenums,0),MATCH($C54,'2022-23 Data'!$B$2:$BJ$2,0))),\"\",INDEX('2022-23 Data'!$B$3:$BJ$20,MATCH($P$6,dfenums,0),MATCH($C54,'2022-23 Data'!$B$2:$BJ$2,0)))","v":""},{"$f":"IF($P$6>0,P54/($Q$6+$R$6),\"\")","v":""},{"$f":"IF($P$6>0,P54/$P$72,\"\")","v":""},null,{"$f":"IF(ISERROR(SUM('2022-23 Data'!AR$3:AR$20)/SUM('2022-23 Data'!$C$3:$D$20)),\"\",SUM('2022-23 Data'!AR$3:AR$20)/SUM('2022-23 Data'!$C$3:$D$20))","v":0},0]
[null,"Pupil Premium","I05",{"$f":"IF(ISERROR(INDEX('2022-23 Data'!$B$3:$BJ$20,MATCH($C$4,dfenums,0),MATCH($C55,'2022-23 Data'!$B$2:$BJ$2,0))),\"\",INDEX('2022-23 Data'!$B$3:$BJ$20,MATCH($C$4,dfenums,0),MATCH($C55,'2022-23 Data'!$B$2:$BJ$2,0)))","v":""},{"$f":"IF($C$4>0,D55/($E$4+$F$4),\"\")","v":""},{"$f":"IF($C$4>0,D55/$D$72,\"\")","v":""},null,{"$f":"IF(ISERROR(INDEX('2022-23 Data'!$B$3:$BJ$20,MATCH($H$6,dfenums,0),MATCH($C55,'2022-23 Data'!$B$2:$BJ$2,0))),\"\",INDEX('2022-23 Data'!$B$3:$BJ$20,MATCH($H$6,dfenums,0),MATCH($C55,'2022-23 Data'!$B$2:$BJ$2,0)))","v":""},{"$f":"IF($H$6>0,H55/($I$6+$J$6),\"\")","v":""},{"$f":"IF($H$6>0,H55/$H$72,\"\")","v":""},null,{"$f":"IF(ISERROR(INDEX('2022-23 Data'!$B$3:$BJ$20,MATCH($L$6,dfenums,0),MATCH($C55,'2022-23 Data'!$B$2:$BJ$2,0))),\"\",INDEX('2022-23 Data'!$B$3:$BJ$20,MATCH($L$6,dfenums,0),MATCH($C55,'2022-23 Data'!$B$2:$BJ$2,0)))","v":""},{"$f":"IF($L$6>0,L55/($M$6+$N$6),\"\")","v":""},{"$f":"IF($L$6>0,L55/$L$72,\"\")","v":""},null,{"$f":"IF(ISERROR(INDEX('2022-23 Data'!$B$3:$BJ$20,MATCH($P$6,dfenums,0),MATCH($C55,'2022-23 Data'!$B$2:$BJ$2,0))),\"\",INDEX('2022-23 Data'!$B$3:$BJ$20,MATCH($P$6,dfenums,0),MATCH($C55,'2022-23 Data'!$B$2:$BJ$2,0)))","v":""},{"$f":"IF($P$6>0,P55/($Q$6+$R$6),\"\")","v":""},{"$f":"IF($P$6>0,P55/$P$72,\"\")","v":""},null,{"$f":"IF(ISERROR(SUM('2022-23 Data'!AS$3:AS$20)/SUM('2022-23 Data'!$C$3:$D$20)),\"\",SUM('2022-23 Data'!AS$3:AS$20)/SUM('2022-23 Data'!$C$3:$D$20))","v":-170.49869948160452},1.6025604106468975E-2]
[null,"Other government grants","I06",{"$f":"IF(ISERROR(INDEX('2022-23 Data'!$B$3:$BJ$20,MATCH($C$4,dfenums,0),MATCH($C56,'2022-23 Data'!$B$2:$BJ$2,0))),\"\",INDEX('2022-23 Data'!$B$3:$BJ$20,MATCH($C$4,dfenums,0),MATCH($C56,'2022-23 Data'!$B$2:$BJ$2,0)))","v":""},"","",null,{"$f":"IF(ISERROR(INDEX('2022-23 Data'!$B$3:$BJ$20,MATCH($H$6,dfenums,0),MATCH($C56,'2022-23 Data'!$B$2:$BJ$2,0))),\"\",INDEX('2022-23 Data'!$B$3:$BJ$20,MATCH($H$6,dfenums,0),MATCH($C56,'2022-23 Data'!$B$2:$BJ$2,0)))","v":""},"","",null,{"$f":"IF(ISERROR(INDEX('2022-23 Data'!$B$3:$BJ$20,MATCH($L$6,dfenums,0),MATCH($C56,'2022-23 Data'!$B$2:$BJ$2,0))),\"\",INDEX('2022-23 Data'!$B$3:$BJ$20,MATCH($L$6,dfenums,0),MATCH($C56,'2022-23 Data'!$B$2:$BJ$2,0)))","v":""},"","",null,{"$f":"IF(ISERROR(INDEX('2022-23 Data'!$B$3:$BJ$20,MATCH($P$6,dfenums,0),MATCH($C56,'2022-23 Data'!$B$2:$BJ$2,0))),\"\",INDEX('2022-23 Data'!$B$3:$BJ$20,MATCH($P$6,dfenums,0),MATCH($C56,'2022-23 Data'!$B$2:$BJ$2,0)))","v":""},"","",null,{"$f":"IF(ISERROR(SUM('2022-23 Data'!AT$3:AT$20)/SUM('2022-23 Data'!$C$3:$D$20)),\"\",SUM('2022-23 Data'!AT$3:AT$20)/SUM('2022-23 Data'!$C$3:$D$20))","v":-10.24743117419095},9.6318198089007058E-4]
[null,"Other grants and payments","I07",{"$f":"IF(ISERROR(INDEX('2022-23 Data'!$B$3:$BJ$20,MATCH($C$4,dfenums,0),MATCH($C57,'2022-23 Data'!$B$2:$BJ$2,0))),\"\",INDEX('2022-23 Data'!$B$3:$BJ$20,MATCH($C$4,dfenums,0),MATCH($C57,'2022-23 Data'!$B$2:$BJ$2,0)))","v":""},"","",null,{"$f":"IF(ISERROR(INDEX('2022-23 Data'!$B$3:$BJ$20,MATCH($H$6,dfenums,0),MATCH($C57,'2022-23 Data'!$B$2:$BJ$2,0))),\"\",INDEX('2022-23 Data'!$B$3:$BJ$20,MATCH($H$6,dfenums,0),MATCH($C57,'2022-23 Data'!$B$2:$BJ$2,0)))","v":""},"","",null,{"$f":"IF(ISERROR(INDEX('2022-23 Data'!$B$3:$BJ$20,MATCH($L$6,dfenums,0),MATCH($C57,'2022-23 Data'!$B$2:$BJ$2,0))),\"\",INDEX('2022-23 Data'!$B$3:$BJ$20,MATCH($L$6,dfenums,0),MATCH($C57,'2022-23 Data'!$B$2:$BJ$2,0)))","v":""},"","",null,{"$f":"IF(ISERROR(INDEX('2022-23 Data'!$B$3:$BJ$20,MATCH($P$6,dfenums,0),MATCH($C57,'2022-23 Data'!$B$2:$BJ$2,0))),\"\",INDEX('2022-23 Data'!$B$3:$BJ$20,MATCH($P$6,dfenums,0),MATCH($C57,'2022-23 Data'!$B$2:$BJ$2,0)))","v":""},"","",null,{"$f":"IF(ISERROR(SUM('2022-23 Data'!AU$3:AU$20)/SUM('2022-23 Data'!$C$3:$D$20)),\"\",SUM('2022-23 Data'!AU$3:AU$20)/SUM('2022-23 Data'!$C$3:$D$20))","v":-83.115325884543765},7.8122197521486745E-3]
[null,"Income from facilities and services","I08",{"$f":"IF(ISERROR(INDEX('2022-23 Data'!$B$3:$BJ$20,MATCH($C$4,dfenums,0),MATCH($C58,'2022-23 Data'!$B$2:$BJ$2,0))),\"\",INDEX('2022-23 Data'!$B$3:$BJ$20,MATCH($C$4,dfenums,0),MATCH($C58,'2022-23 Data'!$B$2:$BJ$2,0)))","v":""},{"$f":"IF($C$4>0,D58/($E$4+$F$4),\"\")","v":""},{"$f":"IF($C$4>0,D58/$D$72,\"\")","v":""},null,{"$f":"IF(ISERROR(INDEX('2022-23 Data'!$B$3:$BJ$20,MATCH($H$6,dfenums,0),MATCH($C58,'2022-23 Data'!$B$2:$BJ$2,0))),\"\",INDEX('2022-23 Data'!$B$3:$BJ$20,MATCH($H$6,dfenums,0),MATCH($C58,'2022-23 Data'!$B$2:$BJ$2,0)))","v":""},{"$f":"IF($H$6>0,H58/($I$6+$J$6),\"\")","v":""},{"$f":"IF($H$6>0,H58/$H$72,\"\")","v":""},null,{"$f":"IF(ISERROR(INDEX('2022-23 Data'!$B$3:$BJ$20,MATCH($L$6,dfenums,0),MATCH($C58,'2022-23 Data'!$B$2:$BJ$2,0))),\"\",INDEX('2022-23 Data'!$B$3:$BJ$20,MATCH($L$6,dfenums,0),MATCH($C58,'2022-23 Data'!$B$2:$BJ$2,0)))","v":""},{"$f":"IF($L$6>0,L58/($M$6+$N$6),\"\")","v":""},{"$f":"IF($L$6>0,L58/$L$72,\"\")","v":""},null,{"$f":"IF(ISERROR(INDEX('2022-23 Data'!$B$3:$BJ$20,MATCH($P$6,dfenums,0),MATCH($C58,'2022-23 Data'!$B$2:$BJ$2,0))),\"\",INDEX('2022-23 Data'!$B$3:$BJ$20,MATCH($P$6,dfenums,0),MATCH($C58,'2022-23 Data'!$B$2:$BJ$2,0)))","v":""},{"$f":"IF($P$6>0,P58/($Q$6+$R$6),\"\")","v":""},{"$f":"IF($P$6>0,P58/$P$72,\"\")","v":""},null,{"$f":"IF(ISERROR(SUM('2022-23 Data'!AW$3:AW$20)/SUM('2022-23 Data'!$C$3:$D$20)),\"\",SUM('2022-23 Data'!AW$3:AW$20)/SUM('2022-23 Data'!$C$3:$D$20))","v":-47.438681362927177},{"$f":"IF(ISERROR(T58/$T$72),\"\",T58/$T$72)","v":4.4588816757351419E-3}]
[null,"Income from facilities and services","I08b",{"$f":"IF(ISERROR(INDEX('2022-23 Data'!$B$3:$BJ$20,MATCH($C$4,dfenums,0),MATCH($C59,'2022-23 Data'!$B$2:$BJ$2,0))),\"\",INDEX('2022-23 Data'!$B$3:$BJ$20,MATCH($C$4,dfenums,0),MATCH($C59,'2022-23 Data'!$B$2:$BJ$2,0)))","v":""},"","",null,{"$f":"IF(ISERROR(INDEX('2022-23 Data'!$B$3:$BJ$20,MATCH($H$6,dfenums,0),MATCH($C59,'2022-23 Data'!$B$2:$BJ$2,0))),\"\",INDEX('2022-23 Data'!$B$3:$BJ$20,MATCH($H$6,dfenums,0),MATCH($C59,'2022-23 Data'!$B$2:$BJ$2,0)))","v":""},"","",null,{"$f":"IF(ISERROR(INDEX('2022-23 Data'!$B$3:$BJ$20,MATCH($L$6,dfenums,0),MATCH($C59,'2022-23 Data'!$B$2:$BJ$2,0))),\"\",INDEX('2022-23 Data'!$B$3:$BJ$20,MATCH($L$6,dfenums,0),MATCH($C59,'2022-23 Data'!$B$2:$BJ$2,0)))","v":""},"","",null,{"$f":"IF(ISERROR(INDEX('2022-23 Data'!$B$3:$BJ$20,MATCH($P$6,dfenums,0),MATCH($C59,'2022-23 Data'!$B$2:$BJ$2,0))),\"\",INDEX('2022-23 Data'!$B$3:$BJ$20,MATCH($P$6,dfenums,0),MATCH($C59,'2022-23 Data'!$B$2:$BJ$2,0)))","v":""},"","",null,{"$f":"IF(ISERROR(SUM('2022-23 Data'!AW$3:AW$20)/SUM('2022-23 Data'!$C$3:$D$20)),\"\",SUM('2022-23 Data'!AW$3:AW$20)/SUM('2022-23 Data'!$C$3:$D$20))","v":-47.438681362927177},4.4588816757351419E-3]
[null,"Income from catering","I09",{"$f":"IF(ISERROR(INDEX('2022-23 Data'!$B$3:$BJ$20,MATCH($C$4,dfenums,0),MATCH($C60,'2022-23 Data'!$B$2:$BJ$2,0))),\"\",INDEX('2022-23 Data'!$B$3:$BJ$20,MATCH($C$4,dfenums,0),MATCH($C60,'2022-23 Data'!$B$2:$BJ$2,0)))","v":""},"","",null,{"$f":"IF(ISERROR(INDEX('2022-23 Data'!$B$3:$BJ$20,MATCH($H$6,dfenums,0),MATCH($C60,'2022-23 Data'!$B$2:$BJ$2,0))),\"\",INDEX('2022-23 Data'!$B$3:$BJ$20,MATCH($H$6,dfenums,0),MATCH($C60,'2022-23 Data'!$B$2:$BJ$2,0)))","v":""},"","",null,{"$f":"IF(ISERROR(INDEX('2022-23 Data'!$B$3:$BJ$20,MATCH($L$6,dfenums,0),MATCH($C60,'2022-23 Data'!$B$2:$BJ$2,0))),\"\",INDEX('2022-23 Data'!$B$3:$BJ$20,MATCH($L$6,dfenums,0),MATCH($C60,'2022-23 Data'!$B$2:$BJ$2,0)))","v":""},"","",null,{"$f":"IF(ISERROR(INDEX('2022-23 Data'!$B$3:$BJ$20,MATCH($P$6,dfenums,0),MATCH($C60,'2022-23 Data'!$B$2:$BJ$2,0))),\"\",INDEX('2022-23 Data'!$B$3:$BJ$20,MATCH($P$6,dfenums,0),MATCH($C60,'2022-23 Data'!$B$2:$BJ$2,0)))","v":""},"","",null,{"$f":"IF(ISERROR(SUM('2022-23 Data'!AX$3:AX$20)/SUM('2022-23 Data'!$C$3:$D$20)),\"\",SUM('2022-23 Data'!AX$3:AX$20)/SUM('2022-23 Data'!$C$3:$D$20))","v":-70.4008047712517},6.617149746427348E-3]
[null,"Receipts from supply teachers insurance claims","I10",{"$f":"IF(ISERROR(INDEX('2022-23 Data'!$B$3:$BJ$20,MATCH($C$4,dfenums,0),MATCH($C61,'2022-23 Data'!$B$2:$BJ$2,0))),\"\",INDEX('2022-23 Data'!$B$3:$BJ$20,MATCH($C$4,dfenums,0),MATCH($C61,'2022-23 Data'!$B$2:$BJ$2,0)))","v":""},"","",null,{"$f":"IF(ISERROR(INDEX('2022-23 Data'!$B$3:$BJ$20,MATCH($H$6,dfenums,0),MATCH($C61,'2022-23 Data'!$B$2:$BJ$2,0))),\"\",INDEX('2022-23 Data'!$B$3:$BJ$20,MATCH($H$6,dfenums,0),MATCH($C61,'2022-23 Data'!$B$2:$BJ$2,0)))","v":""},"","",null,{"$f":"IF(ISERROR(INDEX('2022-23 Data'!$B$3:$BJ$20,MATCH($L$6,dfenums,0),MATCH($C61,'2022-23 Data'!$B$2:$BJ$2,0))),\"\",INDEX('2022-23 Data'!$B$3:$BJ$20,MATCH($L$6,dfenums,0),MATCH($C61,'2022-23 Data'!$B$2:$BJ$2,0)))","v":""},"","",null,{"$f":"IF(ISERROR(INDEX('2022-23 Data'!$B$3:$BJ$20,MATCH($P$6,dfenums,0),MATCH($C61,'2022-23 Data'!$B$2:$BJ$2,0))),\"\",INDEX('2022-23 Data'!$B$3:$BJ$20,MATCH($P$6,dfenums,0),MATCH($C61,'2022-23 Data'!$B$2:$BJ$2,0)))","v":""},"","",null,{"$f":"IF(ISERROR(SUM('2022-23 Data'!AY$3:AY$20)/SUM('2022-23 Data'!$C$3:$D$20)),\"\",SUM('2022-23 Data'!AY$3:AY$20)/SUM('2022-23 Data'!$C$3:$D$20))","v":-1.8670995017363734},1.7549340571621717E-4]
[null,"Receipts from other insurance claims","I11",{"$f":"IF(ISERROR(INDEX('2022-23 Data'!$B$3:$BJ$20,MATCH($C$4,dfenums,0),MATCH($C62,'2022-23 Data'!$B$2:$BJ$2,0))),\"\",INDEX('2022-23 Data'!$B$3:$BJ$20,MATCH($C$4,dfenums,0),MATCH($C62,'2022-23 Data'!$B$2:$BJ$2,0)))","v":""},"","",null,{"$f":"IF(ISERROR(INDEX('2022-23 Data'!$B$3:$BJ$20,MATCH($H$6,dfenums,0),MATCH($C62,'2022-23 Data'!$B$2:$BJ$2,0))),\"\",INDEX('2022-23 Data'!$B$3:$BJ$20,MATCH($H$6,dfenums,0),MATCH($C62,'2022-23 Data'!$B$2:$BJ$2,0)))","v":""},"","",null,{"$f":"IF(ISERROR(INDEX('2022-23 Data'!$B$3:$BJ$20,MATCH($L$6,dfenums,0),MATCH($C62,'2022-23 Data'!$B$2:$BJ$2,0))),\"\",INDEX('2022-23 Data'!$B$3:$BJ$20,MATCH($L$6,dfenums,0),MATCH($C62,'2022-23 Data'!$B$2:$BJ$2,0)))","v":""},"","",null,{"$f":"IF(ISERROR(INDEX('2022-23 Data'!$B$3:$BJ$20,MATCH($P$6,dfenums,0),MATCH($C62,'2022-23 Data'!$B$2:$BJ$2,0))),\"\",INDEX('2022-23 Data'!$B$3:$BJ$20,MATCH($P$6,dfenums,0),MATCH($C62,'2022-23 Data'!$B$2:$BJ$2,0)))","v":""},"","",null,{"$f":"IF(ISERROR(SUM('2022-23 Data'!AZ$3:AZ$20)/SUM('2022-23 Data'!$C$3:$D$20)),\"\",SUM('2022-23 Data'!AZ$3:AZ$20)/SUM('2022-23 Data'!$C$3:$D$20))","v":-10.639202274900599},1.00000553778181E-3]
[null,"Income from contributions to visits etc.","I12",{"$f":"IF(ISERROR(INDEX('2022-23 Data'!$B$3:$BJ$20,MATCH($C$4,dfenums,0),MATCH($C63,'2022-23 Data'!$B$2:$BJ$2,0))),\"\",INDEX('2022-23 Data'!$B$3:$BJ$20,MATCH($C$4,dfenums,0),MATCH($C63,'2022-23 Data'!$B$2:$BJ$2,0)))","v":""},"","",null,{"$f":"IF(ISERROR(INDEX('2022-23 Data'!$B$3:$BJ$20,MATCH($H$6,dfenums,0),MATCH($C63,'2022-23 Data'!$B$2:$BJ$2,0))),\"\",INDEX('2022-23 Data'!$B$3:$BJ$20,MATCH($H$6,dfenums,0),MATCH($C63,'2022-23 Data'!$B$2:$BJ$2,0)))","v":""},"","",null,{"$f":"IF(ISERROR(INDEX('2022-23 Data'!$B$3:$BJ$20,MATCH($L$6,dfenums,0),MATCH($C63,'2022-23 Data'!$B$2:$BJ$2,0))),\"\",INDEX('2022-23 Data'!$B$3:$BJ$20,MATCH($L$6,dfenums,0),MATCH($C63,'2022-23 Data'!$B$2:$BJ$2,0)))","v":""},"","",null,{"$f":"IF(ISERROR(INDEX('2022-23 Data'!$B$3:$BJ$20,MATCH($P$6,dfenums,0),MATCH($C63,'2022-23 Data'!$B$2:$BJ$2,0))),\"\",INDEX('2022-23 Data'!$B$3:$BJ$20,MATCH($P$6,dfenums,0),MATCH($C63,'2022-23 Data'!$B$2:$BJ$2,0)))","v":""},"","",null,{"$f":"IF(ISERROR(SUM('2022-23 Data'!BA$3:BA$20)/SUM('2022-23 Data'!$C$3:$D$20)),\"\",SUM('2022-23 Data'!BA$3:BA$20)/SUM('2022-23 Data'!$C$3:$D$20))","v":-80.49526045598671},7.5659531740529772E-3]
[null,"Donations and/or voluntary funds","I13",{"$f":"IF(ISERROR(INDEX('2022-23 Data'!$B$3:$BJ$20,MATCH($C$4,dfenums,0),MATCH($C64,'2022-23 Data'!$B$2:$BJ$2,0))),\"\",INDEX('2022-23 Data'!$B$3:$BJ$20,MATCH($C$4,dfenums,0),MATCH($C64,'2022-23 Data'!$B$2:$BJ$2,0)))","v":""},"","",null,{"$f":"IF(ISERROR(INDEX('2022-23 Data'!$B$3:$BJ$20,MATCH($H$6,dfenums,0),MATCH($C64,'2022-23 Data'!$B$2:$BJ$2,0))),\"\",INDEX('2022-23 Data'!$B$3:$BJ$20,MATCH($H$6,dfenums,0),MATCH($C64,'2022-23 Data'!$B$2:$BJ$2,0)))","v":""},"","",null,{"$f":"IF(ISERROR(INDEX('2022-23 Data'!$B$3:$BJ$20,MATCH($L$6,dfenums,0),MATCH($C64,'2022-23 Data'!$B$2:$BJ$2,0))),\"\",INDEX('2022-23 Data'!$B$3:$BJ$20,MATCH($L$6,dfenums,0),MATCH($C64,'2022-23 Data'!$B$2:$BJ$2,0)))","v":""},"","",null,{"$f":"IF(ISERROR(INDEX('2022-23 Data'!$B$3:$BJ$20,MATCH($P$6,dfenums,0),MATCH($C64,'2022-23 Data'!$B$2:$BJ$2,0))),\"\",INDEX('2022-23 Data'!$B$3:$BJ$20,MATCH($P$6,dfenums,0),MATCH($C64,'2022-23 Data'!$B$2:$BJ$2,0)))","v":""},"","",null,{"$f":"IF(ISERROR(SUM('2022-23 Data'!BB$3:BB$20)/SUM('2022-23 Data'!$C$3:$D$20)),\"\",SUM('2022-23 Data'!BB$3:BB$20)/SUM('2022-23 Data'!$C$3:$D$20))","v":-63.634516583622727},5.9811692017375127E-3]
[null,"Pupil focussed extended school funding &/or grants","I15",{"$f":"IF(ISERROR(INDEX('2022-23 Data'!$B$3:$BJ$20,MATCH($C$4,dfenums,0),MATCH($C65,'2022-23 Data'!$B$2:$BJ$2,0))),\"\",INDEX('2022-23 Data'!$B$3:$BJ$20,MATCH($C$4,dfenums,0),MATCH($C65,'2022-23 Data'!$B$2:$BJ$2,0)))","v":""},"","",null,{"$f":"IF(ISERROR(INDEX('2022-23 Data'!$B$3:$BJ$20,MATCH($H$6,dfenums,0),MATCH($C65,'2022-23 Data'!$B$2:$BJ$2,0))),\"\",INDEX('2022-23 Data'!$B$3:$BJ$20,MATCH($H$6,dfenums,0),MATCH($C65,'2022-23 Data'!$B$2:$BJ$2,0)))","v":""},"","",null,{"$f":"IF(ISERROR(INDEX('2022-23 Data'!$B$3:$BJ$20,MATCH($L$6,dfenums,0),MATCH($C65,'2022-23 Data'!$B$2:$BJ$2,0))),\"\",INDEX('2022-23 Data'!$B$3:$BJ$20,MATCH($L$6,dfenums,0),MATCH($C65,'2022-23 Data'!$B$2:$BJ$2,0)))","v":""},"","",null,{"$f":"IF(ISERROR(INDEX('2022-23 Data'!$B$3:$BJ$20,MATCH($P$6,dfenums,0),MATCH($C65,'2022-23 Data'!$B$2:$BJ$2,0))),\"\",INDEX('2022-23 Data'!$B$3:$BJ$20,MATCH($P$6,dfenums,0),MATCH($C65,'2022-23 Data'!$B$2:$BJ$2,0)))","v":""},"","",null,{"$f":"IF(ISERROR(SUM('2022-23 Data'!BC$3:BC$20)/SUM('2022-23 Data'!$C$3:$D$20)),\"\",SUM('2022-23 Data'!BC$3:BC$20)/SUM('2022-23 Data'!$C$3:$D$20))","v":0},0]
[null,"Com focussed extended school funding &/or grants","I16",{"$f":"IF(ISERROR(INDEX('2022-23 Data'!$B$3:$BJ$20,MATCH($C$4,dfenums,0),MATCH($C66,'2022-23 Data'!$B$2:$BJ$2,0))),\"\",INDEX('2022-23 Data'!$B$3:$BJ$20,MATCH($C$4,dfenums,0),MATCH($C66,'2022-23 Data'!$B$2:$BJ$2,0)))","v":""},"","",null,{"$f":"IF(ISERROR(INDEX('2022-23 Data'!$B$3:$BJ$20,MATCH($H$6,dfenums,0),MATCH($C66,'2022-23 Data'!$B$2:$BJ$2,0))),\"\",INDEX('2022-23 Data'!$B$3:$BJ$20,MATCH($H$6,dfenums,0),MATCH($C66,'2022-23 Data'!$B$2:$BJ$2,0)))","v":""},"","",null,{"$f":"IF(ISERROR(INDEX('2022-23 Data'!$B$3:$BJ$20,MATCH($L$6,dfenums,0),MATCH($C66,'2022-23 Data'!$B$2:$BJ$2,0))),\"\",INDEX('2022-23 Data'!$B$3:$BJ$20,MATCH($L$6,dfenums,0),MATCH($C66,'2022-23 Data'!$B$2:$BJ$2,0)))","v":""},"","",null,{"$f":"IF(ISERROR(INDEX('2022-23 Data'!$B$3:$BJ$20,MATCH($P$6,dfenums,0),MATCH($C66,'2022-23 Data'!$B$2:$BJ$2,0))),\"\",INDEX('2022-23 Data'!$B$3:$BJ$20,MATCH($P$6,dfenums,0),MATCH($C66,'2022-23 Data'!$B$2:$BJ$2,0)))","v":""},"","",null,{"$f":"IF(ISERROR(SUM('2022-23 Data'!BD$3:BD$20)/SUM('2022-23 Data'!$C$3:$D$20)),\"\",SUM('2022-23 Data'!BD$3:BD$20)/SUM('2022-23 Data'!$C$3:$D$20))","v":0},0]
[null,"Com focussed extended school facilities income","I17",{"$f":"IF(ISERROR(INDEX('2022-23 Data'!$B$3:$BJ$20,MATCH($C$4,dfenums,0),MATCH($C67,'2022-23 Data'!$B$2:$BJ$2,0))),\"\",INDEX('2022-23 Data'!$B$3:$BJ$20,MATCH($C$4,dfenums,0),MATCH($C67,'2022-23 Data'!$B$2:$BJ$2,0)))","v":""},"","",null,{"$f":"IF(ISERROR(INDEX('2022-23 Data'!$B$3:$BJ$20,MATCH($H$6,dfenums,0),MATCH($C67,'2022-23 Data'!$B$2:$BJ$2,0))),\"\",INDEX('2022-23 Data'!$B$3:$BJ$20,MATCH($H$6,dfenums,0),MATCH($C67,'2022-23 Data'!$B$2:$BJ$2,0)))","v":""},"","",null,{"$f":"IF(ISERROR(INDEX('2022-23 Data'!$B$3:$BJ$20,MATCH($L$6,dfenums,0),MATCH($C67,'2022-23 Data'!$B$2:$BJ$2,0))),\"\",INDEX('2022-23 Data'!$B$3:$BJ$20,MATCH($L$6,dfenums,0),MATCH($C67,'2022-23 Data'!$B$2:$BJ$2,0)))","v":""},"","",null,{"$f":"IF(ISERROR(INDEX('2022-23 Data'!$B$3:$BJ$20,MATCH($P$6,dfenums,0),MATCH($C67,'2022-23 Data'!$B$2:$BJ$2,0))),\"\",INDEX('2022-23 Data'!$B$3:$BJ$20,MATCH($P$6,dfenums,0),MATCH($C67,'2022-23 Data'!$B$2:$BJ$2,0)))","v":""},"","",null,{"$f":"IF(ISERROR(SUM('2022-23 Data'!BE$3:BE$20)/SUM('2022-23 Data'!$C$3:$D$20)),\"\",SUM('2022-23 Data'!BE$3:BE$20)/SUM('2022-23 Data'!$C$3:$D$20))","v":0},0]
[null,"Additional Grant for Schools","I18",{"$f":"IF(ISERROR(INDEX('2022-23 Data'!$B$3:$BJ$20,MATCH($C$4,dfenums,0),MATCH($C68,'2022-23 Data'!$B$2:$BJ$2,0))),\"\",INDEX('2022-23 Data'!$B$3:$BJ$20,MATCH($C$4,dfenums,0),MATCH($C68,'2022-23 Data'!$B$2:$BJ$2,0)))","v":""},"","",null,{"$f":"IF(ISERROR(INDEX('2022-23 Data'!$B$3:$BJ$20,MATCH($H$6,dfenums,0),MATCH($C68,'2022-23 Data'!$B$2:$BJ$2,0))),\"\",INDEX('2022-23 Data'!$B$3:$BJ$20,MATCH($H$6,dfenums,0),MATCH($C68,'2022-23 Data'!$B$2:$BJ$2,0)))","v":""},"","",null,{"$f":"IF(ISERROR(INDEX('2022-23 Data'!$B$3:$BJ$20,MATCH($L$6,dfenums,0),MATCH($C68,'2022-23 Data'!$B$2:$BJ$2,0))),\"\",INDEX('2022-23 Data'!$B$3:$BJ$20,MATCH($L$6,dfenums,0),MATCH($C68,'2022-23 Data'!$B$2:$BJ$2,0)))","v":""},"","",null,{"$f":"IF(ISERROR(INDEX('2022-23 Data'!$B$3:$BJ$20,MATCH($P$6,dfenums,0),MATCH($C68,'2022-23 Data'!$B$2:$BJ$2,0))),\"\",INDEX('2022-23 Data'!$B$3:$BJ$20,MATCH($P$6,dfenums,0),MATCH($C68,'2022-23 Data'!$B$2:$BJ$2,0)))","v":""},"","",null,{"$f":"IF(ISERROR(SUM('2022-23 Data'!BF$3:BF$20)/SUM('2022-23 Data'!$C$3:$D$20)),\"\",SUM('2022-23 Data'!BF$3:BF$20)/SUM('2022-23 Data'!$C$3:$D$20))","v":-4.1466606271075541},3.8975512291856382E-4]
[null,"Covid-19 furloughed Staff","I18A",{"$f":"IF(ISERROR(INDEX('2022-23 Data'!$B$3:$BJ$20,MATCH($C$4,dfenums,0),MATCH($C69,'2022-23 Data'!$B$2:$BJ$2,0))),\"\",INDEX('2022-23 Data'!$B$3:$BJ$20,MATCH($C$4,dfenums,0),MATCH($C69,'2022-23 Data'!$B$2:$BJ$2,0)))","v":""},{"$f":"IF($C$4>0,D69/($E$4+$F$4),\"\")","v":""},{"$f":"IF($C$4>0,D69/$D$72,\"\")","v":""},null,{"$f":"IF(ISERROR(INDEX('2022-23 Data'!$B$3:$BJ$20,MATCH($H$6,dfenums,0),MATCH($C69,'2022-23 Data'!$B$2:$BJ$2,0))),\"\",INDEX('2022-23 Data'!$B$3:$BJ$20,MATCH($H$6,dfenums,0),MATCH($C69,'2022-23 Data'!$B$2:$BJ$2,0)))","v":""},{"$f":"IF($H$6>0,H69/($I$6+$J$6),\"\")","v":""},{"$f":"IF($H$6>0,H69/$H$72,\"\")","v":""},null,{"$f":"IF(ISERROR(INDEX('2022-23 Data'!$B$3:$BJ$20,MATCH($L$6,dfenums,0),MATCH($C69,'2022-23 Data'!$B$2:$BJ$2,0))),\"\",INDEX('2022-23 Data'!$B$3:$BJ$20,MATCH($L$6,dfenums,0),MATCH($C69,'2022-23 Data'!$B$2:$BJ$2,0)))","v":""},{"$f":"IF($L$6>0,L69/($M$6+$N$6),\"\")","v":""},{"$f":"IF($L$6>0,L69/$L$72,\"\")","v":""},null,{"$f":"IF(ISERROR(INDEX('2022-23 Data'!$B$3:$BJ$20,MATCH($P$6,dfenums,0),MATCH($C69,'2022-23 Data'!$B$2:$BJ$2,0))),\"\",INDEX('2022-23 Data'!$B$3:$BJ$20,MATCH($P$6,dfenums,0),MATCH($C69,'2022-23 Data'!$B$2:$BJ$2,0)))","v":""},{"$f":"IF($P$6>0,P69/($Q$6+$R$6),\"\")","v":""},{"$f":"IF($P$6>0,P69/$P$72,\"\")","v":""},null,{"$f":"IF(ISERROR(SUM('2022-23 Data'!BG$3:BG$20)/SUM('2022-23 Data'!$C$3:$D$20)),\"\",SUM('2022-23 Data'!BG$3:BG$20)/SUM('2022-23 Data'!$C$3:$D$20))","v":0},{"$f":"IF(ISERROR(T69/$T$72),\"\",T69/$T$72)","v":0}]
[null,"Covid-19 any other Covid-19 related grant","I18B",{"$f":"IF(ISERROR(INDEX('2022-23 Data'!$B$3:$BJ$20,MATCH($C$4,dfenums,0),MATCH($C70,'2022-23 Data'!$B$2:$BJ$2,0))),\"\",INDEX('2022-23 Data'!$B$3:$BJ$20,MATCH($C$4,dfenums,0),MATCH($C70,'2022-23 Data'!$B$2:$BJ$2,0)))","v":""},{"$f":"IF($C$4>0,D70/($E$4+$F$4),\"\")","v":""},{"$f":"IF($C$4>0,D70/$D$72,\"\")","v":""},null,{"$f":"IF(ISERROR(INDEX('2022-23 Data'!$B$3:$BJ$20,MATCH($H$6,dfenums,0),MATCH($C70,'2022-23 Data'!$B$2:$BJ$2,0))),\"\",INDEX('2022-23 Data'!$B$3:$BJ$20,MATCH($H$6,dfenums,0),MATCH($C70,'2022-23 Data'!$B$2:$BJ$2,0)))","v":""},{"$f":"IF($H$6>0,H70/($I$6+$J$6),\"\")","v":""},{"$f":"IF($H$6>0,H70/$H$72,\"\")","v":""},null,{"$f":"IF(ISERROR(INDEX('2022-23 Data'!$B$3:$BJ$20,MATCH($L$6,dfenums,0),MATCH($C70,'2022-23 Data'!$B$2:$BJ$2,0))),\"\",INDEX('2022-23 Data'!$B$3:$BJ$20,MATCH($L$6,dfenums,0),MATCH($C70,'2022-23 Data'!$B$2:$BJ$2,0)))","v":""},{"$f":"IF($L$6>0,L70/($M$6+$N$6),\"\")","v":""},{"$f":"IF($L$6>0,L70/$L$72,\"\")","v":""},null,{"$f":"IF(ISERROR(INDEX('2022-23 Data'!$B$3:$BJ$20,MATCH($P$6,dfenums,0),MATCH($C70,'2022-23 Data'!$B$2:$BJ$2,0))),\"\",INDEX('2022-23 Data'!$B$3:$BJ$20,MATCH($P$6,dfenums,0),MATCH($C70,'2022-23 Data'!$B$2:$BJ$2,0)))","v":""},{"$f":"IF($P$6>0,P70/($Q$6+$R$6),\"\")","v":""},{"$f":"IF($P$6>0,P70/$P$72,\"\")","v":""},null,{"$f":"IF(ISERROR(SUM('2022-23 Data'!BH$3:BH$20)/SUM('2022-23 Data'!$C$3:$D$20)),\"\",SUM('2022-23 Data'!BH$3:BH$20)/SUM('2022-23 Data'!$C$3:$D$20))","v":-7.5795812572348895},{"$f":"IF(ISERROR(T70/$T$72),\"\",T70/$T$72)","v":7.1242401784046524E-4}]
[null,"Covid-19 £1bn package","I18C",{"$f":"IF(ISERROR(INDEX('2022-23 Data'!$B$3:$BJ$20,MATCH($C$4,dfenums,0),MATCH($C71,'2022-23 Data'!$B$2:$BJ$2,0))),\"\",INDEX('2022-23 Data'!$B$3:$BJ$20,MATCH($C$4,dfenums,0),MATCH($C71,'2022-23 Data'!$B$2:$BJ$2,0)))","v":""},"","",null,{"$f":"IF(ISERROR(INDEX('2022-23 Data'!$B$3:$BJ$20,MATCH($H$6,dfenums,0),MATCH($C71,'2022-23 Data'!$B$2:$BJ$2,0))),\"\",INDEX('2022-23 Data'!$B$3:$BJ$20,MATCH($H$6,dfenums,0),MATCH($C71,'2022-23 Data'!$B$2:$BJ$2,0)))","v":""},"","",null,{"$f":"IF(ISERROR(INDEX('2022-23 Data'!$B$3:$BJ$20,MATCH($L$6,dfenums,0),MATCH($C71,'2022-23 Data'!$B$2:$BJ$2,0))),\"\",INDEX('2022-23 Data'!$B$3:$BJ$20,MATCH($L$6,dfenums,0),MATCH($C71,'2022-23 Data'!$B$2:$BJ$2,0)))","v":""},"","",null,{"$f":"IF(ISERROR(INDEX('2022-23 Data'!$B$3:$BJ$20,MATCH($P$6,dfenums,0),MATCH($C71,'2022-23 Data'!$B$2:$BJ$2,0))),\"\",INDEX('2022-23 Data'!$B$3:$BJ$20,MATCH($P$6,dfenums,0),MATCH($C71,'2022-23 Data'!$B$2:$BJ$2,0)))","v":""},"","",null,{"$f":"IF(ISERROR(SUM('2022-23 Data'!BI$3:BI$20)/SUM('2022-23 Data'!$C$3:$D$20)),\"\",SUM('2022-23 Data'!BI$3:BI$20)/SUM('2022-23 Data'!$C$3:$D$20))","v":-62.187289244551806},5.8451406428187309E-3]
[null,"Total Income (excluding reserves and high needs)",null,{"$f":"IF($C$4>0,SUM(D49:D51)+SUM(D54:D71),\"\")","v":""},{"$f":"IF($C$4>0,SUM(E49:E71),\"\")","v":""},{"$f":"IF($C$4>0,SUM(F49:F71),\"\")","v":""},null,{"$f":"IF($H$6>0,SUM(H49:H51)+SUM(H54:H71),\"\")","v":""},{"$f":"IF($H$6>0,SUM(I49:I71),\"\")","v":""},{"$f":"IF($H$6>0,SUM(J49:J71),\"\")","v":""},null,{"$f":"IF($L$6>0,SUM(L49:L51)+SUM(L54:L71),\"\")","v":""},{"$f":"IF($L$6>0,SUM(M49:M71),\"\")","v":""},{"$f":"IF($L$6>0,SUM(N49:N71),\"\")","v":""},null,{"$f":"IF($P$6>0,SUM(P49:P51)+SUM(P54:P71),\"\")","v":""},{"$f":"IF($P$6>0,SUM(Q49:Q71),\"\")","v":""},{"$f":"IF($P$6>0,SUM(R49:R71),\"\")","v":""},null,{"$f":"IF(ISERROR(SUM(T49:T71)),\"\",SUM(T49:T51)+SUM(T54:T71))","v":-10639.14335764604},{"$f":"IF(ISERROR(SUM(U49:U71)),\"\",SUM(U49:U51)+SUM(U54:U71))","v":0.99999999999999989}]

{"sheet":"2022-23 Data","index":2,"n_rows":30,"n_cols":71,"rows_kept":30,"cut":false,"hidden":true,"merged":[[0,3,0,4]]}
[null,"PFI School",{"$f":"Benchmarking!C1&\" School Budget Templates\"","v":"2022-23 School Budget Templates"},"KCC Finance & Procurement",null,{"$f":"\"From \"&Benchmarking!C1&\" Checking Spreadsheet\"","v":"From 2022-23 Checking Spreadsheet"},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,"Self generating","KCC Finance & Procurement\nMinus figure","Self generating\nHN12, HN3U, HNOU, HNTU & HNUT","Self generating\nFrom Advances\nHNMT & HN3M",{"$f":"F1","v":"From 2022-23 Checking Spreadsheet"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"From March 20\"&RIGHT(Benchmarking!C1,2)&\" Advances\"","v":"From March 2023 Advances"},null,null,null,null,null,{"$f":"\"From March 20\"&RIGHT(Benchmarking!C1,2)&\" Advances\"","v":"From March 2023 Advances"}]
["DFE","SCHOOL","11-16 ROLL","POST-16 ROLL","SRP- ROLL","E01","E02","E03","E04","E05","E06","E07","E08","E09","E10","E11","E12","E13","E14","E15","E16","E17","E18","E19","E20","E21","E22","E23","E24","E25","E26","E27","E28","E28B","E29","E30","E31","E32","I01 OTHER","Notional SEN budget","Unit Funding","HNP Funding","I02","I04","I05","I06","I07","I08","I08b","I09","I10","I11","I12","I13","I15","I16","I17","I18","I18A","I18B","I18C","I01 + I03","HN12","HN3U","HNOU","HNTU","HNUT","AN Total","HNMT","HN3M","AM Total"]
[4026,"Dartford Science & Technology College",736,131,0,3185746.29,13980.880000000001,710863.66,180112.5,329844.53000000003,0,2135.64,7575.89,11798.43,1496.3700000000001,3504.96,81042.89,24695.64,10004.36,13319.94,195374.84,131328,52027.17,162527.29,38437.700000000004,80004.320000000007,54338.04,21448.36,0,49558.57,44989.99,85585.150000000009,37449.33,0,0,253831.97,0,0,{"$f":"BJ3-AN3-AO3-AP3","v":-4108663.33},-518897.01,{"$f":"BP3","v":0},{"$f":"BS3","v":-160410.99},-617478.89,0,-163834.5,0,-47864,-99971,-55846.76,0,0,0,0,-27785.100000000002,0,0,0,0,0,0,-45910.94,-4787971.33,0,0,0,0,0,{"$f":"-SUM(BK3:BO3)","v":0},0,160410.99,{"$f":"-SUM(BQ3:BR3)","v":-160410.99}]
[4040,"Northfleet School for Girls",928,247,0,4188428.7,0,1024261.4,165489.56,354587.07,150068.03,31933.89,34668.379999999997,32503.52,1818.88,31554.240000000002,235928.93,26223.68,194808.28,15317.880000000001,134446.89000000001,27136,36961.81,389720.18,162385.1,133173.48000000001,47951.18,28897.48,19547.11,292886.8,116417.90000000001,94735.89,22609.56,0,9811.6,89845,0,0,-4885012.1100000003,-933432.29,{"$f":"BP4","v":0},{"$f":"BS4","v":-20656.599999999999},-1141070.96,0,-336060,-9000,-94998.680000000008,-59022.41,-59864.98,-327893.14,-19903.16,-19790,-105370.78,-48072.3,0,0,0,0,0,-8814.84,-138654.35,-5839101,0,0,0,0,0,{"$f":"-SUM(BK4:BO4)","v":0},0,20656.599999999999,{"$f":"-SUM(BQ4:BR4)","v":-20656.599999999999}]
[4043,"Tunbridge Wells Girls' Grammar School",730,255,0,3500073.86,0,480320.59,87477.62,377471,0,3133.19,26802.82,25918.3,1430.8,25278.600000000002,148091.55000000002,67161.290000000008,138885.91,11839.09,149146.76999999999,48895.75,45691.43,352448.38,98580.14,109504.66,75525.279999999999,24558.940000000002,0,11358.710000000001,19748.560000000001,77881.5,51358.520000000004,0,0,300000,0,0,-3832738.8400000003,-456707.16,0,-73915.19,-1394442.52,0,-28860,0,-13247.04,0,-2480.23,0,0,0,0,-199783.45,0,0,0,0,0,-13903.220000000001,-15140.23,-4363361.1900000004,0,0,0,0,0,0,0,73915.19,-73915.19]
[4045,"Tunbridge Wells Grammar School for Boys",1176,346,0,4902588.96,0,751881.61,181033.48,591176.23,0,34569.840000000004,81167.740000000005,12370.29,2304.96,6177.96,720902.66,32155.63,213449.30000000002,13644.01,202019.92,246801.53,42059.040000000001,558265.96,282314.96000000002,135024.65,47558.07,36154.44,4617.3900000000003,24545.43,143651.51,119217.55,67862.42,0,28833.100000000002,75834,0,0,-6465936.9799999995,-813701.58,0,-30077.349999999995,-1486045.38,0,-63360,0,-14669.02,-192490.55000000002,-35569.410000000003,-25000,0,0,-308991.78999999998,-133412.70000000001,0,0,0,0,0,-16464.8,-29189.4,-7309715.9099999992,0,0,0,0,0,0,0,30077.349999999995,-30077.349999999995]
[4109,"Dover Grammar School for Girls",689,207,0,3455375.39,32412.43,439048.23,161685.69,358440.61,0,14534.64,18448.52,20124.09,1350.44,23492.880000000001,79810.320000000007,2362.5,20346.7,3593.13,77140.31,79872,20641.22,151659.80000000002,171797.23,146363.93,60189.94,21715.97,0,37124.400000000001,20175,53630,33142.01,0,8537.57,0,0,0,-3670324.1599999997,-390904.89,0,-27888.78,-1126507.6599999999,0,-115583.5,0,-17046.88,0,-28745.010000000002,0,0,0,-8180.96,-2,0,0,0,0,0,-11112.86,-49439.48,-4089117.8299999996,0,0,0,0,0,0,0,27888.78,-27888.78]
[4522,"Maidstone Grammar School",1055,377,0,4385922.74,0,685602.14,185939.65,372168.59,0,19248.8,62822.080000000002,22720.61,2067.8000000000002,36268.68,183819.71,56402.520000000004,145596.86000000002,45451.65,218714.85,35840,75590.13,481691.18,241705.11000000002,176136.86000000002,84479.7,36874.720000000001,58025.56,256694.21,51253.51,42221.08,76264.11,0,0,1083635.8999999999,0,0,-5431228.3300000001,-699138.77,0,-6693.9000000000024,-1895987.96,0,-77750,0,-1992.5,-91788.46,-52558.17,-210728.16,0,-1005,-201351.52000000002,-144885.13,0,0,0,0,0,-2018.64,-25571.170000000002,-6137061,0,0,0,0,0,0,0,6693.9000000000024,-6693.9000000000024]
[4523,"Maidstone Grammar School for Girls",879,324,0,3880330.3200000003,0,497949.03,99131.89,451711.81,0,14745.33,51534.32,21086.53,1722.8400000000001,30019.8,38475.57,8202.57,182739.05000000002,44150.37,176575.83000000002,35328,42814.8,306167.60000000003,92118.86,141476.43,58330.61,28012.71,230474.67,35067.730000000003,86661.74,44912.770000000004,45160.36,0,0,338995.7,0,0,-4566857.54,-551308.46,0,0,-1560753.29,0,-81830,0,-178484.07,-237984.36000000002,0,-10938.800000000001,0,-34702.03,-131806.62,-3005.5,0,0,0,0,0,-11394.1,-27500.55,-5118166,0,0,0,0,0,0,0,0,0]
[4534,"Simon Langton Girls' Grammar School",874,358,0,4264805.5599999996,0,574649.32999999996,117856.33,458592.96,107897.87,28127.39,18136.48,26143,1713.04,28606.14,57726.239999999998,72561.119999999995,142679.9,8408.33,140864.67000000001,167783.88,25628.07,439148.4,40797.07,107279.56,86626.87,28768.06,13158.54,226889.03,13300,10175.460000000001,77082.28,0,0,172203.09,0,0,-4667605.25,-555417.96,0,-48110.960000000006,-1685641.0899999999,0,-84080,-41622.200000000004,-17502.22,-30209.79,-34605.43,-312138.28000000003,0,-3478.51,-141531.91,-39244.6,0,0,0,0,0,-7269.14,-28759.02,-5271134.17,0,0,0,0,0,0,0,48110.960000000006,-48110.960000000006]
[4622,"Judd School, The",952,522,15.5,5047104.9000000004,0,906137.62,409026.07,464747.49,0,0,44765.94,24755.87,1865.92,0,349295.44,52089.05,23194.02,14650.2,127519.57,54272,25830.49,1073253.74,153317.66,205796.63,55607.58,76416.12,0,42118.01,27910.5,0,91007.86,0,8534.67,0,0,0,-4949483.2600000007,-631915.52000000002,-259438.68999999994,-5542.61,-2499457.31,0,-28170,-3636.4,-13245.12,-44174.31,-157930.54,0,0,-5220,0,-626369.72,0,0,0,0,0,-11398.94,-21996.400000000001,-5846380.0800000001,0,144105.35999999996,17333.330000000002,98000,0,-259438.68999999994,0,5542.61,-5542.61]
[5407,"Thamesview School",875,71,6,3339539.87,0,1027977.03,27367.63,350752.25,0,58232.380000000005,34186.04,76338.38,1715,28593.96,171799.95236359353,25527.869505434905,166732.44687742327,11481.804454069365,144131.10859467831,37376,5930.83,184556.82,70302.650000000009,98802.59,45841.36,65424.525400860191,23018.73,52570.400000000001,256605.28,166765.15,1183544.7328039405,0,0,56502.82,0,0,-5683818.1000000006,-967410.81,-135615.75999999998,-107386.21999999997,-174743.94,0,-356425,0,-100903.41,-2364.9299999999998,0,0,0,-16244.15,-1380,0,0,0,0,0,0,-8625.26,-101999.3,-6894230.8900000006,0,65615.75999999998,16000,54000,0,-135615.75999999998,0,107386.21999999997,-107386.21999999997]
[5412,"Simon Langton Grammar School for Boys",755,474,36.5,4609286.42,0,847319.48,276371.43,322054.88,203591,61885.94,44297.41,17877.07,1479.8,26638.68,81020.86,50787.130000000005,5982.88,40266.21,342004.99,32256,39293.99,571358.45000000007,182101.96,240219.86000000002,69137.649999999994,30547.46,11137.98,227141.2,14084.460000000001,10028.25,112020.63,0,25851.84,118596,0,0,-4100694.8000000003,-484753.7,-540836.06000000006,-26032.170000000006,-2554643.88,0,-38537.5,-1200,-113243.26000000001,-119999.28,-124122.93000000001,-334071.98,-17194.240000000002,0,-428820.31,-913.41,0,0,0,0,0,-2047.26,-24482.12,-5152316.7300000004,39000,316836.06,0,185000,0,-540836.06000000006,0,26032.170000000006,-26032.170000000006]
[5425,"Malling School, The",915,106,120.08333333333333,4769662.29,1142.42,1229371.45,0,427802.73,0,31668.11,53360.62,35068.93,1793.4,30212.52,70228.587582150692,34806.709452474439,129952.55186712011,5856.8263825962676,107768.23430639798,33792,5796.45,525457.93000000005,142374.48000000001,117501.22,68102.490000000005,57313.063949297168,999221.91820616287,51608.796114932251,13260,89190.89,137482.76213886827,0,0,132231.92000000001,0,0,-5558566.3400000008,-774104.63,-1420251.8,-178089.12,-710730.45000000007,0,-249542.5,-71943.509999999995,-88137.05,-39399.96,-13408.27,0,0,-27525.97,-22694.41,-17772.11,0,0,0,0,0,-1834.48,-142375.20000000001,-7931011.8900000006,10500,633751.80000000005,56000.000000000007,600000,120000,-1420251.8,0,178089.12,-178089.12]
[5426,"Archbishop's School, The",576,99,4,2787423.7199999997,12505.93,759405.32000000007,224771.69,333093.69,0,0,1529.99,31938.89,1128.96,19097.52,66758.790000000008,5000,3164.02,14150.93,124513.7,19558.400000000001,15431.57,161069.13,29987.65,58057.05,44477.13,16328.52,44821.23,137969.83000000002,367256.13,254594.6,26985.07,0,927.88,223264,0,0,-3301360.2100000004,-705680.49,-91188.12,-55200.109999999993,-313541.72000000003,0,-273433.40000000002,0,-469710.98,-14780,-27212.670000000002,-17801.420000000002,0,-20125.54,-31022.73,-5461.25,0,0,0,0,0,-7207.46,-105454.2,-4153428.93,0,37188.120000000003,12000,42000,0,-91188.12,0,55200.109999999993,-55200.109999999993]
[5431,"Hugh Christie Technology College",770,167,19.916666666666668,3693496.23,19052.02,629441.19000000006,0,326986.49,0,51585.11,18037.14,14962.220000000001,1509.2,3635.4,143133.37211090812,48847.951204911704,137648.96828416243,14689.75356913362,102764.18989421359,44544,0,321894.41000000003,104678.95,142054.54,148225.4,58997.492393753157,1171744.1643917973,55389.072639852486,65051.5,325261.90000000002,47400.595511267471,0,470.25,0,0,0,-5071219.6400000006,-711603.92,-331507.26,-41163.15,-795281.66,0,-273820,0,-196264.4,0,-133724.01,0,0,0,-173962.25,-1388.44,0,0,0,0,0,-7168.82,-102108.58,-6155493.9700000007,0,175507.26000000004,24000,132000,0,-331507.26,0,41163.15,-41163.15]
[5447,"St George's CE Foundation School",1081,132,0,5748444.5499999998,0,1191767.51,382284.21,512355.83,163188.4,56855,47884.3,13324.35,2881.2000000000003,205.58,120654.14,11019.42,27088.14,11682,248562.9,69380,37625.96,380345.77,172620.44,138290.06,75547.13,55091.61,0,181907.86000000002,44520.69,220674.17,78340.33,0,0,545928,0,0,-7030251.71,-1369628.37,0,-172249.64999999997,-758803.03,0,-573355.82999999996,0,-126612.78,-29683.75,-60714.19,-157998.26999999999,0,-6163.3,-28599.75,-20,0,0,0,-82390,0,-10422.94,-155896.89000000001,-8572129.7300000004,0,0,0,0,0,0,0,172249.64999999997,-172249.64999999997]
[5456,"Northfleet Technology College",787,155,0,3572195.54,14023.75,860502.62,0,341144.01,0,0,50864.29,49132.15,1542.52,26139.72,103582.31426494976,22824.695204122938,146862.75635071823,13060.808973488485,124885.58727162385,34560,10946.710000000001,287886.5,68122.19,157764.87,46801.700000000004,41022.319228263674,985168.80456534354,59469.123861921638,103455.63,82376.930000000008,54368.560279567755,0,0,107826.97,0,0,-5117807.25,-884161.21,0,-59299.759999999995,-802130.33000000007,0,-263455,-57571.200000000004,-69862.63,0,-29434.09,0,0,-25924.95,0,0,0,0,0,0,0,-7812.74,-86875.08,-6061268.2199999997,0,0,0,0,0,0,0,59299.759999999995,-59299.759999999995]
[5459,"Dover Grammar School for Boys",663,165,0,3077411.97,10517.97,430321.95,195681.45,289130.23999999999,0,0,4323.84,14205.62,1299.48,22352.880000000001,58654.31,22933.040000000001,6797.67,56964.81,59414.67,17818,11647.300000000001,123333.13,97846.91,90327.48,65260.83,19882.95,14087.99,47467,14060,61138.700000000004,58782.92,0,0,47052.270000000004,0,0,-3464441.1799999997,-369523.91,0,-37805.769999999997,-650772.34,0,-128342.5,-3814.8,-1817.5,0,-100981,-2223.54,0,-17220.55,-15647.300000000001,-14988.5,0,0,0,0,0,-1591.66,-43883.38,-3871770.86,0,0,0,0,0,0,0,37805.769999999997,-37805.769999999997]
[5461,"St John's RC Comprehensive School",961,331,0,5352664.32,0,864889.19000000006,0,225905.66,0,39260.99,56778.66,16581.810000000001,1883.56,32341.68,171540.67684257793,23198.466253110131,192937.90384354384,14579.819112375701,166629.09966740359,52933.72,26227.41,192931.29,110556.01000000001,174622.51,80056.350000000006,81704.06683296588,1220321.8873980464,73672.602560239029,87598.94,65271.94,66943.547489737684,0,0,10346,0,0,-6332114.1000000006,-926384.17,0,-83151.47,-1706975.1800000002,0,-251198.93,-14818.1,-85816.87,0,-25361.47,0,0,-33990.31,0,-1250,0,0,0,0,0,-21511.54,-90362.96,-7341649.7400000002,0,0,0,0,0,0,0,83151.47,-83151.47]
[]
[null,null,6,null,null,"E01","E02","E03","E04","E05","E06","E07","E08","E09","E10","E11","E12","E13","E14","E15","E16","E17","E18","E19","E20","E21","E22","E23","E24","E25","E26","E27","E28","E28B","E29","E30","E31","E32",{"$f":"IF(ISERROR(SUM('2022-23 Data'!AM$3:AM$20)/SUM('2022-23 Data'!$C$3:$D$20)),\"\",SUM('2022-23 Data'!AM$3:AM$20)/SUM('2022-23 Data'!$C$3:$D$20))","v":-4440.9946715989727},-347.20789701042912,null,null,"I02","I04","I05","I06","I07","I08","I08b","I09","I10","I11","I12","I13","I15","I16","I17","I18","I18A","I18B","I18C","I01","I03"]
[null,null,7,null,null,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,56,57,58,59,60,61,62,63,64,65,66,67,null,null,null,null,73,75,76,77,78,79,80,81,82,83,84,85,87,88,89,90,91,92,93,72,74]
[]
[null,"PFI Breakdown",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"E12","E13","E14","E15","E16",null,null,null,null,null,null,"E23","E24","E25",null,null,"E28","E28B"]
[5407,"Thamesview School",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'PFI Adjustments'!D16","v":171799.95236359353},{"$f":"'PFI Adjustments'!E16","v":25527.869505434905},{"$f":"'PFI Adjustments'!F16","v":166732.44687742327},{"$f":"'PFI Adjustments'!G16","v":11481.804454069365},{"$f":"'PFI Adjustments'!H16","v":144131.10859467831},null,null,null,null,null,null,{"$f":"'PFI Adjustments'!I16","v":65424.525400860191},{"$f":"'PFI Adjustments'!J16","v":23018.73},{"$f":"'PFI Adjustments'!K16","v":52570.400000000001},null,null,{"$f":"'PFI Adjustments'!L16","v":1183544.7328039405},0]
[5425,"The Malling School",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'PFI Adjustments'!D17","v":70228.587582150692},{"$f":"'PFI Adjustments'!E17","v":34806.709452474439},{"$f":"'PFI Adjustments'!F17","v":129952.55186712011},{"$f":"'PFI Adjustments'!G17","v":5856.8263825962676},{"$f":"'PFI Adjustments'!H17","v":107768.23430639798},null,null,null,null,null,null,{"$f":"'PFI Adjustments'!I17","v":57313.063949297168},{"$f":"'PFI Adjustments'!J17","v":999221.91820616287},{"$f":"'PFI Adjustments'!K17","v":51608.796114932251},null,null,{"$f":"'PFI Adjustments'!L17","v":137482.76213886827},0]
[5431,"Hugh Christie Technology College",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'PFI Adjustments'!D18","v":143133.37211090812},{"$f":"'PFI Adjustments'!E18","v":48847.951204911704},{"$f":"'PFI Adjustments'!F18","v":137648.96828416243},{"$f":"'PFI Adjustments'!G18","v":14689.75356913362},{"$f":"'PFI Adjustments'!H18","v":102764.18989421359},null,null,null,null,null,null,{"$f":"'PFI Adjustments'!I18","v":58997.492393753157},{"$f":"'PFI Adjustments'!J18","v":1171744.1643917973},{"$f":"'PFI Adjustments'!K18","v":55389.072639852486},null,null,{"$f":"'PFI Adjustments'!L18","v":47400.595511267471},0]
[5456,"Northfleet Technology College",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'PFI Adjustments'!D19","v":103582.31426494976},{"$f":"'PFI Adjustments'!E19","v":22824.695204122938},{"$f":"'PFI Adjustments'!F19","v":146862.75635071823},{"$f":"'PFI Adjustments'!G19","v":13060.808973488485},{"$f":"'PFI Adjustments'!H19","v":124885.58727162385},null,null,null,null,null,null,{"$f":"'PFI Adjustments'!I19","v":41022.319228263674},{"$f":"'PFI Adjustments'!J19","v":985168.80456534354},{"$f":"'PFI Adjustments'!K19","v":59469.123861921638},null,null,{"$f":"'PFI Adjustments'!L19","v":54368.560279567755},0]
[5461,"St Johns RC Comprehensive School",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'PFI Adjustments'!D20","v":171540.67684257793},{"$f":"'PFI Adjustments'!E20","v":23198.466253110131},{"$f":"'PFI Adjustments'!F20","v":192937.90384354384},{"$f":"'PFI Adjustments'!G20","v":14579.819112375701},{"$f":"'PFI Adjustments'!H20","v":166629.09966740359},null,null,null,null,null,null,{"$f":"'PFI Adjustments'!I20","v":81704.06683296588},{"$f":"'PFI Adjustments'!J20","v":1220321.8873980464},{"$f":"'PFI Adjustments'!K20","v":73672.602560239029},null,null,{"$f":"'PFI Adjustments'!L20","v":66943.547489737684},0]

{"sheet":"PFI Adjustments","index":3,"n_rows":20,"n_cols":23,"rows_kept":20,"cut":false,"hidden":true,"merged":[[8,0,8,1],[1,2,5,2],[15,2,19,2]]}
["PFI Breakdown",null,null,"E12","E13","E14","E15","E16","E23","E24","E25","E28"]
[5407,"Thamesview School",null,26046.87,0,0,0,16648.72,23542.49,23018.73,52570.400000000001,39663.700000000004]
[5425,"The Malling School",null,3394.04,7528.1500000000005,463.2,0,0,25008.510000000002,36926.03,9156.02,70950.900000000009]
[5431,"Hugh Christie Technology College",null,49395.64,10533.380000000001,335.83,0,0,22283.7,161502.03,1150.27,19249.189999999999]
[5456,"Northfleet Technology College",null,8493.7000000000007,0,766.69,90.68,4220.4800000000005,22026.31,0,2029.75,44368.53]
[5461,"St Johns RC Comprehensive School",null,55893.630000000005,0,0,0,0,28586.53,60.77,8588.56,24631.83]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Standard percentage figures for 2014-15 to 2017-18"]
["PFI Breakdown",null,{"$f":"\"E28B total from\"&CHAR(10)&\" 20\"&RIGHT(Benchmarking!C1,5)&CHAR(10)&\" Checking Spreadsheet\"","v":"E28B total from\n 2022-23\n Checking Spreadsheet"},"E12","E13","E14","E15","E16","E23","E24","E25","E28",null,"E12","E13","E14","E15","E16","E23","E24","E25","E28","Comments"]
[5407,"Thamesview School",1662740.6600000001,{"$f":"$C10*N10","v":145753.08236359354},{"$f":"$C10*O10","v":25527.869505434905},{"$f":"$C10*P10","v":166732.44687742327},{"$f":"$C10*Q10","v":11481.804454069365},{"$f":"$C10*R10","v":127482.38859467831},{"$f":"$C10*S10","v":41882.035400860186},{"$f":"$C10*T10","v":0},{"$f":"$C10*U10","v":0},{"$f":"$C10*V10","v":1143881.0328039406},null,8.7658337749191462E-2,1.5352887025349402E-2,0.10027567791445195,6.9053489400261389E-3,7.6670037403595043E-2,2.5188555502612286E-2,0,0,0.68794915546477375,"Supplied by School"]
[5425,"The Malling School",1440812.6,66834.547582150699,27278.559452474441,129489.35186712012,5856.8263825962676,107768.23430639798,32304.553949297166,962295.88820616284,42452.776114932247,66531.862138868266,null,4.6386703990616611E-2,1.8932760202454116E-2,8.9872445498547213E-2,4.0649466714798767E-3,7.4796843327437565E-2,2.2421065688415804E-2,0.66788414274428387,2.9464467561522049E-2,4.6176624315242845E-2,"Calculation"]
[5431,"Hugh Christie Technology College",1516165.52,93737.732110908124,38314.571204911706,137313.13828416244,14689.75356913362,102764.18989421359,36713.79239375316,1010242.1343917974,54238.802639852489,28151.405511267469,null,6.1825526879748675E-2,2.5270704747929966E-2,9.0566060547375093E-2,9.6887532234169391E-3,6.777900469218795E-2,2.4214897324503964E-2,0.66631388266354807,3.5773668457948105E-2,1.8567501463341199E-2,"Calculation"]
[5456,"Northfleet Technology College",1469248.83,95088.614264949763,22824.695204122938,146096.06635071823,12970.128973488485,120665.10727162386,18996.009228263669,985168.80456534354,57439.373861921638,10000.030279567758,null,6.4719203666100428E-2,1.5534941895528299E-2,9.9435890890393452E-2,8.8277279577540883E-3,8.2127073922273502E-2,1.2929062008008316E-2,0.67052549877840872,3.9094381216503424E-2,6.8062196650296178E-3,"Supplied by School"]
[5461,"St Johns RC Comprehensive School",1893766.75,115647.04684257794,23198.466253110131,192937.90384354384,14579.819112375701,166629.09966740359,53117.536832965889,1220261.1173980464,65084.042560239024,42311.717489737683,null,6.1067207375236653E-2,1.2249906834149523E-2,0.10188050024827178,7.6988462873665408E-3,8.7988185275406056E-2,2.8048616247468645E-2,0.64435660695703223,3.4367507276299482E-2,2.234262349876915E-2,"Calculation"]
[]
[5407,"Thamesview School",null,{"$f":"D2+D10","v":171799.95236359353},25527.869505434905,166732.44687742327,11481.804454069365,144131.10859467831,65424.525400860191,23018.73,52570.400000000001,1183544.7328039405]
[5425,"The Malling School",null,{"$f":"D3+D11","v":70228.587582150692},34806.709452474439,129952.55186712011,5856.8263825962676,107768.23430639798,57313.063949297168,999221.91820616287,51608.796114932251,137482.76213886827]
[5431,"Hugh Christie Technology College",null,{"$f":"D4+D12","v":143133.37211090812},48847.951204911704,137648.96828416243,14689.75356913362,102764.18989421359,58997.492393753157,1171744.1643917973,55389.072639852486,47400.595511267471]
[5456,"Northfleet Technology College",null,{"$f":"D5+D13","v":103582.31426494976},22824.695204122938,146862.75635071823,13060.808973488485,124885.58727162385,41022.319228263674,985168.80456534354,59469.123861921638,54368.560279567755]
[5461,"St Johns RC Comprehensive School",null,{"$f":"D6+D14","v":171540.67684257793},23198.466253110131,192937.90384354384,14579.819112375701,166629.09966740359,81704.06683296588,1220321.8873980464,73672.602560239029,66943.547489737684]