{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Introduction","Benchmarking","2023-24 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":"2023-24 Data"},null,null,{"$f":"\"Kent LA Schools' Benchmarking Data \"&Benchmarking!C1","v":"Kent LA Schools' Benchmarking Data 2023-24"}]
[]
[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 2023-24 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 ","2023-24"," 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,'2023-24 Data'!$A$3:$C$19,3,0)),\"\",VLOOKUP(C4,'2023-24 Data'!$A$3:$C$19,3,0)+VLOOKUP(C4,'2023-24 Data'!$A$3:$E$19,5,0))","v":""},{"$f":"IF(ISERROR(VLOOKUP(C4,'2023-24 Data'!$A$3:$D$19,4,0)),\"\",VLOOKUP(C4,'2023-24 Data'!$A$3:$D$19,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 2023-24 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,'2023-24 Data'!$A$3:$C$19,3,0)),\"\",VLOOKUP(H6,'2023-24 Data'!$A$3:$C$19,3,0))","v":""},{"$f":"IF(ISERROR(VLOOKUP(H6,'2023-24 Data'!$A$3:$D$19,4,0)),\"\",VLOOKUP(H6,'2023-24 Data'!$A$3:$D$19,4,0))","v":""},null,{"$f":"IF(ISERROR(SUMIF(schools,L4,dfenums)),\"\",SUMIF(schools,L4,dfenums))","v":0},{"$f":"IF(ISERROR(VLOOKUP(L6,'2023-24 Data'!$A$3:$C$19,3,0)),\"\",VLOOKUP(L6,'2023-24 Data'!$A$3:$C$19,3,0))","v":""},{"$f":"IF(ISERROR(VLOOKUP(L6,'2023-24 Data'!$A$3:$D$19,4,0)),\"\",VLOOKUP(L6,'2023-24 Data'!$A$3:$D$19,4,0))","v":""},null,{"$f":"IF(ISERROR(SUMIF(schools,P4,dfenums)),\"\",SUMIF(schools,P4,dfenums))","v":0},{"$f":"IF(ISERROR(VLOOKUP(P6,'2023-24 Data'!$A$3:$C$19,3,0)),\"\",VLOOKUP(P6,'2023-24 Data'!$A$3:$C$19,3,0))","v":""},{"$f":"IF(ISERROR(VLOOKUP(P6,'2023-24 Data'!$A$3:$D$19,4,0)),\"\",VLOOKUP(P6,'2023-24 Data'!$A$3:$D$19,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,'2023-24 Data'!A3:B279,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('2023-24 Data'!$B$3:$BJ$19,MATCH($C$4,dfenums,0),MATCH($C13,'2023-24 Data'!$B$2:$BJ$2,0))),\"\",INDEX('2023-24 Data'!$B$3:$BJ$19,MATCH($C$4,dfenums,0),MATCH($C13,'2023-24 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('2023-24 Data'!$B$3:$BJ$19,MATCH($H$6,dfenums,0),MATCH($C13,'2023-24 Data'!$B$2:$BJ$2,0))),\"\",INDEX('2023-24 Data'!$B$3:$BJ$19,MATCH($H$6,dfenums,0),MATCH($C13,'2023-24 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('2023-24 Data'!$B$3:$BJ$19,MATCH($L$6,dfenums,0),MATCH($C13,'2023-24 Data'!$B$2:$BJ$2,0))),\"\",INDEX('2023-24 Data'!$B$3:$BJ$19,MATCH($L$6,dfenums,0),MATCH($C13,'2023-24 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('2023-24 Data'!$B$3:$BJ$19,MATCH($P$6,dfenums,0),MATCH($C13,'2023-24 Data'!$B$2:$BJ$2,0))),\"\",INDEX('2023-24 Data'!$B$3:$BJ$19,MATCH($P$6,dfenums,0),MATCH($C13,'2023-24 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('2023-24 Data'!F$3:F$19)/SUM('2023-24 Data'!$C$3:$D$19)),\"\",SUM('2023-24 Data'!F$3:F$19)/SUM('2023-24 Data'!$C$3:$D$19))","v":5132.468644386704},{"$f":"IF(ISERROR(T13/$T$46),\"\",T13/$T$46)","v":0.53195605631465548},{"$f":"IF(ISERROR(T13/-$T$72),\"\",T13/-$T$72)","v":5.531126141268018E-3}]
[null,"Supply teaching staff","E02",{"$f":"IF(ISERROR(INDEX('2023-24 Data'!$B$3:$BJ$19,MATCH($C$4,dfenums,0),MATCH($C14,'2023-24 Data'!$B$2:$BJ$2,0))),\"\",INDEX('2023-24 Data'!$B$3:$BJ$19,MATCH($C$4,dfenums,0),MATCH($C14,'2023-24 Data'!$B$2:$BJ$2,0)))","v":""},"","",null,{"$f":"IF(ISERROR(INDEX('2023-24 Data'!$B$3:$BJ$19,MATCH($H$6,dfenums,0),MATCH($C14,'2023-24 Data'!$B$2:$BJ$2,0))),\"\",INDEX('2023-24 Data'!$B$3:$BJ$19,MATCH($H$6,dfenums,0),MATCH($C14,'2023-24 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('2023-24 Data'!$B$3:$BJ$19,MATCH($L$6,dfenums,0),MATCH($C14,'2023-24 Data'!$B$2:$BJ$2,0))),\"\",INDEX('2023-24 Data'!$B$3:$BJ$19,MATCH($L$6,dfenums,0),MATCH($C14,'2023-24 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('2023-24 Data'!$B$3:$BJ$19,MATCH($P$6,dfenums,0),MATCH($C14,'2023-24 Data'!$B$2:$BJ$2,0))),\"\",INDEX('2023-24 Data'!$B$3:$BJ$19,MATCH($P$6,dfenums,0),MATCH($C14,'2023-24 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('2023-24 Data'!G$3:G$19)/SUM('2023-24 Data'!$C$3:$D$19)),\"\",SUM('2023-24 Data'!G$3:G$19)/SUM('2023-24 Data'!$C$3:$D$19))","v":9.294188692769465},{"$f":"IF(ISERROR(T14/$T$46),\"\",T14/$T$46)","v":9.6329862025697677E-4},{"$f":"IF(ISERROR(T14/-$T$72),\"\",T14/-$T$72)","v":1.0016102114267793E-5}]
[null,"Education support staff","E03",{"$f":"IF(ISERROR(INDEX('2023-24 Data'!$B$3:$BJ$19,MATCH($C$4,dfenums,0),MATCH($C15,'2023-24 Data'!$B$2:$BJ$2,0))),\"\",INDEX('2023-24 Data'!$B$3:$BJ$19,MATCH($C$4,dfenums,0),MATCH($C15,'2023-24 Data'!$B$2:$BJ$2,0)))","v":""},"","",null,{"$f":"IF(ISERROR(INDEX('2023-24 Data'!$B$3:$BJ$19,MATCH($H$6,dfenums,0),MATCH($C15,'2023-24 Data'!$B$2:$BJ$2,0))),\"\",INDEX('2023-24 Data'!$B$3:$BJ$19,MATCH($H$6,dfenums,0),MATCH($C15,'2023-24 Data'!$B$2:$BJ$2,0)))","v":""},"","",null,{"$f":"IF(ISERROR(INDEX('2023-24 Data'!$B$3:$BJ$19,MATCH($L$6,dfenums,0),MATCH($C15,'2023-24 Data'!$B$2:$BJ$2,0))),\"\",INDEX('2023-24 Data'!$B$3:$BJ$19,MATCH($L$6,dfenums,0),MATCH($C15,'2023-24 Data'!$B$2:$BJ$2,0)))","v":""},"","",null,{"$f":"IF(ISERROR(INDEX('2023-24 Data'!$B$3:$BJ$19,MATCH($P$6,dfenums,0),MATCH($C15,'2023-24 Data'!$B$2:$BJ$2,0))),\"\",INDEX('2023-24 Data'!$B$3:$BJ$19,MATCH($P$6,dfenums,0),MATCH($C15,'2023-24 Data'!$B$2:$BJ$2,0)))","v":""},"","",null,{"$f":"IF(ISERROR(SUM('2023-24 Data'!H$3:H$19)/SUM('2023-24 Data'!$C$3:$D$19)),\"\",SUM('2023-24 Data'!H$3:H$19)/SUM('2023-24 Data'!$C$3:$D$19))","v":999.77418130095862},0.10362185675926759,1.0774302762875129E-3]
[null,"Premises staff","E04",{"$f":"IF(ISERROR(INDEX('2023-24 Data'!$B$3:$BJ$19,MATCH($C$4,dfenums,0),MATCH($C16,'2023-24 Data'!$B$2:$BJ$2,0))),\"\",INDEX('2023-24 Data'!$B$3:$BJ$19,MATCH($C$4,dfenums,0),MATCH($C16,'2023-24 Data'!$B$2:$BJ$2,0)))","v":""},"","",null,{"$f":"IF(ISERROR(INDEX('2023-24 Data'!$B$3:$BJ$19,MATCH($H$6,dfenums,0),MATCH($C16,'2023-24 Data'!$B$2:$BJ$2,0))),\"\",INDEX('2023-24 Data'!$B$3:$BJ$19,MATCH($H$6,dfenums,0),MATCH($C16,'2023-24 Data'!$B$2:$BJ$2,0)))","v":""},"","",null,{"$f":"IF(ISERROR(INDEX('2023-24 Data'!$B$3:$BJ$19,MATCH($L$6,dfenums,0),MATCH($C16,'2023-24 Data'!$B$2:$BJ$2,0))),\"\",INDEX('2023-24 Data'!$B$3:$BJ$19,MATCH($L$6,dfenums,0),MATCH($C16,'2023-24 Data'!$B$2:$BJ$2,0)))","v":""},"","",null,{"$f":"IF(ISERROR(INDEX('2023-24 Data'!$B$3:$BJ$19,MATCH($P$6,dfenums,0),MATCH($C16,'2023-24 Data'!$B$2:$BJ$2,0))),\"\",INDEX('2023-24 Data'!$B$3:$BJ$19,MATCH($P$6,dfenums,0),MATCH($C16,'2023-24 Data'!$B$2:$BJ$2,0)))","v":""},"","",null,{"$f":"IF(ISERROR(SUM('2023-24 Data'!I$3:I$19)/SUM('2023-24 Data'!$C$3:$D$19)),\"\",SUM('2023-24 Data'!I$3:I$19)/SUM('2023-24 Data'!$C$3:$D$19))","v":196.73686654421644},2.0390844038184999E-2,2.1201813413589842E-4]
[null,"Administrative and clerical staff","E05",{"$f":"IF(ISERROR(INDEX('2023-24 Data'!$B$3:$BJ$19,MATCH($C$4,dfenums,0),MATCH($C17,'2023-24 Data'!$B$2:$BJ$2,0))),\"\",INDEX('2023-24 Data'!$B$3:$BJ$19,MATCH($C$4,dfenums,0),MATCH($C17,'2023-24 Data'!$B$2:$BJ$2,0)))","v":""},"","",null,{"$f":"IF(ISERROR(INDEX('2023-24 Data'!$B$3:$BJ$19,MATCH($H$6,dfenums,0),MATCH($C17,'2023-24 Data'!$B$2:$BJ$2,0))),\"\",INDEX('2023-24 Data'!$B$3:$BJ$19,MATCH($H$6,dfenums,0),MATCH($C17,'2023-24 Data'!$B$2:$BJ$2,0)))","v":""},"","",null,{"$f":"IF(ISERROR(INDEX('2023-24 Data'!$B$3:$BJ$19,MATCH($L$6,dfenums,0),MATCH($C17,'2023-24 Data'!$B$2:$BJ$2,0))),\"\",INDEX('2023-24 Data'!$B$3:$BJ$19,MATCH($L$6,dfenums,0),MATCH($C17,'2023-24 Data'!$B$2:$BJ$2,0)))","v":""},"","",null,{"$f":"IF(ISERROR(INDEX('2023-24 Data'!$B$3:$BJ$19,MATCH($P$6,dfenums,0),MATCH($C17,'2023-24 Data'!$B$2:$BJ$2,0))),\"\",INDEX('2023-24 Data'!$B$3:$BJ$19,MATCH($P$6,dfenums,0),MATCH($C17,'2023-24 Data'!$B$2:$BJ$2,0)))","v":""},"","",null,{"$f":"IF(ISERROR(SUM('2023-24 Data'!J$3:J$19)/SUM('2023-24 Data'!$C$3:$D$19)),\"\",SUM('2023-24 Data'!J$3:J$19)/SUM('2023-24 Data'!$C$3:$D$19))","v":497.3833092912821},5.1551423305176231E-2,5.3601687898478009E-4]
[null,"Catering staff","E06",{"$f":"IF(ISERROR(INDEX('2023-24 Data'!$B$3:$BJ$19,MATCH($C$4,dfenums,0),MATCH($C18,'2023-24 Data'!$B$2:$BJ$2,0))),\"\",INDEX('2023-24 Data'!$B$3:$BJ$19,MATCH($C$4,dfenums,0),MATCH($C18,'2023-24 Data'!$B$2:$BJ$2,0)))","v":""},"","",null,{"$f":"IF(ISERROR(INDEX('2023-24 Data'!$B$3:$BJ$19,MATCH($H$6,dfenums,0),MATCH($C18,'2023-24 Data'!$B$2:$BJ$2,0))),\"\",INDEX('2023-24 Data'!$B$3:$BJ$19,MATCH($H$6,dfenums,0),MATCH($C18,'2023-24 Data'!$B$2:$BJ$2,0)))","v":""},"","",null,{"$f":"IF(ISERROR(INDEX('2023-24 Data'!$B$3:$BJ$19,MATCH($L$6,dfenums,0),MATCH($C18,'2023-24 Data'!$B$2:$BJ$2,0))),\"\",INDEX('2023-24 Data'!$B$3:$BJ$19,MATCH($L$6,dfenums,0),MATCH($C18,'2023-24 Data'!$B$2:$BJ$2,0)))","v":""},"","",null,{"$f":"IF(ISERROR(INDEX('2023-24 Data'!$B$3:$BJ$19,MATCH($P$6,dfenums,0),MATCH($C18,'2023-24 Data'!$B$2:$BJ$2,0))),\"\",INDEX('2023-24 Data'!$B$3:$BJ$19,MATCH($P$6,dfenums,0),MATCH($C18,'2023-24 Data'!$B$2:$BJ$2,0)))","v":""},"","",null,{"$f":"IF(ISERROR(SUM('2023-24 Data'!K$3:K$19)/SUM('2023-24 Data'!$C$3:$D$19)),\"\",SUM('2023-24 Data'!K$3:K$19)/SUM('2023-24 Data'!$C$3:$D$19))","v":50.988124720007164},5.2846775351660978E-3,5.4948557716277176E-5]
[null,"Cost of other staff","E07",{"$f":"IF(ISERROR(INDEX('2023-24 Data'!$B$3:$BJ$19,MATCH($C$4,dfenums,0),MATCH($C19,'2023-24 Data'!$B$2:$BJ$2,0))),\"\",INDEX('2023-24 Data'!$B$3:$BJ$19,MATCH($C$4,dfenums,0),MATCH($C19,'2023-24 Data'!$B$2:$BJ$2,0)))","v":""},"","",null,{"$f":"IF(ISERROR(INDEX('2023-24 Data'!$B$3:$BJ$19,MATCH($H$6,dfenums,0),MATCH($C19,'2023-24 Data'!$B$2:$BJ$2,0))),\"\",INDEX('2023-24 Data'!$B$3:$BJ$19,MATCH($H$6,dfenums,0),MATCH($C19,'2023-24 Data'!$B$2:$BJ$2,0)))","v":""},"","",null,{"$f":"IF(ISERROR(INDEX('2023-24 Data'!$B$3:$BJ$19,MATCH($L$6,dfenums,0),MATCH($C19,'2023-24 Data'!$B$2:$BJ$2,0))),\"\",INDEX('2023-24 Data'!$B$3:$BJ$19,MATCH($L$6,dfenums,0),MATCH($C19,'2023-24 Data'!$B$2:$BJ$2,0)))","v":""},"","",null,{"$f":"IF(ISERROR(INDEX('2023-24 Data'!$B$3:$BJ$19,MATCH($P$6,dfenums,0),MATCH($C19,'2023-24 Data'!$B$2:$BJ$2,0))),\"\",INDEX('2023-24 Data'!$B$3:$BJ$19,MATCH($P$6,dfenums,0),MATCH($C19,'2023-24 Data'!$B$2:$BJ$2,0)))","v":""},"","",null,{"$f":"IF(ISERROR(SUM('2023-24 Data'!L$3:L$19)/SUM('2023-24 Data'!$C$3:$D$19)),\"\",SUM('2023-24 Data'!L$3:L$19)/SUM('2023-24 Data'!$C$3:$D$19))","v":33.060825866857812},3.4265979522103349E-3,3.5628780392858711E-5]
[null,"Indirect employee expenses","E08",{"$f":"IF(ISERROR(INDEX('2023-24 Data'!$B$3:$BJ$19,MATCH($C$4,dfenums,0),MATCH($C20,'2023-24 Data'!$B$2:$BJ$2,0))),\"\",INDEX('2023-24 Data'!$B$3:$BJ$19,MATCH($C$4,dfenums,0),MATCH($C20,'2023-24 Data'!$B$2:$BJ$2,0)))","v":""},"","",null,{"$f":"IF(ISERROR(INDEX('2023-24 Data'!$B$3:$BJ$19,MATCH($H$6,dfenums,0),MATCH($C20,'2023-24 Data'!$B$2:$BJ$2,0))),\"\",INDEX('2023-24 Data'!$B$3:$BJ$19,MATCH($H$6,dfenums,0),MATCH($C20,'2023-24 Data'!$B$2:$BJ$2,0)))","v":""},"","",null,{"$f":"IF(ISERROR(INDEX('2023-24 Data'!$B$3:$BJ$19,MATCH($L$6,dfenums,0),MATCH($C20,'2023-24 Data'!$B$2:$BJ$2,0))),\"\",INDEX('2023-24 Data'!$B$3:$BJ$19,MATCH($L$6,dfenums,0),MATCH($C20,'2023-24 Data'!$B$2:$BJ$2,0)))","v":""},"","",null,{"$f":"IF(ISERROR(INDEX('2023-24 Data'!$B$3:$BJ$19,MATCH($P$6,dfenums,0),MATCH($C20,'2023-24 Data'!$B$2:$BJ$2,0))),\"\",INDEX('2023-24 Data'!$B$3:$BJ$19,MATCH($P$6,dfenums,0),MATCH($C20,'2023-24 Data'!$B$2:$BJ$2,0)))","v":""},"","",null,{"$f":"IF(ISERROR(SUM('2023-24 Data'!M$3:M$19)/SUM('2023-24 Data'!$C$3:$D$19)),\"\",SUM('2023-24 Data'!M$3:M$19)/SUM('2023-24 Data'!$C$3:$D$19))","v":43.902777080906723},4.5503148241855989E-3,4.731286536977614E-5]
[null,"Development and training","E09",{"$f":"IF(ISERROR(INDEX('2023-24 Data'!$B$3:$BJ$19,MATCH($C$4,dfenums,0),MATCH($C21,'2023-24 Data'!$B$2:$BJ$2,0))),\"\",INDEX('2023-24 Data'!$B$3:$BJ$19,MATCH($C$4,dfenums,0),MATCH($C21,'2023-24 Data'!$B$2:$BJ$2,0)))","v":""},"","",null,{"$f":"IF(ISERROR(INDEX('2023-24 Data'!$B$3:$BJ$19,MATCH($H$6,dfenums,0),MATCH($C21,'2023-24 Data'!$B$2:$BJ$2,0))),\"\",INDEX('2023-24 Data'!$B$3:$BJ$19,MATCH($H$6,dfenums,0),MATCH($C21,'2023-24 Data'!$B$2:$BJ$2,0)))","v":""},"","",null,{"$f":"IF(ISERROR(INDEX('2023-24 Data'!$B$3:$BJ$19,MATCH($L$6,dfenums,0),MATCH($C21,'2023-24 Data'!$B$2:$BJ$2,0))),\"\",INDEX('2023-24 Data'!$B$3:$BJ$19,MATCH($L$6,dfenums,0),MATCH($C21,'2023-24 Data'!$B$2:$BJ$2,0)))","v":""},"","",null,{"$f":"IF(ISERROR(INDEX('2023-24 Data'!$B$3:$BJ$19,MATCH($P$6,dfenums,0),MATCH($C21,'2023-24 Data'!$B$2:$BJ$2,0))),\"\",INDEX('2023-24 Data'!$B$3:$BJ$19,MATCH($P$6,dfenums,0),MATCH($C21,'2023-24 Data'!$B$2:$BJ$2,0)))","v":""},"","",null,{"$f":"IF(ISERROR(SUM('2023-24 Data'!N$3:N$19)/SUM('2023-24 Data'!$C$3:$D$19)),\"\",SUM('2023-24 Data'!N$3:N$19)/SUM('2023-24 Data'!$C$3:$D$19))","v":33.079301361885136},3.4285128497292794E-3,3.5648690946745926E-5]
[null,"Supply teacher insurance","E10",{"$f":"IF(ISERROR(INDEX('2023-24 Data'!$B$3:$BJ$19,MATCH($C$4,dfenums,0),MATCH($C22,'2023-24 Data'!$B$2:$BJ$2,0))),\"\",INDEX('2023-24 Data'!$B$3:$BJ$19,MATCH($C$4,dfenums,0),MATCH($C22,'2023-24 Data'!$B$2:$BJ$2,0)))","v":""},"","",null,{"$f":"IF(ISERROR(INDEX('2023-24 Data'!$B$3:$BJ$19,MATCH($H$6,dfenums,0),MATCH($C22,'2023-24 Data'!$B$2:$BJ$2,0))),\"\",INDEX('2023-24 Data'!$B$3:$BJ$19,MATCH($H$6,dfenums,0),MATCH($C22,'2023-24 Data'!$B$2:$BJ$2,0)))","v":""},"","",null,{"$f":"IF(ISERROR(INDEX('2023-24 Data'!$B$3:$BJ$19,MATCH($L$6,dfenums,0),MATCH($C22,'2023-24 Data'!$B$2:$BJ$2,0))),\"\",INDEX('2023-24 Data'!$B$3:$BJ$19,MATCH($L$6,dfenums,0),MATCH($C22,'2023-24 Data'!$B$2:$BJ$2,0)))","v":""},"","",null,{"$f":"IF(ISERROR(INDEX('2023-24 Data'!$B$3:$BJ$19,MATCH($P$6,dfenums,0),MATCH($C22,'2023-24 Data'!$B$2:$BJ$2,0))),\"\",INDEX('2023-24 Data'!$B$3:$BJ$19,MATCH($P$6,dfenums,0),MATCH($C22,'2023-24 Data'!$B$2:$BJ$2,0)))","v":""},"","",null,{"$f":"IF(ISERROR(SUM('2023-24 Data'!O$3:O$19)/SUM('2023-24 Data'!$C$3:$D$19)),\"\",SUM('2023-24 Data'!O$3:O$19)/SUM('2023-24 Data'!$C$3:$D$19))","v":2.0562740793835674},2.1312306528501723E-4,2.2159923619853574E-6]
[null,"Staff related insurance","E11",{"$f":"IF(ISERROR(INDEX('2023-24 Data'!$B$3:$BJ$19,MATCH($C$4,dfenums,0),MATCH($C23,'2023-24 Data'!$B$2:$BJ$2,0))),\"\",INDEX('2023-24 Data'!$B$3:$BJ$19,MATCH($C$4,dfenums,0),MATCH($C23,'2023-24 Data'!$B$2:$BJ$2,0)))","v":""},"","",null,{"$f":"IF(ISERROR(INDEX('2023-24 Data'!$B$3:$BJ$19,MATCH($H$6,dfenums,0),MATCH($C23,'2023-24 Data'!$B$2:$BJ$2,0))),\"\",INDEX('2023-24 Data'!$B$3:$BJ$19,MATCH($H$6,dfenums,0),MATCH($C23,'2023-24 Data'!$B$2:$BJ$2,0)))","v":""},"","",null,{"$f":"IF(ISERROR(INDEX('2023-24 Data'!$B$3:$BJ$19,MATCH($L$6,dfenums,0),MATCH($C23,'2023-24 Data'!$B$2:$BJ$2,0))),\"\",INDEX('2023-24 Data'!$B$3:$BJ$19,MATCH($L$6,dfenums,0),MATCH($C23,'2023-24 Data'!$B$2:$BJ$2,0)))","v":""},"","",null,{"$f":"IF(ISERROR(INDEX('2023-24 Data'!$B$3:$BJ$19,MATCH($P$6,dfenums,0),MATCH($C23,'2023-24 Data'!$B$2:$BJ$2,0))),\"\",INDEX('2023-24 Data'!$B$3:$BJ$19,MATCH($P$6,dfenums,0),MATCH($C23,'2023-24 Data'!$B$2:$BJ$2,0)))","v":""},"","",null,{"$f":"IF(ISERROR(SUM('2023-24 Data'!P$3:P$19)/SUM('2023-24 Data'!$C$3:$D$19)),\"\",SUM('2023-24 Data'!P$3:P$19)/SUM('2023-24 Data'!$C$3:$D$19))","v":26.231902159304724},2.7188123667461926E-3,2.826942935680669E-5]
[null,"Building maintenance and improvement","E12",{"$f":"IF(ISERROR(INDEX('2023-24 Data'!$B$3:$BJ$19,MATCH($C$4,dfenums,0),MATCH($C24,'2023-24 Data'!$B$2:$BJ$2,0))),\"\",INDEX('2023-24 Data'!$B$3:$BJ$19,MATCH($C$4,dfenums,0),MATCH($C24,'2023-24 Data'!$B$2:$BJ$2,0)))","v":""},"","",null,{"$f":"IF(ISERROR(INDEX('2023-24 Data'!$B$3:$BJ$19,MATCH($H$6,dfenums,0),MATCH($C24,'2023-24 Data'!$B$2:$BJ$2,0))),\"\",INDEX('2023-24 Data'!$B$3:$BJ$19,MATCH($H$6,dfenums,0),MATCH($C24,'2023-24 Data'!$B$2:$BJ$2,0)))","v":""},"","",null,{"$f":"IF(ISERROR(INDEX('2023-24 Data'!$B$3:$BJ$19,MATCH($L$6,dfenums,0),MATCH($C24,'2023-24 Data'!$B$2:$BJ$2,0))),\"\",INDEX('2023-24 Data'!$B$3:$BJ$19,MATCH($L$6,dfenums,0),MATCH($C24,'2023-24 Data'!$B$2:$BJ$2,0)))","v":""},"","",null,{"$f":"IF(ISERROR(INDEX('2023-24 Data'!$B$3:$BJ$19,MATCH($P$6,dfenums,0),MATCH($C24,'2023-24 Data'!$B$2:$BJ$2,0))),\"\",INDEX('2023-24 Data'!$B$3:$BJ$19,MATCH($P$6,dfenums,0),MATCH($C24,'2023-24 Data'!$B$2:$BJ$2,0)))","v":""},"","",null,{"$f":"IF(ISERROR(SUM('2023-24 Data'!Q$3:Q$19)/SUM('2023-24 Data'!$C$3:$D$19)),\"\",SUM('2023-24 Data'!Q$3:Q$19)/SUM('2023-24 Data'!$C$3:$D$19))","v":158.99666548924},1.6479251019553623E-2,1.7134651447384887E-4]
[null,"Grounds maintenance and improvement","E13",{"$f":"IF(ISERROR(INDEX('2023-24 Data'!$B$3:$BJ$19,MATCH($C$4,dfenums,0),MATCH($C25,'2023-24 Data'!$B$2:$BJ$2,0))),\"\",INDEX('2023-24 Data'!$B$3:$BJ$19,MATCH($C$4,dfenums,0),MATCH($C25,'2023-24 Data'!$B$2:$BJ$2,0)))","v":""},"","",null,{"$f":"IF(ISERROR(INDEX('2023-24 Data'!$B$3:$BJ$19,MATCH($H$6,dfenums,0),MATCH($C25,'2023-24 Data'!$B$2:$BJ$2,0))),\"\",INDEX('2023-24 Data'!$B$3:$BJ$19,MATCH($H$6,dfenums,0),MATCH($C25,'2023-24 Data'!$B$2:$BJ$2,0)))","v":""},"","",null,{"$f":"IF(ISERROR(INDEX('2023-24 Data'!$B$3:$BJ$19,MATCH($L$6,dfenums,0),MATCH($C25,'2023-24 Data'!$B$2:$BJ$2,0))),\"\",INDEX('2023-24 Data'!$B$3:$BJ$19,MATCH($L$6,dfenums,0),MATCH($C25,'2023-24 Data'!$B$2:$BJ$2,0)))","v":""},"","",null,{"$f":"IF(ISERROR(INDEX('2023-24 Data'!$B$3:$BJ$19,MATCH($P$6,dfenums,0),MATCH($C25,'2023-24 Data'!$B$2:$BJ$2,0))),\"\",INDEX('2023-24 Data'!$B$3:$BJ$19,MATCH($P$6,dfenums,0),MATCH($C25,'2023-24 Data'!$B$2:$BJ$2,0)))","v":""},"","",null,{"$f":"IF(ISERROR(SUM('2023-24 Data'!R$3:R$19)/SUM('2023-24 Data'!$C$3:$D$19)),\"\",SUM('2023-24 Data'!R$3:R$19)/SUM('2023-24 Data'!$C$3:$D$19))","v":40.131723286081801},4.1594629663687082E-3,4.3248900118376831E-5]
[null,"Cleaning and caretaking","E14",{"$f":"IF(ISERROR(INDEX('2023-24 Data'!$B$3:$BJ$19,MATCH($C$4,dfenums,0),MATCH($C26,'2023-24 Data'!$B$2:$BJ$2,0))),\"\",INDEX('2023-24 Data'!$B$3:$BJ$19,MATCH($C$4,dfenums,0),MATCH($C26,'2023-24 Data'!$B$2:$BJ$2,0)))","v":""},"","",null,{"$f":"IF(ISERROR(INDEX('2023-24 Data'!$B$3:$BJ$19,MATCH($H$6,dfenums,0),MATCH($C26,'2023-24 Data'!$B$2:$BJ$2,0))),\"\",INDEX('2023-24 Data'!$B$3:$BJ$19,MATCH($H$6,dfenums,0),MATCH($C26,'2023-24 Data'!$B$2:$BJ$2,0)))","v":""},"","",null,{"$f":"IF(ISERROR(INDEX('2023-24 Data'!$B$3:$BJ$19,MATCH($L$6,dfenums,0),MATCH($C26,'2023-24 Data'!$B$2:$BJ$2,0))),\"\",INDEX('2023-24 Data'!$B$3:$BJ$19,MATCH($L$6,dfenums,0),MATCH($C26,'2023-24 Data'!$B$2:$BJ$2,0)))","v":""},"","",null,{"$f":"IF(ISERROR(INDEX('2023-24 Data'!$B$3:$BJ$19,MATCH($P$6,dfenums,0),MATCH($C26,'2023-24 Data'!$B$2:$BJ$2,0))),\"\",INDEX('2023-24 Data'!$B$3:$BJ$19,MATCH($P$6,dfenums,0),MATCH($C26,'2023-24 Data'!$B$2:$BJ$2,0)))","v":""},"","",null,{"$f":"IF(ISERROR(SUM('2023-24 Data'!S$3:S$19)/SUM('2023-24 Data'!$C$3:$D$19)),\"\",SUM('2023-24 Data'!S$3:S$19)/SUM('2023-24 Data'!$C$3:$D$19))","v":92.778283979930151},9.6160295322178825E-3,9.9984710559239984E-5]
[null,"Water and sewerage","E15",{"$f":"IF(ISERROR(INDEX('2023-24 Data'!$B$3:$BJ$19,MATCH($C$4,dfenums,0),MATCH($C27,'2023-24 Data'!$B$2:$BJ$2,0))),\"\",INDEX('2023-24 Data'!$B$3:$BJ$19,MATCH($C$4,dfenums,0),MATCH($C27,'2023-24 Data'!$B$2:$BJ$2,0)))","v":""},"","",null,{"$f":"IF(ISERROR(INDEX('2023-24 Data'!$B$3:$BJ$19,MATCH($H$6,dfenums,0),MATCH($C27,'2023-24 Data'!$B$2:$BJ$2,0))),\"\",INDEX('2023-24 Data'!$B$3:$BJ$19,MATCH($H$6,dfenums,0),MATCH($C27,'2023-24 Data'!$B$2:$BJ$2,0)))","v":""},"","",null,{"$f":"IF(ISERROR(INDEX('2023-24 Data'!$B$3:$BJ$19,MATCH($L$6,dfenums,0),MATCH($C27,'2023-24 Data'!$B$2:$BJ$2,0))),\"\",INDEX('2023-24 Data'!$B$3:$BJ$19,MATCH($L$6,dfenums,0),MATCH($C27,'2023-24 Data'!$B$2:$BJ$2,0)))","v":""},"","",null,{"$f":"IF(ISERROR(INDEX('2023-24 Data'!$B$3:$BJ$19,MATCH($P$6,dfenums,0),MATCH($C27,'2023-24 Data'!$B$2:$BJ$2,0))),\"\",INDEX('2023-24 Data'!$B$3:$BJ$19,MATCH($P$6,dfenums,0),MATCH($C27,'2023-24 Data'!$B$2:$BJ$2,0)))","v":""},"","",null,{"$f":"IF(ISERROR(SUM('2023-24 Data'!T$3:T$19)/SUM('2023-24 Data'!$C$3:$D$19)),\"\",SUM('2023-24 Data'!T$3:T$19)/SUM('2023-24 Data'!$C$3:$D$19))","v":22.709822414431738},2.353765489517341E-3,2.4473776874876052E-5]
[null,"Energy","E16",{"$f":"IF(ISERROR(INDEX('2023-24 Data'!$B$3:$BJ$19,MATCH($C$4,dfenums,0),MATCH($C28,'2023-24 Data'!$B$2:$BJ$2,0))),\"\",INDEX('2023-24 Data'!$B$3:$BJ$19,MATCH($C$4,dfenums,0),MATCH($C28,'2023-24 Data'!$B$2:$BJ$2,0)))","v":""},"","",null,{"$f":"IF(ISERROR(INDEX('2023-24 Data'!$B$3:$BJ$19,MATCH($H$6,dfenums,0),MATCH($C28,'2023-24 Data'!$B$2:$BJ$2,0))),\"\",INDEX('2023-24 Data'!$B$3:$BJ$19,MATCH($H$6,dfenums,0),MATCH($C28,'2023-24 Data'!$B$2:$BJ$2,0)))","v":""},"","",null,{"$f":"IF(ISERROR(INDEX('2023-24 Data'!$B$3:$BJ$19,MATCH($L$6,dfenums,0),MATCH($C28,'2023-24 Data'!$B$2:$BJ$2,0))),\"\",INDEX('2023-24 Data'!$B$3:$BJ$19,MATCH($L$6,dfenums,0),MATCH($C28,'2023-24 Data'!$B$2:$BJ$2,0)))","v":""},"","",null,{"$f":"IF(ISERROR(INDEX('2023-24 Data'!$B$3:$BJ$19,MATCH($P$6,dfenums,0),MATCH($C28,'2023-24 Data'!$B$2:$BJ$2,0))),\"\",INDEX('2023-24 Data'!$B$3:$BJ$19,MATCH($P$6,dfenums,0),MATCH($C28,'2023-24 Data'!$B$2:$BJ$2,0)))","v":""},"","",null,{"$f":"IF(ISERROR(SUM('2023-24 Data'!U$3:U$19)/SUM('2023-24 Data'!$C$3:$D$19)),\"\",SUM('2023-24 Data'!U$3:U$19)/SUM('2023-24 Data'!$C$3:$D$19))","v":213.45042267717949},2.2123124939152305E-2,2.3002989292992195E-4]
[null,"Rates","E17",{"$f":"IF(ISERROR(INDEX('2023-24 Data'!$B$3:$BJ$19,MATCH($C$4,dfenums,0),MATCH($C29,'2023-24 Data'!$B$2:$BJ$2,0))),\"\",INDEX('2023-24 Data'!$B$3:$BJ$19,MATCH($C$4,dfenums,0),MATCH($C29,'2023-24 Data'!$B$2:$BJ$2,0)))","v":""},"","",null,{"$f":"IF(ISERROR(INDEX('2023-24 Data'!$B$3:$BJ$19,MATCH($H$6,dfenums,0),MATCH($C29,'2023-24 Data'!$B$2:$BJ$2,0))),\"\",INDEX('2023-24 Data'!$B$3:$BJ$19,MATCH($H$6,dfenums,0),MATCH($C29,'2023-24 Data'!$B$2:$BJ$2,0)))","v":""},"","",null,{"$f":"IF(ISERROR(INDEX('2023-24 Data'!$B$3:$BJ$19,MATCH($L$6,dfenums,0),MATCH($C29,'2023-24 Data'!$B$2:$BJ$2,0))),\"\",INDEX('2023-24 Data'!$B$3:$BJ$19,MATCH($L$6,dfenums,0),MATCH($C29,'2023-24 Data'!$B$2:$BJ$2,0)))","v":""},"","",null,{"$f":"IF(ISERROR(INDEX('2023-24 Data'!$B$3:$BJ$19,MATCH($P$6,dfenums,0),MATCH($C29,'2023-24 Data'!$B$2:$BJ$2,0))),\"\",INDEX('2023-24 Data'!$B$3:$BJ$19,MATCH($P$6,dfenums,0),MATCH($C29,'2023-24 Data'!$B$2:$BJ$2,0)))","v":""},"","",null,{"$f":"IF(ISERROR(SUM('2023-24 Data'!V$3:V$19)/SUM('2023-24 Data'!$C$3:$D$19)),\"\",SUM('2023-24 Data'!V$3:V$19)/SUM('2023-24 Data'!$C$3:$D$19))","v":89.810314039960588},9.3084135107827787E-3,9.6786207605029553E-5]
[null,"Other occupation costs","E18",{"$f":"IF(ISERROR(INDEX('2023-24 Data'!$B$3:$BJ$19,MATCH($C$4,dfenums,0),MATCH($C30,'2023-24 Data'!$B$2:$BJ$2,0))),\"\",INDEX('2023-24 Data'!$B$3:$BJ$19,MATCH($C$4,dfenums,0),MATCH($C30,'2023-24 Data'!$B$2:$BJ$2,0)))","v":""},"","",null,{"$f":"IF(ISERROR(INDEX('2023-24 Data'!$B$3:$BJ$19,MATCH($H$6,dfenums,0),MATCH($C30,'2023-24 Data'!$B$2:$BJ$2,0))),\"\",INDEX('2023-24 Data'!$B$3:$BJ$19,MATCH($H$6,dfenums,0),MATCH($C30,'2023-24 Data'!$B$2:$BJ$2,0)))","v":""},"","",null,{"$f":"IF(ISERROR(INDEX('2023-24 Data'!$B$3:$BJ$19,MATCH($L$6,dfenums,0),MATCH($C30,'2023-24 Data'!$B$2:$BJ$2,0))),\"\",INDEX('2023-24 Data'!$B$3:$BJ$19,MATCH($L$6,dfenums,0),MATCH($C30,'2023-24 Data'!$B$2:$BJ$2,0)))","v":""},"","",null,{"$f":"IF(ISERROR(INDEX('2023-24 Data'!$B$3:$BJ$19,MATCH($P$6,dfenums,0),MATCH($C30,'2023-24 Data'!$B$2:$BJ$2,0))),\"\",INDEX('2023-24 Data'!$B$3:$BJ$19,MATCH($P$6,dfenums,0),MATCH($C30,'2023-24 Data'!$B$2:$BJ$2,0)))","v":""},"","",null,{"$f":"IF(ISERROR(SUM('2023-24 Data'!W$3:W$19)/SUM('2023-24 Data'!$C$3:$D$19)),\"\",SUM('2023-24 Data'!W$3:W$19)/SUM('2023-24 Data'!$C$3:$D$19))","v":38.372734298001966},3.9771520922003449E-3,4.1353284061411419E-5]
[null,"Learning resources (not ICT equipment)","E19",{"$f":"IF(ISERROR(INDEX('2023-24 Data'!$B$3:$BJ$19,MATCH($C$4,dfenums,0),MATCH($C31,'2023-24 Data'!$B$2:$BJ$2,0))),\"\",INDEX('2023-24 Data'!$B$3:$BJ$19,MATCH($C$4,dfenums,0),MATCH($C31,'2023-24 Data'!$B$2:$BJ$2,0)))","v":""},"","",null,{"$f":"IF(ISERROR(INDEX('2023-24 Data'!$B$3:$BJ$19,MATCH($H$6,dfenums,0),MATCH($C31,'2023-24 Data'!$B$2:$BJ$2,0))),\"\",INDEX('2023-24 Data'!$B$3:$BJ$19,MATCH($H$6,dfenums,0),MATCH($C31,'2023-24 Data'!$B$2:$BJ$2,0)))","v":""},"","",null,{"$f":"IF(ISERROR(INDEX('2023-24 Data'!$B$3:$BJ$19,MATCH($L$6,dfenums,0),MATCH($C31,'2023-24 Data'!$B$2:$BJ$2,0))),\"\",INDEX('2023-24 Data'!$B$3:$BJ$19,MATCH($L$6,dfenums,0),MATCH($C31,'2023-24 Data'!$B$2:$BJ$2,0)))","v":""},"","",null,{"$f":"IF(ISERROR(INDEX('2023-24 Data'!$B$3:$BJ$19,MATCH($P$6,dfenums,0),MATCH($C31,'2023-24 Data'!$B$2:$BJ$2,0))),\"\",INDEX('2023-24 Data'!$B$3:$BJ$19,MATCH($P$6,dfenums,0),MATCH($C31,'2023-24 Data'!$B$2:$BJ$2,0)))","v":""},"","",null,{"$f":"IF(ISERROR(SUM('2023-24 Data'!X$3:X$19)/SUM('2023-24 Data'!$C$3:$D$19)),\"\",SUM('2023-24 Data'!X$3:X$19)/SUM('2023-24 Data'!$C$3:$D$19))","v":527.56126108771593},5.4679225019628394E-2,5.6853886199849748E-4]
[null,"ICT learning resources","E20",{"$f":"IF(ISERROR(INDEX('2023-24 Data'!$B$3:$BJ$19,MATCH($C$4,dfenums,0),MATCH($C32,'2023-24 Data'!$B$2:$BJ$2,0))),\"\",INDEX('2023-24 Data'!$B$3:$BJ$19,MATCH($C$4,dfenums,0),MATCH($C32,'2023-24 Data'!$B$2:$BJ$2,0)))","v":""},"","",null,{"$f":"IF(ISERROR(INDEX('2023-24 Data'!$B$3:$BJ$19,MATCH($H$6,dfenums,0),MATCH($C32,'2023-24 Data'!$B$2:$BJ$2,0))),\"\",INDEX('2023-24 Data'!$B$3:$BJ$19,MATCH($H$6,dfenums,0),MATCH($C32,'2023-24 Data'!$B$2:$BJ$2,0)))","v":""},"","",null,{"$f":"IF(ISERROR(INDEX('2023-24 Data'!$B$3:$BJ$19,MATCH($L$6,dfenums,0),MATCH($C32,'2023-24 Data'!$B$2:$BJ$2,0))),\"\",INDEX('2023-24 Data'!$B$3:$BJ$19,MATCH($L$6,dfenums,0),MATCH($C32,'2023-24 Data'!$B$2:$BJ$2,0)))","v":""},"","",null,{"$f":"IF(ISERROR(INDEX('2023-24 Data'!$B$3:$BJ$19,MATCH($P$6,dfenums,0),MATCH($C32,'2023-24 Data'!$B$2:$BJ$2,0))),\"\",INDEX('2023-24 Data'!$B$3:$BJ$19,MATCH($P$6,dfenums,0),MATCH($C32,'2023-24 Data'!$B$2:$BJ$2,0)))","v":""},"","",null,{"$f":"IF(ISERROR(SUM('2023-24 Data'!Y$3:Y$19)/SUM('2023-24 Data'!$C$3:$D$19)),\"\",SUM('2023-24 Data'!Y$3:Y$19)/SUM('2023-24 Data'!$C$3:$D$19))","v":137.11318430248184},1.4211131882912535E-2,1.4776326375367065E-4]
[null,"Exam fees","E21",{"$f":"IF(ISERROR(INDEX('2023-24 Data'!$B$3:$BJ$19,MATCH($C$4,dfenums,0),MATCH($C33,'2023-24 Data'!$B$2:$BJ$2,0))),\"\",INDEX('2023-24 Data'!$B$3:$BJ$19,MATCH($C$4,dfenums,0),MATCH($C33,'2023-24 Data'!$B$2:$BJ$2,0)))","v":""},"","",null,{"$f":"IF(ISERROR(INDEX('2023-24 Data'!$B$3:$BJ$19,MATCH($H$6,dfenums,0),MATCH($C33,'2023-24 Data'!$B$2:$BJ$2,0))),\"\",INDEX('2023-24 Data'!$B$3:$BJ$19,MATCH($H$6,dfenums,0),MATCH($C33,'2023-24 Data'!$B$2:$BJ$2,0)))","v":""},"","",null,{"$f":"IF(ISERROR(INDEX('2023-24 Data'!$B$3:$BJ$19,MATCH($L$6,dfenums,0),MATCH($C33,'2023-24 Data'!$B$2:$BJ$2,0))),\"\",INDEX('2023-24 Data'!$B$3:$BJ$19,MATCH($L$6,dfenums,0),MATCH($C33,'2023-24 Data'!$B$2:$BJ$2,0)))","v":""},"","",null,{"$f":"IF(ISERROR(INDEX('2023-24 Data'!$B$3:$BJ$19,MATCH($P$6,dfenums,0),MATCH($C33,'2023-24 Data'!$B$2:$BJ$2,0))),\"\",INDEX('2023-24 Data'!$B$3:$BJ$19,MATCH($P$6,dfenums,0),MATCH($C33,'2023-24 Data'!$B$2:$BJ$2,0)))","v":""},"","",null,{"$f":"IF(ISERROR(SUM('2023-24 Data'!Z$3:Z$19)/SUM('2023-24 Data'!$C$3:$D$19)),\"\",SUM('2023-24 Data'!Z$3:Z$19)/SUM('2023-24 Data'!$C$3:$D$19))","v":161.93824142101963},1.6784131427099995E-2,1.7451657330130719E-4]
[null,"Administrative supplies","E22",{"$f":"IF(ISERROR(INDEX('2023-24 Data'!$B$3:$BJ$19,MATCH($C$4,dfenums,0),MATCH($C34,'2023-24 Data'!$B$2:$BJ$2,0))),\"\",INDEX('2023-24 Data'!$B$3:$BJ$19,MATCH($C$4,dfenums,0),MATCH($C34,'2023-24 Data'!$B$2:$BJ$2,0)))","v":""},"","",null,{"$f":"IF(ISERROR(INDEX('2023-24 Data'!$B$3:$BJ$19,MATCH($H$6,dfenums,0),MATCH($C34,'2023-24 Data'!$B$2:$BJ$2,0))),\"\",INDEX('2023-24 Data'!$B$3:$BJ$19,MATCH($H$6,dfenums,0),MATCH($C34,'2023-24 Data'!$B$2:$BJ$2,0)))","v":""},"","",null,{"$f":"IF(ISERROR(INDEX('2023-24 Data'!$B$3:$BJ$19,MATCH($L$6,dfenums,0),MATCH($C34,'2023-24 Data'!$B$2:$BJ$2,0))),\"\",INDEX('2023-24 Data'!$B$3:$BJ$19,MATCH($L$6,dfenums,0),MATCH($C34,'2023-24 Data'!$B$2:$BJ$2,0)))","v":""},"","",null,{"$f":"IF(ISERROR(INDEX('2023-24 Data'!$B$3:$BJ$19,MATCH($P$6,dfenums,0),MATCH($C34,'2023-24 Data'!$B$2:$BJ$2,0))),\"\",INDEX('2023-24 Data'!$B$3:$BJ$19,MATCH($P$6,dfenums,0),MATCH($C34,'2023-24 Data'!$B$2:$BJ$2,0)))","v":""},"","",null,{"$f":"IF(ISERROR(SUM('2023-24 Data'!AA$3:AA$19)/SUM('2023-24 Data'!$C$3:$D$19)),\"\",SUM('2023-24 Data'!AA$3:AA$19)/SUM('2023-24 Data'!$C$3:$D$19))","v":76.251192993459355},7.9030748601748649E-3,8.2173900337464739E-5]
[null,"Other insurance premiums","E23",{"$f":"IF(ISERROR(INDEX('2023-24 Data'!$B$3:$BJ$19,MATCH($C$4,dfenums,0),MATCH($C35,'2023-24 Data'!$B$2:$BJ$2,0))),\"\",INDEX('2023-24 Data'!$B$3:$BJ$19,MATCH($C$4,dfenums,0),MATCH($C35,'2023-24 Data'!$B$2:$BJ$2,0)))","v":""},"","",null,{"$f":"IF(ISERROR(INDEX('2023-24 Data'!$B$3:$BJ$19,MATCH($H$6,dfenums,0),MATCH($C35,'2023-24 Data'!$B$2:$BJ$2,0))),\"\",INDEX('2023-24 Data'!$B$3:$BJ$19,MATCH($H$6,dfenums,0),MATCH($C35,'2023-24 Data'!$B$2:$BJ$2,0)))","v":""},"","",null,{"$f":"IF(ISERROR(INDEX('2023-24 Data'!$B$3:$BJ$19,MATCH($L$6,dfenums,0),MATCH($C35,'2023-24 Data'!$B$2:$BJ$2,0))),\"\",INDEX('2023-24 Data'!$B$3:$BJ$19,MATCH($L$6,dfenums,0),MATCH($C35,'2023-24 Data'!$B$2:$BJ$2,0)))","v":""},"","",null,{"$f":"IF(ISERROR(INDEX('2023-24 Data'!$B$3:$BJ$19,MATCH($P$6,dfenums,0),MATCH($C35,'2023-24 Data'!$B$2:$BJ$2,0))),\"\",INDEX('2023-24 Data'!$B$3:$BJ$19,MATCH($P$6,dfenums,0),MATCH($C35,'2023-24 Data'!$B$2:$BJ$2,0)))","v":""},"","",null,{"$f":"IF(ISERROR(SUM('2023-24 Data'!AB$3:AB$19)/SUM('2023-24 Data'!$C$3:$D$19)),\"\",SUM('2023-24 Data'!AB$3:AB$19)/SUM('2023-24 Data'!$C$3:$D$19))","v":49.579313218930366},5.1386608983137365E-3,5.3430318704676543E-5]
[null,"Special facilities","E24",{"$f":"IF(ISERROR(INDEX('2023-24 Data'!$B$3:$BJ$19,MATCH($C$4,dfenums,0),MATCH($C36,'2023-24 Data'!$B$2:$BJ$2,0))),\"\",INDEX('2023-24 Data'!$B$3:$BJ$19,MATCH($C$4,dfenums,0),MATCH($C36,'2023-24 Data'!$B$2:$BJ$2,0)))","v":""},"","",null,{"$f":"IF(ISERROR(INDEX('2023-24 Data'!$B$3:$BJ$19,MATCH($H$6,dfenums,0),MATCH($C36,'2023-24 Data'!$B$2:$BJ$2,0))),\"\",INDEX('2023-24 Data'!$B$3:$BJ$19,MATCH($H$6,dfenums,0),MATCH($C36,'2023-24 Data'!$B$2:$BJ$2,0)))","v":""},"","",null,{"$f":"IF(ISERROR(INDEX('2023-24 Data'!$B$3:$BJ$19,MATCH($L$6,dfenums,0),MATCH($C36,'2023-24 Data'!$B$2:$BJ$2,0))),\"\",INDEX('2023-24 Data'!$B$3:$BJ$19,MATCH($L$6,dfenums,0),MATCH($C36,'2023-24 Data'!$B$2:$BJ$2,0)))","v":""},"","",null,{"$f":"IF(ISERROR(INDEX('2023-24 Data'!$B$3:$BJ$19,MATCH($P$6,dfenums,0),MATCH($C36,'2023-24 Data'!$B$2:$BJ$2,0))),\"\",INDEX('2023-24 Data'!$B$3:$BJ$19,MATCH($P$6,dfenums,0),MATCH($C36,'2023-24 Data'!$B$2:$BJ$2,0)))","v":""},"","",null,{"$f":"IF(ISERROR(SUM('2023-24 Data'!AC$3:AC$19)/SUM('2023-24 Data'!$C$3:$D$19)),\"\",SUM('2023-24 Data'!AC$3:AC$19)/SUM('2023-24 Data'!$C$3:$D$19))","v":324.80959313988416},3.3664975315306024E-2,3.5003873496928487E-4]
[null,"Catering supplies","E25",{"$f":"IF(ISERROR(INDEX('2023-24 Data'!$B$3:$BJ$19,MATCH($C$4,dfenums,0),MATCH($C37,'2023-24 Data'!$B$2:$BJ$2,0))),\"\",INDEX('2023-24 Data'!$B$3:$BJ$19,MATCH($C$4,dfenums,0),MATCH($C37,'2023-24 Data'!$B$2:$BJ$2,0)))","v":""},"","",null,{"$f":"IF(ISERROR(INDEX('2023-24 Data'!$B$3:$BJ$19,MATCH($H$6,dfenums,0),MATCH($C37,'2023-24 Data'!$B$2:$BJ$2,0))),\"\",INDEX('2023-24 Data'!$B$3:$BJ$19,MATCH($H$6,dfenums,0),MATCH($C37,'2023-24 Data'!$B$2:$BJ$2,0)))","v":""},"","",null,{"$f":"IF(ISERROR(INDEX('2023-24 Data'!$B$3:$BJ$19,MATCH($L$6,dfenums,0),MATCH($C37,'2023-24 Data'!$B$2:$BJ$2,0))),\"\",INDEX('2023-24 Data'!$B$3:$BJ$19,MATCH($L$6,dfenums,0),MATCH($C37,'2023-24 Data'!$B$2:$BJ$2,0)))","v":""},"","",null,{"$f":"IF(ISERROR(INDEX('2023-24 Data'!$B$3:$BJ$19,MATCH($P$6,dfenums,0),MATCH($C37,'2023-24 Data'!$B$2:$BJ$2,0))),\"\",INDEX('2023-24 Data'!$B$3:$BJ$19,MATCH($P$6,dfenums,0),MATCH($C37,'2023-24 Data'!$B$2:$BJ$2,0)))","v":""},"","",null,{"$f":"IF(ISERROR(SUM('2023-24 Data'!AD$3:AD$19)/SUM('2023-24 Data'!$C$3:$D$19)),\"\",SUM('2023-24 Data'!AD$3:AD$19)/SUM('2023-24 Data'!$C$3:$D$19))","v":141.41499104022941},1.4656993768448409E-2,1.5239920745843374E-4]
[null,"Agency supply teaching staff","E26",{"$f":"IF(ISERROR(INDEX('2023-24 Data'!$B$3:$BJ$19,MATCH($C$4,dfenums,0),MATCH($C38,'2023-24 Data'!$B$2:$BJ$2,0))),\"\",INDEX('2023-24 Data'!$B$3:$BJ$19,MATCH($C$4,dfenums,0),MATCH($C38,'2023-24 Data'!$B$2:$BJ$2,0)))","v":""},"","",null,{"$f":"IF(ISERROR(INDEX('2023-24 Data'!$B$3:$BJ$19,MATCH($H$6,dfenums,0),MATCH($C38,'2023-24 Data'!$B$2:$BJ$2,0))),\"\",INDEX('2023-24 Data'!$B$3:$BJ$19,MATCH($H$6,dfenums,0),MATCH($C38,'2023-24 Data'!$B$2:$BJ$2,0)))","v":""},"","",null,{"$f":"IF(ISERROR(INDEX('2023-24 Data'!$B$3:$BJ$19,MATCH($L$6,dfenums,0),MATCH($C38,'2023-24 Data'!$B$2:$BJ$2,0))),\"\",INDEX('2023-24 Data'!$B$3:$BJ$19,MATCH($L$6,dfenums,0),MATCH($C38,'2023-24 Data'!$B$2:$BJ$2,0)))","v":""},"","",null,{"$f":"IF(ISERROR(INDEX('2023-24 Data'!$B$3:$BJ$19,MATCH($P$6,dfenums,0),MATCH($C38,'2023-24 Data'!$B$2:$BJ$2,0))),\"\",INDEX('2023-24 Data'!$B$3:$BJ$19,MATCH($P$6,dfenums,0),MATCH($C38,'2023-24 Data'!$B$2:$BJ$2,0)))","v":""},"","",null,{"$f":"IF(ISERROR(SUM('2023-24 Data'!AE$3:AE$19)/SUM('2023-24 Data'!$C$3:$D$19)),\"\",SUM('2023-24 Data'!AE$3:AE$19)/SUM('2023-24 Data'!$C$3:$D$19))","v":100.07636658901532},1.0372441214855921E-2,1.078496617741671E-4]
[null,"Bought in professional services - curriculum","E27",{"$f":"IF(ISERROR(INDEX('2023-24 Data'!$B$3:$BJ$19,MATCH($C$4,dfenums,0),MATCH($C39,'2023-24 Data'!$B$2:$BJ$2,0))),\"\",INDEX('2023-24 Data'!$B$3:$BJ$19,MATCH($C$4,dfenums,0),MATCH($C39,'2023-24 Data'!$B$2:$BJ$2,0)))","v":""},"","",null,{"$f":"IF(ISERROR(INDEX('2023-24 Data'!$B$3:$BJ$19,MATCH($H$6,dfenums,0),MATCH($C39,'2023-24 Data'!$B$2:$BJ$2,0))),\"\",INDEX('2023-24 Data'!$B$3:$BJ$19,MATCH($H$6,dfenums,0),MATCH($C39,'2023-24 Data'!$B$2:$BJ$2,0)))","v":""},"","",null,{"$f":"IF(ISERROR(INDEX('2023-24 Data'!$B$3:$BJ$19,MATCH($L$6,dfenums,0),MATCH($C39,'2023-24 Data'!$B$2:$BJ$2,0))),\"\",INDEX('2023-24 Data'!$B$3:$BJ$19,MATCH($L$6,dfenums,0),MATCH($C39,'2023-24 Data'!$B$2:$BJ$2,0)))","v":""},"","",null,{"$f":"IF(ISERROR(INDEX('2023-24 Data'!$B$3:$BJ$19,MATCH($P$6,dfenums,0),MATCH($C39,'2023-24 Data'!$B$2:$BJ$2,0))),\"\",INDEX('2023-24 Data'!$B$3:$BJ$19,MATCH($P$6,dfenums,0),MATCH($C39,'2023-24 Data'!$B$2:$BJ$2,0)))","v":""},"","",null,{"$f":"IF(ISERROR(SUM('2023-24 Data'!AF$3:AF$19)/SUM('2023-24 Data'!$C$3:$D$19)),\"\",SUM('2023-24 Data'!AF$3:AF$19)/SUM('2023-24 Data'!$C$3:$D$19))","v":127.08047173192365},1.317128876199848E-2,1.3695127392738431E-4]
[null,"Bought in professional services other","E28",{"$f":"IF(ISERROR(INDEX('2023-24 Data'!$B$3:$BJ$19,MATCH($C$4,dfenums,0),MATCH($C40,'2023-24 Data'!$B$2:$BJ$2,0))),\"\",INDEX('2023-24 Data'!$B$3:$BJ$19,MATCH($C$4,dfenums,0),MATCH($C40,'2023-24 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('2023-24 Data'!$B$3:$BJ$19,MATCH($H$6,dfenums,0),MATCH($C40,'2023-24 Data'!$B$2:$BJ$2,0))),\"\",INDEX('2023-24 Data'!$B$3:$BJ$19,MATCH($H$6,dfenums,0),MATCH($C40,'2023-24 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('2023-24 Data'!$B$3:$BJ$19,MATCH($L$6,dfenums,0),MATCH($C40,'2023-24 Data'!$B$2:$BJ$2,0))),\"\",INDEX('2023-24 Data'!$B$3:$BJ$19,MATCH($L$6,dfenums,0),MATCH($C40,'2023-24 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('2023-24 Data'!$B$3:$BJ$19,MATCH($P$6,dfenums,0),MATCH($C40,'2023-24 Data'!$B$2:$BJ$2,0))),\"\",INDEX('2023-24 Data'!$B$3:$BJ$19,MATCH($P$6,dfenums,0),MATCH($C40,'2023-24 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('2023-24 Data'!AG$3:AG$19)/SUM('2023-24 Data'!$C$3:$D$19)),\"\",SUM('2023-24 Data'!AG$3:AG$19)/SUM('2023-24 Data'!$C$3:$D$19))","v":196.48016383302854},{"$f":"IF(ISERROR(T40/$T$46),\"\",T40/$T$46)","v":2.0364238018479815E-2},{"$f":"IF(ISERROR(T40/-$T$72),\"\",T40/-$T$72)","v":2.1174149239198078E-4}]
[null,"Bought in professional services other","E28b",{"$f":"IF(ISERROR(INDEX('2023-24 Data'!$B$3:$BJ$19,MATCH($C$4,dfenums,0),MATCH($C41,'2023-24 Data'!$B$2:$BJ$2,0))),\"\",INDEX('2023-24 Data'!$B$3:$BJ$19,MATCH($C$4,dfenums,0),MATCH($C41,'2023-24 Data'!$B$2:$BJ$2,0)))","v":""},"","",null,{"$f":"IF(ISERROR(INDEX('2023-24 Data'!$B$3:$BJ$19,MATCH($H$6,dfenums,0),MATCH($C41,'2023-24 Data'!$B$2:$BJ$2,0))),\"\",INDEX('2023-24 Data'!$B$3:$BJ$19,MATCH($H$6,dfenums,0),MATCH($C41,'2023-24 Data'!$B$2:$BJ$2,0)))","v":""},"","",null,{"$f":"IF(ISERROR(INDEX('2023-24 Data'!$B$3:$BJ$19,MATCH($L$6,dfenums,0),MATCH($C41,'2023-24 Data'!$B$2:$BJ$2,0))),\"\",INDEX('2023-24 Data'!$B$3:$BJ$19,MATCH($L$6,dfenums,0),MATCH($C41,'2023-24 Data'!$B$2:$BJ$2,0)))","v":""},"","",null,{"$f":"IF(ISERROR(INDEX('2023-24 Data'!$B$3:$BJ$19,MATCH($P$6,dfenums,0),MATCH($C41,'2023-24 Data'!$B$2:$BJ$2,0))),\"\",INDEX('2023-24 Data'!$B$3:$BJ$19,MATCH($P$6,dfenums,0),MATCH($C41,'2023-24 Data'!$B$2:$BJ$2,0)))","v":""},"","",null,{"$f":"IF(ISERROR(SUM('2023-24 Data'!AH$3:AH$19)/SUM('2023-24 Data'!$C$3:$D$19)),\"\",SUM('2023-24 Data'!AH$3:AH$19)/SUM('2023-24 Data'!$C$3:$D$19))","v":0},0,0]
[null,"Loan interest","E29",{"$f":"IF(ISERROR(INDEX('2023-24 Data'!$B$3:$BJ$19,MATCH($C$4,dfenums,0),MATCH($C42,'2023-24 Data'!$B$2:$BJ$2,0))),\"\",INDEX('2023-24 Data'!$B$3:$BJ$19,MATCH($C$4,dfenums,0),MATCH($C42,'2023-24 Data'!$B$2:$BJ$2,0)))","v":""},"","",null,{"$f":"IF(ISERROR(INDEX('2023-24 Data'!$B$3:$BJ$19,MATCH($H$6,dfenums,0),MATCH($C42,'2023-24 Data'!$B$2:$BJ$2,0))),\"\",INDEX('2023-24 Data'!$B$3:$BJ$19,MATCH($H$6,dfenums,0),MATCH($C42,'2023-24 Data'!$B$2:$BJ$2,0)))","v":""},"","",null,{"$f":"IF(ISERROR(INDEX('2023-24 Data'!$B$3:$BJ$19,MATCH($L$6,dfenums,0),MATCH($C42,'2023-24 Data'!$B$2:$BJ$2,0))),\"\",INDEX('2023-24 Data'!$B$3:$BJ$19,MATCH($L$6,dfenums,0),MATCH($C42,'2023-24 Data'!$B$2:$BJ$2,0)))","v":""},"","",null,{"$f":"IF(ISERROR(INDEX('2023-24 Data'!$B$3:$BJ$19,MATCH($P$6,dfenums,0),MATCH($C42,'2023-24 Data'!$B$2:$BJ$2,0))),\"\",INDEX('2023-24 Data'!$B$3:$BJ$19,MATCH($P$6,dfenums,0),MATCH($C42,'2023-24 Data'!$B$2:$BJ$2,0)))","v":""},"","",null,{"$f":"IF(ISERROR(SUM('2023-24 Data'!AI$3:AI$19)/SUM('2023-24 Data'!$C$3:$D$19)),\"\",SUM('2023-24 Data'!AI$3:AI$19)/SUM('2023-24 Data'!$C$3:$D$19))","v":8.948996505689454},9.2752108565663516E-4,9.6440975951933501E-6]
[null,"Direct revenue financing (rev contrib. to cap)","E30",{"$f":"IF(ISERROR(INDEX('2023-24 Data'!$B$3:$BJ$19,MATCH($C$4,dfenums,0),MATCH($C43,'2023-24 Data'!$B$2:$BJ$2,0))),\"\",INDEX('2023-24 Data'!$B$3:$BJ$19,MATCH($C$4,dfenums,0),MATCH($C43,'2023-24 Data'!$B$2:$BJ$2,0)))","v":""},"","",null,{"$f":"IF(ISERROR(INDEX('2023-24 Data'!$B$3:$BJ$19,MATCH($H$6,dfenums,0),MATCH($C43,'2023-24 Data'!$B$2:$BJ$2,0))),\"\",INDEX('2023-24 Data'!$B$3:$BJ$19,MATCH($H$6,dfenums,0),MATCH($C43,'2023-24 Data'!$B$2:$BJ$2,0)))","v":""},"","",null,{"$f":"IF(ISERROR(INDEX('2023-24 Data'!$B$3:$BJ$19,MATCH($L$6,dfenums,0),MATCH($C43,'2023-24 Data'!$B$2:$BJ$2,0))),\"\",INDEX('2023-24 Data'!$B$3:$BJ$19,MATCH($L$6,dfenums,0),MATCH($C43,'2023-24 Data'!$B$2:$BJ$2,0)))","v":""},"","",null,{"$f":"IF(ISERROR(INDEX('2023-24 Data'!$B$3:$BJ$19,MATCH($P$6,dfenums,0),MATCH($C43,'2023-24 Data'!$B$2:$BJ$2,0))),\"\",INDEX('2023-24 Data'!$B$3:$BJ$19,MATCH($P$6,dfenums,0),MATCH($C43,'2023-24 Data'!$B$2:$BJ$2,0)))","v":""},"","",null,{"$f":"IF(ISERROR(SUM('2023-24 Data'!AJ$3:AJ$19)/SUM('2023-24 Data'!$C$3:$D$19)),\"\",SUM('2023-24 Data'!AJ$3:AJ$19)/SUM('2023-24 Data'!$C$3:$D$19))","v":115.81427224263058},1.2003600566468419E-2,1.2480998776948017E-4]
[null,"Community focussed extended school staff","E31",{"$f":"IF(ISERROR(INDEX('2023-24 Data'!$B$3:$BJ$19,MATCH($C$4,dfenums,0),MATCH($C44,'2023-24 Data'!$B$2:$BJ$2,0))),\"\",INDEX('2023-24 Data'!$B$3:$BJ$19,MATCH($C$4,dfenums,0),MATCH($C44,'2023-24 Data'!$B$2:$BJ$2,0)))","v":""},"","",null,{"$f":"IF(ISERROR(INDEX('2023-24 Data'!$B$3:$BJ$19,MATCH($H$6,dfenums,0),MATCH($C44,'2023-24 Data'!$B$2:$BJ$2,0))),\"\",INDEX('2023-24 Data'!$B$3:$BJ$19,MATCH($H$6,dfenums,0),MATCH($C44,'2023-24 Data'!$B$2:$BJ$2,0)))","v":""},"","",null,{"$f":"IF(ISERROR(INDEX('2023-24 Data'!$B$3:$BJ$19,MATCH($L$6,dfenums,0),MATCH($C44,'2023-24 Data'!$B$2:$BJ$2,0))),\"\",INDEX('2023-24 Data'!$B$3:$BJ$19,MATCH($L$6,dfenums,0),MATCH($C44,'2023-24 Data'!$B$2:$BJ$2,0)))","v":""},"","",null,{"$f":"IF(ISERROR(INDEX('2023-24 Data'!$B$3:$BJ$19,MATCH($P$6,dfenums,0),MATCH($C44,'2023-24 Data'!$B$2:$BJ$2,0))),\"\",INDEX('2023-24 Data'!$B$3:$BJ$19,MATCH($P$6,dfenums,0),MATCH($C44,'2023-24 Data'!$B$2:$BJ$2,0)))","v":""},"","",null,{"$f":"IF(ISERROR(SUM('2023-24 Data'!AK$3:AK$19)/SUM('2023-24 Data'!$C$3:$D$19)),\"\",SUM('2023-24 Data'!AK$3:AK$19)/SUM('2023-24 Data'!$C$3:$D$19))","v":0},0,0]
[null,"Community focussed extended school costs","E32",{"$f":"IF(ISERROR(INDEX('2023-24 Data'!$B$3:$BJ$19,MATCH($C$4,dfenums,0),MATCH($C45,'2023-24 Data'!$B$2:$BJ$2,0))),\"\",INDEX('2023-24 Data'!$B$3:$BJ$19,MATCH($C$4,dfenums,0),MATCH($C45,'2023-24 Data'!$B$2:$BJ$2,0)))","v":""},"","",null,{"$f":"IF(ISERROR(INDEX('2023-24 Data'!$B$3:$BJ$19,MATCH($H$6,dfenums,0),MATCH($C45,'2023-24 Data'!$B$2:$BJ$2,0))),\"\",INDEX('2023-24 Data'!$B$3:$BJ$19,MATCH($H$6,dfenums,0),MATCH($C45,'2023-24 Data'!$B$2:$BJ$2,0)))","v":""},"","",null,{"$f":"IF(ISERROR(INDEX('2023-24 Data'!$B$3:$BJ$19,MATCH($L$6,dfenums,0),MATCH($C45,'2023-24 Data'!$B$2:$BJ$2,0))),\"\",INDEX('2023-24 Data'!$B$3:$BJ$19,MATCH($L$6,dfenums,0),MATCH($C45,'2023-24 Data'!$B$2:$BJ$2,0)))","v":""},"","",null,{"$f":"IF(ISERROR(INDEX('2023-24 Data'!$B$3:$BJ$19,MATCH($P$6,dfenums,0),MATCH($C45,'2023-24 Data'!$B$2:$BJ$2,0))),\"\",INDEX('2023-24 Data'!$B$3:$BJ$19,MATCH($P$6,dfenums,0),MATCH($C45,'2023-24 Data'!$B$2:$BJ$2,0)))","v":""},"","",null,{"$f":"IF(ISERROR(SUM('2023-24 Data'!AL$3:AL$19)/SUM('2023-24 Data'!$C$3:$D$19)),\"\",SUM('2023-24 Data'!AL$3:AL$19)/SUM('2023-24 Data'!$C$3:$D$19))","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":9648.2944097751097},{"$f":"IF(ISERROR(SUM(U13:U45)),\"\",SUM(U13:U45))","v":1.0000000000000002},{"$f":"IF(ISERROR(SUM(V13:V45)),\"\",SUM(V13:V45))","v":1.0397712509539173E-2}]
[]
[null,"INCOME"]
[null,"Funds delegated by the LEA","I01",{"$f":"IF(ISERROR(INDEX('2023-24 Data'!$B$3:$BJ$19,MATCH($C$4,dfenums,0),MATCH(\"I01 OTHER\",'2023-24 Data'!$B$2:$BJ$2,0))),\"\",INDEX('2023-24 Data'!$B$3:$BJ$19,MATCH($C$4,dfenums,0),MATCH(\"I01 OTHER\",'2023-24 Data'!$B$2:$BJ$2,0)))","v":""},{"$f":"IF(C4>0,D49/(E4-VLOOKUP(C4,'2023-24 Data'!A3:E19,5,0)))","v":false},{"$f":"IF($C$4>0,D49/$D$72)","v":false},null,{"$f":"IF(ISERROR(INDEX('2023-24 Data'!$B$3:$BJ$19,MATCH($H$6,dfenums,0),MATCH(\"I01 OTHER\",'2023-24 Data'!$B$2:$BJ$2,0))),\"\",INDEX('2023-24 Data'!$B$3:$BJ$19,MATCH($H$6,dfenums,0),MATCH(\"I01 OTHER\",'2023-24 Data'!$B$2:$BJ$2,0)))","v":""},{"$f":"IF(H6>0,H49/(I6-VLOOKUP(H6,'2023-24 Data'!A3:E19,5,0)))","v":false},{"$f":"IF($H$6>0,H49/$H$72)","v":false},null,{"$f":"IF(ISERROR(INDEX('2023-24 Data'!$B$3:$BJ$19,MATCH($L$6,dfenums,0),MATCH(\"I01 OTHER\",'2023-24 Data'!$B$2:$BJ$2,0))),\"\",INDEX('2023-24 Data'!$B$3:$BJ$19,MATCH($L$6,dfenums,0),MATCH(\"I01 OTHER\",'2023-24 Data'!$B$2:$BJ$2,0)))","v":""},{"$f":"IF(L6>0,L49/(M6-VLOOKUP(L6,'2023-24 Data'!A3:E19,5,0)))","v":false},{"$f":"IF($L$6>0,L49/$L$72)","v":false},null,{"$f":"IF(ISERROR(INDEX('2023-24 Data'!$B$3:$BJ$19,MATCH($P$6,dfenums,0),MATCH(\"I01 OTHER\",'2023-24 Data'!$B$2:$BJ$2,0))),\"\",INDEX('2023-24 Data'!$B$3:$BJ$19,MATCH($P$6,dfenums,0),MATCH(\"I01 OTHER\",'2023-24 Data'!$B$2:$BJ$2,0)))","v":""},{"$f":"IF(P6>0,P49/(Q6-VLOOKUP(P6,'2023-24 Data'!A3:E19,5,0)))","v":false},{"$f":"IF($P$6>0,P49/$P$72)","v":false},null,{"$f":"IF(ISERROR(SUM('2023-24 Data'!AM$3:AM$19)/SUM('2023-24 Data'!$C$3:$D$19)),\"\",SUM('2023-24 Data'!AM$3:AM$19)/SUM('2023-24 Data'!$C$3:$D$19))","v":-5970.5287993907359},{"$f":"IF(ISERROR(T49/$T$72),\"\",T49/$T$72)","v":6.4342814749820598E-3}]
[null,"Funding for sixth form students","I02",{"$f":"IF(ISERROR(INDEX('2023-24 Data'!$B$3:$BJ$19,MATCH($C$4,dfenums,0),MATCH($C50,'2023-24 Data'!$B$2:$BJ$2,0))),\"\",INDEX('2023-24 Data'!$B$3:$BJ$19,MATCH($C$4,dfenums,0),MATCH($C50,'2023-24 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('2023-24 Data'!$B$3:$BJ$19,MATCH($H$6,dfenums,0),MATCH($C50,'2023-24 Data'!$B$2:$BJ$2,0))),\"\",INDEX('2023-24 Data'!$B$3:$BJ$19,MATCH($H$6,dfenums,0),MATCH($C50,'2023-24 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('2023-24 Data'!$B$3:$BJ$19,MATCH($L$6,dfenums,0),MATCH($C50,'2023-24 Data'!$B$2:$BJ$2,0))),\"\",INDEX('2023-24 Data'!$B$3:$BJ$19,MATCH($L$6,dfenums,0),MATCH($C50,'2023-24 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('2023-24 Data'!$B$3:$BJ$19,MATCH($P$6,dfenums,0),MATCH($C50,'2023-24 Data'!$B$2:$BJ$2,0))),\"\",INDEX('2023-24 Data'!$B$3:$BJ$19,MATCH($P$6,dfenums,0),MATCH($C50,'2023-24 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('2023-24 Data'!AQ$3:AQ$19)/SUM('2023-24 Data'!$D$3:$D$19)),\"\",SUM('2023-24 Data'!AQ$3:AQ$19)/SUM('2023-24 Data'!$D$3:$D$19))","v":-920032.83828947356},{"$f":"IF(ISERROR(T50/$T$72),\"\",T50/$T$72)","v":0.99149513329291827}]
[null,"Notional SEN budget","I01",{"$f":"IF(ISERROR(INDEX('2023-24 Data'!$B$3:$BJ$19,MATCH($C$4,dfenums,0),MATCH($B51,'2023-24 Data'!$B$2:$BJ$2,0))),\"\",INDEX('2023-24 Data'!$B$3:$BJ$19,MATCH($C$4,dfenums,0),MATCH($B51,'2023-24 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('2023-24 Data'!$B$3:$BJ$19,MATCH($H$6,dfenums,0),MATCH($B51,'2023-24 Data'!$B$2:$BJ$2,0))),\"\",INDEX('2023-24 Data'!$B$3:$BJ$19,MATCH($H$6,dfenums,0),MATCH($B51,'2023-24 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('2023-24 Data'!$B$3:$BJ$19,MATCH($L$6,dfenums,0),MATCH($B51,'2023-24 Data'!$B$2:$BJ$2,0))),\"\",INDEX('2023-24 Data'!$B$3:$BJ$19,MATCH($L$6,dfenums,0),MATCH($B51,'2023-24 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('2023-24 Data'!$B$3:$BJ$19,MATCH($P$6,dfenums,0),MATCH($B51,'2023-24 Data'!$B$2:$BJ$2,0))),\"\",INDEX('2023-24 Data'!$B$3:$BJ$19,MATCH($P$6,dfenums,0),MATCH($B51,'2023-24 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('2023-24 Data'!AN$3:AN$19)/SUM('2023-24 Data'!$C$3:$D$19)),\"\",SUM('2023-24 Data'!AN$3:AN$19)/SUM('2023-24 Data'!$C$3:$D$19))","v":-867.87416091748048},9.3528510184504585E-4]
[null,"SRP Funding","I01 & I03",{"$f":"IF(ISERROR(INDEX('2023-24 Data'!$B$3:$BJ$19,MATCH($C$4,dfenums,0),MATCH(\"Unit Funding\",'2023-24 Data'!$B$2:$BJ$2,0))),\"\",INDEX('2023-24 Data'!$B$3:$BJ$19,MATCH($C$4,dfenums,0),MATCH(\"Unit Funding\",'2023-24 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('2023-24 Data'!$B$3:$BJ$19,MATCH($C$4,dfenums,0),MATCH(\"HNP Funding\",'2023-24 Data'!$B$2:$BJ$2,0))),\"\",INDEX('2023-24 Data'!$B$3:$BJ$19,MATCH($C$4,dfenums,0),MATCH(\"HNP Funding\",'2023-24 Data'!$B$2:$BJ$2,0)))","v":""}]
[null,"Funding for minority ethnic pupils","I04",{"$f":"IF(ISERROR(INDEX('2023-24 Data'!$B$3:$BJ$19,MATCH($C$4,dfenums,0),MATCH($C54,'2023-24 Data'!$B$2:$BJ$2,0))),\"\",INDEX('2023-24 Data'!$B$3:$BJ$19,MATCH($C$4,dfenums,0),MATCH($C54,'2023-24 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('2023-24 Data'!$B$3:$BJ$19,MATCH($H$6,dfenums,0),MATCH($C54,'2023-24 Data'!$B$2:$BJ$2,0))),\"\",INDEX('2023-24 Data'!$B$3:$BJ$19,MATCH($H$6,dfenums,0),MATCH($C54,'2023-24 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('2023-24 Data'!$B$3:$BJ$19,MATCH($L$6,dfenums,0),MATCH($C54,'2023-24 Data'!$B$2:$BJ$2,0))),\"\",INDEX('2023-24 Data'!$B$3:$BJ$19,MATCH($L$6,dfenums,0),MATCH($C54,'2023-24 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('2023-24 Data'!$B$3:$BJ$19,MATCH($P$6,dfenums,0),MATCH($C54,'2023-24 Data'!$B$2:$BJ$2,0))),\"\",INDEX('2023-24 Data'!$B$3:$BJ$19,MATCH($P$6,dfenums,0),MATCH($C54,'2023-24 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('2023-24 Data'!AR$3:AR$19)/SUM('2023-24 Data'!$C$3:$D$19)),\"\",SUM('2023-24 Data'!AR$3:AR$19)/SUM('2023-24 Data'!$C$3:$D$19))","v":-3.9310993638562852},4.2364421415663162E-6]
[null,"Pupil Premium","I05",{"$f":"IF(ISERROR(INDEX('2023-24 Data'!$B$3:$BJ$19,MATCH($C$4,dfenums,0),MATCH($C55,'2023-24 Data'!$B$2:$BJ$2,0))),\"\",INDEX('2023-24 Data'!$B$3:$BJ$19,MATCH($C$4,dfenums,0),MATCH($C55,'2023-24 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('2023-24 Data'!$B$3:$BJ$19,MATCH($H$6,dfenums,0),MATCH($C55,'2023-24 Data'!$B$2:$BJ$2,0))),\"\",INDEX('2023-24 Data'!$B$3:$BJ$19,MATCH($H$6,dfenums,0),MATCH($C55,'2023-24 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('2023-24 Data'!$B$3:$BJ$19,MATCH($L$6,dfenums,0),MATCH($C55,'2023-24 Data'!$B$2:$BJ$2,0))),\"\",INDEX('2023-24 Data'!$B$3:$BJ$19,MATCH($L$6,dfenums,0),MATCH($C55,'2023-24 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('2023-24 Data'!$B$3:$BJ$19,MATCH($P$6,dfenums,0),MATCH($C55,'2023-24 Data'!$B$2:$BJ$2,0))),\"\",INDEX('2023-24 Data'!$B$3:$BJ$19,MATCH($P$6,dfenums,0),MATCH($C55,'2023-24 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('2023-24 Data'!AS$3:AS$19)/SUM('2023-24 Data'!$C$3:$D$19)),\"\",SUM('2023-24 Data'!AS$3:AS$19)/SUM('2023-24 Data'!$C$3:$D$19))","v":-234.62163515813995},2.5284555044472259E-4]
[null,"Other government grants","I06",{"$f":"IF(ISERROR(INDEX('2023-24 Data'!$B$3:$BJ$19,MATCH($C$4,dfenums,0),MATCH($C56,'2023-24 Data'!$B$2:$BJ$2,0))),\"\",INDEX('2023-24 Data'!$B$3:$BJ$19,MATCH($C$4,dfenums,0),MATCH($C56,'2023-24 Data'!$B$2:$BJ$2,0)))","v":""},"","",null,{"$f":"IF(ISERROR(INDEX('2023-24 Data'!$B$3:$BJ$19,MATCH($H$6,dfenums,0),MATCH($C56,'2023-24 Data'!$B$2:$BJ$2,0))),\"\",INDEX('2023-24 Data'!$B$3:$BJ$19,MATCH($H$6,dfenums,0),MATCH($C56,'2023-24 Data'!$B$2:$BJ$2,0)))","v":""},"","",null,{"$f":"IF(ISERROR(INDEX('2023-24 Data'!$B$3:$BJ$19,MATCH($L$6,dfenums,0),MATCH($C56,'2023-24 Data'!$B$2:$BJ$2,0))),\"\",INDEX('2023-24 Data'!$B$3:$BJ$19,MATCH($L$6,dfenums,0),MATCH($C56,'2023-24 Data'!$B$2:$BJ$2,0)))","v":""},"","",null,{"$f":"IF(ISERROR(INDEX('2023-24 Data'!$B$3:$BJ$19,MATCH($P$6,dfenums,0),MATCH($C56,'2023-24 Data'!$B$2:$BJ$2,0))),\"\",INDEX('2023-24 Data'!$B$3:$BJ$19,MATCH($P$6,dfenums,0),MATCH($C56,'2023-24 Data'!$B$2:$BJ$2,0)))","v":""},"","",null,{"$f":"IF(ISERROR(SUM('2023-24 Data'!AT$3:AT$19)/SUM('2023-24 Data'!$C$3:$D$19)),\"\",SUM('2023-24 Data'!AT$3:AT$19)/SUM('2023-24 Data'!$C$3:$D$19))","v":-97.616865200250857},1.0519912197189117E-4]
[null,"Other grants and payments","I07",{"$f":"IF(ISERROR(INDEX('2023-24 Data'!$B$3:$BJ$19,MATCH($C$4,dfenums,0),MATCH($C57,'2023-24 Data'!$B$2:$BJ$2,0))),\"\",INDEX('2023-24 Data'!$B$3:$BJ$19,MATCH($C$4,dfenums,0),MATCH($C57,'2023-24 Data'!$B$2:$BJ$2,0)))","v":""},"","",null,{"$f":"IF(ISERROR(INDEX('2023-24 Data'!$B$3:$BJ$19,MATCH($H$6,dfenums,0),MATCH($C57,'2023-24 Data'!$B$2:$BJ$2,0))),\"\",INDEX('2023-24 Data'!$B$3:$BJ$19,MATCH($H$6,dfenums,0),MATCH($C57,'2023-24 Data'!$B$2:$BJ$2,0)))","v":""},"","",null,{"$f":"IF(ISERROR(INDEX('2023-24 Data'!$B$3:$BJ$19,MATCH($L$6,dfenums,0),MATCH($C57,'2023-24 Data'!$B$2:$BJ$2,0))),\"\",INDEX('2023-24 Data'!$B$3:$BJ$19,MATCH($L$6,dfenums,0),MATCH($C57,'2023-24 Data'!$B$2:$BJ$2,0)))","v":""},"","",null,{"$f":"IF(ISERROR(INDEX('2023-24 Data'!$B$3:$BJ$19,MATCH($P$6,dfenums,0),MATCH($C57,'2023-24 Data'!$B$2:$BJ$2,0))),\"\",INDEX('2023-24 Data'!$B$3:$BJ$19,MATCH($P$6,dfenums,0),MATCH($C57,'2023-24 Data'!$B$2:$BJ$2,0)))","v":""},"","",null,{"$f":"IF(ISERROR(SUM('2023-24 Data'!AU$3:AU$19)/SUM('2023-24 Data'!$C$3:$D$19)),\"\",SUM('2023-24 Data'!AU$3:AU$19)/SUM('2023-24 Data'!$C$3:$D$19))","v":-91.338911611862756},9.8433536907016389E-5]
[null,"Income from facilities and services","I08",{"$f":"IF(ISERROR(INDEX('2023-24 Data'!$B$3:$BJ$19,MATCH($C$4,dfenums,0),MATCH($C58,'2023-24 Data'!$B$2:$BJ$2,0))),\"\",INDEX('2023-24 Data'!$B$3:$BJ$19,MATCH($C$4,dfenums,0),MATCH($C58,'2023-24 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('2023-24 Data'!$B$3:$BJ$19,MATCH($H$6,dfenums,0),MATCH($C58,'2023-24 Data'!$B$2:$BJ$2,0))),\"\",INDEX('2023-24 Data'!$B$3:$BJ$19,MATCH($H$6,dfenums,0),MATCH($C58,'2023-24 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('2023-24 Data'!$B$3:$BJ$19,MATCH($L$6,dfenums,0),MATCH($C58,'2023-24 Data'!$B$2:$BJ$2,0))),\"\",INDEX('2023-24 Data'!$B$3:$BJ$19,MATCH($L$6,dfenums,0),MATCH($C58,'2023-24 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('2023-24 Data'!$B$3:$BJ$19,MATCH($P$6,dfenums,0),MATCH($C58,'2023-24 Data'!$B$2:$BJ$2,0))),\"\",INDEX('2023-24 Data'!$B$3:$BJ$19,MATCH($P$6,dfenums,0),MATCH($C58,'2023-24 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('2023-24 Data'!AW$3:AW$19)/SUM('2023-24 Data'!$C$3:$D$19)),\"\",SUM('2023-24 Data'!AW$3:AW$19)/SUM('2023-24 Data'!$C$3:$D$19))","v":-72.262276901711317},{"$f":"IF(ISERROR(T58/$T$72),\"\",T58/$T$72)","v":7.7875150632579092E-5}]
[null,"Income from facilities and services","I08b",{"$f":"IF(ISERROR(INDEX('2023-24 Data'!$B$3:$BJ$19,MATCH($C$4,dfenums,0),MATCH($C59,'2023-24 Data'!$B$2:$BJ$2,0))),\"\",INDEX('2023-24 Data'!$B$3:$BJ$19,MATCH($C$4,dfenums,0),MATCH($C59,'2023-24 Data'!$B$2:$BJ$2,0)))","v":""},"","",null,{"$f":"IF(ISERROR(INDEX('2023-24 Data'!$B$3:$BJ$19,MATCH($H$6,dfenums,0),MATCH($C59,'2023-24 Data'!$B$2:$BJ$2,0))),\"\",INDEX('2023-24 Data'!$B$3:$BJ$19,MATCH($H$6,dfenums,0),MATCH($C59,'2023-24 Data'!$B$2:$BJ$2,0)))","v":""},"","",null,{"$f":"IF(ISERROR(INDEX('2023-24 Data'!$B$3:$BJ$19,MATCH($L$6,dfenums,0),MATCH($C59,'2023-24 Data'!$B$2:$BJ$2,0))),\"\",INDEX('2023-24 Data'!$B$3:$BJ$19,MATCH($L$6,dfenums,0),MATCH($C59,'2023-24 Data'!$B$2:$BJ$2,0)))","v":""},"","",null,{"$f":"IF(ISERROR(INDEX('2023-24 Data'!$B$3:$BJ$19,MATCH($P$6,dfenums,0),MATCH($C59,'2023-24 Data'!$B$2:$BJ$2,0))),\"\",INDEX('2023-24 Data'!$B$3:$BJ$19,MATCH($P$6,dfenums,0),MATCH($C59,'2023-24 Data'!$B$2:$BJ$2,0)))","v":""},"","",null,{"$f":"IF(ISERROR(SUM('2023-24 Data'!AW$3:AW$19)/SUM('2023-24 Data'!$C$3:$D$19)),\"\",SUM('2023-24 Data'!AW$3:AW$19)/SUM('2023-24 Data'!$C$3:$D$19))","v":-72.262276901711317},7.7875150632579092E-5]
[null,"Income from catering","I09",{"$f":"IF(ISERROR(INDEX('2023-24 Data'!$B$3:$BJ$19,MATCH($C$4,dfenums,0),MATCH($C60,'2023-24 Data'!$B$2:$BJ$2,0))),\"\",INDEX('2023-24 Data'!$B$3:$BJ$19,MATCH($C$4,dfenums,0),MATCH($C60,'2023-24 Data'!$B$2:$BJ$2,0)))","v":""},"","",null,{"$f":"IF(ISERROR(INDEX('2023-24 Data'!$B$3:$BJ$19,MATCH($H$6,dfenums,0),MATCH($C60,'2023-24 Data'!$B$2:$BJ$2,0))),\"\",INDEX('2023-24 Data'!$B$3:$BJ$19,MATCH($H$6,dfenums,0),MATCH($C60,'2023-24 Data'!$B$2:$BJ$2,0)))","v":""},"","",null,{"$f":"IF(ISERROR(INDEX('2023-24 Data'!$B$3:$BJ$19,MATCH($L$6,dfenums,0),MATCH($C60,'2023-24 Data'!$B$2:$BJ$2,0))),\"\",INDEX('2023-24 Data'!$B$3:$BJ$19,MATCH($L$6,dfenums,0),MATCH($C60,'2023-24 Data'!$B$2:$BJ$2,0)))","v":""},"","",null,{"$f":"IF(ISERROR(INDEX('2023-24 Data'!$B$3:$BJ$19,MATCH($P$6,dfenums,0),MATCH($C60,'2023-24 Data'!$B$2:$BJ$2,0))),\"\",INDEX('2023-24 Data'!$B$3:$BJ$19,MATCH($P$6,dfenums,0),MATCH($C60,'2023-24 Data'!$B$2:$BJ$2,0)))","v":""},"","",null,{"$f":"IF(ISERROR(SUM('2023-24 Data'!AX$3:AX$19)/SUM('2023-24 Data'!$C$3:$D$19)),\"\",SUM('2023-24 Data'!AX$3:AX$19)/SUM('2023-24 Data'!$C$3:$D$19))","v":-117.49638092464834},1.2662275194754054E-4]
[null,"Receipts from supply teachers insurance claims","I10",{"$f":"IF(ISERROR(INDEX('2023-24 Data'!$B$3:$BJ$19,MATCH($C$4,dfenums,0),MATCH($C61,'2023-24 Data'!$B$2:$BJ$2,0))),\"\",INDEX('2023-24 Data'!$B$3:$BJ$19,MATCH($C$4,dfenums,0),MATCH($C61,'2023-24 Data'!$B$2:$BJ$2,0)))","v":""},"","",null,{"$f":"IF(ISERROR(INDEX('2023-24 Data'!$B$3:$BJ$19,MATCH($H$6,dfenums,0),MATCH($C61,'2023-24 Data'!$B$2:$BJ$2,0))),\"\",INDEX('2023-24 Data'!$B$3:$BJ$19,MATCH($H$6,dfenums,0),MATCH($C61,'2023-24 Data'!$B$2:$BJ$2,0)))","v":""},"","",null,{"$f":"IF(ISERROR(INDEX('2023-24 Data'!$B$3:$BJ$19,MATCH($L$6,dfenums,0),MATCH($C61,'2023-24 Data'!$B$2:$BJ$2,0))),\"\",INDEX('2023-24 Data'!$B$3:$BJ$19,MATCH($L$6,dfenums,0),MATCH($C61,'2023-24 Data'!$B$2:$BJ$2,0)))","v":""},"","",null,{"$f":"IF(ISERROR(INDEX('2023-24 Data'!$B$3:$BJ$19,MATCH($P$6,dfenums,0),MATCH($C61,'2023-24 Data'!$B$2:$BJ$2,0))),\"\",INDEX('2023-24 Data'!$B$3:$BJ$19,MATCH($P$6,dfenums,0),MATCH($C61,'2023-24 Data'!$B$2:$BJ$2,0)))","v":""},"","",null,{"$f":"IF(ISERROR(SUM('2023-24 Data'!AY$3:AY$19)/SUM('2023-24 Data'!$C$3:$D$19)),\"\",SUM('2023-24 Data'!AY$3:AY$19)/SUM('2023-24 Data'!$C$3:$D$19))","v":-1.016315518322731},1.095256439085938E-6]
[null,"Receipts from other insurance claims","I11",{"$f":"IF(ISERROR(INDEX('2023-24 Data'!$B$3:$BJ$19,MATCH($C$4,dfenums,0),MATCH($C62,'2023-24 Data'!$B$2:$BJ$2,0))),\"\",INDEX('2023-24 Data'!$B$3:$BJ$19,MATCH($C$4,dfenums,0),MATCH($C62,'2023-24 Data'!$B$2:$BJ$2,0)))","v":""},"","",null,{"$f":"IF(ISERROR(INDEX('2023-24 Data'!$B$3:$BJ$19,MATCH($H$6,dfenums,0),MATCH($C62,'2023-24 Data'!$B$2:$BJ$2,0))),\"\",INDEX('2023-24 Data'!$B$3:$BJ$19,MATCH($H$6,dfenums,0),MATCH($C62,'2023-24 Data'!$B$2:$BJ$2,0)))","v":""},"","",null,{"$f":"IF(ISERROR(INDEX('2023-24 Data'!$B$3:$BJ$19,MATCH($L$6,dfenums,0),MATCH($C62,'2023-24 Data'!$B$2:$BJ$2,0))),\"\",INDEX('2023-24 Data'!$B$3:$BJ$19,MATCH($L$6,dfenums,0),MATCH($C62,'2023-24 Data'!$B$2:$BJ$2,0)))","v":""},"","",null,{"$f":"IF(ISERROR(INDEX('2023-24 Data'!$B$3:$BJ$19,MATCH($P$6,dfenums,0),MATCH($C62,'2023-24 Data'!$B$2:$BJ$2,0))),\"\",INDEX('2023-24 Data'!$B$3:$BJ$19,MATCH($P$6,dfenums,0),MATCH($C62,'2023-24 Data'!$B$2:$BJ$2,0)))","v":""},"","",null,{"$f":"IF(ISERROR(SUM('2023-24 Data'!AZ$3:AZ$19)/SUM('2023-24 Data'!$C$3:$D$19)),\"\",SUM('2023-24 Data'!AZ$3:AZ$19)/SUM('2023-24 Data'!$C$3:$D$19))","v":-15.447536511065314},1.6647402825927114E-5]
[null,"Income from contributions to visits etc.","I12",{"$f":"IF(ISERROR(INDEX('2023-24 Data'!$B$3:$BJ$19,MATCH($C$4,dfenums,0),MATCH($C63,'2023-24 Data'!$B$2:$BJ$2,0))),\"\",INDEX('2023-24 Data'!$B$3:$BJ$19,MATCH($C$4,dfenums,0),MATCH($C63,'2023-24 Data'!$B$2:$BJ$2,0)))","v":""},"","",null,{"$f":"IF(ISERROR(INDEX('2023-24 Data'!$B$3:$BJ$19,MATCH($H$6,dfenums,0),MATCH($C63,'2023-24 Data'!$B$2:$BJ$2,0))),\"\",INDEX('2023-24 Data'!$B$3:$BJ$19,MATCH($H$6,dfenums,0),MATCH($C63,'2023-24 Data'!$B$2:$BJ$2,0)))","v":""},"","",null,{"$f":"IF(ISERROR(INDEX('2023-24 Data'!$B$3:$BJ$19,MATCH($L$6,dfenums,0),MATCH($C63,'2023-24 Data'!$B$2:$BJ$2,0))),\"\",INDEX('2023-24 Data'!$B$3:$BJ$19,MATCH($L$6,dfenums,0),MATCH($C63,'2023-24 Data'!$B$2:$BJ$2,0)))","v":""},"","",null,{"$f":"IF(ISERROR(INDEX('2023-24 Data'!$B$3:$BJ$19,MATCH($P$6,dfenums,0),MATCH($C63,'2023-24 Data'!$B$2:$BJ$2,0))),\"\",INDEX('2023-24 Data'!$B$3:$BJ$19,MATCH($P$6,dfenums,0),MATCH($C63,'2023-24 Data'!$B$2:$BJ$2,0)))","v":""},"","",null,{"$f":"IF(ISERROR(SUM('2023-24 Data'!BA$3:BA$19)/SUM('2023-24 Data'!$C$3:$D$19)),\"\",SUM('2023-24 Data'!BA$3:BA$19)/SUM('2023-24 Data'!$C$3:$D$19))","v":-130.91192612669113},1.4108033131288872E-4]
[null,"Donations and/or voluntary funds","I13",{"$f":"IF(ISERROR(INDEX('2023-24 Data'!$B$3:$BJ$19,MATCH($C$4,dfenums,0),MATCH($C64,'2023-24 Data'!$B$2:$BJ$2,0))),\"\",INDEX('2023-24 Data'!$B$3:$BJ$19,MATCH($C$4,dfenums,0),MATCH($C64,'2023-24 Data'!$B$2:$BJ$2,0)))","v":""},"","",null,{"$f":"IF(ISERROR(INDEX('2023-24 Data'!$B$3:$BJ$19,MATCH($H$6,dfenums,0),MATCH($C64,'2023-24 Data'!$B$2:$BJ$2,0))),\"\",INDEX('2023-24 Data'!$B$3:$BJ$19,MATCH($H$6,dfenums,0),MATCH($C64,'2023-24 Data'!$B$2:$BJ$2,0)))","v":""},"","",null,{"$f":"IF(ISERROR(INDEX('2023-24 Data'!$B$3:$BJ$19,MATCH($L$6,dfenums,0),MATCH($C64,'2023-24 Data'!$B$2:$BJ$2,0))),\"\",INDEX('2023-24 Data'!$B$3:$BJ$19,MATCH($L$6,dfenums,0),MATCH($C64,'2023-24 Data'!$B$2:$BJ$2,0)))","v":""},"","",null,{"$f":"IF(ISERROR(INDEX('2023-24 Data'!$B$3:$BJ$19,MATCH($P$6,dfenums,0),MATCH($C64,'2023-24 Data'!$B$2:$BJ$2,0))),\"\",INDEX('2023-24 Data'!$B$3:$BJ$19,MATCH($P$6,dfenums,0),MATCH($C64,'2023-24 Data'!$B$2:$BJ$2,0)))","v":""},"","",null,{"$f":"IF(ISERROR(SUM('2023-24 Data'!BB$3:BB$19)/SUM('2023-24 Data'!$C$3:$D$19)),\"\",SUM('2023-24 Data'!BB$3:BB$19)/SUM('2023-24 Data'!$C$3:$D$19))","v":-137.24312292805305},1.4790329518463583E-4]
[null,"Pupil focussed extended school funding &/or grants","I15",{"$f":"IF(ISERROR(INDEX('2023-24 Data'!$B$3:$BJ$19,MATCH($C$4,dfenums,0),MATCH($C65,'2023-24 Data'!$B$2:$BJ$2,0))),\"\",INDEX('2023-24 Data'!$B$3:$BJ$19,MATCH($C$4,dfenums,0),MATCH($C65,'2023-24 Data'!$B$2:$BJ$2,0)))","v":""},"","",null,{"$f":"IF(ISERROR(INDEX('2023-24 Data'!$B$3:$BJ$19,MATCH($H$6,dfenums,0),MATCH($C65,'2023-24 Data'!$B$2:$BJ$2,0))),\"\",INDEX('2023-24 Data'!$B$3:$BJ$19,MATCH($H$6,dfenums,0),MATCH($C65,'2023-24 Data'!$B$2:$BJ$2,0)))","v":""},"","",null,{"$f":"IF(ISERROR(INDEX('2023-24 Data'!$B$3:$BJ$19,MATCH($L$6,dfenums,0),MATCH($C65,'2023-24 Data'!$B$2:$BJ$2,0))),\"\",INDEX('2023-24 Data'!$B$3:$BJ$19,MATCH($L$6,dfenums,0),MATCH($C65,'2023-24 Data'!$B$2:$BJ$2,0)))","v":""},"","",null,{"$f":"IF(ISERROR(INDEX('2023-24 Data'!$B$3:$BJ$19,MATCH($P$6,dfenums,0),MATCH($C65,'2023-24 Data'!$B$2:$BJ$2,0))),\"\",INDEX('2023-24 Data'!$B$3:$BJ$19,MATCH($P$6,dfenums,0),MATCH($C65,'2023-24 Data'!$B$2:$BJ$2,0)))","v":""},"","",null,{"$f":"IF(ISERROR(SUM('2023-24 Data'!BC$3:BC$19)/SUM('2023-24 Data'!$C$3:$D$19)),\"\",SUM('2023-24 Data'!BC$3:BC$19)/SUM('2023-24 Data'!$C$3:$D$19))","v":0},0]
[null,"Com focussed extended school funding &/or grants","I16",{"$f":"IF(ISERROR(INDEX('2023-24 Data'!$B$3:$BJ$19,MATCH($C$4,dfenums,0),MATCH($C66,'2023-24 Data'!$B$2:$BJ$2,0))),\"\",INDEX('2023-24 Data'!$B$3:$BJ$19,MATCH($C$4,dfenums,0),MATCH($C66,'2023-24 Data'!$B$2:$BJ$2,0)))","v":""},"","",null,{"$f":"IF(ISERROR(INDEX('2023-24 Data'!$B$3:$BJ$19,MATCH($H$6,dfenums,0),MATCH($C66,'2023-24 Data'!$B$2:$BJ$2,0))),\"\",INDEX('2023-24 Data'!$B$3:$BJ$19,MATCH($H$6,dfenums,0),MATCH($C66,'2023-24 Data'!$B$2:$BJ$2,0)))","v":""},"","",null,{"$f":"IF(ISERROR(INDEX('2023-24 Data'!$B$3:$BJ$19,MATCH($L$6,dfenums,0),MATCH($C66,'2023-24 Data'!$B$2:$BJ$2,0))),\"\",INDEX('2023-24 Data'!$B$3:$BJ$19,MATCH($L$6,dfenums,0),MATCH($C66,'2023-24 Data'!$B$2:$BJ$2,0)))","v":""},"","",null,{"$f":"IF(ISERROR(INDEX('2023-24 Data'!$B$3:$BJ$19,MATCH($P$6,dfenums,0),MATCH($C66,'2023-24 Data'!$B$2:$BJ$2,0))),\"\",INDEX('2023-24 Data'!$B$3:$BJ$19,MATCH($P$6,dfenums,0),MATCH($C66,'2023-24 Data'!$B$2:$BJ$2,0)))","v":""},"","",null,{"$f":"IF(ISERROR(SUM('2023-24 Data'!BD$3:BD$19)/SUM('2023-24 Data'!$C$3:$D$19)),\"\",SUM('2023-24 Data'!BD$3:BD$19)/SUM('2023-24 Data'!$C$3:$D$19))","v":0},0]
[null,"Com focussed extended school facilities income","I17",{"$f":"IF(ISERROR(INDEX('2023-24 Data'!$B$3:$BJ$19,MATCH($C$4,dfenums,0),MATCH($C67,'2023-24 Data'!$B$2:$BJ$2,0))),\"\",INDEX('2023-24 Data'!$B$3:$BJ$19,MATCH($C$4,dfenums,0),MATCH($C67,'2023-24 Data'!$B$2:$BJ$2,0)))","v":""},"","",null,{"$f":"IF(ISERROR(INDEX('2023-24 Data'!$B$3:$BJ$19,MATCH($H$6,dfenums,0),MATCH($C67,'2023-24 Data'!$B$2:$BJ$2,0))),\"\",INDEX('2023-24 Data'!$B$3:$BJ$19,MATCH($H$6,dfenums,0),MATCH($C67,'2023-24 Data'!$B$2:$BJ$2,0)))","v":""},"","",null,{"$f":"IF(ISERROR(INDEX('2023-24 Data'!$B$3:$BJ$19,MATCH($L$6,dfenums,0),MATCH($C67,'2023-24 Data'!$B$2:$BJ$2,0))),\"\",INDEX('2023-24 Data'!$B$3:$BJ$19,MATCH($L$6,dfenums,0),MATCH($C67,'2023-24 Data'!$B$2:$BJ$2,0)))","v":""},"","",null,{"$f":"IF(ISERROR(INDEX('2023-24 Data'!$B$3:$BJ$19,MATCH($P$6,dfenums,0),MATCH($C67,'2023-24 Data'!$B$2:$BJ$2,0))),\"\",INDEX('2023-24 Data'!$B$3:$BJ$19,MATCH($P$6,dfenums,0),MATCH($C67,'2023-24 Data'!$B$2:$BJ$2,0)))","v":""},"","",null,{"$f":"IF(ISERROR(SUM('2023-24 Data'!BE$3:BE$19)/SUM('2023-24 Data'!$C$3:$D$19)),\"\",SUM('2023-24 Data'!BE$3:BE$19)/SUM('2023-24 Data'!$C$3:$D$19))","v":0},0]
[null,"Additional Grant for Schools","I18",{"$f":"IF(ISERROR(INDEX('2023-24 Data'!$B$3:$BJ$19,MATCH($C$4,dfenums,0),MATCH($C68,'2023-24 Data'!$B$2:$BJ$2,0))),\"\",INDEX('2023-24 Data'!$B$3:$BJ$19,MATCH($C$4,dfenums,0),MATCH($C68,'2023-24 Data'!$B$2:$BJ$2,0)))","v":""},"","",null,{"$f":"IF(ISERROR(INDEX('2023-24 Data'!$B$3:$BJ$19,MATCH($H$6,dfenums,0),MATCH($C68,'2023-24 Data'!$B$2:$BJ$2,0))),\"\",INDEX('2023-24 Data'!$B$3:$BJ$19,MATCH($H$6,dfenums,0),MATCH($C68,'2023-24 Data'!$B$2:$BJ$2,0)))","v":""},"","",null,{"$f":"IF(ISERROR(INDEX('2023-24 Data'!$B$3:$BJ$19,MATCH($L$6,dfenums,0),MATCH($C68,'2023-24 Data'!$B$2:$BJ$2,0))),\"\",INDEX('2023-24 Data'!$B$3:$BJ$19,MATCH($L$6,dfenums,0),MATCH($C68,'2023-24 Data'!$B$2:$BJ$2,0)))","v":""},"","",null,{"$f":"IF(ISERROR(INDEX('2023-24 Data'!$B$3:$BJ$19,MATCH($P$6,dfenums,0),MATCH($C68,'2023-24 Data'!$B$2:$BJ$2,0))),\"\",INDEX('2023-24 Data'!$B$3:$BJ$19,MATCH($P$6,dfenums,0),MATCH($C68,'2023-24 Data'!$B$2:$BJ$2,0)))","v":""},"","",null,{"$f":"IF(ISERROR(SUM('2023-24 Data'!BF$3:BF$19)/SUM('2023-24 Data'!$C$3:$D$19)),\"\",SUM('2023-24 Data'!BF$3:BF$19)/SUM('2023-24 Data'!$C$3:$D$19))","v":-5.4646313054385809},5.889089083663494E-6]
[null,"Covid-19 furloughed Staff","I18A",{"$f":"IF(ISERROR(INDEX('2023-24 Data'!$B$3:$BJ$19,MATCH($C$4,dfenums,0),MATCH($C69,'2023-24 Data'!$B$2:$BJ$2,0))),\"\",INDEX('2023-24 Data'!$B$3:$BJ$19,MATCH($C$4,dfenums,0),MATCH($C69,'2023-24 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('2023-24 Data'!$B$3:$BJ$19,MATCH($H$6,dfenums,0),MATCH($C69,'2023-24 Data'!$B$2:$BJ$2,0))),\"\",INDEX('2023-24 Data'!$B$3:$BJ$19,MATCH($H$6,dfenums,0),MATCH($C69,'2023-24 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('2023-24 Data'!$B$3:$BJ$19,MATCH($L$6,dfenums,0),MATCH($C69,'2023-24 Data'!$B$2:$BJ$2,0))),\"\",INDEX('2023-24 Data'!$B$3:$BJ$19,MATCH($L$6,dfenums,0),MATCH($C69,'2023-24 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('2023-24 Data'!$B$3:$BJ$19,MATCH($P$6,dfenums,0),MATCH($C69,'2023-24 Data'!$B$2:$BJ$2,0))),\"\",INDEX('2023-24 Data'!$B$3:$BJ$19,MATCH($P$6,dfenums,0),MATCH($C69,'2023-24 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('2023-24 Data'!BG$3:BG$19)/SUM('2023-24 Data'!$C$3:$D$19)),\"\",SUM('2023-24 Data'!BG$3:BG$19)/SUM('2023-24 Data'!$C$3:$D$19))","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('2023-24 Data'!$B$3:$BJ$19,MATCH($C$4,dfenums,0),MATCH($C70,'2023-24 Data'!$B$2:$BJ$2,0))),\"\",INDEX('2023-24 Data'!$B$3:$BJ$19,MATCH($C$4,dfenums,0),MATCH($C70,'2023-24 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('2023-24 Data'!$B$3:$BJ$19,MATCH($H$6,dfenums,0),MATCH($C70,'2023-24 Data'!$B$2:$BJ$2,0))),\"\",INDEX('2023-24 Data'!$B$3:$BJ$19,MATCH($H$6,dfenums,0),MATCH($C70,'2023-24 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('2023-24 Data'!$B$3:$BJ$19,MATCH($L$6,dfenums,0),MATCH($C70,'2023-24 Data'!$B$2:$BJ$2,0))),\"\",INDEX('2023-24 Data'!$B$3:$BJ$19,MATCH($L$6,dfenums,0),MATCH($C70,'2023-24 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('2023-24 Data'!$B$3:$BJ$19,MATCH($P$6,dfenums,0),MATCH($C70,'2023-24 Data'!$B$2:$BJ$2,0))),\"\",INDEX('2023-24 Data'!$B$3:$BJ$19,MATCH($P$6,dfenums,0),MATCH($C70,'2023-24 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('2023-24 Data'!BH$3:BH$19)/SUM('2023-24 Data'!$C$3:$D$19)),\"\",SUM('2023-24 Data'!BH$3:BH$19)/SUM('2023-24 Data'!$C$3:$D$19))","v":0},{"$f":"IF(ISERROR(T70/$T$72),\"\",T70/$T$72)","v":0}]
[null,"Covid-19 £1bn package","I18C",{"$f":"IF(ISERROR(INDEX('2023-24 Data'!$B$3:$BJ$19,MATCH($C$4,dfenums,0),MATCH($C71,'2023-24 Data'!$B$2:$BJ$2,0))),\"\",INDEX('2023-24 Data'!$B$3:$BJ$19,MATCH($C$4,dfenums,0),MATCH($C71,'2023-24 Data'!$B$2:$BJ$2,0)))","v":""},"","",null,{"$f":"IF(ISERROR(INDEX('2023-24 Data'!$B$3:$BJ$19,MATCH($H$6,dfenums,0),MATCH($C71,'2023-24 Data'!$B$2:$BJ$2,0))),\"\",INDEX('2023-24 Data'!$B$3:$BJ$19,MATCH($H$6,dfenums,0),MATCH($C71,'2023-24 Data'!$B$2:$BJ$2,0)))","v":""},"","",null,{"$f":"IF(ISERROR(INDEX('2023-24 Data'!$B$3:$BJ$19,MATCH($L$6,dfenums,0),MATCH($C71,'2023-24 Data'!$B$2:$BJ$2,0))),\"\",INDEX('2023-24 Data'!$B$3:$BJ$19,MATCH($L$6,dfenums,0),MATCH($C71,'2023-24 Data'!$B$2:$BJ$2,0)))","v":""},"","",null,{"$f":"IF(ISERROR(INDEX('2023-24 Data'!$B$3:$BJ$19,MATCH($P$6,dfenums,0),MATCH($C71,'2023-24 Data'!$B$2:$BJ$2,0))),\"\",INDEX('2023-24 Data'!$B$3:$BJ$19,MATCH($P$6,dfenums,0),MATCH($C71,'2023-24 Data'!$B$2:$BJ$2,0)))","v":""},"","",null,{"$f":"IF(ISERROR(SUM('2023-24 Data'!BI$3:BI$19)/SUM('2023-24 Data'!$C$3:$D$19)),\"\",SUM('2023-24 Data'!BI$3:BI$19)/SUM('2023-24 Data'!$C$3:$D$19))","v":-73.860070558193712},7.9597050730573351E-5]
[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":-927924.71429879172},{"$f":"IF(ISERROR(SUM(U49:U71)),\"\",SUM(U49:U51)+SUM(U54:U71))","v":1}]

