# Homework Help: Volume of cut and fill in excel

1. May 8, 2012

### median27

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.

Problem:
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.

File size:
76 KB
Views:
1,399