Cut and Fill 2

[dik]

Is anyone aware of, or have a copy of, a spreadsheet that calculates cut excavation volumes for a small trench with sloped sides, a flat bottom and an existing grade that may be sloped. The above x-section information may vary at each end of the trench.

 

[BigInch]

and you might as well ask for different slopes and different lengths of the slope on each side of the trench too, because you will probably have them.

"The top of the organisation doesn't listen sufficiently to what the bottom is saying." Tony Hayward X-CEO BP
"Being GREEN isn't easy." Kermit

http://www.youtube.com/watch?v=hpiIWMWWVco

http://virtualpipeline.spaces.live.com

 

[dik]

It's pretty flat ground... and I was thinking of imputting the grade elevations at the four corners of the segment considered. I tried a net search and ended up spending an hour looking through trash.

Dik

 

[gbam]

dik - I have coded excel to compute ex&fill approximate quantities. The way I did this was to use an avereage depth (+ or -) between XSECs. Then I coded my typical section area using the average depth. This leads to an avereage end volume calculation. It is not difficult just code it yourself.

 

[MEM1]

Not the most user friendly, but give this a try.

 

[dik]

Thanks, I'll take a look at it this evening... I was able to finally get common formulae for the calculations.

Dik

 

[dik]

MEM1:
I haven't checked the data for a 'cranked' baseline, but for a straight one, it's bang on...

I wish I could give two stars. A little 'clunky' but an excellent spreadsheet.

Thanks, Dik

 

[MEM1]

Like I said, not very user friendly. I didn't develop it. It came from an engineer with the Kansas NRCS. The guy is a genious with spreadsheets. An easier user interface would be nice. For furture reference, NRCS is a great place to find spreadsheets and engineering applications. Just google NRCS Spreadsheets and you will find a ton.

 

[gbam]

Dik I Star'd him for ya. That spreadsheet is nice and I found it pretty straight forward. I may compare it to the INROADS data for a simple section when I find the time. I personally am a hydro guy so I don't usually need more than a trap section (Channels) and that is easily coded in excel using average depths and a typical section.

 

[dik]

I did three sections with pline in AutoCAD and got the areas. Calculated the volume based on distances and found it calculates using average section area and not frustum. That is, L*(A1+A2)/2 and not L/3(A1+A2+sqrt(A1*A2)) For areas that are not dramatically different, average area is OK. Other than that, calculated values were same as ones I calculated.

Dik