Frontline Systems, Excel Solver, optimization software, Solver Excel, simulation software
Solver.com
From Frontline Systems, developers of the Excel Solver.

Solver tutorials

Learn to use optimization for resource allocation, and Monte Carlo simulation for risk analysis of your models.


 

Contact:  Dan Fylstra
Frontline Systems 775-831-0300
press@solver.com 

PSI TechnologyNews Release Backgrounder

News Release - Risk Solver V7.0 Fact Sheet

Risk Solver™ V7.0 Fact Sheet

INCLINE VILLAGE, NV -- April 27, 2007 -- Frontline Systems' new Risk Solver™, is the first new 'industrial strength' Monte Carlo simulation tool for Excel in 15 years.  This fact sheet briefly summarizes its capabilities.  A fully functional, free trial version can be downloaded at Frontline's Website www.solver.com.

Special Capabilities:  High-speed Interactive Simulation, support for Probability Management, breakthrough performance on simulation optimization, runtime support with Risk Solver Engine.

Excel Versions and Features:  Excel 2007, Excel 2003, Excel XP, Excel 2000 on Windows Vista, XP, 2000. Models may have unlimited worksheets, rows and columns in one workbook.

Random Number Generators:  Park-Miller, CMRG, WELL1024, Mersenne Twister.

Sampling:  Standard Monte Carlo, Latin Hypercube, Sobol numbers (randomized QMC).

Probability Distributions:

Beta Laplace Pareto2 Bernoulli DisUniform
BetaGen Logistic Pearson5 Binomial General
BetaSubj LogLogistic Pearson6 Geometric Histogram
Cauchy LogNormal Pert HyperGeo MVLogNormal
ChiSquare LogNorm2 Rayleigh IntUniform MVNormal
Erf MaxExtreme Student Logarithmic Resample
Erlang MinExtreme TriangGen NegBinomial Shuffle
Exponential Myerson Triangular Poisson Sip
Gamma Normal Uniform Cumul Slurp
InvNormal Pareto Weibull Discrete Certified

 

Statistics and Risk Measures:

Percentiles Std. Deviation Max Semi Variance Mean Confidence
Mean Skewness Range Semi Deviation Std. Dev. Conf.
Mode Kurtosis Target Value at Risk Trials for Conf.
Variance Min Mean Abs. Dev Conditional VaR Percentiles

 

Correlation:  Multiple rank-order correlation matrices for dissimilar distributions. Automatic adjustment to positive semidefinite matrices prioritizes user-specified correlations.

Sensitivity Analysis:  Tornado charts based on Moment Correlation or Rank Correlation. Error Filtering: Trials with errors are excluded from charts, statistics and percentiles. Normal or error trials can be displayed. Users can include/exclude trials satisfying any conditional tests. Charts:  2-D and 3-D charts of PDF, CDF, Reverse CDF for uncertain variables; Frequency, Cumulative Frequency, Reverse Cumulative Frequency, Sensitivity for uncertain functions, with colors, titles, legends, gridlines, axis labels and formatting. Automatic or manual bin counts.

Distribution Fitting:  Fit user-supplied data (for uncertain variables), or simulation results (for uncertain functions) to any of 27 continuous and discrete probability distributions, using Chi Square, Kolmogorov Smirnov or Anderson Darling goodness-of-fit tests. Display fitted overlay, P P, Q Q, and Difference charts.

Excel Functions:  80 new functions for probability distributions, statistics and risk measures.

VBA Object Model:  Problem, Model, Solver, Engine, Parameter, Variable, Function, Statistic, Sparse Matrix, Distribution objects with a full set of properties and methods.

< Back to Press Releases - Current Products

< Back to Analysts and Press Start Here


To Learn More:

For instant access to our white papers, example models, full-text User Guides, and to download free 15-day trial versions of our software products whenever you're ready, register now with no obligation.

User type
Email address
Name
First Last
Company
University
Phone

Trial version passwords are sent to the above email address. Our Privacy Policy protects you.