{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Claim Adjustment Form","Date of Birth Ranges","Admin","Summary (READ ONLY)"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":2,"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":"Claim Adjustment Form","index":0,"n_rows":221,"n_cols":36,"rows_kept":221,"cut":false,"hidden":false,"merged":[[191,5,191,7],[191,8,191,9],[191,10,191,11],[191,12,191,13],[212,5,212,7],[212,8,212,10],[212,11,212,13],[213,5,213,7],[213,8,213,10],[213,11,213,13],[210,5,210,7],[210,8,210,9],[210,10,210,11],[210,12,210,13],[211,5,211,7],[211,8,211,9],[211,10,211,11],[211,12,211,13],[206,2,206,11],[206,13,206,19],[208,2,208,19],[197,2,197,3],[197,4,197,5],[197,6,197,11],[166,2,166,11],[166,13,166,19],[168,2,168,19],[171,2,171,4],[171,5,171,7],[171,8,171,9],[171,10,171,11],[171,12,171,13],[172,5,172,7],[172,8,172,10],[172,11,172,13],[157,2,157,3],[157,4,157,5],[157,6,157,11],[157,13,157,19],[159,2,159,19],[160,2,161,19],[164,5,164,10],[164,11,164,17],[164,18,164,19],[151,12,151,13],[137,2,137,3],[137,4,137,5],[137,6,137,11],[137,13,137,19],[139,2,139,19],[140,2,141,19],[144,5,144,10],[144,11,144,17],[144,18,144,19],[146,2,146,11],[146,13,146,19],[148,2,148,19],[99,2,99,19],[100,2,101,19],[97,2,97,3],[97,4,97,5],[113,5,113,7],[120,2,121,19],[124,5,124,10],[124,11,124,17],[124,18,124,19],[106,2,106,11],[106,13,106,19],[108,2,108,19],[130,12,130,13],[110,2,110,4],[110,5,110,7],[110,8,110,9],[110,10,110,11],[110,12,110,13],[126,2,126,11],[126,13,126,19],[128,2,128,19],[90,2,90,4],[90,5,90,7],[90,8,90,9],[90,10,90,11],[90,12,90,13],[84,11,84,17],[72,14,72,17],[73,14,73,17],[94,11,95,13],[31,10,31,11],[44,5,44,10],[44,11,44,17],[46,2,46,11],[48,2,48,19],[72,11,72,13],[73,5,73,7],[73,8,73,10],[73,11,73,13],[64,5,64,10],[64,11,64,17],[64,18,64,19],[66,2,66,11],[66,13,66,19],[68,2,68,19],[50,5,50,7],[50,8,50,9],[50,10,50,11],[50,12,50,13],[24,18,24,19],[28,2,28,19],[32,18,32,19],[32,14,32,17],[33,14,33,17],[33,18,33,19],[33,2,33,4],[26,2,26,11],[26,13,26,19],[30,12,30,13],[31,12,31,13],[32,5,32,7],[33,5,33,7],[32,8,32,10],[33,8,33,10],[32,11,32,13],[33,11,33,13],[30,2,30,4],[31,2,31,4],[30,8,30,9],[31,8,31,9],[30,5,30,7],[31,5,31,7],[30,10,30,11],[19,14,19,15],[3,3,4,19],[19,18,19,19],[7,5,7,12],[7,17,7,19],[11,6,11,12],[11,17,11,19],[13,4,13,12],[13,17,13,19],[15,2,15,19],[17,3,17,18],[19,2,19,8],[19,9,19,12],[16,3,16,18],[5,7,5,15],[21,2,21,19],[24,5,24,10],[24,11,24,17],[32,2,32,4],[84,18,84,19],[84,5,84,10],[86,2,86,11],[86,13,86,19],[88,2,88,19],[72,18,72,19],[59,2,59,19],[60,2,61,19],[51,2,51,4],[51,5,51,7],[51,8,51,9],[51,10,51,11],[51,12,51,13],[52,5,52,7],[52,8,52,10],[52,11,52,13],[53,5,53,7],[53,8,53,10],[53,11,53,13],[50,2,50,4],[30,1,35,1],[44,18,44,19],[40,2,41,19],[39,2,39,19],[53,14,53,17],[54,11,55,13],[57,2,57,3],[34,11,35,13],[34,2,35,4],[37,4,37,5],[37,13,37,19],[37,6,37,11],[37,2,37,3],[57,4,57,5],[57,6,57,11],[57,13,57,19],[46,13,46,19],[52,2,52,4],[52,14,52,17],[52,18,52,19],[53,2,53,4],[50,1,55,1],[53,18,53,19],[54,2,55,4],[70,1,75,1],[72,2,72,4],[73,2,73,4],[74,2,75,4],[74,11,75,13],[70,2,70,4],[70,5,70,7],[70,8,70,9],[80,2,81,19],[73,18,73,19],[77,2,77,3],[77,4,77,5],[77,6,77,11],[77,13,77,19],[79,2,79,19],[70,10,70,11],[70,12,70,13],[71,2,71,4],[71,5,71,7],[71,8,71,9],[71,10,71,11],[71,12,71,13],[72,5,72,7],[72,8,72,10],[90,1,95,1],[92,2,92,4],[92,14,92,17],[92,18,92,19],[93,2,93,4],[92,5,92,7],[104,5,104,10],[104,11,104,17],[104,18,104,19],[97,6,97,11],[97,13,97,19],[91,2,91,4],[91,5,91,7],[91,8,91,9],[91,10,91,11],[91,12,91,13],[92,8,92,10],[92,11,92,13],[93,5,93,7],[93,8,93,10],[93,11,93,13],[93,14,93,17],[93,18,93,19],[94,2,95,4],[110,1,115,1],[112,2,112,4],[112,14,112,17],[112,18,112,19],[114,2,115,4],[114,11,115,13],[113,8,113,10],[113,11,113,13],[119,2,119,19],[117,2,117,3],[117,4,117,5],[117,6,117,11],[117,13,117,19],[113,2,113,4],[113,14,113,17],[113,18,113,19],[111,2,111,4],[111,5,111,7],[111,8,111,9],[111,10,111,11],[111,12,111,13],[112,5,112,7],[112,8,112,10],[112,11,112,13],[130,1,135,1],[132,2,132,4],[132,14,132,17],[132,18,132,19],[133,2,133,4],[133,14,133,17],[133,18,133,19],[134,2,135,4],[134,11,135,13],[132,5,132,7],[132,8,132,10],[132,11,132,13],[133,5,133,7],[133,8,133,10],[133,11,133,13],[131,2,131,4],[131,5,131,7],[131,8,131,9],[131,10,131,11],[131,12,131,13],[130,2,130,4],[130,5,130,7],[130,8,130,9],[130,10,130,11],[150,1,155,1],[152,2,152,4],[152,14,152,17],[152,18,152,19],[153,2,153,4],[153,14,153,17],[153,18,153,19],[154,2,155,4],[154,11,155,13],[152,5,152,7],[152,8,152,10],[152,11,152,13],[153,5,153,7],[153,8,153,10],[153,11,153,13],[150,2,150,4],[150,5,150,7],[150,8,150,9],[150,10,150,11],[150,12,150,13],[151,2,151,4],[151,5,151,7],[151,8,151,9],[151,10,151,11],[170,1,175,1],[172,2,172,4],[172,14,172,17],[172,18,172,19],[173,2,173,4],[173,14,173,17],[173,18,173,19],[174,2,175,4],[174,11,175,13],[170,2,170,4],[170,5,170,7],[170,8,170,9],[170,10,170,11],[170,12,170,13],[173,5,173,7],[173,8,173,10],[173,11,173,13],[177,2,177,3],[177,4,177,5],[177,6,177,11],[177,13,177,19],[179,2,179,19],[180,2,181,19],[184,5,184,10],[184,11,184,17],[184,18,184,19],[186,2,186,11],[186,13,186,19],[188,2,188,19],[190,1,195,1],[192,2,192,4],[192,14,192,17],[192,18,192,19],[193,2,193,4],[193,14,193,17],[193,18,193,19],[194,2,195,4],[194,11,195,13],[192,5,192,7],[192,8,192,10],[192,11,192,13],[193,5,193,7],[193,8,193,10],[193,11,193,13],[190,2,190,4],[190,5,190,7],[190,8,190,9],[190,10,190,11],[190,12,190,13],[191,2,191,4],[197,13,197,19],[199,2,199,19],[200,2,201,19],[204,5,204,10],[204,11,204,17],[204,18,204,19],[210,1,215,1],[212,2,212,4],[212,14,212,17],[212,18,212,19],[213,2,213,4],[210,2,210,4],[211,2,211,4],[220,2,221,19],[213,14,213,17],[213,18,213,19],[214,2,215,4],[214,11,215,13],[217,2,217,3],[217,4,217,5],[217,6,217,11],[217,13,217,19],[219,2,219,19]]}
[]
[]
[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":"TODAY()","v":"2026-01-09"},"Adjustment Reason List","Adjustment Resent Comments","Gender","SEN","Ethinicity","Yes/No list","Offer Type","Term","Year","Hours"]
[null,null,null,"FE FUNDING CLAIM FORM ADJUSTMENT SHEET (CF4)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"New Starter/Adding a child to a claim","As the child has attended and claimed funding at another setting this term, funding can only be moved at half term or at the start of next term unless under exceptional circumstances.  \nExceptional circumstances must be agreed by the funding team before a claim is made.\nPlease be aware if the child has claimed on a different offer type previously, the hours may have to be restricted.","M","N","ABAN","Yes","Term Time","Spring Term",2024,15,30]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Child leaving/not claiming for the term","The leaving date should be the last day they actually attended for funded hours.  \nThere can be no notice period for any funded hours.  \nIf you have a signed PPA and the child has attended for funded hours this term, the funding will continue until half term (If they left before half term) or the end of term (if they left during the second half of term)","F","K","AIND","No","Stretched","Summer Term",2025,14.75,29.75]
[null,null,null,null,null,null,null,"Please upload completed CF4 forms via AnyComms (choose FFE Funding for File Type)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Change of hours claimed","Please put the full amount of hours you are now claiming in the relevant fields and the original hours you claimed in the Previous hours fields.  If they have used the new hours at another setting this term your funding may be restricted.",null,"E","AOTH",null,null,"Autumn Term",2026,14.5,29.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Change to childs personal details","Please complete the child's details and state in the additional comments field what has changed.",null,null,"APKN",null,null,null,2027,14.25,29.25]
[null,null,"Setting Name",null,null,null,null,null,null,null,null,null,null,null,"Funding URN",null,null,null,null,null,null,null,null,null,null,"Claiming for DAF Funding","Please ensure you have uploaded a copy of their Disability Living Allowance agreement via AnyComms",null,null,"BAFR",null,null,null,null,14,29]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"As the child has not attended and claimed funding at another setting this term, funding can be claimed from the date from when they start with you assuming they are eligible to do so for this term.  \nPlease be aware if the child has claimed on a different offer type previously, the hours may have to be restricted.",null,null,"BCRB",null,null,null,null,13.75,28.75]
[null,null,"By completing this form you are confirming that all information provided is accurate and a true reflection of your service provision.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"BOTH",null,null,null,null,13.5,28.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CHNE",null,null,null,null,13.25,28.25]
[null,null,"Name of Person completing the form",null,null,null,null,null,null,null,null,null,null,null,"Date",null,null,null,null,null,null,null,null,null,null,null,"date comments",null,null,"MOTH",null,null,null,null,13,28]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Please state the date when funding will be starting from",null,null,"MWAS",null,null,null,null,12.75,27.75]
[null,null,"email address",null,null,null,null,null,null,null,null,null,null,null,"Telephone No.",null,null,null,null,null,null,null,null,null,null,null,"Please state the date the change of hours took effect from",null,null,"MWBA",null,null,null,null,12.5,27.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Please state the last attended date for funded hours",null,null,"MWBC",null,null,null,null,12.25,27.25]
[null,null,"Please make sure you choose the correct term that the adjustment is for and the reason for the adjustment.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Has this child attended and claimed funding from another provider for this term?","Yes",null,null,"NOBT",null,{"$f":"CONCATENATE(J20,\" \",S20)","v":" "},null,null,12,27]
[null,null,null,"      Please complete a separate amendment sheet for each different term.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Do you have a signed Parent Provider Agreement (PPA)?","No",null,null,"OOTH",null,{"$f":"VLOOKUP($AF$16,Admin!A:F,6,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP($AF$16,Admin!A:H,8,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP($AF$16,Admin!A:J,10,FALSE)","v":{"$error":"#N/A"}},11.75,26.75]
[null,null,null,"  Please consult the Buckinghamshire Council's guidance on \"Local management of the Funded Entitlement for 9 months to 4-year-olds\"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"If hours are increasing, has this child claimed for these extra hours from another provider for this term?","N/A",null,null,"REFU",null,{"$f":"VLOOKUP($AF$16,Admin!A:F,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP($AF$16,Admin!A:F,3,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP($AF$16,Admin!A:K,11,FALSE)","v":{"$error":"#N/A"}},11.5,26.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Have you uploaded evidence of Disability Living Allowance?","Unknown",null,null,"WBRI",null,null,null,null,11.25,26.25]
[null,null,"The term this adjustment is for is",null,null,null,null,null,null,null,null,null,null,null,"and the year",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"WIRI",null,null,null,null,11,26]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"WIRT",null,null,null,null,10.75,25.75]
[null,null,"Please select the correct reason for the adjustment and the date that it took effect from for each child",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"WOTH",null,null,null,null,10.5,25.5]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"WROM",null,null,null,null,10.25,25.25]
[1,null,"Reason for adjustment",null,null,null,null,null,null,null,null,{"$f":"IF(F25=$Z$4,$AA$13,IF(F25=$Z$6,$AA$14,IF(F25=$Z$5,$AA$15,\"\")))","v":""},null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND($F25=$Z$4,$S25=\"\"),\"1\",IF(AND($F25=$Z$5,$S25=\"\"),\"1\",IF(AND($F25=$Z$6,$S25=\"\"),\"1\",\"0\")))","v":"0"},null,null,null,null,null,null,null,null,null,null,null,10,25]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9.75,24.75]
["1a",null,{"$f":"IF(F25=$Z$4,$Z$16,IF(F25=$Z$6,$Z$18,IF(F25=$Z$8,$Z$19,IF(F25=$Z$5,$Z$17,\"\"))))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND($F25=$Z$4,$M27=\"\"),\"1\",IF(AND($F25=$Z$5,$M27=\"\"),\"1\",IF(AND($F25=$Z$6,$M27=\"\"),\"1\",IF(AND($F25=$Z$8,$M27=\"\"),\"1\",\"0\"))))","v":"0"},null,null,null,null,null,null,null,null,null,null,null,9.5,24.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9.25,24.25]
[null,null,{"$f":"IF(AND(F25=$Z$4,M27=$AA$16),$AA$4,IF(AND(F25=$Z$4,M27=$AA$17),$AA$9,IF(F25=$Z$5,$AA$5,IF(F25=$Z$6,$AA$6,IF(F25=$Z$7,$AA$7,IF(F25=$Z$8,$AA$8,\"\"))))))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9,24]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8.75,23.75]
[null,{"$f":"IF(F25=\"\",\"\",IF(AND($F25=$Z$4,$AH32=\"Complete\"),\"Complete Record\",IF(AND($F25=$Z$5,$AH34=\"Complete\"),\"Complete Record\",IF(AND($F25=$Z$6,$AH36=\"Complete\"),\"Complete Record\",IF(AND($F25=$Z$7,$AH39=\"Complete\"),\"Complete Record\",IF(AND($F25=$Z$8,$AH41=\"Complete\"),\"Complete Record\",\"Incomplete Record\"))))))","v":""},"Legal Surname",null,null,"Legal Forename",null,null,"Middle Name",null,"Preferred surname",null,"Preferred forename",null,"DOB\n(DD/MM/YYYY)","Gender","Ethnicity","SEN","Armed Forces Family","In Receipt of DLA",null,null,"Legal Surname","Legal forename","Middle Name","preferred surname","preferred forename","DOB","Gender","Ethnicity","SEN","Armed Forces","DLA","new starter complete?",8.5,23.5]
["1b",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($F25=\"\",0,IF(AND($F25<>\"\",$C32<>\"\"),\"0\",\"1\"))","v":0},{"$f":"IF($F25=\"\",0,IF(AND($F25<>\"\",$F32<>\"\"),\"0\",\"1\"))","v":0},null,{"$f":"IF($F25=\"\",0,IF(AND($F25<>\"\",$K32<>\"\"),\"0\",\"1\"))","v":0},{"$f":"IF($F25=\"\",0,IF(AND($F25<>\"\",$M32<>\"\"),\"0\",\"1\"))","v":0},{"$f":"IF($F25=\"\",0,IF(AND($F25<>\"\",$O32<>\"\"),\"0\",\"1\"))","v":0},{"$f":"IF($F25=\"\",0,IF(AND($F25<>\"\",$P32<>\"\"),\"0\",\"1\"))","v":0},{"$f":"IF($F25=\"\",0,IF(AND($F25<>\"\",$Q32<>\"\"),\"0\",\"1\"))","v":0},{"$f":"IF($F25=\"\",0,IF(AND($F25<>\"\",$R32<>\"\"),\"0\",\"1\"))","v":0},{"$f":"IF($F25=\"\",0,IF(AND($F25<>\"\",$S32<>\"\"),\"0\",\"1\"))","v":0},{"$f":"IF($F25=\"\",0,IF(AND($F25<>\"\",$T32<>\"\"),\"0\",\"1\"))","v":0},{"$f":"IF(W25+W27+W32+X32+Y32+Z32+AA32+AB32+AC32+AD32+AE32+AF32+AG32+W34+X34+Y34+Z34+AA34+W36+X36+Y36+Z36+AA36+W38+X38+AG36+AB38>0,\"Incomplete\",\"Complete\")","v":"Complete"},8.25,23.25]
[null,null,"No. of Flat/Apart.",null,null,"House No./Name",null,null,"Street",null,null,"Local Area",null,null,"Town",null,null,null,"Postcode",null,null,null,"no. Flat","House No.","Street","Town","Postcode",null,"need hours completed?","need previous hours completed","need new residual","need prev residual","AGE","Leaving complete?",8,23]
["1c",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($F25=\"\",0,IF(AND($F25<>\"\",$C34=\"\",$F34=\"\"),\"1\",\"0\"))","v":0},null,{"$f":"IF($F25=\"\",0,IF(AND($F25<>\"\",$I34<>\"\"),\"0\",\"1\"))","v":0},{"$f":"IF($F25=\"\",0,IF(AND($F25<>\"\",$O34<>\"\"),\"0\",\"1\"))","v":0},{"$f":"IF($F25=\"\",0,IF(AND($F25<>\"\",$S34<>\"\"),\"0\",\"1\"))","v":0},null,{"$f":"IF(OR($F25=$Z$4,$F25=$Z$6),1,\"0\")","v":"0"},{"$f":"IF($F25=$Z$6,1,\"0\")","v":"0"},{"$f":"IF($F36=\"stretched\",1,\"0\")","v":"0"},{"$f":"IF($O36=\"stretched\",1,\"0\")","v":"0"},{"$f":"IF(O32=\"\",\"\",IF(O32=$AF$17,2,IF(O32=$AG$17,1,(INT(($AH$17-O32)/365.25)))))","v":""},{"$f":"IF(W25+W27+W32+X32+Y32+Z32+AA32+AB32+AC32+AD32+AE32+AF32+AG32+W34+X34+Y34+Z34+AA34+X38>0,\"Incomplete\",\"Complete\")","v":"Complete"},7.75,22.75]
[null,null,{"$f":"IF($F25=$Z$5,\"Claimed Hours\",\"New Claimed Hours\")","v":"New Claimed Hours"},null,null,"Offer Type","Funded Hours\n(Universal and Dis 2's)","Extended hours\n(3&4 Yr Olds)","Expanded hours\n(WP 2's and Under 2's)","No. of Weeks Claiming","Residual Hours?","Previously Claimed hours\n(what was on your last claim/adjustment form)",null,null,"Offer Type","Funded Hours\n(Universal and Dis 2's)","Extended hours\n(3&4 Yr Olds)","Expanded hours\n(WP 2's and Under 2's)","Number of Weeks","Residual Hours?",null,null,"New offer Type","New Funded","New extended","new weeks","new residual","prev offer","prev funded","prev extended","prev weeks","prev residual","New expanded","change of hours complete?",7.5,22.5]
["1d",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($F25=\"\",0,IF(AND($F25<>\"\",$F36<>\"\"),\"0\",\"1\"))","v":0},{"$f":"IF($F25=\"\",0,IF(AND($F25<>\"\",OR($G36<>\"\",H36<>\"\",$I36<>\"\")),\"0\",\"1\"))","v":0},{"$f":"IF($F25=\"\",0,IF(AND($F25<>\"\",OR($G36<>\"\",H36<>\"\",$I36<>\"\")),\"0\",\"1\"))","v":0},{"$f":"IF($F25=\"\",0,IF(AND($F25<>\"\",$J36<>\"\"),\"0\",\"1\"))","v":0},{"$f":"IF($F25=\"\",0,IF(AND(F36=\"Stretched\",$K36=\"\"),\"1\",\"0\"))","v":0},{"$f":"IF($F25=\"\",0,IF(AND($F25<>\"\",$O36<>\"\"),\"0\",\"1\"))","v":0},{"$f":"IF($F25=\"\",0,IF(AND($F25<>\"\",OR(P36<>\"\",Q36<>\"\",R36<>\"\")),\"0\",\"1\"))","v":0},{"$f":"IF($F25=\"\",0,IF(AND($F25<>\"\",OR(P36<>\"\",Q36<>\"\",R36<>\"\")),\"0\",\"1\"))","v":0},{"$f":"IF($F25=\"\",0,IF(AND($F25<>\"\",$S36<>\"\"),\"0\",\"1\"))","v":0},{"$f":"IF($F25=\"\",0,IF(AND(O36=\"Stretched\",T36=\"\"),\"1\",\"0\"))","v":0},{"$f":"IF($F25=\"\",0,IF(AND($F25<>\"\",OR($G36<>\"\",H36<>\"\",$I36<>\"\")),\"0\",\"1\"))","v":0},{"$f":"IF(W25+W27+W32+X32+Y32+Z32+AA32+AB32+AC32+AD32+AE32+AF32+AG32+W34+X34+Y34+Z34+AA34+W36+X36+Y36+Z36+AA36+W38+X38+AB36+AC36+AD36+AE36+AF36+AG36+AG39+AB38>0,\"Incomplete\",\"Complete\")","v":"Complete"},7.25,22.25]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Code","portal",null,null,null,null,null,null,null,null,null,null,7,22]
["1e",null,"Eligibility Code",null,null,null,"Has the code been checked on your eligibility code portal?",null,null,null,null,null,null,{"$f":"CONCATENATE(\"Please ensure that the code is valid for \",$J$20,\" \",$S$20)","v":"Please ensure that the code is valid for  "},null,null,null,null,null,null,null,null,{"$f":"IF(AND($I36>0.1,$E38=\"\"),\"1\",\"0\")","v":"0"},{"$f":"IF(AND($E38>10000000000,$E38<60000000000,$M38=\"\"),\"1\",\"0\")","v":"0"},"Max funded Hours",{"$f":"IF(AG34=2,15,IF(AG34<2,0,15))","v":15},{"$f":"IF(AG34=2,12.5,IF(AG34<2,0,12.5))","v":12.5},{"$f":"IF(AND($H36>0.1,$E38=\"\"),\"1\",\"0\")","v":"0"},null,null,null,null,"previous expanded","change childs details complete?",6.75,21.75]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Max Extended hours",{"$f":"IF(AG34=2,0,IF(AG34<2,0,15))","v":15},{"$f":"IF(AG34=2,0,IF(AG34<2,0,12.5))","v":12.5},null,null,null,null,null,{"$f":"IF($F25=\"\",0,IF(AND($F25<>\"\",OR(P36<>\"\",Q36<>\"\",R36<>\"\")),\"0\",\"1\"))","v":0},{"$f":"IF(W32+X32+Y32+Z32+AA32+AB32+AC32+AD32+AE32+AF32+AG32+W34+X34+Y34+Z34+AA34>0,\"Incomplete\",\"Complete\")","v":"Complete"},6.5,21.5]
[null,null,"Any Additional Comments?",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Max Expanded hours",{"$f":"IF(AG34=\"\",30,IF(AG34>2,0,30))","v":30},{"$f":"IF(AG34=\"\",25,IF(AG34>2,0,25))","v":25},null,null,null,null,null,null,"DAF Complete?",6.25,21.25]
["1f",null,null,null,null,null,null,null,null,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":"IF(W27+W32+X32+Y32+Z32+AA32+AB32+AC32+AD32+AE32+AF32+AG32+W34+X34+Y34+Z34+AA34>0,\"Incomplete\",\"Complete\")","v":"Complete"},6,21]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5.75,20.75]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5.5,20.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5.25,20.25]
[2,null,"Reason for adjustment",null,null,null,null,null,null,null,null,{"$f":"IF(F45=$Z$4,$AA$13,IF(F45=$Z$6,$AA$14,IF(F45=$Z$5,$AA$15,\"\")))","v":""},null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND($F45=$Z$4,$S45=\"\"),\"1\",IF(AND($F45=$Z$5,$S45=\"\"),\"1\",IF(AND($F45=$Z$6,$S45=\"\"),\"1\",\"0\")))","v":"0"},null,null,null,null,null,null,null,null,null,null,null,5,20]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4.75,19.75]
["2a",null,{"$f":"IF(F45=$Z$4,$Z$16,IF(F45=$Z$6,$Z$18,IF(F45=$Z$8,$Z$19,IF(F45=$Z$5,$Z$17,\"\"))))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND($F45=$Z$4,$M47=\"\"),\"1\",IF(AND($F45=$Z$5,$M47=\"\"),\"1\",IF(AND($F45=$Z$6,$M47=\"\"),\"1\",IF(AND($F45=$Z$8,$M47=\"\"),\"1\",\"0\"))))","v":"0"},null,null,null,null,null,null,null,null,null,null,null,4.5,19.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4.25,19.25]
[null,null,{"$f":"IF(AND(F45=$Z$4,M47=$AA$16),$AA$4,IF(AND(F45=$Z$4,M47=$AA$17),$AA$9,IF(F45=$Z$5,$AA$5,IF(F45=$Z$6,$AA$6,IF(F45=$Z$7,$AA$7,IF(F45=$Z$8,$AA$8,\"\"))))))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4,19]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3.75,18.75]
[null,{"$f":"IF(F45=\"\",\"\",IF(AND($F45=$Z$4,$AH52=\"Complete\"),\"Complete Record\",IF(AND($F45=$Z$5,$AH54=\"Complete\"),\"Complete Record\",IF(AND($F45=$Z$6,$AH56=\"Complete\"),\"Complete Record\",IF(AND($F45=$Z$7,$AH59=\"Complete\"),\"Complete Record\",IF(AND($F45=$Z$8,$AH61=\"Complete\"),\"Complete Record\",\"Incomplete Record\"))))))","v":""},"Legal Surname",null,null,"Legal Forename",null,null,"Middle Name",null,"Preferred surname",null,"Preferred forename",null,"DOB\n(DD/MM/YYYY)","Gender","Ethnicity","SEN","Armed Forces Family","In Receipt of DLA",null,null,"Legal Surname","Legal forename","Middle Name","preferred surname","preferred forename","DOB","Gender","Ethnicity","SEN","Armed Forces","DLA","new starter complete?",3.5,18.5]
["2b",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($F45=\"\",0,IF(AND($F45<>\"\",$C52<>\"\"),\"0\",\"1\"))","v":0},{"$f":"IF($F45=\"\",0,IF(AND($F45<>\"\",$F52<>\"\"),\"0\",\"1\"))","v":0},null,{"$f":"IF($F45=\"\",0,IF(AND($F45<>\"\",$K52<>\"\"),\"0\",\"1\"))","v":0},{"$f":"IF($F45=\"\",0,IF(AND($F45<>\"\",$M52<>\"\"),\"0\",\"1\"))","v":0},{"$f":"IF($F45=\"\",0,IF(AND($F45<>\"\",$O52<>\"\"),\"0\",\"1\"))","v":0},{"$f":"IF($F45=\"\",0,IF(AND($F45<>\"\",$P52<>\"\"),\"0\",\"1\"))","v":0},{"$f":"IF($F45=\"\",0,IF(AND($F45<>\"\",$Q52<>\"\"),\"0\",\"1\"))","v":0},{"$f":"IF($F45=\"\",0,IF(AND($F45<>\"\",$R52<>\"\"),\"0\",\"1\"))","v":0},{"$f":"IF($F45=\"\",0,IF(AND($F45<>\"\",$S52<>\"\"),\"0\",\"1\"))","v":0},{"$f":"IF($F45=\"\",0,IF(AND($F45<>\"\",$T52<>\"\"),\"0\",\"1\"))","v":0},{"$f":"IF(W45+W47+W52+X52+Y52+Z52+AA52+AB52+AC52+AD52+AE52+AF52+AG52+W54+X54+Y54+Z54+AA54+W56+X56+Y56+Z56+AA56+W58+X58+AG56+AB58>0,\"Incomplete\",\"Complete\")","v":"Complete"},3.25,18.25]
[null,null,"No. of Flat/Apart.",null,null,"House No./Name",null,null,"Street",null,null,"Local Area",null,null,"Town",null,null,null,"Postcode",null,null,null,"no. Flat","House No.","Street","Town","Postcode",null,"need hours completed?","need previous hours completed","need new residual","need prev residual","AGE","Leaving complete?",3,18]
["2c",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($F45=\"\",0,IF(AND($F45<>\"\",$C54=\"\",$F54=\"\"),\"1\",\"0\"))","v":0},null,{"$f":"IF($F45=\"\",0,IF(AND($F45<>\"\",$I54<>\"\"),\"0\",\"1\"))","v":0},{"$f":"IF($F45=\"\",0,IF(AND($F45<>\"\",$O54<>\"\"),\"0\",\"1\"))","v":0},{"$f":"IF($F45=\"\",0,IF(AND($F45<>\"\",$S54<>\"\"),\"0\",\"1\"))","v":0},null,{"$f":"IF(OR($F45=$Z$4,$F45=$Z$6),1,\"0\")","v":"0"},{"$f":"IF($F45=$Z$6,1,\"0\")","v":"0"},{"$f":"IF($F56=\"stretched\",1,\"0\")","v":"0"},{"$f":"IF($O56=\"stretched\",1,\"0\")","v":"0"},{"$f":"IF(O52=\"\",\"\",IF(O52=$AF$17,2,IF(O52=$AG$17,1,(INT(($AH$17-O52)/365.25)))))","v":""},{"$f":"IF(W45+W47+W52+X52+Y52+Z52+AA52+AB52+AC52+AD52+AE52+AF52+AG52+W54+X54+Y54+Z54+AA54+X58>0,\"Incomplete\",\"Complete\")","v":"Complete"},2.75,17.75]
[null,null,{"$f":"IF($F45=$Z$5,\"Claimed Hours\",\"New Claimed Hours\")","v":"New Claimed Hours"},null,null,"Offer Type","Funded Hours\n(Universal and Dis 2's)","Extended hours\n(3&4 Yr Olds)","Expanded hours\n(WP 2's and Under 2's)","No. of Weeks Claiming","Residual Hours?","Previously Claimed hours\n(what was on your last claim/adjustment form)",null,null,"Offer Type","Funded Hours\n(Universal and Dis 2's)","Extended hours\n(3&4 Yr Olds)","Expanded hours\n(WP 2's and Under 2's)","Number of Weeks","Residual Hours?",null,null,"New offer Type","New Funded","New extended","new weeks","new residual","prev offer","prev funded","prev extended","prev weeks","prev residual","New expanded","change of hours complete?",2.5,17.5]
["2d",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($F45=\"\",0,IF(AND($F45<>\"\",$F56<>\"\"),\"0\",\"1\"))","v":0},{"$f":"IF($F45=\"\",0,IF(AND($F45<>\"\",OR($G56<>\"\",H56<>\"\",$I56<>\"\")),\"0\",\"1\"))","v":0},{"$f":"IF($F45=\"\",0,IF(AND($F45<>\"\",OR($G56<>\"\",H56<>\"\",$I56<>\"\")),\"0\",\"1\"))","v":0},{"$f":"IF($F45=\"\",0,IF(AND($F45<>\"\",$J56<>\"\"),\"0\",\"1\"))","v":0},{"$f":"IF($F45=\"\",0,IF(AND(F56=\"Stretched\",$K56=\"\"),\"1\",\"0\"))","v":0},{"$f":"IF($F45=\"\",0,IF(AND($F45<>\"\",$O56<>\"\"),\"0\",\"1\"))","v":0},{"$f":"IF($F45=\"\",0,IF(AND($F45<>\"\",OR(P56<>\"\",Q56<>\"\",R56<>\"\")),\"0\",\"1\"))","v":0},{"$f":"IF($F45=\"\",0,IF(AND($F45<>\"\",OR(P56<>\"\",Q56<>\"\",R56<>\"\")),\"0\",\"1\"))","v":0},{"$f":"IF($F45=\"\",0,IF(AND($F45<>\"\",$S56<>\"\"),\"0\",\"1\"))","v":0},{"$f":"IF($F45=\"\",0,IF(AND(O56=\"Stretched\",T56=\"\"),\"1\",\"0\"))","v":0},{"$f":"IF($F45=\"\",0,IF(AND($F45<>\"\",OR($G56<>\"\",H56<>\"\",$I56<>\"\")),\"0\",\"1\"))","v":0},{"$f":"IF(W45+W47+W52+X52+Y52+Z52+AA52+AB52+AC52+AD52+AE52+AF52+AG52+W54+X54+Y54+Z54+AA54+W56+X56+Y56+Z56+AA56+W58+X58+AB56+AC56+AD56+AE56+AF56+AG56+AG59+AB58>0,\"Incomplete\",\"Complete\")","v":"Complete"},2.25,17.25]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Code","portal",null,null,null,null,null,null,null,null,null,null,2,17]
["2e",null,"Eligibility Code",null,null,null,"Has the code been checked on your eligibility code portal?",null,null,null,null,null,null,{"$f":"CONCATENATE(\"Please ensure that the code is valid for \",$J$20,\" \",$S$20)","v":"Please ensure that the code is valid for  "},null,null,null,null,null,null,null,null,{"$f":"IF(AND($I56>0.1,$E58=\"\"),\"1\",\"0\")","v":"0"},{"$f":"IF(AND($E58>10000000000,$E58<60000000000,$M58=\"\"),\"1\",\"0\")","v":"0"},"Max funded Hours",{"$f":"IF(AG54=2,15,IF(AG54<2,0,15))","v":15},{"$f":"IF(AG54=2,12.5,IF(AG54<2,0,12.5))","v":12.5},{"$f":"IF(AND($H56>0.1,$E58=\"\"),\"1\",\"0\")","v":"0"},null,null,null,null,"previous expanded","change childs details complete?",1.75,16.75]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Max Extended hours",{"$f":"IF(AG54=2,0,IF(AG54<2,0,15))","v":15},{"$f":"IF(AG54=2,0,IF(AG54<2,0,12.5))","v":12.5},null,null,null,null,null,{"$f":"IF($F45=\"\",0,IF(AND($F45<>\"\",OR(P56<>\"\",Q56<>\"\",R56<>\"\")),\"0\",\"1\"))","v":0},{"$f":"IF(W52+X52+Y52+Z52+AA52+AB52+AC52+AD52+AE52+AF52+AG52+W54+X54+Y54+Z54+AA54>0,\"Incomplete\",\"Complete\")","v":"Complete"},1.5,16.5]
[null,null,"Any Additional Comments?",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Max Expanded hours",{"$f":"IF(AG54=\"\",30,IF(AG54>2,0,30))","v":30},{"$f":"IF(AG54=\"\",25,IF(AG54>2,0,25))","v":25},null,null,null,null,null,null,"DAF Complete?",1.25,16.25]
["2f",null,null,null,null,null,null,null,null,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":"IF(W47+W52+X52+Y52+Z52+AA52+AB52+AC52+AD52+AE52+AF52+AG52+W54+X54+Y54+Z54+AA54>0,\"Incomplete\",\"Complete\")","v":"Complete"},1,16]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.75,15.75]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.5,15.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.25,15.25]
[3,null,"Reason for adjustment",null,null,null,null,null,null,null,null,{"$f":"IF(F65=$Z$4,$AA$13,IF(F65=$Z$6,$AA$14,IF(F65=$Z$5,$AA$15,\"\")))","v":""},null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND($F65=$Z$4,$S65=\"\"),\"1\",IF(AND($F65=$Z$5,$S65=\"\"),\"1\",IF(AND($F65=$Z$6,$S65=\"\"),\"1\",\"0\")))","v":"0"},null,null,null,null,null,null,null,null,null,null,null,0,15]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,14.75]
["3a",null,{"$f":"IF(F65=$Z$4,$Z$16,IF(F65=$Z$6,$Z$18,IF(F65=$Z$8,$Z$19,IF(F65=$Z$5,$Z$17,\"\"))))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND($F65=$Z$4,$M67=\"\"),\"1\",IF(AND($F65=$Z$5,$M67=\"\"),\"1\",IF(AND($F65=$Z$6,$M67=\"\"),\"1\",IF(AND($F65=$Z$8,$M67=\"\"),\"1\",\"0\"))))","v":"0"},null,null,null,null,null,null,null,null,null,null,null,null,14.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,14.25]
[null,null,{"$f":"IF(AND(F65=$Z$4,M67=$AA$16),$AA$4,IF(AND(F65=$Z$4,M67=$AA$17),$AA$9,IF(F65=$Z$5,$AA$5,IF(F65=$Z$6,$AA$6,IF(F65=$Z$7,$AA$7,IF(F65=$Z$8,$AA$8,\"\"))))))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,14]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,13.75]
[null,{"$f":"IF(F65=\"\",\"\",IF(AND($F65=$Z$4,$AH72=\"Complete\"),\"Complete Record\",IF(AND($F65=$Z$5,$AH74=\"Complete\"),\"Complete Record\",IF(AND($F65=$Z$6,$AH76=\"Complete\"),\"Complete Record\",IF(AND($F65=$Z$7,$AH79=\"Complete\"),\"Complete Record\",IF(AND($F65=$Z$8,$AH81=\"Complete\"),\"Complete Record\",\"Incomplete Record\"))))))","v":""},"Legal Surname",null,null,"Legal Forename",null,null,"Middle Name",null,"Preferred surname",null,"Preferred forename",null,"DOB\n(DD/MM/YYYY)","Gender","Ethnicity","SEN","Armed Forces Family","In Receipt of DLA",null,null,"Legal Surname","Legal forename","Middle Name","preferred surname","preferred forename","DOB","Gender","Ethnicity","SEN","Armed Forces","DLA","new starter complete?",null,13.5]
["3b",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($F65=\"\",0,IF(AND($F65<>\"\",$C72<>\"\"),\"0\",\"1\"))","v":0},{"$f":"IF($F65=\"\",0,IF(AND($F65<>\"\",$F72<>\"\"),\"0\",\"1\"))","v":0},null,{"$f":"IF($F65=\"\",0,IF(AND($F65<>\"\",$K72<>\"\"),\"0\",\"1\"))","v":0},{"$f":"IF($F65=\"\",0,IF(AND($F65<>\"\",$M72<>\"\"),\"0\",\"1\"))","v":0},{"$f":"IF($F65=\"\",0,IF(AND($F65<>\"\",$O72<>\"\"),\"0\",\"1\"))","v":0},{"$f":"IF($F65=\"\",0,IF(AND($F65<>\"\",$P72<>\"\"),\"0\",\"1\"))","v":0},{"$f":"IF($F65=\"\",0,IF(AND($F65<>\"\",$Q72<>\"\"),\"0\",\"1\"))","v":0},{"$f":"IF($F65=\"\",0,IF(AND($F65<>\"\",$R72<>\"\"),\"0\",\"1\"))","v":0},{"$f":"IF($F65=\"\",0,IF(AND($F65<>\"\",$S72<>\"\"),\"0\",\"1\"))","v":0},{"$f":"IF($F65=\"\",0,IF(AND($F65<>\"\",$T72<>\"\"),\"0\",\"1\"))","v":0},{"$f":"IF(W65+W67+W72+X72+Y72+Z72+AA72+AB72+AC72+AD72+AE72+AF72+AG72+W74+X74+Y74+Z74+AA74+W76+X76+Y76+Z76+AA76+W78+X78+AG76+AB78>0,\"Incomplete\",\"Complete\")","v":"Complete"},null,13.25]
[null,null,"No. of Flat/Apart.",null,null,"House No./Name",null,null,"Street",null,null,"Local Area",null,null,"Town",null,null,null,"Postcode",null,null,null,"no. Flat","House No.","Street","Town","Postcode",null,"need hours completed?","need previous hours completed","need new residual","need prev residual","AGE","Leaving complete?",null,13]
["3c",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($F65=\"\",0,IF(AND($F65<>\"\",$C74=\"\",$F74=\"\"),\"1\",\"0\"))","v":0},null,{"$f":"IF($F65=\"\",0,IF(AND($F65<>\"\",$I74<>\"\"),\"0\",\"1\"))","v":0},{"$f":"IF($F65=\"\",0,IF(AND($F65<>\"\",$O74<>\"\"),\"0\",\"1\"))","v":0},{"$f":"IF($F65=\"\",0,IF(AND($F65<>\"\",$S74<>\"\"),\"0\",\"1\"))","v":0},null,{"$f":"IF(OR($F65=$Z$4,$F65=$Z$6),1,\"0\")","v":"0"},{"$f":"IF($F65=$Z$6,1,\"0\")","v":"0"},{"$f":"IF($F76=\"stretched\",1,\"0\")","v":"0"},{"$f":"IF($O76=\"stretched\",1,\"0\")","v":"0"},{"$f":"IF(O72=\"\",\"\",IF(O72=$AF$17,2,IF(O72=$AG$17,1,(INT(($AH$17-O72)/365.25)))))","v":""},{"$f":"IF(W65+W67+W72+X72+Y72+Z72+AA72+AB72+AC72+AD72+AE72+AF72+AG72+W74+X74+Y74+Z74+AA74+X78>0,\"Incomplete\",\"Complete\")","v":"Complete"},null,12.75]
[null,null,{"$f":"IF($F65=$Z$5,\"Claimed Hours\",\"New Claimed Hours\")","v":"New Claimed Hours"},null,null,"Offer Type","Funded Hours\n(Universal and Dis 2's)","Extended hours\n(3&4 Yr Olds)","Expanded hours\n(WP 2's and Under 2's)","No. of Weeks Claiming","Residual Hours?","Previously Claimed hours\n(what was on your last claim/adjustment form)",null,null,"Offer Type","Funded Hours\n(Universal and Dis 2's)","Extended hours\n(3&4 Yr Olds)","Expanded hours\n(WP 2's and Under 2's)","Number of Weeks","Residual Hours?",null,null,"New offer Type","New Funded","New extended","new weeks","new residual","prev offer","prev funded","prev extended","prev weeks","prev residual","New expanded","change of hours complete?",null,12.5]
["3d",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($F65=\"\",0,IF(AND($F65<>\"\",$F76<>\"\"),\"0\",\"1\"))","v":0},{"$f":"IF($F65=\"\",0,IF(AND($F65<>\"\",OR($G76<>\"\",H76<>\"\",$I76<>\"\")),\"0\",\"1\"))","v":0},{"$f":"IF($F65=\"\",0,IF(AND($F65<>\"\",OR($G76<>\"\",H76<>\"\",$I76<>\"\")),\"0\",\"1\"))","v":0},{"$f":"IF($F65=\"\",0,IF(AND($F65<>\"\",$J76<>\"\"),\"0\",\"1\"))","v":0},{"$f":"IF($F65=\"\",0,IF(AND(F76=\"Stretched\",$K76=\"\"),\"1\",\"0\"))","v":0},{"$f":"IF($F65=\"\",0,IF(AND($F65<>\"\",$O76<>\"\"),\"0\",\"1\"))","v":0},{"$f":"IF($F65=\"\",0,IF(AND($F65<>\"\",OR(P76<>\"\",Q76<>\"\",R76<>\"\")),\"0\",\"1\"))","v":0},{"$f":"IF($F65=\"\",0,IF(AND($F65<>\"\",OR(P76<>\"\",Q76<>\"\",R76<>\"\")),\"0\",\"1\"))","v":0},{"$f":"IF($F65=\"\",0,IF(AND($F65<>\"\",$S76<>\"\"),\"0\",\"1\"))","v":0},{"$f":"IF($F65=\"\",0,IF(AND(O76=\"Stretched\",T76=\"\"),\"1\",\"0\"))","v":0},{"$f":"IF($F65=\"\",0,IF(AND($F65<>\"\",OR($G76<>\"\",H76<>\"\",$I76<>\"\")),\"0\",\"1\"))","v":0},{"$f":"IF(W65+W67+W72+X72+Y72+Z72+AA72+AB72+AC72+AD72+AE72+AF72+AG72+W74+X74+Y74+Z74+AA74+W76+X76+Y76+Z76+AA76+W78+X78+AB76+AC76+AD76+AE76+AF76+AG76+AG79+AB78>0,\"Incomplete\",\"Complete\")","v":"Complete"},null,12.25]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Code","portal",null,null,null,null,null,null,null,null,null,null,null,12]
["3e",null,"Eligibility Code",null,null,null,"Has the code been checked on your eligibility code portal?",null,null,null,null,null,null,{"$f":"CONCATENATE(\"Please ensure that the code is valid for \",$J$20,\" \",$S$20)","v":"Please ensure that the code is valid for  "},null,null,null,null,null,null,null,null,{"$f":"IF(AND($I76>0.1,$E78=\"\"),\"1\",\"0\")","v":"0"},{"$f":"IF(AND($E78>10000000000,$E78<60000000000,$M78=\"\"),\"1\",\"0\")","v":"0"},"Max funded Hours",{"$f":"IF(AG74=2,15,IF(AG74<2,0,15))","v":15},{"$f":"IF(AG74=2,12.5,IF(AG74<2,0,12.5))","v":12.5},{"$f":"IF(AND($H76>0.1,$E78=\"\"),\"1\",\"0\")","v":"0"},null,null,null,null,"previous expanded","change childs details complete?",null,11.75]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Max Extended hours",{"$f":"IF(AG74=2,0,IF(AG74<2,0,15))","v":15},{"$f":"IF(AG74=2,0,IF(AG74<2,0,12.5))","v":12.5},null,null,null,null,null,{"$f":"IF($F65=\"\",0,IF(AND($F65<>\"\",OR(P76<>\"\",Q76<>\"\",R76<>\"\")),\"0\",\"1\"))","v":0},{"$f":"IF(W72+X72+Y72+Z72+AA72+AB72+AC72+AD72+AE72+AF72+AG72+W74+X74+Y74+Z74+AA74>0,\"Incomplete\",\"Complete\")","v":"Complete"},null,11.5]
[null,null,"Any Additional Comments?",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Max Expanded hours",{"$f":"IF(AG74=\"\",30,IF(AG74>2,0,30))","v":30},{"$f":"IF(AG74=\"\",25,IF(AG74>2,0,25))","v":25},null,null,null,null,null,null,"DAF Complete?",null,11.25]
["3f",null,null,null,null,null,null,null,null,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":"IF(W67+W72+X72+Y72+Z72+AA72+AB72+AC72+AD72+AE72+AF72+AG72+W74+X74+Y74+Z74+AA74>0,\"Incomplete\",\"Complete\")","v":"Complete"},null,11]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,10.75]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,10.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,10.25]
[4,null,"Reason for adjustment",null,null,null,null,null,null,null,null,{"$f":"IF(F85=$Z$4,$AA$13,IF(F85=$Z$6,$AA$14,IF(F85=$Z$5,$AA$15,\"\")))","v":""},null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND($F85=$Z$4,$S85=\"\"),\"1\",IF(AND($F85=$Z$5,$S85=\"\"),\"1\",IF(AND($F85=$Z$6,$S85=\"\"),\"1\",\"0\")))","v":"0"},null,null,null,null,null,null,null,null,null,null,null,null,10]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9.75]
["4a",null,{"$f":"IF(F85=$Z$4,$Z$16,IF(F85=$Z$6,$Z$18,IF(F85=$Z$8,$Z$19,IF(F85=$Z$5,$Z$17,\"\"))))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND($F85=$Z$4,$M87=\"\"),\"1\",IF(AND($F85=$Z$5,$M87=\"\"),\"1\",IF(AND($F85=$Z$6,$M87=\"\"),\"1\",IF(AND($F85=$Z$8,$M87=\"\"),\"1\",\"0\"))))","v":"0"},null,null,null,null,null,null,null,null,null,null,null,null,9.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9.25]
[null,null,{"$f":"IF(AND(F85=$Z$4,M87=$AA$16),$AA$4,IF(AND(F85=$Z$4,M87=$AA$17),$AA$9,IF(F85=$Z$5,$AA$5,IF(F85=$Z$6,$AA$6,IF(F85=$Z$7,$AA$7,IF(F85=$Z$8,$AA$8,\"\"))))))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8.75]
[null,{"$f":"IF(F85=\"\",\"\",IF(AND($F85=$Z$4,$AH92=\"Complete\"),\"Complete Record\",IF(AND($F85=$Z$5,$AH94=\"Complete\"),\"Complete Record\",IF(AND($F85=$Z$6,$AH96=\"Complete\"),\"Complete Record\",IF(AND($F85=$Z$7,$AH99=\"Complete\"),\"Complete Record\",IF(AND($F85=$Z$8,$AH101=\"Complete\"),\"Complete Record\",\"Incomplete Record\"))))))","v":""},"Legal Surname",null,null,"Legal Forename",null,null,"Middle Name",null,"Preferred surname",null,"Preferred forename",null,"DOB\n(DD/MM/YYYY)","Gender","Ethnicity","SEN","Armed Forces Family","In Receipt of DLA",null,null,"Legal Surname","Legal forename","Middle Name","preferred surname","preferred forename","DOB","Gender","Ethnicity","SEN","Armed Forces","DLA","new starter complete?",null,8.5]
["4b",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($F85=\"\",0,IF(AND($F85<>\"\",$C92<>\"\"),\"0\",\"1\"))","v":0},{"$f":"IF($F85=\"\",0,IF(AND($F85<>\"\",$F92<>\"\"),\"0\",\"1\"))","v":0},null,{"$f":"IF($F85=\"\",0,IF(AND($F85<>\"\",$K92<>\"\"),\"0\",\"1\"))","v":0},{"$f":"IF($F85=\"\",0,IF(AND($F85<>\"\",$M92<>\"\"),\"0\",\"1\"))","v":0},{"$f":"IF($F85=\"\",0,IF(AND($F85<>\"\",$O92<>\"\"),\"0\",\"1\"))","v":0},{"$f":"IF($F85=\"\",0,IF(AND($F85<>\"\",$P92<>\"\"),\"0\",\"1\"))","v":0},{"$f":"IF($F85=\"\",0,IF(AND($F85<>\"\",$Q92<>\"\"),\"0\",\"1\"))","v":0},{"$f":"IF($F85=\"\",0,IF(AND($F85<>\"\",$R92<>\"\"),\"0\",\"1\"))","v":0},{"$f":"IF($F85=\"\",0,IF(AND($F85<>\"\",$S92<>\"\"),\"0\",\"1\"))","v":0},{"$f":"IF($F85=\"\",0,IF(AND($F85<>\"\",$T92<>\"\"),\"0\",\"1\"))","v":0},{"$f":"IF(W85+W87+W92+X92+Y92+Z92+AA92+AB92+AC92+AD92+AE92+AF92+AG92+W94+X94+Y94+Z94+AA94+W96+X96+Y96+Z96+AA96+W98+X98+AG96+AB98>0,\"Incomplete\",\"Complete\")","v":"Complete"},null,8.25]
[null,null,"No. of Flat/Apart.",null,null,"House No./Name",null,null,"Street",null,null,"Local Area",null,null,"Town",null,null,null,"Postcode",null,null,null,"no. Flat","House No.","Street","Town","Postcode",null,"need hours completed?","need previous hours completed","need new residual","need prev residual","AGE","Leaving complete?",null,8]
["4c",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($F85=\"\",0,IF(AND($F85<>\"\",$C94=\"\",$F94=\"\"),\"1\",\"0\"))","v":0},null,{"$f":"IF($F85=\"\",0,IF(AND($F85<>\"\",$I94<>\"\"),\"0\",\"1\"))","v":0},{"$f":"IF($F85=\"\",0,IF(AND($F85<>\"\",$O94<>\"\"),\"0\",\"1\"))","v":0},{"$f":"IF($F85=\"\",0,IF(AND($F85<>\"\",$S94<>\"\"),\"0\",\"1\"))","v":0},null,{"$f":"IF(OR($F85=$Z$4,$F85=$Z$6),1,\"0\")","v":"0"},{"$f":"IF($F85=$Z$6,1,\"0\")","v":"0"},{"$f":"IF($F96=\"stretched\",1,\"0\")","v":"0"},{"$f":"IF($O96=\"stretched\",1,\"0\")","v":"0"},{"$f":"IF(O92=\"\",\"\",IF(O92=$AF$17,2,IF(O92=$AG$17,1,(INT(($AH$17-O92)/365.25)))))","v":""},{"$f":"IF(W85+W87+W92+X92+Y92+Z92+AA92+AB92+AC92+AD92+AE92+AF92+AG92+W94+X94+Y94+Z94+AA94+X98>0,\"Incomplete\",\"Complete\")","v":"Complete"},null,7.75]
[null,null,{"$f":"IF($F85=$Z$5,\"Claimed Hours\",\"New Claimed Hours\")","v":"New Claimed Hours"},null,null,"Offer Type","Funded Hours\n(Universal and Dis 2's)","Extended hours\n(3&4 Yr Olds)","Expanded hours\n(WP 2's and Under 2's)","No. of Weeks Claiming","Residual Hours?","Previously Claimed hours\n(what was on your last claim/adjustment form)",null,null,"Offer Type","Funded Hours\n(Universal and Dis 2's)","Extended hours\n(3&4 Yr Olds)","Expanded hours\n(WP 2's and Under 2's)","Number of Weeks","Residual Hours?",null,null,"New offer Type","New Funded","New extended","new weeks","new residual","prev offer","prev funded","prev extended","prev weeks","prev residual","New expanded","change of hours complete?",null,7.5]
["4d",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($F85=\"\",0,IF(AND($F85<>\"\",$F96<>\"\"),\"0\",\"1\"))","v":0},{"$f":"IF($F85=\"\",0,IF(AND($F85<>\"\",OR($G96<>\"\",H96<>\"\",$I96<>\"\")),\"0\",\"1\"))","v":0},{"$f":"IF($F85=\"\",0,IF(AND($F85<>\"\",OR($G96<>\"\",H96<>\"\",$I96<>\"\")),\"0\",\"1\"))","v":0},{"$f":"IF($F85=\"\",0,IF(AND($F85<>\"\",$J96<>\"\"),\"0\",\"1\"))","v":0},{"$f":"IF($F85=\"\",0,IF(AND(F96=\"Stretched\",$K96=\"\"),\"1\",\"0\"))","v":0},{"$f":"IF($F85=\"\",0,IF(AND($F85<>\"\",$O96<>\"\"),\"0\",\"1\"))","v":0},{"$f":"IF($F85=\"\",0,IF(AND($F85<>\"\",OR(P96<>\"\",Q96<>\"\",R96<>\"\")),\"0\",\"1\"))","v":0},{"$f":"IF($F85=\"\",0,IF(AND($F85<>\"\",OR(P96<>\"\",Q96<>\"\",R96<>\"\")),\"0\",\"1\"))","v":0},{"$f":"IF($F85=\"\",0,IF(AND($F85<>\"\",$S96<>\"\"),\"0\",\"1\"))","v":0},{"$f":"IF($F85=\"\",0,IF(AND(O96=\"Stretched\",T96=\"\"),\"1\",\"0\"))","v":0},{"$f":"IF($F85=\"\",0,IF(AND($F85<>\"\",OR($G96<>\"\",H96<>\"\",$I96<>\"\")),\"0\",\"1\"))","v":0},{"$f":"IF(W85+W87+W92+X92+Y92+Z92+AA92+AB92+AC92+AD92+AE92+AF92+AG92+W94+X94+Y94+Z94+AA94+W96+X96+Y96+Z96+AA96+W98+X98+AB96+AC96+AD96+AE96+AF96+AG96+AG99+AB98>0,\"Incomplete\",\"Complete\")","v":"Complete"},null,7.25]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Code","portal",null,null,null,null,null,null,null,null,null,null,null,7]
["4e",null,"Eligibility Code",null,null,null,"Has the code been checked on your eligibility code portal?",null,null,null,null,null,null,{"$f":"CONCATENATE(\"Please ensure that the code is valid for \",$J$20,\" \",$S$20)","v":"Please ensure that the code is valid for  "},null,null,null,null,null,null,null,null,{"$f":"IF(AND($I96>0.1,$E98=\"\"),\"1\",\"0\")","v":"0"},{"$f":"IF(AND($E98>10000000000,$E98<60000000000,$M98=\"\"),\"1\",\"0\")","v":"0"},"Max funded Hours",{"$f":"IF(AG94=2,15,IF(AG94<2,0,15))","v":15},{"$f":"IF(AG94=2,12.5,IF(AG94<2,0,12.5))","v":12.5},{"$f":"IF(AND($H96>0.1,$E98=\"\"),\"1\",\"0\")","v":"0"},null,null,null,null,"previous expanded","change childs details complete?",null,6.75]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Max Extended hours",{"$f":"IF(AG94=2,0,IF(AG94<2,0,15))","v":15},{"$f":"IF(AG94=2,0,IF(AG94<2,0,12.5))","v":12.5},null,null,null,null,null,{"$f":"IF($F85=\"\",0,IF(AND($F85<>\"\",OR(P96<>\"\",Q96<>\"\",R96<>\"\")),\"0\",\"1\"))","v":0},{"$f":"IF(W92+X92+Y92+Z92+AA92+AB92+AC92+AD92+AE92+AF92+AG92+W94+X94+Y94+Z94+AA94>0,\"Incomplete\",\"Complete\")","v":"Complete"},null,6.5]
[null,null,"Any Additional Comments?",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Max Expanded hours",{"$f":"IF(AG94=\"\",30,IF(AG94>2,0,30))","v":30},{"$f":"IF(AG94=\"\",25,IF(AG94>2,0,25))","v":25},null,null,null,null,null,null,"DAF Complete?",null,6.25]
["4f",null,null,null,null,null,null,null,null,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":"IF(W87+W92+X92+Y92+Z92+AA92+AB92+AC92+AD92+AE92+AF92+AG92+W94+X94+Y94+Z94+AA94>0,\"Incomplete\",\"Complete\")","v":"Complete"},null,6]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5.75]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5.25]
[5,null,"Reason for adjustment",null,null,null,null,null,null,null,null,{"$f":"IF(F105=$Z$4,$AA$13,IF(F105=$Z$6,$AA$14,IF(F105=$Z$5,$AA$15,\"\")))","v":""},null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND($F105=$Z$4,$S105=\"\"),\"1\",IF(AND($F105=$Z$5,$S105=\"\"),\"1\",IF(AND($F105=$Z$6,$S105=\"\"),\"1\",\"0\")))","v":"0"},null,null,null,null,null,null,null,null,null,null,null,null,5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4.75]
["5a",null,{"$f":"IF(F105=$Z$4,$Z$16,IF(F105=$Z$6,$Z$18,IF(F105=$Z$8,$Z$19,IF(F105=$Z$5,$Z$17,\"\"))))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND($F105=$Z$4,$M107=\"\"),\"1\",IF(AND($F105=$Z$5,$M107=\"\"),\"1\",IF(AND($F105=$Z$6,$M107=\"\"),\"1\",IF(AND($F105=$Z$8,$M107=\"\"),\"1\",\"0\"))))","v":"0"},null,null,null,null,null,null,null,null,null,null,null,null,4.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4.25]
[null,null,{"$f":"IF(AND(F105=$Z$4,M107=$AA$16),$AA$4,IF(AND(F105=$Z$4,M107=$AA$17),$AA$9,IF(F105=$Z$5,$AA$5,IF(F105=$Z$6,$AA$6,IF(F105=$Z$7,$AA$7,IF(F105=$Z$8,$AA$8,\"\"))))))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3.75]
[null,{"$f":"IF(F105=\"\",\"\",IF(AND($F105=$Z$4,$AH112=\"Complete\"),\"Complete Record\",IF(AND($F105=$Z$5,$AH114=\"Complete\"),\"Complete Record\",IF(AND($F105=$Z$6,$AH116=\"Complete\"),\"Complete Record\",IF(AND($F105=$Z$7,$AH119=\"Complete\"),\"Complete Record\",IF(AND($F105=$Z$8,$AH121=\"Complete\"),\"Complete Record\",\"Incomplete Record\"))))))","v":""},"Legal Surname",null,null,"Legal Forename",null,null,"Middle Name",null,"Preferred surname",null,"Preferred forename",null,"DOB\n(DD/MM/YYYY)","Gender","Ethnicity","SEN","Armed Forces Family","In Receipt of DLA",null,null,"Legal Surname","Legal forename","Middle Name","preferred surname","preferred forename","DOB","Gender","Ethnicity","SEN","Armed Forces","DLA","new starter complete?",null,3.5]
["5b",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($F105=\"\",0,IF(AND($F105<>\"\",$C112<>\"\"),\"0\",\"1\"))","v":0},{"$f":"IF($F105=\"\",0,IF(AND($F105<>\"\",$F112<>\"\"),\"0\",\"1\"))","v":0},null,{"$f":"IF($F105=\"\",0,IF(AND($F105<>\"\",$K112<>\"\"),\"0\",\"1\"))","v":0},{"$f":"IF($F105=\"\",0,IF(AND($F105<>\"\",$M112<>\"\"),\"0\",\"1\"))","v":0},{"$f":"IF($F105=\"\",0,IF(AND($F105<>\"\",$O112<>\"\"),\"0\",\"1\"))","v":0},{"$f":"IF($F105=\"\",0,IF(AND($F105<>\"\",$P112<>\"\"),\"0\",\"1\"))","v":0},{"$f":"IF($F105=\"\",0,IF(AND($F105<>\"\",$Q112<>\"\"),\"0\",\"1\"))","v":0},{"$f":"IF($F105=\"\",0,IF(AND($F105<>\"\",$R112<>\"\"),\"0\",\"1\"))","v":0},{"$f":"IF($F105=\"\",0,IF(AND($F105<>\"\",$S112<>\"\"),\"0\",\"1\"))","v":0},{"$f":"IF($F105=\"\",0,IF(AND($F105<>\"\",$T112<>\"\"),\"0\",\"1\"))","v":0},{"$f":"IF(W105+W107+W112+X112+Y112+Z112+AA112+AB112+AC112+AD112+AE112+AF112+AG112+W114+X114+Y114+Z114+AA114+W116+X116+Y116+Z116+AA116+W118+X118+AG116+AB118>0,\"Incomplete\",\"Complete\")","v":"Complete"},null,3.25]
[null,null,"No. of Flat/Apart.",null,null,"House No./Name",null,null,"Street",null,null,"Local Area",null,null,"Town",null,null,null,"Postcode",null,null,null,"no. Flat","House No.","Street","Town","Postcode",null,"need hours completed?","need previous hours completed","need new residual","need prev residual","AGE","Leaving complete?",null,3]
["5c",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($F105=\"\",0,IF(AND($F105<>\"\",$C114=\"\",$F114=\"\"),\"1\",\"0\"))","v":0},null,{"$f":"IF($F105=\"\",0,IF(AND($F105<>\"\",$I114<>\"\"),\"0\",\"1\"))","v":0},{"$f":"IF($F105=\"\",0,IF(AND($F105<>\"\",$O114<>\"\"),\"0\",\"1\"))","v":0},{"$f":"IF($F105=\"\",0,IF(AND($F105<>\"\",$S114<>\"\"),\"0\",\"1\"))","v":0},null,{"$f":"IF(OR($F105=$Z$4,$F105=$Z$6),1,\"0\")","v":"0"},{"$f":"IF($F105=$Z$6,1,\"0\")","v":"0"},{"$f":"IF($F116=\"stretched\",1,\"0\")","v":"0"},{"$f":"IF($O116=\"stretched\",1,\"0\")","v":"0"},{"$f":"IF(O112=\"\",\"\",IF(O112=$AF$17,2,IF(O112=$AG$17,1,(INT(($AH$17-O112)/365.25)))))","v":""},{"$f":"IF(W105+W107+W112+X112+Y112+Z112+AA112+AB112+AC112+AD112+AE112+AF112+AG112+W114+X114+Y114+Z114+AA114+X118>0,\"Incomplete\",\"Complete\")","v":"Complete"},null,2.75]
[null,null,{"$f":"IF($F105=$Z$5,\"Claimed Hours\",\"New Claimed Hours\")","v":"New Claimed Hours"},null,null,"Offer Type","Funded Hours\n(Universal and Dis 2's)","Extended hours\n(3&4 Yr Olds)","Expanded hours\n(WP 2's and Under 2's)","No. of Weeks Claiming","Residual Hours?","Previously Claimed hours\n(what was on your last claim/adjustment form)",null,null,"Offer Type","Funded Hours\n(Universal and Dis 2's)","Extended hours\n(3&4 Yr Olds)","Expanded hours\n(WP 2's and Under 2's)","Number of Weeks","Residual Hours?",null,null,"New offer Type","New Funded","New extended","new weeks","new residual","prev offer","prev funded","prev extended","prev weeks","prev residual","New expanded","change of hours complete?",null,2.5]
["5d",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($F105=\"\",0,IF(AND($F105<>\"\",$F116<>\"\"),\"0\",\"1\"))","v":0},{"$f":"IF($F105=\"\",0,IF(AND($F105<>\"\",OR($G116<>\"\",H116<>\"\",$I116<>\"\")),\"0\",\"1\"))","v":0},{"$f":"IF($F105=\"\",0,IF(AND($F105<>\"\",OR($G116<>\"\",H116<>\"\",$I116<>\"\")),\"0\",\"1\"))","v":0},{"$f":"IF($F105=\"\",0,IF(AND($F105<>\"\",$J116<>\"\"),\"0\",\"1\"))","v":0},{"$f":"IF($F105=\"\",0,IF(AND(F116=\"Stretched\",$K116=\"\"),\"1\",\"0\"))","v":0},{"$f":"IF($F105=\"\",0,IF(AND($F105<>\"\",$O116<>\"\"),\"0\",\"1\"))","v":0},{"$f":"IF($F105=\"\",0,IF(AND($F105<>\"\",OR(P116<>\"\",Q116<>\"\",R116<>\"\")),\"0\",\"1\"))","v":0},{"$f":"IF($F105=\"\",0,IF(AND($F105<>\"\",OR(P116<>\"\",Q116<>\"\",R116<>\"\")),\"0\",\"1\"))","v":0},{"$f":"IF($F105=\"\",0,IF(AND($F105<>\"\",$S116<>\"\"),\"0\",\"1\"))","v":0},{"$f":"IF($F105=\"\",0,IF(AND(O116=\"Stretched\",T116=\"\"),\"1\",\"0\"))","v":0},{"$f":"IF($F105=\"\",0,IF(AND($F105<>\"\",OR($G116<>\"\",H116<>\"\",$I116<>\"\")),\"0\",\"1\"))","v":0},{"$f":"IF(W105+W107+W112+X112+Y112+Z112+AA112+AB112+AC112+AD112+AE112+AF112+AG112+W114+X114+Y114+Z114+AA114+W116+X116+Y116+Z116+AA116+W118+X118+AB116+AC116+AD116+AE116+AF116+AG116+AG119+AB118>0,\"Incomplete\",\"Complete\")","v":"Complete"},null,2.25]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Code","portal",null,null,null,null,null,null,null,null,null,null,null,2]
["5e",null,"Eligibility Code",null,null,null,"Has the code been checked on your eligibility code portal?",null,null,null,null,null,null,{"$f":"CONCATENATE(\"Please ensure that the code is valid for \",$J$20,\" \",$S$20)","v":"Please ensure that the code is valid for  "},null,null,null,null,null,null,null,null,{"$f":"IF(AND($I116>0.1,$E118=\"\"),\"1\",\"0\")","v":"0"},{"$f":"IF(AND($E118>10000000000,$E118<60000000000,$M118=\"\"),\"1\",\"0\")","v":"0"},"Max funded Hours",{"$f":"IF(AG114=2,15,IF(AG114<2,0,15))","v":15},{"$f":"IF(AG114=2,12.5,IF(AG114<2,0,12.5))","v":12.5},{"$f":"IF(AND($H116>0.1,$E118=\"\"),\"1\",\"0\")","v":"0"},null,null,null,null,"previous expanded","change childs details complete?",null,1.75]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Max Extended hours",{"$f":"IF(AG114=2,0,IF(AG114<2,0,15))","v":15},{"$f":"IF(AG114=2,0,IF(AG114<2,0,12.5))","v":12.5},null,null,null,null,null,{"$f":"IF($F105=\"\",0,IF(AND($F105<>\"\",OR(P116<>\"\",Q116<>\"\",R116<>\"\")),\"0\",\"1\"))","v":0},{"$f":"IF(W112+X112+Y112+Z112+AA112+AB112+AC112+AD112+AE112+AF112+AG112+W114+X114+Y114+Z114+AA114>0,\"Incomplete\",\"Complete\")","v":"Complete"},null,1.5]
[null,null,"Any Additional Comments?",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Max Expanded hours",{"$f":"IF(AG114=\"\",30,IF(AG114>2,0,30))","v":30},{"$f":"IF(AG114=\"\",25,IF(AG114>2,0,25))","v":25},null,null,null,null,null,null,"DAF Complete?",null,1.25]
["5f",null,null,null,null,null,null,null,null,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":"IF(W107+W112+X112+Y112+Z112+AA112+AB112+AC112+AD112+AE112+AF112+AG112+W114+X114+Y114+Z114+AA114>0,\"Incomplete\",\"Complete\")","v":"Complete"},null,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.75]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.25]
[6,null,"Reason for adjustment",null,null,null,null,null,null,null,null,{"$f":"IF(F125=$Z$4,$AA$13,IF(F125=$Z$6,$AA$14,IF(F125=$Z$5,$AA$15,\"\")))","v":""},null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND($F125=$Z$4,$S125=\"\"),\"1\",IF(AND($F125=$Z$5,$S125=\"\"),\"1\",IF(AND($F125=$Z$6,$S125=\"\"),\"1\",\"0\")))","v":"0"},null,null,null,null,null,null,null,null,null,null,null,null,0]
[]
["6a",null,{"$f":"IF(F125=$Z$4,$Z$16,IF(F125=$Z$6,$Z$18,IF(F125=$Z$8,$Z$19,IF(F125=$Z$5,$Z$17,\"\"))))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND($F125=$Z$4,$M127=\"\"),\"1\",IF(AND($F125=$Z$5,$M127=\"\"),\"1\",IF(AND($F125=$Z$6,$M127=\"\"),\"1\",IF(AND($F125=$Z$8,$M127=\"\"),\"1\",\"0\"))))","v":"0"}]
[]
[null,null,{"$f":"IF(AND(F125=$Z$4,M127=$AA$16),$AA$4,IF(AND(F125=$Z$4,M127=$AA$17),$AA$9,IF(F125=$Z$5,$AA$5,IF(F125=$Z$6,$AA$6,IF(F125=$Z$7,$AA$7,IF(F125=$Z$8,$AA$8,\"\"))))))","v":""}]
[]
[null,{"$f":"IF(F125=\"\",\"\",IF(AND($F125=$Z$4,$AH132=\"Complete\"),\"Complete Record\",IF(AND($F125=$Z$5,$AH134=\"Complete\"),\"Complete Record\",IF(AND($F125=$Z$6,$AH136=\"Complete\"),\"Complete Record\",IF(AND($F125=$Z$7,$AH139=\"Complete\"),\"Complete Record\",IF(AND($F125=$Z$8,$AH141=\"Complete\"),\"Complete Record\",\"Incomplete Record\"))))))","v":""},"Legal Surname",null,null,"Legal Forename",null,null,"Middle Name",null,"Preferred surname",null,"Preferred forename",null,"DOB\n(DD/MM/YYYY)","Gender","Ethnicity","SEN","Armed Forces Family","In Receipt of DLA",null,null,"Legal Surname","Legal forename","Middle Name","preferred surname","preferred forename","DOB","Gender","Ethnicity","SEN","Armed Forces","DLA","new starter complete?"]
["6b",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($F125=\"\",0,IF(AND($F125<>\"\",$C132<>\"\"),\"0\",\"1\"))","v":0},{"$f":"IF($F125=\"\",0,IF(AND($F125<>\"\",$F132<>\"\"),\"0\",\"1\"))","v":0},null,{"$f":"IF($F125=\"\",0,IF(AND($F125<>\"\",$K132<>\"\"),\"0\",\"1\"))","v":0},{"$f":"IF($F125=\"\",0,IF(AND($F125<>\"\",$M132<>\"\"),\"0\",\"1\"))","v":0},{"$f":"IF($F125=\"\",0,IF(AND($F125<>\"\",$O132<>\"\"),\"0\",\"1\"))","v":0},{"$f":"IF($F125=\"\",0,IF(AND($F125<>\"\",$P132<>\"\"),\"0\",\"1\"))","v":0},{"$f":"IF($F125=\"\",0,IF(AND($F125<>\"\",$Q132<>\"\"),\"0\",\"1\"))","v":0},{"$f":"IF($F125=\"\",0,IF(AND($F125<>\"\",$R132<>\"\"),\"0\",\"1\"))","v":0},{"$f":"IF($F125=\"\",0,IF(AND($F125<>\"\",$S132<>\"\"),\"0\",\"1\"))","v":0},{"$f":"IF($F125=\"\",0,IF(AND($F125<>\"\",$T132<>\"\"),\"0\",\"1\"))","v":0},{"$f":"IF(W125+W127+W132+X132+Y132+Z132+AA132+AB132+AC132+AD132+AE132+AF132+AG132+W134+X134+Y134+Z134+AA134+W136+X136+Y136+Z136+AA136+W138+X138+AG136+AB138>0,\"Incomplete\",\"Complete\")","v":"Complete"}]
[null,null,"No. of Flat/Apart.",null,null,"House No./Name",null,null,"Street",null,null,"Local Area",null,null,"Town",null,null,null,"Postcode",null,null,null,"no. Flat","House No.","Street","Town","Postcode",null,"need hours completed?","need previous hours completed","need new residual","need prev residual","AGE","Leaving complete?"]
["6c",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($F125=\"\",0,IF(AND($F125<>\"\",$C134=\"\",$F134=\"\"),\"1\",\"0\"))","v":0},null,{"$f":"IF($F125=\"\",0,IF(AND($F125<>\"\",$I134<>\"\"),\"0\",\"1\"))","v":0},{"$f":"IF($F125=\"\",0,IF(AND($F125<>\"\",$O134<>\"\"),\"0\",\"1\"))","v":0},{"$f":"IF($F125=\"\",0,IF(AND($F125<>\"\",$S134<>\"\"),\"0\",\"1\"))","v":0},null,{"$f":"IF(OR($F125=$Z$4,$F125=$Z$6),1,\"0\")","v":"0"},{"$f":"IF($F125=$Z$6,1,\"0\")","v":"0"},{"$f":"IF($F136=\"stretched\",1,\"0\")","v":"0"},{"$f":"IF($O136=\"stretched\",1,\"0\")","v":"0"},{"$f":"IF(O132=\"\",\"\",IF(O132=$AF$17,2,IF(O132=$AG$17,1,(INT(($AH$17-O132)/365.25)))))","v":""},{"$f":"IF(W125+W127+W132+X132+Y132+Z132+AA132+AB132+AC132+AD132+AE132+AF132+AG132+W134+X134+Y134+Z134+AA134+X138>0,\"Incomplete\",\"Complete\")","v":"Complete"}]
[null,null,{"$f":"IF($F125=$Z$5,\"Claimed Hours\",\"New Claimed Hours\")","v":"New Claimed Hours"},null,null,"Offer Type","Funded Hours\n(Universal and Dis 2's)","Extended hours\n(3&4 Yr Olds)","Expanded hours\n(WP 2's and Under 2's)","No. of Weeks Claiming","Residual Hours?","Previously Claimed hours\n(what was on your last claim/adjustment form)",null,null,"Offer Type","Funded Hours\n(Universal and Dis 2's)","Extended hours\n(3&4 Yr Olds)","Expanded hours\n(WP 2's and Under 2's)","Number of Weeks","Residual Hours?",null,null,"New offer Type","New Funded","New extended","new weeks","new residual","prev offer","prev funded","prev extended","prev weeks","prev residual","New expanded","change of hours complete?"]
["6d",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($F125=\"\",0,IF(AND($F125<>\"\",$F136<>\"\"),\"0\",\"1\"))","v":0},{"$f":"IF($F125=\"\",0,IF(AND($F125<>\"\",OR($G136<>\"\",H136<>\"\",$I136<>\"\")),\"0\",\"1\"))","v":0},{"$f":"IF($F125=\"\",0,IF(AND($F125<>\"\",OR($G136<>\"\",H136<>\"\",$I136<>\"\")),\"0\",\"1\"))","v":0},{"$f":"IF($F125=\"\",0,IF(AND($F125<>\"\",$J136<>\"\"),\"0\",\"1\"))","v":0},{"$f":"IF($F125=\"\",0,IF(AND(F136=\"Stretched\",$K136=\"\"),\"1\",\"0\"))","v":0},{"$f":"IF($F125=\"\",0,IF(AND($F125<>\"\",$O136<>\"\"),\"0\",\"1\"))","v":0},{"$f":"IF($F125=\"\",0,IF(AND($F125<>\"\",OR(P136<>\"\",Q136<>\"\",R136<>\"\")),\"0\",\"1\"))","v":0},{"$f":"IF($F125=\"\",0,IF(AND($F125<>\"\",OR(P136<>\"\",Q136<>\"\",R136<>\"\")),\"0\",\"1\"))","v":0},{"$f":"IF($F125=\"\",0,IF(AND($F125<>\"\",$S136<>\"\"),\"0\",\"1\"))","v":0},{"$f":"IF($F125=\"\",0,IF(AND(O136=\"Stretched\",T136=\"\"),\"1\",\"0\"))","v":0},{"$f":"IF($F125=\"\",0,IF(AND($F125<>\"\",OR($G136<>\"\",H136<>\"\",$I136<>\"\")),\"0\",\"1\"))","v":0},{"$f":"IF(W125+W127+W132+X132+Y132+Z132+AA132+AB132+AC132+AD132+AE132+AF132+AG132+W134+X134+Y134+Z134+AA134+W136+X136+Y136+Z136+AA136+W138+X138+AB136+AC136+AD136+AE136+AF136+AG136+AG139+AB138>0,\"Incomplete\",\"Complete\")","v":"Complete"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Code","portal"]
["6e",null,"Eligibility Code",null,null,null,"Has the code been checked on your eligibility code portal?",null,null,null,null,null,null,{"$f":"CONCATENATE(\"Please ensure that the code is valid for \",$J$20,\" \",$S$20)","v":"Please ensure that the code is valid for  "},null,null,null,null,null,null,null,null,{"$f":"IF(AND($I136>0.1,$E138=\"\"),\"1\",\"0\")","v":"0"},{"$f":"IF(AND($E138>10000000000,$E138<60000000000,$M138=\"\"),\"1\",\"0\")","v":"0"},"Max funded Hours",{"$f":"IF(AG134=2,15,IF(AG134<2,0,15))","v":15},{"$f":"IF(AG134=2,12.5,IF(AG134<2,0,12.5))","v":12.5},{"$f":"IF(AND($H136>0.1,$E138=\"\"),\"1\",\"0\")","v":"0"},null,null,null,null,"previous expanded","change childs details complete?"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Max Extended hours",{"$f":"IF(AG134=2,0,IF(AG134<2,0,15))","v":15},{"$f":"IF(AG134=2,0,IF(AG134<2,0,12.5))","v":12.5},null,null,null,null,null,{"$f":"IF($F125=\"\",0,IF(AND($F125<>\"\",OR(P136<>\"\",Q136<>\"\",R136<>\"\")),\"0\",\"1\"))","v":0},{"$f":"IF(W132+X132+Y132+Z132+AA132+AB132+AC132+AD132+AE132+AF132+AG132+W134+X134+Y134+Z134+AA134>0,\"Incomplete\",\"Complete\")","v":"Complete"}]
[null,null,"Any Additional Comments?",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Max Expanded hours",{"$f":"IF(AG134=\"\",30,IF(AG134>2,0,30))","v":30},{"$f":"IF(AG134=\"\",25,IF(AG134>2,0,25))","v":25},null,null,null,null,null,null,"DAF Complete?"]
["6f",null,null,null,null,null,null,null,null,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":"IF(W127+W132+X132+Y132+Z132+AA132+AB132+AC132+AD132+AE132+AF132+AG132+W134+X134+Y134+Z134+AA134>0,\"Incomplete\",\"Complete\")","v":"Complete"}]
[]
[]
[]
[7,null,"Reason for adjustment",null,null,null,null,null,null,null,null,{"$f":"IF(F145=$Z$4,$AA$13,IF(F145=$Z$6,$AA$14,IF(F145=$Z$5,$AA$15,\"\")))","v":""},null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND($F145=$Z$4,$S145=\"\"),\"1\",IF(AND($F145=$Z$5,$S145=\"\"),\"1\",IF(AND($F145=$Z$6,$S145=\"\"),\"1\",\"0\")))","v":"0"}]
[]
["7a",null,{"$f":"IF(F145=$Z$4,$Z$16,IF(F145=$Z$6,$Z$18,IF(F145=$Z$8,$Z$19,IF(F145=$Z$5,$Z$17,\"\"))))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND($F145=$Z$4,$M147=\"\"),\"1\",IF(AND($F145=$Z$5,$M147=\"\"),\"1\",IF(AND($F145=$Z$6,$M147=\"\"),\"1\",IF(AND($F145=$Z$8,$M147=\"\"),\"1\",\"0\"))))","v":"0"}]
[]
[null,null,{"$f":"IF(AND(F145=$Z$4,M147=$AA$16),$AA$4,IF(AND(F145=$Z$4,M147=$AA$17),$AA$9,IF(F145=$Z$5,$AA$5,IF(F145=$Z$6,$AA$6,IF(F145=$Z$7,$AA$7,IF(F145=$Z$8,$AA$8,\"\"))))))","v":""}]
[]
[null,{"$f":"IF(F145=\"\",\"\",IF(AND($F145=$Z$4,$AH152=\"Complete\"),\"Complete Record\",IF(AND($F145=$Z$5,$AH154=\"Complete\"),\"Complete Record\",IF(AND($F145=$Z$6,$AH156=\"Complete\"),\"Complete Record\",IF(AND($F145=$Z$7,$AH159=\"Complete\"),\"Complete Record\",IF(AND($F145=$Z$8,$AH161=\"Complete\"),\"Complete Record\",\"Incomplete Record\"))))))","v":""},"Legal Surname",null,null,"Legal Forename",null,null,"Middle Name",null,"Preferred surname",null,"Preferred forename",null,"DOB\n(DD/MM/YYYY)","Gender","Ethnicity","SEN","Armed Forces Family","In Receipt of DLA",null,null,"Legal Surname","Legal forename","Middle Name","preferred surname","preferred forename","DOB","Gender","Ethnicity","SEN","Armed Forces","DLA","new starter complete?"]
["7b",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($F145=\"\",0,IF(AND($F145<>\"\",$C152<>\"\"),\"0\",\"1\"))","v":0},{"$f":"IF($F145=\"\",0,IF(AND($F145<>\"\",$F152<>\"\"),\"0\",\"1\"))","v":0},null,{"$f":"IF($F145=\"\",0,IF(AND($F145<>\"\",$K152<>\"\"),\"0\",\"1\"))","v":0},{"$f":"IF($F145=\"\",0,IF(AND($F145<>\"\",$M152<>\"\"),\"0\",\"1\"))","v":0},{"$f":"IF($F145=\"\",0,IF(AND($F145<>\"\",$O152<>\"\"),\"0\",\"1\"))","v":0},{"$f":"IF($F145=\"\",0,IF(AND($F145<>\"\",$P152<>\"\"),\"0\",\"1\"))","v":0},{"$f":"IF($F145=\"\",0,IF(AND($F145<>\"\",$Q152<>\"\"),\"0\",\"1\"))","v":0},{"$f":"IF($F145=\"\",0,IF(AND($F145<>\"\",$R152<>\"\"),\"0\",\"1\"))","v":0},{"$f":"IF($F145=\"\",0,IF(AND($F145<>\"\",$S152<>\"\"),\"0\",\"1\"))","v":0},{"$f":"IF($F145=\"\",0,IF(AND($F145<>\"\",$T152<>\"\"),\"0\",\"1\"))","v":0},{"$f":"IF(W145+W147+W152+X152+Y152+Z152+AA152+AB152+AC152+AD152+AE152+AF152+AG152+W154+X154+Y154+Z154+AA154+W156+X156+Y156+Z156+AA156+W158+X158+AG156+AB158>0,\"Incomplete\",\"Complete\")","v":"Complete"}]
[null,null,"No. of Flat/Apart.",null,null,"House No./Name",null,null,"Street",null,null,"Local Area",null,null,"Town",null,null,null,"Postcode",null,null,null,"no. Flat","House No.","Street","Town","Postcode",null,"need hours completed?","need previous hours completed","need new residual","need prev residual","AGE","Leaving complete?"]
["7c",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($F145=\"\",0,IF(AND($F145<>\"\",$C154=\"\",$F154=\"\"),\"1\",\"0\"))","v":0},null,{"$f":"IF($F145=\"\",0,IF(AND($F145<>\"\",$I154<>\"\"),\"0\",\"1\"))","v":0},{"$f":"IF($F145=\"\",0,IF(AND($F145<>\"\",$O154<>\"\"),\"0\",\"1\"))","v":0},{"$f":"IF($F145=\"\",0,IF(AND($F145<>\"\",$S154<>\"\"),\"0\",\"1\"))","v":0},null,{"$f":"IF(OR($F145=$Z$4,$F145=$Z$6),1,\"0\")","v":"0"},{"$f":"IF($F145=$Z$6,1,\"0\")","v":"0"},{"$f":"IF($F156=\"stretched\",1,\"0\")","v":"0"},{"$f":"IF($O156=\"stretched\",1,\"0\")","v":"0"},{"$f":"IF(O152=\"\",\"\",IF(O152=$AF$17,2,IF(O152=$AG$17,1,(INT(($AH$17-O152)/365.25)))))","v":""},{"$f":"IF(W145+W147+W152+X152+Y152+Z152+AA152+AB152+AC152+AD152+AE152+AF152+AG152+W154+X154+Y154+Z154+AA154+X158>0,\"Incomplete\",\"Complete\")","v":"Complete"}]
[null,null,{"$f":"IF($F145=$Z$5,\"Claimed Hours\",\"New Claimed Hours\")","v":"New Claimed Hours"},null,null,"Offer Type","Funded Hours\n(Universal and Dis 2's)","Extended hours\n(3&4 Yr Olds)","Expanded hours\n(WP 2's and Under 2's)","No. of Weeks Claiming","Residual Hours?","Previously Claimed hours\n(what was on your last claim/adjustment form)",null,null,"Offer Type","Funded Hours\n(Universal and Dis 2's)","Extended hours\n(3&4 Yr Olds)","Expanded hours\n(WP 2's and Under 2's)","Number of Weeks","Residual Hours?",null,null,"New offer Type","New Funded","New extended","new weeks","new residual","prev offer","prev funded","prev extended","prev weeks","prev residual","New expanded","change of hours complete?"]
["7d",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($F145=\"\",0,IF(AND($F145<>\"\",$F156<>\"\"),\"0\",\"1\"))","v":0},{"$f":"IF($F145=\"\",0,IF(AND($F145<>\"\",OR($G156<>\"\",H156<>\"\",$I156<>\"\")),\"0\",\"1\"))","v":0},{"$f":"IF($F145=\"\",0,IF(AND($F145<>\"\",OR($G156<>\"\",H156<>\"\",$I156<>\"\")),\"0\",\"1\"))","v":0},{"$f":"IF($F145=\"\",0,IF(AND($F145<>\"\",$J156<>\"\"),\"0\",\"1\"))","v":0},{"$f":"IF($F145=\"\",0,IF(AND(F156=\"Stretched\",$K156=\"\"),\"1\",\"0\"))","v":0},{"$f":"IF($F145=\"\",0,IF(AND($F145<>\"\",$O156<>\"\"),\"0\",\"1\"))","v":0},{"$f":"IF($F145=\"\",0,IF(AND($F145<>\"\",OR(P156<>\"\",Q156<>\"\",R156<>\"\")),\"0\",\"1\"))","v":0},{"$f":"IF($F145=\"\",0,IF(AND($F145<>\"\",OR(P156<>\"\",Q156<>\"\",R156<>\"\")),\"0\",\"1\"))","v":0},{"$f":"IF($F145=\"\",0,IF(AND($F145<>\"\",$S156<>\"\"),\"0\",\"1\"))","v":0},{"$f":"IF($F145=\"\",0,IF(AND(O156=\"Stretched\",T156=\"\"),\"1\",\"0\"))","v":0},{"$f":"IF($F145=\"\",0,IF(AND($F145<>\"\",OR($G156<>\"\",H156<>\"\",$I156<>\"\")),\"0\",\"1\"))","v":0},{"$f":"IF(W145+W147+W152+X152+Y152+Z152+AA152+AB152+AC152+AD152+AE152+AF152+AG152+W154+X154+Y154+Z154+AA154+W156+X156+Y156+Z156+AA156+W158+X158+AB156+AC156+AD156+AE156+AF156+AG156+AG159+AB158>0,\"Incomplete\",\"Complete\")","v":"Complete"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Code","portal"]
["7e",null,"Eligibility Code",null,null,null,"Has the code been checked on your eligibility code portal?",null,null,null,null,null,null,{"$f":"CONCATENATE(\"Please ensure that the code is valid for \",$J$20,\" \",$S$20)","v":"Please ensure that the code is valid for  "},null,null,null,null,null,null,null,null,{"$f":"IF(AND($I156>0.1,$E158=\"\"),\"1\",\"0\")","v":"0"},{"$f":"IF(AND($E158>10000000000,$E158<60000000000,$M158=\"\"),\"1\",\"0\")","v":"0"},"Max funded Hours",{"$f":"IF(AG154=2,15,IF(AG154<2,0,15))","v":15},{"$f":"IF(AG154=2,12.5,IF(AG154<2,0,12.5))","v":12.5},{"$f":"IF(AND($H156>0.1,$E158=\"\"),\"1\",\"0\")","v":"0"},null,null,null,null,"previous expanded","change childs details complete?"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Max Extended hours",{"$f":"IF(AG154=2,0,IF(AG154<2,0,15))","v":15},{"$f":"IF(AG154=2,0,IF(AG154<2,0,12.5))","v":12.5},null,null,null,null,null,{"$f":"IF($F145=\"\",0,IF(AND($F145<>\"\",OR(P156<>\"\",Q156<>\"\",R156<>\"\")),\"0\",\"1\"))","v":0},{"$f":"IF(W152+X152+Y152+Z152+AA152+AB152+AC152+AD152+AE152+AF152+AG152+W154+X154+Y154+Z154+AA154>0,\"Incomplete\",\"Complete\")","v":"Complete"}]
[null,null,"Any Additional Comments?",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Max Expanded hours",{"$f":"IF(AG154=\"\",30,IF(AG154>2,0,30))","v":30},{"$f":"IF(AG154=\"\",25,IF(AG154>2,0,25))","v":25},null,null,null,null,null,null,"DAF Complete?"]
["7f",null,null,null,null,null,null,null,null,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":"IF(W147+W152+X152+Y152+Z152+AA152+AB152+AC152+AD152+AE152+AF152+AG152+W154+X154+Y154+Z154+AA154>0,\"Incomplete\",\"Complete\")","v":"Complete"}]
[]
[]
[]
[8,null,"Reason for adjustment",null,null,null,null,null,null,null,null,{"$f":"IF(F165=$Z$4,$AA$13,IF(F165=$Z$6,$AA$14,IF(F165=$Z$5,$AA$15,\"\")))","v":""},null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND($F165=$Z$4,$S165=\"\"),\"1\",IF(AND($F165=$Z$5,$S165=\"\"),\"1\",IF(AND($F165=$Z$6,$S165=\"\"),\"1\",\"0\")))","v":"0"}]
[]
["8a",null,{"$f":"IF(F165=$Z$4,$Z$16,IF(F165=$Z$6,$Z$18,IF(F165=$Z$8,$Z$19,IF(F165=$Z$5,$Z$17,\"\"))))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND($F165=$Z$4,$M167=\"\"),\"1\",IF(AND($F165=$Z$5,$M167=\"\"),\"1\",IF(AND($F165=$Z$6,$M167=\"\"),\"1\",IF(AND($F165=$Z$8,$M167=\"\"),\"1\",\"0\"))))","v":"0"}]
[]
[null,null,{"$f":"IF(AND(F165=$Z$4,M167=$AA$16),$AA$4,IF(AND(F165=$Z$4,M167=$AA$17),$AA$9,IF(F165=$Z$5,$AA$5,IF(F165=$Z$6,$AA$6,IF(F165=$Z$7,$AA$7,IF(F165=$Z$8,$AA$8,\"\"))))))","v":""}]
[]
[null,{"$f":"IF(F165=\"\",\"\",IF(AND($F165=$Z$4,$AH172=\"Complete\"),\"Complete Record\",IF(AND($F165=$Z$5,$AH174=\"Complete\"),\"Complete Record\",IF(AND($F165=$Z$6,$AH176=\"Complete\"),\"Complete Record\",IF(AND($F165=$Z$7,$AH179=\"Complete\"),\"Complete Record\",IF(AND($F165=$Z$8,$AH181=\"Complete\"),\"Complete Record\",\"Incomplete Record\"))))))","v":""},"Legal Surname",null,null,"Legal Forename",null,null,"Middle Name",null,"Preferred surname",null,"Preferred forename",null,"DOB\n(DD/MM/YYYY)","Gender","Ethnicity","SEN","Armed Forces Family","In Receipt of DLA",null,null,"Legal Surname","Legal forename","Middle Name","preferred surname","preferred forename","DOB","Gender","Ethnicity","SEN","Armed Forces","DLA","new starter complete?"]
["8b",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($F165=\"\",0,IF(AND($F165<>\"\",$C172<>\"\"),\"0\",\"1\"))","v":0},{"$f":"IF($F165=\"\",0,IF(AND($F165<>\"\",$F172<>\"\"),\"0\",\"1\"))","v":0},null,{"$f":"IF($F165=\"\",0,IF(AND($F165<>\"\",$K172<>\"\"),\"0\",\"1\"))","v":0},{"$f":"IF($F165=\"\",0,IF(AND($F165<>\"\",$M172<>\"\"),\"0\",\"1\"))","v":0},{"$f":"IF($F165=\"\",0,IF(AND($F165<>\"\",$O172<>\"\"),\"0\",\"1\"))","v":0},{"$f":"IF($F165=\"\",0,IF(AND($F165<>\"\",$P172<>\"\"),\"0\",\"1\"))","v":0},{"$f":"IF($F165=\"\",0,IF(AND($F165<>\"\",$Q172<>\"\"),\"0\",\"1\"))","v":0},{"$f":"IF($F165=\"\",0,IF(AND($F165<>\"\",$R172<>\"\"),\"0\",\"1\"))","v":0},{"$f":"IF($F165=\"\",0,IF(AND($F165<>\"\",$S172<>\"\"),\"0\",\"1\"))","v":0},{"$f":"IF($F165=\"\",0,IF(AND($F165<>\"\",$T172<>\"\"),\"0\",\"1\"))","v":0},{"$f":"IF(W165+W167+W172+X172+Y172+Z172+AA172+AB172+AC172+AD172+AE172+AF172+AG172+W174+X174+Y174+Z174+AA174+W176+X176+Y176+Z176+AA176+W178+X178+AG176+AB178>0,\"Incomplete\",\"Complete\")","v":"Complete"}]
[null,null,"No. of Flat/Apart.",null,null,"House No./Name",null,null,"Street",null,null,"Local Area",null,null,"Town",null,null,null,"Postcode",null,null,null,"no. Flat","House No.","Street","Town","Postcode",null,"need hours completed?","need previous hours completed","need new residual","need prev residual","AGE","Leaving complete?"]
["8c",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($F165=\"\",0,IF(AND($F165<>\"\",$C174=\"\",$F174=\"\"),\"1\",\"0\"))","v":0},null,{"$f":"IF($F165=\"\",0,IF(AND($F165<>\"\",$I174<>\"\"),\"0\",\"1\"))","v":0},{"$f":"IF($F165=\"\",0,IF(AND($F165<>\"\",$O174<>\"\"),\"0\",\"1\"))","v":0},{"$f":"IF($F165=\"\",0,IF(AND($F165<>\"\",$S174<>\"\"),\"0\",\"1\"))","v":0},null,{"$f":"IF(OR($F165=$Z$4,$F165=$Z$6),1,\"0\")","v":"0"},{"$f":"IF($F165=$Z$6,1,\"0\")","v":"0"},{"$f":"IF($F176=\"stretched\",1,\"0\")","v":"0"},{"$f":"IF($O176=\"stretched\",1,\"0\")","v":"0"},{"$f":"IF(O172=\"\",\"\",IF(O172=$AF$17,2,IF(O172=$AG$17,1,(INT(($AH$17-O172)/365.25)))))","v":""},{"$f":"IF(W165+W167+W172+X172+Y172+Z172+AA172+AB172+AC172+AD172+AE172+AF172+AG172+W174+X174+Y174+Z174+AA174+X178>0,\"Incomplete\",\"Complete\")","v":"Complete"}]
[null,null,{"$f":"IF($F165=$Z$5,\"Claimed Hours\",\"New Claimed Hours\")","v":"New Claimed Hours"},null,null,"Offer Type","Funded Hours\n(Universal and Dis 2's)","Extended hours\n(3&4 Yr Olds)","Expanded hours\n(WP 2's and Under 2's)","No. of Weeks Claiming","Residual Hours?","Previously Claimed hours\n(what was on your last claim/adjustment form)",null,null,"Offer Type","Funded Hours\n(Universal and Dis 2's)","Extended hours\n(3&4 Yr Olds)","Expanded hours\n(WP 2's and Under 2's)","Number of Weeks","Residual Hours?",null,null,"New offer Type","New Funded","New extended","new weeks","new residual","prev offer","prev funded","prev extended","prev weeks","prev residual","New expanded","change of hours complete?"]
["8d",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($F165=\"\",0,IF(AND($F165<>\"\",$F176<>\"\"),\"0\",\"1\"))","v":0},{"$f":"IF($F165=\"\",0,IF(AND($F165<>\"\",OR($G176<>\"\",H176<>\"\",$I176<>\"\")),\"0\",\"1\"))","v":0},{"$f":"IF($F165=\"\",0,IF(AND($F165<>\"\",OR($G176<>\"\",H176<>\"\",$I176<>\"\")),\"0\",\"1\"))","v":0},{"$f":"IF($F165=\"\",0,IF(AND($F165<>\"\",$J176<>\"\"),\"0\",\"1\"))","v":0},{"$f":"IF($F165=\"\",0,IF(AND(F176=\"Stretched\",$K176=\"\"),\"1\",\"0\"))","v":0},{"$f":"IF($F165=\"\",0,IF(AND($F165<>\"\",$O176<>\"\"),\"0\",\"1\"))","v":0},{"$f":"IF($F165=\"\",0,IF(AND($F165<>\"\",OR(P176<>\"\",Q176<>\"\",R176<>\"\")),\"0\",\"1\"))","v":0},{"$f":"IF($F165=\"\",0,IF(AND($F165<>\"\",OR(P176<>\"\",Q176<>\"\",R176<>\"\")),\"0\",\"1\"))","v":0},{"$f":"IF($F165=\"\",0,IF(AND($F165<>\"\",$S176<>\"\"),\"0\",\"1\"))","v":0},{"$f":"IF($F165=\"\",0,IF(AND(O176=\"Stretched\",T176=\"\"),\"1\",\"0\"))","v":0},{"$f":"IF($F165=\"\",0,IF(AND($F165<>\"\",OR($G176<>\"\",H176<>\"\",$I176<>\"\")),\"0\",\"1\"))","v":0},{"$f":"IF(W165+W167+W172+X172+Y172+Z172+AA172+AB172+AC172+AD172+AE172+AF172+AG172+W174+X174+Y174+Z174+AA174+W176+X176+Y176+Z176+AA176+W178+X178+AB176+AC176+AD176+AE176+AF176+AG176+AG179+AB178>0,\"Incomplete\",\"Complete\")","v":"Complete"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Code","portal"]
["8e",null,"Eligibility Code",null,null,null,"Has the code been checked on your eligibility code portal?",null,null,null,null,null,null,{"$f":"CONCATENATE(\"Please ensure that the code is valid for \",$J$20,\" \",$S$20)","v":"Please ensure that the code is valid for  "},null,null,null,null,null,null,null,null,{"$f":"IF(AND($I176>0.1,$E178=\"\"),\"1\",\"0\")","v":"0"},{"$f":"IF(AND($E178>10000000000,$E178<60000000000,$M178=\"\"),\"1\",\"0\")","v":"0"},"Max funded Hours",{"$f":"IF(AG174=2,15,IF(AG174<2,0,15))","v":15},{"$f":"IF(AG174=2,12.5,IF(AG174<2,0,12.5))","v":12.5},{"$f":"IF(AND($H176>0.1,$E178=\"\"),\"1\",\"0\")","v":"0"},null,null,null,null,"previous expanded","change childs details complete?"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Max Extended hours",{"$f":"IF(AG174=2,0,IF(AG174<2,0,15))","v":15},{"$f":"IF(AG174=2,0,IF(AG174<2,0,12.5))","v":12.5},null,null,null,null,null,{"$f":"IF($F165=\"\",0,IF(AND($F165<>\"\",OR(P176<>\"\",Q176<>\"\",R176<>\"\")),\"0\",\"1\"))","v":0},{"$f":"IF(W172+X172+Y172+Z172+AA172+AB172+AC172+AD172+AE172+AF172+AG172+W174+X174+Y174+Z174+AA174>0,\"Incomplete\",\"Complete\")","v":"Complete"}]
[null,null,"Any Additional Comments?",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Max Expanded hours",{"$f":"IF(AG174=\"\",30,IF(AG174>2,0,30))","v":30},{"$f":"IF(AG174=\"\",25,IF(AG174>2,0,25))","v":25},null,null,null,null,null,null,"DAF Complete?"]
["8f",null,null,null,null,null,null,null,null,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":"IF(W167+W172+X172+Y172+Z172+AA172+AB172+AC172+AD172+AE172+AF172+AG172+W174+X174+Y174+Z174+AA174>0,\"Incomplete\",\"Complete\")","v":"Complete"}]
[]
[]
[]
[9,null,"Reason for adjustment",null,null,null,null,null,null,null,null,{"$f":"IF(F185=$Z$4,$AA$13,IF(F185=$Z$6,$AA$14,IF(F185=$Z$5,$AA$15,\"\")))","v":""},null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND($F185=$Z$4,$S185=\"\"),\"1\",IF(AND($F185=$Z$5,$S185=\"\"),\"1\",IF(AND($F185=$Z$6,$S185=\"\"),\"1\",\"0\")))","v":"0"}]
[]
["9a",null,{"$f":"IF(F185=$Z$4,$Z$16,IF(F185=$Z$6,$Z$18,IF(F185=$Z$8,$Z$19,IF(F185=$Z$5,$Z$17,\"\"))))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND($F185=$Z$4,$M187=\"\"),\"1\",IF(AND($F185=$Z$5,$M187=\"\"),\"1\",IF(AND($F185=$Z$6,$M187=\"\"),\"1\",IF(AND($F185=$Z$8,$M187=\"\"),\"1\",\"0\"))))","v":"0"}]
[]
[null,null,{"$f":"IF(AND(F185=$Z$4,M187=$AA$16),$AA$4,IF(AND(F185=$Z$4,M187=$AA$17),$AA$9,IF(F185=$Z$5,$AA$5,IF(F185=$Z$6,$AA$6,IF(F185=$Z$7,$AA$7,IF(F185=$Z$8,$AA$8,\"\"))))))","v":""}]
[]
[null,{"$f":"IF(F185=\"\",\"\",IF(AND($F185=$Z$4,$AH192=\"Complete\"),\"Complete Record\",IF(AND($F185=$Z$5,$AH194=\"Complete\"),\"Complete Record\",IF(AND($F185=$Z$6,$AH196=\"Complete\"),\"Complete Record\",IF(AND($F185=$Z$7,$AH199=\"Complete\"),\"Complete Record\",IF(AND($F185=$Z$8,$AH201=\"Complete\"),\"Complete Record\",\"Incomplete Record\"))))))","v":""},"Legal Surname",null,null,"Legal Forename",null,null,"Middle Name",null,"Preferred surname",null,"Preferred forename",null,"DOB\n(DD/MM/YYYY)","Gender","Ethnicity","SEN","Armed Forces Family","In Receipt of DLA",null,null,"Legal Surname","Legal forename","Middle Name","preferred surname","preferred forename","DOB","Gender","Ethnicity","SEN","Armed Forces","DLA","new starter complete?"]
["9b",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($F185=\"\",0,IF(AND($F185<>\"\",$C192<>\"\"),\"0\",\"1\"))","v":0},{"$f":"IF($F185=\"\",0,IF(AND($F185<>\"\",$F192<>\"\"),\"0\",\"1\"))","v":0},null,{"$f":"IF($F185=\"\",0,IF(AND($F185<>\"\",$K192<>\"\"),\"0\",\"1\"))","v":0},{"$f":"IF($F185=\"\",0,IF(AND($F185<>\"\",$M192<>\"\"),\"0\",\"1\"))","v":0},{"$f":"IF($F185=\"\",0,IF(AND($F185<>\"\",$O192<>\"\"),\"0\",\"1\"))","v":0},{"$f":"IF($F185=\"\",0,IF(AND($F185<>\"\",$P192<>\"\"),\"0\",\"1\"))","v":0},{"$f":"IF($F185=\"\",0,IF(AND($F185<>\"\",$Q192<>\"\"),\"0\",\"1\"))","v":0},{"$f":"IF($F185=\"\",0,IF(AND($F185<>\"\",$R192<>\"\"),\"0\",\"1\"))","v":0},{"$f":"IF($F185=\"\",0,IF(AND($F185<>\"\",$S192<>\"\"),\"0\",\"1\"))","v":0},{"$f":"IF($F185=\"\",0,IF(AND($F185<>\"\",$T192<>\"\"),\"0\",\"1\"))","v":0},{"$f":"IF(W185+W187+W192+X192+Y192+Z192+AA192+AB192+AC192+AD192+AE192+AF192+AG192+W194+X194+Y194+Z194+AA194+W196+X196+Y196+Z196+AA196+W198+X198+AG196+AB198>0,\"Incomplete\",\"Complete\")","v":"Complete"}]
[null,null,"No. of Flat/Apart.",null,null,"House No./Name",null,null,"Street",null,null,"Local Area",null,null,"Town",null,null,null,"Postcode",null,null,null,"no. Flat","House No.","Street","Town","Postcode",null,"need hours completed?","need previous hours completed","need new residual","need prev residual","AGE","Leaving complete?"]
["9c",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($F185=\"\",0,IF(AND($F185<>\"\",$C194=\"\",$F194=\"\"),\"1\",\"0\"))","v":0},null,{"$f":"IF($F185=\"\",0,IF(AND($F185<>\"\",$I194<>\"\"),\"0\",\"1\"))","v":0},{"$f":"IF($F185=\"\",0,IF(AND($F185<>\"\",$O194<>\"\"),\"0\",\"1\"))","v":0},{"$f":"IF($F185=\"\",0,IF(AND($F185<>\"\",$S194<>\"\"),\"0\",\"1\"))","v":0},null,{"$f":"IF(OR($F185=$Z$4,$F185=$Z$6),1,\"0\")","v":"0"},{"$f":"IF($F185=$Z$6,1,\"0\")","v":"0"},{"$f":"IF($F196=\"stretched\",1,\"0\")","v":"0"},{"$f":"IF($O196=\"stretched\",1,\"0\")","v":"0"},{"$f":"IF(O192=\"\",\"\",IF(O192=$AF$17,2,IF(O192=$AG$17,1,(INT(($AH$17-O192)/365.25)))))","v":""},{"$f":"IF(W185+W187+W192+X192+Y192+Z192+AA192+AB192+AC192+AD192+AE192+AF192+AG192+W194+X194+Y194+Z194+AA194+X198>0,\"Incomplete\",\"Complete\")","v":"Complete"}]
[null,null,{"$f":"IF($F185=$Z$5,\"Claimed Hours\",\"New Claimed Hours\")","v":"New Claimed Hours"},null,null,"Offer Type","Funded Hours\n(Universal and Dis 2's)","Extended hours\n(3&4 Yr Olds)","Expanded hours\n(WP 2's and Under 2's)","No. of Weeks Claiming","Residual Hours?","Previously Claimed hours\n(what was on your last claim/adjustment form)",null,null,"Offer Type","Funded Hours\n(Universal and Dis 2's)","Extended hours\n(3&4 Yr Olds)","Expanded hours\n(WP 2's and Under 2's)","Number of Weeks","Residual Hours?",null,null,"New offer Type","New Funded","New extended","new weeks","new residual","prev offer","prev funded","prev extended","prev weeks","prev residual","New expanded","change of hours complete?"]
["9d",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($F185=\"\",0,IF(AND($F185<>\"\",$F196<>\"\"),\"0\",\"1\"))","v":0},{"$f":"IF($F185=\"\",0,IF(AND($F185<>\"\",OR($G196<>\"\",H196<>\"\",$I196<>\"\")),\"0\",\"1\"))","v":0},{"$f":"IF($F185=\"\",0,IF(AND($F185<>\"\",OR($G196<>\"\",H196<>\"\",$I196<>\"\")),\"0\",\"1\"))","v":0},{"$f":"IF($F185=\"\",0,IF(AND($F185<>\"\",$J196<>\"\"),\"0\",\"1\"))","v":0},{"$f":"IF($F185=\"\",0,IF(AND(F196=\"Stretched\",$K196=\"\"),\"1\",\"0\"))","v":0},{"$f":"IF($F185=\"\",0,IF(AND($F185<>\"\",$O196<>\"\"),\"0\",\"1\"))","v":0},{"$f":"IF($F185=\"\",0,IF(AND($F185<>\"\",OR(P196<>\"\",Q196<>\"\",R196<>\"\")),\"0\",\"1\"))","v":0},{"$f":"IF($F185=\"\",0,IF(AND($F185<>\"\",OR(P196<>\"\",Q196<>\"\",R196<>\"\")),\"0\",\"1\"))","v":0},{"$f":"IF($F185=\"\",0,IF(AND($F185<>\"\",$S196<>\"\"),\"0\",\"1\"))","v":0},{"$f":"IF($F185=\"\",0,IF(AND(O196=\"Stretched\",T196=\"\"),\"1\",\"0\"))","v":0},{"$f":"IF($F185=\"\",0,IF(AND($F185<>\"\",OR($G196<>\"\",H196<>\"\",$I196<>\"\")),\"0\",\"1\"))","v":0},{"$f":"IF(W185+W187+W192+X192+Y192+Z192+AA192+AB192+AC192+AD192+AE192+AF192+AG192+W194+X194+Y194+Z194+AA194+W196+X196+Y196+Z196+AA196+W198+X198+AB196+AC196+AD196+AE196+AF196+AG196+AG199+AB198>0,\"Incomplete\",\"Complete\")","v":"Complete"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Code","portal"]
["9e",null,"Eligibility Code",null,null,null,"Has the code been checked on your eligibility code portal?",null,null,null,null,null,null,{"$f":"CONCATENATE(\"Please ensure that the code is valid for \",$J$20,\" \",$S$20)","v":"Please ensure that the code is valid for  "},null,null,null,null,null,null,null,null,{"$f":"IF(AND($I196>0.1,$E198=\"\"),\"1\",\"0\")","v":"0"},{"$f":"IF(AND($E198>10000000000,$E198<60000000000,$M198=\"\"),\"1\",\"0\")","v":"0"},"Max funded Hours",{"$f":"IF(AG194=2,15,IF(AG194<2,0,15))","v":15},{"$f":"IF(AG194=2,12.5,IF(AG194<2,0,12.5))","v":12.5},{"$f":"IF(AND($H196>0.1,$E198=\"\"),\"1\",\"0\")","v":"0"},null,null,null,null,"previous expanded","change childs details complete?"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Max Extended hours",{"$f":"IF(AG194=2,0,IF(AG194<2,0,15))","v":15},{"$f":"IF(AG194=2,0,IF(AG194<2,0,12.5))","v":12.5},null,null,null,null,null,{"$f":"IF($F185=\"\",0,IF(AND($F185<>\"\",OR(P196<>\"\",Q196<>\"\",R196<>\"\")),\"0\",\"1\"))","v":0},{"$f":"IF(W192+X192+Y192+Z192+AA192+AB192+AC192+AD192+AE192+AF192+AG192+W194+X194+Y194+Z194+AA194>0,\"Incomplete\",\"Complete\")","v":"Complete"}]
[null,null,"Any Additional Comments?",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Max Expanded hours",{"$f":"IF(AG194=\"\",30,IF(AG194>2,0,30))","v":30},{"$f":"IF(AG194=\"\",25,IF(AG194>2,0,25))","v":25},null,null,null,null,null,null,"DAF Complete?"]
["9f",null,null,null,null,null,null,null,null,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":"IF(W187+W192+X192+Y192+Z192+AA192+AB192+AC192+AD192+AE192+AF192+AG192+W194+X194+Y194+Z194+AA194>0,\"Incomplete\",\"Complete\")","v":"Complete"}]
[]
[]
[]
[10,null,"Reason for adjustment",null,null,null,null,null,null,null,null,{"$f":"IF(F205=$Z$4,$AA$13,IF(F205=$Z$6,$AA$14,IF(F205=$Z$5,$AA$15,\"\")))","v":""},null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND($F205=$Z$4,$S205=\"\"),\"1\",IF(AND($F205=$Z$5,$S205=\"\"),\"1\",IF(AND($F205=$Z$6,$S205=\"\"),\"1\",\"0\")))","v":"0"}]
[]
["10a",null,{"$f":"IF(F205=$Z$4,$Z$16,IF(F205=$Z$6,$Z$18,IF(F205=$Z$8,$Z$19,IF(F205=$Z$5,$Z$17,\"\"))))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND($F205=$Z$4,$M207=\"\"),\"1\",IF(AND($F205=$Z$5,$M207=\"\"),\"1\",IF(AND($F205=$Z$6,$M207=\"\"),\"1\",IF(AND($F205=$Z$8,$M207=\"\"),\"1\",\"0\"))))","v":"0"}]
[]
[null,null,{"$f":"IF(AND(F205=$Z$4,M207=$AA$16),$AA$4,IF(AND(F205=$Z$4,M207=$AA$17),$AA$9,IF(F205=$Z$5,$AA$5,IF(F205=$Z$6,$AA$6,IF(F205=$Z$7,$AA$7,IF(F205=$Z$8,$AA$8,\"\"))))))","v":""}]
[]
[null,{"$f":"IF(F205=\"\",\"\",IF(AND($F205=$Z$4,$AH212=\"Complete\"),\"Complete Record\",IF(AND($F205=$Z$5,$AH214=\"Complete\"),\"Complete Record\",IF(AND($F205=$Z$6,$AH216=\"Complete\"),\"Complete Record\",IF(AND($F205=$Z$7,$AH219=\"Complete\"),\"Complete Record\",IF(AND($F205=$Z$8,$AH221=\"Complete\"),\"Complete Record\",\"Incomplete Record\"))))))","v":""},"Legal Surname",null,null,"Legal Forename",null,null,"Middle Name",null,"Preferred surname",null,"Preferred forename",null,"DOB\n(DD/MM/YYYY)","Gender","Ethnicity","SEN","Armed Forces Family","In Receipt of DLA",null,null,"Legal Surname","Legal forename","Middle Name","preferred surname","preferred forename","DOB","Gender","Ethnicity","SEN","Armed Forces","DLA","new starter complete?"]
["10b",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($F205=\"\",0,IF(AND($F205<>\"\",$C212<>\"\"),\"0\",\"1\"))","v":0},{"$f":"IF($F205=\"\",0,IF(AND($F205<>\"\",$F212<>\"\"),\"0\",\"1\"))","v":0},null,{"$f":"IF($F205=\"\",0,IF(AND($F205<>\"\",$K212<>\"\"),\"0\",\"1\"))","v":0},{"$f":"IF($F205=\"\",0,IF(AND($F205<>\"\",$M212<>\"\"),\"0\",\"1\"))","v":0},{"$f":"IF($F205=\"\",0,IF(AND($F205<>\"\",$O212<>\"\"),\"0\",\"1\"))","v":0},{"$f":"IF($F205=\"\",0,IF(AND($F205<>\"\",$P212<>\"\"),\"0\",\"1\"))","v":0},{"$f":"IF($F205=\"\",0,IF(AND($F205<>\"\",$Q212<>\"\"),\"0\",\"1\"))","v":0},{"$f":"IF($F205=\"\",0,IF(AND($F205<>\"\",$R212<>\"\"),\"0\",\"1\"))","v":0},{"$f":"IF($F205=\"\",0,IF(AND($F205<>\"\",$S212<>\"\"),\"0\",\"1\"))","v":0},{"$f":"IF($F205=\"\",0,IF(AND($F205<>\"\",$T212<>\"\"),\"0\",\"1\"))","v":0},{"$f":"IF(W205+W207+W212+X212+Y212+Z212+AA212+AB212+AC212+AD212+AE212+AF212+AG212+W214+X214+Y214+Z214+AA214+W216+X216+Y216+Z216+AA216+W218+X218+AG216+AB218>0,\"Incomplete\",\"Complete\")","v":"Complete"}]
[null,null,"No. of Flat/Apart.",null,null,"House No./Name",null,null,"Street",null,null,"Local Area",null,null,"Town",null,null,null,"Postcode",null,null,null,"no. Flat","House No.","Street","Town","Postcode",null,"need hours completed?","need previous hours completed","need new residual","need prev residual","AGE","Leaving complete?"]
["10c",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($F205=\"\",0,IF(AND($F205<>\"\",$C214=\"\",$F214=\"\"),\"1\",\"0\"))","v":0},null,{"$f":"IF($F205=\"\",0,IF(AND($F205<>\"\",$I214<>\"\"),\"0\",\"1\"))","v":0},{"$f":"IF($F205=\"\",0,IF(AND($F205<>\"\",$O214<>\"\"),\"0\",\"1\"))","v":0},{"$f":"IF($F205=\"\",0,IF(AND($F205<>\"\",$S214<>\"\"),\"0\",\"1\"))","v":0},null,{"$f":"IF(OR($F205=$Z$4,$F205=$Z$6),1,\"0\")","v":"0"},{"$f":"IF($F205=$Z$6,1,\"0\")","v":"0"},{"$f":"IF($F216=\"stretched\",1,\"0\")","v":"0"},{"$f":"IF($O216=\"stretched\",1,\"0\")","v":"0"},{"$f":"IF(O212=\"\",\"\",IF(O212=$AF$17,2,IF(O212=$AG$17,1,(INT(($AH$17-O212)/365.25)))))","v":""},{"$f":"IF(W205+W207+W212+X212+Y212+Z212+AA212+AB212+AC212+AD212+AE212+AF212+AG212+W214+X214+Y214+Z214+AA214+X218>0,\"Incomplete\",\"Complete\")","v":"Complete"}]
[null,null,{"$f":"IF($F205=$Z$5,\"Claimed Hours\",\"New Claimed Hours\")","v":"New Claimed Hours"},null,null,"Offer Type","Funded Hours\n(Universal and Dis 2's)","Extended hours\n(3&4 Yr Olds)","Expanded hours\n(WP 2's and Under 2's)","No. of Weeks Claiming","Residual Hours?","Previously Claimed hours\n(what was on your last claim/adjustment form)",null,null,"Offer Type","Funded Hours\n(Universal and Dis 2's)","Extended hours\n(3&4 Yr Olds)","Expanded hours\n(WP 2's and Under 2's)","Number of Weeks","Residual Hours?",null,null,"New offer Type","New Funded","New extended","new weeks","new residual","prev offer","prev funded","prev extended","prev weeks","prev residual","New expanded","change of hours complete?"]
["10d",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($F205=\"\",0,IF(AND($F205<>\"\",$F216<>\"\"),\"0\",\"1\"))","v":0},{"$f":"IF($F205=\"\",0,IF(AND($F205<>\"\",OR($G216<>\"\",H216<>\"\",$I216<>\"\")),\"0\",\"1\"))","v":0},{"$f":"IF($F205=\"\",0,IF(AND($F205<>\"\",OR($G216<>\"\",H216<>\"\",$I216<>\"\")),\"0\",\"1\"))","v":0},{"$f":"IF($F205=\"\",0,IF(AND($F205<>\"\",$J216<>\"\"),\"0\",\"1\"))","v":0},{"$f":"IF($F205=\"\",0,IF(AND(F216=\"Stretched\",$K216=\"\"),\"1\",\"0\"))","v":0},{"$f":"IF($F205=\"\",0,IF(AND($F205<>\"\",$O216<>\"\"),\"0\",\"1\"))","v":0},{"$f":"IF($F205=\"\",0,IF(AND($F205<>\"\",OR(P216<>\"\",Q216<>\"\",R216<>\"\")),\"0\",\"1\"))","v":0},{"$f":"IF($F205=\"\",0,IF(AND($F205<>\"\",OR(P216<>\"\",Q216<>\"\",R216<>\"\")),\"0\",\"1\"))","v":0},{"$f":"IF($F205=\"\",0,IF(AND($F205<>\"\",$S216<>\"\"),\"0\",\"1\"))","v":0},{"$f":"IF($F205=\"\",0,IF(AND(O216=\"Stretched\",T216=\"\"),\"1\",\"0\"))","v":0},{"$f":"IF($F205=\"\",0,IF(AND($F205<>\"\",OR($G216<>\"\",H216<>\"\",$I216<>\"\")),\"0\",\"1\"))","v":0},{"$f":"IF(W205+W207+W212+X212+Y212+Z212+AA212+AB212+AC212+AD212+AE212+AF212+AG212+W214+X214+Y214+Z214+AA214+W216+X216+Y216+Z216+AA216+W218+X218+AB216+AC216+AD216+AE216+AF216+AG216+AG219+AB218>0,\"Incomplete\",\"Complete\")","v":"Complete"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Code","portal"]
["10e",null,"Eligibility Code",null,null,null,"Has the code been checked on your eligibility code portal?",null,null,null,null,null,null,{"$f":"CONCATENATE(\"Please ensure that the code is valid for \",$J$20,\" \",$S$20)","v":"Please ensure that the code is valid for  "},null,null,null,null,null,null,null,null,{"$f":"IF(AND($I216>0.1,$E218=\"\"),\"1\",\"0\")","v":"0"},{"$f":"IF(AND($E218>10000000000,$E218<60000000000,$M218=\"\"),\"1\",\"0\")","v":"0"},"Max funded Hours",{"$f":"IF(AG214=2,15,IF(AG214<2,0,15))","v":15},{"$f":"IF(AG214=2,12.5,IF(AG214<2,0,12.5))","v":12.5},{"$f":"IF(AND($H216>0.1,$E218=\"\"),\"1\",\"0\")","v":"0"},null,null,null,null,"previous expanded","change childs details complete?"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Max Extended hours",{"$f":"IF(AG214=2,0,IF(AG214<2,0,15))","v":15},{"$f":"IF(AG214=2,0,IF(AG214<2,0,12.5))","v":12.5},null,null,null,null,null,{"$f":"IF($F205=\"\",0,IF(AND($F205<>\"\",OR(P216<>\"\",Q216<>\"\",R216<>\"\")),\"0\",\"1\"))","v":0},{"$f":"IF(W212+X212+Y212+Z212+AA212+AB212+AC212+AD212+AE212+AF212+AG212+W214+X214+Y214+Z214+AA214>0,\"Incomplete\",\"Complete\")","v":"Complete"}]
[null,null,"Any Additional Comments?",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Max Expanded hours",{"$f":"IF(AG214=\"\",30,IF(AG214>2,0,30))","v":30},{"$f":"IF(AG214=\"\",25,IF(AG214>2,0,25))","v":25},null,null,null,null,null,null,"DAF Complete?"]
["10f",null,null,null,null,null,null,null,null,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":"IF(W207+W212+X212+Y212+Z212+AA212+AB212+AC212+AD212+AE212+AF212+AG212+W214+X214+Y214+Z214+AA214>0,\"Incomplete\",\"Complete\")","v":"Complete"}]

{"sheet":"Date of Birth Ranges","index":1,"n_rows":16,"n_cols":21,"rows_kept":16,"cut":false,"hidden":false,"merged":[]}
[]
[null,"The valid Date of Birth Age ranges for each term are as follows"]
[]
[]
[null,"Spring Term 2024","Dates of birth must be between ","2019-01-01","and","2021-12-31",null,"3&4 Years Olds between","2019-01-01","and","2020-12-31",null,"2 Years Olds between","2021-01-01","and","2021-12-31"]
[null,"Summer Term 2024","Dates of birth must be between ","2019-04-01","and","2022-03-31",null,"3&4 Years Olds between","2019-04-01","and","2021-03-31",null,"2 Years Olds between","2021-04-01","and","2022-03-31"]
[null,"Autumn Term 2024","Dates of birth must be between ","2019-09-01","and","2023-12-31",null,"3&4 Years Olds between","2019-09-01","and","2021-08-31",null,"2 Years Olds between","2021-09-01","and","2022-08-31",null,"Under 2s between","2022-09-01","and","2023-12-31"]
[null,"Spring Term 2025","Dates of birth must be between ","2020-01-01","and","2022-12-31",null,"3&4 Years Olds between","2020-01-01","and","2021-12-31",null,"2 Years Olds between","2022-01-01","and","2022-12-31",null,"Under 2s between","2023-01-01","and","2024-03-31"]
[null,"Summer Term 2025","Dates of birth must be between ","2020-04-01","and","2024-06-30",null,"3&4 Years Olds between","2020-04-01","and","2022-03-31",null,"2 Years Olds between","2022-04-01","and","2023-03-31",null,"Under 2s between","2023-04-01","and","2024-06-30"]
[null,"Autumn Term 2025","Dates of birth must be between ","2020-09-01","and","2024-12-31",null,"3&4 Years Olds between","2020-09-01","and","2022-08-31",null,"2 Years Olds between","2022-09-01","and","2023-08-31",null,"Under 2s between","2023-09-01","and","2024-12-31"]
[null,"Spring Term 2026","Dates of birth must be between ","2021-01-01","and","2023-12-31",null,"3&4 Years Olds between","2021-01-01","and","2022-12-31",null,"2 Years Olds between","2023-01-01","and","2023-12-31",null,"Under 2s between","2024-01-01","and","2025-03-31"]
[null,"Summer Term 2026","Dates of birth must be between ","2021-04-01","and","2025-06-30",null,"3&4 Years Olds between","2021-04-01","and","2023-03-31",null,"2 Years Olds between","2023-04-01","and","2024-03-31",null,"Under 2s between","2024-04-01","and","2025-06-30"]
[null,"Autumn Term 2026","Dates of birth must be between ","2021-09-01","and","2025-12-31",null,"3&4 Years Olds between","2021-09-01","and","2023-08-31",null,"2 Years Olds between","2023-09-01","and","2024-08-31",null,"Under 2s between","2024-09-01","and","2025-12-31"]
[null,"Spring Term 2027","Dates of birth must be between ","2022-01-01","and","2024-12-31",null,"3&4 Years Olds between","2022-01-01","and","2023-12-31",null,"2 Years Olds between","2024-01-01","and","2024-12-31",null,"Under 2s between","2025-01-01","and","2026-03-31"]
[null,"Summer Term 2027","Dates of birth must be between ","2022-04-01","and","2026-06-30",null,"3&4 Years Olds between","2022-04-01","and","2024-03-31",null,"2 Years Olds between","2024-04-01","and","2025-03-31",null,"Under 2s between","2025-04-01","and","2026-06-30"]
[null,"Autumn Term 2027","Dates of birth must be between ","2022-09-01","and","2026-12-31",null,"3&4 Years Olds between","2022-09-01","and","2024-08-31",null,"2 Years Olds between","2024-09-01","and","2025-08-31",null,"Under 2s between","2025-09-01","and","2026-12-31"]

{"sheet":"Admin","index":2,"n_rows":13,"n_cols":11,"rows_kept":13,"cut":false,"hidden":true,"merged":[]}
[null,null,null,"3&4",null,2,null,"Under 2",null,null,"Date Validation"]
["Spring Term 2024","2019-01-01","2021-12-31","2019-01-01","2020-12-31","2021-01-01","2021-12-31",null,null,"2024-01-01","2024-03-31"]
["Summer Term 2024","2019-04-01","2022-03-31","2019-04-01","2021-03-31","2021-04-01","2022-03-31",null,null,"2024-04-01","2024-08-31"]
["Autumn Term 2024","2019-09-01","2023-12-31","2019-09-01","2021-08-31","2021-09-01","2022-08-31","2022-09-01","2023-12-31","2024-09-01","2024-12-31"]
["Spring Term 2025","2020-01-01","2022-12-31","2020-01-01","2021-12-31","2022-01-01","2022-12-31","2023-01-01","2024-03-31","2025-01-01","2025-03-31"]
["Summer Term 2025","2020-04-01","2024-06-30","2020-04-01","2022-03-31","2022-04-01","2023-03-31","2023-04-01","2024-06-30","2025-04-01","2025-08-31"]
["Autumn Term 2025","2020-09-01","2024-12-31","2020-09-01","2022-08-31","2022-09-01","2023-08-31","2023-09-01","2024-12-31","2025-09-01",{"$f":"TODAY()","v":"2026-01-09"}]
["Spring Term 2026","2021-01-01","2023-12-31","2021-01-01","2022-12-31","2023-01-01","2023-12-31","2024-01-01","2025-03-31","2026-01-01"]
["Summer Term 2026","2021-04-01","2025-06-30","2021-04-01","2023-03-31","2023-04-01","2024-03-31","2024-04-01","2025-06-30","2026-04-01"]
["Autumn Term 2026","2021-09-01","2025-12-31","2021-09-01","2023-08-31","2023-09-01","2024-08-31","2024-09-01","2025-12-31","2026-09-01"]
["Spring Term 2027","2022-01-01","2024-12-31","2022-01-01","2023-12-31","2024-01-01","2024-12-31","2025-01-01","2026-03-31","2027-01-01"]
["Summer Term 2027","2022-04-01","2026-06-30","2022-04-01","2024-03-31","2024-04-01","2025-03-31","2025-04-01","2026-06-30","2027-04-01"]
["Autumn Term 2027","2022-09-01","2026-12-31","2022-09-01","2024-08-31","2024-09-01","2025-08-31","2025-09-01","2026-12-31","2027-09-01"]

{"sheet":"Summary (READ ONLY)","index":3,"n_rows":19,"n_cols":37,"rows_kept":19,"cut":false,"hidden":false,"merged":[[5,2,5,6],[5,8,5,9],[2,2,2,11],[2,13,2,14],[3,2,3,5],[3,7,3,11],[3,13,3,16]]}
[null,"Claim Adjustment Form Summary"]
[]
[null,"Setting Name",{"$f":"'Claim Adjustment Form'!F8","v":0},null,null,null,null,null,null,null,null,null,"Funding URN",{"$f":"'Claim Adjustment Form'!R8","v":0},null,"Date",{"$f":"'Claim Adjustment Form'!R12","v":"00:00:00"}]
[null,"Name Person completing",{"$f":"'Claim Adjustment Form'!G12","v":0},null,null,null,"Email",{"$f":"'Claim Adjustment Form'!E14","v":0},null,null,null,null,"Telephone",{"$f":"'Claim Adjustment Form'!R14","v":0}]
[]
[null,"The term the adjustment is for",{"$f":"'Claim Adjustment Form'!J20","v":0},null,null,null,null,"Year",{"$f":"'Claim Adjustment Form'!S20","v":0}]
[]
[]
[null,"Reason for adjustment","Date for adjustment","attended another setting","Legal Surname","Legal forename","middle name","preferred surname","preferred forename","DOB","Gender","Ethnicity","SEN","Armed Forces","DLA","Age","Offer Type","Universal","Extended","Expanded","Weeks","Residual","OLD Offer Type","OLD Universal","OLD Extended","OLD Expanded","OLD Weeks","OLD Residual","Eligibility code","Flat number","house number","street","local area","town","postcode","code checked?","Comments"]
[1,{"$f":"IF(VLOOKUP($A10,'Claim Adjustment Form'!A:T,6,FALSE)=\"\",\"\",(VLOOKUP($A10,'Claim Adjustment Form'!A:T,6,FALSE)))","v":""},{"$f":"IF(VLOOKUP($A10,'Claim Adjustment Form'!A:T,19,FALSE)=\"\",\"\",(VLOOKUP($A10,'Claim Adjustment Form'!A:T,19,FALSE)))","v":""},{"$f":"IF(VLOOKUP($A10&\"a\",'Claim Adjustment Form'!A:T,13,FALSE)=\"\",\"\",(VLOOKUP($A10&\"a\",'Claim Adjustment Form'!A:T,13,FALSE)))","v":""},{"$f":"IF(VLOOKUP($A10&\"b\",'Claim Adjustment Form'!A:T,3,FALSE)=\"\",\"\",(VLOOKUP($A10&\"b\",'Claim Adjustment Form'!A:T,3,FALSE)))","v":""},{"$f":"IF(VLOOKUP($A10&\"b\",'Claim Adjustment Form'!A:T,6,FALSE)=\"\",\"\",(VLOOKUP($A10&\"b\",'Claim Adjustment Form'!A:T,6,FALSE)))","v":""},{"$f":"IF(VLOOKUP($A10&\"b\",'Claim Adjustment Form'!A:T,9,FALSE)=\"\",\"\",(VLOOKUP($A10&\"b\",'Claim Adjustment Form'!A:T,9,FALSE)))","v":""},{"$f":"IF(VLOOKUP($A10&\"b\",'Claim Adjustment Form'!A:T,11,FALSE)=\"\",\"\",(VLOOKUP($A10&\"b\",'Claim Adjustment Form'!A:T,11,FALSE)))","v":""},{"$f":"IF(VLOOKUP($A10&\"b\",'Claim Adjustment Form'!A:T,13,FALSE)=\"\",\"\",(VLOOKUP($A10&\"b\",'Claim Adjustment Form'!A:T,13,FALSE)))","v":""},{"$f":"IF(VLOOKUP($A10&\"b\",'Claim Adjustment Form'!A:T,15,FALSE)=\"\",\"\",(VLOOKUP($A10&\"b\",'Claim Adjustment Form'!A:T,15,FALSE)))","v":""},{"$f":"IF(VLOOKUP($A10&\"b\",'Claim Adjustment Form'!A:T,16,FALSE)=\"\",\"\",(VLOOKUP($A10&\"b\",'Claim Adjustment Form'!A:T,16,FALSE)))","v":""},{"$f":"IF(VLOOKUP($A10&\"b\",'Claim Adjustment Form'!A:T,17,FALSE)=\"\",\"\",(VLOOKUP($A10&\"b\",'Claim Adjustment Form'!A:T,17,FALSE)))","v":""},{"$f":"IF(VLOOKUP($A10&\"b\",'Claim Adjustment Form'!A:T,18,FALSE)=\"\",\"\",(VLOOKUP($A10&\"b\",'Claim Adjustment Form'!A:T,18,FALSE)))","v":""},{"$f":"IF(VLOOKUP($A10&\"b\",'Claim Adjustment Form'!A:T,19,FALSE)=\"\",\"\",(VLOOKUP($A10&\"b\",'Claim Adjustment Form'!A:T,19,FALSE)))","v":""},{"$f":"IF(VLOOKUP($A10&\"b\",'Claim Adjustment Form'!A:T,20,FALSE)=\"\",\"\",(VLOOKUP($A10&\"b\",'Claim Adjustment Form'!A:T,20,FALSE)))","v":""},{"$f":"IF(VLOOKUP($A10&\"c\",'Claim Adjustment Form'!A:AG,33,FALSE)=\"\",\"\",(VLOOKUP($A10&\"c\",'Claim Adjustment Form'!A:AG,33,FALSE)))","v":""},{"$f":"IF(VLOOKUP($A10&\"d\",'Claim Adjustment Form'!A:F,6,FALSE)=\"\",\"\",(VLOOKUP($A10&\"d\",'Claim Adjustment Form'!A:F,6,FALSE)))","v":""},{"$f":"IF(VLOOKUP($A10&\"d\",'Claim Adjustment Form'!A:T,7,FALSE)=\"\",\"\",(VLOOKUP($A10&\"d\",'Claim Adjustment Form'!A:T,7,FALSE)))","v":""},{"$f":"IF(VLOOKUP($A10&\"d\",'Claim Adjustment Form'!A:T,8,FALSE)=\"\",\"\",(VLOOKUP($A10&\"d\",'Claim Adjustment Form'!A:T,8,FALSE)))","v":""},{"$f":"IF(VLOOKUP($A10&\"d\",'Claim Adjustment Form'!A:T,9,FALSE)=\"\",\"\",(VLOOKUP($A10&\"d\",'Claim Adjustment Form'!A:T,9,FALSE)))","v":""},{"$f":"IF(VLOOKUP($A10&\"d\",'Claim Adjustment Form'!A:T,10,FALSE)=\"\",\"\",(VLOOKUP($A10&\"d\",'Claim Adjustment Form'!A:T,10,FALSE)))","v":""},{"$f":"IF(VLOOKUP($A10&\"d\",'Claim Adjustment Form'!A:T,11,FALSE)=\"\",\"\",(VLOOKUP($A10&\"d\",'Claim Adjustment Form'!A:T,11,FALSE)))","v":""},{"$f":"IF(VLOOKUP($A10&\"d\",'Claim Adjustment Form'!A:T,15,FALSE)=\"\",\"\",(VLOOKUP($A10&\"d\",'Claim Adjustment Form'!A:T,15,FALSE)))","v":""},{"$f":"IF(VLOOKUP($A10&\"d\",'Claim Adjustment Form'!A:T,16,FALSE)=\"\",\"\",(VLOOKUP($A10&\"d\",'Claim Adjustment Form'!A:T,16,FALSE)))","v":""},{"$f":"IF(VLOOKUP($A10&\"d\",'Claim Adjustment Form'!A:T,17,FALSE)=\"\",\"\",(VLOOKUP($A10&\"d\",'Claim Adjustment Form'!A:T,17,FALSE)))","v":""},{"$f":"IF(VLOOKUP($A10&\"d\",'Claim Adjustment Form'!A:T,18,FALSE)=\"\",\"\",(VLOOKUP($A10&\"d\",'Claim Adjustment Form'!A:T,18,FALSE)))","v":""},{"$f":"IF(VLOOKUP($A10&\"d\",'Claim Adjustment Form'!A:T,19,FALSE)=\"\",\"\",(VLOOKUP($A10&\"d\",'Claim Adjustment Form'!A:T,19,FALSE)))","v":""},{"$f":"IF(VLOOKUP($A10&\"d\",'Claim Adjustment Form'!A:T,20,FALSE)=\"\",\"\",(VLOOKUP($A10&\"d\",'Claim Adjustment Form'!A:T,20,FALSE)))","v":""},{"$f":"IF(VLOOKUP($A10&\"e\",'Claim Adjustment Form'!A:T,5,FALSE)=\"\",\"\",(VLOOKUP($A10&\"e\",'Claim Adjustment Form'!A:T,5,FALSE)))","v":""},{"$f":"IF(VLOOKUP($A10&\"c\",'Claim Adjustment Form'!A:T,3,FALSE)=\"\",\"\",(VLOOKUP($A10&\"c\",'Claim Adjustment Form'!A:T,3,FALSE)))","v":""},{"$f":"IF(VLOOKUP($A10&\"c\",'Claim Adjustment Form'!A:T,6,FALSE)=\"\",\"\",(VLOOKUP($A10&\"c\",'Claim Adjustment Form'!A:T,6,FALSE)))","v":""},{"$f":"IF(VLOOKUP($A10&\"c\",'Claim Adjustment Form'!A:T,9,FALSE)=\"\",\"\",(VLOOKUP($A10&\"c\",'Claim Adjustment Form'!A:T,9,FALSE)))","v":""},{"$f":"IF(VLOOKUP($A10&\"c\",'Claim Adjustment Form'!A:T,12,FALSE)=\"\",\"\",(VLOOKUP($A10&\"c\",'Claim Adjustment Form'!A:T,12,FALSE)))","v":""},{"$f":"IF(VLOOKUP($A10&\"c\",'Claim Adjustment Form'!A:T,15,FALSE)=\"\",\"\",(VLOOKUP($A10&\"c\",'Claim Adjustment Form'!A:T,15,FALSE)))","v":""},{"$f":"IF(VLOOKUP($A10&\"c\",'Claim Adjustment Form'!A:T,19,FALSE)=\"\",\"\",(VLOOKUP($A10&\"c\",'Claim Adjustment Form'!A:T,19,FALSE)))","v":""},{"$f":"IF(VLOOKUP($A10&\"e\",'Claim Adjustment Form'!A:T,13,FALSE)=\"\",\"\",(VLOOKUP($A10&\"e\",'Claim Adjustment Form'!A:T,13,FALSE)))","v":""},{"$f":"IF(VLOOKUP($A10&\"f\",'Claim Adjustment Form'!A:T,3,FALSE)=\"\",\"\",(VLOOKUP($A10&\"f\",'Claim Adjustment Form'!A:T,3,FALSE)))","v":""}]
[2,{"$f":"IF(VLOOKUP($A11,'Claim Adjustment Form'!A:T,6,FALSE)=\"\",\"\",(VLOOKUP($A11,'Claim Adjustment Form'!A:T,6,FALSE)))","v":""},{"$f":"IF(VLOOKUP($A11,'Claim Adjustment Form'!A:T,19,FALSE)=\"\",\"\",(VLOOKUP($A11,'Claim Adjustment Form'!A:T,19,FALSE)))","v":""},{"$f":"IF(VLOOKUP($A11&\"a\",'Claim Adjustment Form'!A:T,13,FALSE)=\"\",\"\",(VLOOKUP($A11&\"a\",'Claim Adjustment Form'!A:T,13,FALSE)))","v":""},{"$f":"IF(VLOOKUP($A11&\"b\",'Claim Adjustment Form'!A:T,3,FALSE)=\"\",\"\",(VLOOKUP($A11&\"b\",'Claim Adjustment Form'!A:T,3,FALSE)))","v":""},{"$f":"IF(VLOOKUP($A11&\"b\",'Claim Adjustment Form'!A:T,6,FALSE)=\"\",\"\",(VLOOKUP($A11&\"b\",'Claim Adjustment Form'!A:T,6,FALSE)))","v":""},{"$f":"IF(VLOOKUP($A11&\"b\",'Claim Adjustment Form'!A:T,9,FALSE)=\"\",\"\",(VLOOKUP($A11&\"b\",'Claim Adjustment Form'!A:T,9,FALSE)))","v":""},{"$f":"IF(VLOOKUP($A11&\"b\",'Claim Adjustment Form'!A:T,11,FALSE)=\"\",\"\",(VLOOKUP($A11&\"b\",'Claim Adjustment Form'!A:T,11,FALSE)))","v":""},{"$f":"IF(VLOOKUP($A11&\"b\",'Claim Adjustment Form'!A:T,13,FALSE)=\"\",\"\",(VLOOKUP($A11&\"b\",'Claim Adjustment Form'!A:T,13,FALSE)))","v":""},{"$f":"IF(VLOOKUP($A11&\"b\",'Claim Adjustment Form'!A:T,15,FALSE)=\"\",\"\",(VLOOKUP($A11&\"b\",'Claim Adjustment Form'!A:T,15,FALSE)))","v":""},{"$f":"IF(VLOOKUP($A11&\"b\",'Claim Adjustment Form'!A:T,16,FALSE)=\"\",\"\",(VLOOKUP($A11&\"b\",'Claim Adjustment Form'!A:T,16,FALSE)))","v":""},{"$f":"IF(VLOOKUP($A11&\"b\",'Claim Adjustment Form'!A:T,17,FALSE)=\"\",\"\",(VLOOKUP($A11&\"b\",'Claim Adjustment Form'!A:T,17,FALSE)))","v":""},{"$f":"IF(VLOOKUP($A11&\"b\",'Claim Adjustment Form'!A:T,18,FALSE)=\"\",\"\",(VLOOKUP($A11&\"b\",'Claim Adjustment Form'!A:T,18,FALSE)))","v":""},{"$f":"IF(VLOOKUP($A11&\"b\",'Claim Adjustment Form'!A:T,19,FALSE)=\"\",\"\",(VLOOKUP($A11&\"b\",'Claim Adjustment Form'!A:T,19,FALSE)))","v":""},{"$f":"IF(VLOOKUP($A11&\"b\",'Claim Adjustment Form'!A:T,20,FALSE)=\"\",\"\",(VLOOKUP($A11&\"b\",'Claim Adjustment Form'!A:T,20,FALSE)))","v":""},{"$f":"IF(VLOOKUP($A11&\"c\",'Claim Adjustment Form'!A:AG,33,FALSE)=\"\",\"\",(VLOOKUP($A11&\"c\",'Claim Adjustment Form'!A:AG,33,FALSE)))","v":""},{"$f":"IF(VLOOKUP($A11&\"d\",'Claim Adjustment Form'!A:F,6,FALSE)=\"\",\"\",(VLOOKUP($A11&\"d\",'Claim Adjustment Form'!A:F,6,FALSE)))","v":""},{"$f":"IF(VLOOKUP($A11&\"d\",'Claim Adjustment Form'!A:T,7,FALSE)=\"\",\"\",(VLOOKUP($A11&\"d\",'Claim Adjustment Form'!A:T,7,FALSE)))","v":""},{"$f":"IF(VLOOKUP($A11&\"d\",'Claim Adjustment Form'!A:T,8,FALSE)=\"\",\"\",(VLOOKUP($A11&\"d\",'Claim Adjustment Form'!A:T,8,FALSE)))","v":""},{"$f":"IF(VLOOKUP($A11&\"d\",'Claim Adjustment Form'!A:T,9,FALSE)=\"\",\"\",(VLOOKUP($A11&\"d\",'Claim Adjustment Form'!A:T,9,FALSE)))","v":""},{"$f":"IF(VLOOKUP($A11&\"d\",'Claim Adjustment Form'!A:T,10,FALSE)=\"\",\"\",(VLOOKUP($A11&\"d\",'Claim Adjustment Form'!A:T,10,FALSE)))","v":""},{"$f":"IF(VLOOKUP($A11&\"d\",'Claim Adjustment Form'!A:T,11,FALSE)=\"\",\"\",(VLOOKUP($A11&\"d\",'Claim Adjustment Form'!A:T,11,FALSE)))","v":""},{"$f":"IF(VLOOKUP($A11&\"d\",'Claim Adjustment Form'!A:T,15,FALSE)=\"\",\"\",(VLOOKUP($A11&\"d\",'Claim Adjustment Form'!A:T,15,FALSE)))","v":""},{"$f":"IF(VLOOKUP($A11&\"d\",'Claim Adjustment Form'!A:T,16,FALSE)=\"\",\"\",(VLOOKUP($A11&\"d\",'Claim Adjustment Form'!A:T,16,FALSE)))","v":""},{"$f":"IF(VLOOKUP($A11&\"d\",'Claim Adjustment Form'!A:T,17,FALSE)=\"\",\"\",(VLOOKUP($A11&\"d\",'Claim Adjustment Form'!A:T,17,FALSE)))","v":""},{"$f":"IF(VLOOKUP($A11&\"d\",'Claim Adjustment Form'!A:T,18,FALSE)=\"\",\"\",(VLOOKUP($A11&\"d\",'Claim Adjustment Form'!A:T,18,FALSE)))","v":""},{"$f":"IF(VLOOKUP($A11&\"d\",'Claim Adjustment Form'!A:T,19,FALSE)=\"\",\"\",(VLOOKUP($A11&\"d\",'Claim Adjustment Form'!A:T,19,FALSE)))","v":""},{"$f":"IF(VLOOKUP($A11&\"d\",'Claim Adjustment Form'!A:T,20,FALSE)=\"\",\"\",(VLOOKUP($A11&\"d\",'Claim Adjustment Form'!A:T,20,FALSE)))","v":""},{"$f":"IF(VLOOKUP($A11&\"e\",'Claim Adjustment Form'!A:T,5,FALSE)=\"\",\"\",(VLOOKUP($A11&\"e\",'Claim Adjustment Form'!A:T,5,FALSE)))","v":""},{"$f":"IF(VLOOKUP($A11&\"c\",'Claim Adjustment Form'!A:T,3,FALSE)=\"\",\"\",(VLOOKUP($A11&\"c\",'Claim Adjustment Form'!A:T,3,FALSE)))","v":""},{"$f":"IF(VLOOKUP($A11&\"c\",'Claim Adjustment Form'!A:T,6,FALSE)=\"\",\"\",(VLOOKUP($A11&\"c\",'Claim Adjustment Form'!A:T,6,FALSE)))","v":""},{"$f":"IF(VLOOKUP($A11&\"c\",'Claim Adjustment Form'!A:T,9,FALSE)=\"\",\"\",(VLOOKUP($A11&\"c\",'Claim Adjustment Form'!A:T,9,FALSE)))","v":""},{"$f":"IF(VLOOKUP($A11&\"c\",'Claim Adjustment Form'!A:T,12,FALSE)=\"\",\"\",(VLOOKUP($A11&\"c\",'Claim Adjustment Form'!A:T,12,FALSE)))","v":""},{"$f":"IF(VLOOKUP($A11&\"c\",'Claim Adjustment Form'!A:T,15,FALSE)=\"\",\"\",(VLOOKUP($A11&\"c\",'Claim Adjustment Form'!A:T,15,FALSE)))","v":""},{"$f":"IF(VLOOKUP($A11&\"c\",'Claim Adjustment Form'!A:T,19,FALSE)=\"\",\"\",(VLOOKUP($A11&\"c\",'Claim Adjustment Form'!A:T,19,FALSE)))","v":""},{"$f":"IF(VLOOKUP($A11&\"e\",'Claim Adjustment Form'!A:T,13,FALSE)=\"\",\"\",(VLOOKUP($A11&\"e\",'Claim Adjustment Form'!A:T,13,FALSE)))","v":""},{"$f":"IF(VLOOKUP($A11&\"f\",'Claim Adjustment Form'!A:T,3,FALSE)=\"\",\"\",(VLOOKUP($A11&\"f\",'Claim Adjustment Form'!A:T,3,FALSE)))","v":""}]
[3,{"$f":"IF(VLOOKUP($A12,'Claim Adjustment Form'!A:T,6,FALSE)=\"\",\"\",(VLOOKUP($A12,'Claim Adjustment Form'!A:T,6,FALSE)))","v":""},{"$f":"IF(VLOOKUP($A12,'Claim Adjustment Form'!A:T,19,FALSE)=\"\",\"\",(VLOOKUP($A12,'Claim Adjustment Form'!A:T,19,FALSE)))","v":""},{"$f":"IF(VLOOKUP($A12&\"a\",'Claim Adjustment Form'!A:T,13,FALSE)=\"\",\"\",(VLOOKUP($A12&\"a\",'Claim Adjustment Form'!A:T,13,FALSE)))","v":""},{"$f":"IF(VLOOKUP($A12&\"b\",'Claim Adjustment Form'!A:T,3,FALSE)=\"\",\"\",(VLOOKUP($A12&\"b\",'Claim Adjustment Form'!A:T,3,FALSE)))","v":""},{"$f":"IF(VLOOKUP($A12&\"b\",'Claim Adjustment Form'!A:T,6,FALSE)=\"\",\"\",(VLOOKUP($A12&\"b\",'Claim Adjustment Form'!A:T,6,FALSE)))","v":""},{"$f":"IF(VLOOKUP($A12&\"b\",'Claim Adjustment Form'!A:T,9,FALSE)=\"\",\"\",(VLOOKUP($A12&\"b\",'Claim Adjustment Form'!A:T,9,FALSE)))","v":""},{"$f":"IF(VLOOKUP($A12&\"b\",'Claim Adjustment Form'!A:T,11,FALSE)=\"\",\"\",(VLOOKUP($A12&\"b\",'Claim Adjustment Form'!A:T,11,FALSE)))","v":""},{"$f":"IF(VLOOKUP($A12&\"b\",'Claim Adjustment Form'!A:T,13,FALSE)=\"\",\"\",(VLOOKUP($A12&\"b\",'Claim Adjustment Form'!A:T,13,FALSE)))","v":""},{"$f":"IF(VLOOKUP($A12&\"b\",'Claim Adjustment Form'!A:T,15,FALSE)=\"\",\"\",(VLOOKUP($A12&\"b\",'Claim Adjustment Form'!A:T,15,FALSE)))","v":""},{"$f":"IF(VLOOKUP($A12&\"b\",'Claim Adjustment Form'!A:T,16,FALSE)=\"\",\"\",(VLOOKUP($A12&\"b\",'Claim Adjustment Form'!A:T,16,FALSE)))","v":""},{"$f":"IF(VLOOKUP($A12&\"b\",'Claim Adjustment Form'!A:T,17,FALSE)=\"\",\"\",(VLOOKUP($A12&\"b\",'Claim Adjustment Form'!A:T,17,FALSE)))","v":""},{"$f":"IF(VLOOKUP($A12&\"b\",'Claim Adjustment Form'!A:T,18,FALSE)=\"\",\"\",(VLOOKUP($A12&\"b\",'Claim Adjustment Form'!A:T,18,FALSE)))","v":""},{"$f":"IF(VLOOKUP($A12&\"b\",'Claim Adjustment Form'!A:T,19,FALSE)=\"\",\"\",(VLOOKUP($A12&\"b\",'Claim Adjustment Form'!A:T,19,FALSE)))","v":""},{"$f":"IF(VLOOKUP($A12&\"b\",'Claim Adjustment Form'!A:T,20,FALSE)=\"\",\"\",(VLOOKUP($A12&\"b\",'Claim Adjustment Form'!A:T,20,FALSE)))","v":""},{"$f":"IF(VLOOKUP($A12&\"c\",'Claim Adjustment Form'!A:AG,33,FALSE)=\"\",\"\",(VLOOKUP($A12&\"c\",'Claim Adjustment Form'!A:AG,33,FALSE)))","v":""},{"$f":"IF(VLOOKUP($A12&\"d\",'Claim Adjustment Form'!A:F,6,FALSE)=\"\",\"\",(VLOOKUP($A12&\"d\",'Claim Adjustment Form'!A:F,6,FALSE)))","v":""},{"$f":"IF(VLOOKUP($A12&\"d\",'Claim Adjustment Form'!A:T,7,FALSE)=\"\",\"\",(VLOOKUP($A12&\"d\",'Claim Adjustment Form'!A:T,7,FALSE)))","v":""},{"$f":"IF(VLOOKUP($A12&\"d\",'Claim Adjustment Form'!A:T,8,FALSE)=\"\",\"\",(VLOOKUP($A12&\"d\",'Claim Adjustment Form'!A:T,8,FALSE)))","v":""},{"$f":"IF(VLOOKUP($A12&\"d\",'Claim Adjustment Form'!A:T,9,FALSE)=\"\",\"\",(VLOOKUP($A12&\"d\",'Claim Adjustment Form'!A:T,9,FALSE)))","v":""},{"$f":"IF(VLOOKUP($A12&\"d\",'Claim Adjustment Form'!A:T,10,FALSE)=\"\",\"\",(VLOOKUP($A12&\"d\",'Claim Adjustment Form'!A:T,10,FALSE)))","v":""},{"$f":"IF(VLOOKUP($A12&\"d\",'Claim Adjustment Form'!A:T,11,FALSE)=\"\",\"\",(VLOOKUP($A12&\"d\",'Claim Adjustment Form'!A:T,11,FALSE)))","v":""},{"$f":"IF(VLOOKUP($A12&\"d\",'Claim Adjustment Form'!A:T,15,FALSE)=\"\",\"\",(VLOOKUP($A12&\"d\",'Claim Adjustment Form'!A:T,15,FALSE)))","v":""},{"$f":"IF(VLOOKUP($A12&\"d\",'Claim Adjustment Form'!A:T,16,FALSE)=\"\",\"\",(VLOOKUP($A12&\"d\",'Claim Adjustment Form'!A:T,16,FALSE)))","v":""},{"$f":"IF(VLOOKUP($A12&\"d\",'Claim Adjustment Form'!A:T,17,FALSE)=\"\",\"\",(VLOOKUP($A12&\"d\",'Claim Adjustment Form'!A:T,17,FALSE)))","v":""},{"$f":"IF(VLOOKUP($A12&\"d\",'Claim Adjustment Form'!A:T,18,FALSE)=\"\",\"\",(VLOOKUP($A12&\"d\",'Claim Adjustment Form'!A:T,18,FALSE)))","v":""},{"$f":"IF(VLOOKUP($A12&\"d\",'Claim Adjustment Form'!A:T,19,FALSE)=\"\",\"\",(VLOOKUP($A12&\"d\",'Claim Adjustment Form'!A:T,19,FALSE)))","v":""},{"$f":"IF(VLOOKUP($A12&\"d\",'Claim Adjustment Form'!A:T,20,FALSE)=\"\",\"\",(VLOOKUP($A12&\"d\",'Claim Adjustment Form'!A:T,20,FALSE)))","v":""},{"$f":"IF(VLOOKUP($A12&\"e\",'Claim Adjustment Form'!A:T,5,FALSE)=\"\",\"\",(VLOOKUP($A12&\"e\",'Claim Adjustment Form'!A:T,5,FALSE)))","v":""},{"$f":"IF(VLOOKUP($A12&\"c\",'Claim Adjustment Form'!A:T,3,FALSE)=\"\",\"\",(VLOOKUP($A12&\"c\",'Claim Adjustment Form'!A:T,3,FALSE)))","v":""},{"$f":"IF(VLOOKUP($A12&\"c\",'Claim Adjustment Form'!A:T,6,FALSE)=\"\",\"\",(VLOOKUP($A12&\"c\",'Claim Adjustment Form'!A:T,6,FALSE)))","v":""},{"$f":"IF(VLOOKUP($A12&\"c\",'Claim Adjustment Form'!A:T,9,FALSE)=\"\",\"\",(VLOOKUP($A12&\"c\",'Claim Adjustment Form'!A:T,9,FALSE)))","v":""},{"$f":"IF(VLOOKUP($A12&\"c\",'Claim Adjustment Form'!A:T,12,FALSE)=\"\",\"\",(VLOOKUP($A12&\"c\",'Claim Adjustment Form'!A:T,12,FALSE)))","v":""},{"$f":"IF(VLOOKUP($A12&\"c\",'Claim Adjustment Form'!A:T,15,FALSE)=\"\",\"\",(VLOOKUP($A12&\"c\",'Claim Adjustment Form'!A:T,15,FALSE)))","v":""},{"$f":"IF(VLOOKUP($A12&\"c\",'Claim Adjustment Form'!A:T,19,FALSE)=\"\",\"\",(VLOOKUP($A12&\"c\",'Claim Adjustment Form'!A:T,19,FALSE)))","v":""},{"$f":"IF(VLOOKUP($A12&\"e\",'Claim Adjustment Form'!A:T,13,FALSE)=\"\",\"\",(VLOOKUP($A12&\"e\",'Claim Adjustment Form'!A:T,13,FALSE)))","v":""},{"$f":"IF(VLOOKUP($A12&\"f\",'Claim Adjustment Form'!A:T,3,FALSE)=\"\",\"\",(VLOOKUP($A12&\"f\",'Claim Adjustment Form'!A:T,3,FALSE)))","v":""}]
[4,{"$f":"IF(VLOOKUP($A13,'Claim Adjustment Form'!A:T,6,FALSE)=\"\",\"\",(VLOOKUP($A13,'Claim Adjustment Form'!A:T,6,FALSE)))","v":""},{"$f":"IF(VLOOKUP($A13,'Claim Adjustment Form'!A:T,19,FALSE)=\"\",\"\",(VLOOKUP($A13,'Claim Adjustment Form'!A:T,19,FALSE)))","v":""},{"$f":"IF(VLOOKUP($A13&\"a\",'Claim Adjustment Form'!A:T,13,FALSE)=\"\",\"\",(VLOOKUP($A13&\"a\",'Claim Adjustment Form'!A:T,13,FALSE)))","v":""},{"$f":"IF(VLOOKUP($A13&\"b\",'Claim Adjustment Form'!A:T,3,FALSE)=\"\",\"\",(VLOOKUP($A13&\"b\",'Claim Adjustment Form'!A:T,3,FALSE)))","v":""},{"$f":"IF(VLOOKUP($A13&\"b\",'Claim Adjustment Form'!A:T,6,FALSE)=\"\",\"\",(VLOOKUP($A13&\"b\",'Claim Adjustment Form'!A:T,6,FALSE)))","v":""},{"$f":"IF(VLOOKUP($A13&\"b\",'Claim Adjustment Form'!A:T,9,FALSE)=\"\",\"\",(VLOOKUP($A13&\"b\",'Claim Adjustment Form'!A:T,9,FALSE)))","v":""},{"$f":"IF(VLOOKUP($A13&\"b\",'Claim Adjustment Form'!A:T,11,FALSE)=\"\",\"\",(VLOOKUP($A13&\"b\",'Claim Adjustment Form'!A:T,11,FALSE)))","v":""},{"$f":"IF(VLOOKUP($A13&\"b\",'Claim Adjustment Form'!A:T,13,FALSE)=\"\",\"\",(VLOOKUP($A13&\"b\",'Claim Adjustment Form'!A:T,13,FALSE)))","v":""},{"$f":"IF(VLOOKUP($A13&\"b\",'Claim Adjustment Form'!A:T,15,FALSE)=\"\",\"\",(VLOOKUP($A13&\"b\",'Claim Adjustment Form'!A:T,15,FALSE)))","v":""},{"$f":"IF(VLOOKUP($A13&\"b\",'Claim Adjustment Form'!A:T,16,FALSE)=\"\",\"\",(VLOOKUP($A13&\"b\",'Claim Adjustment Form'!A:T,16,FALSE)))","v":""},{"$f":"IF(VLOOKUP($A13&\"b\",'Claim Adjustment Form'!A:T,17,FALSE)=\"\",\"\",(VLOOKUP($A13&\"b\",'Claim Adjustment Form'!A:T,17,FALSE)))","v":""},{"$f":"IF(VLOOKUP($A13&\"b\",'Claim Adjustment Form'!A:T,18,FALSE)=\"\",\"\",(VLOOKUP($A13&\"b\",'Claim Adjustment Form'!A:T,18,FALSE)))","v":""},{"$f":"IF(VLOOKUP($A13&\"b\",'Claim Adjustment Form'!A:T,19,FALSE)=\"\",\"\",(VLOOKUP($A13&\"b\",'Claim Adjustment Form'!A:T,19,FALSE)))","v":""},{"$f":"IF(VLOOKUP($A13&\"b\",'Claim Adjustment Form'!A:T,20,FALSE)=\"\",\"\",(VLOOKUP($A13&\"b\",'Claim Adjustment Form'!A:T,20,FALSE)))","v":""},{"$f":"IF(VLOOKUP($A13&\"c\",'Claim Adjustment Form'!A:AG,33,FALSE)=\"\",\"\",(VLOOKUP($A13&\"c\",'Claim Adjustment Form'!A:AG,33,FALSE)))","v":""},{"$f":"IF(VLOOKUP($A13&\"d\",'Claim Adjustment Form'!A:F,6,FALSE)=\"\",\"\",(VLOOKUP($A13&\"d\",'Claim Adjustment Form'!A:F,6,FALSE)))","v":""},{"$f":"IF(VLOOKUP($A13&\"d\",'Claim Adjustment Form'!A:T,7,FALSE)=\"\",\"\",(VLOOKUP($A13&\"d\",'Claim Adjustment Form'!A:T,7,FALSE)))","v":""},{"$f":"IF(VLOOKUP($A13&\"d\",'Claim Adjustment Form'!A:T,8,FALSE)=\"\",\"\",(VLOOKUP($A13&\"d\",'Claim Adjustment Form'!A:T,8,FALSE)))","v":""},{"$f":"IF(VLOOKUP($A13&\"d\",'Claim Adjustment Form'!A:T,9,FALSE)=\"\",\"\",(VLOOKUP($A13&\"d\",'Claim Adjustment Form'!A:T,9,FALSE)))","v":""},{"$f":"IF(VLOOKUP($A13&\"d\",'Claim Adjustment Form'!A:T,10,FALSE)=\"\",\"\",(VLOOKUP($A13&\"d\",'Claim Adjustment Form'!A:T,10,FALSE)))","v":""},{"$f":"IF(VLOOKUP($A13&\"d\",'Claim Adjustment Form'!A:T,11,FALSE)=\"\",\"\",(VLOOKUP($A13&\"d\",'Claim Adjustment Form'!A:T,11,FALSE)))","v":""},{"$f":"IF(VLOOKUP($A13&\"d\",'Claim Adjustment Form'!A:T,15,FALSE)=\"\",\"\",(VLOOKUP($A13&\"d\",'Claim Adjustment Form'!A:T,15,FALSE)))","v":""},{"$f":"IF(VLOOKUP($A13&\"d\",'Claim Adjustment Form'!A:T,16,FALSE)=\"\",\"\",(VLOOKUP($A13&\"d\",'Claim Adjustment Form'!A:T,16,FALSE)))","v":""},{"$f":"IF(VLOOKUP($A13&\"d\",'Claim Adjustment Form'!A:T,17,FALSE)=\"\",\"\",(VLOOKUP($A13&\"d\",'Claim Adjustment Form'!A:T,17,FALSE)))","v":""},{"$f":"IF(VLOOKUP($A13&\"d\",'Claim Adjustment Form'!A:T,18,FALSE)=\"\",\"\",(VLOOKUP($A13&\"d\",'Claim Adjustment Form'!A:T,18,FALSE)))","v":""},{"$f":"IF(VLOOKUP($A13&\"d\",'Claim Adjustment Form'!A:T,19,FALSE)=\"\",\"\",(VLOOKUP($A13&\"d\",'Claim Adjustment Form'!A:T,19,FALSE)))","v":""},{"$f":"IF(VLOOKUP($A13&\"d\",'Claim Adjustment Form'!A:T,20,FALSE)=\"\",\"\",(VLOOKUP($A13&\"d\",'Claim Adjustment Form'!A:T,20,FALSE)))","v":""},{"$f":"IF(VLOOKUP($A13&\"e\",'Claim Adjustment Form'!A:T,5,FALSE)=\"\",\"\",(VLOOKUP($A13&\"e\",'Claim Adjustment Form'!A:T,5,FALSE)))","v":""},{"$f":"IF(VLOOKUP($A13&\"c\",'Claim Adjustment Form'!A:T,3,FALSE)=\"\",\"\",(VLOOKUP($A13&\"c\",'Claim Adjustment Form'!A:T,3,FALSE)))","v":""},{"$f":"IF(VLOOKUP($A13&\"c\",'Claim Adjustment Form'!A:T,6,FALSE)=\"\",\"\",(VLOOKUP($A13&\"c\",'Claim Adjustment Form'!A:T,6,FALSE)))","v":""},{"$f":"IF(VLOOKUP($A13&\"c\",'Claim Adjustment Form'!A:T,9,FALSE)=\"\",\"\",(VLOOKUP($A13&\"c\",'Claim Adjustment Form'!A:T,9,FALSE)))","v":""},{"$f":"IF(VLOOKUP($A13&\"c\",'Claim Adjustment Form'!A:T,12,FALSE)=\"\",\"\",(VLOOKUP($A13&\"c\",'Claim Adjustment Form'!A:T,12,FALSE)))","v":""},{"$f":"IF(VLOOKUP($A13&\"c\",'Claim Adjustment Form'!A:T,15,FALSE)=\"\",\"\",(VLOOKUP($A13&\"c\",'Claim Adjustment Form'!A:T,15,FALSE)))","v":""},{"$f":"IF(VLOOKUP($A13&\"c\",'Claim Adjustment Form'!A:T,19,FALSE)=\"\",\"\",(VLOOKUP($A13&\"c\",'Claim Adjustment Form'!A:T,19,FALSE)))","v":""},{"$f":"IF(VLOOKUP($A13&\"e\",'Claim Adjustment Form'!A:T,13,FALSE)=\"\",\"\",(VLOOKUP($A13&\"e\",'Claim Adjustment Form'!A:T,13,FALSE)))","v":""},{"$f":"IF(VLOOKUP($A13&\"f\",'Claim Adjustment Form'!A:T,3,FALSE)=\"\",\"\",(VLOOKUP($A13&\"f\",'Claim Adjustment Form'!A:T,3,FALSE)))","v":""}]
[5,{"$f":"IF(VLOOKUP($A14,'Claim Adjustment Form'!A:T,6,FALSE)=\"\",\"\",(VLOOKUP($A14,'Claim Adjustment Form'!A:T,6,FALSE)))","v":""},{"$f":"IF(VLOOKUP($A14,'Claim Adjustment Form'!A:T,19,FALSE)=\"\",\"\",(VLOOKUP($A14,'Claim Adjustment Form'!A:T,19,FALSE)))","v":""},{"$f":"IF(VLOOKUP($A14&\"a\",'Claim Adjustment Form'!A:T,13,FALSE)=\"\",\"\",(VLOOKUP($A14&\"a\",'Claim Adjustment Form'!A:T,13,FALSE)))","v":""},{"$f":"IF(VLOOKUP($A14&\"b\",'Claim Adjustment Form'!A:T,3,FALSE)=\"\",\"\",(VLOOKUP($A14&\"b\",'Claim Adjustment Form'!A:T,3,FALSE)))","v":""},{"$f":"IF(VLOOKUP($A14&\"b\",'Claim Adjustment Form'!A:T,6,FALSE)=\"\",\"\",(VLOOKUP($A14&\"b\",'Claim Adjustment Form'!A:T,6,FALSE)))","v":""},{"$f":"IF(VLOOKUP($A14&\"b\",'Claim Adjustment Form'!A:T,9,FALSE)=\"\",\"\",(VLOOKUP($A14&\"b\",'Claim Adjustment Form'!A:T,9,FALSE)))","v":""},{"$f":"IF(VLOOKUP($A14&\"b\",'Claim Adjustment Form'!A:T,11,FALSE)=\"\",\"\",(VLOOKUP($A14&\"b\",'Claim Adjustment Form'!A:T,11,FALSE)))","v":""},{"$f":"IF(VLOOKUP($A14&\"b\",'Claim Adjustment Form'!A:T,13,FALSE)=\"\",\"\",(VLOOKUP($A14&\"b\",'Claim Adjustment Form'!A:T,13,FALSE)))","v":""},{"$f":"IF(VLOOKUP($A14&\"b\",'Claim Adjustment Form'!A:T,15,FALSE)=\"\",\"\",(VLOOKUP($A14&\"b\",'Claim Adjustment Form'!A:T,15,FALSE)))","v":""},{"$f":"IF(VLOOKUP($A14&\"b\",'Claim Adjustment Form'!A:T,16,FALSE)=\"\",\"\",(VLOOKUP($A14&\"b\",'Claim Adjustment Form'!A:T,16,FALSE)))","v":""},{"$f":"IF(VLOOKUP($A14&\"b\",'Claim Adjustment Form'!A:T,17,FALSE)=\"\",\"\",(VLOOKUP($A14&\"b\",'Claim Adjustment Form'!A:T,17,FALSE)))","v":""},{"$f":"IF(VLOOKUP($A14&\"b\",'Claim Adjustment Form'!A:T,18,FALSE)=\"\",\"\",(VLOOKUP($A14&\"b\",'Claim Adjustment Form'!A:T,18,FALSE)))","v":""},{"$f":"IF(VLOOKUP($A14&\"b\",'Claim Adjustment Form'!A:T,19,FALSE)=\"\",\"\",(VLOOKUP($A14&\"b\",'Claim Adjustment Form'!A:T,19,FALSE)))","v":""},{"$f":"IF(VLOOKUP($A14&\"b\",'Claim Adjustment Form'!A:T,20,FALSE)=\"\",\"\",(VLOOKUP($A14&\"b\",'Claim Adjustment Form'!A:T,20,FALSE)))","v":""},{"$f":"IF(VLOOKUP($A14&\"c\",'Claim Adjustment Form'!A:AG,33,FALSE)=\"\",\"\",(VLOOKUP($A14&\"c\",'Claim Adjustment Form'!A:AG,33,FALSE)))","v":""},{"$f":"IF(VLOOKUP($A14&\"d\",'Claim Adjustment Form'!A:F,6,FALSE)=\"\",\"\",(VLOOKUP($A14&\"d\",'Claim Adjustment Form'!A:F,6,FALSE)))","v":""},{"$f":"IF(VLOOKUP($A14&\"d\",'Claim Adjustment Form'!A:T,7,FALSE)=\"\",\"\",(VLOOKUP($A14&\"d\",'Claim Adjustment Form'!A:T,7,FALSE)))","v":""},{"$f":"IF(VLOOKUP($A14&\"d\",'Claim Adjustment Form'!A:T,8,FALSE)=\"\",\"\",(VLOOKUP($A14&\"d\",'Claim Adjustment Form'!A:T,8,FALSE)))","v":""},{"$f":"IF(VLOOKUP($A14&\"d\",'Claim Adjustment Form'!A:T,9,FALSE)=\"\",\"\",(VLOOKUP($A14&\"d\",'Claim Adjustment Form'!A:T,9,FALSE)))","v":""},{"$f":"IF(VLOOKUP($A14&\"d\",'Claim Adjustment Form'!A:T,10,FALSE)=\"\",\"\",(VLOOKUP($A14&\"d\",'Claim Adjustment Form'!A:T,10,FALSE)))","v":""},{"$f":"IF(VLOOKUP($A14&\"d\",'Claim Adjustment Form'!A:T,11,FALSE)=\"\",\"\",(VLOOKUP($A14&\"d\",'Claim Adjustment Form'!A:T,11,FALSE)))","v":""},{"$f":"IF(VLOOKUP($A14&\"d\",'Claim Adjustment Form'!A:T,15,FALSE)=\"\",\"\",(VLOOKUP($A14&\"d\",'Claim Adjustment Form'!A:T,15,FALSE)))","v":""},{"$f":"IF(VLOOKUP($A14&\"d\",'Claim Adjustment Form'!A:T,16,FALSE)=\"\",\"\",(VLOOKUP($A14&\"d\",'Claim Adjustment Form'!A:T,16,FALSE)))","v":""},{"$f":"IF(VLOOKUP($A14&\"d\",'Claim Adjustment Form'!A:T,17,FALSE)=\"\",\"\",(VLOOKUP($A14&\"d\",'Claim Adjustment Form'!A:T,17,FALSE)))","v":""},{"$f":"IF(VLOOKUP($A14&\"d\",'Claim Adjustment Form'!A:T,18,FALSE)=\"\",\"\",(VLOOKUP($A14&\"d\",'Claim Adjustment Form'!A:T,18,FALSE)))","v":""},{"$f":"IF(VLOOKUP($A14&\"d\",'Claim Adjustment Form'!A:T,19,FALSE)=\"\",\"\",(VLOOKUP($A14&\"d\",'Claim Adjustment Form'!A:T,19,FALSE)))","v":""},{"$f":"IF(VLOOKUP($A14&\"d\",'Claim Adjustment Form'!A:T,20,FALSE)=\"\",\"\",(VLOOKUP($A14&\"d\",'Claim Adjustment Form'!A:T,20,FALSE)))","v":""},{"$f":"IF(VLOOKUP($A14&\"e\",'Claim Adjustment Form'!A:T,5,FALSE)=\"\",\"\",(VLOOKUP($A14&\"e\",'Claim Adjustment Form'!A:T,5,FALSE)))","v":""},{"$f":"IF(VLOOKUP($A14&\"c\",'Claim Adjustment Form'!A:T,3,FALSE)=\"\",\"\",(VLOOKUP($A14&\"c\",'Claim Adjustment Form'!A:T,3,FALSE)))","v":""},{"$f":"IF(VLOOKUP($A14&\"c\",'Claim Adjustment Form'!A:T,6,FALSE)=\"\",\"\",(VLOOKUP($A14&\"c\",'Claim Adjustment Form'!A:T,6,FALSE)))","v":""},{"$f":"IF(VLOOKUP($A14&\"c\",'Claim Adjustment Form'!A:T,9,FALSE)=\"\",\"\",(VLOOKUP($A14&\"c\",'Claim Adjustment Form'!A:T,9,FALSE)))","v":""},{"$f":"IF(VLOOKUP($A14&\"c\",'Claim Adjustment Form'!A:T,12,FALSE)=\"\",\"\",(VLOOKUP($A14&\"c\",'Claim Adjustment Form'!A:T,12,FALSE)))","v":""},{"$f":"IF(VLOOKUP($A14&\"c\",'Claim Adjustment Form'!A:T,15,FALSE)=\"\",\"\",(VLOOKUP($A14&\"c\",'Claim Adjustment Form'!A:T,15,FALSE)))","v":""},{"$f":"IF(VLOOKUP($A14&\"c\",'Claim Adjustment Form'!A:T,19,FALSE)=\"\",\"\",(VLOOKUP($A14&\"c\",'Claim Adjustment Form'!A:T,19,FALSE)))","v":""},{"$f":"IF(VLOOKUP($A14&\"e\",'Claim Adjustment Form'!A:T,13,FALSE)=\"\",\"\",(VLOOKUP($A14&\"e\",'Claim Adjustment Form'!A:T,13,FALSE)))","v":""},{"$f":"IF(VLOOKUP($A14&\"f\",'Claim Adjustment Form'!A:T,3,FALSE)=\"\",\"\",(VLOOKUP($A14&\"f\",'Claim Adjustment Form'!A:T,3,FALSE)))","v":""}]
[6,{"$f":"IF(VLOOKUP($A15,'Claim Adjustment Form'!A:T,6,FALSE)=\"\",\"\",(VLOOKUP($A15,'Claim Adjustment Form'!A:T,6,FALSE)))","v":""},{"$f":"IF(VLOOKUP($A15,'Claim Adjustment Form'!A:T,19,FALSE)=\"\",\"\",(VLOOKUP($A15,'Claim Adjustment Form'!A:T,19,FALSE)))","v":""},{"$f":"IF(VLOOKUP($A15&\"a\",'Claim Adjustment Form'!A:T,13,FALSE)=\"\",\"\",(VLOOKUP($A15&\"a\",'Claim Adjustment Form'!A:T,13,FALSE)))","v":""},{"$f":"IF(VLOOKUP($A15&\"b\",'Claim Adjustment Form'!A:T,3,FALSE)=\"\",\"\",(VLOOKUP($A15&\"b\",'Claim Adjustment Form'!A:T,3,FALSE)))","v":""},{"$f":"IF(VLOOKUP($A15&\"b\",'Claim Adjustment Form'!A:T,6,FALSE)=\"\",\"\",(VLOOKUP($A15&\"b\",'Claim Adjustment Form'!A:T,6,FALSE)))","v":""},{"$f":"IF(VLOOKUP($A15&\"b\",'Claim Adjustment Form'!A:T,9,FALSE)=\"\",\"\",(VLOOKUP($A15&\"b\",'Claim Adjustment Form'!A:T,9,FALSE)))","v":""},{"$f":"IF(VLOOKUP($A15&\"b\",'Claim Adjustment Form'!A:T,11,FALSE)=\"\",\"\",(VLOOKUP($A15&\"b\",'Claim Adjustment Form'!A:T,11,FALSE)))","v":""},{"$f":"IF(VLOOKUP($A15&\"b\",'Claim Adjustment Form'!A:T,13,FALSE)=\"\",\"\",(VLOOKUP($A15&\"b\",'Claim Adjustment Form'!A:T,13,FALSE)))","v":""},{"$f":"IF(VLOOKUP($A15&\"b\",'Claim Adjustment Form'!A:T,15,FALSE)=\"\",\"\",(VLOOKUP($A15&\"b\",'Claim Adjustment Form'!A:T,15,FALSE)))","v":""},{"$f":"IF(VLOOKUP($A15&\"b\",'Claim Adjustment Form'!A:T,16,FALSE)=\"\",\"\",(VLOOKUP($A15&\"b\",'Claim Adjustment Form'!A:T,16,FALSE)))","v":""},{"$f":"IF(VLOOKUP($A15&\"b\",'Claim Adjustment Form'!A:T,17,FALSE)=\"\",\"\",(VLOOKUP($A15&\"b\",'Claim Adjustment Form'!A:T,17,FALSE)))","v":""},{"$f":"IF(VLOOKUP($A15&\"b\",'Claim Adjustment Form'!A:T,18,FALSE)=\"\",\"\",(VLOOKUP($A15&\"b\",'Claim Adjustment Form'!A:T,18,FALSE)))","v":""},{"$f":"IF(VLOOKUP($A15&\"b\",'Claim Adjustment Form'!A:T,19,FALSE)=\"\",\"\",(VLOOKUP($A15&\"b\",'Claim Adjustment Form'!A:T,19,FALSE)))","v":""},{"$f":"IF(VLOOKUP($A15&\"b\",'Claim Adjustment Form'!A:T,20,FALSE)=\"\",\"\",(VLOOKUP($A15&\"b\",'Claim Adjustment Form'!A:T,20,FALSE)))","v":""},{"$f":"IF(VLOOKUP($A15&\"c\",'Claim Adjustment Form'!A:AG,33,FALSE)=\"\",\"\",(VLOOKUP($A15&\"c\",'Claim Adjustment Form'!A:AG,33,FALSE)))","v":""},{"$f":"IF(VLOOKUP($A15&\"d\",'Claim Adjustment Form'!A:F,6,FALSE)=\"\",\"\",(VLOOKUP($A15&\"d\",'Claim Adjustment Form'!A:F,6,FALSE)))","v":""},{"$f":"IF(VLOOKUP($A15&\"d\",'Claim Adjustment Form'!A:T,7,FALSE)=\"\",\"\",(VLOOKUP($A15&\"d\",'Claim Adjustment Form'!A:T,7,FALSE)))","v":""},{"$f":"IF(VLOOKUP($A15&\"d\",'Claim Adjustment Form'!A:T,8,FALSE)=\"\",\"\",(VLOOKUP($A15&\"d\",'Claim Adjustment Form'!A:T,8,FALSE)))","v":""},{"$f":"IF(VLOOKUP($A15&\"d\",'Claim Adjustment Form'!A:T,9,FALSE)=\"\",\"\",(VLOOKUP($A15&\"d\",'Claim Adjustment Form'!A:T,9,FALSE)))","v":""},{"$f":"IF(VLOOKUP($A15&\"d\",'Claim Adjustment Form'!A:T,10,FALSE)=\"\",\"\",(VLOOKUP($A15&\"d\",'Claim Adjustment Form'!A:T,10,FALSE)))","v":""},{"$f":"IF(VLOOKUP($A15&\"d\",'Claim Adjustment Form'!A:T,11,FALSE)=\"\",\"\",(VLOOKUP($A15&\"d\",'Claim Adjustment Form'!A:T,11,FALSE)))","v":""},{"$f":"IF(VLOOKUP($A15&\"d\",'Claim Adjustment Form'!A:T,15,FALSE)=\"\",\"\",(VLOOKUP($A15&\"d\",'Claim Adjustment Form'!A:T,15,FALSE)))","v":""},{"$f":"IF(VLOOKUP($A15&\"d\",'Claim Adjustment Form'!A:T,16,FALSE)=\"\",\"\",(VLOOKUP($A15&\"d\",'Claim Adjustment Form'!A:T,16,FALSE)))","v":""},{"$f":"IF(VLOOKUP($A15&\"d\",'Claim Adjustment Form'!A:T,17,FALSE)=\"\",\"\",(VLOOKUP($A15&\"d\",'Claim Adjustment Form'!A:T,17,FALSE)))","v":""},{"$f":"IF(VLOOKUP($A15&\"d\",'Claim Adjustment Form'!A:T,18,FALSE)=\"\",\"\",(VLOOKUP($A15&\"d\",'Claim Adjustment Form'!A:T,18,FALSE)))","v":""},{"$f":"IF(VLOOKUP($A15&\"d\",'Claim Adjustment Form'!A:T,19,FALSE)=\"\",\"\",(VLOOKUP($A15&\"d\",'Claim Adjustment Form'!A:T,19,FALSE)))","v":""},{"$f":"IF(VLOOKUP($A15&\"d\",'Claim Adjustment Form'!A:T,20,FALSE)=\"\",\"\",(VLOOKUP($A15&\"d\",'Claim Adjustment Form'!A:T,20,FALSE)))","v":""},{"$f":"IF(VLOOKUP($A15&\"e\",'Claim Adjustment Form'!A:T,5,FALSE)=\"\",\"\",(VLOOKUP($A15&\"e\",'Claim Adjustment Form'!A:T,5,FALSE)))","v":""},{"$f":"IF(VLOOKUP($A15&\"c\",'Claim Adjustment Form'!A:T,3,FALSE)=\"\",\"\",(VLOOKUP($A15&\"c\",'Claim Adjustment Form'!A:T,3,FALSE)))","v":""},{"$f":"IF(VLOOKUP($A15&\"c\",'Claim Adjustment Form'!A:T,6,FALSE)=\"\",\"\",(VLOOKUP($A15&\"c\",'Claim Adjustment Form'!A:T,6,FALSE)))","v":""},{"$f":"IF(VLOOKUP($A15&\"c\",'Claim Adjustment Form'!A:T,9,FALSE)=\"\",\"\",(VLOOKUP($A15&\"c\",'Claim Adjustment Form'!A:T,9,FALSE)))","v":""},{"$f":"IF(VLOOKUP($A15&\"c\",'Claim Adjustment Form'!A:T,12,FALSE)=\"\",\"\",(VLOOKUP($A15&\"c\",'Claim Adjustment Form'!A:T,12,FALSE)))","v":""},{"$f":"IF(VLOOKUP($A15&\"c\",'Claim Adjustment Form'!A:T,15,FALSE)=\"\",\"\",(VLOOKUP($A15&\"c\",'Claim Adjustment Form'!A:T,15,FALSE)))","v":""},{"$f":"IF(VLOOKUP($A15&\"c\",'Claim Adjustment Form'!A:T,19,FALSE)=\"\",\"\",(VLOOKUP($A15&\"c\",'Claim Adjustment Form'!A:T,19,FALSE)))","v":""},{"$f":"IF(VLOOKUP($A15&\"e\",'Claim Adjustment Form'!A:T,13,FALSE)=\"\",\"\",(VLOOKUP($A15&\"e\",'Claim Adjustment Form'!A:T,13,FALSE)))","v":""},{"$f":"IF(VLOOKUP($A15&\"f\",'Claim Adjustment Form'!A:T,3,FALSE)=\"\",\"\",(VLOOKUP($A15&\"f\",'Claim Adjustment Form'!A:T,3,FALSE)))","v":""}]
[7,{"$f":"IF(VLOOKUP($A16,'Claim Adjustment Form'!A:T,6,FALSE)=\"\",\"\",(VLOOKUP($A16,'Claim Adjustment Form'!A:T,6,FALSE)))","v":""},{"$f":"IF(VLOOKUP($A16,'Claim Adjustment Form'!A:T,19,FALSE)=\"\",\"\",(VLOOKUP($A16,'Claim Adjustment Form'!A:T,19,FALSE)))","v":""},{"$f":"IF(VLOOKUP($A16&\"a\",'Claim Adjustment Form'!A:T,13,FALSE)=\"\",\"\",(VLOOKUP($A16&\"a\",'Claim Adjustment Form'!A:T,13,FALSE)))","v":""},{"$f":"IF(VLOOKUP($A16&\"b\",'Claim Adjustment Form'!A:T,3,FALSE)=\"\",\"\",(VLOOKUP($A16&\"b\",'Claim Adjustment Form'!A:T,3,FALSE)))","v":""},{"$f":"IF(VLOOKUP($A16&\"b\",'Claim Adjustment Form'!A:T,6,FALSE)=\"\",\"\",(VLOOKUP($A16&\"b\",'Claim Adjustment Form'!A:T,6,FALSE)))","v":""},{"$f":"IF(VLOOKUP($A16&\"b\",'Claim Adjustment Form'!A:T,9,FALSE)=\"\",\"\",(VLOOKUP($A16&\"b\",'Claim Adjustment Form'!A:T,9,FALSE)))","v":""},{"$f":"IF(VLOOKUP($A16&\"b\",'Claim Adjustment Form'!A:T,11,FALSE)=\"\",\"\",(VLOOKUP($A16&\"b\",'Claim Adjustment Form'!A:T,11,FALSE)))","v":""},{"$f":"IF(VLOOKUP($A16&\"b\",'Claim Adjustment Form'!A:T,13,FALSE)=\"\",\"\",(VLOOKUP($A16&\"b\",'Claim Adjustment Form'!A:T,13,FALSE)))","v":""},{"$f":"IF(VLOOKUP($A16&\"b\",'Claim Adjustment Form'!A:T,15,FALSE)=\"\",\"\",(VLOOKUP($A16&\"b\",'Claim Adjustment Form'!A:T,15,FALSE)))","v":""},{"$f":"IF(VLOOKUP($A16&\"b\",'Claim Adjustment Form'!A:T,16,FALSE)=\"\",\"\",(VLOOKUP($A16&\"b\",'Claim Adjustment Form'!A:T,16,FALSE)))","v":""},{"$f":"IF(VLOOKUP($A16&\"b\",'Claim Adjustment Form'!A:T,17,FALSE)=\"\",\"\",(VLOOKUP($A16&\"b\",'Claim Adjustment Form'!A:T,17,FALSE)))","v":""},{"$f":"IF(VLOOKUP($A16&\"b\",'Claim Adjustment Form'!A:T,18,FALSE)=\"\",\"\",(VLOOKUP($A16&\"b\",'Claim Adjustment Form'!A:T,18,FALSE)))","v":""},{"$f":"IF(VLOOKUP($A16&\"b\",'Claim Adjustment Form'!A:T,19,FALSE)=\"\",\"\",(VLOOKUP($A16&\"b\",'Claim Adjustment Form'!A:T,19,FALSE)))","v":""},{"$f":"IF(VLOOKUP($A16&\"b\",'Claim Adjustment Form'!A:T,20,FALSE)=\"\",\"\",(VLOOKUP($A16&\"b\",'Claim Adjustment Form'!A:T,20,FALSE)))","v":""},{"$f":"IF(VLOOKUP($A16&\"c\",'Claim Adjustment Form'!A:AG,33,FALSE)=\"\",\"\",(VLOOKUP($A16&\"c\",'Claim Adjustment Form'!A:AG,33,FALSE)))","v":""},{"$f":"IF(VLOOKUP($A16&\"d\",'Claim Adjustment Form'!A:F,6,FALSE)=\"\",\"\",(VLOOKUP($A16&\"d\",'Claim Adjustment Form'!A:F,6,FALSE)))","v":""},{"$f":"IF(VLOOKUP($A16&\"d\",'Claim Adjustment Form'!A:T,7,FALSE)=\"\",\"\",(VLOOKUP($A16&\"d\",'Claim Adjustment Form'!A:T,7,FALSE)))","v":""},{"$f":"IF(VLOOKUP($A16&\"d\",'Claim Adjustment Form'!A:T,8,FALSE)=\"\",\"\",(VLOOKUP($A16&\"d\",'Claim Adjustment Form'!A:T,8,FALSE)))","v":""},{"$f":"IF(VLOOKUP($A16&\"d\",'Claim Adjustment Form'!A:T,9,FALSE)=\"\",\"\",(VLOOKUP($A16&\"d\",'Claim Adjustment Form'!A:T,9,FALSE)))","v":""},{"$f":"IF(VLOOKUP($A16&\"d\",'Claim Adjustment Form'!A:T,10,FALSE)=\"\",\"\",(VLOOKUP($A16&\"d\",'Claim Adjustment Form'!A:T,10,FALSE)))","v":""},{"$f":"IF(VLOOKUP($A16&\"d\",'Claim Adjustment Form'!A:T,11,FALSE)=\"\",\"\",(VLOOKUP($A16&\"d\",'Claim Adjustment Form'!A:T,11,FALSE)))","v":""},{"$f":"IF(VLOOKUP($A16&\"d\",'Claim Adjustment Form'!A:T,15,FALSE)=\"\",\"\",(VLOOKUP($A16&\"d\",'Claim Adjustment Form'!A:T,15,FALSE)))","v":""},{"$f":"IF(VLOOKUP($A16&\"d\",'Claim Adjustment Form'!A:T,16,FALSE)=\"\",\"\",(VLOOKUP($A16&\"d\",'Claim Adjustment Form'!A:T,16,FALSE)))","v":""},{"$f":"IF(VLOOKUP($A16&\"d\",'Claim Adjustment Form'!A:T,17,FALSE)=\"\",\"\",(VLOOKUP($A16&\"d\",'Claim Adjustment Form'!A:T,17,FALSE)))","v":""},{"$f":"IF(VLOOKUP($A16&\"d\",'Claim Adjustment Form'!A:T,18,FALSE)=\"\",\"\",(VLOOKUP($A16&\"d\",'Claim Adjustment Form'!A:T,18,FALSE)))","v":""},{"$f":"IF(VLOOKUP($A16&\"d\",'Claim Adjustment Form'!A:T,19,FALSE)=\"\",\"\",(VLOOKUP($A16&\"d\",'Claim Adjustment Form'!A:T,19,FALSE)))","v":""},{"$f":"IF(VLOOKUP($A16&\"d\",'Claim Adjustment Form'!A:T,20,FALSE)=\"\",\"\",(VLOOKUP($A16&\"d\",'Claim Adjustment Form'!A:T,20,FALSE)))","v":""},{"$f":"IF(VLOOKUP($A16&\"e\",'Claim Adjustment Form'!A:T,5,FALSE)=\"\",\"\",(VLOOKUP($A16&\"e\",'Claim Adjustment Form'!A:T,5,FALSE)))","v":""},{"$f":"IF(VLOOKUP($A16&\"c\",'Claim Adjustment Form'!A:T,3,FALSE)=\"\",\"\",(VLOOKUP($A16&\"c\",'Claim Adjustment Form'!A:T,3,FALSE)))","v":""},{"$f":"IF(VLOOKUP($A16&\"c\",'Claim Adjustment Form'!A:T,6,FALSE)=\"\",\"\",(VLOOKUP($A16&\"c\",'Claim Adjustment Form'!A:T,6,FALSE)))","v":""},{"$f":"IF(VLOOKUP($A16&\"c\",'Claim Adjustment Form'!A:T,9,FALSE)=\"\",\"\",(VLOOKUP($A16&\"c\",'Claim Adjustment Form'!A:T,9,FALSE)))","v":""},{"$f":"IF(VLOOKUP($A16&\"c\",'Claim Adjustment Form'!A:T,12,FALSE)=\"\",\"\",(VLOOKUP($A16&\"c\",'Claim Adjustment Form'!A:T,12,FALSE)))","v":""},{"$f":"IF(VLOOKUP($A16&\"c\",'Claim Adjustment Form'!A:T,15,FALSE)=\"\",\"\",(VLOOKUP($A16&\"c\",'Claim Adjustment Form'!A:T,15,FALSE)))","v":""},{"$f":"IF(VLOOKUP($A16&\"c\",'Claim Adjustment Form'!A:T,19,FALSE)=\"\",\"\",(VLOOKUP($A16&\"c\",'Claim Adjustment Form'!A:T,19,FALSE)))","v":""},{"$f":"IF(VLOOKUP($A16&\"e\",'Claim Adjustment Form'!A:T,13,FALSE)=\"\",\"\",(VLOOKUP($A16&\"e\",'Claim Adjustment Form'!A:T,13,FALSE)))","v":""},{"$f":"IF(VLOOKUP($A16&\"f\",'Claim Adjustment Form'!A:T,3,FALSE)=\"\",\"\",(VLOOKUP($A16&\"f\",'Claim Adjustment Form'!A:T,3,FALSE)))","v":""}]
[8,{"$f":"IF(VLOOKUP($A17,'Claim Adjustment Form'!A:T,6,FALSE)=\"\",\"\",(VLOOKUP($A17,'Claim Adjustment Form'!A:T,6,FALSE)))","v":""},{"$f":"IF(VLOOKUP($A17,'Claim Adjustment Form'!A:T,19,FALSE)=\"\",\"\",(VLOOKUP($A17,'Claim Adjustment Form'!A:T,19,FALSE)))","v":""},{"$f":"IF(VLOOKUP($A17&\"a\",'Claim Adjustment Form'!A:T,13,FALSE)=\"\",\"\",(VLOOKUP($A17&\"a\",'Claim Adjustment Form'!A:T,13,FALSE)))","v":""},{"$f":"IF(VLOOKUP($A17&\"b\",'Claim Adjustment Form'!A:T,3,FALSE)=\"\",\"\",(VLOOKUP($A17&\"b\",'Claim Adjustment Form'!A:T,3,FALSE)))","v":""},{"$f":"IF(VLOOKUP($A17&\"b\",'Claim Adjustment Form'!A:T,6,FALSE)=\"\",\"\",(VLOOKUP($A17&\"b\",'Claim Adjustment Form'!A:T,6,FALSE)))","v":""},{"$f":"IF(VLOOKUP($A17&\"b\",'Claim Adjustment Form'!A:T,9,FALSE)=\"\",\"\",(VLOOKUP($A17&\"b\",'Claim Adjustment Form'!A:T,9,FALSE)))","v":""},{"$f":"IF(VLOOKUP($A17&\"b\",'Claim Adjustment Form'!A:T,11,FALSE)=\"\",\"\",(VLOOKUP($A17&\"b\",'Claim Adjustment Form'!A:T,11,FALSE)))","v":""},{"$f":"IF(VLOOKUP($A17&\"b\",'Claim Adjustment Form'!A:T,13,FALSE)=\"\",\"\",(VLOOKUP($A17&\"b\",'Claim Adjustment Form'!A:T,13,FALSE)))","v":""},{"$f":"IF(VLOOKUP($A17&\"b\",'Claim Adjustment Form'!A:T,15,FALSE)=\"\",\"\",(VLOOKUP($A17&\"b\",'Claim Adjustment Form'!A:T,15,FALSE)))","v":""},{"$f":"IF(VLOOKUP($A17&\"b\",'Claim Adjustment Form'!A:T,16,FALSE)=\"\",\"\",(VLOOKUP($A17&\"b\",'Claim Adjustment Form'!A:T,16,FALSE)))","v":""},{"$f":"IF(VLOOKUP($A17&\"b\",'Claim Adjustment Form'!A:T,17,FALSE)=\"\",\"\",(VLOOKUP($A17&\"b\",'Claim Adjustment Form'!A:T,17,FALSE)))","v":""},{"$f":"IF(VLOOKUP($A17&\"b\",'Claim Adjustment Form'!A:T,18,FALSE)=\"\",\"\",(VLOOKUP($A17&\"b\",'Claim Adjustment Form'!A:T,18,FALSE)))","v":""},{"$f":"IF(VLOOKUP($A17&\"b\",'Claim Adjustment Form'!A:T,19,FALSE)=\"\",\"\",(VLOOKUP($A17&\"b\",'Claim Adjustment Form'!A:T,19,FALSE)))","v":""},{"$f":"IF(VLOOKUP($A17&\"b\",'Claim Adjustment Form'!A:T,20,FALSE)=\"\",\"\",(VLOOKUP($A17&\"b\",'Claim Adjustment Form'!A:T,20,FALSE)))","v":""},{"$f":"IF(VLOOKUP($A17&\"c\",'Claim Adjustment Form'!A:AG,33,FALSE)=\"\",\"\",(VLOOKUP($A17&\"c\",'Claim Adjustment Form'!A:AG,33,FALSE)))","v":""},{"$f":"IF(VLOOKUP($A17&\"d\",'Claim Adjustment Form'!A:F,6,FALSE)=\"\",\"\",(VLOOKUP($A17&\"d\",'Claim Adjustment Form'!A:F,6,FALSE)))","v":""},{"$f":"IF(VLOOKUP($A17&\"d\",'Claim Adjustment Form'!A:T,7,FALSE)=\"\",\"\",(VLOOKUP($A17&\"d\",'Claim Adjustment Form'!A:T,7,FALSE)))","v":""},{"$f":"IF(VLOOKUP($A17&\"d\",'Claim Adjustment Form'!A:T,8,FALSE)=\"\",\"\",(VLOOKUP($A17&\"d\",'Claim Adjustment Form'!A:T,8,FALSE)))","v":""},{"$f":"IF(VLOOKUP($A17&\"d\",'Claim Adjustment Form'!A:T,9,FALSE)=\"\",\"\",(VLOOKUP($A17&\"d\",'Claim Adjustment Form'!A:T,9,FALSE)))","v":""},{"$f":"IF(VLOOKUP($A17&\"d\",'Claim Adjustment Form'!A:T,10,FALSE)=\"\",\"\",(VLOOKUP($A17&\"d\",'Claim Adjustment Form'!A:T,10,FALSE)))","v":""},{"$f":"IF(VLOOKUP($A17&\"d\",'Claim Adjustment Form'!A:T,11,FALSE)=\"\",\"\",(VLOOKUP($A17&\"d\",'Claim Adjustment Form'!A:T,11,FALSE)))","v":""},{"$f":"IF(VLOOKUP($A17&\"d\",'Claim Adjustment Form'!A:T,15,FALSE)=\"\",\"\",(VLOOKUP($A17&\"d\",'Claim Adjustment Form'!A:T,15,FALSE)))","v":""},{"$f":"IF(VLOOKUP($A17&\"d\",'Claim Adjustment Form'!A:T,16,FALSE)=\"\",\"\",(VLOOKUP($A17&\"d\",'Claim Adjustment Form'!A:T,16,FALSE)))","v":""},{"$f":"IF(VLOOKUP($A17&\"d\",'Claim Adjustment Form'!A:T,17,FALSE)=\"\",\"\",(VLOOKUP($A17&\"d\",'Claim Adjustment Form'!A:T,17,FALSE)))","v":""},{"$f":"IF(VLOOKUP($A17&\"d\",'Claim Adjustment Form'!A:T,18,FALSE)=\"\",\"\",(VLOOKUP($A17&\"d\",'Claim Adjustment Form'!A:T,18,FALSE)))","v":""},{"$f":"IF(VLOOKUP($A17&\"d\",'Claim Adjustment Form'!A:T,19,FALSE)=\"\",\"\",(VLOOKUP($A17&\"d\",'Claim Adjustment Form'!A:T,19,FALSE)))","v":""},{"$f":"IF(VLOOKUP($A17&\"d\",'Claim Adjustment Form'!A:T,20,FALSE)=\"\",\"\",(VLOOKUP($A17&\"d\",'Claim Adjustment Form'!A:T,20,FALSE)))","v":""},{"$f":"IF(VLOOKUP($A17&\"e\",'Claim Adjustment Form'!A:T,5,FALSE)=\"\",\"\",(VLOOKUP($A17&\"e\",'Claim Adjustment Form'!A:T,5,FALSE)))","v":""},{"$f":"IF(VLOOKUP($A17&\"c\",'Claim Adjustment Form'!A:T,3,FALSE)=\"\",\"\",(VLOOKUP($A17&\"c\",'Claim Adjustment Form'!A:T,3,FALSE)))","v":""},{"$f":"IF(VLOOKUP($A17&\"c\",'Claim Adjustment Form'!A:T,6,FALSE)=\"\",\"\",(VLOOKUP($A17&\"c\",'Claim Adjustment Form'!A:T,6,FALSE)))","v":""},{"$f":"IF(VLOOKUP($A17&\"c\",'Claim Adjustment Form'!A:T,9,FALSE)=\"\",\"\",(VLOOKUP($A17&\"c\",'Claim Adjustment Form'!A:T,9,FALSE)))","v":""},{"$f":"IF(VLOOKUP($A17&\"c\",'Claim Adjustment Form'!A:T,12,FALSE)=\"\",\"\",(VLOOKUP($A17&\"c\",'Claim Adjustment Form'!A:T,12,FALSE)))","v":""},{"$f":"IF(VLOOKUP($A17&\"c\",'Claim Adjustment Form'!A:T,15,FALSE)=\"\",\"\",(VLOOKUP($A17&\"c\",'Claim Adjustment Form'!A:T,15,FALSE)))","v":""},{"$f":"IF(VLOOKUP($A17&\"c\",'Claim Adjustment Form'!A:T,19,FALSE)=\"\",\"\",(VLOOKUP($A17&\"c\",'Claim Adjustment Form'!A:T,19,FALSE)))","v":""},{"$f":"IF(VLOOKUP($A17&\"e\",'Claim Adjustment Form'!A:T,13,FALSE)=\"\",\"\",(VLOOKUP($A17&\"e\",'Claim Adjustment Form'!A:T,13,FALSE)))","v":""},{"$f":"IF(VLOOKUP($A17&\"f\",'Claim Adjustment Form'!A:T,3,FALSE)=\"\",\"\",(VLOOKUP($A17&\"f\",'Claim Adjustment Form'!A:T,3,FALSE)))","v":""}]
[9,{"$f":"IF(VLOOKUP($A18,'Claim Adjustment Form'!A:T,6,FALSE)=\"\",\"\",(VLOOKUP($A18,'Claim Adjustment Form'!A:T,6,FALSE)))","v":""},{"$f":"IF(VLOOKUP($A18,'Claim Adjustment Form'!A:T,19,FALSE)=\"\",\"\",(VLOOKUP($A18,'Claim Adjustment Form'!A:T,19,FALSE)))","v":""},{"$f":"IF(VLOOKUP($A18&\"a\",'Claim Adjustment Form'!A:T,13,FALSE)=\"\",\"\",(VLOOKUP($A18&\"a\",'Claim Adjustment Form'!A:T,13,FALSE)))","v":""},{"$f":"IF(VLOOKUP($A18&\"b\",'Claim Adjustment Form'!A:T,3,FALSE)=\"\",\"\",(VLOOKUP($A18&\"b\",'Claim Adjustment Form'!A:T,3,FALSE)))","v":""},{"$f":"IF(VLOOKUP($A18&\"b\",'Claim Adjustment Form'!A:T,6,FALSE)=\"\",\"\",(VLOOKUP($A18&\"b\",'Claim Adjustment Form'!A:T,6,FALSE)))","v":""},{"$f":"IF(VLOOKUP($A18&\"b\",'Claim Adjustment Form'!A:T,9,FALSE)=\"\",\"\",(VLOOKUP($A18&\"b\",'Claim Adjustment Form'!A:T,9,FALSE)))","v":""},{"$f":"IF(VLOOKUP($A18&\"b\",'Claim Adjustment Form'!A:T,11,FALSE)=\"\",\"\",(VLOOKUP($A18&\"b\",'Claim Adjustment Form'!A:T,11,FALSE)))","v":""},{"$f":"IF(VLOOKUP($A18&\"b\",'Claim Adjustment Form'!A:T,13,FALSE)=\"\",\"\",(VLOOKUP($A18&\"b\",'Claim Adjustment Form'!A:T,13,FALSE)))","v":""},{"$f":"IF(VLOOKUP($A18&\"b\",'Claim Adjustment Form'!A:T,15,FALSE)=\"\",\"\",(VLOOKUP($A18&\"b\",'Claim Adjustment Form'!A:T,15,FALSE)))","v":""},{"$f":"IF(VLOOKUP($A18&\"b\",'Claim Adjustment Form'!A:T,16,FALSE)=\"\",\"\",(VLOOKUP($A18&\"b\",'Claim Adjustment Form'!A:T,16,FALSE)))","v":""},{"$f":"IF(VLOOKUP($A18&\"b\",'Claim Adjustment Form'!A:T,17,FALSE)=\"\",\"\",(VLOOKUP($A18&\"b\",'Claim Adjustment Form'!A:T,17,FALSE)))","v":""},{"$f":"IF(VLOOKUP($A18&\"b\",'Claim Adjustment Form'!A:T,18,FALSE)=\"\",\"\",(VLOOKUP($A18&\"b\",'Claim Adjustment Form'!A:T,18,FALSE)))","v":""},{"$f":"IF(VLOOKUP($A18&\"b\",'Claim Adjustment Form'!A:T,19,FALSE)=\"\",\"\",(VLOOKUP($A18&\"b\",'Claim Adjustment Form'!A:T,19,FALSE)))","v":""},{"$f":"IF(VLOOKUP($A18&\"b\",'Claim Adjustment Form'!A:T,20,FALSE)=\"\",\"\",(VLOOKUP($A18&\"b\",'Claim Adjustment Form'!A:T,20,FALSE)))","v":""},{"$f":"IF(VLOOKUP($A18&\"c\",'Claim Adjustment Form'!A:AG,33,FALSE)=\"\",\"\",(VLOOKUP($A18&\"c\",'Claim Adjustment Form'!A:AG,33,FALSE)))","v":""},{"$f":"IF(VLOOKUP($A18&\"d\",'Claim Adjustment Form'!A:F,6,FALSE)=\"\",\"\",(VLOOKUP($A18&\"d\",'Claim Adjustment Form'!A:F,6,FALSE)))","v":""},{"$f":"IF(VLOOKUP($A18&\"d\",'Claim Adjustment Form'!A:T,7,FALSE)=\"\",\"\",(VLOOKUP($A18&\"d\",'Claim Adjustment Form'!A:T,7,FALSE)))","v":""},{"$f":"IF(VLOOKUP($A18&\"d\",'Claim Adjustment Form'!A:T,8,FALSE)=\"\",\"\",(VLOOKUP($A18&\"d\",'Claim Adjustment Form'!A:T,8,FALSE)))","v":""},{"$f":"IF(VLOOKUP($A18&\"d\",'Claim Adjustment Form'!A:T,9,FALSE)=\"\",\"\",(VLOOKUP($A18&\"d\",'Claim Adjustment Form'!A:T,9,FALSE)))","v":""},{"$f":"IF(VLOOKUP($A18&\"d\",'Claim Adjustment Form'!A:T,10,FALSE)=\"\",\"\",(VLOOKUP($A18&\"d\",'Claim Adjustment Form'!A:T,10,FALSE)))","v":""},{"$f":"IF(VLOOKUP($A18&\"d\",'Claim Adjustment Form'!A:T,11,FALSE)=\"\",\"\",(VLOOKUP($A18&\"d\",'Claim Adjustment Form'!A:T,11,FALSE)))","v":""},{"$f":"IF(VLOOKUP($A18&\"d\",'Claim Adjustment Form'!A:T,15,FALSE)=\"\",\"\",(VLOOKUP($A18&\"d\",'Claim Adjustment Form'!A:T,15,FALSE)))","v":""},{"$f":"IF(VLOOKUP($A18&\"d\",'Claim Adjustment Form'!A:T,16,FALSE)=\"\",\"\",(VLOOKUP($A18&\"d\",'Claim Adjustment Form'!A:T,16,FALSE)))","v":""},{"$f":"IF(VLOOKUP($A18&\"d\",'Claim Adjustment Form'!A:T,17,FALSE)=\"\",\"\",(VLOOKUP($A18&\"d\",'Claim Adjustment Form'!A:T,17,FALSE)))","v":""},{"$f":"IF(VLOOKUP($A18&\"d\",'Claim Adjustment Form'!A:T,18,FALSE)=\"\",\"\",(VLOOKUP($A18&\"d\",'Claim Adjustment Form'!A:T,18,FALSE)))","v":""},{"$f":"IF(VLOOKUP($A18&\"d\",'Claim Adjustment Form'!A:T,19,FALSE)=\"\",\"\",(VLOOKUP($A18&\"d\",'Claim Adjustment Form'!A:T,19,FALSE)))","v":""},{"$f":"IF(VLOOKUP($A18&\"d\",'Claim Adjustment Form'!A:T,20,FALSE)=\"\",\"\",(VLOOKUP($A18&\"d\",'Claim Adjustment Form'!A:T,20,FALSE)))","v":""},{"$f":"IF(VLOOKUP($A18&\"e\",'Claim Adjustment Form'!A:T,5,FALSE)=\"\",\"\",(VLOOKUP($A18&\"e\",'Claim Adjustment Form'!A:T,5,FALSE)))","v":""},{"$f":"IF(VLOOKUP($A18&\"c\",'Claim Adjustment Form'!A:T,3,FALSE)=\"\",\"\",(VLOOKUP($A18&\"c\",'Claim Adjustment Form'!A:T,3,FALSE)))","v":""},{"$f":"IF(VLOOKUP($A18&\"c\",'Claim Adjustment Form'!A:T,6,FALSE)=\"\",\"\",(VLOOKUP($A18&\"c\",'Claim Adjustment Form'!A:T,6,FALSE)))","v":""},{"$f":"IF(VLOOKUP($A18&\"c\",'Claim Adjustment Form'!A:T,9,FALSE)=\"\",\"\",(VLOOKUP($A18&\"c\",'Claim Adjustment Form'!A:T,9,FALSE)))","v":""},{"$f":"IF(VLOOKUP($A18&\"c\",'Claim Adjustment Form'!A:T,12,FALSE)=\"\",\"\",(VLOOKUP($A18&\"c\",'Claim Adjustment Form'!A:T,12,FALSE)))","v":""},{"$f":"IF(VLOOKUP($A18&\"c\",'Claim Adjustment Form'!A:T,15,FALSE)=\"\",\"\",(VLOOKUP($A18&\"c\",'Claim Adjustment Form'!A:T,15,FALSE)))","v":""},{"$f":"IF(VLOOKUP($A18&\"c\",'Claim Adjustment Form'!A:T,19,FALSE)=\"\",\"\",(VLOOKUP($A18&\"c\",'Claim Adjustment Form'!A:T,19,FALSE)))","v":""},{"$f":"IF(VLOOKUP($A18&\"e\",'Claim Adjustment Form'!A:T,13,FALSE)=\"\",\"\",(VLOOKUP($A18&\"e\",'Claim Adjustment Form'!A:T,13,FALSE)))","v":""},{"$f":"IF(VLOOKUP($A18&\"f\",'Claim Adjustment Form'!A:T,3,FALSE)=\"\",\"\",(VLOOKUP($A18&\"f\",'Claim Adjustment Form'!A:T,3,FALSE)))","v":""}]
[10,{"$f":"IF(VLOOKUP($A19,'Claim Adjustment Form'!A:T,6,FALSE)=\"\",\"\",(VLOOKUP($A19,'Claim Adjustment Form'!A:T,6,FALSE)))","v":""},{"$f":"IF(VLOOKUP($A19,'Claim Adjustment Form'!A:T,19,FALSE)=\"\",\"\",(VLOOKUP($A19,'Claim Adjustment Form'!A:T,19,FALSE)))","v":""},{"$f":"IF(VLOOKUP($A19&\"a\",'Claim Adjustment Form'!A:T,13,FALSE)=\"\",\"\",(VLOOKUP($A19&\"a\",'Claim Adjustment Form'!A:T,13,FALSE)))","v":""},{"$f":"IF(VLOOKUP($A19&\"b\",'Claim Adjustment Form'!A:T,3,FALSE)=\"\",\"\",(VLOOKUP($A19&\"b\",'Claim Adjustment Form'!A:T,3,FALSE)))","v":""},{"$f":"IF(VLOOKUP($A19&\"b\",'Claim Adjustment Form'!A:T,6,FALSE)=\"\",\"\",(VLOOKUP($A19&\"b\",'Claim Adjustment Form'!A:T,6,FALSE)))","v":""},{"$f":"IF(VLOOKUP($A19&\"b\",'Claim Adjustment Form'!A:T,9,FALSE)=\"\",\"\",(VLOOKUP($A19&\"b\",'Claim Adjustment Form'!A:T,9,FALSE)))","v":""},{"$f":"IF(VLOOKUP($A19&\"b\",'Claim Adjustment Form'!A:T,11,FALSE)=\"\",\"\",(VLOOKUP($A19&\"b\",'Claim Adjustment Form'!A:T,11,FALSE)))","v":""},{"$f":"IF(VLOOKUP($A19&\"b\",'Claim Adjustment Form'!A:T,13,FALSE)=\"\",\"\",(VLOOKUP($A19&\"b\",'Claim Adjustment Form'!A:T,13,FALSE)))","v":""},{"$f":"IF(VLOOKUP($A19&\"b\",'Claim Adjustment Form'!A:T,15,FALSE)=\"\",\"\",(VLOOKUP($A19&\"b\",'Claim Adjustment Form'!A:T,15,FALSE)))","v":""},{"$f":"IF(VLOOKUP($A19&\"b\",'Claim Adjustment Form'!A:T,16,FALSE)=\"\",\"\",(VLOOKUP($A19&\"b\",'Claim Adjustment Form'!A:T,16,FALSE)))","v":""},{"$f":"IF(VLOOKUP($A19&\"b\",'Claim Adjustment Form'!A:T,17,FALSE)=\"\",\"\",(VLOOKUP($A19&\"b\",'Claim Adjustment Form'!A:T,17,FALSE)))","v":""},{"$f":"IF(VLOOKUP($A19&\"b\",'Claim Adjustment Form'!A:T,18,FALSE)=\"\",\"\",(VLOOKUP($A19&\"b\",'Claim Adjustment Form'!A:T,18,FALSE)))","v":""},{"$f":"IF(VLOOKUP($A19&\"b\",'Claim Adjustment Form'!A:T,19,FALSE)=\"\",\"\",(VLOOKUP($A19&\"b\",'Claim Adjustment Form'!A:T,19,FALSE)))","v":""},{"$f":"IF(VLOOKUP($A19&\"b\",'Claim Adjustment Form'!A:T,20,FALSE)=\"\",\"\",(VLOOKUP($A19&\"b\",'Claim Adjustment Form'!A:T,20,FALSE)))","v":""},{"$f":"IF(VLOOKUP($A19&\"c\",'Claim Adjustment Form'!A:AG,33,FALSE)=\"\",\"\",(VLOOKUP($A19&\"c\",'Claim Adjustment Form'!A:AG,33,FALSE)))","v":""},{"$f":"IF(VLOOKUP($A19&\"d\",'Claim Adjustment Form'!A:F,6,FALSE)=\"\",\"\",(VLOOKUP($A19&\"d\",'Claim Adjustment Form'!A:F,6,FALSE)))","v":""},{"$f":"IF(VLOOKUP($A19&\"d\",'Claim Adjustment Form'!A:T,7,FALSE)=\"\",\"\",(VLOOKUP($A19&\"d\",'Claim Adjustment Form'!A:T,7,FALSE)))","v":""},{"$f":"IF(VLOOKUP($A19&\"d\",'Claim Adjustment Form'!A:T,8,FALSE)=\"\",\"\",(VLOOKUP($A19&\"d\",'Claim Adjustment Form'!A:T,8,FALSE)))","v":""},{"$f":"IF(VLOOKUP($A19&\"d\",'Claim Adjustment Form'!A:T,9,FALSE)=\"\",\"\",(VLOOKUP($A19&\"d\",'Claim Adjustment Form'!A:T,9,FALSE)))","v":""},{"$f":"IF(VLOOKUP($A19&\"d\",'Claim Adjustment Form'!A:T,10,FALSE)=\"\",\"\",(VLOOKUP($A19&\"d\",'Claim Adjustment Form'!A:T,10,FALSE)))","v":""},{"$f":"IF(VLOOKUP($A19&\"d\",'Claim Adjustment Form'!A:T,11,FALSE)=\"\",\"\",(VLOOKUP($A19&\"d\",'Claim Adjustment Form'!A:T,11,FALSE)))","v":""},{"$f":"IF(VLOOKUP($A19&\"d\",'Claim Adjustment Form'!A:T,15,FALSE)=\"\",\"\",(VLOOKUP($A19&\"d\",'Claim Adjustment Form'!A:T,15,FALSE)))","v":""},{"$f":"IF(VLOOKUP($A19&\"d\",'Claim Adjustment Form'!A:T,16,FALSE)=\"\",\"\",(VLOOKUP($A19&\"d\",'Claim Adjustment Form'!A:T,16,FALSE)))","v":""},{"$f":"IF(VLOOKUP($A19&\"d\",'Claim Adjustment Form'!A:T,17,FALSE)=\"\",\"\",(VLOOKUP($A19&\"d\",'Claim Adjustment Form'!A:T,17,FALSE)))","v":""},{"$f":"IF(VLOOKUP($A19&\"d\",'Claim Adjustment Form'!A:T,18,FALSE)=\"\",\"\",(VLOOKUP($A19&\"d\",'Claim Adjustment Form'!A:T,18,FALSE)))","v":""},{"$f":"IF(VLOOKUP($A19&\"d\",'Claim Adjustment Form'!A:T,19,FALSE)=\"\",\"\",(VLOOKUP($A19&\"d\",'Claim Adjustment Form'!A:T,19,FALSE)))","v":""},{"$f":"IF(VLOOKUP($A19&\"d\",'Claim Adjustment Form'!A:T,20,FALSE)=\"\",\"\",(VLOOKUP($A19&\"d\",'Claim Adjustment Form'!A:T,20,FALSE)))","v":""},{"$f":"IF(VLOOKUP($A19&\"e\",'Claim Adjustment Form'!A:T,5,FALSE)=\"\",\"\",(VLOOKUP($A19&\"e\",'Claim Adjustment Form'!A:T,5,FALSE)))","v":""},{"$f":"IF(VLOOKUP($A19&\"c\",'Claim Adjustment Form'!A:T,3,FALSE)=\"\",\"\",(VLOOKUP($A19&\"c\",'Claim Adjustment Form'!A:T,3,FALSE)))","v":""},{"$f":"IF(VLOOKUP($A19&\"c\",'Claim Adjustment Form'!A:T,6,FALSE)=\"\",\"\",(VLOOKUP($A19&\"c\",'Claim Adjustment Form'!A:T,6,FALSE)))","v":""},{"$f":"IF(VLOOKUP($A19&\"c\",'Claim Adjustment Form'!A:T,9,FALSE)=\"\",\"\",(VLOOKUP($A19&\"c\",'Claim Adjustment Form'!A:T,9,FALSE)))","v":""},{"$f":"IF(VLOOKUP($A19&\"c\",'Claim Adjustment Form'!A:T,12,FALSE)=\"\",\"\",(VLOOKUP($A19&\"c\",'Claim Adjustment Form'!A:T,12,FALSE)))","v":""},{"$f":"IF(VLOOKUP($A19&\"c\",'Claim Adjustment Form'!A:T,15,FALSE)=\"\",\"\",(VLOOKUP($A19&\"c\",'Claim Adjustment Form'!A:T,15,FALSE)))","v":""},{"$f":"IF(VLOOKUP($A19&\"c\",'Claim Adjustment Form'!A:T,19,FALSE)=\"\",\"\",(VLOOKUP($A19&\"c\",'Claim Adjustment Form'!A:T,19,FALSE)))","v":""},{"$f":"IF(VLOOKUP($A19&\"e\",'Claim Adjustment Form'!A:T,13,FALSE)=\"\",\"\",(VLOOKUP($A19&\"e\",'Claim Adjustment Form'!A:T,13,FALSE)))","v":""},{"$f":"IF(VLOOKUP($A19&\"f\",'Claim Adjustment Form'!A:T,3,FALSE)=\"\",\"\",(VLOOKUP($A19&\"f\",'Claim Adjustment Form'!A:T,3,FALSE)))","v":""}]