Introduces the version compatibility, usage method of Smart Census Import Tool, including enabling macros, using copy and paste functions, using frozen windows, using filter and sorting functions, etc.
This document provides step-by-step instructions for using the Smart Census Import Tool (SCIT) Version 14 to enter and validate group census data for small group and middle market enrollment. It includes setup procedures, data entry guidelines, compatibility notes, and reference tables for state-specific configurations.
The tool requires Excel 2013 or newer and macros to be enabled. Users must save the tool locally, avoid opening multiple instances, and use the AutoFill feature to populate select columns. The guide also explains how to map census data from external spreadsheets and handle specific data formats, such as phone numbers and zip codes with leading zeros.
Version 14 is compatible with Excel 2013 and newer versions.
Use the instructions provided in the Reference section to enable macros.
Update the source document and paste copied data as VALUES into the tool to avoid overwriting Excel formatting.