Bitcointalk Merit Dashboard

[DdmrDdmr]

Since were talking (so as to say) about meriting habits today, I’ve added two new sections to our profile summary:

- Received TX: For each number of sMerits received (first column), it displays the % of our total sMerits TX reeived, and the count of sMerits TXs.
- Sent TX: For each number of sMerits sent (first column), it displays the % of our total sMerits TX sent, and the count of sMerits TXs.

i.e. The máx. sMerits I have sent to date per TX is 4. That has happened on 2 occasions, which represents 0,05% of my sent sMerit TXs.

https://public.tableau.com/shared/7DFZBRFR3?:display_count=y&:origin=viz_share_link

As usual, change the UserName (top right) and press enter to see a different profile.

[1713454237]

1713454237

[1713454237]

1713454237

[1713454237]

1713454237

[DdmrDdmr]

Update 10/01/2020:

The dashboard gives you access to anyone’s complete merit history in the TX tab, surpassing the 120 day limit.
Link:  BitcoinTalk Merit Dashboard.  

Updated the Merit Dashboard to reflect the most recent sMerit available data:

Total sMerit:  564.259
Total Txs:      288.275
From Users:    21.541
To Users:        32.351
minDate:       2018-01-24 22:12:21
maxDate:      2020-01-10 02:51:18

Aggregate awarded sMerit for the last complete week (30/12/2019 .. 05/01/2020) is 5.634 which is down 10,16% from the previous week.

Recent: Google Sheet Tabular sumary for all merited accounts (updated weekly):
(user_id, name, datecreated, rank, posts, activity, merit, MeritReceived, startedwith, meritsent, probableInitialRank, url)
https://docs.google.com/spreadsheets/d/1mD6cdsQNJ8dauTL-XLi8I0oDG5WBl0z0NeKzXTByNyw/edit?usp=sharing

There are no new Legendary nor Hero members this week.

[DdmrDdmr]

Update 17/01/2020:

The dashboard gives you access to anyone’s complete merit history in the TX tab, surpassing the 120 day limit.
Link:  BitcoinTalk Merit Dashboard. 

Updated the Merit Dashboard to reflect the most recent sMerit available data:

Total sMerit:  570.065
Total Txs:      291.724
From Users:    21.569
To Users:        32.458
minDate:       2018-01-24 22:12:21
maxDate:      2020-01-17 02:33:31

Aggregate awarded sMerit for the last complete week (06/01/2020 .. 12/01/2020) is 5.600 which is down0,60% from the previous week.

Recent: Google Sheet Tabular sumary for all merited accounts (updated weekly):
(user_id, name, datecreated, rank, posts, activity, merit, MeritReceived, startedwith, meritsent, probableInitialRank, url)
https://docs.google.com/spreadsheets/d/1mD6cdsQNJ8dauTL-XLi8I0oDG5WBl0z0NeKzXTByNyw/edit?usp=sharing

In addition, there are 2 new Legendary members and 2 more Heroes this week:
PHI1618                     -> Legendary from Full Member during Merit System kick-off.
Yatsan                        -> Legendary from Hero Member during Merit System kick-off.

hosseinimr93               -> Hero from Sr. Member during Merit System kick-off.
TalkStar                      -> Hero from Old Era Newbie during Merit System kick-off.

[DdmrDdmr]

Update 24/01/2020:

The dashboard gives you access to anyone’s complete merit history in the TX tab, surpassing the 120 day limit.
Link:  BitcoinTalk Merit Dashboard. 

Updated the Merit Dashboard to reflect the most recent sMerit available data:

Total sMerit:  577.235
Total Txs:      296.072
From Users:    21.616
To Users:        32.570
minDate:       2018-01-24 22:12:21
maxDate:      2020-01-24 02:49:26

Aggregate awarded sMerit for the last complete week (13/01/2020 .. 19/01/2020) is 6.654 which is up 18,82% from the previous week.
Recent: Google Sheet Tabular sumary for all merited accounts (updated weekly):
(user_id, name, datecreated, rank, posts, activity, merit, MeritReceived, startedwith, meritsent, probableInitialRank, url)
https://docs.google.com/spreadsheets/d/1mD6cdsQNJ8dauTL-XLi8I0oDG5WBl0z0NeKzXTByNyw/edit?usp=sharing

In addition, there is 1 new Legendary members and 1 more Heroes this week:
bitserve                     -> Legendary from Sr. Member during Merit System kick-off.
Theb                        -> Hero from Sr. Member during Merit System kick-off.

[DdmrDdmr]

Update 31/01/2020:

The dashboard gives you access to anyone’s complete merit history in the TX tab, surpassing the 120 day limit.
Link:  BitcoinTalk Merit Dashboard. 

