The Input Variables panel of the Tornado Analysis tool specifies the assumptions, decision variables, and precedents to include in tornado and spider charts. You can include any value cell in the tornado chart calculations. However, the cells are usually:
Assumptions — Cells defined as assumptions in Crystal Ball.
Decision variables — Cells defined as decision variables in Crystal Ball.
Precedents — All cells within open workbooks that are referenced as part of the formula or a sub-formula of the target cell.
The Input Variables panel includes these settings:
Input variable list — Lists all the variables selected for the tornado and spider charts.
Add Assumptions — Adds all assumptions from all open worksheets to the input variable list.
Add Decision Variables — Adds all decision variables from all open worksheets to the input variable list.
Add Precedents — Adds all precedents of the target cell from all open worksheets to the input variable list.
Add Range — Enables you to select a range of cells from the open worksheet to add to the input variable list. If you click this button, an Input panel opens, asking you to enter a cell range or to select a range of cells from the spreadsheet. Click OK to accept the selected range.
Remove Selected — Removes the selected variable from the input variable list.
Remove All — Removes all of the items from the input variable list.
Back — Returns to the Target Forecast panel.
Next — Opens the Options panel.
Run — Runs the Tornado Analysis tool.
When settings are complete, click Next to open the Options panel.