Rates Table Template

HIOS Issuer ID* 43633. Federal TIN* 00-0000000. Rate Effective Date*. 1/1/2017. Rate Expiration Date*. 12/31/2017. Plan ID*. Rating Area ID*. Tobacco*. Age*.
211KB Größe 6 Downloads 10 vistas
Silver 7110

2017 Rates Table Template v6.0

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 you are I, a and community rating state, Family Option under option Age and fill in allenter. columns. If macros are disabled, press and hold the ALT key and press the F, then then N key. After that, select select the Enable All Content by pressing (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 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 + H. All plans must have the same dates on a sheet. HIOS Issuer ID* 43633 Federal TIN* 00-0000000 Rate Effective Date* Rate Expiration Date*

Plan ID*

Required: Enter the 14-character Plan ID

1/1/2017 12/31/2017

Rating Area ID*

Tobacco*

Required: Select the Rating Area ID

Require: Select if Tobacco use of subscriber is used to determine if a person is eligible for a rate from a plan

43633PR0010003 Rating Area 1

Tobacco User/Non-Tobacco User

43633PR0010003 Rating Area 1

Tobacco User/Non-Tobacco User

43633PR0010003 Rating Area 1

Tobacco User/Non-Tobacco User

43633PR0010003 Rating Area 1

Tobacco User/Non-Tobacco User

43633PR0010003 Rating Area 1

Tobacco User/Non-Tobacco User

43633PR0010003 Rating Area 1

Tobacco User/Non-Tobacco User

43633PR0010003 Rating Area 1

Tobacco User/Non-Tobacco User

43633PR0010003 Rating Area 1

Tobacco User/Non-Tobacco User

43633PR0010003 Rating Area 1

Tobacco User/Non-Tobacco User

43633PR0010003 Rating Area 1

Tobacco User/Non-Tobacco User

43633PR0010003 Rating Area 1

Tobacco User/Non-Tobacco User

43633PR0010003 Rating Area 1

Tobacco User/Non-Tobacco User

43633PR0010003 Rating Area 1

Tobacco User/Non-Tobacco User

43633PR0010003 Rating Area 1

Tobacco User/Non-Tobacco User

43633PR0010003 Rating Area 1

Tobacco User/Non-Tobacco User

43633PR0010003 Rating Area 1

Tobacco User/Non-Tobacco User

43633PR0010003 Rating Area 1

Tobacco User/Non-Tobacco User

43633PR0010003 Rating Area 1

Tobacco User/Non-Tobacco User

43633PR0010003 Rating Area 1

Tobacco User/Non-Tobacco User

43633PR0010003 Rating Area 1

Tobacco User/Non-Tobacco User

43633PR0010003 Rating Area 1

Tobacco User/Non-Tobacco User

43633PR0010003 Rating Area 1

Tobacco User/Non-Tobacco User

43633PR0010003 Rating Area 1

Tobacco User/Non-Tobacco User

43633PR0010003 Rating Area 1

Tobacco User/Non-Tobacco User

43633PR0010003 Rating Area 1

Tobacco User/Non-Tobacco User

43633PR0010003 Rating Area 1

Tobacco User/Non-Tobacco User

43633PR0010003 Rating Area 1

Tobacco User/Non-Tobacco User

43633PR0010003 Rating Area 1

Tobacco User/Non-Tobacco User

43633PR0010003 Rating Area 1

Tobacco User/Non-Tobacco User

43633PR0010003 Rating Area 1

Tobacco User/Non-Tobacco User

43633PR0010003 Rating Area 1

Tobacco User/Non-Tobacco User

43633PR0010003 Rating Area 1

Tobacco User/Non-Tobacco User

43633PR0010003 Rating Area 1

Tobacco User/Non-Tobacco User

43633PR0010003 Rating Area 1

Tobacco User/Non-Tobacco User

43633PR0010003 Rating Area 1

Tobacco User/Non-Tobacco User

43633PR0010003 Rating Area 1

Tobacco User/Non-Tobacco User

43633PR0010003 Rating Area 1

Tobacco User/Non-Tobacco User

43633PR0010003 Rating Area 1

Tobacco User/Non-Tobacco User

43633PR0010003 Rating Area 1

Tobacco User/Non-Tobacco User

43633PR0010003 Rating Area 1

Tobacco User/Non-Tobacco User

43633PR0010003 Rating Area 1

Tobacco User/Non-Tobacco User

43633PR0010003 Rating Area 1

Tobacco User/Non-Tobacco User

43633PR0010003 Rating Area 1

Tobacco User/Non-Tobacco User

43633PR0010003 Rating Area 1

Tobacco User/Non-Tobacco User

43633PR0010003 Rating Area 1

Tobacco User/Non-Tobacco User

43633PR0010003 Rating Area 1

Tobacco User/Non-Tobacco User

Age*

Individual Rate*

Individual Tobacco Rate*

Required: Required: Select the age of a subscriber eligible for the Enter the rate of an Individual Non-Tobacco or rate No Preference enrollee on a plan

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 65 and over

Required: Enter the rate of an Individual tobacco enrollee on a plan

109.35

109.35

172.20

189.42

172.20

189.42

172.20

189.42

172.20

189.42

172.89

190.18

176.33

193.96

180.46

198.51

187.18

205.90

192.69

211.96

195.44

214.98

199.58

219.54

203.71

224.08

206.29

226.92

209.05

229.96

210.43

231.47

211.80

232.98

213.18

234.50

214.56

236.02

217.31

239.04

220.07

242.08

224.20

246.62

228.16

250.98

233.67

257.04

240.56

264.62

248.65

273.52

258.30

284.13

269.14

296.05

281.54

309.69

293.77

323.15

307.54

338.29

321.15

353.27

336.13

369.74

351.28

386.41

367.64

404.40

384.00

422.40

401.74

441.91

419.65

461.62

438.76

482.64

448.23

493.05

467.34

514.07

483.87

532.26

494.72

544.19

508.33

559.16

516.59

568.25

516.59

568.25