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 a later post in which we’ll look at the new features in Rainbow’s Risk Map function!