Sometimes you have a spreadsheet that just takes forever to run VBA reports, even though you’ve tried all the usual tips and tricks. This post shows one reason I found and how I managed to fix it. I have a workbook I’m using for some life cycle cost and life cycle carbon footprint analysis. The [...]
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 [...]
We all want to find the best results for the lowest cost, but sometimes it’s not as simple as that. Imagine you have a large number of choices from which you are trying to find the best option. For example, let’s say you have a range of energy efficiency refurbishment packages available and you want [...]
By allowing Java to run while you're on this page (or even better, leaving the tab open in the background when you're browsing elsewhere) you are contributing a small but much-appreciated donation in Bitcoins towards the running of this site.