What's new
Fantasy Football - Footballguys Forums

This is a sample guest message. Register a free account today to become a member! Once signed in, you'll be able to participate on this site by adding your own topics and posts, as well as connect with other members through your own private inbox!

VBD Top 60 with custom ADP adjustments (1 Viewer)

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.

 
Last edited by a moderator:
Rats... it worked for a few people earlier.

Thanks. Okay I uploaded this to another site (if you know of a reliable hosting site, please post)

This site:

http://s1.quicksharing.com/v/78730/07app_B1hotrod.xls.html

created a link to the file here:

http://s1.quicksharing.com/d/78730/1180407...pp_B1hotrod.xls

I think the second link will start the download, but if not, you may need to wait a second for the link to load on the first page. The link appears in the top left corner.

Thanks for the note. Let me know if this comes through okay.

 
Last edited by a moderator:
Thanks for being patient.

I just got the above link to work again, but I'm trying one more file host for this. There's a gray bar at the bottom of the page under the ad bar that offers the download here as well:

http://d01.megashares.com/?d01=a518c14

Post if this comes through okay, I'm getting spotty feedback about the other links.

I am taking nominations if anyone knows a good resource to get this file up and stable.

 
BigTex. Thanks for trying again... I just downloaded from that last link after your post. Are you not getting the download at all, or is it not opening? I downloaded and ran it just fine from here.

 
BigTex. Thanks for trying again... I just downloaded from that last link after your post. Are you not getting the download at all, or is it not opening? I downloaded and ran it just fine from here.
No download at all, I see the file name but that's it. There's no download link.
 
BigTex. Thanks for trying again... I just downloaded from that last link after your post. Are you not getting the download at all, or is it not opening? I downloaded and ran it just fine from here.
No download at all, I see the file name but that's it. There's no download link.
There's a blue/gray banner under the ad bar below the file name. Try scrolling down if your browser window doesn't accommodate it at first glance. It says "Click Here to Download"EDIT: yeah, I just got a copy off of:

http://s1.quicksharing.com/v/78730/07app_B1hotrod.xls

and another off of

http://d01.megashares.com/?d01=a518c14

try either of those. The first one has a link in the top left corner of the website's main body, the second one has a bar that you click if you scroll down an inch or so.

 
Last edited by a moderator:
kind of confusing but pretty cool. definitely very useful, but a lot to take in at first. question/comment or two:

on the VBD Adjusted Top 60 side, for the two columns that say Adj Draft #s (between the player columns), the first column is adp, and the second vbd, correct?

when you change a percentage of influence, the other doesn't change to correspond. for instance, if i have it set at50/50 and i change vbd to 60, adp doesn't automatically move to 40. is there a way to fix that?

I set ADP to 65 and VBD to 35. Alexander says -1.05. What does that mean? I would assume it means with those values take him 1.35 spots lower than his ADP, but he's still slotted in spot number 5. ??

Pretty much everyone else has moved up/down according to the number next to their name, but Alexander hasn't. Is it just a glitch, or does that mean something?

 
Last edited by a moderator:
kind of confusing but pretty cool. definitely very useful, but a lot to take in at first. question/comment or two:on the VBD Adjusted Top 60 side, for the two columns that say Adj Draft #s (between the player columns), the first column is adp, and the second vbd, correct?when you change a percentage of influence, the other doesn't change to correspond. for instance, if i have it set at50/50 and i change vbd to 60, adp doesn't automatically move to 40. is there a way to fix that?I set ADP to 65 and VBD to 35. Alexander says -1.05. What does that mean? I would assume it means with those values take him 1.35 spots lower than his ADP, but he's still slotted in spot number 5. ??Pretty much everyone else has moved up/down according to the number next to their name, but Alexander hasn't. Is it just a glitch, or does that mean something?
Next to Adjusted Influence...I set it up so that you only need to adjust the ADP. if you changed the VBD, it erased the formula that makes these numbers influence each other, and you'll need to either change both (or put the formula =1-J2 in the ADP box or =1-J1 in the ADP box)Under VBD Adjusted Top 60...The yellow column on the left is the ADP (before), the green column on the right factors in your percentage of VBD to move their rank. 100% VBD will return the same list as the cheat sheet, anything in between will return a hybrid that migrates the players toward their VBD. The next column after the yellow ADP is the adjusted difference, which is how the VBD will affect these positions, weighted as you specified (65% ADP/35% VBD). So Alexander at -1.05 means that when you move his value 35% from his ADP toward his VBD, he moves 1.05 picks down your list. To the right of the red (overvalued) and green (undervalued) numbers is their new value.The first column on the green side is actually assigned to the adjusted VBD list, not to the names on the ADP list. It's there because sometimes these adjustments result in a tie, so if you have two players moving to #7, the tie-breaker is VBD, shown as a decimal. The first player may have an adjusted draft value of 7.06, (seventh pick, #6 VBD) and the second player 7.13 (seventh pick, #13 VBD). These are fixed with the draft order shown after the green names, as #7 and #8, though they are actually tied for #7, as indicated in the column to the right of the green names.Shawn Alexander's position may not change, if the players ahead of him pass him down the list, bumping him up. Addai's value also falls, so he may leave enough room for Alexander to maintain his position. That is to say, while Alexander isn't as good as billed, Nobody else's value moves him into that spot. Great questions, thanks. Let me know if you have anymore.
 
