Cruisers Forum
 


Reply
  This discussion is proudly sponsored by:
Please support our sponsors and let them know you heard about their products on Cruisers Forums. Advertise Here
 
Thread Tools Search this Thread Rate Thread Display Modes
Old 19-05-2021, 06:07   #61
Registered User
 
GrowleyMonster's Avatar

Join Date: Dec 2012
Location: New Orleans
Boat: Bruce Roberts 44 Ofshore
Posts: 2,908
Re: Almanac and Celestial Navigation Calculator

Thanks for posting this sad news and putting a face on a company that I have done business with on several occasions. Hopefully the company has enough momentum to keep providing the same level of service and same varied and high quality product line that this strange, landlocked ocean navigation supply company has become known for in the past several decades.
__________________
GrowleyMonster
1979 Bruce Roberts Offshore 44, BRUTE FORCE
GrowleyMonster is offline   Reply With Quote
Old 31-10-2021, 18:59   #62
Registered User
 
SeanPatrick's Avatar

Join Date: Dec 2012
Location: Norfolk, VA USA
Posts: 673
Lightbulb Re: Almanac and Celestial Navigation Calculator

New version available at my website.


v 0.3.1 - 2021, Oct 31

  • Added rise, set, transit and twilight calculator.
  • Increased precision of azimuths on the printable list to 0.1.
  • Added button to Data Series calculator to get the date and time from the Almanac.
  • Added ecliptic longitude of Sun, Moon and planets to the Data Series calculator to facilitate determination of the times of equinoxes, conjunctions, etc.
  • Corrected a minor error in the calculation of Ha of the LL of the Moon and Sun at extremely low altitudes.
  • Added PA correction to the Sun.
  • Updated delta-T table.
  • Extended visibility chart to -5.
  • Minor formatting changes.
__________________
If you have any questions about celestial navigation, ask me!
Celestial Navigation Spreadsheet
NavList Celestial Navigation Forum
SeanPatrick is offline   Reply With Quote
Old 31-10-2021, 19:28   #63
Registered User

Join Date: May 2016
Location: Land of 100,000 lakes
Boat: Boatless for now, looking!
Posts: 379
Re: Almanac and Celestial Navigation Calculator

Thank you for all the work you are doing.
Best wishes.
__________________
If you aren't part of the solution, your the other part.
Midnight Son is offline   Reply With Quote
Old 31-10-2021, 19:46   #64
Registered User
 
SeanPatrick's Avatar

Join Date: Dec 2012
Location: Norfolk, VA USA
Posts: 673
Re: Almanac and Celestial Navigation Calculator

Thank you!
__________________
If you have any questions about celestial navigation, ask me!
Celestial Navigation Spreadsheet
NavList Celestial Navigation Forum
SeanPatrick is offline   Reply With Quote
Old 01-11-2021, 08:11   #65
Registered User

Join Date: Nov 2014
Location: Puerto Montt
Boat: Perry 47 Ketch 1981
Posts: 448
Send a message via Skype™ to surazo
Re: Almanac and Celestial Navigation Calculator

I'm one of the sailor's that to which maintain the tradition of the sextant .Unfortunately I can't open your spreadsheet because It has eliminated from dropbox .Could you send another link please .Thanks
surazo is offline   Reply With Quote
Old 01-11-2021, 08:23   #66
Registered User

Join Date: Nov 2014
Location: Puerto Montt
Boat: Perry 47 Ketch 1981
Posts: 448
Send a message via Skype™ to surazo
Re: Almanac and Celestial Navigation Calculator

Thanks .I can downloads without VPN .Regards and great work ,Congrats
surazo is offline   Reply With Quote
Old 01-11-2021, 16:52   #67
Registered User

Join Date: Nov 2018
Location: Panama
Boat: Norseman 447
Posts: 1,628
Re: Almanac and Celestial Navigation Calculator

Actually, I found the combination of the sextant with a computer quite the best of both worlds. First long passage, I used an old Radio Shack computer with a home brew Basic program. The computer saved an immense amount of work and mistakes. Then as things got really wet, first the computer, then the HO229, then the HO249 all went away. Finished the trip with the sextant and HO211 from the back of Bowditch.
Bycrick is offline   Reply With Quote
Old 01-11-2021, 18:08   #68
Registered User
 
GrowleyMonster's Avatar

Join Date: Dec 2012
Location: New Orleans
Boat: Bruce Roberts 44 Ofshore
Posts: 2,908
Re: Almanac and Celestial Navigation Calculator

