Category Archives: News

Map your spreadsheet structure with Logic Analysis

Map your spreadsheet structure with Logic Analysis

Have you ever wished for a spreadsheet analysis tool that lets you see at a glance the structure and layout of your spreadsheets? In Rainbow version 12, the new Cells and Data tabs in the Logic Analysis function let you do this very quickly and easily. For a practical example, check out the composite screenshot above.

You’ll see that numeric cells are highlighted in blue, dates in purple, text in yellow, and logic values in green. And for each cell type, cells with formulas are a darker colour than input cells. So here you can immediately see which are input numbers and which are calculations.

And if you look at column H, you’ll notice Rainbow has found a few issues:

  • In row 10, cells up to G10 are input values, but cell H10 is calculated.
  • Conversely in row 14, cells up to G14 are calculated, but cell H14 is an input value.
  • Even more concerning is that cell H17 looks like a number (a percentage), but actually it is a text value. And you can see from the formula bar that this is because it has been entered with an initial quote mark.

These issues could easily have escaped notice if you were trying to audit the spreadsheet without a tool like Rainbow. But with Rainbow’s Logic Analysis function you can spot them immediately.

And for another kind of spreadsheet analysis map, you can use the Dependents tab (in Logic Analysis) or the separate Logic Map function. This takes longer to run, but it creates a detailed map showing the role of each cell in the spreadsheet logic.

Watch out for our next post, in which we’ll look at the new features in Rainbow’s Risk Map function!

Rainbow 12.0 brings new functionality

Rainbow 12.0 brings new functionality

We’re proud to announce the release of Rainbow version 12.0, which brings more new features than we can cover in a single post. Some of the highlights are: Analysis options in Risk Map and Logic Analysis increased from 36 to 48. Recognition of new features in Excel like dynamic arrays and threaded comments. New functions… Continue Reading

Usability improvements in Rainbow 11.4

Usability improvements in Rainbow 11.4

With Rainbow 11.4 our main focus has been on usability rather than new functions. We’ve gone behind the scenes to optimise some of the user interface code, and you’ll now find that Rainbow loads more quickly, and starts individual functions more smoothly and with less screen flicker. You’ll also notice that you can scroll up… Continue Reading

Corporate integration in Rainbow 11.3.1

Corporate integration in Rainbow 11.3.1

With Rainbow 11.3.1 we’ve added some further features that will help Rainbow integrate smoothly into a large-corporate environment. In particular, we’ve given you control over two of Rainbow’s functions (Check For Updates and Uninstall) that could potentially cause problems in a corporate IT environment by (a) running a VBScript file and (b) modifying the corporate… Continue Reading

Quickly undo changes with Rainbow 11.2

Quickly undo changes with Rainbow 11.2

Rainbow has offered an Undo Changes function for many years, and we made it much more visible in the recently redesigned menu (in version 11.0). However, as you probably know, it was only able to operate if you had already used the Save Format function to create a “format restore point” to which Rainbow could… Continue Reading

Fix merged cell problems with Rainbow 11.1

Fix merged cell problems with Rainbow 11.1

If you ask any professional Excel developer about merged cells, they will almost certainly say something that can’t be repeated here! Merged cells can produce incorrect calculation results, prevent sorting and filtering in data tables, cause errors in macros, and waste large amounts of time when spreadsheets have to be updated. Of course if your… Continue Reading

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… Continue Reading

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.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

Back to topAdministration