Not registered? Sign up to enjoy secure access to personalized information.Register Now
Access personalized services and information.
Find a Doctor
Search our provider directory when you need a doctor, hospital, pharmacy or other health care provider.
Health & Wellness
A total-health solution that surrounds everyone with the help they need to live healthier, feel better and save money doing it.
Electronic Census Sheet
Download the blank census sheet to a disk and run a virus scan to ensure the integrity of the file. Depending on your web browser, you may need to right-mouse-click on the link and specify "Save Target As" to save the file.
Open the spreadsheet cencalc.xls
using Excel. You're ready to enter data.
| GROUP NAME |
Enter the GROUP NAME.
| PLAN NAME |
Enter PLAN NAME, for example, ConnecticutCare HMO.
| PLAN TYPE |
Enter PLAN TYPE, for example, HMO, POS, PPO.
| EFFECTIVE DATE |
Please enter the effective date of coverage. The census sheet will automatically calculate the employee's age.
| DOB |
Enter Date of Birth. The member's age will be calculated and displayed on the census sheet.
| M/F |
Enter the member's gender.
| Contract Class |
Enter the following codes:
1 = Employee only
2 = Employee and spouse
3 = Employee, spouse and child(ren)
4 = Employee and child(ren)
| ZIP CODE |
Enter the zip code. As soon as the zip code is entered, the state will appear in column 4.
Formatting Makes the Difference
All of the columns except for the DOB column have been text formatted to accept data. The DOB column has been date formatted. This formatting allows us to process your information faster - without keying in data - ensuring the accuracy of the quote. If you decide to use your own spreadsheet, you can submit it to us. We ask that you use these formatting guidelines to minimize the need for our staff to re-key data.
Submitting the Census
Whether or not you use our census sheet, you can submit your files electronically to your Anthem Blue Cross and Blue Shield sales representative. We have found that it may take up to five business days to receive information by mail. Once we've received it, depending on the number of individuals on the census, it can take up to ten business days to re-enter the data and check it. Use our Internet address to send your completed census sheet to an Anthem Blue Cross and Blue Shield sales representative. By using this format, firstname.lastname@example.org, your census will be here within minutes of transmission.
We'll gladly assist you and your staff when using this census sheet. Just give us a call.