# How to find the coordinates at a given distance and bearing

1. ## How to find the coordinates at a given distance and bearing

Need an Excel formula to get new coordinate at a given distance and bearing/heading.
example:
Lat/Lon : -6.24525785446167, 106.627548217773
Distance : 300m
Bearing : 90 degree
New Lat/Lon : ?

I've found the coordinate calculator and apps toll, but I've a lot of data to work with.

2. ## Re: How to find the coordinates at a given distance and bearing

``Please Login or Register  to view this content.``
From Movable Type Scripts: Calculate distance, bearing and more between Latitude/Longitude points.

3. ## Re: How to find the coordinates at a given distance and bearing

ben_hensel, could you please indicate what values you refer to by your variables?

Correct me if I'm wrong, given OmJose's example, three of the four variables would be:
lat1=-6.24525785446167
lon1=106.627548217773
d=300

What does variable R refer to?

Originally Posted by ben_hensel
``Please Login or Register  to view this content.``
EDIT: figured it out
lat1=-6.24525785446167
lon1=106.627548217773
d=300 meters
R= radial distance of the Earth, 6371.1 meters

Also, all values in degrees (lat1, lon1, bearing, lat2) are to be converted to radians for input, and then the output is converted back to degrees

Thanks for the help.

4. ## Re: How to find the coordinates at a given distance and bearing

Do you have to include the negative value for south or west in the calculations?

5. ## Re: How to find the coordinates at a given distance and bearing

I believe you do, though I don't know if it can account for values crossing across positive/negative (East/West or North/South) thresholds.

6. ## Re: How to find the coordinates at a given distance and bearing

OK. It also looks like the distance needs to be in km not meters.

7. ## Re: How to find the coordinates at a given distance and bearing

Correct, as long as long as R is also in KM.
I ended up using meters instead of kilometers so my R was set to 6371100.

8. ## Re: How to find the coordinates at a given distance and bearing

ben_hensel, could you please indicate what values you refer to by your variables?

Correct me if I'm wrong, given OmJose's example, three of the four variables would be:
lat1=-6.24525785446167
lon1=106.627548217773
d=300

What does variable R refer to?

Quote Originally Posted by ben_hensel View Post
[Select Code] copy to clipboard

lat2: =ASIN(SIN(lat1)*COS(d/R) + COS(lat1)*SIN(d/R)*COS(brng))
lon2: =lon1 + ATAN2(COS(d/R)-SIN(lat1)*SIN(lat2), SIN(brng)*SIN(d/R)*COS(lat1))

EDIT: figured it out
lat1=-6.24525785446167
lon1=106.627548217773
d=300 meters
R= radial distance of the Earth, 6371.1 kilometers

Also, all values in degrees (lat1, lon1, bearing, lat2) are to be converted to radians for input, and then the output is converted back to degrees

Thanks for the help.

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