Writing

How to keep track of club cylinder tests without a spreadsheet

Every club has the same story. A cylinder comes out of the store on a Saturday, somebody turns it over to look at the stamp, and it went out of test in March. Nobody did anything wrong: the spreadsheet said November, because the spreadsheet was written before the last test moved.

The fix is not a better spreadsheet. It is deciding what the record actually is.

The date is not the record. The test is.

Most clubs keep a column called "next test" and update it by hand. That column is a conclusion, and conclusions drift: somebody tests four cylinders, updates three, and the fourth keeps the old date because updating it was a separate act from testing it.

Record the test instead (who did it, when, what kind, and what it cost) and let the next date be worked out from that. Then there is no such thing as a cylinder whose date is wrong, only one that hasn't been tested. Those are very different problems and only one of them is dangerous.

What to keep against each cylinder

Count dives, not just months

A test interval is a calendar rule, and calendar rules are blunt. A cylinder that has done ninety dives this year and one that has sat in the rack since February are in the same place on the calendar and nowhere near each other in reality.

If you are already recording who took what out, you have a dive count for free. Servicing a regulator at ninety dives rather than a year is a better rule, and the club that does it finds problems in the workshop rather than at the shot line.

Make the overdue ones loud

A list where everything looks the same is a list nobody reads. Anything out of test, or due inside forty-five days, should say so without an officer going to look, and the moment somebody tries to book it, the answer should be no, with the reason.

The Equipment Officer's job stops being a monthly audit and becomes a glance.

FoxFace Diving does all of this: the record, the attached certificate, the loud overdue, and refusing the booking. But the principle stands whatever you use: record the event, derive the date, and let the system argue with you.

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.