Frontline Solver Platforms V2014 Bring Multi-Dimensional Analytic Modeling to Excel Highline Excel 2013 Class Video #35: Excel 2013 PivotTables: Basic To Advanced 58 Examples
Incline Village, NV (PRWEB) December 19, 2013
Frontline Systems is shipping Version 2014 of its Solvers for Excel, including its new flagship integrated product, Analytic Solver Platform — featuring a new, powerful facility for multi-dimensional analytic modeling in Excel. V2014 also includes new versions of Risk Solver Platform, the leading tool for simulation / risk analysis and stochastic optimization in Excel; Premium Solver Platform, the leading tool for conventional optimization in Excel; subsets Premium Solver Pro and Risk Solver Pro; and XLMiner, the leading data visualization and data mining add-in for Microsoft Excel.
“Multi-dimensional spreadsheet modeling is another key step in our continuing effort to ‘democratize analytics’,” said Daniel Fylstra, Frontline’s President and CEO. “Excel with PowerPivot is already an industrial-strength tool for slicing and dicing multi-dimensional data from a variety of data sources. Now Excel users can easily create multi-dimensional models, with formulas that reflect the dynamics of existing and future business situations, and easily link those models to Pivot Table data.”
Upward Compatible from Excel Solver, works with Excel 2013
Frontline’s Solvers 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 V2014 work with Excel 2007, Excel 2010, and Excel 2013 for Windows.
Dimensional Modeling: Enterprise Modeling Features in Excel
Dimensional modeling in Analytic Solver Platform V2014, Risk Solver Platform V2014, and Premium Solver Platform V2014 enables users to 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 — giving an ordinary spreadsheet the capabilities found in enterprise business intelligence systems, without the high cost and learning curve of those systems.
Frontline’s PSI Interpreter extends ordinary Excel formulas to operate over multi-dimensional ‘cubes’, and integrates easily with Excel PivotTables and PowerPivot for both input and output data. A formula such as =A1+B2*C3, where B2 and C3 (say) are defined with the new PsiCube() function, can compute thousands of values across up to eight dimensions. Double-clicking a cube formula displays a built-in multi-dimensional cube result viewer with drag-and-drop pivoting of dimensions. Other Psi functions can write cube results to cell ranges.
Dimensional modeling can be used for ‘what-if’ and sensitivity analysis, and for defining optimization models and Monte Carlo simulation models. Parametric dimensions can be used to perform multiple sensitivity analysis, simulation, or optimizations runs for all combinations of values from selected dimensions, yielding results via built-in reports and charts, or in Excel PivotTables and PivotCharts.
New Levels of Help and User Support in Analytic Software
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 V2014 goes even further ? bringing “Proactive Support” for analytics directly into Microsoft Excel.
When a user encounters a common problem or error condition in any of Frontline Solvers V2014, special dialogs and Help appear, the desktop software reports the problem in real-time to Frontline’s servers, and the user can be connected immediately via “live chat” to Frontline’s technical support ? bypassing the delays and missing information characteristic of traditional phone and email support. A series of user errors automatically triggers a support ticket in Frontline’s online Help Desk, so tech support staff can follow up proactively.
New Performance Enhancements
Frontline Solvers have always offered the fastest Monte Carlo simulation in Excel, and the fastest available solvers for mathematical optimization. V2014 focuses on faster interactive performance, when starting up Excel, switching among worksheets and multiple open workbooks, and working with large models containing thousands to hundreds of thousands of formulas, constraints in optimization, or distributions in simulation.
The V2014 release also incorporates all the performance enhancements introduced recently in the PSI Interpreter for commonly-used Excel functions, the Evolutionary Solver in its use of multi-core CPUs for global search and massively parallel GPUs in local search, and the first commercial implement