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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

3329.829

3270.335

9.317

2283.804

1921.743

2618.759

2885.607

2862.534

2995.362

2759.900

3100.289

2286.518

2602.623

3125.503

2806.671

2789.440

2727.202

2788.321

2454.904

2468.449

3045.705

2819.524

796.850

209.807

2383.324

2440.802

3055.870

2633.229

3121.547

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

439.192 463.212

428.918 451.563

-8.188 -0.117

295.115 315.353

248.920 267.524

342.866 363.638

379.444 401.360

375.750 397.540

394.309 415.159

362.726 383.511

407.227 429.053

295.851 315.926

339.615 360.407

409.395 431.869

367.133 387.744

365.981 387.343

356.850 378.241

366.191 386.998

320.820 341.057

323.285 341.890

402.036 422.923

383.909 403.921

94.198 112.796

9.589 25.557

311.145 330.882

319.366 340.268

403.099 426.401

362.317 383.501

423.524 446.405

418.508 441.424
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 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 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 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 348.760 1,000 lb/hr

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

3329.829

3270.335

9.317

2283.804

1921.743

2618.759

2885.607

2862.534

2995.362

2759.900

3100.289

2286.518

2602.623

3125.503

2806.671

2789.440

2727.202

2788.321

2454.904

2468.449

3045.705

2819.524

796.850

209.807

2383.324

2440.802

3055.870

2633.229

3121.547

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

439.192 463.212

428.918 451.563

-8.188 -0.117

295.115 315.353

248.920 267.524

342.866 363.638

379.444 401.360

375.750 397.540

394.309 415.159

362.726 383.511

407.227 429.053

295.851 315.926

339.615 360.407

409.395 431.869

367.133 387.744

365.981 387.343

356.850 378.241

366.191 386.998

320.820 341.057

323.285 341.890

402.036 422.923

383.909 403.921

94.198 112.796

9.589 25.557

311.145 330.882

319.366 340.268

403.099 426.401

362.317 383.501

423.524 446.405

418.508 441.424
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 (%)