Have you ever wondered why it takes so long to audit a spreadsheet model, and thought that there must be a quicker and more effective way?
Rainbow Analyst is a sophisticated add-in (for Microsoft Excel 2000 and above) that delivers considerable time savings in the audit process through a combination of diagnostic reports, visual highlighting or mapping of potential problems, and interactive logic tracking.
Are you concerned about the danger of costly errors going undetected despite thorough checking? Rainbow Analyst's wide range of analysis functions can detect errors which would be hard to spot through manual checking, however exhaustive.
Version 5.0 of Rainbow Analyst Professional incorporates a completely redesigned front end plus a range of new reporting and mapping features combining increased ease of use with even more comprehensive auditing and compliance testing functionality.
Here are some key features of "Rainbow Analyst Professional":
· analyse the logic of any individual cell and spot potential inconsistencies;
· check how consistently formulas have been copied across rows and down columns;
· see where model inputs really are, as opposed to where they are indicated;
· find row differences, hard-coded numbers, complex formulas and other problems;
· see the overall flow of logic between different sheets in a workbook;
· analyse differences between workbooks, worksheets or tables in a sheet;
· find links to other Excel workbooks, and trace comments and names.
Requirements:
· Microsoft Excel 2000 and above
Limitations:
· 30 days trial
What's New in This Release: [ read full changelog ]
· The new Summary Report gives you a high-level view of a workbook, including e.g. data on Visual Basic code modules and average and maximum formula length per sheet, so that you can assess potential problem areas before starting detailed analysis.
· The Inter-Sheet Logic reports can now group relevant copied formulas together, producing a much more compact and readable report.
· Nearly all Rainbow’s functions can now generate a report (grouping copied formulas where appropriate), rather than simply applying colour to the relevant cells.