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

2079 Hawthorn 5A
EIA Facility Code Facility Name Boiler ID

2079 Hawthorn 5A

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 19-Apr-10 138480.5 MMBTU N/A

Day 2 20-Apr-10 136163.0 MMBTU N/A

Day 3 21-Apr-10 130584.9 MMBTU N/A

Day 4 22-Apr-10 130924.4 MMBTU N/A

Day 5 23-Apr-10 128281.4 MMBTU N/A

Day 6 24-Apr-10 121294.5 MMBTU N/A

Day 7 25-Apr-10 57366.9 MMBTU N/A

Day 8 26-Apr-10 151549.0 MMBTU N/A

Day 9 27-Apr-10 141203.6 MMBTU N/A

Day 10 28-Apr-10 124664.2 MMBTU N/A

Day 11 29-Apr-10 120883.5 MMBTU N/A

Day 12 30-Apr-10 134405.3 MMBTU N/A

Day 13 01-May-10 139272.2 MMBTU N/A

Day 14 02-May-10 140698.7 MMBTU N/A

Day 15 05-May-10 134784.4 MMBTU N/A

Day 16 06-May-10 137085.1 MMBTU N/A

Day 17 07-May-10 138847.0 MMBTU N/A

Day 18 08-May-10 142977.7 MMBTU N/A

Day 19 09-May-10 142874.5 MMBTU N/A

Day 20 10-May-10 138141.0 MMBTU N/A

Day 21 11-May-10 122305.8 MMBTU N/A

Day 22 12-May-10 135168.4 MMBTU N/A

Day 23 13-May-10 134457.2 MMBTU N/A

Day 24 14-May-10 130943.4 MMBTU N/A

Day 25 15-May-10 137890.4 MMBTU N/A

Day 26 16-May-10 139295.8 MMBTU N/A

Day 27 17-May-10 134481.5 MMBTU N/A

Day 28 18-May-10 138372.6 MMBTU N/A

Day 29 19-May-10 137302.7 MMBTU N/A

Day 30 20-May-10 135393.7 MMBTU N/A

30-Day Average 132536.4 MMBTU N/A
he Testing Date

Synfuel Firing Rate (units) Pet Coke Firing Rate Pet Coke Firing Rate (units) Coal Gas Firing Rate

N/A N/A N/A N/A

N/A N/A N/A N/A

N/A N/A N/A N/A

N/A N/A N/A N/A

N/A N/A N/A N/A

N/A N/A N/A N/A

N/A N/A N/A N/A

N/A N/A N/A N/A

N/A N/A N/A N/A

N/A N/A N/A N/A

N/A N/A N/A N/A

N/A N/A N/A N/A

N/A N/A N/A N/A

N/A N/A N/A N/A

N/A N/A N/A N/A

N/A N/A N/A N/A

N/A N/A N/A N/A

N/A N/A N/A N/A

N/A N/A N/A N/A

N/A N/A N/A N/A

N/A N/A N/A N/A

N/A N/A N/A N/A

N/A N/A N/A N/A

N/A N/A N/A N/A

N/A N/A N/A N/A

N/A N/A N/A N/A

N/A N/A N/A N/A

N/A N/A N/A N/A

N/A N/A N/A N/A

N/A N/A N/A N/A

N/A N/A N/A N/A
Coal Gas Firing Rate (units) Fuel oil Firing Rate Fuel oil Firing Rate (units)

N/A N/A N/A

N/A N/A N/A

N/A N/A N/A

N/A N/A N/A

N/A N/A N/A

N/A N/A N/A

N/A N/A N/A

N/A N/A N/A

N/A N/A N/A

N/A N/A N/A

N/A N/A N/A

N/A N/A N/A

N/A N/A N/A

N/A N/A N/A

N/A N/A N/A

N/A N/A N/A

N/A N/A N/A

N/A N/A N/A

N/A N/A N/A

N/A N/A N/A

N/A N/A N/A

N/A N/A N/A

N/A N/A N/A

N/A N/A N/A

N/A N/A N/A

N/A N/A N/A

N/A N/A N/A

N/A N/A N/A

N/A N/A N/A

N/A N/A N/A

N/A N/A N/A
Average Heat Input (MMBtu/hr) Steam Output (1,000 lbs steam/hr)

5770.0 3426.443325

5673.5 3392.532486

5441.0 3267.43465

5455.2 3323.567488

5345.1 2991.015432

6314.5 2701.251781

5883.5 1392.50331

