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

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

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

Day 2 12/17/2009 869.869 1,000 lb/hr

Day 3 12/18/2009 967.474 1,000 lb/hr

Day 4 12/19/2009 877.407 1,000 lb/hr

Day 5 12/20/2009 925.380 1,000 lb/hr

Day 6 12/21/2009 861.837 1,000 lb/hr

Day 7 12/22/2009 913.197 1,000 lb/hr

Day 8 12/23/2009 871.735 1,000 lb/hr

Day 9 12/24/2009 959.467 1,000 lb/hr

Day 10 12/25/2009 843.726 1,000 lb/hr

Day 11 12/26/2009 974.305 1,000 lb/hr

Day 12 12/27/2009 867.568 1,000 lb/hr

Day 13 12/28/2009 943.098 1,000 lb/hr

Day 14 12/29/2009 871.525 1,000 lb/hr

Day 15 12/30/2009 988.711 1,000 lb/hr

Day 16 12/31/2009 872.891 1,000 lb/hr

Day 17 1/1/2010 909.009 1,000 lb/hr

Day 18 1/2/2010 859.184 1,000 lb/hr

Day 19 1/3/2010 960.671 1,000 lb/hr

Day 20 1/4/2010 912.277 1,000 lb/hr

Day 21 1/5/2010 976.739 1,000 lb/hr

Day 22 1/6/2010 865.182 1,000 lb/hr

Day 23 1/7/2010 957.311 1,000 lb/hr

Day 24 1/8/2010 867.442 1,000 lb/hr

Day 25 1/9/2010 978.706 1,000 lb/hr

Day 26 1/10/2010 882.026 1,000 lb/hr

Day 27 1/11/2010 945.915 1,000 lb/hr

Day 28 1/12/2010 857.239 1,000 lb/hr

Day 29 1/13/2010 941.403 1,000 lb/hr

Day 30 1/14/2010 864.682 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)

8,455.703 5,614.487

7,633.126 5,000.298

8,653.170 5,572.209

7,693.587 5,021.334

8,189.431 5,382.211

7,686.196 5,043.863

4,142.275 5,461.496

8,640.272 5,075.205

8,439.320 5,560.193

7,533.681 4,900.600

8,579.651 5,619.028

7,680.662 5,020.609

8,456.215 5,556.816

7,754.996 5,039.644

8,540.496 5,607.428

7,649.636 4,980.477

8,160.985 5,347.346

7,786.767 4,995.635

8,628.766 5,619.732

8,176.921 5,307.734

8,739.236 5,726.220

7,946.526 5,133.620

9,010.935 5,595.350

8,126.189 5,190.260

8,832.916 5,685.836

8,116.182 5,169.685

8,888.169 5,633.687

8,016.701 5,048.662

8,493.227 5,623.841

8,375.559 5,068.023
Unit Net Electric Generation (MWh) Unit Gross Electric Generation (MWe)

837.068 879.530

749.429 789.828

831.502 874.172

753.021 793.541

805.526 847.248

753.759 794.404

815.087 857.197

760.208 799.869

831.037 873.402

734.689 774.953

836.687 879.439

750.668 790.387

830.524 872.457

753.846 792.960

835.425 877.165

744.970 784.501

801.872 843.042

748.430 787.911

837.276 880.002

792.056 832.851

852.422 895.044

767.283 807.266

833.574 875.710

773.886 814.614

846.147 888.693

771.411 811.474

837.854 879.949

754.749 794.128

837.050 878.815

757.268 797.249
Control Device Operating Parameters, As Appicable

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

1,903,267.381

1,760,015.915

1,902,318.857

1,762,065.114

1,837,878.485

1,757,908.719

1,106,667.500

1,903,128.000

1,892,937.026

1,729,885.121

1,904,503.885

1,758,790.895

1,870,533.156

1,766,217.386

1,909,032.395

1,772,203.716

1,825,535.649

1,752,023.526

1,895,472.821

1,837,100.153

1,939,430.126

1,792,561.885

1,915,488.395

1,810,624.756

1,952,734.070

1,802,326.863

1,916,408.835

1,762,234.913

1,926,040.000

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

PAC 203.197

PAC 195.425

PAC 200.777

PAC 195.880

PAC 198.523

PAC 191.591

PAC 212.028

PAC 192.906

PAC 195.382

PAC 186.543

PAC 196.070

PAC 209.782

PAC 194.567

PAC 190.222

PAC 196.205

PAC 188.857

PAC 186.967

PAC 189.537

PAC 196.854

PAC 193.479

PAC 202.488

PAC 181.061

PAC 163.469

PAC 164.140

PAC 164.012

PAC 164.188

PAC 153.067

PAC 169.238

PAC 150.959

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

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

295.600

298.400

282.800

284.800

279.500

282.600

281.900

295.100

285.600

295.200

287.800

285.600

282.300

288.600

277.300

289.400

277.700

286.800

268.400

278.100

269.300

275.400

267.800

284.600

274.000

272.000

263.700

276.900

272.600

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

13.328

13.011

13.646

13.099

13.368

13.117

11.229

13.620

13.375

13.065

13.515

13.101

13.562

13.172

13.421

12.949

13.411

13.333

13.657

13.353

13.518

13.299

14.113

13.464

13.570

13.510

13.914

13.648

13.229

13.039
EIA Facility Code Facility Name Boiler ID

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

