Complete Solution for Predictive and Prescriptive Analytics in Excel
Analytic Solver Platform offers truly powerful and comprehensive forecasting, data mining, simulation/risk analysis, decision trees, and conventional and stochastic optimization, for problems of any size.Apply "rocket science methods" to your business models in Excel.
Incredible Analytic Power Made Easy to Use
We assume you're smart, but you have limited time, and you've got to get results while learning about the analytic methods. Analytic Solver Platform is packed with features to help you get started with data mining, simulation and optimization, diagnose your models, and get help when you're not sure what to do.
- Ribbon choices and dialogs guide you through forecasting and data mining. Our Distribution Wizard guides you through the hardest steps of a simulation model, and our Constraint Wizard guides you through the toughest parts of an optimization model.
- Automatic Mode allows Analytic Solver Platform to diagnose your model type and attempt to transform it to make it easier to solve. It "makes you smart" by automatically choosing the most appropriate method (such as simulation optimization, stochastic programming or robust optimization) and the best Solver engine for your particular model.
- Guided Mode is like having an expert at your side to help you understand your model, how to correct any errors found, how to interpret the solution found (for example whether it's locally or globally optimal), and whether you'll be able to scale up the model to larger size.
- Interactive Mode for Simulation allows you to conduct real time what-if analysis, taking advantage of the speed of our Monte Carlo Simulation engine to do virtually instant simulation runs anytime a cell is changed in the worksheet. All output cells and charts are updated to give you immediate insight.
- Flexible Charting: Easily understand and share results and get insight into the key drivers of your model results and potential decision trade-offs you can make.
- Context-sensitive Help, a User Guide, Reference Guide and QuickStart Guide, and 30 sample datasets and 90 example models are available at your fingertips.
- New Active Support shortens the time and distance between you and live technical support. Start a Live Chat directly in Excel, and pass on error information automatically in seconds.
Powerful Data Visualization, Forecasting and Data Mining
Analytic Solver Platform provides everything you need to sample data from many sources -- PowerPivot, external SQL databases, or spreadsheets; explore and visualize your data with multiple linked charts; preprocess and 'clean' your data, fit data mining models, and evaluate your models' predictive power..
|Visualization aids||Use bar, line, scatterplot, boxplot and histogram charts, with one-click changes to axes, colors and panels, zooming, brushing and more.|
|Data transformation||Perform data sampling and partitioning, missing data handling, binning, transforming categorical data, and principal component analysis.|
|Time series analysis||Create ACF/PACF plots and fit exponential smoothing, ARIMA, and standard and seasonal models.|
|Powerful Statistics methods||Use multiple linear regression with advanced diagnostics and variable selection methods, discriminant analysis, and logistic regression.|
|Classification & Clustering||Use k-nearest neighbors, classification trees, naïve Bayes and neural nets for classification, and k-means and hierarchical clustering for any data.|
|Prediction and Affinity Analysis||Use regression trees, k-nearest neighbors, and neural networks for prediction, and association rules for affinity analysis.|
|Score external databases||Apply your data mining model for classification or prediction to data in an external database.|
Industry Leading Optimization Capabilities
Analytic Solver Platform provides the best-in-class tools you need to solve virtually any conventional optimization problem of any size, and unique tools to solve stochastic optimization problems of any type, while helping you along the way.
|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 Platform take it from there.|
|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 (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 arbitrary Excel models with Analytic Solver Platform'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.|
Industry Leading Monte Carlo Simulation and Risk Analysis
Over 20+ years of our own R&D and working directly with Microsoft, most recently implementing the new, more-accurate probability distribution functions built-in to Excel 2010 and Excel 2011, has enabled us to bring you a proven accurate Monte Carlo simulation tool which is much faster than competing alternatives.
|Complete set of features||Over 50 probability distributions and over 30 statistics 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 Platform gives you greater insights.|
|Helpful example models||Over 30 example models show you step by step how to create a basic simulation model, use Interactive Simulation, run multiple parameterized simulations, use distribution fitting and more.|
|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.|
|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.|
Combine Optimization and Simulation to Make Even Better Decisions
Optimization helps you make better choices when you have all the data, and simulation helps you understand the possible outcomes when you don’t. Analytic Solver Platform enables you to combine these analytic methods, so you can make better choices for decisions you do control, taking into account the range of potential outcomes for factors you don’t control.
|One model does it all||With a single model you can optimize your decisions while taking uncertainty into account. The result is a more realistic model that helps you make better decisions.|
|Define recourse decisions||Many real-world situations involve both decisions that you must make "here and now", and decisions you can make on a "wait and see" basis, after all or part of the uncertainty is resolved. Only Analytic Solver Platform enables you to include both types of decisions in your model -- which often results in different and better decisions "here and now."|
|Multiple ways to solve||Only Analytic Solver Platform has built-in support for simulation optimization, stochastic programming, and robust optimization for models with uncertainty, offering multiple Solver engines for each of these methods. Products that support only simulation optimization cannot handle large-scale optimization models with uncertainty.|
|The speed you need||Analytic Solver Platform's optimization and simulation speed advantage is even greater when solving these more complex, and useful, models.|
|Single interface||Analytic Solver Platform has a single integrated interface for simulation, conventional and stochastic optimization, and decision trees, so you can access every feature and see your entire model at a glance.|
Powerful Decision Tree capabilities
Decision Trees help you visually lay out complex decisions to not only make choices clear, but also help you understand which choices you should make and the risk associated with each.
|Easily build trees||Build single and multi-stage decision trees simply by filling in fields, and modify them right in Excel.|
|Add uncertainty||Easily add probability distributions and run simulations, to see the true range of potential outcomes for each decision alternative.|
|Full sensitivity analysis||See how your optimal decisions change as you vary the chances and payoffs across multiple outcomes.|
|Helpful example models||Over a dozen example models show you everything from building a basic tree to adding uncertainty to advanced sensitivity analysis.|
The Best Technology for the Best Solutions
At the heart of Analytic Solver Platform is the combination of our advanced Solver Engines and our proprietary PSI Interpreter -- which automatically performs Monte Carlo simulation trials in parallel, algebraically analyzes your formulas, delivers model structure information crucial for advanced optimization algorithms, computes function gradient and curvature results with maximum speed and accuracy, and fully exploits multiple processor cores. This is advanced technology no one else can offer -- and we make this advanced technology easy -- even automatic -- for you to use.
Compare our Solvers for Excel
We have a range of Solver products to meet your needs. Below are several comparison charts to help you choose. We're happy to assist with any questions, to help make sure you find the right product for your unique needs.
We’re Here To Help You
Whichever product you buy, we offer a full range of support internally and through external partners to help you succeed. Whether you are looking for pre-sales support on your problem and our product line, Technical Support on using our tools, or personalized Consulting Services, we are here to help you. We offer a full range of online support resources you can access anytime.
|Support Live Chat||Only Frontline Solvers offer quick access to Tech Support via Live Chat from inside Excel -- automatically passing error information to our support reps.|
|Guided Mode Support||In Guided and Auto-Help Mode, if the error message and full-text explanation isn't enough, just click the button to connect live to Tech Support.|
Very Cost Effective Pricing
Depending on the problem and size of the business, cost savings and profit improvements of up to a million dollars or more are not uncommon. Even much smaller applications can result in significant benefits.
ATTENTION PROFESSORS: If you teach management science in a classroom environment, learn more about using Analytic Solver Platform for Education, with special low-cost licenses for your students.
To try out Analytic Solver Platform, simply download our Frontline Solvers free 15-day trial Setup program. When you run Setup, choose Analytic Solver Platform as your Initial Product Choice. During your trial, you can switch to another product at any time. On the Analytic Solver Platform Ribbon Menu in Excel, select Help > Change Product.
Just enter your name and email address, and optionally your company and phone, pick the closest "User Type," and click the Register for Download button. You can download immediately after registering, or return later anytime -- just login with your email address.