Blog
Running a SSL certificated/authenticated HTTPS website over dynamic DNS
One of reasons why I originally held back on buying a SSL certificate for my website was that I wasn't sure that it'd work using a dynamic IP routing service - cos I didn't want to waste $15!
Well you don't need to fret about it because I can confirm it works after I eventually got round to setting up a free LetsEncrypt.org one on more »
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 »
Musing of the day 22-Feb-2017
I love an analogy, there's nothing better than pushing your explanation across the line with an unequivocal corresponding example in everyday life. I think I've crossed the line this time though, I'd been asked to rate the presentation I'd just been given on a subject outside of my specific skill set; I responded that it was more »
Free LetsEncrypt secure SSL server certificate install tutorial for Raspberry Pi
For me being SSL secured has always been the benchmark as having a bonafide website. That little green padlock next to your websites URL doesn't really mean much for a blog, but I always wanted one. At the start of last year I started thing about trying to get one.
Ever being a skinflint I wanted to pay nothing for it, but logic more »
How to make an clock for a raspberry pi with an OLED display
My dream RaspberryPi project that I am slowly chipping away at is to create the ultimate alarm clock. It is a slow burner though as at it's inception I had none of the skills I needed to pull it off.
I've now amassed all of the technical skills to pull it off and I'm just left with finalising the design and finding the time and the more »
How to run a python script as a service / in background / as a daemon
So you've written a killer python script and you want to run it in the background as a service because when you close the terminal window/SSH session it kills it. I originally worked it out when I wrote my Twitterbot app, and was going to write it up seperately then but it took me so long to get it running in the background and I tried so may more »
Using OR in SUMIF in Excel
Things have moved on since the days of DSUM, we now have the likes of SUMIFS from Excel 2007 onwards. Can't even remember life before SUMIFS having never being a fan on DSUM. But with all things in life everything moves on, everything is never good enough and now SUMIFS's shortcomings are beginning to pop up. The other week the need came more »
Geocache Log Sheets download
One of the highlights of my summer was the adoption of a supplementary passtime, having recently picked up a copy of the National Trust's 50 things to do before you are 11 3/4 to inspire fun activities to be enjoyed with my niece and nephew I proceeded to introduce them to it.
Unfortunately despite them falling very short of the cut-off turns more »
Musing of the day 09-Jan-2017
Had a right good chuckle to my self whilst on holiday in Cambodia, in the spirit of travelling light I'd left my electric toothbrush at home favoring the good ol' fashioned way of doing things. I've never been a fan of the manual way - always found it a bit too awkward and unusually for me being ambidextrous I suddenly realized that more »
Cracking ice-cream flavour combo: Coconut and chocolate
On yet another fun Saturday night out at National Cycling Centre to watch the Revolution Cycling Series I set off in search of a snack! I had often seen the ice cream stand at the Sapporo noodle bar, but had never tried the ice cream.
I joined the queue to get myself an ice cream, deciding to get two scoops (despite declining the offer more »
"You only know what you know how to google"
"You only know what you know how to google" - Martin Childs, 2016 This post was supposed to be about how create a custom Excel VBA function, the origination of the idea was despite my lifelong career of tinkering with excel I'd never come across or had the requirement to have a function cycle through the cell you input as a range to perform a more »
How to pivot data by month in SQL and output to a temporary table
There are some things that aren't easy to do in SQL as you'd like. I don't know why it has to make the seemingly simple things to complete in Excel so annoyingly tricky.
Dynamic pivots is one of those things that is overcomplicated, sure there's plenty of tutorials on the t'internet , but what they all seem to lack is 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