How to solve 3D Bin Packing Problems using Excel

[ganeshpalani]

I'm mind blown, that you did this in excel.
I'm trying to understand the algorithm and add a stackability constraint matrix for every item,
once again professor thanks a lot for making our lives easier and you sir are awesome.

[alissonmar]

i really like to thank you and every person colaborate to this application. It's is a exactly thing i had being braking my brain to undestand e make.

[Lobos]

*Great work.*
Only thing I thought should have been a bit more clear is that the width etc and weights could be whatever you wanted as long as they were the same. It wasnt super clear to me if the XYZ or weight formulas in the background assumed something like cm vs inches, kg vs tonnage etc.
-
That and if such could be selected on the front page so that you could mix cm on parcel with volume in m3 or kg parcel with total weight in tonnage would be better, but I assume that would be a allot of work just for visual aesthetic.

[guneserdogan]

As of version 1.3, the solver also aims to equalise the load on the right and left of each container for better balance.

[federicoperea]

Hello Günes!! Brilliant contribution, as always. Thanks for sharing!!

[guneserdogan]

As of version 1.5, the interface can be set to multiple languages in the console worksheet: English, Turkish, French, German, Italian, Portuguese, Spanish, and Arabic. You can also add your own language or jargon.

[wilsonargarcia]

Günes, thanks a lot!, my initial tests have been working so good. Thank you!

[guneserdogan]

As of version 1.2 (released 22.07.2019), you can have "heavy" items that can only be placed on the floor, and "fragile" items on which you cannot place any items. That will be all the stacking options for the foreseeable future.

[olcemn]

gercekten cok guzel calisma olmus, elinize saglik, uzerine transport ve paket, kasa .... maliyetlerinin de eklenmesiyle daha kapsamli hale getirilebilir.

[jorgegilramirez]

Thank you very much for sharing such didactic and practical work!! How easy or difficult would be adding a package download priority constraint? Let´s say that there are some packages which should be located at the end of the container as they would be downloaded at the end

[roshaan]

Many thanks for the great tool you have made and published for free. Have been using it for 3 years now.
By the way, solver takes too much time while calculating, so I want to ask if we can increase the CPU usage limit for Excel so it can be calculated in less time?

[abdullahajmalkwt]

Your solution jeopardized my whole senior project and our hard work was labeled as waste of time!

[pauloedermedeiroscardoso]

Just amazing!! i wish i had any idea on how this was made

[gonzalovladimircontrerasma]

Thanks a lot. Is there any way to put together different materials?

[SupplyChainExplained]

Hi Gunes, thanks for sharing this.What method or technique is being used for the visualization part? Is that something already in excel or something external add-ins? Looking forward to your reply

[prodigybd]

That is what I am looking for. Great tool and you are a great man to share free :)

[bilaldemirtas]

Merhabalar Güneş bey. Elinize, zamanınıza, emek ve bilginize sağlık. Çok güzel bir dosya hazırlayıp bunu paylaşmışsınız.

[MiladGhanbari-uz]

Hi dear Prof,
thank you for sharing this file. Is it also possible to determine form which side we are allowed to load the pallets? i mean x side or also from z side.

[dkmk]

Can you share more about the details which heuristics models did you apply to this problem? and which one was the one closer to the optimal solution, thanks in advance (Great work!!)

[marocaine-]

GREAT WORK
Thanks for providing this code, I want to take a look at the code, how to access it?