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

6639 R D Green G2
EIA Facility Code Facility Name Boiler ID

6639 R D Green G2

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

Date 

(MM/DD/YY) Coal Firing Rate (1,000 Tons/hr)

5/1/2010 Day 1 0.0952655

5/2/2010 Day 2 0.094399875

5/3/2010 Day 3 0.1000285

5/4/2010 Day 4 0.096644958

5/5/2010 Day 5 0.097792375

5/6/2010 Day 6 0.096981292

5/7/2010 Day 7 0.099872917

5/8/2010 Day 8 0.093758125

5/9/2010 Day 9 0.07904675

5/10/2010 Day 10 0.09146975

5/11/2010 Day 11 0.096151708

5/12/2010 Day 12 0.09423575

5/13/2010 Day 13 0.095452042

5/14/2010 Day 14 0.090973833

5/15/2010 Day 15 0.093478125

5/16/2010 Day 16 0.09193225

5/17/2010 Day 17 0.097751958

5/18/2010 Day 18 0.092657042

5/19/2010 Day 19 0.089741542

5/20/2010 Day 20 0.086707875

5/21/2010 Day 21 0.092780167

5/22/2010 Day 22 0.096863958

5/23/2010 Day 23 0.093250625

5/24/2010 Day 24 0.101237917

5/25/2010 Day 25 0.101886542

5/26/2010 Day 26 0.092543792

5/27/2010 Day 27 0.093382167

5/28/2010 Day 28 0.095240917

5/29/2010 Day 29 0.095181875

5/30/2010 Day 30 0.093363667
 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.023340048

0.022183971

0.024206897

0.021938406

0.021220945

0.021820791

0.024368992

0.01650143

0.01873408

0.025337121

0.022403348

0.020920337

0.021572161

0.019650348

0.021032578

0.022339537

0.022385198

0.022700975

0.020909779

0.019422564

0.019762176

0.021988119

0.022659902

0.02237358

0.014875435

0

0.017835994

0.02076252

0.021987013

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

2256.198214

2269.724628

2334.286178

2288.449891

2235.342806

2297.623543

2362.616429

2217.481967

1861.000702

2141.946305

2279.140012

2224.699104

2260.127659

2112.643678

2194.49493

2171.932371

2317.695275

2170.955147

2110.377764

2080.709353

2228.525854

2285.30399

2255.993431

2397.456052

2406.405655

2109.228486

2165.729164

2221.577198

2203.977237

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

1569.859741 661991.6667 29.02

1279.143677 664308.3333 28.98

1234.248657 680891.6667 28.94

1414.419189 673587.5 29.19

1138.360352 677866.6667 29.24

1266.072876 685170.8333 29.17

1560.724731 694462.5 29.27

1562.870117 668220.8333 29.1

1074.085205 572066.6667 29.41

1066.883789 656387.5 29.56

1128.607422 684704.1667 29.43

1505.1875 662183.3333 29.22

1317.112915 680458.3333 29.34

1459.077271 649725 29.4

1139.006714 674429.1667 29.52

1406.588257 663520.8333 29.47

1221.794312 688841.6667 29.3

1188.361084 658575 29.21

1047.905762 647504.1667 29.2

1117.163696 636158.3333 29.25

1045.112671 674216.6667 29.22

1480.066895 684525 29.21

1348.135986 672454.1667 29.33

1535.271118 720366.6667 29.39

1576.275269 726941.6667 29.4

1576.472534 651175 29.39

833.3412476 677464.5833 29.34

1396.625854 689324.3056 29.28

1589.359741 680428.4722 29.24

1141.358032 673952.0833 29.23
Flue Gas Sampling Point Temperature (Deg F) Flue Gas Oxygen Content (%)

115.1

115.4

117.6

115.8

115.3

116.4

112.9

115.2

109.2

108.3

109.8

115

118.3

119

117

114.7

114.8

115

112.6

112.4

112.8

116.5

