solver.com

NEW!  The Premium Solver Platform V8.0 supports Solver models spread across multiple worksheets in a workbook, with decision variables and constraints on any worksheet. Different models may be defined on each worksheet, and each model can include variables and constraints on any sheet in a workbook.  Solver reports, previously limited to 65,536 rows, are now automatically “wrapped” and may be of virtually unlimited size, even in Excel 2000-2003. Report generation is typically 5-7 times faster for models of a few thousand variables, and many times faster for larger models.

NEW!  When used with Frontline's new Risk Solver Engine, the Premium Solver Platform V8.0 can solve simulation optimization problems with unprecedented speed.  Your models can include random variables, defined by probability distributions, and formulas that depend on these random variables. Risk Solver Engine performs Monte Carlo simulation, with thousands of trials, on each change to the spreadsheet. Statistics for any uncertain formula, such as its mean and variance, Value at Risk, and percentiles, are available on the spreadsheet and can be used in the objective and constraints of your optimization model.

NEW!  The Premium Solver Platform V8.0 can deliver multiple solutions, not just a single best solution, for integer programming and global optimization problems. The best integer solutions (“incumbents”) for MIP problems, locally optimal solutions for global optimization problems, or best final population members for non-smooth problems solved with the Evolutionary Solver can be viewed in a worksheet report, or easily accessed in your VBA code via the new object-oriented API.

NEW!  The Premium Solver Platform V8.0 supports a new, optional style for defining optimization models with functions on the worksheet. You can move easily between the traditional interactive modeling style and the new functions such as PsiVar(), PsiObj() and PsiCon(), or between the new functions for optimization and Risk Solver Engine’s functions for simulation.

NEW!  Interactive Optimization enables the Premium Solver Platform to 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.

NEW!  The Premium Solver Platform V8.0 features a new objected-oriented API (application programming interface), accessible from Excel VBA, that matches the object-oriented API of the Solver Platform SDK, our flagship product for developing optimization and simulation using modern programming languages such as C#, C++, VB.NET, Java and MATLAB. The new API makes it much easier to develop powerful custom applications in Excel, and to move applications from Excel to a programming language.

Unique: The Premium Solver Platform V8.0 includes Frontline's Polymorphic Spreadsheet Interpreter that replaces the core of Excel with a dramatically improved ability to analyze your spreadsheet models for linear, quadratic, smooth nonlinear, and nonsmooth functions -- and, in a research breakthrough not available in any other commercial software, automatically determine (in many cases) whether your nonlinear model is convex -- the key property that makes it possible to solve your model quickly and reliably, to very large size.

Unique:  And if your model uses common Excel functions like IF, MIN. MAX, ABS, AND, OR and NOT and comparison operators, that make the model nonsmooth and cause problems for conventional optimizers, the Premium Solver Platform V8.0 can automatically transform your model to an equivalent form that replaces these functions with additional variables and linear constraints.  You simply check a box to "Solve Transformed Model" and click Solve -- the Polymorphic Spreadsheet Interpreter does the work of an expert operations research analyst and transforms your model into one that can be solved faster and more reliably!

Powerful:  The Premium Solver Platform V8.0 includes a new, far more powerful LP/Quadratic Solver that handles linear (LP), quadratic (QP) and mixed-integer (MIP) problems, with up to 8,000 variables (and up to 2,000 integer variables).  This Solver offers world-class performance in both speed on large problems, and robustness on poorly scaled problems.  It includes a powerful presolver, advanced primal and dual Simplex methods, and powerful Branch, Cut & Bound method for mixed-integer problems.

Powerful:  Version 8.0 also includes new support for second order cone programming (SOCP) -- the natural generalization of linear and quadratic programming -- with new, easy to use second order cone (SOC) constraints, a new SOCP Barrier Solver built-in to the Premium Solver Platform, and the new, field-installable MOSEK Solver Engine, widely regarded as the world's best Solver for SOCP problems.