|
||||
|
|
Earlier versions of OOTP: General Discussions General chat about the game... |
|
Thread Tools |
02-23-2012, 05:34 PM | #1 |
Bat Boy
Join Date: Jan 2012
Posts: 8
|
Planning your Team
Was curious if anyone used excel documents or how you planned the future of your team? Just one of those where you know this coming draft you need a future 1B star and perhaps a 2B or how you orgainze your depth and know what to target in FA/Draft/Trades.
I ask because I just took over a team in an online league and its frustratng trying to figure things out and than overnight I forget some of my plans because I'm not very good at thinking of a way to document ideas and was curious if anyone cared enough to share their ways. |
02-23-2012, 06:20 PM | #2 | |
Minors (Triple A)
Join Date: Feb 2011
Posts: 256
|
Quote:
I usually create a note about my 1st & 2nd round picks, whether I'm thin at a certain postion, or players I may want to trade or trade for. Eliminates toggling back & forth between the game and a spreadsheet. |
|
02-23-2012, 07:36 PM | #3 |
Major Leagues
Join Date: Jun 2005
Location: Maine
Posts: 482
|
I definitely use a spreadsheet for everything in my league. For me it's easier to visualize needs, etc. on the spreadsheet and I make many lists and reorder things as necessary. Plus, it's possible to look at the information you have even when the game isn't running.
|
02-24-2012, 07:58 AM | #4 |
Major Leagues
Join Date: Jun 2005
Location: Maine
Posts: 482
|
Here you go.
|
02-24-2012, 01:49 PM | #5 |
All Star Starter
Join Date: Aug 2004
Location: Morro Bay, CA
Posts: 1,257
|
I use spreadsheets (and Word docs) extensively in OOTP. It's especially important for the annual draft, but I also use spreadsheets for draft day, monthly minor league evaluation, EOY stats, trades, etc. I use Word docs to document game-day highlights as well.
Here's an important thread (with examples) about using spreadsheets for the annual draft... http://www.ootpdevelopments.com/boar...-approach.html Also, an important aspect of using spreadsheets is to create the correct statistical 'views' inside of OOTP. If you don't have the most useful data, a spreadsheet won't help much.
__________________
I cast this question into your soul, that I might know how deep it is - Friedrich Nietzsche It often shows a fine command of language - to say nothing! - Bertrand Russell |
02-25-2012, 11:13 AM | #6 |
Minors (Rookie Ball)
Join Date: Aug 2009
Posts: 30
|
I don't have much of a need for detailed spreadsheets. In the annual draft, I always draft the best player available. I would never say, "I need a good 1st baseman." Whoever I draft might not ever reach their potential or it might take so long that my team needs have drastically changed. If I end up with multiple great prospects at more than one position, then just means I have great trade bait I can use to fill immediate needs.
I only draft the first few rounds though as I found it too easy to beat the AI by out picking them in the other rounds. I just let the scouting director make my later picks. If you are drafting all the rounds, a spreadsheet helps tremendously. For other types of notes, I use a desktop note app. |
02-25-2012, 04:18 PM | #7 |
Minors (Single A)
Join Date: Jul 2011
Posts: 86
|
What are the steps for exporting all players into excel? I have 521 pages with about 13 players per page
|
02-25-2012, 04:36 PM | #8 | |
All Star Starter
Join Date: Dec 2001
Location: near Rochester, NY
Posts: 1,269
|
Quote:
You can take any one page, however long, and open it in your browser. From there, you can copy and paste into Excel. (I find I have to do an in-between step of copying and pasting from the browser into a text editor, and then copy and paste into Excel.) If all the players are on one page, this is quick and smooth. When the list is so long that it extends many pages, it gets pretty tedious. I usually do a filter to shorten the list. Since I won't draft pitchers with low movement potential or hitters with poor movement potential, I can cut the size of the list by two thirds. But 521 pages??? ouch!
__________________
Commish of Dog Days Baseball Commish Pennant Chase Baseball League (PCBL) Commish and Blue Jays GM Extra Innings Baseball Last edited by beorn; 02-25-2012 at 04:37 PM. |
|
02-25-2012, 04:39 PM | #9 |
Minors (Single A)
Join Date: Jul 2011
Posts: 86
|
Thanks for the reply. I was afraid of that.
|
02-25-2012, 05:19 PM | #10 | |
All Star Starter
Join Date: Aug 2004
Location: Morro Bay, CA
Posts: 1,257
|
Quote:
On my draft-day spreadsheet I list the 40 top players in the draft (40 batters and 40 Pitchers) and the 3 top players at each position. I also trade players for future draft picks.
__________________
I cast this question into your soul, that I might know how deep it is - Friedrich Nietzsche It often shows a fine command of language - to say nothing! - Bertrand Russell |
|
02-26-2012, 11:11 AM | #11 |
Minors (Single A)
Join Date: Jul 2011
Posts: 86
|
Thanks Ambermonk for the tips and the inagural draft link.
|
02-26-2012, 05:33 PM | #12 | |
Bat Boy
Join Date: Jan 2012
Posts: 8
|
Quote:
|
|
02-26-2012, 06:53 PM | #13 | |
All Star Starter
Join Date: Aug 2004
Location: Morro Bay, CA
Posts: 1,257
|
Quote:
Pay attention to the column headings in my examples to get an idea how to custom design your roster views!
__________________
I cast this question into your soul, that I might know how deep it is - Friedrich Nietzsche It often shows a fine command of language - to say nothing! - Bertrand Russell |
|
03-01-2012, 12:40 PM | #14 |
Hall Of Famer
Join Date: Dec 2001
Location: SF Area, California Total Posts: 531,691
Posts: 2,363
|
I use Excel. And am extraordinarily anal about it.
Depth Chart: used to manage team
__________________
JML MILKSHAKES Last edited by Rizon; 03-01-2012 at 01:04 PM. |
03-01-2012, 12:44 PM | #15 |
Hall Of Famer
Join Date: Dec 2001
Location: SF Area, California Total Posts: 531,691
Posts: 2,363
|
Team Previews, all
__________________
JML MILKSHAKES Last edited by Rizon; 03-01-2012 at 01:04 PM. |
03-01-2012, 12:48 PM | #16 |
Hall Of Famer
Join Date: Dec 2001
Location: SF Area, California Total Posts: 531,691
Posts: 2,363
|
Team previews, detail by team (just NL)
Edit: fixed
__________________
JML MILKSHAKES Last edited by Rizon; 03-01-2012 at 01:08 PM. |
03-01-2012, 12:49 PM | #17 |
Hall Of Famer
Join Date: Dec 2001
Location: SF Area, California Total Posts: 531,691
Posts: 2,363
|
Draft and FA
__________________
JML MILKSHAKES Last edited by Rizon; 03-01-2012 at 01:05 PM. |
03-01-2012, 12:51 PM | #18 |
Hall Of Famer
Join Date: Dec 2001
Location: SF Area, California Total Posts: 531,691
Posts: 2,363
|
Salary management
__________________
JML MILKSHAKES Last edited by Rizon; 03-01-2012 at 01:05 PM. |
03-01-2012, 01:10 PM | #19 |
Hall Of Famer
Join Date: Dec 2001
Location: SF Area, California Total Posts: 531,691
Posts: 2,363
|
I've tinkered with how to rank each stat/rating for years and years and years, and kind of just got tired of re-evaluating them and just went with something kind of basic.
__________________
JML MILKSHAKES |
03-03-2012, 01:47 PM | #20 |
Minors (Single A)
Join Date: May 2005
Posts: 98
|
Rizon, these are fantastic and thank you for sharing these. on your depth chart sheet, what is the column with the +,-,x its right before before the players experience
|
Bookmarks |
Thread Tools | |
|
|