2015 Ottoneu Roster Grid (updated)
Attached you’ll find an updated version of the 2015 Ottoneu Roster Grid for FGPoints leagues. You can use the Roster Grid in a number of different ways:
- Pre-load existing team rosters before your league auction begins to determine your needs at various positions, what you expect (project) from various free agents, and how much money you have available to spend compared to your rivals.
- Load all rosters after your league auction in order to compare (power rankings) and evaluate teams overall or by position to determine strengths and weaknesses, contenders and pretenders, and everything in between.
- Easily and quickly build your own player projections using the template to compare against three year averages, 2014 production, and FG Fans expectations for the upcoming season.
While the tool may look intimidating at first glance, it is very easy to use for even those with just basic Excel skills.
First, from your league page, download your league rosters to Excel. Next, highlight and copy both the Player Name and Salary columns from your league rosters sheet into cell “A6” of the League Salaries (Input) tab in the Roster Grid. This action should populate the salary for each owned player in and the total salary of each team in your league.
Next, enter the name of each team in your league in the League Salaries tab. This will enable to you to quickly select each team in the Roster Grid tab (column I).
Finally, enter your projections for each rostered player on the Roster Grid tab. You can input two variables: the P/G (or P/IP) you expect the player to score in 2015 (column N), and the Games Played (or Innings Pitched) per player you expect from each player in 2015 (column O). As a guide, the P/G or P/IP in column N will default to the average of the three previous production columns, but you may override this production level depending on how you expect a player to perform in 2015. In other words, you can use the averages provided, or can easily override this information if you feel strongly one way or another about either the playing time or production level of a player on your team (or another owner’s team).
There – you’re done. Once you’ve entered each player on each team and their respective production levels and playing time, check out the Summary tab, which will provide you with a quick, graphical comparison of your team vs. others in your league. These graphs will change in real time according to your Roster Grid projection entires, so they should help give you an easy way to determine where your team needs improvement or where it is better than others.
The Roster Grid is one more tool to help prepare you for Ottoneu success in 2015. Enjoy.
If you have questions, or see any issues, feel free to contact me on the #OttoneuCommunity on Slack, or leave comments here.