Explore

Euro 2020 Prediction Pool

Use this doc to run a prediction pool for Euro 2020 with your friends and family

This is a full tournament prediction pool (submit your predictions for group play and knockout rounds before group play begins).

If you want a 2-stage prediction pool, check out

Euro 2020 Prediction Pool Template (2-Stage)⁠

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.

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).

Changelog

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⁠

⁠

Update “was eliminated” column formula in

Countries⁠

⁠

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 9pm PDT

Update email subject to include date

Update total entry formula in rules

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

Rules

10

⁠

per entry

⁠

8

⁠

entries * $

10

⁠

= $

80

⁠

total entry

Maximum points =

176

⁠

Highest point wins 50% of total entry ($

40

⁠

)

2nd highest point wins 30% of total entry ($

24

⁠

)

3rd highest point wins 15% of total entry ($

12

⁠

)

4th highest point wins 5% of total entry ($

4

⁠

)

In case of a tie in points, the total number of goals scored during the tournament will be used as tie breaker. Prediction closest to the correct answer wins.

Scoring System