For those of you familiar with online auction draft rooms, you know the constant refrain to which the article title refers. Waiting for that final, SOLD, to make sure you can mark the player off your list. Well, I was invited to join the CBS NL auction league hosted by Scott White with many names that you’re likely more familiar with than mine.
Spreadsheets on Spreadsheets
Let me start by plugging Rudy’s tools as part of the Razzball subscription. The War Room alone is worth the price of the subscription and is something I take into every roto or categories draft. Grey can give you the hard sell over in his write up though.
I combine Rudy’s War Room with my auction values. I think of auction values in tiers of players with a range of dollar amounts for that tier. If you have a dollar values assigned to tiers rather than specific player values, you can wait for the value or anticipate the cliff coming in that tier rather than being strict on a specific number. There is, of course, that delicate balancing act between not overspending early when everyone is flush with money and waiting too long while missing out on all of the top options.
Before entering the auction, I lay out the positions on a spreadsheet and input various dollar amounts for different spending in the auction. It helps me to see what rosters may look like if I take a $45 Christian Yelich vs a $30 Pete Alonso. How spending various amounts at hitting vs pitching can adjust a team’s construction.
It’s nothing fancy, just an Excel spreadsheet using the sum function at the end of each column.
Please, blog, may I have some more?