+ Reply to Thread
Results 1 to 2 of 2

Finding Multiple peaks, and duration of peaks

  1. #1
    Registered User
    Join Date
    03-10-2015
    Location
    egg
    MS-Off Ver
    2004
    Posts
    1

    Finding Multiple peaks, and duration of peaks

    Hello,

    I'm trying to find a way to get all of the peak values, without have to manually find them. I'm not sure if this is possible, I've seen example online that are similar but I can't seem to make it work for this application.

    And if we have super users out in the wild, Trying to find the duration of the event when is goes up from 0, then when is come back to 0, and how many mi, sec's that is.

    Thank you,

    Josh
    Attached Files Attached Files

  2. #2
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP, 2007, 2024
    Posts
    16,382

    Re: Finding Multiple peaks, and duration of peaks

    I believe there are many different strategies and algorithms for processing these kind of signals, and I am far from an expert in the field. You might spend some time researching "signal processing" and "signal processing in excel" or similar search terms to get a feel for the information that is available.

    Easiest approach might be a simple "when is signal above a threshold" value. This kind of approach might look something like:

    1) Choose threshold (0.1 or 0.05 or whatever you deem appropriate).
    2) Identify points that are above the threshold value. In Excel, this could be as simple as =$B2>D$1 (if threshold is entered into D1). then copy down. This will yield a column of TRUE/FALSE values. TRUE values mark the peaks.
    3) To identify start and end of peak, you would then analyze this column looking for the points where column D changes from FALSE to TRUE (marks start of peak) and where D changes from TRUE to FALSE (marks end of peak). This could be as simple as =D3=D2 (maybe entered in E3) then copy down. Most results in this column will be TRUE, with the occasional FALSE value marking the start and end of peaks.
    4) To aid in searching for start and end of peak values, a "counting column" could be added that counts the FALSE values in column E. =IF(E3,F2,F2+1) will increment for each FALSE value, giving a column of 0, 1, 2, 3, 4, ....
    5) An INDEX(column A, MATCH()) combination could then be used to find the start and end of peaks in column F and return the corresponding time from column A. These could then be used to find duration of peak.

    Let us know if you need specific help with any of these steps.
    Quote Originally Posted by shg
    Mathematics is the native language of the natural world. Just trying to become literate.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. How do I identify multiple max peaks in data set
    By jon2316 in forum Excel General
    Replies: 7
    Last Post: 10-08-2014, 05:42 AM
  2. Finding Elevation Peaks?
    By eric_f in forum Excel General
    Replies: 1
    Last Post: 04-18-2013, 10:53 PM
  3. [SOLVED] How to find multiple peaks in a data set
    By willevans in forum Excel General
    Replies: 9
    Last Post: 03-29-2012, 06:37 AM
  4. Replies: 1
    Last Post: 11-02-2009, 09:00 AM
  5. [SOLVED] Finding major peaks and troughs
    By zxaris@rocketmail.com in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-22-2006, 12:40 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1