Top
 

@RISK for Excel 7.x (All Editions)

@RISK performs risk analysis using Monte Carlo simulation to show you many possible outcomes in your Microsoft Excel spreadsheet—and tells you how likely they are to occur. New in version 7 is the ability to build efficient frontiers, use copulas and a host of usability enhancements.

Picture of @RISK for Excel - Standard
@RISK for Excel - Standard

@RISK performs risk analysis using Monte Carlo simulation to show you many possible outcomes in your Microsoft Excel spreadsheet—and tells you how likely they are to occur.

SKU: PAL10ASL
$1,295.00
$1,230.25
Picture of @RISK for Excel - Professional
@RISK for Excel - Professional

Building on the Standard Edition, @RISK professional Includes Monte-Carlo simulation, distribution fitting and goal seek functionalities. New in version 7 is the ability to build efficient frontiers, use copulas and a host of usability enhancements.

SKU: PAL10BSL
$1,695.00
$1,610.25
Picture of @RISK for Excel -  Industrial
@RISK for Excel - Industrial

@RISK Industrial Includes Monte-Carlo simulation, distribution fitting, time-series fitting and optimization functionalities. New in version 7 is the ability to build efficient frontiers, use copulas and a host of usability enhancements.

SKU: PAL10CSL
$2,295.00
$2,180.25
Products specifications
Min. OS Requirement Windows XP
Language 6 languages (EN, FR, JP, ES, CN, KR)
Add-In Requires Excel
Available for Mac No, requires Parallels Emulation
Price includes 1st year maintenance
Requires other Software? Requires Microsoft Excel to run
Scripting Support Built In
Simulation Monte Carlo
VBA Support Built In
CSV Support
XML Support
Distribution Fitting Built In
User Defined Distributions
Distribution Gallery 48 base distributions (38 Continuous + 10 Discrete) with 20 that can have alternate parameters
Monte Carlo Sampling
Latin HyperCube Sampling
Process Capability (6 Sigma)
Sensitivity Analysis
Tornado Analysis
Precision Control
Probability calculations functions
Correlation
Correlation Methods Normal + Non-Normal Copulas
SIP Math Support Import/Export using a 3rd Party Macro. Call for more info.
Decision Trees Available as an additional option. We recommend : Palisade PrecisionTree
Stats Tools Available as an add-on option. We recommend Palisade StatsTools
MS Project Support - [Professional and Industrial Editions Only]
Charting Built In
Charts can be customized
Automated Reporting
Multi-Core Support
Developper Kit - [Professional and Industrial Editions Only]
Example Models
Network Licensing Available
Data Base Integration 30+ Data Sources with CDATA Connectors
Supported DBs Standard ODBC sources from Excel + 3rd party connectors
User Defined Distribution Library Distributions can be generated and saved to an SQL or SQL Express DB and can be made available to other @RISK users who have access to the repository
Linear Optimization Methods - [Industrial Edition Only]
Non-Linear Optimization Methods - [Industrial Edition Only]
Requirements / Soft Constraints - [Industrial Edition Only]
Max Requirements - [Industrial Edition Only]
Max Decision Variables - [Industrial Edition Only]
PSI support - [Industrial Edition Only]
Solution Filtering - [Industrial Edition Only]
Efficient Frontier - [Industrial Edition Only]
Scenario Analysis Support Must be setup as separate submodels using functions. Functions exist to support multiple scenarios and to track results separately
Convergence Testing - [Industrial Edition Only]
Genetic Algorithims - [Industrial Edition Only]
Ranges for Decision Variables - [Industrial Edition Only]
Main Solver Engine - [Industrial Edition Only]
Optimize multiple statistics Optimization can be done on 11 different statisics (Mean, Variance, Standard Deviation, Skewness, Kurtosis, Percentile, Min/Max, Mode and Range) (Industrial Only)
Optimization Goal Types Minimize, Maximize & Set Target (Industrial Edition Only)
Static Optimization Support - [Industrial Edition Only]
Dynamic Optimization Support
Stochastic Optimization Support - [Industrial Edition Only]
Time Series as distributions - [Industrial Edition Only]
Time Series Fitting - [Industrial Edition Only]
Time Series Methods 11 Methods (AutoRegression, GBM, Moving Average) (Industrial Edition Only)
Multiple Linear Regression Provided using Palisade StatTools (Industrial Edition Only)
Seasonal Methods Seasonal ARMA & GBM (Industrial Edition Only)
Non-Seasonal Methods AR(1&2), MA(1&2) (Industrial Edition Only)
GBM Support Univariate, Multivariate and Seasonal (Industrial Edition Only)
Cubic Spline
Heteroscedastic Models ARCH, GARCH11, EGARCH11 and APARCH11 (Industrial Edition Only)
ARIMA Support Partial Support for ARMA (Industrial Edition Only)
AutoARIMA
Data Sensoring - [Industrial Edition Only]
Time-Series Event Support
Define Time Series All available methods can be configured manually using parameters (Industrial Edition Only)
Markov Chains
Automatic Data Transform - [Industrial Edition Only]
Manual Data Transform Methods - [Industrial Edition Only]
Manual Deseasonalization - [Industrial Edition Only]
Manual Detrending - [Industrial Edition Only]
Visualize Simulated Output - [Industrial Edition Only]
Exception Reporting - [Industrial Edition Only]
Time Series Scenario Analysis
Error Measures
Time Series Fit Criteria Akaike and Baysean Information Criteria (Industrial Edition Only)
Product description

