Welcome to MapForums!

Register, sign in, or use Facebook Connect above to join in and participate in the forum.

When you are signed in, this message, the ads in this row, and the red-underlined link ads all go away.

 Subscribe to receive our newsletter. Subscribe Unsubscribe

Fast Calculation of Driving Distance between 2 points

This is a discussion on Fast Calculation of Driving Distance between 2 points within the Wish List forums, part of the MapPoint Desktop Discussion category; I could use a fast calculation of the Driving Distance and Driving Time between two locations. Perhaps if the map ...

1. Junior Member Yellow Belt
Join Date
Mar 2003
Posts
13

Fast Calculation of Driving Distance between 2 points

I could use a fast calculation of the Driving Distance and Driving Time between two locations. Perhaps if the map were not drawn and the itinerary not created these values could be returned much faster?

2. Senior Member Black Belt
Join Date
Jul 2002
Posts
5,137

Re: Fast Calculation of Driving Distance between 2 points

Originally Posted by Bob Chase
I could use a fast calculation of the Driving Distance and Driving Time between two locations. Perhaps if the map were not drawn and the itinerary not created these values could be returned much faster?

3. Senior Member Black Belt
Join Date
Jul 2002
Posts
5,137
Totally - I'm using MapPoint within an Excel MAcro and the calculate method looks SLOW. Any faster ways of getting driving distance between two points I don't know of?

4. Senior Member Black Belt
Join Date
Jul 2002
Posts
5,137

5. Senior Member Black Belt
Join Date
Jul 2002
Posts
5,137
We are in the middle of building a table of locations (more than a thousand locations, actually) with distances between each location pair. The end result is a pivot table of all of our locations, with mileages noted (not unlike the mileage grids one might find in maps and atlases. We have an Excel macro that grabs the mileages from MapPoint right now. It's not very efficient (yet), but it's reasonably fast. When it's done we can post it here.

6. Senior Member Black Belt
Join Date
Jul 2002
Posts
5,137

mappoint matchmaker software

I think that what you need is this:

http://www.tufat.com/script.php?id_num=8

This program basically take in 2 Excel spreadsheets and computes a table of driving distances from them.

7. Senior Member Black Belt
Join Date
Jul 2002
Posts
5,137

distances

Hi everybody,

I would like to calculate ditances between a list of zipcodes and one town.
These zipcodes are in an excel file.
Mappoint match maker won't allow me to do that because it needs full adresses. Do you know another way of doing that ( could you please give me your macro even if it is slow?)

Thank you very much

Sebastien

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•