We have just released version 5.1 of Rainbow Analyst Professional, and the main news about this release is that it is compatible with Microsoft Excel 2007. We have fixed a few issues that made previous releases incompatible with Excel 2007, so you can now use Rainbow Analyst Professional with the latest version of Microsoft Office.

Version 5.1 does not directly use Microsoft’s Ribbon interface, but it appears inside an Add-Ins tab on the Ribbon, where you can access the Rainbow menu and toolbar. The steps for installing and trouble-shooting Rainbow Analyst under Office 2007 are quite different from previous versions of Excel, so we have now included full details of the Office 2007 procedures on other pages of our site.

If you currently have a single-user licence for version 5.0, you can download and install version 5.1 for free from the Download page of our website. If you have a corporate site licence, please contact us for details of how to upgrade.

If you are using an earlier version of Rainbow Analyst Professional, you are missing out on a wide range of new features introduced in version 5, not to mention the completely redesigned user interface (see details below on this page).

Now that version 5 has been available for over a year, we are offering the chance for users of earlier versions to upgrade for free if you have a single-user licence, or for a nominal charge of £99.00 if you have a corporate site licence.

You can download the latest single-user version of Rainbow Analyst from our Download page. This requires a different licence key from earlier versions, so please contact us to obtain your upgraded licence key, or for details of how to upgrade your corporate site licence version of Rainbow Analyst Professional.

Are you looking for a simple but powerful spreadsheet checker for casual or home use? Our Rainbow Analyst Personal add-in is now available completely free of charge! It offers many of the key features of our flagship Professional product, such as Formula Groups and Dependencies, in a simple and clear package.

Rainbow Analyst Personal has been selected for listing as freeware on the Softpedia software database, and has been certified by Softpedia to be completely clean of adware/spyware components.

For more details and to download your own copy, please visit our Download page, where you can also find details of our flagship product, Rainbow Analyst Professional. This has also been selected for listing on the Softpedia software database, and has been certified by Softpedia to be completely clean of adware/spyware components.

The most obvious new feature in version 5.0 of Rainbow Analyst Professional is a completely redesigned front end. Nearly all Rainbow’s functions are now accessed via a dialogue box similar to the one shown here, which lets you change the selected workbook/ worksheet and the output medium (colour, map, report) as well as any function-specific options.The option to generate a worksheet map is also new in Version 5.0. Instead of applying colour directly to a worksheet (e.g. to indicate blocks of unique formulas), this option applies the same colour to the corresponding cells in a separate mapping worksheet. And because you can map any number of Rainbow functions to the same mapping worksheet, you can build up your own cumulative picture of the worksheet(s) you are analysing.

And in version 5.0 you can now put all your reports and maps in the same workbook (instead of each being a separate single-worksheet workbook). If you wish, you can even append them as additional worksheets in the workbook you are analysing.

Version 5.0 also includes important enhancements to Rainbow’s core functionality, of which the following are just a selection:

• 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. And this technique has enabled us to speed up the inter-sheet precedents report by an order of magnitude, so that you can now quickly and easily generate a complete inter-sheet precedents report even for a model of some size.
• Nearly all Rainbow’s functions can now generate a report (grouping copied formulas where appropriate), rather than simply applying colour to the relevant cells. This means that Rainbow can now provide a much more comprehensive set of tools for use in a structured model audit process.

Version 5.0 is the first full version of Rainbow to include the Cell Inspector, an interactive function which displays the precedents and dependents of the currently selected cell, and also provides a best-guess description of the meaning of each cell. It will take you to each precedent or dependent (double-click on the relevant line) so that you can explore the logic and check out the meaning of each cell. Then click the back-arrow button to return to where you were before. The Cell Inspector title bar shows how many steps you are from the original cell (#1) where you started.

Cell Inspector uses a complex probabilistic scoring system to generate the cell descriptions; the screenshot on the left is a good example of how this works. Although of course the descriptions cannot be guaranteed to be 100% accurate in every single case, they have been proved to be highly reliable across a range of financial models, and they can provide a very fast indication of possible faulty logic.

As an example, suppose you run Cell Inspector on cell H74 in sheet Operations, and Cell Inspector shows this as Availability Fee - 30/09/2013, with the formula “=Inputs!H101*(1-$C$26)”. If you then look at Cell Inspector’s list of Precedents and see that Inputs!H101 is Availability Charge - 30/09/2012, you can immediately spot that there may be a problem with misaligned columns in different sheets referring to different time periods.

If you come across a complex formula, perhaps with several nested IF() statements, you can click on the Parse Formula button to see a structured layout of the formula which will quickly identify which are the relevant components of each IF() statement. And at any time you can click the Minimise button so that you can see the parts of the worksheet which may be hidden by the Cell Inspector dialogue box.