Wisdom of the Crowds + LastPlayerStanding Auction Values XLS

[thecubsyear]

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.