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

6823 D.B. Wilson W1
EIA Facility Code Facility Name Boiler ID

6823 D.B. Wilson W1

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

Date 

(MM/DD/YY) Coal Firing Rate (1,000 Tons/hr)
 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)

1515.486767

1528.730152

1547.378378

1534.914287

1543.161695

1563.340841

1502.169636

1590.794955

1432.189096

0

0

0

0

0

0

2440.698042

1260.50216

1459.678552

1459.342435

1480.545716

1454.647636

1478.96158

1467.73119

1554.285903

1602.508169

1554.982467

1513.288054

1562.808139

1563.653305

1574.473976

1521.768486
Steam Output (1,000 lbs steam/hr) Flue Gas Flow Rate (scfm) Flue Gas Pressure (in. Hg)

904.7403564 424954.1667 29.42

907.1779785 438013.1944 29.38

891.7828369 451679.8611 29.35

889.4430542 448191.6667 29.59

897.1018677 433130.5556 29.63

898.157959 439733.3333 29.54

1024.06189 424042.3611 29.65

1025.371948 421503.4722 29.48

901.7952881 397223.5294 29.87

0 0 30.02

0 0 29.89

0 0 29.63

0 0 29.71

0 0 29.76

0 0 29.9

3.998165131 0 29.85

418.0106201 415487.037 29.71

894.1089478 422406.25 29.62

899.480835 422703.4722 29.64

891.8081665 420381.9444 29.68

897.1272583 421883.3333 29.65

899.6207886 431041.6667 29.61

894.7055054 431041.6667 29.7

900.9041138 465838.8889 29.73

1020.578003 472556.9444 29.73

1011.960938 449270.8333 29.73

1007.815186 447822.2222 29.69

895.5250854 451972.2222 29.63

966.586731 447922.2222 29.6

887.427002 446261.1111 29.57

899.9885254 442951.3889 29.62
Flue Gas Sampling Point Temperature (Deg F) Flue Gas Oxygen Content (%)

137.3 2.552563209

138.8 3.769277224

140.1 4.017696891

137.5 3.757355073

136.6 3.169459641

136.8 3.1951857

133.4 3.268505165

135.8 3.009737523

130 5.59571162

125.9 0

104.7 0

105.6 0

114.9 0

118 0

116.5 0

111.9 0

109.4 6.058649884

128.7 4.138994971

134.8 3.944650776

134.6 4.134013712

135.6 3.980853325

138.1 3.798767408

138.6 3.609888452

142.4 4.036239118

141.8 3.888295503

141.3 3.620296025

140.8 3.706093025

141.1 3.518364744

141 3.865780843

141.5 3.830909314

142 3.610938793
Flue Gas Carbon Dioxide Content (%) Flue Gas Moisture Content (%)

10.99266667

10.75516667

10.626

10.8533913

11.24266667

11.1635

11.251

11.376

10.65394118

9.456555556

10.50933333

10.64683333

10.63433333

10.75516667

10.79266667

10.79266667

10.551

10.59266667

10.676

10.65516667

10.76766667

10.676

10.66766667

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

3363 3656

3687 3982

3179 3477

3499 3795

3503 3796

3531 3826

3435 3725

3508 3795

2284 2476

0 0

0 0

0 0

0 0

0 0

0 0

26 26

2486 2642

3177 3463

3240 3519

3217 3491

3243 3527

3355 3649

3284 3575

3515 3804

3644 3935

3488 3775

3455 3740

3516 3809

3437 3736

3418 3718

3439 3733
Standard Temperature (Deg F) Pressure Drop across FGD (in H2O)
FGD Scrubber Liquor Flow Rate (gals/min) FGD Scrubber Liquor pH (pH) Sorbent Type

296.6666667 6.094116688

296.6666667 6.485429764

296.6666667 6.51906538

296.6666667 6.53661871

296.6666667 6.505339146

296.6666667 6.602477074

296.6666667 6.642546654

296.6666667 6.77314949

17800 6.798145294

0 0

0 0

0 0

0 0

0 0

0 0

0 6.91590786

296.6666667 6.858022213

296.6666667 6.401144028

296.6666667 6.655427456

296.6666667 6.81010294

296.6666667 6.505884171

296.6666667 6.452738762

296.6666667 6.862361908

296.6666667 6.678971291

296.6666667 6.610678673

296.6666667 6.603446007

