Subscribe Bookmark RSS Feed

Numerical solver add-in

JesperJohansen

Community Trekker

Joined:

Apr 15, 2013

I am looking for a script or add-in which can adjust the values i a single column, recalculate the entire sheet, evaluate some criterion and repeat until some criterion is met. In short I need something which will do for me what the Excel solver add-in does for me in Excel.

Does anyone know of such a tool for or function i JMP?

BR
Jesper
1 ACCEPTED SOLUTION

Accepted Solutions
Solution

Hi JesperJohansen,

You might be able to use the Nonlinear platform with a formula column. The solving based on a criterion would all happen in the platform, but then you can save estimates back to the data table column.

Best,

Michael

Michael Crotty
Sr Statistical Writer
JMP Development
4 REPLIES
Solution

Hi JesperJohansen,

You might be able to use the Nonlinear platform with a formula column. The solving based on a criterion would all happen in the platform, but then you can save estimates back to the data table column.

Best,

Michael

Michael Crotty
Sr Statistical Writer
JMP Development
Jeff_Perkinson

Community Manager

Joined:

Jun 23, 2011

The optimizer in the Profiler could help here as well.

In this case you would embed your formula in a column in the data table and then use the Profiler to find optimal settings of the input value based on your desirability criteria.

If you can describe your scenario more completely and/or share some non-proprietary data that will help us point you in the best direction.

Thanks!

-Jeff

-Jeff
JesperJohansen

Community Trekker

Joined:

Apr 15, 2013

It would be hard to share data of any kind since the formulas themselves are proprietary. A larger concept involving these formulas are in the process of being patented. I thought of using the Nonlinear platform, but I don't see an easy way for this to work. The calculations are quite complex. Although i only need to optimize a single parameter, I need to do so for each row in a data-set of thousands of rows. Also the calculations span several columns, and combining them into one would almost certainly introduce error.

What i was hoping for was a method that would find the value in one column that cause the value in two different columns to be as close to equal as possible. this should be repeated for every row in the data-set.

It closely resembles what the Excel solver add-in does, so I though someone might have built the tool for JMP.

I also thought a script using the Minimize (or Maximize) functions might do the trick, but I guess I would need to script the entire formula set as opposed to just having the formulas in the columns, and then run it "for each row".

BR
Jesper
JesperJohansen

Community Trekker

Joined:

Apr 15, 2013

The nonlinear platform solved it for me after all. I just had to do the analysis by Row.

BR
Jesper