@RISK Simulation and Optimization Add-In for Excel

 

@RISK is a complete risk analysis & optimization solution for Excel that allows for the best decision making under uncertainty.

@RISK analyzes thousands of different possible outcomes, showing you the likelihood of each occurring. Uncertain factors are defined using over 35 probability distribution functions, which accurate describe the possible range of values your inputs could take. @RISK 6.x is fully compatible with 64-bit Excel 2010. 64-bit technology enables Excel and @RISK to access much more computer memory than ever before. This allows for vastly larger models and greater computational power. In addition, @RISK has been fully translated into Spanish, German, French, Portuguese, Japanese and .

New in @RISK 6.x

New @RISK version 6.x includes a wide range of improvements, including powerful new integration with Microsoft Project that allows you to perform risk analysis and Monte Carlo simulation on your Microsoft Project schedules – all from the @RISK for Excel platform! Other new features include easier-to-understand tornado charts, better graphing options, improved distribution fitting, new distribution functions, and much more. The Industrial edition now adds the OptQuest solving engine to RISKOptimizer, and features simulation of time-series forecasts.

Integration with Microsoft Project

The new version of @RISK for Excel integrates with Microsoft Project, allowing you to perform all your risk modeling from the more flexible Excel environment. @RISK now imports your Project schedules into Excel so that you can use all of Excel’s formulas, and @RISK’s features, on your Project models. Excel becomes a front-end for your Microsoft Project schedule, linking directly to the underlying .MPP(X) file. Changes made in either Project or Excel are reflected in the other. When it’s time to run your Monte Carlo simulation, Microsoft Project’s scheduling engine is used for the calculations, ensuring accuracy.

Time Series Simulation

@RISK now offers a new set of functions for simulating time series processes, or values that change over time. Any future projection of time series values has inherent uncertainty, and @RISK now lets you account for that uncertainty by looking at the whole range of possible time series projections in your model. This is particularly useful in financial modeling and portfolio simulation.

@RISK for Six Sigma

 

A key application of @RISK is Six Sigma and quality analysis. Industries ranging from engine manufacturing to precious metals to airlines and consumer goods are using @RISK every day to improve their processes, enhance the quality of their products and services, and save money.

Whether it’s in DMAIC, Design for Six Sigma (DFSS), Lean projects, Design of Experiments (DOE), or other areas, uncertainty and variability lie at the core of any Six Sigma analysis. @RISK uses Monte Carlo simulation to identify, measure, and root out the causes of variability in your production and service processes and designs.

Six Sigma Capability Metrics in @RISK

@RISK allows you to define Upper and Lower Specification Limits and Target values for each output, and comes complete with a wide range of Six Sigma statistics and capability metrics on those outputs, like Cpk, Cp, Cpm, and much more. These metrics can be placed directly in your spreadsheet model, or appear in the @RISK Results Summary window. Output graphs show markers for LSL, USL, and Target values. The Industrial edition of @RISK adds RISKOptimizer to your Six Sigma analyses for optimization of project selection, resource allocation, and more.

 

