In this concluding article, explore the scripts which add andremove timesheet entries to the system, and get a crash course instatistics by using these entries to generate useful resource allocationand usage reports.
In the first part of this article, I explained the need and rationale for a timesheet application to log and analyze employee work hours, and put together a set of functional requirements for this application. I then constructed a database schema to address my requirements, designed a simple user interface, and wrote a few of the basic scripts required by such a system.
The job's nowhere near complete, though - I have yet to write the code which accepts and validates user input, displays timesheet entries, and analyzes the raw data to create a useful report. I plan to address all these items, and a few more, over the next few pages. So keep reading.