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

0 0 0

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

0 0 0

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/25/2010 5552.35

Day 2 3/26/2010 6653.75

Day 3 3/27/2010 5668.4

Day 4 3/28/2010 5338.65

Day 5 3/29/2010 6678.3

Day 6 3/30/2010 5934.4 ton/day

Day 7 3/31/2010 4956.85 ton/day

Day 8 4/1/2010 5061.55 ton/day

Day 9 4/2/2010 156.2 ton/day

Day 10 4/4/2010 115.2 ton/day

Day 11 4/5/2010 4856.15 ton/day

Day 12 4/6/2010 6175.25 ton/day

Day 13 4/7/2010 5095.4 ton/day

Day 14 4/8/2010 3968.1 ton/day

Day 15 4/9/2010 1951.75 ton/day

Day 16 4/11/2010 3639.7 ton/day

Day 17 4/12/2010 6239.55 ton/day

Day 18 4/13/2010 6550.75 ton/day

Day 19 4/14/2010 6568.7 ton/day

Day 20 4/15/2010 6507.5 ton/day

Day 21 4/16/2010 5476.45 ton/day

Day 22 4/17/2010 4982.7 ton/day

Day 23 4/18/2010 6877.2 ton/day

Day 24 4/19/2010 6925.6 ton/day

Day 25 4/20/2010 6810.5 ton/day

Day 26 4/21/2010 6843.55 ton/day

Day 27 4/22/2010 6976.8 ton/day

Day 28 4/23/2010 5954.95 ton/day

Day 29 4/24/2010 5423.65 ton/day

Day 30 4/25/2010 4444.45 ton/day
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)

0 gallon/day

0 gallon/day

0 gallon/day

5467.92 gallon/day

0 gallon/day

0 gallon/day

0 gallon/day

3678.42 gallon/day

0 gallon/day

8748.67 gallon/day

4573.17 gallon/day

0 gallon/day

0 gallon/day

6660.92 gallon/day

3678.42 gallon/day

11432.92 gallon/day

0 gallon/day

0 gallon/day

0 gallon/day

932.04 gallon/day

0 gallon/day

7108.29 gallon/day

0 gallon/day

0 gallon/day

0 gallon/day

0 gallon/day

0 gallon/day

0 gallon/day

0 gallon/day

5219.38 gallon/day
Average Heat Input (MMBtu/hr) Steam Output (1,000 lbs steam/hr)

3462.4

4210.5

3631.4

3419.1

4321.7

3805.2

3290.3

3241.0

392.3

271.4

3233.6

3962.5

3196.7

2598.2

3288.6

2292.0

3986.4

4497.2

4374.1

4260.5

3609.5

3862.2

4912.3

4860.0

4622.5

4484.2

4076.2

3319.7

2952.3

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

9401

11080.6

9593.3

9250.9

11326.5

8209.4 9741.2

9993.7 8458.1

8764.9 8411.4

7941.2 105.9

10245.9 106

8855.7 8381.6

7451.3 10380.3

7504.1 8581.7

264.3 6694.5

61.1 2892.4

7101.6 6338.1

9402.9 10573.1

7516.5 11110.5

5793.6 11114.6

3006.4 10873.4

5263.6 8908

9552.9 8681.2

9910.5 11495.6

9948.7 11495

9747.2 11455.4

8186.5 11459.3

7436.9 11399.3

10348.5 9825

10312.2 8993.7

10328.3 7086.1

10321.5

10271.9

8865.7

8013.8

6127.8
Control Device Operating Parameters, As Appicable

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

1397493

1552270

1372414

1355762

1574634

1399525

1304789

1294532

719504

1314411

1473736

1293654

1147373

1294273

756533

1149573

1484860

1552651

1535548

1540812

1351467

1392373

1605810

1591417

1559558

1569364

1566248

1404967

1298617

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

Activated Carbon 6.0

Activated Carbon 6.7

Activated Carbon 5.9

Activated Carbon 5.9

Activated Carbon 6.9

Activated Carbon 6.1

Activated Carbon 5.7

Activated Carbon 5.6

Activated Carbon 3.0

Activated Carbon 5.6

Activated Carbon 6.5

Activated Carbon 5.6

Activated Carbon 4.8

Activated Carbon 5.6

Activated Carbon 2.4

Activated Carbon 4.7

Activated Carbon 6.4

Activated Carbon 6.7

Activated Carbon 6.6

Activated Carbon 6.7

Activated Carbon 5.8

Activated Carbon 5.9

Activated Carbon 7.0

Activated Carbon 6.9

Activated Carbon 6.8

Activated Carbon 6.9

Activated Carbon 6.9

Activated Carbon 6.1

Activated Carbon 4.3

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

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

297

313

305

300

321

310

297

298

281

146

285

315

298

277

309

251

312

314

315

315

298

292

315

316

316

315

315

306

28.925 309

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

8.2

9.4

9.2

8.5

9.5

9.3

8.2

8.1

2.1

7.8

9.3

8.2

7.3

8.3

5.9

9.3

10.0

9.9

9.6

9.0

9.0

10.6

10.6

10.3

9.9

9.0

8.0

7.8

6.7
EIA Facility Code Facility Name Boiler ID

0 0 0

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

0 0 0

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