Instructions for filling Mercury Emission Reporting Information

This spreadsheet is intended for you to enter information about Historic Mercury emissions at your facility for each 

boiler, based on reading from continuous emissions monitoring systems (CEMS) data. Please provide both your boiler's 

hourly data and daily data. Fields required in each worksheet are highlighted in yellow. Gray cells are automtically filled

for you. Green cells require you to choose a value from a drop-down box. Please name each resulting spreadsheet with 

the following naming convention: [FacilityID]_Unit_[BoilerID]_HgCEMS.xls (example: 8100_Unit_2_HgCEMS.xls).

Unit Information Worksheet

1. Boiler information including EIA Facility Code, Facility Name, Boiler ID, and Unit Type are required regardless of 

whether other information is provided on this worksheet.

2. Mercury Emission Limits. Please provide units of measure in the columns that follows the mercury emission limit 

values.

CEMS Data Hourly

The CEMS Data Hourly worksheet is based upon Pt. 75 App. F or 40 CFR CH I (7-1-07 Edition). The basic entries are based 

on Equation F-28 and F-29. There are a few additional entries required. You are required to report historic mercury 

emission data for the following species of mercury, if recorded by your CEMS: Hg, Hg0, and Hg+2.

1. Please enter the collection date (MM/DD/YYYY) and collection hour (HH24:MM) of each data record.

2. Please enter the total Hg emissions (ounces), total Hg fluegas concentration, concentration unit of measure, and the 

average hourly Hg emission factor for each species of Hg (lb/MMBtu).

3. Please provide the fluegas flowrate (scfh), fluegas temperature(°F), unit or stack operating time (hr), and moisture 

fraction of the stack gas.

4. Please enter the heat input (MMBtu/hr), average load for the hour of the reading (MW Gross), and the F-Factor (if 

used).

The CEMS Data Daily worksheet represents data rolled up from the hourly values, as appropriate. Please provide the 

following information:

1. Please enter the collection date (MM/DD/YYYY).

2. Please enter the total Hg emissions (ounces), total Hg fluegas concentration, concentration unit of measure, and the 

average daily Hg emission factor for each species of Hg (lb/MMBtu).

3. Please enter the average mercury emission rate (ounces/hour).

4. Please provide the average fluegas flowrate (scfh), average fluegas temperature(°F), unit or stack operating time (hr), 

and average moisture fraction of the stack gas.

5. Please enter the average heat input (MMBtu/hr), average daily load (MW Gross), and the F-Factor (if used).
EIA Facility 

Code Facility Name Boiler ID

Hg Emission Limit 1

(If Applicable) Emission Limit 1 Units

Hg Emission Limit 2

(If Applicable) Emission Limit 2 Units

Hg Emission Limit 3

(If Applicable) Emission Limit 3 Units

Hg Emission Limit 4

(If Applicable) Emission Limit 4 Units

101 Rawhide 101 0.00174 lbs/GWh (2012 -2017) 0.0087 lbs/GWh (2018)
EIA Facility Code Facility Name Boiler ID

101 Rawhide 101

Collection Date

Collection 

Hour

Hourly Total 

Mercury (Hg) 

Emissions 

(ounces)

Hourly Total 

Mercury (Hg) 

Fluegas 

Concentration

Unit of 

Measure

Average Hourly 

Total Mercury 

(Hg) Emission 

Factor (lb/MMBtu)

Hourly Elemental 

Mercury (Hg0) 

Emissions 

(ounces)

Hourly Elemental 

Mercury (Hg0) 

Fluegas 

Concentration

Unit of 

Measure

Average Hourly 

Elemental 

Mercury (Hg0) 

Emission Factor 

(lb/MMBtu)

Hourly Oxidized 

Mercury (Hg+2) 

Emissions 

(ounces)

Hourly Oxidized 

Mercury (Hg+2) 

Fluegas 

Concentration

Unit of 

Measure

