Home Assistant and Apple Watch – Actions and Complications Guide
Introduction In this guide, I’ll be going through how to make the most of the integration between Apple Watch and Home Assistant including Actions and an overview and examples of …
Home Assistant with a Ring Doorbell in 2022
In this post, we will go through in detail how to integrate Home Assistant with a Ring doorbell, add an automation and download videos locally. If you haven’t seen my …
Home Assistant Beginner’s Guide in 2022
Home Assistant is an Open source home automation tool that is constantly being updated and enhanced through contributions from a large DIY community. Home Assistant is perfect to run on …
How to report from an Outlook Mailbox – Quick and Simple Reporting
Have you ever wanted to report on an Outlook mailbox? There is a simple way using Microsoft Access to report on the emails in any mailbox and folder. There are …
Introduction to Power Apps – First Time User Tutorial
Introduction Today’s tutorial is to go through the basics of Microsoft Power Apps. Power Apps is a tool from Microsoft that allows you to build custom apps with connectivity and functionality …
Connecting a stepper motor to Hassio/Home Assistant using a NodeMCU via MQTT
The following guide will take you through how to connect a stepper motor to your Home Assistant/Hassio using a NodeMCU via MQTT. What you will need (or equivalent): NodeMCU (Banggood …
Home Assistant: Cheap and Easy Sprinkler Automation
The following guide will take you through how to automate your sprinkler system using a simple and cost effective method. What you will need: Sonoff Switch – I’m using the …
Top basic and advanced Excel formulas and shortcuts
Whether you love or hate using Excel, it is an extremely useful tool in a workplace or even home to easily calculate, analyse, audit and display data in a logical …
Excel Looking up values (VLOOKUP, INDEX, MATCH
VLOOKUP =VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup]) Looks for a value in the leftmost column of a table, and then returns a value in the same row from a column you specify. …
Excel Basic Statistics (AVERAGE, MIN, MAX, MEDIAN, MODE)
AVERAGE =AVERAGE(number1, [number2], …) Returns the average (arithmetic mean) of its arguments, which can be numbers or names, arrays, or references that contain numbers MIN =MIN(number1, [number2], …) Returns the …