Tag Archives: Premier League

Premier League Sweepstakes Excel spreadsheet

Premier League Sweepstakes Excel spreadsheet

Premier League Sweepstakes is an Excel spreadsheet file created for season 2018 -2019. 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.

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 different round.

FREE Premier League 2018-2019 Sweepstakes Excel spreadsheet download

Please feel free to download Premier League 2018-2019 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 2018-19 PRO, Sweepstake for 50 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.

Premier League fixtures Excel spreadsheet

Premier League fixtures Excel spreadsheet

Premier League fixtures Excel
Premier League fixtures Excel is a fully automated spreadsheet that contains a schedule of Premier League fixtures. The dynamic tables will automatically update each time you enter a set of results. The table index retrieves data from all matches. In addition, one of the worksheets contains a table which only considers the games played at home. Another table considers only the games played away from home. In other cases, the system used in the spreadsheet sorts the teams in the tables depending on the number of points scored, goal difference and a number of goals scored. In addition, I have posted the dynamic result table, allowing you to clearly track the results of matches between teams.

The methodology used in the application

The spreadsheet user completes only the results of matches in cells designed for this purpose, highlighted in bright yellow. There is an additional table with the corresponding formulas that counts the points, goals scored, goals conceded and the goal difference per team in the following three cases, all matches, home game and away games. For this purpose, I used the SUMAIF, COUNTIF and SUMIFS functions. In addition, I used the RANK function, which based on the criteria, assigns the appropriate position for each team. To ensure that the teams are sorted correctly, I have used a very popular function VLOOKUP, which will assign the appropriate team to a specific position in the table and all the individual items will be stored in the table in the correct order.

FREE spreadsheet download

Please feel free to download Premier League fixtures Excel spreadsheet. It does not require any additional software or any registration. It is also free of adverts and VBA code. Just push the button below, save the file and enjoy supporting your team.

Download Free

If you are interested Premier League and Championship for 2017-18 season, please visit here.