Average Daily 

Oxidized 

Mercury (Hg+2) 

Emission Factor 

(lb/MMBtu)

Fluegas 

Flowrate 

(scfh)

Fluegas 

Temperature 

(°F)

Heat Input 

(MMBtu/hr)

Average 

Load for the 

Hour 

(MW Gross) 

Unit or 

Stack 

Operating 

Time 

(hr)

Moisture 

Fraction of 

the Stack 

Gas

F-Factor

(Fd, Fw, 

or Fc=....)

01/01/2009 00:00 0.097 2.60 μg/wscm 0.000002303 0.084 2.25 μg/wscm 0.000001985 0.013 0.36 μg/wscm 0.000000314 37,439,199 206 2645.2 298.4 1 1840

01/01/2009 01:00 0.128 3.39 μg/wscm 0.000002977 0.095 2.52 μg/wscm 0.000002216 0.033 0.87 μg/wscm 0.000000760 37,662,199 208 2678.7 298.4 1 1840

Ref. CEM Hourly Mass Emission Data Based on 40 CFR Ch. I Pt. 75 App. F (either Wet or Dry Basis)
EIA Facility Code Facility Name Boiler ID

101 Rawhide 101

Collection Date

Daily Total 

Mercury (Hg) 

Emissions 

(ounces)

Daily Total 

Mercury (Hg) 

Fluegas 

Concentration

Unit of 

Measure

Average Daily 

Total Mercury 

(Hg) Emission 

Factor 

(lb/MMBtu)

Daily Elemental 

Mercury (Hg0) 

Emissions (ounces)

Daily Elemental 

Mercury (Hg0) Fluegas 

Concentration

Unit of 

Measure

Average Daily 

Elemental 

Mercury (Hg0) 

Emission 

Factor 

(lb/MMBtu)

Daily Oxidized 

Mercury (Hg+2) 

Emissions 

(ounces)

Daily Oxidized 

Mercury (Hg+2) 

Fluegas 

Concentration

Unit of 

Measure

Average Daily 

Oxidized 

Mercury 

(Hg+2) 

Emission 

Factor 

(lb/MMBtu)

Average Total 

Mercury 

Emission Rate 

(ounces/hr)

Average 

Fluegas 

Flowrate (scfh)

Average 

Fluegas 

Temperature 

(°F)

Average 

Heat Input 

(MMBtu/hr)

Average 

Daily Load 

(MW Gross)

Unit or Stack 

Operating 

Time 

(hr)

Average 

Moisture 

Fraction of 

the Stack 

Gas

F-Factor

(Fd, Fw, or Fc=....)

1/1/2009 2.650 3.40 μg/wscm 0.000002987 1.951 2.63 μg/wscm 0.000002309 0.561 0.78 μg/wscm 0.000000696 0.128 37504035.0 208 2671.9 297.7 24 1840

1/2/2009 2.652 3.65 μg/wscm 0.000003199 1.882 2.82 μg/wscm 0.000002466 0.574 0.88 μg/wscm 0.000000784 0.137 37481483.6 209 2678.0 297.5 24 1840

1/3/2009 2.234 3.08 μg/wscm 0.000002840 1.770 2.57 μg/wscm 0.000002363 0.323 0.51 μg/wscm 0.000000488 0.106 35485388.8 206 2421.8 271.4 24 1840

1/4/2009 2.680 3.47 μg/wscm 0.000003100 1.960 2.66 μg/wscm 0.000002369 0.608 0.84 μg/wscm 0.000000761 0.132 38251556.6 209 2670.2 300.7 24 1840

1/5/2009 1.996 2.62 μg/wscm 0.000002346 1.657 2.34 μg/wscm 0.000002101 0.213 0.31 μg/wscm 0.000000278 0.099 37625504.9 205 2626.9 298.9 24 1840

CEM Daily Mass Emission Data Based on Hourly Data (either Wet or Dry Basis)