Comments on: How to Calculate Distance and Bearing to a Latitude Longitude Waypoint in Excel http://blog.deathpod3000.com/?p=192 Documenting the construction and programming of an autonomous r/c car Sat, 22 Aug 2009 12:15:47 -0700 http://wordpress.org/?v=2.8.1 hourly 1 By: Carl http://blog.deathpod3000.com/?p=192&cpage=1#comment-526 Carl Tue, 04 Aug 2009 02:21:01 +0000 http://deathpod3000.wordpress.com/?p=192#comment-526 Thanks for the excel formula download. I was looking for a formula to input 2 gps coordinates and convert that to a bearing degrees. Your spreadsheet saved me a ton of time trying to figure that out!! Thanks for the excel formula download. I was looking for a formula to input 2 gps coordinates and convert that to a bearing degrees. Your spreadsheet saved me a ton of time trying to figure that out!!

]]> By: Kelly Brown http://blog.deathpod3000.com/?p=192&cpage=1#comment-63 Kelly Brown Fri, 12 Jun 2009 23:19:55 +0000 http://deathpod3000.wordpress.com/?p=192#comment-63 The best information i have found exactly here. Keep going Thank you The best information i have found exactly here. Keep going Thank you

]]> By: pushkar http://blog.deathpod3000.com/?p=192&cpage=1#comment-54 pushkar Sat, 06 Jun 2009 10:53:20 +0000 http://deathpod3000.wordpress.com/?p=192#comment-54 hi, its very useful,infact i have been using it already. but i m more interested in getting lat2 & lon2 as output when giving lat1,lon2,bearing from 1 to 2 & distance as inputs. Can you revise the above formulae to get that. Pushkar hi,
its very useful,infact i have been using it already.
but i m more interested in getting lat2 & lon2 as output when giving
lat1,lon2,bearing from 1 to 2 & distance as inputs.
Can you revise the above formulae to get that.

Pushkar

]]> By: aliasmrjones http://blog.deathpod3000.com/?p=192&cpage=1#comment-45 aliasmrjones Sun, 17 May 2009 21:16:24 +0000 http://deathpod3000.wordpress.com/?p=192#comment-45 Good catch! You are correct, it should read =MOD(ATAN2((COS(lat1)*SIN(lat2))-(SIN(lat1)*COS(lat2)*COS(lon2-lon1)), SIN(lon2-lon1)*COS(lat2)),2*PI(). I edited the post to correct the formula. The formula in the spreadsheet you can download on this page was correct. Eric Good catch! You are correct, it should read =MOD(ATAN2((COS(lat1)*SIN(lat2))-(SIN(lat1)*COS(lat2)*COS(lon2-lon1)), SIN(lon2-lon1)*COS(lat2)),2*PI(). I edited the post to correct the formula. The formula in the spreadsheet you can download on this page was correct.

Eric

]]> By: debbie russell http://blog.deathpod3000.com/?p=192&cpage=1#comment-44 debbie russell Sun, 17 May 2009 20:39:36 +0000 http://deathpod3000.wordpress.com/?p=192#comment-44 you give the function in excel for calculating a bearing as =MOD(ATAN2((COS(lat1)*SIN(lat2))-(SIN(lat1)*COS(lat1)*COS(lon2-lon1)), SIN(lon2-lon1)*COS(lat2)),2*PI()) Whereas other places give it as =MOD(ATAN2((COS(lat1)*SIN(lat2))-(SIN(lat1)*COS(lat2)*COS(lon2-lon1)), SIN(lon2-lon1)*COS(lat2)),2*PI() Ie. a cos(lat2) where you have given cos(lat1). Could you possibly confirm your version is correct as at the moment I don't know what to use. Thank you so much This page had been very useful to me Best wishes Debbie Russell University of St Andrews UK you give the function in excel for calculating a bearing as

=MOD(ATAN2((COS(lat1)*SIN(lat2))-(SIN(lat1)*COS(lat1)*COS(lon2-lon1)), SIN(lon2-lon1)*COS(lat2)),2*PI())

Whereas other places give it as

=MOD(ATAN2((COS(lat1)*SIN(lat2))-(SIN(lat1)*COS(lat2)*COS(lon2-lon1)), SIN(lon2-lon1)*COS(lat2)),2*PI()

Ie. a cos(lat2) where you have given cos(lat1). Could you possibly confirm your version is correct as at the moment I don’t know what to use.

Thank you so much
This page had been very useful to me
Best wishes

Debbie Russell
University of St Andrews
UK

]]>