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 2012.

  • 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
Atlanta ATL
Boston BOS
Buffalo BU
Chicago CHI
Cincinnati CIN
Cleveland CLE
Columbus COL
Dallas DFW
Dayton DAY
Denver DEN
Detroit DET
Hartford HAR
Houston HOU
Huntsville HNT
Indianapolis IND
Los Angeles LA
Miami MFL
Milwaukee MIL
Minneapolis MSP
New York NY
Philadelphia PHL
Phoenix PX
Pittsburgh PIT
Portland POR
Raleigh RA
Richmond RCH
Sacramento SAC
San Diego SD
San Francisco SF
Seattle SEA
Washington, DC DCB
Rest of U.S. RUS
State of Alaska AK
State of Hawaii HI
Nonforeign Areas as Defined in 5 CFR Part 591 ON

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