Birthday Gift Tracker
Sheets + Excel6 tabs
Free
In a confidence pool you do more than pick winners; you say how sure you are. Within each round, you give each pick a different number, and a correct pick earns that many points. A Wild Card slate uses one to six, the Divisional round one to four, conference games one and two, and the Super Bowl one. That makes a safe lock worth more than a coin flip.
The rule that trips people up is using a number twice. This sheet shades any row where a number repeats inside its round, and the Standings tab counts the repeats for each player so the organizer can ask for a fix before kickoff. Winners are chosen as games end, and points, rank and points still open update. The sheet fits six players, each with a pick column and a points column.
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.
Each pick gets a different number inside its round. If the pick is right, the player earns that number. A pick given the top number is the one the player trusts most.
A row turns amber when a number appears more than once in its round for any player. Standings also lists how many repeated numbers each player has.
Wild Card uses one to six, Divisional one to four, conference championships one and two, and the Super Bowl one. Change the rule in your own pool if you like.
Sheets + Excel6 tabs
Free
Docs + Word1 page
FreeSheets + Excel5 tabs
Free