Templates/Spreadsheets For Roster Management?

American_Ernesider · 08-15-2015, 11:45 AM

I have noticed on more than a few occasions mention of using some type of spreadsheet to track the roster, make decisions, etc. I am getting to that point where I think this would be really helpful...plus giving me something offline when I am not able to play the game.

Do any templates or specific spreadsheets exist that you utilize or have created?

Thanks as always with all of my questions.

olivertheorem · 08-15-2015, 08:06 PM

I have one with pitchers, catchers, infielders, and outfielders each on their own tab. I have planned position, current ratings, and potential ratings for each player in the org, along with a personal "overall" rating I made up for myself based off the individual ratings (largely because I often can't make heads or tails of OOTP's overall ratings.

sreem · 08-16-2015, 06:44 PM

Quote:

Originally Posted by olivertheorem

I have one with pitchers, catchers, infielders, and outfielders each on their own tab. I have planned position, current ratings, and potential ratings for each player in the org, along with a personal "overall" rating I made up for myself based off the individual ratings (largely because I often can't make heads or tails of OOTP's overall ratings.

Would you mind sharing it for others to use?

olivertheorem · 08-16-2015, 09:14 PM

I suppose I could do that. It's attached here. The fields that end in "p" are potentials, everything else is currents. Pitching is straightforward, just a straight average of the 3 pitching ratings (I have stamina and groundball rating there for reference only). Hitters are more complicated. The overall is 4 parts hitting (straight average again), 2 parts defense, and 1 part baserunning (straight average). That's the formula that made the most sense to me when I developed it, and it's worked well enough.

The defensive component includes both fielding ratings and position rating, so that for any two players with the same defensive rating, the one with better overall tools gets a higher rating.

In my experience, anybody over around 40 for potential (1-100 scale, though 45 works for 20-80) can be reasonably expected to be a useful MLB player.

sreem · 08-16-2015, 10:34 PM

This is great, thanks for sharing your work with us!

olivertheorem · 08-16-2015, 11:34 PM

Glad to help. You can make the updating easier if you change the single name field to one each for first and last name. That way you can sort by last name the way the game does when you view all players in org by position. The way I have it, it's not so simple. I just haven't changed it for myself yet.

08-15-2015, 11:45 AM	#1
American_Ernesider Major Leagues Join Date: Dec 2003 Posts: 365	Templates/Spreadsheets For Roster Management? I have noticed on more than a few occasions mention of using some type of spreadsheet to track the roster, make decisions, etc. I am getting to that point where I think this would be really helpful...plus giving me something offline when I am not able to play the game. Do any templates or specific spreadsheets exist that you utilize or have created? Thanks as always with all of my questions.

08-16-2015, 10:34 PM	#5
sreem All Star Reserve Join Date: Jul 2013 Posts: 673	This is great, thanks for sharing your work with us! __________________ "What doesn't kill you only makes you stronger. Except for bears....."

08-15-2015, 08:06 PM	#2
olivertheorem All Star Starter Join Date: Jun 2006 Posts: 1,919	I have one with pitchers, catchers, infielders, and outfielders each on their own tab. I have planned position, current ratings, and potential ratings for each player in the org, along with a personal "overall" rating I made up for myself based off the individual ratings (largely because I often can't make heads or tails of OOTP's overall ratings.

08-16-2015, 11:34 PM	#6
olivertheorem All Star Starter Join Date: Jun 2006 Posts: 1,919	Glad to help. You can make the updating easier if you change the single name field to one each for first and last name. That way you can sort by last name the way the game does when you view all players in org by position. The way I have it, it's not so simple. I just haven't changed it for myself yet.