FantasySharks.com

There are two types of Fantasy Football Owners: Sharks and Chum, which are you?
It is currently Sun 10.26.2014, 00:12

All times are UTC - 5 hours




Post new topic Reply to topic  [ 52 posts ]  Go to page 1, 2, 3, 4  Next

Did you find the app useful?
Yes 80%  80%  [ 16 ]
No 15%  15%  [ 3 ]
You should charge for this! 5%  5%  [ 1 ]
Total votes : 20
Author Message
PostPosted: Wed 08.31.2005, 08:45 
Offline
Great White Shark
Great White Shark
User avatar

Joined: Mon 11.01.2004, 12:12
Posts: 4533
Sand$: 13381
Donate
Location: Chesapeake, VA
car.gif
Hey gang...

Saw some VBD calculators out on the web that cost money and haven't really seen any that really impressed me so I wrote my own. It's not perfect *yet* but it's better than a static cheatsheet from any website and it's better than a lot of the calculators I've seen out there.

Note: Any calculator is only as good as the predictions in it. I'd recommend looking over the stats I have in this one before you go with it's predictions. If you dissagree with my predictions I'd recommend putting your own in.

It's just an excel spreadsheet with a bunch of calculations in it. Don't sort the collumns yourself, use the built in Macro to do it once you've entered your data otherwise you'll bork it up.

Enjoy! Feedback is appreciated.
Original with only Overal VBD displayed in the Position Cheat Sheets:
http://members.cox.net/elnator/FantasyFootball/VBD_Calculator_v1.1.xls

Version 1.2 with the cheat sheets more printer-friendly and with Position sheets displaying player projected points and overall sheet showing Projected Value.
http://members.cox.net/elnator/FantasyFootball/VBD_Calculator_v1.2.xls


Last edited by elnator on Wed 08.31.2005, 12:43, edited 3 times in total.

Top
 Profile  
 
 Post subject:
PostPosted: Wed 08.31.2005, 08:51 
Offline
Great White Shark
Great White Shark
User avatar

Joined: Fri 07.02.2004, 22:31
Posts: 5539
Sand$: 6404
Donate
Location: PhilaDallas, Texsylvania
phi.gif
Looks pretty good Elnator.

Thanks for posting it.

_________________
Image


Top
 Profile  
 
 Post subject:
PostPosted: Wed 08.31.2005, 08:53 
Offline
Great White Shark
Great White Shark
User avatar

Joined: Mon 11.01.2004, 12:12
Posts: 4533
Sand$: 13381
Donate
Location: Chesapeake, VA
car.gif
:) Would have posted it sooner but I had a PPR draft last night and hadn't used it for one yet. It did really well for me so I figured it was time to share.

There is also that other little aspect that I didn't really WANT to share till I was sure all my shark drafts were done (or nearly done).


Top
 Profile  
 
 Post subject:
PostPosted: Wed 08.31.2005, 09:02 
Offline
Megalodon
Megalodon

Joined: Wed 01.26.2005, 14:46
Posts: 20136
Sand$: 53856
Donate
Location: C/S, CO
ari.gif
Very kind of you to share the wealth. It looks great and I'm quite intrigued to try it out. Thanks! :thumbright:


Top
 Profile  
 
 Post subject:
PostPosted: Wed 08.31.2005, 09:07 
Offline
Great White Shark
Great White Shark
User avatar

Joined: Sat 08.30.2003, 14:30
Posts: 4080
Sand$: 7848
Donate
Location: Milwaukee
gb.gif
I like it...

A couple suggestions though... I don't start any TEs in my league... just WR/TEs... perhaps make it so you can classify TEs as WRs easily.

Also, for some reason in my scoring system Defs showed up as "#VALUE!" at the top of my VBD list.

I also wanted to factor Kickers out so I made them 0 in my lineup requirements. If possible... it would be cool if I selected "0" for my lineup requirements they don't display at all on my vbd list... Or maybe I could put the scoring in and they'd sort themselves on the K/Def lists but not into the main list...

_________________
Image


Last edited by Deckard on Wed 08.31.2005, 09:10, edited 1 time in total.

Top
 Profile  
 
 Post subject:
PostPosted: Wed 08.31.2005, 09:08 
Offline
Great White Shark
Great White Shark
User avatar

Joined: Mon 08.30.2004, 14:28
Posts: 7507
Sand$: 9473
Donate
Location: Cranberry Twp, PA
Very cool Elnator... thanks!


Top
 Profile  
 
 Post subject:
PostPosted: Wed 08.31.2005, 09:11 
Offline
Great White Shark
Great White Shark
User avatar

Joined: Sat 09.27.2003, 17:26
Posts: 1850
Sand$: 94
Donate
Location: Oakland
nyj.gif
Cool.

_________________
The Oakland/L.A. Raiders History:
Super Bowl Champions: 3
Super Bowl Appearances: 5
AFL/AFC Championship Games: 14
Division Championships: 15
Playoff Appearences: 21
Team Record in Playoffs: 24-18 .571
Hall of Fame Players: 17


Top
 Profile  
 
 Post subject:
PostPosted: Wed 08.31.2005, 09:12 
Offline
Great White Shark
Great White Shark
User avatar

Joined: Mon 11.01.2004, 12:12
Posts: 4533
Sand$: 13381
Donate
Location: Chesapeake, VA
car.gif
Decktard wrote:
I like it...

A couple suggestions though... I don't start any TEs in my league... just WR/TEs... perhaps make it so you can classify TEs as WRs easily.