5194.3 3328.853462

5036.8 3416.829702

5600.2 3212.680463

5803.0 3046.057234

5862.4 3379.166982

5616.0 3449.642588

5711.9 3446.670352

5785.3 3404.040312

5957.4 3408.108291

5953.1 3457.074345

5755.9 3424.790525

5096.1 3440.088247

5632.0 3434.434888

5602.4 3091.256165

5456.0 3306.26441

5745.4 3303.964004

5804.0 3156.546695

5603.4 3073.086357

5765.5 3410.978675

5720.9 3256.545833

5641.4 3422.044355

5526.3 3411.574997

4972.6 3366.739665

5624.2 3238.1
Unit Net Electric Generation (MWh) Unit Gross Electric Generation (MWe)

545.648151 569.8327624

541.668344 566.079631

525.1135085 548.9971913

531.8796702 556.3732364

475.3705392 498.7664759

424.1805279 446.3132849

145.4797416 160.407468

528.3501206 552.6870464

543.2863833 568.068215

512.902051 536.1608668

481.6759712 504.9237981

536.3589725 560.9498121

544.9744572 569.9173234

544.6100404 570.0887025

530.7886942 554.9555585

540.9272917 565.3764038

545.1225662 569.9790282

543.3564374 567.7127972

545.2090331 569.7333605

541.489404 566.2899347

485.7528964 509.0142087

520.2728721 544.6898225

519.7751402 543.5895041

498.901479 521.9731782

486.65996 509.2862101

541.5716038 565.3813618

516.5683662 539.7658818

543.3541158 566.9504855

540.1896456 563.9158853

534.7147769 558.7328992

510.5 534.2
Control Device Operating Parameters, As Appicable

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

1183397.3 N/A

1185911.6 N/A

1162590.9 N/A

1189921.3 N/A

1290802.0 N/A

1382763.6 N/A

1257193.1 N/A

1120020.8 N/A

1101771.9 N/A

1168070.5 N/A

1184760.5 N/A

1203125.6 N/A

1180017.7 N/A

1198053.2 N/A

1215988.0 N/A

1209535.7 N/A

1218095.0 N/A

1221657.2 N/A

1112240.9 N/A

1200229.6 N/A

1177500.5 N/A

1131265.6 N/A

1109673.9 N/A

1177785.5 N/A

1140671.9 N/A

1162247.1 N/A

1164103.5 N/A

1159220.1 N/A

1125091.4 N/A

1055399.6 N/A

1179636.9 N/A
FGD Scrubber Liquor Flow Rate (gals/min) Sorbent Type Sorbent Injection Rate (lb/hr)

375.5544583 N/A N/A

372.038566 N/A N/A

379.535321 N/A N/A

373.6610596 N/A N/A

360.8213989 N/A N/A

346.6427436 N/A N/A

102.0589363 N/A N/A

394.2400167 N/A N/A

400.0449074 N/A N/A

363.875322 N/A N/A

355.5311698 N/A N/A

377.0097996 N/A N/A

354.470434 N/A N/A

314.3882993 N/A N/A

407.5932169 N/A N/A

373.9852603 N/A N/A

366.5361545 N/A N/A

364.1563624 N/A N/A

377.3277608 N/A N/A

361.1461674 N/A N/A

339.699594 N/A N/A

373.7266838 N/A N/A

349.1058802 N/A N/A

352.5937498 N/A N/A

345.0288308 N/A N/A

367.6064735 N/A N/A

346.8047342 N/A N/A

324.7051158 N/A N/A

363.3738826 N/A N/A

362.8303249 N/A N/A

354.9 N/A N/A
Other Boiler or Control Device Operating Parameters (e.g., Boiler O2) 

Flue Gas Pressure (atm) Flue Gas Sampling Point Temperature (Deg F)

N/A N/A

N/A N/A

N/A N/A

N/A N/A

N/A N/A

N/A N/A

N/A N/A

N/A N/A

N/A N/A

N/A N/A

N/A N/A

N/A N/A

N/A N/A

N/A N/A

N/A N/A

N/A N/A

N/A N/A

N/A N/A

N/A N/A

N/A N/A

N/A N/A

N/A N/A

N/A N/A

N/A N/A

N/A N/A

N/A N/A

N/A N/A

N/A N/A

N/A N/A

N/A N/A

N/A N/A
Flue Gas Oxygen Content (%) Flue Gas Carbon Dioxide Content (%) Flue Gas Moisture Content (%)

