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

7790 Bonanza Power Plant 1-1
EIA Facility Code Facility Name Boiler ID

7790 Bonanza Power Plant 1-1

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

Date 

(MM/DD/YY) Coal Firing Rate (1,000 Tons/hr)

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
 for a 30 Day Period Including the Testing Date

Synfuel Firing Rate (1,000 Tons/hr) Pet Coke Firing Rate (1,000 Tons/hr)
Coal Gas Firing Rate (ft^3/min) Fuel oil Firing Rate (Gal/hr) Average Heat Input (MMBtu/hr)
Steam Output (1,000 lbs steam/hr) Flue Gas Flow Rate (dscfm) Flue Gas Pressure (atm)
Flue Gas Sampling Point Temperature (Deg F) Flue Gas Oxygen Content (%)
Flue Gas Carbon Dioxide Content (%) Flue Gas Moisture Content (%)
Unit Net Electric Generation (MWh) Unit Gross Electric Generation (MWe) Standard Pressure (atm)
Standard Temperature (Deg F) Pressure Drop across FGD (in H2O)
FGD Scrubber Liquor Flow Rate (gals/min) FGD Scrubber Liquor pH (pH) Sorbent Type
Sorbent Injection Rate (lb/hr)
EIA Facility Code Facility Name Boiler ID

7790 Bonanza Power Plant 1-1

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

Date 

(MM/DD/YYYY) Coal Firing Rate (1,000 Tons/hr)

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
a for a 30 Day Period Including the Testing Date

Synfuel Firing Rate (1,000 Tons/hr) Pet Coke Firing Rate (1,000 Tons/hr)
Coal Gas Firing Rate (ft^3/min) Fuel oil Firing Rate (Gal/hr) Average Heat Input (MMBtu/hr)
Steam Output (1,000 lbs steam/hr) Flue Gas Flow Rate (dscfm) Flue Gas Pressure (atm)
Flue Gas Sampling Point Temperature (Deg F) Flue Gas Oxygen Content (%)
Flue Gas Carbon Dioxide Content (%) Flue Gas Moisture Content (%)
Unit Net Electric Generation (MWh) Unit Gross Electric Generation (MWe) Standard Pressure (atm)
Standard Temperature (Deg F) Pressure Drop across FGD (in H2O)
FGD Scrubber Liquor Flow Rate (gals/min) FGD Scrubber Liquor pH (pH) Sorbent Type
Sorbent Injection Rate (lb/hr)
EIA Facility Code Facility Name Boiler ID

7790 Bonanza Power Plant 1-1

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

Date 

(MM/DD/YYYY) Coal Firing Rate (1,000 Tons/hr) Synfuel Firing Rate (1,000 Tons/hr) Pet Coke Firing Rate (1,000 Tons/hr)

3/22/2010 Day 1 440

3/23/2010 Day 2 451.8

3/24/2010 Day 3 441.6

3/25/2010 Day 4 461.2

3/26/2010 Day 5 463.6

3/27/2010 Day 6 403.2

3/28/2010 Day 7 433.4

3/29/2010 Day 8 473

3/30/2010 Day 9 442

3/31/2010 Day 10 454.4

4/1/2010 Day 11 483.6

4/2/2010 Day 12 469

4/3/2010 Day 13 482.2

4/4/2010 Day 14 489.6

4/5/2010 Day 15 479.4

4/6/2010 Day 16 478.8

4/7/2010 Day 17 498

4/8/2010 Day 18 449.8

4/9/2010 Day 19 405.2

4/10/2010 Day 20 462.8

4/11/2010 Day 21 481.6

4/12/2010 Day 22 468.4

4/13/2010 Day 23 454.8

4/14/2010 Day 24 473

4/15/2010 Day 25 481

4/16/2010 Day 26 487

4/17/2010 Day 27 449.8

4/18/2010 Day 28 488.8

4/19/2010 Day 29 453.6

4/20/2010 Day 30 477.4
Coal Gas Firing Rate (ft^3/min) Fuel oil Firing Rate (Gal/hr) Average Heat Input (MMBtu/hr) Steam Output (1,000 lbs steam/hr) Flue Gas Flow Rate (dscfm) 

3637 2847.4 975158.3

3815.1 2933.7 1002733.3

3905.7 2933.7 1025525

4133.8 2852.8 1070597

3923.2 3002.7 1016833

3511.1 2954.8 940942

3776.5 2550.7 967438

4102.1 2787.6 1036747

3689.6 3031.3 958230

3765.5 2852.7 986683

3901.6 2917.7 1016142

4023.1 2947.5 1012505

4053.9 2952.9 1032830

4130.4 3036.1 1050630

4018.3 3090.8 1040908

4230.2 3008.3 1086888

4552.7 3022.8 1149858

4041.2 3154.9 1026658

3626.5 2904 928330

4194.1 2601.7 1056833

4414.2 2956.2 1104166

4299 3066.5 1098888

4088.1 3035.9 1055738

