I have an excel spreadsheet (Attached) in which I collect sports competition data. After the game I take that sheet and do calculations on the data and than I roll data up to the overall team and league level. So if "Johnny" is on Team Green than his data is collected and I build a report (See attached file) for Johnny and the Green Team and The League (all teams) for that week. I capture each players data and with that I can roll it up to look at the bigger picture.
I want you to build me a website where I can up load the excel spreadsheet to so it can be analyzed. I want to up load it, once it gets up loaded it AUTOMATICALLY takes all the data into it's DB. Than I want you to program the DB to do the calculations and reports I want from it. Example- I up load JOHNNY's data, it automatically does the calculations for JOHNNY's data and it dumps JOHNNY's data into the DB. The reports are ready to be run at any time off the data. You need to build a DB that accepts all the fields of the excel spreadsheet, populates the DB with those fields and than build the reports I need. Those reports will be advanced reports like trending, analysis etc..
Phase 1 is just the tool to take the data in, analyze it and report on it with fixed reports.
PHASE 2- NOT INCLUDED in this bid... This will all go to the web, personal accounts for each student to view their reports.
PHASE 3- Web based data collection tool that can be used or the EXCEL upload. Either or.