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

4042 Valley 4
EIA Facility Code Facility Name Boiler ID

4042 Valley 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

4042 Valley 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

4042 Valley 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

4042 Valley 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 4/1/2010 44.79166667 1,000 lbs per hour

Day 2 4/2/2010 44.875 1,000 lbs per hour

Day 3 4/3/2010 47.625 1,000 lbs per hour

Day 4 4/4/2010 45.75 1,000 lbs per hour

Day 5 4/5/2010 48.5 1,000 lbs per hour

Day 6 4/6/2010 53 1,000 lbs per hour

Day 7 4/7/2010 53.20833333 1,000 lbs per hour

Day 8 4/8/2010 54.41666667 1,000 lbs per hour

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

Day 10 4/10/2010 43.79166667 1,000 lbs per hour

Day 11 4/11/2010 44 1,000 lbs per hour

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

Day 13 4/13/2010 50 1,000 lbs per hour

Day 14 4/14/2010 46.375 1,000 lbs per hour

Day 15 4/15/2010 41.54166667 1,000 lbs per hour

Day 16 4/16/2010 44.25 1,000 lbs per hour

Day 17 4/17/2010 45.875 1,000 lbs per hour

Day 18 4/18/2010 44.875 1,000 lbs per hour

Day 19 4/19/2010 47.83333333 1,000 lbs per hour

Day 20 4/20/2010 48.25 1,000 lbs per hour

Day 21 4/21/2010 48.79166667 1,000 lbs per hour

Day 22 4/22/2010 51.66666667 1,000 lbs per hour

Day 23 4/23/2010 45.33333333 1,000 lbs per hour

Day 24 4/24/2010 46.25 1,000 lbs per hour

Day 25 4/25/2010 47.33333333 1,000 lbs per hour

Day 26 4/26/2010 47.83333333 1,000 lbs per hour

Day 27 4/27/2010 54.625 1,000 lbs per hour

Day 28 4/28/2010 54.83333333 1,000 lbs per hour

Day 29 4/29/2010 56.125 1,000 lbs per hour

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

567.8125 385.2083333

518.3625 382.4583333

525.0166667 413.7916667

489.9833333 390

490.2083333 414.7916667

517.5875 595.8333333

502.225 458.5833333

527.225 452.3333333

583.1125 416.2083333

595.4291667 376.0416667

584.3541667 385

537.8791667 383.1666667

482.9708333 424.3333333

481.2666667 395.5

496.1041667 370.4166667

538.775 400.875

505.9708333 407.5

465.9 399.6666667

497.4208333 417.5

502.9125 418.2916667

498.2708333 431.0416667

525.2708333 446.9583333

540 405.125

558.35 415.375

566.7958333 416.125

509.9 416.4583333

516.0958333 467.4166667

511.6 462.3333333

503.7083333 474.7916667

588.1625 467.125
Unit Net Electric Generation (MWh) Unit Gross Electric Generation (MWe)

52.57428636 57.84095303

53.56537923 59.07787923

54.46193038 59.82443038

53.11625552 58.26625552

54.75123811 60.46790478

55.12077347 60.84160681

60.30995627 66.63912293

56.21560068 62.40726735

56.95619008 63.68952341

56.41504035 62.86920702

42.62618384 48.5678505

41.25179488 46.43096154

44.90157912 50.51407912

46.0965059 51.45067256

46.87602662 51.92602662

49.54852498 54.41935831

47.84012896 52.73596229

46.99930037 52.3451337

47.46672798 52.96256131

73.159465 79.384465

64.61042141 70.63125474

66.49361371 73.46444704

46.30034883 51.93368217

48.05237605 53.21487605

47.38722235 52.59138902

48.17409792 53.73659792

56.67648148 63.06814815

57.42863505 63.53113505

61.19395591 66.78562257

60.04786207 65.4311954
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.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

0.963877007 286.4416667

0.952235342 292.7208333

0.943448391 283.6583333

0.951344114 284.6958333

0.95917021 291.7208333
Flue Gas Oxygen Content (%) Flue Gas Carbon Dioxide Content (%) Flue Gas Moisture Content (%)

9.0125 11.8875

9.1125 11.7875

9.379166667 11.52083333

9.516666667 11.38333333

9.5875 11.3125

9.429166667 11.47083333

9.308333333 11.59166667

9.245833333 11.65416667

9.266666667 11.63333333

9.104166667 11.79583333

9.070833333 11.82916667

9.054166667 11.84583333

9.204166667 11.69583333

9.366666667 11.53333333

9.329166667 11.57083333

9.404166667 11.49583333

9.516666667 11.38333333

9.6 11.3

9.458333333 11.44166667

9.358333333 11.54166667

9.308333333 11.59166667

9.3125 11.5875

9.095833333 11.80416667

9.133333333 11.76666667

9.108333333 11.79166667

9.329166667 11.57083333

9.566666667 11.33333333

9.791666667 11.10833333

9.741666667 11.15833333

9.508333333 11.39166667