JWDixon's All-Inclusive Franchise Spreadsheet

[TexasDBack]

Oh man - that makes life so much easier. ROFL.

[JWDixon120]

Quote: Originally Posted by TexasDBack

Oh man - that makes life so much easier. ROFL.

Haha my apologies.

[bryanm1982]

Quote: Originally Posted by JWDixon120

That’s a typo. Sorry about that. It shouldn’t be sorted by overall, but alphabetically. So if it’s the 30th team, it would be the Washington Nationals.

Where is this at on the spreadsheet?

I’m looking at the scenarios and the top left gives a team name and then a number between 1-93 for player in the organization and then a number between 1-26 for player on the mlb roster.

[JWDixon120]

Quote: Originally Posted by bryanm1982

Where is this at on the spreadsheet? I’m looking at the scenarios and the top left gives a team name and then a number between 1-93 for player in the organization and then a number between 1-26 for player on the mlb roster.

Actually, you’re right.

It auto generates a team name at the top.

[TexasDBack]

Quote: Originally Posted by JWDixon120

Actually, you’re right. It auto generates a team name at the top.

You're both right. I've been reading part of this spreadsheet wrong. Total bonehead move on my part. Thanks!

JWDixon - Remind me - are you putting out an updated version for this year or rolling with what is there now? Asking so I know if I need to go re-copy it.

[JWDixon120]

Quote: Originally Posted by TexasDBack

You're both right. I've been reading part of this spreadsheet wrong. Total bonehead move on my part. Thanks! JWDixon - Remind me - are you putting out an updated version for this year or rolling with what is there now? Asking so I know if I need to go re-copy it.

Originally, I was working with another creator here for a little while to create an application to be downloaded onto your computer as a franchise companion App.

As of now plans for that are on hold due to some unfortunate events.

This project still is alive though!

[JWDixon120]

Quick update to the sheet!


I’ve created a “Contract Demand” sheet.

This works exactly like you’d think. Enter the variables I have highlighted yellow on the sheet and a players expected AAV will be returned.

This tool mainly aims to “fix” those asking demands from solid 75-82 OVR players.

These guys tend to ask for deals way lower then what we’d see IRL.

In the screenshot above, you can see how my demands line up with what these players demand in game. My demands very closely align with actual Contract data and projected contracts.

If you have any questions, let me know!

[TexasDBack]

So in the above example, would it be:

Jon Gray is demanding $12M and the spreadsheet is projecting $7M value or the other way around in that he is demanding $7M and you're projecting he is worth $12M?