Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
help with solver or macro
I am trying to figure out a way to use Excel to optimize
an order of operations to minimize a calculation in one cell. Essentially, I have a table of 3 parameters. Each set of parameters is an operation. Every operation must be performed, but in any order. There is a calculation next to the table for each operation showing time per operation and set-up time. The set-up time is dependent on the order in which operations are performed. What I need is to use something like Solver to optimize order of operations (optimize row order). I can't figure out how to do that. Any ideas? Thanks. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
help with solver or macro
I'm sure your explanation of the problem makes perfect sense to you,
but pretend you don't know anything about the problem and (re)read the post. What is the set of 3 parameters. How do these three parameters become one operation? What does "there is a calculation next to the table for each operation" mean? I thought the table contained three parameters that constituted one operation. If the sequence of operations defines setup time, how can you have a single value for the setup time. One should need a n-dimensional 'table'. Maybe, if you post sample data and explain how it all comes together for the posted data set... -- Regards, Tushar Mehta, MS MVP -- Excel www.tushar-mehta.com Excel, PowerPoint, and VBA add-ins, tutorials Custom MS Office productivity solutions In article , says... I am trying to figure out a way to use Excel to optimize an order of operations to minimize a calculation in one cell. Essentially, I have a table of 3 parameters. Each set of parameters is an operation. Every operation must be performed, but in any order. There is a calculation next to the table for each operation showing time per operation and set-up time. The set-up time is dependent on the order in which operations are performed. What I need is to use something like Solver to optimize order of operations (optimize row order). I can't figure out how to do that. Any ideas? Thanks. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
XL solver macro | Excel Worksheet Functions | |||
Solver Macro | Excel Discussion (Misc queries) | |||
Is it possible to run Solver using a macro? | Excel Worksheet Functions | |||
Solver Macro | Excel Programming |