{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Guidance","Reporting Tool","Sheet 3"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":0,"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":"Guidance","index":0,"n_rows":8,"n_cols":2,"rows_kept":8,"cut":false,"hidden":false,"merged":[[7,0,7,1],[0,0,0,3],[1,0,2,0],[1,1,2,1],[3,0,5,0],[4,1,5,1]]}
["Learning Disability and Autism Community Discharge Grant Reporting Tool - Guidance"]
["What is the purpose of the reporting tool? ","This light touch reporting tool has been developed for oversight of the Learning Disability and Autism Community Discharge Grant expenditure. This information will enable the DHSC to demonstrate the effectiveness of the grant, ultimately informing future decision making.                                                                                             "]
[]
["How to use the tool","It is the responsibility of the lead local authority to complete and return this spreadsheet to the NDLDmailbox@dhsc.gov.uk in the timeframes outlined. The DHSC will also contact you ahead of the set deadlines. "]
[null,"Local authorities in each TCP or ICS can insert as many rows as necessary to report on an intervention (column B) and we encourage case studies being shared with the department. "]
[]
["What is the CDG for?","Insufficient funding to meet double running costs has been identified as a particular block to timely discharge and to meeting the objectives of Building the Right Support. Double running costs are the costs incurred in the period before a formal discharge when a person is still an inpatient requiring a bed, and a community care package is also put in place. Therefore, this funding has been provided to meet these costs."]
["If you have any queries please contact NDLDmailbox@dhsc.gov.uk "]

{"sheet":"Reporting Tool","index":1,"n_rows":10,"n_cols":17,"rows_kept":10,"cut":false,"hidden":false,"merged":[[0,0,0,6],[1,1,1,2],[6,6,6,8]]}
["Learning Disability and Autism Community Discharge Grant Reporting Tool"]
["Name of TCP or ICS:","Bath and North East Somerset, Swindon and Wiltshire ICS"]
["Lead LA:","Luton Council "]
["Sum of CDG 2021/22 allocation:","Free text"]
[]
["Section 1 ",null,null,null,null,null,"Section 2 ",null,null,"Section 3"]
["To be completed and returned to NDLDmailbox@dhsc.gov.uk by 29 November 2021",null,null,null,null,null,"To be completed and returned to NDLDmailbox@dhsc.gov.uk by 31 January 2022 (you will receive a reminder from the DHSC)",null,null,"To be completed and returned to NDLDmailbox@dhsc.gov.uk by 13 April 2022 (you will receive a reminder from the DHSC)"]
[]
["Local Authority ","Please select what intervention you plan to fund using the CDG (create a new line for each intervention)","How much do you plan to spend on this intervention (listed in column B)? ","How many inpatients do you plan to discharge with this intervention (listed in column B)? ","Are you planning to put in place any additional changes (unrelated to the CDG) that might contribute to discharges? ","Approximately how many discharges are you expecting to make through changes unrelated to the CDG? ","Has the CDG been used to discharge any inpatients yet?","If your answer is yes, how many inpatients have been discharged? ","Have you used the CDG in a different way than originally planned?  If your answer is yes, how did your plans change? ","How many inpatients did you discharge in 2021/22?","How many people have been discharged directly as a result of CDG funding i.e. without this they wouldn’t have been discharged?","Please select what intervention you actually funded using the CDG (using interventions listed in column B drop down menu)                       ","Please provide a high-level summary of what you spent the CDG on for the intervention listed in column L","Would you have been able to discharge inpatients without the CDG? If yes, would this have been to the same degree?","How much of your 2021/22 CDG allocation have you spent? ","If you have not spent all of your 2021/22 CDG allocation, what is the reason for this?","Do you have any other feedback regarding the CDG?"]
["Arun District Council","Establishing community teams","Free text","Free text","Yes","Free text","Yes","Free text ","Free text ","Free text ","Free text ","Free text ","Free text ","Free text ","Free text ","Free text ","Free text "]

{"sheet":"Sheet 3","index":2,"n_rows":433,"n_cols":2,"rows_kept":433,"cut":false,"hidden":true,"merged":[]}
["ICS/TCP"]
["Bath and North East Somerset, Swindon and Wiltshire ICS"]
["Bedfordshire, Luton and Milton Keynes ICS"]
["Birmingham and Solihull ICS"]
["Black Country and West Birmingham ICS"]
["Bristol, North Somerset and South Gloucestershire ICS"]
["Buckinghamshire, Oxfordshire and Berkshire West ICS"]
["Cambridgeshire and Peterborough ICS"]
["Cheshire and Merseyside ICS"]
["Cornwall and The Isles Of Scilly ICS"]
["Coventry and Warwickshire ICS"]
["Derbyshire ICS"]
["Devon ICS"]
["Dorset ICS"]
["Essex TCP"]
["Frimley ICS"]
["Gloucestershire ICS"]
["Greater Manchester ICS"]
["Hampshire and The Isle Of Wight ICS"]
["Herefordshire and Worcestershire ICS"]
["Hertfordshire TCP"]
["Humber, Coast and Vale ICS"]
["Kent and Medway ICS"]
["Lancashire and South Cumbria ICS"]
["Leicester, Leicestershire and Rutland ICS"]
["Lincolnshire ICS"]
["Norfolk and Waveney ICS"]
["North Central London ICS"]
["North East and North Cumbria ICS"]
["North East London ICS"]
["North West London ICS"]
["Northamptonshire ICS"]
["Nottingham and Nottinghamshire ICS"]
["Shropshire and Telford and Wrekin ICS"]
["Somerset ICS"]
["South East London ICS"]
["South West London ICS"]
["South Yorkshire and Bassetlaw ICS"]
["Staffordshire and Stoke On Trent ICS"]
["Suffolk TCP"]
["Surrey Heartlands ICS"]
["Sussex ICS"]
["West Yorkshire and Harrogate ICS"]
[null,"Confirmed ICS/TCP LA members"]
["Total","Bath and North East Somerset Council Swindon Council and Wiltshire Council"]
[null,"Bedford Borough Council, Central Bedfordshire Councillor, Luton Council; and Milton Keynes Council.\n"]
["Lead LA","Birmingham City Council and Solihull Metropolitan Borough Council"]
["Wiltshire Council","Wolverhampton, Sandwell, Dudley, Walsall, Birmingham – delivered jointly via BSoL ICS\n"]
["Luton Council ","Bristol City Council, South Gloucestershire Council, North Somerset Council "]
["Birmingham City Council","Oxfordshire County Council, Buckinghamshire County Council, Reading Borough Council, West Berkshire UA, Wokingham UA"]
["Wolverhampton City Council ","Cambridgeshire County Council, , Peterborough City Council  "]
["Bristol City Council","Cheshire East, Cheshire West and Chester, Halton, Knowsley, Liverpool, Sefton, St Helens, Warrington and Wirral"]
["Cambridgeshire County Council","Cornwall Council\nThe Council of the Isles of Scilly\n"]
["Wirral Council","Warwickshire County Council and Coventry City Council"]
["Cornwall Council","Derby City Council, Derbyshire County Council"]
["Warwickshire County Council","Devon County Council\nTorbay Council\nPlymouth City Council \n"]
["Derbyshire County Council","Dorset Council"]
["Devon County Council","Essex County Council, Southend-on-Sea Borough Council, Thurrock Council"]
["Bournemouth, Christchurch and Poole Council and Dorset Council","Surrey County Council"]
["Essex County Council, Southend-on-Sea Borough Council, Thurrock Council","Gloucestershire County Council"]
["Surrey County Council","\tBolton Council\n\tBury MBC\n\tManchester City Council\n\tOldham MBC\n\tRochdale MBC\n\tSalford City Council\n\tStockport Council\n\tTameside MBC\n\tTrafford Council\n\tWigan Council\n"]
["Gloucestershire County Council","Southampton Council\nPortsmouth Council\nIsle of Wight Council\nHampshire County "]
["Oldham Metropolitan Borough Council","Herefordshire Council and Worcestershire County Council"]
["Hampshire County Council ","Hertfordshire County Council"]
["Worcestershire County Council","Hull City Council, East Riding of Yorkshire Council, North Lincolnshire Council, North East Lincolnshire Council"]
["Hertfordshire County Council"," Kent County Council and Medway Council "]
["Hull City Council","Lancashire County Council,\nBlackburn with Darwen Borough Council,\nBlackpool Council,\nCumbria County Council (South Cumbria) \n"]
["Kent County Council","•\tLeicester City Council\n•\tLeicestershire County Council\n•\tRutland County Council\n"]
["Lancashire County Council","Lincolnshire County Council"]
["Leicester City Council","Norfolk County Council and Suffolk County Council "]
["Lincolnshire County Council","Camden, Islington, Enfield, Barnet, Haringey"]
["Norfolk County Council","Cumbria (North only), Northumberland, North Tyneside, Newcastle upon Tyne, Gateshead, South Tyneside, Sunderland, Durham, Darlington, Middlesbrough, Stockton on Tees, Redcar Cleveland, Hartlepool"]
["London Borough of Camden","London Boroughs of Barking & Dagenham, City & Hackney, Havering, Newham, Redbridge, Tower Hamlets and Waltham Forest"]
["Durham County Council","Brent, Ealing, Harrow, Hammersmith and Fulham, Hillingdon, Hounslow, Westminster and Kensington and Chelsea."]
["London Borough of Havering","North and West Northamptonshire"]
["London Borough of Harrow","Nottingham City Council; Nottinghamshire County Council and Bassetlaw District Council."]
["West Northamptonshire Council","Telford and Wrekin Council; Shropshire Council"]
["Nottinghamshire County Council","Somerset County Council"]
["Telford and Wrekin Council","London Boroughs of Lambeth, Southwark, Bromley, Lewisham, Greenwich and Bexley"]
["Somerset County Council","Croydon, Sutton, Merton, Richmond,Sutton and Wandsworth."]
["London Borough of Lambeth","Barnsley Metropolitan Borough Council,\nBassetlaw District Council,\nDoncaster Metropolitan Borough Council,\nRotherham Metropolitan Borough Council,\nSheffield City Council\n"]
["London Borough of Merton","Staffordshire County Council and Stoke-on-Trent City Council"]
["Rotherham Metropolitan Borough Council"]
["Staffordshire County Council","Surrey County Council"]
["Surrey County Council","Brighton and Hove City Council, East Sussex County Council, West Sussex County Council."]
["Brighton and Hove City Council","Leeds, Bradford, Calderdale, Kirklees, Wakefield, Barnsley"]
["Leeds City Council"]
["looks like 2 are missing?"]
[]
["Confirmed ICS/TCP LA members"]
["Bath and North East Somerset Council"]
["Swindon Council"]
["Wiltshire Council"]
["Bedford Borough Council"]
["Central Bedfordshire Councillor"]
["Luton Council"]
["Milton Keynes Council"]
[]
[]
[]
["Adur District Council"]
["Allerdale Borough Council"]
["Amber Valley Borough Council"]
["Arun District Council"]
["Ashfield District Council"]
["Ashford Borough Council"]
["Babergh District Council"]
["Barking and Dagenham London Borough"]
["Barnet London Borough"]
["Barnsley Metropolitan Borough Council"]
["Barrow-in-Furness District Council"]
["Basildon District Council"]
["Basingstoke and Deane Borough Council"]
["Bassetlaw District Council"]
["Bath and North East Somerset Council"]
["Bedford UA"]
["Bexley London Borough"]
["Birmingham City Council"]
["Blaby District Council"]
["Blackburn with Darwen Borough Council"]
["Blackpool Borough Council"]
["Bolsover District Council"]
["Bolton Metropolitan Borough Council"]
["Boston Borough Council"]
["Bournemouth, Christchurch and Poole Council "]
["Bracknell Forest Borough Council"]
["Braintree District Council"]
["Breckland District Council"]
["Brent London Borough"]
["Brentwood Borough Council"]
["Brighton and Hove Council"]
["Bristol Council"]
["Broadland District Council"]
["Bromley London Borough"]
["Bromsgrove District Council"]
["Broxbourne Borough Council"]
["Broxtowe Borough Council"]
["Buckinghamshire County Council"]
["Burnley Borough Council"]
["Bury Metropolitan Borough Council"]
["Calderdale Metropolitan Borough Council"]
["Cambridge City Council"]
["Cambridgeshire County Council"]
["Camden London Borough"]
["Cannock Chase District Council"]
["Canterbury City Council"]
["Carlisle City Council"]
["Castle Point Borough Council"]
["Central Bedfordshire UA"]
["Charnwood Borough Council"]
["Chelmsford Borough Council"]
["Cheltenham Borough Council"]
["Cherwell District Council"]
["Cheshire East UA"]
["Cheshire West and Chester UA"]
["Chesterfield Borough Council"]
["Chichester District Council"]
["Chorley Borough Council"]
["City of Bradford Metropolitan District Council"]
["City of London"]
["City of York Council"]
["Colchester Borough Council"]
["Copeland Borough Council"]
["Cornwall County UA"]
["Cotswold District Council"]
["County of Herefordshire District Council"]
["Coventry City Council"]
["Craven District Council"]
["Crawley Borough Council"]
["Croydon London Borough"]
["Cumbria County Council"]
["Dacorum Borough Council"]
["Darlington Borough Council"]
["Dartford Borough Council"]
["Derby City Council"]
["Derbyshire County Council"]
["Derbyshire Dales District Council"]
["Devon County Council"]
["Doncaster Metropolitan Borough Council"]
["Dorset Council"]
["Dover District Council"]
["Dudley Metropolitan Borough Council"]
["Durham County UA"]
["Ealing London Borough"]
["East Cambridgeshire District Council"]
["East Devon District Council"]
["East Hampshire District Council"]
["East Hertfordshire District Council"]
["East Lindsey District Council"]
["East Riding of Yorkshire Council"]
["East Staffordshire Borough Council"]
["East Suffolk District Council"]
["East Sussex County Council"]
["Eastbourne Borough Council"]
["Eastleigh Borough Council"]
["Eden District Council"]
["Elmbridge Borough Council"]
["Enfield London Borough"]
["Epping Forest District Council"]
["Epsom and Ewell Borough Council"]
["Erewash Borough Council"]
["Essex County Council"]
["Exeter City Council"]
["Fareham Borough Council"]
["Fenland District Council"]
["Folkestone and Hythe District Council"]
["Forest of Dean District Council"]
["Fylde Borough Council"]
["Gateshead Metropolitan Borough Council"]
["Gedling Borough Council"]
["Gloucester City Council"]
["Gloucestershire County Council"]
["Gosport Borough Council"]
["Gravesham Borough Council"]
["Great Yarmouth Borough Council"]
["Greenwich London Borough"]
["Guildford Borough Council"]
["Hackney London Borough"]
["Halton Borough Council"]
["Hambleton District Council"]
["Hammersmith and Fulham London Borough"]
["Hampshire County Council"]
["Harborough District Council"]
["Haringey London Borough"]
["Harlow District Council"]
["Harrogate Borough Council"]
["Harrow London Borough"]
["Hart District Council"]
["Hartlepool Council"]
["Hastings Borough Council"]
["Havant Borough Council"]
["Havering London Borough"]
["Hertfordshire County Council"]
["Hertsmere Borough Council"]
["High Peak Borough Council"]
["Hillingdon London Borough"]
["Hinckley and Bosworth Borough Council"]
["Horsham District Council"]
["Hounslow London Borough"]
["Huntingdonshire"]
["Hyndburn Borough Council"]
["Ipswich Borough Council"]
["Isle of Wight Council"]
["Isles of Scilly Council"]
["Islington London Borough"]
["Kensington and Chelsea Royal Borough"]
["Kent County Council"]
["Kings Lynn and West Norfolk Borough Council"]
["Kingston Upon Hull City Council"]
["Kingston upon Thames Royal Borough"]
["Kirklees Metropolitan Borough Council"]
["Knowsley Metropolitan Borough Council"]
["Lambeth London Borough"]
["Lancashire County Council"]
["Lancaster City Council"]
["Leeds City Council"]
["Leicester City Council"]
["Leicestershire County Council"]
["Lewes District Council"]
["Lewisham London Borough"]
["Lichfield District Council"]
["Lincoln City Council"]
["Lincolnshire County Council"]
["Liverpool City Council"]
["London Borough of Richmond upon Thames"]
["Luton Borough Council"]
["Maidstone Borough Council"]
["Maldon District Council"]
["Malvern Hills District Council"]
["Manchester City Council"]
["Mansfield District Council"]
["Medway Borough Council"]
["Melton Borough Council"]
["Mendip District Council"]
["Merton London Borough"]
["Mid Devon District Council"]
["Mid Suffolk District Council"]
["Mid Sussex District Council"]
["Middlesbrough Borough"]
["Milton Keynes Council"]
["Mole Valley District Council"]
["New Forest District Council"]
["Newark and Sherwood District Council"]
["Newcastle upon Tyne Metropolitan District Council"]
["Newcastle-under-Lyme Borough Council"]
["Newham London Borough"]
["Norfolk County Council"]
["North Devon District Council"]
["North East Derbyshire District Council"]
["North East Lincolnshire Council"]
["North Hertfordshire District Council"]
["North Kesteven District Council"]
["North Lincolnshire Council"]
["North Norfolk District Council"]
["North Northamptonshire"]
["North Somerset Council"]
["North Tyneside Metropolitan Borough Council"]
["North Warwickshire Borough Council"]
["North West Leicestershire District Council"]
["North Yorkshire County Council"]
["Northumberland County UA"]
["Norwich City Council"]
["Nottingham City Council"]
["Nottinghamshire County Council"]
["Nuneaton and Bedworth Borough Council"]
["Oadby and Wigston Borough Council"]
["Oldham Metropolitan Borough Council"]
["Oxford City Council"]
["Oxfordshire"]
["Pendle Borough Council"]
["Peterborough City Council"]
["Plymouth City Council"]
["Portsmouth City Council"]
["Preston city Council"]
["Reading Borough Council"]
["Redbridge London Borough"]
["Redcar and Cleveland Borough Council"]
["Redditch Borough Council"]
["Reigate and Banstead Borough Council"]
["Ribble Valley Borough Council"]
["Richmondshire District Council"]
["Rochdale Metropolitan Borough Council"]
["Rochford District Council"]
["Rossendale Borough Council"]
["Rother District Council"]
["Rotherham Metropolitan Borough Council"]
["Rugby Borough Council"]
["Runnymede Borough Council"]
["Rushcliffe Borough Council"]
["Rushmoor Borough Council"]
["Rutland County Council District Council"]
["Ryedale District Council"]
["Salford Metropolitan District Council"]
["Sandwell Metropolitan Borough Council"]
["Scarborough Borough Council"]
["Sedgemoor District Council"]
["Sefton"]
["Selby District Council"]
["Sevenoaks District Council"]
["Sheffield City Council"]
["Shropshire County UA"]
["Slough Borough Council"]
["Solihull Metropolitan Borough Council"]
["Somerset County Council"]
["Somerset West and Taunton District Council"]
["South Cambridgeshire District Council"]
["South Derbyshire District Council"]
["South Gloucestershire Council"]
["South Hams District Council"]
["South Holland District Council"]
["South Kesteven District Council"]
["South Lakeland District Council"]
["South Norfolk Council"]
["South Oxfordshire District Council"]
["South Ribble Borough Council"]
["South Somerset District Council"]
["South Staffordshire District Council"]
["South Tyneside Metropolitan Borough Council"]
["Southampton City Council"]
["Southend-on-Sea Borough Council"]
["Southwark London Borough"]
["Spelthorne Borough Council"]
["St Albans District Council"]
["St Helens Metropolitan Borough Council"]
["Stafford Borough Council"]
["Staffordshire County Council"]
["Staffordshire Moorlands District Council"]
["Stevenage Borough Council"]
["Stockport Metropolitan Borough Council"]
["Stockton-on-Tees Borough Council"]
["Stoke-on-Trent City Council"]
["Stratford-on-Avon District Council"]
["Stroud District Council"]
["Suffolk County Council"]
["Sunderland City Council"]
["Surrey County Council"]
["Surrey Heath Borough Council"]
["Sutton London Borough"]
["Swale Borough Council"]
["Swindon Borough Council"]
["Tameside Metropolitan Borough Council"]
["Tamworth Borough Council"]
["Tandridge District Council"]
["Teignbridge District Council"]
["Telford and Wrekin Council"]
["Tendring District Council"]
["Test Valley Borough Council"]
["Tewkesbury Borough Council"]
["Thanet District Council"]
["Three Rivers District Council"]
["Thurrock Council"]
["Tonbridge and Malling Borough Council"]
["Torbay Borough Council"]
["Torridge District Council"]
["Tower Hamlets London Borough"]
["Trafford Metropolitan Borough Council"]
["Tunbridge Wells Borough Council"]
["Uttlesford District Council"]
["Vale of White Horse"]
["Wakefield Metropolitan District Council"]
["Walsall Metropolitan Borough Council"]
["Waltham Forest London Borough"]
["Wandsworth London Borough"]
["Warrington Borough Council"]
["Warwick District Council"]
["Warwickshire County Council"]
["Watford Borough Council"]
["Waverley Borough Council"]
["Wealden District Council"]
["Welwyn Hatfield District Council"]
["West Berkshire District Council"]
["West Devon Borough Council"]
["West Lancashire District Council"]
["West Lindsey District Council"]
["West Northamptonshire"]
["West Oxfordshire District Council"]
["West Suffolk District Council"]
["West Sussex County Council"]
["Westminster City Council"]
["Wigan Metropolitan Borough Council"]
["Wiltshire County UA"]
["Winchester City Council"]
["Windsor and Maidenhead Royal Borough Council"]
["Wirral Metropolitan Borough Council"]
["Woking Borough Council"]
["Wokingham District Council"]
["Wolverhampton Metropolitan Borough Council"]
["Worcester City Council"]
["Worcestershire County Council"]
["Worthing Borough Council"]
["Wychavon District Council"]
["Wyre Borough Council"]
["Wyre Forest"]