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

703 Bowen 2
EIA Facility Code Facility Name Boiler ID

703 Bowen 2

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 1/25/2010 538.3868408 1,000 lbs/hr

Day 2 1/26/2010 540.7538452 1,000 lbs/hr

Day 3 1/27/2010 554.057373 1,000 lbs/hr

Day 4 1/28/2010 551.3671265 1,000 lbs/hr

Day 5 1/29/2010 550.2770386 1,000 lbs/hr

Day 6 1/30/2010 536.723877 1,000 lbs/hr

Day 7 1/31/2010 542.6216431 1,000 lbs/hr

Day 8 2/1/2010 521.5470581 1,000 lbs/hr

Day 9 2/2/2010 529.614502 1,000 lbs/hr

Day 10 2/3/2010 510.6359558 1,000 lbs/hr

Day 11 2/4/2010 531.2694702 1,000 lbs/hr

Day 12 2/5/2010 521.3933716 1,000 lbs/hr

Day 13 2/6/2010 537.2435303 1,000 lbs/hr

Day 14 2/7/2010 552.3765869 1,000 lbs/hr

Day 15 2/8/2010 546.973999 1,000 lbs/hr

Day 16 2/9/2010 551.6846924 1,000 lbs/hr

Day 17 2/10/2010 534.1885986 1,000 lbs/hr

Day 18 2/11/2010 538.9619751 1,000 lbs/hr

Day 19 2/12/2010 551.0586548 1,000 lbs/hr

Day 20 2/13/2010 539.8920288 1,000 lbs/hr

Day 21 2/14/2010 530.0450439 1,000 lbs/hr

Day 22 2/15/2010 542.2246094 1,000 lbs/hr

Day 23 2/16/2010 528.7555542 1,000 lbs/hr

Day 24 2/17/2010 530.8136597 1,000 lbs/hr

Day 25 2/18/2010 527.4956665 1,000 lbs/hr

Day 26 2/19/2010 529.5272827 1,000 lbs/hr

Day 27 2/20/2010 511.1208801 1,000 lbs/hr

Day 28 2/21/2010 517.2973633 1,000 lbs/hr

Day 29 2/22/2010 522.6780396 1,000 lbs/hr

Day 30 2/23/2010 556.0314331 1,000 lbs/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)

6,393.436 5206.924316

6,433.574 5199.560059

6,500.341 5206.415039

6,207.504 5191.451172

6,775.568 5172.037109

6,761.996 5150.943848

6,982.824 5193.662598

6,862.174 5186.633301

6,802.022 5214.804688

6,293.110 4770.101563

6,943.240 5271.868164

6,652.435 5244.066895

6,760.266 5211.592285

6,920.318 5199.921875

6,824.017 5180.163086

6,757.037 5195.864746

6,884.234 5185.350098

6,679.458 5163.842773

6,684.190 5229.796875

6,660.059 5161.202148

6,673.768 5169.693359

6,710.563 5173.776367

6,689.165 5141.862305

6,708.370 5168.884766

6,717.291 5166.90332

6,726.980 5189.178223

6,545.591 5180.084961

6,414.808 5166.234375

6,146.456 5166.186523

6,287.407 5340.498535
Unit Net Electric Generation (MWh) Unit Gross Electric Generation (MWe)

669.735 721.7941895

668.238 720.4581909

669.375 721.3701782

668.193 719.4946289

665.193 716.7970581

662.174 713.7185669

668.473 719.7846069

668.410 719.3071899

670.796 722.2839355

615.875 663.663208

677.641 729.4047852

674.889 726.8654785

670.105 722.2664185

668.495 720.1849976

667.102 718.4393311

668.012 719.8970947

666.796 718.5996094

664.914 715.8053589

673.143 724.5285034

663.984 715.0031738

665.981 716.7601318

665.806 717.0286255

661.917 712.9215088

664.689 716.6564941

663.600 716.232605

667.342 719.3184814

666.261 717.9343262

664.312 716.2015991

664.553 716.1505127

686.077 739.680603
Control Device Operating Parameters, As Appicable

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

1621754.592 16.597

1655918.292 17.105

1662943.717 17.201

1630028.5 16.326

1634946.658 16.422

1645811.35 16.832

1666512.358 16.942

1639161.192 16.120

1634246.642 16.223

1510462.767 15.924

1673721.808 16.327

1663228.775 16.490

1658859.083 17.193

1673371.8 17.128

1655994.067 16.391

1653771.333 16.565

1693343.925 18.107

1637934.358 17.271

1648625.85 16.887

1624933.533 17.306

1616450.342 16.370

1619448.867 17.273

1624027.842 17.848

1631803.8 17.287

1629840.867 16.549

1626243.358 15.947

1622205.633 15.638

1627838.242 15.220

1629992.417 15.285

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

Hydrated Lime 1,404.038

Hydrated Lime 1,404.066

Hydrated Lime 1,403.905

Hydrated Lime 1,403.868

Hydrated Lime 1,338.052

Hydrated Lime 1,186.713

Hydrated Lime 1,210.128

Hydrated Lime 1,243.684

Hydrated Lime 1,382.695

Hydrated Lime 1,400.275

Hydrated Lime 1,400.039

Hydrated Lime 1,391.682

Hydrated Lime 1,382.838

Hydrated Lime 1,403.030

Hydrated Lime 1,293.349

Hydrated Lime 1,399.982

Hydrated Lime 1,356.785

Hydrated Lime 1,399.938

Hydrated Lime 1,399.997

Hydrated Lime 1,400.052

Hydrated Lime 1,399.967

Hydrated Lime 1,400.190

Hydrated Lime 887.320

Hydrated Lime 602.578

Hydrated Lime 639.651

Hydrated Lime 705.453

Hydrated Lime 543.427

Hydrated Lime 629.762

Hydrated Lime 619.156

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

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

116.5

113.8

111.7

111.2

112.6

111.7

110.9

109.4

110.7

112.5

109.7

111.7

111.9

111

110.7

111.7

113.1

106.6

108.7

109.4

109.1

111.7

109.4

106.5

109.1

111.1

111.4

111.8

115.2

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

11.827

11.656

11.727

11.425

12.433

12.326

12.570

12.559

12.487

12.499

12.445

11.999

12.226

12.407

12.362

12.258

12.196

12.234

12.163

12.296

12.386

12.431

12.357

12.333

12.364

12.410

12.105

11.822

11.313

11.262
EIA Facility Code Facility Name Boiler ID

703 Bowen 2

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

703 Bowen 2

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

703 Bowen 2

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