AVT/VBD Spreadsheet Drafting Tool - Fantasy Football Cafe 2014 Fantasy Football Cafe


Return to Football Talk

AVT/VBD Spreadsheet Drafting Tool

Moderator: Football Moderators

AVT/VBD Spreadsheet Drafting Tool

Postby mattb47 » Tue May 29, 2007 2:02 pm

Hey guys, some of you know (but most of you don't) that I developed a spreadsheet last off season that encorporates two well used stastical approaches for drafting in fantasy football. I was never able to quite get all the time into it that I had wanted to last season but I was able to update it to this season and finish it. This sheet uses both Average Value Theory (AVT) and Value Based Drafting (VBD) and gives a short explanation of how both are used.

For a quick overview on AVT and VBD you can look at this article if you'd like:

http://www.fantasyfootballcafe.com/2006 ... tegies.php

This sheet is customizeable to be used with your specific league settings including the league size, starting requirements, and scoring system. If you find anything that needs to be changed or updated then please let me know and I can work on that for you. Here you go and enjoy!

http://www.savefile.com/files/763139
Image
mattb47
Hall of Fame Hero
Hall of Fame Hero

User avatar
Fantasy ExpertCafe WriterCafe RankerMock(ing) DrafterEagle EyeCafe MusketeerCafe Blackjack Weekly Winner
Posts: 14238
Joined: 29 Nov 2004
Home Cafe: Football

Postby BGbootha » Tue May 29, 2007 2:05 pm

Sweet thanks, I haven't looked at it yet, giong to go through it during my plan
Image
BGbootha
General Manager
General Manager

User avatar
Cafe WriterCafe RankerGraphics ExpertMock(ing) DrafterEagle EyeCafe Blackjack Weekly Winner
Posts: 3830
Joined: 18 Feb 2003
Home Cafe: Football
Location: Teaching is the Greatest Job in the World!!! (during the Summer)

Postby eagles21 » Tue May 29, 2007 3:18 pm

Awesome, thanks for putting it together man. I'm sure this will help a lot of people. ;-D
Image
eagles21
General Manager
General Manager

User avatar
CafeholicCafe RankerGraphics ExpertMock(ing) DrafterEagle EyeCafe Blackjack Weekly Winner
Posts: 4613
Joined: 7 Jun 2006
Home Cafe: Football
Location: State College, PA

Postby mrblitz » Tue May 29, 2007 3:36 pm

Should be a very reliable tool, in disecting my own forumlas. Thanks alot. ;-D
Image


Call em as I see em!
mrblitz
Hall of Fame Hero
Hall of Fame Hero

User avatar
Cafe RankerMock(ing) DrafterEagle Eye
Posts: 12770
Joined: 16 Jul 2006
Home Cafe: Football
Location: Having a coffee at the fantasy cafe.

Postby bige47 » Tue May 29, 2007 7:43 pm

I am not able to download this file from that site. I click the download link and it just sends me right back to that page. PLease help.
bige47
Defensive Assistant
Defensive Assistant

Matchup Meltdown SurvivorCafe Blackjack Weekly Winner
Posts: 481
Joined: 3 Sep 2005
Home Cafe: Football
Location: Philadelphia

Postby mattb47 » Wed May 30, 2007 2:26 pm

bige47 wrote:I am not able to download this file from that site. I click the download link and it just sends me right back to that page. PLease help.


PM me your email and I would be happy to email it to you if you'd like.
Image
mattb47
Hall of Fame Hero
Hall of Fame Hero

User avatar
Fantasy ExpertCafe WriterCafe RankerMock(ing) DrafterEagle EyeCafe MusketeerCafe Blackjack Weekly Winner
Posts: 14238
Joined: 29 Nov 2004
Home Cafe: Football

Postby Kilroy » Thu May 31, 2007 2:14 am

From first glance looks very cool. Thanks Much Matt! ;-D
Image

"I disapprove of what you say, but I will defend to the death your right to say it." -- Voltaire
Kilroy
Hall of Fame Hero
Hall of Fame Hero

User avatar
Fantasy ExpertCafe WriterCafe RankerGraphics ExpertMock(ing) DrafterEagle EyeCafe Musketeer
Posts: 13587
Joined: 6 Oct 2004
Home Cafe: Football
Location: Making My List and Checking It Twice...

Postby killiansjmd » Thu May 31, 2007 9:23 am

Great tool Matt. Thanks for sharing it! ;-D
Image
Thanks to Metroid for the sig!
killiansjmd
Hall of Fame Hero
Hall of Fame Hero

User avatar
Fantasy ExpertCafe RankerMock(ing) DrafterPick 3 Weekly WinnerCafe Blackjack Weekly Winner
Posts: 7929
Joined: 3 Aug 2004
Home Cafe: Football
Location: J-E-T-S, JETS, JETS, JETS

Postby Stelly » Thu May 31, 2007 12:28 pm

Great tool, Matt, thanks!

When I opened the download it said that the macros did not match the digital signature, and that only a virus could cause this. I was able to open it without macros, but just wanted to let you know.

Thanks for sharing your hard work with everyone, it is appreciated!
10-Team, non-PPR

QB:
RB: R. Rice, CJ Spiller
WR: AJ Green
K:
Def:
Stelly
Head Coach
Head Coach

User avatar
Mock(ing) Drafter
Posts: 1271
(Past Year: 1)
Joined: 15 Dec 2005
Home Cafe: Football
Location: Pittsburgh, PA

Postby mattb47 » Thu May 31, 2007 12:57 pm

Stelly wrote:Great tool, Matt, thanks!

When I opened the download it said that the macros did not match the digital signature, and that only a virus could cause this. I was able to open it without macros, but just wanted to let you know.

Thanks for sharing your hard work with everyone, it is appreciated!


Yea, the problems have come in because I've been unable to use a more current version of excel. The one I'm using now is very old and it's causing some problems....if anyone has a solution to any of the problems it is causing that would be a big help to me.

It's still possible to sort the sheets manually and while I didn't want it to be that way, it still works in the end.
Image
mattb47
Hall of Fame Hero
Hall of Fame Hero

User avatar
Fantasy ExpertCafe WriterCafe RankerMock(ing) DrafterEagle EyeCafe MusketeerCafe Blackjack Weekly Winner
Posts: 14238
Joined: 29 Nov 2004
Home Cafe: Football

Next

Return to Football Talk

Who is online

Users browsing this forum: No registered users and 5 guests

Forums Articles & Tips Start & Sit Sleepers Rankings Leagues


Get Ready...
The 2014 NFL season kicks off in 2:17 hours
(and 38 days)
2014 NFL Schedule


  • Fantasy Football
  • Article Submissions
  • Privacy Statement
  • Site Survey 
  • Contact