About Spaghetti Scripting

Most useful scripts start out as spaghetti: a quick fix, a Stack Overflow answer, or a chunk of AI-generated code that works but nobody quite knows why. This site takes those scripts and untangles them.

Every write-up follows the same shape:

1. The problem: a real task, stated plainly.
2. The script: complete and tested, ready to copy or download.
3. How it works: each block explained in plain English.
4. Running it: what to install and what to expect.
5. Variations: modifications and add-ons for your own situation.

Where the code comes from

Some scripts are written from scratch, and some start as AI-generated drafts. Either way, each one is run, simplified where possible, and annotated by hand before it's published. If you find a bug or a better way to do something, I'd like to hear about it.

Topics

Python for data cleaning and analytics, VBA for Excel automation, R for statistics, and scripts for talking to hardware over serial ports. Browse by tag to find what you need.