1. Limited time only! Sign up for a free 30min personal tutor trial with Chegg Tutors
    Dismiss Notice
Dismiss Notice
Join Physics Forums Today!
The friendliest, high quality science and math community on the planet! Everyone who loves science is here!

Homework Help: Volume of cut and fill in excel

  1. May 8, 2012 #1
    1. The problem statement, all variables and given/known data
    I need someone who could help me to find my mistake with this excel project(kindly see my attachment) about cut and fill. It will be submitted within this week and still I can't locate my mistake. I don't know if it is in the computation, in the figure or about my comprehension with the problem. Thanks in advance.

    Given the cross section level notes of existing ground line at station 100+020 and station 100+040. Plot the cross section of cut and fill of each station. Determine the volume of cut and fill using (a) end area method; (b) prismoidal formula; (c) with prismoidal correction. The roadbed is 100.00m and width equal to 11m. The sideslope for cut is 1:1 and 1.5:1 for fill.

    3. The attempt at a solution
    Kindly see my attachment.
    I've erased the plotting of the cross section because the complete file exceeds the allowable kilobyte.

    Attached Files:

  2. jcsd
Share this great discussion with others via Reddit, Google+, Twitter, or Facebook

Can you offer guidance or do you also need help?
Draft saved Draft deleted