Blog
Excel: How to calculate distances between longitude / latitude co-ordinates
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 more »
How to convert a text DDMMMYYY date in SQL
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 »
Excel: convert Postcode in x,y grid co-ordinates
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 »
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 »
- What's your Robot name?
- How to remove bicycle tyre marks from painted walls
- Install apache php7 mySQL and phpmyadmin on Raspbian Stretch on a RaspberryPi
- How to clean the lid and nozzle of your Camelbak Podium bottle
- How to enable and change the Remote IR GPIO pin in OSMC
- Split and extract the first 1000 (N) rows from a text-csv-data file in Windows
- My new scale for measuring oldness
- A datedif function for excel that calculates correctly
- Raspberry Pi 3 HDMI overscan settings and how to correct them
- Create custom Excel function using an array/range input
- SSL on a RaspberryPi - does it slow your site down?
- Remove Real VNC from RaspberryPi Pixel and install TightVNC
- Running a SSL certificated/authenticated HTTPS website over dynamic DNS
- Excel: How to calculate distances between longitude / latitude co-ordinates
- Musing of the day 22-Feb-2017