Why Spreadsheets Eventually Let You Down

Almost every sailing centre starts on spreadsheets, and rightly so. They are free, flexible and familiar, and for a small operation with one person in the office they do the job. The trouble is that they keep doing the job, apparently, long after they have stopped doing it well. The signs are gradual: the roster that takes an evening, the booking that was double-entered, the certificate that lapsed because the date was in the wrong column, the version on the laptop that differs from the one on the shared drive. This article sets out why spreadsheets eventually let a centre down, the warning signs that the moment has arrived, and what to do about it.

They hold data, not rules

A spreadsheet will happily let you roster an instructor whose first aid lapsed last week, book a seventh learner onto a course with six places, assign the same safety boat to two sessions, or put a sixteen-year-old on a late shift. It does not know the rules, so it cannot enforce them. The rules live in the head of the person using it, and heads are busy, tired and sometimes on holiday. The mistakes that cause incidents, complaints and compliance failures are exactly the ones a spreadsheet cannot catch.

They do not connect

A centre's information is a web: a booking changes the ratio, the ratio changes the staffing, the staffing changes the hours, the hours change the pay, the instructor's certificate changes who can be rostered, the session change affects the parents who need to be told. In spreadsheets each of those lives in a separate file, and the connections are made by a person retyping. Every retype is time and a chance of error, and the files drift apart until nobody is sure which is right.

They have one version, and then they do not

The moment a spreadsheet is emailed, copied to a laptop or photographed for the group chat, there are two versions. One is updated and the other is not. The instructor acts on the old one. The office does not know which the Principal has. Shared spreadsheets help but still cannot tell each instructor only what concerns them, notify them of a change, or stop two people editing the same cell.

They are only as good as the person who built them

The roster spreadsheet with its clever formulas was built by someone who understood it. When that person leaves, falls ill or simply forgets how the lookup works, nobody dares touch it. The spreadsheet becomes a single point of failure disguised as a tool. The same is true of the booking tracker, the certificate list and the hours sheet.

They cannot talk to the people

Instructors cannot see their own roster on their phone from a spreadsheet, confirm their hours, submit availability, swap a shift within rules or upload a new certificate. Parents cannot receive an automatic reminder. The office becomes the human interface between the spreadsheet and everyone else, which is where the hours go.

They keep personal data badly

Spreadsheets of learners, children, medical information and staff records end up on personal laptops, in email attachments and in download folders, with no access control, no audit of who looked, and no reliable deletion. That is a data protection problem waiting to happen, and increasingly a question that parents, schools and insurers ask.

The warning signs

• The weekly roster takes more than an hour, or is rebuilt more than once most weeks.
• Something was double-booked, over-booked or under-staffed in the last season because two files disagreed.
• A certificate expired without anyone noticing until it mattered.
• The same information is typed into more than one place.
• Only one person understands the main spreadsheet.
• Instructors ask the office what they are doing this week.
• Hours and pay are reconciled from paper or memory.
• You cannot say, in a minute, who was on duty for a given session last month.
• Personal data is in files on more than one computer.
• The Principal does admin in the evenings that a system could do in the day.

Two or three of these is the moment. Five is overdue.

What a proper system does differently

A system built for the job holds the rules and enforces them: ratios, qualifications, hours limits, boat and location clashes, booking caps. It connects the pieces so that information is entered once and flows: booking to session to roster to hours to pay. It has one live version that each person sees from their own angle, on their own phone, with changes notified. It talks to people automatically: reminders, confirmations, expiry warnings. It keeps the records that compliance needs as a by-product of running the day. It controls access and keeps an audit. And it does not depend on the person who set it up.

Making the move without pain

Moving off spreadsheets feels daunting and is usually an afternoon. Clean the spreadsheets first, import the season's courses and the staff with their qualifications, run the two side by side for a fortnight, then switch. Choose a system designed for centres like yours, that handles the roster, the qualifications, the hours and the sessions together, that works on a phone on the slipway, that keeps data in the right place and lets you leave cleanly if it does not suit. Involve the office and a couple of instructors in the choice; they will use it most.

Keep the spreadsheets for what they are good at

Spreadsheets remain excellent for one-off analysis, the budget model, the fleet replacement plan, a quick list. The point is not to banish them but to stop using them as the operational system of record for things that have rules, connections, multiple users and personal data. Those belong in a system built to hold them, and the day the move is made is the day the Principal gets the evenings back.

This article is general guidance for RYA centres and clubs. Schemes, awards and requirements change — always check the latest official RYA guidance and your recognition paperwork before acting. ActivityRoster helps you run the rostering, qualifications and safety-cover side of all of this in one place.