Instructions for filling 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. Constituents of concern are: Car

Monoxide, Formaldehyde, Methane, Speciated Volatile Hazardous Air Pollutants (HAPs), Speciated Semi

HAPs, Sulfur Dioxide, Oxygen, Carbon Dioxide, Hydrogen Cyanide, Nitrogen Oxides, Total Dissolved Solids (TDS), 

Suspended Solids (TSS). You must complete 3 separate sampling events for each of the requested constituents. 

spreadsheet is intended to be used for one boiler of one facility. Data for multiple boilers should be handled b

separate copies of this spreadsheet. Fields shaded in yellow are required. All cells that are shaded in light gree

populated using drop-down lists. You do not need to populate cells shaded in gray, as they are automatically po

from the Boiler Information worksheet. Please Do Not modify the structure of this spreadsheet by adding or su

rows, columns, cells. 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 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 determine which units of measure (acfm or dscfm) were used for Exhaust Flow Rate and which units o

(deg C or deg F) were used for Exhaust Temperature. Fill these units of measure into the Units of Measure field.

2. Please provide the values of all requested parameters for each of the 3 sample testing periods in the Sample 

2, and Sample 3 fields.

3. 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. Then, enter the input rate of each fuel in the Sample 1, Sample 2, and Sample 

If you are not burning one or more of the fuel types entered in one or more samples, then enter an input rate of 
If you are not burning one or more of the fuel types entered in one or more samples, then enter an input rate of 

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 of the 3 samples in two different units of measure

others do not. If emission rate results are requested in two different units of measure (ex. lb/MMBtu (Pounds p

BTU) and ppmvd @ 7% O2(parts per million by volume dry basis at 7 percent oxygen)), you are required to prov

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. Constituents of concern are: Carbon 

ants (HAPs), Speciated Semi-Volatile Organic 

Oxides, Total Dissolved Solids (TDS), and Total 

each of the requested constituents. This 

multiple boilers should be handled by using 

All cells that are shaded in light green are 

in gray, as they are automatically populated 

 of this spreadsheet by adding or subtracting 

wing naming convention: 

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

xhaust Flow Rate and which units of measure 

ure into the Units of Measure field.

mple testing periods in the Sample 1, Sample 

er Supporting Information field.

downs in the Fuel Type Selection field. 

he Sample 1, Sample 2, and Sample 3 fields. 

samples, then enter an input rate of zero. 
samples, then enter an input rate of zero. 

he Other Supporting Information field.

es in two different units of measure, while 

f measure (ex. lb/MMBtu (Pounds per million 

t oxygen)), 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

997 Michigan City Unit 12
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

997 Michigan City Unit 12

Parameter Sample 1 Sample 2 Sample 3

Date of Testing

Steam Output (1000 lb/hr)

Total Heat Input (MMBtu/hr)

Basis (Wet/Dry)

Exhaust Steam % Moisture

Exhaust Flow Rate (acfm or dscfm)

Exhaust Temperature (deg C or deg F)

Fuel Type Selection

Fuel Input Rate

Sample 1

Fuel Input Rate 

Sample 2

Fuel Input Rate 

Sample 3

Emission Test Results

CO Emission Rate 

Sample 1 

(lb/MMBtu)

CO Emission Rate 

Sample 1 

(ppmvd @ 7% O2)

CO Emission Rate 

Sample 2 

(lb/MMBtu)
Unit of Measure

Other Supporting 

Information

1000 lb/hr

MMBtu/hr

N/A

%

Unit of Measure

Fuel Flow 

Measurement 

Method

Other Supporting 

Information

CO Emission Rate 

Sample 2 

(ppmvd @ 7% O2)

CO Emission Rate 

Sample 3 

(lb/MMBtu)

CO Emission Rate 

Sample 3 

(ppmvd @ 7% O2)

Test Method Used 

(ex. U.S. EPA

Method 10A)

Other Supporting 

Information
EIA Facility Code Facility Name Boiler ID

997 Michigan City Unit 12

Parameter Sample 1 Sample 2 Sample 3

Date of Testing

Steam Output (1000 lb/hr)

Total Heat Input (MMBtu/hr)

Basis (Wet/Dry)

Exhaust Steam % Moisture

Exhaust Flow Rate (acfm or dscfm)

Exhaust Temperature (deg C or deg F)

Fuel Type Selection

Fuel Input Rate

