We developed and deployed an integrated a project management and time logging system consisting of a LAMP server, a web GUI written in PHP, and a detailed report generator working from Microsoft Excel®. A MySQL plugin for Excel was used to connect to the project SQL database directly using VBA scripts and forms.
Employees can log time in time sheets for specific projects and tasks. Financial details for each project and for company expenses can be added at various levels of granularity.
Managers can review company status at glance or pull up detailed information on specific projects. The reports are displayed in Excel and can be customized for each company.