Excel Spreadsheets? - Fantasy Football Cafe 2014 Fantasy Football Cafe


Return to Football Talk

Excel Spreadsheets?

Moderator: Football Moderators

Postby Mercer Boy » Wed Aug 03, 2005 8:38 pm

This is so going in the FFFAQ. Great work Amazinz. ;-D
The One, the Only, the Incomparable Mercer Boy.
My My YouTube.
Mercer Boy
Mod in Retirement
Mod in Retirement

User avatar
Fantasy ExpertCafe WriterCafe RankerMock(ing) DrafterEagle EyeCafe MusketeerWeb SupporterLucky Ladders ChampionPick 3 Weekly WinnerSweet 16 SurvivorCafe Blackjack Weekly Winner
Posts: 12045
Joined: 22 Oct 2003
Home Cafe: Football
Location: New Castle, PA

Postby SHOCKandAWE » Wed Aug 03, 2005 9:10 pm

Here is a great Excel sheet that is free. You can use it to enter your league settings and it will calculate rankings using VBD

http://www.footballguys.com/download.htm

Click the free VBD Excel file
Image
SHOCKandAWE
Special Teams Staff
Special Teams Staff

User avatar

Posts: 268
Joined: 8 Feb 2004
Home Cafe: Baseball
Location: The town with the BEST football fans around! PITTSBURGH, PA

Postby BronXBombers51 » Wed Aug 03, 2005 9:24 pm

SHOCKandAWE wrote:Here is a great Excel sheet that is free. You can use it to enter your league settings and it will calculate rankings using VBD

http://www.footballguys.com/download.htm

Click the free VBD Excel file


It won't let me run the file because my macro level is too high? What the hell is that?
BronXBombers51
Offensive Coordinator
Offensive Coordinator


Posts: 659
(Past Year: 1)
Joined: 7 Apr 2005
Home Cafe: Baseball

Postby Amazinz » Wed Aug 03, 2005 9:30 pm

Your macro security level prevents macro viruses.

If you have an anti-virus program installed you can just shut it off. Depending on your edition of Excel:

Tools->Macro->Security

or

Tools->Options, Security Tab, Macro Security Button

Then set it to low. If you don't have AV installed and you turn it off just be careful about spreadsheets downloaded from the Internet.
Image
Amazinz
General Manager
General Manager

User avatar
Mock(ing) DrafterEagle EyePick 3 Weekly Winner
Posts: 2552
Joined: 16 Mar 2004
Home Cafe: Baseball

Postby BGbootha » Wed Aug 03, 2005 9:30 pm

Open excel...

Tools -> Macro -> Security

YOu can then adjust your macro security settings to medium and it should work.
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 BronXBombers51 » Thu Aug 04, 2005 11:12 am

Nice, I figured it out. But those sheets are run on projections, no? I assume they are FootballGuys.com projections. They don't have the same type of thing using last year's stats, do they?

No biggie though, I appreciate the help.
BronXBombers51
Offensive Coordinator
Offensive Coordinator


Posts: 659
(Past Year: 1)
Joined: 7 Apr 2005
Home Cafe: Baseball

Postby BGbootha » Thu Aug 04, 2005 11:42 am

BronXBombers51 wrote:Nice, I figured it out. But those sheets are run on projections, no? I assume they are FootballGuys.com projections. They don't have the same type of thing using last year's stats, do they?

No biggie though, I appreciate the help.


The best part about football guys, is that you can manually adjust any projections you want to. I don't have it on this computer, but I know there is a way to do it.

That way, if you don't believe that manning will throw 45 TDs you can adjust it manually
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 BronXBombers51 » Thu Aug 04, 2005 11:46 am

That's pretty awesome. Thanks for the link and the help guys. ;-D
BronXBombers51
Offensive Coordinator
Offensive Coordinator


Posts: 659
(Past Year: 1)
Joined: 7 Apr 2005
Home Cafe: Baseball

Postby inferno19 » Thu Aug 04, 2005 9:20 pm

That is a nice spreadsheet.
Image
1335 rushing yards, 53 receptions, 441 receiving yards. 18 TDs.
Money in the bank.
inferno19
Defensive Assistant
Defensive Assistant

User avatar

Posts: 411
Joined: 16 Aug 2003
Home Cafe: Football
Location: Hunting Eli Manning.

Postby MCG321 » Mon Aug 15, 2005 3:34 pm

Nice tip. ;-D
MCG321
General Manager
General Manager

User avatar
Cafe RankerEagle EyeInnovative MemberCafe Blackjack Weekly Winner
Posts: 2644
Joined: 10 Jul 2003
Home Cafe: Football

PreviousNext

Return to Football Talk

Who is online

Users browsing this forum: No registered users and 7 guests

Forums Articles & Tips Start & Sit Sleepers Rankings Leagues


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


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