{"text_format":"3","workbook":"xlsx","n_sheets":5,"sheets":["Income Spenddown","Asset Spenddown","INCOME SPENDDOWN INSTRUCTIONS","ASSET SPENDDOWN INSTRUCTIONS","DropDown"],"not_rendered":{"images":1,"defined_names":2},"read":"whole","date_system":"1900"}

{"sheet":"Income Spenddown","index":0,"n_rows":56,"n_cols":6,"rows_kept":56}
[]
["Spenddown Calculations"]
["Total Gross Monthly Income"]
["2025 AABD Medicaid Income Limit *",{"v":1304,"d":"$1,304.00"}]
["Monthly Spenddown Amount",{"$f":"IF((B3-B4)<0,\"0\",B3-B4)","v":"0"}]
["Total Medical Expenses",{"$f":"SUM(E:E)","v":0}]
["Total Months of Spenddown Met",{"$f":"ROUNDDOWN(B6/B5, 0)","v":{"$error":"#DIV/0!"}}]
["Amount needed for additional month of coverage",{"$f":"B5*(B7+1)-B6","v":{"$error":"#DIV/0!"}}]
[]
["Date Calculations"]
["Date ABE application will get submitted"]
["All billing dates must be after:",{"$f":"EDATE(B11,-6)","v":{"$error":"#NUM!"}}]
[]
["Statement Date","Source","Bill Amount","How many times have you paid this bill in the past 6 months?","Total Client Paid in Past 6 Mos","Notes"]
[null,"[Medicare Part B Premium]",null,null,{"$f":"IF(D15=0,C15*1,C15*D15)","v":0}]
[null,"[Part D Premium]",null,null,0]
[null,"[Medicare Advantage Premium]",null,null,0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]

{"sheet":"Asset Spenddown","index":1,"n_rows":55,"n_cols":6,"rows_kept":55}
["Spenddown Calculations"]
["Total Assets"]
["2024 AABD Medicaid Asset Limit",{"v":17500,"d":"$17,500.00"}]
["Asset Spenddown Amount",{"$f":"IF((B2-B3)<0,\"0\",B2-B3)","v":"0"}]
["Total Medical Expenses",{"$f":"SUM(E:E)","v":0}]
["Asset Spenddown Met?",{"$f":"IF(B2-B5<=B3,\"YES\",\"NO\")","v":"YES"}]
[]
["Date Calculations"]
["Date ABE application will get submitted"]
["All billing dates must be after:",{"$f":"EDATE(B9,-6)","v":{"$error":"#NUM!"}}]
[]
["Statement Date","Source","Bill Amount","How many times have you paid this bill in the past 6 months?","Total Client Paid in Past 6 Mos","Notes"]
[{"$nulls":4},{"$f":"IF(D13=0,C13*1,C13*D13)","v":0}]
[{"$nulls":4},{"$f":"IF(D14=0,C14*1,C14*D14)","v":0}]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]

{"sheet":"INCOME SPENDDOWN INSTRUCTIONS","index":2,"n_rows":57,"n_cols":6,"rows_kept":57}
[]
["Spenddown Calculations"]
["Total Gross Monthly Income"]
["2024 AABD Medicaid Income Limit *",{"v":1280,"d":"$1,280.00"}]
["Monthly Spenddown Amount",{"$f":"IF((B3-B4)<0,\"0\",B3-B4)","v":"0"}]
["Total Medical Expenses"]
["Total Months of Spenddown Met",{"$f":"ROUNDDOWN(B6/B5, 0)","v":{"$error":"#DIV/0!"}}]
["Amount needed for additional month of coverage",{"$f":"B5*(B7+1)-B6","v":{"$error":"#DIV/0!"}}]
[]
["Date Calculations"]
["Date ABE application will get submitted"]
["All billing dates must be after:",{"$f":"EDATE(B11,-6)","v":{"$error":"#NUM!"}}]
[]
["Statement Date","Source","Bill Amount","How many times have you paid this bill in the past 6 months?","Total Client Paid in Past 6 Mos","Notes"]
[null,"[Medicare Part B Premium]",null,null,{"$f":"IF(D15=0,C15*1,C15*D15)","v":0}]
[null,"[Part D Premium]",null,null,0]
[null,"[Medicare Advantage Premium]",null,null,0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]

{"sheet":"ASSET SPENDDOWN INSTRUCTIONS","index":3,"n_rows":55,"n_cols":6,"rows_kept":55}
["Spenddown Calculations"]
["Total Assets"]
["2024 AABD Medicaid Asset Limit",{"v":17500,"d":"$17,500.00"}]
["Asset Spenddown Amount",{"$f":"IF((B2-B3)<0,\"0\",B2-B3)","v":"0"}]
["Total Medical Expenses",{"$f":"SUM(E:E)","v":0}]
["Asset Spenddown Met?",{"$f":"IF(B2-B5<=B3,\"YES\",\"NO\")","v":"YES"}]
[]
["Date Calculations"]
["Date ABE application will get submitted"]
["All billing dates must be after:",{"$f":"EDATE(B9,-6)","v":{"$error":"#NUM!"}}]
[]
["Statement Date","Source","Bill Amount","How many times have you paid this bill in the past 6 months?","Total Client Paid in Past 6 Mos","Notes"]
[{"$nulls":3},1,{"$f":"IF(D13=0,C13*1,C13*D13)","v":0}]
[{"$nulls":4},{"$f":"IF(D14=0,C14*1,C14*D14)","v":0}]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]

{"sheet":"DropDown","index":4,"n_rows":7,"n_cols":1,"rows_kept":7,"hidden":true}
["Frequency"]
[1]
[2]
[3]
[4]
[5]
[6]