Sharp Crested Weir Flow Calculator Spreadsheets

What is a Sharp‑Crested Weir

A sharp‑crested weir is a thin‑plate flow‑measuring structure with a precisely formed crest over which water flows. The crest edge is kept sharp—typically with a thickness of just a few millimetres—so that the water jet (the nappe) springs cleanly away from the plate. This creates a predictable relationship between the upstream water level (the head) and the discharge.

Sharp‑crested weirs are widely used in:

- Irrigation channels
- Wastewater treatment works
- SuDS flow‑control structures
- Laboratory flumes and hydraulic models
- Industrial discharge monitoring

Their popularity comes from:

- High measurement accuracy
- Simple construction and installation
- Well‑established hydraulic theory
- Suitability for low to moderate flows
- Ease of calibration and maintenance

Sharp‑crested weirs can be rectangular, V‑notch, or trapezoidal, but the defining feature is always the thin, sharp crest that produces a clean, aerated nappe.

Common Sharp‑Crested Weir Design Methods

Designing a sharp‑crested weir involves ensuring the crest geometry, approach flow, and hydraulic assumptions are correct so that flow measurements remain accurate and repeatable.

Widely used design methods include:

- Standard Sharp‑Crested Weir Equation — The general discharge equation is: Q = Cd * L * H^(3/2)
- Discharge Coefficient Selection — Coefficients depend on crest sharpness, plate thickness, approach velocity, and weir type. Typical values range from 0.60 to 0.65 for rectangular sharp‑crested weirs.
- Velocity of Approach Correction — When upstream velocity is significant, a correction is applied to ensure the measured head reflects true energy conditions.
- Free‑Flow (Unsubmerged) Conditions — Designers check the downstream water level to ensure the nappe remains aerated and unsubmerged. Submergence reduces accuracy and requires correction factors.
- Head Measurement Location — The head is measured upstream at a distance of 3–4 times the maximum head to avoid velocity effects and turbulence.
- Crest Geometry Requirements — The crest must be sharp, smooth, and aligned perpendicular to the flow. Plate thickness and bevel angle directly influence the discharge coefficient.

Each method must consider channel width, sediment load, debris potential, flow variability, and maintenance access to ensure long‑term reliability.

Why Use a Sharp‑Crested Weir Design Spreadsheet?

A sharp‑crested weir design spreadsheet helps engineers manage the many variables involved in calculating flow, checking submergence, and ensuring the weir meets hydraulic requirements. Because flow depends on head, crest length, discharge coefficient, and approach conditions, a spreadsheet ensures calculations are accurate, consistent, and easy to update.

Key benefits include:

- Automated calculation of flow for any head and crest geometry
- Quick comparison of rectangular, V‑notch, and trapezoidal sharp‑crested weirs
- Built‑in checks for submergence, approach velocity, and crest sharpness
- Scenario testing for different flow ranges or channel geometries
- Clear documentation for calibration, monitoring, and regulatory reporting

For hydrologists, drainage engineers, and environmental regulators, a spreadsheet becomes a practical tool that improves accuracy, reduces design time, and ensures reliable long‑term flow measurement.

The CivilWeb Sharp Crested Weir Calculator Spreadsheet Suite includes all the following individual sheets;

V Notch Weir Calculator Spreadsheet

Rectangular Weir Calculator Excel Spreadsheet

Suppressed Rectangular Weir Calculator Spreadsheet

Trapezoidal Weir Calculator Spreadsheet

Parshall Flume Calculator Spreadsheet

Get Started Today

Save hours of repetitive calculation time. Whether you’re working on a major project or a small renovation, this tool will give you clarity, accuracy, and confidence.

Buy the CivilWeb Sharp Crested Weir Flow Calculator Spreadsheets Suite now for only $49.99.