Viewing entries tagged
calendar

Vacation & Training Tracker

Vacation & Training Tracker

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.

Task Planning Calendar

Task Planning Calendar

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.