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! 11.0 incorporates several enhancements including improved handling of optimization models that incorporate uncertainty, a number of solver enhancements, and expanded function support.
Stochastic Solver Improvements:
MIP Solver Improvements:
Significant improvements in root node heuristics for quickly finding good, integer-feasible solutions.
Improved identification of special structures in certain classes of models, as in multi-period models, and the ability to exploit this structure to achieve significant reductions in solve times.
Global Solver Improvements:
Improved heuristics for finding a good, feasible solution quickly.
Constraints may now be flagged as being convex, in cases where the constraint's complexity makes it impossible for the global solver to automatically determine convexity. This speeds the proof of global optimality.
Improved ability to identify constraints that can be reformulated as conic (i.e., second-order cone) constraints and thus be solved by the faster conic solver.
Improved ability for efficiently handling polynomial terms.
Improved bounds for non-convex quadratic terms using SDP and eigenvalue reformulations.
Support of Additional Excel's Functions
Support has been added for the array function MMULT as well as several additional Cumulative Distribution and Probability Density functions.
New Tool to Help Translate Models
A feature has been added to assist you in translating models set up for competing optimization solvers working in Excel into a format you can use with What'sBest!
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.