Welcome - All Locations | |||||||
2015 Report of Organization and/or Annual Survey of Manufactures | |||||||
This spreadsheet allows the input of data using software external to Census Surveyor. | |||||||
Import this data into Census Surveyor using the "Import from Spreadsheet" button. | |||||||
This spreadsheet does not fulfill your reporting obligation. | |||||||
You will need to enter additional data in either the Form or Workbook view for all form types, | |||||||
or export the different form types and import using the "Import from Spreadsheet" button. | |||||||
After completing items on all forms, submit your data to the Census Bureau using the | |||||||
"Submit Responses" button. | |||||||
The Data Dictionary (next tab) includes the Data Element Names that Census Surveyor uses to import data. | |||||||
The Data Dictionary may be printed for convenience to outline the Data Element Names listed on the next tab. | |||||||
Columns of the spreadsheet can be deleted or reordered, and the remaining data will import into Census Surveyor. | |||||||
Do not modify the Data Element Names in the first row of the data tab. | |||||||
Census Surveyor uses the Data Element Names to link the data from this spreadsheet. | |||||||
Do not modify prelisted values for FORM_MAILED and RECORD_CFN. | |||||||
It is recommended that you add locations prior to exporting to a spreadsheet. | |||||||
To add locations after exporting: | |||||||
Data for new locations should be entered into blank rows. It is important to enter a Form Number | |||||||
(FORM_MAILED) of NC-99001(L) and unique Census File Number (RECORD_CFN) for each new location. | |||||||
Use the following 10-character format for RECORD_CFN: ADD_000001, ADD_000002, ADD_000003, etc. | |||||||
For additional information: | |||||||
Call: 1-800-838-2640, between 8:00 a.m. and 4:30 p.m., Eastern time, Monday through Friday. | |||||||
To add establishments to NC-99001(L) - | |||||||
use Major Activity Code, ADD_MAJOR_ACT_CODE, from Item 5B: | |||||||
01 - Agricultural production | |||||||
02 - Agricultural services | |||||||
03 - Minerals extraction/ore processing | |||||||
04 - Mining services/oil and gas field services | |||||||
05 - Utilities | |||||||
06 - Construction | |||||||
07 - Manufacturing | |||||||
08 - Merchant wholesaler | |||||||
09 - Commission merchant/broker/agent/electronic marketer (business to business) | |||||||
10 - Manufacturers' sale branch/manufacturers' sales office | |||||||
11 - Retail | |||||||
12 - Transportation/public warehousing | |||||||
13 - Information services/publishing/telecommunications | |||||||
14 - Finance/insurance | |||||||
15 - Real estate/renting/leasing | |||||||
16 - Professional/scientific/technical service | |||||||
17 - Waste management/remediation service/administrative/support service | |||||||
18 - Educational service | |||||||
19 - Health care | |||||||
20 - Social assistance | |||||||
21 - Arts/entertainment/recreation | |||||||
22 - Accommodation/food service | |||||||
23 - Corporate/subsidiary/regional/managing office | |||||||
24 - Other | |||||||
Data Dictionary for All Locations | ||
Row 1 - Data Element Name | Row 2 - Data Element Description | Row 3 - Data Element Characteristic |
@RECORD_CFN | *CFN (census file number) - Unique identifier used for exporting and importing data | *Do not modify prelisted CFN |
@RECORD_STORENUM | *Store/Plant - Enter corrections to prelisted store/plant number | *Maximum length is 12 characters |
@RECORD_NAME1 | Name 1 - Enter corrections to prelisted Name 1 | Maximum length is 36 characters |
@RECORD_NAME2 | Name 2 - Enter corrections to prelisted Name 2 | Maximum length is 36 characters |
@ADDR_STREET | Street - Enter corrections to prelisted street address | Maximum length is 36 characters |
@ADDR_CITY | City - Enter corrections to prelisted city | Maximum length is 20 characters |
@ADDR_ST | State - Enter corrections to prelisted state | Use 2-letter state abbreviation |
@ADDR_ZIP | ZIP Code - Enter corrections to prelisted ZIP Code | Use 5- or 9-digit ZIP Code |
@EIN_NUM | EIN (Employer Identification Number) - Enter corrections to prelisted EIN | Enter 9-digit EIN |
@PHYSLOC_ADDR | Is this establishment's physical location the same as the mailing address (ADDR_STREET, ADDR_CITY, ADDR_ST, ADDR_ZIP)? | 1=Yes; 2=No |
@PHYSLOC_ADDR_STREET | If PHYSLOC_ADDR is No - Enter the physical location number and street address | Maximum length is 36 characters |
@PHYSLOC_ADDR_CITY | If PHYSLOC_ADDR is No - Enter the physical location city, town, village, etc. | Maximum length is 20 characters |
@PHYSLOC_ADDR_ST | If PHYSLOC_ADDR is No - Enter the physical location state | Use 2-letter state abbreviation |
@PHYSLOC_ADDR_ZIP | If PHYSLOC_ADDR is No - Enter the physical location ZIP Code | Use 5- or 9-digit ZIP Code |
@PHYSLOC_LGL | Is this establishment physically located inside the legal boundaries of the city, town, village, etc.? | 1=Yes; 2=No; 3=No legal boundaries; 4=Do not know |
@PHYSLOC_MUNI | In what type of municipality is this establishment physically located? | 1=City, village, or borough; 2=Town or township; 3=Other; 4=Do not know |
@OPSTAT | Which best describes this establishment's operational status at the end of 2015? | 1=In operation; 2=Temporarily inactive; 3=Ceased operation; 4=Sold/Leased to another operator; 5=Other or under construction |
@OPSTAT_DATE | Date - Enter date for ceased or sold/leased establishments | Use MMDDYYYY format |
@OPSTAT_NAME | Name of new owner or operator - Enter new owner name for sold/leased establishments | Maximum length is 36 characters |
@OPSTAT_ADDR_STREET | Mailing address - Enter new owner number and street (P.O. Box, etc.) address for sold/leased establishments | Maximum length is 36 characters |
@OPSTAT_ADDR_CITY | City, town, village, etc. - Enter new owner city, town, village, etc. for sold/leased establishments | Maximum length is 20 characters |
@OPSTAT_ADDR_STATE | State - Enter new owner state for sold/leased establishments | Use 2-letter state abbreviation |
@OPSTAT_ADDR_ZIP | ZIP Code - Enter new owner ZIP Code for sold/leased establishments | Use 5- or 9-digit ZIP Code |
@ACTV_MIO | Number of months in operation during 2015 | Enter 0-12 |
@EMP_MAR12 | Number of employees for pay period including March 12, 2015 | Enter number - Enter '0' for None |
@PAY_ANN | 2015 Annual payroll before deductions (Exclude employer's cost for fringe benefits.) | Report in thousands - Enter '0' for None |
@PAY_QTR1 | First quarter payroll before deductions (January-March, 2015) (Exclude employer's cost for fringe benefits.) | Report in thousands - Enter '0' for None |
@ADD_MAJOR_ACT_CODE | NC-99001(L), Item 5B, column (c1): Code - Enter code from the Major Activity Codes list from the Welcome tab or Item 5B | Enter 2-digit Major Activity Code from NC-99001(L), Item 5B |
@FORM_MAILED | @RECORD_CFN | @RECORD_STORENUM | @RECORD_NAME1 | @RECORD_NAME2 | @ADDR_STREET | @ADDR_CITY | @ADDR_ST | @ADDR_ZIP | @EIN_NUM | @PHYSLOC_ADDR | @PHYSLOC_ADDR_STREET | @PHYSLOC_ADDR_CITY | @PHYSLOC_ADDR_ST | @PHYSLOC_ADDR_ZIP | @PHYSLOC_LGL | @PHYSLOC_MUNI | @OPSTAT | @OPSTAT_DATE | @OPSTAT_NAME | @OPSTAT_ADDR_STREET | @OPSTAT_ADDR_CITY | @OPSTAT_ADDR_STATE | @OPSTAT_ADDR_ZIP | @ACTV_MIO | @EMP_MAR12 | @PAY_ANN | @PAY_QTR1 | @ADD_MAJOR_ACT_CODE |
*Form Number | *CFN (census file number) - Unique identifier used for exporting and importing data | *Store/Plant - Enter corrections to prelisted store/plant number | Name 1 - Enter corrections to prelisted Name 1 | Name 2 - Enter corrections to prelisted Name 2 | Street - Enter corrections to prelisted street address | City - Enter corrections to prelisted city | State - Enter corrections to prelisted state | ZIP Code - Enter corrections to prelisted ZIP Code | EIN (Employer Identification Number) - Enter corrections to prelisted EIN | Is this establishment's physical location the same as the mailing address (ADDR_STREET, ADDR_CITY, ADDR_ST, ADDR_ZIP)? | If PHYSLOC_ADDR is No - Enter the physical location number and street address | If PHYSLOC_ADDR is No - Enter the physical location city, town, village, etc. | If PHYSLOC_ADDR is No - Enter the physical location state | If PHYSLOC_ADDR is No - Enter the physical location ZIP Code | Is this establishment physically located inside the legal boundaries of the city, town, village, etc.? | In what type of municipality is this establishment physically located? | Which best describes this establishment's operational status at the end of 2015? | Date - Enter date for ceased or sold/leased establishments | Name of new owner or operator - Enter new owner name for sold/leased establishments | Mailing address - Enter new owner number and street (P.O. Box, etc.) address for sold/leased establishments | City, town, village, etc. - Enter new owner city, town, village, etc. for sold/leased establishments | State - Enter new owner state for sold/leased establishments | ZIP Code - Enter new owner ZIP Code for sold/leased establishments | Number of months in operation during 2015 | Number of employees for pay period including March 12, 2015 | 2015 Annual payroll before deductions (Exclude employer's cost for fringe benefits.) | First quarter payroll before deductions (January-March, 2015) (Exclude employer's cost for fringe benefits.) | NC-99001(L), Item 5B, column (c1): Code - Enter code from the Major Activity Codes list from the Welcome tab or Item 5B |
*Do not move column or modify prelisted form number | *Do not modify prelisted CFN | *Maximum length is 12 characters | Maximum length is 36 characters | Maximum length is 36 characters | Maximum length is 36 characters | Maximum length is 20 characters | Use 2-letter state abbreviation | Use 5- or 9-digit ZIP Code | Enter 9-digit EIN | 1=Yes; 2=No | Maximum length is 36 characters | Maximum length is 20 characters | Use 2-letter state abbreviation | Use 5- or 9-digit ZIP Code | 1=Yes; 2=No; 3=No legal boundaries; 4=Do not know | 1=City, village, or borough; 2=Town or township; 3=Other; 4=Do not know | 1=In operation; 2=Temporarily inactive; 3=Ceased operation; 4=Sold/Leased to another operator; 5=Other or under construction | Use MMDDYYYY format | Maximum length is 36 characters | Maximum length is 36 characters | Maximum length is 20 characters | Use 2-letter state abbreviation | Use 5- or 9-digit ZIP Code | Enter 0-12 | Enter number - Enter '0' for None | Report in thousands - Enter '0' for None | Report in thousands - Enter '0' for None | Enter 2-digit Major Activity Code from NC-99001(L), Item 5B |
MA-10000(L) | 7000012015 | 1 | Test Example 1 | Street Address 1 | Milford | MA | 01757-1234 | 12-3456789 | Street Address 9 | Milford | MA | 01757-1234 | ||||||||||||||||
NC-99001(L) | 7000042015 | 4 | Test Example 4 | Street Address 4 | Milford | MA | 01757-1234 | 12-3456789 | ||||||||||||||||||||
NC-99001(L) | 7000052015 | 5 | Test Example 5 | Street Address 5 | Akron | OH | 44312 | 12-3456789 | ||||||||||||||||||||
NC-99001(L) | 7000062015 | 6 | Test Example 6 | Street Address 6 | Culpepper | VA | 22701 | 12-3456789 | ||||||||||||||||||||
NC-99001(L) | ADD_500003 | |||||||||||||||||||||||||||
NC-99001(L) | ADD_500004 | |||||||||||||||||||||||||||
NC-99001(L) | ADD_500005 | |||||||||||||||||||||||||||
NC-99001(S) | ADD_500006 | |||||||||||||||||||||||||||
NC-99001(S) | ADD_500007 | |||||||||||||||||||||||||||
NC-99001(S) | ADD_500008 | |||||||||||||||||||||||||||
MA-10000(L) | ADD_500001 | |||||||||||||||||||||||||||
MA-10000(L) | ADD_500002 |
File Type | application/vnd.openxmlformats-officedocument.spreadsheetml.sheet |
File Modified | 0000-00-00 |
File Created | 0000-00-00 |