database and analysis

Currently staff enter information into a printed sheet at the end of each shift. The currently used sheet is attached as an example. I would like to be able to have this information entered into a database so that I can report on any combination of fields. For instance: Cash income(notes + coins) in week one vs week ten. Average takings of one employee against another. The report must be able to be both numerical and graphical(ie a simple line graph - example included) I would prefer if this project was usable via the internet, but if that is not possible an access database would suffice. I normally pay a bonus for work well done. In this instance the bonus will be higher the more robust the search criteria. ## Deliverables 1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done. 2) Deliverables must be in ready-to-run condition, as follows (depending on the nature of the deliverables): a) For web sites or other server-side deliverables intended to only ever exist in one place in the Buyer's environment--Deliverables must be installed by the Seller in ready-to-run condition in the Buyer's environment. b) For all others including desktop software or software the buyer intends to distribute: A software installation package that will install the software in ready-to-run condition on the platform(s) specified in this bid request. 3) All deliverables will be considered "work made for hire" under U.S. Copyright law. Buyer will receive exclusive and complete copyrights to all work purchased. (No GPL, GNU, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site per the coder's Seller Legal Agreement). * * *This broadcast message was sent to all bidders on Thursday Jan 12, 2006 5:15:37 PM: 2 quick additions/clarifications. I have a website which I can provide you with access to which supports PHP and Mysql database(1 only) For input I would like the format to be Year(1-50), month(1-12), week(1-6), day(1-7) For the reporting I would like to be able to report based on dates(Year(1-50,all), month(1-12,all), week(1-6,all), day(1-7,all)) and employee(with an all employee option) and the output being a choice of the other fields in the attached form. Reports should be able to provide totals or averages. ## Platform Input is from a Windows XP home computer. Reporting preferably by web browser as data would be accessable online(password protected). Open to offers for anyone who can supply what i want on a standalone system, but preference given to those who can provide it online.