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

54081 Spruance Genco, LLC 3
EIA Facility Code Facility Name Boiler ID

54081 Spruance Genco, LLC 3

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

54081 Spruance Genco, LLC 3

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

54081 Spruance Genco, LLC 3

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

54081 Spruance Genco, LLC 3

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 04/01/10 15662 lbs/hr 0

Day 2 04/02/10 19661 lbs/hr 0

Day 3 04/03/10 23239 lbs/hr 0

Day 4 04/04/10 22763 lbs/hr 0

Day 5 04/05/10 50639 lbs/hr 0

Day 6 04/06/10 58827 lbs/hr 0

Day 7 04/07/10 58373 lbs/hr 0

Day 8 04/08/10 53827 lbs/hr 0

Day 9 04/09/10 48640 lbs/hr 0

Day 10 04/10/10 48435 lbs/hr 0

Day 11 04/11/10 40024 lbs/hr 0

Day 12 04/12/10 53347 lbs/hr 0

Day 13 04/13/10 23801 lbs/hr 0

Day 14 04/14/10 45961 lbs/hr 0

Day 15 04/15/10 58467 lbs/hr 0

Day 16 04/16/10 58663 lbs/hr 0

Day 17 04/17/10 41874 lbs/hr 0

Day 18 04/18/10 52376 lbs/hr 0

Day 19 04/19/10 51307 lbs/hr 0

Day 20 04/20/10 56529 lbs/hr 0

Day 21 04/21/10 57172 lbs/hr 0

Day 22 04/22/10 58480 lbs/hr 0

Day 23 04/23/10 54834 lbs/hr 0

Day 24 04/24/10 45842 lbs/hr 0

Day 25 04/25/10 35041 lbs/hr 0

Day 26 04/26/10 42034 lbs/hr 0

Day 27 04/27/10 52651 lbs/hr 0

Day 28 04/28/10 59386 lbs/hr 0

Day 29 04/29/10 56382 lbs/hr 0

Day 30 04/30/10 57873 lbs/hr 0
he Testing Date

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

N/A 0 N/A 0

N/A 0 N/A 0

N/A 0 N/A 0

N/A 0 N/A 0

N/A 0 N/A 0

N/A 0 N/A 0

N/A 0 N/A 0

N/A 0 N/A 0

N/A 0 N/A 0

N/A 0 N/A 0

N/A 0 N/A 0

N/A 0 N/A 0

N/A 0 N/A 0

N/A 0 N/A 0

N/A 0 N/A 0

N/A 0 N/A 0

N/A 0 N/A 0

N/A 0 N/A 0

N/A 0 N/A 0

N/A 0 N/A 0

N/A 0 N/A 0

N/A 0 N/A 0

N/A 0 N/A 0

N/A 0 N/A 0

N/A 0 N/A 0

N/A 0 N/A 0

N/A 0 N/A 0

N/A 0 N/A 0

N/A 0 N/A 0

N/A 0 N/A 0
Coal Gas Firing Rate (units) Fuel oil Firing Rate Fuel oil Firing Rate (units)

N/A 0 N/A

N/A 0 N/A

N/A 0 N/A

N/A 0 N/A

N/A 0 N/A

N/A 0 N/A

N/A 0 N/A

N/A 0 N/A

N/A 0 N/A

N/A 0 N/A

N/A 0 N/A

N/A 0 N/A

N/A 0 N/A

N/A 0 N/A

N/A 0 N/A

N/A 0 N/A

N/A 0 N/A

N/A 0 N/A

N/A 0 N/A

N/A 0 N/A

N/A 0 N/A

N/A 0 N/A

N/A 0 N/A

N/A 0 N/A

N/A 0 N/A

N/A 0 N/A

N/A 0 N/A

N/A 0 N/A

N/A 0 N/A

N/A 0 N/A
Average Heat Input (MMBtu/hr) Steam Output (1,000 lbs steam/hr)

192 139002

241 167875

285 193231

279 187003

622 413172

722 478226

717 483464

661 469641

597 401187

595 390010

491 334950

655 484133

292 481406

564 502589

718 529923

720 505980

514 368682

643 458858

630 455243

694 496668

702 506255

718 496530

673 465969

563 405442

430 297204

516 353705

646 452887

729 501841

692 494633

710 483558
Unit Net Electric Generation (MWh) Unit Gross Electric Generation (MWe)

2.74 4.20

