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

2917 Hamilton 9
1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

17

18

19

20

21

22

23

24

25

26

27

28

29

30

31

32

33

34

35

A B C H I J K L

EIA Facility Code Facility Name Boiler ID

2917 Hamilton 9

revised 10/11/10

Daily Average Process Data for a 30 Day Period Including the Testing Date (as requested by rti)

Date 

(MM/DD/YY)

Coal Firing Rate

(1,000 Tons/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)

05/21/10 Day 1 0.01477 390.4 313.576 98633 0.980 176.8

05/22/10 Day 2 0.01367 366.0 291.953 93206 0.981 177.7

05/23/10 Day 3 0.01369 371.8 292.356 95804 0.984 180.6

05/24/10 Day 4 0.01496 410.8 328.059 102632 0.985 180.6

05/25/10 Day 5 0.01517 396.0 330.010 101748 0.983 179.6

05/26/10 Day 6 0.01718 439.9 380.339 108828 0.978 180.3

05/27/10 Day 7 0.01483 387.1 328.743 99366 0.974 179.6

05/28/10 Day 8 0.01371 366.8 298.594 95533 0.975 180.7

05/29/10 Day 9 0.01372 372.4 298.594 95778 0.977 181.0

05/30/10 Day 10 0.01452 395.8 318.374 99444 0.978 180.1

05/31/10 Day 11 0.01334 368.4 292.222 96824 0.977 181.0

06/01/10 Day 12 0.01484 404.3 328.810 100447 0.977 179.8

06/02/10 Day 13 0.01354 370.1 297.066 96447 0.972 179.5

06/03/10 Day 14 0.01327 368.8 298.170 97304 0.972 182.0

06/04/10 Day 15 0.01667 443.4 371.313 107532 0.973 181.2

06/05/10 Day 16 0.01372 367.2 294.448 95420 0.972 181.8

06/06/10 Day 17 0.01346 363.3 293.346 95363 0.972 178.7

06/10/10 Day 18 0.01393 373.7 300.533 96676 0.979 179.0

06/11/10 Day 19 0.01396 374.0 298.145 97058 0.981 182.1

06/12/10 Day 20 0.01329 368.6 293.371 97052 0.980 183.3

06/13/10 Day 21 0.01325 369.3 291.124 97481 0.979 182.0

06/14/10 Day 22 0.01564 424.4 350.364 105563 0.977 183.8

06/15/10 Day 23 0.01544 420.8 345.243 105612 0.979 181.5

06/16/10 Day 24 0.01503 408.7 330.640 103355 0.980 180.3

06/17/10 Day 25 0.01385 371.5 293.345 97868 0.982 181.8

06/18/10 Day 26 0.01540 410.5 330.882 102893 0.982 181.3

06/19/10 Day 27 0.01470 388.0 313.281 97948 0.980 180.6

06/20/10 Day 28 0.01494 406.1 326.609 100835 0.981 182.7

06/21/10 Day 29 0.01487 404.3 327.975 100273 0.982 180.7

06/22/10 Day 30 0.01590 422.3 345.787 103113 0.983 180.7
1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

17

18

19

20

21

22

23

24

25

26

27

28

29

30

31

32

33

34

35

A B

EIA Facility Code Facility Name

2917 Hamilton

Date 

(MM/DD/YY)

05/21/10 Day 1

05/22/10 Day 2

05/23/10 Day 3

05/24/10 Day 4

05/25/10 Day 5

05/26/10 Day 6

05/27/10 Day 7

05/28/10 Day 8

05/29/10 Day 9

05/30/10 Day 10

05/31/10 Day 11

06/01/10 Day 12

06/02/10 Day 13

06/03/10 Day 14

06/04/10 Day 15

06/05/10 Day 16

06/06/10 Day 17

06/10/10 Day 18

06/11/10 Day 19

06/12/10 Day 20

06/13/10 Day 21

06/14/10 Day 22

06/15/10 Day 23

06/16/10 Day 24

06/17/10 Day 25

06/18/10 Day 26

06/19/10 Day 27

06/20/10 Day 28

06/21/10 Day 29

06/22/10 Day 30

M N O P Q R

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)

Not Available; Do Not Monitor 10.85 Not Available; Do Not Monitor 32.79 35.83

Not Available; Do Not Monitor 10.80 Not Available; Do Not Monitor 31.17 34.17

Not Available; Do Not Monitor 10.67 Not Available; Do Not Monitor 32.29 35.42

Not Available; Do Not Monitor 10.94 Not Available; Do Not Monitor 34.25 37.50

Not Available; Do Not Monitor 10.66 Not Available; Do Not Monitor 35.29 38.75

