Several years ago I wrote about how I used Excel to track a fantasy football draft. Everything in that post is still relevant but I wanted to provide a short update.
Most importantly, the spreadsheet I use is now available and updated for 2022. See the instructions sheet in the document for how to use it during a fantasy football draft.
The original post talked about my league having 16 players that each fantasy owner drafts. Over the last five years that number has increased to 18.
The short version of how to use this spreadsheet is to:
- Update team names on the Teams sheet to reflect players in your league.
- During the draft, use the Players sheet to track the player selections by entering the team owner and dollar amount for each player drafted on the Players sheet.
- For the various tracking sheets, most notably, the Auction Tracker, use the Data:Refresh Connections command on the Data ribbon or press CTRL+Alt+F5 to have the sheets update with info from what you enter as the draft progresses.
- Have fun.
I have made every reasonable effort to verify the accuracy of the formulas and such in this spreadsheet. If you find an issue, please let me know in the comments here or on Twitter, where I am @kellylford.
Leave a Comment