Sample 1

Fuel Input Rate 

Sample 2

Fuel Input Rate 

Sample 3

Emission Test Results

Formaldehyde 

Emission Rate 

Sample 1 

(lb/MMBtu)

Formaldehyde 

Emission Rate 

Sample 1 

(ppmvd @ 7% O2)

Formaldehyde 

Emission Rate 

Sample 2 

(lb/MMBtu)
Unit of Measure

Other Supporting 

Information

1000 lb/hr

MMBtu/hr

N/A

%

Unit of Measure

Fuel Flow 

Measurement 

Method

Other Supporting 

Information

Formaldehyde 

Emission Rate 

Sample 2 

(ppmvd @ 7% O2)

Formaldehyde 

Emission Rate 

Sample 3 

(lb/MMBtu)

Formaldehyde 

Emission Rate 

Sample 3 

(ppmvd @ 7% O2)

Test Method Used

(ex. U.S. EPA

Method 320)
Other Supporting 

Information
EIA Facility Code Facility Name Boiler ID

997 Michigan City Unit 12

Parameter Sample 1 Sample 2

Date of Testing

Steam Output (1000 lb/hr)

Total Heat Input (MMBtu/hr)

Basis (Wet/Dry)

Exhaust Steam % Moisture

Exhaust Flow Rate (acfm or dscfm)

Exhaust Temperature (deg C or deg F)

Fuel Type Selection

Fuel Input Rate

Sample 1

Fuel Input Rate 

Sample 2

Emission Test Results

Methane Emission Rate 

Sample 1

 (lb/MMBtu)

Methane Emission Rate 

Sample 1

(ppmvd @ 7% O2)
Sample 3 Unit of Measure

Other Supporting 

Information

1000 lb/hr

MMBtu/hr

N/A

%

Fuel Input Rate 

Sample 3 Unit of Measure

Fuel Flow Measurement 

Method

Other Supporting 

Information

Methane Emission Rate 

Sample 2 

(lb/MMBtu)

Methane Emission Rate 

Sample 2 

(ppmvd @ 7% O2)

Methane Emission Rate 

Sample 3 

(lb/MMBtu)

Methane Emission Rate 

Sample 3 

(ppmvd @ 7% O2)
Test Method Used

(ex. U.S. EPA

Method 18)

Other Supporting 

Information
EIA Facility Code Facility Name Boiler ID

997 Michigan City Unit 12

Parameter Sample 1 Sample 2 Sample 3

Date of Testing

Steam Output (1000 lb/hr)

Total Heat Input (MMBtu/hr)

Basis (Wet/Dry)

Exhaust Steam % Moisture

Exhaust Flow Rate (acfm or dscfm)

Exhaust Temperature (deg C or deg F)

Fuel Type Selection

Fuel Input Rate

Sample 1

Fuel Input Rate 

Sample 2

Fuel Input Rate 

Sample 3

Emission Test Results

SO2 Emission Rate 

Sample 1

 (lb/MMBtu)

SO2 Emission Rate 

Sample 1

(ppmvd @ 7% O2)

SO2 Emission Rate 

Sample 2 

(lb/MMBtu)
Unit of Measure

Other Supporting 

Information

1000 lb/hr

MMBtu/hr

N/A

%

Unit of Measure

Fuel Flow 

Measurement Method

Other Supporting 

Information

SO2 Emission Rate 

Sample 2 

(ppmvd @ 7% O2)

SO2 Emission Rate 

Sample 3 

(lb/MMBtu)

SO2 Emission Rate 

Sample 3 

(ppmvd @ 7% O2)

Test Method Used

(ex. U.S. EPA

Method 6)
Other Supporting 

Information
EIA Facility Code Facility Name Boiler ID

997 Michigan City Unit 12

Parameter Sample 1 Sample 2

Date of Testing 3/10/2010 3/11/2010

Steam Output (1000 lb/hr) 32,000 33,000

Total Heat Input (MMBtu/hr) 4,420 4,295

Basis (Wet/Dry) Dry Dry

Exhaust Steam % Moisture 7.08 6.92

Exhaust Flow Rate (acfm or dscfm) 1,196,818 1,202,596

Exhaust Temperature (deg C or deg F) 74 66

Fuel Type Selection

Fuel Input Rate

Sample 1

Fuel Input Rate 

Sample 2

bituminous 4,420 4,295

Emission Test Results

Total Vapor Phase 

Mercury Emission Rate 

Sample 1

 (lb/MMBtu)

Total Vapor Phase 

Mercury Emission Rate 

Sample 2 

(lb/MMBtu)

3.25E-06 3.66E-06

Data Sheets and QA/QC Documentation

trap ID Section 1 

Run 1A 46459 328

Run 1B 65480 602

Run 2A 46409 369

Run 2B 65471 650

Run 3A 46428 382

Run 3B 68502 693

Start

Run 1A 10-Mar 8:45

Run 1B 10-Mar 8:45

Run 2A 11-Mar 6:30

Run 2B 11-Mar 6:30

Summary of Hg Collected on Sorbent Traps via Me

Run ID

Appartioned Mass (ng)

Individual Sorbent Tube Emiss

Run ID Test Date Run Time
Run 3A 11-Mar 11:35

Run 3B 11-Mar 11:35

Averages

Average R Vol. diff (%)

94.349 -5.81%

94.349 0.17%

94.349 5.85%

% Limit

1A 0.335365854

1B 0.099667774

2A 0.298102981

2B 0.092307692

3A 0.157068063

3B 0.25974026

Run ID

Sorbent Trap Breakthrough (B)

Summary of M30B Quality Assurance Checks

Run ID Volume Sampled (dscm)

≤ 10% of Section 1 Hg 

mass for Hg conc. >1 

μg/dscm: or ≤ 20% of 

Section 1 for Hg conc.≤1 

μg/dscm
Sample 3 Unit of Measure

Other Supporting 

Information

3/11/2010

33,000 1000 lb/hr Plant Data

4,335 MMBtu/hr Plant Data

Dry N/A

6.52 %

1,197,709 dscfm

76 deg F

Fuel Input Rate 

Sample 3 Unit of Measure

Fuel Flow 

Measurement 

Method

Other Supporting 

Information

4,335 MMBtu/hr F-Factor From CEMS

Total Vapor Phase 

Mercury Emission Rate 

Sample 3 

(lb/MMBtu)

Test Method Used

(ex. U.S. EPA

Method 30B)

Other Supporting 

Information

4.30E-06 U.S. EPA Method 30B

Total Mass (ng)

Section 2 Sections 1+2 (ng) (ug)

1.1 329.1 0 329.1 0.3291

0.6 602.6 300 302.6 0.3026

1.1 370.1 0 370.1 0.3701

0.6 650.6 300 350.6 0.3506

0.6 382.6 0 382.6 0.3826

1.8 694.8 300 394.8 0.3948

Stop per tube per run per tube per run

10:45 3.38 3.38

10:45 3.11 3.11

8:36 3.76 3.76

8:36 3.56 3.56

f Hg Collected on Sorbent Traps via Method 30B

Initial Spike (ng) Total Non-spike

Individual Sorbent Tube Emission Summary, Method 30B

Run Time Hg Emissions(lb/Tbtu) Hg Emissions (lb/hr)
13:41 4.24 4.24

13:41 4.36 4.36

3.735 #DIV/0!

Limit Abs. diff. % Limit

Crec R (%) by Run R (%) by program Limit

4.160246533 ≥10 % RD mass for 

Hg conc. >1 

μg/dscm: or ≤20% 

RD or ≤0.2 μg/dscm 

abs.diff. for Hg conc. 

≤1 μg/dscm

0.2 2.732240437

M30B Quality Assurance Checks

≤20% of field recovery

test

0.27

94.31666667

Average Recovery, 

between 85 and 

115%

Paired Trap Agreement (RD)

0.12 1.395348837

99.81

88.93

Measured Spike Recovery ( R )

94.21
per tube per run

Hg Emissions (lb/yr)*
#DIV/0!

99.794

94.23

89.023 Spiked

94.349 Average R

99.835

94.19

88.834

94.286 Non Spiked



EIA Facility Code Facility Name Boiler ID

997 Michigan City Unit 12

Parameter Sample 1 Sample 2

Date of Testing

Steam Output (1000 lb/hr)

Total Heat Input (MMBtu/hr)

Basis (Wet/Dry)

Exhaust Steam % Moisture

Exhaust Flow Rate (acfm or dscfm)

Exhaust Temperature (deg C or deg F)

Fuel Type Selection

Fuel Input Rate

Sample 1

Fuel Input Rate 

