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

864 Meredosia 5
EIA Facility Code Facility Name Boiler ID

864 Meredosia 5

Daily Average Process Data for a 30 Day Period Including the Testing Date

Date 

(MM/DD/YY) Coal Firing Rate (1,000 Tons/hr)

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
 for a 30 Day Period Including the Testing Date

Synfuel Firing Rate (1,000 Tons/hr) Pet Coke Firing Rate (1,000 Tons/hr)
Coal Gas Firing Rate (ft^3/min) Fuel oil Firing Rate (Gal/hr) Average Heat Input (MMBtu/hr)
Steam Output (1,000 lbs steam/hr) Flue Gas Flow Rate (dscfm) Flue Gas Pressure (atm)
Flue Gas Sampling Point Temperature (Deg F) Flue Gas Oxygen Content (%)
Flue Gas Carbon Dioxide Content (%) Flue Gas Moisture Content (%)
Unit Net Electric Generation (MWh) Unit Gross Electric Generation (MWe) Standard Pressure (atm)
Standard Temperature (Deg F) Pressure Drop across FGD (in H2O)
FGD Scrubber Liquor Flow Rate (gals/min) FGD Scrubber Liquor pH (pH) Sorbent Type
Sorbent Injection Rate (lb/hr)
EIA Facility Code Facility Name Boiler ID

864 Meredosia 5

Daily Average Process Data for a 30 Day Period Including the Testing Date

Date 

(MM/DD/YYYY) Coal Firing Rate (1,000 Tons/hr)

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
a for a 30 Day Period Including the Testing Date

Synfuel Firing Rate (1,000 Tons/hr) Pet Coke Firing Rate (1,000 Tons/hr)
Coal Gas Firing Rate (ft^3/min) Fuel oil Firing Rate (Gal/hr) Average Heat Input (MMBtu/hr)
Steam Output (1,000 lbs steam/hr) Flue Gas Flow Rate (dscfm) Flue Gas Pressure (atm)
Flue Gas Sampling Point Temperature (Deg F) Flue Gas Oxygen Content (%)
Flue Gas Carbon Dioxide Content (%) Flue Gas Moisture Content (%)
Unit Net Electric Generation (MWh) Unit Gross Electric Generation (MWe) Standard Pressure (atm)
Standard Temperature (Deg F) Pressure Drop across FGD (in H2O)
FGD Scrubber Liquor Flow Rate (gals/min) FGD Scrubber Liquor pH (pH) Sorbent Type
Sorbent Injection Rate (lb/hr)
EIA Facility Code Facility Name Boiler ID

864 Meredosia 5

Daily Average Process Data for a 30 Day Period Including the Testing Date

Date 

(MM/DD/YYYY) Coal Firing Rate (1,000 Tons/hr)

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
a for a 30 Day Period Including the Testing Date

Synfuel Firing Rate (1,000 Tons/hr) Pet Coke Firing Rate (1,000 Tons/hr)
Coal Gas Firing Rate (ft^3/min) Fuel oil Firing Rate (Gal/hr) Average Heat Input (MMBtu/hr)
Steam Output (1,000 lbs steam/hr) Flue Gas Flow Rate (dscfm) Flue Gas Pressure (atm)
Flue Gas Sampling Point Temperature (Deg F) Flue Gas Oxygen Content (%)
Flue Gas Carbon Dioxide Content (%) Flue Gas Moisture Content (%)
Unit Net Electric Generation (MWh) Unit Gross Electric Generation (MWe) Standard Pressure (atm)
Standard Temperature (Deg F) Pressure Drop across FGD (in H2O)
FGD Scrubber Liquor Flow Rate (gals/min) FGD Scrubber Liquor pH (pH) Sorbent Type
Sorbent Injection Rate (lb/hr)
EIA Facility Code Facility Name Boiler ID

864 Meredosia 5

Daily Average Process Data for a 30 Day Period Including the Testing Date

Date 

(MM/DD/YYYY) Coal Firing Rate (1,000 Tons/hr)

03/01/2010 Day 1 0.108262315

03/02/2010 Day 2 0.117323587

03/03/2010 Day 3 0.120026396

03/04/2010 Day 4 0.100486221

03/05/2010 Day 5 0.090474994

03/06/2010 Day 6 0.065482331

03/07/2010 Day 7 0.064389433

03/08/2010 Day 8 0.077488248

03/09/2010 Day 9 0.088211247

03/10/2010 Day 10 0.085869594

03/11/2010 Day 11 0.084896758

03/12/2010 Day 12 0.087062875

03/13/2010 Day 13 0.071367796

03/14/2010 Day 14 0.059581547

03/15/2010 Day 15 0.081006928

03/16/2010 Day 16 0.076398665

03/17/2010 Day 17 0.033878016

03/18/2010 Day 18 0.061005906

03/19/2010 Day 19 0.062664143

03/20/2010 Day 20 0.084910339

03/21/2010 Day 21 0.064213182

03/22/2010 Day 22 0.074694277

03/23/2010 Day 23 0.086044462

