{"text_format":"1","workbook":"xlsx","n_sheets":9,"sheets":["Instructions","AS Data","HData","Dashboard","Queries","HData Formulae","Lists","Checks","Analysis"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":17,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Instructions","index":0,"n_rows":24,"n_cols":10,"rows_kept":24,"cut":false,"hidden":false,"merged":[[21,1,22,4],[23,1,23,4],[3,9,3,15],[5,9,5,15],[7,9,7,15]]}
[]
[null,"ADOPTION SUPPORT DATA COLLECTION"]
[]
[null,"Reporting period to which the data relates to: ",null,null,null,null,null,null,null,"2025/26"]
[]
[null,"Please enter the email address of the person completing this return:"]
[]
[null,"Please select the name of your agency:"]
[]
[]
[null,"INSTRUCTIONS"]
[]
[null,"The 'AS DATA'  tab is where you should paste (as values) the child/young person-level adoption support you are planning to submit for the data collection period"]
[null,"When you have added your data, press the 'COMPILE DATA' button on the top left corner of the 'AS Data' sheet"]
[null,"A log of the queries raised can be found in the 'Queries' sheet. This log will be freshly generated each time you go to the \"Queries\" sheet if any changes have been made to your data."]
[null,"The 'Dashboard' sheet provides analysis of the data you enter into the 'AS Data' sheet"]
[]
[null,"In addition to your child level data, please fill in the table below with aggregate numbers of children with Supported Contact Agreements"]
[]
[]
[]
[null,"CO    Type of Supported Contact Agreement",null,null,null,"CO(i)","CO(ii)","CO(ii)"]
[null,null,null,null,null,"Direct","Indirect","Virtual"]
[null,{"$f":"J4","v":"2025/26"}]

{"sheet":"AS Data","index":1,"n_rows":6,"n_cols":40,"rows_kept":6,"cut":false,"hidden":false,"merged":[[2,0,2,5],[2,6,2,16]]}
[]
[]
["THE CHILD",null,null,null,null,null,"ADOPTION SUPPORT KEY DATES"]
["C1","C2","C3","C4","C5","C6","C7","C8","C9","C10","C11","C12","C13","C14","C15","C16","C17","A1","A12","A15","B1","B2","B3","B4","B5","B6","B7","B8","B9","B10","B11","B12","B13","B14","B15","B16","B17","B18","B19","B20"]
["LA Code  of Responsible  Local Authority","Child/Young Person  Identifier","Date of birth","Gender Identity","Ethnic Origin","Is the child/young person  classed as being disabled (0=No, 1=Yes)","Date the ADM approves an adoptive match for the child/young person \n(PRE ORDER)","Date child/young person was placed with the adoptive family\n(PRE ORDER)","Date of Adoption Order","Date of adoption support contact\n(POST ORDER)","Date service contacted family and allocated support\n(POST ORDER)","Date 'Adoption Support Needs Assessment' started\n(POST ORDER)","Date 'Adoption Support Needs Assessment' completed\n(POST ORDER)","Date of most recent 'Adoption Support Needs Assessment' review","Has the child/young person been referred into Children's Social Care (0=No, 1=Yes)\n(POST ORDER)","Date Case Closed","Comments","Pre- or post-order case (flag)","In reporting period","Missing record flag",{"$f":"_xlfn.XLOOKUP(U$4,Checks!$A$23:$A$52,Checks!$B$23:$B$52,\"\",0,1)","v":"C1"},{"$f":"_xlfn.XLOOKUP(V$4,Checks!$A$23:$A$52,Checks!$B$23:$B$52,\"\",0,1)","v":"C2"},{"$f":"_xlfn.XLOOKUP(W$4,Checks!$A$23:$A$52,Checks!$B$23:$B$52,\"\",0,1)","v":"C3"},{"$f":"_xlfn.XLOOKUP(X$4,Checks!$A$23:$A$52,Checks!$B$23:$B$52,\"\",0,1)","v":"C4"},{"$f":"_xlfn.XLOOKUP(Y$4,Checks!$A$23:$A$52,Checks!$B$23:$B$52,\"\",0,1)","v":"C5"},{"$f":"_xlfn.XLOOKUP(Z$4,Checks!$A$23:$A$52,Checks!$B$23:$B$52,\"\",0,1)","v":"C6"},{"$f":"_xlfn.XLOOKUP(AA$4,Checks!$A$23:$A$52,Checks!$B$23:$B$52,\"\",0,1)","v":"C7"},{"$f":"_xlfn.XLOOKUP(AB$4,Checks!$A$23:$A$52,Checks!$B$23:$B$52,\"\",0,1)","v":"C8"},{"$f":"_xlfn.XLOOKUP(AC$4,Checks!$A$23:$A$52,Checks!$B$23:$B$52,\"\",0,1)","v":"C9"},{"$f":"_xlfn.XLOOKUP(AD$4,Checks!$A$23:$A$52,Checks!$B$23:$B$52,\"\",0,1)","v":"C10"},{"$f":"_xlfn.XLOOKUP(AE$4,Checks!$A$23:$A$52,Checks!$B$23:$B$52,\"\",0,1)","v":"C11"},{"$f":"_xlfn.XLOOKUP(AF$4,Checks!$A$23:$A$52,Checks!$B$23:$B$52,\"\",0,1)","v":"C12"},{"$f":"_xlfn.XLOOKUP(AG$4,Checks!$A$23:$A$52,Checks!$B$23:$B$52,\"\",0,1)","v":"C13"},{"$f":"_xlfn.XLOOKUP(AH$4,Checks!$A$23:$A$52,Checks!$B$23:$B$52,\"\",0,1)","v":"C14"},{"$f":"_xlfn.XLOOKUP(AI$4,Checks!$A$23:$A$52,Checks!$B$23:$B$52,\"\",0,1)","v":"C15"},{"$f":"_xlfn.XLOOKUP(AJ$4,Checks!$A$23:$A$52,Checks!$B$23:$B$52,\"\",0,1)","v":"C16"},{"$f":"_xlfn.XLOOKUP(AK$4,Checks!$A$23:$A$52,Checks!$B$23:$B$52,\"\",0,1)","v":"C2"},{"$f":"_xlfn.XLOOKUP(AL$4,Checks!$A$23:$A$52,Checks!$B$23:$B$52,\"\",0,1)","v":"C2"},"C2","C2"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNT(J6:M6,O6)>0,\"Post\",IF(AND(OR(G6<>\"\",H6<>\"\",COUNT(J6:M6,O6)=0),COUNTA(A6:F6)>0),\"Pre\",\"\"))","v":""},{"$f":"OR(AND(R6=\"Pre\",NOT(OR(AND(I6<SDate,I6<>\"\"),AND(G6<>\"\",G6>RDate)))),AND(R6=\"Post\",NOT(OR(AND(J6<>\"\",J6>RDate),AND(P6<>\"\",P6<SDate)))))","v":false},null,{"$f":"IF(R6<>\"\",IF(OR(A6=\"\",ISNA(MATCH(A6,LA_URN,0))),\"Please record a valid LA URN\",\"\"),\"\")","v":""},{"$f":"IF(R6<>\"\",IF(NOT(S6),\"This case falls outside the reporting period, so this case does not need to be included in the return\",IF(B6=\"\",\"Please record the child's CMS ID.\",\"\")))","v":false},{"$f":"IF(R6<>\"\",IF(C6=\"\",\"Please record the date of birth for this child\",IF(NOT(ISNUMBER(C6)),\"Please enter a valid date for the date of birth\",IF(C6>RDate,\"Please enter a date that is not after the reporting period\",IF(DATEDIF(C6,RDate,\"y\")>=25,\"Cases for individuals aged 25 or over should not be included in this data return\",IF(C6>MIN(G6:N6,P6),\"Date of birth cannot be after any of the dates in the adoption journey - please correct whichever dates are wrong\",\"\"))))),\"\")","v":""},{"$f":"IF(R6<>\"\",IF(OR(D6=\"\",ISNA(MATCH(D6,Gender_list,0))),\"Please record a valid gender code\",\"\"),\"\")","v":""},{"$f":"IF(R6<>\"\",IF(OR(E6=\"\",ISNA(MATCH(E6,Eth_list,0))),\"Please record a valid ethnicity code\",\"\"),\"\")","v":""},{"$f":"IF(R6<>\"\",IF(OR(F6=\"\",AND(F6<>0,F6<>1)),\"Please record a valid Disability code\",\"\"),\"\")","v":""},{"$f":"IF(G6<>\"\",IF(NOT(ISNUMBER(G6)),\"Please enter a valid date for the match approval\",IF(G6<C6,\"The adoptive match cannot have been approved before the child was born. Please correct either C3 or C8\",\"\")),IF(AND(H6<>\"\",ISNUMBER(H6)),\"This date is missing, please add it\",\"\"))","v":""},{"$f":"IF(H6=\"\",IF(AND(I6<>\"\",G6<>\"\"),\"Date is missing, please add it\",\"\"),IF(NOT(ISNUMBER(H6)),\"Please enter a valid date\",IF(H6<G6,\"Placement date cannot be before date match was approved - please correct either C7 or C8\",\"\")))","v":""},{"$f":"IF(AND(COUNT(J6:M6)>0,I6=\"\"),\"Date of AO is missing, please add it\",IF(I6<>\"\",IF(NOT(ISNUMBER(I6)),\"Please enter a valid date\",IF(AND(H6<>\"\",I6<>\"\",ISNUMBER(H6),ISNUMBER(I6),H6>I6),\"Date of AO cannot be before placement date - please correct either C8 or C9\",IF(AND(J6<>\"\",ISNUMBER(J6),I6<>\"\",ISNUMBER(I6),I6>J6),\"Date of AO cannot be after post-order contact - please correct C9 or C10\",\"\"))),\"\"))","v":""},{"$f":"IF(J6=\"\",IF(OR(R6=\"Post\",COUNT(K6:N6)>0),\"Date appears to be missing, please add it\",\"\"),IF(NOT(ISNUMBER(J6)),\"Please enter a valid date\",IF(J6<I6,\"Contact date cannot be before Date of AO - please correct either C9 or C10\",\"\")))","v":""},{"$f":"IF(K6=\"\",IF(OR(COUNT(L6:M6)>0,AND(N6<>\"\",ISNUMBER(N6),R6=\"Post\")),\"Date of allocation appears to be missing, please add it\",\"\"),IF(NOT(ISNUMBER(K6)),\"Please enter a valid date\",IF(K6<J6,\"Case cannot be allocated before Contact - please correct either C10 or C11\",\"\")))","v":""},{"$f":"IF(L6=\"\",IF(OR(COUNT(M6)>0,AND(N6<>\"\",ISNUMBER(N6),R6=\"Post\")),\"Assessment start date appears to be missing, please add it\",\"\"),IF(NOT(ISNUMBER(L6)),\"Please enter a valid date\",IF(L6<K6,\"Assessment start date cannot be before allocation date - please correct either C11 or C12\",\"\")))","v":""},{"$f":"IF(M6=\"\",IF(AND(N6<>\"\",ISNUMBER(N6),R6=\"Post\"),\"Assessment completion date is missing or review date has been incorrectly recorded - please correct either C13 or C14\",\"\"),IF(NOT(ISNUMBER(M6)),\"Please enter a valid date\",IF(M6<L6,\"Assessment cannot be completed before it is started - please correct either C12 or C13\",\"\")))","v":""},{"$f":"IF(N6=\"\",IF(OR(AND(H6<>\"\",OR(IFERROR(DATEDIF(H6,I6,\"y\"),0)>=1,IFERROR(DATEDIF(H6,RDate,\"y\"),0)>=1)),AND(M6<>\"\",OR(IFERROR(DATEDIF(M6,P6,\"y\"),0)>=1,IFERROR(DATEDIF(M6,RDate,\"y\"),0)>=1))),\"Date appears to be missing - please record the date of review\",\"\"),IF(NOT(ISNUMBER(N6)),\"Please enter a valid date\",IF(AND(M6<>\"\",N6<M6),\"Review date cannot be before assessment was completed - please correct either C13 or C14\",IF(AND(P6<>\"\",N6>P6),\"Review date cannot be after case was closed - please correct either C14 or C16\",IF(AND(H6<>\"\",N6<H6),\"Review date cannot be before date of placement - please correct either C8 or C14\",IF(AND(I6<>\"\",N6>I6,H6<>\"\",R6=\"Pre\"),\"Review date cannot be after date of AO - please correct either C9 or C14\",\"\"))))))","v":""},{"$f":"IF(AND(O6<>\"\",O6<>0,O6<>1),\"Please record a valid code\",\"\")","v":""},{"$f":"IF(P6<>\"\",IF(NOT(ISNUMBER(P6)),\"Please enter a valid date\",IF(AND(N6<>\"\",ISNUMBER(N6),N6>P6),\"Closure date cannot be before the latest Review date - please correct either C14 or C16\",IF(AND(J6<>\"\",ISNUMBER(J6),J6>P6),\"Closure date cannot be before the initial contact date - please correct C10 or C16\",IF(P6<SDate,\"Case was closed before reporting period. Only include it in this data return if it was not included in a previous return\",IF(AND(I6<>\"\",ISNUMBER(I6),P6<I6),\"Closure date cannot be before the date of AO - please correct C9 or C16\",\"\"))))),\"\")","v":""},{"$f":"IF(COUNTIFS($R$6:$R$100000,\"Pre\",$A$6:$A$100000,$A6,$B$6:$B$100000,$B6)>1,\"This is a duplicate record. Please ensure there are no duplicates in your data.\",\"\")","v":""},{"$f":"IF($J6=\"\",\"\",IF(COUNTIFS($A$6:$A$100000,$A6,$B$6:$B$100000,$B6,$J$6:$J$100000,\"<=\"&IF($P6=\"\",DATE(2099,12,31),$P6),$P$6:$P$100000,\">=\"&$J6)+COUNTIFS($A$6:$A$100000,$A6,$B$6:$B$100000,$B6,$J$6:$J$100000,\"<=\"&IF($P6=\"\",DATE(2099,12,31),$P6),$P$6:$P$100000,\"=\")-1>0,\"This is a duplicate record. Please ensure there are no duplicates in your data.\",\"\"))","v":""},{"$f":"IF(T6=TRUE,\"This record has been added as it appears to be missing in your data return. It was included in a previous return and the case appeared to be still active at the time.\",\"\")","v":""},{"$f":"IF(AND(COUNT(G6:H6)>0,COUNT(J6:M6,O6)>0,I6>=SDate,I6<=RDate),\"A record should not include data for both pre-order and post-order support. Please correct the data entered and add another record if necessary.\",\"\")","v":""}]

