*Spreadsheets* Do you guys use them?

[yankeefan1024]

Do you guys use spreadsheets to do any of the following:


- track your minor league rosters to easily keep track of promotions / demotions


- have formulas to evaluate prospects, or evaluate big league players seasons to see if they over/underperformed relative to their expected ratings or something similar to this


- or anything else you guys are using spreadsheets to track, I'd love to know - curious to see and learn from you guys how you use sheets as a sidekick to your franchises!

[ShawnSoup]

I literally just started using them this week to track my leagues financials. But I've been thinking about using them to track monthly splits, to better sit my lineups for the most optimal situations.

I've been thinking of simulating 10 years and gathering all the split data, then starting over and using the data to put the players in good situations, and seeing how they do compared to the 10 year sim.

[yankeefan1024]

Originally Posted by ShawnSoup

I literally just started using them this week to track my leagues financials. But I've been thinking about using them to track monthly splits, to better sit my lineups for the most optimal situations.

I've been thinking of simulating 10 years and gathering all the split data, then starting over and using the data to put the players in good situations, and seeing how they do compared to the 10 year sim.

nice - when you say track league financials, what kinda stuff are you tracking?

[RchW]

I micromanage league totals modifiers LTM via spreadsheet to keep my fictional leagues stat outputs in line better than auto calc.

[ShawnSoup]

Originally Posted by yankeefan1024

nice - when you say track league financials, what kinda stuff are you tracking?

Adjusting player baseline salaries every few years to reflect inflation or a new CBA I come up with, or new TV deals and media contracts. Using population growth or decline in cities and metro areas to reflect new local media contracts. Raising or lowering baseline ticket prices, based on attendance data. Creating a boom or recession.

[ShawnSoup]

Originally Posted by RchW

I micromanage league totals modifiers LTM via spreadsheet to keep my fictional leagues stat outputs in line better than auto calc.

I'm actually using spreadsheets for a similar thing. I created my own AA league and I want to compare it to an existing AA league based on stat outputs.

[yankeefan1024]

Originally Posted by ShawnSoup

Adjusting player baseline salaries every few years to reflect inflation or a new CBA I come up with, or new TV deals and media contracts. Using population growth or decline in cities and metro areas to reflect new local media contracts. Raising or lowering baseline ticket prices, based on attendance data. Creating a boom or recession.

would be curious how you go about raising or lowering ticket prices based on attendance data. what goes into this

[ShawnSoup]

Originally Posted by yankeefan1024

would be curious how you go about raising or lowering ticket prices based on attendance data. what goes into this

It's in it's infancy but I want to track league wide attendance and adjust the baseline for the league. But since I play in commish mode and control the financials for every team, I also want to track real population trends in the 30 areas the teams are located and use that to adjust the market size of each team in game. Along with the normal growth of the population overall. Take the baseline ticket price for 2020 and come up with a formula that incorporates normal inflation, attendance data, fan loyalty #, fan interest, and market sizes into ticket prices.

[CBeisbol]

I mostly use them for display purposes

I have my 40 man roster in the spreadsheet, so I can actually see all 40 of my players at once

I also have depth charts in the spreadsheet broken down by position.

I have a spreadsheet of who I expect to fill each position going into the future.

I keep a spreadsheet with my player contracts on it.

I keep a spreadsheet with my team finances on it, so I can easily see how different changes will affect the bottom line.


This is partly because I did that when I was playing Baseball Mogul and got used to seeing things in a certain way. And partially because I don't think OOTP does a real good job with some things.

[BirdWatcher]

I used to track far more about my own team and especially my prospects but as the league has progressed I find myself spending less time doing that (largely because it has become less and less necessary for me as I get to know the game, my team, my league, etc. better and better.)

What I do track on spreadsheets quite a bit now relates to things like Hall of Fame credentials for players in my league (I created my own tool to rate the chances of a player to make the Hall, based upon a number of the existing tools like JAWS, WAR, HOF Monitor, HOF Standards, etc.)

So basically where I used to use spreadsheets on a more micro, team-level I now use them more for a macro, league history and development level. (I track some things on spreadsheets for some analog processes as well, like the creation of players who are related to current players in my league and the dates of death and causes of death of former players, as well as tracking closely the performance of all first round draft picks from amateur drafts- just because I think that is fun.)

[thirdsaint]

I use my spreadsheets to track history more than anything. I have a History Recaps spreadsheet that, for each season, I put critical season events or trades in, milestones, and top achievements. This helps me to remember a season by getting a good snapshot of everything that happened and jog my memory. I also do a game-by-game recap of all my playoff games with a brief line of stats or significant events. Other tabs include top 25 in major stat areas, the history of largest contracts signed to date, and all major awards listed year by year.

My personal favorite tab is rife with formulas for the Bill James proposed Manager Ratings where a manager gets points in a given season depending on milestone their team achieves like so: four points for winning the World Series, three points for winning the pennant but not the World Series, two for a divisional title and one for each season with a record above .500. In addition, a manager gets one point for guiding his team to 20 games above .500 and a second point for winning 100 games.

This allows me to see the best managers and I'll have my own Hall of Fame for them on this tab since OOTP doesn't do a manager hall of fame yet.

I have other spreadsheets for Draft History too. Each season gets its own tab for the first round picks. I track how each pick did in terms of Championships, Major Awards and WAR total. After 10 Years I do a re-draft on that same tab to see how teams did and I also find all of the later round picks that have produced well. Its fun to see a 7th Rounder make the Re-Draft and get picked #4 overall. I may do a re-draft after 20 years too, which I finally hit with Year 21 starting in my league soon.

