risk graph logo

TopRank

Sensitivity and Scenario Analysis in Excel

Identify Critical Factors using Automated What-If Analysis

orange triangle
Two smiling diverse businesspeople using a laptop together at wo

Rank Variables for Scenario Planning and @RISK Analysis

Have you ever been faced with a large, complex spreadsheet model and been tasked with determining what the most important factors are? What if you need to determine how sensitive your profits are to particular variables, such as material costs or market share? Or perhaps you want to run a risk analysis in @RISK, but don’t know which variables are important enough to add distribution functions to.

Included with the DecisionTools Suite, TopRank performs automated “what if” sensitivity analysis on Microsoft Excel spreadsheets to answer these questions. Define any output or “bottom line” cell or cells, and TopRank will automatically find and vary all input cells which affect your output. You can also control exactly which cells you’d like to analyze. The end result is easy-to-understand tornado charts, spider graphs, and other reports which clearly identify and rank which affect your bottom line the most.

Overview

Simply take your existing spreadsheet model, select any cell or cells as outputs, and TopRank scans the spreadsheet to find cells which affect your results. Click the ‘Run What-if’ button and TopRank tries different values for each variable cell, changing values over ranges such as -10% and +10%. Each time a new value is tried, the spreadsheet is recalculated and new results are generated. Upon completion, TopRank ranks the variable cells according to the effect they have on your selected outputs. You can also select exactly which cells you wish to vary, and by how much, for a more customized analysis.

TopRank uses Vary functions in Excel to vary inputs across a range. TopRank functions are true Excel functions, and behave exactly as native Excel functions do. TopRank windows point to the cells they refer to via callouts, and changes in one place are automatically carried out in the other.

Works with Microsoft Excel

Identify Critical Factors Automatically

Streamline your @RISK analysis

Communicate Important Factors to Others

Industries

Energy & Utilities

Insurance & Reinsurance

Finance & Banking

Manufacturing & Consumer Goods

Construction & Engineering

Aerospace & Defense

Customer Success Stories

Learn how TopRank has helped analysts and executives improve decision making.

Logion BV
logian logo

Rolf van Lingen
Logion BV

orange quotes

I use TopRank to determine the critical factors affecting transportation efficiency. No more stressful late nights working with static Excel spreadsheets in order to meet my clients' deadlines.

MegaFon
megafon

Dmitry Shevchenko
Head of Risk Management, MegaFon

orange quotes

[TopRank] is a well-balanced and flexible instrument that can be applied to a wide variety of situations, making it ideally suited to managing risk across the enterprise.

How TopRank Is Used

TopRank has a multitude of applications, including:

Business people presentation on future plans to colleagues , business meeting concept

Investment Planning & Portfolio Optimization

Identify the most critical factors that lead to volatility or undesirable outcomes in investments.

woman pointing at a screen in a hard hat

Cost Estimation

Understand the factors that drive overages in materials and labor costs throughout the entire project.

people looking at their phones

Engineering Reliability

Gain insight into the factors driving variance and inconsistencies to ensure quality.

Diverse Team of Young Professionals in Conference Room Have Discussion about Statistics and Graphs Shown on a Presentation TV.

Capital Reserves

Determine the risk factors which most likely lead to loss scenarios to enable focused mitigation planning.

man talking with clients

Oil, Gas, & Mineral Reserves

Understand what issues are most likely to derail an exploration project so that mitigation steps can be taken.

Investment Planning & Portfolio Optimization

man talking with clients

Oil, Gas, & Mineral Reserves

Map out sequential, probabilistic exploration plans of prospective sites containing oil, natural gas, or other minerals. Estimate uncertain reserves to make wise drilling decisions.

Cost Estimation

woman pointing at a screen in a hard hat

Cost Estimation

Understand the factors that drive overages in materials and labor costs throughout the entire project.

Engineering Reliability

people looking at their phones

Engineering Reliability

Gain insight into the factors driving variance and inconsistencies to ensure quality.

Capital Reserves

Diverse Team of Young Professionals in Conference Room Have Discussion about Statistics and Graphs Shown on a Presentation TV.

Capital Reserves

Determine the risk factors which most likely lead to loss scenarios to enable focused mitigation planning.

Oil, Gas, & Mineral Reserves

man talking with clients

Oil, Gas, & Mineral Reserves

Understand what issues are most likely to derail an exploration project so that mitigation steps can be taken.

Key Features

Automated What-if Analysis

By automatically identifying all inputs affecting your designated output, TopRank removes all the guesswork – and wasted hours – from figuring out what’s important in your large spreadsheets.

100% Excel Integration

TopRank integrates seamlessly with Excel, adding a host of new, native functions that enable you to work in a familiar environment with results you can trust.

Graphs and Reports

TopRank graphs enable you to communicate results intuitively and easily to other stakeholders, allowing you to quickly focus discussions on the most important priorities.

Next Step: @RISK

Once TopRank has identified the most important variables in your model, it’s time to define those variables with probability distributions in @RISK. This will let you describe the uncertainty inherent in those cells with ranges, the first step in a Monte Carlo simulation. With TopRank, you don’t have to spend hours guessing which variables to study.

Extensive Modeling Features

If desired, TopRank allows you to customize which cells to vary and how to change their values. Plus, you can experiment with varying two or more inputs at the same time. Analyze any scenario in seconds.

decision tools logo

Included with The DecisionTools Suite

The complete risk and decision analysis toolkit, including @RISK, PrecisionTree, TopRank, NeuralTools, StatTools, Evolver, RISKOptimizer, and ScheduleRiskAnalysis.

Additional Benefits

Subscription

Your software subscription has you fully covered.

  • Free upgrades when new software versions are released
  • Full access to Technical Support

Support

Technical Support is available to help with installation, operational problems, or errors.

  • Included with subscription
  • Phone, web, or email

Customizable

Leverage the power of TopRank in your own custom application with Palisade Custom Development.

  • Engage Palisade to design your solution
  • Standardize your analyses and reduce learning curves

Join decision-makers around the world who

RELY ON PALISADE.