Instructions for Emissions Testing Template | |||||||||||||
1) | Three different tabs are provided based on the type of test performed: | ||||||||||||
Emissions source test results should be entered in the "Emissions_Data" tab | |||||||||||||
Fuel gas sampling data should be entered in the "FuelGas_Data" tab | |||||||||||||
Wastewater sampling data should be entered in the "Wastewater_Data" tab | |||||||||||||
2) | Data should be entered into the white cells only; blue cells are intended for calculations | ||||||||||||
3) | A list of pollutants, their CAS No./Pollutant Code, and their pollutant category are provided in the "Pollutants" tab | ||||||||||||
4) | Guidance for process data to report is provided below | ||||||||||||
Qa | Qs | %M | Ts | Ps | %O2 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Emissions Test Data | Use full detection limits in averages? | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Instruction: | Enter APCD used during test. Enter more than 1 APCD if needed (e.g., ESP1/WS1) | Enter other source reduction measures used during emission test (e.g., low NOx burners or catalyst additives) | General source description, e.g., Fluid catalytic cracking unit; semiregenerative catalytic reforming unit; etc. | Assign a unique ID for each test report | Enter start date | Enter the pollutant information for each pollutant measured (see pollutant tab for list of possible pollutants) | Enter the feed input rate or production rate in units as specified in table for Question 16 of Part I (see instructions tab for details) | Provide other processing rate data as specified in the instructions for the type of unit tested. | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Field: | Process Throughput or Production Rate | Secondary Processing Rate Data | Outlet - Run 1 Stack Gas Parameters | Outlet - Run 2 Stack Gas Parameters | Outlet - Run 3 Stack Gas Parameters | Outlet - Average Stack Gas Parameters | Outlet - Run 1 Emissions Data | Outlet - Run 2 Emissions Data | Outlet - Run 3 Emissions Data | Outlet - Average Emissions Data | Suspect Data | Exclude | Comment | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Facility ID Number | Unit ID Number | APCD_ID(s) | Combustion controls used to reduce air pollution (from combustion sources) | General Description | Test Report ID | Test Date (mm/dd/yyyy) |
Other data provided | Pollutant Name | Pollutant CAS No. | Pollutant Class | Test Method | Run 1 Hourly Production Rate (value) |
Run 2 Hourly Production Rate (value) |
Run 3 Hourly Production Rate (value) |
Average Hourly Production Rate (value) |
Hourly Production Rate (units) |
Production comment | Run 1 Hourly Production Rate (value) |
Run 2 Hourly Production Rate (value) |
Run 3 Hourly Production Rate (value) |
Average Hourly Production Rate (value) |
Hourly Production Rate (units) |
Production comment | Run 1 Airflow Rate_Outlet (acfm) |
Run 1 Airflow Rate_Outlet (dscfm) |
Run 1 Gas Moisture_Outlet (%) |
Run 1 Gas Temp_Outlet (F) |
Run 1 Gas Pressure_Outlet (in. Hg) |
Run 1 Gas Oxygen_Outlet (%) |
Run 2 Airflow Rate_Outlet (acfm) |
Run 2 Airflow Rate_Outlet (dscfm) |
Run 2 Gas Moisture_Outlet (%) |
Run 2 Gas Temp_Outlet (F) |
Run 2 Gas Pressure_Outlet (in. Hg) |
Run 2 Gas Oxygen_Outlet (%) |
Run 3 Airflow Rate_Outlet (acfm) |
Run 3 Airflow Rate_Outlet (dscfm) |
Run 3 Gas Moisture_Outlet (%) |
Run 3 Gas Temp_Outlet (F) |
Run 3 Gas Pressure_Outlet (in. Hg) |
Run 3 Gas Oxygen_Outlet (%) |
Average Airflow Rate_Outlet (acfm) |
Average Airflow Rate_Outlet (dscfm) |
Average Gas Moisture_Outlet (%) |
Average Gas Temp_Outlet (F) |
Average Gas Pressure_Outlet (in. Hg) |
Average Gas Oxygen_Outlet (%) |
Run 1_Outlet concentration |
Run 1 Outlet concentration units | Run 1 Outlet Detect Flag | Run 1_Outlet (lb/hr) |
Run 1_Outlet (lb/production) |
Run 1 Lb/Production units |
Run 2_Outlet concentration |
Run 2 Outlet concentration units | Run 2 Outlet Detect Flag | Run 2_Outlet (lb/hr) |
Run 2_Outlet (lb/production) |
Run 2 Lb/Production units |
Run 3_Outlet concentration |
Run 3 Outlet concentration units | Run 3 Outlet Detect Flag | Run 3_Outlet (lb/hr) |
Run 3_Outlet (lb/production) |
Run 3 Lb/Production units |
Average_Outlet concentration |
Average Outlet concentration units | Count Outlet Non-Detect Runs | Average_Outlet (lb/hr) |
Average_Outlet (lb/production) |
Average Lb/Production units |
Suspect Data? | Cause for suspicion | Exclude Data? | Reason for excluding | Test Report Comment | |
#DIV/0! | #DIV/0! | #DIV/0! | #DIV/0! | #DIV/0! | #DIV/0! | #DIV/0! | #DIV/0! | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
link ro Run 1 | link to Run 1 | link ro Run 1 | link to Run 1 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Emissions Test Data | ||||||||||||||||||||||||||||||||||||
Instruction: | General source description, e.g., mix drum for X,Y,Z units; mix drum for fuel gas system 1; etc. | Assign a unique ID for each test report | Enter start date | Enter the pollutant information for each pollutant measured (see pollutant tab for list of possible pollutants) | Enter the fuel gas flow rate or usage rates (in scfm at 60°F) from measurement data, company records, or engineering analyses | |||||||||||||||||||||||||||||||
Field: | Process Throughput or Production Rate | Run 1 | Run 2 | Run 3 | Outlet - Average Emissions Data | Suspect Data | Exclude | Comment | ||||||||||||||||||||||||||||
Facility ID Number | Fuel gas mix drum ID | General Description | Test Report ID | Test Date (mm/dd/yyyy) |
Other data provided | Pollutant Name | Pollutant CAS No. | Pollutant Class | Test Method | Run 1 Fuel Gas Flow Rate (scfm) |
Run 2 Fuel Gas Flow Rate (scfm) |
Run 3 Fuel Gas Flow Rate (scfm) |
Average Fuel Gas Flow Rate (scfm) |
Production comment | Run 1 Concentration | Run 1 Concentration units | Run 1 Detect Flag | Run 1 Mass flow (lb/hr) |
Run 2 Concentration | Run 2 Concentration units | Run 2 Detect Flag | Run 2 Mass flow (lb/hr) |
Run 3 Concentration | Run 3 Concentration units | Run 3 Detect Flag | Run 3 Mass flow (lb/hr) |
Average concentration | Average concentration units | Count Non-Detect Runs | Average Mass flow (lb/hr) |
Suspect Data? | Cause for suspicion | Exclude Data? | Reason for excluding | Test Report Comment | |
#DIV/0! | ||||||||||||||||||||||||||||||||||||
link ro Run 1 | link ro Run 1 | |||||||||||||||||||||||||||||||||||
Well-Mixed Assessment | F_bio Determination | |||||||||||||||||||||||||||||||||||||||||||||
Criteria or Description | Value | Compound | F_bio | First-order biorate, k1 (L/gMLVSS-hr) | ||||||||||||||||||||||||||||||||||||||||||
Meets defintion of EBU | Benzene Only Spike | |||||||||||||||||||||||||||||||||||||||||||||
Meets characteristics in Table 1 | Benzene | |||||||||||||||||||||||||||||||||||||||||||||
Meets specifications in Table 2 | Multi-compound Spike | |||||||||||||||||||||||||||||||||||||||||||||
Calculated mixing time | Benzene | |||||||||||||||||||||||||||||||||||||||||||||
Forms used to calculate mixing time | Toluene | |||||||||||||||||||||||||||||||||||||||||||||
Xylene | ||||||||||||||||||||||||||||||||||||||||||||||
Naphthalene | ||||||||||||||||||||||||||||||||||||||||||||||
Waste Water Sampling Data | ||||||||||||||||||||||||||||||||||||||||||||||
Instruction: | General source description, e.g., submerged aeration activated sludge unit; UNOX system; etc. | Assign a unique ID for each test report | Enter start date | Enter the pollutant information for each pollutant measured (see pollutant tab for list of possible pollutants) | Enter the wastewater flow rate and other parameters of the wastewater of unit tested. | |||||||||||||||||||||||||||||||||||||||||
Field: | Process Throughput or Production Rate | Influent Sample Results | Within Biological Treatment Unit Results | Effluent Sample Results | Outlet - Average Stack Gas Parameters | Suspect Data | Exclude | Comment | ||||||||||||||||||||||||||||||||||||||
Facility ID Number | Unit ID Number | General Description | Test Report ID | Test Date (mm/dd/yyyy) |
Other data provided | Pollutant Name | Pollutant CAS No. | Pollutant Class | Test Method | Average wastewater flow rate during test (m3/sec) | Wastewater pH | Wastewater temperature | Volatile suspended solids in biological treatment unit (g/L) (units) |
Total horsepower to surface aerators (HP) | Total air flow rate to diffused aerators (scfm at 68°F) | Other information or comment | Run 1 Airflow Rate_Outlet (acfm) |
Run 1 Airflow Rate_Outlet (dscfm) |
Run 1 Gas Moisture_Outlet (%) |
Run 1 Gas Temp_Outlet (F) |
Run 1 Gas Pressure_Outlet (in. Hg) |
Run 1 Gas Oxygen_Outlet (%) |
Run 2 Airflow Rate_Outlet (acfm) |
Run 2 Airflow Rate_Outlet (dscfm) |
Run 2 Gas Moisture_Outlet (%) |
Run 2 Gas Temp_Outlet (F) |
Run 2 Gas Pressure_Outlet (in. Hg) |
Run 2 Gas Oxygen_Outlet (%) |
Run 3 Airflow Rate_Outlet (acfm) |
Run 3 Airflow Rate_Outlet (dscfm) |
Run 3 Gas Moisture_Outlet (%) |
Run 3 Gas Temp_Outlet (F) |
Run 3 Gas Pressure_Outlet (in. Hg) |
Run 3 Gas Oxygen_Outlet (%) |
Average Airflow Rate_Outlet (acfm) |
Average Airflow Rate_Outlet (dscfm) |
Average Gas Moisture_Outlet (%) |
Average Gas Temp_Outlet (F) |
Average Gas Pressure_Outlet (in. Hg) |
Average Gas Oxygen_Outlet (%) |
Suspect Data? | Cause for suspicion | Exclude Data? | Reason for excluding | Test Report Comment | |
Pollutant_Class | CAS_Number | Substance | |
1 | Criteria Pollutants | 630-08-0 | Carbon monoxide |
2 | Criteria Pollutants | PM10-PRI | Particulate matter (PM) ≤ 10 µm |
3 | Criteria Pollutants | PM10-FIL | Filterable PM ≤ 10 µm |
4 | Criteria Pollutants | PM25-PRI | PM ≤ 2.5 µm |
5 | Criteria Pollutants | PM25-FIL | Filterable PM ≤ 2.5 µm |
6 | Criteria Pollutants | PM-CON | Condensable PM |
7 | Criteria Pollutants | 10102-44-0 | Nitrogen dioxide |
8 | Criteria Pollutants | NOX | Nitrogen oxides |
9 | Criteria Pollutants | 7446-09-5 | Sulfur dioxide |
10 | Criteria Pollutants | VOC | Volatile organic compounds |
11 | VOC | 74-85-1 | Ethylene |
12 | VOC | 74-86-2 | Acetylene |
13 | VOC | 74-98-6 | Propane |
14 | VOC | 115-07-1 | Propylene |
15 | VOC | 463-49-0 | Propadiene |
16 | VOC | 106-97-8 | n-Butane |
17 | VOC | 75-28-5 | Isobutane |
18 | VOC | 106-98-9 | 1-Butene |
19 | VOC | 107-01-7 | 2-Butene |
20 | VOC | 115-11-7 | Isobutene |
21 | VOC | 590-19-2 | 1,2-Butadiene |
22 | VOC | 109-66-0 | n-pentane |
23 | VOC | 78-78-4 | 2-Methylbutane |
24 | VOC | 287-92-3 | Cyclopentane |
25 | VOC | 591-95-7 | 1,2-Pentadiene |
26 | VOC | 1574-41-0 | 1-cis-3-Pentadiene |
27 | VOC | 2004-70-8 | 1-trans-3-Pentadiene |
28 | VOC | 591-93-5 | 1,4-Pentadiene |
29 | VOC | 591-96-8 | 2,3-Pentadiene |
30 | VOC | 598-25-4 | 3-Methyl-1,2-butadiene |
31 | VOC | 78-79-5 | 2-Methyl-1,3-butadiene |
32 | VOC | 542-92-7 | Cyclopentadiene |
33 | VOC | 110-82-7 | Cyclohexane |
34 | VOC | 108-87-2 | Methylcylcohexane |
35 | VOC | 142-82-5 | Heptane (and isomers) |
36 | VOC | 111-65-9 | Octane (and isomers) |
37 | VOC | 78-93-3 | Methyl ethyl ketone |
38 | VOC | 25551-13-7 | Trimethylbenzene(s) |
39 | Volatile Organic HAP | 75-07-0 | Acetaldehyde |
40 | Volatile Organic HAP | 107-02-8 | Acrolein |
41 | Volatile Organic HAP | 62-53-3 | Analine |
42 | Volatile Organic HAP | 71-43-2 | Benzene |
43 | Volatile Organic HAP | 74-83-9 | Bromomethane |
44 | Volatile Organic HAP | 106-99-0 | 1,3-Butadiene |
45 | Volatile Organic HAP | 75-00-3 | Chloroethane |
46 | Volatile Organic HAP | 67-66-3 | Chloroform |
47 | Volatile Organic HAP | 74-87-3 | Chloromethane |
48 | Volatile Organic HAP | 98-82-8 | Cumene |
49 | Volatile Organic HAP | 106-93-4 | 1,2-Dibromoethane |
50 | Volatile Organic HAP | 106-46-7 | 1,4-Dichlorobenzene |
51 | Volatile Organic HAP | 75-34-3 | 1,1-Dichloroethane |
52 | Volatile Organic HAP | 107-06-2 | 1,2-Dichloroethane |
53 | Volatile Organic HAP | 75-35-4 | 1,1-Dichloroethylene |
54 | Volatile Organic HAP | 78-87-5 | 1,2-Dichloropropane |
55 | Volatile Organic HAP | 542-75-6 | 1,3-Dichloropropene |
56 | Volatile Organic HAP | 111-42-2 | Diethanolamine |
57 | Volatile Organic HAP | 100-41-4 | Ethylbenzene |
58 | Volatile Organic HAP | 50-00-0 | Formaldehyde |
59 | Volatile Organic HAP | 67-72-1 | Hexachloroethane |
60 | Volatile Organic HAP | 110-54-3 | n-Hexane |
61 | Volatile Organic HAP | 67-56-1 | Methanol |
62 | Volatile Organic HAP | 108-10-1 | Methyl isobutyl ketone |
63 | Volatile Organic HAP | 1634-04-4 | Methyl tert-butyl ether |
64 | Volatile Organic HAP | 100-42-5 | Styrene |
65 | Volatile Organic HAP | 79-34-5 | 1,1,2,2-Tetrachloroethane |
66 | Volatile Organic HAP | 127-18-4 | Tetrachloroethylene |
67 | Volatile Organic HAP | 108-88-3 | Toluene |
68 | Volatile Organic HAP | 79-00-5 | 1,1,2-Trichloroethane |
69 | Volatile Organic HAP | 79-01-6 | Trichloroethylene |
70 | Volatile Organic HAP | 121-44-8 | Triethylamine |
71 | Volatile Organic HAP | 540-84-1 | 2,2,4-Trimethylpentane |
72 | Volatile Organic HAP | 593-60-2 | Vinyl bromide |
73 | Volatile Organic HAP | 75-01-4 | Vinyl chloride |
74 | Volatile Organic HAP | 95-47-6 | o-Xylene |
75 | Volatile Organic HAP | 108-38-3 | m-Xylene |
76 | Volatile Organic HAP | 106-42-3 | p-Xylene |
77 | Volatile Organic HAP | 1330-20-7 | Xylenes (total) |
78 | Semi-Volatile/Non-Volatile Organic HAP | 83-32-9 | Acenaphthene |
79 | Semi-Volatile/Non-Volatile Organic HAP | 208-96-8 | Acenaphthylene |
80 | Semi-Volatile/Non-Volatile Organic HAP | 120-12-7 | Anthracene |
81 | Semi-Volatile/Non-Volatile Organic HAP | 56-55-3 | Benzo(a)anthracene |
82 | Semi-Volatile/Non-Volatile Organic HAP | 50-32-8 | Benzo(a)pyrene |
83 | Semi-Volatile/Non-Volatile Organic HAP | 205-99-2 | Benzo(b)fluoranthene |
84 | Semi-Volatile/Non-Volatile Organic HAP | 192-97-2 | Benzo(e)pyrene |
85 | Semi-Volatile/Non-Volatile Organic HAP | 191-24-2 | Benzo(g,h,i)perylene |
86 | Semi-Volatile/Non-Volatile Organic HAP | 207-08-9 | Benzo(k)fluoranthene |
87 | Semi-Volatile/Non-Volatile Organic HAP | 92-52-4 | Biphenyl |
88 | Semi-Volatile/Non-Volatile Organic HAP | 117-81-7 | Bis(2-ethyl hexyl)phthalate |
89 | Semi-Volatile/Non-Volatile Organic HAP | 91-58-7 | 2-Chloronaphthalene |
90 | Semi-Volatile/Non-Volatile Organic HAP | 108-39-4 | m-Cresol |
91 | Semi-Volatile/Non-Volatile Organic HAP | 95-48-7 | o-Cresol |
92 | Semi-Volatile/Non-Volatile Organic HAP | 106-44-5 | p-Cresol |
93 | Semi-Volatile/Non-Volatile Organic HAP | 1319-77-3 | Cresols (total) |
94 | Semi-Volatile/Non-Volatile Organic HAP | 218-01-9 | Chrysene |
95 | Semi-Volatile/Non-Volatile Organic HAP | 53-70-3 | Dibenz(a,h)anthracene |
96 | Semi-Volatile/Non-Volatile Organic HAP | 84-74-2 | di-n-Butyl phthalate |
97 | Semi-Volatile/Non-Volatile Organic HAP | 84-66-2 | Diethyl-phthalate |
98 | Semi-Volatile/Non-Volatile Organic HAP | 57-97-6 | 7,12-Dimethylbenz(a) anthracene |
99 | Semi-Volatile/Non-Volatile Organic HAP | 206-44-0 | Fluoranthene |
100 | Semi-Volatile/Non-Volatile Organic HAP | 86-73-7 | Fluorene |
101 | Semi-Volatile/Non-Volatile Organic HAP | 193-39-5 | Indeno(1,2,3-cd) pyrene |
102 | Semi-Volatile/Non-Volatile Organic HAP | 56-49-5 | 3-Methylchloranthrene |
103 | Semi-Volatile/Non-Volatile Organic HAP | 91-57-6 | 2-Methylnaphthalene |
104 | Semi-Volatile/Non-Volatile Organic HAP | 218-01-9 | Chrysene |
105 | Semi-Volatile/Non-Volatile Organic HAP | 91-20-3 | Naphthalene |
106 | Semi-Volatile/Non-Volatile Organic HAP | 198-55-0 | Perylene |
107 | Semi-Volatile/Non-Volatile Organic HAP | 85-01-8 | Phenanthrene |
108 | Semi-Volatile/Non-Volatile Organic HAP | 108-95-2 | Phenol |
109 | Semi-Volatile/Non-Volatile Organic HAP | 129-00-0 | Pyrene |
110 | Dioxins Furans and PCBs | 1746-01-6 | Dioxin: 4D 2378 |
111 | Dioxins Furans and PCBs | 40321-76-4 | Dioxin: 5D 12378 |
112 | Dioxins Furans and PCBs | 39227-28-6 | Dioxin: 6D 123478 |
113 | Dioxins Furans and PCBs | 57653-85-7 | Dioxin: 6D 123678 |
114 | Dioxins Furans and PCBs | 19408-74-3 | Dioxin: 6D 123789 |
115 | Dioxins Furans and PCBs | 35822-46-9 | Dioxin: 7D 1234678 |
116 | Dioxins Furans and PCBs | 3268-87-9 | Dioxin: 8D |
117 | Dioxins Furans and PCBs | 132-64-9 | Dibenzofurans |
118 | Dioxins Furans and PCBs | 51207-31-9 | Furan: 4F 2378 |
119 | Dioxins Furans and PCBs | 57117-41-6 | Furan: 5F 12378 |
120 | Dioxins Furans and PCBs | 57117-31-4 | Furan: 5F 23478 |
121 | Dioxins Furans and PCBs | 70648-26-9 | Furan: 6F 123478 |
122 | Dioxins Furans and PCBs | 57117-44-9 | Furan: 6F 123678 |
123 | Dioxins Furans and PCBs | 72918-21-9 | Furan: 6F 123789 |
124 | Dioxins Furans and PCBs | 60851-34-5 | Furan: 6F 234678 |
125 | Dioxins Furans and PCBs | 67562-39-4 | Furan: 7F 1234678 |
126 | Dioxins Furans and PCBs | 55673-89-7 | Furan: 7F 1234789 |
127 | Dioxins Furans and PCBs | 39001-02-0 | Furan: 8F |
128 | Dioxins Furans and PCBs | 1336-36-3 | Polychlorinated biphenyls (total) |
129 | Metal HAP | 7440-36-0 | Antimony |
130 | Metal HAP | 7440-38-2 | Arsenic |
131 | Metal HAP | 7440-41-7 | Beryllium |
132 | Metal HAP | 7440-43-9 | Cadmium |
133 | Metal HAP | 18540-29-9 | Chromium (hexavalent) |
134 | Metal HAP | 7440-47-3 | Chromium (total) |
135 | Metal HAP | 7440-48-4 | Cobalt |
136 | Metal HAP | 7439-92-1 | Lead |
137 | Metal HAP | 7439-96-5 | Manganese |
138 | Metal HAP | 7439-97-6 | Mercury |
139 | Metal HAP | 7440-02-0 | Nickel |
140 | Metal HAP | 7782-49-2 | Selenium |
141 | Other Inorganic HAP | 75-15-0 | Carbon disulfide |
142 | Other Inorganic HAP | 463-58-1 | Carbonyl sulfide |
143 | Other Inorganic HAP | 7782-50-5 | Chlorine |
144 | Other Inorganic HAP | 7647-01-0 | Hydrogen chloride |
145 | Other Inorganic HAP | 74-90-8 | Hydrogen cyanide (& cyanide compounds) |
146 | Other Inorganic HAP | 7664-39-3 | Hydrogen fluoride |
147 | Other Inorganic HAP | 7723-14-0 | Phosphorus |
148 | Other Compounds | 7664-41-7 | Ammonia |
149 | Other Compounds | 74-84-0 | Ethane |
150 | Other Compounds | 7783-06-4 | Hydrogen sulfide |
151 | Other Compounds | 7440-39-3 | Barium |
152 | Other Compounds | 7440-50-8 | Copper |
153 | Other Compounds | 7439-98-7 | Molybdenum |
154 | Other Compounds | 7440-62-2 | Vanadium |
155 | Other Compounds | 7440-66-6 | Zinc |
156 | Surrogate | HHV | Higher Heating Value (HHV) |
157 | Surrogate | THC | Total Hydrocarbon (THC) |
158 | Surrogate | TRS | Total Reduced Sulfur (TRS) |
159 | Surrogate | Sulfide | Sulfide |
160 | Surrogate | BOD5 | 5-day Biological Oxygen Demand |
161 | Surrogate | COD | Chemical Oxygen Demand |
File Type | application/vnd.ms-excel |
Author | dbullock |
Last Modified By | Jeff Coburn |
File Modified | 2011-03-18 |
File Created | 2011-02-02 |