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 8 of 8

Optimize multiple stops

This is a discussion on Optimize multiple stops within the MapPoint Desktop Discussion forums, part of the Map Forums category; Can anyone help with a problem? I have multiple stops to make, say about 5 a day / call it ...

  1. #1
    petekk is offline Junior Member White Belt
    Join Date
    Aug 2005
    Posts
    1

    Optimize multiple stops

    Can anyone help with a problem?

    I have multiple stops to make, say about 5 a day / call it 100 month?

    Is there any software (mappoint or otherwise) where I can enter all 100 stops, and it will plan a route each day.

    Autoroute will optimise the stops but not let me return home each nightt. This is similar to the TSP, but it would be allowable to visit the same city twice if required (i.e if you pass through on the way to somewhere else)

    This must be a common requirement? Is there a way to acheive it?

  2. #2
    Winwaed's Avatar
    Winwaed is offline Mapping-Tools.com Black Belt
    Join Date
    Feb 2004
    Location
    Irving,Texas
    Posts
    1,859
    Blog Entries
    60
    Hi Peterkk,

    I've just sent you a private message: I think I can help you.


    Richard
    Winwaed Software Technology LLC
    http://www.winwaed.com
    See http://www.mapping-tools.com for MapPoint Tools

  3. #3
    rbarthels is offline Member Green Belt
    Join Date
    Nov 2002
    Posts
    52

  4. #4
    paulus is offline Junior Member White Belt
    Join Date
    Sep 2005
    Posts
    7
    I have exactly the same problem. I'm using mappoint 2004 and Excel, nothing else. I made a excel sheet with customers who needs to be visited.
    for example, in 1 week 30 costumers needs to be visited, I have their name, zipcode etc in an excel sheet. I use the import data wizard to load these customers into my Map I have created in Mappoint. then I use the route planning option to calculate the most efficient route.
    I use my adress where I live as start point.
    i set the start and end time of my driving day in the more route options, for example start driving at 8.00 and stop driving at 18.00

    in the route schedule my last costumer who fits into the planning for 1 day is my last pushpin. day 2 starts at that pushpin.

    But I want to add that mappoint calculates the way home, and use my home adress as the starting point for day 2, 3,4 and 5 So I can get 5 mini routes for all 5 days.


    Paul

  5. #5
    Winwaed's Avatar
    Winwaed is offline Mapping-Tools.com Black Belt
    Join Date
    Feb 2004
    Location
    Irving,Texas
    Posts
    1,859
    Blog Entries
    60
    If you can wait a few weeks Paul, send me an email, or private message with your email; and I'll get back to you with what I'm doing and how I think I can help.



    Richard
    Winwaed Software Technology LLC
    http://www.winwaed.com
    See http://www.mapping-tools.com for MapPoint Tools

  6. #6
    paulus is offline Junior Member White Belt
    Join Date
    Sep 2005
    Posts
    7
    Thanks a lot, but I'm sorry, I can't wait a few weeks because it is an assesment for my education. I'm "working" at a company right now and I'm doing some research for them.
    my assesment has to be ready in 4 weeks, so I don't have time to wait.

    but they want to use mappoint only for creating routes.

    little description:

    that company has 4 salesmanager who are visiting consumers every day in the Netherlands.

    I made a map of The netherlands and I created 4 territorys in Mappoint, 1 for each sales manager.

    then I made a excel sheet with all costumers, their zipcode and territory etc.

    so the only thing I want to do is:

    1) import costumers who needs to be visited that week( per territory)
    2) make a efficient route, the start and stop adress of every day is the adress of the sales manager.

    this is a TSP isn't it?

    Paul

  7. #7
    Winwaed's Avatar
    Winwaed is offline Mapping-Tools.com Black Belt
    Join Date
    Feb 2004
    Location
    Irving,Texas
    Posts
    1,859
    Blog Entries
    60
    yes, but if you only work with one salesperson at once, and already know which customers for that day's route, then MapPoint can do that out of the box.

    The problem is the division of the customers into independent daily routes.


    If the salesperson didn't have to go home each night, and remained on the road (eg. staying in hotels); then you could get MapPoint to optimize a route of all customers all at once.



    Richard
    Winwaed Software Technology LLC
    http://www.winwaed.com
    See http://www.mapping-tools.com for MapPoint Tools

  8. #8
    paulus is offline Junior Member White Belt
    Join Date
    Sep 2005
    Posts
    7
    yes I know already whick costumers needs to be visited, I work also with one person at once.
    but the problem is that there are too many customers for 1 day. off course I can select a few customers for one day, and create a route so I can create 5 single routes. but that isn't the most efficient way to do it.

    Now I have started using VRP from www.free-routing.com but I can't select planning per week, only per day, is this possible?

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Multiple Stops
    By Anonymous in forum MapPoint Desktop Discussion
    Replies: 3
    Last Post: 09-19-2009, 01:14 AM
  2. Optimize Progress Bar
    By Metod in forum MapPoint Desktop Discussion
    Replies: 15
    Last Post: 11-16-2005, 02:13 PM
  3. Handling Route that Calculates but does not Optimize
    By Eric Frost in forum MapPoint Desktop Discussion
    Replies: 4
    Last Post: 03-07-2005, 03:07 PM
  4. Optimize Events
    By Anonymous in forum MapPoint Desktop Discussion
    Replies: 0
    Last Post: 12-03-2003, 12:45 PM
  5. Optimize and calculate a Route
    By rms62 in forum MapPoint Desktop Discussion
    Replies: 2
    Last Post: 08-22-2003, 03:55 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 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96