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

766 Waiau Power Plant 7
EIA Facility Code Facility Name Boiler ID

766 Waiau Power Plant 7

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 3/29/2010

Day 2 3/30/2010

Day 3 3/31/2010

Day 4 4/1/2010

Day 5 4/2/2010

Day 6 4/3/2010

Day 7 4/4/2010

Day 8 4/5/2010

Day 9 4/6/2010

Day 10 4/7/2010

Day 11 4/8/2010

Day 12 4/9/2010

Day 13 4/10/2010

Day 14 4/11/2010

Day 15 4/12/2010

Day 16 4/13/2010

Day 17 4/14/2010

Day 18 4/15/2010

Day 19 4/16/2010

Day 20 4/17/2010

Day 21 4/18/2010

Day 22 4/19/2010

Day 23 4/20/2010

Day 24 4/21/2010

Day 25 4/22/2010

Day 26 4/23/2010

Day 27 4/24/2010

Day 28 4/25/2010

Day 29 4/26/2010

Day 30 4/27/2010
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)

27.72 Klb/hr

29.42 Klb/hr

29.42 Klb/hr

29.55 Klb/hr

45.16 Klb/hr

29.37 Klb/hr

29.11 Klb/hr

44.8 Klb/hr

44.42 Klb/hr

44.53 Klb/hr

25.53 Klb/hr

26.25 Klb/hr

26.1 Klb/hr

26.36 Klb/hr

25.18 Klb/hr

12.65 Klb/hr

23.62 Klb/hr

26.26 Klb/hr

26.29 Klb/hr

26.23 Klb/hr

26.57 Klb/hr

28.54 Klb/hr

26.25 Klb/hr

21.55 Klb/hr

21.45 Klb/hr

26.66 Klb/hr

21.25 Klb/hr

21.46 Klb/hr

26.58 Klb/hr

26.51 Klb/hr
Average Heat Input (MMBtu/hr) Steam Output (1,000 lbs steam/hr)

522.27 437.32

554.193 464.63

554.099 465.37

556.506 462.88

852.137 695.94

553.275 462.48

548.345 458.78

832.754 696.09

841.748 695.24

843.774 696.85

480.867 401.93

494.561 411.51

491.673 410.33

496.568 411.01

474.135 390.54

238.542 200.41

445.22 368.93

494.904 413.7

495.527 410.45

495.452 409.06

500.865 414.82

538.023 447.62

494.843 407.94

406.306 333.47

404.426 331.88

502.562 418.21

400.748 329.62

404.512 334.68

501.143 417.54

499.873 415.66
Unit Net Electric Generation (MWh) Unit Gross Electric Generation (MWe)

51.11 54.24

54.43 57.71

54.5 57.8

54.39 57.5

82.88 86.75

54.14 57.45

53.73 56.96

82.79 86.65

82.47 86.32

82.94 86.78

45.93 48.88

47.8 50.89

47.64 50.71

47.6 50.71

44.8 47.76

21.68 23.57

42.38 45.4

47.92 51.03

47.79 50.9

47.81 50.89

48.38 51.42

52.02 55.2

47.58 50.76

37.86 40.73

37.67 40.45

48.15 51.32

37.37 40.36

37.8 40.81

47.92 51.09

47.66 50.87
Control Device Operating Parameters, As Appicable

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

Since load varied before and after testing, data is the average for the testing period only

Since load varied before and after testing, data is the average for the testing period only

Since load varied before and after testing, data is the average for the testing period only

Since load varied before and after testing, data is the average for the testing period only (Acid Gas Test Day)
FGD Scrubber Liquor Flow Rate (gals/min) Sorbent Type Sorbent Injection Rate (lb/hr)

riod only (Acid Gas Test Day)
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

766 Waiau Power Plant 7

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 3/29/2010

Day 2 3/30/2010

Day 3 3/31/2010

Day 4 4/1/2010

Day 5 4/2/2010

Day 6 4/3/2010

Day 7 4/4/2010

Day 8 4/5/2010

Day 9 4/6/2010

Day 10 4/7/2010

Day 11 4/8/2010

Day 12 4/9/2010

Day 13 4/10/2010

Day 14 4/11/2010

Day 15 4/12/2010

Day 16 4/13/2010

Day 17 4/14/2010

Day 18 4/15/2010

Day 19 4/16/2010

Day 20 4/17/2010

Day 21 4/18/2010

