Analytic Solver Simulation

Capabilities

• Solve Monte Carlo simulation models in Excel
• 1-Click makes @RISK models faster, cloud-ready
• Quantify, control and mitigate costly risks
• Define distributions, correlations, statistics
• Use charts, decision trees, simulation optimization
• Use both Analytic Solver Excel Desktop
• and Analytic Solver Excel for the Web

RISK SOLVER

Analyze and control risk, create optimal plans and resource allocation decisions.

• Understand the range of potential outcomes given uncertainty
• Identify drivers of your risk, explore options to mitigate risk
• Optimize with "here and now" and "wait and see" decisions
• Make complex decision choices clear using decision trees
•   Visually share key insights to better manage risk
• Identify and understand trade-offs in alternative solutions
• Build flexible multi-dimensional optimization models
• Deploy models for cloud-based use with RASON

FEATURES

Analytic Solver Simulation provides best-in-class tools for Monte Carlo simulation, risk analysis and simulation optimization. Combine it with Analytic Solver Optimization for powerful, scalable stochastic programming and robust optimization of models with uncertainty. Solve any model type Since it handles conventional optimization, simulation optimization, and stochastic optimization problems, you can build virtually any model you want, and let Analytic Solver take it from there. Easy to use An intuitive Ribbon and Task Pane, a unique step by step Distribution Wizard, and in-product Help set you up for success. Upgrade to full analytics Upgrade Analytic Solver Simulation at any time, all the way to full-power predictive and prescriptive analytics. Rich simulation features Over 50 probability distributions and over 50 statistics, risk measures and Six Sigma metrics are included, as well as the ability to fit distributions and automatically update them. Seamless integration All functions work as native Excel functions, so if you know even a little about Excel you'll be up and running in no time. Insightful charts From instant preview charts of distributions and fully customizable charts of inputs and outputs, to customizable multi-chart windows with full data visualization features, to charts that automatically cover multiple parameterized simulations, Analytic Solver Simulation gives you greater insights. The fastest simulations At up to 100x faster than competing alternatives thanks to our super-fast, proven accurate PSI Interpreter, you'll spend less time watching your simulation run, and more time analyzing results. Build decision trees Build multi-stage decision trees with point-and-click ease, and modify them right in Excel. Simulate over trees Add probability distributions and run simulations, to see the true range of outcomes for each decision alternative. Full sensitivity analysis See how your optimal decisions change as you vary the chances and payoffs across multiple outcomes. Unlimited size optimization 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 (PDF). Wizards and Guided Mode 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 how to create Excel Solver-compatible optimization models, Monte Carlo simulation models, decision tree models, simulation optimization models, and stochastic optimization models with chance constraints and recourse decisions. Better solutions Find better solutions to portfolio optimization problems, global optimization problems, and models using arbitrary Excel functions with Analytic Solver's built-in LP/Quadratic, SOCP Barrier, Interval Global and Evolutionary Solvers. The fastest optimizations Find solutions between 2X and 200X faster than the Excel Solver, thanks to more advanced Solver engines, better optimization algorithms, and our super-advanced PSI Interpreter.