×
INTELLIGENT WORK FORUMS
FOR ENGINEERING PROFESSIONALS

Log In

Come Join Us!

Are you an
Engineering professional?
Join Eng-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Eng-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Jobs

Cut and Fill
2

Cut and Fill

Cut and Fill

(OP)
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.

RE: Cut and Fill

(OP)
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

RE: Cut and Fill

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.    

RE: Cut and Fill

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

Dik

RE: Cut and Fill

(OP)
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

RE: Cut and Fill

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.

RE: Cut and Fill

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.

RE: Cut and Fill

(OP)
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

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Eng-Tips Forums free from inappropriate posts.
The Eng-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Eng-Tips forums is a member-only feature.

Click Here to join Eng-Tips and talk with other members!


Resources