I've made an excel sheet (2007 and above with solver add in) that uses some type of an optimization to pick the players in daily fantasy sports football.
Just in case you're unfamiliar with daily fantasy sports, it's a sports betting where you choose various players and depending on the numbers they post you win or lose. The player are assigned salaries in dollars and points (ffpg), and you have a total of $45000 to buy the players to elicit the most possible points. And players are given points for scoring, running, receiving etc.
So it's an optimization problem. You want to maximize the number of points a group of players can achieve.
Rules are you get $45000, 1 Quarter back B, 2 Running Backs. 3 Wide Receivers, and 1 Tight end for total of 7 players. You can't have more than 4 players from one team.
Is there a way to convert this excel sheet to mathematica? I ask because the solver routine in excel is really weak and not giving too many solutions.
And use the optimization tools available in mathematica? What are the steps involved here?
Attachments: