MapForums
Community of VE/MapPoint Users and Developers
Calculate driving distance matrix in Excel
This is a discussion on Calculate driving distance matrix in Excel within the MapPoint 2006/2009 Discussion forums, part of the Map Forums category; I am new to Mappoint. I need to access Mappoint from Excel, calculate a large driving distance matrix (50 x ...
| |||||||
| Register | Blogs | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
07-21-2007
| |||
| |||
| Calculate driving distance matrix in Excel Is this doable in mappoint? How do I go about it if it is? THanks! DaveOKC         |
|
07-21-2007
| |||
| |||
| Re: Calculate driving distance matrix in Excel
Hi Dave, Mile-Charter might be a viable option for you ... MileCharter: Create Mileage Charts with Microsoft® MapPoint® |
|
07-22-2007
| ||||
| ||||
| Re: Calculate driving distance matrix in Excel
Yes it would do what you want - except it runs from within MapPoint rather than Excel. Use the Data Import Wizard in MapPoint to load your data into MapPoint. Load the source locs as one pushpin set, load the destination locs as a different pushpin set. Then run MileCharter, and it will create the matrix in Excel. Richard
__________________ Winwaed Software Technology LLC http://www.winwaed.com See http://www.mapping-tools.com for MapPoint Tools Pre-Order MapPoint 2009 today: http://www.mapping-tools.com/mappoint2009 |
|
07-22-2007
| |||
| |||
| Re: Calculate driving distance matrix in Excel
Richard - thanks for the input. One question however - about how long would it take to generate a 50 x 100 matrix (table/chart) in Excel? I saw a comment on the Milecharter website that indicated it might take some time to do this. Thanks DaveOKC |
|
07-22-2007
| ||||
| ||||
| Re: Calculate driving distance matrix in Excel
It really depends on how far apart the locations are... but say it takes two seconds per route, then 2 x 50 x 200 = about 6 hours I think. As long as you precalculate I think it's fairly reasonable. Eric |
|
07-22-2007
| |||
| |||
| Re: Calculate driving distance matrix in Excel
Good point on the route distances. Most of the measurements will be from 1/2 mile to 4 miles. If the average time is two seconds, or even one second, this will pose a problem for me. Can anyone verify this for me? DaveOKC |
|
07-23-2007
| ||||
| ||||
| Re: Calculate driving distance matrix in Excel
The route calculation time is due to MapPoint. MileCharter adds virtually no overhead (I made sure of that!). My rule of thumb (on a P4 @2.4GHz) is 1 second per route. That is an average US route - ie. lots of AK-CA would take longer. Within one State is noticeably less (0.5sec perhaps). 4 miles should be even less. (The rule of thumb comes from some timing tests I did in MapPoint before MileCharter was written. The test data was spread across the eastern half of the US). There's also an option to hide MapPoint during processing. This can be inconvenient if you're using the PC for something else at the same time, but it removes the overhead of MapPoint drawing each and every route. I would expect this to be fairly constant per route length - so more significant for shorter routes. Also your PC is probably faster than my P4 example. Try it - there's a free 14 day trial. Richard
__________________ Winwaed Software Technology LLC http://www.winwaed.com See http://www.mapping-tools.com for MapPoint Tools Pre-Order MapPoint 2009 today: http://www.mapping-tools.com/mappoint2009 |
|
07-24-2007
| |||
| |||
 Re: Calculate driving distance matrix in Excel
Dave, I've built an Excel model that does just the thing You input the Lat/longs and it outputs the following: - a map of all the points - a road distance matrix - a straight-line matrix - a speed matrix - a time matrix - and a 'wiggle' matrix (road/straight-line) You can also select whether you want miles/kms, shortest/quickest, mins/hours and so on, plus drivetime zones for the map itself. Send me an email and I'll send you the model. If it's for personal use then I won't charge... Adam |
 |
| ||||
| Posted By | For | Type | Date | |
| Gmane -- Mail To News And Back Again | This thread | Refback | 01-26-2008 03:34 PM | |
| The Magazine for MapPoint - MP2K Magazine | This thread | Refback | 08-02-2007 02:56 PM | |
| Working With Excel and MapPoint - MP2K Magazine | This thread | Refback | 07-28-2007 01:50 AM | |
| About MP2Kmag - MP2K Magazine | This thread | Refback | 07-23-2007 07:30 AM | |
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests) | |
| Thread Tools | |
| Display Modes | |
Linear Mode
| |
| ||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| How do I get the driving distance of two addresses? | dawa | MapPoint 2006/2009 Discussion | 5 | 04-18-2008 01:23 AM |
| Driving Distance from a Point | BC1968 | MapPoint 2006/2009 Discussion | 4 | 07-21-2007 08:04 AM |
| Distance matrix question | routesmith | MapPoint Web Service and Virtual Earth | 1 | 04-10-2006 02:58 PM |
| Driving distance between two postcodes | zippy | MapPoint 2006/2009 Discussion | 2 | 10-24-2004 10:56 PM |
| SHORTEST DRIVING DISTANCE | Anonymous | MapPoint Web Service and Virtual Earth | 1 | 07-29-2004 07:51 PM |
All times are GMT -5. The time now is 02:07 AM.
