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

4042 Valley 2
EIA Facility Code Facility Name Boiler ID Field1 Field2

4042 Valley 2

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
Field3 Field4 Field5 Field6

he Testing Date

Synfuel Firing Rate (units) Pet Coke Firing Rate Pet Coke Firing Rate (units) Coal Gas Firing Rate
Field7 Field8 Field9

Coal Gas Firing Rate (units) Fuel oil Firing Rate Fuel oil Firing Rate (units)
Field10 Field11

Average Heat Input (MMBtu/hr) Steam Output (1,000 lbs steam/hr)
Field12 Field13

Unit Net Electric Generation (MWh) Unit Gross Electric Generation (MWe)
Field14 Field15

Control Device Operating Parameters, As Appicable

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

FGD Scrubber Liquor Flow Rate (gals/min) Sorbent Type Sorbent Injection Rate (lb/hr)
Field19 Field20

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

Flue Gas Pressure (atm) Flue Gas Sampling Point Temperature (Deg F)
Field21 Field22 Field23

Flue Gas Oxygen Content (%) Flue Gas Carbon Dioxide Content (%) Flue Gas Moisture Content (%)
EIA Facility Code Facility Name Boiler ID Field1 Field2

4042 Valley 2

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
Field3 Field4 Field5 Field6

he Testing Date

Synfuel Firing Rate (units) Pet Coke Firing Rate Pet Coke Firing Rate (units) Coal Gas Firing Rate
Field7 Field8 Field9

Coal Gas Firing Rate (units) Fuel oil Firing Rate Fuel oil Firing Rate (units)
Field10 Field11

Average Heat Input (MMBtu/hr) Steam Output (1,000 lbs steam/hr)
Field12 Field13

Unit Net Electric Generation (MWh) Unit Gross Electric Generation (MWe)
Field14 Field15

Control Device Operating Parameters, As Appicable

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

FGD Scrubber Liquor Flow Rate (gals/min) Sorbent Type Sorbent Injection Rate (lb/hr)
Field19 Field20

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

Flue Gas Pressure (atm) Flue Gas Sampling Point Temperature (Deg F)
Field21 Field22 Field23

Flue Gas Oxygen Content (%) Flue Gas Carbon Dioxide Content (%) Flue Gas Moisture Content (%)
EIA Facility Code Facility Name Boiler ID Field1 Field2

4042 Valley 2

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
Field3 Field4 Field5 Field6

he Testing Date

Synfuel Firing Rate (units) Pet Coke Firing Rate Pet Coke Firing Rate (units) Coal Gas Firing Rate
Field7 Field8 Field9

Coal Gas Firing Rate (units) Fuel oil Firing Rate Fuel oil Firing Rate (units)
Field10 Field11

Average Heat Input (MMBtu/hr) Steam Output (1,000 lbs steam/hr)
Field12 Field13

Unit Net Electric Generation (MWh) Unit Gross Electric Generation (MWe)
Field14 Field15

Control Device Operating Parameters, As Appicable

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

FGD Scrubber Liquor Flow Rate (gals/min) Sorbent Type Sorbent Injection Rate (lb/hr)
Field19 Field20

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

Flue Gas Pressure (atm) Flue Gas Sampling Point Temperature (Deg F)
Field21 Field22 Field23

Flue Gas Oxygen Content (%) Flue Gas Carbon Dioxide Content (%) Flue Gas Moisture Content (%)
EIA Facility Code Facility Name Boiler ID Field1 Field2

4042 Valley 2

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 03/03/10 51.75 1,000 lbs/hr

Day 2 03/04/10 52.875 1,000 lbs/hr

Day 3 03/05/10 49.16666667 1,000 lbs/hr

Day 4 03/06/10 53.875 1,000 lbs/hr

Day 5 03/07/10 29.20833333 1,000 lbs/hr

Day 6 03/08/10 41.79166667 1,000 lbs/hr

Day 7 03/09/10 30 1,000 lbs/hr

Day 8 03/10/10 50.66666667 1,000 lbs/hr

Day 9 03/11/10 49.91666667 1,000 lbs/hr

Day 10 03/12/10 49.5 1,000 lbs/hr

Day 11 03/13/10 52.33333333 1,000 lbs/hr

Day 12 03/14/10 51.58333333 1,000 lbs/hr

Day 13 03/15/10 50.83333333 1,000 lbs/hr

Day 14 03/16/10 50.875 1,000 lbs/hr

Day 15 03/17/10 50.66666667 1,000 lbs/hr

Day 16 03/18/10 46.20833333 1,000 lbs/hr

Day 17 03/19/10 50.45833333 1,000 lbs/hr

Day 18 03/20/10 60.66666667 1,000 lbs/hr

Day 19 03/21/10 55.04166667 1,000 lbs/hr

