Calculating Distance to Devices in Excel

Nov 15, 2023 | Tech

Here is the Excel based Distance Calculation for selecting devices within a range on a central location.

=ACOS(SIN(RADIANS($C$2))*SIN(RADIANS(C4))+COS(RADIANS($C$2))*COS(RADIANS(C4))*COS(RADIANS(D4)-RADIANS($D$2)))*6371

Excel Formula Notes:

  • $C$2 is Central Latitude
  • C4 is Device Latitude (relative to row)
  • $D$2 is Central Longitude
  • D4 is Device Longitude (relative to row)