Bitcoin Forum

Other => Meta => Topic started by: mediaBuzz on March 13, 2020, 12:08:26 PM



Title: [TOP20] Most Merited Ranking History
Post by: mediaBuzz on March 13, 2020, 12:08:26 PM
gmaxwell kept his position so stably. I wonder if he has some daily schedule for the forum :D

https://i.imgur.com/4J8W5sF.gif

Original work: https://imgur.com/PLyVypa


Title: Re: [TOP20] Most Merited Ranking History
Post by: YOSHIE on March 13, 2020, 01:21:28 PM
What is that...! like the corona virus that attacks, who are looking for prey.

I've never seen it move like an earthworm.
Is Merit running ...!


Title: Re: [TOP20] Most Merited Ranking History
Post by: mole0815 on March 13, 2020, 01:33:34 PM
wow what a cool thing 8)
how exactly does that work?
can you do that with a userlist we provide you with?
or e.g. with all users who post in a special subforum?

 :o :o


Title: Re: [TOP20] Most Merited Ranking History
Post by: cabalism13 on March 13, 2020, 02:10:46 PM
Its been a while I have seen a koving image like this. So I'm pretty amaze at your thread here. You really earned a praise mate :) I wish I can see something new again.

Just a thing: I can't see the usernames written on it and when I play it on imgur it doesn't work LoL.


Title: Re: [TOP20] Most Merited Ranking History
Post by: ChuckBuck on March 13, 2020, 03:49:11 PM
https://i.imgur.com/4J8W5sF.gif
Original work: https://imgur.com/PLyVypa
I think you should compress it with a bigger frame, this frame is too small and I can't even see the names of the users there. Can you try another one? I know you because you made one for LoyceV on his 5th birthday, you have great experience for this field :D Reveal: I will give you 2 merit if you can make one more clear (not much, but worthy)  ;)
how exactly does that work?
can you do that with a userlist we provide you with?
or e.g. with all users who post in a special subforum?
Not sure about my answer, but this is like compressing each user's web history or each section/part. Perhaps it can only be done for individual users or fixed sections on the board  ::)


Title: Re: [TOP20] Most Merited Ranking History
Post by: LoyceV on March 13, 2020, 05:31:11 PM
I like it, but it's wrong: I wasn't always #2 when it comes to Merit. Can you create a new one, but with all users included, so the users in the Top 20 change over time?
If needed, I might be able to help extract the data from the full Merit history (http://loyce.club/Merit/merit.all.txt). I think it would be cool to see when new users join the Top 20.

I think you should compress it with a bigger frame, this frame is too small and I can't even see the names of the users there.
I can read it after clicking this:
Original work: https://imgur.com/PLyVypa
The full resolution is probably too large for the forum's image proxy.


Title: Re: [TOP20] Most Merited Ranking History
Post by: DdmrDdmr on March 13, 2020, 06:47:27 PM
Edited: With Tableau you can achieve this kind of results, and the new version has made it easier. It works for profiles with >= 100 earned merits, which allows for it work properly now.

The race takes place on the last tab of the Merit Dashboard:Merit Race (https://public.tableau.com/profile/ddmrddmr#!/vizhome/BitcointalkMeritDashboard/ReceivedMeritRace)

Usage:
-   Select the users on the left side "Received Merit Race" tab (top 22 are already selected) or type them one by one into the "To User Name" and press enter.
-   Set the Date slider to Jan 2018 (if it is not already there)
-   Press the play button (on the right hand side, under the date slider).

Each frame holds for a second or so, and represents a month's worth of data. It can be set to daily, but it gets pretty long to watch.


Title: Re: [TOP20] Most Merited Ranking History
Post by: ChuckBuck on March 14, 2020, 12:49:29 AM
I like it, but it's wrong
Well, after careful review by the original. I realize this data is wrong  ::) theymos is the only one whose merit exceeds 6000, you have a total of 5947 merit, but he makes it beyond 6000. Basically, the data he gives is not accurate.
so the users in the Top 20 change over time?
Is there enough space to show 20 users at the same time? Maybe the name will be so small and blurry we can't see it  ::) I'm not sure, but it would be great if he could make another. Hope he will agree


Title: Re: [TOP20] Most Merited Ranking History
Post by: mediaBuzz on March 14, 2020, 05:53:47 AM
wow what a cool thing 8)
how exactly does that work?
can you do that with a userlist we provide you with?
or e.g. with all users who post in a special subforum?

 :o :o

