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 c

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

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

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

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

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

[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 worksheet

Process Data Worksheets

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

done. 
data required by the ICR. The ERT does not 

separate surrogate worksheets, in case the 

 is intended to be used for one boiler of one 

s of this spreadsheet. Fields shaded in yellow 

ulate cells shaded in gray, as they are 

ot modify the structure of this spreadsheet by 

dsheet with the following naming convention: 

n the Boiler Information worksheet. 

aneous testing of different HAP surrogates was 
EIA Facility Code Facility Name Boiler ID

50835 Filer City 2
EIA Facility Code Facility Name Boiler ID

50835 Filer City 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

50835 Filer City 2

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

Date Coal Firing Rate Coal Firing Rate (units)

Day 1 1-Jun-10 372 Tons per Day

Day 2 2-Jun-10 386

Day 3 3-Jun-10 383

Day 4 4-Jun-10 367

Day 5 5-Jun-10 349

Day 6 6-Jun-10 346

Day 7 7-Jun-10 361

Day 8 8-Jun-10 372

Day 9 9-Jun-10 375

Day 10 10-Jun-10 370

Day 11 11-Jun-10 392

Day 12 12-Jun-10 361

Day 13 13-Jun-10 350

Day 14 14-Jun-10 373

Day 15 15-Jun-10 354

Day 16 16-Jun-10 363

Day 17 17-Jun-10 353

Day 18 18-Jun-10 356

Day 19 19-Jun-10 361

Day 20 20-Jun-10 352

Day 21 21-Jun-10 372

Day 22 22-Jun-10 391

Day 23 23-Jun-10 361

Day 24 24-Jun-10 352

Day 25 25-Jun-10 352

Day 26 26-Jun-10 381

Day 27 27-Jun-10 391

Day 28 28-Jun-10 376

Day 29 29-Jun-10 391

Day 30 30-Jun-10 383
ay Period Including the Testing Date

TDF Firing Rate TDF Firing Rate (units) Wood Firing Rate Wood Firing Rate (units)

46 Tons per Day 25.4316 Tons per Day

46 29.0148

41.8 37.2085

45.7 39.7164

46.2 37.7835

47 42.8144

45 26.5516

40 43.9681

47 47.6821

0 34.6173

46.1 45.8114

46.1 41.0112

46 44.5000

30.7 37.2490

45.7 50.7869

43.7 46.2510

46 56.4179

46 43.8625

45.4 43.4632

38.3 41.4118

47.7 32.8947

44 32.4091

40.4 37.2061

47 44.2458

48 36.9195

46 5.9223

46 0.0000

46 25.4184

35 40.7606

33.7 31.4865
Synfuel Firing Rate Synfuel Firing Rate (units) Pet Coke Firing Rate Pet Coke Firing Rate (units)

52.1987 Tons per Day

54.1632

53.7422

51.4971

48.9714

48.5504

50.6552

52.1987

52.6197

51.9181

55.0051

50.6483

49.105

52.3319

49.6662

50.9289

49.5259

49.9468

50.6483

49.3856

52.1916

54.8573

50.6483

49.3856

49.3856

53.4543

54.8573

51.8186

53.8858

52.7833
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)

406.9 304.257

404.6 306.262

403.5 305.981

402.7 303.656

403.3 302.209

405.2 302.943

402 302.406

390.8 304.075

398.8 303.742

407.3 304.179

415.2 300.408

409 305.009

410.8 305.121

409.7 305.695

410.7 304.659

410.2 305.373

411.7 304.456

411.1 304.198

404.7 306.311

414.6 303.297

413.5 304.489

408.4 307.355

410 305.589

409.3 307.193

409.5 305.086

406.8 304.806

405.8 306.347

407.2 306.682

412.5 303.151

413.2 302.074
Unit Net Electric Generation (MWh) Unit Gross Electric Generation (MWe)

30.37524241 31.74722983

30.27690817 31.89372584

30.19949625 31.93505245

30.26171664 31.77202158

29.91414796 31.56742775

30.07791286 31.50318066

30.09223767 31.6816941

30.16999556 31.57831264

30.11680408 31.78108546

29.99821666 31.73380097

30.121807 31.75348667

29.99300684 31.73961392

29.98599398 31.74597779

30.17790812 31.75066902

29.83720649 31.69413043

29.79162053 31.68548947

29.95112443 31.66545979

29.90192435 31.60651798

29.99774627 31.63387516

27.08873395 28.72773229

32.74358626 34.54849685

30.07068205 31.9021948

30.14236871 31.75609836

30.23943563 31.8455303

30.12439418 31.71794172

30.16493393 31.75359029

29.97805282 31.76349162

29.79917427 31.76850687

29.41816806 31.49694278

29.83542119 31.49992449
Control Device Operating Parameters, As Appicable

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

105,371

104,797

103,372

103,154

103,596

106,183

104,831

101,135

102,988

107,060

107,305

108,453

108,360

109,202

108,961

110,527

109,383

108,718

108,905

108,705

109,267

108,610

109,264

110,664

110,028

108,308

107,456

108,282

109,847

109,063
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 (%)

11.68

11.68

11.81

11.81

11.77

11.54

11.60

11.69

11.59

11.50

11.66

11.41

11.47

11.35

11.40

11.23

11.38

11.45

11.25

11.54

11.47

11.37

11.36

11.20

11.26

11.37

11.43

11.38

11.36

11.46