A1 Yippee > Windows > Business > Spreadsheets > The Spreadsheet Detective

The Spreadsheet Detective
Spreadsheet models are notoriously difficult to validate and undetected errors have lead to expensive mistakes and litigation. The Spreadsheet Detective addresses this problem by documenting spreadsheets so as to make the models easier to develop, understand and validate. The documentation highlights inconsistent copies of formulas. Unlike conventional tools these graphical annotations can be integrated with the spreadsheet that is being reviewed. Slightly inconsistent formulas are a major source of undetected spreadsheet errors. The Spreadsheet Detective also converts cryptic formulas like "= D34 - D35" into more meaningful expressions like "= D34`GrosProft - D35`FixeCosts" by adding AutoNames that are based on cell labels. The advanced AutoName algorithms have proven to be quite robust on complex spreadsheets. The tool also helps to overcome problems with existing named ranges which can be very misleading if they are not carefully maintained as a spreadsheet evolves. Potential problems are highlighted including date processing that might not be year 2000 compliant. Utilities are also provided that automate conversion of non-compliant code, as well as being able to compare two versions of a spreadsheet. Our Review:
Licence: Shareware - Trial Version Version: 5.8 OS: Windows 95/98 Date: 1999/02/02 Developer: Southern Cross Software Queens Size: 465.00 KB		Free download
Yippee Ratings Breakdown (5 is best): Installation: 0 Interface: 0 Functionality: 0 Documentation: 0