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)