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 (http://goo.gl/Tozhy4). 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 (http://goo.gl/XkDzXV). 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.

Enjoy



Print This Post

Trey is a 20 year fantasy veteran and a five time Ottoneu champion, including the 2015 winner of the Ottoneu Champions League. He currently administers the Ottoneu community, a network of ~1,000 hardcore fantasy baseball and football fans. Follow him on Twitter @fazeorange.


Sort by:   newest | oldest | most voted
Ayrahvon
Member
Ayrahvon

Looks great! I’m having issue with the League Average Fields not updating properly (the =_xlfn.AGGREGATE) once I paste in the new information. When I try to take a look at this it appears that it is read only and perhaps this why it isn’t updating for me currently.

Your original loads without issue.

wpDiscuz