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

10151 American Bituminous Units 1/2
EIA Facility 

Code Facility Name Boiler ID

10151 American Bituminous Units 1/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

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)

Day 1 05/13/10 0.0753 1,000 Tons/hr 1222.33

Day 2 05/14/10 0.0782 1,000 Tons/hr 1239.10

Day 3 05/15/10 0.0705 1,000 Tons/hr 1081.28

Day 4 05/16/10 0.0391 1,000 Tons/hr 641.74

Day 5 05/17/10 0.0652 1,000 Tons/hr 963.94

Day 6 05/18/10 0.0760 1,000 Tons/hr 1218.98

Day 7 05/19/10 0.0806 1,000 Tons/hr 1231.72

Day 8 05/20/10 0.0763 1,000 Tons/hr 1227.69

Day 9 05/21/10 0.0702 1,000 Tons/hr 1215.10

Day 10 05/22/10 0.0686 1,000 Tons/hr 1213.26

Day 11 05/23/10 0.0710 1,000 Tons/hr 1211.42

Day 12 05/24/10 0.0698 1,000 Tons/hr 1218.30

Day 13 05/25/10 0.0676 1,000 Tons/hr 1203.51

Day 14 05/26/10 0.0711 1,000 Tons/hr 1205.10

Day 15 05/27/10 0.0749 1,000 Tons/hr 1199.00

Day 16 05/28/10 0.0733 1,000 Tons/hr 1196.15

Day 17 05/29/10 0.0698 1,000 Tons/hr 1207.26

Day 18 05/30/10 0.0732 1,000 Tons/hr 1203.47

Day 19 05/31/10 0.0711 1,000 Tons/hr 1228.87

Day 20 06/01/10 0.0689 1,000 Tons/hr 1213.67

Day 21 06/02/10 0.0622 1,000 Tons/hr 1187.21

Day 22 06/03/10 0.0619 1,000 Tons/hr 1188.40

Day 23 06/04/10 0.0713 1,000 Tons/hr 1207.55

Day 24 06/05/10 0.0763 1,000 Tons/hr 1209.93

Day 25 06/06/10 0.0715 1,000 Tons/hr 1186.28

Day 26 06/07/10 0.0739 1,000 Tons/hr 1215.09

Day 27 06/08/10 0.0728 1,000 Tons/hr 1230.81

Day 28 06/09/10 0.0729 1,000 Tons/hr 1204.54

Day 29 06/10/10 0.0739 1,000 Tons/hr 1203.07

Day 30 06/11/10 0.0742 1,000 Tons/hr 1208.15
Control Device Operating Parameters, As Appicable Other Boiler or Control Device Operating Parameters (e.g., Boiler O2) 

Steam Output 

(1,000 lbs 

steam/hr)

Unit Net 

Electric 

Generation 

(MWh)

Unit Gross 

Electric 

Generation 

(MWe)

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)

Flue Gas 

Pressure (atm)

Flue Gas 

Sampling Point 

Temperature 

(Deg F)

Flue Gas 

Oxygen 

Content (%)

Flue Gas 

Carbon Dioxide 

Content (%)

Flue Gas 

Moisture 

Content (%)

769.6 77.36 87.53 311293.5 364.7 8.6 10.8 8

782.1 78.57 88.81 310322.2 366.0 8.4 11.0 8

683.5 71.49 81.61 310741.6 349.2 10.0 9.6 8

392.7 37.47 45.40 193341.8 319.6 10.2 9.4 8

595.6 55.83 64.93 284349.0 336.5 10.4 9.3 8

781.3 78.56 88.97 313947.1 360.3 8.7 10.7 8

782.3 78.48 89.03 314894.8 361.4 8.6 10.8 8

783.8 78.62 89.23 312816.2 362.1 8.6 10.8 8

780.8 78.69 88.95 310900.7 364.6 8.7 10.8 8

779.3 78.97 89.04 310534.0 363.7 8.7 10.8 8

