This spreadsheet has kindly been developed by Dr. Hamish Biggs, of NIWA, for the calculation of discharge in open channels using surface velocity methods.
The contents of the spreadsheet are aligned with the requirements of the NEMS: - Open Channel Flow Measurement.
A description of how the area associated with the measurement is calculated is provided at the bottom of the “Velocity and Discharge” tab and under the “Notes” heading of the “Cross Section” tab.
The worksheets are locked so that so that only cells where people are supposed to input data can be modified (in GREEN).
If you wish to utilise this tool please download the workbook to your own device and rename the workbook before unlocking and editing it (if necessary).