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

to store these daily averages. This spreadsheet included 4 separate surrogate worksheets, in case the boiler test

at 4 different dates. This spreadsheet is intended to be used for one boiler of one facility. Data for multiple bo

using separate copies of this spreadsheet. Fields shaded in yellow are required (if applicable to your boilers' op

to populate cells shaded in gray, as they are automatically populated from the Boiler Information worksheet. 

structure of this spreadsheet by adding or subtracting rows, columns, cells. Please name each resulting spread

naming 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

s data required by the ICR. The ERT does not have the capability 

e worksheets, in case the boiler tested is tested for all surrogates 

of one facility. Data for multiple boilers should be handled by 

ired (if applicable to your boilers' operation). You do not need 

e Boiler Information worksheet. Please Do Not modify the 

Please name each resulting spreadsheet with the following 

8100_Unit_2_Processdata.xls).

on the Boiler Information worksheet. 

taneous testing of different HAP surrogates was done. 

EIA Facility Code Facility Name Boiler ID

2408 Mercer Generating Station 2
EIA Facility Code Facility Name Boiler ID Unit was not tested for this Group

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 Unit was not tested for this Group

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 Unit was not tested for this Group

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

2408 Mercer Generating Station 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/24/2010 0.0 tons/hr NA

Day 2 1/25/2010 0.0 tons/hr NA

Day 3 1/26/2010 54.7 tons/hr NA

Day 4 1/27/2010 64.1 tons/hr NA

Day 5 1/28/2010 84.8 tons/hr NA

Day 6 1/29/2010 93.8 tons/hr NA

Day 7 1/30/2010 100.7 tons/hr NA

Day 8 1/31/2010 100.7 tons/hr NA

Day 9 2/1/2010 104.6 tons/hr NA

Day 10 2/2/2010 97.1 tons/hr NA

Day 11 2/3/2010 80.2 tons/hr NA

Day 12 2/4/2010 90.1 tons/hr NA

Day 13 2/5/2010 88.6 tons/hr NA

Day 14 2/6/2010 87.4 tons/hr NA

Day 15 2/7/2010 95.4 tons/hr NA

Day 16 2/8/2010 99.2 tons/hr NA

Day 17 2/9/2010 101.1 tons/hr NA

Day 18 2/10/2010 91.0 tons/hr NA

Day 19 2/11/2010 91.1 tons/hr NA

Day 20 2/12/2010 94.4 tons/hr NA

Day 21 2/13/2010 99.1 tons/hr NA

Day 22 2/14/2010 94.5 tons/hr NA

Day 23 2/15/2010 97.3 tons/hr NA

Day 24 2/16/2010 93.5 tons/hr NA

Day 25 2/17/2010 92.0 tons/hr NA

Day 26 2/18/2010 87.7 tons/hr NA

Day 27 2/19/2010 91.2 tons/hr NA

Day 28 2/20/2010 79.7 tons/hr NA

Day 29 2/21/2010 53.1 tons/hr NA

Day 30 2/22/2010 79.5 tons/hr NA
he Testing Date

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

NA NA NA NA

NA NA NA NA

NA NA NA NA

NA NA NA NA

NA NA NA NA

NA NA NA NA

NA NA NA NA

NA NA NA NA

NA NA NA NA

NA NA NA NA

NA NA NA NA

NA NA NA NA

NA NA NA NA

NA NA NA NA

NA NA NA NA

NA NA NA NA

NA NA NA NA

NA NA NA NA

NA NA NA NA

NA NA NA NA

NA NA NA NA

NA NA NA NA

NA NA NA NA

NA NA NA NA

NA NA NA NA

NA NA NA NA

NA NA NA NA

NA NA NA NA

NA NA NA NA

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

NA NA NA

NA NA NA

NA NA NA

NA NA NA

NA NA NA

NA NA NA

NA NA NA

NA NA NA

NA NA NA

NA NA NA

NA NA NA

NA NA NA

NA NA NA

NA NA NA

NA NA NA

NA NA NA

NA NA NA

NA NA NA

NA NA NA

NA NA NA

NA NA NA

NA NA NA

NA NA NA

NA NA NA

NA NA NA

NA NA NA

NA NA NA

NA NA NA

NA NA NA

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

0 NA

0 NA

1422.5 NA

1665.4 NA

2205.0 NA

2440.1 NA

2618.3 NA

2619.0 NA

2718.4 NA

2525.2 NA

2084.6 NA

2341.3 NA

2303.0 NA

2273.5 NA

2479.8 NA

2579.0 NA

2627.9 NA

2365.5 NA

2368.8 NA

2455.4 NA

2575.4 NA

2456.5 NA

2530.6 NA

2431.8 NA

2391.4 NA

2279.3 NA

2372.0 NA

2071.7 NA

1380.3 NA

2067.9 NA
Unit Net Electric Generation (MWh) Unit Gross Electric Generation (MWe)

0 0

0 0

77.1 84.5

129.8 142.1

200.2 215.3

247.6 264.9

267.0 285.1

267.6 285.9

273.7 292.4

254.1 271.0

192.4 207.7

221.8 237.8

216.3 232.5

204.1 220.1

230.4 247.0

261.8 279.8

266.3 284.5

234.4 251.5

232.1 248.5

237.9 254.6

258.6 276.4

238.5 255.3

249.7 267.6

237.1 255.0

230.3 247.4

214.9 231.3

221.8 238.0

183.1 198.2

98.0 110.3

185.8 201.0
Control Device Operating Parameters, As Appicable

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

0 NA

0 NA

506341.7 NA

522858.3 NA

604729.2 NA

653716.7 NA

669804.2 NA

668229.2 NA

675850.0 NA

647183.3 NA

574329.2 NA

602695.8 NA

616166.7 NA

610104.2 NA

642462.5 NA

679237.5 NA

681641.7 NA

640441.7 NA

639062.5 NA

645179.2 NA

668525.0 NA

644000.0 NA

673766.7 NA

661762.5 NA

644537.5 NA

626470.8 NA

628112.5 NA

590383.3 NA

485995.8 NA

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

NA Activated Carbon 0

NA Activated Carbon 0

NA Activated Carbon 29.4

NA Activated Carbon 98.9

NA Activated Carbon 102.5

NA Activated Carbon 168.1

NA Activated Carbon 187.5

NA Activated Carbon 197.5

NA Activated Carbon 222.7

NA Activated Carbon 376.8

NA Activated Carbon 253.2

NA Activated Carbon 222.1

NA Activated Carbon 175.0

NA Activated Carbon 163.0

NA Activated Carbon 179.6

NA Activated Carbon 260.6

NA Activated Carbon 358.5

NA Activated Carbon 212.2

NA Activated Carbon 155.4

NA Activated Carbon 214.7

NA Activated Carbon 307.3

NA Activated Carbon 280.1

NA Activated Carbon 279.4

NA Activated Carbon 273.4

NA Activated Carbon 252.1

NA Activated Carbon 230.4

NA Activated Carbon 245.8

NA Activated Carbon 231.1

NA Activated Carbon 128.6

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

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

NA 0

NA 0

NA 235.6

NA 287.9

NA 294.9

NA 295.6

NA 298.6

NA 301.5

NA 304.1

NA 303.6

NA 294.1

NA 301.7

NA 301.6

NA 296.0

NA 299.6

NA 306.0

NA 307.2

NA 301.2

NA 300.5

NA 301.0

NA 305.3

NA 303.4

NA 307.9

NA 307.1

NA 305.1

NA 304.1

NA 303.9

NA 298.0

NA 288.6

NA 298.3
Flue Gas Oxygen Content (%) Flue Gas Carbon Dioxide Content (%) Flue Gas Moisture Content (%)

0 0 0

0 0 0

14.1 5.3 2.1

10.0 9.5 2.7

8.2 11.0 3.4

7.8 11.3 3.9

7.3 11.8 2.5

7.2 11.8 2.7

7.1 11.9 0.7

7.5 11.4 1.9

8.7 10.3 1.5

7.6 11.6 1.1

7.9 11.2 3.0

8.2 10.5 1.7

7.5 10.6 2.7

7.1 11.1 5.4

7.3 12.1 3.1

7.9 10.9 3.7

7.6 11.4 5.4

7.4 11.9 3.5

7.3 11.7 3.5

7.4 11.7 3.4

7.6 11.5 3.7

8.0 11.1 3.8

7.8 11.2 3.7

8.2 11.0 3.2

7.6 11.7 3.3

8.8 10.7 2.5

10.9 8.4 3.3

8.6 10.7 4.6