Excel.Tips.Net: Calculating the Distance between Points

By Allen Wyatt for Excel.Tips.Net

Mike keeps track of a series of latitude and longitude values in an Excel worksheet. As these are essentially points on a grid, Mike would like to calculate the distance between any two given latitude/longitude pairs.

If the latitude and longitude pairs were really just points on a grid, then calculating the distance between them would be easy. The problem is that they are really points on a sphere, which means that you can’t use flat-grid calculations to determine distance. In addition, there are many ways that you can calculate distances: shortest surface distance, optimum flight path (“as the crow flies”), distance through the earth, driving distance, etc.

Obviously this could be a complicated question. In the space available, I’ll examine a couple of ways to determine the great circle distance (“as the crow flies”), and then provide some references for additional information on the other types of calculations.

Article Continued Here

This post is excerpted with permission from Excel.Tips.Net

Subscribe to the Free ExcelTips Newsletter with the links below

(for those using Excel 97 through 2003)

(for those using Excel 2007 through 2010)

116 total views, 1 views today

(Visited 14 times, 1 visits today)

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.