Auction Value Calculator (1 Viewer)

[u999spf]

Is there a website out there where you can plug in your scoring system, roster requirements and salary cap and it will spit out cheatsheets with average auction values of recent drafts?

I am looking for something other than Draft Dominator to use for this. We have a $150 salary cap and most sites are based on $100 or $200 and people are too lazy to multiply $100 values by 1.5.

 

[turnit643]

Is there a website out there where you can plug in your scoring system, roster requirements and salary cap and it will spit out cheatsheets with average auction values of recent drafts?

I am looking for something other than Draft Dominator to use for this. We have a $150 salary cap and most sites are based on $100 or $200 and people are I am too lazy to multiply $100 values by 1.5.

 

[hephner]

This is what I did for my upcoming auction:

1. find sample mocks or average auction value lists (or even search MFL leagues for actual drafts from this year)

2. cut and paste draft list into excel (you may have to do a "paste special" and select "text", so it doesn't post all the data to a single cell)

3. add a column next to the auction value for "Equivalent Value"

4. create formula in the first cell of that column to adjust to my cap (ie. =C2*1.5)

5. paste formula down rest of column

Its really very easy to do.

 

[Willowdoc]

Is there a website out there where you can plug in your scoring system, roster requirements and salary cap and it will spit out cheatsheets with average auction values of recent drafts?I am looking for something other than Draft Dominator to use for this. We have a $150 salary cap and most sites are based on $100 or $200 and people are too lazy to multiply $100 values by 1.5.

You would never multiply the $100 values by 1.5. You would pay too much for mediocre players and not enough for top players. This doesn't take into account the fact that the number of $1 players doesn't change much as you increase the total auction pool. In a implified case: 10 teams drafting 10 players each with a cap of $100. Total pool is $1000, but 50% of the players will be bought at $1. That leaves $950 for 50 players ($19 a piece), now if each team has a cap of $200, 40 percent bought at $1 (10% will get a $2 bid now), total pool $2000 minus those 50 players (40 at $1, 10 at $2) = 1940 for 50 players or $39 a piece and the spread on LT will go up more than the spread on Brandon Jacobs, so you will seriously underbid on top players by multiplying by 1.5.Here is my formula:Count the number of $1 and $2 players in your league last year. 2. Delete that number from the player pool. 3. Subtract the amount spent on those players from the total amount available at auction4. Subtract $2 for each remaining player (the baseline player is now $1, but actually is $3 when you are bidding)5. Plunk these results into the draft dominator auction section.You will now have a fairer representation of the value of the top players in an auction.Up to now I have done pretty mediocre in draft leagues, but using the above formula, I have always placed in the money in WCOFF auction leagues (3 years) and my home auction league. One other simpler way to do this. Take your ranking list, last years auction prices and match top RB to top RB price., top QB to top QB price. You'll probably be low on LT, but you'll be in the ballpark for your own league for almost anyone else. I have both numbers in the DD when I go to an auction.

 

[u999spf]

Is there a website out there where you can plug in your scoring system, roster requirements and salary cap and it will spit out cheatsheets with average auction values of recent drafts?

I am looking for something other than Draft Dominator to use for this. We have a $150 salary cap and most sites are based on $100 or $200 and people are I am too lazy to multiply $100 values by 1.5.

Actually I already do my own calculations and use DD for this. I am asking b/c I am commish of a few auction leagues and the other owners are complaining that they cant find auction values based on $150. So I wanted to shoot them a link of a site that they can use, if there was one.

 

[gebz306]

Multiplying $100 X 1.5 would prove to be wrong is right... Using the $200 values X 75% would be more accurate