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 1,2,3,4
EIA Facility Code Facility Name Boiler ID

708 Hammond 1,2,3,4

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

5,898.300 4946.744

6,537.073 4836.589

6,225.917 1324.498

947.127 3454.152

2,268.157 2916.289

3,996.750 3781.783

5,047.000 3944.078

5,127.187 3694.034

4,747.323 4017.771

4,995.450 3737.247

4,796.833 4165.745

5,256.320 3049.254

3,964.473 3421.223

4,407.200 4114.025

5,297.887 3730.043

4,944.800 3994.106

5,329.330 3952.066

5,210.240 3998.338

5,195.400 3671.970

4,897.313 3647.164

5,702.693 4855.836

6,045.513 4725.902

6,097.113 2690.595

2,837.520 1747.987

2,490.520 3739.156

5,086.733 3657.833

5,052.400 4740.353

6,329.353 4264.150

2,876.853 5046.363

6,481.400 4914.412
Unit Net Electric Generation (MWh) Unit Gross Electric Generation (MWe)

668.242 697.468

651.121 679.114

179.768 193.207

462.035 487.153

387.995 411.899

508.724 534.977

532.171 557.786

496.978 521.507

541.915 565.576

504.009 527.703

560.352 585.196

405.011 428.327

457.113 481.023

551.272 576.338

499.683 523.291

536.110 562.697

531.282 557.943

539.097 564.927

492.769 518.359

489.994 513.227

657.495 682.491

652.126 676.541

359.286 382.803

225.599 246.839

503.952 528.691

491.739 518.157

640.413 669.539

591.122 617.670

692.086 719.064

672.965 700.774
Control Device Operating Parameters, As Appicable

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

1702642.6 6.489

1806735.8 6.361

1777465 2.198

723716.2 3.617

998757.8 4.333

1384474.2 5.105

1560965 5.483

1624442.8 4.681

1485969.4 5.046

1526844.6 4.658

1466138 5.172

1587897.6 3.879

1337623.6 4.260

1431238.2 5.253

1600454.6 4.853

1529356 5.183

1591448.2 5.267

1611452.8 5.375

1606863 3.552

1551612.2 4.880

1683590.6 6.758

1826307.4

1841895.4 3.948

1170139.2 3.456

1115581.2 5.776

1611626 5.210

1544251.2 6.949

1806995.6 4.132

1099127.2 7.481

1830291 7.178
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)

113.0

113.4

114.6

104.2

114.2

115.7

115.1

116.0

117.4

118.7

116.7

117.2

116.3

113.7

114.1

113.4

115.2

114.3

113.8

112.2

116.0

117.2

117.2

111.7

109.8

114.0

114.3

116.3

119.5

115.5
Flue Gas Oxygen Content (%) Flue Gas Carbon Dioxide Content (%) Flue Gas Moisture Content (%)

10.393

10.855

10.508

3.926

6.813

8.661

9.700

9.469

9.584

9.815

9.815

9.931

8.891

9.238

9.931

9.700

10.046

9.700

9.700

9.469

10.162

9.931

9.931

7.275

6.697

9.469

9.815

10.508

7.852

10.624
EIA Facility Code Facility Name Boiler ID

708 Hammond 1,2,3,4

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 1,2,3,4

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 1,2,3,4

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

5,898.300 4946.744

6,537.073 4836.589

6,225.917 1324.498

947.127 3454.152

2,268.157 2916.289

3,996.750 3781.783

5,047.000 3944.078

5,127.187 3694.034

4,747.323 4017.771

4,995.450 3737.247

4,796.833 4165.745

5,256.320 3049.254

3,964.473 3421.223

4,407.200 4114.025

5,297.887 3730.043

4,944.800 3994.106

5,329.330 3952.066

5,210.240 3998.338

5,195.400 3671.970

4,897.313 3647.164

5,702.693 4855.836

6,045.513 4725.902

6,097.113 2690.595

2,837.520 1747.987

2,490.520 3739.156

5,086.733 3657.833

5,052.400 4740.353

6,329.353 4264.150

2,876.853 5046.363

6,481.400 4914.412
Unit Net Electric Generation (MWh) Unit Gross Electric Generation (MWe)

668.242 697.468

651.121 679.114

179.768 193.207

462.035 487.153

387.995 411.899

508.724 534.977

532.171 557.786

496.978 521.507

541.915 565.576

504.009 527.703

560.352 585.196

405.011 428.327

457.113 481.023

551.272 576.338

499.683 523.291

536.110 562.697

531.282 557.943

539.097 564.927

492.769 518.359

489.994 513.227

657.495 682.491

652.126 676.541

359.286 382.803

225.599 246.839

503.952 528.691

491.739 518.157

640.413 669.539

591.122 617.670

692.086 719.064

672.965 700.774
Control Device Operating Parameters, As Appicable

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

1702642.6 6.489

1806735.8 6.361

1777465 2.198

723716.2 3.617

998757.8 4.333

1384474.2 5.105

1560965 5.483

1624442.8 4.681

1485969.4 5.046

1526844.6 4.658

1466138 5.172

1587897.6 3.879

1337623.6 4.260

1431238.2 5.253

1600454.6 4.853

1529356 5.183

1591448.2 5.267

1611452.8 5.375

1606863 3.552

1551612.2 4.880

1683590.6 6.758

1826307.4

1841895.4 3.948

1170139.2 3.456

1115581.2 5.776

1611626 5.210

1544251.2 6.949

1806995.6 4.132

1099127.2 7.481

1830291 7.178
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)

113.0

113.4

114.6

104.2

114.2

115.7

115.1

116.0

117.4

118.7

116.7

117.2

116.3

113.7

114.1

113.4

115.2

114.3

113.8

112.2

116.0

117.2

117.2

111.7

109.8

114.0

114.3

116.3

119.5

115.5
Flue Gas Oxygen Content (%) Flue Gas Carbon Dioxide Content (%) Flue Gas Moisture Content (%)

10.393

10.855

10.508

3.926

6.813

8.661

9.700

9.469

9.584

9.815

9.815

9.931

8.891

9.238

9.931

9.700

10.046

9.700

9.700

9.469

10.162

9.931

9.931

7.275

6.697

9.469

9.815

10.508

7.852

10.624