{"sheet":"2023-24 Data","index":2,"n_rows":29,"n_cols":71,"rows_kept":29,"cut":false,"hidden":true,"merged":[[0,3,0,4]]}
[null,"PFI School",{"$f":"Benchmarking!C1&\" School Budget Templates\"","v":"2023-24 School Budget Templates"},"KCC Finance & Procurement",null,{"$f":"\"From \"&Benchmarking!C1&\" Checking Spreadsheet\"","v":"From 2023-24 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 2023-24 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 2024 Advances"},null,null,null,null,null,{"$f":"\"From March 20\"&RIGHT(Benchmarking!C1,2)&\" Advances\"","v":"From March 2024 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",744,0,0,3485000.09,25179.66,872934.01,196394.85,362911.21,0,3173.05,16371.56,20419.7,1544.1000000000001,3935.04,87818.73,19417.060000000001,16383.43,11234.39,222745.62,244480,49792.49,186705.25,44406.96,85855.44,73325.930000000008,23398.760000000002,609,65408.1,49956.630000000005,77982.009999999995,41984.56,0,0,256904.25,0,0,{"$f":"BJ3-AN3-AO3-AP3","v":-4479116.0999999996},-584920.29,{"$f":"BP3","v":0},{"$f":"BS3","v":-153887.30000000005},-727958.47,0,-186072.93,-56308.18,-46778,-99206.92,-43082.79,0,0,0,0,-42373.75,0,0,0,0,0,0,-37653.75,-5217923.6899999995,0,0,0,0,0,{"$f":"-SUM(BK3:BO3)","v":0},0,153887.30000000005,{"$f":"-SUM(BQ3:BR3)","v":-153887.30000000005}]
[4040,"Northfleet School for Girls",1007,0,0,4659056.18,0,1191043.0900000001,200343.29,412343.27,177580.87,46240.840000000004,54257.520000000004,59318.89,2014,37598.160000000003,256995.08000000002,19363.420000000002,214495.09,16661.830000000002,194304.13,33280,30653.3,495863.65,158940.01999999999,177736.48,57343.71,33419.800000000003,33876.270000000004,353283.02,218398.98,133072.08000000002,28481.9,0,15743.78,0,0,0,-5576743.0199999996,-1152336.08,{"$f":"BP4","v":0},{"$f":"BS4","v":-33566.94},-1260366.24,0,-375392.84,-111124.32,-132809.83000000002,-61441.05,-58142.76,-371036.58,0,-20494.32,-172857.85,-70224.100000000006,0,0,0,0,0,0,-133610.01,-6762646.04,0,0,0,0,0,{"$f":"-SUM(BK4:BO4)","v":0},0,33566.94,{"$f":"-SUM(BQ4:BR4)","v":-33566.94}]
[4043,"Tunbridge Wells Girls' Grammar School",732,0,0,3793501.4699999997,0,533047.87,93954.53,388648.28,0,1192.6400000000001,26605.09,17801.189999999999,1464,27755.4,90889.84,40438.700000000004,145722.09,9102.33,186849.76,58368,45847.03,604765.11,90242.180000000008,116829.76000000001,36376.11,25992.600000000002,0,13262.28,786.24,83522.5,38929.07,0,0,0,0,0,-3995881.64,-416276.49,0,-93671.26999999999,-1363981.74,0,-21405,-50004.65,-55713.97,0,-4568.57,-15000,0,0,0,-496570.3,0,0,0,0,0,0,-9268.630000000001,-4505829.4000000004,0,0,0,0,0,0,0,93671.26999999999,-93671.26999999999]
[4045,"Tunbridge Wells Grammar School for Boys",1293,0,0,5488737.9100000001,0,912307.95000000007,129053.66,779963.98,0,46723.63,67627.81,19460.13,2586,7377.24,293075.84000000003,37168.76,233192.93,442.74,374661.41000000003,166400,59128.959999999999,892192.33000000007,214871.63,171158.55000000002,79669.11,43565,1974.3400000000001,32415.09,98333.930000000008,59104.08,68524.11,0,50785.06,70351,0,0,-7184700.0899999989,-838211.58,0,-11632.399999999998,-1714372.35,0,-87840,-94283.02,-3583.9500000000003,-88030.52,-32039.91,-25000,0,0,-550818.49,-151673.70000000001,0,0,0,0,0,0,-28219.62,-8034544.0699999994,0,0,0,0,0,0,0,11632.399999999998,-11632.399999999998]
[4109,"Dover Grammar School for Girls",675,0,0,3637182.21,5913.95,474766.32,180572.25,364245.4,0,13833.75,22203.21,13377.14,1350,25241.760000000002,26180.54,11320.37,19610.78,16843.990000000002,90858.2,92672,18567.41,282149.01,74787.63,89071.17,46706.879999999997,22559.16,0,53047.06,39965,67076.33,45811.4,0,1481.53,0,0,0,-3788547.19,-335739.49,0,-37500.310000000005,-1122041.5,0,-126276,-74640.39,-20629.45,0,-23326.62,0,0,-42006.79,-118347.12,-28705.43,0,0,0,0,0,0,-42204.88,-4161786.99,0,0,0,0,0,0,0,37500.310000000005,-37500.310000000005]
[4522,"Maidstone Grammar School",1050,0,0,4766785.45,0,732360.12,204408.21,399553.36,0,22484.27,59397.82,35459.770000000004,2100,40323.19,139790.44,83286.98,172178.34,34966.49,253075.59,45056,64251.21,586014.57999999996,208867.46,200089.25,142758.44,48108.11,78617.150000000009,430519.32,36874.840000000004,45588.51,56204.1,0,0,439479.03,0,0,-5662154.5200000005,-629784.48,0,-2242.9500000000003,-2031801.31,0,-81575,-64635,-720,-102405.31,-50782.090000000004,-381095.26,0,-5186.9000000000005,-293592.18,-134017.12,0,0,0,0,0,0,-15144.880000000001,-6294181.9500000002,0,0,0,0,0,0,0,2242.9500000000003,-2242.9500000000003]
[4523,"Maidstone Grammar School for Girls",862,0,0,4193280.99,0,582152.23,104950.86,523944.22000000003,0,16874.53,56136.82,21997.83,1724,32473.68,58682.590000000004,14247.42,191942.80000000002,48287.950000000004,354025.83,35328,42568.44,396212.21,73728.69,157970.76999999999,64293.440000000002,29764.639999999999,314125.13,42324.98,97224.16,52247.9,54452.35,0,0,335580.7,0,0,-4774023.55,-475810.4,0,0,-1611401,0,-96260,-54928.93,-245246.55000000002,-355840.69,0,-10674.050000000001,0,-20248.310000000001,-215828.30000000002,-11250.25,0,0,0,0,0,0,-25084.65,-5249833.95,0,0,0,0,0,0,0,0,0]
[4534,"Simon Langton Girls' Grammar School",880,0,0,4641333.99,18682.87,637982.32999999996,129712.26000000001,487961.28,121953.65000000001,43207.42,19115.05,27589.61,1760,5711.04,51939.21,31775.06,132108.97,27553.05,188834.56,256637.98,49275.65,523284.11,46242.38,143961.01999999999,67581.78,31573.64,0,271899.09000000003,0,21515.5,54733.32,0,0,221099.97,0,0,-4988138.2,-509895.8,0,-37283.020000000011,-1847091.97,0,-86155,-74007.930000000008,-14221.15,-34890.699999999997,-30834.639999999999,-348953.61,0,-1508.04,0,-313755.81,0,0,0,0,0,0,-15290,-5535317.0199999996,0,0,0,0,0,0,0,37283.020000000011,-37283.020000000011]
[4622,"Judd School, The",952,0.33333333333333331,18.75,5655855.1699999999,1063.8399999999999,1051268.46,464336.01,532823.4,0,0,49533.760000000002,27097.78,1904,0,198831.56,80027.13,25543.37,23320.06,253849.28,54272,23022.010000000002,1378770.63,56301.200000000004,220194.44,58330.39,44901.58,0,48983.82,74873.88,250,95060.540000000008,0,11194.91,0,0,0,-5170876.1000000006,-576051.30000000005,-320388,-14477.22,-2897646.2800000003,0,-30905,-65794.7,-2040,-37351.279999999999,-438464.94,-25000,0,-3844,0,-678403.76,0,0,0,0,0,0,-16300.140000000001,-6081792.6200000001,0,189054.66999999998,9333.33,122000,0,-320388,0,14477.22,-14477.22]
[5407,"Thamesview School",872,0,5.583333333333333,3506215.2,0,1139880.8500000001,38056.17,388786.13,0,65685.13,54723.630000000005,57523.5,1744,31306.920000000002,262080.25893474836,39467.936413313859,84.070000000000007,17751.701841269391,17112.37,45568,14042.15,238247.17,125552.42,104517.07,51419.65,89347.762172195202,26177.79,69237.119999999995,285711.10000000003,231134.7,1816679.3606384727,0,0,27480.87,0,0,-6047440.5300000003,-1139189.1299999999,-132563.71000000002,-107710.91000000002,-335206.63,0,-396855.5,-82855.3,-113273.21,-2047.65,0,0,0,-18674.96,-1320,0,0,0,0,0,0,0,-141330.79,-7426904.2800000003,0,66563.710000000006,12000,54000,0,-132563.71000000002,0,107710.91000000002,-107710.91000000002]
[5412,"Simon Langton Grammar School for Boys",782,6.5,31,4917510.1399999997,0,906885.59,292156.74,364348.05,203358.01,54877.919999999998,32891.520000000004,25549.73,1564,30139.200000000001,177773.77,48463.28,15125.61,37957.89,226299.4,32256,50058.81,513240.76,247811.77000000002,124851.41,81559.960000000006,35770.550000000003,251955.37,234234.71,13427.130000000001,22514.79,122691.37,0,52930.03,31990.74,0,0,-4302613.6499999994,-448357.17,-564580.78,-34706.32,-2649995.48,0,-53600,-88206.76,-50020.55,-114396.39,-163034.30000000002,-358367.23,-15124.130000000001,0,-302213.65000000002,-746.94,0,0,0,0,0,0,-28127.510000000002,-5350257.92,15000,339580.78,0,210000,0,-564580.78,0,34706.32,-34706.32]
[5425,"Malling School, The",903,18,102.66666666666667,5276151.34,4609.3900000000003,1269885.77,0,444176.54000000004,0,31032.27,29164.61,41924.04,1806,32923.56,138391.26302874243,54487.102992277352,146.58000000000001,24680.83968744515,0,33792,6760.35,465568.76,102997.54000000001,130000,45223.31,64464.725973304674,1354964.3957479992,10875.32,1191.01,221458.61000000002,144185.8025702312,0,0,0,0,0,-5810427.9299999997,-880799.08,-1394747.9900000002,-176074.71000000002,-808522.9,0,-258991,-216882.45,-137304.74,-40588.559999999998,-12991,0,0,-28463,-34760.03,-18993.52,0,0,0,0,0,0,-146120.41,-8262049.71,15000,647747.99000000011,12000,600000,120000,-1394747.9900000002,0,176074.71000000002,-176074.71000000002]
[5426,"Archbishop's School, The",622,0.5,4.583333333333333,3188282.17,52367.48,821595.98,241011.82,388674.35000000003,51382.03,25932.5,15487.31,26383.03,1244,22719.119999999999,44597.49,16205.12,18008.740000000002,16461.53,180018.15,23961.600000000002,29397.75,226869.17,68844.72,124002.63,57497.47,19129.400000000001,4504.71,114833.65000000001,202075.89,368663.74,50816.81,0,1037.69,34409.879999999997,0,0,-3863740.0100000007,-1020140.63,-76814.539999999994,-84732.549999999988,-442871.9,-58500,-349955.39,-102507.89,-237519.98,-11740,-25341.31,-35676.54,0,-9879.3000000000011,-42427,-57468.639999999999,0,0,0,0,0,0,-81086.16,-5045427.7300000004,0,26814.539999999994,7999.9999999999991,42000,0,-76814.539999999994,0,84732.549999999988,-84732.549999999988]
[5447,"St George's CE Foundation School",1080,0,0,6199673.3499999996,0,1407124.6,443445.49,655414.01,204496.72,65735,51766.32,14922.09,2992,131.25,213619.14,21058.45,36233.950000000004,9072,411197.18,83345.11,49519.71,347728.81,185056.04,162882.58000000002,76912.44,54217.11,0,198157.01,144382.11000000002,225378.66,80555.960000000006,0,0,128257,0,0,-7449262.8700000001,-1572870.96,0,-176888.15,-774865.43,0,-665660.66,-104063.3,-118586.57,-43870,-60634.97,-174564.86000000002,0,-26556.84,-37289.64,-35,0,0,0,-81321,0,0,-147921.72,-9199021.9800000004,0,0,0,0,0,0,0,176888.15,-176888.15]
[5456,"Northfleet Technology College",754,0,0,3766988.44,17369.52,940971.94000000006,0,365889.46,0,0,52481.18,48055.14,1508,27657.119999999999,105484.50081397685,24488.036174090415,152962.54,14082.292182617019,177548.44,44937.75,12053.65,199378.97,88989.930000000008,132157.28,44564.090000000004,43424.016165937028,1056962.6059858075,104884.83,94182.47,119633.28,53815.158677571148,0,0,149882.99,0,0,-5314089.24,-970518.05,0,-51801.080000000009,-909530.70000000007,0,-267297.5,-91052.89,-82204,0,-41917.120000000003,0,0,-28202.190000000002,0,0,0,0,0,0,0,0,-98707.62,-6336408.3700000001,0,0,0,0,0,0,0,51801.080000000009,-51801.080000000009]
[5459,"Dover Grammar School for Boys",678,0,0,3446469.08,13123.210000000001,492752.93,209310.75,292957.24,0,0,4841.8500000000004,15697.43,1356,25249.8,58896.29,23843.64,6925.28,9324.4600000000009,45046.97,17817.990000000002,11731.57,308961.49,97427.56,99673.600000000006,67076.47,23101.56,18445.34,47539.82,3562,61972,66308.350000000006,0,0,28034.36,0,0,-3708502.9000000004,-344017.51,0,-35833.17,-819500.86,0,-135080,-48463.5,-15186.84,-5995.14,-70792.28,-3134.6800000000003,0,0,-176526.80000000002,-37732.31,0,0,0,0,0,0,-43838.5,-4088353.58,0,0,0,0,0,0,0,35833.17,-35833.17]
[5461,"St John's RC Comprehensive School",970,0,0,5755953.54,0,911012.81,0,249086.64,0,54996.22,40726.800000000003,19687.11,1940,39823.200000000004,161035.83525640928,32155.085881597002,0,20208.893578632062,0,68324.790000000008,14366.960000000001,204862.97,155358.87,168905.5,84080.24,105067.87213720541,1691387.7236451895,13538.4,128324.40000000001,100012.17,104652.6495009668,0,0,0,0,0,-6733171.7000000002,-1020206.24,0,-71477.759999999995,-1990343.81,0,-272160.94,-72909.900000000009,-83406,0,-19405.73,0,0,-24815.29,-2162.9499999999998,-410.03000000000003,0,0,0,0,0,0,-89227.06,-7824855.7000000002,0,0,0,0,0,0,0,71477.759999999995,-71477.759999999995]
[]
[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('2023-24 Data'!AM$3:AM$19)/SUM('2023-24 Data'!$C$3:$D$19)),\"\",SUM('2023-24 Data'!AM$3:AM$19)/SUM('2023-24 Data'!$C$3:$D$19))","v":-5970.5287993907359},-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",null,"E15",null,null,null,null,null,null,null,"E23","E24",null,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":262080.25893474836},{"$f":"'PFI Adjustments'!E16","v":39467.936413313859},null,{"$f":"'PFI Adjustments'!F16","v":17751.701841269391},null,null,null,null,null,null,null,{"$f":"'PFI Adjustments'!G16","v":89347.762172195202},{"$f":"'PFI Adjustments'!H16","v":26177.79},null,null,null,{"$f":"'PFI Adjustments'!I16","v":1816679.3606384727},0]
[5425,"The Malling School",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'PFI Adjustments'!D17","v":138391.26302874243},{"$f":"'PFI Adjustments'!E17","v":54487.102992277352},null,{"$f":"'PFI Adjustments'!F17","v":24680.83968744515},null,null,null,null,null,null,null,{"$f":"'PFI Adjustments'!G17","v":64464.725973304674},{"$f":"'PFI Adjustments'!H17","v":1354964.3957479992},null,null,null,{"$f":"'PFI Adjustments'!I17","v":144185.8025702312},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":120972.88836733704},{"$f":"'PFI Adjustments'!E18","v":43158.921468947687},null,{"$f":"'PFI Adjustments'!F18","v":16547.070755346402},null,null,null,null,null,null,null,{"$f":"'PFI Adjustments'!G18","v":70398.486206187852},{"$f":"'PFI Adjustments'!H18","v":1458422.3798687384},null,null,null,{"$f":"'PFI Adjustments'!I18","v":57000.523333442703},0]
[5456,"Northfleet Technology College",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'PFI Adjustments'!D19","v":105484.50081397685},{"$f":"'PFI Adjustments'!E19","v":24488.036174090415},null,{"$f":"'PFI Adjustments'!F19","v":14082.292182617019},null,null,null,null,null,null,null,{"$f":"'PFI Adjustments'!G19","v":43424.016165937028},{"$f":"'PFI Adjustments'!H19","v":1056962.6059858075},null,null,null,{"$f":"'PFI Adjustments'!I19","v":53815.158677571148},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":161035.83525640928},{"$f":"'PFI Adjustments'!E20","v":32155.085881597002},null,{"$f":"'PFI Adjustments'!F20","v":20208.893578632062},null,null,null,null,null,null,null,{"$f":"'PFI Adjustments'!G20","v":105067.87213720541},{"$f":"'PFI Adjustments'!H20","v":1691387.7236451895},null,null,null,{"$f":"'PFI Adjustments'!I20","v":104652.6495009668},0]

