View Full Version : Distance between 1 Point and 600 other (each)

09-05-2011, 03:57 PM
Hi everybody,

first of all, i want to apologize if my english isn't perfect, i'm no native speaker.

i am totally new to mappoint and i need help for, what i at first intended, should be an easy task, but i haven't found an easy solution.

i want mappoint to calculate the distance between 1 point and 600 other points each and i need this exported to excel. in the end i would neet something like:

Start - Locations - Distance
Home - Location 1 - Distance 5 km
Home - Location 2 - Distance 12 km
Home - Location 3 - Distance 7 km

Is there any easy solution, so that i won't have to select each Location individualy?

Im not into VBA and macrros, so i hope there is an easy way to do this whoich i just haven't found out about yet.

Thanks in advance,


Eric Frost
09-05-2011, 04:15 PM
Welcome to the site! Your English is fine, what is your 1st language?

At first I was going to say to do a custom macro or have someone to do a little custom macro for you, it's really not hard, I think the first thing I wrote like this for someone was almost 10 years ago and have done many since. :-)

But there are also some inexpensive commercial tools for doing this, MPMileCharter and IC-DistanceAnalysis or something like that, Google it, I think they both have free trials.


PROFIT100 Consulting
09-06-2011, 09:29 AM
http://www.mapforums.com/images/icons/icon7.gif Itīs quite easy!

Just download our MapPoint IC-GeoAnalysisSuite. (http://profit100.eu/download/ic-business-tools.html)
Itīs a 30 day free trial.

1. Step: Geocode your points with the tool IC-DatasetExport (http://wh-en.mappoint-tools.info/GA/index.htm#page=html/DatasetExport/IC-DatasetExport.htm)
2. Step: Use IC-DistanceAnalysis (http://wh-en.mappoint-tools.info/GA/index.htm#page=html/DistanceAnalysis/IC-DistanceAnalysis.htm)for Calcultion

Thatīs all.
Good Luck.