A Great Excel Worksheet to Track Salaries @ Auction (1 Viewer)

[Varmint]

I've been running an auction league format since 2002 and one thing that I have found (as I'm sure most of you have too) is that during a bidding frenzy, KNOWING how much each owner has to bid on the player that you are bidding for, is of utmost importance.

It's important to me as an owner to know what I'm up against while bidding against another owner for a player and it is important to me as the Commissioner to have any illegal bids throw up a red flag as soon as it is shouted out

Making the auction staff IMMEDIATELY aware of any illegal bids will save any confusion during the auction.

It has happened more than once that a player has been awarded to an owner only to have someone bring to everyone's attention that the last bid was an illegal bid.

Its a bummer when this happens and it messes up the flow of the auction.

As an owner, I've found that many times, after the smoke has cleared, I let a player go to someone else who could not have gone a single dollar higher.

Whlle most of the time I can quickly figure ABOUT how much he has but I need an exact amount...not an approximation.

So, only knowing enough about Excel to do the basics I set out to make a couple of worksheets that would give me and the aucttion staff an immediate, EXACT answer to the question "how high can this guy go?".

I got the basic formats down then turned it over to Mike (FBG #972) with instructions on how I wanted it to work.

He did the rest and they couldn't have turned out better!!

Ok, so there are two formats available.

One is set up in a landscape format and it seems that this work better for the auction staff

The other is in a portrait format and would work better for an individual owner.

Its a collaberation between two of your fellow FBG's and it is available to anyone else here who thinks that thay may benefit from it!

Send me an IM with your email address and I'll shoot over both formats with instructions.

This is just a small gesture to repay all of you here for all of your help during the fantasy season!

 

[perry147]

I have been doing this for my leagues for years.

We even put it up on a huge draftboard for everyone to see.

 

[bentley]

I have been doing this for my leagues for years.We even put it up on a huge draftboard for everyone to see.

Ours also keeps track of $$ spent by position for the whole league, has dynamically updated projections for each team based upon the draft dominator, and ranks teams in points per dollar spent.It's set up for the specifics of our league but could be modified if anyone's interested.

 

[perry147]

I have been doing this for my leagues for years.We even put it up on a huge draftboard for everyone to see.

Ours also keeps track of $ spent by position for the whole league, has dynamically updated projections for each team based upon the draft dominator, and ranks teams in points per dollar spent.It's set up for the specifics of our league but could be modified if anyone's interested.

Ours just tracks the money spent and money left per team. This evolved after a very confrontational draft a few years ago when someone thought they had enough money and didn't to get Jerry Rice late (he was playing in OAK).

 

[Varmint]

We've had worksheets like those for years...

The one thing that sets these new sheets apart from the others is that not only does it track money spent and how much is remaining on everyone's salary cap...

...it tells you how much each owner's next maximum bid can be!!

It takes into consideration that, after the current bid, the winning owner must have at least one dollar remaining under his cap for each open slot on his roster.

(assuming that most auction leagues have this rule in place)

Example:

You are in a bidding war with another owner who has six open slots to fill.

IF he wins this bid...he will have 5 slots yet to fill on his roster.

This worksheet subtracts the $5 he must have remaining from his salary cap that will remain after the bidding...

IE...he is $28 under his cap with 6 slots open

The MOST that he can bid on this current players is $23

This worksheet shows both his current cap of $28 AND his max bidding power of $23

THAT's the part that I was having so much trouble producing without having a worksheet full of "eyewash"...a bunch of numbers that mean nothing at the time of the bidding.

Knowing your opponents EXACT bidding power is imperative at the auction.

Knowing his limit gives you the choice of taking the bid right up to $1 BELOW his max and allowing him to take the player while killing his future bids...

..or...you can bid exactly what his limit is KNOWING that he cannot bid another buck. This could save you a few bucks...and a few bucks in an auction can be the clincher!