Data Tables
How to create Excel Data Tables
Last updated
How to create Excel Data Tables
Last updated
Unlike Models, Excel will only calculate one Case of your Model at a time, and you will need to use the Scenario and Sensitivity controls in your spreadsheet to change Case.
However, Excel Data Tables allow you to calculate results from different sets of inputs simultaneously, and display all results in one place. While this will not show you all outputs, it can be useful for comparing specific metrics over several Scenarios and Sensitivities, as shown in the example below.
To create a Data Table, simply go to the Tables tab of the Model Editor and add a new item. You will need to enter a name and choose which combinations of Cases to show.
As shown in the screenshot below, once you have created the Data Table, you can edit it in the same way you edit a Sheet in the sheet preview. In a Data Table, all sheet items are Metrics.
Use line formatting and group spacing to change the appearance of your Table.
To add a Data Table to the Layout, you must perform the following steps:
Add a Dashboard Sheet containing the Dashboard to the Layout