Quote:
Originally Posted by surazo View Post
I'm one of the sailor's that to which maintain the tradition of the sextant .Unfortunately I can't open your spreadsheet because It has eliminated from dropbox .Could you send another link please .Thanks
FWIW, despite the disclaimer, I was able to open it with LIbre Office on my Ubuntu laptop. Seems to work okay but I didn't give it an exhaustive test or anything.
__________________
GrowleyMonster
1979 Bruce Roberts Offshore 44, BRUTE FORCE
GrowleyMonster is offline   Reply With Quote
Old 01-11-2021, 19:14   #69
Registered User
 
SeanPatrick's Avatar

Join Date: Dec 2012
Location: Norfolk, VA USA
Posts: 673
Re: Almanac and Celestial Navigation Calculator

Quote:
Originally Posted by GrowleyMonster View Post
FWIW, despite the disclaimer, I was able to open it with LIbre Office on my Ubuntu laptop. Seems to work okay but I didn't give it an exhaustive test or anything.

Yes, it seems most of it will function correctly on other platforms. But some of the features don't work even on some versions of Excel itself. For example, I tried opening it on a machine at work and the printable list of bodies was all error messages. It seems the "filter()" formula I used is exclusive to newer versions and not backwards compatible.

In order to save myself the headache of figuring out exactly what won't work on each and every platform, I just went with the blanket statement that it "can't be guaranteed" to work on anything else. But hey, if it works well enough, then great!

I was thinking about making another version just for Libre Office. (I do have it installed on my PC.) Maybe it's time I got to work on that. We'll see. I had also planned on turning it into a mobile app, but I'm not sure if I will ever get around to that.

Thanks for the heads up! And thank you all for the kind words and for trying it out!
__________________
If you have any questions about celestial navigation, ask me!
Celestial Navigation Spreadsheet
NavList Celestial Navigation Forum
SeanPatrick is offline   Reply With Quote
Old 02-11-2021, 04:58   #70
Registered User
 
SeanPatrick's Avatar

Join Date: Dec 2012
Location: Norfolk, VA USA
Posts: 673
Lightbulb Update

Apologies, but I just found a bug ... of course. And it's a bug I thought I had already squashed. Maybe I'll get it right this time ... [Link]

v 0.3.2 - 2021, Nov 2

  • Fixed a bug [again] causing the spreadsheet to display incorrect values for the equation of time under certain circumstances.
__________________
If you have any questions about celestial navigation, ask me!
Celestial Navigation Spreadsheet
NavList Celestial Navigation Forum
SeanPatrick is offline   Reply With Quote
Old 02-11-2021, 08:10   #71
Registered User

Join Date: Nov 2014
Location: Puerto Montt
Boat: Perry 47 Ketch 1981
Posts: 448
Send a message via Skype™ to surazo
Re: Almanac and Celestial Navigation Calculator

Thanks Sean
surazo is offline   Reply With Quote
Old 02-11-2021, 13:09   #72
Registered User
 
SeanPatrick's Avatar

Join Date: Dec 2012
Location: Norfolk, VA USA
Posts: 673
Re: Almanac and Celestial Navigation Calculator

Quote:
Originally Posted by surazo View Post
Thanks Sean

You are very welcome!
__________________
If you have any questions about celestial navigation, ask me!
Celestial Navigation Spreadsheet
NavList Celestial Navigation Forum
SeanPatrick is offline   Reply With Quote
Old 07-11-2021, 00:51   #73
Registered User
 
SeanPatrick's Avatar

Join Date: Dec 2012
Location: Norfolk, VA USA
Posts: 673
Lightbulb Update

I have added the option to the sky chart to display all 1,535 stars from the basic FK5 catalogue (see screenshot, below). As with the navigational stars, corrections for proper motion have been included. There is a check-box below the chart to show or hide them. These will not be selectable in the almanac or sight reduction calculator. But if you hover your mouse over them, the calculated azimuth and altitude will be displayed. So, they can be used for navigation in a pinch ... you'll just have to plot the LOPs manually. Maybe I will change this in the future.

I have also tweaked the map alignment. Waypoints shouldn't be plotted off the edge of the map anymore [mostly], and the waypoints, DR and fix should be plotted a bit more accurately. (Although at this scale I admit it's hard to see the difference.)

As always, the new version is available at my website. Cheers!

v 0.3.3 - 2021, Nov 7

  • Added the option to the sky chart to display all 1,535 stars from the basic FK5 catalogue. (This increased the size of the spreadsheet from 2.5MB to 3.7MB.)
  • Tip: You can hover your mouse over any star to see its calculated azimuth and altitude.
  • Fixed a bug causing the almanac date and time to change when using the data series or rise/set calculators. (Almanac date and time will still change when using the sight reduction tab.)
  • Improved map alignment. Waypoints and DR/Fix will now be plotted more accurately.
  • Minor formatting changes.

