Hi,


Everyday I export an excel file and it comes out with thousands and thousands of data points. It is from the equipment I use. From when I turn the equipment to when I turn it off, it takes 5 measurements a second. So this is why I have thousands and thousands of data points.


In one column I have the time, the second column I have the current speed at that precise time, and in the third column I have the distance.


What i want to work out is if I pick a certain speed the equipment is at, I can then (from the formatting) work at how many efforts at that speed, the time spent at that speed and how much distance has been covered at that speed also.


For it too be classed as a certain a speed, there has to be a minimum of 5 data points in a row of that same speed. How can I on excel, work out this?


I therefore need to find out: how long it spends at that speed, how many efforts at that speed, distance completed at that speed etc (an effort or the speed is only class at being in that threshold when it lasts for 5 data points).


I want too be able to pick any value. If its equal to or above the certain value (for 5 data points in a row or more), it will class this as an effort and add up the distance covered during this also.


The value I want to chose is a velocity of 3.8. Anything equal to or below 3.8 and lasts for a minimum of 5 data points I want it too tell me how many efforts of 3.8 or above there was. the duration of each effort.


As well as this I would like it to tell me the same sort of results for everything below 3.8. This will give me a idea.


I have attached the book. I dont want it to come out as a table if possible.Book3.xlsx

I hope this makes sense.