Click here to return to the home page
Change Currency      
 
Search:

@RISK Professional [5.0 Full Product, Includes Mandatory Gold Support (1-Year) Win32]


Reference Number: PRS. 255674
Availability: Usually delivered within 5 working days
Media: Licence

£1136.68 (Ex. VAT, Free UK mainland delivery!)
Buy Now

Not what you're looking for? Use our free sourcing request service.

@RISK uses Monte Carlo simulation to show you many possible outcomes in your Microsoft Excel spreadsheet – and tells you how likely they are to occur. This means you can judge which risks to take and which ones to avoid. With @RISK, you can answer questions like, “What is the probability of profit exceeding £10 million?” or “What are the chances of losing money on this venture?”


General
  • The separate Model and Results Summary Windows of @RISK 4.0 and 4.5 are now integrated into the Excel window.
  • New @RISK Settings toolbar in Excel provides quick access to simulation settings.
  • Graphs of simulation results and inputs can link directly to the cells they reference in Excel with "callout" windows.
  • Nearly all modeling operations can be performed via drag and drop or simple clicks on the toolbar.
  • Navigate through Results in Excel with <Tab> Key to move through @RISK inputs and outputs in open workbooks, with graphs pointing at the cell where the input or output is located.
  • Support for versions of Microsoft Excel through Excel 2007, including the larger worksheet size of Excel 2007.
  • All graphs and reports update live as a simulation runs
  • Window selector allows tiling, minimising, closing, activating etc. of all open @RISK windows

Model Window

  • Distribution functions can be edited directly in the Model window
  • Graph thumbnails in list graphically display input distributions
  • Drag thumbnail graph off Model window to expand to full-size graph
  • Statistics shown in table can be customised
  • Report of Model Definition in Excel includes graph thumbnails
  • Inputs are organised by categories, with default categories made based on row or column names in workbook
  • Clicking or tabbing on an input in the table moves to relevant cell in Excel and displays graph

Adding Outputs

  • Existing outputs and output ranges may be edited or deleted directly over Excel
  • Properties dialog can be used to enter property functions

Correlations

  • Correlations between distributions are quickly defined in matrices that pop-up over Excel
  • Dynamic scatter plots of correlated inputs graphically display correlated samples between two inputs
  • Correlation coefficients in matrix can be adjusted using slider
  • Correlation Matrices defined in the @RISK interface can be located anywhere in Excel, not just on the @RISK Correlations sheet
  • Correlated Time Series with Instances can be quickly set up to correlate sets of similar distributions which each use the same matrix
  • Scatter plot matrix shows correlations generated between inputs in a matrix after a run

Distribution Fitting

  • Data sets for fitting now reside in Excel
  • Up to 10 overlays of different fitted distribution in a single graph
  • Fit Manager tracks multiple fitted data sets in a model

Define Distributions

  • Window stays up as you move to different cells to define or edit @RISK distribution functions
  • <Tab> Key moves through cells in open workbooks and worksheets with distribution functions
  • Edit functions directly in formula or in argument panel
  • Up to 10 overlays of different distribution functions
  • Graph settings and overlays maintained when returning to define distribution for a cell
  • Separate argument panels for graph and overlays.
  • Context sensitive (F1) help for each distribution function type.
  • Properties dialog can be used to enter property functions

Simulation and Sampling

  • Demo mode updates Excel, graphs and reports every iteration
  • Eight random number generators available
  • Auto-stop maximum iterations now 50,000
  • New progress window reports additional run statistics and allows changing settings during run
  • New Performance Monitor for @RISK Accelerator multi-CPU support
  • Excel normal recalculation mode (standard or monte carlo) can be selected from the toolbar
  • RiskStatic property function can store value to be returned from a distribution in a normal Excel recalculation
  • Alternatively mean, mode, median or a percentile can be returned from a distribution in a normal Excel recalculation

Convergence Monitoring

  • New algorithm based on user-defined tolerance and confidence interval settings, or on mean, Std. deviation, or percentile.
  • User selectable statistics to test during monitoring
  • Can be applied globally for all outputs or individually by output using the RiskConvergence property function

Results Window

  • Graph thumbnails in list graphically display simulated distributions
  • Drag thumbnail graph off Results window to expand to full-size graph
  • Statistics shown in table can be customised
  • Report of Results Window in Excel includes graph thumbnails
  • Results window and thumbnail graphs update live as a simulation runs to show a "dashboard" of simulation results
  • Clicking or tabbing on a result in the table moves to relevant cell in Excel and displays graph

