Who has time to use a spreadsheet in a 30 second auction draft? Any spreadsheet with enough info to actually help is going to take too long to keep up with no? Just scrolling up and down to the random players nominated (from MJD to Pitt D to Donny Avery, etc) is going to take 10 seconds... is this more just to study prior? That would make sense I guess, but not better than doing mocks.
Just practice, practice, practice - you really won't need one assuming your drafting site has even average features on it (players remaining, dollars available for all members, access to all rosters, etc)
Keep a few notes to remind yourself of mid and late round values you are targetting....
In an auction, only the last bid matters, so taking time to track players and your perceived value vs. what is left makes a lot of sense to me. Why do all that memorization when you can quickly search and find the data you need?Even if there is a 30 second clock, it typically resets to at least 10 seconds with each additional bid. Read the other auction strategy threads, they describe why you might want to have more info
I've done auctions for awhile now, and I can't say I have ever seen a spreadsheet that would tell me something I can't figure out on my own in real time. Of course this assumes I get in the dozens of mocks I normally do from varying sites.I don't think of it as memorizing.. I think of it as being prepared to recognize the tendencies of your opponents and manipulate from there. I don't go in saying I will spend "$X" on a player, because it doesn't take much to completely alter the relative values of a position. If your league is in general over-paying for elite players, you better over-pay for an elite player.. or convince yourself that you will compete with a roster full of mediocre "steals" you got by holding your money.
Of course I study average values and projections, but
every auction draft is going to have different market values for positions and individual players... there is a large component of "feel" IMHO. I'm not discrediting the science behind it, and if someone needs a spreadsheet to remind them of the important stuff.. more power to 'em. But if you have your nose in a spreadsheet the whole time I will gaurantee you are missing a lot of the fun.
Talking crap, baiting, bluffing - all things I would say are at least as useful as a spreadsheet assuming you have a clue.
Gotta say, I , strongly agree. As commish that runs the auction, fills in the auction board. Tried to use the DD to run ours, after 2 players turned the laptop off,takes too long. I am always prepared, do at least 30 mock auctions, with different caps, just to get a feel for what kinds of teams you get with different kinds of strategy. To get a feel for what % of cap players are going for, and what the hot guys are going for. If you have already made decisions on different players and strategy, countless times, then nothing should phase you or slow you down. I have a budget, but that is also in my head, adjust on the fly.
We use an auction draft board, that is color coded for each position, with each sticker having the cost of that player and money left for that team, since we use a $0 nomination, the money left is a teams max bid, makes the math easy. They don't need a spread sheet it's all right in front of them .
I also give my guys all a folder with rules, roster sheets, blank paper, put out a 20 set of highlighters and pens, each folder also has a cheat sheet from a free site, and if possible tweaked for our scoring system, makes it quick for guys to mark off players, if they can't find a guy quickly, another owner will yell out he's wr 33 on the sheet.
Then it all comes down to who's prepared and who isn't.
I can't tell you how much easier it, is if you have put in the work to do the mocks and prepare a few budgets, the auction slows down a hundred fold. Makes it so much more enjoyable, as it a lot less thinking and it's more instinctive.
Just my 2 cents.