These Excel spreadsheets make open channel flow measurement calculations with U.S. or S.I. units for each of the following:
Scroll down for descriptions of these spreadsheets in either U.S. units or S.I. units.
This Excel spreadsheet bundle includes the V-Notch Weir, Rectangular Weir, Sutro Weir, Broad-Crested Weir, and Parshall Flume spreadsheets described below. This spreadsheet bundle uses U.S. units.
This Excel spreadsheet bundle includes the V-Notch Weir, Rectangular Weir, Sutro Weir, Broad-Crested Weir, and Parshall Flume spreadsheets described below. This spreadsheet bundle uses S.I. units.
This group of Excel spreadsheets includes all of the spreadsheets in the Open Channel Flow Measurement Bundle (described below) and in the Manning Equation Excel Spreadsheet Bundle (spreadsheets for Q and V calculation, normal depth calculation, hydraulic radius calculator, and trapezoidal channel with two side slopes.). Calculations are in U.S. units.
This group of Excel spreadsheets includes all of the spreadsheets in the Open Channel Flow Measurement Bundle (described below) and in the Manning Equation - Open Channel Flow Spreadsheet Bundle (spreadsheets for Q and V calculation, normal depth calculation, hydraulic radius calculator, and trapezoidal channel with two side slopes.). 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 Open Channel Flow Measurement and Manning Equation 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 Excel spreadsheet package includes the spreadsheet described below for V-notch weir calculations and the one described below for rectangular weir calculations. This spreadsheet uses U.S. units.
This Excel spreadsheet package includes the spreadsheet described below for V-notch weir calculations and the one described below for rectangular weir calculations. This spreadsheet uses S.I. units
These Excel spreadsheets calculate the flow rate over a V-notch weir with a 90 degree notch angle (either fully contracted or partially contracted). A worksheet is also available for fully contracted flow through a notch angle of 20 to 100 degrees. Flow calculations are based on input for weir and channel dimensions, the head over the weir, and the notch angle if it is other than 90 degrees. A check on fully contracted flow conditions is included for flow over non-90 degree notches. Calculations are in U.S. units.
These Excel spreadsheets calculate the flow rate over a V-notch weir with a 90 degree notch angle (either fully contracted or partially contracted). A worksheet is also available for flow over a fully contracted notch angle between 20 and 100 degrees. Flow calculations are based on input for weir and channel dimensions, the head over the weir, and the notch angle, if it is other than 90 degrees. Checks on the "fully contracted" requirements are included. Calculations are in S.I. units.
This Excel spreadsheet will calculate flow rate through a Parshall flume based on head measurement(s) for both free flow and submerged flow. Calculations are in U.S. units.
This Excel spreadsheet calculates flow rate through a Parshall flume for either free flow or submerged flow, based on head measurement(s). Calculations are in S.I. units.
This Excel spreadsheet includes calculation of flow rate for flow over a sharp crested rectangular weir, either a suppressed rectangular weir or a contracted rectangular weir. Calculations are included for the simpler form of the equations for both the suppressed and contracted weirs as well as the use of the Kinsvater Carter equation for all rectangular, sharp crested weir configurations. This spreadsheet uses S.I. units.
This Excel spreadsheet includes calculation of flow rate for flow over a sharp crested rectangular weir, either a suppressed rectangular weir or a contracted rectangular weir. Calculations are included for the simpler form of the equations for both the suppressed and contracted weirs as well as the use of the Kinsvater Carter equation for all rectangular, sharp crested weir configurations. This spreadsheet uses U.S. units.
A Sutro weir, also known as a proportional weir, produces flow over the weir that is proportional to the head over the weir. This spreadsheet carries out Sutro weir design calculations and calculates flow rate over a sutro weir for a specified sutro weir. Calculations are in U.S. units.
A Sutro weir, also known as a proportional weir, produces flow over the weir that is proportional to the head over the weir. This spreadsheet carries out Sutro weir design calculations and calculates flow rate over a sutro weir for a specified sutro weir. Calculations are in metric units.
This Excel Spreadsheet calculates the flow rate over a broad-crested weir for either free flow or submerged flow for user specified values for weir length, weir height, weir coefficient, upstream depth of flow, and downstream depth of flow for the submerged flow calculation. Also the minimum required upstream head is calculated for free flow and for submerged flow. Calculations are in U.S. units
This Excel Spreadsheet calculates the flow rate over a broad-crested weir for either free flow or submerged flow for user specified values for weir length, weir height, weir coefficient, upstream depth of flow, and downstream depth of flow for the submerged flow calculation. Also the minimum required upstream head is calculated for free flow and for submerged flow. Calculations are in S.I. units