Other ways to validate your spreadsheet is by letting PerfectXL break down your spreadsheet in a summary of characteristics, such as the amount of worksheets, cells and external sources.
Validate Data Through Visualization
With visualization, you can validate the internal structure of your spreadsheet. This allows you to check your spreadsheet for accuracy, examine input and output and map different cell types. Visualization also lets you create straightforward schematic representations of your spreadsheet. By using the information inside your spreadsheet, the spreadsheet is translated into easily understandable visuals, such as a flow diagram.
Complex spreadsheets that make use of multiple worksheets, external resources and other sources can be very hard to understand. Reading such a spreadsheet would be like trying to comprehend a jumbled ball of information spaghetti. PerfectXL’s visualization feature shows you immediately how all the different connections of your spreadsheet are set up.
By clicking on a worksheet or formula button in the visualization, you can see more detailed information on the specific worksheet or formula. The amount of non-empty cells shows the size of the worksheet, while the number of inbound and outbound connections shows the relevance and dependency of said worksheet.
Different Modes of Visualization
There are several modes of visualization. The input-output visualization examines whether there is still a clear separation between input sheets, calculative sheets and output sheets. Arrows and color labels show how the information flows within the spreadsheet, allowing you to easily validate the internal structure of the spreadsheet.
The data-count overview shows the dependency of different worksheets in relation to each other. This mode of visualization shows the number of incoming and outgoing values form and to any worksheets within your spreadsheet.
Color mapping lets you easily recognize the most important parts of information of your spreadsheet. It also shows any information within your spreadsheet that’s hardly being used. Color mapping can be used to highlight formulas, text and numbers that can be exported to a new copy of your own spreadsheet. Color mapping also lets you more easily spot any unexpected disruptions or patterns within the spreadsheet.