JWDixon's All-Inclusive Franchise Spreadsheet

[JWDixon120]

Re: JWDixon's All Inclusive Franchise Spreadsheet

A little update here with some ideas I want to add on and will be implementing soon.

-Power Rankings with numbers showing weekly movement

-Player Regression Adjustor
•in default MLBTS any player over the age of 31-32 seems to fall off a cliff regression wise. This tool will aim to help that depending on player performance.

[kinsmen7]

Re: JWDixon's All Inclusive Franchise Spreadsheet

A little update here with some ideas I want to add on and will be implementing soon.

-Power Rankings with numbers showing weekly movement

-Player Regression Adjustor
•in default MLBTS any player over the age of 31-32 seems to fall off a cliff regression wise. This tool will aim to help that depending on player performance.

Ouuu, I like this! The constant plummet of Mike Trout over the years has been maddening.

I haven't made it far enough in '22 to see anything wild, but I thought they were supposed to have made it so progression/regression was tied *more* into stats?

[JWDixon120]

Re: JWDixon's All Inclusive Franchise Spreadsheet

Ouuu, I like this! The constant plummet of Mike Trout over the years has been maddening.

I haven't made it far enough in '22 to see anything wild, but I thought they were supposed to have made it so progression/regression was tied *more* into stats?

It’s been buffed to an extent. But I also have seen Julio Rodriguez go from hitting .312 with 42 Homers to being out of the league by the end of next year.

It still seems way too random. Max Scherzer in my test sims would start the first 2 months of the year with 5-2 with a 2.2 ERA and 11 K/9 and his overall would go from 92 to and 85 with -6 in every category.

I began working on it last night. It’s going to be performance based on last 2 years of production.

[JWDixon120]

Re: JWDixon's All Inclusive Franchise Spreadsheet

Just an update here.

The sheet is going to be going through some major changes in the near future to get it prepared for 2023.

I’ll update you all when it’s ready!

[kinsmen7]

Re: JWDixon's All Inclusive Franchise Spreadsheet

I'm having a blast screwing around with the IFA generator. Obviously I'm nowhere close to being at that point of my franchise, but I just saw a 5'5'', 210 lbs LH switch hitting 1B from Venezuela that would be a hilarious add.

I'm paying a bit more attention to my scouting this year, and was cruising through the blue chip guys just to see what might be available to me when I pick, and there's a prospect that is an 18 year old SS who's 5'6'' who's 235 lbs, and is considered MLB ready next year, with above average speed and crazy good defence. That's the type of hilarious video game stuff that will keep me entertained.

[JWDixon120]

Re: JWDixon's All Inclusive Franchise Spreadsheet

I'm having a blast screwing around with the IFA generator. Obviously I'm nowhere close to being at that point of my franchise, but I just saw a 5'5'', 210 lbs LH switch hitting 1B from Venezuela that would be a hilarious add.

I'm paying a bit more attention to my scouting this year, and was cruising through the blue chip guys just to see what might be available to me when I pick, and there's a prospect that is an 18 year old SS who's 5'6'' who's 235 lbs, and is considered MLB ready next year, with above average speed and crazy good defence. That's the type of hilarious video game stuff that will keep me entertained.

Haha yeah man the IFA Generator will toss out some crazy Heights and Weights. Unfortunately excel limitations kept me from correlating them very well.

So occasionally you’ll get a randy Johnson who is 6’10 and 180 LBS lol

[kinsmen7]

Re: JWDixon's All Inclusive Franchise Spreadsheet

Haha yeah man the IFA Generator will toss out some crazy Heights and Weights. Unfortunately excel limitations kept me from correlating them very well.

So occasionally you’ll get a randy Johnson who is 6’10 and 180 LBS lol

As someone who was once 6'5'', 155 lbs (the beer has helped me fill out over the years to a solid 220 ), I appreciate the heck out of it. Give me all of the tall lanky's, and the short square dudes. Having a Alejandro Kirk sized speedster is a gamers dream.

[IndianSummer]

Re: JWDixon's All Inclusive Franchise Spreadsheet

