There's a quiet art to teaching a class that repeats, and this Pilates instructor has stumbled onto a genuinely useful problem: how do you keep the music fresh for the regulars without overhauling a playlist that works? The instinct to track which songs your students have heard, and when, is not overthinking. It's the difference between guessing and knowing, and for a teacher who sees the same 15 percent of students across morning and evening sessions, that knowledge is the difference between a class that hums and one that quietly grates.
The pivot table struggle is real, but the solution isn't a more complicated table. It's a relational approach: one sheet for classes, one for students, one for songs, and a simple lookup that ties them together. The instructor already has the raw materials, the date of class, the student name, the song title. The missing piece is a way to connect those dots without forcing a single grid to do all the work. A pivot table fails here because it wants to summarize one dimension, but the question is fundamentally two-dimensional: which student heard which song, on which date. That's a job for a few clean columns and a filter, not a single cross-tab.
What's encouraging is that the instructor already understands the core principle: repetition isn't the enemy, unexamined repetition is. Reusing a song across classes is fine, even smart, if the tempo fits and the sequence works. The problem only appears when a student like Milo hears "Call Me Maybe" three times in four months and starts mouthing the lyrics before the beat drops. That's not a music problem, it's a data problem, and it's solvable with a spreadsheet that treats each class attendance as a row, each song as a row, and each student as a row, then lets a simple relationship do the counting.
The practical takeaway is this: stop trying to make one table answer every question. Build three small tables, link them by date and name, and let a filter or a simple formula do the heavy lifting. The instructor doesn't need a dashboard or a script, just a clear structure and the patience to log the data once. That's the real work, and it's worth it. Because when you're teaching the same bodies twice in one day, the music isn't background. It's part of the rhythm, and rhythm, like attendance, is something you can track.