{"text_format":"1","workbook":"xlsx","n_sheets":10,"sheets":["Information","Data","Calc","LA - mapping","Summary SC","1. Leadership","2. Joint Arrangements","3. Commissioning","4. EHC Plan","5. Co-Production"],"not_rendered":{"charts":24,"images":3,"macros":1,"external_links":0,"defined_names":6,"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":26,"n_cols":4,"rows_kept":26,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[null,null,null,"INTRODUCTION"]
[]
[]
[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 closely together 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,"Person centred approaches, a focus on outcomes, choice and control and effective joint working across services are crucial to support effective decision making and should underpin processes for identifying and assessing the social care needs of children and young people. The children’s social care workforce needs to be clear on their roles and responsibilities, have sound knowledge of law and guidance and foster professional relationships across services to ensure effective coordination of social care support and high quality advice in EHC plans, as well as across all services."]
[]
[]
[null,null,null,"The Tool"]
[]
[null,null,null,"The purpose of the tool is to support local authorities in ensuring effective implementation of statutory duties in part 3 of the Children and Families Act 2014 related to social care. This tool has been developed by CDC and is designed to sit alongside the suite of audit tools available here: "]
[null,null,null,"https://councilfordisabledchildren.org.uk/help-resources/resources/audit-tools-hub"]
[null,null,null,"The tool pulls together in one place the key pieces of evidence that an LA will wish to assure itself on and aims to give a high-level overview of its progress. The questions are divided into 5 of the key areas of an LA’s role in supporting children and young people with SEND."]
[]
[null,null,null,"The tool presents this information in an easily accessible “at a glance” RAG review 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,"You can access the full suite of CDC Audit tools at the CDC Audit Tool hub: "]
[null,null,null,"https://councilfordisabledchildren.org.uk/help-resources/resources/audit-tools-hub"]

{"sheet":"Data","index":1,"n_rows":49,"n_cols":10,"rows_kept":49,"cut":false,"hidden":true,"merged":[]}
["m1","Section","Section_ID","Sub-Section","SS_ID","Q","Audit1","Audit2","Audit1_Score","Audit2_Score"]
[null,"1. Leadership",1,"Governance and Leadership",1.1000000000000001,1,{"$f":"'1. Leadership'!G7","v":"Please Select"},{"$f":"'1. Leadership'!H7","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}]
[null,"1. Leadership",1,"Governance and Leadership",1.1000000000000001,2,{"$f":"'1. Leadership'!G8","v":"Please Select"},{"$f":"'1. Leadership'!H8","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}]
[null,"1. Leadership",1,"Governance and Leadership",1.1000000000000001,3,{"$f":"'1. Leadership'!G9","v":"Please Select"},{"$f":"'1. Leadership'!H9","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}]
[null,"1. Leadership",1,"Governance and Leadership",1.1000000000000001,4,{"$f":"'1. Leadership'!G10","v":"Please Select"},{"$f":"'1. Leadership'!H10","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}]
[null,"1. Leadership",1,"Monitoring and Agreeing Plans",1.2,1,{"$f":"'1. Leadership'!G17","v":"Please Select"},{"$f":"'1. Leadership'!H17","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}]
[null,"1. Leadership",1,"Monitoring and Agreeing Plans",1.2,2,{"$f":"'1. Leadership'!G18","v":"Please Select"},{"$f":"'1. Leadership'!H18","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}]
[null,"1. Leadership",1,"Resourcing Joint Arrangements",1.3,1,{"$f":"'1. Leadership'!G25","v":"Please Select"},{"$f":"'1. Leadership'!H25","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}]
[null,"1. Leadership",1,"Resourcing Joint Arrangements",1.3,2,{"$f":"'1. Leadership'!G26","v":"Please Select"},{"$f":"'1. Leadership'!H26","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}]
[null,"1. Leadership",1,"Thresholds and Eligibility Criteria",1.4,1,{"$f":"'1. Leadership'!G33","v":"Please Select"},{"$f":"'1. Leadership'!H33","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}]
[null,"1. Leadership",1,"Thresholds and Eligibility Criteria",1.4,2,{"$f":"'1. Leadership'!G34","v":"Please Select"},{"$f":"'1. Leadership'!H34","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}]
[null,"2. Joint Arrangements",2,"Working Together",2.1,1,{"$f":"'2. Joint Arrangements'!G7","v":"Please Select"},{"$f":"'2. Joint Arrangements'!H7","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}]
[null,"2. Joint Arrangements",2,"Working Together",2.1,2,{"$f":"'2. Joint Arrangements'!G8","v":"Please Select"},{"$f":"'2. Joint Arrangements'!H8","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}]
[null,"2. Joint Arrangements",2,"Working Together",2.1,3,{"$f":"'2. Joint Arrangements'!G9","v":"Please Select"},{"$f":"'2. Joint Arrangements'!H9","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}]
[null,"2. Joint Arrangements",2,"Working Together",2.1,4,{"$f":"'2. Joint Arrangements'!G10","v":"Please Select"},{"$f":"'2. Joint Arrangements'!H10","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}]
[null,"2. Joint Arrangements",2,"Local Offer",2.2000000000000002,1,{"$f":"'2. Joint Arrangements'!G17","v":"Please Select"},{"$f":"'2. Joint Arrangements'!H17","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}]
[null,"2. Joint Arrangements",2,"Local Offer",2.2000000000000002,2,{"$f":"'2. Joint Arrangements'!G18","v":"Please Select"},{"$f":"'2. Joint Arrangements'!H18","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}]
[null,"2. Joint Arrangements",2,"Local Offer",2.2000000000000002,3,{"$f":"'2. Joint Arrangements'!G19","v":"Please Select"},{"$f":"'2. Joint Arrangements'!H19","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}]
[null,"2. Joint Arrangements",2,"Local Offer",2.2000000000000002,4,{"$f":"'2. Joint Arrangements'!G20","v":"Please Select"},{"$f":"'2. Joint Arrangements'!H20","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}]
[null,"2. Joint Arrangements",2,"Local Offer",2.2000000000000002,5,{"$f":"'2. Joint Arrangements'!G21","v":"Please Select"},{"$f":"'2. Joint Arrangements'!H21","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}]
[null,"2. Joint Arrangements",2,"Local Offer",2.2000000000000002,6,{"$f":"'2. Joint Arrangements'!G22","v":"Please Select"},{"$f":"'2. Joint Arrangements'!H22","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}]
[null,"2. Joint Arrangements",2,"Workforce Development",2.2999999999999998,1,{"$f":"'2. Joint Arrangements'!G29","v":"Please Select"},{"$f":"'2. Joint Arrangements'!H29","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}]
[null,"2. Joint Arrangements",2,"Workforce Development",2.2999999999999998,2,{"$f":"'2. Joint Arrangements'!G30","v":"Please Select"},{"$f":"'2. Joint Arrangements'!H30","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}]
[null,"2. Joint Arrangements",2,"Workforce Development",2.2999999999999998,3,{"$f":"'2. Joint Arrangements'!G31","v":"Please Select"},{"$f":"'2. Joint Arrangements'!H31","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}]
[null,"2. Joint Arrangements",2,"Workforce Development",2.2999999999999998,4,{"$f":"'2. Joint Arrangements'!G32","v":"Please Select"},{"$f":"'2. Joint Arrangements'!H32","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}]
[null,"3. Commissioning",3,"Assessing Local Needs",3.1,1,{"$f":"'3. Commissioning'!G7","v":"Please Select"},{"$f":"'3. Commissioning'!H7","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}]
[null,"3. Commissioning",3,"Assessing Local Needs",3.1,2,{"$f":"'3. Commissioning'!G8","v":"Please Select"},{"$f":"'3. Commissioning'!H8","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}]
[null,"3. Commissioning",3,"Assessing Local Needs",3.1,3,{"$f":"'3. Commissioning'!G9","v":"Please Select"},{"$f":"'3. Commissioning'!H9","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}]
[null,"3. Commissioning",3,"Affordability and Demand",3.2,1,{"$f":"'3. Commissioning'!G16","v":"Please Select"},{"$f":"'3. Commissioning'!H16","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}]
[null,"3. Commissioning",3,"Affordability and Demand",3.2,2,{"$f":"'3. Commissioning'!G17","v":"Please Select"},{"$f":"'3. Commissioning'!H17","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}]
[null,"3. Commissioning",3,"Affordability and Demand",3.2,3,{"$f":"'3. Commissioning'!G18","v":"Please Select"},{"$f":"'3. Commissioning'!H18","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}]
[null,"3. Commissioning",3,"Contracts",3.3,1,{"$f":"'3. Commissioning'!G25","v":"Please Select"},{"$f":"'3. Commissioning'!H25","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}]
[null,"3. Commissioning",3,"Personal Budgets",3.4,1,{"$f":"'3. Commissioning'!G32","v":"Please Select"},{"$f":"'3. Commissioning'!H32","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}]
[null,"3. Commissioning",3,"Personal Budgets",3.4,2,{"$f":"'3. Commissioning'!G33","v":"Please Select"},{"$f":"'3. Commissioning'!H33","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}]
[null,"4. EHC Plan",4,"SEN Support and Early Help",4.0999999999999996,1,{"$f":"'4. EHC Plan'!G7","v":"Please Select"},{"$f":"'4. EHC Plan'!H7","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}]
[null,"4. EHC Plan",4,"SEN Support and Early Help",4.0999999999999996,2,{"$f":"'4. EHC Plan'!G8","v":"Please Select"},{"$f":"'4. EHC Plan'!H8","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}]
[null,"4. EHC Plan",4,"SEN Support and Early Help",4.0999999999999996,3,{"$f":"'4. EHC Plan'!G9","v":"Please Select"},{"$f":"'4. EHC Plan'!H9","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}]
[null,"4. EHC Plan",4,"SEN Support and Early Help",4.0999999999999996,4,{"$f":"'4. EHC Plan'!G10","v":"Please Select"},{"$f":"'4. EHC Plan'!H10","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}]
[null,"4. EHC Plan",4,"EHC Needs and Assessment",4.2,1,{"$f":"'4. EHC Plan'!G17","v":"Please Select"},{"$f":"'4. EHC Plan'!H17","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}]
[null,"4. EHC Plan",4,"EHC Needs and Assessment",4.2,2,{"$f":"'4. EHC Plan'!G18","v":"Please Select"},{"$f":"'4. EHC Plan'!H18","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}]
[null,"4. EHC Plan",4,"EHC Needs and Assessment",4.2,3,{"$f":"'4. EHC Plan'!G19","v":"Please Select"},{"$f":"'4. EHC Plan'!H19","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}]
[null,"4. EHC Plan",4,"EHC Needs and Assessment",4.2,4,{"$f":"'4. EHC Plan'!G20","v":"Please Select"},{"$f":"'4. EHC Plan'!H20","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}]
[null,"4. EHC Plan",4,"EHC Needs and Assessment",4.2,5,{"$f":"'4. EHC Plan'!G21","v":"Please Select"},{"$f":"'4. EHC Plan'!H21","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}]
[null,"4. EHC Plan",4,"Sign Off",4.3,1,{"$f":"'4. EHC Plan'!G28","v":"Please Select"},{"$f":"'4. EHC Plan'!H28","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}]
[null,"4. EHC Plan",4,"Sign Off",4.3,2,{"$f":"'4. EHC Plan'!G29","v":"Please Select"},{"$f":"'4. EHC Plan'!H29","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}]
[null,"4. EHC Plan",4,"Sign Off",4.3,3,{"$f":"'4. EHC Plan'!G30","v":"Please Select"},{"$f":"'4. EHC Plan'!H30","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}]
[null,"5. Co-Production",5,"Working in Partnership With Children and Families",5.0999999999999996,1,{"$f":"'5. Co-Production'!G7","v":"Please Select"},{"$f":"'5. Co-Production'!H7","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}]
[null,"5. Co-Production",5,"Working in Partnership With Children and Families",5.0999999999999996,2,{"$f":"'5. Co-Production'!G8","v":"Please Select"},{"$f":"'5. Co-Production'!H8","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}]
[null,"5. Co-Production",5,"Working in Partnership With Children and Families",5.0999999999999996,3,{"$f":"'5. Co-Production'!G9","v":"Please Select"},{"$f":"'5. Co-Production'!H9","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}]

{"sheet":"Calc","index":2,"n_rows":29,"n_cols":23,"rows_kept":29,"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!$D$1:$D$49,Calc!C6,Data!$C$1:$C$49,Calc!B6)","v":4},{"$f":"COUNTIFS(Data!$D$1:$D$49,Calc!$C6,Data!$C$1:$C$49,Calc!$B6,Data!$I$1:$I$49,Calc!E$4)","v":0},{"$f":"COUNTIFS(Data!$D$1:$D$49,Calc!$C6,Data!$C$1:$C$49,Calc!$B6,Data!$I$1:$I$49,Calc!F$4)","v":0},{"$f":"COUNTIFS(Data!$D$1:$D$49,Calc!$C6,Data!$C$1:$C$49,Calc!$B6,Data!$I$1:$I$49,Calc!G$4)","v":0},{"$f":"COUNTIFS(Data!$D$1:$D$49,Calc!$C6,Data!$C$1:$C$49,Calc!$B6,Data!$I$1:$I$49,Calc!H$4)","v":4},{"$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!$D$1:$D$49,Calc!$C6,Data!$C$1:$C$49,Calc!$B6,Data!$J$1:$J$49,Calc!O$4)","v":0},{"$f":"COUNTIFS(Data!$D$1:$D$49,Calc!$C6,Data!$C$1:$C$49,Calc!$B6,Data!$J$1:$J$49,Calc!P$4)","v":0},{"$f":"COUNTIFS(Data!$D$1:$D$49,Calc!$C6,Data!$C$1:$C$49,Calc!$B6,Data!$J$1:$J$49,Calc!Q$4)","v":0},{"$f":"COUNTIFS(Data!$D$1:$D$49,Calc!$C6,Data!$C$1:$C$49,Calc!$B6,Data!$J$1:$J$49,Calc!R$4)","v":4},{"$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,"Monitoring and Agreeing Plans",{"$f":"COUNTIFS(Data!$D$1:$D$49,Calc!C7,Data!$C$1:$C$49,Calc!B7)","v":2},{"$f":"COUNTIFS(Data!$D$1:$D$49,Calc!$C7,Data!$C$1:$C$49,Calc!$B7,Data!$I$1:$I$49,Calc!E$4)","v":0},{"$f":"COUNTIFS(Data!$D$1:$D$49,Calc!$C7,Data!$C$1:$C$49,Calc!$B7,Data!$I$1:$I$49,Calc!F$4)","v":0},{"$f":"COUNTIFS(Data!$D$1:$D$49,Calc!$C7,Data!$C$1:$C$49,Calc!$B7,Data!$I$1:$I$49,Calc!G$4)","v":0},{"$f":"COUNTIFS(Data!$D$1:$D$49,Calc!$C7,Data!$C$1:$C$49,Calc!$B7,Data!$I$1:$I$49,Calc!H$4)","v":2},{"$f":"G7/$D7","v":0},{"$f":"F7/$D7","v":0},{"$f":"E7/$D7","v":0},{"$f":"H7/$D7","v":1},1,null,{"$f":"COUNTIFS(Data!$D$1:$D$49,Calc!$C7,Data!$C$1:$C$49,Calc!$B7,Data!$J$1:$J$49,Calc!O$4)","v":0},{"$f":"COUNTIFS(Data!$D$1:$D$49,Calc!$C7,Data!$C$1:$C$49,Calc!$B7,Data!$J$1:$J$49,Calc!P$4)","v":0},{"$f":"COUNTIFS(Data!$D$1:$D$49,Calc!$C7,Data!$C$1:$C$49,Calc!$B7,Data!$J$1:$J$49,Calc!Q$4)","v":0},{"$f":"COUNTIFS(Data!$D$1:$D$49,Calc!$C7,Data!$C$1:$C$49,Calc!$B7,Data!$J$1:$J$49,Calc!R$4)","v":2},{"$f":"Q7/$D7","v":0},{"$f":"P7/$D7","v":0},{"$f":"O7/$D7","v":0},{"$f":"R7/$D7","v":1},1]
[null,1,"Resourcing Joint Arrangements",{"$f":"COUNTIFS(Data!$D$1:$D$49,Calc!C8,Data!$C$1:$C$49,Calc!B8)","v":2},{"$f":"COUNTIFS(Data!$D$1:$D$49,Calc!$C8,Data!$C$1:$C$49,Calc!$B8,Data!$I$1:$I$49,Calc!E$4)","v":0},{"$f":"COUNTIFS(Data!$D$1:$D$49,Calc!$C8,Data!$C$1:$C$49,Calc!$B8,Data!$I$1:$I$49,Calc!F$4)","v":0},{"$f":"COUNTIFS(Data!$D$1:$D$49,Calc!$C8,Data!$C$1:$C$49,Calc!$B8,Data!$I$1:$I$49,Calc!G$4)","v":0},{"$f":"COUNTIFS(Data!$D$1:$D$49,Calc!$C8,Data!$C$1:$C$49,Calc!$B8,Data!$I$1:$I$49,Calc!H$4)","v":2},0,0,0,1,1,null,{"$f":"COUNTIFS(Data!$D$1:$D$49,Calc!$C8,Data!$C$1:$C$49,Calc!$B8,Data!$J$1:$J$49,Calc!O$4)","v":0},{"$f":"COUNTIFS(Data!$D$1:$D$49,Calc!$C8,Data!$C$1:$C$49,Calc!$B8,Data!$J$1:$J$49,Calc!P$4)","v":0},{"$f":"COUNTIFS(Data!$D$1:$D$49,Calc!$C8,Data!$C$1:$C$49,Calc!$B8,Data!$J$1:$J$49,Calc!Q$4)","v":0},{"$f":"COUNTIFS(Data!$D$1:$D$49,Calc!$C8,Data!$C$1:$C$49,Calc!$B8,Data!$J$1:$J$49,Calc!R$4)","v":2},0,0,0,1,1]
[null,1,"Thresholds and Eligibility Criteria",{"$f":"COUNTIFS(Data!$D$1:$D$49,Calc!C9,Data!$C$1:$C$49,Calc!B9)","v":2},{"$f":"COUNTIFS(Data!$D$1:$D$49,Calc!$C9,Data!$C$1:$C$49,Calc!$B9,Data!$I$1:$I$49,Calc!E$4)","v":0},{"$f":"COUNTIFS(Data!$D$1:$D$49,Calc!$C9,Data!$C$1:$C$49,Calc!$B9,Data!$I$1:$I$49,Calc!F$4)","v":0},{"$f":"COUNTIFS(Data!$D$1:$D$49,Calc!$C9,Data!$C$1:$C$49,Calc!$B9,Data!$I$1:$I$49,Calc!G$4)","v":0},{"$f":"COUNTIFS(Data!$D$1:$D$49,Calc!$C9,Data!$C$1:$C$49,Calc!$B9,Data!$I$1:$I$49,Calc!H$4)","v":2},0,0,0,1,1,null,{"$f":"COUNTIFS(Data!$D$1:$D$49,Calc!$C9,Data!$C$1:$C$49,Calc!$B9,Data!$J$1:$J$49,Calc!O$4)","v":0},{"$f":"COUNTIFS(Data!$D$1:$D$49,Calc!$C9,Data!$C$1:$C$49,Calc!$B9,Data!$J$1:$J$49,Calc!P$4)","v":0},{"$f":"COUNTIFS(Data!$D$1:$D$49,Calc!$C9,Data!$C$1:$C$49,Calc!$B9,Data!$J$1:$J$49,Calc!Q$4)","v":0},{"$f":"COUNTIFS(Data!$D$1:$D$49,Calc!$C9,Data!$C$1:$C$49,Calc!$B9,Data!$J$1:$J$49,Calc!R$4)","v":2},0,0,0,1,1]
[null,2,"Working Together",{"$f":"COUNTIFS(Data!$D$1:$D$49,Calc!C10,Data!$C$1:$C$49,Calc!B10)","v":4},{"$f":"COUNTIFS(Data!$D$1:$D$49,Calc!$C10,Data!$C$1:$C$49,Calc!$B10,Data!$I$1:$I$49,Calc!E$4)","v":0},{"$f":"COUNTIFS(Data!$D$1:$D$49,Calc!$C10,Data!$C$1:$C$49,Calc!$B10,Data!$I$1:$I$49,Calc!F$4)","v":0},{"$f":"COUNTIFS(Data!$D$1:$D$49,Calc!$C10,Data!$C$1:$C$49,Calc!$B10,Data!$I$1:$I$49,Calc!G$4)","v":0},{"$f":"COUNTIFS(Data!$D$1:$D$49,Calc!$C10,Data!$C$1:$C$49,Calc!$B10,Data!$I$1:$I$49,Calc!H$4)","v":4},0,0,0,1,1,null,{"$f":"COUNTIFS(Data!$D$1:$D$49,Calc!$C10,Data!$C$1:$C$49,Calc!$B10,Data!$J$1:$J$49,Calc!O$4)","v":0},{"$f":"COUNTIFS(Data!$D$1:$D$49,Calc!$C10,Data!$C$1:$C$49,Calc!$B10,Data!$J$1:$J$49,Calc!P$4)","v":0},{"$f":"COUNTIFS(Data!$D$1:$D$49,Calc!$C10,Data!$C$1:$C$49,Calc!$B10,Data!$J$1:$J$49,Calc!Q$4)","v":0},{"$f":"COUNTIFS(Data!$D$1:$D$49,Calc!$C10,Data!$C$1:$C$49,Calc!$B10,Data!$J$1:$J$49,Calc!R$4)","v":4},0,0,0,1,1]
[null,2,"Local Offer",{"$f":"COUNTIFS(Data!$D$1:$D$49,Calc!C11,Data!$C$1:$C$49,Calc!B11)","v":6},{"$f":"COUNTIFS(Data!$D$1:$D$49,Calc!$C11,Data!$C$1:$C$49,Calc!$B11,Data!$I$1:$I$49,Calc!E$4)","v":0},{"$f":"COUNTIFS(Data!$D$1:$D$49,Calc!$C11,Data!$C$1:$C$49,Calc!$B11,Data!$I$1:$I$49,Calc!F$4)","v":0},{"$f":"COUNTIFS(Data!$D$1:$D$49,Calc!$C11,Data!$C$1:$C$49,Calc!$B11,Data!$I$1:$I$49,Calc!G$4)","v":0},{"$f":"COUNTIFS(Data!$D$1:$D$49,Calc!$C11,Data!$C$1:$C$49,Calc!$B11,Data!$I$1:$I$49,Calc!H$4)","v":6},0,0,0,1,1,null,{"$f":"COUNTIFS(Data!$D$1:$D$49,Calc!$C11,Data!$C$1:$C$49,Calc!$B11,Data!$J$1:$J$49,Calc!O$4)","v":0},{"$f":"COUNTIFS(Data!$D$1:$D$49,Calc!$C11,Data!$C$1:$C$49,Calc!$B11,Data!$J$1:$J$49,Calc!P$4)","v":0},{"$f":"COUNTIFS(Data!$D$1:$D$49,Calc!$C11,Data!$C$1:$C$49,Calc!$B11,Data!$J$1:$J$49,Calc!Q$4)","v":0},{"$f":"COUNTIFS(Data!$D$1:$D$49,Calc!$C11,Data!$C$1:$C$49,Calc!$B11,Data!$J$1:$J$49,Calc!R$4)","v":6},0,0,0,1,1]
[null,2,"Workforce Development",{"$f":"COUNTIFS(Data!$D$1:$D$49,Calc!C12,Data!$C$1:$C$49,Calc!B12)","v":4},{"$f":"COUNTIFS(Data!$D$1:$D$49,Calc!$C12,Data!$C$1:$C$49,Calc!$B12,Data!$I$1:$I$49,Calc!E$4)","v":0},{"$f":"COUNTIFS(Data!$D$1:$D$49,Calc!$C12,Data!$C$1:$C$49,Calc!$B12,Data!$I$1:$I$49,Calc!F$4)","v":0},{"$f":"COUNTIFS(Data!$D$1:$D$49,Calc!$C12,Data!$C$1:$C$49,Calc!$B12,Data!$I$1:$I$49,Calc!G$4)","v":0},{"$f":"COUNTIFS(Data!$D$1:$D$49,Calc!$C12,Data!$C$1:$C$49,Calc!$B12,Data!$I$1:$I$49,Calc!H$4)","v":4},0,0,0,1,1,null,{"$f":"COUNTIFS(Data!$D$1:$D$49,Calc!$C12,Data!$C$1:$C$49,Calc!$B12,Data!$J$1:$J$49,Calc!O$4)","v":0},{"$f":"COUNTIFS(Data!$D$1:$D$49,Calc!$C12,Data!$C$1:$C$49,Calc!$B12,Data!$J$1:$J$49,Calc!P$4)","v":0},{"$f":"COUNTIFS(Data!$D$1:$D$49,Calc!$C12,Data!$C$1:$C$49,Calc!$B12,Data!$J$1:$J$49,Calc!Q$4)","v":0},{"$f":"COUNTIFS(Data!$D$1:$D$49,Calc!$C12,Data!$C$1:$C$49,Calc!$B12,Data!$J$1:$J$49,Calc!R$4)","v":4},0,0,0,1,1]
[null,3,"Assessing Local Needs",{"$f":"COUNTIFS(Data!$D$1:$D$49,Calc!C13,Data!$C$1:$C$49,Calc!B13)","v":3},{"$f":"COUNTIFS(Data!$D$1:$D$49,Calc!$C13,Data!$C$1:$C$49,Calc!$B13,Data!$I$1:$I$49,Calc!E$4)","v":0},{"$f":"COUNTIFS(Data!$D$1:$D$49,Calc!$C13,Data!$C$1:$C$49,Calc!$B13,Data!$I$1:$I$49,Calc!F$4)","v":0},{"$f":"COUNTIFS(Data!$D$1:$D$49,Calc!$C13,Data!$C$1:$C$49,Calc!$B13,Data!$I$1:$I$49,Calc!G$4)","v":0},{"$f":"COUNTIFS(Data!$D$1:$D$49,Calc!$C13,Data!$C$1:$C$49,Calc!$B13,Data!$I$1:$I$49,Calc!H$4)","v":3},0,0,0,1,1,null,{"$f":"COUNTIFS(Data!$D$1:$D$49,Calc!$C13,Data!$C$1:$C$49,Calc!$B13,Data!$J$1:$J$49,Calc!O$4)","v":0},{"$f":"COUNTIFS(Data!$D$1:$D$49,Calc!$C13,Data!$C$1:$C$49,Calc!$B13,Data!$J$1:$J$49,Calc!P$4)","v":0},{"$f":"COUNTIFS(Data!$D$1:$D$49,Calc!$C13,Data!$C$1:$C$49,Calc!$B13,Data!$J$1:$J$49,Calc!Q$4)","v":0},{"$f":"COUNTIFS(Data!$D$1:$D$49,Calc!$C13,Data!$C$1:$C$49,Calc!$B13,Data!$J$1:$J$49,Calc!R$4)","v":3},0,0,0,1,1]
[null,3,"Affordability and Demand",{"$f":"COUNTIFS(Data!$D$1:$D$49,Calc!C14,Data!$C$1:$C$49,Calc!B14)","v":3},{"$f":"COUNTIFS(Data!$D$1:$D$49,Calc!$C14,Data!$C$1:$C$49,Calc!$B14,Data!$I$1:$I$49,Calc!E$4)","v":0},{"$f":"COUNTIFS(Data!$D$1:$D$49,Calc!$C14,Data!$C$1:$C$49,Calc!$B14,Data!$I$1:$I$49,Calc!F$4)","v":0},{"$f":"COUNTIFS(Data!$D$1:$D$49,Calc!$C14,Data!$C$1:$C$49,Calc!$B14,Data!$I$1:$I$49,Calc!G$4)","v":0},{"$f":"COUNTIFS(Data!$D$1:$D$49,Calc!$C14,Data!$C$1:$C$49,Calc!$B14,Data!$I$1:$I$49,Calc!H$4)","v":3},0,0,0,1,1,null,{"$f":"COUNTIFS(Data!$D$1:$D$49,Calc!$C14,Data!$C$1:$C$49,Calc!$B14,Data!$J$1:$J$49,Calc!O$4)","v":0},{"$f":"COUNTIFS(Data!$D$1:$D$49,Calc!$C14,Data!$C$1:$C$49,Calc!$B14,Data!$J$1:$J$49,Calc!P$4)","v":0},{"$f":"COUNTIFS(Data!$D$1:$D$49,Calc!$C14,Data!$C$1:$C$49,Calc!$B14,Data!$J$1:$J$49,Calc!Q$4)","v":0},{"$f":"COUNTIFS(Data!$D$1:$D$49,Calc!$C14,Data!$C$1:$C$49,Calc!$B14,Data!$J$1:$J$49,Calc!R$4)","v":3},0,0,0,1,1]
[null,3,"Contracts",{"$f":"COUNTIFS(Data!$D$1:$D$49,Calc!C15,Data!$C$1:$C$49,Calc!B15)","v":1},{"$f":"COUNTIFS(Data!$D$1:$D$49,Calc!$C15,Data!$C$1:$C$49,Calc!$B15,Data!$I$1:$I$49,Calc!E$4)","v":0},{"$f":"COUNTIFS(Data!$D$1:$D$49,Calc!$C15,Data!$C$1:$C$49,Calc!$B15,Data!$I$1:$I$49,Calc!F$4)","v":0},{"$f":"COUNTIFS(Data!$D$1:$D$49,Calc!$C15,Data!$C$1:$C$49,Calc!$B15,Data!$I$1:$I$49,Calc!G$4)","v":0},{"$f":"COUNTIFS(Data!$D$1:$D$49,Calc!$C15,Data!$C$1:$C$49,Calc!$B15,Data!$I$1:$I$49,Calc!H$4)","v":1},0,0,0,1,1,null,{"$f":"COUNTIFS(Data!$D$1:$D$49,Calc!$C15,Data!$C$1:$C$49,Calc!$B15,Data!$J$1:$J$49,Calc!O$4)","v":0},{"$f":"COUNTIFS(Data!$D$1:$D$49,Calc!$C15,Data!$C$1:$C$49,Calc!$B15,Data!$J$1:$J$49,Calc!P$4)","v":0},{"$f":"COUNTIFS(Data!$D$1:$D$49,Calc!$C15,Data!$C$1:$C$49,Calc!$B15,Data!$J$1:$J$49,Calc!Q$4)","v":0},{"$f":"COUNTIFS(Data!$D$1:$D$49,Calc!$C15,Data!$C$1:$C$49,Calc!$B15,Data!$J$1:$J$49,Calc!R$4)","v":1},0,0,0,1,1]
[null,3,"Personal Budgets",{"$f":"COUNTIFS(Data!$D$1:$D$49,Calc!C16,Data!$C$1:$C$49,Calc!B16)","v":2},{"$f":"COUNTIFS(Data!$D$1:$D$49,Calc!$C16,Data!$C$1:$C$49,Calc!$B16,Data!$I$1:$I$49,Calc!E$4)","v":0},{"$f":"COUNTIFS(Data!$D$1:$D$49,Calc!$C16,Data!$C$1:$C$49,Calc!$B16,Data!$I$1:$I$49,Calc!F$4)","v":0},{"$f":"COUNTIFS(Data!$D$1:$D$49,Calc!$C16,Data!$C$1:$C$49,Calc!$B16,Data!$I$1:$I$49,Calc!G$4)","v":0},{"$f":"COUNTIFS(Data!$D$1:$D$49,Calc!$C16,Data!$C$1:$C$49,Calc!$B16,Data!$I$1:$I$49,Calc!H$4)","v":2},0,0,0,1,1,null,{"$f":"COUNTIFS(Data!$D$1:$D$49,Calc!$C16,Data!$C$1:$C$49,Calc!$B16,Data!$J$1:$J$49,Calc!O$4)","v":0},{"$f":"COUNTIFS(Data!$D$1:$D$49,Calc!$C16,Data!$C$1:$C$49,Calc!$B16,Data!$J$1:$J$49,Calc!P$4)","v":0},{"$f":"COUNTIFS(Data!$D$1:$D$49,Calc!$C16,Data!$C$1:$C$49,Calc!$B16,Data!$J$1:$J$49,Calc!Q$4)","v":0},{"$f":"COUNTIFS(Data!$D$1:$D$49,Calc!$C16,Data!$C$1:$C$49,Calc!$B16,Data!$J$1:$J$49,Calc!R$4)","v":2},0,0,0,1,1]
[null,4,"SEN Support and Early Help",{"$f":"COUNTIFS(Data!$D$1:$D$49,Calc!C17,Data!$C$1:$C$49,Calc!B17)","v":4},{"$f":"COUNTIFS(Data!$D$1:$D$49,Calc!$C17,Data!$C$1:$C$49,Calc!$B17,Data!$I$1:$I$49,Calc!E$4)","v":0},{"$f":"COUNTIFS(Data!$D$1:$D$49,Calc!$C17,Data!$C$1:$C$49,Calc!$B17,Data!$I$1:$I$49,Calc!F$4)","v":0},{"$f":"COUNTIFS(Data!$D$1:$D$49,Calc!$C17,Data!$C$1:$C$49,Calc!$B17,Data!$I$1:$I$49,Calc!G$4)","v":0},{"$f":"COUNTIFS(Data!$D$1:$D$49,Calc!$C17,Data!$C$1:$C$49,Calc!$B17,Data!$I$1:$I$49,Calc!H$4)","v":4},0,0,0,1,1,null,{"$f":"COUNTIFS(Data!$D$1:$D$49,Calc!$C17,Data!$C$1:$C$49,Calc!$B17,Data!$J$1:$J$49,Calc!O$4)","v":0},{"$f":"COUNTIFS(Data!$D$1:$D$49,Calc!$C17,Data!$C$1:$C$49,Calc!$B17,Data!$J$1:$J$49,Calc!P$4)","v":0},{"$f":"COUNTIFS(Data!$D$1:$D$49,Calc!$C17,Data!$C$1:$C$49,Calc!$B17,Data!$J$1:$J$49,Calc!Q$4)","v":0},{"$f":"COUNTIFS(Data!$D$1:$D$49,Calc!$C17,Data!$C$1:$C$49,Calc!$B17,Data!$J$1:$J$49,Calc!R$4)","v":4},0,0,0,1,1]
[null,4,"EHC Needs and Assessment",{"$f":"COUNTIFS(Data!$D$1:$D$49,Calc!C18,Data!$C$1:$C$49,Calc!B18)","v":5},{"$f":"COUNTIFS(Data!$D$1:$D$49,Calc!$C18,Data!$C$1:$C$49,Calc!$B18,Data!$I$1:$I$49,Calc!E$4)","v":0},{"$f":"COUNTIFS(Data!$D$1:$D$49,Calc!$C18,Data!$C$1:$C$49,Calc!$B18,Data!$I$1:$I$49,Calc!F$4)","v":0},{"$f":"COUNTIFS(Data!$D$1:$D$49,Calc!$C18,Data!$C$1:$C$49,Calc!$B18,Data!$I$1:$I$49,Calc!G$4)","v":0},{"$f":"COUNTIFS(Data!$D$1:$D$49,Calc!$C18,Data!$C$1:$C$49,Calc!$B18,Data!$I$1:$I$49,Calc!H$4)","v":5},0,0,0,1,1,null,{"$f":"COUNTIFS(Data!$D$1:$D$49,Calc!$C18,Data!$C$1:$C$49,Calc!$B18,Data!$J$1:$J$49,Calc!O$4)","v":0},{"$f":"COUNTIFS(Data!$D$1:$D$49,Calc!$C18,Data!$C$1:$C$49,Calc!$B18,Data!$J$1:$J$49,Calc!P$4)","v":0},{"$f":"COUNTIFS(Data!$D$1:$D$49,Calc!$C18,Data!$C$1:$C$49,Calc!$B18,Data!$J$1:$J$49,Calc!Q$4)","v":0},{"$f":"COUNTIFS(Data!$D$1:$D$49,Calc!$C18,Data!$C$1:$C$49,Calc!$B18,Data!$J$1:$J$49,Calc!R$4)","v":5},0,0,0,1,1]
[null,4,"Sign Off",{"$f":"COUNTIFS(Data!$D$1:$D$49,Calc!C19,Data!$C$1:$C$49,Calc!B19)","v":3},{"$f":"COUNTIFS(Data!$D$1:$D$49,Calc!$C19,Data!$C$1:$C$49,Calc!$B19,Data!$I$1:$I$49,Calc!E$4)","v":0},{"$f":"COUNTIFS(Data!$D$1:$D$49,Calc!$C19,Data!$C$1:$C$49,Calc!$B19,Data!$I$1:$I$49,Calc!F$4)","v":0},{"$f":"COUNTIFS(Data!$D$1:$D$49,Calc!$C19,Data!$C$1:$C$49,Calc!$B19,Data!$I$1:$I$49,Calc!G$4)","v":0},{"$f":"COUNTIFS(Data!$D$1:$D$49,Calc!$C19,Data!$C$1:$C$49,Calc!$B19,Data!$I$1:$I$49,Calc!H$4)","v":3},0,0,0,1,1,null,{"$f":"COUNTIFS(Data!$D$1:$D$49,Calc!$C19,Data!$C$1:$C$49,Calc!$B19,Data!$J$1:$J$49,Calc!O$4)","v":0},{"$f":"COUNTIFS(Data!$D$1:$D$49,Calc!$C19,Data!$C$1:$C$49,Calc!$B19,Data!$J$1:$J$49,Calc!P$4)","v":0},{"$f":"COUNTIFS(Data!$D$1:$D$49,Calc!$C19,Data!$C$1:$C$49,Calc!$B19,Data!$J$1:$J$49,Calc!Q$4)","v":0},{"$f":"COUNTIFS(Data!$D$1:$D$49,Calc!$C19,Data!$C$1:$C$49,Calc!$B19,Data!$J$1:$J$49,Calc!R$4)","v":3},0,0,0,1,1]
[null,5,"Working in Partnership With Children and Families",{"$f":"COUNTIFS(Data!$D$1:$D$49,Calc!C20,Data!$C$1:$C$49,Calc!B20)","v":3},{"$f":"COUNTIFS(Data!$D$1:$D$49,Calc!$C20,Data!$C$1:$C$49,Calc!$B20,Data!$I$1:$I$49,Calc!E$4)","v":0},{"$f":"COUNTIFS(Data!$D$1:$D$49,Calc!$C20,Data!$C$1:$C$49,Calc!$B20,Data!$I$1:$I$49,Calc!F$4)","v":0},{"$f":"COUNTIFS(Data!$D$1:$D$49,Calc!$C20,Data!$C$1:$C$49,Calc!$B20,Data!$I$1:$I$49,Calc!G$4)","v":0},{"$f":"COUNTIFS(Data!$D$1:$D$49,Calc!$C20,Data!$C$1:$C$49,Calc!$B20,Data!$I$1:$I$49,Calc!H$4)","v":3},0,0,0,1,1,null,{"$f":"COUNTIFS(Data!$D$1:$D$49,Calc!$C20,Data!$C$1:$C$49,Calc!$B20,Data!$J$1:$J$49,Calc!O$4)","v":0},{"$f":"COUNTIFS(Data!$D$1:$D$49,Calc!$C20,Data!$C$1:$C$49,Calc!$B20,Data!$J$1:$J$49,Calc!P$4)","v":0},{"$f":"COUNTIFS(Data!$D$1:$D$49,Calc!$C20,Data!$C$1:$C$49,Calc!$B20,Data!$J$1:$J$49,Calc!Q$4)","v":0},{"$f":"COUNTIFS(Data!$D$1:$D$49,Calc!$C20,Data!$C$1:$C$49,Calc!$B20,Data!$J$1:$J$49,Calc!R$4)","v":3},0,0,0,1,1]
[]
[]
[null,1,"1. Leadership",{"$f":"COUNTIF(Data!$C$2:$C$91,Calc!B23)","v":10},{"$f":"COUNTIFS(Data!$C$2:$C$91,Calc!$B23,Data!$I$2:$I$91,Calc!E$4)","v":0},{"$f":"COUNTIFS(Data!$C$2:$C$91,Calc!$B23,Data!$I$2:$I$91,Calc!F$4)","v":0},{"$f":"COUNTIFS(Data!$C$2:$C$91,Calc!$B23,Data!$I$2:$I$91,Calc!G$4)","v":0},{"$f":"COUNTIFS(Data!$C$2:$C$91,Calc!$B23,Data!$I$2:$I$91,Calc!H$4)","v":10},{"$f":"G23/$D23","v":0},{"$f":"F23/$D23","v":0},{"$f":"E23/$D23","v":0},{"$f":"H23/$D23","v":1},{"$f":"SUM(I23:L23)","v":1},null,{"$f":"COUNTIFS(Data!$C$2:$C$91,Calc!$B23,Data!$J$2:$J$91,Calc!O$4)","v":0},{"$f":"COUNTIFS(Data!$C$2:$C$91,Calc!$B23,Data!$J$2:$J$91,Calc!P$4)","v":0},{"$f":"COUNTIFS(Data!$C$2:$C$91,Calc!$B23,Data!$J$2:$J$91,Calc!Q$4)","v":0},{"$f":"COUNTIFS(Data!$C$2:$C$91,Calc!$B23,Data!$J$2:$J$91,Calc!R$4)","v":10},{"$f":"Q23/$D23","v":0},{"$f":"P23/$D23","v":0},{"$f":"O23/$D23","v":0},{"$f":"R23/$D23","v":1},{"$f":"SUM(S23:V23)","v":1}]
[null,2,"2. Joint Arrangements",{"$f":"COUNTIF(Data!$C$2:$C$91,Calc!B24)","v":14},{"$f":"COUNTIFS(Data!$C$2:$C$91,Calc!$B24,Data!$I$2:$I$91,Calc!E$4)","v":0},{"$f":"COUNTIFS(Data!$C$2:$C$91,Calc!$B24,Data!$I$2:$I$91,Calc!F$4)","v":0},{"$f":"COUNTIFS(Data!$C$2:$C$91,Calc!$B24,Data!$I$2:$I$91,Calc!G$4)","v":0},{"$f":"COUNTIFS(Data!$C$2:$C$91,Calc!$B24,Data!$I$2:$I$91,Calc!H$4)","v":14},{"$f":"G24/$D24","v":0},{"$f":"F24/$D24","v":0},{"$f":"E24/$D24","v":0},{"$f":"H24/$D24","v":1},{"$f":"SUM(I24:L24)","v":1},null,{"$f":"COUNTIFS(Data!$C$2:$C$91,Calc!$B24,Data!$J$2:$J$91,Calc!O$4)","v":0},{"$f":"COUNTIFS(Data!$C$2:$C$91,Calc!$B24,Data!$J$2:$J$91,Calc!P$4)","v":0},{"$f":"COUNTIFS(Data!$C$2:$C$91,Calc!$B24,Data!$J$2:$J$91,Calc!Q$4)","v":0},{"$f":"COUNTIFS(Data!$C$2:$C$91,Calc!$B24,Data!$J$2:$J$91,Calc!R$4)","v":14},{"$f":"Q24/$D24","v":0},{"$f":"P24/$D24","v":0},{"$f":"O24/$D24","v":0},{"$f":"R24/$D24","v":1},{"$f":"SUM(S24:V24)","v":1}]
[null,3,"3. Commissioning",{"$f":"COUNTIF(Data!$C$2:$C$91,Calc!B25)","v":9},{"$f":"COUNTIFS(Data!$C$2:$C$91,Calc!$B25,Data!$I$2:$I$91,Calc!E$4)","v":0},{"$f":"COUNTIFS(Data!$C$2:$C$91,Calc!$B25,Data!$I$2:$I$91,Calc!F$4)","v":0},{"$f":"COUNTIFS(Data!$C$2:$C$91,Calc!$B25,Data!$I$2:$I$91,Calc!G$4)","v":0},{"$f":"COUNTIFS(Data!$C$2:$C$91,Calc!$B25,Data!$I$2:$I$91,Calc!H$4)","v":9},0,0,0,1,1,null,{"$f":"COUNTIFS(Data!$C$2:$C$91,Calc!$B25,Data!$J$2:$J$91,Calc!O$4)","v":0},{"$f":"COUNTIFS(Data!$C$2:$C$91,Calc!$B25,Data!$J$2:$J$91,Calc!P$4)","v":0},{"$f":"COUNTIFS(Data!$C$2:$C$91,Calc!$B25,Data!$J$2:$J$91,Calc!Q$4)","v":0},{"$f":"COUNTIFS(Data!$C$2:$C$91,Calc!$B25,Data!$J$2:$J$91,Calc!R$4)","v":9},0,0,0,1,1]
[null,4,"4. EHC Plan",{"$f":"COUNTIF(Data!$C$2:$C$91,Calc!B26)","v":12},{"$f":"COUNTIFS(Data!$C$2:$C$91,Calc!$B26,Data!$I$2:$I$91,Calc!E$4)","v":0},{"$f":"COUNTIFS(Data!$C$2:$C$91,Calc!$B26,Data!$I$2:$I$91,Calc!F$4)","v":0},{"$f":"COUNTIFS(Data!$C$2:$C$91,Calc!$B26,Data!$I$2:$I$91,Calc!G$4)","v":0},{"$f":"COUNTIFS(Data!$C$2:$C$91,Calc!$B26,Data!$I$2:$I$91,Calc!H$4)","v":12},0,0,0,1,1,null,{"$f":"COUNTIFS(Data!$C$2:$C$91,Calc!$B26,Data!$J$2:$J$91,Calc!O$4)","v":0},{"$f":"COUNTIFS(Data!$C$2:$C$91,Calc!$B26,Data!$J$2:$J$91,Calc!P$4)","v":0},{"$f":"COUNTIFS(Data!$C$2:$C$91,Calc!$B26,Data!$J$2:$J$91,Calc!Q$4)","v":0},{"$f":"COUNTIFS(Data!$C$2:$C$91,Calc!$B26,Data!$J$2:$J$91,Calc!R$4)","v":12},0,0,0,1,1]
[null,5,"5. Co-Production",{"$f":"COUNTIF(Data!$C$2:$C$91,Calc!B27)","v":3},{"$f":"COUNTIFS(Data!$C$2:$C$91,Calc!$B27,Data!$I$2:$I$91,Calc!E$4)","v":0},{"$f":"COUNTIFS(Data!$C$2:$C$91,Calc!$B27,Data!$I$2:$I$91,Calc!F$4)","v":0},{"$f":"COUNTIFS(Data!$C$2:$C$91,Calc!$B27,Data!$I$2:$I$91,Calc!G$4)","v":0},{"$f":"COUNTIFS(Data!$C$2:$C$91,Calc!$B27,Data!$I$2:$I$91,Calc!H$4)","v":3},0,0,0,1,1,null,{"$f":"COUNTIFS(Data!$C$2:$C$91,Calc!$B27,Data!$J$2:$J$91,Calc!O$4)","v":0},{"$f":"COUNTIFS(Data!$C$2:$C$91,Calc!$B27,Data!$J$2:$J$91,Calc!P$4)","v":0},{"$f":"COUNTIFS(Data!$C$2:$C$91,Calc!$B27,Data!$J$2:$J$91,Calc!Q$4)","v":0},{"$f":"COUNTIFS(Data!$C$2:$C$91,Calc!$B27,Data!$J$2:$J$91,Calc!R$4)","v":3},0,0,0,1,1]
[]
[null,null,null,{"$f":"SUM(D6:D20)","v":48},{"$f":"SUM(E23:E27)","v":0},{"$f":"SUM(F23:F27)","v":0},{"$f":"SUM(G23:G27)","v":0},{"$f":"SUM(H23:H27)","v":48},{"$f":"G29/$D29","v":0},{"$f":"F29/$D29","v":0},{"$f":"E29/$D29","v":0},{"$f":"H29/$D29","v":1},{"$f":"SUM(I29:L29)","v":1},null,{"$f":"SUM(O23:O27)","v":0},{"$f":"SUM(P23:P27)","v":0},{"$f":"SUM(Q23:Q27)","v":0},{"$f":"SUM(R23:R27)","v":48},{"$f":"Q29/$D29","v":0},{"$f":"P29/$D29","v":0},{"$f":"O29/$D29","v":0},{"$f":"R29/$D29","v":1},{"$f":"SUM(S29:V29)","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 SC","index":4,"n_rows":213,"n_cols":14,"rows_kept":213,"cut":false,"hidden":false,"merged":[[1,3,1,17],[4,8,4,10],[5,8,5,10]]}
[]
[null,null,null,"ENGAGEMENT AND PARTICIPATION AUDIT TOOL"]
[]
[]
[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$29:$K$29)","v":0},null,null,null,null,null,null,null,{"$f":"SUM(Calc!$S$29:$U$29)","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!I23:K23)","v":0},null,null,null,null,null,null,null,{"$f":"SUM(Calc!S23:U23)","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[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!I24:K24)","v":0},null,null,null,null,null,null,null,{"$f":"SUM(Calc!S24:U24)","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[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!I25:K25)","v":0},null,null,null,null,null,null,null,{"$f":"SUM(Calc!S25:U25)","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[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!I26:K26)","v":0},null,null,null,null,null,null,null,{"$f":"SUM(Calc!S26:U26)","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"5. CO-PRODUCTION"]
[]
[null,null,null,null,null,"1st Audit",null,null,null,null,null,null,null,"2nd Audit"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,{"$f":"SUM(Calc!I27:K27)","v":0},null,null,null,null,null,null,null,{"$f":"SUM(Calc!S27:U27)","v":0}]

{"sheet":"1. Leadership","index":5,"n_rows":50,"n_cols":10,"rows_kept":50,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,null,"1. LEADERSHIP"]
[]
[null,null,null,"Governance and Leadership"]
[]
[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,"Do senior leaders and managers have a sound understanding of the key duties in the Children and Families Act 2014 as they relate to social care?","SEND champions are appointed within LAs and CCGs to raise the profile of SEND\n\nThe local SEND strategy group includes representatives linked to social care, virtual school heads and parent carers\n\nThe SEND Board, Social Care Board and Leadership meetings are influenced and supported by SEND champions and SEND strategy groups\n",null,"Please Select","Please Select","Please Select"]
[null,null,null,"Have the social care strategic managers worked with their  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 social care and all other partners\n\nSocial care is part of the strategic partnership group which oversees the implementation and review of the plan\n\nThere is a clear set of performance measures that demonstrate progress towards achieving key social care related outcomes with the SEND strategy\n",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 children's and adults' social care within the LA (with particular focus on promoting effective transitions, including Preparation for Adulthood)?","There are 0-25 social care and SEND strategies in place. \n\nProcesses are in place to ensure transition assessments under the Care Act 2014 are aligned with the EHC planning process\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,"To what extent are social care leaders aware of their areas of strengths and areas for development in relation to SEND?","Peer review occurs internally and regionally\n\nFeedback from parents is collated and used \n\nThere is a process in place for sharing the audit tool and gaining triangulated feedback on self assessment\n",null,"Please Select","Please Select","Please Select"]
[]
[]
[]
[null,null,null,"Monitoring and Agreeing Plans"]
[]
[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 process for internal audit and external peer review/moderation of plans in relation to social care?","Social care works collaboratively with the SEN team to undertake an internal audit process around the quality of EHC Plans. \n\nThe local authority has an arrangement with neighbouring authorities to peer review each other's plans.\n",null,"Please Select","Please Select","Please Select"]
[null,null,null,"Are joint commissioning arrangements leading to improvements in social care engagement to support the delivery of outcomes in EHC plans?","The impact of local social care 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,"Resourcing Joint Arrangements"]
[]
[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 there clear links between social care commissioners and SEND commissioning teams?","Senior managers and officers in the authority have social care and SEND commissioning as part of the job descriptions and time to complete it. If the SEND commissioning team sits outside of the social care commissioning team there are clear links between them. \n\nIs SEND commissioning the sole responsibility of one team, or is it part of a larger portfolio (e.g. children’s commissioning)?  If the latter, are there safeguards in place to ensure time remains dedicated to SEND? \n",null,"Please Select","Please Select","Please Select"]
[null,null,null,"Are there clear links between commissioners of children's and adult's services to ensure a successful transition to adulthood?\n","There are links and processes to facilitate joint planning between children's and adult's social care services ",null,"Please Select","Please Select","Please Select"]
[]
[]
[]
[null,null,null,"Thresholds and Eligibility Criteria"]
[]
[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 threshold and eligibility criteria take full account of the statutory provision under which the LA is acting?","The threshold at which the LA accepts it 'necessary' to make provision under the CSDPA 1970 section 2 is clear\n\nThe eligibility criteria is used appropriately where LAs are using their discretionary powers to meet needs (for example section 17 or section 20(4) of the Children Act 1989)\n                                                                              Thresholds and eligibility criteria are applied only after a statutory assessment of the child and families needs unless the LA operates a 'non-assessed' pathway for short breaks\n",null,"Please Select","Please Select","Please Select"]
[null,null,null,"Does the local offer clearly set out the range of short breaks available for disabled children and young people and those with SEN, including how they can be accessed?","The local offer includes a clear short breaks duty statement giving details of the range of local services and how they can be accessed\n\nThe local offer includes details of any eligibility criteria which must be satisfied before social care services can be provided\n",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 2014:"]
[null,null,null,"https://councilfordisabledchildren.org.uk/help-resources/resources/role-social-care-implementing-children-families-act"]
[]
[null,null,null,"FAQs on the SEND reforms:"]
[null,null,null,"https://councilfordisabledchildren.org.uk/help-resources/resources/faqs-social-care-and-send-reforms"]
[]
[null,null,null,"Short breaks for Disabled Children: A legal guide"]
[null,null,null,"https://councilfordisabledchildren.org.uk/help-resources/resources/short-breaks-disabled-children-legal-guide "]
[]
[null,null,null,"CDC’s case law directory:"]
[null,null,null,"https://councilfordisabledchildren.org.uk/our-work/social-care/policy/case-law-directory"]

{"sheet":"2. Joint Arrangements","index":6,"n_rows":51,"n_cols":10,"rows_kept":51,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,null,"2. JOINT ARRANGEMENTS"]
[]
[null,null,null,"Working Together"]
[]
[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 there clear decision-making structures which allow social care partners to agree the outcomes sought and services required to achieve them?\n","There are clear multi-agency protocols in place to support oversight and decision making, joint commissioning, pathways and threshold documents",null,"Please Select","Please Select","Please Select"]
[null,null,null,"Are there agreements in place about how all social care services, including children's and adults', contribute to the SEN agenda?","There is infrastucture in place to allow for joint working between SEN and Children's and Adults' social care teams such as a 0-25 service model\n\nThere are clear links between and understanding of roles and repsonsibilities across SEN and all social care teams (e.g. Early Help, CiN, LAC, CP)\n\nThere are agreed links between children's and adults' services and clear protocols for engagement and information sharing \n",null,"Please Select","Please Select","Please Select"]
[null,null,null,"Are the Early Help processes and SEND processes clearly aligned?  ","There are processes in place for the effective assessment of the needs of individual children who may benefit from early help services\n\nEarly Help assessments are informed by - or inform - an EHC needs assessment. The lead professional ensures information relevant to both assessment processes is shared\n",null,"Please Select","Please Select","Please Select"]
[null,null,null,"Are there arrangements in place for the LA to quality assure and performance manage its in-house social care functions against meeting the statutory duties of the SEND Code of Practice?","Requests for social care advice and information are responded to within 6 weeks of the request\n\nSocial care practitioners are involved in multi-agency decision making and sign off processes\n",null,"Please Select","Please Select","Please Select"]
[]
[]
[]
[null,null,null,"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 offer set out information relevant to disabled children and young people, including eligibility for short breaks, early help and statutory social care services?\n","The local offer sets out the social care services and support expected to be available for disabled children and young people and those with SEN",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 social care provision\n\nThe local offer is used as a commissioning tool to identify unmet social care needs\n",null,"Please Select","Please Select","Please Select"]
[null,null,null,"Is the role of social care in the EHC needs assessment process clearly defined in the local offer?","The local offer provides detailed information about how parents and young people can request an EHC needs assessment and how social care is involved in this process\n",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?","Accessible information about the children's social care pathways is available on the local offer, including contact details for safeguarding/child protection, looked after children and disabled children's teams\n\nThe local offer is informative and includes a wide range of information to help parents to identify where to get support and how to access available services\n",null,"Please Select","Please Select","Please Select"]
[null,null,null,"Does the local offer include support with preparing for adulthood and transition?","The local offer includes accessible information on adult social care, including  eligibility for transition assessments under the Care Act 2014, as well as services for young people post-18\n\nThe local offer includes social care support available to disabled children and young people in higher education\n\nThere are links between children's social care and adult social care teams, including complex needs, learning disability and mental health teams and services\n",null,"Please Select","Please Select","Please Select"]
[null,null,null,"Does the local offer include information about meeting the needs of parent carers of children and young people with SEND, for example parent carer needs assessments and eligibility?","The local offer clearly explains the rights of parent carers to needs assesments and links to further detailed guidance about when and how a parent carers needs assessment can be requested\n\nThere is guidance available regarding the support services available to parent carers under section 17 of Children Act 1989\n",null,"Please Select","Please Select","Please Select"]
[]
[]
[]
[null,null,null,"Workforce Development"]
[]
[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 workforce across education, health and care understand the role and responsibilities of social workers in relation to the SEND agenda?","There are clear protocols in place that support schools, SENCOs, EHC plan coordinators, DMOs/DCOs and those working directly with families to be clear about the role of social care\n\nThere is high quality training available in a range of mediums (face to face, e-learning, guidance) related to the role of social care in the SEND reforms\n\nThe approach to working together across agencies supports the development of effective relationships across education, health and care and supports ongoing development of understanding in relation to roles and responsibilities\n",null,"Please Select","Please Select","Please Select"]
[null,null,null,"Does the children's social care workforce understand their own role and responsibilities and those of other practitioners across education and health in relation to the SEND agenda?","Social workers are aware of and understand the duties in the Children and Families Act 2014 in relation to SEND  \n\nThere is high quality training for social workers available in a range of mediums (face to face, e-learning, guidance) related to the role of social care in the SEND reforms which includes links between EHC plans and other statutory plans that children and families may have and approaches to developing outcomes with children, young people and families\n\nThe approach to working together across agencies supports the development of effective relationships across education, health and care and supports ongoing development of understanding in relation to roles and responsibilities\n",null,"Please Select","Please Select","Please Select"]
[null,null,null,"Does the adults' social care workforce understand their role and responsibilities in relation to the SEND agenda for young people from year 9 onwards?","Social workers responsible for supporting young people aged 14 -25 are aware of and understand the duties in the Children and Families Act 2014 in relation to SEND and the duties in the Care Act 2014\n\nThere is high quality training for transition and adults' social workers available in a range of mediums (face to face, e-learning, guidance) related to the role of social care in the SEND reforms which includes links between EHC plans and other statutory plans that children and families may have, and approaches to developing outcomes with children, young people and families\n\nThe approach to working together across agencies supports the development of effective relationships across education, health and care and supports ongoing development of understanding in relation to roles and responsibilities",null,"Please Select","Please Select","Please Select"]
[null,null,null,"Do practitioners supporting families understand their role in identifying social care needs as part of the EHC needs assessment process?","High quality training ensures that practitioners supporting families across universal settings, schools, short breaks, early help and health (including mental health) services are aware of their role in identifying where children and families may have social care needs and how to make a referral to social care services where necessary",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 2014:"]
[null,null,null,"https://councilfordisabledchildren.org.uk/help-resources/resources/role-social-care-implementing-children-families-act"]
[]
[null,null,null,"FAQs on the SEND reforms:"]
[null,null,null,"https://councilfordisabledchildren.org.uk/help-resources/resources/faqs-social-care-and-send-reforms"]
[]
[null,null,null,"Short breaks for Disabled Children: A legal guide"]
[null,null,null,"https://councilfordisabledchildren.org.uk/help-resources/resources/short-breaks-disabled-children-legal-guide "]
[]
[null,null,null,"CDC’s case law directory:"]
[null,null,null,"https://councilfordisabledchildren.org.uk/our-work/social-care/policy/case-law-directory"]
[]
[null,null,null,"CDC Local Offer Briefing:"]
[null,null,null,"https://councilfordisabledchildren.org.uk/sites/default/files/field/attachemnt/Local%20Offer_Online.pdf"]

{"sheet":"3. Commissioning","index":7,"n_rows":52,"n_cols":10,"rows_kept":52,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,null,"3. COMMISSIONING"]
[]
[null,null,null,"Assessing Local Need"]
[]
[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 and national data sets being used (e.g. https://www.gov.uk/guidance/phe-data-and-analysis-tools#child-and-maternal-health) to understand local needs?","There are processes in place to collate and analyse local and national data to understand local need and inform commissioning processes\n\nLeaders and managers meet together regularly, share information and jointly commission services\n",null,"Please Select","Please Select","Please Select"]
[null,null,null,"Does the data available provide assurance that local services are sufficient to meet need as required by section 27(2) of the Children and Familes Act 2014?","Data are collected from a range of local sources including feedback from the local offer and EHC plans to inform local area gap analysis \n\nThere are effective joint commissioning arrangements in place to deliver improved services and outcomes",null,"Please Select","Please Select","Please Select"]
[null,null,null,"Is there a process in place for reviewing the experiences and outcomes of families/children and young people whose needs require multiple commissioning and services?\n","Personalised joint commissioning for complex cases is informed by regular reviews and monitoring of progress towards outcomes",null,"Please Select","Please Select","Please Select"]
[]
[]
[]
[null,null,null,"Affordability and 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,"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 including relationships with social care needs. This is linked to data on CiN, CP and LAC",null,"Please Select","Please Select","Please Select"]
[null,null,null,"For children with more complex needs how are children's and adults' social care working collaboratively with 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) \n\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\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 in relation to transition?","Processes are in place across children's and adults' services to support identification of young people who may or may not have an EHC plan or be in receipt of children's services but may have needs for care and support post-18 \n\nData is monitored, analysed and reviewed by multi-agency teams and informs planning and commissioning for transition",null,"Please Select","Please Select","Please Select"]
[]
[]
[]
[null,null,null,"Contracts"]
[]
[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 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?\n","Data is collected and is used to review social care provision\n\nThere is destination data recorded for children and young people",null,"Please Select","Please Select","Please Select"]
[]
[]
[]
[null,null,null,"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,"Do joint commissioning arrangements set out the arrangements in place for agreeing Personal Budgets?","A local policy is in place for personal budgets that includes a description of the services across education, health and social care that lend themselves to the use of personal budgets\n\nThe mechanisms of control for funding available to parents and young people including direct payments, an arrangement, third party arrangements or a combination, is set out in a clear local policy\n",null,"Please Select","Please Select","Please Select"]
[null,null,null,"Are mechanisms in place to ensure effective planning for pooled budgets in relation to education, health and social care and transition?","Effective use of personal budgets across education, health and care supports person-centred planning and progress towards outcomes\n\nEffective use of personal budgets across education, health and care supports effective transition between services and into adulthood\n",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 2014:"]
[null,null,null,"https://councilfordisabledchildren.org.uk/help-resources/resources/role-social-care-implementing-children-families-act"]
[]
[null,null,null,"FAQs on the SEND reforms:"]
[null,null,null,"https://councilfordisabledchildren.org.uk/help-resources/resources/faqs-social-care-and-send-reforms"]
[]
[null,null,null,"Short breaks for Disabled Children: A legal guide"]
[null,null,null,"https://councilfordisabledchildren.org.uk/help-resources/resources/short-breaks-disabled-children-legal-guide "]
[]
[null,null,null,"CDC’s case law directory:"]
[null,null,null,"https://councilfordisabledchildren.org.uk/our-work/social-care/policy/case-law-directory"]
[]
[null,null,null,"Joint Commissioning bulletins:"]
[null,null,null,"https://councilfordisabledchildren.org.uk/help-resources/resources/updated-joint-commissioning-bulletins"]

{"sheet":"4. EHC Plan","index":8,"n_rows":43,"n_cols":10,"rows_kept":43,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,null,"4. EHC PLAN"]
[]
[null,null,null,"SEN Support and Early Help"]
[]
[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 children's workforce across education, health and care supported to recognise the needs of children and families who may require early help?","Practitioners across all services share a common purpose to identify and support those who have special educational needs and/or disabilities as soon as possible\n\nPractitioners understand local thresholds for early help and know when and how to make a referral\n\nThere is high quality training, information and guidance to inform processes and establish consistency in assessment\n",null,"Please Select","Please Select","Please Select"]
[null,null,null,"Is there a clear process in place to ensure that where children and young people are engaged with SEN support there is a holistic approach to planning which includes health and social care needs?","Early identification training for school and college staff, EHC plan coordinators and frontline practitioners enables them to support early identification of social care needs\n\nThe local area’s ‘early help’ assessment process is a good example of joint working across the education, health and care workforce\n\nThe SEN support planning process is hoslitic and includes information relating to support across education, health and care where relevant\n",null,"Please Select","Please Select","Please Select"]
[null,null,null,"Do early help practitioners understand their role and responsibilities in relation to SEN support and EHC needs assessment and planning processes?","High quality training for early help practitioners enables them to contribute meaningfully to SEN support planning and education, health and care needs assessment and planning\n\nThe local offer supports practitioners and families to know how to access appropriate pathways and support from universal services, short breaks, early help and children's and adults' social care",null,"Please Select","Please Select","Please Select"]
[null,null,null,"Is there a clear process for sharing relevant information related to social care needs as part of assessment and planning processes?","Early help practitioners are supported through high quality training to help them to identify information relevant to a child or young person's SEN\n\nThere are clear protocols in place regarding when, how and with whom to share information. These are aligned with other information sharing processes across children’s social care                                                    \n",null,"Please Select","Please Select","Please Select"]
[]
[]
[]
[null,null,null,"EHC Needs and Assessment"]
[]
[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 workers across children's and adults' services aware of their responsibilities in relation to the EHC assessment and planning process","There is a clear induction process for all staff expected to provide social care advice and information for children and young people who are already known to social care, including sharing relevant protocols, processes and key documents and templates.                                                                                                  \n",null,"Please Select","Please Select","Please Select"]
[null,null,null,"Does the EHC  process from decision to assess through to draft plan include meaningful input from social care?","A social worker/ representative from children's social care is involved in the decision making process from decision to assess through to decision to issue a plan \n\nThere is consistent social care oversight and input at multi-agency panel during weeks 1-6 of the EHC process\n\nSocial workers are routinely invited to and attend the EHC planning meetings for children and young people they are working with",null,"Please Select","Please Select","Please Select"]
[null,null,null,"Are social workers clear about the type of information and advice they are expected to provide as part of the assessment?","There is a process for analysing notification of referrals for EHC assessment received by social care which informs planning and capacity to provide advice and information for those who are known to social care services\n\nRequests for advice and information are received by social care by week 6 of the process wherever possible\n\nThere is a clear process for responding to advice and information requests within 6 weeks of the request including where an assessment is underway or where a child is not known to social care services                                                                                       \n",null,"Please Select","Please Select","Please Select"]
[null,null,null,"Is there a process in place to ensure that high quality social care advice and information is informed by the aspirations of children, young people and their families?","Early conversations with families identify aspirations and outcomes which inform requests for social care advice and information \n\nSocial workers write advice in the context of young people's aspirations and to align with sections D, H1 and H2 of the EHC plan.  This can be supported through the use of templates for both requests and responses to advice                                 \n",null,"Please Select","Please Select","Please Select"]
[null,null,null,"If the child or young person is not known to children's social care, is there a process in place to ensure that social care needs are identified and recorded by other relevant professionals?","The EHC plan coordinator liaises with family and other practitioners such as SENCOs, keyworkers or universal providers to identify the appropriate practitioners to issue the request for advice to\n\nWhere there is no evidence of unmet social care needs this should be clearly articulated with reference to universal services being accessed.\n",null,"Please Select","Please Select","Please Select"]
[]
[]
[]
[null,null,null,"Sign Off"]
[]
[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 sufficient time allowed to ensure robust quality assurance and sign off of the draft plan?","Notifications are sent to social care as early as possible during weeks 1-6\n\nRequest for advice and information and received by week 6 at the latest and responses to advice and information are routinely returned with 6 weeks of the request             \n",null,"Please Select","Please Select","Please Select"]
[null,null,null,"Is there a process in place to ensure families are clear about information will be shared and with whom?","The initial consent form for the EHC needs assessment is clear around the information that is being requested from social care. This includes information on the assessment process and information sharing to ensure informed consent.  Regular communication with the family is clear about what information is being shared and with whom\n\nAs appropriate, further consent is sought from the family by the practitioner submitting the social care advice. The family is made aware of the information that is being shared\n\nThere is a process in place to address if the family do not agree with information shared by social care\n",null,"Please Select","Please Select","Please Select"]
[null,null,null,"Are processes in place to moderate the quality of social care advice,  provide feedback to writers and ensure relevant links across children's social care are established?","There is a quality assurance process in place to ensure the social care advice is relevant and proportionate to the EHC planning process\n\nThe identified social care decision maker is responsible for signing off on social care aspects of the EHC plan and ensuring that outcomes and provision identified is aligned with any other social care plans.\n",null,"Please Select","Please Select","Please Select"]
[]
[]
[]
[null,null,null,"FURTHER INFORMATION:"]
[]
[null,null,null,"Identifying the social care needs of disabled children and young people and those with SEN as part of EHC Needs Assessments:"]
[null,null,null,"https://councilfordisabledchildren.org.uk/help-resources/resources/identifying-social-care-needs-disabled-children-and-young-people"]
[]
[null,null,null,"Securing good quality social care advice for education, health and care (EHC) plans:"]
[null,null,null,"https://councilfordisabledchildren.org.uk/help-resources/resources/advice-education-health-and-care-plans"]
[]
[null,null,null,"Education, Health and Care Plans: Examples of good practice:"]
[null,null,null,"https://councilfordisabledchildren.org.uk/help-resources/resources/education-health-and-care-plans-examples-good-practice"]

{"sheet":"5. Co-Production","index":9,"n_rows":19,"n_cols":10,"rows_kept":19,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,null,"5. CO-PRODUCTION"]
[]
[null,null,null,"Working in Partnership With Children and Families"]
[]
[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 children, young people and parents effectively involved in decisions at both a strategic and individual level?","Disabled children, those with SEN and their parents are consistently provided with the information, advice and support they need to participate in discussions and decisions about individual social care support and local provision\n\nSection 19 principles are embedded in practice across children's and adults' social care services\n",null,"Please Select","Please Select","Please Select"]
[null,null,null,"Are thresholds and eligibility criteria for children's social care clear and applied consistently?","Threshold documents are transparent and explain in clear 'everyday language' how services are allocated on the basis of need\n\nThresholds are applied through careful assessment of need using a whole family approach, looking at the child's level of need in the family context\n",null,"Please Select","Please Select","Please Select"]
[null,null,null,"Are comments from children, young people and parents about the local offer used to improve the range and responsiveness of services and support?","There is a process in place that ensures feedback and comments on the local offer in relation to social care, and analysis across individual EHC plans informs planning and  commissioning of services\n\nThe section 19 principles and person-centred approaches are embedded in practice in relation to assessment and planning\n",null,"Please Select","Please Select","Please Select"]
[]
[]
[]
[null,null,null,"FURTHER INFORMATION:"]
[]
[null,null,null,"Transforming culture and practice in children's social care assessment"]
[null,null,null,"https://councilfordisabledchildren.org.uk/help-resources/resources/transforming-culture-and-practice-social-care "]
[]
[null,null,null,"Participation audit tool:"]
[null,null,null,"https://councilfordisabledchildren.org.uk/help-resources/resources/participation-audit-tool"]