{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["START","Narrative","Financial Summary","Lists"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":11,"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":"START","index":0,"n_rows":31,"n_cols":4,"rows_kept":31,"cut":false,"hidden":true,"merged":[[33,3,34,6],[7,1,7,12],[10,1,11,2],[22,3,27,12],[30,1,31,2],[30,3,31,6]]}
[]
[]
[]
[]
[]
[]
[]
[null,"To use this template, please follow the instruction below, otherwise the template will not work."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"This workbook contains some macro content. To use this workbook, please enable the macro content by clicking on the yellow button above (just below the Ribbon), otherwise it will not be fully accessible."]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"Select School Type:"]

{"sheet":"Narrative","index":1,"n_rows":63,"n_cols":12,"rows_kept":63,"cut":false,"hidden":false,"merged":[[27,1,27,2],[50,1,50,2],[57,1,57,2],[56,1,56,2],[55,1,55,2],[52,1,52,2],[39,2,39,3],[37,1,37,2],[53,1,53,2],[30,1,30,2],[31,1,31,3],[49,1,49,2],[44,1,44,2],[45,1,45,2],[46,1,46,2],[35,2,35,3],[0,1,0,3],[8,1,8,3],[1,1,1,3],[6,1,6,3],[34,1,34,2],[28,1,28,3],[11,1,11,2],[22,1,22,3],[12,1,12,2],[13,1,13,2],[14,1,14,2],[18,1,18,2],[19,1,19,3],[21,1,21,2],[24,1,24,2],[25,1,25,3],[47,1,47,2],[38,1,38,2],[41,1,41,2],[42,1,42,3],[51,1,51,2]]}
[null,"School and Early Years Finance (England) Regulations",null,null,null,null,null,null,null,null,null,{"$f":"SUM(G7:G12)","v":0}]
[null,"Local Authority Dedicated Schools Grant Deficit Recovery Plan"]
[]
[]
[]
[]
[null,"Please complete this recovery plan template outlining how you will bring your DSG deficit back into balance within a 3 year time frame.  Please complete all relevant fields and return the completed recovery plan to financial.management@education.gov.uk "]
[]
[null,"You may wish to include brief supporting attachments with your request such as forum minutes (if links not available) - these can be added towards the bottom of this page. Spreadsheet calculations should be included on the Financial Summary tab.\nAttachments should only be included as supplementary evidence and referenced in the ‘details of the request’ box."]
[]
[]
[null,"Local Authority"]
[null,"Local Authority number",null,{"$f":"IFERROR(VLOOKUP(D12,Lists!A2:B152,2,FALSE),\"\")","v":""}]
[null,"Does schools forum agree with this recovery plan and when was it presented to them?"]
[null,"If yes, please provide link(s) to the minutes and action plans from the schools forum agreement"]
[]
[]
[]
[null,"What plans have you put in place to reduce the deficit in increments over the next 3 years? \n"]
[]
[null,null,null,{"$f":"\"Word count:  \" & IF(LEN(B20)=0,0,LEN(TRIM(B20))-LEN(SUBSTITUTE(B20,\" \",\"\"))+1)","v":"Word count:  0"}]
[null,"Can you specify how continuous improvement has reduced the deficit/ is going to reduce the deficit? This could include sharing best practice, new contracts, efficiency savings "]
[]
[null,null,null,{"$f":"\"Word count:  \" & IF(LEN(B23)=0,0,LEN(TRIM(B23))-LEN(SUBSTITUTE(B23,\" \",\"\"))+1)","v":"Word count:  0"}]
[null,"Please provide details of any previous movements between blocks, what current cost pressures those movements covered, and why those transfers have not been adequate to counter the new cost pressures"]
[]
[null,null,null,{"$f":"\"Word count:  \" & IF(LEN(B26)=0,0,LEN(TRIM(B26))-LEN(SUBSTITUTE(B26,\" \",\"\"))+1)","v":"Word count:  0"}]
[null,"Please provide details of contributions coming from the health and social care budgets towards the cost of high needs provision"]
[]
[null,null,null,{"$f":"\"Word count:  \" & IF(LEN(B29)=0,0,LEN(TRIM(B29))-LEN(SUBSTITUTE(B29,\" \",\"\"))+1)","v":"Word count:  0"}]
[null,"Please explain how the LA has discharged its duties under section 149 of the Equality Act 2010, C&F 2014 and common law to consult with those affected by the changes proposed."]
[]
[null,null,null,{"$f":"\"Word count:  \" & IF(LEN(B32)=0,0,LEN(TRIM(B32))-LEN(SUBSTITUTE(B32,\" \",\"\"))+1)","v":"Word count:  0"}]
[]
[null,"Please include a summary of the savings/and or measure you propose to implement over the next three years which will reduce the overspend."]
[null,"S1","S1 - "]
[]
[null,"Please discuss the local circumstances that have contributed to your deficit.  Please provide a brief summary of the pressures in the box below and transfer the forecast spend in this area on the financial summary tab via the appropriate link. Local authorities should consider providing budget pressures in the following areas: "]
[null,"A) mainstream schools; B) state-funded special schools, \nC) further education and sixth form colleges,\nD) independent specialist provision; E) alternative provision"]
[null,"P1","P1 - "]
[]
[null,"Please provide any further detail here if required, including any attachments that support your recovery plan and any disapplication reference number."]
[]
[]
[null,"Contact Name"]
[null,"Job Title"]
[null,"Email address"]
[null,"Date"]
[]
[null,"For Official use only"]
[null,"Recovery Plan number"]
[null,"ID"]
[null,"DfE Response to Plan"]
[null,"Details of the Decision"]
[]
[null,"Name"]
[null,"Date"]
[null,"Type of Notification"]
[]
[]
[null,"Further Information "]
[null,"High Needs Funding Arrangements ","Information for local authorities and institutions about high needs funding arrangements for 2019 to 2020."]
[null,"High Needs Benchmarking Tool","Information for local authorities about strategic reviews, funding of high needs provision for children and young people with SEND and the High Needs benchmarking tool."]

{"sheet":"Financial Summary","index":2,"n_rows":43,"n_cols":16,"rows_kept":43,"cut":false,"hidden":false,"merged":[[26,10,26,12],[27,10,27,12],[28,10,28,12],[29,10,29,12],[30,10,30,12],[31,10,31,12],[32,10,32,12],[38,1,38,3],[39,1,39,3],[40,1,40,3],[41,1,41,3],[42,1,42,3],[29,1,29,3],[30,1,30,3],[36,1,36,3],[37,1,37,3],[31,1,31,3],[32,1,32,3],[2,1,4,1],[2,4,4,4],[26,1,26,3],[27,1,27,3],[28,1,28,3]]}
[null,"DSG Deficit Recovery Plan"]
[]
[null,"Ref.",null,null,"Action e.g. increasing special school places ",null,"Year 1","Year 2","Year 3",null,"Key"]
[null,null,"Block","Type of provision",null,"2018-19","2019-20","2020-21","2021-22",null,"User entry required"]
[null,null,null,"e.g. special schools",null,"£","£","£","£"]
[null,"DSG Balance b/f",null,null,null,null,{"$f":"F20","v":0},{"$f":"G20","v":0},{"$f":"H20","v":0}]
[null,"Savings (figures should be entered as negative values)"]
[null,"S1"]
[null,"Total savings",null,null,null,{"$f":"SUM(F8:F8)","v":0},{"$f":"SUM(G8:G8)","v":0},{"$f":"SUM(H8:H8)","v":0},{"$f":"SUM(I8:I8)","v":0}]
[null,"Pressures (figures should be entered as positive values)"]
[null,"P1"]
[null,"Additional Pressures (figures should be entered as positive values)",null,null,null,{"$f":"SUM(F11:F11)","v":0},{"$f":"SUM(G11:G11)","v":0},{"$f":"SUM(H11:H11)","v":0},{"$f":"SUM(I11:I11)","v":0}]
[null,"Cost reductions from impact of recovery plan",null,null,null,{"$f":"SUM(F9,F12)","v":0},{"$f":"SUM(G9,G12)","v":0},{"$f":"H9+H12","v":0},{"$f":"I9+I12","v":0}]
[null,"Total DSG forecast overspend"]
[null,"Net in year impact on High Needs DSG",null,null,null,{"$f":"SUM(F13,F14)","v":0},{"$f":"SUM(G13,G14)","v":0},{"$f":"SUM(H13:H14)","v":0},0]
[null,"Estimated High Needs Block change (additional grant)"]
[null,"Approved transfer of schools block to HN block"]
[null,"Other adjustments"]
[null,"Net in year Forecast Outturn Variance",null,null,null,{"$f":"SUM(F15:F18)","v":0},{"$f":"SUM(G15:G18)","v":0},{"$f":"SUM(H15:H18)","v":0},0]
[null,"DSG Balance – show a deficit as a positive value",null,null,null,null,{"$f":"G6+G19","v":0},{"$f":"H6+H19","v":0},{"$f":"I6+I19","v":0}]
[null,null,null,null,null,{"$f":"IF(F20>0,\"DEFICIT\",\"SURPLUS\")","v":"SURPLUS"},{"$f":"IF(G20>0,\"DEFICIT\",\"SURPLUS\")","v":"SURPLUS"},{"$f":"IF(H20>0,\"DEFICIT\",\"SURPLUS\")","v":"SURPLUS"},"SURPLUS"]
[]
[]
[null,"Education, Health and Care Plans"]
[]
[]
[null,null,null,null,"Number of CYP with Statements/ EHCPs","Total HNB ","Outturn","Cumulative"]
[null,2016]
[null,2017]
[null,2018]
[null,2019]
[null,2020]
[null,2021]
[]
[]
[]
[null,null,null,null,2016,"% against total",2017,"% against total",2018,"% against total",2019,"% against total",2020,"% against total",2021,"% against total"]
[null,"Under Age 5",null,null,null,{"$f":"IFERROR(E38/E$43,\"-\")","v":"-"},null,{"$f":"IFERROR(G38/G$43,\"-\")","v":"-"},null,{"$f":"IFERROR(I38/I$43,\"-\")","v":"-"},null,{"$f":"IFERROR(K38/K$43,\"-\")","v":"-"},null,{"$f":"IFERROR(M38/M$43,\"-\")","v":"-"},null,{"$f":"IFERROR(O38/O$43,\"-\")","v":"-"}]
[null,"Aged 5-10",null,null,null,{"$f":"IFERROR(E39/E$43,\"-\")","v":"-"},null,{"$f":"IFERROR(G39/G$43,\"-\")","v":"-"},null,{"$f":"IFERROR(I39/I$43,\"-\")","v":"-"},null,{"$f":"IFERROR(K39/K$43,\"-\")","v":"-"},null,{"$f":"IFERROR(M39/M$43,\"-\")","v":"-"},null,{"$f":"IFERROR(O39/O$43,\"-\")","v":"-"}]
[null,"Aged 11-15",null,null,null,{"$f":"IFERROR(E40/E$43,\"-\")","v":"-"},null,{"$f":"IFERROR(G40/G$43,\"-\")","v":"-"},null,{"$f":"IFERROR(I40/I$43,\"-\")","v":"-"},null,{"$f":"IFERROR(K40/K$43,\"-\")","v":"-"},null,{"$f":"IFERROR(M40/M$43,\"-\")","v":"-"},null,"-"]
[null,"Aged 16-19",null,null,null,{"$f":"IFERROR(E41/E$43,\"-\")","v":"-"},null,{"$f":"IFERROR(G41/G$43,\"-\")","v":"-"},null,{"$f":"IFERROR(I41/I$43,\"-\")","v":"-"},null,{"$f":"IFERROR(K41/K$43,\"-\")","v":"-"},null,{"$f":"IFERROR(M41/M$43,\"-\")","v":"-"},null,"-"]
[null,"Aged 20-25",null,null,null,{"$f":"IFERROR(E42/E$43,\"-\")","v":"-"},null,{"$f":"IFERROR(G42/G$43,\"-\")","v":"-"},null,{"$f":"IFERROR(I42/I$43,\"-\")","v":"-"},null,{"$f":"IFERROR(K42/K$43,\"-\")","v":"-"},null,{"$f":"IFERROR(M42/M$43,\"-\")","v":"-"},null,"-"]
[null,"Total",null,null,{"$f":"SUM(E38:E42)","v":0},0,0,0,0,0,0,0,0,0,{"$f":"SUM(O38:O42)","v":0},0]

{"sheet":"Lists","index":3,"n_rows":152,"n_cols":5,"rows_kept":152,"cut":false,"hidden":true,"merged":[]}
["Local Authority Name","Local Authority number","Blocks","Savings","Pressures"]
["Barking and Dagenham",301,"CSSB","Active engagement of independent / non-maintained providers in designing services and provision","Difficulties arising from the funding formula"]
["Barnet",302,"Early Years","Active engagement of local schools and colleges in designing services and provision","Greater complexity of need"]
["Barnsley",370,"High Needs","Active engagement of parents and young people in designing services and provision","High rates of exclusions and use of AP"]
["Bath & North East Somerset",800,"Schools","Capital investment in new or expanded special units / resourced provision","Higher parental expectations"]
["Bedford",822,null,"Capital investment in new, expanded or adapted special schools","Increase in the number of EHC Plans"]
["Bexley",303,null,"Increased resource for mainstream schools – specialist support services (funded from HN)","Increased use of INMSS or out of area placements"]
["Birmingham",330,null,"Increased resource for mainstream schools – targeted funding","Placements in independent and non-maintained schools"]
["Blackburn with Darwen",889,null,"Increased resource for mainstream schools – training / development for staff","Poor local mental health services"]
["Blackpool",890,null,"Other","Population growth"]
["Bolton",350,null,null,"Post-16 responsibilities"]
["Bournemouth, Christcurch & Poole",839,null,null,"Pressure on maintained special school capacity"]
["Bracknell Forest",867,null,null,"Reduced inclusivity of schools"]
["Bradford",380,null,null,"Reductions in health service provision, e.g. OT, physio, speech and language therapy"]
["Brent",304,null,null,"Reductions in short breaks"]
["Brighton and Hove",846,null,null,"Specific needs of children with SEMH/ASD"]
["Bristol, City of",801,null,null,"SEN Units"]
["Bromley",305,null,null,"Other"]
["Buckinghamshire",825]
["Bury",351]
["Calderdale",381]
["Cambridgeshire",873]
["Camden",202]
["Central Bedfordshire",823]
["Cheshire West and Chester",896]
["City of London",201]
["Cornwall",908]
["Coventry",331]
["Croydon",306]
["Cumbria",909]
["Darlington",841]
["Derby",831]
["Derbyshire",830]
["Devon",878]
["Doncaster",371]
["Dorset",838]
["Dudley",332]
["Durham",840]
["Ealing",307]
["East Cheshire",895]
["East Riding of Yorkshire",811]
["East Sussex",845]
["Enfield",308]
["Essex",881]
["Gateshead",390]
["Gloucestershire",916]
["Greenwich",203]
["Hackney",204]
["Halton",876]
["Hammersmith and Fulham",205]
["Hampshire",850]
["Haringey",309]
["Harrow",310]
["Hartlepool",805]
["Havering",311]
["Herefordshire",884]
["Hertfordshire",919]
["Hillingdon",312]
["Hounslow",313]
["Isle of Wight",921]
["Isles of Scilly",420]
["Islington",206]
["Kensington and Chelsea",207]
["Kent",886]
["Kingston",314]
["Kingston Upon Hull, City of",810]
["Kirklees",382]
["Knowsley",340]
["Lambeth",208]
["Lancashire",888]
["Leeds",383]
["Leicester",856]
["Leicestershire",855]
["Lewisham",209]
["Lincolnshire",925]
["Liverpool",341]
["Luton",821]
["Manchester",352]
["Medway",887]
["Merton",315]
["Middlesbrough",806]
["Milton Keynes",826]
["Newcastle upon Tyne",391]
["Newham",316]
["Norfolk",926]
["North East Lincolnshire",812]
["North Lincolnshire",813]
["North Somerset",802]
["North Tyneside",392]
["North Yorkshire",815]
["Northamptonshire",928]
["Northumberland",929]
["Nottingham",892]
["Nottinghamshire",891]
["Oldham",353]
["Oxfordshire",931]
["Peterborough",874]
["Plymouth",879]
["Portsmouth",851]
["Reading",870]
["Redbridge",317]
["Redcar and Cleveland",807]
["Richmond upon Thames",318]
["Rochdale",354]
["Rotherham",372]
["Rutland",857]
["Salford",355]
["Sandwell",333]
["Sefton",343]
["Sheffield",373]
["Shropshire",893]
["Slough",871]
["Solihull",334]
["Somerset",933]
["South Gloucestershire",803]
["South Tyneside",393]
["Southampton",852]
["Southend-on-Sea",882]
["Southwark",210]
["St Helens",342]
["Staffordshire",860]
["Stockport",356]
["Stockton-on-Tees",808]
["Stoke-on-Trent",861]
["Suffolk",935]
["Sunderland",394]
["Surrey",936]
["Sutton",319]
["Swindon",866]
["Tameside",357]
["Telford and Wrekin",894]
["Thurrock",883]
["Torbay",880]
["Tower Hamlets",211]
["Trafford",358]
["Wakefield",384]
["Walsall",335]
["Waltham Forest",320]
["Wandsworth",212]
["Warrington",877]
["Warwickshire",937]
["West Berkshire",869]
["West Sussex",938]
["Westminster",213]
["Wigan",359]
["Wiltshire",865]
["Windsor and Maidenhead",868]
["Wirral",344]
["Wokingham",872]
["Wolverhampton",336]
["Worcestershire",885]
["York",816]