Solved

# Follow Up Question to "Maximizing the number of Cartons fitting in a Shipping Container" from 2005

Posted on 2006-10-19

Hi,

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

etc etc

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)

etc etc

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.