Tracking volleyball stats in Excel: where a spreadsheet gives out
Somewhere on your laptop there is a file with tabs for the roster, the numbers and the fixture dates. You built it yourself, in one evening, and it does exactly what you wanted. The question is not whether that is allowed — it absolutely is. The question is at what point a file like that gives out, and whether you will ever reach that point.
Three sheets, and what a spreadsheet genuinely does well
Ask ten coaches how they keep track of their team and you get back roughly the same file ten times, with a different name on it. There is a sheet with the players, a sheet with numbers from the matches and a sheet with the dates of practices and fixtures. Sometimes in one file, sometimes in three, almost always made by one person in one evening.
That is not making do, that is a perfectly good start. A spreadsheet does three things you do not get handed anywhere else. You decide which columns go in it, so you measure exactly what you think matters and nothing else. You depend on nobody: no account, no subscription, no permission from a committee. And anybody can open it — your fellow coach, a board member, you yourself eight years from now.
Below, the three sheets go by in turn: which columns are in them, what the sheet does well, and where exactly it breaks. After that, the question that actually matters — whether that breaking affects you, or whether it will never bother you once between now and the end of the season.
Sheet 1: the roster with numbers and contact details
This is nearly always the first sheet, and usually the only one that is completely filled in. The columns coaches put in it are much the same everywhere: name, shirt number, position, year of birth, the player's phone number, a parent or carer's phone number for youth teams, email address, shirt size, the registration number your league asks for, and a wide column at the end for notes — injuries, who can drive, who is away during school holidays.
What this sheet does well is speed. Within twenty minutes you have your whole squad on one screen, sorted by number or by position, and you can print it and stuff it in your bag. Which numbers you hand out and why is a separate matter, covered in assigning and managing shirt numbers.
The breaking point of this sheet is that it is a copy and not a source. People's details change: a new phone number, a house move, a player who stops halfway through the season. Only the person who gets told knows about it, and that is by no means always the person with the file. Meanwhile copies are circulating — your fellow coach has the version from the start of the season, the team manager the one from halfway, and a parent who drew up the driving rota has one too. Six months on, nobody knows which list is the right one, and with minors' contact details you no longer know how many phones it is sitting on either. What the alternatives are for this sheet in particular is in from paper membership list to digital team management.
Sheet 2: the statistics sheet
This is the sheet that gets built most often and finished least often. The shape is predictable: one row per player, and alongside it columns for the actions you count — kill, attack error, ace, service error, block point, and sometimes the pass in three grades. A total at the bottom, a percentage next to it, and a separate tab per match. Anyone who really commits adds a summary sheet that pulls all the match tabs together.
This is a spreadsheet at its strongest, because you set the definitions. Whether a blocked ball counts as an attack error, whether a touched serve counts as an ace, whether you work out hitting efficiency over every attempt or only over the balls that were finished: in your own sheet you choose. If you are still unsure which numbers are worth having at all, start with understanding volleyball statistics — a column you never use is work you redo every single match.
The breaking point is not in the sheet but in the road to it. Your laptop is not on the sideline: you tally on paper during the match and type it up at home. That typing up is the first step to be dropped the moment life gets busy. A month later three of seven matches are in there, and a run with four gaps in it is no longer a run — you cannot see development in it, only separate evenings. Tallying itself is a craft of its own, incidentally, with its own set of symbols and its own rhythm; that is worked out in full in volleyball stats on paper. The second half of the breaking point is the shape: one tab per match means every season overview is handwork. With each new match somebody has to extend the summary formula, and that somebody is you.
Sheet 3: the fixture list with attendance
The third sheet is the schedule. Columns: date, start time, home or away, opponent, venue with address, meeting time, and behind that a column per player where you put a cross or a dash. A counter at the bottom adds up how often each player was there.
What this sheet does well is an overview at a glance. The whole season fits on one screen, colour coding shows you in two seconds who is structurally missing, and it is the only one of the three sheets that is still useful printed out and taped to a cupboard door.
The breaking point is that it only runs one way. Players cannot get into it. Withdrawals come in via the group chat, spread across the week, and you type them over — you have become the typist of a chat group, and that is precisely the work you have no time for on match day. If a start time moves, your sheet changes and the diaries of thirteen people do not; you have to pass that on separately and one day it will go wrong. How to organise that count away from a sheet is covered in tracking attendance without the hassle.
The three breaking points every sheet shares
On top of the objections per sheet there are three that come back everywhere. They have one thing in common: they do not announce themselves. There is no error message, nothing turns red, and that is why you only notice them once things have been going wrong for a while.
- Two people editing at once. The moment a second coach or a team manager joins in, the second version is born. You recognise it by the file name, which gets longer with every round: Team_v3_final_new.xlsx. A spreadsheet in the cloud solves simultaneous typing, but not the question of who owns a cell — and the moment somebody emails the file as an attachment, the fork is there anyway. From then on there are two truths and nobody who can say which is the right one.
- Formulas that quietly shift. Your total sits there as =SUM(C2:C13), neatly covering twelve players. Halfway through the season a player joins, you put her on row 14, and the total does not include her. Nothing tells you. The same happens if you delete a row from the middle, or if you sort a block while the formula column does not sort with it. A spreadsheet always keeps calculating: it does not give you an error, it gives you an answer. That is the most dangerous property of the tool: you make a decision on a number that looks right.
- History that falls apart into a file per year. At a new season virtually everybody copies last year's file and clears out the numbers. Sensible, and it works. But three years later, how has this player developed is an hour's job: three files, with slightly different columns, slightly different definitions, and two players who have swapped shirt numbers in the meantime. Development across several seasons is exactly what you would want to see with youth players, and it is the first thing you lose.
When a spreadsheet is simply the better choice
Now the other side, which gets written down far less often. There is a clear area in which a sheet of your own is not merely allowed but smarter. That area has four boundaries, and all four apply at the same time.
- One team. As soon as a second team joins, or a committee that wants to look in, the first condition falls away.
- One keeper. You do the typing and nobody else edits. Reading along is fine, writing along is not.
- One season. You do not need the comparison with last year, either because you largely have a new group or because you would not use it anyway.
- Measuring to test a practice goal, not measuring continuously. This is the important one. Counting serves for six weeks because you are working on serving for six weeks, and then stopping: a spreadsheet is ideal for that. You build it in half an hour, it answers exactly one question, and after that it may close. It is the promise I am going to keep track of everything from now on that wrecks spreadsheets, not the measuring itself.
If you are staying with your own sheet, this is the short list to watch. Put one row per event rather than one tab per match, and adding up stays possible without constantly extending formulas. Freeze the column headers and leave no empty rows in the middle. Enter a date as a date and not as text, or it will sort wrongly. Put the date in the file name and never the word final. Keep the contact details as sparse as you can and know who has a copy. And once a month, do the boring thing: count one column by hand and compare it with your formula.
The limits no column solves
One thing first, because it is often presented the other way round: even when you work with an app, there is work left over that belongs in a spreadsheet. Your own calculations and one-off questions, to be precise — the mileage from your driving rota across the season, your own way of working out hitting efficiency that you happen to believe in, or the question you ask once and never again, such as how many points you gave away in the fifth rotation. No app has a button for that, and it should not have one. Export, calculate, done.
What a spreadsheet cannot do in principle is three things, and they are the same three that kept coming back sheet by sheet above. Shared access, where players fill in their own availability and you type nothing over. Processing in the moment, so that what happens on the sideline lands in the right place straight away instead of on your sofa that evening. And history that belongs to the player rather than to the file, so that a comparison with last season is an action rather than a project.
If those three weigh heavily for you, a team app is the logical step; Koach is one of them, with a fourteen-day trial to see whether it fits. How to go about that move — what you take with you and what you deliberately leave behind — is in from Excel to a team app. And if they do not weigh heavily, the answer is just as honest: keep your sheet, freeze the column headers and check one total by hand once a month. A spreadsheet you trust is worth more than a system you do not use.
Frequently asked questions
Does a spreadsheet in the cloud, like Google Sheets, solve the version problem?
Partly. Simultaneous editing works well and no second file appears, as long as nobody forwards it as an attachment. The other two breaking points remain: formulas shift just as quietly there, and a new season generally becomes a new file there too. And watch the sharing itself — a link that lets everybody look in also gives access to the phone numbers on sheet 1.
I downloaded a ready-made statistics file. Is that better than building my own?
Not automatically, and it adds one risk: you do not know the formulas. Check two things before you start using it. First, which definitions are baked in — does a blocked ball count as an error there, and is efficiency worked out over every attempt or only over the balls that were finished? Second, whether the totals grow with you when you add a player. Fill in one match whose outcome you already know, and see whether it comes out right.
My fellow coach wants to keep track as well. Can that work in one file?
It can, but agree two things in advance or you will have two versions within a month. One: who is allowed to type — the other reads along and passes things on. Two: where the file lives, and that no copy goes round by email. If that does not work in practice, that in itself is the signal that you are outgrowing the shared-folder solution.
How long should I keep old spreadsheets?
Split the question. Contact details you keep no longer than you need them: once a player has left, take her row out of the current sheet. The numbers and the results you are free to archive, and that is worth doing if you want to look something up later. In practical terms: keep one closed copy per season, and never carry on working in an old file.
