Instructions for filling in the Emission Test Template

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

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

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

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

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

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

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

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

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 worksheet. 

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. On each 

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

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

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

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

Volatile Organic HAP and Speciated Semi-Volatile Organic HAP worksheets allow you to use a drop-down provided in the 

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

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 field. 

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 samples, 

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 field.

Emission Data

1. Some constituents ask for the emission rate results of each run in two different units of measure, while others do not. 

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

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 field. 

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 field.

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

enter these data.
EIA Facility Code Facility Name Boiler ID

645 Big Bend Unit 1
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

645 Big Bend Unit 1

1 4/21/2010 13:42 4/21/2010

2 4/21/2010 15:34 4/21/2010

3 4/21/2010 16:35 4/21/2010

Run Number Test Start Date Test Start Time Test End Date
Measured Value 

(ppm) Basis (Wet or Dry) Test Method Used 

14:42 31.48 Dry U.S. EPA Method 320

16:34 32.67 Dry U.S. EPA Method 320

17:35 32.73 Dry U.S. EPA Method 320

HCN - FTIR Wet

26.64

27.39

27.44

HCN, ppm wet corrected to dry conditions:

HCN, ppmvd = HCN, ppmvw / (1-(run moisture value / 100))

Test End Time

Hydrogen Cyanide Emission Test Results
CEM Data RM 320 CEM Data

Data Flag (ADL, 

BDL, DDL)

Test Method 

Comments

0.029 4559 15.38 13.5

0.030 4498 16.15 13.6

0.030 4495 16.16 13.6

CEM Data

Kscfh, wet scfh, wet

HCN, lbs/scf HCN, lbs/mmBtu 71982 71982000

2.20903E-06 0.029 71028 71028000

2.29208E-06 0.030 70980 70980000

2.29654E-06 0.030

Emmision rate calculated as: CO2, %w - CEM Data

HCN, lbs/mmBtu = 11.4

ppmvd x (27.02534 / (385.15 x 10^6)) x 1800 x (100 / CO2 % dry) 11.4

11.4

Calculated 

Emission Rate 

(lb/mmBtu)

Flue Gas 

Moisture 

(%)

Flue Gas 

CO2 (%)

Steam Output 

(1000 lb/hr)

Total Heat 

Input 

(mmBtu/hr)
CEM Data CEM Data

Fuel Input 

Rate Fuel Type Units of Measure

Measurement 

Method

Fuel Input 

Rate

1.015E+06 130 3.28E+05 bituminous lb/hour Other

9.926E+05 132 3.28E+05 bituminous lb/hour Other

9.918E+05 132 3.28E+05 bituminous lb/hour Other

scfh, dry dscfm

60911168 1.015E+06

59556978 9.926E+05

59509632 9.918E+05

CO2, %dry

13.5

13.6

13.6

Flue Gas 

Temperature 

(F)

Fuel #1 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

Fuel Input 

Rate

Fuel #2 Fuel #3
Fuel Type Units of 

Measure

Measurement 

Method

Fuel #4

Other Supporting Information

Heat Input, CO2, Flue Gas Flow 

Rate, Stack temp are from CEMS