Saving data in excel

[Med_Support]

andersem
Saving data in excel
August 12, 2014, 02:18:08 pm

I am working with a program that has 25 trials, therefore giving 25 latencies in K:. If I save the output into excel rather than word, it doesnt give each trial its own cell, making it difficult to find the average of the 25 trials. Is there a way to do this instead of hand calculating? Thanks again for the great support!

[Med_Support]

Gary Bamberger
Re: Saving data in excel
August 12, 2014, 03:05:58 pm

 It sounds like you are using the Annotated Data File (Format 1) for MED-PC IV.  By default this puts 5 data elements per line with a row number:

0:  5.100  7.100  10.100  5.100  7.100
5:  0.200  12.100  3.100  5.100  5.100

When you open this space delimited file in Excel you end up with 5 rows of 5 numbers and are forced to move the numbers around so that you can do your calculation.  There are a couple of solutions that you could try to eliminate this problem.

1) Do the calculation in MED-PC IV.  This can be done with brute force {(K(0) + K(1) + … + K(24)) / 25} or by adding up the numbers as they are Recorded {SET K(I) = S, Z = Z + S;} and then dividing the value in Z by 25 before the program ends.

2) Use the Stripped with Variable Identification (Format 4).  All data ends up in one vertical line.  This is a little more difficult to know where the data for your K array starts and stops.

3) Use MED-PC to Excel.  This program will read the data file you select and transfer it into Excel for you.  If you use a Row Profile, then the data all ends up in one row, but it has labels so that you can easily find the beginning and end of your data.  If you use a Table Profile, then you can have it place the data for the K array anywhere you want in the Excel spreadsheet.

I hope that this information helps.
Gary

[Author]

Posts