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. The recently released What’sBest! 14 includes a number of significant enhancements and new features. View more information on these new features.
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.
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.
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.
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.
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.
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.
IMPORTANT – Carefully read all the terms and conditions of this agreement before installing this software
package. Installing this package indicates your acceptance of theses terms and conditions. If you do not accept these terms and conditions, contact LINDO Systems Inc., PO Box 148231, Chicago, IL, 60614, USA, for instructions on return of this package for a refund.
LINDO Systems License Agreement
Subject to the following terms and conditions, LINDO Systems Inc. (LINDO) hereby grants to you a nonexclusive license to use the LINDO Systems Inc. software program (the “SOFTWARE”) contained on the enclosed media and related documentation.
Except as set forth below, LINDO grants to you the right to use the SOFTWARE on any single computer. You may also install a copy for your exclusive use on either a home computer or portable computer. You may store or install a copy of the SOFTWARE on a storage device, such as a network server, used only to install or run the SOFTWARE over an internal network; however, you must acquire and dedicate a license for each individual who will use the SOFTWARE. If the license is installed on a network server or other system that physically allows shared access to the SOFTWARE, you agree to provide technical or procedural methods to prevent use of the SOFTWARE by individuals not specifically licensed to use the SOFTWARE pursuant to this Agreement.
The SOFTWARE may be transferred to a single recipient on a permanent basis provided you retain no copies of the SOFTWARE nor documentation (including backup or archival copies) and the recipient agrees to the terms and conditions of this license agreement. At the time of the transfer of the SOFTWARE, you must transfer all media and documentation including any updated media and documentation.
The SOFTWARE and its related documentation are copyrighted and protected by US copyright laws and international treaty provisions. You may not use, copy, modify, or transfer the SOFTWARE or related documentation except as expressly provided in the license agreement or with written permission of LINDO Systems Inc.
Restrictions Against Distribution
You may not distribute, lease, sublease, rent, or sublicense the SOFTWARE or related documentation without written permission of LINDO Systems, Inc.
LINDO Systems Inc. warrants that the enclosed media and the copy of the related documentation to be free of defects in materials and workmanship for a period of one year from receipt of your payment. Due to the inherent complexity of computer programs and mathematical models, the SOFTWARE and your mathematical models may not be completely free of errors. You are advised to verify your answers before basing decisions on them. NEITHER LINDO SYSTEMS INC. NOR ANYONE ASSOCIATED WITH THE CREATION, PRODUCTION, OR DISTRIBUTION OF THE SOFTWARE MAKES ANY OTHER EXPRESSED WARRANTIES REGARDING THE MEDIA OR DOCUMENTATION AND MAKES NO WARRANTIES AT ALL, EITHER EXPRESSED OR IMPLIED, REGARDING THE SOFTWARE, INCLUDING BUT NOT LIMITED TO IMPLIED WARRANTIES OF MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE OR OTHERWISE.
LINDO’s entire liability and your exclusive remedy for breach of this Limited Warrant shall be, at LINDO’s Option, either return of the price paid or replacement of defective media or documentation. In no event shall LINDO Systems Inc. be liable for any damages including but not limited to loss of profit, data, or direct, indirect, special or consequential damages, even if LINDO has been specifically advised of the possibility of such damages.
This agreement gives you specific rights, and you may also have other rights that vary from state to state. This License Agreement is governed by, and shall be construed in accordance with, the laws of the State of Illinois.
What’sBest! 14 is available for:
Windows 32 bit and Windows 64 bit
© Copyright 2017 Lindo Systems Inc.
Applicazione (add-in) per Excel che permette di costruire modelli di ottimizzazione di grandi dimensioni in formato libero all’interno di un foglio elettronico.