Spreadsheet: 124335d1318340977-data-validation-and-if-function-project-cals
Sheet: Location

 |  | States
Alabama |  | Alabama | Birmingham | 3.8
Alaska |  |  | Huntsville | 3.6
Arizona |  |  | Mobile | 4.6
Arkansas |  |  | Montgomery | 4.2
California |  | Alaska | Fairbanks | 1
Colorado |  |  | Juneau | 0.6
Connecticut |  | Arizona | Flagstaff | 2.4
Delaware |  |  | Nogales | 3.1
DC |  |  | Phoenix | 2.5
Florida |  |  | Yuma | 1.6
Georgia |  | Arkansas | Fort Smith | 3.6
Hawaii |  |  | Little Rock | 3.7
Idaho |  |  | Texarkana | 3.8
Illinois |  | California | Barstow | 1.4
Indiana |  |  | Crescent City | 1.5
Iowa |  |  | Fresno | 1.1
Kansas |  |  | Los angeles | 2.1
Kentucky |  |  | Needles | 1.6
Louisiana |  |  | Placerville | 1.5
Maine |  |  | San Fernando | 2.3
Maryland |  |  | San Francisco | 1.5
Massachusetts |  |  | [NAME] | 1.4
Michigan |  | Colorado | [NAME] | 1.5
Minnesota |  |  | Denver | 2.4
Mississippi |  |  | Durango | 1.8
Missouri |  |  | Grand Junction | 1.7
Montana |  |  | Lamar | 3
Nebraska |  |  | Pueblo | 2.5
Nevada |  | Connecticut | Hartford | 2.7
New Hampshire |  |  | New Haven | 2.8
New Jersey |  |  | Putnam | 2.6
New Mexico |  | Delaware | Georgetown | 3
New York |  |  | [NAME] | 3.1
North Carolina |  | Distric of Columbia | Washington | 3.2
North Dakota
Ohio |  | Florida | Jacksonville | 4.3
Oklahoma |  |  | Key West | 4.3
Oregon |  |  | Miami | 4.7
Pennsylvania |  |  | Pensacola | 4.6
Rhode Island |  |  | Tampa | 4.5
South Carolina |  | Georgia | Atlanta | 3.7
South Dakota |  |  | [NAME] | 3.4
Tennessee |  |  | Macon | 3.9
Texas |  |  | Savannah | 4.3
Utah |  |  | Thomasville | 4.3
Vermont |  | Hawaii | Hilo | 6.2
Virginia |  |  | Honolulu | 3
Washington |  |  | Wailuku | 3
West Virginia |  | Idaho | Boise | 0.9
Wisconsin |  |  | Lewiston | 1.1
Wyoming |  |  | Pocatello | 1.2
 |  | Illinois | Cairo | 3.3
 |  |  | Chicago | 3
 |  |  | Peoria | 3.3
 |  |  | Rockford | 3.2
 |  |  | Springfield | 3.3
 |  | Indiana | Evansville | 3.2
 |  |  | [NAME] | 2.9
 |  |  | Indianapolis | 3.1
 |  | Iowa | Davenport | 3.3
 |  |  | Des Moines | 3.4
 |  |  | Dubuque | 3.3
 |  |  | Sioux City | 3.6
 |  | Kansas | Atwood | 3.3
 |  |  | Dodge City | 3.3
 |  |  | Topeka | 3.7
 |  |  | Wichita | 3.7
 |  | Kentucky | Ashland | 3
 |  |  | Lexington | 3.1
 |  |  | Louisville | 3.2
 |  |  | Middlesboro | 3.2
 |  |  | Paducah | 3.3
 |  | Louisiana | [NAME] | 4.2
 |  |  | Lake Providence | 4
 |  |  | New Orleans | 4.8
 |  |  | Shreveport | 3.9
 |  | Maine | Bangor | 2.2
 |  |  | Houlton | 2.1
 |  |  | Portland | 2.4
 |  | Maryland | Baltimore | 3.2
 |  |  | Hagerstown | 2.8
 |  |  | Oakland | 2.7
 |  |  | Salisbury | 3.1
 |  | Massachusetts | Boston | 2.5
 |  |  | Pittsfield | 2.8
 |  |  | Worcester | 2.7
 |  | Michigan | Alpena | 2.5
 |  |  | Detroit | 2.7
 |  |  | Grand Rapids | 2.6
 |  |  | Lansing | 2.8
 |  |  | Marquette | 2.4
 |  |  | [NAME] | 2.2
 |  | Minnesota | Duluth | 2.8
 |  |  | [NAME] | 2.3
 |  |  | Minneapolis | 3.1
 |  |  | Moorhead | 3.2
 |  |  | Worthington | 3.5
 |  | Mississippi | [NAME] | 4.7
 |  |  | Columbus | 3.9
 |  |  | Corinth | 3.6
 |  |  | Natchez | 4.4
 |  |  | Vicksburg | 4.1
 |  | Missouri | Columbia | 3.2
 |  |  | Kansas City | 3.6
 |  |  | Springsfield | 3.4
 |  |  | St. Louis | 3.2
 |  | Montana | Ekalaka | 2.5
 |  |  | Havre | 1.6
 |  |  | Helena | 1.5
 |  |  | Kalispell | 1.2
 |  |  | Missoula | 1.3
 |  | Nebraska | North Platte | 3.3
 |  |  | Omaha | 3.8
 |  |  | Scottsbluff | 3.1
 |  |  | [NAME] | 3.2
 |  | Nevada | Elko | 1
 |  |  | [NAME] | 1.1
 |  |  | Las Vegas | 1.4
 |  |  | Reno | 1.1
 |  | New Hampshire | Berlin | 2.5
 |  |  | Concord | 2.5
 |  |  | [NAME] | 2.4
 |  | New Jersey | Atlantic City | 2.9
 |  |  | Newark | 3.1
 |  |  | Trenton | 3.1
 |  | New Mexico | Albuquerque | 2
 |  |  | Hobbs | 3
 |  |  | Raton | 2.5
 |  |  | Roswell | 2.6
 |  |  | Silver City | 1.9
 |  | New York | Albany | 2.5
 |  |  | [NAME] | 2.3
 |  |  | Buffalo | 2.3
 |  |  | Kingston | 2.7
 |  |  | New York | 3
 |  |  | Rochester | 2.2
 |  | North Carolina | Asheville | 4.1
 |  |  | Charlotte | 3.7
 |  |  | Greensboro | 3.4
 |  |  | [NAME] | 4.2
 |  | North Dakota | Bismarck | 2.8
 |  |  | Devils Lake | 2.9
 |  |  | Fargo | 3.1
 |  |  | Williston | 2.6
 |  | Ohio | Cincinnati | 2.9
 |  |  | Cleveland | 2.6
 |  |  | Columbus | 2.8
 |  |  | Toledo | 2.8
 |  | Oklahoma | Altus | 3.7
 |  |  | Boise City | 3.3
 |  |  | Durant | 3.8
 |  |  | Oklahoma City | 3.8
 |  | Oregon | [NAME] | 0.9
 |  |  | Coos Bay | 1.5
 |  |  | [NAME] | 1.3
 |  |  | Portland | 1.2
 |  | Pennsylvania | Erie | 2.6
 |  |  | Harrisburg | 2.8
 |  |  | Philadelphia | 3.1
 |  |  | Pittsburg | 2.6
 |  |  | Scranton | 2.7
 |  | Rhode Island | Block Island | 2.75
 |  |  | Providence | 2.6
 |  | South Carolina | Charleston | 4.3
 |  |  | Columbia | 4
 |  |  | Greenville | 4.1
 |  | South Dakota | Buffalo | 2.8
 |  |  | Huron | 3.3
 |  |  | [NAME] | 3.1
 |  |  | Rapid City | 2.9
 |  |  | Yankton | 3.6
 |  | Tennessee | Chattanooga | 0.5
 |  |  | Knoxville | 3.2
 |  |  | Memphis | 3.7
 |  |  | Nashville | 3.3
 |  | Texas | Abilene | 3.6
 |  |  | Amarillo | 3.5
 |  |  | Brownsville | 4.5
 |  |  | Dallas | 4
 |  |  | Del Rio | 4
 |  |  | El Paso | 2.3
 |  |  | Houston | 4.6
 |  |  | Lubbock | 3.3
 |  |  | Odessa | 3.2
 |  |  | Pecos | 3
 |  |  | San Antonio | 4.2
 |  | Utah | Brigham City | 1.2
 |  |  | Roosevelt | 1.3
 |  |  | Salt Lake City | 1.3
 |  |  | St. George | 1.7
 |  | Vermont | [NAME] | 2.3
 |  |  | Bratteboro | 2.7
 |  |  | Burlington | 2.1
 |  |  | Rutland | 2.5
 |  | Virginia | Bristol | 2.7
 |  |  | Charlottesville | 2.8
 |  |  | Lynchburg | 3.2
 |  |  | Norfolk | 3.4
 |  |  | Richmond | 3.3
 |  | Washington | Omak | 1.1
 |  |  | Port Angeles | 1.1
 |  |  | Seatle | 1.4
 |  |  | Spokane | 1
 |  |  | Yakima | 1.1
 |  | West Virginia | Charleston | 2.8
 |  |  | Morgantown | 2.7
 |  | Wisconsin | Ashland | 2.5
 |  |  | [NAME] | 2.9
 |  |  | Green Bay | 2.6
 |  |  | La Crosse | 3.1
 |  |  | [NAME] | 3
 |  |  | Milwaukee | 3
 |  | Wyoming | [NAME] | 2.2
 |  |  | [NAME] | 1.3
 |  |  | Lander | 1.5
 |  |  | New Castle | 2.5
 |  |  | [NAME] | 1.7
 |  |  | Yellowstone Park | 1.4