Why do I do this?
In a wonderful combination of my lameness and my boredom at work I used Excel to solve for the best possible fantasy soccer team last week. The site hadn’t updated yet and I wanted to see if I still knew how to use Solver.
I copied the stats from MLS’s page and spent about half an hour writing the cell calculations and setting up the problem.
Rules are:
- 1 Goalie, 4 Defenders, 4 Midfielders and 2 Forwards
- No more than $100M spent (it’s a salary league)
- No more than 3 players from any one team
- One captain whose points are doubled.
MLSnet.com came up with a roster that was $96M and scored 498 points. Obviously they don’t have a bored engineering student working in Excel all day because I came up with one that was $98.1M and scored 502 points.
Since no one cares about soccer I won’t bore you with 11 names where you might only recognize one.
Category: School/Work, Sports Stats Comments Off