Baseball Toaster The Juice Blog
Help
Societal Critic at Large: Scott Long
Frozen Toast
Search
Google Search
Web
Toaster
The Juice
Archives

2009
02  01 

2008
12  11  10  09  08  07 
06  05  04  03  02  01 

2007
12  11  10  09  08  07 
06  05  04  03  02  01 

2006
12  11  10  09  08  07 
06  05  04  03  02  01 

2005
12  11  10  09  08  07 
06  05  04  03  02  01 

2004
12  11  10  09  08  07 
06  05  04  03  02  01 

2003
12  11  10  09 
E-mail

scott@scottlongonline.com

Personally On the Juice
Scott Takes On Society
Comedy 101
Kick Out the Jams (Music Pieces)
Even Baseball Stories Here
Link to Scott's NSFW Sports Site
Fun With Excel
2004-03-30 01:54
by Will Carroll

I've been playing around with a couple things while I'm teaching myself Excel. I think this entry will be something like the Letterman segment "Is This Anything?" If you haven't seen it, you're missing some fun stuff. It's not "Will It Float?" but it does also have the Grinder Girl.

As I'm sure you've all read Doug Pappas' amazing work on Marginal Wins per Dollar Spent, I've wondered how to break it down to a player level. This is still an expirement, but the economists and that statheads can really dig into this one and tell me where I'm wrong and (hopefully) where I'm onto something.

So, here's the chart, courtesy of labelmate Jon Weisman:

NAMESALARYVORPVORP(t)M$/VORP(Sal)VORP(Sal)DIFF
ALOU9.136.51.29%0.741.35-7.78
BAKO0.870.40.08%0.700.08-0.79
BARRETT1.557.31.45%5.841.52-0.03
BELTRAN0.301.40.28%#DIV/0!0.29-0.01
BOROWSKI2.1515.12.99%8.163.140.99
CEDENO0.3000.00%#DIV/0!0.00-0.30
CLEMENT6.0027.65.47%4.845.74-0.26
CRUZ0.3011.62.30%#DIV/0!2.412.11
DEMPSTER0.3000.00%#DIV/0!0.00-0.30
DUBOIS0.309.91.96%#DIV/0!2.061.76
FARNSWORTH1.4016.23.21%14.733.371.97
FRESE0.3000.00%#DIV/0!0.00-0.30
GONZALEZ5.00132.58%2.772.70-2.30
GOODWIN0.65-1.4-0.28%-4.00-0.29-0.94
GRUDZIELANEK1.3812.22.42%11.302.541.16
GUTHRIE0.00%0.000.000.00
GUZMAN0.305.11.01%#DIV/0!1.060.76
HARRIS0.3000.00%#DIV/0!0.00-0.30
HAWKINS3.67152.97%4.453.12-0.55
HOLLANDSWORTH1.009.31.84%13.291.930.93
JACKSON0.306.51.29%#DIV/0!1.351.05
KARROS0.00%0.000.000.00
KELTON0.309.51.88%#DIV/0!1.971.67
LEE7.5040.88.09%5.678.480.98
LEICESTER0.300.30.06%#DIV/0!0.06-0.24
MACIAS0.75-4.5-0.89%-10.00-0.94-1.69
MADDUX7.5033.86.70%4.697.02-0.48
MARTINEZ0.9061.19%10.001.250.35
MERCKER1.209.31.84%10.331.930.73
MILLER0.8000.00%0.000.00-0.80
MITRE0.306.11.21%#DIV/0!1.270.97
PATTERSON0.5013.92.76%69.502.892.39
PINTO0.3000.00%#DIV/0!0.00-0.30
PRIOR2.6057.611.42%25.0411.979.37
RAMIREZ3.1735.26.98%12.267.324.15
REMLINGER3.5511.82.34%3.632.45-1.10
SANCHEZ0.3000.00%#DIV/0!0.00-0.30
SMYTH0.300.50.10%#DIV/0!0.10-0.20
SOSA18.0038.17.55%2.157.92-10.08
VASQUEZ0.3000.00%#DIV/0!0.00-0.30
WALKER1.7518.43.65%12.693.822.07
WELLEMEYER0.30-0.9-0.18%#DIV/0!-0.19-0.49
WOOD10.8346.39.18%4.409.62-1.21
ZAMBRANO0.3526.65.27%532.005.535.18
benefits7.550
TOTAL104.85504.5100.00%#DIV/0!104.850.00

SALARY (data from Dugout Dollars)
VORP (projected VORP at PECOTA midpoint)
VORP(t): Percent of team's total VORP player is expected to contribute
M$/VORP: Cost of each point of VORP above minimum salary
(Sal)VORP: Dollars "earned" by distributing available team salary according to percentage of VORP contributed
(Sal)DIFF: Premium or discount between actual salary and 'earned' salary

I've used the Cubs for mere familiarity and of course, when in doubt, use the Cubs. As I've said, I'm not sure that this "analysis" means much of anything, but I do think there's some interesting things to be learned here. First, there may be a top level where no matter the VORP, there's simply no way to "earn" a salary. It looks to be somewhere south of $10m, but I haven't done the math. There's also some interesting stuff at the bottom and I think playing with the low end of the spectrum might also bring some knowledge up. I think we might find that a replacement level player might not even be worth the minimum salary.

Also, there's lots of factors that we can't add in here. Some players put butts in seats, as Pete calls it, and others have something of a sentimental value. I'd also be curious to see how the Y3-6 players look as this gets broken out to more teams ... or, if it gets broken out to more teams. The biggest problem is the DIV/0 issue, one I'm not sure at all how to deal with.

So, there's my first math wizardry. Don't expect much from someone who's only in his second year at the baseball version of Hogwarts, but hold me to a high standard as well.

Comment status: comments have been closed. Baseball Toaster is now out of business.