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

54081 Spruance Genco, LLC 2

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 2

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 2

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 2

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

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

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

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

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

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

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

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

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

Day 10 04/10/10 64965 lbs/hr 0

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Day 30 04/30/10 62664 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)

215 141330

244 159683

285 193379

301 197520

669 509708

755 509835

770 525672

757 509676

723 489951

797 550235

770 547064

769 527938

763 548792

761 545150

792 573479

806 582272

667 476265

681 487344

767 550076

725 522190

788 572723

794 575754

822 583523

717 492141

672 463637

700 467173

748 501387

847 554072

828 555214

769 513602
Unit Net Electric Generation (MWh) Unit Gross Electric Generation (MWe)

-2.33 0.05

-1.50 0.00

-1.60 0.00

-1.79 0.00

47.98 50.89

48.02 50.60

50.77 53.41

48.21 50.82

46.29 48.79

54.00 56.68

53.91 56.64

50.40 53.01

55.23 57.99

55.92 58.70

58.25 61.08

59.15 61.99

45.16 47.71

47.11 49.75

55.16 57.90

51.46 54.11

58.81 61.56

58.41 61.20

58.60 61.38

46.62 49.18

43.29 45.72

43.14 45.55

47.81 50.35

54.52 57.26

55.68 58.48

49.31 51.94
Control Device Operating Parameters, As Appicable

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

70051 0.00

75240 0.00

85089 0.00

98219 0.17

173310 1.59

163735 1.65

166844 1.60

167139 1.58

163958 1.53

175115 1.64

174744 1.66

169065 1.76

178683 1.82

178731 1.83

181189 1.87

181290 1.86

160114 1.55

164290 1.58

174526 1.71

167578 1.62

179583 1.80

179142 1.81

178724 1.84

156542 1.49

150367 1.35

153318 1.37

160711 1.49

173424 1.72

171768 1.74

165572 1.59
FGD Scrubber Liquor Flow Rate (gals/min) Sorbent Type Sorbent Injection Rate (lb/hr)

0.10 Lime 199

0.13 Lime 115

0.62 Lime 141

0.10 Lime 153

1.46 Lime 359

17.71 Lime 371

23.30 Lime 409

4.75 Lime 439

10.50 Lime 515

4.89 Lime 377

27.62 Lime 322

31.40 Lime 361

33.12 Lime 305

24.63 Lime 318

12.80 Lime 328

0.07 Lime 332

0.09 Lime 281

0.28 Lime 412

2.40 Lime 524

2.87 Lime 586

6.54 Lime 596

10.04 Lime 473

16.67 Lime 455

17.74 Lime 342

0.10 Lime 394

10.73 Lime 606

4.14 Lime 593

19.13 Lime 574

1.49 Lime 471

4.96 Lime 460
Other Boiler or Control Device Operating Parameters (e.g., Boiler O2) 

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

-0.0076 151

-0.0087 143

-0.0107 142

-0.0124 165

-0.0246 181

-0.0228 190

-0.0229 186

-0.0234 183

-0.0233 181

-0.0249 180

-0.0251 179

-0.0241 183

-0.0264 180

-0.0267 179

-0.0271 179

-0.0269 181

-0.0229 182

-0.0238 178

-0.0261 174

-0.0243 174

-0.0266 174

-0.0267 176

-0.0269 178

-0.0230 179

-0.0215 179

-0.0216 177

-0.0228 176

-0.0258 175

-0.0259 175

-0.0242 177
Flue Gas Oxygen Content (%) Flue Gas Carbon Dioxide Content (%) Flue Gas Moisture Content (%)

Only measured during testing 5.7 Only measured during testing

Only measured during testing 5.5 Only measured during testing

Only measured during testing 5.5 Only measured during testing

Only measured during testing 5.7 Only measured during testing

Only measured during testing 11.1 Only measured during testing

Only measured during testing 11.6 Only measured during testing

Only measured during testing 12.5 Only measured during testing

Only measured during testing 11.8 Only measured during testing

Only measured during testing 11.2 Only measured during testing

Only measured during testing 12.5 Only measured during testing

Only measured during testing 12.7 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 12.6 Only measured during testing

Only measured during testing 12.9 Only measured during testing

Only measured during testing 12.8 Only measured during testing

Only measured during testing 11.8 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.8 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 13.1 Only measured during testing

Only measured during testing 12.0 Only measured during testing

Only measured during testing 11.4 Only measured during testing

Only measured during testing 11.2 Only measured during testing

Only measured during testing 11.8 Only measured during testing

Only measured during testing 13.0 Only measured during testing

Only measured during testing 13.2 Only measured during testing

Only measured during testing 12.0 Only measured during testing