Barclays Bike API data feed

I’ve been working on aggregating data regarding the number of Barclays bikes there are available at certain docks. I had tried using some third-party Barclays Bike API sources because I didn’t realise that TFL already had easily accessible data for this.
Continue Reading

Working out aspect ratios in Excel

Aspect Ratios in ExcelI’ve spent most of my time at work recently building a big ol’ database with specifications of screens. Once the structure had been completed, I needed to import all existing data (stored in an Excel spreadsheet) in to the database. I’ve build the database with a form where everything can be put in. Functionality of this form includes automatically calculating aspect ratios from width and height pixel dimensions – something that didn’t exist in the spreadsheet.
Continue Reading