Introduction to this site

This celestial navigation software allows the reduction of sextant sights. The software is based on macro-enabled Microsoft Excel Worksheets. With primary input data from the Nautical Almanac, it gives a graphical representation of the various parameters used in the solution of the spherical navigation triangle, while minimizing the need of correction tables. Up to three sights can be processed and the results are plotted, showing azimuth lines and circles of position. The intersections of the circles of position are computed, as well as the resulting mean position.

One must keep in mind that electronic navigation aids (GPS and others), although indispensable nowadays because of their efficiency and accuracy, will always be subject to technology contingencies, their status of maintenance and, not the least, the variability of the world mutual trust. Celestial navigation remains above all those constraints… And when nothing else works, the good old sextant will always come in handy… as long as one knows how to use it!

I developed this software in an attempt to put together the knowledge acquired from navigation courses from the Canadian Power Squadron, and I offer it for free to all who have an interest in sextant celestial navigation as a challenge, to preserve the knowledge and know-how, or out of sheer curiosity.

Following that line of thought, this software can be considered more as a teaching aid and may contain errors affecting navigation. Hence, there is no warranty pertaining to the accuracy and the results obtained from using the product.

How to download AstronavXls and other documents

- In the “Download Documents” section, to the right, click on the document you want to download (for example, The latest version of AstronavXls);

- A sample of the file will open on the screen, in a “Google Document” format (this is a non-active file);

- To download the original Excel file, click on the “underscored down arrow” icon on top of the screen; a text box, at the bottom of the screen, will appear and offer you a choice to open the file in Excel mode, or save it to your computer.

- The first time you open the downloaded Excel document, it may open in “protected mode”. Click on “Activate modification”, and save the document.

About the Excel file

The Excel file containing the Astronav software is a Microsoft Office 2013 version with a *.xlsm extension. The “m” in the extension indicates that the file includes “macro functions”. Therefore, the “macro-enable” option must be activated in your Excel setup. The procedure to do so is as follows, once the file is opened:

- Click on the File tab (upper left corner), then «Excel Options/Trust Center/Trust Center Settings/Macro Settings/Enable all macros».

- The procedure may be slightly different in earlier versions of Microsoft Excel.

The file that you are downloading contains, by default and as an example, old sight data taken many years ago, as I was taking the CPS courses. The worksheets may be re-initialized to 0 by clicking on the button «Reset all input data to 0». Nautical Almanac data can be obtained from the following site:
http://www.tecepe.com.br/scripts/AlmanacPagesISAPI.isa.
All you have to do is to enter a date and the data for 3 consecutive days will be displayed.

The advantage of the Excel file is that it may be renamed and saved with all your sight data sets, in as many copies as you want. Hence it is good practice to keep a copy as a clean template.

Fair winds and navigation!

Paul Chevrette

Friday, 10 February 2012

Version 10.0.3

Restricted choices have been implemented for some non-numerical parameters such as N, S, E, W, etc.
The height of the eye can now be entered either in feet or meters.
A calculation error occured when the longitudes of the geographical position of the celestial body and the circle of position were on either sides of the date line (different signs) and yielded a difference value greater then 180°. This was corrected to select the shortest distance.
The great-circle navigation file was upgraded.
Paul

2 comments:

Anonymous said...

I have excel 2010. Will it work with the spread sheet without having Microsoft office? Thanks, Bill

Paul Chevrette said...

The spread sheet was developed with Excel 2007, but I assume that Excel 2010 should be backward compatible and it should work. The best thing to do is to try it and see. Normally, Excel comes as part of Microsoft Office, but I guess you may have Excel without it... Let me know if it works.
Paul