You are putting on your first competition, or you have already run three and you rebuild your spreadsheet every single time. You came for a file, not a demo. Here it is, formulas already written, with twelve sample rows so you can watch the ranking work before you clear the data. It is free, there is no email to leave, and you do whatever you want with it. A spreadsheet is more than enough for an in-house event at your gym. Past a certain number of athletes it starts costing you in time and mistakes, and the end of this article says exactly where that line sits.
What is inside the file
| Column | What it holds |
|---|---|
| Athlete or team | The athlete's name for individuals, the team name for pairs and teams. One row per ranked entry. |
| Division | The ranking category. Every rank is computed inside one division, never across two. |
| WOD 1 score | A number of reps, highest wins. You type this in, the rest of the row follows. |
| WOD 2 score | A time in seconds, lowest wins. 8 minutes 32 is written 512. |
| WOD 3 score | A load in kilos, heaviest wins. |
| WOD x rank | The athlete's rank on that workout, inside their division. Automatic formula, do not type over it. |
| WOD x points | Points scored on that workout, computed from the rank and the scale. |
| Total points | The sum of the points across the three workouts. |
| Tie-break | The number of first places on that row, used to split ties. |
| Overall rank | The final standing inside the division, total first, first places second. |
| Settings sheet | Points for first place, points lost per rank, and a coefficient for each of the three WODs. Change those five cells and the whole sheet recomputes. |
Download the Excel template, an .xlsx file with two sheets and the formulas already in place. If you work in Google Sheets or Numbers, take the CSV variant instead, it carries the same formulas with the scale written straight into them. The file covers three WODs and forty rows. For a fourth WOD, copy a block of three columns and add the new points column to the total. For more than forty athletes, drag the last row down and extend the formula ranges.
And for the paper on the day, the scorecard generator prints one judge sheet per athlete and per workout, with rep boxes, time cap and signatures.
The descending points formula
The principle of a multi workout ranking fits in one sentence, the winner of a workout scores the most points and every rank below scores a little less. The file uses one hundred points for first place and five points less per rank, which gives 100, 95, 90 and so on, with a floor at zero. The rank itself comes from a COUNTIFS that counts, inside the same division, how many athletes did better, then adds one. That is what guarantees two divisions never mix, even in a file sorted any way you like.
Two settings are yours to move. The first is the coefficient of each WOD, in the Settings sheet. If you want a signature workout to weigh more than an opener, put 1.5 and the points of that WOD are multiplied accordingly. The second is the loss per rank. At five points, athletes ranked past twentieth score zero on the workout, which flattens the bottom of the field. On a big roster, drop it to two or three points.
Breaking ties on first places
Two athletes finish level on total points, which happens far more often than people expect across three workouts. The rule used here is the countback, whoever won more workouts goes ahead. The file counts the first places of each row in a dedicated column, then the overall rank sorts on the total and uses that column as its second criterion. If the tie survives that, both rows share the same rank and the sheet shows it as it is, rather than deciding for you. What happens next is your call, a tie-break announced at the briefing or a shared place.
What the spreadsheet will not do on the day
This file does its job very well the day before and the day after. On competition day it hits five walls, and none of them is a formula problem. Here they are, plainly, because finding them out at noon on Saturday costs a lot more than reading them now.
Two people cannot type at the same time
A spreadsheet is built for one user. The moment two judges want to enter their scores in parallel, you end up with two copies of the file, or one shared version where the last save wipes the other person's work. The usual workaround is to funnel every score through one person at the desk, which turns that person into a bottleneck for eight hours. Every score goes through them, and so does every typo.
One heat slips and the schedule is rebuilt by hand
A spreadsheet knows scores, never times of day. On the day, one heat runs twenty minutes late, an athlete does not show, two divisions drift apart. Everything downstream is replanned by hand, in another file, while athletes keep asking when they are on. It is the single most time consuming task of a competition, and the spreadsheet does not help with an inch of it.
One athlete who drops out skews the total
A withdrawal, an injury in the warm-up, a workout left unfinished. The score cell stays empty, the rank and the points of that workout stay empty too, and the total simply adds up what exists. In other words the athlete scores zero on the missing workout with nothing in the file saying so. The usual rule is to place them last of their division on that workout, which is not the same outcome at all. You decide, then you apply it row by row.
None of this shows up in the room
A spreadsheet is not a public screen. To show a ranking you export it, reformat it, project a tab with its formulas showing, or print a sheet that is wrong ten minutes later. Athletes want their rank on their phone between two workouts, and the people who came with them want to follow it from home. That expectation is now the norm, and the file has nothing to answer it with.
The ranking does not live, it gets republished
Every time you type a score, the sheet recomputes on your machine and nowhere else. Until you resend the file, redisplay the new version or refresh the projection, the rest of the venue is looking at a stale ranking. Across an eight workout competition that manual republish comes back a dozen times, always at the worst moment.
If you recognise those five walls, your spreadsheet is not badly built, a spreadsheet simply cannot do that job. That is exactly the subject of our page on running your competition without Excel, where the same cases are picked up one by one from the side of a tool built for the day itself, entry from several people at once, a schedule that replans itself, the screen in the room and a ranking that recomputes on its own. Keep the file for your training sessions and your small in-house formats, it is very good at that.
Frequently asked questions
- Yes, import the CSV variant rather than the .xlsx, the formulas are written straight into the cells and the scale is already inside them. Numbers imports the CSV too. The Settings sheet only exists in the Excel version, in the CSV the scale values are written into each formula.
- Copy a block of three columns, score, rank and points, then paste it after the third WOD. Adjust the total formula so it adds the new points column, and add the new rank to the count of first places. Give it five minutes.
- Yes, the second WOD already works that way, ranked from the smallest time to the largest. Enter the time in seconds so the comparisons stay correct. To turn a reps column into a time column, swap the greater than sign for a less than sign in its rank formula.
- There is no magic threshold, but there are two reliable signals. The first is how many people need to enter scores at the same time, and as soon as it is two, the file stops keeping up. The second is having an audience waiting on a ranking, because a spreadsheet has no way to broadcast one.