I'm glad that you like it! Of course, I can. (with better accuracy)



https://i.imgur.com/4J8W5sF.gif
Original work: https://imgur.com/PLyVypa
I think you should compress it with a bigger frame, this frame is too small and I can't even see the names of the users there. Can you try another one? I know you because you made one for LoyceV on his 5th birthday, you have great experience for this field :D Reveal: I will give you 2 merit if you can make one more clear (not much, but worthy)  ;)
how exactly does that work?
can you do that with a userlist we provide you with?
or e.g. with all users who post in a special subforum?
Not sure about my answer, but this is like compressing each user's web history or each section/part. Perhaps it can only be done for individual users or fixed sections on the board  ::)
Yes, I'll gladly do another one. Just ping me the details here or in pm. Thanks much for your interest!



I like it, but it's wrong: I wasn't always #2 when it comes to Merit. Can you create a new one, but with all users included, so the users in the Top 20 change over time?
If needed, I might be able to help extract the data from the full Merit history (http://loyce.club/Merit/merit.all.txt). I think it would be cool to see when new users join the Top 20.

I think you should compress it with a bigger frame, this frame is too small and I can't even see the names of the users there.
I can read it after clicking this:
Original work: https://imgur.com/PLyVypa
The full resolution is probably too large for the forum's image proxy.
Here, in this table, I took the current top 20 users and the table is about their merit receiving history. (so among these 20 you always were #2) However, top20 changing over time is also possible to make but is just tons of work:/



Well, after careful review by the original. I realize this data is wrong  ::) theymos is the only one whose merit exceeds 6000, you have a total of 5947 merit, but he makes it beyond 6000. Basically, the data he gives is not accurate.
The table includes airdropped merits as well



Also, the background is not a screenshot, it is all drawn.


Title: Re: [TOP20] Most Merited Ranking History
Post by: ChuckBuck on March 14, 2020, 06:12:58 AM
Ah shit  :D here you go with 5 posts to answer everybody  ::) I think you should change the way you write. Use one article to answer all here, you can quote each article, then remove the unnecessary parts, put them together and reply with a simple post, If it's too long, you can use two, but one is best  ;) in the same way that LoyceV and others did

Here, in this table, I took the current top 20 users and the table is about their merit receiving history. (so among these 20 you always were #2) However, top20 changing over time is also possible to make but is just tons of work:/
You will receive the amount of merit worth the time you spend. We all know how important merit is  ;)
includes airdropped merits as well
Does that mean the number of merit has been sent? I didn't think of that because your title is the most merited, not SENT


Title: Re: [TOP20] Most Merited Ranking History
Post by: mediaBuzz on March 14, 2020, 06:31:52 AM
Ah shit  :D here you go with 5 posts to answer everybody  ::) I think you should change the way you write. Use one article to answer all here, you can quote each article, then remove the unnecessary parts, put them together and reply with a simple post, If it's too long, you can use two, but one is best  ;) in the same way that LoyceV and others did
Damn, I didn't think about that. Thanks, for the advice :)

Does that mean the number of merit has been sent? I didn't think of that because your title is the most merited, not SENT
Just figured out the point. Yes, Loycev's bar needs to be reduced.





Title: Re: [TOP20] Most Merited Ranking History
Post by: LoyceV on March 14, 2020, 09:39:48 AM
Here, in this table, I took the current top 20 users and the table is about their merit receiving history. (so among these 20 you always were #2)
Did you include airdropped Merit too? Vod for instance is no longer in the Top-20 (https://bitcointalk.org/index.php?action=merit;stats=topusersat), while there was a time Vod earned more Merit than me.
I'm still working on a graph (https://bitcointalk.org/index.php?topic=5099167.0) of the current Top-20 Merit earners, but it's currently killing my spreadsheet.

Quote
However, top20 changing over time is also possible to make but is just tons of work:/
But it'll be so nice to see! The animation should probably be a bit slower to be able to absorb all data in it.


Title: Re: [TOP20] Most Merited Ranking History
Post by: mediaBuzz on March 14, 2020, 10:31:41 AM
Did you include airdropped Merit too? Vod for instance is no longer in the Top-20 (https://bitcointalk.org/index.php?action=merit;stats=topusersat), while there was a time Vod earned more Merit than me.
Yes, airdropped merits are also included.

But it'll be so nice to see! The animation should probably be a bit slower to be able to absorb all data in it.
Sure :) If the community finds these graphs useful, I'll make another one with stated corrections.


Title: Re: [TOP20] Most Merited Ranking History
Post by: LoyceV on March 14, 2020, 11:45:23 AM
If the community finds these graphs useful, I'll make another one with stated corrections.
What do you need for this? A daily Top 20 with usernames and their Merit amount? Or maybe more convenient: for each position in the Top 20, the daily username on that position and their Merit amount?

This is the current Top 20:


Title: Re: [TOP20] Most Merited Ranking History
Post by: mediaBuzz on March 14, 2020, 12:15:37 PM
What do you need for this? A daily Top 20 with usernames and their Merit amount? Or maybe more convenient: for each position in the Top 20, the daily username on that position and their Merit amount?
Username list for each position of daily top 20 would make it far easier. A while ago I tried to find this data :D https://bitcointalk.org/index.php?topic=5231097.msg53982002#msg53982002. DdmrDdmr's dashboard is super useful for that but I had to extract every single data manually from his dash.


Title: Re: [TOP20] Most Merited Ranking History
Post by: bL4nkcode on March 15, 2020, 11:14:42 AM
Satoshi is the only non active user who will be always one of the top merited users. Expect no less from the founder.

Anyways, great work, much better for more accurate stat.


Title: Re: [TOP20] Most Merited Ranking History
Post by: LoyceV on March 15, 2020, 11:43:32 AM
Satoshi is the only non active user who will be always one of the top merited users. Expect no less from the founder.
Based on my graph (https://bitcointalk.org/index.php?topic=5232559.msg54026757#msg54026757), I expect satoshi to be removed from the Top 20 in about half a year.


Title: Re: [TOP20] Most Merited Ranking History
Post by: dragonvslinux on March 15, 2020, 12:17:53 PM
Satoshi is the only non active user who will be always one of the top merited users. Expect no less from the founder.
Based on my graph (https://bitcointalk.org/index.php?topic=5232559.msg54026757#msg54026757), I expect satoshi to be removed from the Top 20 in about half a year.

I believe that's what the curves would tell you, though we've also never seen Satoshi's posts merited in a parabolic bullrun with lots of new users entering the space.
Just food for thought, though you're probably right.


Title: Re: [TOP20] Most Merited Ranking History
Post by: nutildah on March 15, 2020, 12:44:46 PM

Ah, its times like this that I wish I weren't colorblind.

I believe that's what the curves would tell you, though we've also never seen Satoshi's posts merited in a parabolic bullrun with lots of new users entering the space.

Except new users start with zero merit and tend to accrue sendable merits pretty slowly.

It is interesting that satoshi was one of two users to immediately gain several hundred merits. The other user being the man who invented the merit system.


Title: Re: [TOP20] Most Merited Ranking History
Post by: LoyceV on March 15, 2020, 01:54:20 PM
Ah, its times like this that I wish I weren't colorblind.
That's why the names are in the same order as the right side of the graph.

Quote
It is interesting that satoshi was one of two users to immediately gain several hundred merits. The other user being the man who invented the merit system.
There were more users with "initial fame" who quickly gained a large amount of Merit. I'd say it's interesting that none of them are in the Top 20 anymore.


Title: Re: [TOP20] Most Merited Ranking History
Post by: dragonvslinux on March 15, 2020, 02:01:19 PM

Ah, its times like this that I wish I weren't colorblind.

I believe that's what the curves would tell you, though we've also never seen Satoshi's posts merited in a parabolic bullrun with lots of new users entering the space.

Except new users start with zero merit and tend to accrue sendable merits pretty slowly.

Point well made, I rest my case :D


Title: Re: [TOP20] Most Merited Ranking History
Post by: mediaBuzz on March 16, 2020, 07:03:09 AM
Or maybe more convenient: for each position in the Top 20, the daily username on that position and their Merit amount?
So can you please help with extracting this data somehow or point me to someone who may help?



Title: Re: [TOP20] Most Merited Ranking History
Post by: LoyceV on March 16, 2020, 08:04:31 AM
Or maybe more convenient: for each position in the Top 20, the daily username on that position and their Merit amount?
So can you please help with extracting this data somehow or point me to someone who may help?
All the data you need is in merit.all.txt (http://loyce.club/Merit/merit.all.txt). Unfortunately, I won't have time any time soon, we're in work from home lockdown, with the kids at home to distract continuously.


Title: Re: [TOP20] Most Merited Ranking History
Post by: DdmrDdmr on March 16, 2020, 11:54:24 AM
<…> So can you please help with extracting this data somehow or point me to someone who may help?
If I haven’t messed anything up, the following file contains the info for the top 20 merited profiles, broken down by days (up to last friday): https://docs.google.com/spreadsheets/d/1v8CT6AvjckH6SFYiRhEB8xIItw7lg65Q2O_S1Bg2uBw/edit?usp=sharing

It contains the following information: UserId, Name, nMeritsAcc, nPosition, DateOfRank.

Where:
  nMeritsAcc is the sum of all merits earned by the profile up to DateOfRank
  nPosition is the ranking position of each specific date (DateOfRank).
  DateOfRank is the date up to which the calculation is performed. If goes up to midnight (UTC).

The data is only for the currently top 20, not the historical top 20.

You can also play around with the filters to see your position each day. For example, If I filter by DdmrDdmr, I was P2 on the 19th and 20th of January 2019.

Note: This info is on the Merit Dashboard (last tab – Merit Race) for all merited profiles with >= 100 earned merits (in bar line race format - no shifting around though).


Title: Re: [TOP20] Most Merited Ranking History
Post by: mediaBuzz on March 16, 2020, 02:56:01 PM
<…> So can you please help with extracting this data somehow or point me to someone who may help?
If I haven’t messed anything up, the following file contains the info for the top 20 merited profiles, broken down by days (up to last friday): https://docs.google.com/spreadsheets/d/1v8CT6AvjckH6SFYiRhEB8xIItw7lg65Q2O_S1Bg2uBw/edit?usp=sharing

It contains the following information: UserId, Name, nMeritsAcc, nPosition, DateOfRank.

Where:
  nMeritsAcc is the sum of all merits earned by the profile up to DateOfRank
  nPosition is the ranking position of each specific date (DateOfRank).
  DateOfRank is the date up to which the calculation is performed. If goes up to midnight (UTC).

The data is only for the currently top 20, not the historical top 20.

You can also play around with the filters to see your position each day. For example, If I filter by DdmrDdmr, I was P2 on the 19th and 20th of January 2019.

Note: This info is on the Merit Dashboard (last tab – Merit Race) for all merited profiles with >= 100 earned merits (in bar line race format - no shifting around though).
Thank you for the sheet. It is exactly what I needed for the last graph and I had to take this data manually. I don't think there is any point in making it over with more accuracy, I would rather make a new one which will show the historical top 20.