I’m not sure if anyone wants this or cares, but a friend told me I should share this so here it is.

During Season 5 I got tired of loosely tracking my WT WPs in a Notepad file and manually doing the math to check how many WP’s I needed each day to stay on track for Emerald 1, so just before Season 6 hit I created this spreadsheet for myself. The Overview worksheet shows an overview of each season, with information like current rank (pulled dynamically based on the WPs you have from tournament games entered into the seasons WT tracker table on the WT worksheet, total WPs, WP remaining for Emerald 1, target WP/day based on remaining, average WP per tournament, total cash cashed out, win percentage, KDR, and total tournaments played.

Same thing for Quick Play basically.

Also the same thing for Ranked, but with RS totals, RS remaining, average RS per tournament, etc.

Here’s some screenshots showing the Overview worksheet, as well as the rest of the Table/DB worksheets (https://imgur.com/a/4XebA0r).

Here’s a link to the .xlsx on my Google Drive if anyone wants to use it (https://docs.google.com/spreadsheets/d/1mC4Xjvx26H8T5I0Lv98TnqO3PV2vL51m/edit).

Google opens it in Sheets instead of just downloading it, so please ignore all the #ERROR! things in the cells. Apparently named tables, or VLOOKUPs, or some IF statements or something from Excel aren’t compatible with Sheets, and I honestly don’t care enough to port the formulas over. Having my browser open with Sheets up is more resource heavy while I’m gaming than saving this .xlsx as a .xlsb and just having it open in Excel on another monitor. It all works in Excel, just download from Sheets as .xlsx.

It’s been really interesting to see that my feeling that WT was sweatier than Ranked this season supported by my Win Percentage and K/D for each. Also feel free to roast my stats idgaf.

It’s already templated out for Season 7, I just cleaned it up before hopping into some games. You can just delete the columns for S6 stuff and start adding games in under the relevant S7 tables. I thought about removing my S6 data but figured I’d leave it in there for context.

Also sorry for imgur link vs catbox, but I didn’t want to scare the reddit people.