| Author |
 Topic  |
|
|
gusmo
USA
Posts |
 Posted - 12/31/2004 : 10:21:10 AM
|
hello,
i'm new to origin and trying to figure out how to extract specific rows from a worksheet and place them into a new worksheet. for example, each trial of my experiment has 16 parts (with each part occupying a single row). and each experiment has >20 trials. further, each experiment ends up in an origin file with the number of rows equal to 16*number of trials. does origin have a built in tool that would allow me to extract discontinuous rows that correspond to the same part of each trial and place them in a new worksheet? for example, a way to extract every 17th row of a worksheet for the first part of the experiment. any help is much appreciated. thank you. nikkudesu@hotmail.com |
|
|
Mike Buess
USA
3037 Posts |
Posted - 12/31/2004 : 11:47:26 AM
|
Use Analysis->Extract Worksheet Data. To extract the nth row from each record use mod(i,16)==n for the condition (if statement). Examples,
Extract row 1, 17, 33, ...
if: mod(i,16)==1
Extract row 3, 19, 35, ...
if: mod(i,16)==3
...Rows 16, 32, 48, etc., are handled differently because there is no remainder when dividing those numbers by 16. The condition for those rows is mod(i,16)==0.
Mike Buess
Origin WebRing Member
Edited by - Mike Buess on 01/01/2005 2:30:30 PM |
 |
|
| |
Topic |
|
|
|
help with data extraction