1. ## 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.

2. ## 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. ## 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. ## 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. ## 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.

6. ## 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"

#### Posting Permissions

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