NOTES / TECHNICAL WRITING

Notes on data, automation and tools.

Technical notes, design criteria and small experiments. Categories are a map rather than rigid boundaries.

EXCEL · POWER QUERY · DATA & SQL · AUTOMATION · MUSIC & SYSTEMS

Excel Add-ins: turning a macro into a reusable tool ↗

When a recurring macro deserves to become a reusable XLAM tool.

Excel as a front-end for Oracle: when it makes sense ↗

When Excel is a useful interface and when it is starting to become a parallel database.

Power Query beyond data import ↗

Repository, transformation, control and output as one repeatable pipeline.

Automating remote checks with VBA and SSH ↗

Turning a read-only remote command into a repeatable operational control.

Designing a small tool instead of yet another Excel workbook ↗

Reduce unnecessary decisions, separate configuration from operation and automate the path.

Snapshots and data audit: a practical pattern ↗

Reconstructing data history so changes and responsibility become visible.

Excel works best when its tools work together ↗

Tables, formulas, Power Query, VBA and Power Pivot, each used where it belongs.

Patterns, variations and systems ↗

Patterns, repetition and emergent behaviour as a shared thread between systems and music.

Repetition does not mean staying the same ↗

Why repeated structure makes small variations easier to hear.