{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Instructions","Input sheet","Validate","Validation summary page","Summary counts","lists","Formula"],"not_rendered":{"charts":0,"images":1,"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":10,"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,"Version:","BETA V1.1","2022-10-13"]
[null,"Please use this tool to help validate the CLD data before submission to the DSCRO."]
[]
[]
[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":54,"rows_kept":11,"cut":false,"hidden":false,"merged":[[7,35,8,35],[7,46,8,46],[7,45,8,45],[7,26,8,26],[7,22,8,22],[7,29,8,29],[7,30,8,30],[7,34,8,34],[7,0,8,0],[0,0,0,4],[7,24,8,24],[5,0,5,2],[7,23,8,23],[7,12,8,12],[7,13,8,13],[7,14,8,14],[7,8,8,8],[7,9,8,9],[7,10,8,10],[7,11,8,11],[7,5,8,5],[7,7,8,7],[7,15,8,15],[7,16,8,16],[6,50,7,50],[7,51,7,53],[7,4,8,4],[7,17,8,17],[7,27,8,27],[7,28,8,28],[7,33,8,33],[7,31,8,31],[7,32,8,32],[7,40,8,40],[7,41,8,41],[7,36,8,36],[7,37,8,37],[7,38,8,38],[7,18,8,18],[7,19,8,19],[2,1,2,3],[3,1,3,3],[7,1,8,1],[7,2,8,2],[7,6,8,6],[7,3,8,3],[7,47,8,47],[7,48,8,48],[7,49,8,49],[5,3,5,22],[5,24,5,29],[5,39,5,43],[5,47,5,49],[7,20,8,20],[7,21,8,21],[7,42,8,42],[7,43,8,43],[7,44,8,44],[7,25,8,25],[5,44,5,46],[5,31,5,33],[7,39,8,39]]}
["Adult Social Care - Client Level Data (CLD) - INPUT SHEET",null,null,null,null,null,"Spec Version","Release 1"]
[null,"Mandatory","Voluntary","Remove?",null,null,null,"*"]
["Summary:","Count of total data items"]
[null,{"$f":"COUNTIF(A8:AX8,\"*\")","v":50}]
[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,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,null,"Events (Reviews only)",null,null,"Costs (Services Only)"]
["Mandatory","Mandatory","Mandatory","Mandatory","Mandatory","Mandatory","Mandatory","Voluntary","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,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 Name","GP Practice Code","Gender","Ethnicity","Date of Birth","Date of Death","Client Type","Primary Support Reason","Postcode","Accommodation Status","Employment Status","Has Informal 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 Name","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,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","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","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,null,null,{"$f":"IFERROR(IF(X11=\"18(3) (full cost client)\",\"n/a\",IF(AX11>0,AV11*AX11*VLOOKUP(AW11,lists!$AZ$5:$BA$13,2,FALSE),IF(AO11<0,AV11*VLOOKUP(AW11,lists!$AZ$5:$BA$13,2,FALSE),IF(AX11=0,AV11*VLOOKUP(AW11,lists!$AZ$5:$BA$13,2,FALSE)))))*(BB11*100/52)/100,\"\")","v":""},{"$f":"IF(B11=\"\", \"\", IF(AA11<B11,B11,IF(AA11>B11,AA11,B11)))","v":""},{"$f":"IF(C11=\"\", \"\", IF(AB11=\"\",C11,IF(AB11>C11,C11,AB11)))","v":""},{"$f":"IFERROR(ROUND(DATEDIF(AZ11,BA11,\"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":108,"rows_kept":11,"cut":false,"hidden":false,"merged":[[6,47,6,49],[6,0,6,2],[0,0,0,4],[6,3,6,22],[6,24,6,29],[6,39,6,43],[6,31,6,33],[6,44,6,46]]}
["Adult Social Care - Client Level Data (CLD) - VALIDATE",null,null,null,null,null,"Spec Version","Release 1"]
[]
[]
[]
[]
[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,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,null,"Events (Reviews only)",null,null,"Costs (Services Only)"]
["Mandatory","Mandatory","Mandatory","Mandatory","Mandatory","Mandatory","Mandatory","Voluntary","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,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,null,null,"LA Code ","Reporting Period Start Date","Reporting Period End Date","NHS Number","LA Person Unique Identifier","First Name","Last Name","GP Practice Name","GP Practice Code","Gender","Ethnicity","Date of Birth","Date of Death","Client Type","Primary Support Reason","Postcode","Accommodation Status","Employment Status","Has Informal 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 Name","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 Name","GP Practice Code","Gender","Ethnicity","Date of Birth","Date of Death","Client Type","Primary Support Reason","Postcode","Accommodation Status","Employment Status","Has Informal 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 Name","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","Column AW","Column AX",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":""},{"$f":"IF('Input sheet'!AW11=\"\",\"\",'Input sheet'!AW11)","v":""},{"$f":"IF('Input sheet'!AX11=\"\",\"\",'Input sheet'!AX11)","v":""},null,{"$f":"IF(E11=\"\",\"\",IF(AND(A11<>\"\",NOT(ISNUMBER(A11))),\"UV\",IF(AND(E11<>\"\",A11=\"\"),\"MV\",\"P\")))","v":""},{"$f":"IF(A11=\"\",\"\",IF(NOT(ISERROR(DATEVALUE(TEXT(B11,\"dd/mm/yyyy\")))),\"P\",IF(AND(B11<>\"\",ISERROR(DATEVALUE(TEXT(B11,\"dd/mm/yyyy\")))),\"UV\",IF(AND(A11<>\"\",B11=\"\"),\"MV\",\"check\"))))","v":""},{"$f":"IF(A11=\"\",\"\",IF(NOT(ISERROR(DATEVALUE(TEXT(C11,\"dd/mm/yyyy\")))),\"P\",IF(AND(C11<>\"\",ISERROR(DATEVALUE(TEXT(C11,\"dd/mm/yyyy\")))),\"UV\",IF(AND(A11<>\"\",C11=\"\"),\"MV\",\"check\"))))","v":""},{"$f":"IF(A11=\"\",\"\",(IF(ISNUMBER(D11),\"P\",(IF(D11=\"\",\"MV\",(IF(ISTEXT(D11),\"P\")))))))","v":""},{"$f":"IF(A11=\"\",\"\",IF(E11=\"\",\"MV\",\"P\"))","v":""},{"$f":"IF(A11=\"\",\"\",(IF(ISTEXT(F11),\"P\",(IF(F11=\"\",\"MV\",(IF(ISNUMBER(F11),\"UV\")))))))","v":""},{"$f":"IF(A11=\"\",\"\",(IF(ISTEXT(G11),\"P\",(IF(G11=\"\",\"MV\",(IF(ISNUMBER(G11),\"UV\")))))))","v":""},null,null,{"$f":"IFERROR(IF(A11=\"\",\"\",(IF(J11=\"\",\"MV\",(IF(VLOOKUP(J11,lists!$J$4:$J$7,1,FALSE)=J11,\"P\"))))),\"UV\")","v":""},{"$f":"IFERROR(IF(A11=\"\",\"\",(IF(K11=\"\",\"MV\",(IF(VLOOKUP(K11,lists!$K$4:$K$20,1,FALSE)=K11,\"P\"))))),\"UV\")","v":""},{"$f":"IF(A11=\"\",\"\",IF(NOT(ISERROR(DATEVALUE(TEXT(L11,\"dd/mm/yyyy\")))),\"P\",IF(AND(L11<>\"\",ISERROR(DATEVALUE(TEXT(L11,\"dd/mm/yyyy\")))),\"UV\",IF(AND(A11<>\"\",L11=\"\"),\"MV\",\"check\"))))","v":""},{"$f":"IF(M11=\"\",\"\",IF(NOT(ISERROR(DATEVALUE(TEXT(M11,\"dd/mm/yyyy\")))),\"P\",IF(AND(M11<>\"\",ISERROR(DATEVALUE(TEXT(M11,\"dd/mm/yyyy\")))),\"UV\",\"\")))","v":""},{"$f":"IFERROR(IF(A11=\"\",\"\",(IF(N11=\"\",\"MV\",(IF(VLOOKUP(N11,lists!$N$4:$N$7,1,FALSE)=N11,\"P\"))))),\"UV\")","v":""},{"$f":"IFERROR(IF(A11=\"\",\"\",(IF(O11=\"\",\"MV\",(IF(VLOOKUP(O11,lists!$O$4:$O$16,1,FALSE)=O11,\"P\",))))),\"UV\")","v":""},{"$f":"IF(A11=\"\",\"\",(IF(P11=\"\",\"MV\",(IF(NOT(P11=\"\"),\"P\")))))","v":""},{"$f":"IFERROR(IF(A11=\"\",\"\",(IF(DA11=\"\",\"\",(IF(AND(DA11=\"LTS004\",Q11=\"\"),\"CS\",(IF(DA11=\"LTS004\",IF(VLOOKUP(Q11,lists!$Q$4:$Q$23,1,FALSE)=Q11,\"P\",)))))))),\"UV\")","v":""},{"$f":"IFERROR(IF(A11=\"\",\"\",(IF(DA11=\"\",\"\",(IF(AND(DA11=\"LTS004\",Q11=\"\"),\"CS\",(IF(DA11=\"LTS004\",IF(VLOOKUP(R11,lists!$R$4:$R$10,1,FALSE)=R11,\"P\",)))))))),\"Uv\")","v":""},{"$f":"IFERROR(IF(A11=\"\",\"\",(IF(S11=\"\",\"MV\",(IF(VLOOKUP(S11,lists!$S$4:$S$6,1,FALSE)=S11,\"P\"))))),\"UV\")","v":""},{"$f":"IF(T11=\"\",\"\",IF(NOT(ISERROR(VLOOKUP(T11,lists!$T$4:$T$6,1,0))),\"P\",\"UV\"))","v":""},{"$f":"IF(U11=\"\",\"\",IF(NOT(ISERROR(VLOOKUP(U11,lists!$U$4:$U$8,1,0))),\"P\",\"UV\"))","v":""},{"$f":"IF(V11=\"\",\"\",IF(NOT(ISERROR(VLOOKUP(V11,lists!$V$4:$V$9,1,0))),\"P\",\"UV\"))","v":""},{"$f":"IFERROR(IF(A11=\"\",\"\",(IF(W11=\"\",\"MV\",(IF(VLOOKUP(W11,lists!$W$4:$W$6,1,FALSE)=W11,\"P\"))))),\"UV\")","v":""},{"$f":"IFERROR(IF(A11=\"\",\"\",(IF(X11=\"\",\"MV\",(IF(VLOOKUP(X11,lists!$X$4:$X$11,1,FALSE)=X11,\"P\"))))),\"UV\")","v":""},{"$f":"IFERROR(IF(A11=\"\",\"\",(IF(Y11=\"\",\"MV\",(IF(VLOOKUP(Y11,lists!$Y$4:$Y$7,1,FALSE)=Y11,\"P\"))))),\"UV\")","v":""},null,{"$f":"IF(A11=\"\",\"\",(IF(AA11=\"\",\"MV\",(IF(ISTEXT(AA11),\"UV\",(IF(ISNUMBER(AA11),\"P\")))))))","v":""},{"$f":"IF(A11=\"\",\"\",(IF(AND(AB11=\"\",Y11=\"Service\"),\"\",(IF(AND(AB11=\"\",(NOT(Y11=\"Service\"))),\"ES\",(IF(ISTEXT(AB11),\"UV\",IF(ISNUMBER(AB11),\"P\"))))))))","v":""},null,{"$f":"IFERROR(IF(A11=\"\",\"\",(IF(AD11=\"\",\"MV\",(IF(VLOOKUP(AD11,lists!$AD$4:$AD$22,1,FALSE)=AD11,\"P\"))))),\"UV\")","v":""},{"$f":"IFERROR(IF(A11=\"\",\"\",(IF(AND(AE11<>\"\",Y11<>\"Request\"),\"ES\",(IF(AND(AE11=\"\",Y11=\"Request\"),\"MV\",(IF(AND(AE11=\"\",Y11<>\"Request\"),\"\",(IF(AND(Y11=\"Request\",VLOOKUP(AE11,lists!$AE$4:$AE$11,1,FALSE)=AE11),\"P\"))))))))),\"UV\")","v":""},{"$f":"IF(A11=\"\",\"\", IF(AND(Y11=\"Assessment\",AF11=\"\"),\"MV\",IF(Y11<>\"Assessment\",\"P\",IFERROR(IF(VLOOKUP(AF11,lists!$AF$4:$AF$6,1,FALSE)=AF11, \"P\"),\"UV\"))))","v":""},{"$f":"IFERROR(IF(Y11<>\"Assessment\",\"\",IF(A11=\"\",\"\",IF(VLOOKUP(AG11,lists!$AG$4:$AG6,1,FALSE)=AG11,\"P\"))),\"UV\")","v":""},{"$f":"IFERROR(IF(Y11<>\"Assessment\",\"\",IF(A11=\"\",\"\",IF(VLOOKUP(AH11,lists!$AH$4:$AH6,1,FALSE)=AH11,\"P\"))),\"UV\")","v":""},{"$f":"IF(A11=\"\", \"\", IF(OR(N11=\"Carer\", N11=\"Carer known by association\"), IFERROR(IF(VLOOKUP(AI11,lists!$AI$4:$AI11,1,FALSE)=AI11,\"P\"),\"UV\"), \"\"))","v":""},null,null,null,null,{"$f":"IFERROR(IF(A11=\"\",\"\",(IF(AND(NOT(AN11=\"\"),Y11<>\"Service\"),\"ES\",(IF(AND(AN11=\"\",Y11=\"Service\"),\"MV\",(IF(AND(AN11=\"\",Y11<>\"Service\"),\"\",(IF(AND(Y11=\"Service\",VLOOKUP(AN11,lists!$AN$4:$AN$12,1,FALSE)=AN11),\"P\"))))))))),\"UV\")","v":""},{"$f":"IFERROR(IF(A11=\"\",\"\",(IF(AND(NOT(AO11=\"\"),Y11<>\"Service\"),\"ES\",(IF(AND(AO11=\"\",Y11=\"Service\"),\"MV\",(IF(AND(AO11=\"\",Y11<>\"Service\"),\"\",(IF(AND(Y11=\"Service\",VLOOKUP(AO11,lists!$AO$4:$AO$27,1,FALSE)=AO11),\"P\"))))))))),\"UV\")","v":""},{"$f":"IF(Y11=\"Service\", IFERROR(IF(A11=\"\",\"\",IF(VLOOKUP(AP11,lists!$AP$4:$AP7,1,FALSE)=AP11,\"P\")),\"UV\"), \"\")","v":""},null,null,{"$f":"IFERROR(IF(A11=\"\",\"\",(IF(AND(AS11<>\"\",Y11<>\"Review\"),\"ES\",(IF(AND(AS11=\"\",Y11=\"Review\"),\"ES\",(IF(AND(AS11=\"\",Y11<>\"Review\"),\"\",(IF(AND(Y11=\"Review\",VLOOKUP(AS11,lists!$AS$4:$AS$10,1,FALSE)=AS11),\"P\"))))))))),\"UV\")","v":""},{"$f":"IFERROR(IF(A11=\"\",\"\",(IF(AND(AT11<>\"\",Y11<>\"Review\"),\"ES\",(IF(AND(AT11=\"\",Y11=\"Review\"),\"P\",(IF(AND(AT11=\"\",Y11<>\"Review\"),\"\",(IF(AND(Y11=\"Review\",VLOOKUP(AT11,lists!$AT$4:$AT$6,1,FALSE)=AT11),\"P\"))))))))),\"UV\")","v":""},{"$f":"IFERROR(IF(Y11<>\"Review\",\"\",IF(A11=\"\",\"\",IF(VLOOKUP(AU11,lists!$AU$4:$AU6,1,FALSE)=AU11,\"P\"))),\"UV\")","v":""},{"$f":"IF(A11=\"\",\"\",(IF(AND(Y11=\"Service\",ISNUMBER(AV11)),\"P\",(IF(AND(Y11=\"Service\",AV11=\"\"),\"P\",(IF(AND(Y11<>\"Service\",NOT(AV11=\"\")),\"ES\",(IF(AND(Y11<>\"Service\",AV11=\"\"),\"\",\"UV\")))))))))","v":""},{"$f":"IF(Y11=\"Service\", IFERROR(IF(A11=\"\",\"\",(IF(AW11=\"\",\"MV\",(IF(VLOOKUP(AW11,lists!$AW$4:$AW$13,1,FALSE)=AW11,\"P\"))))),\"UV\"), \"\")","v":""},null,null,{"$f":"IF(L11=\"\",\"\",(DATEDIF(L11,C11,\"y\")))","v":""},{"$f":"IFERROR(VLOOKUP(DATEDIF(L11,AA11,\"y\"),lists!BG:BH,2,FALSE),\"\")","v":""},{"$f":"IF(AND(O11=lists!$O$10,Validate!CZ11=\"18-64\"),\"LTS004\",\"\")","v":""},{"$f":"IF(A11=\"\",\"\",(IF(AA11=\"\",\"Missing Value [Event start date]\",(IF(ISTEXT(AA11),\"Unexpected Value [Event start date]\",(IF(AND(AA11<=C11,AB11=\"\"),\"Event Active\",(IF(ISTEXT(AB11),\"Unexpected Value [Event end date]\",(IF(AND(AA11<=C11,AB11>=B11),\"Event Active\",\"Event not active\")))))))))))","v":""},{"$f":"IF(A11=\"\",\"\",(IF(COUNTIFS(AZ11:CW11,\"MV\")+(COUNTIFS(AZ11:CW11,\"UV\")+(COUNTIFS(AZ11:CW11,\"ES\")+(COUNTIFS(AZ11:CW11,\"Event Not Active\")+(COUNTIFS(AZ11:CW11,\"FALSE\")+(COUNTIFS(AZ11:CW11,\"N/A\"))))))=0,\"P\",(COUNTIFS(AZ11:CW11,\"MV\")+(COUNTIFS(AZ11:CW11,\"UV\")+(COUNTIFS(AZ11:CW11,\"ES\")+(COUNTIFS(AZ11:CW11,\"Validation Check on Hold [Event Not Active]\")+(COUNTIFS(AZ11:CW11,\"FALSE\")+(COUNTIFS(AZ11:CW11,\"N/A\"))))))))))","v":""},{"$f":"NOT(OR(A11=\"\",B11=\"\", C11=\"\", E11=\"\", AA11=\"\"))","v":false}]

{"sheet":"Validation summary page","index":3,"n_rows":114,"n_cols":8,"rows_kept":114,"cut":false,"hidden":false,"merged":[[2,1,2,6],[15,1,15,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(G19:G51)","v":0},{"$f":"IF(Validate!$A$11=\"\",\"\",IF(D9=0,\"PASS\",\"CHECK\"))","v":""},"Total rows that have passed validation",{"$f":"COUNTIF(Validate!DC:DC,\"P\")","v":0},"P"]
[null,"Unexpected Value",{"$f":"COUNTIF(E:E,B10)","v":43},{"$f":"SUM(G52:G94)","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!DC:DC,\">=1\")","v":0},1]
[null,"Event Specific",{"$f":"COUNTIF(E:E,B11)","v":15},{"$f":"SUM(G95:G109)","v":0},{"$f":"IF(Validate!$A$11=\"\",\"\",IF(D11=0,\"PASS\",\"CHECK\"))","v":""},"Total rows submitted",{"$f":"SUM(G9:G10)","v":0}]
[null,"Cohort Specific",{"$f":"COUNTIF(E:E,B12)","v":2},{"$f":"SUM(G110:G111)","v":0},{"$f":"IF(Validate!$A$11=\"\",\"\",IF(D12=0,\"PASS\",\"CHECK\"))","v":""},"Total rows acceptable by DLP",{"$f":"COUNTIF(Validate!DD:DD, TRUE)","v":0}]
[]
[null,"Total Validation rules",{"$f":"SUM(C9:C12)","v":93},{"$f":"SUM(D9:D12)","v":0},{"$f":"IF(Validate!$A$11=\"\",\"\",IF(D14=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 - \" & B19","v":"MV - 01"},"Missing Value",{"$f":"CONCATENATE(\"Missing - a value for \",C19,\" 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!AZ11:$AZ$200000,\"MV\")","v":0}]
[null,"02","Reporting Period Start Date",{"$f":"\"MV - \" & B20","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!BA11:$BA$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!BB11:$BB$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!BC11:$BC$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!BD11:$BD$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!BE11:$BE$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!BF11:$BF$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!BI11:$BI$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!BJ11:$BJ$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!BK11:$BK$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!BL11:$BL$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!BM11:$BM$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!BN11:$BN$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!BO11:$BO$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!BP11:$BP$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!BQ11:$BQ$200000,\"MV\")","v":0}]
[null,19,"Has Informal Carer","MV - 19","Missing Value","Missing - a value for Has Informal Carer should be recorded for every row of data submitted",{"$f":"COUNTIF(Validate!BR11:$BR$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!BW11:$BW$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!BX11:$BX$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!BZ11:$BZ$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!CA11:$CA$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!CC11:$CC$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!CD11:$CD$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!CE11:$CE$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!CG11:$CG$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!CM11:$CM$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!CN11:$CN$200000,\"MV\")","v":0}]
[null,44,"Review Reason","MV - 44","Missing Value","Missing - a value for Review Reason should be recorded for every row of data submitted",{"$f":"COUNTIF(Validate!CR11:$CR$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!CS11:$CS$200000,\"MV\")","v":0}]
[null,47,"Method of Review",{"$f":"\"MV - \" & B48","v":"MV - 47"},"Missing Value",{"$f":"CONCATENATE(\"Missing - a value for \",C48,\" 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!CT11:$CT$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!CU11:$CU$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!CV11:$CV$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 zero where Cost Frequency is 'Weekly')",{"$f":"COUNTIF(Validate!CW11:$CW$200000,\"MV\")","v":0}]
[null,"01","LA Code",{"$f":"\"UV - \" & B52","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!AZ11:$AZ$200000,\"UV\")","v":0}]
[null,"02","Reporting Period Start Date",{"$f":"\"UV - \" & B53","v":"UV - 02"},"Unexpected Value","Unexpected Value - the 'Reporting Period Start Date' (column B input sheet) does not match the 'Reporting Period Start Date' (Instructions tab, cell C18). ",{"$f":"COUNTIF(Validate!BA11:$BA$200000,\"UV\")","v":0}]
[null,"03","Reporting Period End Date","UV - 03","Unexpected Value","Unexpected Value - The 'Reporting Period End Date' (column C input sheet) does not match the 'Reporting Period End Date' (Instructions tab, cell C19)",{"$f":"COUNTIF(Validate!BB11:$BB$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!BC11:$BC$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!BD11:$BD$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!BE11:$BE$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!BF11:$BF$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!BI11:$BI$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!BJ11:$BJ$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!BK11:$BK$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!BL11:$BL$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!BM11:$BM$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!BN11:$BN$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!BO11:$BO$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!BP11:$BP$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!BQ11:$BQ$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!BR11:$BR$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!BS11:$BS$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!BT11:$BT$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!BU11:$BU$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!BV11:$BV$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!BW11:$BW$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!BX11:$BX$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!BZ11:$BZ$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!CA11:$CA$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!CB11:$CB$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!CC11:$CC$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!CD11:$CD$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!CE11:$CE$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!CF11:$CF$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!CG11:$CG$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!CH11:$CH$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!CM11:$CM$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!CN11:$CN$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!CO11:$CO$200000,\"UV\")","v":0}]
[null,43,"Provider CQC Location Name","UV - 43","Unexpected Value","Unexpected Value - the value should be in the appropriate format or one of the defined values in the list","n/a"]
[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!CR11:$CR$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!CS11:$CS$200000,\"UV\")","v":0}]
[null,47,"Method of Review",{"$f":"\"UV - \" & B91","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!CT11:$CT$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!CU11:$CU$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!CV11:$CV$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!CW11:$CW$200000,\"UV\")","v":0}]
[null,28,"Event End Date",{"$f":"\"ES - \" & B95","v":"ES - 28"},"Event Specific","Event specific - only service events can be blank",{"$f":"COUNTIF(Validate!CA11:$CA$200000,\"ES\")","v":0}]
[null,30,"Event Outcome",{"$f":"\"ES - \" & B96","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!CD11:$CD$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!CE11:$CE$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!CF11:$CF$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!CM11:$CM$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!CN11:$CN$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!CO11:$CO$200000,\"ES\")","v":0}]
[null,43,"Provider CQC Location Name","ES - 43","Event Specific","Event Specific - Provider CQC Location Name is only required for Service Events","n/a"]
[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!CR11:$CR$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!CS11:$CS$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!CU11:$CU$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!CV11:$CV$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 zero where Cost Frequency is 'Weekly')",{"$f":"COUNTIF(Validate!CW11:$CW$200000,\"ES\")","v":0}]
[null,17,"Accommodation Status",{"$f":"\"CS - \" & B110","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!BP11:$BP$200000,\"CS\")","v":0}]
[null,18,"Employment Status",{"$f":"\"CS - \" & B111","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!BQ11:$BQ$200000,\"CS\")","v":0}]
[null,null,null,null,null,"Total",{"$f":"SUM(G19:G111)","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":"Summary counts","index":4,"n_rows":66,"n_cols":6,"rows_kept":66,"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'!Y11:Y50493,C8)","v":0}]
[null,null,"Assessment",{"$f":"COUNTIF('Input sheet'!Y11:Y50493,C9)","v":0}]
[null,null,"Service",{"$f":"COUNTIF('Input sheet'!Y11:Y50493,C10)","v":0}]
[null,null,"Review",{"$f":"COUNTIF('Input sheet'!Y11:Y50493,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,"Planned Entry (Transition)",{"$f":"COUNTIF('Input sheet'!$AE$11:$AE$50493,C17)","v":0}]
[null,null,"Discharge from Hospital",{"$f":"COUNTIF('Input sheet'!$AE$11:$AE$50493,C18)","v":0}]
[null,null,"Diversion from Hospital Services",{"$f":"COUNTIF('Input sheet'!$AE$11:$AE$50493,C19)","v":0}]
[null,null,"Community / Other route",{"$f":"COUNTIF('Input sheet'!$AE$11:$AE$50493,C20)","v":0}]
[null,null,"Prison",{"$f":"COUNTIF('Input sheet'!$AE$11:$AE$50493,C21)","v":0}]
[null,null,"Self-Funder with depleted funds",{"$f":"COUNTIF('Input sheet'!$AE$11:$AE$50493,C22)","v":0}]
[null,null,"Self-Funder with depleted funds - 12-wk disregard or DPA",{"$f":"COUNTIF('Input sheet'!$AE$11:$AE$50493,C23)","v":0}]
[null,null,"Discharge from Reablement",{"$f":"COUNTIF('Input sheet'!$AE$11:$AE$50493,C24)","v":0}]
[null,null,"Transfer from Other LA",{"$f":"COUNTIF('Input sheet'!$AE$11:$AE$50493,C25)","v":0}]
[null,null,"Total",{"$f":"SUM(D17:D25)","v":0},{"$f":"IF(D26=D8,\"\",\"CHECK\")","v":""}]
[]
[null,null,"Count of Assessments \nby Assessment Type","Count"]
[null,null,"Short Term Assessment",{"$f":"COUNTIF('Input sheet'!AF11:AF50493,C29)","v":0}]
[null,null,"Long Term Assessment",{"$f":"COUNTIF('Input sheet'!AF11:AF50493,C30)","v":0}]
[null,null,"Financial Assessment",{"$f":"COUNTIF('Input sheet'!AF11:AF50494,C31)","v":0}]
[null,null,"Total",{"$f":"SUM(D29:D31)","v":0},{"$f":"IF(D32=D9,\"\",\"CHECK\")","v":""}]
[]
[null,null,"Count of Services and annual gross committed cost\nby Service Component ","Count","Cost (£)"]
[null,null,"Reablement",{"$f":"COUNTIF('Input sheet'!$AO$11:$AO$50493,C35)","v":0},{"$f":"SUMIF('Input sheet'!$AO:$AO,'Summary counts'!C35,'Input sheet'!$AY:$AY)","v":0}]
[null,null,"Short Term Nursing Care",{"$f":"COUNTIF('Input sheet'!$AO$11:$AO$50493,C36)","v":0},{"$f":"SUMIF('Input sheet'!$AO:$AO,'Summary counts'!C36,'Input sheet'!$AY:$AY)","v":0}]
[null,null,"Short Term Residential Care",{"$f":"COUNTIF('Input sheet'!$AO$11:$AO$50493,C37)","v":0},{"$f":"SUMIF('Input sheet'!$AO:$AO,'Summary counts'!C37,'Input sheet'!$AY:$AY)","v":0}]
[null,null,"Long Term Nursing Care",{"$f":"COUNTIF('Input sheet'!$AO$11:$AO$50493,C38)","v":0},{"$f":"SUMIF('Input sheet'!$AO:$AO,'Summary counts'!C38,'Input sheet'!$AY:$AY)","v":0}]
[null,null,"Long Term Residential Care",{"$f":"COUNTIF('Input sheet'!$AO$11:$AO$50493,C39)","v":0},{"$f":"SUMIF('Input sheet'!$AO:$AO,'Summary counts'!C39,'Input sheet'!$AY:$AY)","v":0}]
[null,null,"Home Support",{"$f":"COUNTIF('Input sheet'!$AO$11:$AO$50493,C40)","v":0},{"$f":"SUMIF('Input sheet'!$AO:$AO,'Summary counts'!C40,'Input sheet'!$AY:$AY)","v":0}]
[null,null,"Day Support",{"$f":"COUNTIF('Input sheet'!$AO$11:$AO$50493,C41)","v":0},{"$f":"SUMIF('Input sheet'!$AO:$AO,'Summary counts'!C41,'Input sheet'!$AY:$AY)","v":0}]
[null,null,"Meals",{"$f":"COUNTIF('Input sheet'!$AO$11:$AO$50493,C42)","v":0},{"$f":"SUMIF('Input sheet'!$AO:$AO,'Summary counts'!C42,'Input sheet'!$AY:$AY)","v":0}]
[null,null,"Transport",{"$f":"COUNTIF('Input sheet'!$AO$11:$AO$50493,C43)","v":0},{"$f":"SUMIF('Input sheet'!$AO:$AO,'Summary counts'!C43,'Input sheet'!$AY:$AY)","v":0}]
[null,null,"Equipment",{"$f":"COUNTIF('Input sheet'!$AO$11:$AO$50493,C44)","v":0},{"$f":"SUMIF('Input sheet'!$AO:$AO,'Summary counts'!C44,'Input sheet'!$AY:$AY)","v":0}]
[null,null,"Direct Payment",{"$f":"COUNTIF('Input sheet'!$AO$11:$AO$50493,C45)","v":0},{"$f":"SUMIF('Input sheet'!$AO:$AO,'Summary counts'!C45,'Input sheet'!$AY:$AY)","v":0}]
[null,null,"Shared Lives",{"$f":"COUNTIF('Input sheet'!$AO$11:$AO$50493,C46)","v":0},{"$f":"SUMIF('Input sheet'!$AO:$AO,'Summary counts'!C46,'Input sheet'!$AY:$AY)","v":0}]
[null,null,"Community Supported Living",{"$f":"COUNTIF('Input sheet'!$AO$11:$AO$50493,C47)","v":0},{"$f":"SUMIF('Input sheet'!$AO:$AO,'Summary counts'!C47,'Input sheet'!$AY:$AY)","v":0}]
[null,null,"Professional Support",{"$f":"COUNTIF('Input sheet'!$AO$11:$AO$50493,C48)","v":0},{"$f":"SUMIF('Input sheet'!$AO:$AO,'Summary counts'!C48,'Input sheet'!$AY:$AY)","v":0}]
[null,null,"Learning/Education/Employment Support",{"$f":"COUNTIF('Input sheet'!$AO$11:$AO$50493,C49)","v":0},{"$f":"SUMIF('Input sheet'!$AO:$AO,'Summary counts'!C49,'Input sheet'!$AY:$AY)","v":0}]
[null,null,"End of Life Care",{"$f":"COUNTIF('Input sheet'!$AO$11:$AO$50493,C50)","v":0},{"$f":"SUMIF('Input sheet'!$AO:$AO,'Summary counts'!C50,'Input sheet'!$AY:$AY)","v":0}]
[null,null,"Emergency Support",{"$f":"COUNTIF('Input sheet'!$AO$11:$AO$50493,C51)","v":0},{"$f":"SUMIF('Input sheet'!$AO:$AO,'Summary counts'!C51,'Input sheet'!$AY:$AY)","v":0}]
[null,null,"Other Short Term Support",{"$f":"COUNTIF('Input sheet'!$AO$11:$AO$50493,C52)","v":0},{"$f":"SUMIF('Input sheet'!$AO:$AO,'Summary counts'!C52,'Input sheet'!$AY:$AY)","v":0}]
[null,null,"Other Long Term Support",{"$f":"COUNTIF('Input sheet'!$AO$11:$AO$50493,C53)","v":0},{"$f":"SUMIF('Input sheet'!$AO:$AO,'Summary counts'!C53,'Input sheet'!$AY:$AY)","v":0}]
[null,null,"Total",{"$f":"SUM(D35:D53)","v":0},{"$f":"SUM(E35:E53)","v":0},{"$f":"IF(D54=D10,\"\",\"CHECK\")","v":""}]
[]
[null,null,"Count of Reviews\nby Review Reason","Count"]
[null,null,"Planned",{"$f":"COUNTIF('Input sheet'!$AS$11:$AS$50493,C57)","v":0}]
[null,null,"Unplanned",{"$f":"SUM(D60:D65)","v":0}]
[null,null,"Of which:"]
[null,null,"Unplanned - Hospital (Planned and unplanned episodes)",{"$f":"COUNTIF('Input sheet'!$AS$11:$AS$50493,C60)","v":0}]
[null,null,"Unplanned - Carer related",{"$f":"COUNTIF('Input sheet'!$AS$11:$AS$50493,C61)","v":0}]
[null,null,"Unplanned - Safeguarding concern",{"$f":"COUNTIF('Input sheet'!$AS$11:$AS$50493,C62)","v":0}]
[null,null,"Unplanned - Other Reason",{"$f":"COUNTIF('Input sheet'!$AS$11:$AS$50493,C63)","v":0}]
[null,null,"Unplanned - Provider Failure",{"$f":"COUNTIF('Input sheet'!$AS$11:$AS$50493,C64)","v":0}]
[null,null,"Unplanned - Change in Commissioning arrangements",{"$f":"COUNTIF('Input sheet'!$AS$11:$AS$50493,C65)","v":0}]
[null,null,"Total",{"$f":"SUM(D57:D58)","v":0},{"$f":"IF(D66=D11,\"\",\"CHECK\")","v":""}]

{"sheet":"lists","index":5,"n_rows":142,"n_cols":60,"rows_kept":142,"cut":false,"hidden":true,"merged":[[0,49,1,49],[1,51,1,55],[0,43,1,43],[0,44,1,44],[0,45,1,45],[0,47,1,47],[0,48,1,48],[0,13,1,13],[0,9,1,9],[0,10,1,10],[0,19,1,19],[0,20,1,20],[0,18,1,18],[0,14,1,14],[0,15,1,15],[0,16,1,16],[0,17,1,17],[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,6,1,6],[0,7,1,7],[0,8,1,8],[0,11,1,11],[0,12,1,12],[0,21,1,21],[0,22,1,22],[0,39,1,39],[0,40,1,40],[0,41,1,41],[0,33,1,33],[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,32,1,32],[0,42,1,42],[0,46,1,46],[0,34,1,34],[0,35,1,35],[0,36,1,36],[0,37,1,37],[0,38,1,38]]}
["LA Code ","Reporting Period Start Date","Reporting Period End Date","NHS Number","LA Person Unique Identifier","First Name","Last Name","GP Practice Name","GP Practice Code","Gender","Ethnicity","Date of Birth","Date of Death","Client Type","Primary Support Reason","Postcode","Accommodation Status","Employment Status","Has Informal 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 Name","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,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","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","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,null,"Female","White - British",null,null,"Service User","Physical Support: Access & mobility only","Unknown","Owner occupier or shared ownership scheme","Paid: Less than 16 hours a week","Yes","Yes","Blind/severely sight impaired","Deaf with speech","Yes","18(3) (full cost client)","Request",null,null,null,null,"Progress to Reablement/ST-Max","Planned Entry (Transition)","Short Term Assessment","Eligible needs identified","Carer only","1 - 7 hrs",null,null,null,null,"Short Term Support: ST-Max","Reablement","Direct Payment",null,null,"Planned","Fully Met","Carer only",null,"Per Session",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,null,"Male","White - Irish",null,null,"Carer","Physical Support: Personal care support",null,"Tenant","Paid: 16 or more hours a week","No","No","Partial sight/sight impaired","Deaf without speech","No","Self-Funder – Metering Only","Assessment",null,null,null,null,"Progress to Assessment","Discharge from Hospital","Long Term Assessment","Non-eligible needs identified","Service user only","8 - 14 hrs",null,null,null,null,"Short Term Support: Ongoing Low Level","Short Term Nursing Care","CASSR Managed Personal Budget",null,null,"Unplanned - Hospital (Planned and unplanned episodes)","Partially Met","Service user only",null,"Hourly",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,null,"Other","White - Any other White background",null,null,"Carer known by association","Sensory Support: Support for visual impairment",null,"Tenant - private landlord","Not in Paid Employment (seeking work)","Unknown","Unknown","No visual impairment","Hard of hearing","Unknown","Joint Client and Social Care Funded","Service",null,null,null,null,"Admitted to hospital","Diversion from Hospital Services","Financial Assessment","No needs identified","Service user and carer","15 - 21 hrs",null,null,null,null,"Short Term Support: Other Short Term","Short Term Residential Care","CASSR Commissioned Support",null,null,"Unplanned - Carer related","Not Met","Service user and carer",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,null,"Unknown","Mixed - White and Black Caribbean",null,null,"Unknown","Sensory Support: Support for hearing impairment",null,"Settled mainstream housing with family / friends","Not in Paid Employment (not actively seeking work / retired)",null,null,"Visual impairment - severity unknown","No hearing impairment",null,"Fully Health Funded","Review",null,null,null,null,"Progress to Re-assessment / Unplanned Review","Community / Other route",null,null,null,"22 - 28 hrs",null,null,null,null,"Long Term Support: Nursing Care","Long Term Nursing Care","Self-Funder Metering Only",null,null,"Unplanned - Safeguarding concern",null,null,null,"Weekly",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,null,"Mixed - White and Black African",null,null,null,"Sensory Support: Support for dual impairment",null,"Supported accommodation / supported lodgings / supported group home","Not in Paid Employment (voluntary work only)",null,null,"Unknown","Hearing impairment - severity unknown",null,"Joint Health and Social Care Funded",null,null,null,null,null,"Progress to Support Planning / Services","Prison",null,null,null,"29 - 35 hrs",null,null,null,null,"Long Term Support: Residential Care","Long Term Residential Care",null,null,null,"Unplanned - Other Reason",null,null,null,"Fortnightly",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,null,"Mixed - White and Asian",null,null,null,"Support with Memory & Cognition",null,"Shared Lives scheme","Paid: Hours per week unknown",null,null,null,"Unknown",null,"Fully Social Care Funded",null,null,null,null,null,"Progress to End of Life Care","Self-Funder ",null,null,null,"36 - 42 hrs",null,null,null,null,"Long Term Support: Community","Home Support",null,null,null,"Unplanned - Provider Failure",null,null,null,"4-weekly",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,null,"Mixed - Any other mixed background",null,null,null,"Learning Disability Support",null,"Approved premises for offenders released from prison or under probation supervision","Unknown",null,null,null,null,null,"Unknown - System Level",null,null,null,null,null,"No change in package","Discharge from Reablement",null,null,null,"43 - 49 hrs",null,null,null,null,"Long Term Support: Prison","Day Support",null,null,null,"Unplanned - Change in Commissioning arrangements",null,null,null,"Monthly",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,null,"Asian or Asian British - Indian",null,null,null,"Mental Health Support",null,"Sheltered housing / extra care housing / other sheltered housing",null,null,null,null,null,null,"Unknown - Individual Level",null,null,null,null,null,"Service ended as planned","Transfer from Other LA",null,null,null,"50+ hrs",null,null,null,null,"Carer Support: Direct to Carer","Meals",null,null,null,null,null,null,null,"Quarterly",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,null,"Asian or Asian British - Pakistani",null,null,null,"Social Support: Substance misuse support",null,"Mobile accommodation for Gypsy / Roma and Traveller communities",null,null,null,null,null,null,null,null,null,null,null,null,"NFA - Moved to another LA",null,null,null,null,null,null,null,null,null,"Carer Support: Support involving the person cared-for","Transport",null,null,null,null,null,null,null,"Annually",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,null,"Asian or Asian British - Bangladeshi",null,null,null,"Social Support: Asylum seeker support",null,"Rough sleeper / squatting",null,null,null,null,null,null,null,null,null,null,null,null,"NFA - 100% NHS funded care",null,null,null,null,null,null,null,null,null,null,"Equipment",null,null,null,null,null,null,null,"One-off",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,null,"Asian or Asian British - Any other Asian background",null,null,null,"Social Support: Support for Social Isolation/Other",null,"Night shelter / emergency hostel / direct access hostel",null,null,null,null,null,null,null,null,null,null,null,null,"NFA - Self-funded client (Inc. 12wk disregard)",null,null,null,null,null,null,null,null,null,null,"Direct Payment",null,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,null,"Black or Black British - Caribbean",null,null,null,"Social Support: Support to Carer",null,"Refuge",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,"Shared Lives",null,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,null,"Black or Black British - African",null,null,null,"Unknown",null,"Placed in temporary accommodation by the council (inc. homelessness resettlement)",null,null,null,null,null,null,null,null,null,null,null,null,"NFA - Information & Advice / Signposting only",null,null,null,null,null,null,null,null,null,null,"Community Supported Living",null,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,null,"Black or Black British - Any other Black background",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,"NFA - Deceased",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,"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,null,"Other Ethnic Groups - Chinese",null,null,null,null,null,"Acute / long-term healthcare residential facility or hospital",null,null,null,null,null,null,null,null,null,null,null,null,"NFA - No services offered: Other reason",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,"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,null,"Other Ethnic Groups - Any other ethnic group",null,null,null,null,null,"Registered care home",null,null,null,null,null,null,null,null,null,null,null,null,"NFA - Support ended: Other reason",null,null,null,null,null,null,null,null,null,null,"Learning/Education/Employment Support",null,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,null,"Unknown",null,null,null,null,null,"Registered nursing home",null,null,null,null,null,null,null,null,null,null,null,null,"Progress to financial assessment ",null,null,null,null,null,null,null,null,null,null,"End of Life Care",null,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,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,"Provision of service",null,null,null,null,null,null,null,null,null,null,"Emergency Support",null,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,null,null,null,null,null,null,null,"Other temporary accommodation",null,null,null,null,null,null,null,null,null,null,null,null,"NFA- Other",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,null,20,"18-64"]
[null,null,null,null,null,null,null,null,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,"Other Long Term Support",null,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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Carer Respite",null,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,null,"Carer Sitting Service",null,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,null,"Carer Universal Services",null,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,null,"Other Carer Support",null,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,null,null,null,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,null,null,"Row",null,"Q2, 2020",null,null,null,null,27,"18-64"]
[null,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,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,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," ",null,"Q4, 2021",null,null,null,null,29,"18-64"]
[null,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,null,"Q1, 2021",null,null,null,null,30,"18-64"]
[null,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,null,"Q2, 2021",null,null,null,null,31,"18-64"]
[null,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,null,"Q3, 2021",null,null,null,null,32,"18-64"]
[null,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,null,"Q4, 2022",null,null,null,null,33,"18-64"]
[null,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,null,"Q1, 2022",null,null,null,null,34,"18-64"]
[null,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,null,"Q2, 2022",null,null,null,null,35,"18-64"]
[null,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,null,"Q3, 2022",null,null,null,null,36,"18-64"]
[null,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,null,"Q4, 2023",null,null,null,null,37,"18-64"]
[null,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,null,"Q1, 2023",null,null,null,null,38,"18-64"]
[null,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,null,"Q2, 2023",null,null,null,null,39,"18-64"]
[null,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,null,"Q3, 2023",null,null,null,null,40,"18-64"]
[null,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,null,"Q4, 2024",null,null,null,null,41,"18-64"]
[null,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,null,"Q1, 2024",null,null,null,null,42,"18-64"]
[null,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,null,"Q2, 2024",null,null,null,null,43,"18-64"]
[null,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,null,"Q3, 2024",null,null,null,null,44,"18-64"]
[null,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,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,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,null,null,47,"18-64"]
[null,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,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,null,null,49,"18-64"]
[null,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,null,50,"18-64"]
[null,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,null,51,"18-64"]
[null,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,null,52,"18-64"]
[null,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,null,53,"18-64"]
[null,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,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,null,null,55,"18-64"]
[null,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,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,null,null,57,"18-64"]
[null,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,null,58,"18-64"]
[null,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,null,59,"18-64"]
[null,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,null,60,"18-64"]
[null,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,null,61,"18-64"]
[null,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,null,62,"18-64"]
[null,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,null,63,"18-64"]
[null,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,null,64,"18-64"]
[null,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,null,65,"65+"]
[null,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,null,66,"65+"]
[null,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,null,67,"65+"]
[null,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,null,68,"65+"]
[null,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,null,69,"65+"]
[null,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,null,70,"65+"]
[null,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,null,71,"65+"]
[null,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,null,72,"65+"]
[null,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,null,73,"65+"]
[null,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,null,74,"65+"]
[null,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,null,75,"65+"]
[null,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,null,76,"65+"]
[null,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,null,null,140,"65+"]

{"sheet":"Formula","index":6,"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 / Unplanned Review","Progress to Support Planning / Services","Progress to End of Life Care","NFA - Deceased","NFA - Moved to another LA","NFA - 100% NHS funded care","NFA - Information & Advice / Signposting only","NFA - Self-funded client (inc 12wk disregard)","NFA - Support declined","NFA - No services offered: Other reason","Service ended as planned"]
["Assessment","Progress to Reablement/ST-Max","Progress to Support Planning / Services","Progress to End of Life Care","NFA - Deceased","NFA - Moved to another LA","NFA - 100% NHS funded care","NFA - Information & Advice / Signposting only","NFA - Self-funded client (inc 12wk disregard)","NFA - Support declined","NFA - No services offered: Other reason","Service ended as planned"]
["Service","Admitted to hospital","Progress to End of Life Care","NFA - Deceased","NFA - Moved to another LA","NFA - 100% NHS funded care","NFA - Information & Advice / Signposting only","NFA - Self-funded client (inc 12wk disregard)","NFA - Support declined","NFA - Support ended: Other reason","NFA - No services offered: Other reason","Service ended as planned","Progress to Assessment / Unplanned Review","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 - Moved to another LA","NFA - 100% NHS funded care","NFA - Self-funded client (inc 12wk disregard)","NFA - Support declined","NFA - Support ended: Other reason","Service ended as planned","Progress to Support Planning / 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)"]