The purpose of the application is to allow outside contractors upload their collection data onto the database. The enduser will then be able to generate reports derived from this information by populating the data into predetermined cells on an Excel Spreadsheet template. The template will have the calculations already built in and therefore dumping the data into the correct cells will generate the graphs and reporting information that is required by the business.
There will also be notification messages required along with change logging and sequrity requirements. These requirements are detailed further in the specification.
The full technical specification is described on the attached word document. I will be supporting this application so all code must be commented througly.
Within the technical document there are some screen shots of the existing desktop application and also some screen shots from excel. These are intended to give a guide of how the page should look.
On the technical document there is also some screen shots of the final reports. The coder doesn't need to be worried about these graphs. All the coder needs to do is populate the data in the correct field on the template. This will generate the graphs automatically within Excel. I would advise the coder to work on the other functionality of the application and leave this functionality to last. I need to get the exact cells that need to be populated by which piece of data.
Some other important points to note are that there needs to be some way of logging changes that have been made by users of the site. If a user changes an uploaded value an entry will need to be stored on the database recording this. I will leave it up to the code to decide how this is done from a technical point of view.
* * *This broadcast message was sent to all bidders on Monday Jan 4, 2010 5:17:08 AM: