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.