Premium Solver Pro for Excel

Function-Based Models and Interactive Optimization

Since Premium Solver V8.0, you can define your optimization model using the same interactive dialogs and VBA macros as the Excel Solver and previous versions of Premium Solver Pro. Version 8.0 added a new style of model definition, using PSI functions on the worksheet. These functions are compatible with the family of PSI functions used by Risk Solver Engine.

You can move easily between the interactive dialogs and PSI functions when creating your model. You can define variables and constraints by entering PSI function calls in worksheet cells, and you'll find that these variables and constraints appear in the Solver Parameters dialog the next time you display it.

You can also define variables and constraints in the Solver Parameters dialog, and cause PSI function calls to appear automatically in cells on the worksheet.

PSI functions offer a new alternative
for Load and Save Model commands.

Interactive Optimization

Premium Solver V8.0 and above support Interactive Optimization: If you enable this feature, the Solver will re-optimize your model each time you change a number on the spreadsheet. For small to medium size models, this is not only a convenience - it can be a real decision aid: You'll find that insights about your model, and decisions you can make, start to flow intuitively, when you can quickly see the impact of changing a parameter on the optimal solution.

< Back to Premium Solver Pro Product Overview