by Mike Shallcross | Jul 28, 2007 | News
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...
by Mike Shallcross | Jul 27, 2007 | News
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...
by Mike Shallcross | Jul 19, 2007 | Modelling
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...
by Mike Shallcross | Jul 18, 2007 | Modelling
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...
by Mike Shallcross | Jul 17, 2007 | Modelling
There are many issues that can present a challenge in modelling. Discussion of these can be found at some of the websites listed on our Links page, and there are also many books covering spreadsheet software packages, although these tend to focus on technical points...
