{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["School","IMPORTANT - PLEASE READ","FAQs","Schools"],"not_rendered":{"charts":0,"images":3,"macros":1,"external_links":0,"defined_names":6,"comments":2,"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":"School","index":0,"n_rows":110,"n_cols":58,"rows_kept":110,"cut":false,"hidden":false,"merged":[[2,1,2,2],[3,5,4,7],[2,13,4,15]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Need Help?:","Instructions","FAQs"]
["School No:",null,null,null,{"$f":"FAQs!Z1","v":"**You have successfully pasted the data but do check the totals in row 7 and column BE look correct**"}]
["School Name:",{"$f":"IFERROR(VLOOKUP(B2,Schools,2,FALSE),\"\")","v":""},null,null,{"$f":"FAQs!Z2","v":"Remember to email the file to eytransition@hfleducation.org"},null,null,null,null,null,null,null,null,{"$f":"IFERROR(IF(INFO(\"SYSTEM\")<>\"pcdos\", \"Please note that clicking this button will not work correctly with your operating system.  Please follow the instructions for sending the information manually.\",\"\"),\"Please note that clicking this button will not work correctly with your operating system.  Please follow the instructions for sending the information manually.\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Totals:"]
[null,null,null,null,null,"2025 Version",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Intensive",{"$f":"COUNTIF(Table1[Overall rating],\"Intensive*\")","v":0},{"$f":"CONCATENATE(\"(\",COUNTIFS(Table1[Overall rating],\"Intensive*\",Table1[Gender],\"F\"),\" F and \",COUNTIFS(Table1[Overall rating],\"Intensive*\",Table1[Gender],\"M\"),\" M)\")","v":"(0 F and 0 M)"}]
["Year cohort are entering:",null,null,null,null,null,null,null,null,"Note: all pupils to be included must be present on this sheet",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Note: all pupils to be included must be present on this sheet",null,null,null,null,null,null,null,null,"Personalised",{"$f":"COUNTIF(Table1[Overall rating],\"Person*\")","v":0},{"$f":"CONCATENATE(\"(\",COUNTIFS(Table1[Overall rating],\"Person*\",Table1[Gender],\"F\"),\" F and \",COUNTIFS(Table1[Overall rating],\"Person*\",Table1[Gender],\"M\"),\" M)\")","v":"(0 F and 0 M)"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Targeted",{"$f":"COUNTIF(Table1[Overall rating],\"Target*\")","v":0},{"$f":"CONCATENATE(\"(\",COUNTIFS(Table1[Overall rating],\"Target*\",Table1[Gender],\"F\"),\" F and \",COUNTIFS(Table1[Overall rating],\"Target*\",Table1[Gender],\"M\"),\" M)\")","v":"(0 F and 0 M)"}]
[null,null,null,null,"Totals:",{"$f":"IF(COUNTA(Table1[[Child First Name]:[Child First Name]])=0,0,COUNTIF(Table1[I1) Child Looked After (CLA) in progress],\"Y\"))","v":0},{"$f":"IF(COUNTA(Table1[[Child First Name]:[Child First Name]])=0,0,COUNTIF(Table1[I2) Child in Need (CiN) / Child Protection Plan (CPP)],\"Y\"))","v":0},{"$f":"IF(COUNTA(Table1[[Child First Name]:[Child First Name]])=0,0,COUNTIF(Table1[I3) Special Educational Needs and Disability (SEND)],\"Y\"))","v":0},{"$f":"IF(COUNTA(Table1[[Child First Name]:[Child First Name]])=0,0,COUNTIF(Table1[I4) Social, emotional and mental health needs (SEMH) (No EHCP in place)],\"Y\"))","v":0},{"$f":"IF(COUNTA(Table1[[Child First Name]:[Child First Name]])=0,0,COUNTIF(Table1[I5) Speech and language therapist (SALT) support (no EHCP in place)],\"Y\"))","v":0},{"$f":"IF(COUNTA(Table1[[Child First Name]:[Child First Name]])=0,0,COUNTIF(Table1[I6) Significant Medical Needs],\"Y\"))","v":0},{"$f":"IF(COUNTA(Table1[[Child First Name]:[Child First Name]])=0,0,COUNTIF(Table1[I7) Sensory Need],\"Y\"))","v":0},{"$f":"IF(COUNTA(Table1[[Child First Name]:[Child First Name]])=0,0,COUNTIF(Table1[I8) Close Bereavement],\"Y\"))","v":0},{"$f":"IF(COUNTA(Table1[[Child First Name]:[Child First Name]])=0,0,COUNTIF(Table1[I9) Parental Advocacy],\"Y\"))","v":0},{"$f":"IF(COUNTA(Table1[[Child First Name]:[Child First Name]])=0,0,COUNTIF(Table1[I10) Shared Parental Responsibility],\"Y\"))","v":0},{"$f":"IF(COUNTA(Table1[[Child First Name]:[Child First Name]])=0,0,COUNTIF(Table1[I11) Transient Families],\"Y\"))","v":0},{"$f":"IF(COUNTA(Table1[[Child First Name]:[Child First Name]])=0,0,COUNTIF(Table1[I12) Attendance],\"Y\"))","v":0},{"$f":"IF(COUNTA(Table1[[Child First Name]:[Child First Name]])=0,0,COUNTIF(Table1[I13) Exclusions],\"Y\"))","v":0},{"$f":"IF(COUNTA(Table1[[Child First Name]:[Child First Name]])=0,0,COUNTIF(Table1[I14) Child has been cared for at home],\"Y\"))","v":0},{"$f":"IF(COUNTA(Table1[[Child First Name]:[Child First Name]])=0,0,COUNTIF(Table1[P1) Previously looked after child (PLA)],\"Y\"))","v":0},{"$f":"IF(COUNTA(Table1[[Child First Name]:[Child First Name]])=0,0,COUNTIF(Table1[P2) Special  Guardianship Order (SGO)],\"Y\"))","v":0},{"$f":"IF(COUNTA(Table1[[Child First Name]:[Child First Name]])=0,0,COUNTIF(Table1[P3) Targeted Interventions in place],\"Y\"))","v":0},{"$f":"IF(COUNTA(Table1[[Child First Name]:[Child First Name]])=0,0,COUNTIF(Table1[P4) Emerging Special Educational Needs and Disability (SEND)],\"Y\"))","v":0},{"$f":"IF(COUNTA(Table1[[Child First Name]:[Child First Name]])=0,0,COUNTIF(Table1[P5) Social, emotional and mental health needs (SEMH)],\"Y\"))","v":0},{"$f":"IF(COUNTA(Table1[[Child First Name]:[Child First Name]])=0,0,COUNTIF(Table1[P6) Sensory Need],\"Y\"))","v":0},{"$f":"IF(COUNTA(Table1[[Child First Name]:[Child First Name]])=0,0,COUNTIF(Table1[P7) Speech and Language Therapist (SALT) support],\"Y\"))","v":0},{"$f":"IF(COUNTA(Table1[[Child First Name]:[Child First Name]])=0,0,COUNTIF(Table1[P8) Medical Needs],\"Y\"))","v":0},{"$f":"IF(COUNTA(Table1[[Child First Name]:[Child First Name]])=0,0,COUNTIF(Table1[P9) Sensory and/or physical development],\"Y\"))","v":0},{"$f":"IF(COUNTA(Table1[[Child First Name]:[Child First Name]])=0,0,COUNTIF(Table1[P10) Bereavement],\"Y\"))","v":0},{"$f":"IF(COUNTA(Table1[[Child First Name]:[Child First Name]])=0,0,COUNTIF(Table1[P11) Parental Vulnerability],\"Y\"))","v":0},{"$f":"IF(COUNTA(Table1[[Child First Name]:[Child First Name]])=0,0,COUNTIF(Table1[P12) Shared Parental Responsibility],\"Y\"))","v":0},{"$f":"IF(COUNTA(Table1[[Child First Name]:[Child First Name]])=0,0,COUNTIF(Table1[P13) Transient Families],\"Y\"))","v":0},{"$f":"IF(COUNTA(Table1[[Child First Name]:[Child First Name]])=0,0,COUNTIF(Table1[P14) More than one change in home circumstances or unavoidable daily challenges],\"Y\"))","v":0},{"$f":"IF(COUNTA(Table1[[Child First Name]:[Child First Name]])=0,0,COUNTIF(Table1[P15) English as an additional language (EAL) – no English spoken within the family],\"Y\"))","v":0},{"$f":"IF(COUNTA(Table1[[Child First Name]:[Child First Name]])=0,0,COUNTIF(Table1[P16) Delayed entry],\"Y\"))","v":0},{"$f":"IF(COUNTA(Table1[[Child First Name]:[Child First Name]])=0,0,COUNTIF(Table1[P17) Attendance],\"Y\"))","v":0},{"$f":"IF(COUNTA(Table1[[Child First Name]:[Child First Name]])=0,0,COUNTIF(Table1[T1) Social, emotional and mental health needs (SEMH)],\"Y\"))","v":0},{"$f":"IF(COUNTA(Table1[[Child First Name]:[Child First Name]])=0,0,COUNTIF(Table1[T2) Speech and Language Therapist (SALT) support],\"Y\"))","v":0},{"$f":"IF(COUNTA(Table1[[Child First Name]:[Child First Name]])=0,0,COUNTIF(Table1[T3) Sensory need],\"Y\"))","v":0},{"$f":"IF(COUNTA(Table1[[Child First Name]:[Child First Name]])=0,0,COUNTIF(Table1[T4) Minor medical needs],\"Y\"))","v":0},{"$f":"IF(COUNTA(Table1[[Child First Name]:[Child First Name]])=0,0,COUNTIF(Table1[T5) Sensory and/or physical development],\"Y\"))","v":0},{"$f":"IF(COUNTA(Table1[[Child First Name]:[Child First Name]])=0,0,COUNTIF(Table1[T6) Parental engagement],\"Y\"))","v":0},{"$f":"IF(COUNTA(Table1[[Child First Name]:[Child First Name]])=0,0,COUNTIF(Table1[T7) Shared Parental Responsibility],\"Y\"))","v":0},{"$f":"IF(COUNTA(Table1[[Child First Name]:[Child First Name]])=0,0,COUNTIF(Table1[T8) A change in home circumstance ],\"Y\"))","v":0},{"$f":"IF(COUNTA(Table1[[Child First Name]:[Child First Name]])=0,0,COUNTIF(Table1[T9) English as an Additional Language (EAL)],\"Y\"))","v":0},{"$f":"IF(COUNTA(Table1[[Child First Name]:[Child First Name]])=0,0,COUNTIF(Table1[T10) Deferred entry ],\"Y\"))","v":0},{"$f":"IF(COUNTA(Table1[[Child First Name]:[Child First Name]])=0,0,COUNTIF(Table1[T11) Early Years Pupil Premium (EYPP)],\"Y\"))","v":0},{"$f":"IF(COUNTA(Table1[[Child First Name]:[Child First Name]])=0,0,COUNTIF(Table1[T12) Funded 2 year old],\"Y\"))","v":0},{"$f":"IF(COUNTA(Table1[[Child First Name]:[Child First Name]])=0,0,COUNTIF(Table1[T13) Child born prematurely],\"Y\"))","v":0},{"$f":"IF(COUNTA(Table1[[Child First Name]:[Child First Name]])=0,0,COUNTIF(Table1[T14) Attendance],\"Y\"))","v":0},{"$f":"IF(COUNTA(Table1[[Child First Name]:[Child First Name]])=0,0,COUNTIF(Table1[T15) Out of County ],\"Y\"))","v":0},{"$f":"IF(COUNTA(Table1[[Child First Name]:[Child First Name]])=0,0,COUNTIF(Table1[T16) Child at ARE],\"Y\"))","v":0},{"$f":"SUM(Table1[Total Red])","v":0},{"$f":"SUM(Table1[Total Amber])","v":0},{"$f":"SUM(Table1[Total Yellow])","v":0},"Universal",{"$f":"COUNTIF(Table1[Overall rating],\"Universal*\")","v":0},{"$f":"CONCATENATE(\"(\",COUNTIFS(Table1[Overall rating],\"Universal*\",Table1[Gender],\"F\"),\" F and \",COUNTIFS(Table1[Overall rating],\"Universal*\",Table1[Gender],\"M\"),\" M)\")","v":"(0 F and 0 M)"}]
["Feeder School","Child First Name","Child Surname","Gender","Term of Birth","I1) Child Looked After (CLA) in progress","I2) Child in Need (CiN) / Child Protection Plan (CPP)","I3) Special Educational Needs and Disability (SEND)","I4) Social, emotional and mental health needs (SEMH) (No EHCP in place)","I5) Speech and language therapist (SALT) support (no EHCP in place)","I6) Significant Medical Needs","I7) Sensory Need","I8) Close Bereavement","I9) Parental Advocacy","I10) Shared Parental Responsibility","I11) Transient Families","I12) Attendance","I13) Exclusions","I14) Child has been cared for at home","P1) Previously looked after child (PLA)","P2) Special  Guardianship Order (SGO)","P3) Targeted Interventions in place","P4) Emerging Special Educational Needs and Disability (SEND)","P5) Social, emotional and mental health needs (SEMH)","P6) Sensory Need","P7) Speech and Language Therapist (SALT) support","P8) Medical Needs","P9) Sensory and/or physical development","P10) Bereavement","P11) Parental Vulnerability","P12) Shared Parental Responsibility","P13) Transient Families","P14) More than one change in home circumstances or unavoidable daily challenges","P15) English as an additional language (EAL) – no English spoken within the family","P16) Delayed entry","P17) Attendance","T1) Social, emotional and mental health needs (SEMH)","T2) Speech and Language Therapist (SALT) support","T3) Sensory need","T4) Minor medical needs","T5) Sensory and/or physical development","T6) Parental engagement","T7) Shared Parental Responsibility","T8) A change in home circumstance ","T9) English as an Additional Language (EAL)","T10) Deferred entry ","T11) Early Years Pupil Premium (EYPP)","T12) Funded 2 year old","T13) Child born prematurely","T14) Attendance","T15) Out of County ","T16) Child at ARE","Total Red","Total Amber","Total Yellow","Score","Overall rating"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(COUNTIF(Table1[[#This Row],[I1) Child Looked After (CLA) in progress]:[I13) Exclusions]],\"Y\")*12,\"\")","v":0},{"$f":"IFERROR(COUNTIF(Table1[[#This Row],[P1) Previously looked after child (PLA)]:[P17) Attendance]],\"Y\")*4,\"\")","v":0},{"$f":"IFERROR(COUNTIF(Table1[[#This Row],[T1) Social, emotional and mental health needs (SEMH)]:[T14) Attendance]],\"Y\")*1,\"\")","v":0},{"$f":"IF(ISBLANK(Table1[[#This Row],[Child First Name]]),\"\",SUM(Table1[[#This Row],[Total Red]:[Total Yellow]]))","v":""},{"$f":"IF(ISBLANK(Table1[[#This Row],[Child First Name]]),\"\",IF(Table1[[#This Row],[Score]]<1,\"Universal Need\",IF(Table1[[#This Row],[Score]]<4,\"Targeted Need\",IF(Table1[[#This Row],[Score]]<12,\"Personalised Need\",\"Intensive Need\"))))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(COUNTIF(Table1[[#This Row],[I1) Child Looked After (CLA) in progress]:[I13) Exclusions]],\"Y\")*12,\"\")","v":0},{"$f":"IFERROR(COUNTIF(Table1[[#This Row],[P1) Previously looked after child (PLA)]:[P17) Attendance]],\"Y\")*4,\"\")","v":0},{"$f":"IFERROR(COUNTIF(Table1[[#This Row],[T1) Social, emotional and mental health needs (SEMH)]:[T14) Attendance]],\"Y\")*1,\"\")","v":0},{"$f":"IF(ISBLANK(Table1[[#This Row],[Child First Name]]),\"\",SUM(Table1[[#This Row],[Total Red]:[Total Yellow]]))","v":""},{"$f":"IF(ISBLANK(Table1[[#This Row],[Child First Name]]),\"\",IF(Table1[[#This Row],[Score]]<1,\"Universal Need\",IF(Table1[[#This Row],[Score]]<4,\"Targeted Need\",IF(Table1[[#This Row],[Score]]<12,\"Personalised Need\",\"Intensive Need\"))))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(COUNTIF(Table1[[#This Row],[I1) Child Looked After (CLA) in progress]:[I13) Exclusions]],\"Y\")*12,\"\")","v":0},{"$f":"IFERROR(COUNTIF(Table1[[#This Row],[P1) Previously looked after child (PLA)]:[P17) Attendance]],\"Y\")*4,\"\")","v":0},{"$f":"IFERROR(COUNTIF(Table1[[#This Row],[T1) Social, emotional and mental health needs (SEMH)]:[T14) Attendance]],\"Y\")*1,\"\")","v":0},{"$f":"IF(ISBLANK(Table1[[#This Row],[Child First Name]]),\"\",SUM(Table1[[#This Row],[Total Red]:[Total Yellow]]))","v":""},{"$f":"IF(ISBLANK(Table1[[#This Row],[Child First Name]]),\"\",IF(Table1[[#This Row],[Score]]<1,\"Universal Need\",IF(Table1[[#This Row],[Score]]<4,\"Targeted Need\",IF(Table1[[#This Row],[Score]]<12,\"Personalised Need\",\"Intensive Need\"))))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(COUNTIF(Table1[[#This Row],[I1) Child Looked After (CLA) in progress]:[I13) Exclusions]],\"Y\")*12,\"\")","v":0},{"$f":"IFERROR(COUNTIF(Table1[[#This Row],[P1) Previously looked after child (PLA)]:[P17) Attendance]],\"Y\")*4,\"\")","v":0},{"$f":"IFERROR(COUNTIF(Table1[[#This Row],[T1) Social, emotional and mental health needs (SEMH)]:[T14) Attendance]],\"Y\")*1,\"\")","v":0},{"$f":"IF(ISBLANK(Table1[[#This Row],[Child First Name]]),\"\",SUM(Table1[[#This Row],[Total Red]:[Total Yellow]]))","v":""},{"$f":"IF(ISBLANK(Table1[[#This Row],[Child First Name]]),\"\",IF(Table1[[#This Row],[Score]]<1,\"Universal Need\",IF(Table1[[#This Row],[Score]]<4,\"Targeted Need\",IF(Table1[[#This Row],[Score]]<12,\"Personalised Need\",\"Intensive Need\"))))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(COUNTIF(Table1[[#This Row],[I1) Child Looked After (CLA) in progress]:[I13) Exclusions]],\"Y\")*12,\"\")","v":0},{"$f":"IFERROR(COUNTIF(Table1[[#This Row],[P1) Previously looked after child (PLA)]:[P17) Attendance]],\"Y\")*4,\"\")","v":0},{"$f":"IFERROR(COUNTIF(Table1[[#This Row],[T1) Social, emotional and mental health needs (SEMH)]:[T14) Attendance]],\"Y\")*1,\"\")","v":0},{"$f":"IF(ISBLANK(Table1[[#This Row],[Child First Name]]),\"\",SUM(Table1[[#This Row],[Total Red]:[Total Yellow]]))","v":""},{"$f":"IF(ISBLANK(Table1[[#This Row],[Child First Name]]),\"\",IF(Table1[[#This Row],[Score]]<1,\"Universal Need\",IF(Table1[[#This Row],[Score]]<4,\"Targeted Need\",IF(Table1[[#This Row],[Score]]<12,\"Personalised Need\",\"Intensive Need\"))))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(COUNTIF(Table1[[#This Row],[I1) Child Looked After (CLA) in progress]:[I13) Exclusions]],\"Y\")*12,\"\")","v":0},{"$f":"IFERROR(COUNTIF(Table1[[#This Row],[P1) Previously looked after child (PLA)]:[P17) Attendance]],\"Y\")*4,\"\")","v":0},{"$f":"IFERROR(COUNTIF(Table1[[#This Row],[T1) Social, emotional and mental health needs (SEMH)]:[T14) Attendance]],\"Y\")*1,\"\")","v":0},{"$f":"IF(ISBLANK(Table1[[#This Row],[Child First Name]]),\"\",SUM(Table1[[#This Row],[Total Red]:[Total Yellow]]))","v":""},{"$f":"IF(ISBLANK(Table1[[#This Row],[Child First Name]]),\"\",IF(Table1[[#This Row],[Score]]<1,\"Universal Need\",IF(Table1[[#This Row],[Score]]<4,\"Targeted Need\",IF(Table1[[#This Row],[Score]]<12,\"Personalised Need\",\"Intensive Need\"))))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(COUNTIF(Table1[[#This Row],[I1) Child Looked After (CLA) in progress]:[I13) Exclusions]],\"Y\")*12,\"\")","v":0},{"$f":"IFERROR(COUNTIF(Table1[[#This Row],[P1) Previously looked after child (PLA)]:[P17) Attendance]],\"Y\")*4,\"\")","v":0},{"$f":"IFERROR(COUNTIF(Table1[[#This Row],[T1) Social, emotional and mental health needs (SEMH)]:[T14) Attendance]],\"Y\")*1,\"\")","v":0},{"$f":"IF(ISBLANK(Table1[[#This Row],[Child First Name]]),\"\",SUM(Table1[[#This Row],[Total Red]:[Total Yellow]]))","v":""},{"$f":"IF(ISBLANK(Table1[[#This Row],[Child First Name]]),\"\",IF(Table1[[#This Row],[Score]]<1,\"Universal Need\",IF(Table1[[#This Row],[Score]]<4,\"Targeted Need\",IF(Table1[[#This Row],[Score]]<12,\"Personalised Need\",\"Intensive Need\"))))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(COUNTIF(Table1[[#This Row],[I1) Child Looked After (CLA) in progress]:[I13) Exclusions]],\"Y\")*12,\"\")","v":0},{"$f":"IFERROR(COUNTIF(Table1[[#This Row],[P1) Previously looked after child (PLA)]:[P17) Attendance]],\"Y\")*4,\"\")","v":0},{"$f":"IFERROR(COUNTIF(Table1[[#This Row],[T1) Social, emotional and mental health needs (SEMH)]:[T14) Attendance]],\"Y\")*1,\"\")","v":0},{"$f":"IF(ISBLANK(Table1[[#This Row],[Child First Name]]),\"\",SUM(Table1[[#This Row],[Total Red]:[Total Yellow]]))","v":""},{"$f":"IF(ISBLANK(Table1[[#This Row],[Child First Name]]),\"\",IF(Table1[[#This Row],[Score]]<1,\"Universal Need\",IF(Table1[[#This Row],[Score]]<4,\"Targeted Need\",IF(Table1[[#This Row],[Score]]<12,\"Personalised Need\",\"Intensive Need\"))))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(COUNTIF(Table1[[#This Row],[I1) Child Looked After (CLA) in progress]:[I13) Exclusions]],\"Y\")*12,\"\")","v":0},{"$f":"IFERROR(COUNTIF(Table1[[#This Row],[P1) Previously looked after child (PLA)]:[P17) Attendance]],\"Y\")*4,\"\")","v":0},{"$f":"IFERROR(COUNTIF(Table1[[#This Row],[T1) Social, emotional and mental health needs (SEMH)]:[T14) Attendance]],\"Y\")*1,\"\")","v":0},{"$f":"IF(ISBLANK(Table1[[#This Row],[Child First Name]]),\"\",SUM(Table1[[#This Row],[Total Red]:[Total Yellow]]))","v":""},{"$f":"IF(ISBLANK(Table1[[#This Row],[Child First Name]]),\"\",IF(Table1[[#This Row],[Score]]<1,\"Universal Need\",IF(Table1[[#This Row],[Score]]<4,\"Targeted Need\",IF(Table1[[#This Row],[Score]]<12,\"Personalised Need\",\"Intensive Need\"))))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(COUNTIF(Table1[[#This Row],[I1) Child Looked After (CLA) in progress]:[I13) Exclusions]],\"Y\")*12,\"\")","v":0},{"$f":"IFERROR(COUNTIF(Table1[[#This Row],[P1) Previously looked after child (PLA)]:[P17) Attendance]],\"Y\")*4,\"\")","v":0},{"$f":"IFERROR(COUNTIF(Table1[[#This Row],[T1) Social, emotional and mental health needs (SEMH)]:[T14) Attendance]],\"Y\")*1,\"\")","v":0},{"$f":"IF(ISBLANK(Table1[[#This Row],[Child First Name]]),\"\",SUM(Table1[[#This Row],[Total Red]:[Total Yellow]]))","v":""},{"$f":"IF(ISBLANK(Table1[[#This Row],[Child First Name]]),\"\",IF(Table1[[#This Row],[Score]]<1,\"Universal Need\",IF(Table1[[#This Row],[Score]]<4,\"Targeted Need\",IF(Table1[[#This Row],[Score]]<12,\"Personalised Need\",\"Intensive Need\"))))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(COUNTIF(Table1[[#This Row],[I1) Child Looked After (CLA) in progress]:[I13) Exclusions]],\"Y\")*12,\"\")","v":0},{"$f":"IFERROR(COUNTIF(Table1[[#This Row],[P1) Previously looked after child (PLA)]:[P17) Attendance]],\"Y\")*4,\"\")","v":0},{"$f":"IFERROR(COUNTIF(Table1[[#This Row],[T1) Social, emotional and mental health needs (SEMH)]:[T14) Attendance]],\"Y\")*1,\"\")","v":0},{"$f":"IF(ISBLANK(Table1[[#This Row],[Child First Name]]),\"\",SUM(Table1[[#This Row],[Total Red]:[Total Yellow]]))","v":""},{"$f":"IF(ISBLANK(Table1[[#This Row],[Child First Name]]),\"\",IF(Table1[[#This Row],[Score]]<1,\"Universal Need\",IF(Table1[[#This Row],[Score]]<4,\"Targeted Need\",IF(Table1[[#This Row],[Score]]<12,\"Personalised Need\",\"Intensive Need\"))))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(COUNTIF(Table1[[#This Row],[I1) Child Looked After (CLA) in progress]:[I13) Exclusions]],\"Y\")*12,\"\")","v":0},{"$f":"IFERROR(COUNTIF(Table1[[#This Row],[P1) Previously looked after child (PLA)]:[P17) Attendance]],\"Y\")*4,\"\")","v":0},{"$f":"IFERROR(COUNTIF(Table1[[#This Row],[T1) Social, emotional and mental health needs (SEMH)]:[T14) Attendance]],\"Y\")*1,\"\")","v":0},{"$f":"IF(ISBLANK(Table1[[#This Row],[Child First Name]]),\"\",SUM(Table1[[#This Row],[Total Red]:[Total Yellow]]))","v":""},{"$f":"IF(ISBLANK(Table1[[#This Row],[Child First Name]]),\"\",IF(Table1[[#This Row],[Score]]<1,\"Universal Need\",IF(Table1[[#This Row],[Score]]<4,\"Targeted Need\",IF(Table1[[#This Row],[Score]]<12,\"Personalised Need\",\"Intensive Need\"))))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(COUNTIF(Table1[[#This Row],[I1) Child Looked After (CLA) in progress]:[I13) Exclusions]],\"Y\")*12,\"\")","v":0},{"$f":"IFERROR(COUNTIF(Table1[[#This Row],[P1) Previously looked after child (PLA)]:[P17) Attendance]],\"Y\")*4,\"\")","v":0},{"$f":"IFERROR(COUNTIF(Table1[[#This Row],[T1) Social, emotional and mental health needs (SEMH)]:[T14) Attendance]],\"Y\")*1,\"\")","v":0},{"$f":"IF(ISBLANK(Table1[[#This Row],[Child First Name]]),\"\",SUM(Table1[[#This Row],[Total Red]:[Total Yellow]]))","v":""},{"$f":"IF(ISBLANK(Table1[[#This Row],[Child First Name]]),\"\",IF(Table1[[#This Row],[Score]]<1,\"Universal Need\",IF(Table1[[#This Row],[Score]]<4,\"Targeted Need\",IF(Table1[[#This Row],[Score]]<12,\"Personalised Need\",\"Intensive Need\"))))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(COUNTIF(Table1[[#This Row],[I1) Child Looked After (CLA) in progress]:[I13) Exclusions]],\"Y\")*12,\"\")","v":0},{"$f":"IFERROR(COUNTIF(Table1[[#This Row],[P1) Previously looked after child (PLA)]:[P17) Attendance]],\"Y\")*4,\"\")","v":0},{"$f":"IFERROR(COUNTIF(Table1[[#This Row],[T1) Social, emotional and mental health needs (SEMH)]:[T14) Attendance]],\"Y\")*1,\"\")","v":0},{"$f":"IF(ISBLANK(Table1[[#This Row],[Child First Name]]),\"\",SUM(Table1[[#This Row],[Total Red]:[Total Yellow]]))","v":""},{"$f":"IF(ISBLANK(Table1[[#This Row],[Child First Name]]),\"\",IF(Table1[[#This Row],[Score]]<1,\"Universal Need\",IF(Table1[[#This Row],[Score]]<4,\"Targeted Need\",IF(Table1[[#This Row],[Score]]<12,\"Personalised Need\",\"Intensive Need\"))))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(COUNTIF(Table1[[#This Row],[I1) Child Looked After (CLA) in progress]:[I13) Exclusions]],\"Y\")*12,\"\")","v":0},{"$f":"IFERROR(COUNTIF(Table1[[#This Row],[P1) Previously looked after child (PLA)]:[P17) Attendance]],\"Y\")*4,\"\")","v":0},{"$f":"IFERROR(COUNTIF(Table1[[#This Row],[T1) Social, emotional and mental health needs (SEMH)]:[T14) Attendance]],\"Y\")*1,\"\")","v":0},{"$f":"IF(ISBLANK(Table1[[#This Row],[Child First Name]]),\"\",SUM(Table1[[#This Row],[Total Red]:[Total Yellow]]))","v":""},{"$f":"IF(ISBLANK(Table1[[#This Row],[Child First Name]]),\"\",IF(Table1[[#This Row],[Score]]<1,\"Universal Need\",IF(Table1[[#This Row],[Score]]<4,\"Targeted Need\",IF(Table1[[#This Row],[Score]]<12,\"Personalised Need\",\"Intensive Need\"))))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(COUNTIF(Table1[[#This Row],[I1) Child Looked After (CLA) in progress]:[I13) Exclusions]],\"Y\")*12,\"\")","v":0},{"$f":"IFERROR(COUNTIF(Table1[[#This Row],[P1) Previously looked after child (PLA)]:[P17) Attendance]],\"Y\")*4,\"\")","v":0},{"$f":"IFERROR(COUNTIF(Table1[[#This Row],[T1) Social, emotional and mental health needs (SEMH)]:[T14) Attendance]],\"Y\")*1,\"\")","v":0},{"$f":"IF(ISBLANK(Table1[[#This Row],[Child First Name]]),\"\",SUM(Table1[[#This Row],[Total Red]:[Total Yellow]]))","v":""},{"$f":"IF(ISBLANK(Table1[[#This Row],[Child First Name]]),\"\",IF(Table1[[#This Row],[Score]]<1,\"Universal Need\",IF(Table1[[#This Row],[Score]]<4,\"Targeted Need\",IF(Table1[[#This Row],[Score]]<12,\"Personalised Need\",\"Intensive Need\"))))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(COUNTIF(Table1[[#This Row],[I1) Child Looked After (CLA) in progress]:[I13) Exclusions]],\"Y\")*12,\"\")","v":0},{"$f":"IFERROR(COUNTIF(Table1[[#This Row],[P1) Previously looked after child (PLA)]:[P17) Attendance]],\"Y\")*4,\"\")","v":0},{"$f":"IFERROR(COUNTIF(Table1[[#This Row],[T1) Social, emotional and mental health needs (SEMH)]:[T14) Attendance]],\"Y\")*1,\"\")","v":0},{"$f":"IF(ISBLANK(Table1[[#This Row],[Child First Name]]),\"\",SUM(Table1[[#This Row],[Total Red]:[Total Yellow]]))","v":""},{"$f":"IF(ISBLANK(Table1[[#This Row],[Child First Name]]),\"\",IF(Table1[[#This Row],[Score]]<1,\"Universal Need\",IF(Table1[[#This Row],[Score]]<4,\"Targeted Need\",IF(Table1[[#This Row],[Score]]<12,\"Personalised Need\",\"Intensive Need\"))))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(COUNTIF(Table1[[#This Row],[I1) Child Looked After (CLA) in progress]:[I13) Exclusions]],\"Y\")*12,\"\")","v":0},{"$f":"IFERROR(COUNTIF(Table1[[#This Row],[P1) Previously looked after child (PLA)]:[P17) Attendance]],\"Y\")*4,\"\")","v":0},{"$f":"IFERROR(COUNTIF(Table1[[#This Row],[T1) Social, emotional and mental health needs (SEMH)]:[T14) Attendance]],\"Y\")*1,\"\")","v":0},{"$f":"IF(ISBLANK(Table1[[#This Row],[Child First Name]]),\"\",SUM(Table1[[#This Row],[Total Red]:[Total Yellow]]))","v":""},{"$f":"IF(ISBLANK(Table1[[#This Row],[Child First Name]]),\"\",IF(Table1[[#This Row],[Score]]<1,\"Universal Need\",IF(Table1[[#This Row],[Score]]<4,\"Targeted Need\",IF(Table1[[#This Row],[Score]]<12,\"Personalised Need\",\"Intensive Need\"))))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(COUNTIF(Table1[[#This Row],[I1) Child Looked After (CLA) in progress]:[I13) Exclusions]],\"Y\")*12,\"\")","v":0},{"$f":"IFERROR(COUNTIF(Table1[[#This Row],[P1) Previously looked after child (PLA)]:[P17) Attendance]],\"Y\")*4,\"\")","v":0},{"$f":"IFERROR(COUNTIF(Table1[[#This Row],[T1) Social, emotional and mental health needs (SEMH)]:[T14) Attendance]],\"Y\")*1,\"\")","v":0},{"$f":"IF(ISBLANK(Table1[[#This Row],[Child First Name]]),\"\",SUM(Table1[[#This Row],[Total Red]:[Total Yellow]]))","v":""},{"$f":"IF(ISBLANK(Table1[[#This Row],[Child First Name]]),\"\",IF(Table1[[#This Row],[Score]]<1,\"Universal Need\",IF(Table1[[#This Row],[Score]]<4,\"Targeted Need\",IF(Table1[[#This Row],[Score]]<12,\"Personalised Need\",\"Intensive Need\"))))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(COUNTIF(Table1[[#This Row],[I1) Child Looked After (CLA) in progress]:[I13) Exclusions]],\"Y\")*12,\"\")","v":0},{"$f":"IFERROR(COUNTIF(Table1[[#This Row],[P1) Previously looked after child (PLA)]:[P17) Attendance]],\"Y\")*4,\"\")","v":0},{"$f":"IFERROR(COUNTIF(Table1[[#This Row],[T1) Social, emotional and mental health needs (SEMH)]:[T14) Attendance]],\"Y\")*1,\"\")","v":0},{"$f":"IF(ISBLANK(Table1[[#This Row],[Child First Name]]),\"\",SUM(Table1[[#This Row],[Total Red]:[Total Yellow]]))","v":""},{"$f":"IF(ISBLANK(Table1[[#This Row],[Child First Name]]),\"\",IF(Table1[[#This Row],[Score]]<1,\"Universal Need\",IF(Table1[[#This Row],[Score]]<4,\"Targeted Need\",IF(Table1[[#This Row],[Score]]<12,\"Personalised Need\",\"Intensive Need\"))))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(COUNTIF(Table1[[#This Row],[I1) Child Looked After (CLA) in progress]:[I13) Exclusions]],\"Y\")*12,\"\")","v":0},{"$f":"IFERROR(COUNTIF(Table1[[#This Row],[P1) Previously looked after child (PLA)]:[P17) Attendance]],\"Y\")*4,\"\")","v":0},{"$f":"IFERROR(COUNTIF(Table1[[#This Row],[T1) Social, emotional and mental health needs (SEMH)]:[T14) Attendance]],\"Y\")*1,\"\")","v":0},{"$f":"IF(ISBLANK(Table1[[#This Row],[Child First Name]]),\"\",SUM(Table1[[#This Row],[Total Red]:[Total Yellow]]))","v":""},{"$f":"IF(ISBLANK(Table1[[#This Row],[Child First Name]]),\"\",IF(Table1[[#This Row],[Score]]<1,\"Universal Need\",IF(Table1[[#This Row],[Score]]<4,\"Targeted Need\",IF(Table1[[#This Row],[Score]]<12,\"Personalised Need\",\"Intensive Need\"))))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(COUNTIF(Table1[[#This Row],[I1) Child Looked After (CLA) in progress]:[I13) Exclusions]],\"Y\")*12,\"\")","v":0},{"$f":"IFERROR(COUNTIF(Table1[[#This Row],[P1) Previously looked after child (PLA)]:[P17) Attendance]],\"Y\")*4,\"\")","v":0},{"$f":"IFERROR(COUNTIF(Table1[[#This Row],[T1) Social, emotional and mental health needs (SEMH)]:[T14) Attendance]],\"Y\")*1,\"\")","v":0},{"$f":"IF(ISBLANK(Table1[[#This Row],[Child First Name]]),\"\",SUM(Table1[[#This Row],[Total Red]:[Total Yellow]]))","v":""},{"$f":"IF(ISBLANK(Table1[[#This Row],[Child First Name]]),\"\",IF(Table1[[#This Row],[Score]]<1,\"Universal Need\",IF(Table1[[#This Row],[Score]]<4,\"Targeted Need\",IF(Table1[[#This Row],[Score]]<12,\"Personalised Need\",\"Intensive Need\"))))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(COUNTIF(Table1[[#This Row],[I1) Child Looked After (CLA) in progress]:[I13) Exclusions]],\"Y\")*12,\"\")","v":0},{"$f":"IFERROR(COUNTIF(Table1[[#This Row],[P1) Previously looked after child (PLA)]:[P17) Attendance]],\"Y\")*4,\"\")","v":0},{"$f":"IFERROR(COUNTIF(Table1[[#This Row],[T1) Social, emotional and mental health needs (SEMH)]:[T14) Attendance]],\"Y\")*1,\"\")","v":0},{"$f":"IF(ISBLANK(Table1[[#This Row],[Child First Name]]),\"\",SUM(Table1[[#This Row],[Total Red]:[Total Yellow]]))","v":""},{"$f":"IF(ISBLANK(Table1[[#This Row],[Child First Name]]),\"\",IF(Table1[[#This Row],[Score]]<1,\"Universal Need\",IF(Table1[[#This Row],[Score]]<4,\"Targeted Need\",IF(Table1[[#This Row],[Score]]<12,\"Personalised Need\",\"Intensive Need\"))))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(COUNTIF(Table1[[#This Row],[I1) Child Looked After (CLA) in progress]:[I13) Exclusions]],\"Y\")*12,\"\")","v":0},{"$f":"IFERROR(COUNTIF(Table1[[#This Row],[P1) Previously looked after child (PLA)]:[P17) Attendance]],\"Y\")*4,\"\")","v":0},{"$f":"IFERROR(COUNTIF(Table1[[#This Row],[T1) Social, emotional and mental health needs (SEMH)]:[T14) Attendance]],\"Y\")*1,\"\")","v":0},{"$f":"IF(ISBLANK(Table1[[#This Row],[Child First Name]]),\"\",SUM(Table1[[#This Row],[Total Red]:[Total Yellow]]))","v":""},{"$f":"IF(ISBLANK(Table1[[#This Row],[Child First Name]]),\"\",IF(Table1[[#This Row],[Score]]<1,\"Universal Need\",IF(Table1[[#This Row],[Score]]<4,\"Targeted Need\",IF(Table1[[#This Row],[Score]]<12,\"Personalised Need\",\"Intensive Need\"))))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(COUNTIF(Table1[[#This Row],[I1) Child Looked After (CLA) in progress]:[I13) Exclusions]],\"Y\")*12,\"\")","v":0},{"$f":"IFERROR(COUNTIF(Table1[[#This Row],[P1) Previously looked after child (PLA)]:[P17) Attendance]],\"Y\")*4,\"\")","v":0},{"$f":"IFERROR(COUNTIF(Table1[[#This Row],[T1) Social, emotional and mental health needs (SEMH)]:[T14) Attendance]],\"Y\")*1,\"\")","v":0},{"$f":"IF(ISBLANK(Table1[[#This Row],[Child First Name]]),\"\",SUM(Table1[[#This Row],[Total Red]:[Total Yellow]]))","v":""},{"$f":"IF(ISBLANK(Table1[[#This Row],[Child First Name]]),\"\",IF(Table1[[#This Row],[Score]]<1,\"Universal Need\",IF(Table1[[#This Row],[Score]]<4,\"Targeted Need\",IF(Table1[[#This Row],[Score]]<12,\"Personalised Need\",\"Intensive Need\"))))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(COUNTIF(Table1[[#This Row],[I1) Child Looked After (CLA) in progress]:[I13) Exclusions]],\"Y\")*12,\"\")","v":0},{"$f":"IFERROR(COUNTIF(Table1[[#This Row],[P1) Previously looked after child (PLA)]:[P17) Attendance]],\"Y\")*4,\"\")","v":0},{"$f":"IFERROR(COUNTIF(Table1[[#This Row],[T1) Social, emotional and mental health needs (SEMH)]:[T14) Attendance]],\"Y\")*1,\"\")","v":0},{"$f":"IF(ISBLANK(Table1[[#This Row],[Child First Name]]),\"\",SUM(Table1[[#This Row],[Total Red]:[Total Yellow]]))","v":""},{"$f":"IF(ISBLANK(Table1[[#This Row],[Child First Name]]),\"\",IF(Table1[[#This Row],[Score]]<1,\"Universal Need\",IF(Table1[[#This Row],[Score]]<4,\"Targeted Need\",IF(Table1[[#This Row],[Score]]<12,\"Personalised Need\",\"Intensive Need\"))))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(COUNTIF(Table1[[#This Row],[I1) Child Looked After (CLA) in progress]:[I13) Exclusions]],\"Y\")*12,\"\")","v":0},{"$f":"IFERROR(COUNTIF(Table1[[#This Row],[P1) Previously looked after child (PLA)]:[P17) Attendance]],\"Y\")*4,\"\")","v":0},{"$f":"IFERROR(COUNTIF(Table1[[#This Row],[T1) Social, emotional and mental health needs (SEMH)]:[T14) Attendance]],\"Y\")*1,\"\")","v":0},{"$f":"IF(ISBLANK(Table1[[#This Row],[Child First Name]]),\"\",SUM(Table1[[#This Row],[Total Red]:[Total Yellow]]))","v":""},{"$f":"IF(ISBLANK(Table1[[#This Row],[Child First Name]]),\"\",IF(Table1[[#This Row],[Score]]<1,\"Universal Need\",IF(Table1[[#This Row],[Score]]<4,\"Targeted Need\",IF(Table1[[#This Row],[Score]]<12,\"Personalised Need\",\"Intensive Need\"))))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(COUNTIF(Table1[[#This Row],[I1) Child Looked After (CLA) in progress]:[I13) Exclusions]],\"Y\")*12,\"\")","v":0},{"$f":"IFERROR(COUNTIF(Table1[[#This Row],[P1) Previously looked after child (PLA)]:[P17) Attendance]],\"Y\")*4,\"\")","v":0},{"$f":"IFERROR(COUNTIF(Table1[[#This Row],[T1) Social, emotional and mental health needs (SEMH)]:[T14) Attendance]],\"Y\")*1,\"\")","v":0},{"$f":"IF(ISBLANK(Table1[[#This Row],[Child First Name]]),\"\",SUM(Table1[[#This Row],[Total Red]:[Total Yellow]]))","v":""},{"$f":"IF(ISBLANK(Table1[[#This Row],[Child First Name]]),\"\",IF(Table1[[#This Row],[Score]]<1,\"Universal Need\",IF(Table1[[#This Row],[Score]]<4,\"Targeted Need\",IF(Table1[[#This Row],[Score]]<12,\"Personalised Need\",\"Intensive Need\"))))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(COUNTIF(Table1[[#This Row],[I1) Child Looked After (CLA) in progress]:[I13) Exclusions]],\"Y\")*12,\"\")","v":0},{"$f":"IFERROR(COUNTIF(Table1[[#This Row],[P1) Previously looked after child (PLA)]:[P17) Attendance]],\"Y\")*4,\"\")","v":0},{"$f":"IFERROR(COUNTIF(Table1[[#This Row],[T1) Social, emotional and mental health needs (SEMH)]:[T14) Attendance]],\"Y\")*1,\"\")","v":0},{"$f":"IF(ISBLANK(Table1[[#This Row],[Child First Name]]),\"\",SUM(Table1[[#This Row],[Total Red]:[Total Yellow]]))","v":""},{"$f":"IF(ISBLANK(Table1[[#This Row],[Child First Name]]),\"\",IF(Table1[[#This Row],[Score]]<1,\"Universal Need\",IF(Table1[[#This Row],[Score]]<4,\"Targeted Need\",IF(Table1[[#This Row],[Score]]<12,\"Personalised Need\",\"Intensive Need\"))))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(COUNTIF(Table1[[#This Row],[I1) Child Looked After (CLA) in progress]:[I13) Exclusions]],\"Y\")*12,\"\")","v":0},{"$f":"IFERROR(COUNTIF(Table1[[#This Row],[P1) Previously looked after child (PLA)]:[P17) Attendance]],\"Y\")*4,\"\")","v":0},{"$f":"IFERROR(COUNTIF(Table1[[#This Row],[T1) Social, emotional and mental health needs (SEMH)]:[T14) Attendance]],\"Y\")*1,\"\")","v":0},{"$f":"IF(ISBLANK(Table1[[#This Row],[Child First Name]]),\"\",SUM(Table1[[#This Row],[Total Red]:[Total Yellow]]))","v":""},{"$f":"IF(ISBLANK(Table1[[#This Row],[Child First Name]]),\"\",IF(Table1[[#This Row],[Score]]<1,\"Universal Need\",IF(Table1[[#This Row],[Score]]<4,\"Targeted Need\",IF(Table1[[#This Row],[Score]]<12,\"Personalised Need\",\"Intensive Need\"))))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(COUNTIF(Table1[[#This Row],[I1) Child Looked After (CLA) in progress]:[I13) Exclusions]],\"Y\")*12,\"\")","v":0},{"$f":"IFERROR(COUNTIF(Table1[[#This Row],[P1) Previously looked after child (PLA)]:[P17) Attendance]],\"Y\")*4,\"\")","v":0},{"$f":"IFERROR(COUNTIF(Table1[[#This Row],[T1) Social, emotional and mental health needs (SEMH)]:[T14) Attendance]],\"Y\")*1,\"\")","v":0},{"$f":"IF(ISBLANK(Table1[[#This Row],[Child First Name]]),\"\",SUM(Table1[[#This Row],[Total Red]:[Total Yellow]]))","v":""},{"$f":"IF(ISBLANK(Table1[[#This Row],[Child First Name]]),\"\",IF(Table1[[#This Row],[Score]]<1,\"Universal Need\",IF(Table1[[#This Row],[Score]]<4,\"Targeted Need\",IF(Table1[[#This Row],[Score]]<12,\"Personalised Need\",\"Intensive Need\"))))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(COUNTIF(Table1[[#This Row],[I1) Child Looked After (CLA) in progress]:[I13) Exclusions]],\"Y\")*12,\"\")","v":0},{"$f":"IFERROR(COUNTIF(Table1[[#This Row],[P1) Previously looked after child (PLA)]:[P17) Attendance]],\"Y\")*4,\"\")","v":0},{"$f":"IFERROR(COUNTIF(Table1[[#This Row],[T1) Social, emotional and mental health needs (SEMH)]:[T14) Attendance]],\"Y\")*1,\"\")","v":0},{"$f":"IF(ISBLANK(Table1[[#This Row],[Child First Name]]),\"\",SUM(Table1[[#This Row],[Total Red]:[Total Yellow]]))","v":""},{"$f":"IF(ISBLANK(Table1[[#This Row],[Child First Name]]),\"\",IF(Table1[[#This Row],[Score]]<1,\"Universal Need\",IF(Table1[[#This Row],[Score]]<4,\"Targeted Need\",IF(Table1[[#This Row],[Score]]<12,\"Personalised Need\",\"Intensive Need\"))))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(COUNTIF(Table1[[#This Row],[I1) Child Looked After (CLA) in progress]:[I13) Exclusions]],\"Y\")*12,\"\")","v":0},{"$f":"IFERROR(COUNTIF(Table1[[#This Row],[P1) Previously looked after child (PLA)]:[P17) Attendance]],\"Y\")*4,\"\")","v":0},{"$f":"IFERROR(COUNTIF(Table1[[#This Row],[T1) Social, emotional and mental health needs (SEMH)]:[T14) Attendance]],\"Y\")*1,\"\")","v":0},{"$f":"IF(ISBLANK(Table1[[#This Row],[Child First Name]]),\"\",SUM(Table1[[#This Row],[Total Red]:[Total Yellow]]))","v":""},{"$f":"IF(ISBLANK(Table1[[#This Row],[Child First Name]]),\"\",IF(Table1[[#This Row],[Score]]<1,\"Universal Need\",IF(Table1[[#This Row],[Score]]<4,\"Targeted Need\",IF(Table1[[#This Row],[Score]]<12,\"Personalised Need\",\"Intensive Need\"))))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(COUNTIF(Table1[[#This Row],[I1) Child Looked After (CLA) in progress]:[I13) Exclusions]],\"Y\")*12,\"\")","v":0},{"$f":"IFERROR(COUNTIF(Table1[[#This Row],[P1) Previously looked after child (PLA)]:[P17) Attendance]],\"Y\")*4,\"\")","v":0},{"$f":"IFERROR(COUNTIF(Table1[[#This Row],[T1) Social, emotional and mental health needs (SEMH)]:[T14) Attendance]],\"Y\")*1,\"\")","v":0},{"$f":"IF(ISBLANK(Table1[[#This Row],[Child First Name]]),\"\",SUM(Table1[[#This Row],[Total Red]:[Total Yellow]]))","v":""},{"$f":"IF(ISBLANK(Table1[[#This Row],[Child First Name]]),\"\",IF(Table1[[#This Row],[Score]]<1,\"Universal Need\",IF(Table1[[#This Row],[Score]]<4,\"Targeted Need\",IF(Table1[[#This Row],[Score]]<12,\"Personalised Need\",\"Intensive Need\"))))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(COUNTIF(Table1[[#This Row],[I1) Child Looked After (CLA) in progress]:[I13) Exclusions]],\"Y\")*12,\"\")","v":0},{"$f":"IFERROR(COUNTIF(Table1[[#This Row],[P1) Previously looked after child (PLA)]:[P17) Attendance]],\"Y\")*4,\"\")","v":0},{"$f":"IFERROR(COUNTIF(Table1[[#This Row],[T1) Social, emotional and mental health needs (SEMH)]:[T14) Attendance]],\"Y\")*1,\"\")","v":0},{"$f":"IF(ISBLANK(Table1[[#This Row],[Child First Name]]),\"\",SUM(Table1[[#This Row],[Total Red]:[Total Yellow]]))","v":""},{"$f":"IF(ISBLANK(Table1[[#This Row],[Child First Name]]),\"\",IF(Table1[[#This Row],[Score]]<1,\"Universal Need\",IF(Table1[[#This Row],[Score]]<4,\"Targeted Need\",IF(Table1[[#This Row],[Score]]<12,\"Personalised Need\",\"Intensive Need\"))))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(COUNTIF(Table1[[#This Row],[I1) Child Looked After (CLA) in progress]:[I13) Exclusions]],\"Y\")*12,\"\")","v":0},{"$f":"IFERROR(COUNTIF(Table1[[#This Row],[P1) Previously looked after child (PLA)]:[P17) Attendance]],\"Y\")*4,\"\")","v":0},{"$f":"IFERROR(COUNTIF(Table1[[#This Row],[T1) Social, emotional and mental health needs (SEMH)]:[T14) Attendance]],\"Y\")*1,\"\")","v":0},{"$f":"IF(ISBLANK(Table1[[#This Row],[Child First Name]]),\"\",SUM(Table1[[#This Row],[Total Red]:[Total Yellow]]))","v":""},{"$f":"IF(ISBLANK(Table1[[#This Row],[Child First Name]]),\"\",IF(Table1[[#This Row],[Score]]<1,\"Universal Need\",IF(Table1[[#This Row],[Score]]<4,\"Targeted Need\",IF(Table1[[#This Row],[Score]]<12,\"Personalised Need\",\"Intensive Need\"))))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(COUNTIF(Table1[[#This Row],[I1) Child Looked After (CLA) in progress]:[I13) Exclusions]],\"Y\")*12,\"\")","v":0},{"$f":"IFERROR(COUNTIF(Table1[[#This Row],[P1) Previously looked after child (PLA)]:[P17) Attendance]],\"Y\")*4,\"\")","v":0},{"$f":"IFERROR(COUNTIF(Table1[[#This Row],[T1) Social, emotional and mental health needs (SEMH)]:[T14) Attendance]],\"Y\")*1,\"\")","v":0},{"$f":"IF(ISBLANK(Table1[[#This Row],[Child First Name]]),\"\",SUM(Table1[[#This Row],[Total Red]:[Total Yellow]]))","v":""},{"$f":"IF(ISBLANK(Table1[[#This Row],[Child First Name]]),\"\",IF(Table1[[#This Row],[Score]]<1,\"Universal Need\",IF(Table1[[#This Row],[Score]]<4,\"Targeted Need\",IF(Table1[[#This Row],[Score]]<12,\"Personalised Need\",\"Intensive Need\"))))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(COUNTIF(Table1[[#This Row],[I1) Child Looked After (CLA) in progress]:[I13) Exclusions]],\"Y\")*12,\"\")","v":0},{"$f":"IFERROR(COUNTIF(Table1[[#This Row],[P1) Previously looked after child (PLA)]:[P17) Attendance]],\"Y\")*4,\"\")","v":0},{"$f":"IFERROR(COUNTIF(Table1[[#This Row],[T1) Social, emotional and mental health needs (SEMH)]:[T14) Attendance]],\"Y\")*1,\"\")","v":0},{"$f":"IF(ISBLANK(Table1[[#This Row],[Child First Name]]),\"\",SUM(Table1[[#This Row],[Total Red]:[Total Yellow]]))","v":""},{"$f":"IF(ISBLANK(Table1[[#This Row],[Child First Name]]),\"\",IF(Table1[[#This Row],[Score]]<1,\"Universal Need\",IF(Table1[[#This Row],[Score]]<4,\"Targeted Need\",IF(Table1[[#This Row],[Score]]<12,\"Personalised Need\",\"Intensive Need\"))))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(COUNTIF(Table1[[#This Row],[I1) Child Looked After (CLA) in progress]:[I13) Exclusions]],\"Y\")*12,\"\")","v":0},{"$f":"IFERROR(COUNTIF(Table1[[#This Row],[P1) Previously looked after child (PLA)]:[P17) Attendance]],\"Y\")*4,\"\")","v":0},{"$f":"IFERROR(COUNTIF(Table1[[#This Row],[T1) Social, emotional and mental health needs (SEMH)]:[T14) Attendance]],\"Y\")*1,\"\")","v":0},{"$f":"IF(ISBLANK(Table1[[#This Row],[Child First Name]]),\"\",SUM(Table1[[#This Row],[Total Red]:[Total Yellow]]))","v":""},{"$f":"IF(ISBLANK(Table1[[#This Row],[Child First Name]]),\"\",IF(Table1[[#This Row],[Score]]<1,\"Universal Need\",IF(Table1[[#This Row],[Score]]<4,\"Targeted Need\",IF(Table1[[#This Row],[Score]]<12,\"Personalised Need\",\"Intensive Need\"))))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(COUNTIF(Table1[[#This Row],[I1) Child Looked After (CLA) in progress]:[I13) Exclusions]],\"Y\")*12,\"\")","v":0},{"$f":"IFERROR(COUNTIF(Table1[[#This Row],[P1) Previously looked after child (PLA)]:[P17) Attendance]],\"Y\")*4,\"\")","v":0},{"$f":"IFERROR(COUNTIF(Table1[[#This Row],[T1) Social, emotional and mental health needs (SEMH)]:[T14) Attendance]],\"Y\")*1,\"\")","v":0},{"$f":"IF(ISBLANK(Table1[[#This Row],[Child First Name]]),\"\",SUM(Table1[[#This Row],[Total Red]:[Total Yellow]]))","v":""},{"$f":"IF(ISBLANK(Table1[[#This Row],[Child First Name]]),\"\",IF(Table1[[#This Row],[Score]]<1,\"Universal Need\",IF(Table1[[#This Row],[Score]]<4,\"Targeted Need\",IF(Table1[[#This Row],[Score]]<12,\"Personalised Need\",\"Intensive Need\"))))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(COUNTIF(Table1[[#This Row],[I1) Child Looked After (CLA) in progress]:[I13) Exclusions]],\"Y\")*12,\"\")","v":0},{"$f":"IFERROR(COUNTIF(Table1[[#This Row],[P1) Previously looked after child (PLA)]:[P17) Attendance]],\"Y\")*4,\"\")","v":0},{"$f":"IFERROR(COUNTIF(Table1[[#This Row],[T1) Social, emotional and mental health needs (SEMH)]:[T14) Attendance]],\"Y\")*1,\"\")","v":0},{"$f":"IF(ISBLANK(Table1[[#This Row],[Child First Name]]),\"\",SUM(Table1[[#This Row],[Total Red]:[Total Yellow]]))","v":""},{"$f":"IF(ISBLANK(Table1[[#This Row],[Child First Name]]),\"\",IF(Table1[[#This Row],[Score]]<1,\"Universal Need\",IF(Table1[[#This Row],[Score]]<4,\"Targeted Need\",IF(Table1[[#This Row],[Score]]<12,\"Personalised Need\",\"Intensive Need\"))))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(COUNTIF(Table1[[#This Row],[I1) Child Looked After (CLA) in progress]:[I13) Exclusions]],\"Y\")*12,\"\")","v":0},{"$f":"IFERROR(COUNTIF(Table1[[#This Row],[P1) Previously looked after child (PLA)]:[P17) Attendance]],\"Y\")*4,\"\")","v":0},{"$f":"IFERROR(COUNTIF(Table1[[#This Row],[T1) Social, emotional and mental health needs (SEMH)]:[T14) Attendance]],\"Y\")*1,\"\")","v":0},{"$f":"IF(ISBLANK(Table1[[#This Row],[Child First Name]]),\"\",SUM(Table1[[#This Row],[Total Red]:[Total Yellow]]))","v":""},{"$f":"IF(ISBLANK(Table1[[#This Row],[Child First Name]]),\"\",IF(Table1[[#This Row],[Score]]<1,\"Universal Need\",IF(Table1[[#This Row],[Score]]<4,\"Targeted Need\",IF(Table1[[#This Row],[Score]]<12,\"Personalised Need\",\"Intensive Need\"))))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(COUNTIF(Table1[[#This Row],[I1) Child Looked After (CLA) in progress]:[I13) Exclusions]],\"Y\")*12,\"\")","v":0},{"$f":"IFERROR(COUNTIF(Table1[[#This Row],[P1) Previously looked after child (PLA)]:[P17) Attendance]],\"Y\")*4,\"\")","v":0},{"$f":"IFERROR(COUNTIF(Table1[[#This Row],[T1) Social, emotional and mental health needs (SEMH)]:[T14) Attendance]],\"Y\")*1,\"\")","v":0},{"$f":"IF(ISBLANK(Table1[[#This Row],[Child First Name]]),\"\",SUM(Table1[[#This Row],[Total Red]:[Total Yellow]]))","v":""},{"$f":"IF(ISBLANK(Table1[[#This Row],[Child First Name]]),\"\",IF(Table1[[#This Row],[Score]]<1,\"Universal Need\",IF(Table1[[#This Row],[Score]]<4,\"Targeted Need\",IF(Table1[[#This Row],[Score]]<12,\"Personalised Need\",\"Intensive Need\"))))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(COUNTIF(Table1[[#This Row],[I1) Child Looked After (CLA) in progress]:[I13) Exclusions]],\"Y\")*12,\"\")","v":0},{"$f":"IFERROR(COUNTIF(Table1[[#This Row],[P1) Previously looked after child (PLA)]:[P17) Attendance]],\"Y\")*4,\"\")","v":0},{"$f":"IFERROR(COUNTIF(Table1[[#This Row],[T1) Social, emotional and mental health needs (SEMH)]:[T14) Attendance]],\"Y\")*1,\"\")","v":0},{"$f":"IF(ISBLANK(Table1[[#This Row],[Child First Name]]),\"\",SUM(Table1[[#This Row],[Total Red]:[Total Yellow]]))","v":""},{"$f":"IF(ISBLANK(Table1[[#This Row],[Child First Name]]),\"\",IF(Table1[[#This Row],[Score]]<1,\"Universal Need\",IF(Table1[[#This Row],[Score]]<4,\"Targeted Need\",IF(Table1[[#This Row],[Score]]<12,\"Personalised Need\",\"Intensive Need\"))))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(COUNTIF(Table1[[#This Row],[I1) Child Looked After (CLA) in progress]:[I13) Exclusions]],\"Y\")*12,\"\")","v":0},{"$f":"IFERROR(COUNTIF(Table1[[#This Row],[P1) Previously looked after child (PLA)]:[P17) Attendance]],\"Y\")*4,\"\")","v":0},{"$f":"IFERROR(COUNTIF(Table1[[#This Row],[T1) Social, emotional and mental health needs (SEMH)]:[T14) Attendance]],\"Y\")*1,\"\")","v":0},{"$f":"IF(ISBLANK(Table1[[#This Row],[Child First Name]]),\"\",SUM(Table1[[#This Row],[Total Red]:[Total Yellow]]))","v":""},{"$f":"IF(ISBLANK(Table1[[#This Row],[Child First Name]]),\"\",IF(Table1[[#This Row],[Score]]<1,\"Universal Need\",IF(Table1[[#This Row],[Score]]<4,\"Targeted Need\",IF(Table1[[#This Row],[Score]]<12,\"Personalised Need\",\"Intensive Need\"))))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(COUNTIF(Table1[[#This Row],[I1) Child Looked After (CLA) in progress]:[I13) Exclusions]],\"Y\")*12,\"\")","v":0},{"$f":"IFERROR(COUNTIF(Table1[[#This Row],[P1) Previously looked after child (PLA)]:[P17) Attendance]],\"Y\")*4,\"\")","v":0},{"$f":"IFERROR(COUNTIF(Table1[[#This Row],[T1) Social, emotional and mental health needs (SEMH)]:[T14) Attendance]],\"Y\")*1,\"\")","v":0},{"$f":"IF(ISBLANK(Table1[[#This Row],[Child First Name]]),\"\",SUM(Table1[[#This Row],[Total Red]:[Total Yellow]]))","v":""},{"$f":"IF(ISBLANK(Table1[[#This Row],[Child First Name]]),\"\",IF(Table1[[#This Row],[Score]]<1,\"Universal Need\",IF(Table1[[#This Row],[Score]]<4,\"Targeted Need\",IF(Table1[[#This Row],[Score]]<12,\"Personalised Need\",\"Intensive Need\"))))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(COUNTIF(Table1[[#This Row],[I1) Child Looked After (CLA) in progress]:[I13) Exclusions]],\"Y\")*12,\"\")","v":0},{"$f":"IFERROR(COUNTIF(Table1[[#This Row],[P1) Previously looked after child (PLA)]:[P17) Attendance]],\"Y\")*4,\"\")","v":0},{"$f":"IFERROR(COUNTIF(Table1[[#This Row],[T1) Social, emotional and mental health needs (SEMH)]:[T14) Attendance]],\"Y\")*1,\"\")","v":0},{"$f":"IF(ISBLANK(Table1[[#This Row],[Child First Name]]),\"\",SUM(Table1[[#This Row],[Total Red]:[Total Yellow]]))","v":""},{"$f":"IF(ISBLANK(Table1[[#This Row],[Child First Name]]),\"\",IF(Table1[[#This Row],[Score]]<1,\"Universal Need\",IF(Table1[[#This Row],[Score]]<4,\"Targeted Need\",IF(Table1[[#This Row],[Score]]<12,\"Personalised Need\",\"Intensive Need\"))))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(COUNTIF(Table1[[#This Row],[I1) Child Looked After (CLA) in progress]:[I13) Exclusions]],\"Y\")*12,\"\")","v":0},{"$f":"IFERROR(COUNTIF(Table1[[#This Row],[P1) Previously looked after child (PLA)]:[P17) Attendance]],\"Y\")*4,\"\")","v":0},{"$f":"IFERROR(COUNTIF(Table1[[#This Row],[T1) Social, emotional and mental health needs (SEMH)]:[T14) Attendance]],\"Y\")*1,\"\")","v":0},{"$f":"IF(ISBLANK(Table1[[#This Row],[Child First Name]]),\"\",SUM(Table1[[#This Row],[Total Red]:[Total Yellow]]))","v":""},{"$f":"IF(ISBLANK(Table1[[#This Row],[Child First Name]]),\"\",IF(Table1[[#This Row],[Score]]<1,\"Universal Need\",IF(Table1[[#This Row],[Score]]<4,\"Targeted Need\",IF(Table1[[#This Row],[Score]]<12,\"Personalised Need\",\"Intensive Need\"))))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(COUNTIF(Table1[[#This Row],[I1) Child Looked After (CLA) in progress]:[I13) Exclusions]],\"Y\")*12,\"\")","v":0},{"$f":"IFERROR(COUNTIF(Table1[[#This Row],[P1) Previously looked after child (PLA)]:[P17) Attendance]],\"Y\")*4,\"\")","v":0},{"$f":"IFERROR(COUNTIF(Table1[[#This Row],[T1) Social, emotional and mental health needs (SEMH)]:[T14) Attendance]],\"Y\")*1,\"\")","v":0},{"$f":"IF(ISBLANK(Table1[[#This Row],[Child First Name]]),\"\",SUM(Table1[[#This Row],[Total Red]:[Total Yellow]]))","v":""},{"$f":"IF(ISBLANK(Table1[[#This Row],[Child First Name]]),\"\",IF(Table1[[#This Row],[Score]]<1,\"Universal Need\",IF(Table1[[#This Row],[Score]]<4,\"Targeted Need\",IF(Table1[[#This Row],[Score]]<12,\"Personalised Need\",\"Intensive Need\"))))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(COUNTIF(Table1[[#This Row],[I1) Child Looked After (CLA) in progress]:[I13) Exclusions]],\"Y\")*12,\"\")","v":0},{"$f":"IFERROR(COUNTIF(Table1[[#This Row],[P1) Previously looked after child (PLA)]:[P17) Attendance]],\"Y\")*4,\"\")","v":0},{"$f":"IFERROR(COUNTIF(Table1[[#This Row],[T1) Social, emotional and mental health needs (SEMH)]:[T14) Attendance]],\"Y\")*1,\"\")","v":0},{"$f":"IF(ISBLANK(Table1[[#This Row],[Child First Name]]),\"\",SUM(Table1[[#This Row],[Total Red]:[Total Yellow]]))","v":""},{"$f":"IF(ISBLANK(Table1[[#This Row],[Child First Name]]),\"\",IF(Table1[[#This Row],[Score]]<1,\"Universal Need\",IF(Table1[[#This Row],[Score]]<4,\"Targeted Need\",IF(Table1[[#This Row],[Score]]<12,\"Personalised Need\",\"Intensive Need\"))))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(COUNTIF(Table1[[#This Row],[I1) Child Looked After (CLA) in progress]:[I13) Exclusions]],\"Y\")*12,\"\")","v":0},{"$f":"IFERROR(COUNTIF(Table1[[#This Row],[P1) Previously looked after child (PLA)]:[P17) Attendance]],\"Y\")*4,\"\")","v":0},{"$f":"IFERROR(COUNTIF(Table1[[#This Row],[T1) Social, emotional and mental health needs (SEMH)]:[T14) Attendance]],\"Y\")*1,\"\")","v":0},{"$f":"IF(ISBLANK(Table1[[#This Row],[Child First Name]]),\"\",SUM(Table1[[#This Row],[Total Red]:[Total Yellow]]))","v":""},{"$f":"IF(ISBLANK(Table1[[#This Row],[Child First Name]]),\"\",IF(Table1[[#This Row],[Score]]<1,\"Universal Need\",IF(Table1[[#This Row],[Score]]<4,\"Targeted Need\",IF(Table1[[#This Row],[Score]]<12,\"Personalised Need\",\"Intensive Need\"))))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(COUNTIF(Table1[[#This Row],[I1) Child Looked After (CLA) in progress]:[I13) Exclusions]],\"Y\")*12,\"\")","v":0},{"$f":"IFERROR(COUNTIF(Table1[[#This Row],[P1) Previously looked after child (PLA)]:[P17) Attendance]],\"Y\")*4,\"\")","v":0},{"$f":"IFERROR(COUNTIF(Table1[[#This Row],[T1) Social, emotional and mental health needs (SEMH)]:[T14) Attendance]],\"Y\")*1,\"\")","v":0},{"$f":"IF(ISBLANK(Table1[[#This Row],[Child First Name]]),\"\",SUM(Table1[[#This Row],[Total Red]:[Total Yellow]]))","v":""},{"$f":"IF(ISBLANK(Table1[[#This Row],[Child First Name]]),\"\",IF(Table1[[#This Row],[Score]]<1,\"Universal Need\",IF(Table1[[#This Row],[Score]]<4,\"Targeted Need\",IF(Table1[[#This Row],[Score]]<12,\"Personalised Need\",\"Intensive Need\"))))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(COUNTIF(Table1[[#This Row],[I1) Child Looked After (CLA) in progress]:[I13) Exclusions]],\"Y\")*12,\"\")","v":0},{"$f":"IFERROR(COUNTIF(Table1[[#This Row],[P1) Previously looked after child (PLA)]:[P17) Attendance]],\"Y\")*4,\"\")","v":0},{"$f":"IFERROR(COUNTIF(Table1[[#This Row],[T1) Social, emotional and mental health needs (SEMH)]:[T14) Attendance]],\"Y\")*1,\"\")","v":0},{"$f":"IF(ISBLANK(Table1[[#This Row],[Child First Name]]),\"\",SUM(Table1[[#This Row],[Total Red]:[Total Yellow]]))","v":""},{"$f":"IF(ISBLANK(Table1[[#This Row],[Child First Name]]),\"\",IF(Table1[[#This Row],[Score]]<1,\"Universal Need\",IF(Table1[[#This Row],[Score]]<4,\"Targeted Need\",IF(Table1[[#This Row],[Score]]<12,\"Personalised Need\",\"Intensive Need\"))))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(COUNTIF(Table1[[#This Row],[I1) Child Looked After (CLA) in progress]:[I13) Exclusions]],\"Y\")*12,\"\")","v":0},{"$f":"IFERROR(COUNTIF(Table1[[#This Row],[P1) Previously looked after child (PLA)]:[P17) Attendance]],\"Y\")*4,\"\")","v":0},{"$f":"IFERROR(COUNTIF(Table1[[#This Row],[T1) Social, emotional and mental health needs (SEMH)]:[T14) Attendance]],\"Y\")*1,\"\")","v":0},{"$f":"IF(ISBLANK(Table1[[#This Row],[Child First Name]]),\"\",SUM(Table1[[#This Row],[Total Red]:[Total Yellow]]))","v":""},{"$f":"IF(ISBLANK(Table1[[#This Row],[Child First Name]]),\"\",IF(Table1[[#This Row],[Score]]<1,\"Universal Need\",IF(Table1[[#This Row],[Score]]<4,\"Targeted Need\",IF(Table1[[#This Row],[Score]]<12,\"Personalised Need\",\"Intensive Need\"))))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(COUNTIF(Table1[[#This Row],[I1) Child Looked After (CLA) in progress]:[I13) Exclusions]],\"Y\")*12,\"\")","v":0},{"$f":"IFERROR(COUNTIF(Table1[[#This Row],[P1) Previously looked after child (PLA)]:[P17) Attendance]],\"Y\")*4,\"\")","v":0},{"$f":"IFERROR(COUNTIF(Table1[[#This Row],[T1) Social, emotional and mental health needs (SEMH)]:[T14) Attendance]],\"Y\")*1,\"\")","v":0},{"$f":"IF(ISBLANK(Table1[[#This Row],[Child First Name]]),\"\",SUM(Table1[[#This Row],[Total Red]:[Total Yellow]]))","v":""},{"$f":"IF(ISBLANK(Table1[[#This Row],[Child First Name]]),\"\",IF(Table1[[#This Row],[Score]]<1,\"Universal Need\",IF(Table1[[#This Row],[Score]]<4,\"Targeted Need\",IF(Table1[[#This Row],[Score]]<12,\"Personalised Need\",\"Intensive Need\"))))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(COUNTIF(Table1[[#This Row],[I1) Child Looked After (CLA) in progress]:[I13) Exclusions]],\"Y\")*12,\"\")","v":0},{"$f":"IFERROR(COUNTIF(Table1[[#This Row],[P1) Previously looked after child (PLA)]:[P17) Attendance]],\"Y\")*4,\"\")","v":0},{"$f":"IFERROR(COUNTIF(Table1[[#This Row],[T1) Social, emotional and mental health needs (SEMH)]:[T14) Attendance]],\"Y\")*1,\"\")","v":0},{"$f":"IF(ISBLANK(Table1[[#This Row],[Child First Name]]),\"\",SUM(Table1[[#This Row],[Total Red]:[Total Yellow]]))","v":""},{"$f":"IF(ISBLANK(Table1[[#This Row],[Child First Name]]),\"\",IF(Table1[[#This Row],[Score]]<1,\"Universal Need\",IF(Table1[[#This Row],[Score]]<4,\"Targeted Need\",IF(Table1[[#This Row],[Score]]<12,\"Personalised Need\",\"Intensive Need\"))))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(COUNTIF(Table1[[#This Row],[I1) Child Looked After (CLA) in progress]:[I13) Exclusions]],\"Y\")*12,\"\")","v":0},{"$f":"IFERROR(COUNTIF(Table1[[#This Row],[P1) Previously looked after child (PLA)]:[P17) Attendance]],\"Y\")*4,\"\")","v":0},{"$f":"IFERROR(COUNTIF(Table1[[#This Row],[T1) Social, emotional and mental health needs (SEMH)]:[T14) Attendance]],\"Y\")*1,\"\")","v":0},{"$f":"IF(ISBLANK(Table1[[#This Row],[Child First Name]]),\"\",SUM(Table1[[#This Row],[Total Red]:[Total Yellow]]))","v":""},{"$f":"IF(ISBLANK(Table1[[#This Row],[Child First Name]]),\"\",IF(Table1[[#This Row],[Score]]<1,\"Universal Need\",IF(Table1[[#This Row],[Score]]<4,\"Targeted Need\",IF(Table1[[#This Row],[Score]]<12,\"Personalised Need\",\"Intensive Need\"))))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(COUNTIF(Table1[[#This Row],[I1) Child Looked After (CLA) in progress]:[I13) Exclusions]],\"Y\")*12,\"\")","v":0},{"$f":"IFERROR(COUNTIF(Table1[[#This Row],[P1) Previously looked after child (PLA)]:[P17) Attendance]],\"Y\")*4,\"\")","v":0},{"$f":"IFERROR(COUNTIF(Table1[[#This Row],[T1) Social, emotional and mental health needs (SEMH)]:[T14) Attendance]],\"Y\")*1,\"\")","v":0},{"$f":"IF(ISBLANK(Table1[[#This Row],[Child First Name]]),\"\",SUM(Table1[[#This Row],[Total Red]:[Total Yellow]]))","v":""},{"$f":"IF(ISBLANK(Table1[[#This Row],[Child First Name]]),\"\",IF(Table1[[#This Row],[Score]]<1,\"Universal Need\",IF(Table1[[#This Row],[Score]]<4,\"Targeted Need\",IF(Table1[[#This Row],[Score]]<12,\"Personalised Need\",\"Intensive Need\"))))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(COUNTIF(Table1[[#This Row],[I1) Child Looked After (CLA) in progress]:[I13) Exclusions]],\"Y\")*12,\"\")","v":0},{"$f":"IFERROR(COUNTIF(Table1[[#This Row],[P1) Previously looked after child (PLA)]:[P17) Attendance]],\"Y\")*4,\"\")","v":0},{"$f":"IFERROR(COUNTIF(Table1[[#This Row],[T1) Social, emotional and mental health needs (SEMH)]:[T14) Attendance]],\"Y\")*1,\"\")","v":0},{"$f":"IF(ISBLANK(Table1[[#This Row],[Child First Name]]),\"\",SUM(Table1[[#This Row],[Total Red]:[Total Yellow]]))","v":""},{"$f":"IF(ISBLANK(Table1[[#This Row],[Child First Name]]),\"\",IF(Table1[[#This Row],[Score]]<1,\"Universal Need\",IF(Table1[[#This Row],[Score]]<4,\"Targeted Need\",IF(Table1[[#This Row],[Score]]<12,\"Personalised Need\",\"Intensive Need\"))))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(COUNTIF(Table1[[#This Row],[I1) Child Looked After (CLA) in progress]:[I13) Exclusions]],\"Y\")*12,\"\")","v":0},{"$f":"IFERROR(COUNTIF(Table1[[#This Row],[P1) Previously looked after child (PLA)]:[P17) Attendance]],\"Y\")*4,\"\")","v":0},{"$f":"IFERROR(COUNTIF(Table1[[#This Row],[T1) Social, emotional and mental health needs (SEMH)]:[T14) Attendance]],\"Y\")*1,\"\")","v":0},{"$f":"IF(ISBLANK(Table1[[#This Row],[Child First Name]]),\"\",SUM(Table1[[#This Row],[Total Red]:[Total Yellow]]))","v":""},{"$f":"IF(ISBLANK(Table1[[#This Row],[Child First Name]]),\"\",IF(Table1[[#This Row],[Score]]<1,\"Universal Need\",IF(Table1[[#This Row],[Score]]<4,\"Targeted Need\",IF(Table1[[#This Row],[Score]]<12,\"Personalised Need\",\"Intensive Need\"))))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(COUNTIF(Table1[[#This Row],[I1) Child Looked After (CLA) in progress]:[I13) Exclusions]],\"Y\")*12,\"\")","v":0},{"$f":"IFERROR(COUNTIF(Table1[[#This Row],[P1) Previously looked after child (PLA)]:[P17) Attendance]],\"Y\")*4,\"\")","v":0},{"$f":"IFERROR(COUNTIF(Table1[[#This Row],[T1) Social, emotional and mental health needs (SEMH)]:[T14) Attendance]],\"Y\")*1,\"\")","v":0},{"$f":"IF(ISBLANK(Table1[[#This Row],[Child First Name]]),\"\",SUM(Table1[[#This Row],[Total Red]:[Total Yellow]]))","v":""},{"$f":"IF(ISBLANK(Table1[[#This Row],[Child First Name]]),\"\",IF(Table1[[#This Row],[Score]]<1,\"Universal Need\",IF(Table1[[#This Row],[Score]]<4,\"Targeted Need\",IF(Table1[[#This Row],[Score]]<12,\"Personalised Need\",\"Intensive Need\"))))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(COUNTIF(Table1[[#This Row],[I1) Child Looked After (CLA) in progress]:[I13) Exclusions]],\"Y\")*12,\"\")","v":0},{"$f":"IFERROR(COUNTIF(Table1[[#This Row],[P1) Previously looked after child (PLA)]:[P17) Attendance]],\"Y\")*4,\"\")","v":0},{"$f":"IFERROR(COUNTIF(Table1[[#This Row],[T1) Social, emotional and mental health needs (SEMH)]:[T14) Attendance]],\"Y\")*1,\"\")","v":0},{"$f":"IF(ISBLANK(Table1[[#This Row],[Child First Name]]),\"\",SUM(Table1[[#This Row],[Total Red]:[Total Yellow]]))","v":""},{"$f":"IF(ISBLANK(Table1[[#This Row],[Child First Name]]),\"\",IF(Table1[[#This Row],[Score]]<1,\"Universal Need\",IF(Table1[[#This Row],[Score]]<4,\"Targeted Need\",IF(Table1[[#This Row],[Score]]<12,\"Personalised Need\",\"Intensive Need\"))))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(COUNTIF(Table1[[#This Row],[I1) Child Looked After (CLA) in progress]:[I13) Exclusions]],\"Y\")*12,\"\")","v":0},{"$f":"IFERROR(COUNTIF(Table1[[#This Row],[P1) Previously looked after child (PLA)]:[P17) Attendance]],\"Y\")*4,\"\")","v":0},{"$f":"IFERROR(COUNTIF(Table1[[#This Row],[T1) Social, emotional and mental health needs (SEMH)]:[T14) Attendance]],\"Y\")*1,\"\")","v":0},{"$f":"IF(ISBLANK(Table1[[#This Row],[Child First Name]]),\"\",SUM(Table1[[#This Row],[Total Red]:[Total Yellow]]))","v":""},{"$f":"IF(ISBLANK(Table1[[#This Row],[Child First Name]]),\"\",IF(Table1[[#This Row],[Score]]<1,\"Universal Need\",IF(Table1[[#This Row],[Score]]<4,\"Targeted Need\",IF(Table1[[#This Row],[Score]]<12,\"Personalised Need\",\"Intensive Need\"))))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(COUNTIF(Table1[[#This Row],[I1) Child Looked After (CLA) in progress]:[I13) Exclusions]],\"Y\")*12,\"\")","v":0},{"$f":"IFERROR(COUNTIF(Table1[[#This Row],[P1) Previously looked after child (PLA)]:[P17) Attendance]],\"Y\")*4,\"\")","v":0},{"$f":"IFERROR(COUNTIF(Table1[[#This Row],[T1) Social, emotional and mental health needs (SEMH)]:[T14) Attendance]],\"Y\")*1,\"\")","v":0},{"$f":"IF(ISBLANK(Table1[[#This Row],[Child First Name]]),\"\",SUM(Table1[[#This Row],[Total Red]:[Total Yellow]]))","v":""},{"$f":"IF(ISBLANK(Table1[[#This Row],[Child First Name]]),\"\",IF(Table1[[#This Row],[Score]]<1,\"Universal Need\",IF(Table1[[#This Row],[Score]]<4,\"Targeted Need\",IF(Table1[[#This Row],[Score]]<12,\"Personalised Need\",\"Intensive Need\"))))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(COUNTIF(Table1[[#This Row],[I1) Child Looked After (CLA) in progress]:[I13) Exclusions]],\"Y\")*12,\"\")","v":0},{"$f":"IFERROR(COUNTIF(Table1[[#This Row],[P1) Previously looked after child (PLA)]:[P17) Attendance]],\"Y\")*4,\"\")","v":0},{"$f":"IFERROR(COUNTIF(Table1[[#This Row],[T1) Social, emotional and mental health needs (SEMH)]:[T14) Attendance]],\"Y\")*1,\"\")","v":0},{"$f":"IF(ISBLANK(Table1[[#This Row],[Child First Name]]),\"\",SUM(Table1[[#This Row],[Total Red]:[Total Yellow]]))","v":""},{"$f":"IF(ISBLANK(Table1[[#This Row],[Child First Name]]),\"\",IF(Table1[[#This Row],[Score]]<1,\"Universal Need\",IF(Table1[[#This Row],[Score]]<4,\"Targeted Need\",IF(Table1[[#This Row],[Score]]<12,\"Personalised Need\",\"Intensive Need\"))))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(COUNTIF(Table1[[#This Row],[I1) Child Looked After (CLA) in progress]:[I13) Exclusions]],\"Y\")*12,\"\")","v":0},{"$f":"IFERROR(COUNTIF(Table1[[#This Row],[P1) Previously looked after child (PLA)]:[P17) Attendance]],\"Y\")*4,\"\")","v":0},{"$f":"IFERROR(COUNTIF(Table1[[#This Row],[T1) Social, emotional and mental health needs (SEMH)]:[T14) Attendance]],\"Y\")*1,\"\")","v":0},{"$f":"IF(ISBLANK(Table1[[#This Row],[Child First Name]]),\"\",SUM(Table1[[#This Row],[Total Red]:[Total Yellow]]))","v":""},{"$f":"IF(ISBLANK(Table1[[#This Row],[Child First Name]]),\"\",IF(Table1[[#This Row],[Score]]<1,\"Universal Need\",IF(Table1[[#This Row],[Score]]<4,\"Targeted Need\",IF(Table1[[#This Row],[Score]]<12,\"Personalised Need\",\"Intensive Need\"))))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(COUNTIF(Table1[[#This Row],[I1) Child Looked After (CLA) in progress]:[I13) Exclusions]],\"Y\")*12,\"\")","v":0},{"$f":"IFERROR(COUNTIF(Table1[[#This Row],[P1) Previously looked after child (PLA)]:[P17) Attendance]],\"Y\")*4,\"\")","v":0},{"$f":"IFERROR(COUNTIF(Table1[[#This Row],[T1) Social, emotional and mental health needs (SEMH)]:[T14) Attendance]],\"Y\")*1,\"\")","v":0},{"$f":"IF(ISBLANK(Table1[[#This Row],[Child First Name]]),\"\",SUM(Table1[[#This Row],[Total Red]:[Total Yellow]]))","v":""},{"$f":"IF(ISBLANK(Table1[[#This Row],[Child First Name]]),\"\",IF(Table1[[#This Row],[Score]]<1,\"Universal Need\",IF(Table1[[#This Row],[Score]]<4,\"Targeted Need\",IF(Table1[[#This Row],[Score]]<12,\"Personalised Need\",\"Intensive Need\"))))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(COUNTIF(Table1[[#This Row],[I1) Child Looked After (CLA) in progress]:[I13) Exclusions]],\"Y\")*12,\"\")","v":0},{"$f":"IFERROR(COUNTIF(Table1[[#This Row],[P1) Previously looked after child (PLA)]:[P17) Attendance]],\"Y\")*4,\"\")","v":0},{"$f":"IFERROR(COUNTIF(Table1[[#This Row],[T1) Social, emotional and mental health needs (SEMH)]:[T14) Attendance]],\"Y\")*1,\"\")","v":0},{"$f":"IF(ISBLANK(Table1[[#This Row],[Child First Name]]),\"\",SUM(Table1[[#This Row],[Total Red]:[Total Yellow]]))","v":""},{"$f":"IF(ISBLANK(Table1[[#This Row],[Child First Name]]),\"\",IF(Table1[[#This Row],[Score]]<1,\"Universal Need\",IF(Table1[[#This Row],[Score]]<4,\"Targeted Need\",IF(Table1[[#This Row],[Score]]<12,\"Personalised Need\",\"Intensive Need\"))))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(COUNTIF(Table1[[#This Row],[I1) Child Looked After (CLA) in progress]:[I13) Exclusions]],\"Y\")*12,\"\")","v":0},{"$f":"IFERROR(COUNTIF(Table1[[#This Row],[P1) Previously looked after child (PLA)]:[P17) Attendance]],\"Y\")*4,\"\")","v":0},{"$f":"IFERROR(COUNTIF(Table1[[#This Row],[T1) Social, emotional and mental health needs (SEMH)]:[T14) Attendance]],\"Y\")*1,\"\")","v":0},{"$f":"IF(ISBLANK(Table1[[#This Row],[Child First Name]]),\"\",SUM(Table1[[#This Row],[Total Red]:[Total Yellow]]))","v":""},{"$f":"IF(ISBLANK(Table1[[#This Row],[Child First Name]]),\"\",IF(Table1[[#This Row],[Score]]<1,\"Universal Need\",IF(Table1[[#This Row],[Score]]<4,\"Targeted Need\",IF(Table1[[#This Row],[Score]]<12,\"Personalised Need\",\"Intensive Need\"))))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(COUNTIF(Table1[[#This Row],[I1) Child Looked After (CLA) in progress]:[I13) Exclusions]],\"Y\")*12,\"\")","v":0},{"$f":"IFERROR(COUNTIF(Table1[[#This Row],[P1) Previously looked after child (PLA)]:[P17) Attendance]],\"Y\")*4,\"\")","v":0},{"$f":"IFERROR(COUNTIF(Table1[[#This Row],[T1) Social, emotional and mental health needs (SEMH)]:[T14) Attendance]],\"Y\")*1,\"\")","v":0},{"$f":"IF(ISBLANK(Table1[[#This Row],[Child First Name]]),\"\",SUM(Table1[[#This Row],[Total Red]:[Total Yellow]]))","v":""},{"$f":"IF(ISBLANK(Table1[[#This Row],[Child First Name]]),\"\",IF(Table1[[#This Row],[Score]]<1,\"Universal Need\",IF(Table1[[#This Row],[Score]]<4,\"Targeted Need\",IF(Table1[[#This Row],[Score]]<12,\"Personalised Need\",\"Intensive Need\"))))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(COUNTIF(Table1[[#This Row],[I1) Child Looked After (CLA) in progress]:[I13) Exclusions]],\"Y\")*12,\"\")","v":0},{"$f":"IFERROR(COUNTIF(Table1[[#This Row],[P1) Previously looked after child (PLA)]:[P17) Attendance]],\"Y\")*4,\"\")","v":0},{"$f":"IFERROR(COUNTIF(Table1[[#This Row],[T1) Social, emotional and mental health needs (SEMH)]:[T14) Attendance]],\"Y\")*1,\"\")","v":0},{"$f":"IF(ISBLANK(Table1[[#This Row],[Child First Name]]),\"\",SUM(Table1[[#This Row],[Total Red]:[Total Yellow]]))","v":""},{"$f":"IF(ISBLANK(Table1[[#This Row],[Child First Name]]),\"\",IF(Table1[[#This Row],[Score]]<1,\"Universal Need\",IF(Table1[[#This Row],[Score]]<4,\"Targeted Need\",IF(Table1[[#This Row],[Score]]<12,\"Personalised Need\",\"Intensive Need\"))))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(COUNTIF(Table1[[#This Row],[I1) Child Looked After (CLA) in progress]:[I13) Exclusions]],\"Y\")*12,\"\")","v":0},{"$f":"IFERROR(COUNTIF(Table1[[#This Row],[P1) Previously looked after child (PLA)]:[P17) Attendance]],\"Y\")*4,\"\")","v":0},{"$f":"IFERROR(COUNTIF(Table1[[#This Row],[T1) Social, emotional and mental health needs (SEMH)]:[T14) Attendance]],\"Y\")*1,\"\")","v":0},{"$f":"IF(ISBLANK(Table1[[#This Row],[Child First Name]]),\"\",SUM(Table1[[#This Row],[Total Red]:[Total Yellow]]))","v":""},{"$f":"IF(ISBLANK(Table1[[#This Row],[Child First Name]]),\"\",IF(Table1[[#This Row],[Score]]<1,\"Universal Need\",IF(Table1[[#This Row],[Score]]<4,\"Targeted Need\",IF(Table1[[#This Row],[Score]]<12,\"Personalised Need\",\"Intensive Need\"))))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(COUNTIF(Table1[[#This Row],[I1) Child Looked After (CLA) in progress]:[I13) Exclusions]],\"Y\")*12,\"\")","v":0},{"$f":"IFERROR(COUNTIF(Table1[[#This Row],[P1) Previously looked after child (PLA)]:[P17) Attendance]],\"Y\")*4,\"\")","v":0},{"$f":"IFERROR(COUNTIF(Table1[[#This Row],[T1) Social, emotional and mental health needs (SEMH)]:[T14) Attendance]],\"Y\")*1,\"\")","v":0},{"$f":"IF(ISBLANK(Table1[[#This Row],[Child First Name]]),\"\",SUM(Table1[[#This Row],[Total Red]:[Total Yellow]]))","v":""},{"$f":"IF(ISBLANK(Table1[[#This Row],[Child First Name]]),\"\",IF(Table1[[#This Row],[Score]]<1,\"Universal Need\",IF(Table1[[#This Row],[Score]]<4,\"Targeted Need\",IF(Table1[[#This Row],[Score]]<12,\"Personalised Need\",\"Intensive Need\"))))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(COUNTIF(Table1[[#This Row],[I1) Child Looked After (CLA) in progress]:[I13) Exclusions]],\"Y\")*12,\"\")","v":0},{"$f":"IFERROR(COUNTIF(Table1[[#This Row],[P1) Previously looked after child (PLA)]:[P17) Attendance]],\"Y\")*4,\"\")","v":0},{"$f":"IFERROR(COUNTIF(Table1[[#This Row],[T1) Social, emotional and mental health needs (SEMH)]:[T14) Attendance]],\"Y\")*1,\"\")","v":0},{"$f":"IF(ISBLANK(Table1[[#This Row],[Child First Name]]),\"\",SUM(Table1[[#This Row],[Total Red]:[Total Yellow]]))","v":""},{"$f":"IF(ISBLANK(Table1[[#This Row],[Child First Name]]),\"\",IF(Table1[[#This Row],[Score]]<1,\"Universal Need\",IF(Table1[[#This Row],[Score]]<4,\"Targeted Need\",IF(Table1[[#This Row],[Score]]<12,\"Personalised Need\",\"Intensive Need\"))))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(COUNTIF(Table1[[#This Row],[I1) Child Looked After (CLA) in progress]:[I13) Exclusions]],\"Y\")*12,\"\")","v":0},{"$f":"IFERROR(COUNTIF(Table1[[#This Row],[P1) Previously looked after child (PLA)]:[P17) Attendance]],\"Y\")*4,\"\")","v":0},{"$f":"IFERROR(COUNTIF(Table1[[#This Row],[T1) Social, emotional and mental health needs (SEMH)]:[T14) Attendance]],\"Y\")*1,\"\")","v":0},{"$f":"IF(ISBLANK(Table1[[#This Row],[Child First Name]]),\"\",SUM(Table1[[#This Row],[Total Red]:[Total Yellow]]))","v":""},{"$f":"IF(ISBLANK(Table1[[#This Row],[Child First Name]]),\"\",IF(Table1[[#This Row],[Score]]<1,\"Universal Need\",IF(Table1[[#This Row],[Score]]<4,\"Targeted Need\",IF(Table1[[#This Row],[Score]]<12,\"Personalised Need\",\"Intensive Need\"))))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(COUNTIF(Table1[[#This Row],[I1) Child Looked After (CLA) in progress]:[I13) Exclusions]],\"Y\")*12,\"\")","v":0},{"$f":"IFERROR(COUNTIF(Table1[[#This Row],[P1) Previously looked after child (PLA)]:[P17) Attendance]],\"Y\")*4,\"\")","v":0},{"$f":"IFERROR(COUNTIF(Table1[[#This Row],[T1) Social, emotional and mental health needs (SEMH)]:[T14) Attendance]],\"Y\")*1,\"\")","v":0},{"$f":"IF(ISBLANK(Table1[[#This Row],[Child First Name]]),\"\",SUM(Table1[[#This Row],[Total Red]:[Total Yellow]]))","v":""},{"$f":"IF(ISBLANK(Table1[[#This Row],[Child First Name]]),\"\",IF(Table1[[#This Row],[Score]]<1,\"Universal Need\",IF(Table1[[#This Row],[Score]]<4,\"Targeted Need\",IF(Table1[[#This Row],[Score]]<12,\"Personalised Need\",\"Intensive Need\"))))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(COUNTIF(Table1[[#This Row],[I1) Child Looked After (CLA) in progress]:[I13) Exclusions]],\"Y\")*12,\"\")","v":0},{"$f":"IFERROR(COUNTIF(Table1[[#This Row],[P1) Previously looked after child (PLA)]:[P17) Attendance]],\"Y\")*4,\"\")","v":0},{"$f":"IFERROR(COUNTIF(Table1[[#This Row],[T1) Social, emotional and mental health needs (SEMH)]:[T14) Attendance]],\"Y\")*1,\"\")","v":0},{"$f":"IF(ISBLANK(Table1[[#This Row],[Child First Name]]),\"\",SUM(Table1[[#This Row],[Total Red]:[Total Yellow]]))","v":""},{"$f":"IF(ISBLANK(Table1[[#This Row],[Child First Name]]),\"\",IF(Table1[[#This Row],[Score]]<1,\"Universal Need\",IF(Table1[[#This Row],[Score]]<4,\"Targeted Need\",IF(Table1[[#This Row],[Score]]<12,\"Personalised Need\",\"Intensive Need\"))))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(COUNTIF(Table1[[#This Row],[I1) Child Looked After (CLA) in progress]:[I13) Exclusions]],\"Y\")*12,\"\")","v":0},{"$f":"IFERROR(COUNTIF(Table1[[#This Row],[P1) Previously looked after child (PLA)]:[P17) Attendance]],\"Y\")*4,\"\")","v":0},{"$f":"IFERROR(COUNTIF(Table1[[#This Row],[T1) Social, emotional and mental health needs (SEMH)]:[T14) Attendance]],\"Y\")*1,\"\")","v":0},{"$f":"IF(ISBLANK(Table1[[#This Row],[Child First Name]]),\"\",SUM(Table1[[#This Row],[Total Red]:[Total Yellow]]))","v":""},{"$f":"IF(ISBLANK(Table1[[#This Row],[Child First Name]]),\"\",IF(Table1[[#This Row],[Score]]<1,\"Universal Need\",IF(Table1[[#This Row],[Score]]<4,\"Targeted Need\",IF(Table1[[#This Row],[Score]]<12,\"Personalised Need\",\"Intensive Need\"))))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(COUNTIF(Table1[[#This Row],[I1) Child Looked After (CLA) in progress]:[I13) Exclusions]],\"Y\")*12,\"\")","v":0},{"$f":"IFERROR(COUNTIF(Table1[[#This Row],[P1) Previously looked after child (PLA)]:[P17) Attendance]],\"Y\")*4,\"\")","v":0},{"$f":"IFERROR(COUNTIF(Table1[[#This Row],[T1) Social, emotional and mental health needs (SEMH)]:[T14) Attendance]],\"Y\")*1,\"\")","v":0},{"$f":"IF(ISBLANK(Table1[[#This Row],[Child First Name]]),\"\",SUM(Table1[[#This Row],[Total Red]:[Total Yellow]]))","v":""},{"$f":"IF(ISBLANK(Table1[[#This Row],[Child First Name]]),\"\",IF(Table1[[#This Row],[Score]]<1,\"Universal Need\",IF(Table1[[#This Row],[Score]]<4,\"Targeted Need\",IF(Table1[[#This Row],[Score]]<12,\"Personalised Need\",\"Intensive Need\"))))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(COUNTIF(Table1[[#This Row],[I1) Child Looked After (CLA) in progress]:[I13) Exclusions]],\"Y\")*12,\"\")","v":0},{"$f":"IFERROR(COUNTIF(Table1[[#This Row],[P1) Previously looked after child (PLA)]:[P17) Attendance]],\"Y\")*4,\"\")","v":0},{"$f":"IFERROR(COUNTIF(Table1[[#This Row],[T1) Social, emotional and mental health needs (SEMH)]:[T14) Attendance]],\"Y\")*1,\"\")","v":0},{"$f":"IF(ISBLANK(Table1[[#This Row],[Child First Name]]),\"\",SUM(Table1[[#This Row],[Total Red]:[Total Yellow]]))","v":""},{"$f":"IF(ISBLANK(Table1[[#This Row],[Child First Name]]),\"\",IF(Table1[[#This Row],[Score]]<1,\"Universal Need\",IF(Table1[[#This Row],[Score]]<4,\"Targeted Need\",IF(Table1[[#This Row],[Score]]<12,\"Personalised Need\",\"Intensive Need\"))))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(COUNTIF(Table1[[#This Row],[I1) Child Looked After (CLA) in progress]:[I13) Exclusions]],\"Y\")*12,\"\")","v":0},{"$f":"IFERROR(COUNTIF(Table1[[#This Row],[P1) Previously looked after child (PLA)]:[P17) Attendance]],\"Y\")*4,\"\")","v":0},{"$f":"IFERROR(COUNTIF(Table1[[#This Row],[T1) Social, emotional and mental health needs (SEMH)]:[T14) Attendance]],\"Y\")*1,\"\")","v":0},{"$f":"IF(ISBLANK(Table1[[#This Row],[Child First Name]]),\"\",SUM(Table1[[#This Row],[Total Red]:[Total Yellow]]))","v":""},{"$f":"IF(ISBLANK(Table1[[#This Row],[Child First Name]]),\"\",IF(Table1[[#This Row],[Score]]<1,\"Universal Need\",IF(Table1[[#This Row],[Score]]<4,\"Targeted Need\",IF(Table1[[#This Row],[Score]]<12,\"Personalised Need\",\"Intensive Need\"))))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(COUNTIF(Table1[[#This Row],[I1) Child Looked After (CLA) in progress]:[I13) Exclusions]],\"Y\")*12,\"\")","v":0},{"$f":"IFERROR(COUNTIF(Table1[[#This Row],[P1) Previously looked after child (PLA)]:[P17) Attendance]],\"Y\")*4,\"\")","v":0},{"$f":"IFERROR(COUNTIF(Table1[[#This Row],[T1) Social, emotional and mental health needs (SEMH)]:[T14) Attendance]],\"Y\")*1,\"\")","v":0},{"$f":"IF(ISBLANK(Table1[[#This Row],[Child First Name]]),\"\",SUM(Table1[[#This Row],[Total Red]:[Total Yellow]]))","v":""},{"$f":"IF(ISBLANK(Table1[[#This Row],[Child First Name]]),\"\",IF(Table1[[#This Row],[Score]]<1,\"Universal Need\",IF(Table1[[#This Row],[Score]]<4,\"Targeted Need\",IF(Table1[[#This Row],[Score]]<12,\"Personalised Need\",\"Intensive Need\"))))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(COUNTIF(Table1[[#This Row],[I1) Child Looked After (CLA) in progress]:[I13) Exclusions]],\"Y\")*12,\"\")","v":0},{"$f":"IFERROR(COUNTIF(Table1[[#This Row],[P1) Previously looked after child (PLA)]:[P17) Attendance]],\"Y\")*4,\"\")","v":0},{"$f":"IFERROR(COUNTIF(Table1[[#This Row],[T1) Social, emotional and mental health needs (SEMH)]:[T14) Attendance]],\"Y\")*1,\"\")","v":0},{"$f":"IF(ISBLANK(Table1[[#This Row],[Child First Name]]),\"\",SUM(Table1[[#This Row],[Total Red]:[Total Yellow]]))","v":""},{"$f":"IF(ISBLANK(Table1[[#This Row],[Child First Name]]),\"\",IF(Table1[[#This Row],[Score]]<1,\"Universal Need\",IF(Table1[[#This Row],[Score]]<4,\"Targeted Need\",IF(Table1[[#This Row],[Score]]<12,\"Personalised Need\",\"Intensive Need\"))))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(COUNTIF(Table1[[#This Row],[I1) Child Looked After (CLA) in progress]:[I13) Exclusions]],\"Y\")*12,\"\")","v":0},{"$f":"IFERROR(COUNTIF(Table1[[#This Row],[P1) Previously looked after child (PLA)]:[P17) Attendance]],\"Y\")*4,\"\")","v":0},{"$f":"IFERROR(COUNTIF(Table1[[#This Row],[T1) Social, emotional and mental health needs (SEMH)]:[T14) Attendance]],\"Y\")*1,\"\")","v":0},{"$f":"IF(ISBLANK(Table1[[#This Row],[Child First Name]]),\"\",SUM(Table1[[#This Row],[Total Red]:[Total Yellow]]))","v":""},{"$f":"IF(ISBLANK(Table1[[#This Row],[Child First Name]]),\"\",IF(Table1[[#This Row],[Score]]<1,\"Universal Need\",IF(Table1[[#This Row],[Score]]<4,\"Targeted Need\",IF(Table1[[#This Row],[Score]]<12,\"Personalised Need\",\"Intensive Need\"))))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(COUNTIF(Table1[[#This Row],[I1) Child Looked After (CLA) in progress]:[I13) Exclusions]],\"Y\")*12,\"\")","v":0},{"$f":"IFERROR(COUNTIF(Table1[[#This Row],[P1) Previously looked after child (PLA)]:[P17) Attendance]],\"Y\")*4,\"\")","v":0},{"$f":"IFERROR(COUNTIF(Table1[[#This Row],[T1) Social, emotional and mental health needs (SEMH)]:[T14) Attendance]],\"Y\")*1,\"\")","v":0},{"$f":"IF(ISBLANK(Table1[[#This Row],[Child First Name]]),\"\",SUM(Table1[[#This Row],[Total Red]:[Total Yellow]]))","v":""},{"$f":"IF(ISBLANK(Table1[[#This Row],[Child First Name]]),\"\",IF(Table1[[#This Row],[Score]]<1,\"Universal Need\",IF(Table1[[#This Row],[Score]]<4,\"Targeted Need\",IF(Table1[[#This Row],[Score]]<12,\"Personalised Need\",\"Intensive Need\"))))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(COUNTIF(Table1[[#This Row],[I1) Child Looked After (CLA) in progress]:[I13) Exclusions]],\"Y\")*12,\"\")","v":0},{"$f":"IFERROR(COUNTIF(Table1[[#This Row],[P1) Previously looked after child (PLA)]:[P17) Attendance]],\"Y\")*4,\"\")","v":0},{"$f":"IFERROR(COUNTIF(Table1[[#This Row],[T1) Social, emotional and mental health needs (SEMH)]:[T14) Attendance]],\"Y\")*1,\"\")","v":0},{"$f":"IF(ISBLANK(Table1[[#This Row],[Child First Name]]),\"\",SUM(Table1[[#This Row],[Total Red]:[Total Yellow]]))","v":""},{"$f":"IF(ISBLANK(Table1[[#This Row],[Child First Name]]),\"\",IF(Table1[[#This Row],[Score]]<1,\"Universal Need\",IF(Table1[[#This Row],[Score]]<4,\"Targeted Need\",IF(Table1[[#This Row],[Score]]<12,\"Personalised Need\",\"Intensive Need\"))))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(COUNTIF(Table1[[#This Row],[I1) Child Looked After (CLA) in progress]:[I13) Exclusions]],\"Y\")*12,\"\")","v":0},{"$f":"IFERROR(COUNTIF(Table1[[#This Row],[P1) Previously looked after child (PLA)]:[P17) Attendance]],\"Y\")*4,\"\")","v":0},{"$f":"IFERROR(COUNTIF(Table1[[#This Row],[T1) Social, emotional and mental health needs (SEMH)]:[T14) Attendance]],\"Y\")*1,\"\")","v":0},{"$f":"IF(ISBLANK(Table1[[#This Row],[Child First Name]]),\"\",SUM(Table1[[#This Row],[Total Red]:[Total Yellow]]))","v":""},{"$f":"IF(ISBLANK(Table1[[#This Row],[Child First Name]]),\"\",IF(Table1[[#This Row],[Score]]<1,\"Universal Need\",IF(Table1[[#This Row],[Score]]<4,\"Targeted Need\",IF(Table1[[#This Row],[Score]]<12,\"Personalised Need\",\"Intensive Need\"))))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(COUNTIF(Table1[[#This Row],[I1) Child Looked After (CLA) in progress]:[I13) Exclusions]],\"Y\")*12,\"\")","v":0},{"$f":"IFERROR(COUNTIF(Table1[[#This Row],[P1) Previously looked after child (PLA)]:[P17) Attendance]],\"Y\")*4,\"\")","v":0},{"$f":"IFERROR(COUNTIF(Table1[[#This Row],[T1) Social, emotional and mental health needs (SEMH)]:[T14) Attendance]],\"Y\")*1,\"\")","v":0},{"$f":"IF(ISBLANK(Table1[[#This Row],[Child First Name]]),\"\",SUM(Table1[[#This Row],[Total Red]:[Total Yellow]]))","v":""},{"$f":"IF(ISBLANK(Table1[[#This Row],[Child First Name]]),\"\",IF(Table1[[#This Row],[Score]]<1,\"Universal Need\",IF(Table1[[#This Row],[Score]]<4,\"Targeted Need\",IF(Table1[[#This Row],[Score]]<12,\"Personalised Need\",\"Intensive Need\"))))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(COUNTIF(Table1[[#This Row],[I1) Child Looked After (CLA) in progress]:[I13) Exclusions]],\"Y\")*12,\"\")","v":0},{"$f":"IFERROR(COUNTIF(Table1[[#This Row],[P1) Previously looked after child (PLA)]:[P17) Attendance]],\"Y\")*4,\"\")","v":0},{"$f":"IFERROR(COUNTIF(Table1[[#This Row],[T1) Social, emotional and mental health needs (SEMH)]:[T14) Attendance]],\"Y\")*1,\"\")","v":0},{"$f":"IF(ISBLANK(Table1[[#This Row],[Child First Name]]),\"\",SUM(Table1[[#This Row],[Total Red]:[Total Yellow]]))","v":""},{"$f":"IF(ISBLANK(Table1[[#This Row],[Child First Name]]),\"\",IF(Table1[[#This Row],[Score]]<1,\"Universal Need\",IF(Table1[[#This Row],[Score]]<4,\"Targeted Need\",IF(Table1[[#This Row],[Score]]<12,\"Personalised Need\",\"Intensive Need\"))))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(COUNTIF(Table1[[#This Row],[I1) Child Looked After (CLA) in progress]:[I13) Exclusions]],\"Y\")*12,\"\")","v":0},{"$f":"IFERROR(COUNTIF(Table1[[#This Row],[P1) Previously looked after child (PLA)]:[P17) Attendance]],\"Y\")*4,\"\")","v":0},{"$f":"IFERROR(COUNTIF(Table1[[#This Row],[T1) Social, emotional and mental health needs (SEMH)]:[T14) Attendance]],\"Y\")*1,\"\")","v":0},{"$f":"IF(ISBLANK(Table1[[#This Row],[Child First Name]]),\"\",SUM(Table1[[#This Row],[Total Red]:[Total Yellow]]))","v":""},{"$f":"IF(ISBLANK(Table1[[#This Row],[Child First Name]]),\"\",IF(Table1[[#This Row],[Score]]<1,\"Universal Need\",IF(Table1[[#This Row],[Score]]<4,\"Targeted Need\",IF(Table1[[#This Row],[Score]]<12,\"Personalised Need\",\"Intensive Need\"))))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(COUNTIF(Table1[[#This Row],[I1) Child Looked After (CLA) in progress]:[I13) Exclusions]],\"Y\")*12,\"\")","v":0},{"$f":"IFERROR(COUNTIF(Table1[[#This Row],[P1) Previously looked after child (PLA)]:[P17) Attendance]],\"Y\")*4,\"\")","v":0},{"$f":"IFERROR(COUNTIF(Table1[[#This Row],[T1) Social, emotional and mental health needs (SEMH)]:[T14) Attendance]],\"Y\")*1,\"\")","v":0},{"$f":"IF(ISBLANK(Table1[[#This Row],[Child First Name]]),\"\",SUM(Table1[[#This Row],[Total Red]:[Total Yellow]]))","v":""},{"$f":"IF(ISBLANK(Table1[[#This Row],[Child First Name]]),\"\",IF(Table1[[#This Row],[Score]]<1,\"Universal Need\",IF(Table1[[#This Row],[Score]]<4,\"Targeted Need\",IF(Table1[[#This Row],[Score]]<12,\"Personalised Need\",\"Intensive Need\"))))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(COUNTIF(Table1[[#This Row],[I1) Child Looked After (CLA) in progress]:[I13) Exclusions]],\"Y\")*12,\"\")","v":0},{"$f":"IFERROR(COUNTIF(Table1[[#This Row],[P1) Previously looked after child (PLA)]:[P17) Attendance]],\"Y\")*4,\"\")","v":0},{"$f":"IFERROR(COUNTIF(Table1[[#This Row],[T1) Social, emotional and mental health needs (SEMH)]:[T14) Attendance]],\"Y\")*1,\"\")","v":0},{"$f":"IF(ISBLANK(Table1[[#This Row],[Child First Name]]),\"\",SUM(Table1[[#This Row],[Total Red]:[Total Yellow]]))","v":""},{"$f":"IF(ISBLANK(Table1[[#This Row],[Child First Name]]),\"\",IF(Table1[[#This Row],[Score]]<1,\"Universal Need\",IF(Table1[[#This Row],[Score]]<4,\"Targeted Need\",IF(Table1[[#This Row],[Score]]<12,\"Personalised Need\",\"Intensive Need\"))))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(COUNTIF(Table1[[#This Row],[I1) Child Looked After (CLA) in progress]:[I13) Exclusions]],\"Y\")*12,\"\")","v":0},{"$f":"IFERROR(COUNTIF(Table1[[#This Row],[P1) Previously looked after child (PLA)]:[P17) Attendance]],\"Y\")*4,\"\")","v":0},{"$f":"IFERROR(COUNTIF(Table1[[#This Row],[T1) Social, emotional and mental health needs (SEMH)]:[T14) Attendance]],\"Y\")*1,\"\")","v":0},{"$f":"IF(ISBLANK(Table1[[#This Row],[Child First Name]]),\"\",SUM(Table1[[#This Row],[Total Red]:[Total Yellow]]))","v":""},{"$f":"IF(ISBLANK(Table1[[#This Row],[Child First Name]]),\"\",IF(Table1[[#This Row],[Score]]<1,\"Universal Need\",IF(Table1[[#This Row],[Score]]<4,\"Targeted Need\",IF(Table1[[#This Row],[Score]]<12,\"Personalised Need\",\"Intensive Need\"))))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(COUNTIF(Table1[[#This Row],[I1) Child Looked After (CLA) in progress]:[I13) Exclusions]],\"Y\")*12,\"\")","v":0},{"$f":"IFERROR(COUNTIF(Table1[[#This Row],[P1) Previously looked after child (PLA)]:[P17) Attendance]],\"Y\")*4,\"\")","v":0},{"$f":"IFERROR(COUNTIF(Table1[[#This Row],[T1) Social, emotional and mental health needs (SEMH)]:[T14) Attendance]],\"Y\")*1,\"\")","v":0},{"$f":"IF(ISBLANK(Table1[[#This Row],[Child First Name]]),\"\",SUM(Table1[[#This Row],[Total Red]:[Total Yellow]]))","v":""},{"$f":"IF(ISBLANK(Table1[[#This Row],[Child First Name]]),\"\",IF(Table1[[#This Row],[Score]]<1,\"Universal Need\",IF(Table1[[#This Row],[Score]]<4,\"Targeted Need\",IF(Table1[[#This Row],[Score]]<12,\"Personalised Need\",\"Intensive Need\"))))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(COUNTIF(Table1[[#This Row],[I1) Child Looked After (CLA) in progress]:[I13) Exclusions]],\"Y\")*12,\"\")","v":0},{"$f":"IFERROR(COUNTIF(Table1[[#This Row],[P1) Previously looked after child (PLA)]:[P17) Attendance]],\"Y\")*4,\"\")","v":0},{"$f":"IFERROR(COUNTIF(Table1[[#This Row],[T1) Social, emotional and mental health needs (SEMH)]:[T14) Attendance]],\"Y\")*1,\"\")","v":0},{"$f":"IF(ISBLANK(Table1[[#This Row],[Child First Name]]),\"\",SUM(Table1[[#This Row],[Total Red]:[Total Yellow]]))","v":""},{"$f":"IF(ISBLANK(Table1[[#This Row],[Child First Name]]),\"\",IF(Table1[[#This Row],[Score]]<1,\"Universal Need\",IF(Table1[[#This Row],[Score]]<4,\"Targeted Need\",IF(Table1[[#This Row],[Score]]<12,\"Personalised Need\",\"Intensive Need\"))))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(COUNTIF(Table1[[#This Row],[I1) Child Looked After (CLA) in progress]:[I13) Exclusions]],\"Y\")*12,\"\")","v":0},{"$f":"IFERROR(COUNTIF(Table1[[#This Row],[P1) Previously looked after child (PLA)]:[P17) Attendance]],\"Y\")*4,\"\")","v":0},{"$f":"IFERROR(COUNTIF(Table1[[#This Row],[T1) Social, emotional and mental health needs (SEMH)]:[T14) Attendance]],\"Y\")*1,\"\")","v":0},{"$f":"IF(ISBLANK(Table1[[#This Row],[Child First Name]]),\"\",SUM(Table1[[#This Row],[Total Red]:[Total Yellow]]))","v":""},{"$f":"IF(ISBLANK(Table1[[#This Row],[Child First Name]]),\"\",IF(Table1[[#This Row],[Score]]<1,\"Universal Need\",IF(Table1[[#This Row],[Score]]<4,\"Targeted Need\",IF(Table1[[#This Row],[Score]]<12,\"Personalised Need\",\"Intensive Need\"))))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(COUNTIF(Table1[[#This Row],[I1) Child Looked After (CLA) in progress]:[I13) Exclusions]],\"Y\")*12,\"\")","v":0},{"$f":"IFERROR(COUNTIF(Table1[[#This Row],[P1) Previously looked after child (PLA)]:[P17) Attendance]],\"Y\")*4,\"\")","v":0},{"$f":"IFERROR(COUNTIF(Table1[[#This Row],[T1) Social, emotional and mental health needs (SEMH)]:[T14) Attendance]],\"Y\")*1,\"\")","v":0},{"$f":"IF(ISBLANK(Table1[[#This Row],[Child First Name]]),\"\",SUM(Table1[[#This Row],[Total Red]:[Total Yellow]]))","v":""},{"$f":"IF(ISBLANK(Table1[[#This Row],[Child First Name]]),\"\",IF(Table1[[#This Row],[Score]]<1,\"Universal Need\",IF(Table1[[#This Row],[Score]]<4,\"Targeted Need\",IF(Table1[[#This Row],[Score]]<12,\"Personalised Need\",\"Intensive Need\"))))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(COUNTIF(Table1[[#This Row],[I1) Child Looked After (CLA) in progress]:[I13) Exclusions]],\"Y\")*12,\"\")","v":0},{"$f":"IFERROR(COUNTIF(Table1[[#This Row],[P1) Previously looked after child (PLA)]:[P17) Attendance]],\"Y\")*4,\"\")","v":0},{"$f":"IFERROR(COUNTIF(Table1[[#This Row],[T1) Social, emotional and mental health needs (SEMH)]:[T14) Attendance]],\"Y\")*1,\"\")","v":0},{"$f":"IF(ISBLANK(Table1[[#This Row],[Child First Name]]),\"\",SUM(Table1[[#This Row],[Total Red]:[Total Yellow]]))","v":""},{"$f":"IF(ISBLANK(Table1[[#This Row],[Child First Name]]),\"\",IF(Table1[[#This Row],[Score]]<1,\"Universal Need\",IF(Table1[[#This Row],[Score]]<4,\"Targeted Need\",IF(Table1[[#This Row],[Score]]<12,\"Personalised Need\",\"Intensive Need\"))))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(COUNTIF(Table1[[#This Row],[I1) Child Looked After (CLA) in progress]:[I13) Exclusions]],\"Y\")*12,\"\")","v":0},{"$f":"IFERROR(COUNTIF(Table1[[#This Row],[P1) Previously looked after child (PLA)]:[P17) Attendance]],\"Y\")*4,\"\")","v":0},{"$f":"IFERROR(COUNTIF(Table1[[#This Row],[T1) Social, emotional and mental health needs (SEMH)]:[T14) Attendance]],\"Y\")*1,\"\")","v":0},{"$f":"IF(ISBLANK(Table1[[#This Row],[Child First Name]]),\"\",SUM(Table1[[#This Row],[Total Red]:[Total Yellow]]))","v":""},{"$f":"IF(ISBLANK(Table1[[#This Row],[Child First Name]]),\"\",IF(Table1[[#This Row],[Score]]<1,\"Universal Need\",IF(Table1[[#This Row],[Score]]<4,\"Targeted Need\",IF(Table1[[#This Row],[Score]]<12,\"Personalised Need\",\"Intensive Need\"))))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(COUNTIF(Table1[[#This Row],[I1) Child Looked After (CLA) in progress]:[I13) Exclusions]],\"Y\")*12,\"\")","v":0},{"$f":"IFERROR(COUNTIF(Table1[[#This Row],[P1) Previously looked after child (PLA)]:[P17) Attendance]],\"Y\")*4,\"\")","v":0},{"$f":"IFERROR(COUNTIF(Table1[[#This Row],[T1) Social, emotional and mental health needs (SEMH)]:[T14) Attendance]],\"Y\")*1,\"\")","v":0},{"$f":"IF(ISBLANK(Table1[[#This Row],[Child First Name]]),\"\",SUM(Table1[[#This Row],[Total Red]:[Total Yellow]]))","v":""},{"$f":"IF(ISBLANK(Table1[[#This Row],[Child First Name]]),\"\",IF(Table1[[#This Row],[Score]]<1,\"Universal Need\",IF(Table1[[#This Row],[Score]]<4,\"Targeted Need\",IF(Table1[[#This Row],[Score]]<12,\"Personalised Need\",\"Intensive Need\"))))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(COUNTIF(Table1[[#This Row],[I1) Child Looked After (CLA) in progress]:[I13) Exclusions]],\"Y\")*12,\"\")","v":0},{"$f":"IFERROR(COUNTIF(Table1[[#This Row],[P1) Previously looked after child (PLA)]:[P17) Attendance]],\"Y\")*4,\"\")","v":0},{"$f":"IFERROR(COUNTIF(Table1[[#This Row],[T1) Social, emotional and mental health needs (SEMH)]:[T14) Attendance]],\"Y\")*1,\"\")","v":0},{"$f":"IF(ISBLANK(Table1[[#This Row],[Child First Name]]),\"\",SUM(Table1[[#This Row],[Total Red]:[Total Yellow]]))","v":""},{"$f":"IF(ISBLANK(Table1[[#This Row],[Child First Name]]),\"\",IF(Table1[[#This Row],[Score]]<1,\"Universal Need\",IF(Table1[[#This Row],[Score]]<4,\"Targeted Need\",IF(Table1[[#This Row],[Score]]<12,\"Personalised Need\",\"Intensive Need\"))))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(COUNTIF(Table1[[#This Row],[I1) Child Looked After (CLA) in progress]:[I13) Exclusions]],\"Y\")*12,\"\")","v":0},{"$f":"IFERROR(COUNTIF(Table1[[#This Row],[P1) Previously looked after child (PLA)]:[P17) Attendance]],\"Y\")*4,\"\")","v":0},{"$f":"IFERROR(COUNTIF(Table1[[#This Row],[T1) Social, emotional and mental health needs (SEMH)]:[T14) Attendance]],\"Y\")*1,\"\")","v":0},{"$f":"IF(ISBLANK(Table1[[#This Row],[Child First Name]]),\"\",SUM(Table1[[#This Row],[Total Red]:[Total Yellow]]))","v":""},{"$f":"IF(ISBLANK(Table1[[#This Row],[Child First Name]]),\"\",IF(Table1[[#This Row],[Score]]<1,\"Universal Need\",IF(Table1[[#This Row],[Score]]<4,\"Targeted Need\",IF(Table1[[#This Row],[Score]]<12,\"Personalised Need\",\"Intensive Need\"))))","v":""}]

{"sheet":"IMPORTANT - PLEASE READ","index":1,"n_rows":40,"n_cols":8,"rows_kept":40,"cut":false,"hidden":false,"merged":[[1,2,1,16],[2,2,2,16],[3,2,3,16],[4,2,4,16],[0,0,0,16],[5,2,5,16],[6,2,6,16],[7,2,7,16],[8,2,8,16],[9,2,9,16],[10,2,10,16],[11,2,11,16],[14,0,14,16],[16,0,16,16],[17,2,17,16],[13,0,13,16],[18,2,18,16],[19,2,19,16],[20,2,20,16],[21,2,21,16],[22,2,22,16],[23,2,23,6],[23,7,23,10],[25,0,25,16],[26,0,26,16],[27,2,27,16],[28,2,28,16],[29,2,29,16],[30,2,30,16],[31,2,31,16],[32,2,32,16],[39,2,39,16],[33,2,33,16],[34,2,34,16],[35,2,35,16],[36,2,36,16],[37,2,37,6],[37,7,37,10]]}
["HOW TO USE THIS TOOL"]
[1,null,"Open a feeder setting's spreadsheet (you will need to enter a password if the file is still password protected).  Check that it is the correct version, i.e. it says ‘2025 Version’ at the top.  If it does not, then contact the setting and ask them to resend the information using the latest version as a new column has been added in the 2025 version."]
[2,null,"Select only the cells containing children’s data, but DO NOT include the headings, Scores or Overall Ratings columns.  This will be everything from cell A9 up to the last cell in column AZ (headed T16)."]
[3,null,"Copy the selection by clicking the Copy button, or by pressing Ctrl and C."]
[4,null,"Switch back to this spreadsheet and click in the first available blank cell under Feeder School, in column A.  This will be A9 for the first set of data."]
[5,null,"Click Paste or press Ctrl and V."]
[6,null,"Totals will now appear under the column headings for each area of support, plus totals for each individual child will appear at the end of each row."]
[7,null,"Check that the entries in the Score and Overall rating columns are as expected (i.e. the same as in the original spreadsheet).  If they are not, click the Undo button, and repeat the copy and paste process, ensuring that you do not select any cells after column AZ."]
[8,null,"You can now, if you wish, either delete the entries under Feeder School (which will be your school name), or replace with the name of the setting.  Click Save."]
[9,null,"Repeat these steps for each of the spreadsheets in turn, ensuring that you always paste into the next available blank cell in column A."]
[10,null,"If you have information for children who have not attended a setting, or are from outside of Hertfordshire, then you can manually enter their data in the next available blank row."]
[11,null,"Once you have completed the spreadsheet, the information will need to be sent to HFL by the end of May to establish the level of support needed for each school.  "]
[]
["RETURNING THE FILE TO HFL (in Spring 2025)"]
["In order to use the button on the spreadsheet to automatically create the file to return, you must be using an installed version of Excel (not an online version), and preferably a Windows machine (we cannot guarantee that the macro will work otherwise).  If you are unable to do so, please follow the instructions for manually creating the file to return."]
[]
["Creating a file to return using the button on the spreadsheet"]
[1,null,"Open the final version of the master spreadsheet where all the information has been collated.  Ensure that macros are enabled."]
[2,null,"Check that you have entered your school number into cell B2 and that your school name appears in B3, as well as selecting the appropriate year group (i.e. Nursery or Reception) in cell B5."]
[3,null,"After checking that the information is complete, click the button at the top of the spreadsheet."]
[4,null,"The Save As box will appear.  This will prompt you to save a new file which contains only the information needed, with a filename containing your school number, name, cohort year and the date.  The location for saving will be same folder as the master spreadsheet, but you can change this if preferred."]
[5,null,"Click Save.  You can then close the spreadsheet.  There is no need to password protect the file as no individual pupil data is included."]
[6,null,"If you have made a mistake and need to add or amend information to the master spreadsheet, you can create another file by clicking the button again."]
[7,null,"Please now email the file as an attachment to: ",null,null,null,null,"eytransition@hfleducation.org"]
[]
["Creating a file to return manually"]
["You only need to follow the instructions in this section if you were unable to use the method above."]
[1,null,"Open the final version of the master spreadsheet where all the information has been collated.  Ensure that macros are enabled."]
[2,null,"Check that you have entered your school number into cell B2 and that your school name appears in B3, as well as selecting the appropriate year group (i.e. Nursery or Reception) in cell B5."]
[3,null,"Select only rows 1 to 8 of the spreadsheet.  A quick way to do this is to click on the button for row 1, hold down your Shift key then click on the button for row 8."]
[4,null,"Copy the selection by clicking the Copy button, or by pressing Ctrl and C."]
[5,null,"Press Ctrl and N to create a new workbook.  Do not click in any cell other than A1."]
[6,null,"Click the drop-down arrow below the Paste button on the Home tab and choose the first icon under Paste Values.  DO NOT use Ctrl and V to paste."]
[7,null,"The pasted data should contain the first 8 rows of the spreadsheet, with the number totals showing in row 7.  If the totals do not appear correct, then please repeat the above steps, ensuring that you choose Paste Values as the option for pasting."]
[8,null,"Press the F12 key to display the Save As box (or click the File tab then Save)."]
[9,null,"Please name the file with your 3 digit School number at the beginning followed by the year group then EY Transition and the month and year, e.g. ‘101 Nursery EY Transition Apr 2025’.  Ensure that you save to a known location."]
[10,null,"There is no need to password protect the file as no individual pupil data is included."]
[11,null,"Please now email the file as an attachment to: ",null,null,null,null,"eytransition@hfleducation.org"]
[]
[null,null,"NB: Before you send, please open the attachment to check that the totals are present and that no names are included."]

{"sheet":"FAQs","index":2,"n_rows":10,"n_cols":26,"rows_kept":10,"cut":false,"hidden":false,"merged":[[9,0,9,12],[0,0,0,12],[2,0,2,12],[3,0,3,12],[5,0,5,12],[6,0,6,12],[8,0,8,12]]}
["Please check the answers to these frequently asked questions before contacting us for support",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"**You have successfully pasted the data but do check the totals in row 7 and column BE look correct**"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Remember to email the file to eytransition@hfleducation.org"]
["I am using a Chromebook / Macbook / Google Docs, can I still use the spreadsheet tool?"]
["You should still be able to enter data into the spreadsheet.  However, the drop-down lists may not be available, and it is likely that you will not be able to use the macro button to automatically create a file to return.  You will need to follow the instructions for manually creating the file to return.  You should also be able to password protect the file, but the menu route may be different to that in the instructions."]
[]
["Why is that when time I copy and paste data from the feeder settings I have no information in the final two columns (score and overall rating)?"]
["First check that the feeder school file says ‘2025 Version’ at the top as a new column has been added this year.  Then you must ensure that you do not copy and paste entire rows, only cells from A9 to the last used cell in column AZ."]
[]
["I’ve been copying and pasting data into my master spreadsheet, but something has gone wrong with the totals and/or ratings at the end, what should I do?"]
["First of all, check that all the files you are copying data from are the most recent version of the tool.  If they are, open your spreadsheet containing the data copied and pasted so far, and also a new blank version of the tool.  Then:\n-    In your spreadsheet, select the cells containing the children’s data - this will be everything from cell A9 up to the last cell in column AZ. \n     DO NOT select the entire rows.\n-    In the blank copy, click in A9 and paste the data."]

{"sheet":"Schools","index":3,"n_rows":533,"n_cols":2,"rows_kept":533,"cut":false,"hidden":true,"merged":[]}
["School No","School Name"]
[1,"Knights Templar School"]
[2,"St Mary's CE (VC) Junior"]
[3,"St Mary's Infants' School"]
[4,"St John Catholic Primary School"]
[5,"Hartsfield JMI School"]
[7,"Garden City Academy"]
[8,"Stonehill School"]
[9,"Weston Way Nursery School"]
[10,"Fearnhill School"]
[13,"The Highfield School"]
[14,"Lordship Farm Primary School"]
[16,"Pixmore Junior School"]
[17,"Hillshott Infant School & Nursery School"]
[19,"Wilbury Junior School"]
[20,"Icknield Infant & Nursery School"]
[21,"The Grange Academy"]
[22,"Northfields Infants & Nursery School"]
[23,"Norton St Nicholas CE (VA) Primary School"]
[26,"St Thomas More Catholic Primary School"]
[30,"Hitchin Boys' School"]
[31,"Hitchin Girls' School"]
[33,"The Priory School"]
[35,"Samuel Lucas JMI School"]
[37,"Highbury Infants' School & Nursery"]
[38,"Highover JMI School"]
[40,"Strathmore Infant & Nursery School"]
[41,"St Andrew's CE VA Primary School"]
[42,"Purwell Primary School"]
[43,"Oughton Primary & Nursery School"]
[45,"Our Lady Catholic Primary School"]
[46,"Whitehill Junior School"]
[47,"The William Ransom Primary School"]
[48,"Mary Exton JMI School"]
[49,"York Road Nursery School"]
[51,"Ashwell Primary School"]
[52,"Barkway VA CE First School"]
[53,"Barley CE VC First School"]
[54,"Codicote CE Primary School"]
[55,"Wilshere-Dacre Junior Academy"]
[56,"Hexton  JMI School"]
[58,"Ickleford Primary School"]
[59,"St Ippolyts CE (Aided) Primary School"]
[60,"Kimpton Primary School"]
[61,"Breachwood Green JMI School"]
[63,"Offley Endowed JMI School"]
[64,"Cockernhoe Endowed CE Primary School"]
[65,"Pirton School"]
[66,"Preston Primary (VC) School"]
[67,"Reed First School"]
[68,"St Paul's Walden Primary School"]
[69,"Sandon JMI School"]
[70,"Therfield First School"]
[71,"Weston Primary School"]
[72,"Wymondley JMI School"]
[79,"King James Academy"]
[82,"Icknield Walk First School"]
[83,"Tannery Drift First School"]
[84,"St Mary's Catholic Primary School"]
[85,"Studlands Rise First School"]
[87,"Roman Way Academy"]
[100,"The Barclay Academy"]
[103,"Nobel School"]
[105,"John Henry Newman RC School"]
[108,"Barnwell Business and Enterprise School"]
[112,"Marriotts School"]
[116,"The Thomas Alleyne Academy"]
[120,"Stevenage St Nicholas CE Primary School & Nursery"]
[121,"Almond Hill Junior School"]
[122,"Letchmore Infants' School"]
[123,"Fairlands Primary School"]
[125,"Broom Barns Primary School"]
[127,"Bedwell Primary School"]
[129,"Roebuck Primary School and Nursery"]
[132,"Peartree Spring Primary School "]
[135,"Featherstone Wood Primary School"]
[137,"Longmeadow Primary"]
[138,"Camps Hill Primary School"]
[140,"St Vincent De Paul RC Primary School"]
[141,"Lodge Farm Primary School"]
[146,"Shephalbury Park Primary"]
[149,"St Margaret Clitherow RC Primary School"]
[150,"Moss Bury Primary School & Nursery"]
[154,"Trotts Hill Primary School & Nursery"]
[155,"Martins Wood Primary School"]
[157,"Round Diamond Primary School"]
[159,"Giles Junior School"]
[160,"Giles Nursery & Infants School"]
[161,"Woolenwick Junior School"]
[162,"The Leys Primary & Nursery School"]
[164,"Woolenwick Infants' School"]
[165,"Ashtree Primary School & Nursery"]
[181,"Stevenage Education Support Centre"]
[184,"Peartree Way Nursery School"]
[191,"Avanti Grange Secondary School"]
[192,"Ardeley St Lawrence CE VA Primary School"]
[193,"Aston St Mary's CE Primary School"]
[194,"Benington CE Primary School"]
[195,"All Saints CE (VA) Primary School Datchworth"]
[196,"Graveley JMI School"]
[197,"Knebworth Primary and Nursery School"]
[198,"Walkern Primary School"]
[199,"Avanti Meadows Primary School"]
[200,"Manor Fields Primary School"]
[201,"Herts and Essex High School"]
[202,"Hockerill Anglo-European College"]
[203,"Bishop's Stortford High School"]
[204,"Birchwood High School"]
[205,"St Marys Catholic School, Bishop's Stortford"]
[206,"Northgate Primary School"]
[207,"St Joseph Catholic Primary School"]
[208,"St Michael's CE VA Primary School"]
[209,"Windhill21"]
[211,"Thorley Hill Primary School"]
[212,"All Saints CE Primary School & Nursery"]
[215,"Thorn Grove Primary School"]
[216,"Hillmead Primary School"]
[219,"Richard Whittington JMI School"]
[220,"Leventhorpe School"]
[221,"Mandeville Primary School"]
[222,"Fawbert & Barnard Infants' School"]
[223,"Spellbrook CofE Primary School"]
[224,"Reedings Junior School"]
[225,"Edwinstree Middle School"]
[227,"Summercroft Primary School"]
[228,"Freman College"]
[229,"Albury CE VA Primary School"]
[230,"Millfield First & Nursery School"]
[231,"Jenyns First School and Nursery"]
[232,"Layston CE First School"]
[234,"High Wych CE Primary School"]
[235,"Hormead CE First & Nursery School"]
[236,"St Andrews CE Primary School & Nursery"]
[237,"Furneux Pelham CE School"]
[239,"Little Hadham Primary School"]
[240,"Anstey First School"]
[245,"Richard Hale School"]
[246,"Simon Balle All-through School "]
[247,"Sele School"]
[249,"Abel Smith School"]
[252,"Bengeo Primary School"]
[254,"Hertford St Andrew CE Primary School"]
[255,"St Joseph's Catholic Primary School"]
[256,"Morgans JMI School"]
[258,"Hollybush Primary School"]
[259,"Mill Mead School"]
[261,"Wheatcroft Primary School"]
[262,"Bayford CE VC Primary School"]
[263,"Tonwell St Mary's CE Primary School"]
[266,"Hertingfordbury Cowper CE VA Primary School"]
[267,"Hertford Heath Primary School"]
[268,"Stapleford Primary School"]
[270,"Watton at Stone Primary & Nursery School"]
[271,"Tewin Cowper CE VA Primary School"]
[275,"Broxbourne Secondary School"]
[276,"Robert Barclay Academy"]
[277,"John Warner School"]
[281,"Wormley CofE Primary School (VC)"]
[282,"Broxbourne CE Primary School"]
[285,"St Catherine's Hoddesdon C of E Primary School"]
[287,"St Augustine's Catholic Primary School"]
[288,"Westfield Community Primary School"]
[289,"St Cross Catholic Primary School"]
[290,"Sheredes Primary School"]
[294,"The Cranbourne Primary School"]
[297,"Roselands Primary School"]
[298,"Forres Primary School"]
[299,"Rye Park Nursery School"]
[301,"Presdales School"]
[303,"Chauncy School"]
[305,"Christ Church CE VA Primary & Nursery School"]
[306,"St Mary's (VC) C of E Junior School"]
[307,"St Catherine's (Ware) CE Primary School"]
[310,"Priors Wood Primary School"]
[311,"Kingshill Infant School"]
[312,"Sacred Heart Catholic Primary School"]
[313,"Larkspur Academy"]
[316,"St John The Baptist VA CE Primary School"]
[318,"Hunsdon JMI School"]
[319,"Little Munden CE VC Primary School"]
[320,"Puller Memorial CE VA Primary School"]
[321,"St Thomas of Canterbury Catholic Primary School"]
[322,"Roger De Clare CE (VC) First School"]
[323,"St Andrew's CE VC Primary School"]
[324,"Thundridge CE Primary School"]
[326,"Widford School"]
[327,"Ralph Sadleir School"]
[340,"Goffs-Churchgate"]
[341,"Goffs School"]
[344,"St Mary's High School"]
[347,"Haileybury Turnford Academy"]
[348,"Churchfield CE Academy"]
[350,"Four Swannes Primary School"]
[351,"St Joseph Catholic Primary School"]
[352,"Holy Trinity CE Primary School"]
[353,"Hurst Drive Primary School"]
[354,"Millbrook Primary School"]
[355,"Goffs Oak Primary School"]
[358,"Holdbrook Primary and Nursery School"]
[359,"Dewhurst St Mary CE Primary School"]
[360,"Burleigh Primary School"]
[361,"Flamstead End School"]
[363,"Bonneygrove Primary School"]
[365,"Brookland Junior School"]
[366,"Brookland Infant & Nursery School"]
[367,"Downfield Primary School"]
[373,"St Paul's Catholic Primary School"]
[374,"Woodside Primary School"]
[375,"Longlands Primary School & Nursery"]
[377,"Fairfields Primary School"]
[378,"Andrews Lane Primary School"]
[398,"Arlesdene Nursery School & Pre-school"]
[399,"Greenfield Nursery School"]
[401,"Verulam School"]
[402,"St Albans Girls' School"]
[404,"Loreto College"]
[406,"Beaumont School"]
[408,"Townsend CE VA Secondary School "]
[409,"Marlborough Science Academy"]
[411,"Alban City School"]
[412,"Samuel Ryder Academy"]
[413,"St Alban & St Stephen Catholic Primary School"]
[416,"Bernards Heath Junior School"]
[417,"Bernards Heath Infants' School"]
[418,"Camp Primary & Nursery School"]
[420,"Fleetville Junior School"]
[421,"Fleetville Infant & Nursery School"]
[422,"Garden Fields JMI School"]
[423,"Aboyne Lodge School"]
[424,"Park Street CE VA Primary School"]
[425,"St Michael's CE VA Primary School"]
[426,"St Peter's School"]
[427,"Abbey CE VA Primary School  "]
[429,"Mandeville Primary School"]
[431,"Margaret Wix Primary School"]
[433,"St Adrian RC Primary School"]
[434,"Oakwood Primary School"]
[435,"Windermere Primary School"]
[436,"Cunningham Hill Junior Mixed School"]
[437,"Cunningham Hill Infants' School"]
[438,"Maple School"]
[439,"Muriel Green Nursery School"]
[440,"Prae Wood Primary School"]
[442,"Sandringham School"]
[444,"Nicholas Breakspear RC School"]
[451,"Redbourn Primary School"]
[452,"London Colney Primary and Nursery School"]
[453,"Bowmansgreen Primary School"]
[454,"Colney Heath JMI School"]
[455,"Killigrew Primary School and Nursery "]
[457,"Mount Pleasant Lane JMI and Nursery School"]
[458,"Sandridge School"]
[459,"St Helen's CE Primary School"]
[462,"Skyswood Primary & Nursery School"]
[463,"Wheatfields Junior School"]
[464,"Wheatfields Infants' and Nursery School"]
[465,"St John Fisher Catholic Primary School"]
[466,"How Wood Primary School"]
[467,"St Bernadettes RC Primary School"]
[469,"Links Academy"]
[470,"Beech Hyde Primary School & Nursery"]
[480,"St George's School"]
[481,"Sir John Lawes School"]
[482,"Roundwood Park School"]
[483,"Katherine Warington School"]
[484,"The Lea Primary School and Nursery"]
[485,"Manland Primary School"]
[486,"St Nicholas CE VA Primary School"]
[487,"High Beeches Primary School"]
[488,"Sauncey Wood Primary School"]
[490,"Roundwood Primary School"]
[491,"The Grove Junior School"]
[492,"The Grove Infant & Nursery School"]
[493,"Wood End School"]
[494,"St Dominic's Catholic Primary School"]
[495,"Crabtree Junior School"]
[496,"Crabtree Infants' School"]
[499,"Batford Nursery School"]
[501,"Harpenden Academy"]
[503,"Welwyn St. Mary's CE VA Primary School"]
[504,"St John's CE VA Primary School"]
[505,"St Michael's Woolmer Green VA CE Primary School"]
[506,"Oaklands Primary School"]
[509,"Tenterfield Nursery School"]
[510,"Stanborough School"]
[512,"Ridgeway Academy"]
[516,"Monks Walk School"]
[520,"Holwell JMI School"]
[521,"Applecroft School"]
[523,"Peartree Primary School"]
[524,"Templewood Primary School"]
[525,"Swallow Dell Primary and Nursery School"]
[527,"Our Lady Catholic Primary School"]
[529,"Commonswood School"]
[532,"Harwood Hill JMI & Nursery School"]
[535,"Homerswood Primary School"]
[536,"Waterside Academy"]
[539,"Holy Family Catholic Primary School"]
[540,"Panshanger Primary School"]
[541,"Springmead Primary School"]
[543,"Watchlytes School"]
[545,"Creswick Primary and Nursery School"]
[549,"Ludwick Nursery School"]
[551,"Bishop's Hatfield Girls School"]
[552,"Onslow St Audrey's School"]
[553,"Chancellors School"]
[560,"Essendon CE Primary School"]
[561,"St John's JMI School Lemsford"]
[562,"Ponsbourne St Mary's CofE Primary School"]
[564,"Northaw CE Primary School"]
[565,"North Mymms St Mary's CE VA Primary School"]
[567,"Little Heath Primary School"]
[568,"Cuffley School"]
[570,"Countess Anne VA CE Primary School"]
[571,"Green Lanes Primary School"]
[574,"Brookmans Park School"]
[575,"Birchwood Avenue Primary School"]
[577,"The Ryde School"]
[579,"Howe Dell Primary School"]
[582,"St Philip Howard Catholic Primary School"]
[585,"Oak View Primary and Nursery School"]
[586,"Hatfield Community Free School"]
[587,"De Havilland Primary School"]
[592,"Links Hatfield Academy"]
[599,"Birchwood Children's Centre and Nursery"]
[600,"Yavneh Primary"]
[604,"Yavneh College"]
[606,"Clore Shalom School"]
[607,"Hertswood Academy"]
[608,"Haywood Grove School"]
[609,"Larwood School"]
[610,"St Nicholas Elstree CE VA Primary School"]
[611,"Shenley Primary School"]
[613,"Summerswood School"]
[614,"Monksmead School"]
[615,"Cowley Hill School"]
[616,"Woodlands Primary School"]
[617,"Kenilworth Primary School"]
[618,"Meryfield Community Primary School"]
[619,"The Valley School"]
[620,"Saffron Green School"]
[621,"Parkside Community Primary School"]
[623,"St Teresa Catholic Primary School"]
[624,"Elstree Screen Arts Academy"]
[626,"Heathlands School"]
[627,"Falconer School"]
[628,"Woolgrove School"]
[631,"The Collett School"]
[632,"Colnbrook School"]
[633,"Garston Manor School"]
[634,"Pinewood School"]
[635,"St Luke's School"]
[639,"Middleton School"]
[642,"Hailey Hall School"]
[643,"Batchwood School"]
[646,"Knightsfield School"]
[647,"Meadow Wood School"]
[648,"Lonsdale School"]
[649,"Roman Fields"]
[650,"Brandles School"]
[651,"Mount Grace School"]
[653,"Dame Alice Owen's School"]
[654,"St Giles CE Primary School"]
[655,"Cranborne Primary School"]
[657,"Oakmere Primary School"]
[661,"Ladbrooke JMI School"]
[662,"Pope Paul Catholic Primary School"]
[663,"The Wroxham School"]
[665,"Southfield School"]
[666,"North Herts Education Support Centre"]
[667,"Rivers Education Support Centre"]
[669,"Chessbrook Education Support Centre"]
[670,"Queens' School"]
[672,"Bushey Meads School"]
[675,"Ashfield Junior School"]
[676,"Merry Hill Infant School & Nursery"]
[677,"Bushey Manor Junior School"]
[678,"Bushey Heath Primary School"]
[679,"Highwood Primary School"]
[680,"Little Reddings Primary School"]
[682,"Sacred Heart Catholic Primary School"]
[683,"Bournehall Primary School"]
[684,"Hartsbourne Primary School"]
[685,"St Clement Danes School"]
[686,"Chorleywood Primary School"]
[687,"Christ Church Chorleywood C of E School"]
[689,"The Russell School"]
[690,"Rickmansworth School"]
[693,"Croxley Danes School"]
[694,"Harvey Road Primary School"]
[695,"Yorke Mead Primary School"]
[696,"Little Green Junior School"]
[697,"Malvern Way Infant & Nursery School"]
[698,"St Mary's CE Primary School"]
[699,"Shepherd Primary"]
[700,"The Grange Academy"]
[702,"St Peter's CE VA Primary School"]
[703,"Eastbury Farm Primary School"]
[704,"St Joan of Arc School"]
[705,"St John's Catholic Primary School"]
[706,"Maple Cross JMI School"]
[707,"Arnett Hills JMI School"]
[708,"Rickmansworth Park JMI School"]
[709,"The Reach Free School"]
[710,"Watford Grammar School for Boys"]
[711,"Watford Grammar School for Girls"]
[712,"Francis Combe Academy"]
[713,"Coates Way JMI & Nursery School"]
[714,"Lanchester Community Free School"]
[715,"Ascot Road Community Free School "]
[717,"Westfield Academy"]
[719,"St Michael Catholic High School"]
[720,"Cherry Tree Primary School"]
[721,"Bromet Primary School"]
[722,"Laurance Haines School"]
[723,"Watford UTC"]
[724,"St Anthony's Catholic Primary School"]
[725,"Central Primary School"]
[728,"Chater Junior School"]
[729,"Chater Infants' School"]
[730,"Field Junior School"]
[731,"Watford Field (Infant & Nursery) School"]
[734,"Kingsway Junior School"]
[735,"Knutsford Primary Academy"]
[736,"Bushey and Oxhey Infant School"]
[737,"Parkgate Junior School"]
[738,"Parkgate Infant & Nursery School"]
[740,"Leavesden Green JMI School"]
[741,"Cassiobury Junior School"]
[742,"Cassiobury Infants' School"]
[743,"Orchard Primary School"]
[747,"Holy Rood Catholic Primary School"]
[748,"St Catherine Of Siena RC Primary School"]
[749,"Holywell Primary School"]
[752,"Alban Wood Primary & Nursery School"]
[753,"Beechfield School"]
[754,"Watford St John's C of E Primary School"]
[755,"Kingsway Infants' School"]
[756,"Nascot Wood Junior School"]
[758,"The Grove Academy"]
[759,"Kingswood Nursery School"]
[760,"Parmiter's School"]
[761,"Nascot Wood Infant & Nursery School"]
[768,"Woodhall Primary School"]
[770,"Oxhey Wood Primary School"]
[772,"Warren Dell Primary School"]
[773,"Greenfields Primary School"]
[774,"St Meryl  School"]
[775,"St Joseph's Catholic Primary School"]
[776,"Abbots Langley School  "]
[778,"Bedmond Village Primary & Nursery School"]
[779,"St Paul's CE VA Primary & Nursery School (Hunton Bridge)"]
[780,"Tanners Wood JMI School"]
[784,"Fair Field Junior School"]
[785,"St John's CE Infant & Nursery School"]
[787,"Sarratt Church of England Primary School"]
[788,"Divine Saviour Catholic Primary School"]
[789,"Newberries Primary School"]
[791,"Hertsmere Jewish Primary School"]
[799,"Oxhey Early Years Centre"]
[801,"Hemel Hempstead School"]
[802,"Longdean School"]
[804,"Astley Cooper School"]
[805,"Jupiter Community Free School "]
[806,"Laureate Academy"]
[809,"Adeyfield School"]
[814,"John F Kennedy RC School"]
[821,"Oakleaf Primary"]
[824,"Nash Mills CE Primary School"]
[825,"George Street Primary School"]
[826,"Boxmoor Primary School"]
[827,"Chaulden Junior School"]
[828,"Two Waters Primary School"]
[829,"Tudor Primary School"]
[830,"Broadfield Academy"]
[832,"Belswains Primary School"]
[833,"South Hill Primary School"]
[834,"Hobletts Manor Junior School"]
[835,"Hobletts Manor Infant & Nursery School"]
[836,"Hobbs Hill Wood Primary School"]
[838,"Chambersbury Primary School"]
[843,"St Cuthbert Mayne Catholic Junior School"]
[844,"Micklem Primary School"]
[846,"Reddings Primary School"]
[853,"Leverstock Green CE Primary School"]
[854,"St Albert The Great RC Primary School"]
[855,"Gade Valley Primary School"]
[857,"Pixies Hill Primary School"]
[859,"Galley Hill Primary School and Nursery"]
[860,"St Rose's Catholic Infant School"]
[861,"Lime Walk Primary School"]
[862,"Hammond Academy"]
[863,"Yewtree Primary School"]
[864,"Maple Grove Primary School"]
[867,"Aycliffe Drive Primary School"]
[868,"Holtsmere End Junior School"]
[869,"Holtsmere End Infants and Nursery School"]
[872,"Brockswood Primary & Nursery School"]
[880,"Greenside School"]
[881,"Amwell View School & Specialist Sports College"]
[882,"Watling View School"]
[883,"Lakeside School"]
[884,"Breakspeare School"]
[885,"Woodfield School"]
[899,"Heath Lane Nursery School"]
[902,"Kings Langley School"]
[903,"Bovingdon Primary Academy"]
[904,"Great Gaddesden C of E (VA) Primary School"]
[905,"Gaddesden Row JMI School"]
[907,"Markyate Village School & Nursery"]
[908,"Flamstead Village School"]
[909,"Chipperfield, St Pauls CE VA Primary School"]
[910,"Kings Langley Primary School"]
[915,"Ashlyns School"]
[916,"St Mary's Cof E Primary School (Northchurch)"]
[917,"Victoria Church of England Infant & Nursery School"]
[918,"Westfield Primary School and Nursery"]
[919,"Swing Gate Infant School & Nursery"]
[920,"St Thomas More Catholic Primary School"]
[921,"Greenway Primary & Nursery School"]
[922,"The Thomas Coram Church of England School"]
[923,"Bridgewater Primary School"]
[925,"Aldbury CE Primary School"]
[926,"Potten End CofE Primary School "]
[927,"Long Marston VA JMI School"]
[929,"St Bartholomew's CE VA Primary School"]
[930,"Little Gaddesden CE VA Primary School"]
[934,"Dacorum Education Support Centre"]
[935,"Tring School"]
[936,"Bishop Wood CE Junior School"]
[938,"Grove Road Primary School"]
[939,"Goldfield Infants' & Nursery School"]
[940,"Dundale Primary & Nursery School"]