{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Calculator","all years","2021","2022","2023","2024"],"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":"Calculator","index":0,"n_rows":5,"n_cols":5,"rows_kept":5,"cut":false,"hidden":false,"merged":[[0,0,0,4]]}
["Dual-Eligible PACE Plan Beneficiary\nAccumulated True Out-of-Pocket Cost Calculator\n\nINSTRUCTIONS:\n1. Ensure that macros are enabled\n2. Enter the Plan Year, incoming Current Year TGDC Transfer from Non-PACE, Current Year TrOOP\nTransfer from Non-PACE, and Current Year Dual-Eligible TGDC amounts in columns A through D row 3\n3. Press CTRL-R on the keyboard\n4. Beneficiary's year-to-date Total True Out-of-Pocket Cost will appear in column E row 3\n5. Clear cells by pressing CTRL-D on the keyboard"]
["Plan Year","Current Year TGDC Transfer from Non-PACE*","Current Year TrOOP Transfer from Non-PACE*","Current Year Dual-Eligible TGDC*","Total True \nOut-of-Pocket Cost"]
[2024]
[]
["*Enter values without commas or special characters (e.g., 1000.00 instead of 1,000.00)"]

{"sheet":"all years","index":1,"n_rows":5,"n_cols":16,"rows_kept":5,"cut":false,"hidden":false,"merged":[]}
["Bene Year","Deductible - Low","Deductible - High","Amt in phase","Deductible - %","Cost Sharing - Low","Cost Sharing - High","Amt in phase","Cost Sharing - %","Coverage Gap - Low","Coverage Gap - High","Amt in phase","Coverage Gap - %","Catastrophic - Low","Catastrophic - %","Catastrophic - TrOOP Threshhold"]
[2021,{"$f":"'2021'!$B$7","v":0},{"$f":"'2021'!$C$7","v":445},{"$f":"'2021'!$D$7","v":445},{"$f":"'2021'!$E$7","v":0.98},{"$f":"'2021'!$B$8","v":445.01},{"$f":"'2021'!$C$8","v":4130},{"$f":"'2021'!$D$8","v":3685},{"$f":"'2021'!$E$8","v":0.23},{"$f":"'2021'!$B$9","v":4130.01},{"$f":"'2021'!$C$9","v":9503.83},{"$f":"'2021'!$D$9","v":5373.83},{"$f":"'2021'!$E$9","v":0.98},{"$f":"'2021'!$B$10","v":9503.84},{"$f":"'2021'!$E$10","v":0.05},{"$f":"'2021'!$C$3","v":6550}]
[2022,{"$f":"'2022'!$B$7","v":0},{"$f":"'2022'!$C$7","v":480},{"$f":"'2022'!$D$7","v":480},{"$f":"'2022'!$E$7","v":0.98},{"$f":"'2022'!$B$8","v":480.01},{"$f":"'2022'!$C$8","v":4430},{"$f":"'2022'!$D$8","v":3950},{"$f":"'2022'!$E$8","v":0.23},{"$f":"'2022'!$B$9","v":4430.01},{"$f":"'2022'!$C$9","v":10216.84},{"$f":"'2022'!$D$9","v":5786.84},{"$f":"'2022'!$E$9","v":0.98},{"$f":"'2022'!$B$10","v":10216.85},{"$f":"'2022'!$E$10","v":0.05},{"$f":"'2022'!$C$3","v":7050}]
[2023,{"$f":"'2023'!$B$7","v":0},{"$f":"'2023'!$C$7","v":505},{"$f":"'2023'!$D$7","v":505},{"$f":"'2023'!$E$7","v":0.98},{"$f":"'2023'!$B$8","v":505.01},{"$f":"'2023'!$C$8","v":4660},{"$f":"'2023'!$D$8","v":4155},{"$f":"'2023'!$E$8","v":0.23},{"$f":"'2023'!$B$9","v":4660.01},{"$f":"'2023'!$C$9","v":10730.87},{"$f":"'2023'!$D$9","v":6070.8700000000008},{"$f":"'2023'!$E$9","v":0.98},{"$f":"'2023'!$B$10","v":10730.880000000001},{"$f":"'2023'!$E$10","v":0.05},{"$f":"'2023'!$C$3","v":7400}]
[2024,{"$f":"'2024'!$B$7","v":0},{"$f":"'2024'!$C$7","v":545},{"$f":"'2024'!$D$7","v":545},{"$f":"'2024'!$E$7","v":0.98},{"$f":"'2024'!$B$8","v":545.01},{"$f":"'2024'!$C$8","v":5030},{"$f":"'2024'!$D$8","v":4485},{"$f":"'2024'!$E$8","v":0.23},{"$f":"'2024'!$B$9","v":5030.01},{"$f":"'2024'!$C$9","v":11595.66},{"$f":"'2024'!$D$9","v":6565.66},{"$f":"'2024'!$E$9","v":0.98},{"$f":"'2024'!$B$10","v":11595.67},{"$f":"'2024'!$E$10","v":0.05},{"$f":"'2024'!$C$3","v":8000}]

{"sheet":"2021","index":2,"n_rows":10,"n_cols":5,"rows_kept":10,"cut":false,"hidden":true,"merged":[[4,1,4,2]]}
["Benefit Year",null,2021]
[]
["Catastrophic TrOOP Threshold",null,6550]
[]
[null,"Phase TGDC",null,null,"Percentage"]
["Benefit Phase","Lower","Upper (High)","Amount","LICS"]
["Deductible",0,445,445,0.98]
["Initial Cost-sharing",{"$f":"C7+0.01","v":445.01},4130,{"$f":"C8-C7","v":3685},0.23]
["Coverage Gap",{"$f":"C8+0.01","v":4130.01},9503.83,{"$f":"C9-C8","v":5373.83},0.98]
["Catastrophic ",{"$f":"C9+0.01","v":9503.84},"N/A","N/A",0.05]

{"sheet":"2022","index":3,"n_rows":10,"n_cols":5,"rows_kept":10,"cut":false,"hidden":true,"merged":[[4,1,4,2]]}
["Benefit Year",null,2022]
[]
["Catastrophic TrOOP Threshold",null,7050]
[]
[null,"Phase TGDC",null,null,"Percentage"]
["Benefit Phase","Lower","Upper (High)","Amount","LICS"]
["Deductible",0,480,480,0.98]
["Initial Cost-sharing",{"$f":"C7+0.01","v":480.01},4430,{"$f":"C8-C7","v":3950},0.23]
["Coverage Gap",{"$f":"C8+0.01","v":4430.01},10216.84,{"$f":"C9-C8","v":5786.84},0.98]
["Catastrophic ",{"$f":"C9+0.01","v":10216.85},"N/A","N/A",0.05]

{"sheet":"2023","index":4,"n_rows":10,"n_cols":5,"rows_kept":10,"cut":false,"hidden":true,"merged":[[4,1,4,2]]}
["Benefit Year",null,2023]
[]
["Catastrophic TrOOP Threshold",null,7400]
[]
[null,"Phase TGDC",null,null,"Percentage"]
["Benefit Phase","Lower","Upper (High)","Amount","LICS"]
["Deductible",0,505,505,0.98]
["Initial Cost-sharing",{"$f":"C7+0.01","v":505.01},4660,{"$f":"C8-C7","v":4155},0.23]
["Coverage Gap",{"$f":"C8+0.01","v":4660.01},10730.87,{"$f":"C9-C8","v":6070.8700000000008},0.98]
["Catastrophic ",{"$f":"C9+0.01","v":10730.880000000001},"N/A","N/A",0.05]

{"sheet":"2024","index":5,"n_rows":10,"n_cols":5,"rows_kept":10,"cut":false,"hidden":true,"merged":[[4,1,4,2]]}
["Benefit Year",null,2024]
[]
["Catastrophic TrOOP Threshold",null,8000]
[]
[null,"Phase TGDC",null,null,"Percentage"]
["Benefit Phase","Lower","Upper (High)","Amount","LICS"]
["Deductible",0,545,545,0.98]
["Initial Cost-sharing",{"$f":"C7+0.01","v":545.01},5030,{"$f":"C8-C7","v":4485},0.23]
["Coverage Gap",{"$f":"C8+0.01","v":5030.01},11595.66,{"$f":"C9-C8","v":6565.66},0.98]
["Catastrophic ",{"$f":"C9+0.01","v":11595.67},"N/A","N/A",0.05]