Click here to skip navigation
An official website of the United States Government.
Skip Navigation

In This Section

Pay & Leave Salaries & Wages

Information about Spreadsheet Format

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

  • 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-SAN 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