Project description:

JerseySTEM needs to calculate distances between 2 points on a map identified by Latitude and longitude

Input:

Table FROM: CodeFrom, LatitudeFrom, LongitueFron ( x rows)

Table TO: CodeTo,LatitudeTo,LongitudeTo (y rows)

Output:

Table Distance:CodeFrom.CodeTo,Distance (x*y rows )

Formula:

=ACOS(SIN(latfrom)*SIN(latto) + COS(latfrom)*COS(latto)*COS(lonto-lonfrom) ) * 6371000

Preferably an Excel MAcro