... many things are possible
... gotta think positive
Test this the 1st version:
There is a [button] ... press it!
There are two 'options'
- animation (cell E18 is bold) or faster (cell E18 isn't bold)
I didn't test other 'Summary'-values ... You'll do it testings.
There could be some '[not so] interesting' features
... just let me know.
As written, the 1st version.
cell E18 bold or not - the way how those results would come (slower/faster).
Height is possible to adjust. I can make a sample.
... send needed details
... eg for volume, it needs also need more than height or how?
... many things are possible.
>> There were some unwanted features ... some has modified <<
Thank you Mr Bartholomew,From a programming viewpoint does it really matter that the stacks form a 3x18 arrangement within the container. Wouldn't simply designing stacks within the limit of 54 do the same job?
When it comes to the 3D layout within the container the 3D charts give some overall impression but the actual height and gap (paid for but unused) cannot be seen with any degree of precision. A stacked chart showing the individual boxes in each stack using a set of key colours associated with each box type would convey more information and could include the gap and its height. The stacks could, if needed, be grouped in threes with missing category in-between to give some impression of the overall layout.
By the way, in post 5, I had to remove the unused box types because the free version of solver does not go beyond 200 variables. What the optimisation also showed was that a few specific stacking sequences recurred throughout the packing sequence and, possibly, have been used as a basis for the packing plan.