Example

Introduction

Rainbow Analyst is a comprehensive spreadsheet analysis add-in for Microsoft Excel that uses colour to highlight or map potential problem areas, as well as generating a wide range of diagnostic reports.

Some of Rainbow’s default cell mapping colours are shown above (as displayed in version 6.0 with Excel 2007 or 2010; click to see the full-size image). You will see these colours in the example below; for instance you will notice that label cells are highlighted in purple and input cells in yellow.

This page provides a very small-scale example of how Rainbow Analyst can be used in practice. It shows how even a simple spreadsheet can conceal a number of potential errors, which are clearly highlighted after running a few Rainbow tests.

Example – error highlighting

To demonstrate Rainbow Analyst on a very small scale, here is a simple spreadsheet that might appear to be fairly free of errors (click to see the full-size image). Excel’s own error checking has found only one possible error, in cell D12.

And this is how it appears after invoking Rainbow Analyst to run three quick tests for dependencies, formula groups and hardcoded numbers. The colour chart at the top of this page indicates the cell types displayed here.

It is easy to spot errors from irregularities in the colour patterns. We have added notes to explain the various errors indicated here, many of which would be difficult to find (in a larger spreadsheet) without extensive checking.

For comparison, here is the spreadsheet after correcting the errors and re-running the same tests. Note that the arrangement of colours is much more regular, and is consistent across rows.

Example – printed reports

The report above was generated by Rainbow Analyst to list cells that were changed between the two versions of the spreadsheet. It groups together blocks of cells with the same change, and so is much clearer than most comparison reports.

Other useful reports generated by Rainbow Analyst include a list of all unique formula groups in a spreadsheet. This is ideal for streamlining the manual auditing of a spreadsheet.

Further information

Rainbow Analyst has many other functions. For a more detailed explanation of each menu and sub-menu item please read the User Guide. You can then visit our Rainbow downloads page to download a free 30-day evaluation copy before you decide about purchasing your own licensed copy of Rainbow Analyst.