Scribd Logo
Upload

Welcome to Scribd!

  • 20 views

    Celestialworksheet RF

    Uploaded by

    Hoài Thanh
    1) This document contains a multiple object celestial navigation sight reduction spreadsheet that can process up to 6 observations. 2) It includes inputs for observed data like true course, speed, eye height, temperature, and pressure as well as outputs for calculated altitude, estimated position, and improved position estimates. 3) The spreadsheet performs sight reduction calculations to determine the observed and calculated altitudes for celestial objects like the sun and moon, as well as position lines of position and an improved estimated position.

    Copyright:

    © All Rights Reserved
    Download as XLS, PDF, TXT or read online from Scribd

    Celestialworksheet RF

    Uploaded by

    Hoài Thanh
    20 views5 pages
    1) This document contains a multiple object celestial navigation sight reduction spreadsheet that can process up to 6 observations. 2) It includes inputs for observed data like true course, speed, eye height, temperature, and pressure as well as outputs for calculated altitude, estimated position, and improved position estimates. 3) The spreadsheet performs sight reduction calculations to determine the observed and calculated altitudes for celestial objects like the sun and moon, as well as position lines of position and an improved estimated position.

    Original Title

    celestialworksheetRF (1).xls

    Copyright

    © © All Rights Reserved

    Available Formats

    XLS, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    1) This document contains a multiple object celestial navigation sight reduction spreadsheet that can process up to 6 observations. 2) It includes inputs for observed data like true course, speed, eye height, temperature, and pressure as well as outputs for calculated altitude, estimated position, and improved position estimates. 3) The spreadsheet performs sight reduction calculations to determine the observed and calculated altitudes for celestial objects like the sun and moon, as well as position lines of position and an improved estimated position.

    Copyright:

    © All Rights Reserved
    Download as XLS, PDF, TXT or read online from Scribd
    Download as xls, pdf, or txt
    20 views5 pages

    Celestialworksheet RF

    Uploaded by

    Hoài Thanh
    1) This document contains a multiple object celestial navigation sight reduction spreadsheet that can process up to 6 observations. 2) It includes inputs for observed data like true course, speed, eye height, temperature, and pressure as well as outputs for calculated altitude, estimated position, and improved position estimates. 3) The spreadsheet performs sight reduction calculations to determine the observed and calculated altitudes for celestial objects like the sun and moon, as well as position lines of position and an improved estimated position.

    Copyright:

    © All Rights Reserved
    Download as XLS, PDF, TXT or read online from Scribd
    Download as xls, pdf, or txt
    of 5

    MULTIPLE OBJECT CELESTIAL NAVIGATION SIGHT REDUCTION SPREAD SHEET

    UP TO 6 OBJECTS OR OBSERVATIONS
    OBSERVED DATA
    True Course >> 45.0 degrees Last fix Latitude >> 39.2093 dec.deg. Date >> 7/15/2001
    Speed >> 1.0 knots Last fix Longitude >> -76.8294 dec.deg. month,day,year
    Eye Height >> 0.00 m UT of Last Fix >> 21 dec. hours
    Temperture >> 20 deg C Sign convention UT time for 22
    Pressure >> 1015 mbars N +, S - E +, W - this present fix
    inputs are in pale yellow
    Observation # 1 2 3 4 5 6 outputs are in pale green
    OBJECT >> sun moon
    Limb sign >> 1 1 1 1 1 1 <<<< lower limb = +1 upper limb, = -1
    UT >> 22.1194 22.0694 decimal hours = cardinal hour + M/60 + S/3600
    Hs >> 13.6583 28.5200 decimal degrees = DEGREE + ARCMINUTES /60

    I + IC >> 0.0000 decimal degrees Index Correction, adds to an


    PC >> 0.0000 decimal degrees Personal correction for tech
    DipC = 0.0000
    Ha = 13.6583 28.5200 0.0000 0.0000 0.0000 0.0000 Apparent altitude
    SD >> 0.0000 0.0000 semi diameter, decimal degrees
    HP >> 0.9750 horizontal parallax, decimal degrees
    R= -0.0647 -0.0295 0.0000 0.0000 0.0000 0.0000 refraction
    PA = 0.0000 0.8567 0.0000 0.0000 0.0000 0.0000 parallax in altitude
    CorrALT = -0.0647 0.8271 0.0000 0.0000 0.0000 0.0000 altutide corrections (R + PA +SD*signLimb)
    Ho = 13.5937 29.3471 0.0000 0.0000 0.0000 0.0000 Observed Altitude, decimal degrees

    ESTIMATED POSITION at TIME OF PRESENT FIX


    Time interval = 1.00 decimal hours
    Distance= 1.00 n.miles Estimated distance traveled since last fix to the present fix
    Change in Lat = 0.71 arc minutes
    Change in Lon = 0.91 arc minutes
    DR Latitude = 39.2211 dec. deg.
    DR Longitude = -76.8142 dec. deg.
    Running Fix offset -0.12 -0.07 0.00 0.00 0.00 0.00 nautical miles, Offset distance
    NAUTICAL ALMANAC DATA, GHA and Declination GHA nominal hourly rates
    Sun, planets Aries Moon
    Determine GHA at the specific Universal Time 15.0000 15.0411 14.3167
    GHA tables >> 150.9550 73.9667 GHA at the hour, decimal degrees
    variance v >> 0.0000 7.5000 arc minutes/hr
    GHA rate >> 15.0000 14.3167 <<<<<<<< <<<<<<<< <<<<<<<
    SHA >> if sun or planets, leave blank

    time fraction= 0.1194 0.0694 0.0000 0.0000 0.0000 0.0000 fraction of the hour, M/60 + S/3600
    CorrGHA = 1.7917 0.9942 0.0000 0.0000 0.0000 0.0000
    CorrV = 0.0000 0.0087 0.0000 0.0000 0.0000 0.0000
    GHA total = 152.7467 74.9696 0.0000 0.0000 0.0000 0.0000
    Determine Declination at the specific Universal Time (N +, S -)
    Dec. tables >> 3.9767 -21.5800 declinationat the hour, dec. deg.
    rate d >> -1.0000 -8.2000 arc minutes/hr

    d correction= -0.0020 -0.0095 0.0000 0.0000 0.0000 0.0000


    Dec. total = 3.9747 -21.5895 0.0000 0.0000 0.0000 0.0000

    Using The GHA and Declination Values, Determine Calculated Altitude Hc

    Assumed Latitude>> 39.2093 dec.deg.


    Assumed Longitude >> -76.8294 dec.deg.

    LHA = 75.917 -1.860 0.000 0.000 0.000 0.000 decimal degrees

    Hc = 13.409 29.176 0.000 0.000 0.000 0.000 decimal degrees

    Doffset = 11.08 10.25 0.00 0.00 0.00 0.00 nautical miles

    Zo = 95.9 178.0 0.0 0.0 0.0 0.0 decimal degrees

    Azimuth = 264.1 178.0 0.0 0.0 0.0 0.0 decimal degrees


    Improved Position Estimate

    p1 = 0.1846 0.1708 0.0000 0.0000 0.0000 0.0000


    p2 = 0.0015 0.0008 0.0000 0.0000 0.0000 0.0000

    A= 1.0093
    B= 0.0675
    C= 0.9907
    D= -0.1906
    E= -0.1793
    G= 0.9954
    LONGITUDE new -77.047 decimal degrees
    LATITUDE new 39.032 decimal degrees
    DISTANCE = 14.7 n.miles from assumed position
    if greater than 20 n.miles then redo all calculations with this new estimated position

    D distance = 14.71 n.miles great-arc distance from last fix


    Bearing = 136.3 Great-arc course from last fix, degrees from true north
    inputs are in pale yellow
    outputs are in pale green

    per limb, = -1
    hour + M/60 + S/3600
    REE + ARCMINUTES /60

    Index Correction, adds to angle


    Personal correction for technique

    PA +SD*signLimb)
    v Manually input one of these rates in B41 thru G41
    v
    v
    v

    60 + S/3600

    You might also like