If you have ever spent hours checking or auditing a spreadsheet model, then the Rainbow Analyst add-in (for Microsoft Excel 2000 to 2010) may be just what you need to fast-track your spreadsheet audit process.
Rainbow Analyst Professional has been designed for corporate use by spreadsheet designers, developers and users. It is currently being used in offices around the world by organisations ranging from individual consultancies to large global corporations.
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 to 2010) 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.
Rainbow Analyst’s wide range of analysis functions (see below and on other pages) can detect errors which would be hard to spot through manual checking, however exhaustive. If you have ever wished you could see at a glance where potential errors might be lurking in a spreadsheet model, with Rainbow’s functions at your disposal you will readily be able to:
- assess quickly where there are likely to be problems or errors in a model;
- see the overall flow of logic within and between different sheets in a workbook;
- see where model inputs really are, as opposed to where they are indicated;
- check how consistently formulas have been copied across rows and down columns;
- analyse the logic of any individual cell and spot potential inconsistencies;
- analyse differences between workbooks, worksheets or tables in a sheet;
- trace links to other Excel workbooks, and trace comments and names;
- find row differences, hard-coded numbers, complex formulas and other problems.
