 |
Risk Detective communicates with your spreadsheet
model through tables within your spreadsheet. As shown, a
business model calculates outputs based on inputs. You will
create an Input Table and Output Table so that Risk Detective knows
where to look.
All tables follow the same configuration concept. Tables may be located anywhere in your worksheet, and have a very flexible layout to allow you freedom in model creation and design. |
Required Tables
Input Table: Defines the Low, Base, and High values for each input.
Output Table: Defines the model outputs that you want to follow, say profit. May have more than 1.
Optional Tables
Decision Table: For many analyses, you want to compare a set of decision alternatives. This table provides an automation feature that allows you to repeat the analysis for each alternative then compare the results.
Tree Table: Provides the ability to define complex trees, ie those with downstream decisions, asymmetric uncertainties, or uncertainties with more than 3 possibilities.
 |
 |