It is Tuesday 3:15. The Beginner Ballet instructor is walking a five-year-old through first position when the studio manager opens the master roster for the spring recital and notices — for the third time this term — that the Tuesday 3:15 Beginner Ballet and the Tuesday 4:00 Tap have been assigned the same room. The studio has been running that way for six weeks. A parent noticed last week. Nobody else did.
The schedule lives in a spreadsheet. It has lived in a spreadsheet for as long as the studio has been open. The principal built it in 2019, copied it forward every September, color-coded the headers, locked the first row, and added a tab for "room conflicts" that nobody opens. It works. It also is the single most fragile piece of the operation.
Spreadsheets were not built for recurring weekly schedules
A class schedule is not a list. It is a three-dimensional object — day and time across the top, room and instructor down the side, level and enrollment in the cells — that has to stay consistent week after week for a term. A spreadsheet is a flat grid. You can fake the third dimension with conditional formatting, but the moment a parent switches from Tuesday 3:15 Beginner Ballet to Tuesday 4:00 Beginner Ballet — same level, different time slot — the room, the teacher, and the enrollment count all shift and the spreadsheet has no idea.
Three things go wrong first, in this order:
- Two classes land on the same room in the same hour because the room column was sorted, not the time column.
- A teacher is double-booked across rooms because nobody checks the existing assignments before adding a new one.
- A level change — Beginner to Intermediate, Pre-Ballet to Ballet I — quietly drops the student from one list and adds them to another, and the recital build loses a body.
The hidden cost is bigger than the front-desk phone time
Everyone talks about the front-desk phone time as if it were the cost. A parent calls because they cannot tell whether their child is in the Tuesday 3:15 or the Wednesday 4:00 Beginner Ballet. The studio manager stops what she is doing, looks up the row, and reads it back. That is real time. It is also the smallest cost.
The bigger cost is recital build. The costume order goes in eight weeks before the show, and it is keyed off the roster the schedule prints. If the schedule is wrong — a child counted twice, a child missing, a level mislabeled — the costume order is wrong. A wrong costume order means a costume that does not fit, a child whose costume arrives in a different size than the rest of the line, and a parent who is on the phone with the studio manager two days before dress rehearsal asking why.
Spreadsheets do not warn you. They do not surface conflicts. They do not tell you that the Tuesday 3:15 Beginner Ballet lost three dancers to the same Wednesday 4:00 hip-hop class that started in October. They do not correlate attendance against the recital roster to flag the family who has not walked through the door since November but whose costume deposit is still on the books.
See My Studio Helper on a 3-month free trial
Bring your master roster. We will show you the conflicts a spreadsheet hides and the recital-roster gaps it quietly creates.
What changes when the schedule is a real record
A scheduling system — not a spreadsheet — does three things well. First, it makes conflicts loud. The Tuesday 3:15 Beginner Ballet cannot be in Studio A and Studio B at 3:15 on the same Tuesday; the system refuses the second assignment and asks which one is correct. Second, it carries history. A student who moved from Tuesday 3:15 to Tuesday 4:00 six weeks ago is still a member of Tuesday 4:00 with their full attendance history. Third, it correlates. Attendance drops in the Tuesday 3:15 Beginner Ballet correlate with the new Wednesday 4:00 hip-hop — and the system can show the principal that pattern across a term without anyone rebuilding a pivot table by hand.
None of these are exotic. Every studio management platform built in the last fifteen years has some version of this. Jackrabbit Dance, DanceStudio-Pro, MindBody, Studio Director — they are all scheduling systems of record. The problem is that most studios only use the scheduling module for the calendar grid, and they keep the schedule they actually run their recital build off in a spreadsheet copy. The two drift apart within a month.
How My Studio Helper treats scheduling
My Studio Helper does not replace your studio management platform. We read from it. Jackrabbit Dance, DanceStudio-Pro, MindBody, and Studio Director are the systems of record; the schedule that runs the recital build lives there. My Studio Helper reads the schedule, the attendance, and the enrollment history, and surfaces the three things a spreadsheet hides: room and teacher conflicts, level-change drops, and quiet families whose costume deposits are still on the books but whose attendance went to zero after the December break.
The principal still owns the schedule. The studio manager still makes the change in Jackrabbit. My Studio Helper does the audit the principal would run if she had the hour — before the conflict becomes a parent phone call, before the level drop becomes a missing costume, before the quiet family becomes a February empty chair in the recital build.
The schedule is one battle worth handing off. There are ten other motions a studio principal fights every term, and they each deserve the same treatment. The Tuesday 3:15 Beginner Ballet is just the one where the cost of getting it wrong is most visible — five-year-olds in tutus on recital day, and a parent who is going to remember whose fault it was.
See the desk vs. the spreadsheet side-by-side
Three motions a spreadsheet hides — the trial-to-enrolled follow-up, the costume-deposit cadence, and the morning revenue-and-attendance brief — walked through on a single page.
See how My Studio Helper reads your schedule
Walk the Tuesday 3:15 Beginner Ballet through with the team — from the master roster to the recital build — and see what a scheduling system of record surfaces that a spreadsheet hides.
Janelle Park
Founder, My Studio Helper