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

MPMileCharter Example: Finding only the Three Closest Stores to each Customer

This is a discussion on MPMileCharter Example: Finding only the Three Closest Stores to each Customer within the MP2K Magazine Articles forums, part of the Map Forums category; Read http://www.mapforums.com/using-mpmil...int-17397.html for an Introduction to MPMileCharter MPMileCharter comes with two license levels. The ‘Basic’ level includes most of MPMileCharter’s ...

  1. #1
    Richard Marsden is offline Junior Member White Belt
    Join Date
    Jun 2011
    Posts
    5

    MPMileCharter Example: Finding only the Three Closest Stores to each Customer

    Read Using MPMileCharter to create Mileage Charts with Microsoft MapPoint for an Introduction to MPMileCharter

    MPMileCharter comes with two license levels. The ‘Basic’ level includes most of MPMileCharter’s features and supports all of MapPoint’s route options. The ‘Professional’ license adds the ability to pause and restart processing runs (useful if your PC has to be restarted or switched off during a processing run); and the ability to only report the closest destinations. This latter feature is very powerful. Not only does it simplify the output by having the option to sort the destinations closest first, but MPMileCharter is clever enough to know when routes have no chance of being amongst the closest. It can safely skip these route calculations, resulting in huge speedups on large processing runs.

    This example demonstrates how to use MPMileCharter to report the route distances from each customer to the three closest stores, ie. to find the three closest stores for each customer. The demonstration map can be found in the MPMileCharter examples file:

    http://www.milecharter.com/downloads/examples_3.zip

    The map is called chicago_customers.ptm, and requires MapPoint 2006 North America. The map looks like this:



    The roads have been switched off for clarity. The map contains two pushpin sets (groups of pushpins). Sales Offices contains pushpins for a series of sales offices in Illinois and Indiana. Most are in the Chicago area. Customers contains pushpins for each of the customers. We wish to find our three closest sales offices for each customer with upper limits of 50 miles and 70 minutes. Do this by setting MPMileCharter's options as follows:



    We want routes that start at our customers and finish at our sales offices. This will result in MPMileCharter reporting the closest Sales Offices for each Customer, and not the other way around. We also wish to see the distances and travel times for each sales office, so check Distances and Travel Times. We also want to see the shortest (rather than fastest) routes, so select Shortest Routes.

    To find the closest stores only, check the Only report shortest/quickest routes checkbox. We want the three closest sales offices, so enter '3' in the Find the closest locations box. We also restrict the distance and travel times to 50 miles and 70 minutes, respectively. We also want to list the closest sales offices in order closest-first, so check Rank routes in ascending order.

    Press Compute to start processing. The resulting chart of the closest sales offices will look like this:



    Notice that the customer 'David Brown' only has one sales office within the specified criteria of 50 miles and 70 minutes.

    And that is how simple it is to find the closest destinations from a group of pushpins. For further details and a free 14 day trial download, see the official MPMileCharter website at:

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

  2. #2
    Rosevillerod is offline Junior Member White Belt
    Join Date
    Sep 2011
    Posts
    5

    Re: MPMileCharter Example: Finding only the Three Closest Stores to each Customer

    I am really interested in this product and downloaded the 14 day free trial....my problem is my data set is about 650 pushpins (although if this works, this one will be small compared to what I would eventually use it for). That creates a matrix of almost 400,000 calculations. MapPoint seems to crash at about 100,000 calculations and I lose the work done.
    Any ideas?

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

    Re: MPMileCharter Example: Finding only the Three Closest Stores to each Customer

    MapPoint runs slower with large batch route calculations due to memory management that is designed for interactive use.

    There are a few options:

    - The Pause & Restart functionality was partly added to help solve this problem. Pause a job run as it slows. Exit MPMileCharter and MapPoint. Restart MapPoint, re-load your map file, start MPMileCharter, Restart. (this requires the Professional License)

    - Use the "Find Closest" option to only report the shortest/fastest destinations. This is clever enough to skip routes that have no chance of reaching the final result. Hence greater speed and far fewer routes need to be calculated. (this requires the Professional License)

    - Use our MPMileage product instead ( MPMileage: Batch calculate mileages with Microsoft MapPoint ). Rather than bulk group-to-group calculations, this computes a long list of point-to-point routes. This might be more appropriate to your application (for a full matrix table, you would have to create your own list of routes from the source&destination lists). MPMileage is clever enough to restart MapPoint, so avoiding the memory management problem. It can also take advantage of multiple processor machines for large speed improvements.

    - Finally, you can split your data into smaller chunks, and run multiple jobs.


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

  4. #4
    Rosevillerod is offline Junior Member White Belt
    Join Date
    Sep 2011
    Posts
    5

    Re: MPMileCharter Example: Finding only the Three Closest Stores to each Customer

    Thanks Richard. I have doen the first two suggestions, however the data run times are so larger I let my PC run overnight and in the morning it had crashed. smaller data sizes would be onerous due to the large scale of my task.
    I had tried a a VBA MapPoint object model and encountered the same crashing issues....
    Regarding the MPMileage Application, is there a short term free trial version available?

    Thanks

    Rod

  5. #5
    Rosevillerod is offline Junior Member White Belt
    Join Date
    Sep 2011
    Posts
    5

    Re: MPMileCharter Example: Finding only the Three Closest Stores to each Customer

    Also, does the MPMileage program calculate travel time? That's the number I need, not mileage....thanks!!

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

    Re: MPMileCharter Example: Finding only the Three Closest Stores to each Customer

    Yes there's a 14 day trial - see the web link above.
    Yes supports all of MapPoint's routing features, distances, travel times, and costs.
    It takes more setting up though, but on a modern PC it can be a lot faster (and a new version in testing is faster still).

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

  7. #7
    kavit is offline Junior Member White Belt
    Join Date
    Sep 2012
    Posts
    2

    Re: MPMileCharter Example: Finding only the Three Closest Stores to each Customer

    A bit urgent
    Hi,
    Is the professional licence for 1 year or for a lifetime?

    Also, please tell the lifetime of a Map point licence as well
    Thanks
    Rajit
    Last edited by kavit; 11-30-2012 at 03:45 AM.

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

    Re: MPMileCharter Example: Finding only the Three Closest Stores to each Customer

    The "Professional License" is lifetime and includes minor version updates (3.1, 3.2, 3.3, etc). Major upgrades may require purchasing a (usually discounted) license upgrade (ie. 2.* -> 3.* upgrades have a fee).
    Note that we cannot predict what Microsoft will do with regard to MapPoint, Excel, and Windows; so it is possible that MPMileCharter v3 will not work with future versions of any of these products. Such situations may require an upgrade.

    MapPoint licenses are also lifetime and do not include updates or discounted upgrades.
    Winwaed Software Technology LLC
    http://www.winwaed.com
    See http://www.mapping-tools.com for MapPoint Tools

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. MPMileCharter v3.0 Released!
    By Winwaed in forum Press Releases
    Replies: 1
    Last Post: 07-18-2011, 01:33 PM
  2. Using MPMileCharter to create Mileage Charts with Microsoft MapPoint
    By Richard Marsden in forum MP2K Magazine Articles
    Replies: 0
    Last Post: 06-06-2011, 04:36 PM
  3. How to Map stores from competitors
    By aalfredogq in forum Wish List
    Replies: 0
    Last Post: 01-30-2009, 09:18 AM
  4. Optimum Location between stores.
    By Anonymous in forum MapPoint Desktop Discussion
    Replies: 1
    Last Post: 04-03-2004, 09:46 AM
  5. Finding closest 10 locations
    By Anonymous in forum MapPoint Desktop Discussion
    Replies: 1
    Last Post: 11-19-2003, 04:59 AM

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