I've been running an Appleworks spreadsheet draft tracker for a while, and it runs very much like Excel, but better on my Mac. I just track money, pretty much. Can anyone tell me the formula for computing highest bid? (I have money remaining and money spent, but not highest bid.)
Announcement
Collapse
No announcement yet.
Announcement
Collapse
No announcement yet.
Novice Spreadsheet Question
Collapse
X
-
Originally posted by DJBeasties View PostHighest bid you need count of players remaining. I don't really think I can write it out so that it makes sense but you can email your spreadsheet and I can just do it and send it to you. Once you see it, it makes sense.
Comment
-
Highest Bid = Remaining Budget - ($1 x (All Remaining Roster Spots-1))
Say you have $190 left and 15 spots to fill:
Highest Bid = $190 - ($1 x (15-1)) = $190 - ($1 x 14) = $190 - $14 = $176Some people say winning isn't everything. I say those people never won anything.
Quitters never win, winners never quit, but those who never win AND never quit are idiots.
The last thing I want to do is hurt you...but it's still on the list.
Some people are like Slinkies, they are not really good for anything but they still bring a smile to your face when you push them down a flight of stairs.
"...relentless inevitability of Yankee glory." - The Onion
Comment
-
Originally posted by TopChuckie View PostHighest Bid = Remaining Budget - ($1 x (All Remaining Roster Spots-1))
Say you have $190 left and 15 spots to fill:
Highest Bid = $190 - ($1 x (15-1)) = $190 - ($1 x 14) = $190 - $14 = $176
Comment
-
Originally posted by dslaw View PostIn Excel it is "=260-(25-counta(a3:a27)-1)" where 260 is our total budget, 25 is total roster spots to fill, and a3:a27 is the range to input rosters. Same theory as TC but the formula may help you if you haven't already gotten it.
Comment
Comment