The add-in adds the Tornado Diagram... item under the TM menu.
To create a Tornado diagram , lay out the data so that the nominal (or base) values and the minimum and the maximum values are in adjacent columns as shown in Figure 4 and Figure 5. Ensure that you include the top header row in specifying the data range in the Tornado dialog box.
|
|
![]() |
![]() |
The number of samples affects the time required for the analysis as well as the accuracy of the result. Since the software effectively samples the parameter values, increasing the sample size will take longer but will yield more accurate results. Of course, there is no substitute for understanding the problem being studied. For example, if the relationship between the result cell and the parameters in the Data Range is linear, a sample size of 3 will suffice. More complex relationships will require more samples.
|