Information about Spreadsheet Format
The Excel spreadsheet contains General Schedule rates of pay for 2015.
- 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 Area | Locality 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 |
Please call Pay Systems at 202-606-2838 or email us at Pay-Leave-Policy@opm.gov if you have questions about the spreadsheet.