Instructions for filling in the Emission Test Template

This Information Collection Request (ICR) spreadsheet is intended to collect information about emission data fro

fuel burning power plants and which test methods were used to do so for cases where the test methods are not 

supported by the Electronic Reporting Tool (ERT). This spreadsheet should only be used if the method is not in t

if you do not have access to a lab which performs methods that are in the ERT. You must complete at least 3 se

runs or sampling events for each of the requested constituents. This spreadsheet is intended to be used for one 

one facility. Data for multiple boilers should be handled by using separate copies of this spreadsheet.

yellow are required. All cells that are shaded in green are populated using drop-down lists. You do not need to 

cells shaded in gray, as they are automatically populated from the Boiler Information worksheet. 

resulting spreadsheet with the following naming convention: [FacilityID]_Unit_[BoilerID]_EmisTestMethods.xls 

(example: 8100_Unit_2_EmisTestMethods.xls).

Please refer to the following steps when using these spreadsheets.

Boiler Information Worksheet

1. Please enter the EIA Facility Code, Facility Name and Boiler ID of your boiler on the Boiler Information worksh

2. Please enter the control device configuration.

Emission Data Worksheets

The emission data worksheets are provided for each constituent or constituent family required for this analysis. 

spreadsheet, you must enter boiler operating information during sampling, fuel input information, and emission 

results. There are generally 1 to 3 emission test results records to be entered depending on the constituent or c

family. For example, CO only requires 1 record with 3 sample events, while Mercury requires that you enter bot

Hg+2, or if the Ontario-Hydro Method was used, you would need to enter Hg0, HgP, and Hg

Volatile Organic HAP and Speciated Semi-Volatile Organic HAP worksheets allow you to use a drop

Constituent field to define as many records as needed to record each HAP that you have results for. General ins

follow for these worksheets:

Boiler Operation Information

1. Please provide the values of all requested parameters for each of test run/sample.

2. Please provide any other supporting information or comments in the Other Supporting Information field.

Fuel Information

1. Please enter what types of fuel are being used in your boiler using the drop-downs in the Fuel Type Selection 

You may enter up to 4 fuel types. If you are not burning one or more of the fuel types entered in one or more sa

then enter an input rate of zero. 

2. Please enter the unit of measure using the drop down provided.

3. Please enter the test method used to determine the fuel input rate.

4. Please provide any other information that you feel may be important in the Other Supporting Information fie

Emission Data
1. Some constituents ask for the emission rate results of each run in two different units of measure, while other

If emission rate results are requested in two different units of measure (ex. lb/MMBtu (Pounds per million BTU) 

ppmvd @ 7% O2(parts per million by volume dry basis at 7 percent oxygen)), you are required to provide both.

2. Please provide the test method used. This may or may not match the example given in the Test Method Used 

Please ensure that the name includes the owning organization of the test method (ex. U.S. EPA Method 0010).

3. Please provide any other information that you feel may be important in the Other Supporting Information fie

4. If data sheets and QA/QC documentation tables are provided for the test method you are entering data for p

enter these data.
nformation about emission data from fossil 

ses where the test methods are not currently 

nly be used if the method is not in the ERT or 

T. You must complete at least 3 separate 

sheet is intended to be used for one boiler of 

copies of this spreadsheet. Fields shaded in 

down lists. You do not need to populate 

rmation worksheet. Please name each 

nit_[BoilerID]_EmisTestMethods.xls 

ler on the Boiler Information worksheet. 

ent family required for this analysis. On each 

fuel input information, and emission test 

d depending on the constituent or constituent 

Mercury requires that you enter both Hg0 and 

, HgP, and Hg+2. However, both the Speciated 

low you to use a drop-down provided in the 

at you have results for. General instructions 

er Supporting Information field.

downs in the Fuel Type Selection field. 

fuel types entered in one or more samples, 

he Other Supporting Information field.
erent units of measure, while others do not. 

b/MMBtu (Pounds per million BTU) and 

, you are required to provide both.

mple given in the Test Method Used field. 

ethod (ex. U.S. EPA Method 0010).

he Other Supporting Information field.

 method you are entering data for please also 
EIA Facility Code Facility Name Boiler ID

AB Brown1
Control Device Configuraton
EIA Facility Code Facility Name Boiler ID

0 AB Brown 1

1A 2/16/2010 13:30

1B 2/16/2010 13:30

2A 2/16/2010 15:50

2B 2/16/2010 15:50

3A 2/17/2010 10:50

3B 2/17/2010 10:50

Run Number Test Start Date Test Start Time
Please note QA/QC documentation starting in Column "AI"

Measured Value 

(μg/dscm) Basis (Wet or Dry)

2/16/2010 15:30 0.34 Dry

2/16/2010 15:30 0.34 Dry

2/16/2010 17:50 0.35 Dry

2/16/2010 17:50 0.37 Dry

2/17/2010 12:50 0.35 Dry

2/17/2010 12:50 0.34 Dry

Total Vapor Phase Mercury Em

Test End Date Test End Time
 starting in Column "AI"

Test Method Used Data Flag (ADL, 

BDL, DLL)

Test Method 

Comments (lb/mmBtu)

U.S. EPA Method 30B ADL 2.99E-07

U.S. EPA Method 30B ADL 3.01E-07

