Ottoneu Auction Calculator

Today I present to you the Holy Grail of Ottoneu Tools… Okay, well not really, but in all seriousness, this took a ton of work. So before I dig into the details, thanks to anyone who has already reviewed, questioned or commented on my work. The feedback is incredibly helpful.

Let us begin…

This is a custom dollar value calculator for Ottoneu FGPts leagues. What do I mean by “custom?” By custom, I mean that anything I thought to include as an input is able to be changed. Now you can see dollar values that directly reflect your opinions. Some examples of custom inputs: Replacement Level, PA and IP thresholds, # of prospects in a league, individual player’s projections… The list goes on. So, where do you start?

The Assumptions Tab: This is where the majority of inputs exists. Ignore “Methodology” for now (will come into play in future versions). And start with “Importing Rosters?” Selecting “Yes” will cause your league’s salaries and players to be removed from the total money, roster spots and Points Above Replacement (PAR) available in the league. To import rosters, use the Export.csv function on your team’s homepage and paste your players and salaries (as values) into the “Rosters” tab – cell A2 for names, cell B2 for salaries. Once rosters are included, You can still toggle between “Yes” and “No”, in the event that you want to see $ values ignoring players who are currently kept. (I do this constantly). As you will see in grayed out cells, toggling between “Yes” and “No” will automatically update the calculation.

Not only that, but you can also select assumptions for your own leagues regarding the number of prospects (and cost of said prospects) that will impact the values as well. This cost is in excess of the $1 mandatory cost that each roster spot requires. Ex: $2 cost for prospects is really $2 + $1. Please note that prospect inputs should be changed as league rosters are imported.

Next, you can change the PA and IP threshold for replacement level production. (Assumptions B29 and B33). These cells set the threshold for which all players receive replacement level production. What does this mean? Every player that is projected to received less playing time than the selected PA/IP threshold (currently 625/185 respectively) will receive replacement level production for the difference in plate appearances or innings pitched. Ex: 325PAs would give you 325PAs of a players own projection, in addition to 300PAs of replacement level production. (I probably would not tinker with this too much until I had set all my other assumptions).

As many of you know, I have been doing my own replacement level work this offseason. All of my benchmarks are included in the workbook. In an effort to keep everything custom, you can select your own replacement level that will update the dollar values (no reason to use my values if you disagree with me, PICK YOUR OWN!) You have two options, use the PPG methodology, or the Xth player ranked methodology. By PPG, all replacement levels will be calculated off of the designated PPG that you choose at each position. By Xth player ranked, the baseline for production is the Xth highest P/PA at a position (given all players projecting for 250PAs). So for example, the 17th C would be the 17th highest P/PA of all C projected for 250 or more PAs in 2015.

Now here’s where the fun comes in. Once you have updated your assumptions, go to the Batters and Pitchers tab. You will see the resulting $ values of your assumptions… Now go change your assumptions. Snap! The dollar values have updated. Now, remember, these values are calculated off of Steamer projections. “But wait!” you say, “I don’t agree with Steamer’s playing time projections.” That’s okay, because you can update the “Adj. PA” or “Adj. IP” column to be whatever you choose and the dollar values will update automatically. This is incredibly helpful for running scenarios. For example, what is Tulo worth if he gets 250PAs? 400? 600? (Look and find out). Also, you can change the position a player is getting replacement level for (if steamer did not include a position, 1B has been given as a default). So, what if Mike Trout was a SS (A man can dream…) what would the resulting cost difference be? What if Josh Harrison picked up SS? You get the point.

Also, I have only imported Steamer for now. Future iterations will let you pick between other projections, but in the interest of customization, all projections can be edited. If you think Robinson Cano will hit 22 HR instead of 18HR, change it. The values will update.

Last but not least, if you have selected “Yes” for “Importing Rosters?” all players currently owned will be excluded from the dollar values. (They will receive a $0 value and will no longer be marked as “Available” on the Batters and Pitchers tabs.) This is where the auction calculator part comes in… As you draft, simply type in the player’s salary in the “Drafted?” column and as a result, the dollar values will update. The player will be removed from the pool and his roster spot, salary and PAR will be excluded from calculations. No longer do you have to worry about inflation as a fudge factor, you can get specific inflation to your league depending on who has been kept/cut. A warning: Some teams/leagues keep overpriced players (causing inflation in keeper decisions). Is Miggy worth keeping at $70, probably not, but you might rather pay $70 and guarantee you own him than risk you rival snatches him away. Due to situations like this, it is very possible that a league can achieve negative inflation, or no inflation. This may cause you to disagree with a value placed on one of few remaining “Studs.” However, if 1 or 2 studs do appear under-priced, and consequently go for $10-$15 higher than their theoretical value, remember that there will be a lot of bargains available later. Consequently leaving underpriced talent. Ex: Hamels calculated at $24 (post roster import) and goes for $32. This increase in value is offset by the fact that steamer sees Cliff Lee, John Lackey, Gio Gonzalez, Yusmeiro Petit and Tim Lincecum as $10-$17 dollar assets. Does an $8 increase in Hamels price offset the fact that 3-4 of these guys may go for $10 less than their projected price? Something to consider.

That’s about it! I tried to make everything as custom as possible so that you can have dollar values that reflect your opinions as an owner. I’m happy to answer any questions or comments. I’m sure updates will be made and future iterations will be released. For now, this is a starting point. Enjoy!

The file should now be compatible with earlier versions of Excel.

Ottoneu Custom Auction Calculator (updated for 2016 Steamer!)

Tagged , , ,

9 thoughts on “Ottoneu Auction Calculator

  1. Dan says:

    Would love to give this a try. Were can I download it ?

  2. The link at the bottom of the post should download the file.

  3. Dan says:

    I clicked it before and it just redirected to the same page. But, tried again just now and its working! Thanks 🙂

  4. Dan says:

    This is a great tool and is exactly what I’m looking for !
    Congrats on the release.

    Now, I have a somewhat special case that I would like to try to use this for. I understand that this is not exactly the intended use of your Calculator, but your help would be very much appreciated.

    Instead of getting the dollar amounts of each player from their respective 2015 projections, I just want to see what each player’s dollar amount was for the previous season. For example, how much was each player worth, according to their 2014 stats (Not projections) . Would this involve simply overwriting the Batter and Pitcher sheets with their actual stats? If so, I am stuck at obtaining the positions for each player. Are there any other fields that I would need to pay special attention too?

    Thanks again !!

    • Just overwrite the projected stats with the actual 2014 stats. Each player his 2014 eligibility included I believe, but replacement level is one position… If a player was eligible at 2 positions, his worst position was replacement level. I don’t think this would change for 2014 actual vs. 2015 projected.

  5. I take that back. The positions would only change is someone lost eligibility… not sure where to track down 2014 actual eligibility unless you have it saved from somewhere else.

    • Dan says:

      Thanks, it took some looking around to find the appropriate exportable stats but I think I have what I’m looking for.

      Again, great job on the workbook, I’ll be using for my draft as well !


  6. […] posts have tackled the Auction Calculator and the Roster Grid, but today we’ll post two new tools for the 2015, both designed to help […]

Discuss! We're listening...

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: