JWDixon's Sabermetric Lineup Optimizer

[JWDixon120]

Here's a tool I made that is very easy to use.

Just enter your 9 starters for your upcoming gameday and this tool will optimize your lineup for maximum performance (sabermetrically).

This could be really useful for the guys out there who like to set their opposing team's lineup before each game.

The tool favors guys who *points to Peter Brand* "Get on base". It also prioritzes getting your high SLG guys AB's with runners on base. Speed factors in slightly.

https://docs.google.com/spreadsheets...it?usp=sharing

The sheet is linked above. To use it, click File in the top left, then make a copy. Once you have a copy, you're good to go!

[franch1se]

Re: JWDixon's Sabermetric Lineup Optimizer

I understand there is ZERO correlation between this tool and how I played, but i found it funny i tried this out and i only had ONE hit and got shut out haha

[Cycloniac]

Re: JWDixon's Sabermetric Lineup Optimizer

Here's a tool I made that is very easy to use.

Just enter your 9 starters for your upcoming gameday and this tool will optimize your lineup for maximum performance (sabermetrically).

This could be really useful for the guys out there who like to set their opposing team's lineup before each game.

The tool favors guys who *points to Peter Brand* "Get on base". It also prioritzes getting your high SLG guys AB's with runners on base. Speed factors in slightly.

https://docs.google.com/spreadsheets...it?usp=sharing

The sheet is linked above. To use it, click File in the top left, then make a copy. Once you have a copy, you're good to go!

Been looking for something like this for a while, very cool.

Excited to try it out!

[JWDixon120]

Re: JWDixon's Sabermetric Lineup Optimizer

I understand there is ZERO correlation between this tool and how I played, but i found it funny i tried this out and i only had ONE hit and got shut out haha

Whenever you win I’ll take credit. When you lose it’s definitely not my fault.


-Franchise Fidelity to Reality Roster out Now! (MLB 24)
-Creator of JWDixon’s Franchise Spreadsheet
-More coming soon!

[JWDixon120]

Re: JWDixon's Sabermetric Lineup Optimizer

I understand there is ZERO correlation between this tool and how I played, but i found it funny i tried this out and i only had ONE hit and got shut out haha

Oooh also what team are you using? Interested to see how your lineups shake out.

I tested it on 7-8 teams and thought the results turned out decent with where guys were.


-Franchise Fidelity to Reality Roster out Now! (MLB 24)
-Creator of JWDixon’s Franchise Spreadsheet
-More coming soon!

[Cycloniac]

Re: JWDixon's Sabermetric Lineup Optimizer

So, when setting the CPU's lineups to manual, the CPU will still cycle in guys from the bench when it's main lineup is tired right?

I'm trying to remember how that works.

[qwazwsxedc]

Re: JWDixon's Sabermetric Lineup Optimizer

I can't even download it to try it out, what am i doing wrong

[tc020791]

Re: JWDixon's Sabermetric Lineup Optimizer

So, when setting the CPU's lineups to manual, the CPU will still cycle in guys from the bench when it's main lineup is tired right?

I'm trying to remember how that works.

CPU will sub guys in prior to the game if someone is below about 30% energy whether you have lineups on AUTO or MANUAL. The issue with this is that they will completely redo the lineup, rather than just subbing out the tired guy. Meaning they will leave in the well rested guys but they will completely change the batting order if they sub even 1 guy.

The only way to combat this to check the CPU lineup in the pre game lineup menu. If I see anyone below 30% energy I will back out of the game and go into the lineup screen in the franchise menu. I will take out anyone in the lineup that I know the CPU will be taking out due to needing rest. I will also put guys at DH who have about 50% energy to make sure they play all 3 games in a series.

One thing I do recommend is saving your franchise before you start every game. Sometimes the CPU will sub guys out for a reason besides rest. For example, Player X is only hitting .125 vs lefties this year, or Player Y on the bench hasn’t played in over a week and the CPU wants them to get them playing time. The cool thing about this feature is that it is NOT pre coded into the game. Meaning it doesn’t happen every time you play the same game. Therefore if you saved the franchise prior, you can close the app and reload the franchise. I can almost guarantee the CPU will not pull said player for performance issues this time around.

[JWDixon120]

Re: JWDixon's Sabermetric Lineup Optimizer

I can't even download it to try it out, what am i doing wrong

You’re not supposed to download anything.

You need to open the link to Google sheets, then make a copy of the sheet to edit it.


-Franchise Fidelity to Reality Roster out Now! (MLB 24)
-Creator of JWDixon’s Franchise Spreadsheet
-More coming soon!

[Cycloniac]

Re: JWDixon's Sabermetric Lineup Optimizer

CPU will sub guys in prior to the game if someone is below about 30% energy whether you have lineups on AUTO or MANUAL. The issue with this is that they will completely redo the lineup, rather than just subbing out the tired guy. Meaning they will leave in the well rested guys but they will completely change the batting order if they sub even 1 guy.

