{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Instructions","Cover Sheet","Table A","Table A1","Admin-MissingRowCheck","Admin"],"not_rendered":{"charts":0,"images":17,"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":257,"n_cols":2,"rows_kept":257,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Completing the Return"]
[]
[null,"Important: You must enable macros before completing your return or the built-in validation checks will not work."]
[]
[null,"Detailed guidance on how to complete the return is available at: https://www.gov.uk/government/publications/section-251-2021-to-2022."]
[]
[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,"Log into COLLECT."]
[]
[null,"On the Source page click on 'Upload Return from file…'"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"To upload the return, click on the ‘Browse…’ button to navigate to the required XML file. You then need to select ‘Upload’ to load the data."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"If data is already loaded you will be asked if you want to overwrite it. Answering no will stop the data load, answering yes will delete the existing data and load the new data."]
[]
[null,"Important: If a new version of the data is loaded, all error-level notes will be deleted."]
[]
[null,"Once the file has been successfully loaded the following message will appear."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"The data return has now been placed in a queue to be validated. When COLLECT is busy this process may take some time and users may come back later to view any validation errors present within the return."]
[]
[null,"When you click on ‘OK’ you will return to the ‘Source page’ and the status will be ‘Waiting_for_validation’. When the return reaches the front of the queue, the status on the ‘Source page’ will change to ‘Validation_in_progess’ and then ‘Loaded’ when it is finished."]
[]
[]
[null,"Addressing any errors/queries"]
[]
[null,"When a return has been uploaded, a number of validation checks are run against the data in that return and will trigger errors or queries."]
[]
[null,"All errors and queries are highlighted in red against the relevant data item."]
[]
[null,"To view all errors and queries on the return "]
[]
[null,"Click on ‘All Errors’ at the top of the screen."]
[]
[]
[]
[]
[]
[null,"You will then be shown a list of all errors and queries relating to your return. You may also find it helpful to download an error report."]
[]
[]
[]
[]
[]
[]
[]
[null,"Correcting errors "]
[]
[null,"Click on the 'Details' button to see which data items the validation is checking, these will show to the right of the screen. If you click on one of the underlined fields you will be directed to the corresponding data item in the return."]
[]
[null,"Change the mode of the form to ‘edit’ and then click on the data item that needs to be changed and update it."]
[]
[null,"Providing clarification/ supplementary information"]
[]
[null,"If you are satisfied that the value is correct, please enter a brief but meaningful note next to the error/query (rather than ‘OK’ or ‘Correct’ etc.)."]
[]
[null,"To enter a note, first click on the pen icon next to the error/query on the far right."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Then click ‘Add New Note’."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Type your note in the box provided and click ‘Create’."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"You must enter a note for all errors/queries, except year-on-year queries (3.1.1, 1007, 1008 and 1010)."]
[]
[null,"For year-on-year queries you may either enter a note or choose an option from the drop-down menu at the bottom of the screen which will clear the query."]
[]
[]
[]
[]
[]
[null,"If you select ‘Other - please provide explanation’, this will not clear the query and you must enter a note next to the query."]
[]
[null,"To return to the list of errors, click on the 'Error' button."]
[]
[]
[]
[]
[]
[null,"Editing data within your return"]
[]
[null,"Table A and A1"]
[]
[null,"Use the blue hyperlinks at the bottom of the screen to navigate to the part of your return you wish to edit. Warning: Using the hyperlinks on the left-hand side may result in unexpected behaviour."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Change the mode of the form to ‘edit’ and then click on the data item that needs to be changed and update it."]
[]
[null,"Click on 'View' followed by 'Drill Up' to return to the previous screen."]
[]
[]
[null,"Downloading Reports"]
[]
[null,"On the 'Source Page', click 'Launch Reports'. "]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Select the relevant report and click 'Launch Report'"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Export the report in the desired format."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Submitting the Return"]
[]
[null,"Return to the ‘Source Page’ by clicking on ‘Back to My COLLECT page’ located at the top of the form."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Then select ‘Submit Return’."]

{"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 2021-22"]
[null,null,null,"XML Generator"]
[null,null,null,"Version 1.1"]
[]
[]
[]
[]
[null,"Local Authority Number:",940]
[]
[null,"Local Authority Name:",{"$f":"IF(ISNA(VLOOKUP(C13,LA, 2, FALSE)),\"\",VLOOKUP(C13, LA, 2, FALSE))","v":"North Northamptonshire"}]
[]
[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 2021-22"]
[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,"1.1.10","School improvement",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, 1007, 1010, 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(E25:J25)","v":0},null,{"$f":"K25-L25","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(E40:J40)","v":0},null,{"$f":"K40-L40","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(E43:J43)","v":0},null,{"$f":"K43-L43","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":"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.2","Asset management ",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,"1.5.3","Statutory/ Regulatory duties",null,null,null,null,null,null,null,null,null,{"$f":"K61-L61","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":"K64-L64","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.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},{"$f":"SUM(F9:F71)","v":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 2021-22 (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 2020-21 (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 2022-23 (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,-100,{"$f":"SUM(E113:J113)","v":-100},null,{"$f":"K113-L113","v":-100},null,"J113: 1.3: You have entered a negative amount in this cell. Please check your entry as the value should be zero or a positive amount.\r\n",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":-100},{"$f":"SUM(L93:L120)","v":0},{"$f":"SUM(M93:M120)","v":-100}]
[]
[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 2021-22"]
[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":93,"n_cols":11,"rows_kept":93,"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:C150)","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:J150)","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"},""]
["1.1.10","1.1.10","",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.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(A67,LARowCount,1,FALSE)","v":"2.0.1"},""]
["2.0.2","2.0.2",{"$f":"IF(ISNA(B68),\", \"&A68,\"\")","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":154,"n_cols":2,"rows_kept":154,"cut":false,"hidden":true,"merged":[]}
["Local Authority List"]
[201,"City of London"]
[202,"Camden"]
[203,"Greenwich"]
[204,"Hackney"]
[205,"Hammersmith & Fulham"]
[206,"Islington"]
[207,"Kensington & Chelsea"]
[208,"Lambeth"]
[209,"Lewisham"]
[210,"Southwark"]
[211,"Tower Hamlets"]
[212,"Wandsworth"]
[213,"Westminster"]
[301,"Barking & Dagenham"]
[302,"Barnet"]
[303,"Bexley"]
[304,"Brent"]
[305,"Bromley"]
[306,"Croydon"]
[307,"Ealing"]
[308,"Enfield"]
[309,"Haringey"]
[310,"Harrow"]
[311,"Havering"]
[312,"Hillingdon"]
[313,"Hounslow"]
[314,"Kingston Upon Thames"]
[315,"Merton"]
[316,"Newham"]
[317,"Redbridge"]
[318,"Richmond Upon Thames"]
[319,"Sutton"]
[320,"Waltham Forest"]
[330,"Birmingham"]
[331,"Coventry"]
[332,"Dudley"]
[333,"Sandwell"]
[334,"Solihull"]
[335,"Walsall"]
[336,"Wolverhampton"]
[340,"Knowsley"]
[341,"Liverpool"]
[342,"St Helens"]
[343,"Sefton"]
[344,"Wirral"]
[350,"Bolton"]
[351,"Bury"]
[352,"Manchester"]
[353,"Oldham"]
[354,"Rochdale"]
[355,"Salford"]
[356,"Stockport"]
[357,"Tameside"]
[358,"Trafford"]
[359,"Wigan"]
[370,"Barnsley"]
[371,"Doncaster"]
[372,"Rotherham"]
[373,"Sheffield"]
[380,"Bradford"]
[381,"Calderdale"]
[382,"Kirklees"]
[383,"Leeds"]
[384,"Wakefield"]
[390,"Gateshead"]
[391,"Newcastle Upon Tyne"]
[392,"North Tyneside"]
[393,"South Tyneside"]
[394,"Sunderland"]
[420,"Isles of Scilly"]
[800,"Bath & North East Somerset"]
[801,"Bristol"]
[802,"North Somerset"]
[803,"South Gloucestershire"]
[805,"Hartlepool"]
[806,"Middlesbrough"]
[807,"Redcar & Cleveland"]
[808,"Stockton-on-Tees"]
[810,"Kingston-upon-Hull"]
[811,"East Riding of Yorkshire"]
[812,"North East Lincolnshire"]
[813,"North Lincolnshire"]
[815,"North Yorkshire"]
[816,"York"]
[821,"Luton"]
[822,"Bedford Borough"]
[823,"Central Bedfordshire"]
[825,"Buckinghamshire"]
[826,"Milton Keynes"]
[830,"Derbyshire"]
[831,"Derby"]
[838,"Dorset"]
[839,"Bournemouth, Christchurch and Poole"]
[840,"Durham"]
[841,"Darlington"]
[845,"East Sussex"]
[846,"Brighton & Hove"]
[850,"Hampshire"]
[851,"Portsmouth"]
[852,"Southampton"]
[855,"Leicestershire"]
[856,"Leicester"]
[857,"Rutland"]
[860,"Staffordshire"]
[861,"Stoke-on-Trent"]
[865,"Wiltshire"]
[866,"Swindon"]
[867,"Bracknell Forest"]
[868,"Windsor & Maidenhead"]
[869,"West Berkshire"]
[870,"Reading"]
[871,"Slough"]
[872,"Wokingham"]
[873,"Cambridgeshire"]
[874,"Peterborough"]
[876,"Halton"]
[877,"Warrington"]
[878,"Devon"]
[879,"Plymouth"]
[880,"Torbay"]
[881,"Essex"]
[882,"Southend-on-Sea"]
[883,"Thurrock"]
[884,"Herefordshire"]
[885,"Worcestershire"]
[886,"Kent"]
[887,"Medway"]
[888,"Lancashire"]
[889,"Blackburn with Darwen"]
[890,"Blackpool"]
[891,"Nottinghamshire"]
[892,"Nottingham"]
[893,"Shropshire"]
[894,"Telford & Wrekin"]
[895,"Cheshire East"]
[896,"Cheshire West and Chester"]
[908,"Cornwall"]
[909,"Cumbria"]
[916,"Gloucestershire"]
[919,"Hertfordshire"]
[921,"Isle of Wight"]
[925,"Lincolnshire"]
[926,"Norfolk"]
[928,"Northamptonshire"]
[929,"Northumberland"]
[931,"Oxfordshire"]
[933,"Somerset"]
[935,"Suffolk"]
[936,"Surrey"]
[937,"Warwickshire"]
[938,"West Sussex"]
[940,"North Northamptonshire"]
[941,"West Northamptonshire"]