Don't be shellfish...Share on FacebookTweet about this on TwitterShare on Google+

While Grey and Rudy do a great job of breaking down everything you need to know for 2010 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 2010 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.
• League wide finances – how much was spent, how much can still be spent, and that all important “Max Bid.”
• Real time projected totals, along with real time projected league standings.
• Goal Tracking Dashboard.
• Auto updating Draftee List for you team, that includes both the projected dollar amount and winning bid amount so you can keep track of your value gained or lost.

Download the 2010 Fantasy Baseball Snake War Room and/or 2010 Fantasy Baseball Auction War Room.  Any problems using it go ahead and ask in the comments.  Enjoy! (UPDATE:  These downloads are now Version 2.  Minor tweaks and inflation added.)

UPDATE II: NL-Only Straight Draft War Room; NL-Only Auction Draft War Room

UPDATE IIIAL-Only Straight Draft War Room; AL-Only Auction Draft War Room
UPDATE III 1/2: AL-Only Straight Draft War Room was tweaked.

UPDATE IV:  Auction War Room inflation tweak.

UPDATE V: Mixed League War Room with Grey’s projections in RED; Chone’s projections in BLACK.

UPDATE VI:  Tweak to the War Room with Grey’s projections.

  1. Grey

    Grey says:
    (link)

    Thanks for doing this again, Lou!

  2. AL KOHOLIC says:
    (link)

    cool,thanks ill give it a try

  3. Cheese

    Cheese says:
    (link)

    Interesting. I haven’t downloaded this yet, but is it mainly for draft use purposes? Is there anything about inputting projections or rankings?

  4. Ian says:
    (link)

    Wow. Amazing. Thanks a milly!

  5. Lou Poulas

    Lou says:
    (link)

    It comes pre-populated with Chone projections, but if you are handy in excel you can certainly update to your own.

  6. tourinct says:
    (link)

    Thanks, can’t wait to try them out.

  7. Cain Fan says:
    (link)

    Awesome, I appreciate it. Anyway to customize away from 5×5 and use say a 6×6? How would I go about adding 2 categories into the input? Thanks again!

  8. Tim says:
    (link)

    trying to use 14 teams, but the drop down box is only showing 12. does something need to be changed?

    this is great, thanks

  9. Josh says:
    (link)

    great, now I have to change my pants.

  10. WS2005 says:
    (link)

    Very cool tool, always wanted to make one myself, but never had the time.

    @ Tim

    To increase the number of teams, click on cell B3 and then click on data validation (in the Data tab in excel 2007). Then increase the range from
    =$AX$1:$AX$12 to the number of teams in your league (note the spreadsheet allows 25 names). So for 14 change it to =$AX$1:$AX$14

    Then copy that cell to all of the hitter/pitchers owners cells

  11. Greg says:
    (link)

    This may be a stupid question, but how does the chart know who has been drafted and to whom?

  12. Ian says:
    (link)

    @Greg: On the User Input sheet you name every team. Then, on the Players sheet, there is a drop down menu. You just select the team that drafted that player. This looks like a lot of help. I had no idea Excel had this kind of potential – ha

  13. matthole says:
    (link)

    @Lou: very clever, thanks a lot

  14. peter says:
    (link)

    Again, very impressive. I’ve been making my own spreadsheets for a while (granted, much simpler and MUCH less professional looking). Can you share what kind of formula (or macro? pivot table?) you used to put a strike though picked players on the Dashboard worksheet? I’ve been using a simple =IF formula to put an X in a column next to a selected players name. A strikethrough/cell shading would look way better.

  15. Dingo says:
    (link)

    This looks great, but it looks like you need a password to edit some of the sheets. Are you willing to provide an unlocked version?

    Thanks!

  16. Dingo says:
    (link)

    Whoops! Just read the notes and found the password. Thanks!

  17. peter says:
    (link)

    @peter: @Dingo: Nevermind, I think I found it thanks to Dingo pointing out that the pw was in the notes… I’ll dissect this, yet.

  18. Big Mike says:
    (link)

    @Lou: most excellent work! Problem I have is filling all that data into spreadsheet when every pick is 90 seconds (or less). Anyone know of a way to link Lou’s tool to a Yahoo draft app?

  19. Nate Marcum says:
    (link)

    Wonderful Lou! This should be the type of tool that I have needing for a fast paced auction league. I always am a little behind and not sure who I can outbid, who can outbid me, etc.

    I wish my friends were this smart. Grey, way to pick em!

  20. James says:
    (link)

    Is there a way to customize it for NL only or AL only leagues?

  21. Steve says:
    (link)

    @AL KOHOLIC: You’re not supposed to know about this.

  22. sean says:
    (link)

    This is fucking awesome! How’s that for an endorsement?!?

    This should not be free…

  23. brett says:
    (link)

    Awesome stuff, Lou. Thanks!
    The interactive summing and ranking features are cool but i’m equally impressed with the amount of information available in this thing.
    I think i’d rather avoid getting buried in data during my real drafts, but this will be great for guiding and post-processing my mock drafts.

    I agree with Big Mike that the next key feature would be cross-referencing this to the Yahoo or ESPN interface.

    Also, yeah, how did you do the strikethroughs?

  24. Lou Poulas

    Lou says:
    (link)

    Work has been calling way too much today, but have seen these comments and will take some time to respond tonight. Glad it has hit the mark with some of you!

  25. AL KOHOLIC says:
    (link)

    @Steve: im not sure i can actually figure it out yet,going to get nelly to help me out

  26. Bern says:
    (link)

    Wish you could add categories to War Room like Total Bases, look at positions filled by team, and enter in players in draft order.

  27. airlifting says:
    (link)

    shit runs deep, man! ryan rote?!

  28. Steve says:
    (link)

    @AL KOHOLIC: Hah! Eagerly awaiting that trade offer…

  29. Zobmie says:
    (link)

    Thanks a bundle, Lou! I’ll put this to good use.

  30. Dingo says:
    (link)

    @Bern: You can definitely add categories, provided you’re willing to mess around with Excel a bit. Just go to http://www.baseballprojection.com/ to download the full CHONE projections, do some matching and indexing, and voila!

  31. Ian says:
    (link)

    I don’t suppose anyone has an excel file of Grey’s projections they’d be able to share? It’d be cool to (easily) run his numbers as compared to CHONE’s.

  32. Chris says:
    (link)

    Anyway to add a team or teams past 12 teams? Also, I play 6×6 with OPS and Holds. Can that be added as well?

  33. tourinct says:
    (link)

    When I try to open with OpenOffice I get a “general input/output error”. Any ideas?

  34. sam says:
    (link)

    holy crap this is sweet. thanks!

  35. Dingo says:
    (link)

    @peter: Gotta love that conditional formatting!

  36. tourinct says:
    (link)

    Snake version opens no problem. And of coarse, I have a slow auction in process.

  37. david says:
    (link)

    teh best!

  38. tyler says:
    (link)

    Fantastic, fantastic product. How did you convert CHONE statistics into $ values?

  39. tyler says:
    (link)

    Also, for those of ya’ll that are more excel savvy, any chance of a step-by-step for adding other cats? If it would be ridonculously long, ignore me

  40. Geoffrey says:
    (link)

    Anyone tried opening this with OpenOffice Calc and have luck?

  41. Michael says:
    (link)

    really nice tool, thanks a lot!!

  42. shitbird says:
    (link)

    @Geoffrey: I was able to open it with openoffice 3.0.1 build 9379 and while I haven’t delved too deep, it seems to work great.

    @Lou: thanks brah

    I’m in an AL only leauge and was thinking of using filters to hide the NL players. My thoughts were either adding an AL/NL column next to each player on the players tab or just filtering based on the team names. I’m thinking the second is easier because it requires less work and I won’t have to insert more columns.

  43. timSTi says:
    (link)

    That is a gnarly freakin spreadsheet. Thanks Lou!

  44. Howie says:
    (link)

    Can I change a setting or two to allow for a 4×4 Roto league?

    Any way to account for inflation (keepers before the auction or draft and during the auction or draft itself)?

    Thanks,

  45. Lucky Strikes says:
    (link)

    I’ve never posted on this site but read it every single day. One of my favorite sites on the net, period. Thanks for the War Room file – great resource.

  46. tourinct says:
    (link)

    @Geoffrey: the snake opened in OpenOffice 3.0.0 and seems able to handle auction.. but the auction doesn’t open.

  47. Mark says:
    (link)

    Pretty sweet. I went to the Bloomberg thing yesterday and the product they have coming out is pretty good at quantifying position and statistical scarcity. If you’re interested the product comes out on the 18th, but it does cost $32.

  48. Howie says:
    (link)

    @Mark: Better than, say, the software offered by RotoLab or Fantistics?

  49. Charlie says:
    (link)

    This is great. What is everyone doing to make this into AL/NL only formats?

  50. Lou Poulas

    Lou says:
    (link)

    Wow, lots o good feedback! Thanks for the kind words everyone. Responding to some of the comments:

    – Customization – I wish I had a bit more excel knowledge with macros. As it is now, the only way I know to add columns is to create a brand new spreadsheet – have one for 6×6 leagues, one for NL only leagues, one for NL only 6×6 leagues – you can see it will get a bit crazy.

    Having said that, any user in a 5×5 league can swap out the categories for new ones. Just have to swap out rate stats with rate stats, and counting stats with counting ones. And, always make sure to mirror whether a lower number is the goal or a higher. Don’t ever swap out WHIP with another stat that awards points for “higher the better” performance.

    Maybe I can comeup with a generic template that will allow users to pick and choose whatever stats they need. I could do this I am sure, but the aesthetics would take a huge knock. Maybe better than nothing, will give it a try in the next few days.

    – NL and AL Only – at a minimum, i can create NL and AL only boards.

    – More teams – straight draft has more teams if you didn’t notice

    – $ Values – I created my own formula to come up with the dollar values. Basically, it weights each position based upon the expected minimum stats you would get in a 14 batter, 9 pitcher league. If anyone really is curious, I can go deeper into it or at least share the worksheet – standard deviation stuff, too, fun!

    – $ Inflation – you can change the dollar values in the spreadsheet yourself. Suggest unprotecting the sheet with the password, doing a quick formula to add x% to the dollar value I have, then replacing it. Actually, I can probably add an inflation calculator into it. Lemme try that – but you can certainly do it yourself too.

  51. Bern says:
    (link)

    My league uses TB rather than HR. I swapped out the category and values. How do I make the $ value recalculate? I assume I need your formula.

  52. Lou, I used your auction war room app last year with great satisfaction. Highly recommended, your excel skills are legendary.
    If anyone wants to try their hand at a mock draft, FantasyGameday has one opening for the Wednesday draft on Mock Draft Central scheduled for 8 PM EST. Password for all our drafts FGD2010.
    Here’s the link: FantasyGameday.net #3

  53. fuzzy dunlop says:
    (link)

    this spreadsheet is awesome. i used something similar that i created for my auction drafts last year. but my version only tracked my team, not the entire league. this is a major upgrade.

    i’d love to see the $ VALUES worksheet if possible. it’s something i’ve been wanting to do but never taken the time to build. i just use the baseballhq values for my drafts.

  54. Dexter says:
    (link)

    Thanks Lou! This is pretty great. Quick question for all, as I am not Excel savvy. Is there a way to click and drag names around to reorder the players based on Grey’s rankings? i.e., how do I move the players around to different rankings?

  55. Dave says:
    (link)

    Looks awesome! I tried the snake with the 25 team names listed, but I added 15 teams and when The drop down box displays on the player page, it only will display 12 teams….It misses the 3 other teams I named.. Any suggestions?

  56. Issam says:
    (link)

    Long time reader, first time poster, blah blah…this is just a sensational tool. I can’t say enough about how much I love the site and appreciate little things like that come draft day. Thanks again!

  57. Simply Fred

    Simply Fred says:
    (link)

    I ran Grey’s first complete mock orginally against B. James, then again against Grey’s when I got his hitters (pitchers still have James). He still ranks #2. I just re-entered the mock into this spreasheet. Grey came out #9. This probably explains why MDC has shown similar results. I knew that CHONE was lower than the others (about 10% overall), but thought everything was relative. NOT. CHONE does things like projecting SBs for Bourn, N. Morgan,R. Davis, Fowler, etc. about -50% (not the average -10%). This just a sample stab at why the results are quite different.

    The War Room is a fabulous tool. Just think you will be more pleased to see Grey’s numbers in there.

    Lou, consider adding columns to the right of each cat for ranking purposes. The spreadsheet can auto fill the rankings so that an extra column to the right with total ranks, and then sorted top to bottom, ends up ranking each of the twelve teams top to bottom. If you want to see a sample spreadsheet, email me at
    fred_barker@comcast.net

  58. Lost says:
    (link)

    I can’t figure out the password to save my life. Little help? Anyone? I checked the notes according to a previous post and came up with nothing. What am I doing wrong here?

  59. Simply Fred

    Simply Fred says:
    (link)

    @Lost: To just make it work (snake is all I tried) go to the Players page, click on the black under Owner; it gives you a drop down to select the team that picks the players. This after you go to the User Input page to id the teams. If you are wanting to un-protect and the password doesn’t work, you will have to go to Lou.

  60. Simply Fred

    Simply Fred says:
    (link)

    @Simply Fred: word: black = blank

  61. peter says:
    (link)

    @Lost: The PW is listed on the ‘notes’ worksheet: “fbhof”

    I suggest saving a new copy of the spreadsheet before making changes. Enjoy! And thanks again, Lou!

  62. Simply Fred

    Simply Fred says:
    (link)

    Lou, I noticed CHONE didn’t project Strasburg. Don’t know what your policy is, but some will be drafting him and without numbers in his slot, they will project zip. Fill with Grey’s?

  63. Bryan says:
    (link)

    WOW, this is insanely awesome!

    I can’t believe this is FREE!

    THANKS A BUNCH!

  64. pwire says:
    (link)

    Great Spreadsheet!

  65. Atherton32 says:
    (link)

    Great spreadsheet. This will help wonders on draft day. You could make some money selling this.

  66. Atherton32 says:
    (link)

    HELP FROM ANYONE

    When filling out the goals, if I am in a 14 team, 12×12 league any good ideas of what to set them at.

  67. KarlHungus says:
    (link)

    This is great.
    Nice work.

    Anxiously awaiting the NL only.
    Thanks.

  68. Disco says:
    (link)

    Francisco Rodriguez is listed twice … the ANA reliever should be Fernando Rodriguez

  69. Disco says:
    (link)

    But if it is Fernando Rodriguez, why is he worth $9 ??

  70. Lou Poulas

    Lou says:
    (link)

    Chone has Rodriguez listed twice, i didn’t catch that. I submitted a V2 to Grey today, not sure how he wants to handle updates yet. Also, V2 has inflation built into it :)

  71. Lou Poulas

    Lou says:
    (link)

    @ Simply Fred – yes, the tool will project no stats for him, and worse, it will not automatically show you that you took a player in either a round or an auction. Let me think on that.

  72. Lou Poulas

    Lou says:
    (link)

    @ Lost: Password is in the notes too, but here you go – “fbhof”

  73. Big Mike says:
    (link)

    @ Lou: I’m an Excel buff myself,but I can’t fiture how you got the dropdown list in the vitals on the players page. Can you describe for me how you did that?

  74. Simply Fred

    Simply Fred says:
    (link)

    @Big Mike: Yes, who is that wizard behind the curtain? Would like some of that magic myself.

  75. Lou Poulas

    Lou says:
    (link)

    @Big Mike: In excel 2007 it is the “Data Validation” tool. Once you click data validation, it gives you options as to what type of validation do you want – make sure the cell only has numeric values, whole numbers, dates, etc. There is another option for “List” – make sure the cell only has values from a list somewhere else in the spreadsheet. In this tab, my list is over in column BD, which actually links to the user input tab.

    Excel 2003 has the same feature, but I don’t recall which menu it can be found on. Search Data Validation in the help and it should take you there though. Good luck!

  76. Lou Poulas

    Lou says:
    (link)

    If you didn’t see, version 2 is now up in the body of this post, has the inflation calculator and fixes Frankie Rodriguez

  77. The Dude says:
    (link)

    Both my keeper leagues use a straight draft in order to increase parity in the league.

    Can this be converted to a Straight draft format? If so, how?

    Thanks – and this is sweet!

  78. Lou Poulas

    Lou says:
    (link)

    @The Dude: There are two files, one for straight draft and one for Auction. The straight draft doesn’t have inflation since dollar values aren’t needed, but you can certainly “check off” players that have been taken using the straight draft form.

  79. James says:
    (link)

    I want to thank you for taking the time to work on something like this and now I want to sound like a jerk and ask if there is any way to make it NL or AL only?

    I thought about just removing all the players that are in the league you don’t need from those tabs, but I was afraid that might mess with the formulas.

  80. Lou Poulas

    Lou says:
    (link)

    @James: Yes, working on them as we speak. The most difficult aspect of it is actually re-creating the dollar amounts for an NL or AL only league. Going postion by position, looking at the min expected stat and the std deviation of each category. Takes some time to go through and get it right.

  81. Dexter says:
    (link)

    @all
    is there a way to move guys up and down the rankings, or is it difficult for an Excel novice to do? Just want to align the rankings with Grey’s.
    Thanks!!!

  82. The Dude says:
    (link)

    @Lou: Heh – I suppose I should probably open the spreadsheet before posting dumb questions. I just went with the title – “Snake War Room” and figured it couldn’t be used in a Straight draft. Thanks again for making this public!

  83. Lou Poulas

    Lou says:
    (link)

    @Dexter: Yes, though be careful. And I assume you are talking about the “Dashboard” tab. I suggest you copy and paste the section you want to work on into a a new excel workbook, re order, and then paste back into the the Dashboard tab.

    Key part – please, please do this, when you paste back in, choose the Paste Special, “Values”, option. This will keep the formatting in place and allow the auto cross outs to remain functional. If you don’t do this, you’ll erase some key functionality.

  84. Clodbuster says:
    (link)

    Thanks Lou, this is sweet!

    I’m Excel illiterate though and I’m having a hard time adding two teams to make the total 14. I tried an earlier users suggestion by clicking box B 3 and adding the info he had but I keep getting erfror messages. Perhaps i have a different version? I have ’07 If that makes any difference.

    If you have a moment, can you please tell me exactly what to type in the; data, minimum, and maximum sections.

    Thanks a ton!

  85. Lou Poulas

    Lou says:
    (link)

    @Clodbuster: I am embarassed, it is my own spreadsheet and I don’t know where you mean for the data, min, and max sections.

    If you want to add 14 teams, you have to add new rows after every section on the War Room tab as well as the User Input Tab. If you copy the formula’s down the 1st two and lest sections of the war room will work, but the rank section willl not. This is because the rank is based upon 12 teams, if you add 14, go into the formula’s and anywhere you see a “13-Rank” replace 13 with 15.

    This can be fairly complicated. Give it a shot, if it doesn’t work would be happy to assist some more

  86. Mike says:
    (link)

    Lou, great idea and thank you for sharing.

    I’m wondering if the inflation could be done differently. Right now it appears as if the inflation is a one-time calculation performed prior to the auction. Could it be altered so that it is recalculated after every player is purchased? That way if someone splurges on a player we’ll know the impact on the players that are left.

    Thanks

  87. Big Mike says:
    (link)

    @Lou, you didn’t know this was going to turn into a fulltime unpaid gig, did you?

    I’ll repost an earlier comment: Does anyone have a utility that’ll link Lou’s work to Yahoo’s draft application? That would make this truely amazing … keeping you from running back & forth between Yahoo & spreadsheet in less than 90 seconds each time.

    Thanks!

  88. Bern says:
    (link)

    @Lou

    What is the formula for crossing out the players and where is the formula located?

  89. James says:
    (link)

    @Lou: Thanks, you sir are a gentleman and a scholar.

  90. Lou Poulas

    Lou says:
    (link)

    @Bern: It is a combination of vlookup’s and conditional formatting. For instance, unhide columns C and D for catchers on the Dashboard tab and you will see it.

    Basically – i tell it to
    1) Look Up Joe Mauer on the Players Tab
    2) If there is a value in the column next to Mauer (the Drafting Team) then populate Column C with the drafting team.
    3) in Column D I have another formula. If Column C is populated, return a value of 1, if it is not populated, return a value of 0
    4) Finally, in Column A with the player name i have a conditional format. It says, if Column D is greater than 0 cross off and shade the cell with the players name.

    Hope this helps

  91. Lou Poulas

    Lou says:
    (link)

    @Big Mike: LOL. I wish I knew how to link this to Yahoo or ESPN or something, but alas, way beyond my capabilities!

  92. Lou Poulas

    Lou says:
    (link)

    @Mike: Hey Mike, you are in luck! The inflation already recalculates after each draft pick. It uses the dollar amount that was drafted for each player.

  93. Chuck says:
    (link)

    What do you do if a player is drafted who is not on any of the lists and will this screw things up?

  94. Lou Poulas

    Lou says:
    (link)

    @Chuck: Hey Chuck. I usually overwrite one of the scrubs with the new persons data. i would not generally monkey around with inserting rows unless you are very excel savvy.

  95. worm says:
    (link)

    Hey I’m in an auction league where min is .50 and moves in increments of .25 cents. Is there any way to get this file to not round up?

  96. NotLost says:
    (link)

    @peter: @peter: Thank you all. Think I got, and holy fricken crap, it’s pretty awesome. Thanks again.

  97. behjota says:
    (link)

    I’m in a 10 team, mixed, 6X6, H2H, keeper league (4 keepers per team based on draft position of previous year), no auction values… any suggestions on how to manipulate the sheet to fit this type of league?

    Pretty sweet though, nice work.

  98. KarlHungus says:
    (link)

    Lou,

    Any luck cranking out the NL only version?
    I’d be happy to compensate you for your time.
    In at least the form of a couple nice cold beers.

    Thanks again.
    Very nice tool.

  99. John B says:
    (link)

    Nice spreadsheet. I made one myself with some free time at work and dare say it’s better functionally (I just plugged yahoo’s rankings).

    If you want a copy to see it, shoot me an email at john_m_britt@yahoo.com

  100. Lou Poulas

    Lou says:
    (link)

    @worm: You should be able to increase the decimals with the std functionality excel has. No rounding is taking place, just not displaying the full values to the right of the decimal.

  101. Lou Poulas

    Lou says:
    (link)

    @KarlHungus: Mmmm, beer.

    Yes, NL version complete, though Grey is going to post AL and NL at same time. I was out of town last few days so haven’t had a chance to complete.

  102. Lou Poulas

    Lou says:
    (link)

    @John B: Sweet! I think i have more fun creating then using.

  103. Lou Poulas

    Lou says:
    (link)

    @KarlHungus: I haven’t been able to crack the code on creating a sheet with unlimited functionality for league/scoring type. Sorry!

  104. Jacob says:
    (link)

    impressive, no…amazing. I can’t wait for the NL only version!

  105. James says:
    (link)

    @Lou: Thanks!

  106. Fuzzy Dunlop says:
    (link)

    @Lou: are you aware of any way to properly split category points in the event of a tie? currently if the top two teams in HR are both projected to finish the season at 300, the RANK() function gives each team 12 points. the actual scoring for this should be 11.5 points for each team. i tried scrolling through the statistical functions but couldn’t come up with any way to get around this.

  107. Tom says:
    (link)

    Just wondering if I missed it, but i was looking for an AL only version that may have a 4×4 option attached to it…and by the way, may I say this thing freaking rocks!

  108. wiudavis says:
    (link)

    @Lou. ” – $ Values – …..If anyone really is curious, I can go deeper into it or at least share the worksheet” I would love to get a looksie at this bad boy. Can you email or send me a link?

  109. Rhymenoceros says:
    (link)

    Great work, Lou! I appreciate the tool and the hard work. It’s already proven to be effective in my mock drafts.

  110. Rhymenoceros says:
    (link)

    I suppose this is a request for next year, but could you include the Razzball point shares? I find them helpful when evaluating players, and having all my information in one Excel workbook is priceless.

  111. matthew says:
    (link)

    maybe im being daft, but where do i enter what the player was purchased for in an auction draft? it tells me the cells are protected, but the instructions say “This is only to avoid end user errors that will corrupt the file.” leading me to believe i am looking in the wrong place

    thanks

  112. Rhymenoceros says:
    (link)

    @matthew You can unlock the cells by entering the password found on the notes tab.

  113. Lou Poulas

    Lou says:
    (link)

    @Fuzzy Dunlop: Sorry, I don’t know how to break the tie with excel’s rank formula. I have noticed that, and it is a tad frustrating.

  114. Lou Poulas

    Lou says:
    (link)

    @Tom: On my list is a way to customize non standard leagues. I think it might end up being a 2011 feature though.

  115. Lou Poulas

    Lou says:
    (link)

    @wiudavis: Yeah, kind of a mad scientist spreadsheet, but if you are interested post your email and I will send it to you.

  116. Lou Poulas

    Lou says:
    (link)

    @Rhymenoceros: Thynks! Another wish list item. The problem I had was Chone projects 1500-2000 players. Winshares looks at the top 300. What do I do with the rest – ignore them?

  117. Lou Poulas

    Lou says:
    (link)

    @matthew: If the players tab is locked, it was my mistake. But Rhymenoceros is correct that the password is in the notes in first tab.

  118. Fuzzy Dunlop says:
    (link)

    @Lou: would love to see behind the curtain on dollar values if you don’t mind emailing it to me at fzydunlop at gmail dot com. thanks again for all your effort on this. it’s going to make draft day much easier!

  119. Rhymenoceros says:
    (link)

    @Lou: I’d say include the 300 players because in a 12 team, 23 round draft, we’re only look at about 360 players total being drafted. So, keep the 300 and add 60 more. Honestly, what am I going to do with an extra 900 players?

  120. Lou Poulas

    Lou says:
    (link)

    @Fuzzy Dunlop: Just sent. I feel i should have something akin to that video game epilepsy warning – be warned that viewing hundreds of excel formulas in random colors may cause momentary loss of consciousness or epileptic seizures

  121. Lou Poulas

    Lou says:
    (link)

    @Rhymenoceros: Thanks for feedback. So, basically have a file that lists the Razzball projected stats and Win share amounts for the Top 300, and the balance of the 1500 players using Chone sans Win Shares?

  122. wiudavis says:
    (link)

    @Lou: Sorry I forgot my email..duh. Let’s see the mad scientist spreadsheet. wiudavis@hotmail.com

  123. potus says:
    (link)

    Lou great work. Working through some of the #’s I think I found a formula mistake on the ‘User Input’ page. Cell J4 on the ‘User Input’ page is referencing the ‘Players’ tab…. columns V and AU. This is the ‘saved’ value for each player. I think it should be the TOTAL value paid for each player(either kept or bought during the auction)….you can go about creating this formula a few different ways.

    I may be wrong, as I looked through this very quickly, but the ‘inflation’ just didn’t seem to be working properly. Also, this will allow in-draft inflation to be correctly calculated as well as keeper inflation.

    Need to poke around a bit more but this looks wonderful.

    Thanks again!

  124. Fuzzy Dunlop says:
    (link)

    @Lou: the seizure-inducing file never made it. do you mind trying again? fzydunlop (at) gmail.com. thanks again!

  125. Lou Poulas

    Lou says:
    (link)

    @Fuzzy Dunlop: just resent. let me know if you don’t get it and i will host it somewhere. several mb large, maybe that is the issue.

  126. Lou Poulas

    Lou says:
    (link)

    @potus: Potus for sure! Yes, I agree, mistake on my part and I have submitted the fix to Grey.

    Nice catch!

  127. Dom says:
    (link)

    Thanks for putting this together!

    Jack Cust is missing from the AL only league, how can I add him?

    Dom

  128. BJ says:
    (link)

    Is there going to be an update with prospects and rookies like Strasburg for those of us in deep or keeper leagues?

  129. pwire says:
    (link)

    Lou,
    The scroll down for teams on the players tab will only show 12 teams. Can you direct me on how to fix it?

    I am in a 14 team league and the last two wont be displayed as an option.

    Thanks again for such a great tool.

  130. Lou Poulas

    Lou says:
    (link)

    @pwire: Sorry ’bout that. I will submit an update to Grey too. In the meantime….

    – In Excel highlight all records in the Owner column for batters. Cells B3-B1370.
    – Choose Data Validation from the Data menu.
    – It should bring up a Source formula of =$AX$1:$AX$12.
    – You need to extend it to row 25. When done it should read =$AX$1:$AX$25.

    Repeat this for the pitchers and you are done!

  131. Lou Poulas

    Lou says:
    (link)

    To add any player, I suggest typing over one of the scrubs that one get drafted, and add the projections manually.

    1) On players tab, overwrite the data in Columns A and D through L
    2) If you re-sort, be sure to include just the columns in the batters section.
    3) Go to the Dashboard and overwrite the same exact player that you did on the players tab.
    4) Be sure to spell the player the same exact way, including commas and spaces.

    Should be it.

    Lou

  132. Steve says:
    (link)

    Thanks for this! I am excel challenged and have a question. My league is 20 teams and we don’t use every MLB team. When I delete players form the “players” list it makes my selected battters and pitchers disappear from the war room’s selected players list. Is there anyway to delete players without causing problems elsewhere? thanks

  133. cleaver596 says:
    (link)

    Fantastic work. Last year this thing gave me such an edge. I love being able to see where my team is projected compared to everyone else while the draft is in progress. One question I did have was when inputting the number of players, where should I put bench players? Since they won’t acquire any stats, but still be on the team. SHould i decide how many hitters and pitchers I want to have on my bench and include them in the C-17 and C-18 on the user input page? My auction league starts 10 hitters, 8 pitchers and has 5 bench spots. Any thoughts?

  134. birrrdy! says:
    (link)

    Awesome work, Lou.

    Just to reiterate some of the other comments, adding Grey’s projections for your NL only product would be great as well. However, I just checked out the new updated mixed league workbook with Grey’s numbers. Something doesn’t seem to be quite jiving. For example, Chris Carpenter gets a huge boost in numbers, but remains way down on the price list. Also, Grey is very high on Justin Upton, but he is way down on the list.

    Do the rankings and auction prices automatically update when the stats are changed for a player?

    Also, two more questions: (1) does the spreadsheet still work if you only have 10 teams?; and (2) how are we supposed to handle keepers? Do we just treat them as auction bids and enter them all in beforehand? Can we also add an inflation multiple to certain players (elite and/or young w/high upside) that are more desireable in keeper leagues (e.g. Pablo Sandoval, Justin Upton, etc.)

    THX!

  135. cleaver596 says:
    (link)

    are the projections the average of different sources’ projections?

  136. Lou Poulas

    Lou says:
    (link)

    @cleaver596: Last year they were, this year just chone, though Grey posted a new one that his Razzball’s too!

  137. Lou Poulas

    Lou says:
    (link)

    @birrrdy!: Hmm, I actually didn’t create the new Razzball file. And you are right, the $$ presented do not reflect the new stats.

    Spreadsheet will work with 10 teams, though, be careful with the rankings sections. Functionality still works but the final rank may not be 1-10. Just remember that the lower the rank the better (ha).

    Yes, enter them as if they were drafted. You can certainly add in any multiplier you might see fit – password is in the notes tab.

  138. YouthofToday says:
    (link)

    Lou, fantastic spreadsheet. Do you think you could add the seizure-inducing excel file as update V? I’m new to the advanced capabilities of excel and was curious how you were able to derive auction values from projections.

  139. Lou Poulas

    Lou says:
    (link)

    @YouthofToday: Thanks. The dollar calculations really isn’t a match for the War room, mainly because of size. It would make on file too bulky to work with on a routine basis. Happy to email it to you though, just post your email address here and I will send along.

  140. YouthofToday says:
    (link)

    Thanks. Duly appreciated. andrew_ausanka_crues (AT) yahoo (dot) com.

  141. Lou Poulas

    Lou says:
    (link)

    @YouthofToday: Sent. It is over 2MB, let me know if you didn’t get it.

  142. birrrdy! says:
    (link)

    Would also like the full worksheet formulas (for dollar calculations) if you can spare it, especially if it also has functional tabs for NL only.

    email to use is bilstad (AT) hotmail (dot) com.

    THX!

  143. Lou Poulas

    Lou says:
    (link)

    @birrrdy!: Sent!

  144. pwire says:
    (link)

    Thanks Lou,
    I fixed the data validation… Works great now! Again, thanks for your time and effort…

  145. Orion says:
    (link)

    Lou, thanks for the new sheet w/Greys. Why are some players projected with Grey’s in red and others with Chone in black. Are you only using Grey’s when there’s a significant difference?

    Also, with the new v4, the “Your Selected Players” area of the War Room tab doesn’t seem to show the player names, although it does seem to record them and show the price.

  146. Dave says:
    (link)

    I’m probably being really really stupid, but its early, but in the Auction Sheet, what is the Kept $ column for?

  147. JOE says:
    (link)

    Just found this site and JEEZ what i have been missing. This simply is an amazing tool!!! Thanks for all the effort, much appreciated.

  148. Dexter says:
    (link)

    Yeah, I also can’t get the “Your Selected Players” section to fill in with the names and positions.

  149. Dexter says:
    (link)

    Also, it is difficult to find the names to enter them during a timed snake draft, once you get past the top 50 or so names which most people take initially. Is there a better/easier way to sort the names or enter them under the teams that drafted them?
    All this said, the tool is amazing!!! I really appreciate the time and effort that went into it.

  150. timSTi says:
    (link)

    @Dexter: i was planning on just using the find function of excel.

  151. Steve says:
    (link)

    In the most recent update, it looks like the area where “Your Selected Players” are automatically entered is missing that function. Is it just me? Thanks for this very cool tool!

  152. Lou Poulas

    Lou says:
    (link)

    I’ll take a look at the latest one tonight. I technically didn’t do the excel work, but will try and find what the issue is and resubmit to grey.

  153. Lou Poulas

    Lou says:
    (link)

    @Dexter: This is the one particular thing I wish I had a way of changing. I too have a difficult time keeping up with all the names in a 90 second pick scheme. I have done it with the search function (CTRL-F is the shortcut) but it still is a bit of work to keep up with. One thing I do do is keep track of the total # of players picked. Most online tools like Yahoo or ESPN easily show somewhere the total # of players taken. Great little check to make sure you didn’t miss someone is total the number of players on the war room and always make sure it is the same.

    I added it to the sheet with Grey stats on it, but simple enuogh that anywone shold be able to do it. Just use the =sum() formula and in the brackets put the cells you want to total up on the war room.

  154. Lou Poulas

    Lou says:
    (link)

    OK – resubmitted the “Grey” stats war room and it resolves the “your selected Players” issue.

  155. Lou Poulas

    Lou says:
    (link)

    @Dave: It is for inflation calculation in keeper leagues. Put the $$ amounts for each “kept” player from the previous season.

  156. Lou Poulas

    Lou says:
    (link)

    @Orion: We used Greys stats for every player he had projected them for, about 300. Those are all in red. The ones remaining in black are basic Chone projections.

  157. Dexter says:
    (link)

    That’s great! I didn’t realize that there was that find feature. Thanks!

  158. Cabby says:
    (link)

    Hey, great tool. Just wondering what the breakdown is for pitchers and hittters for the auction values. Is it 30/70…

  159. Lou Poulas

    Lou says:
    (link)

    @Cabby: Yes, exactly

  160. Matt says:
    (link)

    Lou,

    Great spreadsheet. I was just curious as to what the “C” and “T” represented in the goal tracking tab?

  161. Lou Poulas

    Lou says:
    (link)

    @Matt: T is for Target and C is for Current. The T is driven from goals an owner enters on the “User Input” tab, and the C is driven from the projected stats accumulated during the draft.

  162. airlifting says:
    (link)

    couple questions; under inflation calculation….is “total money available” for the whole league (i.e. $3120) or one team ($260)? does the inflation calculator only take effect during the draft?

    i think that’s all. awesome tool, man. thanks.

  163. Rob says:
    (link)

    So I was reading through all of the comments and I saw that you talked about how to add more teams. I am in an 18 team league. When you said click on B3, there is no formula there. Any help? This is one amazing product and i can’t believe it’s free!

  164. RandyO says:
    (link)

    Thanks for this awesome spreadsheet. I know it took alot of work.

    Couple of questions, 1)our league has a roster of 23 players-13 batters,9 pitchers and 1 utility which can be a batter or pitcher, how do I account for that, 2) our league budget is $26 rather than the normal $260. Is there a way that I can recalculate the values based on this?

    Thanks again for all your hard work!!

  165. tony_m says:
    (link)

    I noticed that in the AL Only Snake version that when trying to select an owner for Hitters that there seems to be some sort of error(no drop down list or Owners). Pitcher selection seems to work just fine.

    Maybe I’m missing something, but I’ve checked other sheets and this seems to be specific to the AL only Snake sheet.

    Thank you so much for such an amazing tool. Donations accepted? If so- where?

  166. birrrdy! says:
    (link)

    Any way to get a war room tweak that:

    (i) incorporates Greys numbers AND the corresponding dollar values (currently, the $ values appear unchanged)
    (ii) is for NL only leagues?

    Only other hope is that it can be customizable for number of teams (e.g. 10), total auction dollars (e.g. $300), and keepers, but I would be thrilled with just the tweaks for (i) and (ii).

    THX!

  167. Swagger Jackers says:
    (link)

    I posted this in the Razz Forum but this appears to be the proper place:

    I was looking through the “Mixed League War Room with Grey’s projections” spreadsheet but noticed the rankings are still CHONE. The order of the players in the Dashboard tab and the Players tab don’t line up with Grey’s Top 300. Sooooo I spent some time cutting and pasting his top 300 into the proper order only to find out it ruined a bunch of formulas (must have been the hidden cell data).

    Are there any plans to get the player rankings in those two tabs adjusted to Grey’s predictions?

    PS: I love the tool, this is something I attempted to do last year but failed miserably.

  168. Lou Poulas

    Lou says:
    (link)

    @airlifting: Total Money available is automatically calculated by the team budget. The only section you need to calculate in the inflation area is highlighted in gray – Total Teams in the league.

    Inflation works before the draft if you put in your keepers and automatically updates during the draft as well.

    Good luck!

  169. Lou Poulas

    Lou says:
    (link)

    @RandyO: The dollar values are calculated offline and don’t automatically regenerate based upon league parameters.

  170. Lou Poulas

    Lou says:
    (link)

    @tony_m: Thanks! And sorry, my fault. I am submitting a new template to Grey in 10 minutes. To fix yourself, go into data validation and put the following in the formula box: =$AX$1:$AX$25

    Data Validation is on the data tab in Excel 2007 and on the Data drop down menu in earlier versions.

  171. Lou Poulas

    Lou says:
    (link)

    @Swagger Jackers: I gave this a shot and it is a bear of a job, and it will have to go into a 2011 release.

    However, any enterprising fantasy baseball freaks can take the torch and do this themselves. In a nutshell:

    For each position
    1 – Copy the names of the players off of the War Room Dashboard into a new excel workbook.
    2 – Re order the names
    3 – “Paste Special”, “Values” back into the war room tab. Using Values tells excel to only put the data back in and not to override formatting or formulas.

    It is critical you don’t rename the players that are listed in the war room. If I have Jorge de_la_rosa for instance, please don’t rename them to “de la rosa” or the vlookup formula’s will fail.

    This is a fairly simple exercise just extremely time consuming.

    Post here if you have any difficulties!

  172. Lou Poulas

    Lou says:
    (link)

    @birrrdy!: I am out of time :( ! For this year anyway, it will have to be a 2011 update.

  173. birrrdy! says:
    (link)

    no worries, your tool is awesome and thanks for doing it, Lou!

    a heads-up to everyone else. A similar tool appears to be able at a site called LastPlayerPicked.com.

    http://www.lastplayerpicked.com/priceguide/

    It allows you to take all of the data that others have compiled into spreadsheets with data from Grey, etc., and customize it for your league. Doesn’t have Lou’s war-room’s nifty inflation calculator, but has some seriously customizable dollar-value calculators. Just need to put in the effort to make the required .csv file (and guesstimate things like total hits for batters, plus Hs, BBs, and HBPs for pitchers by reverse-engineering Grey’s average and ratio projections).

    Let’s just say putting in Grey’s calculations spits out some pretty impressive dollar values for a guy like Lincecum (in my NL only league). Same goes for Pujols vs. Hanley. I’m going to try to load these new dollar values into the war-room tool to see if it still works and allows me to project inflation, etc.

    I’ve seen the future in fantasy baseball… Lou’s tool, plus LastPlayerPicked customizability, plus Grey’s projections, equals fantasy dominance!!!

    :)

  174. Great tool!!@Lou I used it last year for two of my 5×5 roto leagues and everyone in the league was jealous.. Love the update with Grey’s projections. I tried finding it at FBHOF but that doesn’t exist anymore, next step was obviously the holy grail at Razzball.

    Next step is definitely pulling from the ESPN/Yahoo/CBS API and synching the picks to the sheet.

    I bet if we pooled enough $$ together through donations it could be outsourced to someone with the technical savvy to do so.

  175. birrrdy! says:
    (link)

    If anyone else happens to use the lastplayerpicked.com tool, please post your thoughts and analysis here. The results on dollar values is great. I will probably recalculate all the dollar values with Grey’s stats (and my own custom modifications), and then load them into Lou’s war-room tool.

    Should be the best of all worlds if that will work with the inflation calculator, and keeper values, etc.

    But would love some critical analysis from some of you stats geniuses out there…

  176. Chris says:
    (link)

    Lou,

    I’d like the accompanying baseball nerd file, too. Please send it to chriswaye at hotmail dot com. Thanks!

  177. Kenny says:
    (link)

    Hey Lou,

    Thanks for doing this for us man. I would love to get the formulas if possible.

    kennycarvalho[@gmail.com]

    Thanks man!

    -Kenny

  178. Lou Poulas

    Lou says:
    (link)

    @Chris: Any alternate address? Hotmail is rejecting saying file is to large 2.4mb

  179. Mikeytmoney says:
    (link)

    Hey Lou!

    Simply Amazing

    I am having some trouble with the goal tracking on the war room tab. The ratio stats seem to be working fine, but the counting stats in the T section show as #DIV/0! or ####

    Any ideas?

    Much thanks once again…this is freakin incredible!

  180. Tobewan says:
    (link)

    On the NL only sheet, i can’t find Adam LaRoche. Is he there an I’m not seeing him?

    Thanks, love this resource.

  181. Tobewan says:
    (link)

    @Tobewan: Sorry, having trouble finding Brett Myers as well. NL Only Auction WAR

  182. Lou Poulas

    Lou says:
    (link)

    @Tobewan: LaRoche and Myers were free agents at the time Chone produced these projections. Because they didn’t have teams, Chone didn’t know what to project.

    Long way of saying i don’t have their projections and you would have to add them yourself. Sorry!

  183. Lou Poulas

    Lou says:
    (link)

    @Mikeytmoney: COuld be two reasons, and it is working on mine so I would like you to try first before looking further.

    1 – expand the width of the column. ##### could simply mean on your screen resolution the characters in the cell aren’t fitting with the width that I originally setup. Just widen the column.

    2 – #DIV/0 likely just means you haven’t selected enough players. Try a test where you put two pitchers and two batters on your team, if that doesn’t solve it let me know. Good luck!

  184. TMac says:
    (link)

    just discovered this 2 days ago and am stunned. i am pinning my lack of success on not knowing this existed.

    my league auctions for 22 players instead of 23. is there anyway to adjust that in the spreadsheet?

    great job.

  185. Euroalien says:
    (link)

    Hi…… I noticed that the ranking section on the War Room tab doesn’t seem to be working. I’m not sure if the formula is correct, or if it’s a user error. Being pretty limited in my Excel skills, I thought I’d ask.

    This is the formula in one of the cells…….. =RANK(C87,C$87:C$111,1)

    Thanks for providing a GREAT tool!!

  186. Lou Poulas

    Lou says:
    (link)

    @Euroalien: Which war room are you using? I downloaded one and it seemed ok, but there are several as you know!

  187. Euroalien says:
    (link)

    @Lou: Lou, I was messing with the formula today and I think I figured out why it wasn’t working. So I’m all good! Thanks for checking – Love the tool!

  188. Jon says:
    (link)

    Thanks so much for this. I modified it to have a “Teams” sheet that lists everyone’s teams, like it does in the “War Room” sheet for your own team.

  189. Mike says:
    (link)

    Lou, great spreadsheet. However any team after the 12th doesn’t show up in the drop down menu on the players page, is there a way to add more than 12 teams?

  190. AfterTheSea says:
    (link)

    Mike, see comment #10. It worked for me.

    “Very cool tool, always wanted to make one myself, but never had the time.

    @ Tim

    To increase the number of teams, click on cell B3 and then click on data validation (in the Data tab in excel 2007). Then increase the range from
    =$AX$1:$AX$12 to the number of teams in your league (note the spreadsheet allows 25 names). So for 14 change it to =$AX$1:$AX$14

    Then copy that cell to all of the hitter/pitchers owners cells”

  191. Dexter says:
    (link)

    In the Straight Draft with Grey’s projections it will not spit out projected batting and pitching totals with points. Does anyone know why?

  192. Dexter says:
    (link)

    Sorry while i said totals, I meant Ranks.

  193. Victor says:
    (link)

    This is my first time on this website and I can’t get off! This website is amazing. I was trying to open your “mixed league war room” but it gives me an error. Any suggestions?

  194. Lou Poulas

    Lou says:
    (link)

    @Dexter: Hi Dexter. I knew there was a reason why I didn’t include ranks in my initial straight draft. The formula isn’t recognizing the fact you don’t have 24 total teams. I don’t know how to automatically change this, but there is a one time manual work around you can do.

    If you have a 10 team league, delete the records below Team 10 in both the batter and pitcher per player sections. In the 10 team league example, this would be rows 94 through 111. If you had 12 teams, it would be row 96 through 111.

    Hope this helps!

  195. Lou Poulas

    Lou says:
    (link)

    @Victor: I just tried it Victor and it worked fine. Odd.

    Have you tried a few times? Maybe right click and “save as”. Do you have excel?

  196. Schlitzy says:
    (link)

    Great tool. Can I change dollar values to the razzball point share dollar values without screwing anything up?

  197. Lou Poulas

    Lou says:
    (link)

    Yes you can

  198. Russ says:
    (link)

    Wish there was a Google Docs version. I don’t have Office. :(

  199. Russ says:
    (link)

    I should add that the file is too big to upload to Google Docs. It only allows .xls files up to 1 MB.

    I should also add thanks for the hard work.

  200. Brian says:
    (link)

    Hey, great info. Would you be able to send the spreadsheet also? blcloney@gmail.com. Thanks.

  201. Euroalien says:
    (link)

    I just noticed that on the Projected Pitching Ranks the ERA & WHIP rankings are reversed, so that the HIGHEST ERA & WHIP are getting 12 points, etc. Is there a fix for this……….? Thanks for his GREAT tool!

  202. Steve says:
    (link)

    Lou – my auction keeper has 11 hitters, 7 pitchers and 7 bench spots.

    Any suggestions for how to take account of that when filling out the ‘Team Budget’ section of the ‘User input’ tab?

  203. Lou Poulas

    Lou says:
    (link)

    @Brian: Sent

  204. Lou Poulas

    Lou says:
    (link)

    @Euroalien: WHich war room are you using?

  205. Lou Poulas

    Lou says:
    (link)

    @Steve: Unfortunately aside from a major re-work of the tool there is nothing that I can really do for this or any of the custom leagues out there. Sorry!

  206. Steve says:
    (link)

    @Lou: No worries!

  207. Mike says:
    (link)

    Hey Lou:

    I was wondering if you could do me a huge favor. I updated the 2009 spreadsheet myself with ranks and projections from cbs sportsline. However, along the way , I seem to have fouled up some of the formulas. If I email you the file, could you work your magic to make everything work. I’d be glad to compensate you for your time. You could even use it yourself/make it available for download, as it is up to date. I dont think it would take very long for you. I just dont have the time or patience. Thanks!

  208. Matthew Raynor says:
    (link)

    Incredible program. I just inputted all the information from our draft and I am having trouble getting the Projected Batting Ranks and the Projected Pitching Ranks to spit out the information. I’m assuming I need to signify somewhere that it is only 12 teams and not 25 teams? Please let me know.Once again incredible spreadsheet

  209. Lou Poulas

    Lou says:
    (link)

    @Matthew Raynor:Not sure what file you are using, but i think my comment above will hit the mark in your situation too…

    @Dexter: Hi Dexter. I knew there was a reason why I didn’t include ranks in my initial straight draft. The formula isn’t recognizing the fact you don’t have 24 total teams. I don’t know how to automatically change this, but there is a one time manual work around you can do.

    If you have a 10 team league, delete the records below Team 10 in both the batter and pitcher per player sections. In the 10 team league example, this would be rows 94 through 111. If you had 12 teams, it would be row 96 through 111.

    Hope this helps!

  210. Lou Poulas

    Lou says:
    (link)

    @Mike: Mike, happy to take a look. If something simple, I am sure I can handle, if the whole sheet is fouled up I don’t think I will have the time to recreate it.

    lpoulas at gmail.com

  211. mikey boy324 says:
    (link)

    lou i just downloaded it and when i try to make changes it asks me for a password to unprotect the sheet an i doing something wrong?

  212. mike says:
    (link)

    @mikeyboy324

    The password to make adjustments is fbhof.

    Says so on the ‘notes’ tab.

    Make changes at your own risk.

  213. mikey boy324 says:
    (link)

    thanks im just trying to fix the rankings a lil

  214. Buck weaver says:
    (link)

    For those who noticed that the Projected Rankings on the war room tab are incorrrectly calculated for ERA and WHIP (high number is bad not good) simply click on a cell and change the ‘1’ after the last comma to a ‘0’ that’s zero not oh. this will then give you more ranking points for good era and whip.
    love the spreadsheet!

  215. pieter says:
    (link)

    Great xls, thanks!
    Question: on the War Room tab, the Batting Rank and Pitching Rank tables show only ###### values, usually meaning that I have to make the column a little wider. But that doesn’t seem possible.
    I have populated the sheet with the 7 teams and 8 keepers per team for our 15×15, 600$ team budget league.
    Thnx!

  216. Lou Poulas

    Lou says:
    (link)

    @pieter: Think you just have to unprotect the sheet. password is fbhof

  217. Professor Chaos says:
    (link)

    I opened the snake draft one and there are dollar figures and spots for max bid, etc. Can I just ignore that stuff during the snake draft? Incredible piece of work. You should really be charging for this.

  218. Bryan says:
    (link)

    Really nice tool! I just wish it had an easy way to update players on the fly. I was using the NL Auction Draft version, and there were a lot of players that I had to unlock the sheet and add, which actually messed it up when I tried to summarize and track later. Also, it would be great if it showed tabs for each team’s lineup so I could see what positions my competition was desperate for, so I could strategize my auction callouts. But otherwise really great!

  219. Jerry says:
    (link)

    Lou I took your spreadsheet to a whole new level man. I used it last year and wanted to expand the awesome job that you already did. YOu laid the foundation for my sheet. Here are some of the things I added to make it more usuable to all league types.

    1. I took your players page and made it a total players page based on CBS projections. (this allowed me to view who the best overall player was.)

    2. I created a hitters only page and a pitcher only page. (this allowed me to view who the best hitter available was. and who the best pitcher)

    3. I created a page for each position C, 1B ….etc. (to help me when I needed to fill a position and see who the next best player at that position was)

    4. I made it so that every page that had player names input crossed them off when selected to a team. (right now you only have the breakdown sheet doing that.)

    5. I made the player page usuable for 4×4,5×5,6×6 all the way up to 15 statistical catagories for owners. This feature allowed me to keep track of every catagory that we score in our league for both hitters and pitchers. I found that it is also usable for a league that plays head to head also.

    6. I put in a positional breakdown on the warroom page so I could track which owners still needed to fill certain positions.

    7. I took the player selceted feature off the warrom and created its own page with stats for all players on my team.

    8. I have the hitter breakdown that lets us know which team is winning it what catagory.

    9. I also have a positional breakdown page that allows me to see what team is projected to score the best at whcih position. C, 1B….etc.

    like i said you laid the foundation but my league is so competive that I had to come up with a way to get a bigger advantage. Thanks so much for your time on this and if you are interested in viewing the one I created please email me at jerdogg2587@yahoo.com

  220. Jerry says:
    (link)

    I have used my sheet for mixed leagues on websites from ESPN, Fanball, to CBS. I will also be creating a football version and possibly a basketball version.

    Thanks again to Lou Poulas for his innovative creation that allowed me to expand my own process.

  221. Jerry says:
    (link)

    For those of you who have asked I have finished the NL only version. If your interested in it let me know. I am going to be working on the AL only tomorrow in hopes to have it done around midday.

  222. timSTi says:
    (link)

    @Lou: Great spreadsheet. With the mixed league war room, how do I adjust it for only 10 teams when it comes to projected rankings and such? Thanks buddy!

  223. Jerry says:
    (link)

    I have added a Draft – Auction page where you can select a player and team from dropdown lists and then they will be input on the print page so you can print out you entire draft or auction.

  224. Dan says:
    (link)

    Lou –
    Thanks again for doing this – using it for the 2nd straight year! Question, in the AL Only War Room I downloaded everything seems to be working excep the “Pitching Rank” don’t seem to be populating. Anything specific I should do?

    Thanks Again!

  225. Sean says:
    (link)

    Lou,

    Thanks, this will be a huge help at my draft. I’m trying to use the auction draft with the inflation, but can’t add the teams. We have 14. The formula is not the same as it is on the straight draft sheets. I added the teams and also added lines and copied the formulas on the war room pages. What am I doing wrong? The formula I see in validation is $BD$1:$BD$12. I tried changing this to 14 at the end, and it shows two more spots on the dropdown, but doesn’t populate the names.

    Thanks in advance for your help!

  226. Lou Poulas

    Lou says:
    (link)

    @Dan: Hi Dan. How many teams do you have? It only works “out of the box” for a 12 team league, but there is a simple update you can make for it to work with fewer.

    if you have a 10 team league for example, delete the records in the “Pitching Per Player” and “Batting Per Player” sections that correspond to the blank team. In the 10 team example, this would be the last two rows of each section.

    Then your rank will work. Good luck!

  227. Lou Poulas

    Lou says:
    (link)

    @Sean: Hi Sean. Open up column BD on the War Room tab. There will be a formula in rows 1-12. Copy this down to row 14.

    Also make sure that you add spots for the 13th and 14th teams on the user Input tabs.

  228. Sean says:
    (link)

    Thanks, that did it! Also, when we enter a “kept” value, do we also fill in the players salary? It doesn’t seem to work right if I just enter the Kept value, so I wanted to make sure my sheet was working.

  229. Lou Poulas

    Lou says:
    (link)

    @Sean: Yes, enter both. Promise a better design for that partnext year

  230. Hugh says:
    (link)

    OK, I am sure the answer is in here somewhere but I missed it so could you explain this to me like I am a 6 yr old…I tried to use the softwarer and don’t see roster lists for the teams and how do I select a player and put him on a team> Thanks, no pressure my draft is tomorrow!!

  231. Hugh says:
    (link)

    Ok, please ignore my mere existence…got it

  232. Simply Fred

    simply fred says:
    (link)

    Hugh, I am a casual user of the War Room for snake drafts. If you are trying to get the standard War Room to work for your draft tomorrow, I will be happy to help you. However, it is pretty time consuming, and without prior working knowledge, I really think you won’t be happy with trying it for the first time tomorrow.

    If you have a set of players for a standard 5X5 roto (say 13 hitter and 9 pitchers), send me the names, I will load them to a War Room spreadsheet. That will at least give you Grey’s projections. Also, the name you would like for your team.

    fred_barker@comcast.net

  233. Lou Poulas

    Lou says:
    (link)

    @simply fred: Fred and HUgh, the players are already pre-loaded. NOt to speak for Fred, but but I think he means if you don’t like the Chone projections it is time consuming to replace them with another set – Razzball, BP, etc.

    Chone was rated#1 among all the projection systems last year.

    Keep in mind projection systems don’t necessarily do a great job in predicting what the league leading RBI total will be, but they do a superb job in telling you who will lead the league in RBI. They are conservative, but only because they have to be.

    So in short, Chone is stellar for telling you who is going to win your league. A bit less stellar in predicting individual outcomes of the league leading players.

  234. Chris B says:
    (link)

    Great spreadsheet.

    I HOPE you are going to do this again for 2011!!!

    Thank you!!!

Comments are closed.