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

47 Colbert 3
EIA Facility Code Facility Name Boiler ID

47 Colbert 3

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 5/15/2010

Day 2 5/16/2010

Day 3 5/17/2010

Day 4 5/18/2010

Day 5 5/19/2010

Day 6 5/20/2010

Day 7 5/21/2010

Day 8 5/22/2010

Day 9 5/23/2010

Day 10 5/24/2010

Day 11 5/25/2010

Day 12 5/26/2010

Day 13 5/27/2010

Day 14 5/28/2010

Day 15 5/29/2010

Day 16 5/30/2010

Day 17 5/31/2010

Day 18 6/1/2010

Day 19 6/2/2010

Day 20 6/3/2010

Day 21 6/4/2010

Day 22 6/5/2010

Day 23 6/6/2010

Day 24 6/7/2010

Day 25 6/8/2010

Day 26 6/9/2010

Day 27 6/10/2010

Day 28 6/11/2010

Day 29 6/12/2010

Day 30 6/13/2010
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)

1384.170833 1074

1243.804167 1095

1364.408333 1074

1372.0625 1098

1566.429167 1161

1486.6125 1020

1536.6875 1099

1646.979167 1187

1504.408333 984

1577.354167 1042

1375.8125 1072

1553.7125 1193

1758.1625 1178

1530.245833 997

1676.154167 987

1673.079167 1011

1782.791667 1049

1718.7625 1034

1640.508333 1013

1241.2375 1096

1629.554167 1057

1862.008333 981

1591.454167 814

1545.7375 854

1706.633333 1074

1698.55 1134

1312.1375 832

1617.741667 1149

1713.058333 1113

1653.495833 1128
Unit Net Electric Generation (MWh) Unit Gross Electric Generation (MWe)

145.25

136.375

144.2083333

151.7083333

160.7083333

153

155.625

162.2083333

150.5833333

150.9583333

131.125

149.875

167.0833333

143.0833333

153.5833333

152.6666667

164.875

159.0416667

154.4583333

119

152.8333333

175.2083333

146.125

143.8333333

159.7083333

158.5

122.0416667

154.375

159.6666667

164.3333333
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

47 Colbert 3

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

47 Colbert 3

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 1 5/15/2010

Day 2 Day 2 5/16/2010

Day 3 Day 3 5/17/2010

Day 4 Day 4 5/18/2010

Day 5 Day 5 5/19/2010

Day 6 Day 6 5/20/2010

Day 7 Day 7 5/21/2010

Day 8 Day 8 5/22/2010

Day 9 Day 9 5/23/2010

Day 10 Day 10 5/24/2010

Day 11 Day 11 5/25/2010

Day 12 Day 12 5/26/2010

Day 13 Day 13 5/27/2010

Day 14 Day 14 5/28/2010

Day 15 Day 15 5/29/2010

Day 16 Day 16 5/30/2010

Day 17 Day 17 5/31/2010

Day 18 Day 18 6/1/2010

Day 19 Day 19 6/2/2010

Day 20 Day 20 6/3/2010

Day 21 Day 21 6/4/2010

Day 22 Day 22 6/5/2010

Day 23 Day 23 6/6/2010

Day 24 Day 24 6/7/2010

Day 25 Day 25 6/8/2010

Day 26 Day 26 6/9/2010

Day 27 Day 27 6/10/2010

Day 28 Day 28 6/11/2010

Day 29 Day 29 6/12/2010

Day 30 Day 30 6/13/2010
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)

1384.170833

1243.804167

1364.408333

1372.0625

1566.429167

1486.6125

1536.6875

1646.979167

1504.408333

1577.354167

1375.8125

1553.7125

1758.1625

1530.245833

1676.154167

1673.079167

1782.791667

1718.7625

1640.508333

1241.2375

1629.554167

1862.008333

1591.454167

1545.7375

1706.633333

1698.55

1312.1375

1617.741667

1713.058333

1653.495833
Unit Net Electric Generation (MWh) Unit Gross Electric Generation (MWe)

1074

1095

1074

1098

1161

1020

1099

1187

984

1042

1072

1193

1178

997

987

1011

1049

1034

1013

1096

1057

981

814

854

1074

1134

832

1149

1113

1128
Control Device Operating Parameters, As Appicable

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

145.25

136.375

144.2083333

151.7083333

160.7083333

153

155.625

162.2083333

150.5833333

150.9583333

131.125

149.875

167.0833333

143.0833333

153.5833333

152.6666667

164.875

159.0416667

154.4583333

119

152.8333333

175.2083333

146.125

143.8333333

159.7083333

158.5

122.0416667

154.375

159.6666667

164.3333333
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

47 Colbert 3

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 1 5/15/2010

Day 2 Day 2 5/16/2010

Day 3 Day 3 5/17/2010

Day 4 Day 4 5/18/2010

Day 5 Day 5 5/19/2010

Day 6 Day 6 5/20/2010

Day 7 Day 7 5/21/2010

Day 8 Day 8 5/22/2010

Day 9 Day 9 5/23/2010

Day 10 Day 10 5/24/2010

Day 11 Day 11 5/25/2010

Day 12 Day 12 5/26/2010

Day 13 Day 13 5/27/2010

Day 14 Day 14 5/28/2010

Day 15 Day 15 5/29/2010

Day 16 Day 16 5/30/2010

Day 17 Day 17 5/31/2010

Day 18 Day 18 6/1/2010

Day 19 Day 19 6/2/2010

Day 20 Day 20 6/3/2010

Day 21 Day 21 6/4/2010

Day 22 Day 22 6/5/2010

Day 23 Day 23 6/6/2010

Day 24 Day 24 6/7/2010

Day 25 Day 25 6/8/2010

Day 26 Day 26 6/9/2010

Day 27 Day 27 6/10/2010

Day 28 Day 28 6/11/2010

Day 29 Day 29 6/12/2010

Day 30 Day 30 6/13/2010
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)

1384.170833

1243.804167

1364.408333

1372.0625

1566.429167

1486.6125

1536.6875

1646.979167

1504.408333

1577.354167

1375.8125

1553.7125

1758.1625

1530.245833

1676.154167

1673.079167

1782.791667

1718.7625

1640.508333

1241.2375

1629.554167

1862.008333

1591.454167

1545.7375

1706.633333

1698.55

1312.1375

1617.741667

1713.058333

1653.495833
Unit Net Electric Generation (MWh) Unit Gross Electric Generation (MWe)

1074

1095

1074

1098

1161

1020

1099

1187

984

1042

1072

1193

1178

997

987

1011

1049

1034

1013

1096

1057

981

814

854

1074

1134

832

1149

1113

1128
Control Device Operating Parameters, As Appicable

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

145.25

136.375

144.2083333

151.7083333

160.7083333

153

155.625

162.2083333

150.5833333

150.9583333

131.125

149.875

167.0833333

143.0833333

153.5833333

152.6666667

164.875

159.0416667

154.4583333

119

152.8333333

175.2083333

146.125

143.8333333

159.7083333

158.5

122.0416667

154.375

159.6666667

164.3333333
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 (%)