### 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 should be handled by using separate spreadsheets. Please name each resulting spreadsheet with the following naming convention: [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 bottom of the page. Please begin with the Boiler Information tab, then proceed to the Hourly tab for a given constituent, and then to the daily tab for the constituent. Yellow highlighted column headers mean that the field is required. Gray highlighted cell do not require data entry, as they are filled in automatically from the information that you input on the Boiler Information worksheet. Green highlighting in a cell indicates that it should be populated using a drop

Please refer to the following steps when using this spreadsheet. CEM data for each constituent are collected on their own worksheet. Additionally, your are asked to provide boiler specific information about the control device configuration and 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 worksheet. 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 information worksheet. You may specify up to 4 different fuels used in the mix, using drop

-down boxes, as well as fuel input rate and units. The unit choices are contained in a drop

-down box. If you choose "other" as your fuel, you must specify the fuel in the "Specify if Fuel is other" column. 4. If applicable, please enter Operational Upsets or other Important Conditions Occuring During 30 Day Period on the Boiler Information worksheet in column V.

CEM Hourly Average Results

There are 4 hourly averge results worksheets in this spreadsheet, inlcuding CO, NOX

### , SO 2

### , and Hg. There are 720 rows for which you may enter data, one for each hour of a 30 day monitoring period. You must enter both the unit of measure on this worksheet from your CEM readout and the converted values for both lb/MMBtu and ppmvd @ 7% O that you are entering CO, NOX

### , SO 2

### , and Hg data in the appropriate worksheets. As you scroll to the right on each of these
screens, you will find text boxes, which expand as you type, requesting that you provide the equations/description of the
process used to convert to both lb/MMBtu and ppmvd @ 7% O 2 

### . 1. In the red box, please provide the date and hour of each average, along with the converted values for both lb/MMBtu and ppmvd @ 7% O 2

### . 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 description ( 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 description 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

### , SO 2

### , and Hg. The intent of this worksheet

is for you to provide daily average data based on the hourly data that you provided for your boiler, in both lb/MMBtu and ppmvd @ 7% O 2

### . Please ensure that you are entering CO, NOX

### , SO 2

### , 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% O 2. Please provide the the correction factor and , if applicable, the standard fuel F

- Factor.

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

### , SO 2

### , and Hg (Elemental This spreadsheet is intended to be used for one boiler of one facility. Data for multiple boilers should be Please name each resulting spreadsheet with the following naming convention:

This spreadsheet is divided into several worksheets, which may be accessed by clicking on each of the tabs at the bottom of the page. Please begin with the Boiler Information tab, then proceed to the Hourly tab for a given constituent, and then to the daily tab for the constituent. Yellow highlighted column headers mean that the field is required. Gray highlighted cell s do not require data entry, as they are filled in automatically from the information that you input on the Boiler Information

-down menu, which is provided.

Please refer to the following steps when using this spreadsheet. CEM data for each constituent are collected on their own worksheet. Additionally, your are asked to provide boiler specific information about the control device configuration and

1. Please enter the the EIA Facility Code, Facility Name and Boiler ID of your boiler on the Boiler Information worksheet. 2. Please enter the typical control device configuration and operating rate used during the 30

-day test period on the Boiler

3. Please enter information about the typical fuel mix for the boiler in columns F through U on the Boiler information down boxes, as well as fuel input rate and down box. If you choose "other" as your fuel, you must specify the fuel in the

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

, and Hg. There are 720 rows for which you may enter data, one for each hour of a 30 day monitoring period. You must enter both the unit of measure on this worksheet from your CEM readout and the converted values for both lb/MMBtu and ppmvd @ 7% O 2

### . Please ensure , and Hg data in the appropriate worksheets. As you scroll to the right on each of these
screens, you will find text boxes, which expand as you type, requesting that you provide the equations/description of the

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

. Then provide the correction factor and , if applicable, the standard fuel F

