Bitcoin Forum>Other>Meta
Author

Topic: Analysis – Who ranked who, and was ranked by whom (with an 'r’' not a 'w') (Read 530 times)

The Sceptical Chymist
legendary
Activity: 3500
Merit: 6981
Top Crypto Casino
Analysis – Who ranked who, and was ranked by whom (with an 'r’' not a 'w')
February 12, 2020, 01:37:06 PM
#20
Quote from: TMAN on February 12, 2020, 01:22:20 PM
who have I wanked please dude..
Congrats on being the head wanker (oh that sounds so bad).  I always knew you had potential.

But seriously, it's nice you've done this for a bunch of members--taken them under your wing, so to speak. 

I've done the same with one or two members who've taken me up on my offer to review their posts via PM, and I'd invite anyone else who's interested to do the same.  Just drop me a note asking me to review your post history if you're a lower-ranked member, and I'll do so.  If I think some of your posts are under-merited, I'll be happy to help out and if not, I won't--but the way I see it you've got nothing to lose by contacting me.

Props to OP for compiling this data, too.
DdmrDdmr
legendary
Activity: 2338
Merit: 10802
There are lies, damned lies and statistics. MTwain
Re: Analysis – Who ranked who, and was ranked by whom (with an 'r’' not a 'w')
February 12, 2020, 01:32:10 PM
#19
Quote from: TMAN on February 12, 2020, 01:22:20 PM
<...>
Who w/ranked you:
Code:
UserFromName             user_from UserToName               user_to   amount    msg                                                              converted_date           RankedTo
dazedfool                327499    TMAN                     98986     50        3335861.msg35312088                                              2018-04-23 04:49:31.000  Legendary

Who you’ve w/ranked:
Code:
UserFromName             user_from UserToName               user_to   amount    msg                                                              converted_date           RankedTo            current_rank
TMAN                     98986     9900K                    2513757   1         5223104.msg53770875                                              2020-02-06 08:59:48.000  Jr. Member          Jr. Member
TMAN                     98986     Rimidalv                 1808762   6         5219641.msg53685001                                              2020-02-03 13:29:57.000  Member              Member
TMAN                     98986     cryptoaddictchie         1269701   35        5218813.msg53643049                                              2020-01-20 10:24:24.000  Hero Member         Hero Member
TMAN                     98986     LUCKMCFLY                1153977   38        5206324.msg53242573                                              2019-12-17 08:11:18.000  Hero Member         Hero Member
TMAN                     98986     Juggy777                 913593    44        5204634.msg53183559                                              2019-12-15 14:30:29.000  Hero Member         Hero Member
TMAN                     98986     fuckcrypto               1344096   9         5206897.msg53259608                                              2019-12-04 16:05:00.000  Jr. Member          Jr. Member
TMAN                     98986     elmanchez                2553198   5         5205279.msg53256225                                              2019-12-04 11:18:56.000  Member              Member
TMAN                     98986     BIT-BENDER               2709246   1         5201659.msg53083589                                              2019-11-15 15:56:52.000  Jr. Member          Member
TMAN                     98986     tk808                    180477    50        5190137.msg52653514                                              2019-10-27 14:50:15.000  Legendary           Legendary
TMAN                     98986     Ispep                    2442315   6         5055497.msg47174920                                              2018-10-23 05:14:02.000  Member              Member
TMAN                     98986     anonymousminer           1668017   10        3042971.msg46940141                                              2018-10-16 11:02:36.000  Full Member         Hero Member
TMAN                     98986     S_Therapist              2423416   5         5045629.msg46623397                                              2018-10-08 01:04:54.000  Member              Sr. Member
TMAN                     98986     iyke12                   1819896   1         5042532.msg46444211                                              2018-10-03 13:08:42.000  Jr. Member          Jr. Member
TMAN                     98986     ND_INVEST                2376221   1         5039599.msg46261197                                              2018-09-28 10:29:58.000  Jr. Member          Jr. Member
TMAN                     98986     erikoy                   1788212   5         5031979.msg45870255                                              2018-09-19 07:27:40.000  Member              Member
TMAN                     98986     hilariousetc             397737    13        4854032.msg43756615                                              2018-08-09 09:10:05.000  Legendary           Legendary
TMAN                     98986     azvn                     1769779   1         3042971.msg40382690                                              2018-06-19 09:38:28.000  Jr. Member          Jr. Member
TMAN                     98986     J-N                      1460009   5         4448729.msg39759485                                              2018-06-14 10:09:44.000  Member              Member
TMAN                     98986     madnessteat              1894120   10        4457400.msg39902993                                              2018-06-11 21:25:13.000  Member              Hero Member
TMAN                     98986     DavidBooker              2027824   1         3796520.msg37235824                                              2018-05-14 15:19:40.000  Jr. Member          Jr. Member
TMAN                     98986     Flash Cunt               2101743   2         3182178.msg36859119                                              2018-05-10 10:32:54.000  Jr. Member          Member
TMAN                     98986     snapee11                 1830654   1         3376729.msg36852018                                              2018-05-10 09:03:18.000  Jr. Member          Jr. Member
TMAN                     98986     PROTO_Token              2095788   1         3376729.msg36827676                                              2018-05-10 04:39:57.000  Jr. Member          Jr. Member
TMAN                     98986     loicuagio1979            1541483   1         3479278.msg36089951                                              2018-05-02 11:23:11.000  Member              Member
TMAN                     98986     jd2281                   1261089   1         2971165.msg34911891                                              2018-04-23 14:39:04.000  Jr. Member          Jr. Member
TMAN                     98986     Talk merit               1977706   1         3287253.msg34292987                                              2018-04-09 13:40:07.000  Member              Member
TMAN                     98986     Indohunter               1571912   10        3182178.msg33975756                                              2018-04-09 08:10:15.000  Member              Member
TMAN                     98986     coinlocket$              1339716   4         2896910.msg32093079                                              2018-03-28 22:21:35.000  Full Member         Hero Member
TMAN                     98986     ThatRandomDude           1076216   2         2865959.msg29423405                                              2018-03-04 10:16:37.000  Jr. Member          Member
TMAN                     98986     imjustagirl              1113788   1         2818350.msg30346764                                              2018-02-15 14:56:19.000  Jr. Member          Jr. Member
TMAN                     98986     vlad230                  1268116   1         2770113.msg29460268                                              2018-02-15 13:12:35.000  Member              Sr. Member
TMAN                     98986     Tatzky                   1549423   1         2846629.msg29233565                                              2018-01-30 12:26:36.000  Jr. Member          Jr. Member
TMAN                     98986     DunnDy                   1441331   10        2842216.msg29159408                                              2018-01-30 06:54:37.000  Member              Member
TMAN                     98986     cry4crypto               1201351   4         2825523.msg28963049                                              2018-01-29 15:46:19.000  Member              Member
TMAN                     98986     bitperson                1459810   6         2828412.msg29048944                                              2018-01-27 17:12:36.000  Member              Full Member
TMAN                     98986     ProofOfLambo             1449217   2         2818350.msg29047001                                              2018-01-27 16:42:32.000  Jr. Member          Jr. Member
TMAN                     98986     nikenv2212               1483939   1         2831178.msg29028656                                              2018-01-27 11:39:59.000  Jr. Member          Jr. Member
TMAN                     98986     Thirio                   1016933   1         2828412.msg29027664                                              2018-01-27 11:36:24.000  Member              Member
TMAN                     98986     l4w                      1526190   1         2821334.msg29021826                                              2018-01-27 09:40:13.000  Jr. Member          Jr. Member
TMAN                     98986     Leopardon29              1436801   1         2828014.msg28988161                                              2018-01-26 19:09:17.000  Jr. Member          Jr. Member
TMAN                     98986     kaar                     1439008   5         2828014.msg28982745                                              2018-01-26 16:54:41.000  Member              Full Member
TMAN                     98986     Chandler32               1436181   1         2824666.msg28970468                                              2018-01-26 13:51:32.000  Jr. Member          Jr. Member
TMAN                     98986     Godwans                  1487209   1         2822726.msg28967826                                              2018-01-26 13:09:01.000  Member              Member
TMAN                     98986     justine11                1139897   7         2825801.msg28955866                                              2018-01-26 09:57:40.000  Member              Member
TMAN                     98986     shailkumari              1368725   7         2825865.msg28949008                                              2018-01-26 08:03:41.000  Member              Member
TMAN                     98986     jimmywh                  1431910   2         2818350.msg28948915                                              2018-01-26 08:00:39.000  Member              Member
TMAN                     98986     KualaBit                 970896    2         2822726.msg28947878                                              2018-01-26 07:41:21.000  Jr. Member          Member
TMAN                     98986     smith4cris               1358112   2         2822726.msg28921244                                              2018-01-25 20:02:55.000  Jr. Member          Jr. Member
TMAN                     98986     FireShark89              1436636   1         2818066.msg28884213                                              2018-01-25 10:19:36.000  Jr. Member          Jr. Member
 

