# Attachment O

Base G4

Attainment Demonstration Data

2009 Best & Final Emission

Inventory

# Key

Ozone site only -- No PM data -- not SMAT dat a

Site omitted per state recommendation

2005 not yet available -- incomplete calculatio n

Modeled CY and FY data filled in by Enviro n

NH4 DON*so4 + .29*no3 ; where DON is the degree of neutralization = NH4/SO4; and was aquired

from the SMAT tool

PBW Particle Bound Water =

(-0.002618) + (0.980314*nh4) + (-0.260011*no3) + (-0.000784*so4)+ (-0.159452*nh4^2) + (-

0.356957*no3*nh4) + (0.153894*no3^2)+ (0.212891*so4*nh4) + (0.044366*so4*no3) + (-

0.048352*so4^2)

Sheets Description

Sites_used_SMAT Information on the sites as gathered from the SMAT tool. Includes DON and % compostions for

each quarter

Sites_used_PM_DVC Inforation used to calculate the DVC -- this is where ARS would add any new PM data

CY modeled - PM Environ entered the component data from model for base year/current year (CY-2002gt2a);

formulas calculate NH4 and PBW

FY modeled - PM Environ added the component data from the model for future year (FY -2009g4a) to the Red

highlighted columns; Yellow columns are calcualted

