What cool external things do you do to track or analyze your franchises?

BigCountryBumgarner · 04-03-2020, 10:02 PM

The community here is pretty creative and techie, interested in hearing some cool ideas. External database storage? Data visualization? Almanacs or history books? Spreadsheets?

I'm toying with the idea of exporting my main save to an external DB and maybe building PowerBI visualization dashboards somehow to track things like WAR/salary and and who knows what else.

scott1964 · 04-03-2020, 10:05 PM

I track all the Grand Slams in my league.

cheo25 · 04-04-2020, 12:10 AM

I use an Excel spreadsheet to track my team's win-loss records on the road, at home and overall vs. every opponent. And I break it down season by season and have a sheet in the workbook that totals it up.

jimmysthebestcop · 04-04-2020, 12:15 AM

I do nothing lol

maybe i'm missing out on something

stealofhome · 04-04-2020, 01:40 AM

I spent the day aggregating player ratings from their draft year over 100 years of league history and building a Random Forest in R to try to predict the best draft prospects.

I also have a script I use to automatically create many of the posts in my fictional league writeup.

greenOak · 04-04-2020, 02:16 AM

I use an excel sheet to track the progression minor league players' ratings throughout the year. That's about it.

illflow · 04-04-2020, 03:24 AM

When starting an expansion franchise, I track on a spreadsheet who wore which number each year on the active roster and for how many games. I find it interesting to look back and see who was the best player to wear any particular number outside of the retired ones. That said. there's a lot of room for improvement with how the game manages player's jersey numbers. And hopefully, we will be able to see them in the game eventually.

BigCountryBumgarner · 04-04-2020, 05:07 PM

Quote:

Originally Posted by stealofhome

I spent the day aggregating player ratings from their draft year over 100 years of league history and building a Random Forest in R to try to predict the best draft prospects.

I also have a script I use to automatically create many of the posts in my fictional league writeup.

This is awesome. How successful was your model in predicting prospects?

I'd love to hear more about this script. Is it kind of like the game recaps that are generated? Do you have any examples?

pgjocki · 04-04-2020, 05:56 PM

Quote:

Originally Posted by stealofhome

I spent the day aggregating player ratings from their draft year over 100 years of league history and building a Random Forest in R to try to predict the best draft prospects.

I also have a script I use to automatically create many of the posts in my fictional league writeup.

I lead analytic and engineering teams at work for multi-million projects and don't even do as much for work as you do for OOTP. I don't know what to do with this new piece of information....

stealofhome · 04-05-2020, 12:15 PM

Quote:

Originally Posted by BigCountryBumgarner

This is awesome. How successful was your model in predicting prospects?

I'd love to hear more about this script. Is it kind of like the game recaps that are generated? Do you have any examples?

It's still running, but seems that it cares most about potential and contact for hitters so far. Of course this may all change based on league setup, etc.

I'm almost totally self-taught (YouTube) so I'm still trying to get Github figured out but I do have some code in the extravaganza pages somewhere. Some of the stuff I originally posted is on Github here, but it is very out of date.

Quote:

Originally Posted by pgjocki

I lead analytic and engineering teams at work for multi-million projects and don't even do as much for work as you do for OOTP. I don't know what to do with this new piece of information....

Get on it! I'm obsessed with data analysis so I love to learn stuff in the baseball world and then take it into work with me. My degree is Chemical Engineering and we did very little coding/data analysis in college but I've grown to really enjoy it over the years since. I would love to figure out much of the more formal ways of doing things and tend to run into technical issues that require a lot of research.

Right now, it is trying to get a Random Forest to run on multiple threads since R is single-threaded and the pitching code is taking many hours to run. Then, what do I do with players who didn't make the MLB? Is it better to ignore them or give them a 0 WAR? So on and so forth, lots of interesting questions.

04-03-2020, 10:02 PM	#1
BigCountryBumgarner Minors (Rookie Ball) Join Date: Sep 2014 Posts: 28	What cool external things do you do to track or analyze your franchises? The community here is pretty creative and techie, interested in hearing some cool ideas. External database storage? Data visualization? Almanacs or history books? Spreadsheets? I'm toying with the idea of exporting my main save to an external DB and maybe building PowerBI visualization dashboards somehow to track things like WAR/salary and and who knows what else. Last edited by BigCountryBumgarner; 04-03-2020 at 10:03 PM.

04-03-2020, 10:05 PM	#2
scott1964 Hall Of Famer Join Date: Oct 2005 Location: Denver Posts: 5,561 Blog Entries: 19	I track all the Grand Slams in my league. __________________ This just feels more like waiting in line at the Department of Motor Vehicles. PETA.....People Eating Tasty Animals.

04-04-2020, 01:40 AM	#5
stealofhome Hall Of Famer Join Date: Apr 2014 Posts: 2,282 Blog Entries: 1	I spent the day aggregating player ratings from their draft year over 100 years of league history and building a Random Forest in R to try to predict the best draft prospects. I also have a script I use to automatically create many of the posts in my fictional league writeup. __________________ OOTP Resources \| - \| Stealofhome's Fictional Feeder Leagues and MLB Extravaganza Last edited by stealofhome; 04-04-2020 at 01:41 AM.

04-04-2020, 12:10 AM	#3
cheo25 All Star Reserve Join Date: Mar 2011 Location: Louisiana Posts: 708	I use an Excel spreadsheet to track my team's win-loss records on the road, at home and overall vs. every opponent. And I break it down season by season and have a sheet in the workbook that totals it up.

04-04-2020, 12:15 AM	#4
jimmysthebestcop Banned Join Date: Jun 2018 Posts: 1,728 Infractions: 0/2 (5)	I do nothing lol maybe i'm missing out on something

04-04-2020, 02:16 AM	#6
greenOak Minors (Triple A) Join Date: Aug 2014 Posts: 203	I use an excel sheet to track the progression minor league players' ratings throughout the year. That's about it.

04-04-2020, 03:24 AM	#7
illflow Bat Boy Join Date: Apr 2017 Posts: 13	When starting an expansion franchise, I track on a spreadsheet who wore which number each year on the active roster and for how many games. I find it interesting to look back and see who was the best player to wear any particular number outside of the retired ones. That said. there's a lot of room for improvement with how the game manages player's jersey numbers. And hopefully, we will be able to see them in the game eventually.