Categories
Posts
November 2018
M T W T F S S
« Dec    
 1234
567891011
12131415161718
19202122232425
2627282930  

Part IV: The Draft Planalyzer Draft List and Pick Depth Sheet

The one of the most useful tabs of the Workbook contains the filterable ‘Draft List’. The most useful part of the list is to filter by Slot, so you can not only get a projected look at what will be taken by a given pick in the draft in that slot, you can also look at what has been gone in the three historical drafts you loaded. In the upper left of the page, you’ll see column headings for Pick, Round and Slot, and you see little buttons with down arrows. Click on the Slot button and you’ll see options to select a particular slot, or you can get fancy and hit Custom to build your own criteria. You can also select All to bring everything back. What I like to do, if I know what pick I’m going to have in an upcoming draft, is go ahead and filter on that slot, then make note of the ‘Project Pick Depth’ at each position. Those values represent how many of each position have been taken until that pick, including that pick you’re on. So, for planning purposes, use those values to see where you start picking in a given position.

For example, say I’m interested in what’s expected to happen with the 6th slot in the 3rd round. I filter on that, and I see that by pick 30, round 3, from slot 6, there will typically be 5 QBs, 14 RBs, and 10 WRs off the board (keep in mind that these would include pick 30, but for planning purposes, you’ll be in the ball park).

I can also see what will happen between my picks. So I see that 10 WRs will be gone by round 3, and 15 by round 4. If I want who is projected to be WR 12, he probably won’t be there when it comes back to me. Or, since no TEs have been taken, but 2 will be gone by my next pick, I could go ahead and grab the best one now.

Another trick I like to use is if you want to not include the slot you’re looking at, and just want to know what typically is gone prior to your pick, just look at the slot before yours! So in my case, I can look at slot 5 and get an excellent idea of what will be gone when I pick. So in my previous example, with slot 6, I can switch it to slot 5 and see that.. ironically.. the same numbers show up! That’s because of rounding errors. But it can be a useful way to know what to expect at any point in the draft.

If you scroll over, you can also see what has happened historically at any given pick over your last three drafts.

The final sheet, the Pick Depths, shows when a given position goes at rank 1 – 64 (eg QB1, QB 24, QB 64, etc). You can filter on any column in the list, but the most useful for getting a handle on what to expect this year is the last column. I like to use ‘Custom’ and set the criteria to ‘does not equal’ and INC. INC is used when there isn’t a selection across all three years. You filter that out, and then you get a nice table of how many players will go at each position- and, even more valuable, exactly when to expect a given player to go, based on your weights entered in the Input page.

For example, first I filter out the INCs. Then, I’m left with a good table in which to do some research. Say I want to wait on QB until 6 are taken. Looking at QB 6, I see I can expect him to be gone by 3.8 (farthest most column to the right), and QB 7 will be gone by 4.4. I can also see how much this varies through the previous three drafts- QB 7 has gone as high as 3.7. So, I’ll want to keep that under consideration.

This listing is useful, too, when using tiers in your player rankings. Say there is a significant drop off after WR5 this year, so you can use this list to see when WR5 can be expected to be taken. You may also have the Draft Planalyzer open along side your draft management tool, so as your draft progresses you can track where the differences are and see where value may be developing.

2 Responses to “Part IV- Draft Tendencies”