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

capability to store these daily averages. This spreadsheet included 4 separate surrogate worksheets, in case the b

tested for all surrogates at 4 different dates. This spreadsheet is intended to be used for one boiler of one facilit

multiple boilers should be handled by using separate copies of this spreadsheet. Fields shaded in yellow are re

applicable to your boilers' operation). You do not need to populate cells shaded in gray, as they are automatically 

the Boiler Information worksheet. Please Do Not modify the structure of this spreadsheet by adding or subtract

columns, cells. Please name each resulting spreadsheet with the following naming 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 worksheet

Process Data Worksheets

Please use one process data worksheet for each HAP surrogate even is simultaneous testing of different HAP surr
data required by the ICR. The ERT does not have the 

surrogate worksheets, in case the boiler tested is 

be used for one boiler of one facility. Data for 

Fields shaded in yellow are required (if 

ed in gray, as they are automatically populated from 

s spreadsheet by adding or subtracting rows, 

ming convention: 

n the Boiler Information worksheet. 

aneous testing of different HAP surrogates was done. 
EIA Facility Code Facility Name Boiler ID

1073 Prairie Creek 4
EIA Facility Code Facility Name Boiler ID

1073 Prairie Creek 4

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

Date 

(MM/DD/YY) 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
 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

1073 Prairie Creek 4

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

Date 

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

04/06/10 Day 1 0.0686

04/07/10 Day 2 0.0670

04/08/10 Day 3 0.0730

04/09/10 Day 4 0.0719

04/10/10 Day 5 0.0693

04/11/10 Day 6 0.0644

04/12/10 Day 7 0.0677

04/13/10 Day 8 0.0655

04/14/10 Day 9 0.0679

04/15/10 Day 10 0.0673

04/16/10 Day 11 0.0669

04/17/10 Day 12 0.0715

04/18/10 Day 13 0.0739

04/19/10 Day 14 0.0725

04/20/10 Day 15 0.0706

04/21/10 Day 16 0.0485

04/22/10 Day 17 0.0557

04/23/10 Day 18 0.0616

04/24/10 Day 19 0.0683

04/25/10 Day 20 0.0718

04/26/10 Day 21 0.0749

04/27/10 Day 22 0.0713

04/28/10 Day 23 0.0690

04/29/10 Day 24 0.0663

04/30/10 Day 25 0.0634

05/01/10 Day 26 0.0693

05/02/10 Day 27 0.0604

05/03/10 Day 28 0.0735

05/04/10 Day 29 0.0736

05/05/10 Day 30 0.0661
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)

0 0

0 0

0 0

0 0

0 0

0 0

0 0

0 0

0 0

0 0

0 0

0 0

0 0

0 0

0 0

0 0

0 0

0 0

0 0

0 0

0 0

0 0

0 0

0 0

0 0

0 0

0 0

0 0

0 0

0 0
Coal Gas Firing Rate (ft^3/min) Fuel oil Firing Rate (Gal/hr) Average Heat Input (MMBtu/hr)

0 0 1194.16

0 0 1147.06

0 0 1251.52

0 0 1275.63

0 0 1143.43

0 0 1082.08

0 0 1128.93

0 0 1100.78

0 0 1205.42

0 0 1160.03

0 0 1194.54

0 0 1250.84

0 0 1257.71

0 0 1244.91

0 0 1008.01

0 0 1046.21

0 0 977.05

0 0 1068.03

0 0 1182.64

0 0 1202.75

0 0 1180.60

0 0 1189.89

0 0 1163.18

0 0 1117.34

0 0 1039.42

0 0 1126.88

0 0 1136.34

0 0 1190.60

0 0 1230.57

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

775.25 NA NA

723.85 NA NA

792.14 NA NA

819.67 NA NA

747.64 NA NA

706.75 NA NA

726.97 NA NA

709.36 NA NA

783.77 NA NA

758.18 NA NA

761.72 NA NA

788.60 NA NA

799.02 NA NA

793.93 NA NA

637.01 NA NA

665.91 NA NA

622.47 NA NA

682.31 NA NA

776.43 NA NA

772.19 NA NA

