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
