In Rainbow 12.6 we’ve introduced two new features which make Rainbow a powerful audit sampling tool. These are a new Find Cells function, and a major enhancement to the Sample Data function.

The new Find Cells function gives you a powerful tool to find any of 6 different types of data that match one of up to 12 different types of condition (e.g. “is between”, “is greater than”, “ends with”). This is far more sophisticated than Excel’s built-in Find function, and as you can see in this screenshot, it can (for instance) find all dates that fall on a weekend.

It can also (for example) find all times between 11:00pm and 2:00am, or all numeric values over a certain limit, or all text cells starting with “Note:”, or all formulas containing “RAND(“. And it has been optimised for speed, so in practical use it’s only slightly slower than Excel’s own Find function.

We’ve used the capabilities of the new Find Cells function as the basis for major enhancements to the Sample Data function, designed for use in audit sampling. As you can see in the composite screenshot at the top of the page, the Sample Data function now has a “conditional search” mode which gives you all the power of Find Cells to select your audit sample.

So (for instance) you could select all data entries completed at weekends, or after working hours, or by a certain individual, or all SKU numbers beginning or ending with certain letters or digits. And if this gives you an audit sample which is larger than you need, you can tell Rainbow to select only every other instance, or every third occurrence, and so on. And like the Find Cells function, the new Sample Data function has been optimised to run much faster than in previous Rainbow versions.

If you’re not sure how many items you need for a valid audit sample, then as you can see above, Rainbow can help with this too. The new sample size calculator uses the widely recognised Cochran formula (with finite population correction) to deliver the same results as industry-standard online calculators.

If you’re not convinced that the functionality described here gives Rainbow a whole new area of application in audit sampling, why not find out for yourself with a 30-day free trial?