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 02-24-2016, 04:26 PM   #1
cavebutter
All Star Starter
 
cavebutter's Avatar
 
Join Date: Dec 2005
Location: Los Angeles
Posts: 1,158
Lightbulb Share your OOTP Spreadsheets!

A thread about how to stay engaged in fictional leagues started off very well, and lots of folks shared great ways to make fictional leagues more "real" for the player. Then, the thread derailed. But it derailed in such a fascinating way that it deserves its own thread.

Share your homemade OOTP spreadsheets. Upload them if you can. If you can't (haven't checked the forum rules), I can set up a public FTP for them. I know that very few of us document them, so explain a little bit about what they do and how they work. Don't worry about getting too technical- it seems that there are a great many Excel jockeys on this board.

Me, I do this kind of thing for work. And I'm embarrassed to say that I only have one sheet that I use to help me create universes- calculates market size and financials as well as just mapping out my farm systems. I will upload my meager contribution when I get home. But I want to see yours! Share!
__________________
MySQL, MyStruggle - A self-indulgent blog about my attempts to roll my own MySQL Database with OOTP

Logo Gallery
cavebutter is offline   Reply With Quote
Old 02-24-2016, 04:50 PM   #2
CivicEvo
All Star Reserve
 
Join Date: Jan 2016
Posts: 672
This is going to end up as my favorite OOTP thread ever.
CivicEvo is offline   Reply With Quote
Old 02-24-2016, 06:02 PM   #3
jpeters1734
Hall Of Famer
 
jpeters1734's Avatar
 
Join Date: Jun 2014
Location: Juust a bit outside...
Posts: 5,606
subscribed
__________________
"Cannonball Coming!" Go Bucs!!

Founder and League Caretaker of the Professional Baseball Circuit, www.probaseballcircuit.com

An Un-Official Guide to Minor League Management in OOTP 21

Ratings Scale Conversion Cross-Reference Cheat Sheet
jpeters1734 is offline   Reply With Quote
Old 02-24-2016, 06:07 PM   #4
thirdsaint
Major Leagues
 
thirdsaint's Avatar
 
Join Date: Jun 2012
Location: Chicago
Posts: 362
Here's one of mine, just a simple little spreadsheet for keeping track of your 1st Round picks. It's easy to expand and just has a few categories like the year they retired, titles they won, and WAR accumulated throughout their career. I also have a little table to the right where after 10 years I do a redraft based on how I think they should've went given their career to that point. Makes for some interesting observations on draft busts and 8th round sleepers.

Looks like you can only attach Excel files if you Zip them first, which is fine by me.
Attached Images
Image 
Attached Files
File Type: zip 1st Round Draft History.zip (17.5 KB, 355 views)
thirdsaint is offline   Reply With Quote
Old 02-24-2016, 06:28 PM   #5
JaBurns
All Star Starter
 
Join Date: Sep 2015
Location: Kelowna, British Columbia
Posts: 1,258
Sign me up! Just tell me what I have to do.
JaBurns is offline   Reply With Quote
Old 02-25-2016, 11:15 AM   #6
Rizon
Hall Of Famer
 
Rizon's Avatar
 
Join Date: Dec 2001
Location: SF Area, California Total Posts: 531,691
Posts: 2,363
My yearly Scores and Schedule file.

(looks like I have to move these to Drive. I will post them later)
__________________
JML MILKSHAKES

Last edited by Rizon; 02-25-2016 at 11:22 AM.
Rizon is offline   Reply With Quote
Old 02-25-2016, 12:20 PM   #7
Blue
Minors (Single A)
 
Blue's Avatar
 
Join Date: Apr 2014
Location: Seattle
Posts: 93
I too use spreadsheets a ton to plan out fictional leagues. This may be hard to read, but its a screenshot of my planned out league based on the early history of the NBA from 1946-1980. I moved everything back two decades and have been slowly making my way through the years. The left column is just notes on the logo sets I use for each team that is based on the real NBA team that existed. And then there are some other notes, the planned ABA rivalry for a few years, and then adding minors along the way.

