Find Excel spreadsheet errors with Rainbow Analyst spreadsheet audit software
Try the Rainbow test
Many research studies (both academic and commercial) have shown that all spreadsheets contain errors. The screenshot above right shows how Rainbow Analyst Pro highlights some potential errors, 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?
Check out Rainbow for free
Rainbow Analyst is a spreadsheet auditing add-in for Microsoft Excel that has been ranked #1 in an independent study at the University of Stuttgart. It comes in two versions, Rainbow Analyst Professional (Rainbow Pro) and Rainbow Analyst Personal, and as you can see from the composite screenshot above, the latest version of Rainbow Pro offers you a choice of two different menus (Standard and Advanced), giving you access to a complete Swiss Army Knife of Excel spreadsheet audit tools to help you find even the most well-hidden spreadsheet errors. Click the buttons below to check out either version of Rainbow for free:
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.