Excel LADZ - 2024 MLB Model
Added 2024-04-01 11:58:08 +0000 UTCG'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 hesitate to ask any questions you may have lads!
Comments
Hi lad, welcome π₯ A #NAME error suggest that Excel doesn't recognise a function. From my end it's working alright. Do you mind sending me screenshots of your issue via email or the Discord? That way I can see where your error is originating from π My email is ladz.excel@gmail.com π
Excel LADZ
2024-07-14 07:46:05 +0000 UTCThe live Simulation not showing and got error #NAME.
spoilbrat42
2024-07-14 07:40:04 +0000 UTCPlaying with this today. Is there a way to project pitcher statlines (ie Outs / H / K / BB)?
Ben
2024-06-11 20:55:13 +0000 UTCHi, Just joined and downloaded the 2024 MLB model. Do you have one that includes MLB pitchers and MLB starting lineups for each game daily? Seems that would be a lot more accurate??
Randy Reed
2024-05-17 21:41:39 +0000 UTCThank you! Will be looking forward to it! One last question, is there a way to weigh the last 3 games for a team into the probabilities? Teams tend to go on streaks and I wonder if that would give an advantage in calculating probabilities a tad bit more accurately. Curious to hear your thoughts!
Binoy Sheth
2024-05-11 12:07:41 +0000 UTCG'day lad, welcome! Not yet, incorporating starting pitchers will most likely the next video I make!
Excel LADZ
2024-05-11 06:11:22 +0000 UTCHey! Thanks for this, truly Is remarkable. Does this model incorporate starting pitchers as well as overall bullpens?
Binoy Sheth
2024-05-11 04:15:51 +0000 UTCHey lad, does the model happen to take into consideration starting pitchers?
Connor Rezo
2024-04-15 17:51:11 +0000 UTCπ thanks for responding
Rolf Boman
2024-04-10 20:45:53 +0000 UTCHi lad, youβre absolutely right π₯ Iβll make a short tutorial vid in the next week or two outlining these changes. In short, the model became more efficient by adding in an extended extra innings feature π Also, the live win probability was moved to be more accessible π
Excel LADZ
2024-04-09 21:39:48 +0000 UTCβLive win Probabilityβ preferably and the section in yellow beside it
Rolf Boman
2024-04-08 14:49:14 +0000 UTCHey Lad, can you make a quick tutorial on how to function the new MLB MODEL because the results page is slightly different from the older version and walkthrough video.
Rolf Boman
2024-04-08 14:41:28 +0000 UTCHi lad, welcome π₯ The probabilities are determined through simulations of the matchup. Using the Expected Runs calculated for each team, Excel runs through 1,000 simulations of the game. Simulations are necessary due to the specific rules of baseball - if the scores are tied, the innings continue. Consider the Yankees vs Dodgers. If the Dodgers win 630 simulations out of 1,000 then their Win % is 63.0%. Whenever you update a cell, select a new team, or refresh the file, Excel re-runs these simulations. As the number of simulations in the model is "only" 1,000, then probabilities will change slightly with each new lot of simulations. If I increased the number of simulations to 100,000, this change would be much lower due to the 'law of large numbers'. However, the model's performance would suffer as the file would become too slow and literally crash π₯ I hope that helps lad π Don't hesitate to ask anymore questions πͺ
Excel LADZ
2024-04-08 02:50:26 +0000 UTCHi I am a new member and I am super interested in the Excel MLB Model. How come the Probability of the teams winning keeps changing, The % of the teams winning keeps switching on me and I dont udnerstand.
Mason
2024-04-08 02:36:51 +0000 UTCHi lad, that's not good! Let's try and get this fixed up as fast as possible. If you're able to, please message me over Discord with a screenshot of your issue π
Excel LADZ
2024-04-04 10:45:46 +0000 UTCThat makes sense! Thanks for the quick reply and the work on these!
Bryan Rufo
2024-04-03 17:01:30 +0000 UTCI, I cant update datas. I m in France and can't find any existing connections in your file :(
Adrien
2024-04-03 15:16:02 +0000 UTCHi lad, Iβve left the 2023 tables in the model. These stats are unconnected from the power query, and standalone as values. This is so a team can get their ratings determined by a βsliding scaleβ. Iβve made this scale 30 games So, after one game of the 2024 season, a teamβs ATT & DEF ratings will be made up (1/30) of their 2024 performance and (29/30) of their 2023 performance. After 23 games of the 2024 season, a teamβs ATT & DEF ratings will be made up of (23/30) of their 2024 stats and (7/30) of their 2023 stats. After 30 games, a teamβs ATT & DEF strength is entirely dependent on their 2024 performance. Iβll explain more in an article detailing my changes to the MLB Model soon, but I hope this helps lad πͺ
Excel LADZ
2024-04-03 01:19:23 +0000 UTCThanks for updating the sheet! Super helpful!! One quick question though, are we able to delete the old Power Query tables from 2023, or do we have to leave them?
Bryan Rufo
2024-04-01 15:23:29 +0000 UTC