Day 20 03/22/10 42.20833333 1,000 lbs/hr

Day 21 03/23/10 45.33333333 1,000 lbs/hr

Day 22 03/24/10 48.625 1,000 lbs/hr

Day 23 03/25/10 52.20833333 1,000 lbs/hr

Day 24 03/26/10 50.45833333 1,000 lbs/hr

Day 25 03/27/10 49.20833333 1,000 lbs/hr

Day 26 03/28/10 49.66666667 1,000 lbs/hr

Day 27 03/29/10 51.45833333 1,000 lbs/hr

Day 28 03/30/10 56 1,000 lbs/hr

Day 29 03/31/10 55.95833333 1,000 lbs/hr

Day 30 04/01/10 64.70833333 1,000 lbs/hr
Field3 Field4 Field5 Field6

he Testing Date

Synfuel Firing Rate (units) Pet Coke Firing Rate Pet Coke Firing Rate (units) Coal Gas Firing Rate
Field7 Field8 Field9

Coal Gas Firing Rate (units) Fuel oil Firing Rate Fuel oil Firing Rate (units)
Field10 Field11

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

549.8958333 431.375

556.3833333 435.5

524.6375 413.1666667

584.8041667 448.3333333

352.85 280.2083333

432.4833333 342.0416667

339.0208333 266.0833333

504.0958333 397.2916667

523.0541667 411.5

535.9708333 429.5416667

573.1625 442.25

556.8041667 434.2916667

559.1875 430.7083333

561.1375 427.9583333

555.6041667 425.25

506.6541667 401.3333333

499.8416667 394.3333333

557.1041667 454.6666667

541.2125 425.5416667

398.3333333 322.7083333

449.3625 345.7916667

533.2333333 410.25

543.2708333 432.9166667

547.3541667 437.4583333

532.9291667 420.6666667

531.1291667 417.8333333

540.6833333 432.875

614.9416667 479.7916667

602.4083333 472.9166667

704.2416667 531.625
Field12 Field13

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

68.45833333 76.875

73.875 82.16666667

63.375 71.125

60.45833333 69.16666667

39.875 45.25

56.33333333 62.20833333

45.41666667 51.54166667

48.95833333 55.04166667

55.04166667 62.04166667

59.08333333 66.70833333

61.91666667 68.875

57.58333333 66.04166667

60.25 66.5

59.29166667 65.91666667

59.45833333 67.29166667

57.875 64.41666667

58.375 65.41666667

64.08333333 71.20833333

59.375 67

60.125 66.04166667

70.54166667 77.25

57.25 63.08333333

37.125 41.33333333

37.20833333 41.25

36.5 40.875

36.04166667 40.66666667

37.125 42.41666667

43.66666667 48.95833333

43.29166667 48.20833333

49.83333333 55.08333333
Field14 Field15

Control Device Operating Parameters, As Appicable

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

FGD Scrubber Liquor Flow Rate (gals/min) Sorbent Type Sorbent Injection Rate (lb/hr)
Field19 Field20

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

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

0.980587532 309.575

0.984918344 310.9291667

0.990572071 308.8708333

0.990892356 309.8291667

0.983553651 290.4666667

0.982119331 300.3541667

0.975616151 299.7875

0.966884902 301.7

0.965436656 306.5375

0.970087753 308.725

0.965868345 308.3416667

0.974098279 306.8875

0.984834791 307.5208333

0.988761764 307.9

0.986631172 307.7125

0.977523936 306.3166667

0.978443015 307.675

0.98306626 306.8416667

0.982996633 305.8541667

0.976966919 297.0583333

0.978067028 298.7166667

0.981980076 288.7958333

0.977997401 280.8958333

0.98129773 282.9791667

0.977885998 288.1541667

0.972594331 287.6416667

0.976799813 287.85

0.97381977 295.1833333

0.971953761 301.5916667

0.974516042 309.2166667
Field21 Field22 Field23

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

9.929166667 10.97083333

9.808333333 11.09166667

9.908333333 10.99166667

10.05416667 10.84583333

10.93333333 9.966666667

10.4 10.5

10.4625 10.4375

10.575 10.325

10.03333333 10.86666667

9.941666667 10.95833333

9.816666667 11.08333333

9.9375 10.9625

9.895833333 11.00416667

9.866666667 11.03333333

9.875 11.025

10.16666667 10.73333333

10.24583333 10.65416667

10.04166667 10.85833333

10.09166667 10.80833333

10.65833333 10.24166667

10.42916667 10.47083333

12.32916667 8.570833333

11.04166667 9.858333333

10.95 9.95

10.86666667 10.03333333

10.95416667 9.945833333

10.91666667 9.983333333

10.6125 10.2875

10.65 10.25

10.35416667 10.54583333