英文:
How to find the right combination of numbers which fits to multiple certain values
问题
有8个装满纸箱的托盘，但我们不确定哪个纸箱装在哪个托盘上。
我们拥有的信息如下：
- 有32个纸箱，每个纸箱的重量已知。
- 有8个托盘，每个托盘的重量（不包括托盘本身的重量）已知。
在这种情况下，是否有一种方法可以将纸箱的重量分配给每个托盘，以便我们可以知道哪个纸箱放在哪个托盘上？
- 我尝试使用求解器函数，但它无法帮助我找到每个托盘的所有组合。
- 然后我尝试使用sumproduct函数找到所有组合，但我只能找到每个托盘的组合，无法找到与所有托盘匹配的重量组合。
如果有人能帮忙解决这个问题，那就太好了。
英文:
There are 8 pallets loaded with cartons, but we are not sure which carton is loaded on which pallet.
Information we have :
-There are 32 cartons and weight of each carton is known.
-There are 8 pallets and weight of each pallet without pallet weight is known.
In this situation, is there a way to allocate carton weight to each pallet so that we can know which carton is out into which pallet?
-I tried to use solver function but it did not help as they could only find one combination per pallet.
-Then I tried to use sumproduct to find all combinations, but I could only find combinations per pallet and couldn't find the combinations of weights which matches all the pallets.
https://www.ablebits.com/office-addins-blog/find-combinations-that-equal-given-sum-excel/
It would be great if anyone can help with this.
答案1
得分: 1
所以，对于前两个托盘，你会遇到求解器限制 - 你可以购买更大版本来克服这个问题，或者每次处理两个托盘...
英文:
So, did this for the first 2 pallets, however you run into a Solver limit - you can purchase the larger version to overcome this or do for 2 pallets at a time...
通过集体智慧和协作来改善编程学习和解决问题的方式。致力于成为全球开发者共同参与的知识库，让每个人都能够通过互相帮助和分享经验来进步。
评论