4328 2915.7 1081655

4408.2 3067.7 1098650

4444.9 3092.8 1105767

4123.1 3114.2 1048930

4464.9 2846.3 1128808

4151.6 3116.2 1063772

4451.5 2885.9 1133821
Flue Gas Pressure (atm) Flue Gas Sampling Point Temperature (Deg F) Flue Gas Oxygen Content (%) Flue Gas Carbon Dioxide Content (%)

0.8265096 126.5 11.2

0.8298423 124.4 11.4

0.833175 122 11.4

0.8265096 124 11.6

0.8231769 127.5 11.6

0.8365077 119.6 11.1

0.8365077 124.7 11.7

0.8265096 127.3 11.9

0.8165115 124.5 11.6

0.8165115 125.9 11.5

0.8165115 126 11.5

0.8231769 121.9 11.9

0.8231769 126.4 11.8

0.8231769 126.8 11.8

0.8198442 127.2 11.6

0.8265096 125.9 11.7

0.8365077 126.7 11.9

0.8298423 124.7 11.8

0.8265096 123 11.7

0.8298423 126.9 11.9

0.8298423 127.5 12

0.8198442 125.9 11.7

0.8231769 123.2 11.6

0.8298423 125.5 12

0.833175 127.3 12

0.8298423 128.8 12.1

0.8298423 128.2 11.8

0.8298423 128.6 11.9

0.8265096 125.3 11.7

0.8231769 126.4 11.8
Flue Gas Moisture Content (%) Unit Net Electric Generation (MWh) Unit Gross Electric Generation (MWe) Standard Pressure (atm) Standard Temperature (Deg F)

462 429.8

461 444

423 431.6

460 457.3

460 452

460 392.3

457 426.2

461 466.2

455 432.8

450 441.7

459 451

457 456.7

459 464.3

459 473.5

458 464.5

459 466.1

459 481.9

459 435.5

458 397.6

457 453

458 472

459 464.9

456 447.4

459 466

459 468.9

459 475.2

459 438.5

459 476.7

459 442.1

460 467
Pressure Drop across FGD (in H2O) FGD Scrubber Liquor Flow Rate (gals/min) FGD Scrubber Liquor pH (pH) Sorbent Type Sorbent Injection Rate (lb/hr)

3.61 40.8 5.57 Limestone 4892

3.68 49.6 5.51 Limestone 5183

3.54 70.0 5.52 Limestone 8150

3.75 70.0 5.51 Limestone 7888

3.79 70.0 5.51 Limestone 8450

3.32 70.0 5.52 Limestone 8408

3.56 70.0 5.52 Limestone 7550

3.81 88.7 5.47 Limestone 9667

3.56 89.2 5.57 Limestone 13608

3.71 21.9 5.56 Limestone 5217

3.85 70.0 5.57 Limestone 14192

3.8 56.0 5.58 Limestone 10750

4 21.9 5.59 Limestone 4833

4.1 0.0 5.50 Limestone 67

4.03 64.4 5.53 Limestone 9350

4.03 10.2 5.53 Limestone 808

4.16 73.4 5.53 Limestone 13308

3.76 0.0 5.54 Limestone 0

3.35 25.3 5.56 Limestone 4142

3.81 46.5 5.54 Limestone 10767

4.02 47.6 5.54 Limestone 10167

4.01 44.4 5.56 Limestone 10425

3.92 41.1 5.58 Limestone 10808

4.03 0.0 5.55 Limestone 0

4.01 22.7 5.53 Limestone 4942

4.12 62.9 5.58 Limestone 15542

3.8 49.6 5.63 Limestone 12558

4.2 65.7 5.63 Limestone 12433

3.9 65.5 5.65 Limestone 14300

4.08 50.1 5.63 Limestone 11992
EIA Facility Code Facility Name Boiler ID

7790 Bonanza Power Plant 1-1

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

Date 

(MM/DD/YYYY) Coal Firing Rate (1,000 Tons/hr)

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
a for a 30 Day Period Including the Testing Date

Synfuel Firing Rate (1,000 Tons/hr) Pet Coke Firing Rate (1,000 Tons/hr)
Coal Gas Firing Rate (ft^3/min) Fuel oil Firing Rate (Gal/hr) Average Heat Input (MMBtu/hr)
Steam Output (1,000 lbs steam/hr) Flue Gas Flow Rate (dscfm) Flue Gas Pressure (atm)
Flue Gas Sampling Point Temperature (Deg F) Flue Gas Oxygen Content (%)
Flue Gas Carbon Dioxide Content (%) Flue Gas Moisture Content (%)
Unit Net Electric Generation (MWh) Unit Gross Electric Generation (MWe) Standard Pressure (atm)
Standard Temperature (Deg F) Pressure Drop across FGD (in H2O)
FGD Scrubber Liquor Flow Rate (gals/min) FGD Scrubber Liquor pH (pH) Sorbent Type
Sorbent Injection Rate (lb/hr)