Fantasy Football - Footballguys Forums
This is a sample guest message. Register a free account today to become a member! Once signed in, you'll be able to participate on this site by adding your own topics and posts, as well as connect with other members through your own private inbox!
Auction player values help (1 Viewer)
- Thread starter ostrich
- Start date
if you are a member here, download either draft dominator or the VBD worksheet. Put in your scoring system. Click "auction on" and use Maurile's baseline's (also a check box). That will give you an up to date cheat sheet based on the FBGs projections. if your not a member here good luck.
Pythagoras
Footballguy
The only thing I found matching what your looking for is the FBG VBD spreadsheet.Obviously it varies based upon the number of teams, number of roster spots, scoring system, experience of the owners, whether you use flex positions, etc. but based upon my experience you can expect to get a top tier RB for 25-40% of salary cap, a top tier QB or WR for 15-25%, and a top TE for 5-10%. D and K are usually 0.5 - 1.5 %. I would start off with the FBG VBD spreadsheet to get a rough idea of what fair prices are, and then do a mock auction. Sometimes all the other owners will seem to put a premium/discount on a particular position compared to where you valued the players. For example, RB's may seem too expensive or QB's really cheep. My advice (not that you've asked) is to not avoid the RB's waiting for a steal, or gobble up the QB's just because their cheep, but to admit that you've under/over valued the position yourself and just try to find relative value.If you do your homework and keep track of the action you should be able to get a well balanced and competitive team.
hephner
Footballguy
It's a bit tedious, but another thing i found useful was to get some actual draft results by going to myfantasyleague.com, and in the league search box, type in auction, and it will give you all kinds of auction leagues. You will have to go through each one and from the menu page of each individual league, click Reports > League > Auction Results Summary (if their draft was done this year, and was not a prior dynasty carry-over).
Once here, you can click on Detailed Results, then re-sort the results by winning bid amounts. I then cut and paste these into excel (using the Paste Special > text option so the formatting carries in properly and not all into one cell).
Ya, it's a bit complicated and long, but if you do this for a few leagues or so, it will give you some good REAL auction drafts as a basis. Of course, it's best to find some with a similar scoring system and auction budget.
But once I did these steps for a few different drafts (each in its own separate tab), I plugged in some VLookup formulas into my excel file and was able to calculate average auction values for each player, and all from very similar leagues to mine.
Once here, you can click on Detailed Results, then re-sort the results by winning bid amounts. I then cut and paste these into excel (using the Paste Special > text option so the formatting carries in properly and not all into one cell).
Ya, it's a bit complicated and long, but if you do this for a few leagues or so, it will give you some good REAL auction drafts as a basis. Of course, it's best to find some with a similar scoring system and auction budget.
But once I did these steps for a few different drafts (each in its own separate tab), I plugged in some VLookup formulas into my excel file and was able to calculate average auction values for each player, and all from very similar leagues to mine.
What are VLookup formulas and how do you use them? It's ok if its too complicated
ActionHero
Footballguy
I noticed on another site that their auction values were based off a $100 salary cap. If our league's cap is $200 (and all other parameters are same), can I just double the player values?
Yes...you can just double the values.Or just wait for Dodds to get out his Perfect Auction article. Should be here right after kickoff of the Colts game next thursday. If your draft is BEFORE the season actually starts...well.....good luck.
Jeff Pasquino
Footballguy
Not quite.The $1 players won't be $2, so the $20 players will be more like $42.A better way would be to take out all the $1 players, add up the $ left across all teams and then adjust.For example - 12 teams, $100 each. Say there are 100 $1 players and 240 players overall.That leaves $1,100 across 140 guys. Now look at the $200 league and figure the same thing - 100 $1 players, 140 guys left. Now you have $2300 across 190 guys.You need to take all values over $1 times $2300 and then divide by $1100, which is over double value.(23/11 > 2)So a $20 player goes to about $42.
Last edited by a moderator:
Big Sug
Footballguy
the information available on how to establish auction values in fantasy football was complete garbage until Maurile Tremblay's auction article--and its subsequent addition to the Draft Dominator--came along. It is awesome.
That article is the first sound mathematical explanation of how to translate the amorphous concept of "value" into concrete numbers in a fantasy football auction. For years, I have intuitively understood the concepts involved, but I could not really articulate them. Therefore, for years I had been resorting to a close examination of my league's past auctions, mapping those results onto the current years' group of players and tweaking auction values in accordance with VBD numbers.
Now there is a an actual mathematical proof of exactly what components combine to create auction dollar values. Kudos to Maurile and Footballguys.com.
short answer to original poster's question:
1. use the draft dominator
2. select the "Maurile's baseline" option.
3. profit.
That article is the first sound mathematical explanation of how to translate the amorphous concept of "value" into concrete numbers in a fantasy football auction. For years, I have intuitively understood the concepts involved, but I could not really articulate them. Therefore, for years I had been resorting to a close examination of my league's past auctions, mapping those results onto the current years' group of players and tweaking auction values in accordance with VBD numbers.
Now there is a an actual mathematical proof of exactly what components combine to create auction dollar values. Kudos to Maurile and Footballguys.com.
short answer to original poster's question:
1. use the draft dominator
2. select the "Maurile's baseline" option.
3. profit.
Dickie Dunn
Footballguy
VLookup is an Excel formula that allows you to extract a certain piece of information out of a table of data.Let's say you had three tables of auction data and you wanted to find the prices for one specific player ... LT, for example ... from each.Here's an example of how it would look:A1 (cell in your spreadsheet) = "LaDainian Tomlinson"Column C has all of the names from the auction data you're examining; Column D has the positions, Column E the pricesNow let's say there are 100 total entries in this table. Here's the formula you would use:=VLOOKUP(A1,$C$1:$E$100,3,FALSE)The "3" refers to the column in the table where you want to find the data. "FALSE" will return a "0" or "N/A" if the formula doesn't find any data.If you had three different tables of data, you could build three different VLOOKUP formulas, or just have one formula that adds all of them together and then is divided by three.Obviously, there are different ways to build it depending on if you keep everyone on one sheet, or if you prefer to put different sets of data on different tabs. But that's the basic idea.Hope that helps.What are VLookup formulas and how do you use them? It's ok if its too complicated
