Best options from a list

[Fred Goodwin]

First up this is for a tipping comp between friends where we have to pick a team of riders for the tour and who ever has the most points at the end of the race wins bragging rights. I want to add a little bit more data to results.

I have a list of riders in the tour de france, which we have assigned a $$ value to. At the beginning we have a set budget that we can spend to buy 9 riders. Points are awarded to each rider after each leg based off the points won in the actual race and special events.

What I want is to be able to show which combination of 9 riders, using the original $$ value, would have scored the most points without going over the original budget.

So for the purpose of this there would be three columns:
Rider
$Price
Points

Hope this make sense

 

[Fred Goodwin]

Okay I have been pretty much digging since I posted the question and found a great Solver example that worked as a basis for a solution. For those playing at home:
http://office.microsoft.com/en-au/e...sy-football-team-with-solver-HA001124603.aspx