- Factor. 2. In the top green box that is to the right of the spread sheet, please provide the equations and a narrative description (as 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 description (a s necessary) that you used to convert from hourly units of measure to daily units of Measure (ppmvd @ 7% O 2

### ).

### , and Hg. The intent of this worksheet is for you to provide daily average data based on the hourly data that you provided for your boiler, in both lb/MMBtu and , 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% O 2

### .EIA

Facility Code Facility Name Boiler ID

2451 San Juan Unit 4Typical Control Device Configuration During 30 Day Test

Listed (by

boiler) in the Configuration Order Section of the Facility Unit Configurations Section of the Electronic ICRTypical 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

4983 subbituminous 491000.00 lb/hourFuel 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

RateFuel 4 Input

Rate Units List Operational Upsets or other Important

Conditions Occuring During 30 Day PeriodEIA

Facility Code Facility Name Boiler ID 2451 San Juan Unit 4

Date (MM/DD/YYYY) Emission Value (lb/MMBtu) Emission Value

(ppmvd @ 7% O2) Day 1 4/21/2010 0.132 109.8 Day 2 4/22/2010 0.239 137.7 Day 3 4/23/2010 0.330 186.7 Day 4 4/24/2010 0.329 187.2 Day 5 4/25/2010 0.255 153.7 Day 6 4/26/2010 0.270 153.5 Day 7 4/27/2010 0.271 153.9 Day 8 4/28/2010 0.268 152.1 Day 9 4/29/2010 0.278 157.8 Day 10 4/30/2010 0.215 150.5 Day 11 5/1/2010 0.277 176.5 Day 12 5/2/2010 0.274 156.9 Day 13 5/3/2010 0.322 184.0 Day 14 5/4/2010 0.305 174.2 Day 15 5/5/2010 0.284 161.8 Day 16 5/6/2010 0.275 156.2 Day 17 5/7/2010 0.283 160.5 Day 18 5/8/2010 0.281 159.3 Day 19 5/9/2010 0.270 153.2 Day 20 5/10/2010 0.280 158.2 Day 21 5/11/2010 0.286 161.8 Day 22 5/12/2010 0.283 160.1 Day 23 5/13/2010 0.278 158.3 Day 24 5/14/2010 0.256 156.7 Day 25 5/15/2010 0.285 162.4 Day 26 5/16/2010 0.277 157.6 Day 27 5/17/2010 0.314 179.2 Day 28 5/18/2010 0.258 147.3 Day 29 5/19/2010 0.273 154.3 Day 30 5/20/2010 0.276 156.1 Day 31 5/21/2010 0.261 147.9 CEMDaily A

verage Emission Data Points for Most Recent 30 Day A veraging Period for Nitrogen OxidesOxygen

Content (%) Standard Fuel FFactor (Fd, Fw, or Fc =.....) 6.61 9820 4.94 9820 4.46 9820 4.54 9820 4.91 9820 4.60 9820 4.53 9820 4.35 9820 4.62 9820 5.16 9820 5.09 9820 4.62 9820 4.62 9820 4.74 9820 5.01 9820 4.95 9820 4.99 9820 4.89 9820 4.63 9820 4.70 9820 4.88 9820 4.89 9820 4.91 9820 5.67 9820 5.18 9820 5.28 9820 5.25 9820 5.54 9820 5.83 9820 5.82 9820 5.43 9820 CEMDaily A

verage Emission Data Points for Most Recent 30 Day A veraging Period forEIA

Facility Code Facility Name Boiler ID 2451 San Juan Unit 4

Date (MM/DD/YYYY) Emission Value (lb/MMBtu) Emission Value

(ppmvd @ 7% O2)* Day 1 4/21/2010 0.014 9.4 Day 2 4/22/2010 0.041 20.9 Day 3 4/23/2010 0.048 24.8 Day 4 4/24/2010 0.047 24.7 Day 5 4/25/2010 0.043 33.1 Day 6 4/26/2010 0.064 30.3 Day 7 4/27/2010 0.109 47.8 Day 8 4/28/2010 0.118 51.6 Day 9 4/29/2010 0.054 30.5 Day 10 4/30/2010 0.026 21.4 Day 11 5/1/2010 0.059 34.4 Day 12 5/2/2010 0.079 35.7 Day 13 5/3/2010 0.058 27.7 Day 14 5/4/2010 0.054 26.9 Day 15 5/5/2010 0.080 36.8 Day 16 5/6/2010 0.096 43.1 Day 17 5/7/2010 0.078 35.2 Day 18 5/8/2010 0.079 35.9 Day 19 5/9/2010 0.079 35.5 Day 20 5/10/2010 0.085 38.0 Day 21 5/11/2010 0.062 29.0 Day 22 5/12/2010 0.092 41.8 Day 23 5/13/2010 0.080 36.6 Day 24 5/14/2010 0.020 13.3 Day 25 5/15/2010 0.045 22.7 Day 26 5/16/2010 0.043 21.7 Day 27 5/17/2010 0.024 14.2 Day 28 5/18/2010 0.026 15.1 Day 29 5/19/2010 0.039 20.1 Day 30 5/20/2010 0.037 19.6 Day 31 5/21/2010 0.046 23.08 CEMDaily A

verage Emission Data Points for Most Recent 30 Day A veraging Period for Sulfur DioxideOxygen Content

(%) Standard Fuel FFactor (Fd, Fw, or Fc =.....)
6.61 9820
4.94 9820
4.46 9820
4.54 9820
4.91 9820
4.60 9820
4.53 9820
4.35 9820
4.62 9820
5.16 9820
5.09 9820
4.62 9820
4.62 9820
4.74 9820
5.01 9820
4.95 9820
4.99 9820
4.89 9820
4.63 9820
4.70 9820
4.88 9820
4.89 9820
4.91 9820
5.67 9820
5.18 9820
5.28 9820
5.25 9820
5.54 9820
5.83 9820
5.82 9820 5.43 9820 CEMDaily A

verage Emission Data Points for Most Recent 30 Day A veraging Period for Sulfur 

### * Note: To convert from a wet to a dry concentration value, EPA suggests the moisture approximation method in Part 75 (i.e., Appendix A, section 2.1.5, the minimum potential moisture of 3.0 percent or a measured value from the past). Also, the tester can calculate the concentration in units of ppmvd@ 7 percent O 2 

### using the CO 2 

### data. The tester can determine O Method 3B, equation 3B

-2 or part 75, appendix F, equation F

### * Note: To convert from a wet to a dry concentration value, EPA suggests the moisture approximation method in Part 75 (i.e., Appendix A, section 2.1.5, the minimum potential moisture of 3.0 percent or a the tester can calculate the concentration in units of ppmvd@ 7 data. The tester can determine O 2 

### values from the CO 2 

### measurements using 2 or part 75, appendix F, equation F

- 14b (same equation algebraically).EIA

Facility Code Facility Name Boiler ID 2451 San Juan Unit 4

Date (MM/DD/YYYY) Daily Total Mercury (Hg 0) Emission Value (lb/MMBtu) Day 1 4/21/2010 Day 2 4/22/2010 0.00000044 Day 3 4/23/2010 0.00000080 Day 4 4/24/2010 0.00000052 Day 5 4/25/2010 0.00000034 Day 6 4/26/2010 0.00000052 Day 7 4/27/2010 0.00000034 Day 8 4/28/2010 0.00000029 Day 9 4/29/2010 0.00000099 Day 10 4/30/2010 Day 11 5/1/2010 0.00000120 Day 12 5/2/2010 0.00000003 Day 13 5/3/2010 0.00000015 Day 14 5/4/2010 -0.00000006 Day 15 5/5/2010 -0.00000006 Day 16 5/6/2010 0.00000075 Day 17 5/7/2010 0.00000115 Day 18 5/8/2010 0.00000095 Day 19 5/9/2010 0.00000074 Day 20 5/10/2010 0.00000062 Day 21 5/11/2010 0.00000116 Day 22 5/12/2010 0.00000092 Day 23 5/13/2010 0.00000037 Day 24 5/14/2010 Day 25 5/15/2010 0.00000029 Day 26 5/16/2010 0.00000032 Day 27 5/17/2010 0.00000022 Day 28 5/18/2010 0.00000023 Day 29 5/19/2010 0.00000016 Day 30 5/20/2010 0.00000003 Day 31 5/21/2010 0.00000015 CEMDaily A

verage Emission Data Points for Most Recent 30 Day A veraging Period for MercuryDaily Total Mercury (Hg 0)

Emission Value (ppmvd @ 7% O2) Oxygen Content (%) Standard Fuel FFactor (Fd, Fw, or Fc =.....)

0.000050 4.94 9820 0.000090 4.46 9820 0.000064 4.54 9820 0.000031 4.91 9820 0.000058 4.60 9820 0.000038 4.53 9820 0.000032 4.35 9820 0.000110 4.62 9820

0.000046 5.09 9820 0.000012 4.62 9820 0.000019 4.62 9820 0.000013 4.74 9820 0.000015 5.01 9820 0.000084 4.95 9820 0.000129 4.99 9820 0.000106 4.89 9820 0.000082 4.63 9820 0.000095 4.70 9820 0.000129 4.88 9820 0.000107 4.89 9820 0.000041 4.91 9820

0.000032 5.18 9820 0.000036 5.28 9820 0.000027 5.25 9820 0.000026 5.54 9820 0.000020 5.83 9820 0.000012 5.82 9820 0.000024 5.43 9820 CEMDaily A

verage Emission Data Points for Most Recent 30 Day A veraging Period for Mercury