ModellingEvery consultancy study involves constructing models that represent one or more aspects of the real-world subject. Sometimes these are just informal thought experiments—mental models—but very often it's worth formalising them into diagrams or computer models. I first used Microsoft Excel to model the operation and finances of visitor attractions in 1997. Since then I have created more than 100 models covering everything from the running costs of a small visitor centre up to the capital and operational costs and revenues over 20 years of a £80 million acquarium. Some of them concentrate on very specific aspects such as visitor flow or secondary spend. The general approach I have developed is to build a model on lots of small input assumptions, each of which is exposed to discussion and criticism. This has two big advantages:
Workshop SessionsUsually during a study I arrange workshop sessions with the client where we sit down with the model on a big screen and systematically examine the assumptions and the logic. Click on the picture at left to see part of the Staffing sheet from an actual model, showing positions, salaries, start dates and so on. What if...?A good model allows "what-if" analysis, and I have developed a range of techniques to make this as effective as possible.
Quality ControlResearch in recent years has shown that 90% of spreadsheets contain errors and that few people appreciate the risks. It has been inferred that reliance by financial institutions on unverified spreadsheets contributed to the crisis that began in 2008. Of the spreadsheets I have audited, all but the very simplest have contained errors that affected the outputs - or would affect them as soon as what-if analysis began. Against this background it would be hubris to claim that my spreadsheets are 100% free of errors. But through the European Spreadsheet Risk Interest Group I appreciate the problems and keep up with thinking on good practice. I have adopted and developed techniques to reduce the risk of errors, and have a set of software tools for troubleshooting and auditing spreadsheets. If you have doubts about an important spreadsheet I can audit it for you. |