Manage all your spreadsheets with Rainbow 11.0

Manage all your spreadsheets with Rainbow 11.0

You may have already noticed that with the release of Rainbow version 11.0 there are now two editions of Rainbow that you can download from our Home page: Rainbow Analyst Professional (Rainbow Pro) and Rainbow Governance. And if you download Rainbow Governance after having used an earlier version of Rainbow Pro, you will immediately see that the Rainbow tab (as in the composite screenshot above) looks very different.

Governance groupThe most obvious reason for the difference is that in Rainbow Governance there is an additional “Governance” group of functions on the left before the standard Rainbow Pro functions. These enable you to add an automatically-generated Table of Contents sheet at the front of each spreadsheet, which Rainbow Governance uses to register your spreadsheet, keep track of changes, and alert you to structural and design issues. And at any time Rainbow can generate a Governance report listing your entire inventory of registered spreadsheets, so that you can see at a glance the state of health of your organisation’s spreadsheet use.

We added the new Governance functions in collaboration with our colleagues at Diligence for Excel, as we wanted to acknowledge that while Rainbow Pro provides industry-leading tools for auditing individual spreadsheets, there is also often a need to manage spreadsheet use across the entire organisation. So Rainbow Governance offers all the functionality of Rainbow Pro plus a tried-and-tested solution for monitoring quality and tracking changes across your entire inventory of spreadsheets.

Comparison menuEven without the new Governance functions, you will notice that the Rainbow tab for Rainbow Analyst Professional (Rainbow Pro, starting with the Summary Report function) now looks rather different from the tab in Rainbow version 10.

This is because Rainbow Pro previously had a dual-menu system, with two different versions of the Rainbow tab, but we found that many users were missing out on the additional features of the Advanced menu (tab). So in version 11 we have succeeded in squeezing all Rainbow’s functions into just the one tab without loss of usability, by making extensive use of “split buttons”.

This means that the large buttons on the Rainbow tab represent Rainbow’s main functions, and you can click on the top half of the button (the icon) to go straight to the relevant function. But if you click the bottom half of the button (the function name), you will see a small drop-down menu with between 1 and 3 subsidiary functions related to the main function. As you can see, the Comparison Toolbox function has two subsidiary functions: Sample Data and Scramble Workbook.

Scramble Workbook is a small utility function that is also new with version 11. It enables you to randomise the data in a workbook (both numbers and optionally text) so that if the workbook is causing problems in Rainbow, you can (if permitted by your organisation) send the randomised version to us for analysis without compromising confidentiality. And equally it allows you to share the workbook with colleagues who may find it helpful to understand the logic but do not need to see the actual data.

Rainbow version 11 also incorporates numerous smaller changes which we believe will make Rainbow even more robust and easier to use. There isn’t space to list all the changes here, so please download a free trial copy and see for yourself!

Find more hidden errors with Rainbow 10.1

Find more hidden errors with Rainbow 10.1

Rainbow has always been about finding hidden errors, and version 10.1 introduces a new analysis option (in Risk Map and Formula Scan) that detects error values lurking hidden in your IF() statements. A simple example would be where cells B3 and B4 contain the value 0, and B5 contains the formula “=IF(B3>0,B3/B4,0)”. In this case… Continue Reading

Rainbow 10.0 adds perpetual licence

Rainbow 10.0 adds perpetual licence

For Rainbow 10, we’ve responded to requests from a number of users for Rainbow to include a perpetual licence. So all Rainbow version 10 licences will now allow you to continue using the same version of Rainbow even after the licence period has expired (but you will not be able to install any updates released… Continue Reading

Rainbow 9.3 for Excel 2016

Rainbow 9.3 for Excel 2016

Microsoft have always said that VBA (the language in which Rainbow is written) will be supported for the foreseeable future. However, it’s not uncommon for there to be a few teething problems with the VBA implementation in a major new release such as Office 2016. This happened with Office 2010, where there was an issue… Continue Reading

Save 20% and get answers faster

Save 20% and get answers faster

As it’s still the holiday season, we’re offering 20% off Finance and Business licences for the latest version (9.2.4) of Rainbow Pro until September 12th! And for this you get our fastest ever implementation of the Summary Report; particularly if your spreadsheet is data-heavy, the Summary Report will now zip through in a fraction of… Continue Reading

Rainbow 9.2 saves time for your team

Rainbow 9.2 saves time for your team

With Rainbow 9.2 we’ve built on the behind-the-scenes changes in version 9.0 to deliver significant new front-end capabilities: We’ve integrated Rainbow’s in-depth testing capabilities (in Risk Map and Logic Analysis) into the Formula Scan function (renamed from Formula Groups). Formula Scan can now perform a battery of tests on each formula as it scans, and… Continue Reading

New Rainbow Pro 8.2 more intuitive than ever

New Rainbow Pro 8.2 more intuitive than ever

We’re always looking for ways to make Rainbow Pro easier to understand and use, and in the just-released version 8.2 we’ve built on our “interactive reports” technology to deliver a whole new level of product integration. You can see this very clearly in the Summary Report screenshot above, showing the 20 interactive buttons (in column… Continue Reading

Stop “Too many different cell formats” errors

Stop “Too many different cell formats” errors

Have you encountered a “Too many different cell formats” error message? This often occurs as a result of copying or importing worksheets from one workbook into another, because by default Excel also imports all the custom styles (cell formats) from the source workbook. Generally there are about 50 basic styles, but when worksheets have been… Continue Reading

10% discount as Rainbow goes to Delft

10% discount as Rainbow goes to Delft

We’ve been a member of the European Spreadsheet Risks Interest Group (EuSpRIG) for some years, and on 3rd July we’ll be attending the 2014 Annual Conference, where we’ll be giving a brief demonstration of Rainbow Pro in use. So if you’re interested or you’re in the area, please do register and come along for the… Continue Reading

Back to topAdministration