LabVIEW

cancel
Showing results for 
Search instead for 
Did you mean: 

Labview equivalent of Excel's "SOLVER"

Solved!
Go to solution

I've learned how to solve non-linear equations in Excel using Solver.  Is there something equivalent in LabView?

 

I have an equation:

T = 1 / (A + B*lnX + C*lnX^2 + D*lnX^5)

 

Where T is temperature and X is resistance of a thermistor.  

 

Now I'd like to (iteratively) solve for X.

 

I've looked around the mathematical functions and haven't found anything that sounds like what I'm looking for.

 

Thanks in advance.

 

- Paul

0 Kudos
Message 1 of 5
(3,925 Views)
Solution
Accepted by topic author Pablo1961
0 Kudos
Message 2 of 5
(3,906 Views)

you can solve it using formula node

on your Labview BD, right click>>Programming>>Structures>>Formula Node

 

see here

 

 

 

or;

Programming»Structures»MathScript Node



Thank you & Best regards
syrpimp

=======================================================
“You must continue to gain expertise, but avoid thinking like an expert." -Denis Waitley
0 Kudos
Message 3 of 5
(3,892 Views)

I want the reverse... to compute expected resistance at a given temperature.  

0 Kudos
Message 4 of 5
(3,832 Views)

THANKS!, that's exactly what I needed.  The documentation was a little sparse but that VI did exactly what I needed.  It wouldn't converge when I started at 1, but it did when I started at 100,000, for whatever reason.

 

Once I expressed my equation with a zero, on the left, I entered:

1 / ( 0.00112766979300187 + 0.000234444184128213* ln(c) +  8.47692130592308E-08 * ln(c)^3 + 1.17512193579615E-11*ln(c)^5 ) - 273.15 -  25

into the formula text (where the 25 is the input variable and is concatenated into the formula string each time).

 

And that worked.

0 Kudos
Message 5 of 5
(3,824 Views)