striped line
Department of Civil Engineering
Computational Assignment #13
set cell vertical height

 

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

Objective

This assignment aims to use your spreadsheet to develop a feasible detention pond design for the site assigned to your group in the lab.

You must submit the cover sheet for the assignment, your calculation on engineering paper for Part 1, and printouts of your spreadsheet for Parts 2 and 3, and your calculation for Part 4. Also, submit your spreadsheets for Part 2 to Canvas. You must follow the Excel format.

This part of the assignment aims to estimate the cut-and-fill cost and the detention pond's volume. This application will support your designs for the detention pond project

Part 1. Table 1 lists 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/yd3, the off-site cost is $5.00/yd3 for fill, and $3.00/yd3 for the cut.

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

1 3 4 5
1 64 67 69 71 67
2 66 69 70 71 69
3 67 70 71 72 68
4 63 66 68 68 66

 

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

1 3 4 5
1 66 67 68 69 69
2 66 67 68 69 69
3 66 67 68 69 69
4 66 67 68 69 69

 

Part 2. Use the cut-and-fill spreadsheet we developed in class. It allows users to enter the row and column spacing of the elevation grid, the original elevations at each gridline intersection, and the proposed elevation. Also, your spreadsheet should graph the original and the proposed elevations. Click here for details on the methodology.

Use the following data 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 with the data given above, use your spreadsheet to develop a feasible detention pond design on 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 defined as a pond that can retain at least 50,000 gallons and minimizes the 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.

 

 

Cover sheet 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.

striped line
Department of Civil Engineering | 104 Engineering Science Bldg |Memphis, TN 38152 | Phone: 901/678-2746 | Fax: 901/678-3026 | Last updated: 04/29/2025