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
Results 1 to 7 of 7

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. #1
    Bob Chase is offline 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. #2
    Anonymous is offline Senior Member Black Belt
    Join Date
    Jul 2002
    Posts
    5,137

    Re: Fast Calculation of Driving Distance between 2 points

    Quote 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. #3
    Anonymous is offline 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. #4
    Anonymous is offline Senior Member Black Belt
    Join Date
    Jul 2002
    Posts
    5,137

  5. #5
    Anonymous is offline 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. #6
    Anonymous is offline 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. #7
    Anonymous is offline 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

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. How do I get the driving distance of two addresses?
    By dawa in forum MapPoint Desktop Discussion
    Replies: 5
    Last Post: 04-18-2008, 02:23 AM
  2. Automate large list of drive time & distance calculation
    By onegalacticwino in forum MapPoint Desktop Discussion
    Replies: 1
    Last Post: 12-13-2004, 02:14 PM
  3. Distance Calculation
    By jburgess in forum MapPoint Desktop Discussion
    Replies: 2
    Last Post: 11-06-2004, 09:33 PM
  4. Driving distance between two postcodes
    By zippy in forum MapPoint Desktop Discussion
    Replies: 2
    Last Post: 10-24-2004, 11:56 PM
  5. SHORTEST DRIVING DISTANCE
    By Anonymous in forum Bing Maps and MapPoint Web Service
    Replies: 1
    Last Post: 07-29-2004, 08:51 PM

Tags for this Thread

Posting Permissions

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


1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36