This content has been marked as final.
Show 2 replies

1. Re: Calculating the endtoend distance between several points across several groups
Joshua Milligan May 28, 2013 10:54 AM (in response to Christine Holloway)Christine,
There is a blog post here that describes how to calculate distances without joining the data set to itself: http://vizpainter.com/mappingdistancesanalternativeapproach/
I built upon the concept described there to calculate a running total of distance. The workbook is attached. The whole thing is rather complex, using table calculations  but I'd be happy to walk through any questions you might have.
Regards,
Joshua

Map Distance.twbx.zip 134.7 KB


2. Re: Calculating the endtoend distance between several points across several groups
Allan Walker May 28, 2013 12:53 PM (in response to Christine Holloway)Christine,
The following formula is 98% accurate using Great Circles.
=ACOS(COS(RADIANS(90Lat1)) *COS(RADIANS(90Lat2)) +SIN(RADIANS(90Lat1)) *SIN(RADIANS(90Lat2)) *COS(RADIANS(Long1Long2))) *6371