DaveClay12 wrote:I'm trying to put together a draft sheet that ranks available players, taking into account all the statistical categories my league has in approximately equal proportion. I'd like to come up with a "final number" in order to rank the players' value in my league after taking into account all the statistical categories. Has anyone tried this before?
This is what I do, almost every single year for both basketball (I use per-game averages) and baseball (raw totals from last year).
What I do is this... and if you can't follow along you can PM me. I copy all the stats onto an EXCEL sheet. Then, I sort each stat column involved (5x5, sort those stats) and find out what the lead was for that stat, in my data sample...
Lets take the hitting categories... your leaders were 133 R, 48 HR, 150 RBI, 70 SB, and a .372 AVG. I take a number that is higher than any of those numbers, say, 200 in this case. Then, I take each lead number and divide it into the 200... so for R you would get 200/133=1.5037 and for HR you would get 200/48=4.1666... Now, use the Excel formulas to multiply each respective player's stat by their magic number... so, for instance, the Sean Casey line would be 101*1.5037xxx in the first cell and 24*4.1666xxx... in the second cell. You can easily copy these formulas down for all players. Finally, I add those five new numbers up, and come up with a total. If you rank this total from top to bottom, you have a good list of how the stats contributed to ROTO success. What kind of order do I get doing this?: Pujols, Beltran, Vlad, Bonds, Abreu, Beltre, ARod, Manny, Tejada, and Edmonds in my top 10 using last years raw totals. To use it as a predition tool, you have to do the mind work. There are a million ways you can look at stats and analyze, this is but one, simple way that I use.
With pitching, it is a bit tougher, but I guess it could be done. But I seperate my pitchers into three lists: 1. Established closers, ranked by saves last year 2. Lower end closers and top setup guys, ranked by Saves if they should close, and then strikeouts if they won't and will only be "top middle men" and finally 3. Strikeouts for starting pitchers. Usually I filter out all the pitchers with an ERA of over 5. But, its up to how I feel. To me, it is much easier to analyze hitting stats than pitching, and pitchers tend to hold many more questions. Finally, their IP really determines the effect that their ratios have and you can quantify all you want, but it is darn tough to predict that Peavy will drop almost 2 ERA points, Ollie will increase his k's by 100 and halve his ERA, and that Prior will only win 6 games. I guess that is the main reason why pitchers don't get drafted as quickly as hitters do, but there are 2 million reasons why that is true I guess...
I hope this helps Dave and anyone else.