LinkBack URL
About LinkBacks
ı need a program that can do automatically container plan. when ı enter the dimensions of marble blocks it should show me the container plan.
Enlargerimensions and block list and container plan sample attached. PLease help me?
ı need a program that can do automatically container plan. when ı enter the dimensions of marble blocks it should show me the container plan.
Enlargerimensions and block list and container plan sample attached. PLease help me?
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.
Click the * to say thanks.
ı 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 tonageOriginally Posted by PaulM100
Last edited by bilkan21; 03-19-2021 at 04:32 AM.
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
Last edited by bilkan21; 03-19-2021 at 05:18 AM.
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
Last edited by JohnTopley; 03-19-2021 at 08:04 AM.
Administrative Note:
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.
Rory
ı 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.
You may find useful this free workbook for 3D bin packing problems.
HTH,
Francesco
Aim high or don't even try.
---------------------------------
If your question has been answered, don't forget to mark the thread as SOLVED.
If you find an answer helpful, click on the star icon at the bottom of the post.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks