C
Corstone
Hi, I've been fiddling with the Solver Fantasy Football example on here.
http://office.microsoft.com/en-us/excel/HA011246031033.aspx
In my example (it's using soccer league data - but similar except
there's no need for the team data on rows 110-136). I've added an extra
column for each players club but I can't work out how to add a
constraint such that I restrict the numbers of players from any one club
to only 2?
I hope that makes sense - I've got the solver to pick the team with
maximum points but it has 5 players from the same club. I want to
restrict it to a maximum of 2 players from any one club.
Does anyone have any suggestions? Thanks.
http://office.microsoft.com/en-us/excel/HA011246031033.aspx
In my example (it's using soccer league data - but similar except
there's no need for the team data on rows 110-136). I've added an extra
column for each players club but I can't work out how to add a
constraint such that I restrict the numbers of players from any one club
to only 2?
I hope that makes sense - I've got the solver to pick the team with
maximum points but it has 5 players from the same club. I want to
restrict it to a maximum of 2 players from any one club.
Does anyone have any suggestions? Thanks.