The non uniform flow in open channels spreadsheets and spreadsheet packages in this category include the following:
Scroll down for descriptions of these spreadsheets in either U.S. units or S.I. units.
This Excel spreadsheet bundle has all of the U.S. unit spreadsheet packages in this category, including hydraulic jump calculations, critical depth and critical slope calculations, M-1 surface profiles, and calculations of non-uniform flow surface profiles.
This Excel spreadsheet bundle has all of the S.I. unit spreadsheet packages in this category, including hydraulic jump calculations, critical depth and critical slope calculations, M-1 surface profiles, and calculations of non-uniform flow surface profiles.
These Excel spreadsheets make hydraulic jump calculations for a horizontal, rectangular channel. This includes calculation of the sequent (downstream) depth for specified initial (upstream) depth, flow rate, and channel width (or flow rate per unit width). The length of the jump, the head loss across the jump, and the jump efficiency can also be calculated, as well as the flow rate under a sluice gate. Information on the type of jump to be expected for several ranges of initial Froude number is also provided. These spreadsheets use U.S. units
These Excel spreadsheets make hydraulic jump calculations for a horizontal, rectangular channel. This includes calculation of the sequent (downstream) depth for specified initial (upstream) depth, flow rate, and channel width (or flow rate per unit width). The length of the jump, the head loss across the jump, and the jump efficiency can also be calculated, as well as the flow rate under a sluice gate. Information on the type of jump to be expected for several ranges of initial Froude number is also provided. These spreadsheets use S.I. units
These Excel spreadsheets calculate the surface profile for the M-1 category of non uniform open channel flow in either a rectangular channel or a trapezoidal channel using U.S. units.
These Excel spreadsheets calculate the surface profile for the M-1 category of non uniform open channel flow in either a rectangular channel or a trapezoidal channel using S.I. units.
These Excel spreadsheets calculate the critical depth and critical slope for either a rectangular channel or a trapezoidal channel, with specified flow rate, Manning roughness coefficient, and channel size. The calculations are in U.S. units.
These spreadsheets calculate the critical depth and critical slope for either a rectangular or a trapezoidal channel with specified flow rate, Manning roughness coefficient, and channel size. Calculations are in S.I. units.
These Excel spreadsheets will calculate the surface profile for any of the six possible non uniform flow configurations for flow on mild or steep slopes, in a rectangular trapezoidal, or triangular channel. Calculations are in U.S. units.
These Excel spreadsheets will calculate the surface profile for any of the six possible non uniform flow configurations for flow on mild or steep slopes, in a rectangular, trapezoidal or triangular channel. Calculations are in S.I. units.
This Excel spreadsheet will calculate the surface profile for any of the six possible non uniform flow configurations for flow on mild or steep slopes, in a triangular channel. Calculations are in U.S. units.
This Excel spreadsheet will calculate the surface profile for any of the six possible non uniform flow configurations for flow on mild or steep slopes, in a triangularl channel. Calculations are in S.I units.