__________________
If you have any questions about celestial navigation, ask me!
Celestial Navigation Spreadsheet
NavList Celestial Navigation Forum
SeanPatrick is offline   Reply With Quote
Old 08-11-2021, 22:57   #74
Registered User

Join Date: Aug 2021
Location: PNW
Boat: 35 Ft. cutter, custom
Posts: 2,467
Re: Almanac and Celestial Navigation Calculator

Quote:
Originally Posted by GrowleyMonster View Post
I knew a guy who kept his old Loran C long after the stations were shut down. Why? Because he could use the Great Circle computation ability of the obsolete Loran to calculate his Zn and Hc by entering declination and GHA as a waypoint and his AP as another, and subtracting the resulting miles as minutes of arc from 90, All because he understood the celestial triangle and how it fits in to the world and universe around him. And this depth of understanding came from a dedicated study of Navigation. Cool? I think so. Some navi-phobes I am sure will disagree.
That was a great idea!
I did something on a smaller scale; Kept a Magnavox Sat-Nav on board for years after the system shut down.
It already had speed and course inputs, you could manually enter your estimated set/drift, (or not,) and it would keep a running DR for you.
I liked that Sat-Nav and found it quite accurate, (of course this was when GPS was in its 1st generation,) once, while sitting at anchor, I was in a place where I could take a round of bearings of known objects shown on the chart.
Plotting those bearings I KNEW where I was, and the Sat-Nav was actually closer than either of the 2 handheld GPS units.

Quote:
Originally Posted by A.Sailor View Post
Amazing work! I wish I could use it!
...it would be rather hard while far from the sea.
You might enjoy the stories of how the British drove a stake at the low tide of the tip of India and proceeded to march North, spreading out and mapping the entire country using sextants and transits, hauling huge degree wheels up on towers.
They poured mercury from a flask into a dish to make an horizon.

Sorry for thread drift,, I prefer HO 211, and made/printed up my own worksheets for it.
The HP 41 has a Nav-Pak in it, but the 41 has failed.
I wrote simple programs into the HP 48SX, but alas, it has gone down too.
But now I have no "need" to do any celestial work, but after recently observing the moon coming up on Jupiter and passing it I was intrigued by the idea of Lunar Distance.
Bowdrie is online now   Reply With Quote
Old 09-11-2021, 11:12   #75
Registered User
 
SeanPatrick's Avatar

Join Date: Dec 2012
Location: Norfolk, VA USA
Posts: 673
Re: Almanac and Celestial Navigation Calculator

Quote:
Originally Posted by Bowdrie View Post
But now I have no "need" to do any celestial work, but after recently observing the moon coming up on Jupiter and passing it I was intrigued by the idea of Lunar Distance.
Frank Reed has a great lunars page with information and tools for shooting lunars. My personal favorite is his easy lunars page, which describes how to do all of the math on a handheld calculator.

I also like the Stark Tables. But I think that once you get used to it, the calculator method is faster. Of course, Frank's online calculator is the quickest and easiest way.

Cheers!


PS
My original intent was to include a lunars calculator in my spreadsheet. I still plan on adding it one day when I have the time.
__________________
If you have any questions about celestial navigation, ask me!
Celestial Navigation Spreadsheet
NavList Celestial Navigation Forum
SeanPatrick is offline   Reply With Quote
Reply

Tags
Almanac, celestial navigation, EXCEL, Great Circle, Sight Reduction

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are Off
Pingbacks are Off
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Celestial Navigation Qs. Simulated sights, long term almanac ohthetrees Navigation 49 30-03-2019 11:03
The New and Improved Celestial Navigation Poll deckofficer Navigation 317 24-04-2015 07:06
Celestial Nav. - Sight Reduction with Calculator Gos2015 Navigation 19 12-01-2015 12:43
Celestial 229 vs 'Calculator Method' ? sneuman Navigation 43 08-11-2012 13:07
Coastal and Celestial Navigation Courses and Tools Coolruns Navigation 0 04-12-2010 06:38

Advertise Here


All times are GMT -7. The time now is 14:31.


Google+
Powered by vBulletin® Version 3.8.8 Beta 1
Copyright ©2000 - 2024, vBulletin Solutions, Inc.
Social Knowledge Networks
Powered by vBulletin® Version 3.8.8 Beta 1
Copyright ©2000 - 2024, vBulletin Solutions, Inc.

ShowCase vBulletin Plugins by Drive Thru Online, Inc.