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

1167 Muscatine Power and Water8
EIA Facility Code Facility Name Boiler ID

1167 Muscatine Power and Water 8

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

1167 Muscatine Power and Water 8

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

1167 Muscatine Power and Water 8

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

1167 Muscatine Power and Water 8

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 7/1/2010 28.27 Tons/hr. not applicable

Day 2 7/2/2010 29.75 Tons/hr. not applicable

Day 3 7/3/2010 30.66 Tons/hr. not applicable

Day 4 7/4/2010 31.69 Tons/hr. not applicable

Day 5 7/5/2010 32.06 Tons/hr. not applicable

Day 6 7/6/2010 31.97 Tons/hr. not applicable

Day 7 7/7/2010 32.14 Tons/hr. not applicable

Day 8 7/8/2010 32.40 Tons/hr. not applicable

Day 9 7/9/2010 31.57 Tons/hr. not applicable

Day 10 7/10/2010 31.49 Tons/hr. not applicable

Day 11 7/11/2010 32.04 Tons/hr. not applicable

Day 12 7/12/2010 44.28 Tons/hr. not applicable

Day 13 7/13/2010 48.51 Tons/hr. not applicable

Day 14 7/14/2010 48.85 Tons/hr. not applicable

Day 15 7/15/2010 46.81 Tons/hr. not applicable

Day 16 7/16/2010 47.51 Tons/hr. not applicable

Day 17 7/17/2010 46.31 Tons/hr. not applicable

Day 18 7/18/2010 45.54 Tons/hr. not applicable

Day 19 7/19/2010 47.74 Tons/hr. not applicable

Day 20 7/20/2010 46.94 Tons/hr. not applicable

Day 21 7/21/2010 46.78 Tons/hr. not applicable

Day 22 7/22/2010 47.03 Tons/hr. not applicable

Day 23 7/23/2010 48.88 Tons/hr. not applicable

Day 24 7/24/2010 49.94 Tons/hr. not applicable

Day 25 7/25/2010 48.23 Tons/hr. not applicable

Day 26 7/26/2010 48.76 Tons/hr. not applicable

Day 27 7/27/2010 49.62 Tons/hr. not applicable

Day 28 7/28/2010 49.81 Tons/hr. not applicable

Day 29 7/29/2010 48.76 Tons/hr. not applicable

Day 30 7/30/2010 43.55 Tons/hr. not applicable

Note: Unit 8 Boiler was originally constructed to provide steam only to a 75 MWe nameplate turbine generator. Subsequently m

made such that the boiler could serve a combination of two turbine generators (the original T/G and a new small non condensin

provide steam to an offsite customer. However, steam output of the boiler remained the same. Unit 8 is required to have a Con

Emissions Monitoring System (CEMS) that meets Part 75 criteria. One of the criteria is Relative Accuracy Test Audit (RATA) te

conditions at which testing is performed is based on historical megawatt output. Since some steam output does not generate m

equivalent method must be used to represent true boiler operation. The CEMS Data Acquisition and Handling System (DAHS) 

equivalent megawatt output. This value represents gross megawatts produced. Net megawatts are determined by subtracting 

from the gross number.
he Testing Date

Synfuel Firing Rate (units) Pet Coke Firing Rate Pet Coke Firing Rate (units) Coal Gas Firing Rate

not applicable not applicable not applicable not applicable

not applicable not applicable not applicable not applicable

not applicable not applicable not applicable not applicable

not applicable not applicable not applicable not applicable

not applicable not applicable not applicable not applicable

not applicable not applicable not applicable not applicable

not applicable not applicable not applicable not applicable

not applicable not applicable not applicable not applicable

not applicable not applicable not applicable not applicable

not applicable not applicable not applicable not applicable

not applicable not applicable not applicable not applicable

not applicable not applicable not applicable not applicable

not applicable not applicable not applicable not applicable

not applicable not applicable not applicable not applicable

not applicable not applicable not applicable not applicable

not applicable not applicable not applicable not applicable

not applicable not applicable not applicable not applicable

not applicable not applicable not applicable not applicable

not applicable not applicable not applicable not applicable

not applicable not applicable not applicable not applicable

not applicable not applicable not applicable not applicable

not applicable not applicable not applicable not applicable

not applicable not applicable not applicable not applicable

not applicable not applicable not applicable not applicable

not applicable not applicable not applicable not applicable

not applicable not applicable not applicable not applicable

not applicable not applicable not applicable not applicable

not applicable not applicable not applicable not applicable

not applicable not applicable not applicable not applicable

not applicable not applicable not applicable not applicable

enerator. Subsequently modifications were 

new small non condensing T/G) and 

 is required to have a Continuous 

racy Test Audit (RATA) testing. Load 

utput does not generate megawatts, an 

Handling System (DAHS) calculates an 

etermined by subtracting "house power" 
Coal Gas Firing Rate (units) Fuel oil Firing Rate Fuel oil Firing Rate (units)

not applicable not applicable not applicable

not applicable not applicable not applicable

not applicable not applicable not applicable

not applicable not applicable not applicable

not applicable not applicable not applicable

not applicable not applicable not applicable

not applicable not applicable not applicable

not applicable not applicable not applicable

not applicable not applicable not applicable

