The PATools Data Analyser 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 a user understand and find their way around a workbook created by a different author. The Analyser is a tool that runs across worksheets and changes the appearance of each cell based on its contents. This allows you to see at a glance whether cells contain a formula, text, or a number, or result in an error (this default option can be switched off), and thus understand how a worksheet is constructed irrespective of the actual values displayed.