Excel Question - Fantasy Baseball Cafe 2014 Fantasy Baseball Cafe
100% Deposit Bonus for Cafe Members!

Return to General Talk

Excel Question

Moderator: Baseball Moderators

Postby Amazinz » Thu Apr 12, 2007 7:10 pm

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.
Image
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
Mod in Retirement

User avatar
CafeholicFantasy ExpertCafe WriterCafe RankerMock(ing) DrafterEagle EyeWeb SupporterPick 3 Weekly WinnerSweet 16 SurvivorLucky Ladders Weekly Winner
Posts: 18800
Joined: 16 Mar 2004
Home Cafe: Baseball
Location: in Canada, toughening up figure skaters

Postby BGbootha » Fri Apr 13, 2007 2:06 am

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

User avatar
Cafeholic
Posts: 2825
Joined: 18 Feb 2003
Home Cafe: Football
Location: Grading papers

Postby Amazinz » Fri Apr 13, 2007 10:38 am

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.
Image
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
Mod in Retirement

User avatar
CafeholicFantasy ExpertCafe WriterCafe RankerMock(ing) DrafterEagle EyeWeb SupporterPick 3 Weekly WinnerSweet 16 SurvivorLucky Ladders Weekly Winner
Posts: 18800
Joined: 16 Mar 2004
Home Cafe: Baseball
Location: in Canada, toughening up figure skaters

Postby BGbootha » Fri Apr 13, 2007 3:03 pm

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.


:-? :-? :-? ............ ;-D
BGbootha
General Manager
General Manager

User avatar
Cafeholic
Posts: 2825
Joined: 18 Feb 2003
Home Cafe: Football
Location: Grading papers

Postby BGbootha » Mon Apr 16, 2007 3:56 pm

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

User avatar
Cafeholic
Posts: 2825
Joined: 18 Feb 2003
Home Cafe: Football
Location: Grading papers

Previous

Return to General Talk

Who is online

Users browsing this forum: claudekw11, gretaan2, janineop2, joiingds, matthewnv69, mistyif4 and 6 guests

Forums Articles & Tips Sleepers Rankings Leagues


Today's Games
Tuesday, Jul. 29
(All times are EST, weather icons show forecast for game time)

LA Angels at Baltimore
(7:05 pm)
Seattle at Cleveland
(7:05 pm)
Chi White Sox at Detroit
(7:08 pm)
Milwaukee at Tampa Bay
(7:10 pm)
indoors
Philadelphia at NY Mets
(7:10 pm)
Washington at Miami
(7:10 pm)
indoors
Arizona at Cincinnati
(7:10 pm)
Toronto at Boston
(7:10 pm)
Colorado at Chi Cubs
(8:05 pm)
NY Yankees at Texas
(8:05 pm)
Oakland at Houston
(8:10 pm)
Minnesota at Kansas City
(8:10 pm)
Atlanta at LA Dodgers
(10:10 pm)
St. Louis at San Diego
(10:10 pm)
Pittsburgh at San Francisco
(10:15 pm)

  • Fantasy Baseball
  • Article Submissions
  • Privacy Statement
  • Site Survey 
  • Contact