Strav's blog

Here are a number of links related to Arduino Deep Sleep.

Wemos D1 mini - sleep?
Making the ESP8266 Low-Powered With Deep Sleep
Put your Arduino to Sleep (using wake up INTERRUPT)
Wakeup From Sleep With a Timer (ESP32 + Arduino series)
ESP32 Secrets: Interrupts, and Deep-Sleep under the Hood
Max deep sleep for ESP8266
WeMos D1 mini (esp8266) deep sleep mode
WeMos D1 mini (esp8266), the three type of sleep mode to manage energy savings – Part 4
Arduino OTA and deep sleep
IoT Device with Deep Sleep example (Arduino code)
Deep sleep in Arduino

Here are some links to advanced filtering in Excel

Excel Filter to Match List of Items
Excel Advanced Filter Items in a List
Advanced Filter Criteria Examples

When my garage door is up, it blocks a significant portion of the ceiling lights.  This is a solution (a bit pricey though).

Liinc Garage Door Lighting

Here are some links to info about MQTT

Retained Messages
Last Will and Testament
MQTT Client Library Encyclopedia
php-mqtt
Display MQTT Data on a Webpage
MQTT Over WebSockets

I've been running the Ampache Docker image for a while now - generally solid but the upgrade process can be troublesome.  I've had some issues while restarting the container where apache fails to start/continue running.  The fix for this is to delete the /run/apache2/apache2.pid file then restart the container.