Not Available; Do Not Monitor 11.06 Not Available; Do Not Monitor 39.83 43.33

Not Available; Do Not Monitor 10.67 Not Available; Do Not Monitor 39.17 42.50

Not Available; Do Not Monitor 10.55 Not Available; Do Not Monitor 27.96 31.25

Not Available; Do Not Monitor 10.69 Not Available; Do Not Monitor 30.96 34.17

Not Available; Do Not Monitor 10.91 Not Available; Do Not Monitor 34.17 37.50

Not Available; Do Not Monitor 10.45 Not Available; Do Not Monitor 30.92 34.17

Not Available; Do Not Monitor 11.00 Not Available; Do Not Monitor 34.21 37.50

Not Available; Do Not Monitor 10.54 Not Available; Do Not Monitor 30.92 34.17

Not Available; Do Not Monitor 10.39 Not Available; Do Not Monitor 30.92 34.17

Not Available; Do Not Monitor 11.28 Not Available; Do Not Monitor 39.46 42.92

Not Available; Do Not Monitor 10.57 Not Available; Do Not Monitor 31.33 34.58

Not Available; Do Not Monitor 10.48 Not Available; Do Not Monitor 30.54 33.75

Not Available; Do Not Monitor 10.63 Not Available; Do Not Monitor 32.38 35.42

Not Available; Do Not Monitor 10.59 Not Available; Do Not Monitor 31.63 34.58

Not Available; Do Not Monitor 10.45 Not Available; Do Not Monitor 31.54 34.58

Not Available; Do Not Monitor 10.41 Not Available; Do Not Monitor 31.54 34.58

Not Available; Do Not Monitor 10.99 Not Available; Do Not Monitor 37.42 40.83

Not Available; Do Not Monitor 10.89 Not Available; Do Not Monitor 36.00 39.17

Not Available; Do Not Monitor 10.81 Not Available; Do Not Monitor 35.63 38.75

Not Available; Do Not Monitor 10.43 Not Available; Do Not Monitor 31.13 34.17

Not Available; Do Not Monitor 10.92 Not Available; Do Not Monitor 35.50 38.75

Not Available; Do Not Monitor 10.86 Not Available; Do Not Monitor 33.75 37.08

Not Available; Do Not Monitor 11.02 Not Available; Do Not Monitor 34.54 37.92

Not Available; Do Not Monitor 11.03 Not Available; Do Not Monitor 34.54 37.92

Not Available; Do Not Monitor 11.20 Not Available; Do Not Monitor 36.17 39.58
1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

17

18

19

20

21

22

23

24

25

26

27

28

29

30

31

32

33

34

35

A B

EIA Facility Code Facility Name

2917 Hamilton

Date 

(MM/DD/YY)

05/21/10 Day 1

05/22/10 Day 2

05/23/10 Day 3

05/24/10 Day 4

05/25/10 Day 5

05/26/10 Day 6

05/27/10 Day 7

05/28/10 Day 8

05/29/10 Day 9

05/30/10 Day 10

05/31/10 Day 11

06/01/10 Day 12

06/02/10 Day 13

06/03/10 Day 14

06/04/10 Day 15

06/05/10 Day 16

06/06/10 Day 17

06/10/10 Day 18

06/11/10 Day 19

06/12/10 Day 20

06/13/10 Day 21

06/14/10 Day 22

06/15/10 Day 23

06/16/10 Day 24

06/17/10 Day 25

06/18/10 Day 26

06/19/10 Day 27

06/20/10 Day 28

06/21/10 Day 29

06/22/10 Day 30

S T U V W X

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)

0.157 N/A : Dry Scrubber FGD Process N/A : Dry Scrubber FGD Process N/A : Dry Scrubber FGD Process N/A : Dry Scrubber FGD Process

0.136 N/A : Dry Scrubber FGD Process N/A : Dry Scrubber FGD Process N/A : Dry Scrubber FGD Process N/A : Dry Scrubber FGD Process

0.133 N/A : Dry Scrubber FGD Process N/A : Dry Scrubber FGD Process N/A : Dry Scrubber FGD Process N/A : Dry Scrubber FGD Process

0.166 N/A : Dry Scrubber FGD Process N/A : Dry Scrubber FGD Process N/A : Dry Scrubber FGD Process N/A : Dry Scrubber FGD Process

0.168 N/A : Dry Scrubber FGD Process N/A : Dry Scrubber FGD Process N/A : Dry Scrubber FGD Process N/A : Dry Scrubber FGD Process

0.168 N/A : Dry Scrubber FGD Process N/A : Dry Scrubber FGD Process N/A : Dry Scrubber FGD Process N/A : Dry Scrubber FGD Process

