![]() |
|||
|
|||
With the Scenarios module, you can create three types of Scenarios Sheets: BASIC, TABLES and COMBINED. |
|||
![]() |
|||
| BASIC Scenarios Sheets Use BASIC Scenarios Sheets when you want to work with inputs with no data -such as a time series- associated to them. In the Model shown in the screenshot below, Tax % and Discount Rate are the selected inputs, as their values remain the same over the years. You should not work with the Units, Price per Unit and Cost per Unit inputs in a BASIC sheet since their values change over the years - from 2006 to 2010. |
|||
![]() |
|||
| TABLE Scenarios Sheet It is convenient to creat TABLE Scenarios Sheets when we need to create scenarios for inputs whose values vary, such as those in a time series. |
|||
![]() |
|||
| COMBINED Scenarios Sheet You should create a COMBINED Scenarios Sheet when you need to work with inputs both associated (TABLES) and non-associated (BASIC) with a series of data. The latter are taken directly from the model while the former from a separate TABLES sheet already created. This functionality is more complete and robust and with it you can work with any type of variables. All inputs should be taken directly from the model, not from other sheets already! created. |
|||
![]() |
|||