Quote:
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.