Excel Question

[Amazinz]

Also, does anyone have any ideas for figuring out possible auction value...for instance given

fantasy points total, # of roster spots, # of teams, # of starter at each position, budget

what would be a good formula for calculating a rough idea of a auction value.

thanks.

The simple version: Determine the sum "draftable" fantasy points. Divide the total dollars by that sum. Now you have dollar per unit and can reapply it to each individual player to determine value.

[BGbootha]

Also, does anyone have any ideas for figuring out possible auction value...for instance given

fantasy points total, # of roster spots, # of teams, # of starter at each position, budget

what would be a good formula for calculating a rough idea of a auction value.

thanks.

The simple version: Determine the sum "draftable" fantasy points. Divide the total dollars by that sum. Now you have dollar per unit and can reapply it to each individual player to determine value.

how do you determine the sum of draftable fantasy points. 16 teams x best 16 starters at each position???

[Amazinz]

Yep that's it. If you've already determined the fantasy points you've done the hard part. Fill up the entire league's roster starting with the highest point player. Now you have your production pool. And if you want to take into account positional scarcity just use the last player at each position drafted as the baseline. Minus that total from the fantasy point total of each player in that position. Now sum you fantasy points and divide by total dollars.

[BGbootha]

Yep that's it. If you've already determined the fantasy points you've done the hard part. Fill up the entire league's roster starting with the highest point player. Now you have your production pool. And if you want to take into account positional scarcity just use the last player at each position drafted as the baseline. Minus that total from the fantasy point total of each player in that position. Now sum you fantasy points and divide by total dollars.

............

[BGbootha]

Wow, I think I actually got it!!!!

Now all I have to do is go back through and adjust some of the numbers and project rookie totals.