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]
- [url]https://docs.google.com/spreadsheets/d/1A33x_0cNfLVB4sU8C-0TG7T72MePPYy-v9q18oesy8c/edit?usp=sharing[/url]
- 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])^8)[/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])^8[/u].
- [/section]
- [section=Top Users]
- Subjectively, these are the top 15 speedrunners on the site based on the significance of all their records. See comments above for the formula:
- 1) [url=/user/Vallu]Vallu[/url] -- Has a lot of really good positions on the popular Super Mario games, among a few others
- 2) [url=/user/TGH]TGH[/url] -- The God-Emperor of Undertale, a popular speedgame, having WR on nearly every leaderboard
- 3) [url=/user/Levaten]Levaten[/url] -- 2nd in SMS Any% and 1st in two other categories of it
- 4) [url=/user/GreenDeathFlavor]GreenDeathFlavor[/url] -- Top records in Super Mario World, among a few others
- 5) [url=/user/Torje]Torje[/url] -- OoT Any% WR holder, the leaderboard with the most players
- 6) [url=/user/SSBMstuff]SSBMstuff[/url] -- Arguably the best Spyro player for the first three games
- 7) [url=/user/Biinny]Biinny[/url] -- He's Biinny
- 8) [url=/user/Xiah]Xiah[/url] -- SM64 16 Star WR holder, among a few others
- 9) [url=/user/nindiddeh]nindiddeh[/url] -- SMS Any% WR holder, and top 3 in the two main SM3DW categories
- 10) [url=/user/darbian]darbian[/url] -- SMB Any% WR holder, with other notable records
- 11) [url=/user/Marco]Marco[/url] -- 2nd in OoT MST and 3rd in both All Dungeons and No IM/WW
- 12) [url=/user/puncayshun]puncayshun[/url] -- 2nd in SM64 120 Star (N64) and 70 Star (Emu) with a few others
- 13) バトラ (Batora) -- Top 4 in SM64 16, 70, and 120 stars. Not registered on the site.
- 14) [url=/user/jodenstone]jodenstone[/url] -- 3rd in OoT Any%, 4th in MST, and 6th in 100%
- 15) [url=/user/zoast]zoast[/url] -- 2nd place in nearly every Super Metroid category
- (Because of exploitation, this has been limited to full-game categories)
- For individuals with a #1 position (followed by #2):
- • Game Count ------------------------------- [url=/user/Dugongue]Dugongue[/url] @ 254 ---------------- [url=/user/Jumpyluff]Jumpyluff[/url] @ 194
- • Game Count (with a full game run) ---- [url=/user/Dugongue]Dugongue[/url] @ 201 ---------------- [url=/user/Jumpyluff]Jumpyluff[/url] @ 146
- • Leaderboard Count ----------------------- [url=/user/Racingmonster]Racingmonster[/url] @ 1,185 ------ [url=/user/Dugongue]Dugongue[/url] @ 453
- • Full Game Leaderboard Count --------- [url=/user/Dugongue]Dugongue[/url] @ 251 ----------------- [url=/user/Jumpyluff]Jumpyluff[/url] @ 224
- • Run Count ---------------------------------- [url=/user/Racingmonster]Racingmonster[/url] @ 1,420 -------- [url=/user/Nordicboa]Nordicboa[/url] @ 832
- • Full Game Run Count -------------------- [url=/user/Cyberdemon531]Cyberdemon531[/url] @ 355 --------- [url=/user/Jumpyluff]Jumpyluff[/url] @ 299
- • Run Activity --------------------------------- [url=/user/MannedTooth]MannedTooth[/url] @ 110.03 ---------- [url=/user/superlinkgod]superlinkgod[/url] @ 96.25
- • Full Game Run Activity ------------------- [url=/user/katze789]katze789[/url] @ 22.76 ---------------- [url=/user/BlaGe]BlaGe[/url] @ 17.22
- • Activity --------------------------------------- [url=/user/MannedTooth]MannedTooth[/url] @ 115.44 -------- [url=/user/superlinkgod]superlinkgod[/url] @ 111.26
- • Full Game Activity ------------------------- [url=/user/katze789]katze789[/url] @ 35.93 --------------- [url=/user/P4ntz]P4ntz[/url] @ 26.75
- • World Records Held ---------------------- [url=/user/Racingmonster]Racingmonster[/url] @ 683 ---------- [url=/user/MannedTooth]MannedTooth[/url] @ 348
- • Full Game World Record Held ---------- [url=/user/werster]werster[/url] @ 64 --------------------- [url=/user/RPGodfather]RPGodfather[/url] @ 58
- • Top 3 Records Held ----------------------- [url=/user/Racingmonster]Racingmonster[/url] @ 1,075 ------- [url=/user/MannedTooth]MannedTooth[/url] @ 358
- • Full Game Top 3 Records Held --------- [url=/user/Dugongue]Dugongue[/url] @ 134 --------------- [url=/user/authorblues]authorblues[/url] @ 93
- • Sum of Weighted Records --------------- [url=/user/Racingmonster]Racingmonster[/url] @ 1480.08 --- [url=/user/Vallu]Vallu[/url] @ 1031.89
- • Sum of Weighted Full Game Records - List above
- • Best Weighted Record -------------------- [url=/user/Torje]Torje[/url] @ 539.14 ([url=/oot#Any]OoT Any%[/url]) - [url=/user/nindiddeh]nindiddeh[/url] @ 463.57 ([url=/sms#Any]SMS Any%[/url])
- The best Jack of All Trades (comparing everyone's worst rank) are:
- 1) [url=/user/Pull]Pull[/url] (#222)
- 2) [url=/user/Vallu]Vallu[/url] (#242)
- 3) [url=/user/Konasumi]Konasumi[/url] (#442)
- 4) [url=/user/Mattmatt10111]Mattmatt10111[/url] (#449)
- 4) [url=/user/SigotuSM64]SigotuSM64[/url] (#449)
- 6) [url=/user/Sonicshadowsilver2]Sonicshadowsilver2[/url] (#468)
- 7) [url=/user/i_o_l]i_o_l[/url] (#470)
- 7) [url=/user/ethmar]ethmar[/url] (#470)
- 9) [url=/user/Nim]Nim[/url] (#512)
- 10) [url=/user/Halodude]Halodude[/url] (#524)
- And for average:
- 1) [url=/user/Jumpyluff]Jumpyluff[/url]
- 2) [url=/user/werster]werster[/url]
- 3) [url=/user/authorblues]authorblues[/url]
- 4) [url=/user/RPGodfather]RPGodfather[/url]
- 5) [url=/user/Cyberdemon531]Cyberdemon531[/url]
- 6) [url=/user/i_o_l]i_o_l[/url]
- 7) [url=/user/Jcool114]Jcool114[/url]
- 8) [url=/user/Yoshipro101]Yoshipro101[/url]
- 9) [url=/user/Racingmonster]Racingmonster[/url]
- 10) [url=/user/Vallu]Vallu[/url]
- Notable mentions:
- - This confirms that speedrunning is officially Jumpyluff's and Dugongue's job.
- - No seriously, since last month Dugongue has ran OVER 30 GAMES. He must have caught wind of this thread or something.
- [/section]
- [section=Game Statistics]
- List of all the games on the site by their activity (as of 2017-02-03):
- [s]https://docs.google.com/spreadsheets/d/1ZHWWjAIlkQyw6QrIG3xbLIquDHr1Qyals9WRuz_Lirg/edit?usp=sharing[/s]
- 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=/smw]Super Mario World[/url]
- 4) [url=/cp]Club Penguin[/url] -- Bad meme
- 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=/smb1]Super Mario Bros.[/url]
- 10) [url=/Destiny]Destiny[/url]
- 11) [url=/supermetroid]Super Metroid[/url]
- 12) [url=/Refunct]Refunct[/url]
- 13) [url=/ori_de]Ori and the Blind Forest Definitive Edition[/url]
- 14) [url=/lm]Luigi's Mansion[/url]
- 15) [url=/khbbs02]Kingdom Hearts Birth by Sleep 0.2: A Fragmentary Passage[/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.
- [/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):
- [s]https://docs.google.com/spreadsheets/d/1jZclEEQSHH6Cs8-cjodlfGqB-Hgo3aMYn9QLhA-wLFY/edit?usp=sharing[/s]
- The top ones are similar to the games sheet:
- 1) [url=/re7#Any]Resident Evil 7: Biohazard - Any% {PC; Easy; New Game+}[/url]
- 2) [url=/re7#Any]Resident Evil 7: Biohazard - Any% {Console; Easy; New Game+}[/url]
- 3) [url=/cp#Banned]Club Penguin - Banned%[/url]
- 4) [url=/Refunct#Any]Refunct - Any% {No NGG}[/url]
- 5) [url=/sms#Any]Super Mario Sunshine - Any% {Normal}[/url]
- 6) [url=/smb1#Any]Super Mario Bros. - Any%[/url]
- 7) [url=/smw#11_Exit]Super Mario World - 11 Exit[/url]
- 8) [url=/ori_de#All_Skills_no_OOB_]Ori and the Blind Forest Definitive Edition - All Skills no OOB no TA[/url]
- 9) [url=/ff4#Paladin_SNES]Final Fantasy IV - Paladin SNES[/url]
- 10) [url=/supermetroid#Any]Super Metroid - Any%[/url]
- 11) [url=/khbbs02#Any]Kingdom Hearts Birth by Sleep 0.2: A Fragmentary Passage - Any% {Beginner}[/url]
- 12) [url=/sm64#16_Star]Super Mario 64 - 16 Star {EMU}[/url]
- 13) [url=/alttp#No_Major_Glitches]The Legend of Zelda: A Link to the Past - No Major Glitches {Any%}[/url]
- 14) [url=/lm#Any_No_OoB]Luigi's Mansion - Any% (No OoB)[/url]
- 15) [url=/sm64#16_Star]Super Mario 64 - 16 Star {N64}[/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/1u2CW1U42TnX1je16BLbja9VQPYhOV_bhRPEK9Cuy7Hc/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