How to use it
There are three discrete steps:
- First, go to the first sheet named "Step 1" and fill the channel's geometry. If you have an unknown value, the sheet will calculate it.
- Then, go to "Step 2" and fill the channel's depth. Automatically, the sheet will calculate some necessary parameters, such as wetted perimeter, hydraulic radius and others.
- Finally, go to "Step 3" and fill the values in the green cells. There are two useful tables that will help you filling the Manning's parameter, as well as the dynamic viscosity of water. If you have correctly filled all the input values, this sheet will calculate the desired values of the flow (discharge, velocity and type of flow).
The workbook can be opened with Excel 2007 or newer. Please, enable macros before using it.