{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Spenddown","Medical Expenses","Instructions"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":0,"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":"Spenddown","index":0,"n_rows":20,"n_cols":11,"rows_kept":20,"cut":false,"hidden":false,"merged":[[17,0,17,1],[5,10,10,10],[3,0,3,6],[5,8,10,8],[5,9,10,9]]}
["Case Number"]
["Case Name"]
[]
["New  Medical Base Period  "]
["Base Period Month","Total Earned Income","$20 Disregard if not used on Unearned","Earned Income After All Disregards","Total Unearned Income","Unearned Disregards","Unearned Income After All Disregards","Countable Income","Spenddown Amount (Less PIL)","Expenses","Remaining Spenddown Amount"]
[null,null,{"$f":"20-F6","v":20},{"$f":"MAX(((B6 -E16-65-C6)-E17)/2,0)","v":0},null,{"$f":"IF(OR(E6>20,E6=20),20,E6)","v":0},{"$f":"E6-F6","v":0},{"$f":"MAX(D6+G6-E18,0)","v":0},{"$f":"MAX((SUM($H$6:$H$11)-(B20*C20)),0)","v":0},{"$f":"'Medical Expenses'!H27","v":0},{"$f":"MAX(I6-J6,0)","v":0}]
[{"$f":"IF(A6=0,\"\",EDATE(A6,1))","v":""},null,{"$f":"20-F7","v":20},{"$f":"MAX(((B7 -F16-65-C7)-F17)/2,0)","v":0},null,{"$f":"IF(OR(E7>20,E7=20),20,E7)","v":0},0,{"$f":"MAX(D7+G7-F18,0)","v":0}]
[{"$f":"IF(A6=0,\"\",EDATE(A6,2))","v":""},null,{"$f":"20-F8","v":20},{"$f":"MAX(((B8 -G16- 65-C8)-G17)/2,0)","v":0},null,0,0,{"$f":"MAX(D8+G8-G18,0)","v":0}]
[{"$f":"IF(A6=0,\"\",EDATE(A6,3))","v":""},null,20,{"$f":"MAX(((B9 -H16- 65-C9)-H17)/2,0)","v":0},null,0,0,{"$f":"MAX(D9+G9-H18,0)","v":0}]
[{"$f":"IF(A6=0,\"\",EDATE(A6,4))","v":""},null,20,{"$f":"MAX(((B10 - I16-65-C10)-I17)/2,0)","v":0},null,0,0,{"$f":"MAX(D10+G10-I18,0)","v":0}]
[{"$f":"IF(A6=0,\"\",EDATE(A6,5))","v":""},null,20,{"$f":"MAX(((B11 -J16- 65-C11)-J17)/2,0)","v":0},null,0,0,{"$f":"MAX(D11+G11-J18,0)","v":0}]
[]
[]
["IRWE or BWE",null,null,null,{"$f":"IF(A6=\"\", \"Month 1\", A6)","v":"Month 1"},{"$f":"IF(A7=\"\", \"Month 2\", A7)","v":"Month 2"},{"$f":"IF(A8=\"\", \"Month 3\", A8)","v":"Month 3"},{"$f":"IF(A9=\"\", \"Month 4\", A9)","v":"Month 4"},{"$f":"IF(A10=\"\", \"Month 5\", A10)","v":"Month 5"},{"$f":"IF(A11=\"\", \"Month 6\", A11)","v":"Month 6"}]
[null,null,null,"IRWE/BWE Reported Amount"]
[null,null,null,"IRWE/BWE Deduction",{"$f":"MAX(E15,IF(A15=\"IRWE\",100,IF(A15=\"BWE\",300,IF(A15=\"Actuals\",0,0))))","v":0},{"$f":"MAX(F15,IF(A15=\"IRWE\",100,IF(A15=\"BWE\",300,IF(A15=\"Actuals\",0,0))))","v":0},{"$f":"MAX(G15,IF(A15=\"IRWE\",100,IF(A15=\"BWE\",300,IF(A15=\"Actuals\",0,0))))","v":0},{"$f":"MAX(H15,IF(A15=\"IRWE\",100,IF(A15=\"BWE\",300,IF(A15=\"Actuals\",0,0))))","v":0},{"$f":"MAX(I15,IF(A15=\"IRWE\",100,IF(A15=\"BWE\",300,IF(A15=\"Actuals\",0,0))))","v":0},{"$f":"MAX(J15,IF(A15=\"IRWE\",100,IF(A15=\"BWE\",300,IF(A15=\"Actuals\",0,0))))","v":0}]
[null,null,null,"Pre-Tax  Deductions"]
["Independent Living Protected Income Limits (PIL) for One Month",null,null,"Federal Deductions"]
["Household Size","1 or 2 persons","Number of Months in Base Period"]
["PIL",475]

