Visyond Help Home
  1. Home /
  2. Analysis Modules /
  3. How to use Audit Mode and Cell Formatting in Visyond
How to use Audit Mode and Cell Formatting in Visyond

How to use Audit Mode and Cell Formatting in Visyond

Audit Mode

Visyond is designed to drastically cut the time and effort involved in auditing models and debugging formulas.

Audit mode is turned on by default in Visyond when you create a new project. If you are importing from Excel, it is turned off so you can see the same formatting you had in your Excel file.

In the audit mode each cell looks different based on the type of data it contains.

  • Yellow cell with blue font indicates that the cell contains hard coded data.
  • Yellow cell with green font indicates that the cell contains date related data.
  • Yellow cell with purple font indicates that the cell contains string related data.
  • White cell with black font indicates manual formula.
  • Red cell indicates an error/NaN/infinity.

You can access these color codes by hovering the cursor on the Audit button.

In Visyond you can also attach files to individual cells, leave comments on a cell or also create cases for each cell.

The cell containing this metadata will show the following:

  • Red dot indicates cells with Cases.
  • Blue dot indicates cells with Comments.
  • Green dot indicates cells with Attachments.

Cell Formatting

Hover or right-click on any cell to open the Format Panel.

You can align text, change colors, draw borders, change font size, decimal digits, etc.

When Audit Mode is on, you will not be able to see custom formats you apply (e.g., cell color background) as the auto formatting will prevail.

 

We recommend that you keep the Audit mode on to get a bird’s eye view of the model structure, row trends and potential errors.

Prefixes and Suffixes

You can format cells adding prefixes and suffixes to improve readability and auditing. For example you can select a range and add “USD” as a prefix and ” / m” as suffix if you want to highlight these cells display figures in USD per month. Formatting does not affect calculations.

Prefixes and suffixes
Prefixes and suffixes

Unit Formatting

In Visyond you can format a cell value in different units, avoiding unnecessary intermediate calculations to visualise numbers in certain units. This improves readability, auditability and reporting.

Select cells and set their units in the Format Panel. Note changing formatting does not affect calculations.

Unit Formatting
Unit Formatting
how to
August 29, 2017

Was that post helpful?

Related Articles