Skip to page navigation
U.S. flag

An official website of the United States government

Official websites use .gov
A .gov website belongs to an official government organization in the United States.

Secure .gov websites use HTTPS
A lock ( ) or https:// means you’ve safely connected to the .gov website. Share sensitive information only on official, secure websites.

OPM.gov / Policy / Pay & Leave / Salaries & Wages
Skip to main content

Information about Spreadsheet Format

Information about Spreadsheet Format

The Excel spreadsheet contains General Schedule rates of pay for 2017.

  • Column A in the spreadsheet contains the codes for the locality pay area.
  • Column B contains grades,
  • Column C contains the annual rates for step 1,
  • Column D contains the hourly rates for step 1, and
  • Column E contains the hourly overtime rates for step 1.
  • Subsequent columns contain similar information for steps 2 through 10.

Locality codes used in the file are as shown in the table below:

Locality Pay AreaLocality Code
Albany-Schenectady, NY AL
Albuquerque-Santa Fe-Las Vegas, NM AQ
Atlanta-Athens-Clarke County-Sandy Springs, GA-AL ATL
Austin-Round Rock, TX AU
Boston-Worcester-Providence, MA-RI-NH-CT-ME BOS
Buffalo-Cheektowaga, NY BU
Charlotte-Concord, NC-SC CT
Chicago-Naperville, IL-IN-WI CHI
Cincinnati-Wilmington-Maysville, OH-KY-IN CIN
Cleveland-Akron-Canton, OH CLE
Colorado Springs, CO CS
Columbus-Marion-Zanesville, OH COL
Dallas-Fort Worth, TX-OK DFW
Davenport-Moline, IA-IL DV
Dayton-Springfield-Sidney, OH DAY
Denver-Aurora, CO DEN
Detroit-Warren-Ann Arbor, MI DET
Harrisburg-Lebanon, PA HB
Hartford-West Hartford, CT-MA HAR
Houston-The Woodlands, TX HOU
Huntsville-Decatur-Albertville, AL HNT
Indianapolis-Carmel-Muncie, IN IND
Kansas City-Overland Park-Kansas City, MO-KS KC
Laredo, TX LR
Las Vegas-Henderson, NV-AZ LV
Los Angeles-Long Beach, CA LA
Miami-Fort Lauderdale-Port St. Lucie, FL MFL
Milwaukee-Racine-Waukesha, WI MIL
Minneapolis-St. Paul, MN-WI MSP
New York-Newark, NY-NJ-CT-PA NY
Palm Bay-Melbourne-Titusville, FL PB
Philadelphia-Reading-Camden, PA-NJ-DE-MD PHL
Phoenix-Mesa-Scottsdale, AZ PX
Pittsburgh-New Castle-Weirton, PA-OH-WV PIT
Portland-Vancouver-Salem, OR-WA POR
Raleigh-Durham-Chapel Hill, NC RA
Richmond, VA RCH
Sacramento-Roseville, CA-NV SAC
San Diego-Carlsbad, CA SD
San Jose-Ssn Francisco-Oakland, CA SF
Seattle-Tacoma, WA SEA
St. Louis-St. Charles-Farmington, MO-IL SL
Tucson-Nogales, AZ TU
Washington-Baltimore-Arlington, DC-MD-VA-WV-PA DCB
Rest of U.S. RUS
State of Alaska AK
State of Hawaii HI

Please call Pay Systems at 202-606-2838 or email us at Pay-Leave-Policy@opm.gov if you have questions about the spreadsheet.

Control Panel