Simple Data Tables
- 01:04
Learn what a data table is by reviewing a simple model
Downloads
No associated resources to download.
Glossary
Dynamic Calculation Input Assumption OutputTranscript
Data tables are a super efficient way of showing how an output is affected by varying the input assumptions as all the different outputs are displayed simultaneously. You don't have to manually change the assumptions yourself, the output calculation must be a dynamic calculation that is affected by the input assumption you want to sensitize on. So in this example, we can see how the profit is affected when the sale prices adjusted. So this is our profit number here and our calculated profit number, and this is the sale price. So this is a normal assumption and that means that changes to that assumption will affect the profit number. So what we're going to do is link this profit number to the top of our table to sell C14. And then the different price inputs that we want to see are listed in the left most column of the data table, so that's that $3,50 down to $4,50 here. The data table outputs then in sales C15 to C19 show how the profit is affected by the input price.