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

4042 Valley 3
EIA Facility Code Facility Name Boiler ID

4042 Valley 3

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

4042 Valley 3

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

4042 Valley 3

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

4042 Valley 3

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/24/2010 74.70833333 1,000 lbs per hour

Day 2 3/25/2010 77.08333333 1,000 lbs per hour

Day 3 3/26/2010 87 1,000 lbs per hour

Day 4 3/27/2010 80.95833333 1,000 lbs per hour

Day 5 3/28/2010 80.16666667 1,000 lbs per hour

Day 6 3/29/2010 86.375 1,000 lbs per hour

Day 7 3/30/2010 80.04166667 1,000 lbs per hour

Day 8 3/31/2010 69.29166667 1,000 lbs per hour

Day 9 4/1/2010 72.95833333 1,000 lbs per hour

Day 10 4/2/2010 75 1,000 lbs per hour

Day 11 4/3/2010 72.45833333 1,000 lbs per hour

Day 12 4/4/2010 71.91666667 1,000 lbs per hour

Day 13 4/5/2010 72.5 1,000 lbs per hour

Day 14 4/6/2010 72 1,000 lbs per hour

Day 15 4/7/2010 77.125 1,000 lbs per hour

Day 16 4/8/2010 76.70833333 1,000 lbs per hour

Day 17 4/9/2010 79.125 1,000 lbs per hour

Day 18 4/10/2010 71.75 1,000 lbs per hour

Day 19 4/11/2010 66.83333333 1,000 lbs per hour

Day 20 4/12/2010 67.625 1,000 lbs per hour

Day 21 4/13/2010 66.95833333 1,000 lbs per hour

Day 22 4/14/2010 65.58333333 1,000 lbs per hour

Day 23 4/15/2010 64.29166667 1,000 lbs per hour

Day 24 4/16/2010 67.79166667 1,000 lbs per hour

Day 25 4/17/2010 68.25 1,000 lbs per hour

Day 26 4/18/2010 69.75 1,000 lbs per hour

Day 27 4/19/2010 70.79166667 1,000 lbs per hour

Day 28 4/20/2010 94.16666667 1,000 lbs per hour

Day 29 4/21/2010 85.58333333 1,000 lbs per hour

Day 30 4/22/2010 87.25 1,000 lbs per hour
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)

513.5708333 399.9166667

545.5041667 416.3333333

599.7875 467.2916667

562.3166667 430.8333333

551.675 422.7083333

574.8375 446.9166667

539.8875 421.0416667

377.8791667 298.9166667

370.1958333 285.125

374.6583333 293.5833333

371.0125 290.5833333

371.8833333 288.5416667

374.225 292.9583333

371.9375 287.5416667

467.7083333 365.75

505.1166667 378.4583333

541.8625 420.1666667

470.8333333 380

345.9333333 271.3333333

349.6833333 271.2916667

346.175 270.2916667

342.4666667 266.375

328.9333333 263.0416667

355.125 275.1666667

357.325 282.2083333

369.35 285.0833333

369.825 287.25

591.8041667 457.3333333

530.1791667 406.125

526.7041667 412.1666667
Unit Net Electric Generation (MWh) Unit Gross Electric Generation (MWe)

28.68091781 31.59981273

28.69494823 31.52236876

32.4075746 35.56606435

30.6280612 33.91968035

30.80265004 33.9226444

32.00005467 35.33943436

30.71540587 33.84326708

23.0707755 25.28997195

22.13859384 24.38526929

23.0366193 25.42152941

22.23630936 24.44430083

22.35252145 24.54233195

22.45630829 24.80397698

20.68409991 22.83716499

26.62920023 29.44740634

25.48425715 28.29430671

28.36330529 31.74180327

28.17804353 31.41852262

17.36299264 19.80868449

16.87319659 19.02013832

17.24599233 19.42179125

18.36446451 20.5215519

19.23455335 21.32951754

19.92076201 21.87432254

19.32566604 21.3366157

19.31167953 21.5390947

19.10853014 21.36075307

38.6364411 41.83141541

31.69273274 34.6301287

32.36027041 35.72725693
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)

0.965993674 294.3958333

0.963264288 291.6208333

0.966787424 295.3083333

0.963278214 295.125

0.95855749 295.6333333

0.963278214 299.2041667

0.959086657 295.45

0.956566153 293.825

0.958028324 297.425

0.956802885 294.0875

0.955660999 291.2416667

0.960465275 289.3458333

0.964099814 292.2541667

0.951734026 293.5375

0.951330188 297.55

0.955452118 298.675

0.965798718 296.775

0.969753542 293.1333333

0.978136655 284.3541667

0.976549156 284.175

0.974209682 287.1416667

0.97556045 286.4625

0.9715917 285.5230769

0.970463739 286.3333333

0.970561217 281.1958333

0.971981612 279.55

0.972914616 283.0666667

0.96808249 302.25

0.960103214 295.3875

0.961064069 295.8
Flue Gas Oxygen Content (%) Flue Gas Carbon Dioxide Content (%) Flue Gas Moisture Content (%)

9.025 11.875

8.983 11.91666667

8.792 12.10833333

8.967 11.93333333

9.092 11.80833333

9.013 11.8875

9.113 11.7875

9.379 11.52083333

9.517 11.38333333

9.588 11.3125

9.429 11.47083333

9.308 11.59166667

9.246 11.65416667

9.267 11.63333333

9.104 11.79583333

9.071 11.82916667

9.054 11.84583333

9.204 11.69583333

9.367 11.53333333

9.329 11.57083333

9.404 11.49583333

9.517 11.38333333

9.600 11.3

9.458 11.44166667

9.358 11.54166667

9.308 11.59166667

9.313 11.5875

9.096 11.80416667

9.133 11.76666667

9.108 11.79166667