Extracting useful info from test data

[TonyN]

Hi everyone,

I'm doing a considerable amount of mechanical testing for my graduat
work, and am having a heck of a time sorting through the data to ge
meaningful results. I have about 10,000 data points, which represen
about 400 cycles of tests. I want to extract the cycle number, and plo
the minimum and maximum loads encountered in each cycle with respect t
the cycle number. Can anyone give me a hand? Thanks in advance, Ton

 

[Frank Kabel]

Hi
not quite sure but try creating a pivot table based on your source data
and create a pivot chart. See

http://www.cpearson.com/excel/pivots.htm
http://peltiertech.com/Excel/Pivots/pivotstart.htm
http://www.contextures.com/xlPivot02.html

 

[ross]

Tony,
i think you could do lots of stuff, but if your not maga good with
excel, then it might be just a quick to do a bit of mannual leg work,
and save the bother.
I dont know what your data set looks like, but i will asumm that it is
in one long list, and has the floowing in in colums
test number, score (where score has the max and min value)
there is priobal;y some other stuff as well, but whatever..
so use the sort tool from the data menu and sort the data on test
number, then use tghe sub totals list, and subtotal but test number,
at each subtotal you can use the =max(B2:b40) and =min(b2:b40)
formulas to get t max and mn or tha subtotal

ran... easy stto mor stuff trr god in te at menu for you

good luck pal
rosscoe