Articles
An enhanced name manager for Microsoft Excel
Named ranges are one of those marmite things in Excel, either you use them or you don't. I sit between the two camps and my utilisation depends on two things:
Firstly who the end user will be and whether they'll need to interact with them.
The other is a timesaving thing - their use will depend on if it will save me time over the long run.
My more »
Malaga to Manchester flight GPX tracklog - aborted landing
This flight was a cracker, made extra special not only for the fact it was the first I was able to fully record on my GPX logger for later analysis - but for the added drama of the flight.
First off the skies that day were a bit congested so we had to do an extra loop over Warrington whist we were waiting, but next there was great excitement.
As more »
Extract a Surname from a string in Excel
There comes a point in every Excel users workflow that they've got to work with a list of names. Usually the data you get is in the wrong format, or you have to compare two dataset of different formats. This can be frustrating but here is a quick guide of how to manipulate them.
This tutorial is based around extracting the surname / family name more »
The blog has now reached 50 posts!
Well, I didn't think I had it in me to write so much, I'm generally not a person with much to say (this is a lot for me!).
My general interest in all things tech had always since the early days compelled me to want to make my own website, trouble is you actually need to have some content to put on it.
After a while toiling I'd decided that I'd more »
- Getting ExifTool's move files to directories to work properly as Windows batch file
- How to easily & perfectly align your Stem
- How to remove bicycle tyre marks from painted walls
- What's your Robot name?
- 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