#automation
Every note tagged #automation, newest first — or browse the full archive.
A spreadsheet that runs payroll: a pipeline in Google Apps Script
Every two weeks I used to open a time-clock export and copy each employee's shifts, by hand, into a payroll workbook — an afternoon of careful, error-prone transcription. Now it's a one-minute import from a menu inside the spreadsheet itself. This post is the big-picture tour of how that works: what Google Apps Script is, bound versus standalone projects, converting an uploaded .xlsx on the fly, writing live formulas so a hand edit still cascades, and getting the code out of the browser and into local files and git with clasp.
From a Prompt to a Polished Excel Workbook with Codex and Sol
A reproducible demonstration of turning NASA exoplanet data into an auditable Excel workbook with natural-language prompts, Codex, the Sol model, and generated Python.
Running my day job on Claude Code — an agent architecture for non-software work
My day job isn't writing software — it's coordinating insurance-restoration jobs, which is document-heavy and relentlessly repetitive. Over a few months I built a system of Claude Code agents around that workflow. This is the architecture, the decisions that made it hold together, and what I'd change.
PowerShell Command Line Fundamentals - A Structured Learning Approach
A methodical introduction to PowerShell fundamentals with structured experimental procedures and evaluation of command functionality.