Optimization challenge

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Spreadsheet Solutions - 01 Mar 2008 10:23 GMT

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 ?

Thanks in advance;

Mark Rosenkrantz
Spreadsheet Solutions
Netherlands
---

www.spreadsheetsolutions.nl

Reply to this Message

RB Smissaert - 01 Mar 2008 10:56 GMT

> the ultimate team

How do you define that then?

RBS

>I have a cycling management game in which cyclists (column A) score points
>(column B) and cost money (column C).
[quoted text clipped - 14 lines]
>
> www.spreadsheetsolutions.nl

Reply to this Message

Spreadsheet Solutions - 01 Mar 2008 11:50 GMT

The ultimate 10.

10 riders with, in total, the most points that cost no more than 10.000.

So, it might be that the 10th rider does not make it, as he is the one that
makes the team of 10 cost more than 10.000.
The 11th rider might then come in. Even though he has less points, he does
not make the team cost more than 10.000.

>> the ultimate team
>
[quoted text clipped - 20 lines]
>>
>> www.spreadsheetsolutions.nl

Reply to this Message

RB Smissaert - 01 Mar 2008 12:52 GMT

I take it that there are not that many riders, so simplest would be to loop
through all possible combinations and
see what gets you closest (but not above) 10.000.

RBS

> The ultimate 10.
>
[quoted text clipped - 29 lines]
>>>
>>> www.spreadsheetsolutions.nl

Reply to this Message