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
    Name or NavList Code:
    Email:
       
    Reply
    Re: Need help writing a slope-fit excel sheet
    From: Brad Morris
    Date: 2014 Jan 27, 22:11 -0500

    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@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)

    : http://fer3.com/arc/m2.aspx?i=126727


    Attached File:

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

    : http://fer3.com/arc/m2.aspx?i=126728

       
    Reply
    Browse Files

    Drop Files

    NavList

    What is NavList?

    Get a NavList ID Code

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

    A NavList ID Code guarantees your identity in NavList posts and allows faster posting of messages.

    Retrieve a NavList ID Code

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

    Email Settings

    NavList ID 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