CTC 462 Lab3 (Manning's Equation-Spreadsheets)

1. Develop a spreadsheet to find the capacity of a trapezoidal ditch. The user must be able to input slope, roughness coefficient, water height, incoming slope, and outgoing slope..
2. Solve problem 3 in chapter 3 by using the template you developed in 1.
3. Develop a spreadsheet to find the normal depth of a trapezoidal ditch. The user must be able to input slope, roughness coefficient, flow rate, incoming slope, and outgoing slope. Hint: Try using tools, solver to find exact answer.
4. Turn in your spreadsheets on disk along with your report.

SUNYIT Home | Baran's Classes | ISET Home | E-Mail S. J. Baran