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

1943 Hoot Lake 2
EIA Facility Code Facility Name Boiler ID

1943 Hoot Lake 2

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

Date 

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

05/01/10 Day 1 0.0200

05/02/10 Day 2 0.0207

05/03/10 Day 3 0.0263

05/04/10 Day 4 0.0235

05/05/10 Day 5 0.0195

05/06/10 Day 6 0.0267

05/07/10 Day 7 0.0253

05/08/10 Day 8 0.0259

05/09/10 Day 9 0.0225

05/10/10 Day 10 0.0211

05/11/10 Day 11 0.0260

05/12/10 Day 12 0.0271

05/13/10 Day 13 0.0278

05/14/10 Day 14 0.0253

05/15/10 Day 15 0.0226

05/16/10 Day 16 0.0195

05/17/10 Day 17 0.0256

05/18/10 Day 18 0.0250

05/19/10 Day 19 0.0250

05/20/10 Day 20 0.0239

05/21/10 Day 21 0.0241

05/22/10 Day 22 0.0191

05/23/10 Day 23 0.0210

05/24/10 Day 24 0.0240

05/25/10 Day 25 0.0247

05/26/10 Day 26 0.0257

05/27/10 Day 27 0.0254

05/28/10 Day 28 0.0231

05/29/10 Day 29 0.0197

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

440.6

458.6

553.4

501.1

420.6

563.4

541.2

524.9

457.6

469.8

554.3

580.7

570.1

585.2

550.9

469.7

608.5

624.9

625.1

603.0

610.6

521.8

566.7

616.1

609.8

612.7

576.3

518.8

483.1

428.6
Steam Output (1,000 lbs steam/hr) Flue Gas Flow Rate (wet scfm) Flue Gas Pressure (atm)

254.1 126,968.2 0.9248

260.4 129,758.9 0.9324

333.4 149,826.2 0.9401

294.7 138,619.0 0.9359

240.5 118,390.6 0.9395

341.6 151,419.2 0.9517

331.7 147,109.8 0.9475

304.8 143,057.6 0.9575

267.1 126,327.6 0.9586

276.7 130,008.0 0.9523

343.0 148,939.8 0.9522

337.5 150,446.4 0.9544

328.9 149,203.3 0.9462

334.5 147,274.3 0.9527

308.5 138,785.8 0.9564

252.1 120,840.4 0.9559

352.6 151,751.7 0.9551

363.8 154,324.6 0.9515

365.5 156,564.2 0.9505

359.6 152,316.6 0.9498

353.2 153,335.1 0.9466

290.6 137,137.6 0.9383

324.2 145,888.6 0.9413

358.2 155,539.6 0.9428

360.5 154,027.0 0.9491

365.0 152,352.6 0.9557

352.7 148,835.0 0.9542

320.4 139,184.0 0.9489

294.7 130,149.9 0.9431

256.6 118,186.5 0.9450
Flue Gas Sampling Point Temperature (Deg F)

Flue Gas Oxygen Content (%) 

(Boiler Excess Oxygen - Not 

Stack Exit)

294.1 3.3

295.3 3.3

324.5 3.3

312.0 3.3

301.7 3.3

322.7 3.3

326.1 3.3

322.2 3.3

309.5 3.3

302.8 3.3

319.1 3.3

329.3 3.3

330.4 3.3

329.2 3.3

326.1 3.3

304.8 3.3

340.1 3.3

339.4 3.3

338.7 3.3

333.5 3.3

330.4 3.3

313.4 3.3

336.9 3.3

342.9 3.3

346.8 3.3

337.6 3.3

345.2 3.3

334.8 3.3

319.7 3.3

296.7 3.3
Flue Gas Carbon Dioxide Content (%) Flue Gas Moisture Content (%)

10.6

10.8

11.3

11.1

10.9

11.4

11.3

11.2

11.1

11.1

11.4

11.8

11.7

12.1

12.1

11.9

12.3

12.4

12.2

12.1

12.2

11.6

11.9

12.1

12.1

12.3

11.9

11.4

11.3

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

34 35 1

34 36 1

43 45 1

39 40 1

32 33 1

44 46 1

43 45 1

40 42 1

35 36 1

36 38 1

44 47 1

44 46 1

43 45 1

43 45 1

40 42 1

33 35 1

46 48 1

47 49 1

47 50 1

46 48 1

46 48 1

38 40 1

42 44 1

46 48 1

47 49 1

47 49 1

45 47 1

41 43 1

38 40 1

33 35 1
Standard Temperature (Deg F) Pressure Drop across FGD (in H2O)

68

68

68

68

68

68

68

68

68

68

68

68

68

68

68