{"sheet":"HData","index":2,"n_rows":5,"n_cols":37,"rows_kept":5,"cut":false,"hidden":false,"merged":[[2,0,2,5],[2,6,2,16]]}
[]
[]
["THE CHILD",null,null,null,null,null,"ADOPTION SUPPORT KEY DATES"]
["C1","C2","C3","C4","C5","C6","C7","C8","C9","C10","C11","C12","C13","C14","C15","C16","C17","A1","A2","A3","A4","A5","A6","A7","A8","A9","A10","A11","A12","A13","A14","A16","A17","A18","A19","A20","A21"]
["LA Code  of Responsible  Local Authority","Child/Young Person  Identifier","Date of birth","Gender Identity","Ethnic Origin","Is the child/young person  classed as being disabled (0=No, 1=Yes)","Date the ADM approves an adoptive match for the child/young person \n(PRE ORDER)","Date child/young person was placed with the adoptive family\n(PRE ORDER)","Date of Adoption Order","Date of adoption support contact\n(POST ORDER)","Date service contacted family and allocated support\n(POST ORDER)","Date 'Adoption Support Needs Assessment' started\n(POST ORDER)","Date 'Adoption Support Needs Assessment' completed\n(POST ORDER)","Date of most recent 'Adoption Support Needs Assessment' review","Has the child/young person been referred into Children's Social Care (0=No, 1=Yes)\n(POST ORDER)","Date Case Closed","Comments","Pre- or post-order case (flag)","Time from match to case closed","Time from match to report date","Case open or closed?","Time from contact to allocation","Time from allocation to assessment","Time to complete assessment","Time from contact to closure","Age at report date","Age at AO","Age when case closed","In reporting period","Pre-order duplicate","Post-order duplicate","Region","Case opened in reporting year?","Case closed in reporting year?","Current stage (post-order only)","Time from assessment completed to latest review","Time from latest review to closure"]

