AVT/VBD Spreadsheet Drafting Tool

[mattb47]

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

[BGbootha]

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

[eagles21]

Awesome, thanks for putting it together man. I'm sure this will help a lot of people.

[mrblitz]

Should be a very reliable tool, in disecting my own forumlas. Thanks alot.

[bige47]

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.

[mattb47]

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.

[Kilroy]

From first glance looks very cool. Thanks Much Matt!

[killiansjmd]

Great tool Matt. Thanks for sharing it!

[Stelly]

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!

[mattb47]

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.