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.
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. 什么是最好的！是 Excel 的一个加载项，允许您在电子表格中以自由格式布局构建大规模优化模型。什么是最好的！将线性、非线性（凸和非凸/全局）、二次、二次约束、二阶圆锥、半定、随机和整数优化与 Microsoft Excel （当今最流行和最灵活的业务建模环境）相结合。最近发布的 What'sBest！15.0 包括许多重要的增强功能和新功能。
单纯形求解器的增强功能提高了线性模型的性能。使用原始单纯形，大型模型的求解速度平均提高 20%，使用双单纯形平均快 15%。
新的对称性检测功能大大减少了在具有整数变量的某些类别的模型上证明最优性所需的时间。在最小买入数量和/或非零水平的工具数量限制的 Markowitz 投资组合问题上，性能得到了改善。其他增强功能为某些类似任务分配的模型提供了更快的解决方案。
通过对二次识别和范围缩减的多项增强，全局求解器的稳定性和鲁棒性得到了改进。改进了对某些比率约束的凸性的利用，例如，在换热器网络设计问题中发现的那样。
对于一般整数变量，可以识别几种新的函数和约束类型，例如，=WBALLDIFF（） All Different 约束。=WBALLDIFF（） 函数允许指定一组整数变量，以便集合中的每个变量必须具有唯一值，与集合中的所有其他变量不同。
购买后，将显示帖子中所有出售内容。
若发现会员采用欺骗的方法获取财富,请立刻举报,我们会对会员处以2-N倍的罚金,严重者封掉ID!
此段为出售的内容，购买后显示
微博帐号登录