{"text_format":"3","workbook":"xlsx","n_sheets":3,"sheets":["Rate Table","EnableMacros","Sheet1"],"not_rendered":{"macros":1,"defined_names":4},"read":"whole","date_system":"1900"}

{"sheet":"Rate Table","index":0,"n_rows":1140,"n_cols":16,"rows_kept":1140,"hidden":true,"merged":[[8,6,8,12]]}
["Rates Table Template "]
["If you are a community rating state, select Family Option under Age and fill in all columns."]
["If you are not community rating state, select 0-20 under Age and provide an Individual Rate for every age band."]
["If Tobacco is Tobacco User/Non-Tobacco User, you must give a rate for Tobacco Use and Non-Tobacco Use."]
["To add a new sheet, press the Add Sheet button, or Ctrl + Shift + S. All plans must have the same dates on a sheet."]
["HIOS Issuer ID*"]
["Federal TIN*"]
["Rate Effective Date*"]
["Rate Expiration Date*",{"$nulls":5},"Family Tier"]
["Plan ID*\n(format 12345XX1234567)","Rating Area ID*","Tobacco*\n","Age*\n","Individual Rate*\n","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*"]
{"$rows_empty":980}
[{"$nulls":13},"Rating Area 1","Tobacco User/Non Tobacco User","Family Option"]
[{"$nulls":13},"Rating Area 2","No Preference","0-20"]
[{"$nulls":13},"Rating Area 3",null,21]
[{"$nulls":13},"Rating Area 4",null,22]
[{"$nulls":13},"Rating Area 5",null,23]
[{"$nulls":13},"Rating Area 6",null,24]
[{"$nulls":13},"Rating Area 7",null,25]
[{"$nulls":13},"Rating Area 8",null,26]
[{"$nulls":13},"Rating Area 9",null,27]
[{"$nulls":13},"Rating Area 10",null,28]
[{"$nulls":13},"Rating Area 11",null,29]
[{"$nulls":13},"Rating Area 12",null,30]
[{"$nulls":13},"Rating Area 13",null,31]
[{"$nulls":13},"Rating Area 14",null,32]
[{"$nulls":13},"Rating Area 15",null,33]
[{"$nulls":13},"Rating Area 16",null,34]
[{"$nulls":13},"Rating Area 17",null,35]
[{"$nulls":13},"Rating Area 18",null,36]
[{"$nulls":13},"Rating Area 19",null,37]
[{"$nulls":13},"Rating Area 20",null,38]
[{"$nulls":13},"Rating Area 21",null,39]
[{"$nulls":13},"Rating Area 22",null,40]
[{"$nulls":13},"Rating Area 23",null,41]
[{"$nulls":13},"Rating Area 24",null,42]
[{"$nulls":13},"Rating Area 25",null,43]
[{"$nulls":13},"Rating Area 26",null,44]
[{"$nulls":13},"Rating Area 27",null,45]
[{"$nulls":13},"Rating Area 28",null,46]
[{"$nulls":13},"Rating Area 29",null,47]
[{"$nulls":13},"Rating Area 30",null,48]
[{"$nulls":13},"Rating Area 31",null,49]
[{"$nulls":13},"Rating Area 32",null,50]
[{"$nulls":13},"Rating Area 33",null,51]
[{"$nulls":13},"Rating Area 34",null,52]
[{"$nulls":13},"Rating Area 35",null,53]
[{"$nulls":13},"Rating Area 36",null,54]
[{"$nulls":13},"Rating Area 37",null,55]
[{"$nulls":13},"Rating Area 38",null,56]
[{"$nulls":13},"Rating Area 39",null,57]
[{"$nulls":13},"Rating Area 40",null,58]
[{"$nulls":13},"Rating Area 41",null,59]
[{"$nulls":13},"Rating Area 42",null,60]
[{"$nulls":13},"Rating Area 43",null,61]
[{"$nulls":13},"Rating Area 44",null,62]
[{"$nulls":13},"Rating Area 45",null,63]
[{"$nulls":13},"Rating Area 46",null,64]
[{"$nulls":13},"Rating Area 47",null,"65 and over"]
[{"$nulls":13},"Rating Area 48"]
[{"$nulls":13},"Rating Area 49"]
[{"$nulls":13},"Rating Area 50"]
[{"$nulls":13},"Rating Area 51"]
[{"$nulls":13},"Rating Area 52"]
[{"$nulls":13},"Rating Area 53"]
[{"$nulls":13},"Rating Area 54"]
[{"$nulls":13},"Rating Area 55"]
[{"$nulls":13},"Rating Area 56"]
[{"$nulls":13},"Rating Area 57"]
[{"$nulls":13},"Rating Area 58"]
[{"$nulls":13},"Rating Area 59"]
[{"$nulls":13},"Rating Area 60"]
[{"$nulls":13},"Rating Area 61"]
[{"$nulls":13},"Rating Area 62"]
[{"$nulls":13},"Rating Area 63"]
[{"$nulls":13},"Rating Area 64"]
[{"$nulls":13},"Rating Area 65"]
[{"$nulls":13},"Rating Area 66"]
[{"$nulls":13},"Rating Area 67"]
[{"$nulls":13},"Rating Area 68"]
[{"$nulls":13},"Rating Area 69"]
[{"$nulls":13},"Rating Area 70"]
[{"$nulls":13},"Rating Area 71"]
[{"$nulls":13},"Rating Area 72"]
[{"$nulls":13},"Rating Area 73"]
[{"$nulls":13},"Rating Area 74"]
[{"$nulls":13},"Rating Area 75"]
[{"$nulls":13},"Rating Area 76"]
[{"$nulls":13},"Rating Area 77"]
[{"$nulls":13},"Rating Area 78"]
[{"$nulls":13},"Rating Area 79"]
[{"$nulls":13},"Rating Area 80"]
[{"$nulls":13},"Rating Area 81"]
[{"$nulls":13},"Rating Area 82"]
[{"$nulls":13},"Rating Area 83"]
[{"$nulls":13},"Rating Area 84"]
[{"$nulls":13},"Rating Area 85"]
[{"$nulls":13},"Rating Area 86"]
[{"$nulls":13},"Rating Area 87"]
[{"$nulls":13},"Rating Area 88"]
[{"$nulls":13},"Rating Area 89"]
[{"$nulls":13},"Rating Area 90"]
[{"$nulls":13},"Rating Area 91"]
[{"$nulls":13},"Rating Area 92"]
[{"$nulls":13},"Rating Area 93"]
[{"$nulls":13},"Rating Area 94"]
[{"$nulls":13},"Rating Area 95"]
[{"$nulls":13},"Rating Area 96"]
[{"$nulls":13},"Rating Area 97"]
[{"$nulls":13},"Rating Area 98"]
[{"$nulls":13},"Rating Area 99"]
[{"$nulls":13},"Rating Area 100"]
[{"$nulls":13},"Rating Area 101"]
[{"$nulls":13},"Rating Area 102"]
[{"$nulls":13},"Rating Area 103"]
[{"$nulls":13},"Rating Area 104"]
[{"$nulls":13},"Rating Area 105"]
[{"$nulls":13},"Rating Area 106"]
[{"$nulls":13},"Rating Area 107"]
[{"$nulls":13},"Rating Area 108"]
[{"$nulls":13},"Rating Area 109"]
[{"$nulls":13},"Rating Area 110"]
[{"$nulls":13},"Rating Area 111"]
[{"$nulls":13},"Rating Area 112"]
[{"$nulls":13},"Rating Area 113"]
[{"$nulls":13},"Rating Area 114"]
[{"$nulls":13},"Rating Area 115"]
[{"$nulls":13},"Rating Area 116"]
[{"$nulls":13},"Rating Area 117"]
[{"$nulls":13},"Rating Area 118"]
[{"$nulls":13},"Rating Area 119"]
[{"$nulls":13},"Rating Area 120"]
[{"$nulls":13},"Rating Area 121"]
[{"$nulls":13},"Rating Area 122"]
[{"$nulls":13},"Rating Area 123"]
[{"$nulls":13},"Rating Area 124"]
[{"$nulls":13},"Rating Area 125"]
[{"$nulls":13},"Rating Area 126"]
[{"$nulls":13},"Rating Area 127"]
[{"$nulls":13},"Rating Area 128"]
[{"$nulls":13},"Rating Area 129"]
[{"$nulls":13},"Rating Area 130"]
[{"$nulls":13},"Rating Area 131"]
[{"$nulls":13},"Rating Area 132"]
[{"$nulls":13},"Rating Area 133"]
[{"$nulls":13},"Rating Area 134"]
[{"$nulls":13},"Rating Area 135"]
[{"$nulls":13},"Rating Area 136"]
[{"$nulls":13},"Rating Area 137"]
[{"$nulls":13},"Rating Area 138"]
[{"$nulls":13},"Rating Area 139"]
[{"$nulls":13},"Rating Area 140"]
[{"$nulls":13},"Rating Area 141"]
[{"$nulls":13},"Rating Area 142"]
[{"$nulls":13},"Rating Area 143"]
[{"$nulls":13},"Rating Area 144"]
[{"$nulls":13},"Rating Area 145"]
[{"$nulls":13},"Rating Area 146"]
[{"$nulls":13},"Rating Area 147"]
[{"$nulls":13},"Rating Area 148"]
[{"$nulls":13},"Rating Area 149"]
[{"$nulls":13},"Rating Area 150"]

