JWDixon's All-Inclusive Franchise Spreadsheet

[JWDixon120]

Quote: Originally Posted by bilbobeuli

I'm trying to get back into '23, and wanted to user your spreadsheet for my franchise, especially because of the STORYLINE/EVENT GENERATORS. But I can't seem to find them in the docs file?

https://docs.google.com/file/d/13SjG...letype=msexcel

Here’s a link to an old sheet with those. I removed them from my personal one!


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

[WillieB1214]

After using word docs for years, this will make things so much easier. Thank you for this!

[cabralk]

Quote: Originally Posted by JWDixon120

If anyone still uses this tool, drop me feature requests you’d like to see added for 2024! -Franchise Fidelity to Reality Roster out Now! -Creator of JWDixon’s Franchise Spreadsheet -More coming soon!

Any insight on new features for 24? Liked the spreadsheet last year before I tapped out on the game. Looking to use it again this year.

Do you have any tips on how to use it for a 30 team control

[JWDixon120]

Quote: Originally Posted by cabralk

Any insight on new features for 24? Liked the spreadsheet last year before I tapped out on the game. Looking to use it again this year. Do you have any tips on how to use it for a 30 team control

I’ve been so busy on the roster project that I haven’t had too much time to put into the sheet.

I did add xBA and xSLG and all that jazz but it took a TON of user input for it to track and it’s just too much lol.

It shouldn’t need any specific tips for 30 team control unless you play with each team. Then I’d recommend a sheet per team.


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

[cabralk]

Definitely not much you could possibly add to the sheet anyway so time is more well spent on the roster. I'll definitely use the spreadsheet again this year I do 30 team but only play as one team. The other 29 is more to prevent unrealistic trades and offseason contracts. The work you did helps so its just plug in and generate whole lot less thinking for me lol

[JWDixon120]

Just wanted to drop an update here.

I’m going to clean up a few things and post an updated link for the spreadsheet this week.

I’ve just added a new feature to the “contract demand calculator” that now tells you if a player is willing to enter negotiations.

This was done by taking OOTP’s Loyalty and Greed ratings for every player in their database.

I’ve also used those numbers to adjust players asking price.

This should work for all players on the existing roster. Obviously your draft picks and fictional guys will not work for the “will they re-sign” portion.

I’ll likely add a way to generate a personality for those guys however.


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

[JWDixon120]

The OP has been updated with the latest link for the Spreadsheet for this year!

You'll notice the changes made to the Contract Demand calculator. This adds a little life to your roster building since not every player will be willing to re-up with your team.

[swatkins1978]

I assume we use this along with the Fidelity Reality rosters?


-SW

PS5: swatkins1978