|
outside of a draft there's no way to do that.
you could export players and then randomly assign the team id for each mlb team in your league... ? that would do it quickly and without effort.
use the rand function or is it speelled out random... it's there and use the range of your team ids... they will be successive #'s. may not start at 1 though... hsould be able to define range of random #, if not...
link to that column in empty worksheet, do the random blah blah to get 1-30. use "fill" function for the rest of the fields from that one cell's formula... all done.
in next colomn simply add the diffrence from first team id in game to 1 or "0" if it started 0-29 etc - this is a contant to add and placed somewhere to the side. (avoid autoincrement by linking to this value and using $ in cell address - $a$1 for example).. you now have it adjusted in the 2nd column, fill down from that 1 highlighted box (faster to type range than dragging, so look for last cell row# first.)
copy/paste that new column but, paste special, numbers only... delete 2nd worksheet, re-save, and import into league.
it should assign them in equal proportions ... if not you may have some teams with a few less and a few more etc.. maybe you can force proportional assignment another way? paramater of th rand() funciton maybe?
i would think wiht 750 players, it;ll be close to 25 each..
|