{"sheet":"EnableMacros","index":1,"n_rows":23,"n_cols":2,"rows_kept":23,"merged":[[0,0,0,15],[1,0,1,15],[2,0,2,15]]}
["Rates Template"]
[]
[]
[]
[]
[null,"If you are seeing this sheet, macros are not enabled, please follow the following steps: "]
[]
[]
[null,"If using Excel 2003:"]
[null,"1. Set the macro security setting to Medium (Recommended) or Low.  To change the macro security setting, select Tools-> "]
[null,"       Macro->Security."]
[null,"2. If the macro security setting is set to Medium, select Enable Macros when opening the workbook."]
[]
[]
[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":"Sheet1","index":2,"n_rows":150,"n_cols":3,"rows_kept":150,"hidden":true}
["Rating Area 1","Tobacco User/Non Tobacco User","Family Option"]
["Rating Area 2","No Preference","0-20"]
["Rating Area 3",null,21]
["Rating Area 4",null,22]
["Rating Area 5",null,23]
["Rating Area 6",null,24]
["Rating Area 7",null,25]
["Rating Area 8",null,26]
["Rating Area 9",null,27]
["Rating Area 10",null,28]
["Rating Area 11",null,29]
["Rating Area 12",null,30]
["Rating Area 13",null,31]
["Rating Area 14",null,32]
["Rating Area 15",null,33]
["Rating Area 16",null,34]
["Rating Area 17",null,35]
["Rating Area 18",null,36]
["Rating Area 19",null,37]
["Rating Area 20",null,38]
["Rating Area 21",null,39]
["Rating Area 22",null,40]
["Rating Area 23",null,41]
["Rating Area 24",null,42]
["Rating Area 25",null,43]
["Rating Area 26",null,44]
["Rating Area 27",null,45]
["Rating Area 28",null,46]
["Rating Area 29",null,47]
["Rating Area 30",null,48]
["Rating Area 31",null,49]
["Rating Area 32",null,50]
["Rating Area 33",null,51]
["Rating Area 34",null,52]
["Rating Area 35",null,53]
["Rating Area 36",null,54]
["Rating Area 37",null,55]
["Rating Area 38",null,56]
["Rating Area 39",null,57]
["Rating Area 40",null,58]
["Rating Area 41",null,59]
["Rating Area 42",null,60]
["Rating Area 43",null,61]
["Rating Area 44",null,62]
["Rating Area 45",null,63]
["Rating Area 46",null,64]
["Rating Area 47",null,"65 and over"]
["Rating Area 48"]
["Rating Area 49"]
["Rating Area 50"]
["Rating Area 51"]
["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"]