英文:
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...
通过集体智慧和协作来改善编程学习和解决问题的方式。致力于成为全球开发者共同参与的知识库，让每个人都能够通过互相帮助和分享经验来进步。
评论