Instructions for Completing the Process Data Template

This template is to be used to record the 30 daily averages of specific process data required by the ICR. The ERT d

have the capability to store these daily averages. This spreadsheet included 4 separate surrogate worksheets, in 

boiler tested is tested for all surrogates at 4 different dates. This spreadsheet is intended to be used for one boi

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

yellow are required (if applicable to your boilers' operation). You do not need to populate cells shaded in gray, a

automatically populated from the Boiler Information worksheet. Please Do Not modify the structure of this spr

by adding or subtracting rows, columns, cells. Please name each resulting spreadsheet with the following nami

convention: [FacilityID]_Unit_[BoilerID]_Processdata.xls (example: 8100_Unit_2_Processdata.xls).

Please refer to the following steps when using these spreadsheets.

Boiler Information Worksheet

Please enter the EIA Facility Code, Facility Name and Boiler ID of your boiler on the Boiler Information workshee

Process Data Worksheets

Please use one process data worksheet for each HAP surrogate even is simultaneous testing of different HAP sur

was done. 
ta Template

s data required by the ICR. The ERT does not 

4 separate surrogate worksheets, in case the 

t is intended to be used for one boiler of one 

es of this spreadsheet. Fields shaded in 

d to populate cells shaded in gray, as they are 

Not modify the structure of this spreadsheet 

preadsheet with the following naming 

nit_2_Processdata.xls).

on the Boiler Information worksheet. 

taneous testing of different HAP surrogates 
EIA Facility Code Facility Name Boiler ID

2408 Mercer Generating Station 1
EIA Facility Code Facility Name Boiler ID Unit was not tested for this Group

Daily Average Process Data for a 30 Day Period Including the Testing Date

Date Coal Firing Rate Coal Firing Rate (units) Synfuel Firing Rate

Day 1

Day 2

Day 3

Day 4

Day 5

Day 6

Day 7

Day 8

Day 9

Day 10

Day 11

Day 12

Day 13

Day 14

Day 15

Day 16

Day 17

Day 18

Day 19

Day 20

Day 21

Day 22

Day 23

Day 24

Day 25

Day 26

Day 27

Day 28

Day 29

Day 30
he Testing Date

Synfuel Firing Rate (units) Pet Coke Firing Rate Pet Coke Firing Rate (units) Coal Gas Firing Rate
Coal Gas Firing Rate (units) Fuel oil Firing Rate Fuel oil Firing Rate (units)
Average Heat Input (MMBtu/hr) Steam Output (1,000 lbs steam/hr)
Unit Net Electric Generation (MWh) Unit Gross Electric Generation (MWe)
Control Device Operating Parameters, As Appicable

Flue Gas Flow Rate (dscfm) Pressure Drop across FGD (in H2O)
FGD Scrubber Liquor Flow Rate (gals/min) Sorbent Type Sorbent Injection Rate (lb/hr)
Other Boiler or Control Device Operating Parameters (e.g., Boiler O2) 

Flue Gas Pressure (atm) Flue Gas Sampling Point Temperature (Deg F)
Flue Gas Oxygen Content (%) Flue Gas Carbon Dioxide Content (%) Flue Gas Moisture Content (%)
EIA Facility Code Facility Name Boiler ID Unit was not tested for this Group

Daily Average Process Data for a 30 Day Period Including the Testing Date

Date Coal Firing Rate Coal Firing Rate (units) Synfuel Firing Rate

Day 1

Day 2

Day 3

Day 4

Day 5

Day 6

Day 7

Day 8

Day 9

Day 10

Day 11

Day 12

Day 13

Day 14

Day 15

Day 16

Day 17

Day 18

Day 19

Day 20

Day 21

Day 22

Day 23

Day 24

Day 25

Day 26

Day 27

Day 28

Day 29

Day 30
he Testing Date

Synfuel Firing Rate (units) Pet Coke Firing Rate Pet Coke Firing Rate (units) Coal Gas Firing Rate
Coal Gas Firing Rate (units) Fuel oil Firing Rate Fuel oil Firing Rate (units)
Average Heat Input (MMBtu/hr) Steam Output (1,000 lbs steam/hr)
Unit Net Electric Generation (MWh) Unit Gross Electric Generation (MWe)
Control Device Operating Parameters, As Appicable

Flue Gas Flow Rate (dscfm) Pressure Drop across FGD (in H2O)
FGD Scrubber Liquor Flow Rate (gals/min) Sorbent Type Sorbent Injection Rate (lb/hr)
Other Boiler or Control Device Operating Parameters (e.g., Boiler O2) 

Flue Gas Pressure (atm) Flue Gas Sampling Point Temperature (Deg F)
Flue Gas Oxygen Content (%) Flue Gas Carbon Dioxide Content (%) Flue Gas Moisture Content (%)
EIA Facility Code Facility Name Boiler ID Unit was not tested for this Group

