Vehicle Maintenance Schedule

**aspirus** · 05-19-2013, 08:38 PM

I'm responsible for setting up a compliance system for heavy vehicle maintenance.
I'd like to compile a spreadsheet that captures all the maintenance data, and prompts the relevant staff member when services and inspections are coming up.
There are other aspects, but that would be a great start.
Any ideas - existing spreadsheets?
Thanks,
Rob (aspirus)

**FDibbins** · 05-19-2013, 08:46 PM

Hi and welcome to the forum

There may be existing workbooks that some members may have, and may be willing to share with you. But its been my experience that such "canned" sollutions generally fit THEIR requirements, not yours.

My suggestion would be to start putting something together for yourself - something that fits your needs - and together we can then help you build it to where you want it to be.

Start by creating the log the way you (I presume?) currently do it manually - enter any calculated values manually, and lets take it from there?

**aspirus** · 05-19-2013, 09:07 PM

Thanks for that. I'll follow your suggested process, which will work out well.
I have to close out some Corrective Actions by the end of this week. I can do that from the 'manual' setup, then 'automate' it from there.
I'll post the manual version for you to have a look at - modified to retain client confidentiality. I'll put some notes on it to show what I'd like it to do.
Appreciate your help.