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

006096 Nebraska City Station 2
EIA Facility Code Facility Name Boiler ID

006096 Nebraska City Station 2

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

Date Coal Firing Rate Coal Firing Rate (units)

Day 1 06/30/10 664.9708181 KPPH

Day 2 07/01/10 656.4830927 KPPH

Day 3 07/02/10 652.2577496 KPPH

Day 4 07/03/10 635.4857365 KPPH

Day 5 07/04/10 651.8139738 KPPH

Day 6 07/05/10 665.8448863 KPPH

Day 7 07/06/10 748.9827084 KPPH

Day 8 07/07/10 709.1217898 KPPH

Day 9 07/08/10 731.9671884 KPPH

Day 10 07/09/10 729.522573 KPPH

Day 11 07/10/10 695.7919928 KPPH

Day 12 07/11/10 671.1306544 KPPH

Day 13 07/12/10 718.5982981 KPPH

Day 14 07/13/10 619.8127848 KPPH

Day 15 07/14/10 695.1812857 KPPH

Day 16 07/15/10 721.8905805 KPPH

Day 17 07/16/10 741.6798862 KPPH

Day 18 07/17/10 707.7045956 KPPH

Day 19 07/18/10 670.8726413 KPPH

Day 20 07/19/10 682.6335113 KPPH

Day 21 07/20/10 721.4159186 KPPH

Day 22 07/21/10 659.7463313 KPPH

Day 23 07/22/10 670.9951297 KPPH

Day 24 07/23/10 721.6714639 KPPH

Day 25 07/24/10 729.4160304 KPPH

Day 26 07/25/10 712.9400786 KPPH

Day 27 07/26/10 726.5016125 KPPH

Day 28 07/27/10 719.9004894 KPPH

Day 29 07/28/10 709.7497764 KPPH

Day 30 07/29/10 708.5880469 KPPH
ay Period Including the Testing Date

Synfuel Firing Rate 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)
Average Heat Input (MMBtu/hr) Steam Output (1,000 lbs steam/hr)

5578.692595 4115.250591

5603.255186 4091.829209

5500.178872 4104.04562

5182.357586 3877.333051

5360.149615 3980.121238

5285.30385 3913.313009

5971.520652 4520.1726

5938.068342 4427.006591

5960.861572 4406.023102

5813.936594 4435.837288

5545.750204 4281.86057

5335.704099 4121.030246

5744.127287 4327.961911

5034.904755 3752.979124

5889.20942 4398.28025

5881.180276 4329.534837

5887.107428 4342.717022

5798.747034 4373.040667

5665.510892 4249.288208

5661.278102 4185.978053

6119.971264 4460.694625

5523.239493 4077.460375

5601.408605 4264.595416

5846.699321 4428.626126

5983.192346 4464.579482

5892.479642 4367.052803

5830.188723 4336.351613

5722.397215 4291.192235

5880.740738 4381.032789

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

585.2842402 634.070402

579.8599862 628.7263643

573.4410119 624.0512464

546.2362766 596.5379178

560.6791239 611.7214434

550.8905578 601.9225085

633.7514792 688.5940298

622.3070042 676.217022

619.5173791 673.2291253

624.7169419 678.5527326

602.9819936 655.6249779

579.2793279 631.1352689

607.7067629 661.0713714

523.7437829 573.9774917

613.1103774 666.8760238

608.392303 662.0303766

608.4546129 662.1872602

610.7390756 664.3506191

584.5299896 637.4105625

585.6204188 638.0210025

624.8239442 678.8972381

572.0005255 623.5388145

593.8735317 647.2336351

617.9371642 672.1257885

625.3239199 679.6125346

613.7110259 667.1298657

607.1385273 660.9013222

597.6970749 651.5802053

612.021892 666.1296945

615.3688547 667.9251175
Control Device Operating Parameters, As Appicable

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

85.51129974 3.354669757

84.35025902 3.393511483

84.22271604 3.281852342

80.05295646 3.191015579

81.78946293 3.025399736

81.17550711 3.229748698

90.06275197 3.520359988

87.71883366 3.482821469

88.10353261 3.948723786

88.53595359 3.665984067

86.06485159 3.306208406

84.18835781 3.207059586

87.81906299 3.403522242

79.55424083 3.064614492

88.51738011 3.522220242

87.07148588 3.439630739

87.44662173 3.465945752

87.69743141 3.514882038

84.90201208 3.240248837

84.61317896 3.234069981

88.69566631 3.492731043

82.76863288 3.308904752

85.40740921 3.372120856

88.22393447 3.564117892

88.47432267 3.489790644

87.06631933 3.40700709

88.05928481 3.583454242

87.6210306 3.501611268

88.57926246 3.544909647

88.62526716 3.428170426
FGD Scrubber Liquor Flow Rate (gals/min) Sorbent Type Sorbent Injection Rate (lb/hr)

159.7386732 ACI 51.5123586

146.6562015 ACI 52.53543081

138.8073516 ACI 53.55541657

194.3276784 ACI 51.66150232

