{"text_format":"1","workbook":"xlsx","n_sheets":9,"sheets":["Instructions","Input sheet","Validate","Validation summary page","ChangeLog","Summary counts","lists","Change Log","Formula"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":1,"defined_names":131,"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":30,"n_cols":12,"rows_kept":30,"cut":false,"hidden":false,"merged":[[18,5,18,6]]}
[]
[null,"Adult Social Care - Client Level Data Collection (ASC-CLD): Validation Tool"]
[]
[null,"The CLD Validation tool is experimental (beta) and we welcome all feedback for future development:",null,null,null,null,null,null,null,"agem.adultsocialcare@nhs.net"]
[null,null,null,null,null,null,null,null,"Validation Tool  V2.14",null,null,"20th April 2026"]
[null,"Version:","Release 2"]
[null,"Please use this tool to help validate the CLD data before submission to the DSCRO."]
[null,"This tool is compatible with Excel 2021 and later."]
[]
[null,"HOW TO: Steps to validate"]
[null,1,"This is a macro-enabled excel file, so please ensure you enable the functionality."]
[]
[null,2,"Open your CLD template data source, copy columns A:AX (excluding the header row) and paste values into this workbook in the Input sheet (start at cell A11)"]
[]
[null,3,"Click the 'Validate' button below to start the validation process.  The macro will take up to 15-20 minutes to run with a maximum of 120,000 rows of data "]
[null,null,"NB:  If you have data that passes row number 120,000 rows, please run subsets of the data through the tool. "]
[null,null,"TIP: The validate macro will run quicker if this is the only workbook that is open, and quicker still if other applications are closed (Word, Outlook, browser etc)."]
[]
[null,null,null,"<<< CLICK"]
[]
[null,null,"A windows message box will appear to tell you the validation has completed successfully."]
[]
[null,4,"Review the 'Validation summary page' worksheet which will give a summary of data quality broken down by each of the specific validation rules"]
[]
[null,5,"Specific records and data items that require attention can be identified in the 'Validate' worksheet."]
[null,null,"NB: The 'Validate' worksheet is static, so for any corrections to the input sheet after the tool has run, the 'Validate' worksheet will not update automatically."]
[null,null,"The validation will have to be run again, with the corrected input sheet values or with a fresh dataset pasted in."]
[]
[null,6,"Use the 'Summary counts' worksheet as a sense check.  This worksheet includes some basic statistics to summarise the dataset  "]
[null,null,"NB: The summary counts will only tally if there are no unexpected or missing values in the data."]

{"sheet":"Input sheet","index":1,"n_rows":11,"n_cols":52,"rows_kept":11,"cut":false,"hidden":false,"merged":[[7,45,8,45],[7,46,8,46],[7,47,8,47],[5,3,5,21],[5,23,5,28],[5,38,5,41],[5,45,5,47],[7,19,8,19],[7,20,8,20],[7,41,8,41],[7,42,8,42],[7,24,8,24],[5,42,5,44],[5,30,5,32],[7,38,8,38],[7,34,8,34],[3,1,3,3],[7,1,8,1],[7,2,8,2],[7,6,8,6],[7,3,8,3],[6,48,7,48],[7,49,7,51],[7,4,8,4],[7,16,8,16],[7,26,8,26],[7,27,8,27],[7,32,8,32],[7,30,8,30],[7,31,8,31],[7,39,8,39],[7,40,8,40],[7,35,8,35],[7,36,8,36],[7,37,8,37],[7,17,8,17],[7,18,8,18],[7,0,8,0],[0,0,0,4],[7,23,8,23],[5,0,5,2],[7,22,8,22],[7,11,8,11],[7,12,8,12],[7,13,8,13],[7,7,8,7],[7,8,8,8],[7,9,8,9],[7,10,8,10],[7,5,8,5],[7,14,8,14],[7,15,8,15],[2,1,2,3],[7,44,8,44],[7,43,8,43],[7,25,8,25],[7,21,8,21],[7,28,8,28],[7,29,8,29],[7,33,8,33]]}
["Adult Social Care - Client Level Data (CLD) - INPUT SHEET",null,null,null,null,null,"Spec Version"]
[null,"Mandatory","Voluntary","Remove?"]
["Summary:","Count of total data items"]
[null,{"$f":"COUNTIF(A8:AV8,\"*\")","v":48}]
[null,"IMPORTANT: Cells highlighted red contain the validation formula (columns AY:BB) - DO NOT DELETE"]
["Submission Information",null,null,"Person Details - Present on ALL rows with unique values for each data item repeated for all events relating to a person (NOT event specific)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Events (All)",null,null,null,null,null,"Events (Requests only)","Events (Assessments only)",null,null,"Carers and linked service users (Carers only)",null,null,null,null,"Events (Services only)",null,null,null,"Events (Reviews only)",null,null,"Costs (Services Only)"]
["Mandatory","Mandatory","Mandatory","Mandatory","Mandatory","Mandatory","Mandatory","Voluntary","Mandatory","Mandatory","Mandatory","Mandatory","Mandatory","Mandatory","Mandatory","Mandatory","Mandatory","Voluntary","Voluntary","Voluntary","Voluntary","Mandatory","Voluntary","Mandatory","Mandatory","Voluntary","Mandatory","Mandatory","Mandatory","Voluntary","Voluntary","Mandatory","Mandatory","Voluntary","Voluntary","Mandatory","Voluntary","Voluntary","Voluntary","Voluntary","Voluntary",null,null,null,"Mandatory",null,null,null,"Auto populated"]
["LA Code","Reporting Period Start Date","Reporting Period End Date","NHS Number","LA Person Unique Identifier","First Name","Last Name","GP Practice Code","Gender","Ethnicity","Date of Birth","Date of Death","Client Type","Primary Support Reason","Postcode","Accommodation Status","Employment Status","Has Unpaid Carer","Autism Spectrum Disorder (ASD)","Visual Impairment","Hearing Impairment","Dementia","Client Funding Status","Event Type","Event Reference","Event Start Date","Event End Date","Event Description","Event Outcome","Request: Route of Access","Assessment Type","Eligible Needs Identified","Method of Assessment","Total Hrs Caring per week","No. of adults being cared for","Adult 1 Linked Person_ID","Adult 2 Linked Person_ID","Adult 3 Linked Person_ID","Service Type","Service Component","Delivery Mechanism","Provider CQC Location ID","Review Reason","Review Outcomes Achieved","Method of Review","Unit Cost","Cost Frequency (Unit Type)","Planned units per week",null,"Do not remove"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Planned cost\nfull year\n\nSubmission year","Commitment dates"]
["Integer","dd/mm/yyyy","dd/mm/yyyy","Integer ","Integer or Alpha-numeric","Text","Text","Alpha-numeric","Defined List…","Defined List…","dd/mm/yyyy","dd/mm/yyyy","Defined List","Defined List…","Alpha-numeric","Defined List…","Defined List…","Defined List…","Defined List…","Defined List","Defined List","Defined List…","Defined List…","Defined List…","Integer or Alpha-numeric","dd/mm/yyyy","dd/mm/yyyy","Text","Defined List…","Defined List…","Defined List…","Defined List…","Defined List…","Defined List","Integer","Integer or Alpha-numeric","Integer or Alpha-numeric","Integer or Alpha-numeric","Defined List…","Defined List…","Defined List…","Alpha-numeric","Defined List…","Defined List…","Defined List…","Numeric (0.00)","Defined List…","Numeric (0.00)","Year","start","end","wks"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(IF(W11=\"18(3) (full cost client)\",0,IF(AV11>0,AT11*AV11*VLOOKUP(AU11,lists!$AX$5:$AY$13,2,FALSE),IF(AN11<0,AT11*VLOOKUP(AU11,lists!$AX$5:$AY$13,2,FALSE),IF(AV11=0,AT11*VLOOKUP(AU11,lists!$AX$5:$AY$13,2,FALSE)))))*(AZ11*100/52)/100,\"\")","v":""},{"$f":"IF(B11=\"\", \"\", IF(Z11<B11,B11,IF(Z11>B11,Z11,B11)))","v":""},{"$f":"IF(C11=\"\", \"\", IF(AA11=\"\",C11,IF(AA11>C11,C11,AA11)))","v":""},{"$f":"IFERROR(ROUND(DATEDIF(AX11,AY11,\"d\")/7.000384,0)+1,\"Event not open during reporting period\")","v":"Event not open during reporting period"}]

{"sheet":"Validate","index":2,"n_rows":11,"n_cols":104,"rows_kept":11,"cut":false,"hidden":false,"merged":[[6,45,6,47],[6,0,6,2],[0,0,0,4],[6,3,6,21],[6,23,6,28],[6,38,6,41],[6,30,6,32],[6,42,6,44]]}
["Adult Social Care - Client Level Data (CLD) - VALIDATE",null,null,null,null,null,"Spec Version","Release 2"]
[]
[]
[]
[]
[null,"IMPORTANT: Cells highlighted red contain the validation formula (row 11) - DO NOT DELETE "]
["Submission Information",null,null,"Person Details - Present on ALL rows with unique values for each data item repeated for all events relating to a person (NOT event specific)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Events (All)",null,null,null,null,null,"Events (Requests only)","Events (Assessments only)",null,null,"Carers and linked service users (Carers only)",null,null,null,null,"Events (Services only)",null,null,null,"Events (Reviews only)",null,null,"Costs (Services Only)"]
["Mandatory","Mandatory","Mandatory","Mandatory","Mandatory","Mandatory","Mandatory","Voluntary","Mandatory","Mandatory","Mandatory","Mandatory","Mandatory","Mandatory","Mandatory","Mandatory","Mandatory","Voluntary","Voluntary","Voluntary","Voluntary","Mandatory","Voluntary","Mandatory","Mandatory","Voluntary","Mandatory","Mandatory","Mandatory","Voluntary","Voluntary","Mandatory","Mandatory","Voluntary","Voluntary","Mandatory","Voluntary","Voluntary","Voluntary","Voluntary",null,null,null,null,"Mandatory",null,null,"Voluntary"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"LA Code ","Reporting Period Start Date","Reporting Period End Date","NHS Number","LA Person Unique Identifier","First Name","Last Name","GP Practice Code","Gender","Ethnicity","Date of Birth","Date of Death","Client Type","Primary Support Reason","Postcode","Accommodation Status","Employment Status","Has Unpaid Carer","Autism Spectrum Disorder (ASD)","Visual Impairment","Hearing Impairment","Dementia","Client Funding Status","Event Type","Event Reference","Event Start Date","Event End Date","Event Description","Event Outcome","Request: Route of Access","Assessment Type","Eligible Needs Identified","Method of Assessment","Total Hrs Caring per week","No. of adults being cared for","Adult 1 Linked Person_ID","Adult 2 Linked Person_ID","Adult 3 Linked Person_ID","Service Type","Service Component","Delivery Mechanism","Provider CQC Location ID","Review Reason","Review Outcomes Achieved","Method of Review","Unit Cost","Cost Frequency (Unit Type)","Planned units per week"]
["LA Code","Reporting Period Start Date","Reporting Period End Date","NHS Number","LA Person Unique Identifier","First Name","Last Name","GP Practice Code","Gender","Ethnicity","Date of Birth","Date of Death","Client Type","Primary Support Reason","Postcode","Accommodation Status","Employment Status","Has Unpaid Carer","Autism Spectrum Disorder (ASD)","Visual Impairment","Hearing Impairment","Dementia","Client Funding Status","Event Type","Event Reference","Event Start Date","Event End Date","Event Description","Event Outcome","Request: Route of Access","Assessment Type","Eligible Needs Identified","Method of Assessment","Total Hrs Caring per week","No. of adults being cared for","Adult 1 Linked Person_ID","Adult 2 Linked Person_ID","Adult 3 Linked Person_ID","Service Type","Service Component","Delivery Mechanism","Provider CQC Location ID","Review Reason","Review Outcomes Achieved","Method of Review","Unit Cost","Cost Frequency (Unit Type)","Planned units per week",null,"Column A","Column B","Column  C","Column  D","Column  E","Column F","Column G","Column H","Column I","Column J","Column K","Column L","Column M","Column N","Column O","Column P","Column Q","Column R","Column S","Column T","Column U","Column V","Column W","Column X","Column Y","Column Z","Column AA","Column AB","Column AC","Column AD","Column AE","Column AF","Column AG","Column AH","Column AI","Column AJ","Column AK","Column AL","Column AM","Column AN","Column AO","Column AP","Column AQ","Column AR","Column AS","Column AT","Column AU","Column AV",null,"Age\n\nat end date of reporting period","Age Band\n\non end date of event","LTS005","Event active during submission period","Row Validated = P\nELSE\nValidation count","Acceptable by DLP"]
[{"$f":"IF('Input sheet'!A11=\"\",\"\",'Input sheet'!A11)","v":""},{"$f":"IF('Input sheet'!B11=\"\",\"\",'Input sheet'!B11)","v":""},{"$f":"IF('Input sheet'!C11=\"\",\"\",'Input sheet'!C11)","v":""},{"$f":"IF('Input sheet'!D11=\"\",\"\",'Input sheet'!D11)","v":""},{"$f":"IF('Input sheet'!E11=\"\",\"\",'Input sheet'!E11)","v":""},{"$f":"IF('Input sheet'!F11=\"\",\"\",'Input sheet'!F11)","v":""},{"$f":"IF('Input sheet'!G11=\"\",\"\",'Input sheet'!G11)","v":""},{"$f":"IF('Input sheet'!H11=\"\",\"\",'Input sheet'!H11)","v":""},{"$f":"IF('Input sheet'!I11=\"\",\"\",'Input sheet'!I11)","v":""},{"$f":"IF('Input sheet'!J11=\"\",\"\",'Input sheet'!J11)","v":""},{"$f":"IF('Input sheet'!K11=\"\",\"\",'Input sheet'!K11)","v":""},{"$f":"IF('Input sheet'!L11=\"\",\"\",'Input sheet'!L11)","v":""},{"$f":"IF('Input sheet'!M11=\"\",\"\",'Input sheet'!M11)","v":""},{"$f":"IF('Input sheet'!N11=\"\",\"\",'Input sheet'!N11)","v":""},{"$f":"IF('Input sheet'!O11=\"\",\"\",'Input sheet'!O11)","v":""},{"$f":"IF('Input sheet'!P11=\"\",\"\",'Input sheet'!P11)","v":""},{"$f":"IF('Input sheet'!Q11=\"\",\"\",'Input sheet'!Q11)","v":""},{"$f":"IF('Input sheet'!R11=\"\",\"\",'Input sheet'!R11)","v":""},{"$f":"IF('Input sheet'!S11=\"\",\"\",'Input sheet'!S11)","v":""},{"$f":"IF('Input sheet'!T11=\"\",\"\",'Input sheet'!T11)","v":""},{"$f":"IF('Input sheet'!U11=\"\",\"\",'Input sheet'!U11)","v":""},{"$f":"IF('Input sheet'!V11=\"\",\"\",'Input sheet'!V11)","v":""},{"$f":"IF('Input sheet'!W11=\"\",\"\",'Input sheet'!W11)","v":""},{"$f":"IF('Input sheet'!X11=\"\",\"\",'Input sheet'!X11)","v":""},{"$f":"IF('Input sheet'!Y11=\"\",\"\",'Input sheet'!Y11)","v":""},{"$f":"IF('Input sheet'!Z11=\"\",\"\",'Input sheet'!Z11)","v":""},{"$f":"IF('Input sheet'!AA11=\"\",\"\",'Input sheet'!AA11)","v":""},{"$f":"IF('Input sheet'!AB11=\"\",\"\",'Input sheet'!AB11)","v":""},{"$f":"IF('Input sheet'!AC11=\"\",\"\",'Input sheet'!AC11)","v":""},{"$f":"IF('Input sheet'!AD11=\"\",\"\",'Input sheet'!AD11)","v":""},{"$f":"IF('Input sheet'!AE11=\"\",\"\",'Input sheet'!AE11)","v":""},{"$f":"IF('Input sheet'!AF11=\"\",\"\",'Input sheet'!AF11)","v":""},{"$f":"IF('Input sheet'!AG11=\"\",\"\",'Input sheet'!AG11)","v":""},{"$f":"IF('Input sheet'!AH11=\"\",\"\",'Input sheet'!AH11)","v":""},{"$f":"IF('Input sheet'!AI11=\"\",\"\",'Input sheet'!AI11)","v":""},{"$f":"IF('Input sheet'!AJ11=\"\",\"\",'Input sheet'!AJ11)","v":""},{"$f":"IF('Input sheet'!AK11=\"\",\"\",'Input sheet'!AK11)","v":""},{"$f":"IF('Input sheet'!AL11=\"\",\"\",'Input sheet'!AL11)","v":""},{"$f":"IF('Input sheet'!AM11=\"\",\"\",'Input sheet'!AM11)","v":""},{"$f":"IF('Input sheet'!AN11=\"\",\"\",'Input sheet'!AN11)","v":""},{"$f":"IF('Input sheet'!AO11=\"\",\"\",'Input sheet'!AO11)","v":""},{"$f":"IF('Input sheet'!AP11=\"\",\"\",'Input sheet'!AP11)","v":""},{"$f":"IF('Input sheet'!AQ11=\"\",\"\",'Input sheet'!AQ11)","v":""},{"$f":"IF('Input sheet'!AR11=\"\",\"\",'Input sheet'!AR11)","v":""},{"$f":"IF('Input sheet'!AS11=\"\",\"\",'Input sheet'!AS11)","v":""},{"$f":"IF('Input sheet'!AT11=\"\",\"\",'Input sheet'!AT11)","v":""},{"$f":"IF('Input sheet'!AU11=\"\",\"\",'Input sheet'!AU11)","v":""},{"$f":"IF('Input sheet'!AV11=\"\",\"\",'Input sheet'!AV11)","v":""},null,{"$f":"_xlfn.IFS(\nE11=\"\", \"\",\nA11=\"\", \"MV\",\nLEN(A11)>5, \"RL\",\nTRUE, \"P\"\n)","v":""},{"$f":"_xlfn.IFS(\nA11=\"\", \"\",\nNOT(ISERROR(DATEVALUE(TEXT(B11,\"dd/mm/yyyy\")))), \"P\",\nAND(B11<>\"\", ISERROR(DATEVALUE(TEXT(B11,\"dd/mm/yyyy\")))), \"UV\",\nAND(A11<>\"\", B11=\"\"), \"MV\",\nTRUE, \"check\"\n)","v":""},{"$f":"_xlfn.IFS(\n    A11=\"\", \"\",\n    NOT(ISERROR(DATEVALUE(TEXT(C11, \"dd/mm/yyyy\")))), \"P\",\n    AND(C11<>\"\", ISERROR(DATEVALUE(TEXT(C11, \"dd/mm/yyyy\")))), \"UV\",\n    AND(A11<>\"\", C11=\"\"), \"MV\",\n    TRUE, \"check\"\n)","v":""},{"$f":"_xlfn.IFS(\nA11=\"\", \"\",\nLEN(D11)>10, \"RL\",\nAND(ISNUMBER(D11), LEN(D11)=10), \"P\",\nD11=\"\", \"MV\",\nISTEXT(D11), \"UV\",\nTRUE, \"UV\"\n)","v":""},{"$f":"_xlfn.IFS(\nA11=\"\", \"\",\nLEN(E11)>10, \"RL\",\nE11=\"\", \"MV\",\nTRUE, \"P\"\n)","v":""},{"$f":"_xlfn.IFS(\nA11=\"\", \"\",\nLEN(F11)>85, \"RL\",\nF11=\"\", \"MV\",\nISTEXT(F11), \"P\",\nISNUMBER(F11), \"UV\"\n)","v":""},{"$f":"_xlfn.IFS(\nA11=\"\", \"\",\nLEN(G11)>85, \"RL\",\nG11=\"\", \"MV\",\nOR(G11 = TRUE,ISTEXT(G11)), \"P\",\nISNUMBER(G11), \"UV\"\n)","v":""},{"$f":"_xlfn.IFS(\nLEN(H11)>10, \"RL\",\nTRUE, \"\"\n)","v":""},{"$f":"IFERROR(\n_xlfn.IFS(\nA11=\"\", \"\",\nLEN(I11)>7, \"RL\",\nI11=\"\", \"MV\",\n_xlfn.XLOOKUP(TRUE, EXACT(I11, lists!$I$4:$I$29), lists!$I$4:$I$29)=I11, \"P\"\n),\n\"UV\"\n)","v":""},{"$f":"IFERROR(\n_xlfn.IFS(\nA11=\"\", \"\",\nLEN(J11)>98, \"RL\",\nJ11=\"\", \"MV\",\n_xlfn.XLOOKUP(TRUE, EXACT(J11, lists!$J$4:$J$29), lists!$J$4:$J$29)=J11, \"P\"\n),\n\"UV\"\n)","v":""},{"$f":"_xlfn.IFS(\nA11=\"\", \"\",\nNOT(ISERROR(DATEVALUE(TEXT(K11, \"dd/mm/yyyy\")))), \"P\",\nAND(K11<>\"\", ISERROR(DATEVALUE(TEXT(K11, \"dd/mm/yyyy\")))), \"UV\",\nAND(A11<>\"\", K11=\"\"\n), \"MV\",\nTRUE, \"check\"\n)","v":""},{"$f":"_xlfn.IFS(\nL11=\"\", \"\",\nNOT(ISERROR(DATEVALUE(TEXT(L11, \"dd/mm/yyyy\")))), \"P\",\nAND(L11<>\"\", ISERROR(DATEVALUE(TEXT(L11, \"dd/mm/yyyy\")))), \"UV\",\nTRUE, \"\"\n)","v":""},{"$f":"IFERROR(\n_xlfn.IFS(\nA11=\"\", \"\",\nLEN(M11)>33, \"RL\",\nM11=\"\", \"MV\",\n _xlfn.XLOOKUP(TRUE, EXACT(M11, lists!$M$4:$M$29), lists!$M$4:$M$29)=M11, \"P\"\n),\n\"UV\"\n)","v":""},{"$f":"IFERROR(\n_xlfn.IFS(\nOR(A11=\"\", X11=\"\",X11=\"Request\",X11=\"Funded\"), \"\",\nLEN(N11)>60, \"RL\",\nN11=\"\", \"MV\",\n_xlfn.XLOOKUP(TRUE, EXACT(N11, lists!$N$4:$N$29), lists!$N$4:$N$29) = N11, \"P\"\n),\n\"UV\"\n)","v":""},{"$f":"_xlfn.IFS(\nA11=\"\", \"\",\nLEN(O11)>9, \"RL\",\nO11=\"\", \"MV\",\nO11<>\"\", \"P\"\n)","v":""},{"$f":"IFERROR(\n_xlfn.IFS(\nA11=\"\", \"\",\nLEN(P11)>83, \"RL\",\nCW11=\"\", \"\",\nAND(CW11=\"LTS004\", P11=\"\"), \"CS\",\nAND(CW11=\"LTS004\", _xlfn.XLOOKUP(TRUE, EXACT(P11, lists!$P$4:$P$29), lists!$P$4:$P$29) = P11), \"P\"\n),\n\"UV\"\n)","v":""},{"$f":"IFERROR(\n_xlfn.IFS(\nA11=\"\", \"\",\nLEN(Q11)>60, \"RL\",\nCW11=\"\", \"\",\nAND(CW11=\"LTS004\", P11=\"\"), \"CS\",\nAND(CW11=\"LTS004\", _xlfn.XLOOKUP(TRUE, EXACT(Q11, lists!$Q$4:$Q$29), lists!$Q$4:$Q$29) = Q11), \"P\"\n),\n\"UV\"\n)","v":""},{"$f":"IFERROR(\n_xlfn.IFS(\nA11=\"\", \"\",\nLEN(R11)>7, \"RL\",\nR11=\"\", \"MV\",\n_xlfn.XLOOKUP(TRUE, EXACT(R11, lists!$R$4:$R$29), lists!$R$4:$R$29) = R11, \"P\"),\n\"UV\"\n)","v":""},{"$f":"IFERROR(\n_xlfn.IFS(\nS11=\"\", \"\",\nLEN(S11)>7, \"RL\",\n_xlfn.XLOOKUP(TRUE, EXACT(S11, lists!$S$4:$S$29), lists!$S$4:$S$29) = S11, \"P\"\n),\n\"UV\"\n)","v":""},{"$f":"IFERROR(\n_xlfn.IFS(\nT11=\"\", \"\",\nLEN(T11)>36, \"RL\",\n_xlfn.XLOOKUP(TRUE, EXACT(T11, lists!$T$4:$T$29), lists!$T$4:$T$29) = T11, \"P\"\n),\n\"UV\"\n)","v":""},{"$f":"IFERROR(\n_xlfn.IFS(\nU11=\"\", \"\",\nLEN(U11)>37, \"RL\",\n_xlfn.XLOOKUP(TRUE, EXACT(U11, lists!$U$4:$U$29), lists!$U$4:$U$29) = U11, \"P\"\n),\n\"UV\"\n)","v":""},{"$f":"IFERROR(\n_xlfn.IFS(\nA11=\"\", \"\",\nLEN(V11)>7, \"RL\",\nV11=\"\", \"\",\n_xlfn.XLOOKUP(TRUE, EXACT(V11, lists!$V$4:$V$29), lists!$V$4:$V$29) = V11, \"P\" ),\n\"UV\"\n)","v":""},{"$f":"IFERROR(\n_xlfn.IFS(\nOR(A11=\"\", X11=\"\",X11=\"Request\",X11=\"Funded\"), \"\",\nW11=\"\", \"MV\",\nLEN(W11)>35, \"RL\",\n_xlfn.XLOOKUP(TRUE, EXACT(W11, lists!$W$4:$W$29), lists!$W$4:$W$29) = W11, \"P\"\n),\n\"UV\"\n)","v":""},{"$f":"IFERROR(\n_xlfn.IFS(\nAND(X11=\"\", M11=\"Unpaid carer known by association\"), \"\",\nA11=\"\", \"\",\nLEN(X11)>10, \"RL\",\nX11=\"\", \"MV\",\n_xlfn.XLOOKUP(TRUE, EXACT(X11, lists!$X$4:$X$29), lists!$X$4:$X$29) = X11, \"P\"\n),\n\"UV\"\n)","v":""},null,{"$f":"_xlfn.IFS(\nAND(Z11=\"\", EXACT(M11, \"Unpaid carer known by association\")), \"\",\nA11=\"\", \"\",\nZ11=\"\", \"MV\",\nISTEXT(Z11), \"UV\",\nISNUMBER(Z11), \"P\"\n)","v":""},{"$f":"_xlfn.IFS(\nAND(AA11=\"\", EXACT(M11, \"Unpaid carer known by association\")), \"\",\nA11=\"\", \"\",\nAND(AA11=\"\", X11=\"Service\"), \"\",\nAND(AA11=\"\", NOT(X11=\"Service\")), \"ES\",\nISTEXT(AA11), \"UV\",\nISNUMBER(AA11), \"P\"\n)","v":""},null,{"$f":"IFERROR(\n_xlfn.IFS(\nOR(EXACT(AE11, \"Financial assessment\"), AND(AC11 = \"\", EXACT(M11, \"Unpaid carer known by association\"))), \"\",\nA11= \"\", \"\",\nAA11 = \"\", \"\",\nLEN(AC11) > 100, \"RL\",\nAC11 = \"\", \"MV\",\n_xlfn.XLOOKUP(TRUE, EXACT(AC11, lists!$AC$4:$AC$29), lists!$AC$4:$AC$29) = AC11, \"P\"\n), \"UV\")","v":""},{"$f":"IFERROR(_xlfn.IFS(\nAND(AD11=\"\", EXACT(M11, \"Unpaid carer known by association\")), \"\",\nA11=\"\", \"\",\nLEN(AD11)>43, \"RL\",\nAND(AD11<>\"\", X11<>\"Request\"), \"ES\",\nAND(AD11=\"\", EXACT(X11, \"Request\")), \"MV\",\nAND(AD11=\"\", X11<>\"Request\"), \"\",\nAND(X11=\"Request\", _xlfn.XLOOKUP(TRUE, EXACT(AD11, lists!$AD$4:$AD$29), lists!$AD$4:$AD$29) = AD11), \"P\",\nTRUE, \"UV\"\n),\"UV\")","v":""},{"$f":"IFERROR(\n_xlfn.IFS(\nOR(AND(X11<>\"Assessment\", AE11=\"\"), AND(AE11=\"\", EXACT(M11, \"Unpaid carer known by association\"))), \"\",\nA11=\"\", \"\",\nLEN(AE11)>21, \"RL\",\nX11<>\"Assessment\", \"ES\",\nAND(EXACT(X11, \"Assessment\"), AE11=\"\"), \"MV\",\nAND(EXACT(X11, \"Assessment\"), _xlfn.XLOOKUP(TRUE, EXACT(AE11, lists!$AE$4:$AE$29), lists!$AE$4:$AE$29) = AE11), \"P\"\n),\"UV\")","v":""},{"$f":"IFERROR(\n    _xlfn.IFS(\n    LEN(AF11)>29, \"RL\",\n    A11=\"\", \"\",\n    AND(AF11=\"\", EXACT(M11, \"Unpaid carer known by association\")), \"\",\n    AND(AF11=\"\", EXACT(X11, \"Assessment\")), \"MV\",\n    AND(EXACT(AF11, \"Long Term Assessment\"), X11<>\"Assessment\"), \"\",\n    AND(AF11=\"\", X11<>\"Assessment\"), \"\",\n    AND(AF11<>\"\", X11<>\"Assessment\"), \"ES\",\n    _xlfn.XLOOKUP(TRUE, EXACT(AF11, lists!$AF$4:$AF$29), lists!$AF$4:$AF$29) = AF11,\"P\",\nTRUE,\"UV\"\n),\n\"UV\")","v":""},{"$f":"IFERROR(_xlfn.IFS(\nLEN(AG11)>29, \"RL\",\nA11=\"\", \"\",\nAND(AG11=\"\", OR(EXACT(AE11, \"Financial assessment\"), EXACT(M11, \"Unpaid carer known by association\"))), \"\",\nAND(AG11<>\"\", AE11<>\"Financial assessment\",M11<>\"Unpaid carer known by association\",X11<>\"Assessment\"),\"\",\nX11<>\"Assessment\", \"\",\n_xlfn.XLOOKUP(TRUE, EXACT(AG11, lists!$AG$4:$AG$29), lists!$AG$4:$AG$29) = AG11, \"P\",\nTRUE,\"UV\"),\"UV\")","v":""},{"$f":"IFERROR(\n_xlfn.IFS(\nAH11=\"\", \"\",\nA11=\"\", \"\",\nLEN(AH11)>23, \"RL\",\nAH11=\"*\",\"UV\",\nAND(OR(EXACT(M11, \"Carer\"), EXACT(M11, \"Unpaid carer known by association\")), _xlfn.XLOOKUP(TRUE, EXACT(AH11, lists!$AH$4:$AH$29), lists!$AH$4:$AH$29) = AH11), \"P\",\nTRUE, \"\"\n),\n\"UV\")","v":""},{"$f":"_xlfn.IFS(\nISNUMBER(AI11),\"P\",\nTRUE, \"\"\n)","v":""},{"$f":"_xlfn.IFS(\nLEN(AJ11)>32,\"RL\",\nTRUE,\"\"\n)","v":""},{"$f":"_xlfn.IFS(\nLEN(AK11)>32,\"RL\",\nTRUE,\"\"\n)","v":""},{"$f":"_xlfn.IFS(\nLEN(AL11)>64,\"RL\",\nTRUE,\"\"\n)","v":""},{"$f":"_xlfn.IFS(\nA11=\"\", \"\",\nLEN(AM11)>60, \"RL\",\nAND(NOT(AM11=\"\"), X11<>\"Service\"), \"ES\",\nAND(AM11=\"\", EXACT(X11, \"Service\")), \"MV\",\nAND(AM11=\"\", X11<>\"Service\"), \"\",\nAND(EXACT(X11, \"Service\"), IFERROR(_xlfn.XLOOKUP(TRUE, EXACT(AM11, lists!$AM$4:$AM$29), lists!$AM$4:$AM$29) = AM11, FALSE)), \"P\",\nTRUE, \"UV\"\n)","v":""},{"$f":"_xlfn.IFS(\nA11=\"\", \"\",\nLEN(AN11)>41, \"RL\",\nAND(NOT(AN11=\"\"), X11<>\"Service\"), \"ES\",\nAND(AN11=\"\", EXACT(X11, \"Service\")), \"MV\",\nAND(AN11=\"\", X11<>\"Service\"), \"\",\nAND(EXACT(X11, \"Service\"), IFERROR(_xlfn.XLOOKUP(TRUE, EXACT(AN11, lists!$AN$4:$AN$29), lists!$AN$4:$AN$29) = AN11, FALSE)), \"P\",\nTRUE, \"UV\"\n)","v":""},{"$f":"_xlfn.IFS(\nAO11=\"\", \"\",\nA11=\"\", \"\",\nLEN(AO11)>29, \"RL\",\nIFERROR(_xlfn.XLOOKUP(TRUE, EXACT(AO11, lists!$AO$4:$AO$29), lists!$AO$4:$AO$29) = AO11, FALSE), \"P\",\nTRUE, \"UV\"\n)","v":""},{"$f":"IFERROR(IF(LEN(AP11)>18,\"RL\",\"\"),\"UV\")","v":""},{"$f":"_xlfn.IFS(\nA11=\"\", \"\",\nLEN(AQ11)>52, \"RL\",\nOR(AND(AQ11<>\"\", X11<>\"Review\"),AND(AQ11=\"\", EXACT(X11, \"Review\"))), \"ES\",\nAND(AQ11=\"\", X11<>\"Review\"), \"\",\nAND(EXACT(X11, \"Review\"), IFERROR(_xlfn.XLOOKUP(TRUE, EXACT(AQ11, lists!$AQ$4:$AQ$29), lists!$AQ$4:$AQ$29) = AQ11, FALSE)), \"P\",\nTRUE, \"UV\"\n)","v":""},{"$f":"IFERROR(_xlfn.IFS(\nA11=\"\", \"\",\nLEN(AR11)>14, \"RL\",\nAND(EXACT(X11, \"Review\"),AND(AR11=\"\", LEFT(AQ11, 7)=\"Planned\")), \"ES\",\nAND(EXACT(X11, \"Review\"),IFERROR(_xlfn.XLOOKUP(TRUE, EXACT(AR11, lists!$AR$4:$AR$29), lists!$AR$4:$AR$29) = AR11, FALSE)), \"P\",\nTRUE,\"\"\n),\"UV\")","v":""},{"$f":"_xlfn.IFS(\nA11=\"\", \"\",\nLEN(AS11)>29, \"RL\",\nOR(AND(X11<>\"\", X11<>\"Review\", AS11<>\"\"), AND(EXACT(X11, \"Review\"), AS11=\"\", AC11<>\"Progress to assessment, review or reassessment\")), \"ES\",\nAS11=\"\", \"\",\nIFERROR(_xlfn.XLOOKUP(TRUE, EXACT(AS11, lists!$AS$4:$AS$29), lists!$AS$4:$AS$29)=AS11,FALSE), \"P\",\nTRUE, \"UV\"\n)","v":""},{"$f":"_xlfn.IFS(\nA11=\"\", \"\",\nAND(EXACT(X11, \"Service\"), ISNUMBER(AT11)), \"P\",\nAND(EXACT(X11, \"Service\"), AT11=\"\"), \"P\",\nAND(X11<>\"Service\", NOT(AT11=\"\")), \"ES\",\nAND(X11<>\"Service\", AT11=\"\"), \"\",\nTRUE, \"UV\"\n)","v":""},{"$f":"_xlfn.IFS(\nAT11=\"\", \"\",\nLEN(AU11)>11, \"RL\",\nA11=\"\", \"\",\nAND(EXACT(X11, \"Service\"),AU11=\"\"),\"MV\",\nAND(EXACT(X11, \"Service\"),IFERROR(_xlfn.XLOOKUP(TRUE, EXACT(AU11, lists!$AU$4:$AU$29), lists!$AU$4:$AU$29) = AU11,FALSE)), \"P\",\nAND(EXACT(X11, \"Service\"),ISERROR(_xlfn.XLOOKUP(TRUE, EXACT(AU11, lists!$AU$4:$AU$29), lists!$AU$4:$AU$29))), \"UV\",\nTRUE, \"\")","v":""},{"$f":"_xlfn.IFS(A11=\"\", \"\",\nAND(EXACT(X11, \"Service\"),\nAU11 <> \"Per session\", AU11 <> \"Hourly\", AU11 <> \"Daily\"\n), \"P\",\nAND(NOT(EXACT(M11, \"Unpaid carer known by association\")),\nEXACT(X11, \"Service\"),\nAV11=\"\"\n), \"ES\",\nAND(EXACT(X11, \"Service\"),\nNOT(EXACT(LEFT(AO11, 26), \"CASSR commissioned support\")),\nOR(EXACT(AU11, \"Per session\"), EXACT(AU11, \"Hourly\"), EXACT(AU11, \"Daily\")),\nOR(EXACT(LEFT(AM11, 9), \"Long term\"), EXACT(LEFT(AM11, 20), \"Unpaid carer support\")),\nOR(EXACT(AN11, \"Short term residential care\"), EXACT(AN11, \"Short term nursing care\"), EXACT(AN11, \"Unpaid carer respite\")),\nAV11<>\"\"\n), \"P\",\nAND(EXACT(X11, \"Service\"),\nNOT(EXACT(LEFT(AO11, 26), \"CASSR commissioned support\")),\nOR(EXACT(AU11, \"Per session\"), EXACT(AU11, \"Hourly\"), EXACT(AU11, \"Daily\")),\nOR(EXACT(LEFT(AM11, 9), \"Long term\"), EXACT(LEFT(AM11, 20), \"Unpaid carer support\")),\nOR(EXACT(AN11, \"Short term residential care\"), EXACT(AN11, \"Short term nursing care\"), EXACT(AN11, \"Unpaid carer respite\")),\nAV11=\"\"\n), \"MV\",\nTRUE, \"P\"\n)","v":""},null,{"$f":"IF(K11=\"\",\"\",(DATEDIF(K11,C11,\"y\")))","v":""},{"$f":"IFERROR(VLOOKUP(DATEDIF(K11,Z11,\"y\"),lists!BE:BF,2,FALSE),\"\")","v":""},{"$f":"IF(AND(N11=lists!$N$10,Validate!CV11=\"18-64\"),\"LTS004\",\"\")","v":""},{"$f":"IF(A11=\"\",\"\",(IF(Z11=\"\",\"Missing Value [Event start date]\",(IF(ISTEXT(Z11),\"Unexpected Value [Event start date]\",(IF(AND(Z11<=C11,AA11=\"\"),\"Event Active\",(IF(ISTEXT(AA11),\"Unexpected Value [Event end date]\",(IF(AND(Z11<=C11,AA11>=B11),\"Event Active\",\"Event not active\")))))))))))","v":""},{"$f":"IF(A11=\"\",\"\",(IF(COUNTIFS(AX11:CS11,\"MV\")+(COUNTIFS(AX11:CS11,\"UV\")+(COUNTIFS(AX11:CS11,\"ES\")+(COUNTIFS(AX11:CS11,\"Event Not Active\")+(COUNTIFS(AX11:CS11,\"FALSE\")+(COUNTIFS(AX11:CS11,\"N/A\"))))))=0,\"P\",(COUNTIFS(AX11:CS11,\"MV\")+(COUNTIFS(AX11:CS11,\"UV\")+(COUNTIFS(AX11:CS11,\"ES\")+(COUNTIFS(AX11:CS11,\"Validation Check on Hold [Event Not Active]\")+(COUNTIFS(AX11:CS11,\"FALSE\")+(COUNTIFS(AX11:CS11,\"N/A\"))))))))))","v":""},{"$f":"NOT(OR(A11=\"\",B11=\"\", C11=\"\", E11=\"\"))","v":false}]

{"sheet":"Validation summary page","index":3,"n_rows":150,"n_cols":8,"rows_kept":150,"cut":false,"hidden":false,"merged":[[2,1,2,6],[16,1,16,6],[0,0,0,6],[5,1,5,7]]}
["Adult Social Care - Client Level Data (CLD): Validation Summary"]
[]
[null,"Validation rules apply for to both mandatory and voluntary data items that LAs have supplied data for."]
[null,"If LAs have not supplied data for the voluntary data items then the validation rules will not apply."]
[]
[null,"Summary of all primary validation rules"]
[]
[null,"Validation Type","No. of validation  rules","No. of items\ntriggered"]
[null,"Missing Value",{"$f":"COUNTIF(E:E,B9)","v":33},{"$f":"SUM(G20:G52)","v":0},{"$f":"IF(Validate!$A$11=\"\",\"\",IF(D9=0,\"PASS\",\"CHECK\"))","v":""},"Total rows that have passed validation",{"$f":"COUNTIF(Validate!CY:CY,\"P\")","v":0},"P"]
[null,"Restricted Length",{"$f":"COUNTIF(E:E,B10)","v":37},{"$f":"SUM(G53:G89)","v":0},{"$f":"IF(Validate!$A$11=\"\",\"\",IF(D10=0,\"PASS\",\"CHECK\"))","v":""},"Total rows with at least one validation rule triggered",{"$f":"COUNTIF(Validate!CY:CY,\">=1\")","v":0}]
[null,"Unexpected Value",{"$f":"COUNTIF(E:E,B11)","v":42},{"$f":"SUM(G90:G131)","v":0},{"$f":"IF(Validate!$A$11=\"\",\"\",IF(D11=0,\"PASS\",\"CHECK\"))","v":""},"Total rows submitted",{"$f":"SUM(G9:G10)","v":0},1]
[null,"Event Specific",{"$f":"COUNTIF(E:E,B12)","v":14},{"$f":"SUM(G132:G145)","v":0},{"$f":"IF(Validate!$A$11=\"\",\"\",IF(D12=0,\"PASS\",\"CHECK\"))","v":""},"Total rows acceptable by DLP",{"$f":"COUNTIF(Validate!CZ:CZ, TRUE)","v":0}]
[null,"Cohort Specific",{"$f":"COUNTIF(E:E,B13)","v":2},{"$f":"SUM(G146:G147)","v":0},{"$f":"IF(Validate!$A$11=\"\",\"\",IF(D13=0,\"PASS\",\"CHECK\"))","v":""}]
[]
[null,"Total Validation rules",{"$f":"SUM(C9:C13)","v":128},{"$f":"SUM(D9:D13)","v":0},{"$f":"IF(Validate!$A$11=\"\",\"\",IF(D15=0,\"PASS\",\"CHECK\"))","v":""},{"$f":"IF(G12<>G11,\"Submission would be rejected by DLP\",\"\")","v":""}]
[]
[null,"Breakdown by validation Type and Data Item"]
[]
[null,"Data Item No","Data item Descriptor","Validation Code","Validation Type","Validation Rule","Count by Validation Type","LA notes"]
[null,"01","LA Code",{"$f":"\"MV - \" & B20","v":"MV - 01"},"Missing Value",{"$f":"CONCATENATE(\"Missing - a value for \",C20,\" should be recorded for every row of data submitted\")","v":"Missing - a value for LA Code should be recorded for every row of data submitted"},{"$f":"COUNTIF(Validate!AX11:$AX$200000,\"MV\")","v":0}]
[null,"02","Reporting Period Start Date",{"$f":"\"MV - \" & B21","v":"MV - 02"},"Missing Value","Missing - a value for Reporting Period Start Date should be recorded for every row of data submitted",{"$f":"COUNTIF(Validate!AY11:$AY$200000,\"MV\")","v":0}]
[null,"03","Reporting Period End Date","MV - 03","Missing Value","Missing - a value for Reporting Period End Date should be recorded for every row of data submitted",{"$f":"COUNTIF(Validate!AZ11:$AZ$200000,\"MV\")","v":0}]
[null,"04","NHS Number","MV - 04","Missing Value","Missing - a value for NHS Number should be recorded for every row of data submitted",{"$f":"COUNTIF(Validate!BA11:$BA$200000,\"MV\")","v":0}]
[null,"05","LA Person Unique Identifier","MV - 05","Missing Value","Missing - a value for LA Person Unique Identifier should be recorded for every row of data submitted",{"$f":"COUNTIF(Validate!BB11:$BB$200000,\"MV\")","v":0}]
[null,"06","First Name","MV - 06","Missing Value","Missing - a value for First Name should be recorded for every row of data submitted",{"$f":"COUNTIF(Validate!BC11:$BC$200000,\"MV\")","v":0}]
[null,"07","Last Name","MV - 07","Missing Value","Missing - a value for Last Name should be recorded for every row of data submitted",{"$f":"COUNTIF(Validate!BD11:$BD$200000,\"MV\")","v":0}]
[null,"10","Gender","MV - 10","Missing Value","Missing - a value for Gender should be recorded for every row of data submitted",{"$f":"COUNTIF(Validate!BF11:$BF$200000,\"MV\")","v":0}]
[null,"11","Ethnicity","MV - 11","Missing Value","Missing - a value for Ethnicity should be recorded for every row of data submitted",{"$f":"COUNTIF(Validate!BG11:$BG$200000,\"MV\")","v":0}]
[null,"12","Date of Birth","MV - 12","Missing Value","Missing - a value for Date of Birth should be recorded for every row of data submitted",{"$f":"COUNTIF(Validate!BH11:$BH$200000,\"MV\")","v":0}]
[null,13,"Date of Death","MV - 13","Missing Value","Missing - a value for Date of Death should be recorded for every row of data submitted",{"$f":"COUNTIF(Validate!BI11:$BI$200000,\"MV\")","v":0}]
[null,14,"Client Type","MV - 14","Missing Value","Missing - a value for Client Type should be recorded for every row of data submitted",{"$f":"COUNTIF(Validate!BJ11:$BJ$200000,\"MV\")","v":0}]
[null,15,"Primary Support Reason","MV - 15","Missing Value","Missing - a value for Primary Support Reason should be recorded for every row of data submitted",{"$f":"COUNTIF(Validate!BK11:$BK$200000,\"MV\")","v":0}]
[null,16,"Postcode","MV - 16","Missing Value","Missing - a value for Postcode should be recorded for every row of data submitted",{"$f":"COUNTIF(Validate!BL11:$BL$200000,\"MV\")","v":0}]
[null,17,"Accommodation Status","MV - 17","Missing Value","Missing - a value for Accommodation Status should be recorded for every row of data submitted",{"$f":"COUNTIF(Validate!BM11:$BM$200000,\"MV\")","v":0}]
[null,18,"Employment Status","MV - 18","Missing Value","Missing - a value for Employment Status should be recorded for every row of data submitted",{"$f":"COUNTIF(Validate!BN11:$BN$200000,\"MV\")","v":0}]
[null,19,"Has Unpaid Carer","MV - 19","Missing Value","Missing - a value for Has Unpaid Carer should be recorded for every row of data submitted",{"$f":"COUNTIF(Validate!BO11:$BO$200000,\"MV\")","v":0}]
[null,24,"Client Funding Status","MV - 24","Missing Value","Missing - a value for Client Funding Status should be recorded for every row of data submitted",{"$f":"COUNTIF(Validate!BT11:$BT$200000,\"MV\")","v":0}]
[null,25,"Event Type","MV - 25","Missing Value","Missing - a value for Event Type should be recorded for every row of data submitted",{"$f":"COUNTIF(Validate!BU11:$BU$200000,\"MV\")","v":0}]
[null,27,"Event Start Date","MV - 27","Missing Value","Missing - a value for Event Start Date should be recorded for every row of data submitted",{"$f":"COUNTIF(Validate!BW11:$BW$200000,\"MV\")","v":0}]
[null,28,"Event End Date","MV - 28","Missing Value","Missing - a value for Event End Date should be recorded for every row of data submitted",{"$f":"COUNTIF(Validate!BX11:$BX$200000,\"MV\")","v":0}]
[null,30,"Event Outcome","MV - 30","Missing Value","Missing - a value for Event Outcome should be recorded for every row of data submitted that has a Event End Date",{"$f":"COUNTIF(Validate!BZ11:$BZ$200000,\"MV\")","v":0}]
[null,31,"Request: Route of Access","MV - 31","Missing Value","Missing - a value for Request: Route of Access should be recorded for every row of data submitted",{"$f":"COUNTIF(Validate!CA11:$CA$200000,\"MV\")","v":0}]
[null,32,"Assessment Type","MV - 32","Missing Value","Missing - a value for Assessment Type should be recorded for every row of data submitted",{"$f":"COUNTIF(Validate!CB11:$CB$200000,\"MV\")","v":0}]
[null,34,"Method of Assessment","MV - 34","Missing Value","Missing - a value for Method of Assessment should be recorded for every row of data submitted",{"$f":"COUNTIF(Validate!CD11:$CD$200000,\"MV\")","v":0}]
[null,40,"Service Type","MV - 40","Missing Value","Missing - a value for Service Type should be recorded for every row of data submitted",{"$f":"COUNTIF(Validate!CJ11:$CJ$200000,\"MV\")","v":0}]
[null,41,"Service Component","MV - 41","Missing Value","Missing - a value for Service Component should be recorded for every row of data submitted",{"$f":"COUNTIF(Validate!CK11:$CK$200000,\"MV\")","v":0}]
[null,45,"Review Reason","MV - 45","Missing Value","Missing - a value for Review Reason should be recorded for every row of data submitted",{"$f":"COUNTIF(Validate!CN11:$CN$200000,\"MV\")","v":0}]
[null,46,"Review Outcomes Achieved","MV - 46","Missing Value","Missing - a value for Review Outcomes Achieved should be recorded for every row of data submitted",{"$f":"COUNTIF(Validate!CO11:$CO$200000,\"MV\")","v":0}]
[null,47,"Method of Review",{"$f":"\"MV - \" & B49","v":"MV - 47"},"Missing Value",{"$f":"CONCATENATE(\"Missing - a value for \",C49,\" should be recorded for every row of data submitted\")","v":"Missing - a value for Method of Review should be recorded for every row of data submitted"},{"$f":"COUNTIF(Validate!CP11:$CP$200000,\"MV\")","v":0}]
[null,48,"Unit Cost","MV - 48","Missing Value","Missing - a value for Delivery mechanism should be recorded for community and prison service types.",{"$f":"COUNTIF(Validate!CQ11:$CQ$200000,\"MV\")","v":0}]
[null,49,"Cost Frequency (Unit Type)","MV - 49","Missing Value","Missing - a value should be recorded for every Service row that has a Unit Cost",{"$f":"COUNTIF(Validate!CR11:$CR$200000,\"MV\")","v":0}]
[null,50,"Planned units \nper week","MV - 50","Missing Value","Missing - a value should be recorded for every Service row that has a Unit Cost (note. Planned units per week should be blank where Cost Frequency is weekly or less frequently)",{"$f":"COUNTIF(Validate!CS11:$CS$200000,\"MV\")","v":0}]
[null,"01","LA Code ",{"$f":"\"RL - \" & B53","v":"RL - 01"},"Restricted Length","Restricted Length - the value should be no longer than the defined length",{"$f":"COUNTIF(Validate!AX11:$AX$200000,\"RL\")","v":0}]
[null,"04","NHS Number",{"$f":"\"RL - \" & B54","v":"RL - 04"},"Restricted Length","Restricted Length - the value should be no longer than the defined length",{"$f":"COUNTIF(Validate!BA11:$BA$200000,\"RL\")","v":0}]
[null,"05","LA Person Unique Identifier","RL - 05","Restricted Length","Restricted Length - the value should be no longer than the defined length",{"$f":"COUNTIF(Validate!BB11:$BB$200000,\"RL\")","v":0}]
[null,"06","First Name","RL - 06","Restricted Length","Restricted Length - the value should be no longer than the defined length",{"$f":"COUNTIF(Validate!BC11:$BC$200000,\"RL\")","v":0}]
[null,"07","Last Name","RL - 07","Restricted Length","Restricted Length - the value should be no longer than the defined length",{"$f":"COUNTIF(Validate!BD11:$BD$200000,\"RL\")","v":0}]
[null,"09","GP Practice Code","RL - 09","Restricted Length","Restricted Length - the value should be no longer than the defined length",{"$f":"COUNTIF(Validate!BE11:$BE$200000,\"RL\")","v":0}]
[null,"10","Gender","RL - 10","Restricted Length","Restricted Length - the value should be no longer than the defined length",{"$f":"COUNTIF(Validate!BF11:$BF$200000,\"RL\")","v":0}]
[null,"11","Ethnicity","RL - 11","Restricted Length","Restricted Length - the value should be no longer than the defined length",{"$f":"COUNTIF(Validate!BG11:$BG$200000,\"RL\")","v":0}]
[null,"14","Client Type","RL - 14","Restricted Length","Restricted Length - the value should be no longer than the defined length",{"$f":"COUNTIF(Validate!BJ11:$BJ$200000,\"RL\")","v":0}]
[null,"15","Primary Support Reason","RL - 15","Restricted Length","Restricted Length - the value should be no longer than the defined length",{"$f":"COUNTIF(Validate!BK11:$BK$200000,\"RL\")","v":0}]
[null,"16","Postcode","RL - 16","Restricted Length","Restricted Length - the value should be no longer than the defined length",{"$f":"COUNTIF(Validate!BL11:$BL$200000,\"RL\")","v":0}]
[null,"17","Accommodation Status","RL - 17","Restricted Length","Restricted Length - the value should be no longer than the defined length",{"$f":"COUNTIF(Validate!BM11:$BM$200000,\"RL\")","v":0}]
[null,"18","Employment Status","RL - 18","Restricted Length","Restricted Length - the value should be no longer than the defined length",{"$f":"COUNTIF(Validate!BN11:$BN$200000,\"RL\")","v":0}]
[null,"19","Has Unpaid Carer","RL - 19","Restricted Length","Restricted Length - the value should be no longer than the defined length",{"$f":"COUNTIF(Validate!BO11:$BO$200000,\"RL\")","v":0}]
[null,"20","Autism Spectrum Disorder (ASD)","RL - 20","Restricted Length","Restricted Length - the value should be no longer than the defined length",{"$f":"COUNTIF(Validate!BP11:$BP$200000,\"RL\")","v":0}]
[null,"21","Visual Impairment","RL - 21","Restricted Length","Restricted Length - the value should be no longer than the defined length",{"$f":"COUNTIF(Validate!BQ11:$BQ$200000,\"RL\")","v":0}]
[null,"22","Hearing Impairment","RL - 22","Restricted Length","Restricted Length - the value should be no longer than the defined length",{"$f":"COUNTIF(Validate!BR11:$BR$200000,\"RL\")","v":0}]
[null,"23","Dementia","RL - 23","Restricted Length","Restricted Length - the value should be no longer than the defined length",{"$f":"COUNTIF(Validate!BS11:$BS$200000,\"RL\")","v":0}]
[null,"24","Client Funding Status","RL - 24","Restricted Length","Restricted Length - the value should be no longer than the defined length",{"$f":"COUNTIF(Validate!BT11:$BT$200000,\"RL\")","v":0}]
[null,"25","Event Type","RL - 25","Restricted Length","Restricted Length - the value should be no longer than the defined length",{"$f":"COUNTIF(Validate!BU11:$BU$200000,\"RL\")","v":0}]
[null,"30","Event Outcome","RL - 30","Restricted Length","Restricted Length - the value should be no longer than the defined length",{"$f":"COUNTIF(Validate!BZ11:$BZ$200000,\"RL\")","v":0}]
[null,"31","Request: Route of Access","RL - 31","Restricted Length","Restricted Length - the value should be no longer than the defined length",{"$f":"COUNTIF(Validate!CA11:$CA$200000,\"RL\")","v":0}]
[null,"32","Assessment Type","RL - 32","Restricted Length","Restricted Length - the value should be no longer than the defined length",{"$f":"COUNTIF(Validate!CB11:$CB$200000,\"RL\")","v":0}]
[null,"33","Eligible Needs Identified","RL - 33","Restricted Length","Restricted Length - the value should be no longer than the defined length",{"$f":"COUNTIF(Validate!CC11:$CC$200000,\"RL\")","v":0}]
[null,"34","Method of Assessment","RL - 34","Restricted Length","Restricted Length - the value should be no longer than the defined length",{"$f":"COUNTIF(Validate!CD11:$CD$200000,\"RL\")","v":0}]
[null,"35","Total Hrs Caring per week","RL - 35","Restricted Length","Restricted Length - the value should be no longer than the defined length",{"$f":"COUNTIF(Validate!CE11:$CE$200000,\"RL\")","v":0}]
[null,"37","Adult 1 Linked Person_ID","RL - 37","Restricted Length","Restricted Length - the value should be no longer than the defined length",{"$f":"COUNTIF(Validate!CG12:$CG$200000,\"RL\")","v":0}]
[null,"38","Adult 2 Linked Person_ID","RL - 38","Restricted Length","Restricted Length - the value should be no longer than the defined length",{"$f":"COUNTIF(Validate!CH13:$CH$200000,\"RL\")","v":0}]
[null,"39","Adult 3 Linked Person_ID","RL - 39","Restricted Length","Restricted Length - the value should be no longer than the defined length",{"$f":"COUNTIF(Validate!CI14:$CI$200000,\"RL\")","v":0}]
[null,"40","Service Type","RL - 40","Restricted Length","Restricted Length - the value should be no longer than the defined length",{"$f":"COUNTIF(Validate!CJ11:$CJ$200000,\"RL\")","v":0}]
[null,"41","Service Component","RL - 41","Restricted Length","Restricted Length - the value should be no longer than the defined length",{"$f":"COUNTIF(Validate!CK11:$CK$200000,\"RL\")","v":0}]
[null,"42","Delivery Mechanism","RL - 42","Restricted Length","Restricted Length - the value should be no longer than the defined length",{"$f":"COUNTIF(Validate!CL11:$CL$200000,\"RL\")","v":0}]
[null,"44","Provider CQC Location ID","RL - 44","Restricted Length","Restricted Length - the value should be no longer than the defined length",{"$f":"COUNTIF(Validate!CM12:$CM$200000,\"RL\")","v":0}]
[null,"45","Review Reason","RL - 45","Restricted Length","Restricted Length - the value should be no longer than the defined length",{"$f":"COUNTIF(Validate!CN11:$CN$200000,\"RL\")","v":0}]
[null,"46","Review Outcomes Achieved","RL - 46","Restricted Length","Restricted Length - the value should be no longer than the defined length",{"$f":"COUNTIF(Validate!CO11:$CO$200000,\"RL\")","v":0}]
[null,"47","Method of Review","RL - 47","Restricted Length","Restricted Length - the value should be no longer than the defined length",{"$f":"COUNTIF(Validate!CP11:$CP$200000,\"RL\")","v":0}]
[null,"49","Cost Frequency (Unit Type)","RL - 49","Restricted Length","Restricted Length - the value should be no longer than the defined length",{"$f":"COUNTIF(Validate!CR11:$CR$200000,\"RL\")","v":0}]
[null,"01","LA Code",{"$f":"\"UV - \" & B90","v":"UV - 01"},"Unexpected Value","Unexpected Value - the value should be in the appropriate format or one of the defined values in the list",{"$f":"COUNTIF(Validate!AX11:$AX$200000,\"UV\")","v":0}]
[null,"02","Reporting Period Start Date",{"$f":"\"UV - \" & B91","v":"UV - 02"},"Unexpected Value","Unexpected Value - the value should be in the appropriate format or one of the defined values in the list",{"$f":"COUNTIF(Validate!AY11:$AY$200000,\"UV\")","v":0}]
[null,"03","Reporting Period End Date","UV - 03","Unexpected Value","Unexpected Value - the value should be in the appropriate format or one of the defined values in the list",{"$f":"COUNTIF(Validate!AZ11:$AZ$200000,\"UV\")","v":0}]
[null,"04","NHS Number","UV - 04","Unexpected Value","Unexpected Value - the value should be in the appropriate format or one of the defined values in the list",{"$f":"COUNTIF(Validate!BA11:$BA$200000,\"UV\")","v":0}]
[null,"05","LA Person Unique Identifier","UV - 05","Unexpected Value","Unexpected Value - the value should be in the appropriate format or one of the defined values in the list",{"$f":"COUNTIF(Validate!BB11:$BB$200000,\"UV\")","v":0}]
[null,"06","First Name","UV - 06","Unexpected Value","Unexpected Value - the value should be in the appropriate format or one of the defined values in the list",{"$f":"COUNTIF(Validate!BC11:$BC$200000,\"UV\")","v":0}]
[null,"07","Last Name","UV - 07","Unexpected Value","Unexpected Value - the value should be in the appropriate format or one of the defined values in the list",{"$f":"COUNTIF(Validate!BD11:$BD$200000,\"UV\")","v":0}]
[null,"10","Gender","UV - 10","Unexpected Value","Unexpected Value - the value should be in the appropriate format or one of the defined values in the list",{"$f":"COUNTIF(Validate!BF11:$BF$200000,\"UV\")","v":0}]
[null,"11","Ethnicity","UV - 11","Unexpected Value","Unexpected Value - the value should be in the appropriate format or one of the defined values in the list",{"$f":"COUNTIF(Validate!BG11:$BG$200000,\"UV\")","v":0}]
[null,"12","Date of Birth","UV - 12","Unexpected Value","Unexpected Value - the value should be in the appropriate format or one of the defined values in the list",{"$f":"COUNTIF(Validate!BH11:$BH$200000,\"UV\")","v":0}]
[null,"13","Date of Death","UV - 13","Unexpected Value","Unexpected Value - the value should be in the appropriate format or one of the defined values in the list",{"$f":"COUNTIF(Validate!BI11:$BI$200000,\"UV\")","v":0}]
[null,14,"Client Type","UV - 14","Unexpected Value","Unexpected Value - the value should be in the appropriate format or one of the defined values in the list",{"$f":"COUNTIF(Validate!BJ11:$BJ$200000,\"UV\")","v":0}]
[null,15,"Primary Support Reason","UV - 15","Unexpected Value","Unexpected Value - the value should be in the appropriate format or one of the defined values in the list",{"$f":"COUNTIF(Validate!BK11:$BK$200000,\"UV\")","v":0}]
[null,"16","Postcode","UV - 16","Unexpected Value","Unexpected Value - the value should be in the appropriate format or one of the defined values in the list",{"$f":"COUNTIF(Validate!BL11:$BL$200000,\"UV\")","v":0}]
[null,"17","Accommodation Status","UV - 17","Unexpected Value","Unexpected Value - the value should be in the appropriate format or one of the defined values in the list",{"$f":"COUNTIF(Validate!BM11:$BM$200000,\"UV\")","v":0}]
[null,"18","Employment Status","UV - 18","Unexpected Value","Unexpected Value - the value should be in the appropriate format or one of the defined values in the list",{"$f":"COUNTIF(Validate!BN11:$BN$200000,\"UV\")","v":0}]
[null,"19","Has Informal Carer","UV - 19","Unexpected Value","Unexpected Value - the value should be in the appropriate format or one of the defined values in the list",{"$f":"COUNTIF(Validate!BO11:$BO$200000,\"UV\")","v":0}]
[null,"20","Autism Spectrum Disorder (ASD)","UV - 20","Unexpected Value","Unexpected Value - the value should be in the appropriate format or one of the defined values in the list",{"$f":"COUNTIF(Validate!BP11:$BP$200000,\"UV\")","v":0}]
[null,"21","Visual Impairment","UV - 21","Unexpected Value","Unexpected Value - the value should be in the appropriate format or one of the defined values in the list",{"$f":"COUNTIF(Validate!BQ11:$BQ$200000,\"UV\")","v":0}]
[null,"22","Hearing Impairment","UV - 22","Unexpected Value","Unexpected Value - the value should be in the appropriate format or one of the defined values in the list",{"$f":"COUNTIF(Validate!BR11:$BR$200000,\"UV\")","v":0}]
[null,"23","Dementia","UV - 23","Unexpected Value","Unexpected Value - the value should be in the appropriate format or one of the defined values in the list",{"$f":"COUNTIF(Validate!BS11:$BS$200000,\"UV\")","v":0}]
[null,"24","Client Funding Status","UV - 24","Unexpected Value","Unexpected Value - the value should be in the appropriate format or one of the defined values in the list",{"$f":"COUNTIF(Validate!BT11:$BT$200000,\"UV\")","v":0}]
[null,25,"Event Type","UV - 25","Unexpected Value","Unexpected Value - the value should be in the appropriate format or one of the defined values in the list",{"$f":"COUNTIF(Validate!BU11:$BU$200000,\"UV\")","v":0}]
[null,27,"Event Start Date","UV - 27","Unexpected Value","Unexpected Value - the value should be in the appropriate format or one of the defined values in the list",{"$f":"COUNTIF(Validate!BW11:$BW$200000,\"UV\")","v":0}]
[null,28,"Event End Date","UV - 28","Unexpected Value","Unexpected Value - the value should be in the appropriate format or one of the defined values in the list",{"$f":"COUNTIF(Validate!BX11:$BX$200000,\"UV\")","v":0}]
[null,29,"Event Description","UV - 29","Unexpected Value","Unexpected Value - the value should be in the appropriate format or one of the defined values in the list",{"$f":"COUNTIF(Validate!BY11:$BY$200000,\"UV\")","v":0}]
[null,30,"Event Outcome","UV - 30","Unexpected Value","Unexpected Value - the value should be in the appropriate format or one of the defined values in the list",{"$f":"COUNTIF(Validate!BZ11:$BZ$200000,\"UV\")","v":0}]
[null,31,"Request: Route of Access","UV - 31","Unexpected Value","Unexpected Value - the value should be in the appropriate format or one of the defined values in the list",{"$f":"COUNTIF(Validate!CA11:$CA$200000,\"UV\")","v":0}]
[null,32,"Assessment Type","UV - 32","Unexpected Value","Unexpected Value - the value should be in the appropriate format or one of the defined values in the list",{"$f":"COUNTIF(Validate!CB11:$CB$200000,\"UV\")","v":0}]
[null,33,"Eligible Needs Identified","UV - 33","Unexpected Value","Unexpected Value - the value should be in the appropriate format or one of the defined values in the list",{"$f":"COUNTIF(Validate!CC11:$CC$200000,\"UV\")","v":0}]
[null,34,"Method of Assessment","UV - 34","Unexpected Value","Unexpected Value - the value should be in the appropriate format or one of the defined values in the list",{"$f":"COUNTIF(Validate!CD11:$CD$200000,\"UV\")","v":0}]
[null,35,"Total Hrs Caring per week","UV - 35","Unexpected Value","Unexpected Value - the value should be in the appropriate format or one of the defined values in the list",{"$f":"COUNTIF(Validate!CE11:$CE$200000,\"UV\")","v":0}]
[null,40,"Service Type","UV - 40","Unexpected Value","Unexpected Value - the value should be in the appropriate format or one of the defined values in the list",{"$f":"COUNTIF(Validate!CJ11:$CJ$200000,\"UV\")","v":0}]
[null,41,"Service Component","UV - 41","Unexpected Value","Unexpected Value - the value should be in the appropriate format or one of the defined values in the list",{"$f":"COUNTIF(Validate!CK11:$CK$200000,\"UV\")","v":0}]
[null,42,"Delivery Mechanism","UV - 42","Unexpected Value","Unexpected Value - the value should be in the appropriate format or one of the defined values in the list",{"$f":"COUNTIF(Validate!CL11:$CL$200000,\"UV\")","v":0}]
[null,44,"Provider CQC Location ID","UV - 44","Unexpected Value","Unexpected Value - the value should be in the appropriate format or one of the defined values in the list","n/a"]
[null,45,"Review Reason","UV - 45","Unexpected Value","Unexpected Value - the value should be in the appropriate format or one of the defined values in the list",{"$f":"COUNTIF(Validate!CN11:$CN$200000,\"UV\")","v":0}]
[null,46,"Review Outcomes Achieved","UV - 46","Unexpected Value","Unexpected Value - the value should be in the appropriate format or one of the defined values in the list",{"$f":"COUNTIF(Validate!CO11:$CO$200000,\"UV\")","v":0}]
[null,47,"Method of Review",{"$f":"\"UV - \" & B128","v":"UV - 47"},"Unexpected Value","Unexpected Value - the value should be in the appropriate format or one of the defined values in the list",{"$f":"COUNTIF(Validate!CP11:$CP$200000,\"UV\")","v":0}]
[null,48,"Unit Cost","UV - 48","Unexpected Value","Unexpected Value - the value should be in the appropriate format or one of the defined values in the list",{"$f":"COUNTIF(Validate!CQ11:$CQ$200000,\"UV\")","v":0}]
[null,49,"Cost Frequency (Unit Type)","UV - 49","Unexpected Value","Unexpected Value - the value should be in the appropriate format or one of the defined values in the list",{"$f":"COUNTIF(Validate!CR11:$CR$200000,\"UV\")","v":0}]
[null,50,"Planned units \nper week","UV - 50","Unexpected Value","Unexpected Value - the value should be in the appropriate format or one of the defined values in the list",{"$f":"COUNTIF(Validate!CS11:$CS$200000,\"UV\")","v":0}]
[null,28,"Event End Date",{"$f":"\"ES - \" & B132","v":"ES - 28"},"Event Specific","Event specific - only service events can be blank",{"$f":"COUNTIF(Validate!BX11:$BX$200000,\"ES\")","v":0}]
[null,30,"Event Outcome",{"$f":"\"ES - \" & B133","v":"ES - 30"},"Event Specific","Event specific - not all event outcomes relate to all events, please check","n/a"]
[null,31,"Request: Route of Access","ES - 31","Event Specific","Event specific - Route of access only required for Request events",{"$f":"COUNTIF(Validate!CA11:$CA$200000,\"ES\")","v":0}]
[null,32,"Assessment Type","ES - 32","Event Specific","Event Specific - Assessment Type is only required for Assessment Events",{"$f":"COUNTIF(Validate!CB11:$CB$200000,\"ES\")","v":0}]
[null,33,"Eligible Needs Identified","ES - 33","Event Specific","Event Specific - Eligible Needs Identified is only required for Assessment Events",{"$f":"COUNTIF(Validate!CC11:$CC$200000,\"ES\")","v":0}]
[null,40,"Service Type","ES - 40","Event Specific","Event Specific - Service Type is only required for Service Events",{"$f":"COUNTIF(Validate!CJ11:$CJ$200000,\"ES\")","v":0}]
[null,41,"Service Component","ES - 41","Event Specific","Event Specific - Service Component ie only rvquirvd for Service Comp Evente",{"$f":"COUNTIF(Validate!CK11:$CK$200000,\"ES\")","v":0}]
[null,42,"Delivery Mechanism","ES - 42","Event Specific","Event Specific - Delivery Mechanism is only required for Service Events AND where Service Type = Community: Long Term Support, or Prison: Long Term Support",{"$f":"COUNTIF(Validate!CL11:$CL$200000,\"ES\")","v":0}]
[null,44,"Provider CQC Location ID","ES - 44","Event Specific","Event Specific - Provider CQC Location ID is only required for Service Events","n/a"]
[null,45,"Review Reason","ES - 45","Event Specific","Event Specific - Review Reason is only required for Review Events",{"$f":"COUNTIF(Validate!CN11:$CN$200000,\"ES\")","v":0}]
[null,46,"Review Outcomes Achieved","ES - 46","Event Specific","Event specific - Review Outcomes Achieved is only required for Review Events",{"$f":"COUNTIF(Validate!CO11:$CO$200000,\"ES\")","v":0}]
[null,48,"Unit Cost","ES - 48","Event Specific","Event Specific - Unit Cost (£) - is required for Service Events ONLY for Long Term Support, STS Residential and STS Nursing. \n(note. not required, Unit costs for CASSR Commissioned Support Services)",{"$f":"COUNTIF(Validate!CQ11:$CQ$200000,\"ES\")","v":0}]
[null,49,"Cost Frequency (Unit Type)","ES - 49","Event Specific","Event Specific - Cost Frequency - only required for Service Events rows with a  Unit Cost",{"$f":"COUNTIF(Validate!CR11:$CR$200000,\"ES\")","v":0}]
[null,50,"Planned units \nper week","ES - 50","Event Specific","Event Specific - Planned units per week only required for Service Events rows with a unit cost. \n(note. Planned units per week should be blank where Cost Frequency is weekly or less frequently)",{"$f":"COUNTIF(Validate!CS11:$CS$200000,\"ES\")","v":0}]
[null,17,"Accommodation Status",{"$f":"\"CS - \" & B146","v":"CS - 17"},"Cohort specific","Cohort specific - Accommodation Status is only required where the PSR = Learning Disability Support AND age group = 18 to 64 at the end of the reporting period",{"$f":"COUNTIF(Validate!BM11:$BM$200000,\"CS\")","v":0}]
[null,18,"Employment Status",{"$f":"\"CS - \" & B147","v":"CS - 18"},"Cohort specific","Cohort specific - Employment Status is only required where the PSR = Learning Disability Support AND age group = 18 to 64 at the end of the reporting period",{"$f":"COUNTIF(Validate!BN11:$BN$200000,\"CS\")","v":0}]
[null,null,null,null,null,"Total",{"$f":"SUM(G20:G147)","v":0}]
["Notes:"," CQC Location Name and ID currently not included as a validation rule"]
[null,"Event outcome is likely to include 'event specific' validation in the future where certain values can be chosen for different event tyes, but at present these rules have been turned off."]

{"sheet":"ChangeLog","index":4,"n_rows":8,"n_cols":2,"rows_kept":8,"cut":false,"hidden":true,"merged":[]}
["Version","Change"]
[1.25,"Incorporated changelog"]
[1.25,"NHS number validation: remove P for text, check length is 10"]
[1.25,"Date columns on validate tab set to date format"]
[1.25,"Mandate on Dementia Status column removed"]
[1.25,"Summary counts on Service Component expanded"]
[1.25,"Method of Review validation altered to ES only when not review and not blank"]
[1.27,"Method of Review validation corrected"]

{"sheet":"Summary counts","index":5,"n_rows":72,"n_cols":6,"rows_kept":72,"cut":false,"hidden":false,"merged":[[0,0,0,6],[3,6,3,8]]}
["Adult Social Care - Client Level Data (CLD): Summary counts"]
[]
[]
[]
[]
[]
[null,null,"Count of events\nby Event Type"]
[null,null,"Request",{"$f":"COUNTIF('Input sheet'!X11:X999999,C8)","v":0}]
[null,null,"Assessment",{"$f":"COUNTIF('Input sheet'!X11:X999999,C9)","v":0}]
[null,null,"Service",{"$f":"COUNTIF('Input sheet'!X11:X999999,C10)","v":0}]
[null,null,"Review",{"$f":"COUNTIF('Input sheet'!X11:X999999,C11)","v":0}]
[null,null,"Total ",{"$f":"SUM(D8:D11)","v":0}]
[]
[null,null,"NB: The table totals below for specific event types will not match the event counts above if there are validation errors. "]
[]
[null,null,"Count of Requests\nby Route of Access","Count"]
[null,null,"Community or other route",{"$f":"COUNTIF('Input sheet'!$AD$11:$AD$999999,C17)","v":0}]
[null,null,"Discharge from hospital",{"$f":"COUNTIF('Input sheet'!$AD$11:$AD$999999,C18)","v":0}]
[null,null,"Discharge from reablement",{"$f":"COUNTIF('Input sheet'!$AD$11:$AD$999999,C19)","v":0}]
[null,null,"Diversion from hospital services",{"$f":"COUNTIF('Input sheet'!$AD$11:$AD$999999,C20)","v":0}]
[null,null,"Planned transition from children’s services",{"$f":"COUNTIF('Input sheet'!$AD$11:$AD$999999,C21)","v":0}]
[null,null,"Prison",{"$f":"COUNTIF('Input sheet'!$AD$11:$AD$999999,C22)","v":0}]
[null,null,"Self-funder",{"$f":"COUNTIF('Input sheet'!$AD$11:$AD$999999,C23)","v":0}]
[null,null,"Transfer from other local authority",{"$f":"COUNTIF('Input sheet'!$AD$11:$AD$999999,C24)","v":0}]
[null,null,"Total",{"$f":"SUM(D17:D24)","v":0},{"$f":"IF(D25=D8,\"\",\"CHECK\")","v":""}]
[]
[null,null,"Count of Assessments \nby Assessment Type","Count"]
[null,null,"Financial assessment",{"$f":"COUNTIF('Input sheet'!$AE11:$AE999999,C28)","v":0}]
[null,null,"Long term assessment",{"$f":"COUNTIF('Input sheet'!$AE11:$AE999999,C29)","v":0}]
[null,null,"Short term assessment",{"$f":"COUNTIF('Input sheet'!$AE11:$AE999999,C30)","v":0}]
[null,null,"Total",{"$f":"SUM(D28:D30)","v":0},{"$f":"IF(D31=D9,\"\",\"CHECK\")","v":""}]
[]
[null,null,"Count of Services and annual gross committed cost\nby Service Component ","Count","Cost (£)"]
[null,null,"Extra care housing",{"$f":"COUNTIF('Input sheet'!$AN$11:$AN$999999,C34)","v":0},{"$f":"SUMIF('Input sheet'!$AN:$AN,'Summary counts'!C34,'Input sheet'!$AW:$AW)","v":0}]
[null,null,"Unpaid carer respite",{"$f":"COUNTIF('Input sheet'!$AN$11:$AN$999999,C35)","v":0},{"$f":"SUMIF('Input sheet'!$AN:$AN,'Summary counts'!C35,'Input sheet'!$AW:$AW)","v":0}]
[null,null,"Unpaid carer sitting service",{"$f":"COUNTIF('Input sheet'!$AN$11:$AN$999999,C36)","v":0},{"$f":"SUMIF('Input sheet'!$AN:$AN,'Summary counts'!C36,'Input sheet'!$AW:$AW)","v":0}]
[null,null,"Unpaid carer universal services",{"$f":"COUNTIF('Input sheet'!$AN$11:$AN$999999,C37)","v":0},{"$f":"SUMIF('Input sheet'!$AN:$AN,'Summary counts'!C37,'Input sheet'!$AW:$AW)","v":0}]
[null,null,"Community supported living",{"$f":"COUNTIF('Input sheet'!$AN$11:$AN$999999,C38)","v":0},{"$f":"SUMIF('Input sheet'!$AN:$AN,'Summary counts'!C38,'Input sheet'!$AW:$AW)","v":0}]
[null,null,"Day support",{"$f":"COUNTIF('Input sheet'!$AN$11:$AN$999999,C39)","v":0},{"$f":"SUMIF('Input sheet'!$AN:$AN,'Summary counts'!C39,'Input sheet'!$AW:$AW)","v":0}]
[null,null,"Direct payment",{"$f":"COUNTIF('Input sheet'!$AN$11:$AN$999999,C40)","v":0},{"$f":"SUMIF('Input sheet'!$AN:$AN,'Summary counts'!C40,'Input sheet'!$AW:$AW)","v":0}]
[null,null,"Emergency support",{"$f":"COUNTIF('Input sheet'!$AN$11:$AN$999999,C41)","v":0},{"$f":"SUMIF('Input sheet'!$AN:$AN,'Summary counts'!C41,'Input sheet'!$AW:$AW)","v":0}]
[null,null,"End of life care",{"$f":"COUNTIF('Input sheet'!$AN$11:$AN$999999,C42)","v":0},{"$f":"SUMIF('Input sheet'!$AN:$AN,'Summary counts'!C42,'Input sheet'!$AW:$AW)","v":0}]
[null,null,"Equipment",{"$f":"COUNTIF('Input sheet'!$AN$11:$AN$999999,C43)","v":0},{"$f":"SUMIF('Input sheet'!$AN:$AN,'Summary counts'!C43,'Input sheet'!$AW:$AW)","v":0}]
[null,null,"Home support or domiciliary care",{"$f":"COUNTIF('Input sheet'!$AN$11:$AN$999999,C44)","v":0},{"$f":"SUMIF('Input sheet'!$AN:$AN,'Summary counts'!C44,'Input sheet'!$AW:$AW)","v":0}]
[null,null,"Learning, education or employment support",{"$f":"COUNTIF('Input sheet'!$AN$11:$AN$999999,C45)","v":0},{"$f":"SUMIF('Input sheet'!$AN:$AN,'Summary counts'!C45,'Input sheet'!$AW:$AW)","v":0}]
[null,null,"Long term nursing care",{"$f":"COUNTIF('Input sheet'!$AN$11:$AN$999999,C46)","v":0},{"$f":"SUMIF('Input sheet'!$AN:$AN,'Summary counts'!C46,'Input sheet'!$AW:$AW)","v":0}]
[null,null,"Long term residential care",{"$f":"COUNTIF('Input sheet'!$AN$11:$AN$999999,C47)","v":0},{"$f":"SUMIF('Input sheet'!$AN:$AN,'Summary counts'!C47,'Input sheet'!$AW:$AW)","v":0}]
[null,null,"Meals",{"$f":"COUNTIF('Input sheet'!$AN$11:$AN$999999,C48)","v":0},{"$f":"SUMIF('Input sheet'!$AN:$AN,'Summary counts'!C48,'Input sheet'!$AW:$AW)","v":0}]
[null,null,"Other unpaid carer support",{"$f":"COUNTIF('Input sheet'!$AN$11:$AN$999999,C49)","v":0},{"$f":"SUMIF('Input sheet'!$AN:$AN,'Summary counts'!C49,'Input sheet'!$AW:$AW)","v":0}]
[null,null,"Other long term support",{"$f":"COUNTIF('Input sheet'!$AN$11:$AN$999999,C50)","v":0},{"$f":"SUMIF('Input sheet'!$AN:$AN,'Summary counts'!C50,'Input sheet'!$AW:$AW)","v":0}]
[null,null,"Other short term support",{"$f":"COUNTIF('Input sheet'!$AN$11:$AN$999999,C51)","v":0},{"$f":"SUMIF('Input sheet'!$AN:$AN,'Summary counts'!C51,'Input sheet'!$AW:$AW)","v":0}]
[null,null,"Professional support: Other",{"$f":"COUNTIF('Input sheet'!$AN$11:$AN$999999,C52)","v":0},{"$f":"SUMIF('Input sheet'!$AN:$AN,'Summary counts'!C52,'Input sheet'!$AW:$AW)","v":0}]
[null,null,"Professional support: Social worker",{"$f":"COUNTIF('Input sheet'!$AN$11:$AN$999999,C53)","v":0},{"$f":"SUMIF('Input sheet'!$AN:$AN,'Summary counts'!C53,'Input sheet'!$AW:$AW)","v":0}]
[null,null,"Reablement",{"$f":"COUNTIF('Input sheet'!$AN$11:$AN$999999,C54)","v":0},{"$f":"SUMIF('Input sheet'!$AN:$AN,'Summary counts'!C54,'Input sheet'!$AW:$AW)","v":0}]
[null,null,"Shared Lives",{"$f":"COUNTIF('Input sheet'!$AN$11:$AN$999999,C55)","v":0},{"$f":"SUMIF('Input sheet'!$AN:$AN,'Summary counts'!C55,'Input sheet'!$AW:$AW)","v":0}]
[null,null,"Short term nursing care",{"$f":"COUNTIF('Input sheet'!$AN$11:$AN$999999,C56)","v":0},{"$f":"SUMIF('Input sheet'!$AN:$AN,'Summary counts'!C56,'Input sheet'!$AW:$AW)","v":0}]
[null,null,"Short term residential care",{"$f":"COUNTIF('Input sheet'!$AN$11:$AN$999999,C57)","v":0},{"$f":"SUMIF('Input sheet'!$AN:$AN,'Summary counts'!C57,'Input sheet'!$AW:$AW)","v":0}]
[null,null,"Transport",{"$f":"COUNTIF('Input sheet'!$AN$11:$AN$999999,C58)","v":0},{"$f":"SUMIF('Input sheet'!$AN:$AN,'Summary counts'!C58,'Input sheet'!$AW:$AW)","v":0}]
[null,null,"Total",{"$f":"SUM(D34:D58)","v":0},{"$f":"SUM(E34:E58)","v":0},{"$f":"IF(D59=D10,\"\",\"CHECK\")","v":""}]
[]
[null,null,"Count of Reviews\nby Review Reason","Count"]
[null,null,"Planned review of long term care and support plan",{"$f":"COUNTIF('Input sheet'!$AQ$11:$AQ$999999,C62)","v":0}]
[null,null,"Review of short term support",{"$f":"COUNTIF('Input sheet'!$AQ$11:$AQ$999999,C63)","v":0}]
[null,null,"Unplanned",{"$f":"SUM(D66:D71)","v":0}]
[null,null,"Of which:"]
[null,null,"Unplanned: Unpaid carer related",{"$f":"COUNTIF('Input sheet'!$AQ$11:$AQ$999999,C66)","v":0}]
[null,null,"Unplanned: Change in commissioning arrangements",{"$f":"COUNTIF('Input sheet'!$AQ$11:$AQ$999999,C67)","v":0}]
[null,null,"Unplanned: Hospital (planned and unplanned episodes)",{"$f":"COUNTIF('Input sheet'!$AQ$11:$AQ$999999,C68)","v":0}]
[null,null,"Unplanned: Other reason",{"$f":"COUNTIF('Input sheet'!$AQ$11:$AQ$999999,C69)","v":0}]
[null,null,"Unplanned: Provider failure",{"$f":"COUNTIF('Input sheet'!$AQ$11:$AQ$999999,C70)","v":0}]
[null,null,"Unplanned: Safeguarding concern",{"$f":"COUNTIF('Input sheet'!$AQ$11:$AQ$999999,C71)","v":0}]
[null,null,"Total",{"$f":"SUM(D62:D64)","v":0},{"$f":"IF(D72=D11,\"\",\"CHECK\")","v":""}]

{"sheet":"lists","index":6,"n_rows":142,"n_cols":58,"rows_kept":142,"cut":false,"hidden":true,"merged":[[0,37,1,37],[0,21,1,21],[0,38,1,38],[0,39,1,39],[0,40,1,40],[0,32,1,32],[0,22,1,22],[0,23,1,23],[0,24,1,24],[0,25,1,25],[0,26,1,26],[0,27,1,27],[0,28,1,28],[0,29,1,29],[0,30,1,30],[0,31,1,31],[0,33,1,33],[0,34,1,34],[0,35,1,35],[0,36,1,36],[0,6,1,6],[0,7,1,7],[0,10,1,10],[0,11,1,11],[0,20,1,20],[0,12,1,12],[0,8,1,8],[0,9,1,9],[0,18,1,18],[0,19,1,19],[0,17,1,17],[0,13,1,13],[0,14,1,14],[0,15,1,15],[0,16,1,16],[0,5,1,5],[0,0,1,0],[0,1,1,1],[0,2,1,2],[0,3,1,3],[0,4,1,4],[0,47,1,47],[1,49,1,53],[0,41,1,41],[0,42,1,42],[0,43,1,43],[0,45,1,45],[0,46,1,46],[0,44,1,44]]}
["LA Code ","Reporting Period Start Date","Reporting Period End Date","NHS Number","LA Person Unique Identifier","First Name","Last Name","GP Practice Code","Gender","Ethnicity","Date of Birth","Date of Death","Client Type","Primary Support Reason","Postcode","Accommodation Status","Employment Status","Has Unpaid Carer","Autism Spectrum Disorder (ASD)","Visual Impairment","Hearing Impairment","Dementia","Client Funding Status","Event Type","Event Reference","Event Start Date","Event End Date","Event Description","Event Outcome","Request: Route of Access","Assessment Type","Eligible Needs Identified","Method of Assessment","Total Hrs Caring per week","No. of adults being cared for","Adult 1 Linked Person_ID","Adult 2 Linked Person_ID","Adult 3 Linked Person_ID","Service Type","Service Component","Delivery Mechanism","Provider CQC Location ID","Review Reason","Review Outcomes Achieved","Method of Review","Unit Cost","Cost Frequency (Unit Type)","Planned units per week",null,null,null,null,null,null,null,null,"Age","Age Band"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Do not move",null,null,null,null,null,null,0,"0-18"]
["Integer","dd/mm/yyyy","dd/mm/yyyy","Integer ","Integer or Alpha-numeric","Text","Text","Alpha-numeric","Defined List…","Defined List…","dd/mm/yyyy","dd/mm/yyyy","Defined List","Defined List…","Alpha-numeric","Defined List…","Defined List…","Defined List…","Defined List…","Defined List","Defined List","Defined List…","Defined List…","Defined List…","Integer or Alpha-numeric","dd/mm/yyyy","dd/mm/yyyy","Text","Defined List…","Defined List…","Defined List…","Defined List…","Defined List…","Defined List","Integer","Integer or Alpha-numeric","Integer or Alpha-numeric","Integer or Alpha-numeric","Defined List…","Defined List…","Defined List…","Alpha-numeric","Defined List…","Defined List…","Defined List…","Numeric (0.00)","Defined List…","Numeric (0.00)",null,"Cost Frequency","Cost frequency fraction",null,"Start Date  Reporting Period","End Date Reporting Period","End Date Reporting Year",null,1,"0-18"]
[null,null,null,null,null,null,null,null,"Female","Asian or Asian British: Any other Asian background",null,null,"Service user","Learning disability support","Unknown","Acute hospital or long term healthcare residential facility","Not in paid employment: Not actively seeking work or retired","Yes","Yes","Blind or severely sight impaired","Deaf with speech","Yes","Fully client funded","Request",null,null,null,null,"Admitted to hospital","Community or other route","Financial assessment","Eligible needs identified","Unpaid carer only","1 to 9 hours a week",null,null,null,null,"Unpaid carer support: Direct to unpaid carer","Extra care housing","CASSR commissioned support",null,"Review of short term support","Fully Met","Unpaid carer only",null,"4-weekly",null,null,"Defined List…",null,"2020/21, Q1","2020-04-01","2020-06-30","2021-03-31",null,2,"0-18"]
[null,null,null,null,null,null,null,null,"Male","Asian or Asian British: Bangladeshi",null,null,"Unknown","Mental health support",null,"Approved premises for offenders released from prison or under probation supervision","Not in paid employment: Seeking work","No","No","No visual impairment","Deaf without speech","No","Fully social care funded","Assessment",null,null,null,null,"Continuation of support or services","Discharge from hospital","Long term assessment","Non-eligible needs identified","Service user and unpaid carer","10 to 19 hours a week",null,null,null,null,"Unpaid carer support: Support involving the person cared-for","Unpaid carer respite","CASSR managed personal budget",null,"Planned review of long term care and support plan","Partially Met","Service user and unpaid carer",null,"Annually",null,null,"Per Session",52.14,"2020/21, Q2","2020-04-01","2020-09-30","2021-03-31",null,3,"0-18"]
[null,null,null,null,null,null,null,null,"Other","Asian or Asian British: Chinese",null,null,"Unpaid carer","Physical support: Access and mobility only",null,"Mobile accommodation for Gypsy, Roma and Traveller communities","Not in paid employment: Voluntary work only","Unknown","Unknown","Partial sight or sight impaired","Hard of hearing","Unknown","Joint client and social care funded","Service",null,null,null,null,"NFA: Deceased","Discharge from reablement","Short term assessment","No needs identified","Service user only","20 to 34 hours a week",null,null,null,null,"Long term support: Community","Unpaid carer sitting service","Direct payment",null,"Unplanned: Unpaid carer related","Not Met","Service user only",null,"Daily",null,null,"Hourly",52.14,"2020/21, Q3","2020-04-01","2020-12-31","2021-03-31",null,4,"0-18"]
[null,null,null,null,null,null,null,null,"Unknown","Asian or Asian British: Indian",null,null,"Unpaid carer known by association","Physical support: Personal care support",null,"Night shelter, emergency hostel or direct access hostel","Paid: 16 or more hours a week",null,null,"Unknown","No hearing impairment",null,"Unknown","Review",null,null,null,null,"NFA: Information and advice or signposting","Diversion from hospital services",null,null,null,"35 to 49 hours a week",null,null,null,null,"Long term support: Nursing care","Unpaid carer universal services",null,null,"Unplanned: Change in commissioning arrangements","Not applicable",null,null,"Fortnightly",null,null,"Weekly",52.14,"2020/21,Q4","2020-04-01","2021-03-31","2021-03-31",null,5,"0-18"]
[null,null,null,null,null,null,null,null,null,"Asian or Asian British: Pakistani",null,null,null,"Sensory support: Support for dual impairment",null,"Other temporary accommodation","Paid: Hours per week unknown",null,null,"Visual impairment: Severity unknown","Hearing impairment: Severity unknown",null,null,null,null,null,null,null,"NFA: No services offered for other reason","Planned transition from children’s services",null,null,null,"50 or more hours a week",null,null,null,null,"Long term support: Prison","Community supported living",null,null,"Unplanned: Hospital (planned and unplanned episodes)",null,null,null,"Hourly",null,null,"Fortnightly",{"$f":"52.14/2","v":26.07},"2021/22, Q1","2021-04-01","2021-06-30","2022-03-31",null,6,"0-18"]
[null,null,null,null,null,null,null,null,null,"Black, Black British, Caribbean or African: African",null,null,null,"Sensory support: Support for hearing impairment",null,"Owner occupier or shared ownership scheme","Paid: Less than 16 hours a week",null,null,null,"Unknown",null,null,null,null,null,null,null,"NFA: Other","Prison",null,null,null,null,null,null,null,null,"Long term support: Residential care","Day support",null,null,"Unplanned: Other reason",null,null,null,"Monthly",null,null,"4-weekly",{"$f":"52.14/4","v":13.035},"2021/22, Q2","2021-04-01","2021-09-30","2022-03-31",null,7,"0-18"]
[null,null,null,null,null,null,null,null,null,"Black, Black British, Caribbean or African: Any other Black, Black British or Caribbean background",null,null,null,"Sensory support: Support for visual impairment",null,"Placed in temporary accommodation by the council (inc. homelessness resettlement)","Unknown",null,null,null,null,null,null,null,null,null,null,null,"NFA: Referral to NHS services or NHS funded social care","Self-funder",null,null,null,null,null,null,null,null,"Short term support: Ongoing low level","Direct payment",null,null,"Unplanned: Provider failure",null,null,null,"One-off",null,null,"Monthly",12,"2021/22, Q3","2021-04-01","2021-12-31","2022-03-31",null,8,"0-18"]
[null,null,null,null,null,null,null,null,null,"Black, Black British, Caribbean or African: Caribbean",null,null,null,"Social support: Asylum seeker support",null,"Prison, young offenders institution or detention centre",null,null,null,null,null,null,null,null,null,null,null,null,"NFA: Referral to other service within the local authority","Transfer from other local authority",null,null,null,null,null,null,null,null,"Short term support: Other short term","Emergency support",null,null,"Unplanned: Safeguarding concern",null,null,null,"Per session",null,null,"Quarterly",4,"2021/22, Q4","2021-04-01","2022-03-31","2022-03-31",null,9,"0-18"]
[null,null,null,null,null,null,null,null,null,"Mixed or multiple ethnic groups: Any other Mixed or multiple ethnic background",null,null,null,"Social support: Substance misuse support",null,"Refuge",null,null,null,null,null,null,null,null,null,null,null,null,"NFA: Responsibility moved to another local authority","Planned transition from children's services",null,null,null,null,null,null,null,null,"Short term support: ST-Max","End of life care",null,null,null,null,null,null,"Quarterly",null,null,"Annually",1,"2022/23, Q1","2022-04-01","2022-06-30","2023-03-31",null,10,"0-18"]
[null,null,null,null,null,null,null,null,null,"Mixed or multiple ethnic groups: White and Asian",null,null,null,"Social support: Support for social isolation or other reason",null,"Registered care home",null,null,null,null,null,null,null,null,null,null,null,null,"NFA: Self-funded client or under 12wk disregard",null,null,null,null,null,null,null,null,null,null,"Equipment",null,null,null,null,null,null,"Weekly",null,null,"One-off",1,"2022/23, Q2","2022-04-01","2022-09-30","2023-03-31",null,11,"0-18"]
[null,null,null,null,null,null,null,null,null,"Mixed or multiple ethnic groups: White and Black African",null,null,null,"Social support: Support to unpaid carer",null,"Registered nursing home",null,null,null,null,null,null,null,null,null,null,null,null,"NFA: Support declined",null,null,null,null,null,null,null,null,null,null,"Home support or domiciliary care",null,null,null,null,null,null,null,null,null,null,null,"2022/23, Q3","2022-04-01","2022-12-31","2023-03-31",null,12,"0-18"]
[null,null,null,null,null,null,null,null,null,"Mixed or multiple ethnic groups: White and Black Caribbean",null,null,null,"Support with memory and cognition",null,"Rough sleeper or squatting",null,null,null,null,null,null,null,null,null,null,null,null,"NFA: Support ended as planned",null,null,null,null,null,null,null,null,null,null,"Learning, education or employment support",null,null,null,null,null,null,null,null,null,null,null,"2022/23, Q4","2022-04-01","2023-03-31","2023-03-31",null,13,"0-18"]
[null,null,null,null,null,null,null,null,null,"No data: Refused",null,null,null,"Unknown",null,"Settled mainstream housing with family or friends",null,null,null,null,null,null,null,null,null,null,null,null,"NFA: Support ended for other reason",null,null,null,null,null,null,null,null,null,null,"Long term nursing care",null,null,null,null,null,null,null,null,null,null,null,"2023/24, Q1","2023-04-01","2023-06-30","2024-03-31",null,14,"0-18"]
[null,null,null,null,null,null,null,null,null,"No data: Undeclared or not known",null,null,null,null,null,"Shared Lives scheme",null,null,null,null,null,null,null,null,null,null,null,null,"Progress to assessment, review or reassessment",null,null,null,null,null,null,null,null,null,null,"Long term residential care",null,null,null,null,null,null,null,null,null,null,null,"2023/24, Q2","2023-04-01","2023-09-30","2024-03-31",null,15,"0-18"]
[null,null,null,null,null,null,null,null,null,"Other ethnic group: Any other ethnic group",null,null,null,null,null,"Sheltered housing, extra care housing or other sheltered housing",null,null,null,null,null,null,null,null,null,null,null,null,"Progress to reablement/ST-Max",null,null,null,null,null,null,null,null,null,null,"Meals",null,null,null,null,null,null,null,null,null,null,null,"2023/24, Q3","2023-04-01","2023-12-31","2024-03-31",null,16,"0-18"]
[null,null,null,null,null,null,null,null,null,"Other ethnic group: Arab",null,null,null,null,null,"Staying with family or friends as a short term guest",null,null,null,null,null,null,null,null,null,null,null,null,"Progress to support planning or services",null,null,null,null,null,null,null,null,null,null,"Other unpaid carer support",null,null,null,null,null,null,null,null,null,null,null,"2023/24, Q4","2023-04-01","2024-03-31","2024-03-31",null,17,"0-18"]
[null,null,null,null,null,null,null,null,null,"White: Any other White background",null,null,null,null,null,"Supported accommodation, supported lodgings or supported group home",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Other long term support",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,18,"18-64"]
[null,null,null,null,null,null,null,null,null,"White: English, Welsh, Scottish, Northern Irish or British",null,null,null,null,null,"Tenant: Local authority or other social housing provider",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Other short term support",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,19,"18-64"]
[null,null,null,null,null,null,null,null,null,"White: Gypsy or Irish Traveller",null,null,null,null,null,"Tenant: Private landlord",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Professional support: Other",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,20,"18-64"]
[null,null,null,null,null,null,null,null,null,"White: Irish",null,null,null,null,null,"Unknown",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Professional support: Social worker",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,21,"18-64"]
[null,null,null,null,null,null,null,null,null,"White: Roma",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Reablement",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,22,"18-64"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Shared Lives",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,23,"18-64"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Short term nursing care",null,null,null,null,null,null,null,null,null,null,null,"Select…","Auto populated","Auto populated","Auto populated",null,24,"18-64"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Short term residential care",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,25,"18-64"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Transport",null,null,null,null,null,null,null,null,null,null,null,"Q1, 2020",null,null,null,null,26,"18-64"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Row",null,"Q2, 2020",null,null,null,null,27,"18-64"]
[null,null,null,null,null,null,null,null,null,"Tenant (including local authority, arm's length management organisations, registered social landlord, housing association)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Q4, 2023",null,null,null,11,null,"Q3, 2020",null,null,null,null,28,"18-64"]
[null,null,null,null,null,null,null,null,null,"Tenant - private landlord",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," ",null,"Q4, 2021",null,null,null,null,29,"18-64"]
[null,null,null,null,null,null,null,null,null,"Settled mainstream housing with family / friends (including flat-sharing)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Q1, 2021",null,null,null,null,30,"18-64"]
[null,null,null,null,null,null,null,null,null,"Supported accommodation / supported lodgings / supported group home (i.e. accommodation supported by staff or resident care taker)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Q2, 2021",null,null,null,null,31,"18-64"]
[null,null,null,null,null,null,null,null,null,"Shared Lives scheme",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Q3, 2021",null,null,null,null,32,"18-64"]
[null,null,null,null,null,null,null,null,null,"Approved premises for offenders released from prison or under probation supervision (e.g. probation hostel)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Q4, 2022",null,null,null,null,33,"18-64"]
[null,null,null,null,null,null,null,null,null,"Sheltered housing / extra care housing / other sheltered housing",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Q1, 2022",null,null,null,null,34,"18-64"]
[null,null,null,null,null,null,null,null,null,"Mobile accommodation for Gypsy / Roma and Traveller communities",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Q2, 2022",null,null,null,null,35,"18-64"]
[null,null,null,null,null,null,null,null,"Not living on their own or with family","Rough sleeper / squatting",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Q3, 2022",null,null,null,null,36,"18-64"]
[null,null,null,null,null,null,null,null,null,"Night shelter / emergency hostel / direct access hostel (temporary accommodation accepting self-referrals)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Q4, 2023",null,null,null,null,37,"18-64"]
[null,null,null,null,null,null,null,null,null,"Refuge",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Q1, 2023",null,null,null,null,38,"18-64"]
[null,null,null,null,null,null,null,null,null,"Placed in temporary accommodation by the council (including homelessness resettlement)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Q2, 2023",null,null,null,null,39,"18-64"]
[null,null,null,null,null,null,null,null,null,"Staying with family / friends as a short-term guest",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Q3, 2023",null,null,null,null,40,"18-64"]
[null,null,null,null,null,null,null,null,null,"Acute / long-term healthcare residential facility or hospital (e.g. NHS Independent general hospital / clinic, long-stay hospital, specialist rehabilitation / recovery hospital)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Q4, 2024",null,null,null,null,41,"18-64"]
[null,null,null,null,null,null,null,null,null,"Registered care home",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Q1, 2024",null,null,null,null,42,"18-64"]
[null,null,null,null,null,null,null,null,null,"Registered nursing home",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Q2, 2024",null,null,null,null,43,"18-64"]
[null,null,null,null,null,null,null,null,null,"Prison / Young offenders institution / detention centre",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Q3, 2024",null,null,null,null,44,"18-64"]
[null,null,null,null,null,null,null,null,null,"Other temporary accommodation",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,45,"18-64"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,46,"18-64"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,47,"18-64"]
[null,null,null,null,null,null,null,null,"Employment status",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,48,"18-64"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,49,"18-64"]
[null,null,null,null,null,null,null,null,"Employed","Paid - less than 16 hours a week",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,50,"18-64"]
[null,null,null,null,null,null,null,null,null,"Paid - 16 hours or more a week",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,51,"18-64"]
[null,null,null,null,null,null,null,null,"Not in Paid Employment","Not in Paid Employment (seeking work)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,52,"18-64"]
[null,null,null,null,null,null,null,null,null,"Not in Paid Employment (not actively seeking work/retired)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,53,"18-64"]
[null,null,null,null,null,null,null,null,"Unknown",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,54,"18-64"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,55,"18-64"]
[null,null,null,null,null,null,null,null,"Ethnicity",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,56,"18-64"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,57,"18-64"]
[null,null,null,null,null,null,null,null,"White","English/Welsh/Scottish/Northern Irish/British",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,58,"18-64"]
[null,null,null,null,null,null,null,null,null,"Irish",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,59,"18-64"]
[null,null,null,null,null,null,null,null,null,"Gypsy or Irish Traveller",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,60,"18-64"]
[null,null,null,null,null,null,null,null,null,"Any other white background",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,61,"18-64"]
[null,null,null,null,null,null,null,null,"Mixed/multiple ethnic groups","White & Black Caribbean",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,62,"18-64"]
[null,null,null,null,null,null,null,null,null,"White & Black African",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,63,"18-64"]
[null,null,null,null,null,null,null,null,null,"White & Asian",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,64,"18-64"]
[null,null,null,null,null,null,null,null,null,"Any other mixed/multiple ethnic background",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,65,"65+"]
[null,null,null,null,null,null,null,null,"Asian/Asian British","Indian",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,66,"65+"]
[null,null,null,null,null,null,null,null,null,"Pakistani",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,67,"65+"]
[null,null,null,null,null,null,null,null,null,"Bangladesh",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,68,"65+"]
[null,null,null,null,null,null,null,null,null,"Chinese",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,69,"65+"]
[null,null,null,null,null,null,null,null,null,"Any other Asian background",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,70,"65+"]
[null,null,null,null,null,null,null,null,"Black/African/Caribbean/Black British","African",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,71,"65+"]
[null,null,null,null,null,null,null,null,null,"Caribbean",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,72,"65+"]
[null,null,null,null,null,null,null,null,null,"Any other Black/African/Caribbean background",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,73,"65+"]
[null,null,null,null,null,null,null,null,"Other ethnic group","Arab",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,74,"65+"]
[null,null,null,null,null,null,null,null,null,"Other",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,75,"65+"]
[null,null,null,null,null,null,null,null,"No data","Refused",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,76,"65+"]
[null,null,null,null,null,null,null,null,null,"Undeclared/Not known",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,77,"65+"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,78,"65+"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,79,"65+"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,80,"65+"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,81,"65+"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,82,"65+"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,83,"65+"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,84,"65+"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,85,"65+"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,86,"65+"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,87,"65+"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,88,"65+"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,89,"65+"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,90,"65+"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,91,"65+"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,92,"65+"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,93,"65+"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,94,"65+"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,95,"65+"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,96,"65+"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,97,"65+"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,98,"65+"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,99,"65+"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,100,"65+"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,101,"65+"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,102,"65+"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,103,"65+"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,104,"65+"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,105,"65+"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,106,"65+"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,107,"65+"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,108,"65+"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,109,"65+"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,110,"65+"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,111,"65+"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,112,"65+"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,113,"65+"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,114,"65+"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,115,"65+"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,116,"65+"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,117,"65+"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,118,"65+"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,119,"65+"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,120,"65+"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,121,"65+"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,122,"65+"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,123,"65+"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,124,"65+"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,125,"65+"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,126,"65+"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,127,"65+"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,128,"65+"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,129,"65+"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,130,"65+"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,131,"65+"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,132,"65+"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,133,"65+"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,134,"65+"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,135,"65+"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,136,"65+"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,137,"65+"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,138,"65+"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,139,"65+"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,140,"65+"]

{"sheet":"Change Log","index":7,"n_rows":16,"n_cols":4,"rows_kept":16,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Adult Social Care Client Level Data Validation Tool - Release 2 Change Log"]
[null,"Date","Version","Comment"]
[null,"2025-08-28","v2.00","Initial release."]
[null,"2025-09-04","v2.01","Correction to lookup values:\n  - Hearing impairment: Severity unknown\n  - Visual impairment: Severity unknown\n  - Unpaid carer support: Support involving the person cared-for"]
[null,"2025-09-08","v2.02","Correction to lookup values:\n  - Planned transition from children's services\n  - Home support or domiciliary care\n"]
[null,"2025-09-23","v2.03","Added lookup value for Review_Outcomes_Acheived:\n  - Not applicable\n"]
[null,"2025-09-26","v2.04","Total Hrs Caring per week updated to reflect updated Release 2 lookup value mappings, released May 2025."]
[null,"2025-09-26","v2.05","Validate macro adjusted to account for the two data columns removed since Release 1."]
[null,"2025-10-09","v2.06","Apostrophe changed in lookup values, Summary counts tab wording amendment from \"Home support\"\n"]
[null,"2025-10-16","v2.07","Capitalisation in Cost Frequency validation and additional checks"]
[null,"2025-10-20","v2.08","Correction of reverted apostrophe issue, signed certificate applied\n"]
[null,"2025-10-22","v2.09","Amended Home Support value."]
[null,"2025-12-10","v2.10","Asserted case-sensitivity in lookup values"]
[null,"2026-04-13","v2.13","Corrected Review Outcomes Achieved to be mandatory only when review reason is planned"]
[null,"2026-04-20","v2.14","Ensured both apostrophe types are valid in lookups. Removed RL length validation on Event Outcome"]

{"sheet":"Formula","index":8,"n_rows":82,"n_cols":14,"rows_kept":82,"cut":false,"hidden":true,"merged":[[20,0,20,12]]}
["Specification","Guidance document"]
[null,"Event Outcome","Request","Assmt","Service","Review","spec defined list matches guidance doc."]
["Progress to Reablement/ST-Max","Progress to Reablement / ST-Max","PN+E","PN+E",null,"PE",{"$f":"IF(A3=B3,\"match\",\"not match\")","v":"not match"}]
["Progress to Assessment / Unplanned Review","Progress to Assessment / Unplanned Review","PN+E",null,null,null,"match"]
["Admitted to hospital","Admitted to Hospital",null,null,"PN+E",null,"match"]
["Progress to Re-assessment","Progress to re-assessment",null,null,null,"PN+E","match"]
["Progress to Support Planning / Services","Progress to Support Planning / Services*","PN","PN+E",null,null,"not match"]
["Progress to End of Life Care","Progress to End of Life Care","PN+E","PN+E","PN+E","PN+E","match"]
["No change in package","No change in package",null,null,null,"PN+E","match"]
["NFA - Deceased","NFA - Deceased","PN+E","PN+E","PN+E","PN+E","match"]
["NFA - Moved to another LA","NFA - Moved to another LA","PN+E","PN+E","PN+E","PN+E","match"]
["NFA - 100% NHS funded care","NFA - 100% NHS-funded care","PN+E","PN+E","PN+E","PN+E","not match"]
["NFA - Information & Advice / Signposting only","NFA - Information & Advice / Signposting only","PN","PN","PN+E",null,"match"]
["NFA - Self-funded client (inc 12wk disregard)","NFA - Self-funded client (inc. 12wk disregard)","PN+E","PN+E","PN+E","PN+E","not match"]
["NFA - Support declined","NFA - Support declined","PN+E","PN+E","PN+E","PN+E","match"]
["NFA - Support ended: Other reason","NFA - Support ended – other reason",null,null,"PN+E","PN+E","not match"]
["NFA - No services offered: Other reason","NFA - No services offered - other reason","PN+E","PN+E","PN+E",null,"not match"]
["Service ended as planned",null,null,null,null,null,"Not listed in guidance"]
[]
[]
["Do not move"]
["Request","Progress to reablement/ST-Max","Progress to assessment, review or reassessment","Progress to support planning or services","Progress to End of Life Care","NFA: Deceased","NFA: Responsibility moved to another local authority","NFA: Referral to NHS services or NHS funded social care","NFA: Information and advice or signposting","NFA: Self-funded client or under 12wk disregard","NFA: Support declined","NFA: No services offered for other reason","NFA: Support ended as planned"]
["Assessment","Progress to reablement/ST-Max","Progress to support planning or services","Progress to End of Life Care","NFA: Deceased","NFA: Responsibility moved to another local authority","NFA: Referral to NHS services or NHS funded social care","NFA: Information and advice or signposting","NFA: Self-funded client or under 12wk disregard","NFA: Support declined","NFA: No services offered for other reason","NFA: Support ended as planned"]
["Service","Admitted to hospital","Progress to End of Life Care","NFA: Deceased","NFA: Responsibility moved to another local authority","NFA: Referral to NHS services or NHS funded social care","NFA: Information and advice or signposting","NFA: Self-funded client or under 12wk disregard","NFA: Support declined","NFA: Support ended for other reason","NFA: No services offered for other reason","NFA: Support ended as planned","Progress to assessment, review or reassessment","Progress to Re-assessment"]
["Review","Progress to reablement/ST-Max","Progress to Re-assessment","Progress to End of Life Care","No change in package","NFA: Deceased","NFA: Responsibility moved to another local authority","NFA: Referral to NHS services or NHS funded social care","NFA: Self-funded client or under 12wk disregard","NFA: Support declined","NFA: Support ended for other reason","NFA: Support ended as planned","Progress to support planning or services"]
[]
["Deliver Mechanism"]
[]
["Long Term Support: Community","Community: Direct payment","Community: CASSR managed personal budget","Community: CASSR commissioned support"]
["Long Term Support: Prison","Prison: CASSR managed personal budget","Prison: CASSR commissioned support"]
[]
[]
[null,"Short term support: ST-Max"]
[null,"Short term support: Ongoing low level"]
[null,"Short term support: Other short term"]
[null,"Long term support: Nursing care"]
[null,"Long term support: Residential care"]
["Formula collated ",{"$f":"IF(#REF!=\"\",\"\",(IF(AND(#REF!=\"Service\",OR(#REF!=Formula!$B$33,#REF!=Formula!$B$34,#REF!=Formula!$B$35,#REF!=Formula!$B$36,#REF!=Formula!$B$37),#REF!=\"\"),\"\",(IF(AND(#REF!=\"Service\",OR(#REF!=Formula!$B$33,#REF!=Formula!$B$34,#REF!=Formula!$B$35,#REF!=Formula!$B$36,#REF!=Formula!$B$37),#REF!<>\"\"),\"Unexpected Value\",IF(AND(NOT(#REF!=\"Service\"),NOT(#REF!=\"\")),\"Event Specific\",(IF(AND(#REF!=\"Service\",#REF!=Formula!$A$29,OR(#REF!=Formula!$B$29,#REF!=Formula!$C$29,#REF!=Formula!$D$29)),\"P\",(IF(AND(#REF!=\"Service\",#REF!=Formula!$A$30,OR(#REF!=Formula!$B$30,#REF!=Formula!$C$30)),\"P\",(IF(AND(NOT(#REF!=\"Service\"),#REF!=\"\"),\"\"))))))))))))","v":{"$error":"#REF!"}},"Formula collated "]
["Formula broken down"]
[null,{"$f":"IF(#REF!=\"\",\"\")","v":{"$error":"#REF!"}},"row not populated"]
[null,{"$f":"(IF(AND(#REF!=\"Service\",OR(#REF!=Formula!$B$33,#REF!=Formula!$B$34,#REF!=Formula!$B$35,#REF!=Formula!$B$36,#REF!=Formula!$B$37),#REF!=\"\"),\"\"))","v":{"$error":"#REF!"}},"is service, is not LTS/C, is not LTS/P, IS NULL = \"\""]
[null,{"$f":"IF(AND(#REF!=\"Service\",OR(#REF!=Formula!$B$33,#REF!=Formula!$B$34,#REF!=Formula!$B$35,#REF!=Formula!$B$36,#REF!=Formula!$B$37),#REF!<>\"\"),\"Unexpected Value\")","v":{"$error":"#REF!"}},"is service, is not LTS/C, is not LTS/P, IS NOT NULL = \"Unexpected Value\""]
[null,{"$f":"IF(AND(NOT(#REF!=\"Service\"),NOT(#REF!=\"\")),\"Event Specific\")","v":{"$error":"#REF!"}},"Is not service, IS NOT NULL = \"Event Specific\""]
[null,{"$f":"IF(AND(#REF!=\"Service\",#REF!=Formula!$A$29,OR(#REF!=Formula!$B$29,#REF!=Formula!$C$29,#REF!=Formula!$D$29)),\"P\")","v":{"$error":"#REF!"}},"is service, is( LTS/C), is required fields = \"P\""]
[null,{"$f":"IF(AND(#REF!=\"Service\",#REF!=Formula!$A$30,OR(#REF!=Formula!$B$30,#REF!=Formula!$C$30)),\"P\")","v":{"$error":"#REF!"}},"is service, is( LTS/P), is required fields = \"P\""]
[null,{"$f":"IF(AND(NOT(#REF!=\"Service\"),#REF!=\"\"),\"\")","v":{"$error":"#REF!"}},"Is not service, IS NULL = \"\""]
[null,"IF(AND(Validate!#REF!=\"Service\",Validate!#REF!=Formula!$A$29,OR(Validate!#REF!=Formula!$B$29,Validate!#REF!=Formula!$C$29,Validate!#REF!=Formula!$D$29)),\"P\")"]
[null,{"$f":"IF(AND(#REF!=\"Service\",#REF!=Formula!$A$30,OR(#REF!=Formula!$B$29,#REF!=Formula!$C$29,#REF!=Formula!$D$29)),\"UV\")","v":{"$error":"#REF!"}}]
["Unit Cost"]
[]
["Formula collated ",{"$f":"IF(A11=\"\",\"\",(IF(AND(#REF!=\"Service\",ISNUMBER(#REF!)),\"P c\",(IF(AND(#REF!=\"Service\",#REF!=\"\"),\"P n\",(IF(AND(#REF!<>\"Service\",NOT(#REF!=\"\")),\"Event Specific\",(IF(AND(#REF!<>\"Service\",#REF!=\"\"),\"\",\"Unexpected Value\")))))))))","v":{"$error":"#REF!"}},"Formula collated (plus unexpected value)"]
["Formula broken down"]
[null,{"$f":"(IF(AND(#REF!=\"Service\",ISNUMBER(#REF!)),\"P c\"))","v":{"$error":"#REF!"}},"Unit Cost (IS NUMBER, IS SERVICE) =\"P c\""]
[null,{"$f":"(IF(AND(#REF!=\"Service\",#REF!=\"\"),\"P n\"))","v":{"$error":"#REF!"}},"Unit Cost (ISNULL, IS SERVICE) =\"P n\""]
[null,{"$f":"(IF(AND(#REF!<>\"Service\",NOT(#REF!=\"\")),\"Event Specific\"))","v":{"$error":"#REF!"}},"if(or(IS NOTNULL, ISNOT  SERVICE, \"Event Specific\""]
[null,{"$f":"(IF(AND(#REF!<>\"Service\",#REF!=\"\"),\"\"))","v":{"$error":"#REF!"}},"if(or(ISNULL, ISNOT  SERVICE, \"\""]
[]
["Cost Frequency"]
[]
[null,"Per session",null,"Formula collated ",{"$f":"IF(#REF!=\"\",\"\",(IF(AND(#REF!=\"Service\",OR(#REF!=Formula!$B$60,#REF!=Formula!$B$61,#REF!=Formula!$B$60,#REF!=Formula!$B$62,#REF!=Formula!$B$60,#REF!=Formula!$B$63,#REF!=Formula!$B$64,#REF!=Formula!$B$65,#REF!=Formula!$B$66,#REF!=Formula!$B$67,#REF!=Formula!$B$68,#REF!=Formula!$B$69)),\"P c\",(IF(AND(#REF!=\"Service\",#REF!=\"\",#REF!=\"\"),\"P n\",(IF(AND(#REF!<>\"Service\",#REF!<>\"\"),\"Event Specific\",(IF(AND(#REF!<>\"Service\",#REF!=\"\"),\"\",IF(AND(#REF!<>\"\",#REF!=\"\"),\"Missing Value\"))))))))))","v":{"$error":"#REF!"}},"Formula collated"]
[null,"Hourly",null,"Formula broken down"]
[null,"Daily",null,null,{"$f":"(IF(AND(#REF!=\"Service\",OR(#REF!=Formula!$B$60,#REF!=Formula!$B$61,#REF!=Formula!$B$60,#REF!=Formula!$B$62,#REF!=Formula!$B$60,#REF!=Formula!$B$63,#REF!=Formula!$B$64,#REF!=Formula!$B$65,#REF!=Formula!$B$66,#REF!=Formula!$B$67,#REF!=Formula!$B$68,#REF!=Formula!$B$69)),\"P c\"))","v":{"$error":"#REF!"}},"IS SERVICE, cost frquecy MATCHED DEFINED LIST,\"P c\""]
[null,"Weekly",null,null,{"$f":"(IF(AND(#REF!=\"Service\",#REF!=\"\",#REF!=\"\"),\"P n\"))","v":{"$error":"#REF!"}},"IS SERVICE, IS NULL, \"P n\""]
[null,"Fortnightly",null,null,{"$f":"(IF(AND(#REF!<>\"Service\",#REF!<>\"\"),\"Event Specific\"))","v":{"$error":"#REF!"}},"Isnot service, is not null, \"Event specific\""]
[null,"4-weekly",null,null,{"$f":"(IF(AND(#REF!<>\"Service\",#REF!=\"\"),\"\"))","v":{"$error":"#REF!"}},"Isnot service, is null, \"\""]
[null,"Monthly",null,null,{"$f":"IF(AND(#REF!<>\"\",#REF!=\"\"),\"Missing Value\")","v":{"$error":"#REF!"}},"If Unit cost is not null, and cost frequency is null = Missing Value"]
[null,"Quarterly",null,null,"IF(ISTEXT(AO23),\"UV\")"]
[null,"Annually"]
[null,"One-off"]
[]
[]
["Planned units \nper week"]
[]
["Formula collated ",{"$f":"IF(#REF!=\"\",\"\",(IF(AND(#REF!=Formula!$B$63,#REF!<>\"\"),\"Unexpected Value\",(IF(AND(#REF!=\"Service\",ISNUMBER(#REF!),OR(#REF!=Formula!$B$60,#REF!=Formula!$B$61,#REF!=Formula!$B$62,#REF!=Formula!$B$64,#REF!=Formula!$B$65,#REF!=Formula!$B$66,#REF!=Formula!$B$67,#REF!=Formula!$B$68,#REF!=Formula!$B$69)),\"P\",(IF(AND(#REF!<>\"Service\",#REF!=\"\"),\"\",(IF(AND(#REF!<>\"Service\",#REF!<>\"\"),\"Event Specific\",IF(AND(#REF!=Formula!$B$63,#REF!=\"\"),\"\",(IF(AND(#REF!=\"Service\",#REF!=\"\"),\"\",\"Unexpected Value\"))))))))))))","v":{"$error":"#REF!"}},"Formula collated (plus unexpected value)"]
["Formula broken down"]
[null,{"$f":"IF(AND(#REF!=Formula!$B$63,#REF!<>\"\"),\"Unexpected Value\")","v":{"$error":"#REF!"}},"If weekly, AND IS NOT NULL \"Unexpected Value\""]
[null,{"$f":"(IF(AND(#REF!=\"Service\",ISNUMBER(#REF!),OR(#REF!=Formula!$B$60,#REF!=Formula!$B$61,#REF!=Formula!$B$62,,#REF!,#REF!=Formula!$B$64,#REF!=Formula!$B$65,#REF!=Formula!$B$66,#REF!=Formula!$B$67,#REF!=Formula!$B$68,#REF!=Formula!$B$69)),\"P\"))","v":{"$error":"#REF!"}},"If not weekly, and match defined list in cost frequency, AND is number (P)"]
[null,{"$f":"IF(AND(#REF!<>\"Service\",#REF!=\"\"),\"\")","v":{"$error":"#REF!"}},"If not service, and is null, \"\""]
[null,{"$f":"IF(AND(#REF!<>\"Service\",#REF!<>\"\"),\"Event Specific\")","v":{"$error":"#REF!"}},"If not service, and is not null, \"Event specific\""]
[null,{"$f":"IF(AND(#REF!=Formula!$B$63,#REF!=\"\"),\"\")","v":{"$error":"#REF!"}},"If weekly, AND IS  NULL \"\""]
[null,{"$f":"IF(AND(#REF!=\"Service\",#REF!=\"\"),\"\")","v":{"$error":"#REF!"}},"if service, and is null, \"\""]
[null,{"$f":"IF(AND(#REF!<>Formula!$B$63,#REF!=\"\"),\"MV\")","v":{"$error":"#REF!"}},"If not weekly (Cost f), is null (MV)"]