Watch Rainbow Analyst in action

Watch Rainbow Analyst in action

It can take a while to get your head around what the various functions in Rainbow Analyst Professional 7.2 can do for you. So on our new Demo page we’ve put together a series of short (3-4 minutes) videos on YouTube to demonstrate how some key Rainbow functions...
Put an end to incomplete SUM() ranges

Put an end to incomplete SUM() ranges

It’s probably the classic spreadsheet error; the developer writes a simple SUM() formula which adds up sales of all products, and this works fine until a new product is added but is left out of the SUM() formula, which now gives an incorrect result. Back in the...
Track down those #REF! errors

Track down those #REF! errors

You know how annoying it can be when one of Excel’s cell errors (#REF!, #DIV/0!, #N/A and so on) creeps into your spreadsheet, and as soon as it recalculates, the whole spreadsheet seems to be filled with error values. With a large or complex spreadsheet, it can...
Rainbow Analyst 7.2 now released

Rainbow Analyst 7.2 now released

We are delighted to announce the release of the latest version 7.2 of Rainbow Analyst Professional! As trailed in previous posts, this features a major upgrade of the Map Risks function, of which the new dialog box is shown above. This now offers an array of 28...
Use this report to find hidden inconsistencies

Use this report to find hidden inconsistencies

We’ve now completed the initial coding for the powerful new analysis options in Map Risks (in Rainbow 7.2) that can help you find inconsistent references in your spreadsheets. The screenshot above shows the “Inconsistent precedent copies” report,...