{"text_format":"1","workbook":"xlsx","n_sheets":11,"sheets":["Information","Data","Calc","LA - mapping","Summary LA","1. Children's Social Care","2. Adult Social Care","3. Health","4. Early Years","5. Schools","6. Post 16 Options"],"not_rendered":{"charts":16,"images":5,"macros":1,"external_links":0,"defined_names":3,"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":21,"n_cols":4,"rows_kept":21,"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 that supports joint working across local areas to support the best possible outcomes for children and young people with SEND in a participative and person centred way."]
[]
[null,null,null,"Section 8 of the Code of Practice sets out how professionals across education (including early years, schools, colleges and 16-19 academies), health and social care should support children and young people with special educational needs (SEN) or disabilities to prepare for adult life to be as independent as they can be and help them go on to achieve the best outcomes in employment, independent living, health and community participation."]
[]
[]
[null,null,null,"The Tool"]
[]
[null,null,null,"The tool is designed to support Local Authorities and Health partners in CCGs areas across education, health and care (children and adult’s) to evaluate about how they are doing in preparing young people with SEND for their adult lives."]
[]
[null,null,null,"The tool has been divided into sections across Early Years, Schools and Post 16. Children and Adult Social Care and Health. "]
[]
[null,null,null,"Fundamental to the Code is the expectation that Local Areas will work in partnership with children, young people and parent/carers, and we would expect the completion of this tool to involve all stakeholders including children, young people and parent carers, although there is a separate tool for evaluating participation in your Local Area."]

{"sheet":"Data","index":1,"n_rows":60,"n_cols":10,"rows_kept":60,"cut":false,"hidden":true,"merged":[]}
["m1","Section","Section_ID","Sub-Section","SS_ID","Q","Audit1","Audit2","Audit1_Score","Audit2_Score"]
[null,"1. Children's Social Care",1,"CSC",1.1000000000000001,1,{"$f":"'1. Children''s Social Care'!G6","v":"Please Select"},{"$f":"'1. Children''s Social Care'!H6","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. Children's Social Care",1,"CSC",1.1000000000000001,2,{"$f":"'1. Children''s Social Care'!G7","v":"Please Select"},{"$f":"'1. Children''s Social Care'!H7","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. Children's Social Care",1,"CSC",1.1000000000000001,3,{"$f":"'1. Children''s Social Care'!G8","v":"Please Select"},{"$f":"'1. Children''s Social Care'!H8","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. Children's Social Care",1,"CSC",1.1000000000000001,4,{"$f":"'1. Children''s Social Care'!G9","v":"Please Select"},{"$f":"'1. Children''s Social Care'!H9","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. Children's Social Care",1,"CSC",1.1000000000000001,5,{"$f":"'1. Children''s Social Care'!G10","v":"Please Select"},{"$f":"'1. Children''s Social Care'!H10","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. Children's Social Care",1,"CSC",1.1000000000000001,6,{"$f":"'1. Children''s Social Care'!G11","v":"Please Select"},{"$f":"'1. Children''s Social Care'!H11","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. Children's Social Care",1,"CSC",1.1000000000000001,7,{"$f":"'1. Children''s Social Care'!G12","v":"Please Select"},{"$f":"'1. Children''s Social Care'!H12","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. Children's Social Care",1,"CSC",1.1000000000000001,8,{"$f":"'1. Children''s Social Care'!G13","v":"Please Select"},{"$f":"'1. Children''s Social Care'!H13","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,"2. Adult Social Care",2,"ASC",2.1,1,{"$f":"'2. Adult Social Care'!G6","v":"Please Select"},{"$f":"'2. Adult Social Care'!H6","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,"2. Adult Social Care",2,"ASC",2.1,2,{"$f":"'2. Adult Social Care'!G7","v":"Please Select"},{"$f":"'2. Adult Social Care'!H7","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. Adult Social Care",2,"ASC",2.1,3,{"$f":"'2. Adult Social Care'!G8","v":"Please Select"},{"$f":"'2. Adult Social Care'!H8","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. Adult Social Care",2,"ASC",2.1,4,{"$f":"'2. Adult Social Care'!G9","v":"Please Select"},{"$f":"'2. Adult Social Care'!H9","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. Adult Social Care",2,"ASC",2.1,5,{"$f":"'2. Adult Social Care'!G10","v":"Please Select"},{"$f":"'2. Adult Social Care'!H10","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. Adult Social Care",2,"ASC",2.1,6,{"$f":"'2. Adult Social Care'!G11","v":"Please Select"},{"$f":"'2. Adult Social Care'!H11","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. Adult Social Care",2,"ASC",2.1,7,{"$f":"'2. Adult Social Care'!G12","v":"Please Select"},{"$f":"'2. Adult Social Care'!H12","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. Adult Social Care",2,"ASC",2.1,8,{"$f":"'2. Adult Social Care'!G13","v":"Please Select"},{"$f":"'2. Adult Social Care'!H13","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. Adult Social Care",2,"ASC",2.1,9,{"$f":"'2. Adult Social Care'!G14","v":"Please Select"},{"$f":"'2. Adult Social Care'!H14","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,"3. Health",3,"H",3.1,1,{"$f":"'3. Health'!G6","v":"Please Select"},{"$f":"'3. Health'!H6","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,"3. Health",3,"H",3.1,2,{"$f":"'3. Health'!G7","v":"Please Select"},{"$f":"'3. Health'!H7","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,"3. Health",3,"H",3.1,3,{"$f":"'3. Health'!G8","v":"Please Select"},{"$f":"'3. Health'!H8","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,"3. Health",3,"H",3.1,4,{"$f":"'3. Health'!G9","v":"Please Select"},{"$f":"'3. Health'!H9","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,"3. Health",3,"H",3.1,5,{"$f":"'3. Health'!G10","v":"Please Select"},{"$f":"'3. Health'!H10","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,"3. Health",3,"H",3.1,6,{"$f":"'3. Health'!G11","v":"Please Select"},{"$f":"'3. Health'!H11","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,"3. Health",3,"H",3.1,7,{"$f":"'3. Health'!G12","v":"Please Select"},{"$f":"'3. Health'!H12","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. Health",3,"H",3.1,8,{"$f":"'3. Health'!G13","v":"Please Select"},{"$f":"'3. Health'!H13","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. Health",3,"H",3.1,9,{"$f":"'3. Health'!G14","v":"Please Select"},{"$f":"'3. Health'!H14","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. Health",3,"H",3.1,10,{"$f":"'3. Health'!G15","v":"Please Select"},{"$f":"'3. Health'!H15","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. Health",3,"H",3.1,11,{"$f":"'3. Health'!G16","v":"Please Select"},{"$f":"'3. Health'!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. Health",3,"H",3.1,12,{"$f":"'3. Health'!G17","v":"Please Select"},{"$f":"'3. Health'!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,"4. Early Years",4,"EY",4.0999999999999996,1,{"$f":"'4. Early Years'!G6","v":"Please Select"},{"$f":"'4. Early Years'!H6","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,"4. Early Years",4,"EY",4.0999999999999996,2,{"$f":"'4. Early Years'!G7","v":"Please Select"},{"$f":"'4. Early Years'!H7","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,"4. Early Years",4,"EY",4.0999999999999996,3,{"$f":"'4. Early Years'!G8","v":"Please Select"},{"$f":"'4. Early Years'!H8","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,"4. Early Years",4,"EY",4.0999999999999996,4,{"$f":"'4. Early Years'!G9","v":"Please Select"},{"$f":"'4. Early Years'!H9","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. Early Years",4,"EY",4.0999999999999996,5,{"$f":"'4. Early Years'!G10","v":"Please Select"},{"$f":"'4. Early Years'!H10","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. Early Years",4,"EY",4.0999999999999996,6,{"$f":"'4. Early Years'!G11","v":"Please Select"},{"$f":"'4. Early Years'!H11","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. Early Years",4,"EY",4.0999999999999996,7,{"$f":"'4. Early Years'!G12","v":"Please Select"},{"$f":"'4. Early Years'!H12","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,"5. Schools",5,"S",5.0999999999999996,1,{"$f":"'5. Schools'!G6","v":"Please Select"},{"$f":"'5. Schools'!H6","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,"5. Schools",5,"S",5.0999999999999996,2,{"$f":"'5. Schools'!G7","v":"Please Select"},{"$f":"'5. Schools'!H7","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,"5. Schools",5,"S",5.0999999999999996,3,{"$f":"'5. Schools'!G8","v":"Please Select"},{"$f":"'5. Schools'!H8","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,"5. Schools",5,"S",5.0999999999999996,4,{"$f":"'5. Schools'!G9","v":"Please Select"},{"$f":"'5. Schools'!H9","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,"5. Schools",5,"S",5.0999999999999996,5,{"$f":"'5. Schools'!G10","v":"Please Select"},{"$f":"'5. Schools'!H10","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,"5. Schools",5,"S",5.0999999999999996,6,{"$f":"'5. Schools'!G11","v":"Please Select"},{"$f":"'5. Schools'!H11","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,"5. Schools",5,"S",5.0999999999999996,7,{"$f":"'5. Schools'!G12","v":"Please Select"},{"$f":"'5. Schools'!H12","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,"5. Schools",5,"S",5.0999999999999996,8,{"$f":"'5. Schools'!G13","v":"Please Select"},{"$f":"'5. Schools'!H13","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,"5. Schools",5,"S",5.0999999999999996,9,{"$f":"'5. Schools'!G14","v":"Please Select"},{"$f":"'5. Schools'!H14","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. Schools",5,"S",5.0999999999999996,10,{"$f":"'5. Schools'!G15","v":"Please Select"},{"$f":"'5. Schools'!H15","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. Schools",5,"S",5.0999999999999996,11,{"$f":"'5. Schools'!G16","v":"Please Select"},{"$f":"'5. Schools'!H16","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. Schools",5,"S",5.0999999999999996,12,{"$f":"'5. Schools'!G17","v":"Please Select"},{"$f":"'5. Schools'!H17","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}]
[null,"5. Schools",5,"S",5.0999999999999996,13,{"$f":"'5. Schools'!G18","v":"Please Select"},{"$f":"'5. Schools'!H18","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}]
[null,"6. Post 16 Options",6,"P16",6.1,1,{"$f":"'6. Post 16 Options'!G6","v":"Please Select"},{"$f":"'6. Post 16 Options'!H6","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}]
[null,"6. Post 16 Options",6,"P16",6.1,2,{"$f":"'6. Post 16 Options'!G7","v":"Please Select"},{"$f":"'6. Post 16 Options'!H7","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}]
[null,"6. Post 16 Options",6,"P16",6.1,3,{"$f":"'6. Post 16 Options'!G8","v":"Please Select"},{"$f":"'6. Post 16 Options'!H8","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}]
[null,"6. Post 16 Options",6,"P16",6.1,4,{"$f":"'6. Post 16 Options'!G9","v":"Please Select"},{"$f":"'6. Post 16 Options'!H9","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}]
[null,"6. Post 16 Options",6,"P16",6.1,5,{"$f":"'6. Post 16 Options'!G10","v":"Please Select"},{"$f":"'6. Post 16 Options'!H10","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}]
[null,"6. Post 16 Options",6,"P16",6.1,6,{"$f":"'6. Post 16 Options'!G11","v":"Please Select"},{"$f":"'6. Post 16 Options'!H11","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}]
[null,"6. Post 16 Options",6,"P16",6.1,7,{"$f":"'6. Post 16 Options'!G12","v":"Please Select"},{"$f":"'6. Post 16 Options'!H12","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}]
[null,"6. Post 16 Options",6,"P16",6.1,8,{"$f":"'6. Post 16 Options'!G13","v":"Please Select"},{"$f":"'6. Post 16 Options'!H13","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}]
[null,"6. Post 16 Options",6,"P16",6.1,9,{"$f":"'6. Post 16 Options'!G14","v":"Please Select"},{"$f":"'6. Post 16 Options'!H14","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}]
[null,"6. Post 16 Options",6,"P16",6.1,10,{"$f":"'6. Post 16 Options'!G15","v":"Please Select"},{"$f":"'6. Post 16 Options'!H15","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}]

{"sheet":"Calc","index":2,"n_rows":21,"n_cols":23,"rows_kept":21,"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.1000000000000001,"CSC",{"$f":"COUNTIF(Data!$E$2:$E$99,Calc!B6)","v":8},{"$f":"COUNTIFS(Data!$E:$E,Calc!$B6,Data!$I:$I,Calc!E$4)","v":0},{"$f":"COUNTIFS(Data!$E:$E,Calc!$B6,Data!$I:$I,Calc!F$4)","v":0},{"$f":"COUNTIFS(Data!$E:$E,Calc!$B6,Data!$I:$I,Calc!G$4)","v":0},{"$f":"COUNTIFS(Data!$E:$E,Calc!$B6,Data!$I:$I,Calc!H$4)","v":8},{"$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!$E:$E,Calc!$B6,Data!$J:$J,Calc!O$4)","v":0},{"$f":"COUNTIFS(Data!$E:$E,Calc!$B6,Data!$J:$J,Calc!P$4)","v":0},{"$f":"COUNTIFS(Data!$E:$E,Calc!$B6,Data!$J:$J,Calc!Q$4)","v":0},{"$f":"COUNTIFS(Data!$E:$E,Calc!$B6,Data!$J:$J,Calc!R$4)","v":8},{"$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,2.1,"ASC",{"$f":"COUNTIF(Data!$E$2:$E$99,Calc!B7)","v":9}]
[null,3.1,"H",{"$f":"COUNTIF(Data!$E$2:$E$99,Calc!B8)","v":12}]
[null,4.0999999999999996,"EY",{"$f":"COUNTIF(Data!$E$2:$E$99,Calc!B9)","v":7}]
[null,5.0999999999999996,"S",{"$f":"COUNTIF(Data!$E$2:$E$99,Calc!B10)","v":13}]
[null,6.1,"P16",{"$f":"COUNTIF(Data!$E$2:$E$99,Calc!B11)","v":10}]
[]
[]
[null,1,"1. Children's Social Care",{"$f":"COUNTIF(Data!$C$2:$C$99,Calc!B14)","v":8},{"$f":"COUNTIFS(Data!$C$2:$C$99,Calc!$B14,Data!$I$2:$I$99,Calc!E$4)","v":0},{"$f":"COUNTIFS(Data!$C$2:$C$99,Calc!$B14,Data!$I$2:$I$99,Calc!F$4)","v":0},{"$f":"COUNTIFS(Data!$C$2:$C$99,Calc!$B14,Data!$I$2:$I$99,Calc!G$4)","v":0},{"$f":"COUNTIFS(Data!$C$2:$C$99,Calc!$B14,Data!$I$2:$I$99,Calc!H$4)","v":8},{"$f":"G14/$D14","v":0},{"$f":"F14/$D14","v":0},{"$f":"E14/$D14","v":0},{"$f":"H14/$D14","v":1},{"$f":"SUM(I14:L14)","v":1},null,{"$f":"COUNTIFS(Data!$C$2:$C$99,Calc!$B14,Data!$J$2:$J$99,Calc!O$4)","v":0},{"$f":"COUNTIFS(Data!$C$2:$C$99,Calc!$B14,Data!$J$2:$J$99,Calc!P$4)","v":0},{"$f":"COUNTIFS(Data!$C$2:$C$99,Calc!$B14,Data!$J$2:$J$99,Calc!Q$4)","v":0},{"$f":"COUNTIFS(Data!$C$2:$C$99,Calc!$B14,Data!$J$2:$J$99,Calc!R$4)","v":8},{"$f":"Q14/$D14","v":0},{"$f":"P14/$D14","v":0},{"$f":"O14/$D14","v":0},{"$f":"R14/$D14","v":1},{"$f":"SUM(S14:V14)","v":1}]
[null,2,"2. Adult Social Care",{"$f":"COUNTIF(Data!$C$2:$C$99,Calc!B15)","v":9},{"$f":"COUNTIFS(Data!$C$2:$C$99,Calc!$B15,Data!$I$2:$I$99,Calc!E$4)","v":0},{"$f":"COUNTIFS(Data!$C$2:$C$99,Calc!$B15,Data!$I$2:$I$99,Calc!F$4)","v":0},{"$f":"COUNTIFS(Data!$C$2:$C$99,Calc!$B15,Data!$I$2:$I$99,Calc!G$4)","v":0},{"$f":"COUNTIFS(Data!$C$2:$C$99,Calc!$B15,Data!$I$2:$I$99,Calc!H$4)","v":9},{"$f":"G15/$D15","v":0},{"$f":"F15/$D15","v":0},{"$f":"E15/$D15","v":0},{"$f":"H15/$D15","v":1},{"$f":"SUM(I15:L15)","v":1},null,{"$f":"COUNTIFS(Data!$C$2:$C$99,Calc!$B15,Data!$J$2:$J$99,Calc!O$4)","v":0},{"$f":"COUNTIFS(Data!$C$2:$C$99,Calc!$B15,Data!$J$2:$J$99,Calc!P$4)","v":0},{"$f":"COUNTIFS(Data!$C$2:$C$99,Calc!$B15,Data!$J$2:$J$99,Calc!Q$4)","v":0},{"$f":"COUNTIFS(Data!$C$2:$C$99,Calc!$B15,Data!$J$2:$J$99,Calc!R$4)","v":9},{"$f":"Q15/$D15","v":0},{"$f":"P15/$D15","v":0},{"$f":"O15/$D15","v":0},{"$f":"R15/$D15","v":1},{"$f":"SUM(S15:V15)","v":1}]
[null,3,"3. Health",{"$f":"COUNTIF(Data!$C$2:$C$99,Calc!B16)","v":12},{"$f":"COUNTIFS(Data!$C$2:$C$99,Calc!$B16,Data!$I$2:$I$99,Calc!E$4)","v":0},{"$f":"COUNTIFS(Data!$C$2:$C$99,Calc!$B16,Data!$I$2:$I$99,Calc!F$4)","v":0},{"$f":"COUNTIFS(Data!$C$2:$C$99,Calc!$B16,Data!$I$2:$I$99,Calc!G$4)","v":0},{"$f":"COUNTIFS(Data!$C$2:$C$99,Calc!$B16,Data!$I$2:$I$99,Calc!H$4)","v":12},0,0,0,1,1,null,{"$f":"COUNTIFS(Data!$C$2:$C$99,Calc!$B16,Data!$J$2:$J$99,Calc!O$4)","v":0},{"$f":"COUNTIFS(Data!$C$2:$C$99,Calc!$B16,Data!$J$2:$J$99,Calc!P$4)","v":0},{"$f":"COUNTIFS(Data!$C$2:$C$99,Calc!$B16,Data!$J$2:$J$99,Calc!Q$4)","v":0},{"$f":"COUNTIFS(Data!$C$2:$C$99,Calc!$B16,Data!$J$2:$J$99,Calc!R$4)","v":12},0,0,0,1,1]
[null,4,"4. Early Years",{"$f":"COUNTIF(Data!$C$2:$C$99,Calc!B17)","v":7},{"$f":"COUNTIFS(Data!$C$2:$C$99,Calc!$B17,Data!$I$2:$I$99,Calc!E$4)","v":0},{"$f":"COUNTIFS(Data!$C$2:$C$99,Calc!$B17,Data!$I$2:$I$99,Calc!F$4)","v":0},{"$f":"COUNTIFS(Data!$C$2:$C$99,Calc!$B17,Data!$I$2:$I$99,Calc!G$4)","v":0},{"$f":"COUNTIFS(Data!$C$2:$C$99,Calc!$B17,Data!$I$2:$I$99,Calc!H$4)","v":7},0,0,0,1,1,null,{"$f":"COUNTIFS(Data!$C$2:$C$99,Calc!$B17,Data!$J$2:$J$99,Calc!O$4)","v":0},{"$f":"COUNTIFS(Data!$C$2:$C$99,Calc!$B17,Data!$J$2:$J$99,Calc!P$4)","v":0},{"$f":"COUNTIFS(Data!$C$2:$C$99,Calc!$B17,Data!$J$2:$J$99,Calc!Q$4)","v":0},{"$f":"COUNTIFS(Data!$C$2:$C$99,Calc!$B17,Data!$J$2:$J$99,Calc!R$4)","v":7},0,0,0,1,1]
[null,5,"5. Schools",{"$f":"COUNTIF(Data!$C$2:$C$99,Calc!B18)","v":13},{"$f":"COUNTIFS(Data!$C$2:$C$99,Calc!$B18,Data!$I$2:$I$99,Calc!E$4)","v":0},{"$f":"COUNTIFS(Data!$C$2:$C$99,Calc!$B18,Data!$I$2:$I$99,Calc!F$4)","v":0},{"$f":"COUNTIFS(Data!$C$2:$C$99,Calc!$B18,Data!$I$2:$I$99,Calc!G$4)","v":0},{"$f":"COUNTIFS(Data!$C$2:$C$99,Calc!$B18,Data!$I$2:$I$99,Calc!H$4)","v":13},0,0,0,1,1,null,{"$f":"COUNTIFS(Data!$C$2:$C$99,Calc!$B18,Data!$J$2:$J$99,Calc!O$4)","v":0},{"$f":"COUNTIFS(Data!$C$2:$C$99,Calc!$B18,Data!$J$2:$J$99,Calc!P$4)","v":0},{"$f":"COUNTIFS(Data!$C$2:$C$99,Calc!$B18,Data!$J$2:$J$99,Calc!Q$4)","v":0},{"$f":"COUNTIFS(Data!$C$2:$C$99,Calc!$B18,Data!$J$2:$J$99,Calc!R$4)","v":13},0,0,0,1,1]
[null,6,"6. Post 16 Options",{"$f":"COUNTIF(Data!$C$2:$C$99,Calc!B19)","v":10},{"$f":"COUNTIFS(Data!$C$2:$C$99,Calc!$B19,Data!$I$2:$I$99,Calc!E$4)","v":0},{"$f":"COUNTIFS(Data!$C$2:$C$99,Calc!$B19,Data!$I$2:$I$99,Calc!F$4)","v":0},{"$f":"COUNTIFS(Data!$C$2:$C$99,Calc!$B19,Data!$I$2:$I$99,Calc!G$4)","v":0},{"$f":"COUNTIFS(Data!$C$2:$C$99,Calc!$B19,Data!$I$2:$I$99,Calc!H$4)","v":10},0,0,0,1,1,null,{"$f":"COUNTIFS(Data!$C$2:$C$99,Calc!$B19,Data!$J$2:$J$99,Calc!O$4)","v":0},{"$f":"COUNTIFS(Data!$C$2:$C$99,Calc!$B19,Data!$J$2:$J$99,Calc!P$4)","v":0},{"$f":"COUNTIFS(Data!$C$2:$C$99,Calc!$B19,Data!$J$2:$J$99,Calc!Q$4)","v":0},{"$f":"COUNTIFS(Data!$C$2:$C$99,Calc!$B19,Data!$J$2:$J$99,Calc!R$4)","v":10},0,0,0,1,1]
[]
[null,null,null,{"$f":"SUM(D6:D11)","v":59},{"$f":"SUM(E14:E19)","v":0},{"$f":"SUM(F14:F19)","v":0},0,59,{"$f":"G21/$D21","v":0},{"$f":"F21/$D21","v":0},{"$f":"E21/$D21","v":0},{"$f":"H21/$D21","v":1},{"$f":"SUM(I21:L21)","v":1},null,{"$f":"SUM(O14:O19)","v":0},0,0,59,{"$f":"Q21/$D21","v":0},{"$f":"P21/$D21","v":0},{"$f":"O21/$D21","v":0},{"$f":"R21/$D21","v":1},{"$f":"SUM(S21:V21)","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":175,"n_cols":14,"rows_kept":175,"cut":false,"hidden":false,"merged":[[1,3,1,17],[4,8,4,10],[5,8,5,10]]}
[]
[null,null,null,"PREPARATION AND TRANSITION TO ADULTHOOD 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$21:$K$21)","v":0},null,null,null,null,null,null,null,{"$f":"SUM(Calc!$S$21:$U$21)","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,"1st Audit",null,null,null,null,null,null,"2nd Audit"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"1. CHILDREN'S SOCIAL CARE"]
[]
[null,null,null,null,null,"1st Audit",null,null,null,null,null,null,null,"2nd Audit"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,{"$f":"SUM(Calc!I14:K14)","v":0},null,null,null,null,null,null,null,{"$f":"SUM(Calc!S14:U14)","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"2. ADULT SOCIAL CARE"]
[]
[null,null,null,null,null,"1st Audit",null,null,null,null,null,null,null,"2nd Audit"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,{"$f":"SUM(Calc!I15:K15)","v":0},null,null,null,null,null,null,null,{"$f":"SUM(Calc!S15:U15)","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"3. HEALTH"]
[]
[null,null,null,null,null,"1st Audit",null,null,null,null,null,null,null,"2nd Audit"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,{"$f":"SUM(Calc!I16:K16)","v":0},null,null,null,null,null,null,null,{"$f":"SUM(Calc!S16:U16)","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"4. EARLY YEARS"]
[]
[null,null,null,null,null,"1st Audit",null,null,null,null,null,null,null,"2nd Audit"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,{"$f":"SUM(Calc!I17:K17)","v":0},null,null,null,null,null,null,null,{"$f":"SUM(Calc!S17:U17)","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"5. SCHOOLS"]
[]
[null,null,null,null,null,"1st Audit",null,null,null,null,null,null,null,"2nd Audit"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,{"$f":"SUM(Calc!I18:K18)","v":0},null,null,null,null,null,null,null,{"$f":"SUM(Calc!S18:U18)","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"6. POST 16 OPTIONS"]
[]
[null,null,null,null,null,"1st Audit",null,null,null,null,null,null,null,"2nd Audit"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,{"$f":"SUM(Calc!I19:K19)","v":0},null,null,null,null,null,null,null,{"$f":"SUM(Calc!S19:U19)","v":0}]

{"sheet":"1. Children's Social Care","index":5,"n_rows":17,"n_cols":10,"rows_kept":17,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,null,"1.Children's Social Care"]
[]
[]
[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 good information and monitoring systems to allow children’s social care to forecast demand for support across PfA outcome areas?","There is an up to date database that tracks and monitors the needs of children as they move into adult life. The local PfA board is responsible for collecting and analysing the data to inform commissioning \n",null,"Please Select","Please Select","Please Select"]
[null,null,null,"Are EHC planning and review processes aligned with assessment and planning processes across health and social care for children’s and adults’ services?\n","Looked After Children and Safeguarding processes and Transition assessments under the Care Act are integrated with SEND statutory requirements ",null,"Please Select","Please Select","Please Select"]
[null,null,null,"Does the Local Offer have a well-developed Preparing for Adulthood section that clearly identifies the social care support and provision available for young people aged 14+?","Young people and parent/carers can easily use the Local Offer to find information they need about the PfA life outcomes. Local Offer peer reviews consider the quality of PfA outcomes as part of this process \n",null,"Please Select","Please Select","Please Select"]
[null,null,null,"Does children’s social care work in partnership with education, health, adult social care, schools,  housing,  employment and post-16 providers so there is a consistent vision for young people as they move into adult life with good outcomes?\n","There is a multi agency group with a shared vision articulated in a strategic  plan that focusses on PfA",null,"Please Select","Please Select","Please Select"]
[null,null,null,"Have Social Care staff  had relevant training so they know what helps disabled young people achieve good life outcomes including those with the most complex needs who don't use words to speak?\n","The workforce development programme targets all relevant groups, including Family Support workers, Personal Assistants, Community Workers, review officers and any children's multi-agency practitioners                                                                There is an ongoing programme of CPD to ensure that there is a clear understanding of the evidence base of how to achieve PfA outcomes. There are opportunities for children and adult social care practitioners to work together to develop an understanding of a 0-25 approach",null,"Please Select","Please Select","Please Select"]
[null,null,null,"Are universal services locally competent and confident to welcome all young people with SEND?","Young people and  their families tell us that they feel welcome in local colleges, youth clubs and other settings appropriate to their age and interests",null,"Please Select","Please Select","Please Select"]
[null,null,null,"Do social care staff  understand the principles of the Mental Capacity Act 2005 and apply them appropriately to enable young people to have a say in their planning and decision making?\n","An audit of plans indicate that young people have been enabled to make their own decisions and have a voice ",null,"Please Select","Please Select","Please Select"]
[null,null,null,"Are short break opportunities and personal budgets used to support progress towards the PfA outcomes (e.g. Personal Assistants trained as job coaches)?","EHC plans show how social care provision holistically supports the PfA outcomes and short break reviews consider how provision supports the development of PfA outcomes for  those using services                                                                                                                Children and young people have personal budgets that support clear PfA outcomes \n",null,"Please Select","Please Select","Please Select"]
[]
[null,null,null,"FURTHER INFORMATION:"]
[]
[null,null,null,"Children's social care checklist "]

{"sheet":"2. Adult Social Care","index":6,"n_rows":24,"n_cols":10,"rows_kept":24,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,null,"2. ADULT SOCIAL CARE"]
[]
[]
[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 partnership arrangements in place across education, health and children and adult social care for 18-25 year olds that support joint working and understanding of PfA?","There is a strategic group that oversees the ongoing development of joint working/workforce development and joint commissioning for 0-25. There is a clear pathway understood by all that shows how young people are supported by each agency in an integrated way.",null,"Please Select","Please Select","Please Select"]
[null,null,null,"Do all adult social care staff have a  clear and shared understanding of Preparing for Adulthood outcomes (Employment, Friends and  Relationships and Community participation, Independent Living, Good Health) and the evidence of what works to achieve them?\n","There is an ongoing programme of CDP to ensure that there is a clear understanding of the evidence base of how to achieve PfA outcomes. There are opportunities for children and adult social care practitioners to work together to develop an understanding of a 0-25 approach ",null,"Please Select","Please Select","Please Select"]
[null,null,null,"Are there arrangements in place to ensure that young people and their families understand adult social care eligibility from year 9? Is there a clear pathway for young people who will not be eligible for adult social care?","There is a clear and accessible description of the adult social care offer and eligibility criteria for families on the Local Offer  and which, young people and families receive at the Year 9 review.  There is a clear and accessible description of support available to young people who will not meet the eligibility criteria for adult social care.",null,"Please Select","Please Select","Please Select"]
[null,null,null,"Does Joint commissioning take place across adult and children services?","There are robust arrangements to jointly commission services for individual children and young people.  There is a mechanism for developing strategic joint commissioning \n",null,"Please Select","Please Select","Please Select"]
[null,null,null,"Are there good mechanisms for identifying children and young people who are likely to be in need of adult social care?","There is a mechanism in place to identify and plan across children and adult social care for those young people eligible for adult social care support and provision that supports an integrated transition plan from year 9\n",null,"Please Select","Please Select","Please Select"]
[null,null,null,"Do EHC plans always inform adult care and support plans?","There is a process in place to ensure a smooth handover of support from children to adult services where applicable, using the wellbeing principle in the adult support plan to build on PfA outcomes identified in the EHCP. \n",null,"Please Select","Please Select","Please Select"]
[null,null,null,"Does the Local Offer show opportunities and support  available for young people post 18 that will support them with the PfA outcomes?","The Local Offer has a clear description of PfA pathways including a link relevant Adult Information and advice. There is a clear pathway to employment for young people with SEND.",null,"Please Select","Please Select","Please Select"]
[null,null,null,"Does the IASS service effectively support young people up to the age of 25?","There is a clear pathway for IASS services to refer to Adult Advice and Support for those services who stop before then\n",null,"Please Select","Please Select","Please Select"]
[null,null,null,"Is Independent advocacy in place for eligible young people going through adult transition assessments?","a review is conducted of the numbers of young people in need of independent advocacy and how many are using it",null,"Please Select","Please Select","Please Select"]
[]
[null,null,null,"FURTHER INFORMATION:"]
[]
[null,null,null,"Interface between children act and care act"]
[]
[null,null,null,"Nice Guidance"]
[]
[null,null,null,"Joint commissioning in action"]
[]
[null,null,null,"Adult Social Care checklist"]

{"sheet":"3. Health","index":7,"n_rows":47,"n_cols":10,"rows_kept":47,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,null,"3. HEALTH"]
[]
[]
[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 is a clear system in place to identify the views and needs of young people and the views and needs of parent/carers from 14+ that inform: adults’ services, the Joint Strategic Needs Assessment (JSNA), the Joint Health and Wellbeing Strategy and commissioning to improve outcomes for young people moving into adulthood?\n","Parent- carers and young people's views are represented on the Health and Wellbeing Board and there is a system for gathering the views of young people and families about the health services that are available locally.",null,"Please Select","Please Select","Please Select"]
[null,null,null,"Is there a system in place to offer personal health budgets to young people with long term health conditions and is there information available on the Local Offer?\n","Increase in number of young people  with personal health budgets and evidence of these supporting better outcomes.",null,"Please Select","Please Select","Please Select"]
[null,null,null,"Is there a joined up decision making process that lead to holistic packages across education and social care that enable young people with complex needs or behaviours that challenge to have personalised post-16 packages that lead to full adult lives?\n","The numbers of young people with integrated education and care packages increases over time. Feedback is obtained on the quality and impact of these arrangements.",null,"Please Select","Please Select","Please Select"]
[null,null,null,"Do young people with additional needs and long term conditions have a integrated  SEN support or EHC plan that includes a health element beyond 19? (for example a health action plan) Are there arrangements in place for community health services to contribute to EHC plans? Are there arrangements in place for CHC to contribute to plans?\n","over 75% of young people have a health action plan that is referred to by relevant support staff",null,"Please Select","Please Select","Please Select"]
[null,null,null,"Do young people continue to have their health needs met as they progress into adult life ","There is a system in place to ensure young people with learning disabilities are registered with their GP from 14 and offered an annual health check\n",null,"Please Select","Please Select","Please Select"]
[null,null,null,"Is there a detailed health transition pathway  in place for young people 14-25 , that includes those with life limiting conditions that is published in the Local Offer? \n","Young people and their families with long term health conditions feedback that the information is of good quality, is comprehensive and up to date",null,"Please Select","Please Select","Please Select"]
[null,null,null,"Are universal services, such as sexual health services and substance misuse, promoted to young people with SEND with reasonable adjustment? Is this available on the Local Offer?","Clinics can demonstrate how they make reasonable adjustments and young people feedback that they can access them without difficulty, for example sexual health workshops for young people with learning disabilities. ",null,"Please Select","Please Select","Please Select"]
[null,null,null,"Do all relevant health care staff receive training in SEND legislation and the PfA outcomes and the implications for their work?","A training audit is carried out annually to identify gaps  and we are responsive to meeting identified training needs, for example a peer review process looks at the quality of outcomes in a sample of EHCP's\n",null,"Please Select","Please Select","Please Select"]
[null,null,null,"Is the PfA agenda embedded in the DMO/DCO role?","The DMO  ensures that PfA outcomes are included in wider workforce development programmes. S/he has a clear and effective  relationship with the adult health commissioner and the broader LD health team  \n",null,"Please Select","Please Select","Please Select"]
[null,null,null,"Are arrangements in place to support the young person, where required, the move from the paediatrician to the GP as the coordinator of healthcare?'\n","A planning tool such as Ready, Steady, Go is used to encourage young people to develop an understanding of their condition and how to manage it.\n",null,"Please Select","Please Select","Please Select"]
[null,null,null,"Is there a clear link between the Transforming Care plan and children with complex needs coming through transition?","A dynamic risk register is maintained for children and young people as they move into adult life, to prevent admission to ATUs.  There is a process for discharge from ATUs as early as possible.\n",null,"Please Select","Please Select","Please Select"]
[null,null,null,"Continuing Care to Continuing Health Care  is well planned and good quality arrangements are in place for those who do not qualify. ","The Children's Continuing Care aligns with the adult CHC process, and there are clear pathways for those who do not qualify for Continuing Health Care",null,"Please Select","Please Select","Please Select"]
[]
[null,null,null,"FURTHER INFORMATION:"]
[]
[null,null,null,"Statutory guidance JSNA"]
[]
[null,null,null,"Mitchell's Story"]
[]
[null,null,null,"Marianne's Story"]
[]
[null,null,null,"Southampton Ready Steady Go guidance"]
[]
[null,null,null,"Health Checklist"]
[]
[null,null,null,"NHS digital data"]
[]
[null,null,null,"NICE quality standards"]
[]
[null,null,null,"You're Welcome guidance"]
[]
[null,null,null,"SEND guidance for health care professionals"]
[]
[null,null,null,"DMO handbook"]
[]
[null,null,null,"Ready Steady Go"]
[]
[null,null,null,"Transforming Care Children and Young People guidance"]
[]
[null,null,null,"From the pond into the sea"]
[]
[null,null,null,"Moving on Well resource pack"]

{"sheet":"4. Early Years","index":8,"n_rows":22,"n_cols":10,"rows_kept":22,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,null,"4. EARLY YEARS"]
[]
[]
[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 arrangements in place to ensure that the early years workforce understands the PfA outcomes?","The outcomes in plans support children to develop friendships, independence, and early learning goals as well as supporting good health \n",null,"Please Select","Please Select","Please Select"]
[null,null,null,"Within the Early Years curriculum are there opportunities to have an understanding of the world of work?","Children are encouraged to think about work through play, resources (such as books), exploration and opportunities to hear from people doing different jobs, such as fire officers, nurses etc. \n",null,"Please Select","Please Select","Please Select"]
[null,null,null,"Do staff in Early Years settings support children to develop friendships and encourage inclusion that supports independence?\n","Staff encourage children to understand and  include their disabled peers (for example Circles of Friends) ",null,"Please Select","Please Select","Please Select"]
[null,null,null,"Is additional support used to enhance and encourage independence rather than create dependence? \n","All staff facilitate co-operative play and work to encourage independence ",null,"Please Select","Please Select","Please Select"]
[null,null,null,"Is support for children who have additional health needs discreet and delivered in a way that enhances independence and inclusion?","Therapies are integrated into curriculum activity. Children with complex needs have their needs met in an inclusive way, for example children requiring tube feeding remain in the canteen environment with the other children ",null,"Please Select","Please Select","Please Select"]
[null,null,null,"Is the Early Years workforce aware of the Local Offer and the range of opportunities that children with additional needs and their families can access?","The Local Offer describes how inclusive universal services are and the adjustments they make to include all children. It describes how targeted services support universal services to be inclusive, and the additional support provided by specialist services.\n",null,"Please Select","Please Select","Please Select"]
[null,null,null,"The LA provides an opportunity for Early Years providers to share good practice around supporting children with SEND","Early years have a network with a focus on SEND and other means of sharing information e.g. information hub or newsletter\n",null,"Please Select","Please Select","Please Select"]
[]
[null,null,null,"FURTHER INFORMATION:"]
[]
[null,null,null,"DfE outcomes framework"]
[]
[null,null,null,"Employment is Everyone's Business embedding employment in the curriculum"]
[]
[null,null,null,"Circles of Friends"]
[]
[null,null,null,"Preparing for Adulthood and the Local Offer"]

{"sheet":"5. Schools","index":9,"n_rows":54,"n_cols":10,"rows_kept":54,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,null,"5. SCHOOLS"]
[]
[]
[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 Schools represented on the local authority's PfA strategic board.","There is representation of schools at meetings with a  feedback mechanism in place.\n",null,"Please Select","Please Select","Please Select"]
[null,null,null,"Are parents involved with supporting their young people to move into adulthood by receiving timely information, advice and guidance and support to navigate the system \n","Parent feedback indicates satisfaction through the Local Offer feedback mechanism and the parent carer forum ",null,"Please Select","Please Select","Please Select"]
[null,null,null,"Are all children and young people with SEND actively encouraged to participate and achieve in all aspects of school life to prepare them for adult life and increase their independence ","Through the audit of EHC plans it is clear that friendships and participation are planned for. There is evidence that young people with SEND are included in school trips and are represented on school forums.\n",null,"Please Select","Please Select","Please Select"]
[null,null,null,"Do local schools and colleges actively work with partners to ensure an understanding of how PfA outcomes should be embedded in the curriculum so young people have a smooth transition to post 16?\n","Schools and colleges work together to plan the curriculum from year 9 and  share best practice, for example Study Programmes ",null,"Please Select","Please Select","Please Select"]
[null,null,null,"Do teaching and support staff have access to and use, good quality information, advice and support which raises aspirations for adult life? \n","When questioned school staff know where to find relevant IASS",null,"Please Select","Please Select","Please Select"]
[null,null,null,"Are all teaching and support staff confident about supporting  young people with the most complex needs to think about their aspirations and participate fully in their annual reviews.   \n","There is evidence of good preparation prior to a young person's review and the use of a wide range of methods to ensure that young people are  able to fully participate ",null,"Please Select","Please Select","Please Select"]
[null,null,null,"Are all staff aware of the Mental Capacity Act 2005 and how to apply this to ensure young people have a say in their planning and decision making from 16?\n","Review of plans demonstrate that young people have been involved in decisions made about them and from 16, are making their own decisions ",null,"Please Select","Please Select","Please Select"]
[null,null,null,"Are staff  involved in SEN reviews confident to write and review PfA outcomes in EHC plans in a person centred way?","An audit of ECH plans indicate that school staff are able to write PfA outcomes for young people and the steps towards these are clearly articulated \n",null,"Please Select","Please Select","Please Select"]
[null,null,null,"Do teaching and support staff have regular conversations with children and young people about their life aspirations and the kind of jobs they want to do?\n","When asked, children and young people can tell us what they think they want to be when they are older. They know about a range of different job types.",null,"Please Select","Please Select","Please Select"]
[null,null,null,"Do teaching and support staff offer all young people progressive steps to paid employment? ","There are work tasters and appropriate work experience for all young people as well as support to find part-time work and holiday jobs \n",null,"Please Select","Please Select","Please Select"]
[null,null,null,"Do all young people with SEND have a vocational profile from year 9?","There is evidence in plans that young people have developed a vocational profile \n",null,"Please Select","Please Select","Please Select"]
[null,null,null,"Do schools work with employment support providers to ensure young people with SEND have high quality support for work placements and internships?\n","There is a specific arrangement to ensure that children with more complex needs are able to do all work placements ",null,"Please Select","Please Select","Please Select"]
[null,null,null,"Are different housing and support options covered as part of the curriculum so that  young people have a chance to think about these options before their annual PfA  review?\n","There is an accessible description of the local housing and support offer that is shared with young people at their year 9 review ",null,"Please Select","Please Select","Please Select"]
[]
[null,null,null,"FURTHER INFORMATION:"]
[]
[null,null,null,"PfA & the Local Offer"]
[]
[null,null,null,"PfA Outcomes Tool"]
[]
[null,null,null,"Routes Into Work Guide"]
[]
[null,null,null,"IASS"]
[]
[null,null,null,"PfA review Toolkit "]
[]
[null,null,null,"Mental capacity Act "]
[]
[null,null,null,"Young People's Participation"]
[]
[null,null,null,"Routes Into Work Guide"]
[]
[null,null,null,"Employability Toolkit "]
[]
[null,null,null,"Vocational Profile workbook "]
[]
[null,null,null,"Developing Supported Internships"]
[]
[null,null,null,"Housing tool"]
[]
[null,null,null,"My Own Place"]
[]
[null,null,null,"The Care Act and PfA"]
[]
[null,null,null,"Local Offer and PfA"]
[]
[null,null,null,"Inclusive Solutions"]
[]
[null,null,null,"Equalities Act "]

{"sheet":"6. Post 16 Options","index":10,"n_rows":29,"n_cols":10,"rows_kept":29,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,null,"6. POST 16 OPTIONS"]
[]
[]
[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 post 16 providers work with schools and the LA to plan provision for all young people coming through the system?\n","There is a mechanism in place for key partners to use information from young people's plans to develop the future curriculum ",null,"Please Select","Please Select","Please Select"]
[null,null,null,"Do post 16 providers work with partners to ensure  there is a joined up, outcomes focused,  pathway for young people with SEN support/EHC plans with young people leaving school with SEN support and EHCP's that can be used effectively in post 16 provision?\n","Schools and colleges work together to plan the curriculum from year 9 and  share best practice, for example study programmes to ensure there is a clear pathway in place for young people with SEND. There is a local strategy in place for young people to experience college, for example taster days. ",null,"Please Select","Please Select","Please Select"]
[null,null,null,"Is there a clear understanding of the criteria that will be applied in relation to the retention of an EHC plan, across Education, Health and Care based on progress towards achieving PfA outcomes beyond 18?\n","The Local Offer clearly describes PfA pathways and how these can be implemented. More young people with plans are leaving education and going into work from age 19",null,"Please Select","Please Select","Please Select"]
[null,null,null,"Do post 16 providers work closely with the LA, the parent/carer forum and young people to develop the Preparation for Adulthood section of the Local Offer including the development of clear 14-25 pathways to positive life outcomes (employment;  independent living; good health and wellbeing; friends and relationships and community inclusion)?\n","The Local Offer has a clear and accessible PfA section and steps are taken to help people access information if needed",null,"Please Select","Please Select","Please Select"]
[null,null,null,"Do post 16 providers have a strong relationship with adult social care and health to work together to develop an integrated package of support that leads to fulfilling lives in the community?\n","There is a clear joint commissioning strategy in place with evidence of mutual understanding and positive working relationships between key professionals and agencies ",null,"Please Select","Please Select","Please Select"]
[null,null,null,"Do Post 16 providers work with employment support providers to ensure young people with SEND have high quality support for work placements and internships?","All young people with SEND are following high quality Study Programmes which include work placements. There is a year on year increase in the number of supported internships and supported apprenticeships that lead to employment for young people with SEND. Employment providers are asked how they work with Post 16 providers \n",null,"Please Select","Please Select","Please Select"]
[null,null,null,"Do young people own their SEN support/EHC plans and understand how the outcomes in them will support them to have good lives? Is there a robust destination tracking system in place that shows outcomes?\n","An audit of plans shows a variety of media is used to support a person centred approach and young people's participation in planning ",null,"Please Select","Please Select","Please Select"]
[null,null,null,"Are all young people supported to develop friendships and relationships, and is support in place to continue to maintain and develop these\nas they leave education?\n","An audit of plans shows outcomes around friendships, with Study Programmes providing support to develop  skills needed to maintain friendships (for example, social media, linking with community opportunities)\n",null,"Please Select","Please Select","Please Select"]
[null,null,null,"Are all young people  able to participate in the community where they will live  when they leave education? For example, can they all participate fully in volunteering opportunities and local  social activities and is information available about such opportunities on the Local Offer?\n","Colleges are aware of local community opportunities that young people with SEND can use and actively promote these and support young people to access them.",null,"Please Select","Please Select","Please Select"]
[null,null,null,"Do all young people with SEND have an opportunity to explore different housing and support options as part of the curriculum and have a chance to think about these options before their annual PfA review?\n","Study Programmes cover independent living and housing options and individual plans have clear outcomes around independent living. Young people are supported to ensure they are on the housing register from age 16. Local Area housing strategy includes all vulnerable young people with future housing need.\n",null,"Please Select","Please Select","Please Select"]
[]
[null,null,null,"FURTHER INFORMATION:"]
[]
[null,null,null,"Effective transition from school to college "]
[]
[null,null,null,"Local Offer and PfA"]
[]
[null,null,null,"Study Programme guidance "]
[]
[null,null,null,"Inclusion web "]
[]
[null,null,null,"Housing and Support fact sheets LDE"]
[]
[null,null,null,"Housing Tool Kit for plans "]