Formula for calculating auction values? - Fantasy Football Cafe 2014 Fantasy Football Cafe


Return to Football Talk

Formula for calculating auction values?

Moderator: Football Moderators

Formula for calculating auction values?

Postby RJ24VC15 » Fri Jun 08, 2007 10:26 pm

Is there a good formula anyone uses to take projections and calculate acution value?
Image
RJ24VC15
Offensive Coordinator
Offensive Coordinator

User avatar
Cafe Writer
Posts: 783
Joined: 27 Jul 2006
Home Cafe: Football

Re: Formula for calculating auction values?

Postby mlavwilson » Sat Jun 09, 2007 1:55 am

  • Calculate projected points.
  • Calculate worth (VBD)
  • Given worth, distribute dollars to starters + N for each position.

Sounds simple but it is a daunting task to do by hand. Take a look at this article.
Last edited by mlavwilson on Sat Jun 09, 2007 11:23 am, edited 1 time in total.
mlavwilson
Special Teams Staff
Special Teams Staff

User avatar

Posts: 202
Joined: 21 Apr 2006
Home Cafe: Football

Re: Formula for calculating auction values?

Postby Amazinz » Sat Jun 09, 2007 8:52 am

It's really not that bad, especially if you use Excel. Once you have you have your VBD point values, determine the production pool by summing the value of each starter. For example, top 12 QB + top 24 RB + top 24 WR + etc, and we'll say our total is 4,300 points.

For the monies, it is cap ($250) minus minimum bid ($1) multiplied by the number of teams in the league (12):

($250 - $1) / 12 = $2988.

Divide the disposable cash ($2988) by the available points (4300):

$2988 / 4300 = .70

Peyton's VBD value is 90.1 so his projected dollar worth is:

(90.1 * .70) + $1 = $64.

The +1 is adding the minimum bid back into the value. If you have a player with negative points than you probably won't want to draft him but for completeness his value (not necessarily worth) would be $1. There are more advanced models that apply the dollars on a per category basis which is necessary for fantasy baseball but overkill for fantasy football IMHO.
Image
Amazinz
General Manager
General Manager

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

Re: Formula for calculating auction values?

Postby 011472 » Sat Jun 09, 2007 8:43 pm

mlavwilson wrote:
  • Calculate projected points.
  • Calculate worth (VBD)
  • Given worth, distribute dollars to starters + N for each position.

Sounds simple but it is a daunting task to do by hand. Take a look at this [url=http://www.ffauthority.com/modules/smartsection/item.php?itemid=Calculate projections.
This step is simple; calculate projections for all the major players in the NFL. If you do not have 20+ hours to do that task, get your projections for another source.77]article[/url].


Sounds like a great system that I could do at home. Can you recommend a source for the projections? I don't have the 20 hours.
011472
Head Coach
Head Coach

User avatar
Matchup Meltdown SurvivorCafe Blackjack Weekly Winner
Posts: 1921
Joined: 26 Dec 2004
Home Cafe: Football

Re: Formula for calculating auction values?

Postby Crimedogg32 » Sat Jun 09, 2007 11:24 pm

Crimedogg32
General Manager
General Manager

User avatar
CafeholicCafe WriterCafe RankerGraphics ExpertMock(ing) DrafterEagle Eye
Posts: 3974
Joined: 29 Aug 2004
Home Cafe: Football
Location: Minnesota

Re: Formula for calculating auction values?

Postby mlavwilson » Sun Jun 10, 2007 6:54 am

011472 wrote:
mlavwilson wrote:
  • Calculate projected points.
  • Calculate worth (VBD)
  • Given worth, distribute dollars to starters + N for each position.

Sounds simple but it is a daunting task to do by hand. Take a look at this [url=http://www.ffauthority.com/modules/smartsection/item.php?itemid=Calculate projections.
This step is simple; calculate projections for all the major players in the NFL. If you do not have 20+ hours to do that task, get your projections for another article.


Sounds like a great system that I could do at home. Can you recommend a source for the projections? I don't have the 20 hours.


http://www.ffauthority.com/modules/ff/
http://fftoday.com/rankings/index.html
mlavwilson
Special Teams Staff
Special Teams Staff

User avatar

Posts: 202
Joined: 21 Apr 2006
Home Cafe: Football

Re: Formula for calculating auction values?

Postby shawngee03 » Tue Aug 31, 2010 2:33 pm

if i have avg auction values from a site i like...but theirs is done using a $200 budget...how do i get it to be relevant to my $150 budget draft?

do i just take 75% of the $200 budget auction value?
shawngee03
Offensive Coordinator
Offensive Coordinator


Posts: 714
Joined: 6 Mar 2007
Home Cafe: Football


Return to Football Talk

Who is online

Users browsing this forum: No registered users and 3 guests

Forums Articles & Tips Start & Sit Sleepers Rankings Leagues


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


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