Create a Massive Database Script

Status: Closed
Prize: $350
Entries Received: 1

Contest Brief

I have a spreadsheet of data for sports players. The data is a projection score for fantasy basketball points and salary. Please see attached spreadsheet and video. Each player has the following data points:

Name, Position, Salary, Projected Points.

There are 200 total players currently, but the script will need to be able to work with up to 300 players. We have a Roster Tool that we need to be calculated in under 30 seconds. The roster tool has a set number of positions and a maximum on the total salary allowed for all the players. We need to calculate the roster of player positions that have the highest number of projected points without going over the total salary allowed of $60,000 in this case.

Output of project:

1. Database build on open source platform. You can potentially use Google or Amazon
2. Scripts to run database
3. Web based basic GUI showing the positions, salary and output of roster tool as seen in attached excel spreadsheet and video.
4. Computed in under 30 seconds.

There are a total of 199 players. To reduce big time the processing time of generating the combinations, I have sorted the players by position. Below are the number of players per position.

ALL Players : 199
C = 31
PF = 45
PG = 40
SF = 39
SG = 43

unique combinations of 2 PG Players: 40 x 40 = 1,600
unique combinations of 2 PG Players and 1 SG Player: 40 x 39 x 43 = 67,080
unique combinations of 2 PG Players and 2 SG Player: 40 x 40 x 43 x 42 = 2,889,600
unique combinations of 2 PG Players and 2 SG Players and 1 PF Player: 40 x 40 x 43 x 42 x 45 = 130,032,000
unique combinations of 2 PG Players and 2 SG Players and 2 PF Player: 40 x 40 x 43 x 42 x 45 x 44 = 5,721,408,000
and the number goes higher and higher as we add players.

For 9 players, the total combination is an outstanding 256,281,603,177,600.

Recommended Skills

Post a Contest Like This

Public Clarification Board

zunden
- 11 years ago
could you extend this project? I am working on it...
- 11 years ago
1. Contest Holder
  - 11 years ago
  Have you creating an output in the last week? If so, please show what you've done
  - 11 years ago
letwalkalone
- 11 years ago
Garuntee and extend the project .
- 11 years ago
Contest Holder
- 11 years ago
@rightbigboss - please see project requirements. We need the optimal points lineup under the salary cap. If it's a knapsack problem query that solves the issue, that's fine. The deliverable is the database with scripts to run the solution over time and enabling us to upload new files with salary, player and points. output is on a gui on a solution like google developers or some solution where we don't have pay a ton of money for local CPU power. Hope this helps
- 11 years ago
rightbigboss
- 11 years ago
Hi, Do you need any query to solve the Knapsack Problem?
- 11 years ago
MuradMurad
- 11 years ago
Hi, I will participate also in the contest, but 2 days left may not be enough
- 11 years ago
sarkarbiplab
- 11 years ago
Given the set of data, what is changing over time that I need to recalculate? Is it that some player's salary will change or some player will get deleted and new one will be added? I want to know what changes over time and what remains fixed.
- 11 years ago
1. Contest Holder
  - 11 years ago
  Players and player salary will be updated into the database on a daily basis. Some players will get deleted, some added, positions can change and salaries will change
  - 11 years ago
healdeal
- 11 years ago
Hey Robert just a quick question , does this have to be php,sql only.Correct me if i'm wrong this is a NBA team builder right ? cause i was thinking of using both php and ajax to be able create random team combos and also give you the option to randomize 1 single player instead of the hole team, with stuff like json you are able to do that plus some php cashing on the side it can be way faster than 30 secs.
- 11 years ago
1. Contest Holder
  - 11 years ago
  yes, that would be best as we'd like to be able to manually input a number of players and then run the script to find the best possible combination
  - 11 years ago
djones9898
- 11 years ago
how opposed would you be to a working solution in asp.net using sql server?
- 11 years ago
1. Contest Holder
  - 11 years ago
  Php is ideal as we have experience with it
  - 11 years ago
tajvirgo
- 11 years ago
How do you want to handle 'Shawne Williams' - row 170 with empty position?
- 11 years ago
1. healdeal
  - 11 years ago
  Read his wiki page http://en.wikipedia.org/wiki/Shawne_Williams He is both Small Forward and Power Forward , mainly Small Forward so im guessing SF. this is a pretty neat tool to get the top team with under 60k dollars , i'm also building it on a spare domain even if i don't get picked would be fun to build this.
  - 11 years ago
2. Contest Holder
  - 11 years ago
  you can use SF for now. We'll need to be able to input player salary feeds into the database, so we can update at a later date as well
  - 11 years ago
blackgraphics
- 11 years ago
please check #1
- 11 years ago
afoninserg
- 11 years ago
i think postgreSQL is the most compatible DB for this case
- 11 years ago
Contest Holder
- 11 years ago
@shahidjane143 - sorry, all payment is made upon successful completion of project.
- 11 years ago
shahidjane143
- 11 years ago
hello sir i understand what you want me to do just relaxe and please do me a favor please give me 5 or 6 dollars advance bcoz this website want me to verify thats why i ask you this sorry for that and plese dont mind sir thank you very much
- 11 years ago
Contest Holder
- 11 years ago
It's up to you, but it must be open source. Hbase with PHP may be a good solution - http://stackoverflow.com/questions/5688449/integrate-hbase-with-php We have tried MySQL and SQL server, but if you can get it work there, that will work.
- 11 years ago
paponfreelancer
- 11 years ago
Which db do you want to use?
- 11 years ago
Diegmel
- 11 years ago
Hello.

Excuse me, which DB Server do you need the script demo at? (SQL Server, Access, MySQL)
- 11 years ago