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

976 Marion Generating Station B123
EIA Facility Code Facility Name Boiler ID

976 Marion Generating Station B123

Daily Average Process Data for a 30 Day Period Including the Testing Date

Date 

(MM/DD/YY) Coal Firing Rate (1,000 Tons/hr)

05/24/10 Day 1 0.075041667

05/25/10 Day 2 0.070791667

05/26/10 Day 3 0.068541667

05/27/10 Day 4 0.068166667

05/28/10 Day 5 0.07075

05/29/10 Day 6 0.070375

05/30/10 Day 7 0.07175

05/31/10 Day 8 0.071958333

06/01/10 Day 9 0.072416667

06/02/10 Day 10 0.068791667

06/03/10 Day 11 0.065666667

06/04/10 Day 12 0.068708333

06/05/10 Day 13 0.069791667

06/06/10 Day 14 0.071666667

06/07/10 Day 15 0.072

06/08/10 Day 16 0.06825

06/09/10 Day 17 0.073833333

06/10/10 Day 18 0.073041667

06/11/10 Day 19 0.070125

06/12/10 Day 20 0.071375

06/13/10 Day 21 0.065416667

06/14/10 Day 22 0.068208333

06/15/10 Day 23 0.072

06/16/10 Day 24 0.064208333

06/17/10 Day 25 0.071833333

06/18/10 Day 26 0.066208333

06/19/10 Day 27 0.073458333

06/20/10 Day 28 0.069666667

06/21/10 Day 29 0.068791667

06/22/10 Day 30 0.072708333

06/23/10 Day 31 0.070875
 for a 30 Day Period Including the Testing Date

Synfuel Firing Rate (1,000 Tons/hr) Pet Coke Firing Rate (1,000 Tons/hr)
Coal Gas Firing Rate (ft^3/min) Fuel oil Firing Rate (Gal/hr) Average Heat Input (MMBtu/hr)

1285.4

1280

1270.6

1274.4

1261

1257.2

1247.8

1245.5

1261.5

1275.7

1257.4

1261.6

1231.8

1244.4

1246.8

1246

1262.8

1276

1279.5

1267.1

1227

1274.9

1302.4

1154.7

1277.4

1298

1287

1302.9

1307.3

1292.6

1283.7
Steam Output (1,000 lbs steam/hr) Flue Gas Flow Rate (dscfm) Flue Gas Pressure (atm)

979 17837248

983 17447204

979 17649283

962 17489817

968 17611877

970 17647729

965 17545803

963 17193616

972 17360088

994 17776005

986 17523443

981 17536459

953 17241214

978 17383186

985 17638220

994 17571674

992 17679356

991 17628074

991 17857782

994 17675871

956 17159547

997 17754119

1005 18123551

886 16275365

976 18014152

982 17946992

968 17504525

969 17749479

977 17840671

960 17586416

954 17434021
Flue Gas Sampling Point Temperature (Deg F) Flue Gas Oxygen Content (%)

233.5 5

234.8 4.7

230.2 5

226.8 4.8

229.2 5.1

231.1 5.2

230.2 5.2

229.8 4.9

229.4 4.9

229 5.1

227.4 5.1

230.4 5

232.4 5.1

228.9 5.1

230.6 5.4

229.6 5.2

228.6 5.1

230.5 4.9

230.4 5.1

230 5.1

228.8 5.1

227.1 5

231.4 5

225 5.2

228.4 5.3

232.4 4.9

230.1 4.7

234.7 4.7

232.2 4.7

228.1 4.7

232 4.7
Flue Gas Carbon Dioxide Content (%) Flue Gas Moisture Content (%)

14.4

14.6

14.4

14.5

14.3

14.2

14.2

14.5

14.5

14.3

14.3

14.4

14.3

14.3

14

14.1

14.3

14.5

14.3

14.3

14.3

14.3

14.4

14.2

14.2

14.4

14.6

14.6

14.6

14.6

14.7
Unit Net Electric Generation (MWh) Unit Gross Electric Generation (MWe) Standard Pressure (atm)

104

104

104

103

103

103

103

103

104

106

105

104

101

104

105

105

105

105

105

105

102

106

106

93

103

104

102

102

103

102

100
Standard Temperature (Deg F) Pressure Drop across FGD (in H2O)
FGD Scrubber Liquor Flow Rate (gals/min) FGD Scrubber Liquor pH (pH) Sorbent Type
Sorbent Injection Rate (lb/hr)
EIA Facility Code Facility Name Boiler ID

976 Marion Generating Station B123

Daily Average Process Data for a 30 Day Period Including the Testing Date

Date 

(MM/DD/YYYY) Coal Firing Rate (1,000 Tons/hr)

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
a for a 30 Day Period Including the Testing Date