782.0 78.88 89.15 309583.8 366.3 8.6 10.8 8

779.1 78.78 88.97 309910.4 365.6 8.6 10.8 8

775.6 78.48 88.63 309722.7 363.9 8.7 10.7 8

778.5 78.25 88.72 309181.4 367.1 8.7 10.8 8

778.8 78.32 88.72 307478.3 370.6 8.7 10.8 8

775.0 78.33 88.36 307917.1 364.4 8.7 10.7 8

777.1 78.83 88.62 309358.8 365.9 8.7 10.8 8

778.0 78.14 88.63 308874.4 367.6 8.7 10.8 8

782.2 79.24 89.04 309868.9 369.7 8.5 10.9 8

781.1 78.80 88.81 308607.5 370.0 8.6 10.9 8

782.3 78.50 88.95 309984.0 362.3 8.9 10.6 8

780.0 78.76 88.87 311149.9 360.2 8.9 10.5 8

774.8 78.08 88.20 308255.6 365.7 8.6 10.8 8

776.9 78.76 88.44 308618.0 370.1 8.6 10.8 8

775.9 77.99 88.40 309254.4 360.8 8.9 10.6 8

775.8 78.67 88.74 311368.8 364.7 8.7 10.8 8

778.0 78.83 89.17 311791.8 367.4 8.5 10.9 8

774.7 78.02 88.34 311557.9 361.7 8.8 10.7 8

776.7 78.24 88.48 309122.2 365.3 8.7 10.8 8

775.5 78.00 88.36 309359.4 368.3 8.7 10.8 8
EIA Facility Code Facility Name Boiler ID

10151 American Bituminous Units 1/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

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

10151 American Bituminous Units 1/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 05/13/10 0.0753 1,000 Tons/hr

Day 2 05/14/10 0.0782 1,000 Tons/hr

Day 3 05/15/10 0.0705 1,000 Tons/hr

Day 4 05/16/10 0.0391 1,000 Tons/hr

Day 5 05/17/10 0.0652 1,000 Tons/hr

Day 6 05/18/10 0.0760 1,000 Tons/hr

Day 7 05/19/10 0.0806 1,000 Tons/hr

Day 8 05/20/10 0.0763 1,000 Tons/hr

Day 9 05/21/10 0.0702 1,000 Tons/hr

Day 10 05/22/10 0.0686 1,000 Tons/hr

Day 11 05/23/10 0.0710 1,000 Tons/hr

Day 12 05/24/10 0.0698 1,000 Tons/hr

Day 13 05/25/10 0.0676 1,000 Tons/hr

Day 14 05/26/10 0.0711 1,000 Tons/hr

Day 15 05/27/10 0.0749 1,000 Tons/hr

Day 16 05/28/10 0.0733 1,000 Tons/hr

Day 17 05/29/10 0.0698 1,000 Tons/hr

Day 18 05/30/10 0.0732 1,000 Tons/hr

Day 19 05/31/10 0.0711 1,000 Tons/hr

Day 20 06/01/10 0.0689 1,000 Tons/hr

Day 21 06/02/10 0.0622 1,000 Tons/hr

Day 22 06/03/10 0.0619 1,000 Tons/hr

Day 23 06/04/10 0.0713 1,000 Tons/hr

Day 24 06/05/10 0.0763 1,000 Tons/hr

Day 25 06/06/10 0.0715 1,000 Tons/hr

Day 26 06/07/10 0.0739 1,000 Tons/hr

Day 27 06/08/10 0.0728 1,000 Tons/hr

Day 28 06/09/10 0.0729 1,000 Tons/hr

Day 29 06/10/10 0.0739 1,000 Tons/hr

Day 30 06/11/10 0.0742 1,000 Tons/hr
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)

1222.33 769.6

1239.10 782.1

1081.28 683.5

641.74 392.7

963.94 595.6

1218.98 781.3

1231.72 782.3

1227.69 783.8

1215.10 780.8

1213.26 779.3

