Free Zip Codes - Excel With Long/Lat and Distance Calculator in Fayetteville, Arkansas For Sale
Type: Computer,
For Sale
- Private.
The file contains all of the US zip codes, along with their geographic locations. The workbook calculates distance from a reference zip code, using the longitude and latitude coordinates included in the data set. A flag is set so that you can filter the results efficiently. The final distance is expressed in miles.
Distance Calculation:
d = acos(sin(lat1)*sin(lat2)+cos(lat1)*cos(lat2)*cos(long2?long1))*R
The file contains 81,000 rows. (9 Mbytes)
http://www.sharexl.com/?p=826
See more useful Excel workbooks at www.sharexl.com. Excel workbook repair and VBA programming support.
Jerry