A vacation and training tracker system built for a global IT outsourcing company using Microsoft Excel and delivered via SharePoint. The solution included a data entry sheet, a calendar display and a tracking report.
This is a simple worksheet that is easy to use and support, and has an elegant look and feel.
A task planning and scheduling system built for a UK financial services company using Microsoft Excel VBA. The solution included calendar display, data entry form, search and help facilities. It was more than just a shared calendar: it used a library of information about tasks to calculate the likely time required and managed scheduling conflicts.
It illustrates a situation where the very implementation of a tool forces adherence to a process, thereby driving consistency and savings.