Sample 2

Emission Test Results Mercury Species

Mercury Emission Rate 

Sample 1

 (lb/MMBtu)

Hg0

Hg+2

HgP
Sample 3 Unit of Measure

Other Supporting 

Information

1000 lb/hr

MMBtu/hr

N/A

%

Fuel Input Rate 

Sample 3 Unit of Measure

Fuel Flow 

Measurement 

Method

Other Supporting 

Information

Mercury Emission Rate 

Sample 2 

(lb/MMBtu)

Mercury Emission Rate 

Sample 3 

(lb/MMBtu)

Test Method Used

(ex. ASTM Method 

D6784)

Other Supporting 

Information
EIA Facility Code Facility Name Boiler ID

997 Michigan City Unit 12

Parameter Sample 1 Sample 2

Date of Testing

Steam Output (1000 lb/hr)

Total Heat Input (MMBtu/hr)

Basis (Wet/Dry)

Exhaust Steam % Moisture

Exhaust Flow Rate (acfm or dscfm)

Exhaust Temperature (deg C or deg F)

Fuel Type Selection

Fuel Input Rate

Sample 1

Fuel Input Rate 

Sample 2

Compound 

(use drop down to define for as many 

rows as needed)

Volatile Organic HAP 

Emission Rate Sample 

1 

(lb/MMBtu)

Volatile Organic HAP 

Emission Rate Sample 

1 

(ppmvd @ 7% O2)

Speciated Volatile Organic HAP Emission Data


Sample 3 Unit of Measure

Other Supporting 

Information

1000 lb/hr

MMBtu/hr

N/A

%

Fuel Input Rate 

Sample 3 Unit of Measure

Fuel Flow 

Measurement 

Method

Other Supporting 

Information

Volatile Organic 

HAP Emission Rate 

Sample 2 

(lb/MMBtu)

Volatile Organic 

HAP Emission 

Rate Sample 2

(ppmvd @ 7% O2)

Volatile Organic 

HAP Emission 

Rate Sample 3 

(lb/MMBtu)

Volatile Organic 

HAP Emission 

Rate Sample 3

(ppmvd @ 7% O2)


Test Method Used Other Supporting Information


EIA Facility Code Facility Name Boiler ID

997 Michigan City Unit 12

Parameter Sample 1 Sample 2

Date of Testing

Steam Output (1000 lb/hr)

Total Heat Input (MMBtu/hr)

Basis (Wet/Dry)

Exhaust Steam % Moisture

Exhaust Flow Rate (acfm or dscfm)

Exhaust Temperature (deg C or deg F)

Fuel Type Selection

Fuel Input Rate

Sample 1

Fuel Input Rate 

Sample 2

Compound 

(use drop down to define for as 

many rows as needed)

Semi-Volatile Organic HAP 

Emission Rate 

Sample 1 

(lb/MMBtu)

Semi-Volatile Organic HAP 

Emission Rate 

Sample 1 

(ppmvd @ 7% O2)

Aminoazobenzene

Speciated Semi Volatile Organic HAP Emission Data




Sample 3 Unit of Measure

Other Supporting 

Information

1000 lb/hr

MMBtu/hr

N/A

%

Fuel Input Rate 

Sample 3 Unit of Measure

Fuel Flow Measurement 

Method

Semi-Volatile Organic HAP 

Emission Rate 

Sample 2 

(lb/MMBtu)

Semi-Volatile Organic HAP 

Emission Rate 

Sample 2 

(ppmvd @ 7% O2)

Semi-Volatile Organic HAP 

Emission Rate 

Sample 3 

(lb/MMBtu)




Other Supporting Information

Semi-Volatile Organic HAP 

Emission Rate 

Sample 3 

(ppmvd @ 7% O2) Test Method Used




Other Supporting Information




EIA Facility Code Facility Name Boiler ID

997 Michigan City Unit 12

Parameter Sample 1 Sample 2 Sample 3

Date of Testing

Steam Output (1000 lb/hr)

Total Heat Input (MMBtu/hr)

Basis (Wet/Dry)

Exhaust Steam % Moisture

Exhaust Flow Rate (acfm or dscfm)

Exhaust Temperature (deg C or deg F)

Fuel Type Selection

Fuel Input Rate

Sample 1

Fuel Input Rate 

Sample 2

Fuel Input Rate 

Sample 3

