Information about Spreadsheet Format
Information about Spreadsheet Format
The Excel spreadsheet contains General Schedule rates of pay for 2011.
- 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.