Blog

League Table In Excel with Monte Carlo Predictions Update

During the World Cup break, I made some changes to the Interactive League Table with Monte Carlo Predictions. The goal is to use as little VB macro codes in the spread sheets as possible. The newly posted league tables are the results of this update. What has Changed? What hasn’t Changed? Return to the Download…

Continue reading League Table In Excel with Monte Carlo Predictions Update

Premier League Table In Excel with Monte Carlo Predictions

I am happy to introduce the 2022/23 Premier League Table In Excel. The Excel tables are available in two versions. The first version includes Monte Carlo Predictions of the teams standings. This version was first introduced in 2018. The Monte Carlo simulations and the league table were implemented with Excel VBA macros. It includes the…

Continue reading Premier League Table In Excel with Monte Carlo Predictions

Free Download Interactive League Table in Excel with Predictions

In the 2022/23 soccer season, the following European leagues are supported: Premier League. Championship League. England League One. Bundesliga. France Ligue 1. La Liga. Interactive League Table in Excel with Predictions calculates the Win, Draw and Loss probabilities of each fixture.  Based on the calculated probabilities, the spread sheet will predict the score of each…

Continue reading Free Download Interactive League Table in Excel with Predictions

The Math Behind Premier League Score Prediction

I recently developed an Excel spreadsheet that simulates the Premier League table.  This is quite an interesting process. The overall predicting steps are well documented by other sources.  However, most of the detailed algorithms, are not widely discussed or documented.  It took me some time to come up with my own methods and algorithms.   I…

Continue reading The Math Behind Premier League Score Prediction

Serie A Table in Excel With Monte-Carlo Predictions

Serie A Interactive Table in Excel for 2021/22 Season. The Excel tables are now available in two versions. The first version includes Monte Carlo Predictions of the teams standings. The Monte Carlo simulations and the league table are implemented with Excel VBA macros. It includes the following features. League Fixtures sorted by Match Day. Printable…

Continue reading Serie A Table in Excel With Monte-Carlo Predictions

La Liga Table in Excel With Monte-Carlo Predictions

La Liga Interactive Table in Excel for 2022/23 Season. The Excel tables are now available in two versions. The first version includes Monte Carlo Predictions of the teams standings. The Monte Carlo simulations and the league table are implemented with Excel VBA macros. It includes the following features: League Fixtures sorted by Match Day. Printable…

Continue reading La Liga Table in Excel With Monte-Carlo Predictions

Bundesliga Table in Excel With Monte-Carlo Predictions

Bundesliga Interactive Table in Excel for 2022/23 Season. The Excel tables are now available in two versions. The first version includes Monte Carlo Predictions of the teams standings. The Monte Carlo simulations and the league table are implemented with Excel VBA macros. It includes the following features: League Fixtures sorted by Match Day. Printable Match…

Continue reading Bundesliga Table in Excel With Monte-Carlo Predictions

Ligue 1 Table in Excel With Monte-Carlo Predictions

Ligue 1 Interactive Table in Excel for 2022/23 Season. The Excel tables are now available in two versions. The first version includes Monte Carlo Predictions of the teams standings. The Monte Carlo simulations and the league table are implemented with Excel VBA macros. It includes the following features: League Fixtures sorted by Match Day. Printable…

Continue reading Ligue 1 Table in Excel With Monte-Carlo Predictions