Hi, i am looking some advice to make a script in VBA.
I need to get some values summed in time frames that range from 5 seconds to 60 seconds from cells that are updating all the time with 10 to 50 updates per second.
Lets say that in 5 seconds I get the values 1 2 3 4 5 1 2 1 2 1 2. I would need a way to sum these values in a 5 second window and to get the value of 24. In the end of 5 seconds the process will restart to sum the next values in the next 5 seconds.
I would like to choose the time window above the cell I am getting the sums. Say the sums are running in C4 and in C3 I would put 5sec or 15sec to get sums of 5 second loops or 15 second loops.
An example in video
https://youtu.be/QF112qcya2o
Is this possible to do in VBA with good performance?
Many thanks
Jonas
I need to get some values summed in time frames that range from 5 seconds to 60 seconds from cells that are updating all the time with 10 to 50 updates per second.
Lets say that in 5 seconds I get the values 1 2 3 4 5 1 2 1 2 1 2. I would need a way to sum these values in a 5 second window and to get the value of 24. In the end of 5 seconds the process will restart to sum the next values in the next 5 seconds.
I would like to choose the time window above the cell I am getting the sums. Say the sums are running in C4 and in C3 I would put 5sec or 15sec to get sums of 5 second loops or 15 second loops.
An example in video
https://youtu.be/QF112qcya2o
Is this possible to do in VBA with good performance?
Many thanks
Jonas
