Home
Creators
Search
Recent
Missing
Random
Posts
DMs
Tags
Random
Importer
Import
FAQ
Account
Register
Login
Favorites
Keys
Logout
Telegram
2023-24 Excel LADZ NBA Model (Patreon)
Downloads
Missing 1 full-res photo, 2 files, as this post has not yet been imported.
Content
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 to the 2023-24 data from Basketball Reference (from the 2022-23 data). Also, an Overtime function has been added to the simulations, so that any one game can have a maximum of 3 overtimes (if needed).
Important Note: As of today, there has only been around 14 games played by each team. Because this model only considers player stats recorded from the current season (and not their career stats right now), the stats will be extremely volatile. This is because it's very easy for a player to have either a good/bad stretch of games that aren't going to be representative of their true strength. As a result lads, exercise a large degree of caution in interpreting the results of the model before around games 25 - 40. The sample size is just too small using only stats from the current season.
To update the data, go into the Data tab, then press the icon 'Refresh All'. This will refresh the Power Query and automatically update the stats imported from Basketball Reference 🔥
The 'Sports Betting' worksheet captures the probability and the "intrinsic odds" of the Match, Handicap and Total Points markets. Let me know if you have any more suggestions for this lads 💪
Let me know if you have any questions/problems/suggestions lads, enjoy! More will be added to the model as well as this post very soon (i.e. written explanations, videos, etc) 👍
Files
Previews only
