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

Mileage Chart

This is a discussion on Mileage Chart within the MapPoint Desktop Discussion forums, part of the Map Forums category; I am currenlty looking to to create a mileage chart for 1 location in northern California. Is there a way ...

  1. #1
    mpnewb is offline Junior Member White Belt
    Join Date
    Aug 2004
    Posts
    1

    Mileage Chart

    I am currenlty looking to to create a mileage chart for 1 location in northern California. Is there a way that MapPoint can determine mileage from a centerpoint (Fremont, California) to all surrounding cities within a 100 mile radius?

    Current method is to choose the city I am starting from (Fremont) and typing in all the cities surrounding Fremont to determine miles. As you might have guessed it is not very efficiant, and I am looking for a better way to do this.

    Any help would be greatly appreciated.

    Current Version of MapPoint is 2004
    I have city information in Excel spread sheet (text)
    If it will help I can obtain city Zip codes (numeric). I have seen a few places on these Forums that MP does not like text strings.

    P.S. If there is a MapPoint plugin or script that handles this and was posted on this forum and I missed it, I appologize.

    Thanks in Advance,

    mpnewb

  2. #2
    Eric Frost's Avatar
    Eric Frost is offline Administrator Black Belt
    Join Date
    Jul 1992
    Posts
    5,094
    Blog Entries
    4
    This can be coded in pretty short order as an Excel VBA macro..

    If you're willing to publish the results as an article for this magazine, I'd be willing to offer some assistance.

    Send me a private message if you're interested.

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

  3. #3
    Anonymous is offline Senior Member Black Belt
    Join Date
    Jul 2002
    Posts
    5,137
    I have 220 stores with 25 District Managers and would like to create a mileage chart with mileage from any one point to any other, kind of like you see on the top of the maps, the grid with 5 or 6 cities, except I have 245 different places. I have Street Atlas USA Plus and it is no help. I can mapquest.com it for free if I had 2 years. There has to be a better way.

  4. #4
    Eric Frost's Avatar
    Eric Frost is offline Administrator Black Belt
    Join Date
    Jul 1992
    Posts
    5,094
    Blog Entries
    4
    hehe, yeah MapPoint is pretty nice in that you can automate map calculations easily.. note that I've automated StreetAtlas with WinBatch, it can work.

    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. Need help with unsized pie chart in mappoint using vba
    By Anonymous in forum MapPoint Desktop Discussion
    Replies: 0
    Last Post: 02-22-2005, 09:41 AM
  2. Creating Mileage Charts
    By ekrupa in forum MapPoint Desktop Discussion
    Replies: 2
    Last Post: 11-30-2004, 09:37 AM
  3. mileage report for employees
    By Anonymous in forum MapPoint Desktop Discussion
    Replies: 0
    Last Post: 02-11-2004, 07:34 AM
  4. find mileage using two zipcodes onlh
    By Anonymous in forum MapPoint Desktop Discussion
    Replies: 1
    Last Post: 07-08-2003, 04:30 PM
  5. Retrieving mileage & time
    By EJBATL in forum MapPoint Desktop Discussion
    Replies: 0
    Last Post: 06-30-2003, 03: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