Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I posted a week or so ago and have been successful based on the response I
got. I have a new but similar question that i am trying to solve for with another layer of complexity: I Know that it took 6980 hrs to produce the volume below. ND take twice as long as R and R takes twice as long as M to do. (4T, 2T, T) I also know that: based on Coll Complex 1 takes less time then 2 and 2 takes less time then 3 and 3 takes less time then 4. I also know that: ND1 1 takes less time then ND 2 which takes less time then 3 same with R items and M items based on the volume of each type, how long does each type take? can solver do this? ND - 1 ND - 2 ND - 3 Coll Complex 1 18 9 9 Coll Complex 2 9 5 5 Coll Complex 3 9 5 5 Coll Complex 4 15 7 7 RD 1 RD 2 RD 3 Coll Complex 1 30 15 15 Coll Complex 2 5 3 3 Coll Complex 3 10 5 5 Coll Complex 4 12 6 6 M 1 M 2 M 3 Coll Complex 1 37 19 19 Coll Complex 2 7 3 3 Coll Complex 3 12 6 6 Coll Complex 4 15 7 7 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Solver problem | Excel Worksheet Functions | |||
problem with solver | Excel Discussion (Misc queries) | |||
Interesting Solver problem (Solver encounters an error) | Excel Discussion (Misc queries) | |||
solver problem | Excel Worksheet Functions | |||
IF problem using Solver | Excel Worksheet Functions |