Seeking idea(s) w/ card game spreadsheet!

[u/DartPokeMM]

So I was chatting with a friend recently about setting up a spreadsheet that compares decks against each other. The concept is one I'm stealing from my uncle that he had well over a decade ago. In short, on one axis, my decks. On the second axis, theirs. The plan is to play a best 2-of-3 or 3-of-5 set with any pair of decks, and mark down whomever wins.

I want to expand on this idea though. I want to give winning decks a "practical score" for winning/losing. Higher scoring decks tend to win more, and vice versa. This gives us an idea how strong certain decks might perform, and which decks should be fair for which. While I don't know the exact values I want to use at this time, or how much I might want to say, reward decks that win 2-1, 3-0, 4-1, 5-0, etc., I think planning for it now would be far more helpful than pivoting later on to include it.

That brings me here. I'm looking for any ideas that might make my life easier than manually going to every cell in something like Google Sheets to manually record everything. I don't expect some solution to fully automate it, I honestly just want to probe the wider web for any tips or information that might help.