Title: Analysis – Who ranked who, and was ranked by whom (with an 'r’' not a 'w')
Post by: DdmrDdmr on August 17, 2019, 02:21:37 PM
1. IntroductionUpdate with data as of 31/01/2020New 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 (https://bitcointalk.org/index.php?topic=5176193.0)), 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. ContextThe 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 RankersAs 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. 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 rankedIn 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: 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: 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.
Title: Re: Analysis – Who ranked who, and was ranked by whom (with an 'r’' not a 'w')
Post by: Sohyun Park on August 17, 2019, 02:57:27 PM
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.
Title: Re: Analysis – Who ranked who, and was ranked by whom (with an 'r’' not a 'w')
Post by: dkbit98 on August 17, 2019, 02:57:31 PM
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 ;)) each sent me 11 merits in total (can't find any info about that in google doc)
Title: Re: Analysis – Who ranked who, and was ranked by whom (with an 'r’' not a 'w')
Post by: LoyceV on August 17, 2019, 03:02:27 PM
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 :D I didn't have scraped profile data ready, so you had a head start. When finished, let's compare data :) My example: LoyceV and bones261 (thank you guys ;)) 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).
Title: Re: Analysis – Who ranked who, and was ranked by whom (with an 'r’' not a 'w')
Post by: dkbit98 on August 17, 2019, 03:08:57 PM
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 :D I didn't have scraped profile data ready, so you had a head start. When finished, let's compare data :) My example: LoyceV and bones261 (thank you guys ;)) 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 ;D https://public.tableau.com/profile/ddmrddmr#!/vizhome/BitcointalkMeritDashboard/GlobalSummary
Title: Re: Analysis – Who ranked who, and was ranked by whom (with an 'r’' not a 'w')
Post by: DdmrDdmr on August 17, 2019, 03:11:02 PM
<...>
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: 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): 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 <…> I didn't have scraped profile data ready, so you had a head start. When finished, let's compare data <…>
Okeydoke … <…> 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).
Title: Re: Analysis – Who ranked who, and was ranked by whom (with an 'r’' not a 'w')
Post by: dkbit98 on August 17, 2019, 03:57:52 PM
Thanks for clarification and great work with all this data you provide ;)
Title: Re: Analysis – Who ranked who, and was ranked by whom (with an 'r’' not a 'w')
Post by: Jet Cash on August 17, 2019, 04:14:02 PM
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. :)
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.
Title: Re: Analysis – Who ranked who, and was ranked by whom (with an 'r’' not a 'w')
Post by: rhomelmabini on August 17, 2019, 04:29:56 PM
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.
Title: Re: Analysis – Who ranked who, and was ranked by whom (with an 'r’' not a 'w')
Post by: witcher_sense on August 17, 2019, 04:35:21 PM
UserFromName | | user_from | | UserToName | | user_to | | amount | | msg | | converted_date | | RankedTo | | CurrentRank | |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| | Xal0lex | | 1068464 | | witcher_sense | | 1433865 | | 1 | | https://bitcointalk.org/index.php?topic=1085285.msg42850584 | | 2018-07-25 15:22:47.000 | | Jr. Member | | Hero Member | | lovesmayfamilis | | 1982152 | | witcher_sense | | 1433865 | | 2 | | https://bitcointalk.org/index.php?topic=5032601.msg45955145 | | 2018-09-20 18:14:29.000 | | Member | | Hero Member | | lovesmayfamilis | | 1982152 | | witcher_sense | | 1433865 | | 1 | | https://bitcointalk.org/index.php?topic=5119484.msg50121026 | | 2019-03-21 04:58:14.000 | | Full Member | | Hero Member | | ICOEthics | | 2204241 | | witcher_sense | | 1433865 | | 2 | | https://bitcointalk.org/index.php?topic=5142680.msg51034115 | | 2019-05-13 23:00:47.000 | | Sr. Member | | Hero Member | | Alex_Sr | | 1762404 | | witcher_sense | | 1433865 | | 2 | | https://bitcointalk.org/index.php?topic=4661132.msg51650720 | | 2019-07-06 18:49:37.000 | | Hero Member | | Hero Member | |
Title: Re: Analysis – Who ranked who, and was ranked by whom (with an 'r’' not a 'w')
Post by: DdmrDdmr on August 17, 2019, 04:55:06 PM
<…> 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: 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): 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.
Title: Re: Analysis – Who ranked who, and was ranked by whom (with an 'r’' not a 'w')
Post by: TheBeardedBaby on August 17, 2019, 10:31:28 PM
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 :)
Title: Re: Analysis – Who ranked who, and was ranked by whom (with an 'r’' not a 'w')
Post by: DdmrDdmr on August 18, 2019, 09:38:55 AM
<…> Now other thoughts came to my mind, a way to see who rank you up like your personal merit angles :)
It’s already there … In your case it is: 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:
Title: Re: Analysis – Who ranked who, and was ranked by whom (with an 'r’' not a 'w')
Post by: TheBeardedBaby on February 04, 2020, 01:35:00 PM
Bump :) An update needed here ^ :) I was at some point working on this, and it's the reason I added the Merit sum (http://loyce.club/Merit/history/459836.html) 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 :P
Oh man,don't you already have enough projects on your head? Don't bother to start a new one :)
Title: Re: Analysis – Who ranked who, and was ranked by whom (with an 'r’' not a 'w')
Post by: LoyceV on February 04, 2020, 02:36:55 PM
Bump :) An update needed here ^ :)
I was at some point working on this, and it's the reason I added the Merit sum (http://loyce.club/Merit/history/459836.html) 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 :P
Title: Re: Analysis – Who ranked who, and was ranked by whom (with an 'r’' not a 'w')
Post by: DdmrDdmr on February 04, 2020, 03:21:42 PM
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). <...>
I've updated the OP. Your data is as follows: Who ranked you: 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: 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
Title: Re: Analysis – Who ranked who, and was ranked by whom (with an 'r’' not a 'w')
Post by: DdmrDdmr on February 12, 2020, 05:40:29 PM
Added the lists to the Merit Dashboard (https://public.tableau.com/profile/ddmrddmr#!/vizhome/BitcointalkMeritDashboard/GlobalSummary). (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: https://i.imgur.com/YSCHyb9.pngThere 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).
Title: Re: Analysis – Who ranked who, and was ranked by whom (with an 'r’' not a 'w')
Post by: TMAN on February 12, 2020, 06:22:20 PM
who have I wanked please dude..
also who is the most prolific wanker of members plus?
when you have time of course sir!
Title: Re: Analysis – Who ranked who, and was ranked by whom (with an 'r’' not a 'w')
Post by: DdmrDdmr on February 12, 2020, 06:32:10 PM
<...>
Who w/ranked you: 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: 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")
Title: Re: Analysis – Who ranked who, and was ranked by whom (with an 'r’' not a 'w')
Post by: The Sceptical Chymist on February 12, 2020, 06:37:06 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.
|