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

995 Bailly 8
EIA Facility Code Facility Name Boiler ID

995 Bailly 8

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

Date 

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

07/08/10 Day 1 240.4

07/09/10 Day 2 235.6

07/10/10 Day 3 238.1

07/11/10 Day 4 235.9

07/12/10 Day 5 234.4

07/13/10 Day 6 223.2

07/14/10 Day 7 217.1

07/15/10 Day 8 231.3

07/16/10 Day 9 233.0

07/17/10 Day 10 237.0

07/18/10 Day 11 237.6

07/19/10 Day 12 243.1

07/20/10 Day 13 241.4

07/21/10 Day 14 238.6

07/22/10 Day 15 238.4

07/23/10 Day 16 238.9

07/24/10 Day 17 244.7

07/25/10 Day 18 243.7

07/26/10 Day 19 242.5

07/27/10 Day 20 244.9

07/28/10 Day 21 246.3

07/29/10 Day 22 237.9

07/30/10 Day 23 206.7

07/31/10 Day 24 216.7

08/01/10 Day 25 226.7

08/02/10 Day 26 235.2

08/03/10 Day 27 240.3

08/04/10 Day 28 242.8

08/05/10 Day 29 243.2

08/06/10 Day 30 239.3
 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)

3454.9

3360.1

3382.1

3263.2

3275.5

3087.1

3142.8

3416.7

3449.8

3583.6

3548.1

3657.0

3531.8

3328.2

3411.6

3382.7

3426.5

3253.9

3415.7

3524.4

3583.3

3414.2

2962.2

3132.2

3348.7

3461.7

3494.1

3478.5

3506.6

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

61,488,767

55,576,121

54,859,471

53,747,634

54,223,864

51,726,504

52,390,434

57,364,160

56,491,238

59,492,565

58,666,896

58,889,677

56,080,592

51,894,917

53,265,817

53,147,708

55,746,314

56,017,644

54,983,250

56,937,220

58,521,513

55,573,480

49,358,581

52,145,781

55,567,378

56,674,489

57,219,035

57,989,503

57,623,119

57,125,976
Flue Gas Sampling Point Temperature (Deg F) Flue Gas Oxygen Content (%)

114.8

120.1

123.1

129.7

130.5

132.4

134.5

134.7

134.7

134.7

134.7

134.7

135.4

142.4

141.4

137.4

140.6

144.0

135.5

131.2

132.8

132.4

131.9

150.5

132.5

133.2

133.2

133.4

133.2

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

10.1

10.9

11.1

10.9

10.9

10.7

10.8

10.7

11.0

10.8

10.9

11.2

11.3

11.5

11.5

11.5

11.1

10.5

11.2

11.2

11.0

11.1

10.8

10.8

10.8

11.0

11.0

10.8

11.0

11.0
Unit Net Electric Generation (MWh) Unit Gross Electric Generation (MWe) Standard Pressure (atm)

317

310

314

303

310

295

290

308

315

318

316

321

319

313

319

311

315

316

319

320

326

316

279

287

307

316

319

317

316

316
Standard Temperature (Deg F) Pressure Drop across FGD (in H2O)

6.0

6.7

7.0

6.7

6.8

6.3

6.0

6.3

6.6

6.8

7.0

7.1

6.8

6.5

6.0

6.0

6.2

5.5

5.8

6.2

6.7

6.5

5.0

4.7

5.1

6.2

6.1

5.8

5.7

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

195,527 5.9

172,188 5.9

169,217 6.2

166,996 6.1

167,505 6.2

167,003 6.2

163,962 6.1

173,731 6.1

170,900 6.2

174,471 6.4

172,927 6.1

171,964 6.1

172,294 6.1

166,857 5.9

132,823 6.0

129,389 5.7

129,679 5.9

145,640 5.6

138,202 5.8

132,873 5.9

145,602 5.8

144,731 5.8

143,980 5.8

151,330 5.8

154,029 5.8

144,818 5.9

130,556 5.8

117,386 5.8

116,432 5.9

131,102 5.9
Sorbent Injection Rate (lb/hr)
EIA Facility Code Facility Name Boiler ID

995 Bailly 8

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

995 Bailly 8

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

995 Bailly 8

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