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

6257 Scherer 1
EIA Facility Code Facility Name Boiler ID

6257 Scherer 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

6257 Scherer 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 12/23/2009 884.704 1,000 lb/hr

Day 2 12/24/2009 1006.159 1,000 lb/hr

Day 3 12/25/2009 934.515 1,000 lb/hr

Day 4 12/26/2009 937.877 1,000 lb/hr

Day 5 12/27/2009 970.190 1,000 lb/hr

Day 6 12/28/2009 960.994 1,000 lb/hr

Day 7 12/29/2009 871.704 1,000 lb/hr

Day 8 12/30/2009 1000.324 1,000 lb/hr

Day 9 12/31/2009 959.655 1,000 lb/hr

Day 10 1/1/2010 810.231 1,000 lb/hr

Day 11 1/2/2010 970.851 1,000 lb/hr

Day 12 1/3/2010 969.469 1,000 lb/hr

Day 13 1/4/2010 972.996 1,000 lb/hr

Day 14 1/5/2010 877.549 1,000 lb/hr

Day 15 1/6/2010 953.373 1,000 lb/hr

Day 16 1/7/2010 950.855 1,000 lb/hr

Day 17 1/8/2010 883.109 1,000 lb/hr

Day 18 1/9/2010 984.553 1,000 lb/hr

Day 19 1/10/2010 995.852 1,000 lb/hr

Day 20 1/11/2010 909.430 1,000 lb/hr

Day 21 1/12/2010 939.100 1,000 lb/hr

Day 22 1/13/2010 945.106 1,000 lb/hr

Day 23 1/14/2010 880.976 1,000 lb/hr

Day 24 1/15/2010 947.534 1,000 lb/hr

Day 25 1/16/2010 938.891 1,000 lb/hr

Day 26 1/17/2010 819.081 1,000 lb/hr

Day 27 1/18/2010 890.867 1,000 lb/hr

Day 28 1/19/2010 951.548 1,000 lb/hr

Day 29 1/20/2010 889.952 1,000 lb/hr

Day 30 1/21/2010 913.085 1,000 lb/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)

7,800.601 4942.974

8,703.538 5425.518

8,252.868 5095.600

8,083.542 5021.703

8,688.540 5309.486

8,507.937 5304.963

7,419.733 4648.253

8,521.897 5284.374

8,510.526 5245.652

7,240.420 4572.558

8,737.198 5515.323

8,566.556 5507.734

8,737.930 5490.828

7,879.322 5009.858

8,671.933 5476.944

8,562.707 5461.562

7,959.210 5112.832

8,758.802 5532.603

8,862.430 5623.519

8,234.184 5212.193

8,544.839 5445.047

8,573.528 5508.560

7,834.922 5051.472

8,380.108 5377.463

8,442.047 5372.453

7,117.580 4499.233

7,957.795 5,016.320

8,533.495 5,404.999

7,135.444 5,066.446

7,500.415 5,156.136
Unit Net Electric Generation (MWh) Unit Gross Electric Generation (MWe)

742.038 787.753

813.085 861.699

769.936 817.219

747.906 794.316

791.404 838.450

797.052 843.517

696.586 740.972

792.651 839.619

786.465 833.539

686.407 730.283

820.421 867.876

820.350 867.481

820.081 866.936

741.752 787.023

813.089 859.735

813.562 859.910

750.306 795.931

816.571 863.793

828.041 875.828

772.794 818.824

811.011 857.234

819.076 865.710

752.402 797.268

803.243 849.271

801.985 848.060

675.642 718.562

754.098 798.946

807.942 853.775

752.115 797.103

768.575 814.868
Control Device Operating Parameters, As Appicable

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

1,840,071.521

1,998,702.813

1,900,085.000

1,888,699.854

1,948,594.000

1,919,849.583

1,810,335.146

1,936,630.833

1,936,642.021

1,734,793.417

1,995,764.229

1,973,575.688

1,958,103.375

1,817,849.417

1,943,246.375

1,924,391.708

1,860,999.604

1,975,835.563

1,995,928.313

1,884,873.729

1,920,643.896

1,949,257.792

1,831,274.417

1,910,202.229

1,924,320.854

1,746,465.708

1,829,600.021

1,926,696.333

1,839,747.083

1,934,777.438
FGD Scrubber Liquor Flow Rate (gals/min) Sorbent Type Sorbent Injection Rate (lb/hr)

PAC 239.154

PAC 177.668

PAC 140.576

PAC 85.818

PAC 84.873

PAC 85.843

PAC 298.829

PAC 154.247

PAC 407.383

PAC 266.289

PAC 256.290

PAC 232.399

PAC 209.677

PAC 220.796

PAC 113.139

PAC 177.523

PAC 110.935

PAC 152.646

PAC 208.840

PAC 205.585

PAC 175.468

PAC 235.112

PAC 291.702

PAC 274.748

PAC 172.548

PAC 260.945

PAC 233.308

PAC 286.554

PAC 259.972

PAC 189.489
Other Boiler or Control Device Operating Parameters (e.g., Boiler O2) 

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

286.700

280.600

286.500

289.600

273.500

285.100

280.200

266.400

276.200

280.500

276.500

270.500

268.300

267.700

265.000

273.200

281.200

266.500

266.300

270.400

271.400

280.800

281.400

278.400

286.300

293.200

280.200

287.900

297.300

294.500
Flue Gas Oxygen Content (%) Flue Gas Carbon Dioxide Content (%) Flue Gas Moisture Content (%)

12.718

13.064

13.030

12.840

13.377

13.295

12.296

13.201

13.183

12.521

13.134

13.022

13.387

13.003

13.388

13.349

12.831

13.299

13.321

13.106

13.347

13.195

12.835

13.161

13.161

12.226

13.048

13.287

11.635

11.630
EIA Facility Code Facility Name Boiler ID

6257 Scherer 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

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