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

[TheBeardedBaby]

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.

[Lafu]

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 .

[Welsh]

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?

[LoyceMobile]

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?

[DdmrDdmr]

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.

[khaled0111]

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.  

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  

Sorry guys, I couldn't stop myself.

[dkbit98]

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

[DdmrDdmr]

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 ...

[TheBeardedBaby]

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 (29):

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   mikeey89                      1354773   1         2843677.msg29170807                               2018-01-29 17:40:40.000       Jr. Member
iasenko                       1291828   ducdr                         1254889   1         2873832.msg29536389                               2018-02-06 18:28:45.000       Member
iasenko                       1291828   hd49728                       1520746   1         2900651.msg29838182                               2018-02-08 07:41:12.000       Jr. Member
iasenko                       1291828   tbalazs                       1210838   1         2990880.msg30749800                               2018-02-21 11:05:01.000       Jr. Member
iasenko                       1291828   dimplit                       1795327   1         3102907.msg32036677                               2018-03-24 06:35:16.000       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   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   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

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 ...

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.

[khaled0111]

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?

[DdmrDdmr]

<…> 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.

<...>

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:

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

[hd49728]

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

[TheBeardedBaby]

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?

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://bitcointalk.org/index.php?topic=3108981.msg32121418#msg32121418