Stop Running Your Taekwondo League Table in a Spreadsheet

Every club that runs a sparring league starts the same way: a spreadsheet. One tab, a row per student, a column for each week. It works — for about a month. Then a formula gets overwritten, a fight gets entered twice, someone's points don't add up, and on a Tuesday night you're refereeing an argument about who's actually in second place. The problem was never the league. It's that a hand-kept table drifts, and only one person can hold it.

Why the Spreadsheet Always Breaks

The arithmetic drifts

Points, wins, draws, losses, points for, points against, difference — that's a lot of little sums repeated every week across every student. One mistyped cell or dragged-wrong formula and the standings are quietly wrong. Nobody notices until someone who should be top isn't, and then you're auditing eight weeks of entries by torchlight.

Only one person owns it

The league lives on one laptop, in one person's account. When they're away, the table doesn't get updated. When they leave the club, the whole league can leave with them. That's a fragile thing to hang a season on.

Nobody can see it live

A spreadsheet sits on a screen at home. Students can't watch their position change on the night. Parents never see it. The single most motivating thing about a league — watching yourself climb — is locked in a file only the instructor opens.

Tiebreaks are inconsistent

Two students finish level on points. Who's ahead? In a spreadsheet, it's however you happened to sort it that week. Do it by hand and the order changes depending on who's typing. A league needs one rule, applied the same way every single time.

What an Automatic League Table Does Instead

The fix is simple: stop storing the table, and start storing the fights. You record each result — who fought, the score, who won — and the standings are calculated from that, fresh, every time anyone looks. There's no table to overwrite because the table isn't a thing you maintain; it's a thing that's derived.

The columns calculate themselves

From the fights alone, every column falls out automatically:

• Fights, Wins, Draws, Losses — counted.
• Points for and against — summed from the real match scores.
• Points difference — for a fair, built-in tiebreak.
• League points — win/draw/loss totalled, ranked automatically.

Enter a result and the whole table re-ranks on the spot. Nothing to drag, nothing to sum, nothing to get wrong.

Ties break the same way, every time

Level on points is settled by points difference, then points scored — the standard league order, applied identically to everyone. No debate, no re-sorting, no "well, I had them ahead."

Anyone can see it

Because the table is generated on demand, you can put it on the wall screen at the club or share a link with students and parents. The standings people see are always current, not last month's saved copy.

It's not tied to one person

The league lives with the club, not on someone's laptop. Any instructor can run a match day, enter results and pull up the standings. Cover is easy; handover is nothing.

What You Keep From the Spreadsheet

You don't lose the flexibility that made the spreadsheet feel necessary:

• The instructor still pairs fighters — you're not handing pairings to an algorithm that can't see a size mismatch.
• You still choose the points — 3/1/0 by default, changeable if your federation differs.
• You can still enter scores by hand — type the result in on the night, exactly like a spreadsheet, just without the sums.

It's the same league you already run. It just can't drift, and it isn't trapped in one file.

Making the Switch

1. Set up your class (or classes) so students land in the right league.
2. Add your students once — they carry across every week.
3. From next match day, record fights instead of updating a grid.
4. Show the live table on a screen or a shared link.

You don't need to migrate the old spreadsheet. Draw a line, start the new season fresh, and let the table look after itself from here.

Key Takeaways

• Spreadsheet league tables drift, live on one laptop, and can't be seen live.
• Store the fights, not the table — the standings then calculate themselves.
• Wins, draws, losses, points for/against, difference and league points are all automatic.
• Ties break the same way every time, so there's nothing to argue about.
• You keep instructor-led pairing, custom points and manual score entry.