In Progress

Web based DB built

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.

Skills: MySQL, PHP, Website Design

See more: web based design, trending website design, tool design web, spreadsheet on web, program competition, green web design, game design web, design web tool, competition web design, collection design web, advanced level excel, advanced excel website, report 2 web, web design collection, web sports, web report design, trending, sports league, s+db, green web team, db design, collection view, excel data collection tool, analysis excel spreadsheet, analysis sheet excel

About the Employer:
( 12 reviews ) Derby, United States

Project ID: #2524239