The Medal Table Was Wrong: How One Spreadsheet Error Damages a Federation's Reputation
Monday morning. Your published medal table has one club with 14 medals. They actually won 12. The club with 9 medals on your table actually won 11. You have not noticed yet. They have. One of them is the federation president's club. Tuesday is going to be a long day.
How medal tables go wrong
Almost always one of three things:
- Category mis-tagging. A medallist is tagged to the wrong club because someone typed the club name inconsistently (TKD United vs T.K.D. United vs TKD-United).
- Double-counted medals. A fighter placed in two events (patterns + sparring) and someone counted one of them twice.
- Missed results. One category's results never made it off the ring into the master sheet.
All three are transcription errors. None of them happen if the results live in one system from judge to medal table.
The reputational damage
Coaches tell other coaches. Federations tell other federations. A single wrong medal table is remembered for years. "Oh, that event — wasn't that the one where they got the medal count wrong?" said three times, and your next event has 30% fewer entries.
Why spreadsheets make this inevitable
Because the spreadsheet is built at the end of the day, under fatigue, from three different input sources. The data enters a spreadsheet cell as text — which means one extra space, one inconsistent abbreviation, and the COUNTIF that generates the medal table silently drops entries.
Related: why spreadsheets fail at multi-ring events.
What a proper system does
Each fighter is linked to a club ID — not a typed club name — at registration. Each medal is linked to a fighter ID. The medal table is a real-time query across those IDs. There is no transcription, no abbreviation, no typo, and no human step between the final whistle and the public medal table. It is correct by construction.
The lesson
Accuracy is not a feature. It is the whole product. The moment you publish one wrong result, every future result you publish is suspect. Use a system that is right by default — not one where you have to stay late on Sunday manually triple-checking.
The test. At 6pm on event day, hit "publish medal table." If the answer you hit publish on is not the correct answer, your pipeline is broken. Fix the pipeline, not the spreadsheet.
Stop firefighting. Start running events properly.
Brackets, scoring, rings and results in one place — from £39 per event.
See plans & pricing →Run your next event the way it should run.
From £39 per event — all you need is internet and a browser.
🥋 Try the live scoring demo