Share with your friends


Analytics Magazine

Frontline shipping V. 2017 of Solvers for Excel and Analytic


“We’re making advanced analytics power tools and learning aids accessible to every business analyst,” says Daniel Fylstra, Frontline’s president and CEO. “Our users can build models with point-and-click ease of use, while taking advantage of the most advanced analytic algorithms and methods.”

In this release, Frontline is making available to all users Analytic Solver Basic V2017, a new version of its Analytic Solver Platform for Education product, formerly offered only for university MBA programs and used to learn by hundreds of thousands of students. Analytic Solver Basic includes every feature of Frontline’s analytics software, but handles only limited-size models and data sets, suitable for learning. (All of the 100+ example models and data sets included with the software can be used.) A software license is just $250 per year and includes both the desktop version and access to Paired with Solver Academy, Frontline’s new Open edX-based online learning platform, Analytic Solver Basic offers a way for business analysts to gain “advanced analytics ninja” skills.

Analytic Solver Basic gives the user an ongoing “free trial” opportunity for all the large-capacity products that Frontline offers. Users can simply create or open models or data sets larger than Analytic Solver Basic’s limits – and run them. The software enters “Test Run Summary Only” mode, and runs the problem but delivers only summary information such as the final objective in optimization or key statistics in simulation/risk analysis, then recommends the best upgrade option. After a simple, point-and-click upgrade step, the user has both the large-capacity product and Analytic Solver Basic, with its ongoing “free trial” of other functions.

Also in this release, Frontline has implemented a new cloud-based software licensing system, similar to the approach taken by Adobe Systems. Users can now install and use Frontline’s software on multiple computers, such as a desktop, laptop, home PC or virtual machine – but only one of these at a time. A multi-user license option enables organizations to share a license among multiple users and multiple machines, without having to run a special “license server.” Licenses can be used while disconnected from the Internet, for lengths of time specific to the license.

The V2017 release features further significant enhancements to Frontline’s popular Evolutionary Solver for optimization, focusing on the most difficult non-smooth, non-convex models with integer variables.

The new release features support for industry-standard PMML (Predictive Model Markup Language) for Analytic Solver’s full range of classification, prediction, and time series forecasting methods, as well as PMML extensions for text mining. Other data mining enhancements include:

  • Ability to create ensembles of any combination of six different classification methods or four different prediction methods.
  • Direct use of categorical variables in many predictive algorithms that, in other analytics software, can use only continuous variables
  • Ability to “fit,” store and apply to new data a wide range of data transformation and unsupervised learning tools, such as PCA and clustering.
  • Enhanced neural networks with any number of layers, and better scaling, training and activation function options,
  • Enhanced reports and charts, especially for model evaluation, and simplified functions to apply predictive models in Excel worksheets.

Other enhancements include support for very high resolution (4K) monitor, and support for a new version of Tableau Software’s Web Data Connector.

In this release, Frontline has simplified its product line and renamed most products. Frontline continues to offer eight plug-in, large-scale Solver Engines for optimization, upgraded in the new release, that work with Analytic Solver Optimization and Analytic Solver Comprehensive.

The new V2017 release is available at

Related Posts

  • 56
    As the Big Data Analytics space continues to evolve, one of the breakthrough technologies that businesses will be talking about in the coming years is prescriptive analytics. The promise of prescriptive analytics is certainly alluring: it enables decision-makers to not only look into the future of their mission critical processes…
    Tags: analytics, prescriptive, data, software
  • 50
    Use of the term “business analytics” is being used within the information technology industry to refer to the use of computing to gain insight from data. The data may be obtained from a company’s internal sources, such as its enterprise resource planning application, data warehouses/marts, from a third party data…
    Tags: analytics, data, predictive, prescriptive
  • 49
    March/April 2014 Properly deployed, predictive and other forms of advanced analytics can yield crucial insights for exploration and production companies. By Warren Wilson Predictive analytics software has become increasingly attractive as it has increased in capability and fallen in price. It is becoming so powerful that many enterprises consider it…
    Tags: data, analytics, predictive, software, advanced
  • 49
    Gurobi Optimization recently introduced Gurobi Optimizer v7.0, with higher performance and powerful new modeling capabilities.
    Tags: support, optimization, users, enhancements, multiple, software, analytics
  • 49
    November/December 2014 The marriage of two “natural resources” – hydrocarbons and data – will transform unconventional oil development. By Atanu Basu (right), Daniel Mohan and Marc Marshall Known-knowns, known-unknowns and unknown-unknowns. Donald Rumsfeld’s notable turn of phrase is an apt characterization of where we are with unconventional oil development today.…
    Tags: data, analytics, sets, prescriptive, predictive

Analytics Blog

Electoral College put to the math test

With the campaign two months behind us and the inauguration of Donald Trump two days away, isn’t it time to put the 2016 U.S. presidential election to bed and focus on issues that have yet to be decided? Of course not.


Holiday Retirement earns Edelman Award

Holiday Retirement won the 2017 Franz Edelman Award for Achievement in Operations Research and the Management Sciences from INFORMS for its use of operations research (O.R.) to improve the pricing model for its more than 300 senior living communities across the United States. Read more →

U.S. Air Force and Disney receive the 2017 INFORMS Prize

The U.S. Air Force and The Walt Disney Company both received the 2017 INFORMS Prize for their pioneering and enduring integration of operations research (O.R.) and analytics programs into their organizations. The prizes were presented at the INFORMS Conference on Business Analytics & Operations Research in April in Las Vegas. Read more →

Air Force Academy’s O.R. program saluted

The U.S. Air Force Academy won the 2017 UPS George D. Smith Prize for its operations research (O.R.) program, which prepares graduates to become frontline O.R. practitioners as analysts in the Air Force. The program exposes more than 50 percent of cadets to at least one O.R. course and provides cadets the opportunity to graduate with a Bachelor of Science degree in O.R. Read more →




2017 INFORMS Healthcare Conference
July 26-28, 2017, Rotterdam, the Netherlands


CAP® Exam computer-based testing sites are available in 700 locations worldwide. Take the exam close to home and on your schedule:

For more information, go to