View Single Post
  #10   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Dana DeLouis Dana DeLouis is offline
external usenet poster
 
Posts: 947
Default number of items fit into item

Hi. In Operational Research projects, optimal "packing" is probably one of
the hardest to do. I really don't think you will find a "Formula" to do
this. You might work out a formula if you make a lot of assumptions though.
For example, when testing an algorithm, you might want to check that it can
pack all 18 items into a 5*5*5 box.

http://mathworld.wolfram.com/ConwayPuzzle.html

As you can see, a simple Formula will probably not work.
--
HTH :)
Dana DeLouis
Windows XP & Office 2007


"Dreamstar_1961" wrote in message
...
what I'm trying to get is if item is say 28*13*14 and the value of the
item
it's to go into is 29*14*15 then what will fit is 1, but if the item is
1*1*1
then the answer is 1000's what I'm after is the formula to work out the
number, this is being used for a fit size test.

"andy62" wrote:

Can you provide an example of what you mean? Include some data, and
point
out what is making it so tricky.

"Dreamstar_1961" wrote:

tryed that but dos't seem to be working, what this is for is a fit
size, that
is we have a number of location of a given size, I need a formula that
when
we put the size of the part in it will show how many will fit in a
given
location

"andy62" wrote:

Seems like you would just multiply to compute the respective volumes,
and
then divide. So what's the catch?

"Dreamstar_1961" wrote:

can any one think of a formula to find out how many items will fit
in to a
given Dimension, that is I have a item that is so many
width*height*depth
into a location of width*height*depth
ex 10*10*10 into a item of 10*10*10 = 1