To all the statistics guys out there, here's a challenge.

TheBeardedBaby

legendary

Activity: 2240

Merit: 3150

₿uy / $ell ..oeleo ;(

Quote from: khaled0111 on August 16, 2019, 05:06:23 PM

Quote from: TheBeardedBaby on August 16, 2019, 04:55:05 PM

This is really good list. From what i can see is that I'm missing "hugeblack" and "thequin". Im pretty sure hugeblack was the first Full Member to rank up and I gave him the missing merit.

Hugeblack was full member when the merit system was introduced. Maybe you gave him the missing merit to rank up to senior member but am sure I gave him the missing merit to become hero (well deserved, by the way). Does this make us partners? Grin

OK, my mistake, I remember I gave him the missing merit to rank up but I guess I forgot what rank he had at that time. BTW this merit inspired me to start a service to help people to rank up

> https://bitcointalksearch.org/topic/m.32121418

hd49728

legendary

Activity: 2044

Merit: 1018

Not your keys, not your coins!

I help two guys so far: Baofeng and big_daddy. Can I have a slot in the club of Ranking-up Helpers?

DdmrDdmr

legendary

Activity: 2338

Merit: 10802

There are lies, damned lies and statistics. MTwain

Quote from: TheBeardedBaby on August 16, 2019, 04:55:05 PM

<…> From what i can see is that I'm missing "hugeblack" and "thequin". Im pretty sure hugeblack was the first Full Member to rank up and I gave him the missing merit.

Correct, they were missing (I wasn’t dealing properly with airdropped merits). Updated the list above. They're now on the list. Debugged 10 cases so far and seemed ok. I'll call it a night now.

Quote from: khaled0111 on August 16, 2019, 05:06:23 PM

<...>

This is what I make it:

Code:

UserFromName                  user_from UserToName                    user_to   amount    msg                                               converted_date                RankedTo
iasenko                       1291828   hugeblack                     1059082   1         3059507.msg31513716                               2018-03-20 10:14:10.000       Sr. Member
khaled0111                    1012655   hugeblack                     1059082   3         5139792.msg50916804                               2019-05-06 14:27:11.000       Hero Member

Partners in crime ...

Edit:

Quote from: hd49728 on August 16, 2019, 06:57:09 PM

I help two guys so far: Baofeng and big_daddy. Can I have a slot in the club of Ranking-up Helpers?

These are the TXs that did it:

Code:

UserFromName                  user_from UserToName                    user_to   amount    msg                                               converted_date                RankedTo
hd49728                       1520746   Baofeng                       984384    2         5164359.msg51792917                               2019-08-15 02:12:38.000       Hero Member
hd49728                       1520746   big_daddy                     257004    3         5173531.msg52094491                               2019-08-14 13:32:36.000       Sr. Member

khaled0111

legendary

Activity: 2744

Merit: 3097

Top Crypto Casino

Quote from: TheBeardedBaby on August 16, 2019, 04:55:05 PM

This is really good list. From what i can see is that I'm missing "hugeblack" and "thequin". Im pretty sure hugeblack was the first Full Member to rank up and I gave him the missing merit.

Hugeblack was full member when the merit system was introduced. Maybe you gave him the missing merit to rank up to senior member but am sure I gave him the missing merit to become hero (well deserved, by the way). Does this make us partners? Grin

TheBeardedBaby

legendary

Activity: 2240

Merit: 3150

₿uy / $ell ..oeleo ;(

DdmrDdmr

legendary

Activity: 2338

Merit: 10802

There are lies, damned lies and statistics. MTwain

Here I'm jumping into the pool with no safety (i'ts late now, and I need to leave it here). This is a Beta in all senses for @Iasenko (33):
Edit: updated list

Code:

UserFromName                  user_from UserToName                    user_to   amount    msg                                               converted_date                RankedTo
iasenko                       1291828   massivekode                   1454597   1         2819905.msg28872506                               2018-01-27 12:42:12.000       Jr. Member
iasenko                       1291828   ducdr                         1254889   1         2873832.msg29536389                               2018-02-06 18:28:45.000       Member
iasenko                       1291828   tbalazs                       1210838   1         2990880.msg30749800                               2018-02-21 11:05:01.000       Jr. Member
iasenko                       1291828   hugeblack                     1059082   1         3059507.msg31513716                               2018-03-20 10:14:10.000       Sr. Member
iasenko                       1291828   dimplit                       1795327   1         3102907.msg32036677                               2018-03-24 06:35:16.000       Member
iasenko                       1291828   TheQuin                       143168    3         3199352.msg33204677                               2018-03-26 11:10:01.000       Hero Member
iasenko                       1291828   vlad230                       1268116   1         3212390.msg33384025                               2018-04-03 12:38:54.000       Full Member
iasenko                       1291828   tringt                        1418483   1         3270748.msg34102473                               2018-04-15 21:39:09.000       Member
iasenko                       1291828   Slava79                       1387489   1         3379629.msg35426924                               2018-04-24 08:58:20.000       Member
iasenko                       1291828   pantheraio                    1109228   1         3615969.msg36674471                               2018-05-08 19:46:16.000       Member
iasenko                       1291828   Bencus                        1775146   1         3613776.msg36570772                               2018-05-16 21:44:07.000       Member
iasenko                       1291828   hoanghai101296                1575909   1         3502978.msg36182697                               2018-06-04 06:04:38.000       Member
iasenko                       1291828   Coolcryptovator               1980983   1         4407646.msg39226575                               2018-06-06 21:01:13.000       Member
iasenko                       1291828   Heisenberg_Hunter             1564795   1         2968050.msg40114238                               2018-06-16 09:06:06.000       Full Member
iasenko                       1291828   StevenMosher                  987609    1         3375954.msg36260885                               2018-08-07 23:04:58.000       Member
iasenko                       1291828   napsterz                      1895068   1         4556338.msg41093161                               2018-08-08 08:59:17.000       Member
iasenko                       1291828   Ayanamirs                     1215309   1         3957640.msg37715099                               2018-08-08 09:14:29.000       Member
iasenko                       1291828   monsterer2                    1042068   1         3125137.msg32740896                               2018-08-08 09:16:02.000       Full Member
iasenko                       1291828   jenia2                        2247462   1         4872924.msg43898564                               2018-08-11 18:45:13.000       Jr. Member
iasenko                       1291828   mdayonliner                   1432468   3         4884870.msg44003115                               2018-08-13 13:41:11.000       Sr. Member
iasenko                       1291828   bluebits                      881359    1         178336.msg41178158                                2018-09-11 08:16:56.000       Member
iasenko                       1291828   JetAid                        2386998   1         5028318.msg45647117                               2018-09-13 21:06:34.000       Jr. Member
iasenko                       1291828   Shermand100                   938297    1         5030085.msg45786270                               2018-09-16 16:36:52.000       Jr. Member
iasenko                       1291828   YOSHIE                        2363935   1         5042074.msg46417391                               2018-10-02 12:19:17.000       Member
iasenko                       1291828   khatarnak                     2300286   1         5041590.msg46412430                               2018-10-02 13:29:42.000       Jr. Member
iasenko                       1291828   coin-boss                     1930555   1         4937275.msg46915532                               2018-10-16 09:55:56.000       Jr. Member
iasenko                       1291828   Summation                     1334663   1         5072677.msg48092438                               2018-11-21 19:44:06.000       Member
iasenko                       1291828   RinkaDink                     2477984   1         5073079.msg48095864                               2018-11-21 23:36:10.000       Jr. Member
iasenko                       1291828   AverageGlabella               392646    1         5067090.msg47790947                               2018-11-22 20:21:21.000       Sr. Member
iasenko                       1291828   FatBen                        2523202   1         5095468.msg49154463                               2019-01-10 22:00:30.000       Jr. Member
iasenko                       1291828   Kavelj22                      2443746   1         5121257.msg50196173                               2019-04-11 12:03:14.000       Full Member
iasenko                       1291828   tbct_mt2                      1096237   1         5125435.msg50347145                               2019-04-25 14:12:36.000       Sr. Member
iasenko                       1291828   WhyFhy                        1122459   1         5174282.msg52121464                               2019-08-15 09:15:26.000       Full Member

Edit 2: Has to remove 3 cases that received their first merit from @Iasenko, but made it further before the 17/09/2019 (thus the Jr. Member rank did not require merits at that time).

I'll try to keep at it on the Weekend if I can (may not). If anyone wants to overtake, please do.
The above barely checked list of those ranked-up by @Iasenko. The format can be expanded, and I have all the data calculated, but I need to review it properly and think of the outputs.
In process: check Jr. and Legendary.

Notes:
- I’ve taken into consideration that a merit TX may have ranked someone twice (i.e. Jr. member + member if awarded 10 sMerits).
- I’ve considered all in-between rank-up steps.
- The listed data relates to the TX that caused the ranking-up, although technically it may not have at the time. For example, if the user did not have enough activity at the time (but does now). I cannot backtrack activity.
- This is extremely Beta now. I’ve posted the above so as to have a debug set that perhaps @Iasenko can verify to some degree.
- This may backfire and need to be deleted ...

dkbit98

legendary

Activity: 2212

Merit: 7064

source: https://public.tableau.com/profile/ddmrddmr#!/vizhome/BitcointalkMeritDashboard/GlobalSummary

1. DdmrDdmr
2. vlad230
3. xtraelv
4. o_e_l_e_o
5. krogothmanhattan
...

PS
There is more data, but I hope this can help a bit someone who is better than me Wink

khaled0111

legendary

Activity: 2744

Merit: 3097

Top Crypto Casino

Quote from: LoyceMobile on August 16, 2019, 01:53:58 PM

Do you also want to know the Newbies you turned into Jr. Member?

Then, to you (or to DdmrDdmr), it wouldn't be considered as a challenge. Tongue

Quote from: TheBeardedBaby on August 16, 2019, 12:44:44 PM

I need a list with all the users I've sent the last needed merit to rank up.

It will be great to tell someone you've been iasenkoed Tongue

Sorry guys, I couldn't stop myself.

DdmrDdmr

legendary

Activity: 2338

Merit: 10802

There are lies, damned lies and statistics. MTwain

I think it would be nice for someone “newish” to do it, although it requires to either keep a cumulative DB and or integrate a full TX file from those available sources (to begin with .. plus other stuff). Any volunteers?

One of the slight issues is the asynchronism between the merit TX file generation, and the profile scrape (in order to derive the initial starting point). For example, a person may be merited between the TX file and the profile scrape, and cause some to be marked with a wrong initial rank (it is not that likely in the big picture, but it does happen).

There’s also the question if we want to know who ranked who through each step (i.e. when a user reached Jr. Member, but also when the same user got to Member and so forth), or just to the current rank.

LoyceMobile

hero member

Activity: 1659

Merit: 687

LoyceV on the road. Or couch.

I can do this, but then I can just as well do it for all users. And since I didn't keep track of airdropped merit amounts, I'll have to scrape all profiles.

I have more urgent things to do though, so if nobody does it I'll do it at a (much) later time.

Do you also want to know the Newbies you turned into Jr. Member?

Welsh

staff

Activity: 3304

Merit: 4115

In addition to this it would be nice to see the top amount of users who have given that last bit of merit to rank someone up. I'm not sure the amount of work which would be required for this so shall we say a top 10?

Lafu

legendary

Activity: 3178

Merit: 3295

Guess if you ask LoyceV or DdmrDdmr would be best and fastest solution to get your stats for that !
Maybe some others too if they have the time for .

TheBeardedBaby

legendary

Activity: 2240

Merit: 3150

₿uy / $ell ..oeleo ;(

I need a list with all the users I've sent the last needed merit to rank up.
Let's see who's gonna come first with the solution.

I suppose I helped around 15-20 people to rank up till now but maybe I'm wrong,let's see.

Topic: To all the statistics guys out there, here's a challenge. (Read 334 times)