Automated Player Distribution to Group

[laumeng]

Hi,

I would like to seek some help over here for my school band distribution program. The flow of the flow chart as below :-

1. Individual Registration based on school
2. Automated grouping based on individual instruments (e.g.Flute, Clarinet)
3. Automated distribution into the Band A & Band B based on the strength where it start with distributing the higher strength player individually (e.g. Strength 3 = Best, Strength 2 = Moderate, Strength 1 = Beginner) follow by the moderate and last beginner.
4. Once the player is distributed evenly, the chart will automatically highlight the player based on their school colour.

I hope someone can help me out as I'm looking into having a camp with 500 students and distributing them into the respective band will be a nightmare.

Thank you in advanced



https://drive.google.com/open?id=0BwQsaSlS_f_8czRra3plTVpuZGs

 

[oldbrewer]

[TABLE="width: 1041"]
<colgroup><col><col><col><col><col><col><col><col><col><col><col span="4"><col><col><col span="5"></colgroup><tbody>[TR]
[TD]school[/TD]
[TD]name[/TD]
[TD="colspan: 2"]instrument[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]school[/TD]
[TD]name[/TD]
[TD]instrument[/TD]
[TD]band[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]school[/TD]
[TD]name[/TD]
[TD]instrument[/TD]
[TD]band[/TD]
[/TR]
[TR]
[TD]school1[/TD]
[TD]name1[/TD]
[TD]violin[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]school2[/TD]
[TD]name14[/TD]
[TD]cello[/TD]
[TD]BAND A[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]school2[/TD]
[TD]name14[/TD]
[TD]cello[/TD]
[TD]BAND A[/TD]
[/TR]
[TR]
[TD]school1[/TD]
[TD]name2[/TD]
[TD]flute[/TD]
[TD][/TD]
[TD="colspan: 2"]assume you have[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]school3[/TD]
[TD]name21[/TD]
[TD]cello[/TD]
[TD]BAND B[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]school3[/TD]
[TD]name24[/TD]
[TD]cello[/TD]
[TD]BAND A[/TD]
[/TR]
[TR]
[TD]school1[/TD]
[TD]name3[/TD]
[TD]cello[/TD]
[TD][/TD]
[TD="colspan: 2"] 3 schools[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]school3[/TD]
[TD]name24[/TD]
[TD]cello[/TD]
[TD]BAND A[/TD]
[TD][/TD]
[TD]add a 4th[/TD]
[TD][/TD]
[TD]school1[/TD]
[TD]name3[/TD]
[TD]cello[/TD]
[TD]BAND A[/TD]
[/TR]
[TR]
[TD]school1[/TD]
[TD]name4[/TD]
[TD]violin[/TD]
[TD][/TD]
[TD="colspan: 2"]details as to the left[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]school3[/TD]
[TD]name26[/TD]
[TD]cello[/TD]
[TD]BAND B[/TD]
[TD][/TD]
[TD]column[/TD]
[TD][/TD]
[TD]school2[/TD]
[TD]name8[/TD]
[TD]cello[/TD]
[TD]BAND A[/TD]
[/TR]
[TR]
[TD]school1[/TD]
[TD]name5[/TD]
[TD]trumpet[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]school1[/TD]
[TD]name3[/TD]
[TD]cello[/TD]
[TD]BAND A[/TD]
[TD][/TD]
[TD]alternating[/TD]
[TD][/TD]
[TD]school3[/TD]
[TD]name30[/TD]
[TD]drum[/TD]
[TD]BAND A[/TD]
[/TR]
[TR]
[TD]school1[/TD]
[TD]name6[/TD]
[TD]flute[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]school1[/TD]
[TD]name7[/TD]
[TD]cello[/TD]
[TD]BAND B[/TD]
[TD][/TD]
[TD]BAND A[/TD]
[TD][/TD]
[TD]school2[/TD]
[TD]name15[/TD]
[TD]flute[/TD]
[TD]BAND A[/TD]
[/TR]
[TR]
[TD]school1[/TD]
[TD]name7[/TD]
[TD]cello[/TD]
[TD][/TD]
[TD="colspan: 2"]now sort this list[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]school2[/TD]
[TD]name8[/TD]
[TD]cello[/TD]
[TD]BAND A[/TD]
[TD][/TD]
[TD]and BAND B[/TD]
[TD][/TD]
[TD]school1[/TD]
[TD]name2[/TD]
[TD]flute[/TD]
[TD]BAND A[/TD]
[/TR]
[TR]
[TD]school2[/TD]
[TD]name8[/TD]
[TD]cello[/TD]
[TD][/TD]
[TD="colspan: 2"]by first instrument[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]school2[/TD]
[TD]name10[/TD]
[TD]drum[/TD]
[TD]BAND B[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]school2[/TD]
[TD]name11[/TD]
[TD]trumpet[/TD]
[TD]BAND A[/TD]
[/TR]
[TR]
[TD]school2[/TD]
[TD]name9[/TD]
[TD]violin[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]school3[/TD]
[TD]name30[/TD]
[TD]drum[/TD]
[TD]BAND A[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]school3[/TD]
[TD]name20[/TD]
[TD]trumpet[/TD]
[TD]BAND A[/TD]
[/TR]
[TR]
[TD]school2[/TD]
[TD]name10[/TD]
[TD]drum[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]school2[/TD]
[TD]name13[/TD]
[TD]flute[/TD]
[TD]BAND B[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]school3[/TD]
[TD]name27[/TD]
[TD]trumpet[/TD]
[TD]BAND A[/TD]
[/TR]
[TR]
[TD]school2[/TD]
[TD]name11[/TD]
[TD]trumpet[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]school2[/TD]
[TD]name15[/TD]
[TD]flute[/TD]
[TD]BAND A[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]school1[/TD]
[TD]name5[/TD]
[TD]trumpet[/TD]
[TD]BAND A[/TD]
[/TR]
[TR]
[TD]school2[/TD]
[TD]name12[/TD]
[TD]violin[/TD]
[TD][/TD]
[TD="colspan: 2"]then second name[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]school3[/TD]
[TD]name18[/TD]
[TD]flute[/TD]
[TD]BAND B[/TD]
[TD][/TD]
[TD]then[/TD]
[TD][/TD]
[TD]school2[/TD]
[TD]name12[/TD]
[TD]violin[/TD]
[TD]BAND A[/TD]
[/TR]
[TR]
[TD]school2[/TD]
[TD]name13[/TD]
[TD]flute[/TD]
[TD][/TD]
[TD="colspan: 2"]then third school[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]school1[/TD]
[TD]name2[/TD]
[TD]flute[/TD]
[TD]BAND A[/TD]
[TD][/TD]
[TD]finally sort[/TD]
[TD][/TD]
[TD]school3[/TD]
[TD]name19[/TD]
[TD]violin[/TD]
[TD]BAND A[/TD]
[/TR]
[TR]
[TD]school2[/TD]
[TD]name14[/TD]
[TD]cello[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]school1[/TD]
[TD]name6[/TD]
[TD]flute[/TD]
[TD]BAND B[/TD]
[TD][/TD]
[TD]by band[/TD]
[TD][/TD]
[TD]school3[/TD]
[TD]name25[/TD]
[TD]violin[/TD]
[TD]BAND A[/TD]
[/TR]
[TR]
[TD]school2[/TD]
[TD]name15[/TD]
[TD]flute[/TD]
[TD][/TD]
[TD="colspan: 2"]as table on right[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]school2[/TD]
[TD]name11[/TD]
[TD]trumpet[/TD]
[TD]BAND A[/TD]
[TD][/TD]
[TD]and[/TD]
[TD][/TD]
[TD]school1[/TD]
[TD]name4[/TD]
[TD]violin[/TD]
[TD]BAND A[/TD]
[/TR]
[TR]
[TD]school2[/TD]
[TD]name16[/TD]
[TD]violin[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]school2[/TD]
[TD]name17[/TD]
[TD]trumpet[/TD]
[TD]BAND B[/TD]
[TD][/TD]
[TD="colspan: 2"]by instrument[/TD]
[TD]school3[/TD]
[TD]name21[/TD]
[TD]cello[/TD]
[TD]BAND B[/TD]
[/TR]
[TR]
[TD]school2[/TD]
[TD]name17[/TD]
[TD]trumpet[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]school3[/TD]
[TD]name20[/TD]
[TD]trumpet[/TD]
[TD]BAND A[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]school3[/TD]
[TD]name26[/TD]
[TD]cello[/TD]
[TD]BAND B[/TD]
[/TR]
[TR]
[TD]school3[/TD]
[TD]name18[/TD]
[TD]flute[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]school3[/TD]
[TD]name23[/TD]
[TD]trumpet[/TD]
[TD]BAND B[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]school1[/TD]
[TD]name7[/TD]
[TD]cello[/TD]
[TD]BAND B[/TD]
[/TR]
[TR]
[TD]school3[/TD]
[TD]name19[/TD]
[TD]violin[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]school3[/TD]
[TD]name27[/TD]
[TD]trumpet[/TD]
[TD]BAND A[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]school2[/TD]
[TD]name10[/TD]
[TD]drum[/TD]
[TD]BAND B[/TD]
[/TR]
[TR]
[TD]school3[/TD]
[TD]name20[/TD]
[TD]trumpet[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]school3[/TD]
[TD]name28[/TD]
[TD]trumpet[/TD]
[TD]BAND B[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]school2[/TD]
[TD]name13[/TD]
[TD]flute[/TD]
[TD]BAND B[/TD]
[/TR]
[TR]
[TD]school3[/TD]
[TD]name21[/TD]
[TD]cello[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]school1[/TD]
[TD]name5[/TD]
[TD]trumpet[/TD]
[TD]BAND A[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]school3[/TD]
[TD]name18[/TD]
[TD]flute[/TD]
[TD]BAND B[/TD]
[/TR]
[TR]
[TD]school3[/TD]
[TD]name22[/TD]
[TD]violin[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]school1[/TD]
[TD]name1[/TD]
[TD]violin[/TD]
[TD]BAND B[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]school1[/TD]
[TD]name6[/TD]
[TD]flute[/TD]
[TD]BAND B[/TD]
[/TR]
[TR]
[TD]school3[/TD]
[TD]name23[/TD]
[TD]trumpet[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]school2[/TD]
[TD]name12[/TD]
[TD]violin[/TD]
[TD]BAND A[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]school2[/TD]
[TD]name17[/TD]
[TD]trumpet[/TD]
[TD]BAND B[/TD]
[/TR]
[TR]
[TD]school3[/TD]
[TD]name24[/TD]
[TD]cello[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]school2[/TD]
[TD]name16[/TD]
[TD]violin[/TD]
[TD]BAND B[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]school3[/TD]
[TD]name23[/TD]
[TD]trumpet[/TD]
[TD]BAND B[/TD]
[/TR]
[TR]
[TD]school3[/TD]
[TD]name25[/TD]
[TD]violin[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]school3[/TD]
[TD]name19[/TD]
[TD]violin[/TD]
[TD]BAND A[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]school3[/TD]
[TD]name28[/TD]
[TD]trumpet[/TD]
[TD]BAND B[/TD]
[/TR]
[TR]
[TD]school3[/TD]
[TD]name26[/TD]
[TD]cello[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]school3[/TD]
[TD]name22[/TD]
[TD]violin[/TD]
[TD]BAND B[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]school1[/TD]
[TD]name1[/TD]
[TD]violin[/TD]
[TD]BAND B[/TD]
[/TR]
[TR]
[TD]school3[/TD]
[TD]name27[/TD]
[TD]trumpet[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]school3[/TD]
[TD]name25[/TD]
[TD]violin[/TD]
[TD]BAND A[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]school2[/TD]
[TD]name16[/TD]
[TD]violin[/TD]
[TD]BAND B[/TD]
[/TR]
[TR]
[TD]school3[/TD]
[TD]name28[/TD]
[TD]trumpet[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]school3[/TD]
[TD]name29[/TD]
[TD]violin[/TD]
[TD]BAND B[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]school3[/TD]
[TD]name22[/TD]
[TD]violin[/TD]
[TD]BAND B[/TD]
[/TR]
[TR]
[TD]school3[/TD]
[TD]name29[/TD]
[TD]violin[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]school1[/TD]
[TD]name4[/TD]
[TD]violin[/TD]
[TD]BAND A[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]school3[/TD]
[TD]name29[/TD]
[TD]violin[/TD]
[TD]BAND B[/TD]
[/TR]
[TR]
[TD]school3[/TD]
[TD]name30[/TD]
[TD]drum[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]school2[/TD]
[TD]name9[/TD]
[TD]violin[/TD]
[TD]BAND B[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]school2[/TD]
[TD]name9[/TD]
[TD]violin[/TD]
[TD]BAND B[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]