{"text_format":"2","workbook":"xls","n_sheets":4,"sheets":["EnableMacros","Master","Rate Table","names"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":1,"defined_names":9,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","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","formulas":"cached_only"}

{"sheet":"EnableMacros","index":0,"n_rows":17,"n_cols":2,"rows_kept":17,"cut":false,"hidden":true,"merged":[[0,0,0,15],[1,0,1,15],[2,0,2,15]],"flags":["formulas_cached_only"]}
["Rates Template"]
[]
[]
[]
[]
[null,"If you are seeing this sheet, macros are not enabled, please follow the following steps: "]
[]
[]
[null,"If using Excel 2007 and 2010:"]
[null,"1. Set the macro security setting to Disable macros with notifications (Recommended) or Enable all macros. To change"]
[null,"    the macro security setting, click the Office Button and select Excel Option -> Trust Center -> Trust Center Settings -> "]
[null,"    Macro Settings."]
[null,"2. If the macro security setting is set to Disable macros with notifications, click the Option button and select Enable this "]
[null,"    content."]
[]
[]
[null,"Note: This screen will flash momentarily when you save or finalize this workbook."]

{"sheet":"Master","index":1,"n_rows":14,"n_cols":13,"rows_kept":14,"cut":false,"hidden":true,"merged":[[11,6,11,12]],"flags":["formulas_cached_only"]}
["2019 Rates Table Template v8.1","All fields with an asterisk (*) are required. To validate press Validate button or Ctrl + Shift + I. To finalize, press Finalize button or Ctrl + Shift + F."]
["If macros are disabled, press and hold the ALT key and press the F, then I, and then N key. After that, select the Enable All Content option by pressing enter. (note that you can also press the C key to select \"Enable All Content\")  Instructions can be found in cells B1 through B5.","If you are in a community rating state, select Family-Tier Rates under Rating Method and fill in all columns."]
[null,"If you are not in a community rating state, select Age-Based Rates under Rating Method and provide an Individual Rate for every age band."]
[null,"If Tobacco is Tobacco User/Non-Tobacco User, you must give a rate for Tobacco Use and Non-Tobacco Use."]
[null,"To add a new sheet, press the Add Sheet button, or Ctrl + Shift + H. All plans must have the same dates on a sheet."]
["HIOS Issuer ID*"]
["Federal TIN*"]
["Rate Effective Date*"]
["Rate Expiration Date*"]
["Rating Method*"]
[]
[{"$nulls":6},"Family Tier"]
["Plan ID*","Rating Area ID*","Tobacco*","Age*","Individual Rate*","Individual Tobacco Rate*","Couple*","Primary Subscriber and One Dependent*","Primary Subscriber and Two Dependents*","Primary Subscriber and Three or More Dependents*","Couple and One Dependent*","Couple and Two Dependents*","Couple and Three or More Dependents*"]
["Required:\nEnter the 14-character Plan ID","Required:\nSelect the Rating Area ID","Required:\nSelect if Tobacco use of subscriber is used to determine if a person is eligible for a rate from a plan","Required:\nSelect the age of a subscriber eligible for the rate","Required:\nEnter the rate of an Individual Non-Tobacco or No Preference enrollee on a plan","Required:\nEnter the rate of an Individual tobacco enrollee on a plan","Required:\nEnter the rate of a couple based on the pairing of a primary enrollee and a secondary subscriber (e.g. husband and spouse)","Required:\nEnter the rate of a family based on a single parent with one dependent","Required:\nEnter the rate of a family based on a single parent with two dependents","Required:\nEnter the rate of a family based on a single parent with three or more dependents","Required:\nEnter the rate of a family based on a couple with one dependent","Required:\nEnter the rate of a family based on a couple with two dependents","Required:\nEnter the rate of a family based on a couple with three or more dependents"]

{"sheet":"Rate Table","index":2,"n_rows":16,"n_cols":256,"rows_kept":16,"cut":false,"hidden":false,"merged":[[11,6,11,12]],"flags":["formulas_cached_only"]}
[null,"All fields with an asterisk (*) are required. To validate press Validate button or Ctrl + Shift + I. To finalize, press Finalize button or Ctrl + Shift + F."]
["If macros are disabled, press and hold the ALT key and press the F, then I, and then N key. After that, select the Enable All Content option by pressing enter. (note that you can also press the C key to select \"Enable All Content\")  Instructions can be found in cells B1 through B5.","If you are in a community rating state, select Family-Tier Rates under Rating Method and fill in all columns."]
[null,"If you are not in a community rating state, select Age-Based Rates under Rating Method and provide an Individual Rate for every age band."]
[null,"If Tobacco is Tobacco User/Non-Tobacco User, you must give a rate for Tobacco Use and Non-Tobacco Use."]
[null,"To add a new sheet, press the Add Sheet button, or Ctrl + Shift + H. All plans must have the same dates on a sheet."]
["HIOS Issuer ID*"]
["Federal TIN*"]
["Rate Effective Date*"]
["Rate Expiration Date*"]
["Rating Method*"]
[]
[{"$nulls":6},"Family Tier"]
["Plan ID*","Rating Area ID*","Tobacco*","Age*","Individual Rate*","Individual Tobacco Rate*","Couple*","Primary Subscriber and One Dependent*","Primary Subscriber and Two Dependents*","Primary Subscriber and Three or More Dependents*","Couple and One Dependent*","Couple and Two Dependents*","Couple and Three or More Dependents*"]
["Required:\nEnter the 14-character Plan ID","Required:\nSelect the Rating Area ID","Required:\nSelect if Tobacco use of subscriber is used to determine if a person is eligible for a rate from a plan","Required:\nSelect the age of a subscriber eligible for the rate","Required:\nEnter the rate of an Individual Non-Tobacco or No Preference enrollee on a plan","Required:\nEnter the rate of an Individual tobacco enrollee on a plan","Required:\nEnter the rate of a couple based on the pairing of a primary enrollee and a secondary subscriber (e.g. husband and spouse)","Required:\nEnter the rate of a family based on a single parent with one dependent","Required:\nEnter the rate of a family based on a single parent with two dependents","Required:\nEnter the rate of a family based on a single parent with three or more dependents","Required:\nEnter the rate of a family based on a couple with one dependent","Required:\nEnter the rate of a family based on a couple with two dependents","Required:\nEnter the rate of a family based on a couple with three or more dependents"]
[{"$nulls":13},1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1]
[{"$nulls":13},2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2]

{"sheet":"names","index":3,"n_rows":150,"n_cols":4,"rows_kept":150,"cut":false,"hidden":true,"merged":[],"flags":["formulas_cached_only"]}
["Rating Area 1","0-14","Tobacco User/Non-Tobacco User","Age-Based Rates"]
["Rating Area 2",15,"No Preference","Family-Tier Rates"]
["Rating Area 3",16]
["Rating Area 4",17]
["Rating Area 5",18]
["Rating Area 6",19]
["Rating Area 7",20]
["Rating Area 8",21]
["Rating Area 9",22]
["Rating Area 10",23]
["Rating Area 11",24]
["Rating Area 12",25]
["Rating Area 13",26]
["Rating Area 14",27]
["Rating Area 15",28]
["Rating Area 16",29]
["Rating Area 17",30]
["Rating Area 18",31]
["Rating Area 19",32]
["Rating Area 20",33]
["Rating Area 21",34]
["Rating Area 22",35]
["Rating Area 23",36]
["Rating Area 24",37]
["Rating Area 25",38]
["Rating Area 26",39]
["Rating Area 27",40]
["Rating Area 28",41]
["Rating Area 29",42]
["Rating Area 30",43]
["Rating Area 31",44]
["Rating Area 32",45]
["Rating Area 33",46]
["Rating Area 34",47]
["Rating Area 35",48]
["Rating Area 36",49]
["Rating Area 37",50]
["Rating Area 38",51]
["Rating Area 39",52]
["Rating Area 40",53]
["Rating Area 41",54]
["Rating Area 42",55]
["Rating Area 43",56]
["Rating Area 44",57]
["Rating Area 45",58]
["Rating Area 46",59]
["Rating Area 47",60]
["Rating Area 48",61]
["Rating Area 49",62]
["Rating Area 50",63]
["Rating Area 51","64 and over"]
["Rating Area 52"]
["Rating Area 53"]
["Rating Area 54"]
["Rating Area 55"]
["Rating Area 56"]
["Rating Area 57"]
["Rating Area 58"]
["Rating Area 59"]
["Rating Area 60"]
["Rating Area 61"]
["Rating Area 62"]
["Rating Area 63"]
["Rating Area 64"]
["Rating Area 65"]
["Rating Area 66"]
["Rating Area 67"]
["Rating Area 68"]
["Rating Area 69"]
["Rating Area 70"]
["Rating Area 71"]
["Rating Area 72"]
["Rating Area 73"]
["Rating Area 74"]
["Rating Area 75"]
["Rating Area 76"]
["Rating Area 77"]
["Rating Area 78"]
["Rating Area 79"]
["Rating Area 80"]
["Rating Area 81"]
["Rating Area 82"]
["Rating Area 83"]
["Rating Area 84"]
["Rating Area 85"]
["Rating Area 86"]
["Rating Area 87"]
["Rating Area 88"]
["Rating Area 89"]
["Rating Area 90"]
["Rating Area 91"]
["Rating Area 92"]
["Rating Area 93"]
["Rating Area 94"]
["Rating Area 95"]
["Rating Area 96"]
["Rating Area 97"]
["Rating Area 98"]
["Rating Area 99"]
["Rating Area 100"]
["Rating Area 101"]
["Rating Area 102"]
["Rating Area 103"]
["Rating Area 104"]
["Rating Area 105"]
["Rating Area 106"]
["Rating Area 107"]
["Rating Area 108"]
["Rating Area 109"]
["Rating Area 110"]
["Rating Area 111"]
["Rating Area 112"]
["Rating Area 113"]
["Rating Area 114"]
["Rating Area 115"]
["Rating Area 116"]
["Rating Area 117"]
["Rating Area 118"]
["Rating Area 119"]
["Rating Area 120"]
["Rating Area 121"]
["Rating Area 122"]
["Rating Area 123"]
["Rating Area 124"]
["Rating Area 125"]
["Rating Area 126"]
["Rating Area 127"]
["Rating Area 128"]
["Rating Area 129"]
["Rating Area 130"]
["Rating Area 131"]
["Rating Area 132"]
["Rating Area 133"]
["Rating Area 134"]
["Rating Area 135"]
["Rating Area 136"]
["Rating Area 137"]
["Rating Area 138"]
["Rating Area 139"]
["Rating Area 140"]
["Rating Area 141"]
["Rating Area 142"]
["Rating Area 143"]
["Rating Area 144"]
["Rating Area 145"]
["Rating Area 146"]
["Rating Area 147"]
["Rating Area 148"]
["Rating Area 149"]
["Rating Area 150"]