{"sheet":"Dashboard","index":3,"n_rows":95,"n_cols":5,"rows_kept":95,"cut":false,"hidden":false,"merged":[]}
["HEADLINE MEASURES FOR DASHBOARD AND ANALYSIS"]
[]
["PRE ADOPTION ORDER SUPPORT",null,null,"POST ADOPTION ORDER SUPPORT"]
[]
["Number of children with an adoption support plan whose match was approved in the reporting period",{"$f":"COUNTIFS(HData!$R$6:$R$98992,\"Pre\",HData!$G$6:$G$98992,\"<=\"&RDate,HData!$G$6:$G$98992,\">=\"&SDate)","v":0},null,"Number of children for whom an adoption support contact has been made in reporting period",{"$f":"COUNTIFS(HData!$R$6:$R$98992,\"Post\",HData!$J$6:$J$98992,\"<=\"&RDate,HData!$J$6:$J$98992,\">=\"&SDate)","v":0}]
["Number of children with an adoption support plan who were placed for adoption in the reporting period",{"$f":"COUNTIFS(HData!$R$6:$R$98992,\"Pre\",HData!$H$6:$H$98992,\"<=\"&RDate,HData!$H$6:$H$98992,\">=\"&SDate)","v":0},null,"Number of children for whom the service has contacted family and allocated support in reporting period",{"$f":"COUNTIFS(HData!$R$6:$R$98992,\"Post\",HData!$K$6:$K$98992,\"<=\"&RDate,HData!$K$6:$K$98992,\">=\"&SDate)","v":0}]
["Number of children with an adoption support plan in place who were granted an AO in the reporting period",{"$f":"COUNTIFS(HData!$R$6:$R$98992,\"Pre\",HData!$I$6:$I$98992,\"<=\"&RDate,HData!$I$6:$I$98992,\">=\"&SDate)","v":0},null,"Number of children for whom an adoption support needs assessment started in reporting period",{"$f":"COUNTIFS(HData!$R$6:$R$98992,\"Post\",HData!$L$6:$L$98992,\"<=\"&RDate,HData!$L$6:$L$98992,\">=\"&SDate)","v":0}]
[null,null,null,"Number of children for whom an adoption support needs assessment completed in reporting period",{"$f":"COUNTIFS(HData!$R$6:$R$98992,\"Post\",HData!$M$6:$M$98992,\"<=\"&RDate,HData!$M$6:$M$98992,\">=\"&SDate)","v":0}]
["Number of children who had an adoption support needs assessment review in the reporting period",{"$f":"COUNTIFS(HData!$R$6:$R$98992,\"Pre\",HData!$N$6:$N$98992,\"<=\"&RDate,HData!$N$6:$N$98992,\">=\"&SDate)","v":0},null,"Number of children who had an adoption support needs assessment review in reporting period",{"$f":"COUNTIFS(HData!$R$6:$R$98992,\"Post\",HData!$N$6:$N$98992,\"<=\"&RDate,HData!$N$6:$N$98992,\">=\"&SDate)","v":0}]
["Number of children for whom an adoption support contact was closed in the reporting period",{"$f":"COUNTIFS(HData!$R$6:$R$98992,\"Pre\",HData!$P$6:$P$98992,\"<=\"&RDate,HData!$P$6:$P$98992,\">=\"&SDate)","v":0},null,"Number of children who were referred into Children's Social Care",{"$f":"COUNTIFS(HData!$R$6:$R$98992,\"Post\",HData!$O$6:$O$98992,1,HData!$AC$6:$AC$98992,TRUE)","v":0}]
[null,null,null,"Number of children for whom an adoption support contact was closed in reporting period",{"$f":"COUNTIFS(HData!$R$6:$R$98992,\"Post\",HData!$P$6:$P$98992,\"<=\"&RDate,HData!$P$6:$P$98992,\">=\"&SDate)","v":0}]
["Number of children with an open Adoption Support case at the end of the reporting period",{"$f":"COUNTIFS(HData!$R$6:$R$98992,\"Pre\",HData!$U$6:$U$98992,\"Open\")","v":0}]
[null,null,null,"Number of children not yet allocated support",{"$f":"COUNTIFS(HData!$R$6:$R$98992,\"Post\",HData!$AI$6:$AI$98992,\"Awaiting allocation\")","v":0}]
["Average time from date of adoption support plan in place at ADM match TO case closed (for cases closed in reporting period)",{"$f":"IFERROR(SUMIFS(HData!$S$6:$S$98992,HData!$R$6:$R$98992,\"Pre\",HData!$P$6:$P$98992,\"<=\"&RDate,HData!$P$6:$P$98992,\">=\"&SDate)/$B$10&\" days\",\"-\")","v":"-"},null,"Number of children allocated support but an assessment has not yet been started",{"$f":"COUNTIFS(HData!$R$6:$R$98992,\"Post\",HData!$AI$6:$AI$98992,\"Awaiting assessment\")","v":0}]
["Average time from date of adoption support plan in place at ADM match TO end of reporting period (for open cases)",{"$f":"IFERROR(SUMIFS(HData!$T$6:$T$98992,HData!$R$6:$R$98992,\"Pre\",HData!$U$6:$U$98992,\"Open\")/$B$12&\" days\",\"-\")","v":"-"},null,"Number of children with an assessment underway",{"$f":"COUNTIFS(HData!$R$6:$R$98992,\"Post\",HData!$AI$6:$AI$98992,\"Being assessed\")","v":0}]
[null,null,null,"Number of children waiting for an Adoption Support Needs Assessment review",{"$f":"COUNTIFS(HData!$R$6:$R$98992,\"Post\",HData!$M$6:$M$98992,\"<>\",HData!$P$6:$P$98992,\"\",HData!$N$6:$N$98992,\"<\"&SDate)+COUNTIFS(HData!$R$6:$R$98992,\"Post\",HData!$M$6:$M$98992,\"<>\",HData!$P$6:$P$98992,\"\",HData!$N$6:$N$98992,\">\"&RDate)","v":0}]
[null,null,null,"Number of children with an open Adoption Support Contact case to be closed",{"$f":"COUNTIFS(HData!$R$6:$R$98992,\"Post\",HData!$J$6:$J$98992,\"<>\",HData!$U$6:$U$98992,\"Open\")","v":0}]
["Characteristics of Children with an open support contact case at the end of the reporting period"]
["By Age Range (age as at report date):",null,null,"Average time from date of adoption support contact TO case allocated to service for assessment (allocated in reporting period)",{"$f":"IFERROR(TEXT(SUMIFS(HData!$V$6:$V$98992,HData!$R$6:$R$98992,\"Post\",HData!$K$6:$K$98992,\"<=\"&RDate,HData!$K$6:$K$98992,\">=\"&SDate)/E6,\"0.0\")&\" days\",\"\")","v":""}]
["under 1 year",{"$f":"COUNTIFS(HData!$R$6:$R$98992,\"Pre\",HData!$U$6:$U$98992,\"Open\",HData!$Z$6:$Z$98992,\"0\")","v":0},null,"Average time from date of adoption support contact TO case allocated to service for assessment (active case in reporting period)",{"$f":"IFERROR(TEXT(SUMIFS(HData!$V$6:$V$98992,HData!$R$6:$R$98992,\"Post\",HData!$U$6:$U$98992,\"Open\")/COUNTIFS(HData!$R$6:$R$98992,\"Post\",HData!$V$6:$V$98992,\">=0\",HData!$U$6:$U$98992,\"Open\"),\"0.0\")&\" days\",\"\")","v":""}]
["1 to 4 years",{"$f":"COUNTIFS(HData!$R$6:$R$98992,\"Pre\",HData!$U$6:$U$98992,\"Open\",HData!$Z$6:$Z$98992,\">0\",HData!$Z$6:$Z$98992,\"<5\")","v":0},null,"Average time from allocated to service for assessment TO support needs assessment started (assessment started in reporting period)",{"$f":"IFERROR(TEXT(SUMIFS(HData!$W$6:$W$98992,HData!$R$6:$R$98992,\"Post\",HData!$L$6:$L$98992,\"<=\"&RDate,HData!$L$6:$L$98992,\">=\"&SDate)/E7,\"0.0\")&\" days\",\"\")","v":""}]
["5 to 9 years",{"$f":"COUNTIFS(HData!$R$6:$R$98992,\"Pre\",HData!$U$6:$U$98992,\"Open\",HData!$Z$6:$Z$98992,\">4\",HData!$Z$6:$Z$98992,\"<10\")","v":0},null,"Average time from allocated to service for assessment TO support needs assessment started (active case in reporting period)",{"$f":"IFERROR(TEXT(SUMIFS(HData!$W$6:$W$98992,HData!$R$6:$R$98992,\"Post\",HData!$U$6:$U$98992,\"Open\")/COUNTIFS(HData!$R$6:$R$98992,\"Post\",HData!$W$6:$W$98992,\">=0\",HData!$U$6:$U$98992,\"Open\"),\"0.0\")&\" days\",\"\")","v":""}]
["10 to 15 years",{"$f":"COUNTIFS(HData!$R$6:$R$98992,\"Pre\",HData!$U$6:$U$98992,\"Open\",HData!$Z$6:$Z$98992,\">9\",HData!$Z$6:$Z$98992,\"<16\")","v":0},null,"Average time from support needs assessment started TO support needs assessment completed (completed in reporting period)",{"$f":"IFERROR(TEXT(SUMIFS(HData!$X$6:$X$98992,HData!$R$6:$R$98992,\"Post\",HData!$M$6:$M$98992,\"<=\"&RDate,HData!$M$6:$M$98992,\">=\"&SDate)/E8,\"0.0\")&\" days\",\"\")","v":""}]
["16 to 18 years",{"$f":"COUNTIFS(HData!$R$6:$R$98992,\"Pre\",HData!$U$6:$U$98992,\"Open\",HData!$Z$6:$Z$98992,\">15\",HData!$Z$6:$Z$98992,\"<19\")","v":0},null,"Average time from support needs assessment started TO support needs assessment completed (active case in reporting period)",{"$f":"IFERROR(TEXT(SUMIFS(HData!$X$6:$X$98992,HData!$R$6:$R$98992,\"Post\",HData!$U$6:$U$98992,\"Open\")/COUNTIFS(HData!$X$6:$X$98992,\">=0\",HData!$R$6:$R$98992,\"Post\",HData!$U$6:$U$98992,\"Open\"),\"0.0\")&\" days\",\"\")","v":""}]
["19 to 25 years",{"$f":"COUNTIFS(HData!$R$6:$R$98992,\"Pre\",HData!$U$6:$U$98992,\"Open\",HData!$Z$6:$Z$98992,\">18\",HData!$Z$6:$Z$98992,\"<26\")","v":0},null,"Average time from support needs assessment completed TO review (review in reporting period)",{"$f":"IFERROR(TEXT(SUMIFS(HData!$AJ$6:$AJ$98992,HData!$R$6:$R$98992,\"Post\",HData!$N$6:$N$98992,\"<=\"&RDate,HData!$N$6:$N$98992,\">=\"&SDate)/E9,\"0.0\")&\" days\",\"\")","v":""}]
["Gender Identity",null,null,"Average time from adoption support review TO date case closed (closed in reporting period)",{"$f":"IFERROR(TEXT(SUMIFS(HData!$AK$6:$AK$98992,HData!$R$6:$R$98992,\"Post\",HData!$P$6:$P$98992,\"<=\"&RDate,HData!$P$6:$P$98992,\">=\"&SDate)/E11,\"0.0\")&\" days\",\"\")","v":""}]
[{"$f":"Lists!I2","v":"Not known (gender not recorded )"},{"$f":"COUNTIFS(HData!$R$6:$R$98992,\"Pre\",HData!$U$6:$U$98992,\"Open\",HData!$D$6:$D$98992,Lists!H2)","v":0},null,"Average time from adoption support contact TO date case closed (closed in reporting period)",{"$f":"IFERROR(TEXT(SUMIFS(HData!Y6:$Y$98992,HData!$R$6:$R$98992,\"Post\",HData!$P$6:$P$98992,\"<=\"&RDate,HData!$P$6:$P$98992,\">=\"&SDate)/E11,\"0.0\")&\" days\",\"\")","v":""}]
[{"$f":"Lists!I3","v":"Male"},{"$f":"COUNTIFS(HData!$R$6:$R$98992,\"Pre\",HData!$U$6:$U$98992,\"Open\",HData!$D$6:$D$98992,Lists!H3)","v":0}]
[{"$f":"Lists!I4","v":"Female"},{"$f":"COUNTIFS(HData!$R$6:$R$98992,\"Pre\",HData!$U$6:$U$98992,\"Open\",HData!$D$6:$D$98992,Lists!H4)","v":0},null,"Number of children for whom an adoption support contact has been made in reporting period and who had a needs assessment started",{"$f":"COUNTIFS(HData!$R$6:$R$98992,\"Post\",HData!$J$6:$J$98992,\"<=\"&RDate,HData!$J$6:$J$98992,\">=\"&SDate,HData!$L$6:$L$98992,\"<>\")","v":0}]
[{"$f":"Lists!I5","v":"Non-binary"},{"$f":"COUNTIFS(HData!$R$6:$R$98992,\"Pre\",HData!$U$6:$U$98992,\"Open\",HData!$D$6:$D$98992,Lists!H5)","v":0},null,"Percentage of children for whom an adoption support contact has been made in reporting period and who had a needs assessment started",{"$f":"E29/E5","v":{"$error":"#DIV/0!"}}]
[{"$f":"Lists!I6","v":"Transgender Man (Trans Man)"},{"$f":"COUNTIFS(HData!$R$6:$R$98992,\"Pre\",HData!$U$6:$U$98992,\"Open\",HData!$D$6:$D$98992,Lists!H6)","v":0}]
[{"$f":"Lists!I7","v":"Transgender Woman (Trans Woman)"},{"$f":"COUNTIFS(HData!$R$6:$R$98992,\"Pre\",HData!$U$6:$U$98992,\"Open\",HData!$D$6:$D$98992,Lists!H7)","v":0},null,"Characteristics of Children who had a support case opened in the reporting period"]
[{"$f":"Lists!I8","v":"Other gender identity"},{"$f":"COUNTIFS(HData!$R$6:$R$98992,\"Pre\",HData!$U$6:$U$98992,\"Open\",HData!$D$6:$D$98992,Lists!H8)","v":0},null,{"$f":"A19","v":"By Age Range (age as at report date):"}]
[{"$f":"Lists!I9","v":"Gender identity the same as sex registered at birth but no specific identity given"},{"$f":"COUNTIFS(HData!$R$6:$R$98992,\"Pre\",HData!$U$6:$U$98992,\"Open\",HData!$D$6:$D$98992,Lists!H9)","v":0},null,"under 1 year",{"$f":"COUNTIFS(HData!$R$6:$R$98992,\"Post\",HData!$J$6:$J$98992,\"<=\"&RDate,HData!$J$6:$J$98992,\">=\"&SDate,HData!$Z$6:$Z$98992,\"0\")","v":0}]
[{"$f":"Lists!I10","v":"Gender identity different from sex registered at birth but no specific identity given"},{"$f":"COUNTIFS(HData!$R$6:$R$98992,\"Pre\",HData!$U$6:$U$98992,\"Open\",HData!$D$6:$D$98992,Lists!H10)","v":0},null,"1 to 4 years",{"$f":"COUNTIFS(HData!$R$6:$R$98992,\"Post\",HData!$J$6:$J$98992,\"<=\"&RDate,HData!$J$6:$J$98992,\">=\"&SDate,HData!$Z$6:$Z$98992,\">0\",HData!$Z$6:$Z$98992,\"<5\")","v":0}]
[{"$f":"Lists!I11","v":"Neither"},{"$f":"COUNTIFS(HData!$R$6:$R$98992,\"Pre\",HData!$U$6:$U$98992,\"Open\",HData!$D$6:$D$98992,Lists!H11)","v":0},null,"5 to 9 years",{"$f":"COUNTIFS(HData!$R$6:$R$98992,\"Post\",HData!$J$6:$J$98992,\"<=\"&RDate,HData!$J$6:$J$98992,\">=\"&SDate,HData!$Z$6:$Z$98992,\">4\",HData!$Z$6:$Z$98992,\"<10\")","v":0}]
["Ethnic Origin",null,null,"10 to 15 years",{"$f":"COUNTIFS(HData!$R$6:$R$98992,\"Post\",HData!$J$6:$J$98992,\"<=\"&RDate,HData!$J$6:$J$98992,\">=\"&SDate,HData!$Z$6:$Z$98992,\">9\",HData!$Z$6:$Z$98992,\"<16\")","v":0}]
["Asian or Asian British",{"$f":"SUMPRODUCT((HData!$R$6:$R$98992=\"Pre\")*(HData!$U$6:$U$98992=\"Open\")*(LEFT(HData!$E$6:$E$98992,1)=\"A\"))","v":0},null,"16 to 18 years",{"$f":"COUNTIFS(HData!$R$6:$R$98992,\"Post\",HData!$J$6:$J$98992,\"<=\"&RDate,HData!$J$6:$J$98992,\">=\"&SDate,HData!$Z$6:$Z$98992,\">15\",HData!$Z$6:$Z$98992,\"<19\")","v":0}]
["Black, African, Caribbean or Black British",{"$f":"SUMPRODUCT((HData!$R$6:$R$98992=\"Pre\")*(HData!$U$6:$U$98992=\"Open\")*(LEFT(HData!$E$6:$E$98992,1)=\"B\"))","v":0},null,"19 to 25 years",{"$f":"COUNTIFS(HData!$R$6:$R$98992,\"Post\",HData!$J$6:$J$98992,\"<=\"&RDate,HData!$J$6:$J$98992,\">=\"&SDate,HData!$Z$6:$Z$98992,\">18\",HData!$Z$6:$Z$98992,\"<26\")","v":0}]
["Chinese",{"$f":"SUMPRODUCT((HData!$R$6:$R$98992=\"Pre\")*(HData!$U$6:$U$98992=\"Open\")*(LEFT(HData!$E$6:$E$98992,1)=\"C\"))","v":0},null,"Gender Identity"]
["Mixed or Multiple ethnic groups",{"$f":"SUMPRODUCT((HData!$R$6:$R$98992=\"Pre\")*(HData!$U$6:$U$98992=\"Open\")*(LEFT(HData!$E$6:$E$98992,1)=\"M\"))","v":0},null,"Not known (gender not recorded )",{"$f":"COUNTIFS(HData!$R$6:$R$98992,\"Post\",HData!$J$6:$J$98992,\"<=\"&RDate,HData!$J$6:$J$98992,\">=\"&SDate,HData!$D$6:$D$98992,Lists!H2)","v":0}]
["Other ethnic group",{"$f":"SUMPRODUCT((HData!$R$6:$R$98992=\"Pre\")*(HData!$U$6:$U$98992=\"Open\")*(LEFT(HData!$E$6:$E$98992,1)=\"O\"))","v":0},null,"Male",{"$f":"COUNTIFS(HData!$R$6:$R$98992,\"Post\",HData!$J$6:$J$98992,\"<=\"&RDate,HData!$J$6:$J$98992,\">=\"&SDate,HData!$D$6:$D$98992,Lists!H3)","v":0}]
["White",{"$f":"SUMPRODUCT((HData!$R$6:$R$98992=\"Pre\")*(HData!$U$6:$U$98992=\"Open\")*(LEFT(HData!$E$6:$E$98992,1)=\"W\"))","v":0},null,"Female",{"$f":"COUNTIFS(HData!$R$6:$R$98992,\"Post\",HData!$J$6:$J$98992,\"<=\"&RDate,HData!$J$6:$J$98992,\">=\"&SDate,HData!$D$6:$D$98992,Lists!H4)","v":0}]
["Not known (ethnicity not recorded)",{"$f":"B12-SUM(B38:B43)","v":0},null,"Non-binary",{"$f":"COUNTIFS(HData!$R$6:$R$98992,\"Post\",HData!$J$6:$J$98992,\"<=\"&RDate,HData!$J$6:$J$98992,\">=\"&SDate,HData!$D$6:$D$98992,Lists!H5)","v":0}]
["Disability",null,null,"Transgender Man (Trans Man)",{"$f":"COUNTIFS(HData!$R$6:$R$98992,\"Post\",HData!$J$6:$J$98992,\"<=\"&RDate,HData!$J$6:$J$98992,\">=\"&SDate,HData!$D$6:$D$98992,Lists!H6)","v":0}]
["Yes",{"$f":"COUNTIFS(HData!$R$6:$R$98992,\"Pre\",HData!$U$6:$U$98992,\"Open\",HData!$F$6:$F$98992,1)","v":0},null,"Transgender Woman (Trans Woman)",{"$f":"COUNTIFS(HData!$R$6:$R$98992,\"Post\",HData!$J$6:$J$98992,\"<=\"&RDate,HData!$J$6:$J$98992,\">=\"&SDate,HData!$D$6:$D$98992,Lists!H7)","v":0}]
[null,null,null,"Other gender identity",{"$f":"COUNTIFS(HData!$R$6:$R$98992,\"Post\",HData!$J$6:$J$98992,\"<=\"&RDate,HData!$J$6:$J$98992,\">=\"&SDate,HData!$D$6:$D$98992,Lists!H8)","v":0}]
["Characteristics of Children for whom an adoption support contact was closed in reporting period",null,null,"Gender identity the same as sex registered at birth but no specific identity given",{"$f":"COUNTIFS(HData!$R$6:$R$98992,\"Post\",HData!$J$6:$J$98992,\"<=\"&RDate,HData!$J$6:$J$98992,\">=\"&SDate,HData!$D$6:$D$98992,Lists!H9)","v":0}]
["By Age Range (age when AO granted):",null,null,"Gender identity different from sex registered at birth but no specific identity given",{"$f":"COUNTIFS(HData!$R$6:$R$98992,\"Post\",HData!$J$6:$J$98992,\"<=\"&RDate,HData!$J$6:$J$98992,\">=\"&SDate,HData!$D$6:$D$98992,Lists!H10)","v":0}]
["under 1 year",{"$f":"COUNTIFS(HData!$R$6:$R$98992,\"Pre\",HData!$P$6:$P$98992,\"<=\"&RDate,HData!$P$6:$P$98992,\">=\"&SDate,HData!$AA$6:$AA$98992,\"0\")","v":0},null,"Neither",{"$f":"COUNTIFS(HData!$R$6:$R$98992,\"Post\",HData!$J$6:$J$98992,\"<=\"&RDate,HData!$J$6:$J$98992,\">=\"&SDate,HData!$D$6:$D$98992,Lists!H11)","v":0}]
["1 to 4 years",{"$f":"COUNTIFS(HData!$R$6:$R$98992,\"Pre\",HData!$P$6:$P$98992,\"<=\"&RDate,HData!$P$6:$P$98992,\">=\"&SDate,HData!$AA$6:$AA$98992,\">0\",HData!$AA$6:$AA$98992,\"<5\")","v":0},null,"Ethnic Origin"]
["5 to 9 years",{"$f":"COUNTIFS(HData!$R$6:$R$98992,\"Pre\",HData!$P$6:$P$98992,\"<=\"&RDate,HData!$P$6:$P$98992,\">=\"&SDate,HData!$AA$6:$AA$98992,\">4\",HData!$AA$6:$AA$98992,\"<10\")","v":0},null,"Asian or Asian British",{"$f":"SUMPRODUCT((HData!$R$6:$R$98992=\"Post\")*(HData!$J$6:$J$98992<=RDate)*(HData!$J$6:$J$98992>=SDate)*(LEFT(HData!$E$6:$E$98992,1)=\"A\"))","v":0}]
["10 to 15 years",{"$f":"COUNTIFS(HData!$R$6:$R$98992,\"Pre\",HData!$P$6:$P$98992,\"<=\"&RDate,HData!$P$6:$P$98992,\">=\"&SDate,HData!$AA$6:$AA$98992,\">9\",HData!$AA$6:$AA$98992,\"<16\")","v":0},null,"Black, African, Caribbean or Black British",{"$f":"SUMPRODUCT((HData!$R$6:$R$98992=\"Post\")*(HData!$J$6:$J$98992<=RDate)*(HData!$J$6:$J$98992>=SDate)*(LEFT(HData!$E$6:$E$98992,1)=\"B\"))","v":0}]
["16 to 18 years",{"$f":"COUNTIFS(HData!$R$6:$R$98992,\"Pre\",HData!$P$6:$P$98992,\"<=\"&RDate,HData!$P$6:$P$98992,\">=\"&SDate,HData!$AA$6:$AA$98992,\">15\",HData!$AA$6:$AA$98992,\"<19\")","v":0},null,"Chinese",{"$f":"SUMPRODUCT((HData!$R$6:$R$98992=\"Post\")*(HData!$J$6:$J$98992<=RDate)*(HData!$J$6:$J$98992>=SDate)*(LEFT(HData!$E$6:$E$98992,1)=\"C\"))","v":0}]
["19 to 25 years",{"$f":"COUNTIFS(HData!$R$6:$R$98992,\"Pre\",HData!$P$6:$P$98992,\"<=\"&RDate,HData!$P$6:$P$98992,\">=\"&SDate,HData!$AA$6:$AA$98992,\">18\",HData!$AA$6:$AA$98992,\"<26\")","v":0},null,"Mixed or Multiple ethnic groups",{"$f":"SUMPRODUCT((HData!$R$6:$R$98992=\"Post\")*(HData!$J$6:$J$98992<=RDate)*(HData!$J$6:$J$98992>=SDate)*(LEFT(HData!$E$6:$E$98992,1)=\"M\"))","v":0}]
["Gender Identity",null,null,"Other ethnic group",{"$f":"SUMPRODUCT((HData!$R$6:$R$98992=\"Post\")*(HData!$J$6:$J$98992<=RDate)*(HData!$J$6:$J$98992>=SDate)*(LEFT(HData!$E$6:$E$98992,1)=\"O\"))","v":0}]
[{"$f":"A27","v":"Not known (gender not recorded )"},{"$f":"COUNTIFS(HData!$R$6:$R$98992,\"Pre\",HData!$P$6:$P$98992,\"<=\"&RDate,HData!$P$6:$P$98992,\">=\"&SDate,HData!$D$6:$D$98992,Lists!H2)","v":0},null,"White",{"$f":"SUMPRODUCT((HData!$R$6:$R$98992=\"Post\")*(HData!$J$6:$J$98992<=RDate)*(HData!$J$6:$J$98992>=SDate)*(LEFT(HData!$E$6:$E$98992,1)=\"W\"))","v":0}]
["Male",{"$f":"COUNTIFS(HData!$R$6:$R$98992,\"Pre\",HData!$P$6:$P$98992,\"<=\"&RDate,HData!$P$6:$P$98992,\">=\"&SDate,HData!$D$6:$D$98992,Lists!H3)","v":0},null,"Not known (ethnicity not recorded)",{"$f":"E5-SUM(E52:E57)","v":0}]
["Female",{"$f":"COUNTIFS(HData!$R$6:$R$98992,\"Pre\",HData!$P$6:$P$98992,\"<=\"&RDate,HData!$P$6:$P$98992,\">=\"&SDate,HData!$D$6:$D$98992,Lists!H4)","v":0},null,"Disability"]
["Non-binary",{"$f":"COUNTIFS(HData!$R$6:$R$98992,\"Pre\",HData!$P$6:$P$98992,\"<=\"&RDate,HData!$P$6:$P$98992,\">=\"&SDate,HData!$D$6:$D$98992,Lists!H5)","v":0},null,"Yes",{"$f":"COUNTIFS(HData!$R$6:$R$98992,\"Post\",HData!$J$6:$J$98992,\"<=\"&RDate,HData!$J$6:$J$98992,\">=\"&SDate,HData!$F$6:$F$98992,1)","v":0}]
["Transgender Man (Trans Man)",{"$f":"COUNTIFS(HData!$R$6:$R$98992,\"Pre\",HData!$P$6:$P$98992,\"<=\"&RDate,HData!$P$6:$P$98992,\">=\"&SDate,HData!$D$6:$D$98992,Lists!H6)","v":0}]
["Transgender Woman (Trans Woman)",{"$f":"COUNTIFS(HData!$R$6:$R$98992,\"Pre\",HData!$P$6:$P$98992,\"<=\"&RDate,HData!$P$6:$P$98992,\">=\"&SDate,HData!$D$6:$D$98992,Lists!H7)","v":0},null,"Characteristics of Children for whom an adoption support contact was closed in reporting period"]
["Other gender identity",{"$f":"COUNTIFS(HData!$R$6:$R$98992,\"Pre\",HData!$P$6:$P$98992,\"<=\"&RDate,HData!$P$6:$P$98992,\">=\"&SDate,HData!$D$6:$D$98992,Lists!H8)","v":0},null,"By Age Range (age when case closed):"]
["Gender identity the same as sex registered at birth but no specific identity given",{"$f":"COUNTIFS(HData!$R$6:$R$98992,\"Pre\",HData!$P$6:$P$98992,\"<=\"&RDate,HData!$P$6:$P$98992,\">=\"&SDate,HData!$D$6:$D$98992,Lists!H9)","v":0},null,{"$f":"A50","v":"under 1 year"},{"$f":"COUNTIFS(HData!$R$6:$R$98992,\"Post\",HData!$P$6:$P$98992,\"<=\"&RDate,HData!$P$6:$P$98992,\">=\"&SDate,HData!$AB$6:$AB$98992,\"0\")","v":0}]
["Gender identity different from sex registered at birth but no specific identity given",{"$f":"COUNTIFS(HData!$R$6:$R$98992,\"Pre\",HData!$P$6:$P$98992,\"<=\"&RDate,HData!$P$6:$P$98992,\">=\"&SDate,HData!$D$6:$D$98992,Lists!H10)","v":0},null,"1 to 4 years",{"$f":"COUNTIFS(HData!$R$6:$R$98992,\"Post\",HData!$P$6:$P$98992,\"<=\"&RDate,HData!$P$6:$P$98992,\">=\"&SDate,HData!$AB$6:$AB$98992,\">0\",HData!$AB$6:$AB$98992,\"<5\")","v":0}]
["Neither",{"$f":"COUNTIFS(HData!$R$6:$R$98992,\"Pre\",HData!$P$6:$P$98992,\"<=\"&RDate,HData!$P$6:$P$98992,\">=\"&SDate,HData!$D$6:$D$98992,Lists!H11)","v":0},null,"5 to 9 years",{"$f":"COUNTIFS(HData!$R$6:$R$98992,\"Post\",HData!$P$6:$P$98992,\"<=\"&RDate,HData!$P$6:$P$98992,\">=\"&SDate,HData!$AB$6:$AB$98992,\">4\",HData!$AB$6:$AB$98992,\"<10\")","v":0}]
["Ethnic Origin",null,null,"10 to 15 years",{"$f":"COUNTIFS(HData!$R$6:$R$98992,\"Post\",HData!$P$6:$P$98992,\"<=\"&RDate,HData!$P$6:$P$98992,\">=\"&SDate,HData!$AB$6:$AB$98992,\">9\",HData!$AB$6:$AB$98992,\"<16\")","v":0}]
[{"$f":"A38","v":"Asian or Asian British"},{"$f":"SUMPRODUCT((HData!$R$6:$R$98992=\"Pre\")*(HData!$P$6:$P$98992<=RDate)*(HData!$P$6:$P$98992>=SDate)*(LEFT(HData!$E$6:$E$98992,1)=\"A\"))","v":0},null,"16 to 18 years",{"$f":"COUNTIFS(HData!$R$6:$R$98992,\"Post\",HData!$P$6:$P$98992,\"<=\"&RDate,HData!$P$6:$P$98992,\">=\"&SDate,HData!$AB$6:$AB$98992,\">15\",HData!$AB$6:$AB$98992,\"<19\")","v":0}]
["Black, African, Caribbean or Black British",{"$f":"SUMPRODUCT((HData!$R$6:$R$98992=\"Pre\")*(HData!$P$6:$P$98992<=RDate)*(HData!$P$6:$P$98992>=SDate)*(LEFT(HData!$E$6:$E$98992,1)=\"B\"))","v":0},null,"19 to 25 years",{"$f":"COUNTIFS(HData!$R$6:$R$98992,\"Post\",HData!$P$6:$P$98992,\"<=\"&RDate,HData!$P$6:$P$98992,\">=\"&SDate,HData!$AB$6:$AB$98992,\">18\",HData!$AB$6:$AB$98992,\"<26\")","v":0}]
["Chinese",{"$f":"SUMPRODUCT((HData!$R$6:$R$98992=\"Pre\")*(HData!$P$6:$P$98992<=RDate)*(HData!$P$6:$P$98992>=SDate)*(LEFT(HData!$E$6:$E$98992,1)=\"C\"))","v":0},null,"Gender Identity"]
["Mixed or Multiple ethnic groups",{"$f":"SUMPRODUCT((HData!$R$6:$R$98992=\"Pre\")*(HData!$P$6:$P$98992<=RDate)*(HData!$P$6:$P$98992>=SDate)*(LEFT(HData!$E$6:$E$98992,1)=\"M\"))","v":0},null,"Not known (gender not recorded )",{"$f":"COUNTIFS(HData!$R$6:$R$98992,\"Post\",HData!$P$6:$P$98992,\"<=\"&RDate,HData!$P$6:$P$98992,\">=\"&SDate,HData!$D$6:$D$98992,Lists!H2)","v":0}]
["Other ethnic group",{"$f":"SUMPRODUCT((HData!$R$6:$R$98992=\"Pre\")*(HData!$P$6:$P$98992<=RDate)*(HData!$P$6:$P$98992>=SDate)*(LEFT(HData!$E$6:$E$98992,1)=\"O\"))","v":0},null,"Male",{"$f":"COUNTIFS(HData!$R$6:$R$98992,\"Post\",HData!$P$6:$P$98992,\"<=\"&RDate,HData!$P$6:$P$98992,\">=\"&SDate,HData!$D$6:$D$98992,Lists!H3)","v":0}]
["White",{"$f":"SUMPRODUCT((HData!$R$6:$R$98992=\"Pre\")*(HData!$P$6:$P$98992<=RDate)*(HData!$P$6:$P$98992>=SDate)*(LEFT(HData!$E$6:$E$98992,1)=\"W\"))","v":0},null,"Female",{"$f":"COUNTIFS(HData!$R$6:$R$98992,\"Post\",HData!$P$6:$P$98992,\"<=\"&RDate,HData!$P$6:$P$98992,\">=\"&SDate,HData!$D$6:$D$98992,Lists!H4)","v":0}]
["Not known (ethnicity not recorded)",{"$f":"B10-SUM(B68:B73)","v":0},null,"Non-binary",{"$f":"COUNTIFS(HData!$R$6:$R$98992,\"Post\",HData!$P$6:$P$98992,\"<=\"&RDate,HData!$P$6:$P$98992,\">=\"&SDate,HData!$D$6:$D$98992,Lists!H5)","v":0}]
["Disability",null,null,"Transgender Man (Trans Man)",{"$f":"COUNTIFS(HData!$R$6:$R$98992,\"Post\",HData!$P$6:$P$98992,\"<=\"&RDate,HData!$P$6:$P$98992,\">=\"&SDate,HData!$D$6:$D$98992,Lists!H6)","v":0}]
["Yes",{"$f":"COUNTIFS(HData!$R$6:$R$98992,\"Pre\",HData!$P$6:$P$98992,\"<=\"&RDate,HData!$P$6:$P$98992,\">=\"&SDate,HData!$F$6:$F$98992,1)","v":0},null,"Transgender Woman (Trans Woman)",{"$f":"COUNTIFS(HData!$R$6:$R$98992,\"Post\",HData!$P$6:$P$98992,\"<=\"&RDate,HData!$P$6:$P$98992,\">=\"&SDate,HData!$D$6:$D$98992,Lists!H7)","v":0}]
[null,null,null,"Other gender identity",{"$f":"COUNTIFS(HData!$R$6:$R$98992,\"Post\",HData!$P$6:$P$98992,\"<=\"&RDate,HData!$P$6:$P$98992,\">=\"&SDate,HData!$D$6:$D$98992,Lists!H8)","v":0}]
[null,null,null,"Gender identity the same as sex registered at birth but no specific identity given",{"$f":"COUNTIFS(HData!$R$6:$R$98992,\"Post\",HData!$P$6:$P$98992,\"<=\"&RDate,HData!$P$6:$P$98992,\">=\"&SDate,HData!$D$6:$D$98992,Lists!H9)","v":0}]
[null,null,null,"Gender identity different from sex registered at birth but no specific identity given",{"$f":"COUNTIFS(HData!$R$6:$R$98992,\"Post\",HData!$P$6:$P$98992,\"<=\"&RDate,HData!$P$6:$P$98992,\">=\"&SDate,HData!$D$6:$D$98992,Lists!H10)","v":0}]
[null,null,null,"Neither",{"$f":"COUNTIFS(HData!$R$6:$R$98992,\"Post\",HData!$P$6:$P$98992,\"<=\"&RDate,HData!$P$6:$P$98992,\">=\"&SDate,HData!$D$6:$D$98992,Lists!H11)","v":0}]
[null,null,null,"Ethnic Origin"]
[null,null,null,"Asian or Asian British",{"$f":"SUMPRODUCT((HData!$R$6:$R$98992=\"Post\")*(HData!$P$6:$P$98992<=RDate)*(HData!$P$6:$P$98992>=SDate)*(LEFT(HData!$E$6:$E$98992,1)=\"A\"))","v":0}]
[null,null,null,"Black, African, Caribbean or Black British",{"$f":"SUMPRODUCT((HData!$R$6:$R$98992=\"Post\")*(HData!$P$6:$P$98992<=RDate)*(HData!$P$6:$P$98992>=SDate)*(LEFT(HData!$E$6:$E$98992,1)=\"B\"))","v":0}]
[null,null,null,"Chinese",{"$f":"SUMPRODUCT((HData!$R$6:$R$98992=\"Post\")*(HData!$P$6:$P$98992<=RDate)*(HData!$P$6:$P$98992>=SDate)*(LEFT(HData!$E$6:$E$98992,1)=\"C\"))","v":0}]
[null,null,null,"Mixed or Multiple ethnic groups",{"$f":"SUMPRODUCT((HData!$R$6:$R$98992=\"Post\")*(HData!$P$6:$P$98992<=RDate)*(HData!$P$6:$P$98992>=SDate)*(LEFT(HData!$E$6:$E$98992,1)=\"M\"))","v":0}]
[null,null,null,"Other ethnic group",{"$f":"SUMPRODUCT((HData!$R$6:$R$98992=\"Post\")*(HData!$P$6:$P$98992<=RDate)*(HData!$P$6:$P$98992>=SDate)*(LEFT(HData!$E$6:$E$98992,1)=\"O\"))","v":0}]
[null,null,null,"White",{"$f":"SUMPRODUCT((HData!$R$6:$R$98992=\"Post\")*(HData!$P$6:$P$98992<=RDate)*(HData!$P$6:$P$98992>=SDate)*(LEFT(HData!$E$6:$E$98992,1)=\"W\"))","v":0}]
[null,null,null,"Not known (ethnicity not recorded)",{"$f":"E11-SUM(E82:E87)","v":0}]
[null,null,null,"Disability"]
[null,null,null,"Yes",{"$f":"COUNTIFS(HData!$R$6:$R$98992,\"Post\",HData!$P$6:$P$98992,\"<=\"&RDate,HData!$P$6:$P$98992,\">=\"&SDate,HData!$F$6:$F$98992,1)","v":0}]
[]
[null,null,null,"Total number of Supported Contact Agreements in the reporting period"]
[null,null,null,"Direct",{"$f":"Instructions!F24","v":0}]
[null,null,null,"Indirect",{"$f":"Instructions!G24","v":0}]
[null,null,null,"Virtual",{"$f":"Instructions!H24","v":0}]

