JWDixon's All-Inclusive Franchise Spreadsheet

[bryanm1982]

Quote: Originally Posted by JWDixon120

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

That would be awesome to do. I just don’t know how we can do the last 10 game by formula. I know it is sum(offset) but it doesn’t count letters only numbers. So we would have to do 1 for win and 0 for loss, I think. And it doesn’t like blank spaces. It screws it up. But I like going by dates so you can just keep going across the spreadsheet entering the scores.

[kinsmen7]

If one of you fools isn’t an accountant, or tied in to the financial industry somehow with your love of excel, I’ll eat my hat 😂

My boss is a CA (She’s my CFO), and will turn a friggin’ 3 item to-do list into a well thought out spreadsheet 😂

[JWDixon120]

Quote: Originally Posted by kinsmen7

If one of you fools isn’t an accountant, or tied in to the financial industry somehow with your love of excel, I’ll eat my hat My boss is a CA (She’s my CFO), and will turn a friggin’ 3 item to-do list into a well thought out spreadsheet

Hahah I’m a General Contractor. Just love numbers

[bryanm1982]

Quote: Originally Posted by kinsmen7

If one of you fools isn’t an accountant, or tied in to the financial industry somehow with your love of excel, I’ll eat my hat 😂 My boss is a CA (She’s my CFO), and will turn a friggin’ 3 item to-do list into a well thought out spreadsheet 😂

I’m in customer service and don’t deal with too much excel. Google was my friend lol

[bryanm1982]

If you guys decide to do the game log, I would suggest to make a new blank one and always use that for a template. So you don’t have to keep deleting stuff. I have a couple different franchises going so I’ll have a different spreadsheet for each team.

Some notes:
If you delete your stats in the game log, you will have to delete each player at a time. You do not want to delete the column that has the running averages and ERA. You’ll delete the formula. So it is tedious to delete a player at a time.

The standings, you only want to delete the W/L and runs scored and runs against columns. Deleting the game number column will screen things up.

I separated the pitchers cause the google sheets would become ridiculously slow on my phone with all those formulas.

[JWDixon120]

Quote: Originally Posted by bryanm1982

If you guys decide to do the game log, I would suggest to make a new blank one and always use that for a template. So you don’t have to keep deleting stuff. I have a couple different franchises going so I’ll have a different spreadsheet for each team. Some notes: If you delete your stats in the game log, you will have to delete each player at a time. You do not want to delete the column that has the running averages and ERA. You’ll delete the formula. So it is tedious to delete a player at a time. The standings, you only want to delete the W/L and runs scored and runs against columns. Deleting the game number column will screen things up. I separated the pitchers cause the google sheets would become ridiculously slow on my phone with all those formulas.

Yeah I spent about an hour fooling with it before even Excel on my pretty beefy PC started to slow down so I decided to leave it out.

[JWDixon120]

Quote: Originally Posted by bryanm1982

I’m in customer service and don’t deal with too much excel. Google was my friend lol

ChatGPT basically built the IFA generator for me lol.

[JWDixon120]

Quote: Originally Posted by JWDixon120

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

Update on this. I was able to add in power rankings that takes into account each teams overall win %, last 10, and Overall Run Diff

User just has to input each teams Wins/Losses, and RS/RA

Also they will need to add in each teams Last 10 in the format of 6-4 or 2-8 etc. I have formulas that break out this format and generate power rankings.

Just waiting on one of my buddies to format the sheet to make it look really slick.


For example, here are the Power Rankings it generated using the end of last seasons data. As you can see, the format is pretty ugly but it will look incredible once my friend has it finished!