Information about Spreadsheet Format
Information about Spreadsheet Format
The Excel spreadsheet contains General Schedule rates of pay for 2025, and—
- 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,
- Column E contains the hourly overtime rates for step 1, and
- 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-MA | AL |
Albuquerque-Santa Fe-Las Vegas, NM | AQ |
Atlanta-Athens-Clarke County-Sandy Springs, GA-AL | ATL |
Austin-Round Rock-Georgetown, TX |
AU |
Birmingham-Hoover-Talladega, AL | BH |
Boston-Worcester-Providence, MA-RI-NH-CT-ME-VT |
BOS |
Buffalo-Cheektowaga-Olean, NY |
BU |
Burlington-South Burlington-Barre, VT |
BN |
Charlotte-Concord, NC-SC | CT |
Chicago-Naperville, IL-IN-WI | CHI |
Cincinnati-Wilmington-Maysville, OH-KY-IN | CIN |
Cleveland-Akron-Canton, OH-PA |
CLE |
Colorado Springs, CO | CS |
Columbus-Marion-Zanesville, OH | COL |
Corpus Christi-Kingsville-Alice, TX | CC |
Dallas-Fort Worth, TX-OK | DFW |
Davenport-Moline, IA-IL | DV |
Dayton-Springfield-Kettering, OH |
DAY |
Denver-Aurora, CO | DEN |
Des Moines-Ames-West Des Moines, IA | DM |
Detroit-Warren-Ann Arbor, MI | DET |
Fresno-Madera-Hanford, CA |
FN |
Harrisburg-Lebanon, PA | HB |
Hartford-East Hartford, CT-MA |
HAR |
Houston-The Woodlands, TX | HOU |
Huntsville-Decatur, AL-TN |
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-Port St. Lucie-Fort Lauderdale, FL |
MFL |
Milwaukee-Racine-Waukesha, WI | MIL |
Minneapolis-St. Paul, MN-WI | MSP |
New York-Newark, NY-NJ-CT-PA | NY |
Omaha-Council Bluffs-Fremont, NE-IA | OM |
Palm Bay-Melbourne-Titusville, FL | PB |
Philadelphia-Reading-Camden, PA-NJ-DE-MD | PHL |
Phoenix-Mesa, AZ |
PX |
Pittsburgh-New Castle-Weirton, PA-OH-WV | PIT |
Portland-Vancouver-Salem, OR-WA | POR |
Raleigh-Durham-Cary, NC |
RA |
Reno-Fernley, NV |
RN |
Richmond, VA | RCH |
Rochester-Batavia-Seneca Falls, NY |
RT |
Sacramento-Roseville, CA-NV | SAC |
San Antonio-New Braunfels-Pearsall, TX | SO |
San Diego-Chula Vista-Carlsbad, CA |
SD |
San Jose-San Francisco-Oakland, CA | SF |
Seattle-Tacoma, WA | SEA |
Spokane-Spokane Valley-Coeur d'Alene, WA-ID |
SN |
St. Louis-St. Charles-Farmington, MO-IL | SL |
Tucson-Nogales, AZ | TU |
Virginia Beach-Norfolk, VA-NC | VB |
Washington-Baltimore-Arlington, DC-MD-VA-WV-PA | DCB |
Rest of U.S. | RUS |
State of Alaska | AK |
State of Hawaii | HI |
Please email us at PayPolicy@opm.gov if you have questions about the spreadsheet.