Welcome to MapForums!

When you are signed in, this message, the ads in this row, and the red-underlined link ads all go away.

## Multiple Start Points and One Destination

This is a discussion on Multiple Start Points and One Destination within the MapPoint Desktop Discussion forums, part of the Map Forums category; Hi Is there anyway of calculating the distance between a number of different start points (not stops) and one common ...

1. Junior Member White Belt
Join Date
Mar 2011
Posts
2

## Multiple Start Points and One Destination

Hi

Is there anyway of calculating the distance between a number of different start points (not stops) and one common destination. The start points will be inputted into MapPoint using post codes on an Excel worksheet. Ideally, the distance data should be reexported to the same Excel worksheet.

Thanks in anticipation.

2. ## Re: Multiple Start Points and One Destination

This will do many-to-one calculations like you are describing.
Import your start locations as as pushpin set. Create a second pushpin set with your destination location. Start MileCharter, select these and press "Start". Output is to a new Excel worksheet.

Milecharter can also do many-to-many calculations (eg. all combinations from all customers to all sales offices), and perform complex searches such as "report the 3 closest sales offices with 10 miles driving distance of each of my customers".

Richard

3. Junior Member White Belt
Join Date
Mar 2011
Posts
2

## Re: Multiple Start Points and One Destination

Thanks for that. So it definitely requires an add on then!

4. ## Re: Multiple Start Points and One Destination

To automate it, yes.
You could always do each calculation by hand...

Richard

5. Junior Member White Belt
Join Date
Sep 2010
Posts
6

## Re: Multiple Start Points and One Destination

If you would like to do this entirely within Excel, our software CDXZipStream is an Excel add-in that works with MapPoint running in the background - just enter the start and end points in a worksheet and specify the data you need returned (to the same worksheet) such as driving distance, time, cost, etc. Here's a short YouTube video showing how it works.

Regards,
BJ Hughes
CDX Technologies