Instructions for filling Mercury Emission Reporting Informa t

This spreadsheet is intended for you to enter information about Historic Mercury emissi o boiler, based on reading from continuous emissions monitoring systems (CEMS) data. Pl e 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: 8 1

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 Editi o

on Equation F

‐ 28 and F

‐ 29. There are a few additional entries required. You are require d

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

, a n

1. Please enter the collection date (MM/DD/YYYY) and collection hour (HH24:MM) of ea c
2. Please enter the total Hg emissions (ounces), total Hg fluegas concentration, concentr a

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 oper a fraction of the stack gas.
4. Please enter the heat input (MMBtu/hr), average load for the hour of the reading (M W Instructions for filling Mercury Emission Reporting Informa t

This spreadsheet is intended for you to enter information about Historic Mercury emissi o boiler, based on reading from continuous emissions monitoring systems (CEMS) data. Pl e 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: 8 1

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 Editi o

on Equation F

‐ 28 and F

‐ 29. There are a few additional entries required. You are require d

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

, a n

1. Please enter the collection date (MM/DD/YYYY) and collection hour (HH24:MM) of ea c
2. Please enter the total Hg emissions (ounces), total Hg fluegas concentration, concentr a

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 oper a fraction of the stack gas.
4. Please enter the heat input (MMBtu/hr), average load for the hour of the reading (M W used).

The CEMS Data Daily worksheet represents data rolled up from the hourly values, as app r following information:

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

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

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), u n and average moisture fraction of the stack gas.
5. Please enter the average heat input (MMBtu/hr), average daily load (MW Gross), and ttion

o ns at your facility for each

e ase provide both your boiler's

G ray cells are automtically filled

e ach resulting spreadsheet with

1 00_Unit_2_HgCEMS.xls).

a re required regardless of

the mercury emission limit

o n). The basic entries are based
d to report historic mercury

n d Hg +2

.

c h data record.

ation unit of measure, and the

a ting time (hr), and moisture

W Gross), and the F

‐ Factor (if

tion

o ns at your facility for each

e ase provide both your boiler's

G ray cells are automtically filled

e ach resulting spreadsheet with

1 00_Unit_2_HgCEMS.xls).

a re required regardless of

the mercury emission limit

o n). The basic entries are based
d to report historic mercury

n d Hg +2

.

c h data record.

ation unit of measure, and the

a ting time (hr), and moisture

W Gross), and the F

‐ Factor (if

r opriate. Please provide the

ation unit of measure, and the

nit or stack operating time (hr),

t he F

‐ Factor (if used).EIA Facility Code Facility Name Boiler ID Hg Emission Limit 1 (If Applicable) Emission Limit 1 Units 887 Electric Eenrgy, In c 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 UnitsHg Emission Limit 4 (If Applicable) Emission Limit 4 UnitsEIA Facility Cod e Facility Name Boiler ID 887 Electric Eenrgy, 0 See Tabs for Common Stacks 1, 2, an d

Collection Date Collection
Hour Hourly Total Mercury (Hg)

Emissions (ounces) Hourly Total Mercury (Hg) Fluegas
Concentration Unit of
Measured 3

Average Hourly Total Mercury (Hg)
Emission Factor (lb/MMBtu) Hourly Elemental Mercury (Hg 0 )

Emissions (ounces) Hourly Elemental Mercury (Hg 0 ) Fluegas
Concentration Unit of Measure Average Hourly Elemental Mercury (Hg 0 )
Emission Factor (lb/MMBtu) Ref. CEM Hourly Mass Emission Data Based on 40 CFRHourly 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 W eAverage 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 e t 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 W eAverage 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 e t 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 W eAverage 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 e t or Dry Basis)