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

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

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

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

4042 Valley 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 07/06/10 28.375 1,000 lbs/hr

Day 2 07/07/10 28.75 1,000 lbs/hr

Day 3 07/08/10 37.29166667 1,000 lbs/hr

Day 4 07/09/10 58.5 1,000 lbs/hr

Day 5 07/10/10 56.95833333 1,000 lbs/hr

Day 6 07/11/10 56.54166667 1,000 lbs/hr

Day 7 07/12/10 17.875 1,000 lbs/hr

Day 8 07/13/10 6.583333333 1,000 lbs/hr

Day 9 07/14/10 44.5 1,000 lbs/hr

Day 10 07/15/10 4.041666667 1,000 lbs/hr

Day 11 07/16/10 0 1,000 lbs/hr

Day 12 07/17/10 53.5 1,000 lbs/hr

Day 13 07/18/10 59.95833333 1,000 lbs/hr

Day 14 07/19/10 63.20833333 1,000 lbs/hr

Day 15 07/20/10 65.08333333 1,000 lbs/hr

Day 16 07/21/10 63.33333333 1,000 lbs/hr

Day 17 07/22/10 51.20833333 1,000 lbs/hr

Day 18 07/23/10 44.58333333 1,000 lbs/hr

Day 19 07/24/10 63.79166667 1,000 lbs/hr

Day 20 07/25/10 46 1,000 lbs/hr

Day 21 07/26/10 53.54166667 1,000 lbs/hr

Day 22 07/27/10 12.375 1,000 lbs/hr

Day 23 07/28/10 0 1,000 lbs/hr

Day 24 07/29/10 0 1,000 lbs/hr

Day 25 07/30/10 0 1,000 lbs/hr

Day 26 07/31/10 0 1,000 lbs/hr

Day 27 08/01/10 0 1,000 lbs/hr

Day 28 08/02/10 0 1,000 lbs/hr

Day 29 08/03/10 42.54166667 1,000 lbs/hr

Day 30 08/04/10 62.875 1,000 lbs/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)

676.4208333 497.7916667

692.8625 511.9583333

686.6083333 534.0416667

625.7791667 532.25

601.1375 503.9583333

597.5458333 502.3333333

169.8375 233.125

79.975 117.6666667

540.2291667 385.75

111.7958333 61.29166667

14.27916667 67.95833333

572.7208333 446.7083333

599.5583333 471.4583333

657.1958333 511.4166667

687.8083333 541.7916667

671.4916667 525.8333333

540.4583333 431.2083333

552.5583333 353.1666667

657.475 498.6666667

493.1583333 381.0833333

544.2 388.2083333

104.7708333 116.375

0 103.75

0 97.45833333

0 0

0 0

0 0

3.866666667 0

504.875 390.375

677.5166667 569
Unit Net Electric Generation (MWh) Unit Gross Electric Generation (MWe)

47.20833333 50.29166667

48.54166667 51.5

48.25 51.375

44.58333333 47.04166667

42.70833333 44.79166667

41.20833333 43.125

13.5 14.41666667

3.041666667 3.291666667

35.5 38.79166667

2.875 3.375

0.583333333 0.75

40.125 42.83333333

41.79166667 44.54166667

45.41666667 49

49.08333333 52.20833333

47.41666667 50.875

37.83333333 39.83333333

27.08333333 28.95833333

24.83333333 27.66666667

25.04166667 26.95833333

0.5 0.333333333

0.416666667 0.625

0.625 0.625

0.458333333 0.375

0.291666667 0.541666667

0.375 0.5

0.375 0.583333333

0.333333333 0.583333333

33.375 35.66666667

49.33333333 52.125
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.983846085 288.9916667

0.986770427 290.2541667

0.985196852 297.7916667

0.985851348 320.125

0.983957488 320.6541667

0.977774594 319.1708333

0.976590932 233.025

0.979835559 155.3583333

0.982913081 267.5666667

0.981255953 218.2375

0.981186326 150.55

0.981590164 285.1333333

0.979738081 297.2583333

0.981353432 319.175

0.981854747 316.9083333

0.986561545 314.3208333

0.980587532 297.8375

0.978067028 288.75

0.980462204 310.5833333

0.986951457 288.2666667

0.9875224 272.6416667

0.983456173 193.525

0.981715493 124.6875

0.985419659 110.9208333

0.981074923 104.1541667

0.976103542 99.9875

0.98004444 101.4291667

0.980754638 107.3916667

0.98050398 287.0416667

0.980587532 317.2625
Flue Gas Oxygen Content (%) Flue Gas Carbon Dioxide Content (%) Flue Gas Moisture Content (%)

10.52083333 10.37916667

10.57916667 10.32083333

10.525 10.375

9.541666667 11.35833333

9.554166667 11.34583333

9.545833333 11.35416667

17.89166667 3.008333333

19.275 1.625

12.87916667 8.020833333

18.57916667 2.320833333

20.55416667 0.345833333

12.64166667 8.258333333

11.6625 9.2375

10.33333333 10.56666667

10.65 10.25

10.70833333 10.19166667

11.69583333 9.204166667

10.75833333 10.14166667

10.09166667 10.80833333

10.95416667 9.945833333

10.51666667 10.38333333

18.57916667 2.320833333

20.9 0

20.9 0

20.9 0

20.9 0

20.9 0

20.8 0.1

13.025 7.875

10.48333333 10.41666667