Welcome to the NavList Message Boards.


A Community Devoted to the Preservation and Practice of Celestial Navigation and Other Methods of Traditional Wayfinding

Compose Your Message

Add Images & Files
    Re: Calculate new coordinates given bearing and distance?
    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

    Browse Files

    Drop Files


    What is NavList?

    Join NavList

    (please, no nicknames or handles)
    Do you want to receive all group messages by email?
    Yes No

    You can also join by posting. Your first on-topic post automatically makes you a member.

    Posting Code

    Enter the email address associated with your NavList messages. Your posting code will be emailed to you immediately.

    Email Settings

    Posting Code:

    Custom Index

    Start date: (yyyymm dd)
    End date: (yyyymm dd)

    Visit this site
    Visit this site
    Visit this site
    Visit this site
    Visit this site
    Visit this site