Hi, I am having trouble finding a way to automate a large number of tedious calculations. I have a Kestrel wind speed logger set to automatically log every 30 seconds. I need to be able to take the data and report several things.
A: Total amount of time the wind was greater than 0m/s
B: Total amount of time the wind was greater than 3.57632m/s
C: Total number of times the wind exceeded and remained above 3.57632m/s for at least 5 minutes consecutively.
I have been able to calculate A: and B:, but trying to get C: automatically has been problematic. I am trying to count "gusts" that last 5 minutes or longer, and I am not interested in gusts lasting less than five minutes. Various iterations of COUNT and SUM functions are just giving me totals for the column.
Also of importance; I have a Master Summary workbook to show the results of A, B, and C for each log, as each log has a unique identifier. Is there a way to arrange the formulas so that the Master Summary workbook can pull the data from new Kestrel Logs as they are uploaded with a minimal amount of copy/paste?
Thank you,
Ryan
Bookmarks