Home | Webstore
Latest News: OOTP 25 Available - FHM 10 Available - OOTP Go! Available

Out of the Park Baseball 25 Buy Now!

  

Go Back   OOTP Developments Forums > Prior Versions of Our Games > Out of the Park Baseball 16 > OOTP 16 - General Discussions

OOTP 16 - General Discussions Discuss the new 2015 version of Out of the Park Baseball here!

Reply
 
Thread Tools
Old 03-04-2016, 12:00 AM   #21
OBSL Commish
All Star Reserve
 
OBSL Commish's Avatar
 
Join Date: Aug 2010
Posts: 946
https://www.dropbox.com/s/q2q6dsuguj...ater.xlsm?dl=0

This is an Excel macro that will extract ratings from one league and paste them into another league's rosters, provided it finds the same player names in both rosters. I use this macro to update the ratings for the teams in my online league when each new version of OOTP comes out.

The only thing I haven't been able to figure out is how to change the file names in the macro and have it work. As it is, both files have to have the names "obsl_rosters" and "updated_rosters" in order for this to work. The files can be changed to whatever names after the updating is done. If anyone has a clue how to make the changes work, please let me know.
OBSL Commish is offline   Reply With Quote
Old 03-06-2016, 01:33 AM   #22
Athletics
Bat Boy
 
Join Date: Mar 2016
Posts: 4
Quote:
Originally Posted by NoOne View Post
you should look into setting the data up in a db, then make various report templates that query the data and fill everything in for you. absolutely no effort or work required after you set it up.
Quote:
Originally Posted by Rizon View Post
The DB way is interesting (MS Access?). Do you have any examples with data so I can see it in action?
Thanks to NoOne and Rizon, I got inspired to sit down for a weekend and code a Python script to read in CSV files, use PyMongo to save the raw data to MongoDB, and then query the raw data from MongoDB to calculate stats.

I wanted an easier way to see wOBA, ISO, and xFIP splits for my entire fictional league. It's not user-friendly at all and runs from the command line.

Also, compare the game save file to the database size.
3.7G braves.lg/
ootp_braves 0.953GB

Source code and example output can be found here. https://github.com/namtsui/ootp
Athletics is offline   Reply With Quote
Old 03-07-2016, 07:47 PM   #23
Kobeck
Major Leagues
 
Kobeck's Avatar
 
Join Date: Nov 2004
Posts: 488
Quote:
Originally Posted by joefromchicago View Post
This is a spreadsheet I've developed to calculate market size. It's applicable to major US cities through 2010 and Canadian cities through 2006 (I need to update that). Files are in OpenOffice format.

Attachment 439568

Attachment 439569
what does the 2 different number ranges represent ?


and thanks for sharing




EDIT - Nevermind I found the how to file....

Last edited by Kobeck; 03-07-2016 at 08:03 PM.
Kobeck is offline   Reply With Quote
Old 03-08-2016, 09:09 PM   #24
BBGiovanni
All Star Starter
 
BBGiovanni's Avatar
 
Join Date: Aug 2015
Location: Republic of California
Posts: 1,850
For those of you using spreadsheets to "calculate" market size, are you basically using some factor to convert population/raw numbers like radio market population to OOTP market size? Or reverse engineering budgets, or what?

PS: Rizon, were you really Twins34? Curse you
BBGiovanni is offline   Reply With Quote
Old 03-09-2016, 01:35 AM   #25
joefromchicago
Hall Of Famer
 
joefromchicago's Avatar
 
Join Date: Jun 2011
Posts: 3,630
Quote:
Originally Posted by BBGiovanni View Post
For those of you using spreadsheets to "calculate" market size, are you basically using some factor to convert population/raw numbers like radio market population to OOTP market size? Or reverse engineering budgets, or what?
My numbers are based on US and Canadian census figures, so it's the former. TV/Radio market numbers are fine for modern leagues, but they obviously aren't available for earlier time periods, so that's why I use census figures.
joefromchicago is offline   Reply With Quote
Old 03-09-2016, 05:10 PM   #26
NoOne
Hall Of Famer
 
NoOne's Avatar
 
Join Date: Apr 2015
Posts: 7,167
Quote:
Originally Posted by Athletics View Post
Thanks to NoOne and Rizon, I got inspired to sit down for a weekend and code a Python script to read in CSV files, use PyMongo to save the raw data to MongoDB, and then query the raw data from MongoDB to calculate stats.

I wanted an easier way to see wOBA, ISO, and xFIP splits for my entire fictional league. It's not user-friendly at all and runs from the command line.

Also, compare the game save file to the database size.
3.7G braves.lg/
ootp_braves 0.953GB

Source code and example output can be found here. https://github.com/namtsui/ootp
i never saw rizon's reply. i don't put in that kind of effort. i am fine with the stats in game.

the only spreadsheet i have made for this game is to track stats related to LTMs. virtually everything is automated excepted adding or reducing # of years to be evaluated. i would have had to look that up. it's been 20 years since i learned this stuff and i don't do anything sophisticated with spreadsheets in my normal life since then. effort would not have matched the return. i just keep two template files - one for 100, the other 200 years.

