{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Instructions","Cover Sheet","Table A","Table A1","Admin-MissingRowCheck","Admin"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":4,"defined_names":44,"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":"Instructions","index":0,"n_rows":23,"n_cols":2,"rows_kept":23,"cut":false,"hidden":false,"merged":[]}
[null,"Completing the Return"]
[]
[null,"Important: This file uses macros to validate the data entered in the template and to generate an XML file for upload to COLLECT."]
[]
[null,"If you are blocked from running macros, please try the solutions suggested in this Microsoft article or contact your IT support team."]
[]
[null,"Detailed guidance on how to complete the return is available at: https://www.gov.uk/government/publications/section-251-2022-to-2023."]
[]
[null,"Table A"]
[]
[null,"This is information at local authority level that provides an overall picture of the expenditure on schools and the amount being spent on education centrally."]
[]
[null,"Table A1"]
[]
[null,"This relates to the expenditure on children’s and young people’s services including: sure start children's centres and early years, children looked after, other children and family services, safeguarding children and young people’s services, family support services, services for young people and youth justice."]
[]
[null,"Values should be entered in all red cells. If the value entered does not match the data validation restrictions for the cell, an error message will be displayed. You will still be able to submit your return, but you will be prompted to enter an explanation within COLLECT."]
[]
[]
[null,"Uploading the return to COLLECT"]
[]
[null,"When you have finished entering your data, click the ‘Convert to XML’ button on the Cover Sheet. This will create an XML file for uploading to COLLECT."]
[null,"Guidance on using COLLECT to upload and submit your data is available at: https://www.gov.uk/government/publications/section-251-2022-to-2023."]

