These are projects posted by the students of Dr. Gove Allen at Brigham Young University. These students have taken one semester-long course on VBA and generally have had no prior programming experience

Tuesday, April 13, 2010

Minchin Timesheet v1.0.25059

The Minchin Timesheet System is designed to provide an easy way to keep track of time spent on various projects, especially in situations where the user is working on several projects serially. From the main interface, click on “Record Time Stamp” will prompt the user for a project number, a subproject number, and their employee number. When they are finished, they click “Record Time Stamp” a second time to log off. A button (“Am I Logged In or Out?”) provides a simple way of confirming their status. A third button (“Generate Timesheet”) will automatically generate a timesheet for the employee, breaking down their time by day, project and subproject, and saving the result as an easy to email or print PDF.

The example provided here works as described above, but more excitingly, provides a framework to build off of to add many more features. That said, if a simple record of time punches is all you need, the existing version should function very well.

Full Description (Report)
Excel Workbook
Example Timesheet 1
Example Timesheet 2

Update July 7, 2010: Version 1.1 has been released at The update smooths over the edges a little, corrects a few minor math mistakes, and adds an “About” dialogue. Further updates, when released, will be released there.

No comments:

Post a Comment

Blog Archive