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