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. 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 during your drafts.

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!

  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!

Leave a Reply

Your email address will not be published. Required fields are marked *