Help With Advance Excel Macro (Fluctuating Sine Wave Values)

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.

Thanks for the input, but the values aren't quite what I was looking for.

Ill attach a sample file that I have analyzed manually.

There are cycles that each person goes through. A cycle would be represent by one sine wave. Each cycle has a certain stage.
Stage 1) Machine reaches high temp (RED)
Stage 2) Person Rates High Pain (YELLOW)
Stage 3) Machine reaches low temp (BLUE)
Stage 4) Person Rates Low Pain (ORANGE)

I have color coded each high temp/pain, low temp/pain, and guesstimated intermediates for each cycle then recorded them in a chart on the right.

I know its very complicated. I don't know if it is possible to write a macro to move values from the raw data into a chart like I have added on the right since the values for each person tested are always changing.

Let me know what you think!
Thanks

bump*************