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

6170 Pleasant Prairie 2
EIA Facility Code Facility Name Boiler ID

6170 Pleasant Prairie 2

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 3/21/2010 349.990 TONS/HR

Day 2 3/22/2010 369.532 TONS/HR

Day 3 3/23/2010 363.552 TONS/HR

Day 4 3/24/2010 358.037 TONS/HR

Day 5 3/25/2010 342.560 TONS/HR

Day 6 3/26/2010 349.155 TONS/HR

Day 7 3/27/2010 336.593 TONS/HR

Day 8 3/28/2010 328.682 TONS/HR

Day 9 3/29/2010 361.613 TONS/HR

Day 10 3/30/2010 351.666 TONS/HR

Day 11 3/31/2010 329.959 TONS/HR

Day 12 4/1/2010 334.305 TONS/HR

Day 13 4/2/2010 296.874 TONS/HR

Day 14 4/3/2010 308.985 TONS/HR

Day 15 4/4/2010 302.107 TONS/HR

Day 16 4/5/2010 300.343 TONS/HR

Day 17 4/6/2010 349.545 TONS/HR

Day 18 4/7/2010 371.603 TONS/HR

Day 19 4/8/2010 376.236 TONS/HR

Day 20 4/9/2010 372.101 TONS/HR

Day 21 4/10/2010 355.398 TONS/HR

Day 22 4/11/2010 329.814 TONS/HR

Day 23 4/12/2010 290.780 TONS/HR

Day 24 4/13/2010 350.659 TONS/HR

Day 25 4/14/2010 352.666 TONS/HR

Day 26 4/15/2010 326.197 TONS/HR

Day 27 4/16/2010 336.452 TONS/HR

Day 28 4/17/2010 347.951 TONS/HR

Day 29 4/18/2010 331.172 TONS/HR

Day 30 4/19/2010 329.733 TONS/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)

6178.6 3892.553

6525.2 4110.093

6477.7 4091.371

6403.4 4072.212

6149.8 3925.053

6316.2 4003.860

6035 3849.858

5868.8 3747.042

6459.5 4091.999

6352.3 4069.799

5958.5 3858.266

5965.6 3833.398

5293 3410.181

5480.2 3547.182

5331.4 3477.041

6178.3 3462.126

6289.1 3951.392

6394.3 4070.840

6282.4 4129.511

6161 4066.671

5784.7 3962.988

5162 3683.245

6292.1 3308.877

6322.6 3979.461

5901.8 3997.288

6097.5 3750.032

6220.4 3840.015

5863.3 3949.316

6113 3745.520

6508 3901.217
Unit Net Electric Generation (MWh) Unit Gross Electric Generation (MWe)

535.176 582.426

571.736 619.580

571.110 618.387

562.552 609.846

536.198 583.208

551.637 598.998

527.264 573.834

511.902 558.615

566.544 615.463

561.228 609.040

524.679 571.378

520.365 567.641

454.623 500.619

475.644 522.007

463.791 509.488

461.058 506.664

540.033 587.602

556.374 605.587

569.842 620.054

557.563 606.800

541.953 590.654

500.212 547.400

436.515 481.423

542.928 591.466

547.657 596.308

506.277 553.142

525.264 572.846

539.163 588.360

510.813 558.632

533.018 581.265
Control Device Operating Parameters, As Appicable

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

5.836

6.120

6.046

5.936

5.884

5.874

5.687

5.597

6.022

5.936

5.794

5.903

5.292

5.410

5.254

5.234

5.945

6.235

6.244

5.997

5.871

5.638

5.238

5.912

5.987

5.641

6.077

6.017

5.616

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

264.732 limestone 17753.5

260.903 limestone 19207.3

263.591 limestone 21426.2

265.225 limestone 24273.7

258.935 limestone 23569.1

264.849 limestone 24371.7

264.553 limestone 23066.1

259.339 limestone 22746.1

265.516 limestone 22219.6

266.047 limestone 19920.4

257.737 limestone 17865.1

263.241 limestone 19035.7

261.502 limestone 17763.9

262.606 limestone 17869.8

263.300 limestone 18344.1

264.032 limestone 18247.2

257.156 limestone 21917.8

265.833 limestone 23999.4

261.344 limestone 19489.0

260.921 limestone 18826.3

262.968 limestone 19512.1

262.602 limestone 19029.2

261.562 limestone 17978.6

257.661 limestone 20935.8

266.046 limestone 17857.4

264.109 limestone 16476.5

259.636 limestone 18528.0

263.042 limestone 20961.1

262.278 limestone 21024.2

259.267 limestone 19729.9
Other Boiler or Control Device Operating Parameters (e.g., Boiler O2) 

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

0.014 133.220

0.014 133.876

0.015 133.926

0.015 134.246

0.014 133.027

0.014 132.547

0.013 132.864

0.013 131.895

0.014 133.700

0.014 134.061

0.014 133.455

0.015 133.821

0.013 132.551

0.013 132.627

0.012 131.603

0.012 131.617

0.015 133.771

0.015 134.256

0.015 133.979

0.015 133.264

0.014 132.831

0.014 132.860

0.012 131.619

0.014 133.907

0.014 134.518

0.014 133.745

0.015 133.082

0.015 132.979

0.014 131.711

0.014 132.731
Flue Gas Oxygen Content (%) Flue Gas Carbon Dioxide Content (%) Flue Gas Moisture Content (%)

2.601 11.413

2.236 11.646

2.209 11.663

2.245 11.627

2.528 11.360

2.360 11.593

2.569 11.344

2.748 11.104

2.213 11.607

2.237 11.557

2.674 11.022

2.747 10.801

3.376 10.324

3.069 10.619

3.201 10.591

3.231 10.560

2.423 11.246

2.290 11.220

2.221 11.229

2.300 11.238

2.469 11.153

2.902 10.834

3.602 10.318

2.710 11.371

2.328 11.450

2.839 11.014

3.079 10.755

2.814 10.925

2.991 10.811

2.725 11.110
EIA Facility Code Facility Name Boiler ID

6170 Pleasant Prairie 2

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

6170 Pleasant Prairie 2

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

6170 Pleasant Prairie 2

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