闪电联盟 - Powered by phpwind

离线pony8000

UID: 125

IT资讯组

发帖: 53736

今日发帖

最后登录: 2026-10-22

只看楼主倒序阅读使用道具楼主发表于: 2020-09-14 07:46:11

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! 15.0 includes a number of significant enhancements and new features.
Lindo WhatsBest是一款适用于Microsoft Excel的可用于线性，非线性和整数建模和优化的加载项，能够帮助用户快速的在您的Excel中构建线性，非线性和整数模型。使用标准电子表格方程式可以轻松构建和理解模型。WhatsBest16.0使您的Microsoft Excel电子表格程序可以使用高度开发的求解器，该求解器可以对最棘手的问题进行线性，整数，二次，圆锥，半定，一般非线性，全局和随机优化。 What'sBest！使您可以从Excel中访问此求解器，可以直接运行，也可以在VisualBasic中调用。其应用范围非常广，包括对求解器的重大改进，以提高线性，整数，二次和常规非线性模型的速度和可靠性。商业，金融，科学，数学和许多其他领域的人都使用What'sBest！每天都可以对生产，财务计划，人员调度，资源分配，项目组合管理，库存削减，库存控制等方面的问题进行建模和解决，这是一长串的清单，您需要在其中添加自己的应用程序。其他重大改进包括改进的全局求解器，更新的预求解器以及对解决方案过程的更好的用户控制。
Enhancements to the Simplex solvers boost performance on linear models. Large models solve an average of 20% faster using primal simplex and 15% faster for dual simplex.

New symmetry detection capabilities dramatically reduce the time required to prove optimality on certain classes of models with integer variables. Performance has been improved on Markowitz portfolio problems with minimum buy quantities, and/or limit on number of instruments at nonzero level. Other enhancements provide faster solutions on certain task assignment-like models.

Stability and robustness of the Global solver has been improved through several enhancements to quadratic recognition and range reduction. Improved exploitation of convexity of certain ratio constraints, e.g., as found in heat exchanger network design problems.

Several new functions and constraint types are recognized, e.g., the =WBALLDIFF() All Different constraint, for general integer variables. The =WBALLDIFF() function allows one to specify a set of integer variables, such that each variable in the set must have a unique value, different from all other variables in the set.