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…

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

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…

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…

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…