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.*/ […]

TTGO Lora ESP32 V2.1 R1.6

Software Library and Pins for LoRa V2.1_1.6 Site from seller (copied below) shows: Lora, operating on SPI: 26 = DI0/IO0 23 = IRQ/RESET 18 = NSS/SEL (Slave select?) 5 = SCK (clock?) 27 = MOSI 19 = MISO SD Card, also on […]

Tips for ESP32 Development with Arduino and ESP-IDF

Purpose: collate information on development environment for the ESP32. There’s already a lot of information and forums about this board and ESP-IDF. This post collates my experiences. Arduino Core in ESP-IDF Follow instructions. I installed in esp/arduino-src/ Add to your Makefile: EXTRA_COMPONENT_DIRS […]