Search results
How to calculate altitude and azimuth using a free and intuitive spreadsheet (excel) after sextant sights (Celestial Navigation) - free software.
A collection of spreadsheets for performing calculations associated with celestial navigation. The spreadsheets available through this repository are designed to increase the accuracy, reliability, and the speed with which you can derive your position from observations of the heavens.
Enter the information required into the unlocked white cells bounded in green. The grey cells return intermediate results, such as GHA, Declination, LHA, Hc and Ho, which you can compare with results obtained from the Sight Reduction Tables. The final result, in blue, is your Azimuth and Intercept.
GFZ Potsdam - IGRF declination calculator. City: (optional) Alternatively, input your own global coordinates. Date: (1900 - 2025) Altitude (optional): m.
results in the observed altitude (Ho). The Universal Time (UT) of the sight is used to determine the Geographical Position (GP) with the help of an almanac. The declination and Greenwich Hour Angle (GHA) of the GP plus the Ho for the two sights are entered in row 3 of the spreadsheet. The solutions are displayed in rows 8 and 10. 3
7 lut 2010 · This page provides details of a range of user functions for astronomy for Microsoft Excel version 5 or later. These functions may also be of interest to land surveyors and construction technicians, as well as teachers of astronomy and amateur astronomers.
The declination calculator provides declination values for any location on Earth and any time between 1900 and 2025. The calculation is based on the International Geomagentic Reference Field (IGRF) which describes the geomagnetic core field.
