Business Help Site

Due Date:
60 days after receipt

BHS Main / Surveys

Tools

Additional Links

Follow the U.S. Census Bureau

About the Excel Workbooks

26.  What are the BRDIS Excel workbooks?

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.

back to category

27.  Do I have to use the Excel workbooks?

No, the BRDIS Excel workbooks are provided by the Census Bureau as an optional tool companies may use to help complete the survey.

back to category

28.  How will the Excel workbooks make completing the BRDIS easier?

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.

back to category

29.  How do I use the BRDIS Excel workbooks?

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.

back to category

30.  What if I need to send a section workbook to more than one part of my company? Is there a way to consolidate/combine information from multiple workbooks for a section?

Yes, an Excel workbook consolidator tool is available to download on the main BRDIS help page: http://bhs.econ.census.gov/bhs/brdis .

back to category

31.  What is the BRDIS Excel consolidator?

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.

back to category

32.  How do I use the BRDIS Excel consolidator?

Please follow the instructions located in the first worksheet of the consolidator file.

back to category

33.  How do I upload data from the Excel files into the online survey?

1. Log in to online survey.
2. Click on “Upload Files”, located at the bottom of the Main Menu screen.
3. Click the “Browse” button in the Open Box to locate desired file(s).
4. Upload one Excel file at a time. Make sure all files uploaded are in .xls format.
5. After uploading is complete, make sure to verify the data in the online survey.

back to category