I could build you a sexy Excel spreadsheet?
(I love a good tracker spreadsheet
)
I'd do this with a group Spreadsheet. But then I bloody love spreadsheets.
I'm even worse
I do it with access and a front end form
who doesnt love look up drop downs for a userlist or item number list...
(
@Maccy please give me a spanking if this is naughty.)
Alright then you three! I have a mission for you, should you wish to accept it. Compensation will be agreed and will be paid via invoice from my company. I'm sure an Excel wizard could knock something like this up in a day so let me know what you'd charge for this:
- A spreadsheet which will be universal, to be able to be used across various sites.
- Include various categories, such as maintenance, stock checking, and any other tasks that we may need to carry out in an office.
- Include an asset list, with various columns for various data, such as maintenance frequency, description of how to conduct regular maintenance*, specialist contractor, their contact details, a little photo, etc.
- PPM planner week by week, so if I enter week 36 it spits out all the tasks that need doing
- An exportable checklist so that once a task is completed it can be printed and filed, or saved to a drive, so if something goes wrong later on we can
nail someone's arse to the wall prevent it happening again.
*If possible, export a separate printable document which can also be saved to a drive, so an engineer can print off the document that the spreadsheet has produced, stick it on a clipboard, go do the works, then return and input the data on a PC and save it for future reference.
This is, of course, completely separate from a ticketing system but the goalposts have moved a bit as of this morning so I need to adapt, and adapt quickly.
So TL;DR:
Engineer opens spreadsheet, enters week number, spreadsheet spits out exactly what needs servicing (preferably with separate sheets explaining what to do and what materials are needed which can also be saved separately). Also generates a list separately which can be filled in, detailing all the info with space for comments, materials used, etc.
It's a bit rough, but is this workable? Whatchafink?
