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 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



    File:
    Daves-Modified-Short-Distanc.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