+ Reply to Thread
Results 1 to 3 of 3

Parsing and calculating data for timed trials according to criteria?

  1. #1
    Registered User
    Join Date
    06-03-2015
    Location
    California, USA
    MS-Off Ver
    2010
    Posts
    1

    Parsing and calculating data for timed trials according to criteria?

    I've been racking my brain for a week, and I need some help

    For a university experiment, we are collecting data on how much pressure subjects can exert on a force plate, up until the point of fatigue. Data will be captured in a CSV file and we want to do analysis/reporting in Excel.

    Data collection is continuous, but due to individual differences, the duration and pressure patterns in a session will be highly variable.

    All rows will need to be preserved for record-keeping, but low and no-effort rows will need to be excluded from calculations.
    Attachment 399011
    Columns of interest are:
    • Milliseconds - in intervals of 500, to signify half-seconds
    • Pressure - pressure exerted on the force plate
    • Target - arbitrary pressure goal, set by administrator. May be changed mid-session
    • Percentage - (Pressure/Target)*100

    Where I need help

    1. What formula would permit individual session start and end rows to be identified within a data file according to the criteria, where 0>PRESSURE<20 for duration of time => 2 minutes (This would be derived from a difference in MILLISECONDS, I get that--where I really need help is a formula to automatically parse the data, rather than requiring manual gap identification.

    2. Within a valid session (As defined by the above criteria), how could I calculate something like MAX duration, where the MAX pressure is identified, and then we calculate how long that pressure was continuously sustained - I think this one gets glitchy, using MAX, since as I understand it MAX can only be a value that appears once in the data set. Seems like this might be something related to SUMIF, but I can't figure it out past that idea.

    3. Ideally, these sessions would be graphed so the pressure can be visually compared to the target, over time. That one *should* be easy, but the aspiration was to use a macro for standard reporting. Can Macros parse data, calculate, and graph the results, even with a highly variable data set?

    4. I don't know VB, so I was anticipating recording the Macro the very old fashioned way, of typing in cells, setting up charts, etc. Can it be done? If not, are there starter snippets that I can use, or what rudimentary sites do you recommend?

    fwiw, I've fiddled with Pivot tables and outlining, but it doesn't seem applicable. You can view the datasheet to see where I'm at with the modeling.

    THANK YOU!
    Attached Files Attached Files

  2. #2
    Forum Moderator
    Join Date
    01-21-2014
    Location
    St. Joseph, Illinois U.S.A.
    MS-Off Ver
    Office 365 v 2403
    Posts
    13,396

    Re: Parsing and calculating data for timed trials according to criteria?

    Not sure I've understood correctly. Does this do what you want?

  3. #3
    Forum Expert José Augusto's Avatar
    Join Date
    10-29-2014
    Location
    Portugal
    MS-Off Ver
    2013-2016
    Posts
    3,329

    Re: Parsing and calculating data for timed trials according to criteria?

    Follow my interpretation of what you want
    Attached Files Attached Files

+ 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. Binomial trials
    By jameselmore in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 06-20-2013, 11:55 AM
  2. Webscrape, Timed Macro and Archiving Data
    By VBANoob in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-18-2012, 06:13 PM
  3. Timed refresh of input data
    By albatross32 in forum Excel General
    Replies: 1
    Last Post: 09-13-2011, 12:33 AM
  4. automated timed data lookup and storing
    By adroc67 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-12-2008, 01:36 PM
  5. Capturing timed Data with RSLinx
    By mwiggins367 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-08-2005, 11:41 AM

Tags for this Thread

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