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

997 Michigan City 12
EIA Facility Code Facility Name Boiler ID

997 Michigan City 12

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

Date 

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

03/01/10 Day 1

03/02/10 Day 2

03/03/10 Day 3

03/04/10 Day 4

03/05/10 Day 5

03/06/10 Day 6

03/07/10 Day 7

03/08/10 Day 8

03/09/10 Day 9

03/10/10 Day 10

03/11/10 Day 11

03/12/10 Day 12

03/13/10 Day 13

03/14/10 Day 14

03/15/10 Day 15

03/16/10 Day 16

03/17/10 Day 17

03/18/10 Day 18

03/19/10 Day 19

03/20/10 Day 20

03/21/10 Day 21

03/22/10 Day 22

03/23/10 Day 23

03/24/10 Day 24

03/25/10 Day 25

03/26/10 Day 26

03/27/10 Day 27

03/28/10 Day 28

03/29/10 Day 29

03/30/10 Day 30

03/31/10 Day 31
 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)

4100

4300

4300

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

3200
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

997 Michigan City 12

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

997 Michigan City 12

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

997 Michigan City 12

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

Date 

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

3/1/2010 Day 1 375.7

3/2/2010 Day 2 384.8

3/3/2010 Day 3 387.4

3/4/2010 Day 4 392.0

3/5/2010 Day 5 381.8

3/6/2010 Day 6 324.0

3/7/2010 Day 7 296.5

3/8/2010 Day 8 339.8

3/9/2010 Day 9 355.8

3/10/2010 Day 10 356.6

3/11/2010 Day 11 363.0

3/12/2010 Day 12 362.3

3/13/2010 Day 13 354.2

3/14/2010 Day 14 359.4

3/15/2010 Day 15 376.6

3/16/2010 Day 16 352.9

3/17/2010 Day 17 358.1

3/18/2010 Day 18 344.9

3/19/2010 Day 19 344.0

3/20/2010 Day 20 346.2

3/21/2010 Day 21 335.8

3/22/2010 Day 22 356.8

3/23/2010 Day 23 347.9

3/24/2010 Day 24 357.0

3/25/2010 Day 25 353.2

3/26/2010 Day 26 341.5

3/27/2010 Day 27 318.6

3/28/2010 Day 28 294.0

3/29/2010 Day 29 362.7

3/30/2010 Day 30 384.0
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)

4,179.967

4,307.879

4,293.279

4,311.567

4,139.454

3,566.958

3,243.575

3,721.333

3,900.633

3,903.592

3,960.833

3,889.117

3,755.917

3,771.496

3,969.971

3,759.971

3,837.025

3,716.992

3,772.646

3,785.213

3,647.671

3,900.921

3,783.896

3,898.854

3,853.292

3,694.667

3,477.650

3,191.783

3,969.921

4,168.771
Steam Output (1,000 lbs steam/hr) Flue Gas Flow Rate( SCFH) Flue Gas Pressure (atm)

3319.41 62,501,614.429

3432.07 64,361,934.321

3440.24 63,861,979.333

3456.26 64,003,128.804

3325.18 61,841,147.396

2869.66 55,191,245.417

2589.42 52,537,187.133

2997.47 57,774,470.208

3134.88 59,909,533.013

3128.31 60,479,197.463

3188.86 60,931,185.488

3103.80 60,037,604.546

3006.98 58,748,120.350

3043.62 58,543,950.604

3186.84 61,023,804.454

3032.52 58,289,506.233

3080.89 58,898,668.179

2981.41 57,321,656.613

3057.72 57,882,982.713

3053.58 58,473,886.021

2948.45 56,693,591.658

3164.52 59,764,481.958

3067.16 58,198,386.075

3145.82 59,877,623.083

3092.89 60,156,318.438

2970.38 58,085,553.250

2821.97 54,944,332.813

2584.01 52,320,813.079

3184.63 61,720,153.917

3376.91 63,904,433.746
Flue Gas Sampling Point Temperature (Deg F) Flue Gas Oxygen Content (%)

297.713

302.000

304.792

306.558

299.821

277.992

267.392

282.104

299.696

306.458

309.421

299.133

292.133

288.254

296.858

289.900

292.071

292.688

295.292

282.267

277.338

294.150

294.475

300.596

293.333

283.442

280.596

268.217

295.692

315.938
Flue Gas Carbon Dioxide Content (%) Flue Gas Moisture Content (%)

12.221

12.242

12.296

12.321

12.242

11.779

11.263

11.733

11.858

11.758

11.846

11.804

11.646

11.758

11.858

11.771

11.875

11.825

11.888

11.792

11.725

11.900

11.854

11.875

11.679

11.596

11.542

11.142

11.729

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

426.75 453.04

441.26 467.82

442.27 468.64

443.88 470.51

429.32 455.58

366.71 391.42

328.06 351.89

382.23 408.08

399.73 425.45

398.02 424.02

405.88 431.88

398.63 424.19

387.57 412.38

393.52 417.94

408.26 434.05

389.81 414.79

394.91 420.44

380.98 406.28

391.29 416.63

392.15 417.51

378.73 402.93

404.79 430.02

393.94 418.83

402.41 428.27

395.78 421.75

381.40 407.10

361.38 385.12

329.13 352.09

407.89 433.43

432.50 458.16
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)