The Microsoft Excel workbook “CLP Spreadsheet Solver” is an open source tool for representing, solving, and visualising the results of Container Loading Problems (CLPs), also known as 3D Bin Packing Problems.


What’s new in version 1.5

Multi-language support. Users can now set the language of the menu and the rest of the interface from the console worksheet. The available languages are: Turkish, German, Spanish, Italian, French, Portuguese, Arabic, Indonesian, Urdu, Bengali, Swahili, Persian, and Malay. As you may expect, I do not speak all these languages. The translations are from Google Translate, so expect minor (i.e. significant) inconsistencies. You can also add your own language or jargon, details are in the new User’s Manual. Special thanks to Rusuhi Cantay for his help with the multi-language support.

What’s new in version 1.4

Further improvements to the solver, and minor bug fixes.

What’s new in version 1.3

The solver has been improved, and also minimises the moment with respect to the z-axis (i.e. approximately equal load for the right and left sides of the container) for balanced load.

What’s new in version 1.2

The users now can define item types to be “heavy” or “fragile”. “Heavy” items can only be placed at the floor level, since placing them on any other item will result in the other item being damaged. “Fragile” items cannot vertically support any item (i.e. it is not allowed to place any item on top of them), no matter its weight. An item type can be both “heavy” and “fragile” simultaneously.