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:

Trey is a 20+ year fantasy veteran and an early adopter of Ottoneu fantasy sports. He currently administers the Ottoneu community, a network of ~1,200 fantasy baseball and football fans talking sports daily. More resources here:

Newest Most Voted
Inline Feedbacks
View all comments
10 years ago

Wow, thanks for this. One question, how can I play around with it? Seems that permissions are “locked” or something? For example I can’t read the number in grid C1 because the column is too narrow, but the workbook won’t allow me to stretch the column, nor shrink the font size. But overall this is great and just what I needed to prepare me for our ottoneu draft in 8 days.

Joe Douglasmember
10 years ago

Can cell widths be changed? Having some trouble with values calculating being to large for the current cell width. Also, with the projection tool, does every roster spot need filled in before the summary at the top updates (Cells D2 to Q10). Also are rows 258-267 supposed to be manually updated? Or is there some form of grading system in place?

Joe Douglasmember
10 years ago
Reply to  Trey Baughn

Is the D2 to Q10 portion populated as games are played? “#Name?” appears in D2 through D9. Columns E(2-9) through P(2-9) do not populate (if they are supposed to).

10 years ago

this is great. thank you!

10 years ago

brilliant tool, thank you! would love a Roto version too:)

10 years ago

This is great, thank you so much for sharing your work.

10 years ago

This is awesome. I’m in Roto as well, but this is still useful. Actually, has anyone looked at how FG points correlates with Roto stats? Obviously some players are better in Points than in Roto; Points rewards pitchers for innings; Points doesn’t have batting average but does deduct points for making outs… so how closely do they correlate?