Saturday, May 18, 2013
At Home Plate
Trade Value Calculator Spreadsheet
Written by Bjoern Hartig (Contact & Archive) on July 17, 2009
  

Sky Kalkman of Beyond the Boxscore has a little gem for the sabermetrics among our readers:

In case you're not following along, Dave Cameron has a stellar series going on over at Fangraphs.  He's running through the most valuable contracts in MLB, which you could also view as a raning of trade value, assuming all teams currently had the same financial and competitive situations. ...

If we had enough data, a project like this could be automated.  We'd need complete contract information and multi-year WAR projections just to start.  Unfortunately, I don't have any of that lying around (if you do, let me know.)  But it's still worth crunching the numbers player by player, especially if you disagree with any of Dave's rankings.  It's really not that helpful to get into a war of opinions, and bringing some data to the shouting match is a great strategy.

In that vein, I've put together a little spreadsheet you can download to help estimate a player's excess value to his team, based on expected future production and salary.  Pick a player, plug in the data, and post the results.  Disagree with someone's assessment?  Simply change the numbers and spit out your own analysis.  The download link and tutorial after the jump.

Now that should be fun. Next time I hear a trade proposal that sounds stupid to me, I'll run it by the spreadsheet.



Add this page to your favorite Social Bookmarking websites
Reddit! Del.icio.us! Mixx! Free and Open Source Software News Google! Live! Facebook! StumbleUpon! TwitThis Joomla Free PHP
 

At Home Plate Podcast

To listen to or download the latest At Home Plate Podcast, please click here.
To subscribe, click the icon below
Podcast Feed

Donations

If you like At Home Plate, you could show your appreciation by donating a small amount to our team. Thank you very much!

Amount: