In this tutorial I’ll show you how to use a $3.50 RF remote, a $2 RF receiver, and a Raspberry Pi to control a WiFI LED Light Bulb.

A Meter Point Administration Number is a unique number that identfies your electricity meter(s). Every electricity customer in Great Britain has one. (Some customers have more than one.) You can find out more on Wikipedia.

I work with a lot of data that includes MPANs, and I often come across invalid ones. So I wrote a single-cell MPAN-validating formula that I can put into my spreadsheets, and whilst I was at it, made a spreadsheet that explains how the validation algorithm works.

tl;dr: Get the spreadsheet

GB Electricity Network Licensees have submitted £600m of bids to the Low Carbon Networks Fund and Network Innovation Competition since 2010. Here’s how it played out, in charts.

I think I’ve finally grokked how rendering order / parsing order works - I couldn’t find a comprehensive explanation anywhere so I decided to write one.

Hugo Easy Gallery makes Hugo image galleries easy. Get the code and documentation on GitHub. Demo below.

Here are some easy-to-follow* flowcharts to help you remember the words to popular barbershop songs.

Want to use Font Awesome icons in your Hugo website content but but don’t want to keep repeating the same html tags in your markdown files? Use this shortcode…

Update 25/03/2017: I’ve combined this PhotoSwipe implementation with a shortcode that generates a responsive css gallery of all the images in a directory - see Hugo Easy Gallery.

I created a visualisation of Ofgem’s Feed-in Tariff Installation Report to test out Excel 2016’s new 3D Maps feature. The FiT Installation report shows every generator in GB (England, Wales, and Scotland) that’s registered for FiT (mostly solar PV <5MW).

I recently started re-acquainting myself with Python, and I thought solving the GHCQ nonogram would be a good problem to dive in to. Here’s what I came up with.