if i make anything in the future, it will be to test things. e.g. at some point i'd like to do is flesh out which pitch combinations result in lower ERAs than what is projected in the player editor.

once you set up the data (anythign repeatable = can be automated), the spreadsheet does all the hard work, or you can use VB to create your own functions.

you can know every "best" decision within this video game, if someone puts in the time, lol. again, not really worth the effort and probably removes all the fun.
NoOne is offline   Reply With Quote
Old 03-23-2016, 09:49 PM   #27
Athletics
Bat Boy
 
Join Date: Mar 2016
Posts: 4
My Python script reads in raw data from the game's csv files, saves it to a database, reads from the database to calculate some stats for splits, and outputs batter and pitcher csv files.

name,year,team,pos,bats,pa,pa_l,pa_r,woba,woba_l,w oba_r,iso,iso_l,iso_r
Moritz Lingen,2019,POR,3B,R,618.0,201.0,417.0,0.363,0.401 ,0.345,0.257,0.297,0.239
Ian Zilberman,2019,POR,SS,R,572.0,185.0,387.0,0.302,0. 312,0.297,0.111,0.116,0.109

name,year,team,pos,throws,ip,ip_l,ip_r,era,era_l,e ra_r,xfip,xfip_l,xfip_r,k9,k9_l,k9_r,bb9,bb9_l,bb9 _r
Carlos Navarro,2019,POR,P,R,196.0,87.0,108.0,4.684,4.759, 4.667,4.292,4.36,4.247,6.75,6.931,6.667,2.526,3.10 3,2.083
Tom Warner,2019,POR,P,R,138.0,60.0,77.0,4.304,4.35,4.3 25,4.231,4.028,4.401,7.435,7.35,7.597,1.957,0.9,2. 805

Then, I slice and dice the data inside my spreadsheet. Certainly, the game provides a lot of tools to keep track of this information. Using my own notes, I can do things like sort by lineup, mark star players, and research matchups.

I'm still trying to figure out an ideal workflow because the update operation takes 1 minute per team and ~30 minutes to calculate the csv files for the entire league. I plan to update stats every few months during the current season.

I've found that taking the time to sit back and explore the data that the game generates is really immersive and fun! I love the suggestions in this thread and seeing how you all play the game. I have started to incorporate some of these ideas into my workflow. For instance, before, I would never really keep track of the star players of other teams and just focused on building up my own team. Then, I noticed what you all were paying attention to and keeping track of in your spreadsheets. By writing things down and observing the vast landscape, I am better enjoying the dynamic game of baseball.

Also, stats-only is hard, and I will take any edge that I can get.

Name:  spreadsheet.png
Views: 1917
Size:  189.0 KB

Last edited by Athletics; 03-23-2016 at 10:13 PM.
Athletics is offline   Reply With Quote
Old 05-25-2017, 01:17 PM   #28
NoOne
Hall Of Famer
 
NoOne's Avatar
 
Join Date: Apr 2015
Posts: 7,167
a simple front-end like heidisql can import csv they made the script for you. alot prettier and easier to read.

you can make any query/rport you wish with sql. they probably give enough info to extrapolate most statistics out there, if not included in the game.
NoOne is offline   Reply With Quote
Old 05-25-2017, 02:06 PM   #29
r0nster
Hall Of Famer
 
r0nster's Avatar
 
Join Date: May 2006
Location: Michigan
Posts: 3,001
Certainly hopes one-day to learn how to use spreadsheet for reports
r0nster is offline   Reply With Quote
Old 04-20-2018, 12:10 PM   #30
darkcloud4579
Hall Of Famer
 
Join Date: Jun 2003
Posts: 8,304
Blog Entries: 32
This thread is amazing, only found it today. Such good stuff.

My financial calculator for OOTP is called GMExcel.

I created a Google sheet for Tangotiger's Cy Young Calculator, too.

Last edited by darkcloud4579; 04-20-2018 at 12:12 PM.
darkcloud4579 is offline   Reply With Quote
Old 03-03-2023, 02:57 PM   #31
JoshSamBob
Minors (Double A)
 
JoshSamBob's Avatar
 
Join Date: Aug 2002
Location: Near Boston
Posts: 143
(VERY) late to the party, but... anyone use spreadsheets to evaluate draft prospects?
__________________
JoshSamBob is offline   Reply With Quote
Reply

Bookmarks

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT -4. The time now is 08:17 PM.

 

Major League and Minor League Baseball trademarks and copyrights are used with permission of Major League Baseball. Visit MLB.com and MiLB.com.

Officially Licensed Product – MLB Players, Inc.

Out of the Park Baseball is a registered trademark of Out of the Park Developments GmbH & Co. KG

Google Play is a trademark of Google Inc.

Apple, iPhone, iPod touch and iPad are trademarks of Apple Inc., registered in the U.S. and other countries.

COPYRIGHT © 2023 OUT OF THE PARK DEVELOPMENTS. ALL RIGHTS RESERVED.

 

Powered by vBulletin® Version 3.8.10
Copyright ©2000 - 2024, vBulletin Solutions, Inc.
Copyright © 2020 Out of the Park Developments