Instructions for filling CEMS Information

This Information Collection Request (ICR) spreadsheet is intended to collect CEM data for CO, NO

and Oxidized). This spreadsheet is intended to be used for one boiler of one facility. Data for multiple boilers s

handled by using separate spreadsheets. Please name each resulting spreadsheet with the following naming co

[FacilityID]_Unit_[BoilerID]_CEMS.xls (example: 8100_Unit_2_CEMS.xls).

This spreadsheet is divided into several worksheets, which may be accessed by clicking on each of the tabs at the 

the page. Please begin with the Boiler Information tab, then proceed to the Hourly tab for a given constituent, an

the daily tab for the constituent. Yellow highlighted column headers mean that the field is required. Gray highlig

do not require data entry, as they are filled in automatically from the information that you input on the Boiler Info

worksheet. Green highlighting in a cell indicates that it should be populated using a dropPlease refer to the following steps when using this spreadsheet. CEM data for each constituent are collected on t

worksheet. Additionally, your are asked to provide boiler specific information about the control device configurat

fuel mix during the test .

Boiler Information

1. Please enter the the EIA Facility Code, Facility Name and Boiler ID of your boiler on the Boiler Information work

2. Please enter the typical control device configuration and operating rate used during the 30

Information worksheet in columns D and E.

3. Please enter information about the typical fuel mix for the boiler in columns F through U on the Boiler informa

worksheet. You may specify up to 4 different fuels used in the mix, using drop-down boxes, as well as fuel input r

units. The unit choices are contained in a drop-down box. If you choose "other" as your fuel, you must specify th

"Specify if Fuel is other" column.

4. If applicable, please enter Operational Upsets or other Important Conditions Occuring During 30 Day Period on 

Information worksheet in column V.

CEM Hourly Average Results

There are 4 hourly averge results worksheets in this spreadsheet, inlcuding CO, NOX, SO2, and Hg. There are 720 r

which you may enter data, one for each hour of a 30 day monitoring period. You must enter both the unit of me

this worksheet from your CEM readout and the converted values for both lb/MMBtu and ppmvd @ 7% O

that you are entering CO, NOX, SO2, and Hg data in the appropriate worksheets. As you scroll to the right on each 

screens, you will find text boxes, which expand as you type, requesting that you provide the equations/descriptio

process used to convert to both lb/MMBtu and ppmvd @ 7% O2.

1. In the red box, please provide the date and hour of each average, along with the converted values for both lb/

ppmvd @ 7% O2. Then provide the correction factor and , if applicable, the standard fuel F

2. In the top green box that is to the right of the spread sheet, please provide the equations and a narrative descr

necessary) that you used to convert from hourly units of measure to daily units of Measure (lb/MMBtu).

3. In the lower green box that is to the right of the spread sheet, please provide the equations and a narrative de

