Wisdom of the Crowds + LastPlayerStanding Auction Values XLS - Fantasy Baseball Cafe 2015 Fantasy Baseball Cafe
100% Deposit Bonus for Cafe Members!

Return to Draft, Trade, Keeper and Waivers Questions

Wisdom of the Crowds + LastPlayerStanding Auction Values XLS

Moderator: Baseball Moderators

Wisdom of the Crowds + LastPlayerStanding Auction Values XLS

Postby thecubsyear » Sat Mar 10, 2012 3:28 am

It's standardized testing week for my 8th grade students, so I worked on my strategy for my upcoming auction. I took the projections from the Wisdom of the Crowds (10 sets of projections like ZIPS, Yahoo, ESPN, CBS, etc.) and combined it with the lastplayerleft.com spreadsheet algorithm.

(WOC found on this excellent thread: http://www.fantasybaseballcafe.com/forums/viewtopic.php?t=438317&hilit=wisdom+crowds)

My league is a 6x6 which includes OPS and K/BB. It also has a $300 auction budget for 13 starting hitters and 8 pitchers (5 SP, 3 RP) with a bench of 6.

I found that WOC gave me good projections, and lastplayerleft gave decent customized auction values, so I'm happy that after a little tweaking, I was able to combine them. Check this link below for my results: (note: remember it's a $300 budget 6x6. I also did some minor tweaking (added $4 to each OF and 3B)

https://docs.google.com/spreadsheet/ccc?key=0AuYLakcRB93JdDZOSEJwVVpQd1pUUVVNSG1IMjJ6cXc

I color coded tiers as well as overpriced/underpriced vs. Yahoo average $ spent.

Looking for feedback, and feel free to download and use/tweak.
thecubsyear
Softball Supervisor
Softball Supervisor

User avatar

Posts: 31
Joined: 13 Oct 2006
Home Cafe: Football

Return to Draft, Trade, Keeper and Waivers Questions

Who is online

Users browsing this forum: No registered users and 7 guests

Forums Articles & Tips Sleepers Rankings Leagues


Get Ready...
The 2015 MLB season starts in 17:54 hours
(and 91 days)

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