2019 Update: This tool still works, but no promises that certain things might be broken. I’ll be updating this with new features soon!
I’m back again with another ottoneu tool built with Sheets, this time it’s an ottoneu football league dashboard.
Instructions/Features:
Before you can use the dashboard, you will need to make a copy of the tool. You can do so by opening the dashboard link below and going to File:Make a copy to save a version you can edit to your own Google account.
League tab- Input your ottoneu football league # (the same # that appears in the URL of your league homepage, see here for an example https://ottoneu.fangraphs.com/football/67/) in cell B4, the league settings and standings will then populate automatically
Matchups tab- This tab will show the initial and adjusted projected team scores for each weekly matchup, based on FantasyPros projected points. The matchups listed in Column B are pulled automatically, but you can manually adjust them using Column C. There are two primary reason why you might need to do so: 1) The ottoneu week doesn’t roll over until Wednesday morning, so please note that if you view the dashboard on Tuesdays it will show the matchups from the prior week (though the projected scores ARE for the current week). You can input the correct matchups manually if you want to see them on a Tuesday, just be sure to clear those cells in the future to see the automatic matchups again. 2) Some team names that include a numeral cause a bug on the dashboard, you can tell if this is happening because the Initial Proj in Column F will be shaded red for that team. Just select the correct team from the dropdown in Column C.
Lineup tab- Select whichever team you want to view from the dropdown in cell B1, and it will show you that team’s current lineup with actual and projected (from FantasyPros) weekly scoring for every player, as well as the total initial projected team score and updated projected team score (the updated projection accounts for player’s who have already played that week). These projections are all automatically adjusted for the particular league format (PPR, half PPR, standard).
Roster tab- Select the team you wish to view from the dropdown in B1, then select how you’d like to sort the players in B2 (by weekly projected points, rest of season ranking, or salary).
Free Agents tab- This tab shows you all free agents in your league, with options to sort those players by ottoneu ownership %, average salary, weekly projected points, or rest of season position ranking. I’ve also included the option to additionally sort by position, or you can use the filters on this tab to view specific positions.
The remaining tabs are broken down by position and show the weekly projected FantasyPros points for all players at the position.
I want to thank @bills217, @Miguel, @Mulemadness, and @edtnvol for testing this tool, and a big thanks to @dave for his help with regular expressions!
Please let me know if you have any other questions or suggestions!
Version Log:
9/19- Fixed another small bug on the Matchups tab
9/18- Fixed automatic team ID bug
9/14- Added Rest of Season Fantasy Pros rankings (Half PPR) to Rosters and Free Agents tabs
9/13- Fixed bug that resulted in Lineup and Roster tabs not populating correctly
9/12- Initial version released