How to find multiple peaks in a data set

Dear all,

I have posted this thread on a previous forum a while back, but it seems to have been left unaswered so I wanted to see if I obtained any answers from this forum. I have read the rules of forum and realise this is somewhat frowned upon, but seeing as no answers have been provided elsewhere I felt it worth re-posting

I have an excel spreadsheet of ground reaction forces (step by step) from a running trial sampled at 200hz for 1 minute. The data in the column increases from a baseline value up to a peak value (eg 1700N) when the foot contacts the ground and then reduces back down to the baseline value. There are probably around 178 peaks over 1200 cells that I wish to identify and then average. I have tried a macro that identified a value every kth cell and then average this but, my data is dynamic, therefore the peaks do not always occure at a constant time, although they seem to be between every 60-70th cell. Is there any formulas that can be put into a macro or the conditional formatting tab that will allow me to easily identify the peaks and then place them into another column to average.

kind regards
will

A sample of your data would not go amiss!

Can you post a worksheet showning how your data is arranged, and where the peaks are?

hi Marcol,

no problem
edited_ vGRF_data.xlsx

Hi Marcol,

I have just tried this on all of the data (full minutes worth) rather than just the seconds worth of data I sent you and it does seemed to have worked. Thank you, I dont really understand the formula, but its helped a lot. Do you think if I smoothed the data, with a running average and manipulated the B7>1000 part of the formula then I would get a better result as at times I get 2 peaks close together, when really I just need the higher value of the 2 peaks

regards
will

What formula did you try?

Hi,

Used the first formula.
example_template_finding_peaks.xlsx

Hi Marcol,

I have smoothed the data, and used the first formula. It has worked really well. Your help has been much appreciated

regards
Will