{"sheet":"Queries","index":4,"n_rows":1,"n_cols":6,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
["LA URN","Child ID","Case Type","Case start","Field ID","Query"]

{"sheet":"HData Formulae","index":5,"n_rows":21,"n_cols":3,"rows_kept":21,"cut":false,"hidden":false,"merged":[]}
["Calc ID","Formula (for first row of data in Hdata)","Description"]
["A1",{"$f":"Checks!D23","v":"=IF(COUNT(J6:M6,O6)>0,\"Post\",IF(AND(OR(G6<>\"\",H6<>\"\",COUNT(J6:M6,O6)=0),COUNTA(A6:F6)>0),\"Pre\",\"\"))"},"Pre- or post-order case (flag)"]
["A2","=IF(AND(G6<>\"\",I6<>\"\",ISNUMBER(G6),ISNUMBER(I6)),I6-G6,\"\")","Time from match to case closed"]
["A3","=IF(AND(G6<>\"\",ISNUMBER(G6),U6=\"Open\",R6=\"Pre\"),RDate-G6,\"\")","Time from match to review"]
["A4","=IF(AND(P6<>\"\",P6<=RDate),\"Closed\",\"Open\")","Case open or closed?"]
["A5","=IF(AND(J6<>\"\",K6<>\"\",ISNUMBER(J6),ISNUMBER(K6)),K6-J6,\"\")","Time from contact to allocation"]
["A6","=IF(AND(K6<>\"\",L6<>\"\",ISNUMBER(K6),ISNUMBER(L6)),L6-K6,\"\")","Time from allocation to assessment"]
["A7","=IF(AND(L6<>\"\",M6<>\"\",ISNUMBER(L6),ISNUMBER(M6)),M6-L6,\"\")","Time to complete assessment"]
["A8","=IF(AND(J6<>\"\",P6<>\"\",ISNUMBER(J6),ISNUMBER(P6)),P6-J6,\"\")","Time from contact to closure"]
["A9","=IF(C6<>\"\",DATEDIF(C6,RDate,\"y\"),\"\")","Age at report date"]
["A10","=IF(AND(C6<>\"\",I6<>\"\"),DATEDIF(C6,I6,\"y\"),\"\")","Age at AO"]
["A11","=IF(AND(C6<>\"\",P6<>\"\"),DATEDIF(C6,P6,\"y\"),\"\")","Age when case closed"]
["A12",{"$f":"Checks!D24","v":"=OR(AND(R6=\"Pre\",NOT(OR(AND(I6<SDate,I6<>\"\"),AND(G6<>\"\",G6>RDate)))),AND(R6=\"Post\",NOT(OR(AND(J6<>\"\",J6>RDate),AND(P6<>\"\",P6<SDate)))))"},"Active during reporting period"]
["A13","=IF(COUNTIFS($R$6:$R$100000,\"Pre\",$A$6:$A$100000,$A6,$B$6:$B$100000,$B6)>1,TRUE,FALSE)","Pre-order duplicate"]
["A14","=IF($J6=\"\",\"\",IF(COUNTIFS($A$6:$A$100000,$A6,$B$6:$B$100000,$B6,$J$6:$J$100000,\"<=\"&IF($P6=\"\",DATE(2099,12,31),$P6),$P$6:$P$100000,\">=\"&$J6)+COUNTIFS($A$6:$A$100000,$A6,$B$6:$B$100000,$B6,$J$6:$J$100000,\"<=\"&IF($P6=\"\",DATE(2099,12,31),$P6),$P$6:$P$100000,\"=\")-1>0,TRUE,FALSE))","Post-order duplicate"]
["A16","=VLOOKUP(A6,LA_list,3,FALSE)","Region"]
["A17","=OR(AND(G6>=SDate,G6<=RDate),AND(J6>=SDate,J6<=RDate))","Case opened in reporting year?"]
["A18","=AND(P6>=SDate,P6<=RDate)","Case closed in reporting year?"]
["A19","=IF(R6=\"Post\",IF(P6<>\"\",\"Closed\",IF(M6<>\"\",\"Being supported\",IF(L6<>\"\",\"Being assessed\",IF(K6<>\"\",\"Awaiting assessment\",\"Awaiting allocation\")))),\"\")","Current stage (post-order only)"]
["A20","=IF(AND(M6<>\"\",N6<>\"\",ISNUMBER(M6),ISNUMBER(N6)),N6-M6,\"\")","Time from assessment completed to latest review"]
["A21","=IF(AND(N6<>\"\",P6<>\"\",ISNUMBER(N6),ISNUMBER(P6)),P6-N6,\"\")","Time from latest review to closure"]

{"sheet":"Lists","index":6,"n_rows":159,"n_cols":21,"rows_kept":159,"cut":false,"hidden":false,"merged":[]}
["LA CODE","LA Name","Region",null,"Agency URN","Agency Name",null,"Gender Code","Gender Identity Description",null,"Ethnic Code","Ethnicity Description",null,"Disability Code","Disability Description",null,"SC Referred Code","Referred into Social Care",null,"Reporting date","Reporting year"]
[301,"Barking and Dagenham","London",null,"RAA32","Adopt Birmingham",null,0,"Not known (gender not recorded )",null,"ABAN","Asian Bangladeshi",null,0,"No",null,0,"No",null,"2026-03-31","2025/26"]
[302,"Barnet","London",null,"RAA31","Adopt Coast to Coast",null,1,"Male",null,"AIND","Asian Indian",null,1,"Yes",null,1,"Yes",null,"2027-03-31","2026/27"]
[370,"Barnsley","Yorkshire and the Humber",null,"RAA26","Adopt East",null,2,"Female",null,"AOTH","Any other Asian background",null,null,null,null,null,null,null,"2028-03-31","2027/28"]
[800,"Bath and North East Somerset","South West",null,"RAA20","Adopt London East",null,3,"Non-binary",null,"APKN","Asian Pakistani",null,null,null,null,null,null,null,"2029-03-31","2028/29"]
[822,"Bedford","East of England",null,"RAA22","Adopt London North",null,4,"Transgender Man (Trans Man)",null,"BAFR","Black African",null,null,null,null,null,null,null,"2030-03-31","2029/30"]
[303,"Bexley","London",null,"RAA19","Adopt London South",null,5,"Transgender Woman (Trans Woman)",null,"BCRB","Black Caribbean",null,null,null,null,null,null,null,"2031-03-31","2030/31"]
["213B","Bi-Borough","London",null,"RAA21","Adopt London West",null,6,"Other gender identity",null,"BOTH","Any other Black background"]
[330,"Birmingham","West Midlands",null,"RAA12","Adopt North East",null,7,"Gender identity the same as sex registered at birth but no specific identity given",null,"CHNE","Chinese"]
[889,"Blackburn with Darwen","North West",null,"RAA14","Adopt South",null,8,"Gender identity different from sex registered at birth but no specific identity given",null,"MOTH","Any other mixed background"]
[890,"Blackpool","North West",null,"RAA11","Adopt South West",null,9,"Neither",null,"MWAS","Mixed White and Asian"]
[350,"Bolton","North West",null,"RAA6","Adopt Thames Valley",null,null,null,null,"MWBA","Mixed White and Black African"]
[837,"Bournemouth, Christchurch, Poole","South West",null,"RAA15","Adoption @ Heart",null,null,null,null,"MWBC","Mixed White and Black Caribbean"]
[867,"Bracknell Forest","South East",null,"RAA8","Adoption Central England",null,null,null,null,"NOBT","Information not yet obtained"]
[380,"Bradford","Yorkshire and the Humber",null,"RAA16","Adoption Connects",null,null,null,null,"OOTH","Any other ethnic group"]
[304,"Brent","London",null,"RAA3","Adoption Counts",null,null,null,null,"REFU","Refused"]
[846,"Brighton and Hove","South East",null,"RAA17","Adoption East Midlands",null,null,null,null,"WBRI","White British"]
[801,"Bristol","South West",null,"RAA9","Adoption in Merseyside",null,null,null,null,"WIRI","White Irish"]
[305,"Bromley","London",null,"RAA24","Adoption Lancashire & Blackpool",null,null,null,null,"WIRT","White Traveller of Irish heritage"]
[825,"Buckinghamshire","South East",null,"RAA5","Adoption Now",null,null,null,null,"WOTH","Any other White background"]
[351,"Bury","North West",null,"RAA28","Adoption Partnership South East",null,null,null,null,"WROM","White Gypsy/Roma"]
[381,"Calderdale","Yorkshire and the Humber",null,"RAA23","Adoption South East"]
[873,"Cambridgeshire","East of England",null,"RAA10","Adoption Tees Valley"]
[202,"Camden","London",null,"RAA13","Adoption West"]
[823,"Central Bedfordshire","East of England",null,"RAA2","Aspire"]
[895,"Cheshire East","North West",null,"RAA33","Buckinghamshire Adoption"]
[896,"Cheshire West and Chester","North West",null,"RAA29","Cambridgeshire and Peterborough Adoption"]
[201,"City of London","London",null,"RAA34","Cumbria Adoption"]
[908,"Cornwall","South West",null,"RAA27","Family Adoption Links"]
[331,"Coventry","West Midlands",null,"RAA7","One Adoption North and Humber"]
[306,"Croydon","London",null,"RAA30","One Adoption South Yorkshire"]
[909,"Cumbria",null,null,"RAA1","One Adoption West Yorkshire"]
[942,"Cumberland","North West",null,"RAA4","Together for Adoption"]
[841,"Darlington","North East",null,"RAA25","Together4Children"]
[831,"Derby","East Midlands",null,"VAA15","Ambitious for Adoption delivered by Coram"]
[830,"Derbyshire","East Midlands"]
[878,"Devon","South West"]
[371,"Doncaster","Yorkshire and the Humber"]
[835,"Dorset","South West"]
[332,"Dudley","West Midlands"]
[840,"Durham","North East"]
[307,"Ealing","London"]
[811,"East Riding of Yorkshire","Yorkshire and the Humber"]
[845,"East Sussex","South East"]
[308,"Enfield","London"]
[881,"Essex","East of England"]
[390,"Gateshead","North East"]
[916,"Gloucestershire","South West"]
[203,"Greenwich","London"]
[204,"Hackney","London"]
[876,"Halton","North West"]
[205,"Hammersmith and Fulham","London"]
[850,"Hampshire","South East"]
[309,"Haringey","London"]
[310,"Harrow","London"]
[805,"Hartlepool","North East"]
[311,"Havering","London"]
[884,"Herefordshire","West Midlands"]
[919,"Hertfordshire","East of England"]
[312,"Hillingdon","London"]
[313,"Hounslow","London"]
[921,"Isle of Wight","South East"]
[420,"Isles of Scilly","South West"]
[206,"Islington","London"]
[886,"Kent","South East"]
[810,"Kingston upon Hull","Yorkshire and the Humber"]
[314,"Kingston upon Thames","London"]
[382,"Kirklees","Yorkshire and the Humber"]
[340,"Knowsley","North West"]
[208,"Lambeth","London"]
[888,"Lancashire","North West"]
[383,"Leeds","Yorkshire and the Humber"]
[856,"Leicester","East Midlands"]
[855,"Leicestershire","East Midlands"]
[209,"Lewisham","London"]
[925,"Lincolnshire","East Midlands"]
[341,"Liverpool","North West"]
[821,"Luton","East of England"]
[352,"Manchester","North West"]
[887,"Medway","South East"]
[315,"Merton","London"]
[806,"Middlesbrough","North East"]
[826,"Milton Keynes","South East"]
[391,"Newcastle upon Tyne","North East"]
[316,"Newham","London"]
[926,"Norfolk","East of England"]
[812,"North East Lincolnshire","Yorkshire and the Humber"]
[813,"North Lincolnshire","Yorkshire and the Humber"]
[802,"North Somerset","South West"]
[392,"North Tyneside","North East"]
[815,"North Yorkshire","Yorkshire and the Humber"]
[928,"Northamptonshire","East Midlands"]
[929,"Northumberland","North East"]
[892,"Nottingham","East Midlands"]
[891,"Nottinghamshire","East Midlands"]
[353,"Oldham","North West"]
[931,"Oxfordshire","South East"]
[874,"Peterborough","East of England"]
[879,"Plymouth","South West"]
[851,"Portsmouth","South East"]
[870,"Reading","South East"]
[317,"Redbridge","London"]
[807,"Redcar and Cleveland","North East"]
[318,"Richmond upon Thames","London"]
[354,"Rochdale","North West"]
[372,"Rotherham","Yorkshire and the Humber"]
[857,"Rutland","East Midlands"]
[355,"Salford","North West"]
[333,"Sandwell","West Midlands"]
[343,"Sefton","North West"]
[373,"Sheffield","Yorkshire and the Humber"]
[893,"Shropshire","West Midlands"]
[871,"Slough","South East"]
[334,"Solihull","West Midlands"]
[933,"Somerset","South West"]
[803,"South Gloucestershire","South West"]
[393,"South Tyneside","North East"]
[852,"Southampton","South East"]
[882,"Southend-on-Sea","East of England"]
[210,"Southwark","London"]
[342,"St Helens","North West"]
[860,"Staffordshire","West Midlands"]
[356,"Stockport","North West"]
[808,"Stockton-on-Tees","North East"]
[861,"Stoke-on-Trent","West Midlands"]
[935,"Suffolk","East of England"]
[394,"Sunderland","North East"]
[936,"Surrey","South East"]
[319,"Sutton","London"]
[866,"Swindon","South West"]
[357,"Tameside","North West"]
[894,"Telford and Wrekin","West Midlands"]
[883,"Thurrock","East of England"]
[880,"Torbay","South West"]
[211,"Tower Hamlets","London"]
[358,"Trafford","North West"]
[384,"Wakefield","Yorkshire and the Humber"]
[335,"Walsall","West Midlands"]
[320,"Waltham Forest","London"]
[212,"Wandsworth","London"]
[877,"Warrington","North West"]
[937,"Warwickshire","West Midlands"]
[869,"West Berkshire","South East"]
[938,"West Sussex","South East"]
[943,"Westmoreland and Furness","North West"]
[359,"Wigan","North West"]
[865,"Wiltshire","South West"]
[868,"Windsor and Maidenhead","South East"]
[344,"Wirral","North West"]
[872,"Wokingham","South East"]
[336,"Wolverhampton","West Midlands"]
[885,"Worcestershire","West Midlands"]
[816,"York","Yorkshire and the Humber"]
["xxOSUK","Outside UK","Outside England"]
["xxSCOT","Scotland","Outside England"]
["xxWALE","Wales","Outside England"]
["xIOM","Isle of Man","Outside England"]
["xxNIRE","Northern Ireland","Outside England"]
["xxOTUK","Other UK","Outside England"]

{"sheet":"Checks","index":7,"n_rows":45,"n_cols":5,"rows_kept":45,"cut":false,"hidden":false,"merged":[]}
["THIS SHEET NEEDS TO BE UPDATED INCLUDING CHECK FORMULAE"]
[]
["DATA FIELD","PRE ADOPTION ORDER","POST ADOPTION ORDER"]
["C1","Compulsory","Compulsory"]
["C2","Compulsory","Compulsory"]
["C3","Compulsory","Compulsory"]
["C4","Compulsory","Compulsory"]
["C5","Compulsory","Compulsory"]
["C6","Compulsory","Compulsory"]
["C7","Compulsory","Compulsory"]
["C8","Compulsory","leave blank"]
["C9","sequentially","leave blank"]
["C10","sequentially","Compulsory"]
["C11","leave blank","sequentially"]
["C12","leave blank","sequentially"]
["C13","leave blank","sequentially"]
["C14","leave blank","sequentially"]
["C15","Date after C8","sequentially"]
["C16","leave blank","sequentially"]
["C17","Same date as C10","sequentially"]
[]
["Check ID","Relevant Data Field","Description of field","Check formula (for first row of data in AS Data)"]
["A1",null,"Pre- or post-order case (flag)","=IF(COUNT(J6:M6,O6)>0,\"Post\",IF(AND(OR(G6<>\"\",H6<>\"\",COUNT(J6:M6,O6)=0),COUNTA(A6:F6)>0),\"Pre\",\"\"))"]
["A12",null,"In reporting period flag","=OR(AND(R6=\"Pre\",NOT(OR(AND(I6<SDate,I6<>\"\"),AND(G6<>\"\",G6>RDate)))),AND(R6=\"Post\",NOT(OR(AND(J6<>\"\",J6>RDate),AND(P6<>\"\",P6<SDate)))))"]
["A15",null,"Missing record from Hdata flag - filled in by macro for compiling data"]
["B1","C1","Check cell is not blank and URN is in LA_list","=IF(R6<>\"\",IF(OR(A6=\"\",ISNA(MATCH(A6,LA_URN,0))),\"Please record a valid LA URN\",\"\"),\"\")"]
["B2","C2","check cell is not blank","=IF(R6<>\"\",IF(NOT(S6),\"This case falls outside the reporting period, so this case does not need to be included in the return\",IF(B6=\"\",\"Please record the child's CMS ID.\",\"\")))"]
["B3","C3","check cell is not blank, is a date, is not in the future and is not over 25 years ago","=IF(R6<>\"\",IF(C6=\"\",\"Please record the date of birth for this child\",IF(NOT(ISNUMBER(C6)),\"Please enter a valid date for the date of birth\",IF(C6>RDate,\"Please enter a date that is not after the reporting period\",IF(DATEDIF(C6,RDate,\"y\")>=25,\"Cases for individuals aged 25 or over should not be included in this data return\",IF(C6>MIN(G6:N6,P6),\"Date of birth cannot be after any of the dates in the adoption journey - please correct whichever dates are wrong\",\"\"))))),\"\")"]
["B4","C4","Check cell is not blank and is in Gender_list","=IF(R6<>\"\",IF(OR(D6=\"\",ISNA(MATCH(D6,Gender_list,0))),\"Please record a valid gender code\",\"\"),\"\")"]
["B5","C5","Check cell is not blank and is in Ethnicity_list","=IF(R6<>\"\",IF(OR(E6=\"\",ISNA(MATCH(E6,Eth_list,0))),\"Please record a valid ethnicity code\",\"\"),\"\")"]
["B6","C6","Check cell is not blank and is either 0 or 1","=IF(R6<>\"\",IF(OR(F6=\"\",AND(F6<>0,F6<>1)),\"Please record a valid Disability code\",\"\"),\"\")"]
["B7","C7","If not blank, check entry is a date, is after DOB and is not in the future | if C8 and C9 are blank, and C7 has a date, that date should be in this reporting year | If C8 is not blank, C7 should not be blank","=IF(G6<>\"\",IF(NOT(ISNUMBER(G6)),\"Please enter a valid date for the match approval\",IF(G6<C6,\"The adoptive match cannot have been approved before the child was born. Please correct either C3 or C8\",\"\")),IF(AND(H6<>\"\",ISNUMBER(H6)),\"This date is missing, please add it\",\"\"))"]
["B8","C8","If not blank, check entry is a date, is after ADM (C7) and is not in the future | If C9 is blank and C8 has a date, that date should be in this reporting year | If C7 and C9 are not blank, C8 should not be blank","=IF(H6=\"\",IF(AND(I6<>\"\",G6<>\"\"),\"Date is missing, please add it\",\"\"),IF(NOT(ISNUMBER(H6)),\"Please enter a valid date\",IF(H6<G6,\"Placement date cannot be before date match was approved - please correct either C7 or C8\",\"\")))"]
["B9","C9","If not blank, check entry is a date | check is after C8 (pre-order case) or before C10 (post-order case), is in reporting period | If C10 is not blank then C9 should not be blank","=IF(AND(COUNT(J6:M6)>0,I6=\"\"),\"Date of AO is missing, please add it\",IF(I6<>\"\",IF(NOT(ISNUMBER(I6)),\"Please enter a valid date\",IF(AND(H6<>\"\",I6<>\"\",ISNUMBER(H6),ISNUMBER(I6),H6>I6),\"Date of AO cannot be before placement date - please correct either C8 or C9\",IF(AND(J6<>\"\",ISNUMBER(J6),I6<>\"\",ISNUMBER(I6),I6>J6),\"Date of AO cannot be after post-order contact - please correct C9 or C10\",\"\"))),\"\"))"]
["B10","C10","If any of C11, C12, C13, C14 and C16 are not blank then C10 should not be blank | check if case is active in this reporting year | If not blank, check entry is a date and is after AO date","=IF(J6=\"\",IF(OR(R6=\"Post\",COUNT(K6:N6)>0),\"Date appears to be missing, please add it\",\"\"),IF(NOT(ISNUMBER(J6)),\"Please enter a valid date\",IF(J6<I6,\"Contact date cannot be before Date of AO - please correct either C9 or C10\",\"\")))"]
["B11","C11","if any of C13, C14, C16, C17 are not blank THEN C12 should not be blank | If not blank, check entry is a date, is after contact date (C11) and is not in the future","=IF(K6=\"\",IF(OR(COUNT(L6:M6)>0,AND(N6<>\"\",ISNUMBER(N6),R6=\"Post\")),\"Date of allocation appears to be missing, please add it\",\"\"),IF(NOT(ISNUMBER(K6)),\"Please enter a valid date\",IF(K6<J6,\"Case cannot be allocated before Contact - please correct either C10 or C11\",\"\")))"]
["B12","C12","if any of C14, C16, C17 are not blank THEN C13 should not be blank | If not blank, check entry is a date, is after C12 and is not in the future","=IF(L6=\"\",IF(OR(COUNT(M6)>0,AND(N6<>\"\",ISNUMBER(N6),R6=\"Post\")),\"Assessment start date appears to be missing, please add it\",\"\"),IF(NOT(ISNUMBER(L6)),\"Please enter a valid date\",IF(L6<K6,\"Assessment start date cannot be before allocation date - please correct either C11 or C12\",\"\")))"]
["B13","C13","if any of C16, C17 are not blank THEN C14 should not be blank | If not blank, check entry is a date, is after C13 and is not in the future","=IF(M6=\"\",IF(AND(N6<>\"\",ISNUMBER(N6),R6=\"Post\"),\"Assessment completion date is missing or review date has been incorrectly recorded - please correct either C13 or C14\",\"\"),IF(NOT(ISNUMBER(M6)),\"Please enter a valid date\",IF(M6<L6,\"Assessment cannot be completed before it is started - please correct either C12 or C13\",\"\")))"]
["B14","C14","if there is a placement date and there is more than a year between placement and AO OR more than year since placement and no AO date, we would expect there to be an entry | if more than a year has passed since C14 OR there is more than a year between C14 and C17 THEN C15 should not be blank | If C15 is not blank and there is an assessment completed date (C14), check entry is after C14, before C17 (if recorded) and not in the future | If there is a placement date and C15 is not blank, check C15 is after placement, before AO (if recorded) and not in the future","=IF(N6=\"\",IF(OR(AND(H6<>\"\",OR(IFERROR(DATEDIF(H6,I6,\"y\"),0)>=1,IFERROR(DATEDIF(H6,RDate,\"y\"),0)>=1)),AND(M6<>\"\",OR(IFERROR(DATEDIF(M6,P6,\"y\"),0)>=1,IFERROR(DATEDIF(M6,RDate,\"y\"),0)>=1))),\"Date appears to be missing - please record the date of review\",\"\"),IF(NOT(ISNUMBER(N6)),\"Please enter a valid date\",IF(AND(M6<>\"\",N6<M6),\"Review date cannot be before assessment was completed - please correct either C13 or C14\",IF(AND(P6<>\"\",N6>P6),\"Review date cannot be after case was closed - please correct either C14 or C16\",IF(AND(H6<>\"\",N6<H6),\"Review date cannot be before date of placement - please correct either C8 or C14\",IF(AND(I6<>\"\",N6>I6,H6<>\"\",R6=\"Pre\"),\"Review date cannot be after date of AO - please correct either C9 or C14\",\"\"))))))"]
["B15","C15","If not blank, check entry is either 0 or 1","=IF(AND(O6<>\"\",O6<>0,O6<>1),\"Please record a valid code\",\"\")"]
["B16","C16","If not blank, check entry is a date, is after review date (if recorded) and contact date, is not in the future and is not before the reporting period","=IF(P6<>\"\",IF(NOT(ISNUMBER(P6)),\"Please enter a valid date\",IF(AND(N6<>\"\",ISNUMBER(N6),N6>P6),\"Closure date cannot be before the latest Review date - please correct either C14 or C16\",IF(AND(J6<>\"\",ISNUMBER(J6),J6>P6),\"Closure date cannot be before the initial contact date - please correct C10 or C16\",IF(P6<SDate,\"Case was closed before reporting period. Only include it in this data return if it was not included in a previous return\",IF(AND(I6<>\"\",ISNUMBER(I6),P6<I6),\"Closure date cannot be before the date of AO - please correct C9 or C16\",\"\"))))),\"\")"]
["B17","C2","Duplicate pre-order record","=IF(COUNTIFS($R$6:$R$100000,\"Pre\",$A$6:$A$100000,$A6,$B$6:$B$100000,$B6)>1,\"This is a duplicate record. Please ensure there are no duplicates in your data.\",\"\")","checks if this record is a duplicate of another record - for pre-order cases there can only be one case per child (so count how many times a child ID occurs along with pre-order flag)"]
["B18","C2","Duplicate post-order record","=IF($J6=\"\",\"\",IF(COUNTIFS($A$6:$A$100000,$A6,$B$6:$B$100000,$B6,$J$6:$J$100000,\"<=\"&IF($P6=\"\",DATE(2099,12,31),$P6),$P$6:$P$100000,\">=\"&$J6)+COUNTIFS($A$6:$A$100000,$A6,$B$6:$B$100000,$B6,$J$6:$J$100000,\"<=\"&IF($P6=\"\",DATE(2099,12,31),$P6),$P$6:$P$100000,\"=\")-1>0,\"This is a duplicate record. Please ensure there are no duplicates in your data.\",\"\"))","checks if this record is a duplicate of another record - for post-order cases only one case can be open at a time for a child (so check that case time periods do not overlap if a there is more than one record for a child)"]
["B19","C2","Missing record from Hdata","=IF(T6=TRUE,\"This record has been added as it appears to be missing in your data return. It was included in a previous return and the case appeared to be still active at the time.\",\"\")"]
["B20","C2","Pre- and post-order data in record","=IF(AND(COUNT(G6:H6)>0,COUNT(J6:M6,O6)>0,I6>=SDate,I6<=RDate),\"A record should not include data for both pre-order and post-order support. Please correct the data entered and add another record if necessary.\",\"\")"]

{"sheet":"Analysis","index":8,"n_rows":2,"n_cols":4,"rows_kept":2,"cut":false,"hidden":true,"merged":[]}
[{"$f":"INDEX(ReportingPeriod[Reporting date],MATCH(Instructions!J4,ReportingPeriod[Reporting year],0))","v":"2026-03-31"},null,{"$f":"Instructions!J8","v":0},{"$f":"INDEX(RAA_list[Agency URN],MATCH(C1,RAA_list[Agency Name],0))","v":{"$error":"#N/A"}}]
[{"$f":"IF(MONTH(RDate)=3,DATE(YEAR(RDate)-1,4,1),DATE(YEAR(RDate),4,1))","v":"2025-04-01"}]