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 4
EIA Facility Code Facility Name Boiler ID

54081 Spruance Genco, LLC 4

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 4

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 4

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 4

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/07/10 0 lbs/hr 0

Day 2 04/08/10 0 lbs/hr 0

Day 3 04/09/10 13494 lbs/hr 0

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

Day 5 04/11/10 44630 lbs/hr 0

Day 6 04/12/10 54678 lbs/hr 0

Day 7 04/13/10 53239 lbs/hr 0

Day 8 04/14/10 52256 lbs/hr 0

Day 9 04/15/10 54661 lbs/hr 0

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

Day 11 04/17/10 43068 lbs/hr 0

Day 12 04/18/10 47927 lbs/hr 0

Day 13 04/19/10 49345 lbs/hr 0

Day 14 04/20/10 54043 lbs/hr 0

Day 15 04/21/10 55377 lbs/hr 0

Day 16 04/22/10 54281 lbs/hr 0

Day 17 04/23/10 57462 lbs/hr 0

Day 18 04/24/10 49270 lbs/hr 0

Day 19 04/25/10 19083 lbs/hr 0

Day 20 04/26/10 30608 lbs/hr 0

Day 21 04/27/10 50966 lbs/hr 0

Day 22 04/28/10 55652 lbs/hr 0

Day 23 04/29/10 53809 lbs/hr 0

Day 24 04/30/10 55829 lbs/hr 0

Day 25 05/01/10 57085 lbs/hr 0

Day 26 05/02/10 58129 lbs/hr 0

Day 27 05/03/10 42402 lbs/hr 0

Day 28 05/04/10 44039 lbs/hr 0

Day 29 05/05/10 54913 lbs/hr 0

Day 30 05/06/10 57319 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)

0 2129

0 1262

166 46383

544 365674

548 381179

671 491197

654 486937

641 477317

671 507193

716 515942

529 368098

588 435914

606 435210

663 479955

680 491671

666 491424

705 516088

605 434722

234 162535

376 244311

626 442553

683 486423

661 471738

685 490130

701 492584

714 489199

520 372749

541 388869

674 478343

704 522431
Unit Net Electric Generation (MWh) Unit Gross Electric Generation (MWe)

-1.63 0.00

-2.00 0.00

-2.11 0.70

16.73 21.08

15.41 19.71

31.03 35.79

30.25 35.05

29.42 34.25

31.95 36.78

33.08 37.49

15.56 19.37

25.56 29.38

24.37 28.23

29.87 33.85

29.99 34.04

29.13 33.22

29.93 34.15

22.48 26.51

-2.73 0.00

2.95 6.05

24.94 28.92

30.29 34.45

28.83 32.84

29.97 34.00

30.14 34.21

27.22 31.67

2.84 6.82

7.75 11.79

29.86 34.02

33.38 37.81
Control Device Operating Parameters, As Appicable

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

0 0.00

0 0.00

84553.85 0.60

141433.3333 2.51

138958.3333 2.44

164441.6667 3.05

165104.1667 3.07

164612.5 3.04

169358.3333 3.16

168050 3.06

135691.6667 2.34

148216.6667 2.64

151033.3333 2.71

158654.1667 2.91

161391.6667 3.01

162466.6667 2.98

171895.8333 3.15

159283.3333 2.79

101245.8333 1.43

114795.8333 1.87

150137.5 2.72

160083.3333 2.92

157450 2.85

159704.1667 2.93

157933.3333 2.92

164058.3333 3.06

144850 2.55

149179.1667 2.65

162616.6667 3.04

174191.6667 3.30
FGD Scrubber Liquor Flow Rate (gals/min) Sorbent Type Sorbent Injection Rate (lb/hr)

1.30 Lime 0.00

1.30 Lime 3.76

1.83 Lime 101.59

19.75 Lime 407.57

19.92 Lime 354.58

25.46 Lime 420.89

25.17 Lime 391.24

25.47 Lime 374.41

24.66 Lime 585.47

26.04 Lime 362.52

17.61 Lime 329.00

18.87 Lime 568.84

22.35 Lime 527.84

23.19 Lime 631.04

22.14 Lime 606.90

20.51 Lime 683.72

24.25 Lime 662.90

21.23 Lime 534.02

6.83 Lime 222.31

9.49 Lime 424.77

17.51 Lime 581.54

21.67 Lime 533.97

15.58 Lime 734.38

23.87 Lime 554.63

26.32 Lime 496.99

25.20 Lime 540.08

19.28 Lime 548.30

20.49 Lime 547.13

26.57 Lime 578.32

26.78 Lime 686.77
Other Boiler or Control Device Operating Parameters (e.g., Boiler O2) 

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

0.000 85

0.000 81

-0.005 102

-0.019 174

-0.018 167

-0.023 173

-0.023 173

-0.023 172

-0.024 174

-0.024 176

-0.018 176

-0.020 170

-0.021 173

-0.022 174

-0.022 171

-0.023 173

-0.024 172

-0.021 174

-0.011 142

-0.015 152

-0.021 170

-0.022 171

-0.022 176

-0.022 178

-0.022 177

-0.023 176

-0.019 173

-0.020 170

-0.023 171

-0.025 170
Flue Gas Oxygen Content (%) Flue Gas Carbon Dioxide Content (%) Flue Gas Moisture Content (%)

Only measured during testing 0.3 Only measured during testing

Only measured during testing 0.3 Only measured during testing

Only measured during testing 2.0 Only measured during testing

Only measured during testing 10.0 Only measured during testing

Only measured during testing 10.8 Only measured during testing

Only measured during testing 11.6 Only measured during testing

Only measured during testing 11.6 Only measured during testing

Only measured during testing 11.8 Only measured during testing

Only measured during testing 12.0 Only measured during testing

Only measured during testing 11.8 Only measured during testing

Only measured during testing 10.8 Only measured during testing

Only measured during testing 11.7 Only measured during testing

Only measured during testing 11.7 Only measured during testing

Only measured during testing 12.1 Only measured during testing

Only measured during testing 12.2 Only measured during testing

Only measured during testing 12.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 5.6 Only measured during testing

Only measured during testing 7.7 Only measured during testing

Only measured during testing 12.4 Only measured during testing

Only measured during testing 12.5 Only measured during testing

Only measured during testing 12.1 Only measured during testing

Only measured during testing 11.8 Only measured during testing

Only measured during testing 12.4 Only measured during testing

Only measured during testing 12.8 Only measured during testing

Only measured during testing 12.1 Only measured during testing

Only measured during testing 11.9 Only measured during testing

Only measured during testing 12.3 Only measured during testing

Only measured during testing 12.8 Only measured during testing