Rectangular Weir Calculator Excel Spreadsheet

What is a Rectangular Weir?

A rectangular weir is a flat‑crested flow‑measuring structure with a horizontal opening across which water flows. As water passes over the crest, the height of water above the crest—known as the head—is used to calculate discharge using standard hydraulic equations. Because of their simple geometry and predictable performance, rectangular weirs are widely used in irrigation channels, treatment works, rivers, and industrial flow‑measurement systems.

Two main types are used:

• Contracted rectangular weirs — The nappe (water jet) contracts on the sides because the crest is narrower than the channel.
• Broad‑crested or suppressed rectangular weirs — The crest spans the full channel width, reducing side contraction effects.

Rectangular weirs are valued for:

• Straightforward construction and calibration
• Reliable performance across a wide range of flows
• Suitability for both low and moderate discharges
• Compatibility with sediment‑laden or debris‑prone flows

They remain a standard tool in hydrology, SuDS design, wastewater engineering, and environmental monitoring.

Common Rectangular Weir Design Methods

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

Common design methods include:

• Sharp‑Crested Weir Theory — The standard discharge equation for a rectangular weir is: Q = Cd * L * H^(3/2)
• Discharge Coefficient Selection — Engineers select a coefficient based on crest sharpness, approach velocity, and whether the weir is contracted or suppressed. Typical values range from 0.60 to 0.65 for sharp‑crested weirs.
• Velocity of Approach Correction — When upstream velocity is significant, a correction is applied to ensure accurate head measurement.
• Free‑Flow (Unsubmerged) Conditions — The downstream water level must be low enough to avoid submergence. Designers check the submergence ratio to maintain accuracy.
• 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 and Material — Crest thickness, sharpness, and alignment affect the discharge coefficient and long‑term performance.

Each method must consider channel width, sediment load, debris potential, flow variability, and maintenance access to ensure the weir performs reliably.

How Does the CivilWeb Rectangular Weir Calculator Excel Spreadsheet Work?

The spreadsheet uses the above flow rate formulas to calculate the flow rate over the weir. The user simply inputs the weir crest dimensions, the width of channel, width of the weir, head of water over the weir and the depth of downstream water. A useful diagram is also provided within the spreadsheet to make it clear exactly what the inputs are referring to.

The spreadsheet then calculates whether the flow over the weir is fully contracted, partially contracted or not contracted. Then the Kindsvater-Shen equation or Francis formula depending on the conditions is used to determine the flow rate over the weir.

Why Use a Rectangular Weir Design Spreadsheet?

A rectangular 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.

Benefits include:

• Automated calculation of flow for any head and crest length
• Quick comparison of contracted vs. partially contracted weir performance
• 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.

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 Rectangular Weir Calculator Excel Spreadsheet now for only £19.99.

Or alternatively big savings are available with our Sharp Crested Weir Flow Calculator Spreadsheets bundle. Get all 5 weir flow analysis spreadsheets for only £29.99.