Emission Test Results

Hydrogen Cyanide 

Emission Rate 

Sample 1

 (lb/MMBtu)

Hydrogen Cyanide 

Emission Rate 

Sample 2 

(lb/MMBtu)

Hydrogen Cyanide 

Emission Rate 

Sample 3 

(lb/MMBtu)
Unit of Measure

Other Supporting 

Information

1000 lb/hr

MMBtu/hr

N/A

%

Unit of Measure

Fuel Flow 

Measurement 

Method

Test Method Used

(ex. U.S. EPA Conditional Test Method 033)

Other Supporting 

Information
Other Supporting Information
EIA Facility Code Facility Name Boiler ID

997 Michigan City Unit 12

Parameter Sample 1 Sample 2

Date of Testing

Steam Output (1000 lb/hr)

Total Heat Input (MMBtu/hr)

Basis (Wet/Dry)

Exhaust Steam % Moisture

Exhaust Flow Rate (acfm or dscfm)

Exhaust Temperature (deg C or deg F)

Fuel Type Selection

Fuel Input Rate

Sample 1

Fuel Input Rate 

Sample 2

Emission Test Results Constituent

Consitutent Emission Rate 

Sample 1

 (%)

O2

CO2
Sample 3 Unit of Measure

Other Supporting 

Information

1000 lb/hr

MMBtu/hr

N/A

%

Fuel Input Rate 

Sample 3 Unit of Measure

Fuel Flow 

Measurement Method

Other Supporting 

Information

Consitutent Emission Rate 

Sample 2 

(%)

Consitutent Emission Rate 

Sample 3 

(%)

Test Method Used

(ex. U.S. EPA Method 

3B)

Other Supporting 

Information
EIA Facility Code Facility Name Boiler ID

997 Michigan City Unit 12

Parameter Sample 1 Sample 2

Date of Testing

Steam Output (1000 lb/hr)

Total Heat Input (MMBtu/hr)

Basis (Wet/Dry)

Exhaust Steam % Moisture

Exhaust Flow Rate (acfm or dscfm)

Exhaust Temperature (deg C or deg F)

Fuel Type Selection

Fuel Input Rate

Sample 1

Fuel Input Rate 

Sample 2

Emission Test Results Constituent

Nitrogen Oxides Emission Rate 

Sample 1 

(lb/MMBtu)

NO

NO2
Sample 3 Unit of Measure Other Supporting Information

1000 lb/hr

MMBtu/hr

N/A

%

Fuel Input Rate 

Sample 3 Unit of Measure Fuel Flow Measurement Method

Nitrogen Oxides Emission Rate 

Sample 1

(ppmvd @ 7% O2)

Nitrogen Oxides Emission Rate 

Sample 2 

(lb/MMBtu)

Nitrogen Oxides Emission Rate 

Sample 2

(ppmvd @ 7% O2)
Other Supporting Information

Nitrogen Oxides Emission Rate 

Sample 3 

(lb/MMBtu)

Nitrogen Oxides Emission Rate 

Sample 3

(ppmvd @ 7% O2)

Test Method Used

(ex. U.S. EPA Method 7)
Other Supporting 

Information
EIA Facility Code Facility Name Boiler ID

997 Michigan City Unit 12

Parameter Sample 1 Sample 2

Date of Testing

Steam Output (1000 lb/hr)

Total Heat Input (MMBtu/hr)

Basis (Wet/Dry)

Exhaust Steam % Moisture

Exhaust Flow Rate (acfm or dscfm)

Exhaust Temperature (deg C or deg F)

Fuel Type Selection

Fuel Input Rate

Sample 1

Fuel Input Rate 

Sample 2

Emission Test Results Constituent

Constituent Emission 

Rate Sample 1 

(mg solids/liter)

Total Dissolved Solids (TDS)

Total Suspended Solids (TSS)
Sample 3 Unit of Measure

1000 lb/hr

MMBtu/hr

N/A

%

Fuel Input Rate 

Sample 3 Unit of Measure

Constituent Emission Rate 

Sample 2 

(mg solids/liter)

Constituent Emission Rate 

Sample 3 

(mg solids/liter)
Other Supporting Information

Fuel Flow Measurement Method

Test Method Used

(ex. Standard Test Method for Filterable and Nonfilterable Matter in Water ASTM 

D5907)
Other Supporting 

Information

Other Supporting 

Information