Day 2 12/17/2009 869.869 1,000 lb/hr

Day 3 12/18/2009 967.474 1,000 lb/hr

Day 4 12/19/2009 877.407 1,000 lb/hr

Day 5 12/20/2009 925.380 1,000 lb/hr

Day 6 12/21/2009 861.837 1,000 lb/hr

Day 7 12/22/2009 913.197 1,000 lb/hr

Day 8 12/23/2009 871.735 1,000 lb/hr

Day 9 12/24/2009 959.467 1,000 lb/hr

Day 10 12/25/2009 843.726 1,000 lb/hr

Day 11 12/26/2009 974.305 1,000 lb/hr

Day 12 12/27/2009 867.568 1,000 lb/hr

Day 13 12/28/2009 943.098 1,000 lb/hr

Day 14 12/29/2009 871.525 1,000 lb/hr

Day 15 12/30/2009 988.711 1,000 lb/hr

Day 16 12/31/2009 872.891 1,000 lb/hr

Day 17 1/1/2010 909.009 1,000 lb/hr

Day 18 1/2/2010 859.184 1,000 lb/hr

Day 19 1/3/2010 960.671 1,000 lb/hr

Day 20 1/4/2010 912.277 1,000 lb/hr

Day 21 1/5/2010 976.739 1,000 lb/hr

Day 22 1/6/2010 865.182 1,000 lb/hr

Day 23 1/7/2010 957.311 1,000 lb/hr

Day 24 1/8/2010 867.442 1,000 lb/hr

Day 25 1/9/2010 978.706 1,000 lb/hr

Day 26 1/10/2010 882.026 1,000 lb/hr

Day 27 1/11/2010 945.915 1,000 lb/hr

Day 28 1/12/2010 857.239 1,000 lb/hr

Day 29 1/13/2010 941.403 1,000 lb/hr

Day 30 1/14/2010 864.682 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)

8,455.703 5,614.487

7,633.126 5,000.298

8,653.170 5,572.209

7,693.587 5,021.334

8,189.431 5,382.211

7,686.196 5,043.863

4,142.275 5,461.496

8,640.272 5,075.205

8,439.320 5,560.193

7,533.681 4,900.600

8,579.651 5,619.028

7,680.662 5,020.609

8,456.215 5,556.816

7,754.996 5,039.644

8,540.496 5,607.428

7,649.636 4,980.477

8,160.985 5,347.346

7,786.767 4,995.635

8,628.766 5,619.732

8,176.921 5,307.734

8,739.236 5,726.220

7,946.526 5,133.620

9,010.935 5,595.350

8,126.189 5,190.260

8,832.916 5,685.836

8,116.182 5,169.685

8,888.169 5,633.687

8,016.701 5,048.662

8,493.227 5,623.841

8,375.559 5,068.023
Unit Net Electric Generation (MWh) Unit Gross Electric Generation (MWe)

837.068 879.530

749.429 789.828

831.502 874.172

753.021 793.541

805.526 847.248

753.759 794.404

815.087 857.197

760.208 799.869

831.037 873.402

734.689 774.953

836.687 879.439

750.668 790.387

830.524 872.457

753.846 792.960

835.425 877.165

744.970 784.501

801.872 843.042

748.430 787.911

837.276 880.002

792.056 832.851

852.422 895.044

767.283 807.266

833.574 875.710

773.886 814.614

846.147 888.693

771.411 811.474

837.854 879.949

754.749 794.128

837.050 878.815

757.268 797.249
Control Device Operating Parameters, As Appicable

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

1,903,267.381

1,760,015.915

1,902,318.857

1,762,065.114

1,837,878.485

1,757,908.719

1,106,667.500

1,903,128.000

1,892,937.026

1,729,885.121

1,904,503.885

1,758,790.895

1,870,533.156

1,766,217.386

1,909,032.395

1,772,203.716

1,825,535.649

1,752,023.526

1,895,472.821

1,837,100.153

1,939,430.126

1,792,561.885

1,915,488.395

1,810,624.756

1,952,734.070

1,802,326.863

1,916,408.835

1,762,234.913

1,926,040.000

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

PAC 203.197

PAC 195.425

PAC 200.777

PAC 195.880

PAC 198.523

PAC 191.591

PAC 212.028

PAC 192.906

PAC 195.382

PAC 186.543

PAC 196.070

PAC 209.782

PAC 194.567

PAC 190.222

PAC 196.205

PAC 188.857

PAC 186.967

PAC 189.537

PAC 196.854

PAC 193.479

PAC 202.488

PAC 181.061

PAC 163.469

PAC 164.140

PAC 164.012

PAC 164.188

PAC 153.067

PAC 169.238

PAC 150.959

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

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

295.600

298.400

282.800

284.800

279.500

282.600

281.900

295.100

285.600

295.200

287.800

285.600

282.300

288.600

277.300

289.400

277.700

286.800

268.400

278.100

269.300

275.400

267.800

284.600

274.000

272.000

263.700

276.900

272.600

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

13.328

13.011

13.646

13.099

13.368

13.117

11.229

13.620

13.375

13.065

13.515

13.101

13.562

13.172

13.421

12.949

13.411

13.333

13.657

13.353

13.518

13.299

14.113

13.464

13.570

13.510

13.914

13.648

13.229

13.039
EIA Facility Code Facility Name Boiler ID

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