Articles

Whilst working on a project to output the elevation chart of a GPX track I came across some code to produce your own heatmap from a bunch of gps tracks. I thought that'd be pretty cool to visualized my own as I've been using Strava's global heatmap since it was released in 2017 to plot mountain bike routes. I was pretty bummed that when they   more »

Here's a blast from excel past, it was actually one of the more interesting projects I worked on. We were designing food waste recycling plants for the food manufacture and retail industries. The task was to calculate the most efficient solution ofhow many recycling plants to build and where to build them based on the waste arising of each shop   more »

As much as I love Excel there are some circumstances where it just doesn't cut it - more than a millions rows and computer says no; some rediculouse vlookup and you could be there for hours. So step in SQL, it can do those aforementioned tasks in a matter of seconds. There are a couple of occasions though where SQL is not king, one of these is   more »

This is a cracking blast from the past, I was digging through my old personal macro excel backups when I came across this beauty. It dates back to my recycling plant development days, I had to devise an algorithm to work out the most economical site placements for food waste recycling facilities for a given highly dispersion of waste arisings. The   more »

Conscious that hosting a website from a home internet connection from the Raspberry Pi may lead to slower load time than you'd want I've been working on speeding up its response. I've always been focused on server speed throughout its whole development in a bid to speed up load times. I think I've got it cracked – but the only thing I'm   more »