This template is for a 2-stage pool.
- Participants will enter their predictions for group play before June 11.
- After group play ends, participants will enter their predictions for the knockout rounds.
If you want a full tournament prediction pool, check out
and add your predicted total goals (used as tiebreaker).
to add your predictions for group play.
As the game results come in, add the scores in “Team 1 Goals” and “Team 2 Goals” in
(Optional) If you are the owner of this doc, and you want to enable email reminders for participants, make sure you (1) go to Explore > Packs & Import > Gmail to connect your email and (2) go to Settings > Automations > Email Updates and duplicate and turn on the rule. At the bottom, make sure the account is set to run using your own account (not Automation Bot).
After group play has finished, update Round of 16 teams in
and fill in your predictions in
Update “Teams” formula in
Update previous stage (hidden column) for Champion row in
Add conditional formatting to “Prediction” column in
Update email subscription handling to send one email bcc’ing all recipients (avoid “too many requests” error)
Summary: Update eliminated teams after each knockout match instead of after the knockout round is complete
Update “eliminated teams” and “expected count” formulas in
and add row for Round of 16
Update “was eliminated” column formula in
Update “max possible points” column formula in
Update potential points formula in
Update conditional formatting for draws in
Add “was eliminated” column to
and update conditional formatting
Update “teams remaining” formula in
Update email subject to include date
Fix bug in leaderboard points formula
Update conditional formatting for leaderboard so that the leaders are green and everyone else is blue
“Add your predictions” button on
will automatically add the user to the leaderboard
Fill out this form if you’d like email updates of current standings.
Responses won't be saved because this doc is in play mode Submit
to unsubscribe or change your email subscription settings.
JB James Booth 22 22 LT Lola Tseudonym 22 22 PR Polly Rose 21 21 JD Joel Davis 20 20 BD Buck Dubois 19 19 FM Felix Marlin 19 19
There are no rows in this table