Re: Spreadsheet calculations with offsets

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Hello,
This is a engineer station 0+00 = 000.00 and 5+00 = 500.00.
"MartinW" <htmw@xxxxxxxxxxxxxxx> wrote in message
news:uxp53EfBJHA.3348@xxxxxxxxxxxxxxxxxxxxxxx
Hi Mark,

I'm not clear on the 0+00 input, but this may be
what you are looking for.

In your example,
Put this in B3 and drag to B4
=TREND(B$1:B$2,A$1:A$2,A3)

That's assuming your sample data is in A1:B2

HTH
Martin


"mark" <mark@.invalid> wrote in message
news:u1u8CmeBJHA.4724@xxxxxxxxxxxxxxxxxxxxxxx
Sure no problem for now lets try to make it easy and then we can try the
macro
for variable stations length nothing to fancy.

Station offset
row 1 0+00 (I input) 12 (I input a no.)
row 2 5+00 (I input) 24 (I input the no)
row 3 any distance(I input) calculated value
row 4 any distance(I input) calculated value

Ok, the plus sign station will be inputted by me and if I understand
correctly about
the footmarks after the offset and stations (I input a no.) you really
don't
need it that
was just used for explanation purposes.
Thanks again for your help I hope we can get it to work


"Rick Rothstein (MVP - VB)" <rick.newsNO.SPAM@xxxxxxxxxxxxxxxxxx> wrote
in
message news:OpcZPiaBJHA.3348@xxxxxxxxxxxxxxxxxxxxxxx
For future reference, you should follow the answer style used by the
person
responding to you. I top posted my response, so you should top post
your
reply to me. Why? So someone reading this thread in the Google archives
can
follow the order of the responses.

Okay, I thought you might have been suggesting that order in your first
message. There is a problem with doing it that way. Only one of your
"fixed"
points is really fixed (the 0+00 station), the other is at the end of
the
data. This makes it hard to give you a formula because any formula will
be
dependent on address of the "fixed" points and one of your "fixed"
points
will vary with the amount of intermediate points between them. Is there
any
chance you can lay your data out in a way that your Start and End
Stations
and their Offsets are in fixed locations (maybe in the first 2 rows)
with
the intermediate points following them? That way your formulas won't be
overwritten by data as the number of intermediate points change. If you
would rather not do that (that is, you want to stick with the layout
you
showed), are you allowed to run a macro which could perform the
calculations?

And you didn't answer my question about how the plus sign is place in
your
Station numbers or how the "foot mark" is placed at the end of the
Offset
distance. Are they put there by a custom format of the cells or are you
physically typing them in?

Rick


Yes you are correct in the simple proportion and if it is possible I
would
like it in a cell format maybe something like this.
A B
1 Station offset distance
2 0+00 (I input) 12 (I input the no.)
3 any distance(I input) calculated value
4 any distance(I input) calculated value
5 500+00(I input) 24 (I input the no.)

I hope I explain myself clear on this it does not have to be to fancy









.

Quantcast