JWDixon's All-Inclusive Franchise Spreadsheet

[JWDixon120]

Quote: Originally Posted by 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?

Gray is demanding $7m in game, but my tool suggests he should demand closer to $12m.

Which IRL Gray is on a 14m year deal so it’s close.


I use 30 team control, so when I’m making decisions to resign players, this keeps me from giving guys way less then they should be getting compared to IRL.

[LegendKillerOne]

Quote: Originally Posted by JWDixon120

Gray is demanding $7m in game, but my tool suggests he should demand closer to $12m. Which IRL Gray is on a 14m year deal so it’s close. I use 30 team control, so when I’m making decisions to resign players, this keeps me from giving guys way less then they should be getting compared to IRL.

You do very cool work on your sheet. I have an excel sheet I had set up for 30 team control a little bit more basic then yours but I have it all set with all teams entire roster and everything all the way through minors just waiting on them to put out game and drag the minor league guys up, Needs some roster updating over the past 2 weeks of moves but was waiting on the game at this point. Every roster has over 150 players on it

Check it out let me know what you think

https://docs.google.com/spreadsheets...f=true&sd=true

[JWDixon120]

Just checked it out. Looks like a great way to stay organized.

Really wish you could upload franchise data to the cloud to make a lot of this stuff more automated :/

[LegendKillerOne]

Quote: Originally Posted by JWDixon120

Just checked it out. Looks like a great way to stay organized. Really wish you could upload franchise data to the cloud to make a lot of this stuff more automated :/

Thanks, Basically what I did was I went to fangraphs/roster resource or whatever that site is that has all the roster depth charts. I paid for a year suscription was like $30, then you are able to download each teams depth chart in excel. Did that then took out the lines I didnt need and copy and paste and did not take too long

[TexasDBack]

Quote: Originally Posted by JWDixon120

Gray is demanding $7m in game, but my tool suggests he should demand closer to $12m. Which IRL Gray is on a 14m year deal so it’s close. I use 30 team control, so when I’m making decisions to resign players, this keeps me from giving guys way less then they should be getting compared to IRL.

Oh man - this is going force me to look at my "maybe I'm getting too much value for this to be an honest franchise" and stop getting tons of value for way cheaper than I should.

[JWDixon120]

Quote: Originally Posted by TexasDBack

Oh man - this is going force me to look at my "maybe I'm getting too much value for this to be an honest franchise" and stop getting tons of value for way cheaper than I should.

This is exactly why I made it lol.

I need to make a Braves toggle where it drops all demand by 7-10m a year.

[TexasDBack]

Quote: Originally Posted by JWDixon120

This is exactly why I made it lol. I need to make a Braves toggle where it drops all demand by 7-10m a year.

Is it live on the version linked on page 1? Went to check it out and didn't see a tab for it.

[JWDixon120]

Quote: Originally Posted by TexasDBack

Is it live on the version linked on page 1? Went to check it out and didn't see a tab for it.

I have to relink the correct one. I’ll do that now.