I’m not the smartest guy. Corey Brewer anyone? As a result, I often lose track of where I’m at in certain categories when I’m drafting. Maybe it’s all the trees I smoked or the magic mushrooms I ate in the past. Whatever the case may be, I’m a dummy and can’t remember things too well. Therefore, I made a very basic draft tool on Google Sheets which keeps track of everything and lets me know how close/far I am away from certain benchmarks. This can also be helpful post-draft, as you can see how your team stacks up in each category. Please click HERE to read about how I ascertained said benchmarks. So, 24 weeks of data gave me an average for what it took to win each category on a weekly basis. From there, I divided that number by 3.15 (the average number of games each team plays per week) which gave me a per game target number. Then, I submitted the sheet to Rudy (who is a real life wizard by the way) and he did his magic. Rudy was able to link all the players from my projections sheet so that the data wouldn’t have to be inputted manually. Rudy! Rudy! Rudy! The sheet is pretty self explanatory. The row with the colors will show you how far away you are from the target number. Keep in mind that the projections are based off my numbers. Modify them to suit your needs. Hopefully this helps you guys out pre and post draft.

Click HERE to make a copy of the sheet.

Any and all suggestions are welcome to make this a better tool. Comment below.

  1. alex says:
    (link)

    nice

    • Son

      Son says:
      (link)

      Thanks!

  2. cameron says:
    (link)

    lol this is un-freaking-believable. Very impressive, I sometimes wonder why this site and these blog posts don’t get more attention…*starts slow clap*

    • Son

      Son says:
      (link)

      @cameron: Thanks man! Spread the word

    • Brent

      Brent says:
      (link)

      @cameron: Spread the word!

  3. Philip says:
    (link)

    How to modify the target number if my league is only playing 9 players?

    • Son

      Son says:
      (link)

      @Philip: Divide each category by 10 then multiply by 9. Leave the shooting percentages alone

      • Philip says:
        (link)

        @Son: Thanks! Nice work!

        • Son

          Son says:
          (link)

          @Philip: Thanks!

  4. Chad Threecola says:
    (link)

    Nice Work, as always.

    Any way of increasing the number of players drafted to 13 players, instead of 10?

    • Chad says:
      (link)

      Nevermind, just downloaded it from google sheets and was able to make the change.

      “This is for Rudy, Coach”

    • Son

      Son says:
      (link)

      Thanks Chad! Love the Threeecola but you forgot an e.

      As for your question, I kept it at 10 because that’s the standard starting roster construction. I assume you want to include bench players, but factoring in bench stats wouldn’t be beneficial. If you have a 13 player starting roster, then disregard everything I just wrote. If that’s the case, email me @ [email protected] and I’ll try and configure a sheet for you

  5. Roll says:
    (link)

    Can this be used in a roto league with 13 players per team?

    • Son

      Son says:
      (link)

      Technically, yes. You’d have to input your own set of benchmark numbers, though. As for adding players, just copy and paste a blank spot.

  6. Nishinga says:
    (link)

    This is awesome mate, but there is a problem with Razzball Projections sheet’s stats, they aren’t in accordance with the stats on the site.
    For example:
    Russel Westbrook on the site:
    45% 77% 1.23 25.63 10.1 10.3 1.8 .3 4.8
    on the sheet:
    0.449 0.767 1 20.6 8.1 8.3 1.4 0.2 3.8

    can you fix?

    • Son

      Son says:
      (link)

      Thanks!

      Westbrook’s stats should be good. I made an adjustment due to his knee surgery. Knocked him down around 20%, as I’m pretty concerned that he misses time. You can the stats on the sheet to whatever you feel comfortable

  7. Mr. Blast says:
    (link)

    Ayo!

    This is seriously impressive! Atta boy fellas!

    Only now I’m a tad disappointed (of my own draft) because 1 of the teams I imported doesn’t measure up to any of the “9 Targets”.. team looks good on paper, but going off of this chart I fall just shy in just about every cat. Not by much, but still.

    Should this be a concern ? (Especially 3s & boards)

    TARGET 0.48 0.81 19.30 195.50 74.60 42.50 13.20 8.70 20.10
    0.45 0.75 12.00 179.00 61.80 38.80 11.50 7.80 23.10

    Example ^^^

    Thanks Raz Fam!

    • Son

      Son says:
      (link)

      @Mr. Blast: Ayo!!! Thanks! Remember that you are going H2H against just 1 other team. The benchmark numbers are the averages taken from every winner, so that number will likely always be higher. I’d divide your number by the benchmark number, which will give you a percentage. That will give you a better picture how close or far you are. Maybe I’ll insert that function into the sheet

      • Mr. Blast says:
        (link)

        @Son:

        Got you. Amazing stuff man. Thanks

        • Son

          Son says:
          (link)

          @Mr. Blast: Much appreciated and anytime!

  8. Hampton Kid

    Derek McKay says:
    (link)

    This is a great draft day tool. We have an auction draft so it is easy to lose track of which categories you have not covered when you are basking in the beauty of the fact that you think you just got a player for $3 less than what you predicted.

    Our league always the next day has trades when people realize they did not get enough blocks, steals or threes.

    • Son

      Son says:
      (link)

      Thanks Derek! Since your league has been running for quite some time, just plug in the data from your league history to tailor the benchmark numbers.

      Also, welcome to the Razzball community. The rest shall be knowing you soon enough. Derek aka Kid McKay. As Biggie said, https://www.youtube.com/watch?v=tDT-p1RRll0

  9. kalone says:
    (link)

    Any reason I can’t get the sortable stats table to download or copy this spreadsheet (the projections page is empty)? Are these for paying customers only? Happy to pay, just want to know what’s premium. Thanks, guys. Year after year the best fantasy content on the net.

  10. Bibby says:
    (link)

    Yeah have been having same trouble. Been using this sheet for few mock drafts and it has been so helpful!

    But now the projection page is empty.

    P.s. keep up this superb job, definitely my fav fantasy site!

    • Son

      Son says:
      (link)

      Thanks! Working on it now

  11. Son

    Son says:
    (link)

    @kalone: Thanks! Both are accessible to all. Working on fixing the issue now.

  12. kalone says:
    (link)

    @Son: Thanks, bud!

    • Son

      Son says:
      (link)

      No prob

Comments are closed.