__________________
Native Georgian. Adopted Texan.

Las Vegas Knights GM, 3 Time TBC Champion

Blue is offline   Reply With Quote
Old 02-25-2016, 02:59 PM   #8
joefromchicago
Hall Of Famer
 
joefromchicago's Avatar
 
Join Date: Jun 2011
Posts: 3,630
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.

Name:  Market calculation screenshot.jpg
Views: 4346
Size:  352.2 KB

OOTP Market Calc zip.zip
joefromchicago is offline   Reply With Quote
Old 02-25-2016, 03:17 PM   #9
DustinthePOWERHOUSE
All Star Reserve
 
DustinthePOWERHOUSE's Avatar
 
Join Date: Nov 2008
Location: Boston
Posts: 871
Quote:
Originally Posted by thirdsaint View Post
Here's one of mine, just a simple little spreadsheet for keeping track of your 1st Round picks. It's easy to expand and just has a few categories like the year they retired, titles they won, and WAR accumulated throughout their career. I also have a little table to the right where after 10 years I do a redraft based on how I think they should've went given their career to that point. Makes for some interesting observations on draft busts and 8th round sleepers.

Looks like you can only attach Excel files if you Zip them first, which is fine by me.
I would love to see more of this... can you screen shot some more?
__________________
Shootin' at the walls of heartache, BANG BANG, I am THE WARRIOR!

"It's hard to be humble when you're as great as I am"- Ali

Wladimir Klitschko will DESTROY you.
DustinthePOWERHOUSE is offline   Reply With Quote
Old 02-25-2016, 03:24 PM   #10
thirdsaint
Major Leagues
 
thirdsaint's Avatar
 
Join Date: Jun 2012
Location: Chicago
Posts: 362
Quote:
Originally Posted by DustinthePOWERHOUSE View Post
I would love to see more of this... can you screen shot some more?
Thanks! There's really not much else to it. The file is in that post if you want to download it and take a look.
thirdsaint is offline   Reply With Quote
Old 02-25-2016, 04:18 PM   #11
Rizon
Hall Of Famer
 
Rizon's Avatar
 
Join Date: Dec 2001
Location: SF Area, California Total Posts: 531,691
Posts: 2,363
Team scores and schedule file. I color code opponents by interleague or interdivision games. File attached below picture.

Attached Files
File Type: zip Schedule.zip (43.3 KB, 328 views)
__________________
JML MILKSHAKES
Rizon is offline   Reply With Quote
Old 02-25-2016, 06:15 PM   #12
Rizon
Hall Of Famer
 
Rizon's Avatar
 
Join Date: Dec 2001
Location: SF Area, California Total Posts: 531,691
Posts: 2,363
Team History file.

Attached Files
File Type: zip Philly Team History.zip (53.7 KB, 399 views)
__________________
JML MILKSHAKES
Rizon is offline   Reply With Quote
Old 02-25-2016, 08:10 PM   #13
r0nster
Hall Of Famer
 
r0nster's Avatar
 
Join Date: May 2006
Location: Michigan
Posts: 3,001
I do wonder how you can do this stuff and put it on spreadsheet like what you guys have done over the years. I have had this game since season ticket and I never really thought to try it although I have seen countless people doing that.
r0nster is offline   Reply With Quote
Old 02-26-2016, 11:26 AM   #14
thirdsaint
Major Leagues
 
thirdsaint's Avatar
 
Join Date: Jun 2012
Location: Chicago
Posts: 362
Quote:
Originally Posted by Rizon View Post
Team History file.

Man, you really had a dynasty going with that Philly team, huh?

Interesting template, certainly more involved than mine. Any chance I can get just one tab of the basic premise of your team previews? No data needs to be filled in or any formulas, don't think I'd be able to figure them out anyhow, just like how clean it looks at the categories.

