Drop Column
Drop Column
(OP)
In doing manual volume calculations in embankment fills, you have two end areas. Then the average x length = volume. But, I would like to know if I can drop the average area, length and volume columns a half row in order to have the volume reflect between the two end areas:
Area Length Volume
25
45 3 105
I want:
25
35 3 105
45
Thanks!
Area Length Volume
25
45 3 105
I want:
25
35 3 105
45
Thanks!

RE: Drop Column
Area 1 Area 2 Ave. Area Length Volume
25 45 35 3 105
Good luck,
Latexman
RE: Drop Column
Use one row for each.
Or use different formatting (top, middle and bottom) of a single tall row.
RE: Drop Column
k125+050 25
k125+075 35
k125+100 28
so you see that to get area between chainage k125+050 and k125+075, you follow the form I originally sent. We have hundreds of chainages in a column and by organizing in a drop column (following the old hand calculations) it "appears" cleaner to the eye. I suppose I can just use every other row for the chainages but would be nice not to "thicken" the spreadsheet thus.
Thanks for the interest.
RE: Drop Column
then select the columns for the average area, length and volume and format them for "top" alignment (the chainage and end areas being the default "bottom"alignment),
this should give the appearance you require, without introducing extra rows.