{"text_format":"1","workbook":"xlsx","n_sheets":11,"sheets":["Information","Data","Calc","LA - mapping","Summary LA","1. LA - Leadership","2. LA - Joint Arrangements","3. LA - Commissioning","4. LA - EHC Plan","5. LA - Co-Production","6. LA - Monitor & Redress"],"not_rendered":{"charts":28,"images":3,"macros":1,"external_links":0,"defined_names":4,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Information","index":0,"n_rows":30,"n_cols":4,"rows_kept":30,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,null,"Special Educational Needs & Disability (SEND)\nDiagnostic Checklist For Local Authorities"]
[]
[]
[null,null,null,"INTRODUCTION"]
[]
[]
[null,null,null,"Local Authority (LA) Diagnostic checklist"]
[]
[null,null,null,"The Children and Families Act 2014"]
[]
[null,null,null,"The Children and Families Act is a statutory framework for the integration and personalisation of services for children and young people with special educational needs and or disabilities (SEND). Improving outcomes, experiences and services for children, young people and their families requires education, social care and health services in England to work together closely at both a strategic joint commissioning level and through the provision of integrated services for individuals through Education Health and Care Plans."]
[]
[null,null,null,"Strong joint working arrangements, based on a shared local vision, strategy and common understanding of areas of strength and where improvement is needed is key and crucial for delivering transformation programmes for children and young people, including:"]
[]
[null,null,null,"·         Transforming Care Programme"]
[null,null,null,"·         CAMHS Local Transformation Plans"]
[null,null,null,"·        Increasing the use of Integrated Personal Budgets."]
[]
[null,null,null,"The Tool"]
[]
[null,null,null,"The purpose of the tool is to support joint working between LAs and health partners and therefore mirrors the CCG audit tool, although some language differs to reflect the different agencies. It pulls together in one place the key pieces of evidence that the LA will wish to assure itself on and aims to give a LA a high-level overview of its progress. The questions are divided into the 6 key areas of the role of a LA in supporting children with SEND. "]
[]
[null,null,null,"The tool presents this information in an easily accessible “at a glance” RAG rating system to update the relevant LA on progress in implementation.  It also includes a facility for a follow up audit which enables the responsible LA officer to demonstrate trends in terms of implementation and flag up any areas which are not moving towards full compliance."]
[]
[null,null,null,"RAG rating scores and trend description options can be chosen from a drop down menu as can the name of your LA."]
[]
[null,null,null,"Local authorities may wish to use this alongside more detailed self-evaluations on specific aspects of the reforms as part of their focus on ongoing improvement of services and as part of their evidence base for inspections."]
[]
[null,null,null,"There is a supplementary Local Area Overview Tool that can be used alongside both the LA and CCG tool to create a local area overview on progress, using a RAG rating. Simple instructions on how to use this are provided."]

{"sheet":"Data","index":1,"n_rows":114,"n_cols":10,"rows_kept":114,"cut":false,"hidden":true,"merged":[]}
["Type","Section","Section_ID","Sub-Section","SS_ID","Q","Audit1","Audit2","Audit1_Score","Audit2_Score"]
["LA","1. Leadership",1,"Governance and Leadership",1.1000000000000001,1,{"$f":"'1. LA - Leadership'!G10","v":"Please Select"},{"$f":"'1. LA - Leadership'!H10","v":"Please Select"},{"$f":"VLOOKUP(G2,'LA - mapping'!$B$6:$C$9,2,0)","v":0},{"$f":"VLOOKUP(H2,'LA - mapping'!$B$6:$C$9,2,0)","v":0}]
["LA","1. Leadership",1,"Governance and Leadership",1.1000000000000001,2,{"$f":"'1. LA - Leadership'!G11","v":"Please Select"},{"$f":"'1. LA - Leadership'!H11","v":"Please Select"},{"$f":"VLOOKUP(G3,'LA - mapping'!$B$6:$C$9,2,0)","v":0},{"$f":"VLOOKUP(H3,'LA - mapping'!$B$6:$C$9,2,0)","v":0}]
["LA","1. Leadership",1,"Governance and Leadership",1.1000000000000001,3,{"$f":"'1. LA - Leadership'!G12","v":"Please Select"},{"$f":"'1. LA - Leadership'!H12","v":"Please Select"},{"$f":"VLOOKUP(G4,'LA - mapping'!$B$6:$C$9,2,0)","v":0},{"$f":"VLOOKUP(H4,'LA - mapping'!$B$6:$C$9,2,0)","v":0}]
["LA","1. Leadership",1,"Governance and Leadership",1.1000000000000001,4,{"$f":"'1. LA - Leadership'!G13","v":"Please Select"},{"$f":"'1. LA - Leadership'!H13","v":"Please Select"},{"$f":"VLOOKUP(G5,'LA - mapping'!$B$6:$C$9,2,0)","v":0},{"$f":"VLOOKUP(H5,'LA - mapping'!$B$6:$C$9,2,0)","v":0}]
["LA","1. Leadership",1,"Governance and Leadership",1.1000000000000001,5,{"$f":"'1. LA - Leadership'!G14","v":"Please Select"},{"$f":"'1. LA - Leadership'!H14","v":"Please Select"},{"$f":"VLOOKUP(G6,'LA - mapping'!$B$6:$C$9,2,0)","v":0},{"$f":"VLOOKUP(H6,'LA - mapping'!$B$6:$C$9,2,0)","v":0}]
["LA","1. Leadership",1,"Governance and Leadership",1.1000000000000001,6,{"$f":"'1. LA - Leadership'!G15","v":"Please Select"},{"$f":"'1. LA - Leadership'!H15","v":"Please Select"},{"$f":"VLOOKUP(G7,'LA - mapping'!$B$6:$C$9,2,0)","v":0},{"$f":"VLOOKUP(H7,'LA - mapping'!$B$6:$C$9,2,0)","v":0}]
["LA","1. Leadership",1,"Governance and Leadership",1.1000000000000001,7,{"$f":"'1. LA - Leadership'!G16","v":"Please Select"},{"$f":"'1. LA - Leadership'!H16","v":"Please Select"},{"$f":"VLOOKUP(G8,'LA - mapping'!$B$6:$C$9,2,0)","v":0},{"$f":"VLOOKUP(H8,'LA - mapping'!$B$6:$C$9,2,0)","v":0}]
["LA","1. Leadership",1,"Governance and Leadership",1.1000000000000001,8,{"$f":"'1. LA - Leadership'!G17","v":"Please Select"},{"$f":"'1. LA - Leadership'!H17","v":"Please Select"},{"$f":"VLOOKUP(G9,'LA - mapping'!$B$6:$C$9,2,0)","v":0},{"$f":"VLOOKUP(H9,'LA - mapping'!$B$6:$C$9,2,0)","v":0}]
["LA","1. Leadership",1,"Governance and Leadership",1.1000000000000001,9,{"$f":"'1. LA - Leadership'!G18","v":"Please Select"},{"$f":"'1. LA - Leadership'!H18","v":"Please Select"},{"$f":"VLOOKUP(G10,'LA - mapping'!$B$6:$C$9,2,0)","v":0},{"$f":"VLOOKUP(H10,'LA - mapping'!$B$6:$C$9,2,0)","v":0}]
["LA","1. Leadership",1,"Requests for high cost residential or specialist placements for children and young people with complex needs",1.2,1,{"$f":"'1. LA - Leadership'!G39","v":"Please Select"},{"$f":"'1. LA - Leadership'!H39","v":"Please Select"},{"$f":"VLOOKUP(G11,'LA - mapping'!$B$6:$C$9,2,0)","v":0},{"$f":"VLOOKUP(H11,'LA - mapping'!$B$6:$C$9,2,0)","v":0}]
["LA","1. Leadership",1,"Requests for high cost residential or specialist placements for children and young people with complex needs",1.2,2,{"$f":"'1. LA - Leadership'!G40","v":"Please Select"},{"$f":"'1. LA - Leadership'!H40","v":"Please Select"},{"$f":"VLOOKUP(G12,'LA - mapping'!$B$6:$C$9,2,0)","v":0},{"$f":"VLOOKUP(H12,'LA - mapping'!$B$6:$C$9,2,0)","v":0}]
["LA","1. Leadership",1,"Requests for high cost residential or specialist placements for children and young people with complex needs",1.2,3,{"$f":"'1. LA - Leadership'!G41","v":"Please Select"},{"$f":"'1. LA - Leadership'!H41","v":"Please Select"},{"$f":"VLOOKUP(G13,'LA - mapping'!$B$6:$C$9,2,0)","v":0},{"$f":"VLOOKUP(H13,'LA - mapping'!$B$6:$C$9,2,0)","v":0}]
["LA","1. Leadership",1,"Monitoring and Agreeing Plans",1.3,1,{"$f":"'1. LA - Leadership'!G56","v":"Please Select"},{"$f":"'1. LA - Leadership'!H56","v":"Please Select"},{"$f":"VLOOKUP(G14,'LA - mapping'!$B$6:$C$9,2,0)","v":0},{"$f":"VLOOKUP(H14,'LA - mapping'!$B$6:$C$9,2,0)","v":0}]
["LA","1. Leadership",1,"Monitoring and Agreeing Plans",1.3,2,{"$f":"'1. LA - Leadership'!G57","v":"Please Select"},{"$f":"'1. LA - Leadership'!H57","v":"Please Select"},{"$f":"VLOOKUP(G15,'LA - mapping'!$B$6:$C$9,2,0)","v":0},{"$f":"VLOOKUP(H15,'LA - mapping'!$B$6:$C$9,2,0)","v":0}]
["LA","1. Leadership",1,"Resourcing Joint Arrangements",1.4,1,{"$f":"'1. LA - Leadership'!G76","v":"Please Select"},{"$f":"'1. LA - Leadership'!H76","v":"Please Select"},{"$f":"VLOOKUP(G16,'LA - mapping'!$B$6:$C$9,2,0)","v":0},{"$f":"VLOOKUP(H16,'LA - mapping'!$B$6:$C$9,2,0)","v":0}]
["LA","1. Leadership",1,"Resourcing Joint Arrangements",1.4,2,{"$f":"'1. LA - Leadership'!G77","v":"Please Select"},{"$f":"'1. LA - Leadership'!H77","v":"Please Select"},{"$f":"VLOOKUP(G17,'LA - mapping'!$B$6:$C$9,2,0)","v":0},{"$f":"VLOOKUP(H17,'LA - mapping'!$B$6:$C$9,2,0)","v":0}]
["LA","1. Leadership",1,"Resourcing Joint Arrangements",1.4,3,{"$f":"'1. LA - Leadership'!G78","v":"Please Select"},{"$f":"'1. LA - Leadership'!H78","v":"Please Select"},{"$f":"VLOOKUP(G18,'LA - mapping'!$B$6:$C$9,2,0)","v":0},{"$f":"VLOOKUP(H18,'LA - mapping'!$B$6:$C$9,2,0)","v":0}]
["LA","1. Leadership",1,"Resourcing Joint Arrangements",1.4,4,{"$f":"'1. LA - Leadership'!G79","v":"Please Select"},{"$f":"'1. LA - Leadership'!H79","v":"Please Select"},{"$f":"VLOOKUP(G19,'LA - mapping'!$B$6:$C$9,2,0)","v":0},{"$f":"VLOOKUP(H19,'LA - mapping'!$B$6:$C$9,2,0)","v":0}]
["LA","2. Joint Arrangements",2,"Joint Arrangements",2.1,1,{"$f":"'2. LA - Joint Arrangements'!G10","v":"Please Select"},{"$f":"'2. LA - Joint Arrangements'!H10","v":"Please Select"},{"$f":"VLOOKUP(G20,'LA - mapping'!$B$6:$C$9,2,0)","v":0},{"$f":"VLOOKUP(H20,'LA - mapping'!$B$6:$C$9,2,0)","v":0}]
["LA","2. Joint Arrangements",2,"Joint Arrangements",2.1,2,{"$f":"'2. LA - Joint Arrangements'!G11","v":"Please Select"},{"$f":"'2. LA - Joint Arrangements'!H11","v":"Please Select"},{"$f":"VLOOKUP(G21,'LA - mapping'!$B$6:$C$9,2,0)","v":0},{"$f":"VLOOKUP(H21,'LA - mapping'!$B$6:$C$9,2,0)","v":0}]
["LA","2. Joint Arrangements",2,"Joint Arrangements",2.1,3,{"$f":"'2. LA - Joint Arrangements'!G12","v":"Please Select"},{"$f":"'2. LA - Joint Arrangements'!H12","v":"Please Select"},{"$f":"VLOOKUP(G22,'LA - mapping'!$B$6:$C$9,2,0)","v":0},{"$f":"VLOOKUP(H22,'LA - mapping'!$B$6:$C$9,2,0)","v":0}]
["LA","2. Joint Arrangements",2,"Joint Arrangements",2.1,4,{"$f":"'2. LA - Joint Arrangements'!G13","v":"Please Select"},{"$f":"'2. LA - Joint Arrangements'!H13","v":"Please Select"},{"$f":"VLOOKUP(G23,'LA - mapping'!$B$6:$C$9,2,0)","v":0},{"$f":"VLOOKUP(H23,'LA - mapping'!$B$6:$C$9,2,0)","v":0}]
["LA","2. Joint Arrangements",2,"Joint Arrangements",2.1,5,{"$f":"'2. LA - Joint Arrangements'!G14","v":"Please Select"},{"$f":"'2. LA - Joint Arrangements'!H14","v":"Please Select"},{"$f":"VLOOKUP(G24,'LA - mapping'!$B$6:$C$9,2,0)","v":0},{"$f":"VLOOKUP(H24,'LA - mapping'!$B$6:$C$9,2,0)","v":0}]
["LA","2. Joint Arrangements",2,"Joint Arrangements",2.1,6,{"$f":"'2. LA - Joint Arrangements'!G15","v":"Please Select"},{"$f":"'2. LA - Joint Arrangements'!H15","v":"Please Select"},{"$f":"VLOOKUP(G25,'LA - mapping'!$B$6:$C$9,2,0)","v":0},{"$f":"VLOOKUP(H25,'LA - mapping'!$B$6:$C$9,2,0)","v":0}]
["LA","2. Joint Arrangements",2,"Joint Arrangements",2.1,7,{"$f":"'2. LA - Joint Arrangements'!G16","v":"Please Select"},{"$f":"'2. LA - Joint Arrangements'!H16","v":"Please Select"},{"$f":"VLOOKUP(G26,'LA - mapping'!$B$6:$C$9,2,0)","v":0},{"$f":"VLOOKUP(H26,'LA - mapping'!$B$6:$C$9,2,0)","v":0}]
["LA","2. Joint Arrangements",2,"Joint Arrangements",2.1,8,{"$f":"'2. LA - Joint Arrangements'!G17","v":"Please Select"},{"$f":"'2. LA - Joint Arrangements'!H17","v":"Please Select"},{"$f":"VLOOKUP(G27,'LA - mapping'!$B$6:$C$9,2,0)","v":0},{"$f":"VLOOKUP(H27,'LA - mapping'!$B$6:$C$9,2,0)","v":0}]
["LA","2. Joint Arrangements",2,"Joint Arrangements",2.1,9,{"$f":"'2. LA - Joint Arrangements'!G18","v":"Please Select"},{"$f":"'2. LA - Joint Arrangements'!H18","v":"Please Select"},{"$f":"VLOOKUP(G28,'LA - mapping'!$B$6:$C$9,2,0)","v":0},{"$f":"VLOOKUP(H28,'LA - mapping'!$B$6:$C$9,2,0)","v":0}]
["LA","2. Joint Arrangements",2,"Health and Wellbeing Boards",2.2000000000000002,1,{"$f":"'2. LA - Joint Arrangements'!G42","v":"Please Select"},{"$f":"'2. LA - Joint Arrangements'!H42","v":"Please Select"},{"$f":"VLOOKUP(G29,'LA - mapping'!$B$6:$C$9,2,0)","v":0},{"$f":"VLOOKUP(H29,'LA - mapping'!$B$6:$C$9,2,0)","v":0}]
["LA","2. Joint Arrangements",2,"Health and Wellbeing Boards",2.2000000000000002,2,{"$f":"'2. LA - Joint Arrangements'!G43","v":"Please Select"},{"$f":"'2. LA - Joint Arrangements'!H43","v":"Please Select"},{"$f":"VLOOKUP(G30,'LA - mapping'!$B$6:$C$9,2,0)","v":0},{"$f":"VLOOKUP(H30,'LA - mapping'!$B$6:$C$9,2,0)","v":0}]
["LA","2. Joint Arrangements",2,"Health and Wellbeing Boards",2.2000000000000002,3,{"$f":"'2. LA - Joint Arrangements'!G44","v":"Please Select"},{"$f":"'2. LA - Joint Arrangements'!H44","v":"Please Select"},{"$f":"VLOOKUP(G31,'LA - mapping'!$B$6:$C$9,2,0)","v":0},{"$f":"VLOOKUP(H31,'LA - mapping'!$B$6:$C$9,2,0)","v":0}]
["LA","2. Joint Arrangements",2,"Health and Wellbeing Boards",2.2000000000000002,4,{"$f":"'2. LA - Joint Arrangements'!G45","v":"Please Select"},{"$f":"'2. LA - Joint Arrangements'!H45","v":"Please Select"},{"$f":"VLOOKUP(G32,'LA - mapping'!$B$6:$C$9,2,0)","v":0},{"$f":"VLOOKUP(H32,'LA - mapping'!$B$6:$C$9,2,0)","v":0}]
["LA","2. Joint Arrangements",2,"Dispute Resolution",2.2999999999999998,1,{"$f":"'2. LA - Joint Arrangements'!G69","v":"Please Select"},{"$f":"'2. LA - Joint Arrangements'!H69","v":"Please Select"},{"$f":"VLOOKUP(G33,'LA - mapping'!$B$6:$C$9,2,0)","v":0},{"$f":"VLOOKUP(H33,'LA - mapping'!$B$6:$C$9,2,0)","v":0}]
["LA","2. Joint Arrangements",2,"Dispute Resolution",2.2999999999999998,2,{"$f":"'2. LA - Joint Arrangements'!G70","v":"Please Select"},{"$f":"'2. LA - Joint Arrangements'!H70","v":"Please Select"},{"$f":"VLOOKUP(G34,'LA - mapping'!$B$6:$C$9,2,0)","v":0},{"$f":"VLOOKUP(H34,'LA - mapping'!$B$6:$C$9,2,0)","v":0}]
["LA","2. Joint Arrangements",2,"Dispute Resolution",2.2999999999999998,3,{"$f":"'2. LA - Joint Arrangements'!G71","v":"Please Select"},{"$f":"'2. LA - Joint Arrangements'!H71","v":"Please Select"},{"$f":"VLOOKUP(G35,'LA - mapping'!$B$6:$C$9,2,0)","v":0},{"$f":"VLOOKUP(H35,'LA - mapping'!$B$6:$C$9,2,0)","v":0}]
["LA","2. Joint Arrangements",2,"Local Offer",2.4,1,{"$f":"'2. LA - Joint Arrangements'!G89","v":"Please Select"},{"$f":"'2. LA - Joint Arrangements'!H89","v":"Please Select"},{"$f":"VLOOKUP(G36,'LA - mapping'!$B$6:$C$9,2,0)","v":0},{"$f":"VLOOKUP(H36,'LA - mapping'!$B$6:$C$9,2,0)","v":0}]
["LA","2. Joint Arrangements",2,"Local Offer",2.4,2,{"$f":"'2. LA - Joint Arrangements'!G90","v":"Please Select"},{"$f":"'2. LA - Joint Arrangements'!H90","v":"Please Select"},{"$f":"VLOOKUP(G37,'LA - mapping'!$B$6:$C$9,2,0)","v":0},{"$f":"VLOOKUP(H37,'LA - mapping'!$B$6:$C$9,2,0)","v":0}]
["LA","2. Joint Arrangements",2,"Local Offer",2.4,3,{"$f":"'2. LA - Joint Arrangements'!G91","v":"Please Select"},{"$f":"'2. LA - Joint Arrangements'!H91","v":"Please Select"},{"$f":"VLOOKUP(G38,'LA - mapping'!$B$6:$C$9,2,0)","v":0},{"$f":"VLOOKUP(H38,'LA - mapping'!$B$6:$C$9,2,0)","v":0}]
["LA","2. Joint Arrangements",2,"Local Offer",2.4,4,{"$f":"'2. LA - Joint Arrangements'!G92","v":"Please Select"},{"$f":"'2. LA - Joint Arrangements'!H92","v":"Please Select"},{"$f":"VLOOKUP(G39,'LA - mapping'!$B$6:$C$9,2,0)","v":0},{"$f":"VLOOKUP(H39,'LA - mapping'!$B$6:$C$9,2,0)","v":0}]
["LA","2. Joint Arrangements",2,"Local Offer",2.4,5,{"$f":"'2. LA - Joint Arrangements'!G93","v":"Please Select"},{"$f":"'2. LA - Joint Arrangements'!H93","v":"Please Select"},{"$f":"VLOOKUP(G40,'LA - mapping'!$B$6:$C$9,2,0)","v":0},{"$f":"VLOOKUP(H40,'LA - mapping'!$B$6:$C$9,2,0)","v":0}]
["LA","2. Joint Arrangements",2,"Local Offer",2.4,6,{"$f":"'2. LA - Joint Arrangements'!G94","v":"Please Select"},{"$f":"'2. LA - Joint Arrangements'!H94","v":"Please Select"},{"$f":"VLOOKUP(G41,'LA - mapping'!$B$6:$C$9,2,0)","v":0},{"$f":"VLOOKUP(H41,'LA - mapping'!$B$6:$C$9,2,0)","v":0}]
["LA","2. Joint Arrangements",2,"Local Offer",2.4,7,{"$f":"'2. LA - Joint Arrangements'!G95","v":"Please Select"},{"$f":"'2. LA - Joint Arrangements'!H95","v":"Please Select"},{"$f":"VLOOKUP(G42,'LA - mapping'!$B$6:$C$9,2,0)","v":0},{"$f":"VLOOKUP(H42,'LA - mapping'!$B$6:$C$9,2,0)","v":0}]
["LA","2. Joint Arrangements",2,"Local Offer",2.4,8,{"$f":"'2. LA - Joint Arrangements'!G96","v":"Please Select"},{"$f":"'2. LA - Joint Arrangements'!H96","v":"Please Select"},{"$f":"VLOOKUP(G43,'LA - mapping'!$B$6:$C$9,2,0)","v":0},{"$f":"VLOOKUP(H43,'LA - mapping'!$B$6:$C$9,2,0)","v":0}]
["LA","2. Joint Arrangements",2,"Local Offer",2.4,9,{"$f":"'2. LA - Joint Arrangements'!G97","v":"Please Select"},{"$f":"'2. LA - Joint Arrangements'!H97","v":"Please Select"},{"$f":"VLOOKUP(G44,'LA - mapping'!$B$6:$C$9,2,0)","v":0},{"$f":"VLOOKUP(H44,'LA - mapping'!$B$6:$C$9,2,0)","v":0}]
["LA","2. Joint Arrangements",2,"Local Offer",2.4,10,{"$f":"'2. LA - Joint Arrangements'!G98","v":"Please Select"},{"$f":"'2. LA - Joint Arrangements'!H98","v":"Please Select"},{"$f":"VLOOKUP(G45,'LA - mapping'!$B$6:$C$9,2,0)","v":0},{"$f":"VLOOKUP(H45,'LA - mapping'!$B$6:$C$9,2,0)","v":0}]
["LA","2. Joint Arrangements",2,"Local Offer",2.4,11,{"$f":"'2. LA - Joint Arrangements'!G99","v":"Please Select"},{"$f":"'2. LA - Joint Arrangements'!H99","v":"Please Select"},{"$f":"VLOOKUP(G46,'LA - mapping'!$B$6:$C$9,2,0)","v":0},{"$f":"VLOOKUP(H46,'LA - mapping'!$B$6:$C$9,2,0)","v":0}]
["LA","2. Joint Arrangements",2,"Local Offer",2.4,12,{"$f":"'2. LA - Joint Arrangements'!G100","v":"Please Select"},{"$f":"'2. LA - Joint Arrangements'!H100","v":"Please Select"},{"$f":"VLOOKUP(G47,'LA - mapping'!$B$6:$C$9,2,0)","v":0},{"$f":"VLOOKUP(H47,'LA - mapping'!$B$6:$C$9,2,0)","v":0}]
["LA","2. Joint Arrangements",2,"Local Offer",2.4,13,{"$f":"'2. LA - Joint Arrangements'!G101","v":"Please Select"},{"$f":"'2. LA - Joint Arrangements'!H101","v":"Please Select"},{"$f":"VLOOKUP(G48,'LA - mapping'!$B$6:$C$9,2,0)","v":0},{"$f":"VLOOKUP(H48,'LA - mapping'!$B$6:$C$9,2,0)","v":0}]
["LA","2. Joint Arrangements",2,"Local Offer",2.4,14,{"$f":"'2. LA - Joint Arrangements'!G102","v":"Please Select"},{"$f":"'2. LA - Joint Arrangements'!H102","v":"Please Select"},{"$f":"VLOOKUP(G49,'LA - mapping'!$B$6:$C$9,2,0)","v":0},{"$f":"VLOOKUP(H49,'LA - mapping'!$B$6:$C$9,2,0)","v":0}]
["LA","3. Commissioning",3,"Assessing Local Need",3.1,1,{"$f":"'3. LA - Commissioning'!G10","v":"Please Select"},{"$f":"'3. LA - Commissioning'!H10","v":"Please Select"},{"$f":"VLOOKUP(G50,'LA - mapping'!$B$6:$C$9,2,0)","v":0},{"$f":"VLOOKUP(H50,'LA - mapping'!$B$6:$C$9,2,0)","v":0}]
["LA","3. Commissioning",3,"Assessing Local Need",3.1,2,{"$f":"'3. LA - Commissioning'!G11","v":"Please Select"},{"$f":"'3. LA - Commissioning'!H11","v":"Please Select"},{"$f":"VLOOKUP(G51,'LA - mapping'!$B$6:$C$9,2,0)","v":0},{"$f":"VLOOKUP(H51,'LA - mapping'!$B$6:$C$9,2,0)","v":0}]
["LA","3. Commissioning",3,"Assessing Local Need",3.1,3,{"$f":"'3. LA - Commissioning'!G12","v":"Please Select"},{"$f":"'3. LA - Commissioning'!H12","v":"Please Select"},{"$f":"VLOOKUP(G52,'LA - mapping'!$B$6:$C$9,2,0)","v":0},{"$f":"VLOOKUP(H52,'LA - mapping'!$B$6:$C$9,2,0)","v":0}]
["LA","3. Commissioning",3,"Assessing Local Need",3.1,4,{"$f":"'3. LA - Commissioning'!G13","v":"Please Select"},{"$f":"'3. LA - Commissioning'!H13","v":"Please Select"},{"$f":"VLOOKUP(G53,'LA - mapping'!$B$6:$C$9,2,0)","v":0},{"$f":"VLOOKUP(H53,'LA - mapping'!$B$6:$C$9,2,0)","v":0}]
["LA","3. Commissioning",3,"Assessing Local Need",3.1,5,{"$f":"'3. LA - Commissioning'!G14","v":"Please Select"},{"$f":"'3. LA - Commissioning'!H14","v":"Please Select"},{"$f":"VLOOKUP(G54,'LA - mapping'!$B$6:$C$9,2,0)","v":0},{"$f":"VLOOKUP(H54,'LA - mapping'!$B$6:$C$9,2,0)","v":0}]
["LA","3. Commissioning",3,"Assessing Local Need",3.1,6,{"$f":"'3. LA - Commissioning'!G15","v":"Please Select"},{"$f":"'3. LA - Commissioning'!H15","v":"Please Select"},{"$f":"VLOOKUP(G55,'LA - mapping'!$B$6:$C$9,2,0)","v":0},{"$f":"VLOOKUP(H55,'LA - mapping'!$B$6:$C$9,2,0)","v":0}]
["LA","3. Commissioning",3,"Affordability and Demand",3.2,1,{"$f":"'3. LA - Commissioning'!G36","v":"Please Select"},{"$f":"'3. LA - Commissioning'!H36","v":"Please Select"},{"$f":"VLOOKUP(G56,'LA - mapping'!$B$6:$C$9,2,0)","v":0},{"$f":"VLOOKUP(H56,'LA - mapping'!$B$6:$C$9,2,0)","v":0}]
["LA","3. Commissioning",3,"Affordability and Demand",3.2,2,{"$f":"'3. LA - Commissioning'!G37","v":"Please Select"},{"$f":"'3. LA - Commissioning'!H37","v":"Please Select"},{"$f":"VLOOKUP(G57,'LA - mapping'!$B$6:$C$9,2,0)","v":0},{"$f":"VLOOKUP(H57,'LA - mapping'!$B$6:$C$9,2,0)","v":0}]
["LA","3. Commissioning",3,"Affordability and Demand",3.2,3,{"$f":"'3. LA - Commissioning'!G38","v":"Please Select"},{"$f":"'3. LA - Commissioning'!H38","v":"Please Select"},{"$f":"VLOOKUP(G58,'LA - mapping'!$B$6:$C$9,2,0)","v":0},{"$f":"VLOOKUP(H58,'LA - mapping'!$B$6:$C$9,2,0)","v":0}]
["LA","3. Commissioning",3,"Affordability and Demand",3.2,4,{"$f":"'3. LA - Commissioning'!G39","v":"Please Select"},{"$f":"'3. LA - Commissioning'!H39","v":"Please Select"},{"$f":"VLOOKUP(G59,'LA - mapping'!$B$6:$C$9,2,0)","v":0},{"$f":"VLOOKUP(H59,'LA - mapping'!$B$6:$C$9,2,0)","v":0}]
["LA","3. Commissioning",3,"Affordability and Demand",3.2,5,{"$f":"'3. LA - Commissioning'!G40","v":"Please Select"},{"$f":"'3. LA - Commissioning'!H40","v":"Please Select"},{"$f":"VLOOKUP(G60,'LA - mapping'!$B$6:$C$9,2,0)","v":0},{"$f":"VLOOKUP(H60,'LA - mapping'!$B$6:$C$9,2,0)","v":0}]
["LA","3. Commissioning",3,"Affordability and Demand",3.2,6,{"$f":"'3. LA - Commissioning'!G41","v":"Please Select"},{"$f":"'3. LA - Commissioning'!H41","v":"Please Select"},{"$f":"VLOOKUP(G61,'LA - mapping'!$B$6:$C$9,2,0)","v":0},{"$f":"VLOOKUP(H61,'LA - mapping'!$B$6:$C$9,2,0)","v":0}]
["LA","3. Commissioning",3,"Contracts",3.3,1,{"$f":"'3. LA - Commissioning'!G62","v":"Please Select"},{"$f":"'3. LA - Commissioning'!H62","v":"Please Select"},{"$f":"VLOOKUP(G62,'LA - mapping'!$B$6:$C$9,2,0)","v":0},{"$f":"VLOOKUP(H62,'LA - mapping'!$B$6:$C$9,2,0)","v":0}]
["LA","3. Commissioning",3,"Contracts",3.3,2,{"$f":"'3. LA - Commissioning'!G63","v":"Please Select"},{"$f":"'3. LA - Commissioning'!H63","v":"Please Select"},{"$f":"VLOOKUP(G63,'LA - mapping'!$B$6:$C$9,2,0)","v":0},{"$f":"VLOOKUP(H63,'LA - mapping'!$B$6:$C$9,2,0)","v":0}]
["LA","3. Commissioning",3,"Contracts",3.3,3,{"$f":"'3. LA - Commissioning'!G64","v":"Please Select"},{"$f":"'3. LA - Commissioning'!H64","v":"Please Select"},{"$f":"VLOOKUP(G64,'LA - mapping'!$B$6:$C$9,2,0)","v":0},{"$f":"VLOOKUP(H64,'LA - mapping'!$B$6:$C$9,2,0)","v":0}]
["LA","3. Commissioning",3,"Personal Budgets",3.4,1,{"$f":"'3. LA - Commissioning'!G88","v":"Please Select"},{"$f":"'3. LA - Commissioning'!H88","v":"Please Select"},{"$f":"VLOOKUP(G65,'LA - mapping'!$B$6:$C$9,2,0)","v":0},{"$f":"VLOOKUP(H65,'LA - mapping'!$B$6:$C$9,2,0)","v":0}]
["LA","3. Commissioning",3,"Personal Budgets",3.4,2,{"$f":"'3. LA - Commissioning'!G89","v":"Please Select"},{"$f":"'3. LA - Commissioning'!H89","v":"Please Select"},{"$f":"VLOOKUP(G66,'LA - mapping'!$B$6:$C$9,2,0)","v":0},{"$f":"VLOOKUP(H66,'LA - mapping'!$B$6:$C$9,2,0)","v":0}]
["LA","3. Commissioning",3,"Personal Budgets",3.4,3,{"$f":"'3. LA - Commissioning'!G90","v":"Please Select"},{"$f":"'3. LA - Commissioning'!H90","v":"Please Select"},{"$f":"VLOOKUP(G67,'LA - mapping'!$B$6:$C$9,2,0)","v":0},{"$f":"VLOOKUP(H67,'LA - mapping'!$B$6:$C$9,2,0)","v":0}]
["LA","3. Commissioning",3,"Designated Medical Officer / Designated Clinical Officer",3.5,1,{"$f":"'3. LA - Commissioning'!G117","v":"Please Select"},{"$f":"'3. LA - Commissioning'!H117","v":"Please Select"},{"$f":"VLOOKUP(G68,'LA - mapping'!$B$6:$C$9,2,0)","v":0},{"$f":"VLOOKUP(H68,'LA - mapping'!$B$6:$C$9,2,0)","v":0}]
["LA","4. Education, Health & Care Plan",4,"SEN Support and Early Help (Coordinated assessment) ",4.0999999999999996,1,{"$f":"'4. LA - EHC Plan'!G10","v":"Please Select"},{"$f":"'4. LA - EHC Plan'!H10","v":"Please Select"},{"$f":"VLOOKUP(G69,'LA - mapping'!$B$6:$C$9,2,0)","v":0},{"$f":"VLOOKUP(H69,'LA - mapping'!$B$6:$C$9,2,0)","v":0}]
["LA","4. Education, Health & Care Plan",4,"SEN Support and Early Help (Coordinated assessment) ",4.0999999999999996,2,{"$f":"'4. LA - EHC Plan'!G11","v":"Please Select"},{"$f":"'4. LA - EHC Plan'!H11","v":"Please Select"},{"$f":"VLOOKUP(G70,'LA - mapping'!$B$6:$C$9,2,0)","v":0},{"$f":"VLOOKUP(H70,'LA - mapping'!$B$6:$C$9,2,0)","v":0}]
["LA","4. Education, Health & Care Plan",4,"SEN Support and Early Help (Coordinated assessment) ",4.0999999999999996,3,{"$f":"'4. LA - EHC Plan'!G12","v":"Please Select"},{"$f":"'4. LA - EHC Plan'!H12","v":"Please Select"},{"$f":"VLOOKUP(G71,'LA - mapping'!$B$6:$C$9,2,0)","v":0},{"$f":"VLOOKUP(H71,'LA - mapping'!$B$6:$C$9,2,0)","v":0}]
["LA","4. Education, Health & Care Plan",4,"SEN Support and Early Help (Coordinated assessment) ",4.0999999999999996,4,{"$f":"'4. LA - EHC Plan'!G13","v":"Please Select"},{"$f":"'4. LA - EHC Plan'!H13","v":"Please Select"},{"$f":"VLOOKUP(G72,'LA - mapping'!$B$6:$C$9,2,0)","v":0},{"$f":"VLOOKUP(H72,'LA - mapping'!$B$6:$C$9,2,0)","v":0}]
["LA","4. Education, Health & Care Plan",4,"SEN Support and Early Help (Coordinated assessment) ",4.0999999999999996,5,{"$f":"'4. LA - EHC Plan'!G14","v":"Please Select"},{"$f":"'4. LA - EHC Plan'!H14","v":"Please Select"},{"$f":"VLOOKUP(G73,'LA - mapping'!$B$6:$C$9,2,0)","v":0},{"$f":"VLOOKUP(H73,'LA - mapping'!$B$6:$C$9,2,0)","v":0}]
["LA","4. Education, Health & Care Plan",4,"SEN Support and Early Help (Coordinated assessment) ",4.0999999999999996,6,{"$f":"'4. LA - EHC Plan'!G15","v":"Please Select"},{"$f":"'4. LA - EHC Plan'!H15","v":"Please Select"},{"$f":"VLOOKUP(G74,'LA - mapping'!$B$6:$C$9,2,0)","v":0},{"$f":"VLOOKUP(H74,'LA - mapping'!$B$6:$C$9,2,0)","v":0}]
["LA","4. Education, Health & Care Plan",4,"EHC Needs Assessment (Coordinated Specialist Assessment)",4.2,1,{"$f":"'4. LA - EHC Plan'!G33","v":"Please Select"},{"$f":"'4. LA - EHC Plan'!H33","v":"Please Select"},{"$f":"VLOOKUP(G75,'LA - mapping'!$B$6:$C$9,2,0)","v":0},{"$f":"VLOOKUP(H75,'LA - mapping'!$B$6:$C$9,2,0)","v":0}]
["LA","4. Education, Health & Care Plan",4,"EHC Needs Assessment (Coordinated Specialist Assessment)",4.2,2,{"$f":"'4. LA - EHC Plan'!G34","v":"Please Select"},{"$f":"'4. LA - EHC Plan'!H34","v":"Please Select"},{"$f":"VLOOKUP(G76,'LA - mapping'!$B$6:$C$9,2,0)","v":0},{"$f":"VLOOKUP(H76,'LA - mapping'!$B$6:$C$9,2,0)","v":0}]
["LA","4. Education, Health & Care Plan",4,"EHC Needs Assessment (Coordinated Specialist Assessment)",4.2,3,{"$f":"'4. LA - EHC Plan'!G35","v":"Please Select"},{"$f":"'4. LA - EHC Plan'!H35","v":"Please Select"},{"$f":"VLOOKUP(G77,'LA - mapping'!$B$6:$C$9,2,0)","v":0},{"$f":"VLOOKUP(H77,'LA - mapping'!$B$6:$C$9,2,0)","v":0}]
["LA","4. Education, Health & Care Plan",4,"EHC Needs Assessment (Coordinated Specialist Assessment)",4.2,4,{"$f":"'4. LA - EHC Plan'!G36","v":"Please Select"},{"$f":"'4. LA - EHC Plan'!H36","v":"Please Select"},{"$f":"VLOOKUP(G78,'LA - mapping'!$B$6:$C$9,2,0)","v":0},{"$f":"VLOOKUP(H78,'LA - mapping'!$B$6:$C$9,2,0)","v":0}]
["LA","4. Education, Health & Care Plan",4,"EHC Needs Assessment (Coordinated Specialist Assessment)",4.2,5,{"$f":"'4. LA - EHC Plan'!G37","v":"Please Select"},{"$f":"'4. LA - EHC Plan'!H37","v":"Please Select"},{"$f":"VLOOKUP(G79,'LA - mapping'!$B$6:$C$9,2,0)","v":0},{"$f":"VLOOKUP(H79,'LA - mapping'!$B$6:$C$9,2,0)","v":0}]
["LA","4. Education, Health & Care Plan",4,"EHC Needs Assessment (Coordinated Specialist Assessment)",4.2,6,{"$f":"'4. LA - EHC Plan'!G38","v":"Please Select"},{"$f":"'4. LA - EHC Plan'!H38","v":"Please Select"},{"$f":"VLOOKUP(G80,'LA - mapping'!$B$6:$C$9,2,0)","v":0},{"$f":"VLOOKUP(H80,'LA - mapping'!$B$6:$C$9,2,0)","v":0}]
["LA","4. Education, Health & Care Plan",4,"EHC Needs Assessment (Coordinated Specialist Assessment)",4.2,7,{"$f":"'4. LA - EHC Plan'!G39","v":"Please Select"},{"$f":"'4. LA - EHC Plan'!H39","v":"Please Select"},{"$f":"VLOOKUP(G81,'LA - mapping'!$B$6:$C$9,2,0)","v":0},{"$f":"VLOOKUP(H81,'LA - mapping'!$B$6:$C$9,2,0)","v":0}]
["LA","4. Education, Health & Care Plan",4,"Sign Off",4.3,1,{"$f":"'4. LA - EHC Plan'!G63","v":"Please Select"},{"$f":"'4. LA - EHC Plan'!H63","v":"Please Select"},{"$f":"VLOOKUP(G82,'LA - mapping'!$B$6:$C$9,2,0)","v":0},{"$f":"VLOOKUP(H82,'LA - mapping'!$B$6:$C$9,2,0)","v":0}]
["LA","4. Education, Health & Care Plan",4,"Sign Off",4.3,2,{"$f":"'4. LA - EHC Plan'!G64","v":"Please Select"},{"$f":"'4. LA - EHC Plan'!H64","v":"Please Select"},{"$f":"VLOOKUP(G83,'LA - mapping'!$B$6:$C$9,2,0)","v":0},{"$f":"VLOOKUP(H83,'LA - mapping'!$B$6:$C$9,2,0)","v":0}]
["LA","4. Education, Health & Care Plan",4,"Sign Off",4.3,3,{"$f":"'4. LA - EHC Plan'!G65","v":"Please Select"},{"$f":"'4. LA - EHC Plan'!H65","v":"Please Select"},{"$f":"VLOOKUP(G84,'LA - mapping'!$B$6:$C$9,2,0)","v":0},{"$f":"VLOOKUP(H84,'LA - mapping'!$B$6:$C$9,2,0)","v":0}]
["LA","4. Education, Health & Care Plan",4,"Sign Off",4.3,4,{"$f":"'4. LA - EHC Plan'!G66","v":"Please Select"},{"$f":"'4. LA - EHC Plan'!H66","v":"Please Select"},{"$f":"VLOOKUP(G85,'LA - mapping'!$B$6:$C$9,2,0)","v":0},{"$f":"VLOOKUP(H85,'LA - mapping'!$B$6:$C$9,2,0)","v":0}]
["LA","4. Education, Health & Care Plan",4,"Sign Off",4.3,5,{"$f":"'4. LA - EHC Plan'!G67","v":"Please Select"},{"$f":"'4. LA - EHC Plan'!H67","v":"Please Select"},{"$f":"VLOOKUP(G86,'LA - mapping'!$B$6:$C$9,2,0)","v":0},{"$f":"VLOOKUP(H86,'LA - mapping'!$B$6:$C$9,2,0)","v":0}]
["LA","4. Education, Health & Care Plan",4,"Sign Off",4.3,6,{"$f":"'4. LA - EHC Plan'!G68","v":"Please Select"},{"$f":"'4. LA - EHC Plan'!H68","v":"Please Select"},{"$f":"VLOOKUP(G87,'LA - mapping'!$B$6:$C$9,2,0)","v":0},{"$f":"VLOOKUP(H87,'LA - mapping'!$B$6:$C$9,2,0)","v":0}]
["LA","4. Education, Health & Care Plan",4,"Sign Off",4.3,7,{"$f":"'4. LA - EHC Plan'!G69","v":"Please Select"},{"$f":"'4. LA - EHC Plan'!H69","v":"Please Select"},{"$f":"VLOOKUP(G88,'LA - mapping'!$B$6:$C$9,2,0)","v":0},{"$f":"VLOOKUP(H88,'LA - mapping'!$B$6:$C$9,2,0)","v":0}]
["LA","4. Education, Health & Care Plan",4,"Sign Off",4.3,8,{"$f":"'4. LA - EHC Plan'!G70","v":"Please Select"},{"$f":"'4. LA - EHC Plan'!H70","v":"Please Select"},{"$f":"VLOOKUP(G89,'LA - mapping'!$B$6:$C$9,2,0)","v":0},{"$f":"VLOOKUP(H89,'LA - mapping'!$B$6:$C$9,2,0)","v":0}]
["LA","5. Co-Production (Engagement)",5,"Children, Young People and Parents",5.0999999999999996,1,{"$f":"'5. LA - Co-Production'!G10","v":"Please Select"},{"$f":"'5. LA - Co-Production'!H10","v":"Please Select"},{"$f":"VLOOKUP(G90,'LA - mapping'!$B$6:$C$9,2,0)","v":0},{"$f":"VLOOKUP(H90,'LA - mapping'!$B$6:$C$9,2,0)","v":0}]
["LA","5. Co-Production (Engagement)",5,"Children, Young People and Parents",5.0999999999999996,2,{"$f":"'5. LA - Co-Production'!G11","v":"Please Select"},{"$f":"'5. LA - Co-Production'!H11","v":"Please Select"},{"$f":"VLOOKUP(G91,'LA - mapping'!$B$6:$C$9,2,0)","v":0},{"$f":"VLOOKUP(H91,'LA - mapping'!$B$6:$C$9,2,0)","v":0}]
["LA","5. Co-Production (Engagement)",5,"Children, Young People and Parents",5.0999999999999996,3,{"$f":"'5. LA - Co-Production'!G12","v":"Please Select"},{"$f":"'5. LA - Co-Production'!H12","v":"Please Select"},{"$f":"VLOOKUP(G92,'LA - mapping'!$B$6:$C$9,2,0)","v":0},{"$f":"VLOOKUP(H92,'LA - mapping'!$B$6:$C$9,2,0)","v":0}]
["LA","5. Co-Production (Engagement)",5,"Children, Young People and Parents",5.0999999999999996,4,{"$f":"'5. LA - Co-Production'!G13","v":"Please Select"},{"$f":"'5. LA - Co-Production'!H13","v":"Please Select"},{"$f":"VLOOKUP(G93,'LA - mapping'!$B$6:$C$9,2,0)","v":0},{"$f":"VLOOKUP(H93,'LA - mapping'!$B$6:$C$9,2,0)","v":0}]
["LA","5. Co-Production (Engagement)",5,"Children, Young People and Parents",5.0999999999999996,5,{"$f":"'5. LA - Co-Production'!G14","v":"Please Select"},{"$f":"'5. LA - Co-Production'!H14","v":"Please Select"},{"$f":"VLOOKUP(G94,'LA - mapping'!$B$6:$C$9,2,0)","v":0},{"$f":"VLOOKUP(H94,'LA - mapping'!$B$6:$C$9,2,0)","v":0}]
["LA","5. Co-Production (Engagement)",5,"Children, Young People and Parents",5.0999999999999996,6,{"$f":"'5. LA - Co-Production'!G15","v":"Please Select"},{"$f":"'5. LA - Co-Production'!H15","v":"Please Select"},{"$f":"VLOOKUP(G95,'LA - mapping'!$B$6:$C$9,2,0)","v":0},{"$f":"VLOOKUP(H95,'LA - mapping'!$B$6:$C$9,2,0)","v":0}]
["LA","5. Co-Production (Engagement)",5,"Children, Young People and Parents",5.0999999999999996,7,{"$f":"'5. LA - Co-Production'!G16","v":"Please Select"},{"$f":"'5. LA - Co-Production'!H16","v":"Please Select"},{"$f":"VLOOKUP(G96,'LA - mapping'!$B$6:$C$9,2,0)","v":0},{"$f":"VLOOKUP(H96,'LA - mapping'!$B$6:$C$9,2,0)","v":0}]
["LA","5. Co-Production (Engagement)",5,"Children, Young People and Parents",5.0999999999999996,8,{"$f":"'5. LA - Co-Production'!G17","v":"Please Select"},{"$f":"'5. LA - Co-Production'!H17","v":"Please Select"},{"$f":"VLOOKUP(G97,'LA - mapping'!$B$6:$C$9,2,0)","v":0},{"$f":"VLOOKUP(H97,'LA - mapping'!$B$6:$C$9,2,0)","v":0}]
["LA","6. Monitoring & Redress",6,"Data to Monitor Progress",6.1,1,{"$f":"'6. LA - Monitor & Redress'!G10","v":"Please Select"},{"$f":"'6. LA - Monitor & Redress'!H10","v":"Please Select"},{"$f":"VLOOKUP(G98,'LA - mapping'!$B$6:$C$9,2,0)","v":0},{"$f":"VLOOKUP(H98,'LA - mapping'!$B$6:$C$9,2,0)","v":0}]
["LA","6. Monitoring & Redress",6,"Data to Monitor Progress",6.1,2,{"$f":"'6. LA - Monitor & Redress'!G11","v":"Please Select"},{"$f":"'6. LA - Monitor & Redress'!H11","v":"Please Select"},{"$f":"VLOOKUP(G99,'LA - mapping'!$B$6:$C$9,2,0)","v":0},{"$f":"VLOOKUP(H99,'LA - mapping'!$B$6:$C$9,2,0)","v":0}]
["LA","6. Monitoring & Redress",6,"Data to Monitor Progress",6.1,3,{"$f":"'6. LA - Monitor & Redress'!G12","v":"Please Select"},{"$f":"'6. LA - Monitor & Redress'!H12","v":"Please Select"},{"$f":"VLOOKUP(G100,'LA - mapping'!$B$6:$C$9,2,0)","v":0},{"$f":"VLOOKUP(H100,'LA - mapping'!$B$6:$C$9,2,0)","v":0}]
["LA","6. Monitoring & Redress",6,"Data Sharing",6.2,1,{"$f":"'6. LA - Monitor & Redress'!G26","v":"Please Select"},{"$f":"'6. LA - Monitor & Redress'!H26","v":"Please Select"},{"$f":"VLOOKUP(G101,'LA - mapping'!$B$6:$C$9,2,0)","v":0},{"$f":"VLOOKUP(H101,'LA - mapping'!$B$6:$C$9,2,0)","v":0}]
["LA","6. Monitoring & Redress",6,"Data Sharing",6.2,2,{"$f":"'6. LA - Monitor & Redress'!G27","v":"Please Select"},{"$f":"'6. LA - Monitor & Redress'!H27","v":"Please Select"},{"$f":"VLOOKUP(G102,'LA - mapping'!$B$6:$C$9,2,0)","v":0},{"$f":"VLOOKUP(H102,'LA - mapping'!$B$6:$C$9,2,0)","v":0}]
["LA","6. Monitoring & Redress",6,"Data Sharing",6.2,3,{"$f":"'6. LA - Monitor & Redress'!G28","v":"Please Select"},{"$f":"'6. LA - Monitor & Redress'!H28","v":"Please Select"},{"$f":"VLOOKUP(G103,'LA - mapping'!$B$6:$C$9,2,0)","v":0},{"$f":"VLOOKUP(H103,'LA - mapping'!$B$6:$C$9,2,0)","v":0}]
["LA","6. Monitoring & Redress",6,"Data Sharing",6.2,4,{"$f":"'6. LA - Monitor & Redress'!G29","v":"Please Select"},{"$f":"'6. LA - Monitor & Redress'!H29","v":"Please Select"},{"$f":"VLOOKUP(G104,'LA - mapping'!$B$6:$C$9,2,0)","v":0},{"$f":"VLOOKUP(H104,'LA - mapping'!$B$6:$C$9,2,0)","v":0}]
["LA","6. Monitoring & Redress",6,"Disagreement Resolution and Complaints",6.3,1,{"$f":"'6. LA - Monitor & Redress'!G66","v":"Please Select"},{"$f":"'6. LA - Monitor & Redress'!H66","v":"Please Select"},{"$f":"VLOOKUP(G105,'LA - mapping'!$B$6:$C$9,2,0)","v":0},{"$f":"VLOOKUP(H105,'LA - mapping'!$B$6:$C$9,2,0)","v":0}]
["LA","6. Monitoring & Redress",6,"Disagreement Resolution and Complaints",6.3,2,{"$f":"'6. LA - Monitor & Redress'!G67","v":"Please Select"},{"$f":"'6. LA - Monitor & Redress'!H67","v":"Please Select"},{"$f":"VLOOKUP(G106,'LA - mapping'!$B$6:$C$9,2,0)","v":0},{"$f":"VLOOKUP(H106,'LA - mapping'!$B$6:$C$9,2,0)","v":0}]
["LA","6. Monitoring & Redress",6,"Disagreement Resolution and Complaints",6.3,3,{"$f":"'6. LA - Monitor & Redress'!G68","v":"Please Select"},{"$f":"'6. LA - Monitor & Redress'!H68","v":"Please Select"},{"$f":"VLOOKUP(G107,'LA - mapping'!$B$6:$C$9,2,0)","v":0},{"$f":"VLOOKUP(H107,'LA - mapping'!$B$6:$C$9,2,0)","v":0}]
["LA","6. Monitoring & Redress",6,"Disagreement Resolution and Complaints",6.3,4,{"$f":"'6. LA - Monitor & Redress'!G69","v":"Please Select"},{"$f":"'6. LA - Monitor & Redress'!H69","v":"Please Select"},{"$f":"VLOOKUP(G108,'LA - mapping'!$B$6:$C$9,2,0)","v":0},{"$f":"VLOOKUP(H108,'LA - mapping'!$B$6:$C$9,2,0)","v":0}]
["LA","6. Monitoring & Redress",6,"Mediation",6.4,1,{"$f":"'6. LA - Monitor & Redress'!G83","v":"Please Select"},{"$f":"'6. LA - Monitor & Redress'!H83","v":"Please Select"},{"$f":"VLOOKUP(G109,'LA - mapping'!$B$6:$C$9,2,0)","v":0},{"$f":"VLOOKUP(H109,'LA - mapping'!$B$6:$C$9,2,0)","v":0}]
["LA","6. Monitoring & Redress",6,"Mediation",6.4,2,{"$f":"'6. LA - Monitor & Redress'!G84","v":"Please Select"},{"$f":"'6. LA - Monitor & Redress'!H84","v":"Please Select"},{"$f":"VLOOKUP(G110,'LA - mapping'!$B$6:$C$9,2,0)","v":0},{"$f":"VLOOKUP(H110,'LA - mapping'!$B$6:$C$9,2,0)","v":0}]
["LA","6. Monitoring & Redress",6,"Mediation",6.4,3,{"$f":"'6. LA - Monitor & Redress'!G85","v":"Please Select"},{"$f":"'6. LA - Monitor & Redress'!H85","v":"Please Select"},{"$f":"VLOOKUP(G111,'LA - mapping'!$B$6:$C$9,2,0)","v":0},{"$f":"VLOOKUP(H111,'LA - mapping'!$B$6:$C$9,2,0)","v":0}]
["LA","6. Monitoring & Redress",6,"Mediation",6.4,4,{"$f":"'6. LA - Monitor & Redress'!G86","v":"Please Select"},{"$f":"'6. LA - Monitor & Redress'!H86","v":"Please Select"},{"$f":"VLOOKUP(G112,'LA - mapping'!$B$6:$C$9,2,0)","v":0},{"$f":"VLOOKUP(H112,'LA - mapping'!$B$6:$C$9,2,0)","v":0}]
["LA","6. Monitoring & Redress",6,"Mediation",6.4,5,{"$f":"'6. LA - Monitor & Redress'!G87","v":"Please Select"},{"$f":"'6. LA - Monitor & Redress'!H87","v":"Please Select"},{"$f":"VLOOKUP(G113,'LA - mapping'!$B$6:$C$9,2,0)","v":0},{"$f":"VLOOKUP(H113,'LA - mapping'!$B$6:$C$9,2,0)","v":0}]
["LA","6. Monitoring & Redress",6,"Mediation",6.4,6,{"$f":"'6. LA - Monitor & Redress'!G88","v":"Please Select"},{"$f":"'6. LA - Monitor & Redress'!H88","v":"Please Select"},{"$f":"VLOOKUP(G114,'LA - mapping'!$B$6:$C$9,2,0)","v":0},{"$f":"VLOOKUP(H114,'LA - mapping'!$B$6:$C$9,2,0)","v":0}]

{"sheet":"Calc","index":2,"n_rows":35,"n_cols":23,"rows_kept":35,"cut":false,"hidden":true,"merged":[]}
[]
[]
[null,null,null,null,"1st AUDIT: SCORE",null,null,null,"1st AUDIT: PERCENTAGE",null,null,null,null,null,"2nd AUDIT: SCORE",null,null,null,"2nd AUDIT: PERCENTAGE"]
[null,null,null,null,3,2,1,0,null,null,null,null,null,null,3,2,1,0]
[null,"Section_ID","Sub-Section","No of Qs","Green","Amber","Red","No Response","No Compliance","Partial Compliance","Full Compliance","No Response","Validation",null,"Green","Amber","Red","No Response","No Compliance","Partial Compliance","Full Compliance","No Response","Validation"]
[null,1,"Governance and Leadership",{"$f":"COUNTIFS(Data!$A:$A,\"LA\",Data!$C:$C,Calc!$B6,Data!$D:$D,Calc!$C6)","v":9},{"$f":"COUNTIFS(Data!$A:$A,\"LA\",Data!$C:$C,Calc!$B6,Data!$D:$D,Calc!$C6,Data!$I:$I,Calc!E$4)","v":0},{"$f":"COUNTIFS(Data!$A:$A,\"LA\",Data!$C:$C,Calc!$B6,Data!$D:$D,Calc!$C6,Data!$I:$I,Calc!F$4)","v":0},{"$f":"COUNTIFS(Data!$A:$A,\"LA\",Data!$C:$C,Calc!$B6,Data!$D:$D,Calc!$C6,Data!$I:$I,Calc!G$4)","v":0},{"$f":"COUNTIFS(Data!$A:$A,\"LA\",Data!$C:$C,Calc!$B6,Data!$D:$D,Calc!$C6,Data!$I:$I,Calc!H$4)","v":9},{"$f":"G6/$D6","v":0},{"$f":"F6/$D6","v":0},{"$f":"E6/$D6","v":0},{"$f":"H6/$D6","v":1},{"$f":"SUM(I6:L6)","v":1},null,{"$f":"COUNTIFS(Data!$A:$A,\"LA\",Data!$C:$C,Calc!$B6,Data!$D:$D,Calc!$C6,Data!$J:$J,Calc!O$4)","v":0},{"$f":"COUNTIFS(Data!$A:$A,\"LA\",Data!$C:$C,Calc!$B6,Data!$D:$D,Calc!$C6,Data!$J:$J,Calc!P$4)","v":0},{"$f":"COUNTIFS(Data!$A:$A,\"LA\",Data!$C:$C,Calc!$B6,Data!$D:$D,Calc!$C6,Data!$J:$J,Calc!Q$4)","v":0},{"$f":"COUNTIFS(Data!$A:$A,\"LA\",Data!$C:$C,Calc!$B6,Data!$D:$D,Calc!$C6,Data!$J:$J,Calc!R$4)","v":9},{"$f":"Q6/$D6","v":0},{"$f":"P6/$D6","v":0},{"$f":"O6/$D6","v":0},{"$f":"R6/$D6","v":1},{"$f":"SUM(S6:V6)","v":1}]
[null,1,"Requests for high cost residential or specialist placements for children and young people with complex needs",{"$f":"COUNTIFS(Data!$A:$A,\"LA\",Data!$C:$C,Calc!$B7,Data!$D:$D,Calc!$C7)","v":3},{"$f":"COUNTIFS(Data!$A:$A,\"LA\",Data!$C:$C,Calc!$B7,Data!$D:$D,Calc!$C7,Data!$I:$I,Calc!E$4)","v":0},{"$f":"COUNTIFS(Data!$A:$A,\"LA\",Data!$C:$C,Calc!$B7,Data!$D:$D,Calc!$C7,Data!$I:$I,Calc!F$4)","v":0},{"$f":"COUNTIFS(Data!$A:$A,\"LA\",Data!$C:$C,Calc!$B7,Data!$D:$D,Calc!$C7,Data!$I:$I,Calc!G$4)","v":0},{"$f":"COUNTIFS(Data!$A:$A,\"LA\",Data!$C:$C,Calc!$B7,Data!$D:$D,Calc!$C7,Data!$I:$I,Calc!H$4)","v":3},{"$f":"G7/$D7","v":0},{"$f":"F7/$D7","v":0},{"$f":"E7/$D7","v":0},1,1,null,{"$f":"COUNTIFS(Data!$A:$A,\"LA\",Data!$C:$C,Calc!$B7,Data!$D:$D,Calc!$C7,Data!$J:$J,Calc!O$4)","v":0},{"$f":"COUNTIFS(Data!$A:$A,\"LA\",Data!$C:$C,Calc!$B7,Data!$D:$D,Calc!$C7,Data!$J:$J,Calc!P$4)","v":0},{"$f":"COUNTIFS(Data!$A:$A,\"LA\",Data!$C:$C,Calc!$B7,Data!$D:$D,Calc!$C7,Data!$J:$J,Calc!Q$4)","v":0},{"$f":"COUNTIFS(Data!$A:$A,\"LA\",Data!$C:$C,Calc!$B7,Data!$D:$D,Calc!$C7,Data!$J:$J,Calc!R$4)","v":3},{"$f":"Q7/$D7","v":0},{"$f":"P7/$D7","v":0},{"$f":"O7/$D7","v":0},1,1]
[null,1,"Monitoring and Agreeing Plans",{"$f":"COUNTIFS(Data!$A:$A,\"LA\",Data!$C:$C,Calc!$B8,Data!$D:$D,Calc!$C8)","v":2},{"$f":"COUNTIFS(Data!$A:$A,\"LA\",Data!$C:$C,Calc!$B8,Data!$D:$D,Calc!$C8,Data!$I:$I,Calc!E$4)","v":0},{"$f":"COUNTIFS(Data!$A:$A,\"LA\",Data!$C:$C,Calc!$B8,Data!$D:$D,Calc!$C8,Data!$I:$I,Calc!F$4)","v":0},{"$f":"COUNTIFS(Data!$A:$A,\"LA\",Data!$C:$C,Calc!$B8,Data!$D:$D,Calc!$C8,Data!$I:$I,Calc!G$4)","v":0},{"$f":"COUNTIFS(Data!$A:$A,\"LA\",Data!$C:$C,Calc!$B8,Data!$D:$D,Calc!$C8,Data!$I:$I,Calc!H$4)","v":2},0,0,0,1,1,null,{"$f":"COUNTIFS(Data!$A:$A,\"LA\",Data!$C:$C,Calc!$B8,Data!$D:$D,Calc!$C8,Data!$J:$J,Calc!O$4)","v":0},{"$f":"COUNTIFS(Data!$A:$A,\"LA\",Data!$C:$C,Calc!$B8,Data!$D:$D,Calc!$C8,Data!$J:$J,Calc!P$4)","v":0},{"$f":"COUNTIFS(Data!$A:$A,\"LA\",Data!$C:$C,Calc!$B8,Data!$D:$D,Calc!$C8,Data!$J:$J,Calc!Q$4)","v":0},{"$f":"COUNTIFS(Data!$A:$A,\"LA\",Data!$C:$C,Calc!$B8,Data!$D:$D,Calc!$C8,Data!$J:$J,Calc!R$4)","v":2},0,0,0,1,1]
[null,1,"Resourcing Joint Arrangements",{"$f":"COUNTIFS(Data!$A:$A,\"LA\",Data!$C:$C,Calc!$B9,Data!$D:$D,Calc!$C9)","v":4},{"$f":"COUNTIFS(Data!$A:$A,\"LA\",Data!$C:$C,Calc!$B9,Data!$D:$D,Calc!$C9,Data!$I:$I,Calc!E$4)","v":0},{"$f":"COUNTIFS(Data!$A:$A,\"LA\",Data!$C:$C,Calc!$B9,Data!$D:$D,Calc!$C9,Data!$I:$I,Calc!F$4)","v":0},{"$f":"COUNTIFS(Data!$A:$A,\"LA\",Data!$C:$C,Calc!$B9,Data!$D:$D,Calc!$C9,Data!$I:$I,Calc!G$4)","v":0},{"$f":"COUNTIFS(Data!$A:$A,\"LA\",Data!$C:$C,Calc!$B9,Data!$D:$D,Calc!$C9,Data!$I:$I,Calc!H$4)","v":4},0,0,0,1,1,null,{"$f":"COUNTIFS(Data!$A:$A,\"LA\",Data!$C:$C,Calc!$B9,Data!$D:$D,Calc!$C9,Data!$J:$J,Calc!O$4)","v":0},{"$f":"COUNTIFS(Data!$A:$A,\"LA\",Data!$C:$C,Calc!$B9,Data!$D:$D,Calc!$C9,Data!$J:$J,Calc!P$4)","v":0},{"$f":"COUNTIFS(Data!$A:$A,\"LA\",Data!$C:$C,Calc!$B9,Data!$D:$D,Calc!$C9,Data!$J:$J,Calc!Q$4)","v":0},{"$f":"COUNTIFS(Data!$A:$A,\"LA\",Data!$C:$C,Calc!$B9,Data!$D:$D,Calc!$C9,Data!$J:$J,Calc!R$4)","v":4},0,0,0,1,1]
[null,2,"Joint Arrangements",{"$f":"COUNTIFS(Data!$A:$A,\"LA\",Data!$C:$C,Calc!$B10,Data!$D:$D,Calc!$C10)","v":9},{"$f":"COUNTIFS(Data!$A:$A,\"LA\",Data!$C:$C,Calc!$B10,Data!$D:$D,Calc!$C10,Data!$I:$I,Calc!E$4)","v":0},{"$f":"COUNTIFS(Data!$A:$A,\"LA\",Data!$C:$C,Calc!$B10,Data!$D:$D,Calc!$C10,Data!$I:$I,Calc!F$4)","v":0},{"$f":"COUNTIFS(Data!$A:$A,\"LA\",Data!$C:$C,Calc!$B10,Data!$D:$D,Calc!$C10,Data!$I:$I,Calc!G$4)","v":0},{"$f":"COUNTIFS(Data!$A:$A,\"LA\",Data!$C:$C,Calc!$B10,Data!$D:$D,Calc!$C10,Data!$I:$I,Calc!H$4)","v":9},0,0,0,1,1,null,{"$f":"COUNTIFS(Data!$A:$A,\"LA\",Data!$C:$C,Calc!$B10,Data!$D:$D,Calc!$C10,Data!$J:$J,Calc!O$4)","v":0},{"$f":"COUNTIFS(Data!$A:$A,\"LA\",Data!$C:$C,Calc!$B10,Data!$D:$D,Calc!$C10,Data!$J:$J,Calc!P$4)","v":0},{"$f":"COUNTIFS(Data!$A:$A,\"LA\",Data!$C:$C,Calc!$B10,Data!$D:$D,Calc!$C10,Data!$J:$J,Calc!Q$4)","v":0},{"$f":"COUNTIFS(Data!$A:$A,\"LA\",Data!$C:$C,Calc!$B10,Data!$D:$D,Calc!$C10,Data!$J:$J,Calc!R$4)","v":9},0,0,0,1,1]
[null,2,"Health and Wellbeing Boards",{"$f":"COUNTIFS(Data!$A:$A,\"LA\",Data!$C:$C,Calc!$B11,Data!$D:$D,Calc!$C11)","v":4},{"$f":"COUNTIFS(Data!$A:$A,\"LA\",Data!$C:$C,Calc!$B11,Data!$D:$D,Calc!$C11,Data!$I:$I,Calc!E$4)","v":0},{"$f":"COUNTIFS(Data!$A:$A,\"LA\",Data!$C:$C,Calc!$B11,Data!$D:$D,Calc!$C11,Data!$I:$I,Calc!F$4)","v":0},{"$f":"COUNTIFS(Data!$A:$A,\"LA\",Data!$C:$C,Calc!$B11,Data!$D:$D,Calc!$C11,Data!$I:$I,Calc!G$4)","v":0},{"$f":"COUNTIFS(Data!$A:$A,\"LA\",Data!$C:$C,Calc!$B11,Data!$D:$D,Calc!$C11,Data!$I:$I,Calc!H$4)","v":4},0,0,0,1,1,null,{"$f":"COUNTIFS(Data!$A:$A,\"LA\",Data!$C:$C,Calc!$B11,Data!$D:$D,Calc!$C11,Data!$J:$J,Calc!O$4)","v":0},{"$f":"COUNTIFS(Data!$A:$A,\"LA\",Data!$C:$C,Calc!$B11,Data!$D:$D,Calc!$C11,Data!$J:$J,Calc!P$4)","v":0},{"$f":"COUNTIFS(Data!$A:$A,\"LA\",Data!$C:$C,Calc!$B11,Data!$D:$D,Calc!$C11,Data!$J:$J,Calc!Q$4)","v":0},{"$f":"COUNTIFS(Data!$A:$A,\"LA\",Data!$C:$C,Calc!$B11,Data!$D:$D,Calc!$C11,Data!$J:$J,Calc!R$4)","v":4},0,0,0,1,1]
[null,2,"Dispute Resolution",{"$f":"COUNTIFS(Data!$A:$A,\"LA\",Data!$C:$C,Calc!$B12,Data!$D:$D,Calc!$C12)","v":3},{"$f":"COUNTIFS(Data!$A:$A,\"LA\",Data!$C:$C,Calc!$B12,Data!$D:$D,Calc!$C12,Data!$I:$I,Calc!E$4)","v":0},{"$f":"COUNTIFS(Data!$A:$A,\"LA\",Data!$C:$C,Calc!$B12,Data!$D:$D,Calc!$C12,Data!$I:$I,Calc!F$4)","v":0},{"$f":"COUNTIFS(Data!$A:$A,\"LA\",Data!$C:$C,Calc!$B12,Data!$D:$D,Calc!$C12,Data!$I:$I,Calc!G$4)","v":0},{"$f":"COUNTIFS(Data!$A:$A,\"LA\",Data!$C:$C,Calc!$B12,Data!$D:$D,Calc!$C12,Data!$I:$I,Calc!H$4)","v":3},0,0,0,1,1,null,{"$f":"COUNTIFS(Data!$A:$A,\"LA\",Data!$C:$C,Calc!$B12,Data!$D:$D,Calc!$C12,Data!$J:$J,Calc!O$4)","v":0},{"$f":"COUNTIFS(Data!$A:$A,\"LA\",Data!$C:$C,Calc!$B12,Data!$D:$D,Calc!$C12,Data!$J:$J,Calc!P$4)","v":0},{"$f":"COUNTIFS(Data!$A:$A,\"LA\",Data!$C:$C,Calc!$B12,Data!$D:$D,Calc!$C12,Data!$J:$J,Calc!Q$4)","v":0},{"$f":"COUNTIFS(Data!$A:$A,\"LA\",Data!$C:$C,Calc!$B12,Data!$D:$D,Calc!$C12,Data!$J:$J,Calc!R$4)","v":3},0,0,0,1,1]
[null,2,"Local Offer",{"$f":"COUNTIFS(Data!$A:$A,\"LA\",Data!$C:$C,Calc!$B13,Data!$D:$D,Calc!$C13)","v":14},{"$f":"COUNTIFS(Data!$A:$A,\"LA\",Data!$C:$C,Calc!$B13,Data!$D:$D,Calc!$C13,Data!$I:$I,Calc!E$4)","v":0},{"$f":"COUNTIFS(Data!$A:$A,\"LA\",Data!$C:$C,Calc!$B13,Data!$D:$D,Calc!$C13,Data!$I:$I,Calc!F$4)","v":0},{"$f":"COUNTIFS(Data!$A:$A,\"LA\",Data!$C:$C,Calc!$B13,Data!$D:$D,Calc!$C13,Data!$I:$I,Calc!G$4)","v":0},{"$f":"COUNTIFS(Data!$A:$A,\"LA\",Data!$C:$C,Calc!$B13,Data!$D:$D,Calc!$C13,Data!$I:$I,Calc!H$4)","v":14},0,0,0,1,1,null,{"$f":"COUNTIFS(Data!$A:$A,\"LA\",Data!$C:$C,Calc!$B13,Data!$D:$D,Calc!$C13,Data!$J:$J,Calc!O$4)","v":0},{"$f":"COUNTIFS(Data!$A:$A,\"LA\",Data!$C:$C,Calc!$B13,Data!$D:$D,Calc!$C13,Data!$J:$J,Calc!P$4)","v":0},{"$f":"COUNTIFS(Data!$A:$A,\"LA\",Data!$C:$C,Calc!$B13,Data!$D:$D,Calc!$C13,Data!$J:$J,Calc!Q$4)","v":0},{"$f":"COUNTIFS(Data!$A:$A,\"LA\",Data!$C:$C,Calc!$B13,Data!$D:$D,Calc!$C13,Data!$J:$J,Calc!R$4)","v":14},0,0,0,1,1]
[null,3,"Assessing Local Need",{"$f":"COUNTIFS(Data!$A:$A,\"LA\",Data!$C:$C,Calc!$B14,Data!$D:$D,Calc!$C14)","v":6},{"$f":"COUNTIFS(Data!$A:$A,\"LA\",Data!$C:$C,Calc!$B14,Data!$D:$D,Calc!$C14,Data!$I:$I,Calc!E$4)","v":0},{"$f":"COUNTIFS(Data!$A:$A,\"LA\",Data!$C:$C,Calc!$B14,Data!$D:$D,Calc!$C14,Data!$I:$I,Calc!F$4)","v":0},{"$f":"COUNTIFS(Data!$A:$A,\"LA\",Data!$C:$C,Calc!$B14,Data!$D:$D,Calc!$C14,Data!$I:$I,Calc!G$4)","v":0},{"$f":"COUNTIFS(Data!$A:$A,\"LA\",Data!$C:$C,Calc!$B14,Data!$D:$D,Calc!$C14,Data!$I:$I,Calc!H$4)","v":6},0,0,0,1,1,null,{"$f":"COUNTIFS(Data!$A:$A,\"LA\",Data!$C:$C,Calc!$B14,Data!$D:$D,Calc!$C14,Data!$J:$J,Calc!O$4)","v":0},{"$f":"COUNTIFS(Data!$A:$A,\"LA\",Data!$C:$C,Calc!$B14,Data!$D:$D,Calc!$C14,Data!$J:$J,Calc!P$4)","v":0},{"$f":"COUNTIFS(Data!$A:$A,\"LA\",Data!$C:$C,Calc!$B14,Data!$D:$D,Calc!$C14,Data!$J:$J,Calc!Q$4)","v":0},{"$f":"COUNTIFS(Data!$A:$A,\"LA\",Data!$C:$C,Calc!$B14,Data!$D:$D,Calc!$C14,Data!$J:$J,Calc!R$4)","v":6},0,0,0,1,1]
[null,3,"Affordability and Demand",{"$f":"COUNTIFS(Data!$A:$A,\"LA\",Data!$C:$C,Calc!$B15,Data!$D:$D,Calc!$C15)","v":6},{"$f":"COUNTIFS(Data!$A:$A,\"LA\",Data!$C:$C,Calc!$B15,Data!$D:$D,Calc!$C15,Data!$I:$I,Calc!E$4)","v":0},{"$f":"COUNTIFS(Data!$A:$A,\"LA\",Data!$C:$C,Calc!$B15,Data!$D:$D,Calc!$C15,Data!$I:$I,Calc!F$4)","v":0},{"$f":"COUNTIFS(Data!$A:$A,\"LA\",Data!$C:$C,Calc!$B15,Data!$D:$D,Calc!$C15,Data!$I:$I,Calc!G$4)","v":0},{"$f":"COUNTIFS(Data!$A:$A,\"LA\",Data!$C:$C,Calc!$B15,Data!$D:$D,Calc!$C15,Data!$I:$I,Calc!H$4)","v":6},0,0,0,1,1,null,{"$f":"COUNTIFS(Data!$A:$A,\"LA\",Data!$C:$C,Calc!$B15,Data!$D:$D,Calc!$C15,Data!$J:$J,Calc!O$4)","v":0},{"$f":"COUNTIFS(Data!$A:$A,\"LA\",Data!$C:$C,Calc!$B15,Data!$D:$D,Calc!$C15,Data!$J:$J,Calc!P$4)","v":0},{"$f":"COUNTIFS(Data!$A:$A,\"LA\",Data!$C:$C,Calc!$B15,Data!$D:$D,Calc!$C15,Data!$J:$J,Calc!Q$4)","v":0},{"$f":"COUNTIFS(Data!$A:$A,\"LA\",Data!$C:$C,Calc!$B15,Data!$D:$D,Calc!$C15,Data!$J:$J,Calc!R$4)","v":6},0,0,0,1,1]
[null,3,"Contracts",{"$f":"COUNTIFS(Data!$A:$A,\"LA\",Data!$C:$C,Calc!$B16,Data!$D:$D,Calc!$C16)","v":3},{"$f":"COUNTIFS(Data!$A:$A,\"LA\",Data!$C:$C,Calc!$B16,Data!$D:$D,Calc!$C16,Data!$I:$I,Calc!E$4)","v":0},{"$f":"COUNTIFS(Data!$A:$A,\"LA\",Data!$C:$C,Calc!$B16,Data!$D:$D,Calc!$C16,Data!$I:$I,Calc!F$4)","v":0},{"$f":"COUNTIFS(Data!$A:$A,\"LA\",Data!$C:$C,Calc!$B16,Data!$D:$D,Calc!$C16,Data!$I:$I,Calc!G$4)","v":0},{"$f":"COUNTIFS(Data!$A:$A,\"LA\",Data!$C:$C,Calc!$B16,Data!$D:$D,Calc!$C16,Data!$I:$I,Calc!H$4)","v":3},0,0,0,1,1,null,{"$f":"COUNTIFS(Data!$A:$A,\"LA\",Data!$C:$C,Calc!$B16,Data!$D:$D,Calc!$C16,Data!$J:$J,Calc!O$4)","v":0},{"$f":"COUNTIFS(Data!$A:$A,\"LA\",Data!$C:$C,Calc!$B16,Data!$D:$D,Calc!$C16,Data!$J:$J,Calc!P$4)","v":0},{"$f":"COUNTIFS(Data!$A:$A,\"LA\",Data!$C:$C,Calc!$B16,Data!$D:$D,Calc!$C16,Data!$J:$J,Calc!Q$4)","v":0},{"$f":"COUNTIFS(Data!$A:$A,\"LA\",Data!$C:$C,Calc!$B16,Data!$D:$D,Calc!$C16,Data!$J:$J,Calc!R$4)","v":3},0,0,0,1,1]
[null,3,"Personal Budgets",{"$f":"COUNTIFS(Data!$A:$A,\"LA\",Data!$C:$C,Calc!$B17,Data!$D:$D,Calc!$C17)","v":3},{"$f":"COUNTIFS(Data!$A:$A,\"LA\",Data!$C:$C,Calc!$B17,Data!$D:$D,Calc!$C17,Data!$I:$I,Calc!E$4)","v":0},{"$f":"COUNTIFS(Data!$A:$A,\"LA\",Data!$C:$C,Calc!$B17,Data!$D:$D,Calc!$C17,Data!$I:$I,Calc!F$4)","v":0},{"$f":"COUNTIFS(Data!$A:$A,\"LA\",Data!$C:$C,Calc!$B17,Data!$D:$D,Calc!$C17,Data!$I:$I,Calc!G$4)","v":0},{"$f":"COUNTIFS(Data!$A:$A,\"LA\",Data!$C:$C,Calc!$B17,Data!$D:$D,Calc!$C17,Data!$I:$I,Calc!H$4)","v":3},0,0,0,1,1,null,{"$f":"COUNTIFS(Data!$A:$A,\"LA\",Data!$C:$C,Calc!$B17,Data!$D:$D,Calc!$C17,Data!$J:$J,Calc!O$4)","v":0},{"$f":"COUNTIFS(Data!$A:$A,\"LA\",Data!$C:$C,Calc!$B17,Data!$D:$D,Calc!$C17,Data!$J:$J,Calc!P$4)","v":0},{"$f":"COUNTIFS(Data!$A:$A,\"LA\",Data!$C:$C,Calc!$B17,Data!$D:$D,Calc!$C17,Data!$J:$J,Calc!Q$4)","v":0},{"$f":"COUNTIFS(Data!$A:$A,\"LA\",Data!$C:$C,Calc!$B17,Data!$D:$D,Calc!$C17,Data!$J:$J,Calc!R$4)","v":3},0,0,0,1,1]
[null,3,"Designated Medical Officer / Designated Clinical Officer",{"$f":"COUNTIFS(Data!$A:$A,\"LA\",Data!$C:$C,Calc!$B18,Data!$D:$D,Calc!$C18)","v":1},{"$f":"COUNTIFS(Data!$A:$A,\"LA\",Data!$C:$C,Calc!$B18,Data!$D:$D,Calc!$C18,Data!$I:$I,Calc!E$4)","v":0},{"$f":"COUNTIFS(Data!$A:$A,\"LA\",Data!$C:$C,Calc!$B18,Data!$D:$D,Calc!$C18,Data!$I:$I,Calc!F$4)","v":0},{"$f":"COUNTIFS(Data!$A:$A,\"LA\",Data!$C:$C,Calc!$B18,Data!$D:$D,Calc!$C18,Data!$I:$I,Calc!G$4)","v":0},{"$f":"COUNTIFS(Data!$A:$A,\"LA\",Data!$C:$C,Calc!$B18,Data!$D:$D,Calc!$C18,Data!$I:$I,Calc!H$4)","v":1},0,0,0,1,1,null,{"$f":"COUNTIFS(Data!$A:$A,\"LA\",Data!$C:$C,Calc!$B18,Data!$D:$D,Calc!$C18,Data!$J:$J,Calc!O$4)","v":0},{"$f":"COUNTIFS(Data!$A:$A,\"LA\",Data!$C:$C,Calc!$B18,Data!$D:$D,Calc!$C18,Data!$J:$J,Calc!P$4)","v":0},{"$f":"COUNTIFS(Data!$A:$A,\"LA\",Data!$C:$C,Calc!$B18,Data!$D:$D,Calc!$C18,Data!$J:$J,Calc!Q$4)","v":0},{"$f":"COUNTIFS(Data!$A:$A,\"LA\",Data!$C:$C,Calc!$B18,Data!$D:$D,Calc!$C18,Data!$J:$J,Calc!R$4)","v":1},0,0,0,1,1]
[null,4,"SEN Support and Early Help (Coordinated assessment) ",{"$f":"COUNTIFS(Data!$A:$A,\"LA\",Data!$C:$C,Calc!$B19,Data!$D:$D,Calc!$C19)","v":6},{"$f":"COUNTIFS(Data!$A:$A,\"LA\",Data!$C:$C,Calc!$B19,Data!$D:$D,Calc!$C19,Data!$I:$I,Calc!E$4)","v":0},{"$f":"COUNTIFS(Data!$A:$A,\"LA\",Data!$C:$C,Calc!$B19,Data!$D:$D,Calc!$C19,Data!$I:$I,Calc!F$4)","v":0},{"$f":"COUNTIFS(Data!$A:$A,\"LA\",Data!$C:$C,Calc!$B19,Data!$D:$D,Calc!$C19,Data!$I:$I,Calc!G$4)","v":0},{"$f":"COUNTIFS(Data!$A:$A,\"LA\",Data!$C:$C,Calc!$B19,Data!$D:$D,Calc!$C19,Data!$I:$I,Calc!H$4)","v":6},0,0,0,1,1,null,{"$f":"COUNTIFS(Data!$A:$A,\"LA\",Data!$C:$C,Calc!$B19,Data!$D:$D,Calc!$C19,Data!$J:$J,Calc!O$4)","v":0},{"$f":"COUNTIFS(Data!$A:$A,\"LA\",Data!$C:$C,Calc!$B19,Data!$D:$D,Calc!$C19,Data!$J:$J,Calc!P$4)","v":0},{"$f":"COUNTIFS(Data!$A:$A,\"LA\",Data!$C:$C,Calc!$B19,Data!$D:$D,Calc!$C19,Data!$J:$J,Calc!Q$4)","v":0},{"$f":"COUNTIFS(Data!$A:$A,\"LA\",Data!$C:$C,Calc!$B19,Data!$D:$D,Calc!$C19,Data!$J:$J,Calc!R$4)","v":6},0,0,0,1,1]
[null,4,"EHC Needs Assessment (Coordinated Specialist Assessment)",{"$f":"COUNTIFS(Data!$A:$A,\"LA\",Data!$C:$C,Calc!$B20,Data!$D:$D,Calc!$C20)","v":7},{"$f":"COUNTIFS(Data!$A:$A,\"LA\",Data!$C:$C,Calc!$B20,Data!$D:$D,Calc!$C20,Data!$I:$I,Calc!E$4)","v":0},{"$f":"COUNTIFS(Data!$A:$A,\"LA\",Data!$C:$C,Calc!$B20,Data!$D:$D,Calc!$C20,Data!$I:$I,Calc!F$4)","v":0},{"$f":"COUNTIFS(Data!$A:$A,\"LA\",Data!$C:$C,Calc!$B20,Data!$D:$D,Calc!$C20,Data!$I:$I,Calc!G$4)","v":0},{"$f":"COUNTIFS(Data!$A:$A,\"LA\",Data!$C:$C,Calc!$B20,Data!$D:$D,Calc!$C20,Data!$I:$I,Calc!H$4)","v":7},0,0,0,{"$f":"H20/$D20","v":1},1,null,{"$f":"COUNTIFS(Data!$A:$A,\"LA\",Data!$C:$C,Calc!$B20,Data!$D:$D,Calc!$C20,Data!$J:$J,Calc!O$4)","v":0},{"$f":"COUNTIFS(Data!$A:$A,\"LA\",Data!$C:$C,Calc!$B20,Data!$D:$D,Calc!$C20,Data!$J:$J,Calc!P$4)","v":0},{"$f":"COUNTIFS(Data!$A:$A,\"LA\",Data!$C:$C,Calc!$B20,Data!$D:$D,Calc!$C20,Data!$J:$J,Calc!Q$4)","v":0},{"$f":"COUNTIFS(Data!$A:$A,\"LA\",Data!$C:$C,Calc!$B20,Data!$D:$D,Calc!$C20,Data!$J:$J,Calc!R$4)","v":7},0,0,0,{"$f":"R20/$D20","v":1},1]
[null,4,"Sign Off",{"$f":"COUNTIFS(Data!$A:$A,\"LA\",Data!$C:$C,Calc!$B21,Data!$D:$D,Calc!$C21)","v":8},{"$f":"COUNTIFS(Data!$A:$A,\"LA\",Data!$C:$C,Calc!$B21,Data!$D:$D,Calc!$C21,Data!$I:$I,Calc!E$4)","v":0},{"$f":"COUNTIFS(Data!$A:$A,\"LA\",Data!$C:$C,Calc!$B21,Data!$D:$D,Calc!$C21,Data!$I:$I,Calc!F$4)","v":0},{"$f":"COUNTIFS(Data!$A:$A,\"LA\",Data!$C:$C,Calc!$B21,Data!$D:$D,Calc!$C21,Data!$I:$I,Calc!G$4)","v":0},{"$f":"COUNTIFS(Data!$A:$A,\"LA\",Data!$C:$C,Calc!$B21,Data!$D:$D,Calc!$C21,Data!$I:$I,Calc!H$4)","v":8},0,0,0,1,1,null,{"$f":"COUNTIFS(Data!$A:$A,\"LA\",Data!$C:$C,Calc!$B21,Data!$D:$D,Calc!$C21,Data!$J:$J,Calc!O$4)","v":0},{"$f":"COUNTIFS(Data!$A:$A,\"LA\",Data!$C:$C,Calc!$B21,Data!$D:$D,Calc!$C21,Data!$J:$J,Calc!P$4)","v":0},{"$f":"COUNTIFS(Data!$A:$A,\"LA\",Data!$C:$C,Calc!$B21,Data!$D:$D,Calc!$C21,Data!$J:$J,Calc!Q$4)","v":0},{"$f":"COUNTIFS(Data!$A:$A,\"LA\",Data!$C:$C,Calc!$B21,Data!$D:$D,Calc!$C21,Data!$J:$J,Calc!R$4)","v":8},0,0,0,1,1]
[null,5,"Children, Young People and Parents",{"$f":"COUNTIFS(Data!$A:$A,\"LA\",Data!$C:$C,Calc!$B22,Data!$D:$D,Calc!$C22)","v":8},{"$f":"COUNTIFS(Data!$A:$A,\"LA\",Data!$C:$C,Calc!$B22,Data!$D:$D,Calc!$C22,Data!$I:$I,Calc!E$4)","v":0},{"$f":"COUNTIFS(Data!$A:$A,\"LA\",Data!$C:$C,Calc!$B22,Data!$D:$D,Calc!$C22,Data!$I:$I,Calc!F$4)","v":0},{"$f":"COUNTIFS(Data!$A:$A,\"LA\",Data!$C:$C,Calc!$B22,Data!$D:$D,Calc!$C22,Data!$I:$I,Calc!G$4)","v":0},{"$f":"COUNTIFS(Data!$A:$A,\"LA\",Data!$C:$C,Calc!$B22,Data!$D:$D,Calc!$C22,Data!$I:$I,Calc!H$4)","v":8},0,0,0,1,1,null,{"$f":"COUNTIFS(Data!$A:$A,\"LA\",Data!$C:$C,Calc!$B22,Data!$D:$D,Calc!$C22,Data!$J:$J,Calc!O$4)","v":0},{"$f":"COUNTIFS(Data!$A:$A,\"LA\",Data!$C:$C,Calc!$B22,Data!$D:$D,Calc!$C22,Data!$J:$J,Calc!P$4)","v":0},{"$f":"COUNTIFS(Data!$A:$A,\"LA\",Data!$C:$C,Calc!$B22,Data!$D:$D,Calc!$C22,Data!$J:$J,Calc!Q$4)","v":0},{"$f":"COUNTIFS(Data!$A:$A,\"LA\",Data!$C:$C,Calc!$B22,Data!$D:$D,Calc!$C22,Data!$J:$J,Calc!R$4)","v":8},0,0,0,1,1]
[null,6,"Data to Monitor Progress",{"$f":"COUNTIFS(Data!$A:$A,\"LA\",Data!$C:$C,Calc!$B23,Data!$D:$D,Calc!$C23)","v":3},{"$f":"COUNTIFS(Data!$A:$A,\"LA\",Data!$C:$C,Calc!$B23,Data!$D:$D,Calc!$C23,Data!$I:$I,Calc!E$4)","v":0},{"$f":"COUNTIFS(Data!$A:$A,\"LA\",Data!$C:$C,Calc!$B23,Data!$D:$D,Calc!$C23,Data!$I:$I,Calc!F$4)","v":0},{"$f":"COUNTIFS(Data!$A:$A,\"LA\",Data!$C:$C,Calc!$B23,Data!$D:$D,Calc!$C23,Data!$I:$I,Calc!G$4)","v":0},{"$f":"COUNTIFS(Data!$A:$A,\"LA\",Data!$C:$C,Calc!$B23,Data!$D:$D,Calc!$C23,Data!$I:$I,Calc!H$4)","v":3},0,0,0,1,1,null,{"$f":"COUNTIFS(Data!$A:$A,\"LA\",Data!$C:$C,Calc!$B23,Data!$D:$D,Calc!$C23,Data!$J:$J,Calc!O$4)","v":0},{"$f":"COUNTIFS(Data!$A:$A,\"LA\",Data!$C:$C,Calc!$B23,Data!$D:$D,Calc!$C23,Data!$J:$J,Calc!P$4)","v":0},{"$f":"COUNTIFS(Data!$A:$A,\"LA\",Data!$C:$C,Calc!$B23,Data!$D:$D,Calc!$C23,Data!$J:$J,Calc!Q$4)","v":0},{"$f":"COUNTIFS(Data!$A:$A,\"LA\",Data!$C:$C,Calc!$B23,Data!$D:$D,Calc!$C23,Data!$J:$J,Calc!R$4)","v":3},0,0,0,1,1]
[null,6,"Data Sharing",{"$f":"COUNTIFS(Data!$A:$A,\"LA\",Data!$C:$C,Calc!$B24,Data!$D:$D,Calc!$C24)","v":4},{"$f":"COUNTIFS(Data!$A:$A,\"LA\",Data!$C:$C,Calc!$B24,Data!$D:$D,Calc!$C24,Data!$I:$I,Calc!E$4)","v":0},{"$f":"COUNTIFS(Data!$A:$A,\"LA\",Data!$C:$C,Calc!$B24,Data!$D:$D,Calc!$C24,Data!$I:$I,Calc!F$4)","v":0},{"$f":"COUNTIFS(Data!$A:$A,\"LA\",Data!$C:$C,Calc!$B24,Data!$D:$D,Calc!$C24,Data!$I:$I,Calc!G$4)","v":0},{"$f":"COUNTIFS(Data!$A:$A,\"LA\",Data!$C:$C,Calc!$B24,Data!$D:$D,Calc!$C24,Data!$I:$I,Calc!H$4)","v":4},0,0,0,1,1,null,{"$f":"COUNTIFS(Data!$A:$A,\"LA\",Data!$C:$C,Calc!$B24,Data!$D:$D,Calc!$C24,Data!$J:$J,Calc!O$4)","v":0},{"$f":"COUNTIFS(Data!$A:$A,\"LA\",Data!$C:$C,Calc!$B24,Data!$D:$D,Calc!$C24,Data!$J:$J,Calc!P$4)","v":0},{"$f":"COUNTIFS(Data!$A:$A,\"LA\",Data!$C:$C,Calc!$B24,Data!$D:$D,Calc!$C24,Data!$J:$J,Calc!Q$4)","v":0},{"$f":"COUNTIFS(Data!$A:$A,\"LA\",Data!$C:$C,Calc!$B24,Data!$D:$D,Calc!$C24,Data!$J:$J,Calc!R$4)","v":4},0,0,0,1,1]
[null,6,"Disagreement Resolution and Complaints",{"$f":"COUNTIFS(Data!$A:$A,\"LA\",Data!$C:$C,Calc!$B25,Data!$D:$D,Calc!$C25)","v":4},{"$f":"COUNTIFS(Data!$A:$A,\"LA\",Data!$C:$C,Calc!$B25,Data!$D:$D,Calc!$C25,Data!$I:$I,Calc!E$4)","v":0},{"$f":"COUNTIFS(Data!$A:$A,\"LA\",Data!$C:$C,Calc!$B25,Data!$D:$D,Calc!$C25,Data!$I:$I,Calc!F$4)","v":0},{"$f":"COUNTIFS(Data!$A:$A,\"LA\",Data!$C:$C,Calc!$B25,Data!$D:$D,Calc!$C25,Data!$I:$I,Calc!G$4)","v":0},{"$f":"COUNTIFS(Data!$A:$A,\"LA\",Data!$C:$C,Calc!$B25,Data!$D:$D,Calc!$C25,Data!$I:$I,Calc!H$4)","v":4},0,0,0,1,1,null,{"$f":"COUNTIFS(Data!$A:$A,\"LA\",Data!$C:$C,Calc!$B25,Data!$D:$D,Calc!$C25,Data!$J:$J,Calc!O$4)","v":0},{"$f":"COUNTIFS(Data!$A:$A,\"LA\",Data!$C:$C,Calc!$B25,Data!$D:$D,Calc!$C25,Data!$J:$J,Calc!P$4)","v":0},{"$f":"COUNTIFS(Data!$A:$A,\"LA\",Data!$C:$C,Calc!$B25,Data!$D:$D,Calc!$C25,Data!$J:$J,Calc!Q$4)","v":0},{"$f":"COUNTIFS(Data!$A:$A,\"LA\",Data!$C:$C,Calc!$B25,Data!$D:$D,Calc!$C25,Data!$J:$J,Calc!R$4)","v":4},0,0,0,1,1]
[null,6,"Mediation",{"$f":"COUNTIFS(Data!$A:$A,\"LA\",Data!$C:$C,Calc!$B26,Data!$D:$D,Calc!$C26)","v":6},{"$f":"COUNTIFS(Data!$A:$A,\"LA\",Data!$C:$C,Calc!$B26,Data!$D:$D,Calc!$C26,Data!$I:$I,Calc!E$4)","v":0},{"$f":"COUNTIFS(Data!$A:$A,\"LA\",Data!$C:$C,Calc!$B26,Data!$D:$D,Calc!$C26,Data!$I:$I,Calc!F$4)","v":0},{"$f":"COUNTIFS(Data!$A:$A,\"LA\",Data!$C:$C,Calc!$B26,Data!$D:$D,Calc!$C26,Data!$I:$I,Calc!G$4)","v":0},{"$f":"COUNTIFS(Data!$A:$A,\"LA\",Data!$C:$C,Calc!$B26,Data!$D:$D,Calc!$C26,Data!$I:$I,Calc!H$4)","v":6},0,0,0,1,1,null,{"$f":"COUNTIFS(Data!$A:$A,\"LA\",Data!$C:$C,Calc!$B26,Data!$D:$D,Calc!$C26,Data!$J:$J,Calc!O$4)","v":0},{"$f":"COUNTIFS(Data!$A:$A,\"LA\",Data!$C:$C,Calc!$B26,Data!$D:$D,Calc!$C26,Data!$J:$J,Calc!P$4)","v":0},{"$f":"COUNTIFS(Data!$A:$A,\"LA\",Data!$C:$C,Calc!$B26,Data!$D:$D,Calc!$C26,Data!$J:$J,Calc!Q$4)","v":0},{"$f":"COUNTIFS(Data!$A:$A,\"LA\",Data!$C:$C,Calc!$B26,Data!$D:$D,Calc!$C26,Data!$J:$J,Calc!R$4)","v":6},0,0,0,1,1]
[]
[null,1,"1. Leadership",{"$f":"SUMIF($B$6:$B$26,$B28,D$6:D$26)","v":18},{"$f":"SUMIF($B$6:$B$26,$B28,E$6:E$26)","v":0},0,0,18,{"$f":"G28/$D28","v":0},{"$f":"F28/$D28","v":0},{"$f":"E28/$D28","v":0},{"$f":"H28/$D28","v":1},{"$f":"SUM(I28:L28)","v":1},null,{"$f":"SUMIF($B$6:$B$26,$B28,O$6:O$26)","v":0},0,0,18,{"$f":"Q28/$D28","v":0},{"$f":"P28/$D28","v":0},{"$f":"O28/$D28","v":0},{"$f":"R28/$D28","v":1},{"$f":"SUM(S28:V28)","v":1}]
[null,2,"2. Joint Arrangements",{"$f":"SUMIF($B$6:$B$26,$B29,D$6:D$26)","v":30},0,0,0,30,0,0,0,1,1,null,0,0,0,30,0,0,0,1,1]
[null,3,"3. Commissioning",19,0,0,0,19,0,0,0,1,1,null,0,0,0,19,0,0,0,1,1]
[null,4,"4. Education, Health & Care Plan",21,0,0,0,21,0,0,0,1,1,null,0,0,0,21,0,0,0,1,1]
[null,5,"5. Co-Production (Engagement)",8,0,0,0,8,0,0,0,1,1,null,0,0,0,8,0,0,0,1,1]
[null,6,"6. Monitoring & Redress",17,0,0,0,17,0,0,0,1,1,null,0,0,0,17,0,0,0,1,1]
[]
[null,null,"TOTAL LA",{"$f":"SUM(D6:D26)","v":113},{"$f":"SUM(E6:E26)","v":0},{"$f":"SUM(F6:F26)","v":0},{"$f":"SUM(G6:G26)","v":0},{"$f":"SUM(H6:H26)","v":113},{"$f":"G35/$D35","v":0},{"$f":"F35/$D35","v":0},{"$f":"E35/$D35","v":0},{"$f":"H35/$D35","v":1},{"$f":"SUM(I35:L35)","v":1},null,{"$f":"SUM(O6:O26)","v":0},{"$f":"SUM(P6:P26)","v":0},{"$f":"SUM(Q6:Q26)","v":0},{"$f":"SUM(R6:R26)","v":113},{"$f":"Q35/$D35","v":0},{"$f":"P35/$D35","v":0},{"$f":"O35/$D35","v":0},{"$f":"R35/$D35","v":1},{"$f":"SUM(S35:V35)","v":1}]

{"sheet":"LA - mapping","index":3,"n_rows":155,"n_cols":9,"rows_kept":155,"cut":false,"hidden":true,"merged":[]}
[]
[]
[]
[]
[null,"Audit 1 and 2 response","Mark",null,"Trend",null,"Combined","Region","Council"]
[null,"Please Select",0,null,"Please Select",null,"East - Bedford","East","Bedford"]
[null,"No Compliance: Not started. ",1,null,"Complete at 2nd Audit",null,"East - Cambridgeshire","East","Cambridgeshire"]
[null,"Partially Achieved: Some Progress/Implemented in some areas",2,null,"Improvement",null,"East - Central Bedfordshire","East","Central Bedfordshire"]
[null,"Full Compliance: Fully Achieved/Implemented",3,null,"No Change",null,"East - Essex","East","Essex"]
[null,null,null,null,"Decrease",null,"East - Hertfordshire","East","Hertfordshire"]
[null,null,null,null,null,null,"East - Luton","East","Luton"]
[null,null,null,null,null,null,"East - Norfolk","East","Norfolk"]
[null,null,null,null,null,null,"East - Peterborough","East","Peterborough"]
[null,null,null,null,null,null,"East - Southend-on-Sea","East","Southend-on-Sea"]
[null,null,null,null,null,null,"East - Suffolk","East","Suffolk"]
[null,null,null,null,null,null,"East - Thurrock","East","Thurrock"]
[null,null,null,null,null,null,"East Mids - Derby","East Mids","Derby"]
[null,null,null,null,null,null,"East Mids - Derbyshire","East Mids","Derbyshire"]
[null,null,null,null,null,null,"East Mids - Leicester","East Mids","Leicester"]
[null,null,null,null,null,null,"East Mids - Leicestershire","East Mids","Leicestershire"]
[null,null,null,null,null,null,"East Mids - Lincolnshire","East Mids","Lincolnshire"]
[null,null,null,null,null,null,"East Mids - Northamptonshire","East Mids","Northamptonshire"]
[null,null,null,null,null,null,"East Mids - Nottingham","East Mids","Nottingham"]
[null,null,null,null,null,null,"East Mids - Nottinghamshire","East Mids","Nottinghamshire"]
[null,null,null,null,null,null,"East Mids - Rutland","East Mids","Rutland"]
[null,null,null,null,null,null,"London - Barking & Dagenham","London","Barking & Dagenham"]
[null,null,null,null,null,null,"London - Barnet","London","Barnet"]
[null,null,null,null,null,null,"London - Bexley","London","Bexley"]
[null,null,null,null,null,null,"London - Brent","London","Brent"]
[null,null,null,null,null,null,"London - Bromley","London","Bromley"]
[null,null,null,null,null,null,"London - Camden","London","Camden"]
[null,null,null,null,null,null,"London - Croydon","London","Croydon"]
[null,null,null,null,null,null,"London - Ealing","London","Ealing"]
[null,null,null,null,null,null,"London - Enfield","London","Enfield"]
[null,null,null,null,null,null,"London - Greenwich","London","Greenwich"]
[null,null,null,null,null,null,"London - Hackney","London","Hackney"]
[null,null,null,null,null,null,"London - Hammersmith & Fulham","London","Hammersmith & Fulham"]
[null,null,null,null,null,null,"London - Haringey","London","Haringey"]
[null,null,null,null,null,null,"London - Harrow","London","Harrow"]
[null,null,null,null,null,null,"London - Havering","London","Havering"]
[null,null,null,null,null,null,"London - Hillingdon","London","Hillingdon"]
[null,null,null,null,null,null,"London - Hounslow","London","Hounslow"]
[null,null,null,null,null,null,"London - Islington","London","Islington"]
[null,null,null,null,null,null,"London - Kensington & Chelsea","London","Kensington & Chelsea"]
[null,null,null,null,null,null,"London - Kingston-upon-Thames","London","Kingston-upon-Thames"]
[null,null,null,null,null,null,"London - Lambeth","London","Lambeth"]
[null,null,null,null,null,null,"London - Lewisham","London","Lewisham"]
[null,null,null,null,null,null,"London - Merton","London","Merton"]
[null,null,null,null,null,null,"London - Newham","London","Newham"]
[null,null,null,null,null,null,"London - Redbridge","London","Redbridge"]
[null,null,null,null,null,null,"London - Richmond-upon-Thames","London","Richmond-upon-Thames"]
[null,null,null,null,null,null,"London - Southwark","London","Southwark"]
[null,null,null,null,null,null,"London - Sutton","London","Sutton"]
[null,null,null,null,null,null,"London - Tower Hamlets","London","Tower Hamlets"]
[null,null,null,null,null,null,"London - Waltham Forest","London","Waltham Forest"]
[null,null,null,null,null,null,"London - Wandsworth","London","Wandsworth"]
[null,null,null,null,null,null,"London - Westminster","London","Westminster"]
[null,null,null,null,null,null,"North East - Darlington","North East","Darlington"]
[null,null,null,null,null,null,"North East - Durham","North East","Durham"]
[null,null,null,null,null,null,"North East - Gateshead","North East","Gateshead"]
[null,null,null,null,null,null,"North East - Hartlepool","North East","Hartlepool"]
[null,null,null,null,null,null,"North East - Middlesborough","North East","Middlesborough"]
[null,null,null,null,null,null,"North East - Newcastle-upon-Tyne","North East","Newcastle-upon-Tyne"]
[null,null,null,null,null,null,"North East - North Tyneside","North East","North Tyneside"]
[null,null,null,null,null,null,"North East - Northumberland","North East","Northumberland"]
[null,null,null,null,null,null,"North East - Redcar and Cleveland","North East","Redcar and Cleveland"]
[null,null,null,null,null,null,"North East - South Tyneside","North East","South Tyneside"]
[null,null,null,null,null,null,"North East - Stockton-on-Tees","North East","Stockton-on-Tees"]
[null,null,null,null,null,null,"North East - Sunderland","North East","Sunderland"]
[null,null,null,null,null,null,"North West - Blackburn with Darwen","North West","Blackburn with Darwen"]
[null,null,null,null,null,null,"North West - Blackpool","North West","Blackpool"]
[null,null,null,null,null,null,"North West - Bolton","North West","Bolton"]
[null,null,null,null,null,null,"North West - Bury","North West","Bury"]
[null,null,null,null,null,null,"North West - Cheshire East ","North West","Cheshire East "]
[null,null,null,null,null,null,"North West - Cheshire West & Chester","North West","Cheshire West & Chester"]
[null,null,null,null,null,null,"North West - Cumbria","North West","Cumbria"]
[null,null,null,null,null,null,"North West - Halton","North West","Halton"]
[null,null,null,null,null,null,"North West - Knowsley","North West","Knowsley"]
[null,null,null,null,null,null,"North West - Lancashire","North West","Lancashire"]
[null,null,null,null,null,null,"North West - Liverpool","North West","Liverpool"]
[null,null,null,null,null,null,"North West - Manchester","North West","Manchester"]
[null,null,null,null,null,null,"North West - Oldham","North West","Oldham"]
[null,null,null,null,null,null,"North West - Rochdale","North West","Rochdale"]
[null,null,null,null,null,null,"North West - Salford","North West","Salford"]
[null,null,null,null,null,null,"North West - Sefton","North West","Sefton"]
[null,null,null,null,null,null,"North West - St.Helens","North West","St.Helens"]
[null,null,null,null,null,null,"North West - Stockport","North West","Stockport"]
[null,null,null,null,null,null,"North West - Tameside","North West","Tameside"]
[null,null,null,null,null,null,"North West - Trafford","North West","Trafford"]
[null,null,null,null,null,null,"North West - Warrington","North West","Warrington"]
[null,null,null,null,null,null,"North West - Wigan","North West","Wigan"]
[null,null,null,null,null,null,"North West - Wirral","North West","Wirral"]
[null,null,null,null,null,null,"South East - Bracknell Forest","South East","Bracknell Forest"]
[null,null,null,null,null,null,"South East - Brighton & Hove","South East","Brighton & Hove"]
[null,null,null,null,null,null,"South East - Buckinghamshire","South East","Buckinghamshire"]
[null,null,null,null,null,null,"South East - East Sussex","South East","East Sussex"]
[null,null,null,null,null,null,"South East - Hampshire","South East","Hampshire"]
[null,null,null,null,null,null,"South East - Isle of Wight","South East","Isle of Wight"]
[null,null,null,null,null,null,"South East - Kent","South East","Kent"]
[null,null,null,null,null,null,"South East - Medway","South East","Medway"]
[null,null,null,null,null,null,"South East - Milton Keynes","South East","Milton Keynes"]
[null,null,null,null,null,null,"South East - Oxfordshire","South East","Oxfordshire"]
[null,null,null,null,null,null,"South East - Portsmouth","South East","Portsmouth"]
[null,null,null,null,null,null,"South East - Reading","South East","Reading"]
[null,null,null,null,null,null,"South East - Slough","South East","Slough"]
[null,null,null,null,null,null,"South East - Southampton","South East","Southampton"]
[null,null,null,null,null,null,"South East - Surrey","South East","Surrey"]
[null,null,null,null,null,null,"South East - West Berkshire","South East","West Berkshire"]
[null,null,null,null,null,null,"South East - West Sussex","South East","West Sussex"]
[null,null,null,null,null,null,"South East - Windsor & Maidenhead","South East","Windsor & Maidenhead"]
[null,null,null,null,null,null,"South East - Wokingham","South East","Wokingham"]
[null,null,null,null,null,null,"South West - Bath & N.E Somerset","South West","Bath & N.E Somerset"]
[null,null,null,null,null,null,"South West - Bournmouth","South West","Bournmouth"]
[null,null,null,null,null,null,"South West - Bristol","South West","Bristol"]
[null,null,null,null,null,null,"South West - Cornwall","South West","Cornwall"]
[null,null,null,null,null,null,"South West - Devon","South West","Devon"]
[null,null,null,null,null,null,"South West - Dorset","South West","Dorset"]
[null,null,null,null,null,null,"South West - Gloucestershire","South West","Gloucestershire"]
[null,null,null,null,null,null,"South West - North Somerset","South West","North Somerset"]
[null,null,null,null,null,null,"South West - Plymouth","South West","Plymouth"]
[null,null,null,null,null,null,"South West - Poole","South West","Poole"]
[null,null,null,null,null,null,"South West - Somerset","South West","Somerset"]
[null,null,null,null,null,null,"South West - South Gloucestershire","South West","South Gloucestershire"]
[null,null,null,null,null,null,"South West - Swindon","South West","Swindon"]
[null,null,null,null,null,null,"South West - Torbay","South West","Torbay"]
[null,null,null,null,null,null,"South West - Wiltshire","South West","Wiltshire"]
[null,null,null,null,null,null,"West Midlands - Birmingham","West Midlands","Birmingham"]
[null,null,null,null,null,null,"West Midlands - Coventry","West Midlands","Coventry"]
[null,null,null,null,null,null,"West Midlands - Dudley","West Midlands","Dudley"]
[null,null,null,null,null,null,"West Midlands - Herefordshire","West Midlands","Herefordshire"]
[null,null,null,null,null,null,"West Midlands - Sandwell","West Midlands","Sandwell"]
[null,null,null,null,null,null,"West Midlands - Shropshire","West Midlands","Shropshire"]
[null,null,null,null,null,null,"West Midlands - Solihull","West Midlands","Solihull"]
[null,null,null,null,null,null,"West Midlands - Staffordshire","West Midlands","Staffordshire"]
[null,null,null,null,null,null,"West Midlands - Stoke-on-Trent","West Midlands","Stoke-on-Trent"]
[null,null,null,null,null,null,"West Midlands - Telford & Wrekin","West Midlands","Telford & Wrekin"]
[null,null,null,null,null,null,"West Midlands - Walsall","West Midlands","Walsall"]
[null,null,null,null,null,null,"West Midlands - Warwickshire","West Midlands","Warwickshire"]
[null,null,null,null,null,null,"West Midlands - Wolverhampton","West Midlands","Wolverhampton"]
[null,null,null,null,null,null,"West Midlands - Worcestershire","West Midlands","Worcestershire"]
[null,null,null,null,null,null,"Yorks & Humber - Barnsley","Yorks & Humber","Barnsley"]
[null,null,null,null,null,null,"Yorks & Humber - Bradford","Yorks & Humber","Bradford"]
[null,null,null,null,null,null,"Yorks & Humber - Calderdale","Yorks & Humber","Calderdale"]
[null,null,null,null,null,null,"Yorks & Humber - Doncaster","Yorks & Humber","Doncaster"]
[null,null,null,null,null,null,"Yorks & Humber - East Riding of Yorkshire","Yorks & Humber","East Riding of Yorkshire"]
[null,null,null,null,null,null,"Yorks & Humber - Kingston upon Hull","Yorks & Humber","Kingston upon Hull"]
[null,null,null,null,null,null,"Yorks & Humber - Kirklees","Yorks & Humber","Kirklees"]
[null,null,null,null,null,null,"Yorks & Humber - Leeds","Yorks & Humber","Leeds"]
[null,null,null,null,null,null,"Yorks & Humber - N.Yorkshire","Yorks & Humber","N.Yorkshire"]
[null,null,null,null,null,null,"Yorks & Humber - North East Lincolnshire","Yorks & Humber","North East Lincolnshire"]
[null,null,null,null,null,null,"Yorks & Humber - North Lincolnshire","Yorks & Humber","North Lincolnshire"]
[null,null,null,null,null,null,"Yorks & Humber - Rotherham","Yorks & Humber","Rotherham"]
[null,null,null,null,null,null,"Yorks & Humber - Sheffield","Yorks & Humber","Sheffield"]
[null,null,null,null,null,null,"Yorks & Humber - Wakefield","Yorks & Humber","Wakefield"]
[null,null,null,null,null,null,"Yorks & Humber - York","Yorks & Humber","York"]

{"sheet":"Summary LA","index":4,"n_rows":286,"n_cols":14,"rows_kept":286,"cut":false,"hidden":false,"merged":[[1,3,1,17],[4,8,4,10],[5,8,5,10]]}
[]
[null,null,null,"Special Educational Needs & Disability (SEND) Diagnostic Checklist for Local Authorities"]
[]
[]
[null,null,null,null,null,null,null,"REGION"]
[null,null,null,null,null,null,null,"LOCAL AUTHORITY"]
[]
[]
[]
[]
[null,null,null,"OVERALL SCORE"]
[]
[null,null,null,null,null,"1st Audit",null,null,null,null,null,null,null,"2nd Audit"]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,{"$f":"SUM(Calc!$I$35:$K$35)","v":0},null,null,null,null,null,null,null,{"$f":"SUM(Calc!$S$35:$U$35)","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,"1st Audit",null,null,null,null,null,null,"2nd Audit"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"1. LEADERSHIP"]
[]
[null,null,null,null,null,"1st Audit",null,null,null,null,null,null,null,"2nd Audit"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,{"$f":"SUM(Calc!I28:K28)","v":0},null,null,null,null,null,null,null,{"$f":"SUM(Calc!S28:U28)","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,"1st Audit",null,null,null,null,null,null,"2nd Audit"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"2. JOINT ARRANGEMENTS"]
[]
[null,null,null,null,null,"1st Audit",null,null,null,null,null,null,null,"2nd Audit"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,{"$f":"SUM(Calc!I29:K29)","v":0},null,null,null,null,null,null,null,{"$f":"SUM(Calc!S29:U29)","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,"1st Audit",null,null,null,null,null,null,"2nd Audit"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"3. COMMISSIONING"]
[]
[null,null,null,null,null,"1st Audit",null,null,null,null,null,null,null,"2nd Audit"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,{"$f":"SUM(Calc!I30:K30)","v":0},null,null,null,null,null,null,null,{"$f":"SUM(Calc!S30:U30)","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,"1st Audit",null,null,null,null,null,null,"2nd Audit"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"4. EHC PLAN"]
[]
[null,null,null,null,null,"1st Audit",null,null,null,null,null,null,null,"2nd Audit"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,{"$f":"SUM(Calc!I31:K31)","v":0},null,null,null,null,null,null,null,{"$f":"SUM(Calc!S31:U31)","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,"1st Audit",null,null,null,null,null,null,"2nd Audit"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"5. CO-PRODUCTION (ENGAGEMENT)"]
[]
[null,null,null,null,null,"1st Audit",null,null,null,null,null,null,null,"2nd Audit"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,{"$f":"SUM(Calc!I32:K32)","v":0},null,null,null,null,null,null,null,{"$f":"SUM(Calc!S32:U32)","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,"1st Audit",null,null,null,null,null,null,"2nd Audit"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"6. MONITOR & REDRESS"]
[]
[null,null,null,null,null,"1st Audit",null,null,null,null,null,null,null,"2nd Audit"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,{"$f":"SUM(Calc!I33:K33)","v":0},null,null,null,null,null,null,null,{"$f":"SUM(Calc!S33:U33)","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,"1st Audit",null,null,null,null,null,null,"2nd Audit"]

{"sheet":"1. LA - Leadership","index":5,"n_rows":83,"n_cols":10,"rows_kept":83,"cut":false,"hidden":false,"merged":[[72,3,72,9],[6,3,6,9],[35,3,35,9],[52,3,52,9]]}
[]
[null,null,null,"1. LEADERSHIP"]
[]
[null,null,null,"Governance and Leadership"]
[]
[null,null,null,"Additional Notes (press '+' sign to expand)"]
[null,null,null,"\nTop tier local authorities must designate one of its members as Lead Member for Children’s Services (LMCS) and appoint a Director for Children’s Services (DCS). The DCS has professional responsibility for children’s services, including operational matters; the LMCS has political responsibility for children’s services.  The DCS and LMCS have a key leadership role both within the local authority and working with other local agencies to improve outcomes for disabled children and young people and those with SEN.\n\nThe DCS and LMCS should report to the Chief Executive and to the Council Leader or Mayor respectively as they are the post holders with ultimate responsibility for the political and corporate leadership of the Council. They are also accountable for ensuring that the effectiveness of steps taken and capacity to improve outcomes for all children and young people is reflected across the full range of the Council’s business. \nThere is statutory guidance on the roles and responsibilities of the Director of Children’s Services and the Lead Member for Children’s Services."]
[]
[null,null,null,"Prompts for Implementation","Key Indicators / Evidence","LA Named Lead","1st Audit RAG Rating: DD/MM/YY","2nd Audit RAG Rating: DD/MM/YY","Trend","Comments/Evidence"]
[null,null,null,"Is there democratic scrutiny of the local authority's arrangements for disabled children and young people and those with SEN?","The LMCS and DCS report regularly to elected members on SEND.\n\nSEND has been recently considered by an overview and scrutiny committee, or there are plans to do so. \n\nThe Nominated Officer for SEN produces regular updates on implementing SEND reforms for LMCS. \n\nReports are made to LA Corporate Parenting Board and Children's Safeguarding Board on delivery of SEND strategy.",null,"Please Select","Please Select","Please Select"]
[null,null,null,"How has the LA responded to ensuring a joined up approach to support for 0-25 age range across directorates within the LA (with particular focus on promoting effective transitions, including Preparation for Adulthood)?","There are 0-25 strategies\n\nThere are integrated 0-25 teams\n\nThere is effective communication between teams focussed on supporting 0-25 year olds who are eligible for either SEN Support or an EHC plan.",null,"Please Select","Please Select","Please Select"]
[null,null,null,"Has the LA worked with its strategic partners to develop and agree a multiagency SEND strategy and implementation plan which clearly defines the strategic vision, objectives and outcomes that partners will work towards?","There is a multiagency SEND strategy and implementation plan signed off by all partners \n\nThere is a strategic partnership group which oversees the implementation and review of the plan. \n\nThere is a clear statement and commitment to promoting coproduction and personalisation within the strategy. \n\nThere is a clear set of performance measures that demonstrate progress towards acheiving key outcomes with the SEND strategy.",null,"Please Select","Please Select","Please Select"]
[null,null,null,"How does the LA provide assurance that work undertaken around other national programmes (i.e. Transforming Care, CAMHS transformation, IPC) is aligned to SEND strategy and implementation plan?","The SEND strategy and implementation plan clearly reference work in progress on other relevant national programmes.",null,"Please Select","Please Select","Please Select"]
[null,null,null,"Has the LA signed off the joint commissioning arrangements with clinical commissioning group(s) and the outcomes they are intended to support around the 0-25 age group?","There is a document setting out the details of the joint commissioning arrangements which has received senior sign off\n\nThere are a set of agreed outcomes across education health and social care.",null,"Please Select","Please Select","Please Select"]
[null,null,null,"Are there effective and robust assurance checks  in place for progress towards implementation of the SEND reforms?","Assurance checks have been agreed by the Council, including a set of outcomes by which success will be measured\n\nRegular reports are provided to the executive and political leadership on progress.",null,"Please Select","Please Select","Please Select"]
[null,null,null,"Are there clear joint governance arrangements for commissioning services for children and young people with SEN and disabilities from birth to the age of 25?","Joint governance arrangements are available that show which senior managers are accountable for commissioning across education, health and social care and across the different age ranges",null,"Please Select","Please Select","Please Select"]
[null,null,null,"To what extent are leaders aware of their areas of strengths and areas for development.","Peer review internally and regionally .  Feedback from parents. Process for sharing audit tool and gaining triangulated feedback on self assessment.",null,"Please Select","Please Select","Please Select"]
[null,null,null,"Is there a clear process for engagement with leaders of local settings including headteachers, principals of FE colleges and EY settings, around the development, implementation and review of SEND reforms?","LA engages with headteachers, principals etc within dedicated groups. \n\nLocal leaders are involved in strategic partnerships, planning forums. \n\nThere are clear policies in place to allow EY settings, schools and colleges to implement their commissioning functions in relation to SEND provision.",null,"Please Select","Please Select","Please Select"]
[]
[null,null,null,"FURTHER INFORMATION:"]
[]
[null,null,null,"The Children and Families Act 2014"]
[null,null,null,"http://www.legislation.gov.uk/ukpga/2014/6/contents/enacted"]
[]
[null,null,null,"Special educational needs and disability code of practice: 0 to 25 years. Statutory guidance for organisations who work with and support children and young people with special educational needs and disabilities (2014)"]
[null,null,null,"https://www.gov.uk/government/uploads/system/uploads/attachment_data/file/398815/SEND_Code_of_Practice_January_2015.pdf"]
[]
[null,null,null,"CDC Online Learning Module Making it Happen"]
[null,null,null,"https://councilfordisabledchildren.org.uk/learning/sections/health/role-health-practitioners-implementing-children-and-families-act"]
[]
[]
[]
[null,null,null,"Requests for high cost residential or specialist placements for children and young people with complex needs"]
[]
[null,null,null,"Additional Notes (press '+' sign to expand)"]
[null,null,null,"\nWhere a local authority maintains an EHC plan for a child or young person, a child’s parent or a young person can request for a particular type of nursery, school or post-16 institution to be named. The local authority must comply with that preference and name the school or college in the EHC plan unless:\n• it would be unsuitable for the age, ability, aptitude or SEN of the child or young person, or\n• the attendance of the child or young person there would be incompatible with the efficient education of others, or the efficient use of resources\nThe child’s parent or the young person may also make representations for places in non-maintained early years provision or at independent schools or independent specialist colleges or other post-16 providers that are not on a Section 41 list and the local authority must consider their request. However, the local authority is not under the same conditional duty to name the provider \n\nLocal authorities should also consider strategic planning and commissioning of services or placements for children and young people with high levels of need across groups of authorities, or at a regional level. The potential benefits include:\n• greater choice for parents and young people, enabling them to access a wider range of services or educational settings \n• greater continuity of support for children and young people in areas where there is a great deal of movement across local authorities (for example, in London)\n\nNHS England already commissions specialist health services at a regional and national level, so local partners will need to engage and integrate these arrangements to support local joint commissioning activity. When a health body is considering a placement that includes an education commitment, such as a placement in residential care, they should consult the local authority prior to the decision being made. The Winterbourne View Concordat emphasised the need for high quality local provision – local authorities and CCGs should work together to consider how they will reduce out-of-area placements. Regional commissioning may help them to do this."]
[]
[null,null,null,"Prompts for Implementation","Key Indicators / Evidence","LA Named Lead","1st Audit RAG Rating: DD/MM/YY","2nd Audit RAG Rating: DD/MM/YY","Trend","Comments/Evidence"]
[null,null,null,"Are the arrangements for the local authority to consider requests for these types of placements made clear to parents and young people? ","There is a policy to explain how the decision will be made in advance to parents and young people\n\nThe legal criteria are explained  \n\nThe Local Offer includes information about how a LA may consider a residential placement if a child's needs cannot be met within local provision",null,"Please Select","Please Select","Please Select"]
[null,null,null,"Is there a multi-agency panel or board that allows joint placement decisions to be made across health, social care and education?","Framework / protocol includes  procedure for reaching a decision. e.g. panel drawing on assessor recommendation, and executive oversight.",null,"Please Select","Please Select","Please Select"]
[null,null,null,"Are there multi-agency governance arrangements for reviewing the quality of the placement and its ability to meet the identified outcomes in the EHC Plan?","Residential placements are being reviewed on a multi-agency basis.\n\nAnnual review of EHC Plan",null,"Please Select","Please Select","Please Select"]
[]
[null,null,null,"FURTHER INFORMATION:"]
[]
[null,null,null,"The framework for Children and Young People’s Continuing Care has been revised to take account of the new SEND framework."]
[null,null,null,"https://www.gov.uk/government/uploads/system/uploads/attachment_data/file/499611/children_s_continuing_care_Fe_16.pdf"]
[]
[]
[]
[null,null,null,"Monitoring and Agreeing Plans"]
[]
[null,null,null,"Additional Notes (press '+' sign to expand)"]
[null,null,null,"\nLocal authorities, NHS England and their partner CCGs must put in place joint commissioning arrangements for agreeing the education, health and social care provision reasonably required by local children and young people with SEN or disabilities. The local authority must review its educational, training and social care provision, consulting a range of partners including children and young people with SEN or disabilities, and their parents and carers. This consultation will inform the development and review of the Local Offer.\nThe joint commissioning arrangements must also include arrangements for:\n• securing EHC needs assessments\n• securing the education, health and care provision specified in EHC plans, and\n• agreeing Personal Budgets.\nAt a strategic level, partners must engage children and young people with SEN and disabilities and children’s parents in commissioning decisions, to give insights into how to improve services and outcomes."]
[]
[null,null,null,"Prompts for Implementation","Key Indicators / Evidence","LA Named Lead","1st Audit RAG Rating: DD/MM/YY","2nd Audit RAG Rating: DD/MM/YY","Trend","Comments/Evidence"]
[null,null,null,"Are joint commissioning arrangements leading to improvements in partners working together to support the delivery of outcomes in EHC plans?","The impact of local provision on outcomes for children and young people is closely monitored. \n\nA baseline has been established against which targets can be set and outcomes measured\n\nSuccess criteria that have been agreed across education, health and social care services are used to judge effectiveness",null,"Please Select","Please Select","Please Select"]
[null,null,null,"Is there a process for internal audit and external peer review/moderation of plans?","DMO/DCO works collaboratively with the LA to undertake an internal audit process around the quality of EHC Plans.\nThe local authority has an arrangement with neighbouring authorities to peer review each other's plans.",null,"Please Select","Please Select","Please Select"]
[]
[null,null,null,"FURTHER INFORMATION:"]
[]
[null,null,null,"Appendix 4: SE7 Thinking about good outcomes"]
[null,null,null,"http://www.sendpathfinder.co.uk/coordinated-assessment-process"]
[]
[null,null,null,"See also:"]
[null,null,null,"• DMO/DCO Handbook (Commissioning: DMO / DCO: Further information)"]
[null,null,null,"• The Joint Commissioning Information pack (Joint Arrangements: Working across the local authority and with health services: Further information)"]
[]
[]
[]
[null,null,null,"Resourcing Joint Arrangements"]
[]
[null,null,null,"Additional Notes (press '+' sign to expand)"]
[null,null,null,"\nEnsuring effective implementation of the new statutory framework for SEND requires  staff resourcing and ensuring appropriate strategic links with the CCG will require some senior input. Monitoring implementation of the joint commissioning arrangements on a day-to-day basis can be subsumed within on-going monitoring of commissioning services for children and young people. Where mediation or complaints handling is necessary, more intensive input would be required, but this would be on an occasional rather than a routine basis. \n\nThe local authority will want to ensure the effectiveness of its role in joint arrangements, and the effectiveness of the services it is commissioning for this group of children and young people. This will require a mix of evidence, some of process (the relationship with the local authority), some of volume (the number of EHC plans, compared with anticipated demand), user experience, and outcomes (both at cohort level, and in terms of the EHC plan delivering the specified outcomes for the individual)."]
[]
[null,null,null,"Prompts for Implementation","Key Indicators / Evidence","LA Named Lead","1st Audit RAG Rating: DD/MM/YY","2nd Audit RAG Rating: DD/MM/YY","Trend","Comments/Evidence"]
[null,null,null,"Is there a team or teams (s) with explicit responsibility for SEND commissioning? ","Senior managers and officers in the authority have SEND commissioning as part of the job descriptions and time to complete it\n\nIf the SEND commissioning team sits outside the SEN operational team there are clear links between them\n\nIs SEND commissioning the sole responsibility of this team, or is it part of a larger portfolio (e.g. children’s commissioning)?  If the latter, there are safeguards are in place to ensure time remains dedicated to SEND? ",null,"Please Select","Please Select","Please Select"]
[null,null,null,"How can the LA demonstrate integrated commissioning processes across education, health and care?","There are integrated teams covering education and social care or close working relationships to enable this joint working. \n\nJoint commissioning arrangements in place e.g. section 75 agreements, pooled budgets.",null,"Please Select","Please Select","Please Select"]
[null,null,null,"Are there clear links between commissioners of children's and adult services to ensure a successful transition to adulthood?","There are links and processes to facilitate joint planning between children's and adult services ",null,"Please Select","Please Select","Please Select"]
[null,null,null,"How does the local authority demonstrate effective use of finite resources to meet the needs of CYP with SEND?","Regular monitoring and review of spend across the LA \n\nRegular performance management of LA contracts \n\nEvidence of cost saving initiatives to demonstrate best value. \n\nJoint arrangements with the CCG include reviews of joint capacity in relation to servicing the SEND arrangements.",null,"Please Select","Please Select","Please Select"]
[]
[null,null,null,"FURTHER INFORMATION:"]
[]
[null,null,null,"See materials under the Further Information sections under Joint Arrangements"]

{"sheet":"2. LA - Joint Arrangements","index":6,"n_rows":119,"n_cols":10,"rows_kept":119,"cut":false,"hidden":false,"merged":[[65,3,65,9],[68,4,70,4],[85,3,85,9],[6,3,6,9],[38,3,38,9],[41,4,42,4]]}
[]
[null,null,null,"2. Joint Arrangements"]
[]
[null,null,null,"Working across the local authority and with health services"]
[]
[null,null,null,"Additional Notes (press '+' sign to expand)"]
[null,null,null,"\nSection 25 of the Children and Families Act 2014 places a duty on local authorities that should ensure integration between educational provision and training provision, health and social care provision, where this would promote wellbeing and improve the quality of provision for disabled young people and those with SEN. Local authorities and clinical commissioning groups (CCGs) must make joint commissioning arrangements for education, health and care provision for children and young people with SEN or disabilities (Section 26 of the Act). The term ‘partners’ refers to the local authority and its partner commissioning bodies across education, health and social care provision for children and young people with SEN or disabilities, including clinicians’ commissioning arrangements, and NHS England for specialist health provision.\n\nLocal authorities, NHS England and their partner CCGs must make arrangements for agreeing the education, health and social care provision reasonably required by local children and young people with SEN or disabilities. Joint commissioning must also include arrangements for:\n• securing EHC needs assessments\n• securing the education, health and care provision specified in EHC plans, and\n• agreeing Personal Budgets"]
[]
[null,null,null,"Prompts for Implementation","Key Indicators / Evidence","LA Named Lead","1st Audit RAG Rating: DD/MM/YY","2nd Audit RAG Rating: DD/MM/YY","Trend","Comments/Evidence"]
[null,null,null,"Are the joint commissioning arrangements with the CCG fully documented, and subject to a written agreement?","The arrangements are documented and easily accessible.",null,"Please Select","Please Select","Please Select"]
[null,null,null,"Is there a forum or working group for reviewing the joint commissioning arrangements?","The joint commissioning arrangements are kept under regular review and there is a specific forum where issues can be raised. Staff are given sufficient time to participate.",null,"Please Select","Please Select","Please Select"]
[null,null,null,"Are there clear decision-making structures which allow partners to agree the outcomes sought and services required to achieve them","There is a structure in place such as a SEND Joint Commissioning Board which provides a forum for decision making\n\nThere is evidence that the SEND Joint Commissioning Board reports to the H&WBB and informs the H&WBB Strategy and JSNA",null,"Please Select","Please Select","Please Select"]
[null,null,null,"Are there agreements in place about how children's and adult social care services contribute to the SEN agenda?","There is a 0-25 service model",null,"Please Select","Please Select","Please Select"]
[null,null,null,"Has the local authority and its partners ensured that there is alignment between their SEND strategy, their Transforming Care plans, their CAMHS transformation plans and where, in place, their IPC programmes?","Specific programme documents clearly reference other relevant programmes of work and identify the interdependencies of the programmes.",null,"Please Select","Please Select","Please Select"]
[null,null,null,"Is there alignment between your Early Help Provision and your SEND provision?  With the Early Help Offer aligned with the SEND Local Offer?","There is a graduated support offer with a single point of entry for Early Help and SEN Support or processes for drawing down provision of support are aligned.",null,"Please Select","Please Select","Please Select"]
[null,null,null,"Is the local authority and its partners mindful of the public sector equality duty to eliminate discrimination, promote equality of opportunity and foster good relations between disabled and non-disabled children and young people","The local authority publishes information to demonstrate its compliance with the general duty, including in relation to disabled children and young people. The core aims of the general duty are considered when making commissioning decisions. ",null,"Please Select","Please Select","Please Select"]
[null,null,null,"What arrangements are in place for the LA to quality assure and performance manage its in-house functions against meeting the statutory duties with the SEND Code of Practice?","Timescales for transfer from statements to EHC plans are met.\n\nEHC plans are signed off within the 20 week timescale. \n\nNumbers of EHC Plans which are appealed \n\nInformal mediation takes place and successfully resolves concerns. \n\nThere is oversight of SEND process and effective engagement from partners. ",null,"Please Select","Please Select","Please Select"]
[null,null,null,"Where there is a DMO/DCO in place, how is the LA working with its CCG partner(s) to measure the impact of the role in delivering the SEND reforms? ","The DMO/DCO role and its remit is reviewed regularly. If there is not a DMO/DCO in place what representation are the local authority making to the CCG to ensure that the role is being effectively carried out.",null,"Please Select","Please Select","Please Select"]
[]
[null,null,null,"FURTHER INFORMATION:"]
[]
[null,null,null,"The Joint Commissioning Information pack has abundant evidence on effective collaboration:"]
[null,null,null,"http://www.sendpathfinder.co.uk/joint-commissioning-information-pack"]
[]
[null,null,null,"Integrated Personal Commissioning"]
[null,null,null,"https://www.england.nhs.uk/healthbudgets/wp-content/uploads/sites/26/2016/05/ipc-emerging-framework.pdf"]
[]
[null,null,null,"Future in Mind"]
[null,null,null,"https://www.gov.uk/government/uploads/system/uploads/attachment_data/file/414024/Childrens_Mental_Health.pdf"]
[]
[null,null,null,"Transforming Care"]
[null,null,null,"https://www.england.nhs.uk/learningdisabilities/care/"]
[]
[]
[]
[null,null,null,"Health and Wellbeing Boards"]
[]
[null,null,null,"Additional Notes (press '+' sign to expand)"]
[null,null,null,"\nThe Health and Wellbeing Board (HWB) has a pivotal role to play in implementing the SEND reforms. Membership of the HWB must include at least one local elected councillor, the DCS, the Director of Adult Social Services, a senior CCG representative and the Director of Public Health. The Health and Wellbeing Board must ensure a joint strategic needs assessment (JSNA) of the current and future needs of the whole local population is developed.\n\nThe JSNA will form the basis of NHS and local authorities’ own commissioning plans, across health, social care, public health and children’s services. This should include specific needs of disabled children and young people and those with SEN. Ideally CCGs and local authorities as members of HWBs should ensure JSNA and JHWS articulate the local SEND need, which joint arrangements will focus on.\n"]
[]
[null,null,null,"Prompts for Implementation","Key Indicators / Evidence","LA Named Lead","1st Audit RAG Rating: DD/MM/YY","2nd Audit RAG Rating: DD/MM/YY","Trend","Comments/Evidence"]
[null,null,null,"What arrangements are in place to ensure that the SEND strategy is aligned to the broader health and wellbeing strategy?","The JSNA articulates the need of children and young people with SEND. \n\nThe Joint Health and Wellbeing Strategy makes specific reference to children and young people with SEND.",null,"Please Select","Please Select","Please Select"]
[null,null,null,"How well do commissioners for children and young people with SEN and disabilities engage with the Health and Wellbeing Board?",null,null,"Please Select","Please Select","Please Select"]
[null,null,null,"How is the LA ensuring that the needs of CYP with SEND are captured within the Sustainability & Transformation Plan (STP) and local Digital Roadmap?","The needs of CYP with SEND are included in STP and local Digital Roadmap \n\nThe 10 Digital Capabilities in the local Digital Roadmap are applied to CYP services and adult health and social care services ",null,"Please Select","Please Select","Please Select"]
[null,null,null,"What assurance processes are in place to enable the health and wellbeing board to have oversight on the implementation of the SEND reforms? ","The LA submits progress reports on delivery of SEND strategy to the Health and Wellbeing Board",null,"Please Select","Please Select","Please Select"]
[]
[null,null,null,"FURTHER INFORMATION:"]
[]
[null,null,null,"Guidance for HWBs on children’s complex needs are be found at: "]
[null,null,null,"https://www.gov.uk/government/uploads/system/uploads/attachment_data/file/357447/DH_HWB_children_s_guidance.pdf "]
[]
[null,null,null,"Operating Principles for Health and Wellbeing Boards. "]
[null,null,null,"http://www.local.gov.uk/c/document_library/get_file?uuid=1ccc06cb-d44b-43c6-b04c-f7b713e03122&groupId=10180 "]
[]
[null,null,null,"Rochdale’s Joint Health and Wellbeing Strategy: "]
[null,null,null,"http://www.hmr.nhs.uk/attachments/article/81/jointhealthwellbeingstrategy12-15.pdf?_sm_au_=iHVgkN6tWJ5nrVWj"]
[]
[null,null,null,"Wiltshire’s Joint Health and Wellbeing Strategy: "]
[null,null,null,"http://www.wiltshire.gov.uk/healthandsocialcare/jointhealthandwellbeingstrategy.htm"]
[]
[]
[]
[null,null,null,"Dispute Resolution between agencies"]
[]
[null,null,null,"Additional Notes (press '+' sign to expand)"]
[null,null,null,"\nJoint arrangements need dispute resolution – a basic forum bringing the CCG and LA together, with appropriate senior oversight, directly linked to those with responsibility for determining commissioning strategy / plans, and with financial input. Joint arrangements could include a protocol for decision making and escalation and could plan for challenge points within the process (e.g. at referral, following joint assessment of evidence, mediation) \n\nLocal authority and CCGs could take stock of existing commissioning plans, and capacity; the significance of the overlap of speech and language therapy would recommend a specific stocktake of SLT services across education and health, and how providers in particular manage demand, with a view to adopting a collaborative approach. Joint commissioning of SLT between schools, LA and CCG would be a sensible basis for an integrated, equitable approach. \n\nThe SEND framework is about integrated commissioning; CCGs will necessarily have to commission  SLT for children with communication support needs – and the joint arrangements provide a basis for agreeing joined-up commissioning of SLT across education and health. Schools will often be commissioning SLT through delegated budgets, the pupil premium etc., and the local authority can help broker a joint approach between schools and the CCG."]
[]
[null,null,null,"Prompts for Implementation","Key Indicators / Evidence","LA Named Lead","1st Audit RAG Rating: DD/MM/YY","2nd Audit RAG Rating: DD/MM/YY","Trend","Comments/Evidence"]
[null,null,null,"Is there a framework for resolving disputes about strategic commissioning decisions across partners?","CCG and local authority joint arrangements include a formal, documented process for resolving disputes. \n\nThis includes the monitoring by each party, and escalation procedures, and identifies personnel with delegated responsibility. \n",null,"Please Select","Please Select","Please Select"]
[null,null,null,"Are all parties aware who the decision makers are in relation to health, social care and education",null,null,"Please Select","Please Select","Please Select"]
[null,null,null,"Is there a mechanism for resolving fundamental disputes about the joint arrangements, and disputes over who pays? What is the existing framework for disputes / deadlock on the responsible commissioner?",null,null,"Please Select","Please Select","Please Select"]
[]
[null,null,null,"FURTHER INFORMATION:"]
[]
[null,null,null,"The Communication Council briefing on SLCN for health audiences"]
[null,null,null,"www.thecommunicationtrust.org.uk/sendreforms"]
[]
[null,null,null,"The Royal College of Speech and Language Therapists has a range of information resources on speech and language therapy to support effective commissioning. "]
[null,null,null,"http://www.rcslt.org/speech_and_language_therapy/commissioning/intro"]
[]
[]
[]
[null,null,null,"Local Offer"]
[]
[null,null,null,"Additional Notes (press '+' sign to expand)"]
[null,null,null,"\nThe local offer will be published on the local authority website, and this should include details of all services relevant to children and young people with SEND, including to access, eligibility criteria, and details of how individuals may seek more information or make a complaint."]
[]
[null,null,null,"Prompts for Implementation","Key Indicators / Evidence","LA Named Lead","1st Audit RAG Rating: DD/MM/YY","2nd Audit RAG Rating: DD/MM/YY","Trend","Comments/Evidence"]
[null,null,null,"How has the LA promoted the coproduction of CYP with SEND and their parent/carers in the design, implementation and review of the local offer? ","The local offer is user friendly, accessible and relevant\n\nParent Carer Forum is involved in strategic planning groups linked to development and review of the local offer\n\nMechanisms are in place to capture and record feedback from CYP and parent/carers on the content and functionality of the local offer\n\nThe LA produces an annual report summarising local offer feedback and responses to this.\n\nThe LA uses feedback to inform future commissioning priorities.  ",null,"Please Select","Please Select","Please Select"]
[null,null,null,"How has the LA ensured that local and national voluntary sector support (including local parent carer forums and other parent support groups) is included in the local offer?","The local offer includes information and links to voluntary sector support. ",null,"Please Select","Please Select","Please Select"]
[null,null,null,"How is the local offer used to understand unmet need and amended to reflect new services/provision commissioned?","The local offer is up to date in terms of available SEND provision.\n\nThe local offer is used as a commissioning tool to identify unmet needs.",null,"Please Select","Please Select","Please Select"]
[null,null,null,"Does the local offer include information on provision available for those eligible for SEN Support?","Information about SEN Support is included in the local offer",null,"Please Select","Please Select","Please Select"]
[null,null,null,"Is the process for requesting an EHC Needs Assessment, the resulting process involved in developing an EHC plan clearly defined in the local offer?\n\n","The EHC process is documented in the local offer \n\nLocal Independent Support agencies are referenced and contact details included in local offer ",null,"Please Select","Please Select","Please Select"]
[null,null,null,"Is the process for EHC plan review clearly defined in the local offer?","The EHC plan review process is documented in the local offer",null,"Please Select","Please Select","Please Select"]
[null,null,null,"Is information about Personal Budgets including how to request one from education, health and social care included in the local offer?","Personal budget information is clear in the local offer, including what a PB can be used for; the support available to develop and administer PBs.",null,"Please Select","Please Select","Please Select"]
[null,null,null,"Are the local arrangements for making a complaint, mediation and dispute resolution included in the local offer?","The local arrangements for making a complaint, mediation and dispute resolution are in the local offer. ",null,"Please Select","Please Select","Please Select"]
[null,null,null,"Does the local offer include information on children's social care, including eligibility for services?","a) The Local Threshold document including:\nInformation about the levels for the different types of assessment and services available as well as the process for referral. \nIe.\n• the process for the early help assessment and the type and level of early help services to be provided; \n• the criteria, including the level of need, for when a case should be referred to local authority children’s social care for assessment and for statutory services under: section 17 of the Children Act 1989 (children in need); section 47 of the Children Act 1989 (reasonable cause to suspect children suffering or likely to suffer significant harm)\n\nb) The short breaks duty statement including eligibility criteria\n",null,"Please Select","Please Select","Please Select"]
[null,null,null,"Does the local offer include information on adult social care, including eligibility for services?","The availability of transition assessments for adult social care (Child's Needs Assessments). The criteria that the local authority judges eligibility.",null,"Please Select","Please Select","Please Select"]
[null,null,null,"Is the local authority confident that local offer includes comprehensive and up to date information on health services, including eligibility for services?","The local offer includes available health services. ",null,"Please Select","Please Select","Please Select"]
[null,null,null,"Does the local offer set out what early years providers, school and post-16 institutions are expected to provide?","Information that includes: how facilities can be accessed; the expertise of staff; provision available through SEN Support; extra curricular activities; and pastoral support. There are links to school information reports. It includes the availability of post-16 training options, including apprenticeships, traineeships and supported internships. \n\nThe local offer links to individual settings' SEN offer.",null,"Please Select","Please Select","Please Select"]
[null,null,null,"Does the local offer include information on preparing for adulthood, including eligibility for services?","Information about finding accommodation; support to find work; financial support; leisure and social activities and other ways of getting involved in the community. \nIt is clear from the Local Offer that the Year 9 review is an excellent opportunity to begin planning in earnest for adulthood.",null,"Please Select","Please Select","Please Select"]
[null,null,null,"Does the local offer include information about universal leisure provision including the provision of Changing Places facilities?","Information is included in the Local Offer",null,"Please Select","Please Select","Please Select"]
[]
[null,null,null,"FURTHER INFORMATION:"]
[]
[null,null,null,"How to engage young people in the local offer"]
[null,null,null,"https://councilfordisabledchildren.org.uk/making-ourselves-heard/resources/how-engage-young-people-local-offer"]
[]
[null,null,null,"CDC Local Offer Briefing"]
[null,null,null,"https://councilfordisabledchildren.org.uk/sites/default/files/field/attachemnt/Local%20Offer_Online.pdf"]
[]
[null,null,null,"Leeds City Council have an interactive directory"]
[null,null,null,"https://leedslocaloffer.org.uk/#/directory/suggestions"]
[]
[null,null,null,"You can create your own personal contact list on the Luton Borough Council Directory"]
[null,null,null,"http://directory.luton.gov.uk/kb5/luton/directory/family.page?familychannel=11"]
[]
[null,null,null,"There is a wide range of examples on how to approach the local offer in the Local Offer Information Pack."]
[null,null,null,"http://www.sendpathfinder.co.uk/local-offer-information-pack-resources"]

{"sheet":"3. LA - Commissioning","index":7,"n_rows":128,"n_cols":10,"rows_kept":128,"cut":false,"hidden":false,"merged":[[58,3,58,9],[84,3,84,9],[113,3,113,9],[6,3,6,9],[32,3,32,9]]}
[]
[null,null,null,"3. Commissioning"]
[]
[null,null,null,"Assessing Local Need"]
[]
[null,null,null,"Additional Notes (press '+' sign to expand)"]
[null,null,null,"\nLocal authorities must carry out their functions with a view to identifying all the children and young people in their area who have or may have SEN or have or may have a disability (Section 22 of the Children and Families Act 2014). Local authorities may gather information on children and young people with SEN or disabilities in a number of ways. Anyone can bring a child or young person who they believe has or probably has SEN or a disability to the attention of a local authority (Section 24 of the Children and Families Act 2014) and parents, early years providers, schools and colleges should be encouraged to do so.\n\nLocal authorities must keep data on disabled children on the register of disabled children they are required to keep under Schedule 2 of the Children Act 1989. Local authorities should ensure that registers of disabled children and young people are kept accurate and up to date, and pay particular attention to including low-incidence needs that are particularly difficult to plan for from national data sets."]
[]
[null,null,null,"Prompts for Implementation","Key Indicators / Evidence","LA Named Lead","1st Audit RAG Rating: DD/MM/YY","2nd Audit RAG Rating: DD/MM/YY","Trend","Comments/Evidence"]
[null,null,null,"Does the local authority actively seek to identify all disabled children and young people, and those with SEN, in their area?","The local authority proactively collects information from early years providers, schools, colleges and other education providers on the number of children who receive SEN support.\n\nThe local authority proactively encourages CCGs, NHS Trusts and NHS Foundation Trusts to inform them if they identify a child under compulsory school age as having, or probably having, SEN or a disability\n\nThe local authority draws on information from early health screening programmes\n\nUsing annual school census data to inform strategic planning and joint commissioning\n\nEYFS profile data is analysed to ensure children with SEN are identified at an early stage",null,"Please Select","Please Select","Please Select"]
[null,null,null,"How does the LA ensure that the needs of CYP and their parent/carers with SEND are captured in JSNA?","The JSNA articulates the need of children and young people with SEND. \n\nThe Joint Health and Wellbeing Strategy makes specific reference to children and young people with SEND.",null,"Please Select","Please Select","Please Select"]
[null,null,null,"How has the LA used strategic needs assessments of specific groups of CYP to inform joint commissioning arrangements?","Strategic needs assessments inform commissioning strategies and joint commissioning frameworks",null,"Please Select","Please Select","Please Select"]
[null,null,null,"Does the local authority proactively engage with early years providers, schools, colleges to support accurate identification of SEND?","The local authority provides or commissions support to education settings on accurate identification of SEND \n\nThe local authority looks at school census data to identify possible inconsistencies in the identification of SEND\n\nThe local authority facilitates or engages with peer review processes across groups of schools, SENCo networks or other forums\n\nThe local authority provides feedback to education settings on the views of children, parents and young people on how well needs are identified",null,"Please Select","Please Select","Please Select"]
[null,null,null,"Does the local authority regularly consult early years providers, schools and post-16 providers about the services on offer in relation to SEND? ","There are mechanisms in place to ensure early years providers, schools and post-16 providers can provide feedback to the local authority\n\nThe Schools Forum regularly discusses SEND provision and use of the high-needs block\n",null,"Please Select","Please Select","Please Select"]
[null,null,null,"Does the local authority have confidence that the register of disabled children (or equivalent) is accurate and up to date?","The local authority is confident that it has an accurate understanding of the number of disabled children and young people in the local and the extent and type of their needs\n\nThe local authority benchmarks this data against national data sets.\n\nThis is used to inform strategic needs assessment ",null,"Please Select","Please Select","Please Select"]
[]
[null,null,null,"FURTHER INFORMATION:"]
[]
[null,null,null,"The ChiMat Needs Assessments Reports include one developed for children and young people with disabilities, showing likely prevalence for each local authority area."]
[null,null,null,"http://atlas.chimat.org.uk/IAS/profiles/needsassessments"]
[]
[null,null,null,"The Multi-Agency Planning and Improvement Tool (MAPIT) supports service improvement for children and young people with special educational needs and disabilities and their families."]
[null,null,null,"http://www.councilfordisabledchildren.org.uk/resources/mapit-multi-agency-planning-and-improvement-tool"]
[]
[null,null,null,"Early years: guide to the 0 to 25 SEND code of practice"]
[null,null,null,"https://www.gov.uk/government/uploads/system/uploads/attachment_data/file/350685/Early_Years_Guide_to_SEND_Code_of_Practice_-_02Sept14.pdf"]
[]
[]
[]
[null,null,null,"Affordability and Demand"]
[]
[null,null,null,"Additional Notes (press '+' sign to expand)"]
[null,null,null,"\nLocal authorities must keep educational, training and social care provision for children and young people with SEND under review (Section 27 of the Children and Families Act 2104). This requires them to consult a range of partners, including children and young people and their parents and carers. As part of this duty the local authority must make a judgement about whether the services are sufficient to meet local demand. Linked to this duty is the requirement on local authorities, NHS England and their partner CCGs to make arrangements for agreeing the education, health and social care provision reasonably required by local children and young people with SEN or disabilities. These new arrangements provide a means of reaching a consensual decision on difficult choices. They also provide a basis for strategic discussions on contractual flexibilities, informing dialogue between the local authority and provider on changing demand."]
[]
[null,null,null,"Prompts for Implementation","Key Indicators / Evidence","LA Named Lead","1st Audit RAG Rating: DD/MM/YY","2nd Audit RAG Rating: DD/MM/YY","Trend","Comments/Evidence"]
[null,null,null,"Does the LA have a planning process for ensuring sufficiency of special educational provision?","The local authority has a planning process in place and  uses a range of evidence to consider the sufficiency of places\n\n",null,"Please Select","Please Select","Please Select"]
[null,null,null,"Is there a local mechanism for anticipating changes in demand and monitoring of trends?","The local authority has a mechanism for dialogue with all agencies on changes in SEND prevalence.",null,"Please Select","Please Select","Please Select"]
[null,null,null,"How is the authorities Early Help Offer and SEN support provision linked to building the resilience of families and settings?","The local authority has a strategy for increasing the capacity of mainstream settings, universal and targetted services to meet the needs of children and young people with SEND",null,"Please Select","Please Select","Please Select"]
[null,null,null,"For children with more complex needs how is the authority working collaboratively with its partners to strengthen the resilience of families and settings thereby leading to a reduction in requests for residential placements.","A multi-disciplinary team is in place (this could include a multi-agency intensive support model based on positive behaviour support for children and young people with behaviours that challenge.\nSocial services and the CCG can evidence that they are working collaboratively to use Continuing Care and Social Care packages to build the resilience of families.",null,"Please Select","Please Select","Please Select"]
[null,null,null,"Is there a local mechanism for anticipating changes in demand and monitoring of trends?","The local authority has a mechanism for dialogue with all agencies on changes in SEND prevalence.",null,"Please Select","Please Select","Please Select"]
[null,null,null,"What mechanisms does the LA have for monitoring use of high needs block funding for CYP with SEND?","The LA regularly monitors requests for high needs funding block spend\n\nLA monitors trends in spend",null,"Please Select","Please Select","Please Select"]
[]
[null,null,null,"FURTHER INFORMATION:"]
[]
[null,null,null,"High needs funding: operational guide 2016 to 2017"]
[null,null,null,"https://www.gov.uk/government/publications/high-needs-funding-arrangements-2016-to-2017/high-needs-funding-2016-to-2017"]
[]
[null,null,null,"Children and young people’s health services data set (2015)"]
[null,null,null,"http://www.hscic.gov.uk/maternityandchildren/CYPHS"]
[]
[null,null,null,"Department of Health (2013) Chief Medical Officer Report, Our children deserve better: prevention pays"]
[null,null,null,"https://www.gov.uk/government/uploads/system/uploads/attachment_data/file/255237/2901304_CMO_complete_low_res_accessible.pdf"]
[]
[]
[]
[null,null,null,"Contracts"]
[]
[null,null,null,"Additional Notes (press '+' sign to expand)"]
[null,null,null,"\nContracts or other agreements with providers may not have to change (although the new framework provides an opportunity for looking at what is commissioned). For instance agreement with providers that the EHC process would be appropriately supported and that information on services would be provided for the Local Offer."]
[]
[null,null,null,"Prompts for Implementation","Key Indicators / Evidence","LA Named Lead","1st Audit RAG Rating: DD/MM/YY","2nd Audit RAG Rating: DD/MM/YY","Trend","Comments/Evidence"]
[null,null,null,"How well does the local authority communicate with the services it commissions on SEND?","The local authority has a mechanism for communication  with providers on SEND\n\nProviders are kept up to date on local  practice relating to SEND",null,"Please Select","Please Select","Please Select"]
[null,null,null,"How are local authorities evidencing that the services they are commissioning are contributing to EHC assessments in a timely way.","Service contracts set out clear expectations which are written into Service specifications",null,"Please Select","Please Select","Please Select"]
[null,null,null,"How are local authorities evidencing that the services they are commissioning are making a positive contribution towards achieving the outcomes identified in a child's EHC Plan.","Data is collected and is used to review provision.\nThere is destination data for children and young people.",null,"Please Select","Please Select","Please Select"]
[]
[null,null,null,"FURTHER INFORMATION:"]
[]
[null,null,null,"M. Gascoigne (2015) Commissioning for Speech Language and Communication Needs. Better Communication Research Programme"]
[null,null,null,"http://www.bettercommunication.org.uk/support-for-commissioners/digest-request/"]
[]
[null,null,null,"Outcomes Based Healthcare & Capsticks (2014) Contracting for Outcomes: A Value Based Approach"]
[null,null,null,"http://outcomesbasedhealthcare.com/Contracting_for_Outcomes.pdf"]
[]
[null,null,null,"Outcomes Based Healthcare (2014) Outcomes myths"]
[null,null,null,"http://outcomesbasedhealthcare.com/portfolio/outcomes-myths/ "]
[]
[null,null,null,"The Health Foundation (2015) Need to nurture: Outcome based commissioning in the NHS"]
[null,null,null,"http://www.health.org.uk/sites/health/files/NeedToNurture_1.pdf"]
[]
[]
[]
[null,null,null,"Personal Budgets"]
[]
[null,null,null,"Additional Notes (press '+' sign to expand)"]
[null,null,null,"\nYoung people and parents of children who have EHC plans have the right to request a Personal Budget, which may contain elements of education, social care and health funding. A Personal Budget is an amount of money identified by a local authority and/or CCG to deliver provision set out in an EHC plan where the parent or young person is involved in securing that provision. The funds can be held directly by the parent or young person, or may be held and managed on their behalf by the local authority, school, college or another organisation or individual and used to commission the support specified in the EHC plan. Partners must set out in their joint commissioning arrangements their arrangements for agreeing Personal Budgets."]
[]
[null,null,null,"Prompts for Implementation","Key Indicators / Evidence","LA Named Lead","1st Audit RAG Rating: DD/MM/YY","2nd Audit RAG Rating: DD/MM/YY","Trend","Comments/Evidence"]
[null,null,null,"Is there a local policy on the use of personal budgets for all children and young people with SEND that has been agreed by the local authority and partners?","There is a local policy that sets out:\n\n- a description of the services across education, health and social care that can be delivered through a Personal Budget           \n\n- clear and simple statements of eligibility criteria for different types of Personal Budgets\n\n- the availability of Personal Budgets in both children and adult services for young people up to the age of 25 across education, health and care.",null,"Please Select","Please Select","Please Select"]
[null,null,null,"Is there a clear pathway for agreeing personal budgets where a parent or young person has requested one as part of an EHC needs assessment or EHC plan?","This pathway for Personal Budgets is on the Local\nOffer\n\nThere is a mechanism for agreeing the scope of a personal budget for a child or young person with an EHC plan  with input from education, health and social care\n\nA child’s parent or the young person is made aware of the scope of Personal Budgets linked to the EHC plan at the earliest possible stage",null,"Please Select","Please Select","Please Select"]
[null,null,null,"Has the local authority developed a market position statement to communicate to the market how it will be rolling out the provision of personal budgets over the next five years?","A market position statement has been produced and disseminated to providers.",null,"Please Select","Please Select","Please Select"]
[]
[null,null,null,"FURTHER INFORMATION:"]
[]
[null,null,null,"NHS England’s information hub on personal budgets: "]
[null,null,null,"http://www.peoplehub.org.uk/ "]
[]
[null,null,null,"For more guidance on personal health budgets, see Guidance on the “right to have” a Personal Health Budget in Adult NHS Continuing Healthcare and Children and Young People’s Continuing Care (September 2014)."]
[null,null,null,"http://www.personalhealthbudgets.england.nhs.uk/_library/Resources/Personalhealthbudgets/2014/Personal_health_budgets_right_to_have_guidance.pdf"]
[]
[null,null,null,"Understanding the Resource Allocation System (RAS). Developing a self-directed support approach to resource allocation for children, young people and families (2013) "]
[null,null,null,"http://www.in-control.org.uk/media/131598/understanding_the_ras%20-%20final%20for%20print.pdf"]
[]
[null,null,null,"Making It Personal 2 is a resource for families and commissioners and providers to support developing personalisation in care, through use of personal budgets.  "]
[null,null,null,"http://www.kids.org.uk/mip2"]
[]
[null,null,null,"The SEND Pathfinder Information Pack - Personal Budgets"]
[null,null,null," http://www.sendpathfinder.co.uk/personal-budget-information"]
[]
[]
[]
[null,null,null,"Designated Medical Officer / Designated Clinical Officer"]
[]
[null,null,null,"Additional Notes (press '+' sign to expand)"]
[null,null,null,"\nA Designated Medical Officer or Clinical Officer (DMO / DCO) should be employed to support the CCG in meeting its statutory responsibilities for children and young people with SEND, primarily by providing a point of contact for local partners, when notifying parents and local authorities about children and young people they believe have, or may have, SEND, and when seeking advice on SEND. The DMO / DCO provides the point of contact for local authorities, schools and colleges seeking health advice on children and young people who may have SEND, and provides a contact (or contacts) for CCGs or health providers so that appropriate notification can be given to the local authority of children under compulsory school age who they think may have SEND. \n\nThe DMO / DCO should have an appropriate level of clinical expertise to enable them to exercise these functions effectively, and should be designated as the DMO / DCO in their job description. There may be one DMO / DCO for several CCGs and local authorities, where there are joint arrangements or shared commissioning responsibilities, and given the age range of EHC plans from birth to 25, the DMO / DCO may need to liaise with colleagues outside paediatrics.\nWhen carried out by a paediatrician the role is a Designated Medical Officer, when undertaken by a nurse or other health professional the role would be a Designated Clinical Office.  Nurses can be dual registered and this can be an advantage when considering the remit of the role from 0-25."]
[]
[null,null,null,"Prompts for Implementation","Key Indicators / Evidence","LA Named Lead","1st Audit RAG Rating: DD/MM/YY","2nd Audit RAG Rating: DD/MM/YY","Trend","Comments/Evidence"]
[null,null,null,"Where there is DMO/DCO in place, the local authority has a close working relationship with the DMO/DCO","The DMO/DCO is involved in strategic decisions around SEND provision\n\nThe DMO/DCO is regularly involved in reviews of EHC assessment processes and plans.\n\nDMO/DCO is known and information about their role is available on the Local Offer ",null,"Please Select","Please Select","Please Select"]
[]
[null,null,null,"FURTHER INFORMATION:"]
[]
[null,null,null,"DMO/DCO Handbook"]
[null,null,null,"https://councilfordisabledchildren.org.uk/help-resources/resources/designated-medical-officer-and-designated-clinical-officer-handbook"]
[]
[null,null,null,"The BACD have published a model job description for a DMO: "]
[null,null,null,"http://www.bacdis.org.uk/policy/documents/DesignatedDrJDforSEND.pdf "]
[]
[null,null,null,"Dr. Karen Horridge, Chair of the BACD has published a presentation capturing the scope of the DMO role in an effective SEND system. "]
[null,null,null,"http://www.bacdis.org.uk/policy/documents/MedicalAdviceforEducation-RecforPaedsBACCHBACD23Sept2014.pdf"]

{"sheet":"4. LA - EHC Plan","index":8,"n_rows":86,"n_cols":10,"rows_kept":86,"cut":false,"hidden":false,"merged":[[6,3,6,9],[59,3,59,9],[29,3,29,9]]}
[]
[null,null,null,"4. Education, Health & Care Plan"]
[]
[null,null,null,"SEN Support and Early Help (Coordinated assessment) "]
[]
[null,null,null,"Additional Notes (press '+' sign to expand)"]
[null,null,null,"\nLocal authorities are responsible for all the children and young people in their area who have or may have SEN (section 24 of the Children and Families Act). This includes children and young people who are receiving SEN support.\n\nLocal authorities have a key role to play in supporting the capacity of education settings to identify and meet the needs of children and young people with SEN, including by providing specialist support to advise them on early identification and effective support and interventions for children receiving SEN support. Settings and the local authority should work closely together to ensure there are clear arrangements accessing specialist support. \n\nLocal authorities also have a key role in helping education settings to develop their offer of support, and have a duty to set out the provision that they expect settings to have available in the Local Offer. This includes agreeing what settings are expected to provide out of their delegated budgets, and when the local authority would expect to provide top-up funding out of the high needs block."]
[]
[null,null,null,"Prompts for Implementation","Key Indicators / Evidence","LA Named Lead","1st Audit RAG Rating: DD/MM/YY","2nd Audit RAG Rating: DD/MM/YY","Trend","Comments/Evidence"]
[null,null,null,"How is the LA working with early years settings/schools/FE settings to develop and promote their offer for CYP with SEN support needs?","The local offer and school SEN offer should clearly articulate the support available to this group of CYP and how it can be accessed. \n\nHow are the needs of a CYP with SEN needs identified and recorded? Is there a person centred plan as part of a graduated pathway?",null,"Please Select","Please Select","Please Select"]
[null,null,null,"How is the LA working with other settings to ensure that the needs of CYP at SEN support level are met within the allocated funding available either within the dedicated support grant or from the high needs block?","Local agreements in place across settings to ensure  access to additional specialist advice from specialist teachers/Educational Psychologists to provide whole school training or advice linked to an individual child's needs when this can’t be met within the individuals schools allocated resources.",null,"Please Select","Please Select","Please Select"]
[null,null,null,"What quality assurance processes are in place to ensure that settings meet their duties under the Equality Act i.e. in making reasonable adjustments?","Settings are physically accessible and there is adequate provision/access to auxiliary aids and services for disabled CYP. \n\nSettings have developed targetted groups for specific needs types e.g. communication/language and sensory impairment.\nThe Local Authority monitors the quality of  School information reports.",null,"Please Select","Please Select","Please Select"]
[null,null,null,"What quality assurance processes are in place to reasssure the LA that suitable provision is in place to meet the needs of CYP at SEN Support level, prior to an application being made for an EHC Needs Assessment?","There is evidence of a clear process based on Assess, Plan, Do, Review and Transition involving specialists. \n\nRobust approach in place around record keeping. \n\nA peer review process in place \n\nPerson centred SEN support plan in place",null,"Please Select","Please Select","Please Select"]
[null,null,null,"Is there a coordinated assessment process that brings together the needs of CYP at SEN Support level with those who are eligible for Early Help?\n\nIs the Early Help Offer aligned with the SEND Local Offer?","There is a graduated support offer with a single point of entry for Early Help and SEN Support or the processes for drawing down provision of support are aligned.",null,"Please Select","Please Select","Please Select"]
[null,null,null,"What arrangements does the LA have in place to promote educational attainment and school improvement relating to CYP at SEN Support level?","Arrangements are in place. These may include workforce training and development; support from school improvement partners; peer review of policies, procedures and educational data linked to key stages and progression. ",null,"Please Select","Please Select","Please Select"]
[]
[null,null,null,"FURTHER INFORMATION:"]
[]
[null,null,null,"Focus on SEND (Free online training for educational practitioners)"]
[null,null,null,"https://councilfordisabledchildren.org.uk/help-resources/resources/focus-send"]
[]
[null,null,null,"SEND Review Guide"]
[null,null,null,"https://councilfordisabledchildren.org.uk/help-resources/resources/send-review"]
[]
[]
[]
[null,null,null,"EHC Needs Assessment (Coordinated Specialist Assessment)"]
[]
[null,null,null,"Additional Notes (press '+' sign to expand)"]
[null,null,null,"\nFollowing a request for an EHC needs assessment, or the child or young person having otherwise been brought to its attention, the local authority must determine whether an EHC needs assessment is necessary. The local authority must make a decision and communicate the decision to the child’s parent or to the young person within 6 weeks of receiving the request. Where the local authority is considering whether an EHC needs\nassessment is necessary, it must notify:\n\n• the child’s parent or the young person\n• the health service (the relevant Clinical Commissioning Group (CCG) or NHS England where it has responsibility for a child or young person)\n• local authority officers responsible for social care for children or young people with SEN\n• the education setting where that child or young person attends\nand social care \n\nIf a local authority decides an EHC needs assessment is necessary it must gather advice from relevant professionals about the child or young person’s education, health and care needs. This includes desired outcomes and special\neducational, health and care provision that may be required to meet identified needs and achieve desired outcomes. This specifically includes: medical advice and information from health care professionals with a role in relation to the child or young person’s health; and social care advice and information from or on behalf of the local authority. The evidence and advice submitted by those providing it should be clear, accessible\nand specific. The local authority may provide guidance about the structure and format of advice and information to be provided."]
[]
[null,null,null,"Prompts for Implementation","Key Indicators / Evidence","LA Named Lead","1st Audit RAG Rating: DD/MM/YY","2nd Audit RAG Rating: DD/MM/YY","Trend","Comments/Evidence"]
[null,null,null,"Are local authority officers responsible for social care and the relevant CCG informed whenever the local authority is considering whether to carry out an EHC needs assessment?","There are named contacts in health and social services who are automatically informed whenever an assessment is being considered \n \nThe effectiveness and timeliness of this process is kept under review",null,"Please Select","Please Select","Please Select"]
[null,null,null,"Is there an induction programme which ensures that new staff in the LA are aware of their responsibilities and roles around contributing to or writing an EHC Plan?","There is an induction programme in place and staff are aware of processes.",null,"Please Select","Please Select","Please Select"]
[null,null,null,"Are education, social care and health practitioners clear about the type of information and advice they are expected to provide as part of the assessment?  ","Training has been provided to social care and health practitioners on providing information and advice, and the local authority has ensured that key personnel are familiar with the format in which advice should be given.\n\nWhere child or young person is not known to health or social care services and there is no evidence of a relevant need this should be clearly articulated with agreed reference to universal services. \n\nThere is an agreed process for monitoring and quality assuring  education, health and social care advice                                                                                                                                     ",null,"Please Select","Please Select","Please Select"]
[null,null,null,"Is there a clear expectation and agreement about when health and social care colleagues will attend multi-agency meetings?","The local authority and the CCG have a criteria setting out when health and social care professionals are required to attend face to face or multiagency planning meetings.",null,"Please Select","Please Select","Please Select"]
[null,null,null,"Is there a process for aligning EHC Planning with LAC assessment and reviews?","Evidence of LAC health and social care teams contributing to an EHC assessment where appropriate.  \nThere are protocols around notification across teams.\nReview processes are aligned.",null,"Please Select","Please Select","Please Select"]
[null,null,null,"Is the timeliness of the provision of health and social care advice satisfactory and are there means of addressing any issues?","There is routine monitoring of the timeliness of health and social care advice \n\nHealth and social care advice is received in time for inclusion in the draft EHC plan sent to parents or young people.\n\nThere is clear accountability at a senior level in the CCG and local authority for ensuring the timeliness of health and social care advice ADVICE IS ROUTINELY GATHERED WITHIN 6 WEEKS",null,"Please Select","Please Select","Please Select"]
[null,null,null,"What arrangements does the LA have in place to promote educational attainment and school improvement relating to CYP with EHC plans?","Arrangements are in place. These may include workforce training and development; support from school improvement partners; peer review of policies, procedures and educational data linked to key stages and progression. ",null,"Please Select","Please Select","Please Select"]
[]
[null,null,null,"FURTHER INFORMATION:"]
[]
[null,null,null,"The role of social care in implementing the Children and Families Act"]
[null,null,null,"https://councilfordisabledchildren.org.uk/sites/default/files/field/attachemnt/socialcare_implementationofcfa2014_online.pdf"]
[]
[null,null,null,"Identifying the social care needs of disabled children and young people and those with SEN as part of Education, health and Care Needs Assessments"]
[null,null,null,"https://councilfordisabledchildren.org.uk/sites/default/files/field/attachemnt/Identifying%20the%20social%20care%20needs_0.pdf"]
[]
[null,null,null,"Social Care and the SEND reforms: Advice on frequently asked questions"]
[null,null,null,"https://councilfordisabledchildren.org.uk/sites/default/files/field/attachemnt/FAQ_Social%20care%20adnthe%20SEND%20reforms.pdf"]
[]
[null,null,null,"The role of Independent Reviewing Officers in Education, Health and Care Needs Assessments and Plans for looked after children and young people with special educational needs."]
[null,null,null,"https://councilfordisabledchildren.org.uk/sites/default/files/field/attachemnt/Role%20of%20the%20IRO.pdf"]
[]
[]
[]
[null,null,null,"Sign Off"]
[]
[null,null,null,"Additional Notes (press '+' sign to expand)"]
[null,null,null,"\nUpon gathering all the relevant information and advice, the local authority must produce a draft EHC plan and send the draft (including the appendices containing the advice and information gathered during the EHC needs assessment) to the child’s parent or to the young person and give them at least 15 days to give views and make representations on the content. The health care provision specified in section G of the EHC plan must be agreed by the CCG (or where relevant, NHS England) and any health care provision should be agreed in time to be included in the draft EHC plan sent to the child’s parent or to the young person. As part of the joint commissioning arrangements, partners must have clear disagreement resolution procedures where there is disagreement on the services to be included in an EHC plan."]
[]
[null,null,null,"Prompts for Implementation","Key Indicators / Evidence","LA Named Lead","1st Audit RAG Rating: DD/MM/YY","2nd Audit RAG Rating: DD/MM/YY","Trend","Comments/Evidence"]
[null,null,null,"Are social care teams and the CCG/relevant health professionals given the opportunity to agree to the content of the draft EHC plan before it is sent to parents or young people?","Is there a named contact in the social care team who signs off provision ",null,"Please Select","Please Select","Please Select"]
[null,null,null,"Is there a well developed sign off process for including children's social care provision in the draft or final EHC plan?","There is an agreed and  documented process\n\nThere a named contact in the social care team who coordinates signing off provision \n\nThe timeliness of the sign off allows the local authority to meet its 20 week statutory timescales for issuing a plan ",null,"Please Select","Please Select","Please Select"]
[null,null,null,"Is there a well developed sign off process for including adult social care provision in the draft or final EHC plan?","There is an agreed and  documented process\n\nThere is a named contact in the social care team who coordinates the signing off provision \n\nThe timeliness of the sign off allows the local authority to meet it statutory timescales for issuing a plan There is a Child's Needs Assessment  (under the Care Act) from age 14",null,"Please Select","Please Select","Please Select"]
[null,null,null,"Is there a well developed sign off process with the CCG for including health care provisions in the draft or final EHC plan?","There is an agreed and  documented process\n\nThere is a named contact in the CCG who coordinates signing off provision \n\nThe timeliness of the sign off allows the local authority to meet it statutory timescales for issuing a plan",null,"Please Select","Please Select","Please Select"]
[null,null,null,"Is there a clear process for ensuring that EHC plan outcomes are SMART?","Outcomes in EHC plans are SMART\n\nEHC Plan outcomes are monitored for progress and achievement \n\nMechanisms are in place to capture progress towards meeting outcomes in EHC plans by setting or LA \n\nDestination data is collected to demonstrate impact achieving outcomes in EHC plans",null,"Please Select","Please Select","Please Select"]
[null,null,null,"Are there arrangements in place to ensure that CYP and parent/carers have coproduced the EHC plan and have been engaged in every stage of its development?","A clear and transparent policy and procedure for promoting coproduction \n\nEHC plans are person-centred and the voice of the CYP is clear. \n\nDisputes over EHC plans are resolved informally without the need for formal mediation.",null,"Please Select","Please Select","Please Select"]
[null,null,null,"How can the LA demonstrate that there is a consistent approach to the sign off of EHC plans that is aligned to current joint commissioning arrangements?","Joint commissioning arrangements clearly define roles and responsibilities of providers and commissioners in ensuring timely sign off of EHC plans including sign off by professionals who provide advice ",null,"Please Select","Please Select","Please Select"]
[null,null,null,"Are there arrangements in place for resolving disputes about the content of EHC plans between local authorities and CCGs?","The local authority have an agreed approach to resolving disputes about the health and social care content of EHC plans\n\nDisputes are resolved in a timely manner that allow the local authority to meet its statutory timescales for issuing a plan",null,"Please Select","Please Select","Please Select"]
[]
[null,null,null,"FURTHER INFORMATION:"]
[]
[null,null,null,"Nottinghamshire County Council’s EHC plan animation: "]
[null,null,null,"https://www.youtube.com/watch?v=3zf8BgtMKsg"]
[]
[null,null,null,"The British Academy of Childhood Disability has developed detailed guidelines for professionals who are asked to contribute to an EHC plan: "]
[null,null,null,"http://www.bacdis.org.uk/policy/documents/MedicalAdviceforEducation-RecforPaedsBACCHBACD23Sept2014.pdf"]
[]
[null,null,null,"NB. DH is developing guidance for health services on responding to requests for information on a child’s health, for the EHC plan assessment process. "]
[]
[null,null,null,"The SEND Pathfinder Information Pack - Coordinated Assessment Process and Education, Health and Care (EHC) Plan:"]
[null,null,null,"http://www.sendpathfinder.co.uk/coordinated-assessment-process"]
[]
[null,null,null,"A step-by-step guide to EHC plans "]
[null,null,null,"https://councilfordisabledchildren.org.uk/help-resources/resources/step-step-guide-ehc-plans"]

{"sheet":"5. LA - Co-Production","index":9,"n_rows":52,"n_cols":10,"rows_kept":52,"cut":false,"hidden":false,"merged":[[6,3,6,9]]}
[]
[null,null,null,"5. Co-production (Engagement)"]
[]
[null,null,null,"Children, Young People and Parents"]
[]
[null,null,null,"Additional Notes (press '+' sign to expand)"]
[null,null,null,"\nSection 19 requires local authorities to have regard to a set of core principles when carrying out their functions under Part 3 of the Children and Families Act 2014. When they are undertaking any function under Part 3 of the Children and Families Act, local authorities must have regard to:\n\n• the views, wishes and feelings of children and their parents, or the young person;\n• the importance of the child and their parents, or the young person, participating as fully as possible in decisions;\n• the importance of the child and their parents, or the young person, being provided with the information and support they need in order to participate in decision-making; \n• the need to support parents, children and young people so that children and young people achieve the best possible educational and other outcomes\n\nThese considerations must be applied at both the strategic commissioning and the individual level. In addition to Section 19, the local authority must involve and consult children, parents and young people specifically when reviewing the education, social care and training provision on offer in the local area (Section 27) and developing and reviewing the Local Offer (Section 30)."]
[]
[null,null,null,"Prompts for Implementation","Key Indicators / Evidence","LA Named Lead","1st Audit RAG Rating: DD/MM/YY","2nd Audit RAG Rating: DD/MM/YY","Trend","Comments/Evidence"]
[null,null,null,"Is the Parent Carer Forum (or equivalent group) and wider group of parents involved at all stages in the planning, delivery and monitoring of services?","Evidence can be provided as to how the local authority responds to feedback from engagement in its policies, particularly in relation to commissioning.\n\nThe input of parent groups is recognised, valued, planned and resourced (for example, through appropriate remuneration and training)\n\nThere are strong feedback mechanisms to ensure that parents understand the impact their participation is making",null,"Please Select","Please Select","Please Select"]
[null,null,null,"How confident are you that parents not involved in a parent carer forum are involved in the planning, delivery and monitoring of services?","Evidence can be provided as to how parents who are not involved in parent carer forums are involved and have the opportunity to comment on service delivery",null,"Please Select","Please Select","Please Select"]
[null,null,null,"Are children, parents and young people involved in reviewing the services on offer?","There are a range of robust, meaningful and accessible processes and opportunities for children and young people to review local service provision",null,"Please Select","Please Select","Please Select"]
[null,null,null,"Does the Local authority take steps to involve other harder to reach groups of parents?","There is a strategy in place to consult and involve parents who are not members of the Parent Carer Forum (or equivalent group)\n\nThere are a range of ways that parents can contribute their views",null,"Please Select","Please Select","Please Select"]
[null,null,null,"Does the local authority have a mechanism for routinely and directly involving children and young people in decisions about services, separately from parents?","There is a forum, or a range of forums, where children and young people with SEND can be directly consulted and involved in planning \n",null,"Please Select","Please Select","Please Select"]
[null,null,null,"Does the local authority have a mechanism for engaging the widest possible group of children and young people in development, impelementation and review of its implementation strategy?","The strategy recognises the need to provide a range of methods for children and young people to be involved\n\nEngagement opportunities are made accessible to children and young people with a range of SEN and disabilities, including those with cognitive or communication impairments ",null,"Please Select","Please Select","Please Select"]
[null,null,null,"Does the local authority have a strategy for engaging children and young people who are placed or educated outside the local area?","The local authority actively seeks the views of children and young people for whom they are responsible but are placed outside of the local area, including:\n\n- those in the youth justice system\n- those placed in residential schools or colleges\n- those fostered in another local authority",null,"Please Select","Please Select","Please Select"]
[null,null,null,"Are children, young people and parents able to access an Information, Advice and Support service that enables them to participate fully in local discussions? ","There is an IASS that encourages and supports children, their parents and young people to participate in local discussions\n\nThe IASS works closely with Parent Carer Forum (or equivalent group) to ensure the experience of children, their parents and young people inform policy, practice and commissioning decisions ",null,"Please Select","Please Select","Please Select"]
[]
[null,null,null,"FURTHER INFORMATION:"]
[]
[null,null,null,"SEND: Experiences with schools and colleges"]
[null,null,null,"https://www.gov.uk/government/uploads/system/uploads/attachment_data/file/564348/SEND_experiences_with_schools_and_colleges.pdf"]
[]
[null,null,null,"Top tips from children and young people about how to involve them in their social care assessment"]
[null,null,null,"https://councilfordisabledchildren.org.uk/sites/default/files/field/attachemnt/Postcard%20Involving%20dcyp%20in%20assessment%20Final%20online.pdf"]
[]
[null,null,null,"Your Rights, Your Future Toolkits and other participation and coproduction resources:"]
[null,null,null,"https://councilfordisabledchildren.org.uk/making-ourselves-heard/resources"]
[]
[null,null,null,"Engagement and Participation Information Pack"]
[null,null,null,"http://www.sendpathfinder.co.uk/engagement-and-participation-information-pack"]
[]
[null,null,null,"A guide to co-producing children’s services"]
[null,null,null,"https://www.actionforchildren.org.uk/media/3255/a_guide_to_coproducing_childrens_services.pdf"]
[]
[null,null,null,"An introduction to co-production"]
[null,null,null,"http://www.changingourlives.org/wp-content/uploads/2016/10/CoproIntro.pdf"]
[]
[null,null,null,"What does good co-production look like?"]
[null,null,null,"https://blog.scope.org.uk/2015/01/18/what-does-good-co%E2%80%91production-look-like/"]
[]
[null,null,null,"Supported Decision Making"]
[null,null,null,"http://www.preparingforadulthood.org.uk/media/380898/pfa_factsheet_-_mca-cb_final_versions_3-12.pdf"]
[]
[null,null,null,"Transforming culture and practice in social care"]
[null,null,null,"https://councilfordisabledchildren.org.uk/help-resources/resources/transforming-culture-and-practice-social-care"]
[]
[null,null,null,"Transforming Participation in the NHS"]
[null,null,null,"https://www.england.nhs.uk/wp-content/uploads/2013/09/trans-part-hc-guid1.pdf"]
[]
[null,null,null,"National Network of Parent Carer Forum"]
[null,null,null,"http://www.nnpcf.org.uk/"]

{"sheet":"6. LA - Monitor & Redress","index":10,"n_rows":93,"n_cols":10,"rows_kept":93,"cut":false,"hidden":false,"merged":[[62,3,62,9],[79,3,79,9],[6,3,6,9],[22,3,22,9]]}
[]
[null,null,null,"6. Monitoring & Redress"]
[]
[null,null,null,"Data to Monitor Progress"]
[]
[null,null,null,"Additional Notes (press '+' sign to expand)"]
[null,null,null,"\nEffective implementation can only be ensured through appropriate monitoring of the joint commissioning arrangements between CCG and local authority, of the process for developing individual EHC plans, and the success of the plans in delivering the outcomes specified for the child or young person. Local authorities and CCGs will need to identify and collect its own dataset of indicators of effective implementation and improved outcomes, covering both process measures, and health and wellbeing outcomes for the child or young person. Engagement with children, young people and their families will allow evidence of the user-reported experience to inform a view of implementation."]
[]
[null,null,null,"Prompts for Implementation","Key Indicators / Evidence","LA Named Lead","1st Audit RAG Rating: DD/MM/YY","2nd Audit RAG Rating: DD/MM/YY","Trend","Comments/Evidence"]
[null,null,null,"Does the local authority use robust data and evidence to monitor progress towards successful implementation of SEND arrangements? \n\n\n","The local authority produces regular performance reports using a range of agreed outcome indicators , and reflects on their implications. \n\nThe range of evidence considered includes: \n- quality of engagement with children, parents and young \n- progress on individual EHC plans; \n- improvements in health and wellbeing outcomes for children and young people with SEND",null,"Please Select","Please Select","Please Select"]
[null,null,null,"Does the local authority consider potential gaps in data and evidence and whether new collections might be necessary\n   ","The local authority has mapped existing data sources and made a judgement about the sufficiency\n\nThe local authority is proactively pursuing additional data sources and evidence that would aid its understanding\n\nThe local authority has a data development programme.",null,"Please Select","Please Select","Please Select"]
[null,null,null,"Has the local authority benchmarked its data on the implementation of the SEND reforms against its statistical neighbours?","Authorities can show they compare and what implementation plan they have to deal with any significant variation?",null,"Please Select","Please Select","Please Select"]
[]
[null,null,null,"FURTHER INFORMATION:"]
[]
[null,null,null,"See Monitoring and Agreeing Plans: Further information"]
[]
[]
[]
[null,null,null,"Data Sharing"]
[]
[null,null,null,"Additional Notes (press '+' sign to expand)"]
[null,null,null,"\nInformation sharing is vital to support an effective assessment and planning process which fully identifies needs and outcomes and the education, health and care provision needed by the child or young person. Local authorities with their partners should establish local protocols for the effective sharing of information which addresses confidentiality, consent and security of information."]
[]
[null,null,null,"Prompts for Implementation","Key Indicators / Evidence","LA Named Lead","1st Audit RAG Rating: DD/MM/YY","2nd Audit RAG Rating: DD/MM/YY","Trend","Comments/Evidence"]
[null,null,null,"Is there a protocol to enable the NHS to comply with its duty to inform the authority that it has identified a child who has or who is likely to have SEND","The protocol is in place and being implemented",null,"Please Select","Please Select","Please Select"]
[null,null,null,"Is there a local protocol for the sharing of information which addresses confidentiality, consent and security of information","Staff and trained and understand how to share information safely; e.g. the use of secure email.",null,"Please Select","Please Select","Please Select"]
[null,null,null,"Does the local authority discuss with the child/young person and their parents what information they are happy for the local authority to share with other agencies. ","Details of this conversation recorded ",null,"Please Select","Please Select","Please Select"]
[null,null,null,"Is there a specific information sharing protocol in place with the Youth Offending Team  where a child or young Person with an EHC plan is in, or at risk of entering, custody","The  protocol sets out how checks will be made about whether a child or young person known to the YOT has an EHC plan \n\nThe protocol sets out how an EHC plan will be transferred to the secure estate when a child or young person is  sentenced or remanded into custody",null,"Please Select","Please Select","Please Select"]
[]
[null,null,null,"FURTHER INFORMATION:"]
[]
[null,null,null,"The revised Caldicott Principles:"]
[null,null,null,"http://informationsharing.org.uk/wp-content/uploads/2016/05/Caldicott-principles.pdf "]
[]
[null,null,null,"A guide to confidentiality in health and social care. Treating confidential information with respect (HSCIC, 2013). "]
[null,null,null,"http://www.hscic.gov.uk/media/12822/Guide-to-confidentiality-in-health-and-social-care/pdf/HSCIC-guide-to-confidentiality.pdf"]
[]
[null,null,null,"Information Sharing: Advice for practitioners providing safeguarding services to children, young people, parents and carers (HM Government, 2015)."]
[null,null,null,"https://www.gov.uk/government/uploads/system/uploads/attachment_data/file/419628/Information_sharing_advice_safeguarding_practitioners.pdf"]
[]
[null,null,null,"NHS England’s Healthy Children: transforming child health information"]
[null,null,null,"https://www.england.nhs.uk/wp-content/uploads/2016/11/healthy-children-transforming-child-health-info.pdf"]
[]
[null,null,null,"Further resources to support safe and effective information sharing can be found at the Centre for Excellence for Information Sharing"]
[null,null,null,"http://informationsharing.org.uk/"]
[null,null,null,"and the Information Governance Alliance"]
[null,null,null,"http://systems.hscic.gov.uk/infogov/iga"]
[null,null,null,"For a step-by-step guide for senders in the NHS using NHSmail see Sending an encrypted email from NHSmail to a non-secure email address (January, 2015)"]
[null,null,null,"http://systems.hscic.gov.uk/nhsmail/secure/senders.pdf "]
[]
[null,null,null,"For recipients, see Guidance for recipients of an encrypted NHSmail email (January, 2015)"]
[null,null,null,"http://systems.hscic.gov.uk/nhsmail/secure/recipients.pdf "]
[]
[null,null,null,"Further information on the encryption feature in general can be found at:"]
[null,null,null,"http://systems.hscic.gov.uk/nhsmail/secure"]
[]
[]
[]
[null,null,null,"Disagreement Resolution and Complaints"]
[]
[null,null,null,"Additional Notes (press '+' sign to expand)"]
[null,null,null,"\nLocal authorities are required to hear complaints about the way they provide services or the decision they make. They must include information about how to make complaints about other services in  the Local Offer.\n\nLocal authorities must make disagreement resolution services available to parents and young people. Use of the disagreement resolution services is voluntary and has to be with the agreement of all parties. The service, while commissioned by it, must be independent of the local authority – no-one who is directly employed by a local authority can provide disagreement resolution services. Parents and young people can also access informal support in resolving disagreements through the local impartial Information, Advice and Support Service and, between 2014 and 2016, with the help of Independent Supporters. Local authorities must make the availability of disagreement resolution services known to parents, young people, head teachers, governing bodies, proprietors and principals of schools and post-16 institutions in their areas and should make them known to others they think appropriate. Details of the disagreement resolution arrangements must be set out in the Local Offer."]
[]
[null,null,null,"Prompts for Implementation","Key Indicators / Evidence","LA Named Lead","1st Audit RAG Rating: DD/MM/YY","2nd Audit RAG Rating: DD/MM/YY","Trend","Comments/Evidence"]
[null,null,null,"Does the local authority have a robust policy for handling complaints about its own SEND responsibilities?   \n\n\n ","The Local Offer is clear about the type of complaints the local authority can handle in relation to SEND and the possible outcomes of making a complaint\n\nComplaints are dealt with in a timely manner and in line with the complaints policy\n\nThe local authority monitors complaints relevant to SEND, and has a mechanism for reflecting on / acting on issues raised",null,"Please Select","Please Select","Please Select"]
[null,null,null,"Does the local authority provide information to parents and young people about how to complain about services? ","The Local Offer includes information about how to complain about the services listed there",null,"Please Select","Please Select","Please Select"]
[null,null,null,"Is there a functioning and effective disagreement resolution service in place for  parents and young people to use across education, health and social care? ","There are clear funding and budgeting plans for the service\n\nThe local authority is satisfied that those providing the service have appropriate skills in disagreement resolution\nand an understanding of SEN processes, procedures and\nlegislation\n\nParents and young people are routinely informed about the availability of the disagreement resolution service and their satisfaction monitored",null,"Please Select","Please Select","Please Select"]
[null,null,null,"Has the local authority and the CCG agreed a common framework for handling complaints relating to SEND across education, health and social care? ","There is a consistent approach to handling complaints about SEND provision that has been agreed by the local authority and the CCG\n\nThe nature, frequency and outcomes from complaints are shared across services in order to address common problems \n\nCCG and local authority have a single point for making complaints in relation to an EHC plan (which could be via the local authority).",null,"Please Select","Please Select","Please Select"]
[]
[null,null,null,"FURTHER INFORMATION:"]
[]
[null,null,null,"See Mediation: Further resources"]
[]
[]
[]
[null,null,null,"Mediation"]
[]
[null,null,null,"Additional Notes (press '+' sign to expand)"]
[null,null,null,"\nMediation is a statutory service commissioned by local authorities which is designed to help settle disagreements between parents or young people and local authorities over EHC needs assessments and plans.\n\nWhen the local authority sends the parent or young person notice of a decision which can be appealed to the Tribunal it must tell the parent or young person of their right to go to mediation and that they must contact a mediation adviser before registering an appeal with the Tribunal. The adviser will provide information on mediation and answer any questions which the parent or young person may have about pursuing mediation. The information will normally be provided on the telephone, although information can be provided in written form, through face-to-face meetings or through other means. If the parent or young person decides to proceed with mediation then the local authority must ensure that a mediation session takes place, although it may delegate the arrangement of the session to the mediator. The local authority must attend the mediation and the mediator must be independent of the local authority.\n\nParents and young people can also go to mediation about the health and social care elements of an EHC plan. However, unlike matters which can be appealed to the Tribunal, parents and young people do not have to receive mediation advice before going to mediation.  If the parent or young person only wants to appeal about the health care aspect of the plan then the responsible health commissioning body or bodies must arrange for mediation between them and the parent or young person, and ensure that the mediation is conducted by an independent person. If the mediation includes education or social care matters the local authority must arrange the mediation."]
[]
[null,null,null,"Prompts for Implementation","Key Indicators / Evidence","LA Named Lead","1st Audit RAG Rating: DD/MM/YY","2nd Audit RAG Rating: DD/MM/YY","Trend","Comments/Evidence"]
[null,null,null,"What arrangements are in place to promote an early ethos to resolving conflicts? ","Policies and procedures clearly define roles and responsibilities around actively engaging with parents and young people to ensure any dispute is identified and resolved at the earliest opportunity \n\nNeed for formal mediation is reduced",null,"Please Select","Please Select","Please Select"]
[null,null,null,"Has the local authority made arrangements for parents and young people to access independent mediation advice?","\nThe local authority has a contract or other supply arrangements in place with an independent provider.\n",null,"Please Select","Please Select","Please Select"]
[null,null,null,"Does the local authority quality assure the mediation advice?","The local authority has satisfied itself that the mediation advice:\n- is accurate and unbiased\n- does not pressure parents or young people into taking a particular course of action\n\nThe local authority asks parents and young people about their experiences of mediation advice",null,"Please Select","Please Select","Please Select"]
[null,null,null,"Has the local authority made arrangements for parents and young people to access independent mediation?","The local authority has a contract or other supply arrangements in place with an independent provider.",null,"Please Select","Please Select","Please Select"]
[null,null,null,"Does the local authority quality assure the mediation service?","Mediation sessions are arranged at a place and a time which is convenient for the parties \n\nThe local authority is satisfied  that mediators have sufficient knowledge of the legislation relating to SEN, health and social care to be able to conduct the mediation\n\nThe local authority asks parents and young people about their experiences of mediation ",null,"Please Select","Please Select","Please Select"]
[null,null,null,"How does the LA ensure key lessons from tribunal cases are learnt and used to inform and amend practice?","Key messages from tribunals and feedback from parents is used to inform policy and practice in relation to SEND.",null,"Please Select","Please Select","Please Select"]
[]
[null,null,null,"FURTHER INFORMATION:"]
[]
[null,null,null,"KIDS Regional Mediation Services"]
[null,null,null,"http://www.kids.org.uk/regional-mediation"]