View Single Post
Old 06-16-2013, 08:36 PM   #11
Timeetyo
Rookie
 
OVR: 5
Join Date: Aug 2002
Re: Timeetyo’s NCAA 14 Relegation System

One piece I forgot to add that is a fun twist for my dynasties - and that is my own system for NCAA violations. I do this mostly as a fun twist to randomly punish the top 25 but it also has some fun twists in that a bad roll can really gut a top team if it takes out a key player. I can't describe the feeling I had when it cost me my starting QB in a year when I was expecting to make a push for my first national championship (and failed). I only do this for the top 25 as I get the best bang for the buck that way. So here is how it works:

• I have an excel spreadsheet setup to use random to make rolls for each of the top 25 teams (RND column).

• Based on this RND, it determines if a team is impacted, and if so, how many players.

• I have easily changeable tiers for players 1-5 so I can tweak if I want more or less teams to be impacted – and more or less players.

• My current setup is 70% (1-70) are not impacted; 10% lose 1 player (71-80); 10% lose 2 players (81-90); 3% lose 3 players (91-93); 3% lose 4 players (93-96); 4% lose 5 players (97-100).

• There is then a roll for each player to see what position is affected (WR & CB are in 2x, K&P are combined).

• Next is a roll on depth (1-3) with 1 being the starter. If a 3 is rolled and a team only has 2 at a position I impact the 2nd stringer. If the same position gets hit for the same depth slot – I’ll take the next best equivalent (see below example).

• If it is a player on my team – I just cut them at the appropriate stage in the offseason. For other teams, since we can’t cut I essentially replace them with a walk-on. This means editing down key ratings to make them 60ish overall. The key here is to edit them across the board, not just cutting speed / THP/THA, etc. I did this one year and team ended up playing a RB with 20 speed. Oops…it was ugly.


Below is what this looks like for a given year. Here are some observations from this particular roll:

• 2nd team is gutted. They lose their starting QB, LE, & RE. Then they lose their backup RE and their 2nd best kicker or punter. Ouch!!!

• 4th team loses their 3rd QB (oh well unless he’s a stud freshman). Then there is the dilemma of what to do at LT. They lose their 2nd LT (easy) and need to lose one more. If they had 3 LTs, I’d take their 3rd LT as well. If not – I’d take their 2nd RT (next closest equivalent).

• 9 of 25 teams are impacted losing a total of 22 players are impacted



Edit and update:
Thanks to MRE and a few others questions and great feedback, I have added a few new tabs which include:
- A calculator for you to change the number of teams used and thresholds to get an idea of on average how many teams and players will be impacted.
- A new tab showing all 126 teams for those who want to have the potential to impact those outside the top 25
- A new 1-70 OVR roll to determine which players is impacted. Instead of rolling QB #2, this rolls player number 19. Just sort the team by OVR and nuke the 19th player down. This helps make it more fair what positions are impacted.
Attached Images
File Type: jpg Violations.jpg (206.9 KB, 1384 views)

Last edited by Timeetyo; 07-05-2013 at 01:44 PM. Reason: Added a second tab to do all 126 teams and 1-70 scale - thx MRE!
Timeetyo is offline  
Reply With Quote
Advertisements - Register to remove