Distributore Esclusivo
ULTIMO RILASCIO: 10 Novembre 2020

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, Semi-Definite, Stochastic, and Integer optimization with Microsoft Excel — the most popular and flexible business modeling environment in use today. The recently released What’sBest! 16.0 includes a number of significant enhancements and new features. See how to formulate SP Models in What’sBest!.

 

 

What'sBest spreadsheet solver

 

 

CAPACITY AND OPTIONS DETAILS:

                                         Base Nonlinear                       Global
                                 Linear Models Nonlinear Multistart Global Solver
Capacity Constraints Variables Integers Variables NL Variables NL Variables
Commercial/Super 1,000 2,000 200 200 200 10
Professional/Hyper 4,000 8,000 800 800 800 20
Industrial 16,000 32,000 3,200 3,200 3,200 50
Extended Unrestricted Unrestricted Unrestricted Unrestricted Unrestricted Unrestricted
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, … more

 

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, … more

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, … more

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, … more

SEVERAL TIMES FASTER ON LINEAR MODELS WITH MANY MORE VARIABLES THAN CONSTRAINTS 

The Simplex Solvers have been enhanced to solve linear models with several times more variables than constraints substantially faster.

 

ADDED SUPPORT FOR MULTIPLE OBJECTIVE OPTIMIZATION

For linear models, users can provide a prioritized list of objective functions and What’sBest! will perform Lexico/Pre-emptive priority optimization. The solver will optimize on the first objective, constraint it to the optimal value and resolve on the next objective. Then, constraint it and move to the next.

FASTER WHEN SIMULTANEOUSLY SOLVING LINEAR MODELS USING DIFFERENT SOLVERS

An improved feature allows users to concurrently run the Primal Simplex, Dual Simplex, and Barrier solver each on a separate core ensuring the solution in the shortest time regardless of which solver is fastest.

IMPROVED SUPPORT FOR USING NETWORK AND CLOUD DRIVES

The new release offers improved support for storing models on network drives and cloud drives.

 

INTEGER SOLVER IMPROVEMENTS

Better performance on many integer models has been achieved through improved selection of default settings for cut generation and solution heuristics.

SUPPORT (FASTER SOLVE TIMES) FOR ADDITIONAL COMPOSITE FUNCTIONS

WBLOGABEXPX ln(a + b * exp(x))
WBLOGSUMAEXP ln( a1 * exp(x1) + . . . +an * exp(xn))
WBLOGSUMEXP ln(exp(x1) + . . . + exp(xn))
WBXPOWDIVAB x^a/(b – x)

ENHANCEMENTS TO THE QUADRATIC/CONIC SOLVERS

Models with ex and xk terms are solved faster — so called Barrier Solver exponential and power cones.

 

IMPROVED INSTALLATION AND USER INTERFACE

The format and layout of some dialog boxes have been improved to provide more information and make them more user-friendly. Several enhancements have been made to improve the installation process.

 

NUMEROUS GLOBAL SOLVER ENHANCEMENTS

The ability to recognize and exploit convexity of various composite functions has been substantially improved. Performance has been improved for convex-concave type functions. Models with ratio/fractional objective solve an order of magnitude faster. Performance on on-convex Quadratically Constrained Quadratic Programs and been substantially improved.

 

What’sBest End User License Agreement 
IMPORTANT – Carefully read all the terms and conditions of this agreement before installing this software package. Installing this package indicates your acceptance of these terms and conditions. If you do not accept these terms and conditions, please contact TStat S.r.l. Via Rettangolo, 12-14, 67039 Sulmona, Italy at tstat@tstat.it within 30 days of your original purchase date for instructions on how to obtaining a refund.

 

LINDO Systems License Agreement
Subject to the following terms and conditions, LINDO Systems Inc. (LINDO) hereby grants to you a non-exclusive license to use the LINDO Systems Inc. software program (the “SOFTWARE”) contained on the enclosed media and related documentation.

 

Software License
License
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.

 

Transfer
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.

 

Copyright
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.

 

Limited Warranty
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

 

Remedy
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.

 

General
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!
Versione
Sistema Operativo Software Hardware
17.0 (32 Bit) Windows Microsoft® Windows® 7, 8, 10, or Windows® XP, Vista®

Microsoft® Excel® versione 2002, 2003, e versione 2007, 2010, 2013, 2016, 2019, 365

Microsoft® .NET Framework 4.0

Pentium-class PC

500 MB of RAM

50 MB di spazio libero sul disco

17.0 (64 Bit) Windows Microsoft® Windows® 7, 8, 10, or Windows® XP, Vista®

Excel 365, 2016, 2013, e 2010

Microsoft® .NET Framework 4.0

Pentium-class PC
500 MB of RAM
50 MB di spazio libero sul disco

What’sBest! MANUAL 

The What’sBest! manual can be downloaded in pdf format here

 

Download Models for What’sBest!

What’sBest! lets you build linear, nonlinear, and integer models in Excel. Models are easy to build and understanding standard spreadsheet equations. Excel users can often begin building models within minutes of installing the What’sBest! program, and the problem capacities of the larger What’sBest! versions allow large scale, real world problems to be solved.

 

RECOMMENDED BOOKS: 

Modeling the Supply Chain by Jeremy F. Shapiro

Modeling, Analysis and Optimization of Process and Energy Systems by F. Carl Knopf

 

 


© Copyright 2020 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.