Author Archives: Mike Shallcross

New features in version 6.0

Many professional Excel users have continued to use Excel 2003 rather than migrating to the completely new Ribbon interface in Excel 2007. However, in Rainbow Analyst Professional version 6.0 we have recognised that an increasing number are making the move, and we have upgraded Rainbow Analyst to take full advantage of the Ribbon interface. The… Continue Reading

Rainbow Analyst Professional awarded 5 Stars at GearDownload.com and BestShareware.net

Following the inclusion of Rainbow Analyst in the Softpedia software database (see earlier news item), Rainbow Analyst Professional has now been awarded 5 Stars at GearDownload.com as well as at BestShareware.net. These are unsolicited ratings, and we are delighted at this further recognition of the quality of our product. Continue Reading

Version 5.1 now Excel® 2007 compatible

We have just released version 5.1 of Rainbow Analyst Professional, and the main news about this release is that it is compatible with Microsoft Excel 2007. We have fixed a few issues that made previous releases incompatible with Excel 2007, so you can now use Rainbow Analyst Professional with the latest version of Microsoft Office.… Continue Reading

Free upgrade to Professional version 5

If you are using an earlier version of Rainbow Analyst Professional, you are missing out on a wide range of new features introduced in version 5, not to mention the completely redesigned user interface (see details below on this page). Now that version 5 has been available for over a year, we are offering the… Continue Reading

Rainbow Analyst Personal available free

Are you looking for a simple but powerful spreadsheet checker for casual or home use? Our Rainbow Analyst Personal add-in is now available completely free of charge! It offers many of the key features of our flagship Professional product, such as Formula Groups and Dependencies, in a simple and clear package. Rainbow Analyst Personal has… Continue Reading

New features in version 5.0

The most obvious new feature in version 5.0 of Rainbow Analyst Professional is a completely redesigned front end. Nearly all Rainbow’s functions are now accessed via a dialogue box similar to the one shown here, which lets you change the selected workbook/ worksheet and the output medium (colour, map, report) as well as any function-specific… Continue Reading

The Cell Inspector function

Version 5.0 is the first full version of Rainbow to include the Cell Inspector, an interactive function which displays the precedents and dependents of the currently selected cell, and also provides a best-guess description of the meaning of each cell. It will take you to each precedent or dependent (double-click on the relevant line) so… Continue Reading

The value of quality

Many studies over the past ten years have shown that up to 90% of models contain significant errors. Generally these errors go undetected, but there have been some well-publicised cases where they have resulted in financial loss and embarrassment. For example, an employee at a US investment fund omitted the minus sign on a figure… Continue Reading

Key quality principles

The hallmark of a good model is that it is clearly laid out and easy to understand, so minimising the possibility of errors such as that mentioned above. Some key steps to achieving this are: Design, then develop, then test Separate the inputs from the calculations Use only one formula per row Avoid balancing figures… Continue Reading

Back to topAdministration