68

68

68

68

68

68

68

68

68

68

68

68

68

68

68
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

1943 Hoot Lake 2

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

Date 

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

05/01/10 Day 1 0.0200

05/02/10 Day 2 0.0207

05/03/10 Day 3 0.0263

05/04/10 Day 4 0.0235

05/05/10 Day 5 0.0195

05/06/10 Day 6 0.0267

05/07/10 Day 7 0.0253

05/08/10 Day 8 0.0259

05/09/10 Day 9 0.0225

05/10/10 Day 10 0.0211

05/11/10 Day 11 0.0260

05/12/10 Day 12 0.0271

05/13/10 Day 13 0.0278

05/14/10 Day 14 0.0253

05/15/10 Day 15 0.0226

05/16/10 Day 16 0.0195

05/17/10 Day 17 0.0256

05/18/10 Day 18 0.0250

05/19/10 Day 19 0.0250

05/20/10 Day 20 0.0239

05/21/10 Day 21 0.0241

05/22/10 Day 22 0.0191

05/23/10 Day 23 0.0210

05/24/10 Day 24 0.0240

05/25/10 Day 25 0.0247

05/26/10 Day 26 0.0257

05/27/10 Day 27 0.0254

05/28/10 Day 28 0.0231

05/29/10 Day 29 0.0197

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

440.6

458.6

553.4

501.1

420.6

563.4

541.2

524.9

457.6

469.8

554.3

580.7

570.1

585.2

550.9

469.7

608.5

624.9

625.1

603.0

610.6

521.8

566.7

616.1

609.8

612.7

576.3

518.8

483.1

428.6
Steam Output (1,000 lbs steam/hr) Flue Gas Flow Rate (wet scfm) Flue Gas Pressure (atm)

254.1 126968.2 0.9248

260.4 129758.9 0.9324

333.4 149826.2 0.9401

294.7 138619.0 0.9359

240.5 118390.6 0.9395

341.6 151419.2 0.9517

331.7 147109.8 0.9475

304.8 143057.6 0.9575

267.1 126327.6 0.9586

276.7 130008.0 0.9523

343.0 148939.8 0.9522

337.5 150446.4 0.9544

328.9 149203.3 0.9462

334.5 147274.3 0.9527

308.5 138785.8 0.9564

252.1 120840.4 0.9559

352.6 151751.7 0.9551

363.8 154324.6 0.9515

365.5 156564.2 0.9505

359.6 152316.6 0.9498

353.2 153335.1 0.9466

290.6 137137.6 0.9383

324.2 145888.6 0.9413

358.2 155539.6 0.9428

360.5 154027.0 0.9491

365.0 152352.6 0.9557

352.7 148835.0 0.9542

320.4 139184.0 0.9489

294.7 130149.9 0.9431

256.6 118186.5 0.9450
Flue Gas Sampling Point Temperature (Deg F)

Flue Gas Oxygen Content (%) 

(Boiler Excess Oxygen - Not 

Stack Exit)

294.1 3.3

295.3 3.3

324.5 3.3

312.0 3.3

301.7 3.3

322.7 3.3

326.1 3.3

322.2 3.3

309.5 3.3

302.8 3.3

319.1 3.3

329.3 3.3

330.4 3.3

329.2 3.3

326.1 3.3

304.8 3.3

340.1 3.3

339.4 3.3

338.7 3.3

333.5 3.3

330.4 3.3

313.4 3.3

336.9 3.3

342.9 3.3

346.8 3.3

337.6 3.3

345.2 3.3

334.8 3.3

319.7 3.3

296.7 3.3
Flue Gas Carbon Dioxide Content (%) Flue Gas Moisture Content (%)

10.6

10.8

11.3

11.1

10.9

11.4

11.3

11.2

11.1

11.1

11.4

11.8

11.7

12.1

12.1

11.9

12.3

12.4

12.2

12.1

12.2

11.6

11.9

12.1

12.1

12.3

11.9

11.4

11.3

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

34 35 1

34 36 1

43 45 1

39 40 1

32 33 1

44 46 1

43 45 1

40 42 1

35 36 1

36 38 1

44 47 1

44 46 1

43 45 1

43 45 1

40 42 1

33 35 1

46 48 1

47 49 1

47 50 1

46 48 1

46 48 1

38 40 1

42 44 1

46 48 1

47 49 1

47 49 1

45 47 1

41 43 1

38 40 1

33 35 1
Standard Temperature (Deg F) Pressure Drop across FGD (in H2O)

68

68

68

68

68

68

68

68

68

68

68

68

68

68

68

68

68

68

68

68

68

68

68

68

68

68

68

68

68

68
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

1943 Hoot Lake 2

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

Date 

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

05/01/10 Day 1 0.0200

05/02/10 Day 2 0.0207

05/03/10 Day 3 0.0263

05/04/10 Day 4 0.0235

05/05/10 Day 5 0.0195

05/06/10 Day 6 0.0267

05/07/10 Day 7 0.0253

05/08/10 Day 8 0.0259

05/09/10 Day 9 0.0225

05/10/10 Day 10 0.0211

05/11/10 Day 11 0.0260

05/12/10 Day 12 0.0271

05/13/10 Day 13 0.0278

05/14/10 Day 14 0.0253

05/15/10 Day 15 0.0226

05/16/10 Day 16 0.0195

05/17/10 Day 17 0.0256

05/18/10 Day 18 0.0250

05/19/10 Day 19 0.0250

05/20/10 Day 20 0.0239

05/21/10 Day 21 0.0241

05/22/10 Day 22 0.0191

05/23/10 Day 23 0.0210

05/24/10 Day 24 0.0240

05/25/10 Day 25 0.0247

05/26/10 Day 26 0.0257

05/27/10 Day 27 0.0254

05/28/10 Day 28 0.0231

05/29/10 Day 29 0.0197

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

440.6

458.6

553.4

501.1

420.6

563.4

541.2

524.9

457.6

469.8

554.3

580.7

570.1

585.2

550.9

469.7

608.5

624.9

625.1

603.0

610.6

521.8

566.7

616.1

609.8

612.7

576.3

518.8

483.1

428.6
Steam Output (1,000 lbs steam/hr) Flue Gas Flow Rate (wet scfm) Flue Gas Pressure (atm)

254.1 126968.2 0.9248

260.4 129758.9 0.9324

333.4 149826.2 0.9401

294.7 138619.0 0.9359

240.5 118390.6 0.9395

341.6 151419.2 0.9517

331.7 147109.8 0.9475

304.8 143057.6 0.9575

267.1 126327.6 0.9586

276.7 130008.0 0.9523

343.0 148939.8 0.9522

337.5 150446.4 0.9544

328.9 149203.3 0.9462

334.5 147274.3 0.9527

308.5 138785.8 0.9564

252.1 120840.4 0.9559

352.6 151751.7 0.9551

363.8 154324.6 0.9515

365.5 156564.2 0.9505

359.6 152316.6 0.9498

353.2 153335.1 0.9466

290.6 137137.6 0.9383

324.2 145888.6 0.9413

358.2 155539.6 0.9428

360.5 154027.0 0.9491

365.0 152352.6 0.9557

352.7 148835.0 0.9542

320.4 139184.0 0.9489

294.7 130149.9 0.9431

256.6 118186.5 0.9450
Flue Gas Sampling Point Temperature (Deg F)

Flue Gas Oxygen Content (%) 

(Boiler Excess Oxygen - Not 

Stack Exit)

294.1 3.3

295.3 3.3

324.5 3.3

312.0 3.3

301.7 3.3

322.7 3.3

326.1 3.3

322.2 3.3

309.5 3.3

302.8 3.3

319.1 3.3

329.3 3.3

330.4 3.3

329.2 3.3

326.1 3.3

304.8 3.3

340.1 3.3

339.4 3.3

338.7 3.3

333.5 3.3

330.4 3.3

313.4 3.3

336.9 3.3

342.9 3.3

346.8 3.3

337.6 3.3

345.2 3.3

334.8 3.3

319.7 3.3

296.7 3.3
Flue Gas Carbon Dioxide Content (%) Flue Gas Moisture Content (%)

10.6

10.8

11.3

11.1

10.9

11.4

11.3

11.2

11.1

11.1

11.4

11.8

11.7

12.1

12.1

11.9

12.3

12.4

12.2

12.1

12.2

11.6

11.9

12.1

12.1

12.3

11.9

11.4

11.3

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

34 35 1

34 36 1

43 45 1

39 40 1

32 33 1

44 46 1

43 45 1

40 42 1

35 36 1

36 38 1

44 47 1

44 46 1

43 45 1

43 45 1

40 42 1

33 35 1

46 48 1

47 49 1

47 50 1

46 48 1

46 48 1

38 40 1

42 44 1

46 48 1

47 49 1

47 49 1

45 47 1

41 43 1

38 40 1

33 35 1
Standard Temperature (Deg F) Pressure Drop across FGD (in H2O)

68

68

68

68

68

68

68

68

68

68

68

68

68

68

68

68

68

68

68

68

68

68

68

68

68

68

68

68

68

68
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

1943 Hoot Lake 2

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

Date 

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

05/01/10 Day 1 0.0200

