I'm terrible setting up an excel spreadsheet, but here's what I need.....
We have 14 owners with a $200 budget to draft with.
I am need of one that shows we are drafting 15 players, 16 players, and 17 players - need a sheet for each quantity with 14 tabs at the bottom for each owner.
Basically, what I need the spreadsheet to show is a column for each player drafted, their team, position, and they amount they were won for in our bidding process.
The last column - the one with the amounts, needs to show at the bottom how much of each person's $200 has been spent and also how much each owner can spend on any one player. Each roster spot to be filled is a minimum of $1 so let's say you spent $20 on Andrew Luck, that would leave you with $180 left, and let's say you're drafting 15 spots, at a minimum of $1 per spot, the max you could bid on any single player at that moment is $167. That would leave you exactly $1 for the remaining 13 spots.
But like I said, I need this with rosters at each of 15, 16, and 17 players since we're not entirely sure how many we'll allow for. Probably 16, but it's on our agenda for pre-draft discussion once we all meet live on the 25th.
Anyone have something like this?
Thanks in advance!