Then we add in formulas to calculate the points over replacement player. We add in a column the text combination of “Position&Rank” so that we can look up the point total for the replacement player with a VLOOKUP. We make the same calculation for the next 9 QBs, then do the same for every other position, and finally we sum up the total points above replacement and then divide by the total number of dollars available to get each player’s fair value ![]() So by purchasing Aaron Rodgers, you’d be getting 321 points minus Ryan Tannehill’s 265 points = 56 points above replacement value. With 10 teams in the league and 1 QB per team, the 11th QB should be worth $0 as every team would already have a QB and not need to pay for another QB. Now the logic – how much should you pay for each player? How much are Aaron Rodgers’ 321 points worth in terms of auction dollars? We will use a similar value over replacement player methodology as we did in the snake draft spreadsheet. We want our spreadsheet to tell what the “fair value” of each player that comes up to auction is, based on which players have already been drafted and how much money has been spent so far.įirst, we set up our spreadsheet – by entering our league settings assumptions and putting in each player, their projected points and position rank:
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |