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

4125 Manitowoc 9
EIA Facility Code Facility Name Boiler ID

4125 Manitowoc 9

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.002429858

05/02/10 Day 2 0.002300053

05/03/10 Day 3 0.002981507

05/04/10 Day 4 0.002399206

05/05/10 Day 5 0.002230422

05/06/10 Day 6 0.003246027

05/07/10 Day 7 0.002718421

05/08/10 Day 8 0.002510583

05/09/10 Day 9 0.002413964

05/10/10 Day 10 0.002527604

05/11/10 Day 11 0.00323823

05/12/10 Day 12 0.003188304

05/13/10 Day 13 0.002718595

05/14/10 Day 14 0.003451749

05/15/10 Day 15 0.002421523

05/16/10 Day 16 0.002199029

05/17/10 Day 17 0.002797349

05/18/10 Day 18 0.002826985

05/19/10 Day 19 0.002872211

05/20/10 Day 20 0.003127565

05/21/10 Day 21 0.00288145

05/22/10 Day 22 0.001903582

05/23/10 Day 23 0.002765472

05/24/10 Day 24 0.003589277

05/25/10 Day 25 0.002883892

05/26/10 Day 26 0.003226634

05/27/10 Day 27 0.002881317

05/28/10 Day 28 0.003037459

05/29/10 Day 29 0.003006043

05/30/10 Day 30 0.003084129
 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.001502045 0.009719431

0.001977506 0.009200212

0.002120109 0.01192603

0.002780907 0.009596824

0.00259495 0.00892169

0.002871658 0.012984107

0.002470625 0.010873683

0.001391919 0.010042332

0.000739411 0.009655855

0.00032477 0.010110418

0.001262414 0.012952919

0.000599167 0.012753217

0.001996755 0.010874379

0.001404591 0.013806994

0.000799093 0.009686092

0.001305876 0.008796116

0.001219444 0.011189395

0.001921324 0.011307941

0.001939799 0.011488844

0.002023839 0.012510262

0.001310565 0.011525798

0.001293214 0.007614329

0.000623994 0.011061888

0.000885302 0.014357108

0.001602288 0.01153557

0.00145104 0.012906535

0.00160258 0.011525269

0.000776582 0.012149834

0.000464454 0.01202417

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

NA NA 349.8917076

NA NA 361.9925896

NA NA 441.0030687

NA NA 407.63507

NA NA 365.7162893

NA NA 500.6655074

NA NA 428.1254319

NA NA 357.685852

NA NA 333.1092926

NA NA 358.2111975

NA NA 462.9975905

NA NA 462.4049827

NA NA 453.1136798

NA NA 501.611884

NA NA 364.3069649

NA NA 360.5798327

NA NA 436.070581

NA NA 453.997204

NA NA 447.1231133

NA NA 492.713607

NA NA 458.1786688

NA NA 318.3115566

NA NA 408.7221313

NA NA 511.7731178

NA NA 436.2139253

NA NA 482.3459493

NA NA 444.3271731

NA NA 456.0695126

NA NA 448.5925168

NA NA 440.9405119
Note units are scfm

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

226.6416745 98874.56947 NA

236.7702862 98481.97215 NA

293.4352596 109349.39 NA

258.0098219 102075.8011 NA

228.6535516 96937.96785 NA

337.8626553 117099.743 NA

280.1239985 105113.6069 NA

223.6371487 94002.57057 NA

210.7891826 87492.53227 NA

225.3954112 90406.04413 NA

308.1001315 109512.1618 NA

290.8573511 107183.1684 NA

281.0841525 104947.856 NA

340.1946725 115570.6312 NA

230.1252157 93241.70966 NA

226.2041639 92799.65185 NA

278.3595195 104454.9483 NA

296.0911725 108944.1039 NA

299.8780435 107764.2055 NA

333.7636219 111954.0619 NA

299.5928267 105078.7 NA

201.7450195 83191.52643 NA

267.4386866 97448.11075 NA