Graphics - General

  • New graphics engine, designed for processing simulation data, provides faster graphing and real-time animation of simulation results.
  • Type Lower, Middle Range and Upper Delimiter Values directly on Graph
  • Edit Titles directly on Graph
  • User controllable number of delimiter bars for overlays
  • Predefined and custom markers on graphs
  • Extensive graph color and shading options
  • Controllable number formatting on graphs
  • Customisable statistics displayed in legend of graph
  • Improved graphing of discrete distributions and data sets, including new RiskIsDiscrete property function
  • Select overlays by clicking on cells to overlay in Excel
  • Up to 10 overlays on a single graph
  • Remove overlays by clicking on the entry in the legend

Scatter Plots

  • Any pair of output results and/or sampled inputs can be placed in a scatter plot
  • Overlay up to 10 scatter plots in a single chart
  • X and Y values can be standardised
  • User controllable Confidence Ellipse can be added
  • Scatter plots can be generated in Excel as native Excel charts

Summary Graphs and Box Plots

  • Any inputs or outputs (not just those in an output range) can be placed in a summary graph or box plot
  • Box plot has user definable box and whisker settings

Sensitivity Analysis

  • Pivoted Detailed Statistics report allows listings of larger numbers of inputs and outputs
  • Regression - Mapped Values analysis type displays values, as opposed to coefficients, on bars
  • Drag a bar from a Tornado Chart to show a scatter graph of values for a key input vs output
  • Pre-screening inputs based on their precedence in formulas to outputs in your model helps keeps erroneous inputs from appearing in results.
  • Sensitivity Scatter Plot Matrix can be displayed, showing a matrix of scatter plots ranked by most important inputs
  • RiskMakeInput function allows sensitivity impacts of multiple inputs to be captured in a single bar in a tornado chart

Filtering

  • Filtering can be specified using percentiles as well as actual values
  • Filtering available directly from a graph window
  • Percentile filters update real time as data changes during a simulation

@RISK Library

  • The @RISK Library provides a repository for sharing @RISK inputs and simulation results.
  • Distributions to be shared can be entered directly in the Library or added from an @RISK model in Excel
  • Revision history is provided for library distributions
  • Results for different simulations stored in the library can be graphically compared
  • Archived simulations, including workbooks simulated, can be reloaded into Excel

Function Swap

  • Function Swap allows @RISK functions to be removed and restored from workbooks; easing the sharing of workbooks with non-@RISK users.
  • Value used to replace a swapped out distribution can be a user selected statistic from the distribution
  • Model changes made when functions are swapped out are captured in the RiskStatic function
  • Distributions swapped back in are placed in correct location in changed workbook
  • Report on changes made to a swapped out model available

Data Reports

  • Data from a simulation may be sorted to show key values you are interested in, including Error values
  • Iterations from a previously run simulation may be stepped through, updating Excel with values sampled and results calculated.

Save Simulations

  • Simulation Data and Graphs can be stored in the simulated workbook
  • Simulation Data and Graphs, along with the simulated workbook, can be stored in the @RISK Library

Six Sigma Support

  • 19 new statistics functions provide six sigma statistics in models
  • LSL, USL and Target values set using new RiskSixSigma property function
  • Results summary window displays six sigma statistics
  • LSL, USL and Target values displayed with markers on graphs
  • Six Sigma guide and help details how to develop six sigma models using @RISK

Clear Data

  • Simulation results, settings, and/or all @RISK functions and information can be permanently removed from an Excel workbook

Application Settings

  • Default settings for graphs, simulations, function swap, reporting and others are specified in a single location
  • Standard settings can be shared between users with a custom configuration file
  • Custom formatting of @RISK input and output cells, including color, font and borders

Excel Reports

  • New standard headers and formatting
  • Reports include graphics where applicable
  • Ability to have more than one template sheet report.

Help and Tutorials

  • Technical information on distribution functions integrated into help system
  • On-line tutorials and movies illustrate key concepts

Installation, Licensing and Updates

  • New installer and licensing system
  • Licenses may be moved to a new computer via the internet
  • Automatic updating of installations with new releases and patches

Programmability and Macros

  • New object-oriented API has hundreds of properties and methods for setting up and running simulations and generating results from VBA
  • Intellisense pops up available arguments and constants when wrting programs that control @RISK