I have other spreadsheets that keep track of Season Records for each team, Dynasty Tracker with points assigned to teams depending on playoff results, and a Championship/Playoff Drought tracker.

Needless to say, I love Excel and OOTP.

[CBeisbol]

Originally Posted by CBeisbol

I mostly use them for display purposes

I have my 40 man roster in the spreadsheet, so I can actually see all 40 of my players at once

I also have depth charts in the spreadsheet broken down by position.

I have a spreadsheet of who I expect to fill each position going into the future.

I keep a spreadsheet with my player contracts on it.

I keep a spreadsheet with my team finances on it, so I can easily see how different changes will affect the bottom line.


I also keep track of all the trades I've been offered. This way I can see what players of mine other teams have been interested in.

Also I keep track of interesting players from when I shop players. Maybe I wasn't ready to make the deal at that moment, but I want to remember what was available.

I keep track of my prospect rankings from year-to-year. Both the OSA and my own.

Then a to-do list

And some other stuff...


This is partly because I did that when I was playing Baseball Mogul and got used to seeing things in a certain way. And partially because I don't think OOTP does a real good job with some things.

To show some examples

My 40 man roster - it's the beginning of the offseason so there's a lot of blank spaces. The players below are players that might get added. Maciera is on the 60-day DL. I just traded for Mateo and the others are minor leaguers in my system that I might add to protect from the Rule V draft. The (o)'s are options used (when they've used 3 options it looks like (ooo), which equals out of options.

My depth chart for relief pitchers. The numbers in the brackets are their overall ratings. 45/55 means 45 overall as a starter with 55 potential. [55/60] = 55 as a reliever with 60 potential.

My plan for the future. Always subject to change.

I also keep a page of transactions. With my thoughts on why I made the deal.

[cavebutter]

There was a thread I participated in (maybe I started it?) several years ago where a bunch of us shared our spreadsheets. I'm not around much anymore these days, but I may try to link it here to re-up some of the very clever work our community puts into their own games.

[cavebutter]

Share Your OOTP Spreadsheets!

[yankeefan1024]

Originally Posted by cavebutter

There was a thread I participated in (maybe I started it?) several years ago where a bunch of us shared our spreadsheets. I'm not around much anymore these days, but I may try to link it here to re-up some of the very clever work our community puts into their own games.

i found that thread and most if not all of the sheets were removed or trashed

[BillyBall]

Would love to see a spreadsheet built right into OOTP.

[nebben]

For team finances, you're manually entering the numbers, right? I do the same thing and can't believe there's not an export or Open in browser option, but I've yet to find it for team finances.

[Timofmars]

Originally Posted by yankeefan1024

Do you guys use spreadsheets to do any of the following:


- track your minor league rosters to easily keep track of promotions / demotions


- have formulas to evaluate prospects, or evaluate big league players seasons to see if they over/underperformed relative to their expected ratings or something similar to this

I use spreadsheets for pretty much these things. Using the editor in game to test things, like seeing how the stat estimates in the editor change as I change a player's attributes, I created some formulas for estimating the output of players based on their attributes, as well as potential attributes.

But then I wanted to assign some values to those estimates, like how much is a HR worth compared to a walk, etc. So I used real baseball stats to find info about how often players should be on base when a player comes up to bat, how often they score from 2nd on a single, how often players hit into double plays when a runner is on 1B, etc. This gave me a kind of a run value for each action.

I also created a lineup sheet that give values for how well players can get on base, advance other runners, etc. I can enter the lineup on the spreadsheet and it will tell me how many runs I should expect. It also handles the 1st inning as a special case, since you know that the 1st batter will have nobody on base, etc. And it estimates having a last inning where the batters higher in the lineup have greater chances of getting one extra AB compared to the others. Actually there are 2 lineup sheets, using attributes vs LHPs and vs RHPs.

I also have estimates of what kind of defensive position ratings player can achieve with experience at a position, given their defensive attributes. I can put my whole minor league into the spreadsheet and see what position they can be best in. I also can show how far they have to go in their development for the attribute that has the most still yet to be learned, and estimate how much they'd have to gain each year before reaching 26 years old. This is good for predicting which prospects have a better chance of reaching their potential.

For pitching, I also generate some numbers to tell how many runs a pitcher should give up relative to other pitchers. I also have a number for how well they do with bases empty, compared to an average situation (so giving up HRs or allowing contact is more dangerous with men on base, while walks may not be so bad). I also show their difference in pitching to LHB vs RHB. I also can show how much better they are pitching as a starter compared to coming on as a reliever, although this is a hassle since to get the data, I have to switch each player to the SP role and then the RP role. Though all of this data is quite useful, and it's why in my current game Blake Snell is my reliever of the year for 4 consecutive seasons instead of being an SP.

[Klew1986]

Originally Posted by CBeisbol

I mostly use them for display purposes

I have my 40 man roster in the spreadsheet, so I can actually see all 40 of my players at once

I also have depth charts in the spreadsheet broken down by position.

I have a spreadsheet of who I expect to fill each position going into the future.

I keep a spreadsheet with my player contracts on it.

I keep a spreadsheet with my team finances on it, so I can easily see how different changes will affect the bottom line.


This is partly because I did that when I was playing Baseball Mogul and got used to seeing things in a certain way. And partially because I don't think OOTP does a real good job with some things.

This all sounds amazing. I would love to see some of these spreadsheets. I love numbers and excel. I have a fictional game going and want to dig deeper into it.

[Syd Thrift]

I got white-out all over my bedsheets! You think your Commodore 64 is really neato! What kind of chip you got in there, a Dorito?