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

641 Crist 4,5,6,7
EIA Facility Code Facility Name Boiler ID

641 Crist 4,5,6,7

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

641 Crist 4,5,6,7

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

641 Crist 4,5,6,7

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

641 Crist 4,5,6,7

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

Day 2 4/2/2010

Day 3 4/3/2010

Day 4 4/4/2010

Day 5 4/5/2010

Day 6 4/6/2010

Day 7 4/7/2010

Day 8 4/8/2010

Day 9 4/9/2010

Day 10 4/10/2010

Day 11 4/11/2010

Day 12 4/12/2010

Day 13 4/13/2010

Day 14 4/14/2010

Day 15 4/15/2010

Day 16 4/16/2010

Day 17 4/17/2010

Day 18 4/18/2010

Day 19 4/19/2010

Day 20 4/20/2010

Day 21 4/21/2010

Day 22 4/22/2010

Day 23 4/23/2010

Day 24 4/24/2010

Day 25 4/25/2010

Day 26 4/26/2010

Day 27 4/27/2010

Day 28 4/28/2010

Day 29 4/29/2010

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

NA

NA

NA

NA

NA

2436.64

4494.37

NA

NA

4137.00

4380.27

4874.46

4783.52

4353.40

4946.78

4546.57

4663.13

4680.21

3955.39

3862.60

4487.38

4332.64

4936.55

5095.56

6683.02

6207.08

8017.46

8450.94

5964.22

6403.76
Unit Net Electric Generation (MWh) Unit Gross Electric Generation (MWe)

363.240

352.880

346.710

287

244

272

200.710

387.920

482.170

328.620

357.970

378.650

435.660

425.740

377.610

441.020

451.830

410.410

417.060

345.150

335.830

401.210

379.280

439.410

440.520

578.660

538.870

716.330

763.070

512.080
Control Device Operating Parameters, As Appicable

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

NA 13.47

NA 13.47

NA 13.22

NA 11.15

NA 13.10

1,043,652.000 12.86

1,673,119.696 12.63

NA N/A

NA N/A

1,331,872.125 13.35

1,382,216.125 14.80

1,494,765.125 13.89

1,468,755.750 13.62

1,384,249.750 13.52

1,484,419.375 13.96

1,448,576.478 14.31

1,448,357.875 14.25

1,438,142.625 13.93

1,322,606.625 13.76

1,293,787.875 13.44

1,403,498.500 13.86

1,370,173.875 13.63

1,567,076.625 14.70

1,796,412.250 15.49

1,980,518.750 15.38

1,885,250.125 14.57

2,244,552.875 15.80

2,330,780.750 17.25

1,843,830.875 15.35

1,940,121.750 15.83
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 (%)

9.234

7.883

8.324

8.041

8.194

7.189

7.763

9.952

9.080

9.306

9.454

9.703

9.717

9.406

9.904

9.296

9.607

9.684

8.961

8.956

9.569

9.468

9.373

8.491

10.105

9.875

10.603

10.747

9.703

9.880