Category Archives: sport

EURO2020 Excel Sweepstake

EURO2020 Excel Sweepstake

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:

Updates EURO 2020 Sweepstake

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.

FREE EURO 2020 Excel Sweepstake Template

If you are interested get FREE version for 5 players, please send request using the button below.

Download Free

EURO2020 SWEEPSTAKE PRO 20 

If you are interested, get an Advanced version EURO2020 Excel PRO, Sweepstake for 20 players and have a special access to advanced functions and methods used in this spreadsheet including full access to other spreadsheets, please Buy Now  using the button below.

£5

If you have any request do not to hesitate to contact me on 07761 716 681

Excel Pace Calculator

Excel Pace Calculator

Excel Kalkulator Biegacza
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:

=CONVERT(1,"mi","km")

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:

=24/(C15*24)/24

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:

=($C15*24)*G$13/24

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)
    • Positive Split
    • Even Splitting
    • Negative Split
  • Deviation [%]

Download Excel Runner Pace Calculator by clicking button below:

Download Free

You can learn similar tips and tricks in Excel at a comprehensive Training in London.

Premier League Sweepstakes Excel spreadsheet

Premier League Sweepstakes Excel spreadsheet

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.

Excel Premier League
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.

Sweepstakes rules

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.

Download Free

Advanced version PRO

If you are interested in buying an advanced version of Premier League 2020-21 PRO 20, Sweepstake for 20 players, not protected by password, therefore you have a special access to advanced functions and methods used in this spreadsheet including easy settings point by round, please click button below Buy Now.

£9