sliding periodic average?

[tdxloki]

Excellers,

I have a set of data from a cycling computer. The computer records my heart rate every second over the course of a given bike ride. So, I have two data columns, one is time and one is heart rate.

I would like to use excel to find any/all of the 3 minute intervals during the ride when my heart rate averaged 160 beats per minute or greater. How do I accomplish this analysis? Seems like I need a sliding window, 3 minutes wide. The average calculated from each window, then post results of 160 or above. As an added complication, I would also like to identify the time interval that a given average came from.

Thanks for any help or suggestions.

James

[nrage21]

If it is not private info, could you post your cycling data set? I want to see how your date column is formatted, and how you are separating the different bike rides or days from one another as well as the duration of each cycle (15mins; 30 mins, et al).

[tdxloki]

I'd be happy to post the data but the files are at home and I am at work.

I can tell you how the data is formatted though.

The computer saves the data as a comma separated file. Each column has a name heading in the first row. The time is formatted as a decimal fraction of minutes and recorded every second (so there can be many time points for even a short ride). The heart rate is in another column and is a two or three digit whole number associated with a given time point. The computer also saves a bunch of other data: power, speed, and cadence, that appear in other columns.

[tdxloki]

nrage21,

Here is a text file in csv format.

I have figured that I can use 'moving average' from the Data analysis menu and then filter the results to show only those averages above a given heart rate. Its a hack. If you have a more elegant solution that would be great.

James