Analytic Solver Optimization

Capabilities

• Solve large-scale optimization models in Excel
• Traceable formulas show everyone what's happening
• Achieve cost savings by better allocating resources
• 100% upward compatible from Excel Solver
• Solver Engines for every type and size of model
• Use both Analytic Solver Excel Desktop
• and Analytic Solver Excel for the Web

PREMIUM SOLVER

Solve every type and size of optimization problem to better allocate scarce resources

•  Easily model your problem in Excel with full VBA support
• Use Guided Mode and Active Support with Live Chat
• Build an optimization model of virtually any size and type
• Use any of eight plug-in, large-scale Solver Engines
•   Get better answers to even the hardest problem types
• Identify and understand trade-offs in alternative solutions
• Build flexible multi-dimensional optimization models
• Desktop & cloud: publish to Excel Online or Google Sheets

FEATURES

Analytic Solver Optimization provides best-in-class tools to help you solve virtually any conventional optimization problem of any size. Excel Solver compatible Use existing Solver models and VBA macros as-is, but solve faster -- just open your workbook and solve. Upgrade to full analytics Upgrade Premium Solver Platform for Windows to handle stochastic and robust optimization, all the way to full-power predictive and prescriptive analytics. Unlimited size models 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. Easier model building Our Constraint Wizard helps you think about and define constraints. Guided Mode helps you better understand your model, refine it for better answers in less time, and find and correct any errors. When you're up to speed, Auto-Help Mode gives you expert help only when you encounter an error. Dimensional modeling Build more structured, easily readable, compact Excel models, that represent business situations with many 'dimensions' such as products, customer types, geographic regions, or time periods. Helpful example models Over 60 example models show you step by step how to create a basic Solver model, build more complex models, and use more advanced features. Better solutions Find 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. Faster solutions Find solutions between 2X and 200X faster thanks to more advanced Solver engines, better optimization algorithms, and our super-fast, proven accurate PSI Interpreter. Insightful reports & charts Easily understand and share results, and get insight into the key drivers of your model results and potential decision trade-offs you can make. Easy to use interface 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. Remove guesswork Simply define your model in Excel -- Premium Solver Platform will analyze it algebraically and automatically choose the best available Solver engine for it. Automatic transformation Premium Solver Platform 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. Upgrade Solver Engines 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. Your plug-in Solver engines will work with all our Platform products.