## 2012 Spreadsheet to calculate Value and Inflation

Moderator: Baseball Moderators

### 2012 Spreadsheet to calculate Value and Inflation

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:
If your league is NOT with CBS:
-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!
T-Ball Trainer

Posts: 4
Joined: 6 Mar 2012
Home Cafe: Baseball

### Re: 2012 Spreadsheet to calculate Value and Inflation

Interesting, will it affect it entering my own projections?
 Broncmet724
Major League Manager

Posts: 1734
(Past Year: -20)
Joined: 8 Apr 2003
Home Cafe: Baseball
Location: On the outside looking in

### Re: 2012 Spreadsheet to calculate Value and Inflation

Broncmet724 wrote: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.
T-Ball Trainer

Posts: 4
Joined: 6 Mar 2012
Home Cafe: Baseball

### Re: 2012 Spreadsheet to calculate Value and Inflation

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?
Goldy is King.
rjforlife
Hall of Fame Hero

Posts: 7493
(Past Year: 247)
Joined: 25 Jan 2003
Home Cafe: Baseball
Location: Vegas Baby

### Re: 2012 Spreadsheet to calculate Value and Inflation

rjforlife wrote: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.
T-Ball Trainer

Posts: 4
Joined: 6 Mar 2012
Home Cafe: Baseball

### Re: 2012 Spreadsheet to calculate Value and Inflation

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.

http://www.ultimatefantasydrafthelper.com/
It works fine and fast, and has more features.

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.
the awesome sig by soty

"You should be mindful of the future, but not at the expense of the
moment." - Qui-Gon Jinn (keeper league expert?)
Syfo-Dyas
Major League Manager

Posts: 1843
(Past Year: -6)
Joined: 23 Jul 2007
Home Cafe: Baseball

### Re: 2012 Spreadsheet to calculate Value and Inflation

Syfo-Dyas wrote: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.

http://www.ultimatefantasydrafthelper.com/
It works fine and fast, and has more features.

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.
T-Ball Trainer

Posts: 4
Joined: 6 Mar 2012
Home Cafe: Baseball

### Who is online

Users browsing this forum: No registered users and 13 guests