Re: Level Notes with excel

In article <[EMAIL PROTECTED]>,
Don Phillips <[EMAIL PROTECTED]> wrote:
>
>It has been 20 years since I kept a log book for my surveying class in
>college.  I think you are asking Excel to add and subtract cells in certain
>columns.  Did I lose that many brain cells over the years?

For any given survey it would be easy.  But if you want to set
a generic one up, you would have to make sure it calculates off
the most current instrument height.

I would think though, that if you Instrument Height repeated on
every line, with an IF statement, that used the previous line, or
recalculated it if there was a BS.  And then if there was an FS or
another shot, that is calculated an elevation if there was a shot, with
another IF statement.  I'm not quite sure how you would select
automatically have the sheet know how to calculate the new instrument
height for a BS, though, because you would have to have some kind of
lookup thing find the correct height .... perhaps best fixing manually ...
(but we all know, that is when the errors start happening!).  I'm sure
there is a nifty way to do it in Excel; perhaps an IF statement that
does a unique VLOOKUP on the point name ....

Nick