{"sheet":"Cover Sheet","index":1,"n_rows":21,"n_cols":4,"rows_kept":21,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[null,null,null,"Section 251 Outturn 2022-23"]
[null,null,null,"XML Generator"]
[null,null,null,"Version 1.0"]
[]
[]
[]
[]
[null,"Local Authority Number:",null,"C13: 1.1: Value is missing. Do not leave any cell blank.\r\n"]
[]
[null,"Local Authority Name:",{"$f":"IF(ISNA(VLOOKUP(C13,LA, 2, FALSE)),\"\",VLOOKUP(C13, LA, 2, FALSE))","v":""}]
[]
[null,"Contact Name:",null,"C17: 1.1: Value is missing. Do not leave any cell blank.\r\n"]
[]
[null,"Contact Email:",null,"C19: 1.1: Value is missing. Do not leave any cell blank.\r\n"]
[]
[null,"Contact Telephone:",null,"C21: 1.1: Value is missing. Do not leave any cell blank.\r\n"]

{"sheet":"Table A","index":2,"n_rows":124,"n_cols":26,"rows_kept":124,"cut":false,"hidden":false,"merged":[[2,16,2,24],[74,4,74,6],[77,4,77,6]]}
[null,"S251 Outturn 2022-23",null,null,"Please enable macros before entering data"]
[null,"TABLE A:  LA LEVEL INFORMATION"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Rule Application (offset by 12 columns to data)"]
[null,null,"Description",null,"Early Years","Primary","Secondary","SEN/Special Schools ","AP/PRUs","Post school ","Gross","Income","Net",null,"Error Cell Reference and Description",null,"Early Years","Primary","Secondary","SEN/Special Schools ","AP/PRUs","Post school ","Gross","Income","Net","Notes"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"(only 1.1, 1.3, 1.4, 1.6, 1021 & Decimal check will be implemented)"]
[null,null,null,null,{"$f":"IF(COUNTA(E9:M124)<447,\"PLEASE ENTER VALUES IN ALL CELLS\",\"\")","v":"PLEASE ENTER VALUES IN ALL CELLS"},null,null,null,null,null,null,null,"LA Table Errors:",null,null,null,"E","F","G","H","I","J","K","L","M"]
[null,1,"SCHOOLS EXPENDITURE"]
[]
[null,"1.0.1","Individual Schools Budget (after academies recoupment), including grant for maintained school sixth forms but excluding all high needs place funding",null,null,null,null,null,null,null,{"$f":"SUM(E9:J9)","v":0},null,{"$f":"K9-L9","v":0},null,null,null,"1.1,1.3","1.1,1.3","1.1,1.3",1.6,1.6,1.6," \n3.1.1, 1007",1.6," "]
[null,"1.0.2","High needs place funding within Individual Schools Budget (after academies recoupment), including all pre- and post-16 place funding for maintained schools",null,null,null,null,null,null,null,{"$f":"SUM(E10:J10)","v":0},null,{"$f":"K10-L10","v":0},null,null,null,"1.1,1.3","1.1,1.3","1.1,1.3","1.1,1.3","1.1,1.3",1.6," \n3.1.1, 1007, 1022",1.6," "]
[]
[null,null,"DE-DELEGATED ITEMS      "]
[null,"1.1.1","Contingencies      ",null,null,null,null,null,null,null,{"$f":"SUM(E13:J13)","v":0},null,{"$f":"K13-L13","v":0},null,null,null,1.6,"1.1,1.3","1.1,1.3",1.6,1.6,1.6," \n3.1.1, 1010, 1007, 1008","1.1,1.3"," "]
[null,"1.1.2","Behaviour support services",null,null,null,null,null,null,null,0,null,0,null,null,null,1.6,"1.1,1.3","1.1,1.3",1.6,1.6,1.6," \n3.1.1, 1010, 1007, 1008","1.1,1.3"," "]
[null,"1.1.3","Support to UPEG and bilingual learners  ",null,null,null,null,null,null,null,0,null,0,null,null,null,1.6,"1.1,1.3","1.1,1.3",1.6,1.6,1.6," \n3.1.1, 1010, 1007, 1008","1.1,1.3"," "]
[null,"1.1.4","Free school meals eligibility",null,null,null,null,null,null,null,0,null,0,null,null,null,1.6,"1.1,1.3","1.1,1.3",1.6,1.6,1.6," \n3.1.1, 1010, 1007, 1008","1.1,1.3"," "]
[null,"1.1.5","Insurance",null,null,null,null,null,null,null,0,null,0,null,null,null,1.6,"1.1,1.3","1.1,1.3",1.6,1.6,1.6," \n3.1.1, 1010, 1007, 1008","1.1,1.3"," "]
[null,"1.1.6","Museum and Library services",null,null,null,null,null,null,null,0,null,0,null,null,null,1.6,"1.1,1.3","1.1,1.3",1.6,1.6,1.6," \n3.1.1, 1010, 1007, 1008","1.1,1.3"," "]
[null,"1.1.7","Licences/subscriptions ",null,null,null,null,null,null,null,0,null,0,null,null,null,1.6,"1.1,1.3","1.1,1.3",1.6,1.6,1.6," \n3.1.1, 1010, 1007, 1008","1.1,1.3"," "]
[null,"1.1.8","Staff costs - supply cover excluding cover for facility time",null,null,null,null,null,null,null,0,null,0,null,null,null,1.6,"1.1,1.3","1.1,1.3",1.6,1.6,1.6," \n3.1.1, 1010, 1007, 1008","1.1,1.3"," "]
[null,"1.1.9","Staff costs - supply cover for facility time",null,null,null,null,null,null,null,0,null,0,null,null,null,1.6,"1.1,1.3","1.1,1.3",1.6,1.6,1.6," \n3.1.1, 1010, 1007, 1008","1.1,1.3"," "]
[]
[null,null,"HIGH NEEDS EXPENDITURE"]
[null,"1.2.1","Top up funding - maintained schools",null,null,null,null,null,null,null,{"$f":"SUM(E24:J24)","v":0},null,{"$f":"K24-L24","v":0},null,null,null,"1.1,1.3","1.1,1.3","1.1,1.3","1.1,1.3","1.1,1.3",1.6," \n3.1.1, 1010, 1007, 1008","1.1,1.3"," "]
[null,"1.2.2","Top-up funding – academies, free schools and colleges",null,null,null,null,null,null,null,0,null,0,null,null,null,"1.1,1.3","1.1,1.3","1.1,1.3","1.1,1.3","1.1,1.3","1.1,1.3"," \n3.1.1, 1010, 1007, 1008","1.1,1.3"," "]
[null,"1.2.3","Top-up and other funding – non-maintained and independent providers",null,null,null,null,null,null,null,0,null,0,null,null,null,"1.1,1.3","1.1,1.3","1.1,1.3","1.1,1.3","1.1,1.3","1.1,1.3"," \n3.1.1, 1010, 1007, 1008","1.1,1.3"," "]
[null,"1.2.4","Additional high needs targeted funding for mainstream schools and academies",null,null,null,null,null,null,null,0,null,0,null,null,null,"1.1,1.3","1.1,1.3","1.1,1.3",1.6,1.6,1.6," \n3.1.1, 1010, 1007, 1008","1.1,1.3"," "]
[null,"1.2.5","SEN support services  ",null,null,null,null,null,null,null,0,null,0,null,null,null,"1.1,1.3","1.1,1.3","1.1,1.3","1.1,1.3","1.1,1.3","1.1,1.3"," \n3.1.1, 1010, 1007, 1008","1.1,1.3"," "]
[null,"1.2.6","Hospital education services  ",null,null,null,null,null,null,null,0,null,0,null,null,null,1.6,1.6,1.6,"1.1,1.3","1.1,1.3",1.6," \n3.1.1, 1010, 1007, 1008","1.1,1.3"," "]
[null,"1.2.7","Other alternative provision services",null,null,null,null,null,null,null,0,null,0,null,null,null,"1.1,1.3","1.1,1.3","1.1,1.3","1.1,1.3","1.1,1.3","1.1,1.3"," \n3.1.1, 1010, 1007, 1008","1.1,1.3"," "]
[null,"1.2.8","Support for inclusion ",null,null,null,null,null,null,null,0,null,0,null,null,null,"1.1,1.3","1.1,1.3","1.1,1.3","1.1,1.3","1.1,1.3","1.1,1.3"," \n3.1.1, 1010, 1007, 1008","1.1,1.3"," "]
[null,"1.2.9","Special schools and PRUs in financial difficulty",null,null,null,null,null,null,null,0,null,0,null,null,null,1.6,1.6,1.6,"1.1,1.3","1.1,1.3",1.6," \n3.1.1, 1010, 1007, 1008","1.1,1.3"," "]
[null,"1.2.10","PFI and BSF costs at special schools, AP/ PRUs and Post 16 institutions only",null,null,null,null,null,null,null,0,null,0,null,null,null,1.6,1.6,1.6,"1.1,1.3","1.1,1.3","1.1,1.3"," \n3.1.1, 1010, 1007, 1008","1.1,1.3"," "]
[null,"1.2.11","Direct payments (SEN and disability) ",null,null,null,null,null,null,null,0,null,0,null,null,null,"1.1,1.3","1.1,1.3","1.1,1.3","1.1,1.3","1.1,1.3","1.1,1.3"," \n3.1.1, 1010, 1007, 1008","1.1,1.3"," "]
[null,"1.2.12","Carbon reduction commitment allowances (PRUs)",null,null,null,null,null,null,null,0,null,0,null,null,null,1.6,1.6,1.6,1.6,"1.1,1.3",1.6," \n3.1.1, 1010, 1007, 1008","1.1,1.3"," "]
[null,"1.2.13","Therapies and other health related services",null,null,null,null,null,null,null,0,null,0,null,null,null,"1.1,1.3","1.1,1.3","1.1,1.3","1.1,1.3","1.1,1.3","1.1,1.3"," \n3.1.1, 1010, 1007, 1008","1.1,1.3"," "]
[]
[null,null,"EARLY YEARS EXPENDITURE"]
[null,"1.3.1","Central expenditure on early years entitlement ",null,null,null,null,null,null,null,{"$f":"SUM(E39:J39)","v":0},null,{"$f":"K39-L39","v":0},null,null,null,"1.1,1.3",1.6,1.6,1.6,1.6,1.6," \n3.1.1, 1010, 1007, 1008","1.1,1.3"," "]
[]
[null,null,"CENTRAL PROVISION WITHIN SCHOOLS SPEND"]
[null,"1.4.1","Contribution to combined expenditure",null,null,null,null,null,null,null,{"$f":"SUM(E42:J42)","v":0},null,{"$f":"K42-L42","v":0},null,null,null,"1.1,1.3","1.1,1.3","1.1,1.3","1.1,1.3","1.1,1.3",1.6," \n3.1.1, 1010, 1007, 1008","1.1,1.3"]
[null,"1.4.2","School admissions",null,null,null,null,null,null,null,0,null,0,null,null,null,"1.1,1.3","1.1,1.3","1.1,1.3","1.1,1.3","1.1,1.3",1.6," \n3.1.1, 1010, 1007, 1008","1.1,1.3"]
[null,"1.4.3","Servicing of schools forums",null,null,null,null,null,null,null,0,null,0,null,null,null,"1.1,1.3","1.1,1.3","1.1,1.3","1.1,1.3","1.1,1.3",1.6," \n3.1.1, 1010, 1007, 1008","1.1,1.3"]
[null,"1.4.4","Termination of employment costs",null,null,null,null,null,null,null,0,null,0,null,null,null,"1.1,1.3","1.1,1.3","1.1,1.3","1.1,1.3","1.1,1.3",1.6," \n3.1.1, 1010, 1007, 1008","1.1,1.3"]
[null,"1.4.5","Falling Rolls Fund",null,null,null,null,null,null,null,0,null,0,null,null,null,"1.1,1.3","1.1,1.3","1.1,1.3","1.1,1.3","1.1,1.3",1.6," \n3.1.1, 1010, 1007, 1008","1.1,1.3"]
[null,"1.4.6","Capital expenditure from revenue (CERA)",null,null,null,null,null,null,null,0,null,0,null,null,null,"1.1,1.3","1.1,1.3","1.1,1.3","1.1,1.3","1.1,1.3",1.6," \n3.1.1, 1010, 1007, 1008","1.1,1.3"]
[null,"1.4.7","Prudential borrowing costs",null,null,null,null,null,null,null,0,null,0,null,null,null,"1.1,1.3","1.1,1.3","1.1,1.3","1.1,1.3","1.1,1.3",1.6," \n3.1.1, 1010, 1007, 1008","1.1,1.3"]
[null,"1.4.8","Fees to independent schools without SEN ",null,null,null,null,null,null,null,0,null,0,null,null,null,"1.1,1.3","1.1,1.3","1.1,1.3","1.1,1.3","1.1,1.3",1.6," \n3.1.1, 1010, 1007, 1008","1.1,1.3"]
[null,"1.4.9","Equal pay - back pay   ",null,null,null,null,null,null,null,0,null,0,null,null,null,"1.1,1.3","1.1,1.3","1.1,1.3","1.1,1.3","1.1,1.3",1.6," \n3.1.1, 1010, 1007, 1008","1.1,1.3"]
[null,"1.4.10","Pupil growth",null,null,null,null,null,null,null,0,null,0,null,null,null,"1.1,1.3","1.1,1.3","1.1,1.3","1.1,1.3","1.1,1.3",1.6," \n3.1.1, 1010, 1007, 1008","1.1,1.3"]
[null,"1.4.11","SEN transport",null,null,null,null,null,null,null,0,null,0,null,null,null,"1.1,1.3","1.1,1.3","1.1,1.3","1.1,1.3","1.1,1.3","1.1,1.3"," \n3.1.1, 1010, 1007, 1008","1.1,1.3"]
[null,"1.4.12","Exceptions agreed by Secretary of State ",null,null,null,null,null,null,null,0,null,0,null,null,null,"1.1,1.3","1.1,1.3","1.1,1.3","1.1,1.3","1.1,1.3","1.1,1.3","\n3.1.1, 1010, 1007, 1008, 1013","1.1,1.3"]
[null,"1.4.13","Infant class sizes",null,null,null,null,null,null,null,0,null,0,null,null,null,1.6,"1.1,1.3",1.6,1.6,1.6,1.6,"\n3.1.1, 1010, 1007, 1008","1.1,1.3"," "]
[null,"1.4.14","Other items",null,null,null,null,null,null,null,0,null,0,null,null,null,"1.1,1.3","1.1,1.3","1.1,1.3","1.1,1.3","1.1,1.3","1.1,1.3"," \n3.1.1, 1010, 1007, 1008",1.6," "]
[]
[null,null,"CENTRAL PROVISION WITHIN SCHOOLS SPEND (FORMER ESG RETAINED DUTIES)"]
[null,"1.5.1","Education welfare service",null,null,null,null,null,null,null,null,null,{"$f":"K58-L58","v":0},null,null,null,null,null,null,null,null,null,"1.1, 1.3, 3.1.1, 1007, 1010, 1008","1.1,1.3"," "]
[null,"1.5.2","Asset management ",null,null,null,null,null,null,null,null,null,{"$f":"K59-L59","v":0},null,null,null,null,null,null,null,null,null,"1.1, 1.3, 3.1.1, 1007, 1010, 1008","1.1,1.3"," "]
[null,"1.5.3","Statutory/ Regulatory duties",null,null,null,null,null,null,null,null,null,{"$f":"K60-L60","v":0},null,null,null,null,null,null,null,null,null,"1.1, 1.3, 3.1.1, 1007, 1010, 1008","1.1,1.3"," "]
[]
[null,null,"CENTRAL PROVISION FUNDED THROUGH MAINTAINED SCHOOLS SPEND"]
[null,"1.6.1","Central support services ",null,null,null,null,null,null,null,null,null,{"$f":"K63-L63","v":0},null,null,null,null,null,null,null,null,null,"1.1, 1.3, 3.1.1, 1007, 1010, 1008","1.1,1.3"," "]
[null,"1.6.2","Education welfare service",null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,"1.1, 1.3, 3.1.1, 1007, 1010, 1008","1.1,1.3"," "]
[null,"1.6.3","Asset management ",null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,"1.1, 1.3, 3.1.1, 1007, 1010, 1008","1.1,1.3"," "]
[null,"1.6.4","Statutory/ Regulatory duties",null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,"1.1, 1.3, 3.1.1, 1007, 1010, 1008","1.1,1.3"," "]
[null,"1.6.5","Premature retirement cost/ Redundancy costs (new provisions)",null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,"1.1, 1.3, 3.1.1, 1007, 1010, 1008","1.1,1.3"," "]
[null,"1.6.6","Monitoring national curriculum assessment",null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,"1.1, 1.3, 3.1.1, 1007, 1010, 1008","1.1,1.3"," "]
[null,"1.6.7","School improvement",null,null,null,null,null,null,null,null,null,{"$f":"K69-L69","v":0},null,null,null,null,null,null,null,null,null,"1.1, 1.3, 3.1.1, 1007, 1010, 1008","1.1,1.3"]
[]
[null,"1.7.1","Other Specific Grants ",null,null,null,null,null,null,null,{"$f":"SUM(E71:J71)","v":0},null,0,null,null,null,"1.1,1.3,1021","1.1,1.3,1021","1.1,1.3,1021","1.1,1.3,1021","1.1,1.3,1021","1.1,1.3,1021"," 3.1.1, 1010, 1007, 1008","1.1,1.3,1021",1021,"Note that 2021 only needs to be applied to the Net column, but has to be triggered by the rest of the data entry fields"]
[]
[null,"1.8.1","TOTAL SCHOOLS EXPENDITURE (after academy recoupment)",null,{"$f":"SUM(E9:E71)","v":0},0,0,0,0,0,0,0,0]
[]
[null,"1.8.1a","DSG BLOCK Expenditure",null,"Block\n",null,null,"Allocated DSG funding\n","Expenditure\n","Net\n"]
[null,"Schools",null,null,"Schools (after academies recoupment)",null,null,null,null,{"$f":"H76-I76","v":0},null,null,null,null,null,null,null,null,null,"1.1,1.7, 1.3, 1027","1.1,1.7, 1.3, 1.4"]
[null,"Central School Services",null,null,"Central School Services",null,null,null,null,{"$f":"H77-I77","v":0},null,null,null,null,null,null,null,null,null,"1.1,1.7, 1.3, 1028","1.1,1.7, 1.3, 1.4"]
[null,"High Needs",null,null,"High Needs (after deductions for academies recoupment and direct funding of high needs places by ESFA)",null,null,null,null,{"$f":"H78-I78","v":0},null,null,null,null,null,null,null,null,null,"1.1,1.7, 1.3, 1029","1.1,1.7, 1.3, 1.4"]
[null,"Early Years",null,null,"Early Years",null,null,null,null,{"$f":"H79-I79","v":0},null,null,null,null,null,null,null,null,null,"1.1,1.7, 1.3, 1030","1.1,1.7, 1.3, 1.4"]
[null,null,null,null,"Total",null,null,{"$f":"SUM(H76:H79)","v":0},{"$f":"SUM(I76:I79)","v":0},{"$f":"SUM(J76:J79)","v":0}]
[]
[null,null,"RECONCILIATION OF SCHOOLS EXPENDITURE"]
[null,"1.9.1","Dedicated Schools Grant for 2022-23 (after deductions for academies recoupment and direct funding of high needs places by ESFA)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1.1, 1.3, 1023"]
[null,"1.9.1a","Dedicated Schools Grant in year adjustments",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.1000000000000001]
[null,"1.9.2","Dedicated Schools Grant brought forward from 2021-22 (please show a deficit as a negative)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1.1, 1031"]
[null,"1.9.3","Dedicated Schools Grant carry forward to 2023-24 (please show a deficit as a positive)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1.1, 1032"]
[null,"1.9.4","Grant for maintained school sixth forms",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1.1, 1.3, 1025"]
[null,"1.9.5","Local Authority additional contribution   ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1.1, 1.3"]
[null,"1.9.6","Total funding supporting the Schools Expenditure (lines 1.9.1 to 1.9.5)  ",null,null,null,null,null,null,null,{"$f":"SUM(K83:K88)","v":0}]
[]
[null,2,"OTHER EDUCATION AND COMMUNITY EXPENDITURE"]
[]
[null,"2.0.1","Central support services ",null,null,null,null,null,null,null,null,null,{"$f":"K93-L93","v":0},null,null,null,null,null,null,null,null,null,"1.1, 1.3, 3.1.1, 1010, 1007, 1008","1.1, 1.3"," "]
[null,"2.0.2","Education welfare service",null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,"1.1, 1.3, 3.1.1, 1010, 1007, 1008","1.1, 1.3"," "]
[null,"2.0.3","School improvement",null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,"1.1, 1.3, 3.1.1, 1010, 1007, 1008","1.1, 1.3"," "]
[null,"2.0.4","Asset management - education",null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,"1.1, 1.3, 3.1.1, 1010, 1007, 1008","1.1, 1.3"," "]
[null,"2.0.5","Statutory/ Regulatory duties - education",null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,"1.1, 1.3, 3.1.1, 1010, 1007, 1008","1.1, 1.3"," "]
[null,"2.0.6","Premature retirement cost/ Redundancy costs (new provisions)",null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,"1.1, 1.3, 3.1.1, 1010, 1007, 1008","1.1, 1.3"," "]
[null,"2.0.7","Monitoring national curriculum assessment",null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,"1.1, 1.3, 3.1.1, 1010, 1007, 1008","1.1, 1.3"," "]
[]
[null,"2.1.1","Educational psychology service",null,null,null,null,null,null,null,null,null,{"$f":"K101-L101","v":0},null,null,null,null,null,null,null,null,null,"1.1, 1.3, 3.1.1, 1010, 1007, 1008","1.1, 1.3"," "]
[null,"2.1.2","SEN administration, assessment and coordination and monitoring",null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,"1.1, 1.3, 3.1.1, 1010, 1007, 1008","1.1, 1.3"," "]
[null,"2.1.3","Independent Advice and Support Services (Parent partnership), guidance and information",null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,"1.1, 1.3, 3.1.1, 1010, 1007, 1008","1.1, 1.3"," "]
[null,"2.1.4","Home to school transport (pre 16): SEN transport expenditure",null,null,null,null,null,null,null,{"$f":"SUM(E104:J104)","v":0},null,0,null,null,null,"1.1,1.3","1.1,1.3","1.1,1.3","1.1,1.3","1.1,1.3",1.6," \n3.1.1, 1010, 1007, 1008","1.1, 1.3"," "]
[null,"2.1.5","Home to school transport (pre 16): mainstream home to school transport expenditure",null,null,null,null,null,null,null,{"$f":"SUM(E105:J105)","v":0},null,0,null,null,null,"1.1,1.3","1.1,1.3","1.1,1.3","1.1,1.3","1.1,1.3",1.6," \n3.1.1, 1010, 1007, 1008","1.1, 1.3"," "]
[null,"2.1.6","Home to post-16 provision: SEN/LLDD transport expenditure (aged 16-18)",null,null,null,null,null,null,null,0,null,0,null,null,null,1.6,1.6,"1.1,1.3","1.1,1.3","1.1,1.3","1.1,1.3"," \n3.1.1, 1010, 1007, 1008","1.1, 1.3"," "]
[null,"2.1.7","Home to post-16 provision: SEN/LLDD transport expenditure (aged 19-25)",null,null,null,null,null,null,null,0,null,0,null,null,null,1.6,1.6,"1.1,1.3","1.1,1.3","1.1,1.3","1.1,1.3"," \n3.1.1, 1010, 1007, 1008","1.1, 1.3"," "]
[null,"2.1.8","Home to post-16 provision transport: mainstream home to post-16 transport expenditure      ",null,null,null,null,null,null,null,0,null,0,null,null,null,1.6,1.6,"1.1,1.3","1.1,1.3","1.1,1.3","1.1,1.3"," \n3.1.1, 1010, 1007, 1008","1.1, 1.3"," "]
[null,"2.1.9","Supply of school places",null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,"1.1, 1.3, 3.1.1, 1010, 1007, 1008","1.1, 1.3"," "]
[]
[null,"2.2.1","Other spend not funded from the Schools Budget ",null,null,null,null,null,null,null,null,null,{"$f":"K111-L111","v":0},null,null,null,null,null,null,null,null,null,"1.1, 1.3, 3.1.1, 1010, 1007, 1008","1.1, 1.3"," "]
[]
[null,"2.3.1","Young people's learning and development",null,null,null,null,null,null,null,{"$f":"SUM(E113:J113)","v":0},null,{"$f":"K113-L113","v":0},null,null,null,1.6,1.6,"1.1,1.3","1.1,1.3","1.1,1.3","1.1,1.3"," \n3.1.1, 1010, 1007, 1008","1.1, 1.3"," "]
[null,"2.3.2","Adult and Community learning",null,null,null,null,null,null,null,null,null,{"$f":"K114-L114","v":0},null,null,null,null,null,null,null,null,null,"1.1, 1.3, 3.1.1, 1010, 1007, 1008","1.1, 1.3"," "]
[null,"2.3.3","Pension costs",null,null,null,null,null,null,null,null,null,{"$f":"K115-L115","v":0},null,null,null,null,null,null,null,null,null,"1.1, 1.3, 3.1.1, 1010, 1007, 1008","1.1, 1.3"," "]
[null,"2.3.4","Joint use arrangements",null,null,null,null,null,null,null,null,null,{"$f":"K116-L116","v":0},null,null,null,null,null,null,null,null,null,"1.1, 1.3, 3.1.1, 1010, 1007, 1008","1.1, 1.3"," "]
[null,"2.3.5","Insurance",null,null,null,null,null,null,null,null,null,{"$f":"K117-L117","v":0},null,null,null,null,null,null,null,null,null,"1.1, 1.3, 3.1.1, 1010, 1007, 1008","1.1, 1.3"," "]
[]
[null,"2.4.1","Other Specific Grant ",null,null,null,null,null,null,null,null,null,{"$f":"K119-L119","v":0},null,null,null,null,null,null,null,null,null,"1.1, 1.3, 3.1.1, 1010, 1007, 1008,1021","1.1, 1.3, 1021",1021,"Note that 2021 only needs to be applied to the Net column, but has to be triggered by the rest of the data entry fields"]
[null,"2.4.2","Capital Expenditure from Revenue (CERA) (Non-schools budget functions) ",null,null,null,null,null,null,null,null,null,{"$f":"K120-L120","v":0},null,null,null,null,null,null,null,null,null,"1.1, 1.3, 1007","1.1, 1.3"," "]
[null,"2.4.3","Total Other education and community expenditure",null,null,null,null,null,null,null,{"$f":"SUM(K93:K120)","v":0},{"$f":"SUM(L93:L120)","v":0},{"$f":"SUM(M93:M120)","v":0}]
[]
[null,2.5,"CAPITAL"]
[null,"2.5.1","Capital Expenditure (excluding CERA)",null,null,null,null,null,null,null,{"$f":"SUM(E124:J124)","v":0},null,{"$f":"K124-L124","v":0},null,null,null,"1.1,1.3","1.1,1.3","1.1,1.3","1.1,1.3","1.1,1.3",1.6,"3.1.1, 1007","1.1, 1.3"," "]

{"sheet":"Table A1","index":3,"n_rows":70,"n_cols":29,"rows_kept":70,"cut":false,"hidden":false,"merged":[[4,5,4,7],[4,18,4,28]]}
[null,"S251 Outturn 2022-23",null,null,"Please enable macros before entering data"]
[null,"TABLE A1: CHILDREN'S AND YOUNG PEOPLE'S SERVICES"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null," Table A1 Errors:"]
[null,null,null,null,null,"PROVISIONS BY OTHERS",null,null,null,null,null,null,null,null,null,null,null,null,"Rule Application (only 1.1, 1.3, 1.4, 1.6, 1021 & Decimal check will be implemented)"]
[null,null,"Description",null,"OWN PROVISION","PRIVATE","OTHER PUBLIC","VOLUNTARY","TOTAL EXPENDITURE","INCOME","NET Current Expenditure",null,"Govt. Grants Inside AEF ","Govt. Grants Outside AEF ","LEA NET Revenue Expenditure",null,"Error Cell Reference and Description",null,"OWN PROVISION","PRIVATE","OTHER PUBLIC","VOLUNTARY","TOTAL EXPENDITURE","INCOME","NET Current Expenditure",null,"Govt. Grants Inside AEF ","Govt. Grants Outside AEF ","LEA NET Revenue Expenditure"]
[null,null,null,null,"(a)","(b)","(c)","(d)","(k)","(l)","(m)",null,"(n)","(o)","(q)"]
[null,null,null,null,{"$f":"IF(COUNTA(E9:N70)<289,\"PLEASE ENTER VALUES IN ALL CELLS\",\"\")","v":"PLEASE ENTER VALUES IN ALL CELLS"}]
[null,null,"CHILDREN'S AND YOUNG PEOPLE'S SERVICES           "]
[]
[null,null,"SURE START CHILDREN'S CENTRES AND OTHER SPEND ON CHILDREN UNDER 5"]
[null,"3.0.1","Spend on individual Sure Start Children's Centres",null,null,null,null,null,{"$f":"SUM(E12:H12)","v":0},null,{"$f":"I12-J12","v":0},null,null,null,{"$f":"K12-(M12+N12)","v":0},null,null,null,"1.1,1.3","1.1,1.3","1.1,1.3","1.1,1.3","3.1.1,1010,1007,1008","1.1,1.3",null,null,"1.1,1.3","1.1,1.3"]
[null,"3.0.2","Spend for local authority provided or commissioned area wide services delivered through Sure Start Children's Centres",null,null,null,null,null,{"$f":"SUM(E13:H13)","v":0},null,{"$f":"I13-J13","v":0},null,null,null,{"$f":"K13-(M13+N13)","v":0},null,null,null,"1.1,1.3","1.1,1.3","1.1,1.3","1.1,1.3","3.1.1,1010,1007,1008","1.1,1.3",null,null,"1.1,1.3","1.1,1.3"]
[null,"3.0.3","Spend on local authority management costs relating to Sure Start Children's Centres",null,null,null,null,null,{"$f":"SUM(E14:H14)","v":0},null,{"$f":"I14-J14","v":0},null,null,null,0,null,null,null,"1.1,1.3","1.1,1.3","1.1,1.3","1.1,1.3","3.1.1,1010,1007,1008","1.1,1.3",null,null,"1.1,1.3","1.1,1.3"]
[null,"3.0.4","Other spend on children under 5",null,null,null,null,null,{"$f":"SUM(E15:H15)","v":0},null,{"$f":"I15-J15","v":0},null,null,null,0,null,null,null,"1.1,1.3","1.1,1.3","1.1,1.3","1.1,1.3","3.1.1,1010,1007,1008","1.1,1.3",null,null,"1.1,1.3","1.1,1.3"]
[null,"3.0.5","Total Sure Start children's centres and other spend on children under 5",null,{"$f":"SUM(E12:E15)","v":0},0,0,0,{"$f":"SUM(E16:H16)","v":0},0,0,null,{"$f":"SUM(M12:M15)","v":0},{"$f":"SUM(N12:N15)","v":0},{"$f":"SUM(O12:O15)","v":0}]
[]
[null,null,"CHILDREN LOOKED AFTER"]
[null,"3.1.1","Residential care",null,null,null,null,null,{"$f":"SUM(E19:H19)","v":0},null,{"$f":"I19-J19","v":0},null,null,null,{"$f":"K19-(M19+N19)","v":0},null,null,null,"1.1,1.3","1.1,1.3","1.1,1.3","1.1,1.3","3.1.1,1010,1007,1008","1.1,1.3",null,null,"1.1,1.3","1.1,1.3"]
[null,"3.1.2a","Fostering services (excluding fees and allowances for LA foster carers)",null,null,null,null,null,0,null,0,null,null,null,0,null,null,null,"1.1,1.3","1.1,1.3","1.1,1.3","1.1,1.3","3.1.1,1010,1007,1008","1.1,1.3",null,null,"1.1,1.3","1.1,1.3"]
[null,"3.1.2b","Fostering services (fees and allowances for LA foster carers)",null,null,null,null,null,0,null,0,null,null,null,0,null,null,null,"1.1,1.3","1.1,1.3","1.1,1.3","1.1,1.3","3.1.1,1010,1007,1008","1.1,1.3",null,null,"1.1,1.3","1.1,1.3"]
[null,"3.1.3","Adoption services",null,null,null,null,null,0,null,0,null,null,null,0,null,null,null,"1.1,1.3","1.1,1.3","1.1,1.3","1.1,1.3","3.1.1,1010,1007,1008","1.1,1.3",null,null,"1.1,1.3","1.1,1.3"]
[null,"3.1.4","Special guardianship support ",null,null,null,null,null,0,null,0,null,null,null,0,null,null,null,"1.1,1.3","1.1,1.3","1.1,1.3","1.1,1.3","3.1.1,1010,1007,1008","1.1,1.3",null,null,"1.1,1.3","1.1,1.3"]
[null,"3.1.5","Other children looked after services",null,null,null,null,null,0,null,0,null,null,null,0,null,null,null,"1.1,1.3","1.1,1.3","1.1,1.3","1.1,1.3","3.1.1,1010,1007,1008","1.1,1.3",null,null,"1.1,1.3","1.1,1.3"]
[null,"3.1.6","Short breaks (respite) for looked after disabled children",null,null,null,null,null,0,null,0,null,null,null,0,null,null,null,"1.1,1.3","1.1,1.3","1.1,1.3","1.1,1.3","3.1.1,1010,1007,1008","1.1,1.3",null,null,"1.1,1.3","1.1,1.3"]
[null,"3.1.7","Children placed with family and friends",null,null,null,null,null,0,null,0,null,null,null,0,null,null,null,"1.1,1.3","1.1,1.3","1.1,1.3","1.1,1.3","3.1.1,1010,1007,1008","1.1,1.3",null,null,"1.1,1.3","1.1,1.3"]
[null,"3.1.8","Education of looked after children ",null,null,null,null,null,0,null,0,null,null,null,0,null,null,null,"1.1,1.3","1.1,1.3","1.1,1.3","1.1,1.3","3.1.1,1010,1007,1008","1.1,1.3",null,null,"1.1,1.3","1.1,1.3"]
[null,"3.1.9","Leaving care support services",null,null,null,null,null,0,null,0,null,null,null,0,null,null,null,"1.1,1.3","1.1,1.3","1.1,1.3","1.1,1.3","3.1.1,1010,1007,1008","1.1,1.3",null,null,"1.1,1.3","1.1,1.3"]
[null,"3.1.10","Asylum seeker services - children",null,null,null,null,null,0,null,0,null,null,null,0,null,null,null,"1.1,1.3","1.1,1.3","1.1,1.3","1.1,1.3","3.1.1,1010,1007,1008","1.1,1.3",null,null,"1.1,1.3","1.1,1.3"]
[null,"3.1.11","Total Children Looked After",null,{"$f":"SUM(E19:E29)","v":0},{"$f":"SUM(F19:F29)","v":0},0,0,0,0,0,null,{"$f":"SUM(M19:M29)","v":0},{"$f":"SUM(N19:N29)","v":0},{"$f":"SUM(O19:O29)","v":0}]
[]
[null,null,"OTHER CHILDREN AND FAMILY SERVICES"]
[null,"3.2.1","Other children and families services",null,null,null,null,null,{"$f":"SUM(E33:H33)","v":0},null,{"$f":"I33-J33","v":0},null,null,null,{"$f":"K33-(M33+N33)","v":0},null,null,null,"1.1,1.3","1.1,1.3","1.1,1.3","1.1,1.3","3.1.1,1010,1007,1008","1.1,1.3",null,null,"1.1,1.3","1.1,1.3"]
[]
[null,null,"SAFEGUARDING CHILDREN AND YOUNG PEOPLE'S SERVICES"]
[null,"3.3.1","Social work (including LA functions in relation to child protection)",null,null,null,null,null,{"$f":"SUM(E36:H36)","v":0},null,{"$f":"I36-J36","v":0},null,null,null,{"$f":"K36-(M36+N36)","v":0},null,null,null,"1.1,1.3","1.1,1.3","1.1,1.3","1.1,1.3","3.1.1,1010,1007,1008","1.1,1.3",null,null,"1.1,1.3","1.1,1.3"]
[null,"3.3.2","Commissioning and Children's Services Strategy",null,null,null,null,null,{"$f":"SUM(E37:H37)","v":0},null,{"$f":"I37-J37","v":0},null,null,null,0,null,null,null,"1.1,1.3","1.1,1.3","1.1,1.3","1.1,1.3","3.1.1,1010,1007,1008","1.1,1.3",null,null,"1.1,1.3","1.1,1.3"]
[null,"3.3.3","Local Safeguarding Children Board",null,null,null,null,null,{"$f":"SUM(E38:H38)","v":0},null,{"$f":"I38-J38","v":0},null,null,null,0,null,null,null,"1.1,1.3","1.1,1.3","1.1,1.3","1.1,1.3","3.1.1,1010,1007,1008","1.1,1.3",null,null,"1.1,1.3","1.1,1.3"]
[null,"3.3.4","Total Safeguarding Children and Young People's Services",null,{"$f":"SUM(E36:E38)","v":0},{"$f":"SUM(F36:F38)","v":0},0,0,0,0,0,null,{"$f":"SUM(M36:M38)","v":0},{"$f":"SUM(N36:N38)","v":0},{"$f":"SUM(O36:O38)","v":0}]
[]
[null,null,"FAMILY SUPPORT SERVICES"]
[null,"3.4.1","Direct payments",null,null,null,null,null,{"$f":"SUM(E42:H42)","v":0},null,{"$f":"I42-J42","v":0},null,null,null,{"$f":"K42-(M42+N42)","v":0},null,null,null,"1.1,1.3","1.1,1.3","1.1,1.3","1.1,1.3","3.1.1,1010,1007,1008","1.1,1.3",null,null,"1.1,1.3","1.1,1.3"]
[null,"3.4.2","Short breaks (respite) for disabled children",null,null,null,null,null,{"$f":"SUM(E43:H43)","v":0},null,{"$f":"I43-J43","v":0},null,null,null,0,null,null,null,"1.1,1.3","1.1,1.3","1.1,1.3","1.1,1.3","3.1.1,1010,1007,1008","1.1,1.3",null,null,"1.1,1.3","1.1,1.3"]
[null,"3.4.3","Other support for disabled children",null,null,null,null,null,{"$f":"SUM(E44:H44)","v":0},null,{"$f":"I44-J44","v":0},null,null,null,0,null,null,null,"1.1,1.3","1.1,1.3","1.1,1.3","1.1,1.3","3.1.1,1010,1007,1008","1.1,1.3",null,null,"1.1,1.3","1.1,1.3"]
[null,"3.4.4","Targeted family support",null,null,null,null,null,{"$f":"SUM(E45:H45)","v":0},null,{"$f":"I45-J45","v":0},null,null,null,0,null,null,null,"1.1,1.3","1.1,1.3","1.1,1.3","1.1,1.3","3.1.1,1010,1007,1008","1.1,1.3",null,null,"1.1,1.3","1.1,1.3"]
[null,"3.4.5","Universal family support ",null,null,null,null,null,{"$f":"SUM(E46:H46)","v":0},null,{"$f":"I46-J46","v":0},null,null,null,0,null,null,null,"1.1,1.3","1.1,1.3","1.1,1.3","1.1,1.3","3.1.1,1010,1007,1008","1.1,1.3",null,null,"1.1,1.3","1.1,1.3"]
[null,"3.4.6","Total Family Support Services",null,{"$f":"SUM(E42:E46)","v":0},{"$f":"SUM(F42:F46)","v":0},0,0,0,0,0,null,{"$f":"SUM(M42:M46)","v":0},{"$f":"SUM(N42:N46)","v":0},{"$f":"SUM(O42:O46)","v":0}]
[]
[null,null,"SERVICES FOR YOUNG PEOPLE"]
[null,"3.5.1","Universal services for young people",null,null,null,null,null,{"$f":"SUM(E50:H50)","v":0},null,{"$f":"I50-J50","v":0},null,null,null,{"$f":"K50-(M50+N50)","v":0},null,null,null,"1.1,1.3","1.1,1.3","1.1,1.3","1.1,1.3","3.1.1,1010,1007,1008","1.1,1.3",null,null,"1.1,1.3","1.1,1.3"]
[null,"3.5.2","Targeted services for young people ",null,null,null,null,null,{"$f":"SUM(E51:H51)","v":0},null,{"$f":"I51-J51","v":0},null,null,null,0,null,null,null,"1.1,1.3","1.1,1.3","1.1,1.3","1.1,1.3","3.1.1,1010,1007,1008","1.1,1.3",null,null,"1.1,1.3","1.1,1.3"]
[null,"3.5.3","Total Services for young people",null,{"$f":"SUM(E50:E51)","v":0},{"$f":"SUM(F50:F51)","v":0},0,0,0,0,0,null,{"$f":"SUM(M50:M51)","v":0},{"$f":"SUM(N50:N51)","v":0},{"$f":"SUM(O50:O51)","v":0}]
[]
[null,null,"YOUTH JUSTICE"]
[null,"3.6.1","Youth justice",null,null,null,null,null,null,null,{"$f":"I55-J55","v":0},null,null,null,null,null,null,null,null,null,null,null,"1.1,1.3,3.1.1,1010,1007,1008","1.1,1.3"]
[]
[null,"4.0.1","Capital Expenditure from Revenue (CERA) (Children's and young people services)",null,null,null,null,null,null,null,{"$f":"I57-J57","v":0},null,null,null,null,null,null,null,null,null,null,null,"1.1,1.3,3.1.1,1010,1007,1008","1.1,1.3"]
[]
[null,"5.0.1","Do not complete - not applicable"]
[]
[null,"5.0.2","Total Children and Young People's Services Expenditure (excluding CERA)",null,null,null,null,null,{"$f":"I63-I57","v":0},{"$f":"J63-J57","v":0},{"$f":"K63-K57","v":0}]
[]
[null,"5.0.3","Total Children and Young People's Services Expenditure (including CERA)",null,null,null,null,null,{"$f":"I16+I30+I33+I39+I47+I52+I55+I57","v":0},{"$f":"J16+J30+J33+J39+J47+J52+J55+J57","v":0},{"$f":"K16+K30+K33+K39+K47+K52+K55+K57","v":0}]
[]
[]
[null,null,"MEMORANDUM ITEMS"]
[]
[null,8,"Services for young people"]
[null,"8a.1","Substance misuse services (Drugs, Alcohol and Volatile substances) (included in 3.5.1 and 3.5.2 above)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1.1,1.3,6.1,3.1.1,1010,1007,1008"]
[null,"8a.2","Teenage pregnancy services (included in 3.5.1 and 3.5.2 above)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1.1,1.3,6.2,1007,3.1.1,1008,1010"]

{"sheet":"Admin-MissingRowCheck","index":4,"n_rows":94,"n_cols":11,"rows_kept":94,"cut":false,"hidden":true,"merged":[]}
["Table A - Error 1033 information for error message",null,null,"Missing rows",null,null,null,"Table A1",null,null,"Missing rows"]
["Required Row Numbers","Are they present? If not output the number in column C to add to end of 1033 error message","Check for isna",{"$f":"_xlfn.CONCAT(C3:C151)","v":""},null,null,null,"Required Rows","Are they present? If not output the number in column C to add to end of 1033 error message","Check for isna",{"$f":"_xlfn.CONCAT(J3:J151)","v":""}]
[1,{"$f":"VLOOKUP(A3,LARowCount,1,FALSE)","v":1},{"$f":"IF(ISNA(B3),\", \"&A3,\"\")","v":""},null,null,null,null,"3.0.1",{"$f":"VLOOKUP(H3,'Table A1'!B:B,1,FALSE)","v":"3.0.1"},{"$f":"IF(ISNA(I3),\", \"&H3,\"\")","v":""}]
["1.0.1",{"$f":"VLOOKUP(A4,LARowCount,1,FALSE)","v":"1.0.1"},{"$f":"IF(ISNA(B4),\", \"&A4,\"\")","v":""},null,null,null,null,"3.0.2",{"$f":"VLOOKUP(H4,'Table A1'!B:B,1,FALSE)","v":"3.0.2"},{"$f":"IF(ISNA(I4),\", \"&H4,\"\")","v":""}]
["1.0.2","1.0.2","",null,null,null,null,"3.0.3",{"$f":"VLOOKUP(H5,'Table A1'!B:B,1,FALSE)","v":"3.0.3"},""]
["1.1.1","1.1.1","",null,null,null,null,"3.0.4",{"$f":"VLOOKUP(H6,'Table A1'!B:B,1,FALSE)","v":"3.0.4"},""]
["1.1.2","1.1.2","",null,null,null,null,"3.0.5",{"$f":"VLOOKUP(H7,'Table A1'!B:B,1,FALSE)","v":"3.0.5"},""]
["1.1.3","1.1.3","",null,null,null,null,"3.1.1",{"$f":"VLOOKUP(H8,'Table A1'!B:B,1,FALSE)","v":"3.1.1"},""]
["1.1.4","1.1.4","",null,null,null,null,"3.1.2a",{"$f":"VLOOKUP(H9,'Table A1'!B:B,1,FALSE)","v":"3.1.2a"},""]
["1.1.5","1.1.5","",null,null,null,null,"3.1.2b",{"$f":"VLOOKUP(H10,'Table A1'!B:B,1,FALSE)","v":"3.1.2b"},""]
["1.1.6","1.1.6","",null,null,null,null,"3.1.3",{"$f":"VLOOKUP(H11,'Table A1'!B:B,1,FALSE)","v":"3.1.3"},""]
["1.1.7","1.1.7","",null,null,null,null,"3.1.4",{"$f":"VLOOKUP(H12,'Table A1'!B:B,1,FALSE)","v":"3.1.4"},""]
["1.1.8","1.1.8","",null,null,null,null,"3.1.5",{"$f":"VLOOKUP(H13,'Table A1'!B:B,1,FALSE)","v":"3.1.5"},""]
["1.1.9","1.1.9","",null,null,null,null,"3.1.6",{"$f":"VLOOKUP(H14,'Table A1'!B:B,1,FALSE)","v":"3.1.6"},""]
[null,null,"",null,null,null,null,"3.1.7",{"$f":"VLOOKUP(H15,'Table A1'!B:B,1,FALSE)","v":"3.1.7"},""]
["1.2.1","1.2.1","",null,null,null,null,"3.1.8",{"$f":"VLOOKUP(H16,'Table A1'!B:B,1,FALSE)","v":"3.1.8"},""]
["1.2.2","1.2.2","",null,null,null,null,"3.1.9",{"$f":"VLOOKUP(H17,'Table A1'!B:B,1,FALSE)","v":"3.1.9"},""]
["1.2.3","1.2.3","",null,null,null,null,"3.1.10",{"$f":"VLOOKUP(H18,'Table A1'!B:B,1,FALSE)","v":"3.1.10"},""]
["1.2.4","1.2.4","",null,null,null,null,"3.1.11",{"$f":"VLOOKUP(H19,'Table A1'!B:B,1,FALSE)","v":"3.1.11"},""]
["1.2.5","1.2.5","",null,null,null,null,"3.2.1",{"$f":"VLOOKUP(H20,'Table A1'!B:B,1,FALSE)","v":"3.2.1"},""]
["1.2.6","1.2.6","",null,null,null,null,"3.3.1",{"$f":"VLOOKUP(H21,'Table A1'!B:B,1,FALSE)","v":"3.3.1"},""]
["1.2.7","1.2.7","",null,null,null,null,"3.3.2",{"$f":"VLOOKUP(H22,'Table A1'!B:B,1,FALSE)","v":"3.3.2"},""]
["1.2.8","1.2.8","",null,null,null,null,"3.3.3",{"$f":"VLOOKUP(H23,'Table A1'!B:B,1,FALSE)","v":"3.3.3"},""]
["1.2.9","1.2.9","",null,null,null,null,"3.3.4",{"$f":"VLOOKUP(H24,'Table A1'!B:B,1,FALSE)","v":"3.3.4"},""]
["1.2.10","1.2.10","",null,null,null,null,"3.4.1",{"$f":"VLOOKUP(H25,'Table A1'!B:B,1,FALSE)","v":"3.4.1"},""]
["1.2.11","1.2.11","",null,null,null,null,"3.4.2",{"$f":"VLOOKUP(H26,'Table A1'!B:B,1,FALSE)","v":"3.4.2"},""]
["1.2.12","1.2.12","",null,null,null,null,"3.4.3",{"$f":"VLOOKUP(H27,'Table A1'!B:B,1,FALSE)","v":"3.4.3"},""]
["1.2.13","1.2.13","",null,null,null,null,"3.4.4",{"$f":"VLOOKUP(H28,'Table A1'!B:B,1,FALSE)","v":"3.4.4"},""]
["1.3.1","1.3.1","",null,null,null,null,"3.4.5",{"$f":"VLOOKUP(H29,'Table A1'!B:B,1,FALSE)","v":"3.4.5"},""]
["1.4.1","1.4.1","",null,null,null,null,"3.4.6",{"$f":"VLOOKUP(H30,'Table A1'!B:B,1,FALSE)","v":"3.4.6"},""]
["1.4.2","1.4.2","",null,null,null,null,"3.5.1",{"$f":"VLOOKUP(H31,'Table A1'!B:B,1,FALSE)","v":"3.5.1"},""]
["1.4.3","1.4.3","",null,null,null,null,"3.5.2",{"$f":"VLOOKUP(H32,'Table A1'!B:B,1,FALSE)","v":"3.5.2"},""]
["1.4.4","1.4.4","",null,null,null,null,"3.5.3",{"$f":"VLOOKUP(H33,'Table A1'!B:B,1,FALSE)","v":"3.5.3"},""]
["1.4.5","1.4.5","",null,null,null,null,"3.6.1",{"$f":"VLOOKUP(H34,'Table A1'!B:B,1,FALSE)","v":"3.6.1"},""]
["1.4.6",{"$f":"VLOOKUP(A35,LARowCount,1,FALSE)","v":"1.4.6"},"",null,null,null,null,"4.0.1",{"$f":"VLOOKUP(H35,'Table A1'!B:B,1,FALSE)","v":"4.0.1"},""]
["1.4.7","1.4.7","",null,null,null,null,"5.0.1",{"$f":"VLOOKUP(H36,'Table A1'!B:B,1,FALSE)","v":"5.0.1"},""]
["1.4.8","1.4.8","",null,null,null,null,"5.0.2",{"$f":"VLOOKUP(H37,'Table A1'!B:B,1,FALSE)","v":"5.0.2"},""]
["1.4.9","1.4.9","",null,null,null,null,"5.0.3",{"$f":"VLOOKUP(H38,'Table A1'!B:B,1,FALSE)","v":"5.0.3"},""]
["1.4.10","1.4.10","",null,null,null,null,8,{"$f":"VLOOKUP(H39,'Table A1'!B:B,1,FALSE)","v":8},""]
["1.4.11","1.4.11","",null,null,null,null,"8a.1",{"$f":"VLOOKUP(H40,'Table A1'!B:B,1,FALSE)","v":"8a.1"},""]
["1.4.12","1.4.12","",null,null,null,null,"8a.2",{"$f":"VLOOKUP(H41,'Table A1'!B:B,1,FALSE)","v":"8a.2"},""]
["1.4.13","1.4.13",""]
["1.4.14","1.4.14",""]
["1.5.1","1.5.1",""]
["1.5.2","1.5.2",""]
["1.5.3","1.5.3",""]
["1.6.1","1.6.1",""]
["1.6.2","1.6.2",""]
["1.6.3","1.6.3",""]
["1.6.4","1.6.4",""]
["1.6.5","1.6.5",""]
["1.6.6","1.6.6",""]
["1.6.7","1.6.7"]
["1.7.1","1.7.1",""]
["1.8.1","1.8.1",""]
["1.8.1a","1.8.1a",""]
["Schools","Schools",""]
["Central School Services","Central School Services",""]
["High Needs","High Needs",""]
["Early Years","Early Years",""]
["1.9.1","1.9.1",""]
["1.9.2","1.9.2",""]
["1.9.3","1.9.3",""]
["1.9.4","1.9.4",""]
["1.9.5","1.9.5",""]
["1.9.6","1.9.6",""]
[2,2,""]
["2.0.1",{"$f":"VLOOKUP(A68,LARowCount,1,FALSE)","v":"2.0.1"},""]
["2.0.2","2.0.2",{"$f":"IF(ISNA(B69),\", \"&A69,\"\")","v":""}]
["2.0.3","2.0.3",""]
["2.0.4","2.0.4",""]
["2.0.5","2.0.5",""]
["2.0.6","2.0.6",""]
["2.0.7","2.0.7",""]
["2.1.1","2.1.1",""]
["2.1.2","2.1.2",""]
["2.1.3","2.1.3",""]
["2.1.4","2.1.4",""]
["2.1.5","2.1.5",""]
["2.1.6","2.1.6",""]
["2.1.7","2.1.7",""]
["2.1.8","2.1.8",""]
["2.1.9","2.1.9",""]
["2.2.1","2.2.1",""]
["2.3.1","2.3.1",""]
["2.3.2","2.3.2",""]
["2.3.3","2.3.3",""]
["2.3.4","2.3.4",""]
["2.3.5","2.3.5",""]
["2.4.1","2.4.1",""]
["2.4.2","2.4.2",""]
["2.4.3","2.4.3",""]
[2.5,2.5,""]
["2.5.1","2.5.1",""]

{"sheet":"Admin","index":5,"n_rows":155,"n_cols":2,"rows_kept":155,"cut":false,"hidden":true,"merged":[]}
["Local Authority List"]
[201,"COMMON COUNCIL OF THE CITY OF LONDON"]
[202,"CAMDEN LONDON BOROUGH COUNCIL"]
[203,"ROYAL BOROUGH OF GREENWICH"]
[204,"HACKNEY LONDON BOROUGH COUNCIL"]
[205,"HAMMERSMITH AND FULHAM LONDON BOROUGH COUNCIL"]
[206,"ISLINGTON LONDON BOROUGH COUNCIL"]
[207,"ROYAL BOROUGH OF KENSINGTON AND CHELSEA"]
[208,"LAMBETH LONDON BOROUGH COUNCIL"]
[209,"LEWISHAM LONDON BOROUGH COUNCIL"]
[210,"SOUTHWARK LONDON BOROUGH COUNCIL"]
[211,"TOWER HAMLETS LONDON BOROUGH COUNCIL"]
[212,"WANDSWORTH LONDON BOROUGH COUNCIL"]
[213,"WESTMINSTER CITY COUNCIL"]
[301,"BARKING & DAGENHAM LONDON BOROUGH COUNCIL"]
[302,"BARNET LONDON BOROUGH COUNCIL"]
[303,"BEXLEY LONDON BOROUGH COUNCIL"]
[304,"BRENT LONDON BOROUGH COUNCIL"]
[305,"BROMLEY LONDON BOROUGH COUNCIL"]
[306,"CROYDON LONDON BOROUGH COUNCIL"]
[307,"EALING LONDON BOROUGH COUNCIL"]
[308,"ENFIELD LONDON BOROUGH COUNCIL"]
[309,"HARINGEY LONDON BOROUGH COUNCIL"]
[310,"HARROW LONDON BOROUGH COUNCIL"]
[311,"HAVERING LONDON BOROUGH COUNCIL"]
[312,"HILLINGDON LONDON BOROUGH COUNCIL"]
[313,"HOUNSLOW LONDON BOROUGH COUNCIL"]
[314,"ROYAL BOROUGH OF KINGSTON UPON THAMES"]
[315,"MERTON BOROUGH COUNCIL"]
[316,"NEWHAM LONDON BOROUGH COUNCIL"]
[317,"REDBRIDGE LONDON BOROUGH COUNCIL"]
[318,"RICHMOND UPON THAMES LONDON BOROUGH COUNCIL"]
[319,"SUTTON LONDON BOROUGH COUNCIL"]
[320,"WALTHAM FOREST LONDON BOROUGH COUNCIL"]
[330,"BIRMINGHAM CITY COUNCIL"]
[331,"COVENTRY CITY COUNCIL"]
[332,"DUDLEY METROPOLITAN BOROUGH COUNCIL"]
[333,"SANDWELL METROPOLITAN BOROUGH COUNCIL"]
[334,"SOLIHULL METROPOLITAN BOROUGH COUNCIL"]
[335,"WALSALL METROPOLITAN BOROUGH COUNCIL"]
[336,"WOLVERHAMPTON CITY COUNCIL"]
[340,"KNOWSLEY METROPOLITAN BOROUGH COUNCIL"]
[341,"LIVERPOOL CITY COUNCIL"]
[342,"ST HELENS METROPOLITAN BOROUGH COUNCIL"]
[343,"SEFTON METROPOLITAN BOROUGH COUNCIL"]
[344,"WIRRAL METROPOLITAN BOROUGH COUNCIL"]
[350,"BOLTON METROPOLITAN BOROUGH COUNCIL"]
[351,"BURY METROPOLITAN BOROUGH COUNCIL"]
[352,"MANCHESTER CITY COUNCIL"]
[353,"OLDHAM METROPOLITAN BOROUGH COUNCIL"]
[354,"ROCHDALE BOROUGH COUNCIL"]
[355,"SALFORD CITY COUNCIL"]
[356,"STOCKPORT METROPOLITAN BOROUGH COUNCIL"]
[357,"TAMESIDE METROPOLITAN BOROUGH COUNCIL"]
[358,"TRAFFORD METROPOLITAN BOROUGH COUNCIL"]
[359,"WIGAN METROPOLITAN BOROUGH COUNCIL"]
[370,"BARNSLEY METROPOLITAN BOROUGH COUNCIL"]
[371,"DONCASTER COUNCIL"]
[372,"ROTHERHAM BOROUGH COUNCIL"]
[373,"SHEFFIELD CITY COUNCIL"]
[380,"BRADFORD CITY COUNCIL"]
[381,"CALDERDALE METROPOLITAN BOROUGH COUNCIL"]
[382,"KIRKLEES METROPOLITAN COUNCIL"]
[383,"LEEDS CITY COUNCIL"]
[384,"WAKEFIELD CITY COUNCIL"]
[390,"GATESHEAD COUNCIL"]
[391,"NEWCASTLE UPON TYNE CITY COUNCIL"]
[392,"NORTH TYNESIDE METROPOLITAN BOROUGH COUNCIL"]
[393,"SOUTH TYNESIDE COUNCIL"]
[394,"SUNDERLAND CITY METROPOLITAN BOROUGH COUNCIL"]
[420,"COUNCIL OF THE ISLES OF SCILLY"]
[800,"BATH & NORTH EAST SOMERSET COUNCIL"]
[801,"BRISTOL CITY COUNCIL"]
[802,"NORTH SOMERSET COUNCIL"]
[803,"SOUTH GLOUCESTERSHIRE COUNCIL"]
[805,"HARTLEPOOL BOROUGH COUNCIL"]
[806,"MIDDLESBOROUGH COUNCIL"]
[807,"REDCAR AND CLEVELAND BOROUGH COUNCIL"]
[808,"STOCKTON-ON-TEES BOROUGH COUNCIL"]
[810,"KINGSTON UPON HULL CITY COUNCIL"]
[811,"EAST RIDING OF YORKSHIRE COUNCIL"]
[812,"NORTH EAST LINCOLNSHIRE COUNCIL"]
[813,"NORTH LINCOLNSHIRE COUNCIL"]
[815,"NORTH YORKSHIRE COUNTY COUNCIL"]
[816,"CITY OF YORK COUNCIL"]
[821,"LUTON BOROUGH COUNCIL"]
[822,"BEDFORD BOROUGH COUNCIL"]
[823,"CENTRAL BEDFORDSHIRE COUNCIL"]
[825,"BUCKINGHAMSHIRE COUNCIL"]
[826,"MILTON KEYNES COUNCIL"]
[830,"DERBYSHIRE COUNTY COUNCIL"]
[831,"DERBY CITY COUNCIL"]
[838,"DORSET COUNCIL"]
[839,"BOURNEMOUTH CHRISTCHURCH AND POOLE COUNCIL"]
[840,"COUNTY DURHAM COUNCIL"]
[841,"DARLINGTON BOROUGH COUNCIL"]
[845,"EAST SUSSEX COUNTY COUNCIL"]
[846,"BRIGHTON & HOVE CITY COUNCIL"]
[850,"HAMPSHIRE CITY COUNCIL"]
[851,"PORTSMOUTH CITY COUNCIL"]
[852,"SOUTHAMPTON CITY COUNCIL"]
[855,"LEICESTERSHIRE COUNTY COUNCIL"]
[856,"LEICESTER CITY COUNCIL"]
[857,"RUTLAND COUNTY COUNCIL"]
[860,"STAFFORDSHIRE COUNTY COUNCIL"]
[861,"STOKE-ON-TRENT CITY COUNCIL"]
[865,"THE WILTSHIRE COUNCIL"]
[866,"SWINDON BOROUGH COUNCIL"]
[867,"BRACKNELL FOREST BOROUGH COUNCIL"]
[868,"ROYAL BOROUGH OF WINDSOR AND MAIDENHEAD"]
[869,"WEST BERKSHIRE COUNCIL"]
[870,"READING BOROUGH COUNCIL"]
[871,"SLOUGH BOROUGH COUNCIL"]
[872,"WOKINGHAM COUNCIL"]
[873,"CAMBRIDGESHIRE COUNTY COUNCIL"]
[874,"PETERBOROUGH CITY COUNCIL"]
[876,"HALTON BOROUGH COUNCIL"]
[877,"WARRINGTON BOROUGH COUNCIL"]
[878,"DEVON COUNTY COUNCIL"]
[879,"PLYMOUTH CITY COUNCIL"]
[880,"TORBAY COUNCIL"]
[881,"ESSEX COUNTY COUNCIL"]
[882,"SOUTHEND-ON-SEA BOROUGH COUNCIL"]
[883,"THURROCK COUNCIL"]
[884,"HEREFORDSHIRE COUNCIL"]
[885,"WORCESTERSHIRE COUNTY COUNCIL"]
[886,"KENT COUNTY COUNCIL"]
[887,"MEDWAY COUNCIL"]
[888,"LANCASHIRE COUNTY COUNCIL"]
[889,"BLACKBURN WITH DARWEN BOROUGH COUNCIL"]
[890,"BLACKPOOL BOROUGH COUNCIL"]
[891,"NOTTINGHAMSHIRE COUNTY COUNCIL"]
[892,"NOTTINGHAM CITY COUNCIL"]
[893,"THE SHROPSHIRE COUNCIL"]
[894,"BOROUGH OF TELFORD AND WREKIN"]
[895,"CHESHIRE EAST COUNCIL"]
[896,"CHESHIRE WEST AND CHESTER COUNCIL"]
[908,"CORNWALL COUNCIL"]
[909,"CUMBRIA COUNTY COUNCIL"]
[916,"GLOUCESTERHSIRE COUNTY COUNCIL"]
[919,"HERTFORDSHIRE COUNTY COUNCIL"]
[921,"ISLE OF WIGHT COUNCIL"]
[925,"LINCOLNSHIRE COUNTY COUNCIL"]
[926,"NORFOLK COUNTY COUNCIL"]
[929,"THE NORTHUMBERLAND COUNCIL"]
[931,"OXFORDSHIRE COUNTY COUNCIL"]
[933,"SOMERSET COUNTY COUNCIL"]
[935,"SUFFOLK COUNTY COUNCIL"]
[936,"SURREY COUNTY COUNCIL"]
[937,"WARWICKSHIRE COUNTY COUNCIL"]
[938,"WEST SUSSEX COUNTY COUNCIL"]
[940,"NORTH NORTHAMTONSHIRE COUNCIL"]
[941,"WEST NORTHAMPTONSHIRE COUNCIL"]
[942,"CUMBERLAND COUNCIL"]
[943,"WESTMORELAND AND FURNESS COUNCIL"]