{"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":66,"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":18,"n_cols":2,"rows_kept":18,"cut":false,"hidden":false,"merged":[[0,0,0,1]]}
["MEDDedCredit"]
["Anthem","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":21,"rows_kept":34,"cut":false,"hidden":false,"merged":[[33,15,33,20],[28,1,28,6],[28,8,28,13],[31,15,31,20],[32,15,32,20],[28,15,28,20],[30,15,30,20],[30,8,30,13],[31,8,31,13],[32,8,32,13],[29,4,29,6],[33,8,33,13],[33,1,33,6],[31,1,31,6],[29,15,29,20],[32,1,32,6],[2,0,3,0],[2,8,2,13],[3,8,3,10],[3,11,3,13],[2,1,2,6],[3,1,3,3],[3,4,3,6],[30,1,30,6],[2,15,2,20],[3,15,3,17],[3,18,3,20],[29,1,29,3],[29,8,29,13]]}
[]
["Connecticut 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","Anthem",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"]
["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"]
["HMO  g  HMO","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"]
["HMO  g  PPO","l","l ","l","l","l","l",null,"l","l","l","l","l","l",null,"l","l","l","l","l","l"]
["HMO  g  EPO","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"]
["HMO  g  HSA","l","l","l","l","l","l",null,"l","l","l","l","l","l",null,"l","l","l","l","l","l"]
[]
["PPO  g  PPO","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,"l","l","l","l","l","l",null,"N/A","N/A","N/A","N/A","N/A","N/A"]
["PPO  g  EPO","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"]
["PPO  g  HSA","l","l","l","l","l","l",null,"l","l","l","l","l","l",null,"l","l","l","l","l","l"]
[]
["EPO  g  EPO","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"]
["EPO  g  HMO","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"]
["EPO  g  PPO","l","l","l","l","l","l",null,"l","l","l","l","l","l",null,"l","l","l","l","l","l"]
["EPO  g  HSA","l","l","l","l","l","l",null,"l","l","l","l","l","l",null,"l","l","l","l","l","l"]
[]
["HSA g  HSA","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,"l","l","l","l","l","l",null,"N/A","N/A","N/A","N/A","N/A","N/A"]
["HSA g  PPO","l","l","l","l","l","l",null,"l","l","l","l","l","l",null,"l","l","l","l","l","l"]
["HSA g  EPO","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"]
[]
[]
["4th Quarter Carryover","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.","-",null,null,null,null,null,null,"-",null,null,null,null,null,null,"-"]
["NOTES:","-",null,null,"-",null,null,null,"Deductible credit is applied for groups that move from a calendar year accumulation plan to another calendar year accumulation plan. Deductible credits would NOT apply when the group elects a plan year accumulator plan.",null,null,null,null,null,null,"Deductible credit is applied for groups that move from a calendar year accumulation plan to another calendar year accumulation plan. Deductible credits would NOT apply when the group elects a plan year accumulator plan."]
["How to Request Credit"," "]
["What materials are needed:","-",null,null,null,null,null,null,"Submit completed Deductible Credit Form along with an EOB.",null,null,null,null,null,null,"Submit completed Deductible Credit Form along with an EOB."]
["Where are materials sent:","-",null,null,null,null,null,null,"Deductible Credit Center, P.O. Box 29135, Hot Springs, AR 71903",null,null,null,null,null,null,"send to ga_service@uhc.com "]
["When request should be made:","-",null,null,null,null,null,null,"At initial submission.",null,null,null,null,null,null,"At initial submission."]