2012 Spreadsheet to calculate Value and Inflation - Fantasy Baseball Cafe 2014 Fantasy Baseball Cafe
100% Deposit Bonus for Cafe Members!

Return to Baseball Leftovers

2012 Spreadsheet to calculate Value and Inflation

Moderator: Baseball Moderators

2012 Spreadsheet to calculate Value and Inflation

Postby MadBall » Wed Mar 07, 2012 11:45 pm

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!
MadBall
T-Ball Trainer


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

Re: 2012 Spreadsheet to calculate Value and Inflation

Postby Broncmet724 » Thu Mar 08, 2012 3:16 pm

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

User avatar

Posts: 1754
Joined: 8 Apr 2003
Home Cafe: Baseball
Location: On the outside looking in

Re: 2012 Spreadsheet to calculate Value and Inflation

Postby MadBall » Thu Mar 08, 2012 3:42 pm

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


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

Re: 2012 Spreadsheet to calculate Value and Inflation

Postby rjforlife » Thu Mar 08, 2012 4:49 pm

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
Hall of Fame Hero

User avatar
CafeholicResponse TeamCafe WriterCafe RankerMock(ing) Drafter
Posts: 7507
(Past Year: 765)
Joined: 25 Jan 2003
Home Cafe: Baseball
Location: Vegas Baby

Re: 2012 Spreadsheet to calculate Value and Inflation

Postby MadBall » Thu Mar 08, 2012 5:01 pm

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


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

Re: 2012 Spreadsheet to calculate Value and Inflation

Postby Syfo-Dyas » Thu Mar 08, 2012 5:23 pm

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.
Image
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
Major League Manager


Posts: 1849
Joined: 23 Jul 2007
Home Cafe: Baseball

Re: 2012 Spreadsheet to calculate Value and Inflation

Postby MadBall » Thu Mar 08, 2012 5:30 pm

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.


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


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


Return to Baseball Leftovers

Who is online

Users browsing this forum: Majestic-12 [Bot], unioreimi and 9 guests

Forums Articles & Tips Sleepers Rankings Leagues


Today's Games
Monday, Jul. 28
(All times are EST, weather icons show forecast for game time)

San Diego at Atlanta
(12:10 pm)
Milwaukee at Tampa Bay
(7:10 pm)
indoors
Philadelphia at NY Mets
(7:10 pm)
Washington at Miami
(7:10 pm)
indoors
Arizona at Cincinnati
(7:10 pm)
Toronto at Boston
(7:10 pm)
Colorado at Chi Cubs
(8:05 pm)
NY Yankees at Texas
(8:05 pm)
Oakland at Houston
(8:10 pm)
Pittsburgh at San Francisco
(10:15 pm)

  • Fantasy Baseball
  • Article Submissions
  • Privacy Statement
  • Site Survey 
  • Contact