Additional information
Products specifications
Min. OS Requirement Windows XP
Language 6 languages (EN, FR, JP, ES, CN, KR)
Add-In Requires Excel
Available for Mac No, requires Parallels Emulation
Price includes 1st year maintenance
Requires other Software? Requires Microsoft Excel to run
Scripting Support Built In
Simulation Monte Carlo
VBA Support Built In
CSV Support
XML Support
Distribution Fitting Built In
User Defined Distributions
Distribution Gallery 48 base distributions (38 Continuous + 10 Discrete) with 20 that can have alternate parameters
Monte Carlo Sampling
Latin HyperCube Sampling
Process Capability (6 Sigma)
Sensitivity Analysis
Tornado Analysis
Precision Control
Probability calculations functions
Correlation
Correlation Methods Normal + Non-Normal Copulas
SIP Math Support Import/Export using a 3rd Party Macro. Call for more info.
Decision Trees Available as an additional option. We recommend : Palisade PrecisionTree
Stats Tools Available as an add-on option. We recommend Palisade StatsTools
MS Project Support - [Professional and Industrial Editions Only]
Charting Built In
Charts can be customized
Automated Reporting
Multi-Core Support
Developper Kit - [Professional and Industrial Editions Only]
Example Models
Network Licensing Available
Data Base Integration 30+ Data Sources with CDATA Connectors
Supported DBs Standard ODBC sources from Excel + 3rd party connectors
User Defined Distribution Library Distributions can be generated and saved to an SQL or SQL Express DB and can be made available to other @RISK users who have access to the repository
Linear Optimization Methods - [Industrial Edition Only]
Non-Linear Optimization Methods - [Industrial Edition Only]
Requirements / Soft Constraints - [Industrial Edition Only]
Max Requirements - [Industrial Edition Only]
Max Decision Variables - [Industrial Edition Only]
PSI support - [Industrial Edition Only]
Solution Filtering - [Industrial Edition Only]
Efficient Frontier - [Industrial Edition Only]
Scenario Analysis Support Must be setup as separate submodels using functions. Functions exist to support multiple scenarios and to track results separately
Convergence Testing - [Industrial Edition Only]
Genetic Algorithims - [Industrial Edition Only]
Ranges for Decision Variables - [Industrial Edition Only]
Main Solver Engine - [Industrial Edition Only]
Optimize multiple statistics Optimization can be done on 11 different statisics (Mean, Variance, Standard Deviation, Skewness, Kurtosis, Percentile, Min/Max, Mode and Range) (Industrial Only)
Optimization Goal Types Minimize, Maximize & Set Target (Industrial Edition Only)
Static Optimization Support - [Industrial Edition Only]
Dynamic Optimization Support
Stochastic Optimization Support - [Industrial Edition Only]
Time Series as distributions - [Industrial Edition Only]
Time Series Fitting - [Industrial Edition Only]
Time Series Methods 11 Methods (AutoRegression, GBM, Moving Average) (Industrial Edition Only)
Multiple Linear Regression Provided using Palisade StatTools (Industrial Edition Only)
Seasonal Methods Seasonal ARMA & GBM (Industrial Edition Only)
Non-Seasonal Methods AR(1&2), MA(1&2) (Industrial Edition Only)
GBM Support Univariate, Multivariate and Seasonal (Industrial Edition Only)
Cubic Spline
Heteroscedastic Models ARCH, GARCH11, EGARCH11 and APARCH11 (Industrial Edition Only)
ARIMA Support Partial Support for ARMA (Industrial Edition Only)
AutoARIMA
Data Sensoring - [Industrial Edition Only]
Time-Series Event Support
Define Time Series All available methods can be configured manually using parameters (Industrial Edition Only)
Markov Chains
Automatic Data Transform - [Industrial Edition Only]
Manual Data Transform Methods - [Industrial Edition Only]
Manual Deseasonalization - [Industrial Edition Only]
Manual Detrending - [Industrial Edition Only]
Visualize Simulated Output - [Industrial Edition Only]
Exception Reporting - [Industrial Edition Only]
Time Series Scenario Analysis
Error Measures
Time Series Fit Criteria Akaike and Baysean Information Criteria (Industrial Edition Only)