Hello all,
I'm looking to create a spreadsheet that will take the names of 6 people and randomly split the names into 2 groups of 3. This will have to be done 9 times without any duplication.
Any help would be appreciated.
Thanks.
[Solved] Random team assignments
[Solved] Random team assignments
Last edited by imacanuck on Wed Feb 21, 2024 10:42 pm, edited 3 times in total.
AO4.1.13 / LO7.3.7.2 / Win 10
Re: Random Team Assignments
it can be done 10 times - example:
Code: Select all
[A,B,C][D,E,F] 01
[A,B,D][C,E,F] 02
[A,B,E][C,D,F] 03
[A,B,F][C,D,E] 04
[A,C,D][B,E,F] 05
[A,C,E][B,D,F] 06
[A,C,F][B,D,E] 07
[A,D,E][B,C,F] 08
[A,D,F][B,C,E] 09
[A,E,F][B,C,D] 10
LibreOffice 7.6.6.3 on Ubuntu 22.04.4 LTS
- MrProgrammer
- Moderator
- Posts: 4909
- Joined: Fri Jun 04, 2010 7:57 pm
- Location: Wisconsin, USA
Re: Random Team Assignments
Put the names of the people in sheet Roster. Nine distinct, randomly-chosen groupings will appear in sheet NineTeams.
To generate a new grouping select sheet Random. Select C2:C21 → Edit → Copy. For OpenOffice, select B2 → Edit → Paste Special → Selection:Numbers (only) → Options:None → Operations:None → ShiftCells:Don't → OK. Sheet NineTeams will have the new groupings.
After selecting B2, for LibreOffice use Edit → Paste Special → Paste Special → Selection etc. I don't use LibreOffice and didn't test it there.
If this solved your problem please go to your first post use the Edit ☐ button and add [Solved] to the start of the Subject field. Select the green checkmark icon at the same time.
[Tutorial] Randomization in Calc, sections E and J
Mr. Programmer
AOO 4.1.7 Build 9800, MacOS 13.6.3, iMac Intel. The locale for any menus or Calc formulas in my posts is English (USA).
AOO 4.1.7 Build 9800, MacOS 13.6.3, iMac Intel. The locale for any menus or Calc formulas in my posts is English (USA).
Re: Random Team Assignments
Thank you both, your responses are appreciated.
I was able to come up with a spreadsheet that defined the 20 possible combinations available, then copy and paste the combinations, assign a random number to each pasted row then sort to come up with the 9 random assignments required.
See attached, let me know your thoughts.
I was able to come up with a spreadsheet that defined the 20 possible combinations available, then copy and paste the combinations, assign a random number to each pasted row then sort to come up with the 9 random assignments required.
See attached, let me know your thoughts.
- Attachments
-
- Random Teams.ods
- (12.31 KiB) Downloaded 52 times
AO4.1.13 / LO7.3.7.2 / Win 10