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