Rate Models for Brokers in North and South Carolina

Downloading these files

NOTE: These files are password protected. If you have not received a password, please contact us at 800.227.4918 or email us at carolinassg@cigna.com.

Use the links below to access the CIGNA HealthCare Small Group Rate Models for North and South Carolina. You will be prompted to save the excel file to your hard drive. If you receive a prompt about Macros, please choose "Enable Macros."

Please be patient as these files may take a little longer to download than they do to open. Please right-click on the links above and choose "Save Target As" (Microsoft Internet Explorer) or "Save Link As" (Netscape Navigator) to save the rate model to your hard drive.

CIGNA SC SG Rating Model v10.01 for cases effective 1/1/2010 through 3/31/2010
Detailed directions for pricing model

CIGNA NC SG Rating Model v10.01 for cases effective 1/1/2010 through 3/31/2010
Detailed directions for pricing model

CIGNA SC SG Rating Model v9.06 for cases effective 10/1/2009 through 12/31/2009
Detailed directions for pricing model

CIGNA NC SG Rating Model v9.06 for cases effective 10/1/2009 through 12/31/2009
Detailed directions for pricing model

Opening these files
NOTE: Your security setting in excel must be set to "Medium" or "Low". If they are set to "High" the macros will not work, which means that none of the features that allow rates to be run will be active.

Security Settings in Excel
To set your security in Excel to "medium".

Close the rate model, if already open. Do not save. Open a blank Excel spreadsheet by opening Excel from your Start menu, and selecting "File" then "New". Go to the "Tools" menu and choose "Options". Depending on the version of Excel you have, the security settings may be in different areas.

In Excel ‘97, you’ll go to the "General" tab and uncheck "Macro Virus Protection".
In later versions, there should be a "Security" tab.
On the security tab, look for either a choice between "Low", "Medium" and "High" security, or a button that mentions security or macro settings. If it is a button, click on it and choose "Medium".
Once you’ve changed that setting, click "OK" or until the window goes away.
Close Excel then re–open it to activate the change.

Once the settings have been changed, you can open up the rate model and you will be asked if you want to "Enable" macros. Click "Yes".

If you have any questions, feel free to call us at 800.227.4918 or email us at carolinassg@cigna.