{"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":33,"n_cols":8,"rows_kept":33,"cut":false,"hidden":false,"merged":[[32,6,32,7],[5,7,7,7],[15,0,15,6],[10,0,10,6],[3,0,3,6],[5,5,7,5],[5,6,7,6]]}
["Case Number"]
["Case Name"]
[]
["Prior Medical Base Period (Usually 3 Months)"]
["Prior Medical Month","Total Gross Income","Household Size","PIL\n(One Month)","Countable Income","Spenddown Amount","Expenses","Remaining Spenddown Amount"]
[null,null,null,{"$f":"IF($C6=0,0,IF($C6<3,$B$18,IF($C6=3,$C$18,$D$18+($E$18*($C6-4)))))","v":0},{"$f":"B6-D6","v":0},{"$f":"MAX(E6+E7+E8,0)","v":0},{"$f":"IF('Medical Expenses'!$F$1 = \"Prior\", 'Medical Expenses'!$F$22, 0)","v":0},{"$f":"MAX(F6-G6,0)","v":0}]
[null,null,null,{"$f":"IF($C7=0,0,IF($C7<3,$B$18,IF($C7=3,$C$18,$D$18+($E$18*($C7-4)))))","v":0},{"$f":"B7-D7","v":0}]
[null,null,null,0,{"$f":"B8-D8","v":0}]
[]
[]
["Current Base Period (Usually 6 Months)"]
["Number of Months in Base Period","Total Gross Income\n(One Month)","Household Size","PIL\n(One Month)","Countable Income","Spenddown Amount","Expenses","Remaining Spenddown Amount"]
[null,null,null,{"$f":"IF($C13=0,0,IF($C13<3,$B$18,IF($C13=3,$C$18,$D$18+($E$18*($C13-4)))))","v":0},{"$f":"B13-D13","v":0},{"$f":"(E13*A13)","v":0},{"$f":"IF('Medical Expenses'!$F$1 = \"Current\", 'Medical Expenses'!$F$22, 0)","v":0},{"$f":"MAX(F13-G13,0)","v":0}]
[]
[]
["Independent Living Protected Income Limits (PIL) for One Month"]
["Household Size","1 or 2 persons","3 persons","4 Persons","Each Person After 4"]
["PIL",475,480,497,61]
["For each additional person after 4, add $61.00.  "]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,"KDHE DHCF Policy "]

{"sheet":"Medical Expenses","index":1,"n_rows":22,"n_cols":6,"rows_kept":22,"cut":false,"hidden":false,"merged":[[0,3,0,4],[1,3,1,4],[2,3,2,4],[3,0,3,5]]}
["Case Number",{"$f":"IF(Spenddown!$B$1 = \"\", \"\", Spenddown!$B$1)","v":""},null,"Base Period",null,"Prior"]
["Case Name",{"$f":"IF(Spenddown!$B$2 = \"\", \"\", Spenddown!$B$2)","v":""},null,"Initial Spenddown",null,{"$f":"IF($F$1 = \"Current\", Spenddown!$F$13, Spenddown!$F$6)","v":0}]
[null,null,null,"Remaining Spenddown",null,{"$f":"MAX($F$2 - $F$22,0)","v":0}]
[]
["Role\n(MEM/FRI)","Name","Provider Information","Date of Service","Total Charge","Client\nObligation"]
[" "," "]
[" ",null," "]
[" "]
[" "]
[" "]
[" "]
[" "]
[" "]
[" "]
[" "]
[" "]
[" "]
[" "]
[" "]
[" "]
[" "]
[null,null,null,"Total",{"$f":"SUM(E6:E21)","v":0},{"$f":"SUM(F6:F21)","v":0}]

{"sheet":"Instructions","index":2,"n_rows":2,"n_cols":1,"rows_kept":2,"cut":false,"hidden":false,"merged":[[0,0,0,12],[1,0,49,12]]}
["Family Medical Spenddown Worksheet Instructions"]
["Overview:  The Family Medical Spenddown Worksheet is used when estimating a potential spenddown as well as in combination with Workaround 61 to determine the amount of the spenddown to be used when overriding EDBC.  \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.  \nUsers will enter the Total Gross Income and Household Size to calculate the Spenddown Amount.  The Protected Income Limit is automatically generated based on the Household Size entered.  This populates the initial spenddown, the amount the consumer will have to meet before any expenses are applied.\nOnce expenses are applied using the Medical Expenses tab, the amount will update in the Remaining Spenddown Amount field.  The amount shown in this field will be used when completing the process outlined in Workaround 61.  \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, and Client Obligation.  Only the Client Obligation amount will be deducted from the Initial Spenddown.  The total Client Obligation will then feed automatically into the Spenddown tab under Expenses in either the Prior or Current spenddown base period.  The base period expenses are applied to on the Spenddown tab is determined by the value chosen in the Base Period drop-down on the Medical Expense tab.\n\nTwo spenddown worksheets will be needed to allow expenses (due & owing, health insurance premiums) toward both a Prior and a Current spenddown base period.  \n\nBoth tabs of the Spenddown Worksheet will need to be imaged to the KEES case.  \n"]