Birthday Gift Tracker
Sheets + Excel6 tabs
Free
A pick'em pool asks one thing of every player: choose a winner for each game. This file holds the whole contest. The Games tab lists all thirteen playoff games from Wild Card weekend to the Super Bowl, with a column for each player's pick and one for the real winner. As results arrive, you choose the winner and every player's correct picks are counted.
Later rounds are worth more. The Scoring tab sets points per correct pick for each round, and the Games tab picks up that value automatically. Standings show correct picks, points, rank and a best possible total based on the games left. Scoring is in points, and a prize, if you give one, is up to the group. Replace the seed placeholders with real team names once matchups are set.
Click Make a copy in Google Sheets, then confirm on the Google page. The copy is saved to your own Google Drive.
Start on the Standings tab: replace the sample rows with your own.
Keep the formula columns as they are; they fill in as you type.
Read the How to use tab for tips. For Excel, download the .xlsx file instead.
Thirteen: six on Wild Card weekend, then four on Divisional weekend, two conference finals and one title game. This file lists all thirteen.
The Scoring tab gives each round its own points per correct pick. The sample uses one, two, four and eight, and you can change any value.
It adds a player's current points to the points available in games they have picked but that are not yet decided. It shows who can still catch the leader.
Sheets + Excel6 tabs
Free
Docs + Word1 page
FreeSheets + Excel5 tabs
Free