Excel LADZ: October 2024 Update (Patreon)

G’day, lads! It’s been another great month for the community! In September, Excel LADZ hit 300,000 views and 4,400 subscribers on YouTube. Furthermore, there are 2,700 free & paid members signed up to the Patreon.

A large part of this growth has been driven by the release of the ‘Excel LADZ - 2024 NFL Model’ on YouTube. While a long video, it’s a very comprehensive tutorial on how to use team stats to calculate probabilities in a matchup. Its connection to the internet through Power Query also allows for quick and easy daily analysis, eliminating the need to manually copy and paste new data each day.

If you haven’t already, download the ‘Excel LADZ - 2024 NFL Model’ here: https://www.patreon.com/posts/excel-ladz-2024-111333965

Next YouTube Video: Excel Bet Tracker

Following the success of the NFL video, my next upload on YouTube will most likely be a tutorial on building a Bet Tracker in Excel. To make the Bet Tracker as useful as possible, I’d like the spreadsheet to:

• Make entering bets (to track) as easy and smooth as possible.

• Analyse the user’s performance across different bet types, sports, and time periods to identify trends, strengths and areas for improvement

• Be visually appealing with clean, organised layouts and dynamic charts.

An inspiration for this video is the following tutorial: https://www.youtube.com/watch?v=z26zbiGJnd4

While I’ve explored the mathematical side of sports modelling for the last month, I’m hoping I can add some Excel-specific knowledge to the Patreon while building this project.

2024-25 NHL & NBA Model

Of course, I’m still very much focused on bringing the lads insight into the statistical side of sports modelling! In October, this will start with the creation of the 2024-25 versions of the NHL and NBA models.

At the start of each season, the models will remain the same, using the same formulas as the 2023-24 versions to calculate probabilities. However, to adapt to the new season, I’ll implement a trailing window of data. Early on, the models will incorporate data from last season, but as the season progresses, the team strength will gradually rely more on the current season’s data.

Thanks for reading, lads! Please leave any questions you might have below. If you haven’t already, I hope you’ll consider upgrading to a paid membership. More to come!