Updated the Merit Dashboard to reflect the most recent sMerit available data:

Total sMerit:  584.137
Total Txs:      300.090
From Users:    21.651
To Users:        32.664
minDate:       2018-01-24 22:12:21
maxDate:      2020-01-31 02:51:21

Aggregate awarded sMerit for the last complete week (20/01/2020 .. 26/01/2020) is 6.950 which is up 4,45% from the previous week.

Recent: Google Sheet Tabular sumary for all merited accounts (updated weekly):
(user_id, name, datecreated, rank, posts, activity, merit, MeritReceived, startedwith, meritsent, probableInitialRank, url)
https://docs.google.com/spreadsheets/d/1mD6cdsQNJ8dauTL-XLi8I0oDG5WBl0z0NeKzXTByNyw/edit?usp=sharing

In addition, there are 2 more Heroes this week:
sujonali1819                 -> Hero Member from Sr. Member during Merit System kick-off.
VB1001                        -> Hero from Sr. Member during Merit System kick-off.

[fillippone]

Update 31/01/2020:

<...>

Superfast update this week!

[DdmrDdmr]

<…>

Yep, I had quite a bit of personal stuff to do today, so I shifted things around quite a bit:

Normally, I download the merit.txt file, integrate it, and only then do I retrieve all the profiles and newly merited posts (that all takes more or less 13 to 14 hours of linear time, which increases overtime, in accordance to the increase in merited posts and profiles).

I’ve complicated it a wee bit now, by starting to retrieve on Thursday those profiles that are least likely to change between then and Friday’s Merit.txt file (profiles that have not logged-in over the last six months and did not get merited recently). This leaves less stuff to do in Friday, and I can now not overlap the update with my dinner time … This new approach gives me a bit more flexibility to finish earlier for now.

[DdmrDdmr]

Update 07/02/2020:

The dashboard gives you access to anyone’s complete merit history in the TX tab, surpassing the 120 day limit.
Link:  BitcoinTalk Merit Dashboard. 

Updated the Merit Dashboard to reflect the most recent sMerit available data:

Total sMerit:  590.505
Total Txs:      303.760
From Users:    21.688
To Users:        32.788
minDate:       2018-01-24 22:12:21
maxDate:      2020-02-07 02:47:27

Aggregate awarded sMerit for the last complete week (27/01/2020 .. 02/02/2020) is 6.703 which is down 3,55% from the previous week.

Recent: Google Sheet Tabular sumary for all merited accounts (updated weekly):
(user_id, name, datecreated, rank, posts, activity, merit, MeritReceived, startedwith, meritsent, probableInitialRank, url)
https://docs.google.com/spreadsheets/d/1mD6cdsQNJ8dauTL-XLi8I0oDG5WBl0z0NeKzXTByNyw/edit?usp=sharing

In addition, there are 2 more Legendries and 3 Heroes this week:
krogothmanhattan              -> Legendary from Sr. Member during Merit System kick-off.
TwitchySeal                        -> Legendary from Hero Member during Merit System kick-off.

cryptoaddictchie                 -> Hero Member from Member during Merit System kick-off.
CucakRowo                        -> Hero from New Era Newbie during Merit System kick-off.
ivomm                               -> Hero from Full Member during Merit System kick-off.

[fillippone]

Update 07/02/2020:

<...>

Update 31/01/2020:

<...>

Superfast update this week!

You are becoming increasingly efficient at this!

[DdmrDdmr]

<...> You are becoming increasingly efficient at this!

It depends when I have my lunchbreak (and if the processes go well and so forth) … no lunch yet therefore ...

Note: I prefer this schedule of updates, but I’m not sure how long I’ll be able to keep it up for (intersects the shedule of other stuff).

[fillippone]

Note: I prefer this schedule of updates, but I’m not sure how long I’ll be able to keep it up for (intersects the shedule of other stuff).

Don't worry, we all know running that chiringuito on the Playa de Bolonia is taking precious time away from the forum. You'll be ok.

[hosseinimr93]

Recent: Google Sheet Tabular sumary for all merited accounts (updated weekly):
(user_id, name, datecreated, rank, posts, activity, merit, MeritReceived, startedwith, meritsent, probableInitialRank, url)
https://docs.google.com/spreadsheets/d/1mD6cdsQNJ8dauTL-XLi8I0oDG5WBl0z0NeKzXTByNyw/edit?usp=sharing

There are a few errors in number of merits started with (Column J)
Number of airdropped merit can be only 0, 10, 100, 250, 500 and 1000. But there are some users with other numbers of airdropped merit.

