OOTP and Excel

Spracks · 11-17-2012, 08:56 AM

I am always creating Excel spreadsheets to keep track of various things in OOTP, from player progression to depth charts to overall evaluation. These tend to get complicated and often confusing, and a lot of the time don't really accomplish anything. I think I saw a thread the other day where someone had a pretty interesting looking spreadsheet with what looked like a customized way to evaluate players, with different weights given to each rating. I saw a Mod for OOTP11 that read the .dat files, which looked to be exactly what I wanted, but it doesn't work for OOTP 13. So my question is, what are some of the ways you use Excel to enhance your OOTP experience? Have you made any spreadsheets that make analyzing data easier? Show off what you've created!

Spracks · 11-20-2012, 08:46 AM

I would also be interested in any databases you have put together in Access or other software!

Marinersfan51 · 11-21-2012, 11:33 AM

I put together a HOF voting system in an excel document. It simulates voting and progression each year and does a decent enough job of mimicking actual HOF voting, however it is a little cumbersome to run.

11-17-2012, 08:56 AM	#1
Spracks Minors (Rookie Ball) Join Date: May 2009 Posts: 33	OOTP and Excel I am always creating Excel spreadsheets to keep track of various things in OOTP, from player progression to depth charts to overall evaluation. These tend to get complicated and often confusing, and a lot of the time don't really accomplish anything. I think I saw a thread the other day where someone had a pretty interesting looking spreadsheet with what looked like a customized way to evaluate players, with different weights given to each rating. I saw a Mod for OOTP11 that read the .dat files, which looked to be exactly what I wanted, but it doesn't work for OOTP 13. So my question is, what are some of the ways you use Excel to enhance your OOTP experience? Have you made any spreadsheets that make analyzing data easier? Show off what you've created!

11-20-2012, 08:46 AM	#2
Spracks Minors (Rookie Ball) Join Date: May 2009 Posts: 33	I would also be interested in any databases you have put together in Access or other software!

11-21-2012, 11:33 AM	#3
Marinersfan51 All Star Reserve Join Date: Dec 2009 Posts: 777	I put together a HOF voting system in an excel document. It simulates voting and progression each year and does a decent enough job of mimicking actual HOF voting, however it is a little cumbersome to run.