The Excel workbooks are electronic versions of the paper survey form. These files allow respondents to email sections of the survey within their company to collect information that is not centrally available. These files can also be used to upload survey data into Census.s online survey, Centurion. There are seven workbooks, one for each survey section.
No, the BRDIS Excel workbooks are provided by the Census Bureau as an optional tool companies may use to help complete the survey.
The Excel workbooks make it easier to collect data needed to complete the survey. Each survey section has an Excel version that can be downloaded and emailed to appropriate persons within your company. Each Excel workbook is designed to carry forward applicable answers throughout the survey section that is being completed. This allows questions to reference your answers to previous questions in the section, making it easier to understand how questions are related to each other. The Excel spreadsheets also check for imbalances between detail and total values. This will make it easier for you to know when there is an arithmetic mistake.
Send workbooks to appropriate individuals within company. For example, if you do not have access to Human Resources records you could email the excel workbook for Section 5: Human Resources to a contact in your company.s HR department. When the survey sections are returned to you, you can review the information and upload the data directly into the online survey. The data from the Excel files will be mapped to the correct questions in the online survey.
Yes, an Excel workbook consolidator tool is available to download on the main BRDIS help page: http://bhs.econ.census.gov/bhs/brdis .
The BRDIS Excel consolidator is a tool that will consolidate data from multiple BRDIS Excel workbooks so that the consolidated information can be uploaded into the online survey.
Please follow the instructions located in the first worksheet of the consolidator file.