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

1382 HMP&L Station TwoH2
EIA Facility Code Facility Name Boiler ID

1382 HMP&L Station Two H2

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

Date 

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

05/01/10 Day 1 0.063046333

05/02/10 Day 2 0.064309125

05/03/10 Day 3 0.063098958

05/04/10 Day 4 0.06391225

05/05/10 Day 5 0.064492875

05/06/10 Day 6 0.067437125

05/07/10 Day 7 0.030840042

05/08/10 Day 8 0.00512525

05/09/10 Day 9 0.022179625

05/10/10 Day 10 0.065394167

05/11/10 Day 11 0.064802042

05/12/10 Day 12 0.059812292

05/13/10 Day 13 0.06248025

05/14/10 Day 14 0.059725667

05/15/10 Day 15 0.063306542

05/16/10 Day 16 0.062947333

05/17/10 Day 17 0.061107875

05/18/10 Day 18 0.064551333

05/19/10 Day 19 0.065085

05/20/10 Day 20 0.064800083

05/21/10 Day 21 0.059535917

05/22/10 Day 22 0.059739958

05/23/10 Day 23 0.06103125

05/24/10 Day 24 0.064512833

05/25/10 Day 25 0.060698

05/26/10 Day 26 0.059562292

05/27/10 Day 27 0.058716917

05/28/10 Day 28 0.063423167

05/29/10 Day 29 0.062051417

05/30/10 Day 30 0.060929375

05/31/10 Day 31 0.059127458
 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)

1548.201067

1458.98755

1476.274587

1517.591263

1550.45257

1648.584143

1471.069386

635.1904217

1315.615508

1586.002108

1560.697556

1430.866725

1490.595073

1445.778018

1497.975849

1550.468357

1473.158097

1551.167249

1541.39634

1540.123021

1456.005615

1465.514372

1481.902223

1558.588765

1466.242739

1421.940119

1446.257549

1557.51061

1502.547752

1494.77792

1450.123384
Steam Output (1,000 lbs steam/hr) Flue Gas Flow Rate (scfm) Flue Gas Pressure (in. Hg)

923.2327271 438320.8333 29.28

981.9070435 439429.1667 29.23

927.5103149 426887.5 29.18

928.0378418 427591.6667 29.42

900.7832642 442950 29.45

937.5914307 446054.1667 29.38

1002.170776 436566.6667 29.49

12.60009766 0 29.31

447.8019104 424455.5556 29.72

995.4830933 449854.1667 29.85

987.7156372 441904.1667 29.7

934.8133545 411516.6667 29.42

950.1881714 425966.6667 29.53

943.4073486 413541.6667 29.6

927.7800293 434937.5 29.74

928.4867554 435716.6667 29.73

921.8706665 415583.3333 29.6

920.8660278 431787.5 29.59

922.840271 432375 29.65

922.4213867 433141.6667 29.75

920.9419556 404837.5 29.75

928.2633057 410416.6667 29.78

928.4960327 420941.6667 29.94

925.2046509 443033.3333 30.03

1069.278442 426325 30.12

931.8942871 416983.3333 30.16

934.8300781 414258.3333 30.19

931.9679565 435875 30.17

983.9105225 428829.1667 30.25

946.3080444 423108.3333 30.3

938.8519897 419854.1667 30.52
Flue Gas Sampling Point Temperature (Deg F) Flue Gas Oxygen Content (%)

135.1 3.785339355

135.9 3.568817139

137.7 2.771636963

135 2.883148193

134.2 3.667327881

136.1 3.095245361

135.4 3.7449646

138.8 10.01835155

95.1 8.57434082

99.1 3.614898682

128.2 3.370574951

133.4 3.345123291

136.2 3.095184326

137.2 3.254364014

135.2 3.423461914

132.8 3.579803467

133.4 3.284698486

134.3 3.369934082

132.8 3.735290527

132.5 4.039703369

133.1 3.9034729

135.4 3.072280884

135.7 3.476135254

139.2 3.320358276

139 3.460479736

138 3.697662354

138.1 3.255554199

137.9 3.67791748

138 3.263061523

139.2 2.710205078

139.5 3.141265869
Flue Gas Carbon Dioxide Content (%) Flue Gas Moisture Content (%)

10.71918182

10.74266667

10.83016667

10.9385

10.8635

10.97183333

10.74266667

0

10.35655556

10.70933333

10.87491304

10.78016667

10.85516667

10.70516667

10.73433333

10.78016667

10.83016667

10.901

10.9135

10.94683333

10.71766667

10.701

10.53433333

10.551

10.37183333

10.39266667

10.35933333

10.251

10.2885

10.38433333

10.35516667
Unit Net Electric Generation (MWh) Unit Gross Electric Generation (MWe) Standard Pressure (atm)

3370 3624

3414 3673

3368 3625

3413 3677

3478 3748

3520 3789

1721 1858

280 280

1191 1275

3548 3779

3566 3817

3270 3503

3393 3627

3252 3488

3479 3731

3479 3732

3333 3580

3506 3758

3512 3765

3511 3773

3216 3469

3277 3534

3320 3580

3471 3735

3324 3586

3246 3505

3204 3479

3406 3664

3334 3603

3294 3553

3216 3477
Standard Temperature (Deg F) Pressure Drop across FGD (in H2O)
FGD Scrubber Liquor Flow Rate (gals/min) FGD Scrubber Liquor pH (pH) Sorbent Type

296.6666667 6.4

296.6666667 6.5

296.6666667 6.7

296.6666667 6.77857542

296.6666667 6.508764267

296.6666667 5.09929657

296.6666667 7.094181061

296.6666667 8.124447823

296.6666667 8.123663902

296.6666667 6.362243176

296.6666667 6.50420475

296.6666667 6.473270893

296.6666667 6.683186054

296.6666667 6.656044483

296.6666667 6.673273087

296.6666667 6.578346729

296.6666667 6.600155354

296.6666667 7.017753601

296.6666667 7.039962769

296.6666667 6.946269989

296.6666667 6.935717583

296.6666667 6.880337715

296.6666667 6.892971516

296.6666667 6.968878746

296.6666667 6.895040989

296.6666667 6.974737644

296.6666667 6.829789639

296.6666667 6.776449203

296.6666667 6.858850002

296.6666667 6.883078098

296.6666667 6.818326473
Sorbent Injection Rate (lb/hr)
EIA Facility Code Facility Name Boiler ID

1382 HMP&L Station Two H2

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

1382 HMP&L Station Two H2

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

1382 HMP&L Station Two H2

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)