Hello everybody.
I was wondering how people keep (or don't keep) track of their equipment maintenance records.
My memory is very bad and I like to keep records of maintenance, inspections, problems, remedies etc for future reference.
Up to now I used an Excel spreadsheet. I have a "general" tab having a list of all my equipment with the date and description of the last event (such us maintenance/inspection/problem etc) together with a day count since then. The purpose of this is to have an overview and be able to prepare for coming maintenance with reminders, "days since last maintenance" counters etc.
Then I use more tabs (eg one for each piece of equipment) for more detailed history.
The problem I am facing is that miraculously their numbers seem to grow exponentially (ok not really but you know what I mean) hence adding tabs to the spreadsheets becomes impractical - not to mention that several pieces of equipment get mixed up now and then (for example regs 1st stages paired with different 2nd stages to be used as main vs pony reg sets etc).
I thought of getting rid of this spreadsheet and instead use a calendar like approach (date, equipment id, event/explanation). It will be easier to record / view but things like maintenance remainders (eg days since last service/inspection) become problematic.
Any other options out there??
BTW In case you are wondering, here is a rough list of my equipment:
- 3 tanks with their valves
- 2 reg sets (one primary, one for pony/stage)
- BPW
- 2 dive computers
- camera with casing and 2 strobes
Accessories such as suits, lights, DSMBs, masks, fins etc don't get that much attention.
They don't look that many after all - but still. I am sure there are people out there with much more than that - how do they keep such records?? I can't imagine if I had more...
Thanks
I was wondering how people keep (or don't keep) track of their equipment maintenance records.
My memory is very bad and I like to keep records of maintenance, inspections, problems, remedies etc for future reference.
Up to now I used an Excel spreadsheet. I have a "general" tab having a list of all my equipment with the date and description of the last event (such us maintenance/inspection/problem etc) together with a day count since then. The purpose of this is to have an overview and be able to prepare for coming maintenance with reminders, "days since last maintenance" counters etc.
Then I use more tabs (eg one for each piece of equipment) for more detailed history.
The problem I am facing is that miraculously their numbers seem to grow exponentially (ok not really but you know what I mean) hence adding tabs to the spreadsheets becomes impractical - not to mention that several pieces of equipment get mixed up now and then (for example regs 1st stages paired with different 2nd stages to be used as main vs pony reg sets etc).
I thought of getting rid of this spreadsheet and instead use a calendar like approach (date, equipment id, event/explanation). It will be easier to record / view but things like maintenance remainders (eg days since last service/inspection) become problematic.
Any other options out there??
BTW In case you are wondering, here is a rough list of my equipment:
- 3 tanks with their valves
- 2 reg sets (one primary, one for pony/stage)
- BPW
- 2 dive computers
- camera with casing and 2 strobes
Accessories such as suits, lights, DSMBs, masks, fins etc don't get that much attention.
They don't look that many after all - but still. I am sure there are people out there with much more than that - how do they keep such records?? I can't imagine if I had more...
Thanks