Optimization challenge

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Spreadsheet Solutions - 01 Mar 2008 10:24 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 ?

---
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
---

www.spreadsheetsolutions.nl

Reply to this Message

Tim879 - 01 Mar 2008 14:41 GMT

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.

On Mar 1, 5:24 am, "Spreadsheet Solutions" <m...@rosenkrantz.nl>
wrote:

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

Reply to this Message

Rate this thread: