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

708 Hammond 3

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 71.857 1,000 lb/hr

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Day 30 2/11/2010 71.313 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)

672.570

653.891

523.421

440.286

327.968

447.828

495.095

470.060

575.624

529.598

578.969

430.180

454.026

575.470

518.750

461.995

472.317

479.394

450.422

438.612

682.991

685.659

674.098

611.521

550.727

463.666

650.690

602.388

683.076

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

94.340 94.687

92.392 92.717

76.179 76.362

64.972 65.166

48.341 48.538

65.090 65.526

71.524 71.935

68.265 68.737

82.038 82.209

75.967 76.144

82.570 82.860

62.001 62.451

64.861 65.328

81.669 81.853

73.839 74.421

66.635 67.100

68.351 68.708

69.630 69.960

64.233 64.781

62.192 62.851

94.749 94.889

95.517 95.910

93.727 94.126

86.099 86.454

78.521 78.708

66.389 66.916

91.811 92.331

84.968 85.143

94.719 95.011

89.655 89.864
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 3

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 3

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 3

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 71.857 1,000 lb/hr

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Day 30 2/11/2010 71.313 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)

672.570

653.891

523.421

440.286

327.968

447.828

495.095

470.060

575.624

529.598

578.969

430.180

454.026

575.470

518.750

461.995

472.317

479.394

450.422

438.612

682.991

685.659

674.098

611.521

550.727

463.666

650.690

602.388

683.076

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

94.340 94.687

92.392 92.717

76.179 76.362

64.972 65.166

48.341 48.538

65.090 65.526

71.524 71.935

68.265 68.737

82.038 82.209

75.967 76.144

82.570 82.860

62.001 62.451

64.861 65.328

81.669 81.853

73.839 74.421

66.635 67.100

68.351 68.708

69.630 69.960

64.233 64.781

62.192 62.851

94.749 94.889

95.517 95.910

93.727 94.126

86.099 86.454

78.521 78.708

66.389 66.916

91.811 92.331

84.968 85.143

94.719 95.011

89.655 89.864
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 (%)