My Timesheet Project

Description: Obviously, this exercise is about scheduling. The object is an integrated spreadsheet/database. It also has properties and attributes that may be found in project management software.

Detail: The vertical columns are labeled with times in the day with increments in quarter hours extending a minimum two weeks, and maximum one month. The horizontal rows are labeled in the first column with proper names (an employee, a vendor, a maintenance event, etc.)

The functionality is represented by a movable-sizable bar extending over the time of an event. Example, Jo is scheduled from 3 to 6 on Monday, and her time is represented by a green bar. We may change her hours by moving or resizing the bar. The bar will snap to the nearest quarter hour.

Tools & Methods: Microsoft Excel, XML, Visual Basic.net

Results: What we get out of this are visualizations that primarily show coverage and overlap in the environment.

Can someone help me with the functionality. There are probably several approaches. Any suggestions?