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

Creating Mileage Charts

This is a discussion on Creating Mileage Charts within the MapPoint Desktop Discussion forums, part of the Map Forums category; I work in the headquarter office of Minor League Baseball, and I am looking to create a huge mileage chart ...

  1. #1
    ekrupa is offline Junior Member White Belt
    Join Date
    Sep 2004
    Posts
    2

    Creating Mileage Charts

    I work in the headquarter office of Minor League Baseball, and I am looking to create a huge mileage chart that shows the shortest drivable route between the 160 Minor League Baseball clubs in the United States. I have all of the street addresses in Excel, and I would like to know if MapPoint has the ability to create a chart, preferable a matrix like you see in an atlas. I could use MapQuest for free and input every possible combination, but I really don't have a year to spend on this project.

    Is MapPoint capable of handling this task? I would be satisfied if MapPoint can calculate the mileage for each datapoint, and I will type them into a matrix.

    Thanks.

  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
    I've written something similar for a client in the past.

    The source and destination addresses (they were separate in that application) were stored in an Excel-compatible CSV file. My program then used MapPoint to find all the addresses and find the route distances.

    The biggest issue is speed. 160 addresses comes out as 12,720 route distances to find.

    In the previous application, I found each route took about 1 second (but it increases with lots of routes, due to poor/lazy memory management in MapPoint).
    If 1/sec can be maintained, then 12,720 works out at about 3 and a half hours.

    It could be quickly coded in VB if you're upto doing a bit of programming, or I could be hired to produce a tailor-made program for you (my choice would be C++).


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

  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
    Wow! The above thread resulted in quite a few email and private message queries!

    I have since written an add-in to compute mileage charts. Called "MileCharter", it can produce traditional "road atlas" style charts or charts like the parent post refers to. It can also compute route distances, travel times, and estimated costs.
    For further details and free download, see:

    http://www.mapping-tools.com/milecharter/index.shtml


    Richard
    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. Mapping-Tools.com releases pre-computed US mileage charts
    By Winwaed in forum News and Announcements
    Replies: 1
    Last Post: 11-14-2006, 08:43 AM
  2. Help Please!!! With Mapping information to pie charts
    By DCM in forum MapPoint Desktop Discussion
    Replies: 3
    Last Post: 12-16-2005, 10:33 AM
  3. Automatic Bar/Pie Charts (with Data from SQLServer)
    By webjagger in forum MapPoint Desktop Discussion
    Replies: 3
    Last Post: 05-27-2004, 11:16 AM
  4. How can I change charts size?
    By julior in forum MapPoint Desktop Discussion
    Replies: 0
    Last Post: 03-12-2004, 05:22 AM
  5. Sized Pie Charts - Legend Query
    By stephen kilbee in forum MapPoint Desktop Discussion
    Replies: 0
    Last Post: 01-15-2004, 01:20 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