Hi guys, I am new to VBA and just wondering if someone could point me towards the right direction for achiving this task:
The goal is to find out workable time periods (continuous "blocks" of times) based on criteria including wave height and wave periods, as certain requirements of wave height and wave periods need to be reached for working condition.
I have a time series with 3 columns of data: time (in 3-hour increments), wave height, wave period:
How would I get VBA to start counting downwards, and when the streak of satisfactory criteria ends, stop counting, record the counts and start counting again from where it stopped?
Thanks in advance
The goal is to find out workable time periods (continuous "blocks" of times) based on criteria including wave height and wave periods, as certain requirements of wave height and wave periods need to be reached for working condition.
I have a time series with 3 columns of data: time (in 3-hour increments), wave height, wave period:
How would I get VBA to start counting downwards, and when the streak of satisfactory criteria ends, stop counting, record the counts and start counting again from where it stopped?
Thanks in advance
