On-Air video monitoring device

I thought it would be interesting, and incredibly useful, to build a device that displays a visual cue when my laptops webcam is turned on. I work from home and I'm in a large amount of video meetings either on Zoom or Google Meet. This handy device helps others in the household know when I'm on a video call without needing to see the screen. GitHub Repository containing full code I based my work largely on another great tutorial I found here on medium: https://edransit.medium.com/an-on-air-sign-with-iot-5bf2f2bc7dc9 The principle is the same, but things are a bit updated and expanded. I needed this to work on both my MacBook and my Linux laptop. Hardware: ESP32 microcontrollerNeopixel LED stripWooden boxTranslucent Plexiglass (3mm)Micro USB cordMosquitto Broker Server Mosquitto Server: The original tutorial utilizes an Arduino to run the broker. However, Arduinos are currently like gold because of the chip shortage and are both hard and expensive to find. Since I already have a server at home running TrueNAS, I spun up...
Read More

Google Sheets Gantt Chart

Just something I thought was a little interesting - I couldn't find any free Gantt chart web-based apps that were easily shareable (preferably in Google Docs). So, I built one using Google sheets. It's not perfect, and only has very basic functionality. It's a perfect chart for running through basic timing and milestones (particularly for a research project, which is why it's geared toward organizing a dissertation). Click below to make a copy of the link for your own usage. It does assume a level of familiarity with Excel/Sheets and the familiarity with formulas. Google Sheets Link All you need to do is the following: Add new rows if neededEdit/Add dates if needed across columnsCopy down formulas in your new rows/columns from existing (included the hidden column H), make sure to special paste formulas only so the formatting doesn't get thrown offSet your start date / due date (A light blue line will generate)Set the percentage done in the PCT OF TASK COMPLETE...
Read More