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

708 Hammond 2
EIA Facility Code Facility Name Boiler ID

708 Hammond 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 1/13/2010 52.891 1,000 lb/hr

Day 2 1/14/2010 51.090 1,000 lb/hr

Day 3 1/15/2010 44.814 1,000 lb/hr

Day 4 1/16/2010 42.361 1,000 lb/hr

Day 5 1/17/2010 42.907 1,000 lb/hr

Day 6 1/18/2010 41.984 1,000 lb/hr

Day 7 1/19/2010 22.391 1,000 lb/hr

Day 8 1/20/2010 0.088 1,000 lb/hr

Day 9 1/21/2010 0.000 1,000 lb/hr

Day 10 1/22/2010 0.000 1,000 lb/hr

Day 11 1/23/2010 0.000 1,000 lb/hr

Day 12 1/24/2010 0.000 1,000 lb/hr

Day 13 1/25/2010 0.000 1,000 lb/hr

Day 14 1/26/2010 0.000 1,000 lb/hr

Day 15 1/27/2010 0.000 1,000 lb/hr

Day 16 1/28/2010 0.000 1,000 lb/hr

Day 17 1/29/2010 45.982 1,000 lb/hr

Day 18 1/30/2010 44.310 1,000 lb/hr

Day 19 1/31/2010 46.113 1,000 lb/hr

Day 20 2/1/2010 44.221 1,000 lb/hr

Day 21 2/2/2010 59.573 1,000 lb/hr

Day 22 2/3/2010 71.783 1,000 lb/hr

Day 23 2/4/2010 70.952 1,000 lb/hr

Day 24 2/5/2010 54.454 1,000 lb/hr

Day 25 2/6/2010 48.501 1,000 lb/hr

Day 26 2/7/2010 47.602 1,000 lb/hr

Day 27 2/8/2010 65.663 1,000 lb/hr

Day 28 2/9/2010 62.235 1,000 lb/hr

Day 29 2/10/2010 71.543 1,000 lb/hr

Day 30 2/11/2010 66.771 1,000 lb/hr
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)

464.605

453.624

385.621

365.376

368.202

356.830

195.675

4.647

4.624

4.633

4.652

4.643

4.625

4.625

10.374

373.031

390.272

376.492

399.546

377.221

526.291

639.401

630.531

462.431

399.125

386.690

565.706

537.794

633.288

590.543
Unit Net Electric Generation (MWh) Unit Gross Electric Generation (MWe)

64.071 66.254

62.879 64.972

51.966 54.294

48.780 50.604

47.585 49.941

47.892 50.361

26.632 27.497

-0.070 -0.070

-0.084 -0.084

-0.095 -0.095

-0.096 -0.096

-0.048 -0.048

-0.113 -0.113

-0.080 -0.080

0.749 0.749

49.108 51.420

52.272 54.951

51.002 53.323

53.801 56.195

51.328 52.889

72.573 74.490

86.759 89.037

84.736 87.205

61.144 63.869

53.804 56.316

51.817 54.167

76.486 78.678

71.817 74.073

85.118 86.455

79.676 81.398
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

708 Hammond 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

708 Hammond 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

708 Hammond 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 1/13/2010 52.891 1,000 lb/hr

Day 2 1/14/2010 51.090 1,000 lb/hr

Day 3 1/15/2010 44.814 1,000 lb/hr

Day 4 1/16/2010 42.361 1,000 lb/hr

Day 5 1/17/2010 42.907 1,000 lb/hr

Day 6 1/18/2010 41.984 1,000 lb/hr

Day 7 1/19/2010 22.391 1,000 lb/hr

Day 8 1/20/2010 0.088 1,000 lb/hr

Day 9 1/21/2010 0.000 1,000 lb/hr

Day 10 1/22/2010 0.000 1,000 lb/hr

Day 11 1/23/2010 0.000 1,000 lb/hr

Day 12 1/24/2010 0.000 1,000 lb/hr

Day 13 1/25/2010 0.000 1,000 lb/hr

Day 14 1/26/2010 0.000 1,000 lb/hr

Day 15 1/27/2010 0.000 1,000 lb/hr

Day 16 1/28/2010 0.000 1,000 lb/hr

Day 17 1/29/2010 45.982 1,000 lb/hr

Day 18 1/30/2010 44.310 1,000 lb/hr

Day 19 1/31/2010 46.113 1,000 lb/hr

Day 20 2/1/2010 44.221 1,000 lb/hr

Day 21 2/2/2010 59.573 1,000 lb/hr

Day 22 2/3/2010 71.783 1,000 lb/hr

Day 23 2/4/2010 70.952 1,000 lb/hr

Day 24 2/5/2010 54.454 1,000 lb/hr

Day 25 2/6/2010 48.501 1,000 lb/hr

Day 26 2/7/2010 47.602 1,000 lb/hr

Day 27 2/8/2010 65.663 1,000 lb/hr

Day 28 2/9/2010 62.235 1,000 lb/hr

Day 29 2/10/2010 71.543 1,000 lb/hr

Day 30 2/11/2010 66.771 1,000 lb/hr
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)

464.605

453.624

385.621

365.376

368.202

356.830

195.675

4.647

4.624

4.633

4.652

4.643

4.625

4.625

10.374

373.031

390.272

376.492

399.546

377.221

526.291

639.401

630.531

462.431

399.125

386.690

565.706

537.794

633.288

590.543
Unit Net Electric Generation (MWh) Unit Gross Electric Generation (MWe)

64.071 66.254

62.879 64.972

51.966 54.294

48.780 50.604

47.585 49.941

47.892 50.361

26.632 27.497

-0.070 -0.070

-0.084 -0.084

-0.095 -0.095

-0.096 -0.096

-0.048 -0.048

-0.113 -0.113

-0.080 -0.080

0.749 0.749

49.108 51.420

52.272 54.951

51.002 53.323

53.801 56.195

51.328 52.889

72.573 74.490

86.759 89.037

84.736 87.205

61.144 63.869

53.804 56.316

51.817 54.167

76.486 78.678

71.817 74.073

85.118 86.455

79.676 81.398
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 (%)