Business Modellers is John Drummond's financial modelling website.
We build financial models using Microsoft Excel.
Our focus is primarily commercial Real Estate, but we also qualified to work in energy and finance.
Based in London, we are proficient in the UK and European markets.
We have three USP's:
The things that worry me about Excel won't get fixed for years I am sure: proper 3-dimensional formulae; sensible evolution of its function library for business; the future of VBA and whatever might succeed it; making it easier to build addins in compiled languages. Oh well.
One of the main questions is whether to go for a cardfile type simple list or fully normalize.
On the face of it, it is a technical no-brainer. But if you cogitate on this long enough, it becomes quite a teaser. When, for example, does a list of widgets actually become a list of components of type widget or a list of things of type component of type widget. Before long, you can find yourself writing the database of everything. And it takes longer than the beautifully simple list.
The pros of normalisation are in every textbook. The cons of normalisation are often not. Here are what I think are the cons:
JD's normalisation criteria:
I've just completed two Brainbench certification tests on Microsoft Excel 2003. I passed both, one at a Masters level, beating in one case 97% of other test-takets and in in the other 99%. These are by far the best scores I have got on any Brainbench tests, which I have a fair degree of faith in.
But here's the thing. On the second test, I was guessing more than half the time. I mean, I really didn't have a clue - I have never used Pivot Tables, OLAPs or XML - I just don't believe in them.
So if I don't know what I'm doing and I'm better than nearly everyone, most people are totally lost!
|Andrew Boggis & Associes||Real Estate Modelling|
|Invesco||Rent modelling, Pan-European fund modelling, model audit|
|Manitoba Hydro||Bond modelling, bespoke function development|
|2001+||Director Business Functions, Business Software Developers and Modellers|
|1991-2001||Canary Wharf Group plc, property developers, Head of Business Planning and Appraisal|
|1989-1991||3i plc venture capitalists, Investment Excecutive|
|1987-1989||MBA London Business School , full time|
|1982-1987||BHP Billiton, Petroleum Division, Engineer/Economist|
|1981-1982||MSc Petroleum Engineering, Heriot Watt Univ.|
|Recent IT test certificates||Brainbench: PHP4, PHP5, C++ Fundamentals, Excel 2003 Fundamentals.|