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.

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.

8 x 1 x 1

1 x 8 x 1

1 x 1 x 8

4 x 2 x 1

etc etc ?????

Is that a way to show boxes? don"t tell me this a mathematical representation of a palette, I immediately get mad at that!

---------

it does, but does yr database have the size of parcels and boxes to fit in a palette?

that's where your chart does not mean anything to me... was is a 8x box compared to a 4x? bigger in all dimensions, double length, same width? what height? etc...

I have done a similar thing 3 years ago in 2D to fit labels on big sheets with a minimum loss of paper, and that was quite a lot of work giving a superbe result.

so I agree than it is worth trying in a database rather than in an external app, but probably not very easy.

so how would this work? you have a table of boxes, and they have to be allocated to palette for the least waste of space.

The raw idea I have is to make a table of all possible combinations for a given set of boxes (generated automatically from the box list) then search for the best volume.

Of course that list of combinations is the key of the principle.

For each box, you must consider, box flat, rotated 90Â°, box up, box up and rotated 90Â°.

For a set of 4 boxes, that gives 4 power 4 combinations, but with a nice script, that should be easy.

I obvisouly need more time to get it run, and I have a heavy job at the moment. So it may to wait a few weeks...

Do you also consider several layers of boxes on the same palette?

In between, if I can work on it, some more questions:

If you need 2 layers, that means all boxes from the 1st row must be flat and the same height? or all up and same height?

Preferably a fm file or tabbed file, I don't have excel here.

I had a look to Quick Pallet Maker, and I don't feel like doing something like this with fmaker.

I'll have a lok to yr stuff available for download and tell you if I have some clue..

That sounds much easier if true... let me know

example with yr item 6856. my simple thing gives its best with 440 outer boxes / palette.

but by taking the 3rd best solution (420 boxes), you can fit 36 extra boxes with a different orientation, which gives 456 outer boxes / palette.

I am now trying to find the best fit by combining several boxes orientations in the same palette, but this may exceed by poor brain capacity, kind of stuck on finding the right approach for combined orientations...

my file is just importing the necessary data from yours with no link, so its easy for you to use it.

shall I post it on a site for you to retrieve it?

http://www.caraibscann.com/fichiers/boxes1.fp7.zip

Not the solution you were looking for? Getting a personalized solution is easy.

Ask the ExpertsCreate a free account to continue.

Limited access with a free account allows you to:

- View three pieces of content (articles, solutions, posts, and videos)
- Ask the experts questions (counted toward content limit)
- Customize your dashboard and profile

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.