I want to build a table like the “data table” in Excel. To calculate different scenarios.
i dont like the scenario options of adding a category with different values to calculate the scenario.
rows: EBITDA ( lets say 10; 12; 14)
columns: multiple (6; 7; 8)
is there any function to do that same sensitivity analysis like in Excel? In Excel is very easy. You set the values for roes and columns and the output.
many thanks, Quanters
I think your question about doing Excel-like sensitivity analysis may be addressed by the new Solver feature… I wouldn’t know as I haven’t used it yet.
However, if you set up your scenarios such that every “scenario” is an item of a Category (let’s say called Scenarios), and all assumptions and the “single” output you desire are defined as items of another Category (let’s say Scenario Attributes), then you should be able to achieve the same result, although with more steps. Sorry if I can’t be more specific – can you describe your use case in more detail?