Welcome to the NavList Message Boards.

NavList:

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

Compose Your Message

Message:αβγ
Message:abc
Add Images & Files
    or...
       
    Reply
    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

       
    Reply
    Browse Files

    Drop Files

    NavList

    What is NavList?

    Join NavList

    Name:
    (please, no nicknames or handles)
    Email:
    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:

    Email Settings

    Posting Code:

    Custom Index

    Subject:
    Author:
    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