Instructions for  filling Mercury Emission Reporting Informat

This spreadsheet is intended for you to enter information about  Historic Mercury emissio

boiler, based on reading from continuous emissions monitoring systems(CEMS) data.  Ple

hourly data and daily data.  Fields required in each worksheet are highlighted in yellow.  G

for you.   Green cells require you to choose a value from a drop‐down box.  Please name e

the following naming convention:   [FacilityID]_Unit_[BoilerID]_HgCEMS.xls  (example:  81

Unit Information Worksheet

1.  Boiler information including EIA Facility Code, Facility Name, Boiler ID, and Unit Type a

whether other information is provided on this worksheet.

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

values.

CEMS Data Hourly

The CEMS Data Hourly worksheet is based upon Pt. 75 App. F or 40 CFR CH I (7‐1‐07 Editio

on Equation F‐28 and F‐29.  There are a few additional entries required.   You are required

emission data for the following species of mercury, if recorded by your CEMS:  Hg, Hg0, an

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

2.  Please enter the total Hg emissions(ounces), total Hg fluegas concentration, concentra

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 opera

fraction of the stack gas.

4.  Please enter the heat input (MMBtu/hr), average load for the hour of the reading (MW

Instructions for  filling Mercury Emission Reporting Informat

This spreadsheet is intended for you to enter information about  Historic Mercury emissio

boiler, based on reading from continuous emissions monitoring systems(CEMS) data.  Ple

hourly data and daily data.  Fields required in each worksheet are highlighted in yellow.  G

for you.   Green cells require you to choose a value from a drop‐down box.  Please name e

the following naming convention:   [FacilityID]_Unit_[BoilerID]_HgCEMS.xls  (example:  81

Unit Information Worksheet

1.  Boiler information including EIA Facility Code, Facility Name, Boiler ID, and Unit Type a

whether other information is provided on this worksheet.

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

values.

CEMS Data Hourly

The CEMS Data Hourly worksheet is based upon Pt. 75 App. F or 40 CFR CH I (7‐1‐07 Editio

on Equation F‐28 and F‐29.  There are a few additional entries required.   You are required

emission data for the following species of mercury, if recorded by your CEMS:  Hg, Hg0, an

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

2.  Please enter the total Hg emissions(ounces), total Hg fluegas concentration, concentra

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 opera

fraction of the stack gas.

4.  Please enter the heat input (MMBtu/hr), average load for the hour of the reading (MW

used).

The CEMS Data Daily worksheet represents data rolled up from the hourly values, as appr

following information:

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

2.  Please enter the total Hg emissions(ounces), total Hg fluegas concentration, concentra

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), un

and average moisture fraction of the stack gas.

5.  Please enter the average heat input (MMBtu/hr), average daily load (MW Gross), and t
tion

ons at your facility for each

ease provide both your boiler's

Gray cells are automtically filled

each resulting spreadsheet with

100_Unit_2_HgCEMS.xls).

are required regardless of

the mercury emission limit

on).  The basic entries are based

d to report historic mercury

nd Hg+2.

ch data record.

ation unit of measure, and the

ating time (hr), and moisture

W Gross), and the F‐Factor (if

tion

ons at your facility for each

ease provide both your boiler's

Gray cells are automtically filled

each resulting spreadsheet with

100_Unit_2_HgCEMS.xls).

are required regardless of

the mercury emission limit

on).  The basic entries are based

d to report historic mercury

nd Hg+2.

ch data record.

ation unit of measure, and the

ating time (hr), and moisture

W Gross), and the F‐Factor (if

ropriate.  Please provide the

ation unit of measure, and the

nit or stack operating time (hr),

the F‐Factor (if used).
EIA Facility 

Code Facility Name Boiler ID

Hg Emission Limit 1

(If Applicable) Emission Limit 1 Units

887 Electric Eenrgy, Inc No Hg emission Limits for Electric Energy, Inc.
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
EIA Facility Code Facility Name Boiler ID

887 Electric Eenrgy, 0 See Tabs for Common Stacks 1, 2, and

Collection Date

Collection 

Hour

Hourly Total 

Mercury (Hg) 

Emissions 

(ounces)

Hourly Total 

Mercury (Hg) 

Fluegas 

Concentration

Unit of 

Measure
d 3

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)

Ref. CEM Hourly Mass Emission Data Based on 40 CFR 
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)

Ch. I Pt. 75 App. F (either Wet or Dry Basis)
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=....)
EIA Facility Code Boiler ID

887 Common Stack 1, Units 1 & 2

Start Date End Date

Daily Total 

Mercury (Hg) 

Fluegas 

Concentration

Unit of 

Measure

Average 

Mercury 

Emission Rate 

(ounces/hr)

Average 

Fluegas 

Flowrate 

(mmscfh)

07/06/09 07/10/09 4.76 μg/dscm 0.206 47.16

08/24/09 08/28/09 3.05 μg/dscm 0.123 43.75

08/31/09 09/04/09 2.62 μg/dscm 0.113 47.16

09/14/09 09/18/09 2.96 μg/dscm 0.125 45.98

09/21/09 09/25/09 2.42 μg/dscm 0.104 46.87

09/29/09 10/02/09 2.92 μg/dscm 0.122 45.48

10/27/09 10/27/09 2.97 μg/dscm 0.142 52.26

