Based on the Amazing tutorial "Modeling tiles in a room using Excel Conditional Formatting" I recent found on your website, I am trying to adapt the tutorial to fit bundle on a pallet.
Bundle Dim 1 = 22 cm
Bundle Dim 2 = 30 cm
Pallet/room Dim 1 = 80cm
Pallet/room Dim 2 = 120cm
With
=Max(Int(80/22)*int(120/30);Int(80/30)*int(120/22)) the result is 12 pieces
However I can fit 13 pieces like:
30+30+30+30 – first row (120cm - 4 pieces)
30+30+30+30 – second row (120cm - 4 pieces)
22+22+22+22+22 – third row (110 cm - 5 pieces)
Is there a way to obtain this with your Excel sample/tutorial? Is this possible with a single formula?
Any help is appreciated. Thanks and Regards
Giovanni
Bundle Dim 1 = 22 cm
Bundle Dim 2 = 30 cm
Pallet/room Dim 1 = 80cm
Pallet/room Dim 2 = 120cm
With
=Max(Int(80/22)*int(120/30);Int(80/30)*int(120/22)) the result is 12 pieces
However I can fit 13 pieces like:
30+30+30+30 – first row (120cm - 4 pieces)
30+30+30+30 – second row (120cm - 4 pieces)
22+22+22+22+22 – third row (110 cm - 5 pieces)
Is there a way to obtain this with your Excel sample/tutorial? Is this possible with a single formula?
Any help is appreciated. Thanks and Regards
Giovanni