All my followers and subscribers on YouTube know how to simulate sports games on Excel. It’s time you know how to 🔥 Follow @excel_ladz to become a lad 💪
Check out my new website! If you or your business need a spreadsheet built, fill out the ‘Request a Quote’ form and I’ll get back to you ASAP 😉 https://t.co/fFcNNGpRLZ
What's up lads! I just started an Instagram page 🔥 To celebrate, I'm picking 5 people who like, follow and comment their favourite Excel function to win a free 1 month membership to the Excel LADZ Patreon. Follow here: https://t.co/OZ8TaPrb4U
@ySaiintz It just involves replacing the Power Query with the 24-25 Stats. Of course, by becoming a member, I could help you through any of the problems you may encounter doing this 😃 As the season starts in a couple of days anyway, I'll post the 24-25 Model in about a week 💪
For fun, in the men's race I've got:
🥇 @kenny_bednarek
🥈 @LylesNoah
🥉 @ObliqueSeville
Become a member of the Excel LADZ Patreon to learn more about sports modelling! 🔥
Wondering how you can create odds for the 100m final at Paris 2024? Unlike runs or points, time is a continuous variable ⏱️ So, a runner's expected time can be distributed along a normal distribution with a particular variance; depending on how consistent the runner is...
If you have confidence in your model, some runners may be undervalued 😉 For example, if @fkerley99 has a 20% chance according to your model, but his odds are $10.00 (or +900), that trade would have a Positive Expected Value, providing profit in the long term 💴
The LET function of Excel has proven really useful for me lately. For example, you can calculate the Win % of a team using the Poisson distribution process in only ONE CELL. It's able to do multi-step calculations in the one formula, great for saving space 🔥 #Excel#let#data
@Stunner23 For sure lad 👍 I’m trying to develop a model which does this, taking into account the defensive strength of a player’s direct opponent. I’m hoping this‘ll make the model more accurate. Btw, you can simulate player points using the current NBA Model on YT (using a data table)
@SniperJones03 Thanks lad, you could combine the 22/23 season with 23/24 data, or just grab only 23/24’s data off of Basketball Reference. If you’re doing the former, make a new sheet that adds stats between the years for each unique player, and then match them to their current team.
G’day lads, there’s a “Join Free” option on the Excel LADZ Patreon now 🔥 By signing up, you’ll be notified whenever I post and have downloadable access to a few basic models for free 💪 Take a look here: https://t.co/3jz130v9BE
Once you’ve managed to obtain an accurate ELO Rating for every team, it’s possible to simulate individual matches as well as the whole season (to see a teams probability of winning the Super Bowl).