05/02/10 Day 2 0.0207

05/03/10 Day 3 0.0263

05/04/10 Day 4 0.0235

05/05/10 Day 5 0.0195

05/06/10 Day 6 0.0267

05/07/10 Day 7 0.0253

05/08/10 Day 8 0.0259

05/09/10 Day 9 0.0225

05/10/10 Day 10 0.0211

05/11/10 Day 11 0.0260

05/12/10 Day 12 0.0271

05/13/10 Day 13 0.0278

05/14/10 Day 14 0.0253

05/15/10 Day 15 0.0226

05/16/10 Day 16 0.0195

05/17/10 Day 17 0.0256

05/18/10 Day 18 0.0250

05/19/10 Day 19 0.0250

05/20/10 Day 20 0.0239

05/21/10 Day 21 0.0241

05/22/10 Day 22 0.0191

05/23/10 Day 23 0.0210

05/24/10 Day 24 0.0240

05/25/10 Day 25 0.0247

05/26/10 Day 26 0.0257

05/27/10 Day 27 0.0254

05/28/10 Day 28 0.0231

05/29/10 Day 29 0.0197

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

440.6

458.6

553.4

501.1

420.6

563.4

541.2

524.9

457.6

469.8

554.3

580.7

570.1

585.2

550.9

469.7

608.5

624.9

625.1

603.0

610.6

521.8

566.7

616.1

609.8

612.7

576.3

518.8

483.1

428.6
Steam Output (1,000 lbs steam/hr) Flue Gas Flow Rate (wet scfm) Flue Gas Pressure (atm)

254.1 126968.2 0.9248

260.4 129758.9 0.9324

333.4 149826.2 0.9401

294.7 138619.0 0.9359

240.5 118390.6 0.9395

341.6 151419.2 0.9517

331.7 147109.8 0.9475

304.8 143057.6 0.9575

267.1 126327.6 0.9586

276.7 130008.0 0.9523

343.0 148939.8 0.9522

337.5 150446.4 0.9544

328.9 149203.3 0.9462

334.5 147274.3 0.9527

308.5 138785.8 0.9564

252.1 120840.4 0.9559

352.6 151751.7 0.9551

363.8 154324.6 0.9515

365.5 156564.2 0.9505

359.6 152316.6 0.9498

353.2 153335.1 0.9466

290.6 137137.6 0.9383

324.2 145888.6 0.9413

358.2 155539.6 0.9428

360.5 154027.0 0.9491

365.0 152352.6 0.9557

352.7 148835.0 0.9542

320.4 139184.0 0.9489

294.7 130149.9 0.9431

256.6 118186.5 0.9450
Flue Gas Sampling Point Temperature (Deg F)

Flue Gas Oxygen Content (%) 

(Boiler Excess Oxygen - Not 

Stack Exit)

294.1 3.3

295.3 3.3

324.5 3.3

312.0 3.3

301.7 3.3

322.7 3.3

326.1 3.3

322.2 3.3

309.5 3.3

302.8 3.3

319.1 3.3

329.3 3.3

330.4 3.3

329.2 3.3

326.1 3.3

304.8 3.3

340.1 3.3

339.4 3.3

338.7 3.3

333.5 3.3

330.4 3.3

313.4 3.3

336.9 3.3

342.9 3.3

346.8 3.3

337.6 3.3

345.2 3.3

334.8 3.3

319.7 3.3

296.7 3.3
Flue Gas Carbon Dioxide Content (%) Flue Gas Moisture Content (%)

10.6

10.8

11.3

11.1

10.9

11.4

11.3

11.2

11.1

11.1

11.4

11.8

11.7

12.1

12.1

11.9

12.3

12.4

12.2

12.1

12.2

11.6

11.9

12.1

12.1

12.3

11.9

11.4

11.3

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

34 35 1

34 36 1

43 45 1

39 40 1

32 33 1

44 46 1

43 45 1

40 42 1

35 36 1

36 38 1

44 47 1

44 46 1

43 45 1

43 45 1

40 42 1

33 35 1

46 48 1

47 49 1

47 50 1

46 48 1

46 48 1

38 40 1

42 44 1

46 48 1

47 49 1

47 49 1

45 47 1

41 43 1

38 40 1

33 35 1
Standard Temperature (Deg F) Pressure Drop across FGD (in H2O)

68

68

68

68

68

68

68

68

68

68

68

68

68

68

68

68

68

68

68

68

68

68

68

68

68

68

68

68

68

68
FGD Scrubber Liquor Flow Rate (gals/min) FGD Scrubber Liquor pH (pH) Sorbent Type
Sorbent Injection Rate (lb/hr)