N/A N/A N/A

N/A N/A N/A

N/A N/A N/A

N/A N/A N/A

N/A N/A N/A

N/A N/A N/A

N/A N/A N/A

N/A N/A N/A

N/A N/A N/A

N/A N/A N/A

N/A N/A N/A

N/A N/A N/A

N/A N/A N/A

N/A N/A N/A

N/A N/A N/A

N/A N/A N/A

N/A N/A N/A

N/A N/A N/A

N/A N/A N/A

N/A N/A N/A

N/A N/A N/A

N/A N/A N/A

N/A N/A N/A

N/A N/A N/A

N/A N/A N/A

N/A N/A N/A

N/A N/A N/A

N/A N/A N/A

N/A N/A N/A

N/A N/A N/A

N/A N/A N/A
EIA Facility Code Facility Name Boiler ID

2079 Hawthorn 5A

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

2079 Hawthorn 5A

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 19-Apr-10 138480.5 MMBTU

Day 2 20-Apr-10 136163.0 MMBTU

Day 3 21-Apr-10 130584.9 MMBTU

Day 4 22-Apr-10 130924.4 MMBTU

Day 5 23-Apr-10 128281.4 MMBTU

Day 6 24-Apr-10 121294.5 MMBTU

Day 7 25-Apr-10 57366.9 MMBTU

Day 8 26-Apr-10 151549.0 MMBTU

Day 9 27-Apr-10 141203.6 MMBTU

Day 10 28-Apr-10 124664.2 MMBTU

Day 11 29-Apr-10 120883.5 MMBTU

Day 12 30-Apr-10 134405.3 MMBTU

Day 13 01-May-10 139272.2 MMBTU

Day 14 02-May-10 140698.7 MMBTU

Day 15 05-May-10 134784.4 MMBTU

Day 16 06-May-10 137085.1 MMBTU

Day 17 07-May-10 138847.0 MMBTU

Day 18 08-May-10 142977.7 MMBTU

Day 19 09-May-10 142874.5 MMBTU

Day 20 10-May-10 138141.0 MMBTU

Day 21 11-May-10 122305.8 MMBTU

Day 22 12-May-10 135168.4 MMBTU

Day 23 13-May-10 134457.2 MMBTU

Day 24 14-May-10 130943.4 MMBTU

Day 25 15-May-10 137890.4 MMBTU

Day 26 16-May-10 139295.8 MMBTU

Day 27 17-May-10 134481.5 MMBTU

Day 28 18-May-10 138372.6 MMBTU

Day 29 19-May-10 137302.7 MMBTU

Day 30 20-May-10 135393.7 MMBTU
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)

3426.443325

3392.532486

3267.43465

3323.567488

2991.015432

2701.251781

1392.50331

3328.853462

3416.829702

3212.680463

3046.057234

3379.166982

3449.642588

3446.670352

3404.040312

3408.108291

3457.074345

3424.790525

3440.088247

3434.434888

3091.256165

3306.26441

3303.964004

3156.546695

3073.086357

3410.978675

3256.545833

3422.044355

3411.574997

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

545.648151 569.8327624

541.668344 566.079631

525.1135085 548.9971913

531.8796702 556.3732364

475.3705392 498.7664759

424.1805279 446.3132849

145.4797416 160.407468

528.3501206 552.6870464

543.2863833 568.068215

512.902051 536.1608668

481.6759712 504.9237981

536.3589725 560.9498121

544.9744572 569.9173234

544.6100404 570.0887025

530.7886942 554.9555585

540.9272917 565.3764038

545.1225662 569.9790282

543.3564374 567.7127972

545.2090331 569.7333605

541.489404 566.2899347

485.7528964 509.0142087

520.2728721 544.6898225

519.7751402 543.5895041

498.901479 521.9731782

486.65996 509.2862101

541.5716038 565.3813618

516.5683662 539.7658818

543.3541158 566.9504855

540.1896456 563.9158853

534.7147769 558.7328992
Control Device Operating Parameters, As Appicable

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

N/A

N/A

N/A

N/A

N/A

N/A

N/A

N/A

N/A

N/A

N/A

N/A

N/A

N/A

N/A

N/A

N/A

N/A

N/A

N/A

N/A

N/A

N/A

N/A

N/A

N/A

N/A

N/A

N/A

N/A
FGD Scrubber Liquor Flow Rate (gals/min) Sorbent Type Sorbent Injection Rate (lb/hr)

375.5544583

