| T O P I C R E V I E W |
| gusmo |
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 |
| 1 L A T E S T R E P L I E S (Newest First) |
| Mike Buess |
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 |
|
|
