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: Number of players at each position (1 quarterback, 3 wide receivers, 2 running backs, 1 tight end, 1 defense and 1 kicker).Amount of auction money allotted ($200 is pretty standard).Projected season long point totals for each NFL player (similar to our previous post, we use the FantasyPros season projections).At first you might feel intimidated, but once you remember that every auction round is just a data driven decision, and that spreadsheets are great at solving data driven decisions, you can build something to give yourself the best chance to succeed! They might cite something like this articleto make their case. While most leagues use snake draft, eventually you might be faced with a league where someone suggests an auction draft. Last year, we demonstrated how someone can make a fantasy football draft spreadsheet to help make the best decision in each round of a traditional snake draft.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |