Spreadsheet: 144800d1331141511-vlookup-not-returning-the-correct-value-in-cell-paycheck-calculator-b
Sheet: Facility

State | Facility ID | Name | ATC Level | Locality %
Alaska | A11 | Anchorage TRACON | 8 | 0.2772
Georgia | A80 | Atlanta TRACON | 12 | 0.1929
New Hampshire | A90 | Boston Consolidated TRACON | 11 | 0.248
Pennsylvania | ABE | Allentown ATCT/TRACON | 7 | 0.1416
Texas | ABI | Abilene ATCT/TRACON | 7 | 0.1416
New Mexico | ABQ | Albuquerque ATCT/TRACON | 8 | 0.1416
Massachusetts | ACK | Nantucket ATCT | 6 | 0.1416
Texas | ACT | Waco ATCT/TRACON | 5 | 0.1416
New Jersey | ACY | Atlantic City ATCT | 7 | 0.2179
Texas | ADS | Addison ATCT | 5 | 0.2067
Maryland | ADW | Andrews Air Base ATCT | 6 | 0.2422
Texas | AFW | Alliance ATCT | 5 | 0.2067
Pennsylvania | AGC | Allegheny County ATCT | 5 | 0.1637
Georgia | AGS | Augusta ATCT/TRACON | 5 | 0.1416
New York | ALB | Albany ATCT/TRACON | 7 | 0.1416
Iowa | ALO | [NAME] | 5 | 0.1416
Texas | AMA | Amarillo ATCT/TRACON | 7 | 0.1416
Alaska | ANC | Anchorage ATCT | 8 | 0.2772
Colorado | APA | Centennial ATCT | 8 | 0.2252
California | APC | Napa ATCT | 5 | 0.3515
Michigan | ARB | [NAME] ATCT | 5 | 0.2409
Illinois | ARR | Auroroa ATCT | 5 | 0.251
Colorado | ASE | Aspen ATCT/TRACON | 5 | 0.1416
Georgia | ATL | Atlanta ATCT | 12 | 0.1929
Texas | AUS | Austin ATCT/TRACON | 8 | 0.1416
North Carolina | AVL | Asheville ATCT/TRACON | 6 | 0.1416
Pennsylvania | AVP | Wilkes-Barre ATCT/TRACON | 6 | 0.1416
Michigan | AZO | Kalamazoo ATCT/TRACON | 6 | 0.1416
Connecticut | BDL | Bradley ATCT | 6 | 0.2582
Massachusetts | BED | Bedford ATCT | 7 | 0.248
Washington | BFI | Boeing Field ATCT | 8 | 0.2181
California | BFL | Bakersfield ATCT/TRACON | 7 | 0.1416
New York | BGM | Binghampton ATCT/TRACON | 5 | 0.1416
Maine | BGR | Bangor ATCT/TRACON | 6 | 0.1416
Alabama | BHM | [NAME]/TRACON | 8 | 0.1416
Montana | BIL | Billings ATCT/TRACON | 6 | 0.1416
North Dakota | BIS | Bismarck ATCT/TRACON | 5 | 0.1416
Colorado | BJC | Metro ATCT | 6 | 0.2252
Tennessee | BNA | Nashville ATCT/TRACON | 9 | 0.1416
Idaho | BOI | Boise ATCT/TRACON | 7 | 0.1416
Massachusetts | BOS | Boston ATCT | 10 | 0.248
Texas | BPT | Beaumont ATCT | 4 | 0.1416
Louisiana | BTR | Baton Rouge ATCT/TRACON | 6 | 0.1416
Vermont | BTV | Burlington ATCT/TRACON | 6 | 0.1416
New York | BUF | Buffalo ATCT/TRACON | 8 | 0.1698
California | BUR | Burbank ATCT | 7 | 0.2716
Maryland | BWI | Baltimore ATCT | 9 | 0.2422
Illinois | C90 | Chicago TRACON | 12 | 0.251
Ohio | CAK | Canton-Akron ATCT/TRACON | 7 | 0.1624
California | CCR | Concord ATCT | 5 | 0.3515
New Jersey | CDW | Caldwell ATCT | 5 | 0.2872
Tennessee | CHA | Chattanooga ATCT/TRACON | 6 | 0.1416
South Carolina | CHS | Charleston ATCT/TRACON | 8 | 0.1416
Iowa | CID | Cedar Rapids ATCT/TRACON | 6 | 0.1416
West Virginia | CKB | Clarksburg ATCT/TRACON | 5 | 0.1416
Ohio | CLE | Cleveland ATCT/TRACON | 9 | 0.1868
North Carolina | CLT | Charlotte ATCT/TRACON | 12 | 0.1416
California | CMA | Camarillo ATCT | 6 | 0.2716
Ohio | CMH | Columbus OH ATCT | 8 | 0.1855
Illinois | CMI | [NAME]/TRACON | 6 | 0.1416
California | CNO | [NAME] | 7 | 0.2716
Colorado | COS | Colorado Springs ATCT/TRACON | 8 | 0.1416
Wyoming | CPR | Casper ATCT/TRACON | 5 | 0.1416
Illinois | CPS | St. Louis Downtown Parks ATCT | 5 | 0.1416
Texas | CRP | Corpus Christi SSC | 9 | 0.1416
California | CRQ | [NAME] | 6 | 0.2419
West Virginia | CRW | Charleston WV ATCT/TRACON | 6 | 0.1416
Georgia | CSG | Columbus ATCT | 4 | 0.1416
Kentucky | CVG | Greater Cincinnati ATCT/TRACON | 9 | 0.1855
Colorado | D01 | Denver TRACON | 11 | 0.2252
Texas | D10 | Dallas/Fort Worth TRACON | 12 | 0.2067
Michigan | D21 | Detroit TRACON | 11 | 0.2409
Florida | DAB | Daytona ATCT/TRACON | 9 | 0.1416
Texas | DAL | Dallas Love Field ATCT | 8 | 0.2067
Ohio | DAY | Dayton ATCT/TRACON | 7 | 0.1624
Virginia | DCA | [NAME] National ATCT | 10 | 0.2422
Colorado | DEN | Denver ATCT | 12 | 0.2252
Texas | DFW | Dallas/Fort Worth ATCT | 12 | 0.2067
Minnesota | DLH | Duluth ATCT/TRACON | 5 | 0.1416
Illinois | DPA | DuPage ATCT | 5 | 0.251
Iowa | DSM | Des Moines ATCT/TRACON | 7 | 0.1416
Michigan | DTW | Detroit Metro ATCT | 11 | 0.2409
Arizona | DVT | Deer Valley ATCT | 8 | 0.1416
Texas | DWH | Houston Hooks ATCT | 7 | 0.2871
California | E10 | High Desert TRACON | 8 | 0.2716
New York | ELM | Elmira ATCT | 5 | 0.1416
Texas | ELP | El Paso ATCT/TRACON | 7 | 0.1416
California | EMT | El Monte ATCT | 5 | 0.2716
Pennsylvania | ERI | Erie ATCT/TRACON | 5 | 0.1416
Oregon | EUG | [NAME]/TRACON | 6 | 0.1416
Indiana | EVV | Evansville ATCT/TRACON | 6 | 0.1416
New Jersey | EWR | Liberty ATCT | 10 | 0.2872
Alaska | FAI | Fairbanks ATCT/TRACON | 7 | 0.2772
North Dakota | FAR | Fargo ATCT/TRACON | 6 | 0.1416
California | FAT | Fresno ATCT/TRACON | 8 | 0.1416
North Carolina | FAY | Fayetteville ATCT/TRACON | 7 | 0.1416
Minnesota | FCM | Flying Cloud ATCT | 5 | 0.2096
Arizona | FFZ | Falcon Field | 7 | 0.1416
Florida | FLL | Fort Lauderdale ATCT | 8 | 0.2079
South Carolina | FLO | Florence ATCT/TRACON | 5 | 0.1416
Michigan | FNT | Flint ATCT/TRACON | 5 | 0.2409
Florida | FPR | Fort Pierce ATCT | 6 | 0.1416
New York | FRG | Republic ATCT | 7 | 0.2872
South Dakota | FSD | [NAME]/TRACON | 6 | 0.1416
Arkansas | FSM | Fort Smith ATCT/TRACON | 7 | 0.1416
Texas | FTW | Fort Worth Meacham ATCT | 5 | 0.2067
Indiana | FWA | Fort Wayne ATCT/TRACON | 5 | 0.1416
Florida | FXE | Fort Lauderdale Executive ATCT | 6 | 0.2079
Arizona | GCN | Grand Canyon ATCT | 5 | 0.1416
Washington | GEG | Spokane ATCT/TRACON | 7 | 0.1416
North Dakota | GFK | Grand Forks ATCT | 9 | 0.1416
Texas | GGG | Longview ATCT/TRACON | 6 | 0.1416
Mississippi | GPT | Gulfport ATCT/TRACON | 7 | 0.1416
Wisconsin | GRB | Green Bay ATCT/TRACON | 7 | 0.1416
Michigan | GRR | Grand Rapids ATCT/TRACON | 7 | 0.1416
North Carolina | GSO | Greensboro ATCT/TRACON | 7 | 0.1416
South Carolina | GSP | Greer ATCT/TRACON | 6 | 0.1416
Montana | GTF | Great Falls ATCT/TRACON | 5 | 0.1416
Virginia | HEF | Manassas ATCT | 4 | 0.2422
Oregon | HIO | Hillsboro ATCT | 7 | 0.2035
Montana | HLN | Helena ATCT | 5 | 0.1416
Texas | HOU | [NAME] | 8 | 0.2871
New York | HPN | White Plains ATCT | 7 | 0.2872
Alabama | HSV | Huntsville ATCT/TRACON | 7 | 0.1602
West Virginia | HTS | Huntington ATCT/TRACON | 5 | 0.1416
Indiana | HUF | Terra Haute ATCT/TRACON | 5 | 0.1416
California | HWD | Hayward ATCT | 6 | 0.3515
Texas | I90 | Houston Intercontinental TRACON | 12 | 0.2871
Virginia | IAD | Dulles ATCT | 10 | 0.2422
Texas | IAH | Houston Intercontinental ATCT | 12 | 0.2871
Kansas | ICT | Wichita ATCT/TRACON | 8 | 0.1416
Delaware | ILG | Wilmington ATCT | 5 | 0.2179
North Carolina | ILM | Wilmington NC ATCT/TRACON | 6 | 0.1416
Indiana | IND | Indianapolis ATCT/TRACON | 8 | 0.1468
New York | ISP | Islip ATCT | 7 | 0.2872
Hawaii | ITO | Hilo ATCT/TRACON | 7 | 0.2972
Mississippi | JAN | Jackson ATCT/TRACON | 7 | 0.1416
Florida | JAX | Jacksonville ATCT/TRACON | 9 | 0.1416
New York | [NAME] | Kennedy ATCT | 10 | 0.2872
Alaska | JNU | Juneau ATCT | 5 | 0.2772
Massachusetts | [NAME] | Cape TRACON | 8 | 0.248
Nevada | L30 | Las Vegas TRACON | 11 | 0.1416
Indiana | LAF | Lafayette ATCT | 6 | 0.1416
Michigan | LAN | Lansing ATCT/TRACON | 6 | 0.1416
Nevada | LAS | Las Vegas ATCT | 11 | 0.1416
California | LAX | Los Angeles ATCT | 11 | 0.2716
Texas | LBB | Lubbock ATCT/TRACON | 6 | 0.1416
Louisiana | LCH | [NAME]/TRACON | 6 | 0.1416
Kentucky | LEX | [NAME]/TRACON | 7 | 0.1416
Louisiana | LFT | Lafayette ATCT/TRACON | 7 | 0.1416
California | LGB | Long Beach ATCT | 8 | 0.2716
New York | LGQ | LaGuardia ATCT | 10 | 0.2872
Arkansas | LIT | Little Rock ATCT/TRACON | 8 | 0.1416
Nebraska | LNK | Lincoln ATCT | 5 | 0.1416
Kentucky | LOU | [NAME] ATCT | 5 | 0.1416
California | LVK | Livermore ATCT | 6 | 0.3515
Minnesota | M98 | Minneapolis TRACON | 11 | 0.2096
Texas | MAF | Midland ATCT/TRACON | 7 | 0.1416
Michigan | MBS | Saginaw ATCT/TRACON | 5 | 0.1416
Missouri | MCI | Kansas City Int'l ATCT/TRACON | 9 | 0.1416
Florida | MCO | Orlando ATCT | 9 | 0.1416
Illinois | MDW | Midway ATCT | 8 | 0.251
Tennessee | MEM | Memphis ATCT/TRACON | 10 | 0.1416
Ohio | MFD | Mansfield ATCT/TRACON | 5 | 0.1416
Alabama | MGM | Montgomery ATCT/TRACON | 7 | 0.1416
New Hampshire | MHT | [NAME] | 5 | 0.248
Florida | MIA | Miami ATCT/TRACON | 12 | 0.2079
Minnesota | MIC | Minneapolis Crystal ATCT | 4 | 0.2096
Missouri | MKC | Kansas City Downtown ATCT | 5 | 0.1416
Wisconsin | MKE | Milwauke ATCT/TRACON | 9 | 0.181
Michigan | MKG | Muskegon County ATCT | 5 | 0.1416
Illinois | MLI | Quad City ATCT/TRACON | 5 | 0.1416
Louisiana | MLU | Monroe ATCT/TRACON | 5 | 0.1416
New Jersey | MMU | Morristown Municipal ATCT | 6 | 0.2872
Alabama | MOB | Mobile ATCT/TRACON | 8 | 0.1416
Alaska | MRI | Merrill ATCT | 6 | 0.2772
California | MRY | Monterey ATCT | 5 | 0.3515
Wisconsin | MSN | Madison ATCT/TRACON | 7 | 0.1416
Minnesota | MSP | Minneapolis ATCT | 11 | 0.2096
Louisiana | MSY | New Orleans Moissant ATCT/TRACON | 9 | 0.1416
Washington | MWH | Grant County ATCT/TRACON | 6 | 0.1416
California | MYF | Montgomery ATCT | 7 | 0.2419
South Carolina | MYR | Myrtle Beach ATCT/TRACON | 7 | 0.1416
New York | N90 | New York TRACON | 12 | 0.2872
California | NCT | Northern California TRACON | 11 | 0.2222
Louisiana | NEW | New Orleans Lakefront ATCT | 5 | 0.1416
Mississippi | NMM | [NAME] | 7 | 0.1416
California | OAK | Oakland ATCT | 7 | 0.3515
Hawaii | OGG | [NAME] | 6 | 0.2972
Oklahoma | OKC | Oklahoma City [NAME]/TRACON | 8 | 0.1416
Nebraska | OMA | [NAME] | 6 | 0.1416
California | ONT | Ontario ATCT | 5 | 0.2716
Illinois | ORD | O'Hare ATCT | 12 | 0.251
Virginia | ORF | Norfolk ATCT/TRACON | 8 | 0.1416
Florida | ORL | Orlando Executive ATCT | 5 | 0.1416
Florida | P31 | Pensacola TRACON | 9 | 0.1416
Arizona | P50 | Phoenix TRACON | 11 | 0.1676
Oregon | P80 | Portland TRACON | 9 | 0.2035
Washington | PAE | [NAME] | 6 | 0.2181
California | PAO | Palo Alto ATCT | 6 | 0.3515
Florida | PBI | Palm Beach Int'l ATCT/TRACON | 9 | 0.2079
Virginia | PCT | [NAME] TRACON | 11 | 0.2422
Georgia | PDK | Dekalb Peachtree ATCT | 7 | 0.1929
Oregon | PDX | Portland OR ATCT | 8 | 0.2035
Virginia | PHF | Newport News ATCT | 6 | 0.1416
Pennsylvania | PHL | Philadelphia ATCT/TRACON | 12 | 0.2179
Arizona | PHX | Phoenix ATCT | 10 | 0.1676
Illinois | PIA | Peoria ATCT/TRACON | 6 | 0.1416
Florida | PIE | St. Petersburge ATCT | 6 | 0.1416
Pennsylvania | PIT | Pittsburgh ATCT/TRACON | 9 | 0.1637
Pennsylvania | PNE | North Philadelphia ATCT | 5 | 0.2179
Florida | PNS | Pensacola ATCT | 6 | 0.1416
California | POC | Brackett ATCT | 5 | 0.2716
New York | POU | Dutchess County ATCT | 5 | 0.2872
Arizona | PRC | [NAME] | 7 | 0.1416
Washington | PSC | Pasco/Tri-Cities ATCT/TRACON | 6 | 0.1416
California | PSP | Palm Springs ATCT/TRACON | 5 | 0.2716
Michigan | PTK | Pontiac ATCT | 5 | 0.2409
Colorado | PUB | Pueblo ATCT/TRACON | 7 | 0.1416
Rhode Island | PVD | Providence ATCT/TRACON | 7 | 0.248
Illinois | PWK | Palwaukee ATCT | 5 | 0.251
Maine | PWM | Portland ATCT/TRACON | 6 | 0.1416
Nebraska | R90 | [NAME] | 8 | 0.1416
Pennsylvania | RDG | Reading ATCT/TRACON | 6 | 0.2179
North Carolina | RDU | Raleigh ATCT | 9 | 0.1764
Illinois | RFD | Rockford ATCT/TRACON | 6 | 0.1416
California | RHV | Reid-Hillview ATCT | 6 | 0.3515
Virginia | RIC | Richmond ATCT | 6 | 0.1647
Nevada | RNO | Reno ATCT | 5 | 0.1416
Virginia | ROA | Roanoke ATCT/TRACON | 6 | 0.1416
New York | ROC | Rochester NY ATCT/TRACON | 5 | 0.1416
New Mexico | ROW | Roswell ATCT/TRACON | 5 | 0.1416
Minnesota | RST | Rochester ATCT | 6 | 0.1416
Oklahoma | RVS | Tulsa Riverside ATCT | 7 | 0.1416
Washington | S46 | Seattle TRACON | 10 | 0.2181
Utah | S56 | Salt Lake City TRACON | 10 | 0.1416
California | SAN | Lindbergh ATCT | 7 | 0.2419
Texas | SAT | San Antonio Intn'l ATCT/TRACON | 9 | 0.1416
Georgia | SAV | Savannah ATCT/TRACON | 8 | 0.1416
California | SBA | Santa Barbara ATCT/TRACON | 7 | 0.2716
Indiana | SBN | South Bend ATCT/TRACON | 7 | 0.1416
California | SCK | [NAME] | 4 | 0.3515
California | SCT | Southern California TRACON | 12 | 0.2419
Kentucky | SDF | Standiford ATCT/TRACON | 8 | 0.1416
Arizona | SDL | Scottsdale ATCT | 6 | 0.1676
Washington | SEA | Seattle ATCT | 9 | 0.2181
California | SEE | Gillespie ATCT | 7 | 0.2419
Florida | SFB | [NAME] | 7 | 0.1416
California | SFO | San Francisco ATCT | 9 | 0.3515
Missouri | SGF | Springfield MO ATCT/TRACON | 7 | 0.1416
Louisiana | SHV | Shreveport ATCT | 6 | 0.1416
California | SJC | San Jose ATCT | 7 | 0.3515
Utah | SLC | Salt Lake City ATCT | 10 | 0.1416
California | SMF | Sacramento ATCT | 6 | 0.2222
California | SMO | Santa Monica ATCT | 5 | 0.2716
California | SNA | [NAME] | 8 | 0.2716
Illinois | SPI | Springfield ATCT/TRACON | 5 | 0.1416
Florida | SRQ | Sarasota ATCT | 6 | 0.1416
Missouri | STL | St. Louis ATCT | 8 | 0.1416
Minnesota | STP | St. Paul ATCT | 5 | 0.2096
California | STS | Santa Rosa ATCT | 5 | 0.3515
Missouri | SUS | Spirit of St. Louis ATCT | 5 | 0.1416
Iowa | SUX | Sioux City ATCT/TRACON | 5 | 0.1416
New York | SYR | Syracuse ATCT/TRACON | 6 | 0.1416
Missouri | T75 | St. Louis TRACON | 9 | 0.1416
New Jersey | TEB | Teterboro ATCT | 7 | 0.2872
Florida | TLH | Tallahassee ATCT/TRACON | 7 | 0.1416
Florida | TMB | [NAME] | 7 | 0.2079
California | TOA | Torrance ATCT | 5 | 0.2716
Ohio | TOL | Toledo ATCT/TRACON | 6 | 0.1416
Florida | TPA | Tampa ATCT/TRACON | 10 | 0.1416
Tennessee | TRI | Tri-Cities ATCT/TRACON | 6 | 0.1416
Oklahoma | TUL | Tulsa International ATCT/TRACON | 8 | 0.1416
Arizona | TUS | Tucson ATCT | 7 | 0.1416
Michigan | TVC | Traverse City | 5 | 0.1416
Idaho | TWF | [NAME] | 5 | 0.1416
Tennessee | TYS | Knoxville ATCT/TRACON | 7 | 0.1416
Arizona | U90 | Tucson TRACON | 8 | 0.1416
Nevada | VGT | North Las Vegas | 6 | 0.1416
California | VNY | Van Nuys ATCT | 8 | 0.2716
Florida | VRB | Vero Beach ATCT | 6 | 0.1416
Connecticut | Y90 | Bradley TRACON | 8 | 0.2582
Michigan | [NAME] | Yipsilanti ATCT | 4 | 0.2409
Ohio | YNG | Youngstown ATCT/TRACON | 6 | 0.1416
New Mexico | ZAB | Albuquerque ARTCC | 10 | 0.1416
Alaska | ZAN | Anchorage ARTCC | 10 | 0.2772
Illinois | ZAU | Chicago ARTCC | 12 | 0.251
New Hampshire | ZBW | Boston ARTCC | 11 | 0.248
Virginia | ZDC | [NAME] | 12 | 0.2422
Colorado | ZDV | Denver ARTCC | 10 | 0.2252
Texas | ZFW | Fort Worth ARTCC | 12 | 0.2067
Texas | ZHU | [NAME] | 11 | 0.2871
Indiana | ZID | Indianapolis ARTCC | 12 | 0.1468
Florida | ZJX | [NAME] | 11 | 0.1416
Kansas | ZKC | Kansas City ARTCC | 11 | 0.1416
California | ZLA | Los Angeles ARTCC | 12 | 0.2716
Utah | ZLC | Salt Lake City ARTCC | 10 | 0.1416
Florida | ZMA | Miami ARTCC | 11 | 0.2079
Tennessee | ZME | Memphis ARTCC | 12 | 0.1416
Minnesota | ZMP | Minneapolis ARTCC | 11 | 0.2096
New York | ZNY | New York ARTCC | 12 | 0.2872
California | ZOA | Oakland ARTCC | 11 | 0.3515
Ohio | ZOB | Cleveland ARTCC | 12 | 0.1868
Washington | ZSE | [NAME] | 10 | 0.2181
Georgia | ZTL | Atlanta ARTCC | 12 | 0.1929