ABCDEFGHIJKLMNO
1
Overwatch 2 Match TrackerDONATE
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
INSTRUCTIONSDONATE
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 theRQ: 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 dropdownRQ: 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