The Haversine Formula calculates the distance between two points on a sphere, considering the curvature. It is an accurate method for calculating the distance between two sets of coordinates, taking Earth’s curvature into account. [1][2]

S = Distance between two addresses

r = Radius of Earth

\varphi1 = Latitude of the first place

φ2 = Latitude of the second place

ℽ1 = Longitude of the first place

ℽ2 = Latitude of the second place

S = 2r\sin^{-1}\sqrt { \sin^2 \left( \frac{ \varphi2 - \varphi1 }{2}\right)+\cos\varphi_1 \cos\varphi_2 \sin^2 \left( \frac{\lambda_2 - \lambda_1}{2} \right) }

See the formula in use:


References:

  1. vCalc.com (No date). Haversine – Distance. Available at: https://www.vcalc.com/wiki/vCalc/Haversine%20-%20Distance (Accessed: 7 July 2024).
  2. Nahian, M. A. (2024) How to Calculate Distance Between Two Addresses in Excel (3 Ways)ExcelDemy. Available at: https://www.exceldemy.com/calculate-distance-between-two-addresses-in-excel/ (Accessed: 7 July 2024).

By MisterFoxOnline

Mister Fox AKA @MisterFoxOnline is an ICT, IT and CAT Teacher who has just finished training as a Young Engineers instructor. He has a passion for technology and loves to find solutions to problems using the skills he has learned in the course of his IT career.

Leave a Reply

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