The only way to combat this to check the CPU lineup in the pre game lineup menu. If I see anyone below 30% energy I will back out of the game and go into the lineup screen in the franchise menu. I will take out anyone in the lineup that I know the CPU will be taking out due to needing rest. I will also put guys at DH who have about 50% energy to make sure they play all 3 games in a series.

One thing I do recommend is saving your franchise before you start every game. Sometimes the CPU will sub guys out for a reason besides rest. For example, Player X is only hitting .125 vs lefties this year, or Player Y on the bench hasn’t played in over a week and the CPU wants them to get them playing time. The cool thing about this feature is that it is NOT pre coded into the game. Meaning it doesn’t happen every time you play the same game. Therefore if you saved the franchise prior, you can close the app and reload the franchise. I can almost guarantee the CPU will not pull said player for performance issues this time around.

Hmm, so if you want to set the lineups for the other teams, is it wiser to do manual still then?

What happens if a player gets hurt? Do you get notified that x team's lineup is incomplete?

I've never done lineups for the other teams, so curious about pros and cons before I set them all.

[tc020791]

Re: JWDixon's Sabermetric Lineup Optimizer

Hmm, so if you want to set the lineups for the other teams, is it wiser to do manual still then?



What happens if a player gets hurt? Do you get notified that x team's lineup is incomplete?



I've never done lineups for the other teams, so curious about pros and cons before I set them all.

Basically if you set the lineups to AUTO the CPU will do whatever it wants based off their own stipulations. If you put it on MANUAL they will only change a lineup if there’s an injury or a call up. Even if the injured player isn’t a starter, sometimes they will mess with the lineup anyway. But if the injured player is a starter, and you have CPU lineups on MANUAL, it will tell you that there are invalid lineups for said team. If there are no injuries or call ups for a team, the lineup should stick for the whole time. My suggestion would be to double check every team maybe once a week, or twice a month. Like every Monday or something. 90% of the lineups will still be exactly how you left them. This logic also applies to the CPU pitching rotation.

[Cycloniac]

Re: JWDixon's Sabermetric Lineup Optimizer

Basically if you set the lineups to AUTO the CPU will do whatever it wants based off their own stipulations. If you put it on MANUAL they will only change a lineup if there’s an injury or a call up. Even if the injured player isn’t a starter, sometimes they will mess with the lineup anyway. But if the injured player is a starter, and you have CPU lineups on MANUAL, it will tell you that there are invalid lineups for said team. If there are no injuries or call ups for a team, the lineup should stick for the whole time. My suggestion would be to double check every team maybe once a week, or twice a month. Like every Monday or something. 90% of the lineups will still be exactly how you left them. This logic also applies to the CPU pitching rotation.

Do you ever change the lineups for the CPU teams? Say player x is struggling, do you move them down?

I know on AUTO, the CPU will do stuff like that, but on MANUAL, I'm assuming no.

[tc020791]

Re: JWDixon's Sabermetric Lineup Optimizer

Do you ever change the lineups for the CPU teams? Say player x is struggling, do you move them down?



I know on AUTO, the CPU will do stuff like that, but on MANUAL, I'm assuming no.

Definitely. I will start the season based off what you would normally see IRL. Then I will adjust as the year goes on based off how well they’re doing in game. I especially take a deep look at the team I’m playing that series, want to make sure I get their best effort.

[franch1se]

Re: JWDixon's Sabermetric Lineup Optimizer

Oooh also what team are you using? Interested to see how your lineups shake out.

I tested it on 7-8 teams and thought the results turned out decent with where guys were.


-Franchise Fidelity to Reality Roster out Now! (MLB 24)
-Creator of JWDixon’s Franchise Spreadsheet
-More coming soon!

I'm using the Padres and vs a RHP it entered:

Ha-Seong Kim
Jake Cronenworth
Manny Machado
Xander Bogaerts
Fernando Tatis Jr
Donovan Solano
Jurickson Profar
Jackson Merrill
Luis Campusano

I personally want Tati hitting at the top of the lineup so I'll probably swap him with Cronenworth or Kim if i used the tool again.

[JWDixon120]

Re: JWDixon's Sabermetric Lineup Optimizer

I'm using the Padres and vs a RHP it entered:

Ha-Seong Kim
Jake Cronenworth
Manny Machado
Xander Bogaerts
Fernando Tatis Jr
Donovan Solano
Jurickson Profar
Jackson Merrill
Luis Campusano

I personally want Tati hitting at the top of the lineup so I'll probably swap him with Cronenworth or Kim if i used the tool again.

Hmm. Guess it depends on your roster ratings as well.

Using our FFTR roster, with that same starting 9 vs RHP I get:

1. Tatis Jr.
2. Cronenworth
3. Machado
4. Bogaerts
5. Profar
6. Kim
7. Solano
8. Merrill
9. Campusano