Jan 31, 2010

One Spreadsheet to Rule Them All

Well, you may have wondered what exactly happened to Mr. Cheatsheet over the past couple of days.  You probably thought "I stumbled upon this site and then he just disappears on me? Double you tea eff, mate?".  Calm down, little soldier boy.  I actually had an epiphany for how to completely rework the logic behind these spreadsheets for a variety of reasons and have finally finished up the updates.  Here are what are improved from previous versions of the cheatsheets:

  • No longer have separate sheets for different sized leagues. Now, it's completely customizable from within the cheatsheet and can be updated at any time... for the rare instance where you suddenly change from a 12 team league to a 14 team league mid-draft!
  • No longer restricted to the standard 5 roto categories. I currently have 8 hitting and 8 pitching categories to choose from but would love suggestions on additional categories that you may need.
  • Better logic behind WERTH points system. This was where the rewrite started. The previous logic was fine but it was cumbersome and led to a lot of additional work to customize the sheet. I looked deep inside the logic and found a much more efficient calculation for more accurate roto points predictions.
So, there you have it.  Now, go on and test out the first of our new cheatsheets: the 2010 Fantasy Baseball Mixed Roto cheatsheet.

0 comments:

Post a Comment