We developed the solver in Excel - you get an extremely powerful, 100% compatible upgrade now, and the ability to 'plug in' the world's best Solver engines for every type of optimization problem, whenever you need them. Simply define your model in Excel - Analytic Solver will analyze it algebraically and automatically choose the best available Solver engine for it.Īnalytic Solver goes beyond model analysis - if your model would solve slowly because it uses functions like IF, VLOOKUP and HLOOKUP, MIN and MAX, it will seek to transform your model automatically into a form that can be solved much more quickly and accurately. Use either a dialog-based interface that matches the basic Excel Solver, or our Ribbon and Task Pane interface with quick access to advanced features and help. Over 100 example models show you step by step how to create a basic Solver model, build more complex models, and use more advanced features.įind better solutions to portfolio optimization problems, global optimization problems, and models using arbitrary Excel functions with the built-in LP/Quadratic, SOCP Barrier, Interval Global and Evolutionary Solvers.įind solutions between 2X and 200X faster thanks to more advanced Solver engines, better optimization algorithms, and our super-fast, proven accurate PSI Interpreter.Įasily understand and share results, and get insight into the key drivers of your model results and potential decision trade-offs you can make. When you're up to speed, Auto-Help Mode gives you expert help only when you encounter an error.īuild more structured, easily readable, compact Excel models, that represent business situations with many 'dimensions' such as products, customer types, geographic regions, or time periods. Guided Mode helps you better understand your model, refine it for better answers in less time, and find and correct any errors.

Our Constraint Wizard helps you think about and define constraints. Handle problems with up to 8,000 decision variables (40 times larger than the Excel Solver) using built-in Solver engines, and virtually unlimited size problems with optional plug-in Solver engines.

Use existing Solver models and VBA macros as-is, but solve faster - just open your workbook and solve. Industry Leading Conventional Optimization Capabilities from Premium Solver Platform Analytic Solver Comprehensive provides best-in-class tools to help you solve virtually any conventional optimization problem of any size.

Download data analysis excel mac