TopRank
Identify Critical Factors using Automated What-If Analysis
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.
Rolf van Lingen
Logion BV
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.
Dmitry Shevchenko
Head of Risk Management, MegaFon
[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:
- Investment Planning & Portfolio Optimization
- Cost Estimation
- Engineering Reliability
- Capital Reserves
- Oil, Gas, & Mineral Reserves
Investment Planning & Portfolio Optimization
Identify the most critical factors that lead to volatility or undesirable outcomes in investments.
Cost Estimation
Understand the factors that drive overages in materials and labor costs throughout the entire project.
Engineering Reliability
Gain insight into the factors driving variance and inconsistencies to ensure quality.
Capital Reserves
Determine the risk factors which most likely lead to loss scenarios to enable focused mitigation planning.
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
Oil, Gas, & Mineral Reserves
Cost Estimation
Cost Estimation
Understand the factors that drive overages in materials and labor costs throughout the entire project.
Engineering Reliability
Engineering Reliability
Gain insight into the factors driving variance and inconsistencies to ensure quality.
Capital Reserves
Capital Reserves
Determine the risk factors which most likely lead to loss scenarios to enable focused mitigation planning.
Oil, Gas, & Mineral Reserves
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.
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