Welcome to the NavList Message Boards.

NavList:

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

Compose Your Message

Message:αβγ
Message:abc
Add Images & Files
    or...
       
    Reply
    Re: Need help writing a slope-fit excel sheet
    From: Brad Morris
    Date: 2014 Jan 28, 00:19 -0500

    Gentlemen

    I have taken this conversation private.   Greg is being helped, I just didn't think the guts of Excel to be a NavList topic.

    Brad

    On Jan 27, 2014 10:27 PM, "Brad Morris" <bradley.r.morris@gmail.com> wrote:

    Greg

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

    Brad

    On Jan 27, 2014 10:07 PM, "Greg Licfi" <cfi{at}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.
    Thanks,
          ~Greg


    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

    Brad
    ----------------------------------------------------------------
    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

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

       
    Reply
    Browse Files

    Drop Files

    NavList

    What is NavList?

    Join NavList

    Name:
    (please, no nicknames or handles)
    Email:
    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:

    Email Settings

    Posting Code:

    Custom Index

    Subject:
    Author:
    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