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