#SFB7 Cheat Sheet Web Tool Primer

#SFB7 Cheat Sheet Web Tool Primer

With the Fourth of July in the rear view mirror, we are now in the final stages of draft preparation for the #SFB7. There are many sites providing graphs, charts, ADP, et al. and you are reading this because you’ve stumbled across an #SFB7 web tool I created to throw into the mix as well.

Origins. Before we get into its construction and use, let me provide some background on the web tool. The original concept and design was established last year during the #SFB480. While running over 20 mock drafts for #SFB480 in 2016, I felt the draft data needed to be put to further use than just providing average draft position for players. ADP is useful information that a drafter should be aware of during a draft, but it is limited to that player’s draft position. I am a proponent of having both player rankings and tiers when drafting and have found more often than not that you are able to find good value this way.

What is positional rank and how is it determined? This web tool is pulling from over 50 drafts with #SFB7 settings. Every draft pick is entered into a database with each pick being placed on a separate row. A row consists of an identifier for each mock draft (Mock Draft 1), overall pick (Pick #15), the draft pick (Pick 2.03), the draft slot the pick was chosen from (Slot 1.10), the player name (AJ Green), player NFL team abbreviation (CIN), player NFL position (WR), and the positional rank (WR06). In the written example provided, AJ Green was selected from the 10th slot in the second round with pick 2.03, the 15th overall pick, and was the sixth wide receiver to come off the board. Every draft is placed into the same database and this is how we are able to extract whatever information we need to create draft tools. In order to get a player’s ADP you would take the average draft pick for every player and then sort them from lowest (pick 1) to highest (pick 264). To get the ADP for positional rank you would take the average draft pick for every positional rank listed in the database and then sort from lowest to highest. This is one variation of generating ADP.

Using the web tool. In order to use the three components of the web tool we must first set up those components.

  • SELECT YOUR DRAFT SPOT IN THE SFB7. This is pretty straight-forward. You may type or select the draft spot from the drop-down menu. The web tool will be customized to the draft slot selected.
  • SELECT YOUR SOURCE FOR THE RANKINGS AND TIERS. The default setting for rankings is the #SFB7 mock draft ADP as displayed on TwoQBs. The tiers were preset based on positional rank scoring projections for 2017. The #SFB7 ADP rankings and tiers are not customizable, but an option is available for you to provide your own player rankings and tiers.

Not sure which ranking source you want to use? Go through this scenario for a better idea.

You’re drafting from the 9th slot (1.09) and are 100% set on having a top-5 QB & RB on your roster. Jay Ajayi is your RB05 but #SFB7 ADP shows him being drafted as the RB09 at 2.10.

It is now your pick at 1.09 and four RBs are off the board, coincidentally they are your top four as well, so Ajayi is the only top-5 RB remaining. In this scenario, only one QB has been taken.

If you decide to grab your top QB with the first pick and Ajayi in the second round, then I recommend using the #SFB7 ADP rankings source. You are more comfortable relying on ADP and assuming that your fellow drafters will draft similar to the ADP.

Select the Custom Rankings source if you would rather take Ajayi at 1.09, a full round earlier than his projected ADP, because he is the only top-5 RB option remaining and you’re fine taking the best option remaining at QB in the 2nd round.

So how do I create my own personal rankings?

  • ‘RANKINGS’ TAB. Find and click on the ‘Rankings’ tab on the bottom of the workbook and you will be able to input your own player rankings and adjust the tiers.
  • PLAYER RANKING BY POSITION. You will find each position broken up into three columns: Positional Rank, Player Name, and Tier Break. In this area, you will enter your player rankings by position into the center column.
  • TIER BREAKS. There is no rule for how to customize your tiers. However, this web tool currently limits the number of tiers to ten. Tiers are defined by positional rank in the box to the right of the player rankings. If your first tier of QBs is two players deep then you would insert “QB02” in the QB column. You would do the same for the other positions at each tier break. You can use all ten tiers or you could choose to use fewer. Maybe you believe that the tier one quarterbacks and running backs have a greater value than any of the wide receivers or tight ends; in that case, one option would be to not include any WR or TE in tier one.
  • MULTIPLE CUSTOMIZED RANKINGS. The web tool is designed to allow up to six customizable ranking and tiers. This number can be increased by request but has been limited for online use. Maybe you don’t feel comfortable enough, or don’t have the time, to create your own rankings and tiers — that’s fine, enter up to six rankings from your favorite fantasy football sources. Instructions on how to create multiple custom ranking tabs is included on the ‘Rankings’ Tab’.

Time to use the Web Tool. Now that you’ve preset the data input for the web tool you can dive into the data provided in each of the charts. A brief description of each chart is provided towards the bottom of the web tool. Select a chart title and a blurb will appear. The explanations were kept short due to space limits but let’s go ahead and take a closer look at each chart.

  • Best Availability By Round. The first chart on the left is probably the easiest of the three to decipher. The concept is simple: Provide the best option available at each position in for each round. The data can be presented in three different view options — Positional Rank, Player, Tier Break.
  • POSITIONAL RANK. This is the default setting and the original concept for the web tool’s development. In this view option, the user can see, on average, the best available position rank at each position.
  • PLAYER RANK. This is where the inclusion of personal player rankings is most valuable. If your source is #SFB7 ADP then you will see who is available on average to target in each round. Even though player names appear in the chart, the data is still sorted by positional rank with the player names inserted as they are appear on the rankings source. If your source is Custom Ranking, players will appear by positional rank as laid out in your rankings.
  • TIERED RANK. The tier viewing option is similar to the first two in that you will be able to have a general overview of what values are available on average in a given round. Generally, tiers group players by a common thread, such as fantasy production, You can also place a certain number of players at a position into each tier — 1 to 5 in tier 1, 6 to 10 in tier 2, etc. Another option is to use each tier break for a single round. Essentially, you could plan 10 rounds of picks at a time, placing only players you would draft in that round into that tier.
  • Positional Runs By Round. One thing that I continue to hear from the community is the fear of being at the tail end of a run and missing out on a whole tier or two of players at a position. With this tool, the goal is to provide a better understanding of when a run at certain positions may occur. The chart lists the average number of players taken between rounds.

Not all runs are created equal; what do you consider a run? Last year, I considered a run to be five or more players taken at a position between a drafter’s picks. I realized the value of five players can differ depending on how many players will be drafted between rounds. A “run of “five” would not be relevant to a person drafting at 1.10 if there are only four players taken before he picks again at 2.03; however, that same “run of five” could be helpful since there would be 18 picks made before his next pick at 3.10. Hence, the decision was made to allow users to define a run. This is also why users drafting on the turns will only have data populate every other round. Position scarcity should also be considered when evaluating runs. Because there are half the number of QB and TE drafted than RB and WR, a run of five TE in the third and fourth rounds will be a lot more detrimental than a five-WR run in the same rounds.

  • Last Chance Value By Round. This chart will help identify a targets “Last Chance Value” or the last round, on average, that a specific positional rank, player, or tier group should be selected. Like the ‘Best Availability By Round’ chart, there are three different view options but each option is already separated. The top option is the default and gives the Last Chance Value for different cutoffs for each position, such as “Top-5”, Top-12”, etc.
  • POSITIONAL RANK. If the first view option is not specific enough then the positional rank view may be a better option as you are able to enter a specific positional rank’s Last Chance Value.
  • Disclaimer: The players listed in this view are only representing the positional ranks based on the player rankings source and is not currently tied to the player’s ADP value. I hope to implement this if my schedule allows.
  • TIERED. The Last Chance Value displayed for this chart differ in meaning depending on your ranking source and how the tiers are set up. As is the case for most of the data presented in this web tool, the values are based on the positional rank for each tier group.

Contributions & #SFB7 T-Shirt Sweepstakes. This web tool is currently available for public use at no cost. I will continue to update until the start of the #SFB7 draft. I hope to find time to include live #SFB draft results as well.

  • If you choose to download this web tool rather than use it online, please consider contributing a small donation. Additionally, if you choose to only use the web tool online and would still like to contribute a donation, it would be very much appreciated.
  • Everyone giving a donation will receive a notification when the web tool has been updated. This monetary gift would provide me the means necessary to free up time to maintain the web tool through the completion of the #SFB7 draft.
  • If you can’t give or don’t want to give, that is totally fine — it is a FREE web tool afterall — all I’d ask is that you send a tweet promoting either this web tool or #FantasyCares.
  • As a THANK YOU, everyone who gives a donation of any amount will be entered into a SWEEPSTAKES where one person will win a #SFB7 T-SHIRT (so long as the funds received can cover the cost of the t-shirt).
  • All t-shirt proceeds will help fund #FantasyCares.
  • Please include your name & twitter handle/email in the payment comments so I know who to enter in the giveaway. Entries into the sweepstakes end on July 15, 2017.

Have another idea of how to project the data? The goal of this web tool was to provide flexibility to allow users many different options of how to view data and plan for their draft. If you come up with an idea that doesn’t seem to fit within the constraints of the web tool, PLEASE contact me and I’ll see if I can facilitate the request. Certain aspects of the web tool can be customized by request. One example would be to increase the number of tier breaks.

TwoQBs Guest

At TwoQBs.com, we strive to share the quality work of writers from across the fantasy football industry who are not a part of the TwoQBs staff. From time-to-time we will share 2QB/Superflex posts from guest writers in this space. If you have an idea for a guest post you can pitch it to us via email at TwoQBs@gmail.com


Leave a Reply

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