Website MySql queries, etc.

Avg Bid (USD)
Project Budget (USD)
$30 - $80

Project Description:

For each of the 4 tabs in the attached excel file I need the information to be populated from the created database and be able to be downloaded into excel.

It is important that a user has the option of running the reports by assignment date in which case the website will check the as of date and subtract the number of days that have elapsed from the report date from the as of date. A user could want to run the report from the discharge date then the website will calculate the difference between the discharge dates and the report date in forming the calculations for the tabs.

Files will contain variousFC's and Pt Types. We should have a mechanism to consolidate the many financial classes into a couple with a mapping tool. For example, if a,b,c,d,e,f,g,h,i,j financial classes appeared in a file, we need a way that says for every file applied to project 1 if accounts are received with a financial class a or b or c map to financial class 1. If d,e,f,g,h are received map to 2. Similarily for the pt type. If we receive multiple we need to be able to map to specific fc's.

Skills required:
MySQL, PHP, Software Architecture, Software Testing, Web Hosting, Website Management, Website Testing
Additional Files:
About the employer:
Public Clarification Board
Bids are hidden by the project creator. Log in as the employer to view bids or to bid on this project.
You will not be able to bid on this project if you are not qualified in one of the job categories. To see your qualifications click here.