DrunkenPanda
New Member
- Joined
- Mar 16, 2017
- Messages
- 4
Hey, guys.
So, obviously, I stumbled upon something that I can't seem to figure out myself.
I googled, read and watched a lot. But this problem seems to be a bit too specific to find a solution on web.
80 items. Each item has a different "value" relative to each other. I want to put them in 10 evenly distributed groups.
For simplicity purpose, let's make that 6 items and 2 groups.
[TABLE="width: 500"]
<tbody>[TR]
[TD][/TD]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[TD]D[/TD]
[TD]E[/TD]
[TD]F[/TD]
[/TR]
[TR]
[TD]A[/TD]
[TD][/TD]
[TD]69[/TD]
[TD]81[/TD]
[TD]72[/TD]
[TD]56[/TD]
[TD]86[/TD]
[/TR]
[TR]
[TD]B[/TD]
[TD]59[/TD]
[TD][/TD]
[TD]63[/TD]
[TD]81[/TD]
[TD]99[/TD]
[TD]92[/TD]
[/TR]
[TR]
[TD]C[/TD]
[TD]58[/TD]
[TD]60[/TD]
[TD][/TD]
[TD]52[/TD]
[TD]86[/TD]
[TD]82[/TD]
[/TR]
[TR]
[TD]D[/TD]
[TD]76[/TD]
[TD]83[/TD]
[TD]96[/TD]
[TD][/TD]
[TD]85[/TD]
[TD]81[/TD]
[/TR]
[TR]
[TD]E[/TD]
[TD]58[/TD]
[TD]52[/TD]
[TD]99[/TD]
[TD]70[/TD]
[TD][/TD]
[TD]68[/TD]
[/TR]
[TR]
[TD]F[/TD]
[TD]100[/TD]
[TD]72[/TD]
[TD]69[/TD]
[TD]82[/TD]
[TD]77[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
Honestly. My only idea so far was to make every combination possible and then compare. Not only is even that too hard for me but it also would have an enormous amount of possibilities.
In actuality - the items would be players, groups would be teams, values would be how they value each other.
It would be a google spreadsheet, so VBA is a no-no.
Frankly, I don't expect a solution, but any idea will be appreciated.
So, obviously, I stumbled upon something that I can't seem to figure out myself.
I googled, read and watched a lot. But this problem seems to be a bit too specific to find a solution on web.
80 items. Each item has a different "value" relative to each other. I want to put them in 10 evenly distributed groups.
For simplicity purpose, let's make that 6 items and 2 groups.
[TABLE="width: 500"]
<tbody>[TR]
[TD][/TD]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[TD]D[/TD]
[TD]E[/TD]
[TD]F[/TD]
[/TR]
[TR]
[TD]A[/TD]
[TD][/TD]
[TD]69[/TD]
[TD]81[/TD]
[TD]72[/TD]
[TD]56[/TD]
[TD]86[/TD]
[/TR]
[TR]
[TD]B[/TD]
[TD]59[/TD]
[TD][/TD]
[TD]63[/TD]
[TD]81[/TD]
[TD]99[/TD]
[TD]92[/TD]
[/TR]
[TR]
[TD]C[/TD]
[TD]58[/TD]
[TD]60[/TD]
[TD][/TD]
[TD]52[/TD]
[TD]86[/TD]
[TD]82[/TD]
[/TR]
[TR]
[TD]D[/TD]
[TD]76[/TD]
[TD]83[/TD]
[TD]96[/TD]
[TD][/TD]
[TD]85[/TD]
[TD]81[/TD]
[/TR]
[TR]
[TD]E[/TD]
[TD]58[/TD]
[TD]52[/TD]
[TD]99[/TD]
[TD]70[/TD]
[TD][/TD]
[TD]68[/TD]
[/TR]
[TR]
[TD]F[/TD]
[TD]100[/TD]
[TD]72[/TD]
[TD]69[/TD]
[TD]82[/TD]
[TD]77[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
Honestly. My only idea so far was to make every combination possible and then compare. Not only is even that too hard for me but it also would have an enormous amount of possibilities.
In actuality - the items would be players, groups would be teams, values would be how they value each other.
It would be a google spreadsheet, so VBA is a no-no.
Frankly, I don't expect a solution, but any idea will be appreciated.