296.6666667 6.605006695

296.6666667 6.652133465

296.6666667 6.612700462

296.6666667 6.558825493

296.6666667 6.621767998
Sorbent Injection Rate (lb/hr)
EIA Facility Code Facility Name Boiler ID

6823 D.B. Wilson W1

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

6823 D.B. Wilson W1

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

05/02/10 Day 2 0.1971315

05/03/10 Day 3 0.200193292

05/04/10 Day 4 0.1927285

05/05/10 Day 5 0.188489167

05/06/10 Day 6 0.188362042

05/07/10 Day 7 0.188983375

05/08/10 Day 8 0.179406104

05/09/10 Day 9 0.166640271

05/10/10 Day 10 0.165552167

05/11/10 Day 11 0.173784646

05/12/10 Day 12 0.158240333

05/13/10 Day 13 0.159987271

05/14/10 Day 14 0.170175

05/15/10 Day 15 0.187396604

05/16/10 Day 16 0.172570354

05/17/10 Day 17 0.174983396

05/18/10 Day 18 0.175537292

05/19/10 Day 19 0.175825896

05/20/10 Day 20 0.173494063

05/21/10 Day 21 0.176801208

05/22/10 Day 22 0.180709542

05/23/10 Day 23 0.177042667

05/24/10 Day 24 0.190768604

05/25/10 Day 25 0.188367688

05/26/10 Day 26 0.188732313

05/27/10 Day 27 0.181911958

05/28/10 Day 28 0.193992792

05/29/10 Day 29 0.179963979

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

4362.534264

4615.364534

4672.862546

4504.324634

4355.158454

4539.938797

4521.764818

4283.287089

4137.051488

4121.891357

4300.314964

3800.765072

3637.454591

4062.376758

4439.510226

4144.125193

4139.274224

4204.370909

4228.285759

4229.691557

4358.697869

4397.787162

4303.747888

4621.422851

4473.41612

4408.330088

4282.524026

4506.790098

4266.895556

4303.840364
Steam Output (lbs steam/hr) Flue Gas Flow Rate (dscfm) Flue Gas Pressure (in. Hg)

3278369.628 1169303.791 29.761

3330336.534 1173407.586 29.73

3323317.139 1177713.695 29.677

3282192.138 1157809.783 29.994

3285513.675 1147027.503 29.953

3367428.404 1147632.681 29.872

3377047.485 1188983.14 29.955

3209724.854 1155522.395 29.805

3122232.269 1091801.172 30.147

3061446.798 1044090.289 30.308

3145237.192 1063753.957 30.21

2862484.313 1005188.246 29.967

2903404.698 1028675.039 30.029

2995156.206 1073937.33 30.081

3290729.521 1177959.757 30.188

3175178.314 1134108.925 30.153

3194170.154 1113076.955 30.016

3227597.451 1127610.952 29.949

3230491.087 1112049.89 29.943

3185278.15 1097815.401 29.988

3220485.791 1116906.821 29.969

3269122.288 1127304.696 29.945

3195627.911 1166495.295 30.03

3372389.73 1185819.174 30.063

3409173.951 1186499.046 30.069

3383169.255 1144808.87 30.052

3302849.322 1130311.913 30.01

3561660.442 1183316.171 29.93

3446417.911 1141833.438 29.903

3455252.904 1148590.435 29.893
Flue Gas Sampling Point Temperature (Deg F) Flue Gas Oxygen Content (%)

133 3.224178529

134.8 3.145509676

137.3 3.134581933

135.1 3.127242324

133.9 3.135497424

134.3 3.130163852

132.5 3.071561316

135.8 3.083607301

129.6 3.168861432

128.3 3.169200435

126.8 3.196211343

132 3.166837793

133.4 3.151630987

135.8 3.144135318

136.4 3.090010437

134.2 3.046880498

132.4 3.042667797

131.8 2.982913844

130 3.007896941

130.2 3.039808918

130.5 3.03982597

132.3 3.034538755

132 3.062719412

135.8 3.036474985

138.6 2.954666831

141.2 2.984844841

141.8 3.05143324

143.4 3.116968693

143 3.139441469

140.7 3.136742986
Flue Gas Carbon Dioxide Content (%) Flue Gas Moisture Content (%)

10.73016667

10.70933333

10.80933333

10.94683333

10.9885

11.04683333

10.79683333

10.89683333

10.9135

