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 c

boiler tested is tested for all surrogates at 4 different dates. This spreadsheet is intended to be used for one boile

facility. Data for multiple boilers should be handled by using separate copies of this spreadsheet.

are required (if applicable to your boilers' operation). You do not need to populate cells shaded in gray, as they a

automatically populated from the Boiler Information worksheet. Please Do Not modify the structure of this spre

adding or subtracting rows, columns, cells. Please name each resulting spreadsheet with the following naming c

[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 worksheet

Process Data Worksheets

Please use one process data worksheet for each HAP surrogate even is simultaneous testing of different HAP surr

done. 
data required by the ICR. The ERT does not 

separate surrogate worksheets, in case the 

 is intended to be used for one boiler of one 

s of this spreadsheet. Fields shaded in yellow 

ulate cells shaded in gray, as they are 

ot modify the structure of this spreadsheet by 

dsheet with the following naming convention: 

n the Boiler Information worksheet. 

aneous testing of different HAP surrogates was 
EIA Facility Code Facility Name Boiler ID

4041 South Oak Creek 7
EIA Facility Code Facility Name Boiler ID

4041 South Oak Creek 7

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

4041 South Oak Creek 7

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

4041 South Oak Creek 7

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

4041 South Oak Creek 7

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/25/2010 246.3202 1000 lb per hour

Day 2 6/26/2010 226.2539 1000 lb per hour

Day 3 6/27/2010 226.7167 1000 lb per hour

Day 4 6/28/2010 242.9453 1000 lb per hour

Day 5 6/29/2010 240.925 1000 lb per hour

Day 6 6/30/2010 247.5898 1000 lb per hour

Day 7 7/1/2010 250.1328 1000 lb per hour

Day 8 7/2/2010 245.1542 1000 lb per hour

Day 9 7/3/2010 232.539 1000 lb per hour

Day 10 7/4/2010 240.9804 1000 lb per hour

Day 11 7/5/2010 230.6322727 1000 lb per hour

Day 12 7/6/2010 217.1835 1000 lb per hour

Day 13 7/7/2010 199.6112 1000 lb per hour

Day 14 7/8/2010 204.3946 1000 lb per hour

Day 15 7/9/2010 205.4492 1000 lb per hour

Day 16 7/10/2010 211.9415 1000 lb per hour

Day 17 7/11/2010 194.6377273 1000 lb per hour

Day 18 7/12/2010 202.2501 1000 lb per hour

Day 19 7/13/2010 210.3008 1000 lb per hour

Day 20 7/14/2010 209.2655 1000 lb per hour

Day 21 7/15/2010 215.2423 1000 lb per hour

Day 22 7/16/2010 213.8202 1000 lb per hour

Day 23 7/17/2010 200.364 1000 lb per hour

Day 24 7/18/2010 212.8146 1000 lb per hour

Day 25 7/19/2010 201.1523 1000 lb per hour

Day 26 7/20/2010 202.8048 1000 lb per hour

Day 27 7/21/2010 209.9824 1000 lb per hour

Day 28 7/22/2010 203.2637 1000 lb per hour

Day 29 7/23/2010 216.1685455 1000 lb per hour

Day 30 7/24/2010 207.5637 1000 lb per hour
ng the 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)

2532.304167 1588.2291

2398.7 1476.3679

2292.766667 1451.4574

2475.108333 1556.1299

2591.479167 1537.596273

2564.6875 1597.4898

2563.041667 1612.9253

2507.845833 1598.9178

2319.920833 1494.2031

2405.695833 1503.6431

2289.783333 1476.590545

2240.458333 1406.085

2040.570833 1284.9114

2155.108333 1300.6533

2112.825 1285.6444

2124.995833 1307.9689

2005.729167 1196.886727

2121.645833 1298.4554

2101.195833 1289.5181

2131.579167 1308.1525

2112.925 1326.3411

2121.358333 1307.1761

2109.820833 1277.847182

2111.754167 1330.1648

2145.104167 1305.6209

2132.308333 1333.2882

2127.679167 1341.9708

2164.1625 1302.9812

2234.0125 1385.040909

2103.066667 1282.9082
Unit Net Electric Generation (MWh) Unit Gross Electric Generation (MWe)

237.74 252.9166667

221.71 240.5833333

217.61 231.0416667

234.81 249.625

228.8090909 256

237.77 254.5416667

240.31 256.625

238.63 256

221.96 237.9583333

225.66 246.7083333

218.5818182 233.8333333

208.66 229.5

190.86 203.4583333

192.8 209.5

191.58 203.9583333

193.52 206.7916667

177.5181818 196.7083333

193.27 207.75

191.37 205.25

194.44 212.1666667

196.13 206.7083333

192.9 206.6666667

188.9272727 208.2083333

196.88 210.7083333

191.91 211.6666667

195.68 211.6666667

198.01 211.0833333

192.67 211.5833333

196.7181818 218.375

188.53 207.7916667
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)

0.985085449 300.0291667

0.978540493 299.0583333

0.971577774 289.3916667

0.976451678 283.6541667

0.98480694 279.5583333

0.990098606 280.9458333

0.992605185 281.6916667

0.989820098 285.2375

0.985503212 282.8916667

0.982161107 287.0166667

0.982439616 287.0625

0.985363958 288.9583333

0.986617247 284.9333333

0.985642466 290.7375

0.985781721 288.3

0.981325581 285.2125

0.97589466 284.2666667

0.974223608 289.5541667

0.977565713 287.7458333

0.981325581 300.5125

0.978819002 291.7166667

0.979793782 292.0333333

0.979097511 289.9541667

0.977147949 297.05

0.978261984 306.175

0.978540493 311.625

0.982718124 309.6625

0.977844221 290.1333333

0.975059134 315.0541667

0.976869441 295.4291667
Flue Gas Oxygen Content (%) Flue Gas Carbon Dioxide Content (%) Flue Gas Moisture Content (%)

10.0583333333333 10.84166667

10.0833333333333 10.81666667

10.3083333333333 10.59166667

10.2625000000000 10.6375

9.9250000000000 10.975

9.8875000000000 11.0125

9.9625000000000 10.9375

10.2291666666667 10.67083333

10.4583333333333 10.44166667

10.4125000000000 10.4875

10.4500000000000 10.45

10.2458333333333 10.65416667

10.3666666666667 10.53333333

10.0833333333333 10.81666667

10.0958333333333 10.80416667

10.1833333333333 10.71666667

10.2541666666667 10.64583333

10.1000000000000 10.8

10.1125000000000 10.7875

10.1750000000000 10.725

10.0625000000000 10.8375

10.0375000000000 10.8625

10.1250000000000 10.775

10.2916666666667 10.60833333

10.2250000000000 10.675

10.1166666666667 10.78333333

10.1125000000000 10.7875

10.0958333333333 10.80416667

10.0416666666667 10.85833333

10.3291666666667 10.57083333