{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Introduction","Lists","MEDICAL-Ded Credit"],"not_rendered":{"charts":0,"images":7,"macros":1,"external_links":0,"defined_names":77,"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":"Introduction","index":0,"n_rows":105,"n_cols":1,"rows_kept":105,"cut":false,"hidden":false,"merged":[]}
["\nGuidelines for Deductible & Out-of-Pocket Max Credit\nCarriers can apply different rules for credit based on plan type. In addition, rules can vary\nif a member is moving within a carriers own products or coming from another carrier.  \n\nCustomize the grid based on your group scenario to see how the carrier will handle credit."]
["TO USE THIS TOOL, YOU MUST ENABLE MACROS."]
["If you were able to view the welcome message pop-up upon open, your macros are already enabled."]
[]
["If you see the Security Warning message bar, click Options and select Enable this Content."]
[]
["If you did not receive the Welcome message and you do NOT see the Security Warning message bar:"]
["1.  Click the File ribbon menu and select Options"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["2.  Click Trust Center from the left navigation, then Trust Center Settings from the lower right."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["3.  Click Macro Settings from the left navigation, then Disable all macros with notification. Click OK to close."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["3.  Click OK to close the Excel Options Window.  Close excel and reopen the file."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["4.When you see the Security Warning message bar, click Enable Content. "]

{"sheet":"Lists","index":1,"n_rows":20,"n_cols":2,"rows_kept":20,"cut":false,"hidden":false,"merged":[[0,0,0,1]]}
["MEDDedCredit"]
["Aetna","Yes"]
["Anthem","Yes"]
["HealthPass","Yes"]
["Oxford","Yes"]
["UHC","Yes"]
["MovingSame","Yes"]
["MovingDiff","Yes"]
["FromHMO","Yes"]
["FromPPO","Yes"]
["FromEPO","Yes"]
["FromHSA","Yes"]
["ToHMO","Yes"]
["ToPPO","Yes"]
["ToEPO","Yes"]
["ToHSA","Yes"]
["Instructions","Yes"]
["Q4","Yes"]
["Notes","Yes"]
["OONAcc","Yes"]

{"sheet":"MEDICAL-Ded Credit","index":2,"n_rows":34,"n_cols":35,"rows_kept":34,"cut":false,"hidden":false,"merged":[[2,0,3,0],[29,29,29,31],[29,32,29,34],[29,25,29,27],[2,22,2,27],[3,22,3,24],[3,25,3,27],[2,15,2,20],[3,15,3,17],[3,18,3,20],[2,8,2,13],[3,8,3,10],[3,11,3,13],[29,4,29,6],[33,29,33,34],[28,8,28,13],[28,22,28,27],[31,29,31,34],[32,29,32,34],[28,29,28,34],[30,29,30,34],[30,22,30,27],[31,22,31,27],[32,22,32,27],[28,15,28,20],[29,15,29,17],[31,1,31,6],[29,11,29,13],[28,1,28,6],[33,22,33,27],[29,22,29,24],[32,1,32,6],[33,1,33,6],[29,18,29,20],[30,15,30,20],[31,15,31,20],[32,15,32,20],[33,15,33,20],[33,8,33,13],[31,8,31,13],[32,8,32,13],[29,1,29,3],[30,1,30,6],[29,8,29,10],[30,8,30,13],[2,29,2,34],[3,29,3,31],[3,32,3,34],[2,1,2,6],[3,1,3,3],[3,4,3,6]]}
[]
["New York Deductible & Out-of-Pocket Max Credit Guidelines and Request Process"]
["Legend\nl Yes, credit is applied\nl See Notes\nl No, credit is not applied","Aetna",null,null,null,null,null,null,"Anthem",null,null,null,null,null,null,"HealthPass",null,null,null,null,null,null,"Oxford",null,null,null,null,null,null,"UnitedHealthcare"]
[null,"Moving within the Same Carrier",null,null,"Moving from a Different Carrier",null,null,null,"Moving within the Same Carrier",null,null,"Moving from a Different Carrier",null,null,null,"Moving within the Same Carrier",null,null,"Moving from a Different Carrier",null,null,null,"Moving within the Same Carrier",null,null,"Moving from a Different Carrier",null,null,null,"Moving within the Same Carrier",null,null,"Moving from a Different Carrier"]
["Credit Availability","Plan Deductible","Rx \nDeductible","Out-of-Pocket Max","Plan Deductible","Rx \nDeductible","Out-of-Pocket Max",null,"Plan Deductible","Rx \nDeductible","Out-of-Pocket Max","Plan Deductible","Rx \nDeductible","Out-of-Pocket Max",null,"Plan Deductible","Rx \nDeductible","Out-of-Pocket Max","Plan Deductible","Rx \nDeductible","Out-of-Pocket Max",null,"Plan Deductible","Rx \nDeductible","Out-of-Pocket Max","Plan Deductible","Rx \nDeductible","Out-of-Pocket Max",null,"Plan Deductible","Rx \nDeductible","Out-of-Pocket Max","Plan Deductible","Rx \nDeductible","Out-of-Pocket Max"]
["HMO  g  HMO","N/A","N/A","N/A","N/A","N/A","N/A",null,"N/A","N/A","N/A","N/A","N/A","N/A",null,"l","l","l","l","l","l",null,"N/A","N/A","N/A","N/A","N/A","N/A",null,"N/A","N/A","N/A","N/A","N/A","N/A"]
["HMO  g  PPO","N/A","N/A","N/A","N/A","N/A","N/A",null,"l","l","l","l","l","l",null,"l","l","l","l","l","l",null,"l","l","l","l","l","l",null,"l","l","l","l","l","l"]
["HMO  g  EPO","l ","l ","l ","l ","l ","l ",null,"l","l","l","l","l","l",null,"l","l","l","l","l","l",null,"N/A","N/A","N/A","N/A","N/A","N/A",null,"l","l","l","l","l","l"]
["HMO  g  HSA","N/A","N/A","N/A","N/A","N/A","N/A",null,"l","l","l","l","l","l",null,"l","l","l","l","l","l",null,"l","l","l","l","l","l",null,"l","l","l","l","l","l"]
[]
["PPO  g  PPO","N/A","N/A","N/A","N/A","N/A","N/A",null,"l","l","l","l","l","l",null,"l","l","l","l","l","l",null,"l","l","l","l","l","l",null,"l","l","l","l","l","l"]
["PPO  g  HMO","N/A","N/A","N/A","N/A","N/A","N/A",null,"N/A","N/A","N/A","N/A","N/A","N/A",null,"l","l","l","l","l","l",null,"N/A","N/A","N/A","N/A","N/A","N/A",null,"N/A","N/A","N/A","N/A","N/A","N/A"]
["PPO  g  EPO","l ","l ","l ","l ","l ","l ",null,"l","l","l","l","l","l",null,"l","l","l","l","l","l",null,"l","l","l","l","l","l",null,"l","l","l","l","l","l"]
["PPO  g  HSA","N/A","N/A","N/A","N/A","N/A","N/A",null,"l","l","l","l","l","l",null,"l","l","l","l","l","l",null,"l","l","l","l","l","l",null,"l","l","l","l","l","l"]
[null,"l ","l ","l "]
["EPO  g  EPO","l ","l ","l ","l ","l ","l ",null,"l","l","l","l","l","l",null,"l","l","l","l","l","l",null,"l","l","l","l","l","l",null,"l","l","l","l","l","l"]
["EPO  g  HMO","N/A","N/A","N/A","N/A","N/A","N/A",null,"N/A","N/A","N/A","N/A","N/A","N/A",null,"l","l","l","l","l","l",null,"N/A","N/A","N/A","N/A","N/A","N/A",null,"N/A","N/A","N/A","N/A","N/A","N/A"]
["EPO  g  PPO","N/A","N/A","N/A","N/A","N/A","N/A",null,"l","l","l","l","l","l",null,"l","l","l","l","l","l",null,"l","l","l","l","l","l",null,"l","l","l","l","l","l"]
["EPO  g  HSA","N/A","N/A","N/A","N/A","N/A","N/A",null,"l","l","l","l","l","l",null,"l","l","l","l","l","l",null,"l","l","l","l","l","l",null,"l","l","l","l","l","l"]
[]
["HSA g  HSA","N/A","N/A","N/A","N/A","N/A","N/A",null,"l","l","l","l","l","l",null,"l","l","l","l","l","l",null,"l","l","l","l","l","l",null,"l","l","l","l","l","l"]
["HSA g  HMO","N/A","N/A","N/A","N/A","N/A","N/A",null,"N/A","N/A","N/A","N/A","N/A","N/A",null,"l","l","l","l","l","l",null,"N/A","N/A","N/A","N/A","N/A","N/A",null,"N/A","N/A","N/A","N/A","N/A","N/A"]
["HSA g  PPO","N/A","N/A","N/A","N/A","N/A","N/A",null,"l","l","l","l","l","l",null,"l","l","l","l","l","l",null,"l","l","l","l","l","l",null,"l","l","l","l","l","l"]
["HSA g  EPO","l ","l ","l ","l ","l ","l ",null,"l","l","l","l","l","l",null,"l","l","l","l","l","l",null,"l","l","l","l","l","l",null,"l","l","l","l","l","l"]
[]
[]
["4th Quarter Carryover","l ","l ","l ","l ","l ","l ",null,"l","l","l","l","l","l",null,"l","l","l","l","l","l",null,"l","l","l","l","l","l",null,"l","l","l","l","l","l"]
[]
["Out-of-network Accumulation\nRules when \"Credit Availability\" applies; If carrier response is No then OON credit will also not apply.","No OON credit available. "]
["NOTES:","Credits available on calendar-year plans - not on plan-year plans. Members eligible only when coming from employers prior plan. ",null,null,"Credits available on calendar-year plans - not on plan-year plans. Members eligible only when coming from employers prior plan. "]
["How to Request Credit",null,null,null,null,null,null,null," "]
["What materials are needed:","Submit copy of EOB."]
["Where are materials sent:","Submit with initial enrollment OR fax to Claims Dept 1-866-474-4040. Include \"Deductible Credit Request\" in the subject line along with the Group/Control Number."]
["When request should be made:","Submit no later than 90 days after the effective date of coverage."]