PainTrain
Footballguy
Hey everyone. I'm so psyched that the new VBD is out, thanks footballguys! It's like the season is starting already.
I hope it's okay to post this here, I'll post on the tools questions section too, but I don't actually have any questions, so I thought I'd throw this to the sharks. VBD and ADP go hand-in-hand, but I haven't seen a tool that melds them together, so I built this one.
HERE'S THE DEAL...
I tweaked the new VBD spreadsheet to include some features that I've always thought would be useful and posted it so that you can download it. Let me know what you think.
http://download2-5.files-upload.com/2007-05/29/03/07app_B1hotrod.xls
ADP meets VBD
---
EDIT: I've uploaded this to a couple more servers, if the link above doesn't work:
http://s1.quicksharing.com/v/78730/07app_B1hotrod.xls.html
http://s1.quicksharing.com/d/78730/1180407...pp_B1hotrod.xls
(link in the top-left of the website body)
http://d01.megashares.com/?d01=a518c14
(may have to scroll to to the blue/gray bar under the ads)
---
So you can download it now from the link above, or read on if you have the patience for an explanation. The short version of what's left to say is this: if you change the yellow box on top of the ADP sheet, you'll enable a dynamic list that moves the player's rank from their VBD toward their ADP, by the percentage of the difference that you desire.
Wow, awesome, you're still with me.
Okay, what I've done to the file that was posted on footballguys.com is added a sheet that incorporates ADP with the top 60 VBD projections that the spreadsheet generates. Trust me, it's cooler than either report by itself... there's a yellow box on top of the ADP tab that I added, which allows you to adjust how much influence the ADP will have on the VBD cheat sheet. If you set the yellow box to 100% ADP, there will be no adjustments, and you'll get the straight ADP, and if you set it to zero, you'll get the VBD. However, if you set the ADP influence to 50% (for example), it will shuffle the draft positions to exactly half way between the VBD and ADP positions. So if a player is #8 VBD and #16 ADP, setting the ADP influence to 50% will move that players rank to #12. At 25% or 75%, it will move the player to #10 or #14, depending on which way you want to lean.
The reason I did this is because VBD isn't designed to be a cheat sheet for you to run down top to bottom on your draft, but instead it illustrates the value of the top 60 players. This adaptation not only takes into account their value based on FBG recommendations, but also hedges them toward where players usually go, as much or as little as you'd like. If a player is grossly undervalued, this allows you to better estimate your gamble as to how long to wait to draft him, or conversely, it can estimate how far above FBG value you want to reach to get a player on your roster.
A couple more notes...
At a glance, you can quickly see how differently ADP and VBD value a player, by looking at the net difference between the two rankings, without doing any adjusting anything.
Defenses are not working properly. Posted ADP and VBD lists have some discrepancies in how they name players and defenses, and it takes a little more editing to make them compatible. I could fix with more time, but because defense plays such a small role in these early rounds, I didn't bother.
Also, when you monkey with the percentages of influence from each list, it's not uncommon for a player to move to the exact (combined) draft position when bringing these lists together. When this happens (Alexander and Addai, for example), a decimal place will indicate the VBD after the draft number as a tie-breaker. 6.08 would mean, #6 combined, #8 VBD, so 6.08 would be better than 6.10 if you trust the FBG wizards.
Try it out, and it'll work fine if you plug in your league's info too. Let me know if you catch any significant bugs.
Here's the link again:
http://download2-5.files-upload.com/2007-05/29/03/07app_B1hotrod.xls
ADP meets VBD
Thanks and good luck. I look forward to your feedback.
I hope it's okay to post this here, I'll post on the tools questions section too, but I don't actually have any questions, so I thought I'd throw this to the sharks. VBD and ADP go hand-in-hand, but I haven't seen a tool that melds them together, so I built this one.
HERE'S THE DEAL...
I tweaked the new VBD spreadsheet to include some features that I've always thought would be useful and posted it so that you can download it. Let me know what you think.
http://download2-5.files-upload.com/2007-05/29/03/07app_B1hotrod.xls
ADP meets VBD
---
EDIT: I've uploaded this to a couple more servers, if the link above doesn't work:
http://s1.quicksharing.com/v/78730/07app_B1hotrod.xls.html
http://s1.quicksharing.com/d/78730/1180407...pp_B1hotrod.xls
(link in the top-left of the website body)
http://d01.megashares.com/?d01=a518c14
(may have to scroll to to the blue/gray bar under the ads)
---
So you can download it now from the link above, or read on if you have the patience for an explanation. The short version of what's left to say is this: if you change the yellow box on top of the ADP sheet, you'll enable a dynamic list that moves the player's rank from their VBD toward their ADP, by the percentage of the difference that you desire.
Wow, awesome, you're still with me.
Okay, what I've done to the file that was posted on footballguys.com is added a sheet that incorporates ADP with the top 60 VBD projections that the spreadsheet generates. Trust me, it's cooler than either report by itself... there's a yellow box on top of the ADP tab that I added, which allows you to adjust how much influence the ADP will have on the VBD cheat sheet. If you set the yellow box to 100% ADP, there will be no adjustments, and you'll get the straight ADP, and if you set it to zero, you'll get the VBD. However, if you set the ADP influence to 50% (for example), it will shuffle the draft positions to exactly half way between the VBD and ADP positions. So if a player is #8 VBD and #16 ADP, setting the ADP influence to 50% will move that players rank to #12. At 25% or 75%, it will move the player to #10 or #14, depending on which way you want to lean.
The reason I did this is because VBD isn't designed to be a cheat sheet for you to run down top to bottom on your draft, but instead it illustrates the value of the top 60 players. This adaptation not only takes into account their value based on FBG recommendations, but also hedges them toward where players usually go, as much or as little as you'd like. If a player is grossly undervalued, this allows you to better estimate your gamble as to how long to wait to draft him, or conversely, it can estimate how far above FBG value you want to reach to get a player on your roster.
A couple more notes...
At a glance, you can quickly see how differently ADP and VBD value a player, by looking at the net difference between the two rankings, without doing any adjusting anything.
Defenses are not working properly. Posted ADP and VBD lists have some discrepancies in how they name players and defenses, and it takes a little more editing to make them compatible. I could fix with more time, but because defense plays such a small role in these early rounds, I didn't bother.
Also, when you monkey with the percentages of influence from each list, it's not uncommon for a player to move to the exact (combined) draft position when bringing these lists together. When this happens (Alexander and Addai, for example), a decimal place will indicate the VBD after the draft number as a tie-breaker. 6.08 would mean, #6 combined, #8 VBD, so 6.08 would be better than 6.10 if you trust the FBG wizards.
Try it out, and it'll work fine if you plug in your league's info too. Let me know if you catch any significant bugs.
Here's the link again:
http://download2-5.files-upload.com/2007-05/29/03/07app_B1hotrod.xls
ADP meets VBD
Thanks and good luck. I look forward to your feedback.
Last edited by a moderator: