Calculate distance and bearing, given latitude and longitude of points

[scambigol]

Any idea how to do this? You have LAT1, LON1, LAT2, LON2 and you want to calculate:

A: distance
B: bearing (initial bearing along a great circle ie the shortest distance)
C: bearing along rhumb lines ("constant bearing")

For example if you want to go from 0, 0 to 0, 90E, the answer to C would be 'east' but not to B as that's not the shortest path

Thanks in advance,
Scambigol

 

[AhoyNC]

The attached links should give you the formulas you need. Remember to change degrees to radians in the Excel formulas.

Calculate distance and bearing between two Latitude/Longitude points using haversine formula in JavaScript
Longitude and latitude calculator
How to Calculate Distance and Bearing to a Latitude Longitude Waypoint in Excel | Deathpod 3000 by Team Mookemobile

 

[scambigol]

Hello, thank you very much for the links!
The third one has a link for downloading an excel file with the formulas so that was very helpful.
The only problem left is 'RHUMB LINE BEARING' which is not covered in the third link. It is covered in the first link (which I had already found myself actually) but I was having trouble converting the explanation on that link to an excel formulas.
Any tips on that?
Thanks

Scambigol

The attached links should give you the formulas you need. Remember to change degrees to radians in the Excel formulas.

Calculate distance and bearing between two Latitude/Longitude points using haversine formula in JavaScript
Longitude and latitude calculator
How to Calculate Distance and Bearing to a Latitude Longitude Waypoint in Excel | Deathpod 3000 by Team Mookemobile

 

[Shri4u]

Hi Scambigol,

it is an old thread, but looks like there has been no reply to your last. Have you been able to find an excel formula to determine constant bearing along rhumb lines. All the ones I have come across gives the initial bearing which is quite off to a constant bearing.

Regards
Shri

 

[scambigol]

Hi Shri4u,
yes I did find one for constant bearing... but I do not remember where I found it as it was maybe more than a year ago.
Thanks,

Scambigol

Hi Scambigol,

it is an old thread, but looks like there has been no reply to your last. Have you been able to find an excel formula to determine constant bearing along rhumb lines. All the ones I have come across gives the initial bearing which is quite off to a constant bearing.

Regards
Shri