Articles
Getting ExifTool's move files to directories to work properly as Windows batch file
The automated filing of your photo's into day, month and/or year folders is great for speeding up your workflow, but I just couldn't get it working under windows.
There's plenty of information about it all over the internet but for me instead of putting it into the requisite YYMMDD folders it would just move everything into a folder called more »
How to easily & perfectly align your Stem
I don't know about your but I've always had trouble aligning my stem perfectly parallel to my front wheel. It's even more infuriating when out on the road or tail sensing even the tiniest misalignment which niggles you for weeks or even months.
The trouble is that it's really hard to quantify if it is actually out of kilter or just in your head! more »
How to remove bicycle tyre marks from painted walls
This is probably the bain of a lot of cyclist's lives, well the ones that keep their bikes indoors anyhow, despite how careful you are it is just a matter of time before you inadvertantly catch a tyre on the wall as you wheel your bike around.
No probs you would think, bit of Cif and the mark'd come right off. No such luck here, for some reason more »
What's your Robot name?
I'm usually rubbish at amusing inventive word-play - ask me to come up with a pub quiz name and I'm utterly stumped.
This one was easy for me, though I wasn't asked to think of one, the thought just randomly came up in my more »
Install apache php7 mySQL and phpmyadmin on Raspbian Stretch on a RaspberryPi
I've been eagerly awaiting the fourth version of the RaspberryPi for a while, but when it passed the point where I had expected it to be released I googled it only to find that the next incarnation may be a while.
Darn it, I have to get anothe RaspberryPi3. So the time has come to commission it and I find the lastest version of Raspian called more »
How to clean the lid and nozzle of your Camelbak Podium bottle
My first encounters with Camelbak Podium bidons were not great, I borrowed a bottle from Ali for use on quick ride but but I was soon struggling with it!
What I hadn't experienced before in my two decades of cycling was an increase in nozzle length, every time I wen't for a sip I ended up punching myself in the face - I'd have to relearn how to more »
How to enable and change the Remote IR GPIO pin in OSMC
So you want to rig up your Raspberry Pi OSMC to be controlled by your favourite remote control, easy peasy - it is just a matter of plugging the IR receiver diode in and swith GPIO on in the settings.
Dont like the standard pins 17 or 18, no problem - you can change them at teh same time, just follow these instructions.
Go to 'My OSMC,
Select 'Pi more »
Split and extract the first 1000 (N) rows from a text-csv-data file in Windows
One of the major annoyances for me working with very large datasets you get from someone else is that you often don't know the format the file is coming in, not a problem really just take a peak in Notepad++ or Excel and you are away. But quite often these files are millions of rows in length and it is just not possible to work it out. So I've more »
My new scale for measuring oldness
Well I suppose it was inevitable, when you suddenly realise you are getting older by the things you catch yourself doing/saying thinking getting more frequent.
The latest thing I've noticed is that my propensity to fart in public has increased exponentially! It used to be the case that I'd internalise the pain of holding in a ripper for hours on more »
A datedif function for excel that calculates correctly
This is one of those little quirks in excel that's annoyed me for a while, there must be some method in their madness but I've yet to come across anybody that thinks it is logically the way forward; so I've written one for you to use. The way the in-built function works is that it reports back the answer as how many months apart are the two dates more »
Raspberry Pi 3 HDMI overscan settings and how to correct them
If you've ever plugged a Raspberry Pi into a tv you've probably come across this issue - the displayed image either doesn't fill the screen or over-runs it.
The usual bit of googling reveals that all you have to do is tweak a couple of overscan settings and you are good to go. It sounds easy but three Raspberry Pis in and I've only just found the more »
Create custom Excel function using an array/range input
My new adage of "You only know what you know how to google" - Martin Childs, 2016 stood true for this little puzzler, the answer wasn't apparent from simply googling it! All I wanted was to do something to a range input in a custom Excel function, easy you'd think - not in this case. I toiled for a bit of time before conceding that I'd just have 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