MS Office Tools





MODEL ADVISOR Business Software for Everyone  
Why Buy with Us
Check Out
Advanced Search

Related Sponsors
  TopRank for Excel    

Price: US$2,295.00

FREE Trial Buy Now
What is this Product?

TopRank is the “What- if” sensitivity analysis component of the DecisionTools Suite. Thus this software is not available as component anymore, but is sold as DecisionTools Suite.

Has this ever happened to you: You’ve created a comprehensive spreadsheet model describing the entire financial structure of your department. You show it to your manager and all he says is, “What are the critical factors?” Or what about this: You are given a complex spreadsheet you’ve never seen before and are asked to identify the “important” values that affect the bottom line. In either case, you would have hours of What-if Analysis ahead of you. You might not even know what factors to analyze! TopRank is here to make these tasks a breeze!

Buy TopRank for Excel in order to get benefits and guarantee

TopRank is the powerful but easy-to-use What-if Analysis add-in for Excel. Take any spreadsheet model, define an output, and TopRank will automatically determine which cells affect it the most, and ranks them in order of importance!   

What-if Analysis
What-if Analysis (sometimes referred to as Sensitivity Analysis) determines which values in a spreadsheet model have the greatest impact on your results. Input values are varied (over a range) and the amount of change on the results is recorded. The inputs can then be ranked in order of importance. This type of analysis enables the user to identify the critical factors in the model, whether or not they created it or are familiar with the model itself.

TopRank is a true add-in to your spreadsheet . Once installed, TopRank simply appears as a toolbar in Excel. TopRank allows you to run your analyses right where you are your spreadsheet! No need to go back and forth between applications! TopRank also has a “What-if Wizard” built right in to guide you through each step of your What-if Analysis!

Identify Significant Factors
Never overlook those critical factors again! TopRank scans every cell in your spreadsheet which influences your results. By using TopRank first, you’ll be sure to review the most important when setting up an @RISK risk analysis.

Automatic Analysis
TopRank requires no tedious set up! Simply take your existing spreadsheet model, select any cell as an output and TopRank scans the spreadsheet to find cells which affect your results. Click the ‘Start 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.

Save Time
Until now, What-if analysis was done by manually selecting a cell, trying two or three different “What-if” values, recording the values of some result cell, and repeating for a few other cells in the spreadsheet. This process was both time-consuming and non-rigorous. Now, in a matter of  seconds, TopRank  gives you the answers you need by performing a fast and rigorous analysis. 

Use with the DecisionTools® Suite
TopRank was designed to work with our other DecisionTools® Suite products: @RISK, RISKview™, BestFit® and PrecisionTree®. Start by using TopRank to identify the critical values in your model.  Next, in @RISK, the Risk Analysis and Simulation Add-In, replace those values with @RISK probability distribution functions. Use RISKview to preview these distributions or create one by simply drawing it and placing it directly in @RISK. Take real-world data and use BestFit to find the distribution which best fits your data, and use that function in @RISK to realistically represent uncertainty. Then run a thorough Monte Carlo simulation and analyze the results! Create a decision tree with PrecisionTree to accurately describe a decision, and use TopRank to perform a multi-way What-if Analysis on your decision tree! With the DecisionTools Suite, you will be prepared to face the risks in any situation!

Add-in for Excel YES YES
What-if Wizard controls your What-if Analysis YES YES
VaryTable Function calculates results for each value in table YES YES
Customizable Graphs can be saved or exported into Excel YES YES
Spider Graphs
Show the rate of change of different inputs against the rate of change of an output
Tornado Graphs
Compares the effects of all input variables on a given output. Displayed in bar graph format
Sensitivity Graphs
Plots the effects of an individual input on results
Full statistical reports can be displayed in TopRank or your own spreadsheet YES YES
Multi-Way What-if Analysis shows effects of combining inputs 2-3 variable combinations unlimited number of input combinations
Supports @RISK functions NO YES

Compatibility: TopRank is compatible with Excel versions 2000 through 2003

TopRank's Tornado and Spider graphs show the critical factors affecting your results!



Technical Support: Personalized technical support is free with a current maintenance plan. Contact more details to

If you want 5 or more licenses, you will receive a special discount. Please contact to for more details.


You can download a 10 days FREE trial version to test if it will suit your needs.
FREE Trial

System Requirements
  • Minimum Platform: IBM PC compatible Pentium-equivalent or higher, 16MB RAM, Windows 95/98, NT 4.0, Windows 2000, Windows XP
  • Recommended: 32 MB RAM, or greater
  • Spreadsheet: Windows Excel 97, Excel 2000, Excel XP
  • Version: 1.5

Palisade products not include shipment charges. When you buy this product using Model Advisor shopping cart, you will receive an e-mail indicating the procedures to pay the shipment charges. For more information please send an e-mail to

  • Shipping in the US and Canada is $10 for the first item, $5 for each additional.
  • International shipping is $50 for the first item, $10 for each additional.
Product Prices  
DecisionTools Suite Professional 5.0 US$2,295.00 Buy Now
DecisionTools Suite Industrial 5.0 US$2,795.00 Buy Now

These prices are corresponding to the downloading version. The prices for products in CD are $50 higher.

WARNING, take into account that if you are not USA's resident, you should contact us to: in order to obtain a applicable quotation for you.

Related Sponsors
Our Sponsors

Related Sponsors

Help, Comments, Suggestions? Tell Us at:

©2003-2012 MODEL ADVISOR is a registered trademark of JABS All rights reserved.
Microsoft and Microsoft Excel are registered trademarks of Microsoft Corporation.