My Zopa Spreadsheet
I have a spreadsheet written in Excel, that documents all of my Zopa investment.
What I find about Excel is that it is so illogical and nothing is intuitive. When I wrote a PC-based version of Artemis, that was a project management, spreadsheet and a graphics program, it was way in advance of Excel today for ease-of-use. But then it didn’t have all the features.
Am I being arrogant?
No! At my age and state of health I have that luxury.
On a more important theme, is the spreadsheet telling me what I should do with Zopa?
I think so and I’ll be making changes to my lending philosophy in the next few days.
The Anonymous Widower 
You’re dead right about Excel. I have used it a lot to produced some quite compex business models. At times one has to write enormously long formulae, often with repetition within the same statement. Given also that there is little control over errors such as divide by zero, error checking has to be built into nearly every formula. On the other side there is the power of the bulit-in VBA, and I have often resorted to writing code to provide new functions that are either not available otherwise, or would result in extremely unwieldy, unsupportable code. Events (e.g. cell contents changes) can be used to trigger code to carry out checking functions.
Comment by John Wright | March 25, 2012 |
I’ve never used VBA in Excel. I prefer to write an external program in VB6 to do complex calculations. I wrote a whole project management system that way. Some people even liked it.
This is all being written with one hand. Do we need two?
Comment by AnonW | March 25, 2012 |