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

884 Will County4
Control Device Configuraton

Listed (by boiler) in the Configuration Order Section of the Facility Unit Configurations Section of the Electronic ICR
lectronic ICR
EIA Facility Code Facility Name Boiler ID

884 Will County 4

1 6/30/2010 8:25

2 7/1/2010 8:30

3 7/2/2010 8:00

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)

6/30/2010 10:25 1.28 Dry

7/1/2010 10:30 1.46 Dry

7/2/2010 10:00 1.54 Dry

Total Vapor Phase Mercury Em

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

Test Method Used Data Flag (ADL, 

BDL, DDL)

Test Method 

Comments (lb/mmBtu)

U.S. EPA Method 30B ADL 9.13E-07 3771.2

U.S. EPA Method 30B ADL 1.18E-06 3762.2

U.S. EPA Method 30B ADL 1.11E-06 3696.2

Total Vapor Phase Mercury Emission Test Results

Steam Output 

(1000 lb/hr)
Fuel Input Rate

5320.4 11.4 14.3 5.3 1002207 308.6 621600

5333.4 10.4 14.5 5.1 1007312 311.4 623000

5158.6 11.8 14.2 5.2 972834 311.5 602700

Total Heat 

Input 

(mmBtu/hr)

Flue Gas 

Temperature (F)

Flue Gas 

Moisture 

(%)

Flue Gas 

CO2 (%)

Flue Gas 

O2 (%)

Flue Gas 

Flow Rate 

(dscfm)
Fuel Type Units of 

Measure

Measurement 

Method

Fuel Input 

Rate Fuel Type Units of Measure

Measurement 

Method

subbituminous lb/hour Other

subbituminous lb/hour Other

subbituminous lb/hour Other

Fuel #1 Fuel #2
Fuel Input 

Rate 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)

Fuel Calc with CEMS heat input and fuel HHV 66523 122 0.5 122.5 0

Fuel Calc with CEMS heat input and fuel HHV 66519 138 0.1 138.1 0

Fuel Calc with CEMS heat input and fuel HHV 66512 145 0.0 145.0 0

Other Supporting Information
Total NonSpike (ng)

Sample 

Volume 

(dscm)

Volume 

Difference (%)

Volume Diff. 

Limit

Breaktrough 

(%)

Breaktrough 

Limit

122.5 0.092903 0.409836066

138.1 0.093021 0.072463768

145.0 0.092169 0.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
Concentration 

(μg/dscm) Trap ID Section 1 Mass

Section 2 

Mass

Total 

Mass

Initial 

Spike

Total NonSpikeSample 

Volume

1.318579594 64877 216 0.5 216.5 100 116.5 0.093738

1.484611002 64729 234 0.7 234.7 100 134.7 0.093809

1.573197062 68264 239 0.5 239.5 100 139.5 0.093007

#DIV/0!

#DIV/0!

#DIV/0!
Volume 

Difference (%)

Volume Diff. 

Limit Breaktrough (%) Breaktrough Limit

Concentration 

(μg/dscm) Abs. diff. 

0.231481481 1.242825748 0.075754

0.299145299 1.435896343 0.048715

0.209205021 1.499887105 0.07331

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

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

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

≤ 10% of Section 

1 Hg mass for 

Hg conc. >1 

μg/dscm: or ≤ 

20% of Section 1 

for Hg conc.≤1 

≤20% of field 

recovery test

Trap #2 Paired Trap Agreement 
RD (%) Limit Crec

R (%) by 

Run Ravg (%) Limit

2.957511 100 92.90

1.668020 100 95.43

2.385550 100 93.18

#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 

Average 

Recovery, 

between 85 and 

115%

Measured Spike Recovery ( R )

93.83666667

Paired Trap Agreement (RD)