Includes Excel Manning equation open channel flow calculator spreadsheets to make a variety of open channel flow calculations with the Manning Equation in U.S. or S.I. units, using Manning roughness and bottom slope of the channel:
Scroll down for more details about these spreadsheets in U.S. or S.I. units
This Manning equation Excel spreadsheet bundle has i) the Hydraulic Radius Calculator, ii) Q and V for Open Channel Flow, iii) Normal Depth for Open Channel Flow Spreadsheets and iv) trapezoidal channel with two side slopes, as described below. The spreadsheets in this bundle all use U.S. units.
This Excel spreadsheet bundle has i) the Hydraulic Radius Calculator, ii) Q and V for Open Channel Flow, iii) Normal Depth for Open Channel Flow, and iv) trapezoidal channel with two side slopes Spreadsheets as described below. The spreadsheets in this bundle all use S.I. units.
This group of Excel spreadsheets includes all of the spreadsheets in the Manning Equation Excel Spreadsheet Bundle (described above) and in the Open Channel Flow Measurement Bundle (V-notch Weir, Rectangular Weir, Sutro Weir, Broad-Crested Weir, and Parshall Flume spreadsheets). Calculations are in U.S. units.
This group of Excel spreadsheets includes all of the spreadsheets in the Manning Equation Open Channel Flow Spreadsheet Bundle (described above) and in the Open Channel Flow Measurement Bundle (V-notch Weir, Rectangular Weir, Sutro Weir, Broad-Crested Weir, and Parshall Flume spreadsheets). Calculations are in S.I. units.
This group of Excel spreadsheets includes all of the spreadsheets in the Manning Equation and Open Channel Flow Meas Bundle (described above); and those in the NonUnif and Critical Open Chan Flow Bundle (spreadsheets for hydraulic jump calculations, critical depth and critical slope calculations, M-1 surface profiles, and calculations of non-uniform flow surface profiles). Calculations are in U.S. units.
This group of Excel spreadsheets includes all of the spreadsheets in the Manning Equation and Open Channel Flow Measurement Bundle (described above); and those in the NonUnif and Critical Open Chan Flow Bundle (spreadsheets for hydraulic jump calculations, critical depth and critical slope calculations, M-1 surface profiles, and calculations of non-uniform flow surface profiles). Calculations are in S.I. units.
This set of Excel spreadsheets makes it easy to calculate the hydraulic radius for open channel flow in a triangular, rectangular, or trapezoidal channel, or in a circular pipe flowing partially full (either less than half or more than half full). These calculations are in U.S. units.
FREE DOWNLOAD! This Excel spreadsheet calculates the volumetric flow rate and average velocity for open channel flow in a triangular channel for specified channel side slope, flow depth, Manning roughness coefficient, and channel bottom slope. The calculations are in either U.S. or S.I. units.
This package includes the spreadsheets for calculating flow rate and average velocity for open channel flow in a rectangular, trapezoidal, or triangular channel, with specified channel bottom slope, Manning roughness coefficient, and appropriate channel size/shape parameters. These spreadsheets use U.S. units.
These normal depth open channel flow Excel Spreadsheets include those for calculating normal depth in rectangular, trapezoidal, or triangular channels. The calculations use U.S. units.
These hydraulic radius calculator Excel spreadsheets makes it easy to calculate the hydraulic radius for open channel flow in a triangular, rectangular, or trapezoidal channel, or in a circular pipe flowing partially full (either less than half or more than half full). These calculations are in S.I. units.
This package includes the spreadsheets for calculating flow rate and average velocity for open channel flow in a rectangular, trapezoidal, or triangular channel, with specified channel bottom slope, Manning roughness coefficient, and appropriate channel size/shape parameters. These spreadsheets use S.I. units.
This set of Excel Spreadsheets includes those for calculating normal depth in rectangular, trapezoidal, or triangular channels. The calculations use S.I. units.
This Excel spreadsheet template can be used to determine the Manning roughness coefficient for a natural channel based on a description of various aspects of the channel, such as its irregularity, cross section variations, the effect of obstructions, the effect of vegetation, and degree of meander. This spreadsheet is based on a method developed by W.L Cowan in 1956. Since the Manning roughness coefficient is dimensionless, the n value determined with this spreadsheet can be used for Manning equation calculations in either U.S. or S.I. units.
These Excel spreadsheets will calculate the hydraulic radius for a trapezoidal flume with unequal side slopes, that is with different side slopes on its two sides. There are also worksheets to calculate the flow rate and average velocity for specified Manning roughness coefficient, bottom slope, depth of flow, and side slopes, and to calculate normal depth for a specified flow rate. Calculations are in U.S. units.
These Excel spreadsheets will calculate the hydraulic radius for a trapezoidal flume with unequal side slopes, that is with different side slopes on its two sides. There are also worksheets to calculate the flow rate and average velocity for specified Manning roughness coefficient, bottom slope, depth of flow, and side slopes, and to calculate normal depth for a specified flow rate. Calculations are in S.I. units.