Latest Updates

In our last post we introduced the new Deep Structure function in Rainbow, which you’ll find on the menu under Summary Report. This lets you see at a glance which are the largest worksheets (tabs) in your workbook, and what sort of content each worksheet holds. And…

Did you know that there’s a completely different way of looking at an Excel spreadsheet? And that it can show you information that you didn’t know was there, helping you avoid disastrous errors like the leak of data about Afghan personnel in 2022 that was…

There’s been a Logic Map function in Rainbow for some time, showing you very useful information about which cells are inputs (i.e. other calculations depend on them, but they themselves are not calculated), which cells are workings (i.e. they are calculated, and…

We’ve now released Rainbow Analyst Professional 7.2.1, which lets you analyse risks in your spreadsheet in just two clicks using Rainbow’s “Map Risks” function! We realised that the 28 different Map Risks analysis options could be a bit…

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…

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…

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…

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…

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,…