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
    Name or NavList Code:
    Email:
       
    Reply
    Re: Excel Almanac
    From: Bill Ritchie
    Date: 2021 Jan 7, 11:32 +0000
    Hello Sean,

    Since HermanD's  Jan 6, 2021, 4:02 PM  post, I suspect that you have fixed the problem! For Sun, Moon and a few random stars at 2021:1:1 at 00:00:00 all stated values agree with Astron exactly and only minor differences for planets.

    I did notice that small discrepancies appear progressively with past dates for the Moon. (0.4' difference in GHA on 1901:1:1: 00:00:00 from Astron and Frank's Nautical Almanac Data).
    Even more trivial, you state a start date of 1900:1:1 00:00:00. In fact it gives errors before the 19 hours 12 minutes of that millennium!

    Your earlier post of Jul 28, 2020, 5:16 AM states "There are no macros in the workbook - only tables." My official version of Excel flags up 24 of them!

    As the latest UK Covid lockdown bites, I'll make more detailed comments to you directly via the link given in your instructions tab. Hope this helps. 

    Regards,

    Bill Ritchie

     



    On Wed, Jan 6, 2021 at 4:02 PM Herman Dekker <NoReply_Dekker@navlist.net> wrote:


    Hello Sean,
    I changed only the UT to 00:00:00 (on 1 jan 2021) the calculated Sun GHA is 179°06,9' that's not the same as I get from other sorces.
    On average (10 sources) it is 179°08,5' so what is, or do I wrong?
    I tested this because by conincidence a few days ago  I was on the webstite of Johannes Hornbach. TheNauticalAlmanac.com
    He has a nice collection off Celestial tables etc. and a Forum that nobody seems to use.
    His complete nautical Almanac for 2021 has as GHA value 179° 08,2' I attended him on this (also) wrong value.
    He thought it is the PYEem program that generates the wrong value.
    His only Sun Almanac give the most common 179°08,5' value. Generated with one other program.
    So Sean can you check your GHA value, or inform me how to use the program.

    Kind regards
    HermanD

       
    Reply
    Browse Files

    Drop Files

    NavList

    What is NavList?

    NavList is a community devoted to the preservation and practice of celestial navigation and other methods of traditional position-finding. We're a group of navigators, navigation enthusiasts and hobbyists, mathematicians and physicists, and historians interested in all aspects of navigation but primarily those techniques which are non-electronic.

    To post a message, if you are already signed up as a NavList member, start a new discussion or reply to any posted message and use your posting code (this is a simple low-security password assigned when you join). You may also join by posting. Your first on-topic messsage automatically makes you a member, and a posting code will be assigned and emailed to you for future posts.

    Uniquely, the NavList message boards also permit full interaction entirely by email. You can optionally receive individual posts or daily digests by email, and any member can post messages by email (bypassing the web site) by sending to our posting address which is "NavList@NavList.net". This functionality is similar to a traditional Internet mailing list: post by email, read by email, reply by email. Most members will prefer the web interface here for posting and replying to messages.

    NavList is more than an online community... more about that another day.

    © Copyright notice: please note that the rights to all messages and posts in this discussion group are held by their respective authors. No messages or text or images extracted from messages may be reproduced without the explicit consent of the message author. Email me, Frank Reed, if you have any questions.

    Join / Get NavList ID Code

    Name:
    (please, no nicknames or handles)
    Email:
    Do you want to receive all group messages by email?
    Yes No

    A NavList ID Code guarantees your identity in NavList posts and allows faster posting of messages.

    Retrieve a NavList ID Code

    Enter the email address associated with your NavList messages. Your NavList code will be emailed to you immediately.
    Email:

    Email Settings

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