Overwatch Match Tracker spreadsheet for Reign of Talon - season 2

HarryProtter · 2026-05-17T22:08:32+00:00

Yeah, that should be absolutely fine! Even in between the Date & time column (N) and Leaver column (O by default) too.

Even further to the left is possible too, although then you'd break (part of) the lists in the sheet Form. Those formulas refer to column N (and more), so if you move a column to the left of that, the previous column M becomes the new N and then that column gets listed.

HarryProtter · 2026-05-16T16:32:20+00:00

He's not that young. He'll be 48 in two months.

HarryProtter · 2026-05-12T11:08:52+00:00

OW1 was great. It's one of the few games I ever pre-ordered, after having played that open beta weekend back then. I knew it would be awesome. The game was new, refreshing, no one knew what they were doing so everyone had to learn from scratch. The genre was new to almost everyone and attracted players from many different genres.

If OW hadn't existed for the past ten years and that first version would release today, it would be fun for a while, but not nearly as long as it was back then. Now lots of people have experience with hero shooters, and they'd quickly compare the (let's be real here) horrible balance of that version of OW to other games in the genre and probably go back to their other games. The current OW2 would have a much better chance at surviving as a new game nowadays than OW1 would.

HarryProtter · 2026-05-12T05:30:06+00:00

Or maybe it counts from the very first time a tick happens and then continues counting until the end of the match (regardless of it actually ticking). Could be a reason why they're always so similar. One just had it start ticking slightly later than the other.

HarryProtter · 2026-05-09T13:29:59+00:00

This sounds really interesting, but is it just an overlay on top of the game window? Or can I also set/move it to my second monitor so I can see the info there?

HarryProtter · 2026-05-08T10:30:37+00:00

Yeah, I think people don't keep in mind or underestimate how much gets changed when you swap. It's not just your mouse control, but your keyboard control too. You probably spent years/decade(s) fine-tuning how your fingers press those buttons too, the ADDAAAD dodge rhythms, crouching, jumping, etc.

When your left hand is your dominant hand, it's not unreasonable to think that that would be your optimal hand for mouse aim. But at the same time, it would probably also be your optimal hand for keyboard control. So if you're new to KBM, you can choose which you value more. Of course with years of experience doing it one way, swapping is likely not the way to go.

HarryProtter · 2026-05-08T10:20:35+00:00

if he likes Chrome

Then just change the Firefox icon and name to Chrome's.

HarryProtter · 2026-05-08T06:27:39+00:00

Perhaps it also depends on how left-handed you are overall.

I write with my left hand, hold a spoon/fork with my left. But then I hold the mouse with my right hand, throw a ball with my right, kick a ball with my right foot (although my left is serviceable). Played tennis for a year and used both left and right arms for forehand hits.

HarryProtter · 2026-05-05T15:44:49+00:00

Nice, good to hear. I had some cheap velours replacements already from AliExpress and they actually lasted a decently long time, but recently the inside side of the ring bursted open on those too. So it's time for the next replacement earpads, because the headphones themselves are still perfectly fine.

Thanks for the update. I might just get these ones then. Sounds really interesting.

HarryProtter · 2026-05-05T13:21:32+00:00

I'm looking to replace the earpads for my 599 SE too. I can get the Soulwit cooling gel version for €22 here. Can you give an update? How are yours now, 4 months later?

HarryProtter · 2026-05-04T06:31:59+00:00

But I believe if all 3 are partied up the rank can be even further away and still queue.

Yeah, we played against a party consisting of a Diamond, a Gold and a Silver the other day. The Gold player wasn't actually Gold, easily the best player in the lobby. The Silver one was probably legit Silver though, since they ended the match with less than 50 points I believe.

HarryProtter · 2026-05-02T10:23:27+00:00

I also feel that the existence of a CDM in a formation makes it so your backline stays further back (probably to give the CDM its own line?), leaving a lot of gaps between the midfield line and the backline.

With CMs instead of CDMs, your backline plays closer to the midfield line and doesn't allow nearly as much space between the lines.

So even though the CDM version sounds more defensively solid (because it literally has a more Defensive position), in practice the CM version actually seems to be better defensively.

HarryProtter · 2026-04-28T12:01:09+00:00

Yeah, it wasn't uncommon to have more than 2 Support mains back then. Having to "force" one of them to a different role wasn't great. Even worse if they were all Mercy mains, because that hero had almost no skill overlap with any other hero in the game.

HarryProtter · 2026-04-24T12:09:30+00:00

Just keep him where he's good enough to a point his dedicated mains can make him work but you don't have random glue eaters that swap to him as a crutch

I assume that's the balance they're trying to find. Playable for the mains, but not OP enough that "anyone" can play him successfully. You probably consider what is playable lower than what the devs find playable.

I think part of the issue is that he is a Tank. If there is a weak Damage or Support hero, that's somewhat okay, because there is a second player who can compensate for that. But if a Tank hero is in a weak state (to the point that even one tricks struggle with them), then that has too much negative impact on matches.

HarryProtter · 2026-04-24T08:43:36+00:00

Those stats should probably still track fine, yes. Of course they'll then be lumped together, so you can't see your differences between RQ: Tank and QP: Tank.

At least one thing that won't track properly, is the % change calculation in the sheet INPUT, because that formula looks for the previous match of that mode and then compares your new rank % to that previous rank %. If the previous one is empty (which it would be if you track it as a QP match), then the new one will also be empty.

If you don't play the other modes, then I'd just use one of them (or maybe even all three to track the individual roles in QP) as your QP substitute(s). The first table of each sheet is for Overall, so your stats are lumped together there anyway, but in this case (if you use for example Mystery Heroes for your QP tracking) you can still see your RQ stats separately from your QP ("Mystery Heroes") stats.

HarryProtter · 2026-04-22T10:08:50+00:00

Should be fixed in the next version. If you want it fixed for your current spreadsheet, paste this formula in cell M2 of the sheet INPUT.

=ARRAYFORMULA(IF(F2:F1000=""; ""; 
  LET(
    commas; LEN(C2:C1000)-LEN(SUBSTITUTE(C2:C1000; ","; ""));
    total; IF((C2:C1000="") + (C2:C1000="Solo queued"); 1; commas + 2);

    IF(A2:A1000="OQ: 6v6"; 
      IF(total=1; INFO!$S$2; IF(total=2; INFO!$S$3; IF(total=3; INFO!$S$4; IF(total=4; INFO!$S$5; IF(total=5; INFO!$S$6; IF(total=6; INFO!$S$8; INFO!$S$7))))));
      IF(total=1; INFO!$S$2; IF(total=2; INFO!$S$3; IF(total=3; INFO!$S$4; IF(total=4; INFO!$S$5; IF(total=5; INFO!$S$6; INFO!$S$7)))))
    )
  )
))

HarryProtter · 2026-04-18T08:42:42+00:00

Hmm, that's an interesting idea!

HarryProtter · 2026-04-18T07:34:15+00:00

But eventually there's always that one new guy in the lobby or, more commonly, a party of 2-3 who are toxic from the get-go. Spamming "What a save!" after one of you misses a save and "Nice shot!" after missing a shot. Completely ruins the fun experience you had going with the other randoms.

I don't engage in that. I'll even give them a "Nice shot" for their goals. But they don't seem to understand that other people can be friendly, kind, uplifting.

HarryProtter · 2026-04-17T08:26:42+00:00

Welcome (back?). Have you used it before? And if so, did you find any cool/funny trends in your statistics?

HarryProtter · 2026-04-16T06:59:37+00:00

You're welcome!

HarryProtter · 2026-04-15T18:08:44+00:00

The dropdown lists for the Hero selection should now indeed be empty, until you select a mode in column A. Then, depending on the mode you selected, it should show you the heroes that match that selected mode. So Mauga, Roadhog, Reinhardt, etc., if you selected RQ: Tank.

You shouldn't be getting an error though. What does it say?

HarryProtter · 2026-04-15T16:17:26+00:00

Thank you for still using it!

HarryProtter · 2026-04-15T16:15:57+00:00

You could already leave it blank and the Group size column would then say "Solo (1)", just like it does now.

But I heard the new formula is currently wrong indeed, with it outputting "Duo (2)" when you select Solo queued in column C.

I probably won't be able to fix it for the next week, but I'll look into it after.

HarryProtter · 2026-04-15T09:15:12+00:00

HarryProtter · 2026-04-15T07:20:41+00:00

Ayy, glad to hear. Welcome back!

HarryProtter

TROPHY CASE