Excel users gain extra power for advanced analytic models using data mining, text mining and predictive analytics, mathematical optimization, and simulation/risk analysis methods.
INCLINE VILLAGE, NV – April 6, 2016 – Frontline Systems is shipping a new product line release, Version 2016-R2 of its Solvers for Excel, including its flagship integrated product, Analytic Solver Platform, and its "professional entry-level" integrated product, Analytic Solver Pro. The release includes wide-ranging enhancements in Monte Carlo simulation and optimization technology, plus the ability to convert Excel analytic models into free-standing web and mobile applications.
“We’re fulfilling our promise of ‘no-compromise analytic power’ for Excel users,” said Daniel Fylstra, Frontline’s President and CEO. “Business analysts can build models with point-and-click ease of use, while taking advantage of the most advanced analytic algorithms and methods.” In just four months since release of Analytic Solver Platform V2016, Frontline has added functionality comparable to a years’ worth of many competitors’ offerings.
New Optimization Power in Evolutionary Solver
The new release features significant enhancements to Frontline’s popular Evolutionary Solver, focusing on models with integer variables – often yielding dramatically better solutions in a given amount of time, compared to Frontline’s previous releases and competitive products. These enhancements build on the SQP-GS (Sequential Quadratic Programming with Gradient Sampling) for local search, and Feasibility Pump algorithms introduced in Frontline Solvers V2016.
New Support for ‘Sparse Cubes’ in Dimensional Modeling
The new release also includes performance enhancements for multi-dimensional optimization and simulation models that use the Dimensional Modeling features of Analytic Solver Platform, first introduced in Frontline Solvers V2014, in the frequently-occurring case where multi-dimensional data is ‘sparse’. Memory use and time computing multi-dimensional formulas is dramatically reduced for these models.
New Correlation Methods in Monte Carlo Simulation
In Monte Carlo simulation, the V2016-R2 release supports correlation of uncertain variables with dissimilar distributions, using Gaussian, Student and Archimedean (Clayton, Frank and Gumbel) copulas – complementing existing support for rank-order correlation. Copulas for correlation are popular in quantitative finance models. All the methods are available are available via a simple point-and-click correlation dialog that allows the user to preview scatter plots showing how samples from uncertain variables will be generated and correlated.
New Support for Compound Probability Distributions
The new release also supports ‘compound distributions’ – often used in actuarial and insurance models – where samples are generated and aggregated from multiple instances of a probability distribution – called the ‘severity’ distribution. The number of instances can be a constant or a sample from another, discrete probability distribution, called the ‘frequency’ distribution. Nearly all of Analytic Solver’s 50+ analytic distributions can be used, and for many common distributions, the software uses analytic methods in lieu of repeated sampling for speed.
New Support for Tableau Web Data Connector
Excel Models Converted to Web and Mobile Apps
Support for Excel 2016, Excel Online and Excel for iPad
Frontline Solvers V2016-R2 supports Excel 2016, Excel 2013, Excel 2010 and Excel 2007 for Windows. Its “Publish to the Web” feature makes it possible to run even large-scale optimization and simulation models in Excel Online and Excel for iPad, as well as Google Sheets.
Frontline Systems Inc. (www.solver.com) is the leader in analytics for spreadsheets and the web, helping managers gain insights and make better decisions for an uncertain future. Its products integrate forecasting and data mining for “predictive analytics,” Monte Carlo simulation and risk analysis, and conventional and stochastic optimization for “prescriptive analytics.” Founded in 1987, Frontline is based in Incline Village, Nevada (775-831-0300).
Excel® is a registered trademark of Microsoft Corp. Tableau® is a registered trademark of Tableau Software. Analytic Solver® and RASON® are registered trademarks of Frontline Systems, Inc.