Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
number of items fit into item
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
number of items fit into item
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
number of items fit into item
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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
number of items fit into item
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 |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
number of items fit into item
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 |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
number of items fit into item
Let me know if this works:
=INT(A2/A3)*INT(B2/B3)*INT(C2/C3) Where the numerators are the width/height/depth of the available space ("Dimension" from your first note) and the denominators are for the given part/item. "Dreamstar_1961" wrote: 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 |
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can you use two running total data items to calc a third data item | Excel Discussion (Misc queries) | |||
Pivot Table dropping items from page item list | Excel Discussion (Misc queries) | |||
Replacing dash in item number | Excel Discussion (Misc queries) | |||
How do i sort items using two rows per item in Excel? | Excel Discussion (Misc queries) | |||
Menu items added with menu item editor in older versions | Excel Discussion (Misc queries) |