turn on suggestions

Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.

Showing results for

- JMP User Community
- :
- Discussions
- :
- Discussions
- :
- Numerical solver add-in

Topic Options

- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

Feb 5, 2015 5:18 AM
(5356 views)

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

Jesper

1 ACCEPTED SOLUTION

Accepted Solutions

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

Feb 5, 2015 7:19 AM
(8680 views)
| Posted in reply to message from JesperJohansen 02/05/2015 08:18 AM

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

Sr Statistical Writer

JMP Development

4 REPLIES

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

Feb 5, 2015 7:19 AM
(8681 views)
| Posted in reply to message from JesperJohansen 02/05/2015 08:18 AM

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

Sr Statistical Writer

JMP Development

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

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

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

Feb 5, 2015 11:27 PM
(4942 views)
| Posted in reply to message from Jeff_Perkinson 02/05/2015 10:28 AM

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

Jesper

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

Feb 6, 2015 1:30 AM
(4942 views)
| Posted in reply to message from JesperJohansen 02/06/2015 02:27 AM

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

BR

Jesper

Jesper