Following the inclusion of Rainbow Analyst in the Softpedia software database (see earlier news item), Rainbow Analyst Professional has now been awarded 5 Stars at BestShareware.net. We are delighted at this further recognition of the quality of our product, as BestShareware.net promises to include “Only the best software; we focus on quality not quantity”.

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.