# 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 DVsLowered thresholds 80% -- to adjust threshold per a classification method suggested in docketThe national average 8-hour to 1-hour ozone design value ratio using 2008-2010 data is 0.80.CAA design valuethresholds 1-hourozone ppmPercent above 1-hour ozone NAAQS1Translated 8-hr DVthresholds (ppmozone) using Col D(in Classificationproposal for 2008NAAQS)80% of Col DTranslated 8-hr DVthresholds (ppmozone) using 80% ofCol D (in Classificationproposal for 2008NAAQS)AB C D E F Gfrom 0.121 NA 0.076 NA 0.076up to20.138 15 0.086 12 0.084From 0.138 15 0.086 12 0.084up to20.160 33.333 0.100 26.6664 0.095From 0.160 33.333 0.100 26.6664 0.095up to20.180 50 0.113 40 0.105From 0.180 50 0.113 40 0.105up to20.190 58.333 0.119 46.6664 0.110From 0.190 58.333 0.119 46.6664 0.110up to20.280 133.333 0.175 106.6664 0.155Extremeequal to or above 0.280 133.333 0.175 106.6664 0.155Severe-17Area ClassMarginalModerateSeriousSevere-15Lowered initial upper classification thresholds 5% -- to adjustthreshold per a classification method described in BIDCAA design valuethresholds 1-hourozone ppmPercent above 1-hourozone NAAQS1Primary 2008 8-hourozone value (ppm)Design values within 5% of thethreshold for the next higherclassificationArea classfrom 0.121 NA 0.076 0.076up to20.138 15 0.086 0.082From 0.138 15 0.086 0.082up to20.160 33.333 0.100 0.095From 0.160 33.333 0.100 0.095up to20.180 50 0.113 0.107From 0.180 50 0.113 0.107up to20.190 58.333 0.119 0.113From 0.190 58.333 0.119 0.113up to20.280 133.333 0.175 0.166equal to or above 0.280 133.333 0.175 0.166ExtremeArea ClassSevere-17MarginalModerateSeriousSevere-158-Hr 0zone NAAQS Hypothetical Nonattainment Areas That Could Be ReclassifiedUnder Either (1) CAA Section 181(A)(4)(5% Adjustment Provision) or byUsing the 80% Ratio of the 8-hr to 1-hr DVsReg #Hypothetical Area NameDesignValue 2008-2010 (ppm)Classification basedon “Percent-AboveStandard” ApproachClassification based on 80%adjusted “Percent-AboveStandard”75 ppbAreas Eligible for 5% bump upbased on “Percent-AboveStandard” Approach75 ppb3 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 Marginal4,6 Memphis, TN-AR - NAA 0.076 Marginal Marginal Marginal4 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 Marginal7,5 St. Louis, MO-IL - NAA 0.077 Marginal Marginal Marginal6 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 Marginal5,4 Cincinnati-Hamilton, OH-KY-IN - NAA 0.079 Marginal Marginal Marginal1 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 Marginal3,2 Philadelphia-Wilmin-Atlantic Ci,PA-NJ-MD-DE - NAA 0.083 Marginal Marginal Marginal6 Houston-Galveston-Brazoria, TX - NAA 0.084 Marginal Marginal Marginal9 Nevada Co. (Western Part), CA - NAA 0.084 Marginal Marginal Marginal2,1 New York-N. New Jersey-Long Island,NY-NJ-CT - NAA 0.084 Marginal Marginal Marginal9 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 SeriousEPA:Adjusting threshold lower by 80%would move W.Mojave fromModerate to SeriousEPA:1SeriousareacouldbumpuptoSeverebythe5%adjustmentprovisionEPA:2 Moderate areas could bump up toSerious by the 5% adjustmentprovisionEPA:9 Marginal areas could bump up toModerate by the 5% provision inSec 181(a)(4)