Share with your friends


Analytics Magazine

Analytic Solver Platform offers Excel users a total solution for predictive and prescriptive Analytics

Industry News

In January 2013, Frontline Systems is expected to begin shipping Version 12.5 of its Solvers for Excel, including a new flagship integrated product, Analytic Solver Platform. V12.5 also includes new versions of Risk Solver Platform, the leading tool for simulation risk analysis, conventional and stochastic optimization in Excel; subsets Premium Solver Platform, Premium Solver Pro and Risk Solver Pro; and XLMiner, the leading data mining add-in for Microsoft Excel. Analytic Solver Platform integrates all the capabilities of all these products, and adds new features such as visual data exploration and data mining methods applied to Monte Carlo simulation trial data.

“Our tagline for Analytic Solver Platform is ‘no-compromise analytics in Excel’,” says Daniel Fylstra, Frontline’s President and CEO. “Users enjoy the ease of use of Excel, and leverage their spreadsheet model-building experience, but they don’t compromise at all on functionality or performance.”

Analytic Solver Platform incorporates many of the most powerful algorithms for optimization, simulation and data mining available, and exploits new technology in CPUs, GPUs and cloud servers to a greater degree than “enterprise analytics software” costing five to 10 times more.

Frontline’s Solvers for Excel are upward compatible from the Solver included in Excel, which Frontline developed for Microsoft, and improved in Excel 2010 for Windows and Excel 2011 for Macintosh. Users can solve problems hundreds to thousands of times larger than the basic Excel Solver, at speeds anywhere from several times to hundreds of times faster, and they can solve completely new types of problems. Frontline’s Solvers V12.5 work with Excel 2007, Excel 2010 and Excel 2013, which recently became available to Microsoft’s corporate customers and will be available at the retail level in early 2013.

Analytic Solver Platform is the first software to bring the power of data mining and visual data exploration to the analysis of Monte Carlo simulation trial data. Frontline’s and other vendors’ Monte Carlo software has offered histograms, tornado charts and descriptive statistics summarizing simulation results, but they’ve had only limited visualization for multivariate data, and aside from basic sensitivity analysis, they have lacked tools to discover patterns in simulation data. This has changed in Analytic Solver Platform, which makes all the data visualization and algorithmic tools of XLMiner available for analysis of simulation trial data placed on a worksheet.

The algorithmic methods in Analytic Solver Platform represent “rocket science” for many users, who want to gain business advantage from these methods, but may be unsure whether they can learn and make effective use of this power. For years, Frontline Solvers have offered uniquely helpful features such as a Distribution Wizard, Constraint Wizard and Guided Mode for optimization, but Analytic Solver Platform goes even further – bringing “Active Support” for analytics directly into Microsoft Excel.

Frontline Systems, Inc. ( is a leading developer of optimization and simulation software, and the leader in spreadsheet-based software for both conventional and stochastic optimization.


Fighting terrorists online: Identifying extremists before they post content

New research has found a way to identify extremists, such as those associated with the terrorist group ISIS, by monitoring their social media accounts, and can identify them even before they post threatening content. The research, “Finding Extremists in Online Social Networks,” which was recently published in the INFORMS journal Operations Research, was conducted by Tauhid Zaman of the MIT, Lt. Col. Christopher E. Marks of the U.S. Army and Jytte Klausen of Brandeis University. Read more →

Syrian conflict yields model for attrition dynamics in multilateral war

Based on their study of the Syrian Civil War that’s been raging since 2011, three researchers created a predictive model for multilateral war called the Lanchester multiduel. Unless there is a player so strong it can guarantee a win regardless of what others do, the likely outcome of multilateral war is a gradual stalemate that culminates in the mutual annihilation of all players, according to the model. Read more →

SAS, Samford University team up to generate sports analytics talent

Sports teams try to squeeze out every last bit of talent to gain a competitive advantage on the field. That’s also true in college athletic departments and professional team offices, where entire departments devoted to analyzing data hunt for sports analytics experts that can give them an edge in a game, in the stands and beyond. To create this talent, analytics company SAS will collaborate with the Samford University Center for Sports Analytics to support teaching, learning and research in all areas where analytics affects sports, including fan engagement, sponsorship, player tracking, sports medicine, sports media and operations. Read more →



INFORMS Annual Meeting
Nov. 4-7, 2018, Phoenix

Winter Simulation Conference
Dec. 9-12, 2018, Gothenburg, Sweden


Applied AI & Machine Learning | Comprehensive
Starts Oct. 29, 2018 (live online)

The Analytics Clinic
Citizen Data Scientists | Why Not DIY AI?
Nov. 8, 2018, 11 a.m. – 12:30 p.m.

Advancing the Analytics-Driven Organization
Jan. 28–31, 2019, 1 p.m.– 5 p.m. (live online)


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