372.038566

379.535321

373.6610596

360.8213989

346.6427436

102.0589363

394.2400167

400.0449074

363.875322

355.5311698

377.0097996

354.470434

314.3882993

407.5932169

373.9852603

366.5361545

364.1563624

377.3277608

361.1461674

339.699594

373.7266838

349.1058802

352.5937498

345.0288308

367.6064735

346.8047342

324.7051158

363.3738826

362.8303249
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

2079 Hawthorn 5A

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 19-Apr-10 138480.5 MMBTU

Day 2 20-Apr-10 136163.0 MMBTU

Day 3 21-Apr-10 130584.9 MMBTU

Day 4 22-Apr-10 130924.4 MMBTU

Day 5 23-Apr-10 128281.4 MMBTU

Day 6 24-Apr-10 121294.5 MMBTU

Day 7 25-Apr-10 57366.9 MMBTU

Day 8 26-Apr-10 151549.0 MMBTU

Day 9 27-Apr-10 141203.6 MMBTU

Day 10 28-Apr-10 124664.2 MMBTU

Day 11 29-Apr-10 120883.5 MMBTU

Day 12 30-Apr-10 134405.3 MMBTU

Day 13 01-May-10 139272.2 MMBTU

Day 14 02-May-10 140698.7 MMBTU

Day 15 05-May-10 134784.4 MMBTU

Day 16 06-May-10 137085.1 MMBTU

Day 17 07-May-10 138847.0 MMBTU

Day 18 08-May-10 142977.7 MMBTU

Day 19 09-May-10 142874.5 MMBTU

Day 20 10-May-10 138141.0 MMBTU

Day 21 11-May-10 122305.8 MMBTU

Day 22 12-May-10 135168.4 MMBTU

Day 23 13-May-10 134457.2 MMBTU

Day 24 14-May-10 130943.4 MMBTU

Day 25 15-May-10 137890.4 MMBTU

Day 26 16-May-10 139295.8 MMBTU

Day 27 17-May-10 134481.5 MMBTU

Day 28 18-May-10 138372.6 MMBTU

Day 29 19-May-10 137302.7 MMBTU

Day 30 20-May-10 135393.7 MMBTU
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)

3426.443325

3392.532486

3267.43465

3323.567488

2991.015432

2701.251781

1392.50331

3328.853462

3416.829702

3212.680463

3046.057234

3379.166982

3449.642588

3446.670352

3404.040312

3408.108291

3457.074345

3424.790525

3440.088247

3434.434888

3091.256165

3306.26441

3303.964004

3156.546695

3073.086357

3410.978675

3256.545833

3422.044355

3411.574997

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

545.648151 569.8327624

541.668344 566.079631

525.1135085 548.9971913

531.8796702 556.3732364

475.3705392 498.7664759

424.1805279 446.3132849

145.4797416 160.407468

528.3501206 552.6870464

543.2863833 568.068215

512.902051 536.1608668

481.6759712 504.9237981

536.3589725 560.9498121

544.9744572 569.9173234

544.6100404 570.0887025

530.7886942 554.9555585

540.9272917 565.3764038

545.1225662 569.9790282

543.3564374 567.7127972

545.2090331 569.7333605

541.489404 566.2899347

485.7528964 509.0142087

520.2728721 544.6898225

519.7751402 543.5895041

498.901479 521.9731782

486.65996 509.2862101

541.5716038 565.3813618

516.5683662 539.7658818

543.3541158 566.9504855

540.1896456 563.9158853

534.7147769 558.7328992
Control Device Operating Parameters, As Appicable

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

N/A

N/A

N/A

N/A

N/A

N/A

N/A

N/A

N/A

N/A

N/A

N/A

N/A

N/A

N/A

N/A

N/A

N/A

N/A

N/A

N/A

N/A

N/A

N/A

N/A

N/A

N/A

N/A

N/A

N/A
FGD Scrubber Liquor Flow Rate (gals/min) Sorbent Type Sorbent Injection Rate (lb/hr)

375.5544583

372.038566

379.535321

373.6610596

360.8213989

346.6427436

102.0589363

394.2400167

400.0449074

363.875322

355.5311698

377.0097996

354.470434

314.3882993

407.5932169

373.9852603

366.5361545

364.1563624

377.3277608

361.1461674

339.699594

373.7266838

349.1058802

352.5937498

345.0288308

367.6064735

346.8047342

324.7051158

363.3738826

362.8303249
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 (%)