Hi guys!
I've looked for a way to do this in several foruns and website and found no clue...
Hope someone can help me!![Big grin :biggrin: :biggrin:](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f600.png)
Here is a sample of the data I have:
[TABLE="class: sheet0 gridlines"]
<tbody>[TR]
[TD="class: column0 style0 s row0"]Student1[/TD]
[TD="class: column1 style0 s row0"]Student2[/TD]
[TD="class: column2 style0 s row0"]Student3[/TD]
[TD="class: column3 row0"]Student4[/TD]
[/TR]
[TR="class: row0"]
[TD="class: column0 style0 s"]Nascimento MS[/TD]
[TD="class: column1 style0 s"] Espindola CF[/TD]
[TD="class: column2 style0 s"] do Prado C[/TD]
[TD="class: column3"][/TD]
[/TR]
[TR="class: row1"]
[TD="class: column0 style0 s"]Bhansali S[/TD]
[TD="class: column1 style0 s"]Nascimento MS[/TD]
[TD="class: column2 style0 s"] Dhawan V[/TD]
[TD="class: column3 style0 s"] Amarins MB[/TD]
[/TR]
[TR="class: row2"]
[TD="class: column0 style0 s"]Bozek T[/TD]
[TD="class: column1 style0 s"] Blazekovic A[/TD]
[TD="class: column2"][/TD]
[TD="class: column3"][/TD]
[/TR]
[TR="class: row3"]
[TD="class: column0 style0 s"]Thewjitcharoen Y[/TD]
[TD="class: column1 style0 s"]Nascimento MS[/TD]
[TD="class: column2 style0 s"]do Prado C[/TD]
[TD="class: column3 style0 s"] Nakasatien S[/TD]
[/TR]
[TR="class: row4"]
[TD="class: column0 style0 s"]Jonas MI[/TD]
[TD="class: column1 style0 s"]Bhansali S[/TD]
[TD="class: column2 style0 s"]Amarins MB[/TD]
[TD="class: column3"][/TD]
[/TR]
</tbody>[/TABLE]
I want an arrangement of these cells, outputting pairs that reflect how many times a particular student interacted in these groups.
In other words, it is a simple combination. For each group, there are n!/p!*(n-p)! possibilities of interaction, where "n" is the number of the students in each group (in the sample, ranging from 2 to 4) and "p" equals 2 (pairs of interaction).
Thus, the output would be something like this:
[TABLE="class: sheet0 gridlines"]
<tbody>[TR]
[TD="class: column0 style0 s row0"]Nascimento MS[/TD]
[TD="class: column1 style0 s row0"]Espindola CF[/TD]
[/TR]
[TR="class: row0"]
[TD="class: column0 style0 s"]Nascimento MS[/TD]
[TD="class: column1 style0 s"]do Prado C[/TD]
[/TR]
[TR="class: row1"]
[TD="class: column0 style0 s"]Espindola CF[/TD]
[TD="class: column1 style0 s"]do Prado C[/TD]
[/TR]
[TR]
[TD="class: column0 style0 s row1"]Bhansali S[/TD]
[TD="class: column1 style0 s row1"]Nascimento MS[/TD]
[/TR]
[TR]
[TD="class: column0 style0 s row1"]Bhansali S[/TD]
[TD="class: column1 style0 s row1"]Dhawan V[/TD]
[/TR]
[TR]
[TD="class: column0 style0 s row1"]Bhansali S[/TD]
[TD="class: column1 style0 s row1"]Amarins MB[/TD]
[/TR]
[TR]
[TD="class: column0 style0 s row1"]Nascimento MS[/TD]
[TD="class: column1 style0 s row1"]Dhawan V[/TD]
[/TR]
[TR]
[TD="class: column0 style0 s row1"]Nascimento MS[/TD]
[TD="class: column1 style0 s row1"]Amarins MB[/TD]
[/TR]
[TR]
[TD="class: column0 style0 s row1"]Dhawan V[/TD]
[TD="class: column1 style0 s row1"]Amarins MB[/TD]
[/TR]
[TR]
[TD="class: column0 style0 s row1"]Bozek T[/TD]
[TD="class: column1 style0 s row1"]Blazekovic A[/TD]
[/TR]
[TR]
[TD="class: column0 style0 s row1"]Thewjitcharoen Y[/TD]
[TD="class: column1 style0 s row1"]Nascimento MS[/TD]
[/TR]
[TR]
[TD="class: column0 style0 s row1"]Thewjitcharoen Y[/TD]
[TD="class: column1 style0 s row1"]do Prado C[/TD]
[/TR]
[TR]
[TD="class: column0 style0 s row1"]Thewjitcharoen Y[/TD]
[TD="class: column1 style0 s row1"]Nakasatien S[/TD]
[/TR]
[TR]
[TD="class: column0 style0 s row1"]Nascimento MS[/TD]
[TD="class: column1 style0 s row1"]do Prado C[/TD]
[/TR]
[TR]
[TD="class: column0 style0 s row1"]Nascimento MS[/TD]
[TD="class: column1 style0 s row1"]Nakasatien S[/TD]
[/TR]
[TR]
[TD="class: column0 style0 s row1"]do Prado C[/TD]
[TD="class: column1 style0 s row1"]Nakasatien S[/TD]
[/TR]
</tbody>[/TABLE]
<table class="wysiwyg_dashes wysiwyg_cms_table_sheet0 wysiwyg_cms_table_gridlines" verdana,="" arial,="" tahoma,="" calibri,="" geneva,="" sans-serif;"="" width=""><tbody></tbody></table>...and so on...
It is my first post, but I hope I made it clear enough.![Roll eyes :rolleyes: :rolleyes:](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f644.png)
I've looked for a way to do this in several foruns and website and found no clue...
Hope someone can help me!
![Big grin :biggrin: :biggrin:](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f600.png)
Here is a sample of the data I have:
[TABLE="class: sheet0 gridlines"]
<tbody>[TR]
[TD="class: column0 style0 s row0"]Student1[/TD]
[TD="class: column1 style0 s row0"]Student2[/TD]
[TD="class: column2 style0 s row0"]Student3[/TD]
[TD="class: column3 row0"]Student4[/TD]
[/TR]
[TR="class: row0"]
[TD="class: column0 style0 s"]Nascimento MS[/TD]
[TD="class: column1 style0 s"] Espindola CF[/TD]
[TD="class: column2 style0 s"] do Prado C[/TD]
[TD="class: column3"][/TD]
[/TR]
[TR="class: row1"]
[TD="class: column0 style0 s"]Bhansali S[/TD]
[TD="class: column1 style0 s"]Nascimento MS[/TD]
[TD="class: column2 style0 s"] Dhawan V[/TD]
[TD="class: column3 style0 s"] Amarins MB[/TD]
[/TR]
[TR="class: row2"]
[TD="class: column0 style0 s"]Bozek T[/TD]
[TD="class: column1 style0 s"] Blazekovic A[/TD]
[TD="class: column2"][/TD]
[TD="class: column3"][/TD]
[/TR]
[TR="class: row3"]
[TD="class: column0 style0 s"]Thewjitcharoen Y[/TD]
[TD="class: column1 style0 s"]Nascimento MS[/TD]
[TD="class: column2 style0 s"]do Prado C[/TD]
[TD="class: column3 style0 s"] Nakasatien S[/TD]
[/TR]
[TR="class: row4"]
[TD="class: column0 style0 s"]Jonas MI[/TD]
[TD="class: column1 style0 s"]Bhansali S[/TD]
[TD="class: column2 style0 s"]Amarins MB[/TD]
[TD="class: column3"][/TD]
[/TR]
</tbody>[/TABLE]
I want an arrangement of these cells, outputting pairs that reflect how many times a particular student interacted in these groups.
In other words, it is a simple combination. For each group, there are n!/p!*(n-p)! possibilities of interaction, where "n" is the number of the students in each group (in the sample, ranging from 2 to 4) and "p" equals 2 (pairs of interaction).
Thus, the output would be something like this:
[TABLE="class: sheet0 gridlines"]
<tbody>[TR]
[TD="class: column0 style0 s row0"]Nascimento MS[/TD]
[TD="class: column1 style0 s row0"]Espindola CF[/TD]
[/TR]
[TR="class: row0"]
[TD="class: column0 style0 s"]Nascimento MS[/TD]
[TD="class: column1 style0 s"]do Prado C[/TD]
[/TR]
[TR="class: row1"]
[TD="class: column0 style0 s"]Espindola CF[/TD]
[TD="class: column1 style0 s"]do Prado C[/TD]
[/TR]
[TR]
[TD="class: column0 style0 s row1"]Bhansali S[/TD]
[TD="class: column1 style0 s row1"]Nascimento MS[/TD]
[/TR]
[TR]
[TD="class: column0 style0 s row1"]Bhansali S[/TD]
[TD="class: column1 style0 s row1"]Dhawan V[/TD]
[/TR]
[TR]
[TD="class: column0 style0 s row1"]Bhansali S[/TD]
[TD="class: column1 style0 s row1"]Amarins MB[/TD]
[/TR]
[TR]
[TD="class: column0 style0 s row1"]Nascimento MS[/TD]
[TD="class: column1 style0 s row1"]Dhawan V[/TD]
[/TR]
[TR]
[TD="class: column0 style0 s row1"]Nascimento MS[/TD]
[TD="class: column1 style0 s row1"]Amarins MB[/TD]
[/TR]
[TR]
[TD="class: column0 style0 s row1"]Dhawan V[/TD]
[TD="class: column1 style0 s row1"]Amarins MB[/TD]
[/TR]
[TR]
[TD="class: column0 style0 s row1"]Bozek T[/TD]
[TD="class: column1 style0 s row1"]Blazekovic A[/TD]
[/TR]
[TR]
[TD="class: column0 style0 s row1"]Thewjitcharoen Y[/TD]
[TD="class: column1 style0 s row1"]Nascimento MS[/TD]
[/TR]
[TR]
[TD="class: column0 style0 s row1"]Thewjitcharoen Y[/TD]
[TD="class: column1 style0 s row1"]do Prado C[/TD]
[/TR]
[TR]
[TD="class: column0 style0 s row1"]Thewjitcharoen Y[/TD]
[TD="class: column1 style0 s row1"]Nakasatien S[/TD]
[/TR]
[TR]
[TD="class: column0 style0 s row1"]Nascimento MS[/TD]
[TD="class: column1 style0 s row1"]do Prado C[/TD]
[/TR]
[TR]
[TD="class: column0 style0 s row1"]Nascimento MS[/TD]
[TD="class: column1 style0 s row1"]Nakasatien S[/TD]
[/TR]
[TR]
[TD="class: column0 style0 s row1"]do Prado C[/TD]
[TD="class: column1 style0 s row1"]Nakasatien S[/TD]
[/TR]
</tbody>[/TABLE]
<table class="wysiwyg_dashes wysiwyg_cms_table_sheet0 wysiwyg_cms_table_gridlines" verdana,="" arial,="" tahoma,="" calibri,="" geneva,="" sans-serif;"="" width=""><tbody></tbody></table>...and so on...
It is my first post, but I hope I made it clear enough.
![Roll eyes :rolleyes: :rolleyes:](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f644.png)