Today’s post shows how to create auction values from projections + a plug for Reality Sports Online
Interested in doing an auction draft? You should. It’s one of my favorite ways to play fantasy football. If you haven’t done so already, I recommend you try Reality Sports Online’s auction/league management site.
Reality Sports Online is a website that is designed to emulate actual NFL front office operations and create a realistic general manager experience:
- Negotiate multi-year contracts live online in the first ever Free Agency Auction Room.
- Scout players
- Draft rookies
- Manage salary cap
- Trade players for draft picks
- Utilize a franchise tag
- Fully customize league settings (rosters, lineups, scoring, contracts, and more).
I am running a RSO dynasty league with some of my favorite fantasy writers while writing monthly updates about my team, the league, and other thoughts with keeper league implications.
This is the list of competitors as we enter Year Two.
- Jeff Tefertiller – Footballguys
- Ryan McDowell – Dynasty League Football
- Sigmund Bloom – Footballguys
- Mike MacGregor – FFToday
- Bryan Fontaine – Pro Football Focus
- Tim Stafford – Dynasty League Football
- Matt Papson- Reality Sports Online
- Matt Waldman – Footballguys/RSP/Football Outsiders
- Jason Wood – Footballguys
- Mike Clay – Pro Football Focus/NBC
- Bob Harris and Mike Dempsey – Football Diehards/Sirius XM
- Rivers McCown – Football Outsiders
- Jim Day – Fantasy Taz
- Lance Zierlein – Sideline View
Want to try it yourself? Here’s a review of the site and if you start a league, a promo code where you get 20 percent off the fee for starting a league: RSP20%OFF. Like last year, I’ll cover this league at this block throughout the summer and fall.
Before I wake up these writers from their offseason hibernation, I thought I’d discuss how to create auction values. Although the contract values with Reality Sports Online are more realistic to real football, it never hurts to develop values based on projections. RSO has a salary cap of $123 million with the option of multiple year deals for player.
Despite the use of millions of dollars and multi-year contracts, projecting values is for the most part like any other league. I’ll be creating another auction value sheet this year in my Gut Check column at Footballguys, but today, I’m going to sahre how to do it at home.
There may be better ways to go about it, but I’ve had success with this method in a variety of leagues:
- Determine the VBD (Value Based Drafting) score for each player. I suggest using Footballguys VBD Application/Spreadsheet to determine VBD/projections.
- Create a spreadsheet with every player and his VBD score.
- Sort by high to low VBD score.
- Create a Cap Value based on VBD score.
- Determine a percentage of VBD that your highest valued player is worth.
- Create a sliding scale from that highest value to the lowest value.
- Multiply that VBD of the player with the value and the format the product of those two numbers as dollars.
In essence, I view VBD as gross dollars and then use the percentage scale to refine that total into budgeted dollars for my auction list. For instance, if I had Adrian Peterson as my top player with a VBD of 242 and I was willing to spend 31 percent of my cap on the top player on my board, then the equation for my maximum spend for Peterson would be 242 (VBD) x 0.31 (cap allocation percentage) = 75 — or $75.
For RSO leagues it means I would be willing to spend $75 million of the $129 million of the cap on Peterson last year if I used this exact value sheet for the league. For RSO I would have created a different VBD based on the rules of the league. My league places more value on receivers so I’m almost certain Calvin Johnson would have been the top player on my board. So you know, I spent $68 million on him last year, so my valuation wasn’t much different in terms of dollars.
I created my sliding scale by feel–a little trial and error. Here are some guideposts for the sliding scale I used last year.
- No.1 overall = 31 percent
- No. 12 = 24 percent
- No.24 = 17 percent
- No.36 = 12 percent
- No.48 = 9 percent
- No.60 = 7 percent
- No.72 = 6 percent
- No.84 = 4 percent
- No.96 = 2 percent
- No.108 = 2 percent
The deeper into the rankings, the smaller the difference in value between players. You can determine the values as you wish. This is how I did it.
Here’s a draft where I used these allotments last year in a non-RSO league. Here’s my team:
Bell, Le’Veon PIT RB | $18.00 | Matt Waldman | Sun Aug 11 10:48:58 p.m. ET 2013 | Sun Aug 11 10:50:00 p.m. ET 2013 |
Boldin, Anquan SFO WR | $4.00 | Matt Waldman | Sun Aug 11 11:43:41 p.m. ET 2013 | Sun Aug 11 11:44:03 p.m. ET 2013 |
Brown, Antonio PIT WR | $14.00 | Matt Waldman | Sun Aug 11 11:02:39 p.m. ET 2013 | Sun Aug 11 11:03:29 p.m. ET 2013 |
Brown, Vincent SDC WR | $6.00 | Matt Waldman | Mon Aug 12 12:03:20 a.m. ET 2013 | Mon Aug 12 12:03:42 a.m. ET 2013 |
Bullock, Randy HOU PK | $1.00 | Matt Waldman | Mon Aug 12 12:01:33 a.m. ET 2013 | Mon Aug 12 12:01:33 a.m. ET 2013 |
Cowboys, Dallas DAL Def | $1.00 | Matt Waldman | Mon Aug 12 12:35:01 a.m. ET 2013 | Mon Aug 12 12:35:01 a.m. ET 2013 |
Franklin, Johnathan GBP RB | $1.00 | Matt Waldman | Sun Aug 11 11:53:42 p.m. ET 2013 | Sun Aug 11 11:53:42 p.m. ET 2013 |
Gates, Antonio SDC TE | $7.00 | Matt Waldman | Sun Aug 11 10:55:13 p.m. ET 2013 | Sun Aug 11 10:55:49 p.m. ET 2013 |
Greene, Shonn TEN RB | $1.00 | Matt Waldman | Mon Aug 12 12:29:55 a.m. ET 2013 | Mon Aug 12 12:29:55 a.m. ET 2013 |
Hilton, T.Y. IND WR | $7.00 | Matt Waldman | Sun Aug 11 11:30:21 p.m. ET 2013 | Sun Aug 11 11:30:42 p.m. ET 2013 |
Keller, Dustin MIA TE | $3.00 | Matt Waldman | Mon Aug 12 12:05:05 a.m. ET 2013 | Mon Aug 12 12:05:20 a.m. ET 2013 |
Lewis, Marcedes JAC TE | $1.00 | Matt Waldman | Mon Aug 12 12:25:06 a.m. ET 2013 | Mon Aug 12 12:25:06 a.m. ET 2013 |
Martin, Doug TBB RB | $44.00 | Matt Waldman | Sun Aug 11 9:15:33 p.m. ET 2013 | Sun Aug 11 9:16:33 p.m. ET 2013 |
Peterson, Adrian MIN RB | $55.00 | Matt Waldman | Sun Aug 11 9:17:21 p.m. ET 2013 | Sun Aug 11 9:18:43 p.m. ET 2013 |
Reece, Marcel OAK RB | $1.00 | Matt Waldman | Mon Aug 12 12:33:07 a.m. ET 2013 | Mon Aug 12 12:33:07 a.m. ET 2013 |
Roberts, Andre ARI WR | $1.00 | Matt Waldman | Mon Aug 12 12:08:50 a.m. ET 2013 | Mon Aug 12 12:08:50 a.m. ET 2013 |
Schaub, Matt HOU QB | $1.00 | Matt Waldman | Sun Aug 11 11:47:06 p.m. ET 2013 | Sun Aug 11 11:47:06 p.m. ET 2013 |
Vereen, Shane NEP RB | $19.00 | Matt Waldman | Sun Aug 11 10:31:16 p.m. ET 2013 | Sun Aug 11 10:32:30 p.m. ET 2013 |
Wilson, Russell SEA QB | $14.00 | Matt Waldman | Sun Aug 11 9:49:16 p.m. ET 2013 | Sun Aug 11 9:50:23 p.m. ET 2013 |
This is a mock, but you can see I had a solid foundation to build on with Peterson(RB6), Le’Veon Bell (RB17), Wilson (QB9), Brown (WR7), Boldin(WR15), Hilton (WR19), and Gates(TE9). This was a competitive team with room the add depth from the waiver wire despite Doug Martin, Dustin Keller, and Shane Vereen getting hurt early on.
Here’s last year’s sheet to play with.
Again, I can’t stress how good the RSO league is if you’re seeking a quality experience.
As for an updated spreadsheet of values stay tuned in late July or early August at Footballguys.com
9 responses to “Reality Sports Online Leagues + How to Create an Auction Value Worksheet”
Matt
Great article.
I am trying to build a spreadsheet as you suggest using FGs VBD spreadsheet . I cant seem to copy the data from individual positions to all players to create my own spreadsheet as you did last year.
When i copy the vbd data to my own sheet i get the #ref error as i think the cells are referenced to data in the main sheet.
Can you tell me how you got the data to your own sheet ?
thanks
Matt,
Problem solved!
I was using excel on my Mac.
Excel on my PC works fine.
Sorry about that!
Matt,
Any suggestions on integrating IDP’s into this spreadsheet?
Not much different. Use your scoring and lineup rules to determine VBD. Joe Bryant’s article from last year is a good start http://subscribers.footballguys.com/apps/article.php?article=13bryant_vbd
No worries. I was about to suggest how you paste the data, but all’s well I see.
[…] Reality Sports Online Auction Drafts + How to Create an Auction Value from VBD Projections. […]
[…] Reality Sports Online Auction Drafts + How to Create an Auction Value from VBD Projections. […]
[…] Reality Sports Online Auction Drafts + How to Create an Auction Value from VBD Projections. […]
[…] Reality Sports Online Auction Drafts + How to Create an Auction Value from VBD Projections. […]