Logo Environmental XPRT
Companies
Products
Services
Software
Training
Applications
Sign in
List your business
Lumivero
About
Downloads

Lumivero - TopRank Sensitivity and Scenario Analysis

SHARE
Quickly identify your critical factors with automated “what-if” sensitivity analysis – right in your Microsoft Excel spreadsheet. By identifying and ranking all input factors that affect your bottom line, you can make strategic decisions that help you achieve your goal.
Most popular related searches
decision analysis
risk communication
automatic 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.

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

TopRank has a multitude of applications, including:

  • 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.