Not so crazy jdnoon, since Nelson Cruz is in the American League!
nobody in the draft took nelson cruz. thats crazy!
Thanks, a version of that works. I already had a field for # of player needed, therefore: 260 – # of players needed – $ spent + 1 does the trick. THANKS!
The formula for Max Bid goes something like this:
$260 – (23-# of players taken)- ($ spent) + 1
Thanks for posting the results. It looks like you used an Excel spreadsheet during the draft to keep track of everyone’s roster (I was one of the anonymous lurkers in the back of the room-thanks for opening it to the public). Can you tell me the formula you used for the MAX BID field? I have already figured out how to do # of players needed and $ remaining. It’s probably very simple, but I think I’ve got a brain fart going on here. Thanks for any help.
Not so crazy jdnoon, since Nelson Cruz is in the American League!
nobody in the draft took nelson cruz. thats crazy!
Thanks, a version of that works. I already had a field for # of player needed, therefore: 260 – # of players needed – $ spent + 1 does the trick. THANKS!
The formula for Max Bid goes something like this:
$260 – (23-# of players taken)- ($ spent) + 1
Thanks for posting the results. It looks like you used an Excel spreadsheet during the draft to keep track of everyone’s roster (I was one of the anonymous lurkers in the back of the room-thanks for opening it to the public). Can you tell me the formula you used for the MAX BID field? I have already figured out how to do # of players needed and $ remaining. It’s probably very simple, but I think I’ve got a brain fart going on here. Thanks for any help.