necessary) that you used to convert from hourly units of measure to daily units of Measure (ppmvd @ 7% O

CEM Daily Average Results
There are 4 daily averge results worksheets in this spreadsheet, inlcuding CO, NOX

, SO2, and Hg. The intent of this 

is for you to provide daily average data based on the hourly data that you provided for your boiler, in both lb/MM

ppmvd @ 7% O2. Please ensure that you are entering CO, NOX, SO2, and Hg data in the appropriate worksheets.

1. Please provide the date of each average, along with the converted values for both lb/MMBtu and ppmvd @ 7% 

2. Please provide the the correction factor and , if applicable, the standard fuel F-Factor.
EM data for CO, NOX, SO2, and Hg (Elemental 

 facility. Data for multiple boilers should be 

dsheet with the following naming convention: 

y clicking on each of the tabs at the bottom of 

ourly tab for a given constituent, and then to 

at the field is required. Gray highlighted cells 

tion that you input on the Boiler Information 

-down menu, which is provided. 

r each constituent are collected on their own 

 about the control device configuration and 

oiler on the Boiler Information worksheet.

ed during the 30-day test period on the Boiler 

s F through U on the Boiler information 

down boxes, as well as fuel input rate and 

er" as your fuel, you must specify the fuel in the

ns Occuring During 30 Day Period on the Boiler 

, and Hg. There are 720 rows for 

You must enter both the unit of measure on 

MMBtu and ppmvd @ 7% O2. Please ensure 

s. As you scroll to the right on each of these 

ou provide the equations/description of the 

th the converted values for both lb/MMBtu and 

andard fuel F-Factor.

 the equations and a narrative description (as 

ts of Measure (lb/MMBtu).

de the equations and a narrative description (as 

ts of Measure (ppmvd @ 7% O2).
, and Hg. The intent of this worksheet 

vided for your boiler, in both lb/MMBtu and 

ata in the appropriate worksheets.

or both lb/MMBtu and ppmvd @ 7% O2. 
EIA Facility Code Facility Name Boiler ID

San Juan Unit 3
Typical Control Device Configuration During 30 Day Test

Listed (by boiler) in the Configuration Order Section of the Facility Unit Configurations Section of 

the Electronic ICR
Typical Operating Rate 

During 30 Day Test 

(MMBtu/hr)

Typical Fuel Mix 

During 30 Day

Test: Fuel 1

Specify If Fuel 1 

is Other

Fuel 1 Input 

Rate

Fuel 1 Input 

Rate Units

Typical Fuel 

Mix During 

30 Day Test: 

Fuel 2

Specify If 

Fuel 2 is 

Other

subbituminous
Fuel 2 Input 

Rate

Fuel 2 Input 

Rate Units

Typical Fuel 

Mix During 

30 Day Test: 

Fuel 3

Specify If 

Fuel 3 is 

Other

Fuel 3 Input 

Rate

Fuel 3 Input 

Rate Units

Typical Fuel 

Mix During 

30 Day Test: 

Fuel 4

Specify If 

Fuel 4 is 

Other

Fuel 4 Input 

Rate
Fuel 4 Input 

Rate Units

List Operational Upsets or other Important 

Conditions Occuring During 30 Day Period
EIA Facility Code Facility Name Boiler ID

0 San Juan Unit 3

Date 

(MM/DD/YYYY)

Emission Value

(lb/MMBtu)

Emission Value

(ppmvd @ 7% O2)

Day 1 6/1/2010 0.287 144.4

Day 2 6/2/2010 0.291 145.7

Day 3 6/3/2010 0.286 154.5

Day 4 6/4/2010 0.289 164.2

Day 5 6/5/2010 0.293 148.9

Day 6 6/6/2010 0.287 126.9

Day 7 6/7/2010 0.289 174.4

Day 8 6/8/2010 0.289 166.1

Day 9 6/9/2010 0.300 148.0

Day 10 6/10/2010 0.295 151.8

Day 11 6/11/2010 0.285 142.7

Day 12 6/12/2010 0.285 185.4

Day 13 6/13/2010 0.231 202.3

Day 14 6/14/2010 0.246 183.9

Day 15 6/15/2010 0.289 156.7

Day 16 6/16/2010 0.211 160.5

Day 17 6/17/2010 0.284 156.0

Day 18 6/18/2010 0.284 160.3

Day 19 6/19/2010 0.281 154.2

Day 20 6/20/2010 0.293 157.7

Day 21 6/21/2010 0.278 151.3

Day 22 6/22/2010 0.276 158.6

Day 23 6/23/2010 0.278 153.1

Day 24 6/24/2010 0.280 185.3

Day 25 6/25/2010 0.289 38.0

Day 26 6/26/2010

Day 27 6/27/2010 0.267 157.6

Day 28 6/28/2010 0.266 122.1

Day 29 6/29/2010 0.265 125.8

Day 30 6/30/2010 0.260 149.6

Day 31 07/01/10 0.259 148.1

CEM Daily Average Emission Data Points for Most Recent 30 Day Averaging 

Nitrogen Oxides
Oxygen 

Content 

(%)

Standard Fuel FFactor 

(Fd, Fw, or Fc =.....)

7.05 9820

6.54 9820

5.97 9820

5.92 9820

6.40 9820

6.61 9820

6.29 9820

6.24 9820

5.83 9820

6.14 9820

5.80 9820

4.90 9820

6.63 9820

6.51 9820

6.46 9820

6.67 9820

6.31 9820

6.08 9820

6.03 9820

6.33 9820

5.90 9820

6.06 9820

5.97 9820

12.34 9820

20.53 9820

19.88 9820

7.74 9820

3.96 9820

5.99 9820

5.88 9820

r Most Recent 30 Day Averaging Period for 
EIA Facility Code Facility Name Boiler ID

0 San Juan Unit 3

Date (MM/DD/YYYY)

Emission Value

(lb/MMBtu)

Emission Value

(ppmvd @ 7% O2)*

Day 1 6/1/2010 0.031 36.3

Day 2 6/2/2010 0.029 44.9

Day 3 6/3/2010 0.037 39.6

Day 4 6/4/2010 0.023 38.0

Day 5 6/5/2010 0.036 42.8

Day 6 6/6/2010 0.061 33.2

Day 7 6/7/2010 0.050 41.2

Day 8 6/8/2010 0.034 40.1

Day 9 6/9/2010 0.043 40.7

Day 10 6/10/2010 0.034 46.1

Day 11 6/11/2010 0.037 82.0

Day 12 6/12/2010 0.033 34.5

Day 13 6/13/2010 0.020 35.7

Day 14 6/14/2010 0.023 35.2

Day 15 6/15/2010 0.033 48.9

Day 16 6/16/2010 0.032 37.2

Day 17 6/17/2010 0.036 43.5

Day 18 6/18/2010 0.039 44.1

Day 19 6/19/2010 0.038 45.6

Day 20 6/20/2010 0.032 39.3

Day 21 6/21/2010 0.049 39.0

Day 22 6/22/2010 0.031 35.3

Day 23 6/23/2010 0.027 35.1

Day 24 6/24/2010 0.026 -70.8

Day 25 6/25/2010 0.031 -35.2

Day 26 6/26/2010 0.033 -72.4

Day 27 6/27/2010 0.029 13.2

Day 28 6/28/2010 0.026 29.0

Day 29 6/29/2010 0.036 38.3

Day 30 6/30/2010 0.032 40.8

Day 31 07/01/10 0.081 37.5

CEM Daily Average Emission Data Points for Most Recent 30 Day Averaging 

Dioxide

Oxygen Content 

(%)

Standard Fuel FFactor 

(Fd, Fw, or Fc =.....)

7.05 9820

6.54 9820

5.97 9820

5.92 9820

6.40 9820

6.61 9820

6.29 9820

6.24 9820

5.83 9820

6.14 9820

5.80 9820

4.90 9820

6.63 9820

6.51 9820

6.46 9820

6.67 9820

6.31 9820

6.08 9820

6.03 9820

6.33 9820

5.90 9820

6.06 9820

5.97 9820

12.34 9820

20.53 9820

20.52 9820

19.88 9820

7.74 9820

3.96 9820

5.99 9820

5.88 9820

r Most Recent 30 Day Averaging Period for Sulfur 

* Note: To convert from a wet to a dry concentration value, EPA suggests th

method in Part 75 (i.e., Appendix A, section 2.1.5, the minimum potential m

measured value from the past). Also, the tester can calculate the concentra

percent O2 using the CO2 data. The tester can determine O

Method 3B, equation 3B-2 or part 75, appendix F, equation F

concentration value, EPA suggests the moisture approximation 

tion 2.1.5, the minimum potential moisture of 3.0 percent or a 

he tester can calculate the concentration in units of ppmvd@ 7 

ter can determine O2values from the CO2 measurements using 

ppendix F, equation F-14b (same equation algebraically).
EIA Facility Code Facility Name Boiler ID

0 San Juan Unit 3

Date 

(MM/DD/YYYY)

Daily Total Mercury (Hg0) 

Emission Value

(lb/MMBtu)

Day 1 6/1/2010 0.00000092

Day 2 6/2/2010 0.00000078

Day 3 6/3/2010 0.00000037

Day 4 6/4/2010 0.00000030

Day 5 6/5/2010

Day 6 6/6/2010

Day 7 6/7/2010 0.00000015

Day 8 6/8/2010 0.00000048

Day 9 6/9/2010 0.00000042

Day 10 6/10/2010 0.00000064

Day 11 6/11/2010 0.00000049

Day 12 6/12/2010 0.00000027

Day 13 6/13/2010 0.00000049

Day 14 6/14/2010 0.00000064

Day 15 6/15/2010 0.00000065

Day 16 6/16/2010 0.00000079

Day 17 6/17/2010 0.00000095

Day 18 6/18/2010 0.00000444

Day 19 6/19/2010 0.00000300

Day 20 6/20/2010 0.00000107

Day 21 6/21/2010 0.00000107

Day 22 6/22/2010 0.00000120

Day 23 6/23/2010 0.00000123

Day 24 6/24/2010

Day 25 6/25/2010

Day 26 6/26/2010

Day 27 6/27/2010

Day 28 6/28/2010 0.00000106

Day 29 6/29/2010 0.00000047

Day 30 6/30/2010 0.00000052

Day 31 07/01/10 0.00000030

CEM Daily Average Emission Data Points for Most Recent 30 Day Averagin
Daily Total Mercury (Hg0

) 

Emission Value

(ppmvd @ 7% O2)

Oxygen 

Content 

(%)

Standard Fuel FFactor 

(Fd, Fw, or Fc =.....)

0.000100 7.05 9820

0.000085 6.54 9820

0.000039 5.97 9820

0.000032 5.92 9820

0.000016 6.29 9820

0.000052 6.24 9820

0.000045 5.83 9820

0.000069 6.14 9820

0.000052 5.80 9820

0.000029 4.90 9820

0.000052 6.63 9820

0.000068 6.51 9820

0.000069 6.46 9820

0.000085 6.67 9820

0.000101 6.31 9820

0.000476 6.08 9820

0.000322 6.03 9820

0.000116 6.33 9820

0.000115 5.90 9820

0.000128 6.06 9820

0.000132 5.97 9820

0.000110 7.74 9820

0.000049 3.96 9820

0.000056 5.99 9820

0.000033 5.88 9820

Data Points for Most Recent 30 Day Averaging Period for Mercury