I made a thing! First usable results from my database

[cavebutter]

I've been working on a project to roll my own MySQL database from OOTP data. While mostly done for the sake of learning a new thing, I also had some clear goals in mind for how to improve my playing experience.

The most challenging part was getting to understand and then calculate all of the advanced stats. From there, things have been getting easier and now I've moved back into my professional wheelhouse: Excel.

I've always wanted a better way to manage my organizational depth chart. It's easy to get lost in a sea of numbers and lose context. The below screenshot shows all of the relievers in the fictional Baltimore organization. The charts visualize the stats and ratings for the top 5 players. The players can be sorted based on any of the visible stats as well as a number of hidden ratings.

The data in the table updates automatically from a csv that the database outputs. (This is currently a manual export due to weirdness in the server instance - grr!)

Anyhow, this is the Bullpen Depth worksheet. I'm open to any suggestions on how to improve, but mostly just showing off.

[stealofhome]

Awesome work! The game definitely needs more visualization and friendliness with stats.

[Galeg]

Awesome work!

[cavebutter]

This one's the Outfield Depth worksheet. Same concept.

One note about the batting and fielding ratings. I configured the dump to show OSA ratings rather than true ratings. Also, the raw values for ratings (OSA or otherwise) are on a scale of 0-~250. I don't have a feel for how to convert these to my prefered 20-80 scale. If anyone has ideas, I'd love to hear them. For now, I just removed the labels from the axis.

I'm still playing around with the design and formatting of the charts, so they're not all consistent at this point.

OF Depth:

[NoOne]

def share that in mods section.

[cavebutter]

Again because of a weirdness in my server installation, this one's not connected to a workbook, but...

Have you ever been in this situation?

You're negotiating a trade with Dallas and you're close to a deal but you think that they could throw in a young corner outfielder to sweeten the pot. Rather than scrolling through all of the pulldowns in the lower-right corner of the trade screen, you can Find-a-Batter (tm)!

This nifty stored procedure will let you choose an upper age limit, a position or group of positions, and a PARENT organization and show you all the relevant details. You can name a position directly (2-9) or choose Infield, Outfield, Middle Infield, Corner Infield, Corner Outfield. If you choose none, then it will show you all batters in that age group and that organization.

Don't want to specify an age limit? You don't have to! Want to see all the under-23 third basemen in any organization on the planet? We can do that too! Just NULL the organization and you'll get it!

[RonCo]

Nice work!

[cavebutter]

"That's all well and good," you say. "But I'm stacked with outfielders. What I need is a reliever. Any reliever."

We've got you covered with Find-a-Pitcher (tm)! Enter an age (or no age), a role (Starter, Reliever, Closer, All Relievers or all pitchers), and a Parent organization (or no organization at all) - and you'll get a custom list of pitchers. One is sure to fit your needs!

[Izz]

Really cool!

[actionjackson]

I have no earthly idea what you're doing here, but I'll echo the "great work!" sentiments. It's fun to create something that helps you enjoy this game even more, isn't it? I've done many different things (nothing as complicated as this though) to tailor the game to do things the way I want them done.

[actionjackson]

Originally Posted by actionjackson

I have no earthly idea what you're doing here, but I'll echo the "great work!" sentiments. It's fun to create something that helps you enjoy this game even more, isn't it? I've done many different things (nothing as complicated as this though) to tailor the game to do things the way I want them done.

...And I suppose this quote calls for a "Thank you Markus for making this game endlessly customizable so that we can truly play it our way".

[cavebutter]

Agreed!

[mitchkenn]

Originally Posted by cavebutter

"That's all well and good," you say. "But I'm stacked with outfielders. What I need is a reliever. Any reliever."

We've got you covered with Find-a-Pitcher (tm)! Enter an age (or no age), a role (Starter, Reliever, Closer, All Relievers or all pitchers), and a Parent organization (or no organization at all) - and you'll get a custom list of pitchers. One is sure to fit your needs!

this would be so very nice if it were built into the game! Great idea and good display of potential.

[Orcin]

I am very impressed with the programming. I have done enough Excel in my day to appreciate the skill at work here. Nice job!

[eriqjaffe]

This is really good stuff.

[NoOne]

you can do that in sql too. make a query or report etc.. save for re-use. you wouldn't have to export and use excel.

sql is easy stuff.. at least at this level of use.. syntax may be slightly differnet, but same same logic as what you are using in excel.

edit: lol it is in the dB, nevermind.. leaving the above to look stupid anyway...

what's wrong with mysql intallation? check mysql.ini?

a good all-in-one that comes wokrign out of the box is mariadB and i use a free heidi-sql for a front end. setup differnet users for access to different dB, or at least i like to.. keeps 'tree' view clean.

[cavebutter]

Originally Posted by NoOne

you can do that in sql too. make a query or report etc.. save for re-use. you wouldn't have to export and use excel.

sql is easy stuff.. at least at this level of use.. syntax may be slightly differnet, but same same logic as what you are using in excel.

edit: lol it is in the dB, nevermind.. leaving the above to look stupid anyway...

what's wrong with mysql intallation? check mysql.ini?

a good all-in-one that comes wokrign out of the box is mariadB and i use a free heidi-sql for a front end. setup differnet users for access to different dB, or at least i like to.. keeps 'tree' view clean.

Yeah, all of the depth chart stuff is in excel using csv output generated by the dB.

The find-a-batter and pitcher are stored procedures accessed directly from the dB.

If you know anything about MySQL server on Mac, I’d love to trouble-shoot it with someone. By default, Mac doesn’t create a my.cnf for MySQL and I need to create one to be able to write to a file from the server. To complicate matters, the server is running, but can’t be restarted or stopped. Something about a missing pid file. Seriously, if you know anything about this, I’d like to pick your brain.


Sent from my iPhone using Tapatalk

[paul.m.w.]

Originally Posted by cavebutter

Yeah, all of the depth chart stuff is in excel using csv output generated by the dB.

The find-a-batter and pitcher are stored procedures accessed directly from the dB.

If you know anything about MySQL server on Mac, I’d love to trouble-shoot it with someone. By default, Mac doesn’t create a my.cnf for MySQL and I need to create one to be able to write to a file from the server. To complicate matters, the server is running, but can’t be restarted or stopped. Something about a missing pid file. Seriously, if you know anything about this, I’d like to pick your brain.


Sent from my iPhone using Tapatalk

Wow
Great stuff


Sent from my iPhone using Tapatalk

[Elektranaut]

This is where OOTP has made little progress over the years considering it is basically a spreadsheet kinda game.

[Hemi425HP]

Really cool stuff.