View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Belinda7237 Belinda7237 is offline
external usenet poster
 
Posts: 106
Default problem solver question

Hoping Dan is out there!

I needed to make a couple of changes to my data set, and cannot get my
equation to work correctly.

Know that it took 8116 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

My volume is:
ND 1 ND2 ND3
Coll Complex 1 18 16 2
Coll Complex 2 9 8 1
Coll Complex 3 9 8 1
Coll Complex 4 15 13 1

RD 1 RD2 RD3
Coll Complex 1 31 27 3
Coll Complex 2 5 4 1
Coll Complex 3 10 8 1
Coll Complex 4 12 11 1

M 1 M2 M3
Coll Complex 1 38 33 4
Coll Complex 2 7 6 1
Coll Complex 3 12 11 1
Coll Complex 4 15 13 1

Can you help me to figure out how long each takes.