| Author |
 Topic  |
|
|
Grottenolm85
Germany
Posts |
 Posted - 06/20/2008 : 10:56:13 AM
|
Origin Version (7.5):
Operating System:WinXP Pro SP2
Hello,
I ran a couple of tests on some polymers, and now i want to visualize the results.
Each test fills one worksheet with 9 columns and around 14000 rows of data.
One col is the pressure(col 6:0MPa-400MPa), another one the specific volume(col 7:0,9g/cm^3-0,65g/cm^3).
What I need are the values of the specific volume for 20, 40, 60,...,320MPa(pressure) in a new sheet. If possible in a row, not in a column.
It should be obvious that i am not to eager to search 14000 values about 24 times manually. So, is there a possibility to write a skript that refines the data?
I saw something like that in the "Analyse"-toolbar, but i am not sure how to use it. C++ or java-skripts didn't work.
If someone has an ideas, i would be be glad to hear them.
|
|
|
Shirley_GZ
China
Posts |
Posted - 06/23/2008 : 03:56:34 AM
|
Hi Grottenolm,
I suppose that colA is the pressure (6:0MPa-400MPa), highlight the two columns and choose Analysis: Extract Worksheet Data to bring up the Extract Worksheet Data dialog box, designate the row number from 1 to 320 and choose a output worksheet in the blank of Put Into Worksheet, and then write the below script into the If box:
Mod(col[A](i),20)==0
Click Do it, the data you need will be extracted into a new worksheet.
If you want to output the data in a row, click Edit: Transpose to exchange row and column.
Shirley
Originlab Technical Service Team |
 |
|
| |
Topic |
|
|
|
Filter worksheet?