Spreadsheet Information

This spreadsheet provides information on 2 options for adjusting the classification table for the 2008 

standard. The 2 options are presented in BACKGROUND INFORMATION DOCUMENT -- ADDITIONAL 

OPTIONS CONSIDERED FOR CLASSIFICATION OF NONATTAINMENT AREAS UNDER THE 2008 

OZONE NAAQS

The spreadsheet uses hypothetical nonattainment areas per the information in the Background Information 

Document - Development of Hypothetical Nonattainment Areas for Illustrating Proposed Classification 

Thresholds for Areas Designated Nonattainment for the 2008 0.075 ppm 8-hour Ozone National Ambient Air 

Quality Standard. January 2012, Docket ID No. EPA-HQ-OAR-2010-0885.

The option considerations are based on 2008-2010 ozone design values for the 2 classification options

The 80% adjusted threshold analysis is the method in the BID labeled -- 2. Adjustment of the percentages 

above the standard used to set the classification thresholds. 

The 5% provision thresholds analysis is the method in the BID labeled -- 9. Administrator’s Discretion To 

Reclassify Areas Under 5 Percent Bump-Up Authority Concept.

Worksheets

80% adjusted thresholds- The worksheet contains ozone design value threshold ranges for the percentabove-standard adjusted 80%. The 80% adjustment is the ratio of the 2008-2010 8-hr ozone design value 

period. The docket has the 2 DV tables available with the data for the 8-hr to 1-hr ratios for 2003-2005 and 

2008-2010. The files are titled - "Table showing the ratio of Ozone 8-Hour Design Values-to-Ozone 1-Hour 

Design Values for the period 2003-2005 at Air Quality Monitoring sites" and "Table showing the ratio of 

Ozone 8-Hour Design Values-to-Ozone 1-Hour Design Values for the period 2008-2010 at Air Quality 

Monitoring sites"

5% provision thresholds- The worksheet contains ozone design value threshold ranges for the percentabove-standard adjusted the design value within 5% of the upper threshold for each classification. The 

Administrator has discretion to use section 181(a)(4) to place areas that have design values that are within 

5% of the upper threshold of their initial classification into the next higher classification. 

areas class with adj thresholds ‐ The worksheet contains the hypothetical areas classification based on the

adjusted thresholds from the 2 classification options considered. The table has the results for the 8‐Hr 03

NAAQS Hypothetical Nonattainment Areas That Could Be Reclassified Under Either (1) CAA Section

181(A)(4) (5% Adjustment Provision) or by using the 80% ratio of the 8‐hr to 1‐hr DVs
Lowered thresholds 80% -- to adjust threshold per a classification method sugges

The national average 8-hour to 1-hour ozone design value ratio using 2008-2010 

CAA design value 

thresholds 1-hour 

ozone ppm

Percent above 1-

hour ozone NAAQS1

Translated 8-hr DV 

thresholds (ppm 

ozone) using Col D 

(in Classification 

proposal for 2008 

NAAQS)

80% of Col D 

AB C D E F 

from 0.121 NA 0.076 NA up to2 0.138 15 0.086 12 

From 0.138 15 0.086 12 up to2 0.160 33.333 0.100 26.6664 From 0.160 33.333 0.100 26.6664 up to2 0.180 50 0.113 40 From 0.180 50 0.113 40 up to2 0.190 58.333 0.119 46.6664 From 0.190 58.333 0.119 46.6664 up to2 0.280 133.333 0.175 106.6664 

Extreme equal to or above 0.280 133.333 0.175 106.6664 Severe-17

Area Class

MarginalModerateSeriousSevere-15
Lowered initial upper classification thresholds 5% -- to adjust

 threshold per a classification method described in BID

CAA design value 

thresholds 1-hour 

ozone ppm

Percent above 1-hour 

ozone NAAQS1

Primary 2008 8-hour 

ozone value (ppm)

Design valu

threshold 

cla

Area class from 0.121 NA 0.076 

up to2 0.138 15 0.086 

From 0.138 15 0.086 up to2 0.160 33.333 0.100 From 0.160 33.333 0.100 up to2 0.180 50 0.113 From 0.180 50 0.113 up to2 0.190 58.333 0.119 From 0.190 58.333 0.119 up to2 0.280 133.333 0.175 equal to or above 0.280 133.333 0.175 

Extreme

Area Class

Severe-17

Marginal

ModerateSeriousSevere-15
8-Hr 0zone NAAQS Hypothetical Nonattainment Areas That Could Be Reclassified 

Under Either (1) CAA Section 181(A)(4) (5% Adjustment Provision) or by 

Using the 80% Ratio of the 8-hr to 1-hr DVs

Reg # Hypothetical Area Name

Design 

Value 2008-

2010 (ppm)

Classification based 

on “Percent-AboveStandard” Approach

Classification based on 80% 

adjusted “Percent-AboveStandard” 

75 ppb

Areas Eligible for 5% bump up 

based on “Percent-AboveStandard” Approach

75 ppb

3 Allentown-Bethlehem-Easton, PA - NAA 0.076 Marginal Marginal Marginal4 Greensboro--Winston-Salem--High Point, NC - CSA 0.076 Marginal Marginal Marginal4 Greenville-Spartanburg-Anderson, SC - CSA 0.076 Marginal Marginal Marginal4 Gulfport-Biloxi-Pascagoula, MS - CSA 0.076 Marginal Marginal Marginal9 Las Vegas, NV - NAA 0.076 Marginal Marginal Marginal

4,6 Memphis, TN-AR - NAA 0.076 Marginal Marginal Marginal

4 Nashville-Davidson--Murfreesboro--Columbia, TN - CSA 0.076 Marginal Marginal Marginal1 Providence (All RI), RI - NAA 0.076 Marginal Marginal Marginal3 Richmond-Petersburg, VA - NAA 0.076 Marginal Marginal Marginal9 Santa Barbara-Santa Maria-Goleta, CA - CBSA 0.076 Marginal Marginal Marginal9 Sutter Co (Sutter Buttes), CA - NAA 0.076 Marginal Marginal Marginal5 Cleveland-Akron-Lorain, OH - NAA 0.077 Marginal Marginal Marginal5 Columbus, OH - NAA 0.077 Marginal Marginal Marginal2 Jamestown, NY - NAA 0.077 Marginal Marginal Marginal4 Knoxville, TN - NAA 0.077 Marginal Marginal Marginal3 Lancaster, PA - NAA 0.077 Marginal Marginal Marginal9 Phoenix-Mesa, AZ - NAA 0.077 Marginal Marginal Marginal1 Springfield (Western MA), MA - NAA 0.077 Marginal Marginal Marginal

7,5 St. Louis, MO-IL - NAA 0.077 Marginal Marginal Marginal

6 Baton Rouge, LA - NAA 0.078 Marginal Marginal Marginal1 Boston-Lawrence-Worcester (E. Mass), MA - NAA 0.078 Marginal Marginal Marginal8 Denver-Boulder-Greeley-Ft Collins-Love., CO - NAA 0.078 Marginal Marginal Marginal9 Imperial Co, CA - NAA 0.078 Marginal Marginal Marginal5 Sheboygan, WI - NAA 0.078 Marginal Marginal Marginal8 Sublette County, WY - COUNTY 0.078 Marginal Marginal Marginal9 Chico, CA - NAA 0.079 Marginal Marginal Marginal

5,4 Cincinnati-Hamilton, OH-KY-IN - NAA 0.079 Marginal Marginal Marginal

1 Greater Connecticut, CT - NAA 0.079 Marginal Marginal Marginal3 Reading, PA - NAA 0.079 Marginal Marginal Marginal4 Atlanta, GA - NAA 0.08 Marginal Marginal Marginal9 Red Bluff, CA - CBSA 0.08 Marginal Marginal Marginal9 San Francisco Bay Area, CA - NAA 0.08 Marginal Marginal Marginal3 Pittsburgh-Beaver Valley, PA - NAA 0.081 Marginal Marginal Marginal3 Washington, DC-MD-VA - NAA 0.081 Marginal Marginal Marginal4 Charlotte-Gastonia-Rock Hill, NC-SC - NAA 0.082 Marginal Marginal Marginal9 Amador and Calaveras Cos (Central Mtn), CA - NAA 0.083 Marginal Marginal Marginal9 Kern Co (Eastern Kern), CA - NAA 0.083 Marginal Marginal Marginal9 Mariposa and Tuolumne Cos (Southern Mtn),CA - NAA 0.083 Marginal Marginal Marginal

3,2 Philadelphia-Wilmin-Atlantic Ci,PA-NJ-MD-DE - NAA 0.083 Marginal Marginal Marginal

6 Houston-Galveston-Brazoria, TX - NAA 0.084 Marginal Marginal Marginal9 Nevada Co. (Western Part), CA - NAA 0.084 Marginal Marginal Marginal

2,1 New York-N. New Jersey-Long Island,NY-NJ-CT - NAA 0.084 Marginal Marginal Marginal

9 San Luis Obispo-Paso Robles, CA - CBSA 0.084 Marginal Marginal Marginal6 Dallas-Fort Worth, TX - NAA 0.086 Moderate Moderate Moderate9 Ventura Co, CA - NAA 0.086 Moderate Moderate Moderate9 San Diego, CA - NAA 0.088 Moderate Moderate Moderate3 Baltimore, MD - NAA 0.089 Moderate Moderate Moderate9 Riverside Co, (Coachella Valley), CA - NAA 0.095 Moderate Moderate Moderate9 Los Angeles-San Bernardino Cos(W Mojave),CA - NAA 0.099 Moderate Serious Moderate9 Sacramento Metro, CA - NAA 0.102 Serious Serious Serious9 San Joaquin Valley, CA - NAA 0.104 Serious Serious Serious9 Los Angeles South Coast Air Basin, CA - NAA 0.112 Serious Serious Serious

EPA:Adjusting threshold lower by 80% would move W.Mojave from Moderate to Serious

EPA:1 Serious area 

Severe by the 

provisionEPA:2 Moderate Serious by thprovision

EPA:9 Marginal aModerate by Sec 181(a)(4