Skip to content
Euro 2020 Prediction Pool Template (2-Stage)
Euro 2020 Prediction Pool
My Predictions
Calendar
Predictions Overview
Prediction Data By Person
Knockout Rounds
Data
More
Share
Explore

icon picker
Euro 2020 Prediction Pool

Use this doc to run a prediction pool for Euro 2020 with your friends and family
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
Euro 2020 Prediction Pool Template (Tournament)
⁠
.

Instructions

⁠
Copy this doc
⁠
⁠
⁠
Delete all predictions
⁠
in your new copy
⁠
Add yourself
⁠
to the
Leaderboard
⁠
and add your predicted total goals (used as tiebreaker).
Go to
My Predictions
⁠
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
Match List
⁠
.
(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
Knockout Rounds
⁠
and fill in your predictions in
My Knockout Predictions
⁠
.

Changelog

June 23 at 2:40pm PDT
Update “Teams” formula in
Team Predictions
⁠
⁠
Update “Predictions” in
Countries By Round
⁠
⁠
Update previous stage (hidden column) for Champion row in
Scoring System
⁠
⁠
June 15 at 7:20pm PDT
Add conditional formatting to “Prediction” column in
Countries By Round
⁠
⁠
June 15 at 8:25am PDT
Update email subscription handling to send one email bcc’ing all recipients (avoid “too many requests” error)
June 13 at 12:15pm PDT
Summary: Update eliminated teams after each knockout match instead of after the knockout round is complete
Add “loser” column to
Matches
⁠
⁠
Update “eliminated teams” and “expected count” formulas in
Knockout Teams
⁠
and add row for Round of 16
Update “was eliminated” column formula in
Countries
⁠
⁠
Hide “Points” column in
My Knockout Predictions
⁠
⁠
June 12 at 12:45pm PDT
Update “max possible points” column formula in
Leaderboard
⁠
⁠
June 12 at 8am PDT
Update potential points formula in
Predictions
⁠
⁠
Update conditional formatting for draws in
Round Robin Predictions
⁠
⁠
June 11 at 11:30pm PDT
Add “was eliminated” column to
Countries
⁠
and update conditional formatting
Update “teams remaining” formula in
Predictions Overflow
⁠
⁠
June 11 at 8:30pm PDT
Update email subject to include date
June 11 at 5pm PDT
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
My Predictions
⁠
will automatically add the user to the leaderboard

Scoring System
0
Stage
Teams
Max Points
Scoring System
1
Round Robin
36
36
1 point for each correct match result (Win, Loss, or Draw)
2
Quarter Final
8
32
4 points for each correct team advancing to the Quarter Final (Final 8)
3
Semi Final
4
32
8 points for each correct team advancing to the Semi Final (Final 4)
4
Final
2
20
10 points for each correct team advancing to the Final (Final 2)
5
Champion
1
12
12 points for the correct Champion
No results from filter
132
Sum
⁠

Email Updates

Fill out this form if you’d like email updates of current standings.

Email Frequency
​
Responses won't be saved because this doc is in play modeSubmit
⁠

Go to
Email Subscription
⁠
to unsubscribe or change your email subscription settings.


Leaderboard Chart
2
⁠


Leaderboard
2
Person
Points
Max Possible Points
Predicted Champion
1
James Booth
22
22
​
2
Lola Tseudonym
22
22
​
3
Polly Rose
21
21
​
4
Joel Davis
20
20
​
5
Buck Dubois
19
19
​
6
Felix Marlin
19
19
​
There are no rows in this table
⁠


Want to print your doc?
This is not the way.
Try clicking the ⋯ next to your doc name or using a keyboard shortcut (
CtrlP
) instead.