Excel Question - Fantasy Baseball Cafe 2015

## Excel Question

Moderator: Baseball Moderators

BGbootha wrote: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.

Maine has a good swing for a pitcher but on anything that moves, he has no chance. And if it's a fastball, it has to be up in the zone. Basically, the pitcher has to hit his bat. - Mike Pelfrey
Amazinz
Mod in Retirement

Posts: 18800
Joined: 16 Mar 2004
Home Cafe: Baseball
Location: in Canada, toughening up figure skaters

Amazinz wrote:
BGbootha wrote: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???
BGbootha
General Manager

Posts: 2825
Joined: 18 Feb 2003
Home Cafe: Football

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.

Maine has a good swing for a pitcher but on anything that moves, he has no chance. And if it's a fastball, it has to be up in the zone. Basically, the pitcher has to hit his bat. - Mike Pelfrey
Amazinz
Mod in Retirement

Posts: 18800
Joined: 16 Mar 2004
Home Cafe: Baseball
Location: in Canada, toughening up figure skaters

Amazinz wrote: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
General Manager

Posts: 2825
Joined: 18 Feb 2003
Home Cafe: Football

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.
BGbootha
General Manager

Posts: 2825
Joined: 18 Feb 2003
Home Cafe: Football

Previous