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. Over example models show you step by step how to create a basic Solver model, build more complex models, and use more advanced features. Find solutions between 2X and X faster thanks to more advanced Solver engines, better optimization algorithms, and our super-fast, proven accurate PSI Interpreter.
Easily understand and share results, and get insight into the key drivers of your model results and potential decision trade-offs you can make. 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. Simply define your model in Excel -- Analytic Solver will analyze it algebraically and automatically choose the best available Solver engine for it. 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.
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. 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. 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 gives you greater insights.
At up to x 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 multi-stage decision trees with point-and-click ease, and modify them right in Excel.
Add probability distributions and run simulations, to see the true range of outcomes for each decision alternative. See how your optimal decisions change as you vary the chances and payoffs across multiple outcomes. Our Distribution Wizard helps you define probability distributions. Over example models show you how to create Monte Carlo simulation models, decision tree models, simulation optimization models, and stochastic optimization models with chance constraints and recourse decisions.
Analytic Solver can handle the most challenging stochastic optimization models, thanks to advanced methods such as stochastic decomposition, more advanced Solver engines, and our super-advanced PSI Interpreter. Sample data from spreadsheets, text files and SQL databases, including Microsoft's PowerPivot in-memory database handling million rows or more.
Use visualization aids from simple bar, line and histogram charts to multiple linked charts, instant axis changes, colors, panels, zooming, brushing and more. Automatically transform free-form text into structured data, identifying most frequent terms and extracting key concepts with latent semantic indexing. Clean and transform your data with a comprehensive set of data handling utilities including categorizing data and handling missing values. Use feature selection to automatically identify columns or variables with the greatest explanatory power for your desired classification or prediction task.
Use principal components to reduce columns, and k-means clustering or hierarchical clustering to group data by rows. Easily partition your data into training, validation, and test datasets, with no limits on dataset size -- even "on the fly" as you build a predictive model.
Apply the most popular exponential smoothing and Box-Jenkins ARIMA methods with seasonality to forecast time series, such as sales and inventory, from historical data. Use powerful multiple linear regression with variable selection, and data mining methods like k-nearest neighbors , and ensembles of regression trees and neural networks.
Use classical discriminant analysis and logistic regression , and data mining methods like k-nearest neighbors , naive Bayes , and ensembles of classification trees and neural networks. Use a Ribbon interface, with Wizard-style dialogs to guide you through model and option selections. Over 30 example datasets give you practice with a range of prediction, classification, time series forecasting, and affinity analysis problems.
If our built-in documentation isn't enough, scores of textbooks for MBA analytics courses use Analytic Solver software throughout, with step-by-step instructions and example models. Our Constraint Wizard helps you think through and then define the right constraints for your optimization model. Guided Mode takes you step-by-step through automatic diagnosis of your optimization model, recommended Solver Engines, and interpreting result messages.
Only Frontline Solvers offer quick access to Tech Support via Live Chat from inside Excel -- automatically passing error information to our support reps. Your plug-in Solver engines will work with all our Platform products. Textbooks If our built-in documentation isn't enough, scores of textbooks for MBA analytics courses use Analytic Solver software throughout, with step-by-step instructions and example models.
Wizards Our Constraint Wizard helps you think through and then define the right constraints for your optimization model. Our Distribution Wizard does the same for probability distributions in your simulation model. Guided Mode Guided Mode takes you step-by-step through automatic diagnosis of your optimization model, recommended Solver Engines, and interpreting result messages.
Auto-Help Mode steps in only when a problem arises. Cost Effective Pricing Your Analytic Solver annual license covers your use across devices: office computer, laptop and home PCs, and "in the cloud" -- using Excel for Windows, Excel for Macintosh, and Excel for the Web but only one at a time. A successful model can earn back the software license cost many times over!
Click here and get a Course Code from your instructor. Completing the form below dishonestly will lead to complete loss of your license and support. Download Frontline Solvers for Excel All fields are required To ensure you get value from your free trial, a Frontline rep will contact you to understand your goals and set problem size parameters for your trial license.
Already registered? By checking this box, I indicate that I have read and agree to the Frontline Systems license agreement for downloaded software. Email Address Use Microsoft or business email address to simplify logins later. Login password At least 7 printable characters that you can remember.
Company or University. Upgrading from the basic Excel Solver? Use existing Solver models and VBA macros as-is, but solve faster -- just open your workbook and solve. Upgrade Premium Solver Platform for Windows to handle stochastic and robust optimization , all the way to full-power predictive and prescriptive analytics.
Handle problems with up to 8, 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. Our Constraint Wizard helps you think about and define constraints. 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. 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.
We are the technology source in this area for some of the world's largest software companies. We developed both the Solver for optimization in Microsoft Excel, and the Extreme Speed feature - for high-speed simulation - in Oracle's Crystal Ball. We have an year history of technology "firsts" in this field. Our advanced Solvers are proven in use by nearly , people. We count over five thousand companies as customers, many of them Fortune and Global firms.
Our software is also the overwhelming favorite tool for teaching these methods to MBA students in a thousand universities worldwide. More than any other vendor, we've made this technology easy to use by smart people who aren't specialists in "operations research" or "management science.
Optimization is a tool with applications across many industries and functional areas. More than ninety small, but fully functional, example models are included with a free trial.
Used at Leading Companies Around the World The top companies of virtually every major industry have used Frontline Solvers either inside Excel or in an application outside Excel using our SDK: Along with more than 5, other successful smaller companies. The number one choice to teach around the world More top educational organization teach optimization and simulation with, and more students learn with, Frontline Solvers than any other competing alternative including: Plus hundreds of other programs around the world.
No one else comes close. Users Love Frontline's Solvers Here are just a few stories from our over 5, corporate and university users. USA The package seemed to go way beyond my wildest dreams.
Then I discovered Solver and all the stuff I had done before after months of programming and sweat was there at my fingertips. The packages seemed to go way beyond my wildest dreams.
And all the other little extra bits were there as well at the click of a button - non-negative and integer coefficients, constraints, and some other bits I have yet to use. And the thing just works! So now in my daily work I might propose a model for the change of the dry matter or the color of firmness of kiwifruit over time and use Solver to fit it to a large data set. The models typically involve 10 to 20 parameters many of which are the same for all sets of fruit but some are set-specific.
For example the time of reaching maturity may vary from orchard to orchard of course so that one may need to have a different value for each orchard. But with the tools of Excel available that is easy. So do I use Solver? Do I like it? I Love it! Could I do my job without it? No way! Indirectly the New Zealand kiwifruit industry has benefited immensely form Solver. So have I! In my very first project, Premium Solver was the central tool to do research.
The project analyzes the shifts of income in the agricultural sector of the state of North-Rhine Westphalia through the implementation of the Renewable Energies Sources Act. We set up a typical farm model with resources and constraints, namely arable land, animal population, crop cultivation, work force availability, market prices for feed and farming products etc. The number of variables and constraints became so large that a standard solver would not suffice — no problem, however, for the Premium Solver.
We could calculate which direction of production a farmer would choose given the current regulatory framework, and, more importantly, which parameters influenced his decisions the most. It was also very easy to integrate with Excel. This would have cost me double the time if I would have done it in the classical way.
I use Solver mainly for curve fitting any type of model , roots finding for simultaneous equations, maximizing functions. The result is a truly impressive product.
0コメント