What'sBest!

What'sBest! is a powerful Excel add-in that enables users to build and solve large-scale optimization models directly within spreadsheets. It combines the flexibility of Excel with advanced solvers for linear, nonlinear, integer, quadratic, stochastic, and global optimization. Designed for business analysts, consultants, and researchers, What'sBest! simplifies complex decision-making through intuitive modeling and high-performance computation.

Features

• Excel Integration: Models are built in a free-form spreadsheet layout, making it accessible to Excel users.
• Automatic Solver Selection: Detects model structure and selects the appropriate solver without user intervention.
• Advanced Solvers: Includes simplex, barrier, GRG, SLP, branch-and-bound, multistart, and global optimization techniques.
• Linearization Engine: Converts nonsmooth Excel functions (e.g., IF, MAX, MIN, ABS) into linear equivalents for faster solving.
• Stochastic Programming Support: Models uncertainty with multistage stochastic optimization and over 20 distribution types.
• Preprocessing and Scaling: Improves speed and robustness through model reduction and intelligent scaling.
• Custom Interfaces: Allows creation of user-friendly applications for managers or clerical staff.

Capabilities

• Linear and Integer Programming: Solve models with thousands of variables and constraints efficiently.
• Nonlinear and Global Optimization: Find optimal solutions for complex, non-convex problems.
• Quadratic and Conic Models: Handle portfolio optimization, regression, and layout problems.
• Stochastic Modeling: Incorporate risk and uncertainty into decision-making.
• Client-Facing Applications: Build turnkey optimization tools for end users with minimal training.

Benefits

• Ease of Use: Excel users can start modeling within minutes, with no programming required.
• High Performance: Solves models with over 100,000 variables, outperforming other spreadsheet solvers.
• Scalability: Suitable for small businesses to large enterprises with complex modeling needs.
• Cost Efficiency: Reduces reliance on external modeling platforms and consultants.
• Versatility: Supports a wide range of optimization types and industries.