**Look-up tables for UNC and EPA modeling for Arizona RH FIP** sjb 2014-01-27

range nameused for arealist area abbreviation --> Class I area name, IMPROVE site, state, agency faclist UNC facility abbreviation --> facility name ctrllist various control techology abbreviations, pollutants controlled(not a named lookup table) sitelist IMPROVE site abbreviation --> Class I area abbreviation(s) and name(s) reclist NPS receptor set names --> Class I area abbreviation and name areareclistClass I area abbreviation --> NPS receptor set names
example grca Grand Canyon =VLOOKUP(B12,lookups.xls!arealist,2,FALSE)

**Class I areas for facilities in AZ FIP**

table nameabbr Class I area Class I area, medium Class I area, long IMPROVEstateagency **arealist** band Bandelier Bandelier NM Bandelier NM BAND1NMNPS

bosq Bosque del ApacheBosque del Apache Wild.Bosque del Apache Wilderness BOAP1 NMFWS brca Bryce Canyon Bryce Canyon NP Bryce Canyon NP BRCA1 UTNPS
care Capitol Reef Capitol Reef NP Capitol Reef NP CAPI1 UTNPS chir Chiricahua NM Chiricahua NM Chiricahua NM CHIR1 AZ NPS chrw Chiricahua Chiricahua Wild. Chiricahua Wilderness CHIR1 AZUSFS gali Galiuro Galiuro Wild. Galiuro Wilderness CHIR1 AZUSFS gila Gila Gila Wild. Gila Wilderness GICL1 NMUSFS grca Grand Canyon Grand Canyon NP Grand Canyon NP GRCA2AZ NPS jotr Joshua Tree Joshua Tree NP Joshua Tree NP JOSH1 CANPS
maza Mazatzal Mazatzal Wild. Mazatzal Wilderness IKBA1 AZUSFS
meve Mesa Verde Mesa Verde NP Mesa Verde NP MEVE1CONPS moba Mount Baldy Mount Baldy Wild. Mount Baldy Wilderness BALD1 AZUSFS pefo Petrified Forest Petrified Forest NP Petrified Forest NP PEFO1 AZ NPS pimo Pine Mountain Pine Mountain Wild. Pine Mountain Wilderness IKBA1 AZUSFS sagu Saguaro Saguaro NP Saguaro NP SAGU1AZ NPS saguboth Saguaro Saguaro NP Saguaro NP SAGU1AZNPS sagueast Saguaro east Saguaro NP east Saguaro NP east unit SAGU1AZNPSeast and west units distinguished in some EPA runs saguwestSaguaro west Saguaro NP west Saguaro NP west unit SAWE1AZNPSeast and west units distinguished in some EPA runs sape San Pedro Parks San Pedro Parks Wild. San Pedro Parks Wilderness SAPE1 NMUSFS sian Sierra Ancha Sierra Ancha Wild. Sierra Ancha Wilderness SIAN1 AZUSFS supe Superstition Superstition Wild. Superstition Wilderness TONT1AZUSFS syca Sycamore Canyon Sycamore Canyon Wild. Sycamore Canyon Wilderness SYCA1 AZUSFS zion Zion Zion NP Zion NP ZION1 UTNPS

Saguaro West Saguaro NP West Saguaro NP West SAWE1AZ NPS

**Facilities - UNC abbreviation for CALPUFF file names** fac Facility Facility_Med Facility_Full EPA fac notes**faclist** aep Apache AEPCO Apache AEPCO Apache Generating Station Apache AEPCO = Arizona Electric Power Cooperative cat Snowflake Catalyst Snowflake Catalyst Paper Snowflake Mill NA formerly Abitibi che Nelson Lime Nelson Lime Plant Lhoist Nelson Lime Plant Nelson formerly Chemical Lime Company / Chemical Lime Nelson Plant cho Cholla APS Cholla APS Cholla Generating Station Cholla APS = Arizona Public Service cpc CalPortland CalPortland Cement CalPortland Rillito Cement Plant CalPortland formerly Arizona Portland Company irv Sundt TEP Sundt TEP Sundt Generating Station Sundt formerly Irvington phc Phoenix Cement Phoenix Cement Phoenix Cement Plant phc4 or PhxCem spg Springerville TEP Springerville TEP Springerville Generating Station NA TEP = Tucson Electric Power srp Coronado SRP Coronado SRP Coronado Generating Station Coronado SRP = Salt River Project

