Summer Hockey Private Skate

Job ID: 36128071

Budget: $10 – $30 USD

I run a private skate and am looking for an excel formula with the capability to:

divide teams based on most even split of players from the 7 categories:

Speed, awareness, scoring, off, def, possesion, passing.

Basically I need to be able to select players from a master list or pool, then have the formula split teams based on position (equal number of D and equal number of FWs - it should be 4 D and like 9 Fs a side, but also have the most equal ability.

Let me know estimated cost and turn aorund time. Attached is the master list file with the player scoring criterie
Related categories: Visual Basic Data Processing Data Entry Excel