0.162 N/A : Dry Scrubber FGD Process N/A : Dry Scrubber FGD Process N/A : Dry Scrubber FGD Process N/A : Dry Scrubber FGD Process

0.163 N/A : Dry Scrubber FGD Process N/A : Dry Scrubber FGD Process N/A : Dry Scrubber FGD Process N/A : Dry Scrubber FGD Process

0.158 N/A : Dry Scrubber FGD Process N/A : Dry Scrubber FGD Process N/A : Dry Scrubber FGD Process N/A : Dry Scrubber FGD Process

0.161 N/A : Dry Scrubber FGD Process N/A : Dry Scrubber FGD Process N/A : Dry Scrubber FGD Process N/A : Dry Scrubber FGD Process

0.160 N/A : Dry Scrubber FGD Process N/A : Dry Scrubber FGD Process N/A : Dry Scrubber FGD Process N/A : Dry Scrubber FGD Process

0.145 N/A : Dry Scrubber FGD Process N/A : Dry Scrubber FGD Process N/A : Dry Scrubber FGD Process N/A : Dry Scrubber FGD Process

0.162 N/A : Dry Scrubber FGD Process N/A : Dry Scrubber FGD Process N/A : Dry Scrubber FGD Process N/A : Dry Scrubber FGD Process

0.156 N/A : Dry Scrubber FGD Process N/A : Dry Scrubber FGD Process N/A : Dry Scrubber FGD Process N/A : Dry Scrubber FGD Process

0.154 N/A : Dry Scrubber FGD Process N/A : Dry Scrubber FGD Process N/A : Dry Scrubber FGD Process N/A : Dry Scrubber FGD Process

0.142 N/A : Dry Scrubber FGD Process N/A : Dry Scrubber FGD Process N/A : Dry Scrubber FGD Process N/A : Dry Scrubber FGD Process

0.147 N/A : Dry Scrubber FGD Process N/A : Dry Scrubber FGD Process N/A : Dry Scrubber FGD Process N/A : Dry Scrubber FGD Process

0.107 N/A : Dry Scrubber FGD Process N/A : Dry Scrubber FGD Process N/A : Dry Scrubber FGD Process N/A : Dry Scrubber FGD Process

0.098 N/A : Dry Scrubber FGD Process N/A : Dry Scrubber FGD Process N/A : Dry Scrubber FGD Process N/A : Dry Scrubber FGD Process

0.112 N/A : Dry Scrubber FGD Process N/A : Dry Scrubber FGD Process N/A : Dry Scrubber FGD Process N/A : Dry Scrubber FGD Process

0.115 N/A : Dry Scrubber FGD Process N/A : Dry Scrubber FGD Process N/A : Dry Scrubber FGD Process N/A : Dry Scrubber FGD Process

0.144 N/A : Dry Scrubber FGD Process N/A : Dry Scrubber FGD Process N/A : Dry Scrubber FGD Process N/A : Dry Scrubber FGD Process

0.145 N/A : Dry Scrubber FGD Process N/A : Dry Scrubber FGD Process N/A : Dry Scrubber FGD Process N/A : Dry Scrubber FGD Process

0.133 N/A : Dry Scrubber FGD Process N/A : Dry Scrubber FGD Process N/A : Dry Scrubber FGD Process N/A : Dry Scrubber FGD Process

0.130 N/A : Dry Scrubber FGD Process N/A : Dry Scrubber FGD Process N/A : Dry Scrubber FGD Process N/A : Dry Scrubber FGD Process

0.121 N/A : Dry Scrubber FGD Process N/A : Dry Scrubber FGD Process N/A : Dry Scrubber FGD Process N/A : Dry Scrubber FGD Process

0.098 N/A : Dry Scrubber FGD Process N/A : Dry Scrubber FGD Process N/A : Dry Scrubber FGD Process N/A : Dry Scrubber FGD Process

0.107 N/A : Dry Scrubber FGD Process N/A : Dry Scrubber FGD Process N/A : Dry Scrubber FGD Process N/A : Dry Scrubber FGD Process

0.133 N/A : Dry Scrubber FGD Process N/A : Dry Scrubber FGD Process N/A : Dry Scrubber FGD Process N/A : Dry Scrubber FGD Process

0.147 N/A : Dry Scrubber FGD Process N/A : Dry Scrubber FGD Process N/A : Dry Scrubber FGD Process N/A : Dry Scrubber FGD Process
EIA Facility Code Facility Name Boiler ID

2917 Hamilton 9

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
NOT APPLICABLE

ta 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 (acfm) 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

2917 Hamilton 9

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
NOT APPLICABLE

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 (acfm) 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

2917 Hamilton 9

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
NOT APPLICABLE

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 (acfm) 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)