Welcome to the NavList Message Boards.


A Community Devoted to the Preservation and Practice of Celestial Navigation and Other Methods of Traditional Wayfinding

Compose Your Message

Add Images & Files
    Re: Need help writing a slope-fit excel sheet
    From: Brad Morris
    Date: 2014 Jan 27, 22:11 -0500


    Fix the scale of the chart. Right click on the vertical axis and select min and max values. 


    On Jan 27, 2014 10:07 PM, "Greg Licfi" <cfi@licfi.com> wrote:

    Hi Brad,
        Your sheet seems to change the scale and not actually move the Hc slope up or down
    from the Hs line (?). Can I impose upon you to please take a look at my sheet and see what
    you can do with it to change the value in the control cell (G20) it should step up or down in
    0.1 (arc minute) steps via the buttons or a slide tool like yours. It should not change the scale.

    On 01/27/2014 04:49 PM, Brad Morris wrote:

    Hello Greg

    Here is a simple way to do what you want (I think).

    Attached, please find an example (sheet 1) with instructions (sheet 2). The floating data slides up and down compared to the original data.

    Hopefully its fully self explanatory. If not, I can answer questions

    NavList message boards and member settings: www.fer3.com/NavList
    Members may optionally receive posts by email.
    To cancel email delivery, send a message to NoMail[at]fer3.com

    Attached File:

    (ScrollBarExampleAndInstruct.xlsx: Open and save)

    View and reply to this message: http://fer3.com/arc/m2.aspx?i=126727

    Attached File:

    (img/126728.slope fit.xls: Open and save or View online)

    View and reply to this message: http://fer3.com/arc/m2.aspx?i=126728

    Browse Files

    Drop Files


    What is NavList?

    Join NavList

    (please, no nicknames or handles)
    Do you want to receive all group messages by email?
    Yes No

    You can also join by posting. Your first on-topic post automatically makes you a member.

    Posting Code

    Enter the email address associated with your NavList messages. Your posting code will be emailed to you immediately.

    Email Settings

    Posting Code:

    Custom Index

    Start date: (yyyymm dd)
    End date: (yyyymm dd)

    Visit this site
    Visit this site
    Visit this site
    Visit this site
    Visit this site
    Visit this site