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: Navigation spreadsheet lessons
    From: Andrés Ruiz
    Date: 2009 Jan 16, 14:32 +0100

    Other solution to the problem in [NavList 7082] with excel, (maybe with open office. Google docs?), is to define a user function.

    With a little experience is a very clear way to do calculations, and you can built your own library of navigational functions

    1. insert a module

    [Tools] [Macro] [Visual Basic Editor]

     

    2. Write the function

     

    3. Use it like other excel functions

    [Insert] [Function]

     

    4. See the results in Dip.xls

     

     

    Another example is in the e-mail [NavList 5487] Re: Nautical Almanac Sight Reduction method, it has an excel spreadsheet that calculates the altitude and the azimuth.

     

    Andrés Ruiz

    Navigational Algorithms

    http://www.geocities.com/andresruizgonzalez

     

     


    --~--~---------~--~----~------------~-------~--~----~
    Navigation List archive: www.fer3.com/arc
    To post, email NavList@fer3.com
    To unsubscribe, email NavList-unsubscribe@fer3.com
    -~----------~----~----~----~------~----~------~--~---

    File:


    File:


    File:


    File: 107083.dip.zip
       
    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