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: Applications of Complex Analysis to Celestial Navigation
    From: Robin Stuart
    Date: 2009 Nov 28, 13:51 -0800

    I have put together an Excel spreadsheet that demonstrates the use of complex 
    numbers in calculations performed in celestial navigation. The examples are 
    taken from the paper Applications of Complex Analysis to Celestial 
    Navigation, available at http://www.fer3.com/arc/img/110015.articlec.pdf.
    Each sheet consists of three sections; Inputs, Calculations, Results. The 
    values of the Inputs are initially set to those that appear in the paper, 
    above, and confirm the results that appearing therein. The inputs may be 
    changed to perform the same calculations for other sets of observations.
    The spreadsheet uses the Excel Engineering functions IMSUM(), IMPRODUCT() etc. 
    to the perform the complex number calculations. To ensure that these are 
    available to the system, on the Excel toolbar select Tools>Addins and check 
    "Analysis ToolPak".
    The Excel implementation using functions IMSUM(), IMPRODUCT() etc. to perform 
    arithmetic operations on complex numbers means that formulas that appear here 
    are less compact and transparent than they are in computer languages, such as 
    FORTRAN, C++, PERL, in which complex numbers are a built in native data type.
    Robin Stuart
    NavList message boards: www.fer3.com/arc
    Or post by email to: NavList@fer3.com
    To unsubscribe, email NavList+unsubscribe@fer3.com

    File: 110839.complexcelnavdemo.xls
    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