Welcome to MapForums!

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

This is a discussion on Multi-radius within the MapPoint Desktop Discussion forums, part of the Map Forums category; i just posted this msg in wish list i presume it isnt possible - if it is i will be ...

1. Senior Member Black Belt
Join Date
Jul 2002
Posts
5,137

i just posted this msg in wish list i presume it isnt possible - if it is i will be very happy man :-)

"In my job i have to find out who falls in any of 12 25km radiuses in the UK. To do this i either have to delete all pins outside the radiuses and then export all, or export each radius then add them together and remove any duplications (some radiuses overlapp... so some may be on twice)

It would be brill to be able to select, then export multiple radiuses at once... then there would be no overlapp. How about then being able to export all the pins, not under those radiuses... that would be great."

Regards

Dan

2. Junior Member White Belt
Join Date
Oct 2002
Posts
8
I deal with your exact problem. Here is how I deal with it.

1) I use the drawing tools to draw a circle around the pushpin which I wish to use as the center point. I typically look at a 20 mile radius.

2) I export all the enclosed pushpins with Pushpin Tool (trial version available on this site).

3) I then use a formula I found at the following address to compute distance between the center pushpin and the object pushpin (http://www.cpearson.com/excel/latlong.htm)

4) I then use a nested IF/THEN function in Excel to break the distances into 5 mile radius increments.

5) Finally, I sort and do a subtotal on the IF/THEN function that defines the 5 mile radius increments.

Hope this helps.

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•