Counting Files by Type in Folders and Subfolders
A Python script to analyze and count files by type in a directory and its subdirectories, exporting results to an Excel report.
Welcome to My Site
Recent posts
VBA vs Python for Excel: Which One Should You Use?
A detailed comparison of VBA and Python for Excel automation, covering use cases, platform availability, and usage methods.
Minimal Mistakes Jekyll Theme: Hosting on GitHub & Using Liquid Archive Method
A guide to setting up the Minimal Mistakes Jekyll theme on GitHub Pages using the Liquid archive method for categories and tags.
Tuya Power Meter Overload Alarm – Will It Shut Down the Whole House?
An investigation into Tuya smart power meter overload alarms, clarifying whether they affect the entire house or just the connected device.
Getting Started with Python for Absolute Beginners Using PowerShell
A step-by-step guide for those with zero coding knowledge to set up Python and run scripts using PowerShell.
Remote Home Access in Malaysia: Understanding CGNAT and Solutions
A guide on overcoming CGNAT limitations in Malaysia for remote home access using Tailscale and Cloudflare Tunnel.
Tuya Presence Automation – Smart Home Motion Detection
help + fix for tuya presence automation
CreditCard2Excel – Convert Credit Card Statements to Excel
Save some effort on data entry from credit card statement