Spreadsheets work fine for belt tracking. Right up until they don't. The break point is usually somewhere between 150 and 250 students, but the failure mode looks the same at every school that hits it.
Why spreadsheets work at small scale
If you have 60 students, you know all of them. You know who's coming up on yellow belt, who's been stuck at green for six months, who paid the test fee and who didn't. The spreadsheet is a memory aid. It's not actually doing work for you.
At that size, the spreadsheet is a paper trail with about the same fidelity as your memory. Both work because the inputs are few and the outputs are few. You write down belt promotions mostly to have a record if a parent asks.
Where it breaks
Three things change as the school grows.
1. The inputs multiply faster than the rows
At 60 students you have one program. At 200 students you have kids karate (orange and green), kids karate (blue and up), teens, adults, BJJ, and a black-belt club. Each program has its own ranks. Each rank has its own criteria. The spreadsheet spawns tabs. Tabs spawn formulas. Formulas reference other tabs. You change one tab and the whole thing breaks in a way you don't notice until belt-test prep.
2. The eligibility question stops being a lookup
When a parent asks "is my kid ready for blue?", the answer isn't in a column. It's a function of attendance since the last promotion, skill checklist completion, time-in-rank, and the head instructor's judgment. In a spreadsheet, you compute this by hand each time. By the second belt test prep, you've made it a column. By the fourth, you realize the column lies, because it was last updated three months ago.
3. The data goes stale, silently
Spreadsheets don't tell you when a column is wrong. They just show you what you wrote down. By belt test day, you've spent two weeks cross-checking the spreadsheet against the actual attendance, signoffs, and notebook scribbles, because you don't trust the sheet anymore.
The two weeks of belt-test prep isn't because the test is hard to organize. It's because nobody trusts the data.
What changes when eligibility is calculated
A real system inverts the model. Instead of you maintaining columns, the system maintains a calculated state per student per rank. Attendance is logged in real time during class. Skill signoffs are tapped through on a tablet right after class. Eligibility is the answer to a query, not the contents of a column.
The practical effect: at any moment, you know who is ready for the next belt test, with no audit. You don't trust the data because of how it was maintained; you trust it because it's derived from the underlying facts every time you read it.
The five fields a real system needs
- Class count since last promotion. Counted from attendance, not entered manually.
- Time in rank. Computed from promotion date.
- Curriculum skills. Per-rank list with per-skill signoff timestamps.
- Instructor signoff. One signature, or two, depending on your rules.
- Financial state. Test fee paid, current on tuition, waiver on file.
That's it. Anything else is decoration. The spreadsheet usually accretes 12 to 20 columns before someone admits the schema is beyond saving.
A worked example
Maya Chen is a green belt working toward blue. The criteria for blue at your school: 24 classes since promotion, 120 days in rank, 22 of 22 curriculum skills signed off, head instructor approval, $45 test fee paid.
Today is March 15. Maya was promoted to green on November 12, which is 123 days ago. She's been to 26 classes since then. 22 of 22 skills are signed off. Her test fee was paid last week. The head instructor signed off three days ago after watching her spar.
In a spreadsheet, you'd find this by opening five tabs and cross-referencing. In a real system, Maya shows up on the "ready for blue" view, and a tap shows you each criterion in green. The view updates automatically when any underlying fact changes. You didn't need to "prep" anything. The data was ready the moment Maya was.
If you're still on spreadsheets
You're not behind. Spreadsheets are the right tool at the right size. Watch for the symptoms: belt test prep getting longer every quarter, instructors who can't say with confidence who's ready, the spreadsheet that "kind of works" but you don't trust during the test.
When you see two of those three, it's time. You don't have to change everything. Start with the eligibility view. Once that calculates itself, the two weeks of prep collapses into a Saturday.