We have an existing basic timesheet tracking solution in Excel with macros, however it is very cumbersome to maintain on a monthly basis. This solution allows users to enter the weekly time spent on individual Projects and Project Phases, as well as enter a free form description. The spreadsheet then calculates the total number of Capital and Expense hours for each month based upon the Project Phases selected. These monthly totals are compared to an estimated monthly total and displayed to provide user feedback on how close they are to the estimated hours each month. At the end of each month, all users spreadsheets are consolidated to provide a monthly report to our finance department. We would like to replace this Excel spreadsheet with a web application developed in PHP & MySQL to run on a LAMP stack. Attached is a sample of the current spreadsheet.
The application should have users authenticated against Active Directory (LDAP) and check for AD group membership to fit into one of 3 user categories: User, Manager, and Administrator.
Users should only be able to enter time and edit their own open timesheets.
Managers should have the same capability as users in addition to the ability to Edit and Approve the timesheets of the users on the Manager’s team. Managers should also be able to create, edit, and close their own projects, as well as enter monthly capital time estimates for their team members.
Administrators should have access to all functionality in the application.
The application should produce several reports that can be exported to MS Excel format.
• Individual User Monthly Timesheet
• Individual User Annual Timesheet
• Team Monthly Timesheet
• Team Annual Timesheet
• Project Summary Monthly Time
• Project Summary Total Time