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

6170 Pleasant Prairie 1

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/25/2010 105.811 TONS/HR

Day 2 3/26/2010 251.616 TONS/HR

Day 3 3/27/2010 261.729 TONS/HR

Day 4 3/28/2010 298.416 TONS/HR

Day 5 3/29/2010 108.802 TONS/HR

Day 6 3/30/2010 0.000 TONS/HR

Day 7 3/31/2010 161.218 TONS/HR

Day 8 4/1/2010 206.742 TONS/HR

Day 9 4/2/2010 279.005 TONS/HR

Day 10 4/3/2010 323.589 TONS/HR

Day 11 4/4/2010 322.472 TONS/HR

Day 12 4/5/2010 320.443 TONS/HR

Day 13 4/6/2010 364.535 TONS/HR

Day 14 4/7/2010 335.885 TONS/HR

Day 15 4/8/2010 305.854 TONS/HR

Day 16 4/9/2010 336.777 TONS/HR

Day 17 4/10/2010 340.423 TONS/HR

Day 18 4/11/2010 327.520 TONS/HR

Day 19 4/12/2010 334.453 TONS/HR

Day 20 4/13/2010 355.485 TONS/HR

Day 21 4/14/2010 352.461 TONS/HR

Day 22 4/15/2010 354.798 TONS/HR

Day 23 4/16/2010 334.547 TONS/HR

Day 24 4/17/2010 358.569 TONS/HR

Day 25 4/18/2010 358.884 TONS/HR

Day 26 4/19/2010 342.363 TONS/HR

Day 27 4/20/2010 354.616 TONS/HR

Day 28 4/21/2010 323.707 TONS/HR

Day 29 4/22/2010 336.531 TONS/HR

Day 30 4/23/2010 358.759 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)

2112.2 1538.724

4379.2 2886.252

4598.2 3046.794

5380.1 3547.661

1943.4 1271.676

159.8 1.321

3210 2008.424

3654.9 2357.327

5046 3214.122

5803.9 3696.990

5757.3 3660.562

6600.6 3639.526

5826.4 4119.071

5548.5 3695.660

6021.6 3521.511

6111.7 3766.566

5825.6 3798.589

5882.4 3635.770

6510.5 3674.740

6342.1 4018.591

6482.6 3931.519

6000.9 4021.965

6463 3785.632

6479.7 4059.657

6359 4049.845

6516.9 3958.397

5933.9 4054.966

6236.3 3651.717

6445.8 3927.654

6323.4 4058.950
Unit Net Electric Generation (MWh) Unit Gross Electric Generation (MWe)

161.477 187.519

354.042 399.275

379.281 425.320

458.919 507.167

164.298 181.275

0.033 0.037

244.652 272.987

273.786 316.337

408.088 454.475

482.116 530.709

477.871 526.672

474.428 523.198

548.872 601.614

482.095 532.194

454.224 502.691

496.054 547.679

504.214 555.378

474.363 524.747

483.314 533.380

535.893 587.638

519.752 570.578

533.432 584.598

495.032 545.954

539.732 592.061

541.157 593.318

526.382 578.672

540.237 592.562

481.960 529.398

521.219 569.755

538.269 590.554
Control Device Operating Parameters, As Appicable

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

2.823

4.848

5.121

5.659

2.914

1.520

3.839

3.815

5.219

5.755

5.640

5.607

6.502

6.012

5.683

6.205

6.239

5.870

5.874

6.389

6.137

6.329

5.952

6.442

6.334

6.250

6.432

6.071

6.303

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

238.847 limestone 7447.0

250.074 limestone 17243.5

249.762 limestone 16885.7

254.870 limestone 20728.2

262.171 limestone 7379.4

249.390 limestone 16.6

250.239 limestone 9896.3

257.051 limestone 10870.3

261.673 limestone 15962.7

263.444 limestone 18069.7

263.655 limestone 18742.3

263.252 limestone 18645.9

266.127 limestone 23184.8

260.014 limestone 21571.5

263.319 limestone 16109.1

262.167 limestone 17122.2

260.165 limestone 18429.6

262.060 limestone 18599.3

258.354 limestone 19982.2

262.975 limestone 21065.6

262.902 limestone 17581.1

261.716 limestone 17406.7

262.291 limestone 17922.5

259.841 limestone 21112.1

260.658 limestone 22434.2

264.647 limestone 19797.0

259.675 limestone 17767.8

266.937 limestone 13573.6

263.954 limestone 18703.8

262.198 limestone 26192.8
Other Boiler or Control Device Operating Parameters (e.g., Boiler O2) 

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

0.005 117.109

0.010 129.925

0.011 130.903

0.013 132.255

0.005 111.003

0.002 84.027

0.009 117.180

0.009 128.957

0.012 131.647

0.013 133.130

0.013 133.207

0.013 133.220

0.016 134.717

0.014 134.247

0.013 132.394

0.014 133.016

0.014 133.258

0.014 132.493

0.014 132.945

0.015 133.966

0.014 134.268

0.015 134.401

0.014 134.301

0.015 134.719

0.015 134.070

0.014 134.161

0.015 134.556

0.014 132.152

0.015 131.926

0.015 134.029
Flue Gas Oxygen Content (%) Flue Gas Carbon Dioxide Content (%) Flue Gas Moisture Content (%)

7.800 5.233

4.560 9.028

4.259 9.228

3.370 9.899

7.665 3.465

9.997 0.520

6.469 6.312

5.379 8.787

3.791 9.970

2.860 10.778

2.882 10.811

2.919 10.774

2.442 11.145

2.893 10.597

3.264 10.237

3.059 10.546

3.080 10.640

3.255 10.599

3.069 10.748

2.518 11.141

2.404 11.215

2.279 11.287

2.698 10.858

2.352 11.164

2.407 11.189

2.669 11.047

2.502 11.141

3.185 10.120

2.789 10.651

2.426 11.061
EIA Facility Code Facility Name Boiler ID

6170 Pleasant Prairie 1

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 1

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 1

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