Optimization challenge

[Spreadsheet Solutions]

I have a cycling management game in which cyclists (column A) score points
(column B) and cost money (column C).
After every stage I want to know what the ultimate team of 10 point scoring
cyclists is with the constraint that
the team of 10 may not cost more than 10.000.

I know quit well what Excel is capable of, but I am no maths expert.
What is the best apporach and does anybody have an idea.
Should I be using the solver, goal-seek or making a complex macro ?

---
I also put this one in the programming ng as it might also have to do with
that.
---

Thanks in advance;

Mark Rosenkrantz
Spreadsheet Solutions
Netherlands

 

[Tim879]

Solver is probably the best tool for this challenge since it will
randomly try values subject to your constraints to obtain the
desired / optimized result.

If you need to run multiple scenarios, try a combination of solver to
run each scenario and calculate the optimal value and a single macro
to trigger each scenario to run and copy the results to another
location.