+ Reply to Thread
Results 1 to 6 of 6

Measuring pulse times

Hybrid View

  1. #1
    Registered User
    Join Date
    02-02-2010
    Location
    london, england
    MS-Off Ver
    Excel 2003
    Posts
    5

    Measuring pulse times

    Hello,

    The data I am going though is velocity and looks like:

    __/\___/\___/\___/\___/\___/\___/\___/\___/\___/\___/\___/\___/\___/\__

    Every spike is a piston moving forward (technically there are down spikes between each of these too, but I was worried about ascii formatting so I left them out). The time from 0 - 0 velocity should be the length of time it takes the piston to move forward.

    I am hoping to find a way to measure the length of time of each spike and then take the average. So some kind of formula that would look a 5% change from nominal then when it's within 5% of nominal again (to account for noise in our data).

    Essentially this is to determine the length of time it takes to complete motion.

    Thanks for the help!
    Last edited by bhowell; 09-28-2010 at 07:29 AM.

  2. #2
    Forum Expert martindwilson's Avatar
    Join Date
    06-23-2007
    Location
    London,England
    MS-Off Ver
    office 97 ,2007
    Posts
    19,320

    Re: Measuring pulse times

    how about you specify the formula then we try to apply it to excel?
    "Unless otherwise stated all my comments are directed at OP"

    Mojito connoisseur and now happily retired
    where does code go ?
    look here
    how to insert code

    how to enter array formula

    why use -- in sumproduct
    recommended reading
    wiki Mojito

    how to say no convincingly

    most important thing you need
    Martin Wilson: SPV
    and RSMBC

  3. #3
    Registered User
    Join Date
    02-02-2010
    Location
    london, england
    MS-Off Ver
    Excel 2003
    Posts
    5

    Re: Measuring pulse times

    I'm not sure I follow you. The formula is what I am looking for here.

    I would like to measure the time from the start of the pulse to the end of the pulse, then take the average of those times for all the pulses in my data set.

  4. #4
    Forum Guru
    Join Date
    08-05-2004
    Location
    NJ
    MS-Off Ver
    365
    Posts
    13,582

    Re: Measuring pulse times

    You gave us a visual representation. Do you have some actual numeric data that we can look at?
    ChemistB
    My 2?

    substitute commas with semi-colons if your region settings requires
    Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
    If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)

    Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble

  5. #5
    Registered User
    Join Date
    02-02-2010
    Location
    london, england
    MS-Off Ver
    Excel 2003
    Posts
    5

    Re: Measuring pulse times

    What I did was position measurements of a piston that I then derived into speed. The file I am working with is over 100mB, we were sampling it at 2000Hz for about a 5 minute period. I don't see a feasible way to get the data here, I'm also worried my company might see it as a leak of information if I did (IT tends to watch everything, especially large uploads and are quite cautious)

    The measurements though are generally zero until the piston moves (with some slight "static" from the sensor noise, this is why I suggested waiting until it's moved beyond a certain value, say 1mm/s out of its max: 100mm/s). When it does move it accelerates from 0 to its max value, at halfway it reaches its peak, then decelerates down to zero.

    Essentially a formula that would look for the speed to reach 1mm/s, then find when it crosses past 1mm/s on its slowdown. Then to calculate the time (x-axis) it took to do so.

    This happens 25-100 times within our sample data and I want to calculate the average of all of those time.

    The data again will look something like:

    ---(zero)---(spike up to 100mm/s /\)---(zero)---(spike down to -100mm/s \/)---

    Repeated throughout the data.

    Let me know if you need any more clarification.

    Thanks!

  6. #6
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2010, 2019
    Posts
    40,689

    Re: Measuring pulse times

    I think a matched filter is the way to do this.

    Identify (manually) the signature of a dozen or so of each type of event. Average and normalize the values to create a filter kernel for each, and then use a formula to convolve the kernel against the data. Set a threshold at a value that captures most or all events with few or no false positives.

    An example is attached that finds the spikes in an EKG.
    Attached Files Attached Files
    Last edited by shg; 09-29-2010 at 03:44 PM.
    Entia non sunt multiplicanda sine necessitate

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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