Most prominent w/rankers -> See list in OP (section "3.   Top Rankers")
TMAN
legendary
Activity: 1414
Merit: 1808
Exchange Bitcoin quickly-https://blockchain.com.do
Re: Analysis – Who ranked who, and was ranked by whom (with an 'r’' not a 'w')
February 12, 2020, 01:22:20 PM
#18
who have I wanked please dude..

also who is the most prolific wanker of members plus?

when you have time of course sir!
DdmrDdmr
legendary
Activity: 2338
Merit: 10802
There are lies, damned lies and statistics. MTwain
Re: Analysis – Who ranked who, and was ranked by whom (with an 'r’' not a 'w')
February 12, 2020, 12:40:29 PM
#17
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
legendary
Activity: 2338
Merit: 10802
There are lies, damned lies and statistics. MTwain
Re: Analysis – Who ranked who, and was ranked by whom (with an 'r’' not a 'w')
February 04, 2020, 10:21:42 AM
#16
I found the scripts I used, so let’s see if I can update the OP alongside the Google Sheet soon. I’ll probably overwrite the OP and archive the content previously for comparison purposes (as well as the old Google Sheet).

Quote from: TheBeardedBaby on February 04, 2020, 08:35:00 AM
<...>
I've updated the OP.

Your data is as follows:

Who ranked you:
Code:
UserFromName             user_from UserToName               user_to   amount    msg                                                              converted_date           RankedTo
QuestionAuthority        72795     iasenko                  1291828   20        2827596.msg45942067                                              2018-09-23 18:09:28.000  Hero Member
DdmrDdmr                 1582324   iasenko                  1291828   2         3108981.msg32121418                                              2018-07-05 10:45:08.000  Sr. Member
yahoo62278               355846    iasenko                  1291828   10        3108981.msg32121418                                              2018-03-21 20:24:13.000  Full Member

