Calculate distance and bearing, given latitude and longitude of points

scambigol

Board Regular
Joined
Feb 20, 2003
Messages
77
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
 

Excel Facts

When they said...
When they said you are going to "Excel at life", they meant you "will be doing Excel your whole life".
Upvote 0
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

 
Upvote 0
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
 
Upvote 0
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
 
Upvote 0

Forum statistics

Threads
1,223,098
Messages
6,170,099
Members
452,301
Latest member
QualityAssurance

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top