Monthly Archives: November 2014

Calculating distance between two lat/lon positions (in Excel)

=ACOS(COS(RADIANS(90-Lat1)) *COS(RADIANS(90-Lat2)) +SIN(RADIANS(90-Lat1)) *SIN(RADIANS(90-Lat2)) *COS(RADIANS(Long1-Long2))) *6371

and for Big Data Wall Fillers CSV file use

=ACOS(COS(RADIANS(90-C2)) *COS(RADIANS(90-H2)) +SIN(RADIANS(90-C2)) *SIN(RADIANS(90-H2)) *COS(RADIANS(D2-I2))) *6371

thanks to BlueMM