shortsavage wrote:I've been working on an excel sheet that calculates the average numbers of a major league starter each season (.267, 14HRs, 8 sb, 66 RBIs, and 62 runs for 2005 so far with every type of hitter except outfielders). Once I came up with this figure, I set up a function that looks at how far each player deviates from that average. Then, I calibrated points to be given for slightly below average numbers to well above average numbers, ultimately to be turned into dollar values that I will use to rank players at every position and establish a top 100 overall.

.

.

.

Like I said above, I'm interested in figuring out how my approach compares to other fantasy baseball players in terms of the amount of thought that goes into it and its complexity.

If you are doing it in excel it is a good start. I was going to explain to you that after you get your "calibrated points" you will have to do another pass or two to calculate dollar values correctly. I wanted you to get your "calibrated points" first because that is the easy part.

What I mean by another pass is that the AVERAGE you have is the AVERAGE for the entire population and not the AVERAGE for the population that will be drafted. And, in the population that will be drafted, you have to account for position. To be correct, you can't figure out the draftable population AVERAGE correctly if you are not including all the Catchers that should be drafted. Like I said, complex.

Once you get this, you can move to Dollar Values. That is why in my very first post, I said...But ranking players CORRECTLY is very complicated. If you are looking for your own method, a good place to start would be the 2005 Regular Season statistics. Rank using your method and see if it compares with what other sites/sources say.