1211.42 782.0

1218.30 779.1

1203.51 775.6

1205.10 778.5

1199.00 778.8

1196.15 775.0

1207.26 777.1

1203.47 778.0

1228.87 782.2

1213.67 781.1

1187.21 782.3

1188.40 780.0

1207.55 774.8

1209.93 776.9

1186.28 775.9

1215.09 775.8

1230.81 778.0

1204.54 774.7

1203.07 776.7

1208.15 775.5
Unit Net Electric Generation (MWh) Unit Gross Electric Generation (MWe)

77.36 87.53

78.57 88.81

71.49 81.61

37.47 45.40

55.83 64.93

78.56 88.97

78.48 89.03

78.62 89.23

78.69 88.95

78.97 89.04

78.88 89.15

78.78 88.97

78.48 88.63

78.25 88.72

78.32 88.72

78.33 88.36

78.83 88.62

78.14 88.63

79.24 89.04

78.80 88.81

78.50 88.95

78.76 88.87

78.08 88.20

78.76 88.44

77.99 88.40

78.67 88.74

78.83 89.17

78.02 88.34

78.24 88.48

78.00 88.36
Control Device Operating Parameters, As Appicable

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

311293.5

310322.2

310741.6

193341.8

284349.0

313947.1

314894.8

312816.2

310900.7

310534.0

309583.8

309910.4

309722.7

309181.4

307478.3

307917.1

309358.8

308874.4

309868.9

308607.5

309984.0

311149.9

308255.6

308618.0

309254.4

311368.8

311791.8

311557.9

309122.2

309359.4
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)

364.7

366.0

349.2

319.6

336.5

360.3

361.4

362.1

364.6

363.7

366.3

365.6

363.9

367.1

370.6

364.4

365.9

367.6

369.7

370.0

362.3

360.2

365.7

370.1

360.8

364.7

367.4

361.7

365.3

368.3
Flue Gas Oxygen Content (%) Flue Gas Carbon Dioxide Content (%) Flue Gas Moisture Content (%)

8.6 10.8 8

8.4 11.0 8

10.0 9.6 8

10.2 9.4 8

10.4 9.3 8

8.7 10.7 8

8.6 10.8 8

8.6 10.8 8

8.7 10.8 8

8.7 10.8 8

8.6 10.8 8

8.6 10.8 8

8.7 10.7 8

8.7 10.8 8

8.7 10.8 8

8.7 10.7 8

8.7 10.8 8

8.7 10.8 8

8.5 10.9 8

8.6 10.9 8

8.9 10.6 8

8.9 10.5 8

8.6 10.8 8

8.6 10.8 8

8.9 10.6 8

8.7 10.8 8

8.5 10.9 8

8.8 10.7 8

8.7 10.8 8

8.7 10.8 8
EIA Facility Code Facility Name Boiler ID

10151 American Bituminous Units 1/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 05/13/10 0.0753 1,000 Tons/hr

Day 2 05/14/10 0.0782 1,000 Tons/hr

Day 3 05/15/10 0.0705 1,000 Tons/hr

Day 4 05/16/10 0.0391 1,000 Tons/hr

Day 5 05/17/10 0.0652 1,000 Tons/hr

Day 6 05/18/10 0.0760 1,000 Tons/hr

Day 7 05/19/10 0.0806 1,000 Tons/hr

Day 8 05/20/10 0.0763 1,000 Tons/hr

Day 9 05/21/10 0.0702 1,000 Tons/hr

Day 10 05/22/10 0.0686 1,000 Tons/hr

Day 11 05/23/10 0.0710 1,000 Tons/hr

Day 12 05/24/10 0.0698 1,000 Tons/hr

Day 13 05/25/10 0.0676 1,000 Tons/hr

Day 14 05/26/10 0.0711 1,000 Tons/hr

Day 15 05/27/10 0.0749 1,000 Tons/hr

Day 16 05/28/10 0.0733 1,000 Tons/hr

