Articles
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 »
Logitech K375s Wireless Keyboard review
I've had my Surface Pro 3 now for a while but have not fully commissioned it as my everyday computer as I've been struggluing to integrate it into my setup. As my ageing gaming rig is nearing the end of it's life I've been reluctant to let it go and have been Verdict - Great Love the key feel nice and light wakes my 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 »
Power On, Off & reset switches for a Raspberry Pi 3
It's a bit of an onnoyance for Raspberry Pi owners all over not having hardward buttons to turn you pi on and off> You can't blame the RPI Foundation - it doesn't come with a case and they are trying to make the board as cheap as possible. It is still puzzling me that there are no tutorials out there to give you both, 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 »
Convert trendline equations into formulas in Excel easily
We've all been there, you've created a graph in excel, needed to smooth or extrapolate the data so have resorted to doing a quick and dirty trendline.
1
2
=trendlineparse("y = 2.6948ln(x) - 0.4039 ",2)
Public Function TrendlineParse(Eqtn As String, Optional xVal As Variant = "eq", Optional xType As Variant = 0) As Variant
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 »
Excel GPX route plotter
quick and dirty but.... See previous post of how to do it more »
- How to easily & perfectly align your Stem
- 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