excel solver
optimization
simulation
excel solver, optimization software

   solver.com

Frontline Systems, Inc.  

quadratic programming, portfolio optimization, quadratic solver 
Developers of Your Spreadsheet's Solver  
robust optimization, stochastic programming, simulation optimization
   

Premium Solver - What's New in Version 8.0


optimization, solver, Excel

 
Home
Register
What's New
Solver Tutorial
Solver Technology
Select a Product
Excel Users
Developers
MATLAB Users
Macintosh Users
Government Users
Academic Users
Press/Analysts
Privacy Policy
 

 

 
NEW!  The Premium Solver V8.0 includes includes full support for Excel 2007 -- the biggest Excel upgrade in at least 10 years, with everything from a new "ribbon" based user interface to huge worksheets with 16,384 columns and 1,048,576 rows – far beyond the 256 column and 65,536 row limits in previous Excel releases. This makes it much easier to lay out your models on a worksheet, without having to split up large tables of information.  Version 7.1 updates Help and licensing support for Windows Vista.

NEW!  When used with Frontline's new Risk Solver Engine, the Premium Solver 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 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 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 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 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.

Back to Premium Solver Product Overview

 
Premium Capabilities
What's New in Version 8.0
Problem Size and Speed
New Kinds of Problems
Upward Compatibility
Compare Excel Solvers
Function-Based Models
Interactive Optimization
Linearity and Feasibility
Object-Oriented API
Linear Programming
Nonlinear Optimization
Genetic Algorithms
Simulation Optimization
LSLP Solver Engine
Download Free Trial
How to Order Your Copy
Support and Upgrades
Runtime Licensing
   
spreadsheet solver
scarce resources