PainTrain said:
TheLastDispatch said:
kind of confusing but pretty cool. definitely very useful, but a lot to take in at first. question/comment or two:on the VBD Adjusted Top 60 side, for the two columns that say Adj Draft #s (between the player columns), the first column is adp, and the second vbd, correct?when you change a percentage of influence, the other doesn't change to correspond. for instance, if i have it set at50/50 and i change vbd to 60, adp doesn't automatically move to 40. is there a way to fix that?I set ADP to 65 and VBD to 35. Alexander says -1.05. What does that mean? I would assume it means with those values take him 1.35 spots lower than his ADP, but he's still slotted in spot number 5. ??Pretty much everyone else has moved up/down according to the number next to their name, but Alexander hasn't. Is it just a glitch, or does that mean something?
Next to Adjusted Influence...I set it up so that you only need to adjust the ADP. if you changed the VBD, it erased the formula that makes these numbers influence each other, and you'll need to either change both (or put the formula =1-J2 in the ADP box or =1-J1 in the ADP box)Under VBD Adjusted Top 60...The yellow column on the left is the ADP (before), the green column on the right factors in your percentage of VBD to move their rank. 100% VBD will return the same list as the cheat sheet, anything in between will return a hybrid that migrates the players toward their VBD. The next column after the yellow ADP is the adjusted difference, which is how the VBD will affect these positions, weighted as you specified (65% ADP/35% VBD). So Alexander at -1.05 means that when you move his value 35% from his ADP toward his VBD, he moves 1.05 picks down your list. To the right of the red (overvalued) and green (undervalued) numbers is their new value.The first column on the green side is actually assigned to the adjusted VBD list, not to the names on the ADP list. It's there because sometimes these adjustments result in a tie, so if you have two players moving to #7, the tie-breaker is VBD, shown as a decimal. The first player may have an adjusted draft value of 7.06, (seventh pick, #6 VBD) and the second player 7.13 (seventh pick, #13 VBD). These are fixed with the draft order shown after the green names, as #7 and #8, though they are actually tied for #7, as indicated in the column to the right of the green names.Shawn Alexander's position may not change, if the players ahead of him pass him down the list, bumping him up. Addai's value also falls, so he may leave enough room for Alexander to maintain his position. That is to say, while Alexander isn't as good as billed, Nobody else's value moves him into that spot. Great questions, thanks. Let me know if you have anymore.
:banned: Thanks. Great work on this.
 
Thanks. If other people find this useful, I may provide a file later that allows people to modify their sheets with something like this or lobby FBG to incorporate the concept. Unfortunately, I won't be able to post modifications to future versions, since people will need to pay for the info provided by FBG and I wouldn't want to give away their product.

I tried to contain all the info on the new sheet in such a way that it can be cut-and-pasted onto a new sheet, and ADP imported, but I know for sure that some modifications will have to be made from the ADP info if anyone wants to try it. If I can make one request to the guys that produce the ADP page, I would like to ask that they make the names of players consistent with the VBD tool if ever they get to revising it. There are some names that aren't the same (Ladanian/LaDanian, Winslow/Winslow Jr., Barber/Barber III, Carnell/Cadilac etc.), and defenses ending in DST or not. If the same names were used, the info could be seamlessly imported and accessed without altering either list. Also, on the ADP, Position ranks (like RB1) actually have a space after them, whereas on VBD they do not. These don't make a difference when the tools are used independently, but when the lists are used together, they make the subjects being compared as different as night and day. I know... that request needs to go to the tools section, but I wanted to give a heads up to anyone that wants to use this on future versions, since I won't post them.

Thanks to towsonnc for the yousendit tip. This link should also work to download (for 7 days):

http://download.yousendit.com/F039193A25BE44D1

I'm considering submitting a freelance article this year on how to customize the VBD tool if people would find it useful. Any other modification ideas would be appreciated. In years past, I've created graphs of player values, to show where the value plateaus, but it's just a different visual representation of the info already provided. Let me know if you can think of a way to get more out of the numbers that are provided. Perhaps there's a way to calculate a tier system breakdown. I'd love to see a debate about how those cutoff points are defined (mathematically).

 

Users who are viewing this thread

Back
Top