NavList:
A Community Devoted to the Preservation and Practice of Celestial Navigation and Other Methods of Traditional Wayfinding
Re: Calculate new coordinates given bearing and distance?
From: David Pike
Date: 2015 Nov 26, 13:03 -0800
From: David Pike
Date: 2015 Nov 26, 13:03 -0800
I said I wasn’t going to try putting my short distance waypoint calculation into Excel, but I couldn’t resist it. I’ve got it working below in decimals of degrees apart from crossing 180E/W. However, I’ve failed in turning this back into degrees and minutes because INT always makes negative numbers more negative. E.g. 3.5 degrees west or south, i.e. -3.5 degrees, comes up as -4 degrees + 30’. Can anyone make lines 18 and 33 more useable? DaveP
I should have tried harder first time. The solution is =IF(B18<0,(B18+1),(B18)). See below. DaveP
