Hey everyone,

I am not too familiar with excel functions and was wondering if anyone could help me with my data.

I am using a one of a kind machine that studies an individuals pain based on their pain ratings. The machine monitors the temperature of a thermode placed on someone's arm based on a pain rating that they give. Everyone's pain rating is different and the machine tries to keep their rating at 20% of what they could tolerate. The data that I end up getting ends up forming a sine wave with fluctuating maximum, intermediate, and minimum points.

A sample of someone's Temperature data taken every 1.5 seconds may be:

33
33.4
34
34.7
35.4
36
36.6
37.3
37.9
38.5
39.1
39.7
40.3
40.9
41.5
42.1
42.7
43.3
43.9
44.5
45.1
45.7
46.3
46.9
47.4
47.5
46.9
46.5
46
45.8
46.2
46.5
46.9
47.3
47.5
47.7
47.7
47.3
46.8
46.7
47.1
47.4
47.7
47.9
48.1
47.9
47.4
46.9
46.6
47
47.4
47.7
48.1
48.4
48.6
48.8
48.5
48.1
47.6
47.1
47.5
47.8
48.1
48.5
48.7
48.8
48.7
48.3
47.7
47.2
47.3
47.6
48
48.3
48.6
48.8
48.9
48.5
48
47.5
47.1
47.4
47.7
48
48.4
48.6
48.8
48.9
48.7
48.3
47.7
47.2
47.5
47.8
48.2
48.5
48.7
48.8
48.6
48.2
47.6
47.1
47.1
47.5
47.7
48.1
48.4
48.7
48.7
48.2
47.8
47.4
47.8
48.2
48.5
48.7
48.8
48.4
48
47.5
47.2
47.5
47.9
48.2
48.4

If you were to plot this in a graph you can see the maximum and minimum values don't always stay the same.

I was wondering if it were possible to write some sort of macro that could pull each a maximum, intermediate, and minumum value from each separate wave and place it in a specific cell for later analysis?

If this seems too confusing, please let me know and I will help clarify.