With your coordinates in radians you can use a trigonometric formula to calculate distance along the surface of a sphere. Chris Venesss page also contains an Excel formula of the Haversine equation actually using the spherical law of cosines for distances between points in kilometres. For the euclidean distance between two points in one dimension the formula should look like this please let me know if I misunderstood your data though.
There are many such formulas that could be used.
I would like to create an Excel spreadsheet with the appropriate formulae to compute the distances between different points in three-dimensional coordinates X Y and Z. Cos Lon_place_2PI 180-Lon_place_1PI 180 34438985. Chris Venesss page also contains an Excel formula of the Haversine equation actually using the spherical law of cosines for distances between points in kilometres. The following formula will suffice for our purposes.
