Find Excel spreadsheet errors with Rainbow Analyst spreadsheet audit tools
Excel spreadsheet audit, review and comparison – how “smelly” are your spreadsheets?
Rainbow Analyst is a spreadsheet auditing and visualisation add-in for Microsoft Excel that has been ranked #1 in an independent study at the University of Stuttgart and is in regular use by one of the UK’s largest accounting firms. It can pay for its cost within weeks, as a recent customer told us: “Rainbow Pro has paid for itself already when it was able to remove 150,000 named ranges (most of them nonsensical) from a very large file that ran out of resources using conventional means”.
The latest version of Rainbow Analyst draws on recent work by spreadsheet experts in the Netherlands and Portugal identifying various “bad smells” in spreadsheets that can indicate a heightened risk of error. As you can see above, Rainbow’s Summary Report gives your spreadsheets a quality score based on some of these “smells”, and the Analysis Wheel and Risk Map functions (which you can see on the Rainbow tab below) can detect a wide range of further bad smells in your spreadsheets.
How “smelly” are the spreadsheets that you use every day, or that you develop or review for your clients? Can you afford not to know? Click the button below to download a 30-day free trial of Rainbow Analyst Professional (Rainbow Pro):
After downloading, simply double-click the downloaded file and follow the instructions to install Rainbow for your copy of Excel. And if you’ve any questions, just visit our Installation page or send us an email.
Save time and costs in auditing, reviewing or comparing Excel spreadsheets
Rainbow Analyst is available in two versions: Professional (Rainbow Pro) and Personal. As you can see from the composite screenshot above, Rainbow Pro offers you two different ribbon menus (Standard and Advanced) with a wide range of Excel spreadsheet audit and analysis tools to help you find even the most well-hidden spreadsheet errors. Rainbow Personal has a more basic menu, but still offers many of Rainbow’s core functions. Click the buttons below to check out either version of Rainbow:
After downloading, simply double-click the downloaded file and follow the instructions to install Rainbow for your copy of Excel. And if you still think that you don’t need a tool like Rainbow Analyst, because you can find the errors in your spreadsheets by manual inspection, then try our “Rainbow test” below!
Try the Rainbow test – can you find the hidden error?
Many research studies (both academic and commercial) have shown that all spreadsheets contain errors. The screenshot above shows how Rainbow Analyst highlights some potential errors (or “bad smells” as described above), and the fact is that without Excel audit software such as Rainbow Analyst, many spreadsheet errors are likely to go undetected. If you’re not convinced, you can try the Rainbow test for yourself:
- Here is a small but realistic spreadsheet in which an error has been introduced into one of the formulas (hint: it’s in the first 100 rows). Why not give yourself 5 minutes to see if you can find it?
- And here is the same spreadsheet as highlighted by Rainbow Pro using the Formula Groups function (which you can see on the Rainbow tab below). If you didn’t manage to find the error before, how quickly can you spot it now?
It took Rainbow Pro just 4 seconds to highlight this spreadsheet, and we’re willing to bet that it saved you a lot more time than that in finding the error (which you can see very clearly in this unedited screenshot). And this was just a trivial error (that didn’t actually affect the calculated value) in a small spreadsheet; imagine the difference that Rainbow Pro could make with a large spreadsheet where the results actually matter. With prices starting from just £29 for commercial use, can you afford not to have Rainbow Pro on your Excel menu?