The Origin Forum
File Exchange
Try Origin for Free
The Origin Forum
Home | Profile | Register | Active Topics | Members | Search | FAQ | Send File to Tech support
 All Forums
 Origin Forum
 Origin Forum
 Extract data from graph to data sheet

Note: You must be registered in order to post a reply.
To register, click here. Registration is FREE!

Screensize:
UserName:
Password:
Anti-Spam Code:
Format Mode:
Format: BoldItalicizedUnderlineStrikethrough Align LeftCenteredAlign Right Horizontal Rule Insert HyperlinkUpload FileInsert Image Insert CodeInsert QuoteInsert List
   
Message:

* HTML is OFF
* Forum Code is ON
Smilies
Smile [:)] Big Smile [:D] Cool [8D] Blush [:I]
Tongue [:P] Evil [):] Wink [;)] Clown [:o)]
Black Eye [B)] Eight Ball [8] Frown [:(] Shy [8)]
Shocked [:0] Angry [:(!] Dead [xx(] Sleepy [|)]
Kisses [:X] Approve [^] Disapprove [V] Question [?]

 
Check here to subscribe to this topic.
   

T O P I C    R E V I E W
Pansell Posted - 06/25/2014 : 10:36:31 AM
Hello
I’m working on eye movement recording signals. I would like to extract multiple data marker positions from a graph to a data sheet using the regional data selector tool. I’m only interested in the positions of the markers since I will calculate signal drift over time in separate segments of the recording. If I have the X and Y position of the two markers for each segment this will be good enough. Does anyone know if this feature is available in Origin? See figure with three pairs of markers. I would like to manually mark all segments in the recording and then extract all data at once. Since I’m not a programmer it is not just to write a script… I’m an optometrist
Thanks for any advice
Tony



Origin Ver. 8.0.63.988 and Service Release 6:
Operating System: W7
4   L A T E S T    R E P L I E S    (Newest First)
Pansell Posted - 07/03/2014 : 2:40:01 PM
Here is the solution to get all positions of the data markers to a separate data sheet (thanks Roberto!)

1.click with the right button on the blue strip of the graph window with the markers
2.select 'Show the Script Panel'
3.copy all the command lines written (below) and paste them on the bottom half of the script panel
4.Press the button 'Execute All'
DONE!

dataset mksB,mksE;
mks ob:=mksB oe:=mksE sort:=0;
%B=%C; %A=xof(%C);
win -n data; %R=%H;
work -v X1; work -v Y1;
work -v X2; work -v Y2;
loop(ii,1,mksB.getsize())
{ %R_X1[ii]=%A[mksB[ii]]; %R_Y1[ii]=%B[mksB[ii]];
%R_X2[ii]=%A[mksE[ii]]; %R_Y2[ii]=%B[mksE[ii]];};
lkb0221 Posted - 06/25/2014 : 3:35:07 PM
Hi,

So you only want corresponding Y values at those specific X positions?
Then you can try Analysis: Mathematics: Interpolate/Extrapolate Y from X... tool.
http://www.originlab.com/doc/Origin-Help/Math-Inter-Extrapoltate-YfromX

There is a tricky way to do this, actually.
1). Select Gadget: Interpolate
2). In Interpolate/Extrapolate Options tab, Set Number of Points be 2, Fit Limits To be Data Points.
3). OK to apply the setting.
4). Move the yellow box to your first segment, click the right triangle button and New Output
5). Move the ROI to the next segment. and output again.
A new worksheet will be generated.

Zheng
OriginLab
Pansell Posted - 06/25/2014 : 11:08:50 AM
Thanks for quick reply, sorry if I was unclear.
I'm not interested in the curve itself for this analysis. I want the cordinates of the data markers (X,Y). Something like:

mks1-a:X=12,42;Y=-8,11
mks1-b:X=13,32;Y=-10,71

Then I can calculate the change of Y over X.

AND I would love to mark all segments in the recording manually first and then transfer the marker-coordinates to a data sheet.
lkb0221 Posted - 06/25/2014 : 10:51:32 AM
Hi,

1). Use data markers to mark the first segments.
2). Select the curve, right click and select Copy Range.
3). Open a blank worksheet, select the 1st cell, right click and paste.
4). Move the data marker to select the 2nd range you want.
5). Repeat 2~3.
6). Do the same for the 3rd segment.

Zheng
OriginLab

The Origin Forum © 2020 Originlab Corporation Go To Top Of Page
Snitz Forums 2000