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

1382 HMP&L Station Two H1

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 1520.891

05/02/10 Day 2 1526.814

05/03/10 Day 3 1556.797

05/04/10 Day 4 1549.482

05/05/10 Day 5 1557.137

05/06/10 Day 6 1559.638

05/07/10 Day 7 1483.512

05/08/10 Day 8 1548.891

05/09/10 Day 9 993.218

05/10/10 Day 10 0

05/11/10 Day 11 0

05/12/10 Day 12 0

05/13/10 Day 13 0

05/14/10 Day 14 0

05/15/10 Day 15 0

05/16/10 Day 16 20.204

05/17/10 Day 17 1102.414

05/18/10 Day 18 1441.875

05/19/10 Day 19 1463.308

05/20/10 Day 20 1442.289

05/21/10 Day 21 1440.311

05/22/10 Day 22 1464.606

05/23/10 Day 23 1434.091

05/24/10 Day 24 1533.193

05/25/10 Day 25 1570.25

05/26/10 Day 26 1499.319

05/27/10 Day 27 1498.556

05/28/10 Day 28 1547.594

05/29/10 Day 29 1518.497

05/30/10 Day 30 1508.041
 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)

1515.486767

1528.730152

1547.378378

1534.914287

1543.161695

1563.340841

1502.169636

1590.794955

1432.189096

0

0

0

0

0

0

2440.698042

1260.50216

1459.678552

1459.342435

1480.545716

1454.647636

1478.96158

1467.73119

1554.285903

1602.508169

1554.982467

1513.288054

1562.808139

1563.653305

1574.473976

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

904.7403564 424954.1667 29.42

907.1779785 438013.1944 29.38

891.7828369 451679.8611 29.35

889.4430542 448191.6667 29.59

897.1018677 433130.5556 29.63

898.157959 439733.3333 29.54

1024.06189 424042.3611 29.65

1025.371948 421503.4722 29.48

901.7952881 397223.5294 29.87

0 0 30.02

0 0 29.89

0 0 29.63

0 0 29.71

0 0 29.76

0 0 29.9

3.998165131 0 29.85

418.0106201 415487.037 29.71

894.1089478 422406.25 29.62

899.480835 422703.4722 29.64

891.8081665 420381.9444 29.68

897.1272583 421883.3333 29.65

899.6207886 431041.6667 29.61

894.7055054 431041.6667 29.7

900.9041138 465838.8889 29.73

1020.578003 472556.9444 29.73

1011.960938 449270.8333 29.73

1007.815186 447822.2222 29.69

895.5250854 451972.2222 29.63

966.586731 447922.2222 29.6

887.427002 446261.1111 29.57

899.9885254 442951.3889 29.62
Flue Gas Sampling Point Temperature (Deg F) Flue Gas Oxygen Content (%)

137.3 2.552563209

138.8 3.769277224

140.1 4.017696891

137.5 3.757355073

136.6 3.169459641

136.8 3.1951857

133.4 3.268505165

135.8 3.009737523

130 5.59571162

125.9 0

104.7 0

105.6 0

114.9 0

118 0

116.5 0

111.9 0

109.4 6.058649884

128.7 4.138994971

134.8 3.944650776

134.6 4.134013712

135.6 3.980853325

138.1 3.798767408

138.6 3.609888452

142.4 4.036239118

141.8 3.888295503

141.3 3.620296025

140.8 3.706093025

141.1 3.518364744

141 3.865780843

141.5 3.830909314

142 3.610938793
Flue Gas Carbon Dioxide Content (%) Flue Gas Moisture Content (%)

10.99266667

10.75516667

10.626

10.8533913

11.24266667

11.1635

11.251

11.376

10.65394118

9.456555556

10.50933333

10.64683333

10.63433333

10.75516667

10.79266667

10.79266667

10.551

10.59266667

10.676

10.65516667

10.76766667

10.676

10.66766667

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

3363 3656

3687 3982

3179 3477

3499 3795

3503 3796

3531 3826

3435 3725

3508 3795

2284 2476

0 0

0 0

0 0

0 0

0 0

0 0

26 26

2486 2642

3177 3463

3240 3519

3217 3491

3243 3527

3355 3649

3284 3575

3515 3804

3644 3935

3488 3775

3455 3740

3516 3809

3437 3736

3418 3718

3439 3733
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.094116688

296.6666667 6.485429764

296.6666667 6.51906538

296.6666667 6.53661871

296.6666667 6.505339146

296.6666667 6.602477074

296.6666667 6.642546654

296.6666667 6.77314949

17800 6.798145294

0 0

0 0

0 0

0 0

0 0

0 0

0 6.91590786

296.6666667 6.858022213

296.6666667 6.401144028

296.6666667 6.655427456

296.6666667 6.81010294

296.6666667 6.505884171

296.6666667 6.452738762

296.6666667 6.862361908

296.6666667 6.678971291

296.6666667 6.610678673

296.6666667 6.603446007

296.6666667 6.605006695

296.6666667 6.652133465

296.6666667 6.612700462

296.6666667 6.558825493

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

1382 HMP&L Station Two H1

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 H1

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 H1

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)