Declination 20° 47,5’ S d correction : 0,5’.

“ worksheet :įrom the Nautical Almanac – January 17 th 2016 : Corrections: +0,5’ instrument error (eccentricity) and -1,4’ index errorįirst of all we convert the sextant altitude to observed altitude using “Corrections to a sextant obser. Height of eye above the sea level : 2,5 meters.DR position : Latitude 38☃4,2’ North – Longitude 005☃2,7’ East.Sun ( lower limb ) - sextant altitude 29° 53,5’ at 12h 23m 45s U.T.On January 17th 2016 a Deck Officer takes and records the following sight : (The name of the worksheet appears on its sheet tab at the bottom of our document window.) When we open Excel, Excel automatically selects “Corrections to a sextant obser. To prevent damages in cells containing formulae the worksheets are protected and cells are locked, we may use the unlocked cells only (green background).

We can use this simple excel file to verify (or avoid) the manual calculations ! The data we need are : true altitude, LHA/declination, computed (estimated) altitude and azimuth We’ll use these to plot lines of position (LOP) on a nautical chart, plotting work sheet, or a simple graph paper to determine the position of the ship. after having collected all the data : estimated latitude and longitude, declination / local hour angle of the observed celestial bodies (stars, sun, moon and planets ) and sextant reading (altitude). How to calculate altitude and azimuth using a free and intuitive spreadsheet (excel)

Celestial Navigation: the science of navigating - knowing and using the celestial bodies (stars, Sun, planets and Moon)

Celestial air navigation pro comp form