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

Huge Number of Drive Times

This is a discussion on Huge Number of Drive Times within the MapPoint Desktop Discussion forums, part of the Map Forums category; I want to find the drive times between a huge number of zip codes, or geocodes. I only have a ...

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

    Huge Number of Drive Times

    I want to find the drive times between a huge number of zip codes, or geocodes. I only have a very basic understanding of VB programming though. I don't just want the drive time polygons on the map, I want the data to write out to excel or access. I was told that this was possible. Is it? And how?

    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
    Try looking at our MileCharter product:

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


    Add your required locations to MapPoint as pushpins. Then run Milecharter, and it can calculate the distances, travel times, route costs, etc between these locations.

    If you want distances from one group of pins to another (eg. depots to customers), then you should put each group in its own pushpinset.


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

  3. #3
    lbequis is offline Junior Member White Belt
    Join Date
    Aug 2005
    Posts
    2
    That helps, but if it's outputting to Excel the way it is, that limits you to 256 locations at a time. Is there another way?

  4. #4
    Winwaed's Avatar
    Winwaed is offline Mapping-Tools.com Black Belt
    Join Date
    Feb 2004
    Location
    Irving,Texas
    Posts
    1,859
    Blog Entries
    60
    You can span charts across multiple sheets within the same spreadsheet, because of the 256 column limit in Excel. You did ask for Excel

    With spanning, the limit becomes about 65500 (Excel also has a 65536 row limit).


    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. Get distances/driving times between waypoints
    By Jonathan Shields in forum MapPoint Desktop Discussion
    Replies: 2
    Last Post: 01-25-2006, 07:39 AM
  2. Schedule Stop Times
    By Anonymous in forum MapPoint Desktop Discussion
    Replies: 13
    Last Post: 06-06-2005, 04:41 AM
  3. Import stop times?
    By PBrantley in forum MapPoint Desktop Discussion
    Replies: 0
    Last Post: 03-22-2005, 10:57 AM
  4. Huge memory leak in using QueryShape?
    By random0000 in forum MapPoint Desktop Discussion
    Replies: 2
    Last Post: 03-28-2003, 06:22 AM
  5. Planning a route after arrival times
    By Anonymous in forum MapPoint Desktop Discussion
    Replies: 0
    Last Post: 02-24-2003, 08:11 AM

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