Friday, 13 May 2011



Open Channel Flow - Trapezoidal Cross Section


Introduction



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 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. 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).


Downloads



Download

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!



Categories:


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