11.05933333

10.976

10.851

10.69683333

10.5885

10.776

10.64683333

10.70516667

10.81766667

10.951

10.851

10.8885

11.08016667

10.71766667

10.71766667

10.401

10.64683333

10.59683333

10.60933333

10.53016667

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

9806.936 10505.28

9808.506 10514.53

9264.587 9954.35

10518.097 11197.39

9840.466 10500.22

9942.986 10603.52

10036.02 10723.88

9715.396 10374.89

9103.317 9730.69

8969.034 9587.32

9205.376 9847.06

8475.237 9084.89

8530.481 9147.46

8589.132 9222.5

9860.789 10545.65

9433.748 10111.15

9365.662 10035.58

9441.332 10119.16

9499.631 10169.14

9391.305 10053.2

9571.874 10250.86

9918.962 10603.41

9623.47 10322.29

10113.035 10826.44

9704.419 10397.01

9766.548 10434.38

9550.092 10221.02

10049.097 10766.88

9626.208 10319.66

9842.346 10538.88

9711.143 10403.39
Standard Temperature (Deg F) Pressure Drop across FGD (in H2O)

0.263119229

0.278334634

0.285977578

0.292210607

0.186441864

0.232209372

0.265296073

0.298907146

0.340170957

0.18379103

0.047868215

0.043674319

0.06523685

0.046704344

0.070090678

0.068853029

0.067202023

0.065366972

0.055578224

0.053624427

0.065443258

0.07091352

0.077360197

0.071308456

0.095700064

0.12904793

0.077625214

0.086013536

0.070082381

0.068955589
FGD Scrubber Liquor Flow Rate (gals/min) FGD Scrubber Liquor pH (pH) Sorbent Type

72.99888783 5.796549612 Hydrated Lime

73.00830506 5.809662803 Hydrated Lime

76.08503935 5.784369342 Hydrated Lime

72.42937987 5.807619924 Hydrated Lime

34.70068302 6.200737103 Hydrated Lime

66.74097216 5.804709013 Hydrated Lime

76.6669969 5.805222718 Hydrated Lime

75.69630548 5.815180077 Hydrated Lime

68.51056048 5.823679007 Hydrated Lime

67.07933159 5.85217769 Hydrated Lime

64.49095266 5.87756093 Hydrated Lime

56.21359434 5.827676203 Hydrated Lime

74.81959521 5.997489306 Hydrated Lime

58.43129213 5.930663995 Hydrated Lime

68.09229296 5.841634423 Hydrated Lime

65.64572234 5.865428179 Hydrated Lime

66.79922733 5.841674806 Hydrated Lime

67.47002173 5.888572923 Hydrated Lime

67.86365982 5.826386479 Hydrated Lime

63.44194856 5.87327326 Hydrated Lime

69.0177447 5.848656145 Hydrated Lime

69.7524657 5.819043759 Hydrated Lime

75.20731526 5.830888953 Hydrated Lime

62.07359872 6.039319578 Hydrated Lime

50.74583578 6.002747075 Hydrated Lime

63.52296371 6.152410424 Hydrated Lime

45.58253197 6.071380814 Hydrated Lime

52.20262408 5.813703108 Hydrated Lime

49.17901708 5.826365499 Hydrated Lime

63.40863717 5.791606797 Hydrated Lime
MODULE 2 ME DIFFERENTIAL PRESS

W1M2PDT8004BVLU

Sorbent Injection Rate (lb/hr) InWC

1755.833333 0.150589577

1743.333333 0.160072744

1296.666667 0.154536194

1296.666667 0.140106587

1292.166667 0.164204103

1280.5 0.146047514

855.1666667 0.152488367

1288.5 0.144791644

1722.166667 0.123857726

1287.666667 0.113362108

1309.833333 0.11727485

1737.166667 0.111170858

1731.5 0.153850191

1297.833333 0.125068733

1718 0.145824378

1707.666667 0.13689885

1280.333333 0.139709474

1291.333333 0.15045753

1722.666667 0.148616306

1739.166667 0.149807921

1306.666667 0.143670428

1740.833333 0.148992103

1745.666667 0.160244644

1314.333333 0.17689436

877.6666667 0.167092938

985.7407407 0.18027693

0 0.15596657

0 0.152041824

0 0.153416001

636.6242284 0.150796275
MODULE 3 ME DIFFERENTIAL PRESS MODULE 4 ME DIFFERENTIAL PRESS MODULE 2 SLURRY FEED FLOW

W1M3PDT8004CVLU W1M4PDT8004DVLU W1M2FT8002BVLU

InWC InWC GPM

0.144554243 0.116104064 73.63861834

0.140083519 0.123439204 73.03900318

0.144352533 0.107802993 74.23014071

0.146549661 0.099209612 74.46233223

0.167552464 0.281169558 85.32606446

0.141610968 0.102927835 71.1701154

0.15692949 0.119298517 71.95670316

0.189255079 0.135738045 75.07745557

0.174223047 0.117289089 67.68997638

0.182816243 0.107287705 68.19530241

0.176511073 0.11941743 63.99787109

0.167998838 0.09509783 57.86730521

0.092123812 0.186828569 74.28077098

0.16586067 0.138460009 59.15420594

0.175237698 0.201016026 68.84309864

0.22947032 0.216050034 65.92665688

0.283187212 0.221627882 65.86478024

0.360396406 0.245212578 65.24928711

0.376343085 0.245296244 67.0970635

0.181698997 0.265687165 64.5955343

0.011637011 0.277456588 69.03047534

0.003204927 0.291341877 70.83866329

-0.001234665 0.323471287 73.47804257

-0.003346648 0.435128122 69.65938018

-0.002585148 0.368109688 51.8667894

0.00374568 0.095071355 62.67276843

0.001476733 0.064829049 47.13915795

0.012004618 0.071881926 50.62509447

0.005217789 0.070578439 47.50387296

-0.006854957 0.078212727 59.43893684
MODULE 3 SLURRY FEED FLOWMODULE 4 SLURRY FEED FLOW MODULE 2 SLURRY FEED PH

W1M3FT8002CVLU W1M4FT8002DVLU W1M2AT8007BVLU

GPM GPM pH

69.23666681 75.09073332 5.789673476

68.93204289 75.04871765 5.819271776

70.81836107 75.65740795 5.816306525

75.33282848 72.36317574 5.813835513

82.37416751 87.03830302 5.866852335

66.30750512 74.91913227 5.805197121

73.67740835 74.98884232 5.797088884

72.22584583 74.32246281 5.784400946

65.85815001 71.25225258 5.809468547

68.94272537 76.99110064 5.871263047

64.79109235 74.92704835 5.872907647

56.44042116 49.09898835 5.8412324

29.19170781 77.65438112 6.047491996

61.1640653 58.47845433 5.881880689

71.26802237 69.98252531 5.824378572

68.65102736 74.77996263 5.867912194

64.52418828 68.56977214 5.87436924

64.54497245 65.74523112 5.839726966

62.45926875 66.80958196 5.823033145

71.84482806 61.82370001 5.871011283

64.45225762 75.82277762 5.837710655

68.17494091 70.1581713 5.841317625

75.46587612 73.20682131 5.821706612

66.99698917 63.92876165 5.95601526

48.33808085 48.46417985 5.835943883

64.774988 28.27914091 6.075671462

44.69604012 54.37061437 5.96652259

53.10770546 53.9994374 5.799393312

54.64798692 55.03643612 5.82488897

56.59443803 54.90006001 5.810292434
MODULE 3 SLURRY FEED PH MODULE 4 SLURRY FEED PH

W1M3AT8007CVLU W1M4AT8007DVLU

pH pH

5.825535795 4.984436681

5.827179696 5.101488679

5.81820597 5.027961633

5.788400429 5.095898778

5.874294298 5.12286264

5.846654262 5.802243911

5.756036161 5.891122796

5.796136175 6.479153512

5.813353561 6.339930704

5.852490893 6.269938195

5.879898943 5.803351871

5.841901542 5.90077035

6.336377494 5.99279735

5.896453578 6.676284085

5.81288074 7.059999943

5.835305374 7.059999943

5.960451959 6.867518407

5.982828225 7.054009565

5.878751788 7.032209973

5.820792253 6.218309027

5.896801666 5.880000114

5.848681511 5.880000114

5.80473654 5.880000114

5.95026453 5.880000114

5.960141296 5.880000114

6.132785853 5.880000114

6.198394803 5.92585307

5.983683567 6.198012781

6.057114499 6.945284347

6.047216135 7.059999943
EIA Facility Code Facility Name Boiler ID

6823 D.B. Wilson W1

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)