Maximum bid excel formula - anyone use one?

[[echo] 82]

10 team league, 15 players per team, $100 cap.

 

So if i have 6 roster spots to fill, and $8 remaining my MAX BID would be $3.. how can i program this into excel?

 

current total $ - (empty roster spots - 1) = max bid ammount

 

??

 

:shrug:

 

thanks

[e]

 

[tubby_mcgee 701]

Yes. That is correct.

[TBayXXXVII 2,615]

25 minutes ago, tubby_mcgee said:

Yes. That is correct.

It would actually depend on what his real objective was.  If all he wanted was that final answer, then yes, that formula would do it... and he wouldn't need Excel for that, just common sense.  But if he wanted to track it live he would need to make sure that any values that arise are added to the total money spent.

[Frozenbeernuts 2,292]

My mind is a little burned from today, but you need to figure out the formula of dollars left minus roster spots to to fill plus one. That's the way i believe I did it. 

8 dollars minus 6 spots = 2 + 1 extra dollar to account for the spot you will take up for the max bid

[Brutal Brutus 182]

Its Saturday so my brain is in idle mode, but I think something like this.

Dollars in A1

Roster spots in B1

C1 =(A1-B1) +1

Your scenario would be 

$8 left

6 spots open

Formula would spit out $3

To begin the draft it would be

100

15

Formula should spit out 86.