Whom you ranked:
Code:
UserFromName             user_from UserToName               user_to   amount    msg                                                              converted_date           RankedTo            current_rank
iasenko                  1291828   hosseinimr93             995810    4         5217772.msg53616827                                              2020-01-16 04:42:23.000  Hero Member         Hero Member
iasenko                  1291828   bitwookie                1337455   4         5215095.msg53529331                                              2020-01-06 07:58:24.000  Member              Member
iasenko                  1291828   Maus0728                 1289002   1         5193860.msg52870979                                              2019-11-08 12:41:33.000  Full Member         Full Member
iasenko                  1291828   Durdenkingtyler          2535039   1         5189867.msg52733776                                              2019-10-13 21:25:57.000  Jr. Member          Jr. Member
iasenko                  1291828   Baronets                 2633320   1         5167703.msg51914573                                              2019-08-17 07:39:35.000  Member              Member
iasenko                  1291828   WhyFhy                   1122459   1         5174282.msg52121464                                              2019-08-15 09:15:26.000  Full Member         Full Member
iasenko                  1291828   tbct_mt2                 1096237   1         5125435.msg50347145                                              2019-04-25 14:12:36.000  Sr. Member          Hero Member
iasenko                  1291828   Kavelj22                 2443746   1         5121257.msg50196173                                              2019-04-11 12:03:14.000  Full Member         Full Member
iasenko                  1291828   FatBen                   2523202   1         5095468.msg49154463                                              2019-01-10 22:00:30.000  Jr. Member          Jr. Member
iasenko                  1291828   AverageGlabella          392646    1         5067090.msg47790947                                              2018-11-22 20:21:21.000  Sr. Member          Hero Member
iasenko                  1291828   RinkaDink                2477984   1         5073079.msg48095864                                              2018-11-21 23:36:10.000  Jr. Member          Jr. Member
iasenko                  1291828   Summation                1334663   1         5072677.msg48092438                                              2018-11-21 19:44:06.000  Member              Member
iasenko                  1291828   coin-boss                1930555   1         4937275.msg46915532                                              2018-10-16 09:55:56.000  Jr. Member          Jr. Member
iasenko                  1291828   khatarnak                2300286   1         5041590.msg46412430                                              2018-10-02 13:29:42.000  Jr. Member          Jr. Member
iasenko                  1291828   YOSHIE                   2363935   1         5042074.msg46417391                                              2018-10-02 12:19:17.000  Member              Sr. Member
iasenko                  1291828   Shermand100              938297    1         5030085.msg45786270                                              2018-09-16 16:36:52.000  Jr. Member          Jr. Member
iasenko                  1291828   JetAid                   2386998   1         5028318.msg45647117                                              2018-09-13 21:06:34.000  Jr. Member          Member
iasenko                  1291828   bluebits                 881359    1         178336.msg41178158                                               2018-09-11 08:16:56.000  Member              Member
iasenko                  1291828   mdayonliner              1432468   3         4884870.msg44003115                                              2018-08-13 13:41:11.000  Sr. Member          Sr. Member
iasenko                  1291828   jenia2                   2247462   1         4872924.msg43898564                                              2018-08-11 18:45:13.000  Jr. Member          Jr. Member
iasenko                  1291828   monsterer2               1042068   1         3125137.msg32740896                                              2018-08-08 09:16:02.000  Full Member         Full Member
iasenko                  1291828   Ayanamirs                1215309   1         3957640.msg37715099                                              2018-08-08 09:14:29.000  Member              Member
iasenko                  1291828   napsterz                 1895068   1         4556338.msg41093161                                              2018-08-08 08:59:17.000  Member              Member
iasenko                  1291828   StevenMosher             987609    1         3375954.msg36260885                                              2018-08-07 23:04:58.000  Member              Member
iasenko                  1291828   Heisenberg_Hunter        1564795   1         2968050.msg40114238                                              2018-06-16 09:06:06.000  Full Member         Hero Member
iasenko                  1291828   Coolcryptovator          1980983   1         4407646.msg39226575                                              2018-06-06 21:01:13.000  Member              Hero Member
iasenko                  1291828   hoanghai101296           1575909   1         3502978.msg36182697                                              2018-06-04 06:04:38.000  Member              Member
iasenko                  1291828   Bencus                   1775146   1         3613776.msg36570772                                              2018-05-16 21:44:07.000  Member              Member
iasenko                  1291828   pantheraio               1109228   1         3615969.msg36674471                                              2018-05-08 19:46:16.000  Member              Member
iasenko                  1291828   Slava79                  1387489   1         3379629.msg35426924                                              2018-04-24 08:58:20.000  Member              Member
iasenko                  1291828   tringt                   1418483   1         3270748.msg34102473                                              2018-04-15 21:39:09.000  Member              Member
iasenko                  1291828   vlad230                  1268116   1         3212390.msg33384025                                              2018-04-03 12:38:54.000  Full Member         Sr. Member
iasenko                  1291828   TheQuin                  143168    3         3199352.msg33204677                                              2018-03-26 11:10:01.000  Hero Member         Hero Member
iasenko                  1291828   dimplit                  1795327   1         3102907.msg32036677                                              2018-03-24 06:35:16.000  Member              Member
iasenko                  1291828   hugeblack                1059082   1         3059507.msg31513716                                              2018-03-20 10:14:10.000  Sr. Member          Legendary
iasenko                  1291828   tbalazs                  1210838   1         2990880.msg30749800                                              2018-02-21 11:05:01.000  Jr. Member          Jr. Member
iasenko                  1291828   ducdr                    1254889   1         2873832.msg29536389                                              2018-02-06 18:28:45.000  Member              Member
iasenko                  1291828   massivekode              1454597   1         2819905.msg28872506                                              2018-01-27 12:42:12.000  Jr. Member          Jr. Member
LoyceV
legendary
Activity: 3290
Merit: 16489
Thick-Skinned Gang Leader and Golden Feather 2021
Re: Analysis – Who ranked who, and was ranked by whom (with an 'r’' not a 'w')
February 04, 2020, 09:36:55 AM
#15
Quote from: TheBeardedBaby on February 04, 2020, 08:35:00 AM
Bump Smiley
An update needed here ^ Smiley
I was at some point working on this, and it's the reason I added the Merit sum to my Merit history viewer, but I didn't have the time to finish it. Instead, I've just ranked up several users since then Tongue
TheBeardedBaby
legendary
Activity: 2240
Merit: 3150
₿uy / $ell ..oeleo ;(
Re: Analysis – Who ranked who, and was ranked by whom (with an 'r’' not a 'w')
February 04, 2020, 08:35:00 AM
#14
Bump Smiley
An update needed here ^ Smiley

Quote from: LoyceV on February 04, 2020, 09:36:55 AM
I was at some point working on this, and it's the reason I added the Merit sum to my Merit history viewer, but I didn't have the time to finish it. Instead, I've just ranked up several users since then Tongue

Oh man,don't you already have enough projects on your head? Don't bother to start a new one Smiley
DdmrDdmr
legendary
Activity: 2338
Merit: 10802
There are lies, damned lies and statistics. MTwain
Re: Analysis – Who ranked who, and was ranked by whom (with an 'r’' not a 'w')
August 18, 2019, 04:38:55 AM
#13
Quote from: TheBeardedBaby on August 17, 2019, 05:31:28 PM
<…> Now other thoughts came to my mind, a way to see who rank you up like your personal merit angles Smiley
It’s already there … In your case it is:
Code:
UserFromName                  user_from UserToName                    user_to   amount    msg                                               converted_date                RankedTo
yahoo62278                    355846    iasenko                       1291828   10        3108981.msg32121418                               2018-03-21 20:24:13.000       Full Member
DdmrDdmr                      1582324   iasenko                       1291828   2         3108981.msg32121418                               2018-07-05 10:45:08.000       Sr. Member
QuestionAuthority             72795     iasenko                       1291828   20        2827596.msg45942067                               2018-09-23 18:09:28.000       Hero Member

-> On the Google Sheet, Filter Detail By UserToName or Id.

Edit:
Shame Google Fusion Tables is ending in December 2019 ... Whom @Iasenko ranked-up: 

TheBeardedBaby
legendary
Activity: 2240
Merit: 3150
₿uy / $ell ..oeleo ;(
Re: Analysis – Who ranked who, and was ranked by whom (with an 'r’' not a 'w')
August 17, 2019, 05:31:28 PM
#12
Wonderful thread, I'll check out LoyceV's work as well.
Now other thoughts came to my mind, a way to see who rank you up like your personal merit angles Smiley
DdmrDdmr
legendary
Activity: 2338
Merit: 10802
There are lies, damned lies and statistics. MTwain
Re: Analysis – Who ranked who, and was ranked by whom (with an 'r’' not a 'w')
August 17, 2019, 11:55:06 AM
#11
Quote from: rhomelmabini on August 17, 2019, 11:29:56 AM
<…> I have a question. Does this means that those on the "Ranked-up needing Merit" are the latest data, for example I'm an old era newbie so in that data I belong to the Full Member (89) list and can't be listed anymore on the Member and Jr. ranks list? Hope you get my point here.
Since you got your first merit on the 17/09/2018 (just on the date ranking requirements changed), that merit counted for your Jr. Membership, and thus this is the output:
Code:
UserFromName                  user_from UserToName                    user_to   amount    msg                                               converted_date                RankedTo
Continuous                    951567    rhomelmabini                  1255873   1         5030884.msg45835689                               2018-09-17 16:55:34.000       Jr. Member
witcher_sense                 1433865   rhomelmabini                  1255873   1         5100145.msg49342767                               2019-01-22 18:36:45.000       Member
LoyceV                        459836    rhomelmabini                  1255873   3         5146871.msg51199721                               2019-07-18 09:05:22.000       Full Member

In addition, you’ve also ranked @ruthwithers1980 (to Member):
Code:
UserFromName                  user_from UserToName                    user_to   amount    msg                                               converted_date                RankedTo
rhomelmabini                  1255873   ruthwithers1980               2400859   1         5120009.msg50138744                               2019-03-15 16:50:37.000       Member
GTG now.
witcher_sense
legendary
Activity: 2450
Merit: 4415
🔐BitcoinMessage.Tools🔑
Re: Analysis – Who ranked who, and was ranked by whom (with an 'r’' not a 'w')
August 17, 2019, 11:35:21 AM
#10
UserFromNameuser_fromUserToNameuser_toamountmsgconverted_dateRankedToCurrentRank
Xal0lex1068464witcher_sense14338651https://bitcointalksearch.org/topic/m.428505842018-07-25 15:22:47.000Jr. MemberHero Member
lovesmayfamilis1982152witcher_sense14338652https://bitcointalksearch.org/topic/betvibe-platform-scam-fake-team-50326012018-09-20 18:14:29.000MemberHero Member
lovesmayfamilis1982152witcher_sense14338651https://bitcointalksearch.org/topic/m.501210262019-03-21 04:58:14.000Full MemberHero Member
ICOEthics2204241witcher_sense14338652https://bitcointalksearch.org/topic/m.510341152019-05-13 23:00:47.000Sr. MemberHero Member
Alex_Sr1762404witcher_sense14338652https://bitcointalksearch.org/topic/m.516507202019-07-06 18:49:37.000Hero MemberHero Member
rhomelmabini
hero member
Activity: 2030
Merit: 578
No God or Kings, only BITCOIN.
Re: Analysis – Who ranked who, and was ranked by whom (with an 'r’' not a 'w')
August 17, 2019, 11:29:56 AM
#9
I'm pretty sure LoyceV is the one that gets me wear this Full Member rank with the last 8 merits needed for me to ranked up, can't say for sure who is the one that gave me the merit to become a Member rank.

I have a question. Does this means that those on the "Ranked-up needing Merit" are the latest data, for example I'm an old era newbie so in that data I belong to the Full Member (89) list and can't be listed anymore on the Member and Jr. ranks list? Hope you get my point here.
Jet Cash
legendary
Activity: 2814
Merit: 2472
https://JetCash.com
Re: Analysis – Who ranked who, and was ranked by whom (with an 'r’' not a 'w')
August 17, 2019, 11:14:02 AM
#8
Merit awarding is such a subjective topic. I wonder if declared alts of legendary members are more or less likely to receive merits. I think my Talk Merit alt was the faster to climb the initial ranks based on my gaming the activity to gain 28 in the first 15 days. I've managed to run the others up to member status to enable me to use the basic signature facilities should I wish to do so.

ps. One has to resist temptation when one has over 250 sMerits to award, and one's latest alt just needs one for promotion. Smiley

I'm not sure how one could detect it, but it would be interesting to see if any members have awarded merits to any of their alts.
dkbit98
legendary
Activity: 2212
Merit: 7064
Re: Analysis – Who ranked who, and was ranked by whom (with an 'r’' not a 'w')
August 17, 2019, 10:57:52 AM
#7
Thanks for clarification and great work with all this data you provide Wink
DdmrDdmr
legendary
Activity: 2338
Merit: 10802
There are lies, damned lies and statistics. MTwain
Re: Analysis – Who ranked who, and was ranked by whom (with an 'r’' not a 'w')
August 17, 2019, 10:11:02 AM
#6
Quote from: dkbit98 on August 17, 2019, 09:57:31 AM
<...>
That’s because this is a different focus. What this exercise shows is who merited you at a given point in time, being those merits the fundamental ones for you to move from one rank to another.

For example, in your case we’ve got:
Code:
UserFromName                  user_from UserToName                    user_to   amount    msg                                               converted_date                RankedTo
nid125                        660361    dkbit98                       1410401   3         4313712.msg38922781                               2018-05-30 12:19:51.000       Member
CucakRowo                     1932205   dkbit98                       1410401   2         5041209.msg46369754                               2019-08-09 12:03:39.000       Full Member
@nid125 sent you 3 sMerits on the 30/05/2018, which were the ones “used” to reach your Member rank at the time (>= 10 Merits) . Later on, on the  09/08/2019, @CucakRowo  sent you 2 sMerits, which led you to having >= 100 merits, and thus were key to swith from Member to Full Member.
All other TXs are not listed, since they did not cause you to change rank with them. Jr. Member TXs is not listed, since you reached Jr. Membership through Activity at the time.

And these are the people you've ranked-up (by meriting them enough to reach their next rank):
Code:
UserFromName                  user_from UserToName                    user_to   amount    msg                                               converted_date                RankedTo
dkbit98                       1410401   CucakRowo                     1932205   1         4982784.msg44952559                               2018-09-17 13:16:04.000       Jr. Member
dkbit98                       1410401   CucakRowo                     1932205   6         5080772.msg49269199                               2019-01-23 18:54:12.000       Member
snap...

All your received (or sent) TXs can be retrieved on the Merit Dashboard if you wish (Tab labelled TX and filter by userToId or UserToName).
These are all the sMerit TXs sent to you specifically: https://public.tableau.com/shared/R8KBM97TH?:display_count=yes&:origin=viz_share_link

Quote from: LoyceV on August 17, 2019, 10:02:27 AM
<…> I didn't have scraped profile data ready, so you had a head start. When finished, let's compare data <…>
Okeydoke …

Quote from: Sohyun Park on August 17, 2019, 09:57:27 AM
<…> But, there are thread which say that there is merit giveaway to those who are nearer to upgrading the ranks.

If those thread are taken in to count then it is also in the meriter's hand to intent someone to rank up. I do have much experience so, please correct if my point is wrong.
Sure that happens too, and the type of thread you mention is focused on that situation, leaving the casualty in a discrete plane in these cases (nothing wrong either – a helping hand let’s say). Proportionally though, these type of threads deal with a small amount of ranking-up situations, but may easily have an important weight if we take it down to stats at an individual level (i.e. number of people ranked by x).
dkbit98
legendary
Activity: 2212
Merit: 7064
Re: Analysis – Who ranked who, and was ranked by whom (with an 'r’' not a 'w')
August 17, 2019, 10:08:57 AM
#5
Quote from: LoyceV on August 17, 2019, 10:02:27 AM
Quote from: DdmrDdmr on August 17, 2019, 09:21:37 AM
I was reluctant at first to go ahead, but alas, my mind kept rumbling through the procedure to resolve the challenge
You beat me to it Cheesy

I didn't have scraped profile data ready, so you had a head start. When finished, let's compare data Smiley

Quote from: dkbit98 on August 17, 2019, 09:57:31 AM
My example: LoyceV and bones261  (thank you guys  Wink) each sent me 11 merits in total (can't find any info about that in google doc)
See http://loyce.club/Merit/history/1410401.html (I'll add total Merit amounts later, that makes it easier to find the Rank-up moment).

I was using this cool little magic tool   Grin

https://public.tableau.com/profile/ddmrddmr#!/vizhome/BitcointalkMeritDashboard/GlobalSummary
LoyceV
legendary
Activity: 3290
Merit: 16489
Thick-Skinned Gang Leader and Golden Feather 2021
Re: Analysis – Who ranked who, and was ranked by whom (with an 'r’' not a 'w')
August 17, 2019, 10:02:27 AM
#4
Quote from: DdmrDdmr on August 17, 2019, 09:21:37 AM
I was reluctant at first to go ahead, but alas, my mind kept rumbling through the procedure to resolve the challenge
You beat me to it Cheesy

I didn't have scraped profile data ready, so you had a head start. When finished, let's compare data Smiley

Quote from: dkbit98 on August 17, 2019, 09:57:31 AM
My example: LoyceV and bones261  (thank you guys  Wink) each sent me 11 merits in total (can't find any info about that in google doc)
See http://loyce.club/Merit/history/1410401.html (I'll add total Merit amounts later, that makes it easier to find the Rank-up moment).
dkbit98
legendary
Activity: 2212
Merit: 7064
Re: Analysis – Who ranked who, and was ranked by whom (with an 'r’' not a 'w')
August 17, 2019, 09:57:31 AM
#3
Looks cool,
but I am not sure it is accurate or complete.
Maybe it is just for some members and not all of them.

My example: LoyceV and bones261  (thank you guys  Wink) each sent me 11 merits in total (can't find any info about that in google doc)
Sohyun Park
member
Activity: 103
Merit: 10
Re: Analysis – Who ranked who, and was ranked by whom (with an 'r’' not a 'w')
August 17, 2019, 09:57:27 AM
#2
Quote from: DdmrDdmr on August 17, 2019, 09:21:37 AM

It’s fair to say that ranking someone up is pretty incidental, and normally is not (I figure) the meriter’s intent, but rather a “lucky chance”. For some of those merited that ranked-up, it may be a memorable anecdote for a few days, and they likely will forget about it later on.


I read your complete post but mind is struck in this line and even I think that getting merits is incidental and is depends on the reader. If the reader finds it valuable then he gives merit. But, there are thread which say that there is merit giveaway to those who are nearer to upgrading the ranks.

If those thread are taken in to count then it is also in the meriter's hand to intent someone to rank up. I do have much experience so, please correct if my point is wrong.
DdmrDdmr
legendary
Activity: 2338
Merit: 10802
There are lies, damned lies and statistics. MTwain
Re: Analysis – Who ranked who, and was ranked by whom (with an 'r’' not a 'w')
August 17, 2019, 09:21:37 AM
#1
1.   Introduction

Update with data as of 31/01/2020
New Google Sheet with all the data(as of 31/01/2020):  
https://docs.google.com/spreadsheets/d/1Ob9XFfEFP_uHBb1IltzJRVmOX1jwKFitgYyULl-kYSY/edit?usp=sharing
Archive of prior version (17/08/2019): http://archive.ph/cs4rk
Archive of corresponding Google Sheet (17/08/2019):  
https://docs.google.com/spreadsheets/d/1WO9aWeysFf8tj1XbFWs9dFNmikwHfxsYk_D0aEOdRsY/edit?usp=sharing

@Iasenko casted a challenge (see To all the statistics guys out there, here's a challenge), which seemed interesting. I was reluctant at first to go ahead, but alas, my mind kept rumbling through the procedure to resolve the challenge, even if I tried to avoid it. I eventually came to answer in his thread the question the challenge wanted to resolve: ¿Who had @Iasenko ranked-up by meriting them at a given moment in time?

It’s fair to say that ranking someone up is pretty incidental, and normally is not (I figure) the meriter’s intent, but rather a “lucky chance”. For some of those merited that ranked-up, it may be a memorable anecdote for a few days, and they likely will forget about it later on.

What I did to resolve the challenge serves not only for @Iasenko’s specific case, but rather for any person that has merited o being merited with ranking-up involved in the process.

Disclaimer: Although I’ve checked it pretty thoroughly, there may be a few cases that do not fit my expected scenarios. If anyone detects this, I’ll look into it.


2.   Context

The general context is the current number of profiles that have ranked-up needing additional merits to do so. I make it as of last Friday to be as follows:


That is to say, 15.748 profiles have ranked-up needing merits. For example, there are 43 Legendries, 31 of which were Hero Members when the Merit System kicked-in, 6 were a Sr. Members, 5 Full Members, and another was a Member.

What I’ve done is, for those 15.748 profiles, determine which sMerit TX ranked them up, who was behind it, and when it occurred. If fact, I’ve really got 17.556 records. The extra records are due to those profiles that have ranked-up more than once since the Merit System started (if someone has ranked-up 2 levels, I track both moments in time).

In addition, I have excluded counting the cases when a person was merited and became Jr. Member before the 1 merit rule (17/09/2018). For example, a person that became Jr. Member before that date, and also a Member before the 17/09/2018 did not really need merits to become Jr. Member (only Activity). If on the other hand he received one merit before the 17/09/2018, but not enough additional merits to rank up before the 17/09/2019,  then that merit did count to making him a Jr. Member (keeping the rank), and thus I have counted it in.
 

3.   Top Rankers

As requested by @Welsh, here are the top 40 Rankers (full list here – first tab: https://docs.google.com/spreadsheets/d/1Ob9XFfEFP_uHBb1IltzJRVmOX1jwKFitgYyULl-kYSY/edit?usp=sharing). You may need to scroll here.

Code:
Rank  UserFromName             User_from nRanked        nLegendary     nHero          nSrMember      nFullMember    nMember        nJrMember      nJrMember      
1     OgNasty                  18321     225            0              0              0              0              9              216            201            
2     suchmoon                 234771    158            10             10             17             17             35             69             68            
3     LoyceV                   459836    140            9              8              8              11             30             74             66            
4     dbshck                   153634    135            1              4              4              8              49             69             108            
5     paxmao                   1192397   125            0              1              2              0              13             109            105            
6     MalReynolds              369216    113            0              0              0              0              8              105            60            
7     chimk                    1202061   111            1              1              4              9              33             63             89            
8     TimeTeller               533071    108            0              0              0              0              1              107            55            
9     vapourminer              33156     107            0              0              0              0              10             97             81            
10    theymos                  35        94             0              1              6              10             27             50             53            
11    DarkStar_                507936    90             0              5              4              4              18             59             69            
12    frodocooper              988740    90             0              0              1              5              35             49             48            
13    bones261                 452769    77             0              2              1              3              17             54             40            
14    Jet Cash                 698159    72             0              1              1              1              20             49             47            
15    tk808                    180477    72             0              1              0              1              10             60             43            
16    Halab                    1053119   72             0              0              0              2              18             52             42            
17    mole0815                 1424178   72             0              0              1              0              3              68             56            
18    foserfox                 485194    71             0              1              0              0              1              69             40            
19    xandry                   382413    71             1              0              2              2              27             39             42            
20    qwk                      24140     69             0              4              4              6              10             45             50            
21    EFS                      140584    60             0              0              0              1              17             42             30            
22    Coolcryptovator          1980983   59             0              2              0              6              29             22             20            
23    DdmrDdmr                 1582324   58             0              1              1              3              15             38             43            
24    teramit                  158960    57             0              0              0              3              11             43             47            
25    dumbtool45               965234    57             0              0              0              0              1              56             44            
26    hugeblack                1059082   55             0              0              1              0              16             38             33            
27    CryptopreneurBrainboss   1052091   52             0              2              0              3              9              38             41            
28    Vod                      30747     50             0              0              1              1              3              45             28            
29    nick777                  176605    48             0              0              0              0              1              47             19            
30    zanzibar                 218947    47             0              0              0              0              3              44             8              
31    Slark                    255170    47             0              0              0              0              14             33             37            
32    nutildah                 317618    47             0              1              2              3              5              36             35            
33    TMAN                     98986     46             2              2              0              2              19             21             29            
34    Flying Hellfish          79608     42             1              2              6              5              11             17             15            
35    taikuri13                1855828   42             1              5              6              12             9              9              26            
36    Vadi2323                 399366    41             0              0              0              0              7              34             31            
37    JayJuanGee               252510    40             0              1              1              0              6              32             27            
38    krogothmanhattan         1000199   38             0              0              0              0              9              29             9              
39    iasenko                  1291828   38             0              2              4              6              16             10             27            
40    unamis76                 236307    37             0              0              0              0              0              37             28                    

4. Who ranked me and whom I ranked

In order to see this, you can access the second tab of the google doc (: https://docs.google.com/spreadsheets/d/1Ob9XFfEFP_uHBb1IltzJRVmOX1jwKFitgYyULl-kYSY/edit?usp=sharing), and play around with the filters.

For example, If I filter by my UserToName I get to see who merited me, causing me to rank-up virtually or de facto:
Code:
UserFromName                  user_from UserToName                    user_to   amount    msg                                               converted_date                RankedTo
hilariousandco                164822    DdmrDdmr                      1582324   4         3082289.msg32316357                               2018-03-17 14:17:52.000       Member
Mr. Big                       553678    DdmrDdmr                      1582324   2         3320052.msg34678855                               2018-04-15 06:22:38.000       Full Member
wiser                         120418    DdmrDdmr                      1582324   2         3723527.msg37048060                               2018-05-12 14:18:09.000       Sr. Member
paxmao                        1192397   DdmrDdmr                      1582324   1         4601377.msg41557511                               2018-07-06 20:44:35.000       Hero Member
By "virtually" I mean that the given Merit TX is the one that caused the ranking-up to occur, but I cannot backtrack the Activity to state when that occured. For example, in my case, my merit counter was ahead of my activity counter, thus the narrow timeframes between dates on the above TXs.

And If I filter by my UserFromName I get to see who I’ve ranked-up by meriting them at the precise moment:
Code:
UserFromName             user_from UserToName               user_to   amount    msg                                                              converted_date           RankedTo            CurrentRank
DdmrDdmr                 1582324   KyleSpades               812870    1         https://bitcointalk.org/index.php?topic=3320052.msg34880666      2018-04-17 08:45:36.000  Jr. Member          Jr. Member
DdmrDdmr                 1582324   JoshuaBlack1             1897307   1         https://bitcointalk.org/index.php?topic=3403265.msg35620104      2018-04-26 13:35:47.000  Jr. Member          Jr. Member
DdmrDdmr                 1582324   Sofiasoff                1779108   1         https://bitcointalk.org/index.php?topic=3404054.msg35629533      2018-04-26 13:44:06.000  Jr. Member          Jr. Member
DdmrDdmr                 1582324   daniel.roman             1890148   1         https://bitcointalk.org/index.php?topic=2691123.msg36443004      2018-05-06 05:30:38.000  Jr. Member          Member
DdmrDdmr                 1582324   nev1d                    1933467   1         https://bitcointalk.org/index.php?topic=3534750.msg36300083      2018-05-09 16:54:06.000  Member              Member
DdmrDdmr                 1582324   Syka                     1481275   1         https://bitcointalk.org/index.php?topic=3556844.msg37492421      2018-05-16 19:53:36.000  Jr. Member          Jr. Member
DdmrDdmr                 1582324   Badisee                  1814600   1         https://bitcointalk.org/index.php?topic=4002271.msg37833794      2018-05-19 20:35:45.000  Jr. Member          Jr. Member
DdmrDdmr                 1582324   Kayj55                   1340693   1         https://bitcointalk.org/index.php?topic=3839038.msg38373061      2018-05-24 09:56:54.000  Jr. Member          Jr. Member
DdmrDdmr                 1582324   FabiAdr76                1950645   1         https://bitcointalk.org/index.php?topic=4189361.msg38416886      2018-05-26 10:35:48.000  Jr. Member          Jr. Member
DdmrDdmr                 1582324   Crypto_circuit           1442709   1         https://bitcointalk.org/index.php?topic=4514832.msg40647747      2018-06-22 19:34:22.000  Jr. Member          Jr. Member
DdmrDdmr                 1582324   iasenko                  1291828   2         https://bitcointalk.org/index.php?topic=3108981.msg32121418      2018-07-05 10:45:08.000  Sr. Member          Hero Member
DdmrDdmr                 1582324   MbyzIco                  2085659   1         https://bitcointalk.org/index.php?topic=4602444.msg41651882      2018-07-07 14:27:26.000  Member              Full Member
DdmrDdmr                 1582324   DireWolfM14              2003859   1         https://bitcointalk.org/index.php?topic=4739442.msg42808240      2018-07-24 19:16:50.000  Member              Hero Member
DdmrDdmr                 1582324   Cashi                    1973300   1         https://bitcointalk.org/index.php?topic=4907130.msg44198076      2018-08-16 21:02:34.000  Member              Member
DdmrDdmr                 1582324   Dreykku                  1864944   1         https://bitcointalk.org/index.php?topic=5027897.msg45615574      2018-09-13 10:13:45.000  Jr. Member          Jr. Member
DdmrDdmr                 1582324   Binugon                  1756715   1         https://bitcointalk.org/index.php?topic=5028298.msg45722725      2018-09-18 06:33:24.000  Jr. Member          Jr. Member
DdmrDdmr                 1582324   jademaxxiss012           1986021   1         https://bitcointalk.org/index.php?topic=5031674.msg45857153      2018-09-18 06:59:33.000  Jr. Member          Member
DdmrDdmr                 1582324   Gloverwrt                2397410   1         https://bitcointalk.org/index.php?topic=5032371.msg45886186      2018-09-19 08:34:52.000  Jr. Member          Member
DdmrDdmr                 1582324   Maggiordomo              2340148   1         https://bitcointalk.org/index.php?topic=5023605.msg45324744      2018-09-19 11:23:11.000  Jr. Member          Member
DdmrDdmr                 1582324   Instely                  2379996   1         https://bitcointalk.org/index.php?topic=2314866.msg45558313      2018-09-19 20:13:27.000  Jr. Member          Jr. Member
DdmrDdmr                 1582324   phwizard                 1237719   1         https://bitcointalk.org/index.php?topic=5055993.msg47197196      2018-10-26 08:50:07.000  Jr. Member          Jr. Member
DdmrDdmr                 1582324   cameron_EMI              2468704   1         https://bitcointalk.org/index.php?topic=5070808.msg48029820      2018-11-19 08:02:34.000  Jr. Member          Jr. Member
DdmrDdmr                 1582324   pptIox                   2459352   1         https://bitcointalk.org/index.php?topic=5074297.msg48153994      2018-11-23 10:23:55.000  Jr. Member          Member
DdmrDdmr                 1582324   daniel.roman             1890148   1         https://bitcointalk.org/index.php?topic=5080250.msg48455678      2018-12-05 10:00:07.000  Member              Member
DdmrDdmr                 1582324   Wafilian                 1242964   1         https://bitcointalk.org/index.php?topic=5082932.msg48582298      2018-12-10 18:14:03.000  Jr. Member          Member
DdmrDdmr                 1582324   Harkorede                2160117   1         https://bitcointalk.org/index.php?topic=5083831.msg48621074      2018-12-12 16:24:58.000  Member              Full Member
DdmrDdmr                 1582324   MbyzIco                  2085659   2         https://bitcointalk.org/index.php?topic=5090238.msg48934915      2019-01-07 10:25:56.000  Full Member         Full Member
DdmrDdmr                 1582324   Zarg0n                   1097101   2         https://bitcointalk.org/index.php?topic=5098175.msg49262204      2019-01-16 14:31:37.000  Full Member         Full Member
DdmrDdmr                 1582324   RapTarX                  2530429   1         https://bitcointalk.org/index.php?topic=5106873.msg49612116      2019-02-09 16:08:18.000  Jr. Member          Sr. Member
DdmrDdmr                 1582324   manishanand              755862    2         https://bitcointalk.org/index.php?topic=5110916.msg49782309      2019-02-17 15:55:10.000  Member              Member
DdmrDdmr                 1582324   Mashfiqun                1991378   1         https://bitcointalk.org/index.php?topic=5113729.msg49894839      2019-02-25 12:56:08.000  Jr. Member          Member
DdmrDdmr                 1582324   azkielt                  1164566   1         https://bitcointalk.org/index.php?topic=5116388.msg50003638      2019-03-04 18:09:31.000  Jr. Member          Jr. Member
DdmrDdmr                 1582324   Thomas29                 2536930   1         https://bitcointalk.org/index.php?topic=5117001.msg50024081      2019-03-05 16:55:38.000  Jr. Member          Jr. Member
DdmrDdmr                 1582324   Bitmagister              2363885   1         https://bitcointalk.org/index.php?topic=5125090.msg50358788      2019-03-29 08:54:13.000  Jr. Member          Jr. Member
DdmrDdmr                 1582324   DUPONDIUS                2552214   1         https://bitcointalk.org/index.php?topic=5116665.msg50037422      2019-05-11 20:42:55.000  Jr. Member          Jr. Member
DdmrDdmr                 1582324   alberbeni                1729905   1         https://bitcointalk.org/index.php?topic=5145711.msg51307709      2019-06-02 07:53:57.000  Member              Member
DdmrDdmr                 1582324   BTC Future               2616565   1         https://bitcointalk.org/index.php?topic=5149542.msg51306299      2019-06-03 09:15:03.000  Jr. Member          Jr. Member
DdmrDdmr                 1582324   margotcoins              2581897   1         https://bitcointalk.org/index.php?topic=5150645.msg51346278      2019-06-04 17:16:40.000  Jr. Member          Jr. Member
DdmrDdmr                 1582324   ManoPrimitiva            2373178   1         https://bitcointalk.org/index.php?topic=5137423.msg51361075      2019-06-06 09:35:04.000  Jr. Member          Jr. Member
DdmrDdmr                 1582324   Filmgrid                 2593105   1         https://bitcointalk.org/index.php?topic=5152524.msg51407426      2019-06-09 16:02:01.000  Jr. Member          Jr. Member
DdmrDdmr                 1582324   www.CryptoAirdrop.app    2623021   1         https://bitcointalk.org/index.php?topic=5156595.msg51660938      2019-06-30 18:21:50.000  Jr. Member          Jr. Member
DdmrDdmr                 1582324   olabiyijummy02           2342493   1         https://bitcointalk.org/index.php?topic=5161278.msg51694318      2019-07-03 15:33:32.000  Member              Member
DdmrDdmr                 1582324   adekogbe                 1556229   1         https://bitcointalk.org/index.php?topic=5164440.msg51795149      2019-07-12 10:47:21.000  Member              Member
DdmrDdmr                 1582324   sitwac                   1944251   1         https://bitcointalk.org/index.php?topic=5174927.msg52143815      2019-08-13 12:40:21.000  Member              Member
DdmrDdmr                 1582324   cuttie018                2660854   1         https://bitcointalk.org/index.php?topic=5180204.msg52311978      2019-08-30 14:51:13.000  Jr. Member          Jr. Member
DdmrDdmr                 1582324   mrjohanr                 2227721   1         https://bitcointalk.org/index.php?topic=5179696.msg52349365      2019-09-04 10:00:29.000  Member              Member
DdmrDdmr                 1582324   SheriffEl                2665692   1         https://bitcointalk.org/index.php?topic=5192804.msg52755625      2019-10-19 10:59:26.000  Jr. Member          Jr. Member
DdmrDdmr                 1582324   Stroitelev               2385348   1         https://bitcointalk.org/index.php?topic=5193860.msg52832554      2019-10-22 06:36:12.000  Member              Member
DdmrDdmr                 1582324   CryptoSDesigner          2383377   1         https://bitcointalk.org/index.php?topic=5193860.msg52887438      2019-10-26 20:03:50.000  Jr. Member          Member
DdmrDdmr                 1582324   famososMuertos           1593137   1         https://bitcointalk.org/index.php?topic=5195917.msg52931157      2019-10-30 20:37:05.000  Jr. Member          Member
DdmrDdmr                 1582324   Hunnykaushal31           1834198   1         https://bitcointalk.org/index.php?topic=5193860.msg52996022      2019-11-06 08:28:03.000  Member              Member
DdmrDdmr                 1582324   terizla                  2641576   1         https://bitcointalk.org/index.php?topic=5193860.msg52846255      2019-11-15 09:20:55.000  Full Member         Full Member
DdmrDdmr                 1582324   Axel-Spanish             2670985   1         https://bitcointalk.org/index.php?topic=5201376.msg53072403      2019-11-19 07:08:42.000  Jr. Member          Jr. Member
DdmrDdmr                 1582324   protrader786             2718720   1         https://bitcointalk.org/index.php?topic=5096373.msg53173788      2019-11-25 09:42:18.000  Jr. Member          Jr. Member
DdmrDdmr                 1582324   kawetsriyanto            2003707   1         https://bitcointalk.org/index.php?topic=5211561.msg53407555      2019-12-31 18:29:14.000  Hero Member         Hero Member
DdmrDdmr                 1582324   coinary                  2741227   1         https://bitcointalk.org/index.php?topic=5213189.msg53524175      2020-01-05 16:36:12.000  Jr. Member          Jr. Member
DdmrDdmr                 1582324   Aurora Castro            1498734   1         https://bitcointalk.org/index.php?topic=5202329.msg53529594      2020-01-06 13:34:33.000  Jr. Member          Jr. Member
DdmrDdmr                 1582324   paddy_exchange           451380    1         https://bitcointalk.org/index.php?topic=5215429.msg53539901      2020-01-07 09:46:55.000  Member              Member

Filtering is not too tough (a bit slow though), but if anyone dislikes Google Sheets and Filters, I can place their data here in this thread.
Bitcoin Forum>Other>Meta
Jump to: