3 October 2026

Five signs the cover spreadsheet is finished

Five signs the cover spreadsheet is costing the morning: several versions, missed cover, no fairness count, one owner, and no record when leaders ask.

A spreadsheet is a respectable way to run a rota. It stops being one when the school is working around the file instead of from it. These five show up in that order more often than not. You do not need all of them. The longer comparison, including when you should keep the sheet, is SchoolRota vs the spreadsheet. The anatomy of the file is school cover spreadsheets.

1. Nobody knows which copy is current

Three emails, a staffroom pin, and a file in a shared drive called final-v3. By 08:15 a TA is in the hall because that was yesterday's sheet, and the gate is empty because today's sheet moved them. The problem is not Excel. The problem is that publishing is 'someone forwarded it'. One live version, replaced on purpose, is the fix. Extra columns will not do it.

2. Cover has already been missed

Someone did not know they had been moved. A post was empty for the first ten minutes of lunch. A class sat with no adult because the change was in a side conversation. Once that has happened, nobody is following the sheet any more. It is a record of what you hoped. How to plan school cover is the sequence that prevents the next one: log, assign, publish after the last change.

3. You cannot say who has done the most

If the answer to 'who has covered most this term?' is a pause, you do not have fairness. You have a memory. COUNTIF only helps when the column is filled in every day, and that is the first habit to die in a busy week. The cost shows up later, as the same people going off sick, or as a grievance you cannot evidence. A weekly tally is dull. It is also the whole point.

4. The owner was off, and the morning stopped

The colour code, the hidden tab, the knowledge of who cannot leave a pupil: all of it in one person. When they are on a course, someone else rebuilds the day badly, or waits. That is a single point of failure. Write the rules where a deputy can follow them. A duty rota policy is a starting text. A second editor on the file is the minimum if you stay on a sheet.

5. A report meant rebuilding the month

SLT ask what cover looked like, or a trust lead asks which school is thin. You spend an evening reconstructing it from printouts and inboxes. The spreadsheet did not fail at that moment. It failed every morning you overwrote the only copy. An audit trail is a boring feature until the moment you need Tuesday.

What to do if two or more of these are familiar

You can tighten the sheet: one owner plus a deputy, one filename, a cover log you fill in, a Friday five minutes on the tally. Do that if the week is otherwise calm. Move the rota onto a board if the morning is the file. Cover management is the same job with a published PDF and a record. Try it on your own staff for 30 days before you take the pin down. If the PDF is worse than the sheet, keep the sheet.

If only one sign is true

One missed cover, once, is a bad morning. It becomes a sign when you cannot say what you changed afterwards. Several versions, once, during a snow day, is not a reason to buy software. It is a reason to delete the old files. The owner being off is the one that matters most, because everything else depends on them being in. Fix that with a deputy and a written order even if you keep Excel. The duty rota policy is enough of an order to start.

If you recognise three or more, the sheet is the job. People are maintaining copies instead of supervising children. That is the comparison on SchoolRota vs the spreadsheet, including the case where you should stay. Do not switch because a listicle told you to. Switch because the printout and the email already disagree, and you are tired of being the only person who knows which one is real. A deputy who can run one morning from the written rules is a better next step than a purchase. If that deputy still cannot, the file is the blocker, and the trial is there so you can see a PDF of your own week before you take the pin down.

Count the copies on a normal Tuesday, not after a snow day. Open the inbox, the drive and the staffroom. If you find one file, you are fine. If you find three, pick the one that will be official from tomorrow and tell people the others are dead. Do that before you look at software. A new board on top of three live spreadsheets is four versions. The sign you are trying to cure is the number of versions, and buying something without deleting the old ones makes it worse. Tell people which filename is dead in the same message that sends the live one. A quiet deletion that nobody hears about will be forwarded again by Friday. Check on the following Tuesday. If a fourth copy has appeared, you have not finished. Repeat the message. People keep attachments. Rename the dead file so it says OLD in the name, or someone will open it because it sorts first. Move it out of the shared folder as well, into one only you can open. A renamed file in the same place still gets opened. Put it in a folder called archive, and take the pin off the staffroom board the same afternoon. If the pin is still there on Wednesday, the old rota is still the live one.

Start a 30-day trial on your own school. No card.