154.8729579 ACI 53.12774704

231.1497906 ACI 55.35444229

261.483915 ACI 57.42661747

183.7980696 ACI 56.7638018

216.8808191 ACI 45.38404014

226.4854554 ACI 59.65302765

216.4544035 ACI 56.49913289

229.8966578 ACI 54.33588899

243.4275154 ACI 60.9478082

203.1812647 ACI 56.3502185

196.0537809 ACI 65.0898018

231.494744 ACI 65.52724361

246.0985589 ACI 67.39404283

261.6129575 ACI 64.27327464

217.597708 ACI 59.01539224

233.731314 ACI 47.34204027

234.773492 ACI 64.4963253

209.7643649 ACI 59.34217645

181.5638928 ACI 61.04985631

203.9355643 ACI 65.63041218

239.7053114 ACI 66.13777803

247.2826989 ACI 64.62408319

240.9264137 ACI 66.21297079

232.1383088 ACI 65.70277306

237.5861621 ACI 64.35114079

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

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

29.21220473 180.6839402

29.20687469 181.7700473

29.05678882 182.219055

28.88674729 182.3312991

28.84913807 183.714525

28.84971105 183.4413724

28.97390456 184.0061754

29.06437473 183.950546

29.14540236 182.3411573

29.13663964 181.2339235

29.00078715 184.2649099

28.81343243 180.4064155

28.81350343 181.8936667

28.79650125 194.4392014

28.85155186 185.4644329

29.06135775 184.7666749

29.01708182 185.7313373

28.93290828 185.6045991

28.93496372 190.1527425

28.86895966 184.8739165

28.95100995 186.6063739

29.02368557 184.4702927

28.82821319 188.4788212

28.83379239 186.3038765

28.97605909 186.2872992

29.13067414 186.7642446

29.04391602 185.4548784

28.96700818 185.8773817

29.05250885 186.2622253

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

3.132297732 11.86252179 0.235720872

3.027459701 11.99018129 0.632157013

3.233089567 11.88749951 0.687858636

3.18301508 11.72662918 0.629444882

3.160381415 11.87280945 1.037755025

3.147683053 11.66828871 1.052958737

3.017795788 11.98330454 1.200012221

3.044460929 12.24727322 0.901821758

3.024251543 11.93251623 0.48386884

3.022051905 11.91507257 0.300862282

3.046323506 11.72081912 0.320481794

3.123448258 11.48607354 0.626101634

3.047801838 11.67763162 0.694918171

3.266448298 11.414998 1.256277339

2.836877664 12.00780136 1.549804927

2.765132652 12.24521601 0.768124317

2.726009984 12.16465476 0.883447046

2.74585317 12.01369181 1.827430893

2.813075093 12.1556899 1.003864073

2.813046651 12.03313852 0.976783351

2.727977656 10.78582092 0.997281761

2.844281002 12.08367624 1.168555684

2.816427737 11.87960307 1.127495505

2.747175049 11.96362005 1.263885782

2.721394356 12.2642065 0.78717747

2.888955679 12.29637518 0.500625765

2.942965677 11.9856451 1.070456394

2.935124073 11.82380278 1.08281484

2.949860437 12.02821502 0.990319459

2.753323026 12.23147605 0.634694727
EIA Facility Code Facility Name Boiler ID

006096 Nebraska City Station 2

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

Date Coal Firing Rate Coal Firing Rate (units)

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
ay Period Including the Testing Date

Synfuel Firing Rate 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)
Average Heat Input (MMBtu/hr) Steam Output (1,000 lbs steam/hr)
Unit Net Electric Generation (MWh) Unit Gross Electric Generation (MWe)
Control Device Operating Parameters, As Appicable

Flue Gas Flow Rate (dscfm) Pressure Drop across FGD (in H2O)
FGD Scrubber Liquor Flow Rate (gals/min) Sorbent Type Sorbent Injection Rate (lb/hr)
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

006096 Nebraska City Station 2

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

Date Coal Firing Rate Coal Firing Rate (units)

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
ay Period Including the Testing Date

Synfuel Firing Rate 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)
Average Heat Input (MMBtu/hr) Steam Output (1,000 lbs steam/hr)
Unit Net Electric Generation (MWh) Unit Gross Electric Generation (MWe)
Control Device Operating Parameters, As Appicable

Flue Gas Flow Rate (dscfm) Pressure Drop across FGD (in H2O)
FGD Scrubber Liquor Flow Rate (gals/min) Sorbent Type Sorbent Injection Rate (lb/hr)
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

006096 Nebraska City Station 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
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)
Average Heat Input (MMBtu/hr) Steam Output (1,000 lbs steam/hr)
Unit Net Electric Generation (MWh) Unit Gross Electric Generation (MWe)
Control Device Operating Parameters, As Appicable

Flue Gas Flow Rate (dscfm) Pressure Drop across FGD (in H2O)
FGD Scrubber Liquor Flow Rate (gals/min) Sorbent Type Sorbent Injection Rate (lb/hr)
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 (%)