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

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

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

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

Day 2 12/10/2009 1,028.462 1,000 lb/hr

Day 3 12/11/2009 1,024.927 1,000 lb/hr

Day 4 12/12/2009 1,002.868 1,000 lb/hr

Day 5 12/13/2009 924.467 1,000 lb/hr

Day 6 12/14/2009 1,007.751 1,000 lb/hr

Day 7 12/15/2009 1,035.240 1,000 lb/hr

Day 8 12/16/2009 974.717 1,000 lb/hr

Day 9 12/17/2009 1,004.777 1,000 lb/hr

Day 10 12/18/2009 1,008.073 1,000 lb/hr

Day 11 12/19/2009 989.904 1,000 lb/hr

Day 12 12/20/2009 879.342 1,000 lb/hr

Day 13 12/21/2009 944.287 1,000 lb/hr

Day 14 12/22/2009 965.238 1,000 lb/hr

Day 15 12/23/2009 1,003.311 1,000 lb/hr

Day 16 12/24/2009 927.715 1,000 lb/hr

Day 17 12/25/2009 931.782 1,000 lb/hr

Day 18 12/26/2009 975.357 1,000 lb/hr

Day 19 12/27/2009 909.924 1,000 lb/hr

Day 20 12/28/2009 996.133 1,000 lb/hr

Day 21 12/29/2009 1,019.971 1,000 lb/hr

Day 22 12/30/2009 1,047.846 1,000 lb/hr

Day 23 12/31/2009 978.614 1,000 lb/hr

Day 24 1/1/2010 854.310 1,000 lb/hr

Day 25 1/2/2010 966.945 1,000 lb/hr

Day 26 1/3/2010 1,010.806 1,000 lb/hr

Day 27 1/4/2010 1,019.430 1,000 lb/hr

Day 28 1/5/2010 1,025.419 1,000 lb/hr

Day 29 1/6/2010 1,043.221 1,000 lb/hr

Day 30 1/7/2010 1,023.932 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,522.299 5,612.513

8,808.735 5,760.925

8,833.104 5,790.834

8,766.636 5,750.540

7,849.512 5,122.683

8,582.198 5,623.057

8,791.768 5,738.263

8,479.203 5,602.226

8,672.876 5,745.793

8,783.047 5,748.247

8,502.322 5,584.026

7,578.835 4,967.778

8,137.757 5,367.208

8,630.473 5,669.694

8,628.382 5,787.344

8,037.478 5,264.405

8,127.172 5,324.061

8,392.703 5,470.133

7,929.946 5,113.573

8,811.522 5,746.915

8,872.620 5,796.012

8,798.211 5,828.994

8,418.897 5,458.319

7,435.436 4,884.480

8,463.980 5,543.397

8,881.159 5,809.725

8,882.986 5,820.044

8,779.153 5,826.634

8,725.458 5,831.866

8,767.224 5,832.188
Unit Net Electric Generation (MWh) Unit Gross Electric Generation (MWe)

819.357 860.072

841.138 883.120

843.790 885.900

835.377 877.494

747.435 786.800

822.134 863.516

836.029 877.999

822.491 862.594

837.401 877.772

837.699 878.415

814.573 855.059

729.041 766.516

793.057 832.404

828.905 868.893

842.379 882.601

772.646 811.264

779.335 818.774

801.499 841.534

758.471 798.071

840.366 881.803

841.341 882.264

844.386 885.125

798.134 838.307

716.649 753.948

808.965 848.425

843.737 884.710

841.756 883.379

843.088 885.346

841.745 884.215

841.867 884.285
Control Device Operating Parameters, As Appicable

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

1,773,959.309

1,819,348.032

1,817,107.441

1,799,837.398

1,689,437.496

1,810,006.460

1,840,007.358

1,763,603.734

1,795,098.169

1,797,596.627

1,782,832.405

1,631,040.536

1,695,491.281

1,778,218.351

1,784,115.774

1,699,340.991

1,712,833.280

1,739,088.111

1,670,961.964

1,800,295.959

1,806,185.318

1,802,253.773

1,751,178.171

1,601,188.067

1,743,479.223

1,806,318.409

1,818,999.176

1,831,764.327

1,842,574.593

1,830,967.464
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)

338.200

---

335.700

337.100

333.800

319.400

341.100

350.900

335.900

336.100

328.200

331.600

314.800

325.900

331.600

336.200

327.300

330.100

326.400

326.100

332.000

333.500

336.600

328.900

327.100

318.800

324.200

322.600

321.100

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

14.412

14.525

14.583

14.612

13.939

14.225

14.334

14.424

14.494

14.658

14.307

13.940

14.399

14.560

14.509

14.189

14.235

14.478

14.237

14.683

14.737

14.645

14.423

13.931

14.564

14.750

14.650

14.378

14.206

14.365
EIA Facility Code Facility Name Boiler ID

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