Spreadsheet: 70414d1271172883-spreading-percent-based-upon-criteria-example-col
Sheet: 1stExerciseCALC(4)(100=0)

 |  |  |  |  | 1st Step | 2nd Step | 3rd Step | Assigning
 |  |  |  |  | Cost-of-Living | Reindexing | Reindexing | COL
 |  |  |  |  | (15M User- | with NATCA- | with | Values
 |  |  |  | HEAD- | Defined Area† as a | City Average | 1 | (4-10%)
Facility | PAGE |  | CITY | COUNT | % of U.S. Average) | (105.847%=100%) | =0.0%
Term | 7 |  | Aspen, CO* | 13 | 1.607
Term | 13 |  | Nantucket, MA* | 13 | 1.503
Term | 3 |  | San Francisco, CA |  | 1.389
Term | 5 |  | Honolulu, HI |  | 1.383
Term | 7 |  | Santa Clara, CA | 19 | 1.358
Term | 7 |  | Palo Alto, CA | 12 | 1.355
Term | 12 |  | San Jose, CA | 12 | 1.343
Term | 6 |  | [NAME], HI | 16 | 1.329
Term | 10 |  | Santa Monica, CA | 14 | 1.323
Term | 9 |  | Fremont, CA |  | 1.32
Term | 2 |  | Burbank, CA | 19 | 1.294
Term | 7 |  | Los Angeles, CA |  | 1.289
Term | 5 |  | Van Nuys, CA | 23 | 1.286
Term | 2 |  | Jamaica, NY |  | 1.282
EnRte | 1 |  | Juneau, AK | 10 | 1.28
Term | 10 |  | Hayward, CA | 12 | 1.274
Term | 4 |  | Oakland, CA | 27 | 1.271
Term | 10 |  | Livermore, CA | 11 | 1.262
Term | 10 |  | San Diego, CA |  | 1.256
Term | 9 |  | Flushing, NY |  | 1.256
Term | 13 |  | Westbury, NY |  | 1.254
Term | 12 |  | Bedford, MA | 16 | 1.248
Term | 4 |  | West Harrison, NY | 18 | 1.246
Term | 13 |  | San Diego, CA | 13 | 1.245
Term | 12 |  | Carlsbad, CA | 16 | 1.244
EnRte | 1 |  | Farmingdale, NY | 13 | 1.244
Term | 12 |  | Boston, MA |  | 1.239
Term | 3 |  | Goleta, CA | 32 | 1.238
Term | 13 |  | Costa Mesa, CA | 32 | 1.236
Term | 12 |  | Napa, CA | 11 | 1.22
Term | 12 |  | Teterboro, NJ |  | 1.219
Term | 5 |  | Newark, NJ |  | 1.215
Term | 6 |  | Ronkonkoma, NY |  | 1.213
Term | 6 |  | Ronkonkoma, NY | 18 | 1.213
Term | 12 |  | [NAME], CA | 8 | 1.209
Term | 12 |  | Concord, CA | 10 | 1.207
Term | 6 |  | Hilo, HI* | 13 | 1.201
Term | 12 |  | Anchorage, AK |  | 1.197
Term | 11 |  | Anchorage, AK | 26 | 1.197
Term | 2 |  | Washington, DC |  | 1.197
Term | 12 |  | San Diego, CA | 23 | 1.196
Term | 8 |  | Torrance, CA | 13 | 1.195
Term | 12 |  | Morristown, NJ | 13 | 1.188
Term | 11 |  | Andrews AFB, MD | 16 | 1.188
Term | 7 |  | St. Thomas, Virgin Islands | 8 | 1.186
EnRte | 1 |  | Elmendorf AFB, AK |  | 1.184
Term | 7 |  | Anchorage, AK | 14 | 1.184
Term | 7 |  | Sterling, VA |  | 1.182
EnRte | 1 |  | Fairfield, NJ   2/ | 12 | 1.181
Term | 3 |  | Camarillo, CA | 11 | 1.18
Term | 6 |  | El Cajon, CA | 14 | 1.18
Term | 3 |  | Long Beach, CA | 24 | 1.173
Term | 6 |  | El Monte, CA | 13 | 1.171
Term | 11 |  | Fairbanks, AK | 21 | 1.171
Term | 10 |  | Manassas, VA | 16 | 1.165
Term | 3 |  | Atlantic City, NJ | 30 | 1.162
Term | 12 |  | Santa Rosa, CA | 8 | 1.162
Term | 9 |  | [NAME], CA | 14 | 1.152
Term | 4 |  | [NAME], CA | 13 | 1.151
Term | 12 |  | Traverse City, MI* | 11 | 1.145
Term | 11 |  | Morrisville, NC | 51 | 1.14
Term | 11 |  | [NAME], MA | 24 | 1.137
Term | 10 |  | Longmont, CO |  | 1.13
Term | 11 |  | Miami, FL | 14 | 1.128
Term | 9 |  | Seattle, WA | 24 | 1.128
Term | 12 |  | [NAME], NH |  | 1.127
EnRte | 1 |  | Miami, FL |  | 1.12
Term | 11 |  | Ontario, CA | 20 | 1.12
Term | 12 |  | Miami, FL |  | 1.117
Term | 7 |  | [NAME], WA | 16 | 1.114
Term | 11 |  | Mather, CA |  | 1.114
EnRte | 1 |  | Chicago, IL |  | 1.109
Term | 5 |  | Palm Springs, CA | 12 | 1.108
Term | 4 |  | Sacramento, CA | 15 | 1.106
Term | 12 |  | Philadelphia, PA | 18 | 1.1
Term | 10 |  | Baltimore, MD |  | 1.096
Term | 9 |  | [NAME], NY | 9 | 1.095
Term | 11 |  | Wheeling, IL | 18 | 1.095
Term | 8 |  | Chicago, IL | 31 | 1.093
Term | 10 |  | Broomfield, CO | 17 | 1.092
Term | 9 |  | Grand Canyon, AZ | 8 | 1.092
Term | 10 |  | Windsor Locks, CT | 16 | 1.092
Term | 11 |  | Windsor Locks, CT | 29 | 1.092
Term | 10 |  | Bangor, ME | 24 | 1.091
Term | 10 |  | St. Paul, MN | 16 | 1.091
Term | 10 |  | Fort Lauderdale, FL | 17 | 1.089
Term | 7 |  | Seattle, WA |  | 1.087
Term | 9 |  | Seattle, WA | 32 | 1.087
Term | 10 |  | Eden Prairie, MN | 16 | 1.085
Term | 5 |  | Philadelphia, PA |  | 1.083
Term | 9 |  | Minneapolis, MN | 16 | 1.082
Term | 10 |  | [NAME], FL | 33 | 1.082
Term | 9 |  | Minneapolis, MN |  | 1.081
Term | 10 |  | Minneapolis, MN |  | 1.081
Term | 10 |  | Warwick, RI | 36 | 1.081
Term | 7 |  | Fresno, CA | 31 | 1.08
Term | 10 |  | Fort Lauderdale, FL |  | 1.079
Term | 2 |  | Latham, NY | 29 | 1.079
Term | 2 |  | Warrenton, VA |  | 1.079
Term | 11 |  | Sarasota, FL | 15 | 1.077
Term | 8 |  | Freeland, MI | 19 | 1.077
EnRte | 1 |  | Charleston, SC | 30 | 1.076
Term | 9 |  | [NAME], NH |  | 1.073
Term | 10 |  | New Castle, DE | 15 | 1.072
Term | 7 |  | Stockton, CA | 11 | 1.071
Term | 6 |  | Richmond, VA | 20 | 1.07
Term | 9 |  | Englewood, CO | 21 | 1.07
Term | 9 |  | Farmington, MN |  | 1.067
Term | 9 |  | Merrimack, NH |  | 1.067
EnRte | 1 |  | Hillsboro, OR | 15 | 1.066
Term | 9 |  | West Chicago, IL | 15 | 1.065
Term | 9 |  | Auburn, WA |  | 1.062
EnRte | 1 |  | Elgin, IL |  | 1.062
Term | 3 |  | Edwards, CA |  | 1.062
Term | 8 |  | Phoenix, AZ | 21 | 1.061
Term | 12 |  | Scottsdale, AZ | 15 | 1.06
Term | 2 |  | Denver, CO |  | 1.059
Term | 3 |  | Denver, CO |  | 1.059
Term | 7 |  | Portland, OR |  | 1.059
Term | 3 |  | Portland, OR | 28 | 1.059
Term | 9 |  | Tucson, AZ | 20 | 1.056
EnRte | 1 |  | Tucson, AZ | 27 | 1.056
EnRte | 1 |  | [NAME], IL |  | 1.055
Term | 5 |  | [NAME], IL | 11 | 1.055
Term | 2 |  | Jacksonville, FL | 45 | 1.054
Term | 2 |  | Newport News, VA | 19 | 1.054
EnRte | 1 |  | South Burlington, VT | 22 | 1.054
Term | 7 |  | Waterford, MI | 21 | 1.054
Term | 9 |  | Phoenix, AZ |  | 1.053
Term | 9 |  | Phoenix, AZ |  | 1.053
Term | 3 |  | Virginia Beach, VA | 43 | 1.051
Term | 8 |  | New Orleans, LA | 39 | 1.049
Term | 10 |  | Bakersfield, CA | 22 | 1.049
Term | 9 |  | Portland, ME | 23 | 1.049
Term | 8 |  | Clearwater, FL | 19 | 1.048
Term | 8 |  | Lansing, MI | 28 | 1.047
Term | 8 |  | West Palm Beach, FL | 41 | 1.047
Term | 8 |  | Greensboro, NC | 38 | 1.047
Term | 5 |  | Ann Arbor, MI | 9 | 1.046
Term | 8 |  | Syracuse, NY | 27 | 1.044
Term | 8 |  | Fayetteville, NC | 28 | 1.042
EnRte | 1 |  | Cleveland,OH |  | 1.041
Term | 12 |  | Detroit, MI |  | 1.041
Term | 8 |  | Detroit, MI |  | 1.041
Term | 5 |  | Prescott, AZ | 17 | 1.038
Term | 9 |  | Daytona Beach, FL | 64 | 1.036
Term | 2 |  | Palmdale, CA |  | 1.036
Term | 8 |  | [NAME], WI | 25 | 1.035
Term | 9 |  | New Orleans, LA | 15 | 1.034
Term | 6 |  | Reno, NV | 22 | 1.034
Term | 8 |  | Milwaukee, WI | 56 | 1.034
Term | 7 |  | Mesa, AZ | 17 | 1.033
Term | 11 |  | Columbus, GA | 7 | 1.031
Term | 8 |  | Muskegoh, MI | 23 | 1.03
EnRte | 1 |  | [NAME], OR | 24 | 1.028
Term | 6 |  | Hope Hull, AL | 21 | 1.028
Term | 2 |  | Fletcher, NC | 21 | 1.027
Term | 7 |  | Rome, NY | 6 | 1.027
Term | 12 |  | Leesburg, VA |  | 1.026
Term | 8 |  | Colorado Springs, CO | 32 | 1.024
Term | 8 |  | Addison, TX | 16 | 1.023
Term | 7 |  | Grand Rapids, MI | 30 | 1.023
Term | 7 |  | Tampa, FL | 80 | 1.022
Term | 7 |  | Mobile, AL | 24 | 1.021
Term | 2 |  | [NAME], IL | 18 | 1.021
Term | 6 |  | Olathe, KS |  | 1.021
Term | 7 |  | Belleville, MI | 16 | 1.02
Term | 7 |  | [NAME], NC | 22 | 1.02
Term | 7 |  | North Las Vegas, NV | 20 | 1.019
Term | 10 |  | Las Vegas, NV |  | 1.019
Term | 7 |  | Las Vegas, NV |  | 1.019
Term | 13 |  | Charlotte, NC |  | 1.018
Term | 2 |  | Dallas, TX | 28 | 1.017
Term | 9 |  | Dallas, TX |  | 1.017
Term | 6 |  | Dallas, TX |  | 1.017
Term | 7 |  | Atlanta, GA | 20 | 1.016
Term | 9 |  | Roanoke, VA | 29 | 1.016
Term | 8 |  | Pasco, WA | 19 | 1.016
Term | 11 |  | Rochester, NY | 30 | 1.014
Term | 3 |  | [NAME], OH |  | 1.014
Term | 5 |  | Orlando, FL | 16 | 1.011
Term | 6 |  | Orlando, FL | 57 | 1.009
Term | 6 |  | Orlando, FL | 33 | 1.009
Term | 4 |  | Terre Haute, IN | 21 | 1.009
Term | 7 |  | Salt Lake City, UT |  | 1.008
Term | 11 |  | Salt Lake City, UT |  | 1.008
Term | 5 |  | Salt Lake City, UT | 34 | 1.008
Term | 6 |  | Savoy, IL | 23 | 1.006
Term | 3 |  | Portage, MI | 25 | 1.005
Term | 10 |  | Swanton, OH | 24 | 1.005
Term | 12 |  | Atlanta, GA |  | 1.004
Term | 11 |  | Birmingham, AL | 31 | 1.004
Term | 6 |  | Rochester, MN | 15 | 1.004
Term | 5 |  | Sanford, FL | 21 | 1.004
Term | 4 |  | Buffalo, NY | 29 | 1.003
Term | 2 |  | Lafayette, LA | 26 | 1.003
Term | 6 |  | Bridgeton, MO | 27 | 1.002
Term | 6 |  | Savannah, GA | 29 | 1.002
Term | 6 |  | Kansas City, MO | 43 | 1.002
EnRte | 1 |  | Tallahassee, FL | 28 | 1.002
Term | 8 |  | East St. Louis, IL | 14 | 1.001
Term | 13 |  | Cedar Rapids, IA | 20 | 1.001
Term | 11 |  | Chesterfield, MO | 15 | 1.001
Term | 10 |  | Vandalia, OH | 38 | 1.001
Term | 8 |  | APO, National Average | 21 | 1
EnRte | 1 |  | Ft. Worth, TX |  | 0.999
Term | 11 |  | Flint, MI | 24 | 0.998
Term | 11 |  | Greer, SC | 22 | 0.998
Term | 8 |  | Allentown, PA | 29 | 0.997
Term | 5 |  | El Paso, TX | 22 | 0.997
Term | 6 |  | Kansas City, MO | 16 | 0.996
Term | 6 |  | Rockford, IL | 28 | 0.996
Term | 5 |  | Columbus, OH | 53 | 0.995
Term | 6 |  | West Columbia, SC | 29 | 0.995
Term | 5 |  | Duluth, MN | 22 | 0.994
Term | 3 |  | Albuquerque, NM |  | 0.993
Term | 6 |  | [NAME], NM | 44 | 0.993
Term | 2 |  | Carolina, Puerto Rico |  | 0.993
Term | 5 |  | San Juan, Puerto Rico | 17 | 0.993
Term | 5 |  | Baton Rouge, LA | 22 | 0.991
Term | 5 |  | [NAME], TX | 47 | 0.99
Term | 5 |  | Fort Worth, TX | 16 | 0.99
Term | 3 |  | Green Bay, WI | 25 | 0.99
Term | 5 |  | Ft. Worth, TX | 18 | 0.99
Term | 6 |  | Augusta, GA | 21 | 0.99
EnRte | 1 |  | Vero Beach, FL | 11 | 0.99
Term | 5 |  | Louisville, KY | 13 | 0.989
EnRte | 1 |  | Louisville, KY | 45 | 0.989
Term | 11 |  | Houston, TX | 26 | 0.988
Term | 5 |  | Fort Pierce, FL | 14 | 0.987
Term | 5 |  | Memphis, TN |  | 0.987
Term | 3 |  | Memphis, TN | 35 | 0.987
Term | 5 |  | Memphis, TN | 32 | 0.987
Term | 5 |  | Lincoln, NE | 16 | 0.987
Term | 4 |  | Tomball, TX | 16 | 0.987
Term | 5 |  | Peachtree City, GA |  | 0.985
Term | 11 |  | Reading, PA | 15 | 0.985
Term | 3 |  | Boise, ID | 28 | 0.984
Term | 13 |  | Evansville, IN | 21 | 0.984
Term | 9 |  | [NAME], ID | 9 | 0.984
Term | 7 |  | St. Charles, MO |  | 0.983
Term | 8 |  | [NAME], LA | 25 | 0.982
Term | 3 |  | Fargo, ND | 22 | 0.981
Term | 11 |  | Sioux City, IA | 13 | 0.981
Term | 11 |  | Des Moines, IA | 29 | 0.981
Term | 4 |  | Florence, SC | 20 | 0.98
Term | 4 |  | Monroe, LA | 15 | 0.98
Term | 4 |  | Omaha, NE | 17 | 0.979
Term | 4 |  | South Bend, IN | 28 | 0.979
Term | 11 |  | West Lafayette, IN | 11 | 0.979
Term | 11 |  | Bellevue, NE | 22 | 0.978
Term | 4 |  | Spokane, WA | 31 | 0.978
Term | 12 |  | Pueblo, CO | 15 | 0.978
Term | 5 |  | Erie, PA | 20 | 0.977
Term | 8 |  | Myrtle Beach, SC | 26 | 0.977
Term | 3 |  | Helena, MT | 13 | 0.976
Term | 4 |  | Gulfport, MS | 18 | 0.975
Term | 4 |  | Springfield, MO | 34 | 0.974
Term | 6 |  | San Antonio, TX | 52 | 0.973
Term | 4 |  | Lexington, KY | 25 | 0.973
Term | 12 |  | Huntington, WV | 23 | 0.972
Term | 4 |  | Canton, OH | 28 | 0.972
Term | 4 |  | Springfield, IL | 17 | 0.972
Term | 4 |  | Wichita, KS | 42 | 0.971
Term | 12 |  | Johnson City, NY | 14 | 0.97
Term | 4 |  | Lake Charles, LA | 20 | 0.97
Term | 9 |  | Erlanger, KY |  | 0.969
Term | 4 |  | [NAME], IN | 26 | 0.969
EnRte | 1 |  | Houston, TX |  | 0.968
Term | 4 |  | Houston, TX |  | 0.968
Term | 4 |  | Houston, TX | 48 | 0.968
Term | 4 |  | [NAME], MT | 17 | 0.966
Term | 10 |  | Tulsa, OK | 36 | 0.966
EnRte | 1 |  | Indianapolis, IN |  | 0.965
Term | 4 |  | Indianapolis, IN | 57 | 0.965
Term | 8 |  | Pittsburgh, PA | 55 | 0.964
Term | 3 |  | Hampton, GA |  | 0.964
Term | 4 |  | Little Rock, AR | 35 | 0.964
Term | 12 |  | Abilene, TX | 23 | 0.963
Term | 12 |  | Moses Lake, WA* | 19 | 0.961
Term | 4 |  | [NAME], SD | 19 | 0.961
Term | 3 |  | Peoria, IL | 20 | 0.96
Term | 11 |  | Blountville, TN | 20 | 0.96
Term | 3 |  | Bridgeport, WV | 16 | 0.957
Term | 3 |  | Chattanooga, TN | 23 | 0.957
Term | 12 |  | Middletown, PA | 26 | 0.957
Term | 3 |  | Vienna, OH | 23 | 0.956
Term | 2 |  | Meridian, MS* | 15 | 0.955
Term | 10 |  | Billings, MT | 22 | 0.954
Term | 3 |  | Horseheads, NY | 13 | 0.953
Term | 13 |  | West Mifflin, PA | 16 | 0.953
Term | 3 |  | Amarillo, TX | 23 | 0.952
Term | 8 |  | Tulsa, OK | 19 | 0.952
Term | 10 |  | Lubbock, TX | 20 | 0.951
Term | 3 |  | Beaumont, TX | 16 | 0.95
EnRte | 1 |  | Nashville, TN | 52 | 0.947
Term | 2 |  | Mansfield, OH | 15 | 0.947
Term | 3 |  | Roswell, NM* | 15 | 0.947
Term | 2 |  | Pittston, PA | 26 | 0.946
Term | 7 |  | Casper, WY | 12 | 0.944
Term | 2 |  | Charleston, WV | 24 | 0.938
Term | 6 |  | Huntsville, AL | 20 | 0.936
Term | 9 |  | Bismarck, ND | 14 | 0.935
Term | 2 |  | Pearl, MS | 20 | 0.934
Term | 2 |  | Pensacola, FL | 35 | 0.934
Term | 2 |  | Pensacola, FL | 12 | 0.934
EnRte | 1 |  | [NAME], AR | 32 | 0.932
Term | 8 |  | [NAME], IA | 18 | 0.932
Term | 2 |  | Corpus Christi, TX | 50 | 0.931
Term | 2 |  | Grand Forks, ND | 16 | 0.929
Term | 2 |  | Oklahoma City, OK | 37 | 0.927
EnRte | 1 |  | Hilliard, FL |  | 0.91
Term | 11 |  | Longview, TX | 17 | 0.909
Term | 6 |  | Lake City, TN | 33 | 0.9
Term | 2 |  | [NAME], TX | 16 | 0.887
Term | 2 |  | Midland, TX* | 26 | 0.875
 |  |  | Total Headcount |  | AVERAGE | AVERAGE | AVERAGE
 |  |  | Count of Number of Stations