Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- I like to gather information from the API to see patterns and rankings and would like to share.
- To use Google Sheets like a pro, hover over the letters above the headers to show a button. Click said button to sort, filter, etc.
- [section=User Statistics]
- After enough time, the user statistics have been compiled. [b][u]Warning: Very large and laggy[/u][/b]
- https://docs.google.com/spreadsheets/d/1510hl_x0rezZaYapF7xMnv-lcWvNt40ZzQqxk3hTH0Q/edit?usp=sharing
- Here are the stats I gathered for everyone and used to rank with:
- • Game Count
- • Game Count (with a full game run)
- • Leaderboard Count
- • Full Game Leaderboard Count
- • Run Count
- • Full Game Run Count
- • Run Activity
- • Full Game Run Activity
- • Activity
- • Full Game Activity
- • World Records Held
- • Full Game World Record Held
- • Top 3 Records Held
- • Full Game Top 3 Records Held
- • Sum of Weighted Records
- • Sum of Weighted Full Game Records
- • Best Weighted Record
- Total time has been phased out as it's heavily biased. It takes twelve 20 minute [b]personal bests[/b] just to match one 4 hour one. It wasn't a fair comparison.
- To the right of the sheet are rankings, depending on how you value things.
- • MasterOfOne ranks a player's best rank, from any one stat
- • AverageRanking does exactly that
- • JackOfAllTrades ranks a player's worst rank, from any one stat
- • MasterOfMasters compares everyone's best rank, across all ranks
- • AverageAverage works similar to the above and below
- • JackOfJacks compares everyone's worst rank, across all ranks
- Notes/Comments:
- - Like before, there's separate columns for full game leaderboards. However, this time it also required the median time of the leaderboard to be at least 5 minutes long. This removes virtually all runs that should be considered ILs instead. I'm talking to you Racingmonster...
- - Combined Activity is the same as Activity on the site for games (as of this post). Run Activity is the same, but not adjusted for time.
- - It does not know when a leaderboard is sorted descending, such as [url=https://www.speedrun.com/mp/Frigate_Escape]Metroid Prime's Frigate Escape[/url]. The API currently does not supply that information. [s]Even if it did, I'm not entirely sure how to go about implementing it.[/s] I'll use it to reverse things into negative, so positions are correct.
- - Activity DID NOT affect rankings this time around.
- - The formula that I used for 'RankWeight' is quite a doozy. People from last time might remember I was trying to improve the previous one and I think I got something pretty solid: [u][PlayerCount]^0.9375/[Position]^(1/3*([RunTime]/[WRtime])^5)[/u]
- For leaderboards with only 1 player, that run would be worth 1.0 in ranking. The [u]^0.9375[/u] is to slightly clamp the max value of a WR for larger leaderboards. Going down the leaderboard divides by the position, but doing that without clamping that too punishes positions close to 1st. If 2nd is practically the same as 1st, it'll still get about 80% of the worth of 1st. That's done so that 1st still has value while comparing to 2nd. But if the times are too different, times below 1st are punished HARD with the ratio between the time and 1st place's time; that's done with [u]([RunTime]/[WRtime])^5[/u].
- [/section]
- [section=Top Users]
- For individuals with a #1 position (followed by #2):
- • Game Count ------------------------------- [url=/user/Dugongue]Dugongue[/url] @ 205 ---------------- [url=/user/Jumpyluff]Jumpyluff[/url] @ 192
- • Game Count (with a full game run) ---- [url=/user/Dugongue]Dugongue[/url] @ 163 ---------------- [url=/user/Jumpyluff]Jumpyluff[/url] @ 143
- • Leaderboard Count ----------------------- [url=/user/Racingmonster]Racingmonster[/url] @ 1,185 ------ [url=/user/Jumpyluff]Jumpyluff[/url] @ 440
- • Full Game Leaderboard Count --------- [url=/user/Jumpyluff]Jumpyluff[/url] @ 221 ----------------- [url=/user/Dugongue]Dugongue[/url] @ 211
- • Run Count ---------------------------------- [url=/user/Racingmonster]Racingmonster[/url] @ 1,419 -------- [url=/user/Nordicboa]Nordicboa[/url] @ 832
- • Full Game Run Count -------------------- [url=/user/Cyberdemon531]Cyberdemon531[/url] @ 336 --------- [url=/user/Jumpyluff]Jumpyluff[/url] @ 294
- • Run Activity --------------------------------- [url=/user/MannedTooth]MannedTooth[/url] @ 111.85 ---------- [url=/user/Racingmonster]Racingmonster[/url] @ 48.24
- • Full Game Run Activity ------------------- [url=/user/katze789]katze789[/url] @ 23.74 ---------------- [url=/user/PrinceRallis]PrinceRallis[/url] @ 18.68
- • Activity --------------------------------------- [url=/user/MannedTooth]MannedTooth[/url] @ 114.75 -------- [url=/user/Racingmonster]Racingmonster[/url] @ 49.46
- • Full Game Activity ------------------------- [url=/user/katze789]katze789[/url] @ 33.33 --------------- [url=/user/Portal]Portal[/url] @ 26.38
- • World Records Held ---------------------- [url=/user/Racingmonster]Racingmonster[/url] @ 707 ---------- [url=/user/DarQ_Massacres]DarQ_Massacres[/url] @ 257
- • Full Game World Record Held ---------- [url=/user/werster]werster[/url] @ 61 --------------------- [url=/user/RPGodfather]RPGodfather[/url] @ 59
- • Top 3 Records Held ----------------------- [url=/user/Racingmonster]Racingmonster[/url] @ 1,089 ------- [url=/user/DarQ_Massacres]DarQ_Massacres[/url] @ 325
- • Full Game Top 3 Records Held --------- [url=/user/Dugongue]Dugongue[/url] @ 123 --------------- [url=/user/authorblues]authorblues[/url] @ 92
- • Sum of Weighted Records --------------- [url=/user/Racingmonster]Racingmonster[/url] @ 1431.12 --- [url=/user/Vallu]Vallu[/url] @ 967.29
- • Sum of Weighted Full Game Records - [url=/user/Vallu]Vallu[/url] @ 774.58 ------------------ [url=/user/TGH]TGH[/url] @ 736.39
- • Best Weighted Record -------------------- [url=/user/Torje]Torje[/url] @ 533.59 ([url=/oot#Any]OoT Any%[/url]) - [url=/user/nindiddeh]nindiddeh[/url] @ 454.22 ([url=/sms#Any]SMS Any%[/url])
- The best Jack of All Trades (comparing everyone's worst rank) are:
- 1) [url=/user/Pull]Pull[/url] (#208)
- 2) [url=/user/Vallu]Vallu[/url] (#280)
- 3) [url=/user/Nim]Nim[/url] (#362)
- 4) [url=/user/Konasumi]Konasumi[/url] (#440)
- 5) [url=/user/i_o_l]i_o_l[/url] (#441)
- 6) [url=/user/SigotuSM64]SigotuSM64[/url] (#444)
- 7) [url=/user/Sonicshadowsilver2]Sonicshadowsilver2[/url] (#479)
- 8) [url=/user/MhmdFVC]MhmdFVC[/url] (#485)
- 9) [url=/user/ethmar]ethmar[/url] (#526)
- 10) [url=/user/vlackSR]vlackSR[/url] (#533)
- And for average:
- 1) [url=/user/Jumpyluff]Jumpyluff[/url]
- 2) [url=/user/werster]werster[/url]
- 3) [url=/user/RPGodfather]RPGodfather[/url]
- 4) [url=/user/authorblues]authorblues[/url]
- 5) [url=/user/Yoshipro101]Yoshipro101[/url]
- 6) [url=/user/i_o_l]i_o_l[/url]
- 6) [url=/user/Jcool114]Jcool114[/url]
- 8) [url=/user/360Chrism]360Chrism[/url]
- 8) [url=/user/Barnowl]Barnowl[/url]
- 10) [url=/user/Racingmonster]Racingmonster[/url]
- Notable mentions:
- - This confirms that speedrunning is officially Jumpyluff's and Dugongue's job.
- I'll come up with more notable mentions soon™
- [/section]
- [section=Game Statistics]
- List of all the games on the site by their activity (as of 2017-02-03):
- https://docs.google.com/spreadsheets/d/1ZHWWjAIlkQyw6QrIG3xbLIquDHr1Qyals9WRuz_Lirg/edit?usp=sharing
- The larger the number, the more active a game is. You can sort the columns by hovering above the headers and clicking the arrow. Here's a quick slice of it:
- 1) [url=/re7]Resident Evil 7: Biohazard[/url]
- 2) [url=/sm64]Super Mario 64[/url]
- 3) [url=/Refunct]Refunct[/url]
- 4) [url=/smw]Super Mario World[/url]
- 5) [url=/undertale]Undertale[/url]
- 6) [url=/alttp]The Legend of Zelda: A Link to the Past[/url]
- 7) [url=/sms]Super Mario Sunshine[/url]
- 8) [url=/oot]The Legend of Zelda: Ocarina of Time[/url]
- 9) [url=/khbbs02]Kingdom Hearts Birth by Sleep 0.2: A Fragmentary Passage[/url]
- 10) [url=/supermetroid]Super Metroid[/url]
- 11) [url=/smb1]Super Mario Bros.[/url]
- 12) [url=/ff4]Final Fantasy IV[/url]
- 13) [url=/bfbb]SpongeBob SquarePants: Battle for Bikini Bottom[/url]
- 14) [url=/Destiny]Destiny[/url]
- 15) [url=/mk8]Mario Kart 8[/url]
- This sheet includes more columns than the last sheet I had because of the addition of the game stats page. The main activity value being used, player activity, is based only on the number of players running the game and is different from what was used last time. The old one is the run activity column.
- There's a 'trending' column for what was trending at the time I pulled the stats (which isn't too long ago). The lower the number, the harder it's trending. I'm pretty sure RE7 would be #1 now.
- [/section]
- [section=Leaderboard Statistics]
- This one didn't take long since the base of it was used for the games query. Here's a list of all the leaderboards (with at least one run) on the site by their activity (as of 2017-02-03):
- https://docs.google.com/spreadsheets/d/1jZclEEQSHH6Cs8-cjodlfGqB-Hgo3aMYn9QLhA-wLFY/edit?usp=sharing
- The top ones are similar to the games sheet:
- 1) [url=https://www.speedrun.com/Refunct#Any]Refunct - Any% {No NGG}[/url]
- 2) [url=https://www.speedrun.com/re7#Any]Resident Evil 7: Biohazard - Any% {PC; Easy; New Game+}[/url]
- 3) [url=https://www.speedrun.com/re7#Any]Resident Evil 7: Biohazard - Any% {Console; Easy; New Game+}[/url]
- 4) [url=https://www.speedrun.com/ff4#Paladin_SNES]Final Fantasy IV - Paladin SNES[/url]
- 5) [url=https://www.speedrun.com/khbbs02#Any]Kingdom Hearts Birth by Sleep 0.2: A Fragmentary Passage - Any% {Beginner}[/url]
- 6) [url=https://www.speedrun.com/sms#Any]Super Mario Sunshine - Any% {Normal}[/url]
- 7) [url=https://www.speedrun.com/smb1#Any]Super Mario Bros. - Any%[/url]
- 8) [url=https://www.speedrun.com/smw#11_Exit]Super Mario World - 11 Exit[/url]
- 9) [url=https://www.speedrun.com/undertale#Neutral]Undertale - Neutral[/url]
- 10) [url=https://www.speedrun.com/sm64#16_Star]Super Mario 64 - 16 Star {EMU}[/url]
- 11) [url=https://www.speedrun.com/supermetroid#Any]Super Metroid - Any%[/url]
- 12) [url=https://www.speedrun.com/supermetroid#100]Super Metroid - 100%[/url]
- 13) [url=https://www.speedrun.com/bfbb#Any]SpongeBob SquarePants: Battle for Bikini Bottom - Any%[/url] <-- Could someone tell me why?
- 14) [url=https://www.speedrun.com/sm64#70_Star]Super Mario 64 - 70 Star {N64}[/url]
- 15) [url=https://www.speedrun.com/alttp#No_Major_Glitches]The Legend of Zelda: A Link to the Past - No Major Glitches {Any%}[/url]
- Things like views aren't included as that's not provided by the API.
- [/section]
- [section=Miscellaneous Statistics]
- • [url=https://docs.google.com/spreadsheets/d/1--gnZOsIWEbh4GtxZdIq1FVvw7CuHFkjl1m5zA6F3bk/edit?usp=sharing]Moderator Activity[/url] - Mods with the most number of verified runs (and non-self approved runs).
- [/section]
- By the way, if there's anything in particular anyone would like a sheet of, you're welcome to make a request~~
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement