Introducing MockoSheet 2024: A Data Driven Draft Aid And Strategy Guide

#MockoSheet 2024

It’s officially draft season and I finally wanted to share my draft tool publicly with you all.

I'm a scientist that really loves fantasy football and have started using it as an excuse to get better at coding, sheets, and data organization skills. Last year, I was inspired by all of the great FF tool makers (Beersheets, BorisChen, FantasyFootballAnalytics, FantasyCalc, JuiceboxOne, too many to name) and wanted to make my own with the goal of creating the most accurate projections possible and having all the data to work with for various other projects. I wanted to develop and share a data-and-evidence based approach to fantasy football to help people (including myself) get better at the game.

After a lot of work and small scale deployment on the Fantasy Football Chat discord–they get a lot of charts from me–I am happy to introduce MockoSheet!

https://imgur.com/a/p72ZqRW

##What is MockoSheet and what does this do differently?

Mocko is built to allow for custom draft sheets for nearly all formats. Projections are sourced, weighted based on last year’s accuracy, and scaled from 14 separate sources. As last year was the first year I put together the sheet, the weights will get progressively better over time. Last year, Mocko outperformed every individual site's projections that were used in the pooled projections bar one (Numberfire did great last year). Anecdotally, I’ve gotten really great feedback from some of the users from last year who were able to draft with it.

If you’ve used Beersheets or any similar sheet, Mocko will be very familiar. In Snake Drafts, key information shown includes Pos Rank, Pos Tier, OVR Tier, ADP, VAL, and VAP-ADP (pick at which a player becomes worth it). Auction draft sheets are currently getting an update to provide as much of a numbers advantage as possible in any given draft.

Because Mocko contains relatively strong projections, I’ve used it to create a handful of other things including a fun draft review tool for Sleeper drafts. I’ll be sharing that as well once I’ve finished all of the auction draft improvements so people can see what strategies give a bigger number advantage.

#Here are the links to check out some example sheets you can copy for HPPR and PPR leagues (Snake Leagues (1QB/2RB/2WR/1TE/2FLEX - includes 4pt Pass and 6pt Pass TDs): HPPR: https://docs.google.com/spreadsheets/d/1va3fQTKJynKCJvzPmQ-AkBaweswAZEOVd3uzgecCFZs/edit?usp=sharing

PPR: https://docs.google.com/spreadsheets/d/1SthIg7qMKTFzxNJXFUdH_NnTLFED1SuxB4gQhemZ1tI/edit?usp=sharing

If you want a specific sheet for your format: post it in the comments or DM @mosers15 on Discord for a MockoSheet request. Auction and IDP will be available after this weekend (Aug 3/4th).

##Quality Data is Key and Strategy is League, Scoring, AND Pick Specific

• Projections are better than rankings and can be customized to your league settings.
• Sites vary in consistency, so don't rely solely on one site's rankings unless they use multiple sources (e.g., FantasyPros).
• Using multiple sources for projections and ADP (Average Draft Position) is better than relying on a single ranking source.
• Understand that projections will only ever be so good. Mocko was 70-80% accurate when taking into account “qualified” players.
• While rankings and tiers help you evaluate player-to-player worth, it’s important to know how your specific draft might play out and capitalize on the market (ADP/AAV).
• Be flexible with your strategy and have contingency plans.
• Drafts are only 10-20% of any given season. You can't win the league from the draft alone but you can definitely set yourself to succeed more.

I hope this all helps you do better in your leagues. I know it’s helped me and the 30+ people that used it last year on Discord. I’ll be doing a series on draft permutation science using Mocko data which might be able to help you figure out what are theoretically the best strategies you can do at any given pick slot in a normal HPPR league (1QB/2RB/2WR/1TE/2FLEX).

If you have any suggestions or questions, please let me know as well!

Contact me at @mosers15 on Discord or find me on the Fantasy Football Chat Server: https://discord.com/invite/fantasyfootball or Auction Draft Server: https://discord.com/invite/VgctstrA if you want to go into a deeper dive on some preseason draft data.