Making VBA run faster

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 basis […]

Refurbish or replace?

A new paper in Energy in Buildings looks at the process of life cycle energy analysis of buildings. This is a topic close to my heart and I’m hoping to be working on it more in the coming few years.The paper showed that life cycle energy use of buildings is 80-90% from operating energy and […]