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 27, 00:01 -0800
From: David Pike
Date: 2015 Nov 27, 00:01 -0800
Dave, I have been using the TRUNC() function for this purpose - see the cyan-colored rows 8 and 10 in the attached spreadsheet. Peter Hakel
Wow! Thanks Peter. That’s a bit out of my league; it’s over 30 years since I dabbled in anything like this. My next task will be to make it 180E/W proof, then friendlier and fewer lines. In the night, I dreamt of stacked IF boxes, but TIKI 219 must get priority today. We’re lifting her out at crack of sparrows on Monday; she’s not ready yet, and I’m away this weekend. DaveP
