Dimension calculation

[Lyn Radnell]

Hello,

I am wondering if someone can help me. I am not that familiar with Excel

I have a Dimension of a product that I need to calculate how many of that product fit into a box

ie.
how many 32.5x55x119mm fit into 165x85x198mm

appreciate any help on the formula I need as I have quite a few calculations to do.

 

[jmacleary]

Hello Lyn. There are youtube videos on it,, but I have cobbled together the spreadsheet below, which does the job.

Book1
	T	U	V
1		carton	piece
2	length	165	32.5
3	width	85	55
4	height	198	119
5
6
7	length/length	5.076923
8	width/width	1.545455
9	height/height	1.663866
10
11	how many	13
Sheet1

Cell Formulas
Range	Formula
U7	U7	=cartlen/piecelen
U8	U8	=cartwid/piecewid
U9	U9	=cartht/pieceht
U11	U11	=INT(U7*U8*U9)

Named Ranges
Name	Refers To	Cells
cartht	=Sheet1!$U$4	U9
cartlen	=Sheet1!$U$2	U7
cartwid	=Sheet1!$U$3	U8
pieceht	=Sheet1!$V$4	U9
piecelen	=Sheet1!$V$2	U7
piecewid	=Sheet1!$V$3	U8

 

[jmacleary]

But please note, it may be possible to get more in by changing the orientation of some of them - the maths is much more complicated but there are youtube videos - its called a knapsack problem or a bin packing problem.