ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Is there a way to calculate distance between 2 zipcodes? (https://www.excelbanter.com/excel-programming/390010-there-way-calculate-distance-between-2-zipcodes.html)

Serissa

Is there a way to calculate distance between 2 zipcodes?
 
I need to use some service to dynamically calcualte distance between two
zipcodes. Do you know about anything like this?

JLGWhiz

Is there a way to calculate distance between 2 zipcodes?
 
You could check the USPS website for a zip code index to give you the
locations and then maybe Rand-McNally to get the mileage estimates between
the cities that the zip codes apply to. As far as a single point of
reference. Nope, I don't know of one. But somebody probably has one
somewhere.

"Serissa" wrote:

I need to use some service to dynamically calcualte distance between two
zipcodes. Do you know about anything like this?


NickHK

Is there a way to calculate distance between 2 zipcodes?
 
There are lists of zip code, town, long/lat data. As long as you can get
from zip code to long/lat, you can use trig to calculate the straight line
distance, assuming you can approximate to a flat surface, although slightly
more work will allow for the curvature of the Earth.
This list looks pretty comprehensive:
http://www.cfdynamics.com/cfdynamics/zipbase/index.cfm
and sample code
http://www.zipcodeworld.com/samples/distance.vbs.txt

Or look into querying a suitable website. e.g.
http://www.zipinfo.com/cgi-local/zip...ip=77380&Go=Go

Also, accuracy may not be that high, as zipcodes are areas, but you would
have to assume a single point for calculation. There a discussion of some
salient points he
http://www.webmasterworld.com/forum10/6530.htm

NickHK

"Serissa" wrote in message
...
I need to use some service to dynamically calcualte distance between two
zipcodes. Do you know about anything like this?




JSpence2003

Is there a way to calculate distance between 2 zipcodes?
 
You can definately do this if you have the lat/long of the zip centroid.

There are several website that will give you that.

Then you just set up a Macro in Excel to plot the distance between the 2
points.

If you google Excel Distance Macro, you should find it. If not let me know
and I will email you the script.

Jason

"Serissa" wrote:

I need to use some service to dynamically calcualte distance between two
zipcodes. Do you know about anything like this?



All times are GMT +1. The time now is 07:08 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com