Tornado+Diagrams


 * Tornado Diagram Templates and Video Courses **

= This website is now obsolete because of being extinguished by horrible wikispaces. Please go to http://edbodmer.com for a much improved website. =

This page explains how to make different presentations of scenario and sensitivity analysis using tornado diagrams, spider diagrams and other tools. The process involves using a combination of data tables and the index function. The process is helped with the TRANSPOSE function. A tornado diagram can be a good risk tool because it shows the importance of different variables and it demonstrates whether there is more downside or upside risk. A spider diagram can be used when sensitivity variables are expressed as percentages (e.g.120% or 90%). Then a two way data table can be used with the percentages and the various different input variables. In creating a tornado diagram you need add a whole bunch of scenarios where each sensitivity has only variables that differ from the base case.

The video below illustrates the process

media type="youtube" key="0x1sx5YKpr8" width="560" height="315"


 * Subject ||  || Excel Exercise File ||   || Video ||
 * Basic Tornado Diagram ||  || Scenario and Tornado Exercise ||   || https://www.youtube.com/watch?v=0x1sx5YKpr8 ||
 * Sorting a Tornado Diagram ||  || Scenario and Tornado Exercise Finished ||   || https://www.youtube.com/watch?v=kH41VDGakqM ||
 * Tornado Diagram with Two Way Table ||  || Scenario and Tornado Exercise Two Way Table ||   || https://www.youtube.com/watch?v=fdO6p22ngow ||
 * Showing Low and High Case Values in Tornado Diagram ||  ||   ||   ||   ||
 * Tornado Diagram in Project Finance Model ||  ||   ||   ||   ||
 * Tornado Diagram with Alternative Base Case ||  ||   ||   ||   ||
 * Spider Diagram with Constant Increments ||  ||   ||   ||   ||
 * Spider Diagram with Variable Increments ||  ||   ||   ||   ||
 * Tornado Diagram in Merchant Analysis ||  ||   ||   ||   ||
 * Flexible Sensitvity Diagram ||  || Kalitta Corporate Model ||   || https://www.youtube.com/watch?v=JO-SbCoqXqk ||
 * Tornado Diagram with Offset Function ||  || Kitty Hawk Corporate Model ||   ||   ||
 * Tornado Diagram with Offset Function ||  || Kitty Hawk Corporate Model ||   ||   ||