Due to the coronavirus pandemic, European Football Championship Euro2020 is postponed till the next year. However, I have prepared a spreadsheet for the event on the initially scheduled date. In the past, the spreadsheets I published were very popular among football fans. EURO2020 Excel Sweepstake is a spreadsheet you can use to play and bet, and it has proved to be particularly popular. The formulas in the spreadsheet calculate all the points and made Sweepstake a popular game at home and to be enjoyed with work colleagues.
Feel Free to Download any Excel Spreadsheet from previous championships available below:
EURO2020 Sweepstake spreadsheet is fully automated and integrated with the Internet. It provides better user experience, thus being user friendly and it gives a possibility of setting up one’s score in each series of matches.
Manual Excel Spreadsheet Instruction
FREE EURO 2020 Excel Sweepstake Template
This is a trial version, still under development!
If you are interested get FREE version for 5 players, please send request using the button below.
If you are interested, get an Advanced version EURO2020 Excel PRO, Sweepstake for more then 5 players (20, 50, 100 versions) and a special access to advanced functions and methods used in this spreadsheet including full access to other spreadsheets. Please visit the shop using the button below.
The Excel Runner Pace Calculator, is available for download at the bottom of the article or in the Downloads tab and it offers the following functionalities:
• After declaring the Event and Distance, it automatically calculates Speed and Pace in kilometres and miles.
• After declaring the Pace and Units, it automatically calculates Speed and Time to cover popular Distances and Marathon laps.
• Converts between Pace and Speed
• Converts between SI and Imperial metrics.
• Dynamic visualisation.
• Pace band.
Definition of Pace and Speed
The Pace is the time, most often given in minutes, that is needed to cover 1 km. Alternatively, we give time to cover 1 mile or to cover a special distance, e.g. a lap.
Pace = Time / Distance [min/1km] or [min/1mil]
The Speed is the distance of time. In the SI system, we most often give the number of kilometres we manage to cover in one hour [km / h] or the number of meters per second [m / s].
Speed = Distance / Time [km/1h] or [miles/1h]
Convert miles to kilometres:
In the first argument of the function, instead of 1, we can insert the address of the cell in which the number we want to convert is given.
1 mile = 1.609344 kilometres. In Excel, the formula is used to
Setting the runner’s calculator.
Fill the yellow cells in the red border only. The rest of the spreadsheet is fully automated and write-protected.
In the upper part of the spreadsheet after declaring the Target (it is important to keep the hh: mm: ss format) and Event (from the drop-down list) the Pace and Speed in kilometres and miles are given.
2nd part of Pace Calculator setting:
Pace or time given in the correct format hh: mm: ss.
Unit to choose [kilometres] or [miles] from drop-down list.
Leap in seconds in the Pace column between rows.
Converts between Pace and Speed.
Knowing the Pace, saved in the hh: mm: ss format in an Excel cell (e.g. C15), we can calculate the Speed using the formula:
Calculating the time needed to overcome various distances based on the declared Pace. If in column C starting from C15, the pace is given in the format hh: mm: ss, and in line 15 starting from G15 the distance to do, then the formula in this case for the cell G15 looks in the following way:
The dollar symbol ($) in front of the letter C in cell addressing means that regardless of where you paste the formula, the addressing of column C will remain the same, but if it appears before the number, e.g. 15, the addressing of row 15 will remain unchanged.
The graph on the left shows the time to cover popular Event based on the declared Pace.
At the bottom of the spreadsheet there is a table with the Actual Pace declared in Miles. In the yellow fields we give the real Time achieved in individual sections of the marathon. As a result, we can control how the Plan is implemented in relation to the assumed Pace. In the Difference column, the difference when the implementation of the plan is negative is highlight in red.
Pace Band Worksheet Settings.
Set up your preferences:
Pace (hh:mm:ss format) [miles]
Strategy (drop down list)
Download Excel Runner Pace Calculator by clicking button below:
Premier League Sweepstakes is an Excel spreadsheet file created for season 2020 – 21. It allows bunch of people to run sweepstakes or office pool based on the outcomes of the matches and is fully automated. You can select interesting teams and trace their trend.
Premier League Sweepstakes Excel spreadsheet contains worksheets:
Instruction – User manual and description
Schedule – Schedule matches, results and sweepstakes (manual parts)
Tables – Premier League Tables (Fully automated)
Players – Sweepstakes Players table and visualisation by round (Fully automated)
SET – Settings teams and calculates points for selected teams.
If contestant predicted exact result 3 points
If contestant predicted the winner of the match or a draw 1 point However, you are the owner of version PRO so you can easily change the number of points in worksheet SET and you can define different points for a different round.
FREE Premier League 2019-2020 Sweepstakes Excel spreadsheet download
Please feel free to download Premier League 2019-2020 Sweepstakes. It does not require any additional software or any registration and it is also free of VBA code. Just push the button below, save the file and enjoy supporting your team and keep calm during the contest if it is possible.