355.4578847 117818.9295 NA

288.5035865 103546.1309 NA

327.8413312 111597.5396 NA

299.7495205 104805.1283 NA

303.2014861 106182.5936 NA

295.4734661 105245.8472 NA

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

352.1468267 NA

345.4595893 NA

345.8689563 NA

340.1920528 NA

343.2929976 NA

339.4101115 NA

333.5042376 NA

335.9196956 NA

335.739064 NA

338.6622756 NA

334.3936985 NA

334.9101317 NA

334.267717 NA

342.5351888 NA

339.3755011 NA

340.7512746 NA

339.2191299 NA

342.3248095 NA

341.8588055 NA

343.9640007 NA

336.5077178 NA

340.1324292 NA

338.6578018 NA

345.6823159 NA

348.1385642 NA

350.9965735 NA

348.7301607 NA

348.3821846 NA

344.0433095 NA

345.4345531 NA
Flue Gas Carbon Dioxide Content (%) Flue Gas Moisture Content (%)

10.81642901 NA

11.22942776 NA

12.22341275 NA

12.15049812 NA

11.52490812 NA

12.923149 NA

12.33662596 NA

11.59711991 NA

11.62818535 NA

12.1011523 NA

12.74989211 NA

13.07292062 NA

13.12217224 NA

13.10718739 NA

11.93475358 NA

11.87251535 NA

12.65038626 NA

12.56479543 NA

12.53508345 NA

13.32154571 NA

13.22393963 NA

11.68446228 NA

12.65033487 NA

13.06655293 NA

12.67127869 NA

13.01501542 NA

12.73706096 NA

12.94160074 NA

12.85406919 NA

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

582 675 28.93410448

612 706 28.92575197

801 903 29.09484884

694 790 29.0577875

594 689 29.05676341

937 1046 29.27714073

764 866 29.01332984

573 668 29.16829179

531 626 29.5262006

576 673 29.55373653

838 940 29.2389165

799 902 29.40010237

777 876 29.19285217

943 1052 29.396391

597 692 29.58136425

584 680 29.5567597

761 862 29.46137046

820 920 29.41444685

825 928 29.41883128

931 1038 29.46040966

823 925 29.27957112

517 610 29.29162663

719 817 29.33266057

983 1092 29.45927952

785 887 29.49892225

904 1009 29.47086712

813 915 29.49321296

812 915 29.46208087

805 906 29.40094151

809 908 29.32526685
Standard Temperature (Deg F) Pressure Drop across FGD (in H2O)

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
FGD Scrubber Liquor Flow Rate (gals/min) FGD Scrubber Liquor pH (pH) Sorbent Type

NA NA Limestone

NA NA Limestone

NA NA Limestone

NA NA Limestone

NA NA Limestone

NA NA Limestone

NA NA Limestone

NA NA Limestone

NA NA Limestone

NA NA Limestone

NA NA Limestone

NA NA Limestone

NA NA Limestone

NA NA Limestone

NA NA Limestone

NA NA Limestone

NA NA Limestone

NA NA Limestone

NA NA Limestone

NA NA Limestone

NA NA Limestone

NA NA Limestone

NA NA Limestone

NA NA Limestone

NA NA Limestone

NA NA Limestone

NA NA Limestone

NA NA Limestone

NA NA Limestone

NA NA Limestone
Sorbent Injection Rate (lb/hr)

5954.958333

6951.833333

8683.916667

8112.791667

6153.375

9864.291667

9729.666667

6743.791667

5812.791667

6642.833333

9508.958333

11464.91667

10587.04167

7484.5

5409.708333

6880.25

8712.416667

8759.875

9160.25

12247.875

11113.125

7027.291667

8577.875

10826.75

9201.375

10905.125

9808.125

10959.25

10774.875

9504.375
EIA Facility Code Facility Name Boiler ID

4125 Manitowoc 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
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

4125 Manitowoc 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
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

4125 Manitowoc 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
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)