03/24/2010 Day 24 0.081330007

03/25/2010 Day 25 0.080773761

03/26/2010 Day 26 0.082360785

03/27/2010 Day 27 0.056915858

03/28/2010 Day 28 0.057247029

03/29/2010 Day 29 0.079344179

03/30/2010 Day 30 0.087501292
a for a 30 Day Period Including the Testing Date

Synfuel Firing Rate (1,000 Tons/hr) Pet Coke Firing Rate (1,000 Tons/hr)
Coal Gas Firing Rate (ft^3/min) Fuel oil Firing Rate (Gal/hr) Average Heat Input (MMBtu/hr)

1889.826906

2048.000512

2095.180777

1754.087473

1579.331372

1143.059499

1123.98182

1352.634914

1539.815594

1498.939637

1481.957911

1519.76965

1245.796236

1040.055481

1414.056867

1333.615041

591.374698

1064.91915

1093.865299

1482.194904

1120.905378

1303.863321

1501.992159

1419.696616

1409.986792

1437.689858

993.5231953

999.3041094

1385.032061

1527.422545
Steam Output (1,000 lbs steam/hr) Flue Gas Flow Rate (dscfm) Flue Gas Pressure (atm)

1341.619541 728742.238

1453.164721 787671.646

1496.127867 810381.499

1233.844158 645233.2552

1108.610169 569202.9331

790.7910759 454145.362

772.7846222 447973.7844

927.8546044 512028.2171

1075.862226 585905.5619

1053.456628 580573.8761

1039.521755 557387.8736

1065.0582 568713.6574

861.052125 483685.8997

711.6542315 408621.2083

983.1703974 541236.6373

930.3808049 505101.0861

405.7765476 417446.5907

738.6719808 388504.503

750.7369446 460962.0589

1030.71341 546655.6898

771.3148734 412524.4183

905.4400282 493756.349

1051.85729 582607.411

987.822833 578365.0154

974.7236039 559302.2935

998.5190931 559269.9959

681.7461042 402542.064

676.2432346 424336.3547

959.7013227 549294.2607

1078.590569 586600.3329
Flue Gas Sampling Point Temperature (Deg F) Flue Gas Oxygen Content (%)

279.1633589

286.1397889

284.7828893

277.1808841

277.9662332

274.4412319

273.2390091

282.2122713

286.3492864

286.6443039

282.9725114

277.3350046

280.385756

276.5560851

290.8992046

284.8774833

132.6825346

232.2252308

272.0663756

281.8052832

272.9306805

272.6129673

291.5596396

288.0722997

276.6318468

287.5691479

271.9617279

273.6135063

282.099895

284.0761369
Flue Gas Carbon Dioxide Content (%) Flue Gas Moisture Content (%)
Unit Net Electric Generation (MWh) Unit Gross Electric Generation (MWe) Standard Pressure (atm)

183.6412917 195.3780659 1

200.1345269 212.653803 1

205.0276148 217.9383927 1

170.4184184 181.5724458 1

151.9411719 162.2686072 1

104.9307174 113.1314284 1

103.0972453 111.2456328 1

128.1328833 137.3721368 1

148.054538 158.1914736 1

143.2601711 153.2187029 1

141.6433887 151.5396518 1

144.8309508 154.8959681 1

116.189427 124.7885309 1

94.5938807 102.2173541 1

134.4689736 143.9957625 1

125.1088436 134.1689878 1

-68.70120618 40.78859496 1

42.09483337 91.55267319 1

100.665534 108.945433 1

141.9495241 152.0314089 1

103.3556321 111.6910901 1

123.2043527 132.4774568 1

143.6663597 153.9084948 1

134.731245 144.6028153 1

133.6462755 143.6258112 1

139.0261629 149.1395375 1

89.24757369 97.10928374 1

90.16092126 97.98931359 1

131.1348747 140.8411328 1

145.5376499 155.9422252 1
Standard Temperature (Deg F) Pressure Drop across FGD (in H2O)

68

68

68

68

68

68

68

68

68

68

68

68

68

68

68

68

68

68

68

68

68

68

68

68

68

68

68

68

68

68
FGD Scrubber Liquor Flow Rate (gals/min) FGD Scrubber Liquor pH (pH) Sorbent Type

ACI

ACI

ACI

ACI

ACI

ACI

ACI

ACI

ACI

ACI

ACI

ACI

ACI

ACI

ACI

ACI

ACI

ACI

ACI

ACI

ACI

ACI

ACI

ACI

ACI

ACI

ACI

ACI

ACI

ACI
Sorbent Injection Rate (lb/hr)

2222.944222

2407.717122

2482.963024

1979.16564

1738.040065

1379.879369

1358.401099

1564.871361

1788.695361

1773.398292

1705.718518

1734.34741

1482.389448

1251.684919

1650.269896

1542.897771

50.10096618

815.3331361

1407.841803

1665.398608

1253.76745

1514.52412

1774.058721

1770.783149

1727.389157

1691.574377

1227.772154

1295.273674

1678.454272

1792.55818