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.

Please Login or Register  to view this content.

From Movable Type Scripts: Calculate distance, bearing and more between Latitude/Longitude points.

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

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.

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

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.

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.