Unavoidable Tournament: Nth best score.

[pier4r]

2018-02-12
2018-02-19

(20th best score) (playerid in the data) (playername if I got it)
2082 118911 mrchris
2056 219108 milkhunter
2034 278755 mumpsimus
1989 364986 Hairy Phil
1987 357645 aoi
1949 371487 Joni ja pojat
1902 372162 sdhj
1897 371468 acho (Tortuga)

[pier4r]

2018-02-05
2018-02-11

(20th best score) (playerid in the data) (playername if I got it)
2112 118911 mrchris
2079 219108 milkhunter
2002 278755 mumpsimus
1894 371487 Joni ja pojat
1875 364986 Hairy Phil

[pier4r]

2018-06-09
2018-06-15

(20th best score) (playerid in the data) (playername if I got it)
2825 milkhunter
2714 elvenmonky2
2538 mumpsimus
2388 tortuga
2298 bockwurst
2248 pier4r nvidia k1
2246 aoi
2198 ritterrunkel
1932 mcompany

[pier4r]

2018-06-16
2018-06-22

(20th best score) (playerid in the data) (playername if I got it)
2908 milkhunter
2672 elvenmonkey2
2541 mumpsimus
2337 bockwurst
2336 tortuga
2274 ritterrunkel
2250 aoi
2220 pier4r nvidia k1
2169 chrysophylax
2143 gtresd
2049 elvenmonkey

[pier4r]

2018-06-23
2018-06-29

(20th best score) (playerid in the data) (playername if I got it)
2953 milkhunter
2571 mumpsimus
2446 bockwurst
2326 ritterunkel
2301 aoi
2284 tortuga
2179 chrysophylax
2120 chilio6
1990 irrbertpc
1919 tomcat_wrk

[pier4r]

2018-06-30
2018-07-06

(20th best score) (playerid in the data) (playername if I got it)
2976 milkhunter
2627 bockwurst
2521 mumpsimus
2468 ritterunkel
2460 mrchris
2305 aoi
2173 gtresd
2121 chrysophylax
2106 chilio6
2081 irrbertpc
2039 viva2
1959 tomcat_wrk
1928 human_influence
1897 optrode

[pier4r]

2018-07-07
2018-07-13

(20th best score) (playerid in the data) (playername if I got it)
2652 bockwurst
2652 elvenmonky2
2549 mumpsimus
2461 ritterrunkel
2439 mrchris
2388 tortuga
2280 aoi
2262 gtresd
2131 dh
2059 irrbertpc
1980 tomcat_wrk
1936 glados_beta
1924 viva2
1912 geht

[pier4r]

2018-07-14
2018-07-20

(20th best score) (playerid in the data) (playername if I got it)
2970 milkhunter
2723 bockwurst
2620 elvenmonky2
2613 mumpsimus
2537 mrchris
2492 ritterunkel
2413 tortuga
2281 gtresd
2266 aoi
2262 dh!
2082 chilio6
2038 irrbertpc
2025 viva2
1947 tomcat_wrk

[ElvenMonk]

I've built Power BI project, that uses same dumps to calculate 20th best score. Somehow results differ from those posted here. I've added last game id and resolution time for each player to make sure, that I'm getting most recent ELO for specified week. Could you please double check your scripts to ensure correct results?

Example for 2018-07-14 -2018-07-20:

Player ID Player Name ELO Games LastGame resolutionTime
219108 Milkhunter 2959 60 1045345 2018-07-19 14:58:27
392426 Bockwurst 2704 211 1046710 2018-07-20 07:08:14
393328 ElvenMonky2 2681 245 1048583 2018-07-20 23:59:42
278755 mumpsimus 2557 1074 1046439 2018-07-20 05:15:52
118911 mrchris 2537 196 1044229 2018-07-19 00:52:18
389367 RitterRunkel 2489 77 1046976 2018-07-20 09:30:56
106836 Tortuga 2364 283 1044066 2018-07-18 22:26:09
384255 gtresd 2280 45 1045878 2018-07-19 20:10:48
251352 DH! 2250 233 1047049 2018-07-20 10:13:57
357645 aoi 2168 74 1047674 2018-07-20 14:57:17
21022 Mcompany 2055 3 1037231 2018-07-14 21:37:00
395262 chilio6 2054 32 1046910 2018-07-20 08:55:13
256857 Chrysophylax 2010 9 1041629 2018-07-17 14:36:51
377728 viva2 1970 215 1048107 2018-07-20 19:31:17
132551 IRRbertPC 1965 764 1048049 2018-07-20 18:54:01
1945 100 1047360 2018-07-20 13:08:02
330822 Vine 1894 124 1041875 2018-07-17 16:17:56

[ElvenMonk]

Ok, I see now, that you calculate best score for period, not the most recent one.

Then again table for 14.07 - 20.07 would look more like:

Player ID ELO Player Name
219108 2987 Milkhunter
392426 2749 Bockwurst
393328 2681 ElvenMonky2
278755 2646 mumpsimus
118911 2567 mrchris
389367 2511 RitterRunkel
106836 2430 Tortuga
384255 2316 gtresd
357645 2299 aoi
251352 2280 DH!
395262 2124 chilio6
132551 2071 IRRbertPC
377728 2051 viva2
400232 1973 `oMBre
278271 1968
392068 1950 geth

[pier4r]

hmm not sure if you use UTC times. I am pretty sure my results are correct (some players may be wrong for a couple of scores, but not all of them. Unlikely all of them)

Do you include ghosts as well?

Anyway the script are in the first page, I use mostly the awk based script (plus stats page). I have the feeling you get either the "19th/18th" score or you get the score of the deployment, not the result score of the match. (that is, I may deploy with 2180, but I can end up having 2170 after the match)

[pier4r]

2018-07-21
2018-07-27

(20th best score) (playerid in the data) (playername if I got it)
2950 milkhunter
2788 bockwurst
2732 elvenmonky2
2526 mumpsimus
2483 ritterrunkel
2406 tortuga
2316 dh!
2288 gtresd
2253 aoi
2173 viva2
2117 chilio6
2073 chrysophylax
1979 irrbertpc
1900 rummaker

[pier4r]

Elvenmonk for info, a sample of the data I use: https://pastebin.com/DFcLEhnL and then I run on it the awk snippet in the first page. The data I use can be copied from the stats page, checking the "latest matches" of the player.

If you don't provide the methodology of your checks I cannot help. Things should be reproducible.

[ElvenMonk]

Ok, I fixed my scripts to calculate 20th best score for all players. See e.g. last week

You can download and use Power BI project, if you like:
https://drive.google.com/file/d/17CjHzFyONeaXOeGLGe0pyInoheEcUoSI/view?usp=sharing

I have not adjusted it to work correctly with old format of dumps, so data is only available since 28th of May.

It looks like some player names are missing from dumps and I don't know how to restore them, if not manually.

[pier4r]

unfortunately the dumps are "the last 10k entries" so yes some data is missing when a player started the game but started the multiplayer way later.

And yes now your script work. Even if I get powerBI the point is to use the same script for comparisons.

[pier4r]

2018-07-28
2018-08-03

(20th best score) (playerid in the data) (playername if I got it)
2826 bockwurst
2713 elvenmonky2
2575 mumpsimus
2478 ritterunkel
2417 tortuga
2379 dh!
2368 sollniss
2305 gtresd
2240 aoi
2146 chrysophylax
2146 irrbertpc (n1)
2098 viva2
2095 chilio6
2090 mcompany
2008 romcat_wrk
1994 rummaker
1990 TanahAirKu

n1: note that through the stat page I didn't collect all the player's games in this week due to the recent change to 500 latest matches, before 1000 were listed and was very unlikely to miss player matches.

[ElvenMonk]

Here are results by my script. Still few differences and I can't find why. Perhars, if different dumps contain different data for same matches, my script can take ealiest version, not the latest.

[pier4r]

Elvenmonk would be great to upload your results here (so they are visibile) or maybe making a dedicated page on the wiki (actually I may do it too..). google drive is nice but it is not immediate to check, aside personal usage.

Now I try to see the differences...

2368 sollniss, right. The data from me picked 2018-07-29 and 2018-05-29 (that is 2 months ago).
This is the nice part of having multiple checks, it is healthier.

gtresd I don't see the problem on my side. Here is my data. https://pastebin.com/ihK9kS9s

chilio 6 wrong source for me, fixed.

[ElvenMonk]

I see 1078632 in your data, and it seems you use player commitment time instead of resolution time.Is that correct?

From source data:
"1078632 Ranked 27 2018-08-03 23:59:55 2018-08-04 00:00:38 1 372162 384255 1974 2303 2018-08-03 23:59:55 2018-08-03 23:59:56 2018-08-03 23:59:55 2018-08-03 23:59:58 Y N 0.1308031345 0 -3"

[pier4r]

Interesting, I always supposed that the stats page showed the resolution time. But well since the ghosts are there, resolution time is when the client reported the result. commitment time is when both players (a ghost/player and the other player) have committed the match. So I would say that commitment time should work too.