An Excel spreadsheet template that can be downloaded to make hydraulic jump calculations for open channel flow is available through this article. The Excel formulas in the template calculate Froude number and head loss, along with other hydraulic jump parameters.

- slide 1 of 4
### Background on the Hydraulic Jump in Open Channel Flow

A hydraulic jump will occur whenever there is supercritical flow taking place in an open channel with a subcritical slope. The hydraulic jump provides an abrupt adjustment from supercritical to subcritical flow. This is necessary because the subcritical slope cannot sustain a supercritical flow. The diagram at the right shows a physical open channel flow situation that would give rise to a hydraulic jump. For more background on hydraulic jumps see the article, "Open Channel Flow Basics - Hydraulic Jump Calculations." For additional information on subcritical and supercritical open channel flow, see the article, "Open Channel Flow Basics 2 - Supercritical Flow." For an Excel spreadsheet template that can be downloaded to do hydraulic jump calculations, read on in this article.

- slide 2 of 4
### Equations for Hydraulic Jump Calculations

For flow in a rectangular open channel, with known channel width (b), upstream (supercritical) depth of flow (y

_{1}), and volumetric flow rate (Q), the downstream (subcritical) depth of flow (y_{2}) can be calculated from the following equations:y

_{2}/y_{1}= (1/2)[-1 + (1 + 8Fr_{1}^{2})^{1/2}] ; V_{1}= Q/(by_{1}) ; and Fr_{1}= V_{1}/(y_{1}g)^{1/2}.The upstream velocity, V

_{1}and upstream Froude number, Fr_{1}, need to be calculated first, using the last two equations, then the downstream depth of flow, y_{2}can be calculated using the first equation. After y_{2}is calculated, the downstream velocity of flow, V_{2}, can be calculated from V_{2}= Q/(by_{2}).There will always be frictional head loss across a hydraulic jump, due to the turbulence in the jump. That frictional head loss, h

_{L}, can be calculated from the equation:h

_{L}= y_{1}+ V_{1}^{2}/2g - (y_{2}+ V_{2}^{2}/2g).An Excel spreadsheet template for making the above open channel flow calculations is presented and discussed in the next section.

- slide 3 of 4
### Hydraulic Jump Calculations Using Excel Formulas

Excel spreadsheet templates can be used to easily make hydraulic jump calculations for open channel flow with the equations discussed above. Once the Excel formulas are entered, you simply need to enter the required input values and the Excel spreadsheet will make the calculations. The Excel template at the left is set up the make these calculations.

This Excel spreadsheet template requires input values for the upstream depth of flow, y

_{1}, the channel width, b, and the volumetric flow rate through the channel, Q. Then the Excel formulas that have been entered into the spreadsheet template will calculate the upstream velocity, V_{1}, the upstream Froude number, Fr_{1}, the downstream depth of flow, y_{2}, and the downstream velocity, V_{2}.Click here to download the Excel spreadsheet template shown at the left.

- slide 4 of 4
### References and Image Credits

References for further information:

1. Bengtson, Harlan H.

*Open Channel Flow II - Hydraulic Jumps and Supercritical and Nonuniform Flow -*An online, continuing education course for PDH credit.2. Munson, B. R., Young, D. F., & Okiishi, T. H.,

*Fundamentals of Fluid Mechanics,*4^{th}Ed., New York: John Wiley and Sons, Inc, 2002.3. Chow, V. T.,

*Open Channel Hydraulics,*New York: McGraw-Hill, 1959.Image Credits:

1. Wikipedia Commons, StAnthonyFalls apron

2. Hydraulic Jump Diagram - drawn by H. Bengtson