Blog


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



My new scale for measuring oldness

My new scale for measuring oldnessWell 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   more »

Tags : parp trump scale


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



Raspberry Pi 3 HDMI overscan settings and how to correct them

Raspberry Pi 3 HDMI overscan settings and how to correct themIf 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   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   more »



SSL on a RaspberryPi - does it slow your site down?

SSL on a RaspberryPi - does it slow your site down?First up I'm sorry about bathering on about this SSH thing but I to be honest I'm padding out the blog posts a little bit as there's one article I've written that I'm just not sure I want to publish, It's nothing bad, just not in keeping with the tone of this site so I've racked it up at the end of the post ready to go   more »



Remove Real VNC from RaspberryPi Pixel and install TightVNC

Remove Real VNC from RaspberryPi Pixel and install TightVNCI came across my old shortcut on my windows machine to vnc onto the Pi which prompted me to have a go connecting to my new RaspberryPi3. I duly fired it up only to receive an error message along the lines of 'No configured security type is supported'. After a bit of research it turns out that RealVNC has upped their security protocols and   more »



Running a SSL certificated/authenticated HTTPS website over dynamic DNS

Running a SSL certificated/authenticated HTTPS website over dynamic DNSOne 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

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 »



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

Free LetsEncrypt secure SSL server certificate install tutorial for Raspberry PiFor 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

How to make an clock for a raspberry pi with an OLED displayMy 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 »



Share page

Subscribe to newsletter

Search Posts

Back to top