New and Enhanced @RISK Functions in Excel

  • RiskCompound, used for "frequency / severity" modeling, takes two distributions to form a new input distribution. RiskCompound takes two arguments, each an @RISK distribution function or a reference to a formula in Excel that generates the frequency or severity value
  • RiskTheo functions such as RiskTheoMean or RiskTheoPtoX return a desired statistic on an input probability distribution.
  • @RISK statistics functions for simulation results (such as RiskMean) and RiskTheo functions can take an optional RiskTruncate function to specify a percentile or actual range over which statistics should be calculated.
  • RiskSensitivity function returns sensitivity analysis results directly to your spreadsheet.
  • A new set of 19 @RISK statistics functions (such as RiskCPK) return a desired Six Sigma statistic on a simulation output.
  • RiskConvergenceLevel returns the convergence level of a simulation output
  • RiskStopRun stops a simulation when an Excel formula returns TRUE
  • RiskMakeInput specifies that the calculated value for a formula will be treated as a simulation input, in the same manner as a distribution function. This function allows the results of Excel calculations (or a combination of distribution functions) to be treated as a single "input" in a sensitivity analysis.
  • RiskResultsGraph supports overlays and graphs of input probability distributions

New Property Functions for @RISK Outputs and Distribution Functions

  • RiskUnits specifies units to use to label an input or output in graphs and reports
  • RiskSeed specifies the seed and random number generator to use for an individual distribution function
  • RiskConvergence specifies specific convergence monitoring settings for an output
  • RiskSixSigma specifies LSL,USL and Target values for an output
  • RiskIsDiscrete specifies that the data set to be generated for an output should be treated as a discrete distribution when graphing and calculating statistics
  • RiskStatic specifies the value to be returned by a distribution function in a normal Excel recalculation and optionally will automatically store the value in a formula that was replaced by a distribution function
  • RiskTruncateP specifies truncation limits for a distribution function using percentile values
  • RiskCategory property function to help organise inputs into functional groups.
  • RiskLibrary is used to attach an input in the model to a probability distribution in the @RISK Library.
FEATURES
  • Shows you many possible outcomes
  • Show you chances of different outcomes occurring
  • 100% Excel calculations for simulation

INTERFACE

  • Seamless integration into Microsoft Excel
  • Intuitive toolbars and right-click menus

MODEL DEFINITION

  • Distribution palette viewer and data fitting
  • 38 built-in distribution functions
  • @RISK Library
  • Compound function
  • Percentile distribution parameters
  • Correlation of inputs and correlation time series

SIMULATION

  • Demo Mode and live updating
  • xtensive settings control

SIMULATION RESULTS

  • Fully customisable presentation-quality graphs
  • Reporting in Office
  • One-click Quick Reports
  • Histograms, area, line, cumulative, summary, box plot, and overlay graphs
  • Tornado charts and scatter plots
  • Sensitivity and Scenario Analysis
  • Six Sigma functions

BENEFITS

  • Helps you avoid pitfalls and uncover new opportunities
  • Lets you develop best possible strategy
  • Highest level of accuracy, and maximum use of multi-core processors for speed
  • Never leave your spreadsheet; get up to speed quickly
  • Easy navigation - multiple ways to perform common tasks
  • Easy and accurate definition of uncertain factors
  • Represent virtually any uncertain factor for accurate modeling
  • Define, reuse, and share custom distributions and simulation results
  • Combines two distributions into one to streamline insurance or other large models
  • More flexible ways to define uncertainty
  • Represent dependency between related variables for accurate modeling Graphs and reports update during simulation for illustration to others
  • Customise simulations to specific needs
  • See the impact of risk and communicate to stakeholders
  • All graphs and charts can be exported to Excel, Word, and PowerPoint in native chart format for easy distribution to others
  • See summary of charts and graphs pre-formatted for one page
  • Variety of graphing and charting options for easy, accurate communication
  • Visually identify critical factors and identify trends
  • Identify the individual tasks that have the most impact on results, and the particular scenarios that lead to certain results
  • Report Six Sigma statistics for quality analysis
Stand-alone Licenses
Stand-alone licenses are intended for use by one person on one computer.

They may not be run from a server. Every stand-alone license comes with its own serial number and activation ID which unlocks the software for perpetual use. Software activation can be done with a single click over the Internet or manually via e-mail. Stand-alone licenses may be transferred from one computer to another once every 90 days, but may never be used one more than one computer at a time.

