# Calculating constant bearing with ATAN2 function

1. ## Calculating constant bearing with ATAN2 function

Hi,

I am trying to calculate the geographical direction one needs to take to get from one point (Lat1/Lon1) to another (Lat/Lon2). Mathematical instructions are given at http://www.movable-type.co.uk/scripts/latlong.html.

For my purposes I would like to use the 'constant bearing' or 'rhumb line method' rather than the initial/final bearing method.

I have tried to construct the formulae as needed in Excel, along with the formulae for initial/final bearing and their average (row 27) for control purposes. One would expect that the constant bearing is always between the initial and final bearing and actually more or less close to their average.

In my speadsheet this works pretty well as long as the starting point has LAT1=0 (columns E, F and G). The further LAT1 deviates from 0 the worse the result. Why? I presume this has to do with the way Excel calculates ATAN2. Note that the difference between constant bearing and average bearing increases with increasing \$dPHI. I have maximised \$dPHI in cell H19, any further increase results in a NUM error.

I considered this in my row 26, but it does not resolve the issue.

Can you provide a solution? Thanks so much!

2. ## Re: Calculating constant bearing with ATAN2 function

This is what I use:
``Please Login or Register  to view this content.``
For example,
``Please Login or Register  to view this content.``
EDIT: Rereading your post, this gives departure and return headings for great circle routes, not a rhumb line -- I don't have that.

3. ## Re: Calculating constant bearing with ATAN2 function

Thanks, anyway. I hope somebody will come up with a solution.

##### Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1