Articles
Creating hyperlinks in Excel that are relative & actually work
If you've ever tried to create a hyperlinks in excel you'll know what a pain they are.
The hyperlink tool on the Insert ribbon is quite useful, but it is a pain to create a lot of them. The big problem however is that they are not relative - if you add more columns or rows suddenly your hyperlink is pointing to the wrong place.
You could use the more »
Excel Sunrise & Sunset Calculator
http://www.ecy.wa.gov/programs/eap/models.html http://www.ecy.wa.gov/programs/eap/models/twilight.zip https://www.esrl.noaa.gov/gmd/grad/solcalc/calcdetails.html more »
Raspberry Pi - record uptime
Well, i had pre-written a post celebrating a whole year of uptime for my RaspberryPi - guess I shouldn't have jinxed it! On Friday I came home to find the Pi unresponsive to web access, putty & vnc.
There was noting for it and I had to suck up the loss and kill the power, oh well I shouldn't be to disappointed, 345 days is a respectable more »
Ali goes viral
Well almost.... After Ali's niece has been addicted to watching unwrapping videos on YouTube, she decided to blog her birthday presents opening. Turns out she's quite a good blogger, admittedly I'all have to up my camera skills but you can judge for yourself on more »
Bluetooth Selfie Remote button mapping (AB Shutter 3)
So I've got myself a one of those bluetooth selfie buttons, but before you start slating me for being one of those plonkers - I am using it for other remote control purposes...
The off road satnav loaded with OS Maps which I use for navigation on my MTB sits in a waterproof case attached to my stem. The whole setup is great, I don't have to faff more »
Best place to sledge in Manchester
The only real source of places to sledge I've found is this article from the Manchester Evening News. There's a couple of good spots there but there appears to be a glaring omission - there's nothing in the Peak District, but you are probably not going to find a great hill without a bit of local knowledge!
Lyme Park comes close to it obviously but 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