Hi there,
I'm want to use excel to get the best combination of players for my fantasy football team. so I was wondering if it would be possible with these rules:
Player Name Value Points
Goalkeeper
Vorm etc. £6.7 123
Defenders
distin etc £7.2 134
Midfielders
lampard etc. £12 178
Strikers
Rooney etc £14 234
So i will need - 1 goal keeper, 3,4 or 5 defenders, 3,4 or 5midfielders, 1,2 or 3 strikers totalling 11 players in total. I want the maximum possible number of points for a value of £100.
Any help????
Cheers
Bookmarks