Page 1 of 2 1 2 LastLast
Results 1 to 10 of 19

Thread: How to automatically apply fixed set of calculations to data of variable column and r

  1. #1

    How to automatically apply fixed set of calculations to data of variable column and r

    Register for a FREE account, and/
    or Log in to avoid these ads!


    I have raw data that ha variable set of rows and columns with a unique time and ID (see attached file). I need to apply a fixed set of calculations to the data but doing manually is huge pain. How would I automate this process.


    Attached Files Attached Files

  2. #2
    Acolyte jaslake's Avatar
    Join Date
    Aug 2011
    mineral city oh usa
    Excel Version

    Welcome to the Forum!!!

    Please include a Link to other Forums on which you've posted this's a Forum requirement.

    I count three thus far...

  3. #3
    I have a neat solution.
    Unfortunately you are a cross poster.
    Here is a teaser:

  4. #4

    Sorry for cross posting and I hope someone can still help with my data analysis for a biomedical research study that I am working on.



  5. #5
    Excel 2010
    What I would like to see is just the raw data
    and a text description of the desired result(s).
    If you just want the SNR, then a couple of new formulas can be written
    and all of your present formulas can be eliminated.
    Maybe my charts can illuminate this.

  6. #6

    If you plot signal versus time for 1 row of data you will see a peak in the signal (Columns CE). I need to calculate a drift correction factor (Column), average, standard deviation, min, max, median, etc of the first 7 milliseconds of the background, the top of the signal peak and the time period when the signal decays (Columns DGO, DQY, EA:EI).

    After this I apply the drift correction factor in column DG to every row of the data as the signal decreased 58% over the 20 period of the experiment. I then repeat the same calculations on the right side the data (IQ:JE).



  7. #7
    You recorded data at an interval of 70 seconds, at best.
    To do an analysis at the millisecond range, 10000s of data points
    at that continuous rate are needed.

  8. #8
    Sorry, that was a typo on my part. The time is in seconds.

  9. #9
    That helps a lot.
    Now you need only an additional ~100 data points,
    at one second intervals,
    around record 4 (1:45:23) and record 19 (15:54:40)

  10. #10

    This is data from a quality control measurement which was taken before and after sample measurements. The first step is to obtain calculations of the background and signal. The pivot table and cool charts you made will need to be applied to 1000s of lines of data which vary in length of time and the no. of lines per sample id.



Page 1 of 2 1 2 LastLast

Posting Permissions

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