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
Username:
 Password:
Save Password
Forgot your Password? | Admin Options

 All Forums
 Origin Forum
 Origin Forum
 "Solver" in Origin?		  New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic Lock Topic Edit Topic Delete Topic New Topic Reply to Topic

P_Saddy

Germany
2 Posts
Posted - 12/02/2014 :  05:53:05 AM  Show Profile  Edit Topic  Reply with Quote  View user's IP address  Delete Topic
Origin Ver. and Service Release (Select Help-->About Origin): Origin 9.1G 64-bit
Operating System: Windows 8.1

Dear Members,

I have a problem with the equation below:



All terms are known. Im only looking for a value of the variable [L]. In Excel I can determine this value by the "Solver". But it doesnt work fine.
Is there any equivalent in Origin, which corresponds to the solver in Excel? The second question is how to calculate it? (Which calculation operations I have to do?) Is it possible to calculate it by columns in a table? When more information are needed please let me know!

Thanks for your help

Best Regards

P_Saddy
Edited by - P_Saddy on 12/04/2014 02:31:37 AM

AmandaLu

439 Posts
Posted - 12/11/2014 :  01:31:42 AM  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
Hi P_Saddy,

You can transform the equation to

and then use levelcrossing to find out the point where Y = 0.

Suppose your [L] falls in a range from a to b.

1. First create two new columns, column A and B for example. Fill the first column with some evenly spaced data from a to b, data(a, b, interval).

2. Use the Set Column Values dialog to fill the second column with formula


See here for details about Set Column Value:
http://www.originlab.com/doc/Origin-Help/Wks-SetColVal-QuickStart

3. Enter levelcrossing -d; in the Script Window to bring up the levelcrossing dialog. Get the X value at level Y=0. That's the [L] value you want.

Please refer to the levelcrossing document for details:
http://www.originlab.com/doc/X-Function/ref/levelcrossing

Thanks,
Amanda
Edited by - AmandaLu on 12/11/2014 01:35:08 AM
Go to Top of Page

P_Saddy

Germany
2 Posts
Posted - 12/12/2014 :  03:07:04 AM  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
Hello Amanda,

that looks good. I'm going to try it.

Thanks for your help and for the very good illustration.

Best Regards

P_Saddy
Go to Top of Page
  Previous Topic Topic Next Topic Lock Topic Edit Topic Delete Topic New Topic Reply to Topic
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
The Origin Forum © 2020 Originlab Corporation Go To Top Of Page
Snitz Forums 2000