Air Resources Board, P.O. Box 2815 – Sacramento, CA 95812 – Attention: Stationary Source Division, Measures Assessment Branch
Phone: 916.324.8023 / FAX: 916.324.8026 /
ARB 2005 Architectural Coating Survey - Electronic Submittal in Text or ASCII Format
Thank you for submitting your survey data in an electronic format!
To submit your data in text (*.txt) or ASCII (*.asc) form, please prepare three comma-delimited electronic files that contain fields in the order indicated below. Remember that commas should only be used to separate fields; no commas should be used within a field (e.g. enter addresses as “Main Street Suite 100”, rather than “Main Street,Suite 100”.) A carriage return must be located at the end of each line. For blank text fields, please insert “N/A”, instead of leaving a blank space between commas. For blank numeric fields, please insert a zero. Detailed instructions for completing the survey can be found in the ARB survey package.
Step 1: Create a Form 1 file for Company Information with data in the following order, separated by commas.
For Example –
Paint Company Inc., Division,1234 Main St. Suite 100,Anytown,CA,12345-0000,John Doe,Environmental Manager,
(000) 555-1212,(000) 555-2222,,Yes,No,No,Yes,No,No,No,N/A,No,Yes,No,N/A,No,No,Chemical Co. Inc.,5678 Avenue A,,Bigtown,TX,67890-1111,Jane Doe,Corporate Health & Safety Manager,(000) 555-1212,No,No,No,No,Yes,No,No,No,No,No,Yes,No,No,No,No,No, No,Yes,No,No,No,No,No,No,No,No,No,No,Yes,No,No,Yes,No,No,No,Yes,No,No,No,No,Yes,No,No,No,N/A,N/A
Descriptions of the field names, data types, and field lengths are provided below.
Field Name / Description / Field Type 1 / Field Length / ExampleCompany Name / Company Name / Text / 75 / Paint Company Inc.
Web Site / Company's Website Address / Text / 75 /
Co Division / Company Division Name / Text / 50 / Architectural Division
Co Address / Company Address / Text / 75 / 1234 Main St. Suite 100
Co City / Company City / Text / 35 / Anytown
Co State / Company State / Text / 2 / CA
Co Zip / Company Zip Code / Text / 10 / 12345-0000
Co Contact / Company Point of Contact / Text / 30 / John Doe
Title / Title for Company Point of Contact / Text / 45 / Environmental Manager
Phone / Phone Number for Company Point of Contact / Text / 20 / (000) 555-1212
FAX / FAX Number for Company Point of Contact / Text / 20 / (000) 555-2222
Email / E-Mail address for Company Point of Contact / Text / 40 /
Mfr / Type of Business = Manufacturer? (Yes/No) / Yes/No / Yes
Import / Type of Business = Importer? (Yes/No) / Yes/No / No
Retail / Type of Business = Retail Distributor? (Yes/No) / Yes/No / No
Wholesale / Type of Business = Wholesale Distributor (Yes/No) / Yes/No / Yes
Pvt Label / Type of Business = Private Label Manufacturer (Yes/No) / Yes/No / No
Toll / Type of Business = Toll Manufacturer? (Yes/No) / Yes/No / No
Bus-Other / Type of Business = Other? (Yes/No) / Yes/No / No
Bus-OtherDesc / Describe "Other" Type of Business / Text / 50 / N/A
Intl / Marketing Classification = International? (Yes/No) / Yes/No / No
Natl / Marketing Classification = National? (Yes/No) / Yes/No / Yes
Regional_YN / Marketing Classification = Regional? (Yes/No) / Yes/No / No
Regional / Describe "Regional" Marketing Classification (e.g., Western U.S.) / Text / 15 / N/A
CA State / Marketing Classification = California Statewide (Yes/No) / Yes/No / No
CA Local / Marketing Classification = California Local (Yes/No) / Yes/No / No
Parent Company / Parent Company Name / Text / 75 / Chemical Co. Inc.
Parent Address / Parent Company Address / Text / 75 / 5678 Avenue A
Parent City / Parent Company City / Text / 35 / Bigtown
Parent State / Parent Company State / Text / 2 / TX
Parent Zip / Parent Company Zip Code / Text / 10 / 67890-1111
Parent Contact / Parent Company Point of Contact / Text / 30 / Jane Doe
Parent Title / Title for Parent Company Point of Contact / Text / 45 / Corporate Health & Safety Manager
Parent Phone / Phone Number for Parent Company Point of Contact / Text / 20 / (000) 555-1212
Gross All-500 / Gross Receipts for CY2004, Company Wide - Less than $500,000 (Yes/No) / Yes/No / No
Gross All-1mil / Gross Receipts for CY2004, Company Wide - Between $500,000 and < $1 million (Yes/No) / Yes/No / No
Gross All-2mil / Gross Receipts for CY2004, Company Wide - Between $1 million and < $2 million (Yes/No) / Yes/No / No
Gross All-5mil / Gross Receipts for CY2004, Company Wide - Between $2 million and < $5 million (Yes/No) / Yes/No / No
Gross All-10mil / Gross Receipts for CY2004, Company Wide - Between $5 million and < $10 million (Yes/No) / Yes/No / Yes
Gross All-100mil / Gross Receipts for CY2004, Company Wide - Between $10 million and < $100 million (Yes/No) / Yes/No / No
Gross All-1bil / Gross Receipts for CY2004, Company Wide - Between $100 million and < $1 billion (Yes/No) / Yes/No / No
Gross All->1bil / Gross Receipts for CY2004, Company Wide - Greater than or equal to $1 billion (Yes/No) / Yes/No / No
Gross CA Co-500 / Gross Receipts for CY2004, CA Company Only - Less than $500,000 (Yes/No) / Yes/No / No
Gross CA Co-1mil / Gross Receipts for CY2004, CA Company Only - Between $500,000 and < $1 million (Yes/No) / Yes/No / No
Gross CA Co-2mil / Gross Receipts for CY2004, CA Company Only - Between $1 million and < $2 million (Yes/No) / Yes/No / Yes
Gross CA Co-5mil / Gross Receipts for CY2004, CA Company Only - Between $2 million and < $5 million (Yes/No) / Yes/No / No
Gross CA Co-10mil / Gross Receipts for CY2004, CA Company Only - Between $5 million and < $10 million (Yes/No) / Yes/No / No
Gross CA Co-100mil / Gross Receipts for CY2004, CA Company Only - Between $10 million and < $100 million (Yes/No) / Yes/No / No
Gross CA Co-1bil / Gross Receipts for CY2004, CA Company Only - Between $100 million and < $1 billion (Yes/No) / Yes/No / No
Gross CA Co->1bil / Gross Receipts for CY2004, CA Company Only - Greater than or equal to $1 billion (Yes/No) / Yes/No / No
Gross CA coatdiv-500 / Gross Receipts for CY2004, CA Coatings Division Only - Less than $500,000 (Yes/No) / Yes/No / No
Gross CA coatdiv-1mil / Gross Receipts for CY2004, CA Coatings Division Only - Between $500,000 and < $1 million (Yes/No) / Yes/No / Yes
Gross CA coatdiv-2mil / Gross Receipts for CY2004, CA Coatings Division Only - Between $1 million and < $2 million (Yes/No) / Yes/No / No
Gross CA coatdiv-5mil / Gross Receipts for CY2004, CA Coatings Division Only - Between $2 million and < $5 million (Yes/No) / Yes/No / No
Gross CA coatdiv-10mil / Gross Receipts for CY2004, CA Coatings Division Only - Between $5 million and < $10 million (Yes/No) / Yes/No / No
Gross CA coatdiv-100mil / Gross Receipts for CY2004, CA Coatings Division Only - Between $10 million and < $100 million (Yes/No) / Yes/No / No
Gross CA coatdiv-1bil / Gross Receipts for CY2004, CA Coatings Division Only - Between $100 million and < $1 billion (Yes/No) / Yes/No / No
Gross CA coatdiv->1bil / Gross Receipts for CY2004, CA Coatings Division Only - Greater than or equal to $1 billion (Yes/No) / Yes/No / No
Employ All-10 / Employees, Company Wide - Less than 10 (Yes/No) / Yes/No / No
Employ All-100 / Employees, Company Wide - Between 10 and < 100 (Yes/No) / Yes/No / No
Employ All-250 / Employees, Company Wide - Between 100 and < 250 (Yes/No) / Yes/No / No
Employ All-500 / Employees, Company Wide - Between 250 and < 500 (Yes/No) / Yes/No / No
Employ All->500 / Employees, Company Wide - Greater than or equal to 500 (Yes/No) / Yes/No / Yes
Employ CA Co-10 / Employees, CA Company Only - Less than 10 (Yes/No) / Yes/No / No
Employ CA Co-100 / Employees, CA Company Only - Between 10 and < 100 (Yes/No) / Yes/No / No
Employ CA Co-250 / Employees, CA Company Only - Between 100 and < 250 (Yes/No) / Yes/No / Yes
Employ CA Co-500 / Employees, CA Company Only - Between 250 and < 500 (Yes/No) / Yes/No / No
Employ CA Co->500 / Employees, CA Company Only - Greater than or equal to 500 (Yes/No) / Yes/No / No
Employ CA coatdiv-10 / Employees, CA Coatings Division Only - Less than 10 (Yes/No) / Yes/No / No
Employ CA coatdiv-100 / Employees, CA Coatings Division Only - Between 10 and < 100 (Yes/No) / Yes/No / Yes
Employ CA coatdiv-250 / Employees, CA Coatings Division Only - Between 100 and < 250 (Yes/No) / Yes/No / No
Employ CA coatdiv-500 / Employees, CA Coatings Division Only - Between 250 and < 500 (Yes/No) / Yes/No / No
Employ CA coatdiv->500 / Employees, CA Coatings Division Only - Greater than or equal to 500 (Yes/No) / Yes/No / No
DirCA-Retail / Sales Volume Based On - Direct CA retail sales? (Yes/No) / Yes/No / No
DirCA-Whole / Sales Volume Based On - Direct CA wholesale distribution? (Yes/No) / Yes/No / Yes
Prorated-Retail / Sales Volume Based On - Prorated from national retail sales? (Yes/No) / Yes/No / No
Prorated-Whole / Sales Volume Based On - Prorated from national wholesale distribution? (Yes/No) / Yes/No / No
Sales-Other / Sales Volume Based On - Other? (Yes/No) / Yes/No / No
Sales-Other / Describe "Other" method for determining CA sales volume / Text / 255 / N/A
Notes / Notes/comments from data entry personnel / Text / 100 / N/A
Step 2: Create a Form 2 file for Product Information with data in the following order, separated by commas.
For Example -
1,2500,PremiumCoat,1,27,N/A,9,13,0,0,0,0,0,0,0,0,N/A,I,WB,2,18,0,0,0,N/A,S,10,No,57,50,0,43,31,60,0,70,180,No,Yes,100,2000,2100,N/A
2,100X,MaintenanceCoat,2,19,N/A,3,9,10,13,0,0,0,0,0,0,N/A,D,SB,3,0,0,0,0,N/A,S,9.6,No,28,0,0,72,60,0,0,315,315,No,Yes,350,4200,4550,N/A
Descriptions of the field names, data types, and field lengths are provided below.
Field Name / Description / Field Type 1 / Field Length / ExampleEntry # / Entry Number for each product / Number
(Long Integer) / 1
Product Code / Product Code / Text / 50 / 2500
Product Name / Product Name / Text / 85 / PremiumCoat
# Grouped / Number of Products Grouped under one Product Code and one Product Name / Number
(Long Integer) / 1
Category Code / Coating Category Code from "Coating_Category" tab / Number
(Long Integer) / 27
Other Subcategory / Description for coatings classified as "Other" / Text / 50 / N/A
SubCode 1 / Substrate Code - 1st / Number
(Long Integer) / 9
SubCode 2 / Substrate Code - 2nd / Number
(Long Integer) / 13
SubCode 3 / Substrate Code - 3rd / Number
(Long Integer) / 0
SubCode 4 / Substrate Code - 4th / Number
(Long Integer) / 0
SubCode 5 / Substrate Code - 5th / Number
(Long Integer) / 0
SubCode 6 / Substrate Code - 6th / Number
(Long Integer) / 0
SubCode 7 / Substrate Code - 7th / Number
(Long Integer) / 0
SubCode 8 / Substrate Code - 8th / Number
(Long Integer) / 0
SubCode 9 / Substrate Code - 9th / Number
(Long Integer) / 0
SubCode 10 / Substrate Code - 10th / Number
(Long Integer) / 0
SubNotes / Substrate Code Notes (e.g., describe "Other" substrate) / Text / 50 / N/A
Int/Ext / Interior, Exterior or Dual Coating (I,E, or D)? / Text / 1 / I
SB/WB / Solventborne or Waterborne (SB or WB)? / Text / 2 / WB
ResCode 1 / Resin Code - 1st / Number
(Long Integer) / 2
ResCode 2 / Resin Code - 2nd / Number
(Long Integer) / 18
ResCode 3 / Resin Code - 3rd / Number
(Long Integer) / 0
ResCode 4 / Resin Code - 4th / Number
(Long Integer) / 0
ResCode 5 / Resin Code - 5th / Number
(Long Integer) / 0
ResNotes / Resin Code Notes (e.g., describe "Other" resin) / Text / 50 / N/A
Single/Multi / Single or Multi-Component (S or M)? / Text / 1 / S
Density / Coating Density (lbs/gal) / Number (Double) / 10
AvgProg / Averaging Program Product (Yes/No) / Yes/No / No
WtVolatile / Weight Percent of Volatile Material (%) / Number (Double) / 57
WtWater / Weight Percent of Water (%) / Number (Double) / 50
WtExempt / Weight Percent of Exempt Compounds (%) / Number (Double) / 0
WtSolids / Weight Percent of Solids (%) / Number (Double) / 43
VolSolids / Volume Percent of Solids (%) / Number (Double) / 31
VolWater / Volume Percent of Water (%) / Number (Double) / 60
VolExempt / Volume Percent of Exempt Compounds (%) / Number (Double) / 0
VOC Actual / VOC Actual (g/l) / Number (Double) / 70
VOC Reg / VOC Regulatory (g/l) / Number (Double) / 180
Method 24 / EPA Method 24 was used to determine VOC Actual and VOC Regulatory (Yes/No) / Yes/No / No
Formulation / Formulation data was used to determine VOC Actual and VOC Regulatory (Yes/No) / Yes/No / Yes
< Qt Sales / Sales (gallons) for container sizes one quart or less / Number (Double) / 100
> Qt Sales / Sales (gallons) for container sizes larger than one quart / Number (Double) / 2000
Total Sales / Total sales (gallons) for all container sizes / Number (Double) / 2100
Comments / Comment field for additional explanation. / Memo / 255 / N/A
Step 3: Create a Form 3 file for Ingredient Information with data in the following order, separated by commas.
For Example -
1,1,ChemCorp Mineral Spirits 66,8052413,6,0.5,N/A
1,2,Propylene Glycol,57556,0,4.0,N/A
1,3,Aggregated VOCs < 0.1 wt %,0,0,0.5,N/A
1,4,Texanol,25265774,0,2.0,N/A
1,5,Solids, 0,0,43.0,N/A
1,6,Water, 7732185,0,50.0,N/A
2,1,Mineral Spirits,64742887,14,24.0,N/A
2,2,Ethylene Glycol Monobutyl Ether,111762,0,2.5,N/A
2,3,Xylene,1330207,0,1.0,N/A
2,4,Aggregated Exempt Compounds <0.1 wt %,0,0,0.5,N/A
2,5,Solids,0,0,72.0,N/A
Descriptions of the field names, data types, and field lengths are provided below.
Field Name / Description / Field Type 1 / Field Length / ExampleEntry # / Entry # from "Form_2" / Number
(Long Integer) / 1
Ingr # / Ingredient number / Number
(Long Integer) / 1
Ingr Name / Ingredient name / Text / 255 / ChemCorp Mineral Spirits 66
CAS # / CAS Number / Number (Double) / 8052413
Bin / Hydrocarbon Solvent Bin Number for MIR / Number
(Long Integer) / 6
Wt % / Ingredient Weight Percent to the nearest 0.1% * / Number (Double) / 0.5
Comments / Comment field for additional explanation / Text / 200
NOTE:
For "Aggregated VOCs < 0.1 wt%", enter "Aggregated VOCs < 0.1 wt%" in the "Ingredient Name" column and provide the weight percent in this column.
Use this same approach for "Aggregated Exempt Compounds < 0.1 wt %", "Water", and "Solids", as needed.
1. For the “Yes/No” field type, data can be entered as: Yes, No, Y, or N.
S:\COATINGS\2005 Survey\Electronic Submittal\ARBsurvey_ascii.doc104/20/05