Mini Battery and Solar Powered Timelapse Camera

I wanted a small, battery-powered timelapse camera. First I tried mobile phones but they were not stable in the long term. Previously I’d used a Raspberry Pi which is good, but not battery friendly, a bit big, and a bit of an […]

Installing Monit on AWS

Unfortunately, AWS (ec2) doesn’t come with monit available via: So we need to do the following: Get binary from https://mmonit.com/monit/#download Install manually: Install as a service: https://mmonit.com/wiki/Monit/Systemd Check it’s running. When running, be sure to use sudo (root):

VBA Regex

Typical Replacement Example Dim objRegExp As Object ‘ RegExp using Microsoft VBScript 5.5 Set objRegExp = CreateObject(vbscript.regexp) Dim res As String res = Some text to stuff around with objRegExp.Global = True ‘ match all instance objRegExp.IgnoreCase = True ‘ Multi-space to […]

Time Lapsing with Raspberry Pi

Time Lapse Setup TimeLapse on RPi Enable camera via raspi-config Get pi-timolo which provides a nice script set and configuration to run time lapses Follow the update instructions on that page. Install pi-timolo as a service if you like. I found that […]

Web Design Services

I specialise in websites for: Small Australian businesses Bed and Breakfasts, and small hotels Architectural firms Retailers needing banking and e-commerce integration Since I work from home, I can keep costs down. Please contact me directly to discuss your requirements. I’m a […]

Beeson Excel Function

What is it? These add-in contains various User Defined Functions. They can answer the following Where is the Sunday in London on Friday afternoon in 2020? What is the wetbulb for a given humidity? How big should my duct / compressed air […]

Hacking the Sungrow 5 Inverter

This inverter has a WiFi connection and opens ports 80 (password protected) and 502 (modbus). It’s possible to read the modbus registers. There’s a handy script that’s done all the hard work. This can import into Influx, as shown below on the […]

Access Grafana via token without login screen

This explains how I implemented a previously outlined solution, in a step-by-step fashion. I initially struggled to get this running.   There’s the method that worked. Overview The goal is to give someone a unique link, through which they can logon without a […]

Investigating for IotaWatt, AWS, InfluxDB and Grafana

I’ve previously used EmonCMS to log power and energy data from a IotaWatt  / EmonTx system. This works well, but I’ve been looking for a flexible and fast alternative. The combination of IotaWatt, InfluxDB and Grafana look to provide this. My experiences […]

Tips for InfluxDB and Grafana when using IotaWatt

This post is a collection of tips, in no particular order. It follows on from Iotawatt, InfluxDB and Grafana Setup which is a step-by-step. Do that first, then tweak with these. Snippets for Influx # Delete a CT delete from iotawatt where ct=~/Circuit.*/ […]