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, 14:07 -0800

    Dave, the attachment is relevant for the 180E/W issue.    Peter Hakel

    Thank you Peter.  My early morning dozing didn’t include MOD only nested IF s.  See below.  Actually, my dozing came up with sequential IF s, but there turned out to be no such thing.  I had to Google ‘More than one IF in Excel’ to get the correct syntax.  The complete spreadsheet just needs tidying up now.  Wrt MOD, I can’t see how -180/360 gives a remainder of 179.  
    Nevertheless, isn’t digital wonderful.  The analogue GPI 6 in the Vulcan was very accurate but incredibly slow to reset.  On the rare occasions when the guys had to cross 180W, they carried a second GPI 6 set up in workshops to 180E.  They quickly unscrewed the one that had got up to 180W and screwed in the one set to 180E, what you might call an analogue solution. DaveP



    File:
    180E-WSolution.xls

       
    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