Results 1 to 6 of 6
  1. #1
    Lounger
    Join Date
    Jul 2005
    Location
    Benbrook, Texas, USA
    Posts
    37
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Formula Help (2000)

    I am trying to set up a spreadsheet (attached) to keep track of elevations along a varying slope. The thing I need help with is adding a category. Right now I have it set up where I can enter the slope, distance, starting elevation, and interval to measure the elevation.

    I would like to be able to add an entry to Slope 1. Using survey information, we label our distances using the following format called stations:

    0+00 = starting point
    0+50 = 50 feet from starting point
    0+70 = 70 feet from starting point
    1+20 = 120 feet from starting point etc....

    I would like to be able to enter a starting station and have excel keep track of it. Sometimes I need to check the slope in the middle of a section and it would just be easier if I could enter the station instead of having to keep track in my head.

    Thanks for your help.

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Formula Help (2000)

    Please explain in detail and exactly what you want to accomplish. What do you want to add, how do you want to add it, where do you want to add it and what should be the result of this addition? Please be as specific as you can.

  3. #3
    Lounger
    Join Date
    Jul 2005
    Location
    Benbrook, Texas, USA
    Posts
    37
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Formula Help (2000)

    I would like to add the following:
    Cell F3 = Starting Station (format of X+XX)
    Cell F4 = the cell where the starting station is entered by the user
    I would like cell C8 to still keep referencing the interval, but also reference the starting station. For example:

    If I were to enter 100 into cell C4 (Distance), 20 into cell E4 (Interval) and 6+20 into the newly created cell F4 (Starting Station), I would like to see the following information in column C below the Station heading starting in cell C8:

    6+40
    6+60
    6+80
    7+00
    7+20

    I hope this makes sense. Let me know. Thanks

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Formula Help (2000)

    Basically, you'd replace C7 with F4 in the formula in C8, but it's not clear to me what you would want to use as "stop" criteria (i.e. when to return an empty string).

  5. #5
    Silver Lounger
    Join Date
    Jul 2001
    Location
    Ottawa, Ontario, Canada
    Posts
    1,609
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Formula Help (2000)

    I believe that what you are after is provided in the attached file. I have added formulae to column F; and for clarification, unhidden row 7.
    Regards
    Don

  6. #6
    Silver Lounger
    Join Date
    Jul 2001
    Location
    Ottawa, Ontario, Canada
    Posts
    1,609
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Formula Help (2000)

    Further to my last post; if you would prefer to enter the Starting Station as 620 instead of 6+20, then:
    1. <LI>Cut cell F7;
      <LI>Select cell F4 and Paste; then
      <LI>Format cell F4 as "0+00"
    Regards
    Don

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •