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 simulations for new odds in the "Analysis" worksheet, delete the existing simulations and run the 'Data Table' like I did in the video after pressing ...
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 Ratings to give each team a Win % in a matchup. To refresh the ELO Ratings, select the 'Refresh All' icon in the 'Data' tab. This will update the file'...
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 be filmed and released on YouTube within the next week.
Meanwhile, attached is the script and a model projecting the winner of MLS. The file d...
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 above in the video!
Attached are the models below. If you do not have access to array formulas in Excel, please download the "Legacy" file. Let me ...
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; especially on the statistics used to build it (as well as future updates).
Let me know if you have any questions lads đ„
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 their expected performance. The model (using array formulas) is attached below!
An article & video explaining how I built this model will be rel...
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! | Tutorialâ. The video has reached over 2,000 views in its first two weeks; a new channel record!
Download this mod...
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!
Note: The 'Normal' uses array functions that are only available to Excel 2019 users and later. However, the 'Legacy' file should work for ALL...
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 results of matches from the EPL, LaLiga, Ligue 1, Bundesliga and Serie A đ„
There are two versions of the file: one with more efficient array form...
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!
UPDATE: Both 'Normal' and 'Legacy' files have been uploaded! The 'Legacy' file should work for ALL versions of Excel đȘ
Simply selec...
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â to be ready for the 2024 season.
JOIN the best Excel Sports Modelling Community by becoming a member of the Excel LADZ Patr...
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, go into the 'Data' tab and select the "Refresh All" icon. Wait for the simulations to refresh and the file to load completely.
Please don't hesit...
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 to build a simulation model, you need to be able to define the strength of each team prior to the game starting.
Usually this would involv...
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 model, go into the 'SuperCoach Squads' worksheet where you can select the players for each team.
If you have any questions lads, please let me know ...
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 now have an asterisk, *, next to their name.
Attached to this post is the Excel LADZ - NHL Model. Navigate to the 'Result' worksheet, where you ...
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 strategies!
JOIN the best Excel Sports Modelling Community by becoming an Official Member of the Excel LADZ Patreon! Receive downloada...
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: https://www.patreon.com/posts/98061524
If you have any questions, please ask below đȘ
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!
JOIN the best Excel Sports Modelling Community by becoming a member of the Excel LADZ Patreon! Receive downloadable access to...
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 player's 'Expected Minutes Played' and whether the game is at 'Home'. To see Over/Under probabilities, use cell F11 to change the threshold.
To ...
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.
JOIN the best Excel Sports Modelling Community by becoming an O...
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! The Excel file is attached to this post.
Collecting Data
I collected the UFC Fight Data from the following link: 2024-01-04 11:26:45 +0000 UTC View Post
G'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 will be the next video on the channel đš
To use the model, go to each fighter's profile on UFC Stats. This is the link to Sean Stricklan...
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 becoming a member of the Excel LADZ Patreon! Receive downloadable access to every model (including the Excel LADZ NBA Model) as well as technical posts, ...
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-of-game Expected Score as well as Win %'s for both teams. This will be my next video đš
If you have any questions lads, let me know in t...
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 (and in the model posted to Patreon), the user is required to copy and paste the data into the model everyday. To save time, I've created code in the vi...
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 the best Excel Sports Modelling Community by becoming a member of the Excel LADZ Patreon! Receive downloadable access to every model (including the...
2023-12-14 12:40:49 +0000 UTC View PostG'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 & Shot Data.
I'm planning for this to be the next video uploaded to the channel đš
The 'Result' worksheet has a compilation of odds off...
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 starting lineup and once on the bench. This is obviously an error, and has been fixed. The Excel LADZ NBA Model files on the original post have been updated...
2023-12-03 05:46:27 +0000 UTC View Post