Is Excel capable of this operation?

asezas OK so i had 'fun' and created 2 Lambda functions: wAvg and dThresh. 

my wAvg will take an array and apply an N-pt moving average.  It can accept an weighting array for custom weighted windows or just an N for # of pts and will size that window in the beginning and end to output an array length = to the input array. 

dThresh will take an array and apply a dynamic threshold meaning the threshold value will drift based on the signal or the dPath you give it and return FALSE for values < dThresh.

I did this thinking these might be helpful to this problem, but when I came back to look at your data and sample sheet I don't think so and noticed:

a) the graph you sent doesn't match this set of data so those letters don't line up with the named sections on the spreadsheet (no big deal i guess) and

b) you have a column with your visual output which is what I assume you hope the formula to produce.  BUT those sections don't make sense based on your "rules".  

c) To me, it seems like you just want to find any local maximas that 'plateau' for at least x points on the 'response' data (and maybe the same on the 'Energy' data too).

would love to help on this but still trying to understand exactly what you need.