Everything You Need for Insights and Better Decisions

Start Easily with One Tool, Upgrade to the Integrated Suite

Learn just what you need today, knowing you can upgrade and get the benefits of deep integration in Analytic Solver Pro and Platform.

Choose our Pro level products for problems you expect to solve in Excel. Choose our Platform products for greater power, matching far more expensive enterprise solutions.

Easily share your solution: Move your model from desktop Excel to Office 365 and Power BI, Google Sheets, or a custom application running on-premise or in the cloud.

Find the Best Way to Allocate Scarce Resources

Upgrade the Excel Solver with the World's Most Powerful Optimizers

100% upward compatible from the Solver in Excel - just open your workbook and solve, then expand to handle thousands of variables and constraints.

Guided Mode automatically diagnoses your model, finds (and even fixes) modeling problems, and helps you select the best optimization method and Solver Engine.

Solve every type and size of problem, using methods from linear/mixed-integer programming, nonlinear and global optimization, genetic algorithms and local search.

Understand, Quantify, and Control Your Risks

Explore Thousands of Scenarios in Seconds

Start with any what-if model - easily add uncertain inputs with our Distribution Wizard, or use your historical data for fitting or resampling.

Get instant charts and statistics that show the full range of outcomes, and what factors really matter for the results you care most about.

Find better choices for the factors you can control, using parameterized simulations, simulation optimization, and industry-leading stochastic optimization.

Free XLMiner Analysis ToolPak for Excel & Google

Find Hidden Relationships, Make Better Predictions

Point-and-Click Wizards Make You a Data Mining Whiz

Sample data from virtually any database, from Oracle or SQL Server to Excel's own PowerPivot in-memory database handling 100 million rows or more.

Visualize your data with multiple linked charts, data-driven colors, panels, zooming, brushing and more. Easily transform, cluster, and identify or extract features from data.

Point and click to use text mining, time series forecasting, regression, ensembles of classification and regression trees or neural networks, affinity analysis and more.

Easily Add Analytics to Your Applications

For Desktop, Server, Mobile and Cloud-based Apps

Easily use Analytics in your C++, C#, VB, Java, PHP and JavaScript applications, defining your model in code with an object-oriented API that's also a Web Services API.

Easier: Load, update and solve Excel workbook models from your application, running on-premise or in the cloud, on Azure or AWS.

Easiest of all: Define your model in our high-level RASON® modeling language, and solve on your desktop or server, or via our REST API in your web or mobile app.

Your Next Step Towards Analytics Results

Free Software Trial White Papers Example Models Tutorials and Videos

Tutorials, Videos and Webinars

Optimization Tutorial

Solvers, or optimizers, are software tools that help users determine the best way to allocate scarce resources. Examples include allocating money to investments, or locating new warehouse facilities, or scheduling hospital operating rooms. In each case, multiple decisions need to be made in the best possible way while simultaneously satisfying a number of requirements (or constraints). The "best" or optimal solution might mean maximizing profits, minimizing costs, or achieving the best possible quality. Here are some representative examples of optimization problems:

  • Finance/Investment: Cash management, capital budgeting, portfolio optimization.
  • Manufacturing: Job shop scheduling, blending, cutting stock problems.
  • Distribution and Networks: Routing, truck loading, fleet scheduling.

Simulation/Risk Analysis Tutorial

Quantitative risk analysis is the practice of creating a mathematical model of a project or process that explicitly includes uncertain parameters that we cannot control, and also decision variables that we can control. Monte Carlo simulation explores thousands of possible scenarios, and calculates the impact of the uncertain parameters and the decisions we make on outcomes that we care about -- such as profit and loss, investment returns, environmental results and more. Industries where simulation and risk analysis are heavily used include:

  • Pharmaceuticals: Modeling R&D and clinical trials
  • Oil & Gas: Modeling drilling projects
  • Insurance: Modeling frequency and types of claims

Data Mining Tutorial

Data mining software tools help users find patterns and hidden relationships in data, that can be used to predict behavior and make better business decisions. A machine learning algorithm "trained" on past observations can be used to predict the likelihood of future outcomes such as customer "churn'" or classify new transactions into categories such as "legitimate" or "suspicious". Other methods can be used uncover "clusters" of similar observations, or find associations among different items. Common applications include:

  • Financial Services: Fraud detection, good vs. bad credit risks
  • Direct Marketing: Segmentation to improve response rates
  • Electoral Politics: Identifying "most persuadable" voters

What's New

Monday, April 4, 2016 - 21:13
We're pleased to introduce Version 2016-R2 of Frontline Solvers for Excel, including our flagship integrated product Analytic Solver Platform, and our professional entry-level integrated product Analytic Solver Pro.  In recent years we've been offering "Christmas in July" -- a major release near year-end, and another major new release in mid-year -- but in 2016, July has moved up to April.  This...