Hayden Hayden Smelter ASARCO Hayden Smelter Hayden FMMI FMMI Miami Smelter Freeport McMoRan Miami Smelter FMMI

**Control technologies** abbr Control Control for ctrllist LNB Low-NOx Burner NOx

ULNB Ultra Low-NOx Burner NOx OFA Over-Fire Air NOx CCOFA Close Coupled Over-Fire Air NOx SOFA Separated Over-Fire Air NOx SCR Selective Catalytic Reduction NOx SNCR Selective Non-Catalytic Reduction NOx

FGD Flue Gas Desulfurization SO2 DFGD Dry FGD, dry scrubber SO2 SDA Spray Dryer Absorber, a DFGD usually lime SO2 DL FGD Dry Lime FGD, DFGD using lime SO2 DL Dry Lime scrubber, DFGD using lime SO2 WFGD Wet FGD, wet scrubber SO2 DSI Dry Sorbent Injection SO2 SBC DSI using Sodium bicarbonate SO2

ESP Electrostatic Precipitator PM FF Fabric Filter, a.k.a. Baghouse PM

MAT Mixing Air Technology (for kilns) NOx, SO2

**Class I areas served by each IMPROVE monitor**

**IMPROVE site abbrs**  **Class I areas sitelist**  BALD1 moba Mount Baldy Wild. BAND1 band Bandelier NM BOAP1 bosq Bosque del Apache Wild. BRCA1 brca Bryce Canyon NP CAPI1 care Capitol Reef NP CHIR1 chrw, chir, gali Chiricahua NM, Chiricahua Wild., Galiuro Wild.GICL1 gila Gila Wild. GRCA2 grca Grand Canyon NP IKBA1 maza, pimo Mazatzal Wild., Pine Mountain Wild. JOSH1 jotr Joshua Tree NP MEVE1 meve Mesa Verde NP PEFO1 pefo Petrified Forest NP SAGU1 sagu Saguaro NP SAPE1 sape San Pedro Parks Wild. SIAN1 sian Sierra Ancha Wild. SYCA1 syca Sycamore Canyon Wild. TONT1 supe Superstition Wild. ZION1 zion Zion NP

**Class I areas receptor set names**

**NPS receptor set abbr**  **area reclist**  bandwild band Bandelier NM bosqwild bosq Bosque del Apache Wild. brca brca Bryce Canyon NP care2 care Capitol Reef NP chir2 chrw Chiricahua Wild. (chir's were reversed in earlier versions) chirwild chir Chiricahua NM gali2 gali Galiuro Wild. gila2 gila Gila Wild. grca3 grca Grand Canyon NP jotrwild2 jotr Joshua Tree NP maza2 maza Mazatzal Wild.
meve meve Mesa Verde NP moba moba Mount Baldy Wild. pefo2 pefo Petrified Forest NP pimo pimo Pine Mountain Wild. saguwild sagu Saguaro NP sape sape San Pedro Parks Wild. sian sian Sierra Ancha Wild. supe2 supe Superstition Wild. syca syca Sycamore Canyon Wild. zion2 zion Zion NP

**Class I areas receptor set names abbr**  **NPS receptor set areareclist** band bandwild

bosq bosqwild brca brca
care care2 chir chirwild (chir's were reversed in earlier versions) chrw chir2gali gali2 gila gila2 grca grca3 jotr jotrwild2
maza maza2
meve meve moba moba pefo pefo2 pimo pimo sagu saguwild sape sape sian sian supe supe2 syca syca zion zion2**Class I areas within 300 km of Facilities Modeled for Arizona Regional Haze FIP**

**Phase 2**

abbr.Class I area St.IMPROVE monitorAEPCO

Apache APS

Cholla SRP

Coronado TEP

Springerville Catalyst

Snowflake TEP

Sundt Lhoist

Nelson Lime PlantASARCO

Hayden Smelter FMMI

Miami SmelterCalPortland CementPhoenix

Cement
bandBandelier N.M. NMBAND1 1 1 bosqBosque del Apache Wild.NMBOAP1 1 1 brcaBryce Canyon N.P. UTBRCA1 1 1

careCapitol Reef N.P. UTCAPI1 1 chirChiricahua N.M. AZCHIR1 1 1 1 1 1 1 1 1 chrwChiricahua Wild. AZCHIR1 1 1 1 1 1 1 1 galiGaliuro Wild. AZCHIR1 1 1 1 1 1 1 1 1 1 1 gilaGila Wild. NMGICL1 1 1 1 1 1 1 1 1 1 grcaGrand Canyon N.P. AZGRCA2 1 1 1 1 1 1 jotrJoshua Tree N.P. CAJOSH1 1

mazaMazatzal Wild. AZIKBA1 1 1 1 1 1 1 1 1 1 1 1

meveMesa Verde N.P. COMEVE1 1 1 mobaMount Baldy Wild. AZBALD1 1 1 1 1 1 1 1 1 1 1 pefoPetrified Forest N.P. AZPEFO1 1 1 1 1 1 1 1 1 pimoPine Mountain Wild. AZIKBA1 1 1 1 1 1 1 1 1 1 1 saguSaguaro N.P. AZSAGU1 1 1 1 1 1 1 1 1 1 1 sapeSan Pedro Parks Wild. NMSAPE1 1 1 1 1 sianSierra Ancha Wild. AZSIAN1 1 1 1 1 1 1 1 1 1 1 1 supeSuperstition Wild. AZTONT1 1 1 1 1 1 1 1 1 1 1 1 sycaSycamore Canyon Wild. AZSYCA1 1 1 1 1 1 1 1 1 1 zionZion N.P. UTZION1 1 1

Number of areas for facility 9 13 17 15 12 10 9 13 14 12 12 **Phase 1 BART Phase 3 BART**  **Phase 3 RP UNC-modeled Facilities and Class I areas** 

UNC-modeled Facilities and Class I areas; Lists from "AZ_BART_sources_final_all-Task7-8_05_15_2012.xlsx" and "AZ_RP_sources_all-Task9_2012-09-30.xls" fac irv cat che aep cho srp

Facility **TEP Sundt**

**(Irvington) Catalyst Paper -** 

**Snowflake Chem** **ical Lim e** 

**Co. - Nelson Plant**  **Apache Station**

**(AEPCO) APS Cholla** 

**Power Plant SRP Coronado** 

**Station** Areas chir chir brca chir care band

chrw gali grca chrw gali chir gali gila jotr gali gila chrw gila grca maza gila grca gali

maza maza pimo maza maza gila moba moba sian moba meve grca pimo pefo supe sagu moba maza sagu pimo syca sian pefo meve sian sagu zion supe pimo moba supe sian sagu pefo

supe sian pimo syca supe sagu syca sape

sian supe syca
**Combined list (does not include bosq, omitted for Coronado and Springerville)** band Bandelier NM brca Bryce Canyon NP
care Capitol Reef NP chir Chiricahua NM chrw Chiricahua Wild. gali Galiuro Wild. gila Gila Wild. grca Grand Canyon NP jotr Joshua Tree NP
maza Mazatzal Wild.
meve Mesa Verde NP moba Mount Baldy Wild. pefo Petrified Forest NP pimo Pine Mountain Wild. sagu Saguaro NP sape San Pedro Parks Wild. sian Sierra Ancha Wild. supe Superstition Wild. syca Sycamore Canyon Wild. zion Zion NPUNC-modeled Facilities and Class I areas; Lists from "AZ_BART_sources_final_all-Task7-8_05_15_2012.xlsx" and "AZ_RP_sources_all-Task9_2012-09-30.xls"

spg cpc phc
**TEP Springerville** **CalPortland**

**Cem ent Plant** **Pheonix**

**Cem ent Plant**  fac Facility Areas band chir brca irv **TEP Sundt (Irvington)** chir chir chrw gali cat **Catalyst Paper - Snowflake** chir chrw gali grca che **Chem ical Lim** **e Co. - Nelson Plant**brca gali gila maza aep **Apache Station (AEPCO)** chir gila maza moba cho **APS Cholla Power Plant** care grca moba pefo srp **SRP Coronado Station** band

maza pefo pimo spg **TEP Springerville** band moba pimo sagu cpc **CalPortland Cem ent Plant**  chir pefo sagu sian phc **Pheonix Cem ent Plant**  brca pimo sian supe sagu supe syca sape syca zion sian supe sycachrw gali gila maza moba pimo sagu sian supe

gali gila grca maza moba pefo pimo sagu sian grca jotr maza pimo sian supe syca zion chrw gali gila maza moba sagu sian supe gali gila grca maza meve moba pefo pimo sagu chir chrw gali gila grca maza meve moba pefo chir chrw gali gila grca maza moba pefo pimo chrw gali gila maza moba pefo pimo sagu sian gali grca maza moba pefo pimo sagu sian supesupe syca

sian supe syca pimo sagu sape sian supe syca sagu sape sian supe syca supe syca syca zion**Names for possible use in FRN tables**

Set 'Headings to use' cells to desired text or to references to one of the 'alt. headings' columns In facility-specific spreadsheets, refer to range name here
Row headings Range Name Headings to use alt. headings 1 

### h_dv_cumul Cumulative (sum) Cumulative (sum) 

### h_dv_max Maximum Maximum 

### h_nover5 # CIAs >= 0.5 dv # CIAs >= 0.5 dv 

### h_n_impr_over5# CIAs improvement >= 0.5 dv # CIAs improvement >= 0.5 dv 

### h_dpdv_cumul million $/dv (cumul. dv) million $/dv (cumul. dv) 

### h_dpdv_max million $/dv (max. dv) million $/dv (max. dv)alt. headings 2

Cumulative Visb Impr. Single Largest Class I Improvement Areas >= 0.5 dv Areas >= 0.5 dv impr Cumulative Class I area cost effectiveness Single Class I area cost effectiveness**Look up distance from Class I Area to Facility area_dist_list** use area abbreviation (e.g. band) and column # to look up distance **areaname_dist_list**use area name (e.g. Bandelier NM) and column # to look up distance column # for area-distance lookup area_dist_list 3 4 5 6 7 8 areaname_dist_list **2 3**  **4 5**  **6 7** 
Uses 2008 NPS receptors, different than 2005 for chirwild and saguwild
**Distances between Arizona RH FIP facilities and Class I area receptors, kilometers**

Phase 1 Phase 2N.A. Phase 3

receptor set Class I

area abbrClass I area ApacheChollaCoronadoSpringervilleSnowflak

e Sundt bandwildbandBandelier NM 519 365 292 298 384 575 bosqwildbosqBosque del Apache Wild.334 330 228 210 319 410 brca brcaBryce Canyon NP 634 327 414 443 368 599 care2 careCapitol Reef NP 622 300 365 396 348 605 chirwild chirChiricahua NM 48 334 281 253 288 144 chir2 chrwChiricahua Wild. 46 342 293 264 296 141 gali2 galiGaliuro Wild. 53 249 232 211 200 64 gila2 gilaGila Wild. 168 222 142 111 189 232 grca3 grcaGrand Canyon NP 473 179 277 302 213 434 jotrwild2 jotrJoshua Tree NP 539 468 555 563 458 447 maza2 mazaMazatzal Wild. 255 128 205 209 107 203
meve meveMesa Verde NP 579 292 294 320 336 595 moba mobaMount Baldy Wild. 208 128 71 51 94 232 pefo2 pefoPetrified Forest NP 304 39 54 79 52 308 pimo pimoPine Mountain Wild. 301 149 228 236 131 247 saguwildsaguSaguaro NP 58 300 285 263 252 **17** sape sapeSan Pedro Parks Wild. 520 331 270 281 356 567 sian sianSierra Ancha Wild. 208 126 167 165 84 178 supe2 supeSuperstition Wild. 183 166 199 194 122 137 syca sycaSycamore Canyon Wild. 371 147 246 263 155 320 zion2 zionZion NP 627 337 432 458 373 582 sagueast Saguaro NP, east unit 58 302 285 263 253 **17** saguwest Saguaro NP, west unit 119 300 304 287 252 25

count if <=300.4 km 9 13 17 15 13 10use area abbreviation (e.g. band) and column # to look up distance use area name (e.g. Bandelier NM) and column # to look up distance

9 10 11 12 13 **8 9**  **10 11**  **12**

Nelson Lime ASARCO

Hayden FMMI

Miami CalPortlandPhoenix

Cementcount if <=

300.4 km ST 632 504 401 573 526 2 NM 620 364 235 419 481 3 NM 235 510 552 567 296 2 UT 322 511 523 578 332 1 UT 539 170 113 171 395 8 AZ 544 174 125 170 400 8 AZ 419 48 99 73 278 10 AZ 487 186 55 240 340 9 NM **24** 347 396 403 133 5 AZ 238 427 556 415 305 1 CA 206 121 220 171 59 11 AZ 471 504 460 578 413 2 CO 395 151 95 223 249 10 AZ 323 215 197 290 200 8 AZ 199 168 260 213 56 10 AZ 412 82 143 **7.8** 284 10 AZ 591 489 398 561 490 2 NM 289 84 158 153 142 11 AZ 288 50 163 108 151 11 AZ 132 239 320 287 **10.4** 8 AZ 183 498 556 549 272 2 UT 446 87 143 47 311 412 82 187 **7.8** 284

9 12 12 12 12

State# Areas AZ 12 CA 1 CO 1 NM 4 UT 3**Distance from Class I Area to Facility** Same as 'area_fac_distance', but omits Snowflake-Catalyst, and has reformatted versions for export

Uses 2008 NPS receptors, different than 2005 for chirwild and saguwild
**Distances between Arizona RH FIP facilities and Class I area receptors, kilometers**

Phase 1 Phase 2Phase 3

receptor set Class I

area abbrClass I area ApacheChollaCoronadoSpringerville SundtNelson

Lime bandwildbandBandelier NM 519 365 292 298 575 632 bosqwildbosqBosque del Apache Wild.334 330 228 210 410 620 brca brcaBryce Canyon NP 634 327 414 443 599 235 care2 careCapitol Reef NP 622 300.3 365 396 605 322 chirwild chirChiricahua NM 48 334 281 253 144 539 chir2 chrwChiricahua Wild. 46 342 293 264 141 544 gali2 galiGaliuro Wild. 53 249 232 211 64 419 gila2 gilaGila Wild. 168 222 142 111 232 487 grca3 grcaGrand Canyon NP 473 179 277 302 434 **24** jotrwild2 jotrJoshua Tree NP 539 468 555 563 447 238 maza2 mazaMazatzal Wild. 255 128 205 209 203 206
meve meveMesa Verde NP 579 292 294 320 595 471 moba mobaMount Baldy Wild. 208 128 71 51 232 395 pefo2 pefoPetrified Forest NP 304 39 54 79 308 323 pimo pimoPine Mountain Wild. 301 149 228 236 247 199 saguwildsaguSaguaro NP 58 299.5 285 263 **17** 412 sape sapeSan Pedro Parks Wild. 520 331 270 281 567 591 sian sianSierra Ancha Wild. 208 126 167 165 178 289 supe2 supeSuperstition Wild. 183 166 199 194 137 288 syca sycaSycamore Canyon Wild. 371 147 246 263 320 132 zion2 zionZion NP 627 337 432 458 582 183 sagueast Saguaro NP, east unit 58 302 285 263 **17** 446 saguwest Saguaro NP, west unit 119 300 304 287 25 412

count if <=300.4 km 9 13 17 15 10 9Same as 'area_fac_distance', but omits Snowflake-Catalyst, and has reformatted versions for export

ASARCO Hayden FMMI

Miami CalPortlandPhoenix

Cementcount if <=

300.4 km ST Class I area 504 401 573 526 2 NM Bandelier NM 364 235 419 481 3 NM Bosque del Apache Wild. 510 552 567 296 2 UT Bryce Canyon NP 511 523 578 332 1 UT Capitol Reef NP 170 113 171 395 7 AZ Chiricahua NM 174 125 170 400 7 AZ Chiricahua Wild. 48 99 73 278 9 AZ Galiuro Wild. 186 55 240 340 8 NM Gila Wild. 347 396 403 133 4 AZ Grand Canyon NP 427 556 415 305 1 CA Joshua Tree NP 121 220 171 59 10 AZ Mazatzal Wild. 504 460 578 413 2 CO Mesa Verde NP 151 95 223 249 9 AZ Mount Baldy Wild. 215 197 290 200 7 AZ Petrified Forest NP 168 260 213 56 9 AZ Pine Mountain Wild. 82 143 **7.8** 284 9 AZ Saguaro NP 489 398 561 490 2 NM San Pedro Parks Wild. 84 158 153 142 10 AZ Sierra Ancha Wild. 50 163 108 151 10 AZ Superstition Wild. 239 320 287 **10.4** 7 AZ Sycamore Canyon Wild. 498 556 549 272 2 UT Zion NP 87 143 47 311 Number of areas for facility 82 187 **7.8** 284

12 12 12 12

State# Areas AZ 12 CA 1 CO 1 NM 4 UT 3Phase 1 Phase 2Phase 3

StateApacheChollaCoronadoSpringerville SundtNelson

LimeASARCO

Hayden FMMI

Miami CalPortlandPhoenix

Cement NM 292 298 NM 228 210 235 UT 235 296 UT 300 AZ 48 281 253 144 170 113 171 AZ 46 293 264 141 174 125 170 AZ 53 249 232 211 64 48 99 73 278 NM 168 222 142 111 232 186 55 240 AZ 179 277 24 133 CA 238 AZ 255 128 205 209 203 206 121 220 171 59 CO 292 294 AZ 208 128 71 51 232 151 95 223 249 AZ 39 54 79 215 197 290 200 AZ 149 228 236 247 199 168 260 213 56 AZ 58 300 285 263 17 82 143 8 284 NM 270 281 AZ 208 126 167 165 178 289 84 158 153 142 AZ 183 166 199 194 137 288 50 163 108 151 AZ 147 246 263 132 239 287 10 UT 183 272 9 13 17 15 10 9 12 12 12 12Phase 1 Phase 2

Number of facilities for
area Class I area StateApacheChollaCoronadoSpringerville 2 Bandelier NM NM X X 3 Bosque del Apache Wild. NM X X 2 Bryce Canyon NP UT 1 Capitol Reef NP UT X 7 Chiricahua NM AZ X X X 7 Chiricahua Wild. AZ X X X 9 Galiuro Wild. AZ X X X X 8 Gila Wild. NM X X X X 4 Grand Canyon NP AZ X X 1 Joshua Tree NP CA 10 Mazatzal Wild. AZ X X X X 2 Mesa Verde NP CO X X 9 Mount Baldy Wild. AZ X X X X 7 Petrified Forest NP AZ X X X 9 Pine Mountain Wild. AZ X X X 9 Saguaro NP AZ X X X X 2 San Pedro Parks Wild. NM X X 10 Sierra Ancha Wild. AZ X X X X 10 Superstition Wild. AZ X X X X 7 Sycamore Canyon Wild. AZ X X X 2 Zion NP UT

Number of areas for facility 9 13 17 15Phase 3

SundtNelson

LimeASARCO

Hayden FMMI

Miami CalPortlandPhoenix

CementNumber of facilities for
area2 X 3 X X 2 1 X X X X 7 X X X X 7 X X X X X 9 X X X X 8 X X 4 X 1 X X X X X X 10 2 X X X X X 9

X X X X 7 X X X X X X 9 X X X X X 9 2 X X X X X X 10 X X X X X X 10 X X X X 7 X X 2 10 9 12 12 12 12