Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Seo , Search Engine Optimizer , Seo Search engine Optimization , search engine optimization services, SEO Consulting | Excel Worksheet Functions | |||
Seo , Search Engine Optimizer , Seo Search engine Optimization , search engine optimization services, SEO Consulting | Excel Discussion (Misc queries) | |||
Seo , Search Engine Optimizer , Seo Search engine Optimization , search engine optimization services, SEO Consulting | Setting up and Configuration of Excel | |||
Seo , Search Engine Optimizer , Seo Search engine Optimization , search engine optimization services, SEO Consulting | Links and Linking in Excel | |||
Seo , Search Engine Optimizer , Seo Search engine Optimization , search engine optimization services, SEO Consulting | Charts and Charting in Excel |