| On this page: Download | Upgrade | Buy |
Screenshot | View help file |
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.
Click to see full size screenshot
As a simple example, here is an extract of a worksheet which at face value looks fine.
Below is the same extract created for you by the Data Analyser as a copy
worksheet. You can
clearly see which cell is a number and should be a formula since it is coloured
as the other numbers (yellow = text, blue = number, green = formula).
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?
By installing and using this software you affirm your complete and unreserved acceptance of the PATools
End User License Agreement
For new users, the software will run on an evaluation basis, which means that you can use it for as long as you wish but only run the main tools 30 times.
You can purchase a license 24/7 using our secure automated service from this webpage below.
Changes since last release
Upgrade
No need to uninstall your current version - simply close Excel, download as above and overwrite your existing copy.
If you have a licensed copy then you should download into the same folder as the previous version, otherwise you may need to re-enter your licensing details and may lose any saved settings.
Contact us if you have problems.
Buy
BUY NOW from the secure ordering site of our payment partner share-it! where you can pay in various currencies
Licenses expire after 1 year.
SAVE MONEY by buying an extended license (lasting more than 1 year) - see here
SAVE MONEY by buying several PATools Excel products - see here