How to shuffle all rosters

Rampkin325 · 04-06-2018, 05:14 PM

Hi everyone!

In years past instead of doing a draft I preferred to just shuffle all players. However, I'm struggling to find the option to do that in this year's game. Could someone help me figure out how to shuffle all players around?

Thanks!

NoOne · 04-06-2018, 11:27 PM

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..

mrbucket · 04-07-2018, 02:27 AM

In Excel, I'd probably do it this way for true randomness but ensuring an even split.

Assuming the Player info is in columns A-H, column headers in row 1, and the data starting in row 2. (away from the game so can't see what actual export looks like)

You put =rand() into cell I2 and copy that formula down to the last entry. You'll get numbers like 0.672140636.

Then in cell J2 you put =ROUNDUP(RANK.EQ(I2;I:I)/(COUNT(I:I)/30);0) and copy down to the last entry.

In column J you now have a list of team ids ranging from 1 to 30. You can copy those numbers and Paste Special as Values Only over the current team ids.

Notes:

If the number of entries isn't a multiple of 30 then you won't get an even split. So if you want everyone to have an exact squad of 25, then you need 750 players. If you have 751 then the extra player will get assigned in a patterned way (not random) and one squad will have 26.

If you wanted a different number of teams then you can change the 30 in the second formula to whatever you desire.

Probably not what OP is after but it was a fun formula.

Reed · 04-07-2018, 09:13 AM

During preseason, you should be able to go into league function and on left side of page, release all players and that will schedule a draft. Then just let the AI draft for all teams.

Rampkin325 · 04-09-2018, 06:19 PM

Quote:

Originally Posted by Reed

During preseason, you should be able to go into league function and on left side of page, release all players and that will schedule a draft. Then just let the AI draft for all teams.

Will the AI always draft players in the same order? I.e., if the Dodgers pick first and select idk, Goldschmidt, then I redo the draft and the Cubs pick first will they also pick Goldschmidt first?

NoOne · 04-10-2018, 04:15 PM

rand has an option to do integers only, i think

or nest with absolute value() thingy... defintiely possible.

04-06-2018, 05:14 PM	#1
Rampkin325 Bat Boy Join Date: Apr 2018 Location: Phoenix, AZ Posts: 6	How to shuffle all rosters Hi everyone! In years past instead of doing a draft I preferred to just shuffle all players. However, I'm struggling to find the option to do that in this year's game. Could someone help me figure out how to shuffle all players around? Thanks!

04-06-2018, 11:27 PM	#2
NoOne Hall Of Famer Join Date: Apr 2015 Posts: 7,227	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..

04-07-2018, 02:27 AM	#3
mrbucket All Star Reserve Join Date: Nov 2013 Location: New Zealand Posts: 860	In Excel, I'd probably do it this way for true randomness but ensuring an even split. Assuming the Player info is in columns A-H, column headers in row 1, and the data starting in row 2. (away from the game so can't see what actual export looks like) You put =rand() into cell I2 and copy that formula down to the last entry. You'll get numbers like 0.672140636. Then in cell J2 you put =ROUNDUP(RANK.EQ(I2;I:I)/(COUNT(I:I)/30);0) and copy down to the last entry. In column J you now have a list of team ids ranging from 1 to 30. You can copy those numbers and Paste Special as Values Only over the current team ids. Notes: If the number of entries isn't a multiple of 30 then you won't get an even split. So if you want everyone to have an exact squad of 25, then you need 750 players. If you have 751 then the extra player will get assigned in a patterned way (not random) and one squad will have 26. If you wanted a different number of teams then you can change the 30 in the second formula to whatever you desire. Probably not what OP is after but it was a fun formula.

04-07-2018, 09:13 AM	#4
Reed Hall Of Famer Join Date: Oct 2013 Posts: 2,337	During preseason, you should be able to go into league function and on left side of page, release all players and that will schedule a draft. Then just let the AI draft for all teams.

04-10-2018, 04:15 PM	#6
NoOne Hall Of Famer Join Date: Apr 2015 Posts: 7,227	rand has an option to do integers only, i think or nest with absolute value() thingy... defintiely possible.