Day 22 4/19/2010

Day 23 4/20/2010

Day 24 4/21/2010

Day 25 4/22/2010

Day 26 4/23/2010

Day 27 4/24/2010

Day 28 4/25/2010

Day 29 4/26/2010

Day 30 4/27/2010
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)

27.72 Klb/hr

29.42 Klb/hr

29.42 Klb/hr

29.55 Klb/hr

45.16 Klb/hr

29.37 Klb/hr

29.11 Klb/hr

44.8 Klb/hr

44.42 Klb/hr

44.53 Klb/hr

25.53 Klb/hr

26.25 Klb/hr

26.1 Klb/hr

26.36 Klb/hr

25.18 Klb/hr

12.65 Klb/hr

23.62 Klb/hr

26.26 Klb/hr

26.29 Klb/hr

26.23 Klb/hr

26.57 Klb/hr

28.54 Klb/hr

26.25 Klb/hr

21.55 Klb/hr

21.45 Klb/hr

26.66 Klb/hr

21.25 Klb/hr

21.46 Klb/hr

26.58 Klb/hr

26.51 Klb/hr
Average Heat Input (MMBtu/hr) Steam Output (1,000 lbs steam/hr)

522.27 437.32

554.193 464.63

554.099 465.37

556.506 462.88

852.137 695.94

553.275 462.48

548.345 458.78

832.754 696.09

841.748 695.24

843.774 696.85

480.867 401.93

494.561 411.51

491.673 410.33

496.568 411.01

474.135 390.54

238.542 200.41

445.22 368.93

494.904 413.7

495.527 410.45

495.452 409.06

500.865 414.82

538.023 447.62

494.843 407.94

406.306 333.47

404.426 331.88

502.562 418.21

400.748 329.62

404.512 334.68

501.143 417.54

499.873 415.66
Unit Net Electric Generation (MWh) Unit Gross Electric Generation (MWe)

51.11 54.24

54.43 57.71

54.5 57.8

54.39 57.5

82.88 86.75

54.14 57.45

53.73 56.96

82.79 86.65

82.47 86.32

82.94 86.78

45.93 48.88

47.8 50.89

47.64 50.71

47.6 50.71

44.8 47.76

21.68 23.57

42.38 45.4

47.92 51.03

47.79 50.9

47.81 50.89

48.38 51.42

52.02 55.2

47.58 50.76

37.86 40.73

37.67 40.45

48.15 51.32

37.37 40.36

37.8 40.81

47.92 51.09

47.66 50.87
Control Device Operating Parameters, As Appicable

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

Since load varied before and after testing, data is the average for the testing period only (Dioxin Furan Test Day)

Since load varied before and after testing, data is the average for the testing period only (Dioxin Furan Test Day)

Since load varied before and after testing, data is the average for the testing period only

Since load varied before and after testing, data is the average for the testing period only (Dioxin Furan Test Day)
FGD Scrubber Liquor Flow Rate (gals/min) Sorbent Type Sorbent Injection Rate (lb/hr)

riod only (Dioxin Furan Test Day)

riod only (Dioxin Furan Test Day)

riod only (Dioxin Furan Test Day)
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

766 Waiau Power Plant 7

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 3/29/2010

Day 2 3/30/2010

Day 3 3/31/2010

Day 4 4/1/2010

Day 5 4/2/2010

Day 6 4/3/2010

Day 7 4/4/2010

Day 8 4/5/2010

Day 9 4/6/2010

Day 10 4/7/2010

Day 11 4/8/2010

Day 12 4/9/2010

Day 13 4/10/2010

Day 14 4/11/2010

Day 15 4/12/2010

Day 16 4/13/2010

Day 17 4/14/2010

Day 18 4/15/2010

Day 19 4/16/2010

Day 20 4/17/2010

Day 21 4/18/2010

Day 22 4/19/2010

Day 23 4/20/2010

Day 24 4/21/2010

Day 25 4/22/2010

Day 26 4/23/2010

Day 27 4/24/2010

Day 28 4/25/2010

Day 29 4/26/2010

Day 30 4/27/2010
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)

27.72 Klb/hr

29.42 Klb/hr

29.42 Klb/hr

29.55 Klb/hr

45.16 Klb/hr

29.37 Klb/hr

29.11 Klb/hr

44.8 Klb/hr

44.42 Klb/hr

44.53 Klb/hr

25.53 Klb/hr

26.25 Klb/hr

