Squeeze Every Penny

Updated: June 5th 2016

Let me start this article by raising a glass to the creator at Twitter who added the poll option to tweeting. Since this feature has been added, the ability to quickly skim through @dynastytrades feed to vote and see the results of fantasy football trades, has been an incredible resource. If you are not already following them you should be. However, be careful when reading these polls that they don’t offer exactly approximate value of players in the context of YOUR league. As I have said in previous articles owners have tendencies towards certain players and team philosophies that can alter the value of these players. Even entire leagues can have a style that can alter how one participates in their auctions. One league can be very bullish in their contract signings while another can be coyer when spending large cap figures on single players. Regardless of your league setup however, there is a way that you can quantify how much each player should receive. I will breakdown how to understand and use this formula for not only your auction drafts but also to compare the values of players that are already currently owned.

Please note there are two factors that prevent the formula from being applied universally across all leagues. The first is that the point values are inputted at the discretion of the user and different lists could yield different results. Some users simply like to apply the point totals for last season, others like to use predicted point totals that are released from various fantasy sites. Whichever YOU chose,  just be sure that you feel comfortable with the values as these are the drivers for all the contracts. The second variable is the league settings, including roster sizes and number of starters at each position. It should be pretty easy to understand that the more players that are started and the larger the roster size the more money that needs to be spread throughout each roster. This will reduce the max dollars that the elite players should receive when compared to smaller rosters.

Preparing Your Chart

Once you find a database for every player’s fantasy point total that you are comfortable with, organize them into each individual position so that you can create a baseline and margin scores. Again make sure that the database values that you are using were calculated based on your league’s scoring settings. There is a big difference between half, full and non PPR scoring as well as TE premium and 6 points/passing TDs that will drastically change the values for certain players. From here you can place each player and their fantasy point value in a chart that goes in descending points order along with 6 extra columns labeled as below. This example is for the QBs in my 10 team 0.5 PPR home league which starts 1QB, 3RB, 4WR, 1TE, 2FLEX, 1K, 1DST and has a roster size of 26.

Auction Chart 1

A tip here would be to use Microsoft Excel so that you can input all the formulas and save some time. Either way, now that you have the information entered you can create the VORP score (Value Over Replacement Player) for each player. For each of the BASE values they will be equal to the number of starting players in your league times the appropriate multiplier (1.75, 1.5, 1, 0.5). In my example that would be values of 18, 15, 10 and 5. These values are what you are going to be comparing each player against to calculate their margin score. For example, in the Base x1 to determine Aaron Rodgers’ margin you would compare his points versus that of the 10th ranked QB (Andy Dalton) and subtract his points from Rodgers (304.58-269.3=35.28). You would follow the same process to fill out the rest of the chart where comparisons would be made against the 18th, 15th, 10th and 5th ranked players. This is also why you may have noticed that I did not include every QB available. Every player that ranks lower than your Base x1.75 value, in this case the 19th ranked QB and lower, should only receive the minimum bid at auction. Now you will have a chart now that looks like this. I also included the margin value which is the sum of these base values.

Auction Chart 2

Applying the Math

Once you have done this for every position you can then calculate the contract values. This requires a formula that will be the same for all positions and will yield a multiplier to calculate contract values.

Contract Multiplier = (∑QB Margins+∑RB Margins+∑WR Margins+∑TE Margins)/[(Salary Cap -Roster Size*Minimum Bid)*Number of Owners]

This may seem like a daunting formula but it is simple when broken down. First, multiply the number of rostered players you must have in your league by the minimum auction bid of $500,000. Subtract that number from the salary cap value of $155,270,000 for this year. This difference becomes the “fun money” that you have to spend after accounting for filling out the roster with minimum bid players. Multiply this by the number of teams in the league and you have the entire league’s “fun money”. This number will likely be in the billions of dollars!

The numerator part of the formula takes all of the margins for each position and adds them together. Notice that I did not include a sum for kickers or defenses as I believe in only spending the minimum. Let other owners in your league spend the extra money so that you have more to use on positions that matter. Finally, divide this sum of all position margins from the billions of dollars available in total league “fun money”. This value will be very small, likely a number with four to six 0s after the decimal. For my example this number comes out to 0.00001456 or 1.456e-5.

You now have your multiplier to compare players’ values against one another. Divide an individual player’s margin by the contract multiplier and a dollar value will appear as your contract value. Don’t forget to add back $500,000 to account for the minimum bid value that comes with each player with a value equal to 0. Doing this for every position will yield a completed chart as below.

Auction Chart 3

For those of you that participate in IDP leagues the same formula can apply. You simply would need to do the same margin charts for all defensive positions and apply their sum margins to the numerator.

Hopefully you have stayed with me throughout this impromptu math session. The key to staying focused in your auction is to be prepared. Every owner is entitled to conducting the auction in their own manner, however, too often I have seen owners come in knowing that they want a collection of players and are willing to pay whatever to acquire them. Having a sheet prepared of all the approximate values for each player helps see the whole field instead of getting locked in with blinders. I know math and computers are not everyone’s strong suit so if you have any questions about the chart or want help setting up yours you can find me on twitter @naandrews19.

More Analysis by Nick Andrews