Run Autoanalysis in Visyond

Run Autoanalysis in Visyond

What Autoanalysis does

Autoanalysis transforms a tedious, lengthy (it takes hours or days with traditional spreadsheets) and error-prone manual setup for routine spreadsheet analyses, into a 1-click job generating insightful reports ready to be presented and updated on the fly.

The best way to appreciate Visyond potential when used standalone (i.e., before you invite collaborators) is to create a model (or import one from Excel) and run autoanalysis on a cell of interest (e.g., revenues, profits, IRR, NPV).

Visyond will automatically run all the modules below using heuristics (you can then go to the Analysis module and customise):

Tornado Analysis – Will tell you what are the most important input for the output cell

Sensitivity Analysis – Heuristic: will run a two-way sensitivity on the two most important input by varying them from a minimum of the current value -50% and a maximum of current value +50%.

Scenario Analysis – Heuristic: Visyond varies each of the top 5 input by -/+ 50% and create new cases with these values. We call an “increasing case”, a case that increases the output value; a “decreasing case” a case that decreases the output value.

Note that we cannot use “optimistic” or “pessimistic” as we do not know whether you consider the value increase of the output cell a good thing (think about costs going up).

An “Increasing Scenario” and a “Decreasing Scenario” are constructed by switching the 5 most important input cell to their increasing and decreasing case respectively.

Monte Carlo simulations – Heuristic: the top 5 input cells are modeled as Normal Distributions with a mean set on their base value and a standard deviation of 50% of the base value. Obviously this can be completely wrong (e.g., imagine “inflation”) but gives you the opportunity to see how the module works, get familiar with it, and customise it with the right probability distribution (e.g., A Triangular Distribution is more appropriate for inflation or you can read the tutorial on Monte Carlo simulation and see how to find out what is an appropriate distribution for your data).

The Dashboard

When autoanalysis is complete, you will be taken to the ANALYSIS/Overview Tab where you will find a dashboard with the top inputs for the selected output and can stress test the model without tampering with the spreadsheet. This is ideal to let colleagues and clients, especially those who do not like interacting with spreadsheets, play with assumptions.

You can export this dashboard to PPT or Visyond native interactive HTML slides with a click (you can present and change values directly in presentation mode).

how to
August 11, 2018

Was that post helpful?

Related Articles