Banana Theory. I meant to post a link to this a while ago but somehow didn’t quite get around to it. This is a blog post I wrote for my EngD centre at UCL and if I can drive a bit of traffic that way I’m sure they’ll thank me for it.
Monthly Archives: August 2012
One of the things I find most frustrating about VBA for Excel is the lack of a native sorting method for arrays. Perhaps it’s because there’s the option of sorting it on the worksheet, but that’s not always viable. This post is mainly just a store for VBA implementations of sorting algorithms and will probably [...]
Since I know a lot of people who come here do so for Excel-related posts, I thought it would be useful to rewrite last week’s Pareto frontiers function in VBA for Excel. Remember that 2D Pareto frontiers are the set of options which can’t be bettered on one metric without making things worse on the [...]