Calculating flow rates for a dam

[ANRGIS]

Hey Survey123 community,

I think I have some pulldata functionality with some calculations defining a dams flow rate given a user-defined elevation and user-defined gate statuses; there are 3 gates (2-20' and 1-35'). Am having trouble making this 'simple.' I was currently thinking about pulling the Q total in based elevation and subtract values from how many 20' gates are closed and if the 35' gate is closed using another 'two' pull data rows. Any other ideas out there?

[Anonymous User]

There are weir formulas based on weir type, width of the weir, height of water over the weir and the various coefficients to determine the flow.