10/27/09 10/27/09 2.20 μg/dscm 0.105 51.92

10/27/09 10/27/09 2.21 μg/dscm 0.101 49.88

CEM Daily Mass Emission Data Based on Hourly Data (either We
Average 

Heat Input 

(MMBtu/hr)

F-Factor

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

3232.7 1840

2927.8 1840

3240.4 1840

3148.7 1840

2759.3 1840

2721.3 1840

3635.8 1840

3611.5 1840

3442.7 1840

et or Dry Basis)
EIA Facility Code Boiler ID

887 Common Stack 2, Units 3 & 4

Start Date End Date

Daily Total 

Mercury (Hg) 

Fluegas 

Concentration

Unit of 

Measure

Average 

Mercury 

Emission Rate 

(ounces/hr)

Average 

Fluegas 

Flowrate 

(mmscfh)

08/07/09 08/10/09 2.37 μg/dscm 0.098 44.99

08/14/09 08/17/09 3.38 μg/dscm 0.146 47.05

08/17/09 08/21/09 3.32 μg/dscm 0.137 45.07

08/21/09 08/24/09 3.33 μg/dscm 0.138 45.26

08/24/09 08/28/09 3.76 μg/dscm 0.157 45.50

08/31/09 09/04/09 3.11 μg/dscm 0.132 46.42

09/08/09 09/11/09 3.28 μg/dscm 0.141 46.89

09/14/09 09/18/09 3.44 μg/dscm 0.149 47.13

09/21/09 09/25/09 3.03 μg/dscm 0.131 47.33

10/06/09 10/06/09 2.97 μg/dscm 0.136 49.93

10/08/09 10/08/09 3.51 μg/dscm 0.169 52.27

10/08/09 10/08/09 2.45 μg/dscm 0.103 45.93

10/13/09 10/13/09 3.72 μg/dscm 0.180 52.66

10/13/09 10/13/09 2.87 μg/dscm 0.138 52.36

10/28/09 10/28/09 3.90 μg/dscm 0.185 51.61

10/28/09 10/28/09 3.97 μg/dscm 0.188 51.66

10/28/09 10/28/09 3.97 μg/dscm 0.188 51.48

CEM Daily Mass Emission Data Based on Hourly Data (either We
Average 

Heat Input 

(MMBtu/hr)

F-Factor

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

2535.4 1840

3099.0 1840

2968.1 1840

2981.2 1840

2971.6 1840

3065.3 1840

3014.4 1840

3045.9 1840

3166.6 1840

3424.6 1840

3615.1 1840

3123.7 1840

3571.4 1840

3569.1 1840

3534.09 1840

3509.17 1840

3525.19 1840

et or Dry Basis)
EIA Facility Code Boiler ID

887 Common Stack 3, Units 5 & 6

Start Date End Date

Daily Total 

Mercury (Hg) 

Fluegas 

Concentration

Unit of 

Measure

Average 

Mercury 

Emission Rate 

(ounces/hr)

Average 

Fluegas 

Flowrate 

(mmscfh)

07/24/09 07/27/09 2.67 μg/dscm 0.102 41.62

07/27/09 07/31/09 3.33 μg/dscm 0.142 46.49

07/31/09 08/03/09 3.10 μg/dscm 0.136 47.76

08/03/09 08/07/09 3.07 μg/dscm 0.137 48.64

08/07/09 08/10/09 3.19 μg/dscm 0.148 50.45

08/31/09 09/04/09 3.00 μg/dscm 0.072 26.12

09/14/09 09/18/09 3.15 μg/dscm 0.139 47.97

09/21/09 09/25/09 3.11 μg/dscm 0.137 47.99

09/28/09 09/28/09 3.68 μg/dscm 0.181 53.55

09/29/09 10/02/09 3.45 μg/dscm 0.151 47.80

10/06/09 10/06/09 3.01 μg/dscm 0.148 53.61

10/13/09 10/13/09 4.41 μg/dscm 0.216 53.30

10/13/09 10/13/09 3.06 μg/dscm 0.152 54.05

10/19/09 10/23/09 2.06 μg/dscm 0.100 52.77

10/29/09 10/29/09 3.45 μg/dscm 0.170 53.87

10/29/09 10/29/09 3.26 μg/dscm 0.162 54.13

10/29/09 10/29/09 3.25 μg/dscm 0.162 54.36

11/30/09 12/04/09 2.62 μg/dscm 0.130 53.96

12/04/09 12/07/09 3.00 μg/dscm 0.146 53.00

12/07/09 12/11/09 3.21 μg/dscm 0.156 53.03

12/11/09 12/14/09 2.97 μg/dscm 0.150 54.88

CEM Daily Mass Emission Data Based on Hourly Data (either We
Average 

Heat Input 

(MMBtu/hr)

F-Factor

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

2451.2 1840

3058.3 1840

3208.4 1840

3266.3 1840

3373.3 1840

1633.0 1840

3168.8 1840

3189.4 1840

3594.3 1840

3185.2 1840

3573.9 1840

3524.1 1840

3559.5 1840

2733.4 1840

3688.9 1840

3706.7 1840

3722.5 1840

3658.4 1840

3250.5 1840

3526.1 1840

3844.8 1840

et or Dry Basis)