Message Boards Message Boards

0
|
6706 Views
|
3 Replies
|
0 Total Likes
View groups...
Share
Share this post:

Convert this excel sheet to mathematica for fantasy football?

Posted 9 years ago

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:
POSTED BY: bored dude
3 Replies
Posted 9 years ago
POSTED BY: bored dude

Hi,

I don't fully understand your question, but you can use:

SemanticImport["C:\ .......\...\thu fri cfb solver.xlsx enter image description here

POSTED BY: Jos Klaps

I just imported your sheet into Mathematica by drag-and-drop and it looks fine. If that doesn't work for you, try Import[pathOfSheetFile]. As for optimization I am no expert.

POSTED BY: Gianluca Gorni
Reply to this discussion
Community posts can be styled and formatted using the Markdown syntax.
Reply Preview
Attachments
Remove
or Discard

Group Abstract Group Abstract