Day 17 05/29/10 0.0698 1,000 Tons/hr

Day 18 05/30/10 0.0732 1,000 Tons/hr

Day 19 05/31/10 0.0711 1,000 Tons/hr

Day 20 06/01/10 0.0689 1,000 Tons/hr

Day 21 06/02/10 0.0622 1,000 Tons/hr

Day 22 06/03/10 0.0619 1,000 Tons/hr

Day 23 06/04/10 0.0713 1,000 Tons/hr

Day 24 06/05/10 0.0763 1,000 Tons/hr

Day 25 06/06/10 0.0715 1,000 Tons/hr

Day 26 06/07/10 0.0739 1,000 Tons/hr

Day 27 06/08/10 0.0728 1,000 Tons/hr

Day 28 06/09/10 0.0729 1,000 Tons/hr

Day 29 06/10/10 0.0739 1,000 Tons/hr

Day 30 06/11/10 0.0742 1,000 Tons/hr
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)

1222.33 769.6

1239.10 782.1

1081.28 683.5

641.74 392.7

963.94 595.6

1218.98 781.3

1231.72 782.3

1227.69 783.8

1215.10 780.8

1213.26 779.3

1211.42 782.0

1218.30 779.1

1203.51 775.6

1205.10 778.5

1199.00 778.8

1196.15 775.0

1207.26 777.1

1203.47 778.0

1228.87 782.2

1213.67 781.1

1187.21 782.3

1188.40 780.0

1207.55 774.8

1209.93 776.9

1186.28 775.9

1215.09 775.8

1230.81 778.0

1204.54 774.7

1203.07 776.7

1208.15 775.5
Unit Net Electric Generation (MWh) Unit Gross Electric Generation (MWe)

77.36 87.53

78.57 88.81

71.49 81.61

37.47 45.40

55.83 64.93

78.56 88.97

78.48 89.03

78.62 89.23

78.69 88.95

78.97 89.04

78.88 89.15

78.78 88.97

78.48 88.63

78.25 88.72

78.32 88.72

78.33 88.36

78.83 88.62

78.14 88.63

79.24 89.04

78.80 88.81

78.50 88.95

78.76 88.87

78.08 88.20

78.76 88.44

77.99 88.40

78.67 88.74

78.83 89.17

78.02 88.34

78.24 88.48

78.00 88.36
Control Device Operating Parameters, As Appicable

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

311293.5

310322.2

310741.6

193341.8

284349.0

313947.1

314894.8

312816.2

310900.7

310534.0

309583.8

309910.4

309722.7

309181.4

307478.3

307917.1

309358.8

308874.4

309868.9

308607.5

309984.0

311149.9

308255.6

308618.0

309254.4

311368.8

311791.8

311557.9

309122.2

309359.4
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)

364.7

366.0

349.2

319.6

336.5

360.3

361.4

362.1

364.6

363.7

366.3

365.6

363.9

367.1

370.6

364.4

365.9

367.6

369.7

370.0

362.3

360.2

365.7

370.1

360.8

364.7

367.4

361.7

365.3

368.3
Flue Gas Oxygen Content (%) Flue Gas Carbon Dioxide Content (%) Flue Gas Moisture Content (%)

8.6 10.8 8

8.4 11.0 8

10.0 9.6 8

10.2 9.4 8

10.4 9.3 8

8.7 10.7 8

8.6 10.8 8

8.6 10.8 8

8.7 10.8 8

8.7 10.8 8

8.6 10.8 8

8.6 10.8 8

8.7 10.7 8

8.7 10.8 8

8.7 10.8 8

8.7 10.7 8

8.7 10.8 8

8.7 10.8 8

8.5 10.9 8

8.6 10.9 8

8.9 10.6 8

8.9 10.5 8

8.6 10.8 8

8.6 10.8 8

8.9 10.6 8

8.7 10.8 8

8.5 10.9 8

8.8 10.7 8

8.7 10.8 8

8.7 10.8 8