{"sheet":"PFI Adjustments","index":3,"n_rows":20,"n_cols":17,"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","E15","E23","E24","E28"]
[5407,"Thamesview School",null,36735.43,0,0,24595.100000000002,26177.79,48156.38]
[5425,"The Malling School",null,44597.49,16205.12,16461.53,19129.400000000001,4504.71,50816.81]
[5431,"Hugh Christie Technology College",null,15383.31,0,0,29042.74,320449.03000000003,25289.760000000002]
[5456,"Northfleet Technology College",null,3466.34,0,166.97,23043.68,0,43086.38]
[5461,"St Johns RC Comprehensive School",null,739,0,0,31442.36,0,46004.94]
[]
[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 2023-24\n Checking Spreadsheet"},"E12","E13","E15","E23","E24","E28",null,"E12","E13","E15","E23","E24","E28","Comments"]
[5407,"Thamesview School",2115840.11,{"$f":"$C10*K10","v":225344.82893474837},39467.936413313859,17751.701841269391,64752.662172195196,0,1768522.9806384728,null,0.10650371352244967,1.8653553369547316E-2,8.3899070432450554E-3,3.0603759644293349E-2,0,0.83584906642046453,"Supplied by School"]
[5425,"The Malling School",1629459.07,93793.773028742435,38281.98299227735,8219.3096874451494,45335.325973304673,1350459.6857479992,93368.992570231218,null,5.7561294269725005E-2,2.3493675721647522E-2,5.0441952417038301E-3,2.7822316502435787E-2,0.82877791201469042,5.7300606249797492E-2,"Calculation"]
[5431,"Hugh Christie Technology College",1376335.43,105589.57836733705,43158.921468947687,16547.070755346402,41355.746206187854,1137973.3498687383,31710.763333442705,null,7.6717910522246052E-2,3.1357851093717533E-2,1.2022556707231175E-2,3.0047723327290828E-2,0.82681396196328272,2.3039996386231738E-2,"Calculation"]
[5456,"Northfleet Technology College",1228493.24,102018.16081397685,24488.036174090415,13915.322182617019,20380.336165937028,1056962.6059858075,10728.778677571154,null,8.3043322903410405E-2,1.9933391065375675E-2,1.1327145913002353E-2,1.6589701515929405E-2,0.86037315596934627,8.7332826329359001E-3,"Supplied by School"]
[5461,"St Johns RC Comprehensive School",2036321.76,160296.83525640928,32155.085881597002,20208.893578632062,73625.512137205413,1691387.7236451895,58647.709500966805,null,7.8718814681040028E-2,1.5790768685591712E-2,9.924214323885662E-3,3.6156128949486555E-2,0.83060926660489531,2.8800806755100827E-2,"Calculation"]
[]
[5407,"Thamesview School",null,{"$f":"D2+D10","v":262080.25893474836},39467.936413313859,17751.701841269391,89347.762172195202,26177.79,1816679.3606384727]
[5425,"The Malling School",null,138391.26302874243,54487.102992277352,24680.83968744515,64464.725973304674,1354964.3957479992,144185.8025702312]
[5431,"Hugh Christie Technology College",null,120972.88836733704,43158.921468947687,16547.070755346402,70398.486206187852,1458422.3798687384,57000.523333442703]
[5456,"Northfleet Technology College",null,105484.50081397685,24488.036174090415,14082.292182617019,43424.016165937028,1056962.6059858075,53815.158677571148]
[5461,"St Johns RC Comprehensive School",null,161035.83525640928,32155.085881597002,20208.893578632062,105067.87213720541,1691387.7236451895,104652.6495009668]