Frontline Systems, Excel Solver, optimization software, Solver Excel, simulation software
Solver.com
From Frontline Systems, developers of the Excel Solver.

Solver tutorials

Learn to use optimization for resource allocation, and Monte Carlo simulation for risk analysis of your model.


 

Premium Solver for Excel - Function-Based Models and Interactive Optimization

Function-Based Models and Interactive Optimization

In the 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 the Premium Solver. But Version 8.0 also supports 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

The Premium Solver V8.0 also supports 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 Product Overview