Well, I'm not sure if any of you who were here then remember but I created a spreadsheet a couple years back that incorporates 2 drafting theories/strategies to create a set of rankings. I have decided to completely update it with current stats and tried to make sure it's all working properly...I'm by no means an "excel expert" so if anyone who looks at it has any suggestions I'd be happy to hear them but I think it's well designed overall and can be helpful to those who want another tool to look at.
The two theories/strategies used to calculate the rankings are Average Value Theory (AVT) and Value Based Drafting (VBD). AVT basically takes how each position has performed over the past few seasons and takes the average of a spot (i.e. RB1, RB2) and projects that as the likely final fantasy points for whoever the RB1 or RB2 will be. It's explained better in the spreadsheet if you're interested. VBD is simply an approach that takes into account the amount of starters and the use of scarcity to determine where certain players should go based on where their value is in comparison to other players in their position.
The spreadsheet is fully customizable including everything from league size, starting requirements, and scoring system. It is capable of projecting every position down to IDPs, Kickers, and Team Defenses.
I thought it would be a good tool for those who want something to look at and see how things can change with different league settings, league size, etc. I'd be very interested in any and all feedback from those who decide to download and take a look and/or use it.
Excel 2007: http://www.mediafire.com/download.php?kmmy0uzz2mm
Older Excel Versions: http://www.mediafire.com/download.php?anjmxzmeklt
Just as a note...there is a macro in the spreadsheet so you may need to enable it depending on how you have your settings in excel set up. It's just a simple one created to sort the rankings once changes are made.