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

6113 Unit 2
EIA Facility Code Facility Name Boiler ID

0 0 0

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

0 0 0

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

0 0 0

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

0 0 0

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 5/26/2010 530 klbh N/A

Day 2 5/27/2010 521 klbh N/A

Day 3 5/28/2010 520 klbh N/A

Day 4 5/29/2010 520 klbh N/A

Day 5 5/30/2010 508 klbh N/A

Day 6 5/31/2010 507 klbh N/A

Day 7 6/1/2010 516 klbh N/A

Day 8 6/2/2010 547 klbh N/A

Day 9 6/3/2010 530 klbh N/A

Day 10 6/4/2010 524 klbh N/A

Day 11 6/5/2010 573 klbh N/A

Day 12 6/6/2010 547 klbh N/A

Day 13 6/7/2010 521 klbh N/A

Day 14 6/8/2010 513 klbh N/A

Day 15 6/9/2010 516 klbh N/A

Day 16 6/10/2010 536 klbh N/A

Day 17 6/11/2010 542 klbh N/A

Day 18 6/12/2010 505 klbh N/A

Day 19 6/13/2010 479 klbh N/A

Day 20 6/14/2010 515 klbh N/A

Day 21 6/15/2010 559 klbh N/A

Day 22 6/16/2010 541 klbh N/A

Day 23 6/17/2010 493 klbh N/A

Day 24 6/18/2010 512 klbh N/A

Day 25 6/19/2010 552 klbh N/A

Day 26 6/20/2010 572 klbh N/A

Day 27 6/21/2010 566 klbh N/A

Day 28 6/22/2010 549 klbh N/A

Day 29 6/23/2010 568 klbh N/A

Day 30 6/24/2010 553 klbh N/A

Notes:

Flue Gas Oxygen Content is from economzer outlet and is an average of several monitors used for control

Average Heat Input, Flue Gas Flow Rate, and Flue Gas Carbon Dioxide Content are from CEM. Flue Gas F
he Testing Date

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

N/A N/A N/A N/A

N/A N/A N/A N/A

N/A N/A N/A N/A

N/A N/A N/A N/A

N/A N/A N/A N/A

N/A N/A N/A N/A

N/A N/A N/A N/A

N/A N/A N/A N/A

N/A N/A N/A N/A

N/A N/A N/A N/A

N/A N/A N/A N/A

N/A N/A N/A N/A

N/A N/A N/A N/A

N/A N/A N/A N/A

N/A N/A N/A N/A

N/A N/A N/A N/A

N/A N/A N/A N/A

N/A N/A N/A N/A

N/A N/A N/A N/A

N/A N/A N/A N/A

N/A N/A N/A N/A

N/A N/A N/A N/A

N/A N/A N/A N/A

N/A N/A N/A N/A

N/A N/A N/A N/A

N/A N/A N/A N/A

N/A N/A N/A N/A

N/A N/A N/A N/A

N/A N/A N/A N/A

N/A N/A N/A N/A

 monitors used for control.

are from CEM. Flue Gas Flow is as monitored (wet not dry).
Coal Gas Firing Rate (units) Fuel oil Firing Rate Fuel oil Firing Rate (units)

N/A 0.0 gpm

N/A 0.0 gpm

N/A 0.2 gpm

N/A 0.0 gpm

N/A 0.0 gpm

N/A 0.0 gpm

N/A 0.8 gpm

N/A 0.3 gpm

N/A 0.1 gpm

N/A 0.0 gpm

N/A 0.0 gpm

N/A 0.0 gpm

N/A 0.2 gpm

N/A 0.0 gpm

N/A 0.0 gpm

N/A 0.0 gpm

N/A 0.0 gpm

N/A 0.0 gpm

N/A 0.3 gpm

N/A 0.0 gpm

N/A 0.0 gpm

N/A 0.0 gpm

N/A 0.0 gpm

N/A 0.0 gpm

N/A 0.0 gpm

N/A 0.0 gpm

N/A 0.0 gpm

N/A 0.0 gpm

N/A 0.0 gpm

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

 6,252 4,177

6,053 4,023

6,089 4,039