117.3

120.7

120.1

118.9

121.1

119.1

118

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

10.10516667 NA

10.15516667 NA

10.20516667 NA

10.09683333 NA

10.09266667 NA

10.23433333 NA

10.30933333 NA

10.1385 NA

9.701 NA

10.14683333 NA

10.201 NA

9.951 NA

10.02183333 NA

9.934333333 NA

10.0385 NA

9.801 NA

10.00933333 NA

9.784333333 NA

9.801 NA

9.601 NA

9.701 NA

9.846833333 NA

9.705375 NA

9.896833333 NA

9.846833333 NA

9.376 NA

9.751 NA

9.946833333 NA

9.955166667 NA

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

4808 5249

4738 5181

5015 5461

4916 5363

4910 5358

5013 5461

5138 5592

4972 5420

3940 4353

4784 5223

4930 5374

4808 5249

4949 5392

4757 5196

4906 5347

4795 5235

5061 5509

4787 5228

4660 5095

4464 4896

4731 5168

4929 5376

4758 5198

5213 5669

5277 5734

4595 5032

4741 5177

4961 5401

4952 5390

4843 5277
Standard Temperature (Deg F) Pressure Drop across FGD (in H2O)
FGD Scrubber Liquor Flow Rate (gals/min) FGD Scrubber Liquor pH A (pH)

770.9166667 6.558660984

774.1166667 6.608855247

782.55 6.613014221

775.1 6.594652176

773.3666667 6.566460609

764.7 6.622210979

764.6 6.578211784

762.1666667 6.813189507

753.5666667 6.749520302

747.5666667 6.686508656

754.1 6.754495144

755.4 6.737399578

753.3833333 6.672959328

751.2666667 6.716510773

745.3166667 6.748220444

741.15 6.711113453

738.9666667 6.742999077

786.5833333 6.777443409

793.2666667 6.683755398

782.45 6.675864697

780.4666667 6.650847435

779.2333333 6.583468914

777.1666667 6.664205074

790.8166667 6.618670464

792.7833333 6.642311573

775.1666667 6.555968761

772.3833333 6.667939186

770.5833333 6.615022182

769.05 6.600512505

767.35 6.747199059

765.6666667 6.696483135
FGD Scrubber Liquor pH B (pH) Sorbent Type Sorbent Injection Rate (lb/hr)

6.526742458

6.51748848

6.591025829

6.465183258

6.52535677

6.549603462

6.509164333

6.821391106

6.708824635

6.679447651

6.775161743

6.678332329

6.716574192

6.720412731

6.766312599

6.738305092

6.76053524

6.740606308

6.540208817

6.692183495

6.629446507

6.454388142

6.615596294

6.59303236

6.632897377

6.628685474

6.600167274

6.676578522

6.6259408

6.683105469

6.691697598
EIA Facility Code Facility Name Boiler ID

6639 R D Green G2

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

6639 R D Green G2

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

Date 

(MM/DD/YYYY) Coal Firing Rate (1,000 Tons/hr)

5/1/2010 Day 1 0.0952655

5/2/2010 Day 2 0.094399875

5/3/2010 Day 3 0.1000285

5/4/2010 Day 4 0.096644958

5/5/2010 Day 5 0.097792375

5/6/2010 Day 6 0.096981292

5/7/2010 Day 7 0.099872917

5/8/2010 Day 8 0.093758125

5/9/2010 Day 9 0.07904675

5/10/2010 Day 10 0.09146975

5/11/2010 Day 11 0.096151708

5/12/2010 Day 12 0.09423575

5/13/2010 Day 13 0.095452042

5/14/2010 Day 14 0.090973833

5/15/2010 Day 15 0.093478125

5/16/2010 Day 16 0.09193225

5/17/2010 Day 17 0.097751958

5/18/2010 Day 18 0.092657042

5/19/2010 Day 19 0.089741542

5/20/2010 Day 20 0.086707875