{"sheet":"Medical Expenses","index":1,"n_rows":27,"n_cols":8,"rows_kept":27,"cut":false,"hidden":false,"merged":[[0,3,0,4],[1,3,1,4],[2,3,2,4],[3,0,3,5],[4,0,4,7]]}
["Case Number",{"$f":"IF(Spenddown!$B$1 = \"\", \"\", Spenddown!$B$1)","v":""},null,"Base Period",null,"Current"]
["Case Name",{"$f":"IF(Spenddown!$B$2 = \"\", \"\", Spenddown!$B$2)","v":""},null,"Initial Spenddown",null,{"$f":"Spenddown!I6","v":0}]
[null,null,null,"Remaining Spenddown",null,{"$f":"MAX($F$2 - $H$27,0)","v":0}]
[]
["Medical Expenses"]
["Role\n(MEM/FRI)","Name","Provider Information","Date of Service","Total Charge","Allowable Amount per Month","# of months","Allowable Amount in Base Period"]
[null,null,null,null,null,null,null,{"$f":"F7*G7","v":0}]
[null,null,null,null,null,null,null,{"$f":"F8*G8","v":0}]
[null,null,null,null,null,null,null,{"$f":"F9*G9","v":0}]
[null,null,null,null,null,null,null,{"$f":"F10*G10","v":0}]
[null,null,null,null,null,null,null,{"$f":"F11*G11","v":0}]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,{"$f":"F14*G14","v":0}]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,"Total",{"$f":"SUM(E7:E26)","v":0},null,null,{"$f":"SUM(H7:H26)","v":0}]

{"sheet":"Instructions","index":2,"n_rows":2,"n_cols":1,"rows_kept":2,"cut":false,"hidden":false,"merged":[]}
["Spenddown Estimator Tool"]
["Overview:  The Spenddown Estimator Tool is used when estimating a potential spenddown for E&D programs.  \n\nGeneral Instructions\nEnter the Case Name and Case Number at the top of the Spenddown Worksheet.  This information will automatically populate onto the Medical Expenses tab.  Enter the first month of the base period and the other months will populate. Enter the number of months that are included in the base period (usually 3 or 6).\n\nUsers will enter the Total Earned Income and Total Unearned Income to calculate the Spenddown Amount.  The Protected Income Limit is automatically generated. Use the IRWE or BWE dropdown and enter the reported amount of IRWE or BWE expense if one of these is to be applied. Enter the allowable Pre-tax and Federal tax deductions. This populates the spenddown amount, the amount the consumer will have to meet before any medical expenses are applied.\n\nOnce expenses are applied using the Medical Expenses tab, the amount will update in the Remaining Spenddown Amount field.  \n\nEntering Medical Expenses:  Data collected on this tab will assist the worker in calculating the Remaining Spenddown once expenses have been applied. Each expense will be added to the worksheet by entering the Role, Name (of the person the expense is for), Provider Information, Date of Service, Total Charge, Allowable Amount per Month, and Number of Months To Allow.  Only the Allowable Amount per Base Period will be deducted from the Initial Spenddown.  The total Allowable Amount per Base Period will then feed automatically into the Spenddown tab under Expenses.  \n\nBoth tabs of the Spenddown Worksheet will need to be imaged to the KEES case.  "]