As someone who was once 6'5'', 155 lbs (the beer has helped me fill out over the years to a solid 220 ), I appreciate the heck out of it. Give me all of the tall lanky's, and the short square dudes. Having a Alejandro Kirk sized speedster is a gamers dream.

Age will help to fix that lanky problem

[TexasDBack]

Re: JWDixon's All Inclusive Franchise Spreadsheet

Wow! What an amazing sheet! Thank you for putting this together.

Quick question: I normally don't turn on 30 team control, but if you wanted to do the scenarios - wouldn't that be required? Then also just turn the rest on auto? Just checking so I can start a new franchise and run some water through these pipes.

[JWDixon120]

Re: JWDixon's All Inclusive Franchise Spreadsheet

Wow! What an amazing sheet! Thank you for putting this together.

Quick question: I normally don't turn on 30 team control, but if you wanted to do the scenarios - wouldn't that be required? Then also just turn the rest on auto? Just checking so I can start a new franchise and run some water through these pipes.

Yeah 30 team control is definitely needed for the scenarios I believe!

[bryanm1982]

Re: JWDixon's All Inclusive Franchise Spreadsheet

You can do some of the storylines on single team control but you would have to have everything happen to your own team.

[kinsmen7]

Re: JWDixon's All Inclusive Franchise Spreadsheet

You can do some of the storylines on single team control but you would have to have everything happen to your own team.

I think anything trade wise would probably end up being not-so-great...The trade engine in this game is so bad, that you'd likely either end up ripping off the CPU, or, alternatively, yourself.

[bryanm1982]

Re: JWDixon's All Inclusive Franchise Spreadsheet

I think anything trade wise would probably end up being not-so-great...The trade engine in this game is so bad, that you'd likely either end up ripping off the CPU, or, alternatively, yourself.

Yeah, the only thing you could do is the injuries and player rating changes.

[TexasDBack]

Re: JWDixon's All Inclusive Franchise Spreadsheet

Yes, 30 team control is the way to go.

If you're open to it, just another suggested area, but I might be unique in these items that I manage:

- Full Roster View
- Position Outlook

So, as an example, my standard spreadsheet (which is very manual and no way near as awesome as yours), includes my entire roster.

For POS players I track:
POS, Name, Age, OVR, POT, League, Salary, Years Left on Contract (or team control), On 25 Man?, On 40 Man?, Options Used, Eligible for Rule 5? and Other Positions Playable

For Pitchers it is the same except no other positions played and typically add a couple key stats I like to know.

I only update this page when I make a transaction or once a year when everything ages up. This makes it very easy to look at my roster and have ideas about who I have coming up in the future, how much time I have vs filling a need now etc. Or do I have a gap of a couple years I need to go solve for while my new hot thing develops in AA for a bit.

The other view that I have is that I have a 5 year outlook for each position. this helps me know if I have guys coming up or blocked that I can trade out easier than looking around in game.

[kinsmen7]

Re: JWDixon's All Inclusive Franchise Spreadsheet

Yes, 30 team control is the way to go.

If you're open to it, just another suggested area, but I might be unique in these items that I manage:

- Full Roster View
- Position Outlook

So, as an example, my standard spreadsheet (which is very manual and no way near as awesome as yours), includes my entire roster.

For POS players I track:
POS, Name, Age, OVR, POT, League, Salary, Years Left on Contract (or team control), On 25 Man?, On 40 Man?, Options Used, Eligible for Rule 5? and Other Positions Playable

For Pitchers it is the same except no other positions played and typically add a couple key stats I like to know.

I only update this page when I make a transaction or once a year when everything ages up. This makes it very easy to look at my roster and have ideas about who I have coming up in the future, how much time I have vs filling a need now etc. Or do I have a gap of a couple years I need to go solve for while my new hot thing develops in AA for a bit.

The other view that I have is that I have a 5 year outlook for each position. this helps me know if I have guys coming up or blocked that I can trade out easier than looking around in game.

I like this. I've got my roster set up as the 26 man + other relevant contracts (Ie. I've got Ryu on my roster, but he's not at the MLB level until he *hopefully* stays healthy in the minors until July). So, with my calculation of the MLB payroll, his is included.

I definitely think I'll add to it now that you've brought it up though.