2.13 3.64

1.60 3.14

2.01 3.59

1.75 4.07

14.93 17.51

16.02 18.63

15.16 17.80

2.19 4.70

14.92 17.25

13.63 15.78

31.28 33.89

30.57 33.19

32.21 34.96

35.45 38.29

32.61 35.37

20.63 23.10

27.47 30.28

25.75 28.46

31.47 34.17

31.18 33.87

30.91 33.63

29.45 32.05

22.13 24.60

2.84 5.32

10.34 12.82

26.65 29.43

32.10 34.98

30.21 33.03

32.39 35.06
Control Device Operating Parameters, As Appicable

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

62713 0.91

71825 1.15

80571 1.41

82042 1.43

160933 3.21

166788 3.12

169463 3.26

166375 3.14

160075 3.10

139513 2.64

125400 2.40

162508 3.14

165767 3.24

170525 3.28

173738 3.32

167313 3.22

135921 2.51

155042 2.83

157746 2.94

163113 3.07

166754 3.14

163913 3.06

153142 2.82

142458 2.55

141213 1.97

150448 2.53

159083 3.00

167196 3.16

165450 3.11

157513 2.96
FGD Scrubber Liquor Flow Rate (gals/min) Sorbent Type Sorbent Injection Rate (lb/hr)

0.054 Lime 131

0.067 Lime 158

0.754 Lime 97

1.850 Lime 105

29.032 Lime 294

26.655 Lime 484

19.835 Lime 524

19.291 Lime 548

2.783 Lime 448

0.030 Lime 324

18.187 Lime 277

24.642 Lime 405

17.352 Lime 311

26.295 Lime 473

26.436 Lime 388

24.542 Lime 301

20.206 Lime 240

26.240 Lime 384

30.805 Lime 403

26.611 Lime 593

30.844 Lime 598

26.203 Lime 513

26.712 Lime 524

21.085 Lime 463

19.187 Lime 314

26.770 Lime 436

29.222 Lime 578

29.380 Lime 504

20.627 Lime 658

22.173 Lime 530
Other Boiler or Control Device Operating Parameters (e.g., Boiler O2) 

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

-0.0064 153

-0.0082 152

-0.0100 150

-0.0101 154

-0.0232 187

-0.0230 179

-0.0233 180

-0.0227 179

-0.0223 181

-0.0189 179

-0.0173 167

-0.0228 181

-0.0237 177

-0.0242 180

-0.0247 182

-0.0235 184

-0.0189 181

-0.0213 179

-0.0222 176

-0.0227 177

-0.0231 180

-0.0226 182

-0.0212 184

-0.0193 180

-0.0148 183

-0.0187 177

-0.0218 175

-0.0233 176

-0.0231 180

-0.0218 183
Flue Gas Oxygen Content (%) Flue Gas Carbon Dioxide Content (%) Flue Gas Moisture Content (%)

Only measured during testing 11.1 Only measured during testing

Only measured during testing 11.3 Only measured during testing

Only measured during testing 11.3 Only measured during testing

Only measured during testing 11.0 Only measured during testing

Only measured during testing 11.1 Only measured during testing

Only measured during testing 12.6 Only measured during testing

Only measured during testing 12.4 Only measured during testing

Only measured during testing 12.3 Only measured during testing

Only measured during testing 11.8 Only measured during testing

Only measured during testing 10.5 Only measured during testing

Only measured during testing 8.9 Only measured during testing

Only measured during testing 12.1 Only measured during testing

Only measured during testing 12.1 Only measured during testing

Only measured during testing 12.9 Only measured during testing

Only measured during testing 13.0 Only measured during testing

Only measured during testing 12.4 Only measured during testing

Only measured during testing 11.3 Only measured during testing

Only measured during testing 12.8 Only measured during testing

Only measured during testing 12.8 Only measured during testing

Only measured during testing 13.1 Only measured during testing

Only measured during testing 13.1 Only measured during testing

Only measured during testing 12.6 Only measured during testing

Only measured during testing 11.6 Only measured during testing

Only measured during testing 11.3 Only measured during testing

Only measured during testing 11.6 Only measured during testing

Only measured during testing 11.3 Only measured during testing

Only measured during testing 12.2 Only measured during testing

Only measured during testing 13.0 Only measured during testing

Only measured during testing 12.9 Only measured during testing

Only measured during testing 12.2 Only measured during testing