G'day lads, download the MLS Excel file featured in my latest video below! đ„
Note: I've "frozen" the 10,000 simulations in the file so that it doesn't lag. To re-run the ...
2024-06-30 11:56:57 +0000 UTC View PostG'day lads! Attached to this post is a model that runs simulations to forecast the winners of the Euro and Copa América 2024 competitions, starting from the Round of 16.
The model uses ELO R...
2024-06-29 11:29:16 +0000 UTC View PostG'day lads! My next video on YouTube will be an explanation of how you can use Monte Carlo simulations in Excel to compute probabilities for betting markets in Excel đ„ I'm hoping this video will...
2024-06-21 23:31:00 +0000 UTC View PostG'day lads! I'm considering hosting a live event that would cover the basics of sports modelling in Excel... Let me know if you'd be interested! đ„
2024-06-16 11:27:03 +0000 UTC View Post
G'day lads! In this post I've added the MLS (United States), J1 League (Japan) and SĂ©rie A (Brazil) to the Excel LADZ Poisson Football Model. To add more leagues to this file, follow the steps abo...
2024-06-16 11:11:17 +0000 UTC View PostG'day lads! Attached is a video explaining how to use the attached Excel LADZ 2024 MLB Lineup Model. Please download the files below to use.
More information to come about this model; especia...
2024-06-14 12:43:34 +0000 UTC View PostG'day, lads!
I've created an MLB Model that uses daily lineups to project a team's xRuns in a matchup. This includes calculating the influence a side's pitcher and batting lineup have on thei...
2024-05-29 23:08:59 +0000 UTC View PostGâday, lads!
Football Model
Thank you all for watching my most recent video, âANALYSE Football Matches for Win %, Over/Under and Correct Score Using EXCEL! |...
2024-05-20 02:19:59 +0000 UTC View Post
G'day lads!
I've put together a model that uses the live stats and the Poisson distribution to predict EPL, LaLiga, Ligue 1, Bundesliga and Seria A games. All in one dashboard!
...
2024-05-07 20:33:00 +0000 UTC View PostG'day, lads! In the next week I'm looking to publish a YouTube video explaining how I built the 'Excel LADZ - European Football Model'. This model uses the Poisson Distribution to forecast the resu...
2024-04-25 05:20:51 +0000 UTC View PostG'day, lads
I've put together a model that uses the live stats and the Poisson distribution to predict EPL, LaLiga, Ligue 1, Bundesliga and Seria A games. All in one dashboard!
...
2024-04-22 12:12:21 +0000 UTC View PostGâday lads! An essential part of sports modelling is being able to update a model to reflect current data. In this article, Iâll run you through how I updated the âExcel LADZ - 2023 MLB Model...
2024-04-04 10:49:32 +0000 UTC View Post
G'day, lads
Attached is the Excel LADZ - 2024 MLB Model đ„
An article explaining the changes I made will be published shortly đȘ
Note: To update the data, g...
2024-04-01 11:58:08 +0000 UTC View PostGâday lads,
In this explanation Iâll go through how I built the âExcel LADZ - March Madness Modelâ using ELO Ratings.
ELO Ratings
In order ...
2024-03-19 11:05:04 +0000 UTC View PostG'day lads,
Attached is the Excel LADZ - AFL Model 2024. I'll create an article soon with an explanation of how I made the model đ
To factor in individual players into the mode...
2024-03-07 09:54:15 +0000 UTC View PostG'day, lads
UPDATE: Due to a change in the Hockey Reference Power Query within the file, I've made a small change to the model. Teams that have qualifies for the Finals will ...
2024-03-05 01:10:08 +0000 UTC View PostGâday lads! In the best sports models, the lineup of a team is considered. How you factor in changes to a lineup within a model is very important, and in this article Iâll give you some strateg...
2024-03-01 04:01:40 +0000 UTC View Post
G'day lads,
Attached is the Excel LADZ NBA Player Rebound Model (2023-24 Version) + Video Explanation.
Model Explanation: 2024-02-15 08:52:17 +0000 UTC View Post
Gâday, lads
In this article Iâll explain how I built the Excel LADZ NBA Rebound Model. A video tutorial on how to use the model is above. If you have any questions, please leave a comment...
2024-02-08 15:00:10 +0000 UTC View PostG'day lads,
Attached is the Excel LADZ 2023-24 NBA Rebound Model.
To use, simply go to the 'Result' worksheet. Select the 'Player' from the dropdown list, their 'Opposition', the ...
2024-02-04 20:05:46 +0000 UTC View PostGâday lads! In my experience, there are three important Excel functions that are important to learn! Iâll explain each one below, with an example, and how itâs useful in sports modelling.
... 2024-01-12 04:00:03 +0000 UTC View PostG'day lads, let me know what type of videos you'd like me to publish đ„ If you have a video idea, please leave a comment!
2024-01-08 23:58:09 +0000 UTC View Post
Gâday lads,
In this article Iâll run through how I built the Excel LADZ UFC Model using a process called Logistic Regression. If you have any questions, be sure to comment on the post! Th...
2024-01-04 11:26:45 +0000 UTC View PostG'day, lads
Attached is the Excel LADZ UFC Model. I've used a process called 'Logistic Regression' to use the UFC Stats website and predict the Win % of the 'Red Fighter' in a UFC bout. This ...
2023-12-31 21:40:22 +0000 UTC View Post
Gâday, lads
In this video I ran through 3 major changes to the NBA Model. Iâll summarise how I did them below.
JOIN the best Excel Sports Modelling Community by bec...
2023-12-30 21:19:56 +0000 UTC View PostG'day, lads
Attached to this post is the Excel LADZ 2023-24 NBA Model with a live win probability feature. Simply enter in the matchup, the current score and the remaining time to get an end-...
2023-12-22 11:34:02 +0000 UTC View Post
G'day, lads
In this short video above, I run through how to write some code in Power Query Editor in order to import the Club ELO Data automatically. In the YouTube video up on the channel (a...
2023-12-20 01:57:28 +0000 UTC View Post
Gâday, lads
In this article Iâll run through my process in using linear regression in Excel to predict corner kicks based on a teamâs shot and possession data.
JOIN 2023-12-14 12:40:49 +0000 UTC View Post
G'day, lads
Attached to this post is a model that uses EPL Data to predict the number of Corners in a match. The process of linear regression is used, with the predictors being Possession &am...
2023-12-05 06:06:53 +0000 UTC View Post
G'day lads,
In the video above I run through how I solved a small issue with the Excel LADZ NBA Model. In some teams, players like Jimmy Butler were showing up twice; once in the starti...
2023-12-03 05:46:27 +0000 UTC View Post