Author Archive

Ottoneu Tools: Advanced Standings Part Two

In early May I introduced Ottoneu players to the Advanced Standings Dashboard, a tool that allows team owners to decipher the early season standings in an effort to better gauge where their team might be headed as the 2014 season comes together. You can download that tool here (, but now that we’ve just entered July, the traditional halfway point of the baseball season, it’s time to take a deeper look at a few ways this tool can be used to effectively to manage your team into contention in the second half.

Since the tool can be updated easily with just a couple of copy/paste actions, I use this tool almost daily in my own FGPoints Ottoneu league.  But for fun, let’s walk through a few features as they apply to the FanGraphs Staff League, with a special focus on Eno Sarris’ team, “It’s A Perm“.

Eno enters July as a 3rd place team, nearly 400 points out of 1st place, and 150 out of 2nd.  In general, with at least seven teams over the 8,000 point mark, this league looks competitive at a glance.  But with the recent pickup of Ryan Braun, Eno clearly has his sights set on a title (, so let’s break down the standings using the tool to see if Eno has the momentum to win it all in the 2nd half.

The first tab of the tool is simply the statistical breakdown of the Ottoneu standings into some common sabermetric calculations.  While we can easily see Eno leads the league offensively at 5.44 P/G, the underlying statistics also support it, showing he maintains an (slight) advantage in OPS, OPS+, wOBA, Runs Created, and Total Bases.  What may be more interesting is that Eno has more points scored from his offense than any other team in the league.  In fact, just over 58% of his points have come from his hitters (tab 3, ‘Projected Finish”). With roughly 55% of league scoring in Ottoneu coming from offense, Eno is clearly banking on this approach of shoring up the side of the ledger that carries the most weight.  The acquisition of Braun will only help.

So It’s A Perm is built on bats, but what about the pitching? Unfortunately, this is a weak spot, as Eno’s FIP, WHIP, and BB/9 are all higher than the two teams he’s chasing.  I’m sure he knows this instinctively as his 5.03 P/IP is below the league average of 5.13 P/IP (and further below the top 7 teams of 5.19 P/IP), but the dashboard makes it quicker and easier to point out these pitching deficiencies.  One possible area of improvement: the bullpen.  Without looking at his roster, I can tell you pretty quickly he’s probably pretty frustrated with his bullpen, which has been almost 42% less effective (“PEN” = Saves + Holds/IP) than the league leader, A Little Out of Context.  Shoring up a bullpen is often easier and cheaper than finding an ace SP mid season, so does Eno speculate on the eventual Sergio Romo replacement? Does he approach John Heyman’s Last Sirloin about shedding some of his bullpen pieces in a plea to “deal from strength”?

Once you’ve taken the time to digest some of the traditional sabermetric outputs in the Dashboard, your eyes will naturally gravitate toward the end of the first tab into the “League Projections” section, which is where the real power of the tool comes alive.  The key takeaways here are the “Otto” score and the “Pace” columns.  The Otto score can be better explained here by Chad Young (, while the “Pace” attempts to project the season-ending point totals for each team based up a range of factors, including current P/G and P/IP values, remaining IP and GP, and league averages in these areas.  In many leagues these are the columns that can better identify contenders from pretenders, but for the FanGraphs Staff league we see more evidence that the actual standings are, for the most part, very accurate, as Eno is also projected to end the season with the 3rd most points (18,042, or about 400 points out of 1st place).

There are a few interesting things to note here, however. First, John Heyman’s Last Sirloin actually has the third highest Otto score (13.66), but is still projected for 4th place, most likely due to his slower pace in IP (1,416 projected).  If this team can pick up the IP pace in the 2nd half with similar quality IP (5.54 P/IP), this team could make up ground quickly.  This team is clearly riding a league-best bullpen and trying to maximize its RP innings as much as possible.

Second, Ground Rule Double Helmet, despite sitting in 4th place with a strong 9,000 points, has had to overtax a very week pitching staff (4.74 P/IP) just to get there (1,577 IP projected).  The tool sees as much and projects this team to end the season in 5th place, but unless the pitching staff sees a significant improvement in the 2nd half, I’d expect this team to possibly fall even further as the season shakes out.

And that’s just the first tab…Once you get familiar with the tool, you’ll actually find the third tab, “Projected Finish” to be the most useful summary of some of these features described above, as it will give you a daily update of the projected champion for the league.  With Eno just 400 points out of both the actual and projected season-ending standings, this league is just too close to call on July 1st, but there are at least four clear contenders here, and It’s A Perm is one of them.  Will Ryan Braun help the cause? Just for fun, let’s say Braun increases Eno’s offense by just 2.00% (from 5.44 to 5.55).  Well, that could be all it takes, as that small increase moves the needle for It’s A Perm enough to overtake Johan Santa Claus by 100 points in the projected season-ending standings, and less than 200 points out from 1st place.  Of course, that’s if everything else stays the same, and, as in life, the only thing constant in baseball is change.  This will be a fun league to watch as the summer heats up, so enjoy the tool and use it where possible to get that 2% edge.

Ottoneu Tools: Advanced League Standings

Ottoneu Tools: Advanced Standings (Part One)

Whether you’re brand new to Ottoneu or a “seasoned” veteran in your fourth year, your league’s Standings page is likely to become your best (or worst) friend over the course of a given baseball season. However, if you often find yourself cheering or panicking based on just a few days’ worth of small but evolving linear weights data without the proper, broader context with which to make meaningful decisions about your team, you are not alone. Welcome to the Ottoneu “Advanced Standings” dashboard. The brainchild and early creation of Bill Porter (@wfporter1972), the Advanced Standings dashboard will provide you with the sabermetric performance data you want with the detail you need.

How It Works:

Before you get started you will need to download the current version of the Advanced Standings dashboard here ( Note: You will need the most up to date version of Excel to take full advantage of the dashboard features. Also, this Advanced Standings dashboard only works with FGPoints Ottoneu format leagues (for now).

While it may look overwhelming at first, the dashboard is designed to be easy to use. In fact, it’s designed to be updated quickly and often without requiring a lot of Excelmanship. With as little as two easy steps you will be able to see “inside” your league standings in a way not available on the website.

First, go to your league’s traditional STANDINGS page within Ottoneu. From the bottom right of the standings stats (begin just to the right of the last P/IP on the right hand bottom corner), highlight all standings data with your cursor (including team names). Do not export the standings to Excel. Also, do not highlight the headings bar that includes the column titles (AB, H, 2B, etc.). COPY this information and then go to the first tab (“Advanced Standings”) of the Excel dashboard. In cell A4 (1st team name in column), PASTE SPECIAL and select TEXT. When pasted, your league’s standings will populate this tab and you will have visibility of many advanced statistics tailored exactly to your league.

Second, to have more accurate league standings information, go to your league’s REPORT page within Ottoneu and at the bottom of the page highlight all the information (excluding the column headings) in the “Projected Games Played and Innings Pitched” section. Once selected, COPY this information (including team names), and PASTE SPECIAL – TEXT this data into Tab 2 (“Reports”) of the dashboard spreadsheet, in cell A2.

Yeah, it’s that easy.

In Part Two I will revisit some of the key features of the Advanced Standings Dashboard and how it can be best used to analyze your league  You can also learn how to go much deeper into these advanced standings from reading Bill’s recent post on this subject here ( Until then, enjoy playing with the dashboard tool. If you have questions or want access to some additional Ottoneu tools, feel free to DM me on Twitter @Fazeorange and I will send you a link to the Ottoneu Dropbox folder.


Ottoneu Tools: FGPoints

Below are two tools for Ottoneu FGPoints players to be used for the 2014 MLB season.  The first tool is a roster building tool that will provide 2013 statistics, including platoon splits, for offensive players.  Ottoneu players can use this tool to construct their team and prepare for 2014 auction drafts.

The second tool is a 2014 player projection tool that Ottoneu players (and commissioners) can use to estimate player projections for the 2014 season.  The tool incorporates Steamer, Oliver, and 3 Year Average stats for each player and then allows you to enter your own projections for the 2014 season.  Your own projections (will auto-populate FanGraph’s “Fans” projections as of 2.8.14…you can override these projections by entering your own) will load the team dashboard at the top of the tool and provide you with a summary of what you can expect from your Ottoneu team in 2014.

Roster Breakdown w/platoon splits:

2014 Team Projections Tool: