Hi all
I'm working with stream flow discharge data which has a discharge value associated with the date-time each reading was taken. I am trying to determine what the average and median number of hours the stream is above a certain discharge level. I would also like to know the number of events that the stream is above a certain discharge. Note: an event is the total time that the stream discharge is elevated above a certain level. This information will be used to determine how many times stream flow is high enough to allow fish to swim upstream past a weir.
In the spreadsheet attached I have two columns titled 'adequate fish passage' and 'unimpeded fish passage', with the respective discharge values in a reference cell above the columns. I have been able to identify which readings are above the respective values (filter for value 1 to identify), but cannot determine the descriptive stats I'm chasing. There aren't too many events in the example attached so I could do it manually, but other streams have thousands of events in the dataset.
Any help on this would be greatly appreciated.
Kind regards,
Trent
Bookmarks