5/21/2010 Day 21 0.092780167

5/22/2010 Day 22 0.096863958

5/23/2010 Day 23 0.093250625

5/24/2010 Day 24 0.101237917

5/25/2010 Day 25 0.101886542

5/26/2010 Day 26 0.092543792

5/27/2010 Day 27 0.093382167

5/28/2010 Day 28 0.095240917

5/29/2010 Day 29 0.095181875

5/30/2010 Day 30 0.093363667
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)

0.023340048

0.022183971

0.024206897

0.021938406

0.021220945

0.021820791

0.024368992

0.01650143

0.01873408

0.025337121

0.022403348

0.020920337

0.021572161

0.019650348

0.021032578

0.022339537

0.022385198

0.022700975

0.020909779

0.019422564

0.019762176

0.021988119

0.022659902

0.02237358

0.014875435

0

0.017835994

0.02076252

0.021987013

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

2256.198214

2269.724628

2334.286178

2288.449891

2235.342806

2297.623543

2362.616429

2217.481967

1861.000702

2141.946305

2279.140012

2224.699104

2260.127659

2112.643678

2194.49493

2171.932371

2317.695275

2170.955147

2110.377764

2080.709353

2228.525854

2285.30399

2255.993431

2397.456052

2406.405655

2109.228486

2165.729164

2221.577198

2203.977237

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

1569.859741 661991.6667 29.02

1279.143677 664308.3333 28.98

1234.248657 680891.6667 28.94

1414.419189 673587.5 29.19

1138.360352 677866.6667 29.24

1266.072876 685170.8333 29.17

1560.724731 694462.5 29.27

1562.870117 668220.8333 29.1

1074.085205 572066.6667 29.41

1066.883789 656387.5 29.56

1128.607422 684704.1667 29.43

1505.1875 662183.3333 29.22

1317.112915 680458.3333 29.34

1459.077271 649725 29.4

1139.006714 674429.1667 29.52

1406.588257 663520.8333 29.47

1221.794312 688841.6667 29.3

1188.361084 658575 29.21

1047.905762 647504.1667 29.2

1117.163696 636158.3333 29.25

1045.112671 674216.6667 29.22

1480.066895 684525 29.21

1348.135986 672454.1667 29.33

1535.271118 720366.6667 29.39

1576.275269 726941.6667 29.4

1576.472534 651175 29.39

833.3412476 677464.5833 29.34

1396.625854 689324.3056 29.28

1589.359741 680428.4722 29.24

1141.358032 673952.0833 29.23
Flue Gas Sampling Point Temperature (Deg F) Flue Gas Oxygen Content (%)

115.1

115.4

117.6

115.8

115.3

116.4

112.9

115.2

109.2

108.3

109.8

115

118.3

119

117

114.7

114.8

115

112.6

112.4

112.8

116.5

117.3

120.7

120.1

118.9

121.1

119.1

118

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

10.10516667 NA

10.15516667 NA

10.20516667 NA

10.09683333 NA

10.09266667 NA

10.23433333 NA

10.30933333 NA

10.1385 NA

9.701 NA

10.14683333 NA

10.201 NA

9.951 NA

10.02183333 NA

9.934333333 NA

10.0385 NA

9.801 NA

10.00933333 NA

9.784333333 NA

9.801 NA

9.601 NA

9.701 NA

9.846833333 NA

9.705375 NA

9.896833333 NA

9.846833333 NA

9.376 NA

9.751 NA

9.946833333 NA

9.955166667 NA

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

4808 5249

4738 5181

5015 5461

4916 5363

4910 5358

5013 5461

5138 5592

4972 5420

3940 4353

4784 5223

4930 5374

4808 5249

4949 5392

4757 5196

4906 5347

4795 5235

5061 5509

4787 5228

4660 5095

4464 4896

4731 5168

4929 5376

4758 5198

5213 5669

5277 5734

4595 5032

4741 5177

4961 5401

4952 5390

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

