Blog


Excel: How to calculate distances between longitude / latitude co-ordinates

Excel: How to calculate distances between longitude / latitude co-ordinatesHere'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   more »



How to convert a text DDMMMYYY date in SQL

How to convert a text DDMMMYYY date in SQLAs 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 »



Excel: convert Postcode in x,y grid co-ordinates

Excel: convert Postcode in x,y grid co-ordinatesThis 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 »



Best way to optimise images and pictures to display on the web

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   more »



Share page

Search Posts

Back to top