_________________	_________________
Airdropped Merit	Number of Users
_________________	_________________
1	27
2	5
3	2
5	1
101	12
102	2
150	1
251	6
252	2
253	3
501	9
502	3
503	1
504	1
1001	11
1002	7
1003	3
1004	2
_________________	_________________

[DdmrDdmr]

<…>

That does happen in a small set of cases (98 over 32.788 -> 0,3%). I do take that situation into account to derive the "probable initial rank" values (I apply a margin of tolerance for each rank), but the initial airdropped sMerit is calculated as follows:

Profile Merits – sum(received sMerit from TXs) = Initial airdropped Merits.
 
Now what happens is that there is always a time gap between the two data origins:

- sMerit TXs are generated around 3 AM UTC (a bit before).

- Profiles are scraped at a rate on 1 per second, somewhere between Thursday night and Friday morning (until a few weeks ago, it went on until Friday evening).

What happens is that a few (fortunate) profiles are merited between 3AM and the time the profile is scraped. In these cases, the profile will have more merits that the corresponding sum(received sMerit from TXs), and therefore the initial sMerits for these cases can be off on a given week (probably not on the following week).

There are possible solutions to this, such as force values to the nearest logical value, or play around comparing to last week’s Initial airdropped Merits, but for such a small amount of cases it seems pecata minuta really.

[DdmrDdmr]

Update 14/02/2020:

The dashboard gives you access to anyone’s complete merit history in the TX tab, surpassing the 120 day limit.
Link:  BitcoinTalk Merit Dashboard.  

Updated the Merit Dashboard to reflect the most recent sMerit available data:

Total sMerit:  595.992
Total Txs:      306.907
From Users:    21.724
To Users:        32.876
minDate:       2018-01-24 22:12:21
maxDate:      2020-02-14 02:37:50

Aggregate awarded sMerit for the last complete week (03/02/2020 .. 09/02/2020) is 6.059 which is down 9,61% from the previous week.

In addition, there are 2 more Legendries this week:
Blacknavy              -> Legendary from Sr. Member during Merit System kick-off.
Royse777               -> Legendary from Hero Member during Merit System kick-off.

Note: I've just noticed that here are some issues identifying rank-up for Legendary Copper Members and staff. Not sure what I'll do here, since the rank is not on the profile, and is not strictly derivable from merits and activity (activity is a range). This causes that the Dashboard to identify an Old Era Newbie ranked-up to Legendary this week, which is not true. I'll try to resolve it next week.

NEW (with recalculated data as of today):

Added the lists to the Merit Dashboard.  (Last tab, or https://public.tableau.com/shared/J8MWCR5H2?:display_count=y&:origin=viz_share_link). The data included is as of 07/02/2019. I’ve still got to see what update frequency to use for this tab (initially, I’ll try to make it weekly, alongside all other tabs but the one on the number of posts which is always monthly). The screen looks like this:



There are 3 sections on the screen:

a) Who ranked whom – Ranking:

It shows an ordered list of those who have ranked most people on the forum. In order to search within the list, either scroll around, or use the UserFromName filter on the right hand side of the screen (once filtered though, we’ll lose sight of the proper rank position, as it will be limited to a single entry).


b) Who ranked me:

It displays the list of profiles that ranked me up, the date, TX, merits and post. The post name is clickable, and the menu that pops-up lets you go to the post itself on Bitcointalk.


c) Who I ranked:

It displays the list of profiles that I’ve ranked-up, the date, TX, merits and post. The post name is clickable, and the menu that pops-up lets you go to the post itself on Bitcointalk.

You can change the user here in the UserName box (and press enter) in order to change the view to that of another user (applies to both sections "b" and "c" simultaneously).

[DdmrDdmr]

Update 21/02/2020:

The dashboard gives you access to anyone’s complete merit history in the TX tab, surpassing the 120 day limit.
Link:  BitcoinTalk Merit Dashboard. 

Updated the Merit Dashboard to reflect the most recent sMerit available data:

Total sMerit:  603.065
Total Txs:      310.913
From Users:    21.750
To Users:        32.957
minDate:       2018-01-24 22:12:21
maxDate:      2020-02-21 02:41:29

Aggregate awarded sMerit for the last complete week (10/02/2020 .. 16/02/2020) is 5.845 which is down 3,53% from the previous week.

In addition, there are 1 more Legendary and 4 more Heroes this week:
bct_ail                -> Legendary from Sr. Member during Merit System kick-off.
hd49728             -> Hero from Old Era Newbie during Merit System kick-off.
logfiles               -> Hero from New Era Newbie during Merit System kick-off.
Polar91               -> Hero from Sr. Member during Merit System kick-off.
vycl87                -> Hero from Member during Merit System kick-off.

