The Model Answer

Although we haven't posted here for a while, we've been busy behind the scenes with new features in Rainbow Analyst. The latest addition is an all-new Deep Structure report:
https://www.themodelanswer.com/news/rainbow-26-02-reveals-whats-buried-in-your-workbook/

And last year we introduced a high-speed Logic Map function:
https://www.themodelanswer.com/news/see-a-logic-map-of-your-whole-workbook-v25-01/

And we added Monetary Unit Sampling to our Sample Data function:
https://www.themodelanswer.com/news/monetary-unit-sampling-mus-and-new-high-speed-logic-map/

If you haven't checked out Rainbow Analyst recently, you might be surprised at what it can do for you!

Monetary Unit Sampling (MUS) and new high-speed Logic Map | Rainbow Analyst Monetary Unit Sampling (MUS) and new high-speed Logic Map by Mike Shallcross | Feb 1, 2025 | News This is our first blog for a while, but the start of 2025 brings important new features to Rainbow! In fact one of these is so important that we’ll devote a whole blog to it later, and just mention it...

Read about how the new risk analysis options in Rainbow version 12 can help you find hidden cells and uncover risky macros:

Find hidden cells and risky macros - Rainbow Analyst New risk analysis options in Rainbow version 12 help you find hidden cells and highlight risky macros.

More about new features in version 12.0! This time we're looking at how you can use the Logic Analysis function. With the Cells and Data tabs, you can create a map that shows you at a glance the basic structure of your spreadsheet. Further details at:

Map your spreadsheet structure with Logic Analysis - Rainbow Analyst Rainbow's Logic Analysis function lets you create a visual map of the layout and structure of your spreadsheet.

Rainbow version 12.0 is now live! This brings a host of improvements, including new risk analysis options, functions to analyse and compare macro code, and a new high-powered clean-up function. More details on our website at:

Rainbow 12.0 brings new functionality - Rainbow Analyst 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...

We've just released version 11.4 of our spreadsheet audit add-in Rainbow Analyst Professional, to give you a faster, smoother experience in everyday use. More details on our website at

Usability improvements in Rainbow 11.4 - Rainbow Analyst 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 al...