Rates Table Template v2.3
To validate press Validate button or Ctrl + Shift + V. To finalize, press Finalize button or Ctrl + Shift + F. 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.
32901 66-0555677 1/1/2017 12/31/2017
HIOS Issuer ID* Federal TIN* Rate Effective Date* Rate Expiration Date*
Plan ID*
Rating Area ID*
Required: Enter the 14-character Plan ID
Required: Select the Rating Area ID
TS Directo Plata 1 (1/2017)
Rating Area 1
TS Directo Plata 1 (1/2017)
Rating Area 1
TS Directo Plata 1 (1/2017)
Rating Area 1
TS Directo Plata 1 (1/2017)
Rating Area 1
TS Directo Plata 1 (1/2017)
Rating Area 1
TS Directo Plata 1 (1/2017)
Rating Area 1
TS Directo Plata 1 (1/2017)
Rating Area 1
TS Directo Plata 1 (1/2017)
Rating Area 1
TS Directo Plata 1 (1/2017)
Rating Area 1
TS Directo Plata 1 (1/2017)
Rating Area 1
TS Directo Plata 1 (1/2017)
Rating Area 1
TS Directo Plata 1 (1/2017)
Rating Area 1
TS Directo Plata 1 (1/2017)
Rating Area 1
TS Directo Plata 1 (1/2017)
Rating Area 1
TS Directo Plata 1 (1/2017)
Rating Area 1
TS Directo Plata 1 (1/2017)
Rating Area 1
TS Directo Plata 1 (1/2017)
Rating Area 1
TS Directo Plata 1 (1/2017)
Rating Area 1
TS Directo Plata 1 (1/2017)
Rating Area 1
TS Directo Plata 1 (1/2017)
Rating Area 1
TS Directo Plata 1 (1/2017)
Rating Area 1
TS Directo Plata 1 (1/2017)
Rating Area 1
TS Directo Plata 1 (1/2017)
Rating Area 1
TS Directo Plata 1 (1/2017)
Rating Area 1
TS Directo Plata 1 (1/2017)
Rating Area 1
TS Directo Plata 1 (1/2017)
Rating Area 1
TS Directo Plata 1 (1/2017)
Rating Area 1
TS Directo Plata 1 (1/2017)
Rating Area 1
TS Directo Plata 1 (1/2017)
Rating Area 1
TS Directo Plata 1 (1/2017)
Rating Area 1
TS Directo Plata 1 (1/2017)
Rating Area 1
TS Directo Plata 1 (1/2017)
Rating Area 1
TS Directo Plata 1 (1/2017)
Rating Area 1
TS Directo Plata 1 (1/2017)
Rating Area 1
TS Directo Plata 1 (1/2017)
Rating Area 1
TS Directo Plata 1 (1/2017)
Rating Area 1
TS Directo Plata 1 (1/2017)
Rating Area 1
TS Directo Plata 1 (1/2017)
Rating Area 1
TS Directo Plata 1 (1/2017)
Rating Area 1
TS Directo Plata 1 (1/2017)
Rating Area 1
TS Directo Plata 1 (1/2017)
Rating Area 1
TS Directo Plata 1 (1/2017)
Rating Area 1
TS Directo Plata 1 (1/2017)
Rating Area 1
TS Directo Plata 1 (1/2017)
Rating Area 1
TS Directo Plata 1 (1/2017)
Rating Area 1
Tobacco*
Age*
Require: Required: Select if Tobacco use of subscriber is Select the age of a subscriber eligible used to determine if a person is eligible for the rate for a rate from a plan
Tobacco User/NonTobacco User Tobacco User/NonTobacco User Tobacco User/NonTobacco User Tobacco User/NonTobacco User Tobacco User/NonTobacco User Tobacco User/NonTobacco User Tobacco User/NonTobacco User Tobacco User/NonTobacco User Tobacco User/NonTobacco User Tobacco User/NonTobacco User Tobacco User/NonTobacco User Tobacco User/NonTobacco User Tobacco User/NonTobacco User Tobacco User/NonTobacco User Tobacco User/NonTobacco User Tobacco User/NonTobacco User Tobacco User/NonTobacco User Tobacco User/NonTobacco User Tobacco User/NonTobacco User Tobacco User/NonTobacco User Tobacco User/NonTobacco User Tobacco User/NonTobacco User Tobacco User/NonTobacco User Tobacco User/NonTobacco User Tobacco User/NonTobacco User Tobacco User/NonTobacco User Tobacco User/NonTobacco User Tobacco User/NonTobacco User Tobacco User/NonTobacco User Tobacco User/NonTobacco User Tobacco User/NonTobacco User Tobacco User/NonTobacco User Tobacco User/NonTobacco User Tobacco User/NonTobacco User Tobacco User/NonTobacco User Tobacco User/NonTobacco User Tobacco User/NonTobacco User Tobacco User/NonTobacco User Tobacco User/NonTobacco User Tobacco User/NonTobacco User Tobacco User/NonTobacco User Tobacco User/NonTobacco User Tobacco User/NonTobacco User Tobacco User/NonTobacco User Tobacco User/NonTobacco User
0-20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 and Older
Individual Rate*
Individual Tobacco Rate*
Required: Enter the rate of an Individual NonTobacco or No Preference enrollee on a plan
Required: Enter the rate of an Individual tobacco enrollee on a plan
84.68
84.68
133.35
133.35
133.35
133.35
133.35
133.35
133.35
133.35
133.89
133.89
136.55
136.55
139.76
139.76
144.96
144.96
149.22
149.22
151.36
151.36
154.56
154.56
157.76
157.76
159.76
159.76
161.89
161.89
162.96
162.96
164.03
164.03
165.09
165.09
166.16
166.16
168.29
168.29
170.43
170.43
173.63
173.63
176.69
176.69
180.96
180.96
186.30
186.30
192.56
192.56
200.03
200.03
208.43
208.43
218.03
218.03
227.50
227.50
238.17
238.17
248.71
248.71
260.31
260.31
272.04
272.04
284.71
284.71
297.38
297.38
311.11
311.11
324.98
324.98
339.79
339.79
347.12
347.12
361.92
361.92
374.72
374.72
383.13
383.13
393.66
393.66
400.06
400.06
Rates Table Template v2.3
To validate press Validate button or Ctrl + Shift + V. To finalize, press Finalize button or Ctrl + Shift + F. 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.
32901 66-0555677 1/1/2017 12/31/2017
HIOS Issuer ID* Federal TIN* Rate Effective Date* Rate Expiration Date*
Plan ID*
Rating Area ID*
Required: Enter the 14-character Plan ID
Required: Select the Rating Area ID
TS Directo Plata 2 (1/2017)
Rating Area 1
TS Directo Plata 2 (1/2017)
Rating Area 1
TS Directo Plata 2 (1/2017)
Rating Area 1
TS Directo Plata 2 (1/2017)
Rating Area 1
TS Directo Plata 2 (1/2017)
Rating Area 1
TS Directo Plata 2 (1/2017)
Rating Area 1
TS Directo Plata 2 (1/2017)
Rating Area 1
TS Directo Plata 2 (1/2017)
Rating Area 1
TS Directo Plata 2 (1/2017)
Rating Area 1
TS Directo Plata 2 (1/2017)
Rating Area 1
TS Directo Plata 2 (1/2017)
Rating Area 1
TS Directo Plata 2 (1/2017)
Rating Area 1
TS Directo Plata 2 (1/2017)
Rating Area 1
TS Directo Plata 2 (1/2017)
Rating Area 1
TS Directo Plata 2 (1/2017)
Rating Area 1
TS Directo Plata 2 (1/2017)
Rating Area 1
TS Directo Plata 2 (1/2017)
Rating Area 1
TS Directo Plata 2 (1/2017)
Rating Area 1
TS Directo Plata 2 (1/2017)
Rating Area 1
TS Directo Plata 2 (1/2017)
Rating Area 1
TS Directo Plata 2 (1/2017)
Rating Area 1
TS Directo Plata 2 (1/2017)
Rating Area 1
TS Directo Plata 2 (1/2017)
Rating Area 1
TS Directo Plata 2 (1/2017)
Rating Area 1
TS Directo Plata 2 (1/2017)
Rating Area 1
TS Directo Plata 2 (1/2017)
Rating Area 1
TS Directo Plata 2 (1/2017)
Rating Area 1
TS Directo Plata 2 (1/2017)
Rating Area 1
TS Directo Plata 2 (1/2017)
Rating Area 1
TS Directo Plata 2 (1/2017)
Rating Area 1
TS Directo Plata 2 (1/2017)
Rating Area 1
TS Directo Plata 2 (1/2017)
Rating Area 1
TS Directo Plata 2 (1/2017)
Rating Area 1
TS Directo Plata 2 (1/2017)
Rating Area 1
TS Directo Plata 2 (1/2017)
Rating Area 1
TS Directo Plata 2 (1/2017)
Rating Area 1
TS Directo Plata 2 (1/2017)
Rating Area 1
TS Directo Plata 2 (1/2017)
Rating Area 1
TS Directo Plata 2 (1/2017)
Rating Area 1
TS Directo Plata 2 (1/2017)
Rating Area 1
TS Directo Plata 2 (1/2017)
Rating Area 1
TS Directo Plata 2 (1/2017)
Rating Area 1
TS Directo Plata 2 (1/2017)
Rating Area 1
TS Directo Plata 2 (1/2017)
Rating Area 1
TS Directo Plata 2 (1/2017)
Rating Area 1
Tobacco*
Age*
Require: Required: Select if Tobacco use of subscriber is Select the age of a subscriber eligible used to determine if a person is eligible for the rate for a rate from a plan
Tobacco User/NonTobacco User Tobacco User/NonTobacco User Tobacco User/NonTobacco User Tobacco User/NonTobacco User Tobacco User/NonTobacco User Tobacco User/NonTobacco User Tobacco User/NonTobacco User Tobacco User/NonTobacco User Tobacco User/NonTobacco User Tobacco User/NonTobacco User Tobacco User/NonTobacco User Tobacco User/NonTobacco User Tobacco User/NonTobacco User Tobacco User/NonTobacco User Tobacco User/NonTobacco User Tobacco User/NonTobacco User Tobacco User/NonTobacco User Tobacco User/NonTobacco User Tobacco User/NonTobacco User Tobacco User/NonTobacco User Tobacco User/NonTobacco User Tobacco User/NonTobacco User Tobacco User/NonTobacco User Tobacco User/NonTobacco User Tobacco User/NonTobacco User Tobacco User/NonTobacco User Tobacco User/NonTobacco User Tobacco User/NonTobacco User Tobacco User/NonTobacco User Tobacco User/NonTobacco User Tobacco User/NonTobacco User Tobacco User/NonTobacco User Tobacco User/NonTobacco User Tobacco User/NonTobacco User Tobacco User/NonTobacco User Tobacco User/NonTobacco User Tobacco User/NonTobacco User Tobacco User/NonTobacco User Tobacco User/NonTobacco User Tobacco User/NonTobacco User Tobacco User/NonTobacco User Tobacco User/NonTobacco User Tobacco User/NonTobacco User Tobacco User/NonTobacco User Tobacco User/NonTobacco User
0-20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 and Older
Individual Rate*
Individual Tobacco Rate*
Required: Enter the rate of an Individual NonTobacco or No Preference enrollee on a plan
Required: Enter the rate of an Individual tobacco enrollee on a plan
88.93
88.93
140.05
140.05
140.05
140.05
140.05
140.05
140.05
140.05
140.62
140.62
143.42
143.42
146.78
146.78
152.24
152.24
156.72
156.72
158.96
158.96
162.32
162.32
165.68
165.68
167.79
167.79
170.03
170.03
171.15
171.15
172.27
172.27
173.39
173.39
174.51
174.51
176.75
176.75
178.99
178.99
182.35
182.35
185.57
185.57
190.05
190.05
195.66
195.66
202.24
202.24
210.08
210.08
218.91
218.91
228.99
228.99
238.93
238.93
250.14
250.14
261.20
261.20
273.39
273.39
285.71
285.71
299.02
299.02
312.32
312.32
326.75
326.75
341.31
341.31
356.86
356.86
364.56
364.56
380.11
380.11
393.55
393.55
402.38
402.38
413.44
413.44
420.16
420.16