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


Return to Football Talk

AVT/VBD Spreadsheet Drafting Tool

Moderator: Football Moderators

Postby Stelly » Fri Jun 01, 2007 10:32 am

mattb47 wrote:
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.


Of course, had I read through ALL the directions, I would have known this.

Great work, and again, thanks for sharing with everyone! This will be very hepful!

;-D
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

Re: AVT/VBD Spreadsheet Drafting Tool

Postby mattb47 » Fri Jun 08, 2007 6:16 pm

I'm currently working on adding in the ability to calculate auction values for those who would like a very statistically based approach to those drafts. I'll repost here when I an able to finish.
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

Re: AVT/VBD Spreadsheet Drafting Tool

Postby smackthefirst » Sat Jun 09, 2007 11:31 am

Sorry I didn't see this thread earlier matt, but I think I can help everyone out with the macro problem. If anyone is still dealing with it, let me know what version of excel you are running. I'm assuming it's 2007 for those that are having the problem. If it is 2007, go to your security settings by clicking tools - macro - security. Then click the trusted publishers tab and click the check box for trust all installed add ins and templates. That should allow it to work. But, make sure you change this back if you download random excel files you are not sure about.
Image
My Playoff Team - Please Comment
MSchaub, DMcNabb, JFreeman, KKolb
SJackson, THightower, CWells, JForsett, JSnelling, CJennings, QGanther
RWayne, RMoss, RMeachem, MCrabtree, DBowe
VDavis
smackthefirst
General Manager
General Manager

User avatar
Graphics ExpertEagle EyeMatchup Meltdown Survivor
Posts: 2646
Joined: 16 Oct 2003
Home Cafe: Football
Location: MD

Re: AVT/VBD Spreadsheet Drafting Tool

Postby FantasyMan13 » Thu Jun 14, 2007 1:20 pm

If anyone could type in a 3 year AVT for D/ST only with the scoring categories at the bottom of this post and post the top 24 averages, I would really appreciate it as I do not have Excel.


Interception (2)
Fumble Recovery (2)
Touchdown (6)
Safety (5)
Block Kick (4)
Kickoff and Punt Return Touchdowns (6)
Points Allowed 0 points (10)
Points Allowed 1-6 points (7)
Points Allowed 7-13 points (4)
Points Allowed 14-20 points (1)
Points Allowed 21-27 points (0)
Points Allowed 28-34 points (0)
Points Allowed 35+ points (-1)
FantasyMan13
General Manager
General Manager

User avatar
Cafe RankerMock(ing) DrafterEagle EyePick 3 Weekly WinnerCafe Blackjack Weekly WinnerLucky Ladders Weekly Winner
Posts: 4171
(Past Year: 40)
Joined: 10 Apr 2006
Home Cafe: Football

Re: AVT/VBD Spreadsheet Drafting Tool

Postby mattb47 » Thu Jun 14, 2007 1:44 pm

DST # 1 - 217.00
DST # 2 - 178.00
DST # 3 - 157.33
DST # 4 - 154.00
DST # 5 - 148.67
DST # 6 - 144.67
DST # 7 - 140.00
DST # 8 - 138.00
DST # 9 - 134.67
DST # 10 - 134.33
DST # 11 - 130.00
DST # 12 - 128.67
DST # 13 - 126.00
DST # 14 - 125.33
DST # 15 - 120.33
DST # 16 - 119.00
DST # 17 - 117.00
DST # 18 - 116.00
DST # 19 - 115.00
DST # 20 - 114.67
DST # 21 - 111.33
DST # 22 - 110.33
DST # 23 - 107.33
DST # 24 - 106.67
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

Previous

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 11:14 hours
(and 35 days)
2014 NFL Schedule


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