"Intelligence is not the ability to store information, but to know where to find it." - Albert Einstein (1879 - 1955)

Objective

The purpose of this assignment is use your spreadsheet to develop a feasible detention pond design for the site assigned to your group in lab.

The purpose of this part of the assignment is to estimate the cost of cut-and-fill and the detention pond volume. This application will support your designs for the detention pond project. 

You must hand in the coversheet the assignment your work for Part 1 and printouts of your spreadsheet for Parts 2 and 3. Also, submit your Excel file for Parts 2 and 3 to Canvas.

Part 1. Table 1 list the original elevations for an underdeveloped site. Table 2 gives the desired elevation of the developed site. Compute the cut-and-fill earthwork cost for this site. Assume the on-site cost is $2.50/yd³ and the off-site cost is $5.00/yd³ for fill and $3.00/yd³ for the cut.

Table 1. Original Elevations for 50' x 50' grid.

Table 2. Proposed Elevations for 50' x 50' grid.

Part 2: Use the spreadsheet we developed in the lab to analyze a detention pond design. Click here for details on methodology. Use the following data above to check your spreadsheet. Print out only the sheets containing: the proposed topographic model, compaction elevations, cut-and-fill calculations, and pond volume.

Part 3: After checking your spreadsheet against the data above, use it to develop a feasible detention pond design for the site assigned to your group in the lab. This will give each group an opportunity to develop several alternative designs for each site as part of their overall detention pond design report. For our design purposes, a feasible design is a pond that can retain at least 50,000 gallons and minimizes earthwork costs.

Part 4: Use the information on the syllabus to compute your current grade in the class.

Requirements

Lastly, a web page describing the CIVL 1112 homework policy is available. Read it before you turn in this assignment. You will be graded throughout the semester according to the policy outlined in it.

Coersheet for homework

This website was originally developed by Charles Camp for CIVL 1112.
This site is maintained by the Department of Civil Engineering at the University of Memphis.
Your comments and questions are welcomed.