Scorekeeping Spreadsheets
Hey, to keep track of my scores (as well as those of a few friends), I've been using a google sheets document that I've been developing over time. I always meant to share it here, but forgot to do so until now!
They're both in the form of publicly viewable google sheets, if you want to use it yourself just open the link and make a copy within your own drive account. I don't use excel much myself (no horizontal mouse scrolling, gross), but if there's interest in an excel version I can see what I can do.
Here is the template, currently set up for 3 users, but it's flexible with adding or removing people.
Here is an example usage of the template (basically just the one I use, without names and a bunch of other more messy scratch sheets I use).
The sheet basically just works by anyone inputting their scores in their "[name] Raw Data" sheet, and it at the top it will calculate the best scores according to different metrics (I started using these ones before I ever looked at the subreddit, I still get kind of confused looking at how the leaderboard scores so let me know if you'd like some other scoring method added). On the "Summary" sheet, it then shows the comparisons across all users on the document for the chosen evaluation (there's a dropdown). You can check a box to turn on coloring (green means you have the best score, orange means you're tied for best, red means someone is beating you). I will note here that I think I remember there being problems with the coloring for evaluations other than individual scores and sum (I haven't used the sheet in a while so I can't quite recall the exact issues), but in my quick testing I haven't been able to track down any problems. Let me know if you find something wrong with that!
There's also a box you can check that will populate a table with scores from the wiki here, for the leaderboards. (I usually leave it off for either spoiler reasons, or wanting to compare between friends not to the leaderboard, or because I want some green on my side lol). In "Summary", each table will show the scores from a sheet named "[name] Raw Data", where [name] is at the top of the table (currently "user1", "user2", and "user3").
There's also a template raw data sheet, I recommend leaving it hidden when not in use, but to add a new user just duplicate that sheet and rename the copy appropriately, and fill it with the scores.
Oh and also, as you can see in "Friend2 Raw Data", if you don't know someone's exact scores (like you're just looking at the comparison steam shows you to your friends), you can just overwrite the formulas and hardcode in some values if you want (for individual scores, presumably). It might make some other evaluations show partial scores, and show some errors on the raw data sheet, but that's not really a big deal (if you want to get rid of the errors, just add a "iferror()" around the formulas).
Sorry for the huge post, I hope someone finds this useful!
Posted Aug 31, 2021, 7:33 PM UTC
This is awesome! I'm using this instantly to keep track of my scores on everything! So well-done.
Thanks for the kind words! I'm just glad someone might find it useful