G’day lads,
Attached to this post is a free spreadsheet which shows how to use the Excel LADZ NBA Model to pick up the probabilities and ‘Intrinsic Value’ of three popular betting markets. Spoiler; they can all be found using the SUMPRODUCT function!
JOIN the best Excel Sports Modelling Community by becoming a ...
2023-11-24 15:00:10 +0000 UTC View Post
G'day lads,
Attached below is the 2023-24 update of the Excel LADZ NBA Model. It has both the Normal file as well as the Legacy Version for those without access to functions such as XLOOKUP and SEQUENCE. Both files perform the same function.
All that was involved was updating the Power Query in the model. That is, changing the stats ...
2023-11-17 21:36:21 +0000 UTC View PostG'day lads,
Attached below is a basic NFL ELO Model. It is exactly based off of the 538 NFL Model, which is no longer available to view on their website (so I decided to recreate it). Here's a link to the complete explanation of 538's NFL Model: 2023-10-06 12:00:41 +0000 UTC View Post
G'day lads, I've created a 'Fixture & League Table Generator' on Excel where you can input a number of teams as well as the amount of games they play against each other. The file will then produce a competition fixture list, as well as a compiled table of the results (after you've entered the scores for matches). All you will have to input a...
2023-09-19 22:45:27 +0000 UTC View PostG'day lads, attached below is the Excel LADZ 2023-24 NRL Finals Model. If you have any questions, please comment or message!
I will be updating this post with my message plus any tips on how to use/update the model.
2023-09-11 03:35:43 +0000 UTC View PostG’day lads, I’m planning on releasing an NFL individual match simulator, as well as a full-season NFL model soon. Have a read lads!
Using ELO Ratings
A common approach to model NFL games is to use the ELO method. ELO Ratings are essentially an overall power rating of a team, relative to a league average. For exam...
2023-09-07 05:08:03 +0000 UTC View PostG'day lads,
Attached below is the Excel LADZ file which simulates the 2023 AFL Finals Series. Take a look! Comment on the post or send me a message through Patreon or Discord if you have any questions/problems with the file 👍
2023-09-05 09:09:28 +0000 UTC View PostG’day lads, I’m glad I was able to release the 2023/24 EPL Simulation Model to YouTube. If you have any questions regarding the model, ask me here or on Discord! Also, it would help to have a look at the ‘11 August Weekly Update’, where I run through the model step-by-step.
2023/24 NBA In-Season Tournament Model 2023-08-19 11:33:27 +0000 UTC View Post
G’day lads, as you will have seen, the Excel LADZ - EPL 2023-24 Simulator has been published on the Patreon page! The video explaining how to build it will hopefully be uploaded in the next few days. Below are the steps I took to create the EPL Model:
G'day lads, attached is the file for the Excel LADZ EPL 2023-24 Season Simulator. Note that the Legacy version (for users 2016 and later) will be released shortly, along with a comprehensive explanation of the file in the Weekly Update. If the file takes too long to load, it is because the simulations (1,000 seasons) have made your computer lag....
2023-08-08 12:02:26 +0000 UTC View PostG’day lads, I’m very excited to announce that the Excel LADZ 2023 Women’s World Cup Model will be published onto YouTube on Friday, the 4th of August! As mentioned in last week’s weekly update, the model takes into account a nation’s FIFA World Ranking, and then uses a formula to simulate the knockout stages.
English Prem...
2023-08-01 08:17:56 +0000 UTC View PostG'day lads, attached is an Excel file that uses the Women's FIFA World Ratings to simulate & predict the 2023 Women's World Cup Knockout Stages. Here's the link to the video: https://www.youtube.com/watch?v=P0stJr6V5Vg
Follow the steps to use:
1. ...
2023-07-28 02:45:13 +0000 UTC View PostG’day lads, Part 1 of the NBA In-Season Tournament model has been released onto YouTube. Part 2, which includes simulating the knockout phase of the tournament, will be published within the next couple days. If you have any questions about the model (already available on the Patreon page), don’t hesitate to post them on this post or on Disco...
2023-07-24 11:03:12 +0000 UTC View PostG'day lads, I've constructed an Excel model to predict the scores for the Australian Football League (AFL). In this basic file, simply select two teams, and their Expected Points along with their Probability of Winning will appear! See the file attached below! Constant updates will happen to this file, as I add more and more features (e.g. venue...
2023-07-21 12:14:47 +0000 UTC View PostG’day lads, I’m excited to release the NBA In-Season Tournament video on Thursday, 20 July. As the model has already been posted to Patreon, I’ll run through the reasoning behind it.
The first step was deriving an attacking and defensive strength of each team. For this, I used the 2022-23 NBA Season stats. To work out a team’s atta...
2023-07-18 03:58:41 +0000 UTC View Post
G'day lads, the file attached attached is just the Excel LADZ 2023 MLB Model, with a worksheet added named 'Sports Betting'. It includes three simple calculations: money line, over/under total runs and the run line. They are really simple calculations, and you can take a look at them below 👍
2023-07-16 05:14:09 +0000 UTC View Post
G'day lads, the Excel model attached predicts the 2023-34 NBA In-Season Tournament Based off of the 2022-23 NBA season stats. The model has 1,000 simulations, so it may slow your spreadsheet down. To fix this, you lads can always reduce the number of simulations in the 'Simulations' worksheet 👍
2023-07-12 10:24:28 +0000 UTC View Post
G'day lads, this video is a quick tutorial on how to update your Excel LADZ - Beginner Football ELO model daily.
2023-07-12 03:13:45 +0000 UTC View PostG’day lads, I hope you enjoyed the MLB Model released onto Excel LADZ. The model is inherently basic, and only involves two core steps:
This second step may be complicated to grasp for some. Why not use a r...
2023-07-10 11:06:11 +0000 UTC View Post
G'day LADZ, learn how to Predict MLB Matches using Baseball Stats and an appropriate Probability Distribution. Excel file attached!
Update: G'day lads, the MLB Model is now available to download for users with Legacy Excel versions (i.e. any versions of Excel before dynamic array formulas were introduced such as Excel 2016).
2023-07-07 08:29:48 +0000 UTC View Post
G'day LADZ, learn how to use Linear Regression to Predict Football Matches with Possession on Excel! Excel file attached!
2023-06-17 06:52:00 +0000 UTC View Post
G'day LADZ, learn how to make an interactive Sports League Table on Microsoft Excel! Excel file attached.
2023-06-17 06:49:01 +0000 UTC View Post
G'day LADZ, learn how to EASILY Predict Football Matches using pre-calculated ELO Ratings! Excel file attached!
Link to Football Club ELO Ratings Upcoming Games API: api.clubelo.com/Fixtures
2023-06-17 06:44:13 +0000 UTC View Post
Learn how to transform league standings into a predicative model using the Poisson Distribution on Microsoft Excel! Excel file attached!
2023-06-17 06:40:58 +0000 UTC View Post
G'day LADZ, learn how to Predict NBA Games using Player Statistics and the binomial distribution on Excel! Excel file attached!
2023-06-17 06:35:35 +0000 UTC View Post
G'day LADZ, learn how to predict NFL Player Touchdown Props using statistics on Microsoft Excel. Excel file attached!
2023-06-17 06:27:26 +0000 UTC View Post
G'day LADZ, learn how to predict The Australian Open using Excel! Excel file attached!
2023-06-17 06:21:19 +0000 UTC View Post
Learn how to import live website data into Excel using a Power Query! File attached LADZ!
2023-06-17 06:15:42 +0000 UTC View Post
G'day lads, this video provides a step by step tutorial on how to create the popular game Keno. Excel file attached!
2023-06-16 00:28:53 +0000 UTC View Post
Learn how to predict the outcomes of a sporting fixture through using probability in Excel! Excel file attached!
2023-06-16 00:19:39 +0000 UTC View Post