A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | Overwatch 2 Match Tracker | DONATE | |||||||||||||
2 | |||||||||||||||
3 | |||||||||||||||
4 | Overwatch 2 Match Tracker by HarryProtter | ||||||||||||||
5 | Use this spreadsheet to track your competitive matches and statistics about them. Statistics such | ||||||||||||||
6 | as your win rates per role/map/day, rank changes, streaks and other things. | ||||||||||||||
7 | |||||||||||||||
8 | Created by HarryProtter, inspired by other spreadsheets, such as Jerrywoohu's "Overwatch | ||||||||||||||
9 | Quantified", Dripping's "Overwatch 2 Season 4 Competitive Tracker", Umarrii's "KarQ's Season 9 | ||||||||||||||
10 | Ranked Data" and ExplodingCashew's "Overwatch 2 Game Tracker Season 10". | ||||||||||||||
11 | |||||||||||||||
12 | |||||||||||||||
13 | INSTRUCTIONS | DONATE | |||||||||||||
14 | Click on File in the top left, then on Make a copy and save it to your Google Drive. That should | My spreadsheet is free to use and will continue to be free. | |||||||||||||
15 | create your own copy of this spreadsheet. | Maintaining it and adding new features costs time though, so | |||||||||||||
16 | In your own copy, click on File, then on Settings and change the Locale and Time zone to your | if you enjoy using my spreadsheet, please consider donating. | |||||||||||||
17 | location. | Click the DONATE button above for more information. Thanks! | |||||||||||||
18 | |||||||||||||||
19 | Enter the information about your matches in the sheet INPUT. | ||||||||||||||
20 | |||||||||||||||
21 | Only enter data in cells with a white background! Orange and grey coloured cells update | Tick the boxes of the | RQ: Tank | ||||||||||||
22 | automatically based on your inputs in other cells. | modes you want to | RQ: Damage | ||||||||||||
23 | Many cells in the top row of the sheet INPUT have notes with instructions, indicated by a black | see in the dropdown | RQ: Support | ||||||||||||
24 | triangle in the top right corner of the cell. Hover your cursor over those cells to read the notes. | lists. | Open Queue | ||||||||||||
25 | Mystery Heroes | ||||||||||||||
26 | If you want to use the date format MM/DD/YYYY instead of the default DD-MM-YYYY, then make | Team Queue | |||||||||||||
27 | sure you first changed the Locale and Time zone to your location. After you did that, | Deathmatch | |||||||||||||
28 | select column M from the sheet INPUT, | ||||||||||||||
29 | click on Format in the top left, then on Number, then on Date time. | ||||||||||||||
30 | Solo queued | ||||||||||||||
31 | To track your statistics of playing with specific players (friends, teammates, etc.), follow the | Enter the names of specific players | Ron | ||||||||||||
32 | instructions to the right. | you want to keep track of, | Hermione | ||||||||||||
33 | If done correctly, their names should show up in the dropdown list in column C of the sheet INPUT. | starting in cell H31. | Hagrid | ||||||||||||
34 | After selecting multiple names from the dropdown list, a red triangle will pop up in the top right | One name per cell, each name on a | Dumbledore | ||||||||||||
35 | corner of the cell as warning. Ignore that warning, it still works! | new row! | Snape | ||||||||||||
36 | |||||||||||||||
37 | If you don't want a map or hero to be tracked for a certain match, you can leave the respective | ||||||||||||||
38 | cells empty in the columns of the sheet INPUT. The match will still be tracked, but as "Blank Map" | ||||||||||||||
39 | or as "Blank Tank/Damage/Support/Hero" (depending on the selected mode). | ||||||||||||||
40 | |||||||||||||||
41 | |||||||||||||||
42 | In the other sheets you can see your statistics, based on the information you entered in the sheet | ||||||||||||||
43 | INPUT. | ||||||||||||||
44 | Don't manually change or add values in these other sheets (except for the filters). Those values | ||||||||||||||
45 | update automatically. | ||||||||||||||
46 | |||||||||||||||
47 | In several of the other sheets you can select filters for the third, fourth, fifth and sixth tables. | ||||||||||||||
48 | By default the filters should be Open Queue, RQ: Tank, RQ: Damage and RQ: Support. You can | ||||||||||||||
49 | choose different filters for these tables, for example Echo in one table and Hanzo in the table next | ||||||||||||||
50 | to it, so you can compare your stats between them. | ||||||||||||||
51 | |||||||||||||||
52 | |||||||||||||||
53 | Have fun! | ||||||||||||||
54 | |||||||||||||||
55 | |||||||||||||||
56 | |||||||||||||||
57 | |||||||||||||||
58 | |||||||||||||||
59 | |||||||||||||||
60 | |||||||||||||||
61 | |||||||||||||||
62 | |||||||||||||||
63 | |||||||||||||||
64 | |||||||||||||||
65 | |||||||||||||||
66 | |||||||||||||||
67 | |||||||||||||||
68 | |||||||||||||||
69 | |||||||||||||||
70 | |||||||||||||||
71 | |||||||||||||||
72 | |||||||||||||||
73 | |||||||||||||||
74 | |||||||||||||||
75 | |||||||||||||||
76 | |||||||||||||||
77 | |||||||||||||||
78 | |||||||||||||||
79 | |||||||||||||||
80 | |||||||||||||||
81 | |||||||||||||||
82 | |||||||||||||||
83 | |||||||||||||||
84 | |||||||||||||||
85 | |||||||||||||||
86 | |||||||||||||||
87 | |||||||||||||||
88 | |||||||||||||||
89 | |||||||||||||||
90 | |||||||||||||||
91 | |||||||||||||||
92 | |||||||||||||||
93 | |||||||||||||||
94 | |||||||||||||||
95 | |||||||||||||||
96 | |||||||||||||||
97 | |||||||||||||||
98 | |||||||||||||||
99 | |||||||||||||||
100 |