763.61 NA NA

765.58 NA NA

749.76 NA NA

723.02 NA NA

684.90 NA NA

729.42 NA NA

724.88 NA NA

757.71 NA NA

790.82 NA NA

757.07 NA NA
Flue Gas Sampling Point Temperature (Deg F) Flue Gas Oxygen Content (%)

330.2 2.91

304.6 3.10

310.2 2.47

323.6 2.26

315.4 2.24

308.2 2.19

320.3 3.30

328.7 3.46

348.6 2.66

332.1 2.77

317.8 2.99

317.3 3.01

327.2 2.86

319.0 2.71

304.4 4.68

309.0 4.41

297.9 4.40

305.9 3.89

327.2 3.01

320.4 3.17

320.6 3.26

315.5 3.07

314.3 3.15

325.5 3.51

316.0 3.55

315.5 3.06

313.8 3.06

316.8 3.03

331.3 2.71

315.8 2.59
Flue Gas Carbon Dioxide Content (%) Flue Gas Moisture Content (%)

11.4 NA

11.0 NA

11.4 NA

11.6 NA

11.7 NA

11.6 NA

11.1 NA

11.0 NA

11.5 NA

11.5 NA

11.3 NA

11.3 NA

11.5 NA

11.5 NA

10.2 NA

10.3 NA

10.3 NA

10.5 NA

10.9 NA

10.7 NA

10.8 NA

11.0 NA

11.0 NA

10.8 NA

10.6 NA

11.0 NA

11.0 NA

11.2 NA

11.4 NA

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

102.47 111.23 1.00

95.42 103.76 1.00

105.05 113.70 1.00

108.90 117.60 1.00

98.77 106.94 1.00

92.60 100.57 1.00

95.91 104.15 1.00

90.25 98.39 1.00

99.75 108.19 1.00

102.41 110.70 1.00

105.05 113.43 1.00

107.04 115.61 1.00

112.01 120.58 1.00

101.97 110.40 1.00

78.82 86.91 1.00

89.99 94.37 1.00

84.40 90.17 1.00

96.30 100.51 1.00

102.17 108.59 1.00

102.73 109.21 1.00

103.17 110.33 1.00

99.50 105.21 1.00

100.51 104.88 1.00

94.35 98.43 1.00

87.53 93.56 1.00

94.37 100.45 1.00

88.52 96.70 1.00

98.43 104.41 1.00

104.65 110.65 1.00

97.23 104.31 1.00
Standard Temperature (Deg F) Pressure Drop across FGD (in H2O)

68.00 NA

68.00 NA

68.00 NA

68.00 NA

68.00 NA

68.00 NA

68.00 NA

68.00 NA

68.00 NA

68.00 NA

68.00 NA

68.00 NA

68.00 NA

68.00 NA

68.00 NA

68.00 NA

68.00 NA

68.00 NA

68.00 NA

68.00 NA

68.00 NA

68.00 NA

68.00 NA

68.00 NA

68.00 NA

68.00 NA

68.00 NA

68.00 NA

68.00 NA

68.00 NA
FGD Scrubber Liquor Flow Rate (gals/min) FGD Scrubber Liquor pH (pH) Sorbent Type

NA NA NA

NA NA NA

NA NA NA

NA NA NA

NA NA NA

NA NA NA

NA NA NA

NA NA NA

NA NA NA

NA NA NA

NA NA NA

NA NA NA

NA NA NA

NA NA NA

NA NA NA

NA NA NA

NA NA NA

NA NA NA

NA NA NA

NA NA NA

NA NA NA

NA NA NA

NA NA NA

NA NA NA

NA NA NA

NA NA NA

NA NA NA

NA NA NA

NA NA NA

NA NA NA
Sorbent Injection Rate (lb/hr)

NA

NA

NA

NA

NA

NA

NA

NA

NA

NA

NA

NA

NA

NA

NA

NA

NA

NA

NA

NA

NA

NA

NA

NA

NA

NA

NA

NA

NA

NA
EIA Facility Code Facility Name Boiler ID

1073 Prairie Creek 4

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

1073 Prairie Creek 4

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)