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

MapPoint Routes: Multiple start points, one stop point.

This is a discussion on MapPoint Routes: Multiple start points, one stop point. within the MapPoint Desktop Discussion forums, part of the Map Forums category; I have user data in excel that includes address. I have plotted each user in mappoint, but want to show ...

  1. #1
    samalyst is offline Junior Member White Belt
    Join Date
    Feb 2012
    Posts
    2

    MapPoint Routes: Multiple start points, one stop point.

    I have user data in excel that includes address. I have plotted each user in mappoint, but want to show the route from each of these users to a single location. My end goal is to find the most used routes so I can strategically place a billboard ad where the most people will see it on the way to a certain location. Is there a way to do this?

  2. #2
    Eric Frost's Avatar
    Eric Frost is offline Administrator Black Belt
    Join Date
    Jul 1992
    Posts
    5,069
    Blog Entries
    4

    Re: MapPoint Routes: Multiple start points, one stop point.

    Hi Samalyst, welcome to the forums! How long have you been using MapPoint? What version?

    You could do it with a little bit of automation using Excel macro's controlling MapPoint. How many routes/users?

    Assuming there's a lot, I would probably tackle it by looping over all the users, drawing the route, and extracting coordinates along the route (article & code in the MapForums Downloads section $99 Extracting Coordinates of a Route ).

    You'd end up with a ton of points on top of each other.

    Then, to group them, I think I would export lat/lon's and simply round to the nearest hundredth e.g. lat/lon 40.12345/-90.12345 becomes 40.12/-90.12. (I'd play with that a bit to see what rounding factor works best, maybe five hundredth or one thousandth.) Then group these and get a count using a pivot table or Access, and re-map the grouped result using the Sized Circle map. Then I think you would get a pretty clear picture of the most traveled roads. Make sense?

    Some of this is a little bit advanced e.g. writing the macro to loop over and create all the routes, extracting the lat/lon's, etc. but nothing terribly sophisticated either. Sounds like a fun project! I'd be happy to work with you on a training/consulting basis to get over the hurdles, or if you have any specific questions feel free to post here.

    Eric
    m: 312-399-1586
    ~ Order MapPoint MapPoint 2013 Here and Get Free Access to the MapForums Downloads ~
    ~~
    ~ Upgrade to Get Access to the MapForums Downloads ~

  3. #3
    samalyst is offline Junior Member White Belt
    Join Date
    Feb 2012
    Posts
    2

    Re: MapPoint Routes: Multiple start points, one stop point.

    Thanks for the reply. I've been using MapPoint 2011 on and off for about a year. Your solutions sounds a little more complicated than my skills will allow. This is not something that I need, it just seemed like a simple thing that should be built into MapPoint, and would've been a useful tool.

  4. #4
    Eric Frost's Avatar
    Eric Frost is offline Administrator Black Belt
    Join Date
    Jul 1992
    Posts
    5,069
    Blog Entries
    4

    Re: MapPoint Routes: Multiple start points, one stop point.

    Makes sense.

    It's funny that MapPoint can be used in so many different ways, depending on the industry and scenarios people think of MapPoint as a very different tool. I don't know if I'm making sense, but for my wife, MapPoint is strictly a restaurant searching tool, when she would travel she'd use it to hunt down Indian or Korean restaurants. Other people only use MapPoint for graphing out and visualizing sales data. My point is that something you think would be obvious and simple thing, is actually very niche when you consider the extremely broad range of what MapPoint is capable of out of the box and the various ways people use it. The fact that it can be automated and integrated with other software makes it that much more powerful.

    In any case, I'm still interested in your project, it does sound very interesting. Would you be interested in working with me to create an article of your project for publication in one of our upcoming newsletters? I'd work on the technical aspects and you could provide and background and storyline. Then you could get it done for free, and you'd also generate a little free press for your company .

    Thanks!
    Eric
    ~ Order MapPoint MapPoint 2013 Here and Get Free Access to the MapForums Downloads ~
    ~~
    ~ Upgrade to Get Access to the MapForums Downloads ~

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Multiple Start Points and One Destination
    By redclanger in forum MapPoint Desktop Discussion
    Replies: 4
    Last Post: 03-11-2011, 08:12 PM
  2. Mappoint 2006 --> how to set start/end/stop point
    By andrea in forum Development
    Replies: 0
    Last Post: 04-14-2008, 02:50 AM
  3. automate stop duration and multiple routes
    By samlinc in forum MapPoint Desktop Discussion
    Replies: 1
    Last Post: 01-22-2006, 10:44 AM
  4. Calculating Lat/Long of Start,Stop,End points of a Route
    By Anonymous in forum MapPoint Desktop Discussion
    Replies: 3
    Last Post: 02-07-2005, 12:50 PM
  5. Route Planning (Multiple Point to Points)
    By robertuva in forum MapPoint Desktop Discussion
    Replies: 1
    Last Post: 06-15-2004, 04:19 PM

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