{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["Sheet1"],"not_rendered":{"macros":1,"defined_names":4},"read":"whole","date_system":"1900"}

{"sheet":"Sheet1","index":0,"n_rows":33,"n_cols":8,"rows_kept":33,"merged":[[0,2,0,4],[0,6,0,7],[1,0,1,7],[3,0,3,7],[4,1,4,7],[5,1,5,7],[6,1,6,7],[10,1,10,7],[14,6,14,7],[15,6,15,7],[17,6,17,7],[18,6,18,7],[21,0,21,7],[22,1,24,7],[27,1,28,6],[31,1,32,6]]}
["Case Name:",{"$nulls":4},"Case #:"]
["Calculation for Ineligible ABAWDs"]
[]
["Ineligible ABAWD(s) names:"]
[1]
[2]
[3]
[]
["A.","Number of people in the filing group:"]
["B.","Number of ineligible persons in the filing group:"]
[null,"(Note - include ineligible  ABAWDs, ineligible non-citizens [NC1 and NC2] and people serving an IPV, SSN or OFSET disqualification. Ineligible higher ed students are not part of the filing group.)"]
["C.","Number of people in the benefit group:",{"$nulls":5},{"$f":"((H9-H10)/H9)","v":{"$error":"#DIV/0!"}}]
["Income of the ineligible ABAWD"]
[null,"Income Type","Full Amount","Amount to code on FCAS"]
[1,null,null,{"$f":"C15*(H12)","v":{"$error":"#DIV/0!"}},null,"No","The ABAWD does not pay housing so do not prorate the housing costs of the filing group."]
[2,null,null,{"$f":"C16*(H12)","v":{"$error":"#DIV/0!"}},null,"Yes","The full shelter cost is:\nCode this prorated amount on FCAS:"]
[3,null,null,{"$f":"C17*(H12)","v":{"$error":"#DIV/0!"}}]
[4,null,null,{"$f":"C18*(H12)","v":{"$error":"#DIV/0!"}},null,"No","Do not code COS under the ABAWD."]
[5,null,null,{"$f":"C19*(H12)","v":{"$error":"#DIV/0!"}},null,"Yes","The unprorated amount of COS is:\nCode this prorated amount of COS on FCAS:"]
[6,null,null,{"$f":"C20*(H12)","v":{"$error":"#DIV/0!"}}]
[]
["Deductions of the ineligible ABAWD"]
[1,"Utilities are not prorated. Code the appropriate standard (FUA, LUA, TUA or IUA) if anyone in the filing group has utility costs. If no one in the filing group had utility costs code $0.00 for utilities."]
[]
[]
[]
[2,"Does the ineligible ABAWD pay anything towards the housing?"]
[null,{"$f":"VLOOKUP(H27,Shelter,2,FALSE)","v":{"$error":"#N/A"}}]
[{"$nulls":7},{"$f":"H28*H12","v":{"$error":"#DIV/0!"}}]
[]
[3,"Does the ineligible ABAWD pay court ordered support (COS)?"]
[null,{"$f":"VLOOKUP(H31,COS,2,FALSE)","v":{"$error":"#N/A"}}]
[{"$nulls":7},{"$f":"H32*(H12)","v":{"$error":"#DIV/0!"}}]