Follow Up Question to "Maximizing the number of Cartons fitting in a Shipping Container" from 2005
Posted on 2006-10-19
This is my first question in this forum, so please bear with me.
I have read with great interest a question posted by homeredunord and answered by billmercer 11/07/2005 - 11/14/2005. This seems to be almost exactly what I have been trying to accomplish for my own work, and although homeredunord solved it, there isn't an example of how and what he did.
I would really appreciate a copy of the solution or a more in-depth explanation of how it was done.
Plus, this is the middle section of what I hope to do. I would firstly like to take a retail carton, stipulate an outer carton qty e.g. 8, and work out the best orientation for packing the 8 retail cartons into the outer to give the best container fill (using homeredunord's solution, although I will be converting container to pallet fill). i.e. The outer carton could be made up as:
8 x 1 x 1
1 x 8 x 1
1 x 1 x 8
4 x 2 x 1
I only want to go up to a max of 50 possible retails in a carton, so by using fractions for the first orientation, I can limit the permutations to 13, i.e:
100% x 1 x 1 (8 x 1 x 1)
50% x 2 x 1 (4 x 2 x 1)
25% x 2 x 2 (2 x 2 x 2)
I did this mathematically, and created a ridiculously slow clunky database. I realise that I am still at the very early stages of learning custom functions on Filemaker Advanced so am way out of my depth and need help.
Finally, if I can do this I hope to use the xmCHART Plug-In to draw a picture of the layer build up of the cartons. I have solved this part by finding an answer on another forum; I just felt it important to give you a picture of my whole problem rather than just the bit in the middle.
Any assistance would be greatly appreciated.