Case 15 Problem: Streamlining schedules
A large maintenance company had six different departments feeding various scheduled and emergency appointments to the scheduling and planning department. Each department submitted the incoming data in different formats, and sometimes critical data was missing. This resulted in scheduling nightmares. Additionally, for legal and reporting reasons, the company needed to keep logs of what was done, when and where.
Case 15 Solution:
TAP Solutions developed a standard input form for each department that had data validation embedded into it. When somebody needed a scheduling report, all they had to do was enter the date range. This pulled in all the data from all the sheets and produced a master scheduling sheet for the date range. The company now could see what needed to be done, which made scheduling more efficient.