Time Is Money (part 2) (
Page 1 of 11 )
In this concluding article, explore the scripts which add and
remove timesheet entries to the system, and get a crash course in
statistics by using these entries to generate useful resource allocation
and 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.
/ 4 