Here's my Top 10 Best Players from each franchise template. I kept a couple teams filled so you can see the template. It should be easy to add teams, change colors and logos (just right click and hit 'Change Picture' to keep the same proportion), and fill it out yourselves.
Attached Images
Image 
Attached Files
File Type: zip LBL Best Players.zip (150.6 KB, 333 views)

Last edited by thirdsaint; 02-26-2016 at 11:28 AM.
thirdsaint is offline   Reply With Quote
Old 02-26-2016, 11:51 AM   #15
CivicEvo
All Star Reserve
 
Join Date: Jan 2016
Posts: 672
I've moved everything to Google Sheets, so I've taken my position reports and made it viewable:





https://docs.google.com/spreadsheets...it?usp=sharing

Two tabs, the first is WAR by Year and the second is full stats by year.

Note: I play in God mode so I don't have GM-based reports at this time.

I'll keep posting more templates as I create them!
CivicEvo is offline   Reply With Quote
Old 02-26-2016, 04:52 PM   #16
Rizon
Hall Of Famer
 
Rizon's Avatar
 
Join Date: Dec 2001
Location: SF Area, California Total Posts: 531,691
Posts: 2,363
Quote:
Originally Posted by thirdsaint View Post
Man, you really had a dynasty going with that Philly team, huh?
Yes, I like to attribute my amazing success to my spreadsheets.

Quote:
Originally Posted by thirdsaint View Post
Interesting template, certainly more involved than mine. Any chance I can get just one tab of the basic premise of your team previews? No data needs to be filled in or any formulas, don't think I'd be able to figure them out anyhow, just like how clean it looks at the categories..
I'll try to get it posted sometime today. It ended up being too large for Drive. I'm not sure about a Template, but with all the data filled in you can get a good look at it.
__________________
JML MILKSHAKES
Rizon is offline   Reply With Quote
Old 02-27-2016, 12:52 AM   #17
Rizon
Hall Of Famer
 
Rizon's Avatar
 
Join Date: Dec 2001
Location: SF Area, California Total Posts: 531,691
Posts: 2,363
My season roster file.
Note: it links to another file required to run the formulas.

Season Roster

Ratings Scale File (needed for Season Roster to work right)
Attached Images
Image Image 
__________________
JML MILKSHAKES
Rizon is offline   Reply With Quote
Old 02-27-2016, 12:58 AM   #18
Rizon
Hall Of Famer
 
Rizon's Avatar
 
Join Date: Dec 2001
Location: SF Area, California Total Posts: 531,691
Posts: 2,363
Preseason Team Preview file
note: needs rating scale detail file from above

Team Previews


__________________
JML MILKSHAKES
Rizon is offline   Reply With Quote
Old 03-02-2016, 10:34 AM   #19
thirdsaint
Major Leagues
 
thirdsaint's Avatar
 
Join Date: Jun 2012
Location: Chicago
Posts: 362
Thanks a lot Rizon! Going to look into those files and see what sort of mess I can get myself in... further down the rabbit hole I go...
thirdsaint is offline   Reply With Quote
Old 03-02-2016, 07:10 PM   #20
NoOne
Hall Of Famer
 
NoOne's Avatar
 
Join Date: Apr 2015
Posts: 7,167
Quote:
Originally Posted by r0nster View Post
I do wonder how you can do this stuff and put it on spreadsheet like what you guys have done over the years. I have had this game since season ticket and I never really thought to try it although I have seen countless people doing that.
the trick is to use varialbes and links to the data dump files. you should only have to set up the first line of data, then be able to copy and 'fill' down as many rows as you need. no data entry from the game should be required or you are making the job very difficult for yourself. (if the export 'stuff' doesn't contain the info you need, only then should you be manually entering data)

typically you should have an input/output worksheet and as many work worksheets as required. keep the mess in the work worksheet and have a nice formatted, succinct and organized I/O worksheet.
NoOne 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 07:21 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