Also, for some reason in my scoring system Defs showed up as "#VALUE!" at the top of my VBD list.

I also wanted to factor Kickers out so I made them 0 in my lineup requirements. If possible... it would be cool if I selected "0" for my lineup requirements they don't display at all on my vbd list... Or maybe I could put the scoring in and they'd sort themselves on the K/Def lists but not into the main list...


Thanks! I'll take that into account.... I'm concerned as to why the defenses showed up as #value... check what you put into the scoring system and make sure you didn't put any spaces (or leave any entries blank). Don't use blank entries, use 0 if there's no points. And don't use spaces, I didn't do error checking on my formulas to keep the spreadsheet small enough for a PDA to use.

If you want to set up a FLEX position like WR/TE count it as .5 towards WR and .5 towards TE or just 0 towards TE and 1 towards WR if that's how you'd rather do it. Just remember that putting a 0 in a collumn will set your TE's VERY low on your VBD. Same for RB/WR just put .5 to RB and .5 to WR.


Top
 Profile  
 
 Post subject:
PostPosted: Wed 08.31.2005, 09:15 
Offline
Great White Shark
Great White Shark
User avatar

Joined: Mon 11.01.2004, 12:12
Posts: 4533
Sand$: 13381
Donate
Location: Chesapeake, VA
car.gif
Could the person who voted no state why? I'd like to improve this thing in future so if you have a reason please let me know why you didn't find it useful. If the data is what you dissagree with I wrote it so you can put your own values in.


Top
 Profile  
 
 Post subject:
PostPosted: Wed 08.31.2005, 09:24 
Offline
Supreme Megalodon
Supreme Megalodon
User avatar

Joined: Thu 10.21.2004, 22:12
Posts: 81175
Sand$: 63878
Donate
ind.gif
great job, thanks for sharing!!! :D


Top
 Profile  
 
 Post subject:
PostPosted: Wed 08.31.2005, 09:31 
Offline
Megalodon
Megalodon
User avatar

Joined: Thu 07.21.2005, 13:44
Posts: 14970
Sand$: 21025
Donate
Location: North O' Boston
ne.gif
I think it is great. THanks!!!!!!!

I did get a macro error......
Code:
  Selection.Sort Key1:=Range("Q2"), Order1:=xlDescending, Header:=xlGuess, _
        OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom, _
        DataOption1:=xlSortNormal


I got the #value error for TE when I had 0 for TE required. When I changed it to 1, I got values.

My league has 2 rbs 2 wrs, and 2 flex spots. The flex spots are RB/WR and WR/TE, so adding that flexibility would rock.

Again....thanks!

_________________
stuffedcrust3meat wrote:
to all the people we never meet that leave a lasting impression :Drink)


Image


Top
 Profile  
 
 Post subject:
PostPosted: Wed 08.31.2005, 09:34 
Offline
Great White Shark
Great White Shark
User avatar

Joined: Tue 09.09.2003, 20:29
Posts: 6034
Sand$: 13549
Donate
Location: Austin, TX
ten.gif
Is this different/better than the free VBD spreadsheet that FootballGuys offers?

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

_________________
Image Image


Top
 Profile  
 
 Post subject:
PostPosted: Wed 08.31.2005, 09:38 
Offline
Great White Shark
Great White Shark
User avatar

Joined: Sat 08.30.2003, 14:30
Posts: 4080
Sand$: 7848
Donate
Location: Milwaukee
gb.gif
elnator wrote:
I'm concerned as to why the defenses showed up as #value...


it looks like since I put 0 in TE... the DEF value is based off of how many are in TE (?) so it came up as a bad value...

once I put in .5 for TE and 2.5 for WR... the DEF started showing up. I would like to do a sheet without TEs though. I don't like drafting them in my format.

_________________
Image


Top
 Profile  
 
 Post subject:
PostPosted: Wed 08.31.2005, 09:41 
Offline
Great White Shark
Great White Shark
User avatar

Joined: Mon 11.01.2004, 12:12
Posts: 4533
Sand$: 13381
Donate
Location: Chesapeake, VA
car.gif
Ahh I bet it's the fact that it's using the 0's to determine roster size...

Putting 0 in TE gave you an error on Defense?

I'll fix the 0 error checking and I'll double check my formula for defenses.... sounds like it may be pulling from the wrong collumn.


Top
 Profile  
 
 Post subject:
PostPosted: Wed 08.31.2005, 09:47 
Offline
Great White Shark
Great White Shark
User avatar

Joined: Mon 11.01.2004, 12:12
Posts: 4533
Sand$: 13381
Donate
Location: Chesapeake, VA
car.gif
Thanks guys, found the problem with defenses, it was pulling from the wrong starting lineup spot. I also see the problem with the #Value error when you put 0 beside a roster slot value (IE 0 defense or 0 TE) I'll work on fixing THAT later. I've uploaded the corrected spreadsheet to fix Defense pulling it's roster size from the wrong cell.

Basically the #Value message comes up because when it runs the calculation based on a 0 roster size it gets an incorrect result for the offset that throws the #VALUE message up because it doesn't know what to do with a null value. I'll have to put an IF statement into it later today... got a con call in 5 so I don't have time to fix that right now.


Top
 Profile  
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 52 posts ]  Go to page 1, 2, 3, 4  Next

All times are UTC - 5 hours


Who is online

Users browsing this forum: agame2323, Bing [Bot], dukeman_92, robbush and 13 guests


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum

Jump to:  
Powered by phpBB® Forum Software © phpBB Group