# Container plan-i want to a program with excel that can do container plan dİrectly, please

1. ## Container plan-i want to a program with excel that can do container plan dİrectly, please

ı need a program that can do automatically container plan. when ı enter the dimensions of marble blocks it should show me the container plan.

2. ## Re: Container plan-i want to a program with excel that can do container plan dİrectly, ple

Not sure if I understood your request, but maybe do a formula to find the closest match to the volume for each block?

=INDEX('Container List'!\$B\$5:\$B\$34,MATCH(MIN(ABS('Container List'!\$F\$5:\$F\$35-F5)),ABS('Container List'!\$F\$5:\$F\$35-F5),0))

After you put the formula in cell, press Ctrl+Shift+Enter for it to take effect. Then drag it down.

3. ## Re: Container plan-i want to a program with excel that can do container plan dİrectly, ple

Originally Posted by PaulM100
Not sure if I understood your request, but maybe do a formula to find the closest match to the volume for each block?

=INDEX('Container List'!\$B\$5:\$B\$34,MATCH(MIN(ABS('Container List'!\$F\$5:\$F\$35-F5)),ABS('Container List'!\$F\$5:\$F\$35-F5),0))

After you put the formula in cell, press Ctrl+Shift+Enter for it to take effect. Then drag it down.
ı need this with makros automatically; when ı enter the dimensions of blocks it should be calculate and prepare the proper container list. at the sample we have a block list with dimensions and gross, and ı need the list(it showed book"container list"= it is a sample) one container(ı send the picture the container dimensions) should be under the 26,5 tonage

4. ## Re: Container plan-i want to a program with excel that can do container plan dİrectly, ple

So data (block size) is entered in C:E of Container list - a variable set of blocks ? -and you want to optimise the number of containers with tonnage less than 26.5 per container.

???

5. ## Re: Container plan-i want to a program with excel that can do container plan dİrectly, ple

Originally Posted by JohnTopley
So data (block size) is entered in C:E of Container list - a variable set of blocks ? -and you want to optimise the number of containers with tonnage less than 26.5 per container.

???
yes tonnage should be less than 26,85 tonage, and dimensions should be less than given dimensions on the picture of container

6. ## Re: Container plan-i want to a program with excel that can do container plan dİrectly, ple

This is a "Bin Packing" problem and not being a mathematician, I have no idea what algorithm is needed.

And on a more practical note: it is not obvious to me how the blocks are selected: Is an order placed (as an example) for blocks nos 1,5 and 7 with differing quanties for each?

See

https://stackoverflow.com/questions/...1d-bin-packing

7. ## Re: Container plan-i want to a program with excel that can do container plan dİrectly, ple

Welcome to the forum.

We would very much like to help you with your query, however it has been brought to our attention that the same query has been posted on one or more other forums and you have not provided the required cross-post link(s) here.

Please see Forum Rule #3 about cross-posting and adjust accordingly. Read this to understand why we (and other sites like us) consider this to be important.

8. ## Re: Container plan-i want to a program with excel that can do container plan dİrectly, ple

ı am sory that ı could not put the link before ı posted the other forums. ı did it in good faith , just ı need the quick answer. ı am apologized that ıf ı broke any rule from forums.

9. ## Re: Container plan-i want to a program with excel that can do container plan dİrectly, ple

You may find useful this free workbook for 3D bin packing problems.

HTH,

Francesco

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1