What's Best! is an add-in to Excel that allows you to build large scale optimisation models in a free form layout within a spreadsheet.


Click on the Edition to see more information and pricing

What'sBest! 15.0


What'sBest! 15.0

What'sBest! is an add-in to Excel that allows you to build large scale optimization models in a free form layout within a spreadsheet. What'sBest! combines the proven power of Linear, Nonlinear (convex and nonconvex/Global), Quadratic, Quadratically Constrained, Second Order Cone, Stochastic, and Integer optimization with Microsoft Excel -- the most popular and flexible business modeling environment in use today. What'sBest! 14.0 includes a wide range of performance enhancements and new features.

What's Best! 14.0 Enhancements

Faster Solutions on Linear Models with Improved Simplex Solver

  • Enhancements to the Simplex solvers boost performance on large linear models. Large models solve an average of 35% faster using primal simplex and 20% faster for dual simplex.

Improved Integer Solver with new features

  • A new optimization mode has been introduced to ensure reproducibility of runs.

  • Investigate alternative optima more quickly. Enhancements to the K-Best algorithm allow finding K best solutions in little more time than finding one solution.

  • Find faster solutions to models with knapsack constraints and block structures using new heuristic algorithms.

  • New preprocessing level tightens variable bounds for better performance on classes of nonlinear models.

Enhanced Stochastic Solver

  • Large linear multistage SP instances solve 60% faster with improved cut management for Nested Benders Decomposition Method.

  • Better handling of multistage SP models which do not have full-recourse.

  • Extensions to the parser allow the use of arbitrarily complex functions of stochastic parameters.

Improved Global Solver

  • Performance of Global solver has been dramatically improved on classes of quadratic problems. In particular, non-convex quadratic problems rejected by other solvers, or otherwise solvable only slowly to a local optimum by traditional NLP solvers. Can solve some previously intractable problems to global optimality, especially financial portfolio models with minimum buy quantities, and/or limit on number of instruments at nonzero level.

  • Dramatically faster, more robust performance on many linearized models using functions like @MAX( ), @MIN( ), @ABS( ), x*z where z = 0 or 1, etc. Incorporates a new bound tightening process to the linearization procedure and improves solvability of linearized model.

New Scenario Viewer

  • Powerful new feature to view different solution values on models with integer variables and Stochastic Programming models. On integer models you can use the Scenario Viewer to browse through alternative optima and near optimal solutions. On Stochastic Programming models you can scroll through different scenarios of the scenario tree.

Additional Enhancements

  • Improved model validity checking and more comprehensive error messages.

  • New feature to summarize location of the Adjustable and Constraint cells in the workbook to ease the understanding of the model.

  • Added support for the Standard Deviation function STDEV.

Key Benefits of What's Best!

The World's Most Powerful Solver for Microsoft Excel

  • What'sBest! will efficiently solve your biggest, toughest models. The linear, integer, nonlinear and global solvers in What'sBest! have been designed for large scale commercial use and field tested on real world models by companies around the world. For optimization modeling in Excel, What'sBest! offers unrivaled speed and capacity.

Modeling is Fast and Easy

  • Excel users will find What'sBest! to be an easy and powerful tool for solving optimization problems. Most users are able to begin modeling within minutes of installation.

Build Models for your Clients

  • What'sBest! is an ideal tool for creating optimization applications for use by others. What'sBest! allows you to provide the application in a form that is best suited to the user. For managers, you can build a simple, easy-to-understand spreadsheet. For clerical workers, you can create turn-key applications with custom interfaces.

Extensive Documentation and Help

  • What'sBest! provides all of the tools you will need to get up and running quickly. You get the What'sBest! User Manual (in printed form and available via the online Help) that fully describes the commands and features of the program. Also included in the manual is discussion of the major classes of linear, integer and nonlinear optimization problems along with over two dozen real world based examples that you can modify and expand.


Click on the Addon to see more information and pricing

Barrier Option


Barrier Option

The Barrier Option ­provides the ability to deal with quadratic problems.
This option ­ includes a Barrier/Interior Point solver that provides quadratic programming capabilities. This option also provides an alternative method of solving linear models that may be faster than the linear solvers included in the base version.

Global Option


Global Option

The Global Option provides the global optimisation capability.
Local search solvers are generally designed to search only until they have identified a local optimum. If the model is non-convex, other local optima may exist that yield significantly better solutions. Rather than stopping after the first local optimum is found, the global solver will search until the global optimum is confirmed. The global solver converts the original non-convex, nonlinear problem into several convex, linear subproblems. Then, it uses the branch-and-bound technique to exhaustively search over these subproblems for the global solution. The nonlinear and global license options are required to utilize the global optmization capabilities.

Nonlinear Option


Nonlinear Option

The Nonlinear Option ­provides the ability for dealing with general nonlinear problems.
This option includes a Generalised Reduced Gradient (GRG) based solver that is capable of finding locally optimal solutions to general nonlinear models.