• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Modeling bundle in a pallet using Excel Conditional Formatting

JohnBi

New Member
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
 
Hi Giovanni ,

There is a problem with the figures you have posted.

After the first two rows of bundles fitted one way , when you want to fit a third row of bundles after rotating them , 60 + 22 = 82 exceeds the second dimension of the pallet , since that is only 80.

Is this OK ?

In fact , if you fit 3 rows of bundles as follows :

22 22 22 22 22

30 30 30 30

22 22 22 22 22

can you not fit 14 bundles on a pallet ?

Narayan
 
Hi Narayan,
thanks for your reply.
Let me try to explain with a picture. The first 2 rows are with the same direction, the third row is rotate to build a more stable pallet.
Hopefully there is chance to do something with Excel.

Thanks and Regards
Giovanni
 

Attachments

  • bundle footprint.png
    bundle footprint.png
    3 KB · Views: 12
Hallo to everybody,
did you guys get a chance to look to my question?
Do you think there is an Excel formula that can me help?

Thanks in advance.
Regards
Giovanni
 
Back
Top