6,190 4,081

6,117 4,022

6,120 4,025

6,109 4,026

6,445 4,289

6,242 4,190

6,200 4,127

6,689 4,473

6,313 4,177

6,327 4,034

6,098 4,003

6,177 4,066

6,369 4,201

6,410 4,245

6,010 3,959

5,641 3,730

6,039 4,026

6,559 4,397

6,283 4,181

5,755 3,805

5,983 3,998

6,488 4,274

6,771 4,431

6,615 4,409

6,476 4,303

6,837 4,545

6,489 4,445
Unit Net Electric Generation (MWh) Unit Gross Electric Generation (MWe)

569 613

551 593

552 596

558 602

549 593

548 592

548 592

587 632

570 615

558 604

608 656

571 615

553 595

548 590

556 600

575 619

579 625

538 584

505 549

545 590

596 644

567 614

513 557

542 587

579 626

602 651

595 644

577 625

610 659

595 643
Control Device Operating Parameters, As Appicable

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

 1,798,325 6.98

1,743,890 7.08

1,735,474 6.81

1,774,403 6.60

1,739,748 6.73

1,752,329 7.30

1,746,076 6.81

1,840,723 7.53

1,793,768 7.25

1,781,144 7.10

1,922,396 7.88

1,809,256 7.47

1,742,331 7.08

1,737,422 7.27

1,773,517 7.21

1,814,040 7.12

1,821,733 7.59

1,737,287 6.78

1,643,094 6.28

1,760,629 7.13

1,901,638 7.81

1,808,396 7.31

1,654,203 6.56

1,717,441 6.73

1,832,210 7.30

1,899,631 7.11

1,859,085 6.85

1,821,476 6.87

1,897,006 7.17

1,803,467 7.04
FGD Scrubber Liquor Flow Rate (gals/min) Sorbent Type Sorbent Injection Rate (lb/hr)

301 N/A N/A

242 N/A N/A

324 N/A N/A

331 N/A N/A

334 N/A N/A

391 N/A N/A

328 N/A N/A

306 N/A N/A

360 N/A N/A

309 N/A N/A

325 N/A N/A

291 N/A N/A

301 N/A N/A

259 N/A N/A

299 N/A N/A

301 N/A N/A

269 N/A N/A

289 N/A N/A

265 N/A N/A

322 N/A N/A

411 N/A N/A

370 N/A N/A

241 N/A N/A

330 N/A N/A

310 N/A N/A

293 N/A N/A

386 N/A N/A

297 N/A N/A

367 N/A N/A

342 N/A N/A
Other Boiler or Control Device Operating Parameters (e.g., Boiler O2) 

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

N/A 145

N/A 144

N/A 143

N/A 146

N/A 145

N/A 146

N/A 146

N/A 145

N/A 145

N/A 146

N/A 148

N/A 144

N/A 141

N/A 142

N/A 145

N/A 145

N/A 147

N/A 147

N/A 146

N/A 147

N/A 148

N/A 146

N/A 144

N/A 148

N/A 147

N/A 149

N/A 151

N/A 148

N/A 149

N/A 142
Flue Gas Oxygen Content (%) Flue Gas Carbon Dioxide Content (%) Flue Gas Moisture Content (%)

3.5 10.4 N/A

3.6 10.4 N/A

3.6 10.5 N/A

3.6 10.4 N/A

3.5 10.5 N/A

3.5 10.4 N/A

3.5 10.5 N/A

3.4 10.5 N/A

3.4 10.4 N/A

3.5 10.4 N/A

3.3 10.4 N/A

3.5 10.5 N/A

3.6 10.6 N/A

3.6 10.5 N/A

3.6 10.4 N/A

3.5 10.5 N/A

3.5 10.5 N/A

3.6 10.4 N/A

3.7 10.3 N/A

3.6 10.3 N/A

3.5 10.3 N/A

3.5 10.4 N/A

3.7 10.4 N/A

3.4 10.4 N/A

3.3 10.6 N/A

3.1 10.7 N/A

3.1 10.7 N/A

3.3 10.6 N/A

3.0 10.8 N/A

3.2 10.8 N/A