Daily Average Process Data for a 30 Day Period Including the Testing Date

Date Coal Firing Rate Coal Firing Rate (units) Synfuel Firing Rate

Day 1

Day 2

Day 3

Day 4

Day 5

Day 6

Day 7

Day 8

Day 9

Day 10

Day 11

Day 12

Day 13

Day 14

Day 15

Day 16

Day 17

Day 18

Day 19

Day 20

Day 21

Day 22

Day 23

Day 24

Day 25

Day 26

Day 27

Day 28

Day 29

Day 30
he Testing Date

Synfuel Firing Rate (units) Pet Coke Firing Rate Pet Coke Firing Rate (units) Coal Gas Firing Rate
Coal Gas Firing Rate (units) Fuel oil Firing Rate Fuel oil Firing Rate (units)
Average Heat Input (MMBtu/hr) Steam Output (1,000 lbs steam/hr)
Unit Net Electric Generation (MWh) Unit Gross Electric Generation (MWe)
Control Device Operating Parameters, As Appicable

Flue Gas Flow Rate (dscfm) Pressure Drop across FGD (in H2O)
FGD Scrubber Liquor Flow Rate (gals/min) Sorbent Type Sorbent Injection Rate (lb/hr)
Other Boiler or Control Device Operating Parameters (e.g., Boiler O2) 

Flue Gas Pressure (atm) Flue Gas Sampling Point Temperature (Deg F)
Flue Gas Oxygen Content (%) Flue Gas Carbon Dioxide Content (%) Flue Gas Moisture Content (%)
EIA Facility Code Facility Name Boiler ID

2408 Mercer Generating Station 1

Daily Average Process Data for a 30 Day Period Including the Testing Date

Date Coal Firing Rate Coal Firing Rate (units) Synfuel Firing Rate

Day 1 1/25/2010 78.86 tons/hr NA

Day 2 1/26/2010 80.07 tons/hr NA

Day 3 1/27/2010 54.56 tons/hr NA

Day 4 1/28/2010 83.82 tons/hr NA

Day 5 1/29/2010 85.10 tons/hr NA

Day 6 1/30/2010 92.93 tons/hr NA

Day 7 1/31/2010 81.37 tons/hr NA

Day 8 2/1/2010 81.19 tons/hr NA

Day 9 2/2/2010 79.30 tons/hr NA

Day 10 2/3/2010 80.39 tons/hr NA

Day 11 2/4/2010 85.75 tons/hr NA

Day 12 2/5/2010 83.58 tons/hr NA

Day 13 2/6/2010 71.48 tons/hr NA

Day 14 2/7/2010 83.56 tons/hr NA

Day 15 2/8/2010 90.65 tons/hr NA

Day 16 2/9/2010 86.87 tons/hr NA

Day 17 2/10/2010 81.27 tons/hr NA

Day 18 2/11/2010 82.15 tons/hr NA

Day 19 2/12/2010 84.18 tons/hr NA

Day 20 2/13/2010 86.70 tons/hr NA

Day 21 2/14/2010 78.75 tons/hr NA

Day 22 2/15/2010 87.76 tons/hr NA

Day 23 2/16/2010 82.29 tons/hr NA

Day 24 2/17/2010 81.66 tons/hr NA

Day 25 2/18/2010 77.79 tons/hr NA

Day 26 2/19/2010 75.28 tons/hr NA

Day 27 2/20/2010 67.92 tons/hr NA

Day 28 2/21/2010 28.72 tons/hr NA

Day 29 2/22/2010 57.09 tons/hr NA

Day 30 2/23/2010 78.35 tons/hr NA
he Testing Date

Synfuel Firing Rate (units) Pet Coke Firing Rate Pet Coke Firing Rate (units) Coal Gas Firing Rate

NA NA NA NA

NA NA NA NA

NA NA NA NA

NA NA NA NA

NA NA NA NA

NA NA NA NA

NA NA NA NA

NA NA NA NA

NA NA NA NA

NA NA NA NA

NA NA NA NA

NA NA NA NA

NA NA NA NA

NA NA NA NA

NA NA NA NA

NA NA NA NA

NA NA NA NA

NA NA NA NA

NA NA NA NA

NA NA NA NA

NA NA NA NA

NA NA NA NA

NA NA NA NA

NA NA NA NA

NA NA NA NA

NA NA NA NA

NA NA NA NA

NA NA NA NA

NA NA NA NA

NA NA NA NA
Coal Gas Firing Rate (units) Fuel oil Firing Rate Fuel oil Firing Rate (units)

NA NA NA

NA NA NA

NA NA NA

NA NA NA

NA NA NA

NA NA NA

NA NA NA

NA NA NA

NA NA NA

NA NA NA

NA NA NA

NA NA NA

NA NA NA

NA NA NA

NA NA NA

NA NA NA

