V-notch weirs are an effective way to measure water flow in a wide range of situations. We published a paper on its correct use, and created a free Excel function to simplify the process.
Many of Splashback’s clients work with water discharge as part of their environmental monitoring. These measurements of flow and discharge are often taken from V-notch weirs. Splashback’s team works closely with its clients to provide them the analytical tools to help get the most out of their data. Water flow adds the required context to water quality measurements in many circumstances. Splashback has recently added an Excel function to assist in calculating the discharge from a V-notch weir. We have here provided a summary of the workings of the V-notch weir and the underlying mathematics of the equation used in the Excel function to accompany this release. It is our hope that this article will assist in the accurate use of V-notch weirs as well as give a ‘on-site’ context to those using the Excel function in the workplace.
With the free Splashback add-in for Excel, you can calculate water discharge from a V-notch weir in just a few clicks:

Download the paper
V-notch weir was added to Splashback as the result of a user request. We love suggestions and feedback, and appreciate your help in shaping this platform.
If you have any ideas for functions or features then please let us know and we’ll see what we can do!