PATools Data Analyser for Excel 2.11 (for Excel)
PATools Data Analyser
The PATools Data Analyser is a powerful tool for analysing spreadsheet integrity within Microsoft Excel software.
It is most likely to be used for two main purposes:
to assist in checking a workbook for integrity and for errors in logic and content, and
to help you understand and find your way around a workbook created by somebody else
The Data Analyser is essentially a tool that makes a copy of your worksheet and then changes the appearance of each cell based on its contents. This allows you to see at a glance whether cells contain a formula, text, number, or an error. So it is easy to understand how a worksheet is constructed, irrespective of the actual values displayed.
Imagine how this might help with large and complicated worksheets!
FACT: Users believe that there is only an 18% chance that their completed spreadsheets contain errors, but 86% actually did contain errors!
[Panko R & Halverson R 1996 ‘Spreadsheets on Trial: A Survey of Research on Spreadsheet Risks’, Proceedings of the Hawaii International Conference on System Sciences]
How much might errors in your spreadsheets cost you?
Can you afford not to check your critical work?