Over the past few months we’ve been working on the next release of Rainbow, which will have so many new features that we’ve decided to badge it as version 8.0. As you can see from the the screenshot above, we’ve reorganised the Rainbow ribbon, and added several new functions. Two of these, the Data Explorer… Continue Reading
We’ve just released Rainbow Analyst Professional version 7.2.2, which is all about ease of use and fewer mouse clicks to get where you’re going. In particular, as you can see from the composite screenshot above, we’ve added a section to the Preferences form so that you can tell Rainbow in advance how you want it… Continue Reading
A research report by three software engineering students at the University of Stuttgart has ranked Rainbow Analyst as number 1 among spreadsheet auditing tools costing less than 200 euros. As you can see from the summary table on p.41 of the report (shown above), Rainbow Analyst scored 22 points overall, compared with scores of 9… Continue Reading
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 overwhelming, so we’ve picked out 7 of the most popular options and set them as the default… Continue Reading
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
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
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
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
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
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