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 8
EIA Facility Code Facility Name Boiler ID

4041 South Oak Creek 8

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 8

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 8

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 8

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 3/11/2010 257.5875789 1000 lb per hour

Day 2 3/12/2010 187.7737368 1000 lb per hour

Day 3 3/13/2010 209.4441579 1000 lb per hour

Day 4 3/14/2010 165.1239444 1000 lb per hour

Day 5 3/15/2010 193.5985 1000 lb per hour

Day 6 3/16/2010 227.4426842 1000 lb per hour

Day 7 3/17/2010 229.8522105 1000 lb per hour

Day 8 3/18/2010 224.6661053 1000 lb per hour

Day 9 3/19/2010 227.0921053 1000 lb per hour

Day 10 3/20/2010 240.2802778 1000 lb per hour

Day 11 3/21/2010 225.87 1000 lb per hour

Day 12 3/22/2010 232.8486842 1000 lb per hour

Day 13 3/23/2010 220.9120526 1000 lb per hour

Day 14 3/24/2010 221.8068333 1000 lb per hour

Day 15 3/25/2010 222.6020526 1000 lb per hour

Day 16 3/26/2010 243.8911053 1000 lb per hour

Day 17 3/27/2010 246.7077368 1000 lb per hour

Day 18 3/28/2010 226.0611053 1000 lb per hour

Day 19 3/29/2010 277.8106667 1000 lb per hour

Day 20 3/30/2010 248.7884211 1000 lb per hour

Day 21 3/31/2010 225.8195789 1000 lb per hour

Day 22 4/1/2010 213.5149474 1000 lb per hour

Day 23 4/2/2010 187.6414444 1000 lb per hour

Day 24 4/3/2010 203.591 1000 lb per hour

Day 25 4/4/2010 175.2758421 1000 lb per hour

Day 26 4/5/2010 230.986 1000 lb per hour

Day 27 4/6/2010 267.2504211 1000 lb per hour

Day 28 4/7/2010 116.3306667 1000 lb per hour

Day 29 4/8/2010 276.2307368 1000 lb per hour

Day 30 4/9/2010 272.3141053 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)

2445.2 1361.628

1676.633333 982.6383684

1881.8 1061.622474

1464.716667 824.6288333

1793.170833 1004.021889

2056.904167 1201.501737

2085.3125 1219.440947

1983.933333 1197.837737

2024.495833 1214.186895

2360.275 1280.755778

2158.504167 1193.184053

2164.145833 1242.583579

2022.295833 1183.545368

1980.120833 1191.764167

2141.9625 1201.451158

2440.420833 1313.564947

2363.233333 1340.286368

2145.9 1228.794632

2686.891667 1513.393333

2371.354167 1373.738158

1960.0875 1231.099421

1890.091667 1175.629421

1612.170833 1021.637111

1823.983333 1109.786789

1588.516667 947.0855263

2085.45 1255.721737

2530.345833 1439.410211

1395.17619 623.0034444

2469 1439.241737

2600.516667 1411.360053
Unit Net Electric Generation (MWh) Unit Gross Electric Generation (MWe)

151.9 253.5505789

149.3 181.6283684

124.6 198.2766842

131.2 154.0185556

205.6 184.7997778

207.2 221.9977895

207.5 224.8565789

207 220.7534737

206.8 224.8705263

220.9 236.0790556

215.9 220.8552105

202.9 229.8432632

209.2 218.8661053

205.1 220.0146667

204.3 221.4751053

274.7 242.9296842

137 247.6619474

213.3 226.7114737

210.8 280.4931667

195 253.7912632

149.7 227.1093158

107.4 216.1461579

150 187.1093333

151.6 203.4252632

155.9 172.8763684

157.7 230.2041053

169.7 264.0927895

148.5 112.6366667

190.6 264.8976842

178.2 261.6364737
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.959184135 273.0833333

0.961690714 265.7541667

0.956956065 274.2041667

0.966007599 261.3083333

0.976869441 260.075

0.982300361 268.6583333

0.9803508 268.9083333

0.974919879 272.8

0.972552555 271.6125

0.976033914 260.2708333

0.976312423 270.8625

0.971020757 265.3

0.970324485 262.9083333

0.975198388 265.65

0.971299266 261.7666667

0.974362862 267.5833333

0.971995538 276.8041667

0.966703871 270.6833333

0.970742248 283.2

0.969628213 279.7083333

0.968931941 277.6291667

0.970045976 276.05

0.971160011 271.0791667

0.969488959 268.2125

0.973805844 260.0708333

0.974780625 276.9333333

0.960715933 279.825

0.960019661 225.5291667

0.963083258 273.8916667

0.972691809 274.75
Flue Gas Oxygen Content (%) Flue Gas Carbon Dioxide Content (%) Flue Gas Moisture Content (%)

10.06666667 10.83333333

10.38333333 10.51666667

10.15416667 10.74583333

10.34583333 10.55416667

10.49583333 10.40416667

10.89583333 10.00416667

10.73333333 10.16666667

10.75 10.15

10.725 10.175

10.75416667 10.14583333

10.64166667 10.25833333

10.44166667 10.45833333

10.31666667 10.58333333

10.54166667 10.35833333

10.31666667 10.58333333

10.175 10.725

10.25416667 10.64583333

10.5 10.4

10.1875 10.7125

10.21666667 10.68333333

10.40416667 10.49583333

10.44583333 10.45416667

10.5875 10.3125

10.35833333 10.54166667

10.64166667 10.25833333

10.22083333 10.67916667

10.07083333 10.82916667

15.15 5.75

10.95 9.95

9.9875 10.9125