|
||||
|
|
OOTP 16 - General Discussions Discuss the new 2015 version of Out of the Park Baseball here! |
|
Thread Tools |
02-24-2016, 04:26 PM | #1 |
All Star Starter
Join Date: Dec 2005
Location: Los Angeles
Posts: 1,158
|
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 |
02-24-2016, 04:50 PM | #2 |
All Star Reserve
Join Date: Jan 2016
Posts: 672
|
This is going to end up as my favorite OOTP thread ever.
|
02-24-2016, 06:02 PM | #3 |
Hall Of Famer
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 |
02-24-2016, 06:07 PM | #4 |
Major Leagues
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. |
02-24-2016, 06:28 PM | #5 |
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.
|
02-25-2016, 11:15 AM | #6 |
Hall Of Famer
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. |
02-25-2016, 12:20 PM | #7 |
Minors (Single A)
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 |
02-25-2016, 02:59 PM | #8 |
Hall Of Famer
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.
OOTP Market Calc zip.zip |
02-25-2016, 03:17 PM | #9 | |
All Star Reserve
Join Date: Nov 2008
Location: Boston
Posts: 871
|
Quote:
__________________
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. |
|
02-25-2016, 03:24 PM | #10 |
Major Leagues
Join Date: Jun 2012
Location: Chicago
Posts: 362
|
|
02-25-2016, 04:18 PM | #11 |
Hall Of Famer
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.
__________________
JML MILKSHAKES |
02-25-2016, 06:15 PM | #12 |
Hall Of Famer
Join Date: Dec 2001
Location: SF Area, California Total Posts: 531,691
Posts: 2,363
|
Team History file.
__________________
JML MILKSHAKES |
02-25-2016, 08:10 PM | #13 |
Hall Of Famer
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.
|
02-26-2016, 11:26 AM | #14 |
Major Leagues
Join Date: Jun 2012
Location: Chicago
Posts: 362
|
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. Last edited by thirdsaint; 02-26-2016 at 11:28 AM. |
02-26-2016, 11:51 AM | #15 |
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! |
02-26-2016, 04:52 PM | #16 | ||
Hall Of Famer
Join Date: Dec 2001
Location: SF Area, California Total Posts: 531,691
Posts: 2,363
|
Quote:
Quote:
__________________
JML MILKSHAKES |
||
02-27-2016, 12:52 AM | #17 |
Hall Of Famer
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)
__________________
JML MILKSHAKES |
02-27-2016, 12:58 AM | #18 |
Hall Of Famer
Join Date: Dec 2001
Location: SF Area, California Total Posts: 531,691
Posts: 2,363
|
__________________
JML MILKSHAKES |
03-02-2016, 10:34 AM | #19 |
Major Leagues
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...
|
03-02-2016, 07:10 PM | #20 | |
Hall Of Famer
Join Date: Apr 2015
Posts: 7,167
|
Quote:
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. |
|
Bookmarks |
Thread Tools | |
|
|