JWDixon's All-Inclusive Franchise Spreadsheet

[bryanm1982]

Quote: Originally Posted by JWDixon120

Hey man, do you mind linking me your sheet? I’d love to add this to the official spreadsheet. Sounds like a fantastic addition.

Yeah, I’ll attach it. I took some pages out and put it in my own. So you can just place those pages into your original one. I didn’t want to use everything.

For standings, I have a game log so I go through the calendar and put the scores in each game. It tells you in the main standings the current win/loss streak. Can’t figure out how to get record of the last 10 games without doing a simple 1 or 0 for wins and losses.

[JWDixon120]

Quote: Originally Posted by bryanm1982

I’m decent with excel but I don’t know if there is a function where you can have it where if it’s certain height you can only a limited weight. But if you do have a 5’9 guy the game won’t let you go over like 230 lbs. If it generates a left handed hitter and his contact and power numbers are higher against LHP I’ll switch them.

There is a way to correlate height and weight, that’s what I did to an extent but it gets really math intensive lol. Not sure if I got the Brian power for that one

[bryanm1982]

https://docs.google.com/spreadsheets...0c_fiZxTc/edit

Here is the standings.

[JWDixon120]

Quote: Originally Posted by bryanm1982

https://docs.google.com/spreadsheets...0c_fiZxTc/edit Here is the standings.

When I get home I’ll add these into the main sheet and credit you!

[bryanm1982]

https://docs.google.com/spreadsheets...xd9SQ3-CU/edit

Here is the stats.

[kinsmen7]

Quote: Originally Posted by JWDixon120

It’s yours to use man. Change whatever you see fit! Send me over any good ideas you may have too. I’d love to make this a community sheet with a ton of features! And yeah the IFA generator can sometimes generate some crazy heights and weights. It’s really hard to nail those down with Excel Limitations. But you can always decide if a generated prospect is too unrealistic to add!

I kind of tailored it towards the details that I wanted to track, basically turned it into a "Dynasty Hub", so I've added:

-A top prospects tab which I think I'll either adjust, or re-evaluate a couple of times a year. I'll likely expand it a bit to include the leagues top 30 or 50 at some point, but that's down the road. Given that I'll have prospect stats, my plan is likely to do opening day/trade deadline/offseason lists to track progress. I'm going to leave my own list at 15 players because anything more will likely be too tedious. I don't put a ton of stock into a players overall rating, but I'm going to use it to try to track the growth percentage of my prospects.
-An area for me to journal/ramble off my own thoughts (Sometimes I need to read my own thoughts in order to evaluate whether they're good, or really, really stupid...).
-I separated the transactions tab into two separate tabs...team transactions and notable league transactions.
-The game already has a trade block, but I wanted to expand on it a bit, mainly to document what my potential team needs are, and if I've addressed them or not. Basically a way to keep me on task with team management instead of just upgrading everything at once.
-Going to try to track year over year payroll a bit tighter. Added a few columns here and there to track my budget & profit/loss. Probably not important to many, but I'm hoping to try to mirror MLB payroll growth to some degree...ie, I'm not the Mets so I'm not going to suddenly triple my payroll. I know the budget function sort of works for this, but I'd like to track my yearly (and maybe I need to re-evaluate it after each deadline?) payroll to track growth. I'm trying to search back for the past 2-3 years of it to add as well, but haven't made any progress with that.

I don't know...I've only just started tinkering. I'd imagine I'll come up with some more bone-headed ideas to add while I'm bored at work, but for now, this is a game changer to my franchise mode experience, and I appreciate the heck out of it!

Edit: Mannnn I hate Excel for being a pain in the butt, but also, I love what it can create hahaha.

[kinsmen7]

Quote: Originally Posted by bryanm1982

Yeah, I’ll attach it. I took some pages out and put it in my own. So you can just place those pages into your original one. I didn’t want to use everything. For standings, I have a game log so I go through the calendar and put the scores in each game. It tells you in the main standings the current win/loss streak. Can’t figure out how to get record of the last 10 games without doing a simple 1 or 0 for wins and losses.

I wonder what kind of Excel Witchcraft could be done to make it spit out some sort of power rankings, based on something like a 10 game sample compared to the teams actual win %?

[JWDixon120]

Quote: Originally Posted by kinsmen7

I wonder what kind of Excel Witchcraft could be done to make it spit out some sort of power rankings, based on something like a 10 game sample compared to the teams actual win %?

I can definitely add this in. The math on it wouldn’t be too hard to figure out.

Would just take a lot of user input to input each teams WL for their past 10