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

1554 Wagner 2
EIA Facility Code Facility Name Boiler ID

1554 Wagner 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 NA

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

1554 Wagner 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 NA

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

1554 Wagner 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 NA NA

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

NA NA NA NA
Coal Gas Firing Rate (units) Fuel oil Firing Rate Fuel oil Firing Rate (units)

NA
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

1554 Wagner 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 6/6/2010 980 mmBtu/hr NA

Day 2 6/7/2010 620 mmBtu/hr

Day 3 6/8/2010 8 mmBtu/hr

Day 4 6/9/2010 15 mmBtu/hr

Day 5 6/10/2010 825 mmBtu/hr

Day 6 6/11/2010 1220 mmBtu/hr

Day 7 6/12/2010 762 mmBtu/hr

Day 8 6/13/2010 993 mmBtu/hr

Day 9 6/14/2010 1141 mmBtu/hr

Day 10 6/15/2010 1196 mmBtu/hr

Day 11 6/16/2010 1227 mmBtu/hr

Day 12 6/17/2010 1165 mmBtu/hr

Day 13 6/18/2010 884 mmBtu/hr

Day 14 6/19/2010 1144 mmBtu/hr

Day 15 6/20/2010 1186 mmBtu/hr

Day 16 6/21/2010 1222 mmBtu/hr

Day 17 6/22/2010 1186 mmBtu/hr

Day 18 6/23/2010 1222 mmBtu/hr

Day 19 6/24/2010 1295 mmBtu/hr

Day 20 6/25/2010 1241 mmBtu/hr

Day 21 6/26/2010 1144 mmBtu/hr

Day 22 6/27/2010 1223 mmBtu/hr

Day 23 6/28/2010 1423 mmBtu/hr

Day 24 6/29/2010 1289 mmBtu/hr

Day 25 6/30/2010 811 mmBtu/hr

Day 26 7/1/2010 895 mmBtu/hr

Day 27 7/2/2010 766 mmBtu/hr

Day 28 7/3/2010 327 mmBtu/hr

Day 29 7/4/2010 561 mmBtu/hr

Day 30 7/5/2010 36 mmBtu/hr
ng the Testing Date

Synfuel Firing Rate (units) Pet Coke Firing Rate Pet Coke Firing Rate (units) Coal Gas Firing Rate

NA NA NA NA
Coal Gas Firing Rate (units) Fuel oil Firing Rate Fuel oil Firing Rate (units)

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

980 529

620 207

8 29

15 37

825 412

1220 727

762 339

993 481

1141 664

1196 709

1227 695

1165 695

884 405

1144 635

1186 720

1222 722

1186 695

1222 732

1295 795

1241 754

1144 651

1223 710

1423 925

1289 825

811 549

895 610

766 555

327 311

561 436

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

67 69

22 25

0 0

0 0

48 55

93 97

41 42

60 68

85 85

91 93

90 93

89 88

49 53

82 87

93 90

91 94

88 89

94 94

102 101

97 97

82 86

90 92

120 118

107 103

71 74

77 80

70 74

36 40

53 56

4 7
Control Device Operating Parameters, As Appicable

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

 371,767 NA

 314,227

127,147

131,006

335,516

396,603

332,213

361,193

383,087

390,639

397,117

390,693

340,038

375,870

384,360

383,193

380,669

393,125

405,191

399,173

377,806

391,339

422,114

403,723

269,066

281,322

237,788

116,525

180,498

214,805
FGD Scrubber Liquor Flow Rate (gals/min) Sorbent Type Sorbent Injection Rate (lb/hr)

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

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

1.0 33.3

1.0 33.3

1.0 33.3

1.0 33.3

1.0 33.3

1.0 33.3

1.0 33.3

1.0 33.3

1.0 33.3

1.0 33.3

1.0 33.3

1.0 33.3

1.0 33.3

1.0 33.3

1.0 33.3

1.0 33.3

1.0 33.3

1.0 33.3

1.0 33.3

1.0 33.3

1.0 33.3

1.0 33.3

1.0 33.3

1.0 33.3

1.0 33.3

1.0 33.3

1.0 33.3

1.0 33.3

1.0 33.3

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

10.3 8.2 6

12.7 6.1 6

19.4 0.2 6

19.3 0.3 6

11.4 7.2 6

8.7 9.6 6

11.5 7.2 6

10.0 8.5 6

9.2 9.2 6

8.8 9.5 6

8.5 9.8 6

9.1 9.3 6

10.5 8.1 6

8.9 9.4 6

8.8 9.6 6

8.4 9.9 6

8.7 9.7 6

8.7 9.6 6

8.3 10.0 6

8.6 9.7 6

9.0 9.3 6

8.6 9.7 6

7.5 10.7 6

8.2 10.0 6

9.4 9.0 6

9.3 9.1 6

9.2 9.2 6

11.1 7.6 6

10.5 8.0 6

17.1 2.2 6