How to Use Excel LADZ 2024 MLB Lineup Model!
Added 2024-06-14 12:43:34 +0000 UTCG'day lads! Attached is a video explaining how to use the attached Excel LADZ 2024 MLB Lineup Model. Please download the files below to use.
More information to come about this model; especially on the statistics used to build it (as well as future updates).
Let me know if you have any questions lads ๐ฅ
Comments
No problem! Just bringing it to your attention :)
OhLawdy 1
2024-10-07 21:10:49 +0000 UTCThanks for the comment mate. Apologies, it seems Baseball Monster has stopped uploading their daily lineups to their website. As a result, the Power Query in the spreadsheet is pulling in nothing. To fix this, Iโll look into whether other websites are useful. If not, then for the last month of the season, lineups may have to be entered manually. Iโm looking to come up with a solution in the next couple of days ๐ Sorry for the inconvenience.
Excel LADZ
2024-10-07 21:04:43 +0000 UTCHappening for me, too.
OhLawdy 1
2024-10-07 20:59:27 +0000 UTCI've been using this model for some time now with about 60% accuracy, which is great! The issue today is that it is no longer pulling the games, as we are not in the playoffs. Is there a way to modify the query? "This Web query returned no data. To change the query, click OK, click the arrow on the name box in the formula bar, click the name of the external data range for the Web query, right-click the selection, and then click Edit Query."
J. Deisch
2024-10-02 02:25:09 +0000 UTCWhen I change the Pitcher confidence value even as much as 45% I don't see the xRuns change.
Gary Michalske
2024-08-31 17:42:50 +0000 UTCHey mate! Is there a way to increase the number of simulations? I'd like to up it to 10k but would that just totally brick the spread sheet?
Nate Contreras
2024-08-14 21:04:26 +0000 UTCsimulated box score doesnt make sense to me when i refresh it? what are the numbers in each inning, because the run totals in the box score do not add up to the total score of the game below?
Shawn Collins
2024-08-05 21:33:15 +0000 UTCHey can you update this spreadsheet to 2024 data because itโs giving me ERAs for pitching from 2023 Nรฉstor cortes for Yankees is giving NA played 20 games which is not accurate
Camilo Garcia
2024-07-20 15:23:20 +0000 UTCHi lad, do you know what version of Excel you have? Right now, the file uses array functions such as XLOOKUP and LET, which are only available to Excel 2019 users and later. Versions of Excel 2016 and prior do not recognise these functions, and may return a #NAME? error. Let me know if you need anymore help lad ๐
Excel LADZ
2024-07-14 09:42:45 +0000 UTCNot working at all
spoilbrat42
2024-07-14 08:04:47 +0000 UTCCan you add other ligue? for example KBO KOREA
Victor Saul Parra Rodriguez
2024-06-29 05:05:29 +0000 UTCcan you add other ligue? For example KBO korea del sur
Victor Saul Parra Rodriguez
2024-06-29 05:04:42 +0000 UTCAll done now mate, if you re-download the file the issue shouldn't happen again. I actually performed an XLOOKUP function with multiple criteria to return the starts, ERA and FIP for the starting pitcher. This made it easy to filter out all other pitchers (with the same name) on other teams.
Excel LADZ
2024-06-16 03:24:10 +0000 UTCHello, it's working now; it was my mistake; I didn't modify the global settings for the dot instead of the coma. Thank you for your help and for your valuable content (videos and models), that help learning.
Frederic Soloy
2024-06-15 05:59:13 +0000 UTCNo worries ๐ช That's hilarious, what are the chances! I'll add in an extra criteria in the FILTER function for that cell, so the player returned is also filtered by the team selected. This will return the correct Logan Allen. To do this, I'll equate the team names in the dropdown list of the "Dashboard" worksheet and the 3 letter team codes in the "Player Pitching Data" worksheet. By making a table of these names, I can use an XLOOKUP function to match the long team name to the abbreviation, and filter out the wrong Logan Allen. I'll let you know when this change is up and running lad ๐ For now, you can either write over the top of the formula with a manual FIP value for the proper Logan, or just change the pitcher confidence to 0% and it won't take into account the pitcher's stats.
Excel LADZ
2024-06-14 23:28:48 +0000 UTCHi lad, that's unusual ๐ค If you keep having this problem, please send me a screenshot through Discord so we can work out the issue. Make sure that you have a version of Excel that is Excel 2019 or newer, and you have decimal places as a "." instead of a "," ๐ Don't hesitate to ask for more help lad!
Excel LADZ
2024-06-14 23:25:38 +0000 UTCthanks mate! found a funny glitch of sorts today. for todays Cleveland game Logan Allen is starting but the sheet is loading stats for Logan Allen who pitches for Arizona. Is there a way to fix the model loading up the wrong duplicate name?
Nate Contreras
2024-06-14 21:28:19 +0000 UTCWhich game?? I will see if mine it doing it.
Randy Reed
2024-06-14 20:02:03 +0000 UTCHello, thanks for the updates. I ran into a problem. On the pitchers model, I did refresh all on data. I enter teams to play to day, it's the right pithers name, but on the cells O1 and O3, there is no value, '#VALUE', withe a warning box : "A value used in the formula is of the wrong data type". And it do the same in other cells depending on this ones.
Frederic Soloy
2024-06-14 15:55:21 +0000 UTC
