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
 Find intersection points of multiple sheets

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
mitsous Posted - 02/09/2016 : 09:50:07 AM
Origin Ver. 9 and Service Release
Operating System: Windows 7 x64

Hello,

I have a workbook with 150 sheets. Each sheet has 2 columns of x and y variables. For each sheet i need to find a unique intersection point with x axis and put this to a new workbook with 1 sheet. So, the final book should have 1 column and 150 lines with each point. Also, because my data are noisy it would be convenient to set a range i.e search for the intersection point between 1.9 and 2.2. I saw that levelcrossing function should do it but after many tries i can't build a working loop. Any ideas?

Thanks,
3   L A T E S T    R E P L I E S    (Newest First)
cpyang Posted - 02/13/2016 : 10:55:26 PM
Please download the demo for the current version and try.

CP
mitsous Posted - 02/12/2016 : 07:27:50 AM
Thanks for the answer.

Unfortunately this code is not working.


I have Origin 9.0
cpyang Posted - 02/10/2016 : 01:32:33 AM
The following code assumes input book is Book1 and output into another book named Book2

//assume data in book1 and result in book2
dataset xx;
int ncrossing;
int nout;
range xout=[book2]1!1;

range myBook=[book1];
nout = 1;
for(int ns=1; ns<=myBook.nLayers;ns++)
{
	range mydata=[book1]$(ns)!(1,2);//assume XY
	levelcrossing iy:=mydata nc:=nn oy:=xx;
	if(nn>0) //has at least one crossing, get the first
	{
		xout[nout]=xx[1];
		nout++;
	}
}



give it a try, if does not work, maybe your Origin is too old, try the demo Origin 2016.

CP

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