Creating and formulas in traditional spreadsheet applications is time consuming and error prone because they are represented by abstract cell references (e.g., A2) and you may mistype them without realizing it.
Cell references also make it hard for you, let a lone a colleague, to debug formulas or audit models.
This is why in Visyond you have the option of using descriptive natural names in formulas instead of cryptic cell references.
How natural names in formulas look in Visyond worksheet
By default natural names are turned on and you can change this clicking on the button in the name column.
If your worksheet has labels for at least a row, Visyond will show the natural name in the [Row Label][Column Label] format. If [Column Label] is not defined, [Row Label] [Column Letter] (e.g., Revenues[B]) will be shown.
If you want to go back to a classic Excel environment you can toggle the On in the Names box to Off.
Working with natural names
We recommend that when you are debugging formulas and auditing models keep the:
- Audit Mode is On
- Natural Names is On.
- Precedents and Dependents is turned On.
When you click through the Visyond worksheet you will be able to spot any inconsistency in formulas, immediately figure out the precedent and dependent cells, and instantly determine which cells have comments, attachments, or cases.
If debugging formulas with cell references is as hard as using a 2007 vintage phone to get directions, debugging with natural names is as simple as firing up Siri and asking for the shortest route.