# 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.  Register To Reply

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.  Register To Reply

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.  Register To Reply

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?  Register To Reply

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.  Register To Reply

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.  Register To Reply

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.  Register To Reply

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.  Register To Reply