Synfuel Firing Rate (1,000 Tons/hr) Pet Coke Firing Rate (1,000 Tons/hr)
Coal Gas Firing Rate (ft^3/min) Fuel oil Firing Rate (Gal/hr) Average Heat Input (MMBtu/hr)
Steam Output (1,000 lbs steam/hr) Flue Gas Flow Rate (dscfm) Flue Gas Pressure (atm)
Flue Gas Sampling Point Temperature (Deg F) Flue Gas Oxygen Content (%)
Flue Gas Carbon Dioxide Content (%) Flue Gas Moisture Content (%)
Unit Net Electric Generation (MWh) Unit Gross Electric Generation (MWe) Standard Pressure (atm)
Standard Temperature (Deg F) Pressure Drop across FGD (in H2O)
FGD Scrubber Liquor Flow Rate (gals/min) FGD Scrubber Liquor pH (pH) Sorbent Type
Sorbent Injection Rate (lb/hr)
EIA Facility Code Facility Name Boiler ID

976 Marion Generating Station B123

Daily Average Process Data for a 30 Day Period Including the Testing Date

Date 

(MM/DD/YYYY) Coal Firing Rate (1,000 Tons/hr)

05/24/10 Day 1 0.075041667

05/25/10 Day 2 0.070791667

05/26/10 Day 3 0.068541667

05/27/10 Day 4 0.068166667

05/28/10 Day 5 0.07075

05/29/10 Day 6 0.070375

05/30/10 Day 7 0.07175

05/31/10 Day 8 0.071958333

06/01/10 Day 9 0.072416667

06/02/10 Day 10 0.068791667

06/03/10 Day 11 0.065666667

06/04/10 Day 12 0.068708333

06/05/10 Day 13 0.069791667

06/06/10 Day 14 0.071666667

06/07/10 Day 15 0.072

06/08/10 Day 16 0.06825

06/09/10 Day 17 0.073833333

06/10/10 Day 18 0.073041667

06/11/10 Day 19 0.070125

06/12/10 Day 20 0.071375

06/13/10 Day 21 0.065416667

06/14/10 Day 22 0.068208333

06/15/10 Day 23 0.072

06/16/10 Day 24 0.064208333

06/17/10 Day 25 0.071833333

06/18/10 Day 26 0.066208333

06/19/10 Day 27 0.073458333

06/20/10 Day 28 0.069666667

06/21/10 Day 29 0.068791667

06/22/10 Day 30 0.072708333

06/23/10 Day 31 0.070875
a for a 30 Day Period Including the Testing Date

Synfuel Firing Rate (1,000 Tons/hr) Pet Coke Firing Rate (1,000 Tons/hr)
Coal Gas Firing Rate (ft^3/min) Fuel oil Firing Rate (Gal/hr) Average Heat Input (MMBtu/hr)

1285.4

1280

1270.6

1274.4

1261

1257.2

1247.8

1245.5

1261.5

1275.7

1257.4

1261.6

1231.8

1244.4

1246.8

1246

1262.8

1276

1279.5

1267.1

1227

1274.9

1302.4

1154.7

1277.4

1298

1287

1302.9

1307.3

1292.6

1283.7
Steam Output (1,000 lbs steam/hr) Flue Gas Flow Rate (dscfm) Flue Gas Pressure (atm)

979 17837248

983 17447204

979 17649283

962 17489817

968 17611877

970 17647729

965 17545803

963 17193616

972 17360088

994 17776005

986 17523443

981 17536459

953 17241214

978 17383186

985 17638220

994 17571674

992 17679356

991 17628074

991 17857782

994 17675871

956 17159547

997 17754119

1005 18123551

886 16275365

976 18014152

982 17946992

968 17504525

969 17749479

977 17840671

960 17586416

954 17434021
Flue Gas Sampling Point Temperature (Deg F) Flue Gas Oxygen Content (%)

233.5 5

234.8 4.7

230.2 5

226.8 4.8

229.2 5.1

231.1 5.2

230.2 5.2

229.8 4.9

229.4 4.9

229 5.1

227.4 5.1

230.4 5

232.4 5.1

228.9 5.1

230.6 5.4

229.6 5.2

228.6 5.1

230.5 4.9

230.4 5.1

230 5.1

228.8 5.1

227.1 5

231.4 5

225 5.2

228.4 5.3

232.4 4.9

230.1 4.7

234.7 4.7

232.2 4.7

228.1 4.7

232 4.7
Flue Gas Carbon Dioxide Content (%) Flue Gas Moisture Content (%)

14.4

14.6

14.4

14.5

14.3

14.2

14.2

14.5

14.5

14.3

14.3

14.4

14.3

14.3

14

14.1

14.3

14.5

14.3

14.3

14.3

14.3

14.4

14.2

14.2

14.4

14.6

14.6

14.6

14.6

14.7
Unit Net Electric Generation (MWh) Unit Gross Electric Generation (MWe) Standard Pressure (atm)

