Writing

The dive club membership spreadsheet, and what always goes wrong with it

Nearly every club runs on one spreadsheet, kept by one person, emailed round in March. It works, right up until it doesn't. These are the five failures that show up again and again, in roughly the order they bite.

1. There are three copies and they disagree

The Membership Secretary has one, the Treasurer has last year's, and somebody printed one for the AGM. None of them is wrong exactly; they were all right when they were made. The question "how many members do we have" then has three answers and no way to choose between them.

The fix is not discipline. It is having one copy that everybody looks at rather than a copy each.

2. Grade and training-for are the same column

Somebody working towards Sports Diver gets written down as "Sports Diver (training)", and six months later a different officer reads that as Sports Diver. What a person holds and what they are working towards are two different facts, and putting them in one box loses one of them.

Two columns. And one action that moves somebody from one to the other when they pass, because doing it in two steps is how a member ends up qualified and still on the trainee rate.

3. Emergency contacts are out of date and nobody knows which

A column of phone numbers with no dates on them tells you nothing about whether any of them still works. A number collected in 2019 and one collected last month look identical.

Record when each was given, and by whom. Then "we should check these" becomes a list rather than a feeling.

4. It quietly becomes a medical record

It starts with a column for "medical", then a note about somebody's asthma, then a scanned form in a folder next to it. That spreadsheet is now holding special-category data under UK GDPR, on a committee member's laptop, in a file that gets emailed.

Decide deliberately whether you are holding health information at all. If you are, it needs a lawful basis, it needs to be held properly, and it should not be in the same file as the subs list. Most clubs, asked plainly, find they do not need it in the spreadsheet at all.

5. One person is the single point of failure

Not because they are secretive, because it is their file, on their machine, in their format. When they stand down, the club inherits a spreadsheet nobody else has ever opened and a set of conventions nobody wrote down.

The test is simple: if the Membership Secretary went under a bus tomorrow, could the club still send an email to every current member?

None of this needs software to fix. It needs the same five decisions whatever you use: one copy, two columns, dated contacts, no health data by accident, and nothing that lives on one laptop.

Written while building FoxFace Diving, a website that runs a diving club: the calendar, the kit store, the boat and the committee's paperwork, for one price with nothing held back.