This was author and innovator Lou Poulas’ introduction last year, “While Grey and Rudy do a great job of breaking down everything you need to know for 2011 fantasy baseball, drafts still trip me up. I’ve been lamenting my inadequacies from the past 3+ years which resulted in an inordinate amount of time number crunching in Excel. My quest – a draft day “war room” that allowed me to keep my finger on the pulse of the league while minimizing my effort. I don’t know about you, but I prefer to keep track of more things as opposed to fewer.”
Presenting the free 2011 Fantasy Baseball War Room. It’s an auto-updating Excel workbook that keeps track of all the necessaries:
• Color Coded Dashboard that “crosses off” selected players.
• Team by Team analysis of players taken, players left.
• Real time projected totals, along with real time projected league standings.
• Goal Tracking Dashboard
Unfortunately, Lou was inundated with real work this year but was kind enough to allow me to make updates for 2011.
This year’s version has been slightly customized to Razzball:
- The Players page lists players in order of Grey’s top 300 with Grey’s projections. CHONE was not publicly available this year. FanGraphs stepped to the plate and graciously provided projections for players unranked by Grey. Several hundred additional unranked players were filled with Marcel projections.
- AB (At-Bats, i.e. playing time) provided by FanGraphs/Marcel.
- Goal Tracking has been pre-loaded with temp targets for “What it takes to win a 12 team fantasy baseball league.”
- The “Dashboard” displays players by position in order of Grey’s rankings.
- The ‘Team Rank’ box (League Standings) is limited to no more than 12 teams. Projected ‘Batting Totals’ and ‘Pitching Totals’ extend up to 25 teams.
- Up to 25 players may be drafted per team (allocations set by the user via the ‘User Input’ page).
- I have left the spreadsheet ‘unprotected’ so you may overlay with your own projections if you like.
The value of the War Room, for me, is to load the picks of a draft to determine which categories I am falling short in. In this manner, I can keep adding/deleting targeted players until I consistently get a strong team.
Click on the ‘Notes’ tab for instructions for how to load league team names, etc. Put questions and comments in this post and I’ll do my best to answer them.
Download the 2011 Fantasy Baseball War Room <–Snake Draft
Download the 2011 Fantasy Baseball War Room <–Auction Draft
Download the 2011 Fantasy Baseball War Room <–Point Shares Auction Values included
Download the 2011 Fantasy Baseball War Room <–Snake Draft, 13 or More Teams