U.S. EPA Method 30B ADL 3.05E-07

U.S. EPA Method 30B ADL 3.24E-07

U.S. EPA Method 30B ADL 3.06E-07

U.S. EPA Method 30B ADL 2.95E-07

Total Vapor Phase Mercury Emission Test Results

Steam Output 

(1000 lb/hr)
Fuel Input Rate

14 12.2 6.4 603270 127.6

14 12.2 6.4 603270 127.6

14 12.3 6.4 604361 127.6

14 12.3 6.4 604361 127.6

14.6 12.3 6.2 610789 127.9

14.6 12.3 6.2 610789 127.9

Flue Gas 

O2 (%)

Flue Gas 

Moisture 

(%)

Total Heat 

Input 

(mmBtu/hr)

Flue Gas 

CO2 (%)

Flue Gas 

Flow Rate 

(dscfm)

Flue Gas 

Temperature (F)
Fuel Type Units of 

Measure

Measurement 

Method

Fuel Input 

Rate Fuel Type Units of Measure

Measurement 

Method

Fuel Input 

Rate

Fuel #1 Fuel #2
Fuel Type Units of 

Measure

Measurement 

Method

Fuel Input 

Rate Fuel Type Units of Measure

Measurement 

Method

Fuel #3 Fuel #4
 QA/QC Documentation

Trap ID Section 1 

Mass (ng)

Section 2 

Mass (ng)

Total 

Mass (ng)

Initial 

Spike 

(ng)

Total NonSpike (ng)

63516 63 0 63 0 63

63530 63 0 63 0 63

63461 67 0 67 0 67

Other Supporting Information
Sample 

Volume 

(dscm)

Volume 

Difference (%)

Volume Diff. 

Limit

Breaktrough 

(%)

Breaktrough 

Limit

Concentration 

(μg/dscm) Trap ID

0.180129 0 0.349749346 64882

0.182306 0 0.345572828 64253

0.179459 0 0.373344329 64876

#DIV/0! #DIV/0!

#DIV/0! #DIV/0!

#DIV/0! #DIV/0!

≤20% of field 

recovery test

≤ 10% of 

Section 1 Hg 

mass for Hg 

conc. >1 

μg/dscm: or ≤ 

20% of Section 

Trap #1
Section 1 

Mass

Section 2 

Mass

Total 

Mass

Initial 

Spike

Total NonSpikeSample 

Volume

Volume 

Difference (%)

Volume Diff. 

Limit

166 0 266 100 66 0.178742

149 12 249 100 61 0.179863

160 2.4 260 100 62.4 0.180176 ≤20% of field 

recovery test

Trap #2
Breaktrough (%) Breaktrough 

Limit

Concentration 

(μg/dscm) Abs. diff. RD (%) Limit Crec

0 0.369247295 0.019498 2.711828 100

8.053691275 0.339147017 0.006426 0.938458 100

1.5 0.346328035 0.027016 3.753971 100

#DIV/0! #DIV/0! #DIV/0! #DIV/0!

#DIV/0! #DIV/0! #DIV/0! #DIV/0!

#DIV/0! #DIV/0! #DIV/0! #DIV/0!

≥10 % RD mass 

for Hg conc. >1 

μg/dscm: or 

≤20% RD or ≤0.2 

μg/dscm abs.diff. 

for Hg conc. ≤1 

≤ 10% of Section 

1 Hg mass for 

Hg conc. >1 

μg/dscm: or ≤ 

20% of Section 1 

for Hg conc.≤1 

Paired Trap Agreement (RD) Measured Spik
R (%) by 

Run Ravg (%) Limit

100.27

103.84

97.75

Average 

Recovery, 

between 85 and 

115%

Measured Spike Recovery ( R )

100.62
EIA Facility Code Facility Name Boiler ID

0 AB Brown 1

1 2/16/2010 13:00

2 2/17/2010 8:40

3 2/17/2010 13:15

Run Number Test Start Date Test Start Time
Total Dissolved Solids 

(mg solids/liter)

Total Suspended Solids 

(mg solids/liter)

2/16/2010 17:15 161000 260

2/17/2010 12:55 177000 290

2/17/2010 17:30 182000 260

Test End Date Test End Time
Test Method Used Data Flag (ADL, 

BDL, DLL)

Standard Test Method for Filterable and Nonfilterable Matter in Water ASTM D5907 ADL

Standard Test Method for Filterable and Nonfilterable Matter in Water ASTM D5907 ADL

Standard Test Method for Filterable and Nonfilterable Matter in Water ASTM D5907 ADL

Constisuent Emission Test Results
Test Method Comments Fuel Input Rate

603270 127.6

604361 127.6

610789 127.9

Flue Gas 

Temperat

ure (F)

Flue Gas 

Flow Rate 

(dscfm)

Steam Output 

(1000 lb/hr)

Total Heat Input 

(mmBtu/hr)
Fuel Type Units of 

Measure

Measurement 

Method Fuel Input Rate Fuel Type Units of Measure

Measurement 

Method Fuel Input Rate

Fuel #1 Fuel #2
Fuel Type Units of 

Measure

Measurement 

Method

Fuel Input 

Rate Fuel Type Units of Measure

Measurement 

Method

Fuel #3 Fuel #4
Other Supporting Information