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

range name used 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

areareclist Class 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 name abbr Class I area Class I area, medium Class I area, long IMPROVE state agency

arealist band Bandelier Bandelier NM Bandelier NM BAND1 NM NPS

bosq Bosque del Apache Bosque del Apache Wild. Bosque del Apache Wilderness BOAP1 NM FWS

brca Bryce Canyon Bryce Canyon NP Bryce Canyon NP BRCA1 UT NPS

care Capitol Reef Capitol Reef NP Capitol Reef NP CAPI1 UT NPS

chir Chiricahua NM Chiricahua NM Chiricahua NM CHIR1 AZ NPS

chrw Chiricahua Chiricahua Wild. Chiricahua Wilderness CHIR1 AZ USFS

gali Galiuro Galiuro Wild. Galiuro Wilderness CHIR1 AZ USFS

gila Gila Gila Wild. Gila Wilderness GICL1 NM USFS

grca Grand Canyon Grand Canyon NP Grand Canyon NP GRCA2 AZ NPS

jotr Joshua Tree Joshua Tree NP Joshua Tree NP JOSH1 CA NPS

maza Mazatzal Mazatzal Wild. Mazatzal Wilderness IKBA1 AZ USFS

meve Mesa Verde Mesa Verde NP Mesa Verde NP MEVE1 CO NPS

moba Mount Baldy Mount Baldy Wild. Mount Baldy Wilderness BALD1 AZ USFS

pefo Petrified Forest Petrified Forest NP Petrified Forest NP PEFO1 AZ NPS

pimo Pine Mountain Pine Mountain Wild. Pine Mountain Wilderness IKBA1 AZ USFS

sagu Saguaro Saguaro NP Saguaro NP SAGU1 AZ NPS

saguboth Saguaro Saguaro NP Saguaro NP SAGU1 AZ NPS

sagueast Saguaro east Saguaro NP east Saguaro NP east unit SAGU1 AZ NPS east and west units distinguished in some EPA runs

saguwest Saguaro west Saguaro NP west Saguaro NP west unit SAWE1 AZ NPS east and west units distinguished in some EPA runs

sape San Pedro Parks San Pedro Parks Wild. San Pedro Parks Wilderness SAPE1 NM USFS

sian Sierra Ancha Sierra Ancha Wild. Sierra Ancha Wilderness SIAN1 AZ USFS

supe Superstition Superstition Wild. Superstition Wilderness TONT1 AZ USFS

syca Sycamore Canyon Sycamore Canyon Wild. Sycamore Canyon Wilderness SYCA1 AZ USFS

zion Zion Zion NP Zion NP ZION1 UT NPS

Saguaro West Saguaro NP West Saguaro NP West SAWE1 AZ 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 chir2
gali 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 

monitor

AEPCO 

Apache

APS 

Cholla

SRP 

Coronado

TEP 

Springerville

Catalyst 

Snowflake

TEP 

Sundt

Lhoist 

Nelson 

Lime Plant

ASARCO 

Hayden 

Smelter

FMMI 

Miami 

Smelter

CalPortland 

Cement

Phoenix 

Cement

band Bandelier N.M. NM BAND1 1 1

bosq Bosque del Apache Wild. NM BOAP1 1 1

brca Bryce Canyon N.P. UT BRCA1 1 1

care Capitol Reef N.P. UT CAPI1 1

chir Chiricahua N.M. AZ CHIR1 1 1 1 1 1 1 1 1

chrw Chiricahua Wild. AZ CHIR1 1 1 1 1 1 1 1

gali Galiuro Wild. AZ CHIR1 1 1 1 1 1 1 1 1 1 1

gila Gila Wild. NM GICL1 1 1 1 1 1 1 1 1 1

grca Grand Canyon N.P. AZ GRCA2 1 1 1 1 1 1

jotr Joshua Tree N.P. CA JOSH1 1

maza Mazatzal Wild. AZ IKBA1 1 1 1 1 1 1 1 1 1 1 1

meve Mesa Verde N.P. CO MEVE1 1 1

moba Mount Baldy Wild. AZ BALD1 1 1 1 1 1 1 1 1 1 1

pefo Petrified Forest N.P. AZ PEFO1 1 1 1 1 1 1 1 1

pimo Pine Mountain Wild. AZ IKBA1 1 1 1 1 1 1 1 1 1 1

sagu Saguaro N.P. AZ SAGU1 1 1 1 1 1 1 1 1 1 1

sape San Pedro Parks Wild. NM SAPE1 1 1 1 1

sian Sierra Ancha Wild. AZ SIAN1 1 1 1 1 1 1 1 1 1 1 1

supe Superstition Wild. AZ TONT1 1 1 1 1 1 1 1 1 1 1 1

syca Sycamore Canyon Wild. AZ SYCA1 1 1 1 1 1 1 1 1 1

zion Zion N.P. UT ZION1 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_sou

