Friday, 13 May 2011

Last updated: 30/09/2017, 1 min read

Open Channel Flow - Trapezoidal Cross Section


Here is another freeware tool that I developed in Excel. With this workbook, you can calculate the discharge, the velocity, the Reynolds number and the type of flow (laminar, transitional, turbulent) of an open channel with a trapezoidal cross-section. The Manning's equation is used for the calculations.

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. Two useful tables will help you fill 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.

Read also

Did you like this post? If yes, then share it with your friends. Thank you!


Mechanical Engineer (Ph.D. cand.), M.Sc. Cranfield University, Dipl.-Ing. Aristotle University, Thessaloniki - Greece.
Communication: e-mail, Facebook, Twitter, Google+ and Linkedin. More info