JeremyHight
I wish I was Scrubs
Burnt has his thread dealing with the topic, but I made one as well. The difference between our systems is that I made a fully automated process in a spreadsheet that you can change in any way you want. It is based around having three options: Probability of Suspensions (How likely do you want a suspension to be), Maximum number of suspensions per week (a limit on how many can be handed out), and the Maximum number of games a player can be suspended. Basically, you put in the options you want and calculate, the system does the rest for you.
The first image has suspension probability of 30% with up to 3 suspensions and a max of a 14 game suspension (one entire season). You'll notice that several people have under the 30% roll, but only the 3 lowest rolls get a suspension. After that, the position and string are randomly selected.
The second image has suspension probability of 20% with up to 2 suspensions and a max of a 4 game suspension. In this case, only 2 people can be selected for suspensions and they could only receive up to a 4 game suspension.
The final image has a suspension probability of 15% with up to 5 suspensions and a max of a 12 game suspension. Because teams didn't roll low enough, only 2 suspensions were awarded.
Best things about it, it can be done in about 5 seconds just by hitting a three button combination to reroll all the numbers. Also, it is customizable, so if you want longer or shorter suspensions, you can do it or if you want no limit on the number of suspensions per week, you can do that, too. Also, if you have teams leave, just delete their row of data and it will automatically not count them, so it can work for any number of teams.
Link: http://www.virtualsportsnetwork.com/forum/Suspension Generator.xlsm
The first image has suspension probability of 30% with up to 3 suspensions and a max of a 14 game suspension (one entire season). You'll notice that several people have under the 30% roll, but only the 3 lowest rolls get a suspension. After that, the position and string are randomly selected.
The second image has suspension probability of 20% with up to 2 suspensions and a max of a 4 game suspension. In this case, only 2 people can be selected for suspensions and they could only receive up to a 4 game suspension.
The final image has a suspension probability of 15% with up to 5 suspensions and a max of a 12 game suspension. Because teams didn't roll low enough, only 2 suspensions were awarded.
Best things about it, it can be done in about 5 seconds just by hitting a three button combination to reroll all the numbers. Also, it is customizable, so if you want longer or shorter suspensions, you can do it or if you want no limit on the number of suspensions per week, you can do that, too. Also, if you have teams leave, just delete their row of data and it will automatically not count them, so it can work for any number of teams.
Link: http://www.virtualsportsnetwork.com/forum/Suspension Generator.xlsm
