Ogee Spillway Designxls — Better Fix

| | Purpose | |------------|--------------| | Hydrology Input | Design head, maximum head, upstream slope (vertical, 3:1, etc.), crest length | | Crest Coordinate Generator | Automatically computes x, y from 0 to 4×( H_d ) using WES equation | | Discharge Table | Interpolates ( C ) from H/H_d ratio; checks against maximum expected head | | Pressure Check | Estimates piezometric head at each x; flags potential negative pressures | | Energy Dissipator Sizing | Computes tailwater required for hydraulic jump or flip bucket trajectory | | Plot | Instant scatter plot of crest profile; compares with original nappe curve |

= Variable discharge coefficient (which changes based on approach depth, upstream face slope, and submergence effects). ogee spillway designxls better

This public link is valid for 7 days and shares a thread, including any personal information you added. This link or copies made by others cannot be deleted. If you share with third parties, their policies apply. Can’t copy the link right now. Try again later. If you share with third parties, their policies apply

| Row | Description | Formula / Logic | | :--- | :--- | :--- | | | Unit Discharge ($q$) | =B3/B4 | | 11 | Design Head ($H_d$) | See Note 1 below | | 12 | Approach Velocity ($v_a$) | =B3/(B4*(B5-B6)) (Approximate) | | 13 | Velocity Head ($h_v$) | =(B12^2)/(2*9.81) | | 14 | Total Head ($H_0$) | =B11 + B13 | | Row | Description | Formula / Logic