{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Instructions","AS Data","Dashboard","Checks","Queries","Lists","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":[[23,1,23,4],[21,1,21,4],[22,1,22,4],[3,9,3,15],[5,9,5,15],[7,9,7,15],[19,1,19,5]]}
[]
[null,"ADOPTION SUPPORT DATA COLLECTION"]
[]
[null,"Reporting period to which the data relates to: ",null,null,null,null,null,null,null,"2025/26 Q1 and Q2 Pilot"]
[]
[null,"Please enter the email address of the person completing this return:"]
[]
[null,"Please select the name of your agency:"]
[]
[]
[null,"INSTRUCTIONS"]
[]
[null,"The '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 'CHECK 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,"C0"]
[null,"Type of Supported Contact Agreement",null,null,null,"2025/26 Q1 and Q2 Pilot"]
[null,"Direct"]
[null,"Indirect"]
[null,"Virtual"]

{"sheet":"AS Data","index":1,"n_rows":202,"n_cols":46,"rows_kept":202,"cut":false,"hidden":false,"merged":[[2,0,2,6],[2,7,2,16]]}
[]
[]
["THE CHILD",null,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","B1","B2","B3","B4","B5","B6","B7","B8","B9","B10","B11","B12","B13","B14","B15","B16","B17","A2","A3","A4","A5","A6","A7","A8","A9","A10","A11","A12"]
["LA Code  of Responsible  Local Authority","Child/Young Person  Identifier","Contact 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","Pre- or post-order case (flag)",{"$f":"_xlfn.XLOOKUP(S$4,Checks!$A$23:$A$47,Checks!$B$23:$B$47,\"\",0,1)","v":"C1"},{"$f":"_xlfn.XLOOKUP(T$4,Checks!$A$23:$A$47,Checks!$B$23:$B$47,\"\",0,1)","v":"C2"},{"$f":"_xlfn.XLOOKUP(U$4,Checks!$A$23:$A$47,Checks!$B$23:$B$47,\"\",0,1)","v":"C3"},{"$f":"_xlfn.XLOOKUP(V$4,Checks!$A$23:$A$47,Checks!$B$23:$B$47,\"\",0,1)","v":"C4"},{"$f":"_xlfn.XLOOKUP(W$4,Checks!$A$23:$A$47,Checks!$B$23:$B$47,\"\",0,1)","v":"C5"},{"$f":"_xlfn.XLOOKUP(X$4,Checks!$A$23:$A$47,Checks!$B$23:$B$47,\"\",0,1)","v":"C6"},{"$f":"_xlfn.XLOOKUP(Y$4,Checks!$A$23:$A$47,Checks!$B$23:$B$47,\"\",0,1)","v":"C7"},{"$f":"_xlfn.XLOOKUP(Z$4,Checks!$A$23:$A$47,Checks!$B$23:$B$47,\"\",0,1)","v":"C8"},{"$f":"_xlfn.XLOOKUP(AA$4,Checks!$A$23:$A$47,Checks!$B$23:$B$47,\"\",0,1)","v":"C9"},{"$f":"_xlfn.XLOOKUP(AB$4,Checks!$A$23:$A$47,Checks!$B$23:$B$47,\"\",0,1)","v":"C10"},{"$f":"_xlfn.XLOOKUP(AC$4,Checks!$A$23:$A$47,Checks!$B$23:$B$47,\"\",0,1)","v":"C11"},{"$f":"_xlfn.XLOOKUP(AD$4,Checks!$A$23:$A$47,Checks!$B$23:$B$47,\"\",0,1)","v":"C12"},{"$f":"_xlfn.XLOOKUP(AE$4,Checks!$A$23:$A$47,Checks!$B$23:$B$47,\"\",0,1)","v":"C13"},{"$f":"_xlfn.XLOOKUP(AF$4,Checks!$A$23:$A$47,Checks!$B$23:$B$47,\"\",0,1)","v":"C14"},{"$f":"_xlfn.XLOOKUP(AG$4,Checks!$A$23:$A$47,Checks!$B$23:$B$47,\"\",0,1)","v":"C15"},{"$f":"_xlfn.XLOOKUP(AH$4,Checks!$A$23:$A$47,Checks!$B$23:$B$47,\"\",0,1)","v":"C16"},{"$f":"_xlfn.XLOOKUP(AI$4,Checks!$A$23:$A$47,Checks!$B$23:$B$47,\"\",0,1)","v":"C17"},"Time from match to case closed","Time from match to review","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"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(OR(H6<>\"\",I6<>\"\"),COUNTA(A6:G6)>0),\"Pre\",IF(COUNT(K6:Q6)>0,\"Post\",\"\"))","v":""},{"$f":"IF(R6<>\"\",IF(OR(A6=\"\",ISNA(MATCH(A6,LA_URN,0))),\"Please record a valid LA URN\",\"\"),\"\")","v":""},{"$f":"IF(R6<>\"\",IF(B6=\"\",\"Please record the child's CMS ID\",\"\"),\"\")","v":""},{"$f":"IF(R6<>\"\",IF(C6=\"\",\"Please record a unique identifier for this case\",IF(COUNTIF($C$6:$C$100000,C6)>1,\"The contact identifier must be unique - please correct this case or other cases that have the same contact identifier recorded\",\"\")),\"\")","v":""},{"$f":"IF(R6<>\"\",IF(D6=\"\",\"Please record the date of birth for this child\",IF(OR(D6>TODAY(),NOT(ISNUMBER(D6))),\"Please enter a valid date for the date of birth\",IF(D6>RDate,\"Please enter a date that is not after the reporting period\",IF(DATEDIF(D6,RDate,\"y\")>=25,\"Cases for individuals aged 25 or over should not be included in this data return\",IF(D6>MIN(H6:O6,Q6),\"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(E6=\"\",ISNA(MATCH(E6,Gender_list,0))),\"Please record a valid gender code\",\"\"),\"\")","v":""},{"$f":"IF(R6<>\"\",IF(OR(F6=\"\",ISNA(MATCH(F6,Eth_list,0))),\"Please record a valid ethnicity code\",\"\"),\"\")","v":""},{"$f":"IF(R6<>\"\",IF(OR(G6=\"\",AND(G6<>0,G6<>1)),\"Please record a valid Disability code\",\"\"),\"\")","v":""},{"$f":"IF(H6<>\"\",IF(OR(H6>TODAY(),NOT(ISNUMBER(H6))),\"Please enter a valid date\",IF(H6<D6,\"The adoptive match cannot have been approved before the child was born\",IF(H6>RDate,\"This date indicates that the adoptive match was approved after the reporting period, so this case should not be included in the return\",IF(AND(I6=\"\",J6=\"\",OR(H6<SDate,I6>RDate)),\"This date falls outside the reporting period, so this case should not be included in the return\",\"\")))),IF(AND(I6<>\"\",ISNUMBER(I6)),\"This date is missing, please add it\",\"\"))","v":""},{"$f":"IF(I6=\"\",IF(AND(J6<>\"\",H6<>\"\"),\"Date is missing, please add it\",\"\"),IF(OR(I6>TODAY(),NOT(ISNUMBER(I6))),\"Please enter a valid date\",IF(I6<H6,\"Placement date cannot be before date match was approved - please correct either C8 or C9\",IF(AND(J6=\"\",OR(I6<SDate,I6>RDate)),\"This case falls outside the reporting period and so does not need to be included in this data return\",IF(I6>RDate,\"Date recorded is after reporting period, so this case does not need to be included in this data return\",\"\")))))","v":""},{"$f":"IF(AND(COUNT(K6:N6,Q6)>0,J6=\"\"),\"Date is missing, please add it\",IF(J6<>\"\",IF(OR(J6>TODAY(),NOT(ISNUMBER(J6))),\"Please enter a valid date\",IF(AND(I6<>\"\",ISNUMBER(I6),I6>J6),\"Date of AO cannot be before placement date - please correct either C9 or C10\",IF(AND(K6<>\"\",ISNUMBER(K6),J6>K6),\"Date of AO cannot be after post-order contact - please correct C10 or C11\",IF(OR(J6>RDate,AND(J6<SDate,R6=\"Pre\")),\"This case falls outside the reporting period and so does not need to be included in this data return\",\"\")))),\"\"))","v":""},{"$f":"IF(K6=\"\",IF(OR(R6=\"Post\",COUNT(L6:N6,Q6)>0),\"Date is missing, please add it\",\"\"),IF(OR(K6>TODAY(),NOT(ISNUMBER(K6))),\"Please enter a valid date\",IF(K6<J6,\"Contact date cannot be before Date of AO - please correct either C10 or C11\",IF(AND(R6=\"Post\",COUNT(L6:N6,P6:Q6)=0,OR(K6<SDate,K6>RDate)),\"Date of contact is outside the reporting period, so this record should not be included in this data return\",IF(K6>RDate,\"Date of contact is after the reporting period, so this record should ont be included in this data record\",\"\")))))","v":""},{"$f":"IF(L6=\"\",IF(COUNT(M6:N6,Q6)>0,\"Date is missing, please add it\",\"\"),IF(OR(L6>TODAY(),NOT(ISNUMBER(L6))),\"Please enter a valid date\",IF(L6<K6,\"Allocation date cannot be before Contact - please correct either C11 or C12\",\"\")))","v":""},{"$f":"IF(M6=\"\",IF(COUNT(N6,Q6)>0,\"Date is missing, please add it\",\"\"),IF(OR(M6>TODAY(),NOT(ISNUMBER(M6))),\"Please enter a valid date\",IF(M6<L6,\"Assessment start date cannot be before allocation date - please correct either C12 or C13\",\"\")))","v":""},{"$f":"IF(N6=\"\",IF(COUNT(Q6)>0,\"Date is missing, please add it\",\"\"),IF(OR(N6>TODAY(),NOT(ISNUMBER(N6))),\"Please enter a valid date\",IF(N6<M6,\"Assessment cannot be completed before it is started - please correct either C13 or C14\",\"\")))","v":""},{"$f":"IF(O6=\"\",IF(OR(AND(I6<>\"\",OR(IFERROR(DATEDIF(I6,J6,\"y\"),0)>=1,IFERROR(DATEDIF(I6,RDate,\"y\"),0)>=1)),AND(N6<>\"\",OR(IFERROR(DATEDIF(N6,Q6,\"y\"),0)>=1,IFERROR(DATEDIF(N6,RDate,\"y\"),0)>=1))),\"Date appears to be missing - please record the date of review\",\"\"),IF(OR(O6>TODAY(),NOT(ISNUMBER(O6))),\"Please enter a valid date\",IF(AND(N6<>\"\",O6<N6),\"Review date cannot be before assessment was completed - please correct either C14 or C15\",IF(AND(Q6<>\"\",O6>Q6),\"Review date cannot be after case was closed - please correct either C15 or C17\",IF(AND(I6<>\"\",O6<I6),\"Review date cannot be before date of placement - please correct either C9 or C15\",IF(AND(J6<>\"\",O6>J6,I6<>\"\"),\"Review date cannot be after date of AO - please correct either C10 or C15\",\"\"))))))","v":""},{"$f":"IF(AND(P6<>\"\",P6<>0,P6<>1),\"Please record a valid code\",\"\")","v":""},{"$f":"IF(Q6<>\"\",IF(OR(Q6>TODAY(),NOT(ISNUMBER(Q6))),\"Please enter a valid date\",IF(AND(O6<>\"\",ISNUMBER(O6),O6>Q6),\"Closure date cannot be earlier than the latest Review - please correct either C15 or C17\",IF(AND(K6<>\"\",ISNUMBER(K6),K6>Q6),\"Closure date cannot be earlier than the initial contact date - please correct C11 or C17\",IF(Q6<SDate,\"Case was closed before reporting period and so does not need to be included in this data return\",\"\")))),\"\")","v":""},{"$f":"IF(AND(H6<>\"\",J6<>\"\",ISNUMBER(H6),ISNUMBER(J6)),J6-H6,\"\")","v":""},{"$f":"IF(AND(H6<>\"\",O6<>\"\",ISNUMBER(H6),ISNUMBER(O6)),O6-H6,\"\")","v":""},{"$f":"IF(R6<>\"\",IF(OR(AND(R6=\"Post\",Q6<>\"\",Q6<RDate),AND(R6=\"Pre\",J6<>\"\",J6<RDate)),\"Closed\",\"Open\"),\"\")","v":""},{"$f":"IF(AND(K6<>\"\",L6<>\"\",ISNUMBER(K6),ISNUMBER(L6)),L6-K6,\"\")","v":""},{"$f":"IF(AND(L6<>\"\",M6<>\"\",ISNUMBER(L6),ISNUMBER(M6)),M6-L6,\"\")","v":""},{"$f":"IF(AND(M6<>\"\",N6<>\"\",ISNUMBER(M6),ISNUMBER(N6)),N6-M6,\"\")","v":""},{"$f":"IF(AND(K6<>\"\",Q6<>\"\",ISNUMBER(K6),ISNUMBER(Q6)),Q6-K6,\"\")","v":""},{"$f":"IF(D6<>\"\",DATEDIF(D6,RDate,\"y\"),\"\")","v":""},{"$f":"IF(D6<>\"\",DATEDIF(D6,J6,\"y\"),\"\")","v":""},{"$f":"IF(D6<>\"\",DATEDIF(D6,Q6,\"y\"),\"\")","v":""},{"$f":"NOT(OR(AND(K6<>\"\",K6>RDate),AND(Q6<>\"\",Q6<SDate)))","v":{"$error":"#NAME?"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(OR(H7<>\"\",I7<>\"\"),COUNTA(A7:G7)>0),\"Pre\",IF(COUNT(K7:Q7)>0,\"Post\",\"\"))","v":""},"",{"$f":"IF(R7<>\"\",IF(B7=\"\",\"Please record the child's CMS ID\",\"\"),\"\")","v":""},{"$f":"IF(R7<>\"\",IF(C7=\"\",\"Please record a unique identifier for this case\",IF(COUNTIF($C$6:$C$100000,C7)>1,\"The contact identifier must be unique - please correct this case or other cases that have the same contact identifier recorded\",\"\")),\"\")","v":""},"","","",{"$f":"IF(R7<>\"\",IF(OR(G7=\"\",AND(G7<>0,G7<>1)),\"Please record a valid Disability code\",\"\"),\"\")","v":""},"","","","",{"$f":"IF(L7=\"\",IF(COUNT(M7:N7,Q7)>0,\"Date is missing, please add it\",\"\"),IF(OR(L7>TODAY(),NOT(ISNUMBER(L7))),\"Please enter a valid date\",IF(L7<K7,\"Allocation date cannot be before Contact - please correct either C11 or C12\",\"\")))","v":""},{"$f":"IF(M7=\"\",IF(COUNT(N7,Q7)>0,\"Date is missing, please add it\",\"\"),IF(OR(M7>TODAY(),NOT(ISNUMBER(M7))),\"Please enter a valid date\",IF(M7<L7,\"Assessment start date cannot be before allocation date - please correct either C12 or C13\",\"\")))","v":""},{"$f":"IF(N7=\"\",IF(COUNT(Q7)>0,\"Date is missing, please add it\",\"\"),IF(OR(N7>TODAY(),NOT(ISNUMBER(N7))),\"Please enter a valid date\",IF(N7<M7,\"Assessment cannot be completed before it is started - please correct either C13 or C14\",\"\")))","v":""},"",{"$f":"IF(AND(P7<>\"\",P7<>0,P7<>1),\"Please record a valid code\",\"\")","v":""},"",{"$f":"IF(AND(H7<>\"\",J7<>\"\",ISNUMBER(H7),ISNUMBER(J7)),J7-H7,\"\")","v":""},{"$f":"IF(AND(H7<>\"\",O7<>\"\",ISNUMBER(H7),ISNUMBER(O7)),O7-H7,\"\")","v":""},"",{"$f":"IF(AND(K7<>\"\",L7<>\"\",ISNUMBER(K7),ISNUMBER(L7)),L7-K7,\"\")","v":""},{"$f":"IF(AND(L7<>\"\",M7<>\"\",ISNUMBER(L7),ISNUMBER(M7)),M7-L7,\"\")","v":""},{"$f":"IF(AND(M7<>\"\",N7<>\"\",ISNUMBER(M7),ISNUMBER(N7)),N7-M7,\"\")","v":""},{"$f":"IF(AND(K7<>\"\",Q7<>\"\",ISNUMBER(K7),ISNUMBER(Q7)),Q7-K7,\"\")","v":""},"",{"$f":"IF(D7<>\"\",DATEDIF(D7,J7,\"y\"),\"\")","v":""},{"$f":"IF(D7<>\"\",DATEDIF(D7,Q7,\"y\"),\"\")","v":""},{"$error":"#NAME?"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$error":"#NAME?"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$error":"#NAME?"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$error":"#NAME?"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$error":"#NAME?"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$error":"#NAME?"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$error":"#NAME?"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$error":"#NAME?"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$error":"#NAME?"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$error":"#NAME?"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$error":"#NAME?"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$error":"#NAME?"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$error":"#NAME?"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$error":"#NAME?"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$error":"#NAME?"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$error":"#NAME?"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$error":"#NAME?"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$error":"#NAME?"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$error":"#NAME?"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$error":"#NAME?"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$error":"#NAME?"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$error":"#NAME?"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$error":"#NAME?"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$error":"#NAME?"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$error":"#NAME?"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$error":"#NAME?"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$error":"#NAME?"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$error":"#NAME?"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$error":"#NAME?"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$error":"#NAME?"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$error":"#NAME?"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"IF(R38<>\"\",IF(OR(A38=\"\",ISNA(MATCH(A38,LA_URN,0))),\"Please record a valid LA URN\",\"\"),\"\")","v":""},"","",{"$f":"IF(R38<>\"\",IF(D38=\"\",\"Please record the date of birth for this child\",IF(OR(D38>TODAY(),NOT(ISNUMBER(D38))),\"Please enter a valid date for the date of birth\",IF(D38>RDate,\"Please enter a date that is not after the reporting period\",IF(DATEDIF(D38,RDate,\"y\")>=25,\"Cases for individuals aged 25 or over should not be included in this data return\",IF(D38>MIN(H38:O38,Q38),\"Date of birth cannot be after any of the dates in the adoption journey - please correct whichever dates are wrong\",\"\"))))),\"\")","v":""},{"$f":"IF(R38<>\"\",IF(OR(E38=\"\",ISNA(MATCH(E38,Gender_list,0))),\"Please record a valid gender code\",\"\"),\"\")","v":""},{"$f":"IF(R38<>\"\",IF(OR(F38=\"\",ISNA(MATCH(F38,Eth_list,0))),\"Please record a valid ethnicity code\",\"\"),\"\")","v":""},"",{"$f":"IF(H38<>\"\",IF(OR(H38>TODAY(),NOT(ISNUMBER(H38))),\"Please enter a valid date\",IF(H38<D38,\"The adoptive match cannot have been approved before the child was born\",IF(H38>RDate,\"This date indicates that the adoptive match was approved after the reporting period, so this case should not be included in the return\",IF(AND(I38=\"\",J38=\"\",OR(H38<SDate,I38>RDate)),\"This date falls outside the reporting period, so this case should not be included in the return\",\"\")))),IF(AND(I38<>\"\",ISNUMBER(I38)),\"This date is missing, please add it\",\"\"))","v":""},{"$f":"IF(I38=\"\",IF(AND(J38<>\"\",H38<>\"\"),\"Date is missing, please add it\",\"\"),IF(OR(I38>TODAY(),NOT(ISNUMBER(I38))),\"Please enter a valid date\",IF(I38<H38,\"Placement date cannot be before date match was approved - please correct either C8 or C9\",IF(AND(J38=\"\",OR(I38<SDate,I38>RDate)),\"This case falls outside the reporting period and so does not need to be included in this data return\",IF(I38>RDate,\"Date recorded is after reporting period, so this case does not need to be included in this data return\",\"\")))))","v":""},{"$f":"IF(AND(COUNT(K38:N38,Q38)>0,J38=\"\"),\"Date is missing, please add it\",IF(J38<>\"\",IF(OR(J38>TODAY(),NOT(ISNUMBER(J38))),\"Please enter a valid date\",IF(AND(I38<>\"\",ISNUMBER(I38),I38>J38),\"Date of AO cannot be before placement date - please correct either C9 or C10\",IF(AND(K38<>\"\",ISNUMBER(K38),J38>K38),\"Date of AO cannot be after post-order contact - please correct C10 or C11\",IF(OR(J38>RDate,AND(J38<SDate,R38=\"Pre\")),\"This case falls outside the reporting period and so does not need to be included in this data return\",\"\")))),\"\"))","v":""},{"$f":"IF(K38=\"\",IF(OR(R38=\"Post\",COUNT(L38:N38,Q38)>0),\"Date is missing, please add it\",\"\"),IF(OR(K38>TODAY(),NOT(ISNUMBER(K38))),\"Please enter a valid date\",IF(K38<J38,\"Contact date cannot be before Date of AO - please correct either C10 or C11\",IF(AND(R38=\"Post\",COUNT(L38:N38,P38:Q38)=0,OR(K38<SDate,K38>RDate)),\"Date of contact is outside the reporting period, so this record should not be included in this data return\",IF(K38>RDate,\"Date of contact is after the reporting period, so this record should ont be included in this data record\",\"\")))))","v":""},"","","",{"$f":"IF(O38=\"\",IF(OR(AND(I38<>\"\",OR(IFERROR(DATEDIF(I38,J38,\"y\"),0)>=1,IFERROR(DATEDIF(I38,RDate,\"y\"),0)>=1)),AND(N38<>\"\",OR(IFERROR(DATEDIF(N38,Q38,\"y\"),0)>=1,IFERROR(DATEDIF(N38,RDate,\"y\"),0)>=1))),\"Date appears to be missing - please record the date of review\",\"\"),IF(OR(O38>TODAY(),NOT(ISNUMBER(O38))),\"Please enter a valid date\",IF(AND(N38<>\"\",O38<N38),\"Review date cannot be before assessment was completed - please correct either C14 or C15\",IF(AND(Q38<>\"\",O38>Q38),\"Review date cannot be after case was closed - please correct either C15 or C17\",IF(AND(I38<>\"\",O38<I38),\"Review date cannot be before date of placement - please correct either C9 or C15\",IF(AND(J38<>\"\",O38>J38,I38<>\"\"),\"Review date cannot be after date of AO - please correct either C10 or C15\",\"\"))))))","v":""},"",{"$f":"IF(Q38<>\"\",IF(OR(Q38>TODAY(),NOT(ISNUMBER(Q38))),\"Please enter a valid date\",IF(AND(O38<>\"\",ISNUMBER(O38),O38>Q38),\"Closure date cannot be earlier than the latest Review - please correct either C15 or C17\",IF(AND(K38<>\"\",ISNUMBER(K38),K38>Q38),\"Closure date cannot be earlier than the initial contact date - please correct C11 or C17\",IF(Q38<SDate,\"Case was closed before reporting period and so does not need to be included in this data return\",\"\")))),\"\")","v":""},"","",{"$f":"IF(R38<>\"\",IF(OR(AND(R38=\"Post\",Q38<>\"\",Q38<RDate),AND(R38=\"Pre\",J38<>\"\",J38<RDate)),\"Closed\",\"Open\"),\"\")","v":""},"","","","",{"$f":"IF(D38<>\"\",DATEDIF(D38,RDate,\"y\"),\"\")","v":""},"","",{"$f":"NOT(OR(AND(K38<>\"\",K38>RDate),AND(Q38<>\"\",Q38<SDate)))","v":{"$error":"#NAME?"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$error":"#NAME?"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$error":"#NAME?"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$error":"#NAME?"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$error":"#NAME?"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$error":"#NAME?"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$error":"#NAME?"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$error":"#NAME?"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$error":"#NAME?"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$error":"#NAME?"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$error":"#NAME?"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$error":"#NAME?"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$error":"#NAME?"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$error":"#NAME?"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$error":"#NAME?"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$error":"#NAME?"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$error":"#NAME?"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$error":"#NAME?"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$error":"#NAME?"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$error":"#NAME?"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$error":"#NAME?"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$error":"#NAME?"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$error":"#NAME?"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$error":"#NAME?"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$error":"#NAME?"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$error":"#NAME?"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$error":"#NAME?"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$error":"#NAME?"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$error":"#NAME?"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$error":"#NAME?"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$error":"#NAME?"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$error":"#NAME?"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"IF(R70<>\"\",IF(OR(A70=\"\",ISNA(MATCH(A70,LA_URN,0))),\"Please record a valid LA URN\",\"\"),\"\")","v":""},"","",{"$f":"IF(R70<>\"\",IF(D70=\"\",\"Please record the date of birth for this child\",IF(OR(D70>TODAY(),NOT(ISNUMBER(D70))),\"Please enter a valid date for the date of birth\",IF(D70>RDate,\"Please enter a date that is not after the reporting period\",IF(DATEDIF(D70,RDate,\"y\")>=25,\"Cases for individuals aged 25 or over should not be included in this data return\",IF(D70>MIN(H70:O70,Q70),\"Date of birth cannot be after any of the dates in the adoption journey - please correct whichever dates are wrong\",\"\"))))),\"\")","v":""},{"$f":"IF(R70<>\"\",IF(OR(E70=\"\",ISNA(MATCH(E70,Gender_list,0))),\"Please record a valid gender code\",\"\"),\"\")","v":""},{"$f":"IF(R70<>\"\",IF(OR(F70=\"\",ISNA(MATCH(F70,Eth_list,0))),\"Please record a valid ethnicity code\",\"\"),\"\")","v":""},"",{"$f":"IF(H70<>\"\",IF(OR(H70>TODAY(),NOT(ISNUMBER(H70))),\"Please enter a valid date\",IF(H70<D70,\"The adoptive match cannot have been approved before the child was born\",IF(H70>RDate,\"This date indicates that the adoptive match was approved after the reporting period, so this case should not be included in the return\",IF(AND(I70=\"\",J70=\"\",OR(H70<SDate,I70>RDate)),\"This date falls outside the reporting period, so this case should not be included in the return\",\"\")))),IF(AND(I70<>\"\",ISNUMBER(I70)),\"This date is missing, please add it\",\"\"))","v":""},{"$f":"IF(I70=\"\",IF(AND(J70<>\"\",H70<>\"\"),\"Date is missing, please add it\",\"\"),IF(OR(I70>TODAY(),NOT(ISNUMBER(I70))),\"Please enter a valid date\",IF(I70<H70,\"Placement date cannot be before date match was approved - please correct either C8 or C9\",IF(AND(J70=\"\",OR(I70<SDate,I70>RDate)),\"This case falls outside the reporting period and so does not need to be included in this data return\",IF(I70>RDate,\"Date recorded is after reporting period, so this case does not need to be included in this data return\",\"\")))))","v":""},{"$f":"IF(AND(COUNT(K70:N70,Q70)>0,J70=\"\"),\"Date is missing, please add it\",IF(J70<>\"\",IF(OR(J70>TODAY(),NOT(ISNUMBER(J70))),\"Please enter a valid date\",IF(AND(I70<>\"\",ISNUMBER(I70),I70>J70),\"Date of AO cannot be before placement date - please correct either C9 or C10\",IF(AND(K70<>\"\",ISNUMBER(K70),J70>K70),\"Date of AO cannot be after post-order contact - please correct C10 or C11\",IF(OR(J70>RDate,AND(J70<SDate,R70=\"Pre\")),\"This case falls outside the reporting period and so does not need to be included in this data return\",\"\")))),\"\"))","v":""},{"$f":"IF(K70=\"\",IF(OR(R70=\"Post\",COUNT(L70:N70,Q70)>0),\"Date is missing, please add it\",\"\"),IF(OR(K70>TODAY(),NOT(ISNUMBER(K70))),\"Please enter a valid date\",IF(K70<J70,\"Contact date cannot be before Date of AO - please correct either C10 or C11\",IF(AND(R70=\"Post\",COUNT(L70:N70,P70:Q70)=0,OR(K70<SDate,K70>RDate)),\"Date of contact is outside the reporting period, so this record should not be included in this data return\",IF(K70>RDate,\"Date of contact is after the reporting period, so this record should ont be included in this data record\",\"\")))))","v":""},"","","",{"$f":"IF(O70=\"\",IF(OR(AND(I70<>\"\",OR(IFERROR(DATEDIF(I70,J70,\"y\"),0)>=1,IFERROR(DATEDIF(I70,RDate,\"y\"),0)>=1)),AND(N70<>\"\",OR(IFERROR(DATEDIF(N70,Q70,\"y\"),0)>=1,IFERROR(DATEDIF(N70,RDate,\"y\"),0)>=1))),\"Date appears to be missing - please record the date of review\",\"\"),IF(OR(O70>TODAY(),NOT(ISNUMBER(O70))),\"Please enter a valid date\",IF(AND(N70<>\"\",O70<N70),\"Review date cannot be before assessment was completed - please correct either C14 or C15\",IF(AND(Q70<>\"\",O70>Q70),\"Review date cannot be after case was closed - please correct either C15 or C17\",IF(AND(I70<>\"\",O70<I70),\"Review date cannot be before date of placement - please correct either C9 or C15\",IF(AND(J70<>\"\",O70>J70,I70<>\"\"),\"Review date cannot be after date of AO - please correct either C10 or C15\",\"\"))))))","v":""},"",{"$f":"IF(Q70<>\"\",IF(OR(Q70>TODAY(),NOT(ISNUMBER(Q70))),\"Please enter a valid date\",IF(AND(O70<>\"\",ISNUMBER(O70),O70>Q70),\"Closure date cannot be earlier than the latest Review - please correct either C15 or C17\",IF(AND(K70<>\"\",ISNUMBER(K70),K70>Q70),\"Closure date cannot be earlier than the initial contact date - please correct C11 or C17\",IF(Q70<SDate,\"Case was closed before reporting period and so does not need to be included in this data return\",\"\")))),\"\")","v":""},"","",{"$f":"IF(R70<>\"\",IF(OR(AND(R70=\"Post\",Q70<>\"\",Q70<RDate),AND(R70=\"Pre\",J70<>\"\",J70<RDate)),\"Closed\",\"Open\"),\"\")","v":""},"","","","",{"$f":"IF(D70<>\"\",DATEDIF(D70,RDate,\"y\"),\"\")","v":""},"","",{"$f":"NOT(OR(AND(K70<>\"\",K70>RDate),AND(Q70<>\"\",Q70<SDate)))","v":{"$error":"#NAME?"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(OR(H71<>\"\",I71<>\"\"),COUNTA(A71:G71)>0),\"Pre\",IF(COUNT(K71:Q71)>0,\"Post\",\"\"))","v":""},"",{"$f":"IF(R71<>\"\",IF(B71=\"\",\"Please record the child's CMS ID\",\"\"),\"\")","v":""},{"$f":"IF(R71<>\"\",IF(C71=\"\",\"Please record a unique identifier for this case\",IF(COUNTIF($C$6:$C$100000,C71)>1,\"The contact identifier must be unique - please correct this case or other cases that have the same contact identifier recorded\",\"\")),\"\")","v":""},"","","",{"$f":"IF(R71<>\"\",IF(OR(G71=\"\",AND(G71<>0,G71<>1)),\"Please record a valid Disability code\",\"\"),\"\")","v":""},"","","","",{"$f":"IF(L71=\"\",IF(COUNT(M71:N71,Q71)>0,\"Date is missing, please add it\",\"\"),IF(OR(L71>TODAY(),NOT(ISNUMBER(L71))),\"Please enter a valid date\",IF(L71<K71,\"Allocation date cannot be before Contact - please correct either C11 or C12\",\"\")))","v":""},{"$f":"IF(M71=\"\",IF(COUNT(N71,Q71)>0,\"Date is missing, please add it\",\"\"),IF(OR(M71>TODAY(),NOT(ISNUMBER(M71))),\"Please enter a valid date\",IF(M71<L71,\"Assessment start date cannot be before allocation date - please correct either C12 or C13\",\"\")))","v":""},{"$f":"IF(N71=\"\",IF(COUNT(Q71)>0,\"Date is missing, please add it\",\"\"),IF(OR(N71>TODAY(),NOT(ISNUMBER(N71))),\"Please enter a valid date\",IF(N71<M71,\"Assessment cannot be completed before it is started - please correct either C13 or C14\",\"\")))","v":""},"",{"$f":"IF(AND(P71<>\"\",P71<>0,P71<>1),\"Please record a valid code\",\"\")","v":""},"",{"$f":"IF(AND(H71<>\"\",J71<>\"\",ISNUMBER(H71),ISNUMBER(J71)),J71-H71,\"\")","v":""},{"$f":"IF(AND(H71<>\"\",O71<>\"\",ISNUMBER(H71),ISNUMBER(O71)),O71-H71,\"\")","v":""},"",{"$f":"IF(AND(K71<>\"\",L71<>\"\",ISNUMBER(K71),ISNUMBER(L71)),L71-K71,\"\")","v":""},{"$f":"IF(AND(L71<>\"\",M71<>\"\",ISNUMBER(L71),ISNUMBER(M71)),M71-L71,\"\")","v":""},{"$f":"IF(AND(M71<>\"\",N71<>\"\",ISNUMBER(M71),ISNUMBER(N71)),N71-M71,\"\")","v":""},{"$f":"IF(AND(K71<>\"\",Q71<>\"\",ISNUMBER(K71),ISNUMBER(Q71)),Q71-K71,\"\")","v":""},"",{"$f":"IF(D71<>\"\",DATEDIF(D71,J71,\"y\"),\"\")","v":""},{"$f":"IF(D71<>\"\",DATEDIF(D71,Q71,\"y\"),\"\")","v":""},{"$error":"#NAME?"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$error":"#NAME?"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$error":"#NAME?"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$error":"#NAME?"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$error":"#NAME?"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$error":"#NAME?"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$error":"#NAME?"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$error":"#NAME?"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$error":"#NAME?"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$error":"#NAME?"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$error":"#NAME?"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$error":"#NAME?"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$error":"#NAME?"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$error":"#NAME?"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$error":"#NAME?"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$error":"#NAME?"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$error":"#NAME?"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$error":"#NAME?"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$error":"#NAME?"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$error":"#NAME?"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$error":"#NAME?"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$error":"#NAME?"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$error":"#NAME?"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$error":"#NAME?"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$error":"#NAME?"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$error":"#NAME?"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$error":"#NAME?"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$error":"#NAME?"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$error":"#NAME?"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$error":"#NAME?"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$error":"#NAME?"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"IF(R102<>\"\",IF(OR(A102=\"\",ISNA(MATCH(A102,LA_URN,0))),\"Please record a valid LA URN\",\"\"),\"\")","v":""},"","",{"$f":"IF(R102<>\"\",IF(D102=\"\",\"Please record the date of birth for this child\",IF(OR(D102>TODAY(),NOT(ISNUMBER(D102))),\"Please enter a valid date for the date of birth\",IF(D102>RDate,\"Please enter a date that is not after the reporting period\",IF(DATEDIF(D102,RDate,\"y\")>=25,\"Cases for individuals aged 25 or over should not be included in this data return\",IF(D102>MIN(H102:O102,Q102),\"Date of birth cannot be after any of the dates in the adoption journey - please correct whichever dates are wrong\",\"\"))))),\"\")","v":""},{"$f":"IF(R102<>\"\",IF(OR(E102=\"\",ISNA(MATCH(E102,Gender_list,0))),\"Please record a valid gender code\",\"\"),\"\")","v":""},{"$f":"IF(R102<>\"\",IF(OR(F102=\"\",ISNA(MATCH(F102,Eth_list,0))),\"Please record a valid ethnicity code\",\"\"),\"\")","v":""},"",{"$f":"IF(H102<>\"\",IF(OR(H102>TODAY(),NOT(ISNUMBER(H102))),\"Please enter a valid date\",IF(H102<D102,\"The adoptive match cannot have been approved before the child was born\",IF(H102>RDate,\"This date indicates that the adoptive match was approved after the reporting period, so this case should not be included in the return\",IF(AND(I102=\"\",J102=\"\",OR(H102<SDate,I102>RDate)),\"This date falls outside the reporting period, so this case should not be included in the return\",\"\")))),IF(AND(I102<>\"\",ISNUMBER(I102)),\"This date is missing, please add it\",\"\"))","v":""},{"$f":"IF(I102=\"\",IF(AND(J102<>\"\",H102<>\"\"),\"Date is missing, please add it\",\"\"),IF(OR(I102>TODAY(),NOT(ISNUMBER(I102))),\"Please enter a valid date\",IF(I102<H102,\"Placement date cannot be before date match was approved - please correct either C8 or C9\",IF(AND(J102=\"\",OR(I102<SDate,I102>RDate)),\"This case falls outside the reporting period and so does not need to be included in this data return\",IF(I102>RDate,\"Date recorded is after reporting period, so this case does not need to be included in this data return\",\"\")))))","v":""},{"$f":"IF(AND(COUNT(K102:N102,Q102)>0,J102=\"\"),\"Date is missing, please add it\",IF(J102<>\"\",IF(OR(J102>TODAY(),NOT(ISNUMBER(J102))),\"Please enter a valid date\",IF(AND(I102<>\"\",ISNUMBER(I102),I102>J102),\"Date of AO cannot be before placement date - please correct either C9 or C10\",IF(AND(K102<>\"\",ISNUMBER(K102),J102>K102),\"Date of AO cannot be after post-order contact - please correct C10 or C11\",IF(OR(J102>RDate,AND(J102<SDate,R102=\"Pre\")),\"This case falls outside the reporting period and so does not need to be included in this data return\",\"\")))),\"\"))","v":""},{"$f":"IF(K102=\"\",IF(OR(R102=\"Post\",COUNT(L102:N102,Q102)>0),\"Date is missing, please add it\",\"\"),IF(OR(K102>TODAY(),NOT(ISNUMBER(K102))),\"Please enter a valid date\",IF(K102<J102,\"Contact date cannot be before Date of AO - please correct either C10 or C11\",IF(AND(R102=\"Post\",COUNT(L102:N102,P102:Q102)=0,OR(K102<SDate,K102>RDate)),\"Date of contact is outside the reporting period, so this record should not be included in this data return\",IF(K102>RDate,\"Date of contact is after the reporting period, so this record should ont be included in this data record\",\"\")))))","v":""},"","","",{"$f":"IF(O102=\"\",IF(OR(AND(I102<>\"\",OR(IFERROR(DATEDIF(I102,J102,\"y\"),0)>=1,IFERROR(DATEDIF(I102,RDate,\"y\"),0)>=1)),AND(N102<>\"\",OR(IFERROR(DATEDIF(N102,Q102,\"y\"),0)>=1,IFERROR(DATEDIF(N102,RDate,\"y\"),0)>=1))),\"Date appears to be missing - please record the date of review\",\"\"),IF(OR(O102>TODAY(),NOT(ISNUMBER(O102))),\"Please enter a valid date\",IF(AND(N102<>\"\",O102<N102),\"Review date cannot be before assessment was completed - please correct either C14 or C15\",IF(AND(Q102<>\"\",O102>Q102),\"Review date cannot be after case was closed - please correct either C15 or C17\",IF(AND(I102<>\"\",O102<I102),\"Review date cannot be before date of placement - please correct either C9 or C15\",IF(AND(J102<>\"\",O102>J102,I102<>\"\"),\"Review date cannot be after date of AO - please correct either C10 or C15\",\"\"))))))","v":""},"",{"$f":"IF(Q102<>\"\",IF(OR(Q102>TODAY(),NOT(ISNUMBER(Q102))),\"Please enter a valid date\",IF(AND(O102<>\"\",ISNUMBER(O102),O102>Q102),\"Closure date cannot be earlier than the latest Review - please correct either C15 or C17\",IF(AND(K102<>\"\",ISNUMBER(K102),K102>Q102),\"Closure date cannot be earlier than the initial contact date - please correct C11 or C17\",IF(Q102<SDate,\"Case was closed before reporting period and so does not need to be included in this data return\",\"\")))),\"\")","v":""},"","",{"$f":"IF(R102<>\"\",IF(OR(AND(R102=\"Post\",Q102<>\"\",Q102<RDate),AND(R102=\"Pre\",J102<>\"\",J102<RDate)),\"Closed\",\"Open\"),\"\")","v":""},"","","","",{"$f":"IF(D102<>\"\",DATEDIF(D102,RDate,\"y\"),\"\")","v":""},"","",{"$f":"NOT(OR(AND(K102<>\"\",K102>RDate),AND(Q102<>\"\",Q102<SDate)))","v":{"$error":"#NAME?"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$error":"#NAME?"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$error":"#NAME?"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$error":"#NAME?"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$error":"#NAME?"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$error":"#NAME?"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$error":"#NAME?"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$error":"#NAME?"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$error":"#NAME?"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$error":"#NAME?"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$error":"#NAME?"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$error":"#NAME?"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$error":"#NAME?"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$error":"#NAME?"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$error":"#NAME?"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$error":"#NAME?"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$error":"#NAME?"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$error":"#NAME?"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$error":"#NAME?"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$error":"#NAME?"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$error":"#NAME?"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$error":"#NAME?"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$error":"#NAME?"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$error":"#NAME?"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$error":"#NAME?"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$error":"#NAME?"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$error":"#NAME?"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$error":"#NAME?"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$error":"#NAME?"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$error":"#NAME?"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$error":"#NAME?"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$error":"#NAME?"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"IF(R134<>\"\",IF(OR(A134=\"\",ISNA(MATCH(A134,LA_URN,0))),\"Please record a valid LA URN\",\"\"),\"\")","v":""},"","",{"$f":"IF(R134<>\"\",IF(D134=\"\",\"Please record the date of birth for this child\",IF(OR(D134>TODAY(),NOT(ISNUMBER(D134))),\"Please enter a valid date for the date of birth\",IF(D134>RDate,\"Please enter a date that is not after the reporting period\",IF(DATEDIF(D134,RDate,\"y\")>=25,\"Cases for individuals aged 25 or over should not be included in this data return\",IF(D134>MIN(H134:O134,Q134),\"Date of birth cannot be after any of the dates in the adoption journey - please correct whichever dates are wrong\",\"\"))))),\"\")","v":""},{"$f":"IF(R134<>\"\",IF(OR(E134=\"\",ISNA(MATCH(E134,Gender_list,0))),\"Please record a valid gender code\",\"\"),\"\")","v":""},{"$f":"IF(R134<>\"\",IF(OR(F134=\"\",ISNA(MATCH(F134,Eth_list,0))),\"Please record a valid ethnicity code\",\"\"),\"\")","v":""},"",{"$f":"IF(H134<>\"\",IF(OR(H134>TODAY(),NOT(ISNUMBER(H134))),\"Please enter a valid date\",IF(H134<D134,\"The adoptive match cannot have been approved before the child was born\",IF(H134>RDate,\"This date indicates that the adoptive match was approved after the reporting period, so this case should not be included in the return\",IF(AND(I134=\"\",J134=\"\",OR(H134<SDate,I134>RDate)),\"This date falls outside the reporting period, so this case should not be included in the return\",\"\")))),IF(AND(I134<>\"\",ISNUMBER(I134)),\"This date is missing, please add it\",\"\"))","v":""},{"$f":"IF(I134=\"\",IF(AND(J134<>\"\",H134<>\"\"),\"Date is missing, please add it\",\"\"),IF(OR(I134>TODAY(),NOT(ISNUMBER(I134))),\"Please enter a valid date\",IF(I134<H134,\"Placement date cannot be before date match was approved - please correct either C8 or C9\",IF(AND(J134=\"\",OR(I134<SDate,I134>RDate)),\"This case falls outside the reporting period and so does not need to be included in this data return\",IF(I134>RDate,\"Date recorded is after reporting period, so this case does not need to be included in this data return\",\"\")))))","v":""},{"$f":"IF(AND(COUNT(K134:N134,Q134)>0,J134=\"\"),\"Date is missing, please add it\",IF(J134<>\"\",IF(OR(J134>TODAY(),NOT(ISNUMBER(J134))),\"Please enter a valid date\",IF(AND(I134<>\"\",ISNUMBER(I134),I134>J134),\"Date of AO cannot be before placement date - please correct either C9 or C10\",IF(AND(K134<>\"\",ISNUMBER(K134),J134>K134),\"Date of AO cannot be after post-order contact - please correct C10 or C11\",IF(OR(J134>RDate,AND(J134<SDate,R134=\"Pre\")),\"This case falls outside the reporting period and so does not need to be included in this data return\",\"\")))),\"\"))","v":""},{"$f":"IF(K134=\"\",IF(OR(R134=\"Post\",COUNT(L134:N134,Q134)>0),\"Date is missing, please add it\",\"\"),IF(OR(K134>TODAY(),NOT(ISNUMBER(K134))),\"Please enter a valid date\",IF(K134<J134,\"Contact date cannot be before Date of AO - please correct either C10 or C11\",IF(AND(R134=\"Post\",COUNT(L134:N134,P134:Q134)=0,OR(K134<SDate,K134>RDate)),\"Date of contact is outside the reporting period, so this record should not be included in this data return\",IF(K134>RDate,\"Date of contact is after the reporting period, so this record should ont be included in this data record\",\"\")))))","v":""},"","","",{"$f":"IF(O134=\"\",IF(OR(AND(I134<>\"\",OR(IFERROR(DATEDIF(I134,J134,\"y\"),0)>=1,IFERROR(DATEDIF(I134,RDate,\"y\"),0)>=1)),AND(N134<>\"\",OR(IFERROR(DATEDIF(N134,Q134,\"y\"),0)>=1,IFERROR(DATEDIF(N134,RDate,\"y\"),0)>=1))),\"Date appears to be missing - please record the date of review\",\"\"),IF(OR(O134>TODAY(),NOT(ISNUMBER(O134))),\"Please enter a valid date\",IF(AND(N134<>\"\",O134<N134),\"Review date cannot be before assessment was completed - please correct either C14 or C15\",IF(AND(Q134<>\"\",O134>Q134),\"Review date cannot be after case was closed - please correct either C15 or C17\",IF(AND(I134<>\"\",O134<I134),\"Review date cannot be before date of placement - please correct either C9 or C15\",IF(AND(J134<>\"\",O134>J134,I134<>\"\"),\"Review date cannot be after date of AO - please correct either C10 or C15\",\"\"))))))","v":""},"",{"$f":"IF(Q134<>\"\",IF(OR(Q134>TODAY(),NOT(ISNUMBER(Q134))),\"Please enter a valid date\",IF(AND(O134<>\"\",ISNUMBER(O134),O134>Q134),\"Closure date cannot be earlier than the latest Review - please correct either C15 or C17\",IF(AND(K134<>\"\",ISNUMBER(K134),K134>Q134),\"Closure date cannot be earlier than the initial contact date - please correct C11 or C17\",IF(Q134<SDate,\"Case was closed before reporting period and so does not need to be included in this data return\",\"\")))),\"\")","v":""},"","",{"$f":"IF(R134<>\"\",IF(OR(AND(R134=\"Post\",Q134<>\"\",Q134<RDate),AND(R134=\"Pre\",J134<>\"\",J134<RDate)),\"Closed\",\"Open\"),\"\")","v":""},"","","","",{"$f":"IF(D134<>\"\",DATEDIF(D134,RDate,\"y\"),\"\")","v":""},"","",{"$f":"NOT(OR(AND(K134<>\"\",K134>RDate),AND(Q134<>\"\",Q134<SDate)))","v":{"$error":"#NAME?"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(OR(H135<>\"\",I135<>\"\"),COUNTA(A135:G135)>0),\"Pre\",IF(COUNT(K135:Q135)>0,\"Post\",\"\"))","v":""},"",{"$f":"IF(R135<>\"\",IF(B135=\"\",\"Please record the child's CMS ID\",\"\"),\"\")","v":""},{"$f":"IF(R135<>\"\",IF(C135=\"\",\"Please record a unique identifier for this case\",IF(COUNTIF($C$6:$C$100000,C135)>1,\"The contact identifier must be unique - please correct this case or other cases that have the same contact identifier recorded\",\"\")),\"\")","v":""},"","","",{"$f":"IF(R135<>\"\",IF(OR(G135=\"\",AND(G135<>0,G135<>1)),\"Please record a valid Disability code\",\"\"),\"\")","v":""},"","","","",{"$f":"IF(L135=\"\",IF(COUNT(M135:N135,Q135)>0,\"Date is missing, please add it\",\"\"),IF(OR(L135>TODAY(),NOT(ISNUMBER(L135))),\"Please enter a valid date\",IF(L135<K135,\"Allocation date cannot be before Contact - please correct either C11 or C12\",\"\")))","v":""},{"$f":"IF(M135=\"\",IF(COUNT(N135,Q135)>0,\"Date is missing, please add it\",\"\"),IF(OR(M135>TODAY(),NOT(ISNUMBER(M135))),\"Please enter a valid date\",IF(M135<L135,\"Assessment start date cannot be before allocation date - please correct either C12 or C13\",\"\")))","v":""},{"$f":"IF(N135=\"\",IF(COUNT(Q135)>0,\"Date is missing, please add it\",\"\"),IF(OR(N135>TODAY(),NOT(ISNUMBER(N135))),\"Please enter a valid date\",IF(N135<M135,\"Assessment cannot be completed before it is started - please correct either C13 or C14\",\"\")))","v":""},"",{"$f":"IF(AND(P135<>\"\",P135<>0,P135<>1),\"Please record a valid code\",\"\")","v":""},"",{"$f":"IF(AND(H135<>\"\",J135<>\"\",ISNUMBER(H135),ISNUMBER(J135)),J135-H135,\"\")","v":""},{"$f":"IF(AND(H135<>\"\",O135<>\"\",ISNUMBER(H135),ISNUMBER(O135)),O135-H135,\"\")","v":""},"",{"$f":"IF(AND(K135<>\"\",L135<>\"\",ISNUMBER(K135),ISNUMBER(L135)),L135-K135,\"\")","v":""},{"$f":"IF(AND(L135<>\"\",M135<>\"\",ISNUMBER(L135),ISNUMBER(M135)),M135-L135,\"\")","v":""},{"$f":"IF(AND(M135<>\"\",N135<>\"\",ISNUMBER(M135),ISNUMBER(N135)),N135-M135,\"\")","v":""},{"$f":"IF(AND(K135<>\"\",Q135<>\"\",ISNUMBER(K135),ISNUMBER(Q135)),Q135-K135,\"\")","v":""},"",{"$f":"IF(D135<>\"\",DATEDIF(D135,J135,\"y\"),\"\")","v":""},{"$f":"IF(D135<>\"\",DATEDIF(D135,Q135,\"y\"),\"\")","v":""},{"$error":"#NAME?"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$error":"#NAME?"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$error":"#NAME?"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$error":"#NAME?"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$error":"#NAME?"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$error":"#NAME?"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$error":"#NAME?"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$error":"#NAME?"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$error":"#NAME?"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$error":"#NAME?"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$error":"#NAME?"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$error":"#NAME?"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$error":"#NAME?"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$error":"#NAME?"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$error":"#NAME?"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$error":"#NAME?"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$error":"#NAME?"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$error":"#NAME?"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$error":"#NAME?"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$error":"#NAME?"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$error":"#NAME?"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$error":"#NAME?"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$error":"#NAME?"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$error":"#NAME?"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$error":"#NAME?"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$error":"#NAME?"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$error":"#NAME?"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$error":"#NAME?"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$error":"#NAME?"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$error":"#NAME?"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$error":"#NAME?"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"IF(R166<>\"\",IF(OR(A166=\"\",ISNA(MATCH(A166,LA_URN,0))),\"Please record a valid LA URN\",\"\"),\"\")","v":""},"","",{"$f":"IF(R166<>\"\",IF(D166=\"\",\"Please record the date of birth for this child\",IF(OR(D166>TODAY(),NOT(ISNUMBER(D166))),\"Please enter a valid date for the date of birth\",IF(D166>RDate,\"Please enter a date that is not after the reporting period\",IF(DATEDIF(D166,RDate,\"y\")>=25,\"Cases for individuals aged 25 or over should not be included in this data return\",IF(D166>MIN(H166:O166,Q166),\"Date of birth cannot be after any of the dates in the adoption journey - please correct whichever dates are wrong\",\"\"))))),\"\")","v":""},{"$f":"IF(R166<>\"\",IF(OR(E166=\"\",ISNA(MATCH(E166,Gender_list,0))),\"Please record a valid gender code\",\"\"),\"\")","v":""},{"$f":"IF(R166<>\"\",IF(OR(F166=\"\",ISNA(MATCH(F166,Eth_list,0))),\"Please record a valid ethnicity code\",\"\"),\"\")","v":""},"",{"$f":"IF(H166<>\"\",IF(OR(H166>TODAY(),NOT(ISNUMBER(H166))),\"Please enter a valid date\",IF(H166<D166,\"The adoptive match cannot have been approved before the child was born\",IF(H166>RDate,\"This date indicates that the adoptive match was approved after the reporting period, so this case should not be included in the return\",IF(AND(I166=\"\",J166=\"\",OR(H166<SDate,I166>RDate)),\"This date falls outside the reporting period, so this case should not be included in the return\",\"\")))),IF(AND(I166<>\"\",ISNUMBER(I166)),\"This date is missing, please add it\",\"\"))","v":""},{"$f":"IF(I166=\"\",IF(AND(J166<>\"\",H166<>\"\"),\"Date is missing, please add it\",\"\"),IF(OR(I166>TODAY(),NOT(ISNUMBER(I166))),\"Please enter a valid date\",IF(I166<H166,\"Placement date cannot be before date match was approved - please correct either C8 or C9\",IF(AND(J166=\"\",OR(I166<SDate,I166>RDate)),\"This case falls outside the reporting period and so does not need to be included in this data return\",IF(I166>RDate,\"Date recorded is after reporting period, so this case does not need to be included in this data return\",\"\")))))","v":""},{"$f":"IF(AND(COUNT(K166:N166,Q166)>0,J166=\"\"),\"Date is missing, please add it\",IF(J166<>\"\",IF(OR(J166>TODAY(),NOT(ISNUMBER(J166))),\"Please enter a valid date\",IF(AND(I166<>\"\",ISNUMBER(I166),I166>J166),\"Date of AO cannot be before placement date - please correct either C9 or C10\",IF(AND(K166<>\"\",ISNUMBER(K166),J166>K166),\"Date of AO cannot be after post-order contact - please correct C10 or C11\",IF(OR(J166>RDate,AND(J166<SDate,R166=\"Pre\")),\"This case falls outside the reporting period and so does not need to be included in this data return\",\"\")))),\"\"))","v":""},{"$f":"IF(K166=\"\",IF(OR(R166=\"Post\",COUNT(L166:N166,Q166)>0),\"Date is missing, please add it\",\"\"),IF(OR(K166>TODAY(),NOT(ISNUMBER(K166))),\"Please enter a valid date\",IF(K166<J166,\"Contact date cannot be before Date of AO - please correct either C10 or C11\",IF(AND(R166=\"Post\",COUNT(L166:N166,P166:Q166)=0,OR(K166<SDate,K166>RDate)),\"Date of contact is outside the reporting period, so this record should not be included in this data return\",IF(K166>RDate,\"Date of contact is after the reporting period, so this record should ont be included in this data record\",\"\")))))","v":""},"","","",{"$f":"IF(O166=\"\",IF(OR(AND(I166<>\"\",OR(IFERROR(DATEDIF(I166,J166,\"y\"),0)>=1,IFERROR(DATEDIF(I166,RDate,\"y\"),0)>=1)),AND(N166<>\"\",OR(IFERROR(DATEDIF(N166,Q166,\"y\"),0)>=1,IFERROR(DATEDIF(N166,RDate,\"y\"),0)>=1))),\"Date appears to be missing - please record the date of review\",\"\"),IF(OR(O166>TODAY(),NOT(ISNUMBER(O166))),\"Please enter a valid date\",IF(AND(N166<>\"\",O166<N166),\"Review date cannot be before assessment was completed - please correct either C14 or C15\",IF(AND(Q166<>\"\",O166>Q166),\"Review date cannot be after case was closed - please correct either C15 or C17\",IF(AND(I166<>\"\",O166<I166),\"Review date cannot be before date of placement - please correct either C9 or C15\",IF(AND(J166<>\"\",O166>J166,I166<>\"\"),\"Review date cannot be after date of AO - please correct either C10 or C15\",\"\"))))))","v":""},"",{"$f":"IF(Q166<>\"\",IF(OR(Q166>TODAY(),NOT(ISNUMBER(Q166))),\"Please enter a valid date\",IF(AND(O166<>\"\",ISNUMBER(O166),O166>Q166),\"Closure date cannot be earlier than the latest Review - please correct either C15 or C17\",IF(AND(K166<>\"\",ISNUMBER(K166),K166>Q166),\"Closure date cannot be earlier than the initial contact date - please correct C11 or C17\",IF(Q166<SDate,\"Case was closed before reporting period and so does not need to be included in this data return\",\"\")))),\"\")","v":""},"","",{"$f":"IF(R166<>\"\",IF(OR(AND(R166=\"Post\",Q166<>\"\",Q166<RDate),AND(R166=\"Pre\",J166<>\"\",J166<RDate)),\"Closed\",\"Open\"),\"\")","v":""},"","","","",{"$f":"IF(D166<>\"\",DATEDIF(D166,RDate,\"y\"),\"\")","v":""},"","",{"$f":"NOT(OR(AND(K166<>\"\",K166>RDate),AND(Q166<>\"\",Q166<SDate)))","v":{"$error":"#NAME?"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$error":"#NAME?"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$error":"#NAME?"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$error":"#NAME?"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$error":"#NAME?"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$error":"#NAME?"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$error":"#NAME?"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$error":"#NAME?"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$error":"#NAME?"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$error":"#NAME?"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$error":"#NAME?"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$error":"#NAME?"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$error":"#NAME?"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$error":"#NAME?"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$error":"#NAME?"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$error":"#NAME?"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$error":"#NAME?"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$error":"#NAME?"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$error":"#NAME?"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$error":"#NAME?"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$error":"#NAME?"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$error":"#NAME?"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$error":"#NAME?"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$error":"#NAME?"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$error":"#NAME?"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$error":"#NAME?"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$error":"#NAME?"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$error":"#NAME?"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$error":"#NAME?"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$error":"#NAME?"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$error":"#NAME?"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$error":"#NAME?"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"IF(R198<>\"\",IF(OR(A198=\"\",ISNA(MATCH(A198,LA_URN,0))),\"Please record a valid LA URN\",\"\"),\"\")","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","",{"$error":"#NAME?"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(OR(H199<>\"\",I199<>\"\"),COUNTA(A199:G199)>0),\"Pre\",IF(COUNT(K199:Q199)>0,\"Post\",\"\"))","v":""},"",{"$f":"IF(R199<>\"\",IF(B199=\"\",\"Please record the child's CMS ID\",\"\"),\"\")","v":""},{"$f":"IF(R199<>\"\",IF(C199=\"\",\"Please record a unique identifier for this case\",IF(COUNTIF($C$6:$C$100000,C199)>1,\"The contact identifier must be unique - please correct this case or other cases that have the same contact identifier recorded\",\"\")),\"\")","v":""},"","","",{"$f":"IF(R199<>\"\",IF(OR(G199=\"\",AND(G199<>0,G199<>1)),\"Please record a valid Disability code\",\"\"),\"\")","v":""},"","","","",{"$f":"IF(L199=\"\",IF(COUNT(M199:N199,Q199)>0,\"Date is missing, please add it\",\"\"),IF(OR(L199>TODAY(),NOT(ISNUMBER(L199))),\"Please enter a valid date\",IF(L199<K199,\"Allocation date cannot be before Contact - please correct either C11 or C12\",\"\")))","v":""},{"$f":"IF(M199=\"\",IF(COUNT(N199,Q199)>0,\"Date is missing, please add it\",\"\"),IF(OR(M199>TODAY(),NOT(ISNUMBER(M199))),\"Please enter a valid date\",IF(M199<L199,\"Assessment start date cannot be before allocation date - please correct either C12 or C13\",\"\")))","v":""},{"$f":"IF(N199=\"\",IF(COUNT(Q199)>0,\"Date is missing, please add it\",\"\"),IF(OR(N199>TODAY(),NOT(ISNUMBER(N199))),\"Please enter a valid date\",IF(N199<M199,\"Assessment cannot be completed before it is started - please correct either C13 or C14\",\"\")))","v":""},"",{"$f":"IF(AND(P199<>\"\",P199<>0,P199<>1),\"Please record a valid code\",\"\")","v":""},"",{"$f":"IF(AND(H199<>\"\",J199<>\"\",ISNUMBER(H199),ISNUMBER(J199)),J199-H199,\"\")","v":""},{"$f":"IF(AND(H199<>\"\",O199<>\"\",ISNUMBER(H199),ISNUMBER(O199)),O199-H199,\"\")","v":""},"",{"$f":"IF(AND(K199<>\"\",L199<>\"\",ISNUMBER(K199),ISNUMBER(L199)),L199-K199,\"\")","v":""},{"$f":"IF(AND(L199<>\"\",M199<>\"\",ISNUMBER(L199),ISNUMBER(M199)),M199-L199,\"\")","v":""},{"$f":"IF(AND(M199<>\"\",N199<>\"\",ISNUMBER(M199),ISNUMBER(N199)),N199-M199,\"\")","v":""},{"$f":"IF(AND(K199<>\"\",Q199<>\"\",ISNUMBER(K199),ISNUMBER(Q199)),Q199-K199,\"\")","v":""},"",{"$f":"IF(D199<>\"\",DATEDIF(D199,J199,\"y\"),\"\")","v":""},{"$f":"IF(D199<>\"\",DATEDIF(D199,Q199,\"y\"),\"\")","v":""},{"$error":"#NAME?"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$error":"#NAME?"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$error":"#NAME?"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$error":"#NAME?"}]

{"sheet":"Dashboard","index":2,"n_rows":104,"n_cols":5,"rows_kept":104,"cut":false,"hidden":false,"merged":[]}
["HEADLINE MEASURES FOR DASHBOARD AND ANALYSIS"]
[]
["PRE ADOPTION ORDERSUPPORT",null,null,"POST ADOPTION ORDER SUPPORT"]
[]
["Number of children with an adoption support plan in place at ADM match (for matches approved in reporting period)",{"$f":"COUNTIFS('AS Data'!$R$6:$R$700000,\"Pre\",'AS Data'!$H$6:$H$700000,\"<=\"&RDate,'AS Data'!$H$6:$H$700000,\">=\"&SDate)","v":0},null,"Number of children for whom an adoption support contact has been made in reporting period",{"$f":"COUNTIFS('AS Data'!$R$6:$R$700000,\"Post\",'AS Data'!$K$6:$K$700000,\"<=\"&RDate,'AS Data'!$K$6:$K$700000,\">=\"&SDate)","v":0}]
["Number of children with an adoption support plan in place at placement (for placements in reporting period)",{"$f":"COUNTIFS('AS Data'!$R$6:$R$700000,\"Pre\",'AS Data'!$I$6:$I$700000,\"<=\"&RDate,'AS Data'!$I$6:$I$700000,\">=\"&SDate)","v":0},null,"Number of children for whom the service has contacted family and allocated support in reporting period",{"$f":"COUNTIFS('AS Data'!$R$6:$R$700000,\"Post\",'AS Data'!$L$6:$L$700000,\"<=\"&RDate,'AS Data'!$L$6:$L$700000,\">=\"&SDate)","v":0}]
["Number of children who had an adoption support needs assessment review in reporting period",{"$f":"COUNTIFS('AS Data'!$R$6:$R$700000,\"Pre\",'AS Data'!$O$6:$O$700000,\"<=\"&RDate,'AS Data'!$O$6:$O$700000,\">=\"&SDate)","v":0},null,"Number of children for whom an adoption support needs assessment started in reporting period",{"$f":"COUNTIFS('AS Data'!$R$6:$R$700000,\"Post\",'AS Data'!$M$6:$M$700000,\"<=\"&RDate,'AS Data'!$M$6:$M$700000,\">=\"&SDate)","v":0}]
["Number of children for whom an adoption support contact was closed in reporting period",{"$f":"COUNTIFS('AS Data'!$R$6:$R$700000,\"Pre\",'AS Data'!$J$6:$J$700000,\"<=\"&RDate,'AS Data'!$J$6:$J$700000,\">=\"&SDate)","v":0},null,"Number of children for whom an adoption support needs assessment completed in reporting period",{"$f":"COUNTIFS('AS Data'!$R$6:$R$700000,\"Post\",'AS Data'!$N$6:$N$700000,\"<=\"&RDate,'AS Data'!$N$6:$N$700000,\">=\"&SDate)","v":0}]
[null,null,null,"Number of children who had an adoption support needs assessment review in reporting period",{"$f":"COUNTIFS('AS Data'!$R$6:$R$700000,\"Post\",'AS Data'!$O$6:$O$700000,\"<=\"&RDate,'AS Data'!$O$6:$O$700000,\">=\"&SDate)","v":0}]
["Average time from date of adoption adoption support plan in place at ADM match to case closed (for cases closed in reporting period)",{"$f":"IFERROR(SUMIFS('AS Data'!$AJ$6:$AJ$700000,'AS Data'!$R$6:$R$700000,\"Pre\",'AS Data'!$J$6:$J$700000,\"<=\"&RDate,'AS Data'!$J$6:$J$700000,\">=\"&SDate)/$B$8&\" days\",\"-\")","v":"-"},null,"Number of children who were referred into Children's Social Care",{"$f":"COUNTIFS('AS Data'!$R$6:$R$700000,\"Post\",'AS Data'!$P$6:$P$700000,1,'AS Data'!$AT$6:$AT$700000,TRUE)","v":0}]
["Average time from date of adoption adoption support plan in place at ADM match to Adoption Support Needs Assessment review (for reviews in reporting period)",{"$f":"IFERROR(SUMIFS('AS Data'!$AK$6:$AK$700000,'AS Data'!$R$6:$R$700000,\"Pre\",'AS Data'!$O$6:$O$700000,\"<=\"&RDate,'AS Data'!$O$6:$O$700000,\">=\"&SDate)/$B$8&\" days\",\"-\")","v":"-"},null,"Number of children for whom an adoption support contact was closed in reporting period",{"$f":"COUNTIFS('AS Data'!$R$6:$R$700000,\"Post\",'AS Data'!$Q$6:$Q$700000,\"<=\"&RDate,'AS Data'!$Q$6:$Q$700000,\">=\"&SDate)","v":0}]
[]
[null,null,null,"Average time from date of adoption support contact to allocated to service for assessment (allocated in reporting period)",{"$f":"IFERROR(TEXT(SUMIFS('AS Data'!$AM$6:$AM$700000,'AS Data'!$R$6:$R$700000,\"Post\",'AS Data'!$L$6:$L$700000,\"<=\"&RDate,'AS Data'!$L$6:$L$700000,\">=\"&SDate)/E6,\"0.0\")&\" days\",\"\")","v":""}]
[null,null,null,"Average time from allocated to service for assessment to support needs assessment started (started in reporting period)",{"$f":"IFERROR(TEXT(SUMIFS('AS Data'!$AN$6:$AN$700000,'AS Data'!$R$6:$R$700000,\"Post\",'AS Data'!$M$6:$M$700000,\"<=\"&RDate,'AS Data'!$M$6:$M$700000,\">=\"&SDate)/E7,\"0.0\")&\" days\",\"\")","v":""}]
[null,null,null,"Average time from support needs assessment started to support needs assessment completed (completed in reporting period)",{"$f":"IFERROR(TEXT(SUMIFS('AS Data'!$AO$6:$AO$700000,'AS Data'!$R$6:$R$700000,\"Post\",'AS Data'!$N$6:$N$700000,\"<=\"&RDate,'AS Data'!$N$6:$N$700000,\">=\"&SDate)/E8,\"0.0\")&\" days\",\"\")","v":""}]
[null,null,null,"Average time from adoption support contact to date case closed (closed in reporting period)",{"$f":"IFERROR(TEXT(SUMIFS('AS Data'!AP6:$AP$700000,'AS Data'!$R$6:$R$700000,\"Post\",'AS Data'!$Q$6:$Q$700000,\"<=\"&RDate,'AS Data'!$Q$6:$Q$700000,\">=\"&SDate)/E11,\"0.0\")&\" days\",\"\")","v":""}]
[]
["Characteristics of Children with an open/ support contact (no adoption order date)",{"$f":"COUNTIFS('AS Data'!$R$6:$R$700000,\"Pre\",'AS Data'!$J$6:$J$700000,\"=\")","v":0},null,"Characteristics of Children with an open/ support contact",{"$f":"COUNTIFS('AS Data'!$R$6:$R$700000,\"Post\",'AS Data'!$Q$6:$Q$700000,\"=\")","v":0}]
["By Age Range (age as at report date):",null,null,{"$f":"A19","v":"By Age Range (age as at report date):"}]
["under 1 year",{"$f":"COUNTIFS('AS Data'!$R$6:$R$700000,\"Pre\",'AS Data'!$J$6:$J$700000,\"=\",'AS Data'!$AQ$6:$AQ$700000,\"0\")","v":0},null,{"$f":"A20","v":"under 1 year"},{"$f":"COUNTIFS('AS Data'!$R$6:$R$700000,\"Post\",'AS Data'!$Q$6:$Q$700000,\"=\",'AS Data'!$AQ$6:$AQ$700000,\"0\")","v":0}]
["1 to 4 years",{"$f":"COUNTIFS('AS Data'!$R$6:$R$700000,\"Pre\",'AS Data'!$J$6:$J$700000,\"=\",'AS Data'!$AQ$6:$AQ$700000,\">0\",'AS Data'!$AQ$6:$AQ$700000,\"<5\")","v":0},null,"1 to 4 years",{"$f":"COUNTIFS('AS Data'!$R$6:$R$700000,\"Post\",'AS Data'!$Q$6:$Q$700000,\"=\",'AS Data'!$AQ$6:$AQ$700000,\">0\",'AS Data'!$AQ$6:$AQ$700000,\"<5\")","v":0}]
["5 to 9 years",{"$f":"COUNTIFS('AS Data'!$R$6:$R$700000,\"Pre\",'AS Data'!$J$6:$J$700000,\"=\",'AS Data'!$AQ$6:$AQ$700000,\">4\",'AS Data'!$AQ$6:$AQ$700000,\"<10\")","v":0},null,"5 to 9 years",{"$f":"COUNTIFS('AS Data'!$R$6:$R$700000,\"Post\",'AS Data'!$Q$6:$Q$700000,\"=\",'AS Data'!$AQ$6:$AQ$700000,\">4\",'AS Data'!$AQ$6:$AQ$700000,\"<10\")","v":0}]
["10 to 15 years",{"$f":"COUNTIFS('AS Data'!$R$6:$R$700000,\"Pre\",'AS Data'!$J$6:$J$700000,\"=\",'AS Data'!$AQ$6:$AQ$700000,\">9\",'AS Data'!$AQ$6:$AQ$700000,\"<16\")","v":0},null,"10 to 15 years",{"$f":"COUNTIFS('AS Data'!$R$6:$R$700000,\"Post\",'AS Data'!$Q$6:$Q$700000,\"=\",'AS Data'!$AQ$6:$AQ$700000,\">9\",'AS Data'!$AQ$6:$AQ$700000,\"<16\")","v":0}]
["16 to 18 years",{"$f":"COUNTIFS('AS Data'!$R$6:$R$700000,\"Pre\",'AS Data'!$J$6:$J$700000,\"=\",'AS Data'!$AQ$6:$AQ$700000,\">15\",'AS Data'!$AQ$6:$AQ$700000,\"<19\")","v":0},null,"16 to 18 years",{"$f":"COUNTIFS('AS Data'!$R$6:$R$700000,\"Post\",'AS Data'!$Q$6:$Q$700000,\"=\",'AS Data'!$AQ$6:$AQ$700000,\">15\",'AS Data'!$AQ$6:$AQ$700000,\"<19\")","v":0}]
["19 to 25 years",{"$f":"COUNTIFS('AS Data'!$R$6:$R$700000,\"Pre\",'AS Data'!$J$6:$J$700000,\"=\",'AS Data'!$AQ$6:$AQ$700000,\">18\",'AS Data'!$AQ$6:$AQ$700000,\"<26\")","v":0},null,"19 to 25 years",{"$f":"COUNTIFS('AS Data'!$R$6:$R$700000,\"Post\",'AS Data'!$Q$6:$Q$700000,\"=\",'AS Data'!$AQ$6:$AQ$700000,\">18\",'AS Data'!$AQ$6:$AQ$700000,\"<26\")","v":0}]
["Gender Identity",null,null,"Gender Identity"]
[{"$f":"Lists!H2","v":"Not known (gender not recorded )"},{"$f":"COUNTIFS('AS Data'!$R$6:$R$700000,\"Pre\",'AS Data'!$J$6:$J$700000,\"=\",'AS Data'!$E$6:$E$700000,Lists!G2)","v":0},null,"Not known (gender not recorded )",{"$f":"COUNTIFS('AS Data'!$R$6:$R$700000,\"Post\",'AS Data'!$Q$6:$Q$700000,\"=\",'AS Data'!$E$6:$E$700000,Lists!G2)","v":0}]
[{"$f":"Lists!H3","v":"Male"},{"$f":"COUNTIFS('AS Data'!$R$6:$R$700000,\"Pre\",'AS Data'!$J$6:$J$700000,\"=\",'AS Data'!$E$6:$E$700000,Lists!G3)","v":0},null,"Male",{"$f":"COUNTIFS('AS Data'!$R$6:$R$700000,\"Post\",'AS Data'!$Q$6:$Q$700000,\"=\",'AS Data'!$E$6:$E$700000,Lists!G3)","v":0}]
[{"$f":"Lists!H4","v":"Female"},{"$f":"COUNTIFS('AS Data'!$R$6:$R$700000,\"Pre\",'AS Data'!$J$6:$J$700000,\"=\",'AS Data'!$E$6:$E$700000,Lists!G4)","v":0},null,"Female",{"$f":"COUNTIFS('AS Data'!$R$6:$R$700000,\"Post\",'AS Data'!$Q$6:$Q$700000,\"=\",'AS Data'!$E$6:$E$700000,Lists!G4)","v":0}]
[{"$f":"Lists!H5","v":"Non-binary"},{"$f":"COUNTIFS('AS Data'!$R$6:$R$700000,\"Pre\",'AS Data'!$J$6:$J$700000,\"=\",'AS Data'!$E$6:$E$700000,Lists!G5)","v":0},null,"Non-binary",{"$f":"COUNTIFS('AS Data'!$R$6:$R$700000,\"Post\",'AS Data'!$Q$6:$Q$700000,\"=\",'AS Data'!$E$6:$E$700000,Lists!G5)","v":0}]
[{"$f":"Lists!H6","v":"Transgender Man (Trans Man)"},{"$f":"COUNTIFS('AS Data'!$R$6:$R$700000,\"Pre\",'AS Data'!$J$6:$J$700000,\"=\",'AS Data'!$E$6:$E$700000,Lists!G6)","v":0},null,"Transgender Man (Trans Man)",{"$f":"COUNTIFS('AS Data'!$R$6:$R$700000,\"Post\",'AS Data'!$Q$6:$Q$700000,\"=\",'AS Data'!$E$6:$E$700000,Lists!G6)","v":0}]
[{"$f":"Lists!H7","v":"Transgender Woman (Trans Woman)"},{"$f":"COUNTIFS('AS Data'!$R$6:$R$700000,\"Pre\",'AS Data'!$J$6:$J$700000,\"=\",'AS Data'!$E$6:$E$700000,Lists!G7)","v":0},null,"Transgender Woman (Trans Woman)",{"$f":"COUNTIFS('AS Data'!$R$6:$R$700000,\"Post\",'AS Data'!$Q$6:$Q$700000,\"=\",'AS Data'!$E$6:$E$700000,Lists!G7)","v":0}]
[{"$f":"Lists!H8","v":"Other gender identity"},{"$f":"COUNTIFS('AS Data'!$R$6:$R$700000,\"Pre\",'AS Data'!$J$6:$J$700000,\"=\",'AS Data'!$E$6:$E$700000,Lists!G8)","v":0},null,"Other gender identity",{"$f":"COUNTIFS('AS Data'!$R$6:$R$700000,\"Post\",'AS Data'!$Q$6:$Q$700000,\"=\",'AS Data'!$E$6:$E$700000,Lists!G8)","v":0}]
[{"$f":"Lists!H9","v":"Gender identity the same as sex registered at birth but no specific identity given"},{"$f":"COUNTIFS('AS Data'!$R$6:$R$700000,\"Pre\",'AS Data'!$J$6:$J$700000,\"=\",'AS Data'!$E$6:$E$700000,Lists!G9)","v":0},null,"Gender identity the same as sex registered at birth but no specific identity given",{"$f":"COUNTIFS('AS Data'!$R$6:$R$700000,\"Post\",'AS Data'!$Q$6:$Q$700000,\"=\",'AS Data'!$E$6:$E$700000,Lists!G9)","v":0}]
[{"$f":"Lists!H10","v":"Gender identity different from sex registered at birth but no specific identity given"},{"$f":"COUNTIFS('AS Data'!$R$6:$R$700000,\"Pre\",'AS Data'!$J$6:$J$700000,\"=\",'AS Data'!$E$6:$E$700000,Lists!G10)","v":0},null,"Gender identity different from sex registered at birth but no specific identity given",{"$f":"COUNTIFS('AS Data'!$R$6:$R$700000,\"Post\",'AS Data'!$Q$6:$Q$700000,\"=\",'AS Data'!$E$6:$E$700000,Lists!G10)","v":0}]
[{"$f":"Lists!H11","v":"Neither"},{"$f":"COUNTIFS('AS Data'!$R$6:$R$700000,\"Pre\",'AS Data'!$J$6:$J$700000,\"=\",'AS Data'!$E$6:$E$700000,Lists!G11)","v":0},null,"Neither",{"$f":"COUNTIFS('AS Data'!$R$6:$R$700000,\"Post\",'AS Data'!$Q$6:$Q$700000,\"=\",'AS Data'!$E$6:$E$700000,Lists!G11)","v":0}]
["Ethnic Origin",null,null,"Ethnic Origin"]
[{"$f":"Lists!K2","v":"Asian Bangladeshi"},{"$f":"COUNTIFS('AS Data'!$R$6:$R$700000,\"Pre\",'AS Data'!$J$6:$J$700000,\"=\",'AS Data'!$F$6:$F$700000,Lists!J2)","v":0},null,"Asian Bangladeshi",{"$f":"COUNTIFS('AS Data'!$R$6:$R$700000,\"Post\",'AS Data'!$Q$6:$Q$700000,\"=\",'AS Data'!$F$6:$F$700000,Lists!J2)","v":0}]
[{"$f":"Lists!K3","v":"Asian Indian"},{"$f":"COUNTIFS('AS Data'!$R$6:$R$700000,\"Pre\",'AS Data'!$J$6:$J$700000,\"=\",'AS Data'!$F$6:$F$700000,Lists!J3)","v":0},null,"Asian Indian",{"$f":"COUNTIFS('AS Data'!$R$6:$R$700000,\"Post\",'AS Data'!$Q$6:$Q$700000,\"=\",'AS Data'!$F$6:$F$700000,Lists!J3)","v":0}]
[{"$f":"Lists!K4","v":"Any other Asian background"},{"$f":"COUNTIFS('AS Data'!$R$6:$R$700000,\"Pre\",'AS Data'!$J$6:$J$700000,\"=\",'AS Data'!$F$6:$F$700000,Lists!J4)","v":0},null,"Any other Asian background",{"$f":"COUNTIFS('AS Data'!$R$6:$R$700000,\"Post\",'AS Data'!$Q$6:$Q$700000,\"=\",'AS Data'!$F$6:$F$700000,Lists!J4)","v":0}]
[{"$f":"Lists!K5","v":"Asian Pakistani"},{"$f":"COUNTIFS('AS Data'!$R$6:$R$700000,\"Pre\",'AS Data'!$J$6:$J$700000,\"=\",'AS Data'!$F$6:$F$700000,Lists!J5)","v":0},null,"Asian Pakistani",{"$f":"COUNTIFS('AS Data'!$R$6:$R$700000,\"Post\",'AS Data'!$Q$6:$Q$700000,\"=\",'AS Data'!$F$6:$F$700000,Lists!J5)","v":0}]
[{"$f":"Lists!K6","v":"Black African"},{"$f":"COUNTIFS('AS Data'!$R$6:$R$700000,\"Pre\",'AS Data'!$J$6:$J$700000,\"=\",'AS Data'!$F$6:$F$700000,Lists!J6)","v":0},null,"Black African",{"$f":"COUNTIFS('AS Data'!$R$6:$R$700000,\"Post\",'AS Data'!$Q$6:$Q$700000,\"=\",'AS Data'!$F$6:$F$700000,Lists!J6)","v":0}]
[{"$f":"Lists!K7","v":"Black Caribbean"},{"$f":"COUNTIFS('AS Data'!$R$6:$R$700000,\"Pre\",'AS Data'!$J$6:$J$700000,\"=\",'AS Data'!$F$6:$F$700000,Lists!J7)","v":0},null,"Black Caribbean",{"$f":"COUNTIFS('AS Data'!$R$6:$R$700000,\"Post\",'AS Data'!$Q$6:$Q$700000,\"=\",'AS Data'!$F$6:$F$700000,Lists!J7)","v":0}]
[{"$f":"Lists!K8","v":"Any other Black background"},{"$f":"COUNTIFS('AS Data'!$R$6:$R$700000,\"Pre\",'AS Data'!$J$6:$J$700000,\"=\",'AS Data'!$F$6:$F$700000,Lists!J8)","v":0},null,"Any other Black background",{"$f":"COUNTIFS('AS Data'!$R$6:$R$700000,\"Post\",'AS Data'!$Q$6:$Q$700000,\"=\",'AS Data'!$F$6:$F$700000,Lists!J8)","v":0}]
[{"$f":"Lists!K9","v":"Chinese"},{"$f":"COUNTIFS('AS Data'!$R$6:$R$700000,\"Pre\",'AS Data'!$J$6:$J$700000,\"=\",'AS Data'!$F$6:$F$700000,Lists!J9)","v":0},null,"Chinese",{"$f":"COUNTIFS('AS Data'!$R$6:$R$700000,\"Post\",'AS Data'!$Q$6:$Q$700000,\"=\",'AS Data'!$F$6:$F$700000,Lists!J9)","v":0}]
[{"$f":"Lists!K10","v":"Any other mixed background"},{"$f":"COUNTIFS('AS Data'!$R$6:$R$700000,\"Pre\",'AS Data'!$J$6:$J$700000,\"=\",'AS Data'!$F$6:$F$700000,Lists!J10)","v":0},null,"Any other mixed background",{"$f":"COUNTIFS('AS Data'!$R$6:$R$700000,\"Post\",'AS Data'!$Q$6:$Q$700000,\"=\",'AS Data'!$F$6:$F$700000,Lists!J10)","v":0}]
[{"$f":"Lists!K11","v":"Mixed White and Asian"},{"$f":"COUNTIFS('AS Data'!$R$6:$R$700000,\"Pre\",'AS Data'!$J$6:$J$700000,\"=\",'AS Data'!$F$6:$F$700000,Lists!J11)","v":0},null,"Mixed White and Asian",{"$f":"COUNTIFS('AS Data'!$R$6:$R$700000,\"Post\",'AS Data'!$Q$6:$Q$700000,\"=\",'AS Data'!$F$6:$F$700000,Lists!J11)","v":0}]
[{"$f":"Lists!K12","v":"Mixed White and Black African"},{"$f":"COUNTIFS('AS Data'!$R$6:$R$700000,\"Pre\",'AS Data'!$J$6:$J$700000,\"=\",'AS Data'!$F$6:$F$700000,Lists!J12)","v":0},null,"Mixed White and Black African",{"$f":"COUNTIFS('AS Data'!$R$6:$R$700000,\"Post\",'AS Data'!$Q$6:$Q$700000,\"=\",'AS Data'!$F$6:$F$700000,Lists!J12)","v":0}]
[{"$f":"Lists!K13","v":"Mixed White and Black Caribbean"},{"$f":"COUNTIFS('AS Data'!$R$6:$R$700000,\"Pre\",'AS Data'!$J$6:$J$700000,\"=\",'AS Data'!$F$6:$F$700000,Lists!J13)","v":0},null,"Mixed White and Black Caribbean",{"$f":"COUNTIFS('AS Data'!$R$6:$R$700000,\"Post\",'AS Data'!$Q$6:$Q$700000,\"=\",'AS Data'!$F$6:$F$700000,Lists!J13)","v":0}]
[{"$f":"Lists!K14","v":"Information not yet obtained"},{"$f":"COUNTIFS('AS Data'!$R$6:$R$700000,\"Pre\",'AS Data'!$J$6:$J$700000,\"=\",'AS Data'!$F$6:$F$700000,Lists!J14)","v":0},null,"Information not yet obtained",{"$f":"COUNTIFS('AS Data'!$R$6:$R$700000,\"Post\",'AS Data'!$Q$6:$Q$700000,\"=\",'AS Data'!$F$6:$F$700000,Lists!J14)","v":0}]
[{"$f":"Lists!K15","v":"Any other ethnic group"},{"$f":"COUNTIFS('AS Data'!$R$6:$R$700000,\"Pre\",'AS Data'!$J$6:$J$700000,\"=\",'AS Data'!$F$6:$F$700000,Lists!J15)","v":0},null,"Any other ethnic group",{"$f":"COUNTIFS('AS Data'!$R$6:$R$700000,\"Post\",'AS Data'!$Q$6:$Q$700000,\"=\",'AS Data'!$F$6:$F$700000,Lists!J15)","v":0}]
[{"$f":"Lists!K16","v":"Refused"},{"$f":"COUNTIFS('AS Data'!$R$6:$R$700000,\"Pre\",'AS Data'!$J$6:$J$700000,\"=\",'AS Data'!$F$6:$F$700000,Lists!J16)","v":0},null,"Refused",{"$f":"COUNTIFS('AS Data'!$R$6:$R$700000,\"Post\",'AS Data'!$Q$6:$Q$700000,\"=\",'AS Data'!$F$6:$F$700000,Lists!J16)","v":0}]
[{"$f":"Lists!K17","v":"White British"},{"$f":"COUNTIFS('AS Data'!$R$6:$R$700000,\"Pre\",'AS Data'!$J$6:$J$700000,\"=\",'AS Data'!$F$6:$F$700000,Lists!J17)","v":0},null,"White British",{"$f":"COUNTIFS('AS Data'!$R$6:$R$700000,\"Post\",'AS Data'!$Q$6:$Q$700000,\"=\",'AS Data'!$F$6:$F$700000,Lists!J17)","v":0}]
[{"$f":"Lists!K18","v":"White Irish"},{"$f":"COUNTIFS('AS Data'!$R$6:$R$700000,\"Pre\",'AS Data'!$J$6:$J$700000,\"=\",'AS Data'!$F$6:$F$700000,Lists!J18)","v":0},null,"White Irish",{"$f":"COUNTIFS('AS Data'!$R$6:$R$700000,\"Post\",'AS Data'!$Q$6:$Q$700000,\"=\",'AS Data'!$F$6:$F$700000,Lists!J18)","v":0}]
[{"$f":"Lists!K19","v":"White Traveller of Irish heritage"},{"$f":"COUNTIFS('AS Data'!$R$6:$R$700000,\"Pre\",'AS Data'!$J$6:$J$700000,\"=\",'AS Data'!$F$6:$F$700000,Lists!J19)","v":0},null,"White Traveller of Irish heritage",{"$f":"COUNTIFS('AS Data'!$R$6:$R$700000,\"Post\",'AS Data'!$Q$6:$Q$700000,\"=\",'AS Data'!$F$6:$F$700000,Lists!J19)","v":0}]
[{"$f":"Lists!K20","v":"Any other White background"},{"$f":"COUNTIFS('AS Data'!$R$6:$R$700000,\"Pre\",'AS Data'!$J$6:$J$700000,\"=\",'AS Data'!$F$6:$F$700000,Lists!J20)","v":0},null,"Any other White background",{"$f":"COUNTIFS('AS Data'!$R$6:$R$700000,\"Post\",'AS Data'!$Q$6:$Q$700000,\"=\",'AS Data'!$F$6:$F$700000,Lists!J20)","v":0}]
[{"$f":"Lists!K21","v":"White Gypsy/Roma"},{"$f":"COUNTIFS('AS Data'!$R$6:$R$700000,\"Pre\",'AS Data'!$J$6:$J$700000,\"=\",'AS Data'!$F$6:$F$700000,Lists!J21)","v":0},null,"White Gypsy/Roma",{"$f":"COUNTIFS('AS Data'!$R$6:$R$700000,\"Post\",'AS Data'!$Q$6:$Q$700000,\"=\",'AS Data'!$F$6:$F$700000,Lists!J21)","v":0}]
["Disability",null,null,"Disability"]
["Yes",{"$f":"COUNTIFS('AS Data'!$R$6:$R$700000,\"Pre\",'AS Data'!$J$6:$J$700000,\"=\",'AS Data'!$G$6:$G$700000,1)","v":0},null,"Yes",{"$f":"COUNTIFS('AS Data'!$R$6:$R$700000,\"Post\",'AS Data'!$Q$6:$Q$700000,\"=\",'AS Data'!$G$6:$G$700000,1)","v":0}]
["No",{"$f":"COUNTIFS('AS Data'!$R$6:$R$700000,\"Pre\",'AS Data'!$J$6:$J$700000,\"=\",'AS Data'!$G$6:$G$700000,0)","v":0},null,"No",{"$f":"COUNTIFS('AS Data'!$R$6:$R$700000,\"Post\",'AS Data'!$Q$6:$Q$700000,\"=\",'AS Data'!$G$6:$G$700000,0)","v":0}]
[]
["Characteristics of Children for whom an adoption support contact was closed in reporting period",{"$f":"COUNTIFS('AS Data'!$R$6:$R$700000,\"Pre\",'AS Data'!$J$6:$J$700000,\"<>\")","v":0},null,"Characteristics of Children for whom an adoption support contact was closed in reporting period",{"$f":"COUNTIFS('AS Data'!$R$6:$R$700000,\"Post\",'AS Data'!$Q$6:$Q$700000,\"<>\")","v":0}]
["By Age Range (age when AO granted):",null,null,"By Age Range (age when case closed):"]
["under 1 year",{"$f":"COUNTIFS('AS Data'!$R$6:$R$700000,\"Pre\",'AS Data'!$J$6:$J$700000,\"<=\"&RDate,'AS Data'!$J$6:$J$700000,\">=\"&SDate,'AS Data'!$AR$6:$AR$700000,\"0\")","v":0},null,{"$f":"A64","v":"under 1 year"},{"$f":"COUNTIFS('AS Data'!$R$6:$R$700000,\"Post\",'AS Data'!$Q$6:$Q$700000,\"<=\"&RDate,'AS Data'!$Q$6:$Q$700000,\">=\"&SDate,'AS Data'!$AS$6:$AS$700000,\"0\")","v":0}]
["1 to 4 years",{"$f":"COUNTIFS('AS Data'!$R$6:$R$700000,\"Pre\",'AS Data'!$J$6:$J$700000,\"<=\"&RDate,'AS Data'!$J$6:$J$700000,\">=\"&SDate,'AS Data'!$AR$6:$AR$700000,\">0\",'AS Data'!$AR$6:$AR$700000,\"<5\")","v":0},null,"1 to 4 years",{"$f":"COUNTIFS('AS Data'!$R$6:$R$700000,\"Post\",'AS Data'!$Q$6:$Q$700000,\"<=\"&RDate,'AS Data'!$Q$6:$Q$700000,\">=\"&SDate,'AS Data'!$AS$6:$AS$700000,\">0\",'AS Data'!$AS$6:$AS$700000,\"<5\")","v":0}]
["5 to 9 years",{"$f":"COUNTIFS('AS Data'!$R$6:$R$700000,\"Pre\",'AS Data'!$J$6:$J$700000,\"<=\"&RDate,'AS Data'!$J$6:$J$700000,\">=\"&SDate,'AS Data'!$AR$6:$AR$700000,\">4\",'AS Data'!$AR$6:$AR$700000,\"<10\")","v":0},null,"5 to 9 years",{"$f":"COUNTIFS('AS Data'!$R$6:$R$700000,\"Post\",'AS Data'!$Q$6:$Q$700000,\"<=\"&RDate,'AS Data'!$Q$6:$Q$700000,\">=\"&SDate,'AS Data'!$AS$6:$AS$700000,\">4\",'AS Data'!$AS$6:$AS$700000,\"<10\")","v":0}]
["10 to 15 years",{"$f":"COUNTIFS('AS Data'!$R$6:$R$700000,\"Pre\",'AS Data'!$J$6:$J$700000,\"<=\"&RDate,'AS Data'!$J$6:$J$700000,\">=\"&SDate,'AS Data'!$AR$6:$AR$700000,\">9\",'AS Data'!$AR$6:$AR$700000,\"<16\")","v":0},null,"10 to 15 years",{"$f":"COUNTIFS('AS Data'!$R$6:$R$700000,\"Post\",'AS Data'!$Q$6:$Q$700000,\"<=\"&RDate,'AS Data'!$Q$6:$Q$700000,\">=\"&SDate,'AS Data'!$AS$6:$AS$700000,\">9\",'AS Data'!$AS$6:$AS$700000,\"<16\")","v":0}]
["16 to 18 years",{"$f":"COUNTIFS('AS Data'!$R$6:$R$700000,\"Pre\",'AS Data'!$J$6:$J$700000,\"<=\"&RDate,'AS Data'!$J$6:$J$700000,\">=\"&SDate,'AS Data'!$AR$6:$AR$700000,\">15\",'AS Data'!$AR$6:$AR$700000,\"<19\")","v":0},null,"16 to 18 years",{"$f":"COUNTIFS('AS Data'!$R$6:$R$700000,\"Post\",'AS Data'!$Q$6:$Q$700000,\"<=\"&RDate,'AS Data'!$Q$6:$Q$700000,\">=\"&SDate,'AS Data'!$AS$6:$AS$700000,\">15\",'AS Data'!$AS$6:$AS$700000,\"<19\")","v":0}]
["19 to 25 years",{"$f":"COUNTIFS('AS Data'!$R$6:$R$700000,\"Pre\",'AS Data'!$J$6:$J$700000,\"<=\"&RDate,'AS Data'!$J$6:$J$700000,\">=\"&SDate,'AS Data'!$AR$6:$AR$700000,\">18\",'AS Data'!$AR$6:$AR$700000,\"<26\")","v":0},null,"19 to 25 years",{"$f":"COUNTIFS('AS Data'!$R$6:$R$700000,\"Post\",'AS Data'!$Q$6:$Q$700000,\"<=\"&RDate,'AS Data'!$Q$6:$Q$700000,\">=\"&SDate,'AS Data'!$AS$6:$AS$700000,\">18\",'AS Data'!$AS$6:$AS$700000,\"<26\")","v":0}]
["Gender Identity",null,null,"Gender Identity"]
[{"$f":"A27","v":"Not known (gender not recorded )"},{"$f":"COUNTIFS('AS Data'!$R$6:$R$700000,\"Pre\",'AS Data'!$J$6:$J$700000,\"<=\"&RDate,'AS Data'!$J$6:$J$700000,\">=\"&SDate,'AS Data'!$E$6:$E$700000,Lists!G2)","v":0},null,"Not known (gender not recorded )",{"$f":"COUNTIFS('AS Data'!$R$6:$R$700000,\"Post\",'AS Data'!$Q$6:$Q$700000,\"<=\"&RDate,'AS Data'!$Q$6:$Q$700000,\">=\"&SDate,'AS Data'!$E$6:$E$700000,Lists!G2)","v":0}]
[{"$f":"A28","v":"Male"},{"$f":"COUNTIFS('AS Data'!$R$6:$R$700000,\"Pre\",'AS Data'!$J$6:$J$700000,\"<=\"&RDate,'AS Data'!$J$6:$J$700000,\">=\"&SDate,'AS Data'!$E$6:$E$700000,Lists!G3)","v":0},null,"Male",{"$f":"COUNTIFS('AS Data'!$R$6:$R$700000,\"Post\",'AS Data'!$Q$6:$Q$700000,\"<=\"&RDate,'AS Data'!$Q$6:$Q$700000,\">=\"&SDate,'AS Data'!$E$6:$E$700000,Lists!G3)","v":0}]
["Female",{"$f":"COUNTIFS('AS Data'!$R$6:$R$700000,\"Pre\",'AS Data'!$J$6:$J$700000,\"<=\"&RDate,'AS Data'!$J$6:$J$700000,\">=\"&SDate,'AS Data'!$E$6:$E$700000,Lists!G4)","v":0},null,"Female",{"$f":"COUNTIFS('AS Data'!$R$6:$R$700000,\"Post\",'AS Data'!$Q$6:$Q$700000,\"<=\"&RDate,'AS Data'!$Q$6:$Q$700000,\">=\"&SDate,'AS Data'!$E$6:$E$700000,Lists!G4)","v":0}]
["Non-binary",{"$f":"COUNTIFS('AS Data'!$R$6:$R$700000,\"Pre\",'AS Data'!$J$6:$J$700000,\"<=\"&RDate,'AS Data'!$J$6:$J$700000,\">=\"&SDate,'AS Data'!$E$6:$E$700000,Lists!G5)","v":0},null,"Non-binary",{"$f":"COUNTIFS('AS Data'!$R$6:$R$700000,\"Post\",'AS Data'!$Q$6:$Q$700000,\"<=\"&RDate,'AS Data'!$Q$6:$Q$700000,\">=\"&SDate,'AS Data'!$E$6:$E$700000,Lists!G5)","v":0}]
["Transgender Man (Trans Man)",{"$f":"COUNTIFS('AS Data'!$R$6:$R$700000,\"Pre\",'AS Data'!$J$6:$J$700000,\"<=\"&RDate,'AS Data'!$J$6:$J$700000,\">=\"&SDate,'AS Data'!$E$6:$E$700000,Lists!G6)","v":0},null,"Transgender Man (Trans Man)",{"$f":"COUNTIFS('AS Data'!$R$6:$R$700000,\"Post\",'AS Data'!$Q$6:$Q$700000,\"<=\"&RDate,'AS Data'!$Q$6:$Q$700000,\">=\"&SDate,'AS Data'!$E$6:$E$700000,Lists!G6)","v":0}]
["Transgender Woman (Trans Woman)",{"$f":"COUNTIFS('AS Data'!$R$6:$R$700000,\"Pre\",'AS Data'!$J$6:$J$700000,\"<=\"&RDate,'AS Data'!$J$6:$J$700000,\">=\"&SDate,'AS Data'!$E$6:$E$700000,Lists!G7)","v":0},null,"Transgender Woman (Trans Woman)",{"$f":"COUNTIFS('AS Data'!$R$6:$R$700000,\"Post\",'AS Data'!$Q$6:$Q$700000,\"<=\"&RDate,'AS Data'!$Q$6:$Q$700000,\">=\"&SDate,'AS Data'!$E$6:$E$700000,Lists!G7)","v":0}]
["Other gender identity",{"$f":"COUNTIFS('AS Data'!$R$6:$R$700000,\"Pre\",'AS Data'!$J$6:$J$700000,\"<=\"&RDate,'AS Data'!$J$6:$J$700000,\">=\"&SDate,'AS Data'!$E$6:$E$700000,Lists!G8)","v":0},null,"Other gender identity",{"$f":"COUNTIFS('AS Data'!$R$6:$R$700000,\"Post\",'AS Data'!$Q$6:$Q$700000,\"<=\"&RDate,'AS Data'!$Q$6:$Q$700000,\">=\"&SDate,'AS Data'!$E$6:$E$700000,Lists!G8)","v":0}]
["Gender identity the same as sex registered at birth but no specific identity given",{"$f":"COUNTIFS('AS Data'!$R$6:$R$700000,\"Pre\",'AS Data'!$J$6:$J$700000,\"<=\"&RDate,'AS Data'!$J$6:$J$700000,\">=\"&SDate,'AS Data'!$E$6:$E$700000,Lists!G9)","v":0},null,"Gender identity the same as sex registered at birth but no specific identity given",{"$f":"COUNTIFS('AS Data'!$R$6:$R$700000,\"Post\",'AS Data'!$Q$6:$Q$700000,\"<=\"&RDate,'AS Data'!$Q$6:$Q$700000,\">=\"&SDate,'AS Data'!$E$6:$E$700000,Lists!G9)","v":0}]
["Gender identity different from sex registered at birth but no specific identity given",{"$f":"COUNTIFS('AS Data'!$R$6:$R$700000,\"Pre\",'AS Data'!$J$6:$J$700000,\"<=\"&RDate,'AS Data'!$J$6:$J$700000,\">=\"&SDate,'AS Data'!$E$6:$E$700000,Lists!G10)","v":0},null,"Gender identity different from sex registered at birth but no specific identity given",{"$f":"COUNTIFS('AS Data'!$R$6:$R$700000,\"Post\",'AS Data'!$Q$6:$Q$700000,\"<=\"&RDate,'AS Data'!$Q$6:$Q$700000,\">=\"&SDate,'AS Data'!$E$6:$E$700000,Lists!G10)","v":0}]
["Neither",{"$f":"COUNTIFS('AS Data'!$R$6:$R$700000,\"Pre\",'AS Data'!$J$6:$J$700000,\"<=\"&RDate,'AS Data'!$J$6:$J$700000,\">=\"&SDate,'AS Data'!$E$6:$E$700000,Lists!G11)","v":0},null,"Neither",{"$f":"COUNTIFS('AS Data'!$R$6:$R$700000,\"Post\",'AS Data'!$Q$6:$Q$700000,\"<=\"&RDate,'AS Data'!$Q$6:$Q$700000,\">=\"&SDate,'AS Data'!$E$6:$E$700000,Lists!G11)","v":0}]
["Ethnic Origin",null,null,"Ethnic Origin"]
[{"$f":"A38","v":"Asian Bangladeshi"},{"$f":"COUNTIFS('AS Data'!$R$6:$R$700000,\"Pre\",'AS Data'!$J$6:$J$700000,\"<=\"&RDate,'AS Data'!$J$6:$J$700000,\">=\"&SDate,'AS Data'!$F$6:$F$700000,Lists!J2)","v":0},null,"Asian Bangladeshi",{"$f":"COUNTIFS('AS Data'!$R$6:$R$700000,\"Post\",'AS Data'!$Q$6:$Q$700000,\"<=\"&RDate,'AS Data'!$Q$6:$Q$700000,\">=\"&SDate,'AS Data'!$F$6:$F$700000,Lists!J2)","v":0}]
[{"$f":"A39","v":"Asian Indian"},{"$f":"COUNTIFS('AS Data'!$R$6:$R$700000,\"Pre\",'AS Data'!$J$6:$J$700000,\"<=\"&RDate,'AS Data'!$J$6:$J$700000,\">=\"&SDate,'AS Data'!$F$6:$F$700000,Lists!J3)","v":0},null,"Asian Indian",{"$f":"COUNTIFS('AS Data'!$R$6:$R$700000,\"Post\",'AS Data'!$Q$6:$Q$700000,\"<=\"&RDate,'AS Data'!$Q$6:$Q$700000,\">=\"&SDate,'AS Data'!$F$6:$F$700000,Lists!J3)","v":0}]
["Any other Asian background",{"$f":"COUNTIFS('AS Data'!$R$6:$R$700000,\"Pre\",'AS Data'!$J$6:$J$700000,\"<=\"&RDate,'AS Data'!$J$6:$J$700000,\">=\"&SDate,'AS Data'!$F$6:$F$700000,Lists!J4)","v":0},null,"Any other Asian background",{"$f":"COUNTIFS('AS Data'!$R$6:$R$700000,\"Post\",'AS Data'!$Q$6:$Q$700000,\"<=\"&RDate,'AS Data'!$Q$6:$Q$700000,\">=\"&SDate,'AS Data'!$F$6:$F$700000,Lists!J4)","v":0}]
["Asian Pakistani",{"$f":"COUNTIFS('AS Data'!$R$6:$R$700000,\"Pre\",'AS Data'!$J$6:$J$700000,\"<=\"&RDate,'AS Data'!$J$6:$J$700000,\">=\"&SDate,'AS Data'!$F$6:$F$700000,Lists!J5)","v":0},null,"Asian Pakistani",{"$f":"COUNTIFS('AS Data'!$R$6:$R$700000,\"Post\",'AS Data'!$Q$6:$Q$700000,\"<=\"&RDate,'AS Data'!$Q$6:$Q$700000,\">=\"&SDate,'AS Data'!$F$6:$F$700000,Lists!J5)","v":0}]
["Black African",{"$f":"COUNTIFS('AS Data'!$R$6:$R$700000,\"Pre\",'AS Data'!$J$6:$J$700000,\"<=\"&RDate,'AS Data'!$J$6:$J$700000,\">=\"&SDate,'AS Data'!$F$6:$F$700000,Lists!J6)","v":0},null,"Black African",{"$f":"COUNTIFS('AS Data'!$R$6:$R$700000,\"Post\",'AS Data'!$Q$6:$Q$700000,\"<=\"&RDate,'AS Data'!$Q$6:$Q$700000,\">=\"&SDate,'AS Data'!$F$6:$F$700000,Lists!J6)","v":0}]
["Black Caribbean",{"$f":"COUNTIFS('AS Data'!$R$6:$R$700000,\"Pre\",'AS Data'!$J$6:$J$700000,\"<=\"&RDate,'AS Data'!$J$6:$J$700000,\">=\"&SDate,'AS Data'!$F$6:$F$700000,Lists!J7)","v":0},null,"Black Caribbean",{"$f":"COUNTIFS('AS Data'!$R$6:$R$700000,\"Post\",'AS Data'!$Q$6:$Q$700000,\"<=\"&RDate,'AS Data'!$Q$6:$Q$700000,\">=\"&SDate,'AS Data'!$F$6:$F$700000,Lists!J7)","v":0}]
["Any other Black background",{"$f":"COUNTIFS('AS Data'!$R$6:$R$700000,\"Pre\",'AS Data'!$J$6:$J$700000,\"<=\"&RDate,'AS Data'!$J$6:$J$700000,\">=\"&SDate,'AS Data'!$F$6:$F$700000,Lists!J8)","v":0},null,"Any other Black background",{"$f":"COUNTIFS('AS Data'!$R$6:$R$700000,\"Post\",'AS Data'!$Q$6:$Q$700000,\"<=\"&RDate,'AS Data'!$Q$6:$Q$700000,\">=\"&SDate,'AS Data'!$F$6:$F$700000,Lists!J8)","v":0}]
["Chinese",{"$f":"COUNTIFS('AS Data'!$R$6:$R$700000,\"Pre\",'AS Data'!$J$6:$J$700000,\"<=\"&RDate,'AS Data'!$J$6:$J$700000,\">=\"&SDate,'AS Data'!$F$6:$F$700000,Lists!J9)","v":0},null,"Chinese",{"$f":"COUNTIFS('AS Data'!$R$6:$R$700000,\"Post\",'AS Data'!$Q$6:$Q$700000,\"<=\"&RDate,'AS Data'!$Q$6:$Q$700000,\">=\"&SDate,'AS Data'!$F$6:$F$700000,Lists!J9)","v":0}]
["Any other mixed background",{"$f":"COUNTIFS('AS Data'!$R$6:$R$700000,\"Pre\",'AS Data'!$J$6:$J$700000,\"<=\"&RDate,'AS Data'!$J$6:$J$700000,\">=\"&SDate,'AS Data'!$F$6:$F$700000,Lists!J10)","v":0},null,"Any other mixed background",{"$f":"COUNTIFS('AS Data'!$R$6:$R$700000,\"Post\",'AS Data'!$Q$6:$Q$700000,\"<=\"&RDate,'AS Data'!$Q$6:$Q$700000,\">=\"&SDate,'AS Data'!$F$6:$F$700000,Lists!J10)","v":0}]
["Mixed White and Asian",{"$f":"COUNTIFS('AS Data'!$R$6:$R$700000,\"Pre\",'AS Data'!$J$6:$J$700000,\"<=\"&RDate,'AS Data'!$J$6:$J$700000,\">=\"&SDate,'AS Data'!$F$6:$F$700000,Lists!J11)","v":0},null,"Mixed White and Asian",{"$f":"COUNTIFS('AS Data'!$R$6:$R$700000,\"Post\",'AS Data'!$Q$6:$Q$700000,\"<=\"&RDate,'AS Data'!$Q$6:$Q$700000,\">=\"&SDate,'AS Data'!$F$6:$F$700000,Lists!J11)","v":0}]
["Mixed White and Black African",{"$f":"COUNTIFS('AS Data'!$R$6:$R$700000,\"Pre\",'AS Data'!$J$6:$J$700000,\"<=\"&RDate,'AS Data'!$J$6:$J$700000,\">=\"&SDate,'AS Data'!$F$6:$F$700000,Lists!J12)","v":0},null,"Mixed White and Black African",{"$f":"COUNTIFS('AS Data'!$R$6:$R$700000,\"Post\",'AS Data'!$Q$6:$Q$700000,\"<=\"&RDate,'AS Data'!$Q$6:$Q$700000,\">=\"&SDate,'AS Data'!$F$6:$F$700000,Lists!J12)","v":0}]
["Mixed White and Black Caribbean",{"$f":"COUNTIFS('AS Data'!$R$6:$R$700000,\"Pre\",'AS Data'!$J$6:$J$700000,\"<=\"&RDate,'AS Data'!$J$6:$J$700000,\">=\"&SDate,'AS Data'!$F$6:$F$700000,Lists!J13)","v":0},null,"Mixed White and Black Caribbean",{"$f":"COUNTIFS('AS Data'!$R$6:$R$700000,\"Post\",'AS Data'!$Q$6:$Q$700000,\"<=\"&RDate,'AS Data'!$Q$6:$Q$700000,\">=\"&SDate,'AS Data'!$F$6:$F$700000,Lists!J13)","v":0}]
["Information not yet obtained",{"$f":"COUNTIFS('AS Data'!$R$6:$R$700000,\"Pre\",'AS Data'!$J$6:$J$700000,\"<=\"&RDate,'AS Data'!$J$6:$J$700000,\">=\"&SDate,'AS Data'!$F$6:$F$700000,Lists!J14)","v":0},null,"Information not yet obtained",{"$f":"COUNTIFS('AS Data'!$R$6:$R$700000,\"Post\",'AS Data'!$Q$6:$Q$700000,\"<=\"&RDate,'AS Data'!$Q$6:$Q$700000,\">=\"&SDate,'AS Data'!$F$6:$F$700000,Lists!J14)","v":0}]
["Any other ethnic group",{"$f":"COUNTIFS('AS Data'!$R$6:$R$700000,\"Pre\",'AS Data'!$J$6:$J$700000,\"<=\"&RDate,'AS Data'!$J$6:$J$700000,\">=\"&SDate,'AS Data'!$F$6:$F$700000,Lists!J15)","v":0},null,"Any other ethnic group",{"$f":"COUNTIFS('AS Data'!$R$6:$R$700000,\"Post\",'AS Data'!$Q$6:$Q$700000,\"<=\"&RDate,'AS Data'!$Q$6:$Q$700000,\">=\"&SDate,'AS Data'!$F$6:$F$700000,Lists!J15)","v":0}]
["Refused",{"$f":"COUNTIFS('AS Data'!$R$6:$R$700000,\"Pre\",'AS Data'!$J$6:$J$700000,\"<=\"&RDate,'AS Data'!$J$6:$J$700000,\">=\"&SDate,'AS Data'!$F$6:$F$700000,Lists!J16)","v":0},null,"Refused",{"$f":"COUNTIFS('AS Data'!$R$6:$R$700000,\"Post\",'AS Data'!$Q$6:$Q$700000,\"<=\"&RDate,'AS Data'!$Q$6:$Q$700000,\">=\"&SDate,'AS Data'!$F$6:$F$700000,Lists!J16)","v":0}]
["White British",{"$f":"COUNTIFS('AS Data'!$R$6:$R$700000,\"Pre\",'AS Data'!$J$6:$J$700000,\"<=\"&RDate,'AS Data'!$J$6:$J$700000,\">=\"&SDate,'AS Data'!$F$6:$F$700000,Lists!J17)","v":0},null,"White British",{"$f":"COUNTIFS('AS Data'!$R$6:$R$700000,\"Post\",'AS Data'!$Q$6:$Q$700000,\"<=\"&RDate,'AS Data'!$Q$6:$Q$700000,\">=\"&SDate,'AS Data'!$F$6:$F$700000,Lists!J17)","v":0}]
["White Irish",{"$f":"COUNTIFS('AS Data'!$R$6:$R$700000,\"Pre\",'AS Data'!$J$6:$J$700000,\"<=\"&RDate,'AS Data'!$J$6:$J$700000,\">=\"&SDate,'AS Data'!$F$6:$F$700000,Lists!J18)","v":0},null,"White Irish",{"$f":"COUNTIFS('AS Data'!$R$6:$R$700000,\"Post\",'AS Data'!$Q$6:$Q$700000,\"<=\"&RDate,'AS Data'!$Q$6:$Q$700000,\">=\"&SDate,'AS Data'!$F$6:$F$700000,Lists!J18)","v":0}]
["White Traveller of Irish heritage",{"$f":"COUNTIFS('AS Data'!$R$6:$R$700000,\"Pre\",'AS Data'!$J$6:$J$700000,\"<=\"&RDate,'AS Data'!$J$6:$J$700000,\">=\"&SDate,'AS Data'!$F$6:$F$700000,Lists!J19)","v":0},null,"White Traveller of Irish heritage",{"$f":"COUNTIFS('AS Data'!$R$6:$R$700000,\"Post\",'AS Data'!$Q$6:$Q$700000,\"<=\"&RDate,'AS Data'!$Q$6:$Q$700000,\">=\"&SDate,'AS Data'!$F$6:$F$700000,Lists!J19)","v":0}]
["Any other White background",{"$f":"COUNTIFS('AS Data'!$R$6:$R$700000,\"Pre\",'AS Data'!$J$6:$J$700000,\"<=\"&RDate,'AS Data'!$J$6:$J$700000,\">=\"&SDate,'AS Data'!$F$6:$F$700000,Lists!J20)","v":0},null,"Any other White background",{"$f":"COUNTIFS('AS Data'!$R$6:$R$700000,\"Post\",'AS Data'!$Q$6:$Q$700000,\"<=\"&RDate,'AS Data'!$Q$6:$Q$700000,\">=\"&SDate,'AS Data'!$F$6:$F$700000,Lists!J20)","v":0}]
["White Gypsy/Roma",{"$f":"COUNTIFS('AS Data'!$R$6:$R$700000,\"Pre\",'AS Data'!$J$6:$J$700000,\"<=\"&RDate,'AS Data'!$J$6:$J$700000,\">=\"&SDate,'AS Data'!$F$6:$F$700000,Lists!J21)","v":0},null,"White Gypsy/Roma",{"$f":"COUNTIFS('AS Data'!$R$6:$R$700000,\"Post\",'AS Data'!$Q$6:$Q$700000,\"<=\"&RDate,'AS Data'!$Q$6:$Q$700000,\">=\"&SDate,'AS Data'!$F$6:$F$700000,Lists!J21)","v":0}]
["Disability",null,null,"Disability"]
["Yes",{"$f":"COUNTIFS('AS Data'!$R$6:$R$700000,\"Pre\",'AS Data'!$J$6:$J$700000,\"<=\"&RDate,'AS Data'!$J$6:$J$700000,\">=\"&SDate,'AS Data'!$G$6:$G$700000,1)","v":0},null,"Yes",{"$f":"COUNTIFS('AS Data'!$R$6:$R$700000,\"Post\",'AS Data'!$Q$6:$Q$700000,\"<=\"&RDate,'AS Data'!$Q$6:$Q$700000,\">=\"&SDate,'AS Data'!$G$6:$G$700000,1)","v":0}]
["No",{"$f":"COUNTIFS('AS Data'!$R$6:$R$700000,\"Pre\",'AS Data'!$J$6:$J$700000,\"<=\"&RDate,'AS Data'!$J$6:$J$700000,\">=\"&SDate,'AS Data'!$G$6:$G$700000,0)","v":0},null,"No",{"$f":"COUNTIFS('AS Data'!$R$6:$R$700000,\"Post\",'AS Data'!$Q$6:$Q$700000,\"<=\"&RDate,'AS Data'!$Q$6:$Q$700000,\">=\"&SDate,'AS Data'!$G$6:$G$700000,0)","v":0}]

{"sheet":"Checks","index":3,"n_rows":51,"n_cols":4,"rows_kept":51,"cut":false,"hidden":false,"merged":[]}
[]
[]
["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(AND(OR(H6<>\"\",I6<>\"\"),COUNTA(A6:G6)>0),\"Pre\",IF(COUNT(K6:Q6)>0,\"Post\",\"\"))"]
["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(B6=\"\",\"Please record the child's CMS ID\",\"\"),\"\")"]
["B3","C3","Check cell is not blank and ID is unique in return","=IF(R6<>\"\",IF(C6=\"\",\"Please record a unique identifier for this case\",IF(COUNTIF($C$6:$C$100000,C6)>1,\"The contact identifier must be unique - please correct this case or other cases that have the same contact identifier recorded\",\"\")),\"\")"]
["B4","C4","check cell is not blank, is a date, is not in the future and is not over 25 years ago","=IF(R6<>\"\",IF(D6=\"\",\"Please record the date of birth for this child\",IF(OR(D6>TODAY(),NOT(ISNUMBER(D6))),\"Please enter a valid date for the date of birth\",IF(D6>RDate,\"Please enter a date that is not after the reporting period\",IF(DATEDIF(D6,RDate,\"y\")>=25,\"Cases for individuals aged 25 or over should not be included in this data return\",if(D6>MIN(H6:O6,Q6),\"Date of birth cannot be after any of the dates in the adoption journey - please correct whichever dates are wrong\",\"\"))))),\"\")"]
["B5","C5","Check cell is not blank and is in Gender_list","=IF(R6<>\"\",IF(OR(E6=\"\",ISNA(MATCH(E6,Gender_list,0))),\"Please record a valid gender code\",\"\"),\"\")"]
["B6","C6","Check cell is not blank and is in Ethnicity_list","=IF(R6<>\"\",IF(OR(F6=\"\",ISNA(MATCH(F6,Eth_list,0))),\"Please record a valid ethnicity code\",\"\"),\"\")"]
["B7","C7","Check cell is not blank and is either 0 or 1","=IF(R6<>\"\",IF(OR(G6=\"\",AND(G6<>0,G6<>1)),\"Please record a valid Disability code\",\"\"),\"\")"]
["B8","C8","If not blank, check entry is a date, is after DOB and is not in the future | if C9 and C10 are blank, and C8 has a date, that date should be in this reporting year | If C9 is not blank, C8 should not be blank","=IF(H6<>\"\",IF(OR(H6>TODAY(),NOT(ISNUMBER(H6))),\"Please enter a valid date\",IF(H6<D6,\"The adoptive match cannot have been approved before the child was born\",IF(H6>RDate,\"This date indicates that the adoptive match was approved after the reporting period, so this case should not be included in the return\",IF(AND(I6=\"\",J6=\"\",OR(H6<SDate,I6>RDate)),\"This date falls outside the reporting period, so this case should not be included in the return\",\"\")))),IF(AND(I6<>\"\",ISNUMBER(I6)),\"This date is missing, please add it\",\"\"))"]
["B9","C9","If not blank, check entry is a date, is after ADM (C8) and is not in the future | If C10 is blank and C9 has a date, that date should be in this reporting year | If C8 and C10 are not blank, C9 should not be blank","=IF(I6=\"\",IF(AND(J6<>\"\",H6<>\"\"),\"Date is missing, please add it\",\"\"),IF(OR(I6>TODAY(),NOT(ISNUMBER(I6))),\"Please enter a valid date\",IF(I6<H6,\"Placement date cannot be before date match was approved - please correct either C8 or C9\",IF(AND(J6=\"\",OR(I6<SDate,I6>RDate)),\"This case falls outside the reporting period and so does not need to be included in this data return\",IF(I6>RDate,\"Date recorded is after reporting period, so this case does not need to be included in this data return\",\"\")))))"]
["B10","C10","If not blank, check entry is a date | if pre-order case, check is after C9 or before C11 (whichever is recorded), is not in the future and before reporting period | If C11 is not blank then C10 should not be blank","=IF(AND(COUNT(K6:N6,Q6)>0,J6=\"\"),\"Date is missing, please add it\",IF(J6<>\"\",IF(OR(J6>TODAY(),NOT(ISNUMBER(J6))),\"Please enter a valid date\",IF(AND(I6<>\"\",ISNUMBER(I6),I6>J6),\"Date of AO cannot be before placement date - please correct either C9 or C10\",IF(AND(K6<>\"\",ISNUMBER(K6),J6>K6),\"Date of AO cannot be after post-order contact - please correct C10 or C11\",IF(OR(J6>RDate,AND(J6<SDate,R6=\"Pre\")),\"This case falls outside the reporting period and so does not need to be included in this data return\",\"\")))),\"\"))"]
["B11","C11","If any of C12, C13, C14, C16 and C17 are not blank then C11 should not be blank | if Post-order case and C12, C13, C14, C16, C17 are all blank, then C11 should be in this reporting year | If not blank, check entry is a date, is after AO and is not in the future","=IF(K6=\"\",IF(OR(R6=\"Post\",COUNT(L6:N6,Q6)>0),\"Date is missing, please add it\",\"\"),IF(OR(K6>TODAY(),NOT(ISNUMBER(K6))),\"Please enter a valid date\",IF(K6<J6,\"Contact date cannot be before Date of AO - please correct either C10 or C11\",IF(AND(R6=\"Post\",COUNT(L6:N6,P6:Q6)=0,OR(K6<SDate,K6>RDate)),\"Date of contact is outside the reporting period, so this record should not be included in this data return\",IF(K6>RDate,\"Date of contact is after the reporting period, so this record should ont be included in this data record\",\"\")))))"]
["B12","C12","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(L6=\"\",IF(COUNT(M6:N6,Q6)>0,\"Date is missing, please add it\",\"\"),IF(OR(L6>TODAY(),NOT(ISNUMBER(L6))),\"Please enter a valid date\",IF(L6<K6,\"Allocation date cannot be before Contact - please correct either C11 or C12\",\"\")))"]
["B13","C13","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(M6=\"\",IF(COUNT(N6,Q6)>0,\"Date is missing, please add it\",\"\"),IF(OR(M6>TODAY(),NOT(ISNUMBER(M6))),\"Please enter a valid date\",IF(M6<L6,\"Assessment start date cannot be before allocation date - please correct either C12 or C13\",\"\")))"]
["B14","C14","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(N6=\"\",IF(COUNT(Q6)>0,\"Date is missing, please add it\",\"\"),IF(OR(N6>TODAY(),NOT(ISNUMBER(N6))),\"Please enter a valid date\",IF(N6<M6,\"Assessment cannot be completed before it is started - please correct either C13 or C14\",\"\")))"]
["B15","C15","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(O6=\"\",IF(OR(AND(I6<>\"\",OR(IFERROR(DATEDIF(I6,J6,\"y\"),0)>=1,IFERROR(DATEDIF(I6,RDate,\"y\"),0)>=1)),AND(N6<>\"\",OR(IFERROR(DATEDIF(N6,Q6,\"y\"),0)>=1,IFERROR(DATEDIF(N6,RDate,\"y\"),0)>=1))),\"Date appears to be missing - please record the date of review\",\"\"),IF(OR(O6>TODAY(),NOT(ISNUMBER(O6))),\"Please enter a valid date\",IF(AND(N6<>\"\",O6<N6),\"Review date cannot be before assessment was completed - please correct either C14 or C15\",IF(AND(Q6<>\"\",O6>Q6),\"Review date cannot be after case was closed - please correct either C15 or C17\",IF(AND(I6<>\"\",O6<I6),\"Review date cannot be before date of placement - please correct either C9 or C15\",IF(AND(J6<>\"\",O6>J6,I6<>\"\"),\"Review date cannot be after date of AO - please correct either C10 or C15\",\"\"))))))"]
["B16","C16","If not blank, check entry is either 0 or 1","=IF(AND(P6<>\"\",P6<>0,P6<>1),\"Please record a valid code\",\"\")"]
["B17","C17","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(Q6<>\"\",IF(OR(Q6>TODAY(),NOT(ISNUMBER(Q6))),\"Please enter a valid date\",IF(AND(O6<>\"\",ISNUMBER(O6),O6>Q6),\"Closure date cannot be earlier than the latest Review - please correct either C15 or C17\",IF(AND(K6<>\"\",ISNUMBER(K6),K6>Q6),\"Closure date cannot be earlier than the initial contact date - please correct C11 or C17\",IF(Q6<SDate,\"Case was closed before reporting period and so does not need to be included in this data return\",\"\")))),\"\")"]
["A2",null,"Time from match to case closed","=IF(AND(H6<>\"\",J6<>\"\",ISNUMBER(H6),ISNUMBER(J6)),J6-H6,\"\")"]
["A3",null,"Time from match to review","=IF(AND(H6<>\"\",O6<>\"\",ISNUMBER(H6),ISNUMBER(O6)),O6-H6,\"\")"]
["A4",null,"Case open or closed?","=IF(R6<>\"\",IF(OR(AND(R6=\"Post\",Q6<>\"\",Q6<RDate),AND(R6=\"Pre\",J6<>\"\",J6<RDate)),\"Closed\",\"Open\"),\"\")"]
["A5",null,"Time from contact to allocation","=IF(AND(K6<>\"\",L6<>\"\",ISNUMBER(K6),ISNUMBER(L6)),L6-K6,\"\")"]
["A6",null,"Time from allocation to assessment","=IF(AND(L6<>\"\",M6<>\"\",ISNUMBER(L6),ISNUMBER(M6)),M6-L6,\"\")"]
["A7",null,"Time to complete assessment","=IF(AND(M6<>\"\",N6<>\"\",ISNUMBER(M6),ISNUMBER(N6)),N6-M6,\"\")"]
["A8",null,"Time from contact to closure","=IF(AND(K6<>\"\",Q6<>\"\",ISNUMBER(K6),ISNUMBER(Q6)),Q6-K6,\"\")"]
["A9",null,"Age at report date","=IF(D6<>\"\",DATEDIF(D6,RDate,\"y\"),\"\")"]
["A10",null,"Age at AO","=IF(D6<>\"\",DATEDIF(D6,J6,\"y\"),\"\")"]
["A11",null,"Age when case closed","=IF(D6<>\"\",DATEDIF(D6,Q6,\"y\"),\"\")"]
["A12",null,"In reporting period","=NOT(OR(AND(K6<>\"\",K6>RDate),AND(Q6<>\"\",Q6<SDate)))"]

{"sheet":"Queries","index":4,"n_rows":1,"n_cols":3,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
["Contact ID","Field ID","Query"]

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

{"sheet":"Analysis","index":6,"n_rows":2,"n_cols":1,"rows_kept":2,"cut":false,"hidden":false,"merged":[]}
[{"$f":"_xlfn.XLOOKUP(Instructions!J4,Lists!$T$2:$T$7,Lists!$S$2:$S$7,\"\",0,1)","v":{"$error":"#NAME?"}}]
[{"$f":"IF(MONTH(RDate)=3,DATE(YEAR(RDate)-1,4,1),DATE(YEAR(RDate),4,1))","v":{"$error":"#NAME?"}}]