Calculating new coordinates based on bearing and distance of current position...

Formulas, Functions, Formatting, Charts, Data Analysis, etc.
Forum rules
Forum Rules Please read the forum rules before posting!

Put CODE tags around your macro/vba code in a post. Easy way to do this: select the macro/vba in your post and click the CODE button above where you input the text.

Calculating new coordinates based on bearing and distance of current position...

Postby Sigmatic » Sun Apr 22, 2012 4:33 am

Hello all,

I hope there is someone out there that can help me with the following problem...

Here is what I have:
.... the latitude and longitude for a given position "A" on earth.

Here is what I need:
.... the formula that will give me the latitude and longitude for a new position "B" that is located on a given bearing and distance from position "A".

Example:
.... position "A" is located at N10 40.5 - E120 20.0. Position "B" is located on a bearing of 060 degrees and a distance of 20 nautical miles from position "A". What would be the coordinates for position "B"?

Thank you so much for your time ...
  • 0

Sigmatic
 
Posts: 4
Joined: Apr 22, 2012
Reputation: 0
Excel Version: 2007

Re: Calculating new coordinates based on bearing and distance of current position...

Postby Sisyphus » Sun Apr 22, 2012 9:33 pm

Hi,
I'm afraid I haven't ever done this kind of calculations. The best I can do for you is to guide you to the sources where I would start getting guidance on how to do it. Perhaps these sources can help you, too:
http://www.cpearson.com/excel/LatLong.aspx

http://www.contextures.com/excellatitudelongitude.html
  • 0

Have a great day! :D

Sisyphus
Do what you can, with what you have, where you are. (FDR)
Sisyphus
Former Moderator
 
Posts: 4436
Joined: Dec 7, 2011
Location: Shanghai
Reputation: 198
Excel Version: 2010

Re: Calculating new coordinates based on bearing and distance of current position...

Postby Sigmatic » Tue May 08, 2012 7:04 pm

Thank you Sisyphus for your input and links. All though interesting, those site do not specifically address the problem as such.

In the mean time however I have done some more research and eventually did find a website that answers the question. I've tried the formulas and indeed come up with the correct answer when calculating the lat/lon for the new posiion based on a distance and bearing from a starting point.

Here's the link for those who were looking for the same:
http://stackoverflow.com/questions/7222382/get-lat-long-given-current-point-distance-and-bearing

Regards,
  • 0

Sigmatic
 
Posts: 4
Joined: Apr 22, 2012
Reputation: 0
Excel Version: 2007

Re: Calculating new coordinates based on bearing and distance of current position...

Postby Sisyphus » Tue May 08, 2012 10:44 pm

Hello sigmatic.
I'm glad you solved your problem. Thank you for sharing your knowledge.
  • 0

Have a great day! :D

Sisyphus
Do what you can, with what you have, where you are. (FDR)
Sisyphus
Former Moderator
 
Posts: 4436
Joined: Dec 7, 2011
Location: Shanghai
Reputation: 198
Excel Version: 2010


Return to General Excel Questions

Who is online

Users browsing this forum: Bing [Bot], Google [Bot] and 3 guests

cron