Home | Webstore
Latest News: FHM 5 Available - OOTP 19 Available! - MLB Manager 2018 Available Now

Perfect Team is LIVE!

  

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,018
Thanks: 320
Thanked 548x in 337 posts
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
2 thanks for this post:
Rizon (02-24-2016), SupermanBSU (02-25-2016)
Old 02-24-2016, 04:50 PM   #2
CivicEvo
All Star Reserve
 
Join Date: Jan 2016
Posts: 672
Thanks: 67
Thanked 120x in 85 posts
This is going to end up as my favorite OOTP thread ever.
CivicEvo is offline   Reply With Quote
Thank you for this post:
Texasborn (02-24-2016)
Old 02-24-2016, 06:02 PM   #3
jpeters1734
Hall Of Famer
 
Join Date: Jun 2014
Location: Juust a bit outside...
Posts: 4,106
Thanks: 946
Thanked 2,035x in 1,186 posts
subscribed
__________________
"Cannonball Coming!" Go Bucs!!
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: 355
Thanks: 71
Thanked 178x in 99 posts
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, 123 views)
thirdsaint is offline   Reply With Quote
6 thanks for this post:
BIG17EASY (02-26-2016), cavebutter (02-24-2016), DustinthePOWERHOUSE (02-25-2016), gRaider2001 (02-25-2017), pgjocki (02-25-2016), Rizon (02-24-2016)
Old 02-24-2016, 06:28 PM   #5
JaBurns
All Star Starter
 
Join Date: Sep 2015
Location: Regina, Saskatchewan
Posts: 1,172
Thanks: 3,380
Thanked 531x in 420 posts
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: 467,854
Posts: 2,187
Thanks: 245
Thanked 251x in 143 posts
My yearly Scores and Schedule file.

(looks like I have to move these to Drive. I will post them later)
__________________
http://www.yescalifornia.org/
Because California has had it with you, America.

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: 89
Thanks: 91
Thanked 83x in 40 posts
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
2 thanks for this post:
Rizon (02-25-2016), statmeister (02-26-2016)
Old 02-25-2016, 02:59 PM   #8
joefromchicago
Hall Of Famer
 
joefromchicago's Avatar
 
Join Date: Jun 2011
Posts: 2,469
Thanks: 1,343
Thanked 1,814x in 920 posts
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: 2032
Size:  352.2 KB

OOTP Market Calc zip.zip
joefromchicago is online now   Reply With Quote
3 thanks for this post:
gRaider2001 (02-25-2017), Kobeck (03-07-2016), prisonerno6 (02-25-2016)
Old 02-25-2016, 03:17 PM   #9
DustinthePOWERHOUSE
All Star Reserve
 
DustinthePOWERHOUSE's Avatar
 
Join Date: Nov 2008
Location: Boston
Posts: 868
Thanks: 1,127
Thanked 384x in 241 posts
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
Thank you for this post:
thirdsaint (02-25-2016)
Old 02-25-2016, 03:24 PM   #10
thirdsaint
Major Leagues
 
thirdsaint's Avatar
 
Join Date: Jun 2012
Location: Chicago
Posts: 355
Thanks: 71
Thanked 178x in 99 posts
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: 467,854
Posts: 2,187
Thanks: 245
Thanked 251x in 143 posts
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, 123 views)
__________________
http://www.yescalifornia.org/
Because California has had it with you, America.
Rizon is offline   Reply With Quote
3 thanks for this post:
gRaider2001 (02-25-2017), r0nster (02-25-2016), thirdsaint (02-25-2016)
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: 467,854
Posts: 2,187
Thanks: 245
Thanked 251x in 143 posts
Team History file.

Attached Files
File Type: zip Philly Team History.zip (53.7 KB, 169 views)
__________________
http://www.yescalifornia.org/
Because California has had it with you, America.
Rizon is offline   Reply With Quote
Thank you for this post:
thirdsaint (02-25-2016)
Old 02-25-2016, 08:10 PM   #13
r0nster
Hall Of Famer
 
r0nster's Avatar
 
Join Date: May 2006
Location: Michigan
Posts: 2,618
Thanks: 742
Thanked 672x in 467 posts
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 online now   Reply With Quote
Thank you for this post:
phillsphan (03-04-2016)
Old 02-26-2016, 11:26 AM   #14
thirdsaint
Major Leagues
 
thirdsaint's Avatar
 
Join Date: Jun 2012
Location: Chicago
Posts: 355
Thanks: 71
Thanked 178x in 99 posts
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, 121 views)

Last edited by thirdsaint; 02-26-2016 at 11:28 AM.
thirdsaint is offline   Reply With Quote
3 thanks for this post:
darkcloud4579 (04-20-2018), gRaider2001 (02-25-2017), Rizon (02-26-2016)
Old 02-26-2016, 11:51 AM   #15
CivicEvo
All Star Reserve
 
Join Date: Jan 2016
Posts: 672
Thanks: 67
Thanked 120x in 85 posts
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: 467,854
Posts: 2,187
Thanks: 245
Thanked 251x in 143 posts
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.
__________________
http://www.yescalifornia.org/
Because California has had it with you, America.
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: 467,854
Posts: 2,187
Thanks: 245
Thanked 251x in 143 posts
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 
__________________
http://www.yescalifornia.org/
Because California has had it with you, America.
Rizon is offline   Reply With Quote
2 thanks for this post:
gRaider2001 (02-25-2017), Noone_Uknow (03-16-2016)
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: 467,854
Posts: 2,187
Thanks: 245
Thanked 251x in 143 posts
Preseason Team Preview file
note: needs rating scale detail file from above

Team Previews


__________________
http://www.yescalifornia.org/
Because California has had it with you, America.
Rizon is offline   Reply With Quote
2 thanks for this post:
JaBurns (02-27-2016), Noone_Uknow (03-16-2016)
Old 03-02-2016, 10:34 AM   #19
thirdsaint
Major Leagues
 
thirdsaint's Avatar
 
Join Date: Jun 2012
Location: Chicago
Posts: 355
Thanks: 71
Thanked 178x in 99 posts
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
Thank you for this post:
Rizon (03-02-2016)
Old 03-02-2016, 07:10 PM   #20
NoOne
Hall Of Famer
 
NoOne's Avatar
 
Join Date: Apr 2015
Posts: 6,004
Thanks: 604
Thanked 1,615x in 1,309 posts
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 06:36 PM.

 

Major League Baseball trademarks and copyrights are used with permission of MLB Advanced Media, L.P. Minor League Baseball trademarks and copyrights are used with the permission of Minor League Baseball. All rights reserved.

The Major League Baseball Players Association (www.MLBPLAYERS.com ) is the collective bargaining representative for all professional baseball players of the thirty Major League Baseball teams and serves as the exclusive group licensing agent for commercial and licensing activities involving active Major League baseball players. On behalf of its members, it operates the Players Choice licensing program and the Players Choice Awards, which benefit the needy through the Major League Baseball Players Trust, a charitable foundation established and run entirely by Major League baseball players. Follow: @MLB_Players; @MLBPAClubhouse; @MLBPlayersTrust

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 © 2017 OUT OF THE PARK DEVELOPMENTS. ALL RIGHTS RESERVED.

 

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