The Manning Equation
In this Spreadsheets across the Curriculum activity, students investigate the relationship between discharge and culvert diameter, given various culvert materials and slope angles. To begin, students are given the culvert diameter, material and gradient, and use the Manning equation to determine velocity and then discharge. Next, students determine culvert size to convey a specified discharge. These activities allow students to graph the relationship between culvert diameter and discharge.
- Create and work with spreadsheets in Excel.
- Create graphs within Excel.
- Gain experience with foward modeling.
- Gain experience with solving an inverse problem using the iterative process.
- Gain experience working with power functions and fractional exponents.
- Gain experience with manipulating algebraic equations.
- Use the Manning equation to solve for culvert radius and gradient.
- Graphically examine the relationship of culvert diameter to velocity and discharge.
Context for Use
Description and Teaching Materials
PowerPoint SSAC2005.TC401.PB1.1-student version (PowerPoint 99kB May2 07)
The module is a PowerPoint presentation with embedded spreadsheets.
If the embedded spreadsheets are not visible, save the PowerPoint file to disk and open it from there.
This PowerPoint file is the student version of the module. An instructor version is available by request. The instructor version includes the completed spreadsheet. Send your request to Len Vacher (firstname.lastname@example.org) by filling out and submitting the Instructor Module Request Form (Acrobat (PDF) 91kB Aug20 12).