Rainbow Analyst And The Model AnswerAbout Us
This page provides details of the latest major update of Rainbow Analyst, as well as some background information about The Model Answer and the development of the Rainbow Analyst add-in.
Rainbow Analyst News
Our latest update
Visualise workbook structure with Rainbow 12.5
When someone sends you a spreadsheet to look at, do you ever wish there was an easy way to see what’s going on? Well, now there is, with the new Structure Map function in Rainbow 12.5. As you can see in the composite screenshot above, this gives you a simple and clear diagram of all the sheets and how they are linked.
Sheets with mainly input data are shown as purple, intermediate workings as green, and output calculations as blue, and you can also see the size of each sheet. The direction and importance of the links between them are shown by the direction of the arrows and their colour and size. And if you’re thinking the arrows are pointing the wrong way – check out the Rainbow User Guide (from row 283) for a full explanation!
We think this new function perfectly complements the Summary Report, which gives you lots of data about a workbook but needs the Structure Map to explain how it all fits together. So we’ve placed the Structure Map (and related functions) right after the Summary Report, in the Initial Overview group. And even with the Structure Map you can see the underlying data, as shown in the composite screenshot above – just click on any circle or arrow for full details. Why not download Rainbow and try it for yourself?
Where Rainbow Analyst Started
The Model Answer
Mike set up The Model Answer in 2000 as a financial modelling consultancy. At the same time, he started developing Rainbow Analyst, initially just for his own use in analysing and auditing Excel spreadsheets. Its key feature (and the reason for the name “Rainbow Analyst”) was a unique colour-coding system that makes it very easy to spot problems and inconsistencies. Over time it grew into the leading-edge commercial tool that it is today.
Before starting The Model Answer, Mike spent 17 years working for KPMG and predecessor firms. He trained as a chartered accountant (ICAEW) and chartered tax adviser (IoT), and then moved into financial modelling. His modelling projects at KPMG ranged from a spreadsheet for calculating divorce tax settlements, to a multi-dimensional simulation of the UK electricity generation system. Mike lives in London and is also a qualified psychotherapist. In his spare time he enjoys travel and riding a big-wheel unicycle.