Excel and sports

Euro 2021 Excel Spreadsheet Pool

Excel Euro 2021

We are back with the “Excel Euro 2021”, after launched four years ago the Excel of the Euro 2016 in France. We’ve already published several excel of national team tournaments (in spanish) such as Excel World Cup Russia 2018 and Excel Copa America Brazil 2019, as well as the main club tournaments: Excel Champions 2020-2021 (avalaible in English).

We are already counting the days to start this summer to be able to organice the typical pool at work, in the bars, with the group of friends, etc. The purpose of this excel is to help you in your group with the Euro 2021 pool. Also this summer there is a new edition of the America’s Cup and of the Gold Cup. You can also use it as an excel simulator or predictor of the Eurocup and see what would happen with different results.

The draw for the Eurocup took place on November 30, 2019, but the last four teams have been known until March 2021.

Since 2016 when we published the first file until this year we have improved the use of the excel. For example 4 years ago in case of a draw in a group you had to change a result if you didn’t like the order of the group. Now in case of a draw you can select the order in a group as well as the order of the third ranked in each group. (In the instructions are the criteria used). Another new feature is that you can select the times according to the country you have chosen, also we`ve added the flags of the countries participating in the group stage.

Once again I would like to thank SandruskDesign for their advice on the design, I don’t know how the design would have looked without her help. I thank her again for her availability and collaboration.

Predictor Excel Eurocup

Using the file is so simple: in the group stage you only have to fill in the grey cells with the results you think will be given. In case of a draw between two or more teams in the group, the order of those teams can be selected.

From the eighths onwards the crosses are automatically placed and the grey boxes must be filled in. In case of a draw, two extra grey boxes will be opened at the sides, to undo the draw. At the end you have to write down who you think will be the best player, the top scorer and the best goalkeeper. I leave you a file about how it works and the instructions to organize a pool with your group.

The file can serve as a fixture, pool, simulator (you can make calculations with the results to see who would rank according to the results).

Download Excel file Eurocup Pool 2021

Comments on the Excel Euro Pool 2021

In addition, for those of you who want to manage the Eurocup 2020 Excel pool, you can also use the pool manager file along with the instructions.

Download the ADMINISTRATOR file

Comments to the administrator’s file:

THERE IS NO A BETTER WAY to set the scores, because each one has its pros and cons, so I encourage you to comment on how you are going to put them in your group with a screenshot so that people can see it, and also if you want to comment.

As always, any correction, suggestion, comment you want to make is welcome. You can comment anything related to the Euro, the rules you use in your group, where you are from, how many people you are, how you make the bets, suggest scores, etc. Thank you very much in advance.

ENJOY!

If it has been of your interest you can collaborate with a small donation.

Exit mobile version