fac irv cat che aep cho srp

Facility

TEP Sundt 

(Irvington) 

Catalyst Paper - 

Snowflake 

Chemical Lime 

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 NP
15_2012.xlsx" and "AZ_RP_sources_all-Task9_2012-09-30.xls"

spg cpc phc

TEP 

Springerville

CalPortland 

Cement Plant

Pheonix 

Cement Plant fac Facility Areas

band chir brca irv TEP Sundt (Irvington) chir

chir chrw gali cat Catalyst Paper - Snowflake chir

chrw gali grca che Chemical Lime 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 Cement Plant chir

pefo sagu sian phc Pheonix Cement Plant brca

pimo sian supe

sagu supe syca

sape syca zion

sian

supe

syca
chrw 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 supe
supe 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 2 N.A. Phase 3

receptor 

set

Class I 

area 

abbr Class I area Apache Cholla Coronado

SpringervilleSnowflak

e Sundt

bandwild band Bandelier NM 519 365 292 298 384 575

bosqwild bosq Bosque del Apache Wild. 334 330 228 210 319 410

brca brca Bryce Canyon NP 634 327 414 443 368 599

care2 care Capitol Reef NP 622 300 365 396 348 605

chirwild chir Chiricahua NM 48 334 281 253 288 144

chir2 chrw Chiricahua Wild. 46 342 293 264 296 141

gali2 gali Galiuro Wild. 53 249 232 211 200 64

gila2 gila Gila Wild. 168 222 142 111 189 232

grca3 grca Grand Canyon NP 473 179 277 302 213 434

jotrwild2 jotr Joshua Tree NP 539 468 555 563 458 447

maza2 maza Mazatzal Wild. 255 128 205 209 107 203

meve meve Mesa Verde NP 579 292 294 320 336 595

moba moba Mount Baldy Wild. 208 128 71 51 94 232

pefo2 pefo Petrified Forest NP 304 39 54 79 52 308

pimo pimo Pine Mountain Wild. 301 149 228 236 131 247

saguwild sagu Saguaro NP 58 300 285 263 252 17

sape sape San Pedro Parks Wild. 520 331 270 281 356 567

sian sian Sierra Ancha Wild. 208 126 167 165 84 178

supe2 supe Superstition Wild. 183 166 199 194 122 137

syca syca Sycamore Canyon Wild. 371 147 246 263 155 320

zion2 zion Zion 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 10
 to look up distance

 # to look up distance

9 10 11 12 13

8 9 10 11 12

Nelson 

Lime

ASARCO 

Hayden

FMMI 

Miami

CalPortlandPhoenix 

Cement

count 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 re

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 2 Phase 3

receptor 

set

Class I 

area 

abbr Class I area Apache Cholla Coronado

Springerville SundtNelson 

Lime

bandwild band Bandelier NM 519 365 292 298 575 632

bosqwild bosq Bosque del Apache Wild. 334 330 228 210 410 620

brca brca Bryce Canyon NP 634 327 414 443 599 235

care2 care Capitol Reef NP 622 300.3 365 396 605 322

chirwild chir Chiricahua NM 48 334 281 253 144 539

chir2 chrw Chiricahua Wild. 46 342 293 264 141 544

gali2 gali Galiuro Wild. 53 249 232 211 64 419

gila2 gila Gila Wild. 168 222 142 111 232 487

grca3 grca Grand Canyon NP 473 179 277 302 434 24

jotrwild2 jotr Joshua Tree NP 539 468 555 563 447 238

maza2 maza Mazatzal Wild. 255 128 205 209 203 206

meve meve Mesa Verde NP 579 292 294 320 595 471

moba moba Mount Baldy Wild. 208 128 71 51 232 395

pefo2 pefo Petrified Forest NP 304 39 54 79 308 323

pimo pimo Pine Mountain Wild. 301 149 228 236 247 199

saguwild sagu Saguaro NP 58 299.5 285 263 17 412

sape sape San Pedro Parks Wild. 520 331 270 281 567 591

sian sian Sierra Ancha Wild. 208 126 167 165 178 289

supe2 supe Superstition Wild. 183 166 199 194 137 288

syca syca Sycamore Canyon Wild. 371 147 246 263 320 132

zion2 zion Zion 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 9
ts Snowflake-Catalyst, and has reformatted versions for export

ASARCO 

Hayden

FMMI 

Miami

CalPortlandPhoenix 

Cement

count 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 3
Phase 1 Phase 2 Phase 3

State Apache Cholla Coronado

Springerville SundtNelson 

Lime

ASARCO 

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 12
Phase 1 Phase 2

Number of 

facilities for 

area Class I area State Apache Cholla Coronado

Springerville

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 15
Phase 3

Sundt

Nelson 

Lime

ASARCO 

Hayden

FMMI 

Miami

CalPortlandPhoenix 

Cement

Number of 

facilities for 

area

2

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