If you’re a data nerd like me and want to track your Tetris 99 game results, I’m happy to announce that I’m making my Twitch overlay dashboards freely available to the public. These stats were originally created in Tableau but creating a public version with the limitations of Tableau Public was too cumbersome. This new system is 100% Excel based on much easier to implement and update.
Below are step by instructions for how to set everything up, but if you prefer video to words, click here for the YouTube tutorial.
Download Excel File
If you prefer to see an example of the file with data already completed, click here to download a copy of the Sniper Stats spreadsheet used for the DaddioTV Twitch stream.
Note that this spreadsheet uses macros to automatically rotate between tabs so you may need to adjust your security settings to enable macros.
Populating the Game Log
Log all your games starting in the data entry section starting in row 6
- Game ID: Unique ID for each game played. If there were 5 players in a single game, there should be 5 rows of data: one for each player.
- Host Streamer: Your name. This is used to determine if the player is the also the host, which is used to filter Sniper only dashboards
- Date: date the game was played
- Mode: Tetris 99 or Invictus
- Place: The place the player finished
- Player: Player name
- All other columns are formula fields and should be left alone
At the top of the screen you’ll see the following fields:
- Include in Rotation: Leave this set to False so this data entry tab get skipped in the tab rotation
- Min Game Count All Time: Minimum number of games for players to be included in Win Rate and Most Consistent dashboards. Default value is 5
- Min Game Count Today: Minimum number of games for players to be included in the “Today” versions of Win Rate and Most Consistent dashboards. Default value is 3.
- Record Count Today: This is a formula field. You can ignore it
Populating Optional Player Info
If there are certain players you want to highlight in your dashboard (you, subscribers, etc.) you can do so in the Player Info tab. This tab can also be used to track players who have a different in-game and Twitch names.
- Player: The in-game player name
- Twitch Name: Twitch name, if different than player name
- Highlight in Stream? Set as “Highlight” to highlight the player on the dashboard
- Highlight Category: Optional reason why you’re highlighting this player
All the other tabs are populated with small dashboards ready to be displayed in your stream. These are all Pivot table based so if you’re familiar with Excel, feel free to make your own edits or new tabs. Clicking the green Start Rotation tab will start the Countdown to Transition timer and switch to the next tab marked with “Include in Rotation” as True. Tabs for “Today” stats should automatically get set to Include in Rotation when at least 2 games have been logged today.
Adding dashboard to OBS
The preferred method to add to OBS is Window Capture, but unfortunately I just get a black screen when capturing Excel. If you get the same, Display Capture should work but you’ll just need to make sure to keep a section of your desktop dedicated to Excel.
First, click the Add Source button and add either Display/Window Capture to your OBS layout. Adding Display Capture will add your entire desktop and Window Capture will add just the selected Window.
When you first add the new source, you’ll see way more than you want so show on your stream. Right click the newly added source and click Filters, then click the + button to add a Crop/Pad filter.
Adjust the Left, Top, Right, and Bottom crop values so that just the dashboard is being displayed. Make sure you have a dashboard tab selected in Excel and you have Excel positioned exactly how it will be when you’re streaming.
Next, we can make the dashboard transparent by using a Color Key filter. While on the Source filter page, click the + button to add a Color Key filter and set the key color to white to remove the background.
The last step is to add a semi-transparent black background behind the stats to help them stand out on the screen. Use the + button on the Sources section to add a Black Color Source and then add a Color Key Filter to lower the opacity. Place one layer below the Display Capture and you’re set!
You’re all set for stat tracking on your stream! I recommend setting up another scene that doesn’t show the stats that you can use when logging games. Also remember to click the “End Rotation” button to enter data and the Start Rotation button to resume.