770.9166667 6.558660984 6.526742458

774.1166667 6.608855247 6.51748848

782.55 6.613014221 6.591025829

775.1 6.594652176 6.465183258

773.3666667 6.566460609 6.52535677

764.7 6.622210979 6.549603462

764.6 6.578211784 6.509164333

762.1666667 6.813189507 6.821391106

753.5666667 6.749520302 6.708824635

747.5666667 6.686508656 6.679447651

754.1 6.754495144 6.775161743

755.4 6.737399578 6.678332329

753.3833333 6.672959328 6.716574192

751.2666667 6.716510773 6.720412731

745.3166667 6.748220444 6.766312599

741.15 6.711113453 6.738305092

738.9666667 6.742999077 6.76053524

786.5833333 6.777443409 6.740606308

793.2666667 6.683755398 6.540208817

782.45 6.675864697 6.692183495

780.4666667 6.650847435 6.629446507

779.2333333 6.583468914 6.454388142

777.1666667 6.664205074 6.615596294

790.8166667 6.618670464 6.59303236

792.7833333 6.642311573 6.632897377

775.1666667 6.555968761 6.628685474

772.3833333 6.667939186 6.600167274

770.5833333 6.615022182 6.676578522

769.05 6.600512505 6.6259408

767.35 6.747199059 6.683105469

765.6666667 6.696483135 6.691697598
Sorbent Injection Rate (lb/hr)
EIA Facility Code Facility Name Boiler ID

6639 R D Green G2

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

Date 

(MM/DD/YYYY) Coal Firing Rate (1,000 Tons/hr)

5/1/2010 Day 1 0.0952655

5/2/2010 Day 2 0.094399875

5/3/2010 Day 3 0.1000285

5/4/2010 Day 4 0.096644958

5/5/2010 Day 5 0.097792375

5/6/2010 Day 6 0.096981292

5/7/2010 Day 7 0.099872917

5/8/2010 Day 8 0.093758125

5/9/2010 Day 9 0.07904675

5/10/2010 Day 10 0.09146975

5/11/2010 Day 11 0.096151708

5/12/2010 Day 12 0.09423575

5/13/2010 Day 13 0.095452042

5/14/2010 Day 14 0.090973833

5/15/2010 Day 15 0.093478125

5/16/2010 Day 16 0.09193225

5/17/2010 Day 17 0.097751958

5/18/2010 Day 18 0.092657042

5/19/2010 Day 19 0.089741542

5/20/2010 Day 20 0.086707875

5/21/2010 Day 21 0.092780167

5/22/2010 Day 22 0.096863958

5/23/2010 Day 23 0.093250625

5/24/2010 Day 24 0.101237917

5/25/2010 Day 25 0.101886542

5/26/2010 Day 26 0.092543792

5/27/2010 Day 27 0.093382167

5/28/2010 Day 28 0.095240917

5/29/2010 Day 29 0.095181875

5/30/2010 Day 30 0.093363667
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)

0.023340048

0.022183971

0.024206897

0.021938406

0.021220945

0.021820791

0.024368992

0.01650143

0.01873408

0.025337121

0.022403348

0.020920337

0.021572161

0.019650348

0.021032578

0.022339537

0.022385198

0.022700975

0.020909779

0.019422564

0.019762176

0.021988119

0.022659902

0.02237358

0.014875435

0

0.017835994

0.02076252

0.021987013

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

2256.198214

2269.724628

2334.286178

2288.449891

2235.342806

2297.623543

2362.616429

2217.481967

1861.000702

2141.946305

2279.140012

2224.699104

2260.127659

2112.643678

2194.49493

2171.932371

2317.695275

2170.955147

2110.377764

2080.709353

2228.525854

2285.30399

2255.993431

2397.456052

2406.405655

2109.228486

2165.729164

2221.577198

2203.977237

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

1569.859741 661991.6667 29.02

1279.143677 664308.3333 28.98

1234.248657 680891.6667 28.94

1414.419189 673587.5 29.19

1138.360352 677866.6667 29.24

1266.072876 685170.8333 29.17

1560.724731 694462.5 29.27

1562.870117 668220.8333 29.1

1074.085205 572066.6667 29.41

1066.883789 656387.5 29.56

1128.607422 684704.1667 29.43

1505.1875 662183.3333 29.22

1317.112915 680458.3333 29.34

1459.077271 649725 29.4

1139.006714 674429.1667 29.52

1406.588257 663520.8333 29.47

1221.794312 688841.6667 29.3

1188.361084 658575 29.21

1047.905762 647504.1667 29.2

1117.163696 636158.3333 29.25

1045.112671 674216.6667 29.22

1480.066895 684525 29.21

1348.135986 672454.1667 29.33

1535.271118 720366.6667 29.39

1576.275269 726941.6667 29.4

1576.472534 651175 29.39

833.3412476 677464.5833 29.34

1396.625854 689324.3056 29.28

1589.359741 680428.4722 29.24

1141.358032 673952.0833 29.23
Flue Gas Sampling Point Temperature (Deg F) Flue Gas Oxygen Content (%)

115.1

115.4

117.6

115.8

115.3

116.4

112.9

115.2

109.2

108.3

109.8

115

118.3

119

117

114.7

114.8

115

112.6

112.4

112.8

116.5

117.3

120.7

120.1

118.9

121.1

119.1

118

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

10.10516667 NA

10.15516667 NA

10.20516667 NA

10.09683333 NA

10.09266667 NA

10.23433333 NA

10.30933333 NA

10.1385 NA

9.701 NA

10.14683333 NA

10.201 NA

9.951 NA

10.02183333 NA

9.934333333 NA

10.0385 NA

9.801 NA

10.00933333 NA

9.784333333 NA

9.801 NA

9.601 NA

9.701 NA

9.846833333 NA

9.705375 NA

9.896833333 NA

9.846833333 NA

9.376 NA

9.751 NA

9.946833333 NA

9.955166667 NA

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

4808 5249

4738 5181

5015 5461

4916 5363

4910 5358

5013 5461

5138 5592

4972 5420

3940 4353

4784 5223

4930 5374

4808 5249

4949 5392

4757 5196

4906 5347

4795 5235

5061 5509

4787 5228

4660 5095

4464 4896

4731 5168

4929 5376

4758 5198

5213 5669

5277 5734

4595 5032

4741 5177

4961 5401

4952 5390

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

770.9166667 6.558660984 6.526742458

774.1166667 6.608855247 6.51748848

782.55 6.613014221 6.591025829

775.1 6.594652176 6.465183258

773.3666667 6.566460609 6.52535677

764.7 6.622210979 6.549603462

764.6 6.578211784 6.509164333

762.1666667 6.813189507 6.821391106

753.5666667 6.749520302 6.708824635

747.5666667 6.686508656 6.679447651

754.1 6.754495144 6.775161743

755.4 6.737399578 6.678332329

753.3833333 6.672959328 6.716574192

751.2666667 6.716510773 6.720412731

745.3166667 6.748220444 6.766312599

741.15 6.711113453 6.738305092

738.9666667 6.742999077 6.76053524

786.5833333 6.777443409 6.740606308

793.2666667 6.683755398 6.540208817

782.45 6.675864697 6.692183495

780.4666667 6.650847435 6.629446507

779.2333333 6.583468914 6.454388142

777.1666667 6.664205074 6.615596294

790.8166667 6.618670464 6.59303236

792.7833333 6.642311573 6.632897377

775.1666667 6.555968761 6.628685474

772.3833333 6.667939186 6.600167274

770.5833333 6.615022182 6.676578522

769.05 6.600512505 6.6259408

767.35 6.747199059 6.683105469

765.6666667 6.696483135 6.691697598
Sorbent Injection Rate (lb/hr)