26.1 Klb/hr

26.36 Klb/hr

25.18 Klb/hr

12.65 Klb/hr

23.62 Klb/hr

26.26 Klb/hr

26.29 Klb/hr

26.23 Klb/hr

26.57 Klb/hr

28.54 Klb/hr

26.25 Klb/hr

21.55 Klb/hr

21.45 Klb/hr

26.66 Klb/hr

21.25 Klb/hr

21.46 Klb/hr

26.58 Klb/hr

26.51 Klb/hr
Average Heat Input (MMBtu/hr) Steam Output (1,000 lbs steam/hr)

522.27 437.32

554.193 464.63

554.099 465.37

556.506 462.88

852.137 695.94

553.275 462.48

548.345 458.78

832.754 696.09

841.748 695.24

843.774 696.85

480.867 401.93

494.561 411.51

491.673 410.33

496.568 411.01

474.135 390.54

238.542 200.41

445.22 368.93

494.904 413.7

495.527 410.45

495.452 409.06

500.865 414.82

538.023 447.62

494.843 407.94

406.306 333.47

404.426 331.88

502.562 418.21

400.748 329.62

404.512 334.68

501.143 417.54

499.873 415.66
Unit Net Electric Generation (MWh) Unit Gross Electric Generation (MWe)

51.11 54.24

54.43 57.71

54.5 57.8

54.39 57.5

82.88 86.75

54.14 57.45

53.73 56.96

82.79 86.65

82.47 86.32

82.94 86.78

45.93 48.88

47.8 50.89

47.64 50.71

47.6 50.71

44.8 47.76

21.68 23.57

42.38 45.4

47.92 51.03

47.79 50.9

47.81 50.89

48.38 51.42

52.02 55.2

47.58 50.76

37.86 40.73

37.67 40.45

48.15 51.32

37.37 40.36

37.8 40.81

47.92 51.09

47.66 50.87
Control Device Operating Parameters, As Appicable

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

Since load varied before and after testing, data is the average for the testing period only

Since load varied before and after testing, data is the average for the testing period only

Since load varied before and after testing, data is the average for the testing period only (Organics Test Day)

Since load varied before and after testing, data is the average for the testing period only
FGD Scrubber Liquor Flow Rate (gals/min) Sorbent Type Sorbent Injection Rate (lb/hr)

riod only (Organics Test Day)
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 (%)
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)

27.72 Klb/hr 522.27 437.32 51.11 54.24

29.42 Klb/hr 554.193 464.63 54.43 57.71

29.42 Klb/hr 554.099 465.37 54.5 57.8

29.55 Klb/hr 556.506 462.88 54.39 57.5

45.16 Klb/hr 852.137 695.94 82.88 86.75

29.37 Klb/hr 553.275 462.48 54.14 57.45

29.11 Klb/hr 548.345 458.78 53.73 56.96

44.8 Klb/hr 832.754 696.09 82.79 86.65

44.42 Klb/hr 841.748 695.24 82.47 86.32

44.53 Klb/hr 843.774 696.85 82.94 86.78

25.53 Klb/hr 480.867 401.93 45.93 48.88

26.25 Klb/hr 494.561 411.51 47.8 50.89

26.1 Klb/hr 491.673 410.33 47.64 50.71

26.36 Klb/hr 496.568 411.01 47.6 50.71

25.18 Klb/hr 474.135 390.54 44.8 47.76

12.65 Klb/hr 238.542 200.41 21.68 23.57

23.62 Klb/hr 445.22 368.93 42.38 45.4

26.26 Klb/hr 494.904 413.7 47.92 51.03

26.29 Klb/hr 495.527 410.45 47.79 50.9

26.23 Klb/hr 495.452 409.06 47.81 50.89

26.57 Klb/hr 500.865 414.82 48.38 51.42

28.54 Klb/hr 538.023 447.62 52.02 55.2

26.25 Klb/hr 494.843 407.94 47.58 50.76

21.55 Klb/hr 406.306 333.47 37.86 40.73

21.45 Klb/hr 404.426 331.88 37.67 40.45

26.66 Klb/hr 502.562 418.21 48.15 51.32

21.25 Klb/hr 400.748 329.62 37.37 40.36

21.46 Klb/hr 404.512 334.68 37.8 40.81

26.58 Klb/hr 501.143 417.54 47.92 51.09

26.51 Klb/hr 499.873 415.66 47.66 50.87