SUBSIM Radio Room Forums



SUBSIM: The Web's #1 resource for all submarine & naval simulations since 1997

Go Back   SUBSIM Radio Room Forums > General > Sub & Naval Discussions: World Naval News, Books, & Films
Forget password? Reset here

Reply
 
Thread Tools Display Modes
Old 01-06-21, 04:01 AM   #1
Sean C
Grey Wolf
 
Join Date: Jun 2017
Location: Norfolk, VA
Posts: 900
Downloads: 12
Uploads: 2


radar Almanac and Celestial Navigation Calculator

All,

Here is a link to the latest version of my Excel almanac. I have added a data series calculator, sight reduction calculator, position log, great circle route planner and map. (It's really just a consolidation of several different spreadsheets.) A few bugs from the last version have also been squashed.


The new data series calculator can be used to make charts like the following for data comparison or analysis:





I would greatly appreciate it if everyone could test it out to make sure everything works. Nothing rigorous. I'd just like to know if it all functions as intended. I've been having a little trouble locking some parts of the spreadsheet while still keeping it functional. But I think I've got it solved - for now. Not the most elegant solution, but maybe I can improve on it in the future.

Thanks!

Shawn


PS
Don't let the warning about macros scare you. Neal knows where I live ... seriously.



Link to the zipped spreadsheet.


Link to the unzipped spreadsheet.


***NOTE: This spreadsheet is only guaranteed to work in current versions of Microsoft Excel.***


Current list of features:

Perpetual almanac which lists basic data necessary for celestial navigation
Sky chart showing traditional nav bodies above the horizon
Data series calculator for comparison/analysis
DR and sight reduction calculator
Position log
Great circle route calculator including internal database of ~15,500 cities worldwide
Internal delta-T values for dates between 500 BC and AD 2030
Custom delta-T value fields for dates outside the above range - or whenever
Only 2MB


Some stats:

Total Sheets: 18
Cells with data: 180,868
Tables: 4
Formulas: 8,373
Charts: 2
Macros: 26
Days I've been working on it so far: 237


























__________________
If you have a question about celestial navigation ... ask me!
Celestial Navigation Spreadsheet

Last edited by Sean C; 01-23-21 at 05:51 AM. Reason: Updated links to new version. Updated screenshots. Added info.
Sean C is offline   Reply With Quote
Old 01-06-21, 05:06 AM   #2
vienna
Navy Seal
 
Join Date: Jun 2005
Location: Anywhere but the here & now...
Posts: 7,488
Downloads: 85
Uploads: 0


Default

Yeah, hey...

...like, do you know the way to San Jose...?...





<O>
__________________
__________________________________________________ __
vienna is offline   Reply With Quote
Old 01-06-21, 05:13 AM   #3
Catfish
Dipped Squirrel Operative
 
Catfish's Avatar
 
Join Date: Sep 2001
Location: ..where the ocean meets the sky
Posts: 16,880
Downloads: 38
Uploads: 0


Icon14

Hello Nathaniel umm Shawn,
i always wanted to ask you since you advertised "ask me" ... seems to be a nice tool !
__________________


>^..^<*)))>{ All generalizations are wrong.
Catfish is offline   Reply With Quote
Old 01-06-21, 05:20 AM   #4
Skybird
Soaring
 
Skybird's Avatar
 
Join Date: Sep 2001
Location: the mental asylum named Germany
Posts: 40,340
Downloads: 9
Uploads: 0


Default

Its the first chess program I have ever seen that gives out the moves in Longitudes and Latitudes.
__________________
If you feel nuts, consult an expert.
Skybird is offline   Reply With Quote
Old 01-06-21, 05:37 AM   #5
Sean C
Grey Wolf
 
Join Date: Jun 2017
Location: Norfolk, VA
Posts: 900
Downloads: 12
Uploads: 2


Default

Quote:
Originally Posted by Skybird View Post
Its the first chess program I have ever seen that gives out the moves in Longitudes and Latitudes.

Pffft. I'm terrible at chess. And anything involving strategy. Like Steel Beasts.
__________________
If you have a question about celestial navigation ... ask me!
Celestial Navigation Spreadsheet
Sean C is offline   Reply With Quote
Old 01-06-21, 05:57 AM   #6
Sean C
Grey Wolf
 
Join Date: Jun 2017
Location: Norfolk, VA
Posts: 900
Downloads: 12
Uploads: 2


Default

By the way, there's no reason this spreadsheet can't be used with a flight sim like MSFSX or whatever as well. The route planner includes a database of about 15,500 cities worldwide (many nowhere near water) and will plot the shortest route between any two.


The sight reduction calculator should work with aerial observations, as well.


There are a couple of minor bugs I have left to kill. (See the bottom of the instructions tab.) And some more features I want to add.


I was thinking of making a special edition, too.
__________________
If you have a question about celestial navigation ... ask me!
Celestial Navigation Spreadsheet
Sean C is offline   Reply With Quote
Old 01-06-21, 05:35 AM   #7
Sean C
Grey Wolf
 
Join Date: Jun 2017
Location: Norfolk, VA
Posts: 900
Downloads: 12
Uploads: 2


Default

Quote:
Originally Posted by Catfish View Post
Hello Nathaniel umm Shawn,
i always wanted to ask you since you advertised "ask me" ... seems to be a nice tool !

Please feel free to ask me anything about celestial navigation. I really enjoy teaching people about it!


I should probably ask Neal to change my forum name. I chose it as a nod to Nathaniel Bowditch, the editor of The American Practical Navigator (now mostly known simply as Bowditch). But it is probably a bit confusing ... and obscure.


Hey Neal, if you're reading this: can you please go ahead and change my forum name to something like "Sean C"? That's what I use on some other forums. I'll send you a PM, too. Thanks in advance!
__________________
If you have a question about celestial navigation ... ask me!
Celestial Navigation Spreadsheet
Sean C is offline   Reply With Quote
Reply

Tags
almanac, celestial navigation, excel, great circle, spreadsheet

Thread Tools
Display Modes

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

Forum Jump


All times are GMT -5. The time now is 03:05 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright © 1995- 2024 Subsim®
"Subsim" is a registered trademark, all rights reserved.