Note: Still pending-> There are some issues identifying rank-up for Legendary Copper Members and staff. Not sure what I'll do here, since the rank is not on the profile, and is not strictly derivable from merits and activity (activity is a range). This causes that the Dashboard to identify an Old Era Newbie ranked-up to Legendary this week, which is not true. I'll try to resolve it next week.

[DdmrDdmr]

Update 28/02/2020:

The dashboard gives you access to anyone’s complete merit history in the TX tab, surpassing the 120 day limit.
Link:  BitcoinTalk Merit Dashboard.  

Updated the Merit Dashboard to reflect the most recent sMerit available data:

Total sMerit:  609.374
Total Txs:      314.736
From Users:    21.778
To Users:        33.065
minDate:       2018-01-24 22:12:21
maxDate:      2020-02-28 02:42:36

Aggregate awarded sMerit for the last complete week (17/02/2020 .. 23/02/2020) is 6.848 which is up 17,16% from the previous week.

In addition, there are 3 more Legendries and 1 more Heroe this week:
exstasie           -> Legendary from Hero Member during Merit System kick-off.
nc50lc             -> Legendary from Member during Merit System kick-off.
roycilik            -> Legendary from Full Member during Merit System kick-off.
Trofo               -> Hero from Full Member during Merit System kick-off.


Note:
I'm still working on deriving the real rank for some Copper Members and non-native ranks (staff, etc). Not completely finished, so they may be some unresoved cases still pending to deal with properly (/wrong case).

[DdmrDdmr]

Update 06/03/2020:

The dashboard gives you access to anyone’s complete merit history in the TX tab, surpassing the 120 day limit.
Link:  BitcoinTalk Merit Dashboard. 

Updated the Merit Dashboard to reflect the most recent sMerit available data:

Total sMerit:  614.072
Total Txs:      317.783
From Users:    21.807
To Users:        33.158
minDate:       2018-01-24 22:12:21
maxDate:      2020-03-06 02:51:54

Aggregate awarded sMerit for the last complete week (24/02/2020 .. 01/03/2020) is 5.833 which is down 14,82% from the previous week.

In addition, there is 1 more Legendary and 1 more Hero this week:
Saint-loup           -> Legendary from Sr. Member during Merit System kick-off.
amishmanish      -> Hero from Full Member during Merit System kick-off.


Note:
Copper Members and non-native ranks (staff, etc) should now be displayed as real (regular) ranks.

[mediaBuzz]

Update 06/03/2020:

The dashboard gives you access to anyone’s complete merit history in the TX tab, surpassing the 120 day limit.
Link:  BitcoinTalk Merit Dashboard.  

Updated the Merit Dashboard to reflect the most recent sMerit available data:

Total sMerit:  614.072
Total Txs:      317.783
From Users:    21.807
To Users:        33.158
minDate:       2018-01-24 22:12:21
maxDate:      2020-03-06 02:51:54

Aggregate awarded sMerit for the last complete week (24/02/2020 .. 01/03/2020) is 5.833 which is down 14,82% from the previous week.

In addition, there is 1 more Legendary and 1 more Hero this week:
Saint-loup           -> Legendary from Sr. Member during Merit System kick-off.
amishmanish      -> Hero from Full Member during Merit System kick-off.


Note:
Copper Members and non-native ranks (staff, etc) should now be displayed as real (regular) ranks.

Can you please explain how the Merited User Ranking list works? It's showing the top 1 merited user is theymos with 6591 merits but his profile on the forum is showing a different number which is 7591. Thank you!

[hosseinimr93]

Can you please explain how the Merited User Ranking list works? It's showing the top 1 merited user is theymos with 6591 merits but his profile on the forum is showing a different number which is 7591. Thank you!

The merit dashboard shows earned merit. But the forum shows total merit (earned merit + airdropped merit). Theymos has earned 6591 merit and has 1000 airdropped merit.
When merit system was implemented, all users of the forum except newbies received airdropped merits, so they are not deranked. All legendary members including theymos received 1000 airdropped merit.

[DdmrDdmr]

<…>

As @hosseinimr93 indicates, some profiles had an initial amount of Merits (and sMerits) when the system kicked-off. Specifically, they had an airdropped amount of Merits equivalent to their rank at the time. Therefore, a Member would have and airdrop of 10 Merits, a Full Member a 100, a Sr. Member 250, and so on. On the Dashboard, I’m usually displaying earned merits (meaning non-airdropped merits). The Rankings Tab you mentioned displays earned Merits.

Only on the tabs where I display Activity and Posts alongside Merits do I display various Merit counters:
Merits (Total Merits), Merits Received (earned Merits) and Initial Merits (airdropped Merits). These are displayed for example in the Personal Summary Tab (on the top left cuadrant), the User Summary Tab.