Calculate distance and bearing between two positions

[Lserpa]

Hello all,

I am looking for an easy, offline way of calculating the distance and bearing between two points. I found one in the net but it is a little too math to me.

Does anyone know of a simple, downloadable formula, preferably in Excel?

Thanks in advance

Luis Serpa

[pete33458]

The way that your question is written, I don't think you will get many answers.

The simplest way is with a chart, dividers, parallel ruler, and the compass rose.

If you are saying you know your own location and the distance to two points, but not their distance from each other, then you can use any online triangle calculator to get the distance between those two points, as well as the angle of any of the corners of the triangle, from which, if you know the bearing of one of the points from you, you can calculate the bearing from one of the points to the next.

As I said, it is really not clear enough what you are trying to do.

Pete

[pierrrre]

What about this

Calculate distance and bearing between two Latitude/Longitude points using haversine formula in JavaScript

[barnakiel]

Enter both WPTs into a handheld and read the bearing and distance.

Or use cosine from lat long difference allowing for lat adjusted length of one degree of lat long.

Or use haversine formula for longer distances over the ortho.

There are many ways so it depends on what you want to do and how big the distances are.

b.

[hellosailor]

Unless you are on a powerbeat or running dead downwind, remember that you may be tacking and that can add 40% to the distance you'll actually have to be traveling.

[psneeld]

Starpath had a wind calculator you can download....I use it for all sorts of things.

Just plug in a number or two and it gives you all the parts of a triangle.

Didn't see it when I just looked it up at Starpath navigation...but maybe it was for Windows not android and I don't have my other computer right now.

[biku navigator]

Hello i want formula for calculate bearing and distance between longitude and latitude in excel thanks

[Shrew]

A chart and basic navigation tools would do this significantly easier.

[StuM]

Originally Posted by biku navigator

Hello i want formula for calculate bearing and distance between longitude and latitude in excel thanks

VBA written in MS Access, but should work in Excel as well.


Inputs and Output in Radians:
Conversion from/to Degrees/NM is left as an exercise for the reader



Distance"

Distance = 2 * arcsin(Sqr((Sin((lat1 - lat2) / 2)) ^ 2 + Cos(lat1) * Cos(lat2) * (Sin((lon1 - lon2) / 2)) ^ 2))

Bearing:

If (Cos(lat1) < 0.0000001) Then ' a small number ~ machine precision
  If (lat1 > 0) Then
     Bearing = 3.14159265358979    '  starting from N pole
  Else
     Bearing = 0        '  starting from S pole
  End If
 Exit Function
End If
If Sin(lon2 - lon1) < 0 Then
   Bearing = acos((Sin(lat2) - Sin(lat1) * Cos(Distance)) / (Sin(Distance) * Cos(lat1)))
Else
   Bearing = 2 * 3.14159265358979 - acos((Sin(lat2) - Sin(lat1) * Cos(Distance)) / (Sin(Distance) * Cos(lat1)))
End If