Optimization challenge
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 |
Optimization challenge
the ultimate team
How do you define that then? RBS "Spreadsheet Solutions" wrote in message ... 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 |
Optimization challenge
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. "RB Smissaert" wrote in message ... the ultimate team How do you define that then? RBS "Spreadsheet Solutions" wrote in message ... 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 |
Optimization challenge
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 "Spreadsheet Solutions" wrote in message ... 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. "RB Smissaert" wrote in message ... the ultimate team How do you define that then? RBS "Spreadsheet Solutions" wrote in message ... 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 |
All times are GMT +1. The time now is 11:14 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com