RRF-DVF_data Calculates the needed RRFs and DVFs;Sited_used_SMATAIRS ID State County Pollutant(s) Site Name City Name County Name MSA Latitude Longitude47-009-0011TNBlount PM2.5 Maryville Blount Knoxville,TN 35.77 -83.9447-093-0028TNKnox PM2.5 Knoxville Knox Knoxville,TN 35.94 -84.0447-093-1013TNKnox PM2.5 Knoxville Knox Knoxville,TN 35.98 -83.9347-093-1017TNKnox PM2.5 Knoxville Knox Knoxville,TN 35.98 -83.9547-093-1020TNKnox O3 and PM2.5 Knoxville Knox Knoxville,TN 36.02 -83.8747-105-0108TNLoudon O3 and PM2.5 Loudon Loudon Knoxville,TN 35.74 -84.3247-145-0004TNRoane PM2.5 Harriman Roane 35.94 -84.54Page 2 of 32Sited_used_SMATAIRS ID State County Pollutant(s)47-009-0011TNBlount PM2.547-093-0028TNKnox PM2.547-093-1013TNKnox PM2.547-093-1017TNKnox PM2.547-093-1020TNKnox O3 and PM2.547-105-0108TNLoudon O3 and PM2.547-145-0004TNRoane PM2.5AIRS ID Speciated profile in SMAT 3 yrs of data O33 yrs of dataPM2547-009-0011 YESUsed for PM onlyYES47-093-0028 YESUsed for PM onlyYES47-093-1013 Use 47-093-1020 profile,Used for PM only2004 incomplete47-093-1017 YESUsed for PM onlyYES47-093-1020 YES YES YES47-105-0108 Use 47-093-1020 profile,no data 2003 2003 incomplete47-145-0004 YESUsed for PM onlyYESPage 3 of 32Sited_used_SMATAIRS ID State County Pollutant(s)47-009-0011TNBlount PM2.547-093-0028TNKnox PM2.547-093-1013TNKnox PM2.547-093-1017TNKnox PM2.547-093-1020TNKnox O3 and PM2.547-105-0108TNLoudon O3 and PM2.547-145-0004TNRoane PM2.5Verified byStateSite/ParameterShut Down blank qtr donQ1 frac. Crustal frac. EC Frac OC frac.SO4USE 0.5 1 0.2894 0.01993726 0.03987 0.581341 0.217497USE 0.5 1 0.2894 0.017059553 0.03412 0.641769 0.186104DO NOT USE PM2.5 0.5 1 0.28777 0.020411215 0.04632 0.591565 0.204112USE 0.5 1 0.2894 0.016424797 0.03285 0.655099 0.17918USE 0.5 1 0.28777 0.020411215 0.04632 0.591565 0.204112USE 0.5USE 0.5 1 0.28854 0.02401104 0.04802 0.496606 0.249893Page 4 of 32Sited_used_SMATAIRS ID State County Pollutant(s)47-009-0011TNBlount PM2.547-093-0028TNKnox PM2.547-093-1013TNKnox PM2.547-093-1017TNKnox PM2.547-093-1020TNKnox O3 and PM2.547-105-0108TNLoudon O3 and PM2.547-145-0004TNRoane PM2.5frac NO3 frac NH4 frac H2O Q donQ2 frac. Crustal frac. EC Frac OC frac.SO4 frac NO30.013594 0.066886 0.06087 2 0.29103 0.045003934 0.03 0.420343 0.319801 0.0006820.011632 0.057232 0.052085 2 0.29103 0.043969676 0.02931 0.433664 0.312451 0.0006660.017271 0.063746 0.056577 2 0.29476 0.040538721 0.03282 0.445519 0.303075 0.0006430.011199 0.055102 0.050147 2 0.29103 0.041886629 0.02792 0.460494 0.297649 0.0006350.017271 0.063746 0.056577 2 0.29476 0.040538721 0.03282 0.445519 0.303075 0.0006430.031125 0.08113 0.069212 2 0.29827 0.05551858 0.03389 0.383449 0.330227 0.000721Page 5 of 32Sited_used_SMATAIRS ID State County Pollutant(s)47-009-0011TNBlount PM2.547-093-0028TNKnox PM2.547-093-1013TNKnox PM2.547-093-1017TNKnox PM2.547-093-1020TNKnox O3 and PM2.547-105-0108TNLoudon O3 and PM2.547-145-0004TNRoane PM2.5frac NH4 frac H2O Q donQ3 frac. Crustal frac. EC Frac OC frac.SO4 frac NO3 frac NH40.093269 0.090898 3 0.27318 0.038482759 0.02298 0.313222 0.4099483 0.000534 0.1121450.091126 0.088809 3 0.27318 0.038187845 0.02281 0.318486 0.4068066 0.00053 0.1112850.089521 0.087885 3 0.27351 0.029368248 0.02311 0.399891 0.3586778 0.000481 0.0982420.086809 0.084602 3 0.27318 0.034244456 0.02045 0.388861 0.3647986 0.000476 0.0997940.089521 0.087885 3 0.27351 0.029368248 0.02311 0.399891 0.3586778 0.000481 0.0982420.098706 0.09749 3 0.28146 0.052046263 0.02776 0.256028 0.4285142 0.000578 0.120777Page 6 of 32Sited_used_SMATAIRS ID State County Pollutant(s)47-009-0011TNBlount PM2.547-093-0028TNKnox PM2.547-093-1013TNKnox PM2.547-093-1017TNKnox PM2.547-093-1020TNKnox O3 and PM2.547-105-0108TNLoudon O3 and PM2.547-145-0004TNRoane PM2.5frac H2O Q donQ4 frac. Crustal frac. EC Frac OC frac.SO4 frac NO3 frac NH4 frac H2O0.102685 4 0.27378 0.026580035 0.0443 0.477774 0.277318 0.020378 0.081834 0.0718150.101898 4 0.27378 0.023213825 0.03869 0.543911 0.242198 0.017797 0.07147 0.062720.090231 4 0.27255 0.021746376 0.05324 0.486635 0.260207 0.031495 0.080053 0.0666230.091375 4 0.27378 0.022523912 0.03754 0.557466 0.234999 0.017268 0.069346 0.0608560.090231 4 0.27255 0.021746376 0.05324 0.486635 0.260207 0.031495 0.080053 0.0666230.114298 4 0.28405 0.032684426 0.05249 0.373195 0.31793 0.036646 0.100936 0.086116Page 7 of 32Sited_used_PM_DVCAIRS ID State County Pollutant(s) Site Name City Name County Name MSA47-009-0011TNBlount PM2.5 Maryville Blount Knoxville,TN47-093-0028TNKnox PM2.5 Knoxville Knox Knoxville,TN47-093-1013TNKnox PM2.5 Knoxville Knox Knoxville,TN47-093-1017TNKnox PM2.5 Knoxville Knox Knoxville,TN47-093-1020TNKnox O3 and PM2.5 Knoxville Knox Knoxville,TN47-105-0108TNLoudon O3 and PM2.5 Loudon Loudon Knoxville,TN47-145-0004TNRoane PM2.5 Harriman RoanePage 8 of 32Sited_used_PM_DVCAIRS ID State County Pollutant(s)47-009-0011TNBlount PM2.547-093-0028TNKnox PM2.547-093-1013TNKnox PM2.547-093-1017TNKnox PM2.547-093-1020TNKnox O3 and PM2.547-105-0108TNLoudon O3 and PM2.547-145-0004TNRoane PM2.5Latitude Longitude AIRS IDSpeciated profile inSMAT 3 yrs of data O335.768333 -83.942222 47-009-0011 YESUsed for PM only35.943611 -84.038889 47-093-0028 YESUsed for PM only35.98055 -83.93277 47-093-1013 NOUsed for PM only35.975 -83.954444 47-093-1017 YESUsed for PM only36.01944 -83.87361 47-093-1020 YES YES35.7447 -84.3174 47-105-0108 NOno data 200335.9386 -84.5438 47-145-0004 YESUsed for PM onlyPage 9 of 32Sited_used_PM_DVCAIRS ID State County Pollutant(s)47-009-0011TNBlount PM2.547-093-0028TNKnox PM2.547-093-1013TNKnox PM2.547-093-1017TNKnox PM2.547-093-1020TNKnox O3 and PM2.547-105-0108TNLoudon O3 and PM2.547-145-0004TNRoane PM2.53 yrs of dataPM25Verified byStateSite/ParameterShut Down2000 - Q1 2000 - Q2 2000 - Q3YES USE 18.959 17.214YES USE 16.552 17.933 18.3292004 incomplete DO NOT USE PM2.5YES USE 18.651 19.883 20.717YES USE 15.389 18.315 19.0902003 incompleteUSEYES USE 14.550 15.876 16.907Page 10 of 32Sited_used_PM_DVCAIRS ID State County Pollutant(s)47-009-0011TNBlount PM2.547-093-0028TNKnox PM2.547-093-1013TNKnox PM2.547-093-1017TNKnox PM2.547-093-1020TNKnox O3 and PM2.547-105-0108TNLoudon O3 and PM2.547-145-0004TNRoane PM2.52000 - Q4 2001 - Q1 2001 - Q2 2001 - Q3 2001 - Q4 2002 - Q1 2002 - Q2 2002 - Q318.579 15.353 14.873 18.452 11.011 11.535 15.165 19.21019.815 13.921 16.553 20.471 11.904 13.396 15.510 19.35417.367 20.45420.412 14.999 17.720 21.533 15.572 13.894 16.257 21.52519.553 15.299 18.529 20.528 13.521 13.238 16.041 21.27120.335 12.383 16.361 20.761 11.404 11.745 14.369 17.792Page 11 of 32Sited_used_PM_DVCAIRS ID State County Pollutant(s)47-009-0011TNBlount PM2.547-093-0028TNKnox PM2.547-093-1013TNKnox PM2.547-093-1017TNKnox PM2.547-093-1020TNKnox O3 and PM2.547-105-0108TNLoudon O3 and PM2.547-145-0004TNRoane PM2.52002 - Q4 2003 - Q1 2003 - Q2 2003 - Q3 2003 - Q4 2004 - Q1 2004 - Q2 2004 - Q311.787 11.686 14.393 18.850 10.635 10.326 14.087 17.43213.423 12.960 15.262 18.313 10.883 10.978 14.679 17.41112.740 14.385 16.400 20.589 12.743 11.75013.819 12.807 14.813 21.460 12.979 13.400 14.918 18.35513.836 12.014 13.363 19.826 11.961 12.488 14.642 19.48311.285 15.960 19.27010.597 10.900 12.174 19.186 10.969 9.970 15.296 18.048Page 12 of 32Sited_used_PM_DVCAIRS ID State County Pollutant(s)47-009-0011TNBlount PM2.547-093-0028TNKnox PM2.547-093-1013TNKnox PM2.547-093-1017TNKnox PM2.547-093-1020TNKnox O3 and PM2.547-105-0108TNLoudon O3 and PM2.547-145-0004TNRoane PM2.52004 - Q4 2005 - Q1 2005 - Q2 2005 - Q3 2005 - Q4 2000-2002 Q1 2000-2002 Q212.147 13.444 16.33212.417 14.623 16.66617.36713.687 15.848 17.95313.048 14.642 17.62812.16712.837 12.893 15.535Page 13 of 32Sited_used_PM_DVCAIRS ID State County Pollutant(s)47-009-0011TNBlount PM2.547-093-0028TNKnox PM2.547-093-1013TNKnox PM2.547-093-1017TNKnox PM2.547-093-1020TNKnox O3 and PM2.547-105-0108TNLoudon O3 and PM2.547-145-0004TNRoane PM2.52000-2002 Q3 2000-2002 Q4 2001-2003 Q1 2001-2003 Q2 2001-2003 Q3 2001-2003 Q418.292 13.792 12.858 14.811 18.837 11.14419.385 15.047 13.426 15.775 19.380 12.07020.454 12.740 14.385 16.883 20.521 12.74121.258 16.601 13.900 16.263 21.506 14.12320.296 15.636 13.517 15.978 20.542 13.10618.487 14.112 11.676 14.301 19.246 10.990Page 14 of 32Sited_used_PM_DVCAIRS ID State County Pollutant(s)47-009-0011TNBlount PM2.547-093-0028TNKnox PM2.547-093-1013TNKnox PM2.547-093-1017TNKnox PM2.547-093-1020TNKnox O3 and PM2.547-105-0108TNLoudon O3 and PM2.547-145-0004TNRoane PM2.52002-2004 Q1 2002-2004 Q2 2002-2004 Q3 2002-2004 Q4 2003-2005 Q1 2003-2005 Q211.182 14.548 18.497 11.523 11.006 14.24012.445 15.151 18.359 12.241 11.969 14.97113.067 16.883 20.521 12.741 13.067 16.40013.367 15.329 20.447 13.495 13.104 14.86512.580 14.682 20.193 12.948 12.251 14.00311.285 15.960 19.270 12.167 11.285 15.96010.872 13.946 18.342 11.468 10.435 13.735Page 15 of 32Sited_used_PM_DVCAIRS ID State County Pollutant(s)47-009-0011TNBlount PM2.547-093-0028TNKnox PM2.547-093-1013TNKnox PM2.547-093-1017TNKnox PM2.547-093-1020TNKnox O3 and PM2.547-105-0108TNLoudon O3 and PM2.547-145-0004TNRoane PM2.52003-2005 Q3 2003-2005 Q4 2000-2004 Q1 2000-2004 Q2 2000-2004 Q3 2000-2004 Q418.141 11.391 11.995 14.730 18.042 11.65317.862 11.650 12.998 15.364 18.541 12.62020.589 12.743 13.226 16.544 19.999 12.24119.908 13.333 13.872 16.015 20.570 14.24019.654 12.504 13.080 15.596 19.844 13.39719.270 12.167 10.785 15.460 18.770 11.66718.617 11.903 11.313 14.094 18.192 11.690Page 16 of 32Sited_used_PM_DVCAIRS ID State County Pollutant(s)47-009-0011TNBlount PM2.547-093-0028TNKnox PM2.547-093-1013TNKnox PM2.547-093-1017TNKnox PM2.547-093-1020TNKnox O3 and PM2.547-105-0108TNLoudon O3 and PM2.547-145-0004TNRoane PM2.5# Q used192082020420Page 17 of 32CY modeled - PMAIRS ID StateCountyPollutant(s)Crustal EC OC SO4 NO3 Crustal EC OC47-009-0011TNBlount PM2.52.2075 0.5429 2.6069 2.3923 1.2188 1.6438 0.3564 3.119547-093-0028TNKnox PM2.52.1038 0.6328 2.6089 2.4472 1.4701 1.7129 0.4669 3.289847-093-1017TNKnox PM2.52.1716 0.6177 2.5562 2.4299 1.4143 1.7173 0.4407 3.193947-093-1020TNKnox O3 and PM2.51.8081 0.5864 2.4076 2.3976 1.4849 1.4059 0.4312 3.115547-105-0108TNLoudon O3 and PM2.51.7759 0.4886 2.6714 2.4011 1.4274 1.2996 0.3268 3.390647-145-0004TNRoane PM2.51.4830 0.3845 2.4494 2.2909 1.2631 1.0573 0.2452 2.9968Q1 Q2Page 18 of 32CY modeled - PMAIRS ID StateCountyPollutant(s)47-009-0011TNBlount PM2.547-093-0028TNKnox PM2.547-093-1017TNKnox PM2.547-093-1020TNKnox O3 and PM2.547-105-0108TNLoudon O3 and PM2.547-145-0004TNRoane PM2.5SO4 NO3 Crustal EC OC SO4 NO3 Crustal4.1760 0.3716 1.8627 0.4138 4.3430 7.1444 0.0314 2.66734.4061 0.4199 1.9315 0.5414 4.4561 7.5263 0.0513 2.56604.3001 0.4100 1.9045 0.5058 4.3632 7.3351 0.0482 2.63694.3446 0.4289 1.4785 0.4787 4.2044 7.3496 0.0554 2.20874.3180 0.4359 1.5019 0.3870 4.6275 7.3606 0.0626 2.17964.2440 0.3901 1.0907 0.2564 3.9815 7.0300 0.0321 1.7904Q3Page 19 of 32CY modeled - PMAIRS ID StateCountyPollutant(s)47-009-0011TNBlount PM2.547-093-0028TNKnox PM2.547-093-1017TNKnox PM2.547-093-1020TNKnox O3 and PM2.547-105-0108TNLoudon O3 and PM2.547-145-0004TNRoane PM2.5EC OC SO4 NO30.5407 2.6779 3.4079 1.67520.6406 2.6503 3.5254 1.98140.6235 2.6167 3.4717 1.90830.5788 2.4350 3.4397 1.98760.4675 2.6961 3.4696 2.08520.3331 2.3465 3.2712 1.7693Q4Page 20 of 32