104

104

104

103

103

103

103

103

104

106

105

104

101

104

105

105

105

105

105

105

102

106

106

93

103

104

102

102

103

102

100
Standard Temperature (Deg F) Pressure Drop across FGD (in H2O)
FGD Scrubber Liquor Flow Rate (gals/min) FGD Scrubber Liquor pH (pH) Sorbent Type
Sorbent Injection Rate (lb/hr)
EIA Facility Code Facility Name Boiler ID

976 Marion Generating Station B123

Daily Average Process Data for a 30 Day Period Including the Testing Date

Date 

(MM/DD/YYYY) Coal Firing Rate (1,000 Tons/hr)

05/24/10 Day 1 0.075041667

05/25/10 Day 2 0.070791667

05/26/10 Day 3 0.068541667

05/27/10 Day 4 0.068166667

05/28/10 Day 5 0.07075

05/29/10 Day 6 0.070375

05/30/10 Day 7 0.07175

05/31/10 Day 8 0.071958333

06/01/10 Day 9 0.072416667

06/02/10 Day 10 0.068791667

06/03/10 Day 11 0.065666667

06/04/10 Day 12 0.068708333

06/05/10 Day 13 0.069791667

06/06/10 Day 14 0.071666667

06/07/10 Day 15 0.072

06/08/10 Day 16 0.06825

06/09/10 Day 17 0.073833333

06/10/10 Day 18 0.073041667

06/11/10 Day 19 0.070125

06/12/10 Day 20 0.071375

06/13/10 Day 21 0.065416667

06/14/10 Day 22 0.068208333

06/15/10 Day 23 0.072

06/16/10 Day 24 0.064208333

06/17/10 Day 25 0.071833333

06/18/10 Day 26 0.066208333

06/19/10 Day 27 0.073458333

06/20/10 Day 28 0.069666667

06/21/10 Day 29 0.068791667

06/22/10 Day 30 0.072708333

06/23/10 Day 31 0.070875
a for a 30 Day Period Including the Testing Date

Synfuel Firing Rate (1,000 Tons/hr) Pet Coke Firing Rate (1,000 Tons/hr)
Coal Gas Firing Rate (ft^3/min) Fuel oil Firing Rate (Gal/hr) Average Heat Input (MMBtu/hr)

1285.4

1280

1270.6

1274.4

1261

1257.2

1247.8

1245.5

1261.5

1275.7

1257.4

1261.6

1231.8

1244.4

1246.8

1246

1262.8

1276

1279.5

1267.1

1227

1274.9

1302.4

1154.7

1277.4

1298

1287

1302.9

1307.3

1292.6

1283.7
Steam Output (1,000 lbs steam/hr) Flue Gas Flow Rate (dscfm) Flue Gas Pressure (atm)

979 17837248

983 17447204

979 17649283

962 17489817

968 17611877

970 17647729

965 17545803

963 17193616

972 17360088

994 17776005

986 17523443

981 17536459

953 17241214

978 17383186

985 17638220

994 17571674

992 17679356

991 17628074

991 17857782

994 17675871

956 17159547

997 17754119

1005 18123551

886 16275365

976 18014152

982 17946992

968 17504525

969 17749479

977 17840671

960 17586416

954 17434021
Flue Gas Sampling Point Temperature (Deg F) Flue Gas Oxygen Content (%)

233.5 5

234.8 4.7

230.2 5

226.8 4.8

229.2 5.1

231.1 5.2

230.2 5.2

229.8 4.9

229.4 4.9

229 5.1

227.4 5.1

230.4 5

232.4 5.1

228.9 5.1

230.6 5.4

229.6 5.2

228.6 5.1

230.5 4.9

230.4 5.1

230 5.1

228.8 5.1

227.1 5

231.4 5

225 5.2

228.4 5.3

232.4 4.9

230.1 4.7

234.7 4.7

232.2 4.7

228.1 4.7

232 4.7
Flue Gas Carbon Dioxide Content (%) Flue Gas Moisture Content (%)

14.4

14.6

14.4

14.5

14.3

14.2

14.2

14.5

14.5

14.3

14.3

14.4

14.3

14.3

14

14.1

14.3

14.5

14.3

14.3

14.3

14.3

14.4

14.2

14.2

14.4

14.6

14.6

14.6

14.6

14.7
Unit Net Electric Generation (MWh) Unit Gross Electric Generation (MWe) Standard Pressure (atm)

104

104

104

103

103

103

103

103

104

106

105

104

101

104

105

105

105

105

105

105

102

106

106

93

103

104

102

102

103

102

100
Standard Temperature (Deg F) Pressure Drop across FGD (in H2O)
FGD Scrubber Liquor Flow Rate (gals/min) FGD Scrubber Liquor pH (pH) Sorbent Type
Sorbent Injection Rate (lb/hr)