It should be fun to play a prediction game among your friends while watching 2021 Copa America soccer tournament that will be held in Argentina and Colombia in June. And by using this Copa America Sweepstake spreadsheet, you don’t have to define rules nor create your own spreadsheet. It is equipped with features and formulas that will help you managing your pool with ease. All you have to do just set the spreadsheet in the beginning, start predicting and collecting score predictions, and let the embedded excel formulas do the rest.
You can download the spreadsheet before reading this instruction below. It is easy to use and it is compatible with Excel 2007 and above version either in Windows or Mac environment.
Setup the Game
Set the game points by filling point tables in respective boxes in group and Knock Out round stages. You can set regular points with different values for these 2 stages. There are 3 criteria to earn points, those are :
– Predict win/draw/lose and score results correctly
– Predict win/draw/lose with correct goal differences
– Predict win/draw/lose with incorrect goal differences
You can set those 3 criteria to have different values or you can apply one criteria only by zeroing other 2s, or you can apply one point value for any correct match results regardless of its scores.
Besides regular points, you can set bonus points for predicted correctly :
o Group Winner, Runner Up, 3rd and 4th Place
o Number of teams that advance to KO rounds
o Champion, Runner Up and 3rd Place of the tournament
Set your knock out game scenario in this 2021 Copa America Office Pool spreadsheet. There are two options you can select.
1. Actual Matches
If you select this option, teams in knock out rounds in each player’s tables will be the same with teams that qualified in this tournament. This game type is suitable for you who manage a small group of players where they like to predict the game match-by-match. And it will give each players new opportunities to earn points and win the game even though they don’t perform well in group stages.
2. Player Prediction Matches
This option will pair teams in knock out bracket based on teams that are predicted will be qualified by each players. The advantage of this type is each players can predict all matches at once, while the disadvantage is they shall lose opportunities to earn more points in knock out rounds if their teams are not the same with real ones.
It is up to you to decide this game setup. If you don’t want to apply this bonus points, you can set those values to zero.
Type your player names in Player Scoreboard worksheet. Remember to differentiate similar player names to prevent any errors in player ranking calculation. Furthermore, their entry order will decide final tie-breaker regulation for final standings.
Fill Player Scores
Type player prediction scores in Game Board worksheet. You can start with Player 1 table. Remember that this Pool only compares Full time score only. It is possible to have a draw result in Knock Out stages, where the matches have to be decided with penalty kick. Correct penalty kick prediction won’t be take into account. But it is needed to be filled to decide team that will advance to the next round.
Fill Actual Scores
Update tournament matches results by typing actual score results in respective score boxes in the leftmost table in Game Board worksheet. Points for each player will be shown automatically after you filled them.
Track Player Standing
You can track your player standing after every matches in Player Leaderboard worksheet.
Try the free version of Copa America 2021 Sweepstake spreadsheet. This free version can accommodate maximum 10 players only. You can upgrade it to 100 players by purchasing the paid version that you can accessed in About worksheet or from the author site.
Copa America Predictor Game V2.0 - Free Version (540.4 KiB, 300 hits)