2012 Spreadsheet to calculate Value and Inflation

[MadBall]

I am in a few leagues all with different setups so I created a spreadsheet that can accommodate all of them and figured others could find it useful as well. Just follow the instructions on the "League Setup" tab and you should be good to go. I have put up two versions to be downloaded:

If your league is with CBS:
https://docs.google.com/open?id=0B4X028QIULchd0tGWkhCQlJTVEdxSWlUM0ZDYWtKQQ
If your league is NOT with CBS:
https://docs.google.com/open?id=0B4X028QIULchdjM5c0VJbVpRaUdOYTVET2MxTVlZdw
-this version has the players already entered in, however you will need to enter in teams and salaries manually.
-Due to the players already being entered there will be player values already populated, ignore them until you have completed the setup
-Position eligibility for hitters is 20 games, starters 5 starts, relievers 10 appearances.


Notes:
-Toggle stats, INN, W, S, K, ERA, WHIP, RBI, R, HR, SB, RP, BA, OBP, SLG, OPS
-If you enter salaries as players are drafted inflation will adjust
-Buttons to sort stats, value, and filter by position
-Projections based on averages from CBS, ESPN, ZiPS, and RotoChamps


If you find this useful Paypal donations are greatly appreciated, wsickles31@yahoo.com, Thanks!

[Broncmet724]

Interesting, will it affect it entering my own projections?

[MadBall]

Interesting, will it affect it entering my own projections?

You could, currently all the stat cells have formula's to lookup and averages from CBS, ESPN, ZiPS, and RotoChamps but if you could find a way to paste your projections into those cells it will overwrite them and use only your projections. If you do so, the name format will not matter, but you will need player eligibility to have all the players eligible positions separated with a comma, or else position scarcity will not work.

Let me know if you have any more questions.

[rjforlife]

In step 7 when it says, change the rank to one for all top players, do you then keep ranking the players down 1,2,3,4,5,6.....until you have ranked at least the minimum needed to fill the league rosters?

[MadBall]

In step 7 when it says, change the rank to one for all top players, do you then keep ranking the players down 1,2,3,4,5,6.....until you have ranked at least the minimum needed to fill the league rosters?

I should probably re-write that to be more descriptive. you want all players at each position that MUST be started to have a 1 as their rank. For example, if there are 12 teams and you must start 2 catchers, you MUST have 24 catchers with a 1 for rank. Another thing I forgot to mention is that the number in Cell U1 needs to equal the number of hitters that will be auctioned off. So if you have 12 teams, starting 14 players per team, it should be 168. If its over, you need to change a players rank to be outside 168. Doesn't matter what it is, could be 169 or 10000. Just make sure the player you take out doesn't leave you short at a position (like making only 23 catchers ranked). Kinda confusing, but in short the rank is used to calculate the value. All players with a rank less than Cell U1 will have there stats used when calculating value. All players with a 1 for their rank will have there stats used when calculating position scarcity.

[Syfo-Dyas]

This is the Tavish sheet with a facelift.
And it has problems.

Inflation doesn't working properly.
Albert Pujols
price $57
inflation price $2439
I fail to see who would spend that much on a player if he has only $300 budget.

I only draft 264 players, yet 384 costs at least $1.
Therefore all prices are flawed.
If all prices are flawed than rankings might be flawed too.
This is the same problem as lastplayer has.


I dowloaded this:
http://www.ultimatefantasydrafthelper.com/
It works fine and fast, and has more features.
now I see it's only $7.95, and I downloaded for $12.95

The only reason to choose this over that, that this is free, if you don't want donation.
Otherwise the other is lot better, and costs only a little more than a donation.
I would recommend that over this.

my 2 cents.
Sorry if I was too negative.

[MadBall]

This is the Tavish sheet with a facelift.
And it has problems.

Inflation doesn't working properly.
Albert Pujols
price $57
inflation price $2439
I fail to see who would spend that much on a player if he has only $300 budget.

I only draft 264 players, yet 384 costs at least $1.
Therefore all prices are flawed.
If all prices are flawed than rankings might be flawed too.
This is the same problem as lastplayer has.


I dowloaded this:
http://www.ultimatefantasydrafthelper.com/
It works fine and fast, and has more features.
now I see it's only $7.95, and I downloaded for $12.95

The only reason to choose this over that, that this is free, if you don't want donation.
Otherwise the other is lot better, and costs only a little more than a donation.
I would recommend that over this.

my 2 cents.
Sorry if I was too negative.

If that is the inflation rate then something has been entered wrong so the flaw was by you, or my instructions not being detailed enough. This is also a work in progress, so i expect some flaws, but my sheet has inflation working just fine.