Author Archives: Mike Shallcross

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 can uncover problems and errors in a… Continue Reading

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 eighties a Florida company sued Lotus over an… Continue Reading

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 be difficult to track down all the cells… Continue Reading

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 sophisticated analysis options to help you detect risks… Continue Reading

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, which finds inconsistencies between the precedents of copied formulas. You can see in the first line that cell… Continue Reading

Improved risk detection coming in Rainbow 7.2

Improved risk detection coming in Rainbow 7.2

As you can see from the screen image above, the next version of Rainbow (version 7.2, scheduled for release in December) will give you a much greater range of risk detection capabilities using the Map Risks function. The new Map Risks function will be able to analyse 28 different potential risks, and the new risk… Continue Reading

New Rainbow Analyst 7.0 released

New Rainbow Analyst 7.0 released

We are proud to release the latest version 7.0 of Rainbow Analyst Professional, with many new features including: Multiple colours per cell; Colour identification and tracking; Quick file clean-up; Integrated “file save as”; Random and periodic data sampling; Automatic event logging; Improved workbook/sheet selection; Full keyboard shortcuts. The biggest change, and one that affects most… Continue Reading

Rainbow 7.0 on the way

Rainbow 7.0 on the way

That’s right, we have now added so many new features to the forthcoming release of Rainbow that we will be badging it as Rainbow 7.0 instead of 6.3. We have overhauled not only the colour management system (as detailed in our last post), but also the sub-systems for workbook management and error logging. There’s now… Continue Reading

Coming next in Rainbow 6.3

We’ve built on some modifications we introduced for a recent corporate client (which we called version 6.2), and in the next couple of months we will be releasing version 6.3. There’s a new File Control group at the beginning of the Rainbow 6.3 tab, which makes it even easier for you to manage your Excel… Continue Reading

More new features in Rainbow 6.1

A couple more new features that we’ve added to the latest (6.1.2) release of Rainbow Analyst Professional, to make your spreadsheet audit process as intuitive as possible: A new function (in the Format Editor) that will clear existing colours from your spreadsheet at the click of a mouse, so that you can be sure that… Continue Reading

Back to topAdministration