Hi all
i have a question. in the upload file how can I manage, the type of pallet needed...there are 3 kind of pallets.
adding many products, with different size. what pallet suites better.
I dont know if my question is clear...
thanks in advance
Rui Ramos.
Try this formula in J3 and fill down
It is just something to get you started.
=IF(C8*D8*E8*F8<=$G$2,$C$2,IF(C8*D8*E8*F8<=G$3,C$3,IF(C8*D8*E8*F8<=$G$4,$C$4,"Over Size")))
My General Rules if you want my help. Not aimed at any person in particular:
1. Please Make Requests not demands, none of us get paid here.
2. Check back on your post regularly. I will not return to a post after 4 days.
If it is not important to you then it definitely is not important to me.
Does this earlier thread from 4 years ago help?
https://www.excelforum.com/excel-gen...alculator.html
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star iconbelow the post.
Thank you mehmetcik, is a start, yes.
I will try it.
the issue is adding, for example 3 different products are supportable in that particular pallet...the pallet is to be stacked...with all 3 products.
Rui Ramos.
Hi Richard
I did saw that post, but it didnt work for me
Thanks
Rui
This seems to be a 3D bin packing problem, so you may want to give to this free solver a try.
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.
It wouldn't work 'out of the box' since cell references were in different positions, but it seemed to me that if you faithfully change the references it would work.
I will give a try again.
many thanks, and have a wonderful day
Rui Ramos
This can be the solution? SUM all volume?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks