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

127 Oklaunion OKL-1
EIA Facility Code Facility Name Boiler ID Field1 Field2

127 Oklaunion OKL-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
Field3 Field4 Field5 Field6

he Testing Date

Synfuel Firing Rate (units) Pet Coke Firing Rate Pet Coke Firing Rate (units) Coal Gas Firing Rate
Field7 Field8 Field9

Coal Gas Firing Rate (units) Fuel oil Firing Rate Fuel oil Firing Rate (units)
Field10 Field11

Average Heat Input (MMBtu/hr) Steam Output (1,000 lbs steam/hr)
Field12 Field13

Unit Net Electric Generation (MWh) Unit Gross Electric Generation (MWe)
Field14 Field15

Control Device Operating Parameters, As Appicable

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

FGD Scrubber Liquor Flow Rate (gals/min) Sorbent Type Sorbent Injection Rate (lb/hr)
Field19 Field20

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

Flue Gas Pressure (atm) Flue Gas Sampling Point Temperature (Deg F)
Field21 Field22 Field23

Flue Gas Oxygen Content (%) Flue Gas Carbon Dioxide Content (%) Flue Gas Moisture Content (%)
EIA Facility Code Facility Name Boiler ID Field1 Field2

127 Oklaunion OKL-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
Field3 Field4 Field5 Field6

he Testing Date

Synfuel Firing Rate (units) Pet Coke Firing Rate Pet Coke Firing Rate (units) Coal Gas Firing Rate
Field7 Field8 Field9

Coal Gas Firing Rate (units) Fuel oil Firing Rate Fuel oil Firing Rate (units)
Field10 Field11

Average Heat Input (MMBtu/hr) Steam Output (1,000 lbs steam/hr)
Field12 Field13

Unit Net Electric Generation (MWh) Unit Gross Electric Generation (MWe)
Field14 Field15

Control Device Operating Parameters, As Appicable

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

FGD Scrubber Liquor Flow Rate (gals/min) Sorbent Type Sorbent Injection Rate (lb/hr)
Field19 Field20

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

Flue Gas Pressure (atm) Flue Gas Sampling Point Temperature (Deg F)
Field21 Field22 Field23

Flue Gas Oxygen Content (%) Flue Gas Carbon Dioxide Content (%) Flue Gas Moisture Content (%)
EIA Facility Code Facility Name Boiler ID Field1 Field2

127 Oklaunion OKL-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 3/1/2010 259.5569097 tons/hr

Day 2 3/2/2010 376.5553819 tons/hr

Day 3 3/3/2010 356.1753472 tons/hr

Day 4 3/4/2010 171.9570139 tons/hr

Day 5 3/5/2010 155.8413542 tons/hr

Day 6 3/6/2010 335.1132292 tons/hr

Day 7 3/7/2010 296.0570833 tons/hr

Day 8 3/8/2010 138.3080208 tons/hr

Day 9 3/9/2010 223.0082292 tons/hr

Day 10 3/10/2010 205.945625 tons/hr

Day 11 3/11/2010 337.9848264 tons/hr

Day 12 3/12/2010 290.7257292 tons/hr

Day 13 3/13/2010 339.7721875 tons/hr

Day 14 3/14/2010 267.7825 tons/hr

Day 15 3/15/2010 236.5718403 tons/hr

Day 16 3/16/2010 332.6960764 tons/hr

Day 17 3/17/2010 362.3703125 tons/hr

Day 18 3/18/2010 326.129375 tons/hr

Day 19 3/19/2010 144.8179514 tons/hr

Day 20 3/20/2010 254.1441667 tons/hr

Day 21 3/21/2010 368.5708333 tons/hr

Day 22 3/22/2010 303.6863889 tons/hr

Day 23 3/23/2010 130.0224306 tons/hr

Day 24 3/24/2010 302.9074306 tons/hr

Day 25 3/25/2010 309.400625 tons/hr

Day 26 3/26/2010 184.8126389 tons/hr

Day 27 3/27/2010 175.8647569 tons/hr

Day 28 3/28/2010 274.0970486 tons/hr

Day 29 3/29/2010 294.5483681 tons/hr

Day 30 3/30/2010 219.0239583 tons/hr
Field3 Field4 Field5 Field6

he Testing Date

Synfuel Firing Rate (units) Pet Coke Firing Rate Pet Coke Firing Rate (units) Coal Gas Firing Rate
Field7 Field8 Field9

Coal Gas Firing Rate (units) Fuel oil Firing Rate Fuel oil Firing Rate (units)
Field10 Field11

Average Heat Input (MMBtu/hr) Steam Output (1,000 lbs steam/hr)
Field12 Field13

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

421.7725647 454.0738807

637.3136745 675.5269027

613.0574433 650.3044036

261.4509411 290.1894755

228.1368935 255.9301017

546.9428457 582.7570835

484.8164801 519.1530972

192.6595851 219.4695374

350.2860816 380.5040831

318.0043067 347.9390054

561.2723685 596.5116141

472.9239665 506.2984073

571.3311269 607.7956117

438.670924 471.8713552

379.4229555 410.6113123

550.0298298 585.4609068

604.4271533 642.3301014

556.5683003 592.1179643

208.11358 235.2490998

397.6792466 429.4953289

622.9349041 659.7558178

510.1107959 544.4308694

179.4441602 206.7652019

503.0653823 536.6507587

513.7425226 548.5433997

292.5009945 321.4246798

272.0175581 300.4988735

458.1946938 491.5264904

499.8553429 533.0553135

356.5831834 387.1290927
Field14 Field15

Control Device Operating Parameters, As Appicable

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

FGD Scrubber Liquor Flow Rate (gals/min) Sorbent Type Sorbent Injection Rate (lb/hr)
Field19 Field20

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

Flue Gas Pressure (atm) Flue Gas Sampling Point Temperature (Deg F)
Field21 Field22 Field23

Flue Gas Oxygen Content (%) Flue Gas Carbon Dioxide Content (%) Flue Gas Moisture Content (%)
EIA Facility Code Facility Name Boiler ID Field1 Field2

127 Oklaunion OKL-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
Field3 Field4 Field5 Field6

he Testing Date

Synfuel Firing Rate (units) Pet Coke Firing Rate Pet Coke Firing Rate (units) Coal Gas Firing Rate
Field7 Field8 Field9

Coal Gas Firing Rate (units) Fuel oil Firing Rate Fuel oil Firing Rate (units)
Field10 Field11

Average Heat Input (MMBtu/hr) Steam Output (1,000 lbs steam/hr)
Field12 Field13

Unit Net Electric Generation (MWh) Unit Gross Electric Generation (MWe)
Field14 Field15

Control Device Operating Parameters, As Appicable

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

FGD Scrubber Liquor Flow Rate (gals/min) Sorbent Type Sorbent Injection Rate (lb/hr)
Field19 Field20

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

Flue Gas Pressure (atm) Flue Gas Sampling Point Temperature (Deg F)
Field21 Field22 Field23

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