Concurrent Network Licenses
Concurrent network licenses are intended to serve multiple users from a network server. The software is installed on a single server, but may also be installed on an unlimited number of client computers. The restriction is placed on the number of users who can access the software at the same time, i.e., concurrently. Concurrent network licenses are a very cost-effective way to serve many people who need to use the software occasionally and “log off" when finished.

Concurrent network licenses utilize FLEXnet technology and come with one serial number and activation ID, regardless of the number of users. Software activation is only required for the server license, not the client installations. Activation can be done with a single click over the Internet or manually via e-mail. The same installer may be used on all client computers, so scripting is very straightforward. In addition, concurrent network licenses support Terminal Services and Citrix environments. The server license may be transferred from one server to another once every 90 days, but may never be used on more than one server at a time.

Concurrent network licenses also allow “borrowing," or temporarily taking one license off the network server and putting it on the client computer. This lets someone use the software even if their computer is disconnected from the server (e.g., taking a laptop on a trip). When a license is borrowed, an expiration date must be set by the user. At expiration, the license is automatically returned to the server license pool and ceases to function on the disconnected client.

Enterprise Activation Server
Enterprise Activation Server licenses use FLEXnet technology to allow you to grant and manage stand-alone licenses of Palisade software from your own server instead of the Palisade license server.
Rather than requiring every stand-alone user to contact the Palisade license server to activate their software, each user would instead contact your own server once to activate. A single activation ID may be used for all license installations. You can expand the number of users on the license by purchasing additional users for the same server without having to use a new activation ID. If users wish to transfer licenses from one computer to another, the deactivation and reactivation of licenses can be managed on your local server as well. Enterprise Activation Servers are a great option for companies with strict firewall or security protocols, and make license management easy. Simply check your server to see how many installations you’ve used, and who has them.

Corporate Licenses
Palisade corporate licenses are purchasing options that enable you to get the most software for your money, deployed in the most efficient manner possible. Using the concurrent network or Enterprise Activation methods (though may be customized however you wish) and are structured according to your organizational needs and volume.
Investing in a Palisade corporate license is the most cost-effective path to better decisions enterprise-wide. By switching from haphazardly purchasing individual copies to adopting a corporate license, many companies have found that the return on their software investment dramatically improved. Not only was their investment outlay reduced compared to buying individual copies, but widespread access to the software encouraged better decision-making throughout the organization.

There are two kinds of Palisade corporate licenses:

  • Site Licenses – Provide software access to everyone at a particular physical location.
  • Enterprise Licenses – Provide access to the software throughout an organization or division regardless of physical location.
@RISK Professional

Designed for professional-grade problems in any industry, @RISK Professional is perfect for most commercial uses. It provides a balance of advanced analysis and point-and-click ease of use, and includes:

  • Integrated distribution fitting: Defines distribution functions for you based on historical or industry data.
  • @RISK Library: A SQL database for storing and sharing with others @RISK distribution functions, model components, and simulation results.
  • Excel Developer Kit (XDK): Automate and customise @RISK for Excel through a complete library of commands and functions that let you control every aspect of @RISK in your spreadsheet. Add @RISK for Excel to any custom application.
  • Stress Analysis: Lets you control the range that is sampled from a distribution function, enabling you to see how different scenarios affect your bottom line without changing your model.
  • Advanced Sensitivity Analysis: Lets you see how changes in any input - distributions or regular values - affect simulation results.
  • @RISK Goal Seek: Uses multiple simulations to find an input value that achieves a target simulation result you specify.

@RISK Industrial

Designed for your largest, most complex models, @RISK Industrial includes everything in @RISK Professional, plus the following::

  • RISKOptimizer 5.0: Combine Monte Carlo simulation with genetic algorithm-based optimisation to find the best combination of factors to lead to a desired result under uncertain conditions.
  • Integrated @RISKAccelerator: Speed up large simulations with parallel processing by using multi-core processors and up to four CPUs within a single machine.
Compatibility
@RISK for Excel is compatible with Excel versions 2000 through 2007.
Help
My Account
Corporate Info
Other Info
Secure Shopping
Copyright © Grey Matter Ltd. 1983 - 2008. Registered office: 2 Prigg Meadow, Ashburton, Devon, TQ13 7DF. Registered in England. Company no: 1671407. VAT no: GB 384904621.