This is not an optimizer but it is close
first calculate the volume on each (I did in column 8)
sort the list by the volume (descending order) biggest on top
then run the macro
Column 8 will reference into which box the referred box goes into
Column 9 will tell wich box does the referred box contains
Column 10-12 will display how much space is left (theoretically)
The reason it is not an optimizer is:
1. It does not consider any rotation of the boxes (sideways maybe)
2. There is only one run coded
Bookmarks