Thread: Multi-radius
View Single Post

  #2 (permalink)  
Old 02-26-2003
mark.sechrist mark.sechrist is offline
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.
Reply With Quote