NA NA NA

NA NA NA

NA NA NA

NA NA NA

NA NA NA

NA NA NA

NA NA NA

NA NA NA

NA NA NA

NA NA NA

NA NA NA

NA NA NA

NA NA NA

NA NA NA
Average Heat Input (MMBtu/hr) Steam Output (1,000 lbs steam/hr)

2050.5 NA

2081.8 NA

1418.7 NA

2179.3 NA

2212.6 NA

2416.2 NA

2115.6 NA

2111.0 NA

2061.9 NA

2090.0 NA

2229.5 NA

2173.0 NA

1858.4 NA

2172.5 NA

2356.8 NA

2258.5 NA

2112.9 NA

2136.0 NA

2188.8 NA

2254.2 NA

2047.4 NA

2281.8 NA

2139.6 NA

2123.1 NA

2022.5 NA

1957.3 NA

1765.8 NA

746.6 NA

1484.3 NA

2037.0 NA
Unit Net Electric Generation (MWh) Unit Gross Electric Generation (MWe)

218.2 237.9

227.2 248.2

136.6 152.9

240.4 260.9

253.0 273.7

278.1 300.2

237.6 257.5

241.7 261.6

213.6 233.2

220.5 239.5

234.3 253.5

228.1 247.4

194.7 212.7

232.8 252.3

265.0 286.2

249.8 270.2

234.8 255.1

232.2 252.1

239.2 259.4

253.6 274.4

225.5 245.0

253.9 274.5

237.2 257.4

234.9 255.0

232.0 252.0

223.3 242.7

181.4 199.4

80.4 94.3

185.7 203.5

217.5 236.6
Control Device Operating Parameters, As Appicable

Flue Gas Flow Rate (dscfm) Pressure Drop across FGD (in H2O)

571000 NA

575746 NA

448729 NA

598996 NA

601133 NA

639062 NA

585254 NA

595475 NA

561225 NA

568296 NA

585150 NA

582654 NA

520667 NA

579879 NA

619346 NA

606538 NA

582808 NA

586200 NA

593812 NA

598204 NA

559517 NA

600637 NA

577396 NA

575208 NA

572092 NA

573342 NA

528800 NA

390804 NA

514817 NA

560817 NA
FGD Scrubber Liquor Flow Rate (gals/min) Sorbent Type Sorbent Injection Rate (lb/hr)

NA Activated Carbon 131.3

NA Activated Carbon 150.8

NA Activated Carbon 100.2

NA Activated Carbon 149.6

NA Activated Carbon 167.9

NA Activated Carbon 182.4

NA Activated Carbon 155.9

NA Activated Carbon 160.5

NA Activated Carbon 150.8

NA Activated Carbon 156.6

NA Activated Carbon 136.4

NA Activated Carbon 138.7

NA Activated Carbon 133.8

NA Activated Carbon 149.5

NA Activated Carbon 196.2

NA Activated Carbon 227.1

NA Activated Carbon 198.2

NA Activated Carbon 186.8

NA Activated Carbon 242.4

NA Activated Carbon 284.1

NA Activated Carbon 284.1

NA Activated Carbon 343.2

NA Activated Carbon 371.7

NA Activated Carbon 369.0

NA Activated Carbon 369.2

NA Activated Carbon 312.7

NA Activated Carbon 194.5

NA Activated Carbon 104.3

NA Activated Carbon 171.8

NA Activated Carbon 227.8
Other Boiler or Control Device Operating Parameters (e.g., Boiler O2) 

Flue Gas Pressure (atm) Flue Gas Sampling Point Temperature (Deg F)

NA 333.5

NA 343.2

NA 363.7

NA 344.2

NA 358.2

NA 352.8

NA 355.1

NA 349.8

NA 349.3

NA 347.1

NA 346.3

NA 343.3

NA 361.6

NA 355.3

NA 349.0

NA 344.4

NA 349.0

NA 349.6

NA 349.7

NA 354.2

NA 359.9

NA 351.0

NA 354.9

NA 356.4

NA 351.0

NA 349.9

NA 354.6

NA 369.0

NA 353.7

NA 349.1
Flue Gas Oxygen Content (%) Flue Gas Carbon Dioxide Content (%) Flue Gas Moisture Content (%)

7.71 12 6

7.95 12 5

9.64 10 4

7.79 12 6

7.54 12 5

6.96 13 6

7.47 12 6

7.90 12 7

7.90 11 4

7.87 11 4

7.36 12 3

7.65 12 4

8.41 11 4

7.55 11 4

7.10 12 5

7.32 12 5

7.86 11 6

7.63 11 6

7.51 12 5

7.23 12 5

7.69 12 5

7.23 12 5

7.73 11 4

7.69 11 4

7.78 10 8

8.31 11 8

9.42 10 2

14.31 5 1

10.99 7 3

7.97 11 5