| T O P I C R E V I E W |
| P_Saddy |
Posted - 12/02/2014 : 05:53:05 AM
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. I’m only looking for a value of the variable [L]. In Excel I can determine this value by the "Solver". But it doesn’t 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 |
| 2 L A T E S T R E P L I E S (Newest First) |
| P_Saddy |
Posted - 12/12/2014 : 03:07:04 AM
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 |
| AmandaLu |
Posted - 12/11/2014 : 01:31:42 AM
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 |
|
|