not applicable not applicable not applicable

not applicable not applicable not applicable

not applicable not applicable not applicable

not applicable not applicable not applicable

not applicable not applicable not applicable

not applicable not applicable not applicable

not applicable not applicable not applicable

not applicable not applicable not applicable

not applicable not applicable not applicable

not applicable not applicable not applicable

not applicable not applicable not applicable

not applicable not applicable not applicable

not applicable not applicable not applicable

not applicable not applicable not applicable

not applicable not applicable not applicable

not applicable not applicable not applicable

not applicable not applicable not applicable

not applicable not applicable not applicable

not applicable not applicable not applicable

not applicable not applicable not applicable

not applicable not applicable not applicable
Average Heat Input (MMBtu/hr) Steam Output (1,000 lbs steam/hr)

468.68 360,412.0

494.68 379,029.7

515.17 391,506.3

544.09 399,158.2

543.49 398,925.6

531.71 390,232.9

532.17 397,396.4

497.58 401,275.5

521.69 395,381.6

527.13 397,179.1

531.55 402,043.7

737.00 550,973.2

797.32 597,057.3

817.84 600,871.2

772.74 578,531.5

795.70 592,848.2

780.18 587,102.8

780.54 577,469.8

803.04 600,294.2

760.81 594,809.9

794.32 584,032.4

798.50 585,788.1

811.43 597,791.1

830.83 601,497.2

791.33 591,246.1

812.29 595,246.1

815.64 609,247.1

817.23 611,852.7

837.42 594,600.1

717.50 543,300.2
Unit Net Electric Generation (MWh) Unit Gross Electric Generation (MWe)

39.47 43.00

42.68 46.00

44.85 48.00

44.81 48.00

44.75 48.00

43.77 47.00

44.69 48.00

45.80 49.00

44.81 48.00

44.88 48.00

45.76 49.00

63.93 68.00

68.55 73.00

68.67 73.00

66.71 71.00

67.72 72.00

67.86 72.00

65.86 70.00

68.59 73.00

66.64 71.00

66.84 71.00

66.82 71.00

68.69 73.00

69.59 74.00

67.78 72.00

68.77 73.00

70.76 75.00

70.74 75.00

68.77 73.00

58.77 63.00
Control Device Operating Parameters, As Applicable

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

not available not applicable

not available not applicable

not available not applicable

not available not applicable

not available not applicable

not available not applicable

not available not applicable

not available not applicable

not available not applicable

not available not applicable

not available not applicable

not available not applicable

not available not applicable

not available not applicable

not available not applicable

not available not applicable

not available not applicable

not available not applicable

not available not applicable

not available not applicable

not available not applicable

not available not applicable

not available not applicable

not available not applicable

not available not applicable

not available not applicable

not available not applicable

not available not applicable

not available not applicable

not available not applicable
FGD Scrubber Liquor Flow Rate (gals/min) Sorbent Type Sorbent Injection Rate (lb/hr)

not applicable none not applicable

not applicable none not applicable

not applicable none not applicable

not applicable none not applicable

not applicable none not applicable

not applicable none not applicable

not applicable none not applicable

not applicable none not applicable

not applicable none not applicable

not applicable none not applicable

not applicable none not applicable

not applicable none not applicable

not applicable none not applicable

not applicable none not applicable

not applicable none not applicable

not applicable none not applicable

not applicable none not applicable

not applicable none not applicable

not applicable none not applicable

not applicable none not applicable

not applicable none not applicable

not applicable none not applicable

not applicable none not applicable

not applicable none not applicable

not applicable none not applicable

not applicable none not applicable

not applicable none not applicable

not applicable none not applicable

not applicable none not applicable

not applicable none not applicable
Other Boiler or Control Device Operating Parameters (e.g., Boiler O2) 

Flue Gas Pressure (atm) Flue Gas Sampling Point Temperature (Deg F)

not available 348.9

not available 351.5

not available 353.1

not available 358.2

not available 360.5

not available 361.2

not available 360.8

not available 360.3

not available 357.1

not available 358.6

not available 359.0

not available 370.7

not available 383.1

not available 387.4

not available 377.8

not available 376.7

not available 382.4

not available 381.2

not available 380.5

not available 380.3

not available 383.7

not available 380.0

not available 381.2

not available 379.7

not available 378.8

not available 379.0

not available 379.6

not available 380.3

not available 377.3

not available 371.6
Flue Gas Oxygen Content (%) Flue Gas Carbon Dioxide Content (%) Flue Gas Moisture Content (%)

not available 13.0 not available

not available 12.8 not available

not available 13.0 not available

not available 12.9 not available

not available 12.8 not available

not available 12.7 not available

not available 13.0 not available

not available 13.1 not available

not available 13.1 not available

not available 13.2 not available

not available 13.1 not available

not available 13.8 not available

not available 13.7 not available

not available 13.7 not available

not available 13.8 not available

not available 14.0 not available

not available 13.9 not available

not available 13.9 not available

not available 14.0 not available

not available 13.8 not available

not available 14.1 not available

not available 14.0 not available

not available 13.8 not available

not available 13.8 not available

not available 14.0 not available

not available 13.9 not available

not available 14.0 not available

not available 14.0 not available

not available 13.9 not available

not available 13.7 not available